Webinar May 15
May 15, 1pmET, join us for a webinar for app developers interested in the American Community challenge using ACS data in the National Day of Civic hacking. See http://go.usa.gov/T6bW for details.
Feedback on multiple technical issues
May 15, 1pmET, join us for a webinar for app developers interested in the American Community challenge using ACS data in the National Day of Civic hacking. See http://go.usa.gov/T6bW for details.
Hi,
I am doing a http get http://api.census.gov/data/2010/sf1?key=user key&get=P0010001,NAME&for=state:* and this succeeds with response of 200, but the JSON elements are null. This same call used to work a few days back, now I get the following: ["P0010001","NAME","state"],["null","null","null"],["null","null","null"],...
Please help.
Thank You.
Is there an API equivalent of the FactFinder search "All Places fully or partially within [County]?"
Such as http://factfinder2.census.gov/bkmk/table/1.0/en/DEC/10_SF1/P1/0500000US53019.16000P
I'm doing a project where I require census statistics by Zip Code. I want to look at correlations between several different factors. I have addresses and zip codes.
To pull in data by zip code what would my API call look like.
an application that was running last night no longer operates. It is accessing ACS 2011 5 year data at BG level with a multi-item request (fails with just 2). Were changes made that could affect this? Thank you.
Is there any API which can be used to find average income of people in an area by entering the zip code?
I would like to get census block group data for various groups that overlap with a polygon map overlay. If I can get the block groups and need say the number of Chinese of ages 18 to 34 in those block groups then how do I do a JavaScript query to get them?
Hi all, I am trying to use the api to collect information for zip code tabulation areas from the ACS 2011 survey. I have tried several variations of the following url, but get an unsupported/unknown geography error: http://api.census.gov/data/2011/acs5?key={key}&get=B25070_003E&for=zip+code+tabulation+area:*&in=state:06 I have read elsewhere on this form that the 2011 ACS is now available via the API by zip ...more »
Hi all,
I am trying to use the api to collect information for zip code tabulation areas from the ACS 2011 survey.
I have tried several variations of the following url, but get an unsupported/unknown geography error:
http://api.census.gov/data/2011/acs5?key={key}&get=B25070_003E&for=zip+code+tabulation+area:*&in=state:06
I have read elsewhere on this form that the 2011 ACS is now available via the API by zip code. Is this correct? If so, what is the proper format to query the API for the ACS survey?
« less full details »
this call worked yesterday with slightly different items, but fails today. is this dataset offline, or? thank you.
Department of Labor has added Census API access to their SDK for iOS. See
Need code list for AIA. The SF1 identification section shows this field -- American Indian Area/Alaska Native Area/ Hawaiian Home Land (FIPS) AIANHHFP 5 81 A/N 00001–89999 American Indian area, Alaska Native area, or Hawaiian home land This is apparently the code field required by the API (both SF1 and ACS). Geography division cannot locate this file. most all references are now 4 digit ANSI codes (includiing ...more »
Need code list for AIA.
The SF1 identification section shows this field -- American Indian Area/Alaska Native Area/
Hawaiian Home Land (FIPS) AIANHHFP 5 81 A/N
00001–89999 American Indian area, Alaska Native area, or Hawaiian home land
This is apparently the code field required by the API (both SF1 and ACS). Geography division cannot locate this file. most all references are now 4 digit ANSI codes (includiing shapefiles).
Hoping you can help with code list or revised API structure.
Thank you.
« less full details »
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 »
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 Income In The Past 12 Months For Current Residence In The United States
Results in the error: 'Invalid API key or request'
In looking at api examples for the ACS endpoints, you use table names like B00001_001E, which are not listed with in the ACS sf1 documentation. As an example, B02001_00E is listed as Total Population, but according to the ACS SF1 document the table number for Total Population is B01003.
Is there logic or a mapping of the ACS SF1 table names to the required API SF1 table names?
Any help would be greatly appreciated.
------------------------------------------------------------------
EDIT:
Updating for the sake of posterity. A listing of the api field names can be found here:
Census SF1:
http://www.census.gov/developers/data/sf1.xml
ACS SF1:
http://www.census.gov/developers/data/acs_5yr_2010_var.xml
It appears that with the ACS datapoints, the table name is converted to field names to take into account Estimates and Margins of Error.
Reference the XML instead of the SF1 PDFs when accessing the API.
« less full details »
Is there any place, where can I get all the APIs exposed by Census. [kind of API Browser] . This greatly helps the developers to use the correct API to get the data, what they look for. In addition, it helps to see entire API in one place.
Is it possible to use the API to fetch all tracts within a state? I tried the following request, but failed:
http://api.census.gov/data/2011/acs5?key=af4bfcf4a660196ff6a297eadfa70331f&get=NAME,B19013_001E,B19013_001M,NAME&for=tract:*&in=state:02+county:*
I am obviously overlooking something. There must be a better way to determine a "Concept"/"Variable Name" than trudging through the xml file.
Can someone please point me in the correct direction?
Thanks
Hello I am new to getting data from the Census. Could use some help. I have now all the states register voters. Now I need to pull register voters for all US counties for an app I am building
Just a reminder - you can now call up to 50 variables with each API call.
I wrote a python script to download all the census tract data for four different counties, parse it and save it as csv to upload to our database.
it works great! except that sometimes only the first and fourth queries return data.
Is there limit on how fast we can fire off queries to the API?
Greetings, Though we have provided this infomation in a reply to an existing thread, we also wanted to create a "fresh" post to let everyone know that the maximum number of variables per request has been increased from 4 to 50. The documentation on www.census.gov/developers/ will be updated to reflect this information as well. Thank you to everyone who has provided feekback so far. We do take the feedback into account ...more »
Greetings,
Though we have provided this infomation in a reply to an existing thread, we also wanted to create a "fresh" post to let everyone know that the maximum number of variables per request has been increased from 4 to 50. The documentation on www.census.gov/developers/ will be updated to reflect this information as well.
Thank you to everyone who has provided feekback so far. We do take the feedback into account as we continue to improve the API so please keep it coming.
« less full details »
Via API queries I have easily obtained all county populations within a state, and all places populations within a state. Is there a way to obtain population for each place in a particular county? The main problem is that I want to know all of the places that are contained in one particular county. A secondary special case issue is the situation where a place (incorporated or CDP) may cross a county boundary... thus making ...more »
Via API queries I have easily obtained all county populations within a state, and all places populations within a state. Is there a way to obtain population for each place in a particular county? The main problem is that I want to know all of the places that are contained in one particular county. A secondary special case issue is the situation where a place (incorporated or CDP) may cross a county boundary... thus making it difficult to determine what percentage of the places area and population is in each county. Do you think this is possible, and do I need to go down to tract and group levels?
« less full details »
First of all I want to thank you all at the Census for your brilliant effort in providing a usable API. I think the documentation needs to be improved, though, with more examples of string requests and possible use of wild cards, if any. I am currently working on a web application where I want the user to visualize demographic indicators within a certain distance from a specific/user-picked LatLong (for instance total ...more »
First of all I want to thank you all at the Census for your brilliant effort in providing a usable API. I think the documentation needs to be improved, though, with more examples of string requests and possible use of wild cards, if any.
I am currently working on a web application where I want the user to visualize demographic indicators within a certain distance from a specific/user-picked LatLong (for instance total population count within 5 miles, or % of Hispanic people for each block group within a tract), but I can't find any information on how to retrieve, through the API, the census' geographic boundaries (tract, block group or block) in order to plot them on a map (Google), or how to get a list of all block groups within a tract or blocks within a block group.
Is this at all possible? If so, can you please give me some direction?
« less full details »
I'm having some trouble going from lat/lng to block data. The example here (http://www.census.gov/developers/data/geography_list_sf1.html) seem to indicate that state, country, and tract information is required to get the block data. Here (http://www.census.gov/developers/geo/) it recommends using the FCC's Block Conversion API to convert lat/lng to block FIPS code. That's great, but it doesn't return the tract so ...more »
I'm having some trouble going from lat/lng to block data.
The example here (http://www.census.gov/developers/data/geography_list_sf1.html) seem to indicate that state, country, and tract information is required to get the block data.
Here (http://www.census.gov/developers/geo/) it recommends using the FCC's Block Conversion API to convert lat/lng to block FIPS code.
That's great, but it doesn't return the tract so I'm not able to access the census data. Am I missing something? How are others doing this?
« less full details »
Hey I had a general question about the API. Im interested in finding out where the data set for a ZIP Code demographics can be found. I got approved for the API Key but need to find out where the Zip Code demographic info is. I would like to gather a ZIP Code from a data set I have and output the following. Does anyone know the codes for this, or on what page of the API manual it can be found? Median Income ($) ...more »
Hey I had a general question about the API.
Im interested in finding out where the data set for a ZIP Code demographics can be found.
I got approved for the API Key but need to find out where the Zip Code demographic info is.
I would like to gather a ZIP Code from a data set I have and output the following. Does anyone know the codes for this, or on what page of the API manual it can be found?
Median Income ($)
Cost Of Living Index
Median Mortgage To Income Ratio (%)
Owner Occupied Homes (%)
Median Rooms In Home 4.2
College Degree (%)
Professional (%) 46.8
Population
Average Household Size 2.3
Median Age
Male To Female Ratio (%)
Married (%)
Divorced (%)
White (%)
Black (%)
Asian (%)
Hispanic Ethnicity (%)
« less full details »
I can't find the following fields in the SF1 API:
P0020002 Total Urban Persons
P0020003 Total Rural Persons
Are only a subset of fields availible through this API?
Also it appears that I can only request up to 5 fields (seperated by commas) through the URL string. Is there a way to query more?
Is there a way to use the NAME parameter for the IDs of variables? I've been using it to fill in the names of geographies but it doesn't seem to work for variable IDs in the output.