Skip to content
This repository

Tables H17a-H17i #138

Open
tommeagher opened this Issue · 4 comments

2 participants

Tom Meagher Joe Germuska
Tom Meagher

I noticed that the crosswalk between 2000 and 2010 data doesn't appear to be working for tables H17a through H17i on census.ire.org.
The 2000 data and delta and % change is appearing for table H17 (which maps to table H16 in 2000). But the subtables H17a through H17i are only showing the 2010 data and not the corresponding fields from 2000 tables H16a through H16i.

Joe Germuska
Collaborator

Thanks for identifying this, Tom. This is probabably mostly simple communication error: we collected a list of cross-references from the two censuses and perhaps it was assumed that we'd map all of the iterative tables, but the literal minded coders didn't notice...

Unfortunately, the process of correcting for this would require either repeating the entire data load process, which takes several days across all fifty states, or making some adjustments to the loader to target specific tables. I'm not going to have any time to work on that this week, and i might wish that we find any other similar adjustments before we repeat the load process, to minimize the likelihood of doing that whole thing again. Unsurprisingly, we didn't design for doing it over-and-over, and that's turned out to be mildly annoying.

Anyway, we'll have this issue here for now, and this is a clue to investigate any other cross-references that have iterative tables too... thanks.

Joe Germuska
Collaborator

A brief review suggests that none of the comparables were migrated to the iterated subtables. So at some point we need to collect that complete list and fix 'em all.

Tom Meagher

Joe,
It appears that you are correct that none of the 2000 data made it into any of the subtables in the app.
So I took the Census SF-1 table crosswalk and checked it against the IRE app and the 2000 docs.
I pulled the list below of all the tables missing 2000 data in the app from the crosswalk. It includes the name of the 2010 subtable, the name of the comparable 2000 subtable and comments/questions on one table.

I hope this helps, Tom

2010tables,2000tables,comments
P12A,P12A,
P12B,P12B,
P12C,P12C,
P12D,P12D,
P12E,P12E,
P12F,P12F,
P12G,P12G,
P12H,P12H,
P12I,P12I,
P13A,P13A,
P13B,P13B,
P13C,P13C,
P13D,P13D,
P13E,P13E,
P13F,P13F,
P13G,P13G,
P13H,P13H,
P13I,P13I,
PCT12A,PCT12A,
PCT12B,PCT12B,
PCT12C,PCT12C,
PCT12D,PCT12D,
PCT12E,PCT12E,
PCT12F,PCT12F,
PCT12G,PCT12G,
PCT12H,PCT12H,
PCT12I,PCT12I,
PCT12J,PCT12J,
PCT12K,PCT12K,
PCT12L,PCT12L,
PCT12M,PCT12M,
PCT12N,PCT12N,
PCT12O,PCT12O,
PCT13A,PCT13A,
PCT13B,PCT13B,
PCT13C,PCT13C,
PCT13D,PCT13D,
PCT13E,PCT13E,
PCT13F,PCT13F,
PCT13G,PCT13G,
PCT13H,PCT13H,
PCT13I,PCT13I,
P29A,P27,
P29B,P27,
P29C,P27,
P29D,P27,
P29E,P27,
P29F,P27,
P29G,P27,
P29H,P27,
P29I,P27,
P31A,P28A,
P31B,P28B,
P31C,P28C,
P31D,P28D,
P31E,P28E,
P31F,P28F,
P31G,P28G,
P31H,P28H,
P31I,P28I,
P34A,P30A,
P34B,P30B,
P34C,P30C,
P34D,P30D,
P34E,P30E,
P34F,P30F,
P34G,P30G,
P34H,P30H,
P34I,P30I,
PCT19A,PCT15A,
PCT19B,PCT15B,
PCT19C,PCT15C,
PCT19D,PCT15D,
PCT19E,PCT15E,
PCT19F,PCT15F,
PCT19G,PCT15G,
PCT19H,PCT15H,
PCT19I,PCT15I,
P16A,P16A,'Where does this p16002 in main table come from?'
P16B,P16B,'Where does this p16002 in main table come from?'
P16C,P16C,'Where does this p16002 in main table come from?'
P16D,P16D,'Where does this p16002 in main table come from?'
P16E,P16E,'Where does this p16002 in main table come from?'
P16F,P16F,'Where does this p16002 in main table come from?'
P16G,P16G,'Where does this p16002 in main table come from?'
P16H,P16H,'Where does this p16002 in main table come from?'
P16I,P16I,'Where does this p16002 in main table come from?'
P17A,P17A,
P17B,P17B,
P17C,P17C,
P17D,P17D,
P17E,P17E,
P17F,P17F,
P17G,P17G,
P17H,P17H,
P17I,P17I,
P28A,P26A,
P28B,P26B,
P28C,P26C,
P28D,P26D,
P28E,P26E,
P28F,P26F,
P28G,P26G,
P28H,P26H,
P28I,P26I,
H12A,H12A,
H12B,H12B,
H12C,H12C,
H12D,H12D,
H12E,H12E,
H12F,H12F,
H12G,H12G,
H12H,H12H,
H12I,H12I,
P35A,P31A,
P35B,P31B,
P35C,P31C,
P35D,P31D,
P35E,P31E,
P35F,P31F,
P35G,P31G,
P35H,P31H,
P35I,P31I,
P36A,P32A,
P36B,P32B,
P36C,P32C,
P36D,P32D,
P36E,P32E,
P36F,P32F,
P36G,P32G,
P36H,P32H,
P36I,P32I,
P37A,P33A,
P37B,P33B,
P37C,P33C,
P37D,P33D,
P37E,P33E,
P37F,P33F,
P37G,P33G,
P37H,P33H,
P37I,P33I,
P38A,P34A,
P38B,P34B,
P38C,P34C,
P38D,P34D,
P38E,P34E,
P38F,P34F,
P38G,P34G,
P38H,P34H,
P38I,P34I,
P39A,P35A,
P39B,P35B,
P39C,P35C,
P39D,P35D,
P39E,P35E,
P39F,P35F,
P39G,P35G,
P39H,P35H,
P39I,P35I,
H11A,H11A,
H11B,H11B,
H11C,H11C,
H11D,H11D,
H11E,H11E,
H11F,H11F,
H11G,H11G,
H11H,H11H,
H11I,H11I,
H16A,H15A,
H16B,H15B,
H16C,H15C,
H16D,H15D,
H16E,H15E,
H16F,H15F,
H16G,H15G,
H16H,H15H,
H16I,H15I,
H17A,H16A,
H17B,H16B,
H17C,H16C,
H17D,H16D,
H17E,H16E,
H17F,H16F,
H17G,H16G,
H17H,H16H,
H17I,H16I,

Tom Meagher

Just noticed these lines lost their letter designations:

P29A,P27A,
P29B,P27B,
P29C,P27C,
P29D,P27D,
P29E,P27E,
P29F,P27F,
P29G,P27G,
P29H,P27H,
P29I,P27I,

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.