ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
754 rows where county = "Chippewa" and state = "Minnesota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
74111 | 74111 | 2020-04-20 | Chippewa | Minnesota | 27023 | 1 | 0 |
76891 | 76891 | 2020-04-21 | Chippewa | Minnesota | 27023 | 1 | 0 |
79676 | 79676 | 2020-04-22 | Chippewa | Minnesota | 27023 | 1 | 0 |
82472 | 82472 | 2020-04-23 | Chippewa | Minnesota | 27023 | 1 | 0 |
85276 | 85276 | 2020-04-24 | Chippewa | Minnesota | 27023 | 1 | 0 |
88086 | 88086 | 2020-04-25 | Chippewa | Minnesota | 27023 | 2 | 0 |
90902 | 90902 | 2020-04-26 | Chippewa | Minnesota | 27023 | 2 | 0 |
93723 | 93723 | 2020-04-27 | Chippewa | Minnesota | 27023 | 2 | 0 |
96558 | 96558 | 2020-04-28 | Chippewa | Minnesota | 27023 | 2 | 0 |
99404 | 99404 | 2020-04-29 | Chippewa | Minnesota | 27023 | 2 | 0 |
102256 | 102256 | 2020-04-30 | Chippewa | Minnesota | 27023 | 2 | 0 |
105116 | 105116 | 2020-05-01 | Chippewa | Minnesota | 27023 | 2 | 0 |
107980 | 107980 | 2020-05-02 | Chippewa | Minnesota | 27023 | 2 | 0 |
110851 | 110851 | 2020-05-03 | Chippewa | Minnesota | 27023 | 3 | 0 |
113730 | 113730 | 2020-05-04 | Chippewa | Minnesota | 27023 | 3 | 0 |
116611 | 116611 | 2020-05-05 | Chippewa | Minnesota | 27023 | 3 | 0 |
119571 | 119571 | 2020-05-06 | Chippewa | Minnesota | 27023 | 4 | 0 |
122544 | 122544 | 2020-05-07 | Chippewa | Minnesota | 27023 | 5 | 0 |
125526 | 125526 | 2020-05-08 | Chippewa | Minnesota | 27023 | 5 | 0 |
128513 | 128513 | 2020-05-09 | Chippewa | Minnesota | 27023 | 5 | 0 |
131503 | 131503 | 2020-05-10 | Chippewa | Minnesota | 27023 | 6 | 0 |
134494 | 134494 | 2020-05-11 | Chippewa | Minnesota | 27023 | 14 | 0 |
137484 | 137484 | 2020-05-12 | Chippewa | Minnesota | 27023 | 21 | 0 |
140478 | 140478 | 2020-05-13 | Chippewa | Minnesota | 27023 | 21 | 0 |
143473 | 143473 | 2020-05-14 | Chippewa | Minnesota | 27023 | 27 | 0 |
146473 | 146473 | 2020-05-15 | Chippewa | Minnesota | 27023 | 27 | 0 |
149478 | 149478 | 2020-05-16 | Chippewa | Minnesota | 27023 | 28 | 0 |
152489 | 152489 | 2020-05-17 | Chippewa | Minnesota | 27023 | 30 | 0 |
155503 | 155503 | 2020-05-18 | Chippewa | Minnesota | 27023 | 32 | 0 |
158521 | 158521 | 2020-05-19 | Chippewa | Minnesota | 27023 | 34 | 0 |
161547 | 161547 | 2020-05-20 | Chippewa | Minnesota | 27023 | 36 | 0 |
164576 | 164576 | 2020-05-21 | Chippewa | Minnesota | 27023 | 37 | 0 |
167612 | 167612 | 2020-05-22 | Chippewa | Minnesota | 27023 | 39 | 0 |
170649 | 170649 | 2020-05-23 | Chippewa | Minnesota | 27023 | 39 | 0 |
173691 | 173691 | 2020-05-24 | Chippewa | Minnesota | 27023 | 40 | 0 |
176734 | 176734 | 2020-05-25 | Chippewa | Minnesota | 27023 | 42 | 0 |
179778 | 179778 | 2020-05-26 | Chippewa | Minnesota | 27023 | 42 | 1 |
182824 | 182824 | 2020-05-27 | Chippewa | Minnesota | 27023 | 44 | 1 |
185879 | 185879 | 2020-05-28 | Chippewa | Minnesota | 27023 | 44 | 1 |
188937 | 188937 | 2020-05-29 | Chippewa | Minnesota | 27023 | 49 | 1 |
192001 | 192001 | 2020-05-30 | Chippewa | Minnesota | 27023 | 49 | 1 |
195069 | 195069 | 2020-05-31 | Chippewa | Minnesota | 27023 | 51 | 1 |
198140 | 198140 | 2020-06-01 | Chippewa | Minnesota | 27023 | 51 | 1 |
201213 | 201213 | 2020-06-02 | Chippewa | Minnesota | 27023 | 51 | 1 |
204290 | 204290 | 2020-06-03 | Chippewa | Minnesota | 27023 | 51 | 1 |
207371 | 207371 | 2020-06-04 | Chippewa | Minnesota | 27023 | 52 | 1 |
210452 | 210452 | 2020-06-05 | Chippewa | Minnesota | 27023 | 52 | 1 |
213536 | 213536 | 2020-06-06 | Chippewa | Minnesota | 27023 | 52 | 1 |
216624 | 216624 | 2020-06-07 | Chippewa | Minnesota | 27023 | 52 | 1 |
219716 | 219716 | 2020-06-08 | Chippewa | Minnesota | 27023 | 52 | 1 |
222811 | 222811 | 2020-06-09 | Chippewa | Minnesota | 27023 | 53 | 1 |
225909 | 225909 | 2020-06-10 | Chippewa | Minnesota | 27023 | 54 | 1 |
229011 | 229011 | 2020-06-11 | Chippewa | Minnesota | 27023 | 54 | 1 |
232115 | 232115 | 2020-06-12 | Chippewa | Minnesota | 27023 | 55 | 1 |
235220 | 235220 | 2020-06-13 | Chippewa | Minnesota | 27023 | 55 | 1 |
238327 | 238327 | 2020-06-14 | Chippewa | Minnesota | 27023 | 56 | 1 |
241436 | 241436 | 2020-06-15 | Chippewa | Minnesota | 27023 | 56 | 1 |
244547 | 244547 | 2020-06-16 | Chippewa | Minnesota | 27023 | 57 | 1 |
247660 | 247660 | 2020-06-17 | Chippewa | Minnesota | 27023 | 58 | 1 |
250772 | 250772 | 2020-06-18 | Chippewa | Minnesota | 27023 | 62 | 1 |
253887 | 253887 | 2020-06-19 | Chippewa | Minnesota | 27023 | 64 | 1 |
257007 | 257007 | 2020-06-20 | Chippewa | Minnesota | 27023 | 66 | 1 |
260133 | 260133 | 2020-06-21 | Chippewa | Minnesota | 27023 | 66 | 1 |
263262 | 263262 | 2020-06-22 | Chippewa | Minnesota | 27023 | 67 | 1 |
266388 | 266388 | 2020-06-23 | Chippewa | Minnesota | 27023 | 68 | 1 |
269521 | 269521 | 2020-06-24 | Chippewa | Minnesota | 27023 | 69 | 1 |
272658 | 272658 | 2020-06-25 | Chippewa | Minnesota | 27023 | 69 | 1 |
275801 | 275801 | 2020-06-26 | Chippewa | Minnesota | 27023 | 70 | 1 |
278949 | 278949 | 2020-06-27 | Chippewa | Minnesota | 27023 | 74 | 1 |
282097 | 282097 | 2020-06-28 | Chippewa | Minnesota | 27023 | 74 | 1 |
285242 | 285242 | 2020-06-29 | Chippewa | Minnesota | 27023 | 74 | 1 |
288392 | 288392 | 2020-06-30 | Chippewa | Minnesota | 27023 | 75 | 1 |
291543 | 291543 | 2020-07-01 | Chippewa | Minnesota | 27023 | 76 | 1 |
294697 | 294697 | 2020-07-02 | Chippewa | Minnesota | 27023 | 76 | 1 |
297855 | 297855 | 2020-07-03 | Chippewa | Minnesota | 27023 | 78 | 1 |
301018 | 301018 | 2020-07-04 | Chippewa | Minnesota | 27023 | 78 | 1 |
304182 | 304182 | 2020-07-05 | Chippewa | Minnesota | 27023 | 79 | 1 |
307349 | 307349 | 2020-07-06 | Chippewa | Minnesota | 27023 | 79 | 1 |
310517 | 310517 | 2020-07-07 | Chippewa | Minnesota | 27023 | 79 | 1 |
313687 | 313687 | 2020-07-08 | Chippewa | Minnesota | 27023 | 79 | 1 |
316861 | 316861 | 2020-07-09 | Chippewa | Minnesota | 27023 | 79 | 1 |
320036 | 320036 | 2020-07-10 | Chippewa | Minnesota | 27023 | 79 | 1 |
323215 | 323215 | 2020-07-11 | Chippewa | Minnesota | 27023 | 80 | 1 |
326398 | 326398 | 2020-07-12 | Chippewa | Minnesota | 27023 | 81 | 1 |
329584 | 329584 | 2020-07-13 | Chippewa | Minnesota | 27023 | 81 | 1 |
332771 | 332771 | 2020-07-14 | Chippewa | Minnesota | 27023 | 82 | 1 |
335964 | 335964 | 2020-07-15 | Chippewa | Minnesota | 27023 | 84 | 1 |
339160 | 339160 | 2020-07-16 | Chippewa | Minnesota | 27023 | 83 | 1 |
342356 | 342356 | 2020-07-17 | Chippewa | Minnesota | 27023 | 84 | 1 |
345556 | 345556 | 2020-07-18 | Chippewa | Minnesota | 27023 | 84 | 1 |
348757 | 348757 | 2020-07-19 | Chippewa | Minnesota | 27023 | 86 | 1 |
351957 | 351957 | 2020-07-20 | Chippewa | Minnesota | 27023 | 86 | 1 |
355159 | 355159 | 2020-07-21 | Chippewa | Minnesota | 27023 | 87 | 1 |
358362 | 358362 | 2020-07-22 | Chippewa | Minnesota | 27023 | 87 | 1 |
361567 | 361567 | 2020-07-23 | Chippewa | Minnesota | 27023 | 87 | 1 |
364774 | 364774 | 2020-07-24 | Chippewa | Minnesota | 27023 | 87 | 1 |
367981 | 367981 | 2020-07-25 | Chippewa | Minnesota | 27023 | 87 | 1 |
371191 | 371191 | 2020-07-26 | Chippewa | Minnesota | 27023 | 90 | 1 |
374403 | 374403 | 2020-07-27 | Chippewa | Minnesota | 27023 | 90 | 1 |
377618 | 377618 | 2020-07-28 | Chippewa | Minnesota | 27023 | 90 | 1 |
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);