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 |
---|---|---|---|---|---|---|---|
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 |
725756 | 725756 | 2020-11-13 | Lee | Alabama | 1081 | 7122 | 65 |
722513 | 722513 | 2020-11-12 | Lee | Alabama | 1081 | 7043 | 65 |
719270 | 719270 | 2020-11-11 | Lee | Alabama | 1081 | 6994 | 65 |
716027 | 716027 | 2020-11-10 | Lee | Alabama | 1081 | 6952 | 65 |
712783 | 712783 | 2020-11-09 | Lee | Alabama | 1081 | 6926 | 65 |
709539 | 709539 | 2020-11-08 | Lee | Alabama | 1081 | 6903 | 65 |
706295 | 706295 | 2020-11-07 | Lee | Alabama | 1081 | 6878 | 65 |
703052 | 703052 | 2020-11-06 | Lee | Alabama | 1081 | 6851 | 65 |
699809 | 699809 | 2020-11-05 | Lee | Alabama | 1081 | 6812 | 65 |
696565 | 696565 | 2020-11-04 | Lee | Alabama | 1081 | 6776 | 65 |
693323 | 693323 | 2020-11-03 | Lee | Alabama | 1081 | 6749 | 65 |
690080 | 690080 | 2020-11-02 | Lee | Alabama | 1081 | 6736 | 65 |
686835 | 686835 | 2020-11-01 | Lee | Alabama | 1081 | 6715 | 65 |
683591 | 683591 | 2020-10-31 | Lee | Alabama | 1081 | 6702 | 65 |
680348 | 680348 | 2020-10-30 | Lee | Alabama | 1081 | 6669 | 65 |
677105 | 677105 | 2020-10-29 | Lee | Alabama | 1081 | 6649 | 65 |
673862 | 673862 | 2020-10-28 | Lee | Alabama | 1081 | 6624 | 65 |
670620 | 670620 | 2020-10-27 | Lee | Alabama | 1081 | 6571 | 65 |
667377 | 667377 | 2020-10-26 | Lee | Alabama | 1081 | 6550 | 65 |
664132 | 664132 | 2020-10-25 | Lee | Alabama | 1081 | 6546 | 65 |
660888 | 660888 | 2020-10-24 | Lee | Alabama | 1081 | 6534 | 65 |
657644 | 657644 | 2020-10-23 | Lee | Alabama | 1081 | 6517 | 65 |
654399 | 654399 | 2020-10-22 | Lee | Alabama | 1081 | 6496 | 65 |
651154 | 651154 | 2020-10-21 | Lee | Alabama | 1081 | 6461 | 65 |
647910 | 647910 | 2020-10-20 | Lee | Alabama | 1081 | 6449 | 66 |
644665 | 644665 | 2020-10-19 | Lee | Alabama | 1081 | 6439 | 66 |
641417 | 641417 | 2020-10-18 | Lee | Alabama | 1081 | 6430 | 66 |
638170 | 638170 | 2020-10-17 | Lee | Alabama | 1081 | 6421 | 66 |
634925 | 634925 | 2020-10-16 | Lee | Alabama | 1081 | 6400 | 66 |
631680 | 631680 | 2020-10-15 | Lee | Alabama | 1081 | 6367 | 66 |
628436 | 628436 | 2020-10-14 | Lee | Alabama | 1081 | 6346 | 64 |
625193 | 625193 | 2020-10-13 | Lee | Alabama | 1081 | 6335 | 64 |
621950 | 621950 | 2020-10-12 | Lee | Alabama | 1081 | 6325 | 64 |
618707 | 618707 | 2020-10-11 | Lee | Alabama | 1081 | 6292 | 64 |
615465 | 615465 | 2020-10-10 | Lee | Alabama | 1081 | 6281 | 64 |
612224 | 612224 | 2020-10-09 | Lee | Alabama | 1081 | 6268 | 64 |
608982 | 608982 | 2020-10-08 | Lee | Alabama | 1081 | 6243 | 64 |
605739 | 605739 | 2020-10-07 | Lee | Alabama | 1081 | 6218 | 63 |
602497 | 602497 | 2020-10-06 | Lee | Alabama | 1081 | 6173 | 62 |
599254 | 599254 | 2020-10-05 | Lee | Alabama | 1081 | 6156 | 61 |
596011 | 596011 | 2020-10-04 | Lee | Alabama | 1081 | 6141 | 61 |
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);