ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-12-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 |
---|---|---|---|---|---|---|---|
819830 | 819830 | 2020-12-12 | Autauga | Alabama | 1001 | 3258 | 41 |
819831 | 819831 | 2020-12-12 | Baldwin | Alabama | 1003 | 10665 | 141 |
819832 | 819832 | 2020-12-12 | Barbour | Alabama | 1005 | 1269 | 30 |
819833 | 819833 | 2020-12-12 | Bibb | Alabama | 1007 | 1417 | 40 |
819834 | 819834 | 2020-12-12 | Blount | Alabama | 1009 | 3744 | 47 |
819835 | 819835 | 2020-12-12 | Bullock | Alabama | 1011 | 725 | 20 |
819836 | 819836 | 2020-12-12 | Butler | Alabama | 1013 | 1306 | 44 |
819837 | 819837 | 2020-12-12 | Calhoun | Alabama | 1015 | 7760 | 129 |
819838 | 819838 | 2020-12-12 | Chambers | Alabama | 1017 | 1997 | 57 |
819839 | 819839 | 2020-12-12 | Cherokee | Alabama | 1019 | 1187 | 24 |
819840 | 819840 | 2020-12-12 | Chilton | Alabama | 1021 | 2527 | 46 |
819841 | 819841 | 2020-12-12 | Choctaw | Alabama | 1023 | 453 | 20 |
819842 | 819842 | 2020-12-12 | Clarke | Alabama | 1025 | 2033 | 24 |
819843 | 819843 | 2020-12-12 | Clay | Alabama | 1027 | 998 | 28 |
819844 | 819844 | 2020-12-12 | Cleburne | Alabama | 1029 | 878 | 15 |
819845 | 819845 | 2020-12-12 | Coffee | Alabama | 1031 | 2886 | 25 |
819846 | 819846 | 2020-12-12 | Colbert | Alabama | 1033 | 3806 | 53 |
819847 | 819847 | 2020-12-12 | Conecuh | Alabama | 1035 | 776 | 15 |
819848 | 819848 | 2020-12-12 | Coosa | Alabama | 1037 | 430 | 4 |
819849 | 819849 | 2020-12-12 | Covington | Alabama | 1039 | 2517 | 38 |
819850 | 819850 | 2020-12-12 | Crenshaw | Alabama | 1041 | 771 | 32 |
819851 | 819851 | 2020-12-12 | Cullman | Alabama | 1043 | 5633 | 59 |
819852 | 819852 | 2020-12-12 | Dale | Alabama | 1045 | 2748 | 59 |
819853 | 819853 | 2020-12-12 | Dallas | Alabama | 1047 | 2487 | 34 |
819854 | 819854 | 2020-12-12 | DeKalb | Alabama | 1049 | 5785 | 49 |
819855 | 819855 | 2020-12-12 | Elmore | Alabama | 1051 | 4909 | 72 |
819856 | 819856 | 2020-12-12 | Escambia | Alabama | 1053 | 2258 | 32 |
819857 | 819857 | 2020-12-12 | Etowah | Alabama | 1055 | 7919 | 80 |
819858 | 819858 | 2020-12-12 | Fayette | Alabama | 1057 | 1160 | 16 |
819859 | 819859 | 2020-12-12 | Franklin | Alabama | 1059 | 2848 | 34 |
819860 | 819860 | 2020-12-12 | Geneva | Alabama | 1061 | 1398 | 16 |
819861 | 819861 | 2020-12-12 | Greene | Alabama | 1063 | 544 | 20 |
819862 | 819862 | 2020-12-12 | Hale | Alabama | 1065 | 1122 | 33 |
819863 | 819863 | 2020-12-12 | Henry | Alabama | 1067 | 984 | 8 |
819864 | 819864 | 2020-12-12 | Houston | Alabama | 1069 | 6024 | 52 |
819865 | 819865 | 2020-12-12 | Jackson | Alabama | 1071 | 4306 | 26 |
819866 | 819866 | 2020-12-12 | Jefferson | Alabama | 1073 | 40232 | 558 |
819867 | 819867 | 2020-12-12 | Lamar | Alabama | 1075 | 841 | 9 |
819868 | 819868 | 2020-12-12 | Lauderdale | Alabama | 1077 | 5005 | 61 |
819869 | 819869 | 2020-12-12 | Lawrence | Alabama | 1079 | 1569 | 37 |
819870 | 819870 | 2020-12-12 | Lee | Alabama | 1081 | 8675 | 73 |
819871 | 819871 | 2020-12-12 | Limestone | Alabama | 1083 | 5244 | 49 |
819872 | 819872 | 2020-12-12 | Lowndes | Alabama | 1085 | 856 | 30 |
819873 | 819873 | 2020-12-12 | Macon | Alabama | 1087 | 838 | 24 |
819874 | 819874 | 2020-12-12 | Madison | Alabama | 1089 | 16760 | 162 |
819875 | 819875 | 2020-12-12 | Marengo | Alabama | 1091 | 1459 | 25 |
819876 | 819876 | 2020-12-12 | Marion | Alabama | 1093 | 1669 | 40 |
819877 | 819877 | 2020-12-12 | Marshall | Alabama | 1095 | 7736 | 65 |
819878 | 819878 | 2020-12-12 | Mobile | Alabama | 1097 | 22034 | 389 |
819879 | 819879 | 2020-12-12 | Monroe | Alabama | 1099 | 921 | 10 |
819880 | 819880 | 2020-12-12 | Montgomery | Alabama | 1101 | 13671 | 260 |
819881 | 819881 | 2020-12-12 | Morgan | Alabama | 1103 | 8393 | 64 |
819882 | 819882 | 2020-12-12 | Perry | Alabama | 1105 | 738 | 9 |
819883 | 819883 | 2020-12-12 | Pickens | Alabama | 1107 | 1399 | 24 |
819884 | 819884 | 2020-12-12 | Pike | Alabama | 1109 | 1731 | 16 |
819885 | 819885 | 2020-12-12 | Randolph | Alabama | 1111 | 1121 | 28 |
819886 | 819886 | 2020-12-12 | Russell | Alabama | 1113 | 2458 | 6 |
819887 | 819887 | 2020-12-12 | Shelby | Alabama | 1117 | 12551 | 87 |
819888 | 819888 | 2020-12-12 | St. Clair | Alabama | 1115 | 5210 | 62 |
819889 | 819889 | 2020-12-12 | Sumter | Alabama | 1119 | 659 | 22 |
819890 | 819890 | 2020-12-12 | Talladega | Alabama | 1121 | 4298 | 63 |
819891 | 819891 | 2020-12-12 | Tallapoosa | Alabama | 1123 | 2046 | 93 |
819892 | 819892 | 2020-12-12 | Tuscaloosa | Alabama | 1125 | 15373 | 193 |
819893 | 819893 | 2020-12-12 | Walker | Alabama | 1127 | 4396 | 113 |
819894 | 819894 | 2020-12-12 | Washington | Alabama | 1129 | 1020 | 23 |
819895 | 819895 | 2020-12-12 | Wilcox | Alabama | 1131 | 777 | 19 |
819896 | 819896 | 2020-12-12 | Winston | Alabama | 1133 | 1633 | 25 |
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);