ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 1117 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917250 | 917250 | 2021-01-11 | Shelby | Alabama | 1117 | 17690 | 106 |
914005 | 914005 | 2021-01-10 | Shelby | Alabama | 1117 | 17562 | 106 |
910760 | 910760 | 2021-01-09 | Shelby | Alabama | 1117 | 17449 | 106 |
907515 | 907515 | 2021-01-08 | Shelby | Alabama | 1117 | 17253 | 105 |
904269 | 904269 | 2021-01-07 | Shelby | Alabama | 1117 | 17035 | 105 |
901024 | 901024 | 2021-01-06 | Shelby | Alabama | 1117 | 16824 | 105 |
897779 | 897779 | 2021-01-05 | Shelby | Alabama | 1117 | 16622 | 103 |
894533 | 894533 | 2021-01-04 | Shelby | Alabama | 1117 | 16323 | 103 |
891287 | 891287 | 2021-01-03 | Shelby | Alabama | 1117 | 16186 | 103 |
888040 | 888040 | 2021-01-02 | Shelby | Alabama | 1117 | 16034 | 103 |
884795 | 884795 | 2021-01-01 | Shelby | Alabama | 1117 | 15877 | 103 |
881550 | 881550 | 2020-12-31 | Shelby | Alabama | 1117 | 15668 | 103 |
878305 | 878305 | 2020-12-30 | Shelby | Alabama | 1117 | 15501 | 103 |
875060 | 875060 | 2020-12-29 | Shelby | Alabama | 1117 | 15304 | 103 |
871815 | 871815 | 2020-12-28 | Shelby | Alabama | 1117 | 15159 | 103 |
868570 | 868570 | 2020-12-27 | Shelby | Alabama | 1117 | 15020 | 103 |
865325 | 865325 | 2020-12-26 | Shelby | Alabama | 1117 | 14880 | 103 |
862080 | 862080 | 2020-12-25 | Shelby | Alabama | 1117 | 14840 | 103 |
858835 | 858835 | 2020-12-24 | Shelby | Alabama | 1117 | 14635 | 103 |
855590 | 855590 | 2020-12-23 | Shelby | Alabama | 1117 | 14407 | 101 |
852345 | 852345 | 2020-12-22 | Shelby | Alabama | 1117 | 14212 | 98 |
849100 | 849100 | 2020-12-21 | Shelby | Alabama | 1117 | 14016 | 97 |
845855 | 845855 | 2020-12-20 | Shelby | Alabama | 1117 | 13888 | 97 |
842609 | 842609 | 2020-12-19 | Shelby | Alabama | 1117 | 13763 | 97 |
839364 | 839364 | 2020-12-18 | Shelby | Alabama | 1117 | 13586 | 93 |
836119 | 836119 | 2020-12-17 | Shelby | Alabama | 1117 | 13366 | 93 |
832873 | 832873 | 2020-12-16 | Shelby | Alabama | 1117 | 13165 | 89 |
829626 | 829626 | 2020-12-15 | Shelby | Alabama | 1117 | 12983 | 87 |
826380 | 826380 | 2020-12-14 | Shelby | Alabama | 1117 | 12837 | 87 |
823133 | 823133 | 2020-12-13 | Shelby | Alabama | 1117 | 12705 | 87 |
819887 | 819887 | 2020-12-12 | Shelby | Alabama | 1117 | 12551 | 87 |
816641 | 816641 | 2020-12-11 | Shelby | Alabama | 1117 | 12411 | 87 |
813395 | 813395 | 2020-12-10 | Shelby | Alabama | 1117 | 12254 | 86 |
810151 | 810151 | 2020-12-09 | Shelby | Alabama | 1117 | 12047 | 85 |
806906 | 806906 | 2020-12-08 | Shelby | Alabama | 1117 | 11881 | 78 |
803661 | 803661 | 2020-12-07 | Shelby | Alabama | 1117 | 11687 | 79 |
800416 | 800416 | 2020-12-06 | Shelby | Alabama | 1117 | 11546 | 79 |
797171 | 797171 | 2020-12-05 | Shelby | Alabama | 1117 | 11450 | 79 |
793926 | 793926 | 2020-12-04 | Shelby | Alabama | 1117 | 11278 | 78 |
790681 | 790681 | 2020-12-03 | Shelby | Alabama | 1117 | 11102 | 78 |
787436 | 787436 | 2020-12-02 | Shelby | Alabama | 1117 | 10958 | 77 |
784192 | 784192 | 2020-12-01 | Shelby | Alabama | 1117 | 10796 | 77 |
780947 | 780947 | 2020-11-30 | Shelby | Alabama | 1117 | 10616 | 77 |
777701 | 777701 | 2020-11-29 | Shelby | Alabama | 1117 | 10465 | 77 |
774456 | 774456 | 2020-11-28 | Shelby | Alabama | 1117 | 10315 | 77 |
771211 | 771211 | 2020-11-27 | Shelby | Alabama | 1117 | 10203 | 77 |
767965 | 767965 | 2020-11-26 | Shelby | Alabama | 1117 | 10161 | 77 |
764720 | 764720 | 2020-11-25 | Shelby | Alabama | 1117 | 10005 | 77 |
761475 | 761475 | 2020-11-24 | Shelby | Alabama | 1117 | 9922 | 76 |
758230 | 758230 | 2020-11-23 | Shelby | Alabama | 1117 | 9805 | 76 |
754983 | 754983 | 2020-11-22 | Shelby | Alabama | 1117 | 9712 | 76 |
751737 | 751737 | 2020-11-21 | Shelby | Alabama | 1117 | 9629 | 76 |
748491 | 748491 | 2020-11-20 | Shelby | Alabama | 1117 | 9537 | 75 |
745245 | 745245 | 2020-11-19 | Shelby | Alabama | 1117 | 9444 | 75 |
741998 | 741998 | 2020-11-18 | Shelby | Alabama | 1117 | 9317 | 75 |
738751 | 738751 | 2020-11-17 | Shelby | Alabama | 1117 | 9160 | 74 |
735507 | 735507 | 2020-11-16 | Shelby | Alabama | 1117 | 9086 | 73 |
732261 | 732261 | 2020-11-15 | Shelby | Alabama | 1117 | 9011 | 73 |
729016 | 729016 | 2020-11-14 | Shelby | Alabama | 1117 | 8913 | 73 |
725773 | 725773 | 2020-11-13 | Shelby | Alabama | 1117 | 8792 | 73 |
722530 | 722530 | 2020-11-12 | Shelby | Alabama | 1117 | 8635 | 73 |
719287 | 719287 | 2020-11-11 | Shelby | Alabama | 1117 | 8539 | 73 |
716044 | 716044 | 2020-11-10 | Shelby | Alabama | 1117 | 8423 | 72 |
712800 | 712800 | 2020-11-09 | Shelby | Alabama | 1117 | 8319 | 71 |
709556 | 709556 | 2020-11-08 | Shelby | Alabama | 1117 | 8251 | 71 |
706312 | 706312 | 2020-11-07 | Shelby | Alabama | 1117 | 8182 | 71 |
703069 | 703069 | 2020-11-06 | Shelby | Alabama | 1117 | 8090 | 70 |
699826 | 699826 | 2020-11-05 | Shelby | Alabama | 1117 | 8017 | 70 |
696582 | 696582 | 2020-11-04 | Shelby | Alabama | 1117 | 7947 | 70 |
693340 | 693340 | 2020-11-03 | Shelby | Alabama | 1117 | 7870 | 70 |
690097 | 690097 | 2020-11-02 | Shelby | Alabama | 1117 | 7826 | 70 |
686852 | 686852 | 2020-11-01 | Shelby | Alabama | 1117 | 7788 | 70 |
683608 | 683608 | 2020-10-31 | Shelby | Alabama | 1117 | 7716 | 70 |
680365 | 680365 | 2020-10-30 | Shelby | Alabama | 1117 | 7660 | 67 |
677122 | 677122 | 2020-10-29 | Shelby | Alabama | 1117 | 7605 | 65 |
673879 | 673879 | 2020-10-28 | Shelby | Alabama | 1117 | 7563 | 65 |
670637 | 670637 | 2020-10-27 | Shelby | Alabama | 1117 | 7504 | 65 |
667394 | 667394 | 2020-10-26 | Shelby | Alabama | 1117 | 7436 | 63 |
664149 | 664149 | 2020-10-25 | Shelby | Alabama | 1117 | 7390 | 63 |
660905 | 660905 | 2020-10-24 | Shelby | Alabama | 1117 | 7338 | 63 |
657661 | 657661 | 2020-10-23 | Shelby | Alabama | 1117 | 7274 | 63 |
654416 | 654416 | 2020-10-22 | Shelby | Alabama | 1117 | 7204 | 62 |
651171 | 651171 | 2020-10-21 | Shelby | Alabama | 1117 | 7153 | 61 |
647927 | 647927 | 2020-10-20 | Shelby | Alabama | 1117 | 7099 | 60 |
644682 | 644682 | 2020-10-19 | Shelby | Alabama | 1117 | 7035 | 60 |
641434 | 641434 | 2020-10-18 | Shelby | Alabama | 1117 | 7002 | 60 |
638187 | 638187 | 2020-10-17 | Shelby | Alabama | 1117 | 6955 | 60 |
634942 | 634942 | 2020-10-16 | Shelby | Alabama | 1117 | 6906 | 60 |
631697 | 631697 | 2020-10-15 | Shelby | Alabama | 1117 | 6853 | 60 |
628453 | 628453 | 2020-10-14 | Shelby | Alabama | 1117 | 6804 | 59 |
625210 | 625210 | 2020-10-13 | Shelby | Alabama | 1117 | 6758 | 58 |
621967 | 621967 | 2020-10-12 | Shelby | Alabama | 1117 | 6706 | 58 |
618724 | 618724 | 2020-10-11 | Shelby | Alabama | 1117 | 6673 | 58 |
615482 | 615482 | 2020-10-10 | Shelby | Alabama | 1117 | 6637 | 58 |
612241 | 612241 | 2020-10-09 | Shelby | Alabama | 1117 | 6589 | 58 |
608999 | 608999 | 2020-10-08 | Shelby | Alabama | 1117 | 6497 | 56 |
605756 | 605756 | 2020-10-07 | Shelby | Alabama | 1117 | 6485 | 56 |
602514 | 602514 | 2020-10-06 | Shelby | Alabama | 1117 | 6448 | 54 |
599271 | 599271 | 2020-10-05 | Shelby | Alabama | 1117 | 6407 | 51 |
596028 | 596028 | 2020-10-04 | Shelby | Alabama | 1117 | 6375 | 51 |
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);