Week 8 Assignment

R Spatial Lab Assignment # 2

Task 1: Covid 19 Join

library(sf)
library(dplyr)

load("lab1_spatial_objects.RData")

names(zip_sf)
##  [1] "ZIPCODE"    "BLDGZIP"    "PO_NAME"    "POPULATION" "AREA"      
##  [6] "STATE"      "COUNTY"     "ST_FIPS"    "CTY_FIPS"   "URL"       
## [11] "SHAPE_AREA" "SHAPE_LEN"  "geometry"
names(health_sf)
##  [1] "Facility ID"                  "Facility Name"               
##  [3] "Short Description"            "Description"                 
##  [5] "Facility Open Date"           "Facility Address 1"          
##  [7] "Facility Address 2"           "Facility City"               
##  [9] "Facility State"               "Facility Zip Code"           
## [11] "Facility Phone Number"        "Facility Fax Number"         
## [13] "Facility Website"             "Facility County Code"        
## [15] "Facility County"              "Regional Office ID"          
## [17] "Regional Office"              "Main Site Name"              
## [19] "Main Site Facility ID"        "Operating Certificate Number"
## [21] "Operator Name"                "Operator Address 1"          
## [23] "Operator Address 2"           "Operator City"               
## [25] "Operator State"               "Operator Zip Code"           
## [27] "Cooperator Name"              "Cooperator Address"          
## [29] "Cooperator Address 2"         "Cooperator City"             
## [31] "Cooperator State"             "Cooperator Zip Code"         
## [33] "Ownership Type"               "Facility Location"           
## [35] "geometry"
names(nyc_retail_sf)
##  [1] "County"             "License.Number"     "Operation.Type"    
##  [4] "Establishment.Type" "Entity.Name"        "DBA.Name"          
##  [7] "Street.Number"      "Street.Name"        "Address.Line.2"    
## [10] "Address.Line.3"     "City"               "State"             
## [13] "Zip.Code"           "Square.Footage"     "Location"          
## [16] "Coords"             "geometry"
getwd()
## [1] "/Users/uwu/Documents/Rstudio/Week8"
head(zip_sf)
## Simple feature collection with 6 features and 12 fields
## Geometry type: POLYGON
## Dimension:     XY
## Bounding box:  xmin: 986490.1 ymin: 168910.5 xmax: 1043042 ymax: 189382.9
## Projected CRS: NAD83 / New York Long Island (ftUS)
##   ZIPCODE BLDGZIP  PO_NAME POPULATION     AREA STATE COUNTY ST_FIPS CTY_FIPS
## 1   11436       0  Jamaica      18681 22699295    NY Queens      36      081
## 2   11213       0 Brooklyn      62426 29631004    NY  Kings      36      047
## 3   11212       0 Brooklyn      83866 41972104    NY  Kings      36      047
## 4   11225       0 Brooklyn      56527 23698630    NY  Kings      36      047
## 5   11218       0 Brooklyn      72280 36868799    NY  Kings      36      047
## 6   11226       0 Brooklyn     106132 39408598    NY  Kings      36      047
##                    URL SHAPE_AREA SHAPE_LEN                       geometry
## 1 http://www.usps.com/          0         0 POLYGON ((1038098 188138.4,...
## 2 http://www.usps.com/          0         0 POLYGON ((1001614 186926.4,...
## 3 http://www.usps.com/          0         0 POLYGON ((1011174 183696.3,...
## 4 http://www.usps.com/          0         0 POLYGON ((995908.4 183617.6...
## 5 http://www.usps.com/          0         0 POLYGON ((991997.1 176307.5...
## 6 http://www.usps.com/          0         0 POLYGON ((994821.5 177865.7...
covid_df <- read.csv("tests-by-zcta_2021_04_23.csv")

head(covid_df)
##   MODIFIED_ZCTA                       NEIGHBORHOOD_NAME BOROUGH_GROUP
## 1         10001              Chelsea/NoMad/West Chelsea     Manhattan
## 2         10002               Chinatown/Lower East Side     Manhattan
## 3         10003 East Village/Gramercy/Greenwich Village     Manhattan
## 4         10004                      Financial District     Manhattan
## 5         10005                      Financial District     Manhattan
## 6         10006                      Financial District     Manhattan
##          label      lat       lon COVID_CASE_COUNT COVID_CASE_RATE
## 1 10001, 10118 40.75069 -73.99714             1542         5584.31
## 2        10002 40.71578 -73.98618             5902         7835.62
## 3        10003 40.73183 -73.98916             2803         5192.87
## 4        10004 40.70367 -74.01311              247         8310.58
## 5        10005 40.70609 -74.00886              413         4716.11
## 6        10006 40.70965 -74.01304              164         4849.49
##   POP_DENOMINATOR COVID_DEATH_COUNT COVID_DEATH_RATE PERCENT_POSITIVE
## 1        27613.09                35           126.75             7.86
## 2        75322.71               264           350.49            12.63
## 3        53977.81                48            88.93             6.93
## 4         2972.12                 2            67.29             6.92
## 5         8757.23                 0             0.00             6.72
## 6         3381.80                 1            29.57             6.84
##   TOTAL_COVID_TESTS
## 1             20158
## 2             48197
## 3             41076
## 4              3599
## 5              6102
## 6              2441
names(covid_df)
##  [1] "MODIFIED_ZCTA"     "NEIGHBORHOOD_NAME" "BOROUGH_GROUP"    
##  [4] "label"             "lat"               "lon"              
##  [7] "COVID_CASE_COUNT"  "COVID_CASE_RATE"   "POP_DENOMINATOR"  
## [10] "COVID_DEATH_COUNT" "COVID_DEATH_RATE"  "PERCENT_POSITIVE" 
## [13] "TOTAL_COVID_TESTS"
covid_df$MODIFIED_ZCTA <- as.character(covid_df$MODIFIED_ZCTA)

zip_covid <- left_join(zip_sf, covid_df,
                       by = c("ZIPCODE" = "MODIFIED_ZCTA"))

head(zip_covid)
## Simple feature collection with 6 features and 24 fields
## Geometry type: POLYGON
## Dimension:     XY
## Bounding box:  xmin: 986490.1 ymin: 168910.5 xmax: 1043042 ymax: 189382.9
## Projected CRS: NAD83 / New York Long Island (ftUS)
##   ZIPCODE BLDGZIP  PO_NAME POPULATION     AREA STATE COUNTY ST_FIPS CTY_FIPS
## 1   11436       0  Jamaica      18681 22699295    NY Queens      36      081
## 2   11213       0 Brooklyn      62426 29631004    NY  Kings      36      047
## 3   11212       0 Brooklyn      83866 41972104    NY  Kings      36      047
## 4   11225       0 Brooklyn      56527 23698630    NY  Kings      36      047
## 5   11218       0 Brooklyn      72280 36868799    NY  Kings      36      047
## 6   11226       0 Brooklyn     106132 39408598    NY  Kings      36      047
##                    URL SHAPE_AREA SHAPE_LEN
## 1 http://www.usps.com/          0         0
## 2 http://www.usps.com/          0         0
## 3 http://www.usps.com/          0         0
## 4 http://www.usps.com/          0         0
## 5 http://www.usps.com/          0         0
## 6 http://www.usps.com/          0         0
##                                NEIGHBORHOOD_NAME BOROUGH_GROUP label      lat
## 1                 South Jamaica/South Ozone Park        Queens 11436 40.67582
## 2                           Crown Heights (East)      Brooklyn 11213 40.67107
## 3                         Ocean Hill-Brownsville      Brooklyn 11212 40.66293
## 4 Crown Heights (West)/Prospect Lefferts Gardens      Brooklyn 11225 40.66306
## 5                     Kensington/Windsor Terrace      Brooklyn 11218 40.64348
## 6             Flatbush/Prospect Lefferts Gardens      Brooklyn 11226 40.64646
##         lon COVID_CASE_COUNT COVID_CASE_RATE POP_DENOMINATOR COVID_DEATH_COUNT
## 1 -73.79662             1888         9419.96        20042.54                64
## 2 -73.93633             5166         7996.75        64601.26               203
## 3 -73.91301             7182         9709.74        73966.99               330
## 4 -73.95423             3833         6664.50        57513.69               177
## 5 -73.97604             6199         8377.49        73995.92               218
## 6 -73.95665             7279         7476.75        97355.08               368
##   COVID_DEATH_RATE PERCENT_POSITIVE TOTAL_COVID_TESTS
## 1           319.32            17.57             11082
## 2           314.24            13.72             38560
## 3           446.14            15.64             47319
## 4           307.75            11.62             33709
## 5           294.61            13.93             45884
## 6           378.00            13.33             56287
##                         geometry
## 1 POLYGON ((1038098 188138.4,...
## 2 POLYGON ((1001614 186926.4,...
## 3 POLYGON ((1011174 183696.3,...
## 4 POLYGON ((995908.4 183617.6...
## 5 POLYGON ((991997.1 176307.5...
## 6 POLYGON ((994821.5 177865.7...
plot(zip_covid["COVID_CASE_COUNT"])

Task 2: NYC Food Retail Aggregation

Quarto markdown is different from R markdown in terms of chunk options. See chunk options at Quarto website.

unique(nyc_retail_sf$Operation.Type)
## [1] "Store"
unique(nyc_retail_sf$Establishment.Type)
##  [1] "JAC"    "A"      "JACD"   "JACDK"  "JAD"    "JABCHK" "JACHK"  "JABC"  
##  [9] "JAZ"    "JABCK"  "JACK"   "JACDHK" "JABH"   "JACH"   "JACDE"  "JABCH" 
## [17] "JABCDH" "JABK"   "JABHK"  "JABCD"  "JACG"   "JACDH"  "JADHK"  "JKA"   
## [25] "JADK"   "JAB"    "JAHK"   "JABCDK" "JACZ"   "JAK"    "JADO"   "JDA"
retail_food <- nyc_retail_sf %>%
  filter(Establishment.Type == "A")

retail_food_proj <- st_transform(retail_food, st_crs(zip_covid))

zip_retail <- st_join(zip_covid, retail_food_proj, left = TRUE)

zip_retail <- zip_retail %>%
  group_by(ZIPCODE) %>%
  summarize(
    retail_count = sum(!is.na(Establishment.Type)),
    across(c(COVID_CASE_COUNT, COVID_CASE_RATE, POP_DENOMINATOR,
             COVID_DEATH_COUNT, COVID_DEATH_RATE, 
             PERCENT_POSITIVE, TOTAL_COVID_TESTS,
             PO_NAME, COUNTY),
           first)
  )
  

zip_retail <- zip_retail %>%
  filter(ZIPCODE != "00083")

head(zip_retail)
## Simple feature collection with 6 features and 11 fields
## Geometry type: GEOMETRY
## Dimension:     XY
## Bounding box:  xmin: 971132.6 ymin: 188447.3 xmax: 992172.8 ymax: 215324.9
## Projected CRS: NAD83 / New York Long Island (ftUS)
## # A tibble: 6 × 12
##   ZIPCODE retail_count COVID_CASE_COUNT COVID_CASE_RATE POP_DENOMINATOR
##   <chr>          <int>            <int>           <dbl>           <dbl>
## 1 10001             16             1542           5584.          27613.
## 2 10002             51             5902           7836.          75323.
## 3 10003             27             2803           5193.          53978.
## 4 10004              6              247           8311.           2972.
## 5 10005              2              413           4716.           8757.
## 6 10006              2              164           4849.           3382.
## # ℹ 7 more variables: COVID_DEATH_COUNT <int>, COVID_DEATH_RATE <dbl>,
## #   PERCENT_POSITIVE <dbl>, TOTAL_COVID_TESTS <int>, PO_NAME <chr>,
## #   COUNTY <chr>, geometry <GEOMETRY [US_survey_foot]>
plot(zip_retail["retail_count"])

Task 3: NYC Health Facility Aggregation

