MADA Module 4: Data Analysis Exercise

Source of Data: The dataset used for this analysis is obtained from the CDC’s data website https://data.cdc.gov/NCHS/Provisional-COVID-19-Deaths-by-Race-and-Hispanic-O/ks3g-spdg. This dataset contains information about the deaths from COVID-19, pneumonia, influenza, and total deaths from the different states of the US including Puerto Rico during 2020-2023.

LOADING AND PROCESSING DATA

# Loading the required packages
library(readr)
library(tidyverse)

── Attaching packages ─────────────────────────────────────── tidyverse 1.3.2 ──
✔ ggplot2 3.4.0     ✔ dplyr   1.1.0
✔ tibble  3.1.8     ✔ stringr 1.4.1
✔ tidyr   1.2.0     ✔ forcats 0.5.2
✔ purrr   0.3.4     
── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
✖ dplyr::filter() masks stats::filter()
✖ dplyr::lag()    masks stats::lag()

library(naniar)
library(dplyr)
library(ggplot2)

# Loading the data
covid19mod4 <- read_csv("module4_dataanalysis_exercise/data/raw_data/covid19_deaths_race_hispanic_origin_age.csv")

Rows: 6489 Columns: 13
── Column specification ────────────────────────────────────────────────────────
Delimiter: ","
chr (7): Data as of, Start Date, End Date, State, Age group, Race and Hispan...
dbl (6): COVID-19 Deaths, Total Deaths, Pneumonia Deaths, Pneumonia and COVI...

ℹ Use `spec()` to retrieve the full column specification for this data.
ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.

head(covid19mod4, n = 10)

# A tibble: 10 × 13
   Data …¹ Start…² End D…³ State Age g…⁴ Race …⁵ COVID…⁶ Total…⁷ Pneum…⁸ Pneum…⁹
   <chr>   <chr>   <chr>   <chr> <chr>   <chr>     <dbl>   <dbl>   <dbl>   <dbl>
 1 01/25/… 01/01/… 01/21/… Unit… All Ag… Total … 1098567  1.02e7 1036419  551581
 2 01/25/… 01/01/… 01/21/… Unit… All Ag… Non-Hi…  721987  7.55e6  711314  348822
 3 01/25/… 01/01/… 01/21/… Unit… Under … Non-Hi…     158  2.36e4     315      27
 4 01/25/… 01/01/… 01/21/… Unit… 0-17 y… Non-Hi…     554  4.40e4     937     144
 5 01/25/… 01/01/… 01/21/… Unit… 1-4 ye… Non-Hi…      94  4.92e3     201      24
 6 01/25/… 01/01/… 01/21/… Unit… 5-14 y… Non-Hi…     160  8.00e3     280      49
 7 01/25/… 01/01/… 01/21/… Unit… 15-24 … Non-Hi…    1092  4.84e4    1214     447
 8 01/25/… 01/01/… 01/21/… Unit… 18-29 … Non-Hi…    2492  9.04e4    2674    1109
 9 01/25/… 01/01/… 01/21/… Unit… 25-34 … Non-Hi…    4406  1.20e5    4428    2028
10 01/25/… 01/01/… 01/21/… Unit… 30-49 … Non-Hi…   25748  4.01e5   24374   13061
# … with 3 more variables: `Influenza Deaths` <dbl>,
#   `Pneumonia, Influenza, or COVID-19 Deaths` <dbl>, Footnote <chr>, and
#   abbreviated variable names ¹​`Data as of`, ²​`Start Date`, ³​`End Date`,
#   ⁴​`Age group`, ⁵​`Race and Hispanic Origin Group`, ⁶​`COVID-19 Deaths`,
#   ⁷​`Total Deaths`, ⁸​`Pneumonia Deaths`, ⁹​`Pneumonia and COVID-19 Deaths`

dim(covid19mod4)

[1] 6489   13

DATA CLEANING

# Looking at the variables
colnames(covid19mod4)

 [1] "Data as of"                              
 [2] "Start Date"                              
 [3] "End Date"                                
 [4] "State"                                   
 [5] "Age group"                               
 [6] "Race and Hispanic Origin Group"          
 [7] "COVID-19 Deaths"                         
 [8] "Total Deaths"                            
 [9] "Pneumonia Deaths"                        
[10] "Pneumonia and COVID-19 Deaths"           
[11] "Influenza Deaths"                        
[12] "Pneumonia, Influenza, or COVID-19 Deaths"
[13] "Footnote"                                

# Changing the variable names to lower case for working conveniance
names(covid19mod4) <- tolower(names(covid19mod4))
colnames(covid19mod4)

 [1] "data as of"                              
 [2] "start date"                              
 [3] "end date"                                
 [4] "state"                                   
 [5] "age group"                               
 [6] "race and hispanic origin group"          
 [7] "covid-19 deaths"                         
 [8] "total deaths"                            
 [9] "pneumonia deaths"                        
[10] "pneumonia and covid-19 deaths"           
[11] "influenza deaths"                        
[12] "pneumonia, influenza, or covid-19 deaths"
[13] "footnote"                                

# Renaming the variables
covid19mod4 <- covid19mod4 %>%
  rename("age" = "age group",
         "race" = "race and hispanic origin group",
         "covid19_deaths" = "covid-19 deaths",
         "total_deaths" = "total deaths",
         "pneumonia_deaths" = "pneumonia deaths",
         "pneumonia_and_covid19_deaths" = "pneumonia and covid-19 deaths",
         "influenza_deaths" = "influenza deaths",
         "pneumonia_influenza_or_covid19_deaths" = "pneumonia, influenza, or covid-19 deaths")
colnames(covid19mod4)       

 [1] "data as of"                           
 [2] "start date"                           
 [3] "end date"                             
 [4] "state"                                
 [5] "age"                                  
 [6] "race"                                 
 [7] "covid19_deaths"                       
 [8] "total_deaths"                         
 [9] "pneumonia_deaths"                     
[10] "pneumonia_and_covid19_deaths"         
[11] "influenza_deaths"                     
[12] "pneumonia_influenza_or_covid19_deaths"
[13] "footnote"                             

# Let's create an object that contains only the variables that will be used in this data analysis exercise
covid19mod4_main <- covid19mod4 %>% select(state, age, race, covid19_deaths, pneumonia_deaths, influenza_deaths,
                                           pneumonia_and_covid19_deaths, pneumonia_influenza_or_covid19_deaths, total_deaths)
glimpse(covid19mod4_main)

Rows: 6,489
Columns: 9
$ state                                 <chr> "United States", "United States"…
$ age                                   <chr> "All Ages", "All Ages", "Under 1…
$ race                                  <chr> "Total Deaths", "Non-Hispanic Wh…
$ covid19_deaths                        <dbl> 1098567, 721987, 158, 554, 94, 1…
$ pneumonia_deaths                      <dbl> 1036419, 711314, 315, 937, 201, …
$ influenza_deaths                      <dbl> 19209, 13964, 22, 178, 50, 85, 8…
$ pneumonia_and_covid19_deaths          <dbl> 551581, 348822, 27, 144, 24, 49,…
$ pneumonia_influenza_or_covid19_deaths <dbl> 1600399, 1097320, 467, 1516, 319…
$ total_deaths                          <dbl> 10216003, 7552090, 23582, 44049,…

# Checking if there are any missing data  
any(is.na(covid19mod4_main))

[1] TRUE

# Let's go and remove NAs from each columns of the object `covid19mod4_main`
covid19mod4_main <- covid19mod4_main %>% 
                        drop_na(state, age, race, covid19_deaths, pneumonia_deaths, influenza_deaths,
                               pneumonia_and_covid19_deaths, pneumonia_influenza_or_covid19_deaths, total_deaths)

# Making sure there are no missing values in any columns of the object `covid19mod4_main`
any(is.na(covid19mod4_main))

[1] FALSE

gg_miss_var(covid19mod4_main)

Warning: The `guide` argument in `scale_*()` cannot be `FALSE`. This was deprecated in
ggplot2 3.3.4.
ℹ Please use "none" instead.
ℹ The deprecated feature was likely used in the naniar package.
  Please report the issue at <]8;;https://github.com/njtierney/naniar/issueshttps://github.com/njtierney/naniar/issues]8;;>.

# Let's look at the age variable of the object `covid19mod4_main`
unique(covid19mod4_main$age)

 [1] "All Ages"          "Under 1 year"      "0-17 years"       
 [4] "1-4 years"         "5-14 years"        "15-24 years"      
 [7] "18-29 years"       "25-34 years"       "30-49 years"      
[10] "35-44 years"       "45-54 years"       "50-64 years"      
[13] "55-64 years"       "65-74 years"       "75-84 years"      
[16] "85 years and over"

# Removing word "years" from `age` column values
covid19mod4_main$age<-gsub(" years","",as.character(covid19mod4_main$age))
unique(covid19mod4_main$age)

 [1] "All Ages"     "Under 1 year" "0-17"         "1-4"          "5-14"        
 [6] "15-24"        "18-29"        "25-34"        "30-49"        "35-44"       
[11] "45-54"        "50-64"        "55-64"        "65-74"        "75-84"       
[16] "85 and over" 

class(covid19mod4_main$age)

[1] "character"

# Changing '85 and over' age category into '85+' category for our easiness and filtering only the age categories starting `1-4` to `85+` years categories with even 4 years spacing
covid19mod4_main$age[covid19mod4_main$age == '85 and over'] <- '85+'
covid19mod4_main <- 
  filter(covid19mod4_main, age %in% c("1-4", "5-14", "15-24", "25-34", "35-44", "45-54", "55-64", "65-74", "75-84", "85+"))
unique(covid19mod4_main$age)

 [1] "1-4"   "5-14"  "15-24" "25-34" "35-44" "45-54" "55-64" "65-74" "75-84"
[10] "85+"  

# Let's look at the race variable of the object `covid19mod4_main`
unique(covid19mod4_main$race)

[1] "Non-Hispanic White"                                    
[2] "Non-Hispanic Black"                                    
[3] "Non-Hispanic American Indian or Alaska Native"         
[4] "Non-Hispanic Asian"                                    
[5] "Non-Hispanic Native Hawaiian or Other Pacific Islander"
[6] "Non-Hispanic More than one race"                       
[7] "Hispanic"                                              
[8] "Unknown"                                               

# Removing `Non-Hispanic More than one race` and `Unknown` categories of race
covid19mod4_main <- 
  filter(covid19mod4_main, race %in% c("Non-Hispanic White", "Non-Hispanic Black", "Non-Hispanic American Indian or Alaska Native", "Non-Hispanic Asian", "Non-Hispanic Native Hawaiian or Other Pacific Islander", "Hispanic"))
