ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
711 rows where cases = 410 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 66
- Georgia 46
- Virginia 39
- South Dakota 37
- North Dakota 36
- Texas 32
- Kansas 30
- Louisiana 27
- Missouri 26
- Montana 23
- Puerto Rico 23
- Kentucky 21
- Idaho 20
- Arkansas 18
- Iowa 16
- Michigan 16
- Minnesota 16
- Ohio 15
- West Virginia 14
- Colorado 12
- Illinois 12
- Mississippi 12
- North Carolina 12
- Indiana 11
- Oklahoma 11
- Florida 10
- Utah 10
- California 9
- Oregon 9
- Alabama 8
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491482 | 2491482 | 2022-05-10 | Boyd | Nebraska | 31015 | 410 | 7 |
2488224 | 2488224 | 2022-05-09 | Boyd | Nebraska | 31015 | 410 | 7 |
2471936 | 2471936 | 2022-05-04 | Boyd | Nebraska | 31015 | 410 | 7 |
2468680 | 2468680 | 2022-05-03 | Boyd | Nebraska | 31015 | 410 | 7 |
2400337 | 2400337 | 2022-04-12 | Greeley | Nebraska | 31077 | 410 | 2 |
2397082 | 2397082 | 2022-04-11 | Greeley | Nebraska | 31077 | 410 | 2 |
2393827 | 2393827 | 2022-04-10 | Greeley | Nebraska | 31077 | 410 | 2 |
2390571 | 2390571 | 2022-04-09 | Greeley | Nebraska | 31077 | 410 | 2 |
2387315 | 2387315 | 2022-04-08 | Greeley | Nebraska | 31077 | 410 | 2 |
2384060 | 2384060 | 2022-04-07 | Greeley | Nebraska | 31077 | 410 | 2 |
2380805 | 2380805 | 2022-04-06 | Greeley | Nebraska | 31077 | 410 | 2 |
2377550 | 2377550 | 2022-04-05 | Greeley | Nebraska | 31077 | 410 | 2 |
2374297 | 2374297 | 2022-04-04 | Greeley | Nebraska | 31077 | 410 | 2 |
2371045 | 2371045 | 2022-04-03 | Greeley | Nebraska | 31077 | 410 | 2 |
2367792 | 2367792 | 2022-04-02 | Greeley | Nebraska | 31077 | 410 | 2 |
2364539 | 2364539 | 2022-04-01 | Greeley | Nebraska | 31077 | 410 | 2 |
2361285 | 2361285 | 2022-03-31 | Greeley | Nebraska | 31077 | 410 | 2 |
2358031 | 2358031 | 2022-03-30 | Greeley | Nebraska | 31077 | 410 | 2 |
2354778 | 2354778 | 2022-03-29 | Greeley | Nebraska | 31077 | 410 | 2 |
2351525 | 2351525 | 2022-03-28 | Greeley | Nebraska | 31077 | 410 | 2 |
2348301 | 2348301 | 2022-03-27 | Pawnee | Nebraska | 31133 | 410 | 4 |
2345048 | 2345048 | 2022-03-26 | Pawnee | Nebraska | 31133 | 410 | 4 |
2341795 | 2341795 | 2022-03-25 | Pawnee | Nebraska | 31133 | 410 | 4 |
2335288 | 2335288 | 2022-03-23 | Pawnee | Nebraska | 31133 | 410 | 4 |
2325529 | 2325529 | 2022-03-20 | Pawnee | Nebraska | 31133 | 410 | 4 |
2322275 | 2322275 | 2022-03-19 | Pawnee | Nebraska | 31133 | 410 | 4 |
2319021 | 2319021 | 2022-03-18 | Pawnee | Nebraska | 31133 | 410 | 4 |
2315768 | 2315768 | 2022-03-17 | Pawnee | Nebraska | 31133 | 410 | 4 |
2309262 | 2309262 | 2022-03-15 | Pawnee | Nebraska | 31133 | 410 | 4 |
2291773 | 2291773 | 2022-03-10 | Quitman | Georgia | 13239 | 410 | 4 |
2288521 | 2288521 | 2022-03-09 | Quitman | Georgia | 13239 | 410 | 4 |
2289830 | 2289830 | 2022-03-09 | Catron | New Mexico | 35003 | 410 | 13 |
2285270 | 2285270 | 2022-03-08 | Quitman | Georgia | 13239 | 410 | 4 |
2286499 | 2286499 | 2022-03-08 | Pawnee | Nebraska | 31133 | 410 | 4 |
2286578 | 2286578 | 2022-03-08 | Catron | New Mexico | 35003 | 410 | 13 |
2282018 | 2282018 | 2022-03-07 | Quitman | Georgia | 13239 | 410 | 4 |
2283247 | 2283247 | 2022-03-07 | Pawnee | Nebraska | 31133 | 410 | 4 |
2283326 | 2283326 | 2022-03-07 | Catron | New Mexico | 35003 | 410 | 13 |
2279994 | 2279994 | 2022-03-06 | Pawnee | Nebraska | 31133 | 410 | 4 |
2276741 | 2276741 | 2022-03-05 | Pawnee | Nebraska | 31133 | 410 | 4 |
2273488 | 2273488 | 2022-03-04 | Pawnee | Nebraska | 31133 | 410 | 4 |
2270236 | 2270236 | 2022-03-03 | Pawnee | Nebraska | 31133 | 410 | 4 |
2266983 | 2266983 | 2022-03-02 | Pawnee | Nebraska | 31133 | 410 | 4 |
2263732 | 2263732 | 2022-03-01 | Pawnee | Nebraska | 31133 | 410 | 4 |
2261244 | 2261244 | 2022-02-28 | Jerauld | South Dakota | 46073 | 410 | 20 |
2189893 | 2189893 | 2022-02-06 | Dickens | Texas | 48125 | 410 | 15 |
2170199 | 2170199 | 2022-01-31 | McPherson | South Dakota | 46089 | 410 | 9 |
2154763 | 2154763 | 2022-01-27 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 410 | 5 |
2151510 | 2151510 | 2022-01-26 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 410 | 5 |
2122705 | 2122705 | 2022-01-17 | Butte | Idaho | 16023 | 410 | 7 |
2124159 | 2124159 | 2022-01-17 | Golden Valley | North Dakota | 38033 | 410 | 4 |
2124969 | 2124969 | 2022-01-17 | Schleicher | Texas | 48413 | 410 | 9 |
2119453 | 2119453 | 2022-01-16 | Butte | Idaho | 16023 | 410 | 7 |
2116201 | 2116201 | 2022-01-15 | Butte | Idaho | 16023 | 410 | 7 |
2112950 | 2112950 | 2022-01-14 | Butte | Idaho | 16023 | 410 | 7 |
2107221 | 2107221 | 2022-01-12 | Cook | Minnesota | 27031 | 410 | 1 |
2103556 | 2103556 | 2022-01-11 | Graham | Kansas | 20065 | 410 | 13 |
2100305 | 2100305 | 2022-01-10 | Graham | Kansas | 20065 | 410 | 13 |
2101403 | 2101403 | 2022-01-10 | Kidder | North Dakota | 38043 | 410 | 13 |
2098152 | 2098152 | 2022-01-09 | Kidder | North Dakota | 38043 | 410 | 13 |
2094900 | 2094900 | 2022-01-08 | Kidder | North Dakota | 38043 | 410 | 13 |
2091648 | 2091648 | 2022-01-07 | Kidder | North Dakota | 38043 | 410 | 13 |
2078248 | 2078248 | 2022-01-03 | Granite | Montana | 30039 | 410 | 6 |
1983301 | 1983301 | 2021-12-05 | Lincoln | Kansas | 20105 | 410 | 7 |
1980051 | 1980051 | 2021-12-04 | Lincoln | Kansas | 20105 | 410 | 7 |
1976801 | 1976801 | 2021-12-03 | Lincoln | Kansas | 20105 | 410 | 7 |
1967008 | 1967008 | 2021-11-30 | Chase | Kansas | 20017 | 410 | 4 |
1963756 | 1963756 | 2021-11-29 | Chase | Kansas | 20017 | 410 | 4 |
1964553 | 1964553 | 2021-11-29 | Frontier | Nebraska | 31063 | 410 | 2 |
1942119 | 1942119 | 2021-11-22 | Griggs | North Dakota | 38039 | 410 | 2 |
1938869 | 1938869 | 2021-11-21 | Griggs | North Dakota | 38039 | 410 | 2 |
1935619 | 1935619 | 2021-11-20 | Griggs | North Dakota | 38039 | 410 | 2 |
1921539 | 1921539 | 2021-11-16 | Kiowa | Kansas | 20097 | 410 | 5 |
1923091 | 1923091 | 2021-11-16 | Jackson | South Dakota | 46071 | 410 | 18 |
1918289 | 1918289 | 2021-11-15 | Kiowa | Kansas | 20097 | 410 | 5 |
1919842 | 1919842 | 2021-11-15 | Jackson | South Dakota | 46071 | 410 | 17 |
1915780 | 1915780 | 2021-11-14 | Cherry | Nebraska | 31031 | 410 | 8 |
1912530 | 1912530 | 2021-11-13 | Cherry | Nebraska | 31031 | 410 | 8 |
1909280 | 1909280 | 2021-11-12 | Cherry | Nebraska | 31031 | 410 | 8 |
1906031 | 1906031 | 2021-11-11 | Cherry | Nebraska | 31031 | 410 | 8 |
1906832 | 1906832 | 2021-11-11 | Faulk | South Dakota | 46049 | 410 | 15 |
1903583 | 1903583 | 2021-11-10 | Faulk | South Dakota | 46049 | 410 | 15 |
1898807 | 1898807 | 2021-11-09 | Morton | Kansas | 20129 | 410 | 9 |
1895557 | 1895557 | 2021-11-08 | Morton | Kansas | 20129 | 410 | 9 |
1896639 | 1896639 | 2021-11-08 | Renville | North Dakota | 38075 | 410 | 14 |
1894586 | 1894586 | 2021-11-07 | Niobrara | Wyoming | 56027 | 410 | 5 |
1891336 | 1891336 | 2021-11-06 | Niobrara | Wyoming | 56027 | 410 | 5 |
1888086 | 1888086 | 2021-11-05 | Niobrara | Wyoming | 56027 | 410 | 5 |
1846178 | 1846178 | 2021-10-24 | Unknown | Delaware | 410 | 0 | |
1837059 | 1837059 | 2021-10-21 | Logan | Kansas | 20109 | 410 | 8 |
1833810 | 1833810 | 2021-10-20 | Logan | Kansas | 20109 | 410 | 8 |
1830583 | 1830583 | 2021-10-19 | Rawlins | Kansas | 20153 | 410 | 7 |
1832126 | 1832126 | 2021-10-19 | Potter | South Dakota | 46107 | 410 | 4 |
1827334 | 1827334 | 2021-10-18 | Rawlins | Kansas | 20153 | 410 | 7 |
1828876 | 1828876 | 2021-10-18 | Perkins | South Dakota | 46105 | 410 | 14 |
1816065 | 1816065 | 2021-10-14 | Fisher | Texas | 48151 | 410 | 16 |
1812637 | 1812637 | 2021-10-13 | Stanley | South Dakota | 46117 | 410 | 3 |
1812817 | 1812817 | 2021-10-13 | Fisher | Texas | 48151 | 410 | 16 |
1806939 | 1806939 | 2021-10-12 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 410 | 0 |
1807117 | 1807117 | 2021-10-12 | Baca | Colorado | 8009 | 410 | 5 |
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);