ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
18 rows where deaths = 9, fips = 27091 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
555215 | 555215 | 2020-09-21 | Martin | Minnesota | 27091 | 329 | 9 |
551977 | 551977 | 2020-09-20 | Martin | Minnesota | 27091 | 319 | 9 |
548738 | 548738 | 2020-09-19 | Martin | Minnesota | 27091 | 304 | 9 |
545500 | 545500 | 2020-09-18 | Martin | Minnesota | 27091 | 290 | 9 |
542263 | 542263 | 2020-09-17 | Martin | Minnesota | 27091 | 280 | 9 |
539027 | 539027 | 2020-09-16 | Martin | Minnesota | 27091 | 273 | 9 |
535790 | 535790 | 2020-09-15 | Martin | Minnesota | 27091 | 269 | 9 |
532555 | 532555 | 2020-09-14 | Martin | Minnesota | 27091 | 268 | 9 |
529319 | 529319 | 2020-09-13 | Martin | Minnesota | 27091 | 264 | 9 |
526083 | 526083 | 2020-09-12 | Martin | Minnesota | 27091 | 259 | 9 |
522847 | 522847 | 2020-09-11 | Martin | Minnesota | 27091 | 254 | 9 |
519610 | 519610 | 2020-09-10 | Martin | Minnesota | 27091 | 253 | 9 |
516375 | 516375 | 2020-09-09 | Martin | Minnesota | 27091 | 252 | 9 |
513141 | 513141 | 2020-09-08 | Martin | Minnesota | 27091 | 250 | 9 |
509909 | 509909 | 2020-09-07 | Martin | Minnesota | 27091 | 248 | 9 |
506676 | 506676 | 2020-09-06 | Martin | Minnesota | 27091 | 248 | 9 |
503443 | 503443 | 2020-09-05 | Martin | Minnesota | 27091 | 248 | 9 |
500209 | 500209 | 2020-09-04 | Martin | Minnesota | 27091 | 248 | 9 |
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);