Advanced Query for Census 2000 Data Users

1
Advanced Query forCensus 2000 Data Users

• Jennifer Holland
• April 29, 2003
• State Data Center Regional Meeting

2
Value of Advanced Query

• Provides necessary tabulations for policy making
  that are not available in the summary files
• Produce millions of tabulations impossible to
  include in summary files
• Technology employed provides prospects for the
  future

3
Tabulations for Policy Makingnot in Summary File
3
4
Immigration

• Kentucky needs count of male non-citizens by
  employment status and educational attainment by
  county for jobs programs

5
Wage Disparities

• DC metropolitan area evaluation of income
  disparities between whites and blacks in
  government jobs

6
Real Estate Taxes

• California wants to determine tax burden on
  homeowners by comparing taxes to mortgage and
  income

7
Child Care

• Pennsylvania needs information on income of
  grandparents who are economically responsible for
  grandchildren in large cities

8
Housing Needs

• Housing authority in King county and Spokane,
  Washington need information for assessment of
  housing needs

9
Number of Tabulations Summary Files (SF)

• SF1 319
• 286 Detailed tables
• 16 Quick tables
• 17 GCTs
• SF2 Iterations 13,572
• 47 Detailed tables x 250
• 7 Quick tables x 250
• 8 GCTs x 9
• Total 100 percent tables
• 13,891 without population threshold

• SF3 860
• 813 Detailed tables
• 39 Quick tables
• 8 GCTs
• SF4 Iterations 120,326
• 323 Detailed tables x 336
• 7 Quick tables x 86
• 33 Quick tables x 336
• 12 GCTs x 9
• Total sample tables
• 121,186 without population threshold

10
Number of Possible Tabulations Advanced Query
(AQ)

• AQ 100 Percent Data
• 52 universes
• 28 characteristics
• 1-3 per tabulation
• Total number of tables
• 191,464 w/o filters

• AQ Sample Data
• 127 universes
• 200 characteristics
• 1- 3 per tabulation
• Total number of tables
• 158,686,500 w/o filters

11
Automated Disclosure Avoidance

• Approximately half of the AQ combinations will
  not
• pass the filters for the areas chosen. The system
• Limits what the user may select when creating a
  tabulation
• Examines each geographic area in the tabulation
  for scarcity before it is released
• Blocks dissemination of areas with sparse
  tabulations

12
Summary of Current Technology

• Create tabulations on the fly from microdata on
  the web
• Block sparse tables with automated disclosure
  avoidance filters
• Fast calculation and download

• Many download options EXCEL, CSV, HTML, Plain
  Text
• Ability to compute statistical measures
• Flexibility in table formats