API Technical Discussions

Feedback on multiple technical issues

API Technical Discussions

Census Personnel Inadvertently Removed An Important Page

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.

Submitted by (@aviat0r)
3 comments

Voting

4 votes
4 up votes
0 down votes
Active

API Technical Discussions

General design and specific API questions

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 »

Submitted by (@lvanleir)
6 comments

Voting

0 votes
0 up votes
0 down votes
Active

API Technical Discussions

Latitude/Longitude in PDI

Hi All,

 

I am trying to call the API for the the geocoder census geographical locations for few addresses I have in my database. I want the longitude/latitude values for each address.I want to call the API through a javascript in an ETL tool. Can anyone suggest method or any useful link for that? It would be a great help.

 

Thanks!!

Submitted by
Add your comment

Voting

0 votes
0 up votes
0 down votes
Active

API Technical Discussions

Query help

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 »

Submitted by
1 comment

Voting

0 votes
0 up votes
0 down votes
Active

API Technical Discussions

COUNTY lookup by valid street address

I am looking for a solid WebService API method that will allow me to submit an http request with a pre-validated US Street/City/State/Zip address and return COUNTY in xml or json about 200 times per work day.It looks like the US Census API may do it? Is the data current enough? What might a request look like? Many thanks in advance.

Submitted by
5 comments

Voting

0 votes
0 up votes
0 down votes
Active

API Technical Discussions

Specific Population Data Access

I would like to access specific population data for Black African America population data by state, county and city. Is this possible today? If so how do I access the data to use for an App? If not, can this feature be created?

1 comment

Voting

-1 votes
0 up votes
1 down votes
Active

API Technical Discussions

Missing counties

API calls are only returning some of the counties in a state. For example, this call will only return 53 of the 254 counties in Texas.

 

http://api.census.gov/data/2012/acs1?get=B19101_001E&for=county:*&key=

Submitted by (@censususer2014)
4 comments

Voting

0 votes
0 up votes
0 down votes
Active

API Technical Discussions

Access Micro-data for Blocks

I'm working on a school project with 2010 Census data. Currently, we are getting tract-level data using codes from http://api.census.gov/data/2010/sf1/variables.json to get data. For example, to find the white 65-year old males in a county's tracts, we make the API call: http://api.census.gov/data/2010/sf1?key=[key]&get=PCT012I068,NAME&for=tract:*&in=state:08+county:059 However, when making the same call at a block ...more »

Submitted by (@elizabeth.duncan)
9 comments

Voting

3 votes
3 up votes
0 down votes
Active

API Technical Discussions

Education Information

Hi,

Is there any way to find out

 

How many people are Educated ?

 

How many people are schooling ?

 

How many people are Bachelors degree ?

 

How many people are graduate or proffessional degree ?

Submitted by (@lakshmiranga.pasupuleti)
1 comment

Voting

0 votes
0 up votes
0 down votes
Active

API Technical Discussions

API extension for query across hierarchy

Hi All, The API has incredible functionality for query/results within the nested US Census Bureau Geography (e.g. getting data for all the tracts in a county or all the block groups within a track). However, it does not appear to support queries that run across the same geography very well. For instance It does not appear to allow me to query the same parameter (e.g. race) in Tract A within County B and Tract C ...more »

Submitted by (@dgcatanzaro)
3 comments

Voting

1 vote
1 up votes
0 down votes
Active

API Technical Discussions

Data Types

would like api access for my developer to obtain historical census data. I know Ancestry has access. But mot sure of this relationship. How can I determine what data and what years are available in digital format?

Submitted by (@george.j.constance)
2 comments

Voting

0 votes
0 up votes
0 down votes
Active

API Technical Discussions

Retrieve Data For Specific Params via API

Hello,

is possible to get data via API for

Exports of Goods and Services, Balance of Payments Basis

Imports of Goods and Services: Balance of Payments Basis

U.S. International Trade in Goods and Services

 

Thanks

Submitted by
Add your comment

Voting

1 vote
1 up votes
0 down votes
Active