latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
24 rows where state = "Maryland" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Maryland · 24 ✖
date | county ▼ | state | fips | cases | deaths | population | deaths_per_million | cases_per_million |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Allegany | Maryland | 24001 | 17291 | 362 | 70416 | 5140 | 245554 |
2022-05-13 | Anne Arundel | Maryland | 24003 | 92830 | 1078 | 579234 | 1861 | 160263 |
2022-05-13 | Baltimore | Maryland | 24005 | 136295 | 2484 | 827370 | 3002 | 164732 |
2022-05-13 | Baltimore city | Maryland | 24510 | 116724 | 1777 | 593490 | 2994 | 196673 |
2022-05-13 | Calvert | Maryland | 24009 | 11468 | 146 | 92525 | 1577 | 123944 |
2022-05-13 | Caroline | Maryland | 24011 | 6159 | 80 | 33406 | 2394 | 184368 |
2022-05-13 | Carroll | Maryland | 24013 | 22141 | 409 | 168447 | 2428 | 131441 |
2022-05-13 | Cecil | Maryland | 24015 | 15906 | 259 | 102855 | 2518 | 154644 |
2022-05-13 | Charles | Maryland | 24017 | 28950 | 353 | 163257 | 2162 | 177327 |
2022-05-13 | Dorchester | Maryland | 24019 | 7819 | 108 | 31929 | 3382 | 244887 |
2022-05-13 | Frederick | Maryland | 24021 | 46920 | 525 | 259547 | 2022 | 180776 |
2022-05-13 | Garrett | Maryland | 24023 | 5761 | 116 | 29014 | 3998 | 198559 |
2022-05-13 | Harford | Maryland | 24025 | 39423 | 582 | 255441 | 2278 | 154333 |
2022-05-13 | Howard | Maryland | 24027 | 46124 | 378 | 325690 | 1160 | 141619 |
2022-05-13 | Kent | Maryland | 24029 | 3122 | 66 | 19422 | 3398 | 160745 |
2022-05-13 | Montgomery | Maryland | 24031 | 178052 | 2044 | 1050688 | 1945 | 169462 |
2022-05-13 | Prince George's | Maryland | 24033 | 175401 | 2163 | 909327 | 2378 | 192891 |
2022-05-13 | Queen Anne's | Maryland | 24035 | 7246 | 110 | 50381 | 2183 | 143824 |
2022-05-13 | Somerset | Maryland | 24039 | 5267 | 74 | 25616 | 2888 | 205613 |
2022-05-13 | St. Mary's | Maryland | 24037 | 19329 | 217 | 113510 | 1911 | 170284 |
2022-05-13 | Talbot | Maryland | 24041 | 5702 | 88 | 37181 | 2366 | 153357 |
2022-05-13 | Washington | Maryland | 24043 | 35434 | 586 | 151049 | 3879 | 234586 |
2022-05-13 | Wicomico | Maryland | 24045 | 20013 | 328 | 103609 | 3165 | 193158 |
2022-05-13 | Worcester | Maryland | 24047 | 8826 | 160 | 52276 | 3060 | 168834 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW latest_ny_times_counties_with_populations AS select ny_times_us_counties.date, ny_times_us_counties.county, ny_times_us_counties.state, ny_times_us_counties.fips, ny_times_us_counties.cases, ny_times_us_counties.deaths, us_census_county_populations_2019.population, 1000000 * ny_times_us_counties.deaths / us_census_county_populations_2019.population as deaths_per_million, 1000000 * ny_times_us_counties.cases / us_census_county_populations_2019.population as cases_per_million from ny_times_us_counties join us_census_county_populations_2019 on ny_times_us_counties.fips = us_census_county_populations_2019.fips where "date" = ( select max(date) from ny_times_us_counties ) order by deaths_per_million desc;