ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Franklin" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1387950 | 1387950 | 2021-06-05 | Franklin | Alabama | 1059 | 4289 | 82 |
1384705 | 1384705 | 2021-06-04 | Franklin | Alabama | 1059 | 4289 | 82 |
1381459 | 1381459 | 2021-06-03 | Franklin | Alabama | 1059 | 4282 | 82 |
1378214 | 1378214 | 2021-06-02 | Franklin | Alabama | 1059 | 4282 | 82 |
1374968 | 1374968 | 2021-06-01 | Franklin | Alabama | 1059 | 4278 | 82 |
1371723 | 1371723 | 2021-05-31 | Franklin | Alabama | 1059 | 4273 | 82 |
1368477 | 1368477 | 2021-05-30 | Franklin | Alabama | 1059 | 4273 | 82 |
1365231 | 1365231 | 2021-05-29 | Franklin | Alabama | 1059 | 4273 | 82 |
1361985 | 1361985 | 2021-05-28 | Franklin | Alabama | 1059 | 4273 | 82 |
1358739 | 1358739 | 2021-05-27 | Franklin | Alabama | 1059 | 4272 | 82 |
1355493 | 1355493 | 2021-05-26 | Franklin | Alabama | 1059 | 4271 | 82 |
1352247 | 1352247 | 2021-05-25 | Franklin | Alabama | 1059 | 4270 | 82 |
1349001 | 1349001 | 2021-05-24 | Franklin | Alabama | 1059 | 4267 | 82 |
1345753 | 1345753 | 2021-05-23 | Franklin | Alabama | 1059 | 4266 | 82 |
1342505 | 1342505 | 2021-05-22 | Franklin | Alabama | 1059 | 4266 | 82 |
1339257 | 1339257 | 2021-05-21 | Franklin | Alabama | 1059 | 4265 | 82 |
1336010 | 1336010 | 2021-05-20 | Franklin | Alabama | 1059 | 4263 | 82 |
1332763 | 1332763 | 2021-05-19 | Franklin | Alabama | 1059 | 4263 | 82 |
1329516 | 1329516 | 2021-05-18 | Franklin | Alabama | 1059 | 4262 | 82 |
1326270 | 1326270 | 2021-05-17 | Franklin | Alabama | 1059 | 4263 | 82 |
1323024 | 1323024 | 2021-05-16 | Franklin | Alabama | 1059 | 4263 | 82 |
1319778 | 1319778 | 2021-05-15 | Franklin | Alabama | 1059 | 4262 | 82 |
1316530 | 1316530 | 2021-05-14 | Franklin | Alabama | 1059 | 4262 | 82 |
1313284 | 1313284 | 2021-05-13 | Franklin | Alabama | 1059 | 4262 | 82 |
1310037 | 1310037 | 2021-05-12 | Franklin | Alabama | 1059 | 4263 | 82 |
1306791 | 1306791 | 2021-05-11 | Franklin | Alabama | 1059 | 4260 | 82 |
1303545 | 1303545 | 2021-05-10 | Franklin | Alabama | 1059 | 4256 | 82 |
1300298 | 1300298 | 2021-05-09 | Franklin | Alabama | 1059 | 4257 | 82 |
1297051 | 1297051 | 2021-05-08 | Franklin | Alabama | 1059 | 4256 | 82 |
1293805 | 1293805 | 2021-05-07 | Franklin | Alabama | 1059 | 4255 | 82 |
1290559 | 1290559 | 2021-05-06 | Franklin | Alabama | 1059 | 4254 | 82 |
1287313 | 1287313 | 2021-05-05 | Franklin | Alabama | 1059 | 4247 | 82 |
1284067 | 1284067 | 2021-05-04 | Franklin | Alabama | 1059 | 4238 | 82 |
1280820 | 1280820 | 2021-05-03 | Franklin | Alabama | 1059 | 4238 | 82 |
1277573 | 1277573 | 2021-05-02 | Franklin | Alabama | 1059 | 4238 | 82 |
1274326 | 1274326 | 2021-05-01 | Franklin | Alabama | 1059 | 4234 | 82 |
1271079 | 1271079 | 2021-04-30 | Franklin | Alabama | 1059 | 4233 | 82 |
1267832 | 1267832 | 2021-04-29 | Franklin | Alabama | 1059 | 4230 | 82 |
1264585 | 1264585 | 2021-04-28 | Franklin | Alabama | 1059 | 4228 | 82 |
1261338 | 1261338 | 2021-04-27 | Franklin | Alabama | 1059 | 4226 | 82 |
1258091 | 1258091 | 2021-04-26 | Franklin | Alabama | 1059 | 4221 | 82 |
1254844 | 1254844 | 2021-04-25 | Franklin | Alabama | 1059 | 4221 | 82 |
1251597 | 1251597 | 2021-04-24 | Franklin | Alabama | 1059 | 4221 | 82 |
1248350 | 1248350 | 2021-04-23 | Franklin | Alabama | 1059 | 4221 | 82 |
1245103 | 1245103 | 2021-04-22 | Franklin | Alabama | 1059 | 4220 | 81 |
1241856 | 1241856 | 2021-04-21 | Franklin | Alabama | 1059 | 4218 | 82 |
1238609 | 1238609 | 2021-04-20 | Franklin | Alabama | 1059 | 4214 | 82 |
1235362 | 1235362 | 2021-04-19 | Franklin | Alabama | 1059 | 4213 | 82 |
1232114 | 1232114 | 2021-04-18 | Franklin | Alabama | 1059 | 4213 | 82 |
1228866 | 1228866 | 2021-04-17 | Franklin | Alabama | 1059 | 4209 | 82 |
1225618 | 1225618 | 2021-04-16 | Franklin | Alabama | 1059 | 4207 | 82 |
1222371 | 1222371 | 2021-04-15 | Franklin | Alabama | 1059 | 4205 | 82 |
1219123 | 1219123 | 2021-04-14 | Franklin | Alabama | 1059 | 4205 | 82 |
1215875 | 1215875 | 2021-04-13 | Franklin | Alabama | 1059 | 4199 | 82 |
1212628 | 1212628 | 2021-04-12 | Franklin | Alabama | 1059 | 4199 | 82 |
1209379 | 1209379 | 2021-04-11 | Franklin | Alabama | 1059 | 4199 | 82 |
1206131 | 1206131 | 2021-04-10 | Franklin | Alabama | 1059 | 4198 | 82 |
1202883 | 1202883 | 2021-04-09 | Franklin | Alabama | 1059 | 4197 | 82 |
1199635 | 1199635 | 2021-04-08 | Franklin | Alabama | 1059 | 4195 | 82 |
1196386 | 1196386 | 2021-04-07 | Franklin | Alabama | 1059 | 4191 | 82 |
1193138 | 1193138 | 2021-04-06 | Franklin | Alabama | 1059 | 4190 | 82 |
1189888 | 1189888 | 2021-04-05 | Franklin | Alabama | 1059 | 4189 | 82 |
1186641 | 1186641 | 2021-04-04 | Franklin | Alabama | 1059 | 4189 | 82 |
1183394 | 1183394 | 2021-04-03 | Franklin | Alabama | 1059 | 4189 | 82 |
1180147 | 1180147 | 2021-04-02 | Franklin | Alabama | 1059 | 4187 | 82 |
1176900 | 1176900 | 2021-04-01 | Franklin | Alabama | 1059 | 4186 | 82 |
1173653 | 1173653 | 2021-03-31 | Franklin | Alabama | 1059 | 4185 | 82 |
1170406 | 1170406 | 2021-03-30 | Franklin | Alabama | 1059 | 4184 | 82 |
1167158 | 1167158 | 2021-03-29 | Franklin | Alabama | 1059 | 4184 | 82 |
1163910 | 1163910 | 2021-03-28 | Franklin | Alabama | 1059 | 4184 | 82 |
1160662 | 1160662 | 2021-03-27 | Franklin | Alabama | 1059 | 4184 | 82 |
1157414 | 1157414 | 2021-03-26 | Franklin | Alabama | 1059 | 4183 | 82 |
1154167 | 1154167 | 2021-03-25 | Franklin | Alabama | 1059 | 4183 | 82 |
1150920 | 1150920 | 2021-03-24 | Franklin | Alabama | 1059 | 4181 | 82 |
1147673 | 1147673 | 2021-03-23 | Franklin | Alabama | 1059 | 4180 | 82 |
1144426 | 1144426 | 2021-03-22 | Franklin | Alabama | 1059 | 4180 | 82 |
1141179 | 1141179 | 2021-03-21 | Franklin | Alabama | 1059 | 4177 | 82 |
1137933 | 1137933 | 2021-03-20 | Franklin | Alabama | 1059 | 4176 | 82 |
1134687 | 1134687 | 2021-03-19 | Franklin | Alabama | 1059 | 4176 | 82 |
1131439 | 1131439 | 2021-03-18 | Franklin | Alabama | 1059 | 4175 | 82 |
1128192 | 1128192 | 2021-03-17 | Franklin | Alabama | 1059 | 4175 | 82 |
1124946 | 1124946 | 2021-03-16 | Franklin | Alabama | 1059 | 4172 | 82 |
1121700 | 1121700 | 2021-03-15 | Franklin | Alabama | 1059 | 4171 | 82 |
1118453 | 1118453 | 2021-03-14 | Franklin | Alabama | 1059 | 4048 | 82 |
1115206 | 1115206 | 2021-03-13 | Franklin | Alabama | 1059 | 4048 | 82 |
1111960 | 1111960 | 2021-03-12 | Franklin | Alabama | 1059 | 4048 | 82 |
1108714 | 1108714 | 2021-03-11 | Franklin | Alabama | 1059 | 4042 | 82 |
1105468 | 1105468 | 2021-03-10 | Franklin | Alabama | 1059 | 4023 | 81 |
1102222 | 1102222 | 2021-03-09 | Franklin | Alabama | 1059 | 4013 | 80 |
1098976 | 1098976 | 2021-03-08 | Franklin | Alabama | 1059 | 4009 | 79 |
1095728 | 1095728 | 2021-03-07 | Franklin | Alabama | 1059 | 4008 | 79 |
1092482 | 1092482 | 2021-03-06 | Franklin | Alabama | 1059 | 4007 | 79 |
1089236 | 1089236 | 2021-03-05 | Franklin | Alabama | 1059 | 4000 | 78 |
1085991 | 1085991 | 2021-03-04 | Franklin | Alabama | 1059 | 3998 | 78 |
1082745 | 1082745 | 2021-03-03 | Franklin | Alabama | 1059 | 3997 | 78 |
1079499 | 1079499 | 2021-03-02 | Franklin | Alabama | 1059 | 3994 | 78 |
1076254 | 1076254 | 2021-03-01 | Franklin | Alabama | 1059 | 3991 | 77 |
1073008 | 1073008 | 2021-02-28 | Franklin | Alabama | 1059 | 3991 | 77 |
1069762 | 1069762 | 2021-02-27 | Franklin | Alabama | 1059 | 3989 | 77 |
1066517 | 1066517 | 2021-02-26 | Franklin | Alabama | 1059 | 3988 | 76 |
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);