ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
363 rows where cases = 1706 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Missouri 58
- Texas 25
- Illinois 23
- Kentucky 23
- Iowa 22
- Arkansas 19
- Mississippi 13
- Alabama 12
- Minnesota 12
- Indiana 11
- Virginia 11
- Idaho 9
- Louisiana 8
- Rhode Island 8
- Georgia 7
- North Carolina 7
- Puerto Rico 7
- Montana 6
- Nebraska 6
- Ohio 6
- Oklahoma 6
- South Dakota 6
- Tennessee 6
- Wisconsin 6
- Kansas 5
- Michigan 5
- South Carolina 5
- California 4
- Utah 4
- Colorado 3
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500661 | 2500661 | 2022-05-13 | Menifee | Kentucky | 21165 | 1706 | 32 |
2497403 | 2497403 | 2022-05-12 | Menifee | Kentucky | 21165 | 1706 | 32 |
2494145 | 2494145 | 2022-05-11 | Menifee | Kentucky | 21165 | 1706 | 32 |
2490887 | 2490887 | 2022-05-10 | Menifee | Kentucky | 21165 | 1706 | 32 |
2487630 | 2487630 | 2022-05-09 | Menifee | Kentucky | 21165 | 1706 | 32 |
2471863 | 2471863 | 2022-05-04 | Sullivan | Missouri | 29211 | 1706 | 21 |
2468607 | 2468607 | 2022-05-03 | Sullivan | Missouri | 29211 | 1706 | 21 |
2465351 | 2465351 | 2022-05-02 | Sullivan | Missouri | 29211 | 1706 | 21 |
2462096 | 2462096 | 2022-05-01 | Sullivan | Missouri | 29211 | 1706 | 21 |
2458840 | 2458840 | 2022-04-30 | Sullivan | Missouri | 29211 | 1706 | 21 |
2455584 | 2455584 | 2022-04-29 | Sullivan | Missouri | 29211 | 1706 | 21 |
2452328 | 2452328 | 2022-04-28 | Sullivan | Missouri | 29211 | 1706 | 21 |
2449072 | 2449072 | 2022-04-27 | Sullivan | Missouri | 29211 | 1706 | 21 |
2445815 | 2445815 | 2022-04-26 | Sullivan | Missouri | 29211 | 1706 | 21 |
2442560 | 2442560 | 2022-04-25 | Sullivan | Missouri | 29211 | 1706 | 21 |
2439304 | 2439304 | 2022-04-24 | Sullivan | Missouri | 29211 | 1706 | 21 |
2436048 | 2436048 | 2022-04-23 | Sullivan | Missouri | 29211 | 1706 | 21 |
2432792 | 2432792 | 2022-04-22 | Sullivan | Missouri | 29211 | 1706 | 21 |
2429536 | 2429536 | 2022-04-21 | Sullivan | Missouri | 29211 | 1706 | 21 |
2426280 | 2426280 | 2022-04-20 | Sullivan | Missouri | 29211 | 1706 | 21 |
2423024 | 2423024 | 2022-04-19 | Sullivan | Missouri | 29211 | 1706 | 21 |
2419767 | 2419767 | 2022-04-18 | Sullivan | Missouri | 29211 | 1706 | 21 |
2416512 | 2416512 | 2022-04-17 | Sullivan | Missouri | 29211 | 1706 | 21 |
2413256 | 2413256 | 2022-04-16 | Sullivan | Missouri | 29211 | 1706 | 21 |
2410000 | 2410000 | 2022-04-15 | Sullivan | Missouri | 29211 | 1706 | 21 |
2406744 | 2406744 | 2022-04-14 | Sullivan | Missouri | 29211 | 1706 | 21 |
2403488 | 2403488 | 2022-04-13 | Sullivan | Missouri | 29211 | 1706 | 21 |
2400233 | 2400233 | 2022-04-12 | Sullivan | Missouri | 29211 | 1706 | 21 |
2396978 | 2396978 | 2022-04-11 | Sullivan | Missouri | 29211 | 1706 | 21 |
2393723 | 2393723 | 2022-04-10 | Sullivan | Missouri | 29211 | 1706 | 21 |
2390467 | 2390467 | 2022-04-09 | Sullivan | Missouri | 29211 | 1706 | 21 |
2387211 | 2387211 | 2022-04-08 | Sullivan | Missouri | 29211 | 1706 | 21 |
2383956 | 2383956 | 2022-04-07 | Sullivan | Missouri | 29211 | 1706 | 21 |
2380701 | 2380701 | 2022-04-06 | Sullivan | Missouri | 29211 | 1706 | 21 |
2377446 | 2377446 | 2022-04-05 | Sullivan | Missouri | 29211 | 1706 | 21 |
2374193 | 2374193 | 2022-04-04 | Sullivan | Missouri | 29211 | 1706 | 21 |
2370941 | 2370941 | 2022-04-03 | Sullivan | Missouri | 29211 | 1706 | 21 |
2367688 | 2367688 | 2022-04-02 | Sullivan | Missouri | 29211 | 1706 | 21 |
2364435 | 2364435 | 2022-04-01 | Sullivan | Missouri | 29211 | 1706 | 21 |
2361181 | 2361181 | 2022-03-31 | Sullivan | Missouri | 29211 | 1706 | 21 |
2357927 | 2357927 | 2022-03-30 | Sullivan | Missouri | 29211 | 1706 | 21 |
2354674 | 2354674 | 2022-03-29 | Sullivan | Missouri | 29211 | 1706 | 21 |
2351421 | 2351421 | 2022-03-28 | Sullivan | Missouri | 29211 | 1706 | 21 |
2348169 | 2348169 | 2022-03-27 | Sullivan | Missouri | 29211 | 1706 | 21 |
2344916 | 2344916 | 2022-03-26 | Sullivan | Missouri | 29211 | 1706 | 21 |
2341663 | 2341663 | 2022-03-25 | Sullivan | Missouri | 29211 | 1706 | 21 |
2338410 | 2338410 | 2022-03-24 | Sullivan | Missouri | 29211 | 1706 | 21 |
2328649 | 2328649 | 2022-03-21 | Sullivan | Missouri | 29211 | 1706 | 21 |
2325397 | 2325397 | 2022-03-20 | Sullivan | Missouri | 29211 | 1706 | 21 |
2322143 | 2322143 | 2022-03-19 | Sullivan | Missouri | 29211 | 1706 | 21 |
2318889 | 2318889 | 2022-03-18 | Sullivan | Missouri | 29211 | 1706 | 21 |
2304529 | 2304529 | 2022-03-14 | Conejos | Colorado | 8021 | 1706 | 52 |
2289383 | 2289383 | 2022-03-09 | Mahnomen | Minnesota | 27087 | 1706 | 17 |
2271556 | 2271556 | 2022-03-03 | Williamsburg city | Virginia | 51830 | 1706 | 20 |
2265431 | 2265431 | 2022-03-02 | Woodruff | Arkansas | 5147 | 1706 | 26 |
2268304 | 2268304 | 2022-03-02 | Williamsburg city | Virginia | 51830 | 1706 | 20 |
2262180 | 2262180 | 2022-03-01 | Woodruff | Arkansas | 5147 | 1706 | 26 |
2258929 | 2258929 | 2022-02-28 | Woodruff | Arkansas | 5147 | 1706 | 26 |
2255678 | 2255678 | 2022-02-27 | Woodruff | Arkansas | 5147 | 1706 | 26 |
2252427 | 2252427 | 2022-02-26 | Woodruff | Arkansas | 5147 | 1706 | 26 |
2237351 | 2237351 | 2022-02-21 | Lac qui Parle | Minnesota | 27073 | 1706 | 28 |
2234100 | 2234100 | 2022-02-20 | Lac qui Parle | Minnesota | 27073 | 1706 | 28 |
2230849 | 2230849 | 2022-02-19 | Lac qui Parle | Minnesota | 27073 | 1706 | 28 |
2227598 | 2227598 | 2022-02-18 | Lac qui Parle | Minnesota | 27073 | 1706 | 28 |
2217799 | 2217799 | 2022-02-15 | Schoolcraft | Michigan | 26153 | 1706 | 13 |
2214548 | 2214548 | 2022-02-14 | Schoolcraft | Michigan | 26153 | 1706 | 13 |
2192201 | 2192201 | 2022-02-07 | Richardson | Nebraska | 31147 | 1706 | 24 |
2176564 | 2176564 | 2022-02-02 | Hormigueros | Puerto Rico | 72067 | 1706 | |
2156164 | 2156164 | 2022-01-27 | Wilkinson | Mississippi | 28157 | 1706 | 41 |
2127003 | 2127003 | 2022-01-18 | Beaverhead | Montana | 30001 | 1706 | 24 |
2108844 | 2108844 | 2022-01-12 | Fairfax city | Virginia | 51600 | 1706 | 36 |
2100131 | 2100131 | 2022-01-10 | Martin | Indiana | 18101 | 1706 | 21 |
2102040 | 2102040 | 2022-01-10 | Clay | Texas | 48077 | 1706 | 26 |
2097196 | 2097196 | 2022-01-09 | Livingston | Kentucky | 21139 | 1706 | 49 |
2097883 | 2097883 | 2022-01-09 | Unknown | Nebraska | 1706 | 307 | |
2093944 | 2093944 | 2022-01-08 | Livingston | Kentucky | 21139 | 1706 | 49 |
2094927 | 2094927 | 2022-01-08 | Traill | North Dakota | 38097 | 1706 | 21 |
2090692 | 2090692 | 2022-01-07 | Livingston | Kentucky | 21139 | 1706 | 49 |
2084460 | 2084460 | 2022-01-05 | Clearwater | Minnesota | 27029 | 1706 | 25 |
2085473 | 2085473 | 2022-01-05 | Comerio | Puerto Rico | 72045 | 1706 | |
2081492 | 2081492 | 2022-01-04 | Deer Lodge | Montana | 30023 | 1706 | 28 |
2075960 | 2075960 | 2022-01-02 | Perry | Tennessee | 47135 | 1706 | 41 |
2072709 | 2072709 | 2022-01-01 | Perry | Tennessee | 47135 | 1706 | 41 |
2069458 | 2069458 | 2021-12-31 | Perry | Tennessee | 47135 | 1706 | 41 |
2066207 | 2066207 | 2021-12-30 | Perry | Tennessee | 47135 | 1706 | 41 |
2021939 | 2021939 | 2021-12-17 | Fremont | Idaho | 16043 | 1706 | 18 |
2019191 | 2019191 | 2021-12-16 | McLean | Kentucky | 21149 | 1706 | 40 |
2016536 | 2016536 | 2021-12-15 | Box Butte | Nebraska | 31013 | 1706 | 16 |
2014695 | 2014695 | 2021-12-14 | Pend Oreille | Washington | 53051 | 1706 | 25 |
1986196 | 1986196 | 2021-12-06 | Owyhee | Idaho | 16073 | 1706 | 41 |
1982946 | 1982946 | 2021-12-05 | Owyhee | Idaho | 16073 | 1706 | 41 |
1979696 | 1979696 | 2021-12-04 | Owyhee | Idaho | 16073 | 1706 | 41 |
1980688 | 1980688 | 2021-12-04 | Ralls | Missouri | 29173 | 1706 | 18 |
1940693 | 1940693 | 2021-11-22 | Teton | Idaho | 16081 | 1706 | 6 |
1935131 | 1935131 | 2021-11-20 | Grundy | Missouri | 29079 | 1706 | 55 |
1932636 | 1932636 | 2021-11-19 | Forest | Pennsylvania | 42053 | 1706 | 27 |
1923116 | 1923116 | 2021-11-16 | Todd | South Dakota | 46121 | 1706 | 37 |
1898708 | 1898708 | 2021-11-09 | Mitchell | Iowa | 19131 | 1706 | 43 |
1895458 | 1895458 | 2021-11-08 | Mitchell | Iowa | 19131 | 1706 | 43 |
1892208 | 1892208 | 2021-11-07 | Mitchell | Iowa | 19131 | 1706 | 43 |
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);