ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2022-03-24" 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 |
---|---|---|---|---|---|---|---|
2336804 | 2336804 | 2022-03-24 | Autauga | Alabama | 1001 | 15607 | 209 |
2336805 | 2336805 | 2022-03-24 | Baldwin | Alabama | 1003 | 55365 | 673 |
2336806 | 2336806 | 2022-03-24 | Barbour | Alabama | 1005 | 5478 | 97 |
2336807 | 2336807 | 2022-03-24 | Bibb | Alabama | 1007 | 6415 | 101 |
2336808 | 2336808 | 2022-03-24 | Blount | Alabama | 1009 | 14894 | 230 |
2336809 | 2336809 | 2022-03-24 | Bullock | Alabama | 1011 | 2283 | 52 |
2336810 | 2336810 | 2022-03-24 | Butler | Alabama | 1013 | 5048 | 127 |
2336811 | 2336811 | 2022-03-24 | Calhoun | Alabama | 1015 | 32343 | 612 |
2336812 | 2336812 | 2022-03-24 | Chambers | Alabama | 1017 | 8464 | 160 |
2336813 | 2336813 | 2022-03-24 | Cherokee | Alabama | 1019 | 5109 | 85 |
2336814 | 2336814 | 2022-03-24 | Chilton | Alabama | 1021 | 10991 | 199 |
2336815 | 2336815 | 2022-03-24 | Choctaw | Alabama | 1023 | 2044 | 36 |
2336816 | 2336816 | 2022-03-24 | Clarke | Alabama | 1025 | 7086 | 98 |
2336817 | 2336817 | 2022-03-24 | Clay | Alabama | 1027 | 4083 | 81 |
2336818 | 2336818 | 2022-03-24 | Cleburne | Alabama | 1029 | 3556 | 69 |
2336819 | 2336819 | 2022-03-24 | Coffee | Alabama | 1031 | 13343 | 230 |
2336820 | 2336820 | 2022-03-24 | Colbert | Alabama | 1033 | 16269 | 254 |
2336821 | 2336821 | 2022-03-24 | Conecuh | Alabama | 1035 | 2852 | 71 |
2336822 | 2336822 | 2022-03-24 | Coosa | Alabama | 1037 | 2950 | 58 |
2336823 | 2336823 | 2022-03-24 | Covington | Alabama | 1039 | 9276 | 225 |
2336824 | 2336824 | 2022-03-24 | Crenshaw | Alabama | 1041 | 3786 | 97 |
2336825 | 2336825 | 2022-03-24 | Cullman | Alabama | 1043 | 24493 | 364 |
2336826 | 2336826 | 2022-03-24 | Dale | Alabama | 1045 | 12503 | 227 |
2336827 | 2336827 | 2022-03-24 | Dallas | Alabama | 1047 | 8378 | 241 |
2336828 | 2336828 | 2022-03-24 | DeKalb | Alabama | 1049 | 18734 | 323 |
2336829 | 2336829 | 2022-03-24 | Elmore | Alabama | 1051 | 22963 | 340 |
2336830 | 2336830 | 2022-03-24 | Escambia | Alabama | 1053 | 9983 | 167 |
2336831 | 2336831 | 2022-03-24 | Etowah | Alabama | 1055 | 28768 | 637 |
2336832 | 2336832 | 2022-03-24 | Fayette | Alabama | 1057 | 4972 | 94 |
2336833 | 2336833 | 2022-03-24 | Franklin | Alabama | 1059 | 9851 | 137 |
2336834 | 2336834 | 2022-03-24 | Geneva | Alabama | 1061 | 6285 | 163 |
2336835 | 2336835 | 2022-03-24 | Greene | Alabama | 1063 | 1865 | 48 |
2336836 | 2336836 | 2022-03-24 | Hale | Alabama | 1065 | 4697 | 104 |
2336837 | 2336837 | 2022-03-24 | Henry | Alabama | 1067 | 4452 | 73 |
2336838 | 2336838 | 2022-03-24 | Houston | Alabama | 1069 | 25009 | 495 |
2336839 | 2336839 | 2022-03-24 | Jackson | Alabama | 1071 | 15013 | 234 |
2336840 | 2336840 | 2022-03-24 | Jefferson | Alabama | 1073 | 184298 | 2317 |
2336841 | 2336841 | 2022-03-24 | Lamar | Alabama | 1075 | 3711 | 63 |
2336842 | 2336842 | 2022-03-24 | Lauderdale | Alabama | 1077 | 24050 | 386 |
2336843 | 2336843 | 2022-03-24 | Lawrence | Alabama | 1079 | 7635 | 154 |
2336844 | 2336844 | 2022-03-24 | Lee | Alabama | 1081 | 37609 | 330 |
2336845 | 2336845 | 2022-03-24 | Limestone | Alabama | 1083 | 24836 | 286 |
2336846 | 2336846 | 2022-03-24 | Lowndes | Alabama | 1085 | 2609 | 75 |
2336847 | 2336847 | 2022-03-24 | Macon | Alabama | 1087 | 3857 | 82 |
2336848 | 2336848 | 2022-03-24 | Madison | Alabama | 1089 | 88955 | 939 |
2336849 | 2336849 | 2022-03-24 | Marengo | Alabama | 1091 | 5168 | 106 |
2336850 | 2336850 | 2022-03-24 | Marion | Alabama | 1093 | 8070 | 151 |
2336851 | 2336851 | 2022-03-24 | Marshall | Alabama | 1095 | 27323 | 388 |
2336852 | 2336852 | 2022-03-24 | Mobile | Alabama | 1097 | 113042 | 1614 |
2336853 | 2336853 | 2022-03-24 | Monroe | Alabama | 1099 | 5265 | 80 |
2336854 | 2336854 | 2022-03-24 | Montgomery | Alabama | 1101 | 54651 | 923 |
2336855 | 2336855 | 2022-03-24 | Morgan | Alabama | 1103 | 35960 | 505 |
2336856 | 2336856 | 2022-03-24 | Perry | Alabama | 1105 | 2091 | 44 |
2336857 | 2336857 | 2022-03-24 | Pickens | Alabama | 1107 | 5243 | 101 |
2336858 | 2336858 | 2022-03-24 | Pike | Alabama | 1109 | 7426 | 133 |
2336859 | 2336859 | 2022-03-24 | Randolph | Alabama | 1111 | 5078 | 74 |
2336860 | 2336860 | 2022-03-24 | Russell | Alabama | 1113 | 10026 | 86 |
2336861 | 2336861 | 2022-03-24 | Shelby | Alabama | 1117 | 60400 | 439 |
2336862 | 2336862 | 2022-03-24 | St. Clair | Alabama | 1115 | 25218 | 411 |
2336863 | 2336863 | 2022-03-24 | Sumter | Alabama | 1119 | 2570 | 49 |
2336864 | 2336864 | 2022-03-24 | Talladega | Alabama | 1121 | 22270 | 371 |
2336865 | 2336865 | 2022-03-24 | Tallapoosa | Alabama | 1123 | 11369 | 232 |
2336866 | 2336866 | 2022-03-24 | Tuscaloosa | Alabama | 1125 | 55709 | 758 |
2336867 | 2336867 | 2022-03-24 | Walker | Alabama | 1127 | 18533 | 433 |
2336868 | 2336868 | 2022-03-24 | Washington | Alabama | 1129 | 3724 | 59 |
2336869 | 2336869 | 2022-03-24 | Wilcox | Alabama | 1131 | 2872 | 45 |
2336870 | 2336870 | 2022-03-24 | Winston | Alabama | 1133 | 7568 | 128 |
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);