ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
550 rows where cases = 676 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Montana 41
- Kansas 33
- Texas 31
- Virginia 27
- Georgia 26
- Iowa 24
- Missouri 23
- Nebraska 23
- Kentucky 21
- Puerto Rico 21
- Illinois 19
- Michigan 17
- North Carolina 15
- North Dakota 14
- Colorado 12
- Idaho 12
- Minnesota 12
- Washington 12
- Wisconsin 12
- Arkansas 10
- Ohio 10
- South Dakota 10
- West Virginia 10
- Oregon 9
- Tennessee 9
- Florida 8
- Mississippi 8
- Indiana 7
- Wyoming 7
- Alabama 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2406042 | 2406042 | 2022-04-14 | Chase | Kansas | 20017 | 676 | 7 |
2402786 | 2402786 | 2022-04-13 | Chase | Kansas | 20017 | 676 | 7 |
2404720 | 2404720 | 2022-04-13 | Shackelford | Texas | 48417 | 676 | 12 |
2399532 | 2399532 | 2022-04-12 | Chase | Kansas | 20017 | 676 | 7 |
2401465 | 2401465 | 2022-04-12 | Shackelford | Texas | 48417 | 676 | 12 |
2396276 | 2396276 | 2022-04-11 | Chase | Kansas | 20017 | 676 | 7 |
2398210 | 2398210 | 2022-04-11 | Shackelford | Texas | 48417 | 676 | 12 |
2393021 | 2393021 | 2022-04-10 | Chase | Kansas | 20017 | 676 | 7 |
2394955 | 2394955 | 2022-04-10 | Shackelford | Texas | 48417 | 676 | 12 |
2389765 | 2389765 | 2022-04-09 | Chase | Kansas | 20017 | 676 | 7 |
2391699 | 2391699 | 2022-04-09 | Shackelford | Texas | 48417 | 676 | 12 |
2386509 | 2386509 | 2022-04-08 | Chase | Kansas | 20017 | 676 | 7 |
2388443 | 2388443 | 2022-04-08 | Shackelford | Texas | 48417 | 676 | 12 |
2361203 | 2361203 | 2022-03-31 | Fallon | Montana | 30025 | 676 | 10 |
2357949 | 2357949 | 2022-03-30 | Fallon | Montana | 30025 | 676 | 10 |
2354696 | 2354696 | 2022-03-29 | Fallon | Montana | 30025 | 676 | 10 |
2351443 | 2351443 | 2022-03-28 | Fallon | Montana | 30025 | 676 | 10 |
2348191 | 2348191 | 2022-03-27 | Fallon | Montana | 30025 | 676 | 10 |
2344938 | 2344938 | 2022-03-26 | Fallon | Montana | 30025 | 676 | 10 |
2341685 | 2341685 | 2022-03-25 | Fallon | Montana | 30025 | 676 | 10 |
2338432 | 2338432 | 2022-03-24 | Fallon | Montana | 30025 | 676 | 10 |
2335178 | 2335178 | 2022-03-23 | Fallon | Montana | 30025 | 676 | 10 |
2331924 | 2331924 | 2022-03-22 | Fallon | Montana | 30025 | 676 | 10 |
2328671 | 2328671 | 2022-03-21 | Fallon | Montana | 30025 | 676 | 10 |
2325419 | 2325419 | 2022-03-20 | Fallon | Montana | 30025 | 676 | 10 |
2322165 | 2322165 | 2022-03-19 | Fallon | Montana | 30025 | 676 | 10 |
2318911 | 2318911 | 2022-03-18 | Fallon | Montana | 30025 | 676 | 10 |
2315658 | 2315658 | 2022-03-17 | Fallon | Montana | 30025 | 676 | 10 |
2312405 | 2312405 | 2022-03-16 | Fallon | Montana | 30025 | 676 | 10 |
2309152 | 2309152 | 2022-03-15 | Fallon | Montana | 30025 | 676 | 10 |
2305900 | 2305900 | 2022-03-14 | Fallon | Montana | 30025 | 676 | 10 |
2302649 | 2302649 | 2022-03-13 | Fallon | Montana | 30025 | 676 | 10 |
2299397 | 2299397 | 2022-03-12 | Fallon | Montana | 30025 | 676 | 10 |
2296145 | 2296145 | 2022-03-11 | Fallon | Montana | 30025 | 676 | 10 |
2292893 | 2292893 | 2022-03-10 | Fallon | Montana | 30025 | 676 | 10 |
2289641 | 2289641 | 2022-03-09 | Fallon | Montana | 30025 | 676 | 10 |
2286389 | 2286389 | 2022-03-08 | Fallon | Montana | 30025 | 676 | 10 |
2283137 | 2283137 | 2022-03-07 | Fallon | Montana | 30025 | 676 | 10 |
2279884 | 2279884 | 2022-03-06 | Fallon | Montana | 30025 | 676 | 10 |
2276631 | 2276631 | 2022-03-05 | Fallon | Montana | 30025 | 676 | 10 |
2273378 | 2273378 | 2022-03-04 | Fallon | Montana | 30025 | 676 | 10 |
2273783 | 2273783 | 2022-03-04 | McIntosh | North Dakota | 38051 | 676 | 9 |
2240211 | 2240211 | 2022-02-22 | Rawlins | Kansas | 20153 | 676 | 9 |
2236960 | 2236960 | 2022-02-21 | Rawlins | Kansas | 20153 | 676 | 9 |
2226793 | 2226793 | 2022-02-18 | Adams | Idaho | 16003 | 676 | 14 |
2215747 | 2215747 | 2022-02-14 | Perkins | South Dakota | 46105 | 676 | 17 |
2212496 | 2212496 | 2022-02-13 | Perkins | South Dakota | 46105 | 676 | 17 |
2209243 | 2209243 | 2022-02-12 | Perkins | South Dakota | 46105 | 676 | 17 |
2205990 | 2205990 | 2022-02-11 | Perkins | South Dakota | 46105 | 676 | 17 |
2172696 | 2172696 | 2022-02-01 | Stanton | Nebraska | 31167 | 676 | 11 |
2169443 | 2169443 | 2022-01-31 | Stanton | Nebraska | 31167 | 676 | 11 |
2169753 | 2169753 | 2022-01-31 | Unknown | Northern Mariana Islands | 676 | 2 | |
2166498 | 2166498 | 2022-01-30 | Unknown | Northern Mariana Islands | 676 | 2 | |
2156432 | 2156432 | 2022-01-27 | Webster | Nebraska | 31181 | 676 | 9 |
2104403 | 2104403 | 2022-01-11 | Mineral | Nevada | 32021 | 676 | 14 |
2098846 | 2098846 | 2022-01-09 | Hall | Texas | 48191 | 676 | 16 |
2095594 | 2095594 | 2022-01-08 | Hall | Texas | 48191 | 676 | 16 |
2062371 | 2062371 | 2021-12-29 | Bowman | North Dakota | 38011 | 676 | 9 |
2055873 | 2055873 | 2021-12-27 | Bowman | North Dakota | 38011 | 676 | 8 |
2049750 | 2049750 | 2021-12-25 | Patillas | Puerto Rico | 72109 | 676 | |
2039440 | 2039440 | 2021-12-22 | Hidalgo | New Mexico | 35023 | 676 | 12 |
2037076 | 2037076 | 2021-12-21 | Goliad | Texas | 48175 | 676 | 28 |
1996033 | 1996033 | 2021-12-09 | Putnam | Illinois | 17155 | 676 | 6 |
1973239 | 1973239 | 2021-12-02 | Hardin | Illinois | 17069 | 676 | 16 |
1964257 | 1964257 | 2021-11-29 | Unknown | Minnesota | 676 | 124 | |
1944930 | 1944930 | 2021-11-23 | Putnam | Missouri | 29171 | 676 | 19 |
1942140 | 1942140 | 2021-11-22 | Sargent | North Dakota | 38081 | 676 | 8 |
1938890 | 1938890 | 2021-11-21 | Sargent | North Dakota | 38081 | 676 | 8 |
1935640 | 1935640 | 2021-11-20 | Sargent | North Dakota | 38081 | 676 | 8 |
1930007 | 1930007 | 2021-11-18 | Essex | Vermont | 50009 | 676 | 2 |
1925249 | 1925249 | 2021-11-17 | Unknown | Minnesota | 676 | 124 | |
1925901 | 1925901 | 2021-11-17 | Wells | North Dakota | 38103 | 676 | 9 |
1883003 | 1883003 | 2021-11-04 | Unknown | Minnesota | 676 | 124 | |
1877127 | 1877127 | 2021-11-02 | LaMoure | North Dakota | 38045 | 676 | 17 |
1877986 | 1877986 | 2021-11-02 | Garfield | Utah | 49017 | 676 | 12 |
1859160 | 1859160 | 2021-10-28 | Washington | Colorado | 8121 | 676 | 19 |
1855021 | 1855021 | 2021-10-26 | Coke | Texas | 48081 | 676 | 16 |
1851772 | 1851772 | 2021-10-25 | Coke | Texas | 48081 | 676 | 16 |
1832953 | 1832953 | 2021-10-20 | Yukon-Koyukuk Census Area | Alaska | 2290 | 676 | 5 |
1829704 | 1829704 | 2021-10-19 | Yukon-Koyukuk Census Area | Alaska | 2290 | 676 | 5 |
1831255 | 1831255 | 2021-10-19 | Mineral | Montana | 30061 | 676 | 11 |
1831870 | 1831870 | 2021-10-19 | Wallowa | Oregon | 41063 | 676 | 12 |
1824784 | 1824784 | 2021-10-17 | Antelope | Nebraska | 31003 | 676 | 9 |
1821535 | 1821535 | 2021-10-16 | Antelope | Nebraska | 31003 | 676 | 9 |
1818286 | 1818286 | 2021-10-15 | Antelope | Nebraska | 31003 | 676 | 9 |
1815037 | 1815037 | 2021-10-14 | Antelope | Nebraska | 31003 | 676 | 9 |
1808623 | 1808623 | 2021-10-12 | Thayer | Nebraska | 31169 | 676 | 7 |
1804225 | 1804225 | 2021-10-11 | Calhoun | Illinois | 17013 | 676 | 5 |
1800976 | 1800976 | 2021-10-10 | Calhoun | Illinois | 17013 | 676 | 5 |
1797684 | 1797684 | 2021-10-09 | Boise | Idaho | 16015 | 676 | 8 |
1797727 | 1797727 | 2021-10-09 | Calhoun | Illinois | 17013 | 676 | 5 |
1794478 | 1794478 | 2021-10-08 | Calhoun | Illinois | 17013 | 676 | 5 |
1785841 | 1785841 | 2021-10-05 | Howard | Nebraska | 31093 | 676 | 13 |
1783605 | 1783605 | 2021-10-04 | Hemphill | Texas | 48211 | 676 | 3 |
1780356 | 1780356 | 2021-10-03 | Hemphill | Texas | 48211 | 676 | 3 |
1777106 | 1777106 | 2021-10-02 | Hemphill | Texas | 48211 | 676 | 3 |
1763029 | 1763029 | 2021-09-28 | Pondera | Montana | 30073 | 676 | 4 |
1742489 | 1742489 | 2021-09-22 | Alexander | Illinois | 17003 | 676 | 11 |
1738892 | 1738892 | 2021-09-21 | Clear Creek | Colorado | 8019 | 676 | 4 |
1740356 | 1740356 | 2021-09-21 | Johnson | Nebraska | 31097 | 676 | 10 |
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);