API Developers Forum

Browse Recent Ideas

• Recent Ideas (141)
• Popular Ideas (141)
• Hot Ideas (47)
• In Review Ideas (0)
• In Progress Ideas (0)
• Complete Ideas (0)

• Vote up

  Feedback Score

  0

  +1

  -1

  Vote down
  This idea is active.
  Using Data »

  gender by zip code

  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 »

  3 comments for Idea: gender by zip code

  Submitted by Community Member 2 months ago

• Vote up

  Feedback Score

  2

  +2

  -0

  Vote down
  This idea is active.
  Using Data »

  Census Data Acquisition from Boundary Files

  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 »

  2 comments for Idea: Census Data Acquisition from Boundary Files

  Submitted by Community Member 2 months ago

• Vote up

  Feedback Score

  -1

  +0

  -1

  Vote down
  This idea is active.
  API Technical Discussions »

  Polygon, block group and census data

  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?

  6 comments for Idea: Polygon, block group and census data

  Submitted by Community Member 2 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  Using Data »

  Best practice for census tract level GeoID

  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 »

  3 comments for Idea: Best practice for census tract level GeoID

  Submitted by maraaverick 3 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  API Technical Discussions »

  ACS data for zip code tabulation area

  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 »

  2 comments for Idea: ACS data for zip code tabulation area

  Submitted by Community Member 3 months ago

• Vote up

  Feedback Score

  -1

  +0

  -1

  Vote down
  This idea is active.
  General Feedback »

  Related APIs

  For the Census team or whomever else ... the DOL APIs only seem to provide access to metadata; no statistical data. What is known of other Federal agencies having APIs that provide access to demographic-economic data?

  4 comments for Idea: Related APIs

  Submitted by Community Member 3 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  General Feedback »

  Demographic Profile Data

  The demographic profile data for the 113th congressional districts are great! :) To make effective use of these data, the same scope of subject matter are needed minimally for each state and the U.S ... MSAs also needed. Resources may not be available to do this ... offering suggestions. The ACS 2010 & 2011 5 year DP2...DP5 for tracts, places, counties, school districts, states & the U.S. are also requested additions ...more »

  The demographic profile data for the 113th congressional districts are great! :)

  To make effective use of these data, the same scope of subject matter are needed minimally for each state and the U.S ... MSAs also needed. Resources may not be available to do this ... offering suggestions.

  The ACS 2010 & 2011 5 year DP2...DP5 for tracts, places, counties, school districts, states & the U.S. are also requested additions ... and corresponding 2011 ZCTA data.

  Thank you.

  « less full details »

  2 comments for Idea: Demographic Profile Data

  Submitted by Community Member 3 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  Bugs / Problems »

  Data dictionary names

  Some of the data dictionary reference names are not being recognized by the service.

  for example, http://api.census.gov/data/2010/sf1?get=P0280001&for=block:2022&in=state:06+county:001+tract:440336&key=8a5899c75bfeb1eb8685fd6c2b067a669e0b89aa

  error: error: unknown variable 'P0280001'

  1 comment for Idea: Data dictionary names

  Submitted by Sai Dhalli 3 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  Bugs / Problems »

  Update to: URL issues

  This post references http://apiforum.ideascale.com/a/dtd/issue-using-2000-sf1/400890-18378

  This error has been resolved. There was a small configuration reversion which caused some summary levels to fail.

  These summary levels have been re-added, and are functioning properly

  Add your comment for Idea: Update to: URL issues

  Submitted by Phillip Thomas 3 months ago

• Vote up

  Feedback Score

  -1

  +0

  -1

  Vote down
  This idea is active.
  API Technical Discussions »

  issue using 2000 sf1

  this call worked yesterday with slightly different items, but fails today. is this dataset offline, or? thank you.

  http://api.census.gov/data/2000/sf1?key=KEY&get=P009001,P009002,P009003,P009004,P009005,P009006,P009007&for=block+group:1&in=state:06+county:001+tract:400100

  1 comment for Idea: issue using 2000 sf1

  Submitted by Community Member 3 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  Using Data »

  Additonal Data Sets Added

  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.

  Add your comment for Idea: Additonal Data Sets Added

  Submitted by Lisa W 3 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  Census Geography »

  Geographic Relationships

  Relationship files are provided as a tool to help you compare the universe of Census geographies from the 1990, 2000 and 2010 Censuses. See http://www.census.gov/geo/maps-data/data/relationship.html

  Add your comment for Idea: Geographic Relationships

  Submitted by Lisa W 3 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  Feature Requests »

  School Districts

  Appears Census 2010 school districts not among data enhancements. Can these data be made accessible? Thank you.

  Add your comment for Idea: School Districts

  Submitted by Community Member 3 months ago

• Vote up

  Feedback Score

  -1

  +0

  -1

  Vote down
  This idea is active.
  General Feedback »

  Data Updates

  Looking good! Thank you for the data updates.

  1 comment for Idea: Data Updates

  Submitted by Community Member 3 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  API Technical Discussions »

  DOL SDK

  Department of Labor has added Census API access to their SDK for iOS. See

  https://github.com/USDepartmentofLabor/DOLDataSDK-iOS

  Add your comment for Idea: DOL SDK

  Submitted by Lisa W 3 months ago

• Vote up

  Feedback Score

  -1

  +0

  -1

  Vote down
  This idea is active.
  Using Data »

  Problem in Virginia Data

  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 »

  1 comment for Idea: Problem in Virginia Data

  Submitted by neroth 3 months ago

