ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marion" and state = "Kentucky" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934493 | 934493 | 2021-01-16 | Marion | Kentucky | 21155 | 1742 | 20 |
931248 | 931248 | 2021-01-15 | Marion | Kentucky | 21155 | 1729 | 20 |
928003 | 928003 | 2021-01-14 | Marion | Kentucky | 21155 | 1719 | 20 |
924757 | 924757 | 2021-01-13 | Marion | Kentucky | 21155 | 1706 | 20 |
921512 | 921512 | 2021-01-12 | Marion | Kentucky | 21155 | 1692 | 20 |
918267 | 918267 | 2021-01-11 | Marion | Kentucky | 21155 | 1686 | 20 |
915022 | 915022 | 2021-01-10 | Marion | Kentucky | 21155 | 1674 | 20 |
911777 | 911777 | 2021-01-09 | Marion | Kentucky | 21155 | 1665 | 20 |
908532 | 908532 | 2021-01-08 | Marion | Kentucky | 21155 | 1638 | 20 |
905286 | 905286 | 2021-01-07 | Marion | Kentucky | 21155 | 1624 | 20 |
902041 | 902041 | 2021-01-06 | Marion | Kentucky | 21155 | 1605 | 20 |
898796 | 898796 | 2021-01-05 | Marion | Kentucky | 21155 | 1561 | 20 |
895551 | 895551 | 2021-01-04 | Marion | Kentucky | 21155 | 1548 | 20 |
892304 | 892304 | 2021-01-03 | Marion | Kentucky | 21155 | 1548 | 20 |
889058 | 889058 | 2021-01-02 | Marion | Kentucky | 21155 | 1546 | 20 |
885812 | 885812 | 2021-01-01 | Marion | Kentucky | 21155 | 1510 | 20 |
882567 | 882567 | 2020-12-31 | Marion | Kentucky | 21155 | 1510 | 20 |
879322 | 879322 | 2020-12-30 | Marion | Kentucky | 21155 | 1510 | 20 |
876077 | 876077 | 2020-12-29 | Marion | Kentucky | 21155 | 1502 | 20 |
872832 | 872832 | 2020-12-28 | Marion | Kentucky | 21155 | 1489 | 20 |
869587 | 869587 | 2020-12-27 | Marion | Kentucky | 21155 | 1489 | 20 |
866342 | 866342 | 2020-12-26 | Marion | Kentucky | 21155 | 1486 | 20 |
863097 | 863097 | 2020-12-25 | Marion | Kentucky | 21155 | 1472 | 20 |
859852 | 859852 | 2020-12-24 | Marion | Kentucky | 21155 | 1472 | 20 |
856607 | 856607 | 2020-12-23 | Marion | Kentucky | 21155 | 1472 | 20 |
853362 | 853362 | 2020-12-22 | Marion | Kentucky | 21155 | 1446 | 20 |
850117 | 850117 | 2020-12-21 | Marion | Kentucky | 21155 | 1436 | 17 |
846872 | 846872 | 2020-12-20 | Marion | Kentucky | 21155 | 1434 | 17 |
843626 | 843626 | 2020-12-19 | Marion | Kentucky | 21155 | 1431 | 17 |
840381 | 840381 | 2020-12-18 | Marion | Kentucky | 21155 | 1417 | 16 |
837136 | 837136 | 2020-12-17 | Marion | Kentucky | 21155 | 1399 | 16 |
833890 | 833890 | 2020-12-16 | Marion | Kentucky | 21155 | 1371 | 16 |
830643 | 830643 | 2020-12-15 | Marion | Kentucky | 21155 | 1364 | 14 |
827397 | 827397 | 2020-12-14 | Marion | Kentucky | 21155 | 1342 | 14 |
824150 | 824150 | 2020-12-13 | Marion | Kentucky | 21155 | 1328 | 14 |
820904 | 820904 | 2020-12-12 | Marion | Kentucky | 21155 | 1319 | 14 |
817658 | 817658 | 2020-12-11 | Marion | Kentucky | 21155 | 1292 | 14 |
814412 | 814412 | 2020-12-10 | Marion | Kentucky | 21155 | 1276 | 14 |
811167 | 811167 | 2020-12-09 | Marion | Kentucky | 21155 | 1257 | 14 |
807922 | 807922 | 2020-12-08 | Marion | Kentucky | 21155 | 1247 | 14 |
804677 | 804677 | 2020-12-07 | Marion | Kentucky | 21155 | 1199 | 14 |
801432 | 801432 | 2020-12-06 | Marion | Kentucky | 21155 | 1190 | 14 |
798187 | 798187 | 2020-12-05 | Marion | Kentucky | 21155 | 1187 | 14 |
794942 | 794942 | 2020-12-04 | Marion | Kentucky | 21155 | 1160 | 14 |
791697 | 791697 | 2020-12-03 | Marion | Kentucky | 21155 | 1122 | 13 |
788452 | 788452 | 2020-12-02 | Marion | Kentucky | 21155 | 1097 | 12 |
785208 | 785208 | 2020-12-01 | Marion | Kentucky | 21155 | 1030 | 12 |
781963 | 781963 | 2020-11-30 | Marion | Kentucky | 21155 | 974 | 12 |
778717 | 778717 | 2020-11-29 | Marion | Kentucky | 21155 | 965 | 12 |
775472 | 775472 | 2020-11-28 | Marion | Kentucky | 21155 | 950 | 12 |
772227 | 772227 | 2020-11-27 | Marion | Kentucky | 21155 | 947 | 12 |
768982 | 768982 | 2020-11-26 | Marion | Kentucky | 21155 | 910 | 12 |
765736 | 765736 | 2020-11-25 | Marion | Kentucky | 21155 | 910 | 12 |
762491 | 762491 | 2020-11-24 | Marion | Kentucky | 21155 | 906 | 12 |
759246 | 759246 | 2020-11-23 | Marion | Kentucky | 21155 | 878 | 12 |
755999 | 755999 | 2020-11-22 | Marion | Kentucky | 21155 | 869 | 12 |
752753 | 752753 | 2020-11-21 | Marion | Kentucky | 21155 | 866 | 12 |
749507 | 749507 | 2020-11-20 | Marion | Kentucky | 21155 | 848 | 12 |
746261 | 746261 | 2020-11-19 | Marion | Kentucky | 21155 | 814 | 12 |
743014 | 743014 | 2020-11-18 | Marion | Kentucky | 21155 | 789 | 12 |
739767 | 739767 | 2020-11-17 | Marion | Kentucky | 21155 | 763 | 12 |
736523 | 736523 | 2020-11-16 | Marion | Kentucky | 21155 | 744 | 12 |
733277 | 733277 | 2020-11-15 | Marion | Kentucky | 21155 | 728 | 12 |
730032 | 730032 | 2020-11-14 | Marion | Kentucky | 21155 | 714 | 12 |
726789 | 726789 | 2020-11-13 | Marion | Kentucky | 21155 | 706 | 12 |
723546 | 723546 | 2020-11-12 | Marion | Kentucky | 21155 | 672 | 11 |
720303 | 720303 | 2020-11-11 | Marion | Kentucky | 21155 | 638 | 11 |
717060 | 717060 | 2020-11-10 | Marion | Kentucky | 21155 | 638 | 11 |
713816 | 713816 | 2020-11-09 | Marion | Kentucky | 21155 | 627 | 11 |
710572 | 710572 | 2020-11-08 | Marion | Kentucky | 21155 | 604 | 11 |
707328 | 707328 | 2020-11-07 | Marion | Kentucky | 21155 | 603 | 11 |
704085 | 704085 | 2020-11-06 | Marion | Kentucky | 21155 | 603 | 11 |
700843 | 700843 | 2020-11-05 | Marion | Kentucky | 21155 | 583 | 11 |
697599 | 697599 | 2020-11-04 | Marion | Kentucky | 21155 | 566 | 11 |
694356 | 694356 | 2020-11-03 | Marion | Kentucky | 21155 | 553 | 11 |
691114 | 691114 | 2020-11-02 | Marion | Kentucky | 21155 | 553 | 11 |
687869 | 687869 | 2020-11-01 | Marion | Kentucky | 21155 | 538 | 11 |
684625 | 684625 | 2020-10-31 | Marion | Kentucky | 21155 | 527 | 11 |
681382 | 681382 | 2020-10-30 | Marion | Kentucky | 21155 | 520 | 11 |
678138 | 678138 | 2020-10-29 | Marion | Kentucky | 21155 | 514 | 11 |
674896 | 674896 | 2020-10-28 | Marion | Kentucky | 21155 | 505 | 11 |
671653 | 671653 | 2020-10-27 | Marion | Kentucky | 21155 | 476 | 11 |
668411 | 668411 | 2020-10-26 | Marion | Kentucky | 21155 | 436 | 11 |
665167 | 665167 | 2020-10-25 | Marion | Kentucky | 21155 | 434 | 11 |
661922 | 661922 | 2020-10-24 | Marion | Kentucky | 21155 | 419 | 11 |
658678 | 658678 | 2020-10-23 | Marion | Kentucky | 21155 | 404 | 11 |
655433 | 655433 | 2020-10-22 | Marion | Kentucky | 21155 | 391 | 11 |
652188 | 652188 | 2020-10-21 | Marion | Kentucky | 21155 | 370 | 10 |
648943 | 648943 | 2020-10-20 | Marion | Kentucky | 21155 | 359 | 10 |
645699 | 645699 | 2020-10-19 | Marion | Kentucky | 21155 | 346 | 10 |
642452 | 642452 | 2020-10-18 | Marion | Kentucky | 21155 | 337 | 10 |
639205 | 639205 | 2020-10-17 | Marion | Kentucky | 21155 | 331 | 10 |
635959 | 635959 | 2020-10-16 | Marion | Kentucky | 21155 | 326 | 10 |
632713 | 632713 | 2020-10-15 | Marion | Kentucky | 21155 | 312 | 10 |
629469 | 629469 | 2020-10-14 | Marion | Kentucky | 21155 | 302 | 10 |
626225 | 626225 | 2020-10-13 | Marion | Kentucky | 21155 | 295 | 10 |
622983 | 622983 | 2020-10-12 | Marion | Kentucky | 21155 | 284 | 10 |
619739 | 619739 | 2020-10-11 | Marion | Kentucky | 21155 | 278 | 10 |
616497 | 616497 | 2020-10-10 | Marion | Kentucky | 21155 | 269 | 10 |
613256 | 613256 | 2020-10-09 | Marion | Kentucky | 21155 | 264 | 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);