ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
756 rows where county = "Marion" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
934979 | 934979 | 2021-01-16 | Marion | Missouri | 29127 | 2509 | 32 |
931734 | 931734 | 2021-01-15 | Marion | Missouri | 29127 | 2503 | 32 |
928489 | 928489 | 2021-01-14 | Marion | Missouri | 29127 | 2494 | 32 |
925243 | 925243 | 2021-01-13 | Marion | Missouri | 29127 | 2488 | 32 |
921998 | 921998 | 2021-01-12 | Marion | Missouri | 29127 | 2482 | 32 |
918753 | 918753 | 2021-01-11 | Marion | Missouri | 29127 | 2472 | 30 |
915508 | 915508 | 2021-01-10 | Marion | Missouri | 29127 | 2464 | 30 |
912263 | 912263 | 2021-01-09 | Marion | Missouri | 29127 | 2451 | 30 |
909018 | 909018 | 2021-01-08 | Marion | Missouri | 29127 | 2433 | 30 |
905772 | 905772 | 2021-01-07 | Marion | Missouri | 29127 | 2422 | 30 |
902527 | 902527 | 2021-01-06 | Marion | Missouri | 29127 | 2410 | 30 |
899282 | 899282 | 2021-01-05 | Marion | Missouri | 29127 | 2403 | 30 |
896037 | 896037 | 2021-01-04 | Marion | Missouri | 29127 | 2394 | 24 |
892790 | 892790 | 2021-01-03 | Marion | Missouri | 29127 | 2394 | 24 |
889544 | 889544 | 2021-01-02 | Marion | Missouri | 29127 | 2370 | 24 |
886298 | 886298 | 2021-01-01 | Marion | Missouri | 29127 | 2360 | 24 |
883053 | 883053 | 2020-12-31 | Marion | Missouri | 29127 | 2329 | 24 |
879808 | 879808 | 2020-12-30 | Marion | Missouri | 29127 | 2315 | 24 |
876563 | 876563 | 2020-12-29 | Marion | Missouri | 29127 | 2304 | 24 |
873318 | 873318 | 2020-12-28 | Marion | Missouri | 29127 | 2279 | 24 |
870073 | 870073 | 2020-12-27 | Marion | Missouri | 29127 | 2275 | 24 |
866828 | 866828 | 2020-12-26 | Marion | Missouri | 29127 | 2264 | 24 |
863583 | 863583 | 2020-12-25 | Marion | Missouri | 29127 | 2258 | 24 |
860338 | 860338 | 2020-12-24 | Marion | Missouri | 29127 | 2251 | 24 |
857093 | 857093 | 2020-12-23 | Marion | Missouri | 29127 | 2244 | 24 |
853848 | 853848 | 2020-12-22 | Marion | Missouri | 29127 | 2223 | 24 |
850603 | 850603 | 2020-12-21 | Marion | Missouri | 29127 | 2207 | 23 |
847358 | 847358 | 2020-12-20 | Marion | Missouri | 29127 | 2197 | 23 |
844112 | 844112 | 2020-12-19 | Marion | Missouri | 29127 | 2185 | 23 |
840867 | 840867 | 2020-12-18 | Marion | Missouri | 29127 | 2164 | 23 |
837622 | 837622 | 2020-12-17 | Marion | Missouri | 29127 | 2155 | 23 |
834376 | 834376 | 2020-12-16 | Marion | Missouri | 29127 | 2145 | 23 |
831129 | 831129 | 2020-12-15 | Marion | Missouri | 29127 | 2131 | 23 |
827883 | 827883 | 2020-12-14 | Marion | Missouri | 29127 | 2118 | 20 |
824636 | 824636 | 2020-12-13 | Marion | Missouri | 29127 | 2104 | 20 |
821390 | 821390 | 2020-12-12 | Marion | Missouri | 29127 | 2088 | 20 |
818144 | 818144 | 2020-12-11 | Marion | Missouri | 29127 | 2063 | 20 |
814898 | 814898 | 2020-12-10 | Marion | Missouri | 29127 | 2063 | 20 |
811653 | 811653 | 2020-12-09 | Marion | Missouri | 29127 | 2017 | 20 |
808408 | 808408 | 2020-12-08 | Marion | Missouri | 29127 | 1992 | 20 |
805163 | 805163 | 2020-12-07 | Marion | Missouri | 29127 | 1970 | 18 |
801918 | 801918 | 2020-12-06 | Marion | Missouri | 29127 | 1957 | 18 |
798673 | 798673 | 2020-12-05 | Marion | Missouri | 29127 | 1926 | 18 |
795428 | 795428 | 2020-12-04 | Marion | Missouri | 29127 | 1894 | 18 |
792183 | 792183 | 2020-12-03 | Marion | Missouri | 29127 | 1846 | 18 |
788938 | 788938 | 2020-12-02 | Marion | Missouri | 29127 | 1832 | 18 |
785693 | 785693 | 2020-12-01 | Marion | Missouri | 29127 | 1818 | 18 |
782449 | 782449 | 2020-11-30 | Marion | Missouri | 29127 | 1797 | 16 |
779203 | 779203 | 2020-11-29 | Marion | Missouri | 29127 | 1774 | 16 |
775958 | 775958 | 2020-11-28 | Marion | Missouri | 29127 | 1756 | 16 |
772713 | 772713 | 2020-11-27 | Marion | Missouri | 29127 | 1737 | 16 |
769468 | 769468 | 2020-11-26 | Marion | Missouri | 29127 | 1715 | 16 |
766222 | 766222 | 2020-11-25 | Marion | Missouri | 29127 | 1680 | 16 |
762977 | 762977 | 2020-11-24 | Marion | Missouri | 29127 | 1662 | 16 |
759732 | 759732 | 2020-11-23 | Marion | Missouri | 29127 | 1625 | 15 |
756485 | 756485 | 2020-11-22 | Marion | Missouri | 29127 | 1608 | 15 |
753239 | 753239 | 2020-11-21 | Marion | Missouri | 29127 | 1593 | 15 |
749993 | 749993 | 2020-11-20 | Marion | Missouri | 29127 | 1549 | 15 |
746747 | 746747 | 2020-11-19 | Marion | Missouri | 29127 | 1527 | 15 |
743500 | 743500 | 2020-11-18 | Marion | Missouri | 29127 | 1499 | 15 |
740253 | 740253 | 2020-11-17 | Marion | Missouri | 29127 | 1455 | 15 |
737009 | 737009 | 2020-11-16 | Marion | Missouri | 29127 | 1424 | 15 |
733763 | 733763 | 2020-11-15 | Marion | Missouri | 29127 | 1391 | 15 |
730518 | 730518 | 2020-11-14 | Marion | Missouri | 29127 | 1391 | 15 |
727275 | 727275 | 2020-11-13 | Marion | Missouri | 29127 | 1326 | 15 |
724032 | 724032 | 2020-11-12 | Marion | Missouri | 29127 | 1298 | 15 |
720789 | 720789 | 2020-11-11 | Marion | Missouri | 29127 | 1270 | 15 |
717546 | 717546 | 2020-11-10 | Marion | Missouri | 29127 | 1243 | 15 |
714302 | 714302 | 2020-11-09 | Marion | Missouri | 29127 | 1222 | 14 |
711058 | 711058 | 2020-11-08 | Marion | Missouri | 29127 | 1186 | 14 |
707814 | 707814 | 2020-11-07 | Marion | Missouri | 29127 | 1145 | 14 |
704571 | 704571 | 2020-11-06 | Marion | Missouri | 29127 | 1123 | 14 |
701329 | 701329 | 2020-11-05 | Marion | Missouri | 29127 | 1101 | 14 |
698085 | 698085 | 2020-11-04 | Marion | Missouri | 29127 | 1078 | 14 |
694842 | 694842 | 2020-11-03 | Marion | Missouri | 29127 | 1065 | 14 |
691600 | 691600 | 2020-11-02 | Marion | Missouri | 29127 | 1028 | 14 |
688355 | 688355 | 2020-11-01 | Marion | Missouri | 29127 | 1008 | 14 |
685111 | 685111 | 2020-10-31 | Marion | Missouri | 29127 | 991 | 14 |
681868 | 681868 | 2020-10-30 | Marion | Missouri | 29127 | 970 | 14 |
678624 | 678624 | 2020-10-29 | Marion | Missouri | 29127 | 950 | 14 |
675382 | 675382 | 2020-10-28 | Marion | Missouri | 29127 | 938 | 14 |
672139 | 672139 | 2020-10-27 | Marion | Missouri | 29127 | 929 | 14 |
668897 | 668897 | 2020-10-26 | Marion | Missouri | 29127 | 906 | 14 |
665653 | 665653 | 2020-10-25 | Marion | Missouri | 29127 | 901 | 14 |
662408 | 662408 | 2020-10-24 | Marion | Missouri | 29127 | 890 | 14 |
659164 | 659164 | 2020-10-23 | Marion | Missouri | 29127 | 871 | 14 |
655919 | 655919 | 2020-10-22 | Marion | Missouri | 29127 | 858 | 14 |
652674 | 652674 | 2020-10-21 | Marion | Missouri | 29127 | 850 | 14 |
649429 | 649429 | 2020-10-20 | Marion | Missouri | 29127 | 822 | 14 |
646185 | 646185 | 2020-10-19 | Marion | Missouri | 29127 | 822 | 14 |
642939 | 642939 | 2020-10-18 | Marion | Missouri | 29127 | 813 | 14 |
639691 | 639691 | 2020-10-17 | Marion | Missouri | 29127 | 804 | 14 |
636445 | 636445 | 2020-10-16 | Marion | Missouri | 29127 | 801 | 14 |
633199 | 633199 | 2020-10-15 | Marion | Missouri | 29127 | 789 | 14 |
629954 | 629954 | 2020-10-14 | Marion | Missouri | 29127 | 781 | 14 |
626710 | 626710 | 2020-10-13 | Marion | Missouri | 29127 | 765 | 14 |
623468 | 623468 | 2020-10-12 | Marion | Missouri | 29127 | 765 | 14 |
620225 | 620225 | 2020-10-11 | Marion | Missouri | 29127 | 765 | 14 |
616983 | 616983 | 2020-10-10 | Marion | Missouri | 29127 | 765 | 14 |
613742 | 613742 | 2020-10-09 | Marion | Missouri | 29127 | 742 | 14 |
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);