• Vote up

  Feedback Score

  -1

  +0

  -1

  Vote down
  This idea is active.
  Bugs / Problems »

  API key not valid

  I've had an API key for weeks and just got back to my project after doing some other work. I get this error when I make a query that used to work:

  "A valid key must be included with each data API request.

  You included a key with this request, however, it is not valid.

  Please check your key and try again.'

  Any thoughts?

  5 comments for Idea: API key not valid

  Submitted by bharper 3 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  API Technical Discussions »

  AIANHHFP Code

  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 »

  1 comment for Idea: AIANHHFP Code

  Submitted by Community Member 4 months ago

• Vote up

  Feedback Score

  2

  +2

  -0

  Vote down
  This idea is active.
  API Technical Discussions »

  ACS2010 sf1 table mapping

  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 »

  1 comment for Idea: ACS2010 sf1 table mapping

  Submitted by tyrauber 4 months ago

• Vote up

  Feedback Score

  10

  +10

  -0

  Vote down
  This idea is active.
  Application Showcase »

  acs package in R

  Working with the Puget Sound Regional Council, I've modified my acs package for R to allow users to download data directly from the Census ACS API. See http://eglenn.scripts.mit.edu/citystate/2013/02/major-improvements-to-acs-r-sneak-peak-at-version-1-0/ for more info and user guide. Features and improvements include: * The package is now capable of downloading data directly from the new Census American Community ...more »

  Working with the Puget Sound Regional Council, I've modified my acs package for R to allow users to download data directly from the Census ACS API. See http://eglenn.scripts.mit.edu/citystate/2013/02/major-improvements-to-acs-r-sneak-peak-at-version-1-0/ for more info and user guide.

  Features and improvements include:

  * The package is now capable of downloading data directly from the new Census American Community Survey API and importing into R (with proper statistical treatment of estimates and error, variable and geographic relabeling, and more), all through a single “acs.fetch()” function;

  * The package includes a new “geo.make()” function to allow users to create their own custom geographies for organize and download data; and

  * The package provides two special “lookup” tools to help filter through all the existing Census geographies (with the “geo.lookup()” function) and tables (with the “acs.lookup()” function) to find exactly what they want. These functions return new R “lookup” objects which can be saved, manipulated, and passed to acs.fetch() for downloading data.

  (Still beta, but getting close -- any help/testing appreciated.)

  « less full details »

  3 comments for Idea: acs package in R

  Submitted by eglenn 4 months ago

• Vote up

  Feedback Score

  5

  +5

  -0

  Vote down
  This idea is active.
  Application Showcase »

  CensusConnect

  

  Hey All,

  just wanted show off my usage of the Census API.. I am using the census data to show off surrounding block census data around each address on real estate listings. Pretty cool. Thanks for Census Developer API for doing such a great job to make this possible. Check it out:

  http://www.census-connect.com

  5 comments for Idea: CensusConnect

  Submitted by cmanganillo 4 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  Using Data »

  2000 SF Census data

  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

  1 comment for Idea: 2000 SF Census data

  Submitted by cmanganillo 4 months ago

• Vote up

  Feedback Score

  -1

  +0

  -1

  Vote down
  This idea is active.
  Feature Requests »

  School District Type

  This is a request to simplify the school district API call structures to have only one replacing the three separate calls for unified, secondary and elementary. The school district codes are unique within state irrespective of the type (U, S, E). Most users are interested in a few districts by name/id, all districts in a state/region or all districts in the U.S. Also, just having the state+district code provides ...more »

  This is a request to simplify the school district API call structures to have only one replacing the three separate calls for unified, secondary and elementary.

  The school district codes are unique within state irrespective of the type (U, S, E). Most users are interested in a few districts by name/id, all districts in a state/region or all districts in the U.S. Also, just having the state+district code provides a unique tie-back to the U, S, E status.

  Thank you.

  « less full details »

  8 comments for Idea: School District Type

  Submitted by Community Member 4 months ago

• Vote up

  Feedback Score

  -1

  +0

  -1

  Vote down
  This idea is active.
  Feature Requests »

  Metros & ACS 2010/2011 1 Year Data

  This adds to my note re the need for 113th Congressional District data (minimally from ACS 2011 1 year data corresponding to easystats). Since all but 2 MSAs are included in the ACS 1 year estimates, most users would benefit from having most recent (ACS 2011 1 year) data for MSAs, unless comparing the MSA with subMSA geography. This is a request to add MSA ACS 2011 1 year (also ACS 2010 and Census 2010 even better) ...more »

  This adds to my note re the need for 113th Congressional District data (minimally from ACS 2011 1 year data corresponding to easystats).

  Since all but 2 MSAs are included in the ACS 1 year estimates, most users would benefit from having most recent (ACS 2011 1 year) data for MSAs, unless comparing the MSA with subMSA geography.

  This is a request to add MSA ACS 2011 1 year (also ACS 2010 and Census 2010 even better) API calls for single MSAs and US wildcarded. Setting the call for all CBSAs and metropolitan divisions might be better.

  Thank you.

  « less full details »

  1 comment for Idea: Metros & ACS 2010/2011 1 Year Data

  Submitted by Community Member 4 months ago

• Vote up

  Feedback Score

  1

  +1

  -0

  Vote down
  This idea is active.
  Using Data »

  Problem with List of State Codes and Zip Code Search

  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 »

  7 comments for Idea: Problem with List of State Codes and Zip Code Search

  Submitted by Community Member 4 months ago

Displaying 51 - 75 of 141 Ideas

• « Previous
• 1
• 2
• 3
• 4
• 5
• 6
• Next »