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 2020-10-28 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
673822 | 673822 | 2020-10-28 | Autauga | Alabama | 1001 | 2103 | 31 |
673823 | 673823 | 2020-10-28 | Baldwin | Alabama | 1003 | 6743 | 69 |
673824 | 673824 | 2020-10-28 | Barbour | Alabama | 1005 | 1045 | 9 |
673825 | 673825 | 2020-10-28 | Bibb | Alabama | 1007 | 856 | 15 |
673826 | 673826 | 2020-10-28 | Blount | Alabama | 1009 | 1988 | 25 |
673827 | 673827 | 2020-10-28 | Bullock | Alabama | 1011 | 650 | 17 |
673828 | 673828 | 2020-10-28 | Butler | Alabama | 1013 | 1015 | 41 |
673829 | 673829 | 2020-10-28 | Calhoun | Alabama | 1015 | 4689 | 62 |
673830 | 673830 | 2020-10-28 | Chambers | Alabama | 1017 | 1370 | 47 |
673831 | 673831 | 2020-10-28 | Cherokee | Alabama | 1019 | 761 | 14 |
673832 | 673832 | 2020-10-28 | Chilton | Alabama | 1021 | 1909 | 32 |
673833 | 673833 | 2020-10-28 | Choctaw | Alabama | 1023 | 394 | 12 |
673834 | 673834 | 2020-10-28 | Clarke | Alabama | 1025 | 1380 | 17 |
673835 | 673835 | 2020-10-28 | Clay | Alabama | 1027 | 758 | 12 |
673836 | 673836 | 2020-10-28 | Cleburne | Alabama | 1029 | 577 | 9 |
673837 | 673837 | 2020-10-28 | Coffee | Alabama | 1031 | 1826 | 11 |
673838 | 673838 | 2020-10-28 | Colbert | Alabama | 1033 | 2082 | 32 |
673839 | 673839 | 2020-10-28 | Conecuh | Alabama | 1035 | 565 | 13 |
673840 | 673840 | 2020-10-28 | Coosa | Alabama | 1037 | 214 | 3 |
673841 | 673841 | 2020-10-28 | Covington | Alabama | 1039 | 1767 | 29 |
673842 | 673842 | 2020-10-28 | Crenshaw | Alabama | 1041 | 611 | 30 |
673843 | 673843 | 2020-10-28 | Cullman | Alabama | 1043 | 2600 | 25 |
673844 | 673844 | 2020-10-28 | Dale | Alabama | 1045 | 1808 | 52 |
673845 | 673845 | 2020-10-28 | Dallas | Alabama | 1047 | 1881 | 27 |
673846 | 673846 | 2020-10-28 | DeKalb | Alabama | 1049 | 3512 | 29 |
673847 | 673847 | 2020-10-28 | Elmore | Alabama | 1051 | 3265 | 58 |
673848 | 673848 | 2020-10-28 | Escambia | Alabama | 1053 | 1753 | 31 |
673849 | 673849 | 2020-10-28 | Etowah | Alabama | 1055 | 4365 | 52 |
673850 | 673850 | 2020-10-28 | Fayette | Alabama | 1057 | 594 | 13 |
673851 | 673851 | 2020-10-28 | Franklin | Alabama | 1059 | 2077 | 32 |
673852 | 673852 | 2020-10-28 | Geneva | Alabama | 1061 | 935 | 7 |
673853 | 673853 | 2020-10-28 | Greene | Alabama | 1063 | 346 | 16 |
673854 | 673854 | 2020-10-28 | Hale | Alabama | 1065 | 780 | 30 |
673855 | 673855 | 2020-10-28 | Henry | Alabama | 1067 | 728 | 6 |
673856 | 673856 | 2020-10-28 | Houston | Alabama | 1069 | 4212 | 34 |
673857 | 673857 | 2020-10-28 | Jackson | Alabama | 1071 | 2219 | 17 |
673858 | 673858 | 2020-10-28 | Jefferson | Alabama | 1073 | 23769 | 383 |
673859 | 673859 | 2020-10-28 | Lamar | Alabama | 1075 | 516 | 5 |
673860 | 673860 | 2020-10-28 | Lauderdale | Alabama | 1077 | 2371 | 43 |
673861 | 673861 | 2020-10-28 | Lawrence | Alabama | 1079 | 877 | 33 |
673862 | 673862 | 2020-10-28 | Lee | Alabama | 1081 | 6624 | 65 |
673863 | 673863 | 2020-10-28 | Limestone | Alabama | 1083 | 2951 | 31 |
673864 | 673864 | 2020-10-28 | Lowndes | Alabama | 1085 | 717 | 28 |
673865 | 673865 | 2020-10-28 | Macon | Alabama | 1087 | 541 | 20 |
673866 | 673866 | 2020-10-28 | Madison | Alabama | 1089 | 9467 | 98 |
673867 | 673867 | 2020-10-28 | Marengo | Alabama | 1091 | 1035 | 22 |
673868 | 673868 | 2020-10-28 | Marion | Alabama | 1093 | 1103 | 31 |
673869 | 673869 | 2020-10-28 | Marshall | Alabama | 1095 | 4452 | 51 |
673870 | 673870 | 2020-10-28 | Mobile | Alabama | 1097 | 17039 | 318 |
673871 | 673871 | 2020-10-28 | Monroe | Alabama | 1099 | 660 | 10 |
673872 | 673872 | 2020-10-28 | Montgomery | Alabama | 1101 | 10435 | 199 |
673873 | 673873 | 2020-10-28 | Morgan | Alabama | 1103 | 4263 | 35 |
673874 | 673874 | 2020-10-28 | Perry | Alabama | 1105 | 596 | 6 |
673875 | 673875 | 2020-10-28 | Pickens | Alabama | 1107 | 874 | 18 |
673876 | 673876 | 2020-10-28 | Pike | Alabama | 1109 | 1355 | 14 |
673877 | 673877 | 2020-10-28 | Randolph | Alabama | 1111 | 843 | 16 |
673878 | 673878 | 2020-10-28 | Russell | Alabama | 1113 | 1976 | 3 |
673879 | 673879 | 2020-10-28 | Shelby | Alabama | 1117 | 7563 | 65 |
673880 | 673880 | 2020-10-28 | St. Clair | Alabama | 1115 | 3070 | 42 |
673881 | 673881 | 2020-10-28 | Sumter | Alabama | 1119 | 477 | 21 |
673882 | 673882 | 2020-10-28 | Talladega | Alabama | 1121 | 2739 | 37 |
673883 | 673883 | 2020-10-28 | Tallapoosa | Alabama | 1123 | 1353 | 87 |
673884 | 673884 | 2020-10-28 | Tuscaloosa | Alabama | 1125 | 10539 | 141 |
673885 | 673885 | 2020-10-28 | Walker | Alabama | 1127 | 2855 | 93 |
673886 | 673886 | 2020-10-28 | Washington | Alabama | 1129 | 754 | 12 |
673887 | 673887 | 2020-10-28 | Wilcox | Alabama | 1131 | 571 | 12 |
673888 | 673888 | 2020-10-28 | Winston | Alabama | 1133 | 943 | 13 |
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);