Small-Area Estimation of Spatial Access to Care and Its Implications for Policy

Abstract

Local or small-area estimates to capture emerging trends across large geographic regions are critical in identifying and addressing community-level health interventions. However, they are often unavailable due to lack of analytic capabilities in compiling and integrating extensive datasets and complementing them with the knowledge about variations in state-level health policies. This study introduces a modeling approach for small-area estimation of spatial access to pediatric primary care that is data “rich” and mathematically rigorous, integrating data and health policy in a systematic way. We illustrate the sensitivity of the model to policy decision making across large geographic regions by performing a systematic comparison of the estimates at the census tract and county levels for Georgia and California. Our results show the proposed approach is able to overcome limitations of other existing models by capturing patient and provider preferences and by incorporating possible changes in health policies. The primary finding is systematic underestimation of spatial access, and inaccurate estimates of disparities across population and across geography at the county level with respect to those at the census tract level with implications on where to focus and which type of interventions to consider.

Appendices

Appendix 1

In this appendix, additional information on data used in our optimization model is presented and the procedure applied to compute the providers’ Medicaid acceptance ratio at the county level is detailed.

Patient Data

The total number of children in the two states under consideration is approximately equal to 12.5 million, and the total number of children eligible for public insurance is equal to 6.8 million.

For the state of Georgia, the distribution of the proportion of population eligible for Medicaid/CHIP at the census tract level has a median equal to 0.60, mean equal to 0.58, and standard deviation equal to 0.23. The same distribution at the county level has a median equal to 0.66, mean equal to 0.65, and standard deviation equal to 0.18.

For the state of California, the distribution of the proportion of population eligible for Medicaid/CHIP at the census tract level has a median equal to 0.53, mean equal to 0.51, and standard deviation equal to 0.26. The same distribution at the county level has a median equal to 0.56, mean equal to 0.55, and standard deviation equal to 0.12.

The distribution of the proportion of population eligible for Medicaid/CHIP at the county and census tract levels for the two states is shown in Fig. 5.

FIG. 5

The distribution of the percentage of the population eligible for Medicaid/CHIP at the census tract level (top) and the county level (bottom) for the state of Georgia (on the left) and the state of California (on the right).

Provider Data

An NPI is assigned to entities that respect the definition of “health care provider.” The definition of health care provider includes several categories of providers such as hospitals, nursing homes, ambulatory care facilities, durable medical equipment suppliers, clinical laboratories, pharmacies, and many other “institutional” type providers; physicians, dentists, psychologists, pharmacists, nurses, chiropractors and many other health care practitioners and professionals; group practices, health maintenance organizations, and others.

Individual and institutional records are distinguished by the entity type attribute:

• Entity 1 Individual (e.g., physicians, sole proprietors)

• Entity 2 Health care providers that are not individual

Data for organizational NPIs were excluded because the dataset does not report how many providers of a particular type are represented by the organization’s listed taxonomies (each organization can list up to 15 different taxonomy codes). It is also unknown how many of the providers listed under an organization’s umbrella have their own individual NPI, raising the possibility of double-counting between individuals and organizations.

The total number of providers under consideration in the state of Georgia is approximately equal to 8000, while in the state of California it is approximately equal to 32,000.

Fifty-three percent of the providers in the state of Georgia accept Medicaid/CHIP-insured children, for a total of approximately 4200 providers; 59 % of the providers in the state of California accept Medicaid/CHIP-insured children, for a total of approximately 18,800 providers.

The network of providers in Georgia consists of 21 % pediatricians, 74 % Family Internal Medicine physicians, and 5 % Nurse Pediatrics, and in California, it consists of 21 % pediatricians, 76 % Family Internal Medicine physicians, and 3 % Nurse Pediatrics. Given our capacity assumptions, the capacity of our network of providers for children care is such that, for the state of Georgia, 63 % of the visits are provided by General Pediatricians, 22 % are provided by Family/Internal Medicine physicians, and the remaining 15 % are provided by Nurse Pediatrics. Meanwhile, the capacity of the network of providers for children care for the state of California is such that 67 % of the visits are provided by General Pediatricians, 24 % are provided by Family/Internal Medicine physicians, and the remaining 9 % are provided by Nurse Pediatrics.

The distribution of the providers in the two states under consideration is mapped in Fig. 6. In Georgia, at the county level, six counties have zero providers, and 50 % of the remaining counties have fewer than 10 providers. The average number of providers in each county is equal to 53.

When analyzing census tracts, 40 % of the census tracts (953 out of 1951) have zero providers, and 50 % of the remaining census tracts have less than 4 providers. The average number of providers in each census tract is equal to 8, and the standard deviation is equal to 17 providers.

In California, at the county level, two counties have zero providers, and 50 % of the remaining counties have less than 164 providers. The average number of providers in each county is equal to 593. At the census tract level, 54 % of the census tracts (4354 out of 7984) have zero providers, and 50 % of the remaining tracts have fewer than 4 providers. The average number of providers in each census tract is equal to 8, and the standard deviation is equal to 15 providers.

FIG. 6

Information about the provider distribution for Georgia (top) and California (bottom). On the left, boxplot of the distribution of the number of providers per 100,000 children at the census tract level and the county level are shown. On the right, histograms of the distribution of the total number of providers per 100,000 children at the census tract level and the county level are shown.

Additional Tables and Figures

FIG. 7

The distribution of the total number of census tracts per county in Georgia (left) and in California (center). The table on the right gives the summarizing statistics of the distribution for both states.

Procedure to Compute Providers’ Medicaid Acceptance Ratio at County Level

• 1. Data used

  • The Medicaid claims data: specifically the OT (other services) file and PS (personal summary) file.

  • NPI data: This data is used to locate the number of providers in each state.

  • Zip code to county code crosswalk: map from zip code to the county it resides. The crosswalk can be downloaded here: http://www.huduser.org/portal/datasets/usps_crosswalk.html.

• 2. Assumptions

  • Billing Provider ID behaves like NPI where it has a one-to-one match with the actual provider.

  • The county with the greatest number of visits from a provider is the county where the provider is located.

• 3. Procedure

  • Calculation of providers in each county.

    • Convert the zip code of the providers in the NPI data into county code using the zip code-county code crosswalk.

    • Count the number of providers in each county.

  • Calculation of providers that accept Medicaid in each county.

    • Join the OT file and PS file in the claims data to get patient’s zip code for each of the claims.

    • Covert the zip code into county code using the zip code-county code crosswalk.

    • Count the number of providers in each county that accepts Medicaid.

  • Calculation of the Medicaid acceptance ratio

    • Divide the number of providers accepting Medicaid by the total number of providers in each county.

The resulting ratios for the state of Georgia and California are provided in Table 5.

TABLE 5 The percentage of providers accepting Medicaid/CHIP patients in each county in Georgia and California computed using the MAX Medicaid claims data. Due to confidentiality issues, the percentages for counties with a number of physicians less than 11 are not reported. For these counties, a weighted average is shown (corresponding to “Other counties”)

Appendix 2: Main Steps to Compute Values of the Parameters for the Optimization Model

• 1. Summary...................................................................................................................................2

• 2. Medicaid Eligibility for Children in GA after ACA................................................................2

• 3. Data Sources............................................................................................................................3

  • PCT3: Sex by Age...................................................................................................................4

  • B17024: Age by Ratio of Income to Poverty Level in the Past 12 Months............................5

  • PCT10: Household by Presence of People under 18 by Household Type by Age of People Under 18 Years...............................................................................6

  • PCT7: Average Household Size by Age...............................................................................7

  • B19001: Household Income in the Past 12 Months (in 2012 Inflation-Adjusted Dollars)....7

  • B08201: Household Size by Vehicles Available....................................................................8

• 4. Procedure to Obtain the Desired Parameter Values..............................................................9

• 1. Summary

  This appendix explains the main steps we carried out to obtain the information needed to calculate the values of the parameters for the mathematical model described in the paper. The parameters are specified considering both CHIP and Medicaid eligibility criteria for children in Georgia and California after the Affordable Care Act (ACA). The steps are explained considering numerical examples for the state of Georgia. Similar steps were carried out when considering the state of California.

