ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
657 rows where cases = 561 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 100
- South Dakota 67
- Texas 52
- Iowa 46
- Puerto Rico 36
- Georgia 27
- Virginia 24
- Minnesota 22
- Nebraska 20
- North Carolina 17
- Alabama 15
- North Dakota 15
- Kentucky 12
- Ohio 12
- Indiana 11
- Michigan 11
- Montana 11
- Arkansas 10
- Mississippi 10
- Tennessee 10
- Illinois 9
- Louisiana 9
- Missouri 9
- New York 9
- Oklahoma 9
- West Virginia 9
- Pennsylvania 8
- South Carolina 8
- Wisconsin 8
- Colorado 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2426017 | 2426017 | 2022-04-20 | Cook | Minnesota | 27031 | 561 | 4 |
2422761 | 2422761 | 2022-04-19 | Cook | Minnesota | 27031 | 561 | 4 |
2423914 | 2423914 | 2022-04-19 | Hand | South Dakota | 46059 | 561 | 12 |
2420658 | 2420658 | 2022-04-18 | Hand | South Dakota | 46059 | 561 | 12 |
2417402 | 2417402 | 2022-04-17 | Hand | South Dakota | 46059 | 561 | 12 |
2414146 | 2414146 | 2022-04-16 | Hand | South Dakota | 46059 | 561 | 12 |
2410890 | 2410890 | 2022-04-15 | Hand | South Dakota | 46059 | 561 | 12 |
2407634 | 2407634 | 2022-04-14 | Hand | South Dakota | 46059 | 561 | 12 |
2404378 | 2404378 | 2022-04-13 | Hand | South Dakota | 46059 | 561 | 12 |
2401123 | 2401123 | 2022-04-12 | Hand | South Dakota | 46059 | 561 | 12 |
2397868 | 2397868 | 2022-04-11 | Hand | South Dakota | 46059 | 561 | 12 |
2394613 | 2394613 | 2022-04-10 | Hand | South Dakota | 46059 | 561 | 12 |
2391357 | 2391357 | 2022-04-09 | Hand | South Dakota | 46059 | 561 | 12 |
2388101 | 2388101 | 2022-04-08 | Hand | South Dakota | 46059 | 561 | 12 |
2384846 | 2384846 | 2022-04-07 | Hand | South Dakota | 46059 | 561 | 12 |
2381591 | 2381591 | 2022-04-06 | Hand | South Dakota | 46059 | 561 | 12 |
2378336 | 2378336 | 2022-04-05 | Hand | South Dakota | 46059 | 561 | 12 |
2375082 | 2375082 | 2022-04-04 | Hand | South Dakota | 46059 | 561 | 12 |
2371830 | 2371830 | 2022-04-03 | Hand | South Dakota | 46059 | 561 | 12 |
2368577 | 2368577 | 2022-04-02 | Hand | South Dakota | 46059 | 561 | 12 |
2365324 | 2365324 | 2022-04-01 | Hand | South Dakota | 46059 | 561 | 12 |
2362071 | 2362071 | 2022-03-31 | Hand | South Dakota | 46059 | 561 | 12 |
2358817 | 2358817 | 2022-03-30 | Hand | South Dakota | 46059 | 561 | 12 |
2355563 | 2355563 | 2022-03-29 | Hand | South Dakota | 46059 | 561 | 12 |
2355876 | 2355876 | 2022-03-29 | Oldham | Texas | 48359 | 561 | 6 |
2352310 | 2352310 | 2022-03-28 | Hand | South Dakota | 46059 | 561 | 12 |
2352623 | 2352623 | 2022-03-28 | Oldham | Texas | 48359 | 561 | 6 |
2349058 | 2349058 | 2022-03-27 | Hand | South Dakota | 46059 | 561 | 12 |
2349371 | 2349371 | 2022-03-27 | Oldham | Texas | 48359 | 561 | 6 |
2345805 | 2345805 | 2022-03-26 | Hand | South Dakota | 46059 | 561 | 12 |
2346118 | 2346118 | 2022-03-26 | Oldham | Texas | 48359 | 561 | 6 |
2342552 | 2342552 | 2022-03-25 | Hand | South Dakota | 46059 | 561 | 12 |
2337724 | 2337724 | 2022-03-24 | Edwards | Kansas | 20047 | 561 | 13 |
2339299 | 2339299 | 2022-03-24 | Hand | South Dakota | 46059 | 561 | 12 |
2334470 | 2334470 | 2022-03-23 | Edwards | Kansas | 20047 | 561 | 13 |
2336045 | 2336045 | 2022-03-23 | Hand | South Dakota | 46059 | 561 | 12 |
2332791 | 2332791 | 2022-03-22 | Hand | South Dakota | 46059 | 561 | 12 |
2329538 | 2329538 | 2022-03-21 | Hand | South Dakota | 46059 | 561 | 12 |
2326286 | 2326286 | 2022-03-20 | Hand | South Dakota | 46059 | 561 | 12 |
2323033 | 2323033 | 2022-03-19 | Hand | South Dakota | 46059 | 561 | 12 |
2319779 | 2319779 | 2022-03-18 | Hand | South Dakota | 46059 | 561 | 12 |
2316525 | 2316525 | 2022-03-17 | Hand | South Dakota | 46059 | 561 | 12 |
2313272 | 2313272 | 2022-03-16 | Hand | South Dakota | 46059 | 561 | 12 |
2310019 | 2310019 | 2022-03-15 | Hand | South Dakota | 46059 | 561 | 11 |
2305158 | 2305158 | 2022-03-14 | Unknown | Iowa | 561 | 0 | |
2301906 | 2301906 | 2022-03-13 | Unknown | Iowa | 561 | 0 | |
2298654 | 2298654 | 2022-03-12 | Unknown | Iowa | 561 | 0 | |
2283998 | 2283998 | 2022-03-07 | Faulk | South Dakota | 46049 | 561 | 16 |
2284003 | 2284003 | 2022-03-07 | Hand | South Dakota | 46059 | 561 | 11 |
2280751 | 2280751 | 2022-03-06 | Hand | South Dakota | 46059 | 561 | 11 |
2277498 | 2277498 | 2022-03-05 | Hand | South Dakota | 46059 | 561 | 11 |
2274245 | 2274245 | 2022-03-04 | Hand | South Dakota | 46059 | 561 | 11 |
2270992 | 2270992 | 2022-03-03 | Hand | South Dakota | 46059 | 561 | 11 |
2267740 | 2267740 | 2022-03-02 | Hand | South Dakota | 46059 | 561 | 11 |
2264487 | 2264487 | 2022-03-01 | Hand | South Dakota | 46059 | 561 | 11 |
2246669 | 2246669 | 2022-02-24 | Graham | Kansas | 20065 | 561 | 13 |
2248233 | 2248233 | 2022-02-24 | Hand | South Dakota | 46059 | 561 | 10 |
2243418 | 2243418 | 2022-02-23 | Graham | Kansas | 20065 | 561 | 13 |
2240990 | 2240990 | 2022-02-22 | Sherman | Nebraska | 31163 | 561 | 4 |
2215255 | 2215255 | 2022-02-14 | Griggs | North Dakota | 38039 | 561 | 2 |
2212004 | 2212004 | 2022-02-13 | Griggs | North Dakota | 38039 | 561 | 2 |
2208751 | 2208751 | 2022-02-12 | Griggs | North Dakota | 38039 | 561 | 2 |
2205498 | 2205498 | 2022-02-11 | Griggs | North Dakota | 38039 | 561 | 2 |
2202245 | 2202245 | 2022-02-10 | Griggs | North Dakota | 38039 | 561 | 2 |
2192483 | 2192483 | 2022-02-07 | Griggs | North Dakota | 38039 | 561 | 2 |
2137908 | 2137908 | 2022-01-21 | Kimble | Texas | 48267 | 561 | 12 |
2111646 | 2111646 | 2022-01-13 | Perkins | South Dakota | 46105 | 561 | 16 |
2108394 | 2108394 | 2022-01-12 | Perkins | South Dakota | 46105 | 561 | 16 |
2095538 | 2095538 | 2022-01-08 | Cochran | Texas | 48079 | 561 | 21 |
2055228 | 2055228 | 2021-12-27 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
2051978 | 2051978 | 2021-12-26 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
2048728 | 2048728 | 2021-12-25 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
2045478 | 2045478 | 2021-12-24 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
2042228 | 2042228 | 2021-12-23 | Lake of the Woods | Minnesota | 27077 | 561 | 5 |
2036023 | 2036023 | 2021-12-21 | Sheridan | Montana | 30091 | 561 | 10 |
2032773 | 2032773 | 2021-12-20 | Sheridan | Montana | 30091 | 561 | 10 |
2029522 | 2029522 | 2021-12-19 | Sheridan | Montana | 30091 | 561 | 10 |
2026271 | 2026271 | 2021-12-18 | Sheridan | Montana | 30091 | 561 | 10 |
2023020 | 2023020 | 2021-12-17 | Sheridan | Montana | 30091 | 561 | 10 |
2024195 | 2024195 | 2021-12-17 | Shackelford | Texas | 48417 | 561 | 7 |
2019769 | 2019769 | 2021-12-16 | Sheridan | Montana | 30091 | 561 | 10 |
2020944 | 2020944 | 2021-12-16 | Shackelford | Texas | 48417 | 561 | 7 |
2013476 | 2013476 | 2021-12-14 | Hamilton | New York | 36041 | 561 | 3 |
1997113 | 1997113 | 2021-12-09 | Valley | Nebraska | 31175 | 561 | 5 |
1993862 | 1993862 | 2021-12-08 | Valley | Nebraska | 31175 | 561 | 5 |
1989825 | 1989825 | 2021-12-07 | Rawlins | Kansas | 20153 | 561 | 7 |
1986575 | 1986575 | 2021-12-06 | Rawlins | Kansas | 20153 | 561 | 7 |
1984827 | 1984827 | 2021-12-05 | Clark | South Dakota | 46025 | 561 | 5 |
1981577 | 1981577 | 2021-12-04 | Clark | South Dakota | 46025 | 561 | 5 |
1978327 | 1978327 | 2021-12-03 | Clark | South Dakota | 46025 | 561 | 5 |
1974621 | 1974621 | 2021-12-02 | Eddy | North Dakota | 38027 | 561 | 6 |
1975077 | 1975077 | 2021-12-02 | Clark | South Dakota | 46025 | 561 | 5 |
1968118 | 1968118 | 2021-11-30 | Cavalier | North Dakota | 38019 | 561 | 5 |
1922317 | 1922317 | 2021-11-16 | Kimball | Nebraska | 31105 | 561 | 9 |
1917430 | 1917430 | 2021-11-15 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 561 | 6 |
1916482 | 1916482 | 2021-11-14 | Patillas | Puerto Rico | 72109 | 561 | |
1913232 | 1913232 | 2021-11-13 | Patillas | Puerto Rico | 72109 | 561 | |
1909982 | 1909982 | 2021-11-12 | Patillas | Puerto Rico | 72109 | 561 | |
1906733 | 1906733 | 2021-11-11 | Patillas | Puerto Rico | 72109 | 561 | |
1903484 | 1903484 | 2021-11-10 | Patillas | Puerto Rico | 72109 | 561 |
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);