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 fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 | Navajo | Arizona | 4017 | 38394 | 909 | 110924 | 8194 | 346128 |
2022-05-13 | Pima | Arizona | 4019 | 255688 | 3850 | 1047279 | 3676 | 244145 |
2022-05-13 | Pinal | Arizona | 4021 | 132748 | 1666 | 462789 | 3599 | 286843 |
2022-05-13 | Santa Cruz | Arizona | 4023 | 16683 | 232 | 46498 | 4989 | 358789 |
2022-05-13 | Yavapai | Arizona | 4025 | 48293 | 1212 | 235099 | 5155 | 205415 |
2022-05-13 | Yuma | Arizona | 4027 | 62751 | 1181 | 213787 | 5524 | 293521 |
2022-05-13 | Arkansas | Arkansas | 5001 | 5696 | 79 | 17486 | 4517 | 325746 |
2022-05-13 | Ashley | Arkansas | 5003 | 5115 | 66 | 19657 | 3357 | 260212 |
2022-05-13 | Baxter | Arkansas | 5005 | 8848 | 247 | 41932 | 5890 | 211008 |
2022-05-13 | Benton | Arkansas | 5007 | 67110 | 849 | 279141 | 3041 | 240416 |
2022-05-13 | Boone | Arkansas | 5009 | 9468 | 179 | 37432 | 4782 | 252938 |
2022-05-13 | Bradley | Arkansas | 5011 | 2997 | 49 | 10763 | 4552 | 278453 |
2022-05-13 | Calhoun | Arkansas | 5013 | 965 | 10 | 5189 | 1927 | 185970 |
2022-05-13 | Carroll | Arkansas | 5015 | 6138 | 102 | 28380 | 3594 | 216279 |
2022-05-13 | Chicot | Arkansas | 5017 | 2778 | 60 | 10118 | 5930 | 274560 |
2022-05-13 | Clark | Arkansas | 5019 | 5379 | 79 | 22320 | 3539 | 240994 |
2022-05-13 | Clay | Arkansas | 5021 | 4154 | 93 | 14551 | 6391 | 285478 |
2022-05-13 | Cleburne | Arkansas | 5023 | 6466 | 128 | 24919 | 5136 | 259480 |
2022-05-13 | Cleveland | Arkansas | 5025 | 2269 | 36 | 7956 | 4524 | 285193 |
2022-05-13 | Columbia | Arkansas | 5027 | 5438 | 95 | 23457 | 4049 | 231828 |
2022-05-13 | Conway | Arkansas | 5029 | 5491 | 65 | 20846 | 3118 | 263407 |
2022-05-13 | Craighead | Arkansas | 5031 | 37767 | 329 | 110332 | 2981 | 342303 |
2022-05-13 | Crawford | Arkansas | 5033 | 15884 | 249 | 63257 | 3936 | 251102 |
2022-05-13 | Crittenden | Arkansas | 5035 | 14315 | 226 | 47955 | 4712 | 298509 |
2022-05-13 | Cross | Arkansas | 5037 | 4835 | 83 | 16419 | 5055 | 294475 |
2022-05-13 | Dallas | Arkansas | 5039 | 1747 | 31 | 7009 | 4422 | 249250 |
2022-05-13 | Desha | Arkansas | 5041 | 3030 | 41 | 11361 | 3608 | 266701 |
2022-05-13 | Drew | Arkansas | 5043 | 4686 | 70 | 18219 | 3842 | 257204 |
2022-05-13 | Faulkner | Arkansas | 5045 | 35251 | 316 | 126007 | 2507 | 279754 |
2022-05-13 | Franklin | Arkansas | 5047 | 3818 | 73 | 17715 | 4120 | 215523 |
2022-05-13 | Fulton | Arkansas | 5049 | 2696 | 90 | 12477 | 7213 | 216077 |
2022-05-13 | Garland | Arkansas | 5051 | 23359 | 510 | 99386 | 5131 | 235033 |
2022-05-13 | Grant | Arkansas | 5053 | 4468 | 61 | 18265 | 3339 | 244620 |
2022-05-13 | Greene | Arkansas | 5055 | 16088 | 173 | 45325 | 3816 | 354947 |
2022-05-13 | Hempstead | Arkansas | 5057 | 4571 | 68 | 21532 | 3158 | 212288 |
2022-05-13 | Hot Spring | Arkansas | 5059 | 11237 | 136 | 33771 | 4027 | 332741 |
2022-05-13 | Howard | Arkansas | 5061 | 3763 | 50 | 13202 | 3787 | 285032 |
2022-05-13 | Independence | Arkansas | 5063 | 10639 | 212 | 37825 | 5604 | 281269 |
2022-05-13 | Izard | Arkansas | 5065 | 3906 | 70 | 13629 | 5136 | 286594 |
2022-05-13 | Jackson | Arkansas | 5067 | 6135 | 63 | 16719 | 3768 | 366947 |
2022-05-13 | Jefferson | Arkansas | 5069 | 18608 | 277 | 66824 | 4145 | 278462 |
2022-05-13 | Johnson | Arkansas | 5071 | 6830 | 87 | 26578 | 3273 | 256979 |
2022-05-13 | Lafayette | Arkansas | 5073 | 1298 | 31 | 6624 | 4679 | 195954 |
2022-05-13 | Lawrence | Arkansas | 5075 | 5324 | 78 | 16406 | 4754 | 324515 |
2022-05-13 | Lee | Arkansas | 5077 | 2912 | 59 | 8857 | 6661 | 328779 |
2022-05-13 | Lincoln | Arkansas | 5079 | 4920 | 68 | 13024 | 5221 | 377764 |
2022-05-13 | Little River | Arkansas | 5081 | 3281 | 104 | 12259 | 8483 | 267640 |
2022-05-13 | Logan | Arkansas | 5083 | 5130 | 80 | 21466 | 3726 | 238982 |
2022-05-13 | Lonoke | Arkansas | 5085 | 19951 | 243 | 73309 | 3314 | 272149 |
2022-05-13 | Madison | Arkansas | 5087 | 3975 | 61 | 16576 | 3680 | 239804 |
2022-05-13 | Marion | Arkansas | 5089 | 3409 | 88 | 16694 | 5271 | 204205 |
2022-05-13 | Miller | Arkansas | 5091 | 9596 | 181 | 43257 | 4184 | 221836 |
2022-05-13 | Mississippi | Arkansas | 5093 | 13608 | 210 | 40651 | 5165 | 334751 |
2022-05-13 | Monroe | Arkansas | 5095 | 1936 | 35 | 6701 | 5223 | 288912 |
2022-05-13 | Montgomery | Arkansas | 5097 | 1525 | 57 | 8986 | 6343 | 169708 |
2022-05-13 | Nevada | Arkansas | 5099 | 2188 | 46 | 8252 | 5574 | 265147 |
2022-05-13 | Newton | Arkansas | 5101 | 1719 | 47 | 7753 | 6062 | 221720 |
2022-05-13 | Ouachita | Arkansas | 5103 | 5484 | 104 | 23382 | 4447 | 234539 |
2022-05-13 | Perry | Arkansas | 5105 | 2523 | 37 | 10455 | 3538 | 241319 |
2022-05-13 | Phillips | Arkansas | 5107 | 4829 | 99 | 17782 | 5567 | 271566 |
2022-05-13 | Pike | Arkansas | 5109 | 2617 | 44 | 10718 | 4105 | 244168 |
2022-05-13 | Poinsett | Arkansas | 5111 | 8052 | 127 | 23528 | 5397 | 342230 |
2022-05-13 | Polk | Arkansas | 5113 | 4146 | 149 | 19964 | 7463 | 207673 |
2022-05-13 | Pope | Arkansas | 5115 | 18455 | 210 | 64072 | 3277 | 288035 |
2022-05-13 | Prairie | Arkansas | 5117 | 1965 | 43 | 8062 | 5333 | 243736 |
2022-05-13 | Pulaski | Arkansas | 5119 | 103939 | 1186 | 391911 | 3026 | 265210 |
2022-05-13 | Randolph | Arkansas | 5121 | 5217 | 89 | 17958 | 4956 | 290511 |
2022-05-13 | St. Francis | Arkansas | 5123 | 7170 | 96 | 24994 | 3840 | 286868 |
2022-05-13 | Saline | Arkansas | 5125 | 31019 | 339 | 122437 | 2768 | 253346 |
2022-05-13 | Scott | Arkansas | 5127 | 2299 | 43 | 10281 | 4182 | 223616 |
2022-05-13 | Searcy | Arkansas | 5129 | 2126 | 48 | 7881 | 6090 | 269762 |
2022-05-13 | Sebastian | Arkansas | 5131 | 32837 | 526 | 127827 | 4114 | 256886 |
2022-05-13 | Sevier | Arkansas | 5133 | 5943 | 75 | 17007 | 4409 | 349444 |
2022-05-13 | Sharp | Arkansas | 5135 | 4640 | 105 | 17442 | 6019 | 266024 |
2022-05-13 | Stone | Arkansas | 5137 | 2918 | 68 | 12506 | 5437 | 233328 |
2022-05-13 | Union | Arkansas | 5139 | 9268 | 176 | 38682 | 4549 | 239594 |
2022-05-13 | Van Buren | Arkansas | 5141 | 3489 | 62 | 16545 | 3747 | 210879 |
2022-05-13 | Washington | Arkansas | 5143 | 68841 | 620 | 239187 | 2592 | 287812 |
2022-05-13 | White | Arkansas | 5145 | 22164 | 292 | 78753 | 3707 | 281436 |
2022-05-13 | Woodruff | Arkansas | 5147 | 1732 | 31 | 6320 | 4905 | 274050 |
2022-05-13 | Yell | Arkansas | 5149 | 6859 | 106 | 21341 | 4966 | 321400 |
2022-05-13 | Alameda | California | 6001 | 284054 | 1868 | 1671329 | 1117 | 169956 |
2022-05-13 | Alpine | California | 6003 | 126 | 0 | 1129 | 0 | 111603 |
2022-05-13 | Amador | California | 6005 | 9242 | 86 | 39752 | 2163 | 232491 |
2022-05-13 | Butte | California | 6007 | 40181 | 424 | 219186 | 1934 | 183319 |
2022-05-13 | Calaveras | California | 6009 | 7754 | 120 | 45905 | 2614 | 168914 |
2022-05-13 | Colusa | California | 6011 | 4549 | 21 | 21547 | 974 | 211119 |
2022-05-13 | Contra Costa | California | 6013 | 209958 | 1301 | 1153526 | 1127 | 182014 |
2022-05-13 | Del Norte | California | 6015 | 6381 | 50 | 27812 | 1797 | 229433 |
2022-05-13 | El Dorado | California | 6017 | 30508 | 212 | 192843 | 1099 | 158201 |
2022-05-13 | Fresno | California | 6019 | 257611 | 2757 | 999101 | 2759 | 257842 |
2022-05-13 | Glenn | California | 6021 | 6631 | 67 | 28393 | 2359 | 233543 |
2022-05-13 | Humboldt | California | 6023 | 20952 | 146 | 135558 | 1077 | 154561 |
2022-05-13 | Imperial | California | 6025 | 66715 | 916 | 181215 | 5054 | 368153 |
2022-05-13 | Inyo | California | 6027 | 4636 | 56 | 18039 | 3104 | 256998 |
2022-05-13 | Kern | California | 6029 | 244681 | 2427 | 900202 | 2696 | 271806 |
2022-05-13 | Kings | California | 6031 | 55429 | 447 | 152940 | 2922 | 362423 |
2022-05-13 | Lake | California | 6033 | 11699 | 137 | 64386 | 2127 | 181700 |
2022-05-13 | Lassen | California | 6035 | 10751 | 69 | 30573 | 2256 | 351650 |
2022-05-13 | Los Angeles | California | 6037 | 2908425 | 32022 | 10039107 | 3189 | 289709 |
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;