ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Hale" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917225 | 917225 | 2021-01-11 | Hale | Alabama | 1065 | 1667 | 41 |
913980 | 913980 | 2021-01-10 | Hale | Alabama | 1065 | 1661 | 41 |
910735 | 910735 | 2021-01-09 | Hale | Alabama | 1065 | 1656 | 41 |
907490 | 907490 | 2021-01-08 | Hale | Alabama | 1065 | 1622 | 41 |
904244 | 904244 | 2021-01-07 | Hale | Alabama | 1065 | 1592 | 34 |
900999 | 900999 | 2021-01-06 | Hale | Alabama | 1065 | 1550 | 34 |
897754 | 897754 | 2021-01-05 | Hale | Alabama | 1065 | 1528 | 33 |
894508 | 894508 | 2021-01-04 | Hale | Alabama | 1065 | 1513 | 33 |
891262 | 891262 | 2021-01-03 | Hale | Alabama | 1065 | 1501 | 33 |
888015 | 888015 | 2021-01-02 | Hale | Alabama | 1065 | 1492 | 33 |
884770 | 884770 | 2021-01-01 | Hale | Alabama | 1065 | 1468 | 33 |
881525 | 881525 | 2020-12-31 | Hale | Alabama | 1065 | 1440 | 33 |
878280 | 878280 | 2020-12-30 | Hale | Alabama | 1065 | 1437 | 33 |
875035 | 875035 | 2020-12-29 | Hale | Alabama | 1065 | 1410 | 33 |
871790 | 871790 | 2020-12-28 | Hale | Alabama | 1065 | 1395 | 33 |
868545 | 868545 | 2020-12-27 | Hale | Alabama | 1065 | 1391 | 33 |
865300 | 865300 | 2020-12-26 | Hale | Alabama | 1065 | 1373 | 33 |
862055 | 862055 | 2020-12-25 | Hale | Alabama | 1065 | 1378 | 33 |
858810 | 858810 | 2020-12-24 | Hale | Alabama | 1065 | 1360 | 33 |
855565 | 855565 | 2020-12-23 | Hale | Alabama | 1065 | 1328 | 33 |
852320 | 852320 | 2020-12-22 | Hale | Alabama | 1065 | 1309 | 33 |
849075 | 849075 | 2020-12-21 | Hale | Alabama | 1065 | 1274 | 33 |
845830 | 845830 | 2020-12-20 | Hale | Alabama | 1065 | 1274 | 33 |
842584 | 842584 | 2020-12-19 | Hale | Alabama | 1065 | 1260 | 33 |
839339 | 839339 | 2020-12-18 | Hale | Alabama | 1065 | 1236 | 33 |
836094 | 836094 | 2020-12-17 | Hale | Alabama | 1065 | 1221 | 33 |
832848 | 832848 | 2020-12-16 | Hale | Alabama | 1065 | 1184 | 33 |
829601 | 829601 | 2020-12-15 | Hale | Alabama | 1065 | 1159 | 33 |
826355 | 826355 | 2020-12-14 | Hale | Alabama | 1065 | 1137 | 33 |
823108 | 823108 | 2020-12-13 | Hale | Alabama | 1065 | 1132 | 33 |
819862 | 819862 | 2020-12-12 | Hale | Alabama | 1065 | 1122 | 33 |
816616 | 816616 | 2020-12-11 | Hale | Alabama | 1065 | 1110 | 33 |
813370 | 813370 | 2020-12-10 | Hale | Alabama | 1065 | 1099 | 33 |
810126 | 810126 | 2020-12-09 | Hale | Alabama | 1065 | 1078 | 33 |
806881 | 806881 | 2020-12-08 | Hale | Alabama | 1065 | 1057 | 32 |
803636 | 803636 | 2020-12-07 | Hale | Alabama | 1065 | 1035 | 32 |
800391 | 800391 | 2020-12-06 | Hale | Alabama | 1065 | 1028 | 32 |
797146 | 797146 | 2020-12-05 | Hale | Alabama | 1065 | 1024 | 32 |
793901 | 793901 | 2020-12-04 | Hale | Alabama | 1065 | 1021 | 32 |
790656 | 790656 | 2020-12-03 | Hale | Alabama | 1065 | 1014 | 32 |
787411 | 787411 | 2020-12-02 | Hale | Alabama | 1065 | 997 | 32 |
784167 | 784167 | 2020-12-01 | Hale | Alabama | 1065 | 981 | 31 |
780922 | 780922 | 2020-11-30 | Hale | Alabama | 1065 | 978 | 31 |
777676 | 777676 | 2020-11-29 | Hale | Alabama | 1065 | 977 | 31 |
774431 | 774431 | 2020-11-28 | Hale | Alabama | 1065 | 970 | 31 |
771186 | 771186 | 2020-11-27 | Hale | Alabama | 1065 | 961 | 31 |
767940 | 767940 | 2020-11-26 | Hale | Alabama | 1065 | 960 | 31 |
764695 | 764695 | 2020-11-25 | Hale | Alabama | 1065 | 945 | 31 |
761450 | 761450 | 2020-11-24 | Hale | Alabama | 1065 | 932 | 31 |
758205 | 758205 | 2020-11-23 | Hale | Alabama | 1065 | 916 | 31 |
754958 | 754958 | 2020-11-22 | Hale | Alabama | 1065 | 915 | 31 |
751712 | 751712 | 2020-11-21 | Hale | Alabama | 1065 | 910 | 31 |
748466 | 748466 | 2020-11-20 | Hale | Alabama | 1065 | 907 | 31 |
745220 | 745220 | 2020-11-19 | Hale | Alabama | 1065 | 897 | 31 |
741973 | 741973 | 2020-11-18 | Hale | Alabama | 1065 | 889 | 31 |
738726 | 738726 | 2020-11-17 | Hale | Alabama | 1065 | 879 | 31 |
735482 | 735482 | 2020-11-16 | Hale | Alabama | 1065 | 876 | 30 |
732236 | 732236 | 2020-11-15 | Hale | Alabama | 1065 | 873 | 30 |
728991 | 728991 | 2020-11-14 | Hale | Alabama | 1065 | 868 | 30 |
725748 | 725748 | 2020-11-13 | Hale | Alabama | 1065 | 851 | 30 |
722505 | 722505 | 2020-11-12 | Hale | Alabama | 1065 | 847 | 30 |
719262 | 719262 | 2020-11-11 | Hale | Alabama | 1065 | 843 | 30 |
716019 | 716019 | 2020-11-10 | Hale | Alabama | 1065 | 833 | 30 |
712775 | 712775 | 2020-11-09 | Hale | Alabama | 1065 | 833 | 30 |
709531 | 709531 | 2020-11-08 | Hale | Alabama | 1065 | 825 | 30 |
706287 | 706287 | 2020-11-07 | Hale | Alabama | 1065 | 823 | 30 |
703044 | 703044 | 2020-11-06 | Hale | Alabama | 1065 | 820 | 30 |
699801 | 699801 | 2020-11-05 | Hale | Alabama | 1065 | 817 | 30 |
696557 | 696557 | 2020-11-04 | Hale | Alabama | 1065 | 816 | 30 |
693315 | 693315 | 2020-11-03 | Hale | Alabama | 1065 | 801 | 30 |
690072 | 690072 | 2020-11-02 | Hale | Alabama | 1065 | 798 | 30 |
686827 | 686827 | 2020-11-01 | Hale | Alabama | 1065 | 796 | 30 |
683583 | 683583 | 2020-10-31 | Hale | Alabama | 1065 | 793 | 30 |
680340 | 680340 | 2020-10-30 | Hale | Alabama | 1065 | 783 | 30 |
677097 | 677097 | 2020-10-29 | Hale | Alabama | 1065 | 781 | 30 |
673854 | 673854 | 2020-10-28 | Hale | Alabama | 1065 | 780 | 30 |
670612 | 670612 | 2020-10-27 | Hale | Alabama | 1065 | 777 | 30 |
667369 | 667369 | 2020-10-26 | Hale | Alabama | 1065 | 777 | 30 |
664124 | 664124 | 2020-10-25 | Hale | Alabama | 1065 | 768 | 30 |
660880 | 660880 | 2020-10-24 | Hale | Alabama | 1065 | 767 | 30 |
657636 | 657636 | 2020-10-23 | Hale | Alabama | 1065 | 758 | 30 |
654391 | 654391 | 2020-10-22 | Hale | Alabama | 1065 | 749 | 30 |
651146 | 651146 | 2020-10-21 | Hale | Alabama | 1065 | 748 | 30 |
647902 | 647902 | 2020-10-20 | Hale | Alabama | 1065 | 745 | 29 |
644657 | 644657 | 2020-10-19 | Hale | Alabama | 1065 | 745 | 29 |
641409 | 641409 | 2020-10-18 | Hale | Alabama | 1065 | 737 | 29 |
638162 | 638162 | 2020-10-17 | Hale | Alabama | 1065 | 734 | 29 |
634917 | 634917 | 2020-10-16 | Hale | Alabama | 1065 | 729 | 29 |
631672 | 631672 | 2020-10-15 | Hale | Alabama | 1065 | 726 | 29 |
628428 | 628428 | 2020-10-14 | Hale | Alabama | 1065 | 714 | 29 |
625185 | 625185 | 2020-10-13 | Hale | Alabama | 1065 | 712 | 29 |
621942 | 621942 | 2020-10-12 | Hale | Alabama | 1065 | 703 | 29 |
618699 | 618699 | 2020-10-11 | Hale | Alabama | 1065 | 699 | 29 |
615457 | 615457 | 2020-10-10 | Hale | Alabama | 1065 | 696 | 29 |
612216 | 612216 | 2020-10-09 | Hale | Alabama | 1065 | 695 | 28 |
608974 | 608974 | 2020-10-08 | Hale | Alabama | 1065 | 682 | 28 |
605731 | 605731 | 2020-10-07 | Hale | Alabama | 1065 | 679 | 28 |
602489 | 602489 | 2020-10-06 | Hale | Alabama | 1065 | 676 | 28 |
599246 | 599246 | 2020-10-05 | Hale | Alabama | 1065 | 669 | 28 |
596003 | 596003 | 2020-10-04 | Hale | Alabama | 1065 | 666 | 28 |
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);