Last active
December 20, 2015 20:59
-
-
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
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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$ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
$ 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