{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Grabbing data with cenpy" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Cenpy (`sen - pie`) is a package that exposes APIs from the US Census Bureau and makes it easy to pull down and work with Census data in Pandas. First, notice that there are two core modules in the package, `base` and `explorer`, which each do different things. First, let's look at `explorer`. " ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false, "scrolled": true }, "outputs": [], "source": [ "import cenpy as c\n", "import pandas" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "On import, `explorer` requests all currently available APIs from the Census Bureau's [API listing](http://www.census.gov/data/developers/data-sets.html). In future, it will can also read a `JSON` collection describing the databases from disk, if asked.\n", "\n", "Explorer has two functions, `available` and `explain`. `available` will provide a list of the identifiers of all the APIs that `cenpy` knows about. If run with `verbose=True`, `cenpy` will also include the title of the database as a dictionary. It's a good idea to *not* process this directly, and instead use it to explore currently available APIs.\n", "\n", "Also, beware that the US Census Bureau can change the names of the resources. This means that the index of the following table is not necessarily stable over time; sometimes, the same resource can change its identifier, like when the 2010 decennial census changed from `2010sf1` to `DECENNIALSF12010`. So, consult the table built by `cenpy.explorer.available()` if the keys appear to have changed. \n", "\n", "Here, I'll just show the first five entries:" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false, "scrolled": false }, "outputs": [ { "data": { "text/html": [ "
\n", " | title | \n", "temporal | \n", "spatial | \n", "publisher | \n", "programCode | \n", "modified | \n", "keyword | \n", "distribution | \n", "description | \n", "contactPoint | \n", "... | \n", "c_isTimeseries | \n", "c_isCube | \n", "c_isAvailable | \n", "c_isAggregate | \n", "c_groupsLink | \n", "c_geographyLink | \n", "c_examplesLink | \n", "c_dataset | \n", "bureauCode | \n", "accessLevel | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
NONEMP2007 | \n", "2007 Nonemployer Statistics: Non Employer Stat... | \n", "2007/2007 | \n", "United States | \n", "U.S. Census Bureau | \n", "006:007 | \n", "2017-02-09 | \n", "NaN | \n", "{'@type': 'dcat:Distribution', 'accessURL': 'h... | \n", "Nonemployer Statistics is an annual series tha... | \n", "{'fn': 'Nonemployer Statistics staff', 'hasEma... | \n", "... | \n", "NaN | \n", "True | \n", "True | \n", "True | \n", "https://api.census.gov/data/2007/nonemp/groups... | \n", "https://api.census.gov/data/2007/nonemp/geogra... | \n", "https://api.census.gov/data/2007/nonemp/exampl... | \n", "(nonemp,) | \n", "006:07 | \n", "public | \n", "
POPESTagesex | \n", "Vintage 2014 Population Estimates: National An... | \n", "April 1, 2010 - Current | \n", "United States | \n", "U.S. Census Bureau | \n", "006:008 | \n", "2015-11-17 | \n", "NaN | \n", "{'@type': 'dcat:Distribution', 'accessURL': 'h... | \n", "Annual Estimates of the Resident Population by... | \n", "{'fn': 'Population Estimates Branch', 'hasEmai... | \n", "... | \n", "NaN | \n", "True | \n", "True | \n", "True | \n", "https://api.census.gov/data/2014/pep/agesex/gr... | \n", "https://api.census.gov/data/2014/pep/agesex/ge... | \n", "https://api.census.gov/data/2014/pep/agesex/ex... | \n", "(pep, agesex) | \n", "006:07 | \n", "public | \n", "
ZBPTotal2011 | \n", "2011 County Business Patterns - Zip Code Busin... | \n", "2011/2011 | \n", "United States | \n", "U.S. Census Bureau | \n", "006:007 | \n", "2017-05-23 | \n", "NaN | \n", "{'@type': 'dcat:Distribution', 'accessURL': 'h... | \n", "ZIP Code Business Patterns (ZBP) is an annual ... | \n", "{'fn': 'CBP Staff', 'hasEmail': 'ewd.county.bu... | \n", "... | \n", "NaN | \n", "NaN | \n", "True | \n", "True | \n", "https://api.census.gov/data/2011/zbp/groups.json | \n", "https://api.census.gov/data/2011/zbp/geography... | \n", "https://api.census.gov/data/2011/zbp/examples.... | \n", "(zbp,) | \n", "006:07 | \n", "public | \n", "
ITMONTHLYIMPORTSUSDA | \n", "Time Series International Trade: Monthly U.S. ... | \n", "Time Series | \n", "United States | \n", "U.S. Census Bureau | \n", "006:004 | \n", "2017-10-27 | \n", "NaN | \n", "{'@type': 'dcat:Distribution', 'accessURL': 'h... | \n", "The Census data API provides access to the mos... | \n", "{'fn': 'Jeff McHugh', 'hasEmail': 'Jeffrey.P.M... | \n", "... | \n", "True | \n", "True | \n", "True | \n", "NaN | \n", "https://api.census.gov/data/timeseries/intltra... | \n", "https://api.census.gov/data/timeseries/intltra... | \n", "https://api.census.gov/data/timeseries/intltra... | \n", "(timeseries, intltrade, imports, usda) | \n", "006:07 | \n", "public | \n", "
POPESTnatmonthly2015 | \n", "Vintage 2015 Population Estimates: National Mo... | \n", "April 1,2010 | \n", "United States | \n", "U.S. Census Bureau | \n", "006:008 | \n", "2016-12-21 | \n", "NaN | \n", "{'@type': 'dcat:Distribution', 'accessURL': 'h... | \n", "Monthly Population Estimates by Universe, Age,... | \n", "{'fn': 'Population Estimates Branch', 'hasEmai... | \n", "... | \n", "NaN | \n", "True | \n", "True | \n", "True | \n", "https://api.census.gov/data/2015/pep/natmonthl... | \n", "https://api.census.gov/data/2015/pep/natmonthl... | \n", "https://api.census.gov/data/2015/pep/natmonthl... | \n", "(pep, natmonthly) | \n", "006:07 | \n", "public | \n", "
5 rows × 24 columns
\n", "\n", " | attributes | \n", "concept | \n", "group | \n", "label | \n", "limit | \n", "predicateOnly | \n", "predicateType | \n", "required | \n", "values | \n", "
---|---|---|---|---|---|---|---|---|---|
for | \n", "NaN | \n", "Census API Geography Specification | \n", "N/A | \n", "Census API FIPS 'for' clause | \n", "0 | \n", "True | \n", "fips-for | \n", "NaN | \n", "NaN | \n", "
in | \n", "NaN | \n", "Census API Geography Specification | \n", "N/A | \n", "Census API FIPS 'in' clause | \n", "0 | \n", "True | \n", "fips-in | \n", "NaN | \n", "NaN | \n", "
ucgid | \n", "NaN | \n", "Census API Geography Specification | \n", "N/A | \n", "Uniform Census Geography Identifier clause | \n", "0 | \n", "True | \n", "ucgid | \n", "NaN | \n", "NaN | \n", "
PCT022021 | \n", "NaN | \n", "GROUP QUARTERS POPULATION BY SEX BY GROUP QUA... | \n", "PCT22 | \n", "Total!!Female!!Noninstitutionalized population... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
P028E001 | \n", "NaN | \n", "HOUSEHOLD TYPE BY HOUSEHOLD SIZE (NATIVE HAWAI... | \n", "P28E | \n", "Total | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
\n", " | attributes | \n", "concept | \n", "group | \n", "label | \n", "limit | \n", "predicateOnly | \n", "predicateType | \n", "required | \n", "values | \n", "
---|---|---|---|---|---|---|---|---|---|
H011A002 | \n", "NaN | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "H11A | \n", "Population in occupied housing units!!Owned wi... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
H011A001 | \n", "NaN | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "H11A | \n", "Population in occupied housing units | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
H011A004 | \n", "NaN | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "H11A | \n", "Population in occupied housing units!!Renter o... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
H011A003 | \n", "NaN | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "H11A | \n", "Population in occupied housing units!!Owned fr... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
H011B001 | \n", "NaN | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "H11B | \n", "Population in occupied housing units | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
H011B002 | \n", "NaN | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "H11B | \n", "Population in occupied housing units!!Owned wi... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
H011B003 | \n", "NaN | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "H11B | \n", "Population in occupied housing units!!Owned fr... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
H011B004 | \n", "NaN | \n", "TOTAL POPULATION IN OCCUPIED HOUSING UNITS BY ... | \n", "H11B | \n", "Population in occupied housing units!!Renter o... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
\n", " | geoLevelDisplay | \n", "name | \n", "optionalWithWCFor | \n", "referenceDate | \n", "requires | \n", "wildcard | \n", "
---|---|---|---|---|---|---|
0 | \n", "010 | \n", "us | \n", "NaN | \n", "2010-01-01 | \n", "NaN | \n", "NaN | \n", "
1 | \n", "020 | \n", "region | \n", "NaN | \n", "2010-01-01 | \n", "NaN | \n", "NaN | \n", "
2 | \n", "030 | \n", "division | \n", "NaN | \n", "2010-01-01 | \n", "NaN | \n", "NaN | \n", "
3 | \n", "040 | \n", "state | \n", "NaN | \n", "2010-01-01 | \n", "NaN | \n", "NaN | \n", "
4 | \n", "050 | \n", "county | \n", "state | \n", "2010-01-01 | \n", "[state] | \n", "[state] | \n", "
\n", " | H001001 | \n", "H002001 | \n", "H002006 | \n", "H002002 | \n", "H002003 | \n", "H002004 | \n", "H002005 | \n", "NAME | \n", "state | \n", "place | \n", "
---|---|---|---|---|---|---|---|---|---|---|
64 | \n", "94404 | \n", "94404 | \n", "0 | \n", "94394 | \n", "94394 | \n", "0 | \n", "10 | \n", "Chandler city, Arizona | \n", "04 | \n", "12000 | \n", "
110 | \n", "201173 | \n", "201173 | \n", "0 | \n", "200979 | \n", "200979 | \n", "0 | \n", "194 | \n", "Mesa city, Arizona | \n", "04 | \n", "46000 | \n", "
201 | \n", "90505 | \n", "90505 | \n", "0 | \n", "90493 | \n", "90493 | \n", "0 | \n", "12 | \n", "Glendale city, Arizona | \n", "04 | \n", "27820 | \n", "
267 | \n", "124001 | \n", "124001 | \n", "0 | \n", "120049 | \n", "120049 | \n", "0 | \n", "3952 | \n", "Scottsdale city, Arizona | \n", "04 | \n", "65000 | \n", "
305 | \n", "52586 | \n", "52586 | \n", "0 | \n", "51082 | \n", "51082 | \n", "0 | \n", "1504 | \n", "Surprise city, Arizona | \n", "04 | \n", "71510 | \n", "
314 | \n", "73462 | \n", "73462 | \n", "0 | \n", "73462 | \n", "73462 | \n", "0 | \n", "0 | \n", "Tempe city, Arizona | \n", "04 | \n", "73000 | \n", "
333 | \n", "229762 | \n", "229762 | \n", "0 | \n", "228577 | \n", "228506 | \n", "71 | \n", "1185 | \n", "Tucson city, Arizona | \n", "04 | \n", "77000 | \n", "
413 | \n", "74907 | \n", "74907 | \n", "0 | \n", "74880 | \n", "74880 | \n", "0 | \n", "27 | \n", "Gilbert town, Arizona | \n", "04 | \n", "27400 | \n", "
433 | \n", "64818 | \n", "64818 | \n", "0 | \n", "64133 | \n", "60939 | \n", "3194 | \n", "685 | \n", "Peoria city, Arizona | \n", "04 | \n", "54050 | \n", "
435 | \n", "590149 | \n", "590149 | \n", "0 | \n", "587936 | \n", "587936 | \n", "0 | \n", "2213 | \n", "Phoenix city, Arizona | \n", "04 | \n", "55000 | \n", "
\n", " | 0 | \n", "1 | \n", "2 | \n", "3 | \n", "4 | \n", "5 | \n", "6 | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "AZ | \n", "4 | \n", "730 | \n", "Aguila CDP | \n", "Census Designated Place | \n", "S | \n", "Maricopa County | \n", "
1 | \n", "AZ | \n", "4 | \n", "870 | \n", "Ajo CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
2 | \n", "AZ | \n", "4 | \n", "940 | \n", "Ak Chin CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
3 | \n", "AZ | \n", "4 | \n", "1090 | \n", "Ak-Chin Village CDP | \n", "Census Designated Place | \n", "S | \n", "Pinal County | \n", "
4 | \n", "AZ | \n", "4 | \n", "1170 | \n", "Alamo Lake CDP | \n", "Census Designated Place | \n", "S | \n", "La Paz County | \n", "
5 | \n", "AZ | \n", "4 | \n", "1560 | \n", "Ali Chuk CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
6 | \n", "AZ | \n", "4 | \n", "1570 | \n", "Ali Chukson CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
7 | \n", "AZ | \n", "4 | \n", "1620 | \n", "Ali Molina CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
8 | \n", "AZ | \n", "4 | \n", "1920 | \n", "Alpine CDP | \n", "Census Designated Place | \n", "S | \n", "Apache County | \n", "
9 | \n", "AZ | \n", "4 | \n", "1990 | \n", "Amado CDP | \n", "Census Designated Place | \n", "S | \n", "Santa Cruz County | \n", "
10 | \n", "AZ | \n", "4 | \n", "2270 | \n", "Anegam CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
11 | \n", "AZ | \n", "4 | \n", "2410 | \n", "Antares CDP | \n", "Census Designated Place | \n", "S | \n", "Mohave County | \n", "
12 | \n", "AZ | \n", "4 | \n", "2430 | \n", "Anthem CDP | \n", "Census Designated Place | \n", "S | \n", "Maricopa County | \n", "
13 | \n", "AZ | \n", "4 | \n", "2830 | \n", "Apache Junction city | \n", "Incorporated Place | \n", "A | \n", "Maricopa County, Pinal County | \n", "
14 | \n", "AZ | \n", "4 | \n", "3320 | \n", "Arivaca CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
15 | \n", "AZ | \n", "4 | \n", "3380 | \n", "Arivaca Junction CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
16 | \n", "AZ | \n", "4 | \n", "3530 | \n", "Arizona City CDP | \n", "Census Designated Place | \n", "S | \n", "Pinal County | \n", "
17 | \n", "AZ | \n", "4 | \n", "3915 | \n", "Arizona Village CDP | \n", "Census Designated Place | \n", "S | \n", "Mohave County | \n", "
18 | \n", "AZ | \n", "4 | \n", "4020 | \n", "Arlington CDP | \n", "Census Designated Place | \n", "S | \n", "Maricopa County | \n", "
19 | \n", "AZ | \n", "4 | \n", "4440 | \n", "Ash Fork CDP | \n", "Census Designated Place | \n", "S | \n", "Yavapai County | \n", "
20 | \n", "AZ | \n", "4 | \n", "4710 | \n", "Avenue B and C CDP | \n", "Census Designated Place | \n", "S | \n", "Yuma County | \n", "
21 | \n", "AZ | \n", "4 | \n", "4720 | \n", "Avondale city | \n", "Incorporated Place | \n", "A | \n", "Maricopa County | \n", "
22 | \n", "AZ | \n", "4 | \n", "4880 | \n", "Avra Valley CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
23 | \n", "AZ | \n", "4 | \n", "4930 | \n", "Aztec CDP | \n", "Census Designated Place | \n", "S | \n", "Yuma County | \n", "
24 | \n", "AZ | \n", "4 | \n", "5140 | \n", "Bagdad CDP | \n", "Census Designated Place | \n", "S | \n", "Yavapai County | \n", "
25 | \n", "AZ | \n", "4 | \n", "5450 | \n", "Bear Flat CDP | \n", "Census Designated Place | \n", "S | \n", "Gila County | \n", "
26 | \n", "AZ | \n", "4 | \n", "5490 | \n", "Beaver Dam CDP | \n", "Census Designated Place | \n", "S | \n", "Mohave County | \n", "
27 | \n", "AZ | \n", "4 | \n", "5495 | \n", "Beaver Valley CDP | \n", "Census Designated Place | \n", "S | \n", "Gila County | \n", "
28 | \n", "AZ | \n", "4 | \n", "5770 | \n", "Benson city | \n", "Incorporated Place | \n", "A | \n", "Cochise County | \n", "
29 | \n", "AZ | \n", "4 | \n", "5970 | \n", "Beyerville CDP | \n", "Census Designated Place | \n", "S | \n", "Santa Cruz County | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
421 | \n", "AZ | \n", "4 | \n", "82120 | \n", "Wheatfields CDP | \n", "Census Designated Place | \n", "S | \n", "Gila County | \n", "
422 | \n", "AZ | \n", "4 | \n", "82155 | \n", "Whetstone CDP | \n", "Census Designated Place | \n", "S | \n", "Cochise County | \n", "
423 | \n", "AZ | \n", "4 | \n", "82270 | \n", "Whispering Pines CDP | \n", "Census Designated Place | \n", "S | \n", "Gila County | \n", "
424 | \n", "AZ | \n", "4 | \n", "82390 | \n", "Whitecone CDP | \n", "Census Designated Place | \n", "S | \n", "Navajo County | \n", "
425 | \n", "AZ | \n", "4 | \n", "82425 | \n", "White Hills CDP | \n", "Census Designated Place | \n", "S | \n", "Mohave County | \n", "
426 | \n", "AZ | \n", "4 | \n", "82450 | \n", "White Mountain Lake CDP | \n", "Census Designated Place | \n", "S | \n", "Navajo County | \n", "
427 | \n", "AZ | \n", "4 | \n", "82530 | \n", "Whiteriver CDP | \n", "Census Designated Place | \n", "S | \n", "Navajo County | \n", "
428 | \n", "AZ | \n", "4 | \n", "82660 | \n", "Why CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
429 | \n", "AZ | \n", "4 | \n", "82740 | \n", "Wickenburg town | \n", "Incorporated Place | \n", "A | \n", "Maricopa County, Yavapai County | \n", "
430 | \n", "AZ | \n", "4 | \n", "82810 | \n", "Wide Ruins CDP | \n", "Census Designated Place | \n", "S | \n", "Apache County | \n", "
431 | \n", "AZ | \n", "4 | \n", "82880 | \n", "Wikieup CDP | \n", "Census Designated Place | \n", "S | \n", "Mohave County | \n", "
432 | \n", "AZ | \n", "4 | \n", "82950 | \n", "Wilhoit CDP | \n", "Census Designated Place | \n", "S | \n", "Yavapai County | \n", "
433 | \n", "AZ | \n", "4 | \n", "83090 | \n", "Willcox city | \n", "Incorporated Place | \n", "A | \n", "Cochise County | \n", "
434 | \n", "AZ | \n", "4 | \n", "83160 | \n", "Williams city | \n", "Incorporated Place | \n", "A | \n", "Coconino County | \n", "
435 | \n", "AZ | \n", "4 | \n", "83388 | \n", "Williamson CDP | \n", "Census Designated Place | \n", "S | \n", "Yavapai County | \n", "
436 | \n", "AZ | \n", "4 | \n", "83475 | \n", "Willow Canyon CDP | \n", "Census Designated Place | \n", "S | \n", "Pima County | \n", "
437 | \n", "AZ | \n", "4 | \n", "83570 | \n", "Willow Valley CDP | \n", "Census Designated Place | \n", "S | \n", "Mohave County | \n", "
438 | \n", "AZ | \n", "4 | \n", "83720 | \n", "Window Rock CDP | \n", "Census Designated Place | \n", "S | \n", "Apache County | \n", "
439 | \n", "AZ | \n", "4 | \n", "83790 | \n", "Winkelman town | \n", "Incorporated Place | \n", "A | \n", "Gila County, Pinal County | \n", "
440 | \n", "AZ | \n", "4 | \n", "83930 | \n", "Winslow city | \n", "Incorporated Place | \n", "A | \n", "Navajo County | \n", "
441 | \n", "AZ | \n", "4 | \n", "83960 | \n", "Winslow West CDP | \n", "Census Designated Place | \n", "S | \n", "Coconino County, Navajo County | \n", "
442 | \n", "AZ | \n", "4 | \n", "84000 | \n", "Wintersburg CDP | \n", "Census Designated Place | \n", "S | \n", "Maricopa County | \n", "
443 | \n", "AZ | \n", "4 | \n", "84140 | \n", "Wittmann CDP | \n", "Census Designated Place | \n", "S | \n", "Maricopa County | \n", "
444 | \n", "AZ | \n", "4 | \n", "84350 | \n", "Woodruff CDP | \n", "Census Designated Place | \n", "S | \n", "Navajo County | \n", "
445 | \n", "AZ | \n", "4 | \n", "84980 | \n", "Yarnell CDP | \n", "Census Designated Place | \n", "S | \n", "Yavapai County | \n", "
446 | \n", "AZ | \n", "4 | \n", "85260 | \n", "York CDP | \n", "Census Designated Place | \n", "S | \n", "Greenlee County | \n", "
447 | \n", "AZ | \n", "4 | \n", "85330 | \n", "Young CDP | \n", "Census Designated Place | \n", "S | \n", "Gila County | \n", "
448 | \n", "AZ | \n", "4 | \n", "85400 | \n", "Youngtown town | \n", "Incorporated Place | \n", "A | \n", "Maricopa County | \n", "
449 | \n", "AZ | \n", "4 | \n", "85470 | \n", "Yucca CDP | \n", "Census Designated Place | \n", "S | \n", "Mohave County | \n", "
450 | \n", "AZ | \n", "4 | \n", "85540 | \n", "Yuma city | \n", "Incorporated Place | \n", "A | \n", "Yuma County | \n", "
451 rows × 7 columns
\n", "\n", " | alias | \n", "domain | \n", "length | \n", "name | \n", "type | \n", "
---|---|---|---|---|---|
0 | \n", "OBJECTID | \n", "None | \n", "NaN | \n", "OBJECTID | \n", "esriFieldTypeOID | \n", "
1 | \n", "AREALAND | \n", "None | \n", "NaN | \n", "AREALAND | \n", "esriFieldTypeDouble | \n", "
2 | \n", "AREAWATER | \n", "None | \n", "NaN | \n", "AREAWATER | \n", "esriFieldTypeDouble | \n", "
3 | \n", "PLACENS | \n", "None | \n", "8.0 | \n", "PLACENS | \n", "esriFieldTypeString | \n", "
4 | \n", "PLACECC | \n", "None | \n", "2.0 | \n", "PLACECC | \n", "esriFieldTypeString | \n", "
5 | \n", "PLACE | \n", "None | \n", "5.0 | \n", "PLACE | \n", "esriFieldTypeString | \n", "
6 | \n", "FUNCSTAT | \n", "None | \n", "1.0 | \n", "FUNCSTAT | \n", "esriFieldTypeString | \n", "
7 | \n", "GEOID | \n", "None | \n", "7.0 | \n", "GEOID | \n", "esriFieldTypeString | \n", "
8 | \n", "LSADC | \n", "None | \n", "2.0 | \n", "LSADC | \n", "esriFieldTypeString | \n", "
9 | \n", "MTFCC | \n", "None | \n", "5.0 | \n", "MTFCC | \n", "esriFieldTypeString | \n", "
10 | \n", "BASENAME | \n", "None | \n", "100.0 | \n", "BASENAME | \n", "esriFieldTypeString | \n", "
11 | \n", "NAME | \n", "None | \n", "100.0 | \n", "NAME | \n", "esriFieldTypeString | \n", "
12 | \n", "OID | \n", "None | \n", "NaN | \n", "OID | \n", "esriFieldTypeDouble | \n", "
13 | \n", "CBSAPCI | \n", "None | \n", "1.0 | \n", "CBSAPCI | \n", "esriFieldTypeString | \n", "
14 | \n", "NECTAPCI | \n", "None | \n", "1.0 | \n", "NECTAPCI | \n", "esriFieldTypeString | \n", "
15 | \n", "STATE | \n", "None | \n", "2.0 | \n", "STATE | \n", "esriFieldTypeString | \n", "
16 | \n", "UR | \n", "None | \n", "1.0 | \n", "UR | \n", "esriFieldTypeString | \n", "
17 | \n", "CENTLON | \n", "None | \n", "12.0 | \n", "CENTLON | \n", "esriFieldTypeString | \n", "
18 | \n", "CENTLAT | \n", "None | \n", "11.0 | \n", "CENTLAT | \n", "esriFieldTypeString | \n", "
19 | \n", "INTPTLON | \n", "None | \n", "12.0 | \n", "INTPTLON | \n", "esriFieldTypeString | \n", "
20 | \n", "INTPTLAT | \n", "None | \n", "11.0 | \n", "INTPTLAT | \n", "esriFieldTypeString | \n", "
21 | \n", "HU100 | \n", "None | \n", "NaN | \n", "HU100 | \n", "esriFieldTypeDouble | \n", "
22 | \n", "POP100 | \n", "None | \n", "NaN | \n", "POP100 | \n", "esriFieldTypeDouble | \n", "
23 | \n", "STGEOMETRY | \n", "None | \n", "NaN | \n", "STGEOMETRY | \n", "esriFieldTypeGeometry | \n", "
24 | \n", "STGEOMETRY.AREA | \n", "None | \n", "NaN | \n", "STGEOMETRY.AREA | \n", "esriFieldTypeDouble | \n", "
25 | \n", "STGEOMETRY.LEN | \n", "None | \n", "NaN | \n", "STGEOMETRY.LEN | \n", "esriFieldTypeDouble | \n", "
\n", " | AREALAND | \n", "AREAWATER | \n", "BASENAME | \n", "CBSAPCI | \n", "CENTLAT | \n", "CENTLON | \n", "FUNCSTAT | \n", "GEOID | \n", "HU100 | \n", "INTPTLAT | \n", "... | \n", "OID | \n", "PLACE | \n", "PLACECC | \n", "PLACENS | \n", "POP100 | \n", "STATE | \n", "STGEOMETRY.AREA | \n", "STGEOMETRY.LEN | \n", "UR | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "19032775 | \n", "3749 | \n", "Copper Hill | \n", "N | \n", "+33.4379206 | \n", "-110.7516247 | \n", "S | \n", "0415600 | \n", "63 | \n", "+33.4309411 | \n", "... | \n", "280403717476730 | \n", "15600 | \n", "U1 | \n", "02582762 | \n", "108 | \n", "04 | \n", "2.740956e+07 | \n", "29887.334159 | \n", "R | \n", "POLYGON ((-12332768.2339 3951052.317500003, -1... | \n", "
1 | \n", "370140896 | \n", "37430 | \n", "Vicksburg | \n", "N | \n", "+33.7292771 | \n", "-113.8254052 | \n", "S | \n", "0479940 | \n", "687 | \n", "+33.7271570 | \n", "... | \n", "280403717388941 | \n", "79940 | \n", "U1 | \n", "02582892 | \n", "597 | \n", "04 | \n", "5.365771e+08 | \n", "139508.893591 | \n", "R | \n", "POLYGON ((-12681838.7724 3986891.478200004, -1... | \n", "
2 | \n", "14935603 | \n", "21306 | \n", "Sawmill | \n", "N | \n", "+35.8924354 | \n", "-109.1538097 | \n", "S | \n", "0464590 | \n", "243 | \n", "+35.8940886 | \n", "... | \n", "280401190808799 | \n", "64590 | \n", "U1 | \n", "02409289 | \n", "748 | \n", "04 | \n", "2.283813e+07 | \n", "26370.978055 | \n", "R | \n", "POLYGON ((-12154943.6963 4285660.0066, -121549... | \n", "
3 | \n", "8693601 | \n", "0 | \n", "Goodyear Village | \n", "N | \n", "+33.1973247 | \n", "-111.8723879 | \n", "S | \n", "0428465 | \n", "121 | \n", "+33.1973247 | \n", "... | \n", "280403861091191 | \n", "28465 | \n", "U2 | \n", "02612139 | \n", "457 | \n", "04 | \n", "1.244920e+07 | \n", "18140.700058 | \n", "M | \n", "POLYGON ((-12456882.7869 3922518.464100003, -1... | \n", "
4 | \n", "23385412 | \n", "55226 | \n", "Carrizo | \n", "N | \n", "+33.9866282 | \n", "-110.3314358 | \n", "S | \n", "0410320 | \n", "40 | \n", "+33.9793542 | \n", "... | \n", "280403717231648 | \n", "10320 | \n", "U1 | \n", "02582748 | \n", "127 | \n", "04 | \n", "3.418072e+07 | \n", "37640.185623 | \n", "R | \n", "POLYGON ((-12289756.4977 4027500.7016, -122896... | \n", "
5 rows × 26 columns
\n", "\n", " | H001001 | \n", "H002001 | \n", "H002006 | \n", "H002002 | \n", "H002003 | \n", "H002004 | \n", "H002005 | \n", "NAME_x | \n", "state | \n", "place | \n", "... | \n", "OID | \n", "PLACE | \n", "PLACECC | \n", "PLACENS | \n", "POP100 | \n", "STATE | \n", "STGEOMETRY.AREA | \n", "STGEOMETRY.LEN | \n", "UR | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "621 | \n", "621 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "621 | \n", "Queen Valley CDP, Arizona | \n", "04 | \n", "58290 | \n", "... | \n", "280401260231706 | \n", "58290 | \n", "U1 | \n", "02409115 | \n", "788 | \n", "04 | \n", "3.615206e+07 | \n", "29036.707030 | \n", "R | \n", "POLYGON ((-12394427.7659 3930594.1774, -123943... | \n", "
1 | \n", "226 | \n", "226 | \n", "0 | \n", "148 | \n", "0 | \n", "148 | \n", "78 | \n", "Rainbow City CDP, Arizona | \n", "04 | \n", "58620 | \n", "... | \n", "280403717231691 | \n", "58620 | \n", "U2 | \n", "02582847 | \n", "968 | \n", "04 | \n", "8.203581e+06 | \n", "15645.985013 | \n", "M | \n", "POLYGON ((-12244069.0863 4010211.943099998, -1... | \n", "
2 | \n", "162 | \n", "162 | \n", "0 | \n", "162 | \n", "0 | \n", "162 | \n", "0 | \n", "Rancho Mesa Verde CDP, Arizona | \n", "04 | \n", "58870 | \n", "... | \n", "280403717389008 | \n", "58870 | \n", "U2 | \n", "02582848 | \n", "625 | \n", "04 | \n", "4.109284e+05 | \n", "2901.827817 | \n", "M | \n", "POLYGON ((-12763708.1353 3841881.7513, -127634... | \n", "
3 | \n", "202 | \n", "202 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "202 | \n", "Red Mesa CDP, Arizona | \n", "04 | \n", "59550 | \n", "... | \n", "280401190808794 | \n", "59550 | \n", "U1 | \n", "02409150 | \n", "480 | \n", "04 | \n", "5.222080e+07 | \n", "43104.992136 | \n", "R | \n", "POLYGON ((-12184877.6187 4433486.655900002, -1... | \n", "
4 | \n", "64 | \n", "64 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "64 | \n", "Red Rock CDP (Apache County), Arizona | \n", "04 | \n", "59760 | \n", "... | \n", "280403717231660 | \n", "59760 | \n", "U1 | \n", "02582849 | \n", "169 | \n", "04 | \n", "4.694147e+06 | \n", "13576.105484 | \n", "R | \n", "POLYGON ((-12142700.7787 4383404.183799997, -1... | \n", "
5 rows × 36 columns
\n", "\n", " | attributes | \n", "concept | \n", "group | \n", "label | \n", "limit | \n", "predicateOnly | \n", "predicateType | \n", "required | \n", "values | \n", "
---|---|---|---|---|---|---|---|---|---|
for | \n", "NaN | \n", "Census API Geography Specification | \n", "N/A | \n", "Census API FIPS 'for' clause | \n", "0 | \n", "True | \n", "fips-for | \n", "NaN | \n", "NaN | \n", "
in | \n", "NaN | \n", "Census API Geography Specification | \n", "N/A | \n", "Census API FIPS 'in' clause | \n", "0 | \n", "True | \n", "fips-in | \n", "NaN | \n", "NaN | \n", "
ucgid | \n", "NaN | \n", "Census API Geography Specification | \n", "N/A | \n", "Uniform Census Geography Identifier clause | \n", "0 | \n", "True | \n", "ucgid | \n", "NaN | \n", "NaN | \n", "
PAYANN | \n", "PAYANN_F | \n", "NaN | \n", "N/A | \n", "Annual payroll ($1,000) | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
GEOTYPE | \n", "NaN | \n", "NaN | \n", "N/A | \n", "Type of geography flag | \n", "0 | \n", "NaN | \n", "string | \n", "NaN | \n", "NaN | \n", "
PAYQTR1 | \n", "PAYQTR1_F | \n", "NaN | \n", "N/A | \n", "First-quarter payroll ($1,000) | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
YEAR | \n", "YEAR_TTL | \n", "NaN | \n", "N/A | \n", "Year | \n", "0 | \n", "NaN | \n", "string | \n", "NaN | \n", "{'item': {'1982': '1982', '1983': '1983', '198... | \n", "
COUNTY | \n", "NaN | \n", "NaN | \n", "N/A | \n", "FIPS county code | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
ST | \n", "NaN | \n", "NaN | \n", "N/A | \n", "FIPS state code | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
EMPSZES | \n", "EMPSZES_TTL | \n", "NaN | \n", "N/A | \n", "Employment size of establishment | \n", "14 | \n", "NaN | \n", "string | \n", "default displayed | \n", "{'item': {'001': 'All establishments', '204': ... | \n", "
CSA | \n", "NaN | \n", "NaN | \n", "N/A | \n", "FIPS Combined Statistical Area code | \n", "0 | \n", "NaN | \n", "string | \n", "NaN | \n", "NaN | \n", "
MD | \n", "NaN | \n", "NaN | \n", "N/A | \n", "FIPS Metropolitan Division code | \n", "0 | \n", "NaN | \n", "string | \n", "NaN | \n", "NaN | \n", "
GEO_ID | \n", "GEO_TTL,FOOTID_GEO | \n", "NaN | \n", "N/A | \n", "Geographic identifier code | \n", "0 | \n", "NaN | \n", "string | \n", "NaN | \n", "NaN | \n", "
EMP | \n", "EMP_F | \n", "NaN | \n", "N/A | \n", "Paid employees for pay period including March ... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
ESTAB | \n", "ESTAB_F | \n", "NaN | \n", "N/A | \n", "Number of establishments | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
MSA | \n", "NaN | \n", "NaN | \n", "N/A | \n", "FIPS Metropolitan Statistical Area or Micropol... | \n", "0 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
NAICS2012 | \n", "NAICS2012_TTL,FOOTID_NAICS | \n", "NaN | \n", "N/A | \n", "2012 NAICS code | \n", "2016 | \n", "NaN | \n", "string | \n", "default displayed | \n", "{'item': {'111331': 'Apple orchards', '111332'... | \n", "
LFO | \n", "LFO_TTL | \n", "NaN | \n", "N/A | \n", "Legal form of organization code | \n", "8 | \n", "NaN | \n", "string | \n", "default displayed | \n", "{'item': {'001': 'All establishments', '002': ... | \n", "
PAYQTR1_N | \n", "PAYQTR1_N_F | \n", "NaN | \n", "N/A | \n", "Noise range for first-quarter payroll (%) | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
PAYANN_N | \n", "PAYANN_N_F | \n", "NaN | \n", "N/A | \n", "Noise range for annual payroll | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
EMP_N | \n", "EMP_N_F | \n", "NaN | \n", "N/A | \n", "Noise range for number of paid employees for p... | \n", "0 | \n", "NaN | \n", "int | \n", "NaN | \n", "NaN | \n", "
\n", " | attributes | \n", "concept | \n", "group | \n", "label | \n", "limit | \n", "predicateOnly | \n", "predicateType | \n", "required | \n", "values | \n", "
---|---|---|---|---|---|---|---|---|---|
EMPSZES | \n", "EMPSZES_TTL | \n", "NaN | \n", "N/A | \n", "Employment size of establishment | \n", "14 | \n", "NaN | \n", "string | \n", "default displayed | \n", "{'item': {'001': 'All establishments', '204': ... | \n", "
NAICS2012 | \n", "NAICS2012_TTL,FOOTID_NAICS | \n", "NaN | \n", "N/A | \n", "2012 NAICS code | \n", "2016 | \n", "NaN | \n", "string | \n", "default displayed | \n", "{'item': {'111331': 'Apple orchards', '111332'... | \n", "
LFO | \n", "LFO_TTL | \n", "NaN | \n", "N/A | \n", "Legal form of organization code | \n", "8 | \n", "NaN | \n", "string | \n", "default displayed | \n", "{'item': {'001': 'All establishments', '002': ... | \n", "
\n", " | geoLevelDisplay | \n", "limit | \n", "name | \n", "optionalWithWCFor | \n", "referenceDate | \n", "requires | \n", "wildcard | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "01 | \n", "1 | \n", "us | \n", "NaN | \n", "2012-01-01 | \n", "NaN | \n", "NaN | \n", "
1 | \n", "02 | \n", "51 | \n", "state | \n", "NaN | \n", "2012-01-01 | \n", "NaN | \n", "NaN | \n", "
2 | \n", "03 | \n", "3304 | \n", "county | \n", "state | \n", "2012-01-01 | \n", "[state] | \n", "[state] | \n", "
3 | \n", "08,09 | \n", "917 | \n", "metropolitan statistical area/micropolitan sta... | \n", "NaN | \n", "2012-01-01 | \n", "NaN | \n", "NaN | \n", "
\n", " | ESTAB | \n", "state | \n", "county | \n", "
---|---|---|---|
0 | \n", "635 | \n", "06 | \n", "999 | \n", "
1 | \n", "36700 | \n", "06 | \n", "001 | \n", "
2 | \n", "43 | \n", "06 | \n", "003 | \n", "
3 | \n", "801 | \n", "06 | \n", "005 | \n", "
4 | \n", "4615 | \n", "06 | \n", "007 | \n", "
\n", " | ESTAB | \n", "state | \n", "county | \n", "AREALAND | \n", "AREAWATER | \n", "BASENAME | \n", "CENTLAT | \n", "CENTLON | \n", "COUNTY | \n", "COUNTYCC | \n", "... | \n", "INTPTLON | \n", "LSADC | \n", "MTFCC | \n", "NAME | \n", "OBJECTID | \n", "OID | \n", "STATE | \n", "STGEOMETRY.AREA | \n", "STGEOMETRY.LEN | \n", "geometry | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "36700 | \n", "06 | \n", "001 | \n", "1909598011 | \n", "216923745 | \n", "Alameda | \n", "+37.6505688 | \n", "-121.9177578 | \n", "001 | \n", "H1 | \n", "... | \n", "-121.9124880 | \n", "06 | \n", "G4020 | \n", "Alameda County | \n", "2098 | \n", "27590141293924 | \n", "06 | \n", "3.398122e+09 | \n", "309844.151899 | \n", "POLYGON ((-13612245.2954 4538149.388899997, -1... | \n", "
1 | \n", "43 | \n", "06 | \n", "003 | \n", "1912292631 | \n", "12557304 | \n", "Alpine | \n", "+38.5971043 | \n", "-119.8206026 | \n", "003 | \n", "H1 | \n", "... | \n", "-119.7983522 | \n", "06 | \n", "G4020 | \n", "Alpine County | \n", "1317 | \n", "27590289634197 | \n", "06 | \n", "3.156005e+09 | \n", "275565.367754 | \n", "POLYGON ((-13366502.0648 4678945.273900002, -1... | \n", "
2 | \n", "801 | \n", "06 | \n", "005 | \n", "1539933575 | \n", "29470567 | \n", "Amador | \n", "+38.4466174 | \n", "-120.6516693 | \n", "005 | \n", "H1 | \n", "... | \n", "-120.6538563 | \n", "06 | \n", "G4020 | \n", "Amador County | \n", "2724 | \n", "27590143912562 | \n", "06 | \n", "2.562527e+09 | \n", "359598.495341 | \n", "POLYGON ((-13472696.4062 4647651.505999997, -1... | \n", "
3 | \n", "4615 | \n", "06 | \n", "007 | \n", "4238438258 | \n", "105310959 | \n", "Butte | \n", "+39.6665788 | \n", "-121.6007017 | \n", "007 | \n", "H1 | \n", "... | \n", "-121.6019188 | \n", "06 | \n", "G4020 | \n", "Butte County | \n", "2237 | \n", "27590417130535 | \n", "06 | \n", "7.340033e+09 | \n", "525974.965501 | \n", "POLYGON ((-13565003.3072 4798393.384000003, -1... | \n", "
4 | \n", "891 | \n", "06 | \n", "009 | \n", "2641829200 | \n", "43797659 | \n", "Calaveras | \n", "+38.2044678 | \n", "-120.5546688 | \n", "009 | \n", "H1 | \n", "... | \n", "-120.5614415 | \n", "06 | \n", "G4020 | \n", "Calaveras County | \n", "347 | \n", "27590202403841 | \n", "06 | \n", "4.356212e+09 | \n", "367005.819167 | \n", "POLYGON ((-13428574.0355 4627724.500200003, -1... | \n", "
5 rows × 24 columns
\n", "