ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
2,502,832 rows sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 191,736
- Georgia 123,609
- Virginia 102,197
- Kentucky 91,612
- Missouri 88,764
- Illinois 78,678
- Kansas 78,446
- North Carolina 77,109
- Iowa 76,270
- Tennessee 74,047
- Indiana 71,177
- Nebraska 68,597
- Ohio 68,478
- Minnesota 67,179
- Michigan 64,530
- Mississippi 63,484
- Oklahoma 59,377
- Arkansas 58,424
- Puerto Rico 57,844
- Wisconsin 55,489
- Florida 52,818
- Pennsylvania 51,972
- Alabama 51,776
- Louisiana 50,382
- South Dakota 49,090
- Colorado 49,015
- New York 45,286
- California 45,229
- West Virginia 41,853
- Montana 40,264
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2478288 | 2478288 | 2022-05-06 | Carter | Missouri | 29035 | 1500 | 24 |
2478289 | 2478289 | 2022-05-06 | Cass | Missouri | 29037 | 25185 | 315 |
2478290 | 2478290 | 2022-05-06 | Cedar | Missouri | 29039 | 2932 | 57 |
2478291 | 2478291 | 2022-05-06 | Chariton | Missouri | 29041 | 1717 | 38 |
2478292 | 2478292 | 2022-05-06 | Christian | Missouri | 29043 | 20920 | 262 |
2478293 | 2478293 | 2022-05-06 | Clark | Missouri | 29045 | 1593 | 37 |
2478294 | 2478294 | 2022-05-06 | Clay | Missouri | 29047 | 27246 | 361 |
2478295 | 2478295 | 2022-05-06 | Clinton | Missouri | 29049 | 4818 | 119 |
2478296 | 2478296 | 2022-05-06 | Cole | Missouri | 29051 | 20170 | 286 |
2478297 | 2478297 | 2022-05-06 | Cooper | Missouri | 29053 | 4133 | 77 |
2478298 | 2478298 | 2022-05-06 | Crawford | Missouri | 29055 | 5393 | 102 |
2478299 | 2478299 | 2022-05-06 | Dade | Missouri | 29057 | 1447 | 42 |
2478300 | 2478300 | 2022-05-06 | Dallas | Missouri | 29059 | 3819 | 72 |
2478301 | 2478301 | 2022-05-06 | Daviess | Missouri | 29061 | 1727 | 29 |
2478302 | 2478302 | 2022-05-06 | DeKalb | Missouri | 29063 | 2216 | 47 |
2478303 | 2478303 | 2022-05-06 | Dent | Missouri | 29065 | 3257 | 83 |
2478304 | 2478304 | 2022-05-06 | Douglas | Missouri | 29067 | 2551 | 80 |
2478305 | 2478305 | 2022-05-06 | Dunklin | Missouri | 29069 | 7763 | 117 |
2478306 | 2478306 | 2022-05-06 | Franklin | Missouri | 29071 | 25741 | 372 |
2478307 | 2478307 | 2022-05-06 | Gasconade | Missouri | 29073 | 3366 | 102 |
2478308 | 2478308 | 2022-05-06 | Gentry | Missouri | 29075 | 2168 | 31 |
2478309 | 2478309 | 2022-05-06 | Greene | Missouri | 29077 | 71557 | 1038 |
2478310 | 2478310 | 2022-05-06 | Grundy | Missouri | 29079 | 2533 | 69 |
2478311 | 2478311 | 2022-05-06 | Harrison | Missouri | 29081 | 1869 | 33 |
2478312 | 2478312 | 2022-05-06 | Henry | Missouri | 29083 | 5750 | 86 |
2478313 | 2478313 | 2022-05-06 | Hickory | Missouri | 29085 | 1838 | 56 |
2478314 | 2478314 | 2022-05-06 | Holt | Missouri | 29087 | 1058 | 30 |
2478315 | 2478315 | 2022-05-06 | Howard | Missouri | 29089 | 2505 | 30 |
2478316 | 2478316 | 2022-05-06 | Howell | Missouri | 29091 | 9165 | 214 |
2478317 | 2478317 | 2022-05-06 | Iron | Missouri | 29093 | 2198 | 44 |
2478318 | 2478318 | 2022-05-06 | Jackson | Missouri | 29095 | 96783 | 1215 |
2478319 | 2478319 | 2022-05-06 | Jasper | Missouri | 29097 | 20847 | 317 |
2478320 | 2478320 | 2022-05-06 | Jefferson | Missouri | 29099 | 54230 | 651 |
2478321 | 2478321 | 2022-05-06 | Johnson | Missouri | 29101 | 12206 | 143 |
2478322 | 2478322 | 2022-05-06 | Joplin | Missouri | 13738 | 219 | |
2478323 | 2478323 | 2022-05-06 | Kansas City | Missouri | 114124 | 1306 | |
2478324 | 2478324 | 2022-05-06 | Knox | Missouri | 29103 | 989 | 14 |
2478325 | 2478325 | 2022-05-06 | Laclede | Missouri | 29105 | 8089 | 176 |
2478326 | 2478326 | 2022-05-06 | Lafayette | Missouri | 29107 | 7814 | 133 |
2478327 | 2478327 | 2022-05-06 | Lawrence | Missouri | 29109 | 7789 | 164 |
2478328 | 2478328 | 2022-05-06 | Lewis | Missouri | 29111 | 2788 | 36 |
2478329 | 2478329 | 2022-05-06 | Lincoln | Missouri | 29113 | 15152 | 138 |
2478330 | 2478330 | 2022-05-06 | Linn | Missouri | 29115 | 2554 | 64 |
2478331 | 2478331 | 2022-05-06 | Livingston | Missouri | 29117 | 3743 | 96 |
2478332 | 2478332 | 2022-05-06 | Macon | Missouri | 29121 | 3645 | 58 |
2478333 | 2478333 | 2022-05-06 | Madison | Missouri | 29123 | 3615 | 57 |
2478334 | 2478334 | 2022-05-06 | Maries | Missouri | 29125 | 1605 | 39 |
2478335 | 2478335 | 2022-05-06 | Marion | Missouri | 29127 | 7989 | 118 |
2478336 | 2478336 | 2022-05-06 | McDonald | Missouri | 29119 | 5809 | 73 |
2478337 | 2478337 | 2022-05-06 | Mercer | Missouri | 29129 | 704 | 14 |
2478338 | 2478338 | 2022-05-06 | Miller | Missouri | 29131 | 6117 | 123 |
2478339 | 2478339 | 2022-05-06 | Mississippi | Missouri | 29133 | 3514 | 59 |
2478340 | 2478340 | 2022-05-06 | Moniteau | Missouri | 29135 | 3832 | 57 |
2478341 | 2478341 | 2022-05-06 | Monroe | Missouri | 29137 | 2179 | 43 |
2478342 | 2478342 | 2022-05-06 | Montgomery | Missouri | 29139 | 2516 | 57 |
2478343 | 2478343 | 2022-05-06 | Morgan | Missouri | 29141 | 4048 | 115 |
2478344 | 2478344 | 2022-05-06 | New Madrid | Missouri | 29143 | 5029 | 86 |
2478345 | 2478345 | 2022-05-06 | Newton | Missouri | 29145 | 11753 | 206 |
2478346 | 2478346 | 2022-05-06 | Nodaway | Missouri | 29147 | 6077 | 44 |
2478347 | 2478347 | 2022-05-06 | Oregon | Missouri | 29149 | 2024 | 33 |
2478348 | 2478348 | 2022-05-06 | Osage | Missouri | 29151 | 3226 | 46 |
2478349 | 2478349 | 2022-05-06 | Ozark | Missouri | 29153 | 1732 | 57 |
2478350 | 2478350 | 2022-05-06 | Pemiscot | Missouri | 29155 | 3013 | 74 |
2478351 | 2478351 | 2022-05-06 | Perry | Missouri | 29157 | 5045 | 46 |
2478352 | 2478352 | 2022-05-06 | Pettis | Missouri | 29159 | 12381 | 167 |
2478353 | 2478353 | 2022-05-06 | Phelps | Missouri | 29161 | 10268 | 243 |
2478354 | 2478354 | 2022-05-06 | Pike | Missouri | 29163 | 4263 | 63 |
2478355 | 2478355 | 2022-05-06 | Platte | Missouri | 29165 | 10520 | 102 |
2478356 | 2478356 | 2022-05-06 | Polk | Missouri | 29167 | 8064 | 108 |
2478357 | 2478357 | 2022-05-06 | Pulaski | Missouri | 29169 | 8894 | 116 |
2478358 | 2478358 | 2022-05-06 | Putnam | Missouri | 29171 | 1013 | 24 |
2478359 | 2478359 | 2022-05-06 | Ralls | Missouri | 29173 | 2463 | 28 |
2478360 | 2478360 | 2022-05-06 | Randolph | Missouri | 29175 | 6049 | 103 |
2478361 | 2478361 | 2022-05-06 | Ray | Missouri | 29177 | 5204 | 94 |
2478362 | 2478362 | 2022-05-06 | Reynolds | Missouri | 29179 | 1165 | 25 |
2478363 | 2478363 | 2022-05-06 | Ripley | Missouri | 29181 | 2695 | 61 |
2478364 | 2478364 | 2022-05-06 | Saline | Missouri | 29195 | 6272 | 107 |
2478365 | 2478365 | 2022-05-06 | Schuyler | Missouri | 29197 | 739 | 26 |
2478366 | 2478366 | 2022-05-06 | Scotland | Missouri | 29199 | 680 | 18 |
2478367 | 2478367 | 2022-05-06 | Scott | Missouri | 29201 | 11122 | 161 |
2478368 | 2478368 | 2022-05-06 | Shannon | Missouri | 29203 | 1609 | 40 |
2478369 | 2478369 | 2022-05-06 | Shelby | Missouri | 29205 | 1598 | 15 |
2478370 | 2478370 | 2022-05-06 | St. Charles | Missouri | 29183 | 103236 | 937 |
2478371 | 2478371 | 2022-05-06 | St. Clair | Missouri | 29185 | 2101 | 36 |
2478372 | 2478372 | 2022-05-06 | St. Francois | Missouri | 29187 | 19092 | 295 |
2478373 | 2478373 | 2022-05-06 | St. Louis | Missouri | 29189 | 225360 | 3342 |
2478374 | 2478374 | 2022-05-06 | St. Louis city | Missouri | 29510 | 57625 | 779 |
2478375 | 2478375 | 2022-05-06 | Ste. Genevieve | Missouri | 29186 | 3671 | 39 |
2478376 | 2478376 | 2022-05-06 | Stoddard | Missouri | 29207 | 6132 | 130 |
2478377 | 2478377 | 2022-05-06 | Stone | Missouri | 29209 | 5805 | 122 |
2478378 | 2478378 | 2022-05-06 | Sullivan | Missouri | 29211 | 1715 | 22 |
2478379 | 2478379 | 2022-05-06 | Taney | Missouri | 29213 | 13369 | 226 |
2478380 | 2478380 | 2022-05-06 | Texas | Missouri | 29215 | 4728 | 102 |
2478381 | 2478381 | 2022-05-06 | Vernon | Missouri | 29217 | 5100 | 109 |
2478382 | 2478382 | 2022-05-06 | Warren | Missouri | 29219 | 8173 | 102 |
2478383 | 2478383 | 2022-05-06 | Washington | Missouri | 29221 | 6023 | 141 |
2478384 | 2478384 | 2022-05-06 | Wayne | Missouri | 29223 | 2406 | 53 |
2478385 | 2478385 | 2022-05-06 | Webster | Missouri | 29225 | 9044 | 148 |
2478386 | 2478386 | 2022-05-06 | Worth | Missouri | 29227 | 407 | 3 |
2478387 | 2478387 | 2022-05-06 | Wright | Missouri | 29229 | 3843 | 84 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);