ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Marshall" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053553 | 1053553 | 2021-02-22 | Marshall | Alabama | 1095 | 11179 | 199 |
1050306 | 1050306 | 2021-02-21 | Marshall | Alabama | 1095 | 11174 | 199 |
1047059 | 1047059 | 2021-02-20 | Marshall | Alabama | 1095 | 11165 | 199 |
1043814 | 1043814 | 2021-02-19 | Marshall | Alabama | 1095 | 11147 | 198 |
1040569 | 1040569 | 2021-02-18 | Marshall | Alabama | 1095 | 11135 | 195 |
1037324 | 1037324 | 2021-02-17 | Marshall | Alabama | 1095 | 11121 | 195 |
1034079 | 1034079 | 2021-02-16 | Marshall | Alabama | 1095 | 11118 | 194 |
1030833 | 1030833 | 2021-02-15 | Marshall | Alabama | 1095 | 11105 | 194 |
1027586 | 1027586 | 2021-02-14 | Marshall | Alabama | 1095 | 11102 | 194 |
1024341 | 1024341 | 2021-02-13 | Marshall | Alabama | 1095 | 11090 | 194 |
1021096 | 1021096 | 2021-02-12 | Marshall | Alabama | 1095 | 11068 | 194 |
1017851 | 1017851 | 2021-02-11 | Marshall | Alabama | 1095 | 11057 | 191 |
1014606 | 1014606 | 2021-02-10 | Marshall | Alabama | 1095 | 11032 | 186 |
1011361 | 1011361 | 2021-02-09 | Marshall | Alabama | 1095 | 11014 | 178 |
1008115 | 1008115 | 2021-02-08 | Marshall | Alabama | 1095 | 10989 | 178 |
1004869 | 1004869 | 2021-02-07 | Marshall | Alabama | 1095 | 10986 | 178 |
1001623 | 1001623 | 2021-02-06 | Marshall | Alabama | 1095 | 10959 | 178 |
998377 | 998377 | 2021-02-05 | Marshall | Alabama | 1095 | 10928 | 177 |
995131 | 995131 | 2021-02-04 | Marshall | Alabama | 1095 | 10905 | 176 |
991885 | 991885 | 2021-02-03 | Marshall | Alabama | 1095 | 10860 | 172 |
988639 | 988639 | 2021-02-02 | Marshall | Alabama | 1095 | 10827 | 160 |
985392 | 985392 | 2021-02-01 | Marshall | Alabama | 1095 | 10789 | 152 |
982145 | 982145 | 2021-01-31 | Marshall | Alabama | 1095 | 10780 | 152 |
978899 | 978899 | 2021-01-30 | Marshall | Alabama | 1095 | 10714 | 144 |
975654 | 975654 | 2021-01-29 | Marshall | Alabama | 1095 | 10714 | 144 |
972409 | 972409 | 2021-01-28 | Marshall | Alabama | 1095 | 10661 | 140 |
969164 | 969164 | 2021-01-27 | Marshall | Alabama | 1095 | 10543 | 133 |
965920 | 965920 | 2021-01-26 | Marshall | Alabama | 1095 | 10513 | 126 |
962675 | 962675 | 2021-01-25 | Marshall | Alabama | 1095 | 10487 | 123 |
959430 | 959430 | 2021-01-24 | Marshall | Alabama | 1095 | 10471 | 123 |
956184 | 956184 | 2021-01-23 | Marshall | Alabama | 1095 | 10420 | 123 |
952939 | 952939 | 2021-01-22 | Marshall | Alabama | 1095 | 10357 | 123 |
949694 | 949694 | 2021-01-21 | Marshall | Alabama | 1095 | 10322 | 119 |
946448 | 946448 | 2021-01-20 | Marshall | Alabama | 1095 | 10290 | 113 |
943201 | 943201 | 2021-01-19 | Marshall | Alabama | 1095 | 10236 | 107 |
939956 | 939956 | 2021-01-18 | Marshall | Alabama | 1095 | 10199 | 107 |
936711 | 936711 | 2021-01-17 | Marshall | Alabama | 1095 | 10191 | 107 |
933466 | 933466 | 2021-01-16 | Marshall | Alabama | 1095 | 10158 | 107 |
930221 | 930221 | 2021-01-15 | Marshall | Alabama | 1095 | 10108 | 107 |
926976 | 926976 | 2021-01-14 | Marshall | Alabama | 1095 | 10048 | 106 |
923730 | 923730 | 2021-01-13 | Marshall | Alabama | 1095 | 9988 | 106 |
920485 | 920485 | 2021-01-12 | Marshall | Alabama | 1095 | 9907 | 98 |
917240 | 917240 | 2021-01-11 | Marshall | Alabama | 1095 | 9863 | 92 |
913995 | 913995 | 2021-01-10 | Marshall | Alabama | 1095 | 9854 | 92 |
910750 | 910750 | 2021-01-09 | Marshall | Alabama | 1095 | 9819 | 92 |
907505 | 907505 | 2021-01-08 | Marshall | Alabama | 1095 | 9710 | 92 |
904259 | 904259 | 2021-01-07 | Marshall | Alabama | 1095 | 9616 | 92 |
901014 | 901014 | 2021-01-06 | Marshall | Alabama | 1095 | 9497 | 91 |
897769 | 897769 | 2021-01-05 | Marshall | Alabama | 1095 | 9401 | 86 |
894523 | 894523 | 2021-01-04 | Marshall | Alabama | 1095 | 9340 | 86 |
891277 | 891277 | 2021-01-03 | Marshall | Alabama | 1095 | 9314 | 86 |
888030 | 888030 | 2021-01-02 | Marshall | Alabama | 1095 | 9293 | 86 |
884785 | 884785 | 2021-01-01 | Marshall | Alabama | 1095 | 9271 | 86 |
881540 | 881540 | 2020-12-31 | Marshall | Alabama | 1095 | 9189 | 86 |
878295 | 878295 | 2020-12-30 | Marshall | Alabama | 1095 | 8996 | 84 |
875050 | 875050 | 2020-12-29 | Marshall | Alabama | 1095 | 8915 | 84 |
871805 | 871805 | 2020-12-28 | Marshall | Alabama | 1095 | 8865 | 84 |
868560 | 868560 | 2020-12-27 | Marshall | Alabama | 1095 | 8854 | 84 |
865315 | 865315 | 2020-12-26 | Marshall | Alabama | 1095 | 8831 | 84 |
862070 | 862070 | 2020-12-25 | Marshall | Alabama | 1095 | 8820 | 84 |
858825 | 858825 | 2020-12-24 | Marshall | Alabama | 1095 | 8766 | 84 |
855580 | 855580 | 2020-12-23 | Marshall | Alabama | 1095 | 8653 | 80 |
852335 | 852335 | 2020-12-22 | Marshall | Alabama | 1095 | 8509 | 71 |
849090 | 849090 | 2020-12-21 | Marshall | Alabama | 1095 | 8389 | 71 |
845845 | 845845 | 2020-12-20 | Marshall | Alabama | 1095 | 8380 | 71 |
842599 | 842599 | 2020-12-19 | Marshall | Alabama | 1095 | 8324 | 71 |
839354 | 839354 | 2020-12-18 | Marshall | Alabama | 1095 | 8233 | 69 |
836109 | 836109 | 2020-12-17 | Marshall | Alabama | 1095 | 8141 | 69 |
832863 | 832863 | 2020-12-16 | Marshall | Alabama | 1095 | 8036 | 66 |
829616 | 829616 | 2020-12-15 | Marshall | Alabama | 1095 | 7890 | 64 |
826370 | 826370 | 2020-12-14 | Marshall | Alabama | 1095 | 7820 | 65 |
823123 | 823123 | 2020-12-13 | Marshall | Alabama | 1095 | 7801 | 65 |
819877 | 819877 | 2020-12-12 | Marshall | Alabama | 1095 | 7736 | 65 |
816631 | 816631 | 2020-12-11 | Marshall | Alabama | 1095 | 7650 | 64 |
813385 | 813385 | 2020-12-10 | Marshall | Alabama | 1095 | 7551 | 64 |
810141 | 810141 | 2020-12-09 | Marshall | Alabama | 1095 | 7435 | 59 |
806896 | 806896 | 2020-12-08 | Marshall | Alabama | 1095 | 7319 | 59 |
803651 | 803651 | 2020-12-07 | Marshall | Alabama | 1095 | 7176 | 58 |
800406 | 800406 | 2020-12-06 | Marshall | Alabama | 1095 | 7133 | 58 |
797161 | 797161 | 2020-12-05 | Marshall | Alabama | 1095 | 7063 | 58 |
793916 | 793916 | 2020-12-04 | Marshall | Alabama | 1095 | 6953 | 58 |
790671 | 790671 | 2020-12-03 | Marshall | Alabama | 1095 | 6750 | 58 |
787426 | 787426 | 2020-12-02 | Marshall | Alabama | 1095 | 6657 | 57 |
784182 | 784182 | 2020-12-01 | Marshall | Alabama | 1095 | 6473 | 57 |
780937 | 780937 | 2020-11-30 | Marshall | Alabama | 1095 | 6353 | 55 |
777691 | 777691 | 2020-11-29 | Marshall | Alabama | 1095 | 6309 | 55 |
774446 | 774446 | 2020-11-28 | Marshall | Alabama | 1095 | 6272 | 55 |
771201 | 771201 | 2020-11-27 | Marshall | Alabama | 1095 | 6213 | 55 |
767955 | 767955 | 2020-11-26 | Marshall | Alabama | 1095 | 6182 | 55 |
764710 | 764710 | 2020-11-25 | Marshall | Alabama | 1095 | 6079 | 54 |
761465 | 761465 | 2020-11-24 | Marshall | Alabama | 1095 | 5961 | 53 |
758220 | 758220 | 2020-11-23 | Marshall | Alabama | 1095 | 5819 | 53 |
754973 | 754973 | 2020-11-22 | Marshall | Alabama | 1095 | 5794 | 53 |
751727 | 751727 | 2020-11-21 | Marshall | Alabama | 1095 | 5710 | 53 |
748481 | 748481 | 2020-11-20 | Marshall | Alabama | 1095 | 5660 | 53 |
745235 | 745235 | 2020-11-19 | Marshall | Alabama | 1095 | 5575 | 54 |
741988 | 741988 | 2020-11-18 | Marshall | Alabama | 1095 | 5516 | 53 |
738741 | 738741 | 2020-11-17 | Marshall | Alabama | 1095 | 5384 | 53 |
735497 | 735497 | 2020-11-16 | Marshall | Alabama | 1095 | 5355 | 53 |
732251 | 732251 | 2020-11-15 | Marshall | Alabama | 1095 | 5330 | 53 |
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);