ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 27103 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
730335 | 730335 | 2020-11-14 | Nicollet | Minnesota | 27103 | 1088 | 21 |
727092 | 727092 | 2020-11-13 | Nicollet | Minnesota | 27103 | 1042 | 21 |
723849 | 723849 | 2020-11-12 | Nicollet | Minnesota | 27103 | 1027 | 20 |
720606 | 720606 | 2020-11-11 | Nicollet | Minnesota | 27103 | 1011 | 20 |
717363 | 717363 | 2020-11-10 | Nicollet | Minnesota | 27103 | 982 | 20 |
714119 | 714119 | 2020-11-09 | Nicollet | Minnesota | 27103 | 963 | 20 |
710875 | 710875 | 2020-11-08 | Nicollet | Minnesota | 27103 | 953 | 20 |
707631 | 707631 | 2020-11-07 | Nicollet | Minnesota | 27103 | 920 | 20 |
704388 | 704388 | 2020-11-06 | Nicollet | Minnesota | 27103 | 886 | 20 |
701146 | 701146 | 2020-11-05 | Nicollet | Minnesota | 27103 | 863 | 18 |
697902 | 697902 | 2020-11-04 | Nicollet | Minnesota | 27103 | 848 | 18 |
694659 | 694659 | 2020-11-03 | Nicollet | Minnesota | 27103 | 829 | 18 |
691417 | 691417 | 2020-11-02 | Nicollet | Minnesota | 27103 | 810 | 18 |
688172 | 688172 | 2020-11-01 | Nicollet | Minnesota | 27103 | 802 | 18 |
684928 | 684928 | 2020-10-31 | Nicollet | Minnesota | 27103 | 793 | 18 |
681685 | 681685 | 2020-10-30 | Nicollet | Minnesota | 27103 | 783 | 18 |
678441 | 678441 | 2020-10-29 | Nicollet | Minnesota | 27103 | 771 | 18 |
675199 | 675199 | 2020-10-28 | Nicollet | Minnesota | 27103 | 756 | 18 |
671956 | 671956 | 2020-10-27 | Nicollet | Minnesota | 27103 | 747 | 18 |
668714 | 668714 | 2020-10-26 | Nicollet | Minnesota | 27103 | 739 | 17 |
665470 | 665470 | 2020-10-25 | Nicollet | Minnesota | 27103 | 730 | 17 |
662225 | 662225 | 2020-10-24 | Nicollet | Minnesota | 27103 | 718 | 17 |
658981 | 658981 | 2020-10-23 | Nicollet | Minnesota | 27103 | 714 | 17 |
655736 | 655736 | 2020-10-22 | Nicollet | Minnesota | 27103 | 700 | 17 |
652491 | 652491 | 2020-10-21 | Nicollet | Minnesota | 27103 | 689 | 17 |
649246 | 649246 | 2020-10-20 | Nicollet | Minnesota | 27103 | 682 | 17 |
646002 | 646002 | 2020-10-19 | Nicollet | Minnesota | 27103 | 673 | 17 |
642755 | 642755 | 2020-10-18 | Nicollet | Minnesota | 27103 | 664 | 17 |
639508 | 639508 | 2020-10-17 | Nicollet | Minnesota | 27103 | 663 | 17 |
636262 | 636262 | 2020-10-16 | Nicollet | Minnesota | 27103 | 651 | 17 |
633016 | 633016 | 2020-10-15 | Nicollet | Minnesota | 27103 | 638 | 17 |
629771 | 629771 | 2020-10-14 | Nicollet | Minnesota | 27103 | 637 | 17 |
626527 | 626527 | 2020-10-13 | Nicollet | Minnesota | 27103 | 630 | 17 |
623285 | 623285 | 2020-10-12 | Nicollet | Minnesota | 27103 | 628 | 17 |
620042 | 620042 | 2020-10-11 | Nicollet | Minnesota | 27103 | 628 | 17 |
616800 | 616800 | 2020-10-10 | Nicollet | Minnesota | 27103 | 625 | 17 |
613559 | 613559 | 2020-10-09 | Nicollet | Minnesota | 27103 | 619 | 17 |
610317 | 610317 | 2020-10-08 | Nicollet | Minnesota | 27103 | 613 | 17 |
607075 | 607075 | 2020-10-07 | Nicollet | Minnesota | 27103 | 607 | 17 |
603832 | 603832 | 2020-10-06 | Nicollet | Minnesota | 27103 | 602 | 17 |
600590 | 600590 | 2020-10-05 | Nicollet | Minnesota | 27103 | 594 | 17 |
597347 | 597347 | 2020-10-04 | Nicollet | Minnesota | 27103 | 589 | 17 |
594106 | 594106 | 2020-10-03 | Nicollet | Minnesota | 27103 | 583 | 17 |
590865 | 590865 | 2020-10-02 | Nicollet | Minnesota | 27103 | 570 | 17 |
587624 | 587624 | 2020-10-01 | Nicollet | Minnesota | 27103 | 562 | 17 |
584384 | 584384 | 2020-09-30 | Nicollet | Minnesota | 27103 | 553 | 17 |
581143 | 581143 | 2020-09-29 | Nicollet | Minnesota | 27103 | 547 | 17 |
577902 | 577902 | 2020-09-28 | Nicollet | Minnesota | 27103 | 545 | 17 |
574661 | 574661 | 2020-09-27 | Nicollet | Minnesota | 27103 | 542 | 17 |
571418 | 571418 | 2020-09-26 | Nicollet | Minnesota | 27103 | 540 | 16 |
568176 | 568176 | 2020-09-25 | Nicollet | Minnesota | 27103 | 529 | 16 |
564936 | 564936 | 2020-09-24 | Nicollet | Minnesota | 27103 | 521 | 16 |
561696 | 561696 | 2020-09-23 | Nicollet | Minnesota | 27103 | 515 | 16 |
558459 | 558459 | 2020-09-22 | Nicollet | Minnesota | 27103 | 513 | 16 |
555222 | 555222 | 2020-09-21 | Nicollet | Minnesota | 27103 | 504 | 16 |
551984 | 551984 | 2020-09-20 | Nicollet | Minnesota | 27103 | 499 | 16 |
548745 | 548745 | 2020-09-19 | Nicollet | Minnesota | 27103 | 496 | 16 |
545507 | 545507 | 2020-09-18 | Nicollet | Minnesota | 27103 | 495 | 16 |
542270 | 542270 | 2020-09-17 | Nicollet | Minnesota | 27103 | 487 | 16 |
539034 | 539034 | 2020-09-16 | Nicollet | Minnesota | 27103 | 484 | 16 |
535797 | 535797 | 2020-09-15 | Nicollet | Minnesota | 27103 | 484 | 16 |
532562 | 532562 | 2020-09-14 | Nicollet | Minnesota | 27103 | 479 | 16 |
529326 | 529326 | 2020-09-13 | Nicollet | Minnesota | 27103 | 476 | 16 |
526090 | 526090 | 2020-09-12 | Nicollet | Minnesota | 27103 | 474 | 16 |
522854 | 522854 | 2020-09-11 | Nicollet | Minnesota | 27103 | 471 | 16 |
519617 | 519617 | 2020-09-10 | Nicollet | Minnesota | 27103 | 469 | 16 |
516382 | 516382 | 2020-09-09 | Nicollet | Minnesota | 27103 | 461 | 15 |
513148 | 513148 | 2020-09-08 | Nicollet | Minnesota | 27103 | 459 | 15 |
509916 | 509916 | 2020-09-07 | Nicollet | Minnesota | 27103 | 457 | 15 |
506683 | 506683 | 2020-09-06 | Nicollet | Minnesota | 27103 | 456 | 15 |
503450 | 503450 | 2020-09-05 | Nicollet | Minnesota | 27103 | 455 | 15 |
500216 | 500216 | 2020-09-04 | Nicollet | Minnesota | 27103 | 452 | 15 |
496982 | 496982 | 2020-09-03 | Nicollet | Minnesota | 27103 | 449 | 15 |
493749 | 493749 | 2020-09-02 | Nicollet | Minnesota | 27103 | 445 | 15 |
490515 | 490515 | 2020-09-01 | Nicollet | Minnesota | 27103 | 442 | 15 |
487282 | 487282 | 2020-08-31 | Nicollet | Minnesota | 27103 | 442 | 15 |
484048 | 484048 | 2020-08-30 | Nicollet | Minnesota | 27103 | 438 | 15 |
480813 | 480813 | 2020-08-29 | Nicollet | Minnesota | 27103 | 436 | 15 |
477581 | 477581 | 2020-08-28 | Nicollet | Minnesota | 27103 | 427 | 15 |
474348 | 474348 | 2020-08-27 | Nicollet | Minnesota | 27103 | 423 | 15 |
471116 | 471116 | 2020-08-26 | Nicollet | Minnesota | 27103 | 413 | 15 |
467886 | 467886 | 2020-08-25 | Nicollet | Minnesota | 27103 | 413 | 14 |
464657 | 464657 | 2020-08-24 | Nicollet | Minnesota | 27103 | 412 | 14 |
461426 | 461426 | 2020-08-23 | Nicollet | Minnesota | 27103 | 408 | 14 |
458199 | 458199 | 2020-08-22 | Nicollet | Minnesota | 27103 | 404 | 14 |
454971 | 454971 | 2020-08-21 | Nicollet | Minnesota | 27103 | 402 | 14 |
451743 | 451743 | 2020-08-20 | Nicollet | Minnesota | 27103 | 396 | 13 |
448515 | 448515 | 2020-08-19 | Nicollet | Minnesota | 27103 | 386 | 13 |
445289 | 445289 | 2020-08-18 | Nicollet | Minnesota | 27103 | 384 | 13 |
442063 | 442063 | 2020-08-17 | Nicollet | Minnesota | 27103 | 378 | 13 |
438836 | 438836 | 2020-08-16 | Nicollet | Minnesota | 27103 | 375 | 13 |
435611 | 435611 | 2020-08-15 | Nicollet | Minnesota | 27103 | 371 | 13 |
432385 | 432385 | 2020-08-14 | Nicollet | Minnesota | 27103 | 363 | 13 |
429158 | 429158 | 2020-08-13 | Nicollet | Minnesota | 27103 | 356 | 13 |
425934 | 425934 | 2020-08-12 | Nicollet | Minnesota | 27103 | 351 | 13 |
422712 | 422712 | 2020-08-11 | Nicollet | Minnesota | 27103 | 347 | 13 |
419490 | 419490 | 2020-08-10 | Nicollet | Minnesota | 27103 | 342 | 13 |
416269 | 416269 | 2020-08-09 | Nicollet | Minnesota | 27103 | 337 | 13 |
413049 | 413049 | 2020-08-08 | Nicollet | Minnesota | 27103 | 333 | 13 |
409829 | 409829 | 2020-08-07 | Nicollet | Minnesota | 27103 | 329 | 13 |
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);