ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
325 rows where cases = 1804 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 26
- South Dakota 22
- Wisconsin 22
- Missouri 20
- Puerto Rico 18
- Mississippi 17
- Tennessee 17
- Montana 16
- Nebraska 16
- Kansas 15
- Texas 14
- Illinois 12
- Iowa 10
- Kentucky 10
- Oklahoma 10
- Arkansas 8
- Minnesota 8
- Virginia 7
- North Carolina 6
- Alabama 4
- Utah 4
- Alaska 3
- California 3
- Colorado 3
- North Dakota 3
- Ohio 3
- Pennsylvania 3
- Washington 3
- West Virginia 3
- Idaho 2
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501072 | 2501072 | 2022-05-13 | Wilkinson | Mississippi | 28157 | 1804 | 46 |
2497251 | 2497251 | 2022-05-12 | Greenwood | Kansas | 20073 | 1804 | 23 |
2497814 | 2497814 | 2022-05-12 | Wilkinson | Mississippi | 28157 | 1804 | 46 |
2493993 | 2493993 | 2022-05-11 | Greenwood | Kansas | 20073 | 1804 | 23 |
2494556 | 2494556 | 2022-05-11 | Wilkinson | Mississippi | 28157 | 1804 | 46 |
2490735 | 2490735 | 2022-05-10 | Greenwood | Kansas | 20073 | 1804 | 23 |
2491298 | 2491298 | 2022-05-10 | Wilkinson | Mississippi | 28157 | 1804 | 46 |
2487478 | 2487478 | 2022-05-09 | Greenwood | Kansas | 20073 | 1804 | 23 |
2488040 | 2488040 | 2022-05-09 | Wilkinson | Mississippi | 28157 | 1804 | 46 |
2484220 | 2484220 | 2022-05-08 | Greenwood | Kansas | 20073 | 1804 | 23 |
2480962 | 2480962 | 2022-05-07 | Greenwood | Kansas | 20073 | 1804 | 23 |
2477704 | 2477704 | 2022-05-06 | Greenwood | Kansas | 20073 | 1804 | 23 |
2470061 | 2470061 | 2022-05-03 | Williamsburg city | Virginia | 51830 | 1804 | 22 |
2446699 | 2446699 | 2022-04-26 | Fall River | South Dakota | 46047 | 1804 | 39 |
2443444 | 2443444 | 2022-04-25 | Fall River | South Dakota | 46047 | 1804 | 39 |
2440188 | 2440188 | 2022-04-24 | Fall River | South Dakota | 46047 | 1804 | 39 |
2436932 | 2436932 | 2022-04-23 | Fall River | South Dakota | 46047 | 1804 | 39 |
2433676 | 2433676 | 2022-04-22 | Fall River | South Dakota | 46047 | 1804 | 39 |
2428207 | 2428207 | 2022-04-21 | Lake | Colorado | 8065 | 1804 | 2 |
2430420 | 2430420 | 2022-04-21 | Fall River | South Dakota | 46047 | 1804 | 39 |
2427164 | 2427164 | 2022-04-20 | Fall River | South Dakota | 46047 | 1804 | 39 |
2423908 | 2423908 | 2022-04-19 | Fall River | South Dakota | 46047 | 1804 | 39 |
2420652 | 2420652 | 2022-04-18 | Fall River | South Dakota | 46047 | 1804 | 39 |
2417396 | 2417396 | 2022-04-17 | Fall River | South Dakota | 46047 | 1804 | 39 |
2414140 | 2414140 | 2022-04-16 | Fall River | South Dakota | 46047 | 1804 | 39 |
2410884 | 2410884 | 2022-04-15 | Fall River | South Dakota | 46047 | 1804 | 39 |
2407628 | 2407628 | 2022-04-14 | Fall River | South Dakota | 46047 | 1804 | 39 |
2404372 | 2404372 | 2022-04-13 | Fall River | South Dakota | 46047 | 1804 | 39 |
2401117 | 2401117 | 2022-04-12 | Fall River | South Dakota | 46047 | 1804 | 39 |
2397862 | 2397862 | 2022-04-11 | Fall River | South Dakota | 46047 | 1804 | 39 |
2394607 | 2394607 | 2022-04-10 | Fall River | South Dakota | 46047 | 1804 | 39 |
2391351 | 2391351 | 2022-04-09 | Fall River | South Dakota | 46047 | 1804 | 39 |
2388095 | 2388095 | 2022-04-08 | Fall River | South Dakota | 46047 | 1804 | 39 |
2384840 | 2384840 | 2022-04-07 | Fall River | South Dakota | 46047 | 1804 | 39 |
2381585 | 2381585 | 2022-04-06 | Fall River | South Dakota | 46047 | 1804 | 39 |
2361218 | 2361218 | 2022-03-31 | Madison | Montana | 30057 | 1804 | 20 |
2357964 | 2357964 | 2022-03-30 | Madison | Montana | 30057 | 1804 | 20 |
2354711 | 2354711 | 2022-03-29 | Madison | Montana | 30057 | 1804 | 20 |
2351458 | 2351458 | 2022-03-28 | Madison | Montana | 30057 | 1804 | 20 |
2348206 | 2348206 | 2022-03-27 | Madison | Montana | 30057 | 1804 | 20 |
2344953 | 2344953 | 2022-03-26 | Madison | Montana | 30057 | 1804 | 20 |
2341700 | 2341700 | 2022-03-25 | Madison | Montana | 30057 | 1804 | 20 |
2338447 | 2338447 | 2022-03-24 | Madison | Montana | 30057 | 1804 | 20 |
2335193 | 2335193 | 2022-03-23 | Madison | Montana | 30057 | 1804 | 20 |
2331939 | 2331939 | 2022-03-22 | Madison | Montana | 30057 | 1804 | 20 |
2328686 | 2328686 | 2022-03-21 | Madison | Montana | 30057 | 1804 | 20 |
2328788 | 2328788 | 2022-03-21 | Richardson | Nebraska | 31147 | 1804 | 24 |
2319028 | 2319028 | 2022-03-18 | Richardson | Nebraska | 31147 | 1804 | 24 |
2315775 | 2315775 | 2022-03-17 | Richardson | Nebraska | 31147 | 1804 | 24 |
2309167 | 2309167 | 2022-03-15 | Madison | Montana | 30057 | 1804 | 20 |
2309269 | 2309269 | 2022-03-15 | Richardson | Nebraska | 31147 | 1804 | 24 |
2302664 | 2302664 | 2022-03-13 | Madison | Montana | 30057 | 1804 | 20 |
2299412 | 2299412 | 2022-03-12 | Madison | Montana | 30057 | 1804 | 20 |
2296160 | 2296160 | 2022-03-11 | Madison | Montana | 30057 | 1804 | 20 |
2292908 | 2292908 | 2022-03-10 | Madison | Montana | 30057 | 1804 | 20 |
2283200 | 2283200 | 2022-03-07 | Cuming | Nebraska | 31039 | 1804 | 15 |
2280001 | 2280001 | 2022-03-06 | Richardson | Nebraska | 31147 | 1804 | 24 |
2276748 | 2276748 | 2022-03-05 | Richardson | Nebraska | 31147 | 1804 | 24 |
2273495 | 2273495 | 2022-03-04 | Richardson | Nebraska | 31147 | 1804 | 24 |
2266936 | 2266936 | 2022-03-02 | Cuming | Nebraska | 31039 | 1804 | 15 |
2267588 | 2267588 | 2022-03-02 | Arroyo | Puerto Rico | 72015 | 1804 | |
2264335 | 2264335 | 2022-03-01 | Arroyo | Puerto Rico | 72015 | 1804 | |
2261085 | 2261085 | 2022-02-28 | Arroyo | Puerto Rico | 72015 | 1804 | |
2257834 | 2257834 | 2022-02-27 | Arroyo | Puerto Rico | 72015 | 1804 | |
2254583 | 2254583 | 2022-02-26 | Arroyo | Puerto Rico | 72015 | 1804 | |
2237527 | 2237527 | 2022-02-21 | Hickory | Missouri | 29085 | 1804 | 50 |
2234276 | 2234276 | 2022-02-20 | Hickory | Missouri | 29085 | 1804 | 50 |
2231025 | 2231025 | 2022-02-19 | Hickory | Missouri | 29085 | 1804 | 50 |
2227774 | 2227774 | 2022-02-18 | Hickory | Missouri | 29085 | 1804 | 50 |
2189884 | 2189884 | 2022-02-06 | Crosby | Texas | 48107 | 1804 | 44 |
2151575 | 2151575 | 2022-01-26 | Monroe | Arkansas | 5095 | 1804 | 28 |
2151586 | 2151586 | 2022-01-26 | Prairie | Arkansas | 5117 | 1804 | 32 |
2152788 | 2152788 | 2022-01-26 | Marshall | Minnesota | 27089 | 1804 | 23 |
2153259 | 2153259 | 2022-01-26 | Sierra | New Mexico | 35051 | 1804 | 68 |
2135715 | 2135715 | 2022-01-21 | Boundary | Idaho | 16021 | 1804 | 53 |
2124191 | 2124191 | 2022-01-17 | Traill | North Dakota | 38097 | 1804 | 21 |
2106396 | 2106396 | 2022-01-12 | Stewart | Georgia | 13259 | 1804 | 30 |
2106472 | 2106472 | 2022-01-12 | Owyhee | Idaho | 16073 | 1804 | 43 |
2097639 | 2097639 | 2022-01-09 | Carroll | Missouri | 29033 | 1804 | 39 |
2098525 | 2098525 | 2022-01-09 | Santa Isabel | Puerto Rico | 72133 | 1804 | |
2092510 | 2092510 | 2022-01-07 | Grand | Utah | 49019 | 1804 | 6 |
2080302 | 2080302 | 2022-01-04 | Dooly | Georgia | 13093 | 1804 | 62 |
2081793 | 2081793 | 2022-01-04 | Clay | North Carolina | 37043 | 1804 | 38 |
2060892 | 2060892 | 2021-12-29 | Turner | Georgia | 13287 | 1804 | 50 |
2063392 | 2063392 | 2021-12-29 | Richmond | Virginia | 51159 | 1804 | 17 |
2058022 | 2058022 | 2021-12-28 | Cloud | Kansas | 20029 | 1804 | 32 |
2054773 | 2054773 | 2021-12-27 | Cloud | Kansas | 20029 | 1804 | 32 |
2051272 | 2051272 | 2021-12-26 | Marshall | Illinois | 17123 | 1804 | 25 |
2048022 | 2048022 | 2021-12-25 | Marshall | Illinois | 17123 | 1804 | 25 |
2044772 | 2044772 | 2021-12-24 | Marshall | Illinois | 17123 | 1804 | 25 |
2041523 | 2041523 | 2021-12-23 | Marshall | Illinois | 17123 | 1804 | 25 |
2040115 | 2040115 | 2021-12-22 | Lake | South Dakota | 46079 | 1804 | 22 |
2035080 | 2035080 | 2021-12-21 | Crawford | Indiana | 18025 | 1804 | 30 |
2031594 | 2031594 | 2021-12-20 | Long | Georgia | 13183 | 1804 | 29 |
2028343 | 2028343 | 2021-12-19 | Long | Georgia | 13183 | 1804 | 29 |
2025092 | 2025092 | 2021-12-18 | Long | Georgia | 13183 | 1804 | 29 |
2021841 | 2021841 | 2021-12-17 | Long | Georgia | 13183 | 1804 | 29 |
2019511 | 2019511 | 2021-12-16 | Stevens | Minnesota | 27149 | 1804 | 11 |
2020481 | 2020481 | 2021-12-16 | Juana Diaz | Puerto Rico | 72075 | 1804 | |
2012558 | 2012558 | 2021-12-14 | Linn | Kansas | 20107 | 1804 | 21 |
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);