(@jason.venable)

Bugs / Problems

Very Slow Response Times

Since about mid day yesterday I started to see very slow response times. Even selecting one variable is taking approximately 10 seconds. Requesting 50 is take minutes and sometime the server returns an an error: There was an error while running your query. We've logged the error and we'll correct it ASAP. Sorry for the inconvenience. This is a bit hard to test as there appears to be server side caching so if you... more »

Voting

0 votes
0 up votes
0 down votes
(@jason.venable)

Using Data

Difference between Data Profile and Summary File API?

What is the difference between the Data Profile data and the Summary file data. It seems very similar, with some overlap, but also slightly different, and I don't understand the relationship between the two. Is the Summary File information used to create the Data Profiles? Are these two totally different surveys with different metrics? It's not clear to me when I should use the Summary File vs Data Profile. I've leaned... more »

Voting

0 votes
0 up votes
0 down votes
(@jason.venable)

Bugs / Problems

Data Profile API Incorrect for DP02_0024PE

The ACS 5 Year API is returning incorrect data for the DP02_0024PE variable. It should be returning a percent value but it is returning a sum.

 

Should be %:

http://api.census.gov/data/2013/acs5/profile?get=NAME,DP02_0024PE&for=state:01

 

It is returning same as this:

http://api.census.gov/data/2013/acs5/profile?get=NAME,DP02_0024E&for=state:01

Voting

0 votes
0 up votes
0 down votes
(@dave00)

Using Data

ACS 2011 1 Year

Is there a specific reason that 2011 1 year data is only available by Congressional District? I've been asked by one of our business analysts, and wanted to provide an accurate answer.

 

Thanks in advance for any insight!

Voting

0 votes
0 up votes
0 down votes

Using Data

Trouble getting daytime population

Hi everyone, I'm trying to calculate the daytime population at the block level and/or the block group level. It's noted here (https://www.census.gov/hhes/commuting/data/calculations.html) that we can query the API and get the code "B08604 Total Workers for Workplace Geography." However, this code returns the "null" value in various data sets (including ACS 5-year) at the block-group and block level. It seems like... more »

Voting

0 votes
0 up votes
0 down votes
(@karl.nicholas)

Using Data

Merging Table Lookup and Shell Files

In order to get the proper titles for variables/cells in the data I needed to write a program to merge two Excel files. The two files are Sequence_Number_and_Table_Number_Lookup.xls and ACS2012_5-Year_TableShells.xls. The first one contains the sequence and line numbers so that I can get the values from the data-tables. The second one has indents in the cell titles so I know how to combine them to create a proper cell... more »

Voting

0 votes
0 up votes
0 down votes
(@karl.nicholas)

Feature Requests

Add GET parameter for tables

There is a limit of 50 variables in a GET. So, I can understand, sort of, the need to limit, but many of your tables have more than 50 cells. For example: [ACSSF, B04001, 0006, , 7, 109 CELLS, , FIRST ANCESTRY REPORTED, Ancestry], has 109 cells, and if I want to get Estimates plus Margin of Errors I need to get 218 variables. So, why not accept a table number parameter instead? It would make the calls much easier and... more »

Voting

4 votes
4 up votes
0 down votes

Bugs / Problems

Can't get an API Key

Hi,

I've tried for several days to request an API key from the census developers site with no success. I have filled out the form trying a couple different email addresses and have not received any additional information. I've checked my spam folder in each of the email accounts and no results there either. What is my next step to get an api key?

Voting

0 votes
0 up votes
0 down votes
(@karl.nicholas)

Using Data

List of all Legislature District "names"

I need a list of all the states' legislature's district names. I will use this list as the definitive list of district names that data is mapped to. I tried to use the " Census Name Lookup Tables" found here: https://www.census.gov/geo/maps-data/data/nlt.html but there are many district names that don't map properly to the district names returned by the 2012-5yr-ACS API. So, for example, if I submit the query: http://api.census.gov/data/2012/acs5?get=B19301_001E&for=state+legislative+district+(lower+chamber):*&in=state:50... more »

Voting

0 votes
0 up votes
0 down votes

Using Data

Age and Income Data by Household

Hi, I am attempting to examine households within a given geography, and would like to count the number of households which fill certain income and age constraints. For example: Household contains person age 12 Household income between $50k and $60k Is this possible using the ACS 3-year tables? When I load a generic tabulation, I know the fields exist (age, income, location) but I cannot get the conditional results (%... more »

Voting

0 votes
0 up votes
0 down votes

API Technical Discussions

Definitions

Hello All, Is there a way to return the label and or concept instead of just the call variable code e.g. Return both DP02_0001E and "HOUSEHOLDS BY TYPE!!Total households" so that the data is easily presented without further manipulation in the application. For example this would be useful in presenting the data in a table, where the table heading would be "HOUSEHOLDS BY TYPE!!Total households" instead of the more... more »

Voting

0 votes
0 up votes
0 down votes