unique(covid19mod4_main$race)

[1] "Non-Hispanic White"                                    
[2] "Non-Hispanic Black"                                    
[3] "Non-Hispanic American Indian or Alaska Native"         
[4] "Non-Hispanic Asian"                                    
[5] "Non-Hispanic Native Hawaiian or Other Pacific Islander"
[6] "Hispanic"                                              

# Let's look at the state variable of the object `covid19mod4_main`
unique(covid19mod4_main$state)

 [1] "United States"        "Alabama"              "Alaska"              
 [4] "Arizona"              "Arkansas"             "California"          
 [7] "Colorado"             "Connecticut"          "Delaware"            
[10] "District of Columbia" "Florida"              "Georgia"             
[13] "Hawaii"               "Idaho"                "Illinois"            
[16] "Indiana"              "Iowa"                 "Kansas"              
[19] "Kentucky"             "Louisiana"            "Maine"               
[22] "Maryland"             "Massachusetts"        "Michigan"            
[25] "Minnesota"            "Mississippi"          "Missouri"            
[28] "Montana"              "Nebraska"             "Nevada"              
[31] "New Hampshire"        "New Jersey"           "New Mexico"          
[34] "New York"             "New York City"        "North Carolina"      
[37] "North Dakota"         "Ohio"                 "Oklahoma"            
[40] "Oregon"               "Pennsylvania"         "Rhode Island"        
[43] "South Carolina"       "South Dakota"         "Tennessee"           
[46] "Texas"                "Utah"                 "Vermont"             
[49] "Virginia"             "Washington"           "West Virginia"       
[52] "Wisconsin"            "Wyoming"              "Puerto Rico"         

# Removing `United States`, `Puerto Rico`, `District of Columbia`, and `New York City` so that the object `covid19mod4_main` includes only 50 states data
covid19mod4_main <- covid19mod4_main[-c(which(covid19mod4_main$state == "United States")), ]
covid19mod4_main <- covid19mod4_main[-c(which(covid19mod4_main$state == "Puerto Rico")), ]
covid19mod4_main <- covid19mod4_main[-c(which(covid19mod4_main$state == "District of Columbia")), ]
covid19mod4_main <- covid19mod4_main[-c(which(covid19mod4_main$state == "New York City")), ]
unique(covid19mod4_main$state)

 [1] "Alabama"        "Alaska"         "Arizona"        "Arkansas"      
 [5] "California"     "Colorado"       "Connecticut"    "Delaware"      
 [9] "Florida"        "Georgia"        "Hawaii"         "Idaho"         
[13] "Illinois"       "Indiana"        "Iowa"           "Kansas"        
[17] "Kentucky"       "Louisiana"      "Maine"          "Maryland"      
[21] "Massachusetts"  "Michigan"       "Minnesota"      "Mississippi"   
[25] "Missouri"       "Montana"        "Nebraska"       "Nevada"        
[29] "New Hampshire"  "New Jersey"     "New Mexico"     "New York"      
[33] "North Carolina" "North Dakota"   "Ohio"           "Oklahoma"      
[37] "Oregon"         "Pennsylvania"   "Rhode Island"   "South Carolina"
[41] "South Dakota"   "Tennessee"      "Texas"          "Utah"          
[45] "Vermont"        "Virginia"       "Washington"     "West Virginia" 
[49] "Wisconsin"      "Wyoming"       

# Since we have no missing data and our data is cleaned as we wanted, the object covid19mod4_main is ready to be used for subsequent data analysis and data visualization.

DATA EXPLORATION AND VISUALIZATION

# Let's look at the number of deaths from COVID-19 as per people's race during 2020-2023
covid19death_race <- covid19mod4_main %>% group_by(race) %>%
 summarize(sum = sum(covid19_deaths, na.rm=T))

# Renaming column `sum` into `covid19_deaths_by_race`
covid19death_race <- covid19death_race %>% rename("covid19_deaths_by_race" = "sum")
covid19death_race <- covid19death_race %>%
  arrange(desc(`covid19_deaths_by_race`))
covid19death_race

# A tibble: 6 × 2
  race                                                   covid19_deaths_by_race
  <chr>                                                                   <dbl>
1 Non-Hispanic White                                                     691412
2 Hispanic                                                               113981
3 Non-Hispanic Black                                                      95587
4 Non-Hispanic Asian                                                      14583
5 Non-Hispanic American Indian or Alaska Native                            2418
6 Non-Hispanic Native Hawaiian or Other Pacific Islander                    580

# Plotting the race versus COVID-19 deaths in different states of the US for 2020-23
ggplot(data = covid19death_race, aes(x = reorder(race, -covid19_deaths_by_race), covid19_deaths_by_race,
                                     fill = race)) +
  geom_bar(stat = "identity") +
  geom_col() +
  geom_text(aes(y = covid19_deaths_by_race, label = covid19_deaths_by_race), vjust = -0.5,
            check_overlap = FALSE) +
  labs(title = "COVID-19 Deaths by Race in the US", 
       x = "Race", y = "Number of COVID-19 Deaths") +
  theme(legend.position = "right", 
        plot.title = element_text(hjust=0.5),
        legend.background = element_rect(fill = "white", color = 1),
        axis.text.x = element_blank(),
        axis.title = element_text(size = 14),
        axis.ticks.x = element_blank())

SAVING CLEANED DATASET AS A RDS FILE

# Saving cleaned `covid19mod4_main` as a rds file
saveRDS(covid19mod4_main, "module4_dataanalysis_exercise/data/processed_data/covid19mod4_main.rds")

SUMMARY TABLE

Table 1: Data summary table.