• 2. Medicaid Eligibility for Children in GA after ACA

  We defined three age classes:

  • Age class 1: children under 1 year of age (i.e., the child has not yet reached his or her first birthday)

  • Age class 2: children at least 1 year old and less than 6 years old (i.e., the child is age 1 or older, but has not yet reached his or her sixth birthday)

  • Age class 3: children at least 6 years old and no more than 19 years old (i.e., the child is age 6 or older, but has not yet reached his or her 19th birthday)

  To be eligible for Medicaid after the ACA, a child in age class 1, age class 2, and age class 3 must be living in a household with an income below 205, 149, and 133 % of the Federal Poverty Level (FPL), respectively.

  To be eligible for CHIP insurance after the ACA in the state of Georgia, a child in any age class must be living in a household with an income below 247 % of the FLP. We consider eligible for Medicaid/CHIP insurance those children that have access to either Medicaid or CHIP.

  For each census tract in Georgia, we need to compute the values of the following parameters:

  • 1. Age class 1: the total number of children in age class 1

  • 2. Age class 2: the total number of children in age class 2

  • 3. Age class 3: the total number of children in age class 3

  • 4. Total population <= 18: the total number of children who are no more than 18 years old

  • 5. Age class 1 eligible: the total number of children in age class 1 who are eligible for Medicaid (parameter p ^M _i1 in the optimization model)

  • 6. Age class 2 eligible: the total number of children in age class 2 who are eligible for Medicaid (parameter p ^M _i2 in the optimization model)

  • 7. Age class 3 eligible: the total number of children in age class 3 who are eligible for Medicaid (parameter p ^M _i3 in the optimization model)

  • 8. Total eligible population <= 18: the total number of children no more than 18 years old who are eligible for Medicaid

  • 9. mob_med: the proportion of households with at least one child less than 18 years old that have at least one vehicle and are eligible for Medicaid (parameter mob ^M _i in the optimization model)

  • 10. mob_oth: the proportion of households with at least one child less than 18 years old that have at least one vehicle and are ineligible for Medicaid (parameter mob ^O _i in the optimization model)

  Parameters p ^O _ik , k = 1, 2, 3 in the optimization model were computed as the difference between the total number of children in census tract i and age class k minus the total number of children in census tract i and age class k who are eligible for Medicaid/CHIP (i.e., age class k eligible).

• 3 Data Sources

  The primary data sources are the 2010 SF2 100 % census data and the 2012 American Community Survey data, downloaded from the website: http://factfinder2.census.gov/faces/nav/jsf/pages/searchresults.xhtml?refresh=t.

Remarks on data processing:

• Tract names and locations specified by a unique Geographic Identifier code (GEOID) can be found in any census table.

• Data from tracts present in the ACS data but not in the census data are ignored.

We used the following tables:

• PCT3: Sex by Age

• B17024: Age by Ratio of Income to Poverty Level in the Past 12 Months

• PCT10: Household by Presence of People under 18 by Household Type by Age of People Under 18 Years

• PCT7: Average Household Size by Age

• B19001: Household Income in the Past 12 Months (in 2012 Inflation-Adjusted Dollars)

• B08201: Household Size by Vehicles Available

A snapshot and a brief explanation of each table are provided in the tables below.

PCT3: Sex by Age

This table lists the total number of people of a particular age and sex in each census tract. Using this table, we find the total population within a specific age range.

Snapshot 1:

	Census track 9501, Appling County, Georgia	Census track 9502, Appling County, Georgia	Census track 9503, Appling County, Georgia	Census track 9504, Appling County, Georgia	Census track 9505, Appling County, Georgia	Census track 9601, Atkinson County, Georgia	Census track 9602, Atkinson County, Georgia	Census track 9603, Atkinson County, Georgia	Census track 9701, Bacon County, Georgia	Census track 9702.01, Bacon County, Georgia	Census track 9702.02, Bacon County, Georgia	Census track 9601, Baker County, Georgia	Census track 9602, Baker County, Georgia	Census track 9701, Baldwin County, Georgia	Census track 9702, Baldwin County, Georgia	Census track 9703, Baldwin County, Georgia	Census track 9704, Baldwin County, Georgia	Census track 9705, Baldwin County, Georgia
Total	3190	4530	5176	1476	3864	2077	5053	1245	3057	4233	3806	2198	1253	5401	6883	6098	4336	7114
Male	1507	2319	2534	746	1953	1035	2565	640	1540	2008	1943	1048	625	2629	3288	2920	1980	3414
Under 1 year	32	27	34	13	30	16	40	0	23	30	19	14	9	30	63	42	21	29
1 year	18	30	36	13	21	17	44	15	13	30	18	12	6	30	56	59	22	24
2 years	14	34	44	6	35	23	44	6	23	45	29	12	4	36	71	35	23	21
3 years	27	40	34	12	24	19	47	12	17	39	40	12	15	37	40	40	12	29
4 years	10	32	47	8	26	15	41	13	16	34	33	15	7	51	52	46	22	25
5 years	21	10	10	15	23	16	37	9	21	29	23	13	7	35	15	55	18	23
6 years	17	31	37	12	22	13	51	0	21	20	30	15	1	45	63	38	15	20
7 years	28	34	31	7	17	16	37	12	24	23	21	14	8	40	60	45	27	28
8 years	21	38	43	7	37	17	40	11	19	41	27	18	5	37	45	40	17	20
9 years	17	50	35	14	18	15	33	6	15	26	29	15	10	38	45	25	21	24
10 years	19	35	35	8	34	21	34	11	21	39	20	8	13	34	45	33	19	29
11 years	23	17	36	9	20	17	31	6	18	30	17	12	9	50	31	35	17	18
12 years	28	40	48	5	29	22	48	7	26	32	29	9	8	46	44	28	20	19
13 years	22	30	41	16	29	24	40	5	31	25	19	8	8	39	50	35	12	17
14 years	33	34	40	12	30	11	52	9	19	33	19	17	10	35	36	48	14	17
15 years	33	40	34	3	32	10	43	16	28	36	16	17	7	44	48	35	21	25
16 years	35	30	50	10	32	19	42	8	21	32	26	15	10	46	34	40	24	19
17 years	22	31	38	10	37	10	49	9	22	27	22	13	10	38	37	50	22	27
18 years	21	42	44	9	23	14	45	8	15	21	27	16	5	50	45	42	31	133
19 years	17	33	31	11	23	14	40	10	18	14	29	15	7	20	46	28	78	348
20 years	24	37	30	8	23	20	41	7	13	23	37	21	6	32	60	39	107	271
21 years	11	30	19	1	20	25	13	9	16	23	32	20	8	31	79	33	126	233
22 years	20	42	35	7	20	13	28	9	19	37	31	10	5	21	83	29	113	179
23 years	21	32	37	3	11	14	31	5	14	29	18	16	7	23	66	28	79	106
24 years	14	44	34	8	27	5	39	12	25	31	34	16	4	30	81	37	59	56
25 years	9	31	30	6	23	13	33	14	15	24	27	12	1	27	68	31	45	50
26 years	10	33	40	11	33	17	34	7	14	16	38	8	7	20	48	42	31	37
27 years	28	39	33	5	18	10	36	8	21	21	16	8	6	19	50	35	25	32
28 years	15	36	40	11	16	10	40	5	17	18	33	9	7	29	36	25	26	27
Female	1583	2211	2642	730	1911	1042	2488	605	1517	2225	1863	1150	628	2772	3595	3178	2356	3700
Under 1 year	20	32	33	8	24	22	43	8	21	25	40	11	8	29	31	43	15	23
1 year	18	33	43	5	31	15	40	10	24	39	34	25	4	36	59	37	15	19
2 years	24	48	35	11	31	21	37	6	19	33	27	15	10	34	58	43	24	20
3 years	12	31	44	3	29	15	47	4	27	29	23	16	4	33	58	47	16	22
4 years	32	39	25	13	35	15	48	9	18	33	24	15	6	34	52	45	7	19
5 years	22	30	41	11	27	30	33	9	22	30	30	11	6	27	53	36	29	28
6 years	22	30	49	11	29	12	43	5	27	32	25	11	7	39	42	33	18	33
7 years	20	33	33	6	24	14	40	15	17	36	33	18	10	37	44	39	16	24
8 years	25	28	34	3	28	16	34	7	30	39	27	23	9	40	50	37	15	23
9 years	20	27	36	12	27	18	41	9	14	29	27	14	7	40	49	40	13	15
10 years	19	43	32	5	17	18	33	11	15	30	32	20	5	47	43	47	26	16
11 years	23	30	38	15	28	14	48	12	29	21	23	13	9	38	38	41	17	31
12 years	28	32	28	3	25	18	51	11	29	34	19	23	12	45	42	50	11	19
13 years	28	34	42	8	33	16	41	5	24	40	33	11	9	45	30	25	14	16
14 years	19	11	24	6	29	16	40	7	16	36	20	11	8	44	30	24	18	26
15 years	23	16	39	8	19	8	37	7	13	32	28	13	10	33	31	35	14	24
16 years	15	33	35	8	17	21	38	6	22	25	21	12	7	38	38	37	20	8
17 years	18	34	37	8	24	9	45	15	10	18	27	12	10	41	42	37	25	24
18 years	14	33	30	10	36	20	36	7	21	38	24	11	9	28	36	42	59	284
19 years	18	21	27	13	27	16	38	11	14	19	15	20	3	33	51	41	111	572
20 years	19	24	25	6	15	14	40	7	22	33	19	15	6	17	59	36	172	496
21 years	19	20	24	2	27	12	23	4	19	21	22	10	6	24	85	39	185	338
22 years	17	18	20	10	13	8	27	7	11	19	13	16	10	26	114	48	132	214
23 years	20	28	28	6	22	9	24	11	17	26	22	12	5	25	81	47	60	100
24 years	8	19	39	7	17	15	33	10	17	22	24	9	7	28	68	38	36	51
25 years	18	27	18	5	29	18	31	10	12	29	13	14	6	30	70	37	25	33
26 years	17	30	34	15	23	14	29	10	18	28	26	20	7	31	53	42	39	31
27 years	15	25	25	12	22	10	35	9	20	25	27	15	4	32	58	44	26	32
28 years	12	24	29	7	17	14	31	10	22	35	24	18	4	32	54	36	28	26

