library(dplyr)
## 
## Attaching package: 'dplyr'
## 
## The following objects are masked from 'package:stats':
## 
##     filter, lag
## 
## The following objects are masked from 'package:base':
## 
##     intersect, setdiff, setequal, union
library(tidyr)
library(historydata)
library(ggplot2)

data(sarna.csv)
## Warning: data set 'sarna.csv' not found
sarna 
## Source: local data frame [92 x 3]
## 
##    year        estimate     value
## 1  1660  population_low 5.000e+01
## 2  1700  population_low 2.000e+02
## 3  1776  population_low 1.000e+03
## 4  1790  population_low 1.300e+03
## 5  1800  population_low 2.500e+03
## 6  1820  population_low 2.650e+03
## 7  1830  population_low 4.000e+03
## 8  1840  population_low 1.500e+04
## 9  1850  population_low 5.000e+04
## 10 1860  population_low 1.250e+05
## 11 1880  population_low 2.300e+05
## 12 1890  population_low 4.000e+05
## 13 1900  population_low 9.380e+05
## 14 1910  population_low 1.508e+06
## 15 1920  population_low 3.300e+06
## 16 1930  population_low 4.228e+06
## 17 1940  population_low 4.771e+06
## 18 1950  population_low 4.500e+06
## 19 1960  population_low 5.367e+06
## 20 1970  population_low 5.370e+06
## 21 1980  population_low 5.500e+06
## 22 1990  population_low 5.515e+06
## 23 2000  population_low 5.340e+06
## 24 1660 population_high 5.000e+01
## 25 1700 population_high 3.000e+02
## 26 1776 population_high 2.500e+03
## 27 1790 population_high 3.000e+03
## 28 1800 population_high 2.500e+03
## 29 1820 population_high 3.000e+03
## 30 1830 population_high 6.000e+03
## 31 1840 population_high 1.500e+04
## 32 1850 population_high 5.000e+04
## 33 1860 population_high 2.000e+05
## 34 1880 population_high 3.000e+05
## 35 1890 population_high 4.750e+05
## 36 1900 population_high 1.058e+06
## 37 1910 population_high 2.044e+06
## 38 1920 population_high 3.600e+06
## 39 1930 population_high 4.400e+06
## 40 1940 population_high 4.831e+06
## 41 1950 population_high 5.000e+06
## 42 1960 population_high 5.531e+06
## 43 1970 population_high 6.000e+06
## 44 1980 population_high 5.921e+06
## 45 1990 population_high 5.981e+06
## 46 2000 population_high 6.155e+06
## 47 1660  percentage_low        NA
## 48 1700  percentage_low        NA
## 49 1776  percentage_low 4.000e-02
## 50 1790  percentage_low 3.000e-02
## 51 1800  percentage_low 4.000e-02
## 52 1820  percentage_low 3.000e-02
## 53 1830  percentage_low 3.000e-02
## 54 1840  percentage_low 9.000e-02
## 55 1850  percentage_low 2.200e-01
## 56 1860  percentage_low 4.000e-01
## 57 1880  percentage_low 4.600e-01
## 58 1890  percentage_low 6.400e-01
## 59 1900  percentage_low 1.230e+00
## 60 1910  percentage_low 1.630e+00
## 61 1920  percentage_low 3.120e+00
## 62 1930  percentage_low 3.440e+00
## 63 1940  percentage_low 3.630e+00
## 64 1950  percentage_low 2.980e+00
## 65 1960  percentage_low 2.990e+00
## 66 1970  percentage_low 2.640e+00
## 67 1980  percentage_low 2.420e+00
## 68 1990  percentage_low 2.240e+00
## 69 2000  percentage_low 1.900e+00
## 70 1660 percentage_high        NA
## 71 1700 percentage_high        NA
## 72 1776 percentage_high 1.000e-01
## 73 1790 percentage_high 8.000e-02
## 74 1800 percentage_high 4.000e-02
## 75 1820 percentage_high 3.000e-02
## 76 1830 percentage_high 5.000e-02
## 77 1840 percentage_high 9.000e-02
## 78 1850 percentage_high 2.200e-01
## 79 1860 percentage_high 6.300e-01
## 80 1880 percentage_high 6.000e-01
## 81 1890 percentage_high 7.500e-01
## 82 1900 percentage_high 1.390e+00
## 83 1910 percentage_high 2.220e+00
## 84 1920 percentage_high 3.410e+00
## 85 1930 percentage_high 3.580e+00
## 86 1940 percentage_high 3.680e+00
## 87 1950 percentage_high 3.310e+00
## 88 1960 percentage_high 3.080e+00
## 89 1970 percentage_high 2.950e+00
## 90 1980 percentage_high 2.610e+00
## 91 1990 percentage_high 2.430e+00
## 92 2000 percentage_high 2.200e+00
# this is the cleaned up sarna
# working off the original raw sarna
sarnaUntidy <- read.csv("historydata/data-raw/sarna.csv", stringsAsFactors = FALSE)
sarnaUntidy
##    year estimate_low estimate_high percentage_pop_low percentage_pop_high
## 1  1660           50            50                 NA                  NA
## 2  1700          200           300                 NA                  NA
## 3  1776         1000          2500               0.04                0.10
## 4  1790         1300          3000               0.03                0.08
## 5  1800         2500          2500               0.04                0.04
## 6  1820         2650          3000               0.03                0.03
## 7  1830         4000          6000               0.03                0.05
## 8  1840        15000         15000               0.09                0.09
## 9  1850        50000         50000               0.22                0.22
## 10 1860       125000        200000               0.40                0.63
## 11 1880       230000        300000               0.46                0.60
## 12 1890       400000        475000               0.64                0.75
## 13 1900       938000       1058000               1.23                1.39
## 14 1910      1508000       2044000               1.63                2.22
## 15 1920      3300000       3600000               3.12                3.41
## 16 1930      4228000       4400000               3.44                3.58
## 17 1940      4771000       4831000               3.63                3.68
## 18 1950      4500000       5000000               2.98                3.31
## 19 1960      5367000       5531000               2.99                3.08
## 20 1970      5370000       6000000               2.64                2.95
## 21 1980      5500000       5921000               2.42                2.61
## 22 1990      5515000       5981000               2.24                2.43
## 23 2000      5340000       6155000               1.90                2.20
sarnaUntidy <- sarnaUntidy %>%
  tbl_df() %>%
  select(year,
         population_low = estimate_low,
         population_high = estimate_high,
         percentage_low = percentage_pop_low,
         percentage_high = percentage_pop_high) %>%
  gather(estimate, counts, -year)
# THIS WORKED!
#trying something else now:
#summarize national population for each year from the raw data. 
#THIS WORKED!!