state	age	race	covid19_deaths	pneumonia_deaths	influenza_deaths	pneumonia_and_covid19_deaths	pneumonia_influenza_or_covid19_deaths	total_deaths
Alabama	35-44	Non-Hispanic White	301	242	10	116	436	4208
Alabama	45-54	Non-Hispanic White	910	621	16	335	1211	8379
Alabama	55-64	Non-Hispanic White	2193	1707	49	821	3121	19642
Alabama	65-74	Non-Hispanic White	3680	3010	47	1357	5379	31105
Alabama	75-84	Non-Hispanic White	4166	3470	64	1517	6174	39053
Alabama	85+	Non-Hispanic White	3207	2500	41	987	4755	36148
Alabama	55-64	Non-Hispanic Black	1164	734	17	366	1548	8548
Alabama	65-74	Non-Hispanic Black	1506	999	23	484	2041	11624
Alabama	25-34	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	10
Alabama	15-24	Non-Hispanic Asian	0	0	0	0	0	12
Alabama	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Alabama	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Alabama	5-14	Hispanic	0	0	0	0	0	26
Alabama	15-24	Hispanic	0	0	0	0	0	105
Alabama	25-34	Hispanic	21	15	0	11	25	193
Alabama	35-44	Hispanic	57	22	0	19	60	204
Alabama	45-54	Hispanic	90	45	0	35	100	298
Alabama	75-84	Hispanic	43	26	0	15	54	236
Alaska	5-14	Non-Hispanic White	0	0	0	0	0	20
Alaska	35-44	Non-Hispanic White	29	19	0	11	37	395
Alaska	1-4	Non-Hispanic Black	0	0	0	0	0	0
Alaska	25-34	Non-Hispanic Black	0	0	0	0	0	20
Alaska	45-54	Non-Hispanic American Indian or Alaska Native	24	38	0	17	45	400
Alaska	65-74	Non-Hispanic Asian	29	20	0	17	32	138
Alaska	75-84	Non-Hispanic Asian	22	26	0	20	28	140
Alaska	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Alaska	65-74	Non-Hispanic Native Hawaiian or Other Pacific Islander	15	15	0	11	19	61
Arizona	15-24	Non-Hispanic White	27	24	0	10	41	1036
Arizona	35-44	Non-Hispanic White	246	258	10	139	374	3849
Arizona	45-54	Non-Hispanic White	683	693	10	391	994	7144
Arizona	55-64	Non-Hispanic White	1896	2048	25	1130	2838	18693
Arizona	65-74	Non-Hispanic White	4025	4190	46	2413	5845	35473
Arizona	75-84	Non-Hispanic White	5388	5433	46	2993	7874	48526
Arizona	85+	Non-Hispanic White	4438	4318	38	2178	6612	50454
Arizona	1-4	Non-Hispanic Black	0	0	0	0	0	44
Arizona	25-34	Non-Hispanic Black	35	23	0	16	42	526
Arizona	65-74	Non-Hispanic Black	266	258	0	164	360	2016
Arizona	15-24	Non-Hispanic American Indian or Alaska Native	18	15	0	10	23	287
Arizona	45-54	Non-Hispanic Asian	37	29	0	21	45	233
Arizona	55-64	Non-Hispanic Native Hawaiian or Other Pacific Islander	17	15	0	12	20	77
Arizona	65-74	Non-Hispanic Native Hawaiian or Other Pacific Islander	15	13	0	11	17	86
Arizona	45-54	Hispanic	976	746	17	606	1129	3910
Arizona	55-64	Hispanic	1667	1347	14	1049	1979	6388
Arizona	65-74	Hispanic	2045	1675	14	1317	2416	7870
Arizona	85+	Hispanic	1038	884	12	605	1329	7011
Arkansas	45-54	Non-Hispanic White	494	480	16	257	733	5492
Arkansas	55-64	Non-Hispanic White	1280	1324	46	706	1943	13287
Arkansas	65-74	Non-Hispanic White	2306	2415	54	1230	3539	21456
Arkansas	75-84	Non-Hispanic White	2888	2983	43	1384	4527	26539
Arkansas	85+	Non-Hispanic White	2530	2411	48	1016	3969	25165
Arkansas	55-64	Non-Hispanic Black	336	307	10	167	484	2943
Arkansas	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Arkansas	55-64	Non-Hispanic American Indian or Alaska Native	22	19	0	13	28	103
Arkansas	75-84	Non-Hispanic American Indian or Alaska Native	18	23	0	14	27	81
Arkansas	65-74	Non-Hispanic Asian	23	21	0	13	31	129
Arkansas	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Arkansas	45-54	Non-Hispanic Native Hawaiian or Other Pacific Islander	19	13	0	10	22	49
Arkansas	1-4	Hispanic	0	0	0	0	0	16
Arkansas	35-44	Hispanic	25	13	0	11	27	169
Arkansas	45-54	Hispanic	64	49	0	40	73	247
Arkansas	85+	Hispanic	25	26	0	13	38	177
California	25-34	Non-Hispanic White	243	273	14	107	423	7962
California	35-44	Non-Hispanic White	531	613	16	267	893	11597
California	45-54	Non-Hispanic White	1408	1635	39	767	2315	21445
California	55-64	Non-Hispanic White	4220	5319	102	2488	7152	57790
California	65-74	Non-Hispanic White	7455	9961	168	4327	13249	99885
California	75-84	Non-Hispanic White	10877	13631	201	6035	18667	135728
California	85+	Non-Hispanic White	13895	15578	243	6507	23203	194182
California	45-54	Non-Hispanic Black	620	596	12	323	905	6486
California	55-64	Non-Hispanic Black	1410	1501	26	782	2154	14293
California	65-74	Non-Hispanic Black	1837	2153	23	1069	2944	17641
California	75-84	Non-Hispanic Black	1550	1851	19	881	2538	15403
California	85+	Non-Hispanic Black	1337	1468	12	657	2160	14346
California	35-44	Non-Hispanic American Indian or Alaska Native	26	33	0	17	42	329
California	55-64	Non-Hispanic Asian	1326	1356	26	788	1918	10363
California	65-74	Non-Hispanic Asian	2406	2772	26	1533	3669	18349
California	75-84	Non-Hispanic Asian	3013	3755	47	1813	4998	25560
California	85+	Non-Hispanic Asian	4222	5348	38	2314	7294	39969
California	45-54	Non-Hispanic Native Hawaiian or Other Pacific Islander	96	81	0	59	118	528
California	15-24	Hispanic	210	196	10	106	310	5802
California	25-34	Hispanic	918	720	28	456	1209	10835
California	35-44	Hispanic	2286	1811	43	1289	2847	14325
California	45-54	Hispanic	5164	4074	54	3107	6182	23116
California	55-64	Hispanic	9213	7689	75	5921	11050	37883
California	65-74	Hispanic	10765	9371	60	6932	13256	44341
California	75-84	Hispanic	8751	8318	71	5657	11476	44350
California	85+	Hispanic	6767	6750	86	3903	9696	50231
Colorado	45-54	Non-Hispanic White	418	415	13	217	629	5677
Colorado	55-64	Non-Hispanic White	1132	1171	43	608	1736	13107
Colorado	65-74	Non-Hispanic White	2105	2272	52	1193	3233	22421
Colorado	75-84	Non-Hispanic White	2772	2772	55	1452	4145	27979
Colorado	85+	Non-Hispanic White	3327	2740	83	1374	4769	35156
Colorado	45-54	Non-Hispanic American Indian or Alaska Native	30	26	0	18	38	184
Colorado	55-64	Non-Hispanic American Indian or Alaska Native	41	30	0	25	46	230
Colorado	75-84	Non-Hispanic American Indian or Alaska Native	23	20	0	13	30	174
Colorado	85+	Non-Hispanic American Indian or Alaska Native	15	14	0	10	19	95
Colorado	65-74	Non-Hispanic Asian	77	66	0	38	105	460
Colorado	75-84	Non-Hispanic Asian	84	76	0	47	113	525
Colorado	25-34	Hispanic	52	47	0	25	74	1259
Connecticut	35-44	Non-Hispanic White	71	49	0	18	102	1748
Connecticut	45-54	Non-Hispanic White	206	183	11	85	314	3307
Connecticut	55-64	Non-Hispanic White	708	647	12	277	1090	9058
Connecticut	65-74	Non-Hispanic White	1452	1305	28	551	2229	14678
Connecticut	75-84	Non-Hispanic White	2381	1959	39	797	3578	21703
Connecticut	85+	Non-Hispanic White	4237	3006	58	1177	6122	36270
Connecticut	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Connecticut	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Connecticut	35-44	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	10
Connecticut	15-24	Non-Hispanic Asian	0	0	0	0	0	15
Connecticut	25-34	Non-Hispanic Asian	0	0	0	0	0	39
Connecticut	65-74	Non-Hispanic Asian	44	37	0	18	63	281
Connecticut	75-84	Non-Hispanic Asian	43	34	0	18	59	354
Connecticut	85+	Non-Hispanic Asian	41	36	0	12	65	401
Connecticut	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Connecticut	35-44	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Connecticut	35-44	Hispanic	57	36	0	21	72	667
Connecticut	75-84	Hispanic	308	186	11	113	392	1548
Delaware	35-44	Non-Hispanic White	29	29	0	16	42	682
Delaware	65-74	Non-Hispanic White	515	568	12	287	807	5399
Delaware	85+	Non-Hispanic White	783	577	14	286	1086	8004
Delaware	85+	Non-Hispanic Black	125	92	0	50	167	1128
Delaware	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Delaware	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Delaware	15-24	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Delaware	25-34	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Delaware	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Delaware	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Delaware	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Delaware	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Delaware	35-44	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Delaware	45-54	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Delaware	55-64	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Delaware	65-74	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Delaware	85+	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Delaware	55-64	Hispanic	29	20	0	15	34	120
Delaware	65-74	Hispanic	29	22	0	18	33	158
Delaware	75-84	Hispanic	25	25	0	16	34	153
Florida	35-44	Non-Hispanic White	755	820	18	474	1119	13524
Florida	45-54	Non-Hispanic White	2147	2245	37	1406	3021	24146
Florida	55-64	Non-Hispanic White	5552	6573	87	3553	8654	63051
Florida	65-74	Non-Hispanic White	9995	12408	166	6401	16156	106654
Florida	75-84	Non-Hispanic White	13711	16568	187	8253	22199	144675
Florida	85+	Non-Hispanic White	14160	15651	164	7365	22585	171706
Florida	35-44	Non-Hispanic Black	705	627	12	422	922	5408
Florida	45-54	Non-Hispanic Black	1323	1199	19	837	1703	8495
Florida	55-64	Non-Hispanic Black	2486	2472	27	1581	3402	16792
Florida	65-74	Non-Hispanic Black	3234	3256	26	2027	4484	21434
Florida	75-84	Non-Hispanic Black	2667	2668	30	1655	3704	18768
Florida	85+	Non-Hispanic Black	1897	1919	16	1115	2714	16133
Florida	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Florida	55-64	Non-Hispanic American Indian or Alaska Native	28	25	0	17	36	165
Florida	65-74	Non-Hispanic American Indian or Alaska Native	38	39	0	20	57	247
Florida	75-84	Non-Hispanic American Indian or Alaska Native	21	23	0	13	31	186
Florida	75-84	Non-Hispanic Asian	281	312	0	169	424	2438
Florida	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Florida	45-54	Hispanic	1389	1257	15	985	1675	7015
Florida	55-64	Hispanic	2610	2470	19	1869	3226	13168
Florida	65-74	Hispanic	3547	3563	30	2541	4594	18673
Florida	75-84	Hispanic	4272	4687	48	3030	5975	27148
Florida	85+	Hispanic	4083	4751	49	2674	6203	35330
Georgia	45-54	Non-Hispanic White	1300	1093	14	710	1696	11933
Georgia	55-64	Non-Hispanic White	3164	2983	59	1785	4414	28473
Georgia	65-74	Non-Hispanic White	5238	4992	80	3004	7298	44745
Georgia	75-84	Non-Hispanic White	6252	6006	78	3352	8977	56909
Georgia	85+	Non-Hispanic White	4901	4387	51	2173	7164	55811
Georgia	45-54	Non-Hispanic Black	1153	856	13	566	1455	8538
Georgia	55-64	Non-Hispanic Black	2243	1801	21	1116	2947	17366
Georgia	65-74	Non-Hispanic Black	2995	2475	29	1501	3997	23113
Georgia	75-84	Non-Hispanic Black	2417	1994	23	1220	3211	18388
Georgia	85+	Non-Hispanic Black	1483	1205	15	690	2010	14062
Georgia	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Georgia	1-4	Non-Hispanic Asian	0	0	0	0	0	17
Georgia	45-54	Non-Hispanic Asian	33	33	0	18	48	373
Georgia	55-64	Non-Hispanic Asian	75	73	0	47	101	652
Georgia	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Georgia	45-54	Hispanic	279	206	0	175	310	1134
Hawaii	15-24	Non-Hispanic White	0	0	0	0	0	51
Hawaii	55-64	Non-Hispanic White	32	63	0	17	78	1044
Hawaii	1-4	Non-Hispanic Black	0	0	0	0	0	0
Hawaii	15-24	Non-Hispanic Black	0	0	0	0	0	12
Hawaii	25-34	Non-Hispanic Black	0	0	0	0	0	20
Hawaii	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Hawaii	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Hawaii	65-74	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	12
Hawaii	55-64	Non-Hispanic Asian	85	108	0	47	146	1288
Hawaii	35-44	Non-Hispanic Native Hawaiian or Other Pacific Islander	31	15	0	12	34	197
Hawaii	45-54	Non-Hispanic Native Hawaiian or Other Pacific Islander	40	41	0	27	54	348
Hawaii	75-84	Non-Hispanic Native Hawaiian or Other Pacific Islander	38	49	0	20	67	529
Hawaii	65-74	Hispanic	26	30	0	12	44	387
Hawaii	75-84	Hispanic	16	36	0	12	40	416
Idaho	55-64	Non-Hispanic White	583	480	13	304	772	5546
Idaho	65-74	Non-Hispanic White	1086	958	24	626	1440	9989
Idaho	75-84	Non-Hispanic White	1370	1235	28	718	1913	13271
Idaho	85+	Non-Hispanic White	1385	1060	34	564	1912	14688
Idaho	1-4	Non-Hispanic Black	0	0	0	0	0	0
Idaho	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Idaho	15-24	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	18
Idaho	75-84	Non-Hispanic American Indian or Alaska Native	25	23	0	17	31	118
Idaho	1-4	Non-Hispanic Asian	0	0	0	0	0	0
Idaho	5-14	Non-Hispanic Asian	0	0	0	0	0	0
Idaho	25-34	Non-Hispanic Asian	0	0	0	0	0	11
Idaho	35-44	Hispanic	28	18	0	15	31	177
Idaho	75-84	Hispanic	93	66	0	52	107	432
Idaho	85+	Hispanic	60	43	0	31	72	357
Illinois	35-44	Non-Hispanic White	262	274	10	121	425	5863
Illinois	45-54	Non-Hispanic White	796	816	12	409	1214	11293
Illinois	55-64	Non-Hispanic White	2449	2637	54	1392	3746	30266
Illinois	65-74	Non-Hispanic White	4892	5300	66	2692	7562	52480
Illinois	75-84	Non-Hispanic White	6904	7329	116	3638	10706	69874
Illinois	85+	Non-Hispanic White	9213	8582	157	3930	14009	95639
Illinois	15-24	Non-Hispanic Black	31	28	0	17	42	1629
Illinois	55-64	Non-Hispanic Black	1150	1205	17	639	1731	12272
Illinois	65-74	Non-Hispanic Black	1690	1693	18	971	2429	14836
Illinois	85+	Non-Hispanic Black	1188	1060	11	576	1683	10791
Illinois	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Illinois	35-44	Non-Hispanic Asian	29	18	0	11	36	247
Illinois	45-54	Non-Hispanic Asian	61	47	0	30	78	472
Illinois	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Indiana	35-44	Non-Hispanic White	346	362	13	197	523	5709
Indiana	45-54	Non-Hispanic White	966	1001	22	568	1420	10822
Indiana	55-64	Non-Hispanic White	2698	3062	59	1652	4161	26619
Indiana	65-74	Non-Hispanic White	4933	5358	84	2906	7462	43474
Indiana	75-84	Non-Hispanic White	6319	6321	114	3385	9363	53264
Indiana	85+	Non-Hispanic White	6822	5577	102	2735	9762	59351
Indiana	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Indiana	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Indiana	45-54	Non-Hispanic Asian	13	14	0	12	15	129
Indiana	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Indiana	35-44	Hispanic	66	54	0	45	75	438
Indiana	85+	Hispanic	113	99	0	62	150	842
Iowa	45-54	Non-Hispanic White	361	287	12	149	510	4102
Iowa	55-64	Non-Hispanic White	987	889	22	422	1473	10920
Iowa	65-74	Non-Hispanic White	1808	1680	45	790	2740	19006
Iowa	75-84	Non-Hispanic White	2655	2235	70	993	3964	25065
Iowa	85+	Non-Hispanic White	3754	2939	105	1140	5657	35321
Iowa	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Iowa	65-74	Non-Hispanic American Indian or Alaska Native	14	17	0	10	21	64
Iowa	85+	Non-Hispanic Asian	24	16	0	10	30	154
Iowa	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Iowa	5-14	Hispanic	0	0	0	0	0	16
Iowa	15-24	Hispanic	0	0	0	0	0	82
Iowa	55-64	Hispanic	83	47	0	39	91	281
Iowa	65-74	Hispanic	73	49	0	41	81	282
Iowa	75-84	Hispanic	44	29	0	24	49	239
Iowa	85+	Hispanic	29	21	0	13	37	218
Kansas	45-54	Non-Hispanic White	374	314	11	184	514	3493
Kansas	55-64	Non-Hispanic White	902	826	33	455	1306	9441
Kansas	65-74	Non-Hispanic White	1635	1577	49	793	2464	16184
Kansas	75-84	Non-Hispanic White	2202	2008	69	990	3284	20331
Kansas	85+	Non-Hispanic White	2695	2239	78	957	4052	27118
Kansas	45-54	Non-Hispanic Black	40	32	0	16	56	456
Kansas	75-84	Non-Hispanic Black	142	102	0	70	174	958
Kansas	65-74	Non-Hispanic American Indian or Alaska Native	26	24	0	15	35	150
Kansas	1-4	Non-Hispanic Asian	0	0	0	0	0	0
Kansas	85+	Non-Hispanic Asian	29	18	0	10	37	219
Kansas	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Kansas	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Kentucky	35-44	Non-Hispanic White	357	396	10	199	564	5873
Kentucky	45-54	Non-Hispanic White	982	1061	21	531	1533	10481
Kentucky	55-64	Non-Hispanic White	2451	2872	74	1397	3991	23603
Kentucky	65-74	Non-Hispanic White	4236	4957	96	2429	6850	35548
Kentucky	75-84	Non-Hispanic White	4935	5553	95	2594	7978	40475
Kentucky	85+	Non-Hispanic White	4294	4021	96	1710	6688	36893
Kentucky	65-74	Non-Hispanic Black	346	381	10	205	532	2847
Kentucky	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Kentucky	15-24	Non-Hispanic Asian	0	0	0	0	0	19
Kentucky	25-34	Non-Hispanic Asian	0	0	0	0	0	16
Kentucky	75-84	Non-Hispanic Asian	26	29	0	16	39	161
Kentucky	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Kentucky	45-54	Hispanic	49	41	0	33	57	195
Kentucky	65-74	Hispanic	46	41	0	28	59	192
Kentucky	75-84	Hispanic	29	32	0	17	44	171
Louisiana	45-54	Non-Hispanic White	588	463	11	314	747	5973
Louisiana	55-64	Non-Hispanic White	1457	1288	22	788	1975	14635
Louisiana	65-74	Non-Hispanic White	2537	2323	33	1404	3487	22753
Louisiana	75-84	Non-Hispanic White	3031	2658	32	1541	4179	28037
Louisiana	85+	Non-Hispanic White	2576	2223	26	1119	3706	28842
Louisiana	55-64	Non-Hispanic Black	1145	926	13	607	1474	9591
Louisiana	65-74	Non-Hispanic Black	1544	1237	12	815	1975	12582
Louisiana	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Louisiana	65-74	Non-Hispanic American Indian or Alaska Native	21	13	0	11	23	113
Louisiana	65-74	Non-Hispanic Asian	37	25	0	23	39	285
Louisiana	75-84	Non-Hispanic Asian	26	25	0	16	35	242
Louisiana	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Louisiana	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Louisiana	45-54	Hispanic	54	35	0	25	64	337
Louisiana	65-74	Hispanic	103	64	0	46	121	519
Louisiana	75-84	Hispanic	79	53	0	35	97	542
Louisiana	85+	Hispanic	68	48	0	28	88	682
Maine	55-64	Non-Hispanic White	329	377	10	97	619	5881
Maine	65-74	Non-Hispanic White	583	721	15	196	1123	9778
Maine	75-84	Non-Hispanic White	850	1045	27	236	1684	12745
Maine	85+	Non-Hispanic White	924	1109	49	181	1900	15718
Maine	15-24	Non-Hispanic Black	0	0	0	0	0	20
Maine	35-44	Non-Hispanic Black	0	0	0	0	0	34
Maine	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Maine	1-4	Non-Hispanic Asian	0	0	0	0	0	0
Maine	5-14	Non-Hispanic Asian	0	0	0	0	0	0
Maine	55-64	Non-Hispanic Asian	0	0	0	0	0	27
Maine	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Maine	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Maine	35-44	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Maine	85+	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Maine	25-34	Hispanic	0	0	0	0	0	13
Maryland	55-64	Non-Hispanic White	962	1032	23	455	1559	12049
Maryland	65-74	Non-Hispanic White	1840	2035	29	827	3076	20296
Maryland	75-84	Non-Hispanic White	2739	2865	53	1164	4491	27869
Maryland	85+	Non-Hispanic White	3585	3470	70	1265	5849	38032
Maryland	55-64	Non-Hispanic Black	967	809	16	384	1405	9455
Maryland	65-74	Non-Hispanic Black	1460	1280	19	617	2141	12259
Maryland	75-84	Non-Hispanic Black	1459	1260	14	611	2120	11470
Maryland	85+	Non-Hispanic Black	1173	970	15	419	1734	10558
Maryland	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Maryland	55-64	Non-Hispanic Asian	74	62	0	31	105	520
Maryland	65-74	Non-Hispanic Asian	123	118	0	57	184	897
Maryland	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Maryland	55-64	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	11
Massachusetts	45-54	Non-Hispanic White	366	369	19	155	598	6757
Massachusetts	55-64	Non-Hispanic White	1250	1388	38	613	2061	17727
Massachusetts	65-74	Non-Hispanic White	2733	2972	67	1289	4480	30595
Massachusetts	75-84	Non-Hispanic White	4390	4464	118	1971	6997	42492
Massachusetts	85+	Non-Hispanic White	7421	6047	159	2594	11021	64562
Massachusetts	35-44	Non-Hispanic Black	37	31	0	12	56	560
Massachusetts	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Massachusetts	35-44	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	12
Massachusetts	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Massachusetts	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Massachusetts	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Massachusetts	45-54	Hispanic	142	93	0	63	172	1166
Michigan	35-44	Non-Hispanic White	399	381	10	203	587	6549
Michigan	45-54	Non-Hispanic White	1250	1110	26	701	1684	12604
Michigan	55-64	Non-Hispanic White	3183	3141	65	1721	4663	33000
Michigan	65-74	Non-Hispanic White	5897	6051	110	3293	8754	56268
Michigan	75-84	Non-Hispanic White	7544	7277	126	3881	11055	72166
Michigan	85+	Non-Hispanic White	8258	7112	109	3366	12111	89298
Michigan	15-24	Non-Hispanic Black	27	19	0	10	36	983
Michigan	55-64	Non-Hispanic Black	1215	1103	11	664	1664	9424
Michigan	65-74	Non-Hispanic Black	1834	1734	21	1017	2572	12584
Michigan	75-84	Non-Hispanic Black	1409	1285	14	763	1944	9482
Michigan	85+	Non-Hispanic Black	1098	914	10	501	1521	8727
Michigan	15-24	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	23
Michigan	45-54	Non-Hispanic American Indian or Alaska Native	18	15	0	12	21	144
Michigan	55-64	Non-Hispanic American Indian or Alaska Native	48	41	0	27	62	285
Michigan	5-14	Non-Hispanic Asian	0	0	0	0	0	14
Michigan	15-24	Non-Hispanic Asian	0	0	0	0	0	47
Michigan	35-44	Non-Hispanic Asian	21	17	0	13	25	105
Michigan	45-54	Non-Hispanic Asian	29	25	0	19	35	174
Michigan	65-74	Non-Hispanic Asian	111	101	0	73	139	597
Michigan	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Michigan	25-34	Hispanic	30	28	0	20	38	428
Michigan	35-44	Hispanic	89	62	0	47	104	620
Minnesota	45-54	Non-Hispanic White	388	352	10	160	590	5316
Minnesota	55-64	Non-Hispanic White	1141	1098	42	507	1774	14744
Minnesota	65-74	Non-Hispanic White	2203	2229	56	984	3500	25908
Minnesota	75-84	Non-Hispanic White	3485	3157	82	1319	5403	36118
Minnesota	85+	Non-Hispanic White	5089	4011	94	1504	7685	51730
Minnesota	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	12
Minnesota	45-54	Non-Hispanic American Indian or Alaska Native	26	32	0	13	45	339
Minnesota	85+	Non-Hispanic American Indian or Alaska Native	25	21	0	10	36	153
Minnesota	45-54	Non-Hispanic Asian	55	38	0	28	65	279
Minnesota	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Minnesota	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Minnesota	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Minnesota	1-4	Hispanic	0	0	0	0	0	19
Minnesota	5-14	Hispanic	0	0	0	0	0	14
Minnesota	35-44	Hispanic	32	16	0	10	38	228
Minnesota	85+	Hispanic	48	39	0	21	66	292
Mississippi	55-64	Non-Hispanic White	1183	1278	37	651	1842	10280
Mississippi	65-74	Non-Hispanic White	2052	2238	36	1140	3182	16502
Mississippi	75-84	Non-Hispanic White	2537	2681	39	1287	3964	20810
Mississippi	85+	Non-Hispanic White	2141	2115	29	914	3364	19718
Mississippi	15-24	Non-Hispanic Black	28	25	0	17	36	867
Mississippi	35-44	Non-Hispanic Black	279	223	10	140	368	2302
Mississippi	45-54	Non-Hispanic Black	540	463	10	273	740	3637
Mississippi	55-64	Non-Hispanic Black	1041	996	16	553	1499	7587
Mississippi	65-74	Non-Hispanic Black	1443	1372	14	745	2081	9876
Mississippi	75-84	Non-Hispanic Black	1125	982	10	556	1559	7354
Mississippi	45-54	Non-Hispanic American Indian or Alaska Native	31	22	0	16	37	107
Mississippi	55-64	Non-Hispanic American Indian or Alaska Native	39	30	0	23	46	133
Mississippi	65-74	Non-Hispanic American Indian or Alaska Native	31	25	0	20	36	93
Mississippi	1-4	Non-Hispanic Asian	0	0	0	0	0	0
Mississippi	65-74	Non-Hispanic Asian	22	21	0	12	31	106
Mississippi	75-84	Non-Hispanic Asian	19	22	0	13	28	116
Mississippi	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Mississippi	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Mississippi	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Mississippi	15-24	Hispanic	0	0	0	0	0	40
Mississippi	35-44	Hispanic	26	19	0	15	30	103
Mississippi	55-64	Hispanic	40	38	0	29	49	168
Mississippi	65-74	Hispanic	27	26	0	18	35	147
Mississippi	75-84	Hispanic	22	26	0	13	35	134
Missouri	35-44	Non-Hispanic White	358	342	10	185	525	5365
Missouri	45-54	Non-Hispanic White	916	803	21	491	1248	9623
Missouri	55-64	Non-Hispanic White	2471	2403	73	1348	3593	25545
Missouri	65-74	Non-Hispanic White	4109	4182	91	2191	6177	40663
Missouri	75-84	Non-Hispanic White	5279	5180	124	2657	7917	50699
Missouri	85+	Non-Hispanic White	5635	4768	114	2160	8350	56471
Missouri	65-74	Non-Hispanic Black	709	501	18	307	921	5837
Missouri	55-64	Non-Hispanic American Indian or Alaska Native	24	21	0	11	34	107
Missouri	65-74	Non-Hispanic American Indian or Alaska Native	28	19	0	14	33	130
Missouri	75-84	Non-Hispanic American Indian or Alaska Native	17	15	0	11	21	101
Missouri	55-64	Non-Hispanic Asian	18	21	0	15	24	157
Missouri	65-74	Non-Hispanic Asian	47	35	0	24	58	276
Missouri	75-84	Non-Hispanic Asian	37	37	0	17	57	346
Missouri	45-54	Hispanic	83	48	0	39	92	334
Missouri	55-64	Hispanic	108	88	0	70	126	465
Missouri	65-74	Hispanic	112	82	0	66	128	517
Missouri	85+	Hispanic	61	53	0	28	86	503
Montana	55-64	Non-Hispanic White	368	333	11	209	503	3738
Montana	65-74	Non-Hispanic White	725	704	18	402	1045	6850
Montana	75-84	Non-Hispanic White	948	882	24	507	1345	8949
Montana	85+	Non-Hispanic White	954	763	24	364	1376	10159
Montana	1-4	Non-Hispanic Black	0	0	0	0	0	0
Montana	85+	Non-Hispanic Black	0	0	0	0	0	10
Montana	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	12
Montana	45-54	Non-Hispanic American Indian or Alaska Native	49	41	0	27	63	360
Montana	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Montana	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Montana	35-44	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Montana	85+	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Montana	15-24	Hispanic	0	0	0	0	0	23
Montana	55-64	Hispanic	18	16	0	12	22	105
Montana	65-74	Hispanic	27	23	0	18	32	128
Montana	75-84	Hispanic	23	14	0	12	25	94
Nebraska	55-64	Non-Hispanic White	521	550	19	277	813	5853
Nebraska	65-74	Non-Hispanic White	1011	1016	26	481	1570	10332
Nebraska	75-84	Non-Hispanic White	1316	1307	23	584	2061	13274
Nebraska	85+	Non-Hispanic White	1679	1622	43	582	2757	18621
Nebraska	5-14	Non-Hispanic Black	0	0	0	0	0	16
Nebraska	75-84	Non-Hispanic Black	43	45	0	24	64	412
Nebraska	15-24	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	13
Nebraska	15-24	Non-Hispanic Asian	0	0	0	0	0	13
Nebraska	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Nebraska	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Nebraska	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Nebraska	35-44	Hispanic	23	15	0	15	23	123
Nebraska	45-54	Hispanic	53	30	0	26	57	200
Nebraska	65-74	Hispanic	70	53	0	31	92	323
Nebraska	85+	Hispanic	45	35	0	22	58	269
Nevada	55-64	Non-Hispanic White	845	1078	18	628	1312	8739
Nevada	65-74	Non-Hispanic White	1786	2372	28	1379	2806	16112
Nevada	75-84	Non-Hispanic White	2137	2685	33	1603	3248	19673
Nevada	85+	Non-Hispanic White	1488	1779	18	1076	2208	16293
Nevada	25-34	Non-Hispanic Black	30	25	0	14	41	465
Nevada	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Nevada	15-24	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	21
Nevada	35-44	Non-Hispanic American Indian or Alaska Native	14	14	0	12	16	82
Nevada	45-54	Non-Hispanic American Indian or Alaska Native	17	16	0	14	19	101
Nevada	65-74	Non-Hispanic American Indian or Alaska Native	36	48	0	31	53	211
Nevada	75-84	Non-Hispanic American Indian or Alaska Native	32	25	0	22	35	184
Nevada	15-24	Non-Hispanic Asian	0	0	0	0	0	34
Nevada	55-64	Non-Hispanic Asian	150	164	0	120	194	716
Nevada	85+	Non-Hispanic Asian	206	236	0	161	281	1409
Nevada	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Nevada	45-54	Non-Hispanic Native Hawaiian or Other Pacific Islander	33	32	0	26	39	100
Nevada	55-64	Non-Hispanic Native Hawaiian or Other Pacific Islander	33	33	0	23	43	152
Nevada	65-74	Non-Hispanic Native Hawaiian or Other Pacific Islander	38	40	0	33	45	187
Nevada	75-84	Non-Hispanic Native Hawaiian or Other Pacific Islander	20	20	0	13	27	146
Nevada	45-54	Hispanic	378	353	0	298	433	1309
New Hampshire	1-4	Non-Hispanic White	0	0	0	0	0	23
New Hampshire	5-14	Non-Hispanic White	0	0	0	0	0	43
New Hampshire	65-74	Non-Hispanic White	538	596	18	263	888	8109
New Hampshire	75-84	Non-Hispanic White	771	791	14	289	1286	10521
New Hampshire	85+	Non-Hispanic White	1073	879	25	302	1674	13639
New Hampshire	1-4	Non-Hispanic Black	0	0	0	0	0	0
New Hampshire	5-14	Non-Hispanic Black	0	0	0	0	0	0
New Hampshire	15-24	Non-Hispanic Black	0	0	0	0	0	10
New Hampshire	25-34	Non-Hispanic Black	0	0	0	0	0	27
New Hampshire	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
New Hampshire	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
New Hampshire	1-4	Non-Hispanic Asian	0	0	0	0	0	0
New Hampshire	5-14	Non-Hispanic Asian	0	0	0	0	0	0
New Hampshire	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Hampshire	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Hampshire	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Hampshire	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Hampshire	35-44	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Hampshire	75-84	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Hampshire	15-24	Hispanic	0	0	0	0	0	22
New Hampshire	65-74	Hispanic	20	12	0	10	22	73
New Jersey	1-4	Non-Hispanic White	0	0	0	0	0	47
New Jersey	55-64	Non-Hispanic White	1957	1707	23	1003	2681	18892
New Jersey	65-74	Non-Hispanic White	3795	3314	40	1872	5270	32601
New Jersey	75-84	Non-Hispanic White	5781	5153	48	2914	8065	47098
New Jersey	85+	Non-Hispanic White	8297	6916	93	3620	11682	73335
New Jersey	85+	Non-Hispanic Black	1017	744	10	427	1342	7065
New Jersey	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
New Jersey	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
New Jersey	15-24	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
New Jersey	1-4	Non-Hispanic Asian	0	0	0	0	0	13
New Jersey	35-44	Non-Hispanic Asian	23	16	0	13	26	267
New Jersey	55-64	Non-Hispanic Asian	259	192	0	131	320	1242
New Jersey	65-74	Non-Hispanic Asian	452	344	0	246	550	2144
New Jersey	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Jersey	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Jersey	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Jersey	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Mexico	1-4	Non-Hispanic White	0	0	0	0	0	18
New Mexico	25-34	Non-Hispanic White	29	27	0	16	40	561
New Mexico	45-54	Non-Hispanic White	138	131	0	69	200	1442
New Mexico	75-84	Non-Hispanic White	775	841	26	372	1268	9114
New Mexico	65-74	Non-Hispanic Black	40	33	0	24	49	307
New Mexico	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	14
New Mexico	25-34	Non-Hispanic American Indian or Alaska Native	90	65	0	43	112	784
New Mexico	75-84	Non-Hispanic American Indian or Alaska Native	333	247	0	161	419	1217
New Mexico	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Mexico	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Mexico	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New Mexico	55-64	Hispanic	644	583	12	405	834	3929
New Mexico	65-74	Hispanic	840	767	10	521	1096	4907
New Mexico	75-84	Hispanic	789	660	12	422	1037	5359
New York	45-54	Non-Hispanic White	880	897	15	414	1377	11509
New York	55-64	Non-Hispanic White	2754	3081	68	1341	4559	31106
New York	65-74	Non-Hispanic White	5541	5963	113	2583	9028	54407
New York	75-84	Non-Hispanic White	8315	8781	147	3627	13611	74687
New York	85+	Non-Hispanic White	12641	12307	241	4604	20568	112143
New York	25-34	Non-Hispanic Black	62	46	0	24	84	1093
New York	35-44	Non-Hispanic Black	139	92	0	57	174	1487
New York	85+	Non-Hispanic Black	891	819	10	402	1315	5884
New York	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
New York	25-34	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	33
New York	75-84	Non-Hispanic American Indian or Alaska Native	32	29	0	16	45	242
New York	45-54	Non-Hispanic Asian	60	41	0	28	73	349
New York	55-64	Non-Hispanic Asian	161	111	0	81	191	755
New York	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New York	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New York	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
New York	35-44	Hispanic	186	119	0	85	220	1148
New York	85+	Hispanic	646	522	12	303	876	3573
North Carolina	45-54	Non-Hispanic White	1190	1172	33	701	1694	13617
North Carolina	55-64	Non-Hispanic White	3001	3293	80	1806	4565	31532
North Carolina	65-74	Non-Hispanic White	5194	5929	122	3103	8134	52201
North Carolina	75-84	Non-Hispanic White	6631	7480	113	3557	10660	68507
North Carolina	85+	Non-Hispanic White	6463	6649	129	2828	10405	72749
North Carolina	45-54	Non-Hispanic Black	630	547	15	351	841	6072
North Carolina	55-64	Non-Hispanic Black	1318	1281	22	721	1900	12881
North Carolina	65-74	Non-Hispanic Black	1917	1922	24	1057	2806	17450
North Carolina	75-84	Non-Hispanic Black	1621	1528	20	815	2350	14994
North Carolina	85+	Non-Hispanic Black	1325	1190	15	608	1922	12762
North Carolina	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	11
North Carolina	85+	Non-Hispanic American Indian or Alaska Native	64	57	0	33	88	510
North Carolina	65-74	Non-Hispanic Asian	78	86	0	51	113	620
North Carolina	35-44	Hispanic	129	83	0	64	148	847
North Dakota	65-74	Non-Hispanic White	505	590	12	309	798	4118
North Dakota	75-84	Non-Hispanic White	688	746	16	385	1064	5470
North Dakota	85+	Non-Hispanic White	1016	888	21	429	1494	7882
North Dakota	65-74	Non-Hispanic American Indian or Alaska Native	65	65	0	39	91	356
North Dakota	1-4	Non-Hispanic Asian	0	0	0	0	0	0
North Dakota	5-14	Non-Hispanic Asian	0	0	0	0	0	0
North Dakota	45-54	Non-Hispanic Asian	0	0	0	0	0	10
North Dakota	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
North Dakota	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
North Dakota	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
North Dakota	35-44	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
North Dakota	75-84	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
North Dakota	55-64	Hispanic	15	16	0	11	20	69
Ohio	25-34	Non-Hispanic White	237	214	13	114	350	6473
Ohio	35-44	Non-Hispanic White	625	586	14	339	886	10311
Ohio	45-54	Non-Hispanic White	1754	1630	36	968	2452	18678
Ohio	55-64	Non-Hispanic White	4815	4699	105	2688	6924	46857
Ohio	65-74	Non-Hispanic White	9001	8429	153	4922	12653	76351
Ohio	75-84	Non-Hispanic White	11655	10016	165	5853	15973	94001
Ohio	85+	Non-Hispanic White	12618	9332	146	5028	17062	112203
Ohio	25-34	Non-Hispanic Black	100	85	11	36	159	2409
Ohio	45-54	Non-Hispanic Black	428	388	11	235	592	4348
Ohio	55-64	Non-Hispanic Black	978	861	18	516	1340	9166
Ohio	65-74	Non-Hispanic Black	1490	1298	14	803	1999	12251
Ohio	75-84	Non-Hispanic Black	1234	976	15	581	1643	9785
Ohio	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Ohio	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Ohio	1-4	Non-Hispanic Asian	0	0	0	0	0	10
Ohio	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Ohio	35-44	Hispanic	59	37	0	28	68	502
Ohio	45-54	Hispanic	99	79	0	58	120	602
Oklahoma	15-24	Non-Hispanic White	22	28	0	13	37	739
Oklahoma	45-54	Non-Hispanic White	720	636	18	347	1026	5948
Oklahoma	55-64	Non-Hispanic White	1749	1772	52	821	2747	14998
Oklahoma	65-74	Non-Hispanic White	3035	3213	78	1433	4880	24979
Oklahoma	75-84	Non-Hispanic White	3768	3640	82	1651	5826	30132
Oklahoma	85+	Non-Hispanic White	3442	3002	57	1257	5237	30179
Oklahoma	35-44	Non-Hispanic Black	64	49	0	23	90	591
Oklahoma	45-54	Non-Hispanic Black	131	91	0	48	174	907
Oklahoma	85+	Non-Hispanic Black	170	113	0	61	222	1397
Oklahoma	35-44	Non-Hispanic American Indian or Alaska Native	86	69	0	41	114	710
Oklahoma	65-74	Non-Hispanic American Indian or Alaska Native	476	427	11	248	665	2586
Oklahoma	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Oregon	45-54	Non-Hispanic White	347	279	14	144	495	5351
Oregon	55-64	Non-Hispanic White	861	888	25	414	1356	13299
Oregon	65-74	Non-Hispanic White	1477	1632	53	680	2481	24527
Oregon	75-84	Non-Hispanic White	2008	1944	73	802	3221	30713
Oregon	85+	Non-Hispanic White	2354	2015	76	751	3690	36783
Oregon	15-24	Non-Hispanic Black	0	0	0	0	0	81
Oregon	55-64	Non-Hispanic Black	27	29	0	15	41	407
Oregon	85+	Non-Hispanic Black	23	18	0	11	30	276
Oregon	75-84	Non-Hispanic American Indian or Alaska Native	43	27	0	23	47	279
Oregon	15-24	Non-Hispanic Asian	0	0	0	0	0	29
Oregon	85+	Non-Hispanic Asian	80	76	0	32	124	894
Oregon	55-64	Non-Hispanic Native Hawaiian or Other Pacific Islander	20	15	0	10	25	89
Oregon	45-54	Hispanic	100	59	0	45	114	568
Oregon	75-84	Hispanic	110	69	0	46	133	818
Pennsylvania	35-44	Non-Hispanic White	501	437	13	241	709	8921
Pennsylvania	45-54	Non-Hispanic White	1581	1303	24	784	2121	16540
Pennsylvania	55-64	Non-Hispanic White	4451	3980	94	2241	6274	43725
Pennsylvania	65-74	Non-Hispanic White	8407	7728	134	4299	11964	75958
Pennsylvania	75-84	Non-Hispanic White	11594	9951	211	5305	16433	100748
Pennsylvania	85+	Non-Hispanic White	15860	11386	227	5555	21897	140548
Pennsylvania	55-64	Non-Hispanic Black	992	756	27	462	1309	8999
Pennsylvania	65-74	Non-Hispanic Black	1467	1109	11	687	1900	11221
Pennsylvania	75-84	Non-Hispanic Black	1180	915	13	572	1535	9364
Pennsylvania	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Pennsylvania	35-44	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	12
Pennsylvania	5-14	Non-Hispanic Asian	0	0	0	0	0	28
Pennsylvania	55-64	Non-Hispanic Asian	99	66	0	41	124	655
Pennsylvania	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Pennsylvania	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Pennsylvania	35-44	Hispanic	107	72	0	51	128	1103
Rhode Island	45-54	Non-Hispanic White	84	99	0	48	135	1249
Rhode Island	75-84	Non-Hispanic White	854	716	15	385	1199	7724
Rhode Island	85+	Non-Hispanic White	1523	1040	30	549	2044	12311
Rhode Island	1-4	Non-Hispanic Black	0	0	0	0	0	0
Rhode Island	15-24	Non-Hispanic Black	0	0	0	0	0	19
Rhode Island	55-64	Non-Hispanic Black	39	23	0	16	46	253
Rhode Island	75-84	Non-Hispanic Black	32	18	0	13	37	235
Rhode Island	85+	Non-Hispanic Black	28	15	0	12	31	195
Rhode Island	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Rhode Island	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Rhode Island	5-14	Non-Hispanic Asian	0	0	0	0	0	0
Rhode Island	75-84	Non-Hispanic Asian	23	16	0	14	25	104
Rhode Island	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Rhode Island	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Rhode Island	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Rhode Island	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Rhode Island	45-54	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Rhode Island	55-64	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Rhode Island	65-74	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Rhode Island	75-84	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Rhode Island	45-54	Hispanic	28	21	0	19	30	180
Rhode Island	65-74	Hispanic	73	49	0	41	81	319
Rhode Island	75-84	Hispanic	75	50	0	37	88	312
South Carolina	25-34	Non-Hispanic White	87	75	0	34	128	2707
South Carolina	45-54	Non-Hispanic White	719	590	19	319	1008	7501
South Carolina	55-64	Non-Hispanic White	1814	1674	37	851	2673	17385
South Carolina	65-74	Non-Hispanic White	3286	2918	47	1511	4733	28678
South Carolina	75-84	Non-Hispanic White	3989	3613	64	1750	5911	36242
South Carolina	85+	Non-Hispanic White	3388	2863	42	1246	5043	35809
South Carolina	45-54	Non-Hispanic Black	495	329	13	184	651	3914
South Carolina	55-64	Non-Hispanic Black	1023	804	12	431	1407	8519
South Carolina	65-74	Non-Hispanic Black	1604	1269	20	691	2200	11766
South Carolina	75-84	Non-Hispanic Black	1296	999	14	565	1741	9832
South Carolina	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
South Carolina	15-24	Non-Hispanic Asian	0	0	0	0	0	16
South Carolina	55-64	Non-Hispanic Asian	23	14	0	10	27	140
South Carolina	65-74	Non-Hispanic Asian	35	27	0	18	44	206
South Carolina	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
South Carolina	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
South Carolina	35-44	Hispanic	68	32	0	28	72	327
South Carolina	55-64	Hispanic	85	51	0	45	91	391
South Dakota	45-54	Non-Hispanic White	78	90	0	49	119	950
South Dakota	55-64	Non-Hispanic White	270	316	10	164	431	2735
South Dakota	65-74	Non-Hispanic White	571	653	16	344	896	4955
South Dakota	75-84	Non-Hispanic White	758	713	19	326	1161	6166
South Dakota	85+	Non-Hispanic White	1097	817	28	364	1577	9032
South Dakota	15-24	Non-Hispanic Black	0	0	0	0	0	14
South Dakota	25-34	Non-Hispanic Black	0	0	0	0	0	13
South Dakota	45-54	Non-Hispanic American Indian or Alaska Native	53	56	0	25	84	449
South Dakota	75-84	Non-Hispanic American Indian or Alaska Native	68	64	0	42	90	328
South Dakota	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
South Dakota	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
South Dakota	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
South Dakota	75-84	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
South Dakota	1-4	Hispanic	0	0	0	0	0	0
Tennessee	35-44	Non-Hispanic White	502	538	16	284	772	7669
Tennessee	45-54	Non-Hispanic White	1490	1452	38	815	2161	14562
Tennessee	55-64	Non-Hispanic White	3349	3722	87	1921	5230	32365
Tennessee	65-74	Non-Hispanic White	5832	6373	132	3202	9126	49800
Tennessee	75-84	Non-Hispanic White	6682	7110	128	3425	10480	59600
Tennessee	85+	Non-Hispanic White	5305	5341	85	2361	8357	55414
Tennessee	45-54	Non-Hispanic Black	504	404	11	283	635	3983
Tennessee	55-64	Non-Hispanic Black	978	863	13	550	1303	7712
Tennessee	65-74	Non-Hispanic Black	1197	1112	16	647	1674	9535
Tennessee	75-84	Non-Hispanic Black	922	858	16	468	1327	7096
Tennessee	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Tennessee	45-54	Non-Hispanic Asian	26	22	0	21	27	128
Tennessee	55-64	Non-Hispanic Asian	23	21	0	14	30	182
Tennessee	65-74	Non-Hispanic Asian	51	33	0	21	63	317
Tennessee	85+	Non-Hispanic Asian	36	31	0	17	50	318
Tennessee	65-74	Hispanic	134	94	0	78	150	530
Texas	25-34	Non-Hispanic White	426	395	11	202	628	7259
Texas	35-44	Non-Hispanic White	983	930	19	544	1384	12154
Texas	45-54	Non-Hispanic White	2739	2504	38	1545	3733	23357
Texas	55-64	Non-Hispanic White	6590	6875	119	3862	9709	59060
Texas	65-74	Non-Hispanic White	11178	12367	183	6688	17018	98578
Texas	75-84	Non-Hispanic White	13378	14300	222	7456	20422	122823
Texas	85+	Non-Hispanic White	12124	11995	171	5718	18554	131877
Texas	25-34	Non-Hispanic Black	262	230	13	118	384	3960
Texas	35-44	Non-Hispanic Black	619	522	12	297	856	5633
Texas	45-54	Non-Hispanic Black	1242	1077	15	661	1673	9166
Texas	55-64	Non-Hispanic Black	2206	2091	33	1111	3215	18426
Texas	65-74	Non-Hispanic Black	2858	2870	40	1570	4196	23400
Texas	75-84	Non-Hispanic Black	2161	2210	22	1171	3216	18160
Texas	85+	Non-Hispanic Black	1428	1352	10	686	2103	14160
Texas	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Texas	45-54	Non-Hispanic American Indian or Alaska Native	26	34	0	22	38	149
Texas	55-64	Non-Hispanic American Indian or Alaska Native	57	35	0	26	66	280
Texas	85+	Non-Hispanic American Indian or Alaska Native	22	24	0	16	30	167
Texas	25-34	Non-Hispanic Asian	29	23	0	13	39	370
Texas	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	12
Texas	45-54	Non-Hispanic Native Hawaiian or Other Pacific Islander	18	15	0	10	23	87
Texas	55-64	Non-Hispanic Native Hawaiian or Other Pacific Islander	22	20	0	13	29	110
Texas	65-74	Non-Hispanic Native Hawaiian or Other Pacific Islander	14	15	0	10	19	121
Texas	25-34	Hispanic	1019	699	14	551	1181	7589
Texas	35-44	Hispanic	2537	1764	24	1434	2889	11273
Texas	45-54	Hispanic	5027	3618	44	2905	5780	19204
Texas	55-64	Hispanic	8309	6358	73	4965	9766	32220
Texas	65-74	Hispanic	9903	8063	86	6062	11969	40320
Texas	75-84	Hispanic	7866	6859	62	4745	10032	39258
Texas	85+	Hispanic	5357	4744	52	2929	7220	36727
Utah	45-54	Non-Hispanic White	266	252	10	136	392	3128
Utah	55-64	Non-Hispanic White	562	575	12	279	869	6459
Utah	65-74	Non-Hispanic White	986	1019	18	511	1509	11333
Utah	75-84	Non-Hispanic White	1210	1289	26	593	1931	15899
Utah	85+	Non-Hispanic White	1138	1122	30	427	1862	18525
Utah	65-74	Non-Hispanic American Indian or Alaska Native	47	42	0	32	57	168
Utah	65-74	Non-Hispanic Asian	32	31	0	20	43	176
Utah	55-64	Non-Hispanic Native Hawaiian or Other Pacific Islander	26	22	0	15	33	146
Utah	75-84	Hispanic	139	105	0	79	165	830
Vermont	1-4	Non-Hispanic White	0	0	0	0	0	10
Vermont	5-14	Non-Hispanic White	0	0	0	0	0	16
Vermont	75-84	Non-Hispanic White	248	316	17	76	505	4852
Vermont	85+	Non-Hispanic White	343	411	21	97	677	6541
Vermont	1-4	Non-Hispanic Black	0	0	0	0	0	0
Vermont	5-14	Non-Hispanic Black	0	0	0	0	0	0
Vermont	25-34	Non-Hispanic Black	0	0	0	0	0	14
Vermont	35-44	Non-Hispanic Black	0	0	0	0	0	16
Vermont	45-54	Non-Hispanic Black	0	0	0	0	0	12
Vermont	85+	Non-Hispanic Black	0	0	0	0	0	18
Vermont	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Vermont	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Vermont	1-4	Non-Hispanic Asian	0	0	0	0	0	0
Vermont	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Vermont	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Vermont	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Vermont	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Vermont	35-44	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Vermont	55-64	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Vermont	65-74	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Vermont	75-84	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Vermont	1-4	Hispanic	0	0	0	0	0	0
Vermont	5-14	Hispanic	0	0	0	0	0	0
Vermont	25-34	Hispanic	0	0	0	0	0	15
Vermont	35-44	Hispanic	0	0	0	0	0	15
Vermont	75-84	Hispanic	0	0	0	0	0	16
Virginia	45-54	Non-Hispanic White	618	532	10	315	845	8552
Virginia	55-64	Non-Hispanic White	1703	1587	48	817	2519	21247
Virginia	65-74	Non-Hispanic White	3171	3111	47	1584	4741	35592
Virginia	75-84	Non-Hispanic White	4245	3837	75	1824	6329	48340
Virginia	85+	Non-Hispanic White	5043	3783	78	1606	7290	57157
Virginia	55-64	Non-Hispanic Black	892	728	15	445	1190	9140
Virginia	65-74	Non-Hispanic Black	1304	1040	16	607	1752	12269
Virginia	75-84	Non-Hispanic Black	1167	953	12	543	1588	11118
Virginia	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Virginia	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
Virginia	25-34	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	13
Virginia	5-14	Non-Hispanic Asian	0	0	0	0	0	13
Virginia	45-54	Non-Hispanic Asian	31	24	0	14	41	374
Virginia	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Virginia	25-34	Hispanic	26	22	0	11	37	444
Virginia	45-54	Hispanic	165	94	0	73	186	731
Washington	35-44	Non-Hispanic White	201	259	11	132	339	4239
Washington	45-54	Non-Hispanic White	478	623	15	319	797	7742
Washington	55-64	Non-Hispanic White	1251	1724	48	842	2179	19872
Washington	65-74	Non-Hispanic White	2377	3297	89	1554	4204	35200
Washington	75-84	Non-Hispanic White	2946	3734	110	1709	5077	43877
Washington	85+	Non-Hispanic White	3519	3950	98	1675	5888	53792
Washington	35-44	Non-Hispanic Black	29	31	0	15	45	490
Washington	85+	Non-Hispanic Black	75	74	0	39	110	882
Washington	35-44	Non-Hispanic American Indian or Alaska Native	19	23	0	12	30	286
Washington	75-84	Non-Hispanic American Indian or Alaska Native	76	99	0	56	119	661
Washington	5-14	Non-Hispanic Asian	0	0	0	0	0	19
Washington	35-44	Non-Hispanic Asian	23	25	0	16	32	298
Washington	65-74	Non-Hispanic Native Hawaiian or Other Pacific Islander	51	48	0	30	69	309
Washington	75-84	Non-Hispanic Native Hawaiian or Other Pacific Islander	34	34	0	25	43	186
West Virginia	45-54	Non-Hispanic White	472	538	13	285	737	5114
West Virginia	55-64	Non-Hispanic White	1013	1275	27	572	1742	11146
West Virginia	65-74	Non-Hispanic White	1931	2420	41	1101	3286	18021
West Virginia	75-84	Non-Hispanic White	2162	2605	48	1143	3669	20228
West Virginia	85+	Non-Hispanic White	1807	1934	32	755	3015	19025
West Virginia	1-4	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
West Virginia	5-14	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
West Virginia	15-24	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
West Virginia	25-34	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	0
West Virginia	1-4	Non-Hispanic Asian	0	0	0	0	0	0
West Virginia	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
West Virginia	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
West Virginia	45-54	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
West Virginia	65-74	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
West Virginia	15-24	Hispanic	0	0	0	0	0	11
Wisconsin	35-44	Non-Hispanic White	201	142	10	71	282	3653
Wisconsin	45-54	Non-Hispanic White	543	432	14	239	748	6581
Wisconsin	55-64	Non-Hispanic White	1414	1278	33	592	2130	18228
Wisconsin	65-74	Non-Hispanic White	2787	2423	69	1191	4078	31922
Wisconsin	75-84	Non-Hispanic White	3978	3415	74	1585	5878	42597
Wisconsin	85+	Non-Hispanic White	5054	3803	99	1540	7413	58699
Wisconsin	1-4	Non-Hispanic Black	0	0	0	0	0	49
Wisconsin	55-64	Non-Hispanic American Indian or Alaska Native	36	32	0	17	51	337
Wisconsin	55-64	Non-Hispanic Asian	41	15	0	10	46	242
Wisconsin	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Wisconsin	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Wisconsin	85+	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	10
Wyoming	1-4	Non-Hispanic White	0	0	0	0	0	11
Wyoming	5-14	Non-Hispanic White	0	0	0	0	0	23
Wyoming	35-44	Non-Hispanic White	26	25	0	15	36	453
Wyoming	1-4	Non-Hispanic Black	0	0	0	0	0	0
Wyoming	55-64	Non-Hispanic Black	0	0	0	0	0	33
Wyoming	15-24	Non-Hispanic American Indian or Alaska Native	0	0	0	0	0	13
Wyoming	1-4	Non-Hispanic Asian	0	0	0	0	0	0
Wyoming	5-14	Non-Hispanic Asian	0	0	0	0	0	0
Wyoming	15-24	Non-Hispanic Asian	0	0	0	0	0	0
Wyoming	45-54	Non-Hispanic Asian	0	0	0	0	0	0
Wyoming	1-4	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Wyoming	5-14	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Wyoming	15-24	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Wyoming	25-34	Non-Hispanic Native Hawaiian or Other Pacific Islander	0	0	0	0	0	0
Wyoming	15-24	Hispanic	0	0	0	0	0	29
Wyoming	55-64	Hispanic	28	24	0	19	33	145
Wyoming	65-74	Hispanic	48	44	0	33	59	195
Wyoming	75-84	Hispanic	29	29	0	18	40	165

