Browse Recent Ideas

Difference between Data Profile and Summary File API?

Stage: Active

Campaign: Using Data

What is the difference between the Data Profile data and the Summary file data. It seems very similar, with some overlap, but also slightly different, and I don't understand the relationship between the two. Is the Summary File information used to create the Data Profiles? Are these two totally different surveys with different metrics? It's not clear to me when I should use the Summary File vs Data Profile. I've leaned ...more »

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Data Profile API Incorrect for DP02_0024PE

Stage: Active

Campaign: Bugs / Problems

The ACS 5 Year API is returning incorrect data for the DP02_0024PE variable. It should be returning a percent value but it is returning a sum.

Should be %:

http://api.census.gov/data/2013/acs5/profile?get=NAME,DP02_0024PE&for=state:01

It is returning same as this:

http://api.census.gov/data/2013/acs5/profile?get=NAME,DP02_0024E&for=state:01

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Error in variable list for census 2010 SF1

Stage: Active

Campaign: Bugs / Problems

Hi,

I found a couple of errors in the variable list for SF 1 census 2010. For example P0050010 should be "Hispanic or Latino:" but is listed as something else on the variables page here

http://api.census.gov/data/2010/sf1/variables.html

and the json here: http://api.census.gov/data/2010/sf1/variables/P0050010.json

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

ACS 2011 1 Year

Stage: Active

Campaign: Using Data

Is there a specific reason that 2011 1 year data is only available by Congressional District? I've been asked by one of our business analysts, and wanted to provide an accurate answer.

Thanks in advance for any insight!

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Trouble getting daytime population

Stage: Active

Campaign: Using Data

