ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
142 rows where cases = 3728 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Alabama 11
- Illinois 11
- Texas 10
- Kentucky 8
- Virginia 8
- Wisconsin 7
- Minnesota 6
- Nebraska 6
- North Carolina 6
- Georgia 5
- Louisiana 5
- West Virginia 5
- Indiana 4
- Iowa 4
- Mississippi 4
- Ohio 4
- Oregon 4
- Missouri 3
- Pennsylvania 3
- South Carolina 3
- South Dakota 3
- Utah 3
- Colorado 2
- Kansas 2
- Maine 2
- Michigan 2
- Tennessee 2
- Arkansas 1
- Maryland 1
- New Mexico 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500451 | 2500451 | 2022-05-13 | Poweshiek | Iowa | 19157 | 3728 | 61 |
2502351 | 2502351 | 2022-05-13 | Leon | Texas | 48289 | 3728 | 93 |
2497193 | 2497193 | 2022-05-12 | Poweshiek | Iowa | 19157 | 3728 | 61 |
2499093 | 2499093 | 2022-05-12 | Leon | Texas | 48289 | 3728 | 93 |
2493754 | 2493754 | 2022-05-11 | Wabash | Illinois | 17185 | 3728 | 31 |
2493935 | 2493935 | 2022-05-11 | Poweshiek | Iowa | 19157 | 3728 | 61 |
2495835 | 2495835 | 2022-05-11 | Leon | Texas | 48289 | 3728 | 93 |
2490496 | 2490496 | 2022-05-10 | Wabash | Illinois | 17185 | 3728 | 31 |
2492577 | 2492577 | 2022-05-10 | Leon | Texas | 48289 | 3728 | 93 |
2489319 | 2489319 | 2022-05-09 | Leon | Texas | 48289 | 3728 | 93 |
2444245 | 2444245 | 2022-04-26 | Lamar | Alabama | 1075 | 3728 | 64 |
2440989 | 2440989 | 2022-04-25 | Lamar | Alabama | 1075 | 3728 | 64 |
2438761 | 2438761 | 2022-04-24 | Larue | Kentucky | 21123 | 3728 | 71 |
2435505 | 2435505 | 2022-04-23 | Larue | Kentucky | 21123 | 3728 | 71 |
2432249 | 2432249 | 2022-04-22 | Larue | Kentucky | 21123 | 3728 | 71 |
2428993 | 2428993 | 2022-04-21 | Larue | Kentucky | 21123 | 3728 | 71 |
2425737 | 2425737 | 2022-04-20 | Larue | Kentucky | 21123 | 3728 | 71 |
2422481 | 2422481 | 2022-04-19 | Larue | Kentucky | 21123 | 3728 | 71 |
2419225 | 2419225 | 2022-04-18 | Larue | Kentucky | 21123 | 3728 | 71 |
2370727 | 2370727 | 2022-04-03 | Renville | Minnesota | 27129 | 3728 | 56 |
2367474 | 2367474 | 2022-04-02 | Renville | Minnesota | 27129 | 3728 | 56 |
2364221 | 2364221 | 2022-04-01 | Renville | Minnesota | 27129 | 3728 | 56 |
2360967 | 2360967 | 2022-03-31 | Renville | Minnesota | 27129 | 3728 | 56 |
2357713 | 2357713 | 2022-03-30 | Renville | Minnesota | 27129 | 3728 | 56 |
2353132 | 2353132 | 2022-03-29 | Washington | Alabama | 1129 | 3728 | 59 |
2353835 | 2353835 | 2022-03-29 | Pike | Indiana | 18125 | 3728 | 49 |
2354460 | 2354460 | 2022-03-29 | Renville | Minnesota | 27129 | 3728 | 56 |
2349880 | 2349880 | 2022-03-28 | Washington | Alabama | 1129 | 3728 | 59 |
2350583 | 2350583 | 2022-03-28 | Pike | Indiana | 18125 | 3728 | 49 |
2309083 | 2309083 | 2022-03-15 | Livingston | Missouri | 29117 | 3728 | 92 |
2284428 | 2284428 | 2022-03-07 | Lamoille | Vermont | 50015 | 3728 | 17 |
2262690 | 2262690 | 2022-03-01 | Wabash | Illinois | 17185 | 3728 | 30 |
2224826 | 2224826 | 2022-02-17 | Socorro | New Mexico | 35053 | 3728 | 83 |
2213174 | 2213174 | 2022-02-13 | Marquette | Wisconsin | 55077 | 3728 | 48 |
2209921 | 2209921 | 2022-02-12 | Marquette | Wisconsin | 55077 | 3728 | 48 |
2206668 | 2206668 | 2022-02-11 | Marquette | Wisconsin | 55077 | 3728 | 48 |
2190223 | 2190223 | 2022-02-06 | Nottoway | Virginia | 51135 | 3728 | 75 |
2186970 | 2186970 | 2022-02-05 | Nottoway | Virginia | 51135 | 3728 | 75 |
2183717 | 2183717 | 2022-02-04 | Nottoway | Virginia | 51135 | 3728 | 75 |
2173842 | 2173842 | 2022-02-01 | San Juan | Utah | 49037 | 3728 | 47 |
2169185 | 2169185 | 2022-01-31 | Yalobusha | Mississippi | 28161 | 3728 | 50 |
2146839 | 2146839 | 2022-01-24 | Chowan | North Carolina | 37041 | 3728 | 46 |
2144429 | 2144429 | 2022-01-23 | Lee | Texas | 48287 | 3728 | 55 |
2132185 | 2132185 | 2022-01-20 | Otero | Colorado | 8089 | 3728 | 118 |
2133203 | 2133203 | 2022-01-20 | Ogemaw | Michigan | 26129 | 3728 | 87 |
2129950 | 2129950 | 2022-01-19 | Ogemaw | Michigan | 26129 | 3728 | 87 |
2121000 | 2121000 | 2022-01-16 | Meigs | Ohio | 39105 | 3728 | 71 |
2097696 | 2097696 | 2022-01-09 | New Madrid | Missouri | 29143 | 3728 | 71 |
2076668 | 2076668 | 2022-01-03 | Randolph | Alabama | 1111 | 3728 | 67 |
2063243 | 2063243 | 2021-12-29 | Carbon | Utah | 49007 | 3728 | 41 |
2034818 | 2034818 | 2021-12-21 | Grady | Georgia | 13131 | 3728 | 92 |
2030909 | 2030909 | 2021-12-19 | Staunton city | Virginia | 51790 | 3728 | 86 |
2027323 | 2027323 | 2021-12-18 | Gillespie | Texas | 48171 | 3728 | 83 |
2027658 | 2027658 | 2021-12-18 | Staunton city | Virginia | 51790 | 3728 | 86 |
2024407 | 2024407 | 2021-12-17 | Staunton city | Virginia | 51790 | 3728 | 86 |
2007357 | 2007357 | 2021-12-12 | Lincoln | Oregon | 41041 | 3728 | 57 |
2004106 | 2004106 | 2021-12-11 | Lincoln | Oregon | 41041 | 3728 | 57 |
2000855 | 2000855 | 2021-12-10 | Lincoln | Oregon | 41041 | 3728 | 57 |
1975715 | 1975715 | 2021-12-02 | Hampshire | West Virginia | 54027 | 3728 | 51 |
1970474 | 1970474 | 2021-12-01 | Woodford | Kentucky | 21239 | 3728 | 31 |
1959752 | 1959752 | 2021-11-28 | Logan | Arkansas | 5083 | 3728 | 51 |
1945308 | 1945308 | 2021-11-23 | Martin | North Carolina | 37117 | 3728 | 75 |
1942057 | 1942057 | 2021-11-22 | Martin | North Carolina | 37117 | 3728 | 75 |
1884750 | 1884750 | 2021-11-04 | Wyoming | West Virginia | 54109 | 3728 | 65 |
1881343 | 1881343 | 2021-11-03 | Lee | Virginia | 51105 | 3728 | 60 |
1862077 | 1862077 | 2021-10-28 | Waushara | Wisconsin | 55137 | 3728 | 51 |
1836570 | 1836570 | 2021-10-21 | Harris | Georgia | 13145 | 3728 | 85 |
1839276 | 1839276 | 2021-10-21 | Door | Wisconsin | 55029 | 3728 | 39 |
1813773 | 1813773 | 2021-10-14 | Burke | Georgia | 13033 | 3728 | 79 |
1711906 | 1711906 | 2021-09-12 | Meade | South Dakota | 46093 | 3728 | 34 |
1708659 | 1708659 | 2021-09-11 | Meade | South Dakota | 46093 | 3728 | 34 |
1705412 | 1705412 | 2021-09-10 | Meade | South Dakota | 46093 | 3728 | 34 |
1700337 | 1700337 | 2021-09-09 | Saline | Illinois | 17165 | 3728 | 78 |
1682210 | 1682210 | 2021-09-03 | Stutsman | North Dakota | 38093 | 3728 | 82 |
1629686 | 1629686 | 2021-08-18 | Barry | Missouri | 29009 | 3728 | 51 |
1622828 | 1622828 | 2021-08-16 | De Soto | Louisiana | 22031 | 3728 | 85 |
1614354 | 1614354 | 2021-08-13 | Vega Baja | Puerto Rico | 72145 | 3728 | |
1608628 | 1608628 | 2021-08-11 | Green | Wisconsin | 55045 | 3728 | 26 |
1602076 | 1602076 | 2021-08-09 | Marshall | West Virginia | 54051 | 3728 | 80 |
1596844 | 1596844 | 2021-08-08 | East Feliciana | Louisiana | 22037 | 3728 | 121 |
1593595 | 1593595 | 2021-08-07 | East Feliciana | Louisiana | 22037 | 3728 | 121 |
1590346 | 1590346 | 2021-08-06 | East Feliciana | Louisiana | 22037 | 3728 | 121 |
1589066 | 1589066 | 2021-08-05 | Fayette | West Virginia | 54019 | 3728 | 84 |
1571995 | 1571995 | 2021-07-31 | Clinton | Pennsylvania | 42035 | 3728 | 68 |
1568747 | 1568747 | 2021-07-30 | Clinton | Pennsylvania | 42035 | 3728 | 68 |
1548207 | 1548207 | 2021-07-24 | Worcester | Maryland | 24047 | 3728 | 106 |
1443106 | 1443106 | 2021-06-22 | Chambers | Alabama | 1017 | 3728 | 124 |
1439861 | 1439861 | 2021-06-21 | Chambers | Alabama | 1017 | 3728 | 124 |
1436614 | 1436614 | 2021-06-20 | Chambers | Alabama | 1017 | 3728 | 124 |
1433367 | 1433367 | 2021-06-19 | Chambers | Alabama | 1017 | 3728 | 124 |
1436406 | 1436406 | 2021-06-19 | Tazewell | Virginia | 51185 | 3728 | 75 |
1430121 | 1430121 | 2021-06-18 | Chambers | Alabama | 1017 | 3728 | 124 |
1355767 | 1355767 | 2021-05-26 | Summit | Colorado | 8117 | 3728 | 8 |
1345324 | 1345324 | 2021-05-22 | Titus | Texas | 48449 | 3728 | 84 |
1317246 | 1317246 | 2021-05-14 | Knox | Indiana | 18083 | 3728 | 90 |
1313999 | 1313999 | 2021-05-13 | Knox | Indiana | 18083 | 3728 | 90 |
1315110 | 1315110 | 2021-05-13 | Cortland | New York | 36023 | 3728 | 60 |
1250565 | 1250565 | 2021-04-23 | Klamath | Oregon | 41035 | 3728 | 59 |
1247201 | 1247201 | 2021-04-22 | Preble | Ohio | 39135 | 3728 | 98 |
1239500 | 1239500 | 2021-04-20 | Ellis | Kansas | 20051 | 3728 | 73 |
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);