ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
64 rows where deaths = 123 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 |
---|---|---|---|---|---|---|---|
2416247 | 2416247 | 2022-04-17 | Clay | Minnesota | 27027 | 19794 | 123 |
2412991 | 2412991 | 2022-04-16 | Clay | Minnesota | 27027 | 19794 | 123 |
2409735 | 2409735 | 2022-04-15 | Clay | Minnesota | 27027 | 19794 | 123 |
2406479 | 2406479 | 2022-04-14 | Clay | Minnesota | 27027 | 19786 | 123 |
2403223 | 2403223 | 2022-04-13 | Clay | Minnesota | 27027 | 19782 | 123 |
2399969 | 2399969 | 2022-04-12 | Clay | Minnesota | 27027 | 19776 | 123 |
2396713 | 2396713 | 2022-04-11 | Clay | Minnesota | 27027 | 19773 | 123 |
2393458 | 2393458 | 2022-04-10 | Clay | Minnesota | 27027 | 19764 | 123 |
2390202 | 2390202 | 2022-04-09 | Clay | Minnesota | 27027 | 19764 | 123 |
2386946 | 2386946 | 2022-04-08 | Clay | Minnesota | 27027 | 19764 | 123 |
2383691 | 2383691 | 2022-04-07 | Clay | Minnesota | 27027 | 19759 | 123 |
2380436 | 2380436 | 2022-04-06 | Clay | Minnesota | 27027 | 19752 | 123 |
2377181 | 2377181 | 2022-04-05 | Clay | Minnesota | 27027 | 19749 | 123 |
2373929 | 2373929 | 2022-04-04 | Clay | Minnesota | 27027 | 19745 | 123 |
2370676 | 2370676 | 2022-04-03 | Clay | Minnesota | 27027 | 19743 | 123 |
2367423 | 2367423 | 2022-04-02 | Clay | Minnesota | 27027 | 19743 | 123 |
2364170 | 2364170 | 2022-04-01 | Clay | Minnesota | 27027 | 19743 | 123 |
2360916 | 2360916 | 2022-03-31 | Clay | Minnesota | 27027 | 19739 | 123 |
2256845 | 2256845 | 2022-02-27 | Goodhue | Minnesota | 27049 | 12776 | 123 |
2253594 | 2253594 | 2022-02-26 | Goodhue | Minnesota | 27049 | 12776 | 123 |
2250343 | 2250343 | 2022-02-25 | Goodhue | Minnesota | 27049 | 12776 | 123 |
2130000 | 2130000 | 2022-01-19 | Itasca | Minnesota | 27061 | 9204 | 123 |
2126746 | 2126746 | 2022-01-18 | Itasca | Minnesota | 27061 | 9053 | 123 |
2123494 | 2123494 | 2022-01-17 | Itasca | Minnesota | 27061 | 8995 | 123 |
2120242 | 2120242 | 2022-01-16 | Itasca | Minnesota | 27061 | 8995 | 123 |
2116990 | 2116990 | 2022-01-15 | Itasca | Minnesota | 27061 | 8995 | 123 |
2113739 | 2113739 | 2022-01-14 | Itasca | Minnesota | 27061 | 8995 | 123 |
2110490 | 2110490 | 2022-01-13 | Kandiyohi | Minnesota | 27067 | 10990 | 123 |
2107239 | 2107239 | 2022-01-12 | Kandiyohi | Minnesota | 27067 | 10939 | 123 |
2103988 | 2103988 | 2022-01-11 | Kandiyohi | Minnesota | 27067 | 10899 | 123 |
1970698 | 1970698 | 2021-12-01 | Crow Wing | Minnesota | 27035 | 11213 | 123 |
1951179 | 1951179 | 2021-11-25 | Benton | Minnesota | 27009 | 8767 | 123 |
1947928 | 1947928 | 2021-11-24 | Benton | Minnesota | 27009 | 8767 | 123 |
1944728 | 1944728 | 2021-11-23 | Otter Tail | Minnesota | 27111 | 9537 | 123 |
1944742 | 1944742 | 2021-11-23 | Sherburne | Minnesota | 27141 | 18333 | 123 |
1941477 | 1941477 | 2021-11-22 | Otter Tail | Minnesota | 27111 | 9439 | 123 |
1921976 | 1921976 | 2021-11-16 | Olmsted | Minnesota | 27109 | 20591 | 123 |
1918726 | 1918726 | 2021-11-15 | Olmsted | Minnesota | 27109 | 20266 | 123 |
1915476 | 1915476 | 2021-11-14 | Olmsted | Minnesota | 27109 | 20113 | 123 |
1912226 | 1912226 | 2021-11-13 | Olmsted | Minnesota | 27109 | 20113 | 123 |
1908976 | 1908976 | 2021-11-12 | Olmsted | Minnesota | 27109 | 20113 | 123 |
1905727 | 1905727 | 2021-11-11 | Olmsted | Minnesota | 27109 | 19981 | 123 |
1902478 | 1902478 | 2021-11-10 | Olmsted | Minnesota | 27109 | 19815 | 123 |
1899228 | 1899228 | 2021-11-09 | Olmsted | Minnesota | 27109 | 19682 | 123 |
1895978 | 1895978 | 2021-11-08 | Olmsted | Minnesota | 27109 | 19492 | 123 |
1892728 | 1892728 | 2021-11-07 | Olmsted | Minnesota | 27109 | 19396 | 123 |
1889478 | 1889478 | 2021-11-06 | Olmsted | Minnesota | 27109 | 19396 | 123 |
1886228 | 1886228 | 2021-11-05 | Olmsted | Minnesota | 27109 | 19396 | 123 |
1285431 | 1285431 | 2021-05-04 | Scott | Minnesota | 27139 | 16941 | 123 |
1282185 | 1282185 | 2021-05-03 | Scott | Minnesota | 27139 | 16902 | 123 |
1278938 | 1278938 | 2021-05-02 | Scott | Minnesota | 27139 | 16874 | 123 |
1275691 | 1275691 | 2021-05-01 | Scott | Minnesota | 27139 | 16811 | 123 |
1272444 | 1272444 | 2021-04-30 | Scott | Minnesota | 27139 | 16751 | 123 |
1197770 | 1197770 | 2021-04-07 | Wright | Minnesota | 27171 | 14053 | 123 |
1194521 | 1194521 | 2021-04-06 | Wright | Minnesota | 27171 | 13974 | 123 |
1191272 | 1191272 | 2021-04-05 | Wright | Minnesota | 27171 | 13886 | 123 |
1188024 | 1188024 | 2021-04-04 | Wright | Minnesota | 27171 | 13826 | 123 |
1184777 | 1184777 | 2021-04-03 | Wright | Minnesota | 27171 | 13826 | 123 |
1181531 | 1181531 | 2021-04-02 | Wright | Minnesota | 27171 | 13748 | 123 |
1178284 | 1178284 | 2021-04-01 | Wright | Minnesota | 27171 | 13637 | 123 |
539001 | 539001 | 2020-09-16 | Dakota | Minnesota | 27037 | 6895 | 123 |
503400 | 503400 | 2020-09-05 | Anoka | Minnesota | 27003 | 4979 | 123 |
500166 | 500166 | 2020-09-04 | Anoka | Minnesota | 27003 | 4923 | 123 |
82485 | 82485 | 2020-04-23 | Hennepin | Minnesota | 27053 | 1132 | 123 |
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);