ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Marshall" and state = "Mississippi" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1058213 | 1058213 | 2021-02-23 | Marshall | Mississippi | 28093 | 3979 | 92 |
1054967 | 1054967 | 2021-02-22 | Marshall | Mississippi | 28093 | 3963 | 92 |
1051720 | 1051720 | 2021-02-21 | Marshall | Mississippi | 28093 | 3952 | 92 |
1048473 | 1048473 | 2021-02-20 | Marshall | Mississippi | 28093 | 3953 | 92 |
1045227 | 1045227 | 2021-02-19 | Marshall | Mississippi | 28093 | 3944 | 92 |
1041982 | 1041982 | 2021-02-18 | Marshall | Mississippi | 28093 | 3943 | 92 |
1038737 | 1038737 | 2021-02-17 | Marshall | Mississippi | 28093 | 3940 | 92 |
1035492 | 1035492 | 2021-02-16 | Marshall | Mississippi | 28093 | 3935 | 92 |
1032247 | 1032247 | 2021-02-15 | Marshall | Mississippi | 28093 | 3921 | 90 |
1029000 | 1029000 | 2021-02-14 | Marshall | Mississippi | 28093 | 3909 | 90 |
1025754 | 1025754 | 2021-02-13 | Marshall | Mississippi | 28093 | 3884 | 90 |
1022509 | 1022509 | 2021-02-12 | Marshall | Mississippi | 28093 | 3878 | 90 |
1019264 | 1019264 | 2021-02-11 | Marshall | Mississippi | 28093 | 3859 | 89 |
1016019 | 1016019 | 2021-02-10 | Marshall | Mississippi | 28093 | 3838 | 89 |
1012774 | 1012774 | 2021-02-09 | Marshall | Mississippi | 28093 | 3828 | 88 |
1009529 | 1009529 | 2021-02-08 | Marshall | Mississippi | 28093 | 3811 | 87 |
1006282 | 1006282 | 2021-02-07 | Marshall | Mississippi | 28093 | 3799 | 87 |
1003036 | 1003036 | 2021-02-06 | Marshall | Mississippi | 28093 | 3788 | 87 |
999791 | 999791 | 2021-02-05 | Marshall | Mississippi | 28093 | 3781 | 87 |
996545 | 996545 | 2021-02-04 | Marshall | Mississippi | 28093 | 3760 | 83 |
993299 | 993299 | 2021-02-03 | Marshall | Mississippi | 28093 | 3738 | 81 |
990053 | 990053 | 2021-02-02 | Marshall | Mississippi | 28093 | 3728 | 81 |
986806 | 986806 | 2021-02-01 | Marshall | Mississippi | 28093 | 3720 | 78 |
983559 | 983559 | 2021-01-31 | Marshall | Mississippi | 28093 | 3710 | 77 |
980313 | 980313 | 2021-01-30 | Marshall | Mississippi | 28093 | 3682 | 76 |
977067 | 977067 | 2021-01-29 | Marshall | Mississippi | 28093 | 3673 | 75 |
973822 | 973822 | 2021-01-28 | Marshall | Mississippi | 28093 | 3650 | 74 |
970577 | 970577 | 2021-01-27 | Marshall | Mississippi | 28093 | 3622 | 73 |
967332 | 967332 | 2021-01-26 | Marshall | Mississippi | 28093 | 3601 | 72 |
964088 | 964088 | 2021-01-25 | Marshall | Mississippi | 28093 | 3585 | 70 |
960843 | 960843 | 2021-01-24 | Marshall | Mississippi | 28093 | 3571 | 70 |
957597 | 957597 | 2021-01-23 | Marshall | Mississippi | 28093 | 3552 | 70 |
954352 | 954352 | 2021-01-22 | Marshall | Mississippi | 28093 | 3520 | 69 |
951107 | 951107 | 2021-01-21 | Marshall | Mississippi | 28093 | 3495 | 69 |
947861 | 947861 | 2021-01-20 | Marshall | Mississippi | 28093 | 3477 | 69 |
944614 | 944614 | 2021-01-19 | Marshall | Mississippi | 28093 | 3440 | 66 |
941369 | 941369 | 2021-01-18 | Marshall | Mississippi | 28093 | 3426 | 65 |
938124 | 938124 | 2021-01-17 | Marshall | Mississippi | 28093 | 3416 | 65 |
934879 | 934879 | 2021-01-16 | Marshall | Mississippi | 28093 | 3391 | 65 |
931634 | 931634 | 2021-01-15 | Marshall | Mississippi | 28093 | 3360 | 65 |
928389 | 928389 | 2021-01-14 | Marshall | Mississippi | 28093 | 3332 | 64 |
925143 | 925143 | 2021-01-13 | Marshall | Mississippi | 28093 | 3315 | 64 |
921898 | 921898 | 2021-01-12 | Marshall | Mississippi | 28093 | 3291 | 64 |
918653 | 918653 | 2021-01-11 | Marshall | Mississippi | 28093 | 3264 | 63 |
915408 | 915408 | 2021-01-10 | Marshall | Mississippi | 28093 | 3241 | 63 |
912163 | 912163 | 2021-01-09 | Marshall | Mississippi | 28093 | 3211 | 63 |
908918 | 908918 | 2021-01-08 | Marshall | Mississippi | 28093 | 3144 | 63 |
905672 | 905672 | 2021-01-07 | Marshall | Mississippi | 28093 | 3107 | 63 |
902427 | 902427 | 2021-01-06 | Marshall | Mississippi | 28093 | 3068 | 63 |
899182 | 899182 | 2021-01-05 | Marshall | Mississippi | 28093 | 3027 | 63 |
895937 | 895937 | 2021-01-04 | Marshall | Mississippi | 28093 | 3001 | 63 |
892690 | 892690 | 2021-01-03 | Marshall | Mississippi | 28093 | 2977 | 63 |
889444 | 889444 | 2021-01-02 | Marshall | Mississippi | 28093 | 2954 | 63 |
886198 | 886198 | 2021-01-01 | Marshall | Mississippi | 28093 | 2929 | 63 |
882953 | 882953 | 2020-12-31 | Marshall | Mississippi | 28093 | 2915 | 63 |
879708 | 879708 | 2020-12-30 | Marshall | Mississippi | 28093 | 2879 | 63 |
876463 | 876463 | 2020-12-29 | Marshall | Mississippi | 28093 | 2856 | 63 |
873218 | 873218 | 2020-12-28 | Marshall | Mississippi | 28093 | 2840 | 63 |
869973 | 869973 | 2020-12-27 | Marshall | Mississippi | 28093 | 2823 | 63 |
866728 | 866728 | 2020-12-26 | Marshall | Mississippi | 28093 | 2813 | 63 |
863483 | 863483 | 2020-12-25 | Marshall | Mississippi | 28093 | 2797 | 63 |
860238 | 860238 | 2020-12-24 | Marshall | Mississippi | 28093 | 2778 | 62 |
856993 | 856993 | 2020-12-23 | Marshall | Mississippi | 28093 | 2743 | 61 |
853748 | 853748 | 2020-12-22 | Marshall | Mississippi | 28093 | 2699 | 60 |
850503 | 850503 | 2020-12-21 | Marshall | Mississippi | 28093 | 2680 | 59 |
847258 | 847258 | 2020-12-20 | Marshall | Mississippi | 28093 | 2656 | 59 |
844012 | 844012 | 2020-12-19 | Marshall | Mississippi | 28093 | 2624 | 59 |
840767 | 840767 | 2020-12-18 | Marshall | Mississippi | 28093 | 2610 | 59 |
837522 | 837522 | 2020-12-17 | Marshall | Mississippi | 28093 | 2587 | 58 |
834276 | 834276 | 2020-12-16 | Marshall | Mississippi | 28093 | 2567 | 58 |
831029 | 831029 | 2020-12-15 | Marshall | Mississippi | 28093 | 2543 | 57 |
827783 | 827783 | 2020-12-14 | Marshall | Mississippi | 28093 | 2517 | 56 |
824536 | 824536 | 2020-12-13 | Marshall | Mississippi | 28093 | 2492 | 56 |
821290 | 821290 | 2020-12-12 | Marshall | Mississippi | 28093 | 2469 | 56 |
818044 | 818044 | 2020-12-11 | Marshall | Mississippi | 28093 | 2456 | 56 |
814798 | 814798 | 2020-12-10 | Marshall | Mississippi | 28093 | 2423 | 54 |
811553 | 811553 | 2020-12-09 | Marshall | Mississippi | 28093 | 2410 | 53 |
808308 | 808308 | 2020-12-08 | Marshall | Mississippi | 28093 | 2378 | 53 |
805063 | 805063 | 2020-12-07 | Marshall | Mississippi | 28093 | 2364 | 51 |
801818 | 801818 | 2020-12-06 | Marshall | Mississippi | 28093 | 2345 | 51 |
798573 | 798573 | 2020-12-05 | Marshall | Mississippi | 28093 | 2314 | 51 |
795328 | 795328 | 2020-12-04 | Marshall | Mississippi | 28093 | 2294 | 51 |
792083 | 792083 | 2020-12-03 | Marshall | Mississippi | 28093 | 2271 | 51 |
788838 | 788838 | 2020-12-02 | Marshall | Mississippi | 28093 | 2250 | 51 |
785593 | 785593 | 2020-12-01 | Marshall | Mississippi | 28093 | 2228 | 51 |
782349 | 782349 | 2020-11-30 | Marshall | Mississippi | 28093 | 2212 | 50 |
779103 | 779103 | 2020-11-29 | Marshall | Mississippi | 28093 | 2194 | 50 |
775858 | 775858 | 2020-11-28 | Marshall | Mississippi | 28093 | 2172 | 50 |
772613 | 772613 | 2020-11-27 | Marshall | Mississippi | 28093 | 2138 | 50 |
769368 | 769368 | 2020-11-26 | Marshall | Mississippi | 28093 | 2119 | 50 |
766122 | 766122 | 2020-11-25 | Marshall | Mississippi | 28093 | 2096 | 50 |
762877 | 762877 | 2020-11-24 | Marshall | Mississippi | 28093 | 2083 | 50 |
759632 | 759632 | 2020-11-23 | Marshall | Mississippi | 28093 | 2072 | 47 |
756385 | 756385 | 2020-11-22 | Marshall | Mississippi | 28093 | 2065 | 47 |
753139 | 753139 | 2020-11-21 | Marshall | Mississippi | 28093 | 2057 | 43 |
749893 | 749893 | 2020-11-20 | Marshall | Mississippi | 28093 | 2029 | 43 |
746647 | 746647 | 2020-11-19 | Marshall | Mississippi | 28093 | 2004 | 41 |
743400 | 743400 | 2020-11-18 | Marshall | Mississippi | 28093 | 1974 | 41 |
740153 | 740153 | 2020-11-17 | Marshall | Mississippi | 28093 | 1935 | 41 |
736909 | 736909 | 2020-11-16 | Marshall | Mississippi | 28093 | 1913 | 39 |
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);