unique(health_sf$`Facility Name`)
##    [1] "NYU Langone Rutherford"                                                                        
##    [2] "Park Ridge Family Health Center"                                                               
##    [3] "FedCare, Inc."                                                                                 
##    [4] "Parkmed NYC, LLC"                                                                              
##    [5] "St Patricks Home"                                                                              
##    [6] "Prime Home Health Services, LLC"                                                               
##    [7] "Segundo Ruiz Belvis D & T Center"                                                              
##    [8] "Fort Greene District Health Center"                                                            
##    [9] "Queens Dialysis Center"                                                                        
##   [10] "Corona Health Center"                                                                          
##   [11] "Comprehensive Health Care & Rehabilitation Services, LLC"                                      
##   [12] "PS 1"                                                                                          
##   [13] "Montefiore Medical Center - Montefiore Westchester Square"                                     
##   [14] "MS 88 Peter Rouget"                                                                            
##   [15] "South Beach Psychiatric Center"                                                                
##   [16] "Health Opportunities High School"                                                              
##   [17] "FMS-Morris Park"                                                                               
##   [18] "Cumberland Diagnostic & Treatment Center"                                                      
##   [19] "Mount Sinai Morningside"                                                                       
##   [20] "New Dorp High School"                                                                          
##   [21] "Century Medical & Dental Center, Inc."                                                         
##   [22] "Cadman Family Health Center"                                                                   
##   [23] "Middle School 142"                                                                             
##   [24] "John Adams High School"                                                                        
##   [25] "New York GI Center, LLC"                                                                       
##   [26] "Homecrest District Health Center"                                                              
##   [27] "Lenox Hill Hosp Center for Mental Health"                                                      
##   [28] "Bronx River Dialysis"                                                                          
##   [29] "Dry Harbor Nursing Home"                                                                       
##   [30] "LaClinica del Barrio"                                                                          
##   [31] "Ambulatory Psychiatric Center"                                                                 
##   [32] "Avicenna ASC, Inc."                                                                            
##   [33] "Ryan/Chelsea-Clinton Community Health Center"                                                  
##   [34] "PS 288"                                                                                        
##   [35] "Fifth Avenue Surgery Center"                                                                   
##   [36] "MS 363"                                                                                        
##   [37] "Frederick Douglas Academy"                                                                     
##   [38] "Mental Health Clinic"                                                                          
##   [39] "Brooklyn Medcare"                                                                              
##   [40] "Lower Eastside Service Center Inc"                                                             
##   [41] "Elmhurst Care Center, Inc"                                                                     
##   [42] "LIJMC-Satellite Dialysis Facility"                                                             
##   [43] "Floating Hospital (Incorporated)"                                                              
##   [44] "Split Rock Rehabilitation and Health Care Center"                                              
##   [45] "Memorial Sloan Kettering 55th Street Imaging Center"                                           
##   [46] "Housing Works East 9th Street ADHCP"                                                           
##   [47] "Ambulatory Surgery Center of Greater New York"                                                 
##   [48] "Be Well Primary Health Care Center, LLC"                                                       
##   [49] "Williamsbridge Home Dialysis Center"                                                           
##   [50] "Community Healthcare Network"                                                                  
##   [51] "Fordham-Tremont Comm Mental Health Center"                                                     
##   [52] "Project Renewal Health 45th Street Clinic"                                                     
##   [53] "HSS Ambulatory Care Clinic"                                                                    
##   [54] "Henry J. Carter Specialty Hospital"                                                            
##   [55] "Charles B Wang Comm Health Care Center"                                                        
##   [56] "Little Sisters of the Assumption Family Health"                                                
##   [57] "Excellent Home Care Services, LLC"                                                             
##   [58] "MS 293 - Global Studies"                                                                       
##   [59] "Brooklyn Hospital Center - Downtown Campus"                                                    
##   [60] "Boro Park Center for Rehabilitation and Healthcare"                                            
##   [61] "PS 457"                                                                                        
##   [62] "Long Island Jewish Medical Center Primary Care Extension Clinic"                               
##   [63] "Springfield Gardens Educational Campus"                                                        
##   [64] "Greenpoint Dialysis"                                                                           
##   [65] "Rebekah Certified Home Health Agency"                                                          
##   [66] "Family Health Center Bushwick High School"                                                     
##   [67] "Union Community Health Center"                                                                 
##   [68] "Sutphin Health Center"                                                                         
##   [69] "Union Community Health Center Comprehensive Family Dentistry"                                  
##   [70] "Mt. Sinai Adult Treatment Program"                                                             
##   [71] "Montefiore Medical Center"                                                                     
##   [72] "Jackson Avenue Family Residence"                                                               
##   [73] "CHN - Tremont"                                                                                 
##   [74] "Brian Picolo/Intermediate School #53 School Clinic"                                            
##   [75] "New York Presbyterian / Lower Manhattan Cancer Center"                                         
##   [76] "PS 83 Mendoza School"                                                                          
##   [77] "PS 11 Wt Harris/The Clinton School"                                                            
##   [78] "Bellevue Hospital Center"                                                                      
##   [79] "Ahava Medical and Rehabilitation Center"                                                       
##   [80] "Silver Lake Specialized Rehabilitation and Care Center"                                        
##   [81] "Joseph P Addabbo Family Health Center"                                                         
##   [82] "PS 042 Benjamin Altman"                                                                        
##   [83] "Eleanor Roosevelt Houses Child HC"                                                             
##   [84] "Kings Harbor Dialysis Center"                                                                  
##   [85] "Family Care Certified Services, a Division of Tri-Borough Certified Health Systems of New York"
##   [86] "Eastchester Rehabilitation and Health Care Center"                                             
##   [87] "Asian Health Center of Flushing"                                                               
##   [88] "Carol Molinaro DCI Dialysis Center"                                                            
##   [89] "PS 164"                                                                                        
##   [90] "Montefiore Medical Center - Wellness Center at Waters Place"                                   
##   [91] "Sillerman Center for Rehabilitation"                                                           
##   [92] "Bronx Gardens Rehabilitation and Nursing Center"                                               
##   [93] "PS 55 & Mott Hall III"                                                                         
##   [94] "Beacon Rehabilitation and Nursing Center"                                                      
##   [95] "PS 38"                                                                                         
##   [96] "Montefiore Dental Center@Bronx Muni Hosp"                                                      
##   [97] "West Side High School"                                                                         
##   [98] "Ridgewood Communicare Center"                                                                  
##   [99] "Utica Avenue Dialysis Clinic"                                                                  
##  [100] "Beacon Christian Community Health Center - Annex Site"                                         
##  [101] "NY-Presbyterian Brooklyn Methodist Hospital, Rehab Center and Women & Children's Clinics"      
##  [102] "Queens Dialysis at The Pavilion, LLC"                                                          
##  [103] "Brooklyn Dialysis Center"                                                                      
##  [104] "Care for the Homeless, Inc."                                                                   
##  [105] "Mobile Medical Unit"                                                                           
##  [106] "Center for Advanced Medicine"                                                                  
##  [107] "A Merryland Health Center"                                                                     
##  [108] "Elmhurst Hospital Center"                                                                      
##  [109] "New Carlton Rehab and Nursing Center, LLC"                                                     
##  [110] "ODA Primary Health Care Network Dental Clinic"                                                 
##  [111] "Public Health Solutions Brownsville Center"                                                    
##  [112] "Jamaica Hillside Dialysis"                                                                     
##  [113] "St. Mary's Hospital for Children"                                                              
##  [114] "Community Mental Health Center"                                                                
##  [115] "Park West Educational Campus"                                                                  
##  [116] "Reg Imaging and Therapeutic Rad Services"                                                      
##  [117] "Bensonhurst Clinic Treatment Program"                                                          
##  [118] "MHHC Mobile Unit"                                                                              
##  [119] "CES 126"                                                                                       
##  [120] "South Bronx Health Center"                                                                     
##  [121] "Psychiatric Out-Patient Clinic"                                                                
##  [122] "Lenox Hill Hospital"                                                                           
##  [123] "CHN Mobile Unit Two"                                                                           
##  [124] "Freedom Center of Queens"                                                                      
##  [125] "Premier Healthcare Bayside"                                                                    
##  [126] "Vincent P. Dole Clinic"                                                                        
##  [127] "CenterLight Healthcare D&TC"                                                                   
##  [128] "Hollis Park Manor Nursing Home"                                                                
##  [129] "Pediatric Dentistry Ext Clinic"                                                                
##  [130] "Women's Health & Birthing Pavilion"                                                            
##  [131] "Columbia University Health Care Inc"                                                           
##  [132] "Intermediate School 143 Eleanor Roosevelt"                                                     
##  [133] "Williamsbridge Center for Rehabilitation and Nursing"                                          
##  [134] "PS 282 Park Slope"                                                                             
##  [135] "Forest View Center for Rehabilitation & Nursing"                                               
##  [136] "Rogosin West Side"                                                                             
##  [137] "Memorial Sloan Kettering Counseling Center"                                                    
##  [138] "Incarnation Childrens Center Inc"                                                              
##  [139] "Park Gardens CHHA"                                                                             
##  [140] "Lotus Health and Wellness"                                                                     
##  [141] "Broadway Clinic"                                                                               
##  [142] "Beacon Christian Community Health Center, Inc."                                                
##  [143] "Hopkins Center for Rehabilitation and Healthcare"                                              
##  [144] "PS 153/368"                                                                                    
##  [145] "Ditmas Park Care Center"                                                                       
##  [146] "Washington Heights Family Center"                                                              
##  [147] "NY Congregational Nursing Center, Inc"                                                         
##  [148] "Woodcrest Rehabilitation & Residential Health Care Center., LLC"                               
##  [149] "P.S. 092 Adrian Hegeman"                                                                       
##  [150] "Thomas Jefferson High School"                                                                  
##  [151] "NYP/Queens Primary Care Center"                                                                
##  [152] "Wyckoff Doctors at Myrtle"                                                                     
##  [153] "Sunset Park High School"                                                                       
##  [154] "BronxCare Crotona Park Family Practice"                                                        
##  [155] "Waters Place Dialysis Center"                                                                  
##  [156] "Rose F. Kennedy Center, Children's Evaluation and Rehabilitation Center at Montefiore"         
##  [157] "U.S. Renal Care South Flushing Dialysis"                                                       
##  [158] "I. Sherwood Wright Center for Aging"                                                           
##  [159] "Third Avenue Family Health Center"                                                             
##  [160] "P. S. 142"                                                                                     
##  [161] "NEOMY Dialysis Center"                                                                         
##  [162] "Columbus Center for Medical Rehabilitation"                                                    
##  [163] "Bushwick Center for Rehabilitation and Health Care"                                            
##  [164] "Flatbush Family Health Center at NYU Langone"                                                  
##  [165] "Chelsea Center for Special Studies"                                                            
##  [166] "Greenwich Village Ambulatory Surgery Center, LLC"                                              
##  [167] "University Hospital of Brooklyn - SUNY Downstate at Bay Ridge"                                 
##  [168] "Schervier Nursing Care Center"                                                                 
##  [169] "Ponce de Leon Elementary School/PS 161"                                                        
##  [170] "Weill Cornell Imaging at NY-WGC"                                                               
##  [171] "Montefiore Radiology Ext Clinic"                                                               
##  [172] "P.S. 18"                                                                                       
##  [173] "Brooklyn Center for Rehabilitation and Residential Health Care"                                
##  [174] "Maimonides Cardiology Outpatient Center"                                                       
##  [175] "New York Surgery Center Queens, LLC"                                                           
##  [176] "Monroe Academy Campus"                                                                         
##  [177] "Primary Care Clinic"                                                                           
##  [178] "Gastroenterology Care, Inc"                                                                    
##  [179] "RiverSpring Certified Home Health Agency / RiverSpring CHHA / ElderServe CHHA"                 
##  [180] "Odyssey House of New York Inc"                                                                 
##  [181] "Myrtle Avenue Family Health Center"                                                            
##  [182] "PS 347"                                                                                        
##  [183] "35th Street Health Center"                                                                     
##  [184] "Family Health Center of Harlem"                                                                
##  [185] "Bushwick Communicare Center"                                                                   
##  [186] "James Monroe Annex"                                                                            
##  [187] "CenterLight Healthcare"                                                                        
##  [188] "The Children's Health Center of the New York Foundling"                                        
##  [189] "FMS-Eastchester"                                                                               
##  [190] "NYP/Queens Eye Care Center"                                                                    
##  [191] "Bay Ridge Surgi-Center"                                                                        
##  [192] "PS 223"                                                                                        
##  [193] "South Bronx Campus"                                                                            
##  [194] "HSS Integrative Care Center"                                                                   
##  [195] "Highbridge Woodycrest Center"                                                                  
##  [196] "Liberty Endoscopy Center"                                                                      
##  [197] "NYU Langone Brooklyn Ambulatory Surgery and Endoscopy Center"                                  
##  [198] "New Glen Oaks Nursing Home, Inc"                                                               
##  [199] "Beth Jacob Day Care"                                                                           
##  [200] "CHN - C A B S Clinic"                                                                          
##  [201] "Queens Hospital Center"                                                                        
##  [202] "P.S. 091 The Albany Avenue School"                                                             
##  [203] "Gramercy Surgery Center, Inc. - Queens"                                                        
##  [204] "NYU Langone Harkness Center for Dance Injuries"                                                
##  [205] "Avantus Harlem Green Dialysis Center"                                                          
##  [206] "Harlem Clinics #1 #3 #6 #7"                                                                    
##  [207] "Harry S. Truman High School"                                                                   
##  [208] "Split Rock Long Term Home Health Care Program"                                                 
##  [209] "Primary Care Network"                                                                          
##  [210] "Premier Home Health Care Services, Inc."                                                       
##  [211] "Margaret Tietz Nursing and Rehabilitation Center"                                              
##  [212] "Surgery of Tomorrow"                                                                           
##  [213] "P R O M E S A Inc"                                                                             
##  [214] "Hillside Manor Rehab & Extended Care Center"                                                   
##  [215] "Lower Manhattan Dialysis Center-2"                                                             
##  [216] "X148 Charles Drew Educational Campus"                                                          
##  [217] "Richmond Center for Rehabilitation and Specialty Healthcare"                                   
##  [218] "Medisys Family Care Center"                                                                    
##  [219] "Sea View Hospital, Rehabilitation Center and Home"                                             
##  [220] "Montefiore Med Center - Jack D Weiler Hosp of A Einstein College Div"                          
##  [221] "New Settlement School"                                                                         
##  [222] "Union Health Center-ILGWU"                                                                     
##  [223] "EMU Health"                                                                                    
##  [224] "PTS of Brooklyn LTHHCP"                                                                        
##  [225] "Health Care for the Homeless Center"                                                           
##  [226] "Juan Morel Campos Campus"                                                                      
##  [227] "Betances Health Center"                                                                        
##  [228] "MediDental Care"                                                                               
##  [229] "Canarsie Multi Service Center"                                                                 
##  [230] "PS 333/335"                                                                                    
##  [231] "PS 279"                                                                                        
##  [232] "FMS-Southern Manhattan Dialysis Center"                                                        
##  [233] "Rogosin Institute - Nephrology Foundation of Brooklyn East"                                    
##  [234] "PS 29 The Melrose School"                                                                      
##  [235] "All-Med & Rehabilitation of New York"                                                          
##  [236] "NYU Langone Perlmutter Cancer Center - Rego Park"                                              
##  [237] "East NY Diagnostic & Treatment Center"                                                         
##  [238] "NYU Langone Ambulatory Care Services"                                                          
##  [239] "PS 169"                                                                                        
##  [240] "Americare Certified Special Services Inc"                                                      
##  [241] "NYU Langone Hospitals"                                                                         
##  [242] "Urban Strategies/Brookdale Family Care Center"                                                 
##  [243] "Franklin Center for Rehab&Nursg ADHCP"                                                         
##  [244] "Medalliance Medical Health Services"                                                           
##  [245] "Planned Parenthood Staten Island Health Center"                                                
##  [246] "Main Street Radiology at Bayside"                                                              
##  [247] "Healthcare Choices NY, Inc."                                                                   
##  [248] "256 Mason Avenue Radiology"                                                                    
##  [249] "Bedford Medical Family Health Center Inc"                                                      
##  [250] "Bay Plaza Primary Care Center"                                                                 
##  [251] "Dental Center at North Central Bronx Hospital"                                                 
##  [252] "Queensbridge Family Health Center"                                                             
##  [253] "PS18"                                                                                          
##  [254] "Brownsville Child Health Clinic"                                                               
##  [255] "PS 136 Charles O. Dewey/Sunset Park Prep MS 821"                                               
##  [256] "St. John's Episcopal Hospital Ambulatory Care Center"                                          
##  [257] "Auburn Family Assessment Center"                                                               
##  [258] "Montefiore Medical Center - Henry & Lucy Moses Div"                                            
##  [259] "Beth Abraham Center for Rehabilitation and Nursing"                                            
##  [260] "Intermediate School 45"                                                                        
##  [261] "Promenade Rehabilitation and Health Care Center"                                               
##  [262] "PS 192/PS 325"                                                                                 
##  [263] "Church Avenue Health Center"                                                                   
##  [264] "The HUB Health Center"                                                                         
##  [265] "Rogosin Kidney Center - Auburndale"                                                            
##  [266] "New York Congregational Nursing Center LTHHCP"                                                 
##  [267] "Far Rockaway Treatment Center"                                                                 
##  [268] "Your Choice at Home, Inc."                                                                     
##  [269] "NY Hotel Trades Council&Hotel Assoc of NYC Health/Midtown Clinic"                              
##  [270] "Bay Ridge Sunset Park Dialysis Center"                                                         
##  [271] "PS 112"                                                                                        
##  [272] "Park Avenue Family Health Center"                                                              
##  [273] "Long Island Jewish Forest Hills"                                                               
##  [274] "UHB Family Health Services"                                                                    
##  [275] "Allhealth D&TC-Mobile Van"                                                                     
##  [276] "Vocational Instruction Project Community Services, Inc."                                       
##  [277] "Bridge View Nursing Home"                                                                      
##  [278] "Methadone Clinic II"                                                                           
##  [279] "William Howard Taft High School"                                                               
##  [280] "Doctor's United Inc.-Bronx"                                                                    
##  [281] "CitiCARES Community Health Center"                                                             
##  [282] "Kings County Hospital Center"                                                                  
##  [283] "Ryan/Frederick Douglass Community Health Center"                                               
##  [284] "Comprehensive Fam Care Center"                                                                 
##  [285] "U.S. Renal Care Pelham Parkway Dialysis"                                                       
##  [286] "Golden Gate Rehabilitation & Health Care Center"                                               
##  [287] "Interfaith Medical Center"                                                                     
##  [288] "Crown Heights Center for Nursing and Rehabilitation"                                           
##  [289] "JHS 117 (Joseph H Wade)"                                                                       
##  [290] "Sea Crest Dialysis Center"                                                                     
##  [291] "Staten Island University Hosp-North"                                                           
##  [292] "NYU Langone Rivergate Transplant Clinic"                                                       
##  [293] "ODA Primary Health Care Network, Inc"                                                          
##  [294] "CS 30&31/R Hernandez & L Hughes"                                                               
##  [295] "Lower Manhattan Health District"                                                               
##  [296] "CenterLight Healthcare D&TC - Grand Street Site"                                               
##  [297] "The Firehouse Health Clinic"                                                                   
##  [298] "Urban Health Plan Extension Clinic"                                                            
##  [299] "BMS Dental Genesis"                                                                            
##  [300] "Mount Sinai Brooklyn Ambulatory Infusion Center"                                               
##  [301] "Alcoholism Outpatient Clinic"                                                                  
##  [302] "Mosholu Parkway Nursing & Rehabilitation Center"                                               
##  [303] "PS 24"                                                                                         
##  [304] "P.S. 124"                                                                                      
##  [305] "Judson Health Center"                                                                          
##  [306] "All County LLC"                                                                                
##  [307] "Louis Brandeis High School"                                                                    
##  [308] "JGB Rehabilitation Corp"                                                                       
##  [309] "BronxCare MBD Family Practice"                                                                 
##  [310] "Premium Health Peds Center"                                                                    
##  [311] "Manhattanville Health Care Center"                                                             
##  [312] "Heritage Health Care"                                                                          
##  [313] "Cypress Garden Center for Nursing and Rehabilitation"                                          
##  [314] "Dialyze Direct NY, LLC"                                                                        
##  [315] "Avantus Irving Place Dialysis Center"                                                          
##  [316] "Dental Center"                                                                                 
##  [317] "M S 51- Alexander"                                                                             
##  [318] "Williamsburg Family Health Center"                                                             
##  [319] "Community Health Initiatives Inc."                                                             
##  [320] "GoldStep Ambulatory Surgery Center, LLC"                                                       
##  [321] "Mount Hope Family Practice"                                                                    
##  [322] "Metro Community Health Center Staten Island"                                                   
##  [323] "P S 64"                                                                                        
##  [324] "NYU Langone Center for Women's Imaging"                                                        
##  [325] "PS 329"                                                                                        
##  [326] "Brooklyn Surgery Center"                                                                       
##  [327] "Williamsbridge Dialysis Center"                                                                
##  [328] "Maimonides Sleep Disorder Clinic"                                                              
##  [329] "Wayne Center for Nursing & Rehabilitation"                                                     
##  [330] "Boston Post Road Dialysis Center"                                                              
##  [331] "PS 54 S Barnes"                                                                                
##  [332] "Park Gardens Rehabilitation & Nursing Center LLC"                                              
##  [333] "The New Jewish Home, Manhattan"                                                                
##  [334] "Urban Health Plan"                                                                             
##  [335] "Fort Tryon Center for Rehabilitation and Nursing"                                              
##  [336] "FMS-Nephro-Care"                                                                               
##  [337] "PS 217"                                                                                        
##  [338] "CUHC Mobile Unit"                                                                              
##  [339] "RUMC-Bayley Seton"                                                                             
##  [340] "Jamaica Health Center"                                                                         
##  [341] "HSS Dana Center"                                                                               
##  [342] "ODA Primary Health Network, Inc."                                                              
##  [343] "NYU Langone Perlmutter Cancer Center-34th Street"                                              
##  [344] "Hamilton Park Nursing and Rehabilitation Center"                                               
##  [345] "Thurgood Marshall Academy"                                                                     
##  [346] "Damian Family Care Center"                                                                     
##  [347] "Palm Gardens Dialysis Center LLC"                                                              
##  [348] "Catholic Managed Long Term Care"                                                               
##  [349] "Women's Medical Center at Corona"                                                              
##  [350] "Flushing Hospital Medical Center"                                                              
##  [351] "Stevenson Family Health Center"                                                                
##  [352] "FMS-City Dialysis Center"                                                                      
##  [353] "GuildCare Manhattan"                                                                           
##  [354] "Joseph P Addabbo-Family Health Center"                                                         
##  [355] "Maimonides Adult and Pediatric Care Newkirk Avenue"                                            
##  [356] "Lenox Hill Hospital Extension Clinic at MEETH"                                                 
##  [357] "Laurance S Rockefeller OP Pavilion"                                                            
##  [358] "Weill Cornell Imaging at New York Presbyterian"                                                
##  [359] "The Pavilion at Queens for Rehabilitation & Nursing"                                           
##  [360] "Medcare"                                                                                       
##  [361] "CHN - Dr. Betty Shabazz Center"                                                                
##  [362] "Ida G Israel Community Health Center"                                                          
##  [363] "RAMBAM Family Health Center"                                                                   
##  [364] "PS 194/Countee Cullen"                                                                         
##  [365] "Fairview Nursing Care Center Inc"                                                              
##  [366] "Brooklyn Birthing Center"                                                                      
##  [367] "NYP/Queens Special Care Center"                                                                
##  [368] "IS45 Educational Campus"                                                                       
##  [369] "Centers Home Health Revival"                                                                   
##  [370] "Beth Israel Med Center Cooper Square"                                                          
##  [371] "FMS-Nephro Care West"                                                                          
##  [372] "Mount Sinai Kidney Center"                                                                     
##  [373] "Sanford R Nalitt Inst for Cancer"                                                              
##  [374] "Staten Island University Hosp-South"                                                           
##  [375] "Peninsula Nursing and Rehabilitation Center"                                                   
##  [376] "Melrose Houses Child Health Clinic"                                                            
##  [377] "X 174"                                                                                         
##  [378] "Kingsbrook Jewish Medical Center"                                                              
##  [379] "NYU Langone Health-Cobble Hill"                                                                
##  [380] "North Central Bronx Hospital"                                                                  
##  [381] "Bella Vista Health Center"                                                                     
##  [382] "Morris Heights Health Center"                                                                  
##  [383] "APICHA Community Health Center"                                                                
##  [384] "Community Healthcare Network East New York"                                                    
##  [385] "Rockaway Care Center"                                                                          
##  [386] "NYU Langone Levit Medical Arts Pavilion"                                                       
##  [387] "CHN - Queens Center"                                                                           
##  [388] "Help One"                                                                                      
##  [389] "Staten Island Extension DTC"                                                                   
##  [390] "Settlement Health Plaza"                                                                       
##  [391] "BronxCare Center for Physical Rehabilitation"                                                  
##  [392] "P.S. 335 Granville T. Woods"                                                                   
##  [393] "Fordham-Tremont Comm Mntl Health Center"                                                       
##  [394] "Holliswood Center for Rehabilitation and Healthcare"                                           
##  [395] "Brookdale Urgent Care and Family Care Center"                                                  
##  [396] "John F. Kennedy Education Campus"                                                              
##  [397] "PS 108"                                                                                        
##  [398] "Bushwick Center for Renal Dialysis LLC"                                                        
##  [399] "Brownsville Multi-Service Family Health Center"                                                
##  [400] "NYP/Queens Family Health Center"                                                               
##  [401] "Lawrence Nursing Care Center, Inc"                                                             
##  [402] "International Community High School"                                                           
##  [403] "Atlas Park Dialysis"                                                                           
##  [404] "Calvary Hospital Inc"                                                                          
##  [405] "Chemical Dependence Treatment Program"                                                         
##  [406] "Montefiore Medical Center - Wellness Center at Melrose"                                        
##  [407] "William F Ryan Community Health Center Inc"                                                    
##  [408] "BronxCare Medical and Dental at Poe"                                                           
##  [409] "Ryan Mobile Medical Van"                                                                       
##  [410] "St Barnabas Ambulatory Care Center"                                                            
##  [411] "PS 28"                                                                                         
##  [412] "Metro Community Health Center Queens"                                                          
##  [413] "Regeis Care Center"                                                                            
##  [414] "Queens Boulevard Extended Care Facility"                                                       
##  [415] "Intermediate School 52 Inwood"                                                                 
##  [416] "Adapt Community Network"                                                                       
##  [417] "Palm Gardens NH ADHCP"                                                                         
##  [418] "Long Island Care Center Inc"                                                                   
##  [419] "MJHS Home Care"                                                                                
##  [420] "Clinton Hill Dialysis"                                                                         
##  [421] "Fort Hamilton Clinic Treatment Program"                                                        
##  [422] "New York-Presbyterian Hospital - Columbia Presbyterian Center"                                 
##  [423] "Castle Hill Family Practice"                                                                   
##  [424] "Brookdale Hospital Medical Center"                                                             
##  [425] "PS 142 - Stranahan"                                                                            
##  [426] "Williamsbridge Family Practice Center"                                                         
##  [427] "PS 86"                                                                                         
##  [428] "CHN Mobile Van V"                                                                              
##  [429] "Morris Heights Counseling Center"                                                              
##  [430] "HSS River Terrace"                                                                             
##  [431] "The Riverside"                                                                                 
##  [432] "Eye Surgery Center of New York"                                                                
##  [433] "Haven Dialysis"                                                                                
##  [434] "Little Neck Care Center"                                                                       
##  [435] "Vanderbilt Avenue Health Center"                                                               
##  [436] "Ezra Medical Center"                                                                           
##  [437] "Planned Parenthood Diane L. Max Queens Health Center"                                          
##  [438] "NYU Mobile Dental Van"                                                                         
##  [439] "Sidney Kimmel Center"                                                                          
##  [440] "Central Harlem Health Center"                                                                  
##  [441] "Mount Sinai Beth Israel"                                                                       
##  [442] "Mount Sinai Brooklyn"                                                                          
##  [443] "Laconia Dialysis"                                                                              
##  [444] "Verrazano Nursing Home"                                                                        
##  [445] "Montefiore Med Grp Aging In America"                                                           
##  [446] "The Preston Robert Tisch Center for Men's Health at NYU Langone"                               
##  [447] "Port Richmond High School"                                                                     
##  [448] "C.I.S. 303"                                                                                    
##  [449] "Hearst Childrens Center"                                                                       
##  [450] "ODA Primary Health Care Network"                                                               
##  [451] "Center for Child Health & Resiliency"                                                          
##  [452] "Rebekah Rehab and Extended Care Center"                                                        
##  [453] "Beth Israel Med Center 2-C"                                                                    
##  [454] "Bronx Health Collective"                                                                       
##  [455] "Primary Care Annex"                                                                            
##  [456] "NYU Langone Rusk Rehabilitation Brooklyn"                                                      
##  [457] "Montefiore Medical Center Henry and Lucy Moses Division Mobile Dental Van"                     
##  [458] "FMS-St. Alban's Dialysis Center"                                                               
##  [459] "Curtis High School"                                                                            
##  [460] "Sheepshead Nursing & Rehabilitation Center"                                                    
##  [461] "Methadone Clinc I"                                                                             
##  [462] "St. Nicholas Houses Child Health Clinic"                                                       
##  [463] "Inwood Diagnostic and Treatment Center, Inc."                                                  
##  [464] "Theodore Roosevelt High School"                                                                
##  [465] "Beach Gardens Rehab and Nursing Center"                                                        
##  [466] "Ahava Medical and Rehabilitation Center, LLC"                                                  
##  [467] "Thelma C. Davidson Adair Medical/Dental clinic"                                                
##  [468] "Eger Health Care and Rehabilitation Center"                                                    
##  [469] "Allhealth D & T Center-Brooklyn"                                                               
##  [470] "New East Side Nursing Home"                                                                    
##  [471] "Eastchester Road Dialysis Center"                                                              
##  [472] "Montefiore Medical Center Henry and Lucy Moses Division Mobile Dental Van #2"                  
##  [473] "Albert Tuitt Educational Academy"                                                              
##  [474] "P S 8"                                                                                         
##  [475] "Montefiore Wakefield Behavioral Health and Substance Use Disorders Clinic"                     
##  [476] "P.S. 044 Thomas C. Brown"                                                                      
##  [477] "Brooklyn Plaza Med Ctr Whitman-Ingersoll-Farragut H C"                                         
##  [478] "BronxCare Health & Wellness Center"                                                            
##  [479] "Ridgewood Dialysis Center"                                                                     
##  [480] "Millennium Dialysis"                                                                           
##  [481] "MMG - Via Verde"                                                                               
##  [482] "PS/MS 75"                                                                                      
##  [483] "Intermediate School 217 Entrada Academy & Charter School"                                      
##  [484] "Riverdale Dialysis Center"                                                                     
##  [485] "New York-Presbyterian Hospital - New York Weill Cornell Center"                                
##  [486] "The High School of Fashion Industries"                                                         
##  [487] "Erasmus Hall High School"                                                                      
##  [488] "Bronx Health Center"                                                                           
##  [489] "Bronx Park Rehabilitation & Nursing Center"                                                    
##  [490] "Mount Sinai Comprehensive Health Program - Downtown"                                           
##  [491] "Coney Island Hospital"                                                                         
##  [492] "Housing Works East New York"                                                                   
##  [493] "JHS 117 (Alternative Education Complex)"                                                       
##  [494] "Kips Bay Endoscopy Center, LLC"                                                                
##  [495] "Hebrew Home for the Aged at Riverdale"                                                         
##  [496] "JHS 220 Pershing"                                                                              
##  [497] "Cliffside Renal Dialysis"                                                                      
##  [498] "Medex Diagnostic and Treatment Center"                                                         
##  [499] "Regal Heights Rehabilitation and Health Care Center"                                           
##  [500] "Premier Healthcare D & T Center"                                                               
##  [501] "Jane Adams High School"                                                                        
##  [502] "MS145"                                                                                         
##  [503] "Bronx Medical and Wellness Center"                                                             
##  [504] "Brookdale Family Care Center at Penn Ave"                                                      
##  [505] "BOOM! Health"                                                                                  
##  [506] "Narco Freedom-Grand Concourse"                                                                 
##  [507] "NYU Mobile Dental Equip Sch Prog"                                                              
##  [508] "Fordham Nursing and Rehabilitation Center"                                                     
##  [509] "Bayard Rustin Education Complex (BREC)"                                                        
##  [510] "Farrell Community Health Center"                                                               
##  [511] "Haym Solomon Home for the Aged"                                                                
##  [512] "PS 38 Pacific"                                                                                 
##  [513] "Montefiore Medical Center-Wakefield Hospital"                                                  
##  [514] "Resort Nursing Home"                                                                           
##  [515] "Plaza Del Castilo Health Center"                                                               
##  [516] "Banana Kelly High School"                                                                      
##  [517] "Hope Center for HIV and Nursing Care"                                                          
##  [518] "Linden Center for Nursing and Rehabilitation"                                                  
##  [519] "Workmen's Circle Multicare Center"                                                             
##  [520] "The Birthing Center of NY Inc"                                                                 
##  [521] "Jerome Family Health Center"                                                                   
##  [522] "X 162 Campus"                                                                                  
##  [523] "Sumner Avenue Child Health Clinic"                                                             
##  [524] "START Treatment & Recovery Centers"                                                            
##  [525] "New York City Department of Health and Mental Hygiene"                                         
##  [526] "Personal Touch Home Aides of New York Inc"                                                     
##  [527] "Weill Cornell Imaging at NYP-61 Street"                                                        
##  [528] "CHN - Caribbean House Clinic"                                                                  
##  [529] "P. S. 97"                                                                                      
##  [530] "Intermediate School 164 Edward W. Stitt"                                                       
##  [531] "Broadway Dialysis Center"                                                                      
##  [532] "New York-Presbyterian Hospital - Allen Hospital"                                               
##  [533] "Bainbridge Nursing & Rehabilitation Center"                                                    
##  [534] "Ozone Park Dialysis"                                                                           
##  [535] "Brooklyn Gardens Nursing & Rehabilitation Center"                                              
##  [536] "Midwood Dialysis"                                                                              
##  [537] "Lakeside/Parkshore Adult Day Health Care Center"                                               
##  [538] "Calvary Hospital"                                                                              
##  [539] "X158"                                                                                          
##  [540] "Callen-Lorde Bronx"                                                                            
##  [541] "Caring Hospice Services of New York, LLC"                                                      
##  [542] "Palm Gardens Center for Nursing and Rehabilitation"                                            
##  [543] "Ambulatory Care Clinic at Union Hosp"                                                          
##  [544] "New York Artificial Kidney Center, Inc"                                                        
##  [545] "Island Rehabilitative Services Corp"                                                           
##  [546] "PS 811 M"                                                                                      
##  [547] "The Endoscopy Center of New York"                                                              
##  [548] "Intermediate School 145"                                                                       
##  [549] "P.S. 96"                                                                                       
##  [550] "Burke Rehab Sports&Physical Medicine"                                                          
##  [551] "Montefiore Rehab Medical Associates"                                                           
##  [552] "Briah Home Care"                                                                               
##  [553] "Joseph P. Addabbo Family Health Center"                                                        
##  [554] "Gan Day Care"                                                                                  
##  [555] "CHN-Long Island City Health Center"                                                            
##  [556] "Benjamin Banneker Academy"                                                                     
##  [557] "Mosholu Avenue Primary Care Center"                                                            
##  [558] "Brookdale Family Care Center-New Lots"                                                         
##  [559] "Morris High School"                                                                            
##  [560] "United Odd Fellow and Rebekah Home LTHHCP"                                                     
##  [561] "Memorial Sloan Kettering Breast and Diagnostic Imaging Center"                                 
##  [562] "Springfield Community Health Center"                                                           
##  [563] "Henry J. Carter Skilled Nursing Facility"                                                      
##  [564] "Coney Island Multi Service Center"                                                             
##  [565] "Richmond Pain Management ASC"                                                                  
##  [566] "BronxCare Dr. Martin Luther King, Jr. Health Center"                                           
##  [567] "Planned Parenthood Project Street Beat Mobile Health Center"                                   
##  [568] "The New Jewish Home Adult Day Health Care Program, Bronx"                                      
##  [569] "P S 10"                                                                                        
##  [570] "The New Jewish Home, Home Care"                                                                
##  [571] "Mount Eden Dialysis"                                                                           
##  [572] "Fieldston Lodge Care Center"                                                                   
##  [573] "Charles B Wang Community Health Center Inc"                                                    
##  [574] "Fresnius Kidney Care - Degraw Street"                                                          
##  [575] "BIMC Geriatrics Senior Health Center"                                                          
##  [576] "Continuing Treatment Program II"                                                               
##  [577] "Dr Susan Smith Mckinney Nursing and Rehabilitation Center"                                     
##  [578] "Century Medical and Dental Center"                                                             
##  [579] "Bronx Center for Rehabilitation & Health Care"                                                 
##  [580] "Girling Health Care of New York"                                                               
##  [581] "FMS-Bayside Dialysis Center"                                                                   
##  [582] "Samaritan Health Service University"                                                           
##  [583] "Evander Childs Campus"                                                                         
##  [584] "La Casa De Salud, Inc."                                                                        
##  [585] "New York Eye & Ear Outpatient Center"                                                          
##  [586] "Marie Curie Campus"                                                                            
##  [587] "NYU Langone Orthopedic Center"                                                                 
##  [588] "Allerton Dialysis"                                                                             
##  [589] "Center for Hearing and Communication"                                                          
##  [590] "Harlem Center for Nursing and Rehabilitation"                                                  
##  [591] "Mid-Bronx Endoscopy Center"                                                                    
##  [592] "The Chateau at Brooklyn Rehabilitation and Nursing Center"                                     
##  [593] "HHC Health and Home Care"                                                                      
##  [594] "PS 155"                                                                                        
##  [595] "PS 57"                                                                                         
##  [596] "Metropolitan Hospital Center"                                                                  
##  [597] "Intermediate School 218"                                                                       
##  [598] "J-Cap Inc Thomas & Marie White Health Center"                                                  
##  [599] "Michael Callen-Audre Lorde Community Health Center"                                            
##  [600] "ParCare Community Health Network"                                                              
##  [601] "NY Eye & Ear Infirmary Ext Clinic"                                                             
##  [602] "121st Street Family Health Center"                                                             
##  [603] "The Marble Hill Family Practice Center"                                                        
##  [604] "Amber Court at Home, LLC"                                                                      
##  [605] "Community Health Center of Richmond, Inc."                                                     
##  [606] "Mosdoth Day Care"                                                                              
##  [607] "Wards Island Project"                                                                          
##  [608] "Carnegie Hill Institute, Inc"                                                                  
##  [609] "Amsterdam Center"                                                                              
##  [610] "Waterview Nursing Care Center"                                                                 
##  [611] "Methadone Clinic III"                                                                          
##  [612] "William F. Ryan Community Health Center, Inc."                                                 
##  [613] "Barnabas Hospital Methadone"                                                                   
##  [614] "M.S. 54 Booker T. Washington"                                                                  
##  [615] "Hospital for Special Surgery"                                                                  
##  [616] "WCINYP at 53 Beekman"                                                                          
##  [617] "NYU Langone Ambulatory Surgery Center"                                                         
##  [618] "Hutchinson River Dialysis"                                                                     
##  [619] "Maimonides Medical Center"                                                                     
##  [620] "Premium Health"                                                                                
##  [621] "CHN Mobile Van IV"                                                                             
##  [622] "Metro Community Health Center Bronx"                                                           
##  [623] "Methadone 1"                                                                                   
##  [624] "Bensonhurst Center for Rehabilitation and Healthcare"                                          
##  [625] "Parker Jewish Institute for Health Care & Rehab"                                               
##  [626] "VNA of Staten Island"                                                                          
##  [627] "Callen-Lorde Integrated Health Center"                                                         
##  [628] "Lasante Health Center"                                                                         
##  [629] "Chinatown Dialysis Center, LLC"                                                                
##  [630] "Royal Care Certified Home Health Care, LLC"                                                    
##  [631] "Rutland Nursing Home, Inc."                                                                    
##  [632] "The Phoenix Rehabilitation and Nursing Center"                                                 
##  [633] "Metro Community Health Center Brooklyn"                                                        
##  [634] "Selfhelp Family Home Care"                                                                     
##  [635] "St Vincent Depaul Residence"                                                                   
##  [636] "Rogosin Institute Brooklyn Home Dialysis"                                                      
##  [637] "Maimonides Cancer Center"                                                                      
##  [638] "Queens Nassau Rehabilitation and Nursing Center"                                               
##  [639] "Ramon Velez Health Center"                                                                     
##  [640] "Staten Island University Hospital University Hospice"                                          
##  [641] "Inwood Health Center"                                                                          
##  [642] "Queens-Long Island Renal Institute"                                                            
##  [643] "Washington Irving High School"                                                                 
##  [644] "Manhattan Avenue Health Center"                                                                
##  [645] "Weill Cornell Imaging at NYP-West Side"                                                        
##  [646] "I S 49"                                                                                        
##  [647] "PS 382"                                                                                        
##  [648] "Dyker Heights Dialysis Center"                                                                 
##  [649] "Memorial Sloan Kettering 64th Street Outpatient Center"                                        
##  [650] "Morris Heights at Melrose Ave"                                                                 
##  [651] "Harlem Hospital Center"                                                                        
##  [652] "Carmel Richmond Healthcare and Rehabilitation Center"                                          
##  [653] "Far Rockaway Center for Rehabilitation and Nursing"                                            
##  [654] "Seagate Rehabilitation and Nursing Center"                                                     
##  [655] "Queens Boulevard Extended Care Facility Dialysis Center"                                       
##  [656] "HSS Physiatry & Pain Management"                                                               
##  [657] "Philip Randolph Campus HS"                                                                     
##  [658] "Northern Manor ADHCP"                                                                          
##  [659] "PS 48"                                                                                         
##  [660] "Boricua Community Health Center"                                                               
##  [661] "Caring Family Nursing and Rehabilitation Center"                                               
##  [662] "Path Center"                                                                                   
##  [663] "Mott Haven Campus"                                                                             
##  [664] "Avantus Upper Manhattan Dialysis Center"                                                       
##  [665] "South Bronx Dialysis Center"                                                                   
##  [666] "BMS at Genesis"                                                                                
##  [667] "Woodside Houses Child Health Center"                                                           
##  [668] "I S 166"                                                                                       
##  [669] "J.H.S. 062 Ditmas"                                                                             
##  [670] "Bushwick Educational Campus"                                                                   
##  [671] "Narco Freedom-561 Court Street"                                                                
##  [672] "West Side GI"                                                                                  
##  [673] "Century Medical and Dental Center, Inc."                                                       
##  [674] "Avon Foundation Breast Imaging Center"                                                         
##  [675] "CHC Surgical Center, LLC"                                                                      
##  [676] "Schulman and Schachne Institute for Nursing And Rehabilitation"                                
##  [677] "Brookdale Family Care Center Inc"                                                              
##  [678] "Four Seasons Nursing and Rehabilitation Center"                                                
##  [679] "Renaissance Health Care Network"                                                               
##  [680] "Morris Heights Center 233rd Street"                                                            
##  [681] "Maimonides Adult/Ped Dental Center"                                                            
##  [682] "X198"                                                                                          
##  [683] "ODA Primary Health Care Network, Inc."                                                         
##  [684] "Bedford Health Clinic"                                                                         
##  [685] "Maimonides Women's Services 9th Avenue"                                                        
##  [686] "Mobile Eye Clinic"                                                                             
##  [687] "PS 59"                                                                                         
##  [688] "NewYork-Presbyterian/Queens"                                                                   
##  [689] "PS 197/John Russwurm"                                                                          
##  [690] "Island Ambulatory Surgery Center, L.L.C."                                                      
##  [691] "Mobile Medical 4"                                                                              
##  [692] "Samaritan Health Village 53rd St"                                                              
##  [693] "Beth Israel Med Center #2"                                                                     
##  [694] "BMS at Ashford"                                                                                
##  [695] "IDCC Health Services"                                                                          
##  [696] "Triboro Center for Rehabilitation and Nursing"                                                 
##  [697] "East Tremont Medical Center"                                                                   
##  [698] "Settlement Health"                                                                             
##  [699] "St Martin De Porres Clinic"                                                                    
##  [700] "HSS ASC of Manhattan"                                                                          
##  [701] "St Mary's Center ADHCP"                                                                        
##  [702] "Kew Gardens Dialysis Center"                                                                   
##  [703] "One Fordham Plaza"                                                                             
##  [704] "Meadow Park Rehabilitation and Health Care Center LLC"                                         
##  [705] "East Haven Nursing & Rehabilitation Center"                                                    
##  [706] "Center for Health Services-Midwood"                                                            
##  [707] "Brook Plaza Ambulatory Surgical Center Inc"                                                    
##  [708] "The Children's Aid Society"                                                                    
##  [709] "Medcare LLC"                                                                                   
##  [710] "HSS East Side Outpatient Center"                                                               
##  [711] "Mapleton Clinic Treatment Program"                                                             
##  [712] "Child Protection Center"                                                                       
##  [713] "Doctors United, Inc."                                                                          
##  [714] "Upper East Side Rehabilitation and Nursing Center"                                             
##  [715] "NYP/Queens Wound Healing Center"                                                               
##  [716] "Fort Tryon Long Term Home Health Care Program"                                                 
##  [717] "In-Tech Academy"                                                                               
##  [718] "FMS-Atlantic Peritoneal Dialysis & Home Training Center"                                       
##  [719] "Third Avenue Imaging LLC"                                                                      
##  [720] "St. Joseph's Medical Center Imaging Center"                                                    
##  [721] "ColumbiaDoctors/NewYork-Presbyterian Imaging"                                                  
##  [722] "Callen-Lorde Mobile Medical Unit"                                                              
##  [723] "P.S./I.S. 157 The Benjamin Health & Science Academy"                                           
##  [724] "Main Street Radiology at Bayside LLC"                                                          
##  [725] "Bedford Center for Nursing and Rehabilitation"                                                 
##  [726] "Grand Concourse Dialysis Facility"                                                             
##  [727] "Harlem Health Center"                                                                          
##  [728] "Johnathan Williams Houses Child HC"                                                            
##  [729] "Visiting Nurse Service of New York Home Care"                                                  
##  [730] "Advanced Endoscopy Center"                                                                     
##  [731] "Wm F Ryan Community Health Center Inc-NENA"                                                    
##  [732] "Rockwell Dialysis Center"                                                                      
##  [733] "FMS-South Queens Dialysis Center"                                                              
##  [734] "Midtown Surgery Center"                                                                        
##  [735] "Forest Hills Hospital Extension Clinic"                                                        
##  [736] "Jeanne Jugan Residence"                                                                        
##  [737] "Bezalel Rehabilitation and Nursing Center"                                                     
##  [738] "Morris Heights at Walton Avenue"                                                               
##  [739] "NY-Presbyterian Brooklyn Methodist Hospital Infusion Services"                                 
##  [740] "Endoscopic Diagnostic and Treatment Center, LLC"                                               
##  [741] "CenterLight Healthcare Diagnostic and Treatment Center"                                        
##  [742] "Crown Heights Child & Adolescent Health Clinic"                                                
##  [743] "L'Refuah Medical & Rehabilitation Center"                                                      
##  [744] "P.S. 5"                                                                                        
##  [745] "Ralph Avenue Health Center"                                                                    
##  [746] "BMS ISIS at Bristol"                                                                           
##  [747] "Planned Parenthood Bronx Health Center"                                                        
##  [748] "Rockefeller University Hospital"                                                               
##  [749] "NYU Langone Hassenfeld and Fink Children's Center"                                             
##  [750] "Queens Endoscopy ASC, LLC"                                                                     
##  [751] "West Lawrence Care Center, LLC"                                                                
##  [752] "Morrisania Dialysis Center"                                                                    
##  [753] "Low Lead Clinic"                                                                               
##  [754] "Sidney R. Baer, Jr. Health Center"                                                             
##  [755] "Queen of Peace Residence"                                                                      
##  [756] "P S 95"                                                                                        
##  [757] "Perry Avenue Family Medical Center, Inc."                                                      
##  [758] "PS 352/375"                                                                                    
##  [759] "Parsons Community Health Center"                                                               
##  [760] "Jamaica Hospital Medical Center"                                                               
##  [761] "Shore View Nursing & Rehabilitation Center"                                                    
##  [762] "Jacobi Medical Center"                                                                         
##  [763] "SUNY-Parkside Dialysis Center"                                                                 
##  [764] "Franklin Center for Rehabilitation and Nursing"                                                
##  [765] "New York Medical and Diagnostic Center"                                                        
##  [766] "Wyckoff Heights Medical Center Extension Clinic"                                               
##  [767] "Staten Island Dialysis Center"                                                                 
##  [768] "SBH Health System"                                                                             
##  [769] "Menorah Home & Hospital for Aged & Infirm"                                                     
##  [770] "The Door - A Center of Alternatives"                                                           
##  [771] "Fairview Adult Day Care Center"                                                                
##  [772] "Terence Cardinal Cooke Health Care Center"                                                     
##  [773] "Gramercy Surgery Center, Inc"                                                                  
##  [774] "HSS Sports Performance Center"                                                                 
##  [775] "Pelham Parkway Nursing Care and Rehabilitation Facility LLC"                                   
##  [776] "Kingsbrook Jewish Medical Center Inc. - Rutland Nursing Home"                                  
##  [777] "NY-Presbyterian Brooklyn Methodist Hospital Cardio-Vascular Services"                          
##  [778] "Psych/Alcoholism Treatment Pgm"                                                                
##  [779] "Premier Healthcare Tremont Avenue"                                                             
##  [780] "New York Community Hospital of Brooklyn, Inc"                                                  
##  [781] "TapCo Campus"                                                                                  
##  [782] "Dr. Susan Smith McKinney - Neponsit ADHCP"                                                     
##  [783] "NYU Langone Occupational and Industrial Orthopaedic Center (OIOC)"                             
##  [784] "Brookdale Physicians Dialysis Associates, Inc"                                                 
##  [785] "SurgiCare of Brooklyn"                                                                         
##  [786] "Riverside Health Center"                                                                       
##  [787] "East Harlem Council for Human Services Inc"                                                    
##  [788] "Norman Thomas High School"                                                                     
##  [789] "August Martin High School"                                                                     
##  [790] "Sapphire Center for Rehabilitation and Nursing of Central Queens, LLC"                         
##  [791] "DCI-Narrows Kidney Center"                                                                     
##  [792] "Morrisania Diagnostic & Treatment Center"                                                      
##  [793] "Wyckoff Heights Medical Center"                                                                
##  [794] "Physicians Choice Surgicenter"                                                                 
##  [795] "Lafayette Medical Approach, LLC"                                                               
##  [796] "Isabella Geriatric Center Inc"                                                                 
##  [797] "Union Square Eye Care - Harlem"                                                                
##  [798] "Brooklyn Community Dialysis"                                                                   
##  [799] "Quality First Medical Center"                                                                  
##  [800] "Brookdale Family Care Center-Flatbush"                                                         
##  [801] "Hillside Polymedic Diagnostic and Treatment Center"                                            
##  [802] "New York University Dental Center"                                                             
##  [803] "BronxCare Ogden Family Medical and Dental Center"                                              
##  [804] "Center for Radiation Therapy"                                                                  
##  [805] "PS 105"                                                                                        
##  [806] "Ambulatory Care Pavilion"                                                                      
##  [807] "Health Center at Gunhill"                                                                      
##  [808] "Soundview Dialysis Center"                                                                     
##  [809] "University Ave Family Practice Center"                                                         
##  [810] "Highland Care Center"                                                                          
##  [811] "NYU Winthrop NYC Cyberknife"                                                                   
##  [812] "Interfaith Medical Center-St. Mark's"                                                          
##  [813] "Gold Crest Care Center"                                                                        
##  [814] "Phoenix House Long Island City Family Health Center"                                           
##  [815] "Adolescent Health and Wellness Center"                                                         
##  [816] "The Citadel Rehab and Nursing Center at Kingsbridge"                                           
##  [817] "PS 15"                                                                                         
##  [818] "The Heritage Rehabilitation and Health Care Center"                                            
##  [819] "Morningside Nursing and Rehabilitation Center"                                                 
##  [820] "Queens Village Dialysis Center"                                                                
##  [821] "Morris Heights Health Center Mobile Van"                                                       
##  [822] "PS 971"                                                                                        
##  [823] "NYP/Queens Trude Weishaupt Memorial Satellite Dialysis Center"                                 
##  [824] "Housing Works Services II"                                                                     
##  [825] "Carnegie Hill Endoscopy, LLC"                                                                  
##  [826] "Amsterdam Nursing Home Corp (1992)"                                                            
##  [827] "New Alternatives for Children Inc"                                                             
##  [828] "Yeled V'Yalda Childhood Center"                                                                
##  [829] "Pinnacle Multicare Nursing and Rehabilitation Center"                                          
##  [830] "South Brooklyn Nephrology Center"                                                              
##  [831] "Wyckoff Heights Medical Center Pediatric Center"                                               
##  [832] "Manhattan Center for Math & Science"                                                           
##  [833] "Charles B Rangel Comm Health Center"                                                           
##  [834] "I S 90"                                                                                        
##  [835] "Methodist Home for Nursing and Rehabilitation"                                                 
##  [836] "Manhattan Surgery Center"                                                                      
##  [837] "Richmond Hill Clinic"                                                                          
##  [838] "Memorial Hospital for Cancer and Allied Diseases"                                              
##  [839] "University Eye Center"                                                                         
##  [840] "MS 424"                                                                                        
##  [841] "RUMC Behavioral Health Pavilion"                                                               
##  [842] "Upper Room AIDS Ministry ADHC"                                                                 
##  [843] "SurgiCare of Manhattan, LLC"                                                                   
##  [844] "Sunset Terrace Family Health Center at NYU Langone"                                            
##  [845] "Brooklyn Health Center"                                                                        
##  [846] "Maimonides Adult Primary Care 57th Street"                                                     
##  [847] "New York Eye and Ear Infirmary of Mount Sinai"                                                 
##  [848] "Grand Manor Nursing & Rehabilitation Center"                                                   
##  [849] "Cliffside Rehabilitation & Residential Health Care Center"                                     
##  [850] "Rego Park Nursing Home"                                                                        
##  [851] "Calvary Home Health Agency and Hospice Care"                                                   
##  [852] "Project Renewal Health Ft. Washington"                                                         
##  [853] "Fordham Tremont Comm Mentl Health Center"                                                      
##  [854] "Planned Parenthood Margaret Sanger Center"                                                     
##  [855] "Union Plaza Care Center"                                                                       
##  [856] "Allhealth D&T Center-Brooklyn2"                                                                
##  [857] "PS 256 Benjamin Banneker"                                                                      
##  [858] "Norwegian Christian Home and Health Center"                                                    
##  [859] "New York-Presbyterian David H. Koch Center"                                                    
##  [860] "Neponsit Health Care Center"                                                                   
##  [861] "NewYork-Presbyterian Brooklyn Methodist Hospital"                                              
##  [862] "Morrisania-Mott Haven"                                                                         
##  [863] "PS 155-William Pacca"                                                                          
##  [864] "The Endoscopy Center of Queens"                                                                
##  [865] "Clearview Dialysis"                                                                            
##  [866] "NY Med"                                                                                        
##  [867] "New Vanderbilt Rehabilitation and Care Center, Inc"                                            
##  [868] "Bedford Stuyvesant Family Health Center Inc"                                                   
##  [869] "Bella Vista Community Health Center"                                                           
##  [870] "Newtown Dialysis Center, Inc"                                                                  
##  [871] "Washington Heights ACNC-Audubon"                                                               
##  [872] "Far Rockaway HS Clinic"                                                                        
##  [873] "King David Center for Nursing and Rehabilitation"                                              
##  [874] "PS 13"                                                                                         
##  [875] "Montefiore Medical Center Home Care and Extended Services"                                     
##  [876] "Avantus Upper East Side Dialysis Center"                                                       
##  [877] "Extended Home Care"                                                                            
##  [878] "Housing Works Health Services III"                                                             
##  [879] "Elmhurst Voyages High School"                                                                  
##  [880] "MJHS Hospice and Palliative Care, Inc."                                                        
##  [881] "Atrium Center for Rehabilitation and Nursing"                                                  
##  [882] "Dyckman Family Health Center"                                                                  
##  [883] "South Brooklyn Endoscopy Center"                                                               
##  [884] "Hospice of New York"                                                                           
##  [885] "2021 Grand Concourse"                                                                          
##  [886] "J. H. S. 22"                                                                                   
##  [887] "Franklin K Lane"                                                                               
##  [888] "Metropolitan Jewish Long Term Home Care"                                                       
##  [889] "NYU Langone Rusk Ambulatory Care Center"                                                       
##  [890] "Herbert H. Lehman High School"                                                                 
##  [891] "P.S. 179"                                                                                      
##  [892] "Melrose Dialysis"                                                                              
##  [893] "Kings Harbor Multicare Center"                                                                 
##  [894] "Union Community Health Center Ext Clinic"                                                      
##  [895] "Mount Sinai Queens Physician Associates"                                                       
##  [896] "Montefiore-Einstein Cancer Center"                                                             
##  [897] "Odyssey House Mabon Clinic"                                                                    
##  [898] "LMRC Mobile Unit"                                                                              
##  [899] "Dewitt Clinton High School"                                                                    
##  [900] "Greenpoint Community Health Center"                                                            
##  [901] "Mount Hope Dialysis Center"                                                                    
##  [902] "Millenium Ambulatory Surgery Center"                                                           
##  [903] "Coler Rehabilitation and Nursing Care Center"                                                  
##  [904] "Rogosin Kidney Center"                                                                         
##  [905] "Cobble Hill Health Center, Inc"                                                                
##  [906] "Walton Family Practice"                                                                        
##  [907] "Windsor Park Nursing Home"                                                                     
##  [908] "I S 302"                                                                                       
##  [909] "HSS Spine Therapy Center"                                                                      
##  [910] "PS 161/Pedro Albizu Campos"                                                                    
##  [911] "South Shore Educational Complex"                                                               
##  [912] "Mobile Van Dental Clinic"                                                                      
##  [913] "South Queens Community Center"                                                                 
##  [914] "BronxCare Dental Services"                                                                     
##  [915] "Casa Promesa Primary Medical Care Services"                                                    
##  [916] "P.S. 002 Meyer London"                                                                         
##  [917] "Queens Boulevard ASC, LLC"                                                                     
##  [918] "Bay Street Health Center"                                                                      
##  [919] "Brooklyn United Methodist Continuum Services"                                                  
##  [920] "Lower Manhattan Dialysis Center Inc"                                                           
##  [921] "Maimonides Pediatric Care 57th Street"                                                         
##  [922] "Beth Israel Med Center 8 & 8-D"                                                                
##  [923] "Abraham Lincoln (K410)"                                                                        
##  [924] "Atara Home Care"                                                                               
##  [925] "New York Neuro & Rehab Center"                                                                 
##  [926] "Psychiatric Day Treatment Clinic"                                                              
##  [927] "Nelson Avenue Family Residence"                                                                
##  [928] "Saints Joachim & Anne Nursing and Rehabilitation Center"                                       
##  [929] "Covenant House"                                                                                
##  [930] "Center for Womens Health"                                                                      
##  [931] "Women's Health Center Ext Clinic"                                                              
##  [932] "Martin Luther King Jr High School"                                                             
##  [933] "Choices Women's Medical Center Inc"                                                            
##  [934] "NYU Langone Orthopedic Hospital"                                                               
##  [935] "Montefiore Einstein Center for Heart and Vascular Care at 1628 Eastchester Road"               
##  [936] "Sheepshead Bay Surgery Center"                                                                 
##  [937] "Gateway Dialysis Center"                                                                       
##  [938] "Mott Hall Campus"                                                                              
##  [939] "CS 200/James Mccune Smith"                                                                     
##  [940] "Project Renewal Inc Mobile Medical Van (Care Van)"                                             
##  [941] "NYP/Queens Dental Services Center"                                                             
##  [942] "Hudson Pointe at Riverdale Center for Nursing and Rehabilitation"                              
##  [943] "Sheepshead Bay Renal Care Center"                                                              
##  [944] "NYU Langone Perlmutter Cancer Center - Midwood"                                                
##  [945] "Greenwich House Counseling Center"                                                             
##  [946] "Urban Horizons Family Practice"                                                                
##  [947] "Springfield Dialysis Center"                                                                   
##  [948] "Coney Island Hospital Mobile Extension Clinic"                                                 
##  [949] "Betances Health Center at Henry Street Settlement"                                             
##  [950] "PS/MS 306"                                                                                     
##  [951] "Bedford Park Dialysis Center"                                                                  
##  [952] "NYS Veterans Home In NYC"                                                                      
##  [953] "Premier Healthcare Remsen Street"                                                              
##  [954] "Richmond University Medical Center"                                                            
##  [955] "First Medcare Primary Care Center - School-Based Mobile Dental Equipment Clinic"               
##  [956] "Spring Creek Rehabilitation & Nursing Care Center"                                             
##  [957] "Casa Promesa"                                                                                  
##  [958] "Project Renewal, Inc"                                                                          
##  [959] "Pierre Toussaint Family Health Care Center"                                                    
##  [960] "Peninsula Community Health Center"                                                             
##  [961] "BronxCare Special Care Center"                                                                 
##  [962] "Borough Park Dialysis"                                                                         
##  [963] "Workmens Circle Dialysis Center"                                                               
##  [964] "Harlem Children's Zone Promise Academy 2"                                                      
##  [965] "Staten Island Care Center"                                                                     
##  [966] "North Queens Surgical Center"                                                                  
##  [967] "PS 180 Hugo Newman College Preparatory School"                                                 
##  [968] "Midway Nursing Home"                                                                           
##  [969] "Greater New York Endoscopy Surgical Center"                                                    
##  [970] "Julia Richman High School"                                                                     
##  [971] "Walton High Campus"                                                                            
##  [972] "PS 257"                                                                                        
##  [973] "City Wide Health Facility Inc."                                                                
##  [974] "Reality House Clinic"                                                                          
##  [975] "Park Avenue Dialysis Center, LLC"                                                              
##  [976] "General Clinical Research Center"                                                              
##  [977] "BronxCare Hospital Center"                                                                     
##  [978] "Retinal Ambulatory Surgery Center of New York Inc"                                             
##  [979] "850 Grand St Campus High School"                                                               
##  [980] "Montefiore Medical Center - Wellness Center at Port Morris"                                    
##  [981] "All City Family Healthcare Center, Inc."                                                       
##  [982] "Intermediate School 136"                                                                       
##  [983] "East Side Endoscopy and Pain Management Center"                                                
##  [984] "Central Park Dialysis Center"                                                                  
##  [985] "7th Avenue Family Heatlh Center at NYU Langone"                                                
##  [986] "Memorial Sloan Kettering Brooklyn Infusion Center"                                             
##  [987] "Laconia Nursing Home"                                                                          
##  [988] "NYP/Queens Developmental Disability, Neuro Science Center and Pediatric Asthma Center"         
##  [989] "Manhattan Endoscopy Center, LLC"                                                               
##  [990] "Cloves Lakes Health Care & Rehab Center"                                                       
##  [991] "First Medcare Primary Care Center"                                                             
##  [992] "Public Health Solutions Fort Greene Center"                                                    
##  [993] "NYU Langone Hospital-Brooklyn"                                                                 
##  [994] "CenterLight Certified Home Health Agency"                                                      
##  [995] "CHN Mobile Unit Three"                                                                         
##  [996] "Rogosin Kidney Center-Bklyn Dialysis"                                                          
##  [997] "PS 503 and Ps 506"                                                                             
##  [998] "Mount Sinai West"                                                                              
##  [999] "NYU Langone Center for Women's Health"                                                         
## [1000] "JHS 22 (Jordan L Mott)"                                                                        
## [1001] "VNSNY Hospice and Palliative Care"                                                             
## [1002] "Brooklyn Hospital Center Extension Clinic"                                                     
## [1003] "BronxCare Tiffany Medical and Pediatric Practice"                                              
## [1004] "The Mackool Eye Institute LLC"                                                                 
## [1005] "Jamaica Hospital Mental Health Clinic"                                                         
## [1006] "Brookhaven Rehabilitation & Health Care Center LLC"                                            
## [1007] "Bronx Regional High School"                                                                    
## [1008] "Starhill Clinic"                                                                               
## [1009] "The Institute for Family Health at Westchester Square"                                         
## [1010] "Sterling Health Center"                                                                        
## [1011] "Metro Community Health Centers Downtown Brooklyn"                                              
## [1012] "United Wire Metal & Machine Medical Center"                                                    
## [1013] "The Floating Hospital"                                                                         
## [1014] "Endoscopic Ambulatory Specialty Center of Bay Ridge, Inc."                                     
## [1015] "Mariners Harbor Family Health Center"                                                          
## [1016] "Quality Kidney Care"                                                                           
## [1017] "Lafayette Houses Child Health Clinic"                                                          
## [1018] "Institute for Urban Family Health/Sidney Hillman Center"                                       
## [1019] "Planned Parenthood Joan Malin Brooklyn Health Center"                                          
## [1020] "NYU Langone Transplant Clinic (Rivergate Extension)"                                           
## [1021] "FMS-Queens Artifical Kidney Center"                                                            
## [1022] "St Marys Center Inc"                                                                           
## [1023] "Physicare Multi-Services, Ltd"                                                                 
## [1024] "Castle Hill Medical Center of New York Inc."                                                   
## [1025] "Central Brooklyn Dialysis Center, LLC"                                                         
## [1026] "HSS East River Professional Building"                                                          
## [1027] "Haven Manor Health Care Center,LLC"                                                            
## [1028] "BronxCare Third Avenue Medical and Dental Practice"                                            
## [1029] "St Barnabas Hospital-Hemodialysis"                                                             
## [1030] "Montefiore North Broadway Dental Clinic"                                                       
## [1031] "Beth Israel Med Center 1-E 2-F 3-G"                                                            
## [1032] "The Plaza Rehab and Nursing Center"                                                            
## [1033] "P S 28 Mt Hope Elementary School"                                                              
## [1034] "Sunrise/Parkshore Adult Day Health Care Center"                                                
## [1035] "Sheepshead Nursing&Rehab Center ADHCP"                                                         
## [1036] "Comprehensive Health Care Center"                                                              
## [1037] "CS 46/Tappan"                                                                                  
## [1038] "Brooklyn-Queens Nursing Home"                                                                  
## [1039] "Mount Sinai Hospital - Mount Sinai Hospital Queens"                                            
## [1040] "Concord Nursing and Rehabilitation Center"                                                     
## [1041] "Mobile Dental Unit"                                                                            
## [1042] "Montefiore Hutchinson Campus"                                                                  
## [1043] "Mary Manning Walsh Nursing Home Co Inc"                                                        
## [1044] "PS 243- The Weeksville School"                                                                 
## [1045] "River Renal Services, Inc"                                                                     
## [1046] "Shining Star Home Health Care"                                                                 
## [1047] "Northern Manhattan Rehabilitation and Nursing Center"                                          
## [1048] "Citadel Renal Center LLC"                                                                      
## [1049] "CHN - Helen B Atkinson Center"                                                                 
## [1050] "Wards Island Family Health Center"                                                             
## [1051] "Lenox Health Greenwich Village"                                                                
## [1052] "Christopher Columbus High School Campus"                                                       
## [1053] "PS 196/MS 582"                                                                                 
## [1054] "Seward Park Educational Campus"                                                                
## [1055] "La Casa de Salud, Inc."                                                                        
## [1056] "University Center for Rehabilitation and Nursing"                                              
## [1057] "Downtown Bronx ASC"                                                                            
## [1058] "Flushing Endoscopy Center, LLC"                                                                
## [1059] "Mount Sinai Downtown Union Square"                                                             
## [1060] "Medwise Center"                                                                                
## [1061] "Corona District Health Center"                                                                 
## [1062] "Catherine M. Abate Health Center"                                                              
## [1063] "Primary Care Center"                                                                           
## [1064] "Gouverneur Diagnostic and Treatment Center"                                                    
## [1065] "Grace Dodge Campus"                                                                            
## [1066] "Brooklyn Comprehensive Care Center, Inc."                                                      
## [1067] "Oceanview Nursing & Rehabilitation Center, LLC"                                                
## [1068] "MS 390/PS 396"                                                                                 
## [1069] "Gouverneur Clinic"                                                                             
## [1070] "Scanvan (Mobile)"                                                                              
## [1071] "PS 309 George E. Webecan"                                                                      
## [1072] "Park Slope Family Health Center"                                                               
## [1073] "Rogosin Kidney Center-Queens Dialysis"                                                         
## [1074] "Pelham Physical Medicine Inc"                                                                  
## [1075] "Long Island City High School"                                                                  
## [1076] "STD Center"                                                                                    
## [1077] "Rogosin Institute - Nephrology Foundation of Brooklyn South"                                   
## [1078] "Caton Park Rehabilitation and Nursing Center, LLC"                                             
## [1079] "Empire State Ambulatory Surgery Center"                                                        
## [1080] "Long Island Jewish Medical Center"                                                             
## [1081] "Campus Magnet High School"                                                                     
## [1082] "Harlem Children's Zone Promise Academy 1"                                                      
## [1083] "Astoria Dialysis Center"                                                                       
## [1084] "Queens Health Center"                                                                          
## [1085] "Center for Comprehensive Health Practice Inc"                                                  
## [1086] "All County LLC Mobile Van"                                                                     
## [1087] "Mt Sinai Adolescent Health Center"                                                             
## [1088] "Bronx Dialysis Center"                                                                         
## [1089] "Mount Sinai Hospital"                                                                          
## [1090] "Broadway Family Health Center"                                                                 
## [1091] "La Casa De Salud, Inc. Casa Maria"                                                             
## [1092] "Health Center at Tremont"                                                                      
## [1093] "Medisys Howard Beach Women&Children Care"                                                      
## [1094] "Revival Home Health Care"                                                                      
## [1095] "Claremont Family Health Care Center"                                                           
## [1096] "PS 199"                                                                                        
## [1097] "Genesis Renal Care"                                                                            
## [1098] "Maimonides Adult and Pediatric Care 7th Avenue"                                                
## [1099] "14 Penn Dental Center"                                                                         
## [1100] "Four Seasons Nursing and Rehabilitation Certified Home Health Agency"                          
## [1101] "Park Nursing Home"                                                                             
## [1102] "LaProvidencia Family Health Center"                                                            
## [1103] "Beth Israel Med Center 3-C"                                                                    
## [1104] "Woodhull Medical & Mental Health Center"                                                       
## [1105] "Ozanam Hall of Queens Nursing Home Inc"                                                        
## [1106] "West Midtown Medical Group"                                                                    
## [1107] "St. Lawrence Community Health Center"                                                          
## [1108] "Memorial Sloan Kettering 60th Street Outpatient Center"                                        
## [1109] "Crown Heights Health Center"                                                                   
## [1110] "Buena Vida Continuing Care & Rehab Center"                                                     
## [1111] "Chapin Home for the Aging"                                                                     
## [1112] "Frank J. Macchiarola Educational Complex"                                                      
## [1113] "P. S. 307"                                                                                     
## [1114] "Hillside Certified Home Care Agency"                                                           
## [1115] "VillageCare Rehabilitation and Nursing Center"                                                 
## [1116] "CHCR Stapleton St. George Health Center"                                                       
## [1117] "Williamsburg Community Health Center"                                                          
## [1118] "Downtown Brooklyn Nursing & Rehabilitation Center"                                             
## [1119] "Park Gardens Rehabilitation and Nursing Center LTHHCP"                                         
## [1120] "PS 85"                                                                                         
## [1121] "PS 188"                                                                                        
## [1122] "NYU Langone Outpatient Surgery Center"                                                         
## [1123] "NYP/Queens Obstetrics Center"                                                                  
## [1124] "Max Meltzer Health & Service Center"                                                           
## [1125] "Saint Joseph's Medical Center Queens OTP"                                                      
## [1126] "Mount Sinai Hospital - Mount Sinai Hospital of Queens"                                         
## [1127] "Upper East Side Dialysis Center"                                                               
## [1128] "New York Preventive Health Center"                                                             
## [1129] "West Farms Family Practice Center"                                                             
## [1130] "Foot Clinics of NY"                                                                            
## [1131] "Richmond Kidney Center"                                                                        
## [1132] "Riverdale Nursing Home"                                                                        
## [1133] "Blavatnik Family - Chelsea Medical Center at Mount Sinai"                                      
## [1134] "Brooklyn Eye Surgery Center"                                                                   
## [1135] "NYU Langone Perlmutter Cancer Center - Bayridge"                                               
## [1136] "Forest Hills Care Center"                                                                      
## [1137] "CASES Family Health Center"                                                                    
## [1138] "Premier Healthcare-Nostrand Ave"                                                               
## [1139] "Lexington Hearing & Speech Center Inc"                                                         
## [1140] "Help Morris Clinic"                                                                            
## [1141] "Roberto Clemente Family Guidance Center"                                                       
## [1142] "University Hospital of Brooklyn"                                                               
## [1143] "Oxford Nursing Home"                                                                           
## [1144] "Fort Washington Houses"                                                                        
## [1145] "X 147"                                                                                         
## [1146] "New Gouverneur Hospital SNF"                                                                   
## [1147] "Greenwich House Methadone"                                                                     
## [1148] "CES 73"                                                                                        
## [1149] "Lincoln Medical & Mental Health Center"                                                        
## [1150] "Staten Island Artificial Kidney Center"                                                        
## [1151] "Park Terrace Care Center"                                                                      
## [1152] "Sea Crest Nursing and Rehabilitation Center"                                                   
## [1153] "P.S. 31"                                                                                       
## [1154] "New York-Presbyterian/Lower Manhattan Hospital"                                                
## [1155] "Bainbridge Nrsg&Rehab Center ADHCP"                                                            
## [1156] "Stevenson High School"                                                                         
## [1157] "Care For the Homeless, Inc"                                                                    
## [1158] "Stuyvesant Heights Dialysis"                                                                   
## [1159] "Is286/172"                                                                                     
## [1160] "Horizon Care Center"                                                                           
## [1161] "Montefiore Med Park Group Dental"                                                              
## [1162] "Prospect Park Dialysis Center"                                                                 
## [1163] "George Washington High School"                                                                 
## [1164] "Dr. Jacqueline Peek-Davis School/Ronald Edmonds Learning Center II"                            
## [1165] "Providence Rest, Inc."                                                                         
## [1166] "Harlem East Life Plan"                                                                         
## [1167] "Union Community Health Center, Site 6"                                                         
## [1168] "NYP/Queens Cardiac Health Center"                                                              
## [1169] "P.S. 90"                                                                                       
## [1170] "CHN - Community League Center"                                                                 
## [1171] "Maimonides Breast Center"                                                                      
## [1172] "The Grand Rehabilitation and Nursing at Queens"                                                
## [1173] "George Wingate Educational Campus"                                                             
## [1174] "Jamaica Hospital Nursing Home Co Inc"                                                          
## [1175] "Gramercy Park Digestive Disease Center"                                                        
## [1176] "Odyssey House East 6th St Clinic"                                                              
## [1177] "Mobile Dental Center"                                                                          
## [1178] "HASC Diagnostic & Treatment Center Inc"                                                        
## [1179] "Josie Robertson Surgery Center"                                                                
## [1180] "Clove Lakes Health Care and Rehabilitation Center, Inc"                                        
## [1181] "Throgs Neck Rehabilitation & Nursing Center"                                                   
## [1182] "CenterLight Healthcare D&TC - Allerton Avenue Site"                                            
## [1183] "Henry Street School"                                                                           
## [1184] "Silvercrest"                                                                                   
## [1185] "Maimonides Rehabilitation Services"                                                            
## [1186] "Montefiore Medical Center-Moses/Mobile Van #1,#2,#3,& #4"                                      
## [1187] "St Johns Episcopal Hospital So Shore"                                                          
## [1188] "PS7 - MS Stern"                                                                                
## [1189] "Community Health Academy of the Heights (Phoenix)"                                             
## [1190] "New York Center for Rehabilitation & Nursing"                                                  
## [1191] "Boys and Girls High School"                                                                    
## [1192] "Brooklyn Plaza Medical Center"                                                                 
## [1193] "Burke Rehabilitation Outpatient Clinic-Hutch Metro"                                            
## [1194] "Bishop O.G. Walker Jr Health Care Center"                                                      
## [1195] "The Bronx Center for Renal Dialysis"                                                           
## [1196] "Morris Park Rehabilitation and Nursing Center"                                                 
## [1197] "All-Med Rehabilitation Center Queens"                                                          
## [1198] "New York Renal Associates, Inc"                                                                
## [1199] "Washington Heights Health Center"                                                              
## [1200] "PS 172"                                                                                        
## [1201] "Narco Freedom Inc"                                                                             
## [1202] "Concourse Rehabilitation and Nursing Center, Inc"                                              
## [1203] "Forest View Adult Day Health Care Center"                                                      
## [1204] "Jamaica Hospital Sleep Center"                                                                 
## [1205] "Sunset Park Familly Health Center"                                                             
## [1206] "HSS Queens Outpatient Center"                                                                  
## [1207] "X 113"                                                                                         
## [1208] "Brooklyn United Methodist Church Home"                                                         
## [1209] "ArchCare Senior Life at San Vicente de Paul Catholic Healthcare Center"                        
## [1210] "Franklin Women's Shelter"                                                                      
## [1211] "Weill Cornell Imaging at NYP-55 St"                                                            
## [1212] "PS 94 Health Extension Clinic"                                                                 
## [1213] "Goodwill Integrated Health and Wellness Center (GIHWC)"
unique(health_sf$`Description`)
##  [1] "Hospital Extension Clinic"                                    
##  [2] "Diagnostic and Treatment Center"                              
##  [3] "Residential Health Care Facility - SNF"                       
##  [4] "Certified Home Health Agency"                                 
##  [5] "Diagnostic and Treatment Center Extension Clinic"             
##  [6] "School Based Hospital Extension Clinic"                       
##  [7] "Hospital"                                                     
##  [8] "School Based Diagnostic and Treatment Center Extension Clinic"
##  [9] "Long Term Home Health Care Program"                           
## [10] "Mobile Diagnostic and Treatment Center Extension Clinic"      
## [11] "Adult Day Health Care Program - Offsite"                      
## [12] "Mobile Hospital Extension Clinic"                             
## [13] "Hospice"
unique(health_sf$`Short Description`)
##  [1] "HOSP-EC" "DTC"     "NH"      "CHHA"    "DTC-EC"  "HOSP-SB" "HOSP"   
##  [8] NA        "LTHHCP"  "ADHCP"   "HSPC"
health_filtered <- health_sf %>%
  filter(`Short Description` == "NH" )

