ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,213 rows where deaths = 225 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 90
- Georgia 84
- Texas 82
- North Carolina 80
- Wisconsin 72
- Tennessee 64
- South Carolina 62
- Louisiana 54
- Michigan 51
- Illinois 46
- Indiana 46
- Pennsylvania 44
- California 41
- Oregon 30
- Virginia 28
- Alabama 26
- Missouri 25
- Montana 25
- Washington 25
- Arkansas 24
- Oklahoma 23
- Florida 17
- Arizona 15
- Idaho 15
- Maryland 12
- New Jersey 12
- New York 12
- Colorado 11
- Maine 11
- Mississippi 11
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501840 | 2501840 | 2022-05-13 | Umatilla | Oregon | 41059 | 22545 | 225 |
2498582 | 2498582 | 2022-05-12 | Umatilla | Oregon | 41059 | 22532 | 225 |
2495324 | 2495324 | 2022-05-11 | Umatilla | Oregon | 41059 | 22518 | 225 |
2491102 | 2491102 | 2022-05-10 | Midland | Michigan | 26111 | 19254 | 225 |
2492066 | 2492066 | 2022-05-10 | Umatilla | Oregon | 41059 | 22512 | 225 |
2487845 | 2487845 | 2022-05-09 | Midland | Michigan | 26111 | 19254 | 225 |
2488808 | 2488808 | 2022-05-09 | Umatilla | Oregon | 41059 | 22501 | 225 |
2484587 | 2484587 | 2022-05-08 | Midland | Michigan | 26111 | 19254 | 225 |
2481329 | 2481329 | 2022-05-07 | Midland | Michigan | 26111 | 19254 | 225 |
2478071 | 2478071 | 2022-05-06 | Midland | Michigan | 26111 | 19254 | 225 |
2474813 | 2474813 | 2022-05-05 | Midland | Michigan | 26111 | 19254 | 225 |
2471556 | 2471556 | 2022-05-04 | Midland | Michigan | 26111 | 19254 | 225 |
2473298 | 2473298 | 2022-05-04 | Rockingham | Virginia | 51165 | 14587 | 225 |
2468300 | 2468300 | 2022-05-03 | Midland | Michigan | 26111 | 19157 | 225 |
2465045 | 2465045 | 2022-05-02 | Midland | Michigan | 26111 | 19157 | 225 |
2461789 | 2461789 | 2022-05-01 | Midland | Michigan | 26111 | 19157 | 225 |
2458533 | 2458533 | 2022-04-30 | Midland | Michigan | 26111 | 19157 | 225 |
2455277 | 2455277 | 2022-04-29 | Midland | Michigan | 26111 | 19157 | 225 |
2452021 | 2452021 | 2022-04-28 | Midland | Michigan | 26111 | 19157 | 225 |
2448765 | 2448765 | 2022-04-27 | Midland | Michigan | 26111 | 19157 | 225 |
2449909 | 2449909 | 2022-04-27 | Georgetown | South Carolina | 45043 | 15847 | 225 |
2446652 | 2446652 | 2022-04-26 | Georgetown | South Carolina | 45043 | 15847 | 225 |
2443397 | 2443397 | 2022-04-25 | Georgetown | South Carolina | 45043 | 15847 | 225 |
2440141 | 2440141 | 2022-04-24 | Georgetown | South Carolina | 45043 | 15847 | 225 |
2436885 | 2436885 | 2022-04-23 | Georgetown | South Carolina | 45043 | 15847 | 225 |
2433629 | 2433629 | 2022-04-22 | Georgetown | South Carolina | 45043 | 15847 | 225 |
2430373 | 2430373 | 2022-04-21 | Georgetown | South Carolina | 45043 | 15847 | 225 |
2427117 | 2427117 | 2022-04-20 | Georgetown | South Carolina | 45043 | 15847 | 225 |
2423861 | 2423861 | 2022-04-19 | Georgetown | South Carolina | 45043 | 15847 | 225 |
2408179 | 2408179 | 2022-04-14 | Rockingham | Virginia | 51165 | 14454 | 225 |
2404923 | 2404923 | 2022-04-13 | Rockingham | Virginia | 51165 | 14453 | 225 |
2378571 | 2378571 | 2022-04-05 | Harrison | Texas | 48203 | 13277 | 225 |
2373007 | 2373007 | 2022-04-04 | Clarke | Georgia | 13059 | 29637 | 225 |
2369754 | 2369754 | 2022-04-03 | Clarke | Georgia | 13059 | 29629 | 225 |
2366501 | 2366501 | 2022-04-02 | Clarke | Georgia | 13059 | 29629 | 225 |
2363248 | 2363248 | 2022-04-01 | Clarke | Georgia | 13059 | 29629 | 225 |
2359994 | 2359994 | 2022-03-31 | Clarke | Georgia | 13059 | 29621 | 225 |
2358461 | 2358461 | 2022-03-30 | Seneca | Ohio | 39147 | 12727 | 225 |
2355207 | 2355207 | 2022-03-29 | Seneca | Ohio | 39147 | 12727 | 225 |
2351954 | 2351954 | 2022-03-28 | Seneca | Ohio | 39147 | 12727 | 225 |
2348702 | 2348702 | 2022-03-27 | Seneca | Ohio | 39147 | 12727 | 225 |
2345449 | 2345449 | 2022-03-26 | Seneca | Ohio | 39147 | 12727 | 225 |
2342196 | 2342196 | 2022-03-25 | Seneca | Ohio | 39147 | 12727 | 225 |
2336823 | 2336823 | 2022-03-24 | Covington | Alabama | 1039 | 9276 | 225 |
2337778 | 2337778 | 2022-03-24 | Reno | Kansas | 20155 | 18545 | 225 |
2338943 | 2338943 | 2022-03-24 | Seneca | Ohio | 39147 | 12727 | 225 |
2333569 | 2333569 | 2022-03-23 | Covington | Alabama | 1039 | 9271 | 225 |
2334524 | 2334524 | 2022-03-23 | Reno | Kansas | 20155 | 18545 | 225 |
2335680 | 2335680 | 2022-03-23 | Pickaway | Ohio | 39129 | 17445 | 225 |
2336491 | 2336491 | 2022-03-23 | Bedford | Virginia | 51019 | 16876 | 225 |
2330315 | 2330315 | 2022-03-22 | Covington | Alabama | 1039 | 9270 | 225 |
2331567 | 2331567 | 2022-03-22 | Grand Traverse | Michigan | 26055 | 17115 | 225 |
2332426 | 2332426 | 2022-03-22 | Pickaway | Ohio | 39129 | 17445 | 225 |
2328315 | 2328315 | 2022-03-21 | Grand Traverse | Michigan | 26055 | 17115 | 225 |
2329173 | 2329173 | 2022-03-21 | Pickaway | Ohio | 39129 | 17445 | 225 |
2325062 | 2325062 | 2022-03-20 | Grand Traverse | Michigan | 26055 | 17091 | 225 |
2325921 | 2325921 | 2022-03-20 | Pickaway | Ohio | 39129 | 17445 | 225 |
2326732 | 2326732 | 2022-03-20 | Bedford | Virginia | 51019 | 16840 | 225 |
2321808 | 2321808 | 2022-03-19 | Grand Traverse | Michigan | 26055 | 17091 | 225 |
2322668 | 2322668 | 2022-03-19 | Pickaway | Ohio | 39129 | 17445 | 225 |
2323479 | 2323479 | 2022-03-19 | Bedford | Virginia | 51019 | 16840 | 225 |
2318554 | 2318554 | 2022-03-18 | Grand Traverse | Michigan | 26055 | 17091 | 225 |
2319414 | 2319414 | 2022-03-18 | Pickaway | Ohio | 39129 | 17445 | 225 |
2320225 | 2320225 | 2022-03-18 | Bedford | Virginia | 51019 | 16840 | 225 |
2316160 | 2316160 | 2022-03-17 | Pickaway | Ohio | 39129 | 17445 | 225 |
2316971 | 2316971 | 2022-03-17 | Bedford | Virginia | 51019 | 16789 | 225 |
2317259 | 2317259 | 2022-03-17 | Wood | Wisconsin | 55141 | 20767 | 225 |
2310799 | 2310799 | 2022-03-16 | Dale | Alabama | 1045 | 12452 | 225 |
2311014 | 2311014 | 2022-03-16 | Sutter | California | 6101 | 22456 | 225 |
2311969 | 2311969 | 2022-03-16 | Kennebec | Maine | 23011 | 22437 | 225 |
2312884 | 2312884 | 2022-03-16 | Knox | Ohio | 39083 | 13095 | 225 |
2313718 | 2313718 | 2022-03-16 | Bedford | Virginia | 51019 | 16699 | 225 |
2314006 | 2314006 | 2022-03-16 | Wood | Wisconsin | 55141 | 20760 | 225 |
2307546 | 2307546 | 2022-03-15 | Dale | Alabama | 1045 | 12447 | 225 |
2307761 | 2307761 | 2022-03-15 | Sutter | California | 6101 | 22454 | 225 |
2309631 | 2309631 | 2022-03-15 | Knox | Ohio | 39083 | 13095 | 225 |
2309825 | 2309825 | 2022-03-15 | Jefferson | Pennsylvania | 42065 | 8946 | 225 |
2310129 | 2310129 | 2022-03-15 | Roane | Tennessee | 47145 | 15712 | 225 |
2310465 | 2310465 | 2022-03-15 | Bedford | Virginia | 51019 | 16694 | 225 |
2304295 | 2304295 | 2022-03-14 | Dale | Alabama | 1045 | 12445 | 225 |
2304510 | 2304510 | 2022-03-14 | Sutter | California | 6101 | 22450 | 225 |
2306378 | 2306378 | 2022-03-14 | Knox | Ohio | 39083 | 13095 | 225 |
2306876 | 2306876 | 2022-03-14 | Roane | Tennessee | 47145 | 15712 | 225 |
2307212 | 2307212 | 2022-03-14 | Bedford | Virginia | 51019 | 16678 | 225 |
2301258 | 2301258 | 2022-03-13 | Sutter | California | 6101 | 22446 | 225 |
2303127 | 2303127 | 2022-03-13 | Knox | Ohio | 39083 | 13095 | 225 |
2303625 | 2303625 | 2022-03-13 | Roane | Tennessee | 47145 | 15712 | 225 |
2304060 | 2304060 | 2022-03-13 | Rockingham | Virginia | 51165 | 14401 | 225 |
2298006 | 2298006 | 2022-03-12 | Sutter | California | 6101 | 22446 | 225 |
2299875 | 2299875 | 2022-03-12 | Knox | Ohio | 39083 | 13093 | 225 |
2300373 | 2300373 | 2022-03-12 | Roane | Tennessee | 47145 | 15712 | 225 |
2300808 | 2300808 | 2022-03-12 | Rockingham | Virginia | 51165 | 14401 | 225 |
2294754 | 2294754 | 2022-03-11 | Sutter | California | 6101 | 22446 | 225 |
2296623 | 2296623 | 2022-03-11 | Knox | Ohio | 39083 | 13093 | 225 |
2297121 | 2297121 | 2022-03-11 | Roane | Tennessee | 47145 | 15712 | 225 |
2297556 | 2297556 | 2022-03-11 | Rockingham | Virginia | 51165 | 14401 | 225 |
2291502 | 2291502 | 2022-03-10 | Sutter | California | 6101 | 22446 | 225 |
2293869 | 2293869 | 2022-03-10 | Roane | Tennessee | 47145 | 15712 | 225 |
2288250 | 2288250 | 2022-03-09 | Sutter | California | 6101 | 22413 | 225 |
2288408 | 2288408 | 2022-03-09 | Baldwin | Georgia | 13009 | 9491 | 225 |
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);