U.S. flag

An official website of the United States government

Skip Header
VISIT DATA.CENSUS.GOV

Events
Data.census.gov outreach staff exhibit at conferences and give presentations, and provide workshops and webinars throughout the year. Learn more about our activities here.
Releases
Find out the latest updates about data.census.gov, the Census API, and the Microdata Access, including the most recent data releases and news.

How Can I Group (or Aggregate) Geographies in the Microdata Access Tool?

Skip Navigation

How Can I Group (or Aggregate) Geographies in the Microdata Access Tool?

The geography group feature allows you to get data for multiple geographies already added together for you in the Microdata Access Tool (MDAT).

For example, let’s say you are interested in getting data for Clark County, WA. In this county, there are four Public Use Microdata Areas (PUMAs) that neatly cover the county. This allows you to add up data from these four PUMAs to get data for Clark County overall.

If you would like the site to automatically add up the data for the combined area of Clark County, use the geography group functionality in MDAT following these steps:

1. Select the individual geographies that you want to group together.
For example: Geographies → PUMA → Washington → select the four PUMAs in Clark County, WA

2. Click the “Group” tab, mark the check boxes for the geographies you want to group together (i.e. the four PUMAs in Clark County), and click “Create New Group”

3. Optional: Rename the group. For example, type “Clark County” in the Selected Group Name box and click “Save Group Name”.

4. View table. Data for your geography group(s) are shown in the bottom rows or far right columns of the table.

Please be aware that just like other estimates in MDAT, the site does not have the capability to provide margins of error (MOEs) for these estimates.

Contact Us

Email us at census.data@census.gov for any questions or comments you may have.  For more guidance on data availability and using data.census.gov, the Census API, and Microdata Access, visit our Resources page.

Page Last Revised - March 24, 2025
Is this page helpful?
Thumbs Up Image Yes Thumbs Down Image No
NO THANKS
255 characters maximum 255 characters maximum reached
Thank you for your feedback.
Comments or suggestions?

Top

Back to Header