health_proj <- st_transform(health_filtered, st_crs(zip_retail))

zip_health <- st_join(zip_retail, health_proj, left = TRUE)

zip_health <- zip_health %>%
  group_by(ZIPCODE) %>%
  summarize(
    nursinghome_count = sum(!is.na(`Short Description`)),
    retail_count = first(retail_count),
    across(c(COVID_CASE_COUNT, COVID_CASE_RATE, POP_DENOMINATOR,
             COVID_DEATH_COUNT, COVID_DEATH_RATE,
             PERCENT_POSITIVE, TOTAL_COVID_TESTS,
             PO_NAME, COUNTY),
           first)
  )

zip_health <- zip_health %>%
  filter(ZIPCODE != "00083")

head(zip_health)
## Simple feature collection with 6 features and 12 fields
## Geometry type: GEOMETRY
## Dimension:     XY
## Bounding box:  xmin: 971132.6 ymin: 188447.3 xmax: 992172.8 ymax: 215324.9
## Projected CRS: NAD83 / New York Long Island (ftUS)
## # A tibble: 6 × 13
##   ZIPCODE nursinghome_count retail_count COVID_CASE_COUNT COVID_CASE_RATE
##   <chr>               <int>        <int>            <int>           <dbl>
## 1 10001                   0           16             1542           5584.
## 2 10002                   2           51             5902           7836.
## 3 10003                   0           27             2803           5193.
## 4 10004                   0            6              247           8311.
## 5 10005                   0            2              413           4716.
## 6 10006                   0            2              164           4849.
## # ℹ 8 more variables: POP_DENOMINATOR <dbl>, COVID_DEATH_COUNT <int>,
## #   COVID_DEATH_RATE <dbl>, PERCENT_POSITIVE <dbl>, TOTAL_COVID_TESTS <int>,
## #   PO_NAME <chr>, COUNTY <chr>, geometry <GEOMETRY [US_survey_foot]>
plot(zip_health["nursinghome_count"])

