{ "metadata": { "name": "", "signature": "sha256:698d7456034f207f82da0d59b68e46bd6850ae16de017e05fbe3aa79744d5663" }, "nbformat": 3, "nbformat_minor": 0, "worksheets": [ { "cells": [ { "cell_type": "code", "collapsed": false, "input": [ "%pylab --no-import-all inline" ], "language": "python", "metadata": {}, "outputs": [ { "output_type": "stream", "stream": "stdout", "text": [ "Populating the interactive namespace from numpy and matplotlib\n" ] } ], "prompt_number": 1 }, { "cell_type": "code", "collapsed": false, "input": [ "# import useful classes of pandas\n", "import pandas as pd\n", "from pandas import Series, DataFrame, Index" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 2 }, { "cell_type": "code", "collapsed": false, "input": [ "import settings\n", "import census\n", "\n", "c = census.Census(key=settings.CENSUS_KEY)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 3 }, { "cell_type": "heading", "level": 1, "metadata": {}, "source": [ "Fields in SF1" ] }, { "cell_type": "code", "collapsed": false, "input": [ "sf1_fields = c.sf1.fields(year=2010)" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 4 }, { "cell_type": "code", "collapsed": false, "input": [ "sorted(sf1_fields.keys())" ], "language": "python", "metadata": {}, "outputs": [ { "metadata": {}, "output_type": "pyout", "prompt_number": 5, "text": [ "['Geographic Characteristics',\n", " 'H1. Housing Units [1]',\n", " 'H10. TOTAL POPULATION IN OCCUPIED HOUSING UNITS [1]',\n", " 'H11. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE [4]',\n", " 'H11A. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE HOUSEHOLDER) [4]',\n", " 'H11B. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [4]',\n", " 'H11C. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [4]',\n", " 'H11D. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (ASIAN ALONE HOUSEHOLDER) [4]',\n", " 'H11E. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [4]',\n", " 'H11F. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (SOME OTHER RACE ALONE HOUSEHOLDER) [4]',\n", " 'H11G. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (TWO OR MORE RACES HOUSEHOLDER) [4]',\n", " 'H11H. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (HISPANIC OR LATINO HOUSEHOLDER) [4]',\n", " 'H11I. TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [4]',\n", " 'H12. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE [3] (2 expressed decimals)',\n", " 'H12A. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'H12B. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'H12C. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'H12D. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (ASIAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'H12E. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'H12F. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (SOME OTHER RACE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'H12G. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (TWO OR MORE RACES HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'H12H. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'H12I. AVERAGE HOUSEHOLD SIZE OF OCCUPIED HOUSING UNITS BY TENURE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'H13. Household Size [8]',\n", " 'H14. Tenure By Race Of Householder [17]',\n", " 'H15. TENURE BY HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER [7]',\n", " 'H16. TENURE BY HOUSEHOLD SIZE [17]',\n", " 'H16A. TENURE BY HOUSEHOLD SIZE (WHITE ALONE HOUSEHOLDER) [17]',\n", " 'H16B. TENURE BY HOUSEHOLD SIZE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [17]',\n", " 'H16C. TENURE BY HOUSEHOLD SIZE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [17]',\n", " 'H16D. TENURE BY HOUSEHOLD SIZE (ASIAN ALONE HOUSEHOLDER) [17]',\n", " 'H16E. TENURE BY HOUSEHOLD SIZE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [17]',\n", " 'H16F. TENURE BY HOUSEHOLD SIZE (SOME OTHER RACE ALONE HOUSEHOLDER) [17]',\n", " 'H16G. TENURE BY HOUSEHOLD SIZE (TWO OR MORE RACES HOUSEHOLDER) [17]',\n", " 'H16H. TENURE BY HOUSEHOLD SIZE (HISPANIC OR LATINO HOUSEHOLDER) [17]',\n", " 'H16I. TENURE BY HOUSEHOLD SIZE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [17]',\n", " 'H17. TENURE BY AGE OF HOUSEHOLDER [21]',\n", " 'H17A. TENURE BY AGE OF HOUSEHOLDER (WHITE ALONE HOUSEHOLDER) [21]',\n", " 'H17B. TENURE BY AGE OF HOUSEHOLDER (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [21]',\n", " 'H17C. TENURE BY AGE OF HOUSEHOLDER (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [21]',\n", " 'H17D. TENURE BY AGE OF HOUSEHOLDER (ASIAN ALONE HOUSEHOLDER) [21]',\n", " 'H17E. TENURE BY AGE OF HOUSEHOLDER (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [21]',\n", " 'H17F. TENURE BY AGE OF HOUSEHOLDER (SOME OTHER RACE ALONE HOUSEHOLDER) [21]',\n", " 'H17G. TENURE BY AGE OF HOUSEHOLDER (TWO OR MORE RACES HOUSEHOLDER) [21]',\n", " 'H17H. TENURE BY AGE OF HOUSEHOLDER (HISPANIC OR LATINO HOUSEHOLDER) [21]',\n", " 'H17I. TENURE BY AGE OF HOUSEHOLDER (WHITE ALONE HOUSEHOLDER, NOT HISPANIC OR LATINO) [21]',\n", " 'H18. TENURE BY HOUSEHOLD TYPE BY AGE OF HOUSEHOLDER [69]',\n", " 'H19. TENURE BY PRESENCE OF PEOPLE UNDER 18 YEARS (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS) [7]',\n", " 'H2. URBAN AND RURAL [6] (Urban/Rural Update only)',\n", " 'H20. OCCUPIED HOUSING UNITS SUBSTITUTED [3]',\n", " 'H21. ALLOCATION OF VACANCY STATUS [3]',\n", " 'H22. ALLOCATION OF TENURE [3]',\n", " 'H3. Occupancy Status [3]',\n", " 'H4. TENURE [4]',\n", " 'H5. VACANCY STATUS [8]',\n", " 'H6. Race Of Householder [8]',\n", " 'H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER BY RACE OF HOUSEHOLDER [17]',\n", " 'H8. Total Races Tallied For Householders [7]',\n", " 'H9. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDERS BY TOTAL RACES TALLIED [15]',\n", " 'HCT1. TENURE BY HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER BY RACE OF HOUSEHOLDER [35]',\n", " 'HCT2. TENURE BY PRESENCE AND AGE OF OWN CHILDREN [13]',\n", " 'HCT3. TENURE BY PRESENCE AND AGE OF RELATED CHILDREN [13]',\n", " 'HCT4. TENURE BY PRESENCE AND AGE OF PEOPLE UNDER 18 YEARS BY HOUSEHOLD TYPE (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS) [13]',\n", " 'P1. Total Population [1]',\n", " 'P10. RACE FOR THE POPULATION 18 YEARS AND OVER [71]',\n", " 'P11. HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO BY RACE FOR THE POPULATION 18 YEARS AND OVER [73]',\n", " 'P12. Sex By Age [49]',\n", " 'P12A. Sex By Age (White Alone) [49]',\n", " 'P12B. Sex By Age (Black Or African American Alone) [49]',\n", " 'P12C. Sex By Age (American Indian And Alaska Native Alone) [49]',\n", " 'P12D. Sex By Age (Asian Alone) [49]',\n", " 'P12E. Sex By Age (Native Hawaiian And Other Pacific Islander Alone) [49]',\n", " 'P12F. Sex By Age (Some Other Race Alone) [49]',\n", " 'P12G. Sex By Age (Two Or More Races) [49]',\n", " 'P12H. Sex By Age (Hispanic Or Latino) [49]',\n", " 'P12I. Sex By Age (White Alone, Not Hispanic Or Latino) [49]',\n", " 'P13. MEDIAN AGE BY SEX [3] (1 expressed decimal)',\n", " 'P13A. MEDIAN AGE BY SEX (WHITE ALONE) [3] (1 expressed decimal)',\n", " 'P13B. MEDIAN AGE BY SEX (BLACK OR AFRICAN AMERICAN ALONE) [3] (1 expressed decimal)',\n", " 'P13C. MEDIAN AGE BY SEX (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [3] (1 expressed decimal)',\n", " 'P13D. MEDIAN AGE BY SEX (ASIAN ALONE) [3] (1 expressed decimal)',\n", " 'P13E. MEDIAN AGE BY SEX (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [3] (1 expressed decimal)',\n", " 'P13F. MEDIAN AGE BY SEX (SOME OTHER RACE ALONE) [3] (1 expressed decimal)',\n", " 'P13G. MEDIAN AGE BY SEX (TWO OR MORE RACES) [3] (1 expressed decimal)',\n", " 'P13H. MEDIAN AGE BY SEX (HISPANIC OR LATINO) [3] (1 expressed decimal)',\n", " 'P13I. MEDIAN AGE BY SEX (WHITE ALONE, NOT HISPANIC OR LATINO) [3] (1 expressed decimal)',\n", " 'P14. Sex By Age For The Population Under 20 Years [43]',\n", " 'P15. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER BY RACE OF HOUSEHOLDER [17]',\n", " 'P16. POPULATION IN HOUSEHOLDS BY AGE [3]',\n", " 'P16A. POPULATION IN HOUSEHOLDS BY AGE (WHITE ALONE HOUSEHOLDER) [3]',\n", " 'P16B. POPULATION IN HOUSEHOLDS BY AGE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3]',\n", " 'P16C. POPULATION IN HOUSEHOLDS BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3]',\n", " 'P16D. POPULATION IN HOUSEHOLDS BY AGE (ASIAN ALONE HOUSEHOLDER) [3]',\n", " 'P16E. POPULATION IN HOUSEHOLDS BY AGE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3]',\n", " 'P16F. POPULATION IN HOUSEHOLDS BY AGE (SOME OTHER RACE ALONE HOUSEHOLDER) [3]',\n", " 'P16G. POPULATION IN HOUSEHOLDS BY AGE (TWO OR MORE RACES HOUSEHOLDER) [3]',\n", " 'P16H. POPULATION IN HOUSEHOLDS BY AGE (HISPANIC OR LATINO HOUSEHOLDER) [3]',\n", " 'P16I. POPULATION IN HOUSEHOLDS BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3]',\n", " 'P17. AVERAGE HOUSEHOLD SIZE BY AGE [3] (2 expressed decimals)',\n", " 'P17A. AVERAGE HOUSEHOLD SIZE BY AGE (WHITE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P17B. AVERAGE HOUSEHOLD SIZE BY AGE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P17C. AVERAGE HOUSEHOLD SIZE BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P17D. AVERAGE HOUSEHOLD SIZE BY AGE (ASIAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P17E. AVERAGE HOUSEHOLD SIZE BY AGE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P17F. AVERAGE HOUSEHOLD SIZE BY AGE (SOME OTHER RACE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P17G. AVERAGE HOUSEHOLD SIZE BY AGE (TWO OR MORERACES HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P17H. AVERAGE HOUSEHOLD SIZE BY AGE (HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P17I. AVERAGE HOUSEHOLD SIZE BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P18. HOUSEHOLD TYPE [9]',\n", " 'P18A. HOUSEHOLD TYPE (WHITE ALONE HOUSEHOLDER) [9]',\n", " 'P18B. HOUSEHOLD TYPE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [9]',\n", " 'P18C. HOUSEHOLD TYPE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [9]',\n", " 'P18D. HOUSEHOLD TYPE (ASIAN ALONE HOUSEHOLDER) [9]',\n", " 'P18E. HOUSEHOLD TYPE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [9]',\n", " 'P18F. HOUSEHOLD TYPE (SOME OTHER RACE ALONE HOUSEHOLDER) [9]',\n", " 'P18G. HOUSEHOLD TYPE (TWO OR MORE RACES HOUSEHOLDER) [9]',\n", " 'P18H. HOUSEHOLD TYPE (HISPANIC OR LATINO HOUSEHOLDER) [9]',\n", " 'P18I. HOUSEHOLD TYPE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [9]',\n", " 'P19. HOUSEHOLD SIZE BY HOUSEHOLD TYPE BY PRESENCE OF OWN CHILDREN [19]',\n", " 'P2. Urban And Rural [6]',\n", " 'P20. HOUSEHOLDS BY PRESENCE OF PEOPLE UNDER 18 YEARS BY HOUSEHOLD TYPE BY AGE OF PEOPLE UNDER 18 YEARS [34]',\n", " 'P21. HOUSEHOLDS BY AGE OF HOUSEHOLDER BY HOUSEHOLD TYPE BY PRESENCE OF RELATED CHILDREN [31]',\n", " 'P22. HOUSEHOLD TYPE BY AGE OF HOUSEHOLDER [21]',\n", " 'P23. HOUSEHOLDS BY PRESENCE OF PEOPLE 60 YEARS AND OVER BY HOUSEHOLD TYPE [15]',\n", " 'P24. HOUSEHOLDS BY PRESENCE OF PEOPLE 60 YEARS AND OVER, HOUSEHOLD SIZE, AND HOUSEHOLD TYPE [11]',\n", " 'P25. HOUSEHOLDS BY PRESENCE OF PEOPLE 65 YEARS AND OVER, HOUSEHOLD SIZE, AND HOUSEHOLD TYPE [11]',\n", " 'P26. HOUSEHOLDS BY PRESENCE OF PEOPLE 75 YEARS AND OVER, HOUSEHOLD SIZE, AND HOUSEHOLD TYPE [11]',\n", " 'P27. HOUSEHOLDS BY PRESENCE OF NONRELATIVES [3]',\n", " 'P28. HOUSEHOLD TYPE BY HOUSEHOLD SIZE [16]',\n", " 'P28A. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (WHITE ALONE HOUSEHOLDER) [16]',\n", " 'P28B. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [16]',\n", " 'P28C. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [16]',\n", " 'P28D. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (ASIAN ALONE HOUSEHOLDER) [16]',\n", " 'P28E. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [16]',\n", " 'P28F. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (SOME OTHER RACE ALONE HOUSEHOLDER) [16]',\n", " 'P28G. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (TWO OR MORE RACES HOUSEHOLDER) [16]',\n", " 'P28H. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (HISPANIC OR LATINO HOUSEHOLDER) [16]',\n", " 'P28I. HOUSEHOLD TYPE BY HOUSEHOLD SIZE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [16]',\n", " 'P29. HOUSEHOLD TYPE BY RELATIONSHIP [28]',\n", " 'P29A. HOUSEHOLD TYPE BY RELATIONSHIP (WHITE ALONE) [28]',\n", " 'P29B. HOUSEHOLD TYPE BY RELATIONSHIP (BLACK OR AFRICAN AMERICAN ALONE) [28]',\n", " 'P29C. HOUSEHOLD TYPE BY RELATIONSHIP (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [28]',\n", " 'P29D. HOUSEHOLD TYPE BY RELATIONSHIP (ASIAN ALONE) [28]',\n", " 'P29E. HOUSEHOLD TYPE BY RELATIONSHIP (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [28]',\n", " 'P29F. HOUSEHOLD TYPE BY RELATIONSHIP (SOME OTHER RACE ALONE) [28]',\n", " 'P29G. HOUSEHOLD TYPE BY RELATIONSHIP (TWO OR MORE RACES) [28]',\n", " 'P29H. HOUSEHOLD TYPE BY RELATIONSHIP (HISPANIC OR LATINO) [28]',\n", " 'P29I. HOUSEHOLD TYPE BY RELATIONSHIP (WHITE ALONE, NOT HISPANIC OR LATINO) [28]',\n", " 'P3. RACE [8]',\n", " 'P30. HOUSEHOLD TYPE FOR THE POPULATION IN HOUSEHOLDS [13]',\n", " 'P31. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS [16]',\n", " 'P31A. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (WHITE ALONE) [16]',\n", " 'P31B. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (BLACK OR AFRICAN AMERICAN ALONE) [16]',\n", " 'P31C. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [16]',\n", " 'P31D. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (ASIAN ALONE) [16]',\n", " 'P31E. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [16]',\n", " 'P31F. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (SOME OTHER RACE ALONE) [16]',\n", " 'P31G. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (TWO OR MORE RACES) [16]',\n", " 'P31H. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (HISPANIC OR LATINO) [16]',\n", " 'P31I. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION UNDER 18 YEARS (WHITE ALONE, NOT HISPANIC OR LATINO) [16]',\n", " 'P32. HOUSEHOLD TYPE BY RELATIONSHIP BY AGE FOR THE POPULATION UNDER 18 YEARS [45]',\n", " 'P33. HOUSEHOLD TYPE FOR THE POPULATION UNDER 18 YEARS IN HOUSEHOLDS (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS) [7]',\n", " 'P34. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER [22]',\n", " 'P34A. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (WHITE ALONE) [22]',\n", " 'P34B. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (BLACK OR AFRICAN AMERICAN ALONE) [22]',\n", " 'P34C. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [22]',\n", " 'P34D. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (ASIAN ALONE) [22]',\n", " 'P34E. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [22]',\n", " 'P34F. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (SOME OTHER RACE ALONE) [22]',\n", " 'P34G. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (TWO OR MORE RACES) [22]',\n", " 'P34H. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (HISPANIC OR LATINO) [22]',\n", " 'P34I. HOUSEHOLD TYPE BY RELATIONSHIP FOR THE POPULATION 65 YEARS AND OVER (WHITE ALONE, NOT HISPANIC OR LATINO) [22]',\n", " 'P35. FAMILIES [1]',\n", " 'P35A. FAMILIES (WHITE ALONE HOUSEHOLDER) [1]',\n", " 'P35B. FAMILIES (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [1]',\n", " 'P35C. FAMILIES (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [1]',\n", " 'P35D. FAMILIES (ASIAN ALONE HOUSEHOLDER) [1]',\n", " 'P35E. FAMILIES (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [1]',\n", " 'P35F. FAMILIES (SOME OTHER RACE ALONE HOUSEHOLDER) [1]',\n", " 'P35G. FAMILIES (TWO OR MORE RACES HOUSEHOLDER) [1]',\n", " 'P35H. FAMILIES (HISPANIC OR LATINO HOUSEHOLDER) [1]',\n", " 'P35I. FAMILIES (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [1]',\n", " 'P36. POPULATION IN FAMILIES BY AGE [3]',\n", " 'P36A. POPULATION IN FAMILIES BY AGE (WHITE ALONE HOUSEHOLDER) [3]',\n", " 'P36B. POPULATION IN FAMILIES BY AGE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3]',\n", " 'P36C. POPULATION IN FAMILIES BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3]',\n", " 'P36D. POPULATION IN FAMILIES BY AGE (ASIAN ALONE HOUSEHOLDER) [3]',\n", " 'P36E. POPULATION IN FAMILIES BY AGE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3]',\n", " 'P36F. POPULATION IN FAMILIES BY AGE (SOME OTHER RACE ALONE HOUSEHOLDER) [3]',\n", " 'P36G. POPULATION IN FAMILIES BY AGE (TWO OR MORE RACES HOUSEHOLDER) [3]',\n", " 'P36H. POPULATION IN FAMILIES BY AGE (HISPANIC OR LATINO HOUSEHOLDER) [3]',\n", " 'P36I. POPULATION IN FAMILIES BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3]',\n", " 'P37. AVERAGE FAMILY SIZE BY AGE [3] (2 expressed decimals)',\n", " 'P37A. AVERAGE FAMILY SIZE BY AGE (WHITE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P37B. AVERAGE FAMILY SIZE BY AGE (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3]',\n", " 'P37C. AVERAGE FAMILY SIZE BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P37D. AVERAGE FAMILY SIZE BY AGE (ASIAN ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P37E. AVERAGE FAMILY SIZE BY AGE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P37F. AVERAGE FAMILY SIZE BY AGE (SOME OTHER RACE ALONE HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P37G. AVERAGE FAMILY SIZE BY AGE (TWO OR MORE RACES HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P37H. AVERAGE FAMILY SIZE BY AGE (HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P37I. AVERAGE FAMILY SIZE BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3] (2 expressed decimals)',\n", " 'P38. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN [20]',\n", " 'P38A. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (WHITE ALONE HOUSEHOLDER) [20]',\n", " 'P38B. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [20]',\n", " 'P38C. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [20]',\n", " 'P38D. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (ASIAN ALONE HOUSEHOLDER) [20]',\n", " 'P38E. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [20]',\n", " 'P38F. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (SOME OTHER RACE ALONE HOUSEHOLDER) [20]',\n", " 'P38G. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (TWO OR MORE RACES HOUSEHOLDER) [20]',\n", " 'P38H. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (HISPANIC OR LATINO HOUSEHOLDER) [20]',\n", " 'P38I. FAMILY TYPE BY PRESENCE AND AGE OF OWN CHILDREN (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [20]',\n", " 'P39. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN [20]',\n", " 'P39A. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (WHITE ALONE HOUSEHOLDER) [20]',\n", " 'P39B. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [20]',\n", " 'P39C. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [20]',\n", " 'P39D. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (ASIAN ALONE HOUSEHOLDER) [20]',\n", " 'P39E. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [20]',\n", " 'P39F. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (SOME OTHER RACE ALONE HOUSEHOLDER) [20]',\n", " 'P39G. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (TWO OR MORE RACES HOUSEHOLDER) [20]',\n", " 'P39H. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (HISPANIC OR LATINO HOUSEHOLDER) [20]',\n", " 'P39I. FAMILY TYPE BY PRESENCE AND AGE OF RELATED CHILDREN (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [20]',\n", " 'P4. HISPANIC OR LATINO ORIGIN [3]',\n", " 'P40. FAMILY TYPE AND AGE FOR OWN CHILDREN UNDER 18 YEARS [20]',\n", " 'P41. AGE OF GRANDCHILDREN UNDER 18 YEARS LIVING WITH A GRANDPARENT HOUSEHOLDER [6]',\n", " 'P42. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE [10]',\n", " 'P43. GROUP QUARTERS POPULATION BY SEX BY AGE BY GROUP QUARTERS TYPE [63]',\n", " 'P44. POPULATION SUBSTITUTED [3]',\n", " 'P45. ALLOCATION OF POPULATION ITEMS [3]',\n", " 'P46. ALLOCATION OF RACE [3]',\n", " 'P47. ALLOCATION OF HISPANIC OR LATINO ORIGIN [3]',\n", " 'P48. ALLOCATION OF SEX [3]',\n", " 'P49. ALLOCATION OF AGE [3]',\n", " 'P5. HISPANIC OR LATINO ORIGIN BY RACE [17]',\n", " 'P50. ALLOCATION OF RELATIONSHIP [3]',\n", " 'P51. ALLOCATION OF POPULATION ITEMS FOR THE POPULATION IN GROUP QUARTERS [3]',\n", " 'P6. RACE (TOTAL RACES TALLIED) [7]',\n", " 'P7. HISPANIC OR LATINO ORIGIN BY RACE (TOTAL RACES TALLIED) [15]',\n", " 'P8. RACE [71]',\n", " 'P9. HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO BY RACE [73]',\n", " 'PCO1. GROUP QUARTERS POPULATION BY SEX BY AGE [39]',\n", " 'PCO10. GROUP QUARTERS POPULATION IN OTHER NONINSTITUTIONAL FACILITIES BY SEX BY AGE [39]',\n", " 'PCO2. GROUP QUARTERS POPULATION IN INSTITUTIONAL FACILITIES BY SEX BY AGE [39]',\n", " 'PCO3. GROUP QUARTERS POPULATION IN CORRECTIONAL FACILITIES FOR ADULTS BY SEX BY AGE [39]',\n", " 'PCO4. GROUP QUARTERS POPULATION IN JUVENILE FACILITIES BY SEX BY AGE [39]',\n", " 'PCO5. GROUP QUARTERS POPULATION IN NURSING FACILITIES/SKILLED-NURSING FACILITIES BY SEX BY AGE [39]',\n", " 'PCO6. GROUP QUARTERS POPULATION IN OTHER INSTITUTIONAL FACILITIES BY SEX BY AGE [39]',\n", " 'PCO7. GROUP QUARTERS POPULATION IN NONINSTITUTIONAL FACILITIES BY SEX BY AGE [39]',\n", " 'PCO8. GROUP QUARTERS POPULATION IN COLLEGE/UNIVERSITY STUDENT HOUSING BY SEX BY AGE [39]',\n", " 'PCO9. GROUP QUARTERS POPULATION IN MILITARY QUARTERS BY SEX BY AGE [39]',\n", " 'PCT1. AMERICAN INDIAN AND ALASKA NATIVE ALONE WITH ONE TRIBE REPORTED FOR SELECTED TRIBES [54]',\n", " '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]',\n", " 'PCT11. Hispanic Or Latino By Specific Origin [31]',\n", " 'PCT12. Sex By Age [209]',\n", " 'PCT12A. Sex By Age (White Alone) [209]',\n", " 'PCT12B. Sex By Age (Black Or African American Alone) [209]',\n", " 'PCT12C. Sex By Age (American Indian And Alaska Native Alone) [209]',\n", " 'PCT12D. Sex By Age (Asian Alone) [209]',\n", " 'PCT12E. Sex By Age (Native Hawaiian And Other Pacific Islander Alone) [209]',\n", " 'PCT12F. Sex By Age (Some Other Race Alone) [209]',\n", " 'PCT12G. Sex By Age (Two Or More Races) [209]',\n", " 'PCT12H. Sex By Age (Hispanic Or Latino) [209]',\n", " 'PCT12I. SEX BY AGE (WHITE ALONE, NOT HISPANIC OR LATINO) [209]',\n", " 'PCT12J. Sex By Age (Black Or African American Alone, Not Hispanic Or Latino) [209]',\n", " 'PCT12K. SEX BY AGE (AMERICAN INDIAN AND ALASKA NATIVE ALONE, NOT HISPANIC OR LATINO) [209]',\n", " 'PCT12L. Sex By Age (Asian Alone, Not Hispanic Or Latino) [209]',\n", " 'PCT12M. Sex By Age (Native Hawaiian And Other Pacific Islander Alone, Not Hispanic Or Latino) [209]',\n", " 'PCT12N. Sex By Age (Some Other Race Alone, Not Hispanic Or Latino) [209]',\n", " 'PCT12O. Sex By Age (Two Or More Races, Not Hispanic Or Latino) [209]',\n", " 'PCT13. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS [49]',\n", " 'PCT13A. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (WHITE ALONE) [49]',\n", " 'PCT13B. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (BLACK OR AFRICAN AMERICAN ALONE) [49]',\n", " 'PCT13C. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [49]',\n", " 'PCT13D. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (ASIAN ALONE) [49]',\n", " 'PCT13E. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [49]',\n", " 'PCT13F. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (SOME OTHER RACE ALONE) [49]',\n", " 'PCT13G. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (TWO OR MORE RACES) [49]',\n", " 'PCT13H. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (HISPANIC OR LATINO) [49]',\n", " 'PCT13I. SEX BY AGE FOR THE POPULATION IN HOUSEHOLDS (WHITE ALONE, NOT HISPANIC OR LATINO) [49]',\n", " 'PCT14. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS [3]',\n", " 'PCT14A. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (WHITE ALONE HOUSEHOLDER) [3]',\n", " 'PCT14B. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (BLACK OR AFRICAN AMERICAN ALONE HOUSEHOLDER) [3]',\n", " 'PCT14C. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (AMERICAN INDIAN AND ALASKA NATIVE ALONE HOUSEHOLDER) [3]',\n", " 'PCT14D. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (ASIAN ALONE HOUSEHOLDER) [3]',\n", " 'PCT14E. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE HOUSEHOLDER) [3]',\n", " 'PCT14F. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (SOME OTHER RACE ALONE HOUSEHOLDER) [3]',\n", " 'PCT14G. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (TWO OR MORE RACES HOUSEHOLDER) [3]',\n", " 'PCT14H. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (HISPANIC OR LATINO HOUSEHOLDER) [3]',\n", " 'PCT14I. PRESENCE OF MULTIGENERATIONAL HOUSEHOLDS (WHITE ALONE, NOT HISPANIC OR LATINO HOUSEHOLDER) [3]',\n", " 'PCT15. HUSBAND-WIFE AND UNMARRIED-PARTNER HOUSEHOLDS BY SEX OF PARTNER BY PRESENCE OF RELATED AND OWN CHILDREN UNDER 18 YEARS [34]',\n", " 'PCT16. HOUSEHOLD TYPE BY NUMBER OF PEOPLE UNDER 18 YEARS (EXCLUDING HOUSEHOLDERS, SPOUSES, AND UNMARRIED PARTNERS) [26]',\n", " '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]',\n", " 'PCT18. NONFAMILY HOUSEHOLDS BY SEX OF HOUSEHOLDER BY LIVING ALONE BY AGE OF HOUSEHOLDER [15]',\n", " 'PCT19. NONRELATIVES BY HOUSEHOLD TYPE [11]',\n", " 'PCT19A. NONRELATIVES BY HOUSEHOLD TYPE (WHITE ALONE) [11]',\n", " 'PCT19B. NONRELATIVES BY HOUSEHOLD TYPE (BLACK OR AFRICAN AMERICAN ALONE) [11]',\n", " 'PCT19C. NONRELATIVES BY HOUSEHOLD TYPE (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [11]',\n", " 'PCT19D. NONRELATIVES BY HOUSEHOLD TYPE (ASIAN ALONE) [11]',\n", " 'PCT19E. NONRELATIVES BY HOUSEHOLD TYPE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [11]',\n", " 'PCT19F. NONRELATIVES BY HOUSEHOLD TYPE (SOME OTHER RACE ALONE) [11]',\n", " 'PCT19G. NONRELATIVES BY HOUSEHOLD TYPE (TWO OR MORE RACES) [11]',\n", " 'PCT19H. NONRELATIVES BY HOUSEHOLD TYPE (HISPANIC OR LATINO) [11]',\n", " 'PCT19I. NONRELATIVES BY HOUSEHOLD TYPE (WHITE ALONE, NOT HISPANIC OR LATINO) [11]',\n", " 'PCT2. AMERICAN INDIAN AND ALASKA NATIVE ALONE WITH ONE OR MORE TRIBES REPORTED FOR SELECTED TRIBES [54]',\n", " 'PCT20. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE [32]',\n", " 'PCT20A. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (WHITE ALONE) [32]',\n", " 'PCT20B. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (BLACK OR AFRICAN AMERICAN ALONE) [32]',\n", " 'PCT20C. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [32]',\n", " 'PCT20D. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (ASIAN ALONE) [32]',\n", " 'PCT20E. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (NATIVE HAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [32]',\n", " 'PCT20F. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (SOME OTHER RACE ALONE) [32]',\n", " 'PCT20G. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (TWO OR MORE RACES) [32]',\n", " 'PCT20H. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (HISPANIC OR LATINO) [32]',\n", " 'PCT20I. GROUP QUARTERS POPULATION BY GROUP QUARTERS TYPE (WHITE ALONE, NOT HISPANIC OR LATINO) [32]',\n", " 'PCT21. GROUP QUARTERS POPULATION BY SEX BY AGE BY GROUP QUARTERS TYPE [195]',\n", " 'PCT22. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER [21]',\n", " 'PCT22A. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (WHITE ALONE)',\n", " 'PCT22B. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (BLACK OR AFRICAN AMERICAN ALONE) [21]',\n", " 'PCT22C. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (AMERICAN INDIAN AND ALASKA NATIVE ALONE) [21]',\n", " 'PCT22D. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (ASIAN ALONE)',\n", " 'PCT22E. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (NATIVEHAWAIIAN AND OTHER PACIFIC ISLANDER ALONE) [21]',\n", " 'PCT22F. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (SOME OTHER RACE ALONE) [21]',\n", " 'PCT22G. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (TWO OR MORE RACES) [21]',\n", " 'PCT22H. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (HISPANIC OR LATINO) [21]',\n", " 'PCT22I. GROUP QUARTERS POPULATION BY SEX BY GROUP QUARTERS TYPE FOR THE POPULATION 18 YEARS AND OVER (WHITE ALONE, NOT HISPANIC OR LATINO) [21]',\n", " '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]',\n", " 'PCT4. American Indian And Alaska Native Alone Or In Combination With One Or More Other Races [9]',\n", " 'PCT5. ASIAN ALONE WITH ONE ASIAN CATEGORY FOR SELECTED GROUPS [22]',\n", " 'PCT6. ASIAN ALONE WITH ONE OR MORE ASIAN CATEGORIES FOR SELECTED GROUPS [22]',\n", " 'PCT7. ASIAN ALONE OR IN COMBINATION WITH ONE OR MORE OTHER RACES, AND WITH ONE OR MORE ASIAN CATEGORIES FOR SELECTED GROUPS [22]',\n", " 'PCT8. Native Hawaiian And Other Pacific Islander Alone With One Native Hawaiian And Other Pacific Islander Category For Selected Groups [14]',\n", " 'PCT9. Native Hawaiian And Other Pacific Islander Alone With One Or More Native Hawaiian And Other Pacific Islander Categories For Selected Groups [14]']" ] } ], "prompt_number": 5 }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's parse more of pieces that are in the fields" ] }, { "cell_type": "code", "collapsed": false, "input": [ "# let's just parse sf1.xml ourselves to get the concepts\n", "# http://lxml.de/parsing.html\n", "\n", "from lxml import etree\n", "from itertools import islice\n", "import re\n", "\n", "def parse_concept_name(concept_name):\n", " if concept_name != 'Geographic Characteristics':\n", " m = re.search(\"(.+\\.)\\s+(.*)\\s+(\\[\\d+\\])\",concept_name)\n", " if m: \n", " return {'label':m.group(1),\n", " 'clean_name':m.group(2),\n", " 'num_vars':re.search(\"\\[(\\d+)\\]\", m.group(3)).group(1)\n", " }\n", " # print m.groups()\n", " else:\n", " m1 = re.search(\"(.+\\.)\\s+(.*)\\s+\",concept_name)\n", " return {'label':m1.group(1),\n", " 'clean_name':m1.group(2),\n", " 'num_vars':0\n", " }\n", " else:\n", " return None\n", " \n", "def concepts_2010_sf1():\n", " # http://www.census.gov/developers/data/sf1.xml\n", " SF1_XML_PATH = \"/Users/raymondyee/D/Document/Working_with_Open_Data/working-open-data-2014/data/sf1.xml\"\n", "\n", " doc = etree.parse(SF1_XML_PATH)\n", " for concept in doc.findall(\"//concept\"):\n", " concept_name = concept.attrib['name']\n", " \n", " if concept_name != 'Geographic Characteristics':\n", " m = re.search(\"(.+\\.)\\s+(.*)\\s+(\\[\\d+\\])\",concept_name)\n", " if m: \n", " yield {'label':m.group(1),\n", " 'clean_name':m.group(2),\n", " 'num_vars':re.search(\"\\[(\\d+)\\]\", m.group(3)).group(1)\n", " }\n", " # print m.groups()\n", " else:\n", " m1 = re.search(\"(.+\\.)\\s+(.*)\\s+\",concept_name)\n", " yield {'label':m1.group(1),\n", " 'clean_name':m1.group(2),\n", " 'num_vars':0\n", " }\n", " \n", "k = list(concepts_2010_sf1()) \n" ], "language": "python", "metadata": {}, "outputs": [], "prompt_number": 6 }, { "cell_type": "code", "collapsed": false, "input": [ "df = DataFrame(k, columns=('label','clean_name','num_vars'))\n", "df.head()" ], "language": "python", "metadata": {}, "outputs": [ { "html": [ "
\n", " | label | \n", "clean_name | \n", "num_vars | \n", "
---|---|---|---|
0 | \n", "H1. | \n", "Housing Units | \n", "1 | \n", "
1 | \n", "H10. | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS | \n", "1 | \n", "
2 | \n", "H11. | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "4 | \n", "
3 | \n", "H11A. | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "4 | \n", "
4 | \n", "H11B. | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "4 | \n", "
5 rows \u00d7 3 columns
\n", "\n", " | label | \n", "clean_name | \n", "num_vars | \n", "sort_label | \n", "
---|---|---|---|---|
232 | \n", "P5. | \n", "HISPANIC OR LATINO ORIGIN BY RACE | \n", "17 | \n", "P 005 | \n", "
233 | \n", "P50. | \n", "ALLOCATION OF RELATIONSHIP | \n", "3 | \n", "P 050 | \n", "
234 | \n", "P51. | \n", "ALLOCATION OF POPULATION ITEMS FOR THE POPULAT... | \n", "3 | \n", "P 051 | \n", "
3 rows \u00d7 4 columns
\n", "\n", " | AIANHHCC | \n", "AIANHHFP | \n", "AIHHTLI | \n", "AITS | \n", "AITSCC | \n", "AITSCE | \n", "ANRC | \n", "CBSAPCI | \n", "CD113 | \n", "CNECTA | \n", "CONCITSC | \n", "GEOCOMP | \n", "LOGRECNO | \n", "MEMI | \n", "METDIV | \n", "NAME | \n", "NECTADIV | \n", "NECTAPCI | \n", "PLACECC | \n", "SLDL2 | \n", "\n", " |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
concept | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "Geographic Characteristics | \n", "... | \n", "
text | \n", "FIPS American Indian Area/Alaska Native Area/... | \n", "American Indian Area/Alaska Native Area/Hawai... | \n", "American Indian Trust Land/Hawaiian Home Land... | \n", "American Indian Tribal Subdivision (FIPS) | \n", "FIPS American Indian Tribal Subdivision Class... | \n", "American Indian Tribal Subdivision (Census) | \n", "Alaska Native Regional Corporation (FIPS) | \n", "Metropolitan Statistical Area/Micropolitan St... | \n", "Congressional District - 113th Congress | \n", "New England City and Town Area | \n", "Consolidated City Size Code | \n", "Geographic Component | \n", "Logical Record Number (State Based Geography ... | \n", "Metropolitan/Micropolitan Indicator Flag | \n", "Metropolitan Division | \n", "Geographic Area Name | \n", "New England City and Town Area Division | \n", "New England City and Town Area Principal City... | \n", "FIPS Place Class Code | \n", "State Legislative District Lower | \n", "... | \n", "
2 rows \u00d7 8945 columns
\n", "\n", " | concept | \n", "label | \n", "
---|---|---|
AIANHH | \n", "Geographic Summary Level | \n", "GEO PLACE HOLDER | \n", "
AIANHHCC | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
AIANHHFP | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
AIHHTLI | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
AITS | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
AITSCC | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
AITSCE | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
ANRC | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
BLKGRP | \n", "Geographic Summary Level | \n", "GEO PLACE HOLDER | \n", "
BLOCK | \n", "NaN | \n", "GEO PLACE HOLDER | \n", "
CBSA | \n", "Geographic Summary Level | \n", "GEO PLACE HOLDER | \n", "
CBSAPCI | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
CD | \n", "Geographic Summary Level | \n", "GEO PLACE HOLDER | \n", "
CD113 | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
CNECTA | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
CONCIT | \n", "Geographic Summary Level | \n", "GEO PLACE HOLDER | \n", "
CONCITSC | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
COUNTY | \n", "Geographic Summary Level | \n", "County (FIPS)) | \n", "
COUSUB | \n", "Geographic Summary Level | \n", "GEO PLACE HOLDER | \n", "
CSA | \n", "Geographic Summary Level | \n", "GEO PLACE HOLDER | \n", "
DIVISION | \n", "Geographic Summary Level | \n", "GEO PLACE HOLDER | \n", "
GEOCOMP | \n", "Geographic Characteristics | \n", "GEO PLACE HOLDER | \n", "
H00010001 | \n", "H1. Housing Units [1] | \n", "Housing units | \n", "
H0020001 | \n", "H2. URBAN AND RURAL [6] (Urban/Rural Update only) | \n", "Housing units | \n", "
H0020002 | \n", "H2. URBAN AND RURAL [6] (Urban/Rural Update only) | \n", "Urban: | \n", "
H0020003 | \n", "H2. URBAN AND RURAL [6] (Urban/Rural Update only) | \n", "Urban: !! Inside urbanized areas | \n", "
H0020004 | \n", "H2. URBAN AND RURAL [6] (Urban/Rural Update only) | \n", "Urban: !! Inside urban clusters | \n", "
H0020005 | \n", "H2. URBAN AND RURAL [6] (Urban/Rural Update only) | \n", "Rural !! Inside urban clusters | \n", "
H0020006 | \n", "H2. URBAN AND RURAL [6] (Urban/Rural Update only) | \n", "Not defined for this file !! Inside urban clus... | \n", "
H0030001 | \n", "H3. Occupancy Status [3] | \n", "Housing units | \n", "
H0030002 | \n", "H3. Occupancy Status [3] | \n", "Occupied | \n", "
H0030003 | \n", "H3. Occupancy Status [3] | \n", "Vacant | \n", "
H0040001 | \n", "H4. TENURE [4] | \n", "Occupied housing units | \n", "
H0040002 | \n", "H4. TENURE [4] | \n", "Owned with a mortgage or a loan | \n", "
H0040003 | \n", "H4. TENURE [4] | \n", "Owned free and clear | \n", "
H0040004 | \n", "H4. TENURE [4] | \n", "Renter occupied | \n", "
H0050001 | \n", "H5. VACANCY STATUS [8] | \n", "Vacant housing units | \n", "
H0050002 | \n", "H5. VACANCY STATUS [8] | \n", "For rent | \n", "
H0050003 | \n", "H5. VACANCY STATUS [8] | \n", "Rented, not occupied | \n", "
H0050004 | \n", "H5. VACANCY STATUS [8] | \n", "For sale only | \n", "
H0050005 | \n", "H5. VACANCY STATUS [8] | \n", "Sold, not occupied | \n", "
H0050006 | \n", "H5. VACANCY STATUS [8] | \n", "For seasonal, recreational, or occasional use | \n", "
H0050007 | \n", "H5. VACANCY STATUS [8] | \n", "For migrant workers | \n", "
H0050008 | \n", "H5. VACANCY STATUS [8] | \n", "Other vacant | \n", "
H0060001 | \n", "H6. Race Of Householder [8] | \n", "Occupied housing units | \n", "
H0060002 | \n", "H6. Race Of Householder [8] | \n", "Householder who is White alone | \n", "
H0060003 | \n", "H6. Race Of Householder [8] | \n", "Householder who is Black or African American a... | \n", "
H0060004 | \n", "H6. Race Of Householder [8] | \n", "Householder who is American Indian and Alaska ... | \n", "
H0060005 | \n", "H6. Race Of Householder [8] | \n", "Householder who is Asian alone | \n", "
H0060006 | \n", "H6. Race Of Householder [8] | \n", "Householder who is Native Hawaiian and Other P... | \n", "
H0060007 | \n", "H6. Race Of Householder [8] | \n", "Householder who is Some Other Race alone | \n", "
H0060008 | \n", "H6. Race Of Householder [8] | \n", "Householder who is Two or More Races | \n", "
H0070001 | \n", "H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B... | \n", "Occupied housing units | \n", "
H0070002 | \n", "H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B... | \n", "Not Hispanic or Latino householder: | \n", "
H0070003 | \n", "H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B... | \n", "Not Hispanic or Latino householder: !! Househo... | \n", "
H0070004 | \n", "H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B... | \n", "Not Hispanic or Latino householder: !! Househo... | \n", "
H0070005 | \n", "H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B... | \n", "Not Hispanic or Latino householder: !! Househo... | \n", "
H0070006 | \n", "H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B... | \n", "Not Hispanic or Latino householder: !! Househo... | \n", "
H0070007 | \n", "H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B... | \n", "Not Hispanic or Latino householder: !! Househo... | \n", "
H0070008 | \n", "H7. HISPANIC OR LATINO ORIGIN OF HOUSEHOLDER B... | \n", "Not Hispanic or Latino householder: !! Househo... | \n", "
\n", " | ... | \n", "... | \n", "
8966 rows \u00d7 2 columns
\n", "