states <- read.csv("historydata/data-raw/nhgis0011_ts_state.csv", stringsAsFactors = FALSE)
states
##     GISJOIN YEAR                   STATE STATEA                  NAME
## 1      G090 1790             Connecticut     90           Connecticut
## 2      G100 1790                Delaware    100              Delaware
## 3      G130 1790                 Georgia    130               Georgia
## 4      G240 1790                Maryland    240              Maryland
## 5      G250 1790           Massachusetts    250         Massachusetts
## 6      G330 1790           New Hampshire    330         New Hampshire
## 7      G340 1790              New Jersey    340            New Jersey
## 8      G360 1790                New York    360              New York
## 9      G370 1790          North Carolina    370        North Carolina
## 10     G420 1790            Pennsylvania    420          Pennsylvania
## 11     G440 1790            Rhode Island    440          Rhode Island
## 12     G450 1790          South Carolina    450        South Carolina
## 13     G465 1790     Southwest Territory    465   Southwest Territory
## 14     G500 1790                 Vermont    500               Vermont
## 15     G510 1790                Virginia    510              Virginia
## 16     G090 1800             Connecticut     90           Connecticut
## 17     G100 1800                Delaware    100              Delaware
## 18     G110 1800    District Of Columbia    110  District of Columbia
## 19     G130 1800                 Georgia    130               Georgia
## 20     G185 1800       Indiana Territory    185     Indiana Territory
## 21     G210 1800                Kentucky    210              Kentucky
## 22     G240 1800                Maryland    240              Maryland
## 23     G250 1800           Massachusetts    250         Massachusetts
## 24     G285 1800   Mississippi Territory    285 Mississippi Territory
## 25     G330 1800           New Hampshire    330         New Hampshire
## 26     G340 1800              New Jersey    340            New Jersey
## 27     G360 1800                New York    360              New York
## 28     G370 1800          North Carolina    370        North Carolina
## 29     G385 1800     Northwest Territory    385   Northwest Territory
## 30     G420 1800            Pennsylvania    420          Pennsylvania
## 31     G440 1800            Rhode Island    440          Rhode Island
## 32     G450 1800          South Carolina    450        South Carolina
## 33     G470 1800               Tennessee    470             Tennessee
## 34     G500 1800                 Vermont    500               Vermont
## 35     G510 1800                Virginia    510              Virginia
## 36     G090 1810             Connecticut     90           Connecticut
## 37     G100 1810                Delaware    100              Delaware
## 38     G110 1810    District Of Columbia    110  District of Columbia
## 39     G130 1810                 Georgia    130               Georgia
## 40     G175 1810      Illinois Territory    175    Illinois Territory
## 41     G185 1810       Indiana Territory    185     Indiana Territory
## 42     G210 1810                Kentucky    210              Kentucky
## 43     G225 1810     Louisiana Territory    225   Louisiana Territory
## 44     G240 1810                Maryland    240              Maryland
## 45     G250 1810           Massachusetts    250         Massachusetts
## 46     G265 1810      Michigan Territory    265    Michigan Territory
## 47     G285 1810   Mississippi Territory    285 Mississippi Territory
## 48     G330 1810           New Hampshire    330         New Hampshire
## 49     G340 1810              New Jersey    340            New Jersey
## 50     G360 1810                New York    360              New York
## 51     G370 1810          North Carolina    370        North Carolina
## 52     G390 1810                    Ohio    390                  Ohio
## 53     G417 1810       Orleans Territory    417     Orleans Territory
## 54     G420 1810            Pennsylvania    420          Pennsylvania
## 55     G440 1810            Rhode Island    440          Rhode Island
## 56     G450 1810          South Carolina    450        South Carolina
## 57     G470 1810               Tennessee    470             Tennessee
## 58     G500 1810                 Vermont    500               Vermont
## 59     G510 1810                Virginia    510              Virginia
## 60     G010 1820                 Alabama     10               Alabama
## 61     G055 1820      Arkansas Territory     55    Arkansas Territory
## 62     G090 1820             Connecticut     90           Connecticut
## 63     G100 1820                Delaware    100              Delaware
## 64     G110 1820    District Of Columbia    110  District of Columbia
## 65     G130 1820                 Georgia    130               Georgia
## 66     G170 1820                Illinois    170              Illinois
## 67     G180 1820                 Indiana    180               Indiana
## 68     G210 1820                Kentucky    210              Kentucky
## 69     G220 1820               Louisiana    220            Louisianna
## 70     G230 1820                   Maine    230                 Maine
## 71     G240 1820                Maryland    240              Maryland
## 72     G250 1820           Massachusetts    250         Massachusetts
## 73     G265 1820      Michigan Territory    265    Michigan Territory
## 74     G280 1820             Mississippi    280           Mississippi
## 75     G295 1820      Missouri Territory    295    Missouri Territory
## 76     G330 1820           New Hampshire    330         New Hampshire
## 77     G340 1820              New Jersey    340            New Jersey
## 78     G360 1820                New York    360              New York
## 79     G370 1820          North Carolina    370        North Carolina
## 80     G390 1820                    Ohio    390                  Ohio
## 81     G420 1820            Pennsylvania    420          Pennsylvania
## 82     G440 1820            Rhode Island    440          Rhode Island
## 83     G450 1820          South Carolina    450        South Carolina
## 84     G470 1820               Tennessee    470             Tennessee
## 85     G500 1820                 Vermont    500               Vermont
## 86     G510 1820                Virginia    510              Virginia
## 87     G010 1830                 Alabama     10               Alabama
## 88     G055 1830      Arkansas Territory     55    Arkansas Territory
## 89     G090 1830             Connecticut     90           Connecticut
## 90     G100 1830                Delaware    100              Delaware
## 91     G110 1830    District Of Columbia    110  District of Columbia
## 92     G125 1830       Florida Territory    125     Florida Territory
## 93     G130 1830                 Georgia    130               Georgia
## 94     G170 1830                Illinois    170              Illinois
## 95     G180 1830                 Indiana    180               Indiana
## 96     G210 1830                Kentucky    210              Kentucky
## 97     G220 1830               Louisiana    220            Louisianna
## 98     G230 1830                   Maine    230                 Maine
## 99     G240 1830                Maryland    240              Maryland
## 100    G250 1830           Massachusetts    250         Massachusetts
## 101    G265 1830      Michigan Territory    265    Michigan Territory
## 102    G280 1830             Mississippi    280           Mississippi
## 103    G290 1830                Missouri    290              Missouri
## 104    G330 1830           New Hampshire    330         New Hampshire
## 105    G340 1830              New Jersey    340            New Jersey
## 106    G360 1830                New York    360              New York
## 107    G370 1830          North Carolina    370        North Carolina
## 108    G390 1830                    Ohio    390                  Ohio
## 109    G420 1830            Pennsylvania    420          Pennsylvania
## 110    G440 1830            Rhode Island    440          Rhode Island
## 111    G450 1830          South Carolina    450        South Carolina
## 112    G470 1830               Tennessee    470             Tennessee
## 113    G500 1830                 Vermont    500               Vermont
## 114    G510 1830                Virginia    510              Virginia
## 115    G010 1840                 Alabama     10               Alabama
## 116    G050 1840                Arkansas     50              Arkansas
## 117    G090 1840             Connecticut     90           Connecticut
## 118    G100 1840                Delaware    100              Delaware
## 119    G110 1840    District Of Columbia    110  District of Columbia
## 120    G125 1840       Florida Territory    125     Florida Territory
## 121    G130 1840                 Georgia    130               Georgia
## 122    G170 1840                Illinois    170              Illinois
## 123    G180 1840                 Indiana    180               Indiana
## 124    G195 1840          Iowa Territory    195        Iowa Territory
## 125    G210 1840                Kentucky    210              Kentucky
## 126    G220 1840               Louisiana    220            Louisianna
## 127    G230 1840                   Maine    230                 Maine
## 128    G240 1840                Maryland    240              Maryland
## 129    G250 1840           Massachusetts    250         Massachusetts
## 130    G260 1840                Michigan    260              Michigan
## 131    G280 1840             Mississippi    280           Mississippi
## 132    G290 1840                Missouri    290              Missouri
## 133    G330 1840           New Hampshire    330         New Hampshire
## 134    G340 1840              New Jersey    340            New Jersey
## 135    G360 1840                New York    360              New York
## 136    G370 1840          North Carolina    370        North Carolina
## 137    G390 1840                    Ohio    390                  Ohio
## 138    G420 1840            Pennsylvania    420          Pennsylvania
## 139    G440 1840            Rhode Island    440          Rhode Island
## 140    G450 1840          South Carolina    450        South Carolina
## 141    G470 1840               Tennessee    470             Tennessee
## 142    G500 1840                 Vermont    500               Vermont
## 143    G510 1840                Virginia    510              Virginia
## 144    G555 1840     Wisconsin Territory    555   Wisconsin Territory
## 145    G010 1850                 Alabama     10               Alabama
## 146    G050 1850                Arkansas     50              Arkansas
## 147    G060 1850              California     60            California
## 148    G090 1850             Connecticut     90           Connecticut
## 149    G100 1850                Delaware    100              Delaware
## 150    G110 1850    District Of Columbia    110  District of Columbia
## 151    G120 1850                 Florida    120               Florida
## 152    G130 1850                 Georgia    130               Georgia
## 153    G170 1850                Illinois    170              Illinois
## 154    G180 1850                 Indiana    180               Indiana
## 155    G190 1850                    Iowa    190                  Iowa
## 156    G210 1850                Kentucky    210              Kentucky
## 157    G220 1850               Louisiana    220            Louisianna
## 158    G230 1850                   Maine    230                 Maine
## 159    G240 1850                Maryland    240              Maryland
## 160    G250 1850           Massachusetts    250         Massachusetts
## 161    G260 1850                Michigan    260              Michigan
## 162    G275 1850     Minnesota Territory    275   Minnesota Territory
## 163    G280 1850             Mississippi    280           Mississippi
## 164    G290 1850                Missouri    290              Missouri
## 165    G330 1850           New Hampshire    330         New Hampshire
## 166    G340 1850              New Jersey    340            New Jersey
## 167    G355 1850    New Mexico Territory    355  New Mexico Territory
## 168    G360 1850                New York    360              New York
## 169    G370 1850          North Carolina    370        North Carolina
## 170    G390 1850                    Ohio    390                  Ohio
## 171    G413 1850        Oregon Territory    413      Oregon Territory
## 172    G420 1850            Pennsylvania    420          Pennsylvania
## 173    G440 1850            Rhode Island    440          Rhode Island
## 174    G450 1850          South Carolina    450        South Carolina
## 175    G470 1850               Tennessee    470             Tennessee
## 176    G480 1850                   Texas    480                 Texas
## 177    G495 1850          Utah Territory    495        Utah Territory
## 178    G500 1850                 Vermont    500               Vermont
## 179    G510 1850                Virginia    510              Virginia
## 180    G550 1850               Wisconsin    550             Wisconsin
## 181    G010 1860                 Alabama     10               Alabama
## 182    G050 1860                Arkansas     50              Arkansas
## 183    G060 1860              California     60            California
## 184    G085 1860      Colorado Territory     85    Colorado Territory
## 185    G090 1860             Connecticut     90           Connecticut
## 186    G095 1860        Dakota Territory     95      Dakota Territory
## 187    G100 1860                Delaware    100              Delaware
## 188    G110 1860    District Of Columbia    110  District of Columbia
## 189    G120 1860                 Florida    120               Florida
## 190    G130 1860                 Georgia    130               Georgia
## 191    G170 1860                Illinois    170              Illinois
## 192    G180 1860                 Indiana    180               Indiana
## 193    G190 1860                    Iowa    190                  Iowa
## 194    G205 1860        Kansas Territory    205      Kansas Territory
## 195    G210 1860                Kentucky    210              Kentucky
## 196    G220 1860               Louisiana    220            Louisianna
## 197    G230 1860                   Maine    230                 Maine
## 198    G240 1860                Maryland    240              Maryland
## 199    G250 1860           Massachusetts    250         Massachusetts
## 200    G260 1860                Michigan    260              Michigan
## 201    G270 1860               Minnesota    270             Minnesota
## 202    G280 1860             Mississippi    280           Mississippi
## 203    G290 1860                Missouri    290              Missouri
## 204    G315 1860      Nebraska Territory    315    Nebraska Territory
## 205    G325 1860        Nevada Territory    325      Nevada Territory
## 206    G330 1860           New Hampshire    330         New Hampshire
## 207    G340 1860              New Jersey    340            New Jersey
## 208    G355 1860    New Mexico Territory    355  New Mexico Territory
## 209    G360 1860                New York    360              New York
## 210    G370 1860          North Carolina    370        North Carolina
## 211    G390 1860                    Ohio    390                  Ohio
## 212    G410 1860                  Oregon    410                Oregon
## 213    G420 1860            Pennsylvania    420          Pennsylvania
## 214    G440 1860            Rhode Island    440          Rhode Island
## 215    G450 1860          South Carolina    450        South Carolina
## 216    G470 1860               Tennessee    470             Tennessee
## 217    G480 1860                   Texas    480                 Texas
## 218    G495 1860          Utah Territory    495        Utah Territory
## 219    G500 1860                 Vermont    500               Vermont
## 220    G510 1860                Virginia    510              Virginia
## 221    G535 1860    Washington Territory    535  Washington Territory
## 222    G550 1860               Wisconsin    550             Wisconsin
## 223    G010 1870                 Alabama     10               Alabama
## 224    G045 1870       Arizona Territory     45     Arizona Territory
## 225    G050 1870                Arkansas     50              Arkansas
## 226    G060 1870              California     60            California
## 227    G085 1870      Colorado Territory     85    Colorado Territory
## 228    G090 1870             Connecticut     90           Connecticut
## 229    G095 1870        Dakota Territory     95      Dakota Territory
## 230    G100 1870                Delaware    100              Delaware
## 231    G110 1870    District Of Columbia    110  District of Columbia
## 232    G120 1870                 Florida    120               Florida
## 233    G130 1870                 Georgia    130               Georgia
## 234    G165 1870         Idaho Territory    165       Idaho Territory
## 235    G170 1870                Illinois    170              Illinois
## 236    G180 1870                 Indiana    180               Indiana
## 237    G190 1870                    Iowa    190                  Iowa
## 238    G200 1870                  Kansas    200                Kansas
## 239    G210 1870                Kentucky    210              Kentucky
## 240    G220 1870               Louisiana    220            Louisianna
## 241    G230 1870                   Maine    230                 Maine
## 242    G240 1870                Maryland    240              Maryland
## 243    G250 1870           Massachusetts    250         Massachusetts
## 244    G260 1870                Michigan    260              Michigan
## 245    G270 1870               Minnesota    270             Minnesota
## 246    G280 1870             Mississippi    280           Mississippi
## 247    G290 1870                Missouri    290              Missouri
## 248    G305 1870       Montana Territory    305     Montana Territory
## 249    G310 1870                Nebraska    310              Nebraska
## 250    G320 1870                  Nevada    320                Nevada
## 251    G330 1870           New Hampshire    330         New Hampshire
## 252    G340 1870              New Jersey    340            New Jersey
## 253    G355 1870    New Mexico Territory    355  New Mexico Territory
## 254    G360 1870                New York    360              New York
## 255    G370 1870          North Carolina    370        North Carolina
## 256    G390 1870                    Ohio    390                  Ohio
## 257    G410 1870                  Oregon    410                Oregon
## 258    G420 1870            Pennsylvania    420          Pennsylvania
## 259    G440 1870            Rhode Island    440          Rhode Island
## 260    G450 1870          South Carolina    450        South Carolina
## 261    G470 1870               Tennessee    470             Tennessee
## 262    G480 1870                   Texas    480                 Texas
## 263    G495 1870          Utah Territory    495        Utah Territory
## 264    G500 1870                 Vermont    500               Vermont
## 265    G510 1870                Virginia    510              Virginia
## 266    G535 1870    Washington Territory    535  Washington Territory
## 267    G540 1870           West Virginia    540         West Virginia
## 268    G550 1870               Wisconsin    550             Wisconsin
## 269    G565 1870       Wyoming Territory    565     Wyoming Territory
## 270    G010 1880                 Alabama     10               Alabama
## 271    G025 1880        Alaska Territory     25      Alaska Territory
## 272    G045 1880       Arizona Territory     45     Arizona Territory
## 273    G050 1880                Arkansas     50              Arkansas
## 274    G060 1880              California     60            California
## 275    G080 1880                Colorado     80              Colorado
## 276    G090 1880             Connecticut     90           Connecticut
## 277    G095 1880        Dakota Territory     95      Dakota Territory
## 278    G100 1880                Delaware    100              Delaware
## 279    G110 1880    District Of Columbia    110  District of Columbia
## 280    G120 1880                 Florida    120               Florida
## 281    G130 1880                 Georgia    130               Georgia
## 282    G165 1880         Idaho Territory    165       Idaho Territory
## 283    G170 1880                Illinois    170              Illinois
## 284    G180 1880                 Indiana    180               Indiana
## 285    G190 1880                    Iowa    190                  Iowa
## 286    G200 1880                  Kansas    200                Kansas
## 287    G210 1880                Kentucky    210              Kentucky
## 288    G220 1880               Louisiana    220            Louisianna
## 289    G230 1880                   Maine    230                 Maine
## 290    G240 1880                Maryland    240              Maryland
## 291    G250 1880           Massachusetts    250         Massachusetts
## 292    G260 1880                Michigan    260              Michigan
## 293    G270 1880               Minnesota    270             Minnesota
## 294    G280 1880             Mississippi    280           Mississippi
## 295    G290 1880                Missouri    290              Missouri
## 296    G305 1880       Montana Territory    305     Montana Territory
## 297    G310 1880                Nebraska    310              Nebraska
## 298    G320 1880                  Nevada    320                Nevada
## 299    G330 1880           New Hampshire    330         New Hampshire
## 300    G340 1880              New Jersey    340            New Jersey
## 301    G355 1880    New Mexico Territory    355  New Mexico Territory
## 302    G360 1880                New York    360              New York
## 303    G370 1880          North Carolina    370        North Carolina
## 304    G390 1880                    Ohio    390                  Ohio
## 305    G410 1880                  Oregon    410                Oregon
## 306    G420 1880            Pennsylvania    420          Pennsylvania
## 307    G440 1880            Rhode Island    440          Rhode Island
## 308    G450 1880          South Carolina    450        South Carolina
## 309    G470 1880               Tennessee    470             Tennessee
## 310    G480 1880                   Texas    480                 Texas
## 311    G495 1880          Utah Territory    495        Utah Territory
## 312    G500 1880                 Vermont    500               Vermont
## 313    G510 1880                Virginia    510              Virginia
## 314    G535 1880    Washington Territory    535  Washington Territory
## 315    G540 1880           West Virginia    540         West Virginia
## 316    G550 1880               Wisconsin    550             Wisconsin
## 317    G565 1880       Wyoming Territory    565     Wyoming Territory
## 318    G010 1890                 Alabama     10               Alabama
## 319    G025 1890        Alaska Territory     25      Alaska Territory
## 320    G045 1890       Arizona Territory     45     Arizona Territory
## 321    G050 1890                Arkansas     50              Arkansas
## 322    G060 1890              California     60            California
## 323    G080 1890                Colorado     80              Colorado
## 324    G090 1890             Connecticut     90           Connecticut
## 325    G100 1890                Delaware    100              Delaware
## 326    G110 1890    District Of Columbia    110  District of Columbia
## 327    G120 1890                 Florida    120               Florida
## 328    G130 1890                 Georgia    130               Georgia
## 329    G160 1890                   Idaho    160                 Idaho
## 330    G170 1890                Illinois    170              Illinois
## 331    G178 1890        Indian Territory    178      Indian Territory
## 332    G180 1890                 Indiana    180               Indiana
## 333    G190 1890                    Iowa    190                  Iowa
## 334    G200 1890                  Kansas    200                Kansas
## 335    G210 1890                Kentucky    210              Kentucky
## 336    G220 1890               Louisiana    220            Louisianna
## 337    G230 1890                   Maine    230                 Maine
## 338    G240 1890                Maryland    240              Maryland
## 339    G250 1890           Massachusetts    250         Massachusetts
## 340    G260 1890                Michigan    260              Michigan
## 341    G270 1890               Minnesota    270             Minnesota
## 342    G280 1890             Mississippi    280           Mississippi
## 343    G290 1890                Missouri    290              Missouri
## 344    G300 1890                 Montana    300               Montana
## 345    G310 1890                Nebraska    310              Nebraska
## 346    G320 1890                  Nevada    320                Nevada
## 347    G330 1890           New Hampshire    330         New Hampshire
## 348    G340 1890              New Jersey    340            New Jersey
## 349    G355 1890    New Mexico Territory    355  New Mexico Territory
## 350    G360 1890                New York    360              New York
## 351    G370 1890          North Carolina    370        North Carolina
## 352    G380 1890            North Dakota    380          North Dakota
## 353    G390 1890                    Ohio    390                  Ohio
## 354    G405 1890      Oklahoma Territory    405    Oklahoma Territory
## 355    G410 1890                  Oregon    410                Oregon
## 356    G420 1890            Pennsylvania    420          Pennsylvania
## 357    G440 1890            Rhode Island    440          Rhode Island
## 358    G450 1890          South Carolina    450        South Carolina
## 359    G460 1890            South Dakota    460          South Dakota
## 360    G470 1890               Tennessee    470             Tennessee
## 361    G480 1890                   Texas    480                 Texas
## 362    G495 1890          Utah Territory    495        Utah Territory
## 363    G500 1890                 Vermont    500               Vermont
## 364    G510 1890                Virginia    510              Virginia
## 365    G530 1890              Washington    530            Washington
## 366    G540 1890           West Virginia    540         West Virginia
## 367    G550 1890               Wisconsin    550             Wisconsin
## 368    G560 1890                 Wyoming    560               Wyoming
## 369    G010 1900                 Alabama     10               Alabama
## 370    G025 1900        Alaska Territory     25      Alaska Territory
## 371    G045 1900       Arizona Territory     45     Arizona Territory
## 372    G050 1900                Arkansas     50              Arkansas
## 373    G060 1900              California     60            California
## 374    G080 1900                Colorado     80              Colorado
## 375    G090 1900             Connecticut     90           Connecticut
## 376    G100 1900                Delaware    100              Delaware
## 377    G110 1900    District Of Columbia    110  District of Columbia
## 378    G120 1900                 Florida    120               Florida
## 379    G130 1900                 Georgia    130               Georgia
## 380    G155 1900        Hawaii Territory    155      Hawaii Territory
## 381    G160 1900                   Idaho    160                 Idaho
## 382    G170 1900                Illinois    170              Illinois
## 383    G178 1900        Indian Territory    178      Indian Territory
## 384    G180 1900                 Indiana    180               Indiana
## 385    G190 1900                    Iowa    190                  Iowa
## 386    G200 1900                  Kansas    200                Kansas
## 387    G210 1900                Kentucky    210              Kentucky
## 388    G220 1900               Louisiana    220            Louisianna
## 389    G230 1900                   Maine    230                 Maine
## 390    G240 1900                Maryland    240              Maryland
## 391    G250 1900           Massachusetts    250         Massachusetts
## 392    G260 1900                Michigan    260              Michigan
## 393    G270 1900               Minnesota    270             Minnesota
## 394    G280 1900             Mississippi    280           Mississippi
## 395    G290 1900                Missouri    290              Missouri
## 396    G300 1900                 Montana    300               Montana
## 397    G310 1900                Nebraska    310              Nebraska
## 398    G320 1900                  Nevada    320                Nevada
## 399    G330 1900           New Hampshire    330         New Hampshire
## 400    G340 1900              New Jersey    340            New Jersey
## 401    G355 1900    New Mexico Territory    355  New Mexico Territory
## 402    G360 1900                New York    360              New York
## 403    G370 1900          North Carolina    370        North Carolina
## 404    G380 1900            North Dakota    380          North Dakota
## 405    G390 1900                    Ohio    390                  Ohio
## 406    G405 1900      Oklahoma Territory    405    Oklahoma Territory
## 407    G410 1900                  Oregon    410                Oregon
## 408    G420 1900            Pennsylvania    420          Pennsylvania
## 409    G440 1900            Rhode Island    440          Rhode Island
## 410    G450 1900          South Carolina    450        South Carolina
## 411    G460 1900            South Dakota    460          South Dakota
## 412    G470 1900               Tennessee    470             Tennessee
## 413    G480 1900                   Texas    480                 Texas
## 414    G490 1900                    Utah    490                  Utah
## 415    G500 1900                 Vermont    500               Vermont
## 416    G510 1900                Virginia    510              Virginia
## 417    G530 1900              Washington    530            Washington
## 418    G540 1900           West Virginia    540         West Virginia
## 419    G550 1900               Wisconsin    550             Wisconsin
## 420    G560 1900                 Wyoming    560               Wyoming
## 421    G999 1900 Persons in the Military    999   Persons in Military
## 422    G010 1910                 Alabama     10               Alabama
## 423    G025 1910        Alaska Territory     25      Alaska Territory
## 424    G045 1910       Arizona Territory     45     Arizona Territory
## 425    G050 1910                Arkansas     50              Arkansas
## 426    G060 1910              California     60            California
## 427    G080 1910                Colorado     80              Colorado
## 428    G090 1910             Connecticut     90           Connecticut
## 429    G100 1910                Delaware    100              Delaware
## 430    G110 1910    District Of Columbia    110  District of Columbia
## 431    G120 1910                 Florida    120               Florida
## 432    G130 1910                 Georgia    130               Georgia
## 433    G155 1910        Hawaii Territory    155      Hawaii Territory
## 434    G160 1910                   Idaho    160                 Idaho
## 435    G170 1910                Illinois    170              Illinois
## 436    G180 1910                 Indiana    180               Indiana
## 437    G190 1910                    Iowa    190                  Iowa
## 438    G200 1910                  Kansas    200                Kansas
## 439    G210 1910                Kentucky    210              Kentucky
## 440    G220 1910               Louisiana    220            Louisianna
## 441    G230 1910                   Maine    230                 Maine
## 442    G240 1910                Maryland    240              Maryland
## 443    G250 1910           Massachusetts    250         Massachusetts
## 444    G260 1910                Michigan    260              Michigan
## 445    G270 1910               Minnesota    270             Minnesota
## 446    G280 1910             Mississippi    280           Mississippi
## 447    G290 1910                Missouri    290              Missouri
## 448    G300 1910                 Montana    300               Montana
## 449    G310 1910                Nebraska    310              Nebraska
## 450    G320 1910                  Nevada    320                Nevada
## 451    G330 1910           New Hampshire    330         New Hampshire
## 452    G340 1910              New Jersey    340            New Jersey
## 453    G355 1910    New Mexico Territory    355  New Mexico Territory
## 454    G360 1910                New York    360              New York
## 455    G370 1910          North Carolina    370        North Carolina
## 456    G380 1910            North Dakota    380          North Dakota
## 457    G390 1910                    Ohio    390                  Ohio
## 458    G400 1910                Oklahoma    400              Oklahoma
## 459    G410 1910                  Oregon    410                Oregon
## 460    G420 1910            Pennsylvania    420          Pennsylvania
## 461    G440 1910            Rhode Island    440          Rhode Island
## 462    G450 1910          South Carolina    450        South Carolina
## 463    G460 1910            South Dakota    460          South Dakota
## 464    G470 1910               Tennessee    470             Tennessee
## 465    G480 1910                   Texas    480                 Texas
## 466    G490 1910                    Utah    490                  Utah
## 467    G500 1910                 Vermont    500               Vermont
## 468    G510 1910                Virginia    510              Virginia
## 469    G530 1910              Washington    530            Washington
## 470    G540 1910           West Virginia    540         West Virginia
## 471    G550 1910               Wisconsin    550             Wisconsin
## 472    G560 1910                 Wyoming    560               Wyoming
## 473    G010 1920                 Alabama     10               Alabama
## 474    G025 1920        Alaska Territory     25      Alaska Territory
## 475    G040 1920                 Arizona     40               Arizona
## 476    G050 1920                Arkansas     50              Arkansas
## 477    G060 1920              California     60            California
## 478    G080 1920                Colorado     80              Colorado
## 479    G090 1920             Connecticut     90           Connecticut
## 480    G100 1920                Delaware    100              Delaware
## 481    G110 1920    District Of Columbia    110  District of Columbia
## 482    G120 1920                 Florida    120               Florida
## 483    G130 1920                 Georgia    130               Georgia
## 484    G155 1920        Hawaii Territory    155      Hawaii Territory
## 485    G160 1920                   Idaho    160                 Idaho
## 486    G170 1920                Illinois    170              Illinois
## 487    G180 1920                 Indiana    180               Indiana
## 488    G190 1920                    Iowa    190                  Iowa
## 489    G200 1920                  Kansas    200                Kansas
## 490    G210 1920                Kentucky    210              Kentucky
## 491    G220 1920               Louisiana    220            Louisianna
## 492    G230 1920                   Maine    230                 Maine
## 493    G240 1920                Maryland    240              Maryland
## 494    G250 1920           Massachusetts    250         Massachusetts
## 495    G260 1920                Michigan    260              Michigan
## 496    G270 1920               Minnesota    270             Minnesota
## 497    G280 1920             Mississippi    280           Mississippi
## 498    G290 1920                Missouri    290              Missouri
## 499    G300 1920                 Montana    300               Montana
## 500    G310 1920                Nebraska    310              Nebraska
## 501    G320 1920                  Nevada    320                Nevada
## 502    G330 1920           New Hampshire    330         New Hampshire
## 503    G340 1920              New Jersey    340            New Jersey
## 504    G350 1920              New Mexico    350            New Mexico
## 505    G360 1920                New York    360              New York
## 506    G370 1920          North Carolina    370        North Carolina
## 507    G380 1920            North Dakota    380          North Dakota
## 508    G390 1920                    Ohio    390                  Ohio
## 509    G400 1920                Oklahoma    400              Oklahoma
## 510    G410 1920                  Oregon    410                Oregon
## 511    G420 1920            Pennsylvania    420          Pennsylvania
## 512    G440 1920            Rhode Island    440          Rhode Island
## 513    G450 1920          South Carolina    450        South Carolina
## 514    G460 1920            South Dakota    460          South Dakota
## 515    G470 1920               Tennessee    470             Tennessee
## 516    G480 1920                   Texas    480                 Texas
## 517    G490 1920                    Utah    490                  Utah
## 518    G500 1920                 Vermont    500               Vermont
## 519    G510 1920                Virginia    510              Virginia
## 520    G530 1920              Washington    530            Washington
## 521    G540 1920           West Virginia    540         West Virginia
## 522    G550 1920               Wisconsin    550             Wisconsin
## 523    G560 1920                 Wyoming    560               Wyoming
## 524    G010 1930                 Alabama     10               Alabama
## 525    G025 1930        Alaska Territory     25      Alaska Territory
## 526    G040 1930                 Arizona     40               Arizona
## 527    G050 1930                Arkansas     50              Arkansas
## 528    G060 1930              California     60            California
## 529    G080 1930                Colorado     80              Colorado
## 530    G090 1930             Connecticut     90           Connecticut
## 531    G100 1930                Delaware    100              Delaware
## 532    G110 1930    District Of Columbia    110  District of Columbia
## 533    G120 1930                 Florida    120               Florida
## 534    G130 1930                 Georgia    130               Georgia
## 535    G155 1930        Hawaii Territory    155      Hawaii Territory
## 536    G160 1930                   Idaho    160                 Idaho
## 537    G170 1930                Illinois    170              Illinois
## 538    G180 1930                 Indiana    180               Indiana
## 539    G190 1930                    Iowa    190                  Iowa
## 540    G200 1930                  Kansas    200                Kansas
## 541    G210 1930                Kentucky    210              Kentucky
## 542    G220 1930               Louisiana    220            Louisianna
## 543    G230 1930                   Maine    230                 Maine
## 544    G240 1930                Maryland    240              Maryland
## 545    G250 1930           Massachusetts    250         Massachusetts
## 546    G260 1930                Michigan    260              Michigan
## 547    G270 1930               Minnesota    270             Minnesota
## 548    G280 1930             Mississippi    280           Mississippi
## 549    G290 1930                Missouri    290              Missouri
## 550    G300 1930                 Montana    300               Montana
## 551    G310 1930                Nebraska    310              Nebraska
## 552    G320 1930                  Nevada    320                Nevada
## 553    G330 1930           New Hampshire    330         New Hampshire
## 554    G340 1930              New Jersey    340            New Jersey
## 555    G350 1930              New Mexico    350            New Mexico
## 556    G360 1930                New York    360              New York
## 557    G370 1930          North Carolina    370        North Carolina
## 558    G380 1930            North Dakota    380          North Dakota
## 559    G390 1930                    Ohio    390                  Ohio
## 560    G400 1930                Oklahoma    400              Oklahoma
## 561    G410 1930                  Oregon    410                Oregon
## 562    G420 1930            Pennsylvania    420          Pennsylvania
## 563    G440 1930            Rhode Island    440          Rhode Island
## 564    G450 1930          South Carolina    450        South Carolina
## 565    G460 1930            South Dakota    460          South Dakota
## 566    G470 1930               Tennessee    470             Tennessee
## 567    G480 1930                   Texas    480                 Texas
## 568    G490 1930                    Utah    490                  Utah
## 569    G500 1930                 Vermont    500               Vermont
## 570    G510 1930                Virginia    510              Virginia
## 571    G530 1930              Washington    530            Washington
## 572    G540 1930           West Virginia    540         West Virginia
## 573    G550 1930               Wisconsin    550             Wisconsin
## 574    G560 1930                 Wyoming    560               Wyoming
## 575    G010 1940                 Alabama     10               Alabama
## 576    G025 1940        Alaska Territory     25      Alaska Territory
## 577    G040 1940                 Arizona     40               Arizona
## 578    G050 1940                Arkansas     50              Arkansas
## 579    G060 1940              California     60            California
## 580    G080 1940                Colorado     80              Colorado
## 581    G090 1940             Connecticut     90           Connecticut
## 582    G100 1940                Delaware    100              Delaware
## 583    G110 1940    District Of Columbia    110  District of Columbia
## 584    G120 1940                 Florida    120               Florida
## 585    G130 1940                 Georgia    130               Georgia
## 586    G155 1940        Hawaii Territory    155      Hawaii Territory
## 587    G160 1940                   Idaho    160                 Idaho
## 588    G170 1940                Illinois    170              Illinois
## 589    G180 1940                 Indiana    180               Indiana
## 590    G190 1940                    Iowa    190                  Iowa
## 591    G200 1940                  Kansas    200                Kansas
## 592    G210 1940                Kentucky    210              Kentucky
## 593    G220 1940               Louisiana    220            Louisianna
## 594    G230 1940                   Maine    230                 Maine
## 595    G240 1940                Maryland    240              Maryland
## 596    G250 1940           Massachusetts    250         Massachusetts
## 597    G260 1940                Michigan    260              Michigan
## 598    G270 1940               Minnesota    270             Minnesota
## 599    G280 1940             Mississippi    280           Mississippi
## 600    G290 1940                Missouri    290              Missouri
## 601    G300 1940                 Montana    300               Montana
## 602    G310 1940                Nebraska    310              Nebraska
## 603    G320 1940                  Nevada    320                Nevada
## 604    G330 1940           New Hampshire    330         New Hampshire
## 605    G340 1940              New Jersey    340            New Jersey
## 606    G350 1940              New Mexico    350            New Mexico
## 607    G360 1940                New York    360              New York
## 608    G370 1940          North Carolina    370        North Carolina
## 609    G380 1940            North Dakota    380          North Dakota
## 610    G390 1940                    Ohio    390                  Ohio
## 611    G400 1940                Oklahoma    400              Oklahoma
## 612    G410 1940                  Oregon    410                Oregon
## 613    G420 1940            Pennsylvania    420          Pennsylvania
## 614    G440 1940            Rhode Island    440          Rhode Island
## 615    G450 1940          South Carolina    450        South Carolina
## 616    G460 1940            South Dakota    460          South Dakota
## 617    G470 1940               Tennessee    470             Tennessee
## 618    G480 1940                   Texas    480                 Texas
## 619    G490 1940                    Utah    490                  Utah
## 620    G500 1940                 Vermont    500               Vermont
## 621    G510 1940                Virginia    510              Virginia
## 622    G530 1940              Washington    530            Washington
## 623    G540 1940           West Virginia    540         West Virginia
## 624    G550 1940               Wisconsin    550             Wisconsin
## 625    G560 1940                 Wyoming    560               Wyoming
## 626    G010 1950                 Alabama     10               Alabama
## 627    G025 1950        Alaska Territory     25      Alaska Territory
## 628    G040 1950                 Arizona     40               Arizona
## 629    G050 1950                Arkansas     50              Arkansas
## 630    G060 1950              California     60            California
## 631    G080 1950                Colorado     80              Colorado
## 632    G090 1950             Connecticut     90           Connecticut
## 633    G100 1950                Delaware    100              Delaware
## 634    G110 1950    District Of Columbia    110  District of Columbia
## 635    G120 1950                 Florida    120               Florida
## 636    G130 1950                 Georgia    130               Georgia
## 637    G155 1950        Hawaii Territory    155      Hawaii Territory
## 638    G160 1950                   Idaho    160                 Idaho
## 639    G170 1950                Illinois    170              Illinois
## 640    G180 1950                 Indiana    180               Indiana
## 641    G190 1950                    Iowa    190                  Iowa
## 642    G200 1950                  Kansas    200                Kansas
## 643    G210 1950                Kentucky    210              Kentucky
## 644    G220 1950               Louisiana    220            Louisianna
## 645    G230 1950                   Maine    230                 Maine
## 646    G240 1950                Maryland    240              Maryland
## 647    G250 1950           Massachusetts    250         Massachusetts
## 648    G260 1950                Michigan    260              Michigan
## 649    G270 1950               Minnesota    270             Minnesota
## 650    G280 1950             Mississippi    280           Mississippi
## 651    G290 1950                Missouri    290              Missouri
## 652    G300 1950                 Montana    300               Montana
## 653    G310 1950                Nebraska    310              Nebraska
## 654    G320 1950                  Nevada    320                Nevada
## 655    G330 1950           New Hampshire    330         New Hampshire
## 656    G340 1950              New Jersey    340            New Jersey
## 657    G350 1950              New Mexico    350            New Mexico
## 658    G360 1950                New York    360              New York
## 659    G370 1950          North Carolina    370        North Carolina
## 660    G380 1950            North Dakota    380          North Dakota
## 661    G390 1950                    Ohio    390                  Ohio
## 662    G400 1950                Oklahoma    400              Oklahoma
## 663    G410 1950                  Oregon    410                Oregon
## 664    G420 1950            Pennsylvania    420          Pennsylvania
## 665    G440 1950            Rhode Island    440          Rhode Island
## 666    G450 1950          South Carolina    450        South Carolina
## 667    G460 1950            South Dakota    460          South Dakota
## 668    G470 1950               Tennessee    470             Tennessee
## 669    G480 1950                   Texas    480                 Texas
## 670    G490 1950                    Utah    490                  Utah
## 671    G500 1950                 Vermont    500               Vermont
## 672    G510 1950                Virginia    510              Virginia
## 673    G530 1950              Washington    530            Washington
## 674    G540 1950           West Virginia    540         West Virginia
## 675    G550 1950               Wisconsin    550             Wisconsin
## 676    G560 1950                 Wyoming    560               Wyoming
## 677    G010 1960                 Alabama     10               Alabama
## 678    G020 1960                  Alaska     20                Alaska
## 679    G040 1960                 Arizona     40               Arizona
## 680    G050 1960                Arkansas     50              Arkansas
## 681    G060 1960              California     60            California
## 682    G080 1960                Colorado     80              Colorado
## 683    G090 1960             Connecticut     90           Connecticut
## 684    G100 1960                Delaware    100              Delaware
## 685    G110 1960    District Of Columbia    110  District of Columbia
## 686    G120 1960                 Florida    120               Florida
## 687    G130 1960                 Georgia    130               Georgia
## 688    G150 1960                  Hawaii    150                Hawaii
## 689    G160 1960                   Idaho    160                 Idaho
## 690    G170 1960                Illinois    170              Illinois
## 691    G180 1960                 Indiana    180               Indiana
## 692    G190 1960                    Iowa    190                  Iowa
## 693    G200 1960                  Kansas    200                Kansas
## 694    G210 1960                Kentucky    210              Kentucky
## 695    G220 1960               Louisiana    220            Louisianna
## 696    G230 1960                   Maine    230                 Maine
## 697    G240 1960                Maryland    240              Maryland
## 698    G250 1960           Massachusetts    250         Massachusetts
## 699    G260 1960                Michigan    260              Michigan
## 700    G270 1960               Minnesota    270             Minnesota
## 701    G280 1960             Mississippi    280           Mississippi
## 702    G290 1960                Missouri    290              Missouri
## 703    G300 1960                 Montana    300               Montana
## 704    G310 1960                Nebraska    310              Nebraska
## 705    G320 1960                  Nevada    320                Nevada
## 706    G330 1960           New Hampshire    330         New Hampshire
## 707    G340 1960              New Jersey    340            New Jersey
## 708    G350 1960              New Mexico    350            New Mexico
## 709    G360 1960                New York    360              New York
## 710    G370 1960          North Carolina    370        North Carolina
## 711    G380 1960            North Dakota    380          North Dakota
## 712    G390 1960                    Ohio    390                  Ohio
## 713    G400 1960                Oklahoma    400              Oklahoma
## 714    G410 1960                  Oregon    410                Oregon
## 715    G420 1960            Pennsylvania    420          Pennsylvania
## 716    G440 1960            Rhode Island    440          Rhode Island
## 717    G450 1960          South Carolina    450        South Carolina
## 718    G460 1960            South Dakota    460          South Dakota
## 719    G470 1960               Tennessee    470             Tennessee
## 720    G480 1960                   Texas    480                 Texas
## 721    G490 1960                    Utah    490                  Utah
## 722    G500 1960                 Vermont    500               Vermont
## 723    G510 1960                Virginia    510              Virginia
## 724    G530 1960              Washington    530            Washington
## 725    G540 1960           West Virginia    540         West Virginia
## 726    G550 1960               Wisconsin    550             Wisconsin
## 727    G560 1960                 Wyoming    560               Wyoming
## 728    G010 1970                 Alabama      1               Alabama
## 729    G020 1970                  Alaska      2                Alaska
## 730    G040 1970                 Arizona      4               Arizona
## 731    G050 1970                Arkansas      5              Arkansas
## 732    G060 1970              California      6            California
## 733    G080 1970                Colorado      8              Colorado
## 734    G090 1970             Connecticut      9           Connecticut
## 735    G100 1970                Delaware     10              Delaware
## 736    G110 1970    District Of Columbia     11  District Of Columbia
## 737    G120 1970                 Florida     12               Florida
## 738    G130 1970                 Georgia     13               Georgia
## 739    G150 1970                  Hawaii     15                Hawaii
## 740    G160 1970                   Idaho     16                 Idaho
## 741    G170 1970                Illinois     17              Illinois
## 742    G180 1970                 Indiana     18               Indiana
## 743    G190 1970                    Iowa     19                  Iowa
## 744    G200 1970                  Kansas     20                Kansas
## 745    G210 1970                Kentucky     21              Kentucky
## 746    G220 1970               Louisiana     22             Louisiana
## 747    G230 1970                   Maine     23                 Maine
## 748    G240 1970                Maryland     24              Maryland
## 749    G250 1970           Massachusetts     25         Massachusetts
## 750    G260 1970                Michigan     26              Michigan
## 751    G270 1970               Minnesota     27             Minnesota
## 752    G280 1970             Mississippi     28           Mississippi
## 753    G290 1970                Missouri     29              Missouri
## 754    G300 1970                 Montana     30               Montana
## 755    G310 1970                Nebraska     31              Nebraska
## 756    G320 1970                  Nevada     32                Nevada
## 757    G330 1970           New Hampshire     33         New Hampshire
## 758    G340 1970              New Jersey     34            New Jersey
## 759    G350 1970              New Mexico     35            New Mexico
## 760    G360 1970                New York     36              New York
## 761    G370 1970          North Carolina     37        North Carolina
## 762    G380 1970            North Dakota     38          North Dakota
## 763    G390 1970                    Ohio     39                  Ohio
## 764    G400 1970                Oklahoma     40              Oklahoma
## 765    G410 1970                  Oregon     41                Oregon
## 766    G420 1970            Pennsylvania     42          Pennsylvania
## 767    G440 1970            Rhode Island     44          Rhode Island
## 768    G450 1970          South Carolina     45        South Carolina
## 769    G460 1970            South Dakota     46          South Dakota
## 770    G470 1970               Tennessee     47             Tennessee
## 771    G480 1970                   Texas     48                 Texas
## 772    G490 1970                    Utah     49                  Utah
## 773    G500 1970                 Vermont     50               Vermont
## 774    G510 1970                Virginia     51              Virginia
## 775    G530 1970              Washington     53            Washington
## 776    G540 1970           West Virginia     54         West Virginia
## 777    G550 1970               Wisconsin     55             Wisconsin
## 778    G560 1970                 Wyoming     56               Wyoming
## 779    G010 1980                 Alabama      1               ALABAMA
## 780    G020 1980                  Alaska      2                ALASKA
## 781    G040 1980                 Arizona      4               ARIZONA
## 782    G050 1980                Arkansas      5              ARKANSAS
## 783    G060 1980              California      6            CALIFORNIA
## 784    G080 1980                Colorado      8              COLORADO
## 785    G090 1980             Connecticut      9           CONNECTICUT
## 786    G100 1980                Delaware     10              DELAWARE
## 787    G110 1980    District Of Columbia     11  DISTRICT OF COLUMBIA
## 788    G120 1980                 Florida     12               FLORIDA
## 789    G130 1980                 Georgia     13               GEORGIA
## 790    G150 1980                  Hawaii     15                HAWAII
## 791    G160 1980                   Idaho     16                 IDAHO
## 792    G170 1980                Illinois     17              ILLINOIS
## 793    G180 1980                 Indiana     18               INDIANA
## 794    G190 1980                    Iowa     19                  IOWA
## 795    G200 1980                  Kansas     20                KANSAS
## 796    G210 1980                Kentucky     21              KENTUCKY
## 797    G220 1980               Louisiana     22             LOUISIANA
## 798    G230 1980                   Maine     23                 MAINE
## 799    G240 1980                Maryland     24              MARYLAND
## 800    G250 1980           Massachusetts     25         MASSACHUSETTS
## 801    G260 1980                Michigan     26              MICHIGAN
## 802    G270 1980               Minnesota     27             MINNESOTA
## 803    G280 1980             Mississippi     28           MISSISSIPPI
## 804    G290 1980                Missouri     29              MISSOURI
## 805    G300 1980                 Montana     30               MONTANA
## 806    G310 1980                Nebraska     31              NEBRASKA
## 807    G320 1980                  Nevada     32                NEVADA
## 808    G330 1980           New Hampshire     33         NEW HAMPSHIRE
## 809    G340 1980              New Jersey     34            NEW JERSEY
## 810    G350 1980              New Mexico     35            NEW MEXICO
## 811    G360 1980                New York     36              NEW YORK
## 812    G370 1980          North Carolina     37        NORTH CAROLINA
## 813    G380 1980            North Dakota     38          NORTH DAKOTA
## 814    G390 1980                    Ohio     39                  OHIO
## 815    G400 1980                Oklahoma     40              OKLAHOMA
## 816    G410 1980                  Oregon     41                OREGON
## 817    G420 1980            Pennsylvania     42          PENNSYLVANIA
## 818    G440 1980            Rhode Island     44          RHODE ISLAND
## 819    G450 1980          South Carolina     45        SOUTH CAROLINA
## 820    G460 1980            South Dakota     46          SOUTH DAKOTA
## 821    G470 1980               Tennessee     47             TENNESSEE
## 822    G480 1980                   Texas     48                 TEXAS
## 823    G490 1980                    Utah     49                  UTAH
## 824    G500 1980                 Vermont     50               VERMONT
## 825    G510 1980                Virginia     51              VIRGINIA
## 826    G530 1980              Washington     53            WASHINGTON
## 827    G540 1980           West Virginia     54         WEST VIRGINIA
## 828    G550 1980               Wisconsin     55             WISCONSIN
## 829    G560 1980                 Wyoming     56               WYOMING
## 830    G010 1990                 Alabama      1               Alabama
## 831    G020 1990                  Alaska      2                Alaska
## 832    G040 1990                 Arizona      4               Arizona
## 833    G050 1990                Arkansas      5              Arkansas
## 834    G060 1990              California      6            California
## 835    G080 1990                Colorado      8              Colorado
## 836    G090 1990             Connecticut      9           Connecticut
## 837    G100 1990                Delaware     10              Delaware
## 838    G110 1990    District Of Columbia     11  District of Columbia
## 839    G120 1990                 Florida     12               Florida
## 840    G130 1990                 Georgia     13               Georgia
## 841    G150 1990                  Hawaii     15                Hawaii
## 842    G160 1990                   Idaho     16                 Idaho
## 843    G170 1990                Illinois     17              Illinois
## 844    G180 1990                 Indiana     18               Indiana
## 845    G190 1990                    Iowa     19                  Iowa
## 846    G200 1990                  Kansas     20                Kansas
## 847    G210 1990                Kentucky     21              Kentucky
## 848    G220 1990               Louisiana     22             Louisiana
## 849    G230 1990                   Maine     23                 Maine
## 850    G240 1990                Maryland     24              Maryland
## 851    G250 1990           Massachusetts     25         Massachusetts
## 852    G260 1990                Michigan     26              Michigan
## 853    G270 1990               Minnesota     27             Minnesota
## 854    G280 1990             Mississippi     28           Mississippi
## 855    G290 1990                Missouri     29              Missouri
## 856    G300 1990                 Montana     30               Montana
## 857    G310 1990                Nebraska     31              Nebraska
## 858    G320 1990                  Nevada     32                Nevada
## 859    G330 1990           New Hampshire     33         New Hampshire
## 860    G340 1990              New Jersey     34            New Jersey
## 861    G350 1990              New Mexico     35            New Mexico
## 862    G360 1990                New York     36              New York
## 863    G370 1990          North Carolina     37        North Carolina
## 864    G380 1990            North Dakota     38          North Dakota
## 865    G390 1990                    Ohio     39                  Ohio
## 866    G400 1990                Oklahoma     40              Oklahoma
## 867    G410 1990                  Oregon     41                Oregon
## 868    G420 1990            Pennsylvania     42          Pennsylvania
## 869    G440 1990            Rhode Island     44          Rhode Island
## 870    G450 1990          South Carolina     45        South Carolina
## 871    G460 1990            South Dakota     46          South Dakota
## 872    G470 1990               Tennessee     47             Tennessee
## 873    G480 1990                   Texas     48                 Texas
## 874    G490 1990                    Utah     49                  Utah
## 875    G500 1990                 Vermont     50               Vermont
## 876    G510 1990                Virginia     51              Virginia
## 877    G530 1990              Washington     53            Washington
## 878    G540 1990           West Virginia     54         West Virginia
## 879    G550 1990               Wisconsin     55             Wisconsin
## 880    G560 1990                 Wyoming     56               Wyoming
## 881    G010 2000                 Alabama      1               Alabama
## 882    G020 2000                  Alaska      2                Alaska
## 883    G040 2000                 Arizona      4               Arizona
## 884    G050 2000                Arkansas      5              Arkansas
## 885    G060 2000              California      6            California
## 886    G080 2000                Colorado      8              Colorado
## 887    G090 2000             Connecticut      9           Connecticut
## 888    G100 2000                Delaware     10              Delaware
## 889    G110 2000    District Of Columbia     11  District of Columbia
## 890    G120 2000                 Florida     12               Florida
## 891    G130 2000                 Georgia     13               Georgia
## 892    G150 2000                  Hawaii     15                Hawaii
## 893    G160 2000                   Idaho     16                 Idaho
## 894    G170 2000                Illinois     17              Illinois
## 895    G180 2000                 Indiana     18               Indiana
## 896    G190 2000                    Iowa     19                  Iowa
## 897    G200 2000                  Kansas     20                Kansas
## 898    G210 2000                Kentucky     21              Kentucky
## 899    G220 2000               Louisiana     22             Louisiana
## 900    G230 2000                   Maine     23                 Maine
## 901    G240 2000                Maryland     24              Maryland
## 902    G250 2000           Massachusetts     25         Massachusetts
## 903    G260 2000                Michigan     26              Michigan
## 904    G270 2000               Minnesota     27             Minnesota
## 905    G280 2000             Mississippi     28           Mississippi
## 906    G290 2000                Missouri     29              Missouri
## 907    G300 2000                 Montana     30               Montana
## 908    G310 2000                Nebraska     31              Nebraska
## 909    G320 2000                  Nevada     32                Nevada
## 910    G330 2000           New Hampshire     33         New Hampshire
## 911    G340 2000              New Jersey     34            New Jersey
## 912    G350 2000              New Mexico     35            New Mexico
## 913    G360 2000                New York     36              New York
## 914    G370 2000          North Carolina     37        North Carolina
## 915    G380 2000            North Dakota     38          North Dakota
## 916    G390 2000                    Ohio     39                  Ohio
## 917    G400 2000                Oklahoma     40              Oklahoma
## 918    G410 2000                  Oregon     41                Oregon
## 919    G420 2000            Pennsylvania     42          Pennsylvania
## 920    G440 2000            Rhode Island     44          Rhode Island
## 921    G450 2000          South Carolina     45        South Carolina
## 922    G460 2000            South Dakota     46          South Dakota
## 923    G470 2000               Tennessee     47             Tennessee
## 924    G480 2000                   Texas     48                 Texas
## 925    G490 2000                    Utah     49                  Utah
## 926    G500 2000                 Vermont     50               Vermont
## 927    G510 2000                Virginia     51              Virginia
## 928    G530 2000              Washington     53            Washington
## 929    G540 2000           West Virginia     54         West Virginia
## 930    G550 2000               Wisconsin     55             Wisconsin
## 931    G560 2000                 Wyoming     56               Wyoming
## 932    G010 2010                 Alabama      1               Alabama
## 933    G020 2010                  Alaska      2                Alaska
## 934    G040 2010                 Arizona      4               Arizona
## 935    G050 2010                Arkansas      5              Arkansas
## 936    G060 2010              California      6            California
## 937    G080 2010                Colorado      8              Colorado
## 938    G090 2010             Connecticut      9           Connecticut
## 939    G100 2010                Delaware     10              Delaware
## 940    G110 2010    District Of Columbia     11  District of Columbia
## 941    G120 2010                 Florida     12               Florida
## 942    G130 2010                 Georgia     13               Georgia
## 943    G150 2010                  Hawaii     15                Hawaii
## 944    G160 2010                   Idaho     16                 Idaho
## 945    G170 2010                Illinois     17              Illinois
## 946    G180 2010                 Indiana     18               Indiana
## 947    G190 2010                    Iowa     19                  Iowa
## 948    G200 2010                  Kansas     20                Kansas
## 949    G210 2010                Kentucky     21              Kentucky
## 950    G220 2010               Louisiana     22             Louisiana
## 951    G230 2010                   Maine     23                 Maine
## 952    G240 2010                Maryland     24              Maryland
## 953    G250 2010           Massachusetts     25         Massachusetts
## 954    G260 2010                Michigan     26              Michigan
## 955    G270 2010               Minnesota     27             Minnesota
## 956    G280 2010             Mississippi     28           Mississippi
## 957    G290 2010                Missouri     29              Missouri
## 958    G300 2010                 Montana     30               Montana
## 959    G310 2010                Nebraska     31              Nebraska
## 960    G320 2010                  Nevada     32                Nevada
## 961    G330 2010           New Hampshire     33         New Hampshire
## 962    G340 2010              New Jersey     34            New Jersey
## 963    G350 2010              New Mexico     35            New Mexico
## 964    G360 2010                New York     36              New York
## 965    G370 2010          North Carolina     37        North Carolina
## 966    G380 2010            North Dakota     38          North Dakota
## 967    G390 2010                    Ohio     39                  Ohio
## 968    G400 2010                Oklahoma     40              Oklahoma
## 969    G410 2010                  Oregon     41                Oregon
## 970    G420 2010            Pennsylvania     42          Pennsylvania
## 971    G440 2010            Rhode Island     44          Rhode Island
## 972    G450 2010          South Carolina     45        South Carolina
## 973    G460 2010            South Dakota     46          South Dakota
## 974    G470 2010               Tennessee     47             Tennessee
## 975    G480 2010                   Texas     48                 Texas
## 976    G490 2010                    Utah     49                  Utah
## 977    G500 2010                 Vermont     50               Vermont
## 978    G510 2010                Virginia     51              Virginia
## 979    G530 2010              Washington     53            Washington
## 980    G540 2010           West Virginia     54         West Virginia
## 981    G550 2010               Wisconsin     55             Wisconsin
## 982    G560 2010                 Wyoming     56               Wyoming
## 983    G720 2010             Puerto Rico     72           Puerto Rico
##        A00AA
## 1     237655
## 2      59096
## 3      82548
## 4     319728
## 5     475199
## 6     141899
## 7     184139
## 8     340241
## 9     395005
## 10    433611
## 11     69112
## 12    249073
## 13     35691
## 14     85341
## 15    821287
## 16    251002
## 17     64273
## 18     14093
## 19    162686
## 20      5641
## 21    220955
## 22    341548
## 23    574564
## 24      8850
## 25    183858
## 26    211149
## 27    589051
## 28    478103
## 29     45365
## 30    602365
## 31     69122
## 32    345591
## 33    105602
## 34    154465
## 35    880200
## 36    261942
## 37     72674
## 38     24023
## 39    252433
## 40     12282
## 41     24520
## 42    406511
## 43     20845
## 44    380546
## 45    700745
## 46      4762
## 47     40352
## 48    214460
## 49    245562
## 50    959049
## 51    555500
## 52    230760
## 53     76556
## 54    810091
## 55     76931
## 56    415115
## 57    261727
## 58    217895
## 59    974600
## 60    127901
## 61     14273
## 62    275248
## 63     72749
## 64     33039
## 65    340989
## 66     55211
## 67    147178
## 68    564317
## 69    153407
## 70    298335
## 71    407350
## 72    523287
## 73      8896
## 74     75448
## 75     66586
## 76    244161
## 77    277575
## 78   1372812
## 79    638829
## 80    581434
## 81   1049458
## 82     83059
## 83    502741
## 84    422813
## 85    235764
## 86   1065379
## 87    309527
## 88     30388
## 89    297675
## 90     76748
## 91     39834
## 92     34730
## 93    516823
## 94    157445
## 95    343031
## 96    687917
## 97    215739
## 98    399455
## 99    447040
## 100   610408
## 101    31639
## 102   136621
## 103   140455
## 104   269328
## 105   320823
## 106  1918608
## 107   737987
## 108   937903
## 109  1348233
## 110    97199
## 111   581185
## 112   681904
## 113   280652
## 114  1211405
## 115   590756
## 116    97574
## 117   309978
## 118    78085
## 119    43712
## 120    54477
## 121   691392
## 122   476183
## 123   685866
## 124    43112
## 125   779828
## 126   352411
## 127   501793
## 128   470019
## 129   737699
## 130   212267
## 131   375651
## 132   383702
## 133   284574
## 134   373306
## 135  2428921
## 136   753419
## 137  1519467
## 138  1724033
## 139   108830
## 140   594398
## 141   829210
## 142   291948
## 143  1239797
## 144    30945
## 145   771623
## 146   209897
## 147    92597
## 148   370792
## 149    91532
## 150    51687
## 151    87445
## 152   906185
## 153   851470
## 154   988416
## 155   192214
## 156   982405
## 157   517762
## 158   583169
## 159   583034
## 160   994514
## 161   397654
## 162     6077
## 163   606526
## 164   682044
## 165   317976
## 166   489555
## 167    61547
## 168  3097394
## 169   869039
## 170  1980329
## 171    13294
## 172  2311786
## 173   147545
## 174   668507
## 175  1002717
## 176   212592
## 177    11380
## 178   314120
## 179  1421661
## 180   305391
## 181   964201
## 182   435450
## 183   379994
## 184    34277
## 185   460147
## 186     4837
## 187   112216
## 188    75080
## 189   140424
## 190  1057286
## 191  1711951
## 192  1350428
## 193   674913
## 194   107206
## 195  1155684
## 196   708002
## 197   628279
## 198   687049
## 199  1231066
## 200   749113
## 201   172023
## 202   791305
## 203  1182012
## 204    28841
## 205     6857
## 206   326073
## 207   672035
## 208    93516
## 209  3880735
## 210   992622
## 211  2339511
## 212    52465
## 213  2906215
## 214   174620
## 215   703708
## 216  1109801
## 217   604215
## 218    40273
## 219   315098
## 220  1596318
## 221    11594
## 222   775881
## 223   996992
## 224     9658
## 225   484471
## 226   560247
## 227    39864
## 228   537454
## 229    14181
## 230   125015
## 231   131700
## 232   187748
## 233  1184109
## 234    14999
## 235  2539891
## 236  1680637
## 237  1194020
## 238   364399
## 239  1321011
## 240   726915
## 241   626915
## 242   780894
## 243  1457351
## 244  1184059
## 245   439706
## 246   827922
## 247  1721295
## 248    20595
## 249   122993
## 250    42491
## 251   318300
## 252   906096
## 253    91874
## 254  4382759
## 255  1071361
## 256  2665260
## 257    90923
## 258  3521951
## 259   217353
## 260   705606
## 261  1258520
## 262   818579
## 263    86786
## 264   330551
## 265  1225163
## 266    23955
## 267   442014
## 268  1054670
## 269     9118
## 270  1262505
## 271    33426
## 272    40440
## 273   802525
## 274   864694
## 275   194327
## 276   622700
## 277   135177
## 278   146608
## 279   177624
## 280   269493
## 281  1542180
## 282    32610
## 283  3077871
## 284  1978301
## 285  1624615
## 286   996096
## 287  1648690
## 288   939946
## 289   648936
## 290   934943
## 291  1783085
## 292  1636937
## 293   780773
## 294  1131597
## 295  2168380
## 296    39159
## 297   452402
## 298    62266
## 299   346991
## 300  1131116
## 301   119565
## 302  5082871
## 303  1399750
## 304  3198062
## 305   174768
## 306  4282891
## 307   276531
## 308   995577
## 309  1542359
## 310  1591749
## 311   143963
## 312   332286
## 313  1512565
## 314    75116
## 315   618457
## 316  1315497
## 317    20789
## 318  1513017
## 319    32052
## 320    59620
## 321  1128179
## 322  1208130
## 323   412198
## 324   746258
## 325   168493
## 326   230392
## 327   391422
## 328  1837353
## 329    84385
## 330  3826351
## 331       NA
## 332  2192404
## 333  1911896
## 334  1427096
## 335  1858635
## 336  1118587
## 337   661086
## 338  1042390
## 339  2238943
## 340  2093889
## 341  1301826
## 342  1289600
## 343  2679184
## 344   132159
## 345  1058910
## 346    45761
## 347   376530
## 348  1444933
## 349   153593
## 350  5997853
## 351  1617947
## 352   182719
## 353  3672316
## 354    61834
## 355   313767
## 356  5258014
## 357   345506
## 358  1151149
## 359   328808
## 360  1767518
## 361  2235523
## 362   207905
## 363   332422
## 364  1655980
## 365   349390
## 366   762794
## 367  1686880
## 368    60705
## 369  1828697
## 370    63592
## 371   122931
## 372  1311564
## 373  1485053
## 374   539700
## 375   908420
## 376   184735
## 377   278718
## 378   528542
## 379  2216331
## 380   154001
## 381   161772
## 382  4821550
## 383   392060
## 384  2516462
## 385  2231853
## 386  1470495
## 387  2147174
## 388  1381625
## 389   694466
## 390  1188044
## 391  2805346
## 392  2420982
## 393  1751394
## 394  1551270
## 395  3106665
## 396   243329
## 397  1066300
## 398    42335
## 399   411588
## 400  1883669
## 401   195310
## 402  7268894
## 403  1893810
## 404   319146
## 405  4157545
## 406   398331
## 407   413536
## 408  6302115
## 409   428556
## 410  1340316
## 411   401570
## 412  2020616
## 413  3048710
## 414   276749
## 415   343641
## 416  1854184
## 417   518103
## 418   958800
## 419  2069042
## 420    92531
## 421    91219
## 422  2138093
## 423    64356
## 424   204354
## 425  1574449
## 426  2377549
## 427   799024
## 428  1114756
## 429   202322
## 430   331069
## 431   752619
## 432  2609121
## 433   191909
## 434   325594
## 435  5638591
## 436  2700876
## 437  2224771
## 438  1690949
## 439  2289905
## 440  1656388
## 441   742371
## 442  1295346
## 443  3366416
## 444  2810173
## 445  2075708
## 446  1797114
## 447  3293335
## 448   376053
## 449  1192214
## 450    81875
## 451   430572
## 452  2537167
## 453   327301
## 454  9113614
## 455  2206287
## 456   577056
## 457  4767121
## 458  1657155
## 459   672765
## 460  7665111
## 461   542610
## 462  1515400
## 463   583888
## 464  2184789
## 465  3896542
## 466   373351
## 467   355956
## 468  2061612
## 469  1141990
## 470  1221119
## 471  2333860
## 472   145965
## 473  2348174
## 474    55036
## 475   334162
## 476  1752204
## 477  3426861
## 478   939629
## 479  1380631
## 480   223003
## 481   437571
## 482   968470
## 483  2895832
## 484   255881
## 485   431866
## 486  6485280
## 487  2930390
## 488  2404021
## 489  1769257
## 490  2416630
## 491  1798509
## 492   768014
## 493  1449661
## 494  3852356
## 495  3668412
## 496  2387125
## 497  1790618
## 498  3404055
## 499   548889
## 500  1296372
## 501    77407
## 502   443083
## 503  3155900
## 504   360350
## 505 10385228
## 506  2559123
## 507   646872
## 508  5759394
## 509  2028283
## 510   783389
## 511  8720018
## 512   604397
## 513  1683724
## 514   636547
## 515  2337885
## 516  4663228
## 517   449396
## 518   352428
## 519  2309187
## 520  1356621
## 521  1463701
## 522  2632067
## 523   194402
## 524  2646248
## 525    59278
## 526   435573
## 527  1854482
## 528  5677251
## 529  1035791
## 530  1606903
## 531   238380
## 532   486869
## 533  1468211
## 534  2908506
## 535   368336
## 536   445032
## 537  7630654
## 538  3238503
## 539  2470939
## 540  1880999
## 541  2614589
## 542  2101593
## 543   797423
## 544  1631526
## 545  4249614
## 546  4842325
## 547  2563953
## 548  2009821
## 549  3629367
## 550   537606
## 551  1377963
## 552    91058
## 553   465293
## 554  4041334
## 555   423317
## 556 12588066
## 557  3170276
## 558   680845
## 559  6646697
## 560  2396040
## 561   953786
## 562  9631350
## 563   687497
## 564  1738765
## 565   692849
## 566  2616556
## 567  5824715
## 568   507847
## 569   359611
## 570  2421851
## 571  1563396
## 572  1729205
## 573  2939006
## 574   225565
## 575  2832961
## 576    72524
## 577   499261
## 578  1949387
## 579  6907387
## 580  1123296
## 581  1709242
## 582   266505
## 583   663091
## 584  1897414
## 585  3123723
## 586   422770
## 587   524873
## 588  7897241
## 589  3427796
## 590  2538268
## 591  1801028
## 592  2845627
## 593  2363880
## 594   847226
## 595  1821244
## 596  4316721
## 597  5256106
## 598  2792300
## 599  2183796
## 600  3784664
## 601   559456
## 602  1315834
## 603   110247
## 604   491524
## 605  4160165
## 606   531818
## 607 13479142
## 608  3571623
## 609   641935
## 610  6907612
## 611  2336434
## 612  1089684
## 613  9900180
## 614   713346
## 615  1899804
## 616   642961
## 617  2915841
## 618  6414824
## 619   550310
## 620   359231
## 621  2677773
## 622  1736191
## 623  1901974
## 624  3137587
## 625   250742
## 626  3061743
## 627   128643
## 628   749587
## 629  1909511
## 630 10586224
## 631  1325089
## 632  2007280
## 633   318085
## 634   802178
## 635  2771305
## 636  3444578
## 637   499794
## 638   588637
## 639  8712176
## 640  3934224
## 641  2621073
## 642  1905299
## 643  2944806
## 644  2683516
## 645   913774
## 646  2343001
## 647  4690514
## 648  6371766
## 649  2982483
## 650  2178914
## 651  3954653
## 652   591024
## 653  1325510
## 654   160083
## 655   533242
## 656  4835329
## 657   681187
## 658 14830192
## 659  4061929
## 660   619636
## 661  7946627
## 662  2233351
## 663  1521341
## 664 10498012
## 665   791896
## 666  2117027
## 667   652740
## 668  3291718
## 669  7711194
## 670   688862
## 671   377747
## 672  3318680
## 673  2378963
## 674  2005552
## 675  3434575
## 676   290529
## 677  3266740
## 678   226167
## 679  1302161
## 680  1786272
## 681 15717204
## 682  1753947
## 683  2535234
## 684   446292
## 685   763956
## 686  4951560
## 687  3943116
## 688   632772
## 689   667191
## 690 10081158
## 691  4662498
## 692  2757537
## 693  2178611
## 694  3038156
## 695  3257022
## 696   969265
## 697  3100689
## 698  5148578
## 699  7823194
## 700  3413864
## 701  2178141
## 702  4319813
## 703   674767
## 704  1411330
## 705   285278
## 706   606921
## 707  6066782
## 708   951023
## 709 16782304
## 710  4556155
## 711   632446
## 712  9706398
## 713  2328284
## 714  1768687
## 715 11319366
## 716   859488
## 717  2382594
## 718   680514
## 719  3567089
## 720  9579678
## 721   890627
## 722   389881
## 723  3966949
## 724  2853214
## 725  1860421
## 726  3951777
## 727   330066
## 728  3444165
## 729   300382
## 730  1770900
## 731  1923295
## 732 19953134
## 733  2207259
## 734  3031709
## 735   548104
## 736   756510
## 737  6789443
## 738  4589575
## 739   768561
## 740   712567
## 741 11113976
## 742  5193669
## 743  2824376
## 744  2246578
## 745  3218706
## 746  3641306
## 747   992048
## 748  3922399
## 749  5689170
## 750  8875083
## 751  3804971
## 752  2216912
## 753  4676501
## 754   694409
## 755  1483493
## 756   488738
## 757   737681
## 758  7168164
## 759  1016000
## 760 18236967
## 761  5082059
## 762   617761
## 763 10652017
## 764  2559229
## 765  2091385
## 766 11793909
## 767   946725
## 768  2590516
## 769   665507
## 770  3923687
## 771 11196730
## 772  1059273
## 773   444330
## 774  4648494
## 775  3409169
## 776  1744237
## 777  4417731
## 778   332416
## 779  3893888
## 780   401851
## 781  2718215
## 782  2286435
## 783 23667902
## 784  2889964
## 785  3107576
## 786   594338
## 787   638333
## 788  9746324
## 789  5463105
## 790   964691
## 791   943935
## 792 11426518
## 793  5490224
## 794  2913808
## 795  2363679
## 796  3660777
## 797  4205900
## 798  1124660
## 799  4216975
## 800  5737037
## 801  9262078
## 802  4075970
## 803  2520638
## 804  4916686
## 805   786690
## 806  1569825
## 807   800493
## 808   920610
## 809  7364823
## 810  1302894
## 811 17558072
## 812  5881766
## 813   652717
## 814 10797630
## 815  3025290
## 816  2633105
## 817 11863895
## 818   947154
## 819  3121820
## 820   690768
## 821  4591120
## 822 14229191
## 823  1461037
## 824   511456
## 825  5346818
## 826  4132156
## 827  1949644
## 828  4705767
## 829   469557
## 830  4040587
## 831   550043
## 832  3665228
## 833  2350725
## 834 29760021
## 835  3294394
## 836  3287116
## 837   666168
## 838   606900
## 839 12937926
## 840  6478216
## 841  1108229
## 842  1006749
## 843 11430602
## 844  5544159
## 845  2776755
## 846  2477574
## 847  3685296
## 848  4219973
## 849  1227928
## 850  4781468
## 851  6016425
## 852  9295297
## 853  4375099
## 854  2573216
## 855  5117073
## 856   799065
## 857  1578385
## 858  1201833
## 859  1109252
## 860  7730188
## 861  1515069
## 862 17990455
## 863  6628637
## 864   638800
## 865 10847115
## 866  3145585
## 867  2842321
## 868 11881643
## 869  1003464
## 870  3486703
## 871   696004
## 872  4877185
## 873 16986510
## 874  1722850
## 875   562758
## 876  6187358
## 877  4866692
## 878  1793477
## 879  4891769
## 880   453588
## 881  4447100
## 882   626932
## 883  5130632
## 884  2673400
## 885 33871648
## 886  4301261
## 887  3405565
## 888   783600
## 889   572059
## 890 15982378
## 891  8186453
## 892  1211537
## 893  1293953
## 894 12419293
## 895  6080485
## 896  2926324
## 897  2688418
## 898  4041769
## 899  4468976
## 900  1274923
## 901  5296486
## 902  6349097
## 903  9938444
## 904  4919479
## 905  2844658
## 906  5595211
## 907   902195
## 908  1711263
## 909  1998257
## 910  1235786
## 911  8414350
## 912  1819046
## 913 18976457
## 914  8049313
## 915   642200
## 916 11353140
## 917  3450654
## 918  3421399
## 919 12281054
## 920  1048319
## 921  4012012
## 922   754844
## 923  5689283
## 924 20851820
## 925  2233169
## 926   608827
## 927  7078515
## 928  5894121
## 929  1808344
## 930  5363675
## 931   493782
## 932  4779736
## 933   710231
## 934  6392017
## 935  2915918
## 936 37253956
## 937  5029196
## 938  3574097
## 939   897934
## 940   601723
## 941 18801310
## 942  9687653
## 943  1360301
## 944  1567582
## 945 12830632
## 946  6483802
## 947  3046355
## 948  2853118
## 949  4339367
## 950  4533372
## 951  1328361
## 952  5773552
## 953  6547629
## 954  9883640
## 955  5303925
## 956  2967297
## 957  5988927
## 958   989415
## 959  1826341
## 960  2700551
## 961  1316470
## 962  8791894
## 963  2059179
## 964 19378102
## 965  9535483
## 966   672591
## 967 11536504
## 968  3751351
## 969  3831074
## 970 12702379
## 971  1052567
## 972  4625364
## 973   814180
## 974  6346105
## 975 25145561
## 976  2763885
## 977   625741
## 978  8001024
## 979  6724540
## 980  1852994
## 981  5686986
## 982   563626
## 983  3725789
states <- states %>%
  select(GISJOIN,
         year = YEAR,
         state = STATE,
         statea = STATEA,
         name = NAME,
         statepop = A00AA) %>%
  group_by(year) %>%
  summarize(nationalpop = sum(statepop))
