Demographic Essentials - United States

Retail

Summary

Essential demographics for block group and higher geography covering population and household characteristics, labor force, income, and housing for the current year and five year projections.

This is a sample visualization of a small subset of this data product.
Loading...
Charts of Demographic Essentials - United States

Key Features

  • Nationwide block group coverage for the United States
  • Population characteristics (including age, sex, race, educational attainment, marital status)
  • Household characteristics (size of household, age of head of household, language, vehicles available)
  • Income
  • Dwelling characteristics (tenure, age and type of dwelling)
  • Labor force (employment status, industry, occupation, class of worker, commuting)
  • Non-Resident population summary

Documentation

Applications

  • A core set of current year demographics is the backbone for most geospatial analysis
  • Retail site location and retail network optimization
  • Demand analysis
  • Urban planning and economic development

Overview

Version: Release 2020B

Estimates for July 1, 2020

Purpose

The Estimates and Projections database (E&P) is the core data offering of AGS, covering the essentials of demographics including population, household, dwelling, labor force, and income statistics. Most analytical applications require at the very least a sampling of this core data in conjunction with more specialized datasets that AGS offers.

Data Product Content

The Estimates and Projections (E&P) database is the most extensive update available, covering a broad range of demographic characteristics for the current year, and 5-year projections. Variables include:

Population

  • Population by household type (family, non-family)
  • Population by group quarters type (institutional, non-institutional)
  • Population by age (19 age breaks)
  • Population by age and sex (38 breaks)
  • Population by sex
  • Population by race
  • Population by Hispanic origin
  • Population by race and Hispanic origin (e.g. white Hispanic, white non-Hispanic)
  • Population by Marital Status
  • Population by Educational Achievement

Households

  • Households by type (family, non-family)
  • Households by size of household
  • Households by age of head of household
  • Household type (e.g. lone parent male family with children)
  • Average Household Size
  • Length of Residence
  • Total Vehicles Available
  • Households by number of vehicles available
  • Households by number of vehicles available and tenure

Labor Force

  • Employment Status
  • Employment Status by sex

Income

  • Aggregate Income (family, non-family households, group quarters)
  • Household income distribution (15 breaks)
  • Family income distribution (15 breaks)
  • Extended Upper-Income distributions
  • Median and average income (family, household)
  • Age of head of household by income
  • Median income by age of head of household

Dwellings

  • Vacant Dwellings
  • Tenure

Expanded Estimates

Using the American Community Survey's (ACS) most recent 1-year and 5-year databases as input, AGS has updated many of the ACS derived tables from 2010 to the current year, primarily by balancing the most recently available 5-year ACS numbers to current block group estimates, using the 1-year ACS and higher order geography as controls. This provides updates to a wide range of important demographic tables, including –

  • School enrollment (private and public, by sex, by grade level)
  • Veteran status (by period of service and by age/sex)
  • Language spoken at home and linguistic isolation (the inability of household members to converse in English)
  • Employment by Occupation (by sex)
  • Employment by Industry (by sex)
  • Class of Worker (private, public, etc.)
  • Time leaving for work
  • Travel time to work
  • Means of transportation to work
  • Income by type of income (wage, social security, etc.)
  • Value of Owner Occupied Housing
  • Cash Rent
  • Units in Structure
  • Year structure built
  • Expanded race by origin details (e.g. Native Hawaiian, Samoan, Guamanian, Other Pacific Islanders)
  • Hispanic/Latino Origin by Nationality (e.g. Costa Rican)
  • Detailed Ancestry (e.g. Albanian, Welsh)

These variables are essentially for 2018, with minor updates to 2020. With many variables, such as housing values, the actual data is quite volatile and it must be understood that these are not current estimates as much as actual 2018 balanced to 2020 using simple methods. That said, these tables provide a valuable addition to our current estimates dataset. They are not projected to 2025.

Methodology

The estimates and projections methodology combines the best current and projected information from a wide range of data sources. It is supplemented by the extensive experience of Applied Geographic Solutions in creating accurate and reliable estimates and projections. A summary of the methodology for each of the major variable groups is included in the sections that follow.

Population

The current population of the United States is obtained from the Census population estimate. This is a very accurate and current estimate of the population down to the county level and serves as the basis for projection and estimation at lower levels of geographic detail. The five-year projections have been derived from the National Projections of the Census Bureau.

The current year estimates also rely heavily on the 2010 Census block level population counts, as these provide the most accurate recent data available. The 2010 Census counts provide a baseline for the estimates and projections, and the current year estimates also rely on USPS delivery counts and Zip+4 locations to help track population growth and new housing developments.

State and county level estimates are based on the compilation of data from a range of Federal and State authorities, including the latest county population estimates from the Census Bureau, the American Community Survey (ACS), the current population survey (CPS), and additional local sources. Where required, the resulting estimates are then ratio-adjusted so that the sum of the county estimates is equal to the state total, and the state estimates equal to the national total. For the five-year projections, a similar method is employed.

At the block group level, the population model consists of the application of a non-linear trend and cohort-survival models which estimates population given historical patterns, the latest Census age distributions and projections of fertility, mortality and international migration rates. The final results are then carefully balanced to the county and population estimates to ensure consistency with current Census Bureau estimates.

The result is a comprehensive set of population estimates and projections which includes the knowledge of State, County, and private agencies about their detailed areas but also ensures that the total population is consistent with the Census Bureau estimates, which have proved extremely reliable over time.

Population by Age, Sex, and Race

National and State level Census bureau projections of age by sex and race/Hispanic origin were used as overall controls to ensure consistency with the Census projections. Detailed forecasts by age, sex, and race, as well as Hispanic origin, were obtained from the Census Bureau National Projections.

At the state level, the projections of individual state agencies and ACS estimates were combined with the results of a cohort survival approach to obtain reliable state estimates by age and sex. The block group estimates were compiled using cohort survival methods, then balanced to both the estimated block group population totals and to the state level control totals. Consistency checks with the annual CPS (Current Population Survey) are used to ensure the validity of the resulting age/sex distributions

