Copy of the Vision of Britain download log prior to 2016 rebuild.

Table ID:
DOWNLOAD_LOG_2015     (1247501)
Contents:
Copy of the Vision of Britain download log prior to 2016 rebuild.
Approx. number of rows:
31,368
Table type:
Raw Data
Documentation Author:
Humphrey Southall

Sources:

  1. This table has been generated over time by the Vision of Britain download sub-system. This copy has been created as a permanent archive, covering 31,368 downloads.


Notes:

  1. Although this copy was made in February 2016, it came from the version on our development server, and is therefore really a snapshot of downloads made up to the point where a copy of the database was transferred from the old production server to the new development box in July 2015.


Indices:

IndexTypeColumn(s) indexed
download_log_2015_pkey Primary key seq_num


Constraints:

The table has the following associated constraints:

ConstraintTypeDetails
download_log_2015_pkey Primary Key See details above for primary key index



Columns within table:

ColumnTypeContents
seq_num Integer number. Automatically generated sequence number, keeping downloads in the order they occurred.
download_date Text string (max.len.=259). Date of download, automatically recorded by the system.
download_type Text string (max.len.=259). Type of downloaded content, the values and current counts being:
  • Map (26,082 downloads)
  • Statistics by location (1,112 downloads)
  • Statistics by ncube (1,590 downloads)
  • Boundaries (2,431 downloads)
  • Statistics (153 downloads)
download_name Text string (max.len.=259). Name of the file downloaded. For statistics they are automatically generated (for example, gbhgis_statistics_1361754912575.zip), but for maps and boundary data the file name precisely identifies the content.
download_user Text string (max.len.=259). Type of user, as selected by the user from our drop-down menu. The four most common are:
  • Local History / Family History -- Personal research (20,712 downloads)
  • Higher Education -- Staff (2,105)
  • Higher Education -- Postgraduate (1,936)
  • Higher Education -- Undergraduate (1,170)
download_subject Text string (max.len.=259). Academic subject of the user, as selected by the user from our drop-down menu. The most common are:
  • History (11,192)
  • Not school or university work (10,368)
  • Geography (3,566)
  • Other arts and humanities (1,388)
  • Other social science (1,323)
download_usage Text string (max.len.=259). What our content will be used for, as selected by the user from our drop-down menu. The most common are:
  • Personal interest -- no publication plans (21,577)
  • University or college project (4,421)
  • Non-commercial local history publication / web site (2,550)
  • School project (1,309)
  • Report written for employer / client (901)
  • Commercial publication (411)
result_size Integer number. For statistical downloads, this is a count of the number of data values. For other downloads it is always zero.
parameter_set Long text. The various parameters set when downloading a statistical data set, held as a text string. Two examples are:
  • "1961, 2011, 10276275 N_AREA_ACRES, 10276275 N_GENDER, 10276275 N_POP_CHANGE, 10276275 N_TOT_POP"
  • "1801, 2011, 10056627 N_REL2001"