this section added by Yao Lu

For finding if there is competition between covid and influenza. First we calculate the correlation coefficient.

cor(covid19mod4_main$covid19_deaths,covid19mod4_main$influenza_deaths)

[1] 0.9396283

Here we find that, there is a high correlation coefficient, but why. We didn’t add the total population of the state. So the absolute number of death are confounded by the number of population of state. We can add total population later to our data set, then calculation the relative death rates. Then get correlation coefficient of relative death rate to check the competition.

If we just would like to use this data set. We can still build a model to test if the deaths are related with age. Here I add a new variable called percentage of deaths. Take covid-19 death for example.

# Let's look at the number of deaths from COVID-19 as per people's state during 2020-2023
covid19death_state <- covid19mod4_main %>% group_by(state) %>%
 summarize(sum = sum(covid19_deaths, na.rm=T))

#add a covid total column
covid19mod4_main$covidtotal <- NA

table <- table(covid19mod4_main$state)
#calculate the number of rows for each state
norow <-as.data.frame( table[1:50])

#give the value of covidtotal for each state, here we just assume the State are ranked by alphabet, if not we can use order function. 
covid19mod4_main <- covid19mod4_main[order(covid19mod4_main$state),]
covid19death_state <- covid19death_state[order(covid19death_state$state),]
norow <- norow[order(norow$Var1),]

  covid19mod4_main$covidtotal <- rep(covid19death_state$sum[1:50],norow$Freq)

