An official website of the United States government
Here’s how you know
Official websites use .gov
A .gov website belongs to an official government organization in the United States.
Secure .gov websites use HTTPS
A lock (
) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.
The American Community Survey (ACS) Detailed Tables and Data Profile estimates in the Census API are being converted to be consistent in the treatment of character and numeric data. Existingly, Detailed Tables only have numeric values and are missing the character values in the API, while Data Profiles have character values in place of numeric values, where applicable. In the new format, ACS will will have both numeric and character data in the API in a consistent format for all data products.
Existing Format Data in API | |
---|---|
Data Product | Format of data in API |
Detailed Table | Numeric data |
Data Profile | Character data |
In order to make the data consistant with other surveys and datasets, ACS will be adding in special variables just for character data and moving the numeric data to the existing variables. The new character variables will have the same name as existing numeric variables but with an “A” on the end.
Note: The character data is only present in the API if character data exist and should always be used for display purposes in place of numeric data.
Example of New Format of Data Profile (DP02) in API | ||
---|---|---|
Characteristics | DP02_0001E | DP02_0001EA |
Format | Numeric | Character |
New/Existing | Existing | New |
SEX AND AGE | Estimates | Margin of Error |
---|---|---|
Total population | DP05_0001E | DP05_0001M |
Male | DP05_0002E | DP05_0002M |
Female | DP05_0003E | DP05_0003M |
https://api.census.gov/data/2015/acs1/profile?get=DP05_0001E,DP05_0002E,DP05_0003E,DP05_0001M,DP05_0002M,DP05_0003M&for=congressional+district:00&in=state:56
[["DP05_0001E","DP05_0002E","DP05_0003E","DP05_0001M","DP05_0002M","DP05_0003M","state","congressional district"],
["586107","295102","291005","*****","2375","2375","56","00"]]
SEX AND AGE | Estimates | Margin of Error |
---|---|---|
Total population | DP05_0001E (DP05_0001EA) |
DP05_0001M (DP05_0001MA) |
Male | DP05_0002E (DP05_0002EA) |
DP05_0002M (DP05_0002MA) |
Female | DP05_0003E (DP05_0003EA) |
DP05_0003M (DP05_0003MA) |
https://api.census.gov/data/2015/acs/acs1/profile?get=DP05_0001E,DP05_0002E,DP05_0003E,DP05_0001M,DP05_0002M,DP05_0003M&for=congressional+district:00&in=state:56
[["DP05_0001E","DP05_0002E","DP05_0003E","DP05_0001M","DP05_0002M","DP05_0003M","state","congressional district"],
["586107","295102","291005","-555555555","2375","2375","56","00"]]
https://api.census.gov/data/2015/acs/acs1/profile?get=DP05_0001EA,DP05_0002EA,DP05_0003EA,DP05_0001MA,DP05_0002MA,DP05_0003MA&for=congressional+district:00&in=state:56
[["DP05_0001EA","DP05_0002EA","DP05_0003EA","DP05_0001MA","DP05_0002MA","DP05_0003MA","state","congressional district"],
[null,null,null,"*****",null,null,"56","00"]]
Some content on this site is available in several different electronic formats. Some of the files may require a plug-in or additional software to view.
Top