ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
92 rows where county = "Clay" and deaths = 10 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 10
- West Virginia 35
- Texas 14
- Nebraska 13
- Iowa 10
- Mississippi 6
- South Dakota 5
- Arkansas 3
- Kentucky 3
- Minnesota 2
- Indiana 1
county 1
- Clay · 92 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1462426 | 1462426 | 2021-06-27 | Clay | West Virginia | 54015 | 542 | 10 |
1459181 | 1459181 | 2021-06-26 | Clay | West Virginia | 54015 | 542 | 10 |
1455936 | 1455936 | 2021-06-25 | Clay | West Virginia | 54015 | 542 | 10 |
1452691 | 1452691 | 2021-06-24 | Clay | West Virginia | 54015 | 542 | 10 |
1449445 | 1449445 | 2021-06-23 | Clay | West Virginia | 54015 | 543 | 10 |
1446200 | 1446200 | 2021-06-22 | Clay | West Virginia | 54015 | 542 | 10 |
1442955 | 1442955 | 2021-06-21 | Clay | West Virginia | 54015 | 542 | 10 |
1439710 | 1439710 | 2021-06-20 | Clay | West Virginia | 54015 | 542 | 10 |
1436463 | 1436463 | 2021-06-19 | Clay | West Virginia | 54015 | 542 | 10 |
1433216 | 1433216 | 2021-06-18 | Clay | West Virginia | 54015 | 542 | 10 |
1429970 | 1429970 | 2021-06-17 | Clay | West Virginia | 54015 | 542 | 10 |
1426725 | 1426725 | 2021-06-16 | Clay | West Virginia | 54015 | 541 | 10 |
1423479 | 1423479 | 2021-06-15 | Clay | West Virginia | 54015 | 541 | 10 |
1420232 | 1420232 | 2021-06-14 | Clay | West Virginia | 54015 | 541 | 10 |
1416987 | 1416987 | 2021-06-13 | Clay | West Virginia | 54015 | 542 | 10 |
1413741 | 1413741 | 2021-06-12 | Clay | West Virginia | 54015 | 542 | 10 |
1410496 | 1410496 | 2021-06-11 | Clay | West Virginia | 54015 | 542 | 10 |
1407251 | 1407251 | 2021-06-10 | Clay | West Virginia | 54015 | 542 | 10 |
1404005 | 1404005 | 2021-06-09 | Clay | West Virginia | 54015 | 540 | 10 |
1400760 | 1400760 | 2021-06-08 | Clay | West Virginia | 54015 | 540 | 10 |
1397515 | 1397515 | 2021-06-07 | Clay | West Virginia | 54015 | 540 | 10 |
1394268 | 1394268 | 2021-06-06 | Clay | West Virginia | 54015 | 539 | 10 |
1391023 | 1391023 | 2021-06-05 | Clay | West Virginia | 54015 | 539 | 10 |
1387778 | 1387778 | 2021-06-04 | Clay | West Virginia | 54015 | 539 | 10 |
1384533 | 1384533 | 2021-06-03 | Clay | West Virginia | 54015 | 539 | 10 |
1381287 | 1381287 | 2021-06-02 | Clay | West Virginia | 54015 | 539 | 10 |
1378042 | 1378042 | 2021-06-01 | Clay | West Virginia | 54015 | 539 | 10 |
1374796 | 1374796 | 2021-05-31 | Clay | West Virginia | 54015 | 537 | 10 |
1371551 | 1371551 | 2021-05-30 | Clay | West Virginia | 54015 | 537 | 10 |
1368305 | 1368305 | 2021-05-29 | Clay | West Virginia | 54015 | 537 | 10 |
1365059 | 1365059 | 2021-05-28 | Clay | West Virginia | 54015 | 537 | 10 |
1361813 | 1361813 | 2021-05-27 | Clay | West Virginia | 54015 | 536 | 10 |
1358567 | 1358567 | 2021-05-26 | Clay | West Virginia | 54015 | 536 | 10 |
1355321 | 1355321 | 2021-05-25 | Clay | West Virginia | 54015 | 536 | 10 |
1352075 | 1352075 | 2021-05-24 | Clay | West Virginia | 54015 | 535 | 10 |
1013000 | 1013000 | 2021-02-09 | Clay | Nebraska | 31035 | 646 | 10 |
1009755 | 1009755 | 2021-02-08 | Clay | Nebraska | 31035 | 646 | 10 |
1006508 | 1006508 | 2021-02-07 | Clay | Nebraska | 31035 | 646 | 10 |
1003262 | 1003262 | 2021-02-06 | Clay | Nebraska | 31035 | 643 | 10 |
1000017 | 1000017 | 2021-02-05 | Clay | Nebraska | 31035 | 641 | 10 |
996771 | 996771 | 2021-02-04 | Clay | Nebraska | 31035 | 640 | 10 |
993525 | 993525 | 2021-02-03 | Clay | Nebraska | 31035 | 638 | 10 |
990279 | 990279 | 2021-02-02 | Clay | Nebraska | 31035 | 637 | 10 |
987032 | 987032 | 2021-02-01 | Clay | Nebraska | 31035 | 636 | 10 |
983785 | 983785 | 2021-01-31 | Clay | Nebraska | 31035 | 636 | 10 |
980539 | 980539 | 2021-01-30 | Clay | Nebraska | 31035 | 634 | 10 |
977293 | 977293 | 2021-01-29 | Clay | Nebraska | 31035 | 627 | 10 |
974048 | 974048 | 2021-01-28 | Clay | Nebraska | 31035 | 627 | 10 |
921463 | 921463 | 2021-01-12 | Clay | Kentucky | 21051 | 1986 | 10 |
918218 | 918218 | 2021-01-11 | Clay | Kentucky | 21051 | 1964 | 10 |
914973 | 914973 | 2021-01-10 | Clay | Kentucky | 21051 | 1954 | 10 |
897136 | 897136 | 2021-01-04 | Clay | Texas | 48077 | 715 | 10 |
893890 | 893890 | 2021-01-03 | Clay | Texas | 48077 | 715 | 10 |
890644 | 890644 | 2021-01-02 | Clay | Texas | 48077 | 715 | 10 |
887397 | 887397 | 2021-01-01 | Clay | Texas | 48077 | 715 | 10 |
884152 | 884152 | 2020-12-31 | Clay | Texas | 48077 | 710 | 10 |
880907 | 880907 | 2020-12-30 | Clay | Texas | 48077 | 701 | 10 |
877662 | 877662 | 2020-12-29 | Clay | Texas | 48077 | 692 | 10 |
874417 | 874417 | 2020-12-28 | Clay | Texas | 48077 | 665 | 10 |
871172 | 871172 | 2020-12-27 | Clay | Texas | 48077 | 665 | 10 |
867927 | 867927 | 2020-12-26 | Clay | Texas | 48077 | 638 | 10 |
864682 | 864682 | 2020-12-25 | Clay | Texas | 48077 | 638 | 10 |
861437 | 861437 | 2020-12-24 | Clay | Texas | 48077 | 638 | 10 |
858192 | 858192 | 2020-12-23 | Clay | Texas | 48077 | 630 | 10 |
854947 | 854947 | 2020-12-22 | Clay | Texas | 48077 | 620 | 10 |
843366 | 843366 | 2020-12-19 | Clay | Iowa | 19041 | 1484 | 10 |
840121 | 840121 | 2020-12-18 | Clay | Iowa | 19041 | 1467 | 10 |
836876 | 836876 | 2020-12-17 | Clay | Iowa | 19041 | 1455 | 10 |
833630 | 833630 | 2020-12-16 | Clay | Iowa | 19041 | 1442 | 10 |
830383 | 830383 | 2020-12-15 | Clay | Iowa | 19041 | 1427 | 10 |
827137 | 827137 | 2020-12-14 | Clay | Iowa | 19041 | 1409 | 10 |
823890 | 823890 | 2020-12-13 | Clay | Iowa | 19041 | 1401 | 10 |
820644 | 820644 | 2020-12-12 | Clay | Iowa | 19041 | 1396 | 10 |
817398 | 817398 | 2020-12-11 | Clay | Iowa | 19041 | 1380 | 10 |
814152 | 814152 | 2020-12-10 | Clay | Iowa | 19041 | 1354 | 10 |
786604 | 786604 | 2020-12-01 | Clay | South Dakota | 46027 | 1377 | 10 |
783360 | 783360 | 2020-11-30 | Clay | South Dakota | 46027 | 1373 | 10 |
780115 | 780115 | 2020-11-29 | Clay | South Dakota | 46027 | 1368 | 10 |
776869 | 776869 | 2020-11-28 | Clay | South Dakota | 46027 | 1349 | 10 |
773624 | 773624 | 2020-11-27 | Clay | South Dakota | 46027 | 1338 | 10 |
687507 | 687507 | 2020-11-01 | Clay | Indiana | 18021 | 554 | 10 |
605818 | 605818 | 2020-10-07 | Clay | Arkansas | 5021 | 352 | 10 |
602576 | 602576 | 2020-10-06 | Clay | Arkansas | 5021 | 347 | 10 |
599333 | 599333 | 2020-10-05 | Clay | Arkansas | 5021 | 342 | 10 |
304270 | 304270 | 2020-07-05 | Clay | Mississippi | 28025 | 250 | 10 |
301106 | 301106 | 2020-07-04 | Clay | Mississippi | 28025 | 249 | 10 |
297943 | 297943 | 2020-07-03 | Clay | Mississippi | 28025 | 247 | 10 |
294785 | 294785 | 2020-07-02 | Clay | Mississippi | 28025 | 244 | 10 |
291631 | 291631 | 2020-07-01 | Clay | Mississippi | 28025 | 242 | 10 |
288480 | 288480 | 2020-06-30 | Clay | Mississippi | 28025 | 240 | 10 |
99406 | 99406 | 2020-04-29 | Clay | Minnesota | 27027 | 152 | 10 |
96560 | 96560 | 2020-04-28 | Clay | Minnesota | 27027 | 149 | 10 |
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);