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 |
---|---|---|---|---|---|---|---|
1050266 | 1050266 | 2021-02-21 | Calhoun | Alabama | 1015 | 12940 | 278 |
1047019 | 1047019 | 2021-02-20 | Calhoun | Alabama | 1015 | 12915 | 278 |
1043774 | 1043774 | 2021-02-19 | Calhoun | Alabama | 1015 | 12860 | 277 |
1040529 | 1040529 | 2021-02-18 | Calhoun | Alabama | 1015 | 12833 | 265 |
1037284 | 1037284 | 2021-02-17 | Calhoun | Alabama | 1015 | 12784 | 264 |
1034039 | 1034039 | 2021-02-16 | Calhoun | Alabama | 1015 | 12756 | 263 |
1030793 | 1030793 | 2021-02-15 | Calhoun | Alabama | 1015 | 12725 | 263 |
1027546 | 1027546 | 2021-02-14 | Calhoun | Alabama | 1015 | 12700 | 263 |
1024301 | 1024301 | 2021-02-13 | Calhoun | Alabama | 1015 | 12629 | 263 |
1021056 | 1021056 | 2021-02-12 | Calhoun | Alabama | 1015 | 12577 | 262 |
1017811 | 1017811 | 2021-02-11 | Calhoun | Alabama | 1015 | 12539 | 257 |
1014566 | 1014566 | 2021-02-10 | Calhoun | Alabama | 1015 | 12498 | 257 |
1011321 | 1011321 | 2021-02-09 | Calhoun | Alabama | 1015 | 12477 | 247 |
1008075 | 1008075 | 2021-02-08 | Calhoun | Alabama | 1015 | 12426 | 246 |
1004829 | 1004829 | 2021-02-07 | Calhoun | Alabama | 1015 | 12402 | 246 |
1001583 | 1001583 | 2021-02-06 | Calhoun | Alabama | 1015 | 12368 | 246 |
998337 | 998337 | 2021-02-05 | Calhoun | Alabama | 1015 | 12325 | 244 |
995091 | 995091 | 2021-02-04 | Calhoun | Alabama | 1015 | 12253 | 242 |
991845 | 991845 | 2021-02-03 | Calhoun | Alabama | 1015 | 12179 | 239 |
988599 | 988599 | 2021-02-02 | Calhoun | Alabama | 1015 | 12102 | 235 |
985352 | 985352 | 2021-02-01 | Calhoun | Alabama | 1015 | 12062 | 232 |
982105 | 982105 | 2021-01-31 | Calhoun | Alabama | 1015 | 12011 | 232 |
978859 | 978859 | 2021-01-30 | Calhoun | Alabama | 1015 | 11918 | 232 |
975614 | 975614 | 2021-01-29 | Calhoun | Alabama | 1015 | 11918 | 232 |
972369 | 972369 | 2021-01-28 | Calhoun | Alabama | 1015 | 11833 | 231 |
969124 | 969124 | 2021-01-27 | Calhoun | Alabama | 1015 | 11730 | 228 |
965880 | 965880 | 2021-01-26 | Calhoun | Alabama | 1015 | 11626 | 228 |
962635 | 962635 | 2021-01-25 | Calhoun | Alabama | 1015 | 11555 | 206 |
959390 | 959390 | 2021-01-24 | Calhoun | Alabama | 1015 | 11521 | 206 |
956144 | 956144 | 2021-01-23 | Calhoun | Alabama | 1015 | 11496 | 206 |
952899 | 952899 | 2021-01-22 | Calhoun | Alabama | 1015 | 11441 | 206 |
949654 | 949654 | 2021-01-21 | Calhoun | Alabama | 1015 | 11365 | 205 |
946408 | 946408 | 2021-01-20 | Calhoun | Alabama | 1015 | 11292 | 201 |
943161 | 943161 | 2021-01-19 | Calhoun | Alabama | 1015 | 11206 | 200 |
939916 | 939916 | 2021-01-18 | Calhoun | Alabama | 1015 | 11161 | 200 |
936671 | 936671 | 2021-01-17 | Calhoun | Alabama | 1015 | 11122 | 200 |
933426 | 933426 | 2021-01-16 | Calhoun | Alabama | 1015 | 11078 | 200 |
930181 | 930181 | 2021-01-15 | Calhoun | Alabama | 1015 | 10982 | 200 |
926936 | 926936 | 2021-01-14 | Calhoun | Alabama | 1015 | 10863 | 197 |
923690 | 923690 | 2021-01-13 | Calhoun | Alabama | 1015 | 10745 | 197 |
920445 | 920445 | 2021-01-12 | Calhoun | Alabama | 1015 | 10668 | 195 |
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 |
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);