ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
20 rows where cases = 279 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
778994 | 778994 | 2020-11-29 | Grant | Minnesota | 27051 | 279 | 6 |
746549 | 746549 | 2020-11-19 | Lac qui Parle | Minnesota | 27073 | 279 | 3 |
704369 | 704369 | 2020-11-06 | Kanabec | Minnesota | 27065 | 279 | 10 |
684947 | 684947 | 2020-10-31 | Sibley | Minnesota | 27143 | 279 | 3 |
633011 | 633011 | 2020-10-15 | Meeker | Minnesota | 27093 | 279 | 3 |
629766 | 629766 | 2020-10-14 | Meeker | Minnesota | 27093 | 279 | 3 |
626555 | 626555 | 2020-10-13 | Wabasha | Minnesota | 27157 | 279 | 0 |
581100 | 581100 | 2020-09-29 | Carlton | Minnesota | 27017 | 279 | 1 |
564914 | 564914 | 2020-09-24 | Isanti | Minnesota | 27059 | 279 | 0 |
454937 | 454937 | 2020-08-21 | Crow Wing | Minnesota | 27035 | 279 | 15 |
451709 | 451709 | 2020-08-20 | Crow Wing | Minnesota | 27035 | 279 | 15 |
448509 | 448509 | 2020-08-19 | McLeod | Minnesota | 27085 | 279 | 1 |
445241 | 445241 | 2020-08-18 | Beltrami | Minnesota | 27007 | 279 | 1 |
445323 | 445323 | 2020-08-18 | Winona | Minnesota | 27169 | 279 | 17 |
442097 | 442097 | 2020-08-17 | Winona | Minnesota | 27169 | 279 | 17 |
438870 | 438870 | 2020-08-16 | Winona | Minnesota | 27169 | 279 | 17 |
352028 | 352028 | 2020-07-20 | Watonwan | Minnesota | 27165 | 279 | 0 |
348818 | 348818 | 2020-07-19 | Steele | Minnesota | 27147 | 279 | 1 |
269550 | 269550 | 2020-06-24 | Lyon | Minnesota | 27083 | 279 | 2 |
146475 | 146475 | 2020-05-15 | Clay | Minnesota | 27027 | 279 | 18 |
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);