Task 4: Census ACS and NYC Planning Census Tract Join

nyc_tracts_sf <- st_read("2010 Census Tracts/geo_export_1dc7b645-647b-4806-b9a0-7b79660f120a.shp")
## Reading layer `geo_export_1dc7b645-647b-4806-b9a0-7b79660f120a' from data source `/Users/uwu/Documents/Rstudio/Week8/2010 Census Tracts/geo_export_1dc7b645-647b-4806-b9a0-7b79660f120a.shp' 
##   using driver `ESRI Shapefile'
## Simple feature collection with 2165 features and 11 fields
## Geometry type: MULTIPOLYGON
## Dimension:     XY
## Bounding box:  xmin: -74.25559 ymin: 40.49612 xmax: -73.70001 ymax: 40.91553
## Geodetic CRS:  WGS84(DD)
names(nyc_tracts_sf)
##  [1] "boro_code"  "boro_ct201" "boro_name"  "cdeligibil" "ct2010"    
##  [6] "ctlabel"    "ntacode"    "ntaname"    "puma"       "shape_area"
## [11] "shape_leng" "geometry"
acs_df <- read.csv("ACSDP5Y2018.DP05_data_with_overlays_2020-04-22T132935.csv")
names(acs_df)
##   [1] "GEO_ID"      "NAME"        "DP05_0031PM" "DP05_0032E"  "DP05_0032M" 
##   [6] "DP05_0032PE" "DP05_0032PM" "DP05_0033E"  "DP05_0033M"  "DP05_0033PE"
##  [11] "DP05_0033PM" "DP05_0034E"  "DP05_0034M"  "DP05_0034PE" "DP05_0034PM"
##  [16] "DP05_0035E"  "DP05_0035M"  "DP05_0035PE" "DP05_0035PM" "DP05_0036E" 
##  [21] "DP05_0036M"  "DP05_0036PE" "DP05_0036PM" "DP05_0037E"  "DP05_0037M" 
##  [26] "DP05_0037PE" "DP05_0037PM" "DP05_0038E"  "DP05_0038M"  "DP05_0038PE"
##  [31] "DP05_0038PM" "DP05_0039E"  "DP05_0039M"  "DP05_0039PE" "DP05_0039PM"
##  [36] "DP05_0040E"  "DP05_0040M"  "DP05_0040PE" "DP05_0040PM" "DP05_0041E" 
##  [41] "DP05_0041M"  "DP05_0041PE" "DP05_0041PM" "DP05_0042E"  "DP05_0042M" 
##  [46] "DP05_0042PE" "DP05_0042PM" "DP05_0043E"  "DP05_0043M"  "DP05_0043PE"
##  [51] "DP05_0043PM" "DP05_0044E"  "DP05_0044M"  "DP05_0044PE" "DP05_0044PM"
##  [56] "DP05_0045E"  "DP05_0045M"  "DP05_0045PE" "DP05_0045PM" "DP05_0046E" 
##  [61] "DP05_0046M"  "DP05_0046PE" "DP05_0046PM" "DP05_0047E"  "DP05_0047M" 
##  [66] "DP05_0047PE" "DP05_0047PM" "DP05_0048E"  "DP05_0048M"  "DP05_0048PE"
##  [71] "DP05_0048PM" "DP05_0049E"  "DP05_0049M"  "DP05_0049PE" "DP05_0049PM"
##  [76] "DP05_0050E"  "DP05_0050M"  "DP05_0050PE" "DP05_0050PM" "DP05_0051E" 
##  [81] "DP05_0051M"  "DP05_0051PE" "DP05_0051PM" "DP05_0052E"  "DP05_0052M" 
##  [86] "DP05_0052PE" "DP05_0052PM" "DP05_0053E"  "DP05_0053M"  "DP05_0053PE"
##  [91] "DP05_0053PM" "DP05_0054E"  "DP05_0054M"  "DP05_0054PE" "DP05_0054PM"
##  [96] "DP05_0055E"  "DP05_0055M"  "DP05_0055PE" "DP05_0055PM" "DP05_0056E" 
## [101] "DP05_0056M"  "DP05_0056PE" "DP05_0056PM" "DP05_0057E"  "DP05_0057M" 
## [106] "DP05_0057PE" "DP05_0057PM" "DP05_0058E"  "DP05_0058M"  "DP05_0058PE"
## [111] "DP05_0058PM" "DP05_0059E"  "DP05_0059M"  "DP05_0059PE" "DP05_0059PM"
## [116] "DP05_0060E"  "DP05_0060M"  "DP05_0060PE" "DP05_0060PM" "DP05_0061E" 
## [121] "DP05_0061M"  "DP05_0061PE" "DP05_0061PM" "DP05_0062E"  "DP05_0062M" 
## [126] "DP05_0062PE" "DP05_0062PM" "DP05_0063E"  "DP05_0063M"  "DP05_0063PE"
## [131] "DP05_0063PM" "DP05_0064E"  "DP05_0064M"  "DP05_0064PE" "DP05_0064PM"
## [136] "DP05_0065E"  "DP05_0065M"  "DP05_0065PE" "DP05_0065PM" "DP05_0066E" 
## [141] "DP05_0066M"  "DP05_0066PE" "DP05_0066PM" "DP05_0067E"  "DP05_0067M" 
## [146] "DP05_0067PE" "DP05_0067PM" "DP05_0068E"  "DP05_0068M"  "DP05_0068PE"
## [151] "DP05_0068PM" "DP05_0069E"  "DP05_0069M"  "DP05_0069PE" "DP05_0069PM"
## [156] "DP05_0070E"  "DP05_0070M"  "DP05_0070PE" "DP05_0070PM" "DP05_0071E" 
## [161] "DP05_0071M"  "DP05_0071PE" "DP05_0071PM" "DP05_0072E"  "DP05_0072M" 
## [166] "DP05_0072PE" "DP05_0072PM" "DP05_0073E"  "DP05_0073M"  "DP05_0073PE"
## [171] "DP05_0073PM" "DP05_0074E"  "DP05_0074M"  "DP05_0074PE" "DP05_0074PM"
## [176] "DP05_0075E"  "DP05_0075M"  "DP05_0075PE" "DP05_0075PM" "DP05_0076E" 
## [181] "DP05_0076M"  "DP05_0076PE" "DP05_0076PM" "DP05_0077E"  "DP05_0077M" 
## [186] "DP05_0077PE" "DP05_0077PM" "DP05_0078E"  "DP05_0078M"  "DP05_0078PE"
## [191] "DP05_0078PM" "DP05_0079E"  "DP05_0079M"  "DP05_0079PE" "DP05_0079PM"
## [196] "DP05_0080E"  "DP05_0080M"  "DP05_0080PE" "DP05_0080PM" "DP05_0081E" 
## [201] "DP05_0081M"  "DP05_0081PE" "DP05_0081PM" "DP05_0082E"  "DP05_0082M" 
## [206] "DP05_0082PE" "DP05_0082PM" "DP05_0083E"  "DP05_0083M"  "DP05_0083PE"
## [211] "DP05_0083PM" "DP05_0084E"  "DP05_0084M"  "DP05_0084PE" "DP05_0084PM"
## [216] "DP05_0085E"  "DP05_0085M"  "DP05_0085PE" "DP05_0085PM" "DP05_0086E" 
## [221] "DP05_0086M"  "DP05_0086PE" "DP05_0086PM" "DP05_0087E"  "DP05_0087M" 
## [226] "DP05_0087PE" "DP05_0087PM" "DP05_0088E"  "DP05_0088M"  "DP05_0088PE"
## [231] "DP05_0088PM" "DP05_0089E"  "DP05_0089M"  "DP05_0089PE" "DP05_0089PM"
## [236] "DP05_0001E"  "DP05_0001M"  "DP05_0001PE" "DP05_0001PM" "DP05_0002E" 
## [241] "DP05_0002M"  "DP05_0002PE" "DP05_0002PM" "DP05_0003E"  "DP05_0003M" 
## [246] "DP05_0003PE" "DP05_0003PM" "DP05_0004E"  "DP05_0004M"  "DP05_0004PE"
## [251] "DP05_0004PM" "DP05_0005E"  "DP05_0005M"  "DP05_0005PE" "DP05_0005PM"
## [256] "DP05_0006E"  "DP05_0006M"  "DP05_0006PE" "DP05_0006PM" "DP05_0007E" 
## [261] "DP05_0007M"  "DP05_0007PE" "DP05_0007PM" "DP05_0008E"  "DP05_0008M" 
## [266] "DP05_0008PE" "DP05_0008PM" "DP05_0009E"  "DP05_0009M"  "DP05_0009PE"
## [271] "DP05_0009PM" "DP05_0010E"  "DP05_0010M"  "DP05_0010PE" "DP05_0010PM"
## [276] "DP05_0011E"  "DP05_0011M"  "DP05_0011PE" "DP05_0011PM" "DP05_0012E" 
## [281] "DP05_0012M"  "DP05_0012PE" "DP05_0012PM" "DP05_0013E"  "DP05_0013M" 
## [286] "DP05_0013PE" "DP05_0013PM" "DP05_0014E"  "DP05_0014M"  "DP05_0014PE"
## [291] "DP05_0014PM" "DP05_0015E"  "DP05_0015M"  "DP05_0015PE" "DP05_0015PM"
## [296] "DP05_0016E"  "DP05_0016M"  "DP05_0016PE" "DP05_0016PM" "DP05_0017E" 
## [301] "DP05_0017M"  "DP05_0017PE" "DP05_0017PM" "DP05_0018E"  "DP05_0018M" 
## [306] "DP05_0018PE" "DP05_0018PM" "DP05_0019E"  "DP05_0019M"  "DP05_0019PE"
## [311] "DP05_0019PM" "DP05_0020E"  "DP05_0020M"  "DP05_0020PE" "DP05_0020PM"
## [316] "DP05_0021E"  "DP05_0021M"  "DP05_0021PE" "DP05_0021PM" "DP05_0022E" 
## [321] "DP05_0022M"  "DP05_0022PE" "DP05_0022PM" "DP05_0023E"  "DP05_0023M" 
## [326] "DP05_0023PE" "DP05_0023PM" "DP05_0024E"  "DP05_0024M"  "DP05_0024PE"
## [331] "DP05_0024PM" "DP05_0025E"  "DP05_0025M"  "DP05_0025PE" "DP05_0025PM"
## [336] "DP05_0026E"  "DP05_0026M"  "DP05_0026PE" "DP05_0026PM" "DP05_0027E" 
## [341] "DP05_0027M"  "DP05_0027PE" "DP05_0027PM" "DP05_0028E"  "DP05_0028M" 
## [346] "DP05_0028PE" "DP05_0028PM" "DP05_0029E"  "DP05_0029M"  "DP05_0029PE"
## [351] "DP05_0029PM" "DP05_0030E"  "DP05_0030M"  "DP05_0030PE" "DP05_0030PM"
## [356] "DP05_0031E"  "DP05_0031M"  "DP05_0031PE"
head(acs_df)
##                 GEO_ID                                    NAME
## 1                   id                    Geographic Area Name
## 2 1400000US36005000100  Census Tract 1, Bronx County, New York
## 3 1400000US36005000200  Census Tract 2, Bronx County, New York
## 4 1400000US36005000400  Census Tract 4, Bronx County, New York
## 5 1400000US36005001600 Census Tract 16, Bronx County, New York
## 6 1400000US36005001900 Census Tract 19, Bronx County, New York
##                                                                         DP05_0031PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!65 years and over!!Female
## 2                                                                              50.4
## 3                                                                               9.5
## 4                                                                               8.8
## 5                                                                               8.9
## 6                                                                              25.5
##                                                                                      DP05_0032E
## 1 Estimate!!SEX AND AGE!!Total population!!65 years and over!!Sex ratio (males per 100 females)
## 2                                                                                         200.0
## 3                                                                                          95.1
## 4                                                                                          91.4
## 5                                                                                          42.5
## 6                                                                                         245.5
##                                                                                             DP05_0032M
## 1 Margin of Error!!SEX AND AGE!!Total population!!65 years and over!!Sex ratio (males per 100 females)
## 2                                                                                               1316.0
## 3                                                                                                 37.2
## 4                                                                                                 32.7
## 5                                                                                                 18.4
## 6                                                                                                331.1
##                                                                                             DP05_0032PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!65 years and over!!Sex ratio (males per 100 females)
## 2                                                                                                   (X)
## 3                                                                                                   (X)
## 4                                                                                                   (X)
## 5                                                                                                   (X)
## 6                                                                                                   (X)
##                                                                                                    DP05_0032PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!65 years and over!!Sex ratio (males per 100 females)
## 2                                                                                                          (X)
## 3                                                                                                          (X)
## 4                                                                                                          (X)
## 5                                                                                                          (X)
## 6                                                                                                          (X)
##                         DP05_0033E                              DP05_0033M
## 1 Estimate!!RACE!!Total population Margin of Error!!RACE!!Total population
## 2                             7080                                     290
## 3                             4542                                     574
## 4                             5634                                     517
## 5                             5917                                     461
## 6                             2765                                     307
##                                DP05_0033PE
## 1 Percent Estimate!!RACE!!Total population
## 2                                     7080
## 3                                     4542
## 4                                     5634
## 5                                     5917
## 6                                     2765
##                                       DP05_0033PM
## 1 Percent Margin of Error!!RACE!!Total population
## 2                                             (X)
## 3                                             (X)
## 4                                             (X)
## 5                                             (X)
## 6                                             (X)
##                                   DP05_0034E
## 1 Estimate!!RACE!!Total population!!One race
## 2                                       7012
## 3                                       4349
## 4                                       5425
## 5                                       5760
## 6                                       2595
##                                          DP05_0034M
## 1 Margin of Error!!RACE!!Total population!!One race
## 2                                               289
## 3                                               557
## 4                                               532
## 5                                               454
## 6                                               297
##                                          DP05_0034PE
## 1 Percent Estimate!!RACE!!Total population!!One race
## 2                                               99.0
## 3                                               95.8
## 4                                               96.3
## 5                                               97.3
## 6                                               93.9
##                                                 DP05_0034PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race
## 2                                                       0.6
## 3                                                       3.4
## 4                                                       2.1
## 5                                                       1.9
## 6                                                       3.2
##                                            DP05_0035E
## 1 Estimate!!RACE!!Total population!!Two or more races
## 2                                                  68
## 3                                                 193
## 4                                                 209
## 5                                                 157
## 6                                                 170
##                                                   DP05_0035M
## 1 Margin of Error!!RACE!!Total population!!Two or more races
## 2                                                         42
## 3                                                        155
## 4                                                        117
## 5                                                        115
## 6                                                         93
##                                                   DP05_0035PE
## 1 Percent Estimate!!RACE!!Total population!!Two or more races
## 2                                                         1.0
## 3                                                         4.2
## 4                                                         3.7
## 5                                                         2.7
## 6                                                         6.1
##                                                          DP05_0035PM
## 1 Percent Margin of Error!!RACE!!Total population!!Two or more races
## 2                                                                0.6
## 3                                                                3.4
## 4                                                                2.1
## 5                                                                1.9
## 6                                                                3.2
##                                   DP05_0036E
## 1 Estimate!!RACE!!Total population!!One race
## 2                                       7012
## 3                                       4349
## 4                                       5425
## 5                                       5760
## 6                                       2595
##                                          DP05_0036M
## 1 Margin of Error!!RACE!!Total population!!One race
## 2                                               289
## 3                                               557
## 4                                               532
## 5                                               454
## 6                                               297
##                                          DP05_0036PE
## 1 Percent Estimate!!RACE!!Total population!!One race
## 2                                               99.0
## 3                                               95.8
## 4                                               96.3
## 5                                               97.3
## 6                                               93.9
##                                                 DP05_0036PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race
## 2                                                       0.6
## 3                                                       3.4
## 4                                                       2.1
## 5                                                       1.9
## 6                                                       3.2
##                                          DP05_0037E
## 1 Estimate!!RACE!!Total population!!One race!!White
## 2                                              1773
## 3                                              2165
## 4                                              2623
## 5                                              2406
## 6                                               585
##                                                 DP05_0037M
## 1 Margin of Error!!RACE!!Total population!!One race!!White
## 2                                                      248
## 3                                                      547
## 4                                                      427
## 5                                                      483
## 6                                                      171
##                                                 DP05_0037PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!White
## 2                                                      25.0
## 3                                                      47.7
## 4                                                      46.6
## 5                                                      40.7
## 6                                                      21.2
##                                                        DP05_0037PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!White
## 2                                                              3.2
## 3                                                             11.1
## 4                                                              7.8
## 5                                                              7.1
## 6                                                              5.8
##                                                              DP05_0038E
## 1 Estimate!!RACE!!Total population!!One race!!Black or African American
## 2                                                                  4239
## 3                                                                  1279
## 4                                                                  1699
## 5                                                                  2434
## 6                                                                  1041
##                                                                     DP05_0038M
## 1 Margin of Error!!RACE!!Total population!!One race!!Black or African American
## 2                                                                          286
## 3                                                                          472
## 4                                                                          432
## 5                                                                          451
## 6                                                                          175
##                                                                     DP05_0038PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Black or African American
## 2                                                                          59.9
## 3                                                                          28.2
## 4                                                                          30.2
## 5                                                                          41.1
## 6                                                                          37.6
##                                                                            DP05_0038PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Black or African American
## 2                                                                                  3.5
## 3                                                                                 10.0
## 4                                                                                  6.4
## 5                                                                                  7.1
## 6                                                                                  6.0
##                                                                      DP05_0039E
## 1 Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native
## 2                                                                            25
## 3                                                                             0
## 4                                                                            30
## 5                                                                             0
## 6                                                                             0
##                                                                             DP05_0039M
## 1 Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native
## 2                                                                                   24
## 3                                                                                   12
## 4                                                                                   33
## 5                                                                                   17
## 6                                                                                   12
##                                                                             DP05_0039PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native
## 2                                                                                   0.4
## 3                                                                                   0.0
## 4                                                                                   0.5
## 5                                                                                   0.0
## 6                                                                                   0.0
##                                                                                    DP05_0039PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native
## 2                                                                                          0.3
## 3                                                                                          0.7
## 4                                                                                          0.6
## 5                                                                                          0.5
## 6                                                                                          1.2
##                                                                                                DP05_0040E
## 1 Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Cherokee tribal grouping
## 2                                                                                                       0
## 3                                                                                                       0
## 4                                                                                                       0
## 5                                                                                                       0
## 6                                                                                                       0
##                                                                                                       DP05_0040M
## 1 Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Cherokee tribal grouping
## 2                                                                                                             17
## 3                                                                                                             12
## 4                                                                                                             17
## 5                                                                                                             17
## 6                                                                                                             12
##                                                                                                       DP05_0040PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Cherokee tribal grouping
## 2                                                                                                             0.0
## 3                                                                                                             0.0
## 4                                                                                                             0.0
## 5                                                                                                             0.0
## 6                                                                                                             0.0
##                                                                                                              DP05_0040PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Cherokee tribal grouping
## 2                                                                                                                    0.5
## 3                                                                                                                    0.7
## 4                                                                                                                    0.6
## 5                                                                                                                    0.5
## 6                                                                                                                    1.2
##                                                                                                DP05_0041E
## 1 Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Chippewa tribal grouping
## 2                                                                                                       0
## 3                                                                                                       0
## 4                                                                                                       0
## 5                                                                                                       0
## 6                                                                                                       0
##                                                                                                       DP05_0041M
## 1 Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Chippewa tribal grouping
## 2                                                                                                             17
## 3                                                                                                             12
## 4                                                                                                             17
## 5                                                                                                             17
## 6                                                                                                             12
##                                                                                                       DP05_0041PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Chippewa tribal grouping
## 2                                                                                                             0.0
## 3                                                                                                             0.0
## 4                                                                                                             0.0
## 5                                                                                                             0.0
## 6                                                                                                             0.0
##                                                                                                              DP05_0041PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Chippewa tribal grouping
## 2                                                                                                                    0.5
## 3                                                                                                                    0.7
## 4                                                                                                                    0.6
## 5                                                                                                                    0.5
## 6                                                                                                                    1.2
##                                                                                              DP05_0042E
## 1 Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Navajo tribal grouping
## 2                                                                                                     0
## 3                                                                                                     0
## 4                                                                                                     0
## 5                                                                                                     0
## 6                                                                                                     0
##                                                                                                     DP05_0042M
## 1 Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Navajo tribal grouping
## 2                                                                                                           17
## 3                                                                                                           12
## 4                                                                                                           17
## 5                                                                                                           17
## 6                                                                                                           12
##                                                                                                     DP05_0042PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Navajo tribal grouping
## 2                                                                                                           0.0
## 3                                                                                                           0.0
## 4                                                                                                           0.0
## 5                                                                                                           0.0
## 6                                                                                                           0.0
##                                                                                                            DP05_0042PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Navajo tribal grouping
## 2                                                                                                                  0.5
## 3                                                                                                                  0.7
## 4                                                                                                                  0.6
## 5                                                                                                                  0.5
## 6                                                                                                                  1.2
##                                                                                             DP05_0043E
## 1 Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Sioux tribal grouping
## 2                                                                                                    0
## 3                                                                                                    0
## 4                                                                                                    0
## 5                                                                                                    0
## 6                                                                                                    0
##                                                                                                    DP05_0043M
## 1 Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Sioux tribal grouping
## 2                                                                                                          17
## 3                                                                                                          12
## 4                                                                                                          17
## 5                                                                                                          17
## 6                                                                                                          12
##                                                                                                    DP05_0043PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Sioux tribal grouping
## 2                                                                                                          0.0
## 3                                                                                                          0.0
## 4                                                                                                          0.0
## 5                                                                                                          0.0
## 6                                                                                                          0.0
##                                                                                                           DP05_0043PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!American Indian and Alaska Native!!Sioux tribal grouping
## 2                                                                                                                 0.5
## 3                                                                                                                 0.7
## 4                                                                                                                 0.6
## 5                                                                                                                 0.5
## 6                                                                                                                 1.2
##                                          DP05_0044E
## 1 Estimate!!RACE!!Total population!!One race!!Asian
## 2                                               125
## 3                                               104
## 4                                               226
## 5                                                13
## 6                                                93
##                                                 DP05_0044M
## 1 Margin of Error!!RACE!!Total population!!One race!!Asian
## 2                                                       51
## 3                                                       87
## 4                                                      155
## 5                                                       19
## 6                                                       74
##                                                 DP05_0044PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Asian
## 2                                                       1.8
## 3                                                       2.3
## 4                                                       4.0
## 5                                                       0.2
## 6                                                       3.4
##                                                        DP05_0044PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Asian
## 2                                                              0.7
## 3                                                              2.0
## 4                                                              2.7
## 5                                                              0.3
## 6                                                              2.7
##                                                        DP05_0045E
## 1 Estimate!!RACE!!Total population!!One race!!Asian!!Asian Indian
## 2                                                              35
## 3                                                              40
## 4                                                              20
## 5                                                               0
## 6                                                              69
##                                                               DP05_0045M
## 1 Margin of Error!!RACE!!Total population!!One race!!Asian!!Asian Indian
## 2                                                                     31
## 3                                                                     64
## 4                                                                     31
## 5                                                                     17
## 6                                                                     70
##                                                               DP05_0045PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Asian!!Asian Indian
## 2                                                                     0.5
## 3                                                                     0.9
## 4                                                                     0.4
## 5                                                                     0.0
## 6                                                                     2.5
##                                                                      DP05_0045PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Asian!!Asian Indian
## 2                                                                            0.4
## 3                                                                            1.4
## 4                                                                            0.5
## 5                                                                            0.5
## 6                                                                            2.5
##                                                   DP05_0046E
## 1 Estimate!!RACE!!Total population!!One race!!Asian!!Chinese
## 2                                                         54
## 3                                                          0
## 4                                                        171
## 5                                                          0
## 6                                                          9
##                                                          DP05_0046M
## 1 Margin of Error!!RACE!!Total population!!One race!!Asian!!Chinese
## 2                                                                46
## 3                                                                12
## 4                                                               142
## 5                                                                17
## 6                                                                14
##                                                          DP05_0046PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Asian!!Chinese
## 2                                                                0.8
## 3                                                                0.0
## 4                                                                3.0
## 5                                                                0.0
## 6                                                                0.3
##                                                                 DP05_0046PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Asian!!Chinese
## 2                                                                       0.6
## 3                                                                       0.7
## 4                                                                       2.5
## 5                                                                       0.5
## 6                                                                       0.5
##                                                    DP05_0047E
## 1 Estimate!!RACE!!Total population!!One race!!Asian!!Filipino
## 2                                                           0
## 3                                                           0
## 4                                                          23
## 5                                                           0
## 6                                                           4
##                                                           DP05_0047M
## 1 Margin of Error!!RACE!!Total population!!One race!!Asian!!Filipino
## 2                                                                 17
## 3                                                                 12
## 4                                                                 36
## 5                                                                 17
## 6                                                                  6
##                                                           DP05_0047PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Asian!!Filipino
## 2                                                                 0.0
## 3                                                                 0.0
## 4                                                                 0.4
## 5                                                                 0.0
## 6                                                                 0.1
##                                                                  DP05_0047PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Asian!!Filipino
## 2                                                                        0.5
## 3                                                                        0.7
## 4                                                                        0.6
## 5                                                                        0.5
## 6                                                                        0.2
##                                                    DP05_0048E
## 1 Estimate!!RACE!!Total population!!One race!!Asian!!Japanese
## 2                                                           0
## 3                                                          40
## 4                                                           0
## 5                                                           0
## 6                                                           0
##                                                           DP05_0048M
## 1 Margin of Error!!RACE!!Total population!!One race!!Asian!!Japanese
## 2                                                                 17
## 3                                                                 55
## 4                                                                 17
## 5                                                                 17
## 6                                                                 12
##                                                           DP05_0048PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Asian!!Japanese
## 2                                                                 0.0
## 3                                                                 0.9
## 4                                                                 0.0
## 5                                                                 0.0
## 6                                                                 0.0
##                                                                  DP05_0048PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Asian!!Japanese
## 2                                                                        0.5
## 3                                                                        1.2
## 4                                                                        0.6
## 5                                                                        0.5
## 6                                                                        1.2
##                                                  DP05_0049E
## 1 Estimate!!RACE!!Total population!!One race!!Asian!!Korean
## 2                                                         4
## 3                                                         0
## 4                                                         0
## 5                                                         0
## 6                                                        11
##                                                         DP05_0049M
## 1 Margin of Error!!RACE!!Total population!!One race!!Asian!!Korean
## 2                                                                7
## 3                                                               12
## 4                                                               17
## 5                                                               17
## 6                                                               18
##                                                         DP05_0049PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Asian!!Korean
## 2                                                               0.1
## 3                                                               0.0
## 4                                                               0.0
## 5                                                               0.0
## 6                                                               0.4
##                                                                DP05_0049PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Asian!!Korean
## 2                                                                      0.1
## 3                                                                      0.7
## 4                                                                      0.6
## 5                                                                      0.5
## 6                                                                      0.7
##                                                      DP05_0050E
## 1 Estimate!!RACE!!Total population!!One race!!Asian!!Vietnamese
## 2                                                             0
## 3                                                             0
## 4                                                            12
## 5                                                             0
## 6                                                             0
##                                                             DP05_0050M
## 1 Margin of Error!!RACE!!Total population!!One race!!Asian!!Vietnamese
## 2                                                                   17
## 3                                                                   12
## 4                                                                   19
## 5                                                                   17
## 6                                                                   12
##                                                             DP05_0050PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Asian!!Vietnamese
## 2                                                                   0.0
## 3                                                                   0.0
## 4                                                                   0.2
## 5                                                                   0.0
## 6                                                                   0.0
##                                                                    DP05_0050PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Asian!!Vietnamese
## 2                                                                          0.5
## 3                                                                          0.7
## 4                                                                          0.3
## 5                                                                          0.5
## 6                                                                          1.2
##                                                       DP05_0051E
## 1 Estimate!!RACE!!Total population!!One race!!Asian!!Other Asian
## 2                                                             32
## 3                                                             24
## 4                                                              0
## 5                                                             13
## 6                                                              0
##                                                              DP05_0051M
## 1 Margin of Error!!RACE!!Total population!!One race!!Asian!!Other Asian
## 2                                                                    30
## 3                                                                    45
## 4                                                                    17
## 5                                                                    19
## 6                                                                    12
##                                                              DP05_0051PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Asian!!Other Asian
## 2                                                                    0.5
## 3                                                                    0.5
## 4                                                                    0.0
## 5                                                                    0.2
## 6                                                                    0.0
##                                                                     DP05_0051PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Asian!!Other Asian
## 2                                                                           0.4
## 3                                                                           1.0
## 4                                                                           0.6
## 5                                                                           0.3
## 6                                                                           1.2
##                                                                               DP05_0052E
## 1 Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander
## 2                                                                                      0
## 3                                                                                      0
## 4                                                                                      0
## 5                                                                                      0
## 6                                                                                      0
##                                                                                      DP05_0052M
## 1 Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander
## 2                                                                                            17
## 3                                                                                            12
## 4                                                                                            17
## 5                                                                                            17
## 6                                                                                            12
##                                                                                      DP05_0052PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander
## 2                                                                                            0.0
## 3                                                                                            0.0
## 4                                                                                            0.0
## 5                                                                                            0.0
## 6                                                                                            0.0
##                                                                                             DP05_0052PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander
## 2                                                                                                   0.5
## 3                                                                                                   0.7
## 4                                                                                                   0.6
## 5                                                                                                   0.5
## 6                                                                                                   1.2
##                                                                                                DP05_0053E
## 1 Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Native Hawaiian
## 2                                                                                                       0
## 3                                                                                                       0
## 4                                                                                                       0
## 5                                                                                                       0
## 6                                                                                                       0
##                                                                                                       DP05_0053M
## 1 Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Native Hawaiian
## 2                                                                                                             17
## 3                                                                                                             12
## 4                                                                                                             17
## 5                                                                                                             17
## 6                                                                                                             12
##                                                                                                       DP05_0053PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Native Hawaiian
## 2                                                                                                             0.0
## 3                                                                                                             0.0
## 4                                                                                                             0.0
## 5                                                                                                             0.0
## 6                                                                                                             0.0
##                                                                                                              DP05_0053PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Native Hawaiian
## 2                                                                                                                    0.5
## 3                                                                                                                    0.7
## 4                                                                                                                    0.6
## 5                                                                                                                    0.5
## 6                                                                                                                    1.2
##                                                                                                      DP05_0054E
## 1 Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Guamanian or Chamorro
## 2                                                                                                             0
## 3                                                                                                             0
## 4                                                                                                             0
## 5                                                                                                             0
## 6                                                                                                             0
##                                                                                                             DP05_0054M
## 1 Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Guamanian or Chamorro
## 2                                                                                                                   17
## 3                                                                                                                   12
## 4                                                                                                                   17
## 5                                                                                                                   17
## 6                                                                                                                   12
##                                                                                                             DP05_0054PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Guamanian or Chamorro
## 2                                                                                                                   0.0
## 3                                                                                                                   0.0
## 4                                                                                                                   0.0
## 5                                                                                                                   0.0
## 6                                                                                                                   0.0
##                                                                                                                    DP05_0054PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Guamanian or Chamorro
## 2                                                                                                                          0.5
## 3                                                                                                                          0.7
## 4                                                                                                                          0.6
## 5                                                                                                                          0.5
## 6                                                                                                                          1.2
##                                                                                       DP05_0055E
## 1 Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Samoan
## 2                                                                                              0
## 3                                                                                              0
## 4                                                                                              0
## 5                                                                                              0
## 6                                                                                              0
##                                                                                              DP05_0055M
## 1 Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Samoan
## 2                                                                                                    17
## 3                                                                                                    12
## 4                                                                                                    17
## 5                                                                                                    17
## 6                                                                                                    12
##                                                                                              DP05_0055PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Samoan
## 2                                                                                                    0.0
## 3                                                                                                    0.0
## 4                                                                                                    0.0
## 5                                                                                                    0.0
## 6                                                                                                    0.0
##                                                                                                     DP05_0055PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Samoan
## 2                                                                                                           0.5
## 3                                                                                                           0.7
## 4                                                                                                           0.6
## 5                                                                                                           0.5
## 6                                                                                                           1.2
##                                                                                                       DP05_0056E
## 1 Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Other Pacific Islander
## 2                                                                                                              0
## 3                                                                                                              0
## 4                                                                                                              0
## 5                                                                                                              0
## 6                                                                                                              0
##                                                                                                              DP05_0056M
## 1 Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Other Pacific Islander
## 2                                                                                                                    17
## 3                                                                                                                    12
## 4                                                                                                                    17
## 5                                                                                                                    17
## 6                                                                                                                    12
##                                                                                                              DP05_0056PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Other Pacific Islander
## 2                                                                                                                    0.0
## 3                                                                                                                    0.0
## 4                                                                                                                    0.0
## 5                                                                                                                    0.0
## 6                                                                                                                    0.0
##                                                                                                                     DP05_0056PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Native Hawaiian and Other Pacific Islander!!Other Pacific Islander
## 2                                                                                                                           0.5
## 3                                                                                                                           0.7
## 4                                                                                                                           0.6
## 5                                                                                                                           0.5
## 6                                                                                                                           1.2
##                                                    DP05_0057E
## 1 Estimate!!RACE!!Total population!!One race!!Some other race
## 2                                                         850
## 3                                                         801
## 4                                                         847
## 5                                                         907
## 6                                                         876
##                                                           DP05_0057M
## 1 Margin of Error!!RACE!!Total population!!One race!!Some other race
## 2                                                                172
## 3                                                                439
## 4                                                                350
## 5                                                                346
## 6                                                                238
##                                                           DP05_0057PE
## 1 Percent Estimate!!RACE!!Total population!!One race!!Some other race
## 2                                                                12.0
## 3                                                                17.6
## 4                                                                15.0
## 5                                                                15.3
## 6                                                                31.7
##                                                                  DP05_0057PM
## 1 Percent Margin of Error!!RACE!!Total population!!One race!!Some other race
## 2                                                                        2.4
## 3                                                                        8.9
## 4                                                                        5.8
## 5                                                                        5.9
## 6                                                                        6.9
##                                            DP05_0058E
## 1 Estimate!!RACE!!Total population!!Two or more races
## 2                                                  68
## 3                                                 193
## 4                                                 209
## 5                                                 157
## 6                                                 170
##                                                   DP05_0058M
## 1 Margin of Error!!RACE!!Total population!!Two or more races
## 2                                                         42
## 3                                                        155
## 4                                                        117
## 5                                                        115
## 6                                                         93
##                                                   DP05_0058PE
## 1 Percent Estimate!!RACE!!Total population!!Two or more races
## 2                                                         1.0
## 3                                                         4.2
## 4                                                         3.7
## 5                                                         2.7
## 6                                                         6.1
##                                                          DP05_0058PM
## 1 Percent Margin of Error!!RACE!!Total population!!Two or more races
## 2                                                                0.6
## 3                                                                3.4
## 4                                                                2.1
## 5                                                                1.9
## 6                                                                3.2
##                                                                                 DP05_0059E
## 1 Estimate!!RACE!!Total population!!Two or more races!!White and Black or African American
## 2                                                                                       55
## 3                                                                                       54
## 4                                                                                       55
## 5                                                                                        0
## 6                                                                                       52
##                                                                                        DP05_0059M
## 1 Margin of Error!!RACE!!Total population!!Two or more races!!White and Black or African American
## 2                                                                                              38
## 3                                                                                              83
## 4                                                                                              60
## 5                                                                                              17
## 6                                                                                              57
##                                                                                        DP05_0059PE
## 1 Percent Estimate!!RACE!!Total population!!Two or more races!!White and Black or African American
## 2                                                                                              0.8
## 3                                                                                              1.2
## 4                                                                                              1.0
## 5                                                                                              0.0
## 6                                                                                              1.9
##                                                                                               DP05_0059PM
## 1 Percent Margin of Error!!RACE!!Total population!!Two or more races!!White and Black or African American
## 2                                                                                                     0.5
## 3                                                                                                     1.8
## 4                                                                                                     1.1
## 5                                                                                                     0.5
## 6                                                                                                     2.1
##                                                                                         DP05_0060E
## 1 Estimate!!RACE!!Total population!!Two or more races!!White and American Indian and Alaska Native
## 2                                                                                                8
## 3                                                                                               53
## 4                                                                                               33
## 5                                                                                                0
## 6                                                                                                0
##                                                                                                DP05_0060M
## 1 Margin of Error!!RACE!!Total population!!Two or more races!!White and American Indian and Alaska Native
## 2                                                                                                      13
## 3                                                                                                      88
## 4                                                                                                      52
## 5                                                                                                      17
## 6                                                                                                      12
##                                                                                                DP05_0060PE
## 1 Percent Estimate!!RACE!!Total population!!Two or more races!!White and American Indian and Alaska Native
## 2                                                                                                      0.1
## 3                                                                                                      1.2
## 4                                                                                                      0.6
## 5                                                                                                      0.0
## 6                                                                                                      0.0
##                                                                                                       DP05_0060PM
## 1 Percent Margin of Error!!RACE!!Total population!!Two or more races!!White and American Indian and Alaska Native
## 2                                                                                                             0.2
## 3                                                                                                             1.9
## 4                                                                                                             0.9
## 5                                                                                                             0.5
## 6                                                                                                             1.2
##                                                             DP05_0061E
## 1 Estimate!!RACE!!Total population!!Two or more races!!White and Asian
## 2                                                                    5
## 3                                                                   15
## 4                                                                    0
## 5                                                                   31
## 6                                                                    0
##                                                                    DP05_0061M
## 1 Margin of Error!!RACE!!Total population!!Two or more races!!White and Asian
## 2                                                                          10
## 3                                                                          25
## 4                                                                          17
## 5                                                                          44
## 6                                                                          12
##                                                                    DP05_0061PE
## 1 Percent Estimate!!RACE!!Total population!!Two or more races!!White and Asian
## 2                                                                          0.1
## 3                                                                          0.3
## 4                                                                          0.0
## 5                                                                          0.5
## 6                                                                          0.0
##                                                                           DP05_0061PM
## 1 Percent Margin of Error!!RACE!!Total population!!Two or more races!!White and Asian
## 2                                                                                 0.1
## 3                                                                                 0.6
## 4                                                                                 0.6
## 5                                                                                 0.7
## 6                                                                                 1.2
##                                                                                                             DP05_0062E
## 1 Estimate!!RACE!!Total population!!Two or more races!!Black or African American and American Indian and Alaska Native
## 2                                                                                                                    0
## 3                                                                                                                    0
## 4                                                                                                                    0
## 5                                                                                                                    0
## 6                                                                                                                   12
##                                                                                                                    DP05_0062M
## 1 Margin of Error!!RACE!!Total population!!Two or more races!!Black or African American and American Indian and Alaska Native
## 2                                                                                                                          17
## 3                                                                                                                          12
## 4                                                                                                                          17
## 5                                                                                                                          17
## 6                                                                                                                          18
##                                                                                                                    DP05_0062PE
## 1 Percent Estimate!!RACE!!Total population!!Two or more races!!Black or African American and American Indian and Alaska Native
## 2                                                                                                                          0.0
## 3                                                                                                                          0.0
## 4                                                                                                                          0.0
## 5                                                                                                                          0.0
## 6                                                                                                                          0.4
##                                                                                                                           DP05_0062PM
## 1 Percent Margin of Error!!RACE!!Total population!!Two or more races!!Black or African American and American Indian and Alaska Native
## 2                                                                                                                                 0.5
## 3                                                                                                                                 0.7
## 4                                                                                                                                 0.6
## 5                                                                                                                                 0.5
## 6                                                                                                                                 0.7
##                                                                              DP05_0063E
## 1 Estimate!!Race alone or in combination with one or more other races!!Total population
## 2                                                                                  7080
## 3                                                                                  4542
## 4                                                                                  5634
## 5                                                                                  5917
## 6                                                                                  2765
##                                                                                     DP05_0063M
## 1 Margin of Error!!Race alone or in combination with one or more other races!!Total population
## 2                                                                                          290
## 3                                                                                          574
## 4                                                                                          517
## 5                                                                                          461
## 6                                                                                          307
##                                                                                     DP05_0063PE
## 1 Percent Estimate!!Race alone or in combination with one or more other races!!Total population
## 2                                                                                          7080
## 3                                                                                          4542
## 4                                                                                          5634
## 5                                                                                          5917
## 6                                                                                          2765
##                                                                                            DP05_0063PM
## 1 Percent Margin of Error!!Race alone or in combination with one or more other races!!Total population
## 2                                                                                                  (X)
## 3                                                                                                  (X)
## 4                                                                                                  (X)
## 5                                                                                                  (X)
## 6                                                                                                  (X)
##                                                                                     DP05_0064E
## 1 Estimate!!Race alone or in combination with one or more other races!!Total population!!White
## 2                                                                                         1841
## 3                                                                                         2299
## 4                                                                                         2814
## 5                                                                                         2484
## 6                                                                                          677
##                                                                                            DP05_0064M
## 1 Margin of Error!!Race alone or in combination with one or more other races!!Total population!!White
## 2                                                                                                 259
## 3                                                                                                 580
## 4                                                                                                 422
## 5                                                                                                 495
## 6                                                                                                 198
##                                                                                            DP05_0064PE
## 1 Percent Estimate!!Race alone or in combination with one or more other races!!Total population!!White
## 2                                                                                                 26.0
## 3                                                                                                 50.6
## 4                                                                                                 49.9
## 5                                                                                                 42.0
## 6                                                                                                 24.5
##                                                                                                   DP05_0064PM
## 1 Percent Margin of Error!!Race alone or in combination with one or more other races!!Total population!!White
## 2                                                                                                         3.3
## 3                                                                                                        11.6
## 4                                                                                                         7.8
## 5                                                                                                         7.2
## 6                                                                                                         6.8
##                                                                                                         DP05_0065E
## 1 Estimate!!Race alone or in combination with one or more other races!!Total population!!Black or African American
## 2                                                                                                             4294
## 3                                                                                                             1392
## 4                                                                                                             1875
## 5                                                                                                             2492
## 6                                                                                                             1134
##                                                                                                                DP05_0065M
## 1 Margin of Error!!Race alone or in combination with one or more other races!!Total population!!Black or African American
## 2                                                                                                                     285
## 3                                                                                                                     494
## 4                                                                                                                     446
## 5                                                                                                                     438
## 6                                                                                                                     176
##                                                                                                                DP05_0065PE
## 1 Percent Estimate!!Race alone or in combination with one or more other races!!Total population!!Black or African American
## 2                                                                                                                     60.6
## 3                                                                                                                     30.6
## 4                                                                                                                     33.3
## 5                                                                                                                     42.1
## 6                                                                                                                     41.0
##                                                                                                                       DP05_0065PM
## 1 Percent Margin of Error!!Race alone or in combination with one or more other races!!Total population!!Black or African American
## 2                                                                                                                             3.4
## 3                                                                                                                            10.3
## 4                                                                                                                             6.6
## 5                                                                                                                             6.8
## 6                                                                                                                             6.0
##                                                                                                                 DP05_0066E
## 1 Estimate!!Race alone or in combination with one or more other races!!Total population!!American Indian and Alaska Native
## 2                                                                                                                       33
## 3                                                                                                                       53
## 4                                                                                                                      154
## 5                                                                                                                       10
## 6                                                                                                                       18
##                                                                                                                        DP05_0066M
## 1 Margin of Error!!Race alone or in combination with one or more other races!!Total population!!American Indian and Alaska Native
## 2                                                                                                                              27
## 3                                                                                                                              88
## 4                                                                                                                             130
## 5                                                                                                                              15
## 6                                                                                                                              20
##                                                                                                                        DP05_0066PE
## 1 Percent Estimate!!Race alone or in combination with one or more other races!!Total population!!American Indian and Alaska Native
## 2                                                                                                                              0.5
## 3                                                                                                                              1.2
## 4                                                                                                                              2.7
## 5                                                                                                                              0.2
## 6                                                                                                                              0.7
##                                                                                                                               DP05_0066PM
## 1 Percent Margin of Error!!Race alone or in combination with one or more other races!!Total population!!American Indian and Alaska Native
## 2                                                                                                                                     0.4
## 3                                                                                                                                     1.9
## 4                                                                                                                                     2.4
## 5                                                                                                                                     0.3
## 6                                                                                                                                     0.7
##                                                                                     DP05_0067E
## 1 Estimate!!Race alone or in combination with one or more other races!!Total population!!Asian
## 2                                                                                          130
## 3                                                                                          119
## 4                                                                                          226
## 5                                                                                           68
## 6                                                                                          130
##                                                                                            DP05_0067M
## 1 Margin of Error!!Race alone or in combination with one or more other races!!Total population!!Asian
## 2                                                                                                  50
## 3                                                                                                  88
## 4                                                                                                 155
## 5                                                                                                  76
## 6                                                                                                  99
##                                                                                            DP05_0067PE
## 1 Percent Estimate!!Race alone or in combination with one or more other races!!Total population!!Asian
## 2                                                                                                  1.8
## 3                                                                                                  2.6
## 4                                                                                                  4.0
## 5                                                                                                  1.1
## 6                                                                                                  4.7
##                                                                                                   DP05_0067PM
## 1 Percent Margin of Error!!Race alone or in combination with one or more other races!!Total population!!Asian
## 2                                                                                                         0.7
## 3                                                                                                         2.0
## 4                                                                                                         2.7
## 5                                                                                                         1.3
## 6                                                                                                         3.5
##                                                                                                                          DP05_0068E
## 1 Estimate!!Race alone or in combination with one or more other races!!Total population!!Native Hawaiian and Other Pacific Islander
## 2                                                                                                                                 0
## 3                                                                                                                                12
## 4                                                                                                                                 0
## 5                                                                                                                                 0
## 6                                                                                                                                 0
##                                                                                                                                 DP05_0068M
## 1 Margin of Error!!Race alone or in combination with one or more other races!!Total population!!Native Hawaiian and Other Pacific Islander
## 2                                                                                                                                       17
## 3                                                                                                                                       20
## 4                                                                                                                                       17
## 5                                                                                                                                       17
## 6                                                                                                                                       12
##                                                                                                                                 DP05_0068PE
## 1 Percent Estimate!!Race alone or in combination with one or more other races!!Total population!!Native Hawaiian and Other Pacific Islander
## 2                                                                                                                                       0.0
## 3                                                                                                                                       0.3
## 4                                                                                                                                       0.0
## 5                                                                                                                                       0.0
## 6                                                                                                                                       0.0
##                                                                                                                                        DP05_0068PM
## 1 Percent Margin of Error!!Race alone or in combination with one or more other races!!Total population!!Native Hawaiian and Other Pacific Islander
## 2                                                                                                                                              0.5
## 3                                                                                                                                              0.5
## 4                                                                                                                                              0.6
## 5                                                                                                                                              0.5
## 6                                                                                                                                              1.2
##                                                                                               DP05_0069E
## 1 Estimate!!Race alone or in combination with one or more other races!!Total population!!Some other race
## 2                                                                                                    850
## 3                                                                                                    872
## 4                                                                                                    945
## 5                                                                                                   1020
## 6                                                                                                    982
##                                                                                                      DP05_0069M
## 1 Margin of Error!!Race alone or in combination with one or more other races!!Total population!!Some other race
## 2                                                                                                           172
## 3                                                                                                           443
## 4                                                                                                           351
## 5                                                                                                           353
## 6                                                                                                           251
##                                                                                                      DP05_0069PE
## 1 Percent Estimate!!Race alone or in combination with one or more other races!!Total population!!Some other race
## 2                                                                                                           12.0
## 3                                                                                                           19.2
## 4                                                                                                           16.8
## 5                                                                                                           17.2
## 6                                                                                                           35.5
##                                                                                                             DP05_0069PM
## 1 Percent Margin of Error!!Race alone or in combination with one or more other races!!Total population!!Some other race
## 2                                                                                                                   2.4
## 3                                                                                                                   8.9
## 4                                                                                                                   5.9
## 5                                                                                                                   6.0
## 6                                                                                                                   6.9
##                                                DP05_0070E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population
## 2                                                    7080
## 3                                                    4542
## 4                                                    5634
## 5                                                    5917
## 6                                                    2765
##                                                       DP05_0070M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population
## 2                                                            290
## 3                                                            574
## 4                                                            517
## 5                                                            461
## 6                                                            307
##                                                       DP05_0070PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population
## 2                                                            7080
## 3                                                            4542
## 4                                                            5634
## 5                                                            5917
## 6                                                            2765
##                                                              DP05_0070PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population
## 2                                                                    (X)
## 3                                                                    (X)
## 4                                                                    (X)
## 5                                                                    (X)
## 6                                                                    (X)
##                                                                                  DP05_0071E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)
## 2                                                                                      2329
## 3                                                                                      3367
## 4                                                                                      3873
## 5                                                                                      3603
## 6                                                                                      1413
##                                                                                         DP05_0071M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)
## 2                                                                                              248
## 3                                                                                              597
## 4                                                                                              422
## 5                                                                                              437
## 6                                                                                              257
##                                                                                         DP05_0071PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)
## 2                                                                                              32.9
## 3                                                                                              74.1
## 4                                                                                              68.7
## 5                                                                                              60.9
## 6                                                                                              51.1
##                                                                                                DP05_0071PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)
## 2                                                                                                      3.2
## 3                                                                                                      7.9
## 4                                                                                                      6.5
## 5                                                                                                      5.7
## 6                                                                                                      6.0
##                                                                                           DP05_0072E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Mexican
## 2                                                                                                207
## 3                                                                                                264
## 4                                                                                                  9
## 5                                                                                                 36
## 6                                                                                                 72
##                                                                                                  DP05_0072M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Mexican
## 2                                                                                                        78
## 3                                                                                                       266
## 4                                                                                                        17
## 5                                                                                                        55
## 6                                                                                                        47
##                                                                                                  DP05_0072PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Mexican
## 2                                                                                                        2.9
## 3                                                                                                        5.8
## 4                                                                                                        0.2
## 5                                                                                                        0.6
## 6                                                                                                        2.6
##                                                                                                         DP05_0072PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Mexican
## 2                                                                                                               1.1
## 3                                                                                                               5.7
## 4                                                                                                               0.3
## 5                                                                                                               0.9
## 6                                                                                                               1.7
##                                                                                                DP05_0073E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Puerto Rican
## 2                                                                                                     826
## 3                                                                                                    1716
## 4                                                                                                    2365
## 5                                                                                                    1888
## 6                                                                                                     518
##                                                                                                       DP05_0073M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Puerto Rican
## 2                                                                                                            146
## 3                                                                                                            484
## 4                                                                                                            388
## 5                                                                                                            384
## 6                                                                                                            206
##                                                                                                       DP05_0073PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Puerto Rican
## 2                                                                                                            11.7
## 3                                                                                                            37.8
## 4                                                                                                            42.0
## 5                                                                                                            31.9
## 6                                                                                                            18.7
##                                                                                                              DP05_0073PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Puerto Rican
## 2                                                                                                                    2.0
## 3                                                                                                                    8.9
## 4                                                                                                                    7.0
## 5                                                                                                                    6.2
## 6                                                                                                                    6.6
##                                                                                         DP05_0074E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Cuban
## 2                                                                                               53
## 3                                                                                               31
## 4                                                                                              124
## 5                                                                                                4
## 6                                                                                                6
##                                                                                                DP05_0074M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Cuban
## 2                                                                                                      36
## 3                                                                                                      38
## 4                                                                                                     128
## 5                                                                                                      10
## 6                                                                                                       9
##                                                                                                DP05_0074PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Cuban
## 2                                                                                                      0.7
## 3                                                                                                      0.7
## 4                                                                                                      2.2
## 5                                                                                                      0.1
## 6                                                                                                      0.2
##                                                                                                       DP05_0074PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Cuban
## 2                                                                                                             0.5
## 3                                                                                                             0.8
## 4                                                                                                             2.2
## 5                                                                                                             0.2
## 6                                                                                                             0.3
##                                                                                                            DP05_0075E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Other Hispanic or Latino
## 2                                                                                                                1243
## 3                                                                                                                1356
## 4                                                                                                                1375
## 5                                                                                                                1675
## 6                                                                                                                 817
##                                                                                                                   DP05_0075M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Other Hispanic or Latino
## 2                                                                                                                        220
## 3                                                                                                                        430
## 4                                                                                                                        431
## 5                                                                                                                        400
## 6                                                                                                                        203
##                                                                                                                   DP05_0075PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Other Hispanic or Latino
## 2                                                                                                                        17.6
## 3                                                                                                                        29.9
## 4                                                                                                                        24.4
## 5                                                                                                                        28.3
## 6                                                                                                                        29.5
##                                                                                                                          DP05_0075PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Hispanic or Latino (of any race)!!Other Hispanic or Latino
## 2                                                                                                                                3.0
## 3                                                                                                                                9.0
## 4                                                                                                                                7.4
## 5                                                                                                                                6.3
## 6                                                                                                                                6.5
##                                                                        DP05_0076E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino
## 2                                                                            4751
## 3                                                                            1175
## 4                                                                            1761
## 5                                                                            2314
## 6                                                                            1352
##                                                                               DP05_0076M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino
## 2                                                                                    293
## 3                                                                                    363
## 4                                                                                    449
## 5                                                                                    388
## 6                                                                                    194
##                                                                               DP05_0076PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino
## 2                                                                                    67.1
## 3                                                                                    25.9
## 4                                                                                    31.3
## 5                                                                                    39.1
## 6                                                                                    48.9
##                                                                                      DP05_0076PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino
## 2                                                                                            3.2
## 3                                                                                            7.9
## 4                                                                                            6.5
## 5                                                                                            5.7
## 6                                                                                            6.0
##                                                                                     DP05_0077E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!White alone
## 2                                                                                          538
## 3                                                                                           77
## 4                                                                                          209
## 5                                                                                          220
## 6                                                                                          262
##                                                                                            DP05_0077M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!White alone
## 2                                                                                                 160
## 3                                                                                                  72
## 4                                                                                                  88
## 5                                                                                                 120
## 6                                                                                                  91
##                                                                                            DP05_0077PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!White alone
## 2                                                                                                  7.6
## 3                                                                                                  1.7
## 4                                                                                                  3.7
## 5                                                                                                  3.7
## 6                                                                                                  9.5
##                                                                                                   DP05_0077PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!White alone
## 2                                                                                                         2.2
## 3                                                                                                         1.6
## 4                                                                                                         1.7
## 5                                                                                                         2.0
## 6                                                                                                         3.1
##                                                                                                         DP05_0078E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Black or African American alone
## 2                                                                                                             3984
## 3                                                                                                              908
## 4                                                                                                             1380
## 5                                                                                                             1992
## 6                                                                                                              934
##                                                                                                                DP05_0078M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Black or African American alone
## 2                                                                                                                     270
## 3                                                                                                                     356
## 4                                                                                                                     432
## 5                                                                                                                     417
## 6                                                                                                                     171
##                                                                                                                DP05_0078PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Black or African American alone
## 2                                                                                                                     56.3
## 3                                                                                                                     20.0
## 4                                                                                                                     24.5
## 5                                                                                                                     33.7
## 6                                                                                                                     33.8
##                                                                                                                       DP05_0078PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Black or African American alone
## 2                                                                                                                             3.4
## 3                                                                                                                             7.7
## 4                                                                                                                             6.6
## 5                                                                                                                             6.5
## 6                                                                                                                             5.9
##                                                                                                                 DP05_0079E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!American Indian and Alaska Native alone
## 2                                                                                                                       25
## 3                                                                                                                        0
## 4                                                                                                                        0
## 5                                                                                                                        0
## 6                                                                                                                        0
##                                                                                                                        DP05_0079M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!American Indian and Alaska Native alone
## 2                                                                                                                              24
## 3                                                                                                                              12
## 4                                                                                                                              17
## 5                                                                                                                              17
## 6                                                                                                                              12
##                                                                                                                        DP05_0079PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!American Indian and Alaska Native alone
## 2                                                                                                                              0.4
## 3                                                                                                                              0.0
## 4                                                                                                                              0.0
## 5                                                                                                                              0.0
## 6                                                                                                                              0.0
##                                                                                                                               DP05_0079PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!American Indian and Alaska Native alone
## 2                                                                                                                                     0.3
## 3                                                                                                                                     0.7
## 4                                                                                                                                     0.6
## 5                                                                                                                                     0.5
## 6                                                                                                                                     1.2
##                                                                                     DP05_0080E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Asian alone
## 2                                                                                          125
## 3                                                                                          104
## 4                                                                                          130
## 5                                                                                            0
## 6                                                                                           82
##                                                                                            DP05_0080M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Asian alone
## 2                                                                                                  51
## 3                                                                                                  87
## 4                                                                                                  92
## 5                                                                                                  17
## 6                                                                                                  70
##                                                                                            DP05_0080PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Asian alone
## 2                                                                                                  1.8
## 3                                                                                                  2.3
## 4                                                                                                  2.3
## 5                                                                                                  0.0
## 6                                                                                                  3.0
##                                                                                                   DP05_0080PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Asian alone
## 2                                                                                                         0.7
## 3                                                                                                         2.0
## 4                                                                                                         1.6
## 5                                                                                                         0.5
## 6                                                                                                         2.5
##                                                                                                                          DP05_0081E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Native Hawaiian and Other Pacific Islander alone
## 2                                                                                                                                 0
## 3                                                                                                                                 0
## 4                                                                                                                                 0
## 5                                                                                                                                 0
## 6                                                                                                                                 0
##                                                                                                                                 DP05_0081M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Native Hawaiian and Other Pacific Islander alone
## 2                                                                                                                                       17
## 3                                                                                                                                       12
## 4                                                                                                                                       17
## 5                                                                                                                                       17
## 6                                                                                                                                       12
##                                                                                                                                 DP05_0081PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Native Hawaiian and Other Pacific Islander alone
## 2                                                                                                                                       0.0
## 3                                                                                                                                       0.0
## 4                                                                                                                                       0.0
## 5                                                                                                                                       0.0
## 6                                                                                                                                       0.0
##                                                                                                                                        DP05_0081PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Native Hawaiian and Other Pacific Islander alone
## 2                                                                                                                                              0.5
## 3                                                                                                                                              0.7
## 4                                                                                                                                              0.6
## 5                                                                                                                                              0.5
## 6                                                                                                                                              1.2
##                                                                                               DP05_0082E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Some other race alone
## 2                                                                                                     38
## 3                                                                                                     86
## 4                                                                                                      0
## 5                                                                                                    102
## 6                                                                                                     19
##                                                                                                      DP05_0082M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Some other race alone
## 2                                                                                                            34
## 3                                                                                                           134
## 4                                                                                                            17
## 5                                                                                                           111
## 6                                                                                                            20
##                                                                                                      DP05_0082PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Some other race alone
## 2                                                                                                            0.5
## 3                                                                                                            1.9
## 4                                                                                                            0.0
## 5                                                                                                            1.7
## 6                                                                                                            0.7
##                                                                                                             DP05_0082PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Some other race alone
## 2                                                                                                                   0.5
## 3                                                                                                                   2.9
## 4                                                                                                                   0.6
## 5                                                                                                                   1.9
## 6                                                                                                                   0.7
##                                                                                           DP05_0083E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races
## 2                                                                                                 41
## 3                                                                                                  0
## 4                                                                                                 42
## 5                                                                                                  0
## 6                                                                                                 55
##                                                                                                  DP05_0083M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races
## 2                                                                                                        33
## 3                                                                                                        12
## 4                                                                                                        51
## 5                                                                                                        17
## 6                                                                                                        56
##                                                                                                  DP05_0083PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races
## 2                                                                                                        0.6
## 3                                                                                                        0.0
## 4                                                                                                        0.7
## 5                                                                                                        0.0
## 6                                                                                                        2.0
##                                                                                                         DP05_0083PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races
## 2                                                                                                               0.5
## 3                                                                                                               0.7
## 4                                                                                                               0.9
## 5                                                                                                               0.5
## 6                                                                                                               2.0
##                                                                                                                                DP05_0084E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races!!Two races including Some other race
## 2                                                                                                                                       0
## 3                                                                                                                                       0
## 4                                                                                                                                       0
## 5                                                                                                                                       0
## 6                                                                                                                                       3
##                                                                                                                                       DP05_0084M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races!!Two races including Some other race
## 2                                                                                                                                             17
## 3                                                                                                                                             12
## 4                                                                                                                                             17
## 5                                                                                                                                             17
## 6                                                                                                                                              5
##                                                                                                                                       DP05_0084PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races!!Two races including Some other race
## 2                                                                                                                                             0.0
## 3                                                                                                                                             0.0
## 4                                                                                                                                             0.0
## 5                                                                                                                                             0.0
## 6                                                                                                                                             0.1
##                                                                                                                                              DP05_0084PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races!!Two races including Some other race
## 2                                                                                                                                                    0.5
## 3                                                                                                                                                    0.7
## 4                                                                                                                                                    0.6
## 5                                                                                                                                                    0.5
## 6                                                                                                                                                    0.2
##                                                                                                                                                         DP05_0085E
## 1 Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races!!Two races excluding Some other race, and Three or more races
## 2                                                                                                                                                               41
## 3                                                                                                                                                                0
## 4                                                                                                                                                               42
## 5                                                                                                                                                                0
## 6                                                                                                                                                               52
##                                                                                                                                                                DP05_0085M
## 1 Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races!!Two races excluding Some other race, and Three or more races
## 2                                                                                                                                                                      33
## 3                                                                                                                                                                      12
## 4                                                                                                                                                                      51
## 5                                                                                                                                                                      17
## 6                                                                                                                                                                      57
##                                                                                                                                                                DP05_0085PE
## 1 Percent Estimate!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races!!Two races excluding Some other race, and Three or more races
## 2                                                                                                                                                                      0.6
## 3                                                                                                                                                                      0.0
## 4                                                                                                                                                                      0.7
## 5                                                                                                                                                                      0.0
## 6                                                                                                                                                                      1.9
##                                                                                                                                                                       DP05_0085PM
## 1 Percent Margin of Error!!HISPANIC OR LATINO AND RACE!!Total population!!Not Hispanic or Latino!!Two or more races!!Two races excluding Some other race, and Three or more races
## 2                                                                                                                                                                             0.5
## 3                                                                                                                                                                             0.7
## 4                                                                                                                                                                             0.9
## 5                                                                                                                                                                             0.5
## 6                                                                                                                                                                             2.1
##                      DP05_0086E                           DP05_0086M
## 1 Estimate!!Total housing units Margin of Error!!Total housing units
## 2                             0                                   17
## 3                          1486                                   58
## 4                          2115                                   49
## 5                          2069                                   54
## 6                          1002                                   48
##                             DP05_0086PE
## 1 Percent Estimate!!Total housing units
## 2                                   (X)
## 3                                   (X)
## 4                                   (X)
## 5                                   (X)
## 6                                   (X)
##                                    DP05_0086PM
## 1 Percent Margin of Error!!Total housing units
## 2                                          (X)
## 3                                          (X)
## 4                                          (X)
## 5                                          (X)
## 6                                          (X)
##                                                                  DP05_0087E
## 1 Estimate!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population
## 2                                                                      6100
## 3                                                                      2952
## 4                                                                      4214
## 5                                                                      3851
## 6                                                                      1787
##                                                                         DP05_0087M
## 1 Margin of Error!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population
## 2                                                                              280
## 3                                                                              481
## 4                                                                              412
## 5                                                                              365
## 6                                                                              251
##                                                                         DP05_0087PE
## 1 Percent Estimate!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population
## 2                                                                              6100
## 3                                                                              2952
## 4                                                                              4214
## 5                                                                              3851
## 6                                                                              1787
##                                                                                DP05_0087PM
## 1 Percent Margin of Error!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population
## 2                                                                                      (X)
## 3                                                                                      (X)
## 4                                                                                      (X)
## 5                                                                                      (X)
## 6                                                                                      (X)
##                                                                        DP05_0088E
## 1 Estimate!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population!!Male
## 2                                                                            5596
## 3                                                                            1529
## 4                                                                            2217
## 5                                                                            1529
## 6                                                                             942
##                                                                               DP05_0088M
## 1 Margin of Error!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population!!Male
## 2                                                                                    264
## 3                                                                                    287
## 4                                                                                    274
## 5                                                                                    255
## 6                                                                                    172
##                                                                               DP05_0088PE
## 1 Percent Estimate!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population!!Male
## 2                                                                                    91.7
## 3                                                                                    51.8
## 4                                                                                    52.6
## 5                                                                                    39.7
## 6                                                                                    52.7
##                                                                                      DP05_0088PM
## 1 Percent Margin of Error!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population!!Male
## 2                                                                                            2.6
## 3                                                                                            5.1
## 4                                                                                            3.2
## 5                                                                                            5.2
## 6                                                                                            5.2
##                                                                          DP05_0089E
## 1 Estimate!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population!!Female
## 2                                                                               504
## 3                                                                              1423
## 4                                                                              1997
## 5                                                                              2322
## 6                                                                               845
##                                                                                 DP05_0089M
## 1 Margin of Error!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population!!Female
## 2                                                                                      167
## 3                                                                                      279
## 4                                                                                      220
## 5                                                                                      287
## 6                                                                                      141
##                                                                                 DP05_0089PE
## 1 Percent Estimate!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population!!Female
## 2                                                                                       8.3
## 3                                                                                      48.2
## 4                                                                                      47.4
## 5                                                                                      60.3
## 6                                                                                      47.3
##                                                                                        DP05_0089PM
## 1 Percent Margin of Error!!CITIZEN, VOTING AGE POPULATION!!Citizen, 18 and over population!!Female
## 2                                                                                              2.6
## 3                                                                                              5.1
## 4                                                                                              3.2
## 5                                                                                              5.2
## 6                                                                                              5.2
##                                DP05_0001E
## 1 Estimate!!SEX AND AGE!!Total population
## 2                                    7080
## 3                                    4542
## 4                                    5634
## 5                                    5917
## 6                                    2765
##                                       DP05_0001M
## 1 Margin of Error!!SEX AND AGE!!Total population
## 2                                            290
## 3                                            574
## 4                                            517
## 5                                            461
## 6                                            307
##                                       DP05_0001PE
## 1 Percent Estimate!!SEX AND AGE!!Total population
## 2                                            7080
## 3                                            4542
## 4                                            5634
## 5                                            5917
## 6                                            2765
##                                              DP05_0001PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population
## 2                                                    (X)
## 3                                                    (X)
## 4                                                    (X)
## 5                                                    (X)
## 6                                                    (X)
##                                      DP05_0002E
## 1 Estimate!!SEX AND AGE!!Total population!!Male
## 2                                          6503
## 3                                          2264
## 4                                          2807
## 5                                          2365
## 6                                          1363
##                                             DP05_0002M
## 1 Margin of Error!!SEX AND AGE!!Total population!!Male
## 2                                                  284
## 3                                                  351
## 4                                                  314
## 5                                                  265
## 6                                                  218
##                                             DP05_0002PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!Male
## 2                                                  91.9
## 3                                                  49.8
## 4                                                  49.8
## 5                                                  40.0
## 6                                                  49.3
##                                                    DP05_0002PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!Male
## 2                                                          2.6
## 3                                                          4.1
## 4                                                          3.1
## 5                                                          3.6
## 6                                                          4.8
##                                        DP05_0003E
## 1 Estimate!!SEX AND AGE!!Total population!!Female
## 2                                             577
## 3                                            2278
## 4                                            2827
## 5                                            3552
## 6                                            1402
##                                               DP05_0003M
## 1 Margin of Error!!SEX AND AGE!!Total population!!Female
## 2                                                    191
## 3                                                    334
## 4                                                    310
## 5                                                    366
## 6                                                    187
##                                               DP05_0003PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!Female
## 2                                                     8.1
## 3                                                    50.2
## 4                                                    50.2
## 5                                                    60.0
## 6                                                    50.7
##                                                      DP05_0003PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!Female
## 2                                                            2.6
## 3                                                            4.1
## 4                                                            3.1
## 5                                                            3.6
## 6                                                            4.8
##                                                                   DP05_0004E
## 1 Estimate!!SEX AND AGE!!Total population!!Sex ratio (males per 100 females)
## 2                                                                     1127.0
## 3                                                                       99.4
## 4                                                                       99.3
## 5                                                                       66.6
## 6                                                                       97.2
##                                                                          DP05_0004M
## 1 Margin of Error!!SEX AND AGE!!Total population!!Sex ratio (males per 100 females)
## 2                                                                             414.5
## 3                                                                              16.7
## 4                                                                              12.1
## 5                                                                               9.9
## 6                                                                              19.0
##                                                                          DP05_0004PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!Sex ratio (males per 100 females)
## 2                                                                                (X)
## 3                                                                                (X)
## 4                                                                                (X)
## 5                                                                                (X)
## 6                                                                                (X)
##                                                                                 DP05_0004PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!Sex ratio (males per 100 females)
## 2                                                                                       (X)
## 3                                                                                       (X)
## 4                                                                                       (X)
## 5                                                                                       (X)
## 6                                                                                       (X)
##                                               DP05_0005E
## 1 Estimate!!SEX AND AGE!!Total population!!Under 5 years
## 2                                                      0
## 3                                                    159
## 4                                                    197
## 5                                                    313
## 6                                                    287
##                                                      DP05_0005M
## 1 Margin of Error!!SEX AND AGE!!Total population!!Under 5 years
## 2                                                            17
## 3                                                            88
## 4                                                            85
## 5                                                            87
## 6                                                            86
##                                                      DP05_0005PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!Under 5 years
## 2                                                            0.0
## 3                                                            3.5
## 4                                                            3.5
## 5                                                            5.3
## 6                                                           10.4
##                                                             DP05_0005PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!Under 5 years
## 2                                                                   0.5
## 3                                                                   1.8
## 4                                                                   1.5
## 5                                                                   1.5
## 6                                                                   2.7
##                                              DP05_0006E
## 1 Estimate!!SEX AND AGE!!Total population!!5 to 9 years
## 2                                                     0
## 3                                                   199
## 4                                                   339
## 5                                                   437
## 6                                                   270
##                                                     DP05_0006M
## 1 Margin of Error!!SEX AND AGE!!Total population!!5 to 9 years
## 2                                                           17
## 3                                                          114
## 4                                                          117
## 5                                                          134
## 6                                                           77
##                                                     DP05_0006PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!5 to 9 years
## 2                                                           0.0
## 3                                                           4.4
## 4                                                           6.0
## 5                                                           7.4
## 6                                                           9.8
##                                                            DP05_0006PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!5 to 9 years
## 2                                                                  0.5
## 3                                                                  2.5
## 4                                                                  1.9
## 5                                                                  2.1
## 6                                                                  2.7
##                                                DP05_0007E
## 1 Estimate!!SEX AND AGE!!Total population!!10 to 14 years
## 2                                                       0
## 3                                                     454
## 4                                                     344
## 5                                                     443
## 6                                                     120
##                                                       DP05_0007M
## 1 Margin of Error!!SEX AND AGE!!Total population!!10 to 14 years
## 2                                                             17
## 3                                                            172
## 4                                                            162
## 5                                                            169
## 6                                                             50
##                                                       DP05_0007PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!10 to 14 years
## 2                                                             0.0
## 3                                                            10.0
## 4                                                             6.1
## 5                                                             7.5
## 6                                                             4.3
##                                                              DP05_0007PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!10 to 14 years
## 2                                                                    0.5
## 3                                                                    3.6
## 4                                                                    2.7
## 5                                                                    2.6
## 6                                                                    1.8
##                                                DP05_0008E
## 1 Estimate!!SEX AND AGE!!Total population!!15 to 19 years
## 2                                                     541
## 3                                                     314
## 4                                                     339
## 5                                                     437
## 6                                                     132
##                                                       DP05_0008M
## 1 Margin of Error!!SEX AND AGE!!Total population!!15 to 19 years
## 2                                                            135
## 3                                                            140
## 4                                                            106
## 5                                                            117
## 6                                                             62
##                                                       DP05_0008PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!15 to 19 years
## 2                                                             7.6
## 3                                                             6.9
## 4                                                             6.0
## 5                                                             7.4
## 6                                                             4.8
##                                                              DP05_0008PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!15 to 19 years
## 2                                                                    1.9
## 3                                                                    2.8
## 4                                                                    1.9
## 5                                                                    1.9
## 6                                                                    2.2
##                                                DP05_0009E
## 1 Estimate!!SEX AND AGE!!Total population!!20 to 24 years
## 2                                                    1119
## 3                                                     366
## 4                                                     454
## 5                                                     599
## 6                                                     186
##                                                       DP05_0009M
## 1 Margin of Error!!SEX AND AGE!!Total population!!20 to 24 years
## 2                                                            185
## 3                                                            153
## 4                                                            198
## 5                                                            205
## 6                                                             62
##                                                       DP05_0009PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!20 to 24 years
## 2                                                            15.8
## 3                                                             8.1
## 4                                                             8.1
## 5                                                            10.1
## 6                                                             6.7
##                                                              DP05_0009PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!20 to 24 years
## 2                                                                    2.5
## 3                                                                    3.2
## 4                                                                    3.4
## 5                                                                    3.3
## 6                                                                    2.2
##                                                DP05_0010E
## 1 Estimate!!SEX AND AGE!!Total population!!25 to 34 years
## 2                                                    2066
## 3                                                     369
## 4                                                     819
## 5                                                     624
## 6                                                     696
##                                                       DP05_0010M
## 1 Margin of Error!!SEX AND AGE!!Total population!!25 to 34 years
## 2                                                            181
## 3                                                            163
## 4                                                            240
## 5                                                            169
## 6                                                            154
##                                                       DP05_0010PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!25 to 34 years
## 2                                                            29.2
## 3                                                             8.1
## 4                                                            14.5
## 5                                                            10.5
## 6                                                            25.2
##                                                              DP05_0010PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!25 to 34 years
## 2                                                                    2.6
## 3                                                                    3.2
## 4                                                                    4.0
## 5                                                                    2.8
## 6                                                                    4.5
##                                                DP05_0011E
## 1 Estimate!!SEX AND AGE!!Total population!!35 to 44 years
## 2                                                    1662
## 3                                                     537
## 4                                                     681
## 5                                                     637
## 6                                                     429
##                                                       DP05_0011M
## 1 Margin of Error!!SEX AND AGE!!Total population!!35 to 44 years
## 2                                                            230
## 3                                                            157
## 4                                                            182
## 5                                                            176
## 6                                                             93
##                                                       DP05_0011PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!35 to 44 years
## 2                                                            23.5
## 3                                                            11.8
## 4                                                            12.1
## 5                                                            10.8
## 6                                                            15.5
##                                                              DP05_0011PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!35 to 44 years
## 2                                                                    3.0
## 3                                                                    3.5
## 4                                                                    3.5
## 5                                                                    2.9
## 6                                                                    3.1
##                                                DP05_0012E
## 1 Estimate!!SEX AND AGE!!Total population!!45 to 54 years
## 2                                                    1204
## 3                                                     791
## 4                                                     939
## 5                                                     765
## 6                                                     312
##                                                       DP05_0012M
## 1 Margin of Error!!SEX AND AGE!!Total population!!45 to 54 years
## 2                                                            187
## 3                                                            219
## 4                                                            229
## 5                                                            169
## 6                                                             73
##                                                       DP05_0012PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!45 to 54 years
## 2                                                            17.0
## 3                                                            17.4
## 4                                                            16.7
## 5                                                            12.9
## 6                                                            11.3
##                                                              DP05_0012PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!45 to 54 years
## 2                                                                    2.6
## 3                                                                    4.1
## 4                                                                    3.3
## 5                                                                    2.6
## 6                                                                    2.6
##                                                DP05_0013E
## 1 Estimate!!SEX AND AGE!!Total population!!55 to 59 years
## 2                                                     339
## 3                                                     158
## 4                                                     509
## 5                                                     387
## 6                                                     179
##                                                       DP05_0013M
## 1 Margin of Error!!SEX AND AGE!!Total population!!55 to 59 years
## 2                                                             89
## 3                                                             77
## 4                                                            150
## 5                                                            164
## 6                                                            108
##                                                       DP05_0013PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!55 to 59 years
## 2                                                             4.8
## 3                                                             3.5
## 4                                                             9.0
## 5                                                             6.5
## 6                                                             6.5
##                                                              DP05_0013PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!55 to 59 years
## 2                                                                    1.2
## 3                                                                    1.6
## 4                                                                    2.7
## 5                                                                    2.7
## 6                                                                    3.6
##                                                DP05_0014E
## 1 Estimate!!SEX AND AGE!!Total population!!60 to 64 years
## 2                                                      98
## 3                                                     245
## 4                                                     303
## 5                                                     286
## 6                                                      78
##                                                       DP05_0014M
## 1 Margin of Error!!SEX AND AGE!!Total population!!60 to 64 years
## 2                                                             48
## 3                                                            100
## 4                                                            123
## 5                                                            116
## 6                                                             42
##                                                       DP05_0014PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!60 to 64 years
## 2                                                             1.4
## 3                                                             5.4
## 4                                                             5.4
## 5                                                             4.8
## 6                                                             2.8
##                                                              DP05_0014PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!60 to 64 years
## 2                                                                    0.7
## 3                                                                    2.2
## 4                                                                    2.1
## 5                                                                    2.1
## 6                                                                    1.6
##                                                DP05_0015E
## 1 Estimate!!SEX AND AGE!!Total population!!65 to 74 years
## 2                                                      51
## 3                                                     718
## 4                                                     459
## 5                                                     429
## 6                                                      47
##                                                       DP05_0015M
## 1 Margin of Error!!SEX AND AGE!!Total population!!65 to 74 years
## 2                                                             44
## 3                                                            185
## 4                                                            122
## 5                                                            121
## 6                                                             30
##                                                       DP05_0015PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!65 to 74 years
## 2                                                             0.7
## 3                                                            15.8
## 4                                                             8.1
## 5                                                             7.3
## 6                                                             1.7
##                                                              DP05_0015PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!65 to 74 years
## 2                                                                    0.6
## 3                                                                    4.2
## 4                                                                    2.2
## 5                                                                    2.0
## 6                                                                    1.1
##                                                DP05_0016E
## 1 Estimate!!SEX AND AGE!!Total population!!75 to 84 years
## 2                                                       0
## 3                                                     124
## 4                                                     163
## 5                                                     451
## 6                                                      29
##                                                       DP05_0016M
## 1 Margin of Error!!SEX AND AGE!!Total population!!75 to 84 years
## 2                                                             17
## 3                                                             87
## 4                                                             91
## 5                                                            112
## 6                                                             29
##                                                       DP05_0016PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!75 to 84 years
## 2                                                             0.0
## 3                                                             2.7
## 4                                                             2.9
## 5                                                             7.6
## 6                                                             1.0
##                                                              DP05_0016PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!75 to 84 years
## 2                                                                    0.5
## 3                                                                    1.9
## 4                                                                    1.6
## 5                                                                    1.9
## 6                                                                    1.0
##                                                   DP05_0017E
## 1 Estimate!!SEX AND AGE!!Total population!!85 years and over
## 2                                                          0
## 3                                                        108
## 4                                                         88
## 5                                                        109
## 6                                                          0
##                                                          DP05_0017M
## 1 Margin of Error!!SEX AND AGE!!Total population!!85 years and over
## 2                                                                17
## 3                                                                78
## 4                                                                65
## 5                                                                65
## 6                                                                12
##                                                          DP05_0017PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!85 years and over
## 2                                                                0.0
## 3                                                                2.4
## 4                                                                1.6
## 5                                                                1.8
## 6                                                                0.0
##                                                                 DP05_0017PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!85 years and over
## 2                                                                       0.5
## 3                                                                       1.7
## 4                                                                       1.2
## 5                                                                       1.1
## 6                                                                       1.2
##                                                    DP05_0018E
## 1 Estimate!!SEX AND AGE!!Total population!!Median age (years)
## 2                                                        34.1
## 3                                                        43.2
## 4                                                        40.6
## 5                                                        37.4
## 6                                                        30.8
##                                                           DP05_0018M
## 1 Margin of Error!!SEX AND AGE!!Total population!!Median age (years)
## 2                                                                0.9
## 3                                                                5.3
## 4                                                                4.1
## 5                                                                5.5
## 6                                                                1.1
##                                                           DP05_0018PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!Median age (years)
## 2                                                                 (X)
## 3                                                                 (X)
## 4                                                                 (X)
## 5                                                                 (X)
## 6                                                                 (X)
##                                                                  DP05_0018PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!Median age (years)
## 2                                                                        (X)
## 3                                                                        (X)
## 4                                                                        (X)
## 5                                                                        (X)
## 6                                                                        (X)
##                                                DP05_0019E
## 1 Estimate!!SEX AND AGE!!Total population!!Under 18 years
## 2                                                     171
## 3                                                     960
## 4                                                    1127
## 5                                                    1501
## 6                                                     757
##                                                       DP05_0019M
## 1 Margin of Error!!SEX AND AGE!!Total population!!Under 18 years
## 2                                                             89
## 3                                                            263
## 4                                                            253
## 5                                                            259
## 6                                                            139
##                                                       DP05_0019PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!Under 18 years
## 2                                                             2.4
## 3                                                            21.1
## 4                                                            20.0
## 5                                                            25.4
## 6                                                            27.4
##                                                              DP05_0019PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!Under 18 years
## 2                                                                    1.3
## 3                                                                    4.8
## 4                                                                    3.8
## 5                                                                    3.4
## 6                                                                    4.1
##                                                   DP05_0020E
## 1 Estimate!!SEX AND AGE!!Total population!!16 years and over
## 2                                                       7080
## 3                                                       3684
## 4                                                       4689
## 5                                                       4598
## 6                                                       2066
##                                                          DP05_0020M
## 1 Margin of Error!!SEX AND AGE!!Total population!!16 years and over
## 2                                                               290
## 3                                                               491
## 4                                                               425
## 5                                                               351
## 6                                                               266
##                                                          DP05_0020PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!16 years and over
## 2                                                              100.0
## 3                                                               81.1
## 4                                                               83.2
## 5                                                               77.7
## 6                                                               74.7
##                                                                 DP05_0020PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!16 years and over
## 2                                                                       0.5
## 3                                                                       4.6
## 4                                                                       3.3
## 5                                                                       3.4
## 6                                                                       4.2
##                                                   DP05_0021E
## 1 Estimate!!SEX AND AGE!!Total population!!18 years and over
## 2                                                       6909
## 3                                                       3582
## 4                                                       4507
## 5                                                       4416
## 6                                                       2008
##                                                          DP05_0021M
## 1 Margin of Error!!SEX AND AGE!!Total population!!18 years and over
## 2                                                               299
## 3                                                               479
## 4                                                               425
## 5                                                               352
## 6                                                               254
##                                                          DP05_0021PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!18 years and over
## 2                                                               97.6
## 3                                                               78.9
## 4                                                               80.0
## 5                                                               74.6
## 6                                                               72.6
##                                                                 DP05_0021PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!18 years and over
## 2                                                                       1.3
## 3                                                                       4.8
## 4                                                                       3.8
## 5                                                                       3.4
## 6                                                                       4.1
##                                                   DP05_0022E
## 1 Estimate!!SEX AND AGE!!Total population!!21 years and over
## 2                                                       6332
## 3                                                       3400
## 4                                                       4329
## 5                                                       4227
## 6                                                       1930
##                                                          DP05_0022M
## 1 Margin of Error!!SEX AND AGE!!Total population!!21 years and over
## 2                                                               281
## 3                                                               455
## 4                                                               413
## 5                                                               342
## 6                                                               260
##                                                          DP05_0022PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!21 years and over
## 2                                                               89.4
## 3                                                               74.9
## 4                                                               76.8
## 5                                                               71.4
## 6                                                               69.8
##                                                                 DP05_0022PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!21 years and over
## 2                                                                       1.9
## 3                                                                       5.4
## 4                                                                       3.9
## 5                                                                       3.7
## 6                                                                       4.7
##                                                   DP05_0023E
## 1 Estimate!!SEX AND AGE!!Total population!!62 years and over
## 2                                                         99
## 3                                                       1094
## 4                                                        909
## 5                                                       1140
## 6                                                        123
##                                                          DP05_0023M
## 1 Margin of Error!!SEX AND AGE!!Total population!!62 years and over
## 2                                                                56
## 3                                                               258
## 4                                                               175
## 5                                                               167
## 6                                                                50
##                                                          DP05_0023PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!62 years and over
## 2                                                                1.4
## 3                                                               24.1
## 4                                                               16.1
## 5                                                               19.3
## 6                                                                4.4
##                                                                 DP05_0023PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!62 years and over
## 2                                                                       0.8
## 3                                                                       5.6
## 4                                                                       3.2
## 5                                                                       3.0
## 6                                                                       1.7
##                                                   DP05_0024E
## 1 Estimate!!SEX AND AGE!!Total population!!65 years and over
## 2                                                         51
## 3                                                        950
## 4                                                        710
## 5                                                        989
## 6                                                         76
##                                                          DP05_0024M
## 1 Margin of Error!!SEX AND AGE!!Total population!!65 years and over
## 2                                                                44
## 3                                                               233
## 4                                                               153
## 5                                                               151
## 6                                                                38
##                                                          DP05_0024PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!65 years and over
## 2                                                                0.7
## 3                                                               20.9
## 4                                                               12.6
## 5                                                               16.7
## 6                                                                2.7
##                                                                 DP05_0024PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!65 years and over
## 2                                                                       0.6
## 3                                                                       5.1
## 4                                                                       2.9
## 5                                                                       2.6
## 6                                                                       1.2
##                                                   DP05_0025E
## 1 Estimate!!SEX AND AGE!!Total population!!18 years and over
## 2                                                       6909
## 3                                                       3582
## 4                                                       4507
## 5                                                       4416
## 6                                                       2008
##                                                          DP05_0025M
## 1 Margin of Error!!SEX AND AGE!!Total population!!18 years and over
## 2                                                               299
## 3                                                               479
## 4                                                               425
## 5                                                               352
## 6                                                               254
##                                                          DP05_0025PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!18 years and over
## 2                                                               6909
## 3                                                               3582
## 4                                                               4507
## 5                                                               4416
## 6                                                               2008
##                                                                 DP05_0025PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!18 years and over
## 2                                                                       (X)
## 3                                                                       (X)
## 4                                                                       (X)
## 5                                                                       (X)
## 6                                                                       (X)
##                                                         DP05_0026E
## 1 Estimate!!SEX AND AGE!!Total population!!18 years and over!!Male
## 2                                                             6340
## 3                                                             1864
## 4                                                             2309
## 5                                                             1778
## 6                                                             1036
##                                                                DP05_0026M
## 1 Margin of Error!!SEX AND AGE!!Total population!!18 years and over!!Male
## 2                                                                     293
## 3                                                                     286
## 4                                                                     279
## 5                                                                     220
## 6                                                                     186
##                                                                DP05_0026PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!18 years and over!!Male
## 2                                                                     91.8
## 3                                                                     52.0
## 4                                                                     51.2
## 5                                                                     40.3
## 6                                                                     51.6
##                                                                       DP05_0026PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!18 years and over!!Male
## 2                                                                             2.6
## 3                                                                             4.2
## 4                                                                             3.0
## 5                                                                             3.8
## 6                                                                             5.1
##                                                           DP05_0027E
## 1 Estimate!!SEX AND AGE!!Total population!!18 years and over!!Female
## 2                                                                569
## 3                                                               1718
## 4                                                               2198
## 5                                                               2638
## 6                                                                972
##                                                                  DP05_0027M
## 1 Margin of Error!!SEX AND AGE!!Total population!!18 years and over!!Female
## 2                                                                       189
## 3                                                                       278
## 4                                                                       221
## 5                                                                       268
## 6                                                                       139
##                                                                  DP05_0027PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!18 years and over!!Female
## 2                                                                        8.2
## 3                                                                       48.0
## 4                                                                       48.8
## 5                                                                       59.7
## 6                                                                       48.4
##                                                                         DP05_0027PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!18 years and over!!Female
## 2                                                                               2.6
## 3                                                                               4.2
## 4                                                                               3.0
## 5                                                                               3.8
## 6                                                                               5.1
##                                                                                      DP05_0028E
## 1 Estimate!!SEX AND AGE!!Total population!!18 years and over!!Sex ratio (males per 100 females)
## 2                                                                                        1114.2
## 3                                                                                         108.5
## 4                                                                                         105.1
## 5                                                                                          67.4
## 6                                                                                         106.6
##                                                                                             DP05_0028M
## 1 Margin of Error!!SEX AND AGE!!Total population!!18 years and over!!Sex ratio (males per 100 females)
## 2                                                                                                414.1
## 3                                                                                                 18.4
## 4                                                                                                 12.2
## 5                                                                                                 10.7
## 6                                                                                                 22.3
##                                                                                             DP05_0028PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!18 years and over!!Sex ratio (males per 100 females)
## 2                                                                                                   (X)
## 3                                                                                                   (X)
## 4                                                                                                   (X)
## 5                                                                                                   (X)
## 6                                                                                                   (X)
##                                                                                                    DP05_0028PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!18 years and over!!Sex ratio (males per 100 females)
## 2                                                                                                          (X)
## 3                                                                                                          (X)
## 4                                                                                                          (X)
## 5                                                                                                          (X)
## 6                                                                                                          (X)
##                                                   DP05_0029E
## 1 Estimate!!SEX AND AGE!!Total population!!65 years and over
## 2                                                         51
## 3                                                        950
## 4                                                        710
## 5                                                        989
## 6                                                         76
##                                                          DP05_0029M
## 1 Margin of Error!!SEX AND AGE!!Total population!!65 years and over
## 2                                                                44
## 3                                                               233
## 4                                                               153
## 5                                                               151
## 6                                                                38
##                                                          DP05_0029PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!65 years and over
## 2                                                                 51
## 3                                                                950
## 4                                                                710
## 5                                                                989
## 6                                                                 76
##                                                                 DP05_0029PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!65 years and over
## 2                                                                       (X)
## 3                                                                       (X)
## 4                                                                       (X)
## 5                                                                       (X)
## 6                                                                       (X)
##                                                         DP05_0030E
## 1 Estimate!!SEX AND AGE!!Total population!!65 years and over!!Male
## 2                                                               34
## 3                                                              463
## 4                                                              339
## 5                                                              295
## 6                                                               54
##                                                                DP05_0030M
## 1 Margin of Error!!SEX AND AGE!!Total population!!65 years and over!!Male
## 2                                                                      32
## 3                                                                     123
## 4                                                                     101
## 5                                                                      94
## 6                                                                      32
##                                                                DP05_0030PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!65 years and over!!Male
## 2                                                                     66.7
## 3                                                                     48.7
## 4                                                                     47.7
## 5                                                                     29.8
## 6                                                                     71.1
##                                                                       DP05_0030PM
## 1 Percent Margin of Error!!SEX AND AGE!!Total population!!65 years and over!!Male
## 2                                                                            50.4
## 3                                                                             9.5
## 4                                                                             8.8
## 5                                                                             8.9
## 6                                                                            25.5
##                                                           DP05_0031E
## 1 Estimate!!SEX AND AGE!!Total population!!65 years and over!!Female
## 2                                                                 17
## 3                                                                487
## 4                                                                371
## 5                                                                694
## 6                                                                 22
##                                                                  DP05_0031M
## 1 Margin of Error!!SEX AND AGE!!Total population!!65 years and over!!Female
## 2                                                                        30
## 3                                                                       166
## 4                                                                        96
## 5                                                                       144
## 6                                                                        22
##                                                                  DP05_0031PE
## 1 Percent Estimate!!SEX AND AGE!!Total population!!65 years and over!!Female
## 2                                                                       33.3
## 3                                                                       51.3
## 4                                                                       52.3
## 5                                                                       70.2
## 6                                                                       28.9
acs_df$ct2010 <- substr(acs_df$GEO_ID, 10, 20)

