ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
792 rows where county = "Tuscaloosa" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917255 | 917255 | 2021-01-11 | Tuscaloosa | Alabama | 1125 | 20211 | 267 |
914010 | 914010 | 2021-01-10 | Tuscaloosa | Alabama | 1125 | 20142 | 267 |
910765 | 910765 | 2021-01-09 | Tuscaloosa | Alabama | 1125 | 20062 | 267 |
907520 | 907520 | 2021-01-08 | Tuscaloosa | Alabama | 1125 | 19878 | 267 |
904274 | 904274 | 2021-01-07 | Tuscaloosa | Alabama | 1125 | 19730 | 222 |
901029 | 901029 | 2021-01-06 | Tuscaloosa | Alabama | 1125 | 19485 | 221 |
897784 | 897784 | 2021-01-05 | Tuscaloosa | Alabama | 1125 | 19288 | 218 |
894538 | 894538 | 2021-01-04 | Tuscaloosa | Alabama | 1125 | 19161 | 218 |
891292 | 891292 | 2021-01-03 | Tuscaloosa | Alabama | 1125 | 19043 | 218 |
888045 | 888045 | 2021-01-02 | Tuscaloosa | Alabama | 1125 | 18947 | 218 |
884800 | 884800 | 2021-01-01 | Tuscaloosa | Alabama | 1125 | 18745 | 218 |
881555 | 881555 | 2020-12-31 | Tuscaloosa | Alabama | 1125 | 18468 | 218 |
878310 | 878310 | 2020-12-30 | Tuscaloosa | Alabama | 1125 | 18341 | 216 |
875065 | 875065 | 2020-12-29 | Tuscaloosa | Alabama | 1125 | 18086 | 216 |
871820 | 871820 | 2020-12-28 | Tuscaloosa | Alabama | 1125 | 17859 | 216 |
868575 | 868575 | 2020-12-27 | Tuscaloosa | Alabama | 1125 | 17772 | 216 |
865330 | 865330 | 2020-12-26 | Tuscaloosa | Alabama | 1125 | 17684 | 216 |
862085 | 862085 | 2020-12-25 | Tuscaloosa | Alabama | 1125 | 17635 | 216 |
858840 | 858840 | 2020-12-24 | Tuscaloosa | Alabama | 1125 | 17473 | 216 |
855595 | 855595 | 2020-12-23 | Tuscaloosa | Alabama | 1125 | 17279 | 212 |
852350 | 852350 | 2020-12-22 | Tuscaloosa | Alabama | 1125 | 17063 | 209 |
849105 | 849105 | 2020-12-21 | Tuscaloosa | Alabama | 1125 | 16770 | 206 |
845860 | 845860 | 2020-12-20 | Tuscaloosa | Alabama | 1125 | 16663 | 206 |
842614 | 842614 | 2020-12-19 | Tuscaloosa | Alabama | 1125 | 16565 | 206 |
839369 | 839369 | 2020-12-18 | Tuscaloosa | Alabama | 1125 | 16378 | 205 |
836124 | 836124 | 2020-12-17 | Tuscaloosa | Alabama | 1125 | 16165 | 205 |
832878 | 832878 | 2020-12-16 | Tuscaloosa | Alabama | 1125 | 16012 | 205 |
829631 | 829631 | 2020-12-15 | Tuscaloosa | Alabama | 1125 | 15811 | 193 |
826385 | 826385 | 2020-12-14 | Tuscaloosa | Alabama | 1125 | 15595 | 193 |
823138 | 823138 | 2020-12-13 | Tuscaloosa | Alabama | 1125 | 15513 | 193 |
819892 | 819892 | 2020-12-12 | Tuscaloosa | Alabama | 1125 | 15373 | 193 |
816646 | 816646 | 2020-12-11 | Tuscaloosa | Alabama | 1125 | 15100 | 193 |
813400 | 813400 | 2020-12-10 | Tuscaloosa | Alabama | 1125 | 14931 | 191 |
810156 | 810156 | 2020-12-09 | Tuscaloosa | Alabama | 1125 | 14671 | 191 |
806911 | 806911 | 2020-12-08 | Tuscaloosa | Alabama | 1125 | 14507 | 186 |
803666 | 803666 | 2020-12-07 | Tuscaloosa | Alabama | 1125 | 14294 | 177 |
800421 | 800421 | 2020-12-06 | Tuscaloosa | Alabama | 1125 | 14182 | 177 |
797176 | 797176 | 2020-12-05 | Tuscaloosa | Alabama | 1125 | 14065 | 176 |
793931 | 793931 | 2020-12-04 | Tuscaloosa | Alabama | 1125 | 13897 | 173 |
790686 | 790686 | 2020-12-03 | Tuscaloosa | Alabama | 1125 | 13755 | 173 |
787441 | 787441 | 2020-12-02 | Tuscaloosa | Alabama | 1125 | 13591 | 156 |
784197 | 784197 | 2020-12-01 | Tuscaloosa | Alabama | 1125 | 13366 | 154 |
780952 | 780952 | 2020-11-30 | Tuscaloosa | Alabama | 1125 | 13246 | 154 |
777706 | 777706 | 2020-11-29 | Tuscaloosa | Alabama | 1125 | 13167 | 154 |
774461 | 774461 | 2020-11-28 | Tuscaloosa | Alabama | 1125 | 13049 | 154 |
771216 | 771216 | 2020-11-27 | Tuscaloosa | Alabama | 1125 | 12983 | 154 |
767970 | 767970 | 2020-11-26 | Tuscaloosa | Alabama | 1125 | 12946 | 154 |
764725 | 764725 | 2020-11-25 | Tuscaloosa | Alabama | 1125 | 12813 | 154 |
761480 | 761480 | 2020-11-24 | Tuscaloosa | Alabama | 1125 | 12684 | 150 |
758235 | 758235 | 2020-11-23 | Tuscaloosa | Alabama | 1125 | 12501 | 148 |
754988 | 754988 | 2020-11-22 | Tuscaloosa | Alabama | 1125 | 12446 | 148 |
751742 | 751742 | 2020-11-21 | Tuscaloosa | Alabama | 1125 | 12356 | 148 |
748496 | 748496 | 2020-11-20 | Tuscaloosa | Alabama | 1125 | 12274 | 149 |
745250 | 745250 | 2020-11-19 | Tuscaloosa | Alabama | 1125 | 12179 | 149 |
742003 | 742003 | 2020-11-18 | Tuscaloosa | Alabama | 1125 | 12052 | 149 |
738756 | 738756 | 2020-11-17 | Tuscaloosa | Alabama | 1125 | 11949 | 149 |
735512 | 735512 | 2020-11-16 | Tuscaloosa | Alabama | 1125 | 11886 | 148 |
732266 | 732266 | 2020-11-15 | Tuscaloosa | Alabama | 1125 | 11810 | 148 |
729021 | 729021 | 2020-11-14 | Tuscaloosa | Alabama | 1125 | 11726 | 148 |
725778 | 725778 | 2020-11-13 | Tuscaloosa | Alabama | 1125 | 11566 | 148 |
722535 | 722535 | 2020-11-12 | Tuscaloosa | Alabama | 1125 | 11440 | 147 |
719292 | 719292 | 2020-11-11 | Tuscaloosa | Alabama | 1125 | 11369 | 147 |
716049 | 716049 | 2020-11-10 | Tuscaloosa | Alabama | 1125 | 11298 | 147 |
712805 | 712805 | 2020-11-09 | Tuscaloosa | Alabama | 1125 | 11260 | 146 |
709561 | 709561 | 2020-11-08 | Tuscaloosa | Alabama | 1125 | 11205 | 146 |
706317 | 706317 | 2020-11-07 | Tuscaloosa | Alabama | 1125 | 11141 | 146 |
703074 | 703074 | 2020-11-06 | Tuscaloosa | Alabama | 1125 | 11025 | 146 |
699831 | 699831 | 2020-11-05 | Tuscaloosa | Alabama | 1125 | 10976 | 145 |
696587 | 696587 | 2020-11-04 | Tuscaloosa | Alabama | 1125 | 10937 | 145 |
693345 | 693345 | 2020-11-03 | Tuscaloosa | Alabama | 1125 | 10844 | 145 |
690102 | 690102 | 2020-11-02 | Tuscaloosa | Alabama | 1125 | 10824 | 145 |
686857 | 686857 | 2020-11-01 | Tuscaloosa | Alabama | 1125 | 10792 | 145 |
683613 | 683613 | 2020-10-31 | Tuscaloosa | Alabama | 1125 | 10734 | 145 |
680370 | 680370 | 2020-10-30 | Tuscaloosa | Alabama | 1125 | 10641 | 142 |
677127 | 677127 | 2020-10-29 | Tuscaloosa | Alabama | 1125 | 10602 | 141 |
673884 | 673884 | 2020-10-28 | Tuscaloosa | Alabama | 1125 | 10539 | 141 |
670642 | 670642 | 2020-10-27 | Tuscaloosa | Alabama | 1125 | 10462 | 140 |
667399 | 667399 | 2020-10-26 | Tuscaloosa | Alabama | 1125 | 10414 | 140 |
664154 | 664154 | 2020-10-25 | Tuscaloosa | Alabama | 1125 | 10345 | 140 |
660910 | 660910 | 2020-10-24 | Tuscaloosa | Alabama | 1125 | 10296 | 140 |
657666 | 657666 | 2020-10-23 | Tuscaloosa | Alabama | 1125 | 10235 | 140 |
654421 | 654421 | 2020-10-22 | Tuscaloosa | Alabama | 1125 | 10148 | 139 |
651176 | 651176 | 2020-10-21 | Tuscaloosa | Alabama | 1125 | 10066 | 137 |
647932 | 647932 | 2020-10-20 | Tuscaloosa | Alabama | 1125 | 10023 | 133 |
644687 | 644687 | 2020-10-19 | Tuscaloosa | Alabama | 1125 | 9983 | 132 |
641439 | 641439 | 2020-10-18 | Tuscaloosa | Alabama | 1125 | 9886 | 132 |
638192 | 638192 | 2020-10-17 | Tuscaloosa | Alabama | 1125 | 9782 | 132 |
634947 | 634947 | 2020-10-16 | Tuscaloosa | Alabama | 1125 | 9747 | 132 |
631702 | 631702 | 2020-10-15 | Tuscaloosa | Alabama | 1125 | 9702 | 130 |
628458 | 628458 | 2020-10-14 | Tuscaloosa | Alabama | 1125 | 9651 | 128 |
625215 | 625215 | 2020-10-13 | Tuscaloosa | Alabama | 1125 | 9619 | 128 |
621972 | 621972 | 2020-10-12 | Tuscaloosa | Alabama | 1125 | 9547 | 128 |
618729 | 618729 | 2020-10-11 | Tuscaloosa | Alabama | 1125 | 9503 | 128 |
615487 | 615487 | 2020-10-10 | Tuscaloosa | Alabama | 1125 | 9430 | 128 |
612246 | 612246 | 2020-10-09 | Tuscaloosa | Alabama | 1125 | 9390 | 126 |
609004 | 609004 | 2020-10-08 | Tuscaloosa | Alabama | 1125 | 9364 | 124 |
605761 | 605761 | 2020-10-07 | Tuscaloosa | Alabama | 1125 | 9352 | 121 |
602519 | 602519 | 2020-10-06 | Tuscaloosa | Alabama | 1125 | 9291 | 121 |
599276 | 599276 | 2020-10-05 | Tuscaloosa | Alabama | 1125 | 9219 | 119 |
596033 | 596033 | 2020-10-04 | Tuscaloosa | Alabama | 1125 | 9194 | 119 |
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);