ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Stone" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
935021 | 935021 | 2021-01-16 | Stone | Missouri | 29209 | 1828 | 28 |
931776 | 931776 | 2021-01-15 | Stone | Missouri | 29209 | 1817 | 28 |
928531 | 928531 | 2021-01-14 | Stone | Missouri | 29209 | 1807 | 28 |
925285 | 925285 | 2021-01-13 | Stone | Missouri | 29209 | 1794 | 28 |
922040 | 922040 | 2021-01-12 | Stone | Missouri | 29209 | 1785 | 28 |
918795 | 918795 | 2021-01-11 | Stone | Missouri | 29209 | 1767 | 27 |
915550 | 915550 | 2021-01-10 | Stone | Missouri | 29209 | 1758 | 27 |
912305 | 912305 | 2021-01-09 | Stone | Missouri | 29209 | 1745 | 27 |
909060 | 909060 | 2021-01-08 | Stone | Missouri | 29209 | 1732 | 27 |
905814 | 905814 | 2021-01-07 | Stone | Missouri | 29209 | 1708 | 27 |
902569 | 902569 | 2021-01-06 | Stone | Missouri | 29209 | 1701 | 27 |
899324 | 899324 | 2021-01-05 | Stone | Missouri | 29209 | 1694 | 25 |
896079 | 896079 | 2021-01-04 | Stone | Missouri | 29209 | 1663 | 24 |
892832 | 892832 | 2021-01-03 | Stone | Missouri | 29209 | 1663 | 24 |
889586 | 889586 | 2021-01-02 | Stone | Missouri | 29209 | 1651 | 24 |
886340 | 886340 | 2021-01-01 | Stone | Missouri | 29209 | 1645 | 24 |
883095 | 883095 | 2020-12-31 | Stone | Missouri | 29209 | 1612 | 24 |
879850 | 879850 | 2020-12-30 | Stone | Missouri | 29209 | 1592 | 24 |
876605 | 876605 | 2020-12-29 | Stone | Missouri | 29209 | 1578 | 24 |
873360 | 873360 | 2020-12-28 | Stone | Missouri | 29209 | 1572 | 24 |
870115 | 870115 | 2020-12-27 | Stone | Missouri | 29209 | 1570 | 24 |
866870 | 866870 | 2020-12-26 | Stone | Missouri | 29209 | 1558 | 24 |
863625 | 863625 | 2020-12-25 | Stone | Missouri | 29209 | 1553 | 24 |
860380 | 860380 | 2020-12-24 | Stone | Missouri | 29209 | 1545 | 24 |
857135 | 857135 | 2020-12-23 | Stone | Missouri | 29209 | 1531 | 23 |
853890 | 853890 | 2020-12-22 | Stone | Missouri | 29209 | 1524 | 23 |
850645 | 850645 | 2020-12-21 | Stone | Missouri | 29209 | 1517 | 23 |
847400 | 847400 | 2020-12-20 | Stone | Missouri | 29209 | 1505 | 23 |
844154 | 844154 | 2020-12-19 | Stone | Missouri | 29209 | 1492 | 23 |
840909 | 840909 | 2020-12-18 | Stone | Missouri | 29209 | 1470 | 23 |
837664 | 837664 | 2020-12-17 | Stone | Missouri | 29209 | 1457 | 23 |
834418 | 834418 | 2020-12-16 | Stone | Missouri | 29209 | 1432 | 23 |
831171 | 831171 | 2020-12-15 | Stone | Missouri | 29209 | 1417 | 20 |
827925 | 827925 | 2020-12-14 | Stone | Missouri | 29209 | 1414 | 20 |
824678 | 824678 | 2020-12-13 | Stone | Missouri | 29209 | 1396 | 20 |
821432 | 821432 | 2020-12-12 | Stone | Missouri | 29209 | 1382 | 20 |
818186 | 818186 | 2020-12-11 | Stone | Missouri | 29209 | 1358 | 20 |
814940 | 814940 | 2020-12-10 | Stone | Missouri | 29209 | 1358 | 20 |
811695 | 811695 | 2020-12-09 | Stone | Missouri | 29209 | 1342 | 19 |
808450 | 808450 | 2020-12-08 | Stone | Missouri | 29209 | 1326 | 19 |
805205 | 805205 | 2020-12-07 | Stone | Missouri | 29209 | 1318 | 19 |
801960 | 801960 | 2020-12-06 | Stone | Missouri | 29209 | 1297 | 19 |
798715 | 798715 | 2020-12-05 | Stone | Missouri | 29209 | 1284 | 19 |
795470 | 795470 | 2020-12-04 | Stone | Missouri | 29209 | 1265 | 19 |
792225 | 792225 | 2020-12-03 | Stone | Missouri | 29209 | 1239 | 19 |
788980 | 788980 | 2020-12-02 | Stone | Missouri | 29209 | 1226 | 18 |
785735 | 785735 | 2020-12-01 | Stone | Missouri | 29209 | 1207 | 16 |
782491 | 782491 | 2020-11-30 | Stone | Missouri | 29209 | 1198 | 16 |
779245 | 779245 | 2020-11-29 | Stone | Missouri | 29209 | 1174 | 16 |
776000 | 776000 | 2020-11-28 | Stone | Missouri | 29209 | 1167 | 16 |
772755 | 772755 | 2020-11-27 | Stone | Missouri | 29209 | 1166 | 16 |
769510 | 769510 | 2020-11-26 | Stone | Missouri | 29209 | 1151 | 16 |
766264 | 766264 | 2020-11-25 | Stone | Missouri | 29209 | 1133 | 15 |
763019 | 763019 | 2020-11-24 | Stone | Missouri | 29209 | 1126 | 15 |
759774 | 759774 | 2020-11-23 | Stone | Missouri | 29209 | 1125 | 15 |
756527 | 756527 | 2020-11-22 | Stone | Missouri | 29209 | 1104 | 15 |
753281 | 753281 | 2020-11-21 | Stone | Missouri | 29209 | 1070 | 15 |
750035 | 750035 | 2020-11-20 | Stone | Missouri | 29209 | 1058 | 15 |
746789 | 746789 | 2020-11-19 | Stone | Missouri | 29209 | 1042 | 15 |
743542 | 743542 | 2020-11-18 | Stone | Missouri | 29209 | 1031 | 14 |
740295 | 740295 | 2020-11-17 | Stone | Missouri | 29209 | 1020 | 13 |
737051 | 737051 | 2020-11-16 | Stone | Missouri | 29209 | 988 | 13 |
733805 | 733805 | 2020-11-15 | Stone | Missouri | 29209 | 964 | 13 |
730560 | 730560 | 2020-11-14 | Stone | Missouri | 29209 | 964 | 13 |
727317 | 727317 | 2020-11-13 | Stone | Missouri | 29209 | 927 | 13 |
724074 | 724074 | 2020-11-12 | Stone | Missouri | 29209 | 909 | 13 |
720831 | 720831 | 2020-11-11 | Stone | Missouri | 29209 | 896 | 13 |
717588 | 717588 | 2020-11-10 | Stone | Missouri | 29209 | 878 | 13 |
714344 | 714344 | 2020-11-09 | Stone | Missouri | 29209 | 869 | 13 |
711100 | 711100 | 2020-11-08 | Stone | Missouri | 29209 | 857 | 13 |
707856 | 707856 | 2020-11-07 | Stone | Missouri | 29209 | 841 | 13 |
704613 | 704613 | 2020-11-06 | Stone | Missouri | 29209 | 829 | 12 |
701371 | 701371 | 2020-11-05 | Stone | Missouri | 29209 | 804 | 11 |
698127 | 698127 | 2020-11-04 | Stone | Missouri | 29209 | 791 | 11 |
694884 | 694884 | 2020-11-03 | Stone | Missouri | 29209 | 779 | 11 |
691642 | 691642 | 2020-11-02 | Stone | Missouri | 29209 | 770 | 11 |
688397 | 688397 | 2020-11-01 | Stone | Missouri | 29209 | 753 | 11 |
685153 | 685153 | 2020-10-31 | Stone | Missouri | 29209 | 747 | 11 |
681910 | 681910 | 2020-10-30 | Stone | Missouri | 29209 | 736 | 11 |
678666 | 678666 | 2020-10-29 | Stone | Missouri | 29209 | 728 | 10 |
675424 | 675424 | 2020-10-28 | Stone | Missouri | 29209 | 712 | 9 |
672181 | 672181 | 2020-10-27 | Stone | Missouri | 29209 | 696 | 9 |
668939 | 668939 | 2020-10-26 | Stone | Missouri | 29209 | 689 | 9 |
665695 | 665695 | 2020-10-25 | Stone | Missouri | 29209 | 678 | 9 |
662450 | 662450 | 2020-10-24 | Stone | Missouri | 29209 | 669 | 9 |
659206 | 659206 | 2020-10-23 | Stone | Missouri | 29209 | 657 | 9 |
655961 | 655961 | 2020-10-22 | Stone | Missouri | 29209 | 655 | 8 |
652716 | 652716 | 2020-10-21 | Stone | Missouri | 29209 | 646 | 8 |
649471 | 649471 | 2020-10-20 | Stone | Missouri | 29209 | 637 | 7 |
646227 | 646227 | 2020-10-19 | Stone | Missouri | 29209 | 637 | 7 |
642981 | 642981 | 2020-10-18 | Stone | Missouri | 29209 | 633 | 7 |
639733 | 639733 | 2020-10-17 | Stone | Missouri | 29209 | 624 | 7 |
636487 | 636487 | 2020-10-16 | Stone | Missouri | 29209 | 615 | 6 |
633241 | 633241 | 2020-10-15 | Stone | Missouri | 29209 | 606 | 6 |
629996 | 629996 | 2020-10-14 | Stone | Missouri | 29209 | 597 | 7 |
626752 | 626752 | 2020-10-13 | Stone | Missouri | 29209 | 570 | 6 |
623510 | 623510 | 2020-10-12 | Stone | Missouri | 29209 | 570 | 6 |
620267 | 620267 | 2020-10-11 | Stone | Missouri | 29209 | 570 | 6 |
617025 | 617025 | 2020-10-10 | Stone | Missouri | 29209 | 570 | 6 |
613784 | 613784 | 2020-10-09 | Stone | Missouri | 29209 | 551 | 6 |
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);