ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 29031 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934930 | 934930 | 2021-01-16 | Cape Girardeau | Missouri | 29031 | 8502 | 128 |
931685 | 931685 | 2021-01-15 | Cape Girardeau | Missouri | 29031 | 8502 | 128 |
928440 | 928440 | 2021-01-14 | Cape Girardeau | Missouri | 29031 | 8468 | 128 |
925194 | 925194 | 2021-01-13 | Cape Girardeau | Missouri | 29031 | 8415 | 128 |
921949 | 921949 | 2021-01-12 | Cape Girardeau | Missouri | 29031 | 8359 | 128 |
918704 | 918704 | 2021-01-11 | Cape Girardeau | Missouri | 29031 | 8333 | 128 |
915459 | 915459 | 2021-01-10 | Cape Girardeau | Missouri | 29031 | 8221 | 125 |
912214 | 912214 | 2021-01-09 | Cape Girardeau | Missouri | 29031 | 8221 | 125 |
908969 | 908969 | 2021-01-08 | Cape Girardeau | Missouri | 29031 | 8221 | 125 |
905723 | 905723 | 2021-01-07 | Cape Girardeau | Missouri | 29031 | 8168 | 125 |
902478 | 902478 | 2021-01-06 | Cape Girardeau | Missouri | 29031 | 8094 | 119 |
899233 | 899233 | 2021-01-05 | Cape Girardeau | Missouri | 29031 | 8007 | 119 |
895988 | 895988 | 2021-01-04 | Cape Girardeau | Missouri | 29031 | 7930 | 115 |
892741 | 892741 | 2021-01-03 | Cape Girardeau | Missouri | 29031 | 7844 | 109 |
889495 | 889495 | 2021-01-02 | Cape Girardeau | Missouri | 29031 | 7844 | 109 |
886249 | 886249 | 2021-01-01 | Cape Girardeau | Missouri | 29031 | 7754 | 109 |
883004 | 883004 | 2020-12-31 | Cape Girardeau | Missouri | 29031 | 7754 | 109 |
879759 | 879759 | 2020-12-30 | Cape Girardeau | Missouri | 29031 | 7688 | 109 |
876514 | 876514 | 2020-12-29 | Cape Girardeau | Missouri | 29031 | 7592 | 109 |
873269 | 873269 | 2020-12-28 | Cape Girardeau | Missouri | 29031 | 7507 | 105 |
870024 | 870024 | 2020-12-27 | Cape Girardeau | Missouri | 29031 | 7408 | 105 |
866779 | 866779 | 2020-12-26 | Cape Girardeau | Missouri | 29031 | 7408 | 105 |
863534 | 863534 | 2020-12-25 | Cape Girardeau | Missouri | 29031 | 7317 | 105 |
860289 | 860289 | 2020-12-24 | Cape Girardeau | Missouri | 29031 | 7317 | 105 |
857044 | 857044 | 2020-12-23 | Cape Girardeau | Missouri | 29031 | 7317 | 105 |
853799 | 853799 | 2020-12-22 | Cape Girardeau | Missouri | 29031 | 7246 | 105 |
850554 | 850554 | 2020-12-21 | Cape Girardeau | Missouri | 29031 | 7203 | 105 |
847309 | 847309 | 2020-12-20 | Cape Girardeau | Missouri | 29031 | 7089 | 105 |
844063 | 844063 | 2020-12-19 | Cape Girardeau | Missouri | 29031 | 7089 | 105 |
840818 | 840818 | 2020-12-18 | Cape Girardeau | Missouri | 29031 | 7057 | 105 |
837573 | 837573 | 2020-12-17 | Cape Girardeau | Missouri | 29031 | 6979 | 97 |
834327 | 834327 | 2020-12-16 | Cape Girardeau | Missouri | 29031 | 6885 | 94 |
831080 | 831080 | 2020-12-15 | Cape Girardeau | Missouri | 29031 | 6787 | 94 |
827834 | 827834 | 2020-12-14 | Cape Girardeau | Missouri | 29031 | 6741 | 93 |
824587 | 824587 | 2020-12-13 | Cape Girardeau | Missouri | 29031 | 6611 | 92 |
821341 | 821341 | 2020-12-12 | Cape Girardeau | Missouri | 29031 | 6557 | 92 |
818095 | 818095 | 2020-12-11 | Cape Girardeau | Missouri | 29031 | 6397 | 89 |
814849 | 814849 | 2020-12-10 | Cape Girardeau | Missouri | 29031 | 6397 | 89 |
811604 | 811604 | 2020-12-09 | Cape Girardeau | Missouri | 29031 | 6322 | 88 |
808359 | 808359 | 2020-12-08 | Cape Girardeau | Missouri | 29031 | 6322 | 88 |
805114 | 805114 | 2020-12-07 | Cape Girardeau | Missouri | 29031 | 6269 | 83 |
801869 | 801869 | 2020-12-06 | Cape Girardeau | Missouri | 29031 | 6160 | 83 |
798624 | 798624 | 2020-12-05 | Cape Girardeau | Missouri | 29031 | 6160 | 83 |
795379 | 795379 | 2020-12-04 | Cape Girardeau | Missouri | 29031 | 6074 | 83 |
792134 | 792134 | 2020-12-03 | Cape Girardeau | Missouri | 29031 | 5869 | 70 |
788889 | 788889 | 2020-12-02 | Cape Girardeau | Missouri | 29031 | 5869 | 70 |
785644 | 785644 | 2020-12-01 | Cape Girardeau | Missouri | 29031 | 5773 | 70 |
782400 | 782400 | 2020-11-30 | Cape Girardeau | Missouri | 29031 | 5727 | 70 |
779154 | 779154 | 2020-11-29 | Cape Girardeau | Missouri | 29031 | 5654 | 69 |
775909 | 775909 | 2020-11-28 | Cape Girardeau | Missouri | 29031 | 5619 | 69 |
772664 | 772664 | 2020-11-27 | Cape Girardeau | Missouri | 29031 | 5537 | 69 |
769419 | 769419 | 2020-11-26 | Cape Girardeau | Missouri | 29031 | 5414 | 67 |
766173 | 766173 | 2020-11-25 | Cape Girardeau | Missouri | 29031 | 5414 | 67 |
762928 | 762928 | 2020-11-24 | Cape Girardeau | Missouri | 29031 | 5297 | 67 |
759683 | 759683 | 2020-11-23 | Cape Girardeau | Missouri | 29031 | 5231 | 63 |
756436 | 756436 | 2020-11-22 | Cape Girardeau | Missouri | 29031 | 5157 | 63 |
753190 | 753190 | 2020-11-21 | Cape Girardeau | Missouri | 29031 | 5111 | 63 |
749944 | 749944 | 2020-11-20 | Cape Girardeau | Missouri | 29031 | 5002 | 63 |
746698 | 746698 | 2020-11-19 | Cape Girardeau | Missouri | 29031 | 4755 | 63 |
743451 | 743451 | 2020-11-18 | Cape Girardeau | Missouri | 29031 | 4755 | 63 |
740204 | 740204 | 2020-11-17 | Cape Girardeau | Missouri | 29031 | 4620 | 61 |
736960 | 736960 | 2020-11-16 | Cape Girardeau | Missouri | 29031 | 4538 | 60 |
733714 | 733714 | 2020-11-15 | Cape Girardeau | Missouri | 29031 | 3961 | 60 |
730469 | 730469 | 2020-11-14 | Cape Girardeau | Missouri | 29031 | 3961 | 60 |
727226 | 727226 | 2020-11-13 | Cape Girardeau | Missouri | 29031 | 3929 | 60 |
723983 | 723983 | 2020-11-12 | Cape Girardeau | Missouri | 29031 | 3929 | 60 |
720740 | 720740 | 2020-11-11 | Cape Girardeau | Missouri | 29031 | 3929 | 60 |
717497 | 717497 | 2020-11-10 | Cape Girardeau | Missouri | 29031 | 3758 | 60 |
714253 | 714253 | 2020-11-09 | Cape Girardeau | Missouri | 29031 | 3758 | 56 |
711009 | 711009 | 2020-11-08 | Cape Girardeau | Missouri | 29031 | 3322 | 56 |
707765 | 707765 | 2020-11-07 | Cape Girardeau | Missouri | 29031 | 3312 | 55 |
704522 | 704522 | 2020-11-06 | Cape Girardeau | Missouri | 29031 | 3312 | 55 |
701280 | 701280 | 2020-11-05 | Cape Girardeau | Missouri | 29031 | 3312 | 55 |
698036 | 698036 | 2020-11-04 | Cape Girardeau | Missouri | 29031 | 3312 | 55 |
694793 | 694793 | 2020-11-03 | Cape Girardeau | Missouri | 29031 | 3210 | 55 |
691551 | 691551 | 2020-11-02 | Cape Girardeau | Missouri | 29031 | 3112 | 55 |
688306 | 688306 | 2020-11-01 | Cape Girardeau | Missouri | 29031 | 3081 | 55 |
685062 | 685062 | 2020-10-31 | Cape Girardeau | Missouri | 29031 | 3041 | 55 |
681819 | 681819 | 2020-10-30 | Cape Girardeau | Missouri | 29031 | 3041 | 53 |
678575 | 678575 | 2020-10-29 | Cape Girardeau | Missouri | 29031 | 3003 | 51 |
675333 | 675333 | 2020-10-28 | Cape Girardeau | Missouri | 29031 | 2902 | 50 |
672090 | 672090 | 2020-10-27 | Cape Girardeau | Missouri | 29031 | 2779 | 50 |
668848 | 668848 | 2020-10-26 | Cape Girardeau | Missouri | 29031 | 2779 | 49 |
665604 | 665604 | 2020-10-25 | Cape Girardeau | Missouri | 29031 | 2779 | 49 |
662359 | 662359 | 2020-10-24 | Cape Girardeau | Missouri | 29031 | 2779 | 49 |
659115 | 659115 | 2020-10-23 | Cape Girardeau | Missouri | 29031 | 2779 | 49 |
655870 | 655870 | 2020-10-22 | Cape Girardeau | Missouri | 29031 | 2739 | 49 |
652625 | 652625 | 2020-10-21 | Cape Girardeau | Missouri | 29031 | 2726 | 49 |
649380 | 649380 | 2020-10-20 | Cape Girardeau | Missouri | 29031 | 2638 | 45 |
646136 | 646136 | 2020-10-19 | Cape Girardeau | Missouri | 29031 | 2638 | 45 |
642890 | 642890 | 2020-10-18 | Cape Girardeau | Missouri | 29031 | 2607 | 45 |
639642 | 639642 | 2020-10-17 | Cape Girardeau | Missouri | 29031 | 2598 | 45 |
636396 | 636396 | 2020-10-16 | Cape Girardeau | Missouri | 29031 | 2545 | 40 |
633150 | 633150 | 2020-10-15 | Cape Girardeau | Missouri | 29031 | 2545 | 40 |
629905 | 629905 | 2020-10-14 | Cape Girardeau | Missouri | 29031 | 2506 | 40 |
626661 | 626661 | 2020-10-13 | Cape Girardeau | Missouri | 29031 | 2467 | 40 |
623419 | 623419 | 2020-10-12 | Cape Girardeau | Missouri | 29031 | 2422 | 34 |
620176 | 620176 | 2020-10-11 | Cape Girardeau | Missouri | 29031 | 2384 | 34 |
616934 | 616934 | 2020-10-10 | Cape Girardeau | Missouri | 29031 | 2369 | 34 |
613693 | 613693 | 2020-10-09 | Cape Girardeau | Missouri | 29031 | 2369 | 34 |
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);