ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 1121 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917253 | 917253 | 2021-01-11 | Talladega | Alabama | 1121 | 5825 | 109 |
914008 | 914008 | 2021-01-10 | Talladega | Alabama | 1121 | 5796 | 109 |
910763 | 910763 | 2021-01-09 | Talladega | Alabama | 1121 | 5766 | 109 |
907518 | 907518 | 2021-01-08 | Talladega | Alabama | 1121 | 5689 | 84 |
904272 | 904272 | 2021-01-07 | Talladega | Alabama | 1121 | 5617 | 76 |
901027 | 901027 | 2021-01-06 | Talladega | Alabama | 1121 | 5528 | 76 |
897782 | 897782 | 2021-01-05 | Talladega | Alabama | 1121 | 5466 | 77 |
894536 | 894536 | 2021-01-04 | Talladega | Alabama | 1121 | 5300 | 76 |
891290 | 891290 | 2021-01-03 | Talladega | Alabama | 1121 | 5274 | 76 |
888043 | 888043 | 2021-01-02 | Talladega | Alabama | 1121 | 5254 | 76 |
884798 | 884798 | 2021-01-01 | Talladega | Alabama | 1121 | 5211 | 76 |
881553 | 881553 | 2020-12-31 | Talladega | Alabama | 1121 | 5165 | 75 |
878308 | 878308 | 2020-12-30 | Talladega | Alabama | 1121 | 5111 | 74 |
875063 | 875063 | 2020-12-29 | Talladega | Alabama | 1121 | 5053 | 74 |
871818 | 871818 | 2020-12-28 | Talladega | Alabama | 1121 | 4953 | 74 |
868573 | 868573 | 2020-12-27 | Talladega | Alabama | 1121 | 4932 | 74 |
865328 | 865328 | 2020-12-26 | Talladega | Alabama | 1121 | 4917 | 74 |
862083 | 862083 | 2020-12-25 | Talladega | Alabama | 1121 | 4907 | 74 |
858838 | 858838 | 2020-12-24 | Talladega | Alabama | 1121 | 4852 | 74 |
855593 | 855593 | 2020-12-23 | Talladega | Alabama | 1121 | 4818 | 72 |
852348 | 852348 | 2020-12-22 | Talladega | Alabama | 1121 | 4767 | 71 |
849103 | 849103 | 2020-12-21 | Talladega | Alabama | 1121 | 4688 | 69 |
845858 | 845858 | 2020-12-20 | Talladega | Alabama | 1121 | 4655 | 69 |
842612 | 842612 | 2020-12-19 | Talladega | Alabama | 1121 | 4626 | 69 |
839367 | 839367 | 2020-12-18 | Talladega | Alabama | 1121 | 4582 | 68 |
836122 | 836122 | 2020-12-17 | Talladega | Alabama | 1121 | 4546 | 67 |
832876 | 832876 | 2020-12-16 | Talladega | Alabama | 1121 | 4476 | 64 |
829629 | 829629 | 2020-12-15 | Talladega | Alabama | 1121 | 4448 | 64 |
826383 | 826383 | 2020-12-14 | Talladega | Alabama | 1121 | 4371 | 63 |
823136 | 823136 | 2020-12-13 | Talladega | Alabama | 1121 | 4335 | 63 |
819890 | 819890 | 2020-12-12 | Talladega | Alabama | 1121 | 4298 | 63 |
816644 | 816644 | 2020-12-11 | Talladega | Alabama | 1121 | 4241 | 62 |
813398 | 813398 | 2020-12-10 | Talladega | Alabama | 1121 | 4180 | 61 |
810154 | 810154 | 2020-12-09 | Talladega | Alabama | 1121 | 4110 | 61 |
806909 | 806909 | 2020-12-08 | Talladega | Alabama | 1121 | 4082 | 62 |
803664 | 803664 | 2020-12-07 | Talladega | Alabama | 1121 | 3976 | 60 |
800419 | 800419 | 2020-12-06 | Talladega | Alabama | 1121 | 3944 | 60 |
797174 | 797174 | 2020-12-05 | Talladega | Alabama | 1121 | 3911 | 60 |
793929 | 793929 | 2020-12-04 | Talladega | Alabama | 1121 | 3861 | 57 |
790684 | 790684 | 2020-12-03 | Talladega | Alabama | 1121 | 3811 | 57 |
787439 | 787439 | 2020-12-02 | Talladega | Alabama | 1121 | 3744 | 57 |
784195 | 784195 | 2020-12-01 | Talladega | Alabama | 1121 | 3701 | 57 |
780950 | 780950 | 2020-11-30 | Talladega | Alabama | 1121 | 3593 | 54 |
777704 | 777704 | 2020-11-29 | Talladega | Alabama | 1121 | 3535 | 54 |
774459 | 774459 | 2020-11-28 | Talladega | Alabama | 1121 | 3514 | 54 |
771214 | 771214 | 2020-11-27 | Talladega | Alabama | 1121 | 3490 | 54 |
767968 | 767968 | 2020-11-26 | Talladega | Alabama | 1121 | 3479 | 54 |
764723 | 764723 | 2020-11-25 | Talladega | Alabama | 1121 | 3434 | 53 |
761478 | 761478 | 2020-11-24 | Talladega | Alabama | 1121 | 3390 | 44 |
758233 | 758233 | 2020-11-23 | Talladega | Alabama | 1121 | 3359 | 42 |
754986 | 754986 | 2020-11-22 | Talladega | Alabama | 1121 | 3340 | 42 |
751740 | 751740 | 2020-11-21 | Talladega | Alabama | 1121 | 3318 | 42 |
748494 | 748494 | 2020-11-20 | Talladega | Alabama | 1121 | 3292 | 42 |
745248 | 745248 | 2020-11-19 | Talladega | Alabama | 1121 | 3263 | 41 |
742001 | 742001 | 2020-11-18 | Talladega | Alabama | 1121 | 3227 | 41 |
738754 | 738754 | 2020-11-17 | Talladega | Alabama | 1121 | 3188 | 41 |
735510 | 735510 | 2020-11-16 | Talladega | Alabama | 1121 | 3180 | 41 |
732264 | 732264 | 2020-11-15 | Talladega | Alabama | 1121 | 3171 | 41 |
729019 | 729019 | 2020-11-14 | Talladega | Alabama | 1121 | 3120 | 41 |
725776 | 725776 | 2020-11-13 | Talladega | Alabama | 1121 | 3083 | 41 |
722533 | 722533 | 2020-11-12 | Talladega | Alabama | 1121 | 3045 | 40 |
719290 | 719290 | 2020-11-11 | Talladega | Alabama | 1121 | 3009 | 40 |
716047 | 716047 | 2020-11-10 | Talladega | Alabama | 1121 | 2992 | 40 |
712803 | 712803 | 2020-11-09 | Talladega | Alabama | 1121 | 2953 | 40 |
709559 | 709559 | 2020-11-08 | Talladega | Alabama | 1121 | 2941 | 40 |
706315 | 706315 | 2020-11-07 | Talladega | Alabama | 1121 | 2935 | 40 |
703072 | 703072 | 2020-11-06 | Talladega | Alabama | 1121 | 2910 | 40 |
699829 | 699829 | 2020-11-05 | Talladega | Alabama | 1121 | 2892 | 39 |
696585 | 696585 | 2020-11-04 | Talladega | Alabama | 1121 | 2866 | 38 |
693343 | 693343 | 2020-11-03 | Talladega | Alabama | 1121 | 2843 | 38 |
690100 | 690100 | 2020-11-02 | Talladega | Alabama | 1121 | 2818 | 38 |
686855 | 686855 | 2020-11-01 | Talladega | Alabama | 1121 | 2808 | 38 |
683611 | 683611 | 2020-10-31 | Talladega | Alabama | 1121 | 2797 | 38 |
680368 | 680368 | 2020-10-30 | Talladega | Alabama | 1121 | 2777 | 37 |
677125 | 677125 | 2020-10-29 | Talladega | Alabama | 1121 | 2764 | 37 |
673882 | 673882 | 2020-10-28 | Talladega | Alabama | 1121 | 2739 | 37 |
670640 | 670640 | 2020-10-27 | Talladega | Alabama | 1121 | 2714 | 37 |
667397 | 667397 | 2020-10-26 | Talladega | Alabama | 1121 | 2674 | 35 |
664152 | 664152 | 2020-10-25 | Talladega | Alabama | 1121 | 2664 | 35 |
660908 | 660908 | 2020-10-24 | Talladega | Alabama | 1121 | 2653 | 35 |
657664 | 657664 | 2020-10-23 | Talladega | Alabama | 1121 | 2636 | 35 |
654419 | 654419 | 2020-10-22 | Talladega | Alabama | 1121 | 2610 | 35 |
651174 | 651174 | 2020-10-21 | Talladega | Alabama | 1121 | 2591 | 35 |
647930 | 647930 | 2020-10-20 | Talladega | Alabama | 1121 | 2584 | 35 |
644685 | 644685 | 2020-10-19 | Talladega | Alabama | 1121 | 2550 | 34 |
641437 | 641437 | 2020-10-18 | Talladega | Alabama | 1121 | 2536 | 34 |
638190 | 638190 | 2020-10-17 | Talladega | Alabama | 1121 | 2529 | 34 |
634945 | 634945 | 2020-10-16 | Talladega | Alabama | 1121 | 2495 | 34 |
631700 | 631700 | 2020-10-15 | Talladega | Alabama | 1121 | 2473 | 34 |
628456 | 628456 | 2020-10-14 | Talladega | Alabama | 1121 | 2454 | 33 |
625213 | 625213 | 2020-10-13 | Talladega | Alabama | 1121 | 2447 | 33 |
621970 | 621970 | 2020-10-12 | Talladega | Alabama | 1121 | 2408 | 33 |
618727 | 618727 | 2020-10-11 | Talladega | Alabama | 1121 | 2401 | 33 |
615485 | 615485 | 2020-10-10 | Talladega | Alabama | 1121 | 2375 | 33 |
612244 | 612244 | 2020-10-09 | Talladega | Alabama | 1121 | 2349 | 33 |
609002 | 609002 | 2020-10-08 | Talladega | Alabama | 1121 | 2306 | 32 |
605759 | 605759 | 2020-10-07 | Talladega | Alabama | 1121 | 2291 | 31 |
602517 | 602517 | 2020-10-06 | Talladega | Alabama | 1121 | 2266 | 31 |
599274 | 599274 | 2020-10-05 | Talladega | Alabama | 1121 | 2257 | 30 |
596031 | 596031 | 2020-10-04 | Talladega | Alabama | 1121 | 2253 | 30 |
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);