B17024: Age by Ratio of Income to Poverty Level in the Past 12 Months

This table lists the number of people in a particular age group and income to poverty level ratio intervals for each census tract. This table is used to determine the proportion of Medicaid eligible children based on age and income.

Snapshot 2:

	Census Tract 9501, Appling County, Georgia		Census Tract 9502, Appling County, Georgia		Census Tract 9503, Appling County, Georgia		Census Tract 9504, Appling County, Georgia		Census Tract 9505, Appling County, Georgia		Census Tract 9601, Atkinson County, Georgia		Census Tract 9602, Atkinson County, Georgia		Census Tract 9603, Atkinson County, Georgia		Census Tract 9701, Bacon County, Georgia
	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error
Total	3009	+/−428	4363	+/−453	5092	+/−491	1353	+/−284	4099	+/−455	2254	+/−301	4832	+/−382	1230	+/−367	2674	+/−405
Under 6 years	176	+/−100	354	+/−129	449	+/−132	53	+/−41	313	+/−118	224	+/−107	509	+/−91	135	+/−92	175	+/−111
Under .50	0	+/−13	26	+/−30	113	+/−101	0	+/−13	32	+/−39	120	+/−111	132	+/−66	26	+/−34	0	+/−13
.50 to .74	28	+/−44	60	+/−54	59	+/−75	0	+/−13	0	+/−13	24	+/−24	52	+/−54	47	+/−66	0	+/−13
.75 to .99	0	+/−13	100	+/−88	80	+/−111	0	+/−13	28	+/−48	9	+/−13	79	+/−51	0	+/−13	15	+/−27
1.00 to 1.24	0	+/−13	32	+/−47	0	+/−19	0	+/−13	72	+/−64	14	+/−16	25	+/−26	0	+/−13	0	+/−13
1.25 to 1.49	0	+/−13	31	+/−54	0	+/−19	0	+/−13	7	+/−11	9	+/−14	73	+/−69	0	+/−13	0	+/−13
1.50 to 1.74	9	+/−15	0	+/−13	88	+/−93	8	+/−12	0	+/−13	0	+/−13	27	+/−30	0	+/−13	0	+/−13
1.75 to 1.84	21	+/−34	24	+/−38	0	+/−19	0	+/−13	106	+/−80	0	+/−13	34	+/−50	0	+/−13	36	+/−63
1.85 to 1.99	0	+/−13	16	+/−27	0	+/−19	0	+/−13	0	+/−13	15	+/−25	12	+/−19	7	+/−12	0	+/−13
2.00 to 2.99	10	+/−18	60	+/−61	0	+/−19	26	+/−30	12	+/−20	12	+/−15	43	+/−44	35	+/−44	28	+/−37
3.00 to 3.99	37	+/−41	5	+/−9	23	+/−32	0	+/−13	27	+/−41	11	+/−21	32	+/−39	0	+/−13	48	+/−66
4.00 to 4.99	26	+/−42	0	+/−13	86	+/−113	19	+/−26	0	+/−13	2	+/−16	0	+/−13	20	+/−32	23	+/−40
5.00 and over	45	+/−54	0	+/−13	0	+/−19	0	+/−13	29	+/−37	8	+/−14	0	+/−13	0	+/−13	25	+/−40
6 to 11 years	315	+/−133	496	+/−162	492	189	74	+/−56	360	+/−123	208	+/−63	376	+/−101	127	+/−82	235	+/−108
Under .50	0	+/−13	51	+/−58	96	+/−99	0	+/−13	91	+/−81	84	+/−61	96	+/−53	32	+/−45	0	+/−13
.50 to .74	0	+/−13	87	+/−89	94	+/−126	0	+/−13	38	+/−66	49	+/−46	26	+/−32	17	+/−25	0	+/−13
.75 to .99	0	+/−13	105	+/−80	21	+/−34	13	+/−18	43	+/−49	14	+/−16	100	+/−66	0	+/−13	54	+/−73
1.00 to 1.24	97	+/−107	53	+/−50	19	+/−30	0	+/−13	25	+/−36	15	+/−17	0	+/−13	0	+/−13	52	+/−48
1.25 to 1.49	0	+/−13	23	+/−31	0	+/−19	0	+/−13	15	+/−24	3	+/−5	27	+/−24	12	+/−22	0	+/−13
1.50 to 1.74	36	+/−39	0	+/−13	23	+/−36	38	+/−51	30	+/−41	0	+/−13	57	+/−37	0	+/−13	0	+/−13
1.75 to 1.84	11	+/−20	0	+/−13	0	+/−19	0	+/−13	32	+/−26	0	+/−13	0	+/−13	0	+/−13	0	+/−13
1.85 to 1.99	0	+/−13	0	+/−13	0	+/−19	0	+/−13	0	+/−13	9	+/−15	15	+/−26	5	+/−10	0	+/−13
2.00 to 2.99	86	+/−74	86	+/−106	105	+/−75	23	+/−26	0	+/−13	16	+/−28	31	+/−34	61	+/−55	11	+/−19
3.00 to 3.99	37	+/−44	44	+/−45	40	+/−63	0	+/−13	35	+/−51	9	+/−17	6	+/−10	0	+/−13	60	+/−93
4.00 to 4.99	0	+/−13	18	+/−28	71	+/−74	0	+/−13	37	+/−53	9	+/−19	18	+/−27	0	+/−13	11	+/−19
5.00 and over	48	+/−47	26	+/−28	23	+/−37	0	+/−13	14	+/−24	0	+/−13	0	+/−13	0	+/−13	47	+/−51
12 to 17 years	310	+/−177	430	+/−131	338	+/−100	97	+/−56	423	+/−168	265	+/−84	510	+/−119	114	+/−81	214	+/−96
Under .50	10	+/−16	71	+/−55	31	+/−34	20	+/−28	64	+/−77	27	+/−22	47	+/−40	8	+/−12	0	+/−13
.50 to .74	0	+/−13	39	+/−43	0	+/−19	0	+/−13	26	+/−30	55	+/−59	16	+/−23	25	+/−40	0	+/−13
.75 to 99	0	+/−13	71	+/−74	13	+/−21	14	+/−18	3	+/−5	23	+/−34	99	+/−62	0	+/−13	0	+/−13
1.00 to 1.24	117	+/−135	58	+/−69	0	+/−19	15	+/−27	30	+/−29	44	+/−39	10	+/−15	0	+/−13	90	+/−73
1.25 to 1.49	30	+/−52	38	+/−59	6	+/−12	9	+/−15	21	+/−31	20	+/−25	44	+/−37	32	+/−47	0	+/−13
1.50 to 1.74	0	+/−13	54	+/−62	23	+/−38	0	+/−13	12	+/−17	0	+/−13	101	+/−87	19	+/−34	0	+/−13
1.75 to 1.84	22	+/−3435	24	+/−3438	0	+/−3419	0	+/−3413	86	+/−3465	0	+/−3413	7	+/−3410	0	+/−3413	27	+/−3442
1.85 to 1.99	29	+/−51	0	+/−13	0	+/−19	3	+/−5	0	+/−13	0	+/−13	0	+/−13	4	+/−8	0	+/−13
2.00 to 2.99	14	+/−26	39	+/−45	127	+/−90	8	+/−14	86	+/−97	0	+/−13	114	+/−79	0	+/−13	24	+/−38
3.00 to 3.99	27	+/−44	7	+/−12	18	+/−29	0	+/−13	44	+/−46	18	+/−25	4	+/−6	0	+/−13	13	+/−22
4.00 to 4.99	61	+/−70	0	+/−13	60	+/−76	28	+/−33	38	+/−39	2	+/−5	53	+/−76	20	+/−34	18	+/−25
5.00 and over	0	+/−13	29	+/−31	60	+/−60	0	+/−13	13	+/−22	76	+/−48	15	+/−19	6	+/−10	42	+/−40
18 to 24 years	159	+/−105	266	+/−131	469	+/−214	126	+/−81	236	+/−121	154	+/−80	527	+/−116	54	+/−58	280	+/−129
Under .50	0	+/−13	14	+/−24	30	+/−48	0	+/−13	35	+/−32	0	+/−13	128	+/−61	0	+/−13	28	+/−35
.50 to .74	37	+/−52	12	+/−20	24	+/−48	0	+/−13	4	+/−7	24	+/−36	54	+/−59	17	+/−28	14	+/−27
.75 to .99	0	+/−13	96	+/−114	0	+/−19	10	+/−19	0	+/−13	13	+/−22	49	+/−41	0	+/−13	0	+/−13
1.00 to 1.24	0	+/−13	36	+/−54	0	+/−19	1	+/−2	5	+/−9	30	+/−33	22	+/−19	0	+/−13	0	+/−13
1.25 to 1.49	0	+/−13	0	+/−13	15	+/−29	0	+/−13	13	+/−20	5	+/−10	5	+/−10	0	+/−13	0	+/−13
1.50 to 1.74	0	+/−13	0	+/−13	97	+/−127	10	+/−15	43	+/−54	0	+/−13	43	+/−44	0	+/13	0	+/−13
1.75 to 1.84	0	+/−13	0	+/−13	0	+/−19	0	+/−13	0	+/−13	44	+/−53	13	+/−15	0	+/−13	0	+/−13
1.85 to 1.99	0	+/−13	0	+/−13	0	+/−19	3	+/−5	0	+/−13	0	+/−13	0	+/−13	7	+/−13	0	+/−13
2.00 to 2.99	30	+/−55	35	+/−44	247	+/−208	44	+/−52	83	+/−89	16	+/−22	142	+/−93	0	+/−13	29	+/−36
3.00 to 3.99	51	+/−50	37	+/−40	0	+/−19	38	+/−51	3	+/−6	22	+/−28	43	+/−47	30	+/−44	87	+/−91
4.00 to 4.99	17	+/−34	0	+/−13	0	+/−19	0	+/−13	28	+/−45	0	+/−13	28	+/−42	0	+/−13	26	+/−34
5.00 and over	24	+/−40	36	+/−54	56	+/−67	20	+/−25	22	+/−34	0	+/−13	0	+/−13	0	+/−13	96	+/−76

