ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
42 rows where deaths = 4, 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 |
---|---|---|---|---|---|---|---|
146503 | 146503 | 2020-05-15 | Martin | Minnesota | 27091 | 114 | 4 |
143503 | 143503 | 2020-05-14 | Martin | Minnesota | 27091 | 113 | 4 |
140508 | 140508 | 2020-05-13 | Martin | Minnesota | 27091 | 112 | 4 |
137514 | 137514 | 2020-05-12 | Martin | Minnesota | 27091 | 112 | 4 |
134524 | 134524 | 2020-05-11 | Martin | Minnesota | 27091 | 112 | 4 |
131533 | 131533 | 2020-05-10 | Martin | Minnesota | 27091 | 112 | 4 |
128543 | 128543 | 2020-05-09 | Martin | Minnesota | 27091 | 112 | 4 |
125556 | 125556 | 2020-05-08 | Martin | Minnesota | 27091 | 111 | 4 |
122574 | 122574 | 2020-05-07 | Martin | Minnesota | 27091 | 111 | 4 |
119600 | 119600 | 2020-05-06 | Martin | Minnesota | 27091 | 111 | 4 |
116640 | 116640 | 2020-05-05 | Martin | Minnesota | 27091 | 111 | 4 |
113759 | 113759 | 2020-05-04 | Martin | Minnesota | 27091 | 111 | 4 |
110880 | 110880 | 2020-05-03 | Martin | Minnesota | 27091 | 111 | 4 |
108009 | 108009 | 2020-05-02 | Martin | Minnesota | 27091 | 111 | 4 |
105144 | 105144 | 2020-05-01 | Martin | Minnesota | 27091 | 111 | 4 |
102283 | 102283 | 2020-04-30 | Martin | Minnesota | 27091 | 88 | 4 |
99431 | 99431 | 2020-04-29 | Martin | Minnesota | 27091 | 70 | 4 |
96585 | 96585 | 2020-04-28 | Martin | Minnesota | 27091 | 52 | 4 |
93750 | 93750 | 2020-04-27 | Martin | Minnesota | 27091 | 43 | 4 |
90929 | 90929 | 2020-04-26 | Martin | Minnesota | 27091 | 43 | 4 |
88113 | 88113 | 2020-04-25 | Martin | Minnesota | 27091 | 42 | 4 |
85303 | 85303 | 2020-04-24 | Martin | Minnesota | 27091 | 41 | 4 |
82499 | 82499 | 2020-04-23 | Martin | Minnesota | 27091 | 41 | 4 |
79703 | 79703 | 2020-04-22 | Martin | Minnesota | 27091 | 41 | 4 |
76918 | 76918 | 2020-04-21 | Martin | Minnesota | 27091 | 41 | 4 |
74138 | 74138 | 2020-04-20 | Martin | Minnesota | 27091 | 41 | 4 |
71365 | 71365 | 2020-04-19 | Martin | Minnesota | 27091 | 39 | 4 |
68600 | 68600 | 2020-04-18 | Martin | Minnesota | 27091 | 39 | 4 |
65848 | 65848 | 2020-04-17 | Martin | Minnesota | 27091 | 39 | 4 |
63109 | 63109 | 2020-04-16 | Martin | Minnesota | 27091 | 39 | 4 |
60387 | 60387 | 2020-04-15 | Martin | Minnesota | 27091 | 39 | 4 |
57677 | 57677 | 2020-04-14 | Martin | Minnesota | 27091 | 39 | 4 |
54979 | 54979 | 2020-04-13 | Martin | Minnesota | 27091 | 38 | 4 |
52297 | 52297 | 2020-04-12 | Martin | Minnesota | 27091 | 38 | 4 |
49627 | 49627 | 2020-04-11 | Martin | Minnesota | 27091 | 37 | 4 |
46982 | 46982 | 2020-04-10 | Martin | Minnesota | 27091 | 36 | 4 |
44373 | 44373 | 2020-04-09 | Martin | Minnesota | 27091 | 35 | 4 |
41797 | 41797 | 2020-04-08 | Martin | Minnesota | 27091 | 34 | 4 |
39244 | 39244 | 2020-04-07 | Martin | Minnesota | 27091 | 34 | 4 |
36735 | 36735 | 2020-04-06 | Martin | Minnesota | 27091 | 33 | 4 |
34275 | 34275 | 2020-04-05 | Martin | Minnesota | 27091 | 32 | 4 |
31849 | 31849 | 2020-04-04 | Martin | Minnesota | 27091 | 32 | 4 |
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);