Do you need help with data available via the API?
I need to access all tracts in a state I used http://api.census.gov/data/2011/acs5?key=***&get=B19057_001E&for=tract:*&in=state:10+county:*. I get an error message and the same error message when I use tract:*&in=state:10. Could someone help. Thank you
Is it possible to get all tracts within a MSA, as in (an attempt to get all tracts in the DC metro):
http://api.census.gov/data/2011/acs5?key=mykey&get=B00001_001E&for=tract:*&in=metropolitan+statistical+area/micropolitan+statistical+area:47900
This returns:
"error: unknown/unsupported geography heirarchy"
If not this would be useful!
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
In order to understand how crime or criminal elements are embedded within different communities, it may be useful to combine neighborhood crime data with ACS demographic and housing data. There are hotspots in most cities that could be objectively analyzed to reveal patterns which may be disrupted by governmental policy. That is, if the data clearly points to consistent reliable trends.
Many federal grants require applicants to supply Census data when responding to RFPs. Allow agencies to create a report template in AFF for applicants. This would allow for applicants to enter an address and get centroid data that was predefined by the agency. Applicants could downloaded the table in PDF form efficiently with all the available data the federal agency requires.
A dissection of the API query string for the Census API I have posted this in another topic, however it is hard to find. Host name, API sub-folder (this triggers our api to parse the following data). http://api.census.gov/data/ This portion refers to the DataSet/Instance pair (without both, it's difficult to determine what number you want back) 2010/sf1? This determines what variables to retrieve (required, ...more »
A dissection of the API query string for the Census API
I have posted this in another topic, however it is hard to find.
Host name, API sub-folder (this triggers our api to parse the following data).
This portion refers to the DataSet/Instance pair (without both, it's difficult to determine what number you want back)
2010/sf1?
This determines what variables to retrieve (required, must exist within the variable documentation for the API)
get=P012D007,P012D008,P012D009,P012D010,P012D011,P012D012
Geography, all currently available data sets require this to return proper numbers
&for=block+group:1&in=state:2+county:170+tract:000101
The reason for this is two-fold, allowing us to limit users, as well as providing us with information as to how many people are using what dataset.
&key=(yourkeyhere)
« less full details »
I'm attempting to write some Python code to retrieve this information. I only have a little experience with APIs, and I'm kind of lost. import requests query_params = { 'apikey': 'mykey', 'place': , #would like to select all 'state': # would like to select all #probably need one for ZCTAs? } # PO120001 - PO120049 all sex by age categories ...more »
I'm attempting to write some Python code to retrieve this information. I only have a little experience with APIs, and I'm kind of lost.
import requests
query_params = { 'apikey': 'mykey',
'place': , #would like to select all
'state': # would like to select all
#probably need one for ZCTAs?
}
# PO120001 - PO120049 all sex by age categories
# not sure how to request them
endpoint = 'http://api.census.gov/data/2010/sf1' # this is probably wrong
response = requests.get(endpoint, params=query_params)
data = response.json # i think
Has anyone done anything like this? Is Python the wrong way to be doing it?
Thanks
« less full details »
On this site: https://sites.google.com/site/stephaniesmullen/google-map-examples/census-data-acquisition the author uses census boundary files to get coordinates of points that make up the boundary of a polygon. When I tried to do the same thing with boundary files of block groups from the 2010 census for California. One of the files contents was in hex format and the block groups arrangement of polygon data ...more »
On this site:
https://sites.google.com/site/stephaniesmullen/google-map-examples/census-data-acquisition
the author uses census boundary files to get coordinates of points that make up the boundary of a polygon.
When I tried to do the same thing with boundary files of block groups from the 2010 census for California. One of the files contents was in hex format and the block groups arrangement of polygon data isn't clear to me even after I converted it to decimal from hex.
I need help to do the same thing as in the article above except with 2010 block groups.
« less full details »
I am trying to make tract-level thematic maps for several indicators (e.g. unemployment, median family income etc.). In the KML and SVG files I am using (including that obtained from TIGER) the 11 digit GeoID10 seems to be the best column through which I can merge data pertaining to the census tracts either by using the "GEO.id2" field from ACS data downloaded as CSV from FactFinder or through a concatenation of ...more »
I am trying to make tract-level thematic maps for several indicators (e.g. unemployment, median family income etc.).
In the KML and SVG files I am using (including that obtained from TIGER) the 11 digit GeoID10 seems to be the best column through which I can merge data pertaining to the census tracts either by using the "GEO.id2" field from ACS data downloaded as CSV from FactFinder or through a concatenation of "state","county","tract", fields retrieved via the API.
Is there a different key I should be using for tract-level data? This seems to work when making chloropleth maps using the same methods used for making US county-level thematic maps with FIPS (as seen here http://flowingdata.com/2009/11/12/how-to-make-a-us-county-thematic-map-using-free-tools/ )
Thanks in advance for any help.
« less full details »
The statistics from the 1990 and 2000 censuses join the previously available data sets from the 2010 Census and the American Community Survey. In addition, 2011 American Community Survey estimates for the new districts formed for the 113th Congress are also now available.
Using the SF1 api, when I loop through the counties in Virginia, it finishes the county loop and then begins a loop through cities. I noticed it while running a nested loop for the entire US. Virginia was the only state that I noticed doing this, though there could be others. Here's the URL I'm using that generates this list of counties + cities. http://api.census.gov/data/2010/sf1?key={ikey}&get=NAME&for=county:*&in=state:51 ...more »
Using the SF1 api, when I loop through the counties in Virginia, it finishes the county loop and then begins a loop through cities. I noticed it while running a nested loop for the entire US. Virginia was the only state that I noticed doing this, though there could be others.
Here's the URL I'm using that generates this list of counties + cities.
http://api.census.gov/data/2010/sf1?key={ikey}&get=NAME&for=county:*&in=state:51
« less full details »
Hi,
Great job on the API!! It is very fast, and very easy to use. I am a developer, and know how hard it is to write programs that scale.. and you seem to have done a great job..
Just a quick question, I'm curious. I was wondering if you planned on releasing the 2000 SF Census data as well through the API? if so, do you have a target date for this?
Thanks
I'm trying to retrieve the population for a certain zip code. What I found in your online documentation is that I should use the following URL string: http://api.census.gov/data/2010/sf1?key=(key)&get=P0010001&for=zip+code+tabulation+area:(zip)&in=state:(state) ...where (key) is my API key, (zip) is the zip code, and (state) is a two digit code that you use to identify states. The problem that I run into is ...more »
I'm trying to retrieve the population for a certain zip code.
What I found in your online documentation is that I should use the following URL string:
http://api.census.gov/data/2010/sf1?key=(key)&get=P0010001&for=zip+code+tabulation+area:(zip)&in=state:(state)
...where (key) is my API key, (zip) is the zip code, and (state) is a two digit code that you use to identify states.
The problem that I run into is that I cannot find a correct list of states and their corresponding two digit codes. What is particularly frustrating is that you have a list posted at the following address which seems like it provides the two digit codes for states. However the two digit codes on the list at this link do not match up to the data output by the above API URL.
http://www.census.gov/govs/www/gidstate.html
What gives? Is the API not working properly for this type of search? If it is working properly then where can I find the REAL state code list?
Also, why won't the API return a query like the following, where I could just search by zip code for all states?
http://api.census.gov/data/2010/sf1?key=(key)&get=P0010001&for=zip+code+tabulation+area:(zip)&in=state:*
Thanks
« less full details »
We are trying to create a tool where a user would:
1) Enter in their "home" zip code
2) Enter in a radius in miles
3) Hit an "Update" button.
Once the user hit the Update button, the screen would show all zip codes, all cities and all counties within the specified number of miles from the home zip code. Can these Census tools be used to create such a system?
Now that 2007-2011 ACS 5 year data is available in the API, please see this guidance on comparing ACS data. http://www.census.gov/acs/www/guidance_for_data_users/comparing_data/ From the page: The Census Bureau recommends that you: DO compare estimates from non-overlapping periods, for example, compare a 2005-2007 ACS 3-year estimate to a 2008-2010 ACS 3-year estimate. DON'T compare overlapping periods, for example, ...more »
Now that 2007-2011 ACS 5 year data is available in the API, please see this guidance on comparing ACS data.
http://www.census.gov/acs/www/guidance_for_data_users/comparing_data/
From the page:
The Census Bureau recommends that you:
DO compare estimates from non-overlapping periods, for example, compare a 2005-2007 ACS 3-year estimate to a 2008-2010 ACS 3-year estimate.
DON'T compare overlapping periods, for example, the 2005-2007 ACS 3-year estimates to the 2006-2008 ACS 3-year estimates.
« less full details »
Please bear with me, I'm new to this. I have been looking for a way to get Zip+4 demographics. The Census position is that they don't provide that but they point to the shapefiles. I have 2 questions: 1. Can someone simplify whether or not these shapefiles are useful or if the data I want is simply not available here? Example: what is the Male-Female ratio in 68198-9550? 2. What are other companies offering when ...more »
Please bear with me, I'm new to this.
I have been looking for a way to get Zip+4 demographics. The Census position is that they don't provide that but they point to the shapefiles.
I have 2 questions:
1. Can someone simplify whether or not these shapefiles are useful or if the data I want is simply not available here? Example: what is the Male-Female ratio in 68198-9550?
2. What are other companies offering when they charge between $1000 to $30,000 to provide zip+4 demographics?
« less full details »
I am looking for a way to get the ACS data for a radius around a given point. Using the FCC's API I can get the Census Tract and Block number to use. Does anyone know of a way to get the Census tract numbers say within a 5 mile radius?
Is there any data available for political party affiliation within census data? I know it was not part of the 2010 Census Form or the American Community Survey, but I am definitely interested in mining that information if it is available somewhere else in the census database.