states
## Source: local data frame [23 x 2]
## 
##    year nationalpop
## 1  1790     3929625
## 2  1800     5308483
## 3  1810     7239881
## 4  1820     9638239
## 5  1830    12860702
## 6  1840    17063353
## 7  1850    23191876
## 8  1860    31443321
## 9  1870    38558371
## 10 1880    50189209
## 11 1890          NA
## 12 1900    76303387
## 13 1910    92228531
## 14 1920   106021539
## 15 1930   123202660
## 16 1940   132164569
## 17 1950   151325799
## 18 1960   179323177
## 19 1970   203211926
## 20 1980   226545805
## 21 1990   248709873
## 22 2000   281421906
## 23 2010   312471327
#failures
# attempts to rename, reorder content
#states <- states %>%
 # select(GISJOIN,
  #       year = YEAR,
   #      state = STATE,
    #     statea = STATEA,
     #    name = NAME,
      #   statepop = A00AA) %>%
#  gather(GISJOIN, year, state, statea, name, statepop)

# group it together by year
#states <- states %>%
 # filter(YEAR == 1790)

#THIS WORKED TO SELECT ONLY PARTS OF CHART, RENAME POP - could also have put
# select(-GISJOIN, -statea, -name)
#states <- states %>%
 # select(YEAR, NAME, STATEPOP = A00AA)