covid19mod4_main$covidperc <- covid19mod4_main$covid19_deaths/covid19mod4_main$covidtotal

We will try to model. First, take age as categorical variables. Second, take age as continuous variables.

lm1 <- lm(covid19mod4_main$covidperc ~ covid19mod4_main$age)
anova(lm1)

Analysis of Variance Table

Response: covid19mod4_main$covidperc
                      Df Sum Sq  Mean Sq F value    Pr(>F)    
covid19mod4_main$age   9 2.7721 0.308015  45.038 < 2.2e-16 ***
Residuals            817 5.5875 0.006839                      
---
Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

summary(lm1)

Call:
lm(formula = covid19mod4_main$covidperc ~ covid19mod4_main$age)

Residuals:
     Min       1Q   Median       3Q      Max 
-0.16406 -0.02679  0.00000  0.01600  0.41631 

Coefficients:
                            Estimate Std. Error t value Pr(>|t|)    
(Intercept)                3.831e-16  8.816e-03   0.000   1.0000    
covid19mod4_main$age15-24  1.885e-04  1.447e-02   0.013   0.9896    
covid19mod4_main$age25-34  2.097e-03  1.539e-02   0.136   0.8916    
covid19mod4_main$age35-44  1.491e-02  1.359e-02   1.097   0.2729    
covid19mod4_main$age45-54  2.495e-02  1.233e-02   2.024   0.0433 *  
covid19mod4_main$age5-14  -1.071e-15  1.353e-02   0.000   1.0000    
covid19mod4_main$age55-64  5.991e-02  1.195e-02   5.013 6.57e-07 ***
covid19mod4_main$age65-74  9.787e-02  1.167e-02   8.387  < 2e-16 ***
covid19mod4_main$age75-84  1.271e-01  1.183e-02  10.745  < 2e-16 ***
covid19mod4_main$age85+    1.641e-01  1.236e-02  13.269  < 2e-16 ***
---
Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

