ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-11-10" 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 |
---|---|---|---|---|---|---|---|
715987 | 715987 | 2020-11-10 | Autauga | Alabama | 1001 | 2328 | 30 |
715988 | 715988 | 2020-11-10 | Baldwin | Alabama | 1003 | 7348 | 84 |
715989 | 715989 | 2020-11-10 | Barbour | Alabama | 1005 | 1107 | 9 |
715990 | 715990 | 2020-11-10 | Bibb | Alabama | 1007 | 948 | 17 |
715991 | 715991 | 2020-11-10 | Blount | Alabama | 1009 | 2378 | 26 |
715992 | 715992 | 2020-11-10 | Bullock | Alabama | 1011 | 665 | 18 |
715993 | 715993 | 2020-11-10 | Butler | Alabama | 1013 | 1061 | 41 |
715994 | 715994 | 2020-11-10 | Calhoun | Alabama | 1015 | 5254 | 68 |
715995 | 715995 | 2020-11-10 | Chambers | Alabama | 1017 | 1507 | 48 |
715996 | 715996 | 2020-11-10 | Cherokee | Alabama | 1019 | 857 | 15 |
715997 | 715997 | 2020-11-10 | Chilton | Alabama | 1021 | 2027 | 35 |
715998 | 715998 | 2020-11-10 | Choctaw | Alabama | 1023 | 407 | 12 |
715999 | 715999 | 2020-11-10 | Clarke | Alabama | 1025 | 1451 | 18 |
716000 | 716000 | 2020-11-10 | Clay | Alabama | 1027 | 819 | 13 |
716001 | 716001 | 2020-11-10 | Cleburne | Alabama | 1029 | 630 | 11 |
716002 | 716002 | 2020-11-10 | Coffee | Alabama | 1031 | 2018 | 12 |
716003 | 716003 | 2020-11-10 | Colbert | Alabama | 1033 | 2515 | 33 |
716004 | 716004 | 2020-11-10 | Conecuh | Alabama | 1035 | 616 | 13 |
716005 | 716005 | 2020-11-10 | Coosa | Alabama | 1037 | 240 | 3 |
716006 | 716006 | 2020-11-10 | Covington | Alabama | 1039 | 1967 | 32 |
716007 | 716007 | 2020-11-10 | Crenshaw | Alabama | 1041 | 654 | 30 |
716008 | 716008 | 2020-11-10 | Cullman | Alabama | 1043 | 3328 | 29 |
716009 | 716009 | 2020-11-10 | Dale | Alabama | 1045 | 2070 | 55 |
716010 | 716010 | 2020-11-10 | Dallas | Alabama | 1047 | 2008 | 28 |
716011 | 716011 | 2020-11-10 | DeKalb | Alabama | 1049 | 3942 | 34 |
716012 | 716012 | 2020-11-10 | Elmore | Alabama | 1051 | 3495 | 60 |
716013 | 716013 | 2020-11-10 | Escambia | Alabama | 1053 | 1835 | 31 |
716014 | 716014 | 2020-11-10 | Etowah | Alabama | 1055 | 4967 | 60 |
716015 | 716015 | 2020-11-10 | Fayette | Alabama | 1057 | 684 | 15 |
716016 | 716016 | 2020-11-10 | Franklin | Alabama | 1059 | 2261 | 34 |
716017 | 716017 | 2020-11-10 | Geneva | Alabama | 1061 | 1038 | 8 |
716018 | 716018 | 2020-11-10 | Greene | Alabama | 1063 | 361 | 17 |
716019 | 716019 | 2020-11-10 | Hale | Alabama | 1065 | 833 | 30 |
716020 | 716020 | 2020-11-10 | Henry | Alabama | 1067 | 787 | 6 |
716021 | 716021 | 2020-11-10 | Houston | Alabama | 1069 | 4543 | 36 |
716022 | 716022 | 2020-11-10 | Jackson | Alabama | 1071 | 2509 | 23 |
716023 | 716023 | 2020-11-10 | Jefferson | Alabama | 1073 | 26232 | 409 |
716024 | 716024 | 2020-11-10 | Lamar | Alabama | 1075 | 565 | 7 |
716025 | 716025 | 2020-11-10 | Lauderdale | Alabama | 1077 | 3011 | 49 |
716026 | 716026 | 2020-11-10 | Lawrence | Alabama | 1079 | 1014 | 35 |
716027 | 716027 | 2020-11-10 | Lee | Alabama | 1081 | 6952 | 65 |
716028 | 716028 | 2020-11-10 | Limestone | Alabama | 1083 | 3414 | 37 |
716029 | 716029 | 2020-11-10 | Lowndes | Alabama | 1085 | 749 | 29 |
716030 | 716030 | 2020-11-10 | Macon | Alabama | 1087 | 618 | 20 |
716031 | 716031 | 2020-11-10 | Madison | Alabama | 1089 | 10524 | 108 |
716032 | 716032 | 2020-11-10 | Marengo | Alabama | 1091 | 1103 | 24 |
716033 | 716033 | 2020-11-10 | Marion | Alabama | 1093 | 1222 | 31 |
716034 | 716034 | 2020-11-10 | Marshall | Alabama | 1095 | 4910 | 53 |
716035 | 716035 | 2020-11-10 | Mobile | Alabama | 1097 | 17998 | 334 |
716036 | 716036 | 2020-11-10 | Monroe | Alabama | 1099 | 701 | 10 |
716037 | 716037 | 2020-11-10 | Montgomery | Alabama | 1101 | 11225 | 221 |
716038 | 716038 | 2020-11-10 | Morgan | Alabama | 1103 | 4974 | 40 |
716039 | 716039 | 2020-11-10 | Perry | Alabama | 1105 | 626 | 6 |
716040 | 716040 | 2020-11-10 | Pickens | Alabama | 1107 | 1017 | 18 |
716041 | 716041 | 2020-11-10 | Pike | Alabama | 1109 | 1437 | 14 |
716042 | 716042 | 2020-11-10 | Randolph | Alabama | 1111 | 896 | 19 |
716043 | 716043 | 2020-11-10 | Russell | Alabama | 1113 | 2028 | 3 |
716044 | 716044 | 2020-11-10 | Shelby | Alabama | 1117 | 8423 | 72 |
716045 | 716045 | 2020-11-10 | St. Clair | Alabama | 1115 | 3537 | 52 |
716046 | 716046 | 2020-11-10 | Sumter | Alabama | 1119 | 510 | 21 |
716047 | 716047 | 2020-11-10 | Talladega | Alabama | 1121 | 2992 | 40 |
716048 | 716048 | 2020-11-10 | Tallapoosa | Alabama | 1123 | 1506 | 87 |
716049 | 716049 | 2020-11-10 | Tuscaloosa | Alabama | 1125 | 11298 | 147 |
716050 | 716050 | 2020-11-10 | Walker | Alabama | 1127 | 3155 | 96 |
716051 | 716051 | 2020-11-10 | Washington | Alabama | 1129 | 828 | 12 |
716052 | 716052 | 2020-11-10 | Wilcox | Alabama | 1131 | 594 | 12 |
716053 | 716053 | 2020-11-10 | Winston | Alabama | 1133 | 1050 | 15 |
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);