latest_ny_times_counties_with_populations (view)
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,131 rows sorted by cases_per_million
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Texas 254
- Georgia 159
- Virginia 133
- Kentucky 120
- Missouri 115
- Kansas 105
- Illinois 102
- North Carolina 100
- Iowa 99
- Tennessee 95
- Nebraska 93
- Indiana 92
- Ohio 88
- Minnesota 87
- Michigan 83
- Mississippi 82
- Oklahoma 77
- Arkansas 75
- Wisconsin 72
- Alabama 67
- Florida 67
- Pennsylvania 67
- South Dakota 65
- Colorado 64
- Louisiana 64
- California 58
- New York 57
- Montana 56
- West Virginia 55
- North Dakota 53
- …
date | county | state | fips | cases | deaths | population | deaths_per_million | cases_per_million ▼ |
---|---|---|---|---|---|---|---|---|
2022-05-13 | Kalawao | Hawaii | 15005 | 1 | 0 | 86 | 0 | 11627 |
2022-05-13 | Storey | Nevada | 32029 | 133 | 11 | 4123 | 2667 | 32258 |
2022-05-13 | Sioux | Nebraska | 31165 | 68 | 1 | 1166 | 857 | 58319 |
2022-05-13 | Arthur | Nebraska | 31005 | 31 | 1 | 463 | 2159 | 66954 |
2022-05-13 | Petroleum | Montana | 30069 | 35 | 1 | 487 | 2053 | 71868 |
2022-05-13 | Eureka | Nevada | 32011 | 165 | 2 | 2029 | 985 | 81320 |
2022-05-13 | San Juan | Washington | 53055 | 1450 | 2 | 17582 | 113 | 82470 |
2022-05-13 | Slope | North Dakota | 38087 | 63 | 0 | 750 | 0 | 84000 |
2022-05-13 | Fairfax city | Virginia | 51600 | 2056 | 43 | 24019 | 1790 | 85598 |
2022-05-13 | Cherry | Nebraska | 31031 | 546 | 10 | 5689 | 1757 | 95974 |
2022-05-13 | Jeff Davis | Texas | 48243 | 224 | 9 | 2274 | 3957 | 98504 |
2022-05-13 | Jefferson | Washington | 53031 | 3198 | 29 | 32221 | 900 | 99252 |
2022-05-13 | Newton | Texas | 48351 | 1367 | 61 | 13595 | 4486 | 100551 |
2022-05-13 | Platte | Missouri | 29165 | 10580 | 102 | 104418 | 976 | 101323 |
2022-05-13 | Harlan | Nebraska | 31083 | 348 | 3 | 3380 | 887 | 102958 |
2022-05-13 | Gaines | Texas | 48165 | 2215 | 83 | 21492 | 3861 | 103061 |
2022-05-13 | Hayes | Nebraska | 31085 | 96 | 0 | 922 | 0 | 104121 |
2022-05-13 | Lincoln | Nevada | 32017 | 550 | 7 | 5183 | 1350 | 106116 |
2022-05-13 | Sierra | California | 6091 | 324 | 4 | 3005 | 1331 | 107820 |
2022-05-13 | Cook | Minnesota | 27031 | 594 | 4 | 5463 | 732 | 108731 |
2022-05-13 | Clay | Missouri | 29047 | 27390 | 363 | 249948 | 1452 | 109582 |
2022-05-13 | Stanton | Nebraska | 31167 | 649 | 11 | 5920 | 1858 | 109628 |
2022-05-13 | Alpine | California | 6003 | 126 | 0 | 1129 | 0 | 111603 |
2022-05-13 | Judith Basin | Montana | 30045 | 225 | 1 | 2007 | 498 | 112107 |
2022-05-13 | Modoc | California | 6049 | 1000 | 8 | 8841 | 904 | 113109 |
2022-05-13 | Banner | Nebraska | 31007 | 87 | 2 | 745 | 2684 | 116778 |
2022-05-13 | Holmes | Ohio | 39075 | 5135 | 182 | 43960 | 4140 | 116810 |
2022-05-13 | Brewster | Texas | 48043 | 1079 | 29 | 9203 | 3151 | 117244 |
2022-05-13 | Sabine | Texas | 48403 | 1254 | 89 | 10542 | 8442 | 118952 |
2022-05-13 | Loup | Nebraska | 31115 | 79 | 0 | 664 | 0 | 118975 |
2022-05-13 | Catron | New Mexico | 35003 | 420 | 14 | 3527 | 3969 | 119081 |
2022-05-13 | Jackson | Colorado | 8057 | 166 | 0 | 1392 | 0 | 119252 |
2022-05-13 | Clatsop | Oregon | 41007 | 4810 | 50 | 40224 | 1243 | 119580 |
2022-05-13 | Wahkiakum | Washington | 53069 | 537 | 7 | 4488 | 1559 | 119652 |
2022-05-13 | Trinity | California | 6105 | 1485 | 20 | 12285 | 1628 | 120879 |
2022-05-13 | Williamsburg city | Virginia | 51830 | 1837 | 22 | 14954 | 1471 | 122843 |
2022-05-13 | Custer | Idaho | 16037 | 532 | 9 | 4315 | 2085 | 123290 |
2022-05-13 | Calvert | Maryland | 24009 | 11468 | 146 | 92525 | 1577 | 123944 |
2022-05-13 | Esmeralda | Nevada | 32009 | 109 | 3 | 873 | 3436 | 124856 |
2022-05-13 | Island | Washington | 53029 | 10635 | 76 | 85141 | 892 | 124910 |
2022-05-13 | Skamania | Washington | 53059 | 1531 | 12 | 12083 | 993 | 126706 |
2022-05-13 | Clark | Idaho | 16033 | 109 | 1 | 845 | 1183 | 128994 |
2022-05-13 | Custer | Colorado | 8027 | 656 | 21 | 5068 | 4143 | 129439 |
2022-05-13 | San Augustine | Texas | 48405 | 1082 | 44 | 8237 | 5341 | 131358 |
2022-05-13 | Carroll | Maryland | 24013 | 22141 | 409 | 168447 | 2428 | 131441 |
2022-05-13 | Rock | Nebraska | 31149 | 179 | 2 | 1357 | 1473 | 131908 |
2022-05-13 | Knox | Texas | 48275 | 492 | 25 | 3664 | 6823 | 134279 |
2022-05-13 | Harding | New Mexico | 35021 | 85 | 4 | 625 | 6400 | 136000 |
2022-05-13 | Thomas | Nebraska | 31171 | 99 | 1 | 722 | 1385 | 137119 |
2022-05-13 | Cumberland | Virginia | 51049 | 1366 | 27 | 9932 | 2718 | 137535 |
2022-05-13 | McPherson | Nebraska | 31117 | 68 | 1 | 494 | 2024 | 137651 |
2022-05-13 | Rich | Utah | 49033 | 343 | 0 | 2483 | 0 | 138139 |
2022-05-13 | Jackson | Missouri | 29095 | 97164 | 1217 | 703011 | 1731 | 138211 |
2022-05-13 | Franklin | Nebraska | 31061 | 413 | 12 | 2979 | 4028 | 138637 |
2022-05-13 | Scotland | Missouri | 29199 | 680 | 18 | 4902 | 3671 | 138718 |
2022-05-13 | Boise | Idaho | 16015 | 1094 | 14 | 7831 | 1787 | 139701 |
2022-05-13 | Blaine | Nebraska | 31009 | 65 | 3 | 465 | 6451 | 139784 |
2022-05-13 | Hawaii | Hawaii | 15001 | 28425 | 190 | 201513 | 942 | 141057 |
2022-05-13 | Glasscock | Texas | 48173 | 199 | 3 | 1409 | 2129 | 141234 |
2022-05-13 | Hardeman | Texas | 48197 | 556 | 19 | 3933 | 4830 | 141367 |
2022-05-13 | Tillamook | Oregon | 41057 | 3827 | 64 | 27036 | 2367 | 141552 |
2022-05-13 | Howard | Maryland | 24027 | 46124 | 378 | 325690 | 1160 | 141619 |
2022-05-13 | Rappahannock | Virginia | 51157 | 1051 | 10 | 7370 | 1356 | 142605 |
2022-05-13 | Camas | Idaho | 16025 | 158 | 2 | 1106 | 1808 | 142857 |
2022-05-13 | Long | Georgia | 13183 | 2801 | 35 | 19559 | 1789 | 143207 |
2022-05-13 | Crawford | Georgia | 13079 | 1780 | 55 | 12404 | 4434 | 143502 |
2022-05-13 | Queen Anne's | Maryland | 24035 | 7246 | 110 | 50381 | 2183 | 143824 |
2022-05-13 | Glades | Florida | 12043 | 1995 | 36 | 13811 | 2606 | 144450 |
2022-05-13 | Lincoln | Oregon | 41041 | 7223 | 85 | 49962 | 1701 | 144569 |
2022-05-13 | Hancock | Maine | 23009 | 7983 | 87 | 54987 | 1582 | 145179 |
2022-05-13 | Tolland | Connecticut | 9013 | 21898 | 275 | 150721 | 1824 | 145288 |
2022-05-13 | Washington | Maine | 23029 | 4585 | 57 | 31379 | 1816 | 146116 |
2022-05-13 | Rockbridge | Virginia | 51163 | 3300 | 79 | 22573 | 3499 | 146192 |
2022-05-13 | Rains | Texas | 48379 | 1839 | 59 | 12514 | 4714 | 146955 |
2022-05-13 | Keya Paha | Nebraska | 31103 | 119 | 0 | 806 | 0 | 147642 |
2022-05-13 | Curry | Oregon | 41015 | 3385 | 54 | 22925 | 2355 | 147655 |
2022-05-13 | LaGrange | Indiana | 18087 | 5871 | 102 | 39614 | 2574 | 148205 |
2022-05-13 | Gilliam | Oregon | 41021 | 284 | 5 | 1912 | 2615 | 148535 |
2022-05-13 | Yates | New York | 36123 | 3704 | 40 | 24913 | 1605 | 148677 |
2022-05-13 | Los Alamos | New Mexico | 35028 | 2880 | 16 | 19369 | 826 | 148691 |
2022-05-13 | Presidio | Texas | 48377 | 998 | 38 | 6704 | 5668 | 148866 |
2022-05-13 | Humboldt | Nevada | 32013 | 2508 | 54 | 16831 | 3208 | 149010 |
2022-05-13 | York | Virginia | 51199 | 10189 | 109 | 68280 | 1596 | 149223 |
2022-05-13 | Marin | California | 6041 | 38685 | 293 | 258826 | 1132 | 149463 |
2022-05-13 | Yoakum | Texas | 48501 | 1317 | 42 | 8713 | 4820 | 151153 |
2022-05-13 | Washington | Oregon | 41067 | 91092 | 594 | 601592 | 987 | 151418 |
2022-05-13 | Douglas | Nevada | 32005 | 7410 | 92 | 48905 | 1881 | 151518 |
2022-05-13 | Cherokee | Texas | 48073 | 7989 | 254 | 52646 | 4824 | 151749 |
2022-05-13 | Bear Lake | Idaho | 16007 | 931 | 16 | 6125 | 2612 | 152000 |
2022-05-13 | Falls Church city | Virginia | 51610 | 2226 | 17 | 14617 | 1163 | 152288 |
2022-05-13 | Multnomah | Oregon | 41051 | 123906 | 1207 | 812855 | 1484 | 152433 |
2022-05-13 | Columbia | Oregon | 41009 | 7987 | 95 | 52354 | 1814 | 152557 |
2022-05-13 | Clackamas | Oregon | 41005 | 63827 | 632 | 418187 | 1511 | 152627 |
2022-05-13 | Kitsap | Washington | 53035 | 41506 | 344 | 271473 | 1267 | 152891 |
2022-05-13 | Borden | Texas | 48033 | 100 | 2 | 654 | 3058 | 152905 |
2022-05-13 | Orange | Vermont | 50017 | 4420 | 14 | 28892 | 484 | 152983 |
2022-05-13 | Talbot | Maryland | 24041 | 5702 | 88 | 37181 | 2366 | 153357 |
2022-05-13 | Polk | Texas | 48373 | 7896 | 247 | 51353 | 4809 | 153759 |
2022-05-13 | Columbia | Washington | 53013 | 613 | 16 | 3985 | 4015 | 153826 |
2022-05-13 | Clallam | Washington | 53009 | 11901 | 141 | 77331 | 1823 | 153896 |
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;