state and county characteristics estimates a detailed description of the vintage 2003 methods and...

STATE AND COUNTY CHARACTERISTICS ESTIMATES

A DETAILED DESCRIPTION OF THE VINTAGE 2003 METHODS AND PROCESSING

2

Workshop Overview

• Introduction• History and general concepts• State age-sex method and processing• State and county characteristics method and

processing• Summary and discussion

3

History and General Concepts: History• 1970s

– Started producing state estimates by selected age groups in the 1970s; added sex later in the ’70s

• 1980s– Started producing state estimates by single years

of age and sex using the current method

• Early 1990s– Released first set of state estimates by age, sex,

race, and Hispanic origin produced by the current method

4

History and General Concepts: History (cont.)• 2000s

– Released first set of county age, sex, race, and Hispanic origin estimates produced by the current method

5

History and General Concepts: General Concepts

• Universes– Resident– Civilian vs. Military– Household vs. GQ– Institutional vs. Noninstitutional

• Migration– International, Domestic, and Total– Ins, Outs, and Net– Interstate and Intrastate

6

History and General Concepts: General Concepts (cont.)• Proportional Distribution Technique

– Basic method1. Develop initial version of new estimates 2. Create proportions from new estimates that

correspond to the estimates to be distributed3. Multiply the proportions by the estimates to be

distributed

– Distributing two sets of estimates1. This procedure is done first to one set then to

another2. Typically, it is necessary to repeat the back-and-

forth procedure several times

7

History and General Concepts: General Concepts (cont.)

– Example – State age-sex estimates – 1 iteration1. Distribute national estimates

a. Produce an initial set of state estimates by age and sex

