ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
39 rows where cases = 1070 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
state 1
- Minnesota · 39 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1496406 | 1496406 | 2021-07-08 | Murray | Minnesota | 27101 | 1070 | 10 |
1493159 | 1493159 | 2021-07-07 | Murray | Minnesota | 27101 | 1070 | 10 |
1489912 | 1489912 | 2021-07-06 | Murray | Minnesota | 27101 | 1070 | 10 |
1486665 | 1486665 | 2021-07-05 | Murray | Minnesota | 27101 | 1070 | 10 |
1483419 | 1483419 | 2021-07-04 | Murray | Minnesota | 27101 | 1070 | 10 |
1480173 | 1480173 | 2021-07-03 | Murray | Minnesota | 27101 | 1070 | 10 |
1476926 | 1476926 | 2021-07-02 | Murray | Minnesota | 27101 | 1070 | 10 |
1470459 | 1470459 | 2021-06-30 | Swift | Minnesota | 27151 | 1070 | 18 |
1467214 | 1467214 | 2021-06-29 | Swift | Minnesota | 27151 | 1070 | 18 |
1463969 | 1463969 | 2021-06-28 | Swift | Minnesota | 27151 | 1070 | 18 |
1460724 | 1460724 | 2021-06-27 | Swift | Minnesota | 27151 | 1070 | 18 |
1457479 | 1457479 | 2021-06-26 | Swift | Minnesota | 27151 | 1070 | 18 |
1431488 | 1431488 | 2021-06-18 | Murray | Minnesota | 27101 | 1070 | 10 |
1428243 | 1428243 | 2021-06-17 | Murray | Minnesota | 27101 | 1070 | 10 |
1424998 | 1424998 | 2021-06-16 | Murray | Minnesota | 27101 | 1070 | 10 |
1421750 | 1421750 | 2021-06-15 | Murray | Minnesota | 27101 | 1070 | 10 |
1418505 | 1418505 | 2021-06-14 | Murray | Minnesota | 27101 | 1070 | 10 |
1415260 | 1415260 | 2021-06-13 | Murray | Minnesota | 27101 | 1070 | 10 |
1412014 | 1412014 | 2021-06-12 | Murray | Minnesota | 27101 | 1070 | 10 |
1408769 | 1408769 | 2021-06-11 | Murray | Minnesota | 27101 | 1070 | 10 |
1405524 | 1405524 | 2021-06-10 | Murray | Minnesota | 27101 | 1070 | 10 |
1402278 | 1402278 | 2021-06-09 | Murray | Minnesota | 27101 | 1070 | 10 |
1399033 | 1399033 | 2021-06-08 | Murray | Minnesota | 27101 | 1070 | 9 |
1395787 | 1395787 | 2021-06-07 | Murray | Minnesota | 27101 | 1070 | 9 |
1392541 | 1392541 | 2021-06-06 | Murray | Minnesota | 27101 | 1070 | 9 |
1389296 | 1389296 | 2021-06-05 | Murray | Minnesota | 27101 | 1070 | 9 |
1386051 | 1386051 | 2021-06-04 | Murray | Minnesota | 27101 | 1070 | 9 |
1382806 | 1382806 | 2021-06-03 | Murray | Minnesota | 27101 | 1070 | 9 |
1379560 | 1379560 | 2021-06-02 | Murray | Minnesota | 27101 | 1070 | 9 |
1376315 | 1376315 | 2021-06-01 | Murray | Minnesota | 27101 | 1070 | 9 |
1373069 | 1373069 | 2021-05-31 | Murray | Minnesota | 27101 | 1070 | 9 |
1369824 | 1369824 | 2021-05-30 | Murray | Minnesota | 27101 | 1070 | 9 |
1366578 | 1366578 | 2021-05-29 | Murray | Minnesota | 27101 | 1070 | 9 |
1363332 | 1363332 | 2021-05-28 | Murray | Minnesota | 27101 | 1070 | 9 |
1187969 | 1187969 | 2021-04-04 | Jackson | Minnesota | 27063 | 1070 | 10 |
1184722 | 1184722 | 2021-04-03 | Jackson | Minnesota | 27063 | 1070 | 10 |
1064601 | 1064601 | 2021-02-25 | Kanabec | Minnesota | 27065 | 1070 | 19 |
967281 | 967281 | 2021-01-26 | Watonwan | Minnesota | 27165 | 1070 | 8 |
694667 | 694667 | 2020-11-03 | Polk | Minnesota | 27119 | 1070 | 6 |
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);