ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 29183 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
935014 | 935014 | 2021-01-16 | St. Charles | Missouri | 29183 | 37829 | 342 |
931769 | 931769 | 2021-01-15 | St. Charles | Missouri | 29183 | 37829 | 342 |
928524 | 928524 | 2021-01-14 | St. Charles | Missouri | 29183 | 37597 | 342 |
925278 | 925278 | 2021-01-13 | St. Charles | Missouri | 29183 | 37352 | 336 |
922033 | 922033 | 2021-01-12 | St. Charles | Missouri | 29183 | 37093 | 335 |
918788 | 918788 | 2021-01-11 | St. Charles | Missouri | 29183 | 36835 | 335 |
915543 | 915543 | 2021-01-10 | St. Charles | Missouri | 29183 | 31660 | 334 |
912298 | 912298 | 2021-01-09 | St. Charles | Missouri | 29183 | 31535 | 334 |
909053 | 909053 | 2021-01-08 | St. Charles | Missouri | 29183 | 31306 | 334 |
905807 | 905807 | 2021-01-07 | St. Charles | Missouri | 29183 | 30810 | 334 |
902562 | 902562 | 2021-01-06 | St. Charles | Missouri | 29183 | 30799 | 334 |
899317 | 899317 | 2021-01-05 | St. Charles | Missouri | 29183 | 30353 | 334 |
896072 | 896072 | 2021-01-04 | St. Charles | Missouri | 29183 | 30294 | 331 |
892825 | 892825 | 2021-01-03 | St. Charles | Missouri | 29183 | 30121 | 330 |
889579 | 889579 | 2021-01-02 | St. Charles | Missouri | 29183 | 29978 | 330 |
886333 | 886333 | 2021-01-01 | St. Charles | Missouri | 29183 | 29669 | 330 |
883088 | 883088 | 2020-12-31 | St. Charles | Missouri | 29183 | 29669 | 330 |
879843 | 879843 | 2020-12-30 | St. Charles | Missouri | 29183 | 29235 | 321 |
876598 | 876598 | 2020-12-29 | St. Charles | Missouri | 29183 | 28961 | 321 |
873353 | 873353 | 2020-12-28 | St. Charles | Missouri | 29183 | 28845 | 321 |
870108 | 870108 | 2020-12-27 | St. Charles | Missouri | 29183 | 28811 | 320 |
866863 | 866863 | 2020-12-26 | St. Charles | Missouri | 29183 | 28036 | 307 |
863618 | 863618 | 2020-12-25 | St. Charles | Missouri | 29183 | 28036 | 307 |
860373 | 860373 | 2020-12-24 | St. Charles | Missouri | 29183 | 28036 | 307 |
857128 | 857128 | 2020-12-23 | St. Charles | Missouri | 29183 | 28036 | 307 |
853883 | 853883 | 2020-12-22 | St. Charles | Missouri | 29183 | 28005 | 306 |
850638 | 850638 | 2020-12-21 | St. Charles | Missouri | 29183 | 27417 | 299 |
847393 | 847393 | 2020-12-20 | St. Charles | Missouri | 29183 | 27417 | 299 |
844147 | 844147 | 2020-12-19 | St. Charles | Missouri | 29183 | 27286 | 299 |
840902 | 840902 | 2020-12-18 | St. Charles | Missouri | 29183 | 27196 | 290 |
837657 | 837657 | 2020-12-17 | St. Charles | Missouri | 29183 | 26917 | 274 |
834411 | 834411 | 2020-12-16 | St. Charles | Missouri | 29183 | 26562 | 267 |
831164 | 831164 | 2020-12-15 | St. Charles | Missouri | 29183 | 26355 | 261 |
827918 | 827918 | 2020-12-14 | St. Charles | Missouri | 29183 | 25953 | 261 |
824671 | 824671 | 2020-12-13 | St. Charles | Missouri | 29183 | 25841 | 253 |
821425 | 821425 | 2020-12-12 | St. Charles | Missouri | 29183 | 25659 | 253 |
818179 | 818179 | 2020-12-11 | St. Charles | Missouri | 29183 | 25174 | 251 |
814933 | 814933 | 2020-12-10 | St. Charles | Missouri | 29183 | 24747 | 244 |
811688 | 811688 | 2020-12-09 | St. Charles | Missouri | 29183 | 24593 | 240 |
808443 | 808443 | 2020-12-08 | St. Charles | Missouri | 29183 | 24435 | 240 |
805198 | 805198 | 2020-12-07 | St. Charles | Missouri | 29183 | 23956 | 232 |
801953 | 801953 | 2020-12-06 | St. Charles | Missouri | 29183 | 23903 | 232 |
798708 | 798708 | 2020-12-05 | St. Charles | Missouri | 29183 | 23457 | 232 |
795463 | 795463 | 2020-12-04 | St. Charles | Missouri | 29183 | 22989 | 228 |
792218 | 792218 | 2020-12-03 | St. Charles | Missouri | 29183 | 22851 | 228 |
788973 | 788973 | 2020-12-02 | St. Charles | Missouri | 29183 | 22695 | 228 |
785728 | 785728 | 2020-12-01 | St. Charles | Missouri | 29183 | 22134 | 228 |
782484 | 782484 | 2020-11-30 | St. Charles | Missouri | 29183 | 22095 | 228 |
779238 | 779238 | 2020-11-29 | St. Charles | Missouri | 29183 | 21726 | 224 |
775993 | 775993 | 2020-11-28 | St. Charles | Missouri | 29183 | 21470 | 224 |
772748 | 772748 | 2020-11-27 | St. Charles | Missouri | 29183 | 21221 | 224 |
769503 | 769503 | 2020-11-26 | St. Charles | Missouri | 29183 | 20830 | 222 |
766257 | 766257 | 2020-11-25 | St. Charles | Missouri | 29183 | 20757 | 222 |
763012 | 763012 | 2020-11-24 | St. Charles | Missouri | 29183 | 20394 | 211 |
759767 | 759767 | 2020-11-23 | St. Charles | Missouri | 29183 | 20042 | 206 |
756520 | 756520 | 2020-11-22 | St. Charles | Missouri | 29183 | 19632 | 205 |
753274 | 753274 | 2020-11-21 | St. Charles | Missouri | 29183 | 19231 | 205 |
750028 | 750028 | 2020-11-20 | St. Charles | Missouri | 29183 | 18993 | 205 |
746782 | 746782 | 2020-11-19 | St. Charles | Missouri | 29183 | 18590 | 190 |
743535 | 743535 | 2020-11-18 | St. Charles | Missouri | 29183 | 18259 | 190 |
740288 | 740288 | 2020-11-17 | St. Charles | Missouri | 29183 | 17809 | 182 |
737044 | 737044 | 2020-11-16 | St. Charles | Missouri | 29183 | 17327 | 182 |
733798 | 733798 | 2020-11-15 | St. Charles | Missouri | 29183 | 16792 | 180 |
730553 | 730553 | 2020-11-14 | St. Charles | Missouri | 29183 | 16358 | 180 |
727310 | 727310 | 2020-11-13 | St. Charles | Missouri | 29183 | 16268 | 180 |
724067 | 724067 | 2020-11-12 | St. Charles | Missouri | 29183 | 15525 | 178 |
720824 | 720824 | 2020-11-11 | St. Charles | Missouri | 29183 | 15170 | 173 |
717581 | 717581 | 2020-11-10 | St. Charles | Missouri | 29183 | 14913 | 173 |
714337 | 714337 | 2020-11-09 | St. Charles | Missouri | 29183 | 14532 | 173 |
711093 | 711093 | 2020-11-08 | St. Charles | Missouri | 29183 | 14251 | 173 |
707849 | 707849 | 2020-11-07 | St. Charles | Missouri | 29183 | 13970 | 173 |
704606 | 704606 | 2020-11-06 | St. Charles | Missouri | 29183 | 13745 | 173 |
701364 | 701364 | 2020-11-05 | St. Charles | Missouri | 29183 | 13155 | 172 |
698120 | 698120 | 2020-11-04 | St. Charles | Missouri | 29183 | 13100 | 167 |
694877 | 694877 | 2020-11-03 | St. Charles | Missouri | 29183 | 12856 | 165 |
691635 | 691635 | 2020-11-02 | St. Charles | Missouri | 29183 | 12590 | 163 |
688390 | 688390 | 2020-11-01 | St. Charles | Missouri | 29183 | 12476 | 162 |
685146 | 685146 | 2020-10-31 | St. Charles | Missouri | 29183 | 12051 | 162 |
681903 | 681903 | 2020-10-30 | St. Charles | Missouri | 29183 | 11948 | 162 |
678659 | 678659 | 2020-10-29 | St. Charles | Missouri | 29183 | 11741 | 157 |
675417 | 675417 | 2020-10-28 | St. Charles | Missouri | 29183 | 11511 | 156 |
672174 | 672174 | 2020-10-27 | St. Charles | Missouri | 29183 | 11364 | 153 |
668932 | 668932 | 2020-10-26 | St. Charles | Missouri | 29183 | 11197 | 150 |
665688 | 665688 | 2020-10-25 | St. Charles | Missouri | 29183 | 10883 | 149 |
662443 | 662443 | 2020-10-24 | St. Charles | Missouri | 29183 | 10877 | 149 |
659199 | 659199 | 2020-10-23 | St. Charles | Missouri | 29183 | 10817 | 149 |
655954 | 655954 | 2020-10-22 | St. Charles | Missouri | 29183 | 10509 | 149 |
652709 | 652709 | 2020-10-21 | St. Charles | Missouri | 29183 | 10449 | 148 |
649464 | 649464 | 2020-10-20 | St. Charles | Missouri | 29183 | 10334 | 148 |
646220 | 646220 | 2020-10-19 | St. Charles | Missouri | 29183 | 10256 | 148 |
642974 | 642974 | 2020-10-18 | St. Charles | Missouri | 29183 | 10072 | 147 |
639726 | 639726 | 2020-10-17 | St. Charles | Missouri | 29183 | 9939 | 146 |
636480 | 636480 | 2020-10-16 | St. Charles | Missouri | 29183 | 9817 | 145 |
633234 | 633234 | 2020-10-15 | St. Charles | Missouri | 29183 | 9665 | 142 |
629989 | 629989 | 2020-10-14 | St. Charles | Missouri | 29183 | 9502 | 141 |
626745 | 626745 | 2020-10-13 | St. Charles | Missouri | 29183 | 9288 | 138 |
623503 | 623503 | 2020-10-12 | St. Charles | Missouri | 29183 | 9195 | 138 |
620260 | 620260 | 2020-10-11 | St. Charles | Missouri | 29183 | 8947 | 138 |
617018 | 617018 | 2020-10-10 | St. Charles | Missouri | 29183 | 8947 | 138 |
613777 | 613777 | 2020-10-09 | St. Charles | Missouri | 29183 | 8859 | 138 |
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);