Trends in the racial distribution and Hispanic populations were used to derive preliminary estimates at the block group level, which were then adjusted to balance with appropriate control totals. This method allows the utilization of the historical changes in race and Hispanic origin distributions and projects those changes into the future while maintaining consistency with national level projections. Again, the CPS is used extensively to assist in the verification of the models.

Households and Household Type

Total households were modeled by:

  • projecting trends in the population per household over time at the national level to provide a control total;
  • reviewing currently available household size statistics at the State level; and utilizing the current estimates of population by age and sex to determine household formation rates for small areas

Current and historical USPS and Zip+4 data were employed to help determine block groups with significant changes to the number of households since the 2010 Census. ACS data has been used in order to bridge the gap between population estimates and dwelling/postal delivery counts.

All household based numbers are initially estimated / projected separately for family and non-family households. Non-family households have been growing in number at a higher rate than family households have over the past several decades. Average household sizes for family households have been decreasing for several decades. However, during the 1990's, the decline has stopped in most areas and has actually reversed in several states.

The group quarters population, that is population that is not in households (such as persons in institutions, military barracks, nursing homes, college dormitories, and homeless persons), is expected to increase slightly during the decade, but remain relatively constant as a percentage of the total population. This is a reflection of two trends: the decreasing armed forces employment since the 1980's and the longer term increasing elderly population which results in high populations in nursing homes and other institutions which cater to the elderly population. As a result, the total group quarters population has been relatively constant.

Income

Income estimates include aggregate income by household type and income distributions as well as derived measures include per capita income, and various median income measures.

All income estimates produced by Applied Geographic Solutions are in current, rather than constant, dollars. In other words, an estimate of income for the year 2018 includes both an inflationary component and a "real" component, the latter being the difference between the change in income and the change in inflation during the period. The "real" component is normally attributed to productivity gains in the economy and to differences in the international competitiveness of the economy.

Aggregate income estimates for the current year are based on an analysis of income information from the previous ACS releases and by considering various macro-economic statistical data from the Department of Commerce and the Federal Reserve. The projections of aggregate income are based in part on a review of national Bureau of Economic Analysis (BEA) projections combined with historical analyses of the factors affecting comparative income growth at the block group and higher geography levels.

Income distributions are estimated and projected for both family households and non-family households separately. Total household income distributions are simply the aggregate of the two detailed distributions.

Income distributions were derived by using a complex distribution shifting technique which utilizes the changes in per family household and non-family household incomes as a means of adjusting the income distributions over time. The relative ratio between changes in per household average incomes and median incomes were used to adjust for above-average growth in high-income households within some geographic areas. The resulting distributions were then normalized to higher order totals and adjusted to national level expectations and were verified for internal consistency with respect to the mean and median measures.

Other Variables

A number of other variables are also projected within the series. In large part, these are derived by using available current estimates and projections at the lowest possible level of geography as the base for the estimation procedures, relying heavily upon the annual release of the ACS. The CPS is used extensively to track changes using available cross-reference information related to age, race, sex, and income.

For example, current marital status estimates are available at the state level ACS from the Census Bureau as "control targets". The ACS is used in conjunction with the annual CPS surveys (both historical and current) are used to track the changes in marital status dependent upon other symptomatic variables such as age, sex, race, and income levels. These "micro-models" are then applied to the block group level changes between the census and the current period. This results in block group level data which is consistent with higher order levels but also reflects changes in marital status owing to shifting local demography.

On the other hand, vacant housing is tracked using state and regional indicators, then adjusted for seasonally vacant dwellings which are a significant component of the marketing landscape in many areas of the country.

2010 Census Special Note

The Census and American Community Survey Integration

Historically, the Census Bureau has used a two form approach to taking the census. The majority of households would fill out the "short" form, which included questions on the age, race, and sex of the household members, as well as the relationships between them. One in seven households would receive the long form, which included many questions related to income, education, occupation, and housing characteristics.

The 2010 Census, as most are aware, did not include a long form and as a result, the data available from the Census itself is highly limited. For those familiar with the historical releases, there was no SF3 (long form) release, only the SF1 (short form) and the special group quarters population tabulations.

The replacement for the Census long form, known as the American Community Survey (ACS), has been underway for several years. Over the past decade, the ACS has been steadily improving, as the geographic coverage and detail level (e.g. from state to county to block group) has become more complete.

We extracted a number of tables from the 2018 American Community Survey releases to make use of two separate series. The "one year" tables cover 2018 for the nation, states and the largest counties and metropolitan areas. The "five-year" tables are for 2014 – 2018 and are released at the block group level and higher.

Data Sources

AGS uses a wide range of data sources in constructing its estimates and projections, including:

  • Census tabulations from the 2010 Census
  • USPS and commercial source ZIP+4 level delivery statistics
  • The Census Bureau's American Community Survey results at the national, state, county, tract and block group levels, which are based upon one year samples from 2018 and a five year rolling sample from 2014-2018.
  • Census Bureau estimates and projections of population characteristics at various levels of geographic detail, including the latest estimates of population at the county level.
  • The Census Bureau's Current Population Survey, which provides detailed demographic breakdowns and enables a thorough longitudinal analysis of demographic trends.
  • The Census Bureau's National Projections database which provides nationwide rates regarding fertility, mortality and migration rates by race which is critical to project the growth of different ethnic populations.
  • The Census Bureau's Annual Estimate of Housing Units data
  • National Center for Education Statistics data on college populations

Dictionary

