ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 1089 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917237 | 917237 | 2021-01-11 | Madison | Alabama | 1089 | 25643 | 178 |
913992 | 913992 | 2021-01-10 | Madison | Alabama | 1089 | 25463 | 178 |
910747 | 910747 | 2021-01-09 | Madison | Alabama | 1089 | 25219 | 177 |
907502 | 907502 | 2021-01-08 | Madison | Alabama | 1089 | 24795 | 179 |
904256 | 904256 | 2021-01-07 | Madison | Alabama | 1089 | 24395 | 179 |
901011 | 901011 | 2021-01-06 | Madison | Alabama | 1089 | 24111 | 181 |
897766 | 897766 | 2021-01-05 | Madison | Alabama | 1089 | 23840 | 179 |
894520 | 894520 | 2021-01-04 | Madison | Alabama | 1089 | 23563 | 179 |
891274 | 891274 | 2021-01-03 | Madison | Alabama | 1089 | 23364 | 179 |
888027 | 888027 | 2021-01-02 | Madison | Alabama | 1089 | 23115 | 179 |
884782 | 884782 | 2021-01-01 | Madison | Alabama | 1089 | 22590 | 179 |
881537 | 881537 | 2020-12-31 | Madison | Alabama | 1089 | 22197 | 178 |
878292 | 878292 | 2020-12-30 | Madison | Alabama | 1089 | 21884 | 178 |
875047 | 875047 | 2020-12-29 | Madison | Alabama | 1089 | 21621 | 178 |
871802 | 871802 | 2020-12-28 | Madison | Alabama | 1089 | 21385 | 179 |
868557 | 868557 | 2020-12-27 | Madison | Alabama | 1089 | 21206 | 179 |
865312 | 865312 | 2020-12-26 | Madison | Alabama | 1089 | 21038 | 179 |
862067 | 862067 | 2020-12-25 | Madison | Alabama | 1089 | 20915 | 179 |
858822 | 858822 | 2020-12-24 | Madison | Alabama | 1089 | 20540 | 179 |
855577 | 855577 | 2020-12-23 | Madison | Alabama | 1089 | 20254 | 178 |
852332 | 852332 | 2020-12-22 | Madison | Alabama | 1089 | 19899 | 176 |
849087 | 849087 | 2020-12-21 | Madison | Alabama | 1089 | 19477 | 174 |
845842 | 845842 | 2020-12-20 | Madison | Alabama | 1089 | 19314 | 174 |
842596 | 842596 | 2020-12-19 | Madison | Alabama | 1089 | 19062 | 174 |
839351 | 839351 | 2020-12-18 | Madison | Alabama | 1089 | 18684 | 172 |
836106 | 836106 | 2020-12-17 | Madison | Alabama | 1089 | 18184 | 170 |
832860 | 832860 | 2020-12-16 | Madison | Alabama | 1089 | 17809 | 165 |
829613 | 829613 | 2020-12-15 | Madison | Alabama | 1089 | 17454 | 163 |
826367 | 826367 | 2020-12-14 | Madison | Alabama | 1089 | 17277 | 162 |
823120 | 823120 | 2020-12-13 | Madison | Alabama | 1089 | 17030 | 162 |
819874 | 819874 | 2020-12-12 | Madison | Alabama | 1089 | 16760 | 162 |
816628 | 816628 | 2020-12-11 | Madison | Alabama | 1089 | 16459 | 163 |
813382 | 813382 | 2020-12-10 | Madison | Alabama | 1089 | 16115 | 163 |
810138 | 810138 | 2020-12-09 | Madison | Alabama | 1089 | 15884 | 160 |
806893 | 806893 | 2020-12-08 | Madison | Alabama | 1089 | 15575 | 161 |
803648 | 803648 | 2020-12-07 | Madison | Alabama | 1089 | 15316 | 160 |
800403 | 800403 | 2020-12-06 | Madison | Alabama | 1089 | 15090 | 160 |
797158 | 797158 | 2020-12-05 | Madison | Alabama | 1089 | 14854 | 159 |
793913 | 793913 | 2020-12-04 | Madison | Alabama | 1089 | 14521 | 153 |
790668 | 790668 | 2020-12-03 | Madison | Alabama | 1089 | 14215 | 153 |
787423 | 787423 | 2020-12-02 | Madison | Alabama | 1089 | 13925 | 150 |
784179 | 784179 | 2020-12-01 | Madison | Alabama | 1089 | 13723 | 151 |
780934 | 780934 | 2020-11-30 | Madison | Alabama | 1089 | 13596 | 148 |
777688 | 777688 | 2020-11-29 | Madison | Alabama | 1089 | 13425 | 148 |
774443 | 774443 | 2020-11-28 | Madison | Alabama | 1089 | 13223 | 148 |
771198 | 771198 | 2020-11-27 | Madison | Alabama | 1089 | 13065 | 148 |
767952 | 767952 | 2020-11-26 | Madison | Alabama | 1089 | 12964 | 148 |
764707 | 764707 | 2020-11-25 | Madison | Alabama | 1089 | 12741 | 146 |
761462 | 761462 | 2020-11-24 | Madison | Alabama | 1089 | 12528 | 146 |
758217 | 758217 | 2020-11-23 | Madison | Alabama | 1089 | 12410 | 146 |
754970 | 754970 | 2020-11-22 | Madison | Alabama | 1089 | 12204 | 146 |
751724 | 751724 | 2020-11-21 | Madison | Alabama | 1089 | 12092 | 146 |
748478 | 748478 | 2020-11-20 | Madison | Alabama | 1089 | 11958 | 146 |
745232 | 745232 | 2020-11-19 | Madison | Alabama | 1089 | 11834 | 129 |
741985 | 741985 | 2020-11-18 | Madison | Alabama | 1089 | 11693 | 121 |
738738 | 738738 | 2020-11-17 | Madison | Alabama | 1089 | 11523 | 120 |
735494 | 735494 | 2020-11-16 | Madison | Alabama | 1089 | 11438 | 118 |
732248 | 732248 | 2020-11-15 | Madison | Alabama | 1089 | 11305 | 118 |
729003 | 729003 | 2020-11-14 | Madison | Alabama | 1089 | 11155 | 118 |
725760 | 725760 | 2020-11-13 | Madison | Alabama | 1089 | 11002 | 118 |
722517 | 722517 | 2020-11-12 | Madison | Alabama | 1089 | 10806 | 117 |
719274 | 719274 | 2020-11-11 | Madison | Alabama | 1089 | 10635 | 117 |
716031 | 716031 | 2020-11-10 | Madison | Alabama | 1089 | 10524 | 108 |
712787 | 712787 | 2020-11-09 | Madison | Alabama | 1089 | 10459 | 105 |
709543 | 709543 | 2020-11-08 | Madison | Alabama | 1089 | 10358 | 105 |
706299 | 706299 | 2020-11-07 | Madison | Alabama | 1089 | 10284 | 105 |
703056 | 703056 | 2020-11-06 | Madison | Alabama | 1089 | 10150 | 106 |
699813 | 699813 | 2020-11-05 | Madison | Alabama | 1089 | 10078 | 102 |
696569 | 696569 | 2020-11-04 | Madison | Alabama | 1089 | 9959 | 102 |
693327 | 693327 | 2020-11-03 | Madison | Alabama | 1089 | 9893 | 101 |
690084 | 690084 | 2020-11-02 | Madison | Alabama | 1089 | 9852 | 101 |
686839 | 686839 | 2020-11-01 | Madison | Alabama | 1089 | 9787 | 101 |
683595 | 683595 | 2020-10-31 | Madison | Alabama | 1089 | 9680 | 101 |
680352 | 680352 | 2020-10-30 | Madison | Alabama | 1089 | 9619 | 98 |
677109 | 677109 | 2020-10-29 | Madison | Alabama | 1089 | 9557 | 98 |
673866 | 673866 | 2020-10-28 | Madison | Alabama | 1089 | 9467 | 98 |
670624 | 670624 | 2020-10-27 | Madison | Alabama | 1089 | 9422 | 98 |
667381 | 667381 | 2020-10-26 | Madison | Alabama | 1089 | 9394 | 96 |
664136 | 664136 | 2020-10-25 | Madison | Alabama | 1089 | 9350 | 96 |
660892 | 660892 | 2020-10-24 | Madison | Alabama | 1089 | 9280 | 96 |
657648 | 657648 | 2020-10-23 | Madison | Alabama | 1089 | 9228 | 94 |
654403 | 654403 | 2020-10-22 | Madison | Alabama | 1089 | 9150 | 94 |
651158 | 651158 | 2020-10-21 | Madison | Alabama | 1089 | 9078 | 94 |
647914 | 647914 | 2020-10-20 | Madison | Alabama | 1089 | 9048 | 93 |
644669 | 644669 | 2020-10-19 | Madison | Alabama | 1089 | 8999 | 92 |
641421 | 641421 | 2020-10-18 | Madison | Alabama | 1089 | 8951 | 92 |
638174 | 638174 | 2020-10-17 | Madison | Alabama | 1089 | 8893 | 92 |
634929 | 634929 | 2020-10-16 | Madison | Alabama | 1089 | 8818 | 92 |
631684 | 631684 | 2020-10-15 | Madison | Alabama | 1089 | 8742 | 88 |
628440 | 628440 | 2020-10-14 | Madison | Alabama | 1089 | 8678 | 83 |
625197 | 625197 | 2020-10-13 | Madison | Alabama | 1089 | 8646 | 83 |
621954 | 621954 | 2020-10-12 | Madison | Alabama | 1089 | 8605 | 83 |
618711 | 618711 | 2020-10-11 | Madison | Alabama | 1089 | 8557 | 83 |
615469 | 615469 | 2020-10-10 | Madison | Alabama | 1089 | 8483 | 83 |
612228 | 612228 | 2020-10-09 | Madison | Alabama | 1089 | 8438 | 83 |
608986 | 608986 | 2020-10-08 | Madison | Alabama | 1089 | 8375 | 83 |
605743 | 605743 | 2020-10-07 | Madison | Alabama | 1089 | 8332 | 80 |
602501 | 602501 | 2020-10-06 | Madison | Alabama | 1089 | 8316 | 79 |
599258 | 599258 | 2020-10-05 | Madison | Alabama | 1089 | 8276 | 78 |
596015 | 596015 | 2020-10-04 | Madison | Alabama | 1089 | 8234 | 78 |
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);