ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where fips = 1001 and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1277544 | 1277544 | 2021-05-02 | Autauga | Alabama | 1001 | 6909 | 107 |
1274297 | 1274297 | 2021-05-01 | Autauga | Alabama | 1001 | 6907 | 107 |
1271050 | 1271050 | 2021-04-30 | Autauga | Alabama | 1001 | 6904 | 107 |
1267803 | 1267803 | 2021-04-29 | Autauga | Alabama | 1001 | 6897 | 107 |
1264556 | 1264556 | 2021-04-28 | Autauga | Alabama | 1001 | 6890 | 107 |
1261309 | 1261309 | 2021-04-27 | Autauga | Alabama | 1001 | 6889 | 107 |
1258062 | 1258062 | 2021-04-26 | Autauga | Alabama | 1001 | 6882 | 107 |
1254815 | 1254815 | 2021-04-25 | Autauga | Alabama | 1001 | 6879 | 107 |
1251568 | 1251568 | 2021-04-24 | Autauga | Alabama | 1001 | 6876 | 107 |
1248321 | 1248321 | 2021-04-23 | Autauga | Alabama | 1001 | 6835 | 107 |
1245074 | 1245074 | 2021-04-22 | Autauga | Alabama | 1001 | 6819 | 107 |
1241827 | 1241827 | 2021-04-21 | Autauga | Alabama | 1001 | 6793 | 107 |
1238580 | 1238580 | 2021-04-20 | Autauga | Alabama | 1001 | 6773 | 106 |
1235333 | 1235333 | 2021-04-19 | Autauga | Alabama | 1001 | 6763 | 106 |
1232085 | 1232085 | 2021-04-18 | Autauga | Alabama | 1001 | 6763 | 106 |
1228837 | 1228837 | 2021-04-17 | Autauga | Alabama | 1001 | 6760 | 106 |
1225589 | 1225589 | 2021-04-16 | Autauga | Alabama | 1001 | 6750 | 103 |
1222342 | 1222342 | 2021-04-15 | Autauga | Alabama | 1001 | 6748 | 103 |
1219094 | 1219094 | 2021-04-14 | Autauga | Alabama | 1001 | 6740 | 103 |
1215846 | 1215846 | 2021-04-13 | Autauga | Alabama | 1001 | 6734 | 103 |
1212599 | 1212599 | 2021-04-12 | Autauga | Alabama | 1001 | 6727 | 103 |
1209350 | 1209350 | 2021-04-11 | Autauga | Alabama | 1001 | 6723 | 103 |
1206102 | 1206102 | 2021-04-10 | Autauga | Alabama | 1001 | 6715 | 103 |
1202854 | 1202854 | 2021-04-09 | Autauga | Alabama | 1001 | 6710 | 103 |
1199606 | 1199606 | 2021-04-08 | Autauga | Alabama | 1001 | 6702 | 103 |
1196357 | 1196357 | 2021-04-07 | Autauga | Alabama | 1001 | 6675 | 102 |
1193109 | 1193109 | 2021-04-06 | Autauga | Alabama | 1001 | 6644 | 102 |
1189859 | 1189859 | 2021-04-05 | Autauga | Alabama | 1001 | 6620 | 102 |
1186612 | 1186612 | 2021-04-04 | Autauga | Alabama | 1001 | 6619 | 102 |
1183365 | 1183365 | 2021-04-03 | Autauga | Alabama | 1001 | 6617 | 102 |
1180118 | 1180118 | 2021-04-02 | Autauga | Alabama | 1001 | 6606 | 99 |
1176871 | 1176871 | 2021-04-01 | Autauga | Alabama | 1001 | 6595 | 99 |
1173624 | 1173624 | 2021-03-31 | Autauga | Alabama | 1001 | 6589 | 99 |
1170377 | 1170377 | 2021-03-30 | Autauga | Alabama | 1001 | 6580 | 99 |
1167129 | 1167129 | 2021-03-29 | Autauga | Alabama | 1001 | 6577 | 99 |
1163881 | 1163881 | 2021-03-28 | Autauga | Alabama | 1001 | 6570 | 99 |
1160633 | 1160633 | 2021-03-27 | Autauga | Alabama | 1001 | 6562 | 99 |
1157385 | 1157385 | 2021-03-26 | Autauga | Alabama | 1001 | 6543 | 99 |
1154138 | 1154138 | 2021-03-25 | Autauga | Alabama | 1001 | 6540 | 99 |
1150891 | 1150891 | 2021-03-24 | Autauga | Alabama | 1001 | 6533 | 99 |
1147644 | 1147644 | 2021-03-23 | Autauga | Alabama | 1001 | 6525 | 99 |
1144397 | 1144397 | 2021-03-22 | Autauga | Alabama | 1001 | 6517 | 98 |
1141150 | 1141150 | 2021-03-21 | Autauga | Alabama | 1001 | 6513 | 98 |
1137904 | 1137904 | 2021-03-20 | Autauga | Alabama | 1001 | 6510 | 98 |
1134658 | 1134658 | 2021-03-19 | Autauga | Alabama | 1001 | 6498 | 98 |
1131410 | 1131410 | 2021-03-18 | Autauga | Alabama | 1001 | 6495 | 98 |
1128163 | 1128163 | 2021-03-17 | Autauga | Alabama | 1001 | 6483 | 96 |
1124917 | 1124917 | 2021-03-16 | Autauga | Alabama | 1001 | 6474 | 95 |
1121671 | 1121671 | 2021-03-15 | Autauga | Alabama | 1001 | 6471 | 95 |
1118424 | 1118424 | 2021-03-14 | Autauga | Alabama | 1001 | 6426 | 95 |
1115177 | 1115177 | 2021-03-13 | Autauga | Alabama | 1001 | 6416 | 95 |
1111931 | 1111931 | 2021-03-12 | Autauga | Alabama | 1001 | 6409 | 95 |
1108685 | 1108685 | 2021-03-11 | Autauga | Alabama | 1001 | 6409 | 95 |
1105439 | 1105439 | 2021-03-10 | Autauga | Alabama | 1001 | 6400 | 93 |
1102193 | 1102193 | 2021-03-09 | Autauga | Alabama | 1001 | 6371 | 92 |
1098947 | 1098947 | 2021-03-08 | Autauga | Alabama | 1001 | 6364 | 92 |
1095699 | 1095699 | 2021-03-07 | Autauga | Alabama | 1001 | 6347 | 92 |
1092453 | 1092453 | 2021-03-06 | Autauga | Alabama | 1001 | 6344 | 92 |
1089207 | 1089207 | 2021-03-05 | Autauga | Alabama | 1001 | 6333 | 92 |
1085962 | 1085962 | 2021-03-04 | Autauga | Alabama | 1001 | 6324 | 92 |
1082716 | 1082716 | 2021-03-03 | Autauga | Alabama | 1001 | 6313 | 91 |
1079470 | 1079470 | 2021-03-02 | Autauga | Alabama | 1001 | 6303 | 91 |
1076225 | 1076225 | 2021-03-01 | Autauga | Alabama | 1001 | 6270 | 91 |
1072979 | 1072979 | 2021-02-28 | Autauga | Alabama | 1001 | 6264 | 91 |
1069733 | 1069733 | 2021-02-27 | Autauga | Alabama | 1001 | 6248 | 91 |
1066488 | 1066488 | 2021-02-26 | Autauga | Alabama | 1001 | 6228 | 90 |
1063243 | 1063243 | 2021-02-25 | Autauga | Alabama | 1001 | 6203 | 89 |
1059998 | 1059998 | 2021-02-24 | Autauga | Alabama | 1001 | 6172 | 85 |
1056752 | 1056752 | 2021-02-23 | Autauga | Alabama | 1001 | 6143 | 84 |
1053506 | 1053506 | 2021-02-22 | Autauga | Alabama | 1001 | 6121 | 85 |
1050259 | 1050259 | 2021-02-21 | Autauga | Alabama | 1001 | 6117 | 85 |
1047012 | 1047012 | 2021-02-20 | Autauga | Alabama | 1001 | 6092 | 85 |
1043767 | 1043767 | 2021-02-19 | Autauga | Alabama | 1001 | 6079 | 85 |
1040522 | 1040522 | 2021-02-18 | Autauga | Alabama | 1001 | 6071 | 84 |
1037277 | 1037277 | 2021-02-17 | Autauga | Alabama | 1001 | 6050 | 84 |
1034032 | 1034032 | 2021-02-16 | Autauga | Alabama | 1001 | 6038 | 84 |
1030786 | 1030786 | 2021-02-15 | Autauga | Alabama | 1001 | 6024 | 84 |
1027539 | 1027539 | 2021-02-14 | Autauga | Alabama | 1001 | 6023 | 84 |
1024294 | 1024294 | 2021-02-13 | Autauga | Alabama | 1001 | 6002 | 84 |
1021049 | 1021049 | 2021-02-12 | Autauga | Alabama | 1001 | 5984 | 84 |
1017804 | 1017804 | 2021-02-11 | Autauga | Alabama | 1001 | 5970 | 81 |
1014559 | 1014559 | 2021-02-10 | Autauga | Alabama | 1001 | 5930 | 79 |
1011314 | 1011314 | 2021-02-09 | Autauga | Alabama | 1001 | 5910 | 77 |
1008068 | 1008068 | 2021-02-08 | Autauga | Alabama | 1001 | 5881 | 77 |
1004822 | 1004822 | 2021-02-07 | Autauga | Alabama | 1001 | 5869 | 77 |
1001576 | 1001576 | 2021-02-06 | Autauga | Alabama | 1001 | 5856 | 77 |
998330 | 998330 | 2021-02-05 | Autauga | Alabama | 1001 | 5824 | 76 |
995084 | 995084 | 2021-02-04 | Autauga | Alabama | 1001 | 5811 | 74 |
991838 | 991838 | 2021-02-03 | Autauga | Alabama | 1001 | 5753 | 71 |
988592 | 988592 | 2021-02-02 | Autauga | Alabama | 1001 | 5723 | 70 |
985345 | 985345 | 2021-02-01 | Autauga | Alabama | 1001 | 5683 | 69 |
982098 | 982098 | 2021-01-31 | Autauga | Alabama | 1001 | 5669 | 69 |
978852 | 978852 | 2021-01-30 | Autauga | Alabama | 1001 | 5596 | 69 |
975607 | 975607 | 2021-01-29 | Autauga | Alabama | 1001 | 5596 | 69 |
972362 | 972362 | 2021-01-28 | Autauga | Alabama | 1001 | 5554 | 69 |
969117 | 969117 | 2021-01-27 | Autauga | Alabama | 1001 | 5499 | 67 |
965873 | 965873 | 2021-01-26 | Autauga | Alabama | 1001 | 5440 | 65 |
962628 | 962628 | 2021-01-25 | Autauga | Alabama | 1001 | 5407 | 62 |
959383 | 959383 | 2021-01-24 | Autauga | Alabama | 1001 | 5376 | 62 |
956137 | 956137 | 2021-01-23 | Autauga | Alabama | 1001 | 5358 | 62 |
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);