ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where date = "2020-07-16" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
337834 | 337834 | 2020-07-16 | Autauga | Alabama | 1001 | 780 | 20 |
337835 | 337835 | 2020-07-16 | Baldwin | Alabama | 1003 | 1599 | 14 |
337836 | 337836 | 2020-07-16 | Barbour | Alabama | 1005 | 459 | 3 |
337837 | 337837 | 2020-07-16 | Bibb | Alabama | 1007 | 247 | 2 |
337838 | 337838 | 2020-07-16 | Blount | Alabama | 1009 | 424 | 1 |
337839 | 337839 | 2020-07-16 | Bullock | Alabama | 1011 | 389 | 11 |
337840 | 337840 | 2020-07-16 | Butler | Alabama | 1013 | 669 | 32 |
337841 | 337841 | 2020-07-16 | Calhoun | Alabama | 1015 | 675 | 6 |
337842 | 337842 | 2020-07-16 | Chambers | Alabama | 1017 | 731 | 32 |
337843 | 337843 | 2020-07-16 | Cherokee | Alabama | 1019 | 152 | 7 |
337844 | 337844 | 2020-07-16 | Chilton | Alabama | 1021 | 397 | 4 |
337845 | 337845 | 2020-07-16 | Choctaw | Alabama | 1023 | 224 | 12 |
337846 | 337846 | 2020-07-16 | Clarke | Alabama | 1025 | 353 | 6 |
337847 | 337847 | 2020-07-16 | Clay | Alabama | 1027 | 97 | 2 |
337848 | 337848 | 2020-07-16 | Cleburne | Alabama | 1029 | 63 | 1 |
337849 | 337849 | 2020-07-16 | Coffee | Alabama | 1031 | 493 | 4 |
337850 | 337850 | 2020-07-16 | Colbert | Alabama | 1033 | 655 | 8 |
337851 | 337851 | 2020-07-16 | Conecuh | Alabama | 1035 | 271 | 8 |
337852 | 337852 | 2020-07-16 | Coosa | Alabama | 1037 | 68 | 1 |
337853 | 337853 | 2020-07-16 | Covington | Alabama | 1039 | 511 | 15 |
337854 | 337854 | 2020-07-16 | Crenshaw | Alabama | 1041 | 149 | 3 |
337855 | 337855 | 2020-07-16 | Cullman | Alabama | 1043 | 740 | 6 |
337856 | 337856 | 2020-07-16 | Dale | Alabama | 1045 | 457 | 3 |
337857 | 337857 | 2020-07-16 | Dallas | Alabama | 1047 | 1092 | 12 |
337858 | 337858 | 2020-07-16 | DeKalb | Alabama | 1049 | 1195 | 7 |
337859 | 337859 | 2020-07-16 | Elmore | Alabama | 1051 | 1175 | 26 |
337860 | 337860 | 2020-07-16 | Escambia | Alabama | 1053 | 582 | 12 |
337861 | 337861 | 2020-07-16 | Etowah | Alabama | 1055 | 1194 | 14 |
337862 | 337862 | 2020-07-16 | Fayette | Alabama | 1057 | 108 | 3 |
337863 | 337863 | 2020-07-16 | Franklin | Alabama | 1059 | 984 | 16 |
337864 | 337864 | 2020-07-16 | Geneva | Alabama | 1061 | 113 | 0 |
337865 | 337865 | 2020-07-16 | Greene | Alabama | 1063 | 209 | 9 |
337866 | 337866 | 2020-07-16 | Hale | Alabama | 1065 | 388 | 23 |
337867 | 337867 | 2020-07-16 | Henry | Alabama | 1067 | 170 | 4 |
337868 | 337868 | 2020-07-16 | Houston | Alabama | 1069 | 723 | 10 |
337869 | 337869 | 2020-07-16 | Jackson | Alabama | 1071 | 521 | 4 |
337870 | 337870 | 2020-07-16 | Jefferson | Alabama | 1073 | 7900 | 183 |
337871 | 337871 | 2020-07-16 | Lamar | Alabama | 1075 | 102 | 1 |
337872 | 337872 | 2020-07-16 | Lauderdale | Alabama | 1077 | 693 | 7 |
337873 | 337873 | 2020-07-16 | Lawrence | Alabama | 1079 | 165 | 0 |
337874 | 337874 | 2020-07-16 | Lee | Alabama | 1081 | 1915 | 38 |
337875 | 337875 | 2020-07-16 | Limestone | Alabama | 1083 | 757 | 5 |
337876 | 337876 | 2020-07-16 | Lowndes | Alabama | 1085 | 505 | 25 |
337877 | 337877 | 2020-07-16 | Macon | Alabama | 1087 | 246 | 9 |
337878 | 337878 | 2020-07-16 | Madison | Alabama | 1089 | 3014 | 14 |
337879 | 337879 | 2020-07-16 | Marengo | Alabama | 1091 | 390 | 11 |
337880 | 337880 | 2020-07-16 | Marion | Alabama | 1093 | 369 | 14 |
337881 | 337881 | 2020-07-16 | Marshall | Alabama | 1095 | 2229 | 13 |
337882 | 337882 | 2020-07-16 | Mobile | Alabama | 1097 | 5540 | 163 |
337883 | 337883 | 2020-07-16 | Monroe | Alabama | 1099 | 307 | 4 |
337884 | 337884 | 2020-07-16 | Montgomery | Alabama | 1101 | 4864 | 121 |
337885 | 337885 | 2020-07-16 | Morgan | Alabama | 1103 | 1534 | 7 |
337886 | 337886 | 2020-07-16 | Perry | Alabama | 1105 | 281 | 3 |
337887 | 337887 | 2020-07-16 | Pickens | Alabama | 1107 | 289 | 7 |
337888 | 337888 | 2020-07-16 | Pike | Alabama | 1109 | 526 | 6 |
337889 | 337889 | 2020-07-16 | Randolph | Alabama | 1111 | 297 | 10 |
337890 | 337890 | 2020-07-16 | Russell | Alabama | 1113 | 820 | 0 |
337891 | 337891 | 2020-07-16 | Shelby | Alabama | 1117 | 2025 | 27 |
337892 | 337892 | 2020-07-16 | St. Clair | Alabama | 1115 | 732 | 4 |
337893 | 337893 | 2020-07-16 | Sumter | Alabama | 1119 | 310 | 13 |
337894 | 337894 | 2020-07-16 | Talladega | Alabama | 1121 | 547 | 8 |
337895 | 337895 | 2020-07-16 | Tallapoosa | Alabama | 1123 | 687 | 73 |
337896 | 337896 | 2020-07-16 | Tuscaloosa | Alabama | 1125 | 2955 | 56 |
337897 | 337897 | 2020-07-16 | Walker | Alabama | 1127 | 1178 | 43 |
337898 | 337898 | 2020-07-16 | Washington | Alabama | 1129 | 183 | 9 |
337899 | 337899 | 2020-07-16 | Wilcox | Alabama | 1131 | 337 | 8 |
337900 | 337900 | 2020-07-16 | Winston | Alabama | 1133 | 334 | 7 |
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);