ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where fips = 1009 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1387925 | 1387925 | 2021-06-05 | Blount | Alabama | 1009 | 6906 | 139 |
1384680 | 1384680 | 2021-06-04 | Blount | Alabama | 1009 | 6906 | 139 |
1381434 | 1381434 | 2021-06-03 | Blount | Alabama | 1009 | 6894 | 139 |
1378189 | 1378189 | 2021-06-02 | Blount | Alabama | 1009 | 6889 | 139 |
1374943 | 1374943 | 2021-06-01 | Blount | Alabama | 1009 | 6887 | 139 |
1371698 | 1371698 | 2021-05-31 | Blount | Alabama | 1009 | 6864 | 139 |
1368452 | 1368452 | 2021-05-30 | Blount | Alabama | 1009 | 6864 | 139 |
1365206 | 1365206 | 2021-05-29 | Blount | Alabama | 1009 | 6864 | 139 |
1361960 | 1361960 | 2021-05-28 | Blount | Alabama | 1009 | 6864 | 139 |
1358714 | 1358714 | 2021-05-27 | Blount | Alabama | 1009 | 6862 | 139 |
1355468 | 1355468 | 2021-05-26 | Blount | Alabama | 1009 | 6856 | 139 |
1352222 | 1352222 | 2021-05-25 | Blount | Alabama | 1009 | 6847 | 139 |
1348976 | 1348976 | 2021-05-24 | Blount | Alabama | 1009 | 6832 | 139 |
1345728 | 1345728 | 2021-05-23 | Blount | Alabama | 1009 | 6832 | 139 |
1342480 | 1342480 | 2021-05-22 | Blount | Alabama | 1009 | 6829 | 139 |
1339232 | 1339232 | 2021-05-21 | Blount | Alabama | 1009 | 6826 | 139 |
1335985 | 1335985 | 2021-05-20 | Blount | Alabama | 1009 | 6816 | 139 |
1332738 | 1332738 | 2021-05-19 | Blount | Alabama | 1009 | 6808 | 139 |
1329491 | 1329491 | 2021-05-18 | Blount | Alabama | 1009 | 6794 | 139 |
1326245 | 1326245 | 2021-05-17 | Blount | Alabama | 1009 | 6776 | 139 |
1322999 | 1322999 | 2021-05-16 | Blount | Alabama | 1009 | 6773 | 139 |
1319753 | 1319753 | 2021-05-15 | Blount | Alabama | 1009 | 6771 | 139 |
1316505 | 1316505 | 2021-05-14 | Blount | Alabama | 1009 | 6750 | 139 |
1313259 | 1313259 | 2021-05-13 | Blount | Alabama | 1009 | 6694 | 137 |
1310012 | 1310012 | 2021-05-12 | Blount | Alabama | 1009 | 6680 | 137 |
1306766 | 1306766 | 2021-05-11 | Blount | Alabama | 1009 | 6678 | 137 |
1303520 | 1303520 | 2021-05-10 | Blount | Alabama | 1009 | 6661 | 137 |
1300273 | 1300273 | 2021-05-09 | Blount | Alabama | 1009 | 6660 | 137 |
1297026 | 1297026 | 2021-05-08 | Blount | Alabama | 1009 | 6656 | 137 |
1293780 | 1293780 | 2021-05-07 | Blount | Alabama | 1009 | 6651 | 137 |
1290534 | 1290534 | 2021-05-06 | Blount | Alabama | 1009 | 6645 | 136 |
1287288 | 1287288 | 2021-05-05 | Blount | Alabama | 1009 | 6635 | 136 |
1284042 | 1284042 | 2021-05-04 | Blount | Alabama | 1009 | 6621 | 135 |
1280795 | 1280795 | 2021-05-03 | Blount | Alabama | 1009 | 6621 | 135 |
1277548 | 1277548 | 2021-05-02 | Blount | Alabama | 1009 | 6619 | 135 |
1274301 | 1274301 | 2021-05-01 | Blount | Alabama | 1009 | 6616 | 135 |
1271054 | 1271054 | 2021-04-30 | Blount | Alabama | 1009 | 6613 | 135 |
1267807 | 1267807 | 2021-04-29 | Blount | Alabama | 1009 | 6607 | 135 |
1264560 | 1264560 | 2021-04-28 | Blount | Alabama | 1009 | 6595 | 134 |
1261313 | 1261313 | 2021-04-27 | Blount | Alabama | 1009 | 6581 | 134 |
1258066 | 1258066 | 2021-04-26 | Blount | Alabama | 1009 | 6574 | 134 |
1254819 | 1254819 | 2021-04-25 | Blount | Alabama | 1009 | 6571 | 134 |
1251572 | 1251572 | 2021-04-24 | Blount | Alabama | 1009 | 6570 | 134 |
1248325 | 1248325 | 2021-04-23 | Blount | Alabama | 1009 | 6570 | 134 |
1245078 | 1245078 | 2021-04-22 | Blount | Alabama | 1009 | 6563 | 133 |
1241831 | 1241831 | 2021-04-21 | Blount | Alabama | 1009 | 6556 | 133 |
1238584 | 1238584 | 2021-04-20 | Blount | Alabama | 1009 | 6548 | 133 |
1235337 | 1235337 | 2021-04-19 | Blount | Alabama | 1009 | 6532 | 133 |
1232089 | 1232089 | 2021-04-18 | Blount | Alabama | 1009 | 6532 | 133 |
1228841 | 1228841 | 2021-04-17 | Blount | Alabama | 1009 | 6529 | 133 |
1225593 | 1225593 | 2021-04-16 | Blount | Alabama | 1009 | 6519 | 134 |
1222346 | 1222346 | 2021-04-15 | Blount | Alabama | 1009 | 6511 | 134 |
1219098 | 1219098 | 2021-04-14 | Blount | Alabama | 1009 | 6507 | 135 |
1215850 | 1215850 | 2021-04-13 | Blount | Alabama | 1009 | 6497 | 135 |
1212603 | 1212603 | 2021-04-12 | Blount | Alabama | 1009 | 6488 | 135 |
1209354 | 1209354 | 2021-04-11 | Blount | Alabama | 1009 | 6483 | 135 |
1206106 | 1206106 | 2021-04-10 | Blount | Alabama | 1009 | 6480 | 135 |
1202858 | 1202858 | 2021-04-09 | Blount | Alabama | 1009 | 6475 | 134 |
1199610 | 1199610 | 2021-04-08 | Blount | Alabama | 1009 | 6472 | 134 |
1196361 | 1196361 | 2021-04-07 | Blount | Alabama | 1009 | 6469 | 133 |
1193113 | 1193113 | 2021-04-06 | Blount | Alabama | 1009 | 6462 | 132 |
1189863 | 1189863 | 2021-04-05 | Blount | Alabama | 1009 | 6460 | 132 |
1186616 | 1186616 | 2021-04-04 | Blount | Alabama | 1009 | 6459 | 132 |
1183369 | 1183369 | 2021-04-03 | Blount | Alabama | 1009 | 6458 | 132 |
1180122 | 1180122 | 2021-04-02 | Blount | Alabama | 1009 | 6455 | 132 |
1176875 | 1176875 | 2021-04-01 | Blount | Alabama | 1009 | 6446 | 131 |
1173628 | 1173628 | 2021-03-31 | Blount | Alabama | 1009 | 6444 | 131 |
1170381 | 1170381 | 2021-03-30 | Blount | Alabama | 1009 | 6443 | 131 |
1167133 | 1167133 | 2021-03-29 | Blount | Alabama | 1009 | 6426 | 131 |
1163885 | 1163885 | 2021-03-28 | Blount | Alabama | 1009 | 6424 | 131 |
1160637 | 1160637 | 2021-03-27 | Blount | Alabama | 1009 | 6420 | 131 |
1157389 | 1157389 | 2021-03-26 | Blount | Alabama | 1009 | 6415 | 131 |
1154142 | 1154142 | 2021-03-25 | Blount | Alabama | 1009 | 6408 | 131 |
1150895 | 1150895 | 2021-03-24 | Blount | Alabama | 1009 | 6402 | 131 |
1147648 | 1147648 | 2021-03-23 | Blount | Alabama | 1009 | 6388 | 130 |
1144401 | 1144401 | 2021-03-22 | Blount | Alabama | 1009 | 6387 | 130 |
1141154 | 1141154 | 2021-03-21 | Blount | Alabama | 1009 | 6383 | 130 |
1137908 | 1137908 | 2021-03-20 | Blount | Alabama | 1009 | 6382 | 130 |
1134662 | 1134662 | 2021-03-19 | Blount | Alabama | 1009 | 6380 | 130 |
1131414 | 1131414 | 2021-03-18 | Blount | Alabama | 1009 | 6376 | 130 |
1128167 | 1128167 | 2021-03-17 | Blount | Alabama | 1009 | 6371 | 129 |
1124921 | 1124921 | 2021-03-16 | Blount | Alabama | 1009 | 6361 | 129 |
1121675 | 1121675 | 2021-03-15 | Blount | Alabama | 1009 | 6353 | 129 |
1118428 | 1118428 | 2021-03-14 | Blount | Alabama | 1009 | 6291 | 129 |
1115181 | 1115181 | 2021-03-13 | Blount | Alabama | 1009 | 6288 | 129 |
1111935 | 1111935 | 2021-03-12 | Blount | Alabama | 1009 | 6282 | 129 |
1108689 | 1108689 | 2021-03-11 | Blount | Alabama | 1009 | 6274 | 129 |
1105443 | 1105443 | 2021-03-10 | Blount | Alabama | 1009 | 6260 | 129 |
1102197 | 1102197 | 2021-03-09 | Blount | Alabama | 1009 | 6255 | 128 |
1098951 | 1098951 | 2021-03-08 | Blount | Alabama | 1009 | 6256 | 128 |
1095703 | 1095703 | 2021-03-07 | Blount | Alabama | 1009 | 6256 | 128 |
1092457 | 1092457 | 2021-03-06 | Blount | Alabama | 1009 | 6252 | 128 |
1089211 | 1089211 | 2021-03-05 | Blount | Alabama | 1009 | 6246 | 128 |
1085966 | 1085966 | 2021-03-04 | Blount | Alabama | 1009 | 6236 | 127 |
1082720 | 1082720 | 2021-03-03 | Blount | Alabama | 1009 | 6229 | 127 |
1079474 | 1079474 | 2021-03-02 | Blount | Alabama | 1009 | 6106 | 127 |
1076229 | 1076229 | 2021-03-01 | Blount | Alabama | 1009 | 6102 | 127 |
1072983 | 1072983 | 2021-02-28 | Blount | Alabama | 1009 | 6097 | 127 |
1069737 | 1069737 | 2021-02-27 | Blount | Alabama | 1009 | 6095 | 127 |
1066492 | 1066492 | 2021-02-26 | Blount | Alabama | 1009 | 6084 | 125 |
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);