PCT10: Household by Presence of People under 18 by Household Type by Age of People under 18 Years

This table lists the number of households that include a child of a particular age range, divided by the type of household (e.g., one with both a husband and wife). This table is used to find the total number of households with a child in each age group.

Snapshot 3:

	Census Tract 9501, Appling County Georgia	Census Tract 9502, Appling County Georgia	Census Tract 9503, Appling County Georgia	Census Tract 9504, Appling County Georgia	Census Tract 9505, Appling County Georgia	Census Tract 9601, Atkinson County Georgia	Census Tract 9602, Atkinson County Georgia	Census Tract 9603, Atkinson County Georgia	Census Tract 9701, Bacon County Georgia	Census Tract 9702.01, Bacon County Georgia	Census Tract 9702.02, Bacon County Georgia	Census Tract 9601, Baker County Georgia	Census Tract 9602, Baker County Georgia	Census Tract 9701, Baldwin County Georgia	Census Tract 9702, Baldwin County Georgia	Census Tract 9703, Baldwin County Georgia	Census Tract 9704, Baldwin County Georgia	Census Tract 9705, Baldwin County Georgia
Total	1270	1631	1969	606	1493	770	1763	450	1167	1606	1441	862	510	2075	2882	2437	1810	2132
Households with one or more people under 18 years	436	612	696	170	522	300	752	178	416	594	504	271	141	755	910	803	375	444
Family households:	433	608	680	170	514	298	737	176	406	589	500	266	139	747	905	798	372	440
Husband-wife family	326	324	421	124	360	171	471	129	303	325	300	150	94	447	407	511	159	203
Under 6 years only	79	64	86	31	79	43	98	27	64	65	67	35	19	94	112	144	48	40
Under 6 years and 6 to 17 years	58	88	121	37	78	54	133	30	69	90	72	37	22	108	91	122	29	41
6 to 17 years only	189	172	214	56	203	74	240	72	170	170	161	78	53	245	204	245	82	122
Other family	107	284	259	46	154	127	266	47	103	264	200	116	45	300	498	287	213	237
Male householder, no wife present	31	69	72	12	61	28	69	23	46	37	47	19	11	61	68	50	35	25
Under 6 years only	7	24	17	2	17	3	19	5	15	10	15	3	2	12	26	13	10	7
Under 6 years and 6 to 17 years	5	19	12	0	8	7	9	6	7	5	7	2	1	12	9	11	8	4
6 to 17 years only	19	26	43	10	36	18	41	12	24	22	25	14	8	37	33	26	17	14
Female householder, no husband present.	76	215	187	34	93	99	197	24	57	227	153	97	34	239	430	237	178	212
Under 6 years only	22	34	45	9	22	27	47	7	7	76	37	24	7	44	121	57	34	66
Under 6 years and 6 to 17 years	8	61	53	6	27	30	44	4	14	45	42	25	8	50	118	53	37	46
6 to 17 years only	46	120	89	19	44	42	106	13	36	106	74	48	19	145	191	127	107	100
Nonfamily households	3	4	16	0	8	2	15	2	10	5	4	5	2	8	5	5	3	4
Male householder	3	2	16	0	7	2	14	1	10	4	4	4	1	5	1	3	1	3
Under 6 years only	2	0	2	0	2	0	1	1	2	0	2	0	1	2	0	1	1	0
Under 6 years and 6 to 17 years	1	0	2	0	1	0	3	0	0	0	0	1	0	0	0	0	0	1
6 to 17 years only	0	2	12	0	4	2	10	0	8	4	2	3	0	3	1	2	0	2
Female householder	0	2	0	0	1	0	1	1	0	1	0	1	1	3	4	2	2	1
Under 6 years only	0	0	0	0	0	0	0	0	0	1	0	1	0	0	4	0	2	0
Under 6 years and 6 to 17 years	0	0	0	0	0	0	0	0	0	0	0	0	0	2	0	0	0	0
6 to 17 years only	0	2	0	0	1	0	1	1	0	0	0	0	1	1	0	2	0	1
Households with no people under 18 years	834	1019	1273	436	971	470	1011	272	751	1012	937	591	369	1320	1972	1634	1435	1688
Family households	477	510	657	267	578	248	541	159	463	524	478	291	196	806	892	938	484	438
Husband-wife family	408	396	538	223	500	186	411	132	403	420	374	207	155	644	696	773	302	316
Other family	69	114	119	44	78	62	130	27	60	104	104	84	41	162	196	165	182	122
Male householder, no wife present	26	34	43	18	33	20	55	9	19	28	34	22	16	42	46	40	59	31
Female householder, no husband present	43	80	76	26	45	42	75	18	41	76	70	62	25	120	150	125	123	91
Nonfamily households	357	509	616	169	393	222	470	113	288	488	459	300	173	514	1080	696	951	1250
Male householder	189	234	240	87	216	115	243	68	163	219	218	145	90	256	500	297	389	512
Female householder	168	275	376	82	177	107	227	45	125	269	241	155	83	258	580	399	562	738