Filter
Column
Title
Data Type
Description
blockgroupBLOCKGROUPTextBlock Group (FIPS)
countyCOUNTYTextCounty Code (FIPS)
countynameCOUNTYNAMETextCounty Name
stateSTATETextState Code (FIPS)
statenameSTATENAMETextState Name
placePLACETextPlace Code (FIPS)
placenamePLACENAMETextPlace Name
areaAREAFloatArea (Sq Miles)
latitudeLATITUDEFloatLatitude
longitudeLONGITUDEFloatLongitude
cbsaCBSATextCBSA (County Based Statistical Area)
cbsanameCBSANAMETextCBSA Name
pop10POP10IntPopulation 2010 Census
hhd10HHD10IntHouseholds 2010 Census
hou10totalHOU10TOTALIntDwellings 2010 Census
popcyPOPCYIntPopulation
popcyfamPOPCYFAMIntPopulation in Family Households
popcygrpPOPCYGRPIntPopulation in Group Quarters
grpcycollGRPCYCOLLIntGroup Quarters: College Housing
grpcymilGRPCYMILIntGroup Quarters: Military Barracks
grpcyothnGRPCYOTHNIntGroup Quarters: Other Non-Institutional
popcynfmPOPCYNFMIntPopulation in Non-Family Households
popcygrpniPOPCYGRPNIIntNon-Institutional Group Quarters Population
popcygrpiPOPCYGRPIIntInstitutional Group Quarters Population
agecy0004AGECY0004IntPopulation age 0-4
agecy0509AGECY0509IntPopulation age 5-9
agecy1014AGECY1014IntPopulation age 10-14
agecy1519AGECY1519IntPopulation age 15-19
agecy2024AGECY2024IntPopulation age 20-24
agecy2529AGECY2529IntPopulation age 25-29
agecy3034AGECY3034IntPopulation age 30-34
agecy3539AGECY3539IntPopulation age 35-39
agecy4044AGECY4044IntPopulation age 40-44
agecy4549AGECY4549IntPopulation age 45-49
agecy5054AGECY5054IntPopulation age 50-54
agecy5559AGECY5559IntPopulation age 55-59
agecy6064AGECY6064IntPopulation age 60-64
agecy6569AGECY6569IntPopulation age 65-69
agecy7074AGECY7074IntPopulation age 70-74
agecy7579AGECY7579IntPopulation age 75-79
agecy8084AGECY8084IntPopulation age 80-84
agecygt85AGECYGT85IntPopulation age 85+
agecymedAGECYMEDFloatMedian Age
sexcymalSEXCYMALIntPopulation male
sexcyfemSEXCYFEMIntPopulation female
raccywhiteRACCYWHITEIntPopulation white
raccyblackRACCYBLACKIntPopulation black
raccyamindRACCYAMINDIntPopulation Am In/AK Nat
raccyasianRACCYASIANIntPopulation Asian
raccyhawaiRACCYHAWAIIntPopulation Hawaiian/PI
raccyotherRACCYOTHERIntPopulation other race
raccymultRACCYMULTIntPopulation multirace
hiscyhispHISCYHISPIntPopulation Hispanic
hiscynonhHISCYNONHIntPopulation Non-Hispanic
rchcywhnhsRCHCYWHNHSIntNon Hispanic White
rchcyblnhsRCHCYBLNHSIntNon Hispanic Black
rchcyamnhsRCHCYAMNHSIntNon Hispanic American Indian
rchcyasnhsRCHCYASNHSIntNon Hispanic Asian
rchcyhanhsRCHCYHANHSIntNon Hispanic Hawaiian/Pacific Islander
rchcyotnhsRCHCYOTNHSIntNon Hispanic Other Race
rchcymunhsRCHCYMUNHSIntNon Hispanic Multiple Race
rchcywhhisRCHCYWHHISIntHispanic White
rchcyblhisRCHCYBLHISIntHispanic Black
rchcyamhisRCHCYAMHISIntHispanic American Indian
rchcyashisRCHCYASHISIntHispanic Asian
rchcyhahisRCHCYHAHISIntHispanic Hawaiian/Pacific Islander
rchcyothisRCHCYOTHISIntHispanic Other Race
rchcymuhisRCHCYMUHISIntHispanic Multiple Race
marcyneverMARCYNEVERIntNever Married
marcymarrMARCYMARRIntNow Married
marcysepMARCYSEPIntSeparated
marcywidowMARCYWIDOWIntWidowed
marcydivorMARCYDIVORIntDivorced
agecygt15AGECYGT15IntPopulation Age 15+
educyltgr9EDUCYLTGR9IntPop 25+ less than 9th grade
educyshschEDUCYSHSCHIntPop 25+ 9th-12th grade no diploma
educyhschEDUCYHSCHIntPop 25+ HS graduate
educyscollEDUCYSCOLLIntPop 25+ college no diploma
educyassocEDUCYASSOCIntPop 25+ Associate degree
educybachEDUCYBACHIntPop 25+ Bachelor's degree
educygradEDUCYGRADIntPop 25+ graduate or prof school degree
agecygt25AGECYGT25IntPopulation Age 25+
hhdcyHHDCYIntHouseholds
hhdcyfamHHDCYFAMIntFamily Households
hhdcynfmHHDCYNFMIntNon-Family Households
hhscymcfchHHSCYMCFCHIntFamilies married couple w children
hhscylpmchHHSCYLPMCHIntFamilies male no wife w children
hhscylpfchHHSCYLPFCHIntFamilies female no husband children
hhscymcfncHHSCYMCFNCIntFamilies married couple no children
hhscylpmncHHSCYLPMNCIntFamilies male no wife no children
hhscylpfncHHSCYLPFNCIntFamilies female no husband no children
hhdcys1HHDCYS1IntHouseholds 1-person
hhdcys2HHDCYS2IntHouseholds 2-persons
hhdcys3HHDCYS3IntHouseholds 3-persons
hhdcys4HHDCYS4IntHouseholds 4-persons
hhdcys5HHDCYS5IntHouseholds 5-persons
hhdcys6HHDCYS6IntHouseholds 6-persons
hhdcys7HHDCYS7IntHouseholds 7+ persons
hhdcyaveszHHDCYAVESZFloatAverage Household Size
famcyaveszFAMCYAVESZFloatAverage Family Size
hagcy1524HAGCY1524IntHouseholds householder 15-24 yrs
hagcy2534HAGCY2534IntHouseholds householder 25-34 yrs
hagcy3544HAGCY3544IntHouseholds householder 35-44 yrs
hagcy4554HAGCY4554IntHouseholds householder 45-54 yrs
hagcy5564HAGCY5564IntHouseholds householder 55-64 yrs
hagcy6574HAGCY6574IntHouseholds householder 65-74 yrs
hagcy7584HAGCY7584IntHouseholds householder 75-84 yrs
hagcygt85HAGCYGT85IntHouseholds householder 85+ yrs
hhdcymedagHHDCYMEDAGFloatMedian Age of Householder
vphcynoneVPHCYNONEIntHouseholds: No Vehicle Available
vphcy1VPHCY1IntHouseholds: One Vehicle Available
vphcygt1VPHCYGT1IntHouseholds: Two or More Vehicles Available
inccypcapINCCYPCAPIntPer capita income
inccyavehhINCCYAVEHHIntAverage household Income
inccyavefaINCCYAVEFAIntAverage family income
inccymedhhINCCYMEDHHIntMedian household income
inccymedfaINCCYMEDFAIntMedian family income
hincylt10HINCYLT10IntHousehold Income < $10000
hincy1015HINCY1015IntHousehold Income $10000-$14999
hincy1520HINCY1520IntHousehold Income $15000-$19999
hincy2025HINCY2025IntHousehold Income $20000-$24999
hincy2530HINCY2530IntHousehold Income $25000-$29999
hincy3035HINCY3035IntHousehold Income $30000-$34999
hincy3540HINCY3540IntHousehold Income $35000-$39999
hincy4045HINCY4045IntHousehold Income $40000-$44999
hincy4550HINCY4550IntHousehold Income $45000-$49999
hincy5060HINCY5060IntHousehold Income $50000-$59999
hincy6075HINCY6075IntHousehold Income $60000-$74999
hincy75100HINCY75100IntHousehold Income $75000-$99999
hincy10025HINCY10025IntHousehold Income $100000-$124999
hincy12550HINCY12550IntHousehold Income $125000-$149999
hincy15020HINCY15020IntHousehold Income $150000-$199999
hincygt200HINCYGT200IntHousehold Income > $200000
lbfcypop16LBFCYPOP16IntPopulation Age 16+
lbfcyarmLBFCYARMIntPop 16+ in Armed Forces
lbfcyemplLBFCYEMPLIntPop 16+ civilian employed
lbfcyunemLBFCYUNEMIntPop 16+ civilian unemployed
lbfcynlfLBFCYNLFIntPop 16+ not in labor force
unecyrateUNECYRATEFloatUnemployment Rate
lbfcylbfLBFCYLBFIntPopulation In Labor Force
lniexenglLNIEXENGLIntHousehold Language: English
lniexspnisLNIEXSPNISIntHousehold Language: Spanish Linguistically isolated
lniexspnnLNIEXSPNNIntHousehold Language: Spanish Not Linguistically isolated
lniexieuisLNIEXIEUISIntHousehold Language: Other Indo-EuropeanLinguistically isolated
lniexiuenLNIEXIUENIntHousehold Language: Other Indo-European Not Linguistically isolated
lniexasnisLNIEXASNISIntHousehold Language: Asian and Pacific IslandLinguistically isolated
lniexasnnLNIEXASNNIntHousehold Language: Asian and Pacific Island Not Linguistically isolated
lniexothinLNIEXOTHINIntHousehold Language: OtherLinguistically isolated
lniexothnLNIEXOTHNIntHousehold Language: Other Not Linguistically isolated
occexmgmtOCCEXMGMTIntOccupation: Management occupations
occexbusfOCCEXBUSFIntOccupation: Business and financial operations occupations
occexcompOCCEXCOMPIntOccupation: Computer and mathematical occupations
occexarchOCCEXARCHIntOccupation: Architecture and engineering occupations
occexsciOCCEXSCIIntOccupation: Life, physical, and social science occupations
occexcommOCCEXCOMMIntOccupation: Community and social service occupations
occexlegOCCEXLEGIntOccupation: Legal occupations
occexeducOCCEXEDUCIntOccupation: Education, training, and library occupations
occexartsOCCEXARTSIntOccupation: Arts, design, entertainment, sports, and media occupations
occexhlt1OCCEXHLT1IntOccupation: Health diagnosing and treating practitioners and other technical occ
occexhlt2OCCEXHLT2IntOccupation: Health technologists and technicians
occexhlt3OCCEXHLT3IntOccupation: Healthcare support occupations
occexfireOCCEXFIREIntOccupation: Fire fighting and prevention, and other protective service workers i
occexcopsOCCEXCOPSIntOccupation: Law enforcement workers including supervisors
occexfprpOCCEXFPRPIntOccupation: Food preparation and serving related occupations
occexclngOCCEXCLNGIntOccupation: Building and grounds cleaning and maintenance occupations
occexpcarOCCEXPCARIntOccupation: Personal care and service occupations
occexsaleOCCEXSALEIntOccupation: Sales and related occupations
occexoffOCCEXOFFIntOccupation: Office and administrative support occupations
occexfarmOCCEXFARMIntOccupation: Farming, fishing, and forestry occupations
occexcnexOCCEXCNEXIntOccupation: Construction and extraction occupations
occexinstOCCEXINSTIntOccupation: Installation, maintenance, and repair occupations
occexprodOCCEXPRODIntOccupation: Production occupations
occextranOCCEXTRANIntOccupation: Transportation occupations
occexmatmOCCEXMATMIntOccupation: Material moving occupations
indexagriINDEXAGRIIntIndustry: Agriculture, forestry, fishing and hunting
indexmineINDEXMINEIntIndustry: Mining, quarrying, and oil and gas extraction
indexconsINDEXCONSIntIndustry: Construction
indexmmfgINDEXMMFGIntIndustry: Manufacturing
indexwtraINDEXWTRAIntIndustry: Wholesale trade
indexrtraINDEXRTRAIntIndustry: Retail trade
indextranINDEXTRANIntIndustry: Transportation and warehousing
indexutilINDEXUTILIntIndustry: Utilities
indexinfoINDEXINFOIntIndustry: Information
indexfinINDEXFINIntIndustry: Finance and insurance
indexrealINDEXREALIntIndustry: Real estate and rental and leasing
indexpsrvINDEXPSRVIntIndustry: Professional, scientific, and technical services
indexmgmtINDEXMGMTIntIndustry: Management of companies and enterprises
indexadsINDEXADSIntIndustry: Administrative and support and waste management services
indexeducINDEXEDUCIntIndustry: Educational services
indexhlthINDEXHLTHIntIndustry: Health care and social assistance
indexartsINDEXARTSIntIndustry: Arts, entertainment, and recreation
indexfoodINDEXFOODIntIndustry: Accommodation and food services
indexothrINDEXOTHRIntIndustry: Other services, except public administration
indexpubaINDEXPUBAIntIndustry: Public administration
clwexprvCLWEXPRVIntClass of Worker: Employee of private company wrkrs
clwexslfCLWEXSLFIntClass of Worker: Self-Empl in own incorporated business wrkrs
clwexnpfCLWEXNPFIntClass of Worker: Private not-for-profit wage and salary wrkrs
clwexlgvCLWEXLGVIntClass of Worker: Local government wrkrs
clwexsgvCLWEXSGVIntClass of Worker: State government wrkrs
clwexfgvCLWEXFGVIntClass of Worker: Federal government wrkrs
clwexslfxCLWEXSLFXIntClass of Worker: Self-Empl in own not incorporated business wrkrs
clwexunpCLWEXUNPIntClass of Worker: Unpaid family wrkrs
tvwexlt5TVWEXLT5IntTravel Time to Work: Less than 5 minutes
tvwex0509TVWEX0509IntTravel Time to Work: 5 to 9 minutes
tvwex1014TVWEX1014IntTravel Time to Work: 10 to 14 minutes
tvwex1519TVWEX1519IntTravel Time to Work: 15 to 19 minutes
tvwex2024TVWEX2024IntTravel Time to Work: 20 to 24 minutes
tvwex2529TVWEX2529IntTravel Time to Work: 25 to 29 minutes
tvwex3034TVWEX3034IntTravel Time to Work: 30 to 34 minutes
tvwex3539TVWEX3539IntTravel Time to Work: 35 to 39 minutes
tvwex4044TVWEX4044IntTravel Time to Work: 40 to 44 minutes
tvwex4559TVWEX4559IntTravel Time to Work: 45 to 59 minutes
tvwex6089TVWEX6089IntTravel Time to Work: 60 to 89 minutes
tvwexgt90TVWEXGT90IntTravel Time to Work: 90 or more minutes
tvwexmedTVWEXMEDFloatMedian Travel Time to Work
tlwext01TLWEXT01IntTime Leaving for Work: 12:00 a.m. to 4:59 a.m.
tlwext02TLWEXT02IntTime Leaving for Work: 5:00 a.m. to 5:29 a.m.
tlwext03TLWEXT03IntTime Leaving for Work: 5:30 a.m. to 5:59 a.m.
tlwext04TLWEXT04IntTime Leaving for Work: 6:00 a.m. to 6:29 a.m.
tlwext05TLWEXT05IntTime Leaving for Work: 6:30 a.m. to 6:59 a.m.
tlwext06TLWEXT06IntTime Leaving for Work: 7:00 a.m. to 7:29 a.m.
tlwext07TLWEXT07IntTime Leaving for Work: 7:30 a.m. to 7:59 a.m.
tlwext08TLWEXT08IntTime Leaving for Work: 8:00 a.m. to 8:29 a.m.
tlwext09TLWEXT09IntTime Leaving for Work: 8:30 a.m. to 8:59 a.m.
tlwext10TLWEXT10IntTime Leaving for Work: 9:00 a.m. to 9:59 a.m.
tlwext11TLWEXT11IntTime Leaving for Work: 10:00 a.m. to 10:59 a.m.
tlwext12TLWEXT12IntTime Leaving for Work: 11:00 a.m. to 11:59 a.m.
tlwext13TLWEXT13IntTime Leaving for Work: 12:00 p.m. to 3:59 p.m.
tlwext14TLWEXT14IntTime Leaving for Work: 4:00 p.m. to 11:59 p.m.
trwexdrv1TRWEXDRV1IntMeans of Transportation to Work: Drove alone
trwexcpol2TRWEXCPOL2IntMeans of Transportation to Work: In 2-person carpool
trwexcpol3TRWEXCPOL3IntMeans of Transportation to Work: In 3-person carpool
trwexcpol4TRWEXCPOL4IntMeans of Transportation to Work: In 4-person carpool
trwexcpol5TRWEXCPOL5IntMeans of Transportation to Work: In 5-or-6-person carpool
trwexcpol7TRWEXCPOL7IntMeans of Transportation to Work: In 7-or-more-person carpool
trwexbusTRWEXBUSIntMeans of Transportation to Work: Bus or trolley bus
trwexstcarTRWEXSTCARIntMeans of Transportation to Work: Streetcar or trolley car
trwexsubTRWEXSUBIntMeans of Transportation to Work: Subway or elevated
trwexrailTRWEXRAILIntMeans of Transportation to Work: Railroad
trwexferryTRWEXFERRYIntMeans of Transportation to Work: Ferryboat
trwextaxiTRWEXTAXIIntMeans of Transportation to Work: Taxicab
trwexmotorTRWEXMOTORIntMeans of Transportation to Work: Motorcycle
trwexbicycTRWEXBICYCIntMeans of Transportation to Work: Bicycle
trwexwalkTRWEXWALKIntMeans of Transportation to Work: Walked
trwexothrTRWEXOTHRIntMeans of Transportation to Work: Other means
trwexhomeTRWEXHOMEIntMeans of Transportation to Work: Worked at home
dwlcyDWLCYIntHousing units
dwlcyvacntDWLCYVACNTIntHousing units vacant
dwlcyrentDWLCYRENTIntOccupied units renter
dwlcyoccupDWLCYOCCUPIntHousing units occupied
dwlcyownedDWLCYOWNEDIntOccupied units owner
hooexv01HOOEXV01IntValue of Owner Occupied Housing Units: Less than $10,000
hooexv02HOOEXV02IntValue of Owner Occupied Housing Units: $10,000 to $14,999
hooexv03HOOEXV03IntValue of Owner Occupied Housing Units: $15,000 to $19,999
hooexv04HOOEXV04IntValue of Owner Occupied Housing Units: $20,000 to $24,999
hooexv05HOOEXV05IntValue of Owner Occupied Housing Units: $25,000 to $29,999
hooexv06HOOEXV06IntValue of Owner Occupied Housing Units: $30,000 to $34,999
hooexv07HOOEXV07IntValue of Owner Occupied Housing Units: $35,000 to $39,999
hooexv08HOOEXV08IntValue of Owner Occupied Housing Units: $40,000 to $49,999
hooexv09HOOEXV09IntValue of Owner Occupied Housing Units: $50,000 to $59,999
hooexv10HOOEXV10IntValue of Owner Occupied Housing Units: $60,000 to $69,999
hooexv11HOOEXV11IntValue of Owner Occupied Housing Units: $70,000 to $79,999
hooexv12HOOEXV12IntValue of Owner Occupied Housing Units: $80,000 to $89,999
hooexv13HOOEXV13IntValue of Owner Occupied Housing Units: $90,000 to $99,999
hooexv14HOOEXV14IntValue of Owner Occupied Housing Units: $100,000 to $124,999
hooexv15HOOEXV15IntValue of Owner Occupied Housing Units: $125,000 to $149,999
hooexv16HOOEXV16IntValue of Owner Occupied Housing Units: $150,000 to $174,999
hooexv17HOOEXV17IntValue of Owner Occupied Housing Units: $175,000 to $199,999
hooexv18HOOEXV18IntValue of Owner Occupied Housing Units: $200,000 to $249,999
hooexv19HOOEXV19IntValue of Owner Occupied Housing Units: $250,000 to $299,999
hooexv20HOOEXV20IntValue of Owner Occupied Housing Units: $300,000 to $399,999
hooexv21HOOEXV21IntValue of Owner Occupied Housing Units: $400,000 to $499,999
hooexv22HOOEXV22IntValue of Owner Occupied Housing Units: $500,000 to $749,999
hooexv23HOOEXV23IntValue of Owner Occupied Housing Units: $750,000 to $999,999
hooexv24HOOEXV24IntValue of Owner Occupied Housing Units: $1,000,000 to $1,499,999
hooexv25HOOEXV25IntValue of Owner Occupied Housing Units: $1,500,000 to $1,999,999
hooexv26HOOEXV26IntValue of Owner Occupied Housing Units: $2,000,000 or more
hooexmedHOOEXMEDIntMedian Value of Owner Occupied Housing Units
rntex01RNTEX01IntCash Rent: Less than $100
rntex02RNTEX02IntCash Rent: $100 to $149
rntex03RNTEX03IntCash Rent: $150 to $199
rntex04RNTEX04IntCash Rent: $200 to $249
rntex05RNTEX05IntCash Rent: $250 to $299
rntex06RNTEX06IntCash Rent: $300 to $349
rntex07RNTEX07IntCash Rent: $350 to $399
rntex08RNTEX08IntCash Rent: $400 to $449
rntex09RNTEX09IntCash Rent: $450 to $499
rntex10RNTEX10IntCash Rent: $500 to $549
rntex11RNTEX11IntCash Rent: $550 to $599
rntex12RNTEX12IntCash Rent: $600 to $649
rntex13RNTEX13IntCash Rent: $650 to $699
rntex14RNTEX14IntCash Rent: $700 to $749
rntex15RNTEX15IntCash Rent: $750 to $799
rntex16RNTEX16IntCash Rent: $800 to $899
rntex17RNTEX17IntCash Rent: $900 to $999
rntex18RNTEX18IntCash Rent: $1,000 to $1,249
rntex19RNTEX19IntCash Rent: $1,250 to $1,499
rntex20RNTEX20IntCash Rent: $1,500 to $1,999
rntex21RNTEX21IntCash Rent: $2,000 to $2,499
rntex22RNTEX22IntCash Rent: $2,500 to $2,999
rntex23RNTEX23IntCash Rent: $3,000 to $3,499
rntex24RNTEX24IntCash Rent: $3,500 or more
rntex25RNTEX25IntCash Rent: No cash rent
rntexmedRNTEXMEDIntMedian Cash Rent
husexo1detHUSEXO1DETIntUnits in Structure: Owner occupied: 1, detached
husexo1attHUSEXO1ATTIntUnits in Structure: Owner occupied: 1, attached
husexo2HUSEXO2IntUnits in Structure: Owner occupied: 2
husexo0304HUSEXO0304IntUnits in Structure: Owner occupied: 3 or 4
husexo0509HUSEXO0509IntUnits in Structure: Owner occupied: 5 to 9
husexo1019HUSEXO1019IntUnits in Structure: Owner occupied: 10 to 19
husexo2049HUSEXO2049IntUnits in Structure: Owner occupied: 20 to 49
husexogt50HUSEXOGT50IntUnits in Structure: Owner occupied: 50 or more
husexomobHUSEXOMOBIntUnits in Structure: Owner occupied: Mobile home
husexoboatHUSEXOBOATIntUnits in Structure: Owner occupied: Boat, RV, van, etc.
husexr1detHUSEXR1DETIntUnits in Structure: Renter occupied: 1, detached
husexr1attHUSEXR1ATTIntUnits in Structure: Renter occupied: 1, attached
husexr2HUSEXR2IntUnits in Structure: Renter occupied: 2
husexr0304HUSEXR0304IntUnits in Structure: Renter occupied: 3 or 4
husexr0509HUSEXR0509IntUnits in Structure: Renter occupied: 5 to 9
husexr1019HUSEXR1019IntUnits in Structure: Renter occupied: 10 to 19
husexr2049HUSEXR2049IntUnits in Structure: Renter occupied: 20 to 49
husexrgt50HUSEXRGT50IntUnits in Structure: Renter occupied: 50 or more
husexrmobHUSEXRMOBIntUnits in Structure: Renter occupied: Mobile home
husexrboatHUSEXRBOATIntUnits in Structure: Renter occupied: Boat, RV, van, etc.
ybtex14upYBTEX14UPIntYear Structure Built: Built 2014 or later
ybtex1013YBTEX1013IntYear Structure Built: Built 2010 to 2013
ybtex0009YBTEX0009IntYear Structure Built: Built 2000 to 2009
ybtex9099YBTEX9099IntYear Structure Built: Built 1990 to 1999
ybtex8089YBTEX8089IntYear Structure Built: Built 1980 to 1989
ybtex7079YBTEX7079IntYear Structure Built: Built 1970 to 1979
ybtex6069YBTEX6069IntYear Structure Built: Built 1960 to 1969
ybtex5059YBTEX5059IntYear Structure Built: Built 1950 to 1959
ybtex4049YBTEX4049IntYear Structure Built: Built 1940 to 1949
ybtex39prYBTEX39PRIntYear Structure Built: Built 1939 or earlier
poppyPOPPYIntPopulation (2025B)
hhdpyHHDPYIntHouseholds (2025B)
dwlpyDWLPYIntHousing units (2025B)
nrplyttotNRPLYTTOTIntAverage Annual Non-Resident Population (2019)
nrplyq1totNRPLYQ1TOTIntQ1 Non-Resident Population (2019)
nrplyq2totNRPLYQ2TOTIntQ2 Non-Resident Population (2019)
nrplyq3totNRPLYQ3TOTIntQ3 Non-Resident Population (2019)
nrplyq4totNRPLYQ4TOTIntQ4 Non-Resident Population (2019)
nrpcyttotNRPCYTTOTIntAverage Annual Non-Resident Population
nrpcyq1totNRPCYQ1TOTIntQ1 Non-Resident Population
nrpcyq2totNRPCYQ2TOTIntQ2 Non-Resident Population
nrpcyq3totNRPCYQ3TOTIntQ3 Non-Resident Population
nrpcyq4totNRPCYQ4TOTIntQ4 Non-Resident Population
nrplytbusNRPLYTBUSIntAverage Annual Business Travelers (2019)
nrplyq1busNRPLYQ1BUSIntQ1 Business Travelers (2019)
nrplyq2busNRPLYQ2BUSIntQ2 Business Travelers (2019)
nrplyq3busNRPLYQ3BUSIntQ3 Business Travelers (2019)
nrplyq4busNRPLYQ4BUSIntQ4 Business Travelers (2019)
nrplytmigrNRPLYTMIGRIntAverage Annual Migrant Workers (2019)
nrplyq1migNRPLYQ1MIGIntQ1 Migrant Workers (2019)
nrplyq2migNRPLYQ2MIGIntQ2 Migrant Workers (2019)
nrplyq3migNRPLYQ3MIGIntQ3 Migrant Workers (2019)
nrplyq4migNRPLYQ4MIGIntQ4 Migrant Workers (2019)
nrplytperNRPLYTPERIntAverage Annual Leisure/Personal Travelers (2019)
nrplyq1perNRPLYQ1PERIntQ1 Leisure/Personal Travelers (2019)
nrplyq2perNRPLYQ2PERIntQ2 Leisure/Personal Travelers (2019)
nrplyq3perNRPLYQ3PERIntQ3 Leisure/Personal Travelers (2019)
nrplyq4perNRPLYQ4PERIntQ4 Leisure/Personal Travelers (2019)
nrplythtlNRPLYTHTLIntAverage Annual Non-Residents At Hotels (2019)
nrplyq1htlNRPLYQ1HTLIntQ1 Non-Residents At Hotels (2019)
nrplyq2htlNRPLYQ2HTLIntQ2 Non-Residents At Hotels (2019)
nrplyq3htlNRPLYQ3HTLIntQ3 Non-Residents At Hotels (2019)
nrplyq4htlNRPLYQ4HTLIntQ4 Non-Residents At Hotels (2019)
nrpcytbusNRPCYTBUSIntAverage Annual Business Travelers
nrpcyq1busNRPCYQ1BUSIntQ1 Business Travelers
nrpcyq2busNRPCYQ2BUSIntQ2 Business Travelers
nrpcyq3busNRPCYQ3BUSIntQ3 Business Travelers
nrpcyq4busNRPCYQ4BUSIntQ4 Business Travelers
nrpcytmigrNRPCYTMIGRIntAverage Annual Migrant Workers
nrpcyq1migNRPCYQ1MIGIntQ1 Migrant Workers
nrpcyq2migNRPCYQ2MIGIntQ2 Migrant Workers
nrpcyq3migNRPCYQ3MIGIntQ3 Migrant Workers
nrpcyq4migNRPCYQ4MIGIntQ4 Migrant Workers
nrpcytperNRPCYTPERIntAverage Annual Leisure/Personal Travelers
nrpcyq1perNRPCYQ1PERIntQ1 Leisure/Personal Travelers
nrpcyq2perNRPCYQ2PERIntQ2 Leisure/Personal Travelers
nrpcyq3perNRPCYQ3PERIntQ3 Leisure/Personal Travelers
nrpcyq4perNRPCYQ4PERIntQ4 Leisure/Personal Travelers
nrpcythtlNRPCYTHTLIntAverage Annual Non-Residents At Hotels
nrpcyq1htlNRPCYQ1HTLIntQ1 Non-Residents At Hotels
nrpcyq2htlNRPCYQ2HTLIntQ2 Non-Residents At Hotels
nrpcyq3htlNRPCYQ3HTLIntQ3 Non-Residents At Hotels
nrpcyq4htlNRPCYQ4HTLIntQ4 Non-Residents At Hotels

