ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23 rows where cases = 2, fips = 27011 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 |
---|---|---|---|---|---|---|---|
152483 | 152483 | 2020-05-17 | Big Stone | Minnesota | 27011 | 2 | 0 |
149472 | 149472 | 2020-05-16 | Big Stone | Minnesota | 27011 | 2 | 0 |
146467 | 146467 | 2020-05-15 | Big Stone | Minnesota | 27011 | 2 | 0 |
143467 | 143467 | 2020-05-14 | Big Stone | Minnesota | 27011 | 2 | 0 |
140472 | 140472 | 2020-05-13 | Big Stone | Minnesota | 27011 | 2 | 0 |
137478 | 137478 | 2020-05-12 | Big Stone | Minnesota | 27011 | 2 | 0 |
134488 | 134488 | 2020-05-11 | Big Stone | Minnesota | 27011 | 2 | 0 |
131497 | 131497 | 2020-05-10 | Big Stone | Minnesota | 27011 | 2 | 0 |
128507 | 128507 | 2020-05-09 | Big Stone | Minnesota | 27011 | 2 | 0 |
125520 | 125520 | 2020-05-08 | Big Stone | Minnesota | 27011 | 2 | 0 |
122538 | 122538 | 2020-05-07 | Big Stone | Minnesota | 27011 | 2 | 0 |
119565 | 119565 | 2020-05-06 | Big Stone | Minnesota | 27011 | 2 | 0 |
116605 | 116605 | 2020-05-05 | Big Stone | Minnesota | 27011 | 2 | 0 |
113724 | 113724 | 2020-05-04 | Big Stone | Minnesota | 27011 | 2 | 0 |
110845 | 110845 | 2020-05-03 | Big Stone | Minnesota | 27011 | 2 | 0 |
107974 | 107974 | 2020-05-02 | Big Stone | Minnesota | 27011 | 2 | 0 |
105110 | 105110 | 2020-05-01 | Big Stone | Minnesota | 27011 | 2 | 0 |
102250 | 102250 | 2020-04-30 | Big Stone | Minnesota | 27011 | 2 | 0 |
99398 | 99398 | 2020-04-29 | Big Stone | Minnesota | 27011 | 2 | 0 |
96552 | 96552 | 2020-04-28 | Big Stone | Minnesota | 27011 | 2 | 0 |
93717 | 93717 | 2020-04-27 | Big Stone | Minnesota | 27011 | 2 | 0 |
90896 | 90896 | 2020-04-26 | Big Stone | Minnesota | 27011 | 2 | 0 |
88080 | 88080 | 2020-04-25 | Big Stone | Minnesota | 27011 | 2 | 0 |
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);