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-06-09 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
1400903 1400903 2021-06-09 Autauga Alabama 1001 7209 113
1400904 1400904 2021-06-09 Baldwin Alabama 1003 21755 313
1400905 1400905 2021-06-09 Barbour Alabama 1005 2346 59
1400906 1400906 2021-06-09 Bibb Alabama 1007 2670 64
1400907 1400907 2021-06-09 Blount Alabama 1009 6921 139
1400908 1400908 2021-06-09 Bullock Alabama 1011 1240 42
1400909 1400909 2021-06-09 Butler Alabama 1013 2230 71
1400910 1400910 2021-06-09 Calhoun Alabama 1015 14684 325
1400911 1400911 2021-06-09 Chambers Alabama 1017 3709 124
1400912 1400912 2021-06-09 Cherokee Alabama 1019 1870 45
1400913 1400913 2021-06-09 Chilton Alabama 1021 4458 115
1400914 1400914 2021-06-09 Choctaw Alabama 1023 614 25
1400915 1400915 2021-06-09 Clarke Alabama 1025 3526 61
1400916 1400916 2021-06-09 Clay Alabama 1027 1593 59
1400917 1400917 2021-06-09 Cleburne Alabama 1029 1518 43
1400918 1400918 2021-06-09 Coffee Alabama 1031 5616 125
1400919 1400919 2021-06-09 Colbert Alabama 1033 6383 139
1400920 1400920 2021-06-09 Conecuh Alabama 1035 1130 30
1400921 1400921 2021-06-09 Coosa Alabama 1037 1106 29
1400922 1400922 2021-06-09 Covington Alabama 1039 4250 121
1400923 1400923 2021-06-09 Crenshaw Alabama 1041 1551 57
1400924 1400924 2021-06-09 Cullman Alabama 1043 9910 200
1400925 1400925 2021-06-09 Dale Alabama 1045 4926 114
1400926 1400926 2021-06-09 Dallas Alabama 1047 3602 154
1400927 1400927 2021-06-09 DeKalb Alabama 1049 8953 188
1400928 1400928 2021-06-09 Elmore Alabama 1051 10298 211
1400929 1400929 2021-06-09 Escambia Alabama 1053 3997 80
1400930 1400930 2021-06-09 Etowah Alabama 1055 14125 361
1400931 1400931 2021-06-09 Fayette Alabama 1057 2161 62
1400932 1400932 2021-06-09 Franklin Alabama 1059 4303 83
1400933 1400933 2021-06-09 Geneva Alabama 1061 2568 81
1400934 1400934 2021-06-09 Greene Alabama 1063 934 34
1400935 1400935 2021-06-09 Hale Alabama 1065 2262 78
1400936 1400936 2021-06-09 Henry Alabama 1067 1938 43
1400937 1400937 2021-06-09 Houston Alabama 1069 10737 287
1400938 1400938 2021-06-09 Jackson Alabama 1071 6897 113
1400939 1400939 2021-06-09 Jefferson Alabama 1073 80715 1560
1400940 1400940 2021-06-09 Lamar Alabama 1075 1459 37
1400941 1400941 2021-06-09 Lauderdale Alabama 1077 9570 248
1400942 1400942 2021-06-09 Lawrence Alabama 1079 3111 100
1400943 1400943 2021-06-09 Lee Alabama 1081 16211 174
1400944 1400944 2021-06-09 Limestone Alabama 1083 10164 157
1400945 1400945 2021-06-09 Lowndes Alabama 1085 1418 54
1400946 1400946 2021-06-09 Macon Alabama 1087 1631 51
1400947 1400947 2021-06-09 Madison Alabama 1089 35596 522
1400948 1400948 2021-06-09 Marengo Alabama 1091 2505 65
1400949 1400949 2021-06-09 Marion Alabama 1093 3233 105
1400950 1400950 2021-06-09 Marshall Alabama 1095 12417 228
1400951 1400951 2021-06-09 Mobile Alabama 1097 41871 826
1400952 1400952 2021-06-09 Monroe Alabama 1099 1789 41
1400953 1400953 2021-06-09 Montgomery Alabama 1101 25063 608
1400954 1400954 2021-06-09 Morgan Alabama 1103 14592 284
1400955 1400955 2021-06-09 Perry Alabama 1105 1087 26
1400956 1400956 2021-06-09 Pickens Alabama 1107 2363 62
1400957 1400957 2021-06-09 Pike Alabama 1109 3139 78
1400958 1400958 2021-06-09 Randolph Alabama 1111 1864 43
1400959 1400959 2021-06-09 Russell Alabama 1113 4537 41
1400960 1400960 2021-06-09 Shelby Alabama 1117 25544 254
1400961 1400961 2021-06-09 St. Clair Alabama 1115 10138 250
1400962 1400962 2021-06-09 Sumter Alabama 1119 1057 32
1400963 1400963 2021-06-09 Talladega Alabama 1121 8436 182
1400964 1400964 2021-06-09 Tallapoosa Alabama 1123 4113 155
1400965 1400965 2021-06-09 Tuscaloosa Alabama 1125 26110 457
1400966 1400966 2021-06-09 Walker Alabama 1127 7315 279
1400967 1400967 2021-06-09 Washington Alabama 1129 1703 39
1400968 1400968 2021-06-09 Wilcox Alabama 1131 1270 30
1400969 1400969 2021-06-09 Winston Alabama 1133 2834 73

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