Sample Data

API

ALTADATA provides a powerfull API, compatible with JSON, CSV formats. You can connect, update and analyze our data products with cURL, Python, R, Ruby, Java or Javascript

Authentication

Getting an API key

You need to subscribe to an ALTADATA data product to get an API key. Once you subscribe to the data product you can find your API key on your Account Dashboard.

Auhenticating your requests

`api_key` is your access token. This token must be included on each API call with either a HTTP Header Authorization, or a query parameter api_key.

Example: https://www.altadata.io/data/api/dm_ags_01?api_key=YOUR_API_KEY

ALTADATA API Reference Table

Parameter Type Parameter Explanation Available Values Default
General size The number of records will be returned for each page. 5 - 100 20
General page The page number. It starts at 1 and increments one by one. Each page returns records that row count equals to the size parameter 1- ... 1
General format The data return format of API call json , csv json
General collapse The aggregation format of API call Examples are monthly, yearly, bystate, bycountry, etc. Refer to the data product documentation to see available aggregations for it. null
Select columns Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause. More detail is in the following sections. *
Order order_by Column order is how you specify the content of an SQL ORDER BY clause. More detail is in the following sections. null
Lookup vary by column name Column lookups are how you specify the content of an SQL WHERE clause. More detail is in the following sections. *

