ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Clinton" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934939 | 934939 | 2021-01-16 | Clinton | Missouri | 29049 | 1412 | 60 |
931694 | 931694 | 2021-01-15 | Clinton | Missouri | 29049 | 1405 | 60 |
928449 | 928449 | 2021-01-14 | Clinton | Missouri | 29049 | 1392 | 60 |
925203 | 925203 | 2021-01-13 | Clinton | Missouri | 29049 | 1385 | 60 |
921958 | 921958 | 2021-01-12 | Clinton | Missouri | 29049 | 1381 | 60 |
918713 | 918713 | 2021-01-11 | Clinton | Missouri | 29049 | 1369 | 59 |
915468 | 915468 | 2021-01-10 | Clinton | Missouri | 29049 | 1366 | 59 |
912223 | 912223 | 2021-01-09 | Clinton | Missouri | 29049 | 1360 | 59 |
908978 | 908978 | 2021-01-08 | Clinton | Missouri | 29049 | 1348 | 59 |
905732 | 905732 | 2021-01-07 | Clinton | Missouri | 29049 | 1321 | 59 |
902487 | 902487 | 2021-01-06 | Clinton | Missouri | 29049 | 1302 | 59 |
899242 | 899242 | 2021-01-05 | Clinton | Missouri | 29049 | 1297 | 59 |
895997 | 895997 | 2021-01-04 | Clinton | Missouri | 29049 | 1295 | 56 |
892750 | 892750 | 2021-01-03 | Clinton | Missouri | 29049 | 1295 | 56 |
889504 | 889504 | 2021-01-02 | Clinton | Missouri | 29049 | 1281 | 56 |
886258 | 886258 | 2021-01-01 | Clinton | Missouri | 29049 | 1272 | 56 |
883013 | 883013 | 2020-12-31 | Clinton | Missouri | 29049 | 1248 | 56 |
879768 | 879768 | 2020-12-30 | Clinton | Missouri | 29049 | 1241 | 56 |
876523 | 876523 | 2020-12-29 | Clinton | Missouri | 29049 | 1223 | 56 |
873278 | 873278 | 2020-12-28 | Clinton | Missouri | 29049 | 1211 | 56 |
870033 | 870033 | 2020-12-27 | Clinton | Missouri | 29049 | 1214 | 56 |
866788 | 866788 | 2020-12-26 | Clinton | Missouri | 29049 | 1208 | 56 |
863543 | 863543 | 2020-12-25 | Clinton | Missouri | 29049 | 1205 | 56 |
860298 | 860298 | 2020-12-24 | Clinton | Missouri | 29049 | 1195 | 56 |
857053 | 857053 | 2020-12-23 | Clinton | Missouri | 29049 | 1179 | 55 |
853808 | 853808 | 2020-12-22 | Clinton | Missouri | 29049 | 1173 | 53 |
850563 | 850563 | 2020-12-21 | Clinton | Missouri | 29049 | 1164 | 50 |
847318 | 847318 | 2020-12-20 | Clinton | Missouri | 29049 | 1156 | 50 |
844072 | 844072 | 2020-12-19 | Clinton | Missouri | 29049 | 1145 | 50 |
840827 | 840827 | 2020-12-18 | Clinton | Missouri | 29049 | 1138 | 49 |
837582 | 837582 | 2020-12-17 | Clinton | Missouri | 29049 | 1121 | 49 |
834336 | 834336 | 2020-12-16 | Clinton | Missouri | 29049 | 1102 | 49 |
831089 | 831089 | 2020-12-15 | Clinton | Missouri | 29049 | 1096 | 49 |
827843 | 827843 | 2020-12-14 | Clinton | Missouri | 29049 | 1094 | 48 |
824596 | 824596 | 2020-12-13 | Clinton | Missouri | 29049 | 1081 | 48 |
821350 | 821350 | 2020-12-12 | Clinton | Missouri | 29049 | 1069 | 48 |
818104 | 818104 | 2020-12-11 | Clinton | Missouri | 29049 | 1037 | 48 |
814858 | 814858 | 2020-12-10 | Clinton | Missouri | 29049 | 1037 | 48 |
811613 | 811613 | 2020-12-09 | Clinton | Missouri | 29049 | 1015 | 48 |
808368 | 808368 | 2020-12-08 | Clinton | Missouri | 29049 | 1014 | 48 |
805123 | 805123 | 2020-12-07 | Clinton | Missouri | 29049 | 996 | 47 |
801878 | 801878 | 2020-12-06 | Clinton | Missouri | 29049 | 984 | 47 |
798633 | 798633 | 2020-12-05 | Clinton | Missouri | 29049 | 968 | 47 |
795388 | 795388 | 2020-12-04 | Clinton | Missouri | 29049 | 951 | 47 |
792143 | 792143 | 2020-12-03 | Clinton | Missouri | 29049 | 933 | 47 |
788898 | 788898 | 2020-12-02 | Clinton | Missouri | 29049 | 913 | 46 |
785653 | 785653 | 2020-12-01 | Clinton | Missouri | 29049 | 904 | 46 |
782409 | 782409 | 2020-11-30 | Clinton | Missouri | 29049 | 895 | 45 |
779163 | 779163 | 2020-11-29 | Clinton | Missouri | 29049 | 884 | 45 |
775918 | 775918 | 2020-11-28 | Clinton | Missouri | 29049 | 868 | 44 |
772673 | 772673 | 2020-11-27 | Clinton | Missouri | 29049 | 861 | 44 |
769428 | 769428 | 2020-11-26 | Clinton | Missouri | 29049 | 853 | 44 |
766182 | 766182 | 2020-11-25 | Clinton | Missouri | 29049 | 847 | 44 |
762937 | 762937 | 2020-11-24 | Clinton | Missouri | 29049 | 833 | 44 |
759692 | 759692 | 2020-11-23 | Clinton | Missouri | 29049 | 829 | 42 |
756445 | 756445 | 2020-11-22 | Clinton | Missouri | 29049 | 824 | 42 |
753199 | 753199 | 2020-11-21 | Clinton | Missouri | 29049 | 814 | 42 |
749953 | 749953 | 2020-11-20 | Clinton | Missouri | 29049 | 800 | 41 |
746707 | 746707 | 2020-11-19 | Clinton | Missouri | 29049 | 786 | 41 |
743460 | 743460 | 2020-11-18 | Clinton | Missouri | 29049 | 779 | 39 |
740213 | 740213 | 2020-11-17 | Clinton | Missouri | 29049 | 765 | 39 |
736969 | 736969 | 2020-11-16 | Clinton | Missouri | 29049 | 744 | 38 |
733723 | 733723 | 2020-11-15 | Clinton | Missouri | 29049 | 735 | 38 |
730478 | 730478 | 2020-11-14 | Clinton | Missouri | 29049 | 735 | 38 |
727235 | 727235 | 2020-11-13 | Clinton | Missouri | 29049 | 701 | 38 |
723992 | 723992 | 2020-11-12 | Clinton | Missouri | 29049 | 683 | 38 |
720749 | 720749 | 2020-11-11 | Clinton | Missouri | 29049 | 667 | 33 |
717506 | 717506 | 2020-11-10 | Clinton | Missouri | 29049 | 653 | 33 |
714262 | 714262 | 2020-11-09 | Clinton | Missouri | 29049 | 643 | 33 |
711018 | 711018 | 2020-11-08 | Clinton | Missouri | 29049 | 628 | 33 |
707774 | 707774 | 2020-11-07 | Clinton | Missouri | 29049 | 623 | 33 |
704531 | 704531 | 2020-11-06 | Clinton | Missouri | 29049 | 607 | 29 |
701289 | 701289 | 2020-11-05 | Clinton | Missouri | 29049 | 594 | 29 |
698045 | 698045 | 2020-11-04 | Clinton | Missouri | 29049 | 588 | 29 |
694802 | 694802 | 2020-11-03 | Clinton | Missouri | 29049 | 574 | 25 |
691560 | 691560 | 2020-11-02 | Clinton | Missouri | 29049 | 570 | 25 |
688315 | 688315 | 2020-11-01 | Clinton | Missouri | 29049 | 558 | 24 |
685071 | 685071 | 2020-10-31 | Clinton | Missouri | 29049 | 540 | 24 |
681828 | 681828 | 2020-10-30 | Clinton | Missouri | 29049 | 532 | 23 |
678584 | 678584 | 2020-10-29 | Clinton | Missouri | 29049 | 521 | 22 |
675342 | 675342 | 2020-10-28 | Clinton | Missouri | 29049 | 509 | 19 |
672099 | 672099 | 2020-10-27 | Clinton | Missouri | 29049 | 502 | 17 |
668857 | 668857 | 2020-10-26 | Clinton | Missouri | 29049 | 495 | 17 |
665613 | 665613 | 2020-10-25 | Clinton | Missouri | 29049 | 487 | 15 |
662368 | 662368 | 2020-10-24 | Clinton | Missouri | 29049 | 479 | 15 |
659124 | 659124 | 2020-10-23 | Clinton | Missouri | 29049 | 463 | 14 |
655879 | 655879 | 2020-10-22 | Clinton | Missouri | 29049 | 447 | 13 |
652634 | 652634 | 2020-10-21 | Clinton | Missouri | 29049 | 436 | 10 |
649389 | 649389 | 2020-10-20 | Clinton | Missouri | 29049 | 427 | 10 |
646145 | 646145 | 2020-10-19 | Clinton | Missouri | 29049 | 427 | 10 |
642899 | 642899 | 2020-10-18 | Clinton | Missouri | 29049 | 420 | 8 |
639651 | 639651 | 2020-10-17 | Clinton | Missouri | 29049 | 408 | 7 |
636405 | 636405 | 2020-10-16 | Clinton | Missouri | 29049 | 402 | 7 |
633159 | 633159 | 2020-10-15 | Clinton | Missouri | 29049 | 385 | 4 |
629914 | 629914 | 2020-10-14 | Clinton | Missouri | 29049 | 371 | 5 |
626670 | 626670 | 2020-10-13 | Clinton | Missouri | 29049 | 333 | 0 |
623428 | 623428 | 2020-10-12 | Clinton | Missouri | 29049 | 333 | 0 |
620185 | 620185 | 2020-10-11 | Clinton | Missouri | 29049 | 333 | 0 |
616943 | 616943 | 2020-10-10 | Clinton | Missouri | 29049 | 333 | 0 |
613702 | 613702 | 2020-10-09 | Clinton | Missouri | 29049 | 302 | 0 |
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);