In [1]:
%pylab --no-import-all inline
Populating the interactive namespace from numpy and matplotlib
In [2]:
# import useful classes of pandas
import pandas as pd
from pandas import Series, DataFrame, Index
In [3]:
import settings
import census
c = census.Census(key=settings.CENSUS_KEY)
In [4]:
sf1_fields = c.sf1.fields(year=2010)
In [5]:
sorted(sf1_fields.keys())
Out[5]:
['Geographic Characteristics',
'H1. Housing Units [1]',
'H10. TOTAL POPULATION IN OCCUPIED HOUSING UNITS [1]',
'H11. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE [4]',
'H11A. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE HOUSEHOLDER) [4]',
'H11B. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [4]',
'H11C. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [4]',
'H11D. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (ASIAN ALONE HOUSEHOLDER) [4]',
'H11E. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [4]',
'H11F. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (SOME OTHER RACE ALONE HOUSEHOLDER) [4]',
'H11G. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (TWO OR MORE RACES HOUSEHOLDER) [4]',
'H11H. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (HISPANIC OR LATINO HOUSEHOLDER) [4]',
'H11I. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [4]',
'H12. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE [3] (2 expressed decimals)',
'H12A. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'H12B. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'H12C. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'H12D. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (ASIAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'H12E. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'H12F. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (SOME OTHER RACE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'H12G. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (TWO OR MORE RACES HOUSEHOLDER) [3] (2 expressed decimals)',
'H12H. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',
'H12I. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',
'H13. Household Size [8]',
'H14. Tenure By Race Of Householder [17]',
'H15. TENURE BY HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER [7]',
'H16. TENURE BY HOUSEHOLD SIZE [17]',
'H16A. TENURE BY HOUSEHOLD SIZE (WHITE ALONE HOUSEHOLDER) [17]',
'H16B. TENURE BY HOUSEHOLD SIZE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [17]',
'H16C. TENURE BY HOUSEHOLD SIZE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [17]',
'H16D. TENURE BY HOUSEHOLD SIZE (ASIAN ALONE HOUSEHOLDER) [17]',
'H16E. TENURE BY HOUSEHOLD SIZE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [17]',
'H16F. TENURE BY HOUSEHOLD SIZE (SOME OTHER RACE ALONE HOUSEHOLDER) [17]',
'H16G. TENURE BY HOUSEHOLD SIZE (TWO OR MORE RACES HOUSEHOLDER) [17]',
'H16H. TENURE BY HOUSEHOLD SIZE (HISPANIC OR LATINO HOUSEHOLDER) [17]',
'H16I. TENURE BY HOUSEHOLD SIZE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [17]',
'H17. TENURE BY AGE OF HOUSEHOLDER [21]',
'H17A. TENURE BY AGE OF HOUSEHOLDER (WHITE ALONE HOUSEHOLDER) [21]',
'H17B. TENURE BY AGE OF HOUSEHOLDER (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [21]',
'H17C. TENURE BY AGE OF HOUSEHOLDER (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [21]',
'H17D. TENURE BY AGE OF HOUSEHOLDER (ASIAN ALONE HOUSEHOLDER) [21]',
'H17E. TENURE BY AGE OF HOUSEHOLDER (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [21]',
'H17F. TENURE BY AGE OF HOUSEHOLDER (SOME OTHER RACE ALONE HOUSEHOLDER) [21]',
'H17G. TENURE BY AGE OF HOUSEHOLDER (TWO OR MORE RACES HOUSEHOLDER) [21]',
'H17H. TENURE BY AGE OF HOUSEHOLDER (HISPANIC OR LATINO HOUSEHOLDER) [21]',
'H17I. TENURE BY AGE OF HOUSEHOLDER (WHITE ALONE HOUSEHOLDER, NOT HISPANIC OR LATINO) [21]',
'H18. TENURE BY HOUSEHOLD TYPE BY AGE OF HOUSEHOLDER [69]',
'H19. TENURE BY PRESENCE OF PEOPLE UNDER 18 YEARS (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS) [7]',
'H2. URBAN AND RURAL [6] (Urban/Rural Update only)',
'H20. OCCUPIED HOUSING UNITS SUBSTITUTED [3]',
'H21. ALLOCATION OF VACANCY STATUS [3]',
'H22. ALLOCATION OF TENURE [3]',
'H3. Occupancy Status [3]',
'H4. TENURE [4]',
'H5. VACANCY STATUS [8]',
'H6. Race Of Householder [8]',
'H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER BY RACE OF HOUSEHOLDER [17]',
'H8. Total Races Tallied For Householders [7]',
'H9. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDERS BY TOTAL RACES TALLIED [15]',
'HCT1. TENURE BY HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER BY RACE OF HOUSEHOLDER [35]',
'HCT2. TENURE BY PRESENCE AND AGE OF OWN CHILDREN [13]',
'HCT3. TENURE BY PRESENCE AND AGE OF RELATED CHILDREN [13]',
'HCT4. TENURE BY PRESENCE AND AGE OF PEOPLE UNDER 18 YEARS BY HOUSEHOLD TYPE (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS) [13]',
'P1. Total Population [1]',
'P10. RACE FOR THE POPULATION 18 YEARS AND OVER [71]',
'P11. HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO BY RACE FOR THE POPULATION 18 YEARS AND OVER [73]',
'P12. Sex By Age [49]',
'P12A. Sex By Age (White Alone) [49]',
'P12B. Sex By Age (Black Or African American Alone) [49]',
'P12C. Sex By Age (American Indian And Alaska Native Alone) [49]',
'P12D. Sex By Age (Asian Alone) [49]',
'P12E. Sex By Age (Native Hawaiian And Other Pacific Islander Alone) [49]',
'P12F. Sex By Age (Some Other Race Alone) [49]',
'P12G. Sex By Age (Two Or More Races) [49]',
'P12H. Sex By Age (Hispanic Or Latino) [49]',
'P12I. Sex By Age (White Alone, Not Hispanic Or Latino) [49]',
'P13. MEDIAN AGE BY SEX [3] (1 expressed decimal)',
'P13A. MEDIAN AGE BY SEX (WHITE ALONE) [3] (1 expressed decimal)',
'P13B. MEDIAN AGE BY SEX (BLACK OR AFRICAN AMERICAN ALONE) [3] (1 expressed decimal)',
'P13C. MEDIAN AGE BY SEX (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [3] (1 expressed decimal)',
'P13D. MEDIAN AGE BY SEX (ASIAN ALONE) [3] (1 expressed decimal)',
'P13E. MEDIAN AGE BY SEX (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [3] (1 expressed decimal)',
'P13F. MEDIAN AGE BY SEX (SOME OTHER RACE ALONE) [3] (1 expressed decimal)',
'P13G. MEDIAN AGE BY SEX (TWO OR MORE RACES) [3] (1 expressed decimal)',
'P13H. MEDIAN AGE BY SEX (HISPANIC OR LATINO) [3] (1 expressed decimal)',
'P13I. MEDIAN AGE BY SEX (WHITE ALONE, NOT HISPANIC OR LATINO) [3] (1 expressed decimal)',
'P14. Sex By Age For The Population Under 20 Years [43]',
'P15. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER BY RACE OF HOUSEHOLDER [17]',
'P16. POPULATION IN HOUSEHOLDS BY AGE [3]',
'P16A. POPULATION IN HOUSEHOLDS BY AGE (WHITE ALONE HOUSEHOLDER) [3]',
'P16B. POPULATION IN HOUSEHOLDS BY AGE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3]',
'P16C. POPULATION IN HOUSEHOLDS BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3]',
'P16D. POPULATION IN HOUSEHOLDS BY AGE (ASIAN ALONE HOUSEHOLDER) [3]',
'P16E. POPULATION IN HOUSEHOLDS BY AGE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3]',
'P16F. POPULATION IN HOUSEHOLDS BY AGE (SOME OTHER RACE ALONE HOUSEHOLDER) [3]',
'P16G. POPULATION IN HOUSEHOLDS BY AGE (TWO OR MORE RACES HOUSEHOLDER) [3]',
'P16H. POPULATION IN HOUSEHOLDS BY AGE (HISPANIC OR LATINO HOUSEHOLDER) [3]',
'P16I. POPULATION IN HOUSEHOLDS BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3]',
'P17. AVERAGE HOUSEHOLD SIZE BY AGE [3] (2 expressed decimals)',
'P17A. AVERAGE HOUSEHOLD SIZE BY AGE (WHITE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P17B. AVERAGE HOUSEHOLD SIZE BY AGE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P17C. AVERAGE HOUSEHOLD SIZE BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P17D. AVERAGE HOUSEHOLD SIZE BY AGE (ASIAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P17E. AVERAGE HOUSEHOLD SIZE BY AGE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P17F. AVERAGE HOUSEHOLD SIZE BY AGE (SOME OTHER RACE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P17G. AVERAGE HOUSEHOLD SIZE BY AGE (TWO OR MORERACES HOUSEHOLDER) [3] (2 expressed decimals)',
'P17H. AVERAGE HOUSEHOLD SIZE BY AGE (HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',
'P17I. AVERAGE HOUSEHOLD SIZE BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',
'P18. HOUSEHOLD TYPE [9]',
'P18A. HOUSEHOLD TYPE (WHITE ALONE HOUSEHOLDER) [9]',
'P18B. HOUSEHOLD TYPE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [9]',
'P18C. HOUSEHOLD TYPE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [9]',
'P18D. HOUSEHOLD TYPE (ASIAN ALONE HOUSEHOLDER) [9]',
'P18E. HOUSEHOLD TYPE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [9]',
'P18F. HOUSEHOLD TYPE (SOME OTHER RACE ALONE HOUSEHOLDER) [9]',
'P18G. HOUSEHOLD TYPE (TWO OR MORE RACES HOUSEHOLDER) [9]',
'P18H. HOUSEHOLD TYPE (HISPANIC OR LATINO HOUSEHOLDER) [9]',
'P18I. HOUSEHOLD TYPE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [9]',
'P19. HOUSEHOLD SIZE BY HOUSEHOLD TYPE BY PRESENCE OF OWN CHILDREN [19]',
'P2. Urban And Rural [6]',
'P20. HOUSEHOLDS BY PRESENCE OF PEOPLE UNDER 18 YEARS BY HOUSEHOLD TYPE BY AGE OF PEOPLE UNDER 18 YEARS [34]',
'P21. HOUSEHOLDS BY AGE OF HOUSEHOLDER BY HOUSEHOLD TYPE BY PRESENCE OF RELATED CHILDREN [31]',
'P22. HOUSEHOLD TYPE BY AGE OF HOUSEHOLDER [21]',
'P23. HOUSEHOLDS BY PRESENCE OF PEOPLE 60 YEARS AND OVER BY HOUSEHOLD TYPE [15]',
'P24. HOUSEHOLDS BY PRESENCE OF PEOPLE 60 YEARS AND OVER, HOUSEHOLD SIZE, AND HOUSEHOLD TYPE [11]',
'P25. HOUSEHOLDS BY PRESENCE OF PEOPLE 65 YEARS AND OVER, HOUSEHOLD SIZE, AND HOUSEHOLD TYPE [11]',
'P26. HOUSEHOLDS BY PRESENCE OF PEOPLE 75 YEARS AND OVER, HOUSEHOLD SIZE, AND HOUSEHOLD TYPE [11]',
'P27. HOUSEHOLDS BY PRESENCE OF NONRELATIVES [3]',
'P28. HOUSEHOLD TYPE BY HOUSEHOLD SIZE [16]',
'P28A. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (WHITE ALONE HOUSEHOLDER) [16]',
'P28B. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [16]',
'P28C. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [16]',
'P28D. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (ASIAN ALONE HOUSEHOLDER) [16]',
'P28E. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [16]',
'P28F. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (SOME OTHER RACE ALONE HOUSEHOLDER) [16]',
'P28G. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (TWO OR MORE RACES HOUSEHOLDER) [16]',
'P28H. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (HISPANIC OR LATINO HOUSEHOLDER) [16]',
'P28I. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [16]',
'P29. HOUSEHOLD TYPE BY RELATIONSHIP [28]',
'P29A. HOUSEHOLD TYPE BY RELATIONSHIP (WHITE ALONE) [28]',
'P29B. HOUSEHOLD TYPE BY RELATIONSHIP (BLACK OR AFRICAN AMERICAN ALONE) [28]',
'P29C. HOUSEHOLD TYPE BY RELATIONSHIP (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [28]',
'P29D. HOUSEHOLD TYPE BY RELATIONSHIP (ASIAN ALONE) [28]',
'P29E. HOUSEHOLD TYPE BY RELATIONSHIP (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [28]',
'P29F. HOUSEHOLD TYPE BY RELATIONSHIP (SOME OTHER RACE ALONE) [28]',
'P29G. HOUSEHOLD TYPE BY RELATIONSHIP (TWO OR MORE RACES) [28]',
'P29H. HOUSEHOLD TYPE BY RELATIONSHIP (HISPANIC OR LATINO) [28]',
'P29I. HOUSEHOLD TYPE BY RELATIONSHIP (WHITE ALONE, NOT HISPANIC OR LATINO) [28]',
'P3. RACE [8]',
'P30. HOUSEHOLD TYPE FOR THE POPULATION IN HOUSEHOLDS [13]',
'P31. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS [16]',
'P31A. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (WHITE ALONE) [16]',
'P31B. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (BLACK OR AFRICAN AMERICAN ALONE) [16]',
'P31C. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [16]',
'P31D. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (ASIAN ALONE) [16]',
'P31E. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [16]',
'P31F. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (SOME OTHER RACE ALONE) [16]',
'P31G. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (TWO OR MORE RACES) [16]',
'P31H. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (HISPANIC OR LATINO) [16]',
'P31I. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (WHITE ALONE, NOT HISPANIC OR LATINO) [16]',
'P32. HOUSEHOLD TYPE BY RELATIONSHIP BY AGE FOR THE POPULATION UNDER 18 YEARS [45]',
'P33. HOUSEHOLD TYPE FOR THE POPULATION UNDER 18 YEARS IN HOUSEHOLDS (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS) [7]',
'P34. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER [22]',
'P34A. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (WHITE ALONE) [22]',
'P34B. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (BLACK OR AFRICAN AMERICAN ALONE) [22]',
'P34C. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [22]',
'P34D. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (ASIAN ALONE) [22]',
'P34E. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [22]',
'P34F. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (SOME OTHER RACE ALONE) [22]',
'P34G. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (TWO OR MORE RACES) [22]',
'P34H. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (HISPANIC OR LATINO) [22]',
'P34I. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (WHITE ALONE, NOT HISPANIC OR LATINO) [22]',
'P35. FAMILIES [1]',
'P35A. FAMILIES (WHITE ALONE HOUSEHOLDER) [1]',
'P35B. FAMILIES (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [1]',
'P35C. FAMILIES (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [1]',
'P35D. FAMILIES (ASIAN ALONE HOUSEHOLDER) [1]',
'P35E. FAMILIES (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [1]',
'P35F. FAMILIES (SOME OTHER RACE ALONE HOUSEHOLDER) [1]',
'P35G. FAMILIES (TWO OR MORE RACES HOUSEHOLDER) [1]',
'P35H. FAMILIES (HISPANIC OR LATINO HOUSEHOLDER) [1]',
'P35I. FAMILIES (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [1]',
'P36. POPULATION IN FAMILIES BY AGE [3]',
'P36A. POPULATION IN FAMILIES BY AGE (WHITE ALONE HOUSEHOLDER) [3]',
'P36B. POPULATION IN FAMILIES BY AGE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3]',
'P36C. POPULATION IN FAMILIES BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3]',
'P36D. POPULATION IN FAMILIES BY AGE (ASIAN ALONE HOUSEHOLDER) [3]',
'P36E. POPULATION IN FAMILIES BY AGE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3]',
'P36F. POPULATION IN FAMILIES BY AGE (SOME OTHER RACE ALONE HOUSEHOLDER) [3]',
'P36G. POPULATION IN FAMILIES BY AGE (TWO OR MORE RACES HOUSEHOLDER) [3]',
'P36H. POPULATION IN FAMILIES BY AGE (HISPANIC OR LATINO HOUSEHOLDER) [3]',
'P36I. POPULATION IN FAMILIES BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3]',
'P37. AVERAGE FAMILY SIZE BY AGE [3] (2 expressed decimals)',
'P37A. AVERAGE FAMILY SIZE BY AGE (WHITE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P37B. AVERAGE FAMILY SIZE BY AGE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3]',
'P37C. AVERAGE FAMILY SIZE BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P37D. AVERAGE FAMILY SIZE BY AGE (ASIAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P37E. AVERAGE FAMILY SIZE BY AGE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P37F. AVERAGE FAMILY SIZE BY AGE (SOME OTHER RACE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',
'P37G. AVERAGE FAMILY SIZE BY AGE (TWO OR MORE RACES HOUSEHOLDER) [3] (2 expressed decimals)',
'P37H. AVERAGE FAMILY SIZE BY AGE (HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',
'P37I. AVERAGE FAMILY SIZE BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',
'P38. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN [20]',
'P38A. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (WHITE ALONE HOUSEHOLDER) [20]',
'P38B. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [20]',
'P38C. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [20]',
'P38D. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (ASIAN ALONE HOUSEHOLDER) [20]',
'P38E. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [20]',
'P38F. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (SOME OTHER RACE ALONE HOUSEHOLDER) [20]',
'P38G. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (TWO OR MORE RACES HOUSEHOLDER) [20]',
'P38H. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (HISPANIC OR LATINO HOUSEHOLDER) [20]',
'P38I. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [20]',
'P39. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN [20]',
'P39A. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (WHITE ALONE HOUSEHOLDER) [20]',
'P39B. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [20]',
'P39C. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [20]',
'P39D. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (ASIAN ALONE HOUSEHOLDER) [20]',
'P39E. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [20]',
'P39F. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (SOME OTHER RACE ALONE HOUSEHOLDER) [20]',
'P39G. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (TWO OR MORE RACES HOUSEHOLDER) [20]',
'P39H. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (HISPANIC OR LATINO HOUSEHOLDER) [20]',
'P39I. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [20]',
'P4. HISPANIC OR LATINO ORIGIN [3]',
'P40. FAMILY TYPE AND AGE FOR OWN CHILDREN UNDER 18 YEARS [20]',
'P41. AGE OF GRANDCHILDREN UNDER 18 YEARS LIVING WITH A GRANDPARENT HOUSEHOLDER [6]',
'P42. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE [10]',
'P43. GROUP QUARTERS POPULATION BY SEX BY AGE BY GROUP QUARTERS TYPE [63]',
'P44. POPULATION SUBSTITUTED [3]',
'P45. ALLOCATION OF POPULATION ITEMS [3]',
'P46. ALLOCATION OF RACE [3]',
'P47. ALLOCATION OF HISPANIC OR LATINO ORIGIN [3]',
'P48. ALLOCATION OF SEX [3]',
'P49. ALLOCATION OF AGE [3]',
'P5. HISPANIC OR LATINO ORIGIN BY RACE [17]',
'P50. ALLOCATION OF RELATIONSHIP [3]',
'P51. ALLOCATION OF POPULATION ITEMS FOR THE POPULATION IN GROUP QUARTERS [3]',
'P6. RACE (TOTAL RACES TALLIED) [7]',
'P7. HISPANIC OR LATINO ORIGIN BY RACE (TOTAL RACES TALLIED) [15]',
'P8. RACE [71]',
'P9. HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO BY RACE [73]',
'PCO1. GROUP QUARTERS POPULATION BY SEX BY AGE [39]',
'PCO10. GROUP QUARTERS POPULATION IN OTHER NONINSTITUTIONAL FACILITIES BY SEX BY AGE [39]',
'PCO2. GROUP QUARTERS POPULATION IN INSTITUTIONAL FACILITIES BY SEX BY AGE [39]',
'PCO3. GROUP QUARTERS POPULATION IN CORRECTIONAL FACILITIES FOR ADULTS BY SEX BY AGE [39]',
'PCO4. GROUP QUARTERS POPULATION IN JUVENILE FACILITIES BY SEX BY AGE [39]',
'PCO5. GROUP QUARTERS POPULATION IN NURSING FACILITIES/SKILLED-NURSING FACILITIES BY SEX BY AGE [39]',
'PCO6. GROUP QUARTERS POPULATION IN OTHER INSTITUTIONAL FACILITIES BY SEX BY AGE [39]',
'PCO7. GROUP QUARTERS POPULATION IN NONINSTITUTIONAL FACILITIES BY SEX BY AGE [39]',
'PCO8. GROUP QUARTERS POPULATION IN COLLEGE/UNIVERSITY STUDENT HOUSING BY SEX BY AGE [39]',
'PCO9. GROUP QUARTERS POPULATION IN MILITARY QUARTERS BY SEX BY AGE [39]',
'PCT1. AMERICAN INDIAN AND ALASKA NATIVE ALONE WITH ONE TRIBE REPORTED FOR SELECTED TRIBES [54]',
'PCT10. NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE OR IN COMBINATION WITH ONE OR MORE RACES, AND WITH ONE OR MORE NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER CATEGORIES FOR SELECTED GROUPS [14]',
'PCT11. Hispanic Or Latino By Specific Origin [31]',
'PCT12. Sex By Age [209]',
'PCT12A. Sex By Age (White Alone) [209]',
'PCT12B. Sex By Age (Black Or African American Alone) [209]',
'PCT12C. Sex By Age (American Indian And Alaska Native Alone) [209]',
'PCT12D. Sex By Age (Asian Alone) [209]',
'PCT12E. Sex By Age (Native Hawaiian And Other Pacific Islander Alone) [209]',
'PCT12F. Sex By Age (Some Other Race Alone) [209]',
'PCT12G. Sex By Age (Two Or More Races) [209]',
'PCT12H. Sex By Age (Hispanic Or Latino) [209]',
'PCT12I. SEX BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO) [209]',
'PCT12J. Sex By Age (Black Or African American Alone, Not Hispanic Or Latino) [209]',
'PCT12K. SEX BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE, NOT HISPANIC OR LATINO) [209]',
'PCT12L. Sex By Age (Asian Alone, Not Hispanic Or Latino) [209]',
'PCT12M. Sex By Age (Native Hawaiian And Other Pacific Islander Alone, Not Hispanic Or Latino) [209]',
'PCT12N. Sex By Age (Some Other Race Alone, Not Hispanic Or Latino) [209]',
'PCT12O. Sex By Age (Two Or More Races, Not Hispanic Or Latino) [209]',
'PCT13. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS [49]',
'PCT13A. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (WHITE ALONE) [49]',
'PCT13B. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (BLACK OR AFRICAN AMERICAN ALONE) [49]',
'PCT13C. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [49]',
'PCT13D. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (ASIAN ALONE) [49]',
'PCT13E. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [49]',
'PCT13F. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (SOME OTHER RACE ALONE) [49]',
'PCT13G. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (TWO OR MORE RACES) [49]',
'PCT13H. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (HISPANIC OR LATINO) [49]',
'PCT13I. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (WHITE ALONE, NOT HISPANIC OR LATINO) [49]',
'PCT14. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS [3]',
'PCT14A. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (WHITE ALONE HOUSEHOLDER) [3]',
'PCT14B. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3]',
'PCT14C. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3]',
'PCT14D. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (ASIAN ALONE HOUSEHOLDER) [3]',
'PCT14E. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3]',
'PCT14F. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (SOME OTHER RACE ALONE HOUSEHOLDER) [3]',
'PCT14G. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (TWO OR MORE RACES HOUSEHOLDER) [3]',
'PCT14H. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (HISPANIC OR LATINO HOUSEHOLDER) [3]',
'PCT14I. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3]',
'PCT15. HUSBAND-WIFE AND UNMARRIED-PARTNER HOUSEHOLDS BY SEX OF PARTNER BY PRESENCE OF RELATED AND OWN CHILDREN UNDER 18 YEARS [34]',
'PCT16. HOUSEHOLD TYPE BY NUMBER OF PEOPLE UNDER 18 YEARS (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS) [26]',
'PCT17. PRESENCE OF UNMARRIED PARTNER OF HOUSEHOLDER BY HOUSEHOLD TYPE FOR THE POPULATION UNDER 18 YEARS IN HOUSEHOLDS (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS) [18]',
'PCT18. NONFAMILY HOUSEHOLDS BY SEX OF HOUSEHOLDER BY LIVING ALONE BY AGE OF HOUSEHOLDER [15]',
'PCT19. NONRELATIVES BY HOUSEHOLD TYPE [11]',
'PCT19A. NONRELATIVES BY HOUSEHOLD TYPE (WHITE ALONE) [11]',
'PCT19B. NONRELATIVES BY HOUSEHOLD TYPE (BLACK OR AFRICAN AMERICAN ALONE) [11]',
'PCT19C. NONRELATIVES BY HOUSEHOLD TYPE (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [11]',
'PCT19D. NONRELATIVES BY HOUSEHOLD TYPE (ASIAN ALONE) [11]',
'PCT19E. NONRELATIVES BY HOUSEHOLD TYPE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [11]',
'PCT19F. NONRELATIVES BY HOUSEHOLD TYPE (SOME OTHER RACE ALONE) [11]',
'PCT19G. NONRELATIVES BY HOUSEHOLD TYPE (TWO OR MORE RACES) [11]',
'PCT19H. NONRELATIVES BY HOUSEHOLD TYPE (HISPANIC OR LATINO) [11]',
'PCT19I. NONRELATIVES BY HOUSEHOLD TYPE (WHITE ALONE, NOT HISPANIC OR LATINO) [11]',
'PCT2. AMERICAN INDIAN AND ALASKA NATIVE ALONE WITH ONE OR MORE TRIBES REPORTED FOR SELECTED TRIBES [54]',
'PCT20. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE [32]',
'PCT20A. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (WHITE ALONE) [32]',
'PCT20B. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (BLACK OR AFRICAN AMERICAN ALONE) [32]',
'PCT20C. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [32]',
'PCT20D. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (ASIAN ALONE) [32]',
'PCT20E. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [32]',
'PCT20F. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (SOME OTHER RACE ALONE) [32]',
'PCT20G. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (TWO OR MORE RACES) [32]',
'PCT20H. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (HISPANIC OR LATINO) [32]',
'PCT20I. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (WHITE ALONE, NOT HISPANIC OR LATINO) [32]',
'PCT21. GROUP QUARTERS POPULATION BY SEX BY AGE BY GROUP QUARTERS TYPE [195]',
'PCT22. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER [21]',
'PCT22A. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (WHITE ALONE)',
'PCT22B. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (BLACK OR AFRICAN AMERICAN ALONE) [21]',
'PCT22C. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [21]',
'PCT22D. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (ASIAN ALONE)',
'PCT22E. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (NATIVEHAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [21]',
'PCT22F. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (SOME OTHER RACE ALONE) [21]',
'PCT22G. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (TWO OR MORE RACES) [21]',
'PCT22H. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (HISPANIC OR LATINO) [21]',
'PCT22I. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (WHITE ALONE, NOT HISPANIC OR LATINO) [21]',
'PCT3. AMERICAN INDIAN AND ALASKA NATIVE ALONE OR IN COMBINATION WITH ONE OR MORE OTHER RACES AND WITH ONE OR MORE TRIBES REPORTED FOR SELECTED TRIBES [54]',
'PCT4. American Indian And Alaska Native Alone Or In Combination With One Or More Other Races [9]',
'PCT5. ASIAN ALONE WITH ONE ASIAN CATEGORY FOR SELECTED GROUPS [22]',
'PCT6. ASIAN ALONE WITH ONE OR MORE ASIAN CATEGORIES FOR SELECTED GROUPS [22]',
'PCT7. ASIAN ALONE OR IN COMBINATION WITH ONE OR MORE OTHER RACES, AND WITH ONE OR MORE ASIAN CATEGORIES FOR SELECTED GROUPS [22]',
'PCT8. Native Hawaiian And Other Pacific Islander Alone With One Native Hawaiian And Other Pacific Islander Category For Selected Groups [14]',
'PCT9. Native Hawaiian And Other Pacific Islander Alone With One Or More Native Hawaiian And Other Pacific Islander Categories For Selected Groups [14]']
Let's parse more of pieces that are in the fields
In [6]:
# let's just parse sf1.xml ourselves to get the concepts
# http://lxml.de/parsing.html
from lxml import etree
from itertools import islice
import re
def parse_concept_name(concept_name):
if concept_name != 'Geographic Characteristics':
m = re.search("(.+\.)\s+(.*)\s+(\[\d+\])",concept_name)
if m:
return {'label':m.group(1),
'clean_name':m.group(2),
'num_vars':re.search("\[(\d+)\]", m.group(3)).group(1)
}
# print m.groups()
else:
m1 = re.search("(.+\.)\s+(.*)\s+",concept_name)
return {'label':m1.group(1),
'clean_name':m1.group(2),
'num_vars':0
}
else:
return None
def concepts_2010_sf1():
# http://www.census.gov/developers/data/sf1.xml
SF1_XML_PATH = "/Users/raymondyee/D/Document/Working_with_Open_Data/working-open-data-2014/data/sf1.xml"
doc = etree.parse(SF1_XML_PATH)
for concept in doc.findall("//concept"):
concept_name = concept.attrib['name']
if concept_name != 'Geographic Characteristics':
m = re.search("(.+\.)\s+(.*)\s+(\[\d+\])",concept_name)
if m:
yield {'label':m.group(1),
'clean_name':m.group(2),
'num_vars':re.search("\[(\d+)\]", m.group(3)).group(1)
}
# print m.groups()
else:
m1 = re.search("(.+\.)\s+(.*)\s+",concept_name)
yield {'label':m1.group(1),
'clean_name':m1.group(2),
'num_vars':0
}
k = list(concepts_2010_sf1())
In [7]:
df = DataFrame(k, columns=('label','clean_name','num_vars'))
df.head()
Out[7]:
label
clean_name
num_vars
0
H1.
Housing Units
1
1
H10.
TOTAL POPULATION IN OCCUPIED HOUSING UNITS
1
2
H11.
TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ...
4
3
H11A.
TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ...
4
4
H11B.
TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ...
4
5 rows × 3 columns
In [8]:
import re
def sort_label(label):
(l1, l2, l3) = re.search("([A-Z,a-z]+)(\d+)([A-Z,a-z]*)\.",label).groups()
return l1 + " " + "{l2:03d}".format(l2=int(l2)) + l3
df['sort_label'] = df.label.apply(sort_label)
In [9]:
df[df.label.str.startswith("P5")]
Out[9]:
label
clean_name
num_vars
sort_label
232
P5.
HISPANIC OR LATINO ORIGIN BY RACE
17
P 005
233
P50.
ALLOCATION OF RELATIONSHIP
3
P 050
234
P51.
ALLOCATION OF POPULATION ITEMS FOR THE POPULAT...
3
P 051
3 rows × 4 columns
In [10]:
# let's go right for the variables and generate a dict, DF
from lxml import etree
from itertools import islice
from collections import OrderedDict
SF1_XML_PATH = "/Users/raymondyee/D/Document/Working_with_Open_Data/working-open-data-2014/data/sf1.xml"
doc = etree.parse(SF1_XML_PATH)
variables = doc.findall("//variable")
variables_dict = OrderedDict([(v.attrib['name'],
{'concept':v.attrib['concept'],
'text': v.text
}) for v in variables])
In [11]:
variables_dict['P0050001']
Out[11]:
{'concept': 'P5. HISPANIC OR LATINO ORIGIN BY RACE [17]',
'text': ' Total population '}
In [12]:
def P005_range(n0,n1):
return tuple(('P005'+ "{i:04d}".format(i=i) for i in xrange(n0,n1)))
P005_vars = P005_range(1,18)
P005_vars_str = ",".join(P005_vars)
[(v,variables_dict[v]['text']) for v in P005_vars]
Out[12]:
[('P0050001', ' Total population '),
('P0050002', ' Not Hispanic or Latino: '),
('P0050003', ' Not Hispanic or Latino: !! White alone '),
('P0050004', ' Not Hispanic or Latino: !! Black or African American alone '),
('P0050005',
' Not Hispanic or Latino: !! American Indian and Alaska Native alone '),
('P0050006', ' Not Hispanic or Latino: !! Asian alone '),
('P0050007',
' Not Hispanic or Latino: !! Native Hawaiian and Other Pacific Islander alone '),
('P0050008', ' Not Hispanic or Latino: !! Some Other Race alone '),
('P0050009', ' Not Hispanic or Latino: !! Two or More Races '),
('P0050010', ' Hispanic or Latino: '),
('P0050011', ' Hispanic or Latino: !! White alone '),
('P0050012', ' Hispanic or Latino: !! Black or African American alone '),
('P0050013',
' Hispanic or Latino: !! American Indian and Alaska Native alone '),
('P0050014', ' Hispanic or Latino: !! Asian alone '),
('P0050015',
' Hispanic or Latino: !! Native Hawaiian and Other Pacific Islander alone '),
('P0050016', ' Hispanic or Latino: !! Some Other Race alone '),
('P0050017', ' Hispanic or Latino: !! Two or More Races ')]
In [13]:
variables_df = DataFrame(variables_dict)
variables_df.head()
Out[13]:
AIANHHCC
AIANHHFP
AIHHTLI
AITS
AITSCC
AITSCE
ANRC
CBSAPCI
CD113
CNECTA
CONCITSC
GEOCOMP
LOGRECNO
MEMI
METDIV
NAME
NECTADIV
NECTAPCI
PLACECC
SLDL2
concept
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
Geographic Characteristics
...
text
FIPS American Indian Area/Alaska Native Area/...
American Indian Area/Alaska Native Area/Hawai...
American Indian Trust Land/Hawaiian Home Land...
American Indian Tribal Subdivision (FIPS)
FIPS American Indian Tribal Subdivision Class...
American Indian Tribal Subdivision (Census)
Alaska Native Regional Corporation (FIPS)
Metropolitan Statistical Area/Micropolitan St...
Congressional District - 113th Congress
New England City and Town Area
Consolidated City Size Code
Geographic Component
Logical Record Number (State Based Geography ...
Metropolitan/Micropolitan Indicator Flag
Metropolitan Division
Geographic Area Name
New England City and Town Area Division
New England City and Town Area Principal City...
FIPS Place Class Code
State Legislative District Lower
...
2 rows × 8945 columns
In [14]:
variables_df.T.concept.apply(parse_concept_name)
Out[14]:
AIANHHCC None
AIANHHFP None
AIHHTLI None
AITS None
AITSCC None
AITSCE None
ANRC None
CBSAPCI None
CD113 None
CNECTA None
CONCITSC None
GEOCOMP None
LOGRECNO None
MEMI None
METDIV None
...
PCT0080014 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090001 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090002 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090003 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090004 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090005 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090006 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090007 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090008 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090009 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090010 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090011 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090012 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090013 {u'clean_name': u'Native Hawaiian And Other Pa...
PCT0090014 {u'clean_name': u'Native Hawaiian And Other Pa...
Name: concept, Length: 8945, dtype: object
In [15]:
parse_concept_name(variables_dict['P0050001']['concept'])
Out[15]:
{'clean_name': 'HISPANIC OR LATINO ORIGIN BY RACE',
'label': 'P5.',
'num_vars': '17'}
In [16]:
# http://www.census.gov/developers/
import requests
url = "http://api.census.gov/data.json"
api_json = requests.get(url).json()
api_json
Out[16]:
[{u'accessLevel': u'public',
u'c_dataset': [u'acs5'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/2010/acs5/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2010/acs5/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2010/acs5/variables.json',
u'c_vintage': 2010,
u'contactPoint': u'Census Bureau Call Center',
u'description': u"The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter by collecting long form type information throughout the decade rather than only once every 10 years. Questionnaires are mailed to a sample of addresses to obtain information about households -- that is, about each person and the housing unit itself. The American Community Survey produces demographic, social, housing and economic estimates in the form of 1-year, 3-year and 5-year estimates based on population thresholds. The strength of the ACS is in estimating population and housing characteristics. It produces estimates for small areas, including census tracts and population subgroups. Although the ACS produces population, demographic and housing unit estimates,it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns, and estimates of housing units for states and counties. For 2010 and other decennial census years, the Decennial Census provides the official counts of population and housing units.",
u'identifier': u'2010acs5',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2010',
u'title': u'2010 American Community Survey: 5-Year Estimates',
u'webService': u'http://api.census.gov/data/2010/acs5'},
{u'accessLevel': u'public',
u'c_dataset': [u'sf1'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/1990/sf1/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/1990/sf1/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/1990/sf1/variables.json',
u'c_vintage': 1990,
u'contactPoint': u'Census Bureau Call Center',
u'description': u'Data files available from Census 2000 and the 2010 Census. This file presents 100-percent population and housing figures for the total population, for 63 race categories, and for many other race and Hispanic or Latino categories. This includes age, sex, households, household relationship, housing units, occupancy status, and tenure (whether the residence is owned or rented). Also included are selected characteristics for a limited number of race and Hispanic or Latino categories. The data are available for the U.S., regions, divisions, states, counties, county subdivisions, places, census tracts, block groups, blocks, metropolitan areas (2000), core based statistical areas (2010), American Indian and Alaska Native areas, tribal subdivisions, Hawaiian home lands, congressional districts, and ZIP Code Tabulation Areas. Data are available down to the block level for many tabulations, but only to the census-tract level for others. The 2010 Census SF 1 has some tables on the population in group quarters that are available only to the county level. Available on DVD and American FactFinder. The Census 2000 Summary File 1 data were released in three stages. Individual state files and two national files were released. The state-level data were released first, followed by the Advance National File, which covered the same data subjects, but includes national level summary data for areas that cross state boundaries such as whole metropolitan areas, whole American Indian areas, etc. The Final National File contains the same data subjects and geographic areas as the Advance National File, but adds the first available urban/rural and urbanized area data. For the most current release dates for these files, see the "Census 2000 Release Schedule" link on the AFFAmerican FactFinder Main Page. The 2010 Census Summaray File 1 data were released in stages. Individual state files and a national update were released in 2011. The SF 1 urban/rural update is planned for release in Fall 2012. This file contains the same data subjects as the previously released files, but for additional geography, including the urban and rural parts of the United States, regions, divisions, states, counties, and places; and urbanized areas and urban clusters. See the 2010 Census Data Products At A Glance',
u'identifier': u'1990sf1',
u'mbox': u'pio@census.gov',
u'publisher': u'U.S. Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'1990',
u'title': u'1990 Decennial: Summary File 1',
u'webService': u'http://api.census.gov/data/1990/sf1'},
{u'accessLevel': u'public',
u'c_dataset': [u'acs1', u'cd113'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/2011/acs1/cd113/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2011/acs1/cd113/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2011/acs1/cd113/variables.json',
u'c_vintage': 2011,
u'contactPoint': u'Census Bureau Call Center',
u'description': u"The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter by collecting long form type information throughout the decade rather than only once every 10 years. Questionnaires are mailed to a sample of addresses to obtain information about households -- that is, about each person and the housing unit itself. The American Community Survey produces demographic, social, housing and economic estimates in the form of 1-year, 3-year and 5-year estimates based on population thresholds. The strength of the ACS is in estimating population and housing characteristics. It produces estimates for small areas, including census tracts and population subgroups. Although the ACS produces population, demographic and housing unit estimates,it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns, and estimates of housing units for states and counties. For 2010 and other decennial census years, the Decennial Census provides the official counts of population and housing units.",
u'identifier': u'2011acs1cd113',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2011',
u'title': u'2011 American Community Survey: 1-Year Estimates',
u'webService': u'http://api.census.gov/data/2011/acs1/cd113'},
{u'accessLevel': u'public',
u'c_dataset': [u'sf3'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/1990/sf3/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/1990/sf3/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/1990/sf3/variables.json',
u'c_vintage': 1990,
u'contactPoint': u'Census Bureau Call Center',
u'description': u'This Census 2000 file presents data on the population and housing long form subjects such as income and education. It includes population totals for ancestry groups. It also includes selected characteristics for a limited number of race and Hispanic or Latino categories. The data are available for the U.S., regions, divisions, states, counties, county subdivisions, places, census tracts, block groups, metropolitan areas, American Indian and Alaska Native areas, tribal subdivisions, Hawaiian home lands, congressional districts, and Zip Code Tabulation Areas. Available on CD-ROM, DVD, and American FactFinder. After Census 2000, data on these subjects were produced from the American Community Survey or the Puerto Rico Community Survey.',
u'identifier': u'1990sf3',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'1990',
u'title': u'1990 Decennial: Summary File 3',
u'webService': u'http://api.census.gov/data/1990/sf3'},
{u'accessLevel': u'public',
u'c_dataset': [u'acs5', u'profile'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_examplesLink': u'http://api.census.gov/data/2012/acs5/profile/examples.json',
u'c_geographyLink': u'http://api.census.gov/data/2012/acs5/profile/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2012/acs5/profile/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2012/acs5/profile/variables.json',
u'c_vintage': 2012,
u'contactPoint': u'Census Bureau Call Center',
u'description': u"The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter by collecting long form type information throughout the decade rather than only once every 10 years. Questionnaires are mailed to a sample of addresses to obtain information about households -- that is, about each person and the housing unit itself. The American Community Survey produces demographic, social, housing and economic estimates in the form of 1-year, 3-year and 5-year estimates based on population thresholds. The strength of the ACS is in estimating population and housing characteristics. It produces estimates for small areas, including census tracts and population subgroups. Although the ACS produces population, demographic and housing unit estimates,it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns, and estimates of housing units for states and counties. For 2010 and other decennial census years, the Decennial Census provides the official counts of population and housing units.",
u'identifier': u'2012acs5profile',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'spatial': u'US',
u'temporal': u'2012',
u'title': u'2012 American Community Survey: 5-Year Profile Tables',
u'webService': u'http://api.census.gov/data/2012/acs5/profile'},
{u'accessLevel': u'public',
u'c_dataset': [u'sf1'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_examplesLink': u'http://api.census.gov/data/2010/sf1/examples.json',
u'c_geographyLink': u'http://api.census.gov/data/2010/sf1/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2010/sf1/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2010/sf1/variables.json',
u'c_vintage': 2010,
u'contactPoint': u'Census Bureau Call Center',
u'description': u'Data files available from Census 2000 and the 2010 Census. This file presents 100-percent population and housing figures for the total population, for 63 race categories, and for many other race and Hispanic or Latino categories. This includes age, sex, households, household relationship, housing units, occupancy status, and tenure (whether the residence is owned or rented). Also included are selected characteristics for a limited number of race and Hispanic or Latino categories. The data are available for the U.S., regions, divisions, states, counties, county subdivisions, places, census tracts, block groups, blocks, metropolitan areas (2000), core based statistical areas (2010), American Indian and Alaska Native areas, tribal subdivisions, Hawaiian home lands, congressional districts, and ZIP Code Tabulation Areas. Data are available down to the block level for many tabulations, but only to the census-tract level for others. The 2010 Census SF 1 has some tables on the population in group quarters that are available only to the county level. Available on DVD and American FactFinder. The Census 2000 Summary File 1 data were released in three stages. Individual state files and two national files were released. The state-level data were released first, followed by the Advance National File, which covered the same data subjects, but includes national level summary data for areas that cross state boundaries such as whole metropolitan areas, whole American Indian areas, etc. The Final National File contains the same data subjects and geographic areas as the Advance National File, but adds the first available urban/rural and urbanized area data. For the most current release dates for these files, see the "Census 2000 Release Schedule" link on the AFFAmerican FactFinder Main Page. The 2010 Census Summaray File 1 data were released in stages. Individual state files and a national update were released in 2011. The SF 1 urban/rural update is planned for release in Fall 2012. This file contains the same data subjects as the previously released files, but for additional geography, including the urban and rural parts of the United States, regions, divisions, states, counties, and places; and urbanized areas and urban clusters. See the 2010 Census Data Products At A Glance',
u'identifier': u'2010sf1',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2010',
u'title': u'2010 Decennial: Summary File 1',
u'webService': u'http://api.census.gov/data/2010/sf1'},
{u'accessLevel': u'public',
u'c_dataset': [u'sf3'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/2000/sf3/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2000/sf3/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2000/sf3/variables.json',
u'c_vintage': 2000,
u'contactPoint': u'Census Bureau Call Center',
u'description': u'This Census 2000 file presents data on the population and housing long form subjects such as income and education. It includes population totals for ancestry groups. It also includes selected characteristics for a limited number of race and Hispanic or Latino categories. The data are available for the U.S., regions, divisions, states, counties, county subdivisions, places, census tracts, block groups, metropolitan areas, American Indian and Alaska Native areas, tribal subdivisions, Hawaiian home lands, congressional districts, and Zip Code Tabulation Areas. Available on CD-ROM, DVD, and American FactFinder. After Census 2000, data on these subjects were produced from the American Community Survey or the Puerto Rico Community Survey.',
u'identifier': u'2000sf3',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2000',
u'title': u'2000 Decennial: Summary File 3',
u'webService': u'http://api.census.gov/data/2000/sf3'},
{u'accessLevel': u'public',
u'c_dataset': [u'acs1'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/2012/acs1/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2012/acs1/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2012/acs1/variables.json',
u'c_vintage': 2012,
u'contactPoint': u'Census Bureau Call Center',
u'description': u"The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter by collecting long form type information throughout the decade rather than only once every 10 years. Questionnaires are mailed to a sample of addresses to obtain information about households -- that is, about each person and the housing unit itself. The American Community Survey produces demographic, social, housing and economic estimates in the form of 1-year, 3-year and 5-year estimates based on population thresholds. The strength of the ACS is in estimating population and housing characteristics. It produces estimates for small areas, including census tracts and population subgroups. Although the ACS produces population, demographic and housing unit estimates,it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns, and estimates of housing units for states and counties. For 2010 and other decennial census years, the Decennial Census provides the official counts of population and housing units.",
u'identifier': u'2012acs1',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2012',
u'title': u'2012 American Community Survey: 1-Year Estimates',
u'webService': u'http://api.census.gov/data/2012/acs1'},
{u'accessLevel': u'public',
u'c_dataset': [u'acs3'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/2012/acs3/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2012/acs3/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2012/acs3/variables.json',
u'c_vintage': 2012,
u'contactPoint': u'Census Bureau Call Center',
u'description': u"The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter by collecting long form type information throughout the decade rather than only once every 10 years. Questionnaires are mailed to a sample of addresses to obtain information about households -- that is, about each person and the housing unit itself. The American Community Survey produces demographic, social, housing and economic estimates in the form of 1-year, 3-year and 5-year estimates based on population thresholds. The strength of the ACS is in estimating population and housing characteristics. It produces estimates for small areas, including census tracts and population subgroups. Although the ACS produces population, demographic and housing unit estimates,it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns, and estimates of housing units for states and counties. For 2010 and other decennial census years, the Decennial Census provides the official counts of population and housing units.",
u'identifier': u'2012acs3',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2012',
u'title': u'2012 American Community Survey: 3-Year Estimates',
u'webService': u'http://api.census.gov/data/2012/acs3'},
{u'accessLevel': u'public',
u'c_dataset': [u'acs5'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/2011/acs5/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2011/acs5/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2011/acs5/variables.json',
u'c_vintage': 2011,
u'contactPoint': u'Census Bureau Call Center',
u'description': u"The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter by collecting long form type information throughout the decade rather than only once every 10 years. Questionnaires are mailed to a sample of addresses to obtain information about households -- that is, about each person and the housing unit itself. The American Community Survey produces demographic, social, housing and economic estimates in the form of 1-year, 3-year and 5-year estimates based on population thresholds. The strength of the ACS is in estimating population and housing characteristics. It produces estimates for small areas, including census tracts and population subgroups. Although the ACS produces population, demographic and housing unit estimates,it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns, and estimates of housing units for states and counties. For 2010 and other decennial census years, the Decennial Census provides the official counts of population and housing units.",
u'identifier': u'2011acs5',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2011',
u'title': u'2011 American Community Survey: 5-Year Estimates',
u'webService': u'http://api.census.gov/data/2011/acs5'},
{u'accessLevel': u'public',
u'c_dataset': [u'acs5'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_examplesLink': u'http://api.census.gov/data/2012/acs5/examples.json',
u'c_geographyLink': u'http://api.census.gov/data/2012/acs5/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2012/acs5/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2012/acs5/variables.json',
u'c_vintage': 2012,
u'contactPoint': u'Census Bureau Call Center',
u'description': u"The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter by collecting long form type information throughout the decade rather than only once every 10 years. Questionnaires are mailed to a sample of addresses to obtain information about households -- that is, about each person and the housing unit itself. The American Community Survey produces demographic, social, housing and economic estimates in the form of 1-year, 3-year and 5-year estimates based on population thresholds. The strength of the ACS is in estimating population and housing characteristics. It produces estimates for small areas, including census tracts and population subgroups. Although the ACS produces population, demographic and housing unit estimates,it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns, and estimates of housing units for states and counties. For 2010 and other decennial census years, the Decennial Census provides the official counts of population and housing units.",
u'identifier': u'2012acs5',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2012',
u'title': u'2012 American Community Survey: 5-Year Estimates',
u'webService': u'http://api.census.gov/data/2012/acs5'},
{u'accessLevel': u'public',
u'c_dataset': [u'acs1', u'profile'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/2012/acs1/profile/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2012/acs1/profile/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2012/acs1/profile/variables.json',
u'c_vintage': 2012,
u'contactPoint': u'Census Bureau Call Center',
u'description': u"The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter by collecting long form type information throughout the decade rather than only once every 10 years. Questionnaires are mailed to a sample of addresses to obtain information about households -- that is, about each person and the housing unit itself. The American Community Survey produces demographic, social, housing and economic estimates in the form of 1-year, 3-year and 5-year estimates based on population thresholds. The strength of the ACS is in estimating population and housing characteristics. It produces estimates for small areas, including census tracts and population subgroups. Although the ACS produces population, demographic and housing unit estimates,it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns, and estimates of housing units for states and counties. For 2010 and other decennial census years, the Decennial Census provides the official counts of population and housing units.",
u'identifier': u'2012acs1profile',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2012',
u'title': u'2012 American Community Survey: 1-Year Profile Tables',
u'webService': u'http://api.census.gov/data/2012/acs1/profile'},
{u'accessLevel': u'public',
u'c_dataset': [u'acs3', u'profile'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/2012/acs3/profile/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2012/acs3/profile/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2012/acs3/profile/variables.json',
u'c_vintage': 2012,
u'contactPoint': u'Census Bureau Call Center',
u'description': u"The American Community Survey (ACS) is a nationwide survey designed to provide communities a fresh look at how they are changing. The ACS replaced the decennial census long form in 2010 and thereafter by collecting long form type information throughout the decade rather than only once every 10 years. Questionnaires are mailed to a sample of addresses to obtain information about households -- that is, about each person and the housing unit itself. The American Community Survey produces demographic, social, housing and economic estimates in the form of 1-year, 3-year and 5-year estimates based on population thresholds. The strength of the ACS is in estimating population and housing characteristics. It produces estimates for small areas, including census tracts and population subgroups. Although the ACS produces population, demographic and housing unit estimates,it is the Census Bureau's Population Estimates Program that produces and disseminates the official estimates of the population for the nation, states, counties, cities and towns, and estimates of housing units for states and counties. For 2010 and other decennial census years, the Decennial Census provides the official counts of population and housing units.",
u'identifier': u'2012acs3profile',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2012',
u'title': u'2012 American Community Survey: 3-Year Profile Tables',
u'webService': u'http://api.census.gov/data/2012/acs3/profile'},
{u'accessLevel': u'public',
u'c_dataset': [u'sf1'],
u'c_documentationLink': u'http://www.census.gov/developers/',
u'c_geographyLink': u'http://api.census.gov/data/2000/sf1/geography.json',
u'c_isAggregate': True,
u'c_tagsLink': u'http://api.census.gov/data/2000/sf1/tags.json',
u'c_variablesLink': u'http://api.census.gov/data/2000/sf1/variables.json',
u'c_vintage': 2000,
u'contactPoint': u'Census Bureau Call Center',
u'description': u'Data files available from Census 2000 and the 2010 Census. This file presents 100-percent population and housing figures for the total population, for 63 race categories, and for many other race and Hispanic or Latino categories. This includes age, sex, households, household relationship, housing units, occupancy status, and tenure (whether the residence is owned or rented). Also included are selected characteristics for a limited number of race and Hispanic or Latino categories. The data are available for the U.S., regions, divisions, states, counties, county subdivisions, places, census tracts, block groups, blocks, metropolitan areas (2000), core based statistical areas (2010), American Indian and Alaska Native areas, tribal subdivisions, Hawaiian home lands, congressional districts, and ZIP Code Tabulation Areas. Data are available down to the block level for many tabulations, but only to the census-tract level for others. The 2010 Census SF 1 has some tables on the population in group quarters that are available only to the county level. Available on DVD and American FactFinder. The Census 2000 Summary File 1 data were released in three stages. Individual state files and two national files were released. The state-level data were released first, followed by the Advance National File, which covered the same data subjects, but includes national level summary data for areas that cross state boundaries such as whole metropolitan areas, whole American Indian areas, etc. The Final National File contains the same data subjects and geographic areas as the Advance National File, but adds the first available urban/rural and urbanized area data. For the most current release dates for these files, see the "Census 2000 Release Schedule" link on the AFFAmerican FactFinder Main Page. The 2010 Census Summaray File 1 data were released in stages. Individual state files and a national update were released in 2011. The SF 1 urban/rural update is planned for release in Fall 2012. This file contains the same data subjects as the previously released files, but for additional geography, including the urban and rural parts of the United States, regions, divisions, states, counties, and places; and urbanized areas and urban clusters. See the 2010 Census Data Products At A Glance',
u'identifier': u'2000sf1',
u'mbox': u'pio@census.gov',
u'publisher': u'US Census Bureau',
u'references': [u'http://www.census.gov/developers/'],
u'spatial': u'US',
u'temporal': u'2000',
u'title': u'2000 Decennial: Summary File 1',
u'webService': u'http://api.census.gov/data/2000/sf1'}]
In [17]:
len(api_json)
Out[17]:
14
In [18]:
[(api['c_vintage'], api['c_dataset'], api['c_variablesLink']) for api in api_json]
Out[18]:
[(2010, [u'acs5'], u'http://api.census.gov/data/2010/acs5/variables.json'),
(1990, [u'sf1'], u'http://api.census.gov/data/1990/sf1/variables.json'),
(2011,
[u'acs1', u'cd113'],
u'http://api.census.gov/data/2011/acs1/cd113/variables.json'),
(1990, [u'sf3'], u'http://api.census.gov/data/1990/sf3/variables.json'),
(2012,
[u'acs5', u'profile'],
u'http://api.census.gov/data/2012/acs5/profile/variables.json'),
(2010, [u'sf1'], u'http://api.census.gov/data/2010/sf1/variables.json'),
(2000, [u'sf3'], u'http://api.census.gov/data/2000/sf3/variables.json'),
(2012, [u'acs1'], u'http://api.census.gov/data/2012/acs1/variables.json'),
(2012, [u'acs3'], u'http://api.census.gov/data/2012/acs3/variables.json'),
(2011, [u'acs5'], u'http://api.census.gov/data/2011/acs5/variables.json'),
(2012, [u'acs5'], u'http://api.census.gov/data/2012/acs5/variables.json'),
(2012,
[u'acs1', u'profile'],
u'http://api.census.gov/data/2012/acs1/profile/variables.json'),
(2012,
[u'acs3', u'profile'],
u'http://api.census.gov/data/2012/acs3/profile/variables.json'),
(2000, [u'sf1'], u'http://api.census.gov/data/2000/sf1/variables.json')]
In [19]:
import requests
url = "http://api.census.gov/data/2010/sf1/variables.json"
var_json = requests.get(url).json()
sorted(var_json['variables'].keys())
Out[19]:
[u'AIANHH',
u'AIANHHCC',
u'AIANHHFP',
u'AIHHTLI',
u'AITS',
u'AITSCC',
u'AITSCE',
u'ANRC',
u'BLKGRP',
u'BLOCK',
u'CBSA',
u'CBSAPCI',
u'CD',
u'CD113',
u'CNECTA',
u'CONCIT',
u'CONCITSC',
u'COUNTY',
u'COUSUB',
u'CSA',
u'DIVISION',
u'GEOCOMP',
u'H00010001',
u'H0020001',
u'H0020002',
u'H0020003',
u'H0020004',
u'H0020005',
u'H0020006',
u'H0030001',
u'H0030002',
u'H0030003',
u'H0040001',
u'H0040002',
u'H0040003',
u'H0040004',
u'H0050001',
u'H0050002',
u'H0050003',
u'H0050004',
u'H0050005',
u'H0050006',
u'H0050007',
u'H0050008',
u'H0060001',
u'H0060002',
u'H0060003',
u'H0060004',
u'H0060005',
u'H0060006',
u'H0060007',
u'H0060008',
u'H0070001',
u'H0070002',
u'H0070003',
u'H0070004',
u'H0070005',
u'H0070006',
u'H0070007',
u'H0070008',
u'H0070009',
u'H0070010',
u'H0070011',
u'H0070012',
u'H0070013',
u'H0070014',
u'H0070015',
u'H0070016',
u'H0070017',
u'H0080001',
u'H0080002',
u'H0080003',
u'H0080004',
u'H0080005',
u'H0080006',
u'H0080007',
u'H0090001',
u'H0090002',
u'H0090003',
u'H0090004',
u'H0090005',
u'H0090006',
u'H0090007',
u'H0090008',
u'H0090009',
u'H0090010',
u'H0090011',
u'H0090012',
u'H0090013',
u'H0090014',
u'H0090015',
u'H0100001',
u'H0110001',
u'H0110002',
u'H0110003',
u'H0110004',
u'H011A0001',
u'H011A0002',
u'H011A0003',
u'H011A0004',
u'H011B0001',
u'H011B0002',
u'H011B0003',
u'H011B0004',
u'H011C0001',
u'H011C0002',
u'H011C0003',
u'H011C0004',
u'H011D0001',
u'H011D0002',
u'H011D0003',
u'H011D0004',
u'H011E0001',
u'H011E0002',
u'H011E0003',
u'H011E0004',
u'H011F0001',
u'H011F0002',
u'H011F0003',
u'H011F0004',
u'H011G0001',
u'H011G0002',
u'H011G0003',
u'H011G0004',
u'H011H0001',
u'H011H0002',
u'H011H0003',
u'H011H0004',
u'H011I0001',
u'H011I0002',
u'H011I0003',
u'H011I0004',
u'H0120001',
u'H0120002',
u'H0120003',
u'H012A0001',
u'H012A0002',
u'H012A0003',
u'H012B0001',
u'H012B0002',
u'H012B0003',
u'H012C0001',
u'H012C0002',
u'H012C0003',
u'H012D0001',
u'H012D0002',
u'H012D0003',
u'H012E0001',
u'H012E0002',
u'H012E0003',
u'H012F0001',
u'H012F0002',
u'H012F0003',
u'H012G0001',
u'H012G0002',
u'H012G0003',
u'H012H0001',
u'H012H0002',
u'H012H0003',
u'H012I0001',
u'H012I0002',
u'H012I0003',
u'H0130001',
u'H0130002',
u'H0130003',
u'H0130004',
u'H0130005',
u'H0130006',
u'H0130007',
u'H0130008',
u'H0140001',
u'H0140002',
u'H0140003',
u'H0140004',
u'H0140005',
u'H0140006',
u'H0140007',
u'H0140008',
u'H0140009',
u'H0140010',
u'H0140011',
u'H0140012',
u'H0140013',
u'H0140014',
u'H0140015',
u'H0140016',
u'H0140017',
u'H0150001',
u'H0150002',
u'H0150003',
u'H0150004',
u'H0150005',
u'H0150006',
u'H0150007',
u'H0160001',
u'H0160002',
u'H0160003',
u'H0160004',
u'H0160005',
u'H0160006',
u'H0160007',
u'H0160008',
u'H0160009',
u'H0160010',
u'H0160011',
u'H0160012',
u'H0160013',
u'H0160014',
u'H0160015',
u'H0160016',
u'H0160017',
u'H016A0001',
u'H016A0002',
u'H016A0003',
u'H016A0004',
u'H016A0005',
u'H016A0006',
u'H016A0007',
u'H016A0008',
u'H016A0009',
u'H016A0010',
u'H016A0011',
u'H016A0012',
u'H016A0013',
u'H016A0014',
u'H016A0015',
u'H016A0016',
u'H016A0017',
u'H016B0001',
u'H016B0002',
u'H016B0003',
u'H016B0004',
u'H016B0005',
u'H016B0006',
u'H016B0007',
u'H016B0008',
u'H016B0009',
u'H016B0010',
u'H016B0011',
u'H016B0012',
u'H016B0013',
u'H016B0014',
u'H016B0015',
u'H016B0016',
u'H016B0017',
u'H016C0001',
u'H016C0002',
u'H016C0003',
u'H016C0004',
u'H016C0005',
u'H016C0006',
u'H016C0007',
u'H016C0008',
u'H016C0009',
u'H016C0010',
u'H016C0011',
u'H016C0012',
u'H016C0013',
u'H016C0014',
u'H016C0015',
u'H016C0016',
u'H016C0017',
u'H016D0001',
u'H016D0002',
u'H016D0003',
u'H016D0004',
u'H016D0005',
u'H016D0006',
u'H016D0007',
u'H016D0008',
u'H016D0009',
u'H016D0010',
u'H016D0011',
u'H016D0012',
u'H016D0013',
u'H016D0014',
u'H016D0015',
u'H016D0016',
u'H016D0017',
u'H016E0001',
u'H016E0002',
u'H016E0003',
u'H016E0004',
u'H016E0005',
u'H016E0006',
u'H016E0007',
u'H016E0008',
u'H016E0009',
u'H016E0010',
u'H016E0011',
u'H016E0012',
u'H016E0013',
u'H016E0014',
u'H016E0015',
u'H016E0016',
u'H016E0017',
u'H016F0001',
u'H016F0002',
u'H016F0003',
u'H016F0004',
u'H016F0005',
u'H016F0006',
u'H016F0007',
u'H016F0008',
u'H016F0009',
u'H016F0010',
u'H016F0011',
u'H016F0012',
u'H016F0013',
u'H016F0014',
u'H016F0015',
u'H016F0016',
u'H016F0017',
u'H016G0001',
u'H016G0002',
u'H016G0003',
u'H016G0004',
u'H016G0005',
u'H016G0006',
u'H016G0007',
u'H016G0008',
u'H016G0009',
u'H016G0010',
u'H016G0011',
u'H016G0012',
u'H016G0013',
u'H016G0014',
u'H016G0015',
u'H016G0016',
u'H016G0017',
u'H016H0001',
u'H016H0002',
u'H016H0003',
u'H016H0004',
u'H016H0005',
u'H016H0006',
u'H016H0007',
u'H016H0008',
u'H016H0009',
u'H016H0010',
u'H016H0011',
u'H016H0012',
u'H016H0013',
u'H016H0014',
u'H016H0015',
u'H016H0016',
u'H016H0017',
u'H016I0001',
u'H016I0002',
u'H016I0003',
u'H016I0004',
u'H016I0005',
u'H016I0006',
u'H016I0007',
u'H016I0008',
u'H016I0009',
u'H016I0010',
u'H016I0011',
u'H016I0012',
u'H016I0013',
u'H016I0014',
u'H016I0015',
u'H016I0016',
u'H016I0017',
u'H0170001',
u'H0170002',
u'H0170003',
u'H0170004',
u'H0170005',
u'H0170006',
u'H0170007',
u'H0170008',
u'H0170009',
u'H0170010',
u'H0170011',
u'H0170012',
u'H0170013',
u'H0170014',
u'H0170015',
u'H0170016',
u'H0170017',
u'H0170018',
u'H0170019',
u'H0170020',
u'H0170021',
u'H017A0001',
u'H017A0002',
u'H017A0003',
u'H017A0004',
u'H017A0005',
u'H017A0006',
u'H017A0007',
u'H017A0008',
u'H017A0009',
u'H017A0010',
u'H017A0011',
u'H017A0012',
u'H017A0013',
u'H017A0014',
u'H017A0015',
u'H017A0016',
u'H017A0017',
u'H017A0018',
u'H017A0019',
u'H017A0020',
u'H017A0021',
u'H017B0001',
u'H017B0002',
u'H017B0003',
u'H017B0004',
u'H017B0005',
u'H017B0006',
u'H017B0007',
u'H017B0008',
u'H017B0009',
u'H017B0010',
u'H017B0011',
u'H017B0012',
u'H017B0013',
u'H017B0014',
u'H017B0015',
u'H017B0016',
u'H017B0017',
u'H017B0018',
u'H017B0019',
u'H017B0020',
u'H017B0021',
u'H017C0001',
u'H017C0002',
u'H017C0003',
u'H017C0004',
u'H017C0005',
u'H017C0006',
u'H017C0007',
u'H017C0008',
u'H017C0009',
u'H017C0010',
u'H017C0011',
u'H017C0012',
u'H017C0013',
u'H017C0014',
u'H017C0015',
u'H017C0016',
u'H017C0017',
u'H017C0018',
u'H017C0019',
u'H017C0020',
u'H017C0021',
u'H017D0001',
u'H017D0002',
u'H017D0003',
u'H017D0004',
u'H017D0005',
u'H017D0006',
u'H017D0007',
u'H017D0008',
u'H017D0009',
u'H017D0010',
u'H017D0011',
u'H017D0012',
u'H017D0013',
u'H017D0014',
u'H017D0015',
u'H017D0016',
u'H017D0017',
u'H017D0018',
u'H017D0019',
u'H017D0020',
u'H017D0021',
u'H017E0001',
u'H017E0002',
u'H017E0003',
u'H017E0004',
u'H017E0005',
u'H017E0006',
u'H017E0007',
u'H017E0008',
u'H017E0009',
u'H017E0010',
u'H017E0011',
u'H017E0012',
u'H017E0013',
u'H017E0014',
u'H017E0015',
u'H017E0016',
u'H017E0017',
u'H017E0018',
u'H017E0019',
u'H017E0020',
u'H017E0021',
u'H017F0001',
u'H017F0002',
u'H017F0003',
u'H017F0004',
u'H017F0005',
u'H017F0006',
u'H017F0007',
u'H017F0008',
u'H017F0009',
u'H017F0010',
u'H017F0011',
u'H017F0012',
u'H017F0013',
u'H017F0014',
u'H017F0015',
u'H017F0016',
u'H017F0017',
u'H017F0018',
u'H017F0019',
u'H017F0020',
u'H017F0021',
u'H017G0001',
u'H017G0002',
u'H017G0003',
u'H017G0004',
u'H017G0005',
u'H017G0006',
u'H017G0007',
u'H017G0008',
u'H017G0009',
u'H017G0010',
u'H017G0011',
u'H017G0012',
u'H017G0013',
u'H017G0014',
u'H017G0015',
u'H017G0016',
u'H017G0017',
u'H017G0018',
u'H017G0019',
u'H017G0020',
u'H017G0021',
u'H017H0001',
u'H017H0002',
u'H017H0003',
u'H017H0004',
u'H017H0005',
u'H017H0006',
u'H017H0007',
u'H017H0008',
u'H017H0009',
u'H017H0010',
u'H017H0011',
u'H017H0012',
u'H017H0013',
u'H017H0014',
u'H017H0015',
u'H017H0016',
u'H017H0017',
u'H017H0018',
u'H017H0019',
u'H017H0020',
u'H017H0021',
u'H017I0001',
u'H017I0002',
u'H017I0003',
u'H017I0004',
u'H017I0005',
u'H017I0006',
u'H017I0007',
u'H017I0008',
u'H017I0009',
u'H017I0010',
u'H017I0011',
u'H017I0012',
u'H017I0013',
u'H017I0014',
u'H017I0015',
u'H017I0016',
u'H017I0017',
u'H017I0018',
u'H017I0019',
u'H017I0020',
u'H017I0021',
u'H0180001',
u'H0180002',
u'H0180003',
u'H0180004',
u'H0180005',
u'H0180006',
u'H0180007',
u'H0180008',
u'H0180009',
u'H0180010',
u'H0180011',
u'H0180012',
u'H0180013',
u'H0180014',
u'H0180015',
u'H0180016',
u'H0180017',
u'H0180018',
u'H0180019',
u'H0180020',
u'H0180021',
u'H0180022',
u'H0180023',
u'H0180024',
u'H0180025',
u'H0180026',
u'H0180027',
u'H0180028',
u'H0180029',
u'H0180030',
u'H0180031',
u'H0180032',
u'H0180033',
u'H0180034',
u'H0180035',
u'H0180036',
u'H0180037',
u'H0180038',
u'H0180039',
u'H0180040',
u'H0180041',
u'H0180042',
u'H0180043',
u'H0180044',
u'H0180045',
u'H0180046',
u'H0180047',
u'H0180048',
u'H0180049',
u'H0180050',
u'H0180051',
u'H0180052',
u'H0180053',
u'H0180054',
u'H0180055',
u'H0180056',
u'H0180057',
u'H0180058',
u'H0180059',
u'H0180060',
u'H0180061',
u'H0180062',
u'H0180063',
u'H0180064',
u'H0180065',
u'H0180066',
u'H0180067',
u'H0180068',
u'H0180069',
u'H0190001',
u'H0190002',
u'H0190003',
u'H0190004',
u'H0190005',
u'H0190006',
u'H0190007',
u'H0200001',
u'H0200002',
u'H0200003',
u'H0210001',
u'H0210002',
u'H0210003',
u'H0220001',
u'H0220002',
u'H0220003',
u'HCT0010001',
u'HCT0010002',
u'HCT0010003',
u'HCT0010004',
u'HCT0010005',
u'HCT0010006',
u'HCT0010007',
u'HCT0010008',
u'HCT0010009',
u'HCT0010010',
u'HCT0010011',
u'HCT0010012',
u'HCT0010013',
u'HCT0010014',
u'HCT0010015',
u'HCT0010016',
u'HCT0010017',
u'HCT0010018',
u'HCT0010019',
u'HCT0010020',
u'HCT0010021',
u'HCT0010022',
u'HCT0010023',
u'HCT0010024',
u'HCT0010025',
u'HCT0010026',
u'HCT0010027',
u'HCT0010028',
u'HCT0010029',
u'HCT0010030',
u'HCT0010031',
u'HCT0010032',
u'HCT0010033',
u'HCT0010034',
u'HCT0010035',
u'HCT0020001',
u'HCT0020002',
u'HCT0020003',
u'HCT0020004',
u'HCT0020005',
u'HCT0020006',
u'HCT0020007',
u'HCT0020008',
u'HCT0020009',
u'HCT0020010',
u'HCT0020011',
u'HCT0020012',
u'HCT0020013',
u'HCT0030001',
u'HCT0030002',
u'HCT0030003',
u'HCT0030004',
u'HCT0030005',
u'HCT0030006',
u'HCT0030007',
u'HCT0030008',
u'HCT0030009',
u'HCT0030010',
u'HCT0030011',
u'HCT0030012',
u'HCT0030013',
u'HCT0040001',
u'HCT0040002',
u'HCT0040003',
u'HCT0040004',
u'HCT0040005',
u'HCT0040006',
u'HCT0040007',
u'HCT0040008',
u'HCT0040009',
u'HCT0040010',
u'HCT0040011',
u'HCT0040012',
u'HCT0040013',
u'LOGRECNO',
u'MEMI',
u'METDIV',
u'NAME',
u'NECTA',
u'NECTADIV',
u'NECTAPCI',
u'P0010001',
u'P0020001',
u'P0020002',
u'P0020003',
u'P0020004',
u'P0020005',
u'P0020006',
u'P0030001',
u'P0030002',
u'P0030003',
u'P0030004',
u'P0030005',
u'P0030006',
u'P0030007',
u'P0030008',
u'P0040001',
u'P0040002',
u'P0040003',
u'P0050001',
u'P0050002',
u'P0050003',
u'P0050004',
u'P0050005',
u'P0050006',
u'P0050007',
u'P0050008',
u'P0050009',
u'P0050010',
u'P0050011',
u'P0050012',
u'P0050013',
u'P0050014',
u'P0050015',
u'P0050016',
u'P0050017',
u'P0060001',
u'P0060002',
u'P0060003',
u'P0060004',
u'P0060005',
u'P0060006',
u'P0060007',
u'P0070001',
u'P0070002',
u'P0070003',
u'P0070004',
u'P0070005',
u'P0070006',
u'P0070007',
u'P0070008',
u'P0070009',
u'P0070010',
u'P0070011',
u'P0070012',
u'P0070013',
u'P0070014',
u'P0070015',
u'P0080001',
u'P0080002',
u'P0080003',
u'P0080004',
u'P0080005',
u'P0080006',
u'P0080007',
u'P0080008',
u'P0080009',
u'P0080010',
u'P0080011',
u'P0080012',
u'P0080013',
u'P0080014',
u'P0080015',
u'P0080016',
u'P0080017',
u'P0080018',
u'P0080019',
u'P0080020',
u'P0080021',
u'P0080022',
u'P0080023',
u'P0080024',
u'P0080025',
u'P0080026',
u'P0080027',
u'P0080028',
u'P0080029',
u'P0080030',
u'P0080031',
u'P0080032',
u'P0080033',
u'P0080034',
u'P0080035',
u'P0080036',
u'P0080037',
u'P0080038',
u'P0080039',
u'P0080040',
u'P0080041',
u'P0080042',
u'P0080043',
u'P0080044',
u'P0080045',
u'P0080046',
u'P0080047',
u'P0080048',
u'P0080049',
u'P0080050',
u'P0080051',
u'P0080052',
u'P0080053',
u'P0080054',
u'P0080055',
u'P0080056',
u'P0080057',
u'P0080058',
u'P0080059',
u'P0080060',
u'P0080061',
u'P0080062',
u'P0080063',
u'P0080064',
u'P0080065',
u'P0080066',
u'P0080067',
u'P0080068',
u'P0080069',
u'P0080070',
u'P0080071',
u'P0090001',
u'P0090002',
u'P0090003',
u'P0090004',
u'P0090005',
u'P0090006',
u'P0090007',
u'P0090008',
u'P0090009',
u'P0090010',
u'P0090011',
u'P0090012',
u'P0090013',
u'P0090014',
u'P0090015',
u'P0090016',
u'P0090017',
u'P0090018',
u'P0090019',
u'P0090020',
u'P0090021',
u'P0090022',
u'P0090023',
u'P0090024',
u'P0090025',
u'P0090026',
u'P0090027',
u'P0090028',
u'P0090029',
u'P0090030',
u'P0090031',
u'P0090032',
u'P0090033',
u'P0090034',
u'P0090035',
u'P0090036',
u'P0090037',
u'P0090038',
u'P0090039',
u'P0090040',
u'P0090041',
u'P0090042',
u'P0090043',
u'P0090044',
u'P0090045',
u'P0090046',
u'P0090047',
u'P0090048',
u'P0090049',
u'P0090050',
u'P0090051',
u'P0090052',
u'P0090053',
u'P0090054',
u'P0090055',
u'P0090056',
u'P0090057',
u'P0090058',
u'P0090059',
u'P0090060',
u'P0090061',
u'P0090062',
u'P0090063',
u'P0090064',
u'P0090065',
u'P0090066',
u'P0090067',
u'P0090068',
u'P0090069',
u'P0090070',
u'P0090071',
u'P0090072',
u'P0090073',
u'P0100001',
u'P0100002',
u'P0100003',
u'P0100004',
u'P0100005',
u'P0100006',
u'P0100007',
u'P0100008',
u'P0100009',
u'P0100010',
u'P0100011',
u'P0100012',
u'P0100013',
u'P0100014',
u'P0100015',
u'P0100016',
u'P0100017',
u'P0100018',
u'P0100019',
u'P0100020',
u'P0100021',
u'P0100022',
u'P0100023',
u'P0100024',
u'P0100025',
u'P0100026',
u'P0100027',
u'P0100028',
u'P0100029',
u'P0100030',
u'P0100031',
u'P0100032',
u'P0100033',
u'P0100034',
u'P0100035',
u'P0100036',
u'P0100037',
u'P0100038',
u'P0100039',
u'P0100040',
u'P0100041',
u'P0100042',
u'P0100043',
u'P0100044',
u'P0100045',
u'P0100046',
u'P0100047',
u'P0100048',
u'P0100049',
u'P0100050',
u'P0100051',
u'P0100052',
u'P0100053',
u'P0100054',
u'P0100055',
u'P0100056',
u'P0100057',
u'P0100058',
u'P0100059',
u'P0100060',
u'P0100061',
u'P0100062',
u'P0100063',
u'P0100064',
u'P0100065',
u'P0100066',
u'P0100067',
u'P0100068',
u'P0100069',
u'P0100070',
u'P0100071',
u'P0110001',
u'P0110002',
u'P0110003',
u'P0110004',
u'P0110005',
u'P0110006',
u'P0110007',
u'P0110008',
u'P0110009',
u'P0110010',
u'P0110011',
u'P0110012',
u'P0110013',
u'P0110014',
u'P0110015',
u'P0110016',
u'P0110017',
u'P0110018',
u'P0110019',
u'P0110020',
u'P0110021',
u'P0110022',
u'P0110023',
u'P0110024',
u'P0110025',
u'P0110026',
u'P0110027',
u'P0110028',
u'P0110029',
u'P0110030',
u'P0110031',
u'P0110032',
u'P0110033',
u'P0110034',
u'P0110035',
u'P0110036',
u'P0110037',
u'P0110038',
u'P0110039',
u'P0110040',
u'P0110041',
u'P0110042',
u'P0110043',
u'P0110044',
u'P0110045',
u'P0110046',
u'P0110047',
u'P0110048',
u'P0110049',
u'P0110050',
u'P0110051',
u'P0110052',
u'P0110053',
u'P0110054',
u'P0110055',
u'P0110056',
u'P0110057',
u'P0110058',
u'P0110059',
u'P0110060',
u'P0110061',
u'P0110062',
u'P0110063',
u'P0110064',
u'P0110065',
u'P0110066',
u'P0110067',
u'P0110068',
u'P0110069',
u'P0110070',
u'P0110071',
u'P0110072',
u'P0110073',
u'P0120001',
u'P0120002',
u'P0120003',
u'P0120004',
u'P0120005',
u'P0120006',
u'P0120007',
u'P0120008',
u'P0120009',
u'P0120010',
u'P0120011',
u'P0120012',
u'P0120013',
u'P0120014',
u'P0120015',
u'P0120016',
u'P0120017',
u'P0120018',
u'P0120019',
u'P0120020',
u'P0120021',
u'P0120022',
u'P0120023',
u'P0120024',
u'P0120025',
u'P0120026',
u'P0120027',
u'P0120028',
u'P0120029',
u'P0120030',
u'P0120031',
u'P0120032',
u'P0120033',
u'P0120034',
u'P0120035',
u'P0120036',
u'P0120037',
u'P0120038',
u'P0120039',
u'P0120040',
u'P0120041',
u'P0120042',
u'P0120043',
u'P0120044',
u'P0120045',
u'P0120046',
u'P0120047',
u'P0120048',
u'P0120049',
u'P012A001',
u'P012A002',
u'P012A003',
u'P012A004',
u'P012A005',
u'P012A006',
u'P012A007',
u'P012A008',
u'P012A009',
u'P012A010',
u'P012A011',
u'P012A012',
u'P012A013',
u'P012A014',
u'P012A015',
u'P012A016',
u'P012A017',
u'P012A018',
u'P012A019',
u'P012A020',
u'P012A021',
u'P012A022',
u'P012A023',
u'P012A024',
u'P012A025',
u'P012A026',
u'P012A027',
u'P012A028',
u'P012A029',
u'P012A030',
u'P012A031',
u'P012A032',
u'P012A033',
u'P012A034',
u'P012A035',
u'P012A036',
u'P012A037',
u'P012A038',
u'P012A039',
u'P012A040',
u'P012A041',
u'P012A042',
u'P012A043',
u'P012A044',
u'P012A045',
u'P012A046',
u'P012A047',
u'P012A048',
u'P012A049',
u'P012B001',
u'P012B002',
u'P012B003',
u'P012B004',
u'P012B005',
u'P012B006',
u'P012B007',
u'P012B008',
u'P012B009',
u'P012B010',
u'P012B011',
u'P012B012',
u'P012B013',
u'P012B014',
u'P012B015',
u'P012B016',
u'P012B017',
u'P012B018',
u'P012B019',
u'P012B020',
u'P012B021',
u'P012B022',
u'P012B023',
u'P012B024',
u'P012B025',
u'P012B026',
u'P012B027',
u'P012B028',
u'P012B029',
u'P012B030',
u'P012B031',
u'P012B032',
u'P012B033',
u'P012B034',
u'P012B035',
u'P012B036',
u'P012B037',
u'P012B038',
u'P012B039',
u'P012B040',
u'P012B041',
u'P012B042',
u'P012B043',
u'P012B044',
u'P012B045',
u'P012B046',
u'P012B047',
u'P012B048',
u'P012B049',
u'P012C001',
u'P012C002',
u'P012C003',
u'P012C004',
u'P012C005',
u'P012C006',
u'P012C007',
u'P012C008',
u'P012C009',
u'P012C010',
u'P012C011',
u'P012C012',
u'P012C013',
u'P012C014',
u'P012C015',
u'P012C016',
u'P012C017',
u'P012C018',
u'P012C019',
u'P012C020',
u'P012C021',
u'P012C022',
u'P012C023',
u'P012C024',
u'P012C025',
u'P012C026',
u'P012C027',
u'P012C028',
u'P012C029',
u'P012C030',
u'P012C031',
u'P012C032',
u'P012C033',
u'P012C034',
u'P012C035',
u'P012C036',
u'P012C037',
u'P012C038',
u'P012C039',
u'P012C040',
u'P012C041',
u'P012C042',
u'P012C043',
u'P012C044',
u'P012C045',
u'P012C046',
u'P012C047',
u'P012C048',
u'P012C049',
u'P012D001',
u'P012D002',
u'P012D003',
u'P012D004',
u'P012D005',
u'P012D006',
u'P012D007',
u'P012D008',
u'P012D009',
u'P012D010',
u'P012D011',
u'P012D012',
u'P012D013',
u'P012D014',
u'P012D015',
u'P012D016',
u'P012D017',
u'P012D018',
u'P012D019',
u'P012D020',
u'P012D021',
u'P012D022',
u'P012D023',
u'P012D024',
u'P012D025',
u'P012D026',
u'P012D027',
u'P012D028',
u'P012D029',
u'P012D030',
u'P012D031',
u'P012D032',
u'P012D033',
u'P012D034',
u'P012D035',
u'P012D036',
u'P012D037',
u'P012D038',
u'P012D039',
u'P012D040',
u'P012D041',
u'P012D042',
u'P012D043',
u'P012D044',
u'P012D045',
u'P012D046',
u'P012D047',
u'P012D048',
u'P012D049',
u'P012E001',
u'P012E002',
u'P012E003',
u'P012E004',
u'P012E005',
u'P012E006',
u'P012E007',
u'P012E008',
u'P012E009',
u'P012E010',
u'P012E011',
u'P012E012',
u'P012E013',
u'P012E014',
u'P012E015',
u'P012E016',
u'P012E017',
u'P012E018',
u'P012E019',
u'P012E020',
u'P012E021',
u'P012E022',
u'P012E023',
u'P012E024',
u'P012E025',
u'P012E026',
u'P012E027',
u'P012E028',
u'P012E029',
u'P012E030',
u'P012E031',
u'P012E032',
u'P012E033',
u'P012E034',
u'P012E035',
u'P012E036',
u'P012E037',
u'P012E038',
u'P012E039',
u'P012E040',
u'P012E041',
u'P012E042',
u'P012E043',
u'P012E044',
u'P012E045',
u'P012E046',
u'P012E047',
u'P012E048',
u'P012E049',
u'P012F001',
u'P012F002',
u'P012F003',
u'P012F004',
u'P012F005',
u'P012F006',
u'P012F007',
u'P012F008',
u'P012F009',
u'P012F010',
u'P012F011',
u'P012F012',
u'P012F013',
u'P012F014',
u'P012F015',
u'P012F016',
u'P012F017',
u'P012F018',
u'P012F019',
u'P012F020',
u'P012F021',
u'P012F022',
u'P012F023',
u'P012F024',
u'P012F025',
u'P012F026',
u'P012F027',
u'P012F028',
u'P012F029',
u'P012F030',
u'P012F031',
u'P012F032',
u'P012F033',
u'P012F034',
u'P012F035',
u'P012F036',
u'P012F037',
u'P012F038',
u'P012F039',
u'P012F040',
u'P012F041',
u'P012F042',
u'P012F043',
u'P012F044',
u'P012F045',
u'P012F046',
u'P012F047',
u'P012F048',
u'P012F049',
u'P012G001',
u'P012G002',
u'P012G003',
u'P012G004',
u'P012G005',
u'P012G006',
u'P012G007',
u'P012G008',
u'P012G009',
u'P012G010',
u'P012G011',
u'P012G012',
u'P012G013',
u'P012G014',
u'P012G015',
u'P012G016',
u'P012G017',
u'P012G018',
u'P012G019',
u'P012G020',
u'P012G021',
u'P012G022',
u'P012G023',
u'P012G024',
u'P012G025',
u'P012G026',
u'P012G027',
u'P012G028',
u'P012G029',
u'P012G030',
u'P012G031',
u'P012G032',
u'P012G033',
u'P012G034',
u'P012G035',
u'P012G036',
u'P012G037',
u'P012G038',
u'P012G039',
u'P012G040',
u'P012G041',
u'P012G042',
u'P012G043',
u'P012G044',
u'P012G045',
u'P012G046',
u'P012G047',
u'P012G048',
u'P012G049',
u'P012H001',
u'P012H002',
u'P012H003',
u'P012H004',
u'P012H005',
u'P012H006',
u'P012H007',
u'P012H008',
u'P012H009',
u'P012H010',
u'P012H011',
u'P012H012',
u'P012H013',
u'P012H014',
u'P012H015',
u'P012H016',
u'P012H017',
u'P012H018',
u'P012H019',
u'P012H020',
u'P012H021',
u'P012H022',
u'P012H023',
u'P012H024',
u'P012H025',
u'P012H026',
u'P012H027',
u'P012H028',
u'P012H029',
u'P012H030',
u'P012H031',
u'P012H032',
u'P012H033',
u'P012H034',
u'P012H035',
u'P012H036',
u'P012H037',
u'P012H038',
u'P012H039',
u'P012H040',
u'P012H041',
u'P012H042',
u'P012H043',
u'P012H044',
u'P012H045',
u'P012H046',
u'P012H047',
u'P012H048',
u'P012H049',
u'P012I001',
u'P012I002',
u'P012I003',
u'P012I004',
u'P012I005',
u'P012I006',
u'P012I007',
u'P012I008',
u'P012I009',
u'P012I010',
u'P012I011',
u'P012I012',
u'P012I013',
u'P012I014',
u'P012I015',
u'P012I016',
u'P012I017',
u'P012I018',
u'P012I019',
u'P012I020',
u'P012I021',
u'P012I022',
u'P012I023',
u'P012I024',
u'P012I025',
u'P012I026',
u'P012I027',
u'P012I028',
u'P012I029',
u'P012I030',
u'P012I031',
u'P012I032',
u'P012I033',
u'P012I034',
u'P012I035',
u'P012I036',
u'P012I037',
u'P012I038',
u'P012I039',
u'P012I040',
u'P012I041',
u'P012I042',
u'P012I043',
u'P012I044',
u'P012I045',
u'P012I046',
u'P012I047',
u'P012I048',
u'P012I049',
u'P0130001',
u'P0130002',
u'P0130003',
u'P013A001',
u'P013A002',
u'P013A003',
u'P013B001',
u'P013B002',
u'P013B003',
u'P013C001',
u'P013C002',
u'P013C003',
u'P013D001',
u'P013D002',
u'P013D003',
u'P013E001',
u'P013E002',
u'P013E003',
u'P013F001',
u'P013F002',
u'P013F003',
u'P013G001',
u'P013G002',
u'P013G003',
u'P013H001',
u'P013H002',
u'P013H003',
u'P013I001',
u'P013I002',
u'P013I003',
u'P0140001',
u'P0140002',
u'P0140003',
u'P0140004',
u'P0140005',
u'P0140006',
u'P0140007',
u'P0140008',
u'P0140009',
u'P0140010',
u'P0140011',
u'P0140012',
u'P0140013',
u'P0140014',
u'P0140015',
u'P0140016',
u'P0140017',
u'P0140018',
u'P0140019',
u'P0140020',
u'P0140021',
u'P0140022',
u'P0140023',
u'P0140024',
u'P0140025',
u'P0140026',
u'P0140027',
u'P0140028',
u'P0140029',
u'P0140030',
u'P0140031',
u'P0140032',
u'P0140033',
u'P0140034',
u'P0140035',
u'P0140036',
u'P0140037',
u'P0140038',
u'P0140039',
u'P0140040',
u'P0140041',
u'P0140042',
u'P0140043',
u'P0150001',
u'P0150002',
u'P0150003',
u'P0150004',
u'P0150005',
u'P0150006',
u'P0150007',
u'P0150008',
u'P0150009',
u'P0150010',
u'P0150011',
u'P0150012',
u'P0150013',
u'P0150014',
u'P0150015',
u'P0150016',
u'P0150017',
u'P0160001',
u'P0160002',
u'P0160003',
u'P016A001',
u'P016A002',
u'P016A003',
u'P016B001',
u'P016B002',
u'P016B003',
u'P016C001',
u'P016C002',
u'P016C003',
u'P016D001',
u'P016D002',
u'P016D003',
u'P016E001',
u'P016E002',
u'P016E003',
u'P016F001',
u'P016F002',
u'P016F003',
u'P016G001',
u'P016G002',
u'P016G003',
u'P016H001',
u'P016H002',
u'P016H003',
u'P016I001',
u'P016I002',
u'P016I003',
u'P0170001',
u'P0170002',
u'P0170003',
u'P017A001',
u'P017A002',
u'P017A003',
u'P017B001',
u'P017B002',
u'P017B003',
u'P017C001',
u'P017C002',
u'P017C003',
u'P017D001',
u'P017D002',
u'P017D003',
u'P017E001',
u'P017E002',
u'P017E003',
u'P017F001',
u'P017F002',
u'P017F003',
u'P017G001',
u'P017G002',
u'P017G003',
u'P017H001',
u'P017H002',
u'P017H003',
u'P017I001',
u'P017I002',
u'P017I003',
u'P0180001',
u'P0180002',
u'P0180003',
u'P0180004',
u'P0180005',
u'P0180006',
u'P0180007',
u'P0180008',
u'P0180009',
u'P018A001',
u'P018A002',
u'P018A003',
u'P018A004',
u'P018A005',
u'P018A006',
u'P018A007',
u'P018A008',
u'P018A009',
u'P018B001',
u'P018B002',
u'P018B003',
u'P018B004',
u'P018B005',
u'P018B006',
u'P018B007',
u'P018B008',
u'P018B009',
u'P018C001',
u'P018C002',
u'P018C003',
u'P018C004',
u'P018C005',
u'P018C006',
u'P018C007',
u'P018C008',
u'P018C009',
u'P018D001',
u'P018D002',
u'P018D003',
u'P018D004',
u'P018D005',
u'P018D006',
u'P018D007',
u'P018D008',
u'P018D009',
u'P018E001',
u'P018E002',
u'P018E003',
u'P018E004',
u'P018E005',
u'P018E006',
u'P018E007',
u'P018E008',
u'P018E009',
u'P018F001',
u'P018F002',
u'P018F003',
u'P018F004',
u'P018F005',
u'P018F006',
u'P018F007',
u'P018F008',
u'P018F009',
u'P018G001',
u'P018G002',
u'P018G003',
u'P018G004',
u'P018G005',
u'P018G006',
u'P018G007',
u'P018G008',
u'P018G009',
u'P018H001',
u'P018H002',
u'P018H003',
u'P018H004',
u'P018H005',
u'P018H006',
u'P018H007',
u'P018H008',
u'P018H009',
u'P018I001',
u'P018I002',
u'P018I003',
u'P018I004',
u'P018I005',
u'P018I006',
u'P018I007',
u'P018I008',
u'P018I009',
u'P0190001',
u'P0190002',
u'P0190003',
u'P0190004',
u'P0190005',
u'P0190006',
u'P0190007',
u'P0190008',
u'P0190009',
u'P0190010',
u'P0190011',
u'P0190012',
u'P0190013',
u'P0190014',
u'P0190015',
u'P0190016',
u'P0190017',
u'P0190018',
u'P0190019',
u'P0200001',
u'P0200002',
u'P0200003',
u'P0200004',
u'P0200005',
u'P0200006',
u'P0200007',
u'P0200008',
u'P0200009',
u'P0200010',
u'P0200011',
u'P0200012',
u'P0200013',
u'P0200014',
u'P0200015',
u'P0200016',
u'P0200017',
u'P0200018',
u'P0200019',
u'P0200020',
u'P0200021',
u'P0200022',
u'P0200023',
u'P0200024',
u'P0200025',
u'P0200026',
u'P0200027',
u'P0200028',
u'P0200029',
u'P0200030',
u'P0200031',
u'P0200032',
u'P0200033',
u'P0200034',
u'P0210001',
u'P0210002',
u'P0210003',
u'P0210004',
u'P0210005',
u'P0210006',
u'P0210007',
u'P0210008',
u'P0210009',
u'P0210010',
u'P0210011',
u'P0210012',
u'P0210013',
u'P0210014',
u'P0210015',
u'P0210016',
u'P0210017',
u'P0210018',
u'P0210019',
u'P0210020',
u'P0210021',
u'P0210022',
u'P0210023',
u'P0210024',
u'P0210025',
u'P0210026',
u'P0210027',
u'P0210028',
u'P0210029',
u'P0210030',
u'P0210031',
u'P0220001',
u'P0220002',
u'P0220003',
u'P0220004',
u'P0220005',
u'P0220006',
u'P0220007',
u'P0220008',
u'P0220009',
u'P0220010',
u'P0220011',
u'P0220012',
u'P0220013',
u'P0220014',
u'P0220015',
u'P0220016',
u'P0220017',
u'P0220018',
u'P0220019',
u'P0220020',
u'P0220021',
u'P0230001',
u'P0230002',
u'P0230003',
u'P0230004',
u'P0230005',
u'P0230006',
u'P0230007',
u'P0230008',
u'P0230009',
u'P0230010',
u'P0230011',
u'P0230012',
u'P0230013',
u'P0230014',
u'P0230015',
u'P0240001',
u'P0240002',
u'P0240003',
u'P0240004',
u'P0240005',
u'P0240006',
u'P0240007',
u'P0240008',
u'P0240009',
u'P0240010',
u'P0240011',
u'P0250001',
u'P0250002',
u'P0250003',
u'P0250004',
u'P0250005',
u'P0250006',
u'P0250007',
u'P0250008',
u'P0250009',
u'P0250010',
u'P0250011',
u'P0260001',
u'P0260002',
u'P0260003',
u'P0260004',
u'P0260005',
u'P0260006',
u'P0260007',
u'P0260008',
u'P0260009',
u'P0260010',
u'P0260011',
u'P0270001',
u'P0270002',
u'P0270003',
u'P0280001',
u'P0280002',
u'P0280003',
u'P0280004',
u'P0280005',
u'P0280006',
u'P0280007',
u'P0280008',
u'P0280009',
u'P0280010',
u'P0280011',
u'P0280012',
u'P0280013',
u'P0280014',
u'P0280015',
u'P0280016',
u'P028A001',
u'P028A002',
u'P028A003',
u'P028A004',
u'P028A005',
u'P028A006',
u'P028A007',
u'P028A008',
u'P028A009',
u'P028A010',
u'P028A011',
u'P028A012',
u'P028A013',
u'P028A014',
u'P028A015',
u'P028A016',
u'P028B001',
u'P028B002',
u'P028B003',
u'P028B004',
u'P028B005',
u'P028B006',
u'P028B007',
u'P028B008',
u'P028B009',
u'P028B010',
u'P028B011',
u'P028B012',
u'P028B013',
u'P028B014',
u'P028B015',
u'P028B016',
u'P028C001',
u'P028C002',
u'P028C003',
u'P028C004',
u'P028C005',
u'P028C006',
u'P028C007',
u'P028C008',
u'P028C009',
u'P028C010',
u'P028C011',
u'P028C012',
u'P028C013',
u'P028C014',
u'P028C015',
u'P028C016',
u'P028D001',
u'P028D002',
u'P028D003',
u'P028D004',
u'P028D005',
u'P028D006',
u'P028D007',
u'P028D008',
u'P028D009',
u'P028D010',
u'P028D011',
u'P028D012',
u'P028D013',
u'P028D014',
u'P028D015',
u'P028D016',
u'P028E001',
u'P028E002',
u'P028E003',
u'P028E004',
u'P028E005',
u'P028E006',
u'P028E007',
u'P028E008',
u'P028E009',
u'P028E010',
u'P028E011',
u'P028E012',
u'P028E013',
u'P028E014',
u'P028E015',
u'P028E016',
u'P028F001',
u'P028F002',
u'P028F003',
u'P028F004',
u'P028F005',
u'P028F006',
u'P028F007',
u'P028F008',
u'P028F009',
u'P028F010',
u'P028F011',
u'P028F012',
u'P028F013',
u'P028F014',
u'P028F015',
u'P028F016',
u'P028G001',
u'P028G002',
u'P028G003',
u'P028G004',
u'P028G005',
u'P028G006',
u'P028G007',
u'P028G008',
u'P028G009',
u'P028G010',
u'P028G011',
u'P028G012',
u'P028G013',
u'P028G014',
u'P028G015',
u'P028G016',
u'P028H001',
u'P028H002',
u'P028H003',
u'P028H004',
u'P028H005',
u'P028H006',
u'P028H007',
u'P028H008',
u'P028H009',
u'P028H010',
u'P028H011',
u'P028H012',
u'P028H013',
u'P028H014',
u'P028H015',
u'P028H016',
u'P028I001',
u'P028I002',
u'P028I003',
u'P028I004',
u'P028I005',
u'P028I006',
u'P028I007',
u'P028I008',
u'P028I009',
u'P028I010',
u'P028I011',
u'P028I012',
u'P028I013',
u'P028I014',
u'P028I015',
u'P028I016',
u'P0290001',
u'P0290002',
u'P0290003',
u'P0290004',
u'P0290005',
u'P0290006',
u'P0290007',
u'P0290008',
u'P0290009',
u'P0290010',
u'P0290011',
u'P0290012',
u'P0290013',
u'P0290014',
u'P0290015',
u'P0290016',
u'P0290017',
u'P0290018',
u'P0290019',
u'P0290020',
u'P0290021',
u'P0290022',
u'P0290023',
u'P0290024',
u'P0290025',
u'P0290026',
u'P0290027',
u'P0290028',
u'P029A001',
u'P029A002',
u'P029A003',
u'P029A004',
u'P029A005',
u'P029A006',
u'P029A007',
u'P029A008',
u'P029A009',
u'P029A010',
u'P029A011',
u'P029A012',
u'P029A013',
u'P029A014',
u'P029A015',
u'P029A016',
u'P029A017',
u'P029A018',
u'P029A019',
u'P029A020',
u'P029A021',
u'P029A022',
u'P029A023',
u'P029A024',
u'P029A025',
u'P029A026',
u'P029A027',
u'P029A028',
u'P029B001',
u'P029B002',
u'P029B003',
u'P029B004',
u'P029B005',
u'P029B006',
u'P029B007',
u'P029B008',
u'P029B009',
u'P029B010',
u'P029B011',
u'P029B012',
u'P029B013',
u'P029B014',
u'P029B015',
u'P029B016',
u'P029B017',
u'P029B018',
u'P029B019',
u'P029B020',
u'P029B021',
u'P029B022',
u'P029B023',
u'P029B024',
u'P029B025',
u'P029B026',
u'P029B027',
u'P029B028',
u'P029C001',
u'P029C002',
u'P029C003',
u'P029C004',
u'P029C005',
u'P029C006',
u'P029C007',
u'P029C008',
u'P029C009',
u'P029C010',
u'P029C011',
u'P029C012',
u'P029C013',
u'P029C014',
u'P029C015',
u'P029C016',
u'P029C017',
u'P029C018',
u'P029C019',
u'P029C020',
u'P029C021',
u'P029C022',
u'P029C023',
u'P029C024',
u'P029C025',
u'P029C026',
u'P029C027',
u'P029C028',
u'P029D001',
u'P029D002',
u'P029D003',
u'P029D004',
u'P029D005',
u'P029D006',
u'P029D007',
u'P029D008',
u'P029D009',
u'P029D010',
u'P029D011',
u'P029D012',
u'P029D013',
u'P029D014',
u'P029D015',
u'P029D016',
u'P029D017',
u'P029D018',
u'P029D019',
u'P029D020',
u'P029D021',
u'P029D022',
u'P029D023',
u'P029D024',
u'P029D025',
u'P029D026',
u'P029D027',
u'P029D028',
u'P029E001',
u'P029E002',
u'P029E003',
u'P029E004',
u'P029E005',
u'P029E006',
u'P029E007',
u'P029E008',
u'P029E009',
u'P029E010',
u'P029E011',
u'P029E012',
u'P029E013',
u'P029E014',
u'P029E015',
u'P029E016',
u'P029E017',
u'P029E018',
u'P029E019',
u'P029E020',
u'P029E021',
u'P029E022',
u'P029E023',
u'P029E024',
u'P029E025',
u'P029E026',
u'P029E027',
u'P029E028',
u'P029F001',
u'P029F002',
u'P029F003',
u'P029F004',
u'P029F005',
u'P029F006',
u'P029F007',
u'P029F008',
u'P029F009',
u'P029F010',
u'P029F011',
u'P029F012',
u'P029F013',
u'P029F014',
u'P029F015',
u'P029F016',
u'P029F017',
u'P029F018',
u'P029F019',
u'P029F020',
u'P029F021',
u'P029F022',
u'P029F023',
u'P029F024',
u'P029F025',
u'P029F026',
u'P029F027',
u'P029F028',
u'P029G001',
u'P029G002',
u'P029G003',
u'P029G004',
u'P029G005',
u'P029G006',
u'P029G007',
u'P029G008',
u'P029G009',
u'P029G010',
u'P029G011',
u'P029G012',
u'P029G013',
u'P029G014',
u'P029G015',
u'P029G016',
u'P029G017',
u'P029G018',
u'P029G019',
u'P029G020',
u'P029G021',
u'P029G022',
u'P029G023',
u'P029G024',
u'P029G025',
u'P029G026',
u'P029G027',
u'P029G028',
u'P029H001',
u'P029H002',
u'P029H003',
u'P029H004',
u'P029H005',
u'P029H006',
u'P029H007',
u'P029H008',
u'P029H009',
u'P029H010',
u'P029H011',
u'P029H012',
u'P029H013',
u'P029H014',
u'P029H015',
u'P029H016',
u'P029H017',
u'P029H018',
u'P029H019',
u'P029H020',
u'P029H021',
u'P029H022',
u'P029H023',
u'P029H024',
u'P029H025',
u'P029H026',
u'P029H027',
u'P029H028',
u'P029I001',
u'P029I002',
u'P029I003',
u'P029I004',
u'P029I005',
u'P029I006',
u'P029I007',
u'P029I008',
u'P029I009',
u'P029I010',
u'P029I011',
u'P029I012',
u'P029I013',
u'P029I014',
u'P029I015',
u'P029I016',
u'P029I017',
u'P029I018',
u'P029I019',
u'P029I020',
u'P029I021',
u'P029I022',
u'P029I023',
u'P029I024',
u'P029I025',
u'P029I026',
u'P029I027',
u'P029I028',
u'P0300001',
u'P0300002',
u'P0300003',
u'P0300004',
u'P0300005',
u'P0300006',
u'P0300007',
u'P0300008',
u'P0300009',
u'P0300010',
u'P0300011',
u'P0300012',
u'P0300013',
u'P0310001',
u'P0310002',
u'P0310003',
u'P0310004',
u'P0310005',
u'P0310006',
u'P0310007',
u'P0310008',
u'P0310009',
u'P0310010',
u'P0310011',
u'P0310012',
u'P0310013',
u'P0310014',
u'P0310015',
u'P0310016',
u'P031A001',
u'P031A002',
u'P031A003',
u'P031A004',
u'P031A005',
u'P031A006',
u'P031A007',
u'P031A008',
u'P031A009',
u'P031A010',
u'P031A011',
u'P031A012',
u'P031A013',
u'P031A014',
u'P031A015',
u'P031A016',
u'P031B001',
u'P031B002',
u'P031B003',
u'P031B004',
u'P031B005',
u'P031B006',
u'P031B007',
u'P031B008',
u'P031B009',
u'P031B010',
u'P031B011',
u'P031B012',
u'P031B013',
u'P031B014',
u'P031B015',
u'P031B016',
u'P031C001',
u'P031C002',
u'P031C003',
u'P031C004',
u'P031C005',
u'P031C006',
u'P031C007',
u'P031C008',
u'P031C009',
u'P031C010',
u'P031C011',
u'P031C012',
u'P031C013',
u'P031C014',
u'P031C015',
u'P031C016',
u'P031D001',
u'P031D002',
u'P031D003',
u'P031D004',
u'P031D005',
u'P031D006',
u'P031D007',
u'P031D008',
u'P031D009',
u'P031D010',
u'P031D011',
u'P031D012',
u'P031D013',
u'P031D014',
u'P031D015',
u'P031D016',
u'P031E001',
u'P031E002',
u'P031E003',
u'P031E004',
u'P031E005',
u'P031E006',
u'P031E007',
u'P031E008',
u'P031E009',
u'P031E010',
u'P031E011',
u'P031E012',
u'P031E013',
u'P031E014',
u'P031E015',
u'P031E016',
u'P031F001',
u'P031F002',
u'P031F003',
u'P031F004',
u'P031F005',
u'P031F006',
u'P031F007',
u'P031F008',
u'P031F009',
u'P031F010',
u'P031F011',
u'P031F012',
u'P031F013',
u'P031F014',
u'P031F015',
u'P031F016',
u'P031G001',
u'P031G002',
u'P031G003',
u'P031G004',
u'P031G005',
u'P031G006',
u'P031G007',
u'P031G008',
u'P031G009',
u'P031G010',
u'P031G011',
u'P031G012',
u'P031G013',
u'P031G014',
u'P031G015',
u'P031G016',
u'P031H001',
u'P031H002',
u'P031H003',
u'P031H004',
u'P031H005',
u'P031H006',
u'P031H007',
u'P031H008',
u'P031H009',
u'P031H010',
u'P031H011',
u'P031H012',
u'P031H013',
u'P031H014',
u'P031H015',
u'P031H016',
u'P031I001',
u'P031I002',
u'P031I003',
u'P031I004',
u'P031I005',
u'P031I006',
u'P031I007',
u'P031I008',
u'P031I009',
u'P031I010',
u'P031I011',
u'P031I012',
u'P031I013',
u'P031I014',
u'P031I015',
u'P031I016',
u'P0320001',
u'P0320002',
u'P0320003',
u'P0320004',
u'P0320005',
u'P0320006',
u'P0320007',
u'P0320008',
u'P0320009',
u'P0320010',
u'P0320011',
u'P0320012',
u'P0320013',
u'P0320014',
u'P0320015',
u'P0320016',
u'P0320017',
u'P0320018',
u'P0320019',
u'P0320020',
u'P0320021',
u'P0320022',
u'P0320023',
u'P0320024',
u'P0320025',
u'P0320026',
u'P0320027',
u'P0320028',
u'P0320029',
u'P0320030',
u'P0320031',
u'P0320032',
u'P0320033',
u'P0320034',
u'P0320035',
u'P0320036',
u'P0320037',
u'P0320038',
u'P0320039',
u'P0320040',
u'P0320041',
u'P0320042',
u'P0320043',
u'P0320044',
u'P0320045',
u'P0330001',
u'P0330002',
u'P0330003',
u'P0330004',
u'P0330005',
u'P0330006',
u'P0330007',
u'P0340001',
u'P0340002',
u'P0340003',
u'P0340004',
u'P0340005',
u'P0340006',
u'P0340007',
u'P0340008',
u'P0340009',
u'P0340010',
u'P0340011',
u'P0340012',
u'P0340013',
u'P0340014',
u'P0340015',
u'P0340016',
u'P0340017',
u'P0340018',
u'P0340019',
u'P0340020',
u'P0340021',
u'P0340022',
u'P034A001',
u'P034A002',
u'P034A003',
u'P034A004',
u'P034A005',
u'P034A006',
u'P034A007',
u'P034A008',
u'P034A009',
u'P034A010',
u'P034A011',
u'P034A012',
u'P034A013',
u'P034A014',
u'P034A015',
u'P034A016',
u'P034A017',
u'P034A018',
u'P034A019',
u'P034A020',
u'P034A021',
u'P034A022',
u'P034B001',
u'P034B002',
u'P034B003',
u'P034B004',
u'P034B005',
u'P034B006',
u'P034B007',
u'P034B008',
u'P034B009',
u'P034B010',
u'P034B011',
u'P034B012',
u'P034B013',
u'P034B014',
u'P034B015',
u'P034B016',
u'P034B017',
u'P034B018',
u'P034B019',
u'P034B020',
u'P034B021',
u'P034B022',
u'P034C001',
u'P034C002',
u'P034C003',
u'P034C004',
u'P034C005',
u'P034C006',
u'P034C007',
u'P034C008',
u'P034C009',
u'P034C010',
u'P034C011',
u'P034C012',
u'P034C013',
u'P034C014',
u'P034C015',
u'P034C016',
u'P034C017',
u'P034C018',
u'P034C019',
u'P034C020',
u'P034C021',
u'P034C022',
u'P034D001',
u'P034D002',
u'P034D003',
u'P034D004',
u'P034D005',
u'P034D006',
u'P034D007',
u'P034D008',
u'P034D009',
u'P034D010',
u'P034D011',
u'P034D012',
u'P034D013',
u'P034D014',
u'P034D015',
u'P034D016',
u'P034D017',
u'P034D018',
u'P034D019',
u'P034D020',
u'P034D021',
u'P034D022',
u'P034E001',
u'P034E002',
u'P034E003',
u'P034E004',
u'P034E005',
u'P034E006',
u'P034E007',
u'P034E008',
u'P034E009',
u'P034E010',
u'P034E011',
u'P034E012',
u'P034E013',
u'P034E014',
u'P034E015',
u'P034E016',
u'P034E017',
u'P034E018',
u'P034E019',
u'P034E020',
u'P034E021',
u'P034E022',
u'P034F001',
u'P034F002',
u'P034F003',
u'P034F004',
u'P034F005',
u'P034F006',
u'P034F007',
u'P034F008',
u'P034F009',
u'P034F010',
u'P034F011',
u'P034F012',
u'P034F013',
u'P034F014',
u'P034F015',
u'P034F016',
u'P034F017',
u'P034F018',
u'P034F019',
u'P034F020',
u'P034F021',
u'P034F022',
u'P034G001',
u'P034G002',
u'P034G003',
u'P034G004',
u'P034G005',
u'P034G006',
u'P034G007',
u'P034G008',
u'P034G009',
u'P034G010',
u'P034G011',
u'P034G012',
u'P034G013',
u'P034G014',
u'P034G015',
u'P034G016',
u'P034G017',
u'P034G018',
u'P034G019',
u'P034G020',
u'P034G021',
u'P034G022',
u'P034H001',
u'P034H002',
u'P034H003',
u'P034H004',
u'P034H005',
u'P034H006',
u'P034H007',
u'P034H008',
u'P034H009',
u'P034H010',
u'P034H011',
u'P034H012',
u'P034H013',
u'P034H014',
u'P034H015',
u'P034H016',
u'P034H017',
u'P034H018',
u'P034H019',
u'P034H020',
u'P034H021',
u'P034H022',
u'P034I001',
u'P034I002',
u'P034I003',
u'P034I004',
u'P034I005',
u'P034I006',
u'P034I007',
u'P034I008',
u'P034I009',
u'P034I010',
u'P034I011',
u'P034I012',
u'P034I013',
u'P034I014',
u'P034I015',
u'P034I016',
u'P034I017',
u'P034I018',
u'P034I019',
u'P034I020',
u'P034I021',
u'P034I022',
u'P0350001',
u'P035A001',
u'P035B001',
u'P035C001',
u'P035D001',
u'P035E001',
u'P035F001',
u'P035G001',
u'P035H001',
u'P035I001',
u'P0360001',
u'P0360002',
u'P0360003',
u'P036A001',
u'P036A002',
u'P036A003',
u'P036B001',
u'P036B002',
u'P036B003',
u'P036C001',
u'P036C002',
u'P036C003',
u'P036D001',
u'P036D002',
u'P036D003',
u'P036E001',
u'P036E002',
u'P036E003',
u'P036F001',
u'P036F002',
u'P036F003',
u'P036G001',
u'P036G002',
u'P036G003',
u'P036H001',
u'P036H002',
u'P036H003',
u'P036I001',
u'P036I002',
u'P036I003',
u'P0370001',
u'P0370002',
u'P0370003',
u'P037A001',
u'P037A002',
u'P037A003',
u'P037B001',
u'P037B002',
u'P037B003',
u'P037C001',
u'P037C002',
u'P037C003',
u'P037D001',
u'P037D002',
u'P037D003',
u'P037E001',
u'P037E002',
u'P037E003',
u'P037F001',
u'P037F002',
u'P037F003',
u'P037G001',
u'P037G002',
u'P037G003',
u'P037H001',
u'P037H002',
u'P037H003',
u'P037I001',
u'P037I002',
u'P037I003',
u'P0380001',
u'P0380002',
u'P0380003',
u'P0380004',
u'P0380005',
u'P0380006',
u'P0380007',
u'P0380008',
u'P0380009',
u'P0380010',
u'P0380011',
u'P0380012',
u'P0380013',
u'P0380014',
u'P0380015',
u'P0380016',
u'P0380017',
u'P0380018',
u'P0380019',
u'P0380020',
u'P038A001',
u'P038A002',
u'P038A003',
u'P038A004',
u'P038A005',
u'P038A006',
u'P038A007',
u'P038A008',
u'P038A009',
u'P038A010',
u'P038A011',
u'P038A012',
u'P038A013',
u'P038A014',
u'P038A015',
u'P038A016',
u'P038A017',
u'P038A018',
u'P038A019',
u'P038A020',
u'P038B001',
u'P038B002',
u'P038B003',
u'P038B004',
u'P038B005',
u'P038B006',
u'P038B007',
u'P038B008',
u'P038B009',
u'P038B010',
u'P038B011',
u'P038B012',
u'P038B013',
u'P038B014',
u'P038B015',
u'P038B016',
u'P038B017',
u'P038B018',
u'P038B019',
u'P038B020',
u'P038C001',
u'P038C002',
u'P038C003',
u'P038C004',
u'P038C005',
u'P038C006',
u'P038C007',
u'P038C008',
u'P038C009',
u'P038C010',
u'P038C011',
u'P038C012',
u'P038C013',
u'P038C014',
u'P038C015',
u'P038C016',
u'P038C017',
u'P038C018',
u'P038C019',
u'P038C020',
u'P038D001',
u'P038D002',
u'P038D003',
u'P038D004',
u'P038D005',
u'P038D006',
u'P038D007',
u'P038D008',
u'P038D009',
u'P038D010',
u'P038D011',
u'P038D012',
u'P038D013',
u'P038D014',
u'P038D015',
u'P038D016',
u'P038D017',
u'P038D018',
u'P038D019',
u'P038D020',
u'P038E001',
u'P038E002',
u'P038E003',
u'P038E004',
u'P038E005',
u'P038E006',
u'P038E007',
u'P038E008',
u'P038E009',
u'P038E010',
u'P038E011',
u'P038E012',
u'P038E013',
u'P038E014',
u'P038E015',
u'P038E016',
u'P038E017',
u'P038E018',
u'P038E019',
u'P038E020',
u'P038F001',
u'P038F002',
u'P038F003',
u'P038F004',
u'P038F005',
u'P038F006',
u'P038F007',
u'P038F008',
u'P038F009',
u'P038F010',
u'P038F011',
u'P038F012',
u'P038F013',
u'P038F014',
u'P038F015',
u'P038F016',
u'P038F017',
u'P038F018',
u'P038F019',
u'P038F020',
u'P038G001',
u'P038G002',
u'P038G003',
u'P038G004',
u'P038G005',
u'P038G006',
u'P038G007',
u'P038G008',
u'P038G009',
u'P038G010',
u'P038G011',
u'P038G012',
u'P038G013',
u'P038G014',
u'P038G015',
u'P038G016',
u'P038G017',
u'P038G018',
u'P038G019',
u'P038G020',
u'P038H001',
u'P038H002',
u'P038H003',
u'P038H004',
u'P038H005',
u'P038H006',
u'P038H007',
u'P038H008',
u'P038H009',
u'P038H010',
u'P038H011',
u'P038H012',
u'P038H013',
u'P038H014',
u'P038H015',
u'P038H016',
u'P038H017',
u'P038H018',
u'P038H019',
u'P038H020',
u'P038I001',
u'P038I002',
u'P038I003',
u'P038I004',
u'P038I005',
u'P038I006',
u'P038I007',
u'P038I008',
u'P038I009',
u'P038I010',
u'P038I011',
u'P038I012',
u'P038I013',
u'P038I014',
u'P038I015',
u'P038I016',
u'P038I017',
u'P038I018',
u'P038I019',
u'P038I020',
u'P0390001',
u'P0390002',
u'P0390003',
u'P0390004',
u'P0390005',
u'P0390006',
u'P0390007',
u'P0390008',
u'P0390009',
u'P0390010',
u'P0390011',
u'P0390012',
u'P0390013',
u'P0390014',
u'P0390015',
u'P0390016',
u'P0390017',
u'P0390018',
u'P0390019',
u'P0390020',
u'P039A001',
u'P039A002',
u'P039A003',
u'P039A004',
u'P039A005',
u'P039A006',
u'P039A007',
u'P039A008',
u'P039A009',
u'P039A010',
u'P039A011',
u'P039A012',
u'P039A013',
u'P039A014',
u'P039A015',
u'P039A016',
u'P039A017',
u'P039A018',
u'P039A019',
u'P039A020',
u'P039B001',
u'P039B002',
u'P039B003',
u'P039B004',
u'P039B005',
u'P039B006',
u'P039B007',
u'P039B008',
u'P039B009',
u'P039B010',
u'P039B011',
u'P039B012',
u'P039B013',
u'P039B014',
u'P039B015',
u'P039B016',
u'P039B017',
u'P039B018',
u'P039B019',
u'P039B020',
u'P039C001',
u'P039C002',
u'P039C003',
u'P039C004',
u'P039C005',
u'P039C006',
u'P039C007',
u'P039C008',
u'P039C009',
u'P039C010',
u'P039C011',
u'P039C012',
u'P039C013',
u'P039C014',
u'P039C015',
u'P039C016',
u'P039C017',
u'P039C018',
u'P039C019',
u'P039C020',
u'P039D001',
u'P039D002',
u'P039D003',
u'P039D004',
u'P039D005',
u'P039D006',
u'P039D007',
u'P039D008',
u'P039D009',
u'P039D010',
u'P039D011',
u'P039D012',
u'P039D013',
u'P039D014',
u'P039D015',
u'P039D016',
u'P039D017',
u'P039D018',
u'P039D019',
u'P039D020',
u'P039E001',
u'P039E002',
u'P039E003',
u'P039E004',
u'P039E005',
u'P039E006',
u'P039E007',
u'P039E008',
u'P039E009',
u'P039E010',
u'P039E011',
u'P039E012',
u'P039E013',
u'P039E014',
u'P039E015',
u'P039E016',
u'P039E017',
u'P039E018',
u'P039E019',
u'P039E020',
u'P039F001',
u'P039F002',
u'P039F003',
u'P039F004',
u'P039F005',
u'P039F006',
u'P039F007',
u'P039F008',
u'P039F009',
u'P039F010',
u'P039F011',
u'P039F012',
u'P039F013',
u'P039F014',
u'P039F015',
u'P039F016',
u'P039F017',
u'P039F018',
u'P039F019',
u'P039F020',
u'P039G001',
u'P039G002',
u'P039G003',
u'P039G004',
u'P039G005',
u'P039G006',
u'P039G007',
u'P039G008',
u'P039G009',
u'P039G010',
u'P039G011',
u'P039G012',
u'P039G013',
u'P039G014',
u'P039G015',
u'P039G016',
u'P039G017',
u'P039G018',
u'P039G019',
u'P039G020',
u'P039H001',
u'P039H002',
u'P039H003',
u'P039H004',
u'P039H005',
u'P039H006',
u'P039H007',
u'P039H008',
u'P039H009',
u'P039H010',
u'P039H011',
u'P039H012',
u'P039H013',
u'P039H014',
u'P039H015',
u'P039H016',
u'P039H017',
u'P039H018',
u'P039H019',
u'P039H020',
u'P039I001',
u'P039I002',
u'P039I003',
u'P039I004',
u'P039I005',
u'P039I006',
u'P039I007',
u'P039I008',
u'P039I009',
u'P039I010',
u'P039I011',
u'P039I012',
u'P039I013',
u'P039I014',
u'P039I015',
u'P039I016',
u'P039I017',
u'P039I018',
u'P039I019',
u'P039I020',
u'P0400001',
u'P0400002',
u'P0400003',
u'P0400004',
u'P0400005',
u'P0400006',
u'P0400007',
u'P0400008',
u'P0400009',
u'P0400010',
u'P0400011',
u'P0400012',
u'P0400013',
u'P0400014',
u'P0400015',
u'P0400016',
u'P0400017',
u'P0400018',
u'P0400019',
u'P0400020',
u'P0410001',
u'P0410002',
u'P0410003',
u'P0410004',
u'P0410005',
u'P0410006',
u'P0420001',
u'P0420002',
u'P0420003',
u'P0420004',
u'P0420005',
u'P0420006',
u'P0420007',
u'P0420008',
u'P0420009',
u'P0420010',
u'P0430001',
u'P0430002',
u'P0430003',
u'P0430004',
u'P0430005',
u'P0430006',
u'P0430007',
u'P0430008',
u'P0430009',
u'P0430010',
u'P0430011',
u'P0430012',
u'P0430013',
u'P0430014',
u'P0430015',
u'P0430016',
u'P0430017',
u'P0430018',
u'P0430019',
u'P0430020',
u'P0430021',
u'P0430022',
u'P0430023',
u'P0430024',
u'P0430025',
u'P0430026',
u'P0430027',
u'P0430028',
u'P0430029',
u'P0430030',
u'P0430031',
u'P0430032',
u'P0430033',
u'P0430034',
u'P0430035',
u'P0430036',
u'P0430037',
u'P0430038',
u'P0430039',
u'P0430040',
u'P0430041',
u'P0430042',
u'P0430043',
u'P0430044',
u'P0430045',
u'P0430046',
u'P0430047',
u'P0430048',
u'P0430049',
u'P0430050',
u'P0430051',
u'P0430052',
u'P0430053',
u'P0430054',
u'P0430055',
u'P0430056',
u'P0430057',
u'P0430058',
u'P0430059',
u'P0430060',
u'P0430061',
u'P0430062',
u'P0430063',
u'P0440001',
u'P0440002',
u'P0440003',
u'P0450001',
u'P0450002',
u'P0450003',
u'P0460001',
u'P0460002',
u'P0460003',
u'P0470001',
u'P0470002',
u'P0470003',
u'P0480001',
u'P0480002',
u'P0480003',
u'P0490001',
u'P0490002',
u'P0490003',
u'P0500001',
u'P0500002',
u'P0500003',
u'P0510001',
u'P0510002',
u'P0510003',
u'PCO0010001',
u'PCO0010002',
u'PCO0010003',
u'PCO0010004',
u'PCO0010005',
u'PCO0010006',
u'PCO0010007',
u'PCO0010008',
u'PCO0010009',
u'PCO0010010',
u'PCO0010011',
u'PCO0010012',
u'PCO0010013',
u'PCO0010014',
u'PCO0010015',
u'PCO0010016',
u'PCO0010017',
u'PCO0010018',
u'PCO0010019',
u'PCO0010020',
u'PCO0010021',
u'PCO0010022',
u'PCO0010023',
u'PCO0010024',
u'PCO0010025',
u'PCO0010026',
u'PCO0010027',
u'PCO0010028',
u'PCO0010029',
u'PCO0010030',
u'PCO0010031',
u'PCO0010032',
u'PCO0010033',
u'PCO0010034',
u'PCO0010035',
u'PCO0010036',
u'PCO0010037',
u'PCO0010038',
u'PCO0010039',
u'PCO0020001',
u'PCO0020002',
u'PCO0020003',
u'PCO0020004',
u'PCO0020005',
u'PCO0020006',
u'PCO0020007',
u'PCO0020008',
u'PCO0020009',
u'PCO0020010',
u'PCO0020011',
u'PCO0020012',
u'PCO0020013',
u'PCO0020014',
u'PCO0020015',
u'PCO0020016',
u'PCO0020017',
u'PCO0020018',
u'PCO0020019',
u'PCO0020020',
u'PCO0020021',
u'PCO0020022',
u'PCO0020023',
u'PCO0020024',
u'PCO0020025',
u'PCO0020026',
u'PCO0020027',
u'PCO0020028',
u'PCO0020029',
u'PCO0020030',
u'PCO0020031',
u'PCO0020032',
u'PCO0020033',
u'PCO0020034',
u'PCO0020035',
u'PCO0020036',
u'PCO0020037',
u'PCO0020038',
u'PCO0020039',
u'PCO0030001',
u'PCO0030002',
u'PCO0030003',
u'PCO0030004',
u'PCO0030005',
u'PCO0030006',
u'PCO0030007',
u'PCO0030008',
u'PCO0030009',
u'PCO0030010',
u'PCO0030011',
u'PCO0030012',
u'PCO0030013',
u'PCO0030014',
u'PCO0030015',
u'PCO0030016',
u'PCO0030017',
u'PCO0030018',
u'PCO0030019',
u'PCO0030020',
u'PCO0030021',
u'PCO0030022',
u'PCO0030023',
u'PCO0030024',
u'PCO0030025',
u'PCO0030026',
u'PCO0030027',
u'PCO0030028',
u'PCO0030029',
u'PCO0030030',
u'PCO0030031',
u'PCO0030032',
u'PCO0030033',
u'PCO0030034',
u'PCO0030035',
u'PCO0030036',
u'PCO0030037',
u'PCO0030038',
u'PCO0030039',
u'PCO0040001',
u'PCO0040002',
u'PCO0040003',
u'PCO0040004',
u'PCO0040005',
u'PCO0040006',
u'PCO0040007',
u'PCO0040008',
u'PCO0040009',
u'PCO0040010',
u'PCO0040011',
u'PCO0040012',
u'PCO0040013',
u'PCO0040014',
u'PCO0040015',
u'PCO0040016',
u'PCO0040017',
u'PCO0040018',
u'PCO0040019',
u'PCO0040020',
u'PCO0040021',
u'PCO0040022',
u'PCO0040023',
u'PCO0040024',
u'PCO0040025',
u'PCO0040026',
u'PCO0040027',
u'PCO0040028',
u'PCO0040029',
u'PCO0040030',
u'PCO0040031',
u'PCO0040032',
u'PCO0040033',
u'PCO0040034',
u'PCO0040035',
u'PCO0040036',
u'PCO0040037',
u'PCO0040038',
u'PCO0040039',
u'PCO0050001',
u'PCO0050002',
u'PCO0050003',
u'PCO0050004',
u'PCO0050005',
u'PCO0050006',
u'PCO0050007',
u'PCO0050008',
u'PCO0050009',
u'PCO0050010',
u'PCO0050011',
u'PCO0050012',
u'PCO0050013',
u'PCO0050014',
u'PCO0050015',
u'PCO0050016',
u'PCO0050017',
u'PCO0050018',
u'PCO0050019',
u'PCO0050020',
u'PCO0050021',
u'PCO0050022',
u'PCO0050023',
u'PCO0050024',
u'PCO0050025',
u'PCO0050026',
u'PCO0050027',
u'PCO0050028',
u'PCO0050029',
u'PCO0050030',
u'PCO0050031',
u'PCO0050032',
u'PCO0050033',
u'PCO0050034',
u'PCO0050035',
u'PCO0050036',
u'PCO0050037',
u'PCO0050038',
u'PCO0050039',
u'PCO0060001',
u'PCO0060002',
u'PCO0060003',
u'PCO0060004',
u'PCO0060005',
u'PCO0060006',
u'PCO0060007',
u'PCO0060008',
u'PCO0060009',
u'PCO0060010',
u'PCO0060011',
u'PCO0060012',
u'PCO0060013',
u'PCO0060014',
u'PCO0060015',
u'PCO0060016',
u'PCO0060017',
u'PCO0060018',
u'PCO0060019',
u'PCO0060020',
u'PCO0060021',
u'PCO0060022',
u'PCO0060023',
u'PCO0060024',
u'PCO0060025',
u'PCO0060026',
u'PCO0060027',
u'PCO0060028',
u'PCO0060029',
u'PCO0060030',
u'PCO0060031',
u'PCO0060032',
u'PCO0060033',
u'PCO0060034',
u'PCO0060035',
u'PCO0060036',
u'PCO0060037',
u'PCO0060038',
u'PCO0060039',
u'PCO0070001',
u'PCO0070002',
u'PCO0070003',
u'PCO0070004',
u'PCO0070005',
u'PCO0070006',
u'PCO0070007',
u'PCO0070008',
u'PCO0070009',
u'PCO0070010',
u'PCO0070011',
u'PCO0070012',
u'PCO0070013',
u'PCO0070014',
u'PCO0070015',
u'PCO0070016',
u'PCO0070017',
u'PCO0070018',
u'PCO0070019',
u'PCO0070020',
u'PCO0070021',
u'PCO0070022',
u'PCO0070023',
u'PCO0070024',
u'PCO0070025',
u'PCO0070026',
u'PCO0070027',
u'PCO0070028',
u'PCO0070029',
u'PCO0070030',
u'PCO0070031',
u'PCO0070032',
u'PCO0070033',
u'PCO0070034',
u'PCO0070035',
u'PCO0070036',
u'PCO0070037',
u'PCO0070038',
u'PCO0070039',
u'PCO0080001',
u'PCO0080002',
u'PCO0080003',
u'PCO0080004',
u'PCO0080005',
u'PCO0080006',
u'PCO0080007',
u'PCO0080008',
u'PCO0080009',
u'PCO0080010',
u'PCO0080011',
u'PCO0080012',
u'PCO0080013',
u'PCO0080014',
u'PCO0080015',
u'PCO0080016',
u'PCO0080017',
u'PCO0080018',
u'PCO0080019',
u'PCO0080020',
u'PCO0080021',
u'PCO0080022',
u'PCO0080023',
u'PCO0080024',
u'PCO0080025',
u'PCO0080026',
u'PCO0080027',
u'PCO0080028',
u'PCO0080029',
u'PCO0080030',
u'PCO0080031',
u'PCO0080032',
u'PCO0080033',
u'PCO0080034',
u'PCO0080035',
u'PCO0080036',
u'PCO0080037',
u'PCO0080038',
u'PCO0080039',
u'PCO0090001',
u'PCO0090002',
u'PCO0090003',
u'PCO0090004',
u'PCO0090005',
u'PCO0090006',
u'PCO0090007',
u'PCO0090008',
u'PCO0090009',
u'PCO0090010',
u'PCO0090011',
u'PCO0090012',
u'PCO0090013',
u'PCO0090014',
u'PCO0090015',
u'PCO0090016',
u'PCO0090017',
u'PCO0090018',
u'PCO0090019',
u'PCO0090020',
u'PCO0090021',
u'PCO0090022',
u'PCO0090023',
u'PCO0090024',
u'PCO0090025',
u'PCO0090026',
u'PCO0090027',
u'PCO0090028',
u'PCO0090029',
u'PCO0090030',
u'PCO0090031',
u'PCO0090032',
u'PCO0090033',
u'PCO0090034',
u'PCO0090035',
u'PCO0090036',
u'PCO0090037',
u'PCO0090038',
u'PCO0090039',
u'PCO0100001',
u'PCO0100002',
u'PCO0100003',
u'PCO0100004',
u'PCO0100005',
u'PCO0100006',
u'PCO0100007',
u'PCO0100008',
u'PCO0100009',
u'PCO0100010',
u'PCO0100011',
u'PCO0100012',
u'PCO0100013',
u'PCO0100014',
u'PCO0100015',
u'PCO0100016',
u'PCO0100017',
u'PCO0100018',
u'PCO0100019',
u'PCO0100020',
u'PCO0100021',
u'PCO0100022',
u'PCO0100023',
u'PCO0100024',
u'PCO0100025',
u'PCO0100026',
u'PCO0100027',
u'PCO0100028',
u'PCO0100029',
u'PCO0100030',
u'PCO0100031',
u'PCO0100032',
u'PCO0100033',
u'PCO0100034',
u'PCO0100035',
u'PCO0100036',
u'PCO0100037',
u'PCO0100038',
u'PCO0100039',
u'PCT0010001',
u'PCT0010002',
u'PCT0010003',
u'PCT0010004',
u'PCT0010005',
u'PCT0010006',
u'PCT0010007',
u'PCT0010008',
u'PCT0010009',
u'PCT0010010',
u'PCT0010011',
u'PCT0010012',
u'PCT0010013',
u'PCT0010014',
u'PCT0010015',
u'PCT0010016',
u'PCT0010017',
u'PCT0010018',
u'PCT0010019',
u'PCT0010020',
u'PCT0010021',
u'PCT0010022',
u'PCT0010023',
u'PCT0010024',
u'PCT0010025',
u'PCT0010026',
u'PCT0010027',
u'PCT0010028',
u'PCT0010029',
u'PCT0010030',
u'PCT0010031',
u'PCT0010032',
u'PCT0010033',
u'PCT0010034',
u'PCT0010035',
u'PCT0010036',
u'PCT0010037',
u'PCT0010038',
u'PCT0010039',
u'PCT0010040',
u'PCT0010041',
u'PCT0010042',
u'PCT0010043',
u'PCT0010044',
u'PCT0010045',
u'PCT0010046',
u'PCT0010047',
u'PCT0010048',
u'PCT0010049',
u'PCT0010050',
u'PCT0010051',
u'PCT0010052',
u'PCT0010053',
u'PCT0010054',
u'PCT0020001',
u'PCT0020002',
u'PCT0020003',
u'PCT0020004',
u'PCT0020005',
u'PCT0020006',
u'PCT0020007',
u'PCT0020008',
u'PCT0020009',
u'PCT0020010',
u'PCT0020011',
u'PCT0020012',
u'PCT0020013',
u'PCT0020014',
u'PCT0020015',
u'PCT0020016',
u'PCT0020017',
u'PCT0020018',
u'PCT0020019',
u'PCT0020020',
u'PCT0020021',
u'PCT0020022',
u'PCT0020023',
u'PCT0020024',
u'PCT0020025',
u'PCT0020026',
u'PCT0020027',
u'PCT0020028',
u'PCT0020029',
u'PCT0020030',
u'PCT0020031',
u'PCT0020032',
u'PCT0020033',
u'PCT0020034',
u'PCT0020035',
u'PCT0020036',
u'PCT0020037',
u'PCT0020038',
u'PCT0020039',
u'PCT0020040',
u'PCT0020041',
u'PCT0020042',
u'PCT0020043',
u'PCT0020044',
u'PCT0020045',
u'PCT0020046',
u'PCT0020047',
u'PCT0020048',
u'PCT0020049',
u'PCT0020050',
u'PCT0020051',
u'PCT0020052',
u'PCT0020053',
u'PCT0020054',
u'PCT0030001',
u'PCT0030002',
u'PCT0030003',
u'PCT0030004',
u'PCT0030005',
u'PCT0030006',
u'PCT0030007',
u'PCT0030008',
u'PCT0030009',
u'PCT0030010',
u'PCT0030011',
u'PCT0030012',
u'PCT0030013',
u'PCT0030014',
u'PCT0030015',
u'PCT0030016',
u'PCT0030017',
u'PCT0030018',
u'PCT0030019',
u'PCT0030020',
u'PCT0030021',
u'PCT0030022',
u'PCT0030023',
u'PCT0030024',
u'PCT0030025',
u'PCT0030026',
u'PCT0030027',
u'PCT0030028',
u'PCT0030029',
u'PCT0030030',
u'PCT0030031',
u'PCT0030032',
u'PCT0030033',
u'PCT0030034',
u'PCT0030035',
u'PCT0030036',
u'PCT0030037',
u'PCT0030038',
u'PCT0030039',
u'PCT0030040',
u'PCT0030041',
u'PCT0030042',
u'PCT0030043',
u'PCT0030044',
u'PCT0030045',
u'PCT0030046',
u'PCT0030047',
u'PCT0030048',
u'PCT0030049',
u'PCT0030050',
u'PCT0030051',
u'PCT0030052',
u'PCT0030053',
u'PCT0030054',
u'PCT0040001',
u'PCT0040002',
u'PCT0040003',
u'PCT0040004',
u'PCT0040005',
u'PCT0040006',
u'PCT0040007',
u'PCT0040008',
u'PCT0040009',
u'PCT0050001',
u'PCT0050002',
u'PCT0050003',
u'PCT0050004',
u'PCT0050005',
u'PCT0050006',
u'PCT0050007',
u'PCT0050008',
u'PCT0050009',
u'PCT0050010',
u'PCT0050011',
u'PCT0050012',
u'PCT0050013',
u'PCT0050014',
u'PCT0050015',
u'PCT0050016',
u'PCT0050017',
u'PCT0050018',
u'PCT0050019',
u'PCT0050020',
u'PCT0050021',
u'PCT0050022',
u'PCT0060001',
u'PCT0060002',
u'PCT0060003',
u'PCT0060004',
u'PCT0060005',
u'PCT0060006',
u'PCT0060007',
u'PCT0060008',
u'PCT0060009',
u'PCT0060010',
u'PCT0060011',
u'PCT0060012',
u'PCT0060013',
u'PCT0060014',
u'PCT0060015',
u'PCT0060016',
u'PCT0060017',
u'PCT0060018',
u'PCT0060019',
u'PCT0060020',
u'PCT0060021',
u'PCT0060022',
u'PCT0070001',
u'PCT0070002',
u'PCT0070003',
u'PCT0070004',
u'PCT0070005',
u'PCT0070006',
u'PCT0070007',
u'PCT0070008',
u'PCT0070009',
u'PCT0070010',
u'PCT0070011',
u'PCT0070012',
u'PCT0070013',
u'PCT0070014',
u'PCT0070015',
u'PCT0070016',
u'PCT0070017',
u'PCT0070018',
u'PCT0070019',
u'PCT0070020',
u'PCT0070021',
u'PCT0070022',
u'PCT0080001',
u'PCT0080002',
u'PCT0080003',
u'PCT0080004',
u'PCT0080005',
u'PCT0080006',
u'PCT0080007',
u'PCT0080008',
u'PCT0080009',
u'PCT0080010',
u'PCT0080011',
u'PCT0080012',
u'PCT0080013',
u'PCT0080014',
u'PCT0090001',
u'PCT0090002',
u'PCT0090003',
u'PCT0090004',
u'PCT0090005',
u'PCT0090006',
u'PCT0090007',
u'PCT0090008',
u'PCT0090009',
u'PCT0090010',
u'PCT0090011',
u'PCT0090012',
u'PCT0090013',
u'PCT0090014',
u'PCT0100001',
u'PCT0100002',
u'PCT0100003',
u'PCT0100004',
u'PCT0100005',
u'PCT0100006',
u'PCT0100007',
u'PCT0100008',
u'PCT0100009',
u'PCT0100010',
u'PCT0100011',
u'PCT0100012',
u'PCT0100013',
u'PCT0100014',
u'PCT0110001',
u'PCT0110002',
u'PCT0110003',
u'PCT0110004',
u'PCT0110005',
u'PCT0110006',
u'PCT0110007',
u'PCT0110008',
u'PCT0110009',
u'PCT0110010',
u'PCT0110011',
u'PCT0110012',
u'PCT0110013',
u'PCT0110014',
u'PCT0110015',
u'PCT0110016',
u'PCT0110017',
u'PCT0110018',
u'PCT0110019',
u'PCT0110020',
u'PCT0110021',
u'PCT0110022',
u'PCT0110023',
u'PCT0110024',
u'PCT0110025',
u'PCT0110026',
u'PCT0110027',
u'PCT0110028',
u'PCT0110029',
u'PCT0110030',
u'PCT0110031',
u'PCT0120001',
u'PCT0120002',
u'PCT0120003',
u'PCT0120004',
u'PCT0120005',
u'PCT0120006',
u'PCT0120007',
u'PCT0120008',
u'PCT0120009',
u'PCT0120010',
u'PCT0120011',
u'PCT0120012',
u'PCT0120013',
u'PCT0120014',
u'PCT0120015',
u'PCT0120016',
u'PCT0120017',
u'PCT0120018',
u'PCT0120019',
u'PCT0120020',
u'PCT0120021',
u'PCT0120022',
u'PCT0120023',
u'PCT0120024',
u'PCT0120025',
u'PCT0120026',
u'PCT0120027',
u'PCT0120028',
u'PCT0120029',
u'PCT0120030',
u'PCT0120031',
u'PCT0120032',
u'PCT0120033',
u'PCT0120034',
u'PCT0120035',
u'PCT0120036',
u'PCT0120037',
u'PCT0120038',
u'PCT0120039',
u'PCT0120040',
u'PCT0120041',
u'PCT0120042',
u'PCT0120043',
u'PCT0120044',
u'PCT0120045',
u'PCT0120046',
u'PCT0120047',
u'PCT0120048',
u'PCT0120049',
u'PCT0120050',
u'PCT0120051',
u'PCT0120052',
u'PCT0120053',
u'PCT0120054',
u'PCT0120055',
u'PCT0120056',
u'PCT0120057',
u'PCT0120058',
u'PCT0120059',
u'PCT0120060',
u'PCT0120061',
u'PCT0120062',
u'PCT0120063',
u'PCT0120064',
u'PCT0120065',
u'PCT0120066',
u'PCT0120067',
u'PCT0120068',
u'PCT0120069',
u'PCT0120070',
u'PCT0120071',
u'PCT0120072',
u'PCT0120073',
u'PCT0120074',
u'PCT0120075',
u'PCT0120076',
u'PCT0120077',
u'PCT0120078',
u'PCT0120079',
u'PCT0120080',
u'PCT0120081',
u'PCT0120082',
u'PCT0120083',
u'PCT0120084',
u'PCT0120085',
u'PCT0120086',
u'PCT0120087',
u'PCT0120088',
u'PCT0120089',
u'PCT0120090',
u'PCT0120091',
u'PCT0120092',
u'PCT0120093',
u'PCT0120094',
u'PCT0120095',
u'PCT0120096',
u'PCT0120097',
u'PCT0120098',
u'PCT0120099',
u'PCT0120100',
u'PCT0120101',
u'PCT0120102',
u'PCT0120103',
u'PCT0120104',
u'PCT0120105',
u'PCT0120106',
u'PCT0120107',
u'PCT0120108',
u'PCT0120109',
u'PCT0120110',
u'PCT0120111',
u'PCT0120112',
u'PCT0120113',
u'PCT0120114',
u'PCT0120115',
u'PCT0120116',
u'PCT0120117',
u'PCT0120118',
u'PCT0120119',
u'PCT0120120',
u'PCT0120121',
u'PCT0120122',
u'PCT0120123',
u'PCT0120124',
u'PCT0120125',
u'PCT0120126',
u'PCT0120127',
u'PCT0120128',
u'PCT0120129',
u'PCT0120130',
u'PCT0120131',
u'PCT0120132',
u'PCT0120133',
u'PCT0120134',
u'PCT0120135',
u'PCT0120136',
u'PCT0120137',
u'PCT0120138',
u'PCT0120139',
u'PCT0120140',
u'PCT0120141',
u'PCT0120142',
u'PCT0120143',
u'PCT0120144',
u'PCT0120145',
u'PCT0120146',
u'PCT0120147',
u'PCT0120148',
u'PCT0120149',
u'PCT0120150',
u'PCT0120151',
u'PCT0120152',
u'PCT0120153',
u'PCT0120154',
u'PCT0120155',
u'PCT0120156',
u'PCT0120157',
u'PCT0120158',
u'PCT0120159',
u'PCT0120160',
u'PCT0120161',
u'PCT0120162',
u'PCT0120163',
u'PCT0120164',
u'PCT0120165',
u'PCT0120166',
u'PCT0120167',
u'PCT0120168',
u'PCT0120169',
u'PCT0120170',
u'PCT0120171',
u'PCT0120172',
u'PCT0120173',
u'PCT0120174',
u'PCT0120175',
u'PCT0120176',
u'PCT0120177',
u'PCT0120178',
u'PCT0120179',
u'PCT0120180',
u'PCT0120181',
u'PCT0120182',
u'PCT0120183',
u'PCT0120184',
u'PCT0120185',
u'PCT0120186',
u'PCT0120187',
u'PCT0120188',
u'PCT0120189',
u'PCT0120190',
u'PCT0120191',
u'PCT0120192',
u'PCT0120193',
u'PCT0120194',
u'PCT0120195',
u'PCT0120196',
u'PCT0120197',
u'PCT0120198',
u'PCT0120199',
u'PCT0120200',
u'PCT0120201',
u'PCT0120202',
u'PCT0120203',
u'PCT0120204',
u'PCT0120205',
u'PCT0120206',
u'PCT0120207',
u'PCT0120208',
u'PCT0120209',
u'PCT012A001',
u'PCT012A002',
u'PCT012A003',
u'PCT012A004',
u'PCT012A005',
u'PCT012A006',
u'PCT012A007',
u'PCT012A008',
u'PCT012A009',
u'PCT012A010',
u'PCT012A011',
u'PCT012A012',
u'PCT012A013',
u'PCT012A014',
u'PCT012A015',
u'PCT012A016',
u'PCT012A017',
u'PCT012A018',
u'PCT012A019',
u'PCT012A020',
u'PCT012A021',
u'PCT012A022',
u'PCT012A023',
u'PCT012A024',
u'PCT012A025',
u'PCT012A026',
u'PCT012A027',
u'PCT012A028',
u'PCT012A029',
u'PCT012A030',
u'PCT012A031',
u'PCT012A032',
u'PCT012A033',
u'PCT012A034',
u'PCT012A035',
u'PCT012A036',
u'PCT012A037',
u'PCT012A038',
u'PCT012A039',
u'PCT012A040',
u'PCT012A041',
u'PCT012A042',
u'PCT012A043',
u'PCT012A044',
u'PCT012A045',
u'PCT012A046',
u'PCT012A047',
u'PCT012A048',
u'PCT012A049',
u'PCT012A050',
u'PCT012A051',
u'PCT012A052',
u'PCT012A053',
u'PCT012A054',
u'PCT012A055',
u'PCT012A056',
u'PCT012A057',
u'PCT012A058',
u'PCT012A059',
u'PCT012A060',
u'PCT012A061',
u'PCT012A062',
u'PCT012A063',
u'PCT012A064',
u'PCT012A065',
u'PCT012A066',
u'PCT012A067',
u'PCT012A068',
u'PCT012A069',
u'PCT012A070',
u'PCT012A071',
u'PCT012A072',
u'PCT012A073',
u'PCT012A074',
u'PCT012A075',
u'PCT012A076',
u'PCT012A077',
u'PCT012A078',
u'PCT012A079',
u'PCT012A080',
u'PCT012A081',
u'PCT012A082',
u'PCT012A083',
u'PCT012A084',
u'PCT012A085',
u'PCT012A086',
u'PCT012A087',
u'PCT012A088',
u'PCT012A089',
u'PCT012A090',
u'PCT012A091',
u'PCT012A092',
u'PCT012A093',
u'PCT012A094',
u'PCT012A095',
u'PCT012A096',
u'PCT012A097',
u'PCT012A098',
u'PCT012A099',
u'PCT012A100',
u'PCT012A101',
u'PCT012A102',
u'PCT012A103',
u'PCT012A104',
u'PCT012A105',
u'PCT012A106',
u'PCT012A107',
u'PCT012A108',
u'PCT012A109',
u'PCT012A110',
u'PCT012A111',
u'PCT012A112',
u'PCT012A113',
u'PCT012A114',
u'PCT012A115',
u'PCT012A116',
u'PCT012A117',
u'PCT012A118',
u'PCT012A119',
u'PCT012A120',
u'PCT012A121',
u'PCT012A122',
u'PCT012A123',
u'PCT012A124',
u'PCT012A125',
u'PCT012A126',
u'PCT012A127',
u'PCT012A128',
u'PCT012A129',
u'PCT012A130',
u'PCT012A131',
u'PCT012A132',
u'PCT012A133',
u'PCT012A134',
u'PCT012A135',
u'PCT012A136',
u'PCT012A137',
u'PCT012A138',
u'PCT012A139',
u'PCT012A140',
u'PCT012A141',
u'PCT012A142',
u'PCT012A143',
u'PCT012A144',
u'PCT012A145',
u'PCT012A146',
u'PCT012A147',
u'PCT012A148',
u'PCT012A149',
u'PCT012A150',
u'PCT012A151',
u'PCT012A152',
u'PCT012A153',
u'PCT012A154',
u'PCT012A155',
u'PCT012A156',
u'PCT012A157',
u'PCT012A158',
u'PCT012A159',
u'PCT012A160',
u'PCT012A161',
u'PCT012A162',
u'PCT012A163',
u'PCT012A164',
u'PCT012A165',
u'PCT012A166',
u'PCT012A167',
u'PCT012A168',
u'PCT012A169',
u'PCT012A170',
u'PCT012A171',
u'PCT012A172',
u'PCT012A173',
u'PCT012A174',
u'PCT012A175',
u'PCT012A176',
u'PCT012A177',
u'PCT012A178',
u'PCT012A179',
u'PCT012A180',
u'PCT012A181',
u'PCT012A182',
u'PCT012A183',
u'PCT012A184',
u'PCT012A185',
u'PCT012A186',
u'PCT012A187',
u'PCT012A188',
u'PCT012A189',
u'PCT012A190',
u'PCT012A191',
u'PCT012A192',
u'PCT012A193',
u'PCT012A194',
u'PCT012A195',
u'PCT012A196',
u'PCT012A197',
u'PCT012A198',
u'PCT012A199',
u'PCT012A200',
u'PCT012A201',
u'PCT012A202',
u'PCT012A203',
u'PCT012A204',
u'PCT012A205',
u'PCT012A206',
u'PCT012A207',
u'PCT012A208',
u'PCT012A209',
u'PCT012B001',
u'PCT012B002',
u'PCT012B003',
u'PCT012B004',
u'PCT012B005',
u'PCT012B006',
u'PCT012B007',
u'PCT012B008',
u'PCT012B009',
u'PCT012B010',
u'PCT012B011',
u'PCT012B012',
u'PCT012B013',
u'PCT012B014',
u'PCT012B015',
u'PCT012B016',
u'PCT012B017',
u'PCT012B018',
u'PCT012B019',
u'PCT012B020',
u'PCT012B021',
u'PCT012B022',
u'PCT012B023',
u'PCT012B024',
u'PCT012B025',
u'PCT012B026',
u'PCT012B027',
u'PCT012B028',
u'PCT012B029',
u'PCT012B030',
u'PCT012B031',
u'PCT012B032',
u'PCT012B033',
u'PCT012B034',
u'PCT012B035',
u'PCT012B036',
u'PCT012B037',
u'PCT012B038',
u'PCT012B039',
u'PCT012B040',
u'PCT012B041',
u'PCT012B042',
u'PCT012B043',
u'PCT012B044',
u'PCT012B045',
u'PCT012B046',
u'PCT012B047',
u'PCT012B048',
u'PCT012B049',
u'PCT012B050',
u'PCT012B051',
u'PCT012B052',
u'PCT012B053',
u'PCT012B054',
u'PCT012B055',
u'PCT012B056',
u'PCT012B057',
u'PCT012B058',
u'PCT012B059',
u'PCT012B060',
u'PCT012B061',
u'PCT012B062',
u'PCT012B063',
u'PCT012B064',
u'PCT012B065',
u'PCT012B066',
u'PCT012B067',
u'PCT012B068',
u'PCT012B069',
u'PCT012B070',
u'PCT012B071',
u'PCT012B072',
u'PCT012B073',
u'PCT012B074',
u'PCT012B075',
u'PCT012B076',
u'PCT012B077',
u'PCT012B078',
u'PCT012B079',
u'PCT012B080',
u'PCT012B081',
u'PCT012B082',
u'PCT012B083',
u'PCT012B084',
u'PCT012B085',
u'PCT012B086',
u'PCT012B087',
u'PCT012B088',
u'PCT012B089',
u'PCT012B090',
u'PCT012B091',
u'PCT012B092',
u'PCT012B093',
u'PCT012B094',
u'PCT012B095',
u'PCT012B096',
u'PCT012B097',
u'PCT012B098',
u'PCT012B099',
u'PCT012B100',
u'PCT012B101',
u'PCT012B102',
u'PCT012B103',
u'PCT012B104',
u'PCT012B105',
u'PCT012B106',
u'PCT012B107',
u'PCT012B108',
u'PCT012B109',
u'PCT012B110',
u'PCT012B111',
u'PCT012B112',
u'PCT012B113',
u'PCT012B114',
u'PCT012B115',
u'PCT012B116',
u'PCT012B117',
u'PCT012B118',
u'PCT012B119',
u'PCT012B120',
u'PCT012B121',
u'PCT012B122',
u'PCT012B123',
u'PCT012B124',
u'PCT012B125',
u'PCT012B126',
u'PCT012B127',
u'PCT012B128',
u'PCT012B129',
u'PCT012B130',
u'PCT012B131',
u'PCT012B132',
u'PCT012B133',
u'PCT012B134',
u'PCT012B135',
u'PCT012B136',
u'PCT012B137',
u'PCT012B138',
u'PCT012B139',
u'PCT012B140',
u'PCT012B141',
u'PCT012B142',
u'PCT012B143',
u'PCT012B144',
u'PCT012B145',
u'PCT012B146',
u'PCT012B147',
u'PCT012B148',
u'PCT012B149',
u'PCT012B150',
u'PCT012B151',
u'PCT012B152',
u'PCT012B153',
u'PCT012B154',
u'PCT012B155',
u'PCT012B156',
u'PCT012B157',
u'PCT012B158',
u'PCT012B159',
u'PCT012B160',
u'PCT012B161',
u'PCT012B162',
u'PCT012B163',
u'PCT012B164',
u'PCT012B165',
u'PCT012B166',
u'PCT012B167',
u'PCT012B168',
u'PCT012B169',
u'PCT012B170',
u'PCT012B171',
u'PCT012B172',
u'PCT012B173',
u'PCT012B174',
u'PCT012B175',
u'PCT012B176',
u'PCT012B177',
u'PCT012B178',
u'PCT012B179',
u'PCT012B180',
u'PCT012B181',
u'PCT012B182',
u'PCT012B183',
u'PCT012B184',
u'PCT012B185',
u'PCT012B186',
u'PCT012B187',
u'PCT012B188',
u'PCT012B189',
u'PCT012B190',
u'PCT012B191',
u'PCT012B192',
u'PCT012B193',
u'PCT012B194',
u'PCT012B195',
u'PCT012B196',
u'PCT012B197',
u'PCT012B198',
u'PCT012B199',
u'PCT012B200',
u'PCT012B201',
u'PCT012B202',
u'PCT012B203',
u'PCT012B204',
u'PCT012B205',
u'PCT012B206',
u'PCT012B207',
u'PCT012B208',
u'PCT012B209',
u'PCT012C001',
u'PCT012C002',
u'PCT012C003',
u'PCT012C004',
u'PCT012C005',
u'PCT012C006',
u'PCT012C007',
u'PCT012C008',
u'PCT012C009',
u'PCT012C010',
u'PCT012C011',
u'PCT012C012',
u'PCT012C013',
u'PCT012C014',
u'PCT012C015',
u'PCT012C016',
u'PCT012C017',
u'PCT012C018',
u'PCT012C019',
u'PCT012C020',
u'PCT012C021',
u'PCT012C022',
u'PCT012C023',
u'PCT012C024',
u'PCT012C025',
u'PCT012C026',
u'PCT012C027',
u'PCT012C028',
u'PCT012C029',
u'PCT012C030',
u'PCT012C031',
u'PCT012C032',
u'PCT012C033',
u'PCT012C034',
u'PCT012C035',
u'PCT012C036',
u'PCT012C037',
u'PCT012C038',
u'PCT012C039',
u'PCT012C040',
u'PCT012C041',
u'PCT012C042',
u'PCT012C043',
u'PCT012C044',
u'PCT012C045',
u'PCT012C046',
u'PCT012C047',
u'PCT012C048',
u'PCT012C049',
u'PCT012C050',
u'PCT012C051',
u'PCT012C052',
u'PCT012C053',
u'PCT012C054',
u'PCT012C055',
u'PCT012C056',
u'PCT012C057',
u'PCT012C058',
u'PCT012C059',
u'PCT012C060',
u'PCT012C061',
u'PCT012C062',
u'PCT012C063',
u'PCT012C064',
u'PCT012C065',
u'PCT012C066',
u'PCT012C067',
u'PCT012C068',
u'PCT012C069',
u'PCT012C070',
u'PCT012C071',
u'PCT012C072',
u'PCT012C073',
u'PCT012C074',
u'PCT012C075',
u'PCT012C076',
u'PCT012C077',
u'PCT012C078',
u'PCT012C079',
u'PCT012C080',
u'PCT012C081',
u'PCT012C082',
u'PCT012C083',
u'PCT012C084',
u'PCT012C085',
u'PCT012C086',
u'PCT012C087',
u'PCT012C088',
u'PCT012C089',
u'PCT012C090',
u'PCT012C091',
u'PCT012C092',
u'PCT012C093',
u'PCT012C094',
u'PCT012C095',
u'PCT012C096',
u'PCT012C097',
u'PCT012C098',
u'PCT012C099',
u'PCT012C100',
u'PCT012C101',
u'PCT012C102',
u'PCT012C103',
u'PCT012C104',
u'PCT012C105',
u'PCT012C106',
u'PCT012C107',
u'PCT012C108',
u'PCT012C109',
u'PCT012C110',
u'PCT012C111',
u'PCT012C112',
u'PCT012C113',
u'PCT012C114',
u'PCT012C115',
u'PCT012C116',
u'PCT012C117',
u'PCT012C118',
u'PCT012C119',
u'PCT012C120',
u'PCT012C121',
u'PCT012C122',
u'PCT012C123',
u'PCT012C124',
u'PCT012C125',
u'PCT012C126',
u'PCT012C127',
u'PCT012C128',
u'PCT012C129',
u'PCT012C130',
u'PCT012C131',
u'PCT012C132',
u'PCT012C133',
u'PCT012C134',
u'PCT012C135',
u'PCT012C136',
u'PCT012C137',
u'PCT012C138',
u'PCT012C139',
u'PCT012C140',
u'PCT012C141',
u'PCT012C142',
u'PCT012C143',
u'PCT012C144',
u'PCT012C145',
u'PCT012C146',
u'PCT012C147',
u'PCT012C148',
u'PCT012C149',
u'PCT012C150',
u'PCT012C151',
u'PCT012C152',
u'PCT012C153',
u'PCT012C154',
u'PCT012C155',
u'PCT012C156',
u'PCT012C157',
u'PCT012C158',
u'PCT012C159',
u'PCT012C160',
u'PCT012C161',
u'PCT012C162',
u'PCT012C163',
u'PCT012C164',
u'PCT012C165',
u'PCT012C166',
u'PCT012C167',
u'PCT012C168',
u'PCT012C169',
u'PCT012C170',
u'PCT012C171',
u'PCT012C172',
u'PCT012C173',
u'PCT012C174',
u'PCT012C175',
u'PCT012C176',
u'PCT012C177',
u'PCT012C178',
u'PCT012C179',
u'PCT012C180',
u'PCT012C181',
u'PCT012C182',
u'PCT012C183',
u'PCT012C184',
u'PCT012C185',
u'PCT012C186',
u'PCT012C187',
u'PCT012C188',
u'PCT012C189',
u'PCT012C190',
u'PCT012C191',
u'PCT012C192',
u'PCT012C193',
u'PCT012C194',
u'PCT012C195',
u'PCT012C196',
u'PCT012C197',
u'PCT012C198',
u'PCT012C199',
u'PCT012C200',
u'PCT012C201',
u'PCT012C202',
u'PCT012C203',
u'PCT012C204',
u'PCT012C205',
u'PCT012C206',
u'PCT012C207',
u'PCT012C208',
u'PCT012C209',
u'PCT012D001',
u'PCT012D002',
u'PCT012D003',
u'PCT012D004',
u'PCT012D005',
u'PCT012D006',
u'PCT012D007',
u'PCT012D008',
u'PCT012D009',
u'PCT012D010',
u'PCT012D011',
u'PCT012D012',
u'PCT012D013',
u'PCT012D014',
u'PCT012D015',
u'PCT012D016',
u'PCT012D017',
u'PCT012D018',
u'PCT012D019',
u'PCT012D020',
u'PCT012D021',
u'PCT012D022',
u'PCT012D023',
u'PCT012D024',
u'PCT012D025',
u'PCT012D026',
u'PCT012D027',
u'PCT012D028',
u'PCT012D029',
u'PCT012D030',
u'PCT012D031',
u'PCT012D032',
u'PCT012D033',
u'PCT012D034',
u'PCT012D035',
u'PCT012D036',
u'PCT012D037',
u'PCT012D038',
u'PCT012D039',
u'PCT012D040',
u'PCT012D041',
u'PCT012D042',
u'PCT012D043',
u'PCT012D044',
u'PCT012D045',
u'PCT012D046',
u'PCT012D047',
u'PCT012D048',
u'PCT012D049',
u'PCT012D050',
u'PCT012D051',
u'PCT012D052',
u'PCT012D053',
u'PCT012D054',
u'PCT012D055',
u'PCT012D056',
u'PCT012D057',
u'PCT012D058',
u'PCT012D059',
u'PCT012D060',
u'PCT012D061',
u'PCT012D062',
u'PCT012D063',
u'PCT012D064',
u'PCT012D065',
u'PCT012D066',
u'PCT012D067',
u'PCT012D068',
u'PCT012D069',
u'PCT012D070',
u'PCT012D071',
u'PCT012D072',
u'PCT012D073',
u'PCT012D074',
u'PCT012D075',
u'PCT012D076',
u'PCT012D077',
u'PCT012D078',
u'PCT012D079',
u'PCT012D080',
u'PCT012D081',
u'PCT012D082',
u'PCT012D083',
u'PCT012D084',
u'PCT012D085',
u'PCT012D086',
u'PCT012D087',
u'PCT012D088',
u'PCT012D089',
u'PCT012D090',
u'PCT012D091',
u'PCT012D092',
u'PCT012D093',
u'PCT012D094',
u'PCT012D095',
u'PCT012D096',
u'PCT012D097',
u'PCT012D098',
u'PCT012D099',
u'PCT012D100',
u'PCT012D101',
u'PCT012D102',
u'PCT012D103',
u'PCT012D104',
u'PCT012D105',
u'PCT012D106',
u'PCT012D107',
u'PCT012D108',
u'PCT012D109',
u'PCT012D110',
u'PCT012D111',
u'PCT012D112',
u'PCT012D113',
u'PCT012D114',
u'PCT012D115',
u'PCT012D116',
u'PCT012D117',
u'PCT012D118',
u'PCT012D119',
u'PCT012D120',
u'PCT012D121',
u'PCT012D122',
u'PCT012D123',
u'PCT012D124',
u'PCT012D125',
u'PCT012D126',
u'PCT012D127',
u'PCT012D128',
u'PCT012D129',
u'PCT012D130',
u'PCT012D131',
u'PCT012D132',
u'PCT012D133',
u'PCT012D134',
u'PCT012D135',
u'PCT012D136',
u'PCT012D137',
u'PCT012D138',
u'PCT012D139',
u'PCT012D140',
u'PCT012D141',
u'PCT012D142',
u'PCT012D143',
u'PCT012D144',
u'PCT012D145',
u'PCT012D146',
u'PCT012D147',
u'PCT012D148',
u'PCT012D149',
u'PCT012D150',
u'PCT012D151',
u'PCT012D152',
u'PCT012D153',
u'PCT012D154',
u'PCT012D155',
u'PCT012D156',
u'PCT012D157',
u'PCT012D158',
u'PCT012D159',
u'PCT012D160',
u'PCT012D161',
u'PCT012D162',
u'PCT012D163',
u'PCT012D164',
u'PCT012D165',
u'PCT012D166',
u'PCT012D167',
u'PCT012D168',
u'PCT012D169',
u'PCT012D170',
u'PCT012D171',
u'PCT012D172',
u'PCT012D173',
u'PCT012D174',
u'PCT012D175',
u'PCT012D176',
u'PCT012D177',
u'PCT012D178',
u'PCT012D179',
u'PCT012D180',
u'PCT012D181',
u'PCT012D182',
u'PCT012D183',
u'PCT012D184',
u'PCT012D185',
u'PCT012D186',
u'PCT012D187',
u'PCT012D188',
u'PCT012D189',
u'PCT012D190',
u'PCT012D191',
u'PCT012D192',
u'PCT012D193',
u'PCT012D194',
u'PCT012D195',
u'PCT012D196',
u'PCT012D197',
u'PCT012D198',
u'PCT012D199',
u'PCT012D200',
u'PCT012D201',
u'PCT012D202',
u'PCT012D203',
u'PCT012D204',
u'PCT012D205',
u'PCT012D206',
u'PCT012D207',
u'PCT012D208',
u'PCT012D209',
u'PCT012E001',
u'PCT012E002',
u'PCT012E003',
u'PCT012E004',
u'PCT012E005',
u'PCT012E006',
u'PCT012E007',
u'PCT012E008',
u'PCT012E009',
u'PCT012E010',
u'PCT012E011',
u'PCT012E012',
u'PCT012E013',
u'PCT012E014',
u'PCT012E015',
u'PCT012E016',
u'PCT012E017',
u'PCT012E018',
u'PCT012E019',
u'PCT012E020',
u'PCT012E021',
u'PCT012E022',
u'PCT012E023',
u'PCT012E024',
u'PCT012E025',
u'PCT012E026',
u'PCT012E027',
u'PCT012E028',
u'PCT012E029',
u'PCT012E030',
u'PCT012E031',
u'PCT012E032',
u'PCT012E033',
u'PCT012E034',
u'PCT012E035',
u'PCT012E036',
u'PCT012E037',
u'PCT012E038',
u'PCT012E039',
u'PCT012E040',
u'PCT012E041',
u'PCT012E042',
u'PCT012E043',
u'PCT012E044',
u'PCT012E045',
u'PCT012E046',
u'PCT012E047',
u'PCT012E048',
u'PCT012E049',
u'PCT012E050',
u'PCT012E051',
u'PCT012E052',
u'PCT012E053',
u'PCT012E054',
u'PCT012E055',
u'PCT012E056',
u'PCT012E057',
u'PCT012E058',
u'PCT012E059',
u'PCT012E060',
u'PCT012E061',
u'PCT012E062',
u'PCT012E063',
u'PCT012E064',
u'PCT012E065',
u'PCT012E066',
u'PCT012E067',
u'PCT012E068',
u'PCT012E069',
u'PCT012E070',
u'PCT012E071',
u'PCT012E072',
u'PCT012E073',
u'PCT012E074',
u'PCT012E075',
u'PCT012E076',
u'PCT012E077',
u'PCT012E078',
u'PCT012E079',
u'PCT012E080',
u'PCT012E081',
u'PCT012E082',
u'PCT012E083',
u'PCT012E084',
u'PCT012E085',
u'PCT012E086',
u'PCT012E087',
u'PCT012E088',
u'PCT012E089',
u'PCT012E090',
u'PCT012E091',
u'PCT012E092',
u'PCT012E093',
u'PCT012E094',
u'PCT012E095',
u'PCT012E096',
u'PCT012E097',
u'PCT012E098',
u'PCT012E099',
u'PCT012E100',
u'PCT012E101',
u'PCT012E102',
u'PCT012E103',
u'PCT012E104',
u'PCT012E105',
u'PCT012E106',
u'PCT012E107',
u'PCT012E108',
u'PCT012E109',
u'PCT012E110',
u'PCT012E111',
u'PCT012E112',
u'PCT012E113',
u'PCT012E114',
u'PCT012E115',
u'PCT012E116',
u'PCT012E117',
u'PCT012E118',
u'PCT012E119',
u'PCT012E120',
u'PCT012E121',
u'PCT012E122',
u'PCT012E123',
u'PCT012E124',
u'PCT012E125',
u'PCT012E126',
u'PCT012E127',
u'PCT012E128',
u'PCT012E129',
u'PCT012E130',
u'PCT012E131',
u'PCT012E132',
u'PCT012E133',
u'PCT012E134',
u'PCT012E135',
u'PCT012E136',
u'PCT012E137',
u'PCT012E138',
u'PCT012E139',
u'PCT012E140',
u'PCT012E141',
u'PCT012E142',
u'PCT012E143',
u'PCT012E144',
u'PCT012E145',
u'PCT012E146',
u'PCT012E147',
u'PCT012E148',
u'PCT012E149',
u'PCT012E150',
u'PCT012E151',
u'PCT012E152',
u'PCT012E153',
u'PCT012E154',
u'PCT012E155',
u'PCT012E156',
u'PCT012E157',
u'PCT012E158',
u'PCT012E159',
u'PCT012E160',
u'PCT012E161',
u'PCT012E162',
u'PCT012E163',
u'PCT012E164',
u'PCT012E165',
u'PCT012E166',
u'PCT012E167',
u'PCT012E168',
u'PCT012E169',
u'PCT012E170',
u'PCT012E171',
u'PCT012E172',
u'PCT012E173',
u'PCT012E174',
u'PCT012E175',
u'PCT012E176',
u'PCT012E177',
u'PCT012E178',
u'PCT012E179',
u'PCT012E180',
u'PCT012E181',
u'PCT012E182',
u'PCT012E183',
u'PCT012E184',
u'PCT012E185',
u'PCT012E186',
u'PCT012E187',
u'PCT012E188',
u'PCT012E189',
u'PCT012E190',
u'PCT012E191',
u'PCT012E192',
u'PCT012E193',
u'PCT012E194',
u'PCT012E195',
u'PCT012E196',
u'PCT012E197',
u'PCT012E198',
u'PCT012E199',
u'PCT012E200',
u'PCT012E201',
u'PCT012E202',
u'PCT012E203',
u'PCT012E204',
u'PCT012E205',
u'PCT012E206',
u'PCT012E207',
u'PCT012E208',
u'PCT012E209',
u'PCT012F001',
u'PCT012F002',
u'PCT012F003',
u'PCT012F004',
u'PCT012F005',
u'PCT012F006',
u'PCT012F007',
u'PCT012F008',
u'PCT012F009',
u'PCT012F010',
u'PCT012F011',
u'PCT012F012',
u'PCT012F013',
u'PCT012F014',
u'PCT012F015',
u'PCT012F016',
u'PCT012F017',
u'PCT012F018',
u'PCT012F019',
u'PCT012F020',
u'PCT012F021',
u'PCT012F022',
u'PCT012F023',
u'PCT012F024',
u'PCT012F025',
u'PCT012F026',
u'PCT012F027',
u'PCT012F028',
u'PCT012F029',
u'PCT012F030',
u'PCT012F031',
u'PCT012F032',
u'PCT012F033',
u'PCT012F034',
u'PCT012F035',
u'PCT012F036',
u'PCT012F037',
u'PCT012F038',
u'PCT012F039',
u'PCT012F040',
u'PCT012F041',
u'PCT012F042',
u'PCT012F043',
u'PCT012F044',
u'PCT012F045',
u'PCT012F046',
u'PCT012F047',
u'PCT012F048',
u'PCT012F049',
u'PCT012F050',
u'PCT012F051',
u'PCT012F052',
u'PCT012F053',
u'PCT012F054',
u'PCT012F055',
u'PCT012F056',
u'PCT012F057',
u'PCT012F058',
u'PCT012F059',
u'PCT012F060',
u'PCT012F061',
u'PCT012F062',
u'PCT012F063',
u'PCT012F064',
u'PCT012F065',
u'PCT012F066',
u'PCT012F067',
u'PCT012F068',
u'PCT012F069',
u'PCT012F070',
u'PCT012F071',
u'PCT012F072',
u'PCT012F073',
u'PCT012F074',
u'PCT012F075',
u'PCT012F076',
u'PCT012F077',
u'PCT012F078',
u'PCT012F079',
u'PCT012F080',
u'PCT012F081',
u'PCT012F082',
u'PCT012F083',
u'PCT012F084',
u'PCT012F085',
u'PCT012F086',
u'PCT012F087',
u'PCT012F088',
u'PCT012F089',
u'PCT012F090',
u'PCT012F091',
u'PCT012F092',
u'PCT012F093',
u'PCT012F094',
u'PCT012F095',
u'PCT012F096',
u'PCT012F097',
u'PCT012F098',
u'PCT012F099',
u'PCT012F100',
u'PCT012F101',
u'PCT012F102',
u'PCT012F103',
u'PCT012F104',
u'PCT012F105',
u'PCT012F106',
u'PCT012F107',
u'PCT012F108',
u'PCT012F109',
u'PCT012F110',
u'PCT012F111',
u'PCT012F112',
u'PCT012F113',
u'PCT012F114',
u'PCT012F115',
u'PCT012F116',
u'PCT012F117',
u'PCT012F118',
u'PCT012F119',
u'PCT012F120',
u'PCT012F121',
u'PCT012F122',
u'PCT012F123',
u'PCT012F124',
u'PCT012F125',
u'PCT012F126',
u'PCT012F127',
u'PCT012F128',
u'PCT012F129',
u'PCT012F130',
u'PCT012F131',
u'PCT012F132',
u'PCT012F133',
u'PCT012F134',
u'PCT012F135',
u'PCT012F136',
u'PCT012F137',
u'PCT012F138',
u'PCT012F139',
u'PCT012F140',
u'PCT012F141',
u'PCT012F142',
u'PCT012F143',
u'PCT012F144',
u'PCT012F145',
u'PCT012F146',
u'PCT012F147',
u'PCT012F148',
u'PCT012F149',
u'PCT012F150',
u'PCT012F151',
u'PCT012F152',
u'PCT012F153',
u'PCT012F154',
u'PCT012F155',
u'PCT012F156',
u'PCT012F157',
u'PCT012F158',
u'PCT012F159',
u'PCT012F160',
u'PCT012F161',
u'PCT012F162',
u'PCT012F163',
u'PCT012F164',
u'PCT012F165',
u'PCT012F166',
u'PCT012F167',
u'PCT012F168',
u'PCT012F169',
u'PCT012F170',
u'PCT012F171',
u'PCT012F172',
u'PCT012F173',
u'PCT012F174',
u'PCT012F175',
u'PCT012F176',
u'PCT012F177',
u'PCT012F178',
u'PCT012F179',
u'PCT012F180',
u'PCT012F181',
u'PCT012F182',
u'PCT012F183',
u'PCT012F184',
u'PCT012F185',
u'PCT012F186',
u'PCT012F187',
u'PCT012F188',
u'PCT012F189',
u'PCT012F190',
u'PCT012F191',
u'PCT012F192',
u'PCT012F193',
u'PCT012F194',
u'PCT012F195',
u'PCT012F196',
u'PCT012F197',
u'PCT012F198',
u'PCT012F199',
u'PCT012F200',
u'PCT012F201',
u'PCT012F202',
u'PCT012F203',
u'PCT012F204',
u'PCT012F205',
u'PCT012F206',
u'PCT012F207',
u'PCT012F208',
u'PCT012F209',
u'PCT012G001',
u'PCT012G002',
u'PCT012G003',
u'PCT012G004',
u'PCT012G005',
u'PCT012G006',
u'PCT012G007',
u'PCT012G008',
u'PCT012G009',
u'PCT012G010',
u'PCT012G011',
u'PCT012G012',
u'PCT012G013',
u'PCT012G014',
u'PCT012G015',
u'PCT012G016',
u'PCT012G017',
u'PCT012G018',
u'PCT012G019',
u'PCT012G020',
u'PCT012G021',
u'PCT012G022',
u'PCT012G023',
u'PCT012G024',
u'PCT012G025',
u'PCT012G026',
u'PCT012G027',
u'PCT012G028',
u'PCT012G029',
u'PCT012G030',
u'PCT012G031',
u'PCT012G032',
u'PCT012G033',
u'PCT012G034',
u'PCT012G035',
u'PCT012G036',
u'PCT012G037',
u'PCT012G038',
u'PCT012G039',
u'PCT012G040',
u'PCT012G041',
u'PCT012G042',
u'PCT012G043',
u'PCT012G044',
u'PCT012G045',
u'PCT012G046',
u'PCT012G047',
u'PCT012G048',
u'PCT012G049',
u'PCT012G050',
u'PCT012G051',
u'PCT012G052',
u'PCT012G053',
u'PCT012G054',
u'PCT012G055',
u'PCT012G056',
u'PCT012G057',
u'PCT012G058',
u'PCT012G059',
u'PCT012G060',
u'PCT012G061',
u'PCT012G062',
u'PCT012G063',
u'PCT012G064',
u'PCT012G065',
u'PCT012G066',
u'PCT012G067',
u'PCT012G068',
u'PCT012G069',
u'PCT012G070',
u'PCT012G071',
u'PCT012G072',
u'PCT012G073',
u'PCT012G074',
u'PCT012G075',
u'PCT012G076',
u'PCT012G077',
u'PCT012G078',
u'PCT012G079',
u'PCT012G080',
u'PCT012G081',
u'PCT012G082',
u'PCT012G083',
u'PCT012G084',
u'PCT012G085',
u'PCT012G086',
u'PCT012G087',
u'PCT012G088',
u'PCT012G089',
u'PCT012G090',
u'PCT012G091',
u'PCT012G092',
u'PCT012G093',
u'PCT012G094',
u'PCT012G095',
u'PCT012G096',
u'PCT012G097',
u'PCT012G098',
u'PCT012G099',
u'PCT012G100',
u'PCT012G101',
u'PCT012G102',
u'PCT012G103',
u'PCT012G104',
u'PCT012G105',
u'PCT012G106',
u'PCT012G107',
u'PCT012G108',
u'PCT012G109',
u'PCT012G110',
u'PCT012G111',
u'PCT012G112',
u'PCT012G113',
u'PCT012G114',
u'PCT012G115',
u'PCT012G116',
u'PCT012G117',
u'PCT012G118',
u'PCT012G119',
u'PCT012G120',
u'PCT012G121',
u'PCT012G122',
u'PCT012G123',
u'PCT012G124',
u'PCT012G125',
u'PCT012G126',
u'PCT012G127',
u'PCT012G128',
u'PCT012G129',
u'PCT012G130',
u'PCT012G131',
u'PCT012G132',
u'PCT012G133',
u'PCT012G134',
u'PCT012G135',
u'PCT012G136',
u'PCT012G137',
u'PCT012G138',
u'PCT012G139',
u'PCT012G140',
u'PCT012G141',
u'PCT012G142',
u'PCT012G143',
u'PCT012G144',
u'PCT012G145',
u'PCT012G146',
u'PCT012G147',
u'PCT012G148',
u'PCT012G149',
u'PCT012G150',
u'PCT012G151',
u'PCT012G152',
u'PCT012G153',
u'PCT012G154',
u'PCT012G155',
u'PCT012G156',
u'PCT012G157',
u'PCT012G158',
u'PCT012G159',
u'PCT012G160',
u'PCT012G161',
u'PCT012G162',
u'PCT012G163',
u'PCT012G164',
u'PCT012G165',
u'PCT012G166',
u'PCT012G167',
u'PCT012G168',
u'PCT012G169',
u'PCT012G170',
u'PCT012G171',
u'PCT012G172',
u'PCT012G173',
u'PCT012G174',
u'PCT012G175',
u'PCT012G176',
u'PCT012G177',
u'PCT012G178',
u'PCT012G179',
u'PCT012G180',
u'PCT012G181',
u'PCT012G182',
u'PCT012G183',
u'PCT012G184',
u'PCT012G185',
u'PCT012G186',
u'PCT012G187',
u'PCT012G188',
u'PCT012G189',
u'PCT012G190',
u'PCT012G191',
u'PCT012G192',
u'PCT012G193',
u'PCT012G194',
u'PCT012G195',
u'PCT012G196',
u'PCT012G197',
u'PCT012G198',
u'PCT012G199',
u'PCT012G200',
u'PCT012G201',
u'PCT012G202',
u'PCT012G203',
u'PCT012G204',
u'PCT012G205',
u'PCT012G206',
u'PCT012G207',
u'PCT012G208',
u'PCT012G209',
u'PCT012H001',
u'PCT012H002',
u'PCT012H003',
u'PCT012H004',
u'PCT012H005',
u'PCT012H006',
u'PCT012H007',
u'PCT012H008',
u'PCT012H009',
u'PCT012H010',
u'PCT012H011',
u'PCT012H012',
u'PCT012H013',
u'PCT012H014',
u'PCT012H015',
u'PCT012H016',
u'PCT012H017',
u'PCT012H018',
u'PCT012H019',
u'PCT012H020',
u'PCT012H021',
u'PCT012H022',
u'PCT012H023',
u'PCT012H024',
u'PCT012H025',
u'PCT012H026',
u'PCT012H027',
u'PCT012H028',
u'PCT012H029',
u'PCT012H030',
u'PCT012H031',
u'PCT012H032',
u'PCT012H033',
u'PCT012H034',
u'PCT012H035',
u'PCT012H036',
u'PCT012H037',
u'PCT012H038',
u'PCT012H039',
u'PCT012H040',
u'PCT012H041',
u'PCT012H042',
u'PCT012H043',
u'PCT012H044',
u'PCT012H045',
u'PCT012H046',
u'PCT012H047',
u'PCT012H048',
u'PCT012H049',
u'PCT012H050',
u'PCT012H051',
u'PCT012H052',
u'PCT012H053',
u'PCT012H054',
u'PCT012H055',
u'PCT012H056',
u'PCT012H057',
u'PCT012H058',
u'PCT012H059',
u'PCT012H060',
u'PCT012H061',
u'PCT012H062',
u'PCT012H063',
u'PCT012H064',
u'PCT012H065',
u'PCT012H066',
u'PCT012H067',
u'PCT012H068',
u'PCT012H069',
u'PCT012H070',
u'PCT012H071',
u'PCT012H072',
u'PCT012H073',
u'PCT012H074',
u'PCT012H075',
u'PCT012H076',
u'PCT012H077',
u'PCT012H078',
u'PCT012H079',
u'PCT012H080',
u'PCT012H081',
u'PCT012H082',
u'PCT012H083',
u'PCT012H084',
u'PCT012H085',
u'PCT012H086',
u'PCT012H087',
u'PCT012H088',
u'PCT012H089',
u'PCT012H090',
u'PCT012H091',
u'PCT012H092',
u'PCT012H093',
u'PCT012H094',
u'PCT012H095',
u'PCT012H096',
u'PCT012H097',
u'PCT012H098',
u'PCT012H099',
u'PCT012H100',
u'PCT012H101',
u'PCT012H102',
u'PCT012H103',
u'PCT012H104',
u'PCT012H105',
u'PCT012H106',
u'PCT012H107',
u'PCT012H108',
u'PCT012H109',
u'PCT012H110',
u'PCT012H111',
u'PCT012H112',
u'PCT012H113',
u'PCT012H114',
u'PCT012H115',
u'PCT012H116',
u'PCT012H117',
u'PCT012H118',
u'PCT012H119',
u'PCT012H120',
u'PCT012H121',
u'PCT012H122',
u'PCT012H123',
u'PCT012H124',
u'PCT012H125',
u'PCT012H126',
u'PCT012H127',
u'PCT012H128',
u'PCT012H129',
u'PCT012H130',
u'PCT012H131',
u'PCT012H132',
u'PCT012H133',
u'PCT012H134',
u'PCT012H135',
u'PCT012H136',
u'PCT012H137',
u'PCT012H138',
u'PCT012H139',
u'PCT012H140',
u'PCT012H141',
u'PCT012H142',
u'PCT012H143',
u'PCT012H144',
u'PCT012H145',
u'PCT012H146',
u'PCT012H147',
u'PCT012H148',
u'PCT012H149',
u'PCT012H150',
u'PCT012H151',
u'PCT012H152',
u'PCT012H153',
u'PCT012H154',
u'PCT012H155',
u'PCT012H156',
u'PCT012H157',
u'PCT012H158',
u'PCT012H159',
u'PCT012H160',
u'PCT012H161',
u'PCT012H162',
u'PCT012H163',
u'PCT012H164',
u'PCT012H165',
u'PCT012H166',
u'PCT012H167',
u'PCT012H168',
u'PCT012H169',
u'PCT012H170',
u'PCT012H171',
u'PCT012H172',
u'PCT012H173',
u'PCT012H174',
u'PCT012H175',
u'PCT012H176',
u'PCT012H177',
u'PCT012H178',
u'PCT012H179',
u'PCT012H180',
u'PCT012H181',
u'PCT012H182',
u'PCT012H183',
u'PCT012H184',
u'PCT012H185',
u'PCT012H186',
u'PCT012H187',
u'PCT012H188',
u'PCT012H189',
u'PCT012H190',
u'PCT012H191',
u'PCT012H192',
u'PCT012H193',
u'PCT012H194',
u'PCT012H195',
u'PCT012H196',
u'PCT012H197',
u'PCT012H198',
u'PCT012H199',
u'PCT012H200',
u'PCT012H201',
u'PCT012H202',
u'PCT012H203',
u'PCT012H204',
u'PCT012H205',
u'PCT012H206',
u'PCT012H207',
u'PCT012H208',
u'PCT012H209',
u'PCT012I001',
u'PCT012I002',
u'PCT012I003',
u'PCT012I004',
u'PCT012I005',
u'PCT012I006',
u'PCT012I007',
u'PCT012I008',
u'PCT012I009',
u'PCT012I010',
u'PCT012I011',
u'PCT012I012',
u'PCT012I013',
u'PCT012I014',
u'PCT012I015',
u'PCT012I016',
u'PCT012I017',
u'PCT012I018',
u'PCT012I019',
u'PCT012I020',
u'PCT012I021',
u'PCT012I022',
u'PCT012I023',
u'PCT012I024',
u'PCT012I025',
u'PCT012I026',
u'PCT012I027',
u'PCT012I028',
u'PCT012I029',
u'PCT012I030',
u'PCT012I031',
u'PCT012I032',
u'PCT012I033',
u'PCT012I034',
u'PCT012I035',
u'PCT012I036',
u'PCT012I037',
u'PCT012I038',
u'PCT012I039',
u'PCT012I040',
u'PCT012I041',
u'PCT012I042',
u'PCT012I043',
u'PCT012I044',
u'PCT012I045',
u'PCT012I046',
u'PCT012I047',
u'PCT012I048',
u'PCT012I049',
u'PCT012I050',
u'PCT012I051',
u'PCT012I052',
u'PCT012I053',
u'PCT012I054',
u'PCT012I055',
u'PCT012I056',
u'PCT012I057',
u'PCT012I058',
u'PCT012I059',
u'PCT012I060',
u'PCT012I061',
u'PCT012I062',
u'PCT012I063',
u'PCT012I064',
u'PCT012I065',
u'PCT012I066',
u'PCT012I067',
u'PCT012I068',
u'PCT012I069',
u'PCT012I070',
u'PCT012I071',
u'PCT012I072',
u'PCT012I073',
u'PCT012I074',
u'PCT012I075',
u'PCT012I076',
u'PCT012I077',
u'PCT012I078',
u'PCT012I079',
u'PCT012I080',
u'PCT012I081',
u'PCT012I082',
u'PCT012I083',
u'PCT012I084',
u'PCT012I085',
u'PCT012I086',
u'PCT012I087',
u'PCT012I088',
u'PCT012I089',
u'PCT012I090',
u'PCT012I091',
u'PCT012I092',
u'PCT012I093',
u'PCT012I094',
u'PCT012I095',
u'PCT012I096',
u'PCT012I097',
u'PCT012I098',
u'PCT012I099',
u'PCT012I100',
u'PCT012I101',
u'PCT012I102',
u'PCT012I103',
u'PCT012I104',
u'PCT012I105',
u'PCT012I106',
u'PCT012I107',
u'PCT012I108',
u'PCT012I109',
u'PCT012I110',
u'PCT012I111',
u'PCT012I112',
u'PCT012I113',
u'PCT012I114',
u'PCT012I115',
u'PCT012I116',
u'PCT012I117',
u'PCT012I118',
u'PCT012I119',
u'PCT012I120',
u'PCT012I121',
u'PCT012I122',
u'PCT012I123',
u'PCT012I124',
u'PCT012I125',
u'PCT012I126',
u'PCT012I127',
u'PCT012I128',
u'PCT012I129',
u'PCT012I130',
u'PCT012I131',
u'PCT012I132',
u'PCT012I133',
u'PCT012I134',
u'PCT012I135',
u'PCT012I136',
u'PCT012I137',
u'PCT012I138',
u'PCT012I139',
u'PCT012I140',
u'PCT012I141',
u'PCT012I142',
u'PCT012I143',
u'PCT012I144',
u'PCT012I145',
u'PCT012I146',
u'PCT012I147',
u'PCT012I148',
u'PCT012I149',
u'PCT012I150',
u'PCT012I151',
u'PCT012I152',
u'PCT012I153',
u'PCT012I154',
u'PCT012I155',
u'PCT012I156',
u'PCT012I157',
u'PCT012I158',
u'PCT012I159',
u'PCT012I160',
u'PCT012I161',
u'PCT012I162',
u'PCT012I163',
u'PCT012I164',
u'PCT012I165',
u'PCT012I166',
u'PCT012I167',
u'PCT012I168',
u'PCT012I169',
u'PCT012I170',
u'PCT012I171',
u'PCT012I172',
u'PCT012I173',
u'PCT012I174',
u'PCT012I175',
u'PCT012I176',
u'PCT012I177',
u'PCT012I178',
u'PCT012I179',
u'PCT012I180',
u'PCT012I181',
u'PCT012I182',
u'PCT012I183',
u'PCT012I184',
u'PCT012I185',
u'PCT012I186',
u'PCT012I187',
u'PCT012I188',
u'PCT012I189',
u'PCT012I190',
u'PCT012I191',
u'PCT012I192',
u'PCT012I193',
u'PCT012I194',
u'PCT012I195',
u'PCT012I196',
u'PCT012I197',
u'PCT012I198',
u'PCT012I199',
u'PCT012I200',
u'PCT012I201',
u'PCT012I202',
u'PCT012I203',
u'PCT012I204',
u'PCT012I205',
u'PCT012I206',
u'PCT012I207',
u'PCT012I208',
u'PCT012I209',
u'PCT012J001',
u'PCT012J002',
u'PCT012J003',
u'PCT012J004',
u'PCT012J005',
u'PCT012J006',
u'PCT012J007',
u'PCT012J008',
u'PCT012J009',
u'PCT012J010',
u'PCT012J011',
u'PCT012J012',
u'PCT012J013',
u'PCT012J014',
u'PCT012J015',
u'PCT012J016',
u'PCT012J017',
u'PCT012J018',
u'PCT012J019',
u'PCT012J020',
u'PCT012J021',
u'PCT012J022',
u'PCT012J023',
u'PCT012J024',
u'PCT012J025',
u'PCT012J026',
u'PCT012J027',
u'PCT012J028',
u'PCT012J029',
u'PCT012J030',
u'PCT012J031',
u'PCT012J032',
u'PCT012J033',
u'PCT012J034',
u'PCT012J035',
u'PCT012J036',
u'PCT012J037',
u'PCT012J038',
u'PCT012J039',
u'PCT012J040',
u'PCT012J041',
u'PCT012J042',
u'PCT012J043',
u'PCT012J044',
u'PCT012J045',
u'PCT012J046',
u'PCT012J047',
u'PCT012J048',
u'PCT012J049',
u'PCT012J050',
u'PCT012J051',
u'PCT012J052',
u'PCT012J053',
u'PCT012J054',
u'PCT012J055',
u'PCT012J056',
u'PCT012J057',
u'PCT012J058',
u'PCT012J059',
u'PCT012J060',
u'PCT012J061',
u'PCT012J062',
u'PCT012J063',
u'PCT012J064',
u'PCT012J065',
u'PCT012J066',
u'PCT012J067',
u'PCT012J068',
u'PCT012J069',
u'PCT012J070',
u'PCT012J071',
u'PCT012J072',
u'PCT012J073',
u'PCT012J074',
u'PCT012J075',
u'PCT012J076',
u'PCT012J077',
u'PCT012J078',
u'PCT012J079',
u'PCT012J080',
u'PCT012J081',
u'PCT012J082',
u'PCT012J083',
u'PCT012J084',
u'PCT012J085',
u'PCT012J086',
u'PCT012J087',
u'PCT012J088',
u'PCT012J089',
u'PCT012J090',
u'PCT012J091',
u'PCT012J092',
u'PCT012J093',
u'PCT012J094',
u'PCT012J095',
u'PCT012J096',
u'PCT012J097',
u'PCT012J098',
u'PCT012J099',
u'PCT012J100',
u'PCT012J101',
u'PCT012J102',
u'PCT012J103',
u'PCT012J104',
u'PCT012J105',
u'PCT012J106',
u'PCT012J107',
u'PCT012J108',
u'PCT012J109',
u'PCT012J110',
u'PCT012J111',
u'PCT012J112',
u'PCT012J113',
u'PCT012J114',
u'PCT012J115',
u'PCT012J116',
u'PCT012J117',
u'PCT012J118',
u'PCT012J119',
u'PCT012J120',
u'PCT012J121',
u'PCT012J122',
u'PCT012J123',
u'PCT012J124',
u'PCT012J125',
u'PCT012J126',
u'PCT012J127',
u'PCT012J128',
u'PCT012J129',
u'PCT012J130',
u'PCT012J131',
u'PCT012J132',
u'PCT012J133',
u'PCT012J134',
u'PCT012J135',
u'PCT012J136',
u'PCT012J137',
u'PCT012J138',
u'PCT012J139',
u'PCT012J140',
u'PCT012J141',
u'PCT012J142',
u'PCT012J143',
u'PCT012J144',
u'PCT012J145',
u'PCT012J146',
u'PCT012J147',
u'PCT012J148',
u'PCT012J149',
u'PCT012J150',
u'PCT012J151',
u'PCT012J152',
u'PCT012J153',
u'PCT012J154',
u'PCT012J155',
u'PCT012J156',
u'PCT012J157',
u'PCT012J158',
u'PCT012J159',
u'PCT012J160',
u'PCT012J161',
u'PCT012J162',
u'PCT012J163',
u'PCT012J164',
u'PCT012J165',
u'PCT012J166',
u'PCT012J167',
u'PCT012J168',
u'PCT012J169',
u'PCT012J170',
u'PCT012J171',
u'PCT012J172',
u'PCT012J173',
u'PCT012J174',
u'PCT012J175',
u'PCT012J176',
u'PCT012J177',
u'PCT012J178',
u'PCT012J179',
u'PCT012J180',
u'PCT012J181',
u'PCT012J182',
u'PCT012J183',
u'PCT012J184',
u'PCT012J185',
u'PCT012J186',
u'PCT012J187',
u'PCT012J188',
u'PCT012J189',
u'PCT012J190',
u'PCT012J191',
u'PCT012J192',
u'PCT012J193',
u'PCT012J194',
u'PCT012J195',
u'PCT012J196',
u'PCT012J197',
u'PCT012J198',
u'PCT012J199',
u'PCT012J200',
u'PCT012J201',
u'PCT012J202',
u'PCT012J203',
u'PCT012J204',
u'PCT012J205',
u'PCT012J206',
u'PCT012J207',
u'PCT012J208',
u'PCT012J209',
u'PCT012K001',
u'PCT012K002',
u'PCT012K003',
u'PCT012K004',
u'PCT012K005',
u'PCT012K006',
u'PCT012K007',
u'PCT012K008',
u'PCT012K009',
u'PCT012K010',
u'PCT012K011',
u'PCT012K012',
u'PCT012K013',
u'PCT012K014',
u'PCT012K015',
u'PCT012K016',
u'PCT012K017',
u'PCT012K018',
u'PCT012K019',
u'PCT012K020',
u'PCT012K021',
u'PCT012K022',
u'PCT012K023',
u'PCT012K024',
u'PCT012K025',
u'PCT012K026',
u'PCT012K027',
u'PCT012K028',
u'PCT012K029',
u'PCT012K030',
u'PCT012K031',
u'PCT012K032',
u'PCT012K033',
u'PCT012K034',
u'PCT012K035',
u'PCT012K036',
u'PCT012K037',
u'PCT012K038',
u'PCT012K039',
u'PCT012K040',
u'PCT012K041',
u'PCT012K042',
u'PCT012K043',
u'PCT012K044',
u'PCT012K045',
u'PCT012K046',
u'PCT012K047',
u'PCT012K048',
u'PCT012K049',
u'PCT012K050',
u'PCT012K051',
u'PCT012K052',
u'PCT012K053',
u'PCT012K054',
u'PCT012K055',
u'PCT012K056',
u'PCT012K057',
u'PCT012K058',
u'PCT012K059',
u'PCT012K060',
u'PCT012K061',
u'PCT012K062',
u'PCT012K063',
u'PCT012K064',
u'PCT012K065',
u'PCT012K066',
u'PCT012K067',
u'PCT012K068',
u'PCT012K069',
u'PCT012K070',
u'PCT012K071',
u'PCT012K072',
u'PCT012K073',
u'PCT012K074',
u'PCT012K075',
u'PCT012K076',
u'PCT012K077',
u'PCT012K078',
u'PCT012K079',
u'PCT012K080',
u'PCT012K081',
u'PCT012K082',
u'PCT012K083',
u'PCT012K084',
u'PCT012K085',
u'PCT012K086',
u'PCT012K087',
u'PCT012K088',
u'PCT012K089',
u'PCT012K090',
u'PCT012K091',
u'PCT012K092',
u'PCT012K093',
u'PCT012K094',
u'PCT012K095',
u'PCT012K096',
u'PCT012K097',
u'PCT012K098',
u'PCT012K099',
u'PCT012K100',
u'PCT012K101',
u'PCT012K102',
u'PCT012K103',
u'PCT012K104',
u'PCT012K105',
u'PCT012K106',
u'PCT012K107',
u'PCT012K108',
u'PCT012K109',
u'PCT012K110',
u'PCT012K111',
u'PCT012K112',
u'PCT012K113',
u'PCT012K114',
u'PCT012K115',
u'PCT012K116',
u'PCT012K117',
u'PCT012K118',
u'PCT012K119',
u'PCT012K120',
u'PCT012K121',
u'PCT012K122',
u'PCT012K123',
u'PCT012K124',
u'PCT012K125',
u'PCT012K126',
u'PCT012K127',
u'PCT012K128',
u'PCT012K129',
u'PCT012K130',
u'PCT012K131',
u'PCT012K132',
u'PCT012K133',
u'PCT012K134',
u'PCT012K135',
u'PCT012K136',
u'PCT012K137',
u'PCT012K138',
u'PCT012K139',
u'PCT012K140',
u'PCT012K141',
u'PCT012K142',
u'PCT012K143',
u'PCT012K144',
u'PCT012K145',
u'PCT012K146',
u'PCT012K147',
u'PCT012K148',
u'PCT012K149',
u'PCT012K150',
u'PCT012K151',
u'PCT012K152',
u'PCT012K153',
u'PCT012K154',
u'PCT012K155',
u'PCT012K156',
u'PCT012K157',
u'PCT012K158',
u'PCT012K159',
u'PCT012K160',
u'PCT012K161',
u'PCT012K162',
u'PCT012K163',
u'PCT012K164',
u'PCT012K165',
u'PCT012K166',
u'PCT012K167',
u'PCT012K168',
u'PCT012K169',
u'PCT012K170',
u'PCT012K171',
u'PCT012K172',
u'PCT012K173',
u'PCT012K174',
u'PCT012K175',
u'PCT012K176',
u'PCT012K177',
u'PCT012K178',
u'PCT012K179',
u'PCT012K180',
u'PCT012K181',
u'PCT012K182',
u'PCT012K183',
u'PCT012K184',
u'PCT012K185',
u'PCT012K186',
u'PCT012K187',
u'PCT012K188',
u'PCT012K189',
u'PCT012K190',
u'PCT012K191',
u'PCT012K192',
u'PCT012K193',
u'PCT012K194',
u'PCT012K195',
u'PCT012K196',
u'PCT012K197',
u'PCT012K198',
u'PCT012K199',
u'PCT012K200',
u'PCT012K201',
u'PCT012K202',
u'PCT012K203',
u'PCT012K204',
u'PCT012K205',
u'PCT012K206',
u'PCT012K207',
u'PCT012K208',
u'PCT012K209',
u'PCT012L001',
u'PCT012L002',
u'PCT012L003',
u'PCT012L004',
u'PCT012L005',
u'PCT012L006',
u'PCT012L007',
u'PCT012L008',
u'PCT012L009',
u'PCT012L010',
u'PCT012L011',
u'PCT012L012',
u'PCT012L013',
u'PCT012L014',
u'PCT012L015',
u'PCT012L016',
u'PCT012L017',
u'PCT012L018',
u'PCT012L019',
u'PCT012L020',
u'PCT012L021',
u'PCT012L022',
u'PCT012L023',
u'PCT012L024',
u'PCT012L025',
u'PCT012L026',
u'PCT012L027',
u'PCT012L028',
u'PCT012L029',
u'PCT012L030',
u'PCT012L031',
u'PCT012L032',
u'PCT012L033',
u'PCT012L034',
u'PCT012L035',
u'PCT012L036',
u'PCT012L037',
u'PCT012L038',
u'PCT012L039',
u'PCT012L040',
u'PCT012L041',
u'PCT012L042',
u'PCT012L043',
u'PCT012L044',
u'PCT012L045',
u'PCT012L046',
u'PCT012L047',
u'PCT012L048',
u'PCT012L049',
u'PCT012L050',
u'PCT012L051',
u'PCT012L052',
u'PCT012L053',
u'PCT012L054',
u'PCT012L055',
u'PCT012L056',
u'PCT012L057',
u'PCT012L058',
u'PCT012L059',
u'PCT012L060',
u'PCT012L061',
u'PCT012L062',
u'PCT012L063',
u'PCT012L064',
u'PCT012L065',
u'PCT012L066',
u'PCT012L067',
u'PCT012L068',
u'PCT012L069',
u'PCT012L070',
u'PCT012L071',
u'PCT012L072',
u'PCT012L073',
u'PCT012L074',
u'PCT012L075',
u'PCT012L076',
u'PCT012L077',
u'PCT012L078',
u'PCT012L079',
u'PCT012L080',
u'PCT012L081',
u'PCT012L082',
u'PCT012L083',
u'PCT012L084',
u'PCT012L085',
u'PCT012L086',
u'PCT012L087',
u'PCT012L088',
u'PCT012L089',
u'PCT012L090',
u'PCT012L091',
u'PCT012L092',
u'PCT012L093',
u'PCT012L094',
u'PCT012L095',
u'PCT012L096',
u'PCT012L097',
u'PCT012L098',
u'PCT012L099',
u'PCT012L100',
u'PCT012L101',
u'PCT012L102',
u'PCT012L103',
u'PCT012L104',
u'PCT012L105',
u'PCT012L106',
u'PCT012L107',
u'PCT012L108',
u'PCT012L109',
u'PCT012L110',
u'PCT012L111',
u'PCT012L112',
u'PCT012L113',
u'PCT012L114',
u'PCT012L115',
u'PCT012L116',
u'PCT012L117',
u'PCT012L118',
u'PCT012L119',
u'PCT012L120',
u'PCT012L121',
u'PCT012L122',
u'PCT012L123',
u'PCT012L124',
u'PCT012L125',
u'PCT012L126',
u'PCT012L127',
u'PCT012L128',
u'PCT012L129',
u'PCT012L130',
u'PCT012L131',
u'PCT012L132',
u'PCT012L133',
u'PCT012L134',
u'PCT012L135',
u'PCT012L136',
u'PCT012L137',
u'PCT012L138',
u'PCT012L139',
u'PCT012L140',
u'PCT012L141',
u'PCT012L142',
u'PCT012L143',
u'PCT012L144',
u'PCT012L145',
u'PCT012L146',
u'PCT012L147',
u'PCT012L148',
u'PCT012L149',
u'PCT012L150',
u'PCT012L151',
u'PCT012L152',
u'PCT012L153',
u'PCT012L154',
u'PCT012L155',
u'PCT012L156',
u'PCT012L157',
u'PCT012L158',
u'PCT012L159',
u'PCT012L160',
u'PCT012L161',
u'PCT012L162',
u'PCT012L163',
u'PCT012L164',
u'PCT012L165',
u'PCT012L166',
u'PCT012L167',
u'PCT012L168',
u'PCT012L169',
u'PCT012L170',
u'PCT012L171',
u'PCT012L172',
u'PCT012L173',
u'PCT012L174',
u'PCT012L175',
u'PCT012L176',
u'PCT012L177',
u'PCT012L178',
u'PCT012L179',
u'PCT012L180',
u'PCT012L181',
u'PCT012L182',
u'PCT012L183',
u'PCT012L184',
u'PCT012L185',
u'PCT012L186',
u'PCT012L187',
u'PCT012L188',
u'PCT012L189',
u'PCT012L190',
u'PCT012L191',
u'PCT012L192',
u'PCT012L193',
u'PCT012L194',
u'PCT012L195',
u'PCT012L196',
u'PCT012L197',
u'PCT012L198',
u'PCT012L199',
u'PCT012L200',
u'PCT012L201',
u'PCT012L202',
u'PCT012L203',
u'PCT012L204',
u'PCT012L205',
u'PCT012L206',
u'PCT012L207',
u'PCT012L208',
u'PCT012L209',
u'PCT012M001',
u'PCT012M002',
u'PCT012M003',
u'PCT012M004',
u'PCT012M005',
u'PCT012M006',
u'PCT012M007',
u'PCT012M008',
u'PCT012M009',
u'PCT012M010',
u'PCT012M011',
u'PCT012M012',
u'PCT012M013',
u'PCT012M014',
u'PCT012M015',
u'PCT012M016',
u'PCT012M017',
u'PCT012M018',
u'PCT012M019',
u'PCT012M020',
u'PCT012M021',
u'PCT012M022',
u'PCT012M023',
u'PCT012M024',
u'PCT012M025',
u'PCT012M026',
u'PCT012M027',
u'PCT012M028',
u'PCT012M029',
u'PCT012M030',
u'PCT012M031',
u'PCT012M032',
u'PCT012M033',
u'PCT012M034',
u'PCT012M035',
u'PCT012M036',
u'PCT012M037',
u'PCT012M038',
u'PCT012M039',
u'PCT012M040',
u'PCT012M041',
u'PCT012M042',
u'PCT012M043',
u'PCT012M044',
u'PCT012M045',
u'PCT012M046',
u'PCT012M047',
u'PCT012M048',
u'PCT012M049',
u'PCT012M050',
u'PCT012M051',
u'PCT012M052',
u'PCT012M053',
u'PCT012M054',
u'PCT012M055',
u'PCT012M056',
u'PCT012M057',
u'PCT012M058',
u'PCT012M059',
u'PCT012M060',
u'PCT012M061',
u'PCT012M062',
u'PCT012M063',
u'PCT012M064',
u'PCT012M065',
u'PCT012M066',
u'PCT012M067',
u'PCT012M068',
u'PCT012M069',
u'PCT012M070',
u'PCT012M071',
u'PCT012M072',
u'PCT012M073',
u'PCT012M074',
u'PCT012M075',
u'PCT012M076',
u'PCT012M077',
u'PCT012M078',
u'PCT012M079',
u'PCT012M080',
u'PCT012M081',
u'PCT012M082',
u'PCT012M083',
u'PCT012M084',
u'PCT012M085',
u'PCT012M086',
u'PCT012M087',
u'PCT012M088',
u'PCT012M089',
u'PCT012M090',
u'PCT012M091',
u'PCT012M092',
u'PCT012M093',
u'PCT012M094',
u'PCT012M095',
u'PCT012M096',
u'PCT012M097',
u'PCT012M098',
u'PCT012M099',
u'PCT012M100',
u'PCT012M101',
u'PCT012M102',
u'PCT012M103',
u'PCT012M104',
u'PCT012M105',
u'PCT012M106',
u'PCT012M107',
u'PCT012M108',
u'PCT012M109',
u'PCT012M110',
u'PCT012M111',
u'PCT012M112',
u'PCT012M113',
u'PCT012M114',
u'PCT012M115',
u'PCT012M116',
u'PCT012M117',
u'PCT012M118',
u'PCT012M119',
u'PCT012M120',
u'PCT012M121',
u'PCT012M122',
u'PCT012M123',
u'PCT012M124',
u'PCT012M125',
u'PCT012M126',
u'PCT012M127',
u'PCT012M128',
u'PCT012M129',
u'PCT012M130',
u'PCT012M131',
u'PCT012M132',
u'PCT012M133',
u'PCT012M134',
u'PCT012M135',
u'PCT012M136',
u'PCT012M137',
u'PCT012M138',
u'PCT012M139',
u'PCT012M140',
u'PCT012M141',
u'PCT012M142',
u'PCT012M143',
u'PCT012M144',
u'PCT012M145',
u'PCT012M146',
u'PCT012M147',
u'PCT012M148',
u'PCT012M149',
u'PCT012M150',
u'PCT012M151',
u'PCT012M152',
u'PCT012M153',
u'PCT012M154',
u'PCT012M155',
u'PCT012M156',
u'PCT012M157',
u'PCT012M158',
u'PCT012M159',
u'PCT012M160',
u'PCT012M161',
u'PCT012M162',
u'PCT012M163',
u'PCT012M164',
u'PCT012M165',
u'PCT012M166',
u'PCT012M167',
u'PCT012M168',
u'PCT012M169',
u'PCT012M170',
u'PCT012M171',
u'PCT012M172',
u'PCT012M173',
u'PCT012M174',
u'PCT012M175',
u'PCT012M176',
u'PCT012M177',
u'PCT012M178',
u'PCT012M179',
u'PCT012M180',
u'PCT012M181',
u'PCT012M182',
u'PCT012M183',
u'PCT012M184',
u'PCT012M185',
u'PCT012M186',
u'PCT012M187',
u'PCT012M188',
u'PCT012M189',
u'PCT012M190',
u'PCT012M191',
u'PCT012M192',
u'PCT012M193',
u'PCT012M194',
u'PCT012M195',
u'PCT012M196',
u'PCT012M197',
u'PCT012M198',
u'PCT012M199',
u'PCT012M200',
u'PCT012M201',
u'PCT012M202',
u'PCT012M203',
u'PCT012M204',
u'PCT012M205',
u'PCT012M206',
u'PCT012M207',
u'PCT012M208',
u'PCT012M209',
u'PCT012N001',
u'PCT012N002',
u'PCT012N003',
u'PCT012N004',
u'PCT012N005',
u'PCT012N006',
u'PCT012N007',
u'PCT012N008',
u'PCT012N009',
u'PCT012N010',
u'PCT012N011',
u'PCT012N012',
u'PCT012N013',
u'PCT012N014',
u'PCT012N015',
u'PCT012N016',
u'PCT012N017',
u'PCT012N018',
u'PCT012N019',
u'PCT012N020',
u'PCT012N021',
u'PCT012N022',
u'PCT012N023',
u'PCT012N024',
u'PCT012N025',
u'PCT012N026',
u'PCT012N027',
u'PCT012N028',
u'PCT012N029',
u'PCT012N030',
u'PCT012N031',
u'PCT012N032',
u'PCT012N033',
u'PCT012N034',
u'PCT012N035',
u'PCT012N036',
u'PCT012N037',
u'PCT012N038',
u'PCT012N039',
u'PCT012N040',
u'PCT012N041',
u'PCT012N042',
u'PCT012N043',
u'PCT012N044',
u'PCT012N045',
u'PCT012N046',
u'PCT012N047',
u'PCT012N048',
u'PCT012N049',
u'PCT012N050',
u'PCT012N051',
u'PCT012N052',
u'PCT012N053',
u'PCT012N054',
u'PCT012N055',
u'PCT012N056',
u'PCT012N057',
u'PCT012N058',
u'PCT012N059',
u'PCT012N060',
u'PCT012N061',
u'PCT012N062',
u'PCT012N063',
u'PCT012N064',
u'PCT012N065',
u'PCT012N066',
u'PCT012N067',
u'PCT012N068',
u'PCT012N069',
u'PCT012N070',
u'PCT012N071',
u'PCT012N072',
u'PCT012N073',
u'PCT012N074',
u'PCT012N075',
u'PCT012N076',
u'PCT012N077',
u'PCT012N078',
u'PCT012N079',
u'PCT012N080',
u'PCT012N081',
u'PCT012N082',
u'PCT012N083',
u'PCT012N084',
u'PCT012N085',
u'PCT012N086',
u'PCT012N087',
u'PCT012N088',
u'PCT012N089',
u'PCT012N090',
u'PCT012N091',
u'PCT012N092',
u'PCT012N093',
u'PCT012N094',
u'PCT012N095',
u'PCT012N096',
u'PCT012N097',
u'PCT012N098',
u'PCT012N099',
u'PCT012N100',
u'PCT012N101',
u'PCT012N102',
u'PCT012N103',
u'PCT012N104',
u'PCT012N105',
u'PCT012N106',
u'PCT012N107',
u'PCT012N108',
u'PCT012N109',
u'PCT012N110',
u'PCT012N111',
u'PCT012N112',
u'PCT012N113',
u'PCT012N114',
u'PCT012N115',
u'PCT012N116',
u'PCT012N117',
u'PCT012N118',
u'PCT012N119',
u'PCT012N120',
u'PCT012N121',
u'PCT012N122',
u'PCT012N123',
u'PCT012N124',
u'PCT012N125',
u'PCT012N126',
u'PCT012N127',
u'PCT012N128',
u'PCT012N129',
u'PCT012N130',
u'PCT012N131',
u'PCT012N132',
u'PCT012N133',
u'PCT012N134',
u'PCT012N135',
u'PCT012N136',
u'PCT012N137',
u'PCT012N138',
u'PCT012N139',
u'PCT012N140',
u'PCT012N141',
u'PCT012N142',
u'PCT012N143',
u'PCT012N144',
u'PCT012N145',
u'PCT012N146',
u'PCT012N147',
u'PCT012N148',
u'PCT012N149',
u'PCT012N150',
u'PCT012N151',
u'PCT012N152',
u'PCT012N153',
u'PCT012N154',
u'PCT012N155',
u'PCT012N156',
u'PCT012N157',
u'PCT012N158',
u'PCT012N159',
u'PCT012N160',
u'PCT012N161',
u'PCT012N162',
u'PCT012N163',
u'PCT012N164',
u'PCT012N165',
u'PCT012N166',
u'PCT012N167',
u'PCT012N168',
u'PCT012N169',
u'PCT012N170',
u'PCT012N171',
u'PCT012N172',
u'PCT012N173',
u'PCT012N174',
u'PCT012N175',
u'PCT012N176',
u'PCT012N177',
u'PCT012N178',
u'PCT012N179',
u'PCT012N180',
u'PCT012N181',
u'PCT012N182',
u'PCT012N183',
u'PCT012N184',
u'PCT012N185',
u'PCT012N186',
u'PCT012N187',
u'PCT012N188',
u'PCT012N189',
u'PCT012N190',
u'PCT012N191',
u'PCT012N192',
u'PCT012N193',
u'PCT012N194',
u'PCT012N195',
u'PCT012N196',
u'PCT012N197',
u'PCT012N198',
u'PCT012N199',
u'PCT012N200',
u'PCT012N201',
u'PCT012N202',
u'PCT012N203',
u'PCT012N204',
u'PCT012N205',
u'PCT012N206',
u'PCT012N207',
u'PCT012N208',
u'PCT012N209',
u'PCT012O001',
u'PCT012O002',
u'PCT012O003',
u'PCT012O004',
u'PCT012O005',
u'PCT012O006',
u'PCT012O007',
u'PCT012O008',
u'PCT012O009',
u'PCT012O010',
u'PCT012O011',
u'PCT012O012',
u'PCT012O013',
u'PCT012O014',
u'PCT012O015',
u'PCT012O016',
u'PCT012O017',
u'PCT012O018',
u'PCT012O019',
u'PCT012O020',
u'PCT012O021',
u'PCT012O022',
u'PCT012O023',
u'PCT012O024',
u'PCT012O025',
u'PCT012O026',
u'PCT012O027',
u'PCT012O028',
u'PCT012O029',
u'PCT012O030',
u'PCT012O031',
u'PCT012O032',
u'PCT012O033',
u'PCT012O034',
u'PCT012O035',
u'PCT012O036',
u'PCT012O037',
u'PCT012O038',
u'PCT012O039',
u'PCT012O040',
u'PCT012O041',
u'PCT012O042',
u'PCT012O043',
u'PCT012O044',
u'PCT012O045',
u'PCT012O046',
u'PCT012O047',
u'PCT012O048',
u'PCT012O049',
u'PCT012O050',
u'PCT012O051',
u'PCT012O052',
u'PCT012O053',
u'PCT012O054',
u'PCT012O055',
u'PCT012O056',
u'PCT012O057',
u'PCT012O058',
u'PCT012O059',
u'PCT012O060',
u'PCT012O061',
u'PCT012O062',
u'PCT012O063',
u'PCT012O064',
u'PCT012O065',
u'PCT012O066',
u'PCT012O067',
u'PCT012O068',
u'PCT012O069',
u'PCT012O070',
u'PCT012O071',
u'PCT012O072',
u'PCT012O073',
u'PCT012O074',
u'PCT012O075',
u'PCT012O076',
u'PCT012O077',
u'PCT012O078',
u'PCT012O079',
u'PCT012O080',
u'PCT012O081',
u'PCT012O082',
u'PCT012O083',
u'PCT012O084',
u'PCT012O085',
u'PCT012O086',
u'PCT012O087',
u'PCT012O088',
u'PCT012O089',
u'PCT012O090',
u'PCT012O091',
u'PCT012O092',
u'PCT012O093',
u'PCT012O094',
u'PCT012O095',
u'PCT012O096',
u'PCT012O097',
u'PCT012O098',
u'PCT012O099',
u'PCT012O100',
u'PCT012O101',
u'PCT012O102',
u'PCT012O103',
u'PCT012O104',
u'PCT012O105',
u'PCT012O106',
u'PCT012O107',
u'PCT012O108',
u'PCT012O109',
u'PCT012O110',
u'PCT012O111',
u'PCT012O112',
u'PCT012O113',
u'PCT012O114',
u'PCT012O115',
u'PCT012O116',
u'PCT012O117',
u'PCT012O118',
u'PCT012O119',
u'PCT012O120',
u'PCT012O121',
u'PCT012O122',
u'PCT012O123',
u'PCT012O124',
u'PCT012O125',
u'PCT012O126',
u'PCT012O127',
u'PCT012O128',
u'PCT012O129',
u'PCT012O130',
u'PCT012O131',
u'PCT012O132',
u'PCT012O133',
u'PCT012O134',
u'PCT012O135',
u'PCT012O136',
u'PCT012O137',
u'PCT012O138',
u'PCT012O139',
u'PCT012O140',
u'PCT012O141',
u'PCT012O142',
u'PCT012O143',
u'PCT012O144',
u'PCT012O145',
u'PCT012O146',
u'PCT012O147',
u'PCT012O148',
u'PCT012O149',
u'PCT012O150',
u'PCT012O151',
u'PCT012O152',
u'PCT012O153',
u'PCT012O154',
u'PCT012O155',
u'PCT012O156',
u'PCT012O157',
u'PCT012O158',
u'PCT012O159',
u'PCT012O160',
u'PCT012O161',
u'PCT012O162',
u'PCT012O163',
u'PCT012O164',
u'PCT012O165',
u'PCT012O166',
u'PCT012O167',
u'PCT012O168',
u'PCT012O169',
u'PCT012O170',
u'PCT012O171',
u'PCT012O172',
u'PCT012O173',
u'PCT012O174',
u'PCT012O175',
u'PCT012O176',
u'PCT012O177',
u'PCT012O178',
u'PCT012O179',
u'PCT012O180',
u'PCT012O181',
u'PCT012O182',
u'PCT012O183',
u'PCT012O184',
u'PCT012O185',
u'PCT012O186',
u'PCT012O187',
u'PCT012O188',
u'PCT012O189',
u'PCT012O190',
u'PCT012O191',
u'PCT012O192',
u'PCT012O193',
u'PCT012O194',
u'PCT012O195',
u'PCT012O196',
u'PCT012O197',
u'PCT012O198',
u'PCT012O199',
u'PCT012O200',
u'PCT012O201',
u'PCT012O202',
u'PCT012O203',
u'PCT012O204',
u'PCT012O205',
u'PCT012O206',
u'PCT012O207',
u'PCT012O208',
u'PCT012O209',
u'PCT0130001',
u'PCT0130002',
u'PCT0130003',
u'PCT0130004',
u'PCT0130005',
u'PCT0130006',
u'PCT0130007',
u'PCT0130008',
u'PCT0130009',
u'PCT0130010',
u'PCT0130011',
u'PCT0130012',
u'PCT0130013',
u'PCT0130014',
u'PCT0130015',
u'PCT0130016',
u'PCT0130017',
u'PCT0130018',
u'PCT0130019',
u'PCT0130020',
u'PCT0130021',
u'PCT0130022',
u'PCT0130023',
u'PCT0130024',
u'PCT0130025',
u'PCT0130026',
u'PCT0130027',
u'PCT0130028',
u'PCT0130029',
u'PCT0130030',
u'PCT0130031',
u'PCT0130032',
u'PCT0130033',
u'PCT0130034',
u'PCT0130035',
u'PCT0130036',
u'PCT0130037',
u'PCT0130038',
u'PCT0130039',
u'PCT0130040',
u'PCT0130041',
u'PCT0130042',
u'PCT0130043',
u'PCT0130044',
u'PCT0130045',
u'PCT0130046',
u'PCT0130047',
u'PCT0130048',
u'PCT0130049',
u'PCT013A001',
u'PCT013A002',
u'PCT013A003',
u'PCT013A004',
u'PCT013A005',
u'PCT013A006',
u'PCT013A007',
u'PCT013A008',
u'PCT013A009',
u'PCT013A010',
u'PCT013A011',
u'PCT013A012',
u'PCT013A013',
u'PCT013A014',
u'PCT013A015',
u'PCT013A016',
u'PCT013A017',
u'PCT013A018',
u'PCT013A019',
u'PCT013A020',
u'PCT013A021',
u'PCT013A022',
u'PCT013A023',
u'PCT013A024',
u'PCT013A025',
u'PCT013A026',
u'PCT013A027',
u'PCT013A028',
u'PCT013A029',
u'PCT013A030',
u'PCT013A031',
u'PCT013A032',
u'PCT013A033',
u'PCT013A034',
u'PCT013A035',
u'PCT013A036',
u'PCT013A037',
u'PCT013A038',
u'PCT013A039',
u'PCT013A040',
u'PCT013A041',
u'PCT013A042',
u'PCT013A043',
u'PCT013A044',
u'PCT013A045',
u'PCT013A046',
u'PCT013A047',
u'PCT013A048',
u'PCT013A049',
u'PCT013B001',
u'PCT013B002',
u'PCT013B003',
u'PCT013B004',
u'PCT013B005',
u'PCT013B006',
u'PCT013B007',
u'PCT013B008',
u'PCT013B009',
u'PCT013B010',
u'PCT013B011',
u'PCT013B012',
u'PCT013B013',
u'PCT013B014',
u'PCT013B015',
u'PCT013B016',
u'PCT013B017',
u'PCT013B018',
u'PCT013B019',
u'PCT013B020',
u'PCT013B021',
u'PCT013B022',
u'PCT013B023',
u'PCT013B024',
u'PCT013B025',
u'PCT013B026',
u'PCT013B027',
u'PCT013B028',
u'PCT013B029',
u'PCT013B030',
u'PCT013B031',
u'PCT013B032',
u'PCT013B033',
u'PCT013B034',
u'PCT013B035',
u'PCT013B036',
u'PCT013B037',
u'PCT013B038',
u'PCT013B039',
u'PCT013B040',
u'PCT013B041',
u'PCT013B042',
u'PCT013B043',
u'PCT013B044',
u'PCT013B045',
u'PCT013B046',
u'PCT013B047',
u'PCT013B048',
u'PCT013B049',
u'PCT013C001',
u'PCT013C002',
u'PCT013C003',
u'PCT013C004',
u'PCT013C005',
u'PCT013C006',
u'PCT013C007',
u'PCT013C008',
u'PCT013C009',
u'PCT013C010',
u'PCT013C011',
u'PCT013C012',
u'PCT013C013',
u'PCT013C014',
u'PCT013C015',
u'PCT013C016',
u'PCT013C017',
u'PCT013C018',
u'PCT013C019',
u'PCT013C020',
u'PCT013C021',
u'PCT013C022',
u'PCT013C023',
u'PCT013C024',
u'PCT013C025',
u'PCT013C026',
u'PCT013C027',
u'PCT013C028',
u'PCT013C029',
u'PCT013C030',
u'PCT013C031',
u'PCT013C032',
u'PCT013C033',
u'PCT013C034',
u'PCT013C035',
u'PCT013C036',
u'PCT013C037',
u'PCT013C038',
u'PCT013C039',
u'PCT013C040',
u'PCT013C041',
u'PCT013C042',
u'PCT013C043',
u'PCT013C044',
u'PCT013C045',
u'PCT013C046',
u'PCT013C047',
u'PCT013C048',
u'PCT013C049',
u'PCT013D001',
u'PCT013D002',
u'PCT013D003',
u'PCT013D004',
u'PCT013D005',
u'PCT013D006',
u'PCT013D007',
u'PCT013D008',
u'PCT013D009',
u'PCT013D010',
u'PCT013D011',
u'PCT013D012',
u'PCT013D013',
u'PCT013D014',
u'PCT013D015',
u'PCT013D016',
u'PCT013D017',
u'PCT013D018',
u'PCT013D019',
u'PCT013D020',
u'PCT013D021',
u'PCT013D022',
u'PCT013D023',
u'PCT013D024',
u'PCT013D025',
u'PCT013D026',
u'PCT013D027',
u'PCT013D028',
u'PCT013D029',
u'PCT013D030',
u'PCT013D031',
u'PCT013D032',
u'PCT013D033',
u'PCT013D034',
u'PCT013D035',
u'PCT013D036',
u'PCT013D037',
u'PCT013D038',
u'PCT013D039',
u'PCT013D040',
u'PCT013D041',
u'PCT013D042',
u'PCT013D043',
u'PCT013D044',
u'PCT013D045',
u'PCT013D046',
u'PCT013D047',
u'PCT013D048',
u'PCT013D049',
u'PCT013E001',
u'PCT013E002',
u'PCT013E003',
u'PCT013E004',
u'PCT013E005',
u'PCT013E006',
u'PCT013E007',
u'PCT013E008',
u'PCT013E009',
u'PCT013E010',
u'PCT013E011',
u'PCT013E012',
u'PCT013E013',
u'PCT013E014',
u'PCT013E015',
u'PCT013E016',
u'PCT013E017',
u'PCT013E018',
u'PCT013E019',
u'PCT013E020',
u'PCT013E021',
u'PCT013E022',
u'PCT013E023',
u'PCT013E024',
u'PCT013E025',
u'PCT013E026',
u'PCT013E027',
u'PCT013E028',
u'PCT013E029',
u'PCT013E030',
u'PCT013E031',
u'PCT013E032',
u'PCT013E033',
u'PCT013E034',
u'PCT013E035',
u'PCT013E036',
u'PCT013E037',
u'PCT013E038',
u'PCT013E039',
u'PCT013E040',
u'PCT013E041',
u'PCT013E042',
u'PCT013E043',
u'PCT013E044',
u'PCT013E045',
u'PCT013E046',
u'PCT013E047',
u'PCT013E048',
u'PCT013E049',
u'PCT013F001',
u'PCT013F002',
u'PCT013F003',
u'PCT013F004',
u'PCT013F005',
u'PCT013F006',
u'PCT013F007',
u'PCT013F008',
u'PCT013F009',
u'PCT013F010',
u'PCT013F011',
u'PCT013F012',
u'PCT013F013',
u'PCT013F014',
u'PCT013F015',
u'PCT013F016',
u'PCT013F017',
u'PCT013F018',
u'PCT013F019',
u'PCT013F020',
u'PCT013F021',
u'PCT013F022',
u'PCT013F023',
u'PCT013F024',
u'PCT013F025',
u'PCT013F026',
u'PCT013F027',
u'PCT013F028',
u'PCT013F029',
u'PCT013F030',
u'PCT013F031',
u'PCT013F032',
u'PCT013F033',
u'PCT013F034',
u'PCT013F035',
u'PCT013F036',
u'PCT013F037',
u'PCT013F038',
u'PCT013F039',
u'PCT013F040',
u'PCT013F041',
u'PCT013F042',
u'PCT013F043',
u'PCT013F044',
u'PCT013F045',
u'PCT013F046',
u'PCT013F047',
u'PCT013F048',
u'PCT013F049',
u'PCT013G001',
u'PCT013G002',
u'PCT013G003',
u'PCT013G004',
u'PCT013G005',
u'PCT013G006',
u'PCT013G007',
u'PCT013G008',
u'PCT013G009',
u'PCT013G010',
u'PCT013G011',
u'PCT013G012',
u'PCT013G013',
u'PCT013G014',
u'PCT013G015',
u'PCT013G016',
u'PCT013G017',
u'PCT013G018',
u'PCT013G019',
u'PCT013G020',
u'PCT013G021',
u'PCT013G022',
u'PCT013G023',
u'PCT013G024',
u'PCT013G025',
u'PCT013G026',
u'PCT013G027',
u'PCT013G028',
u'PCT013G029',
u'PCT013G030',
u'PCT013G031',
u'PCT013G032',
u'PCT013G033',
u'PCT013G034',
u'PCT013G035',
u'PCT013G036',
u'PCT013G037',
u'PCT013G038',
u'PCT013G039',
u'PCT013G040',
u'PCT013G041',
u'PCT013G042',
u'PCT013G043',
u'PCT013G044',
u'PCT013G045',
u'PCT013G046',
u'PCT013G047',
u'PCT013G048',
u'PCT013G049',
u'PCT013H001',
u'PCT013H002',
u'PCT013H003',
u'PCT013H004',
u'PCT013H005',
u'PCT013H006',
u'PCT013H007',
u'PCT013H008',
u'PCT013H009',
u'PCT013H010',
u'PCT013H011',
u'PCT013H012',
u'PCT013H013',
u'PCT013H014',
u'PCT013H015',
u'PCT013H016',
u'PCT013H017',
u'PCT013H018',
u'PCT013H019',
u'PCT013H020',
u'PCT013H021',
u'PCT013H022',
u'PCT013H023',
u'PCT013H024',
u'PCT013H025',
u'PCT013H026',
u'PCT013H027',
u'PCT013H028',
u'PCT013H029',
u'PCT013H030',
u'PCT013H031',
u'PCT013H032',
u'PCT013H033',
u'PCT013H034',
u'PCT013H035',
u'PCT013H036',
u'PCT013H037',
u'PCT013H038',
u'PCT013H039',
u'PCT013H040',
u'PCT013H041',
u'PCT013H042',
u'PCT013H043',
u'PCT013H044',
u'PCT013H045',
u'PCT013H046',
u'PCT013H047',
u'PCT013H048',
u'PCT013H049',
u'PCT013I001',
u'PCT013I002',
u'PCT013I003',
u'PCT013I004',
u'PCT013I005',
u'PCT013I006',
u'PCT013I007',
u'PCT013I008',
u'PCT013I009',
u'PCT013I010',
u'PCT013I011',
u'PCT013I012',
u'PCT013I013',
u'PCT013I014',
u'PCT013I015',
u'PCT013I016',
u'PCT013I017',
u'PCT013I018',
u'PCT013I019',
u'PCT013I020',
u'PCT013I021',
u'PCT013I022',
u'PCT013I023',
u'PCT013I024',
u'PCT013I025',
u'PCT013I026',
u'PCT013I027',
u'PCT013I028',
u'PCT013I029',
u'PCT013I030',
u'PCT013I031',
u'PCT013I032',
u'PCT013I033',
u'PCT013I034',
u'PCT013I035',
u'PCT013I036',
u'PCT013I037',
u'PCT013I038',
u'PCT013I039',
u'PCT013I040',
u'PCT013I041',
u'PCT013I042',
u'PCT013I043',
u'PCT013I044',
u'PCT013I045',
u'PCT013I046',
u'PCT013I047',
u'PCT013I048',
u'PCT013I049',
u'PCT0140001',
u'PCT0140002',
u'PCT0140003',
u'PCT014A001',
u'PCT014A002',
u'PCT014A003',
u'PCT014B001',
u'PCT014B002',
u'PCT014B003',
u'PCT014C001',
u'PCT014C002',
u'PCT014C003',
u'PCT014D001',
u'PCT014D002',
u'PCT014D003',
u'PCT014E001',
u'PCT014E002',
u'PCT014E003',
u'PCT014F001',
u'PCT014F002',
u'PCT014F003',
u'PCT014G001',
u'PCT014G002',
u'PCT014G003',
u'PCT014H001',
u'PCT014H002',
u'PCT014H003',
u'PCT014I001',
u'PCT014I002',
u'PCT014I003',
u'PCT0150001',
u'PCT0150002',
u'PCT0150003',
u'PCT0150004',
u'PCT0150005',
u'PCT0150006',
u'PCT0150007',
u'PCT0150008',
u'PCT0150009',
u'PCT0150010',
u'PCT0150011',
u'PCT0150012',
u'PCT0150013',
u'PCT0150014',
u'PCT0150015',
u'PCT0150016',
u'PCT0150017',
u'PCT0150018',
u'PCT0150019',
u'PCT0150020',
u'PCT0150021',
u'PCT0150022',
u'PCT0150023',
u'PCT0150024',
u'PCT0150025',
u'PCT0150026',
u'PCT0150027',
u'PCT0150028',
u'PCT0150029',
u'PCT0150030',
u'PCT0150031',
u'PCT0150032',
u'PCT0150033',
u'PCT0150034',
u'PCT0160001',
u'PCT0160002',
u'PCT0160003',
u'PCT0160004',
u'PCT0160005',
u'PCT0160006',
u'PCT0160007',
u'PCT0160008',
u'PCT0160009',
u'PCT0160010',
u'PCT0160011',
u'PCT0160012',
u'PCT0160013',
u'PCT0160014',
u'PCT0160015',
u'PCT0160016',
u'PCT0160017',
u'PCT0160018',
u'PCT0160019',
u'PCT0160020',
u'PCT0160021',
u'PCT0160022',
u'PCT0160023',
u'PCT0160024',
u'PCT0160025',
u'PCT0160026',
u'PCT0170001',
u'PCT0170002',
u'PCT0170003',
u'PCT0170004',
u'PCT0170005',
u'PCT0170006',
u'PCT0170007',
u'PCT0170008',
u'PCT0170009',
u'PCT0170010',
u'PCT0170011',
u'PCT0170012',
u'PCT0170013',
u'PCT0170014',
u'PCT0170015',
u'PCT0170016',
u'PCT0170017',
u'PCT0170018',
u'PCT0180001',
u'PCT0180002',
u'PCT0180003',
u'PCT0180004',
u'PCT0180005',
u'PCT0180006',
u'PCT0180007',
u'PCT0180008',
u'PCT0180009',
u'PCT0180010',
u'PCT0180011',
u'PCT0180012',
u'PCT0180013',
u'PCT0180014',
u'PCT0180015',
u'PCT0190001',
u'PCT0190002',
u'PCT0190003',
u'PCT0190004',
u'PCT0190005',
u'PCT0190006',
u'PCT0190007',
u'PCT0190008',
u'PCT0190009',
u'PCT0190010',
u'PCT0190011',
u'PCT019A001',
u'PCT019A002',
u'PCT019A003',
u'PCT019A004',
u'PCT019A005',
u'PCT019A006',
u'PCT019A007',
u'PCT019A008',
u'PCT019A009',
u'PCT019A010',
u'PCT019A011',
u'PCT019B001',
u'PCT019B002',
u'PCT019B003',
u'PCT019B004',
u'PCT019B005',
u'PCT019B006',
u'PCT019B007',
u'PCT019B008',
u'PCT019B009',
u'PCT019B010',
u'PCT019B011',
u'PCT019C001',
u'PCT019C002',
u'PCT019C003',
u'PCT019C004',
u'PCT019C005',
u'PCT019C006',
u'PCT019C007',
u'PCT019C008',
u'PCT019C009',
u'PCT019C010',
u'PCT019C011',
u'PCT019D001',
u'PCT019D002',
u'PCT019D003',
u'PCT019D004',
u'PCT019D005',
u'PCT019D006',
u'PCT019D007',
u'PCT019D008',
u'PCT019D009',
u'PCT019D010',
u'PCT019D011',
u'PCT019E001',
u'PCT019E002',
u'PCT019E003',
u'PCT019E004',
u'PCT019E005',
u'PCT019E006',
u'PCT019E007',
u'PCT019E008',
u'PCT019E009',
u'PCT019E010',
u'PCT019E011',
u'PCT019F001',
u'PCT019F002',
u'PCT019F003',
u'PCT019F004',
u'PCT019F005',
u'PCT019F006',
u'PCT019F007',
u'PCT019F008',
u'PCT019F009',
u'PCT019F010',
u'PCT019F011',
u'PCT019G001',
u'PCT019G002',
u'PCT019G003',
u'PCT019G004',
u'PCT019G005',
u'PCT019G006',
u'PCT019G007',
u'PCT019G008',
u'PCT019G009',
u'PCT019G010',
u'PCT019G011',
u'PCT019H001',
u'PCT019H002',
u'PCT019H003',
u'PCT019H004',
u'PCT019H005',
u'PCT019H006',
u'PCT019H007',
u'PCT019H008',
u'PCT019H009',
u'PCT019H010',
u'PCT019H011',
u'PCT019I001',
u'PCT019I002',
u'PCT019I003',
u'PCT019I004',
u'PCT019I005',
u'PCT019I006',
u'PCT019I007',
u'PCT019I008',
u'PCT019I009',
u'PCT019I010',
u'PCT019I011',
u'PCT0200001',
u'PCT0200002',
u'PCT0200003',
u'PCT0200004',
u'PCT0200005',
u'PCT0200006',
u'PCT0200007',
u'PCT0200008',
u'PCT0200009',
u'PCT0200010',
u'PCT0200011',
u'PCT0200012',
u'PCT0200013',
u'PCT0200014',
u'PCT0200015',
u'PCT0200016',
u'PCT0200017',
u'PCT0200018',
u'PCT0200019',
u'PCT0200020',
u'PCT0200021',
u'PCT0200022',
u'PCT0200023',
u'PCT0200024',
u'PCT0200025',
u'PCT0200026',
u'PCT0200027',
u'PCT0200028',
u'PCT0200029',
u'PCT0200030',
u'PCT0200031',
u'PCT0200032',
u'PCT020A001',
u'PCT020A002',
u'PCT020A003',
u'PCT020A004',
u'PCT020A005',
u'PCT020A006',
u'PCT020A007',
u'PCT020A008',
u'PCT020A009',
u'PCT020A010',
u'PCT020A011',
u'PCT020A012',
u'PCT020A013',
u'PCT020A014',
u'PCT020A015',
u'PCT020A016',
u'PCT020A017',
u'PCT020A018',
u'PCT020A019',
u'PCT020A020',
u'PCT020A021',
u'PCT020A022',
u'PCT020A023',
u'PCT020A024',
u'PCT020A025',
u'PCT020A026',
u'PCT020A027',
u'PCT020A028',
u'PCT020A029',
u'PCT020A030',
u'PCT020A031',
u'PCT020A032',
u'PCT020B001',
u'PCT020B002',
u'PCT020B003',
u'PCT020B004',
u'PCT020B005',
u'PCT020B006',
u'PCT020B007',
u'PCT020B008',
u'PCT020B009',
u'PCT020B010',
u'PCT020B011',
u'PCT020B012',
u'PCT020B013',
u'PCT020B014',
u'PCT020B015',
u'PCT020B016',
u'PCT020B017',
u'PCT020B018',
u'PCT020B019',
u'PCT020B020',
u'PCT020B021',
u'PCT020B022',
u'PCT020B023',
u'PCT020B024',
u'PCT020B025',
u'PCT020B026',
u'PCT020B027',
u'PCT020B028',
u'PCT020B029',
u'PCT020B030',
u'PCT020B031',
u'PCT020B032',
u'PCT020C001',
u'PCT020C002',
u'PCT020C003',
u'PCT020C004',
u'PCT020C005',
u'PCT020C006',
u'PCT020C007',
u'PCT020C008',
u'PCT020C009',
u'PCT020C010',
u'PCT020C011',
u'PCT020C012',
u'PCT020C013',
u'PCT020C014',
u'PCT020C015',
u'PCT020C016',
u'PCT020C017',
u'PCT020C018',
u'PCT020C019',
u'PCT020C020',
u'PCT020C021',
u'PCT020C022',
u'PCT020C023',
u'PCT020C024',
u'PCT020C025',
u'PCT020C026',
u'PCT020C027',
u'PCT020C028',
u'PCT020C029',
u'PCT020C030',
u'PCT020C031',
u'PCT020C032',
u'PCT020D001',
u'PCT020D002',
u'PCT020D003',
u'PCT020D004',
u'PCT020D005',
u'PCT020D006',
u'PCT020D007',
u'PCT020D008',
u'PCT020D009',
u'PCT020D010',
u'PCT020D011',
u'PCT020D012',
u'PCT020D013',
u'PCT020D014',
u'PCT020D015',
u'PCT020D016',
u'PCT020D017',
u'PCT020D018',
u'PCT020D019',
u'PCT020D020',
u'PCT020D021',
u'PCT020D022',
u'PCT020D023',
u'PCT020D024',
u'PCT020D025',
u'PCT020D026',
u'PCT020D027',
u'PCT020D028',
u'PCT020D029',
u'PCT020D030',
u'PCT020D031',
u'PCT020D032',
u'PCT020E001',
u'PCT020E002',
u'PCT020E003',
u'PCT020E004',
u'PCT020E005',
u'PCT020E006',
u'PCT020E007',
u'PCT020E008',
u'PCT020E009',
u'PCT020E010',
u'PCT020E011',
u'PCT020E012',
u'PCT020E013',
u'PCT020E014',
u'PCT020E015',
u'PCT020E016',
u'PCT020E017',
u'PCT020E018',
u'PCT020E019',
u'PCT020E020',
u'PCT020E021',
u'PCT020E022',
u'PCT020E023',
u'PCT020E024',
u'PCT020E025',
u'PCT020E026',
u'PCT020E027',
u'PCT020E028',
u'PCT020E029',
u'PCT020E030',
u'PCT020E031',
u'PCT020E032',
u'PCT020F001',
u'PCT020F002',
u'PCT020F003',
u'PCT020F004',
u'PCT020F005',
u'PCT020F006',
u'PCT020F007',
u'PCT020F008',
u'PCT020F009',
u'PCT020F010',
u'PCT020F011',
u'PCT020F012',
u'PCT020F013',
u'PCT020F014',
u'PCT020F015',
u'PCT020F016',
u'PCT020F017',
u'PCT020F018',
u'PCT020F019',
u'PCT020F020',
u'PCT020F021',
u'PCT020F022',
u'PCT020F023',
u'PCT020F024',
u'PCT020F025',
u'PCT020F026',
u'PCT020F027',
u'PCT020F028',
u'PCT020F029',
u'PCT020F030',
u'PCT020F031',
u'PCT020F032',
u'PCT020G001',
u'PCT020G002',
u'PCT020G003',
u'PCT020G004',
u'PCT020G005',
u'PCT020G006',
u'PCT020G007',
u'PCT020G008',
u'PCT020G009',
u'PCT020G010',
u'PCT020G011',
u'PCT020G012',
u'PCT020G013',
u'PCT020G014',
u'PCT020G015',
u'PCT020G016',
u'PCT020G017',
u'PCT020G018',
u'PCT020G019',
u'PCT020G020',
u'PCT020G021',
u'PCT020G022',
u'PCT020G023',
u'PCT020G024',
u'PCT020G025',
u'PCT020G026',
u'PCT020G027',
u'PCT020G028',
u'PCT020G029',
u'PCT020G030',
u'PCT020G031',
u'PCT020G032',
u'PCT020H001',
u'PCT020H002',
u'PCT020H003',
u'PCT020H004',
u'PCT020H005',
u'PCT020H006',
u'PCT020H007',
u'PCT020H008',
u'PCT020H009',
u'PCT020H010',
u'PCT020H011',
u'PCT020H012',
u'PCT020H013',
u'PCT020H014',
u'PCT020H015',
u'PCT020H016',
u'PCT020H017',
u'PCT020H018',
u'PCT020H019',
u'PCT020H020',
u'PCT020H021',
u'PCT020H022',
u'PCT020H023',
u'PCT020H024',
u'PCT020H025',
u'PCT020H026',
u'PCT020H027',
u'PCT020H028',
u'PCT020H029',
u'PCT020H030',
u'PCT020H031',
u'PCT020H032',
u'PCT020I001',
u'PCT020I002',
u'PCT020I003',
u'PCT020I004',
u'PCT020I005',
u'PCT020I006',
u'PCT020I007',
u'PCT020I008',
u'PCT020I009',
u'PCT020I010',
u'PCT020I011',
u'PCT020I012',
u'PCT020I013',
u'PCT020I014',
u'PCT020I015',
u'PCT020I016',
u'PCT020I017',
u'PCT020I018',
u'PCT020I019',
u'PCT020I020',
u'PCT020I021',
u'PCT020I022',
u'PCT020I023',
u'PCT020I024',
u'PCT020I025',
u'PCT020I026',
u'PCT020I027',
u'PCT020I028',
u'PCT020I029',
u'PCT020I030',
u'PCT020I031',
u'PCT020I032',
u'PCT0210001',
u'PCT0210002',
u'PCT0210003',
u'PCT0210004',
u'PCT0210005',
u'PCT0210006',
u'PCT0210007',
u'PCT0210008',
u'PCT0210009',
u'PCT0210010',
u'PCT0210011',
u'PCT0210012',
u'PCT0210013',
u'PCT0210014',
u'PCT0210015',
u'PCT0210016',
u'PCT0210017',
u'PCT0210018',
u'PCT0210019',
u'PCT0210020',
u'PCT0210021',
u'PCT0210022',
u'PCT0210023',
u'PCT0210024',
u'PCT0210025',
u'PCT0210026',
u'PCT0210027',
u'PCT0210028',
u'PCT0210029',
u'PCT0210030',
u'PCT0210031',
u'PCT0210032',
u'PCT0210033',
u'PCT0210034',
u'PCT0210035',
u'PCT0210036',
u'PCT0210037',
u'PCT0210038',
u'PCT0210039',
u'PCT0210040',
u'PCT0210041',
u'PCT0210042',
u'PCT0210043',
u'PCT0210044',
u'PCT0210045',
u'PCT0210046',
u'PCT0210047',
u'PCT0210048',
u'PCT0210049',
u'PCT0210050',
u'PCT0210051',
u'PCT0210052',
u'PCT0210053',
u'PCT0210054',
u'PCT0210055',
u'PCT0210056',
u'PCT0210057',
u'PCT0210058',
u'PCT0210059',
u'PCT0210060',
u'PCT0210061',
u'PCT0210062',
u'PCT0210063',
u'PCT0210064',
u'PCT0210065',
u'PCT0210066',
u'PCT0210067',
u'PCT0210068',
u'PCT0210069',
u'PCT0210070',
u'PCT0210071',
u'PCT0210072',
u'PCT0210073',
u'PCT0210074',
u'PCT0210075',
u'PCT0210076',
u'PCT0210077',
u'PCT0210078',
u'PCT0210079',
u'PCT0210080',
u'PCT0210081',
u'PCT0210082',
u'PCT0210083',
u'PCT0210084',
u'PCT0210085',
u'PCT0210086',
u'PCT0210087',
u'PCT0210088',
u'PCT0210089',
u'PCT0210090',
u'PCT0210091',
u'PCT0210092',
u'PCT0210093',
u'PCT0210094',
u'PCT0210095',
u'PCT0210096',
u'PCT0210097',
u'PCT0210098',
u'PCT0210099',
u'PCT0210100',
u'PCT0210101',
u'PCT0210102',
u'PCT0210103',
u'PCT0210104',
u'PCT0210105',
u'PCT0210106',
u'PCT0210107',
u'PCT0210108',
u'PCT0210109',
u'PCT0210110',
u'PCT0210111',
u'PCT0210112',
u'PCT0210113',
u'PCT0210114',
u'PCT0210115',
u'PCT0210116',
u'PCT0210117',
u'PCT0210118',
u'PCT0210119',
u'PCT0210120',
u'PCT0210121',
u'PCT0210122',
u'PCT0210123',
u'PCT0210124',
u'PCT0210125',
u'PCT0210126',
u'PCT0210127',
u'PCT0210128',
u'PCT0210129',
u'PCT0210130',
u'PCT0210131',
u'PCT0210132',
u'PCT0210133',
u'PCT0210134',
u'PCT0210135',
u'PCT0210136',
u'PCT0210137',
u'PCT0210138',
u'PCT0210139',
u'PCT0210140',
u'PCT0210141',
u'PCT0210142',
u'PCT0210143',
u'PCT0210144',
u'PCT0210145',
u'PCT0210146',
u'PCT0210147',
u'PCT0210148',
u'PCT0210149',
u'PCT0210150',
u'PCT0210151',
u'PCT0210152',
u'PCT0210153',
u'PCT0210154',
u'PCT0210155',
u'PCT0210156',
u'PCT0210157',
u'PCT0210158',
u'PCT0210159',
u'PCT0210160',
u'PCT0210161',
u'PCT0210162',
u'PCT0210163',
u'PCT0210164',
u'PCT0210165',
u'PCT0210166',
u'PCT0210167',
u'PCT0210168',
u'PCT0210169',
u'PCT0210170',
u'PCT0210171',
u'PCT0210172',
u'PCT0210173',
u'PCT0210174',
u'PCT0210175',
u'PCT0210176',
u'PCT0210177',
u'PCT0210178',
u'PCT0210179',
u'PCT0210180',
u'PCT0210181',
u'PCT0210182',
u'PCT0210183',
u'PCT0210184',
u'PCT0210185',
u'PCT0210186',
u'PCT0210187',
u'PCT0210188',
u'PCT0210189',
u'PCT0210190',
u'PCT0210191',
u'PCT0210192',
u'PCT0210193',
u'PCT0210194',
u'PCT0210195',
u'PCT0220001',
u'PCT0220002',
u'PCT0220003',
u'PCT0220004',
u'PCT0220005',
u'PCT0220006',
u'PCT0220007',
u'PCT0220008',
u'PCT0220009',
u'PCT0220010',
u'PCT0220011',
u'PCT0220012',
u'PCT0220013',
u'PCT0220014',
u'PCT0220015',
u'PCT0220016',
u'PCT0220017',
u'PCT0220018',
u'PCT0220019',
u'PCT0220020',
u'PCT0220021',
u'PCT022A001',
u'PCT022A002',
u'PCT022A003',
u'PCT022A004',
u'PCT022A005',
u'PCT022A006',
u'PCT022A007',
u'PCT022A008',
u'PCT022A009',
u'PCT022A010',
u'PCT022A011',
u'PCT022A012',
u'PCT022A013',
u'PCT022A014',
u'PCT022A015',
u'PCT022A016',
u'PCT022A017',
u'PCT022A018',
u'PCT022A019',
u'PCT022A020',
u'PCT022A021',
u'PCT022B001',
u'PCT022B002',
u'PCT022B003',
u'PCT022B004',
u'PCT022B005',
u'PCT022B006',
u'PCT022B007',
u'PCT022B008',
u'PCT022B009',
u'PCT022B010',
u'PCT022B011',
u'PCT022B012',
u'PCT022B013',
u'PCT022B014',
u'PCT022B015',
u'PCT022B016',
u'PCT022B017',
u'PCT022B018',
u'PCT022B019',
u'PCT022B020',
u'PCT022B021',
u'PCT022C001',
u'PCT022C002',
u'PCT022C003',
u'PCT022C004',
u'PCT022C005',
u'PCT022C006',
u'PCT022C007',
u'PCT022C008',
u'PCT022C009',
u'PCT022C010',
u'PCT022C011',
u'PCT022C012',
u'PCT022C013',
u'PCT022C014',
u'PCT022C015',
u'PCT022C016',
u'PCT022C017',
u'PCT022C018',
u'PCT022C019',
u'PCT022C020',
u'PCT022C021',
u'PCT022D001',
u'PCT022D002',
u'PCT022D003',
u'PCT022D004',
u'PCT022D005',
u'PCT022D006',
u'PCT022D007',
u'PCT022D008',
u'PCT022D009',
u'PCT022D010',
u'PCT022D011',
u'PCT022D012',
u'PCT022D013',
u'PCT022D014',
u'PCT022D015',
u'PCT022D016',
u'PCT022D017',
u'PCT022D018',
u'PCT022D019',
u'PCT022D020',
u'PCT022D021',
u'PCT022E001',
u'PCT022E002',
u'PCT022E003',
u'PCT022E004',
u'PCT022E005',
u'PCT022E006',
u'PCT022E007',
u'PCT022E008',
u'PCT022E009',
u'PCT022E010',
u'PCT022E011',
u'PCT022E012',
u'PCT022E013',
u'PCT022E014',
u'PCT022E015',
u'PCT022E016',
u'PCT022E017',
u'PCT022E018',
u'PCT022E019',
u'PCT022E020',
u'PCT022E021',
u'PCT022F001',
u'PCT022F002',
u'PCT022F003',
u'PCT022F004',
u'PCT022F005',
u'PCT022F006',
u'PCT022F007',
u'PCT022F008',
u'PCT022F009',
u'PCT022F010',
u'PCT022F011',
u'PCT022F012',
u'PCT022F013',
u'PCT022F014',
u'PCT022F015',
u'PCT022F016',
u'PCT022F017',
u'PCT022F018',
u'PCT022F019',
u'PCT022F020',
u'PCT022F021',
u'PCT022G001',
u'PCT022G002',
u'PCT022G003',
u'PCT022G004',
u'PCT022G005',
u'PCT022G006',
u'PCT022G007',
u'PCT022G008',
u'PCT022G009',
u'PCT022G010',
u'PCT022G011',
u'PCT022G012',
u'PCT022G013',
u'PCT022G014',
u'PCT022G015',
u'PCT022G016',
u'PCT022G017',
u'PCT022G018',
u'PCT022G019',
u'PCT022G020',
u'PCT022G021',
u'PCT022H001',
u'PCT022H002',
u'PCT022H003',
u'PCT022H004',
u'PCT022H005',
u'PCT022H006',
u'PCT022H007',
u'PCT022H008',
u'PCT022H009',
u'PCT022H010',
u'PCT022H011',
u'PCT022H012',
u'PCT022H013',
u'PCT022H014',
u'PCT022H015',
u'PCT022H016',
u'PCT022H017',
u'PCT022H018',
u'PCT022H019',
u'PCT022H020',
u'PCT022H021',
u'PCT022I001',
u'PCT022I002',
u'PCT022I003',
u'PCT022I004',
u'PCT022I005',
u'PCT022I006',
u'PCT022I007',
u'PCT022I008',
u'PCT022I009',
u'PCT022I010',
u'PCT022I011',
u'PCT022I012',
u'PCT022I013',
u'PCT022I014',
u'PCT022I015',
u'PCT022I016',
u'PCT022I017',
u'PCT022I018',
u'PCT022I019',
u'PCT022I020',
u'PCT022I021',
u'PLACE',
u'PLACECC',
u'REGION',
u'SDELEM',
u'SDSEC',
u'SDUNI',
u'SLDL',
u'SLDL2',
u'SLDL3',
u'SLDL4',
u'SLDU',
u'SLDU2',
u'SLDU3',
u'SLDU4',
u'STATE',
u'SUBMCD',
u'SUBMDCC',
u'SUMLEV',
u'TRACT',
u'UASC',
u'UATYPE',
u'UGA',
u'UR',
u'VTD',
u'ZCTA5']
In [20]:
var_json['variables']['P0050002']
Out[20]:
{u'concept': u'P5. HISPANIC OR LATINO ORIGIN BY RACE [17]',
u'label': u'Not Hispanic or Latino:'}
In [21]:
from pandas import DataFrame
DataFrame(var_json['variables']).T
Out[21]:
concept
label
AIANHH
Geographic Summary Level
GEO PLACE HOLDER
AIANHHCC
Geographic Characteristics
GEO PLACE HOLDER
AIANHHFP
Geographic Characteristics
GEO PLACE HOLDER
AIHHTLI
Geographic Characteristics
GEO PLACE HOLDER
AITS
Geographic Characteristics
GEO PLACE HOLDER
AITSCC
Geographic Characteristics
GEO PLACE HOLDER
AITSCE
Geographic Characteristics
GEO PLACE HOLDER
ANRC
Geographic Characteristics
GEO PLACE HOLDER
BLKGRP
Geographic Summary Level
GEO PLACE HOLDER
BLOCK
NaN
GEO PLACE HOLDER
CBSA
Geographic Summary Level
GEO PLACE HOLDER
CBSAPCI
Geographic Characteristics
GEO PLACE HOLDER
CD
Geographic Summary Level
GEO PLACE HOLDER
CD113
Geographic Characteristics
GEO PLACE HOLDER
CNECTA
Geographic Characteristics
GEO PLACE HOLDER
CONCIT
Geographic Summary Level
GEO PLACE HOLDER
CONCITSC
Geographic Characteristics
GEO PLACE HOLDER
COUNTY
Geographic Summary Level
County (FIPS))
COUSUB
Geographic Summary Level
GEO PLACE HOLDER
CSA
Geographic Summary Level
GEO PLACE HOLDER
DIVISION
Geographic Summary Level
GEO PLACE HOLDER
GEOCOMP
Geographic Characteristics
GEO PLACE HOLDER
H00010001
H1. Housing Units [1]
Housing units
H0020001
H2. URBAN AND RURAL [6] (Urban/Rural Update only)
Housing units
H0020002
H2. URBAN AND RURAL [6] (Urban/Rural Update only)
Urban:
H0020003
H2. URBAN AND RURAL [6] (Urban/Rural Update only)
Urban: !! Inside urbanized areas
H0020004
H2. URBAN AND RURAL [6] (Urban/Rural Update only)
Urban: !! Inside urban clusters
H0020005
H2. URBAN AND RURAL [6] (Urban/Rural Update only)
Rural !! Inside urban clusters
H0020006
H2. URBAN AND RURAL [6] (Urban/Rural Update only)
Not defined for this file !! Inside urban clus...
H0030001
H3. Occupancy Status [3]
Housing units
H0030002
H3. Occupancy Status [3]
Occupied
H0030003
H3. Occupancy Status [3]
Vacant
H0040001
H4. TENURE [4]
Occupied housing units
H0040002
H4. TENURE [4]
Owned with a mortgage or a loan
H0040003
H4. TENURE [4]
Owned free and clear
H0040004
H4. TENURE [4]
Renter occupied
H0050001
H5. VACANCY STATUS [8]
Vacant housing units
H0050002
H5. VACANCY STATUS [8]
For rent
H0050003
H5. VACANCY STATUS [8]
Rented, not occupied
H0050004
H5. VACANCY STATUS [8]
For sale only
H0050005
H5. VACANCY STATUS [8]
Sold, not occupied
H0050006
H5. VACANCY STATUS [8]
For seasonal, recreational, or occasional use
H0050007
H5. VACANCY STATUS [8]
For migrant workers
H0050008
H5. VACANCY STATUS [8]
Other vacant
H0060001
H6. Race Of Householder [8]
Occupied housing units
H0060002
H6. Race Of Householder [8]
Householder who is White alone
H0060003
H6. Race Of Householder [8]
Householder who is Black or African American a...
H0060004
H6. Race Of Householder [8]
Householder who is American Indian and Alaska ...
H0060005
H6. Race Of Householder [8]
Householder who is Asian alone
H0060006
H6. Race Of Householder [8]
Householder who is Native Hawaiian and Other P...
H0060007
H6. Race Of Householder [8]
Householder who is Some Other Race alone
H0060008
H6. Race Of Householder [8]
Householder who is Two or More Races
H0070001
H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B...
Occupied housing units
H0070002
H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B...
Not Hispanic or Latino householder:
H0070003
H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B...
Not Hispanic or Latino householder: !! Househo...
H0070004
H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B...
Not Hispanic or Latino householder: !! Househo...
H0070005
H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B...
Not Hispanic or Latino householder: !! Househo...
H0070006
H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B...
Not Hispanic or Latino householder: !! Househo...
H0070007
H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B...
Not Hispanic or Latino householder: !! Househo...
H0070008
H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B...
Not Hispanic or Latino householder: !! Househo...
...
...
8966 rows × 2 columns
This example written by AJ Renold.
In [22]:
sf1_fields = c.sf1.fields(year=2010)
# Get the sf1 fields that are only P12 Sex By Age
gender_population_fields = sf1_fields.get('P12. Sex By Age [49]')
# Separate the by male and female
male_fields = { key: val for key, val in gender_population_fields.items()
if 'Male' in val and val != ' Male: ' }
female_fields = { key: val for key, val in gender_population_fields.items()
if 'Female' in val and val != ' Female: '}
In [23]:
# Query the census API with the gender_population_fields
query_results = c.sf1.get(('NAME', ','.join(gender_population_fields.keys())), geo={'for': 'state:*'})
# Create a DataFrame
gender_df = pd.DataFrame(query_results)
In [24]:
# Set the Index to the NAME column
gender_df = gender_df.set_index(gender_df['NAME'])
In [25]:
# Recast all numeric columns to be type int
for col in gender_df.columns:
if col != "state" and col != "NAME":
gender_df[col] = gender_df[col].astype(int)
In [26]:
from numpy import arange
def showPopulationPyramidPlot(df, state, male_fields, female_fields):
# create a series with the row of the state
s = Series(df.ix[state])
#del s['NAME']
#del s['state']
# get the plot values and labels from the series
male_list = sorted([ [key, s[key]] for key in s.keys() if key in male_fields ])
female_list = sorted([ [key, s[key]] for key in s.keys() if key in female_fields ])
# calculate the bar locations and the maximum value
bar_ypos = arange(len(male_list))+.5
max_val = max([ val for label, val in male_list + female_list ])
# create the figures for the plots
fig, (ax2, ax1) = plt.subplots(nrows=1, ncols=2, figsize=(18,8))
fig.suptitle('Population Age Pyramid for {state}'.format(state=state), fontsize=14)
# plot the male populations
bar1 = ax1.barh(bar_ypos, [ val for label, val in male_list ], align='center')
ax1.set_xlim((0,max_val))
ax1.set_yticks(bar_ypos)
ax1.set_yticklabels([ male_fields[label][male_fields[label].find('!!')+3:] for label, val in male_list ])
ax1.set_xlabel('People')
ax1.set_title('Male Population by Age')
ax1.grid(True)
# plot the the female populations
bar2 = ax2.barh(bar_ypos,[ val for label, val in female_list ], align='center', color='red')
ax2.set_yticks([])
#ax2.yaxis.tick_right()
ax2.set_xlim(ax1.get_xlim()[::-1]) # reverses the x axis direction
ax2.set_xlabel('People')
ax2.set_title('Female Population by Age')
ax2.grid(True)
plt.subplots_adjust(wspace=0.22, hspace=0.0)
plt.show()
In [27]:
showPopulationPyramidPlot(gender_df, 'Illinois', male_fields, female_fields)
In [ ]:
Content source: morganwallace/open_data
Similar notebooks: