ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 29037 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934933 | 934933 | 2021-01-16 | Cass | Missouri | 29037 | 6401 | 62 |
931688 | 931688 | 2021-01-15 | Cass | Missouri | 29037 | 6349 | 62 |
928443 | 928443 | 2021-01-14 | Cass | Missouri | 29037 | 6302 | 62 |
925197 | 925197 | 2021-01-13 | Cass | Missouri | 29037 | 6222 | 62 |
921952 | 921952 | 2021-01-12 | Cass | Missouri | 29037 | 6181 | 62 |
918707 | 918707 | 2021-01-11 | Cass | Missouri | 29037 | 6154 | 59 |
915462 | 915462 | 2021-01-10 | Cass | Missouri | 29037 | 6095 | 58 |
912217 | 912217 | 2021-01-09 | Cass | Missouri | 29037 | 6030 | 58 |
908972 | 908972 | 2021-01-08 | Cass | Missouri | 29037 | 5934 | 58 |
905726 | 905726 | 2021-01-07 | Cass | Missouri | 29037 | 5887 | 58 |
902481 | 902481 | 2021-01-06 | Cass | Missouri | 29037 | 5845 | 58 |
899236 | 899236 | 2021-01-05 | Cass | Missouri | 29037 | 5811 | 58 |
895991 | 895991 | 2021-01-04 | Cass | Missouri | 29037 | 5772 | 55 |
892744 | 892744 | 2021-01-03 | Cass | Missouri | 29037 | 5712 | 55 |
889498 | 889498 | 2021-01-02 | Cass | Missouri | 29037 | 5670 | 55 |
886252 | 886252 | 2021-01-01 | Cass | Missouri | 29037 | 5631 | 55 |
883007 | 883007 | 2020-12-31 | Cass | Missouri | 29037 | 5627 | 54 |
879762 | 879762 | 2020-12-30 | Cass | Missouri | 29037 | 5569 | 54 |
876517 | 876517 | 2020-12-29 | Cass | Missouri | 29037 | 5522 | 54 |
873272 | 873272 | 2020-12-28 | Cass | Missouri | 29037 | 5465 | 53 |
870027 | 870027 | 2020-12-27 | Cass | Missouri | 29037 | 5371 | 52 |
866782 | 866782 | 2020-12-26 | Cass | Missouri | 29037 | 5354 | 52 |
863537 | 863537 | 2020-12-25 | Cass | Missouri | 29037 | 5316 | 52 |
860292 | 860292 | 2020-12-24 | Cass | Missouri | 29037 | 5259 | 52 |
857047 | 857047 | 2020-12-23 | Cass | Missouri | 29037 | 5243 | 52 |
853802 | 853802 | 2020-12-22 | Cass | Missouri | 29037 | 5243 | 50 |
850557 | 850557 | 2020-12-21 | Cass | Missouri | 29037 | 5195 | 48 |
847312 | 847312 | 2020-12-20 | Cass | Missouri | 29037 | 5060 | 48 |
844066 | 844066 | 2020-12-19 | Cass | Missouri | 29037 | 5040 | 48 |
840821 | 840821 | 2020-12-18 | Cass | Missouri | 29037 | 5040 | 48 |
837576 | 837576 | 2020-12-17 | Cass | Missouri | 29037 | 4961 | 46 |
834330 | 834330 | 2020-12-16 | Cass | Missouri | 29037 | 4899 | 45 |
831083 | 831083 | 2020-12-15 | Cass | Missouri | 29037 | 4845 | 45 |
827837 | 827837 | 2020-12-14 | Cass | Missouri | 29037 | 4779 | 45 |
824590 | 824590 | 2020-12-13 | Cass | Missouri | 29037 | 4653 | 43 |
821344 | 821344 | 2020-12-12 | Cass | Missouri | 29037 | 4623 | 43 |
818098 | 818098 | 2020-12-11 | Cass | Missouri | 29037 | 4623 | 43 |
814852 | 814852 | 2020-12-10 | Cass | Missouri | 29037 | 4460 | 43 |
811607 | 811607 | 2020-12-09 | Cass | Missouri | 29037 | 4502 | 43 |
808362 | 808362 | 2020-12-08 | Cass | Missouri | 29037 | 4357 | 41 |
805117 | 805117 | 2020-12-07 | Cass | Missouri | 29037 | 4357 | 41 |
801872 | 801872 | 2020-12-06 | Cass | Missouri | 29037 | 4215 | 40 |
798627 | 798627 | 2020-12-05 | Cass | Missouri | 29037 | 4148 | 40 |
795382 | 795382 | 2020-12-04 | Cass | Missouri | 29037 | 4138 | 40 |
792137 | 792137 | 2020-12-03 | Cass | Missouri | 29037 | 4067 | 40 |
788892 | 788892 | 2020-12-02 | Cass | Missouri | 29037 | 4000 | 40 |
785647 | 785647 | 2020-12-01 | Cass | Missouri | 29037 | 3869 | 40 |
782403 | 782403 | 2020-11-30 | Cass | Missouri | 29037 | 3857 | 39 |
779157 | 779157 | 2020-11-29 | Cass | Missouri | 29037 | 3765 | 39 |
775912 | 775912 | 2020-11-28 | Cass | Missouri | 29037 | 3721 | 39 |
772667 | 772667 | 2020-11-27 | Cass | Missouri | 29037 | 3661 | 39 |
769422 | 769422 | 2020-11-26 | Cass | Missouri | 29037 | 3622 | 39 |
766176 | 766176 | 2020-11-25 | Cass | Missouri | 29037 | 3594 | 39 |
762931 | 762931 | 2020-11-24 | Cass | Missouri | 29037 | 3542 | 39 |
759686 | 759686 | 2020-11-23 | Cass | Missouri | 29037 | 3488 | 36 |
756439 | 756439 | 2020-11-22 | Cass | Missouri | 29037 | 3391 | 36 |
753193 | 753193 | 2020-11-21 | Cass | Missouri | 29037 | 3338 | 36 |
749947 | 749947 | 2020-11-20 | Cass | Missouri | 29037 | 3305 | 36 |
746701 | 746701 | 2020-11-19 | Cass | Missouri | 29037 | 3245 | 36 |
743454 | 743454 | 2020-11-18 | Cass | Missouri | 29037 | 3201 | 36 |
740207 | 740207 | 2020-11-17 | Cass | Missouri | 29037 | 3078 | 36 |
736963 | 736963 | 2020-11-16 | Cass | Missouri | 29037 | 3068 | 35 |
733717 | 733717 | 2020-11-15 | Cass | Missouri | 29037 | 2911 | 35 |
730472 | 730472 | 2020-11-14 | Cass | Missouri | 29037 | 2911 | 35 |
727229 | 727229 | 2020-11-13 | Cass | Missouri | 29037 | 2879 | 35 |
723986 | 723986 | 2020-11-12 | Cass | Missouri | 29037 | 2819 | 35 |
720743 | 720743 | 2020-11-11 | Cass | Missouri | 29037 | 2765 | 35 |
717500 | 717500 | 2020-11-10 | Cass | Missouri | 29037 | 2716 | 35 |
714256 | 714256 | 2020-11-09 | Cass | Missouri | 29037 | 2666 | 33 |
711012 | 711012 | 2020-11-08 | Cass | Missouri | 29037 | 2531 | 33 |
707768 | 707768 | 2020-11-07 | Cass | Missouri | 29037 | 2531 | 33 |
704525 | 704525 | 2020-11-06 | Cass | Missouri | 29037 | 2531 | 33 |
701283 | 701283 | 2020-11-05 | Cass | Missouri | 29037 | 2437 | 33 |
698039 | 698039 | 2020-11-04 | Cass | Missouri | 29037 | 2437 | 33 |
694796 | 694796 | 2020-11-03 | Cass | Missouri | 29037 | 2397 | 32 |
691554 | 691554 | 2020-11-02 | Cass | Missouri | 29037 | 2373 | 32 |
688309 | 688309 | 2020-11-01 | Cass | Missouri | 29037 | 2283 | 32 |
685065 | 685065 | 2020-10-31 | Cass | Missouri | 29037 | 2283 | 32 |
681822 | 681822 | 2020-10-30 | Cass | Missouri | 29037 | 2283 | 30 |
678578 | 678578 | 2020-10-29 | Cass | Missouri | 29037 | 2241 | 30 |
675336 | 675336 | 2020-10-28 | Cass | Missouri | 29037 | 2214 | 30 |
672093 | 672093 | 2020-10-27 | Cass | Missouri | 29037 | 2175 | 30 |
668851 | 668851 | 2020-10-26 | Cass | Missouri | 29037 | 2128 | 30 |
665607 | 665607 | 2020-10-25 | Cass | Missouri | 29037 | 2093 | 30 |
662362 | 662362 | 2020-10-24 | Cass | Missouri | 29037 | 2093 | 30 |
659118 | 659118 | 2020-10-23 | Cass | Missouri | 29037 | 2093 | 28 |
655873 | 655873 | 2020-10-22 | Cass | Missouri | 29037 | 2061 | 28 |
652628 | 652628 | 2020-10-21 | Cass | Missouri | 29037 | 2034 | 28 |
649383 | 649383 | 2020-10-20 | Cass | Missouri | 29037 | 2018 | 28 |
646139 | 646139 | 2020-10-19 | Cass | Missouri | 29037 | 2000 | 28 |
642893 | 642893 | 2020-10-18 | Cass | Missouri | 29037 | 1878 | 28 |
639645 | 639645 | 2020-10-17 | Cass | Missouri | 29037 | 1878 | 28 |
636399 | 636399 | 2020-10-16 | Cass | Missouri | 29037 | 1878 | 27 |
633153 | 633153 | 2020-10-15 | Cass | Missouri | 29037 | 1878 | 27 |
629908 | 629908 | 2020-10-14 | Cass | Missouri | 29037 | 1878 | 28 |
626664 | 626664 | 2020-10-13 | Cass | Missouri | 29037 | 1838 | 29 |
623422 | 623422 | 2020-10-12 | Cass | Missouri | 29037 | 1838 | 29 |
620179 | 620179 | 2020-10-11 | Cass | Missouri | 29037 | 1780 | 29 |
616937 | 616937 | 2020-10-10 | Cass | Missouri | 29037 | 1780 | 29 |
613696 | 613696 | 2020-10-09 | Cass | Missouri | 29037 | 1780 | 29 |
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);