Select

Column select is how you specify the content of an SQL SELECT c_only, c_certain, c_columns FROM clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names. If not given, the default value is *(asterisk).

Example 1 :

Query : ?columns=C1,C2,C3 SQL Equivalent : Select C1,C2,C3 from DATA_PRODUCT

Example 2 :

Query : Not Given | ?columns= | ?columns=* SQL Equivalent : Select * from DATA_PRODUCT

Order

Column order is how you specify the content of an SQL ORDER BY clause. It specifies as a keyword argument to the query string of API Call URL. Basic usage is a comma-separated list of column names where each column name has an appropriate suffix (asc,desc) after _(underscore) or no suffix (means ascending).

Example :

Query : ?order_by=C1_asc,C2,C3_desc,C4_asc SQL Equivalent : Select * from DATA_PRODUCT order by C1 asc, C2, C4 desc, C4 asc

Order Type Suffix
Ascending null
Ascending asc
Descending desc

Lookup

Column lookups are how you specify the content of an SQL WHERE clause. They’re specifies as keyword arguments to the query string of API Call URL. Basic usage is appending _(underscore) then lookup type as a suffix to name of the column that you want to filter. The query parameter for a column is built like the format {COLUMN_NAME}_{LOOKUP_TYPE}

As a convenience when no lookup type is provided

