Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save JoeGermuska/6194706 to your computer and use it in GitHub Desktop.
Save JoeGermuska/6194706 to your computer and use it in GitHub Desktop.
All first column labels from Census, with count of occurrences. csvgrep -c 4 -r '^1$' acs2011_1yr_Sequence_Number_and_Table_Number_Lookup.csv | csvgrep -c 8 -r '^Total' -i | csvcut -c 8 | sort | uniq -c
1 "Aggregate interest, dividends, or net rental income in the past 12 months (in 2011 inflation-adjusted dollars)"
1 "Aggregate number of vehicles (car, truck, or van) used in commuting:"
1 Aggregate Social Security income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate Supplemental Security Income (SSI) in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate contract rent
1 Aggregate earnings in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate earnings in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate family income in the past 12 months (in 2011 inflation-adjusted dollars)
3 Aggregate family income in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate gross rent
4 Aggregate gross rent (dollars):
3 Aggregate gross rent:
10 Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
2 Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate income deficit in the past 12 months of unrelated individuals (dollars):
1 Aggregate income deficit in the past 12 months:
10 Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate number of rooms
3 Aggregate number of rooms:
1 Aggregate number of vehicles available:
1 Aggregate other types of income in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate price asked (dollars)
1 Aggregate public assistance income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate real estate taxes paid (dollars):
1 Aggregate rent asked
1 Aggregate retirement income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate selected monthly owner costs (dollars):
1 Aggregate self-employment income in the past 12 months (in 2011 inflation-adjusted dollars)
9 Aggregate travel time to work (in minutes):
1 Aggregate usual hours:
9 Aggregate value (dollars):
1 Aggregate wage or salary income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Gini Index
1 Initial addresses selected
1 Initial sample selected
1 Long Table Title
1 Lower contract rent quartile
1 Lower value quartile (dollars)
3 Lowest Quintile
10 Male
4 Male:
1 Median contract rent
10 Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Median gross rent
1 Median gross rent as a percentage of household income
10 Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Median monthly housing costs
10 Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Median number of rooms
2 Median value (dollars)
1 Median year structure built
10 Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
2 Response Rate
1 Upper contract rent quartile
1 Upper value quartile (dollars)
$ csvgrep -c 4 -r '^1$' acs2011_1yr_Sequence_Number_and_Table_Number_Lookup.csv | csvcut -c 8 | sort | uniq -c
1 "Aggregate interest, dividends, or net rental income in the past 12 months (in 2011 inflation-adjusted dollars)"
1 "Aggregate number of vehicles (car, truck, or van) used in commuting:"
1 Aggregate Social Security income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate Supplemental Security Income (SSI) in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate contract rent
1 Aggregate earnings in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate earnings in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate family income in the past 12 months (in 2011 inflation-adjusted dollars)
3 Aggregate family income in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate gross rent
4 Aggregate gross rent (dollars):
3 Aggregate gross rent:
10 Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
2 Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate income deficit in the past 12 months of unrelated individuals (dollars):
1 Aggregate income deficit in the past 12 months:
10 Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate number of rooms
3 Aggregate number of rooms:
1 Aggregate number of vehicles available:
1 Aggregate other types of income in the past 12 months (in 2011 inflation-adjusted dollars):
1 Aggregate price asked (dollars)
1 Aggregate public assistance income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate real estate taxes paid (dollars):
1 Aggregate rent asked
1 Aggregate retirement income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Aggregate selected monthly owner costs (dollars):
1 Aggregate self-employment income in the past 12 months (in 2011 inflation-adjusted dollars)
9 Aggregate travel time to work (in minutes):
1 Aggregate usual hours:
9 Aggregate value (dollars):
1 Aggregate wage or salary income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Gini Index
1 Initial addresses selected
1 Initial sample selected
1 Long Table Title
1 Lower contract rent quartile
1 Lower value quartile (dollars)
3 Lowest Quintile
10 Male
4 Male:
1 Median contract rent
10 Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Median gross rent
1 Median gross rent as a percentage of household income
10 Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Median monthly housing costs
10 Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
1 Median number of rooms
2 Median value (dollars)
1 Median year structure built
10 Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
2 Response Rate
8 Total
3 Total (dollars):
3 Total Groups Tallied:
42 Total living in area 1 year ago:
1 Total population in occupied housing units:
1267 Total:
1 Upper contract rent quartile
1 Upper value quartile (dollars)
(data)JLGPB:census-table-metadata germuska$
$ csvgrep -c 4 -r '^1$' acs2011_1yr_Sequence_Number_and_Table_Number_Lookup.csv | csvgrep -c 8 -r '^Total' -i | csvcut -c 2,8 | sort
B08013,Aggregate travel time to work (in minutes):
B08015,"Aggregate number of vehicles (car, truck, or van) used in commuting:"
B08131,Aggregate travel time to work (in minutes):
B08133,Aggregate travel time to work (in minutes):
B08135,Aggregate travel time to work (in minutes):
B08136,Aggregate travel time to work (in minutes):
B08536,Aggregate travel time to work (in minutes):
B12007,Male
B12007A,Male
B12007B,Male
B12007C,Male
B12007D,Male
B12007E,Male
B12007F,Male
B12007G,Male
B12007H,Male
B12007I,Male
B17008,Aggregate income deficit in the past 12 months of unrelated individuals (dollars):
B17011,Aggregate income deficit in the past 12 months:
B19013,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19013A,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19013B,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19013C,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19013D,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19013E,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19013F,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19013G,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19013H,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19013I,Median household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025A,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025B,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025C,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025D,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025E,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025F,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025G,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025H,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19025I,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19050,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars):
B19061,Aggregate earnings in the past 12 months (in 2011 inflation-adjusted dollars)
B19062,Aggregate wage or salary income in the past 12 months (in 2011 inflation-adjusted dollars)
B19063,Aggregate self-employment income in the past 12 months (in 2011 inflation-adjusted dollars)
B19064,"Aggregate interest, dividends, or net rental income in the past 12 months (in 2011 inflation-adjusted dollars)"
B19065,Aggregate Social Security income in the past 12 months (in 2011 inflation-adjusted dollars)
B19066,Aggregate Supplemental Security Income (SSI) in the past 12 months (in 2011 inflation-adjusted dollars)
B19067,Aggregate public assistance income in the past 12 months (in 2011 inflation-adjusted dollars)
B19069,Aggregate retirement income in the past 12 months (in 2011 inflation-adjusted dollars)
B19070,Aggregate other types of income in the past 12 months (in 2011 inflation-adjusted dollars):
B19080,Lowest Quintile
B19081,Lowest Quintile
B19082,Lowest Quintile
B19083,Gini Index
B19113,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19113A,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19113B,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19113C,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19113D,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19113E,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19113F,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19113G,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19113H,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19113I,Median family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19127,Aggregate family income in the past 12 months (in 2011 inflation-adjusted dollars)
B19128,Aggregate family income in the past 12 months (in 2011 inflation-adjusted dollars):
B19129,Aggregate family income in the past 12 months (in 2011 inflation-adjusted dollars):
B19130,Aggregate family income in the past 12 months (in 2011 inflation-adjusted dollars):
B19202,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19202A,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19202B,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19202C,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19202D,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19202E,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19202F,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19202G,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19202H,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19202I,Median nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19214,Aggregate nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars)
B19216,Aggregate nonfamily household income in the past 12 months (in 2011 inflation-adjusted dollars):
B19301,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19301A,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19301B,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19301C,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19301D,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19301E,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19301F,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19301G,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19301H,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19301I,Per capita income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313A,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313B,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313C,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313D,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313E,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313F,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313G,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313H,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B19313I,Aggregate income in the past 12 months (in 2011 inflation-adjusted dollars)
B20003,Aggregate earnings in the past 12 months (in 2011 inflation-adjusted dollars):
B23018,Aggregate usual hours:
B24032,Male:
B24042,Male:
B24082,Male:
B24092,Male:
B25018,Median number of rooms
B25019,Aggregate number of rooms
B25022,Aggregate number of rooms:
B25023,Aggregate number of rooms:
B25035,Median year structure built
B25046,Aggregate number of vehicles available:
B25057,Lower contract rent quartile
B25058,Median contract rent
B25059,Upper contract rent quartile
B25060,Aggregate contract rent
B25062,Aggregate rent asked
B25064,Median gross rent
B25065,Aggregate gross rent
B25066,Aggregate gross rent:
B25067,Aggregate gross rent:
B25071,Median gross rent as a percentage of household income
B25076,Lower value quartile (dollars)
B25077,Median value (dollars)
B25078,Upper value quartile (dollars)
B25079,Aggregate value (dollars):
B25080,Aggregate value (dollars):
B25082,Aggregate value (dollars):
B25083,Median value (dollars)
B25086,Aggregate price asked (dollars)
B25089,Aggregate selected monthly owner costs (dollars):
B25090,Aggregate real estate taxes paid (dollars):
B25105,Median monthly housing costs
B25108,Aggregate value (dollars):
B25110,Aggregate value (dollars):
B25112,Aggregate gross rent (dollars):
B25114,Aggregate gross rent:
B25120,Aggregate household income in the past 12 months (in 2011 inflation-adjusted dollars):
B98001,Initial addresses selected
B98002,Initial sample selected
B98021,Response Rate
B98022,Response Rate
C08133,Aggregate travel time to work (in minutes):
C08136,Aggregate travel time to work (in minutes):
C08536,Aggregate travel time to work (in minutes):
C25023,Aggregate number of rooms:
C25066,Aggregate gross rent (dollars):
C25079,Aggregate value (dollars):
C25080,Aggregate value (dollars):
C25108,Aggregate value (dollars):
C25110,Aggregate value (dollars):
C25112,Aggregate gross rent (dollars):
C25114,Aggregate gross rent (dollars):
Table ID,Long Table Title
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment