ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 260 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Minnesota · 43 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2494457 | 2494457 | 2022-05-11 | Scott | Minnesota | 27139 | 41100 | 260 |
2491199 | 2491199 | 2022-05-10 | Scott | Minnesota | 27139 | 41053 | 260 |
2487942 | 2487942 | 2022-05-09 | Scott | Minnesota | 27139 | 40932 | 260 |
2484684 | 2484684 | 2022-05-08 | Scott | Minnesota | 27139 | 40862 | 260 |
2481426 | 2481426 | 2022-05-07 | Scott | Minnesota | 27139 | 40862 | 260 |
2478168 | 2478168 | 2022-05-06 | Scott | Minnesota | 27139 | 40862 | 260 |
2474910 | 2474910 | 2022-05-05 | Scott | Minnesota | 27139 | 40815 | 260 |
2471653 | 2471653 | 2022-05-04 | Scott | Minnesota | 27139 | 40766 | 260 |
2468397 | 2468397 | 2022-05-03 | Scott | Minnesota | 27139 | 40684 | 260 |
2465142 | 2465142 | 2022-05-02 | Scott | Minnesota | 27139 | 40610 | 260 |
2461886 | 2461886 | 2022-05-01 | Scott | Minnesota | 27139 | 40566 | 260 |
2458630 | 2458630 | 2022-04-30 | Scott | Minnesota | 27139 | 40566 | 260 |
2455374 | 2455374 | 2022-04-29 | Scott | Minnesota | 27139 | 40566 | 260 |
2452118 | 2452118 | 2022-04-28 | Scott | Minnesota | 27139 | 40505 | 260 |
2448862 | 2448862 | 2022-04-27 | Scott | Minnesota | 27139 | 40467 | 260 |
2445606 | 2445606 | 2022-04-26 | Scott | Minnesota | 27139 | 40427 | 260 |
2445616 | 2445616 | 2022-04-26 | Unknown | Minnesota | 1054 | 260 | |
2442350 | 2442350 | 2022-04-25 | Scott | Minnesota | 27139 | 40364 | 260 |
2442360 | 2442360 | 2022-04-25 | Unknown | Minnesota | 1053 | 260 | |
2439094 | 2439094 | 2022-04-24 | Scott | Minnesota | 27139 | 40353 | 260 |
2439104 | 2439104 | 2022-04-24 | Unknown | Minnesota | 1051 | 260 | |
2435838 | 2435838 | 2022-04-23 | Scott | Minnesota | 27139 | 40353 | 260 |
2435848 | 2435848 | 2022-04-23 | Unknown | Minnesota | 1051 | 260 | |
2432582 | 2432582 | 2022-04-22 | Scott | Minnesota | 27139 | 40353 | 260 |
2432592 | 2432592 | 2022-04-22 | Unknown | Minnesota | 1051 | 260 | |
2429326 | 2429326 | 2022-04-21 | Scott | Minnesota | 27139 | 40323 | 260 |
2429336 | 2429336 | 2022-04-21 | Unknown | Minnesota | 1049 | 260 | |
2426070 | 2426070 | 2022-04-20 | Scott | Minnesota | 27139 | 40306 | 260 |
2426080 | 2426080 | 2022-04-20 | Unknown | Minnesota | 1048 | 260 | |
2422814 | 2422814 | 2022-04-19 | Scott | Minnesota | 27139 | 40286 | 260 |
2419558 | 2419558 | 2022-04-18 | Scott | Minnesota | 27139 | 40251 | 260 |
2416302 | 2416302 | 2022-04-17 | Scott | Minnesota | 27139 | 40234 | 260 |
2413046 | 2413046 | 2022-04-16 | Scott | Minnesota | 27139 | 40234 | 260 |
2409790 | 2409790 | 2022-04-15 | Scott | Minnesota | 27139 | 40234 | 260 |
2081280 | 2081280 | 2022-01-04 | Wright | Minnesota | 27171 | 29037 | 260 |
2078028 | 2078028 | 2022-01-03 | Wright | Minnesota | 27171 | 28816 | 260 |
1895996 | 1895996 | 2021-11-08 | Stearns | Minnesota | 27145 | 30255 | 260 |
1892746 | 1892746 | 2021-11-07 | Stearns | Minnesota | 27145 | 30110 | 260 |
1889496 | 1889496 | 2021-11-06 | Stearns | Minnesota | 27145 | 30110 | 260 |
1886246 | 1886246 | 2021-11-05 | Stearns | Minnesota | 27145 | 30110 | 260 |
1022446 | 1022446 | 2021-02-12 | St. Louis | Minnesota | 27137 | 14463 | 260 |
1019201 | 1019201 | 2021-02-11 | St. Louis | Minnesota | 27137 | 14429 | 260 |
390537 | 390537 | 2020-08-01 | Ramsey | Minnesota | 27123 | 6763 | 260 |
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);