ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 29069 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055037 | 1055037 | 2021-02-22 | Dunklin | Missouri | 29069 | 2403 | 17 |
1051790 | 1051790 | 2021-02-21 | Dunklin | Missouri | 29069 | 2403 | 17 |
1048543 | 1048543 | 2021-02-20 | Dunklin | Missouri | 29069 | 2403 | 17 |
1045297 | 1045297 | 2021-02-19 | Dunklin | Missouri | 29069 | 2402 | 17 |
1042052 | 1042052 | 2021-02-18 | Dunklin | Missouri | 29069 | 2400 | 17 |
1038807 | 1038807 | 2021-02-17 | Dunklin | Missouri | 29069 | 2400 | 17 |
1035562 | 1035562 | 2021-02-16 | Dunklin | Missouri | 29069 | 2396 | 17 |
1032317 | 1032317 | 2021-02-15 | Dunklin | Missouri | 29069 | 2393 | 17 |
1029070 | 1029070 | 2021-02-14 | Dunklin | Missouri | 29069 | 2394 | 17 |
1025824 | 1025824 | 2021-02-13 | Dunklin | Missouri | 29069 | 2393 | 17 |
1022579 | 1022579 | 2021-02-12 | Dunklin | Missouri | 29069 | 2392 | 17 |
1019334 | 1019334 | 2021-02-11 | Dunklin | Missouri | 29069 | 2388 | 17 |
1016089 | 1016089 | 2021-02-10 | Dunklin | Missouri | 29069 | 2382 | 17 |
1012844 | 1012844 | 2021-02-09 | Dunklin | Missouri | 29069 | 2381 | 17 |
1009599 | 1009599 | 2021-02-08 | Dunklin | Missouri | 29069 | 2381 | 17 |
1006352 | 1006352 | 2021-02-07 | Dunklin | Missouri | 29069 | 2378 | 17 |
1003106 | 1003106 | 2021-02-06 | Dunklin | Missouri | 29069 | 2373 | 17 |
999861 | 999861 | 2021-02-05 | Dunklin | Missouri | 29069 | 2369 | 17 |
996615 | 996615 | 2021-02-04 | Dunklin | Missouri | 29069 | 2362 | 17 |
993369 | 993369 | 2021-02-03 | Dunklin | Missouri | 29069 | 2352 | 17 |
990123 | 990123 | 2021-02-02 | Dunklin | Missouri | 29069 | 2349 | 17 |
986876 | 986876 | 2021-02-01 | Dunklin | Missouri | 29069 | 2347 | 16 |
983629 | 983629 | 2021-01-31 | Dunklin | Missouri | 29069 | 2345 | 16 |
980383 | 980383 | 2021-01-30 | Dunklin | Missouri | 29069 | 2344 | 16 |
977137 | 977137 | 2021-01-29 | Dunklin | Missouri | 29069 | 2342 | 16 |
973892 | 973892 | 2021-01-28 | Dunklin | Missouri | 29069 | 2335 | 16 |
970647 | 970647 | 2021-01-27 | Dunklin | Missouri | 29069 | 2323 | 16 |
967402 | 967402 | 2021-01-26 | Dunklin | Missouri | 29069 | 2319 | 16 |
964158 | 964158 | 2021-01-25 | Dunklin | Missouri | 29069 | 2312 | 16 |
960913 | 960913 | 2021-01-24 | Dunklin | Missouri | 29069 | 2311 | 16 |
957667 | 957667 | 2021-01-23 | Dunklin | Missouri | 29069 | 2306 | 16 |
954422 | 954422 | 2021-01-22 | Dunklin | Missouri | 29069 | 2296 | 16 |
951177 | 951177 | 2021-01-21 | Dunklin | Missouri | 29069 | 2291 | 16 |
947931 | 947931 | 2021-01-20 | Dunklin | Missouri | 29069 | 2277 | 16 |
944684 | 944684 | 2021-01-19 | Dunklin | Missouri | 29069 | 2272 | 16 |
941439 | 941439 | 2021-01-18 | Dunklin | Missouri | 29069 | 2271 | 16 |
938194 | 938194 | 2021-01-17 | Dunklin | Missouri | 29069 | 2266 | 16 |
934949 | 934949 | 2021-01-16 | Dunklin | Missouri | 29069 | 2259 | 16 |
931704 | 931704 | 2021-01-15 | Dunklin | Missouri | 29069 | 2256 | 17 |
928459 | 928459 | 2021-01-14 | Dunklin | Missouri | 29069 | 2247 | 17 |
925213 | 925213 | 2021-01-13 | Dunklin | Missouri | 29069 | 2227 | 17 |
921968 | 921968 | 2021-01-12 | Dunklin | Missouri | 29069 | 2214 | 17 |
918723 | 918723 | 2021-01-11 | Dunklin | Missouri | 29069 | 2207 | 17 |
915478 | 915478 | 2021-01-10 | Dunklin | Missouri | 29069 | 2202 | 17 |
912233 | 912233 | 2021-01-09 | Dunklin | Missouri | 29069 | 2184 | 17 |
908988 | 908988 | 2021-01-08 | Dunklin | Missouri | 29069 | 2163 | 17 |
905742 | 905742 | 2021-01-07 | Dunklin | Missouri | 29069 | 2155 | 17 |
902497 | 902497 | 2021-01-06 | Dunklin | Missouri | 29069 | 2133 | 17 |
899252 | 899252 | 2021-01-05 | Dunklin | Missouri | 29069 | 2129 | 17 |
896007 | 896007 | 2021-01-04 | Dunklin | Missouri | 29069 | 2112 | 15 |
892760 | 892760 | 2021-01-03 | Dunklin | Missouri | 29069 | 2112 | 15 |
889514 | 889514 | 2021-01-02 | Dunklin | Missouri | 29069 | 2105 | 15 |
886268 | 886268 | 2021-01-01 | Dunklin | Missouri | 29069 | 2096 | 15 |
883023 | 883023 | 2020-12-31 | Dunklin | Missouri | 29069 | 2083 | 15 |
879778 | 879778 | 2020-12-30 | Dunklin | Missouri | 29069 | 2066 | 15 |
876533 | 876533 | 2020-12-29 | Dunklin | Missouri | 29069 | 2060 | 15 |
873288 | 873288 | 2020-12-28 | Dunklin | Missouri | 29069 | 2042 | 15 |
870043 | 870043 | 2020-12-27 | Dunklin | Missouri | 29069 | 2037 | 15 |
866798 | 866798 | 2020-12-26 | Dunklin | Missouri | 29069 | 2029 | 15 |
863553 | 863553 | 2020-12-25 | Dunklin | Missouri | 29069 | 2026 | 15 |
860308 | 860308 | 2020-12-24 | Dunklin | Missouri | 29069 | 2023 | 15 |
857063 | 857063 | 2020-12-23 | Dunklin | Missouri | 29069 | 2008 | 15 |
853818 | 853818 | 2020-12-22 | Dunklin | Missouri | 29069 | 1998 | 14 |
850573 | 850573 | 2020-12-21 | Dunklin | Missouri | 29069 | 1989 | 14 |
847328 | 847328 | 2020-12-20 | Dunklin | Missouri | 29069 | 1984 | 14 |
844082 | 844082 | 2020-12-19 | Dunklin | Missouri | 29069 | 1975 | 14 |
840837 | 840837 | 2020-12-18 | Dunklin | Missouri | 29069 | 1970 | 14 |
837592 | 837592 | 2020-12-17 | Dunklin | Missouri | 29069 | 1963 | 14 |
834346 | 834346 | 2020-12-16 | Dunklin | Missouri | 29069 | 1956 | 14 |
831099 | 831099 | 2020-12-15 | Dunklin | Missouri | 29069 | 1869 | 14 |
827853 | 827853 | 2020-12-14 | Dunklin | Missouri | 29069 | 1858 | 14 |
824606 | 824606 | 2020-12-13 | Dunklin | Missouri | 29069 | 1851 | 14 |
821360 | 821360 | 2020-12-12 | Dunklin | Missouri | 29069 | 1842 | 14 |
818114 | 818114 | 2020-12-11 | Dunklin | Missouri | 29069 | 1827 | 14 |
814868 | 814868 | 2020-12-10 | Dunklin | Missouri | 29069 | 1827 | 14 |
811623 | 811623 | 2020-12-09 | Dunklin | Missouri | 29069 | 1800 | 14 |
808378 | 808378 | 2020-12-08 | Dunklin | Missouri | 29069 | 1798 | 14 |
805133 | 805133 | 2020-12-07 | Dunklin | Missouri | 29069 | 1787 | 14 |
801888 | 801888 | 2020-12-06 | Dunklin | Missouri | 29069 | 1777 | 14 |
798643 | 798643 | 2020-12-05 | Dunklin | Missouri | 29069 | 1762 | 14 |
795398 | 795398 | 2020-12-04 | Dunklin | Missouri | 29069 | 1745 | 14 |
792153 | 792153 | 2020-12-03 | Dunklin | Missouri | 29069 | 1738 | 14 |
788908 | 788908 | 2020-12-02 | Dunklin | Missouri | 29069 | 1726 | 14 |
785663 | 785663 | 2020-12-01 | Dunklin | Missouri | 29069 | 1720 | 14 |
782419 | 782419 | 2020-11-30 | Dunklin | Missouri | 29069 | 1708 | 14 |
779173 | 779173 | 2020-11-29 | Dunklin | Missouri | 29069 | 1691 | 14 |
775928 | 775928 | 2020-11-28 | Dunklin | Missouri | 29069 | 1679 | 14 |
772683 | 772683 | 2020-11-27 | Dunklin | Missouri | 29069 | 1666 | 14 |
769438 | 769438 | 2020-11-26 | Dunklin | Missouri | 29069 | 1662 | 14 |
766192 | 766192 | 2020-11-25 | Dunklin | Missouri | 29069 | 1629 | 14 |
762947 | 762947 | 2020-11-24 | Dunklin | Missouri | 29069 | 1608 | 14 |
759702 | 759702 | 2020-11-23 | Dunklin | Missouri | 29069 | 1595 | 13 |
756455 | 756455 | 2020-11-22 | Dunklin | Missouri | 29069 | 1586 | 13 |
753209 | 753209 | 2020-11-21 | Dunklin | Missouri | 29069 | 1578 | 13 |
749963 | 749963 | 2020-11-20 | Dunklin | Missouri | 29069 | 1558 | 13 |
746717 | 746717 | 2020-11-19 | Dunklin | Missouri | 29069 | 1544 | 13 |
743470 | 743470 | 2020-11-18 | Dunklin | Missouri | 29069 | 1540 | 13 |
740223 | 740223 | 2020-11-17 | Dunklin | Missouri | 29069 | 1510 | 13 |
736979 | 736979 | 2020-11-16 | Dunklin | Missouri | 29069 | 1477 | 13 |
733733 | 733733 | 2020-11-15 | Dunklin | Missouri | 29069 | 1463 | 13 |
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);