ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Scott" and fips = 29201 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064835 | 1064835 | 2021-02-25 | Scott | Missouri | 29201 | 3808 | 76 |
1061591 | 1061591 | 2021-02-24 | Scott | Missouri | 29201 | 3806 | 75 |
1058345 | 1058345 | 2021-02-23 | Scott | Missouri | 29201 | 3799 | 75 |
1055099 | 1055099 | 2021-02-22 | Scott | Missouri | 29201 | 3796 | 73 |
1051852 | 1051852 | 2021-02-21 | Scott | Missouri | 29201 | 3795 | 73 |
1048605 | 1048605 | 2021-02-20 | Scott | Missouri | 29201 | 3794 | 73 |
1045359 | 1045359 | 2021-02-19 | Scott | Missouri | 29201 | 3794 | 73 |
1042114 | 1042114 | 2021-02-18 | Scott | Missouri | 29201 | 3783 | 74 |
1038869 | 1038869 | 2021-02-17 | Scott | Missouri | 29201 | 3766 | 74 |
1035624 | 1035624 | 2021-02-16 | Scott | Missouri | 29201 | 3764 | 74 |
1032379 | 1032379 | 2021-02-15 | Scott | Missouri | 29201 | 3761 | 74 |
1029132 | 1029132 | 2021-02-14 | Scott | Missouri | 29201 | 3754 | 74 |
1025886 | 1025886 | 2021-02-13 | Scott | Missouri | 29201 | 3754 | 74 |
1022641 | 1022641 | 2021-02-12 | Scott | Missouri | 29201 | 3745 | 74 |
1019396 | 1019396 | 2021-02-11 | Scott | Missouri | 29201 | 3741 | 74 |
1016151 | 1016151 | 2021-02-10 | Scott | Missouri | 29201 | 3734 | 72 |
1012906 | 1012906 | 2021-02-09 | Scott | Missouri | 29201 | 3727 | 71 |
1009661 | 1009661 | 2021-02-08 | Scott | Missouri | 29201 | 3724 | 71 |
1006414 | 1006414 | 2021-02-07 | Scott | Missouri | 29201 | 3723 | 71 |
1003168 | 1003168 | 2021-02-06 | Scott | Missouri | 29201 | 3711 | 71 |
999923 | 999923 | 2021-02-05 | Scott | Missouri | 29201 | 3699 | 71 |
996677 | 996677 | 2021-02-04 | Scott | Missouri | 29201 | 3691 | 71 |
993431 | 993431 | 2021-02-03 | Scott | Missouri | 29201 | 3680 | 71 |
990185 | 990185 | 2021-02-02 | Scott | Missouri | 29201 | 3674 | 71 |
986938 | 986938 | 2021-02-01 | Scott | Missouri | 29201 | 3672 | 71 |
983691 | 983691 | 2021-01-31 | Scott | Missouri | 29201 | 3671 | 71 |
980445 | 980445 | 2021-01-30 | Scott | Missouri | 29201 | 3672 | 71 |
977199 | 977199 | 2021-01-29 | Scott | Missouri | 29201 | 3666 | 71 |
973954 | 973954 | 2021-01-28 | Scott | Missouri | 29201 | 3656 | 71 |
970709 | 970709 | 2021-01-27 | Scott | Missouri | 29201 | 3646 | 71 |
967464 | 967464 | 2021-01-26 | Scott | Missouri | 29201 | 3633 | 71 |
964220 | 964220 | 2021-01-25 | Scott | Missouri | 29201 | 3633 | 70 |
960975 | 960975 | 2021-01-24 | Scott | Missouri | 29201 | 3633 | 70 |
957729 | 957729 | 2021-01-23 | Scott | Missouri | 29201 | 3628 | 70 |
954484 | 954484 | 2021-01-22 | Scott | Missouri | 29201 | 3613 | 69 |
951239 | 951239 | 2021-01-21 | Scott | Missouri | 29201 | 3608 | 68 |
947993 | 947993 | 2021-01-20 | Scott | Missouri | 29201 | 3592 | 68 |
944746 | 944746 | 2021-01-19 | Scott | Missouri | 29201 | 3587 | 68 |
941501 | 941501 | 2021-01-18 | Scott | Missouri | 29201 | 3584 | 68 |
938256 | 938256 | 2021-01-17 | Scott | Missouri | 29201 | 3583 | 68 |
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 |
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);