ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
38 rows where cases = 136 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1158727 | 1158727 | 2021-03-26 | Cook | Minnesota | 27031 | 136 | 0 |
824440 | 824440 | 2020-12-13 | Lake of the Woods | Minnesota | 27077 | 136 | 1 |
769311 | 769311 | 2020-11-26 | Traverse | Minnesota | 27155 | 136 | 0 |
766065 | 766065 | 2020-11-25 | Traverse | Minnesota | 27155 | 136 | 0 |
730346 | 730346 | 2020-11-14 | Red Lake | Minnesota | 27125 | 136 | 3 |
662179 | 662179 | 2020-10-24 | Big Stone | Minnesota | 27011 | 136 | 0 |
636271 | 636271 | 2020-10-16 | Pope | Minnesota | 27121 | 136 | 0 |
610306 | 610306 | 2020-10-08 | Lincoln | Minnesota | 27081 | 136 | 0 |
603837 | 603837 | 2020-10-06 | Pennington | Minnesota | 27113 | 136 | 1 |
600595 | 600595 | 2020-10-05 | Pennington | Minnesota | 27113 | 136 | 1 |
597352 | 597352 | 2020-10-04 | Pennington | Minnesota | 27113 | 136 | 1 |
587600 | 587600 | 2020-10-01 | Houston | Minnesota | 27055 | 136 | 0 |
587605 | 587605 | 2020-10-01 | Kanabec | Minnesota | 27065 | 136 | 8 |
564906 | 564906 | 2020-09-24 | Faribault | Minnesota | 27043 | 136 | 0 |
561709 | 561709 | 2020-09-23 | Renville | Minnesota | 27129 | 136 | 7 |
558439 | 558439 | 2020-09-22 | Jackson | Minnesota | 27063 | 136 | 1 |
558472 | 558472 | 2020-09-22 | Renville | Minnesota | 27129 | 136 | 7 |
555235 | 555235 | 2020-09-21 | Renville | Minnesota | 27129 | 136 | 7 |
545503 | 545503 | 2020-09-18 | Mille Lacs | Minnesota | 27095 | 136 | 3 |
500172 | 500172 | 2020-09-04 | Brown | Minnesota | 27015 | 136 | 2 |
490475 | 490475 | 2020-09-01 | Chippewa | Minnesota | 27023 | 136 | 1 |
461425 | 461425 | 2020-08-23 | Murray | Minnesota | 27101 | 136 | 1 |
454977 | 454977 | 2020-08-21 | Pine | Minnesota | 27115 | 136 | 0 |
435579 | 435579 | 2020-08-15 | Dodge | Minnesota | 27039 | 136 | 0 |
432353 | 432353 | 2020-08-14 | Dodge | Minnesota | 27039 | 136 | 0 |
409808 | 409808 | 2020-08-07 | Itasca | Minnesota | 27061 | 136 | 12 |
406578 | 406578 | 2020-08-06 | Douglas | Minnesota | 27041 | 136 | 0 |
403360 | 403360 | 2020-08-05 | Douglas | Minnesota | 27041 | 136 | 0 |
377665 | 377665 | 2020-07-28 | Pipestone | Minnesota | 27117 | 136 | 8 |
374450 | 374450 | 2020-07-27 | Pipestone | Minnesota | 27117 | 136 | 8 |
355165 | 355165 | 2020-07-21 | Crow Wing | Minnesota | 27035 | 136 | 12 |
329611 | 329611 | 2020-07-13 | Le Sueur | Minnesota | 27079 | 136 | 1 |
320109 | 320109 | 2020-07-10 | Winona | Minnesota | 27169 | 136 | 15 |
310522 | 310522 | 2020-07-07 | Cottonwood | Minnesota | 27033 | 136 | 0 |
307354 | 307354 | 2020-07-06 | Cottonwood | Minnesota | 27033 | 136 | 0 |
304187 | 304187 | 2020-07-05 | Cottonwood | Minnesota | 27033 | 136 | 0 |
285281 | 285281 | 2020-06-29 | Nicollet | Minnesota | 27103 | 136 | 12 |
85282 | 85282 | 2020-04-24 | Dakota | Minnesota | 27037 | 136 | 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);