ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lee" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1050299 | 1050299 | 2021-02-21 | Lee | Alabama | 1081 | 14798 | 146 |
1047052 | 1047052 | 2021-02-20 | Lee | Alabama | 1081 | 14779 | 146 |
1043807 | 1043807 | 2021-02-19 | Lee | Alabama | 1081 | 14766 | 146 |
1040562 | 1040562 | 2021-02-18 | Lee | Alabama | 1081 | 14729 | 141 |
1037317 | 1037317 | 2021-02-17 | Lee | Alabama | 1081 | 14684 | 141 |
1034072 | 1034072 | 2021-02-16 | Lee | Alabama | 1081 | 14641 | 137 |
1030826 | 1030826 | 2021-02-15 | Lee | Alabama | 1081 | 14622 | 137 |
1027579 | 1027579 | 2021-02-14 | Lee | Alabama | 1081 | 14608 | 137 |
1024334 | 1024334 | 2021-02-13 | Lee | Alabama | 1081 | 14563 | 137 |
1021089 | 1021089 | 2021-02-12 | Lee | Alabama | 1081 | 14524 | 137 |
1017844 | 1017844 | 2021-02-11 | Lee | Alabama | 1081 | 14491 | 137 |
1014599 | 1014599 | 2021-02-10 | Lee | Alabama | 1081 | 14443 | 136 |
1011354 | 1011354 | 2021-02-09 | Lee | Alabama | 1081 | 14391 | 132 |
1008108 | 1008108 | 2021-02-08 | Lee | Alabama | 1081 | 14361 | 132 |
1004862 | 1004862 | 2021-02-07 | Lee | Alabama | 1081 | 14337 | 132 |
1001616 | 1001616 | 2021-02-06 | Lee | Alabama | 1081 | 14277 | 132 |
998370 | 998370 | 2021-02-05 | Lee | Alabama | 1081 | 14197 | 132 |
995124 | 995124 | 2021-02-04 | Lee | Alabama | 1081 | 14149 | 131 |
991878 | 991878 | 2021-02-03 | Lee | Alabama | 1081 | 14048 | 128 |
988632 | 988632 | 2021-02-02 | Lee | Alabama | 1081 | 13958 | 128 |
985385 | 985385 | 2021-02-01 | Lee | Alabama | 1081 | 13878 | 128 |
982138 | 982138 | 2021-01-31 | Lee | Alabama | 1081 | 13829 | 128 |
978892 | 978892 | 2021-01-30 | Lee | Alabama | 1081 | 13679 | 124 |
975647 | 975647 | 2021-01-29 | Lee | Alabama | 1081 | 13679 | 124 |
972402 | 972402 | 2021-01-28 | Lee | Alabama | 1081 | 13602 | 113 |
969157 | 969157 | 2021-01-27 | Lee | Alabama | 1081 | 13482 | 112 |
965913 | 965913 | 2021-01-26 | Lee | Alabama | 1081 | 13378 | 109 |
962668 | 962668 | 2021-01-25 | Lee | Alabama | 1081 | 13261 | 107 |
959423 | 959423 | 2021-01-24 | Lee | Alabama | 1081 | 13205 | 107 |
956177 | 956177 | 2021-01-23 | Lee | Alabama | 1081 | 13137 | 107 |
952932 | 952932 | 2021-01-22 | Lee | Alabama | 1081 | 13036 | 105 |
949687 | 949687 | 2021-01-21 | Lee | Alabama | 1081 | 12901 | 102 |
946441 | 946441 | 2021-01-20 | Lee | Alabama | 1081 | 12749 | 102 |
943194 | 943194 | 2021-01-19 | Lee | Alabama | 1081 | 12603 | 101 |
939949 | 939949 | 2021-01-18 | Lee | Alabama | 1081 | 12515 | 101 |
936704 | 936704 | 2021-01-17 | Lee | Alabama | 1081 | 12465 | 101 |
933459 | 933459 | 2021-01-16 | Lee | Alabama | 1081 | 12393 | 101 |
930214 | 930214 | 2021-01-15 | Lee | Alabama | 1081 | 12261 | 101 |
926969 | 926969 | 2021-01-14 | Lee | Alabama | 1081 | 12120 | 97 |
923723 | 923723 | 2021-01-13 | Lee | Alabama | 1081 | 11983 | 97 |
920478 | 920478 | 2021-01-12 | Lee | Alabama | 1081 | 11812 | 87 |
917233 | 917233 | 2021-01-11 | Lee | Alabama | 1081 | 11626 | 79 |
913988 | 913988 | 2021-01-10 | Lee | Alabama | 1081 | 11565 | 79 |
910743 | 910743 | 2021-01-09 | Lee | Alabama | 1081 | 11498 | 79 |
907498 | 907498 | 2021-01-08 | Lee | Alabama | 1081 | 11355 | 79 |
904252 | 904252 | 2021-01-07 | Lee | Alabama | 1081 | 11179 | 79 |
901007 | 901007 | 2021-01-06 | Lee | Alabama | 1081 | 10964 | 75 |
897762 | 897762 | 2021-01-05 | Lee | Alabama | 1081 | 10765 | 75 |
894516 | 894516 | 2021-01-04 | Lee | Alabama | 1081 | 10656 | 75 |
891270 | 891270 | 2021-01-03 | Lee | Alabama | 1081 | 10560 | 75 |
888023 | 888023 | 2021-01-02 | Lee | Alabama | 1081 | 10508 | 75 |
884778 | 884778 | 2021-01-01 | Lee | Alabama | 1081 | 10450 | 75 |
881533 | 881533 | 2020-12-31 | Lee | Alabama | 1081 | 10320 | 75 |
878288 | 878288 | 2020-12-30 | Lee | Alabama | 1081 | 10159 | 75 |
875043 | 875043 | 2020-12-29 | Lee | Alabama | 1081 | 10047 | 74 |
871798 | 871798 | 2020-12-28 | Lee | Alabama | 1081 | 9928 | 74 |
868553 | 868553 | 2020-12-27 | Lee | Alabama | 1081 | 9856 | 74 |
865308 | 865308 | 2020-12-26 | Lee | Alabama | 1081 | 9800 | 74 |
862063 | 862063 | 2020-12-25 | Lee | Alabama | 1081 | 9779 | 74 |
858818 | 858818 | 2020-12-24 | Lee | Alabama | 1081 | 9715 | 74 |
855573 | 855573 | 2020-12-23 | Lee | Alabama | 1081 | 9609 | 74 |
852328 | 852328 | 2020-12-22 | Lee | Alabama | 1081 | 9490 | 73 |
849083 | 849083 | 2020-12-21 | Lee | Alabama | 1081 | 9372 | 73 |
845838 | 845838 | 2020-12-20 | Lee | Alabama | 1081 | 9337 | 73 |
842592 | 842592 | 2020-12-19 | Lee | Alabama | 1081 | 9283 | 73 |
839347 | 839347 | 2020-12-18 | Lee | Alabama | 1081 | 9188 | 73 |
836102 | 836102 | 2020-12-17 | Lee | Alabama | 1081 | 9055 | 73 |
832856 | 832856 | 2020-12-16 | Lee | Alabama | 1081 | 8966 | 73 |
829609 | 829609 | 2020-12-15 | Lee | Alabama | 1081 | 8857 | 73 |
826363 | 826363 | 2020-12-14 | Lee | Alabama | 1081 | 8788 | 73 |
823116 | 823116 | 2020-12-13 | Lee | Alabama | 1081 | 8744 | 73 |
819870 | 819870 | 2020-12-12 | Lee | Alabama | 1081 | 8675 | 73 |
816624 | 816624 | 2020-12-11 | Lee | Alabama | 1081 | 8595 | 74 |
813378 | 813378 | 2020-12-10 | Lee | Alabama | 1081 | 8499 | 72 |
810134 | 810134 | 2020-12-09 | Lee | Alabama | 1081 | 8386 | 72 |
806889 | 806889 | 2020-12-08 | Lee | Alabama | 1081 | 8298 | 71 |
803644 | 803644 | 2020-12-07 | Lee | Alabama | 1081 | 8218 | 69 |
800399 | 800399 | 2020-12-06 | Lee | Alabama | 1081 | 8171 | 69 |
797154 | 797154 | 2020-12-05 | Lee | Alabama | 1081 | 8131 | 68 |
793909 | 793909 | 2020-12-04 | Lee | Alabama | 1081 | 8071 | 67 |
790664 | 790664 | 2020-12-03 | Lee | Alabama | 1081 | 8015 | 66 |
787419 | 787419 | 2020-12-02 | Lee | Alabama | 1081 | 7925 | 66 |
784175 | 784175 | 2020-12-01 | Lee | Alabama | 1081 | 7872 | 66 |
780930 | 780930 | 2020-11-30 | Lee | Alabama | 1081 | 7814 | 66 |
777684 | 777684 | 2020-11-29 | Lee | Alabama | 1081 | 7785 | 66 |
774439 | 774439 | 2020-11-28 | Lee | Alabama | 1081 | 7757 | 66 |
771194 | 771194 | 2020-11-27 | Lee | Alabama | 1081 | 7735 | 66 |
767948 | 767948 | 2020-11-26 | Lee | Alabama | 1081 | 7718 | 66 |
764703 | 764703 | 2020-11-25 | Lee | Alabama | 1081 | 7644 | 66 |
761458 | 761458 | 2020-11-24 | Lee | Alabama | 1081 | 7597 | 65 |
758213 | 758213 | 2020-11-23 | Lee | Alabama | 1081 | 7539 | 64 |
754966 | 754966 | 2020-11-22 | Lee | Alabama | 1081 | 7504 | 64 |
751720 | 751720 | 2020-11-21 | Lee | Alabama | 1081 | 7478 | 64 |
748474 | 748474 | 2020-11-20 | Lee | Alabama | 1081 | 7421 | 64 |
745228 | 745228 | 2020-11-19 | Lee | Alabama | 1081 | 7363 | 64 |
741981 | 741981 | 2020-11-18 | Lee | Alabama | 1081 | 7331 | 64 |
738734 | 738734 | 2020-11-17 | Lee | Alabama | 1081 | 7278 | 65 |
735490 | 735490 | 2020-11-16 | Lee | Alabama | 1081 | 7240 | 65 |
732244 | 732244 | 2020-11-15 | Lee | Alabama | 1081 | 7212 | 65 |
728999 | 728999 | 2020-11-14 | Lee | Alabama | 1081 | 7181 | 65 |
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);