nyc_tracts_sf <- left_join(nyc_tracts_sf, acs_df, by = "ct2010")

names(nyc_tracts_sf)
##   [1] "boro_code"   "boro_ct201"  "boro_name"   "cdeligibil"  "ct2010"     
##   [6] "ctlabel"     "ntacode"     "ntaname"     "puma"        "shape_area" 
##  [11] "shape_leng"  "GEO_ID"      "NAME"        "DP05_0031PM" "DP05_0032E" 
##  [16] "DP05_0032M"  "DP05_0032PE" "DP05_0032PM" "DP05_0033E"  "DP05_0033M" 
##  [21] "DP05_0033PE" "DP05_0033PM" "DP05_0034E"  "DP05_0034M"  "DP05_0034PE"
##  [26] "DP05_0034PM" "DP05_0035E"  "DP05_0035M"  "DP05_0035PE" "DP05_0035PM"
##  [31] "DP05_0036E"  "DP05_0036M"  "DP05_0036PE" "DP05_0036PM" "DP05_0037E" 
##  [36] "DP05_0037M"  "DP05_0037PE" "DP05_0037PM" "DP05_0038E"  "DP05_0038M" 
##  [41] "DP05_0038PE" "DP05_0038PM" "DP05_0039E"  "DP05_0039M"  "DP05_0039PE"
##  [46] "DP05_0039PM" "DP05_0040E"  "DP05_0040M"  "DP05_0040PE" "DP05_0040PM"
##  [51] "DP05_0041E"  "DP05_0041M"  "DP05_0041PE" "DP05_0041PM" "DP05_0042E" 
##  [56] "DP05_0042M"  "DP05_0042PE" "DP05_0042PM" "DP05_0043E"  "DP05_0043M" 
##  [61] "DP05_0043PE" "DP05_0043PM" "DP05_0044E"  "DP05_0044M"  "DP05_0044PE"
##  [66] "DP05_0044PM" "DP05_0045E"  "DP05_0045M"  "DP05_0045PE" "DP05_0045PM"
##  [71] "DP05_0046E"  "DP05_0046M"  "DP05_0046PE" "DP05_0046PM" "DP05_0047E" 
##  [76] "DP05_0047M"  "DP05_0047PE" "DP05_0047PM" "DP05_0048E"  "DP05_0048M" 
##  [81] "DP05_0048PE" "DP05_0048PM" "DP05_0049E"  "DP05_0049M"  "DP05_0049PE"
##  [86] "DP05_0049PM" "DP05_0050E"  "DP05_0050M"  "DP05_0050PE" "DP05_0050PM"
##  [91] "DP05_0051E"  "DP05_0051M"  "DP05_0051PE" "DP05_0051PM" "DP05_0052E" 
##  [96] "DP05_0052M"  "DP05_0052PE" "DP05_0052PM" "DP05_0053E"  "DP05_0053M" 
## [101] "DP05_0053PE" "DP05_0053PM" "DP05_0054E"  "DP05_0054M"  "DP05_0054PE"
## [106] "DP05_0054PM" "DP05_0055E"  "DP05_0055M"  "DP05_0055PE" "DP05_0055PM"
## [111] "DP05_0056E"  "DP05_0056M"  "DP05_0056PE" "DP05_0056PM" "DP05_0057E" 
## [116] "DP05_0057M"  "DP05_0057PE" "DP05_0057PM" "DP05_0058E"  "DP05_0058M" 
## [121] "DP05_0058PE" "DP05_0058PM" "DP05_0059E"  "DP05_0059M"  "DP05_0059PE"
## [126] "DP05_0059PM" "DP05_0060E"  "DP05_0060M"  "DP05_0060PE" "DP05_0060PM"
## [131] "DP05_0061E"  "DP05_0061M"  "DP05_0061PE" "DP05_0061PM" "DP05_0062E" 
## [136] "DP05_0062M"  "DP05_0062PE" "DP05_0062PM" "DP05_0063E"  "DP05_0063M" 
## [141] "DP05_0063PE" "DP05_0063PM" "DP05_0064E"  "DP05_0064M"  "DP05_0064PE"
## [146] "DP05_0064PM" "DP05_0065E"  "DP05_0065M"  "DP05_0065PE" "DP05_0065PM"
## [151] "DP05_0066E"  "DP05_0066M"  "DP05_0066PE" "DP05_0066PM" "DP05_0067E" 
## [156] "DP05_0067M"  "DP05_0067PE" "DP05_0067PM" "DP05_0068E"  "DP05_0068M" 
## [161] "DP05_0068PE" "DP05_0068PM" "DP05_0069E"  "DP05_0069M"  "DP05_0069PE"
## [166] "DP05_0069PM" "DP05_0070E"  "DP05_0070M"  "DP05_0070PE" "DP05_0070PM"
## [171] "DP05_0071E"  "DP05_0071M"  "DP05_0071PE" "DP05_0071PM" "DP05_0072E" 
## [176] "DP05_0072M"  "DP05_0072PE" "DP05_0072PM" "DP05_0073E"  "DP05_0073M" 
## [181] "DP05_0073PE" "DP05_0073PM" "DP05_0074E"  "DP05_0074M"  "DP05_0074PE"
## [186] "DP05_0074PM" "DP05_0075E"  "DP05_0075M"  "DP05_0075PE" "DP05_0075PM"
## [191] "DP05_0076E"  "DP05_0076M"  "DP05_0076PE" "DP05_0076PM" "DP05_0077E" 
## [196] "DP05_0077M"  "DP05_0077PE" "DP05_0077PM" "DP05_0078E"  "DP05_0078M" 
## [201] "DP05_0078PE" "DP05_0078PM" "DP05_0079E"  "DP05_0079M"  "DP05_0079PE"
## [206] "DP05_0079PM" "DP05_0080E"  "DP05_0080M"  "DP05_0080PE" "DP05_0080PM"
## [211] "DP05_0081E"  "DP05_0081M"  "DP05_0081PE" "DP05_0081PM" "DP05_0082E" 
## [216] "DP05_0082M"  "DP05_0082PE" "DP05_0082PM" "DP05_0083E"  "DP05_0083M" 
## [221] "DP05_0083PE" "DP05_0083PM" "DP05_0084E"  "DP05_0084M"  "DP05_0084PE"
## [226] "DP05_0084PM" "DP05_0085E"  "DP05_0085M"  "DP05_0085PE" "DP05_0085PM"
## [231] "DP05_0086E"  "DP05_0086M"  "DP05_0086PE" "DP05_0086PM" "DP05_0087E" 
## [236] "DP05_0087M"  "DP05_0087PE" "DP05_0087PM" "DP05_0088E"  "DP05_0088M" 
## [241] "DP05_0088PE" "DP05_0088PM" "DP05_0089E"  "DP05_0089M"  "DP05_0089PE"
## [246] "DP05_0089PM" "DP05_0001E"  "DP05_0001M"  "DP05_0001PE" "DP05_0001PM"
## [251] "DP05_0002E"  "DP05_0002M"  "DP05_0002PE" "DP05_0002PM" "DP05_0003E" 
## [256] "DP05_0003M"  "DP05_0003PE" "DP05_0003PM" "DP05_0004E"  "DP05_0004M" 
## [261] "DP05_0004PE" "DP05_0004PM" "DP05_0005E"  "DP05_0005M"  "DP05_0005PE"
## [266] "DP05_0005PM" "DP05_0006E"  "DP05_0006M"  "DP05_0006PE" "DP05_0006PM"
## [271] "DP05_0007E"  "DP05_0007M"  "DP05_0007PE" "DP05_0007PM" "DP05_0008E" 
## [276] "DP05_0008M"  "DP05_0008PE" "DP05_0008PM" "DP05_0009E"  "DP05_0009M" 
## [281] "DP05_0009PE" "DP05_0009PM" "DP05_0010E"  "DP05_0010M"  "DP05_0010PE"
## [286] "DP05_0010PM" "DP05_0011E"  "DP05_0011M"  "DP05_0011PE" "DP05_0011PM"
## [291] "DP05_0012E"  "DP05_0012M"  "DP05_0012PE" "DP05_0012PM" "DP05_0013E" 
## [296] "DP05_0013M"  "DP05_0013PE" "DP05_0013PM" "DP05_0014E"  "DP05_0014M" 
## [301] "DP05_0014PE" "DP05_0014PM" "DP05_0015E"  "DP05_0015M"  "DP05_0015PE"
## [306] "DP05_0015PM" "DP05_0016E"  "DP05_0016M"  "DP05_0016PE" "DP05_0016PM"
## [311] "DP05_0017E"  "DP05_0017M"  "DP05_0017PE" "DP05_0017PM" "DP05_0018E" 
## [316] "DP05_0018M"  "DP05_0018PE" "DP05_0018PM" "DP05_0019E"  "DP05_0019M" 
## [321] "DP05_0019PE" "DP05_0019PM" "DP05_0020E"  "DP05_0020M"  "DP05_0020PE"
## [326] "DP05_0020PM" "DP05_0021E"  "DP05_0021M"  "DP05_0021PE" "DP05_0021PM"
## [331] "DP05_0022E"  "DP05_0022M"  "DP05_0022PE" "DP05_0022PM" "DP05_0023E" 
## [336] "DP05_0023M"  "DP05_0023PE" "DP05_0023PM" "DP05_0024E"  "DP05_0024M" 
## [341] "DP05_0024PE" "DP05_0024PM" "DP05_0025E"  "DP05_0025M"  "DP05_0025PE"
## [346] "DP05_0025PM" "DP05_0026E"  "DP05_0026M"  "DP05_0026PE" "DP05_0026PM"
## [351] "DP05_0027E"  "DP05_0027M"  "DP05_0027PE" "DP05_0027PM" "DP05_0028E" 
## [356] "DP05_0028M"  "DP05_0028PE" "DP05_0028PM" "DP05_0029E"  "DP05_0029M" 
## [361] "DP05_0029PE" "DP05_0029PM" "DP05_0030E"  "DP05_0030M"  "DP05_0030PE"
## [366] "DP05_0030PM" "DP05_0031E"  "DP05_0031M"  "DP05_0031PE" "geometry"

