Preface |
|
xvii | |
Acknowledgments |
|
xix | |
About the Author |
|
xxi | |
Introduction |
|
xxii | |
|
|
xxii | |
|
|
xxiv | |
|
|
xxvi | |
|
Spreadsheet: LibreOffice® Calc 6 |
|
|
xxvi | |
|
|
xxvii | |
|
Geographic Information Systems: OGIS 3 |
|
|
xxvii | |
|
|
xxviii | |
Part I Census Fundamentals |
|
1 | (130) |
|
Chapter 1 Placing the Census in Context |
|
|
2 | (20) |
|
|
2 | (2) |
|
1.2 Applications of Census Data |
|
|
4 | (3) |
|
1.3 Role of the Census in American Society |
|
|
7 | (4) |
|
1.4 Criticism of the Census |
|
|
11 | (3) |
|
1.5 The Census Within the Data Universe |
|
|
14 | (7) |
|
The Federal Statistical System |
|
|
14 | (2) |
|
|
16 | (1) |
|
|
17 | (4) |
|
1.6 Conclusion and Next Steps |
|
|
21 | (1) |
|
Chapter 2 Dive Into the Data |
|
|
22 | (24) |
|
2.1 Introducing data.census.gov |
|
|
22 | (2) |
|
A New Way to Explore the Census |
|
|
23 | (1) |
|
The Census Bureau's Website |
|
|
23 | (1) |
|
|
24 | (1) |
|
2.2 First Steps in Data Exploration |
|
|
24 | (7) |
|
Tool Overview and Topical Search |
|
|
25 | (3) |
|
Profiles: Portraits of Places |
|
|
28 | (3) |
|
2.3 Chart a Clear Path With Advanced Search |
|
|
31 | (9) |
|
Advanced Search and Table Types |
|
|
31 | (4) |
|
Downloading and Importing Data |
|
|
35 | (3) |
|
Follow the Path for Advanced Search |
|
|
38 | (2) |
|
InfoBox 2.1 Alternate Search Strategy: Search By Table ID |
|
|
39 | (1) |
|
2.4 Other Sources for Census Data |
|
|
40 | (4) |
|
Missouri Census Data Center |
|
|
40 | (1) |
|
|
41 | (1) |
|
National Historical Geograhic Information System |
|
|
42 | (1) |
|
State and Local Governments |
|
|
42 | (2) |
|
2.5 Census Research Reports |
|
|
44 | (1) |
|
2.6 Review Questions and Practice Exercises |
|
|
45 | (1) |
|
Chapter 3 Census Geography |
|
|
46 | (37) |
|
|
46 | (2) |
|
3.2 Census Geography Hierarchy |
|
|
48 | (3) |
|
|
51 | (10) |
|
|
51 | (1) |
|
|
52 | (1) |
|
|
53 | (1) |
|
|
54 | (2) |
|
|
56 | (3) |
|
InfoBox 3.1 County Exceptions And Quirks |
|
|
57 | (2) |
|
|
59 | (1) |
|
|
59 | (1) |
|
Fitting the Pieces Together |
|
|
60 | (1) |
|
3.4 Exploring Census Geography With TIGERweb |
|
|
61 | (4) |
|
3.5 Other Geographies: The Branches |
|
|
65 | (14) |
|
Places and County Subdivisions |
|
|
66 | (4) |
|
ZIP Codes, ZCTAs, and PUMAS |
|
|
70 | (2) |
|
Urban/Rural Status and Metropolitan Areas |
|
|
72 | (6) |
|
|
78 | (1) |
|
|
79 | (1) |
|
|
79 | (2) |
|
|
81 | (1) |
|
3.8 Review Questions and Practice Exercises |
|
|
82 | (1) |
|
Chapter 4 Subject Characteristics |
|
|
83 | (48) |
|
|
83 | (1) |
|
|
84 | (2) |
|
4.3 Population Characteristics |
|
|
86 | (15) |
|
|
87 | (1) |
|
|
88 | (8) |
|
Households, Families, and Relationships |
|
|
96 | (4) |
|
|
100 | (1) |
|
4.4 Housing Unit Characteristics |
|
|
101 | (3) |
|
|
102 | (1) |
|
|
103 | (1) |
|
|
104 | (2) |
|
|
106 | (2) |
|
InfoBox 4.1 Derived Measures In The Census |
|
|
107 | (1) |
|
|
108 | (20) |
|
Exercise 1: Generational Categories and Introduction to the Calc Spreadsheet |
|
|
109 | (11) |
|
Exercise 2: Estimating Seasonal Populations and Basic Modeling With Calc |
|
|
120 | (12) |
|
InfoBox 4.2 Tips For Navigating Large Spreadsheets |
|
|
121 | (7) |
|
4.8 Review Questions and Practice Exercises |
|
|
128 | (3) |
Part II The Primary Datasets |
|
131 | (174) |
|
Chapter 5 The Decennial Census |
|
|
132 | (45) |
|
|
132 | (2) |
|
When Do You Use the Decennial Census? |
|
|
133 | (1) |
|
5.2 The Census in the 21st Century |
|
|
134 | (3) |
|
The Recent Past: 2000 Versus 2010 |
|
|
134 | (1) |
|
The Near Future: 2010 Versus 2020 |
|
|
135 | (2) |
|
5.3 The Data Collection Process |
|
|
137 | (7) |
|
|
137 | (2) |
|
|
139 | (4) |
|
InfoBox 5.1 The Homeless Population |
|
|
141 | (2) |
|
Postcensus Activities and Accuracy |
|
|
143 | (1) |
|
5.4 Decennial Census Data |
|
|
144 | (7) |
|
InfoBox 5.2 U.S. Territories And The Island Area Census |
|
|
146 | (1) |
|
|
147 | (1) |
|
InfoBox 5.3 Apportionment |
|
|
147 | (1) |
|
|
148 | (3) |
|
|
151 | (1) |
|
|
151 | (1) |
|
|
151 | (24) |
|
Exercise 1: Relating Group Quarters and Rural Categories With Calc |
|
|
152 | (7) |
|
Exercise 2: Relating Group Quarters and Rural Categories With SQLite |
|
|
159 | (16) |
|
InfoBox 5.4 SQL Where Clause |
|
|
174 | (1) |
|
Supplemental Exercise: Accessing Data in Bulk via FTP |
|
|
175 | (1) |
|
5.6 Review Questions and Practice Exercises |
|
|
175 | (2) |
|
Chapter 6 The American Community Survey |
|
|
177 | (45) |
|
|
177 | (2) |
|
|
178 | (1) |
|
6.2 Fundamentals of the ACS |
|
|
179 | (10) |
|
|
179 | (1) |
|
Sampling and Estimate Creation |
|
|
180 | (2) |
|
Interpreting Period Estimates |
|
|
182 | (3) |
|
|
185 | (4) |
|
|
189 | (6) |
|
InfoBox 6.1 Tools For Working With ACS Formulas |
|
|
190 | (5) |
|
|
195 | (25) |
|
InfoBox 6.2 What's Not In The Census |
|
|
196 | (1) |
|
Exercise 1: Aggregating Tract-level Estimates to Neighborhoods With Calc |
|
|
197 | (15) |
|
InfoBox 6.3 Calculating Change Over Time |
|
|
210 | (2) |
|
Exercise 2: Creating Custom Extracts With Dexter and Using ACS Data in SQLite |
|
|
212 | (8) |
|
Supplemental Exercise: Ranking ACS Data and Testing for Statistical Difference |
|
|
220 | (1) |
|
6.5 Review Questions and Practice Exercises |
|
|
220 | (2) |
|
Chapter 7 Population Estimates Program |
|
|
222 | (24) |
|
|
222 | (2) |
|
|
223 | (1) |
|
|
224 | (2) |
|
InfoBox 7.1 Estimates And Projections For Other Countries |
|
|
226 | (1) |
|
7.3 PEP Datasets and Variables |
|
|
226 | (4) |
|
7.4 Applications for PEP Data |
|
|
230 | (4) |
|
|
234 | (11) |
|
Exercise 1: Studying Components of Change With Charts in Calc |
|
|
234 | (11) |
|
7.6 Review Questions and Practice Exercises |
|
|
245 | (1) |
|
Chapter 8 Business Datasets |
|
|
246 | (36) |
|
|
246 | (3) |
|
When Do You Use the Business Datasets? |
|
|
247 | (2) |
|
8.2 Navigating Industries With NAICS |
|
|
249 | (6) |
|
8.3 Data for Business Establishments |
|
|
255 | (13) |
|
|
255 | (1) |
|
|
256 | (2) |
|
InfoBox 8.1 Census Of Governments, Census Of Agriculture |
|
|
258 | (1) |
|
Accessing Data, Confidentiality, and Disclosure |
|
|
258 | (5) |
|
Using Industry Data to Study Places |
|
|
263 | (5) |
|
8.4 Labor Force Statistics |
|
|
268 | (2) |
|
|
270 | (10) |
|
Exercise 1: Measuring Advanced Industries by NAICS With Calc |
|
|
271 | (12) |
|
InfoBox 8.2 CBP And Economic Census Data In A Relational Database |
|
|
280 | (1) |
|
8.6 Review Questions and Practice Exercises |
|
|
280 | (2) |
|
Chapter 9 Integrating Census Data Into Research |
|
|
282 | (23) |
|
|
282 | (1) |
|
9.2 Writing With Census Data |
|
|
283 | (8) |
|
Weaving Census Data Into Your Writing |
|
|
283 | (5) |
|
The Census in Action: Examples in Research |
|
|
288 | (3) |
|
9.3 Making Geographic Decisions |
|
|
291 | (7) |
|
9.4 National Trends and Historical Context |
|
|
298 | (6) |
|
9.5 Review Questions and Practice Exercises |
|
|
304 | (1) |
Part III Advanced Topics |
|
305 | (101) |
|
Chapter 10 Mapping and GIS |
|
|
306 | (43) |
|
|
306 | (1) |
|
10.2 Creating Maps Online |
|
|
307 | (3) |
|
|
310 | (5) |
|
|
310 | (2) |
|
|
312 | (3) |
|
InfoBox 10.1 Generalization And Cartographic Boundary Shapefiles |
|
|
314 | (1) |
|
|
315 | (33) |
|
Vector Data in Shapefiles and CRS Basics |
|
|
317 | (2) |
|
InfoBox 10.2 Coordinate Reference Systems |
|
|
319 | (1) |
|
|
319 | (2) |
|
Adding and Overlaying Layers |
|
|
321 | (2) |
|
Creating Subsets of Layers, Reprojecting CRS, Saving Projects |
|
|
323 | (9) |
|
|
332 | (2) |
|
Joining Attributes and Mapping Data |
|
|
334 | (4) |
|
|
338 | (4) |
|
InfoBox 10.3 Add The Openstreetmap To Your Map |
|
|
342 | (1) |
|
|
342 | (4) |
|
InfoBox 10.4 Plotting Coordinate Data |
|
|
343 | (3) |
|
|
346 | (2) |
|
10.5 Review Questions and Practice Exercises |
|
|
348 | (1) |
|
Chapter 11 Census Data Derivatives |
|
|
349 | (26) |
|
|
349 | (1) |
|
11.2 Measures of Population Distribution |
|
|
350 | (8) |
|
|
350 | (1) |
|
|
351 | (2) |
|
|
353 | (3) |
|
|
356 | (1) |
|
|
357 | (1) |
|
11.3 Measures of Income and Inequality |
|
|
358 | (4) |
|
|
358 | (2) |
|
|
360 | (1) |
|
|
360 | (2) |
|
11.4 Means and Medians for Aggregates |
|
|
362 | (1) |
|
11.5 Geographic Derivatives |
|
|
363 | (10) |
|
Allocation and Apportionment |
|
|
363 | (5) |
|
|
368 | (3) |
|
InfoBox 11.1 Relating Zip Codes To ZCTAs And Other Places |
|
|
369 | (2) |
|
|
371 | (2) |
|
11.6 Review Questions and Practice Exercises |
|
|
373 | (2) |
|
Chapter 12 Historical Data and Microdata |
|
|
375 | (31) |
|
|
375 | (2) |
|
12.2 Historical Census Data |
|
|
377 | (14) |
|
Historical Considerations |
|
|
377 | (5) |
|
InfoBox 12.1 Historic Census Records For Individuals |
|
|
379 | (3) |
|
National Historic Geographic Information System |
|
|
382 | (5) |
|
|
387 | (4) |
|
|
391 | (11) |
|
InfoBox 12.2 Other Census Surveys And Estimates |
|
|
393 | (1) |
|
Current Population Survey |
|
|
393 | (1) |
|
IPUMS Current Population Survey |
|
|
394 | (6) |
|
Alternatives to IPUMS Extracts |
|
|
400 | (1) |
|
|
400 | (2) |
|
12.4 In Conclusion: What Next? |
|
|
402 | (3) |
|
InfoBox 12.3 The Census Bureau'S API |
|
|
404 | (1) |
|
12.5 Review Questions and Practice Exercises |
|
|
405 | (1) |
References |
|
406 | (9) |
Index |
|
415 | |