Lookup Type Suffix Value Type Example SQL Equivalent
Equal to null String | Numeric | Datetime ?COLUMN=VALUE Select * from DATA_PRODUCT where COLUMN=VALUE
Equal to eq String | Numeric | Datetime ?COLUMN_eq=VALUE Select * from DATA_PRODUCT where COLUMN=VALUE
Not Equal to neq String | Numeric | Datetime ?COLUMN_neq=VALUE Select * from DATA_PRODUCT where COLUMN<>VALUE
Greater Than gt Numeric | Datetime ?COLUMN_gt=VALUE Select * from DATA_PRODUCT where COLUMN>VALUE
Greater Than or Equal to gte Numeric | Datetime ?COLUMN_gte=VALUE Select * from DATA_PRODUCT where COLUMN>=VALUE
Less Than lt Numeric | Datetime ?COLUMN_lt=VALUE Select * from DATA_PRODUCT where COLUMN,VALUE
Less Than or Equal to lte Numeric | Datetime ?COLUMN_lte=VALUE Select * from DATA_PRODUCT where COLUMN<=VALUE
In in String ?COLUMN_in=V1,V2,V3 Select * from DATA_PRODUCT where COLUMN in ('V1','V2','V3')
Not In notin String ?COLUMN_notin=V1,V2,V3 Select * from DATA_PRODUCT where COLUMN not in ('V1','V2','V3')

