ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Lee" and state = "Alabama" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1387961 | 1387961 | 2021-06-05 | Lee | Alabama | 1081 | 16190 | 173 |
1384716 | 1384716 | 2021-06-04 | Lee | Alabama | 1081 | 16190 | 173 |
1381470 | 1381470 | 2021-06-03 | Lee | Alabama | 1081 | 16171 | 173 |
1378225 | 1378225 | 2021-06-02 | Lee | Alabama | 1081 | 16153 | 173 |
1374979 | 1374979 | 2021-06-01 | Lee | Alabama | 1081 | 16135 | 173 |
1371734 | 1371734 | 2021-05-31 | Lee | Alabama | 1081 | 16115 | 173 |
1368488 | 1368488 | 2021-05-30 | Lee | Alabama | 1081 | 16115 | 173 |
1365242 | 1365242 | 2021-05-29 | Lee | Alabama | 1081 | 16115 | 173 |
1361996 | 1361996 | 2021-05-28 | Lee | Alabama | 1081 | 16115 | 173 |
1358750 | 1358750 | 2021-05-27 | Lee | Alabama | 1081 | 16104 | 173 |
1355504 | 1355504 | 2021-05-26 | Lee | Alabama | 1081 | 16084 | 173 |
1352258 | 1352258 | 2021-05-25 | Lee | Alabama | 1081 | 16060 | 173 |
1349012 | 1349012 | 2021-05-24 | Lee | Alabama | 1081 | 16049 | 173 |
1345764 | 1345764 | 2021-05-23 | Lee | Alabama | 1081 | 16049 | 173 |
1342516 | 1342516 | 2021-05-22 | Lee | Alabama | 1081 | 16040 | 173 |
1339268 | 1339268 | 2021-05-21 | Lee | Alabama | 1081 | 16034 | 172 |
1336021 | 1336021 | 2021-05-20 | Lee | Alabama | 1081 | 16017 | 172 |
1332774 | 1332774 | 2021-05-19 | Lee | Alabama | 1081 | 16011 | 172 |
1329527 | 1329527 | 2021-05-18 | Lee | Alabama | 1081 | 16005 | 172 |
1326281 | 1326281 | 2021-05-17 | Lee | Alabama | 1081 | 15997 | 172 |
1323035 | 1323035 | 2021-05-16 | Lee | Alabama | 1081 | 15993 | 172 |
1319789 | 1319789 | 2021-05-15 | Lee | Alabama | 1081 | 15987 | 172 |
1316541 | 1316541 | 2021-05-14 | Lee | Alabama | 1081 | 15946 | 171 |
1313295 | 1313295 | 2021-05-13 | Lee | Alabama | 1081 | 15892 | 171 |
1310048 | 1310048 | 2021-05-12 | Lee | Alabama | 1081 | 15887 | 171 |
1306802 | 1306802 | 2021-05-11 | Lee | Alabama | 1081 | 15882 | 171 |
1303556 | 1303556 | 2021-05-10 | Lee | Alabama | 1081 | 15886 | 171 |
1300309 | 1300309 | 2021-05-09 | Lee | Alabama | 1081 | 15884 | 171 |
1297062 | 1297062 | 2021-05-08 | Lee | Alabama | 1081 | 15873 | 171 |
1293816 | 1293816 | 2021-05-07 | Lee | Alabama | 1081 | 15856 | 171 |
1290570 | 1290570 | 2021-05-06 | Lee | Alabama | 1081 | 15844 | 169 |
1287324 | 1287324 | 2021-05-05 | Lee | Alabama | 1081 | 15822 | 169 |
1284078 | 1284078 | 2021-05-04 | Lee | Alabama | 1081 | 15800 | 168 |
1280831 | 1280831 | 2021-05-03 | Lee | Alabama | 1081 | 15800 | 168 |
1277584 | 1277584 | 2021-05-02 | Lee | Alabama | 1081 | 15796 | 168 |
1274337 | 1274337 | 2021-05-01 | Lee | Alabama | 1081 | 15792 | 168 |
1271090 | 1271090 | 2021-04-30 | Lee | Alabama | 1081 | 15784 | 168 |
1267843 | 1267843 | 2021-04-29 | Lee | Alabama | 1081 | 15773 | 168 |
1264596 | 1264596 | 2021-04-28 | Lee | Alabama | 1081 | 15761 | 168 |
1261349 | 1261349 | 2021-04-27 | Lee | Alabama | 1081 | 15742 | 168 |
1258102 | 1258102 | 2021-04-26 | Lee | Alabama | 1081 | 15731 | 168 |
1254855 | 1254855 | 2021-04-25 | Lee | Alabama | 1081 | 15723 | 168 |
1251608 | 1251608 | 2021-04-24 | Lee | Alabama | 1081 | 15722 | 168 |
1248361 | 1248361 | 2021-04-23 | Lee | Alabama | 1081 | 15709 | 167 |
1245114 | 1245114 | 2021-04-22 | Lee | Alabama | 1081 | 15694 | 167 |
1241867 | 1241867 | 2021-04-21 | Lee | Alabama | 1081 | 15670 | 166 |
1238620 | 1238620 | 2021-04-20 | Lee | Alabama | 1081 | 15642 | 166 |
1235373 | 1235373 | 2021-04-19 | Lee | Alabama | 1081 | 15638 | 166 |
1232125 | 1232125 | 2021-04-18 | Lee | Alabama | 1081 | 15631 | 166 |
1228877 | 1228877 | 2021-04-17 | Lee | Alabama | 1081 | 15614 | 166 |
1225629 | 1225629 | 2021-04-16 | Lee | Alabama | 1081 | 15589 | 165 |
1222382 | 1222382 | 2021-04-15 | Lee | Alabama | 1081 | 15567 | 165 |
1219134 | 1219134 | 2021-04-14 | Lee | Alabama | 1081 | 15552 | 165 |
1215886 | 1215886 | 2021-04-13 | Lee | Alabama | 1081 | 15541 | 165 |
1212639 | 1212639 | 2021-04-12 | Lee | Alabama | 1081 | 15524 | 165 |
1209390 | 1209390 | 2021-04-11 | Lee | Alabama | 1081 | 15524 | 165 |
1206142 | 1206142 | 2021-04-10 | Lee | Alabama | 1081 | 15510 | 165 |
1202894 | 1202894 | 2021-04-09 | Lee | Alabama | 1081 | 15491 | 165 |
1199646 | 1199646 | 2021-04-08 | Lee | Alabama | 1081 | 15480 | 165 |
1196397 | 1196397 | 2021-04-07 | Lee | Alabama | 1081 | 15468 | 165 |
1193149 | 1193149 | 2021-04-06 | Lee | Alabama | 1081 | 15468 | 165 |
1189899 | 1189899 | 2021-04-05 | Lee | Alabama | 1081 | 15459 | 166 |
1186652 | 1186652 | 2021-04-04 | Lee | Alabama | 1081 | 15457 | 166 |
1183405 | 1183405 | 2021-04-03 | Lee | Alabama | 1081 | 15452 | 166 |
1180158 | 1180158 | 2021-04-02 | Lee | Alabama | 1081 | 15444 | 166 |
1176911 | 1176911 | 2021-04-01 | Lee | Alabama | 1081 | 15433 | 166 |
1173664 | 1173664 | 2021-03-31 | Lee | Alabama | 1081 | 15417 | 166 |
1170417 | 1170417 | 2021-03-30 | Lee | Alabama | 1081 | 15397 | 166 |
1167169 | 1167169 | 2021-03-29 | Lee | Alabama | 1081 | 15394 | 166 |
1163921 | 1163921 | 2021-03-28 | Lee | Alabama | 1081 | 15389 | 166 |
1160673 | 1160673 | 2021-03-27 | Lee | Alabama | 1081 | 15381 | 166 |
1157425 | 1157425 | 2021-03-26 | Lee | Alabama | 1081 | 15371 | 166 |
1154178 | 1154178 | 2021-03-25 | Lee | Alabama | 1081 | 15355 | 166 |
1150931 | 1150931 | 2021-03-24 | Lee | Alabama | 1081 | 15333 | 166 |
1147684 | 1147684 | 2021-03-23 | Lee | Alabama | 1081 | 15292 | 166 |
1144437 | 1144437 | 2021-03-22 | Lee | Alabama | 1081 | 15290 | 166 |
1141190 | 1141190 | 2021-03-21 | Lee | Alabama | 1081 | 15282 | 166 |
1137944 | 1137944 | 2021-03-20 | Lee | Alabama | 1081 | 15274 | 166 |
1134698 | 1134698 | 2021-03-19 | Lee | Alabama | 1081 | 15248 | 166 |
1131450 | 1131450 | 2021-03-18 | Lee | Alabama | 1081 | 15231 | 163 |
1128203 | 1128203 | 2021-03-17 | Lee | Alabama | 1081 | 15218 | 163 |
1124957 | 1124957 | 2021-03-16 | Lee | Alabama | 1081 | 15205 | 163 |
1121711 | 1121711 | 2021-03-15 | Lee | Alabama | 1081 | 15197 | 163 |
1118464 | 1118464 | 2021-03-14 | Lee | Alabama | 1081 | 15147 | 163 |
1115217 | 1115217 | 2021-03-13 | Lee | Alabama | 1081 | 15138 | 163 |
1111971 | 1111971 | 2021-03-12 | Lee | Alabama | 1081 | 15122 | 162 |
1108725 | 1108725 | 2021-03-11 | Lee | Alabama | 1081 | 15117 | 162 |
1105479 | 1105479 | 2021-03-10 | Lee | Alabama | 1081 | 15108 | 161 |
1102233 | 1102233 | 2021-03-09 | Lee | Alabama | 1081 | 15087 | 161 |
1098987 | 1098987 | 2021-03-08 | Lee | Alabama | 1081 | 15084 | 161 |
1095739 | 1095739 | 2021-03-07 | Lee | Alabama | 1081 | 15083 | 161 |
1092493 | 1092493 | 2021-03-06 | Lee | Alabama | 1081 | 15070 | 161 |
1089247 | 1089247 | 2021-03-05 | Lee | Alabama | 1081 | 15057 | 158 |
1086002 | 1086002 | 2021-03-04 | Lee | Alabama | 1081 | 15039 | 157 |
1082756 | 1082756 | 2021-03-03 | Lee | Alabama | 1081 | 15021 | 155 |
1079510 | 1079510 | 2021-03-02 | Lee | Alabama | 1081 | 14980 | 154 |
1076265 | 1076265 | 2021-03-01 | Lee | Alabama | 1081 | 14967 | 153 |
1073019 | 1073019 | 2021-02-28 | Lee | Alabama | 1081 | 14961 | 153 |
1069773 | 1069773 | 2021-02-27 | Lee | Alabama | 1081 | 14950 | 153 |
1066528 | 1066528 | 2021-02-26 | Lee | Alabama | 1081 | 14926 | 151 |
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);