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 »

Voting

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 »

Voting

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 »

Voting

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 »

Voting

In the 1990 sf1 data call, H0240001 (Spec Own-occ HUs:Agg Value) is currently returned as a regular integer. However, all the state values are the same - 2,147,483,647, which is the max value that can be stored in a regular integer, indicating that the variable should be stored as a big integer.

Voting

In the 1990 sf1 data call, H0240001 (Spec Own-occ HUs:Agg Value) is currently returned as a regular integer. However, all the state values are the same - 2,147,483,647, which is the max value that can be stored in a regular integer, indicating that the variable should be stored as a big integer.

Voting

In the first 1990 census table, there is no variable for Amer Ind/Esk/Aleut Males 12-13 yrs. In the age by race and gender group, the variables skip from P0120131 to P0120133, so presumably P0120132 is the missing age range. Using the variable in the data call results in an unknown variable error.

Voting

In the first 1990 census table, there is no variable for Amer Ind/Esk/Aleut Males 12-13 yrs. In the age by race and gender group, the variables skip from P0120131 to P0120133, so presumably P0120132 is the missing age range. Using the variable in the data call results in an unknown variable error.