ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1013 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
917199 | 917199 | 2021-01-11 | Butler | Alabama | 1013 | 1637 | 57 |
913954 | 913954 | 2021-01-10 | Butler | Alabama | 1013 | 1632 | 57 |
910709 | 910709 | 2021-01-09 | Butler | Alabama | 1013 | 1625 | 55 |
907464 | 907464 | 2021-01-08 | Butler | Alabama | 1013 | 1610 | 46 |
904218 | 904218 | 2021-01-07 | Butler | Alabama | 1013 | 1598 | 46 |
900973 | 900973 | 2021-01-06 | Butler | Alabama | 1013 | 1583 | 46 |
897728 | 897728 | 2021-01-05 | Butler | Alabama | 1013 | 1574 | 45 |
894482 | 894482 | 2021-01-04 | Butler | Alabama | 1013 | 1554 | 45 |
891236 | 891236 | 2021-01-03 | Butler | Alabama | 1013 | 1546 | 45 |
887989 | 887989 | 2021-01-02 | Butler | Alabama | 1013 | 1530 | 45 |
884744 | 884744 | 2021-01-01 | Butler | Alabama | 1013 | 1522 | 45 |
881499 | 881499 | 2020-12-31 | Butler | Alabama | 1013 | 1508 | 45 |
878254 | 878254 | 2020-12-30 | Butler | Alabama | 1013 | 1493 | 45 |
875009 | 875009 | 2020-12-29 | Butler | Alabama | 1013 | 1482 | 45 |
871764 | 871764 | 2020-12-28 | Butler | Alabama | 1013 | 1457 | 45 |
868519 | 868519 | 2020-12-27 | Butler | Alabama | 1013 | 1452 | 45 |
865274 | 865274 | 2020-12-26 | Butler | Alabama | 1013 | 1446 | 45 |
862029 | 862029 | 2020-12-25 | Butler | Alabama | 1013 | 1448 | 45 |
858784 | 858784 | 2020-12-24 | Butler | Alabama | 1013 | 1434 | 45 |
855539 | 855539 | 2020-12-23 | Butler | Alabama | 1013 | 1423 | 45 |
852294 | 852294 | 2020-12-22 | Butler | Alabama | 1013 | 1412 | 45 |
849049 | 849049 | 2020-12-21 | Butler | Alabama | 1013 | 1405 | 45 |
845804 | 845804 | 2020-12-20 | Butler | Alabama | 1013 | 1399 | 45 |
842558 | 842558 | 2020-12-19 | Butler | Alabama | 1013 | 1393 | 45 |
839313 | 839313 | 2020-12-18 | Butler | Alabama | 1013 | 1384 | 45 |
836068 | 836068 | 2020-12-17 | Butler | Alabama | 1013 | 1368 | 44 |
832822 | 832822 | 2020-12-16 | Butler | Alabama | 1013 | 1343 | 44 |
829575 | 829575 | 2020-12-15 | Butler | Alabama | 1013 | 1332 | 44 |
826329 | 826329 | 2020-12-14 | Butler | Alabama | 1013 | 1340 | 44 |
823082 | 823082 | 2020-12-13 | Butler | Alabama | 1013 | 1330 | 44 |
819836 | 819836 | 2020-12-12 | Butler | Alabama | 1013 | 1306 | 44 |
816590 | 816590 | 2020-12-11 | Butler | Alabama | 1013 | 1289 | 44 |
813344 | 813344 | 2020-12-10 | Butler | Alabama | 1013 | 1287 | 42 |
810100 | 810100 | 2020-12-09 | Butler | Alabama | 1013 | 1263 | 42 |
806855 | 806855 | 2020-12-08 | Butler | Alabama | 1013 | 1257 | 42 |
803610 | 803610 | 2020-12-07 | Butler | Alabama | 1013 | 1244 | 42 |
800365 | 800365 | 2020-12-06 | Butler | Alabama | 1013 | 1236 | 42 |
797120 | 797120 | 2020-12-05 | Butler | Alabama | 1013 | 1225 | 42 |
793875 | 793875 | 2020-12-04 | Butler | Alabama | 1013 | 1211 | 42 |
790630 | 790630 | 2020-12-03 | Butler | Alabama | 1013 | 1200 | 42 |
787385 | 787385 | 2020-12-02 | Butler | Alabama | 1013 | 1188 | 42 |
784141 | 784141 | 2020-12-01 | Butler | Alabama | 1013 | 1186 | 42 |
780896 | 780896 | 2020-11-30 | Butler | Alabama | 1013 | 1178 | 42 |
777650 | 777650 | 2020-11-29 | Butler | Alabama | 1013 | 1173 | 42 |
774405 | 774405 | 2020-11-28 | Butler | Alabama | 1013 | 1165 | 41 |
771160 | 771160 | 2020-11-27 | Butler | Alabama | 1013 | 1153 | 41 |
767914 | 767914 | 2020-11-26 | Butler | Alabama | 1013 | 1153 | 41 |
764669 | 764669 | 2020-11-25 | Butler | Alabama | 1013 | 1144 | 41 |
761424 | 761424 | 2020-11-24 | Butler | Alabama | 1013 | 1143 | 41 |
758179 | 758179 | 2020-11-23 | Butler | Alabama | 1013 | 1137 | 41 |
754932 | 754932 | 2020-11-22 | Butler | Alabama | 1013 | 1133 | 41 |
751686 | 751686 | 2020-11-21 | Butler | Alabama | 1013 | 1132 | 41 |
748440 | 748440 | 2020-11-20 | Butler | Alabama | 1013 | 1120 | 41 |
745194 | 745194 | 2020-11-19 | Butler | Alabama | 1013 | 1113 | 41 |
741947 | 741947 | 2020-11-18 | Butler | Alabama | 1013 | 1102 | 41 |
738700 | 738700 | 2020-11-17 | Butler | Alabama | 1013 | 1099 | 41 |
735456 | 735456 | 2020-11-16 | Butler | Alabama | 1013 | 1095 | 41 |
732210 | 732210 | 2020-11-15 | Butler | Alabama | 1013 | 1087 | 41 |
728965 | 728965 | 2020-11-14 | Butler | Alabama | 1013 | 1075 | 41 |
725722 | 725722 | 2020-11-13 | Butler | Alabama | 1013 | 1068 | 41 |
722479 | 722479 | 2020-11-12 | Butler | Alabama | 1013 | 1062 | 41 |
719236 | 719236 | 2020-11-11 | Butler | Alabama | 1013 | 1062 | 41 |
715993 | 715993 | 2020-11-10 | Butler | Alabama | 1013 | 1061 | 41 |
712749 | 712749 | 2020-11-09 | Butler | Alabama | 1013 | 1054 | 41 |
709505 | 709505 | 2020-11-08 | Butler | Alabama | 1013 | 1052 | 41 |
706261 | 706261 | 2020-11-07 | Butler | Alabama | 1013 | 1046 | 41 |
703018 | 703018 | 2020-11-06 | Butler | Alabama | 1013 | 1044 | 41 |
699775 | 699775 | 2020-11-05 | Butler | Alabama | 1013 | 1037 | 41 |
696531 | 696531 | 2020-11-04 | Butler | Alabama | 1013 | 1034 | 41 |
693289 | 693289 | 2020-11-03 | Butler | Alabama | 1013 | 1029 | 41 |
690046 | 690046 | 2020-11-02 | Butler | Alabama | 1013 | 1026 | 41 |
686801 | 686801 | 2020-11-01 | Butler | Alabama | 1013 | 1024 | 41 |
683557 | 683557 | 2020-10-31 | Butler | Alabama | 1013 | 1022 | 41 |
680314 | 680314 | 2020-10-30 | Butler | Alabama | 1013 | 1020 | 41 |
677071 | 677071 | 2020-10-29 | Butler | Alabama | 1013 | 1019 | 41 |
673828 | 673828 | 2020-10-28 | Butler | Alabama | 1013 | 1015 | 41 |
670586 | 670586 | 2020-10-27 | Butler | Alabama | 1013 | 1012 | 41 |
667343 | 667343 | 2020-10-26 | Butler | Alabama | 1013 | 1013 | 40 |
664098 | 664098 | 2020-10-25 | Butler | Alabama | 1013 | 1011 | 40 |
660854 | 660854 | 2020-10-24 | Butler | Alabama | 1013 | 1007 | 40 |
657610 | 657610 | 2020-10-23 | Butler | Alabama | 1013 | 1002 | 40 |
654365 | 654365 | 2020-10-22 | Butler | Alabama | 1013 | 1001 | 40 |
651120 | 651120 | 2020-10-21 | Butler | Alabama | 1013 | 998 | 40 |
647876 | 647876 | 2020-10-20 | Butler | Alabama | 1013 | 998 | 40 |
644631 | 644631 | 2020-10-19 | Butler | Alabama | 1013 | 998 | 40 |
641383 | 641383 | 2020-10-18 | Butler | Alabama | 1013 | 996 | 40 |
638136 | 638136 | 2020-10-17 | Butler | Alabama | 1013 | 990 | 40 |
634891 | 634891 | 2020-10-16 | Butler | Alabama | 1013 | 988 | 40 |
631646 | 631646 | 2020-10-15 | Butler | Alabama | 1013 | 982 | 40 |
628402 | 628402 | 2020-10-14 | Butler | Alabama | 1013 | 977 | 40 |
625159 | 625159 | 2020-10-13 | Butler | Alabama | 1013 | 968 | 40 |
621916 | 621916 | 2020-10-12 | Butler | Alabama | 1013 | 962 | 40 |
618673 | 618673 | 2020-10-11 | Butler | Alabama | 1013 | 958 | 40 |
615431 | 615431 | 2020-10-10 | Butler | Alabama | 1013 | 952 | 40 |
612190 | 612190 | 2020-10-09 | Butler | Alabama | 1013 | 943 | 40 |
608948 | 608948 | 2020-10-08 | Butler | Alabama | 1013 | 932 | 40 |
605705 | 605705 | 2020-10-07 | Butler | Alabama | 1013 | 933 | 40 |
602463 | 602463 | 2020-10-06 | Butler | Alabama | 1013 | 928 | 40 |
599220 | 599220 | 2020-10-05 | Butler | Alabama | 1013 | 927 | 40 |
595977 | 595977 | 2020-10-04 | Butler | Alabama | 1013 | 926 | 40 |
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);