Depending on the type of API request you use, the microdata API provides results for untabulated records or custom statistics:
For example, this API query provides the raw data for sex, disability status, and person statistical weight for people without health insurance in Maryland, Virginia, and the District of Columbia: api.census.gov/data/2019/acs/acs1/pums?get=SEX,DIS,PWGTP&HICOV=2&for=state:11,24,51. Step-by-step instructions on how to create this API query are covered later in this guide, but for now, let’s focus on the results of the data request.
The results show 8,589 records. Each record represents a single person and shows their sex, disability status, statistical weight, health insurance status, and state of residence. For example, you can see the first record of the API query in Figure 2 represents a single person whose characteristics include:
In your tabulate API queries, you will need to specify whether you want variables to appear in rows &row+ or columns &col+, and you will often want to include a statistical weight in your query.
For example, this API query provides results for sex by disability status for the population without health insurance in DC, MD, and VA: api.census.gov/data/2019/acs/acs1/pums?tabulate=weight(PWGTP)&col+for&row+SEX&row+DIS&HICOV=2&for=state:11,24,51. Step-by-step instructions on how to create this API query are covered later in this guide, but for now, let’s focus on the results of the data request.
The results provide a custom table. Each estimate from this table is a weighted tabulation that has been aggregated to represent the population without health insurance (HICOV=2) in each of the three states. From the first row of data in Figure 3, you can see in 2019 there were an estimated:
The next row of data in Figure 3 shows these same statistics for women (SEX=2). The third and fourth rows of data show the same information that the first two rows do, except that they represent people without a disability (DIS=2).
You can obtain these same results through Microdata Access on data.census.gov/mdat. The data from the API query are shown below, and the tool also calculates totals.