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 82,750
- Georgia 54,969
- Virginia 45,132
- Kentucky 40,132
- Missouri 38,535
- Illinois 34,491
- North Carolina 34,209
- Iowa 33,370
- Kansas 33,327
- Tennessee 32,863
- Indiana 31,682
- Ohio 30,298
- Minnesota 29,427
- Michigan 28,494
- Nebraska 28,349
- Mississippi 28,256
- Oklahoma 25,915
- Arkansas 25,820
- Wisconsin 24,599
- Puerto Rico 23,953
- Florida 23,646
- Pennsylvania 23,229
- Alabama 23,033
- Louisiana 22,498
- Colorado 21,559
- South Dakota 20,776
- New York 20,404
- California 20,339
- West Virginia 18,256
- North Dakota 16,955
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1084265 | 1084265 | 2021-03-03 | Kansas City | Missouri | 36729 | 525 | |
1084266 | 1084266 | 2021-03-03 | Knox | Missouri | 29103 | 179 | 2 |
1084267 | 1084267 | 2021-03-03 | Laclede | Missouri | 29105 | 2926 | 66 |
1084268 | 1084268 | 2021-03-03 | Lafayette | Missouri | 29107 | 2573 | 56 |
1084269 | 1084269 | 2021-03-03 | Lawrence | Missouri | 29109 | 2763 | 76 |
1084270 | 1084270 | 2021-03-03 | Lewis | Missouri | 29111 | 631 | 10 |
1084271 | 1084271 | 2021-03-03 | Lincoln | Missouri | 29113 | 4303 | 39 |
1084272 | 1084272 | 2021-03-03 | Linn | Missouri | 29115 | 545 | 12 |
1084273 | 1084273 | 2021-03-03 | Livingston | Missouri | 29117 | 1331 | 37 |
1084274 | 1084274 | 2021-03-03 | Macon | Missouri | 29121 | 1213 | 15 |
1084275 | 1084275 | 2021-03-03 | Madison | Missouri | 29123 | 1346 | 16 |
1084276 | 1084276 | 2021-03-03 | Maries | Missouri | 29125 | 536 | 7 |
1084277 | 1084277 | 2021-03-03 | Marion | Missouri | 29127 | 2646 | 42 |
1084278 | 1084278 | 2021-03-03 | McDonald | Missouri | 29119 | 2451 | 31 |
1084279 | 1084279 | 2021-03-03 | Mercer | Missouri | 29129 | 178 | 2 |
1084280 | 1084280 | 2021-03-03 | Miller | Missouri | 29131 | 2319 | 49 |
1084281 | 1084281 | 2021-03-03 | Mississippi | Missouri | 29133 | 1272 | 24 |
1084282 | 1084282 | 2021-03-03 | Moniteau | Missouri | 29135 | 1681 | 29 |
1084283 | 1084283 | 2021-03-03 | Monroe | Missouri | 29137 | 597 | 10 |
1084284 | 1084284 | 2021-03-03 | Montgomery | Missouri | 29139 | 568 | 10 |
1084285 | 1084285 | 2021-03-03 | Morgan | Missouri | 29141 | 1626 | 42 |
1084286 | 1084286 | 2021-03-03 | New Madrid | Missouri | 29143 | 1769 | 45 |
1084287 | 1084287 | 2021-03-03 | Newton | Missouri | 29145 | 4084 | 69 |
1084288 | 1084288 | 2021-03-03 | Nodaway | Missouri | 29147 | 2580 | 25 |
1084289 | 1084289 | 2021-03-03 | Oregon | Missouri | 29149 | 677 | 3 |
1084290 | 1084290 | 2021-03-03 | Osage | Missouri | 29151 | 1404 | 14 |
1084291 | 1084291 | 2021-03-03 | Ozark | Missouri | 29153 | 550 | 16 |
1084292 | 1084292 | 2021-03-03 | Pemiscot | Missouri | 29155 | 1413 | 29 |
1084293 | 1084293 | 2021-03-03 | Perry | Missouri | 29157 | 2049 | 27 |
1084294 | 1084294 | 2021-03-03 | Pettis | Missouri | 29159 | 4962 | 75 |
1084295 | 1084295 | 2021-03-03 | Phelps | Missouri | 29161 | 3022 | 121 |
1084296 | 1084296 | 2021-03-03 | Pike | Missouri | 29163 | 1488 | 22 |
1084297 | 1084297 | 2021-03-03 | Platte | Missouri | 29165 | 3121 | 43 |
1084298 | 1084298 | 2021-03-03 | Polk | Missouri | 29167 | 3246 | 39 |
1084299 | 1084299 | 2021-03-03 | Pulaski | Missouri | 29169 | 2990 | 48 |
1084300 | 1084300 | 2021-03-03 | Putnam | Missouri | 29171 | 225 | 3 |
1084301 | 1084301 | 2021-03-03 | Ralls | Missouri | 29173 | 758 | 12 |
1084302 | 1084302 | 2021-03-03 | Randolph | Missouri | 29175 | 1815 | 30 |
1084303 | 1084303 | 2021-03-03 | Ray | Missouri | 29177 | 1517 | 25 |
1084304 | 1084304 | 2021-03-03 | Reynolds | Missouri | 29179 | 464 | 4 |
1084305 | 1084305 | 2021-03-03 | Ripley | Missouri | 29181 | 855 | 14 |
1084306 | 1084306 | 2021-03-03 | Saline | Missouri | 29195 | 2430 | 38 |
1084307 | 1084307 | 2021-03-03 | Schuyler | Missouri | 29197 | 275 | 5 |
1084308 | 1084308 | 2021-03-03 | Scotland | Missouri | 29199 | 263 | 3 |
1084309 | 1084309 | 2021-03-03 | Scott | Missouri | 29201 | 3840 | 77 |
1084310 | 1084310 | 2021-03-03 | Shannon | Missouri | 29203 | 482 | 12 |
1084311 | 1084311 | 2021-03-03 | Shelby | Missouri | 29205 | 355 | 7 |
1084312 | 1084312 | 2021-03-03 | St. Charles | Missouri | 29183 | 43234 | 430 |
1084313 | 1084313 | 2021-03-03 | St. Clair | Missouri | 29185 | 588 | 7 |
1084314 | 1084314 | 2021-03-03 | St. Francois | Missouri | 29187 | 7591 | 107 |
1084315 | 1084315 | 2021-03-03 | St. Louis | Missouri | 29189 | 88778 | 2007 |
1084316 | 1084316 | 2021-03-03 | St. Louis city | Missouri | 29510 | 21544 | 425 |
1084317 | 1084317 | 2021-03-03 | Ste. Genevieve | Missouri | 29186 | 1618 | 15 |
1084318 | 1084318 | 2021-03-03 | Stoddard | Missouri | 29207 | 2314 | 36 |
1084319 | 1084319 | 2021-03-03 | Stone | Missouri | 29209 | 2030 | 38 |
1084320 | 1084320 | 2021-03-03 | Sullivan | Missouri | 29211 | 747 | 14 |
1084321 | 1084321 | 2021-03-03 | Taney | Missouri | 29213 | 4591 | 90 |
1084322 | 1084322 | 2021-03-03 | Texas | Missouri | 29215 | 1544 | 22 |
1084323 | 1084323 | 2021-03-03 | Vernon | Missouri | 29217 | 1395 | 38 |
1084324 | 1084324 | 2021-03-03 | Warren | Missouri | 29219 | 2661 | 27 |
1084325 | 1084325 | 2021-03-03 | Washington | Missouri | 29221 | 2121 | 48 |
1084326 | 1084326 | 2021-03-03 | Wayne | Missouri | 29223 | 821 | 11 |
1084327 | 1084327 | 2021-03-03 | Webster | Missouri | 29225 | 2995 | 53 |
1084328 | 1084328 | 2021-03-03 | Worth | Missouri | 29227 | 143 | 1 |
1084329 | 1084329 | 2021-03-03 | Wright | Missouri | 29229 | 1365 | 29 |
1084330 | 1084330 | 2021-03-03 | Beaverhead | Montana | 30001 | 866 | 8 |
1084331 | 1084331 | 2021-03-03 | Big Horn | Montana | 30003 | 2340 | 71 |
1084332 | 1084332 | 2021-03-03 | Blaine | Montana | 30005 | 700 | 24 |
1084333 | 1084333 | 2021-03-03 | Broadwater | Montana | 30007 | 411 | 5 |
1084334 | 1084334 | 2021-03-03 | Carbon | Montana | 30009 | 836 | 11 |
1084335 | 1084335 | 2021-03-03 | Carter | Montana | 30011 | 145 | 5 |
1084336 | 1084336 | 2021-03-03 | Cascade | Montana | 30013 | 7728 | 150 |
1084337 | 1084337 | 2021-03-03 | Chouteau | Montana | 30015 | 489 | 5 |
1084338 | 1084338 | 2021-03-03 | Custer | Montana | 30017 | 1139 | 15 |
1084339 | 1084339 | 2021-03-03 | Daniels | Montana | 30019 | 197 | 7 |
1084340 | 1084340 | 2021-03-03 | Dawson | Montana | 30021 | 1069 | 28 |
1084341 | 1084341 | 2021-03-03 | Deer Lodge | Montana | 30023 | 1041 | 13 |
1084342 | 1084342 | 2021-03-03 | Fallon | Montana | 30025 | 278 | 2 |
1084343 | 1084343 | 2021-03-03 | Fergus | Montana | 30027 | 1047 | 27 |
1084344 | 1084344 | 2021-03-03 | Flathead | Montana | 30029 | 11059 | 81 |
1084345 | 1084345 | 2021-03-03 | Gallatin | Montana | 30031 | 12461 | 54 |
1084346 | 1084346 | 2021-03-03 | Garfield | Montana | 30033 | 76 | 2 |
1084347 | 1084347 | 2021-03-03 | Glacier | Montana | 30035 | 1523 | 29 |
1084348 | 1084348 | 2021-03-03 | Golden Valley | Montana | 30037 | 53 | 2 |
1084349 | 1084349 | 2021-03-03 | Granite | Montana | 30039 | 191 | 2 |
1084350 | 1084350 | 2021-03-03 | Hill | Montana | 30041 | 1918 | 39 |
1084351 | 1084351 | 2021-03-03 | Jefferson | Montana | 30043 | 1010 | 8 |
1084352 | 1084352 | 2021-03-03 | Judith Basin | Montana | 30045 | 86 | 1 |
1084353 | 1084353 | 2021-03-03 | Lake | Montana | 30047 | 1924 | 26 |
1084354 | 1084354 | 2021-03-03 | Lewis and Clark | Montana | 30049 | 6356 | 67 |
1084355 | 1084355 | 2021-03-03 | Liberty | Montana | 30051 | 117 | 1 |
1084356 | 1084356 | 2021-03-03 | Lincoln | Montana | 30053 | 1499 | 13 |
1084357 | 1084357 | 2021-03-03 | Madison | Montana | 30057 | 708 | 7 |
1084358 | 1084358 | 2021-03-03 | McCone | Montana | 30055 | 179 | 1 |
1084359 | 1084359 | 2021-03-03 | Meagher | Montana | 30059 | 125 | 7 |
1084360 | 1084360 | 2021-03-03 | Mineral | Montana | 30061 | 230 | 0 |
1084361 | 1084361 | 2021-03-03 | Missoula | Montana | 30063 | 8228 | 82 |
1084362 | 1084362 | 2021-03-03 | Musselshell | Montana | 30065 | 308 | 8 |
1084363 | 1084363 | 2021-03-03 | Park | Montana | 30067 | 1136 | 10 |
1084364 | 1084364 | 2021-03-03 | Petroleum | Montana | 30069 | 12 | 1 |
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);