ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
772 rows where county = "Koochiching" and state = "Minnesota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
27146 | 27146 | 2020-04-02 | Koochiching | Minnesota | 27071 | 1 | 0 |
29465 | 29465 | 2020-04-03 | Koochiching | Minnesota | 27071 | 1 | 0 |
31843 | 31843 | 2020-04-04 | Koochiching | Minnesota | 27071 | 1 | 0 |
34269 | 34269 | 2020-04-05 | Koochiching | Minnesota | 27071 | 1 | 0 |
36729 | 36729 | 2020-04-06 | Koochiching | Minnesota | 27071 | 1 | 0 |
39238 | 39238 | 2020-04-07 | Koochiching | Minnesota | 27071 | 1 | 0 |
41791 | 41791 | 2020-04-08 | Koochiching | Minnesota | 27071 | 1 | 0 |
44367 | 44367 | 2020-04-09 | Koochiching | Minnesota | 27071 | 1 | 0 |
46976 | 46976 | 2020-04-10 | Koochiching | Minnesota | 27071 | 1 | 0 |
49621 | 49621 | 2020-04-11 | Koochiching | Minnesota | 27071 | 1 | 0 |
52291 | 52291 | 2020-04-12 | Koochiching | Minnesota | 27071 | 1 | 0 |
54973 | 54973 | 2020-04-13 | Koochiching | Minnesota | 27071 | 1 | 0 |
57671 | 57671 | 2020-04-14 | Koochiching | Minnesota | 27071 | 1 | 0 |
60381 | 60381 | 2020-04-15 | Koochiching | Minnesota | 27071 | 1 | 0 |
63103 | 63103 | 2020-04-16 | Koochiching | Minnesota | 27071 | 1 | 0 |
65842 | 65842 | 2020-04-17 | Koochiching | Minnesota | 27071 | 1 | 0 |
68594 | 68594 | 2020-04-18 | Koochiching | Minnesota | 27071 | 1 | 0 |
71358 | 71358 | 2020-04-19 | Koochiching | Minnesota | 27071 | 1 | 0 |
74131 | 74131 | 2020-04-20 | Koochiching | Minnesota | 27071 | 1 | 0 |
76911 | 76911 | 2020-04-21 | Koochiching | Minnesota | 27071 | 1 | 0 |
79696 | 79696 | 2020-04-22 | Koochiching | Minnesota | 27071 | 1 | 0 |
82492 | 82492 | 2020-04-23 | Koochiching | Minnesota | 27071 | 1 | 0 |
85296 | 85296 | 2020-04-24 | Koochiching | Minnesota | 27071 | 1 | 0 |
88106 | 88106 | 2020-04-25 | Koochiching | Minnesota | 27071 | 1 | 0 |
90922 | 90922 | 2020-04-26 | Koochiching | Minnesota | 27071 | 1 | 0 |
93743 | 93743 | 2020-04-27 | Koochiching | Minnesota | 27071 | 1 | 0 |
96578 | 96578 | 2020-04-28 | Koochiching | Minnesota | 27071 | 1 | 0 |
99424 | 99424 | 2020-04-29 | Koochiching | Minnesota | 27071 | 1 | 0 |
102276 | 102276 | 2020-04-30 | Koochiching | Minnesota | 27071 | 1 | 0 |
105137 | 105137 | 2020-05-01 | Koochiching | Minnesota | 27071 | 1 | 0 |
108002 | 108002 | 2020-05-02 | Koochiching | Minnesota | 27071 | 1 | 0 |
110873 | 110873 | 2020-05-03 | Koochiching | Minnesota | 27071 | 1 | 0 |
113752 | 113752 | 2020-05-04 | Koochiching | Minnesota | 27071 | 1 | 0 |
116633 | 116633 | 2020-05-05 | Koochiching | Minnesota | 27071 | 1 | 0 |
119593 | 119593 | 2020-05-06 | Koochiching | Minnesota | 27071 | 1 | 0 |
122566 | 122566 | 2020-05-07 | Koochiching | Minnesota | 27071 | 1 | 0 |
125548 | 125548 | 2020-05-08 | Koochiching | Minnesota | 27071 | 1 | 0 |
128535 | 128535 | 2020-05-09 | Koochiching | Minnesota | 27071 | 1 | 0 |
131525 | 131525 | 2020-05-10 | Koochiching | Minnesota | 27071 | 1 | 0 |
134516 | 134516 | 2020-05-11 | Koochiching | Minnesota | 27071 | 2 | 0 |
137506 | 137506 | 2020-05-12 | Koochiching | Minnesota | 27071 | 2 | 0 |
140500 | 140500 | 2020-05-13 | Koochiching | Minnesota | 27071 | 2 | 0 |
143495 | 143495 | 2020-05-14 | Koochiching | Minnesota | 27071 | 3 | 0 |
146495 | 146495 | 2020-05-15 | Koochiching | Minnesota | 27071 | 3 | 0 |
149500 | 149500 | 2020-05-16 | Koochiching | Minnesota | 27071 | 3 | 0 |
152511 | 152511 | 2020-05-17 | Koochiching | Minnesota | 27071 | 3 | 0 |
155525 | 155525 | 2020-05-18 | Koochiching | Minnesota | 27071 | 5 | 0 |
158543 | 158543 | 2020-05-19 | Koochiching | Minnesota | 27071 | 5 | 0 |
161569 | 161569 | 2020-05-20 | Koochiching | Minnesota | 27071 | 5 | 0 |
164598 | 164598 | 2020-05-21 | Koochiching | Minnesota | 27071 | 4 | 0 |
167634 | 167634 | 2020-05-22 | Koochiching | Minnesota | 27071 | 4 | 0 |
170672 | 170672 | 2020-05-23 | Koochiching | Minnesota | 27071 | 4 | 0 |
173714 | 173714 | 2020-05-24 | Koochiching | Minnesota | 27071 | 5 | 0 |
176757 | 176757 | 2020-05-25 | Koochiching | Minnesota | 27071 | 6 | 0 |
179801 | 179801 | 2020-05-26 | Koochiching | Minnesota | 27071 | 6 | 0 |
182847 | 182847 | 2020-05-27 | Koochiching | Minnesota | 27071 | 7 | 0 |
185902 | 185902 | 2020-05-28 | Koochiching | Minnesota | 27071 | 7 | 0 |
188960 | 188960 | 2020-05-29 | Koochiching | Minnesota | 27071 | 7 | 0 |
192024 | 192024 | 2020-05-30 | Koochiching | Minnesota | 27071 | 7 | 0 |
195092 | 195092 | 2020-05-31 | Koochiching | Minnesota | 27071 | 8 | 0 |
198163 | 198163 | 2020-06-01 | Koochiching | Minnesota | 27071 | 9 | 0 |
201236 | 201236 | 2020-06-02 | Koochiching | Minnesota | 27071 | 9 | 0 |
204313 | 204313 | 2020-06-03 | Koochiching | Minnesota | 27071 | 9 | 0 |
207394 | 207394 | 2020-06-04 | Koochiching | Minnesota | 27071 | 9 | 0 |
210475 | 210475 | 2020-06-05 | Koochiching | Minnesota | 27071 | 9 | 0 |
213559 | 213559 | 2020-06-06 | Koochiching | Minnesota | 27071 | 9 | 0 |
216647 | 216647 | 2020-06-07 | Koochiching | Minnesota | 27071 | 9 | 0 |
219739 | 219739 | 2020-06-08 | Koochiching | Minnesota | 27071 | 9 | 0 |
222834 | 222834 | 2020-06-09 | Koochiching | Minnesota | 27071 | 9 | 0 |
225932 | 225932 | 2020-06-10 | Koochiching | Minnesota | 27071 | 9 | 0 |
229034 | 229034 | 2020-06-11 | Koochiching | Minnesota | 27071 | 9 | 0 |
232138 | 232138 | 2020-06-12 | Koochiching | Minnesota | 27071 | 9 | 0 |
235244 | 235244 | 2020-06-13 | Koochiching | Minnesota | 27071 | 9 | 0 |
238351 | 238351 | 2020-06-14 | Koochiching | Minnesota | 27071 | 9 | 0 |
241460 | 241460 | 2020-06-15 | Koochiching | Minnesota | 27071 | 9 | 0 |
244571 | 244571 | 2020-06-16 | Koochiching | Minnesota | 27071 | 9 | 0 |
247684 | 247684 | 2020-06-17 | Koochiching | Minnesota | 27071 | 9 | 0 |
250796 | 250796 | 2020-06-18 | Koochiching | Minnesota | 27071 | 9 | 0 |
253911 | 253911 | 2020-06-19 | Koochiching | Minnesota | 27071 | 9 | 0 |
257031 | 257031 | 2020-06-20 | Koochiching | Minnesota | 27071 | 9 | 0 |
260157 | 260157 | 2020-06-21 | Koochiching | Minnesota | 27071 | 9 | 0 |
263286 | 263286 | 2020-06-22 | Koochiching | Minnesota | 27071 | 9 | 0 |
266412 | 266412 | 2020-06-23 | Koochiching | Minnesota | 27071 | 9 | 0 |
269545 | 269545 | 2020-06-24 | Koochiching | Minnesota | 27071 | 9 | 0 |
272682 | 272682 | 2020-06-25 | Koochiching | Minnesota | 27071 | 9 | 0 |
275825 | 275825 | 2020-06-26 | Koochiching | Minnesota | 27071 | 10 | 0 |
278973 | 278973 | 2020-06-27 | Koochiching | Minnesota | 27071 | 10 | 0 |
282121 | 282121 | 2020-06-28 | Koochiching | Minnesota | 27071 | 12 | 1 |
285266 | 285266 | 2020-06-29 | Koochiching | Minnesota | 27071 | 12 | 1 |
288416 | 288416 | 2020-06-30 | Koochiching | Minnesota | 27071 | 13 | 1 |
291567 | 291567 | 2020-07-01 | Koochiching | Minnesota | 27071 | 14 | 1 |
294721 | 294721 | 2020-07-02 | Koochiching | Minnesota | 27071 | 14 | 1 |
297879 | 297879 | 2020-07-03 | Koochiching | Minnesota | 27071 | 14 | 1 |
301042 | 301042 | 2020-07-04 | Koochiching | Minnesota | 27071 | 14 | 1 |
304206 | 304206 | 2020-07-05 | Koochiching | Minnesota | 27071 | 15 | 1 |
307373 | 307373 | 2020-07-06 | Koochiching | Minnesota | 27071 | 15 | 1 |
310541 | 310541 | 2020-07-07 | Koochiching | Minnesota | 27071 | 18 | 1 |
313711 | 313711 | 2020-07-08 | Koochiching | Minnesota | 27071 | 17 | 1 |
316885 | 316885 | 2020-07-09 | Koochiching | Minnesota | 27071 | 17 | 1 |
320060 | 320060 | 2020-07-10 | Koochiching | Minnesota | 27071 | 17 | 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);