PCT7: Average Household Size by Age

This table provides the average size of a household, specifying the portions of adults and of children in the household. The data in this table is used to compute the total household average size to estimate the FPL in dollars.

Snapshot 4:

	Census Tract 9501, Appling County, Georgia	Census Tract 9502, Appling County, Georgia	Census Tract 9503, Appling County, Georgia	Census Tract 9504, Appling County, Georgia	Census Tract 9505, Appling County, Georgia	Census Tract 9601, Atkinson County, Georgia	Census Tract 9602, Atkinson County, Georgia	Census Tract 9603, Atkinson County, Georgia	Census Tract 9701, Bacon County, Georgia	Census Tract 9702.01, Bacon County, Georgia	Census Tract 9702.02, Bacon County, Georgia	Census Tract 9601, Baker County, Georgia	Census Tract 9602, Baker County, Georgia	Census Tract 9701, Baldwin County, Georgia	Census Tract 9702, Baldwin County, Georgia	Census Tract 9703, Baldwin County, Georgia	Census Tract 9704, Baldwin County, Georgia	Census Tract 9705, Baldwin County, Georgia
Average household size
Total	2.49	2.61	2.57	2.44	2.59	2.70	2.85	2.77	2.62	2.55	2.51	2.55	2.46	2.60	2.38	2.50	2.28	2.43
Under 18 years	0.61	0.76	0.69	0.53	0.65	0.78	0.85	0.73	0.65	0.71	0.65	0.60	0.56	0.67	0.58	0.59	0.36	0.39
18 years and over	1.87	1.85	1.88	1.90	1.94	1.92	2.00	2.04	1.97	1.84	1.86	1.95	1.89	1.93	1.80	1.92	1.92	2.04

B19001: Household Income in the Past 12 Months (in 2012 Inflation-Adjusted Dollars)

This table lists the number of households in a particular income interval in dollars. The data in this table is used to determine the number of households below the FPL.

Snapshot 5:

	Census Tract 9501, Appling County, Georgia		Census Tract 9502, Appling County, Georgia		Census Tract 9503, Appling County, Georgia		Census Tract 9504, Appling County, Georgia		Census Tract 9505, Appling County, Georgia		Census Tract 9601, Atkinson County, Georgia		Census Tract 9602, Atkinson County, Georgia		Census Tract 9603, Atkinson County, Georgia		Census Tract 9701, Bacon County, Georgia
	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error
Total:	1189	+/−145	1670	+/−152	2099	+/−230	583	+/−111	1506	+/−152	711	+/−84	1634	+/−133	374	+/−71	976	+/−124
Less than $10,000	55	+/−44	154	+/−61	283	+/−125	59	+/−34	162	+/−70	108	+/−46	341	+/−84	26	+/−31	135	+/−75
$10,000 to $14,999	80	+/−58	201	+/−78	205	+/−87	36	+/−36	56	+/−43	51	+/−27	234	+/−88	52	+/−39	106	+/−68
$15,000 to $19,999	89	+/−62	141	+/−65	146	+/−112	75	+/−46	182	+/−78	111	+/−52	56	+/−34	25	+/−30	23	+/−36
$20,000 to $24,999	56	+/−42	172	+/−111	61	+/−51	31	+/−26	142	+/−80	125	+/−68	61	+/−36	16	+/−19	113	+/−71
$25,000 to $29,999	113	+/−76	108	+/−65	122	+/−108	32	+/−26	92	+/−58	22	+/−18	133	+/−64	37	+/−33	66	+/−37
$30,000 to $34,999	125	+/−83	189	+/−81	161	+/−105	16	+/−14	78	+/−51	39	+/−36	119	+/−64	13	+/−15	52	+/−44
$35,000 to $39,999	108	+/−61	138	+/−71	93	+/−86	43	+/−30	115	+/−77	16	+/−15	118	+/−69	51	+/−41	28	+/−32
$40,000 to $44,999	65	+/−40	90	+/−65	69	+/−52	51	+/−41	42	+/−35	21	+/−24	65	+/−45	0	+/−13	10	+/−16
$45,000 to $49,999	24	+/−25	43	+/−41	144	+/−117	7	+/−8	49	+/−46	4	+/−8	72	+/−46	0	+/−13	45	+/−37
$50,000 to $59,999	53	+/−36	115	+/−79	113	+/−77	32	+/−24	116	+/−68	44	+/−28	70	+/−47	69	+/−48	29	+/−36
$60,000 to $74,999	71	+/−67	122	+/−66	183	+/−95	98	+/−49	137	+/−75	22	+/−17	116	+/−51	43	+/−31	69	+/−44
$75,000 to $99,999	120	+/−67	108	+/−80	239	+/−103	88	+/−48	52	+/−44	56	+/−37	136	+/−54	24	+/−18	142	+/−72
$100,000 to $124,999	139	+/−64	62	+/−54	180	+/−88	0	+/−13	168	+/−94	33	+/−33	69	+/−52	18	+/−20	76	+/−49
$125,000 to $149,999	55	+/−60	11	+/−18	39	+/−35	15	+/−20	52	+/−35	49	+/−32	10	+/−16	0	+/−13	15	+/−26
$150,000 to $199,999	24	+/−28	16	+/−18	54	+/−66	0	+/−13	29	+/−28	0	+/−13	34	+/−24	0	+/−13	51	+/−45
$200,000 or more	12	+/−19	0	+/−13	7	+/−12	0	+/−13	34	+/−46	10	+/−18	0	+/−13	0	+/13	16	+/−27

B08201: Household Size by Vehicles Available

This table lists the number of households, both overall and by size category, with a given number of vehicles. We use this table to find the percentage of households with at least one vehicle.

Snapshot 6:

	Census Tract 9501, Appling County, Georgia		Census Tract 9502, Appling County, Georgia		Census Tract 9503, Appling County, Georgia		Census Tract 9504, Appling County, Georgia		Census Tract 9505, Appling County, Georgia		Census Tract 9601, Atkinson County, Georgia		Census Tract 9602, Atkinson County, Georgia		Census Tract 9603, Atkinson County, Georgia		Census Tract 9701, Bacon County, Georgia
	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error	Estimate	Margin of error
