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 »
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?
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?
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 »
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 »
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 »
I get error: the 'get' argument must be a comma separated list of variable names with the following query:
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.
I want usa all school data with it's state ,district,couty,city
for my application for school
Census has added the very helpful restructured subject matter item lists (eg, http://api.census.gov/data/2000/sf3/variables.html). Thank you. I am seeking an easy way to search for two or more keywords (eg, Age, Hispanic) in a nonphrase structure that will highlight rows/items that meet that condition. ... by searching on the unmodified html. Any thoughts on this? Thank you.
I just wanted to share a labeling error we have run across in the 2010 SF1 API Variables XML. (http://api.census.gov/data/2010/sf1/variables.xml) Under renter occupied by race/ethnicity for each race/ethnicity (Asian householder as example) the xml:id="H016D0017" and xml:id="H016D0010" are both labeled: label="Renter occupied: !! 7-or-more-person household". When xml:id="H016D0010" is the total and should have a label ...more »
I would like to access the data(excel files) from the below location using any web service/file system.
Can you please let me know if is is feasible? If so can you please share the details.
I'm looking for Housing Units and Building permits information
AffordableHousingOnline.com provides affordable rental housing market data on every city and county in the U.S. For example, here is the affordable rental housing market page for Washington, DC: http://affordablehousingonline.com/housing-search/District-of-Columbia/Washington/ AHO's own proprietary database of Federally assisted housing is mashed up with Census place data to provide an innovative look into rental ...more »
When I'm on http://www.census.gov/developers/ and try to click the link to visit the developer forum, Chrome sees it as a pop-up and blocks it. If I'm not paying attention, it appears that the url doesn't work.
"$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.
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.
Is there any documentation for interpreting the values returned in the DATE variable in the population estimates API?
For example, http://api.census.gov/data/2013/pep/natstprc?get=POP,DATE&for=state:25&key=xxxxx returns numerically coded data values (e.g., "1", "6"). I can see by the data that 6 = 2013 but would love to see official documentation somewhere.
You inadvertently removed an important page: http://www.census.gov/developers/data/?eml=gd&utm_medium=email&utm_source=govdelivery.
This page had links to documentation, variables and examples for the ACS5 API.
It took us a while to find this page. Please put it back up.
We are looking to pull county subdivision data for 2008-12, 2010 and 2000. Unfortunately, unlike the other two, 2000 county subdivision geography is not available for SF1 or SF3. We would love to have this data be made available through the API. http://api.census.gov/data/2000/sf1/geo.html http://api.census.gov/data/2000/sf3/geo.html Looking to have added: Summary Level:060 state-county-county subdivision Thanks, ...more »
On the 1990 census sf3 variable call, two time frames (20 to 24 and 35 to 39) are missing from "travel time to work". The variable codes increment from P0500001 (TRAVEL TIME Less than 5 minutes) to P0500013 (TRAVEL TIME Worked at home), with P0500005 and P0500008 missing - presumably the missing time frame variables. Using these in the data call results in an 'unknown variable' error. Is this a bug and the data ...more »
Hello everyone, This is a question requiring some general direction and also some technical help: I would like to automatically (daily, weekly?) upload ACS reports by county (all 3200+) into a database hosted locally. My boss wants it in MS Access (this is not up for debate, I have tried). From MS Access, we'd like to be able to extract the fields we need to populate a .xls file or any other format. Eventually, even ...more »
I have a tool (geocoding, etc) that uses Census 2010 data and it puts out a report with '% Minority" and "Total Housing Units" -- how do I know what Census table originates this data ? And : What the corresponding table/field is in ACS ?
Is there somewhere that documents the Bureau's future plans/roadmaps for its APIs? We're getting ready to build a major project using the ACS and Population Estimate APIs, and it would be helpful to know if the bureau is committed to updating the API as new data are released. For example, last Sept. it was great to see the 2012 ACS data added to the API as the numbers were released on FactFinder. Can we expect that ...more »
Hi, I've been working with the following query: http://api.census.gov/data/2012/popproj/pop?get=TOTAL_POP,POP_4,POP_3,POP_2,POP_1,POP_0&ORIGIN=0&RACE=0&SEX=0&YEAR=2012&key= I think it is returning total usa population of age 5 and under for the year 2012. Is there a way to get the same information for each state? In other words is per state information available from popproj/pop? Or do I need to query another data ...more »