API Developers Forum

Browse Ideas with tag 'sf1':

• Recent Ideas (2)
• Popular Ideas (2)
• Hot Ideas (0)
• In Review Ideas (0)
• In Progress Ideas (0)
• Complete Ideas (0)

• Vote up

  Feedback Score

  2

  +2

  -0

  Vote down
  This idea is active.
  API Technical Discussions »

  ACS2010 sf1 table mapping

  I am trying to make sense of the table name convention for the ACS data. Unlike the 2010 Census SF1 document (http://www.census.gov/prod/cen2010/doc/sf1.pdf), the tables listed in the 2010 ACS SF1 document (http://www2.census.gov/acs2010_5yr/summaryfile/ACS_2006-2010_SF_Tech_Doc.pdf) don't seem to correlate to the api. For example, an attempt to query: B07010: Geographical Mobility In The Past Year By Individual ...more »

  I am trying to make sense of the table name convention for the ACS data.

  Unlike the 2010 Census SF1 document (http://www.census.gov/prod/cen2010/doc/sf1.pdf), the tables listed in the 2010 ACS SF1 document (http://www2.census.gov/acs2010_5yr/summaryfile/ACS_2006-2010_SF_Tech_Doc.pdf) don't seem to correlate to the api.

  For example, an attempt to query:

  B07010: Geographical Mobility In The Past Year By Individual Income In The Past 12 Months For Current Residence In The United States

  Results in the error: 'Invalid API key or request'

  In looking at api examples for the ACS endpoints, you use table names like B00001_001E, which are not listed with in the ACS sf1 documentation. As an example, B02001_00E is listed as Total Population, but according to the ACS SF1 document the table number for Total Population is B01003.

  Is there logic or a mapping of the ACS SF1 table names to the required API SF1 table names?

  Any help would be greatly appreciated.

  ------------------------------------------------------------------

  EDIT:

  Updating for the sake of posterity. A listing of the api field names can be found here:

  Census SF1:

  http://www.census.gov/developers/data/sf1.xml

  ACS SF1:

  http://www.census.gov/developers/data/acs_5yr_2010_var.xml

  It appears that with the ACS datapoints, the table name is converted to field names to take into account Estimates and Margins of Error.

  Reference the XML instead of the SF1 PDFs when accessing the API.

  « less full details »

  1 comment for Idea: ACS2010 sf1 table mapping

  Submitted by tyrauber 4 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  API Technical Discussions »

  Formatting of SF1 Table IDs?

  I'm trying to look at tables from the SF1 and I've noticed they don't seem to follow a consistent format. The ACS ID consistently use tableID-underscore-variable number. For SF1 variables I was under the impression that it worked similarly, because in the examples, the query for total population (for which the table ID is 'P001') uses the ID 'P0010001' or what I thought was Table P001 plus cell ID 0001. However I'm trying ...more »

  I'm trying to look at tables from the SF1 and I've noticed they don't seem to follow a consistent format. The ACS ID consistently use tableID-underscore-variable number. For SF1 variables I was under the impression that it worked similarly, because in the examples, the query for total population (for which the table ID is 'P001') uses the ID 'P0010001' or what I thought was Table P001 plus cell ID 0001. However I'm trying to use the table 'PCT20' (Residents in group quarters) and I can't figure out the proper suffix to use to retrieve each individual cell. Adding 001 or 0001 for the cell ID to the end just returns errors.

  Thanks.

  « less full details »

  3 comments for Idea: Formatting of SF1 Table IDs?

  Submitted by Sam Ennis 10 months ago

Displaying all 2 Ideas