ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 1093 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1387967 | 1387967 | 2021-06-05 | Marion | Alabama | 1093 | 3200 | 102 |
1384722 | 1384722 | 2021-06-04 | Marion | Alabama | 1093 | 3200 | 102 |
1381476 | 1381476 | 2021-06-03 | Marion | Alabama | 1093 | 3197 | 102 |
1378231 | 1378231 | 2021-06-02 | Marion | Alabama | 1093 | 3195 | 102 |
1374985 | 1374985 | 2021-06-01 | Marion | Alabama | 1093 | 3188 | 102 |
1371740 | 1371740 | 2021-05-31 | Marion | Alabama | 1093 | 3178 | 102 |
1368494 | 1368494 | 2021-05-30 | Marion | Alabama | 1093 | 3178 | 102 |
1365248 | 1365248 | 2021-05-29 | Marion | Alabama | 1093 | 3178 | 102 |
1362002 | 1362002 | 2021-05-28 | Marion | Alabama | 1093 | 3178 | 102 |
1358756 | 1358756 | 2021-05-27 | Marion | Alabama | 1093 | 3171 | 102 |
1355510 | 1355510 | 2021-05-26 | Marion | Alabama | 1093 | 3167 | 102 |
1352264 | 1352264 | 2021-05-25 | Marion | Alabama | 1093 | 3162 | 102 |
1349018 | 1349018 | 2021-05-24 | Marion | Alabama | 1093 | 3158 | 102 |
1345770 | 1345770 | 2021-05-23 | Marion | Alabama | 1093 | 3158 | 102 |
1342522 | 1342522 | 2021-05-22 | Marion | Alabama | 1093 | 3154 | 102 |
1339274 | 1339274 | 2021-05-21 | Marion | Alabama | 1093 | 3154 | 101 |
1336027 | 1336027 | 2021-05-20 | Marion | Alabama | 1093 | 3151 | 101 |
1332780 | 1332780 | 2021-05-19 | Marion | Alabama | 1093 | 3147 | 101 |
1329533 | 1329533 | 2021-05-18 | Marion | Alabama | 1093 | 3142 | 101 |
1326287 | 1326287 | 2021-05-17 | Marion | Alabama | 1093 | 3140 | 101 |
1323041 | 1323041 | 2021-05-16 | Marion | Alabama | 1093 | 3140 | 101 |
1319795 | 1319795 | 2021-05-15 | Marion | Alabama | 1093 | 3137 | 101 |
1316547 | 1316547 | 2021-05-14 | Marion | Alabama | 1093 | 3137 | 101 |
1313301 | 1313301 | 2021-05-13 | Marion | Alabama | 1093 | 3130 | 101 |
1310054 | 1310054 | 2021-05-12 | Marion | Alabama | 1093 | 3126 | 101 |
1306808 | 1306808 | 2021-05-11 | Marion | Alabama | 1093 | 3122 | 101 |
1303562 | 1303562 | 2021-05-10 | Marion | Alabama | 1093 | 3119 | 101 |
1300315 | 1300315 | 2021-05-09 | Marion | Alabama | 1093 | 3118 | 101 |
1297068 | 1297068 | 2021-05-08 | Marion | Alabama | 1093 | 3116 | 101 |
1293822 | 1293822 | 2021-05-07 | Marion | Alabama | 1093 | 3113 | 100 |
1290576 | 1290576 | 2021-05-06 | Marion | Alabama | 1093 | 3111 | 100 |
1287330 | 1287330 | 2021-05-05 | Marion | Alabama | 1093 | 3105 | 100 |
1284084 | 1284084 | 2021-05-04 | Marion | Alabama | 1093 | 3092 | 100 |
1280837 | 1280837 | 2021-05-03 | Marion | Alabama | 1093 | 3092 | 100 |
1277590 | 1277590 | 2021-05-02 | Marion | Alabama | 1093 | 3092 | 100 |
1274343 | 1274343 | 2021-05-01 | Marion | Alabama | 1093 | 3089 | 100 |
1271096 | 1271096 | 2021-04-30 | Marion | Alabama | 1093 | 3088 | 100 |
1267849 | 1267849 | 2021-04-29 | Marion | Alabama | 1093 | 3087 | 100 |
1264602 | 1264602 | 2021-04-28 | Marion | Alabama | 1093 | 3087 | 100 |
1261355 | 1261355 | 2021-04-27 | Marion | Alabama | 1093 | 3090 | 100 |
1258108 | 1258108 | 2021-04-26 | Marion | Alabama | 1093 | 3088 | 100 |
1254861 | 1254861 | 2021-04-25 | Marion | Alabama | 1093 | 3087 | 100 |
1251614 | 1251614 | 2021-04-24 | Marion | Alabama | 1093 | 3086 | 100 |
1248367 | 1248367 | 2021-04-23 | Marion | Alabama | 1093 | 3083 | 100 |
1245120 | 1245120 | 2021-04-22 | Marion | Alabama | 1093 | 3083 | 100 |
1241873 | 1241873 | 2021-04-21 | Marion | Alabama | 1093 | 3084 | 100 |
1238626 | 1238626 | 2021-04-20 | Marion | Alabama | 1093 | 3080 | 100 |
1235379 | 1235379 | 2021-04-19 | Marion | Alabama | 1093 | 3076 | 100 |
1232131 | 1232131 | 2021-04-18 | Marion | Alabama | 1093 | 3072 | 100 |
1228883 | 1228883 | 2021-04-17 | Marion | Alabama | 1093 | 3072 | 100 |
1225635 | 1225635 | 2021-04-16 | Marion | Alabama | 1093 | 3072 | 100 |
1222388 | 1222388 | 2021-04-15 | Marion | Alabama | 1093 | 3072 | 100 |
1219140 | 1219140 | 2021-04-14 | Marion | Alabama | 1093 | 3071 | 100 |
1215892 | 1215892 | 2021-04-13 | Marion | Alabama | 1093 | 3066 | 100 |
1212645 | 1212645 | 2021-04-12 | Marion | Alabama | 1093 | 3066 | 100 |
1209396 | 1209396 | 2021-04-11 | Marion | Alabama | 1093 | 3065 | 100 |
1206148 | 1206148 | 2021-04-10 | Marion | Alabama | 1093 | 3065 | 100 |
1202900 | 1202900 | 2021-04-09 | Marion | Alabama | 1093 | 3064 | 100 |
1199652 | 1199652 | 2021-04-08 | Marion | Alabama | 1093 | 3064 | 100 |
1196403 | 1196403 | 2021-04-07 | Marion | Alabama | 1093 | 3064 | 101 |
1193155 | 1193155 | 2021-04-06 | Marion | Alabama | 1093 | 3063 | 101 |
1189905 | 1189905 | 2021-04-05 | Marion | Alabama | 1093 | 3066 | 101 |
1186658 | 1186658 | 2021-04-04 | Marion | Alabama | 1093 | 3066 | 101 |
1183411 | 1183411 | 2021-04-03 | Marion | Alabama | 1093 | 3065 | 101 |
1180164 | 1180164 | 2021-04-02 | Marion | Alabama | 1093 | 3064 | 101 |
1176917 | 1176917 | 2021-04-01 | Marion | Alabama | 1093 | 3063 | 99 |
1173670 | 1173670 | 2021-03-31 | Marion | Alabama | 1093 | 3062 | 99 |
1170423 | 1170423 | 2021-03-30 | Marion | Alabama | 1093 | 3056 | 99 |
1167175 | 1167175 | 2021-03-29 | Marion | Alabama | 1093 | 3050 | 99 |
1163927 | 1163927 | 2021-03-28 | Marion | Alabama | 1093 | 3050 | 99 |
1160679 | 1160679 | 2021-03-27 | Marion | Alabama | 1093 | 3049 | 99 |
1157431 | 1157431 | 2021-03-26 | Marion | Alabama | 1093 | 3049 | 99 |
1154184 | 1154184 | 2021-03-25 | Marion | Alabama | 1093 | 3046 | 99 |
1150937 | 1150937 | 2021-03-24 | Marion | Alabama | 1093 | 3044 | 99 |
1147690 | 1147690 | 2021-03-23 | Marion | Alabama | 1093 | 3040 | 99 |
1144443 | 1144443 | 2021-03-22 | Marion | Alabama | 1093 | 3042 | 99 |
1141196 | 1141196 | 2021-03-21 | Marion | Alabama | 1093 | 3042 | 99 |
1137950 | 1137950 | 2021-03-20 | Marion | Alabama | 1093 | 3042 | 99 |
1134704 | 1134704 | 2021-03-19 | Marion | Alabama | 1093 | 3042 | 99 |
1131456 | 1131456 | 2021-03-18 | Marion | Alabama | 1093 | 3042 | 99 |
1128209 | 1128209 | 2021-03-17 | Marion | Alabama | 1093 | 3041 | 98 |
1124963 | 1124963 | 2021-03-16 | Marion | Alabama | 1093 | 3031 | 98 |
1121717 | 1121717 | 2021-03-15 | Marion | Alabama | 1093 | 3011 | 98 |
1118470 | 1118470 | 2021-03-14 | Marion | Alabama | 1093 | 2948 | 98 |
1115223 | 1115223 | 2021-03-13 | Marion | Alabama | 1093 | 2948 | 98 |
1111977 | 1111977 | 2021-03-12 | Marion | Alabama | 1093 | 2945 | 98 |
1108731 | 1108731 | 2021-03-11 | Marion | Alabama | 1093 | 2939 | 97 |
1105485 | 1105485 | 2021-03-10 | Marion | Alabama | 1093 | 2933 | 97 |
1102239 | 1102239 | 2021-03-09 | Marion | Alabama | 1093 | 2909 | 96 |
1098993 | 1098993 | 2021-03-08 | Marion | Alabama | 1093 | 2890 | 96 |
1095745 | 1095745 | 2021-03-07 | Marion | Alabama | 1093 | 2889 | 96 |
1092499 | 1092499 | 2021-03-06 | Marion | Alabama | 1093 | 2887 | 96 |
1089253 | 1089253 | 2021-03-05 | Marion | Alabama | 1093 | 2885 | 95 |
1086008 | 1086008 | 2021-03-04 | Marion | Alabama | 1093 | 2886 | 95 |
1082762 | 1082762 | 2021-03-03 | Marion | Alabama | 1093 | 2888 | 95 |
1079516 | 1079516 | 2021-03-02 | Marion | Alabama | 1093 | 2834 | 95 |
1076271 | 1076271 | 2021-03-01 | Marion | Alabama | 1093 | 2819 | 95 |
1073025 | 1073025 | 2021-02-28 | Marion | Alabama | 1093 | 2818 | 95 |
1069779 | 1069779 | 2021-02-27 | Marion | Alabama | 1093 | 2816 | 95 |
1066534 | 1066534 | 2021-02-26 | Marion | Alabama | 1093 | 2812 | 95 |
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);