ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Scott" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054982 | 1054982 | 2021-02-22 | Scott | Mississippi | 28123 | 2912 | 66 |
1051735 | 1051735 | 2021-02-21 | Scott | Mississippi | 28123 | 2911 | 66 |
1048488 | 1048488 | 2021-02-20 | Scott | Mississippi | 28123 | 2900 | 66 |
1045242 | 1045242 | 2021-02-19 | Scott | Mississippi | 28123 | 2900 | 66 |
1041997 | 1041997 | 2021-02-18 | Scott | Mississippi | 28123 | 2898 | 66 |
1038752 | 1038752 | 2021-02-17 | Scott | Mississippi | 28123 | 2898 | 66 |
1035507 | 1035507 | 2021-02-16 | Scott | Mississippi | 28123 | 2891 | 66 |
1032262 | 1032262 | 2021-02-15 | Scott | Mississippi | 28123 | 2886 | 66 |
1029015 | 1029015 | 2021-02-14 | Scott | Mississippi | 28123 | 2877 | 66 |
1025769 | 1025769 | 2021-02-13 | Scott | Mississippi | 28123 | 2872 | 66 |
1022524 | 1022524 | 2021-02-12 | Scott | Mississippi | 28123 | 2864 | 66 |
1019279 | 1019279 | 2021-02-11 | Scott | Mississippi | 28123 | 2854 | 65 |
1016034 | 1016034 | 2021-02-10 | Scott | Mississippi | 28123 | 2839 | 65 |
1012789 | 1012789 | 2021-02-09 | Scott | Mississippi | 28123 | 2834 | 64 |
1009544 | 1009544 | 2021-02-08 | Scott | Mississippi | 28123 | 2827 | 60 |
1006297 | 1006297 | 2021-02-07 | Scott | Mississippi | 28123 | 2823 | 60 |
1003051 | 1003051 | 2021-02-06 | Scott | Mississippi | 28123 | 2812 | 60 |
999806 | 999806 | 2021-02-05 | Scott | Mississippi | 28123 | 2800 | 59 |
996560 | 996560 | 2021-02-04 | Scott | Mississippi | 28123 | 2786 | 58 |
993314 | 993314 | 2021-02-03 | Scott | Mississippi | 28123 | 2769 | 58 |
990068 | 990068 | 2021-02-02 | Scott | Mississippi | 28123 | 2759 | 58 |
986821 | 986821 | 2021-02-01 | Scott | Mississippi | 28123 | 2746 | 56 |
983574 | 983574 | 2021-01-31 | Scott | Mississippi | 28123 | 2742 | 56 |
980328 | 980328 | 2021-01-30 | Scott | Mississippi | 28123 | 2734 | 56 |
977082 | 977082 | 2021-01-29 | Scott | Mississippi | 28123 | 2720 | 55 |
973837 | 973837 | 2021-01-28 | Scott | Mississippi | 28123 | 2690 | 55 |
970592 | 970592 | 2021-01-27 | Scott | Mississippi | 28123 | 2680 | 55 |
967347 | 967347 | 2021-01-26 | Scott | Mississippi | 28123 | 2640 | 55 |
964103 | 964103 | 2021-01-25 | Scott | Mississippi | 28123 | 2608 | 49 |
960858 | 960858 | 2021-01-24 | Scott | Mississippi | 28123 | 2600 | 48 |
957612 | 957612 | 2021-01-23 | Scott | Mississippi | 28123 | 2596 | 48 |
954367 | 954367 | 2021-01-22 | Scott | Mississippi | 28123 | 2560 | 48 |
951122 | 951122 | 2021-01-21 | Scott | Mississippi | 28123 | 2534 | 48 |
947876 | 947876 | 2021-01-20 | Scott | Mississippi | 28123 | 2508 | 47 |
944629 | 944629 | 2021-01-19 | Scott | Mississippi | 28123 | 2480 | 46 |
941384 | 941384 | 2021-01-18 | Scott | Mississippi | 28123 | 2466 | 45 |
938139 | 938139 | 2021-01-17 | Scott | Mississippi | 28123 | 2462 | 45 |
934894 | 934894 | 2021-01-16 | Scott | Mississippi | 28123 | 2447 | 45 |
931649 | 931649 | 2021-01-15 | Scott | Mississippi | 28123 | 2410 | 43 |
928404 | 928404 | 2021-01-14 | Scott | Mississippi | 28123 | 2387 | 43 |
925158 | 925158 | 2021-01-13 | Scott | Mississippi | 28123 | 2362 | 43 |
921913 | 921913 | 2021-01-12 | Scott | Mississippi | 28123 | 2347 | 43 |
918668 | 918668 | 2021-01-11 | Scott | Mississippi | 28123 | 2332 | 42 |
915423 | 915423 | 2021-01-10 | Scott | Mississippi | 28123 | 2326 | 42 |
912178 | 912178 | 2021-01-09 | Scott | Mississippi | 28123 | 2304 | 42 |
908933 | 908933 | 2021-01-08 | Scott | Mississippi | 28123 | 2280 | 42 |
905687 | 905687 | 2021-01-07 | Scott | Mississippi | 28123 | 2254 | 42 |
902442 | 902442 | 2021-01-06 | Scott | Mississippi | 28123 | 2228 | 41 |
899197 | 899197 | 2021-01-05 | Scott | Mississippi | 28123 | 2199 | 41 |
895952 | 895952 | 2021-01-04 | Scott | Mississippi | 28123 | 2188 | 41 |
892705 | 892705 | 2021-01-03 | Scott | Mississippi | 28123 | 2177 | 41 |
889459 | 889459 | 2021-01-02 | Scott | Mississippi | 28123 | 2154 | 41 |
886213 | 886213 | 2021-01-01 | Scott | Mississippi | 28123 | 2146 | 40 |
882968 | 882968 | 2020-12-31 | Scott | Mississippi | 28123 | 2131 | 40 |
879723 | 879723 | 2020-12-30 | Scott | Mississippi | 28123 | 2111 | 40 |
876478 | 876478 | 2020-12-29 | Scott | Mississippi | 28123 | 2096 | 40 |
873233 | 873233 | 2020-12-28 | Scott | Mississippi | 28123 | 2071 | 38 |
869988 | 869988 | 2020-12-27 | Scott | Mississippi | 28123 | 2052 | 38 |
866743 | 866743 | 2020-12-26 | Scott | Mississippi | 28123 | 2039 | 38 |
863498 | 863498 | 2020-12-25 | Scott | Mississippi | 28123 | 2035 | 38 |
860253 | 860253 | 2020-12-24 | Scott | Mississippi | 28123 | 2029 | 38 |
857008 | 857008 | 2020-12-23 | Scott | Mississippi | 28123 | 2004 | 38 |
853763 | 853763 | 2020-12-22 | Scott | Mississippi | 28123 | 1988 | 38 |
850518 | 850518 | 2020-12-21 | Scott | Mississippi | 28123 | 1941 | 36 |
847273 | 847273 | 2020-12-20 | Scott | Mississippi | 28123 | 1931 | 36 |
844027 | 844027 | 2020-12-19 | Scott | Mississippi | 28123 | 1907 | 35 |
840782 | 840782 | 2020-12-18 | Scott | Mississippi | 28123 | 1892 | 34 |
837537 | 837537 | 2020-12-17 | Scott | Mississippi | 28123 | 1873 | 34 |
834291 | 834291 | 2020-12-16 | Scott | Mississippi | 28123 | 1862 | 33 |
831044 | 831044 | 2020-12-15 | Scott | Mississippi | 28123 | 1851 | 33 |
827798 | 827798 | 2020-12-14 | Scott | Mississippi | 28123 | 1843 | 31 |
824551 | 824551 | 2020-12-13 | Scott | Mississippi | 28123 | 1833 | 31 |
821305 | 821305 | 2020-12-12 | Scott | Mississippi | 28123 | 1829 | 31 |
818059 | 818059 | 2020-12-11 | Scott | Mississippi | 28123 | 1803 | 30 |
814813 | 814813 | 2020-12-10 | Scott | Mississippi | 28123 | 1774 | 30 |
811568 | 811568 | 2020-12-09 | Scott | Mississippi | 28123 | 1749 | 30 |
808323 | 808323 | 2020-12-08 | Scott | Mississippi | 28123 | 1715 | 30 |
805078 | 805078 | 2020-12-07 | Scott | Mississippi | 28123 | 1702 | 30 |
801833 | 801833 | 2020-12-06 | Scott | Mississippi | 28123 | 1691 | 30 |
798588 | 798588 | 2020-12-05 | Scott | Mississippi | 28123 | 1684 | 30 |
795343 | 795343 | 2020-12-04 | Scott | Mississippi | 28123 | 1660 | 30 |
792098 | 792098 | 2020-12-03 | Scott | Mississippi | 28123 | 1627 | 30 |
788853 | 788853 | 2020-12-02 | Scott | Mississippi | 28123 | 1613 | 30 |
785608 | 785608 | 2020-12-01 | Scott | Mississippi | 28123 | 1594 | 30 |
782364 | 782364 | 2020-11-30 | Scott | Mississippi | 28123 | 1579 | 30 |
779118 | 779118 | 2020-11-29 | Scott | Mississippi | 28123 | 1566 | 30 |
775873 | 775873 | 2020-11-28 | Scott | Mississippi | 28123 | 1548 | 29 |
772628 | 772628 | 2020-11-27 | Scott | Mississippi | 28123 | 1521 | 29 |
769383 | 769383 | 2020-11-26 | Scott | Mississippi | 28123 | 1518 | 29 |
766137 | 766137 | 2020-11-25 | Scott | Mississippi | 28123 | 1507 | 29 |
762892 | 762892 | 2020-11-24 | Scott | Mississippi | 28123 | 1502 | 29 |
759647 | 759647 | 2020-11-23 | Scott | Mississippi | 28123 | 1499 | 29 |
756400 | 756400 | 2020-11-22 | Scott | Mississippi | 28123 | 1494 | 29 |
753154 | 753154 | 2020-11-21 | Scott | Mississippi | 28123 | 1491 | 29 |
749908 | 749908 | 2020-11-20 | Scott | Mississippi | 28123 | 1452 | 29 |
746662 | 746662 | 2020-11-19 | Scott | Mississippi | 28123 | 1438 | 29 |
743415 | 743415 | 2020-11-18 | Scott | Mississippi | 28123 | 1426 | 29 |
740168 | 740168 | 2020-11-17 | Scott | Mississippi | 28123 | 1414 | 29 |
736924 | 736924 | 2020-11-16 | Scott | Mississippi | 28123 | 1396 | 29 |
733678 | 733678 | 2020-11-15 | Scott | Mississippi | 28123 | 1388 | 29 |
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);