ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 27025 and state = "Minnesota" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
282098 | 282098 | 2020-06-28 | Chisago | Minnesota | 27025 | 92 | 1 |
285243 | 285243 | 2020-06-29 | Chisago | Minnesota | 27025 | 93 | 1 |
288393 | 288393 | 2020-06-30 | Chisago | Minnesota | 27025 | 93 | 1 |
291544 | 291544 | 2020-07-01 | Chisago | Minnesota | 27025 | 95 | 1 |
294698 | 294698 | 2020-07-02 | Chisago | Minnesota | 27025 | 97 | 1 |
297856 | 297856 | 2020-07-03 | Chisago | Minnesota | 27025 | 97 | 1 |
301019 | 301019 | 2020-07-04 | Chisago | Minnesota | 27025 | 97 | 1 |
304183 | 304183 | 2020-07-05 | Chisago | Minnesota | 27025 | 98 | 1 |
307350 | 307350 | 2020-07-06 | Chisago | Minnesota | 27025 | 100 | 1 |
310518 | 310518 | 2020-07-07 | Chisago | Minnesota | 27025 | 102 | 1 |
313688 | 313688 | 2020-07-08 | Chisago | Minnesota | 27025 | 102 | 1 |
316862 | 316862 | 2020-07-09 | Chisago | Minnesota | 27025 | 103 | 1 |
320037 | 320037 | 2020-07-10 | Chisago | Minnesota | 27025 | 105 | 1 |
323216 | 323216 | 2020-07-11 | Chisago | Minnesota | 27025 | 107 | 1 |
326399 | 326399 | 2020-07-12 | Chisago | Minnesota | 27025 | 110 | 1 |
329585 | 329585 | 2020-07-13 | Chisago | Minnesota | 27025 | 111 | 1 |
332772 | 332772 | 2020-07-14 | Chisago | Minnesota | 27025 | 112 | 1 |
335965 | 335965 | 2020-07-15 | Chisago | Minnesota | 27025 | 113 | 1 |
339161 | 339161 | 2020-07-16 | Chisago | Minnesota | 27025 | 114 | 1 |
342357 | 342357 | 2020-07-17 | Chisago | Minnesota | 27025 | 119 | 1 |
345557 | 345557 | 2020-07-18 | Chisago | Minnesota | 27025 | 121 | 1 |
348758 | 348758 | 2020-07-19 | Chisago | Minnesota | 27025 | 124 | 1 |
351958 | 351958 | 2020-07-20 | Chisago | Minnesota | 27025 | 126 | 1 |
355160 | 355160 | 2020-07-21 | Chisago | Minnesota | 27025 | 128 | 1 |
358363 | 358363 | 2020-07-22 | Chisago | Minnesota | 27025 | 135 | 1 |
361568 | 361568 | 2020-07-23 | Chisago | Minnesota | 27025 | 138 | 1 |
364775 | 364775 | 2020-07-24 | Chisago | Minnesota | 27025 | 141 | 1 |
367982 | 367982 | 2020-07-25 | Chisago | Minnesota | 27025 | 147 | 1 |
371192 | 371192 | 2020-07-26 | Chisago | Minnesota | 27025 | 154 | 1 |
374404 | 374404 | 2020-07-27 | Chisago | Minnesota | 27025 | 156 | 1 |
377619 | 377619 | 2020-07-28 | Chisago | Minnesota | 27025 | 156 | 1 |
380836 | 380836 | 2020-07-29 | Chisago | Minnesota | 27025 | 158 | 1 |
384053 | 384053 | 2020-07-30 | Chisago | Minnesota | 27025 | 160 | 1 |
387271 | 387271 | 2020-07-31 | Chisago | Minnesota | 27025 | 167 | 1 |
390488 | 390488 | 2020-08-01 | Chisago | Minnesota | 27025 | 172 | 1 |
393705 | 393705 | 2020-08-02 | Chisago | Minnesota | 27025 | 176 | 1 |
396921 | 396921 | 2020-08-03 | Chisago | Minnesota | 27025 | 179 | 1 |
400135 | 400135 | 2020-08-04 | Chisago | Minnesota | 27025 | 182 | 1 |
403352 | 403352 | 2020-08-05 | Chisago | Minnesota | 27025 | 184 | 1 |
406570 | 406570 | 2020-08-06 | Chisago | Minnesota | 27025 | 189 | 1 |
409790 | 409790 | 2020-08-07 | Chisago | Minnesota | 27025 | 190 | 1 |
413010 | 413010 | 2020-08-08 | Chisago | Minnesota | 27025 | 199 | 1 |
416230 | 416230 | 2020-08-09 | Chisago | Minnesota | 27025 | 201 | 1 |
419451 | 419451 | 2020-08-10 | Chisago | Minnesota | 27025 | 204 | 1 |
422673 | 422673 | 2020-08-11 | Chisago | Minnesota | 27025 | 204 | 1 |
425895 | 425895 | 2020-08-12 | Chisago | Minnesota | 27025 | 207 | 1 |
429119 | 429119 | 2020-08-13 | Chisago | Minnesota | 27025 | 209 | 1 |
432346 | 432346 | 2020-08-14 | Chisago | Minnesota | 27025 | 211 | 1 |
435572 | 435572 | 2020-08-15 | Chisago | Minnesota | 27025 | 212 | 1 |
438797 | 438797 | 2020-08-16 | Chisago | Minnesota | 27025 | 214 | 1 |
442024 | 442024 | 2020-08-17 | Chisago | Minnesota | 27025 | 221 | 1 |
445250 | 445250 | 2020-08-18 | Chisago | Minnesota | 27025 | 227 | 1 |
448476 | 448476 | 2020-08-19 | Chisago | Minnesota | 27025 | 233 | 1 |
451704 | 451704 | 2020-08-20 | Chisago | Minnesota | 27025 | 238 | 1 |
454932 | 454932 | 2020-08-21 | Chisago | Minnesota | 27025 | 247 | 1 |
458160 | 458160 | 2020-08-22 | Chisago | Minnesota | 27025 | 256 | 1 |
461387 | 461387 | 2020-08-23 | Chisago | Minnesota | 27025 | 269 | 1 |
464618 | 464618 | 2020-08-24 | Chisago | Minnesota | 27025 | 277 | 1 |
467847 | 467847 | 2020-08-25 | Chisago | Minnesota | 27025 | 278 | 1 |
471077 | 471077 | 2020-08-26 | Chisago | Minnesota | 27025 | 281 | 1 |
474309 | 474309 | 2020-08-27 | Chisago | Minnesota | 27025 | 289 | 1 |
477542 | 477542 | 2020-08-28 | Chisago | Minnesota | 27025 | 291 | 1 |
480774 | 480774 | 2020-08-29 | Chisago | Minnesota | 27025 | 296 | 1 |
484009 | 484009 | 2020-08-30 | Chisago | Minnesota | 27025 | 311 | 1 |
487243 | 487243 | 2020-08-31 | Chisago | Minnesota | 27025 | 316 | 1 |
490476 | 490476 | 2020-09-01 | Chisago | Minnesota | 27025 | 319 | 1 |
493710 | 493710 | 2020-09-02 | Chisago | Minnesota | 27025 | 321 | 1 |
496943 | 496943 | 2020-09-03 | Chisago | Minnesota | 27025 | 327 | 1 |
500177 | 500177 | 2020-09-04 | Chisago | Minnesota | 27025 | 329 | 1 |
503411 | 503411 | 2020-09-05 | Chisago | Minnesota | 27025 | 342 | 1 |
506644 | 506644 | 2020-09-06 | Chisago | Minnesota | 27025 | 351 | 1 |
509877 | 509877 | 2020-09-07 | Chisago | Minnesota | 27025 | 361 | 1 |
513109 | 513109 | 2020-09-08 | Chisago | Minnesota | 27025 | 369 | 1 |
516343 | 516343 | 2020-09-09 | Chisago | Minnesota | 27025 | 373 | 1 |
519578 | 519578 | 2020-09-10 | Chisago | Minnesota | 27025 | 376 | 1 |
522815 | 522815 | 2020-09-11 | Chisago | Minnesota | 27025 | 381 | 1 |
526051 | 526051 | 2020-09-12 | Chisago | Minnesota | 27025 | 389 | 1 |
529287 | 529287 | 2020-09-13 | Chisago | Minnesota | 27025 | 392 | 1 |
532523 | 532523 | 2020-09-14 | Chisago | Minnesota | 27025 | 398 | 1 |
535758 | 535758 | 2020-09-15 | Chisago | Minnesota | 27025 | 408 | 1 |
538995 | 538995 | 2020-09-16 | Chisago | Minnesota | 27025 | 413 | 1 |
542231 | 542231 | 2020-09-17 | Chisago | Minnesota | 27025 | 415 | 1 |
545468 | 545468 | 2020-09-18 | Chisago | Minnesota | 27025 | 421 | 1 |
548706 | 548706 | 2020-09-19 | Chisago | Minnesota | 27025 | 433 | 1 |
551945 | 551945 | 2020-09-20 | Chisago | Minnesota | 27025 | 444 | 1 |
555183 | 555183 | 2020-09-21 | Chisago | Minnesota | 27025 | 458 | 1 |
558420 | 558420 | 2020-09-22 | Chisago | Minnesota | 27025 | 462 | 1 |
561657 | 561657 | 2020-09-23 | Chisago | Minnesota | 27025 | 466 | 1 |
564897 | 564897 | 2020-09-24 | Chisago | Minnesota | 27025 | 471 | 1 |
568137 | 568137 | 2020-09-25 | Chisago | Minnesota | 27025 | 484 | 1 |
571379 | 571379 | 2020-09-26 | Chisago | Minnesota | 27025 | 494 | 1 |
574622 | 574622 | 2020-09-27 | Chisago | Minnesota | 27025 | 507 | 1 |
577863 | 577863 | 2020-09-28 | Chisago | Minnesota | 27025 | 513 | 1 |
581104 | 581104 | 2020-09-29 | Chisago | Minnesota | 27025 | 517 | 1 |
584345 | 584345 | 2020-09-30 | Chisago | Minnesota | 27025 | 522 | 1 |
587585 | 587585 | 2020-10-01 | Chisago | Minnesota | 27025 | 536 | 1 |
590826 | 590826 | 2020-10-02 | Chisago | Minnesota | 27025 | 558 | 1 |
594067 | 594067 | 2020-10-03 | Chisago | Minnesota | 27025 | 574 | 1 |
597308 | 597308 | 2020-10-04 | Chisago | Minnesota | 27025 | 585 | 2 |
600551 | 600551 | 2020-10-05 | Chisago | Minnesota | 27025 | 594 | 2 |
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);