ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29049 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
610460 | 610460 | 2020-10-08 | Clinton | Missouri | 29049 | 293 | 0 |
607218 | 607218 | 2020-10-07 | Clinton | Missouri | 29049 | 280 | 0 |
603975 | 603975 | 2020-10-06 | Clinton | Missouri | 29049 | 274 | 0 |
600733 | 600733 | 2020-10-05 | Clinton | Missouri | 29049 | 269 | 0 |
597490 | 597490 | 2020-10-04 | Clinton | Missouri | 29049 | 265 | 0 |
594249 | 594249 | 2020-10-03 | Clinton | Missouri | 29049 | 262 | 0 |
591008 | 591008 | 2020-10-02 | Clinton | Missouri | 29049 | 253 | 0 |
587767 | 587767 | 2020-10-01 | Clinton | Missouri | 29049 | 250 | 0 |
584527 | 584527 | 2020-09-30 | Clinton | Missouri | 29049 | 236 | 0 |
581286 | 581286 | 2020-09-29 | Clinton | Missouri | 29049 | 244 | 0 |
578045 | 578045 | 2020-09-28 | Clinton | Missouri | 29049 | 244 | 0 |
574804 | 574804 | 2020-09-27 | Clinton | Missouri | 29049 | 241 | 0 |
571561 | 571561 | 2020-09-26 | Clinton | Missouri | 29049 | 236 | 0 |
568319 | 568319 | 2020-09-25 | Clinton | Missouri | 29049 | 231 | 0 |
565079 | 565079 | 2020-09-24 | Clinton | Missouri | 29049 | 221 | 0 |
561839 | 561839 | 2020-09-23 | Clinton | Missouri | 29049 | 210 | 0 |
558602 | 558602 | 2020-09-22 | Clinton | Missouri | 29049 | 206 | 0 |
555365 | 555365 | 2020-09-21 | Clinton | Missouri | 29049 | 202 | 0 |
552127 | 552127 | 2020-09-20 | Clinton | Missouri | 29049 | 196 | 0 |
548888 | 548888 | 2020-09-19 | Clinton | Missouri | 29049 | 197 | 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);