ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
252 rows where cases = 2350 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Iowa 23
- Georgia 16
- Indiana 16
- Ohio 16
- Kentucky 15
- Missouri 13
- Texas 13
- Virginia 12
- Maryland 11
- Kansas 9
- Idaho 8
- North Carolina 8
- Michigan 7
- Nebraska 7
- Mississippi 6
- Puerto Rico 6
- Tennessee 6
- Arkansas 5
- Illinois 5
- Wisconsin 5
- Minnesota 4
- New York 4
- Alabama 3
- Colorado 3
- Louisiana 3
- Maine 3
- South Carolina 3
- West Virginia 3
- Montana 2
- North Dakota 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2471997 | 2471997 | 2022-05-04 | Phelps | Nebraska | 31137 | 2350 | 14 |
2468741 | 2468741 | 2022-05-03 | Phelps | Nebraska | 31137 | 2350 | 14 |
2465371 | 2465371 | 2022-05-02 | Dawson | Montana | 30021 | 2350 | 58 |
2465423 | 2465423 | 2022-05-02 | Box Butte | Nebraska | 31013 | 2350 | 17 |
2462168 | 2462168 | 2022-05-01 | Box Butte | Nebraska | 31013 | 2350 | 17 |
2458912 | 2458912 | 2022-04-30 | Box Butte | Nebraska | 31013 | 2350 | 17 |
2455656 | 2455656 | 2022-04-29 | Box Butte | Nebraska | 31013 | 2350 | 17 |
2422252 | 2422252 | 2022-04-19 | Guthrie | Iowa | 19077 | 2350 | 45 |
2418996 | 2418996 | 2022-04-18 | Guthrie | Iowa | 19077 | 2350 | 45 |
2415740 | 2415740 | 2022-04-17 | Guthrie | Iowa | 19077 | 2350 | 45 |
2417674 | 2417674 | 2022-04-17 | La Salle | Texas | 48283 | 2350 | 48 |
2412484 | 2412484 | 2022-04-16 | Guthrie | Iowa | 19077 | 2350 | 45 |
2414418 | 2414418 | 2022-04-16 | La Salle | Texas | 48283 | 2350 | 48 |
2409228 | 2409228 | 2022-04-15 | Guthrie | Iowa | 19077 | 2350 | 45 |
2411162 | 2411162 | 2022-04-15 | La Salle | Texas | 48283 | 2350 | 48 |
2405972 | 2405972 | 2022-04-14 | Guthrie | Iowa | 19077 | 2350 | 45 |
2407906 | 2407906 | 2022-04-14 | La Salle | Texas | 48283 | 2350 | 48 |
2408144 | 2408144 | 2022-04-14 | Madison | Virginia | 51113 | 2350 | 40 |
2402716 | 2402716 | 2022-04-13 | Guthrie | Iowa | 19077 | 2350 | 45 |
2339807 | 2339807 | 2022-03-24 | Lunenburg | Virginia | 51111 | 2350 | 35 |
2279352 | 2279352 | 2022-03-06 | Owen | Kentucky | 21187 | 2350 | 32 |
2276099 | 2276099 | 2022-03-05 | Owen | Kentucky | 21187 | 2350 | 32 |
2272846 | 2272846 | 2022-03-04 | Owen | Kentucky | 21187 | 2350 | 32 |
2240849 | 2240849 | 2022-02-22 | Wayne | Missouri | 29223 | 2350 | 44 |
2223976 | 2223976 | 2022-02-17 | Thomas | Kansas | 20193 | 2350 | 27 |
2220725 | 2220725 | 2022-02-16 | Thomas | Kansas | 20193 | 2350 | 27 |
2213718 | 2213718 | 2022-02-14 | McIntosh | Georgia | 13191 | 2350 | 35 |
2191057 | 2191057 | 2022-02-07 | Valley | Idaho | 16085 | 2350 | 15 |
2172448 | 2172448 | 2022-02-01 | Bollinger | Missouri | 29017 | 2350 | 35 |
2173584 | 2173584 | 2022-02-01 | Blanco | Texas | 48031 | 2350 | 30 |
2169617 | 2169617 | 2022-01-31 | Clay | North Carolina | 37043 | 2350 | 38 |
2166837 | 2166837 | 2022-01-30 | Santa Isabel | Puerto Rico | 72133 | 2350 | |
2148974 | 2148974 | 2022-01-25 | Calhoun | Iowa | 19025 | 2350 | 20 |
2145722 | 2145722 | 2022-01-24 | Calhoun | Iowa | 19025 | 2350 | 20 |
2142467 | 2142467 | 2022-01-23 | Calhoun | Iowa | 19025 | 2350 | 20 |
2143213 | 2143213 | 2022-01-23 | Lewis | Missouri | 29111 | 2350 | 31 |
2139212 | 2139212 | 2022-01-22 | Calhoun | Iowa | 19025 | 2350 | 20 |
2135956 | 2135956 | 2022-01-21 | Calhoun | Iowa | 19025 | 2350 | 20 |
2132704 | 2132704 | 2022-01-20 | Calhoun | Iowa | 19025 | 2350 | 20 |
2129451 | 2129451 | 2022-01-19 | Calhoun | Iowa | 19025 | 2350 | 20 |
2094450 | 2094450 | 2022-01-08 | Pemiscot | Missouri | 29155 | 2350 | 59 |
2092499 | 2092499 | 2022-01-07 | Zapata | Texas | 48505 | 2350 | 46 |
2087323 | 2087323 | 2022-01-06 | Marion | Kansas | 20115 | 2350 | 35 |
2084071 | 2084071 | 2022-01-05 | Marion | Kansas | 20115 | 2350 | 35 |
2077028 | 2077028 | 2022-01-03 | Charlton | Georgia | 13049 | 2350 | 58 |
2073777 | 2073777 | 2022-01-02 | Charlton | Georgia | 13049 | 2350 | 58 |
2074893 | 2074893 | 2022-01-02 | Dent | Missouri | 29065 | 2350 | 63 |
2070526 | 2070526 | 2022-01-01 | Charlton | Georgia | 13049 | 2350 | 58 |
2071642 | 2071642 | 2022-01-01 | Dent | Missouri | 29065 | 2350 | 63 |
2067275 | 2067275 | 2021-12-31 | Charlton | Georgia | 13049 | 2350 | 58 |
2068391 | 2068391 | 2021-12-31 | Dent | Missouri | 29065 | 2350 | 63 |
2065140 | 2065140 | 2021-12-30 | Dent | Missouri | 29065 | 2350 | 63 |
2054959 | 2054959 | 2021-12-27 | Pendleton | Kentucky | 21191 | 2350 | 29 |
2056866 | 2056866 | 2021-12-27 | Martinsville city | Virginia | 51690 | 2350 | 95 |
2049458 | 2049458 | 2021-12-25 | Harrison | Ohio | 39067 | 2350 | 58 |
2046208 | 2046208 | 2021-12-24 | Harrison | Ohio | 39067 | 2350 | 58 |
2039270 | 2039270 | 2021-12-22 | Roosevelt | Montana | 30085 | 2350 | 69 |
2011394 | 2011394 | 2021-12-13 | Rockbridge | Virginia | 51163 | 2350 | 67 |
2004987 | 2004987 | 2021-12-11 | Monroe | West Virginia | 54063 | 2350 | 27 |
1963432 | 1963432 | 2021-11-29 | Gooding | Idaho | 16047 | 2350 | 42 |
1947798 | 1947798 | 2021-11-24 | Washington | Maine | 23029 | 2350 | 28 |
1940497 | 1940497 | 2021-11-22 | Bleckley | Georgia | 13023 | 2350 | 81 |
1931372 | 1931372 | 2021-11-19 | Clinton | Kentucky | 21053 | 2350 | 35 |
1928121 | 1928121 | 2021-11-18 | Clinton | Kentucky | 21053 | 2350 | 35 |
1926819 | 1926819 | 2021-11-17 | Giles | Virginia | 51071 | 2350 | 32 |
1921978 | 1921978 | 2021-11-16 | Pennington | Minnesota | 27113 | 2350 | 29 |
1906095 | 1906095 | 2021-11-11 | Seward | Nebraska | 31159 | 2350 | 38 |
1901880 | 1901880 | 2021-11-10 | Tipton | Indiana | 18159 | 2350 | 63 |
1873882 | 1873882 | 2021-11-01 | McKenzie | North Dakota | 38053 | 2350 | 21 |
1869366 | 1869366 | 2021-10-31 | Parke | Indiana | 18121 | 2350 | 30 |
1866117 | 1866117 | 2021-10-30 | Parke | Indiana | 18121 | 2350 | 30 |
1862868 | 1862868 | 2021-10-29 | Parke | Indiana | 18121 | 2350 | 30 |
1861232 | 1861232 | 2021-10-28 | Manati | Puerto Rico | 72091 | 2350 | |
1857495 | 1857495 | 2021-10-27 | Schoharie | New York | 36095 | 2350 | 23 |
1857983 | 1857983 | 2021-10-27 | Manati | Puerto Rico | 72091 | 2350 | |
1832620 | 1832620 | 2021-10-19 | New Kent | Virginia | 51127 | 2350 | 22 |
1811180 | 1811180 | 2021-10-13 | Larue | Kentucky | 21123 | 2350 | 45 |
1807764 | 1807764 | 2021-10-12 | Wright | Iowa | 19197 | 2350 | 44 |
1804513 | 1804513 | 2021-10-11 | Wright | Iowa | 19197 | 2350 | 44 |
1801264 | 1801264 | 2021-10-10 | Wright | Iowa | 19197 | 2350 | 44 |
1798015 | 1798015 | 2021-10-09 | Wright | Iowa | 19197 | 2350 | 44 |
1794766 | 1794766 | 2021-10-08 | Wright | Iowa | 19197 | 2350 | 44 |
1791518 | 1791518 | 2021-10-07 | Wright | Iowa | 19197 | 2350 | 44 |
1788269 | 1788269 | 2021-10-06 | Wright | Iowa | 19197 | 2350 | 44 |
1756140 | 1756140 | 2021-09-26 | Cheboygan | Michigan | 26031 | 2350 | 56 |
1752892 | 1752892 | 2021-09-25 | Cheboygan | Michigan | 26031 | 2350 | 56 |
1749644 | 1749644 | 2021-09-24 | Cheboygan | Michigan | 26031 | 2350 | 56 |
1741519 | 1741519 | 2021-09-21 | Carbon | Utah | 49007 | 2350 | 21 |
1741606 | 1741606 | 2021-09-21 | Fluvanna | Virginia | 51065 | 2350 | 22 |
1728035 | 1728035 | 2021-09-17 | San Lorenzo | Puerto Rico | 72129 | 2350 | |
1724774 | 1724774 | 2021-09-16 | Naranjito | Puerto Rico | 72105 | 2350 | |
1700869 | 1700869 | 2021-09-09 | Garrett | Maryland | 24023 | 2350 | 69 |
1655615 | 1655615 | 2021-08-26 | Holmes | Mississippi | 28051 | 2350 | 79 |
1634580 | 1634580 | 2021-08-19 | Upshur | West Virginia | 54097 | 2350 | 35 |
1626084 | 1626084 | 2021-08-17 | Jackson | Louisiana | 22049 | 2350 | 56 |
1623278 | 1623278 | 2021-08-16 | Ray | Missouri | 29177 | 2350 | 37 |
1619965 | 1619965 | 2021-08-15 | Clinton | Missouri | 29049 | 2350 | 66 |
1612060 | 1612060 | 2021-08-13 | Ashley | Arkansas | 5003 | 2350 | 37 |
1613505 | 1613505 | 2021-08-13 | Livingston | Missouri | 29117 | 2350 | 53 |
1608512 | 1608512 | 2021-08-11 | Adams | Washington | 53001 | 2350 | 24 |
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);