Vote up to Idea Formatting of SF1 Table IDs? Vote down to Idea Formatting of SF1 Table IDs?

Rank87

Idea#36

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 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.

Comment

Submitted by Sam Ennis 1 year ago

Vote Activity

  1. Approved
    1 year ago

Events

  1. The idea was posted
    1 year ago

Comments (3)

  1. I am under the impression that not all SF1 tables are retrievable yet through the API. PCT20 is not in the XML and I don't think that data from this table can be retrieved. I also think that the variable IDs will start with PCT020, not PCT20. Please keep also in mind that the lowest level of geography for the PCT tables is Census Tract.

    1 year ago
  2. Sam Ennis Idea Submitter

    Thanks. Is there a separate XML file for SF1 variables? The one I have only has ACS.

    1 year ago
  3. The XML containing the SF1 variables can be found at: http://www.census.gov/developers/data/sf1.xml

    1 year ago