Skip to content

Instantly share code, notes, and snippets.

@franknarf1
Created June 23, 2016 15:39
Show Gist options
  • Save franknarf1/90f9761ae4ba84f627bc7e9626298a0c to your computer and use it in GitHub Desktop.
Save franknarf1/90f9761ae4ba84f627bc7e9626298a0c to your computer and use it in GitHub Desktop.
US Census Geographic Comparison Table, first row
library(data.table)
DT = setDT(structure(list(Id = "310M100US10180", Id2 = 10180L, Geography = "Abilene, TX Metro Area",
`RECORD CODES - File Identification` = "UR1US", `RECORD CODES - State/US-Abbreviation (USPS)` = "US",
`RECORD CODES - Summary Level` = 310L, `RECORD CODES - Geographic Component` = 0L,
`RECORD CODES - Characteristic Iteration` = 0L, `RECORD CODES - Characteristic Iteration File Sequence Number` = NA,
`RECORD CODES - Logical Record Number` = 407913L, `GEOGRAPHIC AREA CODES - Region` = NA,
`GEOGRAPHIC AREA CODES - Division` = NA, `GEOGRAPHIC AREA CODES - State (FIPS)` = NA,
`GEOGRAPHIC AREA CODES - County` = NA, `GEOGRAPHIC AREA CODES - FIPS County Class Code` = NA,
`GEOGRAPHIC AREA CODES - County Size Code` = NA, `GEOGRAPHIC AREA CODES - County Subdivision (FIPS)` = NA,
`GEOGRAPHIC AREA CODES - FIPS County Subdivision Class Code` = NA,
`GEOGRAPHIC AREA CODES - County Subdivision Size Code` = NA,
`GEOGRAPHIC AREA CODES - Place (FIPS)` = NA, `GEOGRAPHIC AREA CODES - FIPS Place Class Code` = NA,
`GEOGRAPHIC AREA CODES - Place Size Code` = NA, `GEOGRAPHIC AREA CODES - Census Tract` = NA,
`GEOGRAPHIC AREA CODES - Block Group` = NA, `GEOGRAPHIC AREA CODES - Block` = NA,
`GEOGRAPHIC AREA CODES - Internal Use Code` = NA, `GEOGRAPHIC AREA CODES - Consolidated City (FIPS)` = NA,
`GEOGRAPHIC AREA CODES - FIPS Consolidated City Class Code` = NA,
`GEOGRAPHIC AREA CODES - Consolidated City Size Code` = NA,
`GEOGRAPHIC AREA CODES - American Indian Area/Alaska Native Area/Hawaiian Home Land (Census)` = NA,
`GEOGRAPHIC AREA CODES - American Indian Area/Alaska Native Area/Hawaiian Home Land (FIPS)` = NA,
`GEOGRAPHIC AREA CODES - FIPS American Indian Area/Alaska Native Area/Hawaiian Home Land Class Code` = NA,
`GEOGRAPHIC AREA CODES - American Indian Trust Land/Hawaiian Home Land Indicator` = NA,
`GEOGRAPHIC AREA CODES - American Indian Tribal Subdivision (Census)` = NA,
`GEOGRAPHIC AREA CODES - American Indian Tribal Subdivision (FIPS)` = NA,
`GEOGRAPHIC AREA CODES - FIPS American Indian Tribal Subdivision Class Code` = NA,
`GEOGRAPHIC AREA CODES - Tribal Census Tract` = NA, `GEOGRAPHIC AREA CODES - Tribal Block Group` = NA,
`GEOGRAPHIC AREA CODES - Alaska Native Regional Corporation (FIPS)` = NA,
`GEOGRAPHIC AREA CODES - FIPS Alaska Native Regional Corporation Class Code` = NA,
`GEOGRAPHIC AREA CODES - Metropolitan Statistical Area/Micropolitan Statistical Area` = 10180L,
`GEOGRAPHIC AREA CODES - Metropolitan Statistical Area/Micropolitan Statistical Area Size Code` = 18L,
`GEOGRAPHIC AREA CODES - Metropolitan Division` = NA, `GEOGRAPHIC AREA CODES - Combined Statistical Area` = 999L,
`GEOGRAPHIC AREA CODES - New England City and Town Area` = NA,
`GEOGRAPHIC AREA CODES - New England City and Town Area Size Code` = NA,
`GEOGRAPHIC AREA CODES - New England City and Town Area Division` = NA,
`GEOGRAPHIC AREA CODES - Combined New England City and Town Area` = NA,
`GEOGRAPHIC AREA CODES - Metropolitan Statistical Area/Micropolitan Statistical Area Principal City Indicator` = NA,
`GEOGRAPHIC AREA CODES - New England City and Town Area Principal City Indicator` = NA,
`GEOGRAPHIC AREA CODES - Urban Area` = NA, `GEOGRAPHIC AREA CODES - Urban Area Size Code` = NA,
`GEOGRAPHIC AREA CODES - Urban Area Type` = NA, `GEOGRAPHIC AREA CODES - Urban/Rural` = NA,
`GEOGRAPHIC AREA CODES - Congressional District (111th)` = NA,
`GEOGRAPHIC AREA CODES - State Legislative District (Upper Chamber) (Year 1)` = NA,
`GEOGRAPHIC AREA CODES - State Legislative District (Lower Chamber) (Year 1)` = NA,
`GEOGRAPHIC AREA CODES - Voting District` = NA, `GEOGRAPHIC AREA CODES - Voting District Indicator` = NA,
`GEOGRAPHIC AREA CODES - Reserved` = NA, `GEOGRAPHIC AREA CODES - ZIP Code Tabulation Area (5 digit)` = NA,
`GEOGRAPHIC AREA CODES - Subminor Civil Division (FIPS)` = NA,
`GEOGRAPHIC AREA CODES - FIPS Subminor Civil Division Class Code` = NA,
`GEOGRAPHIC AREA CODES - School District (Elementary)` = NA,
`GEOGRAPHIC AREA CODES - School District (Secondary)` = NA,
`GEOGRAPHIC AREA CODES - School District (Unified)` = NA,
`AREA CHARACTERISTICS - Area (Land)` = structure(3.51062064917404e-314, class = "integer64"),
`AREA CHARACTERISTICS - Area (Water)` = structure(1.8205961839788e-316, class = "integer64"),
`AREA CHARACTERISTICS - Area Name-Legal/Statistical Area Description (LSAD) Term-Part Indicator` = "Abilene, TX Metro Area",
`AREA CHARACTERISTICS - Functional Status Code` = "S", `AREA CHARACTERISTICS - Geographic Change User Note Indicator` = NA,
`AREA CHARACTERISTICS - Population Count (100%)` = 165252L,
`AREA CHARACTERISTICS - Housing Unit Count (100%)` = 69721L,
`AREA CHARACTERISTICS - Internal Point (Latitude)` = 32.4520222,
`AREA CHARACTERISTICS - Internal Point (Longitude)` = -99.7187428,
`AREA CHARACTERISTICS - Legal/Statistical Area Description Code` = "M1",
`AREA CHARACTERISTICS - Part Flag` = NA, `SPECIAL AREA CODES - Reserved` = NA,
`SPECIAL AREA CODES - Urban Growth Area` = NA, `SPECIAL AREA CODES - State (ANSI)` = NA,
`SPECIAL AREA CODES - County (ANSI)` = NA, `SPECIAL AREA CODES - County Subdivision (ANSI)` = NA,
`SPECIAL AREA CODES - Place (ANSI)` = NA, `SPECIAL AREA CODES - Consolidated City (ANSI)` = NA,
`SPECIAL AREA CODES - American Indian Area/Alaska Native Area/Hawaiian Home Land (ANSI)` = NA,
`SPECIAL AREA CODES - American Indian Tribal Subdivision (ANSI)` = NA,
`SPECIAL AREA CODES - Alaska Native Regional Corporation (ANSI)` = NA,
`SPECIAL AREA CODES - Subminor Civil Division (ANSI)` = NA,
`SPECIAL AREA CODES - Congressional District (113th)` = NA,
`SPECIAL AREA CODES - Congressional District (114th)` = NA,
`SPECIAL AREA CODES - Congressional District (115th)` = NA,
`SPECIAL AREA CODES - State Legislative District (Upper Chamber) (Year 2)` = NA,
`SPECIAL AREA CODES - State Legislative District (Upper Chamber) (Year 3)` = NA,
`SPECIAL AREA CODES - State Legislative District (Upper Chamber) (Year 4)` = NA,
`SPECIAL AREA CODES - State Legislative District (Lower Chamber) (Year 2)` = NA,
`SPECIAL AREA CODES - State Legislative District (Lower Chamber) (Year 3)` = NA,
`SPECIAL AREA CODES - State Legislative District (Lower Chamber) (Year 4)` = NA,
`SPECIAL AREA CODES - American Indian Area/Alaska Native Area/Hawaiian Home Land Size Code` = NA,
`SPECIAL AREA CODES - Combined Statistical Area Size Code` = 0L,
`SPECIAL AREA CODES - Combined NECTA Size Code` = NA, `SPECIAL AREA CODES - Metropolitan Micropolitan Indicator` = 1L,
`SPECIAL AREA CODES - NECTA Metropolitan Micropolitan Indicator` = NA,
`SPECIAL AREA CODES - Public Use Microdata Area` = NA, `SPECIAL AREA CODES - Reserved` = NA), .Names = c("Id",
"Id2", "Geography", "RECORD CODES - File Identification", "RECORD CODES - State/US-Abbreviation (USPS)",
"RECORD CODES - Summary Level", "RECORD CODES - Geographic Component",
"RECORD CODES - Characteristic Iteration", "RECORD CODES - Characteristic Iteration File Sequence Number",
"RECORD CODES - Logical Record Number", "GEOGRAPHIC AREA CODES - Region",
"GEOGRAPHIC AREA CODES - Division", "GEOGRAPHIC AREA CODES - State (FIPS)",
"GEOGRAPHIC AREA CODES - County", "GEOGRAPHIC AREA CODES - FIPS County Class Code",
"GEOGRAPHIC AREA CODES - County Size Code", "GEOGRAPHIC AREA CODES - County Subdivision (FIPS)",
"GEOGRAPHIC AREA CODES - FIPS County Subdivision Class Code",
"GEOGRAPHIC AREA CODES - County Subdivision Size Code", "GEOGRAPHIC AREA CODES - Place (FIPS)",
"GEOGRAPHIC AREA CODES - FIPS Place Class Code", "GEOGRAPHIC AREA CODES - Place Size Code",
"GEOGRAPHIC AREA CODES - Census Tract", "GEOGRAPHIC AREA CODES - Block Group",
"GEOGRAPHIC AREA CODES - Block", "GEOGRAPHIC AREA CODES - Internal Use Code",
"GEOGRAPHIC AREA CODES - Consolidated City (FIPS)", "GEOGRAPHIC AREA CODES - FIPS Consolidated City Class Code",
"GEOGRAPHIC AREA CODES - Consolidated City Size Code", "GEOGRAPHIC AREA CODES - American Indian Area/Alaska Native Area/Hawaiian Home Land (Census)",
"GEOGRAPHIC AREA CODES - American Indian Area/Alaska Native Area/Hawaiian Home Land (FIPS)",
"GEOGRAPHIC AREA CODES - FIPS American Indian Area/Alaska Native Area/Hawaiian Home Land Class Code",
"GEOGRAPHIC AREA CODES - American Indian Trust Land/Hawaiian Home Land Indicator",
"GEOGRAPHIC AREA CODES - American Indian Tribal Subdivision (Census)",
"GEOGRAPHIC AREA CODES - American Indian Tribal Subdivision (FIPS)",
"GEOGRAPHIC AREA CODES - FIPS American Indian Tribal Subdivision Class Code",
"GEOGRAPHIC AREA CODES - Tribal Census Tract", "GEOGRAPHIC AREA CODES - Tribal Block Group",
"GEOGRAPHIC AREA CODES - Alaska Native Regional Corporation (FIPS)",
"GEOGRAPHIC AREA CODES - FIPS Alaska Native Regional Corporation Class Code",
"GEOGRAPHIC AREA CODES - Metropolitan Statistical Area/Micropolitan Statistical Area",
"GEOGRAPHIC AREA CODES - Metropolitan Statistical Area/Micropolitan Statistical Area Size Code",
"GEOGRAPHIC AREA CODES - Metropolitan Division", "GEOGRAPHIC AREA CODES - Combined Statistical Area",
"GEOGRAPHIC AREA CODES - New England City and Town Area", "GEOGRAPHIC AREA CODES - New England City and Town Area Size Code",
"GEOGRAPHIC AREA CODES - New England City and Town Area Division",
"GEOGRAPHIC AREA CODES - Combined New England City and Town Area",
"GEOGRAPHIC AREA CODES - Metropolitan Statistical Area/Micropolitan Statistical Area Principal City Indicator",
"GEOGRAPHIC AREA CODES - New England City and Town Area Principal City Indicator",
"GEOGRAPHIC AREA CODES - Urban Area", "GEOGRAPHIC AREA CODES - Urban Area Size Code",
"GEOGRAPHIC AREA CODES - Urban Area Type", "GEOGRAPHIC AREA CODES - Urban/Rural",
"GEOGRAPHIC AREA CODES - Congressional District (111th)", "GEOGRAPHIC AREA CODES - State Legislative District (Upper Chamber) (Year 1)",
"GEOGRAPHIC AREA CODES - State Legislative District (Lower Chamber) (Year 1)",
"GEOGRAPHIC AREA CODES - Voting District", "GEOGRAPHIC AREA CODES - Voting District Indicator",
"GEOGRAPHIC AREA CODES - Reserved", "GEOGRAPHIC AREA CODES - ZIP Code Tabulation Area (5 digit)",
"GEOGRAPHIC AREA CODES - Subminor Civil Division (FIPS)", "GEOGRAPHIC AREA CODES - FIPS Subminor Civil Division Class Code",
"GEOGRAPHIC AREA CODES - School District (Elementary)", "GEOGRAPHIC AREA CODES - School District (Secondary)",
"GEOGRAPHIC AREA CODES - School District (Unified)", "AREA CHARACTERISTICS - Area (Land)",
"AREA CHARACTERISTICS - Area (Water)", "AREA CHARACTERISTICS - Area Name-Legal/Statistical Area Description (LSAD) Term-Part Indicator",
"AREA CHARACTERISTICS - Functional Status Code", "AREA CHARACTERISTICS - Geographic Change User Note Indicator",
"AREA CHARACTERISTICS - Population Count (100%)", "AREA CHARACTERISTICS - Housing Unit Count (100%)",
"AREA CHARACTERISTICS - Internal Point (Latitude)", "AREA CHARACTERISTICS - Internal Point (Longitude)",
"AREA CHARACTERISTICS - Legal/Statistical Area Description Code",
"AREA CHARACTERISTICS - Part Flag", "SPECIAL AREA CODES - Reserved",
"SPECIAL AREA CODES - Urban Growth Area", "SPECIAL AREA CODES - State (ANSI)",
"SPECIAL AREA CODES - County (ANSI)", "SPECIAL AREA CODES - County Subdivision (ANSI)",
"SPECIAL AREA CODES - Place (ANSI)", "SPECIAL AREA CODES - Consolidated City (ANSI)",
"SPECIAL AREA CODES - American Indian Area/Alaska Native Area/Hawaiian Home Land (ANSI)",
"SPECIAL AREA CODES - American Indian Tribal Subdivision (ANSI)",
"SPECIAL AREA CODES - Alaska Native Regional Corporation (ANSI)",
"SPECIAL AREA CODES - Subminor Civil Division (ANSI)", "SPECIAL AREA CODES - Congressional District (113th)",
"SPECIAL AREA CODES - Congressional District (114th)", "SPECIAL AREA CODES - Congressional District (115th)",
"SPECIAL AREA CODES - State Legislative District (Upper Chamber) (Year 2)",
"SPECIAL AREA CODES - State Legislative District (Upper Chamber) (Year 3)",
"SPECIAL AREA CODES - State Legislative District (Upper Chamber) (Year 4)",
"SPECIAL AREA CODES - State Legislative District (Lower Chamber) (Year 2)",
"SPECIAL AREA CODES - State Legislative District (Lower Chamber) (Year 3)",
"SPECIAL AREA CODES - State Legislative District (Lower Chamber) (Year 4)",
"SPECIAL AREA CODES - American Indian Area/Alaska Native Area/Hawaiian Home Land Size Code",
"SPECIAL AREA CODES - Combined Statistical Area Size Code", "SPECIAL AREA CODES - Combined NECTA Size Code",
"SPECIAL AREA CODES - Metropolitan Micropolitan Indicator", "SPECIAL AREA CODES - NECTA Metropolitan Micropolitan Indicator",
"SPECIAL AREA CODES - Public Use Microdata Area", "SPECIAL AREA CODES - Reserved"
), class = "data.frame", row.names = c(NA, -1L)))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment