ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
74 rows where county = "Clay" and deaths = 7 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 14
- Alabama 15
- Arkansas 10
- Indiana 9
- South Dakota 9
- Texas 8
- Kentucky 6
- Mississippi 5
- Florida 3
- Iowa 2
- Nebraska 2
- Tennessee 2
- Minnesota 1
- Missouri 1
- West Virginia 1
fips 14
county 1
- Clay · 74 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1111788 | 1111788 | 2021-03-11 | Clay | West Virginia | 54015 | 380 | 7 |
879934 | 879934 | 2020-12-30 | Clay | Nebraska | 31035 | 548 | 7 |
876689 | 876689 | 2020-12-29 | Clay | Nebraska | 31035 | 532 | 7 |
809507 | 809507 | 2020-12-08 | Clay | Texas | 48077 | 426 | 7 |
804417 | 804417 | 2020-12-07 | Clay | Iowa | 19041 | 1316 | 7 |
806262 | 806262 | 2020-12-07 | Clay | Texas | 48077 | 407 | 7 |
801172 | 801172 | 2020-12-06 | Clay | Iowa | 19041 | 1295 | 7 |
803017 | 803017 | 2020-12-06 | Clay | Texas | 48077 | 407 | 7 |
799772 | 799772 | 2020-12-05 | Clay | Texas | 48077 | 407 | 7 |
796527 | 796527 | 2020-12-04 | Clay | Texas | 48077 | 392 | 7 |
793282 | 793282 | 2020-12-03 | Clay | Texas | 48077 | 380 | 7 |
790037 | 790037 | 2020-12-02 | Clay | Texas | 48077 | 350 | 7 |
786792 | 786792 | 2020-12-01 | Clay | Texas | 48077 | 317 | 7 |
739718 | 739718 | 2020-11-17 | Clay | Kentucky | 21051 | 811 | 7 |
736474 | 736474 | 2020-11-16 | Clay | Kentucky | 21051 | 801 | 7 |
733228 | 733228 | 2020-11-15 | Clay | Kentucky | 21051 | 796 | 7 |
729983 | 729983 | 2020-11-14 | Clay | Kentucky | 21051 | 795 | 7 |
726740 | 726740 | 2020-11-13 | Clay | Kentucky | 21051 | 780 | 7 |
723497 | 723497 | 2020-11-12 | Clay | Kentucky | 21051 | 757 | 7 |
681020 | 681020 | 2020-10-30 | Clay | Indiana | 18021 | 513 | 7 |
677777 | 677777 | 2020-10-29 | Clay | Indiana | 18021 | 492 | 7 |
674534 | 674534 | 2020-10-28 | Clay | Indiana | 18021 | 475 | 7 |
671292 | 671292 | 2020-10-27 | Clay | Indiana | 18021 | 469 | 7 |
668049 | 668049 | 2020-10-26 | Clay | Indiana | 18021 | 461 | 7 |
664805 | 664805 | 2020-10-25 | Clay | Indiana | 18021 | 458 | 7 |
661560 | 661560 | 2020-10-24 | Clay | Indiana | 18021 | 456 | 7 |
658316 | 658316 | 2020-10-23 | Clay | Indiana | 18021 | 453 | 7 |
655071 | 655071 | 2020-10-22 | Clay | Indiana | 18021 | 446 | 7 |
637423 | 637423 | 2020-10-16 | Clay | Tennessee | 47027 | 351 | 7 |
634177 | 634177 | 2020-10-15 | Clay | Tennessee | 47027 | 351 | 7 |
614651 | 614651 | 2020-10-09 | Clay | South Dakota | 46027 | 619 | 7 |
611410 | 611410 | 2020-10-08 | Clay | South Dakota | 46027 | 606 | 7 |
608168 | 608168 | 2020-10-07 | Clay | South Dakota | 46027 | 603 | 7 |
604925 | 604925 | 2020-10-06 | Clay | South Dakota | 46027 | 589 | 7 |
601683 | 601683 | 2020-10-05 | Clay | South Dakota | 46027 | 586 | 7 |
598440 | 598440 | 2020-10-04 | Clay | South Dakota | 46027 | 585 | 7 |
595197 | 595197 | 2020-10-03 | Clay | South Dakota | 46027 | 581 | 7 |
591956 | 591956 | 2020-10-02 | Clay | South Dakota | 46027 | 576 | 7 |
588715 | 588715 | 2020-10-01 | Clay | South Dakota | 46027 | 572 | 7 |
566814 | 566814 | 2020-09-25 | Clay | Alabama | 1027 | 579 | 7 |
563573 | 563573 | 2020-09-24 | Clay | Alabama | 1027 | 570 | 7 |
563680 | 563680 | 2020-09-24 | Clay | Arkansas | 5021 | 284 | 7 |
560334 | 560334 | 2020-09-23 | Clay | Alabama | 1027 | 554 | 7 |
560441 | 560441 | 2020-09-23 | Clay | Arkansas | 5021 | 277 | 7 |
557098 | 557098 | 2020-09-22 | Clay | Alabama | 1027 | 553 | 7 |
557205 | 557205 | 2020-09-22 | Clay | Arkansas | 5021 | 267 | 7 |
553861 | 553861 | 2020-09-21 | Clay | Alabama | 1027 | 552 | 7 |
553968 | 553968 | 2020-09-21 | Clay | Arkansas | 5021 | 264 | 7 |
550622 | 550622 | 2020-09-20 | Clay | Alabama | 1027 | 542 | 7 |
550729 | 550729 | 2020-09-20 | Clay | Arkansas | 5021 | 260 | 7 |
547383 | 547383 | 2020-09-19 | Clay | Alabama | 1027 | 536 | 7 |
547490 | 547490 | 2020-09-19 | Clay | Arkansas | 5021 | 258 | 7 |
544146 | 544146 | 2020-09-18 | Clay | Alabama | 1027 | 531 | 7 |
544252 | 544252 | 2020-09-18 | Clay | Arkansas | 5021 | 254 | 7 |
540910 | 540910 | 2020-09-17 | Clay | Alabama | 1027 | 518 | 7 |
541016 | 541016 | 2020-09-17 | Clay | Arkansas | 5021 | 251 | 7 |
537673 | 537673 | 2020-09-16 | Clay | Alabama | 1027 | 505 | 7 |
537779 | 537779 | 2020-09-16 | Clay | Arkansas | 5021 | 244 | 7 |
534437 | 534437 | 2020-09-15 | Clay | Alabama | 1027 | 495 | 7 |
534543 | 534543 | 2020-09-15 | Clay | Arkansas | 5021 | 243 | 7 |
531202 | 531202 | 2020-09-14 | Clay | Alabama | 1027 | 486 | 7 |
527965 | 527965 | 2020-09-13 | Clay | Alabama | 1027 | 478 | 7 |
524729 | 524729 | 2020-09-12 | Clay | Alabama | 1027 | 464 | 7 |
521493 | 521493 | 2020-09-11 | Clay | Alabama | 1027 | 460 | 7 |
282185 | 282185 | 2020-06-28 | Clay | Mississippi | 28025 | 235 | 7 |
279037 | 279037 | 2020-06-27 | Clay | Mississippi | 28025 | 234 | 7 |
275889 | 275889 | 2020-06-26 | Clay | Mississippi | 28025 | 233 | 7 |
272746 | 272746 | 2020-06-25 | Clay | Mississippi | 28025 | 229 | 7 |
269609 | 269609 | 2020-06-24 | Clay | Mississippi | 28025 | 222 | 7 |
244727 | 244727 | 2020-06-16 | Clay | Missouri | 29047 | 299 | 7 |
88088 | 88088 | 2020-04-25 | Clay | Minnesota | 27027 | 113 | 7 |
43493 | 43493 | 2020-04-09 | Clay | Florida | 12019 | 110 | 7 |
40919 | 40919 | 2020-04-08 | Clay | Florida | 12019 | 99 | 7 |
38376 | 38376 | 2020-04-07 | Clay | Florida | 12019 | 88 | 7 |
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);