ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21,343 rows where deaths = 19 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
These facets timed out: county, fips
state >30
- Texas 1,632
- Georgia 1,266
- Nebraska 1,258
- Virginia 1,245
- Kentucky 1,114
- Missouri 1,069
- Minnesota 997
- Illinois 921
- Iowa 837
- North Dakota 824
- Kansas 741
- Wisconsin 556
- North Carolina 551
- Mississippi 508
- Tennessee 473
- Idaho 430
- Arkansas 425
- Indiana 418
- Florida 407
- Oklahoma 400
- Colorado 399
- West Virginia 381
- Michigan 356
- Louisiana 354
- Alabama 332
- Utah 325
- Montana 297
- South Dakota 292
- Alaska 277
- Ohio 268
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499651 | 2499651 | 2022-05-13 | Juneau City and Borough | Alaska | 2110 | 8798 | 19 |
2499666 | 2499666 | 2022-05-13 | Valdez-Cordova Census Area | Alaska | 2261 | 2948 | 19 |
2499868 | 2499868 | 2022-05-13 | Phillips | Colorado | 8095 | 894 | 19 |
2500253 | 2500253 | 2022-05-13 | Pulaski | Illinois | 17153 | 1730 | 19 |
2500337 | 2500337 | 2022-05-13 | Ohio | Indiana | 18115 | 1458 | 19 |
2500377 | 2500377 | 2022-05-13 | Audubon | Iowa | 19009 | 1114 | 19 |
2500610 | 2500610 | 2022-05-13 | Elliott | Kentucky | 21063 | 2594 | 19 |
2500932 | 2500932 | 2022-05-13 | Houston | Minnesota | 27055 | 4660 | 19 |
2501314 | 2501314 | 2022-05-13 | Otoe | Nebraska | 31131 | 3353 | 19 |
2501628 | 2501628 | 2022-05-13 | Sioux | North Dakota | 38085 | 1350 | 19 |
2502259 | 2502259 | 2022-05-13 | Crockett | Texas | 48105 | 1091 | 19 |
2502305 | 2502305 | 2022-05-13 | Hardeman | Texas | 48197 | 556 | 19 |
2502693 | 2502693 | 2022-05-13 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2502819 | 2502819 | 2022-05-13 | Johnson | Wyoming | 56019 | 1845 | 19 |
2496393 | 2496393 | 2022-05-12 | Juneau City and Borough | Alaska | 2110 | 8798 | 19 |
2496408 | 2496408 | 2022-05-12 | Valdez-Cordova Census Area | Alaska | 2261 | 2948 | 19 |
2496610 | 2496610 | 2022-05-12 | Phillips | Colorado | 8095 | 894 | 19 |
2496995 | 2496995 | 2022-05-12 | Pulaski | Illinois | 17153 | 1729 | 19 |
2497079 | 2497079 | 2022-05-12 | Ohio | Indiana | 18115 | 1456 | 19 |
2497119 | 2497119 | 2022-05-12 | Audubon | Iowa | 19009 | 1114 | 19 |
2497352 | 2497352 | 2022-05-12 | Elliott | Kentucky | 21063 | 2594 | 19 |
2497674 | 2497674 | 2022-05-12 | Houston | Minnesota | 27055 | 4653 | 19 |
2498056 | 2498056 | 2022-05-12 | Otoe | Nebraska | 31131 | 3350 | 19 |
2498370 | 2498370 | 2022-05-12 | Sioux | North Dakota | 38085 | 1348 | 19 |
2499001 | 2499001 | 2022-05-12 | Crockett | Texas | 48105 | 1091 | 19 |
2499047 | 2499047 | 2022-05-12 | Hardeman | Texas | 48197 | 556 | 19 |
2499435 | 2499435 | 2022-05-12 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2499561 | 2499561 | 2022-05-12 | Johnson | Wyoming | 56019 | 1845 | 19 |
2493135 | 2493135 | 2022-05-11 | Juneau City and Borough | Alaska | 2110 | 8798 | 19 |
2493150 | 2493150 | 2022-05-11 | Valdez-Cordova Census Area | Alaska | 2261 | 2948 | 19 |
2493352 | 2493352 | 2022-05-11 | Phillips | Colorado | 8095 | 890 | 19 |
2493737 | 2493737 | 2022-05-11 | Pulaski | Illinois | 17153 | 1728 | 19 |
2493821 | 2493821 | 2022-05-11 | Ohio | Indiana | 18115 | 1456 | 19 |
2493861 | 2493861 | 2022-05-11 | Audubon | Iowa | 19009 | 1114 | 19 |
2494094 | 2494094 | 2022-05-11 | Elliott | Kentucky | 21063 | 2594 | 19 |
2494798 | 2494798 | 2022-05-11 | Otoe | Nebraska | 31131 | 3350 | 19 |
2495112 | 2495112 | 2022-05-11 | Sioux | North Dakota | 38085 | 1348 | 19 |
2495743 | 2495743 | 2022-05-11 | Crockett | Texas | 48105 | 1091 | 19 |
2495789 | 2495789 | 2022-05-11 | Hardeman | Texas | 48197 | 556 | 19 |
2496177 | 2496177 | 2022-05-11 | Gilmer | West Virginia | 54021 | 2101 | 19 |
2496303 | 2496303 | 2022-05-11 | Johnson | Wyoming | 56019 | 1845 | 19 |
2489877 | 2489877 | 2022-05-10 | Juneau City and Borough | Alaska | 2110 | 8622 | 19 |
2490094 | 2490094 | 2022-05-10 | Phillips | Colorado | 8095 | 890 | 19 |
2490479 | 2490479 | 2022-05-10 | Pulaski | Illinois | 17153 | 1729 | 19 |
2490563 | 2490563 | 2022-05-10 | Ohio | Indiana | 18115 | 1455 | 19 |
2490603 | 2490603 | 2022-05-10 | Audubon | Iowa | 19009 | 1114 | 19 |
2490836 | 2490836 | 2022-05-10 | Elliott | Kentucky | 21063 | 2594 | 19 |
2491525 | 2491525 | 2022-05-10 | Keith | Nebraska | 31101 | 1548 | 19 |
2491540 | 2491540 | 2022-05-10 | Otoe | Nebraska | 31131 | 3385 | 19 |
2491586 | 2491586 | 2022-05-10 | White Pine | Nevada | 32033 | 1694 | 19 |
2491854 | 2491854 | 2022-05-10 | Sioux | North Dakota | 38085 | 1348 | 19 |
2492485 | 2492485 | 2022-05-10 | Crockett | Texas | 48105 | 1091 | 19 |
2492531 | 2492531 | 2022-05-10 | Hardeman | Texas | 48197 | 556 | 19 |
2492919 | 2492919 | 2022-05-10 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2493045 | 2493045 | 2022-05-10 | Johnson | Wyoming | 56019 | 1845 | 19 |
2486620 | 2486620 | 2022-05-09 | Juneau City and Borough | Alaska | 2110 | 8622 | 19 |
2486837 | 2486837 | 2022-05-09 | Phillips | Colorado | 8095 | 890 | 19 |
2487222 | 2487222 | 2022-05-09 | Pulaski | Illinois | 17153 | 1726 | 19 |
2487306 | 2487306 | 2022-05-09 | Ohio | Indiana | 18115 | 1455 | 19 |
2487346 | 2487346 | 2022-05-09 | Audubon | Iowa | 19009 | 1114 | 19 |
2487579 | 2487579 | 2022-05-09 | Elliott | Kentucky | 21063 | 2594 | 19 |
2488267 | 2488267 | 2022-05-09 | Keith | Nebraska | 31101 | 1548 | 19 |
2488282 | 2488282 | 2022-05-09 | Otoe | Nebraska | 31131 | 3385 | 19 |
2488328 | 2488328 | 2022-05-09 | White Pine | Nevada | 32033 | 1694 | 19 |
2488596 | 2488596 | 2022-05-09 | Sioux | North Dakota | 38085 | 1348 | 19 |
2489227 | 2489227 | 2022-05-09 | Crockett | Texas | 48105 | 1091 | 19 |
2489273 | 2489273 | 2022-05-09 | Hardeman | Texas | 48197 | 556 | 19 |
2489661 | 2489661 | 2022-05-09 | Gilmer | West Virginia | 54021 | 2098 | 19 |
2489787 | 2489787 | 2022-05-09 | Johnson | Wyoming | 56019 | 1845 | 19 |
2483362 | 2483362 | 2022-05-08 | Juneau City and Borough | Alaska | 2110 | 8622 | 19 |
2483579 | 2483579 | 2022-05-08 | Phillips | Colorado | 8095 | 890 | 19 |
2483964 | 2483964 | 2022-05-08 | Pulaski | Illinois | 17153 | 1726 | 19 |
2484048 | 2484048 | 2022-05-08 | Ohio | Indiana | 18115 | 1451 | 19 |
2484088 | 2484088 | 2022-05-08 | Audubon | Iowa | 19009 | 1114 | 19 |
2484321 | 2484321 | 2022-05-08 | Elliott | Kentucky | 21063 | 2563 | 19 |
2485010 | 2485010 | 2022-05-08 | Keith | Nebraska | 31101 | 1547 | 19 |
2485025 | 2485025 | 2022-05-08 | Otoe | Nebraska | 31131 | 3378 | 19 |
2485071 | 2485071 | 2022-05-08 | White Pine | Nevada | 32033 | 1694 | 19 |
2485339 | 2485339 | 2022-05-08 | Sioux | North Dakota | 38085 | 1348 | 19 |
2485970 | 2485970 | 2022-05-08 | Crockett | Texas | 48105 | 1091 | 19 |
2486016 | 2486016 | 2022-05-08 | Hardeman | Texas | 48197 | 556 | 19 |
2486404 | 2486404 | 2022-05-08 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2486530 | 2486530 | 2022-05-08 | Johnson | Wyoming | 56019 | 1845 | 19 |
2480104 | 2480104 | 2022-05-07 | Juneau City and Borough | Alaska | 2110 | 8622 | 19 |
2480321 | 2480321 | 2022-05-07 | Phillips | Colorado | 8095 | 890 | 19 |
2480706 | 2480706 | 2022-05-07 | Pulaski | Illinois | 17153 | 1726 | 19 |
2480790 | 2480790 | 2022-05-07 | Ohio | Indiana | 18115 | 1451 | 19 |
2480830 | 2480830 | 2022-05-07 | Audubon | Iowa | 19009 | 1114 | 19 |
2481063 | 2481063 | 2022-05-07 | Elliott | Kentucky | 21063 | 2563 | 19 |
2481752 | 2481752 | 2022-05-07 | Keith | Nebraska | 31101 | 1547 | 19 |
2481767 | 2481767 | 2022-05-07 | Otoe | Nebraska | 31131 | 3378 | 19 |
2481813 | 2481813 | 2022-05-07 | White Pine | Nevada | 32033 | 1694 | 19 |
2482081 | 2482081 | 2022-05-07 | Sioux | North Dakota | 38085 | 1348 | 19 |
2482712 | 2482712 | 2022-05-07 | Crockett | Texas | 48105 | 1091 | 19 |
2482758 | 2482758 | 2022-05-07 | Hardeman | Texas | 48197 | 556 | 19 |
2483146 | 2483146 | 2022-05-07 | Gilmer | West Virginia | 54021 | 2099 | 19 |
2483272 | 2483272 | 2022-05-07 | Johnson | Wyoming | 56019 | 1845 | 19 |
2476846 | 2476846 | 2022-05-06 | Juneau City and Borough | Alaska | 2110 | 8622 | 19 |
2477063 | 2477063 | 2022-05-06 | Phillips | Colorado | 8095 | 890 | 19 |
2477448 | 2477448 | 2022-05-06 | Pulaski | Illinois | 17153 | 1726 | 19 |
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);