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.
Share
On December 17, we released the following updates to the site:
*The refreshed MDAT has similar functionality to the previous version with a few noteworthy updates, described below. To learn more, check out our video tutorial and webinar on Exploring the Refreshed Microdata Access Tutorial.
o URL Migration: At the bottom of the landing page, enter URLs you saved from the previous version of MDAT and click “Go” to load the table on the refreshed MDAT site.
o Select Geographies: The Select Geographies is now a button within the variables tab. When you click the button, a pop-up window will appear that allows you to select your geographies. With the refreshed MDAT, we also added a new option to “Select All” geographies in a list in a single click.
o Cart: Changes to button icons, names, and locations.
o Table: A collapsible panel and buttons at the bottom of the table provide options to edit the table layout and download data.
o “Charts” tab located throughout the site
o “Chart” button in the table and map toolbars
o Measures: Select the primary value shown on your chart (e.g. “percent under 5 years” or “annual payroll”)
*Charts from some complex data tables also have dimensions and units options to help you precisely select the measure for your chart
o Attributes: Specify the categories your chart includes (e.g. geographies, NAICS codes, etc)
o Bar and column charts: Visualize the selected measure in horizontal or vertical bars. Includes option to sort the data in ascending, descending, or alphanumeric order.
o Line charts: Visualize the selected measure over time.
*Note: Line charts are currently supported for American Community Survey (ACS) Comparison Profiles and timeseries datasets, such as the International Trade Import and Export datasets.
o Statistical significance shown in line charts from ACS Comparison Profiles.
▪ Diamonds show the reference year for calculations of statistical comparisons.
▪ Closed circles show values that are statistically different.
▪ Open circles show values that are not statistically different.
o Color-coded legends for line charts with seven or fewer categories.
o Area chart with a slider for line charts from timeseries datasets. The area chart shows the full length of time covered, and the slider allows you to adjust the length of time shown in your line chart.
o U.S. recession periods shown with gray shading in line charts from economic datasets that provide data exclusively for U.S. geographies.
*The dates used for recession periods are based on the business cycle turning points by the National Bureau of Economic Research (NBER).
o Global attributes: Allow you to add or remove filters that may populate your chart, such as filters for geographies, NAICS codes, population group codes, and EEO occupation codes. Any global attribute selections work the same as if you had made the selections using the filter panel located throughout the site.
o Local attributes: Allows you to add or remove values that may populate your chart. These local attributes are specific to the table that was used to build your chart and do not carry over when switching to charts from different data tables.
o When you select global or local attribute check boxes:
▪ Attributes are shown as categories within your chart if you also include the attribute as a primary or secondary attribute to display in the measures drop-down menu
▪ Attributes are shown as options to limit the context that your chart represents if you do not have the attribute included as a primary/secondary attribute to display. In these instances, use the “other attributes to display” drop-down menus to switch between the different options to specify your desired context.
On December 5, we released the following update to the site:
On November 21, we released the following updates to the site:
On October 10, we released the following updates to the site:
On September 26, we released the following updates to the site:
This updates benefits users by providing data for all geographies in the collection through the ACS 5-year estimates instead of only showing data for geographies with 65,000 people or more through the ACS 1-year estimates.
Please be aware that this update applies to all collections of geographies for: counties, county subdivisions, places, metropolitan/micropolitan statistical areas, American Indian Areas/Alaska Native Areas/Hawaiian Home Lands, combined statistical areas, New England city and town areas (NECTAs), school districts, and urban areas.
o Add spacing to ensure population pyramids will not overlap age labels.
o New icon that allows you to explore the meaning of special characters.
o Removal of bar charts when all values in the chart are zero.
On September 4, we released the following updates to the site:
a) To access the download in the profile view: Click “Show Table” and then “Download Table.”
b) To access the download in the map view: Click the “Table” button at the top of the map and then scroll down to see the “Download Table” button.
On August 15, we released the following updates to the site:
On July 23 and Aug 2, we released the following updates to the site:
o View the top of the ACS table for new text that explains ACS 1-Year Estimates are only available for geographies with 65,000 people or more.
o Click the question mark icon for ACS 1-Year Estimates at the bottom of the map to see a pop-up window that explains minimum population requirements.
On June 18, we released the following updates to the site:
Click “Census Data API” or “Census API Key Signup” to get more detailed metrics and visualizations, including:
On June 4, we released the following updates to the site:
On May 23, we released the following updates to the site:
Please note:
Data Link: Provides the corresponding API call to get data for your current table view.
NOTE: When viewing tables for multiple geography or code selections, you may receive multiple API queries separated by a comma. In the example below, the first query provides the table data for the state of California and the second query provides the table data for all counties in California. These must be run as separate API queries to return data.
https://api.census.gov/data/2022/acs/acs5?get=group(B19001)&ucgid=0400000US06,https://api.census.gov/data/2022/acs/acs5?get=group(B19001)&ucgid=pseudo(0400000US06$0500000)
Metadata Link: Provides the API call to the overall dataset that is relevant to your table. This provides reference material such as lists of variables, geographies, and tables for the dataset.
The process of downloading the GeoJSON file is the same as downloading other ZIP files:
o Click the GeoJSON button to start the download
o Wait for the progress bar to load to 100%
o Open the ZIP file in your downloaded files
On March 21, we released the following updates to the site:
On February 29, we released the following updates to the site:
On February 22, we released the following updates to the site:
On Jan 18, we released the following updates to the site:
With this update, the experience is optimized for mobile devices. On desktop devices, you will now see content in portrait mode, as well as additional controls on each side to scroll through the app.
On Jan 4, we released the following updates to the site:
Geo ID = 010XX00US$0400000
Dataset = ACSDP1Y2022
Table ID = DP05
Cell ID = DP05_0004E
The purpose of this update is to make map URLs readable to external search engines such as Google, so that they can better link to data.census.gov content. Previous links to data.census.gov maps using the old URL structure will continue to function.
Top