ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
340 rows where deaths = 551 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Florida 129
- Texas 38
- Tennessee 16
- Michigan 13
- Wisconsin 13
- Indiana 12
- New Jersey 12
- New Mexico 12
- Montana 11
- Ohio 9
- Arizona 7
- North Carolina 7
- Washington 6
- Virginia 5
- California 4
- Georgia 4
- Illinois 4
- Louisiana 4
- Maryland 4
- Pennsylvania 4
- Delaware 3
- Mississippi 3
- South Carolina 3
- Colorado 2
- District of Columbia 2
- Iowa 2
- Kansas 2
- Missouri 2
- Arkansas 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501248 | 2501248 | 2022-05-13 | Yellowstone | Montana | 30111 | 43099 | 551 |
2502252 | 2502252 | 2022-05-13 | Comal | Texas | 48091 | 34812 | 551 |
2497990 | 2497990 | 2022-05-12 | Yellowstone | Montana | 30111 | 43038 | 551 |
2498994 | 2498994 | 2022-05-12 | Comal | Texas | 48091 | 34789 | 551 |
2494732 | 2494732 | 2022-05-11 | Yellowstone | Montana | 30111 | 43038 | 551 |
2495736 | 2495736 | 2022-05-11 | Comal | Texas | 48091 | 34761 | 551 |
2491474 | 2491474 | 2022-05-10 | Yellowstone | Montana | 30111 | 43038 | 551 |
2492478 | 2492478 | 2022-05-10 | Comal | Texas | 48091 | 34720 | 551 |
2488216 | 2488216 | 2022-05-09 | Yellowstone | Montana | 30111 | 43038 | 551 |
2489220 | 2489220 | 2022-05-09 | Comal | Texas | 48091 | 34699 | 551 |
2484959 | 2484959 | 2022-05-08 | Yellowstone | Montana | 30111 | 43038 | 551 |
2485963 | 2485963 | 2022-05-08 | Comal | Texas | 48091 | 34691 | 551 |
2481701 | 2481701 | 2022-05-07 | Yellowstone | Montana | 30111 | 43038 | 551 |
2482705 | 2482705 | 2022-05-07 | Comal | Texas | 48091 | 34680 | 551 |
2478443 | 2478443 | 2022-05-06 | Yellowstone | Montana | 30111 | 43038 | 551 |
2479447 | 2479447 | 2022-05-06 | Comal | Texas | 48091 | 34636 | 551 |
2475185 | 2475185 | 2022-05-05 | Yellowstone | Montana | 30111 | 43020 | 551 |
2476189 | 2476189 | 2022-05-05 | Comal | Texas | 48091 | 34604 | 551 |
2471928 | 2471928 | 2022-05-04 | Yellowstone | Montana | 30111 | 43011 | 551 |
2472932 | 2472932 | 2022-05-04 | Comal | Texas | 48091 | 34563 | 551 |
2468672 | 2468672 | 2022-05-03 | Yellowstone | Montana | 30111 | 42997 | 551 |
2445464 | 2445464 | 2022-04-26 | Berrien | Michigan | 26021 | 34849 | 551 |
2442208 | 2442208 | 2022-04-25 | Berrien | Michigan | 26021 | 34849 | 551 |
2443809 | 2443809 | 2022-04-25 | Tom Green | Texas | 48451 | 40992 | 551 |
2444117 | 2444117 | 2022-04-25 | Brown | Wisconsin | 55009 | 84474 | 551 |
2438952 | 2438952 | 2022-04-24 | Berrien | Michigan | 26021 | 34849 | 551 |
2440553 | 2440553 | 2022-04-24 | Tom Green | Texas | 48451 | 40992 | 551 |
2440861 | 2440861 | 2022-04-24 | Brown | Wisconsin | 55009 | 84380 | 551 |
2435696 | 2435696 | 2022-04-23 | Berrien | Michigan | 26021 | 34849 | 551 |
2437297 | 2437297 | 2022-04-23 | Tom Green | Texas | 48451 | 40992 | 551 |
2437605 | 2437605 | 2022-04-23 | Brown | Wisconsin | 55009 | 84380 | 551 |
2432440 | 2432440 | 2022-04-22 | Berrien | Michigan | 26021 | 34849 | 551 |
2434041 | 2434041 | 2022-04-22 | Tom Green | Texas | 48451 | 40992 | 551 |
2434349 | 2434349 | 2022-04-22 | Brown | Wisconsin | 55009 | 84380 | 551 |
2429184 | 2429184 | 2022-04-21 | Berrien | Michigan | 26021 | 34849 | 551 |
2430785 | 2430785 | 2022-04-21 | Tom Green | Texas | 48451 | 40956 | 551 |
2431093 | 2431093 | 2022-04-21 | Brown | Wisconsin | 55009 | 84331 | 551 |
2425928 | 2425928 | 2022-04-20 | Berrien | Michigan | 26021 | 34849 | 551 |
2427529 | 2427529 | 2022-04-20 | Tom Green | Texas | 48451 | 40956 | 551 |
2427837 | 2427837 | 2022-04-20 | Brown | Wisconsin | 55009 | 84291 | 551 |
2424273 | 2424273 | 2022-04-19 | Tom Green | Texas | 48451 | 40956 | 551 |
2421017 | 2421017 | 2022-04-18 | Tom Green | Texas | 48451 | 40956 | 551 |
2417761 | 2417761 | 2022-04-17 | Tom Green | Texas | 48451 | 40956 | 551 |
2414505 | 2414505 | 2022-04-16 | Tom Green | Texas | 48451 | 40956 | 551 |
2411249 | 2411249 | 2022-04-15 | Tom Green | Texas | 48451 | 40956 | 551 |
2337540 | 2337540 | 2022-03-24 | Hendricks | Indiana | 18063 | 40746 | 551 |
2333932 | 2333932 | 2022-03-23 | Sumter | Florida | 12119 | 21550 | 551 |
2334286 | 2334286 | 2022-03-23 | Hendricks | Indiana | 18063 | 40745 | 551 |
2330678 | 2330678 | 2022-03-22 | Sumter | Florida | 12119 | 21550 | 551 |
2327426 | 2327426 | 2022-03-21 | Sumter | Florida | 12119 | 21550 | 551 |
2324173 | 2324173 | 2022-03-20 | Sumter | Florida | 12119 | 21550 | 551 |
2320919 | 2320919 | 2022-03-19 | Sumter | Florida | 12119 | 21550 | 551 |
2317665 | 2317665 | 2022-03-18 | Sumter | Florida | 12119 | 21550 | 551 |
2314412 | 2314412 | 2022-03-17 | Sumter | Florida | 12119 | 21550 | 551 |
2311159 | 2311159 | 2022-03-16 | Sumter | Florida | 12119 | 21550 | 551 |
2302938 | 2302938 | 2022-03-13 | Buncombe | North Carolina | 37021 | 51621 | 551 |
2299686 | 2299686 | 2022-03-12 | Buncombe | North Carolina | 37021 | 51621 | 551 |
2296434 | 2296434 | 2022-03-11 | Buncombe | North Carolina | 37021 | 51621 | 551 |
2269267 | 2269267 | 2022-03-03 | Porter | Indiana | 18127 | 37193 | 551 |
2246413 | 2246413 | 2022-02-24 | Peoria | Illinois | 17143 | 45903 | 551 |
2246901 | 2246901 | 2022-02-24 | Rapides | Louisiana | 22079 | 32556 | 551 |
2247021 | 2247021 | 2022-02-24 | Jackson | Michigan | 26075 | 44169 | 551 |
2243650 | 2243650 | 2022-02-23 | Rapides | Louisiana | 22079 | 32543 | 551 |
2243770 | 2243770 | 2022-02-23 | Jackson | Michigan | 26075 | 44169 | 551 |
2240399 | 2240399 | 2022-02-22 | Rapides | Louisiana | 22079 | 32530 | 551 |
2241223 | 2241223 | 2022-02-22 | Rowan | North Carolina | 37159 | 40578 | 551 |
2237972 | 2237972 | 2022-02-21 | Rowan | North Carolina | 37159 | 40554 | 551 |
2217733 | 2217733 | 2022-02-15 | Bay | Michigan | 26017 | 26529 | 551 |
2214482 | 2214482 | 2022-02-14 | Bay | Michigan | 26017 | 26529 | 551 |
2204688 | 2204688 | 2022-02-11 | Harford | Maryland | 24025 | 36621 | 551 |
2194069 | 2194069 | 2022-02-08 | Leon | Florida | 12073 | 80881 | 551 |
2190815 | 2190815 | 2022-02-07 | Leon | Florida | 12073 | 80881 | 551 |
2187562 | 2187562 | 2022-02-06 | Leon | Florida | 12073 | 80881 | 551 |
2184309 | 2184309 | 2022-02-05 | Leon | Florida | 12073 | 80881 | 551 |
2181057 | 2181057 | 2022-02-04 | Leon | Florida | 12073 | 80881 | 551 |
2177806 | 2177806 | 2022-02-03 | Leon | Florida | 12073 | 78130 | 551 |
2174553 | 2174553 | 2022-02-02 | Leon | Florida | 12073 | 78130 | 551 |
2168007 | 2168007 | 2022-01-31 | Kent | Delaware | 10001 | 47695 | 551 |
2164752 | 2164752 | 2022-01-30 | Kent | Delaware | 10001 | 47598 | 551 |
2166266 | 2166266 | 2022-01-30 | McKinley | New Mexico | 35031 | 23428 | 551 |
2161497 | 2161497 | 2022-01-29 | Kent | Delaware | 10001 | 47434 | 551 |
2163011 | 2163011 | 2022-01-29 | McKinley | New Mexico | 35031 | 23428 | 551 |
2159756 | 2159756 | 2022-01-28 | McKinley | New Mexico | 35031 | 23428 | 551 |
2155456 | 2155456 | 2022-01-27 | Vanderburgh | Indiana | 18163 | 52306 | 551 |
2156502 | 2156502 | 2022-01-27 | McKinley | New Mexico | 35031 | 23201 | 551 |
2152203 | 2152203 | 2022-01-26 | Vanderburgh | Indiana | 18163 | 51455 | 551 |
2153249 | 2153249 | 2022-01-26 | McKinley | New Mexico | 35031 | 22904 | 551 |
2109594 | 2109594 | 2022-01-13 | Henry | Georgia | 13151 | 51549 | 551 |
2105238 | 2105238 | 2022-01-11 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2101987 | 2101987 | 2022-01-10 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2096858 | 2096858 | 2022-01-09 | Hamilton | Indiana | 18057 | 63192 | 551 |
2098736 | 2098736 | 2022-01-09 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2093606 | 2093606 | 2022-01-08 | Hamilton | Indiana | 18057 | 63192 | 551 |
2095484 | 2095484 | 2022-01-08 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2090354 | 2090354 | 2022-01-07 | Hamilton | Indiana | 18057 | 63192 | 551 |
2092232 | 2092232 | 2022-01-07 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2088980 | 2088980 | 2022-01-06 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2085729 | 2085729 | 2022-01-05 | Sullivan | Tennessee | 47163 | 31623 | 551 |
2085986 | 2085986 | 2022-01-05 | Wichita | Texas | 48485 | 23740 | 551 |
2082477 | 2082477 | 2022-01-04 | Sullivan | Tennessee | 47163 | 31623 | 551 |
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);