ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,122 rows where deaths = 42 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 941
- Iowa 829
- Virginia 803
- Georgia 787
- Missouri 722
- Kentucky 620
- Mississippi 590
- Illinois 580
- Alabama 519
- Arkansas 484
- Kansas 435
- Indiana 413
- North Carolina 405
- Ohio 401
- Wisconsin 376
- South Dakota 361
- Louisiana 302
- Minnesota 276
- Oklahoma 273
- Michigan 256
- Nebraska 252
- Tennessee 233
- Florida 201
- West Virginia 195
- Oregon 191
- Idaho 157
- Pennsylvania 156
- South Carolina 156
- Montana 155
- California 152
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499997 | 2499997 | 2022-05-13 | Clinch | Georgia | 13065 | 2124 | 42 |
2500407 | 2500407 | 2022-05-13 | Franklin | Iowa | 19069 | 2521 | 42 |
2500488 | 2500488 | 2022-05-13 | Coffey | Kansas | 20031 | 2435 | 42 |
2500530 | 2500530 | 2022-05-13 | Marshall | Kansas | 20117 | 2559 | 42 |
2501104 | 2501104 | 2022-05-13 | Dade | Missouri | 29057 | 1447 | 42 |
2501261 | 2501261 | 2022-05-13 | Cass | Nebraska | 31025 | 6136 | 42 |
2501328 | 2501328 | 2022-05-13 | Seward | Nebraska | 31159 | 3324 | 42 |
2502286 | 2502286 | 2022-05-13 | Franklin | Texas | 48159 | 2228 | 42 |
2502355 | 2502355 | 2022-05-13 | Live Oak | Texas | 48297 | 2153 | 42 |
2502458 | 2502458 | 2022-05-13 | Yoakum | Texas | 48501 | 1317 | 42 |
2502536 | 2502536 | 2022-05-13 | Clarke | Virginia | 51043 | 2679 | 42 |
2502556 | 2502556 | 2022-05-13 | Fredericksburg city | Virginia | 51630 | 5498 | 42 |
2502631 | 2502631 | 2022-05-13 | Sussex | Virginia | 51183 | 2419 | 42 |
2496739 | 2496739 | 2022-05-12 | Clinch | Georgia | 13065 | 2124 | 42 |
2497149 | 2497149 | 2022-05-12 | Franklin | Iowa | 19069 | 2521 | 42 |
2497230 | 2497230 | 2022-05-12 | Coffey | Kansas | 20031 | 2427 | 42 |
2497272 | 2497272 | 2022-05-12 | Marshall | Kansas | 20117 | 2559 | 42 |
2497846 | 2497846 | 2022-05-12 | Dade | Missouri | 29057 | 1447 | 42 |
2498003 | 2498003 | 2022-05-12 | Cass | Nebraska | 31025 | 6125 | 42 |
2498070 | 2498070 | 2022-05-12 | Seward | Nebraska | 31159 | 3322 | 42 |
2499028 | 2499028 | 2022-05-12 | Franklin | Texas | 48159 | 2228 | 42 |
2499097 | 2499097 | 2022-05-12 | Live Oak | Texas | 48297 | 2153 | 42 |
2499200 | 2499200 | 2022-05-12 | Yoakum | Texas | 48501 | 1317 | 42 |
2499278 | 2499278 | 2022-05-12 | Clarke | Virginia | 51043 | 2676 | 42 |
2499298 | 2499298 | 2022-05-12 | Fredericksburg city | Virginia | 51630 | 5482 | 42 |
2499373 | 2499373 | 2022-05-12 | Sussex | Virginia | 51183 | 2416 | 42 |
2493481 | 2493481 | 2022-05-11 | Clinch | Georgia | 13065 | 2124 | 42 |
2493891 | 2493891 | 2022-05-11 | Franklin | Iowa | 19069 | 2521 | 42 |
2493972 | 2493972 | 2022-05-11 | Coffey | Kansas | 20031 | 2427 | 42 |
2494014 | 2494014 | 2022-05-11 | Marshall | Kansas | 20117 | 2559 | 42 |
2494588 | 2494588 | 2022-05-11 | Dade | Missouri | 29057 | 1447 | 42 |
2494745 | 2494745 | 2022-05-11 | Cass | Nebraska | 31025 | 6125 | 42 |
2494812 | 2494812 | 2022-05-11 | Seward | Nebraska | 31159 | 3322 | 42 |
2495222 | 2495222 | 2022-05-11 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2495770 | 2495770 | 2022-05-11 | Franklin | Texas | 48159 | 2228 | 42 |
2495839 | 2495839 | 2022-05-11 | Live Oak | Texas | 48297 | 2153 | 42 |
2495942 | 2495942 | 2022-05-11 | Yoakum | Texas | 48501 | 1313 | 42 |
2496020 | 2496020 | 2022-05-11 | Clarke | Virginia | 51043 | 2671 | 42 |
2496040 | 2496040 | 2022-05-11 | Fredericksburg city | Virginia | 51630 | 5466 | 42 |
2496115 | 2496115 | 2022-05-11 | Sussex | Virginia | 51183 | 2412 | 42 |
2490223 | 2490223 | 2022-05-10 | Clinch | Georgia | 13065 | 2122 | 42 |
2490633 | 2490633 | 2022-05-10 | Franklin | Iowa | 19069 | 2517 | 42 |
2490714 | 2490714 | 2022-05-10 | Coffey | Kansas | 20031 | 2427 | 42 |
2490756 | 2490756 | 2022-05-10 | Marshall | Kansas | 20117 | 2559 | 42 |
2491330 | 2491330 | 2022-05-10 | Dade | Missouri | 29057 | 1447 | 42 |
2491487 | 2491487 | 2022-05-10 | Cass | Nebraska | 31025 | 6063 | 42 |
2491554 | 2491554 | 2022-05-10 | Seward | Nebraska | 31159 | 3412 | 42 |
2491964 | 2491964 | 2022-05-10 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2492512 | 2492512 | 2022-05-10 | Franklin | Texas | 48159 | 2228 | 42 |
2492581 | 2492581 | 2022-05-10 | Live Oak | Texas | 48297 | 2152 | 42 |
2492684 | 2492684 | 2022-05-10 | Yoakum | Texas | 48501 | 1313 | 42 |
2492762 | 2492762 | 2022-05-10 | Clarke | Virginia | 51043 | 2667 | 42 |
2492782 | 2492782 | 2022-05-10 | Fredericksburg city | Virginia | 51630 | 5456 | 42 |
2492857 | 2492857 | 2022-05-10 | Sussex | Virginia | 51183 | 2413 | 42 |
2486966 | 2486966 | 2022-05-09 | Clinch | Georgia | 13065 | 2122 | 42 |
2487376 | 2487376 | 2022-05-09 | Franklin | Iowa | 19069 | 2517 | 42 |
2487457 | 2487457 | 2022-05-09 | Coffey | Kansas | 20031 | 2427 | 42 |
2487499 | 2487499 | 2022-05-09 | Marshall | Kansas | 20117 | 2559 | 42 |
2488072 | 2488072 | 2022-05-09 | Dade | Missouri | 29057 | 1447 | 42 |
2488229 | 2488229 | 2022-05-09 | Cass | Nebraska | 31025 | 6063 | 42 |
2488296 | 2488296 | 2022-05-09 | Seward | Nebraska | 31159 | 3412 | 42 |
2488706 | 2488706 | 2022-05-09 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2489254 | 2489254 | 2022-05-09 | Franklin | Texas | 48159 | 2228 | 42 |
2489323 | 2489323 | 2022-05-09 | Live Oak | Texas | 48297 | 2152 | 42 |
2489426 | 2489426 | 2022-05-09 | Yoakum | Texas | 48501 | 1313 | 42 |
2489504 | 2489504 | 2022-05-09 | Clarke | Virginia | 51043 | 2666 | 42 |
2489524 | 2489524 | 2022-05-09 | Fredericksburg city | Virginia | 51630 | 5446 | 42 |
2489599 | 2489599 | 2022-05-09 | Sussex | Virginia | 51183 | 2411 | 42 |
2483708 | 2483708 | 2022-05-08 | Clinch | Georgia | 13065 | 2122 | 42 |
2484118 | 2484118 | 2022-05-08 | Franklin | Iowa | 19069 | 2517 | 42 |
2484199 | 2484199 | 2022-05-08 | Coffey | Kansas | 20031 | 2427 | 42 |
2484241 | 2484241 | 2022-05-08 | Marshall | Kansas | 20117 | 2559 | 42 |
2484815 | 2484815 | 2022-05-08 | Dade | Missouri | 29057 | 1447 | 42 |
2484972 | 2484972 | 2022-05-08 | Cass | Nebraska | 31025 | 6063 | 42 |
2485039 | 2485039 | 2022-05-08 | Seward | Nebraska | 31159 | 3408 | 42 |
2485449 | 2485449 | 2022-05-08 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2485997 | 2485997 | 2022-05-08 | Franklin | Texas | 48159 | 2228 | 42 |
2486066 | 2486066 | 2022-05-08 | Live Oak | Texas | 48297 | 2152 | 42 |
2486168 | 2486168 | 2022-05-08 | Yoakum | Texas | 48501 | 1313 | 42 |
2486247 | 2486247 | 2022-05-08 | Clarke | Virginia | 51043 | 2653 | 42 |
2486267 | 2486267 | 2022-05-08 | Fredericksburg city | Virginia | 51630 | 5423 | 42 |
2486342 | 2486342 | 2022-05-08 | Sussex | Virginia | 51183 | 2411 | 42 |
2480450 | 2480450 | 2022-05-07 | Clinch | Georgia | 13065 | 2122 | 42 |
2480860 | 2480860 | 2022-05-07 | Franklin | Iowa | 19069 | 2517 | 42 |
2480941 | 2480941 | 2022-05-07 | Coffey | Kansas | 20031 | 2427 | 42 |
2480983 | 2480983 | 2022-05-07 | Marshall | Kansas | 20117 | 2559 | 42 |
2481557 | 2481557 | 2022-05-07 | Dade | Missouri | 29057 | 1447 | 42 |
2481714 | 2481714 | 2022-05-07 | Cass | Nebraska | 31025 | 6063 | 42 |
2481781 | 2481781 | 2022-05-07 | Seward | Nebraska | 31159 | 3408 | 42 |
2482191 | 2482191 | 2022-05-07 | Blaine | Oklahoma | 40011 | 2458 | 42 |
2482739 | 2482739 | 2022-05-07 | Franklin | Texas | 48159 | 2228 | 42 |
2482808 | 2482808 | 2022-05-07 | Live Oak | Texas | 48297 | 2152 | 42 |
2482910 | 2482910 | 2022-05-07 | Yoakum | Texas | 48501 | 1313 | 42 |
2482989 | 2482989 | 2022-05-07 | Clarke | Virginia | 51043 | 2653 | 42 |
2483009 | 2483009 | 2022-05-07 | Fredericksburg city | Virginia | 51630 | 5423 | 42 |
2483084 | 2483084 | 2022-05-07 | Sussex | Virginia | 51183 | 2411 | 42 |
2477192 | 2477192 | 2022-05-06 | Clinch | Georgia | 13065 | 2122 | 42 |
2477602 | 2477602 | 2022-05-06 | Franklin | Iowa | 19069 | 2517 | 42 |
2477683 | 2477683 | 2022-05-06 | Coffey | Kansas | 20031 | 2427 | 42 |
2477725 | 2477725 | 2022-05-06 | Marshall | Kansas | 20117 | 2559 | 42 |
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);