b. Sum state estimates [from #1] to the national level by age and sex

c. Calculate proportions by dividing each state age-sex cell [from #1] by the corresponding cell from the National sum [from #2]

d. Calculate intermediate state age-sex estimates by multiplying the proportions [from #3] by the actual national estimates

8


2. Distribute state estimates a. Take state age-sex estimates from first iteration

b. Sum age-sex estimates [from #1] to state totals

c. Calculate proportions by dividing each state age-sex cell [from #1] by the corresponding state total [from #2]

d. Calculate final state age-sex estimates by multiplying the proportions [from #3] by the actual state totals estimates

9


• Approaches to creating time-series– Whole interval approach: the beginning

population for the estimate of each year in the time-series is Census 2000

– Year-to-year approach: the beginning population for the estimates of each year in the time-series is the estimates for the previous year of the time-series

10


• Acronyms used in this presentation– ASRO: Age, Sex, Race, and Hispanic Origin– SYA: Single Years of Age– HH: Household– GQ: Group Quarters

11

State Age-Sex: Overview

• The basics• The general method: Ages 0 – 64

– Beginning populations– Deaths– Migration

• The general method: Ages 65+

12

State Age-Sex: The Basics

• State population – SYA (0 – 84, 85+) by sex

• Whole interval approach to creating time-series

13

State Age-Sex: The General Method1. Calculate preliminary population estimates

a. Calculate the civilian beginning populations and add births*b. Subtract deaths*c. Calculate estimated net migration and add*d. Apply sex proportions to get population by sexe. Add military to get resident populationf. Estimate the 65+ population*

2. Calculate proportions3. Use proportions to distribute estimates

a. National estimates by age and sexb. State totals estimates

* will be discussed in detail in this workshop

14

State Age-Sex: Beginning Population

1. Start with GUSSIE resident base population• By SYA and sex

2. Shift the age of the base population to age in estimate year

3. Add male and female population together

4. Add birth data to the youngest ages

5. Subtract out the military population to get the final civilian beginning population

15

State Age-Sex: Deaths

1. Calculate preliminary estimates of deathsa. Begin with deaths to the resident population by SYA (0-

84, 85+) and sexb. Collapse into both-sexes deaths by agec. Sum deaths to estimate intervals (Census date to

estimate date)d. Subtract military deaths to obtain preliminary civilian

deaths by age

2. Calculate proportions3. Use proportions to distribute national civilian

deaths by SYA from National Estimates

16

State Age-Sex: Migration, Ages 0 - 16

1. Develop an estimate of the total school age population (ages 6 to 14) for each estimate year– Distribute the national estimates for ages 6-14

to the states using proportions developed from school enrollment data

17

State Age-Sex: Migration, Ages 0 – 16 (cont.)

2. Develop a set of state school age population estimates under the assumption of no migration• Survive the cohorts that become the school age

population in the estimates year from Census 2000 to each estimate year using deaths from vital registration

3. Migration = [#1] – [#2]

4. Distribute to SYA 0 to 16

18

State Age-Sex: School-Age Migration Rates

1. Begin with the estimates of migration of the school age population from the previous step

2. Calculate an estimate of the mid-interval school-age population (6 to 14) for each estimate interval • Subtract ½ of the estimate of the cumulative

school-age deaths for each estimate interval from the Census 2000 school-age population

19

State Age-Sex: School-Age Migration Rates (cont.)

3. Compute the school age migration rates• Divide the estimates of school-age migration for

each estimate interval by the corresponding mid-interval estimate of the school age population

20

State Age-Sex: Migration Differentials

1. Begin with census data from 5-year residence question (ignoring sampling variability)

2. Calculate in and out migration rates by state and SYA (0-84, 85+) and smooth by age

3. Combine in and out rates into a net migration rate

4. Convert to annual net-migration rates5. Calculate annual migrants by multiplying

annual rate by mid-interval estimate

21

State Age-Sex: Migration Differentials (cont.)

6. Sum migrants by cohort and collapse summed migrants ages 6-14 into one group

7. Create new migration rates by dividing summed migrants ages 6-14 as a group and 17-64 migrants by SYA by the corresponding population at the beginning of the interval

8. Subtract school age migration rate from each SYA migration rate to get migration differentials.

22

State Age-Sex: Migration, Ages 17 - 64

1. Begin with school age migration rates2. Calculate migration rates by SYA 17 to 64

by adding the SYA migration differentials to the school age migration rate

3. Calculate migration by SYA 17 to 64 by multiplying the single-year rates by an estimate of the mid-interval population– Mid-interval population = Base population + ½

interval deaths

23

State Age-Sex: Population Estimates 65+1. Calculate preliminary population estimates

a. Start with Medicare data by state, sex and 5-year age groups 65-84 and 85+

b. Extrapolate values for 4/1/00 and missing estimate years

c. Control to Medicare totals used in state-county totals estimates

d. Distribute by SYA using cohort distributions from Census 2000

e. Calculate implied population change since 4/1/00 (estimated population – beginning population) and add to beginning population

24

State Age-Sex: Population Estimates 65+ (cont.)

2. Calculate proportions

3. Use proportions to distribute national estimates

25

State Age-Sex: Summary1. Calculate preliminary population estimates

a. Calculate the civilian beginning populations and add birthsb. Subtract deathsc. Calculate estimated net migration and addd. Apply sex proportions to get population by sexe. Add military to get resident populationf. Estimate the 65+ population


a. National estimates by age and sexb. State totals estimates

26

State & County Characteristics: Overview• The basics• State

– The general method– July 1, 2000 beginning population– Domestic migration

• IRS pre-processing• State domestic migration

– Race conversion (4 to 31)

• County– The general method– Domestic migration

27

State & County Characteristics: The Basics

• State and county population by ASRO– SYA (0 – 84, 85+) by sex, race (31 races), and

Hispanic origin (Hispanic, non-Hispanic)

• Year-to-year approach to creating time-series

• Processed in two separate steps– State characteristics– County characteristics

28

State Characteristics: The General Method1. Calculate preliminary population estimates

a. Produce July 1, 2000 beginning population*b. Add births, subtract deaths, add net international

migration, and add military movementc. Add domestic in-migration and subtract domestic out-

migration*


a. National ASROb. State age-sex

4. Convert from 4 to 31 races*


29

State Characteristics: July 1, 2000 Beginning Population1. Calculate preliminary population estimates

a. Begin with GUSSIE baseb. Convert from 31 to 4 races*c. Remove GQ population to get HH population

2. Calculate proportions3. Use proportions to distribute previous July 1,

2000 HH estimatesa. State: National ASRO and state age-sexb. County: State ASRO and county totals

4. Add GQ population to get resident population


30

State Characteristics: July 1, 2000 Beginning Population (cont.)• Race conversion: 31 to 4

– Equi-proportional assignment of persons in multi-race categories to single-race categories (31 to 5 categories)

– Combine Asian and Native Hawaiian and other Pacific Islander categories into Asian and Pacific Islander (5 to 4 categories)

31

State Characteristics: Domestic Migration - Overview

1. Pre-process IRS migration data*2. State domestic migration*

a. Calculate state out-migrationb. Calculate state in-migration

3. County domestic migration*a. Recalculate interstate in- and out- migrationb. Distribute interstate migration flows to countiesc. Calculate intrastate migration rates & migrantsd. Distribute intrastate migration totals to counties


32

State Characteristics: IRS Pre-processing - Overview

1. Obtain administrative record data

2. Match across administrative record sources

3. Assign characteristics to filer and exemptions

4. Compare Y1 and Y2 FIPS codes

5. Define migration universe

6. Tally exemptions by demographic characteristics

33

State Characteristics: Obtain Administrative Record Data

• Internal Revenue Service (IRS) 1040 files– Address in 2002 (Y1)– Address in 2003 (Y2)– Number of exemptions – filer, spouse, child,

parent

• Social Security Numident File– Collapse records to Census Numident Person

Characteristics File (PCF)– File contains modeled age, sex, race, and

Hispanic origin for all persons with an SSN

34

State Characteristics: Match Across Administrative Records

• Bureau committed to privacy and confidentiality– Convert SSN on tax records to Protected

Identifier Key (PIK)

• Match Y1 and Y2 files by filer’s PIK• Match Y1-Y2 file to PCF by filer’s PIK• Convert filer’s return to individual records for

filer, spouse, child, and parent exemptions on the tax return

35

State Characteristics: Assign ASRO

• Assign ASRO for Y1-Y2 matched records that match the PCF– Age

• Filer and spouse exemptions are assigned filer’s age from PCF

• Child exemptions are assigned to a 19 and under age category

• Parent exemptions are assigned to a 65+ age category

36

State Characteristics: Assign ASRO (cont.)

– Sex• Filer is assigned filer’s sex from PCF• Spouse exemption is assigned opposite sex of filer• Child and parent exemptions are assigned sex by

random number generator

– Race and Hispanic origin• Filer, spouse, child, and parent exemptions are all

assigned filer’s race and Hispanic origin from PCF

– Y1 and Y2 State and County FIPS codes• Filer, spouse, child, and parent exemptions are all

assigned filer’s Y1 and Y2 state and county FIPS codes

37

State Characteristics: Compare Y1 and Y2 FIPS Codes

• Compare by equivalent geography• Outcomes of comparison

– Y1 only– Y2 only– Foreign in- and out-movers– Inter-state movers– County to county movers (intra-state)– Non-movers

38

State Characteristics: Define Migration Universe

• Exclude records:– where record appears only in Y1 or Y2 file– with a foreign address on either the Y1 or Y2

return– where Y1-Y2 IRS match does not match to PCF

39

State Characteristics: Tallying Exemptions• Three different measures are calculated from

exemption data– Inter-state migration rates– Intra-state migration rates– County migration shares

• Exemption data come with the following characteristics– Age 0-19, SYA 20-64, 65+– Sex– White, Black, AIAN, API, Hispanic

• See handout

40

State Characteristics: Domestic Migration - Overview

1. State domestic out-migration*

2. State domestic in-migration*

3. State domestic migration flows*


41

State Characteristics: State Domestic Out-migration

1. Calculate a set of state out migration rates– Out-migration rate = tally #2 / tally #1 (see tally

handout)– If there are less than 30 exemptions for an ASRH

combination, additional ages are included until the threshold of 30 exemptions is met

2. Expand to full ASRO distribution– Each ASRO cell within a collapsed category is

assigned the rate of the category as a whole

3. Smooth the out-migration rates by age and perform final adjustment

42

State Characteristics: State Domestic In-migration

1. Calculate a set of state-to-state out-migration rates for each state– Out-migration rate = tally #3 / tally #1 (see tally

handout)– If there are less than 30 exemptions for an

ASRH combination, additional ages are included until the threshold of 30 exemptions is met

43

State Characteristics: State Domestic In-migration (cont.)

2. Calculate a set of state-specific out-migrants for each state by IRS characteristics– Out-migrants = Out-migration rate for State 1-

State 2 pair * state population for State 1 from previous vintage

3. Calculate state in-migrants– State in-migrants = Σ(state out migrants from

each other state to destination state)

44

State Characteristics: State Domestic In-migration (cont.)

3. Sum all state in-migrant estimates4. Calculate each state’s in-migration proportion

of the all-state sum [#3]– State in-migration proportion = preliminary state

in-migrants / Σ(preliminary state in-migrants)


assigned the rate of the category as a whole

6. Smooth the in-migration proportions by age and perform final adjustment

45

State Characteristics: State Domestic Migration Flows

• Calculate final estimates of out- and in-migrants by state (in the process of estimating the population)– State out-migrants = state out-migration rate *

state population at the beginning of the time interval

– State in-migrants = state in-proportion * ∑(state out-migrants)

46

State Characteristics: Race Conversion (4 to 31)

• Calculate conversion factors for 31 to 4 race conversion from the Census 2000 GUSSIE population

• Apply conversion factors to population in each 4-race category to get population in each 31-race category

47

State Characteristics: Summary1. Calculate preliminary population estimates

a. Produce July 1, 2000 beginning populationb. Add births, subtract deaths, add net international


migration


a. National ASROb. State age-sex

4. Convert from 4 to 31 races

48

County Characteristics: The General Method1. Calculate preliminary population estimates



migration*


a. State ASROb. County totals



49

County Characteristics: Domestic Migration - Overview

1. County interstate migration*a. State interstate out- and in-migration

b. County interstate out-migration

c. County interstate in-migration

2. County intrastate migration*a. State intrastate migration

b. County intrastate out-migration

c. County intrastate in-migration


50

County Characteristics: State Interstate Out- and In-migration

• Recalculate state-level in- and out-migrants using final out-rates and in-proportions from State Characteristics Estimates processing– State out-migrants = state out-migration rate *

state population at the beginning of the time interval

– State in-migrants = state in-proportion * ∑(state out-migrants)

51

County Characteristics: County Interstate Out-migration

1. Calculate county proportions of state interstate out-migration– Out-migration prop. = tally #5 / tally #2– By race-origin categories in IRS exemption data

• No age or sex detail

2. Calculate final county interstate outs by multiplying proportions by state interstate out-migration data

52

County Characteristics: County Interstate In-migration

1. Calculate county proportions of state interstate in-migration– In-migration prop. = tally #6 / ∑(tally #6 for all

counties within state) (see tally handout)– By race-origin categories in IRS exemption data


2. Calculate final county interstate ins by multiplying proportions by state interstate in-migration data

53

County Characteristics: State Intrastate Migration

1. Calculate a set of state intrastate migration rates– Intrastate-migration rate = tally #4 / tally #1 (see

tally handout)– If there are less than 30 exemptions for an

ASRH combination, additional ages are included until the threshold of 30 exemptions is met

54

County Characteristics: State Intrastate Migration (cont.)


assigned the rate of the category as a whole– Note: No age-smoothing

3. Calculate state intrastate migrants by ASRO– State intrastate migrants = state intrastate-

migration rate * state population at the beginning of the time interval (previous vintage)

4. Note: Intrastate Outs = Intrastate Ins

55

County Characteristics: County Intrastate Out-migration

1. Calculate county proportions of intrastate out-migration– Out-migration prop. = tally #7 / tally #4 (see tally

handout)– By race-origin categories in IRS exemption data


2. Calculate final county intrastate outs by multiplying proportions by state intrastate migration data

56

County Characteristics: County Intrastate In-migration

1. Calculate county proportions of intrastate in-migration– In-migration prop. = tally #8 / tally #4 (see tally

handout)– By race-origin categories in IRS exemption data


2. Calculate final county intrastate ins by multiplying proportions by state intrastate migration data

57

County Characteristics: County Summary1. Calculate preliminary population estimates



migration


a. State ASRO estimatesb. County totals estimates


58

Characteristics Estimates: Comparison of the Methods

• Processing universes• Controls• Processing components• Base population• Estimated births• Estimated deaths• Estimated migration• Use of Medicare data

59

Issues for the Future: General

• Which universe(s) should we process in?• What is the best method for using rates in

the estimates?• What are the appropriate geographic and

ASRO levels for projecting components of change?

• What is the best way to calculate domestic migration?

60

Issues for the Future: General (cont.)

• What is the best way to perform proportional distribution and controlled rounding?

• How should we estimate populations for which we have registries (school age population, 65+ population)?

61

Issues for the Future: General (cont.)

• How can we maximize the resources of FSCPE members?– Information on components of population

change?– Symptomatic indicators of population or

component change?– State-produced population estimates?– Input from review?

62

Issues for the Future: State Age-Sex

• Should we continue to process using the whole-interval approach?

• Should we process by sex as well as age?

63

Issues for the Future: State & County Characteristics

• Can we move from 1990 race based processing to 2000 race based processing?

• Will person-based IRS migration give us better estimates of domestic movement than return-based migration?

64

Issues for the Future: State & County Characteristics (cont.)

• Should we calculate intrastate migrants at the county level instead of calculating them at the state level and distributing to counties?

• Should we continue to use the previous vintage of estimates in intermediate processing?

state and county characteristics estimates a detailed description of the vintage 2003 methods and...

Documents