ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
655 rows where cases = 542 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Nebraska 69
- Texas 67
- Puerto Rico 40
- Missouri 36
- Georgia 33
- Kansas 32
- North Dakota 27
- Virginia 25
- Kentucky 19
- South Dakota 19
- West Virginia 19
- Colorado 18
- Minnesota 18
- Indiana 15
- Louisiana 15
- Mississippi 14
- North Carolina 13
- Michigan 12
- Tennessee 12
- Iowa 11
- Alabama 10
- Illinois 10
- Oregon 10
- Alaska 9
- Ohio 9
- Oklahoma 9
- Idaho 8
- Pennsylvania 8
- Washington 7
- Arkansas 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2498034 | 2498034 | 2022-05-12 | Hitchcock | Nebraska | 31087 | 542 | 8 |
2494776 | 2494776 | 2022-05-11 | Hitchcock | Nebraska | 31087 | 542 | 8 |
2491490 | 2491490 | 2022-05-10 | Cherry | Nebraska | 31031 | 542 | 10 |
2488232 | 2488232 | 2022-05-09 | Cherry | Nebraska | 31031 | 542 | 10 |
2467092 | 2467092 | 2022-05-03 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 542 | 5 |
2468688 | 2468688 | 2022-05-03 | Cherry | Nebraska | 31031 | 542 | 10 |
2463837 | 2463837 | 2022-05-02 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 542 | 5 |
2465432 | 2465432 | 2022-05-02 | Cherry | Nebraska | 31031 | 542 | 10 |
2460581 | 2460581 | 2022-05-01 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 542 | 5 |
2462177 | 2462177 | 2022-05-01 | Cherry | Nebraska | 31031 | 542 | 10 |
2457325 | 2457325 | 2022-04-30 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 542 | 5 |
2458921 | 2458921 | 2022-04-30 | Cherry | Nebraska | 31031 | 542 | 10 |
2454069 | 2454069 | 2022-04-29 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 542 | 5 |
2455665 | 2455665 | 2022-04-29 | Cherry | Nebraska | 31031 | 542 | 10 |
2450813 | 2450813 | 2022-04-28 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 542 | 5 |
2452409 | 2452409 | 2022-04-28 | Cherry | Nebraska | 31031 | 542 | 10 |
2447557 | 2447557 | 2022-04-27 | Yakutat plus Hoonah-Angoon | Alaska | 2998 | 542 | 5 |
2449153 | 2449153 | 2022-04-27 | Cherry | Nebraska | 31031 | 542 | 10 |
2445896 | 2445896 | 2022-04-26 | Cherry | Nebraska | 31031 | 542 | 10 |
2419864 | 2419864 | 2022-04-18 | Frontier | Nebraska | 31063 | 542 | 3 |
2416609 | 2416609 | 2022-04-17 | Frontier | Nebraska | 31063 | 542 | 3 |
2413353 | 2413353 | 2022-04-16 | Frontier | Nebraska | 31063 | 542 | 3 |
2410097 | 2410097 | 2022-04-15 | Frontier | Nebraska | 31063 | 542 | 3 |
2406841 | 2406841 | 2022-04-14 | Frontier | Nebraska | 31063 | 542 | 3 |
2403585 | 2403585 | 2022-04-13 | Frontier | Nebraska | 31063 | 542 | 3 |
2400330 | 2400330 | 2022-04-12 | Frontier | Nebraska | 31063 | 542 | 2 |
2397075 | 2397075 | 2022-04-11 | Frontier | Nebraska | 31063 | 542 | 2 |
2393820 | 2393820 | 2022-04-10 | Frontier | Nebraska | 31063 | 542 | 2 |
2390564 | 2390564 | 2022-04-09 | Frontier | Nebraska | 31063 | 542 | 2 |
2387308 | 2387308 | 2022-04-08 | Frontier | Nebraska | 31063 | 542 | 2 |
2384053 | 2384053 | 2022-04-07 | Frontier | Nebraska | 31063 | 542 | 2 |
2380798 | 2380798 | 2022-04-06 | Frontier | Nebraska | 31063 | 542 | 2 |
2377543 | 2377543 | 2022-04-05 | Frontier | Nebraska | 31063 | 542 | 2 |
2374290 | 2374290 | 2022-04-04 | Frontier | Nebraska | 31063 | 542 | 2 |
2371038 | 2371038 | 2022-04-03 | Frontier | Nebraska | 31063 | 542 | 2 |
2367785 | 2367785 | 2022-04-02 | Frontier | Nebraska | 31063 | 542 | 2 |
2364532 | 2364532 | 2022-04-01 | Frontier | Nebraska | 31063 | 542 | 2 |
2361278 | 2361278 | 2022-03-31 | Frontier | Nebraska | 31063 | 542 | 2 |
2348266 | 2348266 | 2022-03-27 | Frontier | Nebraska | 31063 | 542 | 2 |
2345013 | 2345013 | 2022-03-26 | Frontier | Nebraska | 31063 | 542 | 2 |
2341760 | 2341760 | 2022-03-25 | Frontier | Nebraska | 31063 | 542 | 2 |
2309227 | 2309227 | 2022-03-15 | Frontier | Nebraska | 31063 | 542 | 2 |
2305975 | 2305975 | 2022-03-14 | Frontier | Nebraska | 31063 | 542 | 2 |
2302724 | 2302724 | 2022-03-13 | Frontier | Nebraska | 31063 | 542 | 2 |
2299472 | 2299472 | 2022-03-12 | Frontier | Nebraska | 31063 | 542 | 2 |
2296220 | 2296220 | 2022-03-11 | Frontier | Nebraska | 31063 | 542 | 2 |
2292968 | 2292968 | 2022-03-10 | Frontier | Nebraska | 31063 | 542 | 2 |
2289716 | 2289716 | 2022-03-09 | Frontier | Nebraska | 31063 | 542 | 2 |
2286448 | 2286448 | 2022-03-08 | Cherry | Nebraska | 31031 | 542 | 8 |
2286464 | 2286464 | 2022-03-08 | Frontier | Nebraska | 31063 | 542 | 2 |
2279600 | 2279600 | 2022-03-06 | Cook | Minnesota | 27031 | 542 | 4 |
2276347 | 2276347 | 2022-03-05 | Cook | Minnesota | 27031 | 542 | 4 |
2273094 | 2273094 | 2022-03-04 | Cook | Minnesota | 27031 | 542 | 4 |
2231866 | 2231866 | 2022-02-19 | Maricao | Puerto Rico | 72093 | 542 | |
2228615 | 2228615 | 2022-02-18 | Maricao | Puerto Rico | 72093 | 542 | |
2225364 | 2225364 | 2022-02-17 | Maricao | Puerto Rico | 72093 | 542 | |
2202263 | 2202263 | 2022-02-10 | Renville | North Dakota | 38075 | 542 | 15 |
2163906 | 2163906 | 2022-01-29 | Hardeman | Texas | 48197 | 542 | 14 |
2153442 | 2153442 | 2022-01-26 | Griggs | North Dakota | 38039 | 542 | 2 |
2151407 | 2151407 | 2022-01-25 | Niobrara | Wyoming | 56027 | 542 | 8 |
2125647 | 2125647 | 2022-01-18 | Custer | Colorado | 8027 | 542 | 16 |
2126349 | 2126349 | 2022-01-18 | Morton | Kansas | 20129 | 542 | 10 |
2123097 | 2123097 | 2022-01-17 | Morton | Kansas | 20129 | 542 | 10 |
2119845 | 2119845 | 2022-01-16 | Morton | Kansas | 20129 | 542 | 10 |
2116593 | 2116593 | 2022-01-15 | Morton | Kansas | 20129 | 542 | 10 |
2113342 | 2113342 | 2022-01-14 | Morton | Kansas | 20129 | 542 | 10 |
2107471 | 2107471 | 2022-01-12 | Scotland | Missouri | 29199 | 542 | 17 |
2095634 | 2095634 | 2022-01-08 | Kinney | Texas | 48271 | 542 | 10 |
2081430 | 2081430 | 2022-01-04 | Mercer | Missouri | 29129 | 542 | 11 |
2068892 | 2068892 | 2021-12-31 | McIntosh | North Dakota | 38051 | 542 | 9 |
2031404 | 2031404 | 2021-12-20 | Ouray | Colorado | 8091 | 542 | 6 |
2006073 | 2006073 | 2021-12-12 | Osborne | Kansas | 20141 | 542 | 15 |
2006100 | 2006100 | 2021-12-12 | Trego | Kansas | 20195 | 542 | 8 |
2002822 | 2002822 | 2021-12-11 | Osborne | Kansas | 20141 | 542 | 15 |
2002849 | 2002849 | 2021-12-11 | Trego | Kansas | 20195 | 542 | 8 |
1999572 | 1999572 | 2021-12-10 | Osborne | Kansas | 20141 | 542 | 15 |
1999599 | 1999599 | 2021-12-10 | Trego | Kansas | 20195 | 542 | 8 |
1990614 | 1990614 | 2021-12-07 | Webster | Nebraska | 31181 | 542 | 9 |
1972674 | 1972674 | 2021-12-02 | Bristol Bay plus Lake and Peninsula | Alaska | 2997 | 542 | 1 |
1973567 | 1973567 | 2021-12-02 | Ness | Kansas | 20135 | 542 | 17 |
1974361 | 1974361 | 2021-12-02 | Valley | Nebraska | 31175 | 542 | 5 |
1974628 | 1974628 | 2021-12-02 | Hettinger | North Dakota | 38041 | 542 | 7 |
1970317 | 1970317 | 2021-12-01 | Ness | Kansas | 20135 | 542 | 17 |
1962084 | 1962084 | 2021-11-28 | Douglas | South Dakota | 46043 | 542 | 9 |
1958833 | 1958833 | 2021-11-27 | Douglas | South Dakota | 46043 | 542 | 9 |
1955582 | 1955582 | 2021-11-26 | Douglas | South Dakota | 46043 | 542 | 9 |
1952331 | 1952331 | 2021-11-25 | Douglas | South Dakota | 46043 | 542 | 9 |
1949080 | 1949080 | 2021-11-24 | Douglas | South Dakota | 46043 | 542 | 9 |
1937786 | 1937786 | 2021-11-21 | Jewell | Kansas | 20089 | 542 | 11 |
1934536 | 1934536 | 2021-11-20 | Jewell | Kansas | 20089 | 542 | 11 |
1931285 | 1931285 | 2021-11-19 | Jewell | Kansas | 20089 | 542 | 11 |
1898139 | 1898139 | 2021-11-09 | Phillips | Colorado | 8095 | 542 | 15 |
1893365 | 1893365 | 2021-11-07 | Eddy | North Dakota | 38027 | 542 | 6 |
1890115 | 1890115 | 2021-11-06 | Eddy | North Dakota | 38027 | 542 | 6 |
1886865 | 1886865 | 2021-11-05 | Eddy | North Dakota | 38027 | 542 | 6 |
1883612 | 1883612 | 2021-11-04 | Cavalier | North Dakota | 38019 | 542 | 5 |
1871514 | 1871514 | 2021-10-31 | Essex | Vermont | 50009 | 542 | 2 |
1867037 | 1867037 | 2021-10-30 | Chase | Nebraska | 31029 | 542 | 5 |
1863788 | 1863788 | 2021-10-29 | Chase | Nebraska | 31029 | 542 | 5 |
1861574 | 1861574 | 2021-10-28 | Hall | Texas | 48191 | 542 | 15 |
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);