ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Scott" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
935011 | 935011 | 2021-01-16 | Scott | Missouri | 29201 | 3579 | 68 |
931766 | 931766 | 2021-01-15 | Scott | Missouri | 29201 | 3574 | 68 |
928521 | 928521 | 2021-01-14 | Scott | Missouri | 29201 | 3547 | 68 |
925275 | 925275 | 2021-01-13 | Scott | Missouri | 29201 | 3531 | 68 |
922030 | 922030 | 2021-01-12 | Scott | Missouri | 29201 | 3521 | 67 |
918785 | 918785 | 2021-01-11 | Scott | Missouri | 29201 | 3513 | 66 |
915540 | 915540 | 2021-01-10 | Scott | Missouri | 29201 | 3504 | 66 |
912295 | 912295 | 2021-01-09 | Scott | Missouri | 29201 | 3490 | 66 |
909050 | 909050 | 2021-01-08 | Scott | Missouri | 29201 | 3472 | 65 |
905804 | 905804 | 2021-01-07 | Scott | Missouri | 29201 | 3445 | 63 |
902559 | 902559 | 2021-01-06 | Scott | Missouri | 29201 | 3417 | 63 |
899314 | 899314 | 2021-01-05 | Scott | Missouri | 29201 | 3392 | 62 |
896069 | 896069 | 2021-01-04 | Scott | Missouri | 29201 | 3367 | 60 |
892822 | 892822 | 2021-01-03 | Scott | Missouri | 29201 | 3367 | 60 |
889576 | 889576 | 2021-01-02 | Scott | Missouri | 29201 | 3358 | 60 |
886330 | 886330 | 2021-01-01 | Scott | Missouri | 29201 | 3345 | 60 |
883085 | 883085 | 2020-12-31 | Scott | Missouri | 29201 | 3328 | 60 |
879840 | 879840 | 2020-12-30 | Scott | Missouri | 29201 | 3297 | 60 |
876595 | 876595 | 2020-12-29 | Scott | Missouri | 29201 | 3286 | 60 |
873350 | 873350 | 2020-12-28 | Scott | Missouri | 29201 | 3298 | 59 |
870105 | 870105 | 2020-12-27 | Scott | Missouri | 29201 | 3274 | 59 |
866860 | 866860 | 2020-12-26 | Scott | Missouri | 29201 | 3261 | 59 |
863615 | 863615 | 2020-12-25 | Scott | Missouri | 29201 | 3255 | 59 |
860370 | 860370 | 2020-12-24 | Scott | Missouri | 29201 | 3229 | 59 |
857125 | 857125 | 2020-12-23 | Scott | Missouri | 29201 | 3215 | 57 |
853880 | 853880 | 2020-12-22 | Scott | Missouri | 29201 | 3200 | 56 |
850635 | 850635 | 2020-12-21 | Scott | Missouri | 29201 | 3184 | 53 |
847390 | 847390 | 2020-12-20 | Scott | Missouri | 29201 | 3167 | 53 |
844144 | 844144 | 2020-12-19 | Scott | Missouri | 29201 | 3157 | 52 |
840899 | 840899 | 2020-12-18 | Scott | Missouri | 29201 | 3141 | 49 |
837654 | 837654 | 2020-12-17 | Scott | Missouri | 29201 | 3114 | 49 |
834408 | 834408 | 2020-12-16 | Scott | Missouri | 29201 | 3092 | 49 |
831161 | 831161 | 2020-12-15 | Scott | Missouri | 29201 | 3083 | 48 |
827915 | 827915 | 2020-12-14 | Scott | Missouri | 29201 | 3072 | 45 |
824668 | 824668 | 2020-12-13 | Scott | Missouri | 29201 | 3058 | 45 |
821422 | 821422 | 2020-12-12 | Scott | Missouri | 29201 | 3045 | 45 |
818176 | 818176 | 2020-12-11 | Scott | Missouri | 29201 | 3004 | 44 |
814930 | 814930 | 2020-12-10 | Scott | Missouri | 29201 | 3004 | 44 |
811685 | 811685 | 2020-12-09 | Scott | Missouri | 29201 | 2969 | 44 |
808440 | 808440 | 2020-12-08 | Scott | Missouri | 29201 | 2962 | 43 |
805195 | 805195 | 2020-12-07 | Scott | Missouri | 29201 | 2936 | 42 |
801950 | 801950 | 2020-12-06 | Scott | Missouri | 29201 | 2914 | 42 |
798705 | 798705 | 2020-12-05 | Scott | Missouri | 29201 | 2871 | 42 |
795460 | 795460 | 2020-12-04 | Scott | Missouri | 29201 | 2816 | 42 |
792215 | 792215 | 2020-12-03 | Scott | Missouri | 29201 | 2780 | 42 |
788970 | 788970 | 2020-12-02 | Scott | Missouri | 29201 | 2739 | 38 |
785725 | 785725 | 2020-12-01 | Scott | Missouri | 29201 | 2712 | 38 |
782481 | 782481 | 2020-11-30 | Scott | Missouri | 29201 | 2686 | 38 |
779235 | 779235 | 2020-11-29 | Scott | Missouri | 29201 | 2651 | 38 |
775990 | 775990 | 2020-11-28 | Scott | Missouri | 29201 | 2623 | 37 |
772745 | 772745 | 2020-11-27 | Scott | Missouri | 29201 | 2587 | 37 |
769500 | 769500 | 2020-11-26 | Scott | Missouri | 29201 | 2569 | 37 |
766254 | 766254 | 2020-11-25 | Scott | Missouri | 29201 | 2524 | 37 |
763009 | 763009 | 2020-11-24 | Scott | Missouri | 29201 | 2489 | 37 |
759764 | 759764 | 2020-11-23 | Scott | Missouri | 29201 | 2449 | 36 |
756517 | 756517 | 2020-11-22 | Scott | Missouri | 29201 | 2419 | 36 |
753271 | 753271 | 2020-11-21 | Scott | Missouri | 29201 | 2382 | 36 |
750025 | 750025 | 2020-11-20 | Scott | Missouri | 29201 | 2326 | 36 |
746779 | 746779 | 2020-11-19 | Scott | Missouri | 29201 | 2259 | 36 |
743532 | 743532 | 2020-11-18 | Scott | Missouri | 29201 | 2205 | 33 |
740285 | 740285 | 2020-11-17 | Scott | Missouri | 29201 | 2139 | 33 |
737041 | 737041 | 2020-11-16 | Scott | Missouri | 29201 | 2074 | 33 |
733795 | 733795 | 2020-11-15 | Scott | Missouri | 29201 | 2045 | 33 |
730550 | 730550 | 2020-11-14 | Scott | Missouri | 29201 | 2045 | 33 |
727307 | 727307 | 2020-11-13 | Scott | Missouri | 29201 | 1959 | 33 |
724064 | 724064 | 2020-11-12 | Scott | Missouri | 29201 | 1889 | 33 |
720821 | 720821 | 2020-11-11 | Scott | Missouri | 29201 | 1855 | 33 |
717578 | 717578 | 2020-11-10 | Scott | Missouri | 29201 | 1805 | 33 |
714334 | 714334 | 2020-11-09 | Scott | Missouri | 29201 | 1773 | 31 |
711090 | 711090 | 2020-11-08 | Scott | Missouri | 29201 | 1755 | 31 |
707846 | 707846 | 2020-11-07 | Scott | Missouri | 29201 | 1722 | 31 |
704603 | 704603 | 2020-11-06 | Scott | Missouri | 29201 | 1688 | 30 |
701361 | 701361 | 2020-11-05 | Scott | Missouri | 29201 | 1645 | 29 |
698117 | 698117 | 2020-11-04 | Scott | Missouri | 29201 | 1624 | 27 |
694874 | 694874 | 2020-11-03 | Scott | Missouri | 29201 | 1600 | 27 |
691632 | 691632 | 2020-11-02 | Scott | Missouri | 29201 | 1585 | 26 |
688387 | 688387 | 2020-11-01 | Scott | Missouri | 29201 | 1551 | 26 |
685143 | 685143 | 2020-10-31 | Scott | Missouri | 29201 | 1519 | 26 |
681900 | 681900 | 2020-10-30 | Scott | Missouri | 29201 | 1484 | 25 |
678656 | 678656 | 2020-10-29 | Scott | Missouri | 29201 | 1457 | 25 |
675414 | 675414 | 2020-10-28 | Scott | Missouri | 29201 | 1434 | 25 |
672171 | 672171 | 2020-10-27 | Scott | Missouri | 29201 | 1429 | 25 |
668929 | 668929 | 2020-10-26 | Scott | Missouri | 29201 | 1407 | 20 |
665685 | 665685 | 2020-10-25 | Scott | Missouri | 29201 | 1390 | 19 |
662440 | 662440 | 2020-10-24 | Scott | Missouri | 29201 | 1377 | 19 |
659196 | 659196 | 2020-10-23 | Scott | Missouri | 29201 | 1356 | 19 |
655951 | 655951 | 2020-10-22 | Scott | Missouri | 29201 | 1337 | 19 |
652706 | 652706 | 2020-10-21 | Scott | Missouri | 29201 | 1312 | 19 |
649461 | 649461 | 2020-10-20 | Scott | Missouri | 29201 | 1266 | 18 |
646217 | 646217 | 2020-10-19 | Scott | Missouri | 29201 | 1266 | 18 |
642971 | 642971 | 2020-10-18 | Scott | Missouri | 29201 | 1244 | 18 |
639723 | 639723 | 2020-10-17 | Scott | Missouri | 29201 | 1224 | 18 |
636477 | 636477 | 2020-10-16 | Scott | Missouri | 29201 | 1186 | 18 |
633231 | 633231 | 2020-10-15 | Scott | Missouri | 29201 | 1164 | 18 |
629986 | 629986 | 2020-10-14 | Scott | Missouri | 29201 | 1151 | 18 |
626742 | 626742 | 2020-10-13 | Scott | Missouri | 29201 | 1114 | 17 |
623500 | 623500 | 2020-10-12 | Scott | Missouri | 29201 | 1114 | 17 |
620257 | 620257 | 2020-10-11 | Scott | Missouri | 29201 | 1114 | 17 |
617015 | 617015 | 2020-10-10 | Scott | Missouri | 29201 | 1114 | 17 |
613774 | 613774 | 2020-10-09 | Scott | Missouri | 29201 | 1026 | 17 |
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);