ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
5,945 rows where deaths = 92 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 364
- Texas 339
- Indiana 308
- Tennessee 299
- Virginia 270
- Mississippi 269
- New York 269
- Minnesota 265
- Louisiana 260
- North Carolina 260
- Illinois 255
- West Virginia 213
- New Mexico 212
- Michigan 178
- Kentucky 175
- Missouri 169
- Pennsylvania 168
- Iowa 159
- Alabama 141
- Wisconsin 122
- Ohio 106
- South Carolina 101
- Montana 98
- Arkansas 95
- Oklahoma 90
- North Dakota 80
- Kansas 74
- Nebraska 65
- California 61
- Florida 58
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500604 | 2500604 | 2022-05-13 | Clay | Kentucky | 21051 | 7867 | 92 |
2500694 | 2500694 | 2022-05-13 | Wayne | Kentucky | 21231 | 6107 | 92 |
2500851 | 2500851 | 2022-05-13 | Houghton | Michigan | 26061 | 7982 | 92 |
2501346 | 2501346 | 2022-05-13 | Douglas | Nevada | 32005 | 7410 | 92 |
2501826 | 2501826 | 2022-05-13 | Jefferson | Oregon | 41031 | 7319 | 92 |
2501899 | 2501899 | 2022-05-13 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2502472 | 2502472 | 2022-05-13 | Iron | Utah | 49021 | 14774 | 92 |
2502486 | 2502486 | 2022-05-13 | Unknown | Utah | 4044 | 92 | |
2502599 | 2502599 | 2022-05-13 | Nottoway | Virginia | 51135 | 4300 | 92 |
2502771 | 2502771 | 2022-05-13 | Langlade | Wisconsin | 55067 | 5295 | 92 |
2497346 | 2497346 | 2022-05-12 | Clay | Kentucky | 21051 | 7867 | 92 |
2497436 | 2497436 | 2022-05-12 | Wayne | Kentucky | 21231 | 6107 | 92 |
2497593 | 2497593 | 2022-05-12 | Houghton | Michigan | 26061 | 7982 | 92 |
2498088 | 2498088 | 2022-05-12 | Douglas | Nevada | 32005 | 7410 | 92 |
2498568 | 2498568 | 2022-05-12 | Jefferson | Oregon | 41031 | 7315 | 92 |
2498641 | 2498641 | 2022-05-12 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2499214 | 2499214 | 2022-05-12 | Iron | Utah | 49021 | 14774 | 92 |
2499228 | 2499228 | 2022-05-12 | Unknown | Utah | 4044 | 92 | |
2499341 | 2499341 | 2022-05-12 | Nottoway | Virginia | 51135 | 4297 | 92 |
2499513 | 2499513 | 2022-05-12 | Langlade | Wisconsin | 55067 | 5287 | 92 |
2494088 | 2494088 | 2022-05-11 | Clay | Kentucky | 21051 | 7867 | 92 |
2494178 | 2494178 | 2022-05-11 | Wayne | Kentucky | 21231 | 6107 | 92 |
2494335 | 2494335 | 2022-05-11 | Houghton | Michigan | 26061 | 7982 | 92 |
2494830 | 2494830 | 2022-05-11 | Douglas | Nevada | 32005 | 7410 | 92 |
2495310 | 2495310 | 2022-05-11 | Jefferson | Oregon | 41031 | 7311 | 92 |
2495383 | 2495383 | 2022-05-11 | Potter | Pennsylvania | 42105 | 3256 | 92 |
2495956 | 2495956 | 2022-05-11 | Iron | Utah | 49021 | 14771 | 92 |
2496083 | 2496083 | 2022-05-11 | Nottoway | Virginia | 51135 | 4299 | 92 |
2496255 | 2496255 | 2022-05-11 | Langlade | Wisconsin | 55067 | 5279 | 92 |
2490830 | 2490830 | 2022-05-10 | Clay | Kentucky | 21051 | 7867 | 92 |
2490920 | 2490920 | 2022-05-10 | Wayne | Kentucky | 21231 | 6107 | 92 |
2491077 | 2491077 | 2022-05-10 | Houghton | Michigan | 26061 | 7922 | 92 |
2491572 | 2491572 | 2022-05-10 | Douglas | Nevada | 32005 | 7369 | 92 |
2492052 | 2492052 | 2022-05-10 | Jefferson | Oregon | 41031 | 7301 | 92 |
2492125 | 2492125 | 2022-05-10 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2492339 | 2492339 | 2022-05-10 | Benton | Tennessee | 47005 | 4527 | 92 |
2492698 | 2492698 | 2022-05-10 | Iron | Utah | 49021 | 14765 | 92 |
2492825 | 2492825 | 2022-05-10 | Nottoway | Virginia | 51135 | 4293 | 92 |
2492997 | 2492997 | 2022-05-10 | Langlade | Wisconsin | 55067 | 5274 | 92 |
2487573 | 2487573 | 2022-05-09 | Clay | Kentucky | 21051 | 7867 | 92 |
2487663 | 2487663 | 2022-05-09 | Wayne | Kentucky | 21231 | 6107 | 92 |
2487820 | 2487820 | 2022-05-09 | Houghton | Michigan | 26061 | 7922 | 92 |
2488314 | 2488314 | 2022-05-09 | Douglas | Nevada | 32005 | 7369 | 92 |
2488794 | 2488794 | 2022-05-09 | Jefferson | Oregon | 41031 | 7288 | 92 |
2488867 | 2488867 | 2022-05-09 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2489081 | 2489081 | 2022-05-09 | Benton | Tennessee | 47005 | 4527 | 92 |
2489440 | 2489440 | 2022-05-09 | Iron | Utah | 49021 | 14765 | 92 |
2489567 | 2489567 | 2022-05-09 | Nottoway | Virginia | 51135 | 4289 | 92 |
2489739 | 2489739 | 2022-05-09 | Langlade | Wisconsin | 55067 | 5266 | 92 |
2484315 | 2484315 | 2022-05-08 | Clay | Kentucky | 21051 | 7866 | 92 |
2484396 | 2484396 | 2022-05-08 | Simpson | Kentucky | 21213 | 5627 | 92 |
2484562 | 2484562 | 2022-05-08 | Houghton | Michigan | 26061 | 7922 | 92 |
2485057 | 2485057 | 2022-05-08 | Douglas | Nevada | 32005 | 7369 | 92 |
2485537 | 2485537 | 2022-05-08 | Jefferson | Oregon | 41031 | 7286 | 92 |
2485610 | 2485610 | 2022-05-08 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2485824 | 2485824 | 2022-05-08 | Benton | Tennessee | 47005 | 4527 | 92 |
2486196 | 2486196 | 2022-05-08 | Unknown | Utah | 4081 | 92 | |
2486310 | 2486310 | 2022-05-08 | Nottoway | Virginia | 51135 | 4283 | 92 |
2486336 | 2486336 | 2022-05-08 | Southampton | Virginia | 51175 | 3433 | 92 |
2486482 | 2486482 | 2022-05-08 | Langlade | Wisconsin | 55067 | 5255 | 92 |
2481057 | 2481057 | 2022-05-07 | Clay | Kentucky | 21051 | 7866 | 92 |
2481138 | 2481138 | 2022-05-07 | Simpson | Kentucky | 21213 | 5627 | 92 |
2481304 | 2481304 | 2022-05-07 | Houghton | Michigan | 26061 | 7922 | 92 |
2481799 | 2481799 | 2022-05-07 | Douglas | Nevada | 32005 | 7369 | 92 |
2482279 | 2482279 | 2022-05-07 | Jefferson | Oregon | 41031 | 7286 | 92 |
2482352 | 2482352 | 2022-05-07 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2482566 | 2482566 | 2022-05-07 | Benton | Tennessee | 47005 | 4527 | 92 |
2482938 | 2482938 | 2022-05-07 | Unknown | Utah | 4084 | 92 | |
2483052 | 2483052 | 2022-05-07 | Nottoway | Virginia | 51135 | 4283 | 92 |
2483078 | 2483078 | 2022-05-07 | Southampton | Virginia | 51175 | 3433 | 92 |
2483224 | 2483224 | 2022-05-07 | Langlade | Wisconsin | 55067 | 5255 | 92 |
2477799 | 2477799 | 2022-05-06 | Clay | Kentucky | 21051 | 7866 | 92 |
2477880 | 2477880 | 2022-05-06 | Simpson | Kentucky | 21213 | 5627 | 92 |
2478046 | 2478046 | 2022-05-06 | Houghton | Michigan | 26061 | 7922 | 92 |
2478541 | 2478541 | 2022-05-06 | Douglas | Nevada | 32005 | 7369 | 92 |
2479021 | 2479021 | 2022-05-06 | Jefferson | Oregon | 41031 | 7286 | 92 |
2479094 | 2479094 | 2022-05-06 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2479308 | 2479308 | 2022-05-06 | Benton | Tennessee | 47005 | 4527 | 92 |
2479794 | 2479794 | 2022-05-06 | Nottoway | Virginia | 51135 | 4283 | 92 |
2479820 | 2479820 | 2022-05-06 | Southampton | Virginia | 51175 | 3433 | 92 |
2479966 | 2479966 | 2022-05-06 | Langlade | Wisconsin | 55067 | 5255 | 92 |
2474541 | 2474541 | 2022-05-05 | Clay | Kentucky | 21051 | 7866 | 92 |
2474622 | 2474622 | 2022-05-05 | Simpson | Kentucky | 21213 | 5627 | 92 |
2474788 | 2474788 | 2022-05-05 | Houghton | Michigan | 26061 | 7922 | 92 |
2475283 | 2475283 | 2022-05-05 | Douglas | Nevada | 32005 | 7369 | 92 |
2475836 | 2475836 | 2022-05-05 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2476050 | 2476050 | 2022-05-05 | Benton | Tennessee | 47005 | 4527 | 92 |
2476562 | 2476562 | 2022-05-05 | Southampton | Virginia | 51175 | 3432 | 92 |
2476708 | 2476708 | 2022-05-05 | Langlade | Wisconsin | 55067 | 5240 | 92 |
2471284 | 2471284 | 2022-05-04 | Clay | Kentucky | 21051 | 7866 | 92 |
2471365 | 2471365 | 2022-05-04 | Simpson | Kentucky | 21213 | 5627 | 92 |
2471531 | 2471531 | 2022-05-04 | Houghton | Michigan | 26061 | 7922 | 92 |
2471762 | 2471762 | 2022-05-04 | Bates | Missouri | 29013 | 3746 | 92 |
2472026 | 2472026 | 2022-05-04 | Douglas | Nevada | 32005 | 7369 | 92 |
2472579 | 2472579 | 2022-05-04 | Potter | Pennsylvania | 42105 | 3222 | 92 |
2472793 | 2472793 | 2022-05-04 | Benton | Tennessee | 47005 | 4527 | 92 |
2473165 | 2473165 | 2022-05-04 | Unknown | Utah | 2526 | 92 | |
2473304 | 2473304 | 2022-05-04 | Southampton | Virginia | 51175 | 3430 | 92 |
2468028 | 2468028 | 2022-05-03 | Clay | Kentucky | 21051 | 7866 | 92 |
2468109 | 2468109 | 2022-05-03 | Simpson | Kentucky | 21213 | 5627 | 92 |
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);