ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where "date" is on date 2020-11-13 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
725716 | 725716 | 2020-11-13 | Autauga | Alabama | 1001 | 2417 | 36 |
725717 | 725717 | 2020-11-13 | Baldwin | Alabama | 1003 | 7523 | 84 |
725718 | 725718 | 2020-11-13 | Barbour | Alabama | 1005 | 1117 | 9 |
725719 | 725719 | 2020-11-13 | Bibb | Alabama | 1007 | 973 | 17 |
725720 | 725720 | 2020-11-13 | Blount | Alabama | 1009 | 2488 | 34 |
725721 | 725721 | 2020-11-13 | Bullock | Alabama | 1011 | 673 | 19 |
725722 | 725722 | 2020-11-13 | Butler | Alabama | 1013 | 1068 | 41 |
725723 | 725723 | 2020-11-13 | Calhoun | Alabama | 1015 | 5429 | 77 |
725724 | 725724 | 2020-11-13 | Chambers | Alabama | 1017 | 1545 | 48 |
725725 | 725725 | 2020-11-13 | Cherokee | Alabama | 1019 | 892 | 15 |
725726 | 725726 | 2020-11-13 | Chilton | Alabama | 1021 | 2053 | 36 |
725727 | 725727 | 2020-11-13 | Choctaw | Alabama | 1023 | 409 | 12 |
725728 | 725728 | 2020-11-13 | Clarke | Alabama | 1025 | 1485 | 18 |
725729 | 725729 | 2020-11-13 | Clay | Alabama | 1027 | 833 | 13 |
725730 | 725730 | 2020-11-13 | Cleburne | Alabama | 1029 | 655 | 11 |
725731 | 725731 | 2020-11-13 | Coffee | Alabama | 1031 | 2116 | 12 |
725732 | 725732 | 2020-11-13 | Colbert | Alabama | 1033 | 2681 | 38 |
725733 | 725733 | 2020-11-13 | Conecuh | Alabama | 1035 | 637 | 14 |
725734 | 725734 | 2020-11-13 | Coosa | Alabama | 1037 | 257 | 3 |
725735 | 725735 | 2020-11-13 | Covington | Alabama | 1039 | 2008 | 32 |
725736 | 725736 | 2020-11-13 | Crenshaw | Alabama | 1041 | 669 | 30 |
725737 | 725737 | 2020-11-13 | Cullman | Alabama | 1043 | 3596 | 30 |
725738 | 725738 | 2020-11-13 | Dale | Alabama | 1045 | 2142 | 54 |
725739 | 725739 | 2020-11-13 | Dallas | Alabama | 1047 | 2043 | 28 |
725740 | 725740 | 2020-11-13 | DeKalb | Alabama | 1049 | 4118 | 34 |
725741 | 725741 | 2020-11-13 | Elmore | Alabama | 1051 | 3587 | 61 |
725742 | 725742 | 2020-11-13 | Escambia | Alabama | 1053 | 1862 | 31 |
725743 | 725743 | 2020-11-13 | Etowah | Alabama | 1055 | 5187 | 60 |
725744 | 725744 | 2020-11-13 | Fayette | Alabama | 1057 | 714 | 15 |
725745 | 725745 | 2020-11-13 | Franklin | Alabama | 1059 | 2309 | 33 |
725746 | 725746 | 2020-11-13 | Geneva | Alabama | 1061 | 1078 | 8 |
725747 | 725747 | 2020-11-13 | Greene | Alabama | 1063 | 369 | 17 |
725748 | 725748 | 2020-11-13 | Hale | Alabama | 1065 | 851 | 30 |
725749 | 725749 | 2020-11-13 | Henry | Alabama | 1067 | 807 | 6 |
725750 | 725750 | 2020-11-13 | Houston | Alabama | 1069 | 4688 | 37 |
725751 | 725751 | 2020-11-13 | Jackson | Alabama | 1071 | 2644 | 23 |
725752 | 725752 | 2020-11-13 | Jefferson | Alabama | 1073 | 27264 | 454 |
725753 | 725753 | 2020-11-13 | Lamar | Alabama | 1075 | 579 | 7 |
725754 | 725754 | 2020-11-13 | Lauderdale | Alabama | 1077 | 3221 | 51 |
725755 | 725755 | 2020-11-13 | Lawrence | Alabama | 1079 | 1050 | 35 |
725756 | 725756 | 2020-11-13 | Lee | Alabama | 1081 | 7122 | 65 |
725757 | 725757 | 2020-11-13 | Limestone | Alabama | 1083 | 3577 | 41 |
725758 | 725758 | 2020-11-13 | Lowndes | Alabama | 1085 | 755 | 29 |
725759 | 725759 | 2020-11-13 | Macon | Alabama | 1087 | 646 | 20 |
725760 | 725760 | 2020-11-13 | Madison | Alabama | 1089 | 11002 | 118 |
725761 | 725761 | 2020-11-13 | Marengo | Alabama | 1091 | 1123 | 24 |
725762 | 725762 | 2020-11-13 | Marion | Alabama | 1093 | 1258 | 32 |
725763 | 725763 | 2020-11-13 | Marshall | Alabama | 1095 | 5159 | 53 |
725764 | 725764 | 2020-11-13 | Mobile | Alabama | 1097 | 18319 | 336 |
725765 | 725765 | 2020-11-13 | Monroe | Alabama | 1099 | 719 | 10 |
725766 | 725766 | 2020-11-13 | Montgomery | Alabama | 1101 | 11449 | 221 |
725767 | 725767 | 2020-11-13 | Morgan | Alabama | 1103 | 5270 | 41 |
725768 | 725768 | 2020-11-13 | Perry | Alabama | 1105 | 634 | 6 |
725769 | 725769 | 2020-11-13 | Pickens | Alabama | 1107 | 1053 | 18 |
725770 | 725770 | 2020-11-13 | Pike | Alabama | 1109 | 1482 | 14 |
725771 | 725771 | 2020-11-13 | Randolph | Alabama | 1111 | 933 | 20 |
725772 | 725772 | 2020-11-13 | Russell | Alabama | 1113 | 2047 | 3 |
725773 | 725773 | 2020-11-13 | Shelby | Alabama | 1117 | 8792 | 73 |
725774 | 725774 | 2020-11-13 | St. Clair | Alabama | 1115 | 3668 | 54 |
725775 | 725775 | 2020-11-13 | Sumter | Alabama | 1119 | 521 | 21 |
725776 | 725776 | 2020-11-13 | Talladega | Alabama | 1121 | 3083 | 41 |
725777 | 725777 | 2020-11-13 | Tallapoosa | Alabama | 1123 | 1564 | 88 |
725778 | 725778 | 2020-11-13 | Tuscaloosa | Alabama | 1125 | 11566 | 148 |
725779 | 725779 | 2020-11-13 | Walker | Alabama | 1127 | 3252 | 96 |
725780 | 725780 | 2020-11-13 | Washington | Alabama | 1129 | 865 | 12 |
725781 | 725781 | 2020-11-13 | Wilcox | Alabama | 1131 | 602 | 12 |
725782 | 725782 | 2020-11-13 | Winston | Alabama | 1133 | 1119 | 22 |
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);