ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
12,226 rows where deaths = 48 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 1,111
- Georgia 883
- Iowa 767
- Kentucky 649
- Virginia 641
- Mississippi 586
- Tennessee 543
- Indiana 502
- Arkansas 469
- Missouri 443
- Illinois 419
- Minnesota 407
- Michigan 357
- Ohio 356
- Louisiana 328
- Wisconsin 314
- Alabama 309
- North Carolina 281
- Florida 241
- South Carolina 240
- Colorado 213
- Idaho 198
- Pennsylvania 157
- Oklahoma 155
- West Virginia 152
- Oregon 151
- New York 145
- Kansas 139
- South Dakota 122
- California 118
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499749 | 2499749 | 2022-05-13 | Searcy | Arkansas | 5129 | 2126 | 48 |
2500085 | 2500085 | 2022-05-13 | Randolph | Georgia | 13243 | 1490 | 48 |
2500426 | 2500426 | 2022-05-13 | Keokuk | Iowa | 19107 | 2085 | 48 |
2500439 | 2500439 | 2022-05-13 | Monona | Iowa | 19133 | 1723 | 48 |
2500584 | 2500584 | 2022-05-13 | Bath | Kentucky | 21011 | 3210 | 48 |
2500880 | 2500880 | 2022-05-13 | Montmorency | Michigan | 26119 | 1750 | 48 |
2500916 | 2500916 | 2022-05-13 | Chippewa | Minnesota | 27023 | 3128 | 48 |
2501027 | 2501027 | 2022-05-13 | Kemper | Mississippi | 28069 | 2187 | 48 |
2501044 | 2501044 | 2022-05-13 | Noxubee | Mississippi | 28103 | 2730 | 48 |
2501064 | 2501064 | 2022-05-13 | Tunica | Mississippi | 28143 | 2559 | 48 |
2501201 | 2501201 | 2022-05-13 | Custer | Montana | 30017 | 3062 | 48 |
2501502 | 2501502 | 2022-05-13 | Caswell | North Carolina | 37033 | 5357 | 48 |
2501811 | 2501811 | 2022-05-13 | Baker | Oregon | 41001 | 3231 | 48 |
2502199 | 2502199 | 2022-05-13 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2502235 | 2502235 | 2022-05-13 | Calhoun | Texas | 48057 | 5731 | 48 |
2502283 | 2502283 | 2022-05-13 | Floyd | Texas | 48153 | 1961 | 48 |
2502345 | 2502345 | 2022-05-13 | La Salle | Texas | 48283 | 2421 | 48 |
2502385 | 2502385 | 2022-05-13 | Ochiltree | Texas | 48357 | 2424 | 48 |
2502590 | 2502590 | 2022-05-13 | Middlesex | Virginia | 51119 | 1874 | 48 |
2502790 | 2502790 | 2022-05-13 | Richland | Wisconsin | 55103 | 3995 | 48 |
2496491 | 2496491 | 2022-05-12 | Searcy | Arkansas | 5129 | 2126 | 48 |
2496827 | 2496827 | 2022-05-12 | Randolph | Georgia | 13243 | 1490 | 48 |
2496903 | 2496903 | 2022-05-12 | Latah | Idaho | 16057 | 6787 | 48 |
2497168 | 2497168 | 2022-05-12 | Keokuk | Iowa | 19107 | 2085 | 48 |
2497181 | 2497181 | 2022-05-12 | Monona | Iowa | 19133 | 1723 | 48 |
2497326 | 2497326 | 2022-05-12 | Bath | Kentucky | 21011 | 3210 | 48 |
2497622 | 2497622 | 2022-05-12 | Montmorency | Michigan | 26119 | 1750 | 48 |
2497658 | 2497658 | 2022-05-12 | Chippewa | Minnesota | 27023 | 3119 | 48 |
2497769 | 2497769 | 2022-05-12 | Kemper | Mississippi | 28069 | 2187 | 48 |
2497786 | 2497786 | 2022-05-12 | Noxubee | Mississippi | 28103 | 2730 | 48 |
2497806 | 2497806 | 2022-05-12 | Tunica | Mississippi | 28143 | 2559 | 48 |
2497943 | 2497943 | 2022-05-12 | Custer | Montana | 30017 | 3060 | 48 |
2498244 | 2498244 | 2022-05-12 | Caswell | North Carolina | 37033 | 5357 | 48 |
2498553 | 2498553 | 2022-05-12 | Baker | Oregon | 41001 | 3230 | 48 |
2498941 | 2498941 | 2022-05-12 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2498977 | 2498977 | 2022-05-12 | Calhoun | Texas | 48057 | 5729 | 48 |
2499025 | 2499025 | 2022-05-12 | Floyd | Texas | 48153 | 1961 | 48 |
2499087 | 2499087 | 2022-05-12 | La Salle | Texas | 48283 | 2421 | 48 |
2499127 | 2499127 | 2022-05-12 | Ochiltree | Texas | 48357 | 2424 | 48 |
2499332 | 2499332 | 2022-05-12 | Middlesex | Virginia | 51119 | 1872 | 48 |
2499532 | 2499532 | 2022-05-12 | Richland | Wisconsin | 55103 | 3988 | 48 |
2493233 | 2493233 | 2022-05-11 | Searcy | Arkansas | 5129 | 2125 | 48 |
2493569 | 2493569 | 2022-05-11 | Randolph | Georgia | 13243 | 1490 | 48 |
2493645 | 2493645 | 2022-05-11 | Latah | Idaho | 16057 | 6787 | 48 |
2493910 | 2493910 | 2022-05-11 | Keokuk | Iowa | 19107 | 2085 | 48 |
2493923 | 2493923 | 2022-05-11 | Monona | Iowa | 19133 | 1723 | 48 |
2494068 | 2494068 | 2022-05-11 | Bath | Kentucky | 21011 | 3210 | 48 |
2494364 | 2494364 | 2022-05-11 | Montmorency | Michigan | 26119 | 1750 | 48 |
2494400 | 2494400 | 2022-05-11 | Chippewa | Minnesota | 27023 | 3115 | 48 |
2494511 | 2494511 | 2022-05-11 | Kemper | Mississippi | 28069 | 2187 | 48 |
2494528 | 2494528 | 2022-05-11 | Noxubee | Mississippi | 28103 | 2730 | 48 |
2494548 | 2494548 | 2022-05-11 | Tunica | Mississippi | 28143 | 2559 | 48 |
2494685 | 2494685 | 2022-05-11 | Custer | Montana | 30017 | 3060 | 48 |
2494986 | 2494986 | 2022-05-11 | Caswell | North Carolina | 37033 | 5357 | 48 |
2495295 | 2495295 | 2022-05-11 | Baker | Oregon | 41001 | 3226 | 48 |
2495683 | 2495683 | 2022-05-11 | Van Buren | Tennessee | 47175 | 1852 | 48 |
2495719 | 2495719 | 2022-05-11 | Calhoun | Texas | 48057 | 5729 | 48 |
2495767 | 2495767 | 2022-05-11 | Floyd | Texas | 48153 | 1961 | 48 |
2495829 | 2495829 | 2022-05-11 | La Salle | Texas | 48283 | 2421 | 48 |
2495858 | 2495858 | 2022-05-11 | Mitchell | Texas | 48335 | 1864 | 48 |
2495869 | 2495869 | 2022-05-11 | Ochiltree | Texas | 48357 | 2424 | 48 |
2496074 | 2496074 | 2022-05-11 | Middlesex | Virginia | 51119 | 1868 | 48 |
2496274 | 2496274 | 2022-05-11 | Richland | Wisconsin | 55103 | 3976 | 48 |
2489975 | 2489975 | 2022-05-10 | Searcy | Arkansas | 5129 | 2124 | 48 |
2490311 | 2490311 | 2022-05-10 | Randolph | Georgia | 13243 | 1490 | 48 |
2490387 | 2490387 | 2022-05-10 | Latah | Idaho | 16057 | 6775 | 48 |
2490652 | 2490652 | 2022-05-10 | Keokuk | Iowa | 19107 | 2083 | 48 |
2490665 | 2490665 | 2022-05-10 | Monona | Iowa | 19133 | 1720 | 48 |
2490810 | 2490810 | 2022-05-10 | Bath | Kentucky | 21011 | 3210 | 48 |
2491106 | 2491106 | 2022-05-10 | Montmorency | Michigan | 26119 | 1745 | 48 |
2491142 | 2491142 | 2022-05-10 | Chippewa | Minnesota | 27023 | 3112 | 48 |
2491253 | 2491253 | 2022-05-10 | Kemper | Mississippi | 28069 | 2187 | 48 |
2491270 | 2491270 | 2022-05-10 | Noxubee | Mississippi | 28103 | 2730 | 48 |
2491290 | 2491290 | 2022-05-10 | Tunica | Mississippi | 28143 | 2559 | 48 |
2491427 | 2491427 | 2022-05-10 | Custer | Montana | 30017 | 3060 | 48 |
2491728 | 2491728 | 2022-05-10 | Caswell | North Carolina | 37033 | 5325 | 48 |
2492037 | 2492037 | 2022-05-10 | Baker | Oregon | 41001 | 3226 | 48 |
2492425 | 2492425 | 2022-05-10 | Van Buren | Tennessee | 47175 | 1851 | 48 |
2492461 | 2492461 | 2022-05-10 | Calhoun | Texas | 48057 | 5727 | 48 |
2492509 | 2492509 | 2022-05-10 | Floyd | Texas | 48153 | 1960 | 48 |
2492571 | 2492571 | 2022-05-10 | La Salle | Texas | 48283 | 2421 | 48 |
2492600 | 2492600 | 2022-05-10 | Mitchell | Texas | 48335 | 1864 | 48 |
2492611 | 2492611 | 2022-05-10 | Ochiltree | Texas | 48357 | 2424 | 48 |
2492816 | 2492816 | 2022-05-10 | Middlesex | Virginia | 51119 | 1865 | 48 |
2493016 | 2493016 | 2022-05-10 | Richland | Wisconsin | 55103 | 3969 | 48 |
2486718 | 2486718 | 2022-05-09 | Searcy | Arkansas | 5129 | 2123 | 48 |
2487054 | 2487054 | 2022-05-09 | Randolph | Georgia | 13243 | 1490 | 48 |
2487130 | 2487130 | 2022-05-09 | Latah | Idaho | 16057 | 6775 | 48 |
2487395 | 2487395 | 2022-05-09 | Keokuk | Iowa | 19107 | 2083 | 48 |
2487408 | 2487408 | 2022-05-09 | Monona | Iowa | 19133 | 1720 | 48 |
2487553 | 2487553 | 2022-05-09 | Bath | Kentucky | 21011 | 3210 | 48 |
2487849 | 2487849 | 2022-05-09 | Montmorency | Michigan | 26119 | 1745 | 48 |
2487885 | 2487885 | 2022-05-09 | Chippewa | Minnesota | 27023 | 3105 | 48 |
2487996 | 2487996 | 2022-05-09 | Kemper | Mississippi | 28069 | 2187 | 48 |
2488013 | 2488013 | 2022-05-09 | Noxubee | Mississippi | 28103 | 2730 | 48 |
2488033 | 2488033 | 2022-05-09 | Tunica | Mississippi | 28143 | 2559 | 48 |
2488169 | 2488169 | 2022-05-09 | Custer | Montana | 30017 | 3060 | 48 |
2488470 | 2488470 | 2022-05-09 | Caswell | North Carolina | 37033 | 5325 | 48 |
2488779 | 2488779 | 2022-05-09 | Baker | Oregon | 41001 | 3226 | 48 |
2489167 | 2489167 | 2022-05-09 | Van Buren | Tennessee | 47175 | 1851 | 48 |
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);