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 |
---|---|---|---|---|---|---|---|
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 |
1063247 | 1063247 | 2021-02-25 | Blount | Alabama | 1009 | 6086 | 125 |
1060002 | 1060002 | 2021-02-24 | Blount | Alabama | 1009 | 6072 | 125 |
1056756 | 1056756 | 2021-02-23 | Blount | Alabama | 1009 | 6058 | 125 |
1053510 | 1053510 | 2021-02-22 | Blount | Alabama | 1009 | 6043 | 125 |
1050263 | 1050263 | 2021-02-21 | Blount | Alabama | 1009 | 6042 | 125 |
1047016 | 1047016 | 2021-02-20 | Blount | Alabama | 1009 | 6040 | 125 |
1043771 | 1043771 | 2021-02-19 | Blount | Alabama | 1009 | 6021 | 125 |
1040526 | 1040526 | 2021-02-18 | Blount | Alabama | 1009 | 6008 | 121 |
1037281 | 1037281 | 2021-02-17 | Blount | Alabama | 1009 | 5997 | 121 |
1034036 | 1034036 | 2021-02-16 | Blount | Alabama | 1009 | 5987 | 121 |
1030790 | 1030790 | 2021-02-15 | Blount | Alabama | 1009 | 5973 | 121 |
1027543 | 1027543 | 2021-02-14 | Blount | Alabama | 1009 | 5961 | 121 |
1024298 | 1024298 | 2021-02-13 | Blount | Alabama | 1009 | 5957 | 121 |
1021053 | 1021053 | 2021-02-12 | Blount | Alabama | 1009 | 5953 | 121 |
1017808 | 1017808 | 2021-02-11 | Blount | Alabama | 1009 | 5955 | 116 |
1014563 | 1014563 | 2021-02-10 | Blount | Alabama | 1009 | 5937 | 116 |
1011318 | 1011318 | 2021-02-09 | Blount | Alabama | 1009 | 5929 | 113 |
1008072 | 1008072 | 2021-02-08 | Blount | Alabama | 1009 | 5920 | 112 |
1004826 | 1004826 | 2021-02-07 | Blount | Alabama | 1009 | 5915 | 112 |
1001580 | 1001580 | 2021-02-06 | Blount | Alabama | 1009 | 5908 | 112 |
998334 | 998334 | 2021-02-05 | Blount | Alabama | 1009 | 5871 | 111 |
995088 | 995088 | 2021-02-04 | Blount | Alabama | 1009 | 5842 | 109 |
991842 | 991842 | 2021-02-03 | Blount | Alabama | 1009 | 5768 | 105 |
988596 | 988596 | 2021-02-02 | Blount | Alabama | 1009 | 5745 | 101 |
985349 | 985349 | 2021-02-01 | Blount | Alabama | 1009 | 5720 | 100 |
982102 | 982102 | 2021-01-31 | Blount | Alabama | 1009 | 5713 | 100 |
978856 | 978856 | 2021-01-30 | Blount | Alabama | 1009 | 5655 | 98 |
975611 | 975611 | 2021-01-29 | Blount | Alabama | 1009 | 5655 | 98 |
972366 | 972366 | 2021-01-28 | Blount | Alabama | 1009 | 5612 | 98 |
969121 | 969121 | 2021-01-27 | Blount | Alabama | 1009 | 5568 | 95 |
965877 | 965877 | 2021-01-26 | Blount | Alabama | 1009 | 5517 | 94 |
962632 | 962632 | 2021-01-25 | Blount | Alabama | 1009 | 5485 | 86 |
959387 | 959387 | 2021-01-24 | Blount | Alabama | 1009 | 5473 | 86 |
956141 | 956141 | 2021-01-23 | Blount | Alabama | 1009 | 5462 | 86 |
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);