Using Data

List of all Legislature District "names"

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

Voting

0 votes
0 up votes
0 down votes

Using Data

Age and Income Data by Household

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

Voting

0 votes
0 up votes
0 down votes

API Technical Discussions

Definitions

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

Voting

0 votes
0 up votes
0 down votes

API Technical Discussions

Finding Geographies

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

Voting

0 votes
0 up votes
0 down votes

API Technical Discussions

Getting Started Area

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

Voting

0 votes
0 up votes
0 down votes

API Technical Discussions

How to get geocoordinates of a certain block?

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

Voting

1 vote
1 up votes
0 down votes

Bugs / Problems

Problem in B05006_161 for 2012?

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

Voting

0 votes
0 up votes
0 down votes

Bugs / Problems

Error in Census 2010 API document ?

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

Voting

0 votes
0 up votes
0 down votes

Feature Requests

Census 2010 SF1 Block Urban/Rural Data

Following up on my request of 10 months ago ... it does not appear that any urban population or housing unit items are populated at the block level.

This is a request for Census to populate those few 2010 SF1 urban/rural update fields for all summary levels.

Thank you.

Submitted by

Voting

0 votes
0 up votes
0 down votes

API Technical Discussions

'Get' variables for Economic Indicators Time Series data

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

Voting

0 votes
0 up votes
0 down votes

API Technical Discussions

ACS 2013 metro division

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

Voting

0 votes
0 up votes
0 down votes

Application Ideas

Population Pyramid for Zip Code

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

Voting

1 vote
1 up votes
0 down votes

API Technical Discussions

Missing Variables

Hi - I'm relatively new to the API, and have been using it to pull several reports. Recently I was asked to find S0802 MEANS OF TRANSPORTATION TO WORK BY SELECTED CHARACTERISTICS . When I look on Fact Finder I can see the variable, however I'm unable to find it via the API (in the variable definition files for ACS). I'm sure I'm missing something basic, so any direction would be much appreciated.

Submitted by

Voting

0 votes
0 up votes
0 down votes

Bugs / Problems

Issues with API - NO Date or response.

I'm trying the following call and getting nothing. When I put it into the browser the page just hangs. The response says the server received it and then it stops. I'm calculating the average age of each city in the USA. Here is the request (note I removed my key) http://api.census.gov/data/2010/sf1?key=[yourkey]&get=PCT0120157,PCT0120158,PCT0120159,PCT0120160,PCT0120161,PCT0120162,PCT0120163,PCT0120164,PCT0120165,PCT0120166,PCT0120167,PCT0120168,PCT0120169,PCT0120170,PCT0120171,PCT0120172,PCT0120173,PCT0120174,PCT0120175,PCT0120176,PCT0120177,PCT0120178,PCT0120179,PCT0120180,PCT0120181,PCT0120182,PCT0120183,PCT0120184,PCT0120185,PCT0120186,PCT0120187,PCT0120188,PCT0120189,PCT0120190,PCT0120191,PCT0120192,PCT0120193,PCT0120194,PCT0120195,PCT0120196,PCT0120197,PCT0120198,PCT0120199,PCT0120200,PCT0120201,PCT0120202,PCT0120203,PCT0120204,PCT0120205,PCT0120206&for=place:36&in=state:99990 ...more »

Submitted by

Voting

0 votes
0 up votes
0 down votes

API Technical Discussions

Demographics by zip code

Newbie here. I searched the api documentation and still do not fully understand how to use it.

I would like to find the average house value for a given zip code from the 2010 census data. Possible?

If so, please provide an example URL for 09210.

Can the same call be made for multiple zip codes that make up an area?

Thanks!

Submitted by

Voting

0 votes
0 up votes
0 down votes

Census Geography

Gated Community Data

Working on our first mobile application in high-end gated communities. Anybody have any experience with simply obtaining accurate gated community numbers nationally? or locally?

Submitted by

Voting

0 votes
0 up votes
0 down votes

Application Showcase

Census Pop Quiz

Available on iTunes and Google Play stores: How well do you know the 50 states? Do you know the percentage of the population that walk or drive to work in Chicago, IL? What percentage of people make between $50,000 and $75,000 in St. Petersburg, FL? How about how many women have doctoral degrees in Sacramento, CA? Test your knowledge with - Census PoP Quiz, a new population challenge about the 50 states and the District ...more »

Submitted by

Voting

0 votes
0 up votes
0 down votes

Application Showcase

dwellr

Available on Android or iOS: City or country? Bike or drive to work? Beach or mountains? Download the U.S. Census Bureau’s dwellr app today to discover the top 25 U.S. cities and towns that best fit your lifestyle. Whether you prefer the bright lights of the big city or wide open spaces, dwellr powers your phone with neighborhood-level statistics on topics such as home value, education, and how people get to work so that ...more »

Submitted by

Voting

1 vote
1 up votes
0 down votes

Application Showcase

America's Economy Mobile App

Available on Apple and Android: Take the pulse of the U.S. Economy straight from your phone. The America’s Economy app provides real-time updates for 19 key economic indicators released from the U.S. Census Bureau, Bureau of Labor Statistics, and Bureau of Economic Analysis. Key economic measures on employment, manufacturing, international trade, retail sales, and residential construction and sales allow those who follow ...more »

Submitted by

Voting

1 vote
1 up votes
0 down votes