ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
19,133 rows where deaths = 22 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 1,631
- Virginia 1,397
- Georgia 1,144
- Iowa 1,106
- Kentucky 1,005
- Minnesota 928
- Kansas 848
- Missouri 685
- Colorado 616
- Arkansas 614
- Oklahoma 553
- Wisconsin 532
- Illinois 508
- Tennessee 493
- Indiana 486
- Michigan 421
- Mississippi 419
- West Virginia 410
- North Carolina 379
- Washington 370
- Ohio 354
- Utah 327
- Idaho 307
- North Dakota 307
- South Dakota 299
- Alabama 277
- Louisiana 252
- Oregon 252
- Florida 249
- Montana 236
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499984 | 2499984 | 2022-05-13 | Calhoun | Georgia | 13037 | 1364 | 22 |
2499991 | 2499991 | 2022-05-13 | Chattahoochee | Georgia | 13053 | 7486 | 22 |
2500444 | 2500444 | 2022-05-13 | Osceola | Iowa | 19143 | 1394 | 22 |
2500459 | 2500459 | 2022-05-13 | Taylor | Iowa | 19173 | 1316 | 22 |
2500534 | 2500534 | 2022-05-13 | Mitchell | Kansas | 20123 | 1428 | 22 |
2500572 | 2500572 | 2022-05-13 | Wabaunsee | Kansas | 20197 | 1642 | 22 |
2500574 | 2500574 | 2022-05-13 | Washington | Kansas | 20201 | 1400 | 22 |
2500819 | 2500819 | 2022-05-13 | Unknown | Massachusetts | 147062 | 22 | |
2500989 | 2500989 | 2022-05-13 | Wilkin | Minnesota | 27167 | 1662 | 22 |
2501183 | 2501183 | 2022-05-13 | Sullivan | Missouri | 29211 | 1715 | 22 |
2502082 | 2502082 | 2022-05-13 | Kingsbury | South Dakota | 46077 | 1340 | 22 |
2502330 | 2502330 | 2022-05-13 | Jim Hogg | Texas | 48247 | 2648 | 22 |
2502598 | 2502598 | 2022-05-13 | Norton city | Virginia | 51720 | 1310 | 22 |
2502638 | 2502638 | 2022-05-13 | Williamsburg city | Virginia | 51830 | 1837 | 22 |
2502718 | 2502718 | 2022-05-13 | Pendleton | West Virginia | 54071 | 2001 | 22 |
2496726 | 2496726 | 2022-05-12 | Calhoun | Georgia | 13037 | 1364 | 22 |
2496733 | 2496733 | 2022-05-12 | Chattahoochee | Georgia | 13053 | 7486 | 22 |
2497186 | 2497186 | 2022-05-12 | Osceola | Iowa | 19143 | 1394 | 22 |
2497201 | 2497201 | 2022-05-12 | Taylor | Iowa | 19173 | 1316 | 22 |
2497276 | 2497276 | 2022-05-12 | Mitchell | Kansas | 20123 | 1426 | 22 |
2497314 | 2497314 | 2022-05-12 | Wabaunsee | Kansas | 20197 | 1640 | 22 |
2497316 | 2497316 | 2022-05-12 | Washington | Kansas | 20201 | 1399 | 22 |
2497561 | 2497561 | 2022-05-12 | Unknown | Massachusetts | 146235 | 22 | |
2497731 | 2497731 | 2022-05-12 | Wilkin | Minnesota | 27167 | 1662 | 22 |
2497925 | 2497925 | 2022-05-12 | Sullivan | Missouri | 29211 | 1715 | 22 |
2498824 | 2498824 | 2022-05-12 | Kingsbury | South Dakota | 46077 | 1340 | 22 |
2499072 | 2499072 | 2022-05-12 | Jim Hogg | Texas | 48247 | 2648 | 22 |
2499340 | 2499340 | 2022-05-12 | Norton city | Virginia | 51720 | 1308 | 22 |
2499380 | 2499380 | 2022-05-12 | Williamsburg city | Virginia | 51830 | 1831 | 22 |
2499460 | 2499460 | 2022-05-12 | Pendleton | West Virginia | 54071 | 1998 | 22 |
2493468 | 2493468 | 2022-05-11 | Calhoun | Georgia | 13037 | 1364 | 22 |
2493475 | 2493475 | 2022-05-11 | Chattahoochee | Georgia | 13053 | 7486 | 22 |
2493928 | 2493928 | 2022-05-11 | Osceola | Iowa | 19143 | 1394 | 22 |
2493943 | 2493943 | 2022-05-11 | Taylor | Iowa | 19173 | 1316 | 22 |
2494018 | 2494018 | 2022-05-11 | Mitchell | Kansas | 20123 | 1426 | 22 |
2494056 | 2494056 | 2022-05-11 | Wabaunsee | Kansas | 20197 | 1640 | 22 |
2494058 | 2494058 | 2022-05-11 | Washington | Kansas | 20201 | 1399 | 22 |
2494303 | 2494303 | 2022-05-11 | Unknown | Massachusetts | 145286 | 22 | |
2494473 | 2494473 | 2022-05-11 | Wilkin | Minnesota | 27167 | 1661 | 22 |
2494667 | 2494667 | 2022-05-11 | Sullivan | Missouri | 29211 | 1715 | 22 |
2495566 | 2495566 | 2022-05-11 | Kingsbury | South Dakota | 46077 | 1340 | 22 |
2495814 | 2495814 | 2022-05-11 | Jim Hogg | Texas | 48247 | 2647 | 22 |
2496082 | 2496082 | 2022-05-11 | Norton city | Virginia | 51720 | 1306 | 22 |
2496122 | 2496122 | 2022-05-11 | Williamsburg city | Virginia | 51830 | 1825 | 22 |
2496202 | 2496202 | 2022-05-11 | Pendleton | West Virginia | 54071 | 1992 | 22 |
2490210 | 2490210 | 2022-05-10 | Calhoun | Georgia | 13037 | 1362 | 22 |
2490217 | 2490217 | 2022-05-10 | Chattahoochee | Georgia | 13053 | 7484 | 22 |
2490670 | 2490670 | 2022-05-10 | Osceola | Iowa | 19143 | 1394 | 22 |
2490685 | 2490685 | 2022-05-10 | Taylor | Iowa | 19173 | 1315 | 22 |
2490760 | 2490760 | 2022-05-10 | Mitchell | Kansas | 20123 | 1426 | 22 |
2490798 | 2490798 | 2022-05-10 | Wabaunsee | Kansas | 20197 | 1640 | 22 |
2490800 | 2490800 | 2022-05-10 | Washington | Kansas | 20201 | 1399 | 22 |
2491045 | 2491045 | 2022-05-10 | Unknown | Massachusetts | 144701 | 22 | |
2491215 | 2491215 | 2022-05-10 | Wilkin | Minnesota | 27167 | 1661 | 22 |
2491409 | 2491409 | 2022-05-10 | Sullivan | Missouri | 29211 | 1715 | 22 |
2492556 | 2492556 | 2022-05-10 | Jim Hogg | Texas | 48247 | 2644 | 22 |
2492824 | 2492824 | 2022-05-10 | Norton city | Virginia | 51720 | 1305 | 22 |
2492864 | 2492864 | 2022-05-10 | Williamsburg city | Virginia | 51830 | 1819 | 22 |
2492944 | 2492944 | 2022-05-10 | Pendleton | West Virginia | 54071 | 1987 | 22 |
2486953 | 2486953 | 2022-05-09 | Calhoun | Georgia | 13037 | 1362 | 22 |
2486960 | 2486960 | 2022-05-09 | Chattahoochee | Georgia | 13053 | 7484 | 22 |
2487413 | 2487413 | 2022-05-09 | Osceola | Iowa | 19143 | 1394 | 22 |
2487428 | 2487428 | 2022-05-09 | Taylor | Iowa | 19173 | 1315 | 22 |
2487503 | 2487503 | 2022-05-09 | Mitchell | Kansas | 20123 | 1426 | 22 |
2487541 | 2487541 | 2022-05-09 | Wabaunsee | Kansas | 20197 | 1640 | 22 |
2487543 | 2487543 | 2022-05-09 | Washington | Kansas | 20201 | 1399 | 22 |
2487788 | 2487788 | 2022-05-09 | Unknown | Massachusetts | 144011 | 22 | |
2487958 | 2487958 | 2022-05-09 | Wilkin | Minnesota | 27167 | 1661 | 22 |
2488151 | 2488151 | 2022-05-09 | Sullivan | Missouri | 29211 | 1715 | 22 |
2489298 | 2489298 | 2022-05-09 | Jim Hogg | Texas | 48247 | 2644 | 22 |
2489566 | 2489566 | 2022-05-09 | Norton city | Virginia | 51720 | 1305 | 22 |
2489606 | 2489606 | 2022-05-09 | Williamsburg city | Virginia | 51830 | 1816 | 22 |
2489686 | 2489686 | 2022-05-09 | Pendleton | West Virginia | 54071 | 1987 | 22 |
2483695 | 2483695 | 2022-05-08 | Calhoun | Georgia | 13037 | 1362 | 22 |
2483702 | 2483702 | 2022-05-08 | Chattahoochee | Georgia | 13053 | 7484 | 22 |
2484155 | 2484155 | 2022-05-08 | Osceola | Iowa | 19143 | 1394 | 22 |
2484170 | 2484170 | 2022-05-08 | Taylor | Iowa | 19173 | 1315 | 22 |
2484245 | 2484245 | 2022-05-08 | Mitchell | Kansas | 20123 | 1426 | 22 |
2484283 | 2484283 | 2022-05-08 | Wabaunsee | Kansas | 20197 | 1640 | 22 |
2484285 | 2484285 | 2022-05-08 | Washington | Kansas | 20201 | 1399 | 22 |
2484530 | 2484530 | 2022-05-08 | Unknown | Massachusetts | 143325 | 22 | |
2484700 | 2484700 | 2022-05-08 | Wilkin | Minnesota | 27167 | 1661 | 22 |
2484894 | 2484894 | 2022-05-08 | Sullivan | Missouri | 29211 | 1715 | 22 |
2486041 | 2486041 | 2022-05-08 | Jim Hogg | Texas | 48247 | 2641 | 22 |
2486309 | 2486309 | 2022-05-08 | Norton city | Virginia | 51720 | 1304 | 22 |
2486349 | 2486349 | 2022-05-08 | Williamsburg city | Virginia | 51830 | 1812 | 22 |
2486429 | 2486429 | 2022-05-08 | Pendleton | West Virginia | 54071 | 1979 | 22 |
2480437 | 2480437 | 2022-05-07 | Calhoun | Georgia | 13037 | 1362 | 22 |
2480444 | 2480444 | 2022-05-07 | Chattahoochee | Georgia | 13053 | 7484 | 22 |
2480897 | 2480897 | 2022-05-07 | Osceola | Iowa | 19143 | 1394 | 22 |
2480912 | 2480912 | 2022-05-07 | Taylor | Iowa | 19173 | 1315 | 22 |
2480987 | 2480987 | 2022-05-07 | Mitchell | Kansas | 20123 | 1426 | 22 |
2481025 | 2481025 | 2022-05-07 | Wabaunsee | Kansas | 20197 | 1640 | 22 |
2481027 | 2481027 | 2022-05-07 | Washington | Kansas | 20201 | 1399 | 22 |
2481272 | 2481272 | 2022-05-07 | Unknown | Massachusetts | 143325 | 22 | |
2481442 | 2481442 | 2022-05-07 | Wilkin | Minnesota | 27167 | 1661 | 22 |
2481636 | 2481636 | 2022-05-07 | Sullivan | Missouri | 29211 | 1715 | 22 |
2482783 | 2482783 | 2022-05-07 | Jim Hogg | Texas | 48247 | 2639 | 22 |
2483051 | 2483051 | 2022-05-07 | Norton city | Virginia | 51720 | 1304 | 22 |
2483091 | 2483091 | 2022-05-07 | Williamsburg city | Virginia | 51830 | 1812 | 22 |
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);