Importing UK 2001 Census Data into SQL Server

  • I know this seems a bit lazy but does anyone know of any tools/scripts/DTS packages for loading the 2001 Census .CSV's into SQL server. Whilst I almost certainly can with my meager knowledge of DTS and VB work out all of the problems it would seem a bit of a waste if someone had already done it.


    Details of the probelm are:

    CSV Specification:

    The Output Files

    All the output files are in a comma separated formatted (CSV) as described in this document. The census bulk format contains three file types (N.B an extract may produce more than three files as described in the CSV Format section):

    • Table description file

        This file will contain text that describes the table.
    • Textual description file
        This file contains the textual descriptions of the cells.

    • Data file.
        This file holds the data values in row major order.

     

    The case of the text in outout files will be displayed as it appears in SuperCROSS. The extract process will however clean the text by removing carriage returns, line feeds, double spaces, leading white space and trailing white space. The cleaning of text will also replace any double quotes with single quotes as the text will be delimited as described below.

    The CSV Format

    • Each new line in the CSV file will be given using the carriage return character (ASCII code 13) followed by the line feed character (ASCII code 10).
    • Each line in a given CSV file will contain the same number of fields separated by a comma.
    • All text fields will be delimited using double quotes.
    • There will be a maximum number of 250 fields per CSV file. Should a census extract file require more than 250 fields the naming convention for multiple files described in this document will be adopted.

    File Naming

    All files produced as a result of the extract process will carry the extension .CSV to indicate it's contents are in comma separated form as described in this document. The filename will be created as shown below.

    • The first two characters will indicate the table type:

      ST - Standard Tables

      TH - Theme Tables

     

  • The following three characters will be numerics and indicate the table number.

  • The next four characters will indicate the type of file:
    • DESC - Table Description File

      META - Textual Description File

      DATA - Data File

  • If an extract file contains more than 250 fields then the file will be split. The next character indicates if the file is split and if so gives its sequence position.

      0 - No split

      A - 1st file in split

      B - 2nd file in split

      C - 3rd file in split

      And so on in alphabetic order.

  • The next character applies to DATA files only and is used to indicate the geography level of the counts it contains. In this product, tables for administrative areas in England and Wales are split into a number of files and the areas contained within them are identified as follows:

      1 - England and Wales.

      2 - England, Wales.

      3 - Government Office Regions.

      4 - Counties, Unitary Authorities.

      5 - Local Authority Districts.

      6 - Wards

    The example file name:

    ST003DATA01.CSV

    would therefore hold all the values for Standard Table 3 for England and Wales combined.

  • For tables produced for Wales only the geography File split is different to that of other tables, as follows:

      1 - Wales.

      2 - Unitary Authorities.

      4 - Communities.

    Textual Description File (META)

    This file contains four fields, the table code, table title, table population and finally footnotes. N.B. This file will only contain 1 record. The table code is given by a two character table type followed by a three digit table number.

    Example output:

    “ST001”,“Table ST0001 AGE BY SEX AND TYPE OF RESIDENT”,“ALL PEOPLE”,“The contents of this table are fictitious and bear no relation to actual populations”<CR><LF>

    <CR><LF> indicates a carriage return and line feed character combination.

    Table Description File (DESC)

    This file will contain 2 fields, a unique cell code followed by its textual description. This file will contain a record for every cell in a census table.

    N.B. The cell code is made up of the table code as described above plus a four digit cell number.

    Example output:

    “ST0010001”,“Males, 0 - 15”<CR><LF>

    “ST0010002”,“Males, 16 - 30”<CR><LF>

    <CR><LF> indicates a carriage return and line feed character combination.

    Data File (DATA)

    The number of fields present in this file is dependent on the number of cells in a census table. If however the number of fields exceeds 250 then the file will be split as detailed above. The CSV file will contain a geography code as the first field and then cell values running sequentially for that geography.

    The data file will contain a header record to label each field.

    Example output for files with sequence code 0 or A for Standard Table 1:

    “GeographyCode”,“ST0010001”,“ST0010002”, etc

    “MA”,2345,45.90,6784, etc

    Example output for files with sequence code B or more for census area table 1:

    “GeographyCode”,“ST0010250”,“ST0010251”,“ST0010252”,“ST0010253”, etc

    “MA”,4567,8902,234,56.89, etc

  •  

    Example File:

    ST008DATAAF1.CSV

    GeographyCode,ST0081250,ST0081251,ST0081252,ST0081253,ST0081254,ST0081255,ST0081256,ST0081257,ST0081258,ST0081259,ST0081260,ST0081261,ST0081262,ST0081263,ST0081264,ST0081265,ST0081266,ST0081267,ST0081268,ST0081269,ST0081270,ST0081271,ST0081272,ST0081273,ST0081274,ST0081275,ST0081276,ST0081277,ST0081278,ST0081279,ST0081280,ST0081281,ST0081282,ST0081283,ST0081284,ST0081285,ST0081286,ST0081287,ST0081288,ST0081289,ST0081290,ST0081291,ST0081292,ST0081293,ST0081294,ST0081295,ST0081296

    727,10,5,11772,4142,117,0,12,44,-1,19,-7,24376,9593,327,0,25,35,-1,32,-7,40112,15829,544,0,56,47,-1,59,-3,57027,20899,706,0,50,46,-1,45,5,67836,19827,680,0,55,44,-1,60,-5

    64,10,-3,11052,3877,110,19,12,42,17,18,-4,22849,8964,310,42,23,35,30,31,4,37629,14808,507,76,52,43,53,57,18,53570,19614,663,91,49,45,71,42,27,63819,18598,637,104,51,41,72,58,25

    220,0,8,720,229,7,17,0,3,19,1,-3,1527,557,17,30,3,0,42,1,-10,2483,892,37,53,4,4,76,2,-21,3457,1123,43,71,0,3,91,3,-23,4017,1053,43,72,4,3,104,2,-30

    A,2,-2,784,278,3,5,3,3,8,1,-1,1504,534,12,22,3,0,13,3,9,2365,860,27,34,4,0,31,2,5,2940,917,25,47,7,3,39,2,13,3115,821,28,29,6,3,50,3,-18

    B,1,-1,1793,587,15,43,3,3,37,2,7,3911,1294,48,51,4,3,80,7,-32,6068,2012,71,96,17,5,119,7,-13,8222,2566,80,126,15,5,192,7,-58,9400,2310,87,113,8,6,144,2,-25

    D,2,-4,1187,383,16,25,0,0,22,0,3,2569,916,30,56,3,5,56,2,1,4184,1552,51,91,0,4,82,7,2,5956,1935,66,114,4,0,137,2,-21,6964,1819,53,112,6,0,107,6,5

    E,1,5,883,292,7,39,0,3,30,4,5,1972,779,29,89,3,3,67,1,24,3282,1219,36,150,9,3,87,5,67,4695,1581,58,205,7,0,114,5,93,5528,1402,45,190,9,3,116,6,77

    F,2,0,1118,394,9,38,0,3,32,1,5,2341,886,30,72,0,0,53,4,15,3901,1420,49,145,4,0,111,2,36,5110,1745,60,177,0,0,142,7,28,5746,1606,70,151,4,0,120,7,28

    G,0,-3,1006,339,16,45,0,3,46,0,-1,2185,844,31,111,4,3,93,0,22,3691,1329,65,233,0,6,129,6,98,5293,1884,69,308,0,6,202,2,104,6431,1790,82,277,6,4,177,6,100

    H,1,-26,1189,317,8,38,0,6,85,5,-52,2075,659,29,81,0,7,154,5,-78,3044,1005,62,112,3,5,318,9,-212,4344,1406,81,165,0,7,452,5,-292,5087,1389,82,147,3,4,445,7,-302

    J,1,18,1812,564,21,66,0,12,61,5,0,3668,1323,59,166,0,9,148,7,11,6356,2385,84,292,6,7,238,8,52,9829,3347,131,426,5,12,318,5,108,12419,3456,104,393,6,11,286,4,109

    K,0,8,1280,390,15,53,0,9,29,3,21,2624,1010,42,113,5,5,85,5,28,4738,1799,62,150,7,11,165,11,-19,7181,2506,93,250,7,10,202,7,48,9129,2462,86,235,3,7,170,11,57

    ST008DESC0.CSV

    "ST0080001","ALL PEOPLE IN HOUSEHOLDS, Lived at same address"

    "ST0080002","ALL PEOPLE IN HOUSEHOLDS, Lived elsewhere one year ago within same area"

    "ST0080003","ALL PEOPLE IN HOUSEHOLDS, No usual address one year ago"

    "ST0080004","ALL PEOPLE IN HOUSEHOLDS, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080005","ALL PEOPLE IN HOUSEHOLDS, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080006","ALL PEOPLE IN HOUSEHOLDS, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080007","ALL PEOPLE IN HOUSEHOLDS, Outflow: Moved out of area but within 'associated area'"

    "ST0080008","ALL PEOPLE IN HOUSEHOLDS, Outflow: Moved out of area but within UK"

    "ST0080009","ALL PEOPLE IN HOUSEHOLDS, Net migration within the UK"

    "ST0080010","Under 1, Lived at same address"

    "ST0080011","Under 1, Lived elsewhere one year ago within same area"

    "ST0080012","Under 1, No usual address one year ago"

    "ST0080013","Under 1, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080014","Under 1, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080015","Under 1, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080016","Under 1, Outflow: Moved out of area but within 'associated area'"

    "ST0080017","Under 1, Outflow: Moved out of area but within UK"

    "ST0080018","Under 1, Net migration within the UK"

    "ST0080019","1 to 3, Lived at same address"

    "ST0080020","1 to 3, Lived elsewhere one year ago within same area"

    "ST0080021","1 to 3, No usual address one year ago"

    "ST0080022","1 to 3, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080023","1 to 3, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080024","1 to 3, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080025","1 to 3, Outflow: Moved out of area but within 'associated area'"

    "ST0080026","1 to 3, Outflow: Moved out of area but within UK"

    "ST0080027","1 to 3, Net migration within the UK"

    "ST0080028","4, Lived at same address"

    "ST0080029","4, Lived elsewhere one year ago within same area"

    "ST0080030","4, No usual address one year ago"

    "ST0080031","4, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080032","4, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080033","4, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080034","4, Outflow: Moved out of area but within 'associated area'"

    "ST0080035","4, Outflow: Moved out of area but within UK"

    "ST0080036","4, Net migration within the UK"

    "ST0080037","5 to 9, Lived at same address"

    "ST0080038","5 to 9, Lived elsewhere one year ago within same area"

    "ST0080039","5 to 9, No usual address one year ago"

    "ST0080040","5 to 9, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080041","5 to 9, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080042","5 to 9, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080043","5 to 9, Outflow: Moved out of area but within 'associated area'"

    "ST0080044","5 to 9, Outflow: Moved out of area but within UK"

    "ST0080045","5 to 9, Net migration within the UK"

    "ST0080046","10 to 14, Lived at same address"

    "ST0080047","10 to 14, Lived elsewhere one year ago within same area"

    "ST0080048","10 to 14, No usual address one year ago"

    "ST0080049","10 to 14, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080050","10 to 14, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080051","10 to 14, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080052","10 to 14, Outflow: Moved out of area but within 'associated area'"

    "ST0080053","10 to 14, Outflow: Moved out of area but within UK"

    "ST0080054","10 to 14, Net migration within the UK"

    "ST0080055","15, Lived at same address"

    "ST0080056","15, Lived elsewhere one year ago within same area"

    "ST0080057","15, No usual address one year ago"

    "ST0080058","15, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080059","15, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080060","15, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080061","15, Outflow: Moved out of area but within 'associated area'"

    "ST0080062","15, Outflow: Moved out of area but within UK"

    "ST0080063","15, Net migration within the UK"

    "ST0080064","16 to 17, Lived at same address"

    "ST0080065","16 to 17, Lived elsewhere one year ago within same area"

    "ST0080066","16 to 17, No usual address one year ago"

    "ST0080067","16 to 17, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080068","16 to 17, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080069","16 to 17, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080070","16 to 17, Outflow: Moved out of area but within 'associated area'"

    "ST0080071","16 to 17, Outflow: Moved out of area but within UK"

    "ST0080072","16 to 17, Net migration within the UK"

    "ST0080073","18 to 19, Lived at same address"

    "ST0080074","18 to 19, Lived elsewhere one year ago within same area"

    "ST0080075","18 to 19, No usual address one year ago"

    "ST0080076","18 to 19, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080077","18 to 19, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080078","18 to 19, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080079","18 to 19, Outflow: Moved out of area but within 'associated area'"

    "ST0080080","18 to 19, Outflow: Moved out of area but within UK"

    "ST0080081","18 to 19, Net migration within the UK"

    "ST0080082","20 to 24, Lived at same address"

    "ST0080083","20 to 24, Lived elsewhere one year ago within same area"

    "ST0080084","20 to 24, No usual address one year ago"

    "ST0080085","20 to 24, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080086","20 to 24, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080087","20 to 24, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080088","20 to 24, Outflow: Moved out of area but within 'associated area'"

    "ST0080089","20 to 24, Outflow: Moved out of area but within UK"

    "ST0080090","20 to 24, Net migration within the UK"

    "ST0080091","25 to 29, Lived at same address"

    "ST0080092","25 to 29, Lived elsewhere one year ago within same area"

    "ST0080093","25 to 29, No usual address one year ago"

    "ST0080094","25 to 29, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080095","25 to 29, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080096","25 to 29, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080097","25 to 29, Outflow: Moved out of area but within 'associated area'"

    "ST0080098","25 to 29, Outflow: Moved out of area but within UK"

    "ST0080099","25 to 29, Net migration within the UK"

    "ST0080100","30 to 34, Lived at same address"

    "ST0080101","30 to 34, Lived elsewhere one year ago within same area"

    "ST0080102","30 to 34, No usual address one year ago"

    "ST0080103","30 to 34, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080104","30 to 34, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080105","30 to 34, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080106","30 to 34, Outflow: Moved out of area but within 'associated area'"

    "ST0080107","30 to 34, Outflow: Moved out of area but within UK"

    "ST0080108","30 to 34, Net migration within the UK"

    "ST0080109","35 to 39, Lived at same address"

    "ST0080110","35 to 39, Lived elsewhere one year ago within same area"

    "ST0080111","35 to 39, No usual address one year ago"

    "ST0080112","35 to 39, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080113","35 to 39, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080114","35 to 39, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080115","35 to 39, Outflow: Moved out of area but within 'associated area'"

    "ST0080116","35 to 39, Outflow: Moved out of area but within UK"

    "ST0080117","35 to 39, Net migration within the UK"

    "ST0080118","40 to 44, Lived at same address"

    "ST0080119","40 to 44, Lived elsewhere one year ago within same area"

    "ST0080120","40 to 44, No usual address one year ago"

    "ST0080121","40 to 44, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080122","40 to 44, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080123","40 to 44, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080124","40 to 44, Outflow: Moved out of area but within 'associated area'"

    "ST0080125","40 to 44, Outflow: Moved out of area but within UK"

    "ST0080126","40 to 44, Net migration within the UK"

    "ST0080127","45 to 49, Lived at same address"

    "ST0080128","45 to 49, Lived elsewhere one year ago within same area"

    "ST0080129","45 to 49, No usual address one year ago"

    "ST0080130","45 to 49, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080131","45 to 49, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080132","45 to 49, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080133","45 to 49, Outflow: Moved out of area but within 'associated area'"

    "ST0080134","45 to 49, Outflow: Moved out of area but within UK"

    "ST0080135","45 to 49, Net migration within the UK"

    "ST0080136","50 to 54, Lived at same address"

    "ST0080137","50 to 54, Lived elsewhere one year ago within same area"

    "ST0080138","50 to 54, No usual address one year ago"

    "ST0080139","50 to 54, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080140","50 to 54, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080141","50 to 54, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080142","50 to 54, Outflow: Moved out of area but within 'associated area'"

    "ST0080143","50 to 54, Outflow: Moved out of area but within UK"

    "ST0080144","50 to 54, Net migration within the UK"

    "ST0080145","55 to 59, Lived at same address"

    "ST0080146","55 to 59, Lived elsewhere one year ago within same area"

    "ST0080147","55 to 59, No usual address one year ago"

    "ST0080148","55 to 59, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080149","55 to 59, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080150","55 to 59, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080151","55 to 59, Outflow: Moved out of area but within 'associated area'"

    "ST0080152","55 to 59, Outflow: Moved out of area but within UK"

    "ST0080153","55 to 59, Net migration within the UK"

    "ST0080154","60 to 64, Lived at same address"

    "ST0080155","60 to 64, Lived elsewhere one year ago within same area"

    "ST0080156","60 to 64, No usual address one year ago"

    "ST0080157","60 to 64, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080158","60 to 64, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080159","60 to 64, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080160","60 to 64, Outflow: Moved out of area but within 'associated area'"

    "ST0080161","60 to 64, Outflow: Moved out of area but within UK"

    "ST0080162","60 to 64, Net migration within the UK"

    "ST0080163","65 to 69, Lived at same address"

    "ST0080164","65 to 69, Lived elsewhere one year ago within same area"

    "ST0080165","65 to 69, No usual address one year ago"

    "ST0080166","65 to 69, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080167","65 to 69, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080168","65 to 69, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080169","65 to 69, Outflow: Moved out of area but within 'associated area'"

    "ST0080170","65 to 69, Outflow: Moved out of area but within UK"

    "ST0080171","65 to 69, Net migration within the UK"

    "ST0080172","70 to 74, Lived at same address"

    "ST0080173","70 to 74, Lived elsewhere one year ago within same area"

    "ST0080174","70 to 74, No usual address one year ago"

    "ST0080175","70 to 74, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080176","70 to 74, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080177","70 to 74, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080178","70 to 74, Outflow: Moved out of area but within 'associated area'"

    "ST0080179","70 to 74, Outflow: Moved out of area but within UK"

    "ST0080180","70 to 74, Net migration within the UK"

    "ST0080181","75 to 79, Lived at same address"

    "ST0080182","75 to 79, Lived elsewhere one year ago within same area"

    "ST0080183","75 to 79, No usual address one year ago"

    "ST0080184","75 to 79, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080185","75 to 79, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080186","75 to 79, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080187","75 to 79, Outflow: Moved out of area but within 'associated area'"

    "ST0080188","75 to 79, Outflow: Moved out of area but within UK"

    "ST0080189","75 to 79, Net migration within the UK"

    "ST0080190","80 to 84, Lived at same address"

    "ST0080191","80 to 84, Lived elsewhere one year ago within same area"

    "ST0080192","80 to 84, No usual address one year ago"

    "ST0080193","80 to 84, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080194","80 to 84, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080195","80 to 84, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080196","80 to 84, Outflow: Moved out of area but within 'associated area'"

    "ST0080197","80 to 84, Outflow: Moved out of area but within UK"

    "ST0080198","80 to 84, Net migration within the UK"

    "ST0080199","85 to 89, Lived at same address"

    "ST0080200","85 to 89, Lived elsewhere one year ago within same area"

    "ST0080201","85 to 89, No usual address one year ago"

    "ST0080202","85 to 89, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080203","85 to 89, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080204","85 to 89, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080205","85 to 89, Outflow: Moved out of area but within 'associated area'"

    "ST0080206","85 to 89, Outflow: Moved out of area but within UK"

    "ST0080207","85 to 89, Net migration within the UK"

    "ST0080208","90 and over, Lived at same address"

    "ST0080209","90 and over, Lived elsewhere one year ago within same area"

    "ST0080210","90 and over, No usual address one year ago"

    "ST0080211","90 and over, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080212","90 and over, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080213","90 and over, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080214","90 and over, Outflow: Moved out of area but within 'associated area'"

    "ST0080215","90 and over, Outflow: Moved out of area but within UK"

    "ST0080216","90 and over, Net migration within the UK"

    "ST0080217","Males, Lived at same address"

    "ST0080218","Males, Lived elsewhere one year ago within same area"

    "ST0080219","Males, No usual address one year ago"

    "ST0080220","Males, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080221","Males, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080222","Males, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080223","Males, Outflow: Moved out of area but within 'associated area'"

    "ST0080224","Males, Outflow: Moved out of area but within UK"

    "ST0080225","Males, Net migration within the UK"

    "ST0080226","Under 1, Lived at same address"

    "ST0080227","Under 1, Lived elsewhere one year ago within same area"

    "ST0080228","Under 1, No usual address one year ago"

    "ST0080229","Under 1, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080230","Under 1, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080231","Under 1, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080232","Under 1, Outflow: Moved out of area but within 'associated area'"

    "ST0080233","Under 1, Outflow: Moved out of area but within UK"

    "ST0080234","Under 1, Net migration within the UK"

    "ST0080235","1 to 3, Lived at same address"

    "ST0080236","1 to 3, Lived elsewhere one year ago within same area"

    "ST0080237","1 to 3, No usual address one year ago"

    "ST0080238","1 to 3, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080239","1 to 3, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080240","1 to 3, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080241","1 to 3, Outflow: Moved out of area but within 'associated area'"

    "ST0080242","1 to 3, Outflow: Moved out of area but within UK"

    "ST0080243","1 to 3, Net migration within the UK"

    "ST0080244","4, Lived at same address"

    "ST0080245","4, Lived elsewhere one year ago within same area"

    "ST0080246","4, No usual address one year ago"

    "ST0080247","4, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080248","4, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080249","4, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080250","4, Outflow: Moved out of area but within 'associated area'"

    "ST0080251","4, Outflow: Moved out of area but within UK"

    "ST0080252","4, Net migration within the UK"

    "ST0080253","5 to 9, Lived at same address"

    "ST0080254","5 to 9, Lived elsewhere one year ago within same area"

    "ST0080255","5 to 9, No usual address one year ago"

    "ST0080256","5 to 9, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080257","5 to 9, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080258","5 to 9, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080259","5 to 9, Outflow: Moved out of area but within 'associated area'"

    "ST0080260","5 to 9, Outflow: Moved out of area but within UK"

    "ST0080261","5 to 9, Net migration within the UK"

    "ST0080262","10 to 14, Lived at same address"

    "ST0080263","10 to 14, Lived elsewhere one year ago within same area"

    "ST0080264","10 to 14, No usual address one year ago"

    "ST0080265","10 to 14, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080266","10 to 14, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080267","10 to 14, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080268","10 to 14, Outflow: Moved out of area but within 'associated area'"

    "ST0080269","10 to 14, Outflow: Moved out of area but within UK"

    "ST0080270","10 to 14, Net migration within the UK"

    "ST0080271","15, Lived at same address"

    "ST0080272","15, Lived elsewhere one year ago within same area"

    "ST0080273","15, No usual address one year ago"

    "ST0080274","15, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080275","15, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080276","15, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080277","15, Outflow: Moved out of area but within 'associated area'"

    "ST0080278","15, Outflow: Moved out of area but within UK"

    "ST0080279","15, Net migration within the UK"

    "ST0080280","16 to 17, Lived at same address"

    "ST0080281","16 to 17, Lived elsewhere one year ago within same area"

    "ST0080282","16 to 17, No usual address one year ago"

    "ST0080283","16 to 17, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080284","16 to 17, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080285","16 to 17, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080286","16 to 17, Outflow: Moved out of area but within 'associated area'"

    "ST0080287","16 to 17, Outflow: Moved out of area but within UK"

    "ST0080288","16 to 17, Net migration within the UK"

    "ST0080289","18 to 19, Lived at same address"

    "ST0080290","18 to 19, Lived elsewhere one year ago within same area"

    "ST0080291","18 to 19, No usual address one year ago"

    "ST0080292","18 to 19, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080293","18 to 19, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080294","18 to 19, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080295","18 to 19, Outflow: Moved out of area but within 'associated area'"

    "ST0080296","18 to 19, Outflow: Moved out of area but within UK"

    "ST0080297","18 to 19, Net migration within the UK"

    "ST0080298","20 to 24, Lived at same address"

    "ST0080299","20 to 24, Lived elsewhere one year ago within same area"

    "ST0080300","20 to 24, No usual address one year ago"

    "ST0080301","20 to 24, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080302","20 to 24, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080303","20 to 24, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080304","20 to 24, Outflow: Moved out of area but within 'associated area'"

    "ST0080305","20 to 24, Outflow: Moved out of area but within UK"

    "ST0080306","20 to 24, Net migration within the UK"

    "ST0080307","25 to 29, Lived at same address"

    "ST0080308","25 to 29, Lived elsewhere one year ago within same area"

    "ST0080309","25 to 29, No usual address one year ago"

    "ST0080310","25 to 29, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080311","25 to 29, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080312","25 to 29, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080313","25 to 29, Outflow: Moved out of area but within 'associated area'"

    "ST0080314","25 to 29, Outflow: Moved out of area but within UK"

    "ST0080315","25 to 29, Net migration within the UK"

    "ST0080316","30 to 34, Lived at same address"

    "ST0080317","30 to 34, Lived elsewhere one year ago within same area"

    "ST0080318","30 to 34, No usual address one year ago"

    "ST0080319","30 to 34, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080320","30 to 34, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080321","30 to 34, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080322","30 to 34, Outflow: Moved out of area but within 'associated area'"

    "ST0080323","30 to 34, Outflow: Moved out of area but within UK"

    "ST0080324","30 to 34, Net migration within the UK"

    "ST0080325","35 to 39, Lived at same address"

    "ST0080326","35 to 39, Lived elsewhere one year ago within same area"

    "ST0080327","35 to 39, No usual address one year ago"

    "ST0080328","35 to 39, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080329","35 to 39, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080330","35 to 39, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080331","35 to 39, Outflow: Moved out of area but within 'associated area'"

    "ST0080332","35 to 39, Outflow: Moved out of area but within UK"

    "ST0080333","35 to 39, Net migration within the UK"

    "ST0080334","40 to 44, Lived at same address"

    "ST0080335","40 to 44, Lived elsewhere one year ago within same area"

    "ST0080336","40 to 44, No usual address one year ago"

    "ST0080337","40 to 44, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080338","40 to 44, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080339","40 to 44, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080340","40 to 44, Outflow: Moved out of area but within 'associated area'"

    "ST0080341","40 to 44, Outflow: Moved out of area but within UK"

    "ST0080342","40 to 44, Net migration within the UK"

    "ST0080343","45 to 49, Lived at same address"

    "ST0080344","45 to 49, Lived elsewhere one year ago within same area"

    "ST0080345","45 to 49, No usual address one year ago"

    "ST0080346","45 to 49, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080347","45 to 49, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080348","45 to 49, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080349","45 to 49, Outflow: Moved out of area but within 'associated area'"

    "ST0080350","45 to 49, Outflow: Moved out of area but within UK"

    "ST0080351","45 to 49, Net migration within the UK"

    "ST0080352","50 to 54, Lived at same address"

    "ST0080353","50 to 54, Lived elsewhere one year ago within same area"

    "ST0080354","50 to 54, No usual address one year ago"

    "ST0080355","50 to 54, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080356","50 to 54, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080357","50 to 54, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080358","50 to 54, Outflow: Moved out of area but within 'associated area'"

    "ST0080359","50 to 54, Outflow: Moved out of area but within UK"

    "ST0080360","50 to 54, Net migration within the UK"

    "ST0080361","55 to 59, Lived at same address"

    "ST0080362","55 to 59, Lived elsewhere one year ago within same area"

    "ST0080363","55 to 59, No usual address one year ago"

    "ST0080364","55 to 59, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080365","55 to 59, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080366","55 to 59, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080367","55 to 59, Outflow: Moved out of area but within 'associated area'"

    "ST0080368","55 to 59, Outflow: Moved out of area but within UK"

    "ST0080369","55 to 59, Net migration within the UK"

    "ST0080370","60 to 64, Lived at same address"

    "ST0080371","60 to 64, Lived elsewhere one year ago within same area"

    "ST0080372","60 to 64, No usual address one year ago"

    "ST0080373","60 to 64, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080374","60 to 64, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080375","60 to 64, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080376","60 to 64, Outflow: Moved out of area but within 'associated area'"

    "ST0080377","60 to 64, Outflow: Moved out of area but within UK"

    "ST0080378","60 to 64, Net migration within the UK"

    "ST0080379","65 to 69, Lived at same address"

    "ST0080380","65 to 69, Lived elsewhere one year ago within same area"

    "ST0080381","65 to 69, No usual address one year ago"

    "ST0080382","65 to 69, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080383","65 to 69, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080384","65 to 69, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080385","65 to 69, Outflow: Moved out of area but within 'associated area'"

    "ST0080386","65 to 69, Outflow: Moved out of area but within UK"

    "ST0080387","65 to 69, Net migration within the UK"

    "ST0080388","70 to 74, Lived at same address"

    "ST0080389","70 to 74, Lived elsewhere one year ago within same area"

    "ST0080390","70 to 74, No usual address one year ago"

    "ST0080391","70 to 74, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080392","70 to 74, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080393","70 to 74, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080394","70 to 74, Outflow: Moved out of area but within 'associated area'"

    "ST0080395","70 to 74, Outflow: Moved out of area but within UK"

    "ST0080396","70 to 74, Net migration within the UK"

    "ST0080397","75 to 79, Lived at same address"

    "ST0080398","75 to 79, Lived elsewhere one year ago within same area"

    "ST0080399","75 to 79, No usual address one year ago"

    "ST0080400","75 to 79, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080401","75 to 79, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080402","75 to 79, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080403","75 to 79, Outflow: Moved out of area but within 'associated area'"

    "ST0080404","75 to 79, Outflow: Moved out of area but within UK"

    "ST0080405","75 to 79, Net migration within the UK"

    "ST0080406","80 to 84, Lived at same address"

    "ST0080407","80 to 84, Lived elsewhere one year ago within same area"

    "ST0080408","80 to 84, No usual address one year ago"

    "ST0080409","80 to 84, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080410","80 to 84, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080411","80 to 84, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080412","80 to 84, Outflow: Moved out of area but within 'associated area'"

    "ST0080413","80 to 84, Outflow: Moved out of area but within UK"

    "ST0080414","80 to 84, Net migration within the UK"

    "ST0080415","85 to 89, Lived at same address"

    "ST0080416","85 to 89, Lived elsewhere one year ago within same area"

    "ST0080417","85 to 89, No usual address one year ago"

    "ST0080418","85 to 89, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080419","85 to 89, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080420","85 to 89, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080421","85 to 89, Outflow: Moved out of area but within 'associated area'"

    "ST0080422","85 to 89, Outflow: Moved out of area but within UK"

    "ST0080423","85 to 89, Net migration within the UK"

    "ST0080424","90 and over, Lived at same address"

    "ST0080425","90 and over, Lived elsewhere one year ago within same area"

    "ST0080426","90 and over, No usual address one year ago"

    "ST0080427","90 and over, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080428","90 and over, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080429","90 and over, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080430","90 and over, Outflow: Moved out of area but within 'associated area'"

    "ST0080431","90 and over, Outflow: Moved out of area but within UK"

    "ST0080432","90 and over, Net migration within the UK"

    "ST0080433","Females, Lived at same address"

    "ST0080434","Females, Lived elsewhere one year ago within same area"

    "ST0080435","Females, No usual address one year ago"

    "ST0080436","Females, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080437","Females, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080438","Females, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080439","Females, Outflow: Moved out of area but within 'associated area'"

    "ST0080440","Females, Outflow: Moved out of area but within UK"

    "ST0080441","Females, Net migration within the UK"

    "ST0080442","Under 1, Lived at same address"

    "ST0080443","Under 1, Lived elsewhere one year ago within same area"

    "ST0080444","Under 1, No usual address one year ago"

    "ST0080445","Under 1, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080446","Under 1, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080447","Under 1, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080448","Under 1, Outflow: Moved out of area but within 'associated area'"

    "ST0080449","Under 1, Outflow: Moved out of area but within UK"

    "ST0080450","Under 1, Net migration within the UK"

    "ST0080451","1 to 3, Lived at same address"

    "ST0080452","1 to 3, Lived elsewhere one year ago within same area"

    "ST0080453","1 to 3, No usual address one year ago"

    "ST0080454","1 to 3, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080455","1 to 3, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080456","1 to 3, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080457","1 to 3, Outflow: Moved out of area but within 'associated area'"

    "ST0080458","1 to 3, Outflow: Moved out of area but within UK"

    "ST0080459","1 to 3, Net migration within the UK"

    "ST0080460","4, Lived at same address"

    "ST0080461","4, Lived elsewhere one year ago within same area"

    "ST0080462","4, No usual address one year ago"

    "ST0080463","4, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080464","4, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080465","4, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080466","4, Outflow: Moved out of area but within 'associated area'"

    "ST0080467","4, Outflow: Moved out of area but within UK"

    "ST0080468","4, Net migration within the UK"

    "ST0080469","5 to 9, Lived at same address"

    "ST0080470","5 to 9, Lived elsewhere one year ago within same area"

    "ST0080471","5 to 9, No usual address one year ago"

    "ST0080472","5 to 9, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080473","5 to 9, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080474","5 to 9, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080475","5 to 9, Outflow: Moved out of area but within 'associated area'"

    "ST0080476","5 to 9, Outflow: Moved out of area but within UK"

    "ST0080477","5 to 9, Net migration within the UK"

    "ST0080478","10 to 14, Lived at same address"

    "ST0080479","10 to 14, Lived elsewhere one year ago within same area"

    "ST0080480","10 to 14, No usual address one year ago"

    "ST0080481","10 to 14, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080482","10 to 14, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080483","10 to 14, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080484","10 to 14, Outflow: Moved out of area but within 'associated area'"

    "ST0080485","10 to 14, Outflow: Moved out of area but within UK"

    "ST0080486","10 to 14, Net migration within the UK"

    "ST0080487","15, Lived at same address"

    "ST0080488","15, Lived elsewhere one year ago within same area"

    "ST0080489","15, No usual address one year ago"

    "ST0080490","15, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080491","15, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080492","15, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080493","15, Outflow: Moved out of area but within 'associated area'"

    "ST0080494","15, Outflow: Moved out of area but within UK"

    "ST0080495","15, Net migration within the UK"

    "ST0080496","16 to 17, Lived at same address"

    "ST0080497","16 to 17, Lived elsewhere one year ago within same area"

    "ST0080498","16 to 17, No usual address one year ago"

    "ST0080499","16 to 17, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080500","16 to 17, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080501","16 to 17, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080502","16 to 17, Outflow: Moved out of area but within 'associated area'"

    "ST0080503","16 to 17, Outflow: Moved out of area but within UK"

    "ST0080504","16 to 17, Net migration within the UK"

    "ST0080505","18 to 19, Lived at same address"

    "ST0080506","18 to 19, Lived elsewhere one year ago within same area"

    "ST0080507","18 to 19, No usual address one year ago"

    "ST0080508","18 to 19, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080509","18 to 19, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080510","18 to 19, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080511","18 to 19, Outflow: Moved out of area but within 'associated area'"

    "ST0080512","18 to 19, Outflow: Moved out of area but within UK"

    "ST0080513","18 to 19, Net migration within the UK"

    "ST0080514","20 to 24, Lived at same address"

    "ST0080515","20 to 24, Lived elsewhere one year ago within same area"

    "ST0080516","20 to 24, No usual address one year ago"

    "ST0080517","20 to 24, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080518","20 to 24, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080519","20 to 24, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080520","20 to 24, Outflow: Moved out of area but within 'associated area'"

    "ST0080521","20 to 24, Outflow: Moved out of area but within UK"

    "ST0080522","20 to 24, Net migration within the UK"

    "ST0080523","25 to 29, Lived at same address"

    "ST0080524","25 to 29, Lived elsewhere one year ago within same area"

    "ST0080525","25 to 29, No usual address one year ago"

    "ST0080526","25 to 29, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080527","25 to 29, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080528","25 to 29, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080529","25 to 29, Outflow: Moved out of area but within 'associated area'"

    "ST0080530","25 to 29, Outflow: Moved out of area but within UK"

    "ST0080531","25 to 29, Net migration within the UK"

    "ST0080532","30 to 34, Lived at same address"

    "ST0080533","30 to 34, Lived elsewhere one year ago within same area"

    "ST0080534","30 to 34, No usual address one year ago"

    "ST0080535","30 to 34, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080536","30 to 34, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080537","30 to 34, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080538","30 to 34, Outflow: Moved out of area but within 'associated area'"

    "ST0080539","30 to 34, Outflow: Moved out of area but within UK"

    "ST0080540","30 to 34, Net migration within the UK"

    "ST0080541","35 to 39, Lived at same address"

    "ST0080542","35 to 39, Lived elsewhere one year ago within same area"

    "ST0080543","35 to 39, No usual address one year ago"

    "ST0080544","35 to 39, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080545","35 to 39, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080546","35 to 39, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080547","35 to 39, Outflow: Moved out of area but within 'associated area'"

    "ST0080548","35 to 39, Outflow: Moved out of area but within UK"

    "ST0080549","35 to 39, Net migration within the UK"

    "ST0080550","40 to 44, Lived at same address"

    "ST0080551","40 to 44, Lived elsewhere one year ago within same area"

    "ST0080552","40 to 44, No usual address one year ago"

    "ST0080553","40 to 44, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080554","40 to 44, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080555","40 to 44, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080556","40 to 44, Outflow: Moved out of area but within 'associated area'"

    "ST0080557","40 to 44, Outflow: Moved out of area but within UK"

    "ST0080558","40 to 44, Net migration within the UK"

    "ST0080559","45 to 49, Lived at same address"

    "ST0080560","45 to 49, Lived elsewhere one year ago within same area"

    "ST0080561","45 to 49, No usual address one year ago"

    "ST0080562","45 to 49, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080563","45 to 49, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080564","45 to 49, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080565","45 to 49, Outflow: Moved out of area but within 'associated area'"

    "ST0080566","45 to 49, Outflow: Moved out of area but within UK"

    "ST0080567","45 to 49, Net migration within the UK"

    "ST0080568","50 to 54, Lived at same address"

    "ST0080569","50 to 54, Lived elsewhere one year ago within same area"

    "ST0080570","50 to 54, No usual address one year ago"

    "ST0080571","50 to 54, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080572","50 to 54, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080573","50 to 54, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080574","50 to 54, Outflow: Moved out of area but within 'associated area'"

    "ST0080575","50 to 54, Outflow: Moved out of area but within UK"

    "ST0080576","50 to 54, Net migration within the UK"

    "ST0080577","55 to 59, Lived at same address"

    "ST0080578","55 to 59, Lived elsewhere one year ago within same area"

    "ST0080579","55 to 59, No usual address one year ago"

    "ST0080580","55 to 59, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080581","55 to 59, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080582","55 to 59, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080583","55 to 59, Outflow: Moved out of area but within 'associated area'"

    "ST0080584","55 to 59, Outflow: Moved out of area but within UK"

    "ST0080585","55 to 59, Net migration within the UK"

    "ST0080586","60 to 64, Lived at same address"

    "ST0080587","60 to 64, Lived elsewhere one year ago within same area"

    "ST0080588","60 to 64, No usual address one year ago"

    "ST0080589","60 to 64, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080590","60 to 64, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080591","60 to 64, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080592","60 to 64, Outflow: Moved out of area but within 'associated area'"

    "ST0080593","60 to 64, Outflow: Moved out of area but within UK"

    "ST0080594","60 to 64, Net migration within the UK"

    "ST0080595","65 to 69, Lived at same address"

    "ST0080596","65 to 69, Lived elsewhere one year ago within same area"

    "ST0080597","65 to 69, No usual address one year ago"

    "ST0080598","65 to 69, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080599","65 to 69, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080600","65 to 69, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080601","65 to 69, Outflow: Moved out of area but within 'associated area'"

    "ST0080602","65 to 69, Outflow: Moved out of area but within UK"

    "ST0080603","65 to 69, Net migration within the UK"

    "ST0080604","70 to 74, Lived at same address"

    "ST0080605","70 to 74, Lived elsewhere one year ago within same area"

    "ST0080606","70 to 74, No usual address one year ago"

    "ST0080607","70 to 74, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080608","70 to 74, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080609","70 to 74, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080610","70 to 74, Outflow: Moved out of area but within 'associated area'"

    "ST0080611","70 to 74, Outflow: Moved out of area but within UK"

    "ST0080612","70 to 74, Net migration within the UK"

    "ST0080613","75 to 79, Lived at same address"

    "ST0080614","75 to 79, Lived elsewhere one year ago within same area"

    "ST0080615","75 to 79, No usual address one year ago"

    "ST0080616","75 to 79, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080617","75 to 79, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080618","75 to 79, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080619","75 to 79, Outflow: Moved out of area but within 'associated area'"

    "ST0080620","75 to 79, Outflow: Moved out of area but within UK"

    "ST0080621","75 to 79, Net migration within the UK"

    "ST0080622","80 to 84, Lived at same address"

    "ST0080623","80 to 84, Lived elsewhere one year ago within same area"

    "ST0080624","80 to 84, No usual address one year ago"

    "ST0080625","80 to 84, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080626","80 to 84, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080627","80 to 84, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080628","80 to 84, Outflow: Moved out of area but within 'associated area'"

    "ST0080629","80 to 84, Outflow: Moved out of area but within UK"

    "ST0080630","80 to 84, Net migration within the UK"

    "ST0080631","85 to 89, Lived at same address"

    "ST0080632","85 to 89, Lived elsewhere one year ago within same area"

    "ST0080633","85 to 89, No usual address one year ago"

    "ST0080634","85 to 89, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080635","85 to 89, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080636","85 to 89, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080637","85 to 89, Outflow: Moved out of area but within 'associated area'"

    "ST0080638","85 to 89, Outflow: Moved out of area but within UK"

    "ST0080639","85 to 89, Net migration within the UK"

    "ST0080640","90 and over, Lived at same address"

    "ST0080641","90 and over, Lived elsewhere one year ago within same area"

    "ST0080642","90 and over, No usual address one year ago"

    "ST0080643","90 and over, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080644","90 and over, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080645","90 and over, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080646","90 and over, Outflow: Moved out of area but within 'associated area'"

    "ST0080647","90 and over, Outflow: Moved out of area but within UK"

    "ST0080648","90 and over, Net migration within the UK"

    "ST0080649","ALL PEOPLE IN COMMUNAL ESTABLISHMENTS, Lived at same address"

    "ST0080650","ALL PEOPLE IN COMMUNAL ESTABLISHMENTS, Lived elsewhere one year ago within same area"

    "ST0080651","ALL PEOPLE IN COMMUNAL ESTABLISHMENTS, No usual address one year ago"

    "ST0080652","ALL PEOPLE IN COMMUNAL ESTABLISHMENTS, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080653","ALL PEOPLE IN COMMUNAL ESTABLISHMENTS, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080654","ALL PEOPLE IN COMMUNAL ESTABLISHMENTS, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080655","ALL PEOPLE IN COMMUNAL ESTABLISHMENTS, Outflow: Moved out of area but within 'associated area'"

    "ST0080656","ALL PEOPLE IN COMMUNAL ESTABLISHMENTS, Outflow: Moved out of area but within UK"

    "ST0080657","ALL PEOPLE IN COMMUNAL ESTABLISHMENTS, Net migration within the UK"

    "ST0080658","Under 1, Lived at same address"

    "ST0080659","Under 1, Lived elsewhere one year ago within same area"

    "ST0080660","Under 1, No usual address one year ago"

    "ST0080661","Under 1, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080662","Under 1, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080663","Under 1, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080664","Under 1, Outflow: Moved out of area but within 'associated area'"

    "ST0080665","Under 1, Outflow: Moved out of area but within UK"

    "ST0080666","Under 1, Net migration within the UK"

    "ST0080667","1 to 3, Lived at same address"

    "ST0080668","1 to 3, Lived elsewhere one year ago within same area"

    "ST0080669","1 to 3, No usual address one year ago"

    "ST0080670","1 to 3, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080671","1 to 3, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080672","1 to 3, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080673","1 to 3, Outflow: Moved out of area but within 'associated area'"

    "ST0080674","1 to 3, Outflow: Moved out of area but within UK"

    "ST0080675","1 to 3, Net migration within the UK"

    "ST0080676","4, Lived at same address"

    "ST0080677","4, Lived elsewhere one year ago within same area"

    "ST0080678","4, No usual address one year ago"

    "ST0080679","4, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080680","4, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080681","4, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080682","4, Outflow: Moved out of area but within 'associated area'"

    "ST0080683","4, Outflow: Moved out of area but within UK"

    "ST0080684","4, Net migration within the UK"

    "ST0080685","5 to 9, Lived at same address"

    "ST0080686","5 to 9, Lived elsewhere one year ago within same area"

    "ST0080687","5 to 9, No usual address one year ago"

    "ST0080688","5 to 9, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080689","5 to 9, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080690","5 to 9, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080691","5 to 9, Outflow: Moved out of area but within 'associated area'"

    "ST0080692","5 to 9, Outflow: Moved out of area but within UK"

    "ST0080693","5 to 9, Net migration within the UK"

    "ST0080694","10 to 14, Lived at same address"

    "ST0080695","10 to 14, Lived elsewhere one year ago within same area"

    "ST0080696","10 to 14, No usual address one year ago"

    "ST0080697","10 to 14, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080698","10 to 14, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080699","10 to 14, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080700","10 to 14, Outflow: Moved out of area but within 'associated area'"

    "ST0080701","10 to 14, Outflow: Moved out of area but within UK"

    "ST0080702","10 to 14, Net migration within the UK"

    "ST0080703","15, Lived at same address"

    "ST0080704","15, Lived elsewhere one year ago within same area"

    "ST0080705","15, No usual address one year ago"

    "ST0080706","15, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080707","15, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080708","15, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080709","15, Outflow: Moved out of area but within 'associated area'"

    "ST0080710","15, Outflow: Moved out of area but within UK"

    "ST0080711","15, Net migration within the UK"

    "ST0080712","16 to 17, Lived at same address"

    "ST0080713","16 to 17, Lived elsewhere one year ago within same area"

    "ST0080714","16 to 17, No usual address one year ago"

    "ST0080715","16 to 17, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080716","16 to 17, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080717","16 to 17, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080718","16 to 17, Outflow: Moved out of area but within 'associated area'"

    "ST0080719","16 to 17, Outflow: Moved out of area but within UK"

    "ST0080720","16 to 17, Net migration within the UK"

    "ST0080721","18 to 19, Lived at same address"

    "ST0080722","18 to 19, Lived elsewhere one year ago within same area"

    "ST0080723","18 to 19, No usual address one year ago"

    "ST0080724","18 to 19, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080725","18 to 19, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080726","18 to 19, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080727","18 to 19, Outflow: Moved out of area but within 'associated area'"

    "ST0080728","18 to 19, Outflow: Moved out of area but within UK"

    "ST0080729","18 to 19, Net migration within the UK"

    "ST0080730","20 to 24, Lived at same address"

    "ST0080731","20 to 24, Lived elsewhere one year ago within same area"

    "ST0080732","20 to 24, No usual address one year ago"

    "ST0080733","20 to 24, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080734","20 to 24, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080735","20 to 24, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080736","20 to 24, Outflow: Moved out of area but within 'associated area'"

    "ST0080737","20 to 24, Outflow: Moved out of area but within UK"

    "ST0080738","20 to 24, Net migration within the UK"

    "ST0080739","25 to 29, Lived at same address"

    "ST0080740","25 to 29, Lived elsewhere one year ago within same area"

    "ST0080741","25 to 29, No usual address one year ago"

    "ST0080742","25 to 29, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080743","25 to 29, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080744","25 to 29, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080745","25 to 29, Outflow: Moved out of area but within 'associated area'"

    "ST0080746","25 to 29, Outflow: Moved out of area but within UK"

    "ST0080747","25 to 29, Net migration within the UK"

    "ST0080748","30 to 34, Lived at same address"

    "ST0080749","30 to 34, Lived elsewhere one year ago within same area"

    "ST0080750","30 to 34, No usual address one year ago"

    "ST0080751","30 to 34, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080752","30 to 34, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080753","30 to 34, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080754","30 to 34, Outflow: Moved out of area but within 'associated area'"

    "ST0080755","30 to 34, Outflow: Moved out of area but within UK"

    "ST0080756","30 to 34, Net migration within the UK"

    "ST0080757","35 to 39, Lived at same address"

    "ST0080758","35 to 39, Lived elsewhere one year ago within same area"

    "ST0080759","35 to 39, No usual address one year ago"

    "ST0080760","35 to 39, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080761","35 to 39, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080762","35 to 39, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080763","35 to 39, Outflow: Moved out of area but within 'associated area'"

    "ST0080764","35 to 39, Outflow: Moved out of area but within UK"

    "ST0080765","35 to 39, Net migration within the UK"

    "ST0080766","40 to 44, Lived at same address"

    "ST0080767","40 to 44, Lived elsewhere one year ago within same area"

    "ST0080768","40 to 44, No usual address one year ago"

    "ST0080769","40 to 44, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080770","40 to 44, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080771","40 to 44, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080772","40 to 44, Outflow: Moved out of area but within 'associated area'"

    "ST0080773","40 to 44, Outflow: Moved out of area but within UK"

    "ST0080774","40 to 44, Net migration within the UK"

    "ST0080775","45 to 49, Lived at same address"

    "ST0080776","45 to 49, Lived elsewhere one year ago within same area"

    "ST0080777","45 to 49, No usual address one year ago"

    "ST0080778","45 to 49, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080779","45 to 49, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080780","45 to 49, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080781","45 to 49, Outflow: Moved out of area but within 'associated area'"

    "ST0080782","45 to 49, Outflow: Moved out of area but within UK"

    "ST0080783","45 to 49, Net migration within the UK"

    "ST0080784","50 to 54, Lived at same address"

    "ST0080785","50 to 54, Lived elsewhere one year ago within same area"

    "ST0080786","50 to 54, No usual address one year ago"

    "ST0080787","50 to 54, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080788","50 to 54, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080789","50 to 54, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080790","50 to 54, Outflow: Moved out of area but within 'associated area'"

    "ST0080791","50 to 54, Outflow: Moved out of area but within UK"

    "ST0080792","50 to 54, Net migration within the UK"

    "ST0080793","55 to 59, Lived at same address"

    "ST0080794","55 to 59, Lived elsewhere one year ago within same area"

    "ST0080795","55 to 59, No usual address one year ago"

    "ST0080796","55 to 59, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080797","55 to 59, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080798","55 to 59, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080799","55 to 59, Outflow: Moved out of area but within 'associated area'"

    "ST0080800","55 to 59, Outflow: Moved out of area but within UK"

    "ST0080801","55 to 59, Net migration within the UK"

    "ST0080802","60 to 64, Lived at same address"

    "ST0080803","60 to 64, Lived elsewhere one year ago within same area"

    "ST0080804","60 to 64, No usual address one year ago"

    "ST0080805","60 to 64, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080806","60 to 64, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080807","60 to 64, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080808","60 to 64, Outflow: Moved out of area but within 'associated area'"

    "ST0080809","60 to 64, Outflow: Moved out of area but within UK"

    "ST0080810","60 to 64, Net migration within the UK"

    "ST0080811","65 to 69, Lived at same address"

    "ST0080812","65 to 69, Lived elsewhere one year ago within same area"

    "ST0080813","65 to 69, No usual address one year ago"

    "ST0080814","65 to 69, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080815","65 to 69, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080816","65 to 69, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080817","65 to 69, Outflow: Moved out of area but within 'associated area'"

    "ST0080818","65 to 69, Outflow: Moved out of area but within UK"

    "ST0080819","65 to 69, Net migration within the UK"

    "ST0080820","70 to 74, Lived at same address"

    "ST0080821","70 to 74, Lived elsewhere one year ago within same area"

    "ST0080822","70 to 74, No usual address one year ago"

    "ST0080823","70 to 74, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080824","70 to 74, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080825","70 to 74, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080826","70 to 74, Outflow: Moved out of area but within 'associated area'"

    "ST0080827","70 to 74, Outflow: Moved out of area but within UK"

    "ST0080828","70 to 74, Net migration within the UK"

    "ST0080829","75 to 79, Lived at same address"

    "ST0080830","75 to 79, Lived elsewhere one year ago within same area"

    "ST0080831","75 to 79, No usual address one year ago"

    "ST0080832","75 to 79, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080833","75 to 79, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080834","75 to 79, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080835","75 to 79, Outflow: Moved out of area but within 'associated area'"

    "ST0080836","75 to 79, Outflow: Moved out of area but within UK"

    "ST0080837","75 to 79, Net migration within the UK"

    "ST0080838","80 to 84, Lived at same address"

    "ST0080839","80 to 84, Lived elsewhere one year ago within same area"

    "ST0080840","80 to 84, No usual address one year ago"

    "ST0080841","80 to 84, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080842","80 to 84, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080843","80 to 84, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080844","80 to 84, Outflow: Moved out of area but within 'associated area'"

    "ST0080845","80 to 84, Outflow: Moved out of area but within UK"

    "ST0080846","80 to 84, Net migration within the UK"

    "ST0080847","85 to 89, Lived at same address"

    "ST0080848","85 to 89, Lived elsewhere one year ago within same area"

    "ST0080849","85 to 89, No usual address one year ago"

    "ST0080850","85 to 89, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080851","85 to 89, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080852","85 to 89, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080853","85 to 89, Outflow: Moved out of area but within 'associated area'"

    "ST0080854","85 to 89, Outflow: Moved out of area but within UK"

    "ST0080855","85 to 89, Net migration within the UK"

    "ST0080856","90 and over, Lived at same address"

    "ST0080857","90 and over, Lived elsewhere one year ago within same area"

    "ST0080858","90 and over, No usual address one year ago"

    "ST0080859","90 and over, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080860","90 and over, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080861","90 and over, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080862","90 and over, Outflow: Moved out of area but within 'associated area'"

    "ST0080863","90 and over, Outflow: Moved out of area but within UK"

    "ST0080864","90 and over, Net migration within the UK"

    "ST0080865","Males, Lived at same address"

    "ST0080866","Males, Lived elsewhere one year ago within same area"

    "ST0080867","Males, No usual address one year ago"

    "ST0080868","Males, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080869","Males, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080870","Males, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080871","Males, Outflow: Moved out of area but within 'associated area'"

    "ST0080872","Males, Outflow: Moved out of area but within UK"

    "ST0080873","Males, Net migration within the UK"

    "ST0080874","Under 1, Lived at same address"

    "ST0080875","Under 1, Lived elsewhere one year ago within same area"

    "ST0080876","Under 1, No usual address one year ago"

    "ST0080877","Under 1, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080878","Under 1, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080879","Under 1, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080880","Under 1, Outflow: Moved out of area but within 'associated area'"

    "ST0080881","Under 1, Outflow: Moved out of area but within UK"

    "ST0080882","Under 1, Net migration within the UK"

    "ST0080883","1 to 3, Lived at same address"

    "ST0080884","1 to 3, Lived elsewhere one year ago within same area"

    "ST0080885","1 to 3, No usual address one year ago"

    "ST0080886","1 to 3, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080887","1 to 3, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080888","1 to 3, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080889","1 to 3, Outflow: Moved out of area but within 'associated area'"

    "ST0080890","1 to 3, Outflow: Moved out of area but within UK"

    "ST0080891","1 to 3, Net migration within the UK"

    "ST0080892","4, Lived at same address"

    "ST0080893","4, Lived elsewhere one year ago within same area"

    "ST0080894","4, No usual address one year ago"

    "ST0080895","4, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080896","4, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080897","4, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080898","4, Outflow: Moved out of area but within 'associated area'"

    "ST0080899","4, Outflow: Moved out of area but within UK"

    "ST0080900","4, Net migration within the UK"

    "ST0080901","5 to 9, Lived at same address"

    "ST0080902","5 to 9, Lived elsewhere one year ago within same area"

    "ST0080903","5 to 9, No usual address one year ago"

    "ST0080904","5 to 9, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080905","5 to 9, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080906","5 to 9, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080907","5 to 9, Outflow: Moved out of area but within 'associated area'"

    "ST0080908","5 to 9, Outflow: Moved out of area but within UK"

    "ST0080909","5 to 9, Net migration within the UK"

    "ST0080910","10 to 14, Lived at same address"

    "ST0080911","10 to 14, Lived elsewhere one year ago within same area"

    "ST0080912","10 to 14, No usual address one year ago"

    "ST0080913","10 to 14, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080914","10 to 14, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080915","10 to 14, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080916","10 to 14, Outflow: Moved out of area but within 'associated area'"

    "ST0080917","10 to 14, Outflow: Moved out of area but within UK"

    "ST0080918","10 to 14, Net migration within the UK"

    "ST0080919","15, Lived at same address"

    "ST0080920","15, Lived elsewhere one year ago within same area"

    "ST0080921","15, No usual address one year ago"

    "ST0080922","15, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080923","15, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080924","15, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080925","15, Outflow: Moved out of area but within 'associated area'"

    "ST0080926","15, Outflow: Moved out of area but within UK"

    "ST0080927","15, Net migration within the UK"

    "ST0080928","16 to 17, Lived at same address"

    "ST0080929","16 to 17, Lived elsewhere one year ago within same area"

    "ST0080930","16 to 17, No usual address one year ago"

    "ST0080931","16 to 17, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080932","16 to 17, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080933","16 to 17, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080934","16 to 17, Outflow: Moved out of area but within 'associated area'"

    "ST0080935","16 to 17, Outflow: Moved out of area but within UK"

    "ST0080936","16 to 17, Net migration within the UK"

    "ST0080937","18 to 19, Lived at same address"

    "ST0080938","18 to 19, Lived elsewhere one year ago within same area"

    "ST0080939","18 to 19, No usual address one year ago"

    "ST0080940","18 to 19, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080941","18 to 19, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080942","18 to 19, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080943","18 to 19, Outflow: Moved out of area but within 'associated area'"

    "ST0080944","18 to 19, Outflow: Moved out of area but within UK"

    "ST0080945","18 to 19, Net migration within the UK"

    "ST0080946","20 to 24, Lived at same address"

    "ST0080947","20 to 24, Lived elsewhere one year ago within same area"

    "ST0080948","20 to 24, No usual address one year ago"

    "ST0080949","20 to 24, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080950","20 to 24, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080951","20 to 24, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080952","20 to 24, Outflow: Moved out of area but within 'associated area'"

    "ST0080953","20 to 24, Outflow: Moved out of area but within UK"

    "ST0080954","20 to 24, Net migration within the UK"

    "ST0080955","25 to 29, Lived at same address"

    "ST0080956","25 to 29, Lived elsewhere one year ago within same area"

    "ST0080957","25 to 29, No usual address one year ago"

    "ST0080958","25 to 29, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080959","25 to 29, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080960","25 to 29, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080961","25 to 29, Outflow: Moved out of area but within 'associated area'"

    "ST0080962","25 to 29, Outflow: Moved out of area but within UK"

    "ST0080963","25 to 29, Net migration within the UK"

    "ST0080964","30 to 34, Lived at same address"

    "ST0080965","30 to 34, Lived elsewhere one year ago within same area"

    "ST0080966","30 to 34, No usual address one year ago"

    "ST0080967","30 to 34, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080968","30 to 34, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080969","30 to 34, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080970","30 to 34, Outflow: Moved out of area but within 'associated area'"

    "ST0080971","30 to 34, Outflow: Moved out of area but within UK"

    "ST0080972","30 to 34, Net migration within the UK"

    "ST0080973","35 to 39, Lived at same address"

    "ST0080974","35 to 39, Lived elsewhere one year ago within same area"

    "ST0080975","35 to 39, No usual address one year ago"

    "ST0080976","35 to 39, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080977","35 to 39, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080978","35 to 39, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080979","35 to 39, Outflow: Moved out of area but within 'associated area'"

    "ST0080980","35 to 39, Outflow: Moved out of area but within UK"

    "ST0080981","35 to 39, Net migration within the UK"

    "ST0080982","40 to 44, Lived at same address"

    "ST0080983","40 to 44, Lived elsewhere one year ago within same area"

    "ST0080984","40 to 44, No usual address one year ago"

    "ST0080985","40 to 44, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080986","40 to 44, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080987","40 to 44, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080988","40 to 44, Outflow: Moved out of area but within 'associated area'"

    "ST0080989","40 to 44, Outflow: Moved out of area but within UK"

    "ST0080990","40 to 44, Net migration within the UK"

    "ST0080991","45 to 49, Lived at same address"

    "ST0080992","45 to 49, Lived elsewhere one year ago within same area"

    "ST0080993","45 to 49, No usual address one year ago"

    "ST0080994","45 to 49, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0080995","45 to 49, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0080996","45 to 49, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0080997","45 to 49, Outflow: Moved out of area but within 'associated area'"

    "ST0080998","45 to 49, Outflow: Moved out of area but within UK"

    "ST0080999","45 to 49, Net migration within the UK"

    "ST0081000","50 to 54, Lived at same address"

    "ST0081001","50 to 54, Lived elsewhere one year ago within same area"

    "ST0081002","50 to 54, No usual address one year ago"

    "ST0081003","50 to 54, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081004","50 to 54, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081005","50 to 54, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081006","50 to 54, Outflow: Moved out of area but within 'associated area'"

    "ST0081007","50 to 54, Outflow: Moved out of area but within UK"

    "ST0081008","50 to 54, Net migration within the UK"

    "ST0081009","55 to 59, Lived at same address"

    "ST0081010","55 to 59, Lived elsewhere one year ago within same area"

    "ST0081011","55 to 59, No usual address one year ago"

    "ST0081012","55 to 59, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081013","55 to 59, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081014","55 to 59, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081015","55 to 59, Outflow: Moved out of area but within 'associated area'"

    "ST0081016","55 to 59, Outflow: Moved out of area but within UK"

    "ST0081017","55 to 59, Net migration within the UK"

    "ST0081018","60 to 64, Lived at same address"

    "ST0081019","60 to 64, Lived elsewhere one year ago within same area"

    "ST0081020","60 to 64, No usual address one year ago"

    "ST0081021","60 to 64, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081022","60 to 64, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081023","60 to 64, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081024","60 to 64, Outflow: Moved out of area but within 'associated area'"

    "ST0081025","60 to 64, Outflow: Moved out of area but within UK"

    "ST0081026","60 to 64, Net migration within the UK"

    "ST0081027","65 to 69, Lived at same address"

    "ST0081028","65 to 69, Lived elsewhere one year ago within same area"

    "ST0081029","65 to 69, No usual address one year ago"

    "ST0081030","65 to 69, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081031","65 to 69, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081032","65 to 69, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081033","65 to 69, Outflow: Moved out of area but within 'associated area'"

    "ST0081034","65 to 69, Outflow: Moved out of area but within UK"

    "ST0081035","65 to 69, Net migration within the UK"

    "ST0081036","70 to 74, Lived at same address"

    "ST0081037","70 to 74, Lived elsewhere one year ago within same area"

    "ST0081038","70 to 74, No usual address one year ago"

    "ST0081039","70 to 74, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081040","70 to 74, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081041","70 to 74, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081042","70 to 74, Outflow: Moved out of area but within 'associated area'"

    "ST0081043","70 to 74, Outflow: Moved out of area but within UK"

    "ST0081044","70 to 74, Net migration within the UK"

    "ST0081045","75 to 79, Lived at same address"

    "ST0081046","75 to 79, Lived elsewhere one year ago within same area"

    "ST0081047","75 to 79, No usual address one year ago"

    "ST0081048","75 to 79, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081049","75 to 79, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081050","75 to 79, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081051","75 to 79, Outflow: Moved out of area but within 'associated area'"

    "ST0081052","75 to 79, Outflow: Moved out of area but within UK"

    "ST0081053","75 to 79, Net migration within the UK"

    "ST0081054","80 to 84, Lived at same address"

    "ST0081055","80 to 84, Lived elsewhere one year ago within same area"

    "ST0081056","80 to 84, No usual address one year ago"

    "ST0081057","80 to 84, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081058","80 to 84, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081059","80 to 84, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081060","80 to 84, Outflow: Moved out of area but within 'associated area'"

    "ST0081061","80 to 84, Outflow: Moved out of area but within UK"

    "ST0081062","80 to 84, Net migration within the UK"

    "ST0081063","85 to 89, Lived at same address"

    "ST0081064","85 to 89, Lived elsewhere one year ago within same area"

    "ST0081065","85 to 89, No usual address one year ago"

    "ST0081066","85 to 89, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081067","85 to 89, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081068","85 to 89, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081069","85 to 89, Outflow: Moved out of area but within 'associated area'"

    "ST0081070","85 to 89, Outflow: Moved out of area but within UK"

    "ST0081071","85 to 89, Net migration within the UK"

    "ST0081072","90 and over, Lived at same address"

    "ST0081073","90 and over, Lived elsewhere one year ago within same area"

    "ST0081074","90 and over, No usual address one year ago"

    "ST0081075","90 and over, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081076","90 and over, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081077","90 and over, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081078","90 and over, Outflow: Moved out of area but within 'associated area'"

    "ST0081079","90 and over, Outflow: Moved out of area but within UK"

    "ST0081080","90 and over, Net migration within the UK"

    "ST0081081","Females, Lived at same address"

    "ST0081082","Females, Lived elsewhere one year ago within same area"

    "ST0081083","Females, No usual address one year ago"

    "ST0081084","Females, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081085","Females, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081086","Females, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081087","Females, Outflow: Moved out of area but within 'associated area'"

    "ST0081088","Females, Outflow: Moved out of area but within UK"

    "ST0081089","Females, Net migration within the UK"

    "ST0081090","Under 1, Lived at same address"

    "ST0081091","Under 1, Lived elsewhere one year ago within same area"

    "ST0081092","Under 1, No usual address one year ago"

    "ST0081093","Under 1, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081094","Under 1, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081095","Under 1, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081096","Under 1, Outflow: Moved out of area but within 'associated area'"

    "ST0081097","Under 1, Outflow: Moved out of area but within UK"

    "ST0081098","Under 1, Net migration within the UK"

    "ST0081099","1 to 3, Lived at same address"

    "ST0081100","1 to 3, Lived elsewhere one year ago within same area"

    "ST0081101","1 to 3, No usual address one year ago"

    "ST0081102","1 to 3, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081103","1 to 3, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081104","1 to 3, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081105","1 to 3, Outflow: Moved out of area but within 'associated area'"

    "ST0081106","1 to 3, Outflow: Moved out of area but within UK"

    "ST0081107","1 to 3, Net migration within the UK"

    "ST0081108","4, Lived at same address"

    "ST0081109","4, Lived elsewhere one year ago within same area"

    "ST0081110","4, No usual address one year ago"

    "ST0081111","4, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081112","4, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081113","4, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081114","4, Outflow: Moved out of area but within 'associated area'"

    "ST0081115","4, Outflow: Moved out of area but within UK"

    "ST0081116","4, Net migration within the UK"

    "ST0081117","5 to 9, Lived at same address"

    "ST0081118","5 to 9, Lived elsewhere one year ago within same area"

    "ST0081119","5 to 9, No usual address one year ago"

    "ST0081120","5 to 9, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081121","5 to 9, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081122","5 to 9, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081123","5 to 9, Outflow: Moved out of area but within 'associated area'"

    "ST0081124","5 to 9, Outflow: Moved out of area but within UK"

    "ST0081125","5 to 9, Net migration within the UK"

    "ST0081126","10 to 14, Lived at same address"

    "ST0081127","10 to 14, Lived elsewhere one year ago within same area"

    "ST0081128","10 to 14, No usual address one year ago"

    "ST0081129","10 to 14, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081130","10 to 14, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081131","10 to 14, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081132","10 to 14, Outflow: Moved out of area but within 'associated area'"

    "ST0081133","10 to 14, Outflow: Moved out of area but within UK"

    "ST0081134","10 to 14, Net migration within the UK"

    "ST0081135","15, Lived at same address"

    "ST0081136","15, Lived elsewhere one year ago within same area"

    "ST0081137","15, No usual address one year ago"

    "ST0081138","15, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081139","15, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081140","15, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081141","15, Outflow: Moved out of area but within 'associated area'"

    "ST0081142","15, Outflow: Moved out of area but within UK"

    "ST0081143","15, Net migration within the UK"

    "ST0081144","16 to 17, Lived at same address"

    "ST0081145","16 to 17, Lived elsewhere one year ago within same area"

    "ST0081146","16 to 17, No usual address one year ago"

    "ST0081147","16 to 17, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081148","16 to 17, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081149","16 to 17, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081150","16 to 17, Outflow: Moved out of area but within 'associated area'"

    "ST0081151","16 to 17, Outflow: Moved out of area but within UK"

    "ST0081152","16 to 17, Net migration within the UK"

    "ST0081153","18 to 19, Lived at same address"

    "ST0081154","18 to 19, Lived elsewhere one year ago within same area"

    "ST0081155","18 to 19, No usual address one year ago"

    "ST0081156","18 to 19, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081157","18 to 19, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081158","18 to 19, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081159","18 to 19, Outflow: Moved out of area but within 'associated area'"

    "ST0081160","18 to 19, Outflow: Moved out of area but within UK"

    "ST0081161","18 to 19, Net migration within the UK"

    "ST0081162","20 to 24, Lived at same address"

    "ST0081163","20 to 24, Lived elsewhere one year ago within same area"

    "ST0081164","20 to 24, No usual address one year ago"

    "ST0081165","20 to 24, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081166","20 to 24, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081167","20 to 24, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081168","20 to 24, Outflow: Moved out of area but within 'associated area'"

    "ST0081169","20 to 24, Outflow: Moved out of area but within UK"

    "ST0081170","20 to 24, Net migration within the UK"

    "ST0081171","25 to 29, Lived at same address"

    "ST0081172","25 to 29, Lived elsewhere one year ago within same area"

    "ST0081173","25 to 29, No usual address one year ago"

    "ST0081174","25 to 29, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081175","25 to 29, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081176","25 to 29, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081177","25 to 29, Outflow: Moved out of area but within 'associated area'"

    "ST0081178","25 to 29, Outflow: Moved out of area but within UK"

    "ST0081179","25 to 29, Net migration within the UK"

    "ST0081180","30 to 34, Lived at same address"

    "ST0081181","30 to 34, Lived elsewhere one year ago within same area"

    "ST0081182","30 to 34, No usual address one year ago"

    "ST0081183","30 to 34, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081184","30 to 34, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081185","30 to 34, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081186","30 to 34, Outflow: Moved out of area but within 'associated area'"

    "ST0081187","30 to 34, Outflow: Moved out of area but within UK"

    "ST0081188","30 to 34, Net migration within the UK"

    "ST0081189","35 to 39, Lived at same address"

    "ST0081190","35 to 39, Lived elsewhere one year ago within same area"

    "ST0081191","35 to 39, No usual address one year ago"

    "ST0081192","35 to 39, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081193","35 to 39, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081194","35 to 39, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081195","35 to 39, Outflow: Moved out of area but within 'associated area'"

    "ST0081196","35 to 39, Outflow: Moved out of area but within UK"

    "ST0081197","35 to 39, Net migration within the UK"

    "ST0081198","40 to 44, Lived at same address"

    "ST0081199","40 to 44, Lived elsewhere one year ago within same area"

    "ST0081200","40 to 44, No usual address one year ago"

    "ST0081201","40 to 44, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081202","40 to 44, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081203","40 to 44, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081204","40 to 44, Outflow: Moved out of area but within 'associated area'"

    "ST0081205","40 to 44, Outflow: Moved out of area but within UK"

    "ST0081206","40 to 44, Net migration within the UK"

    "ST0081207","45 to 49, Lived at same address"

    "ST0081208","45 to 49, Lived elsewhere one year ago within same area"

    "ST0081209","45 to 49, No usual address one year ago"

    "ST0081210","45 to 49, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081211","45 to 49, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081212","45 to 49, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081213","45 to 49, Outflow: Moved out of area but within 'associated area'"

    "ST0081214","45 to 49, Outflow: Moved out of area but within UK"

    "ST0081215","45 to 49, Net migration within the UK"

    "ST0081216","50 to 54, Lived at same address"

    "ST0081217","50 to 54, Lived elsewhere one year ago within same area"

    "ST0081218","50 to 54, No usual address one year ago"

    "ST0081219","50 to 54, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081220","50 to 54, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081221","50 to 54, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081222","50 to 54, Outflow: Moved out of area but within 'associated area'"

    "ST0081223","50 to 54, Outflow: Moved out of area but within UK"

    "ST0081224","50 to 54, Net migration within the UK"

    "ST0081225","55 to 59, Lived at same address"

    "ST0081226","55 to 59, Lived elsewhere one year ago within same area"

    "ST0081227","55 to 59, No usual address one year ago"

    "ST0081228","55 to 59, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081229","55 to 59, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081230","55 to 59, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081231","55 to 59, Outflow: Moved out of area but within 'associated area'"

    "ST0081232","55 to 59, Outflow: Moved out of area but within UK"

    "ST0081233","55 to 59, Net migration within the UK"

    "ST0081234","60 to 64, Lived at same address"

    "ST0081235","60 to 64, Lived elsewhere one year ago within same area"

    "ST0081236","60 to 64, No usual address one year ago"

    "ST0081237","60 to 64, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081238","60 to 64, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081239","60 to 64, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081240","60 to 64, Outflow: Moved out of area but within 'associated area'"

    "ST0081241","60 to 64, Outflow: Moved out of area but within UK"

    "ST0081242","60 to 64, Net migration within the UK"

    "ST0081243","65 to 69, Lived at same address"

    "ST0081244","65 to 69, Lived elsewhere one year ago within same area"

    "ST0081245","65 to 69, No usual address one year ago"

    "ST0081246","65 to 69, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081247","65 to 69, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081248","65 to 69, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081249","65 to 69, Outflow: Moved out of area but within 'associated area'"

    "ST0081250","65 to 69, Outflow: Moved out of area but within UK"

    "ST0081251","65 to 69, Net migration within the UK"

    "ST0081252","70 to 74, Lived at same address"

    "ST0081253","70 to 74, Lived elsewhere one year ago within same area"

    "ST0081254","70 to 74, No usual address one year ago"

    "ST0081255","70 to 74, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081256","70 to 74, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081257","70 to 74, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081258","70 to 74, Outflow: Moved out of area but within 'associated area'"

    "ST0081259","70 to 74, Outflow: Moved out of area but within UK"

    "ST0081260","70 to 74, Net migration within the UK"

    "ST0081261","75 to 79, Lived at same address"

    "ST0081262","75 to 79, Lived elsewhere one year ago within same area"

    "ST0081263","75 to 79, No usual address one year ago"

    "ST0081264","75 to 79, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081265","75 to 79, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081266","75 to 79, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081267","75 to 79, Outflow: Moved out of area but within 'associated area'"

    "ST0081268","75 to 79, Outflow: Moved out of area but within UK"

    "ST0081269","75 to 79, Net migration within the UK"

    "ST0081270","80 to 84, Lived at same address"

    "ST0081271","80 to 84, Lived elsewhere one year ago within same area"

    "ST0081272","80 to 84, No usual address one year ago"

    "ST0081273","80 to 84, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081274","80 to 84, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081275","80 to 84, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081276","80 to 84, Outflow: Moved out of area but within 'associated area'"

    "ST0081277","80 to 84, Outflow: Moved out of area but within UK"

    "ST0081278","80 to 84, Net migration within the UK"

    "ST0081279","85 to 89, Lived at same address"

    "ST0081280","85 to 89, Lived elsewhere one year ago within same area"

    "ST0081281","85 to 89, No usual address one year ago"

    "ST0081282","85 to 89, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081283","85 to 89, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081284","85 to 89, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081285","85 to 89, Outflow: Moved out of area but within 'associated area'"

    "ST0081286","85 to 89, Outflow: Moved out of area but within UK"

    "ST0081287","85 to 89, Net migration within the UK"

    "ST0081288","90 and over, Lived at same address"

    "ST0081289","90 and over, Lived elsewhere one year ago within same area"

    "ST0081290","90 and over, No usual address one year ago"

    "ST0081291","90 and over, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'"

    "ST0081292","90 and over, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK"

    "ST0081293","90 and over, Inflow: Lived elsewhere one year ago outside the UK"

    "ST0081294","90 and over, Outflow: Moved out of area but within 'associated area'"

    "ST0081295","90 and over, Outflow: Moved out of area but within UK"

    "ST0081296","90 and over, Net migration within the UK"

    Would idealy produce a table:

    Called

    ST008DATAF1

    GeographyCode65 to 69, Outflow: Moved out of area but within UK65 to 69, Net migration within the UK70 to 74, Lived at same address70 to 74, Lived elsewhere one year ago within same area70 to 74, No usual address one year ago70 to 74, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'70 to 74, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK70 to 74, Inflow: Lived elsewhere one year ago outside the UK70 to 74, Outflow: Moved out of area but within 'associated area'70 to 74, Outflow: Moved out of area but within UK70 to 74, Net migration within the UK75 to 79, Lived at same address75 to 79, Lived elsewhere one year ago within same area75 to 79, No usual address one year ago75 to 79, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'75 to 79, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK75 to 79, Inflow: Lived elsewhere one year ago outside the UK75 to 79, Outflow: Moved out of area but within 'associated area'75 to 79, Outflow: Moved out of area but within UK75 to 79, Net migration within the UK80 to 84, Lived at same address80 to 84, Lived elsewhere one year ago within same area80 to 84, No usual address one year ago80 to 84, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'80 to 84, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK80 to 84, Inflow: Lived elsewhere one year ago outside the UK80 to 84, Outflow: Moved out of area but within 'associated area'80 to 84, Outflow: Moved out of area but within UK80 to 84, Net migration within the UK85 to 89, Lived at same address85 to 89, Lived elsewhere one year ago within same area85 to 89, No usual address one year ago85 to 89, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'85 to 89, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK85 to 89, Inflow: Lived elsewhere one year ago outside the UK85 to 89, Outflow: Moved out of area but within 'associated area'85 to 89, Outflow: Moved out of area but within UK85 to 89, Net migration within the UK90 and over, Lived at same address90 and over, Lived elsewhere one year ago within same area90 and over, No usual address one year ago90 and over, Inflow: Lived elsewhere one year ago outside the area but within 'associated area'90 and over, Inflow: Lived elsewhere one year ago outside the 'associated area' but within the UK90 and over, Inflow: Lived elsewhere one year ago outside the UK90 and over, Outflow: Moved out of area but within 'associated area'90 and over, Outflow: Moved out of area but within UK90 and over, Net migration within the UK
    72710511772414211701244-119-724376959332702535-132-7401121582954405647-159-3570272089970605046-1455678361982768005544-160-5
    6410-31105238771101912421718-4228498964310422335303143762914808507765243535718535701961466391494571422763819185986371045141725825
    2200872022971703191-31527557173030421-102483892375344762-2134571123437103913-23401710534372431042-30
    A2-2784278353381-115045341222301339236586027344031252940917254773392133115821282963503-18
    B1-11793587154333372739111294485143807-326068201271961751197-1382222566801261551927-589400231087113861442-25
    D2-411873831625002203256991630563556214184155251910482725956193566114401372-2169641819531126010765
    E1588329273903304519727792989336712432821219361509387567469515815820570114593552814024519093116677
    F201118394938033215234188630720053415390114204914540111236511017456017700142728574616067015140120728
    G0-31006339164503460-1218584431111439302236911329652330612969852931884693080620221046431179082277641776100
    H1-26118931783806855-5220756592981071545-783044100562112353189-2124344140681165074525-2925087138982147344457-302
    J1181812564216601261503668132359166091487116356238584292672388529829334713142651231851081241934561043936112864109
    K0812803901553092932126241010421135585528473817996215071116511-1971812506932507102027489129246286235371701157
  • NOTE:

    The tables don't exist in SQL server they will need to be created by the script using a combination of file name (ST008DATAAF1.CSV vs. ST008DATAbF1.CSV, etc.) and the number of columns in the .csv file.

     

  • i have done this. the census data comes in a number of different formats. i used one of the database formats which imported effortlessly into access, so i was effectively using access as a front end to sql server (linked tables, etc). using this method i had all the census data into sql server within 10 minutes.

  • Can you remember which DB format it was, I've only got .CSV, SuperTable and SASPAC?

    I can obviously import individual .CSV's fine but can't find a way to bulk import them!

  • oops, sorry! i looked back on my files. what i was talking about was for depravation data which i was linking to census data over a year ago. hence my confusion.

    very sorry. i remember now the census data is much larger and more complex.

  • OK I've found how to do it:

    Setup and ODBC DSN using the text driver pointing the directory containing the file you can then use the DTS wizard and each file in the directory is represented as a table in the DSN.

    Takes a while however my Dual Xeon server has taken about 30 hours to get through about a third of the files!

    Stephen

  • Viewing 6 posts - 1 through 5 (of 5 total)

    You must be logged in to reply to this topic. Login to reply