Column | Type | Contents |
county_id |
Text string (max.len.=14). |
The identifier of the county from the DIHS project.
|
year |
Integer number. |
Year in which the data were gathered.
The farm census has always been carried out in June.
|
transcriber |
Text string (max.len.=14). |
Value identifying who did the transcription (see notes above).
|
source_tab |
Text string (max.len.=34). |
Tab from which the data were loaded.
Further manual commands must be added to identify the actual tables.
|
report_table |
Text string (max.len.=24). |
Identifier for the table within the report.
This is a string, not a number, such as
'Table 2'. Where the information comes from mulitple
tables, e.g. where the national totals are in a
different table the table number is given for the table
containing the county data as far as possible.
|
col_or_row |
Integer number. |
Column or row occupied by the value in the original
table, i.e. the location of the variable
in the original report. NB Some tables used different
columns for each county, in which case this DB field
will hold a row number.
Many tables also included values for the previous
year, but these have been ignored when computing these
column/row numbers.
(NB the reason why Scottish data for 1870 and 1884 are
included in this table is that they were listed in the
tables for the following year and included in the OCR
output.)
|
report_label |
Text string (max.len.=144). |
The label for the variable as listed in the original report.
NB this is not the version supplied by the
original transcriber, but text added by the GBHGIS after
careful checking against the original reports.
|
transcribe_label |
Text string (max.len.=194). |
The label for the variable as transcribed.
|
original_label |
Text string (max.len.=194). |
[No description available]
|
hold_size |
Text string (max.len.=194). |
The size of the holding, only applies for twentieth century data.
|
meas_unit |
Text string (max.len.=16). |
The units in which the variable is measured.
For now, the only value is 'Acres'.
|
value |
Floating point number. |
The numerical value of the variable for the relevant county and year.
|
row_type |
Text string (max.len.=12). |
Abbreviation indicating type of unit.
|
g_unit |
Floating point number. |
ID number for reporting unit, as defined in the AUO.
|
g_unit_type |
Text string (max.len.=28). |
Type of the unit, as defined in the AUO.
|
g_name |
Text string (max.len.=104). |
Official preferred name for the reporting unit, as defined in the AUO.
|
nation |
Text string (max.len.=8). |
Nation identifier to help distinguish units. 'I' for all units before 1922,
'NI' for Northern Ireland and 'RoI' for the Republic of Ireland after that.
|
cellref |
Text string (max.len.=52). |
Cell reference identifying what the particular data value
measures, as used in the GBH GIS Data Documentation system.
These are set using the agcen_variables table and
based ona standardised version of report_label, but also reflect
the particular year the label appears in.
|
g_data_status |
Text string (max.len.=6). |
Used as in the main data table:
everything loaded in from the GBHGIS transcriptions is
labelled as 'P' for public,
everything loaded in from the DIHS transcriptions is
labelled as 'C' for confidential,
while the additional values computed by
the script which builds the table have status 'D'
for derived.
|
rec_num |
Integer number. |
Sequence number added as the data are loaded, to keep them in order.
|