Residual standard error: 0.0827 on 817 degrees of freedom
Multiple R-squared:  0.3316,    Adjusted R-squared:  0.3242 
F-statistic: 45.04 on 9 and 817 DF,  p-value: < 2.2e-16

TukeyHSD(aov(lm(covid19mod4_main$covidperc ~ covid19mod4_main$age)))

  Tukey multiple comparisons of means
    95% family-wise confidence level

Fit: aov(formula = lm(covid19mod4_main$covidperc ~ covid19mod4_main$age))

$`covid19mod4_main$age`
                     diff           lwr        upr     p adj
15-24-1-4    1.884980e-04 -0.0457017684 0.04607876 1.0000000
25-34-1-4    2.097236e-03 -0.0467184790 0.05091295 1.0000000
35-44-1-4    1.490660e-02 -0.0281946638 0.05800787 0.9849652
45-54-1-4    2.495358e-02 -0.0141665767 0.06407373 0.5824696
5-14-1-4    -8.326673e-17 -0.0429088890 0.04290889 1.0000000
55-64-1-4    5.991495e-02  0.0219972242 0.09783267 0.0000289
65-74-1-4    9.786792e-02  0.0608474262 0.13488842 0.0000000
75-84-1-4    1.270845e-01  0.0895617617 0.16460723 0.0000000
85+-1-4      1.640588e-01  0.1248337387 0.20328394 0.0000000
25-34-15-24  1.908738e-03 -0.0521698661 0.05598734 1.0000000
35-44-15-24  1.471811e-02 -0.0342639386 0.06370015 0.9945561
45-54-15-24  2.476508e-02 -0.0207531350 0.07028330 0.7804653
5-14-15-24  -1.884980e-04 -0.0490013462 0.04862435 1.0000000
55-64-15-24  5.972645e-02  0.0152374042 0.10421549 0.0009513
65-74-15-24  9.767942e-02  0.0539525615 0.14140629 0.0000000
75-84-15-24  1.268960e-01  0.0827431161 0.17104888 0.0000000
85+-15-24    1.638703e-01  0.1182618998 0.20947878 0.0000000
35-44-25-34  1.280937e-02 -0.0389235821 0.06454232 0.9987731
45-54-25-34  2.285634e-02 -0.0256097836 0.07132247 0.8937362
5-14-25-34  -2.097236e-03 -0.0536700155 0.04947554 1.0000000
55-64-25-34  5.781771e-02  0.0103168420 0.10531858 0.0047488
65-74-25-34  9.577069e-02  0.0489829104 0.14255846 0.0000000
75-84-25-34  1.249873e-01  0.0778010924 0.17217343 0.0000000
85+-25-34    1.619616e-01  0.1134107292 0.21051248 0.0000000
45-54-35-44  1.004698e-02 -0.0326579501 0.05275190 0.9991839
5-14-35-44  -1.490660e-02 -0.0611072186 0.03129401 0.9908215
55-64-35-44  4.500834e-02  0.0034021205 0.08661456 0.0220712
65-74-35-44  8.296132e-02  0.0421711090 0.12375153 0.0000000
75-84-35-44  1.121779e-01  0.0709313209 0.15342447 0.0000000
85+-35-44    1.491522e-01  0.1063511539 0.19195332 0.0000000
5-14-45-54  -2.495358e-02 -0.0674643322 0.01755717 0.6946678
55-64-45-54  3.496137e-02 -0.0025052183 0.07242795 0.0913148
65-74-45-54  7.291434e-02  0.0363560540 0.10947263 0.0000000
75-84-45-54  1.021309e-01  0.0650641262 0.13919771 0.0000000
85+-45-54    1.391053e-01  0.1003160878 0.17789443 0.0000000
55-64-5-14   5.991495e-02  0.0185080477 0.10132184 0.0002193
65-74-5-14   9.786792e-02  0.0572810434 0.13845480 0.0000000
75-84-5-14   1.270845e-01  0.0860389945 0.16813000 0.0000000
85+-5-14     1.640588e-01  0.1214514910 0.20666618 0.0000000
65-74-55-64  3.795298e-02  0.0026843553 0.07322160 0.0234207
75-84-55-64  6.716955e-02  0.0313741021 0.10296500 0.0000002
85+-55-64    1.041439e-01  0.0665677438 0.14172004 0.0000000
75-84-65-74  2.921657e-02 -0.0056270419 0.06406019 0.1919493
85+-65-74    6.619092e-02  0.0295203502 0.10286148 0.0000006
85+-75-84    3.697434e-02 -0.0002031908 0.07415187 0.0526439