Total	1189	+/−145	1670	+/−152	2099	+/−230	583	+/−111	1506	+/−152	711	+/−84	1634	+/−133	374	+/−71	976	+/−124
No vehicle available	31	+/−32	150	+/−79	228	+/−121	31	+/−27	71	+/−44	55	+/−30	214	+/−65	13	+/−22	36	+/−35
1 vehicle available	339	+/−122	676	+/−149	728	+/−176	209	+/−69	468	+/−138	317	+/−75	638	+/−127	56	+/−35	321	+/−119
2 vehicles available	461	+/−116	634	+/−130	840	+/−180	170	+/−56	597	+/−115	208	+/−63	398	+/−102	177	+/−76	270	+/−99
3 vehicles available	246	+/−99	146	+/−64	250	+/−116	154	+/−64	283	+/−88	70	+/−41	286	+/−100	97	+/−53	232	+/−91
4 or more vehicles available	112	+/−69	64	+/−40	53	+/−48	19	+/−19	87	+/−75	61	+/−31	98	+/−48	31	+/−24	117	+/−57
1-person household	264	+/−107	466	+/−122	901	+/−229	186	+/−70	375	+/−122	241	+/−71	419	+/−111	55	+/−37	301	+/−113
No vehicle available	13	+/−14	60	+/−57	176	+/−99	21	+/−23	36	+/−24	42	+/−23	107	+/−53	0	+/−13	36	+/−35
1 vehicle available	173	+/−96	280	+/−80	447	+/−163	119	+/−55	272	+/−115	140	+/−64	250	+/−98	20	+/−19	213	+/−99
2 vehicles available	64	+/−43	95	+/−65	210	+/−125	14	+/−18	67	+/−54	54	+/−42	39	+/−25	20	+/−24	38	+/−40
3 vehicles available	14	+/−21	31	+/−36	68	+/−86	32	+/−24	0	+/−13	5	+/−8	23	+/−26	0	+/−13	14	+/−25
4 or more vehicles available	0	+/−13	0	+/−13	0	+/−19	0	+/−13	0	+/−13	0	+/−13	0	+/−13	15	+/−16	0	+/−13
2-person household	476	+/−123	513	+/−128	518	+/−140	234	+/−63	578	+/−103	163	+/−55	503	+/−114	166	+/−57	261	+/−81
No vehicle available	0	+/−13	51	+/−46	52	+/−70	10	+/−12	28	+/−31	5	+/−11	76	+/−57	0	+/−13	0	+/−13
1 vehicle available	76	+/−48	184	+/−95	77	+/−66	49	+/−32	112	+/−66	70	+/−34	150	+/−61	16	+/−19	70	+/−54
2 vehicles available	199	+/−81	220	+/−87	276	+/−110	99	+/−33	322	+/−85	64	+/−38	125	+/−54	82	+/−48	132	+/−58
3 vehicles available	161	+/−84	38	+/−42	105	+/−63	64	+/−38	116	+/−48	24	+/−24	120	+/−64	68	+/−45	47	+/−34
4 or more vehicles available	40	+/−32	20	+/−25	8	+/−12	12	+/−16	0	+/−13	0	+/−13	32	+/−22	0	+/−13	12	+/−14
3-person household	250	+/−105	275	+/−106	230	+/−130	126	+/−49	233	+/−95	140	+/−60	305	+/−92	81	+/−44	160	+/−73
No vehicle available	18	+/−29	18	+/−23	0	+/−19	0	+/−13	0	+/−13	8	+/−15	9	+/−12	13	+/−22	0	+/−13
1 vehicle available	70	+/−65	43	+/−34	87	+/−103	41	+/−31	19	+/−27	71	+/−46	127	+/−56	20	+/−23	0	+/−13
2 vehicles available	113	+/−67	162	+/−89	89	+/−61	38	+/−27	94	+/−58	30	+/−21	67	+/−41	9	+/−15	27	+/−27
3 vehicles available	0	+/−13	30	+/−32	54	+/−48	40	+/−35	86	+/−58	22	+/−24	71	+/−66	23	+/−28	87	+/−55
4 or more vehicles available	49	+/−43	22	+/−24	0	+/−19	7	+/−11	34	+/−46	9	+/−11	31	+/−32	16	+/−20	46	+/−45
4- or more person household	199	+/−90	416	+/−134	450	+/−132	37	+/−33	320	+/−107	167	+/−61	407	+/−98	72	+/−49	254	+/−78
No vehicle available	0	+/−13	21	+/−33	0	+/−19	0	+/−13	7	+/−11	0	+/−13	22	+/−19	0	+/−13	0	+/−13
1 vehicle available	20	+/−27	169	+/−98	117	+/−95	0	+/−13	65	+/−44	36	+/−23	111	+/−57	0	+/−13	38	+/−43
2 vehicles available	85	+/−50	157	+/−72	265	+/−84	19	+/−21	114	+/−72	60	+/−47	167	+/−84	66	+/−47	73	+/−52
3 vehicles available	71	+/−68	47	+/−35	23	+/−40	18	+/−24	81	+/−52	19	+/−24	72	+/−35	6	+/−11	84	+/−54
4 or more vehicles available	23	+/−28	22	+/−25	45	+/−47	0	+/−13	53	+/−65	52	+/−26	35	+/−36	0	+/−13	59	+/−51

• 4. Procedure to Obtain the Desired Parameter Values

In this section, we provide a numeric example of how we computed the model parameters. Examples are provided for one census tract (9501, Appling County, Georgia).

• 1. Age class 1:

  • Using PCT3, sum the data in the columns corresponding to “Male: - Under 1 year” and “Female: - Under 1 year.”

  Example (refer to Snapshot 1):

  Age class 1 = 32 + 20 = 52

• 2. Age class 2:

  • Using PCT3, sum the data in the columns corresponding to “Male: - 1 year” through “Male: - 5 years” and “Female: - 1 year” through “Female: - 5 years.”

  Example (refer to Snapshot 1):

  Age class 2 = (18 + 14 + 27 + 10 + 24) + (18 + 24 + 12 + 32 + 22) = 201

• 3. Age class 3:

  • Using PCT3, sum the data in the columns corresponding to “Male: - 6 years” through “Male: - 18 years” and “Female: - 6 years” through “Female: - 18 years.”

  Example (refer to Snapshot 1):

  Age class 3 = (17 + 28 + 21 + 17 + 19 + 23 + 28 + 22 + 33 + 33 + 35 + 22 + 21) + (22 + 20 + 25 + 20 + 19 + 23 + 28 + 28 + 19 + 23 + 15 + 18 + 14) = 593

• 4. Total Population <= 18:

  • Sum the values of age class 1, age class 2, and age class 3.

  Example

  Total Population <= 18 = 52 + 201 + 593 = 846

• 5. Age class 1 eligible:

  • Using B17024, in the “Under 6 years” age interval, find the value A = the total number of children under 6 with income under 2.47 of the FPL. This is the sum of all income intervals under 2.00 plus a fraction of the number in the 2.00 to 2.99 interval assuming a uniform distribution within that interval. That is:

    $$ \mathrm{A}=\mathrm{A}1+\mathrm{A}2 + \mathrm{A}3+\mathrm{A}4+\mathrm{A}5+\mathrm{A}6+\mathrm{A}7+\mathrm{A}8+\mathrm{A}9\ast \mathrm{A}10 $$

    Where:

    A1:

    Total number of children with income under 0.50

    A2:

    Total number of children with income between 0.50 and 0.74

    A3:

    Total number of children with income between 0.75 and 0.99

    A4:

    Total number of children with income between 1 and 1.24

    A5:

    Total number of children with income between 1.25 and 1.49

    A6:

    Total number of children with income between 1.50 and 1.74

    A7:

    Total number of children with income between 1.75 and 1.84

    A8:

    Total number of children with income between 1.85 and 1.99

    A9:

    Total number of children with income between 2.00 and 2.99

    $$ \mathrm{A}10 = \frac{2.47-2.00}{2.99-2.00} $$

  • Using Table B17024, find the total number of children under 6 ➔ Obtain value B

  • Find the eligible proportion ➔ Obtain value C

    $$ C = A/B $$

  • Find the total eligible population in age class 1 by multiplying C by total people in age class 1:

    $$ \mathrm{Age}\ \mathrm{Class}\ 1\ \mathrm{Eligible} = \mathrm{Age}\ \mathrm{Class}\ 1\ast C. $$

    Example (refer to Snapshot 2 for Census Tract 9501, Appling County, Georgia):

    $$ A = 0 + 28 + 0 + 0 + 0 + 9 + 21 + 0 + 10*\frac{2.47-2.00}{2.99-2.00} = 62.747 $$
    $$ B = 176 $$
    $$ C=\frac{62.747}{176}=0.3565 $$
    $$ \mathrm{Age}\ \mathrm{Class}\ 1\ \mathrm{Eligible} = 52*0.3565 = 18.539 $$

