SN: 1316 - 1851 Census of Great Britain 2 Percent Sample.
	

All of the data files for the 1851 are in ASCII format with commas delimiting 
the individual fields. Note also that all values are surrounded by double quote marks. 
Some database systems need these indicators as they are unable to easily 
distinguish between a comma as a seperator, and a comma as part of a 
record entry. You should have no problem with this format if using a 
modern database system, but this renders all data as type TEXT. It is
of course possible to change the data type of certain variables where
necessary.

	 The following constitutes the table structure for the files. You may 
need to create a template that represents this structure if you are importing
the ASCII into your system. It may be best to start with, for you to assign 
each field as an alphanumeric (text) data type with a field length of 255
characters or so. This should ensure that everything ports across without any 
errors. Here is the variable list; please consult the User Guide for a 
complete definition of these variables. This dataset represents the PDF1 
format (Public Data File 1). 

Field Name              Field Length (not absolute)
---------------------------------------------------

CLUSCODE                5
NUMOFIND                3
NEWHSIND                4
SCHEDNUM                6 (doc says 66!)
NEIGHINF                78
PLACERES                78
ADDRRESD                78
OTHERINF                78
DITTO1                  78
DITTO2                  78
DITTO3                  78
DITTO4                  78
CLUSLOCN                78
CNTYCLUS                78
GRIDCLUS                8
GRIDCODE                1
CNTCLCOD                3
PLCTCODE                2
SEQOFIND                2
PRENAME                 76
SURNAME                 78
RELTOHED                53
MARRSTAT                25
AGEIFMAL                7
AGEIFFEM                7
CNTYBRTH                64
OCCUNAME                78
DITTOA                  78
DITTOB                  78
CTRYBRTH                78
COMMBRTH                40
DISABLED                38
RELNCODE                4+1
MARRCODE                2+1
CNTYCODE                3+1
CTRYCODE                4+1
COMMCODE                8+1
OCCUCODE                59


	

		Do not use the suggested lengths if you find that certain 
fields do not import properly. Always give plenty of room. The last six 
fields contain coded data. However, some of the fields are left blank and 
should be ignored. For example, although the variable OCCUCODE (code for 
occupations) exists, only a small sample of these data is in fact coded, the
rest are blank.

		The file names correspond to the location/cluster codes, 
and that code is also given in the CLUSCODE field.Therefore, 

f0601.txt relates to cluster 0601 which is LONDON : KENSINGTON TOWN.

f3153.txt relates to cluster 3153 which is CHELTENHAM.