ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
186 rows where cases = 3603 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Kentucky 23
- Michigan 17
- Texas 13
- Wisconsin 12
- New York 11
- Tennessee 9
- Florida 8
- Indiana 8
- Iowa 8
- Louisiana 7
- Oklahoma 7
- Arkansas 6
- Minnesota 6
- Georgia 5
- Missouri 5
- South Carolina 5
- Illinois 4
- Mississippi 4
- Ohio 4
- Kansas 3
- Puerto Rico 3
- Idaho 2
- Maryland 2
- North Carolina 2
- Pennsylvania 2
- Virgin Islands 2
- Virginia 2
- West Virginia 2
- Alabama 1
- Arizona 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2490566 | 2490566 | 2022-05-10 | Parke | Indiana | 18121 | 3603 | 46 |
2487309 | 2487309 | 2022-05-09 | Parke | Indiana | 18121 | 3603 | 46 |
2445498 | 2445498 | 2022-04-26 | Leelanau | Michigan | 26089 | 3603 | 54 |
2442242 | 2442242 | 2022-04-25 | Leelanau | Michigan | 26089 | 3603 | 54 |
2438986 | 2438986 | 2022-04-24 | Leelanau | Michigan | 26089 | 3603 | 54 |
2435730 | 2435730 | 2022-04-23 | Leelanau | Michigan | 26089 | 3603 | 54 |
2432474 | 2432474 | 2022-04-22 | Leelanau | Michigan | 26089 | 3603 | 54 |
2429218 | 2429218 | 2022-04-21 | Leelanau | Michigan | 26089 | 3603 | 54 |
2425962 | 2425962 | 2022-04-20 | Leelanau | Michigan | 26089 | 3603 | 54 |
2424057 | 2424057 | 2022-04-19 | Bandera | Texas | 48019 | 3603 | 77 |
2415536 | 2415536 | 2022-04-17 | Greene | Illinois | 17061 | 3603 | 58 |
2412280 | 2412280 | 2022-04-16 | Greene | Illinois | 17061 | 3603 | 58 |
2409024 | 2409024 | 2022-04-15 | Greene | Illinois | 17061 | 3603 | 58 |
2370363 | 2370363 | 2022-04-03 | Clinton | Kentucky | 21053 | 3603 | 49 |
2367110 | 2367110 | 2022-04-02 | Clinton | Kentucky | 21053 | 3603 | 49 |
2363857 | 2363857 | 2022-04-01 | Clinton | Kentucky | 21053 | 3603 | 49 |
2360603 | 2360603 | 2022-03-31 | Clinton | Kentucky | 21053 | 3603 | 49 |
2357349 | 2357349 | 2022-03-30 | Clinton | Kentucky | 21053 | 3603 | 49 |
2354096 | 2354096 | 2022-03-29 | Clinton | Kentucky | 21053 | 3603 | 49 |
2350844 | 2350844 | 2022-03-28 | Clinton | Kentucky | 21053 | 3603 | 49 |
2302108 | 2302108 | 2022-03-13 | Monroe | Kentucky | 21171 | 3603 | 74 |
2298856 | 2298856 | 2022-03-12 | Monroe | Kentucky | 21171 | 3603 | 74 |
2295604 | 2295604 | 2022-03-11 | Monroe | Kentucky | 21171 | 3603 | 74 |
2292352 | 2292352 | 2022-03-10 | Monroe | Kentucky | 21171 | 3603 | 74 |
2289100 | 2289100 | 2022-03-09 | Monroe | Kentucky | 21171 | 3603 | 74 |
2291249 | 2291249 | 2022-03-09 | Goshen | Wyoming | 56015 | 3603 | 56 |
2285658 | 2285658 | 2022-03-08 | Wright | Iowa | 19197 | 3603 | 62 |
2285849 | 2285849 | 2022-03-08 | Monroe | Kentucky | 21171 | 3603 | 74 |
2282406 | 2282406 | 2022-03-07 | Wright | Iowa | 19197 | 3603 | 62 |
2282597 | 2282597 | 2022-03-07 | Monroe | Kentucky | 21171 | 3603 | 74 |
2279153 | 2279153 | 2022-03-06 | Wright | Iowa | 19197 | 3603 | 62 |
2279344 | 2279344 | 2022-03-06 | Monroe | Kentucky | 21171 | 3603 | 74 |
2281446 | 2281446 | 2022-03-06 | Lafayette | Wisconsin | 55065 | 3603 | 22 |
2275900 | 2275900 | 2022-03-05 | Wright | Iowa | 19197 | 3603 | 62 |
2276091 | 2276091 | 2022-03-05 | Monroe | Kentucky | 21171 | 3603 | 74 |
2278193 | 2278193 | 2022-03-05 | Lafayette | Wisconsin | 55065 | 3603 | 22 |
2272647 | 2272647 | 2022-03-04 | Wright | Iowa | 19197 | 3603 | 62 |
2272838 | 2272838 | 2022-03-04 | Monroe | Kentucky | 21171 | 3603 | 74 |
2274940 | 2274940 | 2022-03-04 | Lafayette | Wisconsin | 55065 | 3603 | 22 |
2269264 | 2269264 | 2022-03-03 | Parke | Indiana | 18121 | 3603 | 48 |
2269395 | 2269395 | 2022-03-03 | Wright | Iowa | 19197 | 3603 | 62 |
2266142 | 2266142 | 2022-03-02 | Wright | Iowa | 19197 | 3603 | 62 |
2256885 | 2256885 | 2022-02-27 | Renville | Minnesota | 27129 | 3603 | 55 |
2253634 | 2253634 | 2022-02-26 | Renville | Minnesota | 27129 | 3603 | 55 |
2250383 | 2250383 | 2022-02-25 | Renville | Minnesota | 27129 | 3603 | 55 |
2251366 | 2251366 | 2022-02-25 | Lares | Puerto Rico | 72081 | 3603 | |
2251870 | 2251870 | 2022-02-25 | Zapata | Texas | 48505 | 3603 | 52 |
2220241 | 2220241 | 2022-02-16 | Rabun | Georgia | 13241 | 3603 | 89 |
2186731 | 2186731 | 2022-02-05 | Madison | Texas | 48313 | 3603 | 50 |
2172060 | 2172060 | 2022-02-01 | Webster | Kentucky | 21233 | 3603 | 46 |
2130166 | 2130166 | 2022-01-19 | Cooper | Missouri | 29053 | 3603 | 68 |
2126696 | 2126696 | 2022-01-18 | Ogemaw | Michigan | 26129 | 3603 | 85 |
2123444 | 2123444 | 2022-01-17 | Ogemaw | Michigan | 26129 | 3603 | 85 |
2120192 | 2120192 | 2022-01-16 | Ogemaw | Michigan | 26129 | 3603 | 85 |
2116940 | 2116940 | 2022-01-15 | Ogemaw | Michigan | 26129 | 3603 | 85 |
2113689 | 2113689 | 2022-01-14 | Ogemaw | Michigan | 26129 | 3603 | 85 |
2101742 | 2101742 | 2022-01-10 | Hatillo | Puerto Rico | 72065 | 3603 | |
2087385 | 2087385 | 2022-01-06 | Breckinridge | Kentucky | 21027 | 3603 | 55 |
2053964 | 2053964 | 2021-12-27 | La Paz | Arizona | 4012 | 3603 | 107 |
2040717 | 2040717 | 2021-12-22 | Brooke | West Virginia | 54009 | 3603 | 86 |
2037288 | 2037288 | 2021-12-21 | St. Croix | Virgin Islands | 78010 | 3603 | 38 |
2033729 | 2033729 | 2021-12-20 | Union | Tennessee | 47173 | 3603 | 52 |
2034038 | 2034038 | 2021-12-20 | St. Croix | Virgin Islands | 78010 | 3603 | 38 |
2024046 | 2024046 | 2021-12-17 | Deaf Smith | Texas | 48117 | 3603 | 89 |
2014074 | 2014074 | 2021-12-14 | Beadle | South Dakota | 46005 | 3603 | 48 |
1966637 | 1966637 | 2021-11-30 | Union | Georgia | 13291 | 3603 | 129 |
1939555 | 1939555 | 2021-11-21 | Gillespie | Texas | 48171 | 3603 | 82 |
1936305 | 1936305 | 2021-11-20 | Gillespie | Texas | 48171 | 3603 | 81 |
1933055 | 1933055 | 2021-11-19 | Gillespie | Texas | 48171 | 3603 | 81 |
1927454 | 1927454 | 2021-11-18 | Madison | Florida | 12079 | 3603 | 59 |
1924204 | 1924204 | 2021-11-17 | Madison | Florida | 12079 | 3603 | 59 |
1920955 | 1920955 | 2021-11-16 | Madison | Florida | 12079 | 3603 | 59 |
1922749 | 1922749 | 2021-11-16 | Beckham | Oklahoma | 40009 | 3603 | 75 |
1917705 | 1917705 | 2021-11-15 | Madison | Florida | 12079 | 3603 | 59 |
1919500 | 1919500 | 2021-11-15 | Beckham | Oklahoma | 40009 | 3603 | 75 |
1914455 | 1914455 | 2021-11-14 | Madison | Florida | 12079 | 3603 | 58 |
1916250 | 1916250 | 2021-11-14 | Beckham | Oklahoma | 40009 | 3603 | 75 |
1911205 | 1911205 | 2021-11-13 | Madison | Florida | 12079 | 3603 | 58 |
1913000 | 1913000 | 2021-11-13 | Beckham | Oklahoma | 40009 | 3603 | 75 |
1907956 | 1907956 | 2021-11-12 | Madison | Florida | 12079 | 3603 | 58 |
1909750 | 1909750 | 2021-11-12 | Beckham | Oklahoma | 40009 | 3603 | 75 |
1906501 | 1906501 | 2021-11-11 | Beckham | Oklahoma | 40009 | 3603 | 75 |
1903252 | 1903252 | 2021-11-10 | Beckham | Oklahoma | 40009 | 3603 | 75 |
1860952 | 1860952 | 2021-10-28 | Hocking | Ohio | 39073 | 3603 | 82 |
1855540 | 1855540 | 2021-10-26 | Kewaunee | Wisconsin | 55061 | 3603 | 41 |
1850481 | 1850481 | 2021-10-25 | Meeker | Minnesota | 27093 | 3603 | 54 |
1850632 | 1850632 | 2021-10-25 | Crawford | Missouri | 29055 | 3603 | 57 |
1850966 | 1850966 | 2021-10-25 | Delaware | New York | 36025 | 3603 | 48 |
1847338 | 1847338 | 2021-10-24 | Stone | Mississippi | 28131 | 3603 | 64 |
1844088 | 1844088 | 2021-10-23 | Stone | Mississippi | 28131 | 3603 | 64 |
1840838 | 1840838 | 2021-10-22 | Stone | Mississippi | 28131 | 3603 | 64 |
1836260 | 1836260 | 2021-10-21 | Logan | Arkansas | 5083 | 3603 | 43 |
1837978 | 1837978 | 2021-10-21 | Lewis | New York | 36049 | 3603 | 38 |
1835412 | 1835412 | 2021-10-20 | Fentress | Tennessee | 47049 | 3603 | 65 |
1813821 | 1813821 | 2021-10-14 | Grady | Georgia | 13131 | 3603 | 86 |
1812888 | 1812888 | 2021-10-13 | Limestone | Texas | 48293 | 3603 | 107 |
1804742 | 1804742 | 2021-10-11 | Assumption | Louisiana | 22007 | 3603 | 57 |
1801427 | 1801427 | 2021-10-10 | Johnson | Kentucky | 21115 | 3603 | 45 |
1798178 | 1798178 | 2021-10-09 | Johnson | Kentucky | 21115 | 3603 | 45 |
1794929 | 1794929 | 2021-10-08 | Johnson | Kentucky | 21115 | 3603 | 45 |
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);