ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Lamar" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050296 | 1050296 | 2021-02-21 | Lamar | Alabama | 1075 | 1294 | 32 |
1047049 | 1047049 | 2021-02-20 | Lamar | Alabama | 1075 | 1292 | 32 |
1043804 | 1043804 | 2021-02-19 | Lamar | Alabama | 1075 | 1291 | 32 |
1040559 | 1040559 | 2021-02-18 | Lamar | Alabama | 1075 | 1286 | 32 |
1037314 | 1037314 | 2021-02-17 | Lamar | Alabama | 1075 | 1282 | 32 |
1034069 | 1034069 | 2021-02-16 | Lamar | Alabama | 1075 | 1283 | 32 |
1030823 | 1030823 | 2021-02-15 | Lamar | Alabama | 1075 | 1281 | 32 |
1027576 | 1027576 | 2021-02-14 | Lamar | Alabama | 1075 | 1281 | 32 |
1024331 | 1024331 | 2021-02-13 | Lamar | Alabama | 1075 | 1277 | 32 |
1021086 | 1021086 | 2021-02-12 | Lamar | Alabama | 1075 | 1275 | 32 |
1017841 | 1017841 | 2021-02-11 | Lamar | Alabama | 1075 | 1275 | 32 |
1014596 | 1014596 | 2021-02-10 | Lamar | Alabama | 1075 | 1275 | 32 |
1011351 | 1011351 | 2021-02-09 | Lamar | Alabama | 1075 | 1275 | 31 |
1008105 | 1008105 | 2021-02-08 | Lamar | Alabama | 1075 | 1272 | 30 |
1004859 | 1004859 | 2021-02-07 | Lamar | Alabama | 1075 | 1269 | 30 |
1001613 | 1001613 | 2021-02-06 | Lamar | Alabama | 1075 | 1267 | 30 |
998367 | 998367 | 2021-02-05 | Lamar | Alabama | 1075 | 1264 | 30 |
995121 | 995121 | 2021-02-04 | Lamar | Alabama | 1075 | 1260 | 30 |
991875 | 991875 | 2021-02-03 | Lamar | Alabama | 1075 | 1253 | 29 |
988629 | 988629 | 2021-02-02 | Lamar | Alabama | 1075 | 1251 | 29 |
985382 | 985382 | 2021-02-01 | Lamar | Alabama | 1075 | 1249 | 28 |
982135 | 982135 | 2021-01-31 | Lamar | Alabama | 1075 | 1248 | 28 |
978889 | 978889 | 2021-01-30 | Lamar | Alabama | 1075 | 1235 | 27 |
975644 | 975644 | 2021-01-29 | Lamar | Alabama | 1075 | 1235 | 27 |
972399 | 972399 | 2021-01-28 | Lamar | Alabama | 1075 | 1230 | 24 |
969154 | 969154 | 2021-01-27 | Lamar | Alabama | 1075 | 1220 | 24 |
965910 | 965910 | 2021-01-26 | Lamar | Alabama | 1075 | 1213 | 24 |
962665 | 962665 | 2021-01-25 | Lamar | Alabama | 1075 | 1206 | 22 |
959420 | 959420 | 2021-01-24 | Lamar | Alabama | 1075 | 1202 | 22 |
956174 | 956174 | 2021-01-23 | Lamar | Alabama | 1075 | 1199 | 22 |
952929 | 952929 | 2021-01-22 | Lamar | Alabama | 1075 | 1197 | 21 |
949684 | 949684 | 2021-01-21 | Lamar | Alabama | 1075 | 1196 | 21 |
946438 | 946438 | 2021-01-20 | Lamar | Alabama | 1075 | 1190 | 21 |
943191 | 943191 | 2021-01-19 | Lamar | Alabama | 1075 | 1184 | 19 |
939946 | 939946 | 2021-01-18 | Lamar | Alabama | 1075 | 1182 | 19 |
936701 | 936701 | 2021-01-17 | Lamar | Alabama | 1075 | 1180 | 19 |
933456 | 933456 | 2021-01-16 | Lamar | Alabama | 1075 | 1175 | 19 |
930211 | 930211 | 2021-01-15 | Lamar | Alabama | 1075 | 1166 | 19 |
926966 | 926966 | 2021-01-14 | Lamar | Alabama | 1075 | 1168 | 19 |
923720 | 923720 | 2021-01-13 | Lamar | Alabama | 1075 | 1157 | 19 |
920475 | 920475 | 2021-01-12 | Lamar | Alabama | 1075 | 1153 | 17 |
917230 | 917230 | 2021-01-11 | Lamar | Alabama | 1075 | 1146 | 16 |
913985 | 913985 | 2021-01-10 | Lamar | Alabama | 1075 | 1137 | 16 |
910740 | 910740 | 2021-01-09 | Lamar | Alabama | 1075 | 1132 | 16 |
907495 | 907495 | 2021-01-08 | Lamar | Alabama | 1075 | 1124 | 16 |
904249 | 904249 | 2021-01-07 | Lamar | Alabama | 1075 | 1114 | 16 |
901004 | 901004 | 2021-01-06 | Lamar | Alabama | 1075 | 1098 | 16 |
897759 | 897759 | 2021-01-05 | Lamar | Alabama | 1075 | 1083 | 15 |
894513 | 894513 | 2021-01-04 | Lamar | Alabama | 1075 | 1077 | 15 |
891267 | 891267 | 2021-01-03 | Lamar | Alabama | 1075 | 1074 | 15 |
888020 | 888020 | 2021-01-02 | Lamar | Alabama | 1075 | 1069 | 15 |
884775 | 884775 | 2021-01-01 | Lamar | Alabama | 1075 | 1065 | 15 |
881530 | 881530 | 2020-12-31 | Lamar | Alabama | 1075 | 1056 | 15 |
878285 | 878285 | 2020-12-30 | Lamar | Alabama | 1075 | 1037 | 15 |
875040 | 875040 | 2020-12-29 | Lamar | Alabama | 1075 | 1025 | 15 |
871795 | 871795 | 2020-12-28 | Lamar | Alabama | 1075 | 1017 | 15 |
868550 | 868550 | 2020-12-27 | Lamar | Alabama | 1075 | 1012 | 15 |
865305 | 865305 | 2020-12-26 | Lamar | Alabama | 1075 | 1009 | 15 |
862060 | 862060 | 2020-12-25 | Lamar | Alabama | 1075 | 1007 | 15 |
858815 | 858815 | 2020-12-24 | Lamar | Alabama | 1075 | 997 | 15 |
855570 | 855570 | 2020-12-23 | Lamar | Alabama | 1075 | 986 | 15 |
852325 | 852325 | 2020-12-22 | Lamar | Alabama | 1075 | 979 | 12 |
849080 | 849080 | 2020-12-21 | Lamar | Alabama | 1075 | 966 | 12 |
845835 | 845835 | 2020-12-20 | Lamar | Alabama | 1075 | 946 | 12 |
842589 | 842589 | 2020-12-19 | Lamar | Alabama | 1075 | 941 | 12 |
839344 | 839344 | 2020-12-18 | Lamar | Alabama | 1075 | 925 | 12 |
836099 | 836099 | 2020-12-17 | Lamar | Alabama | 1075 | 912 | 11 |
832853 | 832853 | 2020-12-16 | Lamar | Alabama | 1075 | 889 | 10 |
829606 | 829606 | 2020-12-15 | Lamar | Alabama | 1075 | 870 | 9 |
826360 | 826360 | 2020-12-14 | Lamar | Alabama | 1075 | 858 | 9 |
823113 | 823113 | 2020-12-13 | Lamar | Alabama | 1075 | 855 | 9 |
819867 | 819867 | 2020-12-12 | Lamar | Alabama | 1075 | 841 | 9 |
816621 | 816621 | 2020-12-11 | Lamar | Alabama | 1075 | 830 | 9 |
813375 | 813375 | 2020-12-10 | Lamar | Alabama | 1075 | 806 | 8 |
810131 | 810131 | 2020-12-09 | Lamar | Alabama | 1075 | 786 | 8 |
806886 | 806886 | 2020-12-08 | Lamar | Alabama | 1075 | 769 | 8 |
803641 | 803641 | 2020-12-07 | Lamar | Alabama | 1075 | 759 | 8 |
800396 | 800396 | 2020-12-06 | Lamar | Alabama | 1075 | 755 | 8 |
797151 | 797151 | 2020-12-05 | Lamar | Alabama | 1075 | 744 | 8 |
793906 | 793906 | 2020-12-04 | Lamar | Alabama | 1075 | 734 | 8 |
790661 | 790661 | 2020-12-03 | Lamar | Alabama | 1075 | 725 | 8 |
787416 | 787416 | 2020-12-02 | Lamar | Alabama | 1075 | 713 | 8 |
784172 | 784172 | 2020-12-01 | Lamar | Alabama | 1075 | 701 | 8 |
780927 | 780927 | 2020-11-30 | Lamar | Alabama | 1075 | 689 | 8 |
777681 | 777681 | 2020-11-29 | Lamar | Alabama | 1075 | 683 | 8 |
774436 | 774436 | 2020-11-28 | Lamar | Alabama | 1075 | 679 | 8 |
771191 | 771191 | 2020-11-27 | Lamar | Alabama | 1075 | 671 | 8 |
767945 | 767945 | 2020-11-26 | Lamar | Alabama | 1075 | 667 | 8 |
764700 | 764700 | 2020-11-25 | Lamar | Alabama | 1075 | 650 | 8 |
761455 | 761455 | 2020-11-24 | Lamar | Alabama | 1075 | 633 | 7 |
758210 | 758210 | 2020-11-23 | Lamar | Alabama | 1075 | 626 | 7 |
754963 | 754963 | 2020-11-22 | Lamar | Alabama | 1075 | 622 | 7 |
751717 | 751717 | 2020-11-21 | Lamar | Alabama | 1075 | 609 | 7 |
748471 | 748471 | 2020-11-20 | Lamar | Alabama | 1075 | 601 | 7 |
745225 | 745225 | 2020-11-19 | Lamar | Alabama | 1075 | 600 | 7 |
741978 | 741978 | 2020-11-18 | Lamar | Alabama | 1075 | 596 | 7 |
738731 | 738731 | 2020-11-17 | Lamar | Alabama | 1075 | 588 | 7 |
735487 | 735487 | 2020-11-16 | Lamar | Alabama | 1075 | 584 | 7 |
732241 | 732241 | 2020-11-15 | Lamar | Alabama | 1075 | 584 | 7 |
728996 | 728996 | 2020-11-14 | Lamar | Alabama | 1075 | 581 | 7 |
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);