Task 5: Aggregate ACS Census to Zip

head(nyc_tracts_sf)
## Simple feature collection with 6 features and 369 fields
## Geometry type: MULTIPOLYGON
## Dimension:     XY
## Bounding box:  xmin: -74.08721 ymin: 40.63981 xmax: -73.96433 ymax: 40.76364
## Geodetic CRS:  WGS84(DD)
##   boro_code boro_ct201     boro_name cdeligibil ct2010 ctlabel ntacode
## 1         5    5000900 Staten Island          E 000900       9    SI22
## 2         1    1009800     Manhattan          I 009800      98    MN19
## 3         1    1010000     Manhattan          I 010000     100    MN19
## 4         1    1010200     Manhattan          I 010200     102    MN17
## 5         1    1010400     Manhattan          I 010400     104    MN17
## 6         1    1011300     Manhattan          I 011300     113    MN17
##                                     ntaname puma shape_area shape_leng GEO_ID
## 1 West New Brighton-New Brighton-St. George 3903    2497010   7729.017   <NA>
## 2                   Turtle Bay-East Midtown 3808    1906016   5534.200   <NA>
## 3                   Turtle Bay-East Midtown 3808    1860938   5692.169   <NA>
## 4                     Midtown-Midtown South 3807    1860993   5687.802   <NA>
## 5                     Midtown-Midtown South 3807    1864600   5693.036   <NA>
## 6                     Midtown-Midtown South 3807    1890907   5699.861   <NA>
##   NAME DP05_0031PM DP05_0032E DP05_0032M DP05_0032PE DP05_0032PM DP05_0033E
## 1 <NA>        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2 <NA>        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3 <NA>        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4 <NA>        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5 <NA>        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6 <NA>        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0033M DP05_0033PE DP05_0033PM DP05_0034E DP05_0034M DP05_0034PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0034PM DP05_0035E DP05_0035M DP05_0035PE DP05_0035PM DP05_0036E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0036M DP05_0036PE DP05_0036PM DP05_0037E DP05_0037M DP05_0037PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0037PM DP05_0038E DP05_0038M DP05_0038PE DP05_0038PM DP05_0039E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0039M DP05_0039PE DP05_0039PM DP05_0040E DP05_0040M DP05_0040PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0040PM DP05_0041E DP05_0041M DP05_0041PE DP05_0041PM DP05_0042E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0042M DP05_0042PE DP05_0042PM DP05_0043E DP05_0043M DP05_0043PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0043PM DP05_0044E DP05_0044M DP05_0044PE DP05_0044PM DP05_0045E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0045M DP05_0045PE DP05_0045PM DP05_0046E DP05_0046M DP05_0046PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0046PM DP05_0047E DP05_0047M DP05_0047PE DP05_0047PM DP05_0048E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0048M DP05_0048PE DP05_0048PM DP05_0049E DP05_0049M DP05_0049PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0049PM DP05_0050E DP05_0050M DP05_0050PE DP05_0050PM DP05_0051E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0051M DP05_0051PE DP05_0051PM DP05_0052E DP05_0052M DP05_0052PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0052PM DP05_0053E DP05_0053M DP05_0053PE DP05_0053PM DP05_0054E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0054M DP05_0054PE DP05_0054PM DP05_0055E DP05_0055M DP05_0055PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0055PM DP05_0056E DP05_0056M DP05_0056PE DP05_0056PM DP05_0057E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0057M DP05_0057PE DP05_0057PM DP05_0058E DP05_0058M DP05_0058PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0058PM DP05_0059E DP05_0059M DP05_0059PE DP05_0059PM DP05_0060E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0060M DP05_0060PE DP05_0060PM DP05_0061E DP05_0061M DP05_0061PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0061PM DP05_0062E DP05_0062M DP05_0062PE DP05_0062PM DP05_0063E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0063M DP05_0063PE DP05_0063PM DP05_0064E DP05_0064M DP05_0064PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0064PM DP05_0065E DP05_0065M DP05_0065PE DP05_0065PM DP05_0066E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0066M DP05_0066PE DP05_0066PM DP05_0067E DP05_0067M DP05_0067PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0067PM DP05_0068E DP05_0068M DP05_0068PE DP05_0068PM DP05_0069E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0069M DP05_0069PE DP05_0069PM DP05_0070E DP05_0070M DP05_0070PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0070PM DP05_0071E DP05_0071M DP05_0071PE DP05_0071PM DP05_0072E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0072M DP05_0072PE DP05_0072PM DP05_0073E DP05_0073M DP05_0073PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0073PM DP05_0074E DP05_0074M DP05_0074PE DP05_0074PM DP05_0075E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0075M DP05_0075PE DP05_0075PM DP05_0076E DP05_0076M DP05_0076PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0076PM DP05_0077E DP05_0077M DP05_0077PE DP05_0077PM DP05_0078E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0078M DP05_0078PE DP05_0078PM DP05_0079E DP05_0079M DP05_0079PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0079PM DP05_0080E DP05_0080M DP05_0080PE DP05_0080PM DP05_0081E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0081M DP05_0081PE DP05_0081PM DP05_0082E DP05_0082M DP05_0082PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0082PM DP05_0083E DP05_0083M DP05_0083PE DP05_0083PM DP05_0084E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0084M DP05_0084PE DP05_0084PM DP05_0085E DP05_0085M DP05_0085PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0085PM DP05_0086E DP05_0086M DP05_0086PE DP05_0086PM DP05_0087E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0087M DP05_0087PE DP05_0087PM DP05_0088E DP05_0088M DP05_0088PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0088PM DP05_0089E DP05_0089M DP05_0089PE DP05_0089PM DP05_0001E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0001M DP05_0001PE DP05_0001PM DP05_0002E DP05_0002M DP05_0002PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0002PM DP05_0003E DP05_0003M DP05_0003PE DP05_0003PM DP05_0004E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0004M DP05_0004PE DP05_0004PM DP05_0005E DP05_0005M DP05_0005PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0005PM DP05_0006E DP05_0006M DP05_0006PE DP05_0006PM DP05_0007E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0007M DP05_0007PE DP05_0007PM DP05_0008E DP05_0008M DP05_0008PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0008PM DP05_0009E DP05_0009M DP05_0009PE DP05_0009PM DP05_0010E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0010M DP05_0010PE DP05_0010PM DP05_0011E DP05_0011M DP05_0011PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0011PM DP05_0012E DP05_0012M DP05_0012PE DP05_0012PM DP05_0013E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0013M DP05_0013PE DP05_0013PM DP05_0014E DP05_0014M DP05_0014PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0014PM DP05_0015E DP05_0015M DP05_0015PE DP05_0015PM DP05_0016E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0016M DP05_0016PE DP05_0016PM DP05_0017E DP05_0017M DP05_0017PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0017PM DP05_0018E DP05_0018M DP05_0018PE DP05_0018PM DP05_0019E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0019M DP05_0019PE DP05_0019PM DP05_0020E DP05_0020M DP05_0020PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0020PM DP05_0021E DP05_0021M DP05_0021PE DP05_0021PM DP05_0022E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0022M DP05_0022PE DP05_0022PM DP05_0023E DP05_0023M DP05_0023PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0023PM DP05_0024E DP05_0024M DP05_0024PE DP05_0024PM DP05_0025E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0025M DP05_0025PE DP05_0025PM DP05_0026E DP05_0026M DP05_0026PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0026PM DP05_0027E DP05_0027M DP05_0027PE DP05_0027PM DP05_0028E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0028M DP05_0028PE DP05_0028PM DP05_0029E DP05_0029M DP05_0029PE
## 1       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 2       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 3       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 4       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 5       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
## 6       <NA>        <NA>        <NA>       <NA>       <NA>        <NA>
##   DP05_0029PM DP05_0030E DP05_0030M DP05_0030PE DP05_0030PM DP05_0031E
## 1        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 2        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 3        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 4        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 5        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
## 6        <NA>       <NA>       <NA>        <NA>        <NA>       <NA>
##   DP05_0031M DP05_0031PE                       geometry
## 1       <NA>        <NA> MULTIPOLYGON (((-74.07921 4...
## 2       <NA>        <NA> MULTIPOLYGON (((-73.96433 4...
## 3       <NA>        <NA> MULTIPOLYGON (((-73.96802 4...
## 4       <NA>        <NA> MULTIPOLYGON (((-73.97124 4...
## 5       <NA>        <NA> MULTIPOLYGON (((-73.97446 4...
## 6       <NA>        <NA> MULTIPOLYGON (((-73.98412 4...
names(nyc_tracts_sf)
##   [1] "boro_code"   "boro_ct201"  "boro_name"   "cdeligibil"  "ct2010"     
##   [6] "ctlabel"     "ntacode"     "ntaname"     "puma"        "shape_area" 
##  [11] "shape_leng"  "GEO_ID"      "NAME"        "DP05_0031PM" "DP05_0032E" 
##  [16] "DP05_0032M"  "DP05_0032PE" "DP05_0032PM" "DP05_0033E"  "DP05_0033M" 
##  [21] "DP05_0033PE" "DP05_0033PM" "DP05_0034E"  "DP05_0034M"  "DP05_0034PE"
##  [26] "DP05_0034PM" "DP05_0035E"  "DP05_0035M"  "DP05_0035PE" "DP05_0035PM"
##  [31] "DP05_0036E"  "DP05_0036M"  "DP05_0036PE" "DP05_0036PM" "DP05_0037E" 
##  [36] "DP05_0037M"  "DP05_0037PE" "DP05_0037PM" "DP05_0038E"  "DP05_0038M" 
##  [41] "DP05_0038PE" "DP05_0038PM" "DP05_0039E"  "DP05_0039M"  "DP05_0039PE"
##  [46] "DP05_0039PM" "DP05_0040E"  "DP05_0040M"  "DP05_0040PE" "DP05_0040PM"
##  [51] "DP05_0041E"  "DP05_0041M"  "DP05_0041PE" "DP05_0041PM" "DP05_0042E" 
##  [56] "DP05_0042M"  "DP05_0042PE" "DP05_0042PM" "DP05_0043E"  "DP05_0043M" 
##  [61] "DP05_0043PE" "DP05_0043PM" "DP05_0044E"  "DP05_0044M"  "DP05_0044PE"
##  [66] "DP05_0044PM" "DP05_0045E"  "DP05_0045M"  "DP05_0045PE" "DP05_0045PM"
##  [71] "DP05_0046E"  "DP05_0046M"  "DP05_0046PE" "DP05_0046PM" "DP05_0047E" 
##  [76] "DP05_0047M"  "DP05_0047PE" "DP05_0047PM" "DP05_0048E"  "DP05_0048M" 
##  [81] "DP05_0048PE" "DP05_0048PM" "DP05_0049E"  "DP05_0049M"  "DP05_0049PE"
##  [86] "DP05_0049PM" "DP05_0050E"  "DP05_0050M"  "DP05_0050PE" "DP05_0050PM"
##  [91] "DP05_0051E"  "DP05_0051M"  "DP05_0051PE" "DP05_0051PM" "DP05_0052E" 
##  [96] "DP05_0052M"  "DP05_0052PE" "DP05_0052PM" "DP05_0053E"  "DP05_0053M" 
## [101] "DP05_0053PE" "DP05_0053PM" "DP05_0054E"  "DP05_0054M"  "DP05_0054PE"
## [106] "DP05_0054PM" "DP05_0055E"  "DP05_0055M"  "DP05_0055PE" "DP05_0055PM"
## [111] "DP05_0056E"  "DP05_0056M"  "DP05_0056PE" "DP05_0056PM" "DP05_0057E" 
## [116] "DP05_0057M"  "DP05_0057PE" "DP05_0057PM" "DP05_0058E"  "DP05_0058M" 
## [121] "DP05_0058PE" "DP05_0058PM" "DP05_0059E"  "DP05_0059M"  "DP05_0059PE"
## [126] "DP05_0059PM" "DP05_0060E"  "DP05_0060M"  "DP05_0060PE" "DP05_0060PM"
## [131] "DP05_0061E"  "DP05_0061M"  "DP05_0061PE" "DP05_0061PM" "DP05_0062E" 
## [136] "DP05_0062M"  "DP05_0062PE" "DP05_0062PM" "DP05_0063E"  "DP05_0063M" 
## [141] "DP05_0063PE" "DP05_0063PM" "DP05_0064E"  "DP05_0064M"  "DP05_0064PE"
## [146] "DP05_0064PM" "DP05_0065E"  "DP05_0065M"  "DP05_0065PE" "DP05_0065PM"
## [151] "DP05_0066E"  "DP05_0066M"  "DP05_0066PE" "DP05_0066PM" "DP05_0067E" 
## [156] "DP05_0067M"  "DP05_0067PE" "DP05_0067PM" "DP05_0068E"  "DP05_0068M" 
## [161] "DP05_0068PE" "DP05_0068PM" "DP05_0069E"  "DP05_0069M"  "DP05_0069PE"
## [166] "DP05_0069PM" "DP05_0070E"  "DP05_0070M"  "DP05_0070PE" "DP05_0070PM"
## [171] "DP05_0071E"  "DP05_0071M"  "DP05_0071PE" "DP05_0071PM" "DP05_0072E" 
## [176] "DP05_0072M"  "DP05_0072PE" "DP05_0072PM" "DP05_0073E"  "DP05_0073M" 
## [181] "DP05_0073PE" "DP05_0073PM" "DP05_0074E"  "DP05_0074M"  "DP05_0074PE"
## [186] "DP05_0074PM" "DP05_0075E"  "DP05_0075M"  "DP05_0075PE" "DP05_0075PM"
## [191] "DP05_0076E"  "DP05_0076M"  "DP05_0076PE" "DP05_0076PM" "DP05_0077E" 
## [196] "DP05_0077M"  "DP05_0077PE" "DP05_0077PM" "DP05_0078E"  "DP05_0078M" 
## [201] "DP05_0078PE" "DP05_0078PM" "DP05_0079E"  "DP05_0079M"  "DP05_0079PE"
## [206] "DP05_0079PM" "DP05_0080E"  "DP05_0080M"  "DP05_0080PE" "DP05_0080PM"
## [211] "DP05_0081E"  "DP05_0081M"  "DP05_0081PE" "DP05_0081PM" "DP05_0082E" 
## [216] "DP05_0082M"  "DP05_0082PE" "DP05_0082PM" "DP05_0083E"  "DP05_0083M" 
## [221] "DP05_0083PE" "DP05_0083PM" "DP05_0084E"  "DP05_0084M"  "DP05_0084PE"
## [226] "DP05_0084PM" "DP05_0085E"  "DP05_0085M"  "DP05_0085PE" "DP05_0085PM"
## [231] "DP05_0086E"  "DP05_0086M"  "DP05_0086PE" "DP05_0086PM" "DP05_0087E" 
## [236] "DP05_0087M"  "DP05_0087PE" "DP05_0087PM" "DP05_0088E"  "DP05_0088M" 
## [241] "DP05_0088PE" "DP05_0088PM" "DP05_0089E"  "DP05_0089M"  "DP05_0089PE"
## [246] "DP05_0089PM" "DP05_0001E"  "DP05_0001M"  "DP05_0001PE" "DP05_0001PM"
## [251] "DP05_0002E"  "DP05_0002M"  "DP05_0002PE" "DP05_0002PM" "DP05_0003E" 
## [256] "DP05_0003M"  "DP05_0003PE" "DP05_0003PM" "DP05_0004E"  "DP05_0004M" 
## [261] "DP05_0004PE" "DP05_0004PM" "DP05_0005E"  "DP05_0005M"  "DP05_0005PE"
## [266] "DP05_0005PM" "DP05_0006E"  "DP05_0006M"  "DP05_0006PE" "DP05_0006PM"
## [271] "DP05_0007E"  "DP05_0007M"  "DP05_0007PE" "DP05_0007PM" "DP05_0008E" 
## [276] "DP05_0008M"  "DP05_0008PE" "DP05_0008PM" "DP05_0009E"  "DP05_0009M" 
## [281] "DP05_0009PE" "DP05_0009PM" "DP05_0010E"  "DP05_0010M"  "DP05_0010PE"
## [286] "DP05_0010PM" "DP05_0011E"  "DP05_0011M"  "DP05_0011PE" "DP05_0011PM"
## [291] "DP05_0012E"  "DP05_0012M"  "DP05_0012PE" "DP05_0012PM" "DP05_0013E" 
## [296] "DP05_0013M"  "DP05_0013PE" "DP05_0013PM" "DP05_0014E"  "DP05_0014M" 
## [301] "DP05_0014PE" "DP05_0014PM" "DP05_0015E"  "DP05_0015M"  "DP05_0015PE"
## [306] "DP05_0015PM" "DP05_0016E"  "DP05_0016M"  "DP05_0016PE" "DP05_0016PM"
## [311] "DP05_0017E"  "DP05_0017M"  "DP05_0017PE" "DP05_0017PM" "DP05_0018E" 
## [316] "DP05_0018M"  "DP05_0018PE" "DP05_0018PM" "DP05_0019E"  "DP05_0019M" 
## [321] "DP05_0019PE" "DP05_0019PM" "DP05_0020E"  "DP05_0020M"  "DP05_0020PE"
## [326] "DP05_0020PM" "DP05_0021E"  "DP05_0021M"  "DP05_0021PE" "DP05_0021PM"
## [331] "DP05_0022E"  "DP05_0022M"  "DP05_0022PE" "DP05_0022PM" "DP05_0023E" 
## [336] "DP05_0023M"  "DP05_0023PE" "DP05_0023PM" "DP05_0024E"  "DP05_0024M" 
## [341] "DP05_0024PE" "DP05_0024PM" "DP05_0025E"  "DP05_0025M"  "DP05_0025PE"
## [346] "DP05_0025PM" "DP05_0026E"  "DP05_0026M"  "DP05_0026PE" "DP05_0026PM"
## [351] "DP05_0027E"  "DP05_0027M"  "DP05_0027PE" "DP05_0027PM" "DP05_0028E" 
## [356] "DP05_0028M"  "DP05_0028PE" "DP05_0028PM" "DP05_0029E"  "DP05_0029M" 
## [361] "DP05_0029PE" "DP05_0029PM" "DP05_0030E"  "DP05_0030M"  "DP05_0030PE"
## [366] "DP05_0030PM" "DP05_0031E"  "DP05_0031M"  "DP05_0031PE" "geometry"
zip_health_proj <- st_transform(zip_health, st_crs(nyc_tracts_sf))

