ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
568 rows where cases = 569 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kansas 62
- Texas 41
- Georgia 34
- Virginia 33
- North Dakota 28
- Kentucky 24
- Minnesota 20
- Illinois 19
- Michigan 19
- North Carolina 18
- Idaho 17
- Puerto Rico 17
- South Dakota 17
- Iowa 15
- Mississippi 15
- Oklahoma 15
- Alaska 12
- Arkansas 12
- New Mexico 11
- Alabama 10
- Missouri 10
- Tennessee 10
- West Virginia 10
- Ohio 9
- Florida 8
- Montana 7
- Colorado 6
- Indiana 6
- Nebraska 6
- Wisconsin 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2489893 | 2489893 | 2022-05-10 | Wrangell City and Borough | Alaska | 2275 | 569 | 1 |
2486636 | 2486636 | 2022-05-09 | Wrangell City and Borough | Alaska | 2275 | 569 | 1 |
2483378 | 2483378 | 2022-05-08 | Wrangell City and Borough | Alaska | 2275 | 569 | 1 |
2480120 | 2480120 | 2022-05-07 | Wrangell City and Borough | Alaska | 2275 | 569 | 1 |
2476862 | 2476862 | 2022-05-06 | Wrangell City and Borough | Alaska | 2275 | 569 | 1 |
2473604 | 2473604 | 2022-05-05 | Wrangell City and Borough | Alaska | 2275 | 569 | 1 |
2470347 | 2470347 | 2022-05-04 | Wrangell City and Borough | Alaska | 2275 | 569 | 1 |
2451642 | 2451642 | 2022-04-28 | Elk | Kansas | 20049 | 569 | 10 |
2448386 | 2448386 | 2022-04-27 | Elk | Kansas | 20049 | 569 | 10 |
2445130 | 2445130 | 2022-04-26 | Elk | Kansas | 20049 | 569 | 10 |
2446700 | 2446700 | 2022-04-26 | Faulk | South Dakota | 46049 | 569 | 16 |
2441874 | 2441874 | 2022-04-25 | Elk | Kansas | 20049 | 569 | 10 |
2443445 | 2443445 | 2022-04-25 | Faulk | South Dakota | 46049 | 569 | 16 |
2438618 | 2438618 | 2022-04-24 | Elk | Kansas | 20049 | 569 | 10 |
2440189 | 2440189 | 2022-04-24 | Faulk | South Dakota | 46049 | 569 | 16 |
2435362 | 2435362 | 2022-04-23 | Elk | Kansas | 20049 | 569 | 10 |
2436933 | 2436933 | 2022-04-23 | Faulk | South Dakota | 46049 | 569 | 16 |
2432106 | 2432106 | 2022-04-22 | Elk | Kansas | 20049 | 569 | 10 |
2433677 | 2433677 | 2022-04-22 | Faulk | South Dakota | 46049 | 569 | 16 |
2430421 | 2430421 | 2022-04-21 | Faulk | South Dakota | 46049 | 569 | 16 |
2427165 | 2427165 | 2022-04-20 | Faulk | South Dakota | 46049 | 569 | 16 |
2404050 | 2404050 | 2022-04-13 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2400795 | 2400795 | 2022-04-12 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2397540 | 2397540 | 2022-04-11 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2394285 | 2394285 | 2022-04-10 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2391029 | 2391029 | 2022-04-09 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2387773 | 2387773 | 2022-04-08 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2384518 | 2384518 | 2022-04-07 | Cimarron | Oklahoma | 40025 | 569 | 7 |
2338831 | 2338831 | 2022-03-24 | Griggs | North Dakota | 38039 | 569 | 2 |
2335577 | 2335577 | 2022-03-23 | Griggs | North Dakota | 38039 | 569 | 2 |
2332323 | 2332323 | 2022-03-22 | Griggs | North Dakota | 38039 | 569 | 2 |
2329070 | 2329070 | 2022-03-21 | Griggs | North Dakota | 38039 | 569 | 2 |
2325818 | 2325818 | 2022-03-20 | Griggs | North Dakota | 38039 | 569 | 2 |
2322565 | 2322565 | 2022-03-19 | Griggs | North Dakota | 38039 | 569 | 2 |
2319311 | 2319311 | 2022-03-18 | Griggs | North Dakota | 38039 | 569 | 2 |
2314951 | 2314951 | 2022-03-17 | Elk | Kansas | 20049 | 569 | 8 |
2316057 | 2316057 | 2022-03-17 | Griggs | North Dakota | 38039 | 569 | 2 |
2311698 | 2311698 | 2022-03-16 | Elk | Kansas | 20049 | 569 | 8 |
2312804 | 2312804 | 2022-03-16 | Griggs | North Dakota | 38039 | 569 | 2 |
2308445 | 2308445 | 2022-03-15 | Elk | Kansas | 20049 | 569 | 8 |
2309551 | 2309551 | 2022-03-15 | Griggs | North Dakota | 38039 | 569 | 2 |
2305194 | 2305194 | 2022-03-14 | Elk | Kansas | 20049 | 569 | 8 |
2306298 | 2306298 | 2022-03-14 | Griggs | North Dakota | 38039 | 569 | 2 |
2301942 | 2301942 | 2022-03-13 | Elk | Kansas | 20049 | 569 | 8 |
2302843 | 2302843 | 2022-03-13 | De Baca | New Mexico | 35011 | 569 | 5 |
2303047 | 2303047 | 2022-03-13 | Griggs | North Dakota | 38039 | 569 | 2 |
2298690 | 2298690 | 2022-03-12 | Elk | Kansas | 20049 | 569 | 8 |
2299591 | 2299591 | 2022-03-12 | De Baca | New Mexico | 35011 | 569 | 5 |
2299795 | 2299795 | 2022-03-12 | Griggs | North Dakota | 38039 | 569 | 2 |
2295438 | 2295438 | 2022-03-11 | Elk | Kansas | 20049 | 569 | 8 |
2296339 | 2296339 | 2022-03-11 | De Baca | New Mexico | 35011 | 569 | 5 |
2292186 | 2292186 | 2022-03-10 | Elk | Kansas | 20049 | 569 | 8 |
2288934 | 2288934 | 2022-03-09 | Elk | Kansas | 20049 | 569 | 8 |
2285683 | 2285683 | 2022-03-08 | Elk | Kansas | 20049 | 569 | 8 |
2282431 | 2282431 | 2022-03-07 | Elk | Kansas | 20049 | 569 | 8 |
2279178 | 2279178 | 2022-03-06 | Elk | Kansas | 20049 | 569 | 8 |
2275925 | 2275925 | 2022-03-05 | Elk | Kansas | 20049 | 569 | 8 |
2272672 | 2272672 | 2022-03-04 | Elk | Kansas | 20049 | 569 | 8 |
2256414 | 2256414 | 2022-02-27 | Elk | Kansas | 20049 | 569 | 8 |
2253163 | 2253163 | 2022-02-26 | Elk | Kansas | 20049 | 569 | 8 |
2249912 | 2249912 | 2022-02-25 | Elk | Kansas | 20049 | 569 | 8 |
2215236 | 2215236 | 2022-02-14 | Adams | North Dakota | 38001 | 569 | 9 |
2211985 | 2211985 | 2022-02-13 | Adams | North Dakota | 38001 | 569 | 9 |
2208732 | 2208732 | 2022-02-12 | Adams | North Dakota | 38001 | 569 | 9 |
2155122 | 2155122 | 2022-01-27 | Glascock | Georgia | 13125 | 569 | 23 |
2127860 | 2127860 | 2022-01-18 | Buffalo | South Dakota | 46017 | 569 | 17 |
2123796 | 2123796 | 2022-01-17 | Sheridan | Montana | 30091 | 569 | 10 |
2120544 | 2120544 | 2022-01-16 | Sheridan | Montana | 30091 | 569 | 10 |
2117292 | 2117292 | 2022-01-15 | Sheridan | Montana | 30091 | 569 | 10 |
2114041 | 2114041 | 2022-01-14 | Sheridan | Montana | 30091 | 569 | 10 |
2114413 | 2114413 | 2022-01-14 | McIntosh | North Dakota | 38051 | 569 | 9 |
2105292 | 2105292 | 2022-01-11 | Cochran | Texas | 48079 | 569 | 21 |
2099051 | 2099051 | 2022-01-09 | St. John | Virgin Islands | 78020 | 569 | 5 |
2087997 | 2087997 | 2022-01-06 | Fallon | Montana | 30025 | 569 | 10 |
2083677 | 2083677 | 2022-01-05 | Adams | Idaho | 16003 | 569 | 14 |
2084745 | 2084745 | 2022-01-05 | Fallon | Montana | 30025 | 569 | 10 |
2080425 | 2080425 | 2022-01-04 | Adams | Idaho | 16003 | 569 | 14 |
2063297 | 2063297 | 2021-12-29 | Bath | Virginia | 51017 | 569 | 15 |
2035327 | 2035327 | 2021-12-21 | Ness | Kansas | 20135 | 569 | 17 |
2032077 | 2032077 | 2021-12-20 | Ness | Kansas | 20135 | 569 | 17 |
2019060 | 2019060 | 2021-12-16 | Logan | Kansas | 20109 | 569 | 9 |
2015810 | 2015810 | 2021-12-15 | Logan | Kansas | 20109 | 569 | 9 |
1989101 | 1989101 | 2021-12-07 | Baca | Colorado | 8009 | 569 | 6 |
1984367 | 1984367 | 2021-12-05 | Cavalier | North Dakota | 38019 | 569 | 5 |
1962064 | 1962064 | 2021-11-28 | Aurora | South Dakota | 46003 | 569 | 17 |
1958813 | 1958813 | 2021-11-27 | Aurora | South Dakota | 46003 | 569 | 17 |
1955562 | 1955562 | 2021-11-26 | Aurora | South Dakota | 46003 | 569 | 17 |
1952311 | 1952311 | 2021-11-25 | Aurora | South Dakota | 46003 | 569 | 17 |
1949060 | 1949060 | 2021-11-24 | Aurora | South Dakota | 46003 | 569 | 17 |
1939225 | 1939225 | 2021-11-21 | Maunabo | Puerto Rico | 72095 | 569 | |
1935975 | 1935975 | 2021-11-20 | Maunabo | Puerto Rico | 72095 | 569 | |
1932725 | 1932725 | 2021-11-19 | Maunabo | Puerto Rico | 72095 | 569 | |
1927179 | 1927179 | 2021-11-18 | Prince of Wales-Hyder Census Area | Alaska | 2198 | 569 | 6 |
1929474 | 1929474 | 2021-11-18 | Maunabo | Puerto Rico | 72095 | 569 | |
1917937 | 1917937 | 2021-11-15 | Oneida | Idaho | 16071 | 569 | 10 |
1905023 | 1905023 | 2021-11-11 | Pope | Illinois | 17151 | 569 | 6 |
1901773 | 1901773 | 2021-11-10 | Pope | Illinois | 17151 | 569 | 6 |
1898523 | 1898523 | 2021-11-09 | Pope | Illinois | 17151 | 569 | 6 |
1899251 | 1899251 | 2021-11-09 | Traverse | Minnesota | 27155 | 569 | 6 |
1895273 | 1895273 | 2021-11-08 | Pope | Illinois | 17151 | 569 | 6 |
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);