ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
17,893 rows where deaths = 25 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: state, county, fips
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499874 | 2499874 | 2022-05-13 | Routt | Colorado | 8107 | 6562 | 25 |
2500027 | 2500027 | 2022-05-13 | Glascock | Georgia | 13125 | 610 | 25 |
2500051 | 2500051 | 2022-05-13 | Lanier | Georgia | 13173 | 2277 | 25 |
2500162 | 2500162 | 2022-05-13 | Lemhi | Idaho | 16059 | 1261 | 25 |
2500330 | 2500330 | 2022-05-13 | Martin | Indiana | 18101 | 2173 | 25 |
2500385 | 2500385 | 2022-05-13 | Calhoun | Iowa | 19025 | 2608 | 25 |
2500408 | 2500408 | 2022-05-13 | Fremont | Iowa | 19071 | 1387 | 25 |
2500624 | 2500624 | 2022-05-13 | Hancock | Kentucky | 21091 | 2498 | 25 |
2501471 | 2501471 | 2022-05-13 | Schuyler | New York | 36097 | 3724 | 25 |
2501612 | 2501612 | 2022-05-13 | McKenzie | North Dakota | 38053 | 3272 | 25 |
2502267 | 2502267 | 2022-05-13 | Delta | Texas | 48119 | 1820 | 25 |
2502344 | 2502344 | 2022-05-13 | Knox | Texas | 48275 | 492 | 25 |
2502400 | 2502400 | 2022-05-13 | Real | Texas | 48385 | 817 | 25 |
2502473 | 2502473 | 2022-05-13 | Juab | Utah | 49023 | 2899 | 25 |
2502494 | 2502494 | 2022-05-13 | Caledonia | Vermont | 50005 | 5854 | 25 |
2502614 | 2502614 | 2022-05-13 | Richmond | Virginia | 51159 | 2601 | 25 |
2502735 | 2502735 | 2022-05-13 | Wirt | West Virginia | 54105 | 1455 | 25 |
2496616 | 2496616 | 2022-05-12 | Routt | Colorado | 8107 | 6544 | 25 |
2496769 | 2496769 | 2022-05-12 | Glascock | Georgia | 13125 | 610 | 25 |
2496793 | 2496793 | 2022-05-12 | Lanier | Georgia | 13173 | 2277 | 25 |
2496904 | 2496904 | 2022-05-12 | Lemhi | Idaho | 16059 | 1261 | 25 |
2497072 | 2497072 | 2022-05-12 | Martin | Indiana | 18101 | 2172 | 25 |
2497127 | 2497127 | 2022-05-12 | Calhoun | Iowa | 19025 | 2608 | 25 |
2497150 | 2497150 | 2022-05-12 | Fremont | Iowa | 19071 | 1387 | 25 |
2497366 | 2497366 | 2022-05-12 | Hancock | Kentucky | 21091 | 2498 | 25 |
2497909 | 2497909 | 2022-05-12 | Reynolds | Missouri | 29179 | 1165 | 25 |
2498213 | 2498213 | 2022-05-12 | Schuyler | New York | 36097 | 3724 | 25 |
2498354 | 2498354 | 2022-05-12 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2499009 | 2499009 | 2022-05-12 | Delta | Texas | 48119 | 1819 | 25 |
2499086 | 2499086 | 2022-05-12 | Knox | Texas | 48275 | 492 | 25 |
2499142 | 2499142 | 2022-05-12 | Real | Texas | 48385 | 817 | 25 |
2499215 | 2499215 | 2022-05-12 | Juab | Utah | 49023 | 2899 | 25 |
2499236 | 2499236 | 2022-05-12 | Caledonia | Vermont | 50005 | 5831 | 25 |
2499356 | 2499356 | 2022-05-12 | Richmond | Virginia | 51159 | 2595 | 25 |
2499477 | 2499477 | 2022-05-12 | Wirt | West Virginia | 54105 | 1455 | 25 |
2493358 | 2493358 | 2022-05-11 | Routt | Colorado | 8107 | 6517 | 25 |
2493511 | 2493511 | 2022-05-11 | Glascock | Georgia | 13125 | 610 | 25 |
2493535 | 2493535 | 2022-05-11 | Lanier | Georgia | 13173 | 2277 | 25 |
2493646 | 2493646 | 2022-05-11 | Lemhi | Idaho | 16059 | 1261 | 25 |
2493814 | 2493814 | 2022-05-11 | Martin | Indiana | 18101 | 2172 | 25 |
2493869 | 2493869 | 2022-05-11 | Calhoun | Iowa | 19025 | 2608 | 25 |
2493892 | 2493892 | 2022-05-11 | Fremont | Iowa | 19071 | 1387 | 25 |
2494108 | 2494108 | 2022-05-11 | Hancock | Kentucky | 21091 | 2498 | 25 |
2494651 | 2494651 | 2022-05-11 | Reynolds | Missouri | 29179 | 1165 | 25 |
2494955 | 2494955 | 2022-05-11 | Schuyler | New York | 36097 | 3714 | 25 |
2495096 | 2495096 | 2022-05-11 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2495751 | 2495751 | 2022-05-11 | Delta | Texas | 48119 | 1819 | 25 |
2495828 | 2495828 | 2022-05-11 | Knox | Texas | 48275 | 492 | 25 |
2495884 | 2495884 | 2022-05-11 | Real | Texas | 48385 | 817 | 25 |
2495957 | 2495957 | 2022-05-11 | Juab | Utah | 49023 | 2896 | 25 |
2495978 | 2495978 | 2022-05-11 | Caledonia | Vermont | 50005 | 5800 | 25 |
2496098 | 2496098 | 2022-05-11 | Richmond | Virginia | 51159 | 2592 | 25 |
2490100 | 2490100 | 2022-05-10 | Routt | Colorado | 8107 | 6516 | 25 |
2490253 | 2490253 | 2022-05-10 | Glascock | Georgia | 13125 | 609 | 25 |
2490277 | 2490277 | 2022-05-10 | Lanier | Georgia | 13173 | 2268 | 25 |
2490388 | 2490388 | 2022-05-10 | Lemhi | Idaho | 16059 | 1261 | 25 |
2490556 | 2490556 | 2022-05-10 | Martin | Indiana | 18101 | 2173 | 25 |
2490611 | 2490611 | 2022-05-10 | Calhoun | Iowa | 19025 | 2603 | 25 |
2490634 | 2490634 | 2022-05-10 | Fremont | Iowa | 19071 | 1387 | 25 |
2490850 | 2490850 | 2022-05-10 | Hancock | Kentucky | 21091 | 2498 | 25 |
2491393 | 2491393 | 2022-05-10 | Reynolds | Missouri | 29179 | 1165 | 25 |
2491697 | 2491697 | 2022-05-10 | Schuyler | New York | 36097 | 3707 | 25 |
2491838 | 2491838 | 2022-05-10 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2492493 | 2492493 | 2022-05-10 | Delta | Texas | 48119 | 1819 | 25 |
2492570 | 2492570 | 2022-05-10 | Knox | Texas | 48275 | 492 | 25 |
2492626 | 2492626 | 2022-05-10 | Real | Texas | 48385 | 817 | 25 |
2492699 | 2492699 | 2022-05-10 | Juab | Utah | 49023 | 2896 | 25 |
2492720 | 2492720 | 2022-05-10 | Caledonia | Vermont | 50005 | 5795 | 25 |
2492840 | 2492840 | 2022-05-10 | Richmond | Virginia | 51159 | 2590 | 25 |
2486843 | 2486843 | 2022-05-09 | Routt | Colorado | 8107 | 6508 | 25 |
2486996 | 2486996 | 2022-05-09 | Glascock | Georgia | 13125 | 609 | 25 |
2487020 | 2487020 | 2022-05-09 | Lanier | Georgia | 13173 | 2268 | 25 |
2487131 | 2487131 | 2022-05-09 | Lemhi | Idaho | 16059 | 1261 | 25 |
2487299 | 2487299 | 2022-05-09 | Martin | Indiana | 18101 | 2173 | 25 |
2487354 | 2487354 | 2022-05-09 | Calhoun | Iowa | 19025 | 2603 | 25 |
2487377 | 2487377 | 2022-05-09 | Fremont | Iowa | 19071 | 1387 | 25 |
2487593 | 2487593 | 2022-05-09 | Hancock | Kentucky | 21091 | 2498 | 25 |
2488135 | 2488135 | 2022-05-09 | Reynolds | Missouri | 29179 | 1165 | 25 |
2488439 | 2488439 | 2022-05-09 | Schuyler | New York | 36097 | 3704 | 25 |
2488580 | 2488580 | 2022-05-09 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2489235 | 2489235 | 2022-05-09 | Delta | Texas | 48119 | 1819 | 25 |
2489312 | 2489312 | 2022-05-09 | Knox | Texas | 48275 | 492 | 25 |
2489368 | 2489368 | 2022-05-09 | Real | Texas | 48385 | 817 | 25 |
2489441 | 2489441 | 2022-05-09 | Juab | Utah | 49023 | 2896 | 25 |
2489462 | 2489462 | 2022-05-09 | Caledonia | Vermont | 50005 | 5789 | 25 |
2489582 | 2489582 | 2022-05-09 | Richmond | Virginia | 51159 | 2587 | 25 |
2489738 | 2489738 | 2022-05-09 | Lafayette | Wisconsin | 55065 | 3707 | 25 |
2483585 | 2483585 | 2022-05-08 | Routt | Colorado | 8107 | 6500 | 25 |
2483738 | 2483738 | 2022-05-08 | Glascock | Georgia | 13125 | 609 | 25 |
2483762 | 2483762 | 2022-05-08 | Lanier | Georgia | 13173 | 2268 | 25 |
2483873 | 2483873 | 2022-05-08 | Lemhi | Idaho | 16059 | 1260 | 25 |
2484041 | 2484041 | 2022-05-08 | Martin | Indiana | 18101 | 2169 | 25 |
2484096 | 2484096 | 2022-05-08 | Calhoun | Iowa | 19025 | 2603 | 25 |
2484119 | 2484119 | 2022-05-08 | Fremont | Iowa | 19071 | 1387 | 25 |
2484377 | 2484377 | 2022-05-08 | Morgan | Kentucky | 21175 | 5247 | 25 |
2484878 | 2484878 | 2022-05-08 | Reynolds | Missouri | 29179 | 1165 | 25 |
2485182 | 2485182 | 2022-05-08 | Schuyler | New York | 36097 | 3703 | 25 |
2485323 | 2485323 | 2022-05-08 | McKenzie | North Dakota | 38053 | 3267 | 25 |
2485978 | 2485978 | 2022-05-08 | Delta | Texas | 48119 | 1818 | 25 |
2486055 | 2486055 | 2022-05-08 | Knox | Texas | 48275 | 492 | 25 |
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);