Data Access Examples

cURL
curl \ -H 'Authorization: api_key' \ 'https://www.altadata.io/data/api/dm_ags_01'
Python (requests)
response = requests.get( 'https://www.altadata.io/data/api/dm_ags_01', headers={'Authorization': 'api_key'} )
Ruby (open-uri)
require 'open-uri' response = URI.open('https://www.altadata.io/data/api/dm_ags_01', "Authorization" => "api_key" )
Java (OkHttp)
Request request = new Request.Builder() .url("https://www.altadata.io/data/api/dm_ags_01") .addHeader("Authorization", "api_key") .build(); Call call = client.newCall(request); Response response = call.execute();
Javascript (axios)
axios.request({ url: 'https://www.altadata.io/data/api/dm_ags_01', method: 'get', headers: { 'Authorization', 'api_key'} }) .then(response => { console.log(response.data) })
R ( jsonlite )
library(jsonlite) data <- fromJSON(`https://www.altadata.io/data/api/dm_ags_01`)

Frequently Asked Questions

HOW DO I SUBSCRIBE TO DATA PRODUCTS ON ALTADATA?
DO YOU PROVIDE CUSTOM DATASETS UPON REQUEST?
WHAT ARE THE DIFFERENT WAYS I CAN ACCESS MY SUBSCRIPTION DATA?
HOW CAN I QUICKLY LOOK AT WHAT IS IN THE DATA THAT I SUBSCRIBED TO?
HOW CAN I JOIN ALTADATA PARTNER NETWORK? DO YOU HAVE A LIST OF REQUIREMENTS?