Hi everyone, I'm trying to calculate the daytime population at the block level and/or the block group level. It's noted here (https://www.census.gov/hhes/commuting/data/calculations.html) that we can query the API and get the code "B08604 Total Workers for Workplace Geography." However, this code returns the "null" value in various data sets (including ACS 5-year) at the block-group and block level. It seems like ...more »

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Merging Table Lookup and Shell Files

Stage: Active

Campaign: Using Data

In order to get the proper titles for variables/cells in the data I needed to write a program to merge two Excel files. The two files are Sequence_Number_and_Table_Number_Lookup.xls and ACS2012_5-Year_TableShells.xls. The first one contains the sequence and line numbers so that I can get the values from the data-tables. The second one has indents in the cell titles so I know how to combine them to create a proper cell ...more »

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Add GET parameter for tables

Stage: Active

Campaign: Feature Requests

There is a limit of 50 variables in a GET. So, I can understand, sort of, the need to limit, but many of your tables have more than 50 cells. For example: [ACSSF, B04001, 0006, , 7, 109 CELLS, , FIRST ANCESTRY REPORTED, Ancestry], has 109 cells, and if I want to get Estimates plus Margin of Errors I need to get 218 variables. So, why not accept a table number parameter instead? It would make the calls much easier and ...more »

Submitted by

Feedback Score

3 votes
3 up votes
0 down votes

Can't get an API Key

Stage: Active

Campaign: Bugs / Problems

Hi,

I've tried for several days to request an API key from the census developers site with no success. I have filled out the form trying a couple different email addresses and have not received any additional information. I've checked my spam folder in each of the email accounts and no results there either. What is my next step to get an api key?

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

List of all Legislature District "names"

Stage: Active

Campaign: Using Data

I need a list of all the states' legislature's district names. I will use this list as the definitive list of district names that data is mapped to. I tried to use the " Census Name Lookup Tables" found here: https://www.census.gov/geo/maps-data/data/nlt.html but there are many district names that don't map properly to the district names returned by the 2012-5yr-ACS API. So, for example, if I submit the query: http://api.census.gov/data/2012/acs5?get=B19301_001E&for=state+legislative+district+(lower+chamber):*&in=state:50 ...more »

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Age and Income Data by Household

Stage: Active

Campaign: Using Data

Hi, I am attempting to examine households within a given geography, and would like to count the number of households which fill certain income and age constraints. For example: Household contains person age 12 Household income between $50k and $60k Is this possible using the ACS 3-year tables? When I load a generic tabulation, I know the fields exist (age, income, location) but I cannot get the conditional results (% ...more »

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Definitions

Stage: Active

Campaign: API Technical Discussions

Hello All, Is there a way to return the label and or concept instead of just the call variable code e.g. Return both DP02_0001E and "HOUSEHOLDS BY TYPE!!Total households" so that the data is easily presented without further manipulation in the application. For example this would be useful in presenting the data in a table, where the table heading would be "HOUSEHOLDS BY TYPE!!Total households" instead of the more ...more »

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Finding Geographies

Stage: Active

Campaign: API Technical Discussions

I'm still a newbie and am trying to find a way to pull geographies via the API.

For example, is there a way for our application to only store state names or FIPS codes, then pull all other possible geographies via the API? Or, do we need to store all the needed geographies on our end?

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Getting Started Area

Stage: Active

Campaign: API Technical Discussions

Complete Newbie here. Trying to systematically get started. Have looked through the documentation but not exactly sure where to start when it comes to ACS data. Is there a place with all the possible URI's , URL parameters and explanations , so that if I was making a call I could look through a list and easily select the parameters and corresponding values .

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

How to get geocoordinates of a certain block?

Stage: Active

Campaign: API Technical Discussions

I'm having trouble getting the geo-boundaries of a specific block.

For example, let's say I have the following info:

state: 53

county: 033

tract: 000100

block: 1006

How can I know where this specific block is? In other words, how do I get the geo-boundaries of this specific block so that I can map this block with latitude,longitude coordinates?

Thanks!

Submitted by

Feedback Score

1 vote
1 up votes
0 down votes

Problem in B05006_161 for 2012?

Stage: Active

Campaign: Bugs / Problems

I think there may be small glitch in the API for table B05006 for the 5-year ACS for 2012 -- something about the terminal, 161th variable: The following call works fine for 2011: http://api.census.gov/data/2011/acs5?get=B05006_161E,NAME&for=county:*&in=state:22 but when I try the same for 2012, there's trouble: http://api.census.gov/data/2012/acs5?get=B05006_161E,NAME&for=county:*&in=state:22 The other variables ...more »

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Error in Census 2010 API document ?

Stage: Active

Campaign: Bugs / Problems

Hi All, I believe that the Census 2010 API documentation (http://api.census.gov/data/2010/sf1/variables.html) has an error for the table: P12A. Sex By Age (White Alone). It appears that both P012A026 and P012A049 are attributed as Female: !! 85 years and over. I believe that P012A026 should be 'Female' (as in the total of all females. BTW - I have *not* checked the data as of yet. The data could be correct with ...more »

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

'Get' variables for Economic Indicators Time Series data

Stage: Active

Campaign: API Technical Discussions

The link at http://api.census.gov/data/eits/eits_program_code_RESCONST.xml provides us with most of the information we need to use the API to access data for Residential Construction in the "Economic Indicators Time Series" data. What appears to be missing are variables for the "get" parameter. Manually downloaded data sets (non-api) do not reveal or hint at any variables that could be used either. So maybe there is ...more »

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

ACS 2013 metro division

Stage: Active

Campaign: API Technical Discussions

An ACS 2013 CBSA "name" in the API call is "for=metropolitan+statistical+area/micropolitan+statistical+area"

That does not work for summary level 314.

What is the spelling of the "name" for a metropolitan division? Guessing,

"for=metropolitan+division" does not work.

Can you please provide a full sample? complete with a MD code.

Thank you.

Submitted by

Feedback Score

0 votes
0 up votes
0 down votes

Population Pyramid for Zip Code

Stage: Active

Campaign: Application Ideas

Hello,

I'm new to using the API and was wondering if you have seen examples of using the API to retrieve data needed to build a population pyramid for population of a zip code.

If there are no examples, I would like to build it with a team and add it to the forum for public use. Let me know if you want to collaborate.

Thanks!

Submitted by

Feedback Score

1 vote
1 up votes
0 down votes

Displaying 1 - 25 of 272 Ideas