• 6. Age class 2 eligible:

  • Multiply the value of C by the total people in age class 2 to get the desired value, that is:

    $$ \mathrm{Age}\ \mathrm{Class}\ 2\ \mathrm{Eligible} = \mathrm{Age}\ \mathrm{Class}\ 2\ast C $$

  Example:

  Age Class 2 Eligible = 201 * 0.3565 = 71.660

• 7. Age class 3 eligible:

  • Using the “6 to 11 years” age interval in Table B17024 and the same method to obtain value B, find value D1 = the total number of children 6 to 11 years with income under 2.47 of the FPL

  • Repeat the previous step for the age interval “12 to 17 years” → Obtain value D2

  • Repeat again for the age interval “18 to 24 years” → Obtain value D3

  • Find the value E = the total number of children 6 to 18 years that are eligible in B17024, assume a uniform distribution in the “18 to 24 years” interval obtained by dividing the number of children from that interval by the width of that interval, that is:

    $$ \mathrm{E} = \mathrm{D}1 + \mathrm{D}2 + \mathrm{D}3/\left(24-18 + 1\right) $$

  • Using Table B17024, find the value F = total population whose age is 6 to 18:

    $$ \mathrm{F} = \mathrm{F}1 + \mathrm{F}2 + \mathrm{F}3 $$

    Where:

    F1:

    Total number of children 6 to 11 years

    F2:

    Total number of children 12 to 17 years

    F3:

    Total number of children of children whose age is 18 in the class 18 to 24 (assuming a uniform distribution obtained by dividing the total number of children in the class by the width of the class that is 24 − 18 + 1 = 7)

  • Find the eligible proportion →Obtain value G: $G=E/F$

  • Find the total eligible population in age class 1 by multiplying F by total people in age class 3:

    $$ \mathrm{Age}\ \mathrm{Class}\ 3\ \mathrm{Eligible} = \mathrm{Age}\ \mathrm{Class}\ 3\ast G $$

    Example (refer to Snapshot 2):

    $$ \mathrm{D}1=0+0+0+97+0+36+11+0+86\ast \frac{2.47-2.00}{2.99-2.00}=184.828 $$
    $$ \mathrm{D}2=10+0+0+117+30+0+22+29+14\ast \frac{2.47-2.00}{2.99-2.00} = 214.646 $$
    $$ \mathrm{D}3=0+37+0+0+0+0+0+0+30\ast \frac{2.47-2.00}{2.99-2.00} = 51.242 $$
    $$ E=184.828+214.646+51.242/7=406.795 $$
    $$ F=315+310+159/7=647.714 $$
    $$ G=406.795/647.714=0.6280 $$
    $$ \mathrm{Age}\ \mathrm{Class}\ 3\ \mathrm{Eligible}=593\ast 0.6280=372.432 $$

• 8. Total eligible population <= 18:

  • Sum the values of age class 1 eligible, age class 2 eligible, and age class 3 eligible.

  Example

  Total eligible population <= 18 = 18.539 + 71.660 + 372.432 = 462.631

• 9. mob_med:

  • From PCT10, find the number of households with one or more people under 18 years → Obtain value H

    Observation 1: to be consistent with the age class definition, we should consider the total number of households with at least one child less than 19 years old; however, this information is not available in the table.

  • From PCT7, find the total average household size → Obtain value I

  • Using the 2012 Department of Health and Human Services poverty guidelines formula found on http://aspe.hhs.gov/poverty/12poverty.shtml and the average household size, estimate value J = 247 % of the FPL in dollars. That is

    $$ J=2.47*\left(11,170+3960*\left(I-1\right)\right) $$

  • Using B19001, find the value K = percent of households below 247 % of the FPL. This is done by summing the number of households below the estimated FPL (assuming a uniform distribution in the interval containing the FPL) and dividing that sum by the total number of households listed in that same table. That is:

    $$ K = \left(\mathrm{K}1+\mathrm{K}2*\frac{J-\mathrm{K}3}{\mathrm{K}4-\mathrm{K}3}\right)/\mathrm{K}5 $$

    Where:

    K1:

    The sum of the data in all income intervals with an upper bound lower than J

    K2:

    The number of households in the income interval containing J

    K3:

    The value of the lower bound of the income interval containing J

    K4:

    The value of the upper bound of the income interval containing J

    K5:

    The total number of households given in the table

  • Using B08201, divide the total number of households with no vehicle available by the total number of households to get the proportion of all households with no vehicles → Obtain value N

  • Multiply M and the complement of N to obtain mob_med, that is:

    $$ \mathrm{mob}\_\mathrm{m}\mathrm{e}\mathrm{d}=K\ast \left(1-N\right) $$

  Observation 2: This number is calculated assuming independence between income level, size of household, and vehicle ownership.

  Example (refer to Snapshot 3, Snapshot 4, Snapshot 5, and Snapshot 6):

  • H = 436

  • I = 2.49

  • J = 2.47 * (11,170 + 3960 * (2.49 − 1)))) = $42,163.89

  • $K=\left(55+80+89+56+113+125+108+65*\frac{42,163.89-40,000}{44,999-40,000}\right)/1189=0.5502$

  • $N=\frac{31}{1189}=0.0261$

  • mob_med = .5502 * (1 − 0.0261) = 0.5358

• 10. mob_oth:

  • Multiply the proportion of ineligible households, the complement of K, by the proportion of households with at least one vehicle, the complement of N. That is:

    $$ \mathrm{mob}\_\mathrm{o}\mathrm{t}\mathrm{h}=\left(1-K\right)*\left(1-N\right) $$

  Observation 3: The same assumption as noted above applies here.

  Example

  $$ \mathrm{mob}\_\mathrm{o}\mathrm{t}\mathrm{h}=\left(1-0.5502\right)*\left(1-0.0261\right)=0.4381 $$

Appendix 3: Mathematical Model and Selection Value of the Trade-off Parameter

Optimization models are a very common mathematical tool in the operations research community to make decision about complex system. The three main components of an optimization model are the following: (i) the decision variables, which are a mathematical representation of the decisions that need to be made; (ii) the constraints of the model, which together restrict the set of the decisions that can be made; and (iii) the objective function, which assigns a performance value to each decision. Solving an optimization model means choosing, among all the decisions represented by the constraints of the model, the one whose associated value of the objective function is the best (either the minimum value or the maximum value). The output of the model is represented by the values of the variables, which represent the best-chosen decision.

In our context, the decision variables represent the total number of patients in each census tract of a given age class who are assigned to a specific provider, namely x ^M _ijk and x ^O _ijk , where index i ∈ S represents a census tract, index j ∈ P represents a provider, and index k = 1, 2, 3 denotes a specific age class. We also use the superscripts M and O to distinguish between those children covered by the Medicaid/CHIP insurance (x ^M _ijk ) and those children covered by private insurance (x ^O _ijk ). Constraints in the model ensure that the assignment of patients to providers mimics the process by which families choose primary care for their children. However, the Medicaid/CHIP eligible population and private insurance covered population may face different barriers to health care. For this reason, the model considers the two populations separately.

Our model is based on the assumptions that both families and policy makers value children having a primary care provider, that patients prefer to visit nearby physicians, and that they prefer to schedule visits when the office is not too busy (congestion); however, when physician congestion is considered too high, families prefer nonphysician providers such as Nurse Practitioners.33 Under these assumptions, the objective function of the model is a weighted sum of the total distance traveled (which needs to be minimized) and the provider preference contingent upon demand volume (which needs to be maximized).

To be more specific, the objective function of the model is as follows:

$$ \min \left(\left(1-\lambda \right){\displaystyle \sum_{i\in S}}{\displaystyle \sum_{j\in P}}{\displaystyle \sum_{k=1,2,3}}{d}_{ij}{f}_k\left({x}_{ijk}^{\mathrm{M}}+{x}_{ijk}^{\mathrm{O}}\right)-\lambda {\displaystyle \sum_{j\in P}}\left(1-{y}_j\right){u}_j\right) $$

where f _k is the yearly number of visits required by a patient in age class k, d _ij is the distance between the centroid of census tract i and physician j, y _j is the level of congestion at physician j computed as the ratio between assigned number of visits and maximum physician caseload, and u _j is a weight assigned to each provider. We note that the congestion level for Family/Internal Medicine is computed considering the physicians’ caseload that is devoted to visits to children. That is, we are assuming that these physicians are fully loaded, respecting the general perception of shortage of primary care supply for adult population.48

