(geo) peter@bronx ~/cmsc435/geotags/web-scraper/twitter $ psql scraping -c 'select count(*),state from reddit group by state order by count'
 count | state
-------+-------
   282 | NV
   565 | NY
   640 | ID
   659 | WY
   705 | NM
   914 | SD
   963 | ND
  1036 | MO
  1058 | IL
  1114 | NE
  1131 | UT
  1153 | TN
  1261 | WA
  1370 | GA
  1467 | WV
  1600 | RI
  1635 | MA
  1676 | AL
  1708 | KS
  1734 | AR
  1767 | MT
  1787 | VT
  1799 | KY
  1800 | SC
  1806 | MS
  1914 | LA
  1933 | VA
  2020 | NH
  2043 | DE
  2085 | IA
  2593 | AZ
  2629 | AK
  2659 | PA
  2703 | ME
  2824 | HI
  2900 | OH
  3031 | IN
  3075 | MD
  3572 | OR
  3966 | CO
  3987 | FL
  4116 | OK
  4302 | WI
  4680 | NC
  5223 | MN
  5250 | CT
  7150 | MI
  7460 | CA
  8424 | NJ
  8546 | TX
 10039 | DC
(51 rows)