ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Douglas" and state = "Wisconsin" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1420295 | 1420295 | 2021-06-14 | Douglas | Wisconsin | 55031 | 4996 | 63 |
1417050 | 1417050 | 2021-06-13 | Douglas | Wisconsin | 55031 | 4992 | 63 |
1413804 | 1413804 | 2021-06-12 | Douglas | Wisconsin | 55031 | 4992 | 63 |
1410559 | 1410559 | 2021-06-11 | Douglas | Wisconsin | 55031 | 4992 | 63 |
1407314 | 1407314 | 2021-06-10 | Douglas | Wisconsin | 55031 | 4991 | 63 |
1404068 | 1404068 | 2021-06-09 | Douglas | Wisconsin | 55031 | 4990 | 63 |
1400823 | 1400823 | 2021-06-08 | Douglas | Wisconsin | 55031 | 4989 | 61 |
1397578 | 1397578 | 2021-06-07 | Douglas | Wisconsin | 55031 | 4987 | 61 |
1394331 | 1394331 | 2021-06-06 | Douglas | Wisconsin | 55031 | 4980 | 61 |
1391086 | 1391086 | 2021-06-05 | Douglas | Wisconsin | 55031 | 4980 | 61 |
1387841 | 1387841 | 2021-06-04 | Douglas | Wisconsin | 55031 | 4980 | 61 |
1384596 | 1384596 | 2021-06-03 | Douglas | Wisconsin | 55031 | 4978 | 61 |
1381350 | 1381350 | 2021-06-02 | Douglas | Wisconsin | 55031 | 4977 | 60 |
1378105 | 1378105 | 2021-06-01 | Douglas | Wisconsin | 55031 | 4972 | 58 |
1374859 | 1374859 | 2021-05-31 | Douglas | Wisconsin | 55031 | 4972 | 58 |
1371614 | 1371614 | 2021-05-30 | Douglas | Wisconsin | 55031 | 4966 | 58 |
1368368 | 1368368 | 2021-05-29 | Douglas | Wisconsin | 55031 | 4966 | 58 |
1365122 | 1365122 | 2021-05-28 | Douglas | Wisconsin | 55031 | 4966 | 58 |
1361876 | 1361876 | 2021-05-27 | Douglas | Wisconsin | 55031 | 4956 | 58 |
1358630 | 1358630 | 2021-05-26 | Douglas | Wisconsin | 55031 | 4952 | 58 |
1355384 | 1355384 | 2021-05-25 | Douglas | Wisconsin | 55031 | 4945 | 58 |
1352138 | 1352138 | 2021-05-24 | Douglas | Wisconsin | 55031 | 4942 | 58 |
1348892 | 1348892 | 2021-05-23 | Douglas | Wisconsin | 55031 | 4933 | 58 |
1345644 | 1345644 | 2021-05-22 | Douglas | Wisconsin | 55031 | 4929 | 58 |
1342396 | 1342396 | 2021-05-21 | Douglas | Wisconsin | 55031 | 4922 | 58 |
1339148 | 1339148 | 2021-05-20 | Douglas | Wisconsin | 55031 | 4905 | 58 |
1335901 | 1335901 | 2021-05-19 | Douglas | Wisconsin | 55031 | 4896 | 58 |
1332654 | 1332654 | 2021-05-18 | Douglas | Wisconsin | 55031 | 4884 | 57 |
1329407 | 1329407 | 2021-05-17 | Douglas | Wisconsin | 55031 | 4878 | 57 |
1326161 | 1326161 | 2021-05-16 | Douglas | Wisconsin | 55031 | 4874 | 57 |
1322915 | 1322915 | 2021-05-15 | Douglas | Wisconsin | 55031 | 4874 | 57 |
1319669 | 1319669 | 2021-05-14 | Douglas | Wisconsin | 55031 | 4866 | 57 |
1316421 | 1316421 | 2021-05-13 | Douglas | Wisconsin | 55031 | 4856 | 57 |
1313175 | 1313175 | 2021-05-12 | Douglas | Wisconsin | 55031 | 4846 | 55 |
1309928 | 1309928 | 2021-05-11 | Douglas | Wisconsin | 55031 | 4838 | 54 |
1306682 | 1306682 | 2021-05-10 | Douglas | Wisconsin | 55031 | 4833 | 54 |
1303436 | 1303436 | 2021-05-09 | Douglas | Wisconsin | 55031 | 4822 | 54 |
1300189 | 1300189 | 2021-05-08 | Douglas | Wisconsin | 55031 | 4822 | 54 |
1296942 | 1296942 | 2021-05-07 | Douglas | Wisconsin | 55031 | 4811 | 52 |
1293696 | 1293696 | 2021-05-06 | Douglas | Wisconsin | 55031 | 4800 | 51 |
1290450 | 1290450 | 2021-05-05 | Douglas | Wisconsin | 55031 | 4785 | 51 |
1287204 | 1287204 | 2021-05-04 | Douglas | Wisconsin | 55031 | 4777 | 51 |
1283958 | 1283958 | 2021-05-03 | Douglas | Wisconsin | 55031 | 4767 | 51 |
1280711 | 1280711 | 2021-05-02 | Douglas | Wisconsin | 55031 | 4740 | 51 |
1277464 | 1277464 | 2021-05-01 | Douglas | Wisconsin | 55031 | 4741 | 51 |
1274217 | 1274217 | 2021-04-30 | Douglas | Wisconsin | 55031 | 4730 | 51 |
1270970 | 1270970 | 2021-04-29 | Douglas | Wisconsin | 55031 | 4722 | 51 |
1267723 | 1267723 | 2021-04-28 | Douglas | Wisconsin | 55031 | 4719 | 51 |
1264476 | 1264476 | 2021-04-27 | Douglas | Wisconsin | 55031 | 4708 | 51 |
1261229 | 1261229 | 2021-04-26 | Douglas | Wisconsin | 55031 | 4701 | 50 |
1257982 | 1257982 | 2021-04-25 | Douglas | Wisconsin | 55031 | 4696 | 50 |
1254735 | 1254735 | 2021-04-24 | Douglas | Wisconsin | 55031 | 4687 | 50 |
1251488 | 1251488 | 2021-04-23 | Douglas | Wisconsin | 55031 | 4677 | 50 |
1248241 | 1248241 | 2021-04-22 | Douglas | Wisconsin | 55031 | 4695 | 50 |
1244994 | 1244994 | 2021-04-21 | Douglas | Wisconsin | 55031 | 4692 | 50 |
1241747 | 1241747 | 2021-04-20 | Douglas | Wisconsin | 55031 | 4676 | 50 |
1238500 | 1238500 | 2021-04-19 | Douglas | Wisconsin | 55031 | 4661 | 49 |
1235253 | 1235253 | 2021-04-18 | Douglas | Wisconsin | 55031 | 4660 | 49 |
1232005 | 1232005 | 2021-04-17 | Douglas | Wisconsin | 55031 | 4659 | 49 |
1228757 | 1228757 | 2021-04-16 | Douglas | Wisconsin | 55031 | 4630 | 49 |
1225509 | 1225509 | 2021-04-15 | Douglas | Wisconsin | 55031 | 4613 | 49 |
1222262 | 1222262 | 2021-04-14 | Douglas | Wisconsin | 55031 | 4582 | 49 |
1219014 | 1219014 | 2021-04-13 | Douglas | Wisconsin | 55031 | 4576 | 49 |
1215766 | 1215766 | 2021-04-12 | Douglas | Wisconsin | 55031 | 4566 | 49 |
1212519 | 1212519 | 2021-04-11 | Douglas | Wisconsin | 55031 | 4556 | 49 |
1209270 | 1209270 | 2021-04-10 | Douglas | Wisconsin | 55031 | 4546 | 49 |
1206022 | 1206022 | 2021-04-09 | Douglas | Wisconsin | 55031 | 4516 | 49 |
1202774 | 1202774 | 2021-04-08 | Douglas | Wisconsin | 55031 | 4495 | 49 |
1199526 | 1199526 | 2021-04-07 | Douglas | Wisconsin | 55031 | 4483 | 47 |
1196277 | 1196277 | 2021-04-06 | Douglas | Wisconsin | 55031 | 4462 | 47 |
1193029 | 1193029 | 2021-04-05 | Douglas | Wisconsin | 55031 | 4453 | 47 |
1189779 | 1189779 | 2021-04-04 | Douglas | Wisconsin | 55031 | 4443 | 47 |
1186532 | 1186532 | 2021-04-03 | Douglas | Wisconsin | 55031 | 4440 | 47 |
1183285 | 1183285 | 2021-04-02 | Douglas | Wisconsin | 55031 | 4429 | 47 |
1180038 | 1180038 | 2021-04-01 | Douglas | Wisconsin | 55031 | 4420 | 47 |
1176791 | 1176791 | 2021-03-31 | Douglas | Wisconsin | 55031 | 4398 | 47 |
1173544 | 1173544 | 2021-03-30 | Douglas | Wisconsin | 55031 | 4398 | 47 |
1170297 | 1170297 | 2021-03-29 | Douglas | Wisconsin | 55031 | 4392 | 46 |
1167049 | 1167049 | 2021-03-28 | Douglas | Wisconsin | 55031 | 4392 | 46 |
1163801 | 1163801 | 2021-03-27 | Douglas | Wisconsin | 55031 | 4377 | 46 |
1160553 | 1160553 | 2021-03-26 | Douglas | Wisconsin | 55031 | 4362 | 46 |
1157305 | 1157305 | 2021-03-25 | Douglas | Wisconsin | 55031 | 4349 | 46 |
1154058 | 1154058 | 2021-03-24 | Douglas | Wisconsin | 55031 | 4335 | 46 |
1150811 | 1150811 | 2021-03-23 | Douglas | Wisconsin | 55031 | 4321 | 45 |
1147564 | 1147564 | 2021-03-22 | Douglas | Wisconsin | 55031 | 4321 | 45 |
1144317 | 1144317 | 2021-03-21 | Douglas | Wisconsin | 55031 | 4317 | 45 |
1141070 | 1141070 | 2021-03-20 | Douglas | Wisconsin | 55031 | 4316 | 45 |
1137824 | 1137824 | 2021-03-19 | Douglas | Wisconsin | 55031 | 4314 | 45 |
1134578 | 1134578 | 2021-03-18 | Douglas | Wisconsin | 55031 | 4305 | 45 |
1131330 | 1131330 | 2021-03-17 | Douglas | Wisconsin | 55031 | 4299 | 45 |
1128083 | 1128083 | 2021-03-16 | Douglas | Wisconsin | 55031 | 4295 | 45 |
1124837 | 1124837 | 2021-03-15 | Douglas | Wisconsin | 55031 | 4291 | 44 |
1121591 | 1121591 | 2021-03-14 | Douglas | Wisconsin | 55031 | 4288 | 44 |
1118344 | 1118344 | 2021-03-13 | Douglas | Wisconsin | 55031 | 4285 | 44 |
1115097 | 1115097 | 2021-03-12 | Douglas | Wisconsin | 55031 | 4276 | 44 |
1111851 | 1111851 | 2021-03-11 | Douglas | Wisconsin | 55031 | 4275 | 44 |
1108605 | 1108605 | 2021-03-10 | Douglas | Wisconsin | 55031 | 4270 | 43 |
1105359 | 1105359 | 2021-03-09 | Douglas | Wisconsin | 55031 | 4268 | 43 |
1102113 | 1102113 | 2021-03-08 | Douglas | Wisconsin | 55031 | 4267 | 42 |
1098867 | 1098867 | 2021-03-07 | Douglas | Wisconsin | 55031 | 4266 | 42 |
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);