ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
103 rows where county = "McLeod", deaths = 61 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1697778 | 1697778 | 2021-09-08 | McLeod | Minnesota | 27085 | 4811 | 61 |
1694530 | 1694530 | 2021-09-07 | McLeod | Minnesota | 27085 | 4746 | 61 |
1691281 | 1691281 | 2021-09-06 | McLeod | Minnesota | 27085 | 4722 | 61 |
1688031 | 1688031 | 2021-09-05 | McLeod | Minnesota | 27085 | 4722 | 61 |
1684781 | 1684781 | 2021-09-04 | McLeod | Minnesota | 27085 | 4722 | 61 |
1681530 | 1681530 | 2021-09-03 | McLeod | Minnesota | 27085 | 4722 | 61 |
1678282 | 1678282 | 2021-09-02 | McLeod | Minnesota | 27085 | 4694 | 61 |
1675034 | 1675034 | 2021-09-01 | McLeod | Minnesota | 27085 | 4682 | 61 |
1671786 | 1671786 | 2021-08-31 | McLeod | Minnesota | 27085 | 4662 | 61 |
1668539 | 1668539 | 2021-08-30 | McLeod | Minnesota | 27085 | 4630 | 61 |
1665292 | 1665292 | 2021-08-29 | McLeod | Minnesota | 27085 | 4616 | 61 |
1662044 | 1662044 | 2021-08-28 | McLeod | Minnesota | 27085 | 4616 | 61 |
1658796 | 1658796 | 2021-08-27 | McLeod | Minnesota | 27085 | 4616 | 61 |
1655547 | 1655547 | 2021-08-26 | McLeod | Minnesota | 27085 | 4597 | 61 |
1652300 | 1652300 | 2021-08-25 | McLeod | Minnesota | 27085 | 4577 | 61 |
1649052 | 1649052 | 2021-08-24 | McLeod | Minnesota | 27085 | 4570 | 61 |
1645803 | 1645803 | 2021-08-23 | McLeod | Minnesota | 27085 | 4538 | 61 |
1642554 | 1642554 | 2021-08-22 | McLeod | Minnesota | 27085 | 4529 | 61 |
1639304 | 1639304 | 2021-08-21 | McLeod | Minnesota | 27085 | 4529 | 61 |
1636054 | 1636054 | 2021-08-20 | McLeod | Minnesota | 27085 | 4529 | 61 |
1632804 | 1632804 | 2021-08-19 | McLeod | Minnesota | 27085 | 4515 | 61 |
1629557 | 1629557 | 2021-08-18 | McLeod | Minnesota | 27085 | 4508 | 61 |
1626310 | 1626310 | 2021-08-17 | McLeod | Minnesota | 27085 | 4500 | 61 |
1623063 | 1623063 | 2021-08-16 | McLeod | Minnesota | 27085 | 4475 | 61 |
1619816 | 1619816 | 2021-08-15 | McLeod | Minnesota | 27085 | 4461 | 61 |
1616568 | 1616568 | 2021-08-14 | McLeod | Minnesota | 27085 | 4461 | 61 |
1613320 | 1613320 | 2021-08-13 | McLeod | Minnesota | 27085 | 4461 | 61 |
1610071 | 1610071 | 2021-08-12 | McLeod | Minnesota | 27085 | 4446 | 61 |
1606823 | 1606823 | 2021-08-11 | McLeod | Minnesota | 27085 | 4445 | 61 |
1603574 | 1603574 | 2021-08-10 | McLeod | Minnesota | 27085 | 4431 | 61 |
1600325 | 1600325 | 2021-08-09 | McLeod | Minnesota | 27085 | 4413 | 61 |
1597077 | 1597077 | 2021-08-08 | McLeod | Minnesota | 27085 | 4400 | 61 |
1593828 | 1593828 | 2021-08-07 | McLeod | Minnesota | 27085 | 4400 | 61 |
1590579 | 1590579 | 2021-08-06 | McLeod | Minnesota | 27085 | 4400 | 61 |
1587330 | 1587330 | 2021-08-05 | McLeod | Minnesota | 27085 | 4393 | 61 |
1584079 | 1584079 | 2021-08-04 | McLeod | Minnesota | 27085 | 4387 | 61 |
1580830 | 1580830 | 2021-08-03 | McLeod | Minnesota | 27085 | 4380 | 61 |
1577581 | 1577581 | 2021-08-02 | McLeod | Minnesota | 27085 | 4370 | 61 |
1574333 | 1574333 | 2021-08-01 | McLeod | Minnesota | 27085 | 4366 | 61 |
1571085 | 1571085 | 2021-07-31 | McLeod | Minnesota | 27085 | 4366 | 61 |
1567837 | 1567837 | 2021-07-30 | McLeod | Minnesota | 27085 | 4366 | 61 |
1564589 | 1564589 | 2021-07-29 | McLeod | Minnesota | 27085 | 4358 | 61 |
1561341 | 1561341 | 2021-07-28 | McLeod | Minnesota | 27085 | 4354 | 61 |
1558093 | 1558093 | 2021-07-27 | McLeod | Minnesota | 27085 | 4351 | 61 |
1554846 | 1554846 | 2021-07-26 | McLeod | Minnesota | 27085 | 4343 | 61 |
1551599 | 1551599 | 2021-07-25 | McLeod | Minnesota | 27085 | 4342 | 61 |
1548352 | 1548352 | 2021-07-24 | McLeod | Minnesota | 27085 | 4342 | 61 |
1545105 | 1545105 | 2021-07-23 | McLeod | Minnesota | 27085 | 4342 | 61 |
1541857 | 1541857 | 2021-07-22 | McLeod | Minnesota | 27085 | 4338 | 61 |
1538610 | 1538610 | 2021-07-21 | McLeod | Minnesota | 27085 | 4336 | 61 |
1535363 | 1535363 | 2021-07-20 | McLeod | Minnesota | 27085 | 4336 | 61 |
1532115 | 1532115 | 2021-07-19 | McLeod | Minnesota | 27085 | 4332 | 61 |
1528868 | 1528868 | 2021-07-18 | McLeod | Minnesota | 27085 | 4331 | 61 |
1525621 | 1525621 | 2021-07-17 | McLeod | Minnesota | 27085 | 4331 | 61 |
1522374 | 1522374 | 2021-07-16 | McLeod | Minnesota | 27085 | 4331 | 61 |
1519125 | 1519125 | 2021-07-15 | McLeod | Minnesota | 27085 | 4331 | 61 |
1515878 | 1515878 | 2021-07-14 | McLeod | Minnesota | 27085 | 4331 | 61 |
1512632 | 1512632 | 2021-07-13 | McLeod | Minnesota | 27085 | 4329 | 61 |
1509385 | 1509385 | 2021-07-12 | McLeod | Minnesota | 27085 | 4327 | 61 |
1506139 | 1506139 | 2021-07-11 | McLeod | Minnesota | 27085 | 4327 | 61 |
1502893 | 1502893 | 2021-07-10 | McLeod | Minnesota | 27085 | 4327 | 61 |
1499647 | 1499647 | 2021-07-09 | McLeod | Minnesota | 27085 | 4327 | 61 |
1496401 | 1496401 | 2021-07-08 | McLeod | Minnesota | 27085 | 4327 | 61 |
1493154 | 1493154 | 2021-07-07 | McLeod | Minnesota | 27085 | 4325 | 61 |
1489907 | 1489907 | 2021-07-06 | McLeod | Minnesota | 27085 | 4325 | 61 |
1486660 | 1486660 | 2021-07-05 | McLeod | Minnesota | 27085 | 4324 | 61 |
1483414 | 1483414 | 2021-07-04 | McLeod | Minnesota | 27085 | 4324 | 61 |
1480168 | 1480168 | 2021-07-03 | McLeod | Minnesota | 27085 | 4324 | 61 |
1476921 | 1476921 | 2021-07-02 | McLeod | Minnesota | 27085 | 4324 | 61 |
1473675 | 1473675 | 2021-07-01 | McLeod | Minnesota | 27085 | 4323 | 61 |
1470429 | 1470429 | 2021-06-30 | McLeod | Minnesota | 27085 | 4323 | 61 |
1467184 | 1467184 | 2021-06-29 | McLeod | Minnesota | 27085 | 4322 | 61 |
1463939 | 1463939 | 2021-06-28 | McLeod | Minnesota | 27085 | 4322 | 61 |
1460694 | 1460694 | 2021-06-27 | McLeod | Minnesota | 27085 | 4320 | 61 |
1457449 | 1457449 | 2021-06-26 | McLeod | Minnesota | 27085 | 4316 | 61 |
1454204 | 1454204 | 2021-06-25 | McLeod | Minnesota | 27085 | 4315 | 61 |
1450959 | 1450959 | 2021-06-24 | McLeod | Minnesota | 27085 | 4314 | 61 |
1447713 | 1447713 | 2021-06-23 | McLeod | Minnesota | 27085 | 4312 | 61 |
1444468 | 1444468 | 2021-06-22 | McLeod | Minnesota | 27085 | 4309 | 61 |
1441223 | 1441223 | 2021-06-21 | McLeod | Minnesota | 27085 | 4308 | 61 |
1437977 | 1437977 | 2021-06-20 | McLeod | Minnesota | 27085 | 4306 | 61 |
1434730 | 1434730 | 2021-06-19 | McLeod | Minnesota | 27085 | 4305 | 61 |
1431483 | 1431483 | 2021-06-18 | McLeod | Minnesota | 27085 | 4304 | 61 |
1428238 | 1428238 | 2021-06-17 | McLeod | Minnesota | 27085 | 4303 | 61 |
1424993 | 1424993 | 2021-06-16 | McLeod | Minnesota | 27085 | 4301 | 61 |
1421745 | 1421745 | 2021-06-15 | McLeod | Minnesota | 27085 | 4298 | 61 |
1418500 | 1418500 | 2021-06-14 | McLeod | Minnesota | 27085 | 4297 | 61 |
1415255 | 1415255 | 2021-06-13 | McLeod | Minnesota | 27085 | 4291 | 61 |
1412009 | 1412009 | 2021-06-12 | McLeod | Minnesota | 27085 | 4289 | 61 |
1408764 | 1408764 | 2021-06-11 | McLeod | Minnesota | 27085 | 4289 | 61 |
1405519 | 1405519 | 2021-06-10 | McLeod | Minnesota | 27085 | 4289 | 61 |
1402273 | 1402273 | 2021-06-09 | McLeod | Minnesota | 27085 | 4285 | 61 |
1399028 | 1399028 | 2021-06-08 | McLeod | Minnesota | 27085 | 4285 | 61 |
1395782 | 1395782 | 2021-06-07 | McLeod | Minnesota | 27085 | 4283 | 61 |
1392536 | 1392536 | 2021-06-06 | McLeod | Minnesota | 27085 | 4282 | 61 |
1389291 | 1389291 | 2021-06-05 | McLeod | Minnesota | 27085 | 4282 | 61 |
1386046 | 1386046 | 2021-06-04 | McLeod | Minnesota | 27085 | 4282 | 61 |
1382801 | 1382801 | 2021-06-03 | McLeod | Minnesota | 27085 | 4282 | 61 |
1379555 | 1379555 | 2021-06-02 | McLeod | Minnesota | 27085 | 4281 | 61 |
1376310 | 1376310 | 2021-06-01 | McLeod | Minnesota | 27085 | 4281 | 61 |
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);