Using Data

Finding Available Variables

Here's an example of how to use DataFerret (a Census table-building tool) to lookup variable names and their descriptions on http://dataferrett.census.gov/run.html

Submitted by (@logan.t.powell)
1 comment

Voting

5 votes
5 up votes
0 down votes
Active

Using Data

Finding Available Variables

Here's an example of how to use DataFerret (a Census table-building tool) to lookup variable names and their descriptions on http://dataferrett.census.gov/run.html

Submitted by (@logan.t.powell)
1 comment

Voting

5 votes
5 up votes
0 down votes
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 »

Submitted by (@samennis)
3 comments

Voting

1 vote
1 up votes
0 down votes
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 »

Submitted by (@samennis)
3 comments

Voting

1 vote
1 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf1, missing variable Amer Ind/Esk/Aleut Males 12-13 yrs

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.

Submitted by (@egillingham)
Add your comment

Voting

0 votes
0 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf1, missing variable Amer Ind/Esk/Aleut Males 12-13 yrs

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.

Submitted by (@egillingham)
Add your comment

Voting

0 votes
0 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf3, missing variable for Gross Rent as % of HH income

"$20,000-$34,999: 30 to 34 percent" (presumably H0500016) is missing. Variables jump from "$20,000-$34,999: 25 to 29 percent" to "$20,000-$34,999: 35 percent or more". Using the variable in the data call results in an unknown variable error.

Submitted by (@egillingham)
1 comment

Voting

0 votes
0 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf3, missing variable for Gross Rent as % of HH income

"$20,000-$34,999: 30 to 34 percent" (presumably H0500016) is missing. Variables jump from "$20,000-$34,999: 25 to 29 percent" to "$20,000-$34,999: 35 percent or more". Using the variable in the data call results in an unknown variable error.

Submitted by (@egillingham)
1 comment

Voting

0 votes
0 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf1, H0240001 should be a stored as a big integer

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.

Submitted by (@egillingham)
1 comment

Voting

0 votes
0 up votes
0 down votes
Active

Bugs / Problems

In 1990 sf1, H0240001 should be a stored as a big integer

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.

Submitted by (@egillingham)
1 comment

Voting

0 votes
0 up votes
0 down votes
Active

API Technical Discussions

Education Information

Hi,

Is there any way to find out

 

How many people are Educated ?

 

How many people are schooling ?

 

How many people are Bachelors degree ?

 

How many people are graduate or proffessional degree ?

Submitted by (@lakshmiranga.pasupuleti)
1 comment

Voting

0 votes
0 up votes
0 down votes
Active

API Technical Discussions

Education Information

Hi,

Is there any way to find out

 

How many people are Educated ?

 

How many people are schooling ?

 

How many people are Bachelors degree ?

 

How many people are graduate or proffessional degree ?

Submitted by (@lakshmiranga.pasupuleti)
1 comment

Voting

0 votes
0 up votes
0 down votes
Active