ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
721 rows where county = "Hubbard" and state = "Minnesota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
170665 | 170665 | 2020-05-23 | Hubbard | Minnesota | 27057 | 1 | 0 |
173707 | 173707 | 2020-05-24 | Hubbard | Minnesota | 27057 | 1 | 0 |
176750 | 176750 | 2020-05-25 | Hubbard | Minnesota | 27057 | 1 | 0 |
179794 | 179794 | 2020-05-26 | Hubbard | Minnesota | 27057 | 1 | 0 |
182840 | 182840 | 2020-05-27 | Hubbard | Minnesota | 27057 | 1 | 0 |
185895 | 185895 | 2020-05-28 | Hubbard | Minnesota | 27057 | 1 | 0 |
188953 | 188953 | 2020-05-29 | Hubbard | Minnesota | 27057 | 2 | 0 |
192017 | 192017 | 2020-05-30 | Hubbard | Minnesota | 27057 | 3 | 0 |
195085 | 195085 | 2020-05-31 | Hubbard | Minnesota | 27057 | 2 | 0 |
198156 | 198156 | 2020-06-01 | Hubbard | Minnesota | 27057 | 2 | 0 |
201229 | 201229 | 2020-06-02 | Hubbard | Minnesota | 27057 | 3 | 0 |
204306 | 204306 | 2020-06-03 | Hubbard | Minnesota | 27057 | 3 | 0 |
207387 | 207387 | 2020-06-04 | Hubbard | Minnesota | 27057 | 3 | 0 |
210468 | 210468 | 2020-06-05 | Hubbard | Minnesota | 27057 | 3 | 0 |
213552 | 213552 | 2020-06-06 | Hubbard | Minnesota | 27057 | 3 | 0 |
216640 | 216640 | 2020-06-07 | Hubbard | Minnesota | 27057 | 4 | 0 |
219732 | 219732 | 2020-06-08 | Hubbard | Minnesota | 27057 | 5 | 0 |
222827 | 222827 | 2020-06-09 | Hubbard | Minnesota | 27057 | 5 | 0 |
225925 | 225925 | 2020-06-10 | Hubbard | Minnesota | 27057 | 5 | 0 |
229027 | 229027 | 2020-06-11 | Hubbard | Minnesota | 27057 | 5 | 0 |
232131 | 232131 | 2020-06-12 | Hubbard | Minnesota | 27057 | 5 | 0 |
235237 | 235237 | 2020-06-13 | Hubbard | Minnesota | 27057 | 5 | 0 |
238344 | 238344 | 2020-06-14 | Hubbard | Minnesota | 27057 | 5 | 0 |
241453 | 241453 | 2020-06-15 | Hubbard | Minnesota | 27057 | 5 | 0 |
244564 | 244564 | 2020-06-16 | Hubbard | Minnesota | 27057 | 5 | 0 |
247677 | 247677 | 2020-06-17 | Hubbard | Minnesota | 27057 | 5 | 0 |
250789 | 250789 | 2020-06-18 | Hubbard | Minnesota | 27057 | 5 | 0 |
253904 | 253904 | 2020-06-19 | Hubbard | Minnesota | 27057 | 5 | 0 |
257024 | 257024 | 2020-06-20 | Hubbard | Minnesota | 27057 | 5 | 0 |
260150 | 260150 | 2020-06-21 | Hubbard | Minnesota | 27057 | 5 | 0 |
263279 | 263279 | 2020-06-22 | Hubbard | Minnesota | 27057 | 5 | 0 |
266405 | 266405 | 2020-06-23 | Hubbard | Minnesota | 27057 | 5 | 0 |
269538 | 269538 | 2020-06-24 | Hubbard | Minnesota | 27057 | 5 | 0 |
272675 | 272675 | 2020-06-25 | Hubbard | Minnesota | 27057 | 5 | 0 |
275818 | 275818 | 2020-06-26 | Hubbard | Minnesota | 27057 | 5 | 0 |
278966 | 278966 | 2020-06-27 | Hubbard | Minnesota | 27057 | 5 | 0 |
282114 | 282114 | 2020-06-28 | Hubbard | Minnesota | 27057 | 5 | 0 |
285259 | 285259 | 2020-06-29 | Hubbard | Minnesota | 27057 | 5 | 0 |
288409 | 288409 | 2020-06-30 | Hubbard | Minnesota | 27057 | 5 | 0 |
291560 | 291560 | 2020-07-01 | Hubbard | Minnesota | 27057 | 5 | 0 |
294714 | 294714 | 2020-07-02 | Hubbard | Minnesota | 27057 | 5 | 0 |
297872 | 297872 | 2020-07-03 | Hubbard | Minnesota | 27057 | 6 | 0 |
301035 | 301035 | 2020-07-04 | Hubbard | Minnesota | 27057 | 6 | 0 |
304199 | 304199 | 2020-07-05 | Hubbard | Minnesota | 27057 | 6 | 0 |
307366 | 307366 | 2020-07-06 | Hubbard | Minnesota | 27057 | 7 | 0 |
310534 | 310534 | 2020-07-07 | Hubbard | Minnesota | 27057 | 8 | 0 |
313704 | 313704 | 2020-07-08 | Hubbard | Minnesota | 27057 | 8 | 0 |
316878 | 316878 | 2020-07-09 | Hubbard | Minnesota | 27057 | 8 | 0 |
320053 | 320053 | 2020-07-10 | Hubbard | Minnesota | 27057 | 8 | 0 |
323232 | 323232 | 2020-07-11 | Hubbard | Minnesota | 27057 | 10 | 0 |
326415 | 326415 | 2020-07-12 | Hubbard | Minnesota | 27057 | 10 | 0 |
329601 | 329601 | 2020-07-13 | Hubbard | Minnesota | 27057 | 10 | 0 |
332788 | 332788 | 2020-07-14 | Hubbard | Minnesota | 27057 | 11 | 0 |
335981 | 335981 | 2020-07-15 | Hubbard | Minnesota | 27057 | 12 | 0 |
339177 | 339177 | 2020-07-16 | Hubbard | Minnesota | 27057 | 12 | 0 |
342373 | 342373 | 2020-07-17 | Hubbard | Minnesota | 27057 | 12 | 0 |
345573 | 345573 | 2020-07-18 | Hubbard | Minnesota | 27057 | 12 | 0 |
348774 | 348774 | 2020-07-19 | Hubbard | Minnesota | 27057 | 12 | 0 |
351974 | 351974 | 2020-07-20 | Hubbard | Minnesota | 27057 | 12 | 0 |
355176 | 355176 | 2020-07-21 | Hubbard | Minnesota | 27057 | 12 | 0 |
358379 | 358379 | 2020-07-22 | Hubbard | Minnesota | 27057 | 12 | 0 |
361584 | 361584 | 2020-07-23 | Hubbard | Minnesota | 27057 | 13 | 0 |
364791 | 364791 | 2020-07-24 | Hubbard | Minnesota | 27057 | 13 | 0 |
367998 | 367998 | 2020-07-25 | Hubbard | Minnesota | 27057 | 18 | 0 |
371208 | 371208 | 2020-07-26 | Hubbard | Minnesota | 27057 | 19 | 0 |
374420 | 374420 | 2020-07-27 | Hubbard | Minnesota | 27057 | 20 | 0 |
377635 | 377635 | 2020-07-28 | Hubbard | Minnesota | 27057 | 21 | 0 |
380852 | 380852 | 2020-07-29 | Hubbard | Minnesota | 27057 | 22 | 0 |
384069 | 384069 | 2020-07-30 | Hubbard | Minnesota | 27057 | 25 | 0 |
387287 | 387287 | 2020-07-31 | Hubbard | Minnesota | 27057 | 27 | 0 |
390504 | 390504 | 2020-08-01 | Hubbard | Minnesota | 27057 | 27 | 0 |
393721 | 393721 | 2020-08-02 | Hubbard | Minnesota | 27057 | 28 | 0 |
396937 | 396937 | 2020-08-03 | Hubbard | Minnesota | 27057 | 28 | 0 |
400151 | 400151 | 2020-08-04 | Hubbard | Minnesota | 27057 | 32 | 0 |
403368 | 403368 | 2020-08-05 | Hubbard | Minnesota | 27057 | 30 | 0 |
406586 | 406586 | 2020-08-06 | Hubbard | Minnesota | 27057 | 30 | 0 |
409806 | 409806 | 2020-08-07 | Hubbard | Minnesota | 27057 | 32 | 0 |
413026 | 413026 | 2020-08-08 | Hubbard | Minnesota | 27057 | 33 | 0 |
416246 | 416246 | 2020-08-09 | Hubbard | Minnesota | 27057 | 33 | 0 |
419467 | 419467 | 2020-08-10 | Hubbard | Minnesota | 27057 | 34 | 0 |
422689 | 422689 | 2020-08-11 | Hubbard | Minnesota | 27057 | 35 | 0 |
425911 | 425911 | 2020-08-12 | Hubbard | Minnesota | 27057 | 35 | 0 |
429135 | 429135 | 2020-08-13 | Hubbard | Minnesota | 27057 | 36 | 0 |
432362 | 432362 | 2020-08-14 | Hubbard | Minnesota | 27057 | 37 | 0 |
435588 | 435588 | 2020-08-15 | Hubbard | Minnesota | 27057 | 37 | 0 |
438813 | 438813 | 2020-08-16 | Hubbard | Minnesota | 27057 | 37 | 0 |
442040 | 442040 | 2020-08-17 | Hubbard | Minnesota | 27057 | 37 | 0 |
445266 | 445266 | 2020-08-18 | Hubbard | Minnesota | 27057 | 37 | 0 |
448492 | 448492 | 2020-08-19 | Hubbard | Minnesota | 27057 | 37 | 0 |
451720 | 451720 | 2020-08-20 | Hubbard | Minnesota | 27057 | 39 | 0 |
454948 | 454948 | 2020-08-21 | Hubbard | Minnesota | 27057 | 40 | 0 |
458176 | 458176 | 2020-08-22 | Hubbard | Minnesota | 27057 | 41 | 0 |
461403 | 461403 | 2020-08-23 | Hubbard | Minnesota | 27057 | 41 | 0 |
464634 | 464634 | 2020-08-24 | Hubbard | Minnesota | 27057 | 42 | 0 |
467863 | 467863 | 2020-08-25 | Hubbard | Minnesota | 27057 | 41 | 0 |
471093 | 471093 | 2020-08-26 | Hubbard | Minnesota | 27057 | 41 | 0 |
474325 | 474325 | 2020-08-27 | Hubbard | Minnesota | 27057 | 42 | 0 |
477558 | 477558 | 2020-08-28 | Hubbard | Minnesota | 27057 | 42 | 0 |
480790 | 480790 | 2020-08-29 | Hubbard | Minnesota | 27057 | 43 | 0 |
484025 | 484025 | 2020-08-30 | Hubbard | Minnesota | 27057 | 44 | 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);