ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
773 rows where fips = 1045 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1413906 | 1413906 | 2021-06-13 | Dale | Alabama | 1045 | 4928 | 114 |
1410661 | 1410661 | 2021-06-12 | Dale | Alabama | 1045 | 4928 | 114 |
1407416 | 1407416 | 2021-06-11 | Dale | Alabama | 1045 | 4928 | 114 |
1404170 | 1404170 | 2021-06-10 | Dale | Alabama | 1045 | 4929 | 114 |
1400925 | 1400925 | 2021-06-09 | Dale | Alabama | 1045 | 4926 | 114 |
1397680 | 1397680 | 2021-06-08 | Dale | Alabama | 1045 | 4917 | 114 |
1394433 | 1394433 | 2021-06-07 | Dale | Alabama | 1045 | 4915 | 114 |
1391188 | 1391188 | 2021-06-06 | Dale | Alabama | 1045 | 4911 | 114 |
1387943 | 1387943 | 2021-06-05 | Dale | Alabama | 1045 | 4911 | 114 |
1384698 | 1384698 | 2021-06-04 | Dale | Alabama | 1045 | 4911 | 114 |
1381452 | 1381452 | 2021-06-03 | Dale | Alabama | 1045 | 4911 | 114 |
1378207 | 1378207 | 2021-06-02 | Dale | Alabama | 1045 | 4908 | 114 |
1374961 | 1374961 | 2021-06-01 | Dale | Alabama | 1045 | 4905 | 114 |
1371716 | 1371716 | 2021-05-31 | Dale | Alabama | 1045 | 4902 | 114 |
1368470 | 1368470 | 2021-05-30 | Dale | Alabama | 1045 | 4902 | 114 |
1365224 | 1365224 | 2021-05-29 | Dale | Alabama | 1045 | 4902 | 114 |
1361978 | 1361978 | 2021-05-28 | Dale | Alabama | 1045 | 4902 | 114 |
1358732 | 1358732 | 2021-05-27 | Dale | Alabama | 1045 | 4895 | 114 |
1355486 | 1355486 | 2021-05-26 | Dale | Alabama | 1045 | 4894 | 114 |
1352240 | 1352240 | 2021-05-25 | Dale | Alabama | 1045 | 4891 | 114 |
1348994 | 1348994 | 2021-05-24 | Dale | Alabama | 1045 | 4892 | 114 |
1345746 | 1345746 | 2021-05-23 | Dale | Alabama | 1045 | 4891 | 114 |
1342498 | 1342498 | 2021-05-22 | Dale | Alabama | 1045 | 4890 | 114 |
1339250 | 1339250 | 2021-05-21 | Dale | Alabama | 1045 | 4888 | 113 |
1336003 | 1336003 | 2021-05-20 | Dale | Alabama | 1045 | 4885 | 113 |
1332756 | 1332756 | 2021-05-19 | Dale | Alabama | 1045 | 4885 | 113 |
1329509 | 1329509 | 2021-05-18 | Dale | Alabama | 1045 | 4883 | 113 |
1326263 | 1326263 | 2021-05-17 | Dale | Alabama | 1045 | 4878 | 113 |
1323017 | 1323017 | 2021-05-16 | Dale | Alabama | 1045 | 4877 | 113 |
1319771 | 1319771 | 2021-05-15 | Dale | Alabama | 1045 | 4876 | 113 |
1316523 | 1316523 | 2021-05-14 | Dale | Alabama | 1045 | 4869 | 113 |
1313277 | 1313277 | 2021-05-13 | Dale | Alabama | 1045 | 4850 | 111 |
1310030 | 1310030 | 2021-05-12 | Dale | Alabama | 1045 | 4845 | 111 |
1306784 | 1306784 | 2021-05-11 | Dale | Alabama | 1045 | 4838 | 111 |
1303538 | 1303538 | 2021-05-10 | Dale | Alabama | 1045 | 4831 | 111 |
1300291 | 1300291 | 2021-05-09 | Dale | Alabama | 1045 | 4831 | 111 |
1297044 | 1297044 | 2021-05-08 | Dale | Alabama | 1045 | 4830 | 111 |
1293798 | 1293798 | 2021-05-07 | Dale | Alabama | 1045 | 4828 | 111 |
1290552 | 1290552 | 2021-05-06 | Dale | Alabama | 1045 | 4826 | 111 |
1287306 | 1287306 | 2021-05-05 | Dale | Alabama | 1045 | 4820 | 111 |
1284060 | 1284060 | 2021-05-04 | Dale | Alabama | 1045 | 4810 | 111 |
1280813 | 1280813 | 2021-05-03 | Dale | Alabama | 1045 | 4810 | 111 |
1277566 | 1277566 | 2021-05-02 | Dale | Alabama | 1045 | 4810 | 111 |
1274319 | 1274319 | 2021-05-01 | Dale | Alabama | 1045 | 4807 | 111 |
1271072 | 1271072 | 2021-04-30 | Dale | Alabama | 1045 | 4802 | 111 |
1267825 | 1267825 | 2021-04-29 | Dale | Alabama | 1045 | 4800 | 111 |
1264578 | 1264578 | 2021-04-28 | Dale | Alabama | 1045 | 4797 | 111 |
1261331 | 1261331 | 2021-04-27 | Dale | Alabama | 1045 | 4796 | 111 |
1258084 | 1258084 | 2021-04-26 | Dale | Alabama | 1045 | 4790 | 111 |
1254837 | 1254837 | 2021-04-25 | Dale | Alabama | 1045 | 4788 | 111 |
1251590 | 1251590 | 2021-04-24 | Dale | Alabama | 1045 | 4782 | 111 |
1248343 | 1248343 | 2021-04-23 | Dale | Alabama | 1045 | 4781 | 111 |
1245096 | 1245096 | 2021-04-22 | Dale | Alabama | 1045 | 4780 | 111 |
1241849 | 1241849 | 2021-04-21 | Dale | Alabama | 1045 | 4780 | 111 |
1238602 | 1238602 | 2021-04-20 | Dale | Alabama | 1045 | 4782 | 111 |
1235355 | 1235355 | 2021-04-19 | Dale | Alabama | 1045 | 4781 | 111 |
1232107 | 1232107 | 2021-04-18 | Dale | Alabama | 1045 | 4781 | 111 |
1228859 | 1228859 | 2021-04-17 | Dale | Alabama | 1045 | 4779 | 111 |
1225611 | 1225611 | 2021-04-16 | Dale | Alabama | 1045 | 4772 | 111 |
1222364 | 1222364 | 2021-04-15 | Dale | Alabama | 1045 | 4771 | 111 |
1219116 | 1219116 | 2021-04-14 | Dale | Alabama | 1045 | 4768 | 110 |
1215868 | 1215868 | 2021-04-13 | Dale | Alabama | 1045 | 4766 | 110 |
1212621 | 1212621 | 2021-04-12 | Dale | Alabama | 1045 | 4768 | 110 |
1209372 | 1209372 | 2021-04-11 | Dale | Alabama | 1045 | 4767 | 110 |
1206124 | 1206124 | 2021-04-10 | Dale | Alabama | 1045 | 4766 | 110 |
1202876 | 1202876 | 2021-04-09 | Dale | Alabama | 1045 | 4764 | 110 |
1199628 | 1199628 | 2021-04-08 | Dale | Alabama | 1045 | 4764 | 109 |
1196379 | 1196379 | 2021-04-07 | Dale | Alabama | 1045 | 4764 | 108 |
1193131 | 1193131 | 2021-04-06 | Dale | Alabama | 1045 | 4764 | 109 |
1189881 | 1189881 | 2021-04-05 | Dale | Alabama | 1045 | 4769 | 109 |
1186634 | 1186634 | 2021-04-04 | Dale | Alabama | 1045 | 4769 | 109 |
1183387 | 1183387 | 2021-04-03 | Dale | Alabama | 1045 | 4769 | 109 |
1180140 | 1180140 | 2021-04-02 | Dale | Alabama | 1045 | 4766 | 109 |
1176893 | 1176893 | 2021-04-01 | Dale | Alabama | 1045 | 4763 | 109 |
1173646 | 1173646 | 2021-03-31 | Dale | Alabama | 1045 | 4760 | 109 |
1170399 | 1170399 | 2021-03-30 | Dale | Alabama | 1045 | 4759 | 109 |
1167151 | 1167151 | 2021-03-29 | Dale | Alabama | 1045 | 4755 | 109 |
1163903 | 1163903 | 2021-03-28 | Dale | Alabama | 1045 | 4753 | 109 |
1160655 | 1160655 | 2021-03-27 | Dale | Alabama | 1045 | 4748 | 109 |
1157407 | 1157407 | 2021-03-26 | Dale | Alabama | 1045 | 4746 | 109 |
1154160 | 1154160 | 2021-03-25 | Dale | Alabama | 1045 | 4741 | 109 |
1150913 | 1150913 | 2021-03-24 | Dale | Alabama | 1045 | 4734 | 109 |
1147666 | 1147666 | 2021-03-23 | Dale | Alabama | 1045 | 4727 | 109 |
1144419 | 1144419 | 2021-03-22 | Dale | Alabama | 1045 | 4730 | 109 |
1141172 | 1141172 | 2021-03-21 | Dale | Alabama | 1045 | 4730 | 109 |
1137926 | 1137926 | 2021-03-20 | Dale | Alabama | 1045 | 4725 | 109 |
1134680 | 1134680 | 2021-03-19 | Dale | Alabama | 1045 | 4724 | 109 |
1131432 | 1131432 | 2021-03-18 | Dale | Alabama | 1045 | 4728 | 109 |
1128185 | 1128185 | 2021-03-17 | Dale | Alabama | 1045 | 4722 | 109 |
1124939 | 1124939 | 2021-03-16 | Dale | Alabama | 1045 | 4719 | 108 |
1121693 | 1121693 | 2021-03-15 | Dale | Alabama | 1045 | 4718 | 108 |
1118446 | 1118446 | 2021-03-14 | Dale | Alabama | 1045 | 4702 | 108 |
1115199 | 1115199 | 2021-03-13 | Dale | Alabama | 1045 | 4700 | 108 |
1111953 | 1111953 | 2021-03-12 | Dale | Alabama | 1045 | 4701 | 108 |
1108707 | 1108707 | 2021-03-11 | Dale | Alabama | 1045 | 4697 | 108 |
1105461 | 1105461 | 2021-03-10 | Dale | Alabama | 1045 | 4697 | 107 |
1102215 | 1102215 | 2021-03-09 | Dale | Alabama | 1045 | 4689 | 107 |
1098969 | 1098969 | 2021-03-08 | Dale | Alabama | 1045 | 4688 | 107 |
1095721 | 1095721 | 2021-03-07 | Dale | Alabama | 1045 | 4685 | 107 |
1092475 | 1092475 | 2021-03-06 | Dale | Alabama | 1045 | 4680 | 107 |
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);