ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 1015 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917200 | 917200 | 2021-01-11 | Calhoun | Alabama | 1015 | 10537 | 178 |
913955 | 913955 | 2021-01-10 | Calhoun | Alabama | 1015 | 10497 | 178 |
910710 | 910710 | 2021-01-09 | Calhoun | Alabama | 1015 | 10453 | 168 |
907465 | 907465 | 2021-01-08 | Calhoun | Alabama | 1015 | 10372 | 159 |
904219 | 904219 | 2021-01-07 | Calhoun | Alabama | 1015 | 10283 | 158 |
900974 | 900974 | 2021-01-06 | Calhoun | Alabama | 1015 | 10109 | 158 |
897729 | 897729 | 2021-01-05 | Calhoun | Alabama | 1015 | 9975 | 157 |
894483 | 894483 | 2021-01-04 | Calhoun | Alabama | 1015 | 9752 | 157 |
891237 | 891237 | 2021-01-03 | Calhoun | Alabama | 1015 | 9731 | 157 |
887990 | 887990 | 2021-01-02 | Calhoun | Alabama | 1015 | 9692 | 157 |
884745 | 884745 | 2021-01-01 | Calhoun | Alabama | 1015 | 9584 | 157 |
881500 | 881500 | 2020-12-31 | Calhoun | Alabama | 1015 | 9494 | 156 |
878255 | 878255 | 2020-12-30 | Calhoun | Alabama | 1015 | 9428 | 155 |
875010 | 875010 | 2020-12-29 | Calhoun | Alabama | 1015 | 9345 | 149 |
871765 | 871765 | 2020-12-28 | Calhoun | Alabama | 1015 | 9286 | 149 |
868520 | 868520 | 2020-12-27 | Calhoun | Alabama | 1015 | 9232 | 149 |
865275 | 865275 | 2020-12-26 | Calhoun | Alabama | 1015 | 9198 | 149 |
862030 | 862030 | 2020-12-25 | Calhoun | Alabama | 1015 | 9167 | 149 |
858785 | 858785 | 2020-12-24 | Calhoun | Alabama | 1015 | 9071 | 148 |
855540 | 855540 | 2020-12-23 | Calhoun | Alabama | 1015 | 8968 | 145 |
852295 | 852295 | 2020-12-22 | Calhoun | Alabama | 1015 | 8856 | 141 |
849050 | 849050 | 2020-12-21 | Calhoun | Alabama | 1015 | 8684 | 140 |
845805 | 845805 | 2020-12-20 | Calhoun | Alabama | 1015 | 8648 | 140 |
842559 | 842559 | 2020-12-19 | Calhoun | Alabama | 1015 | 8594 | 140 |
839314 | 839314 | 2020-12-18 | Calhoun | Alabama | 1015 | 8459 | 137 |
836069 | 836069 | 2020-12-17 | Calhoun | Alabama | 1015 | 8290 | 136 |
832823 | 832823 | 2020-12-16 | Calhoun | Alabama | 1015 | 8072 | 135 |
829576 | 829576 | 2020-12-15 | Calhoun | Alabama | 1015 | 7966 | 130 |
826330 | 826330 | 2020-12-14 | Calhoun | Alabama | 1015 | 7872 | 129 |
823083 | 823083 | 2020-12-13 | Calhoun | Alabama | 1015 | 7813 | 129 |
819837 | 819837 | 2020-12-12 | Calhoun | Alabama | 1015 | 7760 | 129 |
816591 | 816591 | 2020-12-11 | Calhoun | Alabama | 1015 | 7658 | 129 |
813345 | 813345 | 2020-12-10 | Calhoun | Alabama | 1015 | 7534 | 129 |
810101 | 810101 | 2020-12-09 | Calhoun | Alabama | 1015 | 7392 | 127 |
806856 | 806856 | 2020-12-08 | Calhoun | Alabama | 1015 | 7300 | 127 |
803611 | 803611 | 2020-12-07 | Calhoun | Alabama | 1015 | 7165 | 127 |
800366 | 800366 | 2020-12-06 | Calhoun | Alabama | 1015 | 7096 | 127 |
797121 | 797121 | 2020-12-05 | Calhoun | Alabama | 1015 | 7027 | 127 |
793876 | 793876 | 2020-12-04 | Calhoun | Alabama | 1015 | 6939 | 126 |
790631 | 790631 | 2020-12-03 | Calhoun | Alabama | 1015 | 6809 | 121 |
787386 | 787386 | 2020-12-02 | Calhoun | Alabama | 1015 | 6695 | 121 |
784142 | 784142 | 2020-12-01 | Calhoun | Alabama | 1015 | 6598 | 121 |
780897 | 780897 | 2020-11-30 | Calhoun | Alabama | 1015 | 6430 | 121 |
777651 | 777651 | 2020-11-29 | Calhoun | Alabama | 1015 | 6366 | 121 |
774406 | 774406 | 2020-11-28 | Calhoun | Alabama | 1015 | 6301 | 119 |
771161 | 771161 | 2020-11-27 | Calhoun | Alabama | 1015 | 6240 | 119 |
767915 | 767915 | 2020-11-26 | Calhoun | Alabama | 1015 | 6215 | 119 |
764670 | 764670 | 2020-11-25 | Calhoun | Alabama | 1015 | 6112 | 115 |
761425 | 761425 | 2020-11-24 | Calhoun | Alabama | 1015 | 6049 | 113 |
758180 | 758180 | 2020-11-23 | Calhoun | Alabama | 1015 | 5997 | 113 |
754933 | 754933 | 2020-11-22 | Calhoun | Alabama | 1015 | 5964 | 113 |
751687 | 751687 | 2020-11-21 | Calhoun | Alabama | 1015 | 5924 | 113 |
748441 | 748441 | 2020-11-20 | Calhoun | Alabama | 1015 | 5896 | 113 |
745195 | 745195 | 2020-11-19 | Calhoun | Alabama | 1015 | 5814 | 111 |
741948 | 741948 | 2020-11-18 | Calhoun | Alabama | 1015 | 5764 | 95 |
738701 | 738701 | 2020-11-17 | Calhoun | Alabama | 1015 | 5702 | 77 |
735457 | 735457 | 2020-11-16 | Calhoun | Alabama | 1015 | 5666 | 77 |
732211 | 732211 | 2020-11-15 | Calhoun | Alabama | 1015 | 5608 | 77 |
728966 | 728966 | 2020-11-14 | Calhoun | Alabama | 1015 | 5470 | 77 |
725723 | 725723 | 2020-11-13 | Calhoun | Alabama | 1015 | 5429 | 77 |
722480 | 722480 | 2020-11-12 | Calhoun | Alabama | 1015 | 5345 | 77 |
719237 | 719237 | 2020-11-11 | Calhoun | Alabama | 1015 | 5282 | 77 |
715994 | 715994 | 2020-11-10 | Calhoun | Alabama | 1015 | 5254 | 68 |
712750 | 712750 | 2020-11-09 | Calhoun | Alabama | 1015 | 5217 | 67 |
709506 | 709506 | 2020-11-08 | Calhoun | Alabama | 1015 | 5181 | 67 |
706262 | 706262 | 2020-11-07 | Calhoun | Alabama | 1015 | 5153 | 67 |
703019 | 703019 | 2020-11-06 | Calhoun | Alabama | 1015 | 5077 | 67 |
699776 | 699776 | 2020-11-05 | Calhoun | Alabama | 1015 | 5039 | 66 |
696532 | 696532 | 2020-11-04 | Calhoun | Alabama | 1015 | 5001 | 65 |
693290 | 693290 | 2020-11-03 | Calhoun | Alabama | 1015 | 4951 | 65 |
690047 | 690047 | 2020-11-02 | Calhoun | Alabama | 1015 | 4925 | 65 |
686802 | 686802 | 2020-11-01 | Calhoun | Alabama | 1015 | 4892 | 65 |
683558 | 683558 | 2020-10-31 | Calhoun | Alabama | 1015 | 4861 | 65 |
680315 | 680315 | 2020-10-30 | Calhoun | Alabama | 1015 | 4806 | 63 |
677072 | 677072 | 2020-10-29 | Calhoun | Alabama | 1015 | 4765 | 62 |
673829 | 673829 | 2020-10-28 | Calhoun | Alabama | 1015 | 4689 | 62 |
670587 | 670587 | 2020-10-27 | Calhoun | Alabama | 1015 | 4647 | 61 |
667344 | 667344 | 2020-10-26 | Calhoun | Alabama | 1015 | 4621 | 61 |
664099 | 664099 | 2020-10-25 | Calhoun | Alabama | 1015 | 4599 | 61 |
660855 | 660855 | 2020-10-24 | Calhoun | Alabama | 1015 | 4567 | 61 |
657611 | 657611 | 2020-10-23 | Calhoun | Alabama | 1015 | 4224 | 61 |
654366 | 654366 | 2020-10-22 | Calhoun | Alabama | 1015 | 4189 | 60 |
651121 | 651121 | 2020-10-21 | Calhoun | Alabama | 1015 | 4160 | 59 |
647877 | 647877 | 2020-10-20 | Calhoun | Alabama | 1015 | 4127 | 59 |
644632 | 644632 | 2020-10-19 | Calhoun | Alabama | 1015 | 4102 | 59 |
641384 | 641384 | 2020-10-18 | Calhoun | Alabama | 1015 | 4084 | 59 |
638137 | 638137 | 2020-10-17 | Calhoun | Alabama | 1015 | 4066 | 59 |
634892 | 634892 | 2020-10-16 | Calhoun | Alabama | 1015 | 4003 | 59 |
631647 | 631647 | 2020-10-15 | Calhoun | Alabama | 1015 | 3949 | 59 |
628403 | 628403 | 2020-10-14 | Calhoun | Alabama | 1015 | 3922 | 57 |
625160 | 625160 | 2020-10-13 | Calhoun | Alabama | 1015 | 3897 | 49 |
621917 | 621917 | 2020-10-12 | Calhoun | Alabama | 1015 | 3861 | 49 |
618674 | 618674 | 2020-10-11 | Calhoun | Alabama | 1015 | 3841 | 49 |
615432 | 615432 | 2020-10-10 | Calhoun | Alabama | 1015 | 3823 | 49 |
612191 | 612191 | 2020-10-09 | Calhoun | Alabama | 1015 | 3803 | 47 |
608949 | 608949 | 2020-10-08 | Calhoun | Alabama | 1015 | 3752 | 45 |
605706 | 605706 | 2020-10-07 | Calhoun | Alabama | 1015 | 3743 | 45 |
602464 | 602464 | 2020-10-06 | Calhoun | Alabama | 1015 | 3730 | 45 |
599221 | 599221 | 2020-10-05 | Calhoun | Alabama | 1015 | 3705 | 44 |
595978 | 595978 | 2020-10-04 | Calhoun | Alabama | 1015 | 3679 | 44 |
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);