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 2022-02-12 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2206725 | 2206725 | 2022-02-12 | Autauga | Alabama | 1001 | 15288 | 176 |
2206726 | 2206726 | 2022-02-12 | Baldwin | Alabama | 1003 | 54391 | 626 |
2206727 | 2206727 | 2022-02-12 | Barbour | Alabama | 1005 | 5408 | 89 |
2206728 | 2206728 | 2022-02-12 | Bibb | Alabama | 1007 | 6307 | 97 |
2206729 | 2206729 | 2022-02-12 | Blount | Alabama | 1009 | 14545 | 213 |
2206730 | 2206730 | 2022-02-12 | Bullock | Alabama | 1011 | 2266 | 49 |
2206731 | 2206731 | 2022-02-12 | Butler | Alabama | 1013 | 4992 | 112 |
2206732 | 2206732 | 2022-02-12 | Calhoun | Alabama | 1015 | 31173 | 568 |
2206733 | 2206733 | 2022-02-12 | Chambers | Alabama | 1017 | 8369 | 149 |
2206734 | 2206734 | 2022-02-12 | Cherokee | Alabama | 1019 | 4998 | 74 |
2206735 | 2206735 | 2022-02-12 | Chilton | Alabama | 1021 | 10346 | 185 |
2206736 | 2206736 | 2022-02-12 | Choctaw | Alabama | 1023 | 1935 | 33 |
2206737 | 2206737 | 2022-02-12 | Clarke | Alabama | 1025 | 6958 | 93 |
2206738 | 2206738 | 2022-02-12 | Clay | Alabama | 1027 | 4033 | 73 |
2206739 | 2206739 | 2022-02-12 | Cleburne | Alabama | 1029 | 3502 | 65 |
2206740 | 2206740 | 2022-02-12 | Coffee | Alabama | 1031 | 13196 | 213 |
2206741 | 2206741 | 2022-02-12 | Colbert | Alabama | 1033 | 15900 | 224 |
2206742 | 2206742 | 2022-02-12 | Conecuh | Alabama | 1035 | 2816 | 63 |
2206743 | 2206743 | 2022-02-12 | Coosa | Alabama | 1037 | 2863 | 53 |
2206744 | 2206744 | 2022-02-12 | Covington | Alabama | 1039 | 9129 | 212 |
2206745 | 2206745 | 2022-02-12 | Crenshaw | Alabama | 1041 | 3741 | 84 |
2206746 | 2206746 | 2022-02-12 | Cullman | Alabama | 1043 | 24007 | 332 |
2206747 | 2206747 | 2022-02-12 | Dale | Alabama | 1045 | 12308 | 212 |
2206748 | 2206748 | 2022-02-12 | Dallas | Alabama | 1047 | 8165 | 226 |
2206749 | 2206749 | 2022-02-12 | DeKalb | Alabama | 1049 | 18326 | 300 |
2206750 | 2206750 | 2022-02-12 | Elmore | Alabama | 1051 | 22688 | 317 |
2206751 | 2206751 | 2022-02-12 | Escambia | Alabama | 1053 | 9877 | 153 |
2206752 | 2206752 | 2022-02-12 | Etowah | Alabama | 1055 | 28245 | 560 |
2206753 | 2206753 | 2022-02-12 | Fayette | Alabama | 1057 | 4520 | 89 |
2206754 | 2206754 | 2022-02-12 | Franklin | Alabama | 1059 | 9671 | 123 |
2206755 | 2206755 | 2022-02-12 | Geneva | Alabama | 1061 | 6099 | 146 |
2206756 | 2206756 | 2022-02-12 | Greene | Alabama | 1063 | 1786 | 48 |
2206757 | 2206757 | 2022-02-12 | Hale | Alabama | 1065 | 4512 | 96 |
2206758 | 2206758 | 2022-02-12 | Henry | Alabama | 1067 | 4383 | 68 |
2206759 | 2206759 | 2022-02-12 | Houston | Alabama | 1069 | 24567 | 458 |
2206760 | 2206760 | 2022-02-12 | Jackson | Alabama | 1071 | 14737 | 215 |
2206761 | 2206761 | 2022-02-12 | Jefferson | Alabama | 1073 | 180392 | 2147 |
2206762 | 2206762 | 2022-02-12 | Lamar | Alabama | 1075 | 3539 | 62 |
2206763 | 2206763 | 2022-02-12 | Lauderdale | Alabama | 1077 | 23535 | 349 |
2206764 | 2206764 | 2022-02-12 | Lawrence | Alabama | 1079 | 7399 | 145 |
2206765 | 2206765 | 2022-02-12 | Lee | Alabama | 1081 | 37243 | 290 |
2206766 | 2206766 | 2022-02-12 | Limestone | Alabama | 1083 | 24251 | 251 |
2206767 | 2206767 | 2022-02-12 | Lowndes | Alabama | 1085 | 2587 | 69 |
2206768 | 2206768 | 2022-02-12 | Macon | Alabama | 1087 | 3795 | 72 |
2206769 | 2206769 | 2022-02-12 | Madison | Alabama | 1089 | 86601 | 837 |
2206770 | 2206770 | 2022-02-12 | Marengo | Alabama | 1091 | 4685 | 97 |
2206771 | 2206771 | 2022-02-12 | Marion | Alabama | 1093 | 7843 | 139 |
2206772 | 2206772 | 2022-02-12 | Marshall | Alabama | 1095 | 26886 | 349 |
2206773 | 2206773 | 2022-02-12 | Mobile | Alabama | 1097 | 110510 | 1514 |
2206774 | 2206774 | 2022-02-12 | Monroe | Alabama | 1099 | 5214 | 71 |
2206775 | 2206775 | 2022-02-12 | Montgomery | Alabama | 1101 | 53829 | 832 |
2206776 | 2206776 | 2022-02-12 | Morgan | Alabama | 1103 | 35263 | 461 |
2206777 | 2206777 | 2022-02-12 | Perry | Alabama | 1105 | 2012 | 41 |
2206778 | 2206778 | 2022-02-12 | Pickens | Alabama | 1107 | 4998 | 95 |
2206779 | 2206779 | 2022-02-12 | Pike | Alabama | 1109 | 7333 | 119 |
2206780 | 2206780 | 2022-02-12 | Randolph | Alabama | 1111 | 5016 | 72 |
2206781 | 2206781 | 2022-02-12 | Russell | Alabama | 1113 | 9880 | 75 |
2206782 | 2206782 | 2022-02-12 | Shelby | Alabama | 1117 | 58078 | 404 |
2206783 | 2206783 | 2022-02-12 | St. Clair | Alabama | 1115 | 24659 | 384 |
2206784 | 2206784 | 2022-02-12 | Sumter | Alabama | 1119 | 2366 | 44 |
2206785 | 2206785 | 2022-02-12 | Talladega | Alabama | 1121 | 21610 | 331 |
2206786 | 2206786 | 2022-02-12 | Tallapoosa | Alabama | 1123 | 11181 | 216 |
2206787 | 2206787 | 2022-02-12 | Tuscaloosa | Alabama | 1125 | 53329 | 701 |
2206788 | 2206788 | 2022-02-12 | Walker | Alabama | 1127 | 18135 | 401 |
2206789 | 2206789 | 2022-02-12 | Washington | Alabama | 1129 | 3630 | 53 |
2206790 | 2206790 | 2022-02-12 | Wilcox | Alabama | 1131 | 2813 | 40 |
2206791 | 2206791 | 2022-02-12 | Winston | Alabama | 1133 | 7359 | 116 |
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);