In this model, the F test shows that the percentage of covid death are influenced by age group.

Turkey test also shows that there are significant difference between some groups, we can summarize some of the groups with close age to reduce the number of age group.

Then we add a new numerical variable of age.

table(covid19mod4_main$age)

  1-4 15-24 25-34 35-44 45-54  5-14 55-64 65-74 75-84   85+ 
   88    52    43    64    92    65   105   117   110    91 

covid19mod4_main <- covid19mod4_main[order(covid19mod4_main$age),]

table(covid19mod4_main$age)

  1-4 15-24 25-34 35-44 45-54  5-14 55-64 65-74 75-84   85+ 
   88    52    43    64    92    65   105   117   110    91 

norow1 <- as.data.frame(table(covid19mod4_main$age))

covid19mod4_main$age1 <- rep(c((1+4)/2,(15+24)/2,(25+34)/2,(35+44)/2,(45+54)/2,(5+14)/2,(55+64)/2,(65+74)/2,(75+84)/2, 85),norow1$Freq)


#remove 85+
covid19mod4_main <- 
  filter(covid19mod4_main, !(age1 %in% 85))

#lm

lm2 <- lm(covid19mod4_main$covidperc~covid19mod4_main$age1)

summary(lm2)

Call:
lm(formula = covid19mod4_main$covidperc ~ covid19mod4_main$age1)

Residuals:
      Min        1Q    Median        3Q       Max 
-0.104307 -0.044716 -0.004968  0.023178  0.315321 

Coefficients:
                        Estimate Std. Error t value Pr(>|t|)    
(Intercept)           -2.732e-02  5.020e-03  -5.442 7.19e-08 ***
covid19mod4_main$age1  1.656e-03  9.579e-05  17.284  < 2e-16 ***
---
Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1

Residual standard error: 0.06854 on 734 degrees of freedom
Multiple R-squared:  0.2893,    Adjusted R-squared:  0.2883 
F-statistic: 298.7 on 1 and 734 DF,  p-value: < 2.2e-16

Here we can see that there is a significant positive trend between age and percentage of covid death.