ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

67 rows where "date" is on date 2021-04-01 and state = "Alabama" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

fips >30

state 1

  • Alabama · 67 ✖
Link rowid date ▲ county state fips cases deaths
1176871 1176871 2021-04-01 Autauga Alabama 1001 6595 99
1176872 1176872 2021-04-01 Baldwin Alabama 1003 20523 301
1176873 1176873 2021-04-01 Barbour Alabama 1005 2227 55
1176874 1176874 2021-04-01 Bibb Alabama 1007 2543 58
1176875 1176875 2021-04-01 Blount Alabama 1009 6446 131
1176876 1176876 2021-04-01 Bullock Alabama 1011 1207 40
1176877 1176877 2021-04-01 Butler Alabama 1013 2103 66
1176878 1176878 2021-04-01 Calhoun Alabama 1015 14227 305
1176879 1176879 2021-04-01 Chambers Alabama 1017 3489 117
1176880 1176880 2021-04-01 Cherokee Alabama 1019 1810 43
1176881 1176881 2021-04-01 Chilton Alabama 1021 4041 109
1176882 1176882 2021-04-01 Choctaw Alabama 1023 583 24
1176883 1176883 2021-04-01 Clarke Alabama 1025 3458 59
1176884 1176884 2021-04-01 Clay Alabama 1027 1483 54
1176885 1176885 2021-04-01 Cleburne Alabama 1029 1454 41
1176886 1176886 2021-04-01 Coffee Alabama 1031 5387 110
1176887 1176887 2021-04-01 Colbert Alabama 1033 6175 126
1176888 1176888 2021-04-01 Conecuh Alabama 1035 1087 26
1176889 1176889 2021-04-01 Coosa Alabama 1037 943 24
1176890 1176890 2021-04-01 Covington Alabama 1039 4043 111
1176891 1176891 2021-04-01 Crenshaw Alabama 1041 1503 57
1176892 1176892 2021-04-01 Cullman Alabama 1043 9390 186
1176893 1176893 2021-04-01 Dale Alabama 1045 4763 109
1176894 1176894 2021-04-01 Dallas Alabama 1047 3516 148
1176895 1176895 2021-04-01 DeKalb Alabama 1049 8699 179
1176896 1176896 2021-04-01 Elmore Alabama 1051 9978 202
1176897 1176897 2021-04-01 Escambia Alabama 1053 3862 74
1176898 1176898 2021-04-01 Etowah Alabama 1055 13646 343
1176899 1176899 2021-04-01 Fayette Alabama 1057 2063 59
1176900 1176900 2021-04-01 Franklin Alabama 1059 4186 82
1176901 1176901 2021-04-01 Geneva Alabama 1061 2447 74
1176902 1176902 2021-04-01 Greene Alabama 1063 903 34
1176903 1176903 2021-04-01 Hale Alabama 1065 2165 73
1176904 1176904 2021-04-01 Henry Alabama 1067 1869 42
1176905 1176905 2021-04-01 Houston Alabama 1069 10342 272
1176906 1176906 2021-04-01 Jackson Alabama 1071 6733 106
1176907 1176907 2021-04-01 Jefferson Alabama 1073 74789 1463
1176908 1176908 2021-04-01 Lamar Alabama 1075 1390 33
1176909 1176909 2021-04-01 Lauderdale Alabama 1077 9144 219
1176910 1176910 2021-04-01 Lawrence Alabama 1079 2928 94
1176911 1176911 2021-04-01 Lee Alabama 1081 15433 166
1176912 1176912 2021-04-01 Limestone Alabama 1083 9753 145
1176913 1176913 2021-04-01 Lowndes Alabama 1085 1363 53
1176914 1176914 2021-04-01 Macon Alabama 1087 1536 47
1176915 1176915 2021-04-01 Madison Alabama 1089 33577 489
1176916 1176916 2021-04-01 Marengo Alabama 1091 2502 58
1176917 1176917 2021-04-01 Marion Alabama 1093 3063 99
1176918 1176918 2021-04-01 Marshall Alabama 1095 11865 217
1176919 1176919 2021-04-01 Mobile Alabama 1097 37515 792
1176920 1176920 2021-04-01 Monroe Alabama 1099 1706 39
1176921 1176921 2021-04-01 Montgomery Alabama 1101 23779 552
1176922 1176922 2021-04-01 Morgan Alabama 1103 14138 263
1176923 1176923 2021-04-01 Perry Alabama 1105 1080 27
1176924 1176924 2021-04-01 Pickens Alabama 1107 2326 57
1176925 1176925 2021-04-01 Pike Alabama 1109 3044 74
1176926 1176926 2021-04-01 Randolph Alabama 1111 1753 41
1176927 1176927 2021-04-01 Russell Alabama 1113 4231 36
1176928 1176928 2021-04-01 Shelby Alabama 1117 23077 232
1176929 1176929 2021-04-01 St. Clair Alabama 1115 9360 232
1176930 1176930 2021-04-01 Sumter Alabama 1119 1026 32
1176931 1176931 2021-04-01 Talladega Alabama 1121 7999 167
1176932 1176932 2021-04-01 Tallapoosa Alabama 1123 3848 144
1176933 1176933 2021-04-01 Tuscaloosa Alabama 1125 25082 434
1176934 1176934 2021-04-01 Walker Alabama 1127 7067 274
1176935 1176935 2021-04-01 Washington Alabama 1129 1639 38
1176936 1176936 2021-04-01 Wilcox Alabama 1131 1247 26
1176937 1176937 2021-04-01 Winston Alabama 1133 2717 71

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);