This objective function takes into account both the total distance and the total utility associated with the final assignment. In particular, the total weighted distance, represented by the first summation, is minimized, and the total patient satisfaction, represented by the second summation, is maximized. Different from the model in Nobles et al. 17 we add the second component to take into account preferences of patients toward different provider types. Existing studies show a general preference for physicians with respect to nurse practitioners, but nurse practitioners could be preferred to physicians when the latter are too congested.33 ^, 49 The model mimics this behavior by assigning the utility u _j to each provider j; this parameter is initially set such that physicians (that is, Family/Internal Medicine and Pediatric physicians) are preferred to nurse practitioners. Such a utility is, however, penalized in the function so that the more congested the provider is, the less utility is gained. The two components of the objective function are weighted by the nonnegative trade-off parameter λ ∈ [0, 1]. This parameter is used to define the relative importance of each component in the objective function. Its value is empirically evaluated by performing several runs of the model to choose the value of the parameter such that (i) neither of the two components of the objective functions dominates the other, and (ii) the resulting optimized decision reflects the fact that close neighbors experience the same travel distance and the same congestion level. Details of this experimental evaluation of the trade-off parameter are given in the next section.

There are several sets of constraints in the model. Figure 8 in this appendix shows the complete mathematical formulation, while Table 6 provides a summarized view of the set of parameters. A brief explanation of the constraints of the model is given next.

FIG. 8

Detailed mathematical formulation of the optimization model.

TABLE 6 The parameters used in the model, together with their description

The first set of constraints is assignment constraints that ensure that the assignment of patients to providers is nonnegative and that the total number of patients assigned to a provider in each census tract is not greater than the census tract population.

The second set of constraints takes into account the individual mandate provision in the ACA. The individual mandate requires every person to be insured; hence, the total number of patients to be assigned to providers should be equal to the total population of the state; however, we take into account the fact that the response of people to the individual mandate will not be universal, but we require that at least a given percentage of the total state population is assigned to providers.

The third set of constraints mimics distance barriers encountered by patients (accessibility constraints), taking into account a maximum distance allowed between patients and providers and barriers due to the ownership of a vehicle.

The fourth set of constraints takes into account provider capacity and mimics availability barriers (availability constraints). In particular, since providers have a maximum patient capacity based on the time they must spend with each patient to provide quality care, we consider constraints that ensure that the total number of patients assigned to each pediatric specialist cannot exceed his or her maximum caseload. Moreover, we add constraints that mimic the fact that for a provider to remain in practice, he or she must maintain a sufficiently large number of visits per year. Finally, we consider constraints that allow for different participation in the Medicaid program by limiting the total number of patients covered by Medicaid/CHIP insurance who can be assigned to each provider.

Finally, the last set of constraints considered in the model specifies that pediatric specialists cover a greater percentage of visits by children45 ^, 50 with respect to Family/Internal Medicine physicians (preference constraints). To this end, these constraints ensure that a given percentage α _k of the total patients in age class k is served by pediatric physicians and pediatric nurse practitioners.

The optimization model described above is implemented using the optimization programming language OPL and the CPLEX solver on a UNIX system. The result of the model is a matching of patients to providers that satisfies all the constraints and optimizes the objective function.

Choice of the Trade-off Parameter Value

We run our optimization model several times to choose the value of the trade-off parameter λ in the objective function of the optimization model. Parameter λ should be such that the two following criteria hold:

• A1: Neither one of the two components of the objective function dominates the other

• A2: Close neighbors should experience same travel cost and congestion

The optimization model is run (for each state separately) for different values of the parameter λ and the following metrics are evaluated for each run:

• Total distance traveled: the total weighted distance traveled is computed by summing up the distances for each patient for each assigned visit (first element of the objective function)

• Total patient satisfaction: sum, over all the providers of the network, of the associated utility computed as a function of the provider congestion (second element of the objective function)

• Spatial autocorrelation Geary index for the total congestion and the total distance traveled: the Geary index is a global index of spatial autocorrelation and provides a summary over the entire study area of the level of spatial similarity of a given measure observed among neighboring census tracts.51 The index varies between 0 and 2. Values of the index less than 1 denote positive spatial autocorrelation among neighboring census tracts. The Geary index is computed both for the average congestion experienced by patients at each census tract and for the total distance traveled by patients in each census tract.

The values of the first two metrics are evaluated to check whether the first assumption A1 holds, while the value of the Geary indices is considered to check whether assumption A2 holds.

Figure 9 shows the four abovementioned metrics for the optimization model for the state of Georgia and for the state of California computed for different values of the trade-off parameter, where the values of the total traveled distance and total patient satisfaction are normalized [0,1]. The leftmost parameter value corresponds to shortest distance, and the far right corresponds to a scenario with best patient satisfaction. Both total distance traveled and total patient satisfaction increase with the trade-off parameter. For small values of the trade-off parameter, distance is very important in the assignment, and thus, providers that are close to each other may have different levels of congestion and, therefore, different level of patient satisfaction. For larger values of the trade-off parameter, the situation is reversed and total patient utility plays an important role in the assignment while distance is not considered at all. The figures also show that the Geary indices for both distance and congestion are always lower that 1, denoting positive spatial autocorrelation. Using the two principles, reasonable values for the parameter λ are selected within the gray-shaded bands.

FIG. 9

The overall performance measures for different parameter settings of the trade-off parameter λ in the optimization model with highlighted area of recommended values. Georgia is on the top, California is on the bottom.

Appendix 4: Details on Statistical Methods Used

Hypothesis Test for Equality of Variances of Two Population Samples

We test the null hypothesis of equality of the variances. In particular, we consider the process Z(s), for each spatial unit s ∈ S, representing either the availability or the accessibility of either one of the two populations. The process can be decomposed as follows: Z(s) = μ(s) + Δ ϵ(s), where μ(s) is its mean trend, Δ its standard deviation, and ϵ(s) is a random error. To obtain an estimation of the variance of the process:

• (i) We apply nonparametric regression for estimation of the mean trend $\hat{\mu}(s)$ through the use the gam function of the mgcv library in the R statistical software;

• (ii) We compute the squared residuals ${Y}^2(s)={\left(Z(s)-\hat{\mu}(s)\right)}^2$ and their log transformation: log(Y ²(s)) ≈ log(Δ ϵ(s))² = log Δ² + log ϵ ²(s).

From the above considerations, it follows that ${ \log \Delta}^2=\mathbb{E}\Big( \log \left({Y}^2(s)\right)$ and the mean or median of the log transformation of the squared residual of Z(s) are an estimate of the variance of the process. We apply the Wilcoxon-paired test to the log-transformed squared residuals of the processes Z ^M(s) and Z ^O(s), to test the null hypothesis of equality of the variances, i.e., H₀ : σ ²_MED  = σ ²_OTH H₁ : σ ²_MED  > σ ²_OTH .

We apply the two tests both for the census tract and the county aggregation levels.

Significance Maps

To locate where the difference in either accessibility or availability between the two populations is statistically significant, we construct significance maps. In particular, we consider the difference process Z(s) = M(s) − O(s) for each spatial unit s for s ∈ S a geographic domain. We decompose Z(s) using nonparametric regression, i.e, Z(s) = f(s) + ϵ _s with $f(s)={\displaystyle \sum_k}{\theta}_k{\varphi}_k(s)$ where φ _k (s), k = 1, 2, … is a prespecified orthogonal basis of functions and θ _k , k = 1, 2,.., are coefficients to be estimated. In our implementation, we used the penalized splines regression for estimating f(s) using the mgcv library in the R statistical software.

Furthermore, we used the method proposed by Serban46 and Krivobokova et al.47 to estimate the simultaneous confidence bands [l _s , u _s ] for the regression functions f(s). Using the confidence bands, we are able to identify where the difference process Z(s) is statistically significantly positive or negative. Indeed, for those spatial units s such that u _s  < 0, we can say that the difference is statistically significantly negative, while for those spatial units s such that l _s  > 0, we can say that the difference is statistically significantly positive. These units can then be visualized on a significance map.