zip_final <- st_join(zip_health_proj, nyc_tracts_sf, left = TRUE)

zip_final <- zip_final %>%
  group_by(ZIPCODE) %>%
  summarize(
    nursinghome_count = first(nursinghome_count),
    retail_count = first(retail_count),
    COVID_CASE_COUNT = first(COVID_CASE_COUNT),
    COVID_CASE_RATE = first(COVID_CASE_RATE),
    POP_DENOMINATOR = first(POP_DENOMINATOR),
    COVID_DEATH_COUNT = first(COVID_DEATH_COUNT),
    COVID_DEATH_RATE = first(COVID_DEATH_RATE),
    PERCENT_POSITIVE = first(PERCENT_POSITIVE),
    TOTAL_COVID_TESTS = first(TOTAL_COVID_TESTS),
    PO_NAME = first(PO_NAME),
    COUNTY = first(COUNTY),
    
    total_population = sum(as.numeric(DP05_0001E), na.rm = TRUE),
    elderly_population = sum(as.numeric(DP05_0024E), na.rm = TRUE)
)

zip_final
## Simple feature collection with 247 features and 14 fields
## Geometry type: GEOMETRY
## Dimension:     XY
## Bounding box:  xmin: -74.25576 ymin: 40.49584 xmax: -73.6996 ymax: 40.91517
## Geodetic CRS:  WGS84(DD)
## # A tibble: 247 × 15
##    ZIPCODE nursinghome_count retail_count COVID_CASE_COUNT COVID_CASE_RATE
##    <chr>               <int>        <int>            <int>           <dbl>
##  1 10001                   0           16             1542           5584.
##  2 10002                   2           51             5902           7836.
##  3 10003                   0           27             2803           5193.
##  4 10004                   0            6              247           8311.
##  5 10005                   0            2              413           4716.
##  6 10006                   0            2              164           4849.
##  7 10007                   0            9              379           5421.
##  8 10009                   0           14             3605           6308.
##  9 10010                   0           14             1686           5055.
## 10 10011                   0           35             2542           5110.
## # ℹ 237 more rows
## # ℹ 10 more variables: POP_DENOMINATOR <dbl>, COVID_DEATH_COUNT <int>,
## #   COVID_DEATH_RATE <dbl>, PERCENT_POSITIVE <dbl>, TOTAL_COVID_TESTS <int>,
## #   PO_NAME <chr>, COUNTY <chr>, total_population <dbl>,
## #   elderly_population <dbl>, geometry <GEOMETRY [°]>
library(ggplot2)

ggplot(zip_final) +
  geom_sf(aes(fill = COVID_CASE_RATE)) +
  scale_fill_viridis_c() +
  labs(
    title = "Covid Case Rate by Zip Code in NYC",
    fill = "Case Rate"
  )