ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
764 rows where fips = 27105 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921816 | 921816 | 2021-01-12 | Nobles | Minnesota | 27105 | 3627 | 46 |
918571 | 918571 | 2021-01-11 | Nobles | Minnesota | 27105 | 3624 | 46 |
915326 | 915326 | 2021-01-10 | Nobles | Minnesota | 27105 | 3620 | 46 |
912081 | 912081 | 2021-01-09 | Nobles | Minnesota | 27105 | 3599 | 46 |
908836 | 908836 | 2021-01-08 | Nobles | Minnesota | 27105 | 3591 | 46 |
905590 | 905590 | 2021-01-07 | Nobles | Minnesota | 27105 | 3576 | 46 |
902345 | 902345 | 2021-01-06 | Nobles | Minnesota | 27105 | 3571 | 46 |
899100 | 899100 | 2021-01-05 | Nobles | Minnesota | 27105 | 3553 | 46 |
895855 | 895855 | 2021-01-04 | Nobles | Minnesota | 27105 | 3546 | 46 |
892608 | 892608 | 2021-01-03 | Nobles | Minnesota | 27105 | 3540 | 46 |
889362 | 889362 | 2021-01-02 | Nobles | Minnesota | 27105 | 3537 | 46 |
886116 | 886116 | 2021-01-01 | Nobles | Minnesota | 27105 | 3530 | 46 |
882871 | 882871 | 2020-12-31 | Nobles | Minnesota | 27105 | 3530 | 46 |
879626 | 879626 | 2020-12-30 | Nobles | Minnesota | 27105 | 3523 | 45 |
876381 | 876381 | 2020-12-29 | Nobles | Minnesota | 27105 | 3508 | 45 |
873136 | 873136 | 2020-12-28 | Nobles | Minnesota | 27105 | 3504 | 44 |
869891 | 869891 | 2020-12-27 | Nobles | Minnesota | 27105 | 3502 | 44 |
866646 | 866646 | 2020-12-26 | Nobles | Minnesota | 27105 | 3499 | 44 |
863401 | 863401 | 2020-12-25 | Nobles | Minnesota | 27105 | 3487 | 44 |
860156 | 860156 | 2020-12-24 | Nobles | Minnesota | 27105 | 3487 | 44 |
856911 | 856911 | 2020-12-23 | Nobles | Minnesota | 27105 | 3479 | 44 |
853666 | 853666 | 2020-12-22 | Nobles | Minnesota | 27105 | 3474 | 43 |
850421 | 850421 | 2020-12-21 | Nobles | Minnesota | 27105 | 3469 | 43 |
847176 | 847176 | 2020-12-20 | Nobles | Minnesota | 27105 | 3463 | 43 |
843930 | 843930 | 2020-12-19 | Nobles | Minnesota | 27105 | 3456 | 42 |
840685 | 840685 | 2020-12-18 | Nobles | Minnesota | 27105 | 3449 | 42 |
837440 | 837440 | 2020-12-17 | Nobles | Minnesota | 27105 | 3435 | 42 |
834194 | 834194 | 2020-12-16 | Nobles | Minnesota | 27105 | 3417 | 42 |
830947 | 830947 | 2020-12-15 | Nobles | Minnesota | 27105 | 3408 | 41 |
827701 | 827701 | 2020-12-14 | Nobles | Minnesota | 27105 | 3395 | 41 |
824454 | 824454 | 2020-12-13 | Nobles | Minnesota | 27105 | 3383 | 41 |
821208 | 821208 | 2020-12-12 | Nobles | Minnesota | 27105 | 3375 | 40 |
817962 | 817962 | 2020-12-11 | Nobles | Minnesota | 27105 | 3348 | 40 |
814716 | 814716 | 2020-12-10 | Nobles | Minnesota | 27105 | 3319 | 39 |
811471 | 811471 | 2020-12-09 | Nobles | Minnesota | 27105 | 3302 | 39 |
808226 | 808226 | 2020-12-08 | Nobles | Minnesota | 27105 | 3272 | 37 |
804981 | 804981 | 2020-12-07 | Nobles | Minnesota | 27105 | 3258 | 35 |
801736 | 801736 | 2020-12-06 | Nobles | Minnesota | 27105 | 3234 | 35 |
798491 | 798491 | 2020-12-05 | Nobles | Minnesota | 27105 | 3210 | 34 |
795246 | 795246 | 2020-12-04 | Nobles | Minnesota | 27105 | 3171 | 34 |
792001 | 792001 | 2020-12-03 | Nobles | Minnesota | 27105 | 3160 | 32 |
788756 | 788756 | 2020-12-02 | Nobles | Minnesota | 27105 | 3137 | 31 |
785511 | 785511 | 2020-12-01 | Nobles | Minnesota | 27105 | 3117 | 30 |
782267 | 782267 | 2020-11-30 | Nobles | Minnesota | 27105 | 3099 | 30 |
779021 | 779021 | 2020-11-29 | Nobles | Minnesota | 27105 | 3087 | 30 |
775776 | 775776 | 2020-11-28 | Nobles | Minnesota | 27105 | 3049 | 29 |
772531 | 772531 | 2020-11-27 | Nobles | Minnesota | 27105 | 3014 | 29 |
769286 | 769286 | 2020-11-26 | Nobles | Minnesota | 27105 | 2987 | 29 |
766040 | 766040 | 2020-11-25 | Nobles | Minnesota | 27105 | 2987 | 29 |
762795 | 762795 | 2020-11-24 | Nobles | Minnesota | 27105 | 2980 | 29 |
759550 | 759550 | 2020-11-23 | Nobles | Minnesota | 27105 | 2960 | 28 |
756303 | 756303 | 2020-11-22 | Nobles | Minnesota | 27105 | 2938 | 28 |
753057 | 753057 | 2020-11-21 | Nobles | Minnesota | 27105 | 2915 | 28 |
749811 | 749811 | 2020-11-20 | Nobles | Minnesota | 27105 | 2887 | 27 |
746565 | 746565 | 2020-11-19 | Nobles | Minnesota | 27105 | 2855 | 27 |
743318 | 743318 | 2020-11-18 | Nobles | Minnesota | 27105 | 2840 | 27 |
740071 | 740071 | 2020-11-17 | Nobles | Minnesota | 27105 | 2830 | 27 |
736827 | 736827 | 2020-11-16 | Nobles | Minnesota | 27105 | 2808 | 25 |
733581 | 733581 | 2020-11-15 | Nobles | Minnesota | 27105 | 2779 | 25 |
730336 | 730336 | 2020-11-14 | Nobles | Minnesota | 27105 | 2755 | 25 |
727093 | 727093 | 2020-11-13 | Nobles | Minnesota | 27105 | 2714 | 25 |
723850 | 723850 | 2020-11-12 | Nobles | Minnesota | 27105 | 2692 | 24 |
720607 | 720607 | 2020-11-11 | Nobles | Minnesota | 27105 | 2661 | 24 |
717364 | 717364 | 2020-11-10 | Nobles | Minnesota | 27105 | 2636 | 22 |
714120 | 714120 | 2020-11-09 | Nobles | Minnesota | 27105 | 2621 | 22 |
710876 | 710876 | 2020-11-08 | Nobles | Minnesota | 27105 | 2614 | 22 |
707632 | 707632 | 2020-11-07 | Nobles | Minnesota | 27105 | 2556 | 22 |
704389 | 704389 | 2020-11-06 | Nobles | Minnesota | 27105 | 2537 | 22 |
701147 | 701147 | 2020-11-05 | Nobles | Minnesota | 27105 | 2527 | 21 |
697903 | 697903 | 2020-11-04 | Nobles | Minnesota | 27105 | 2487 | 20 |
694660 | 694660 | 2020-11-03 | Nobles | Minnesota | 27105 | 2475 | 20 |
691418 | 691418 | 2020-11-02 | Nobles | Minnesota | 27105 | 2450 | 19 |
688173 | 688173 | 2020-11-01 | Nobles | Minnesota | 27105 | 2442 | 19 |
684929 | 684929 | 2020-10-31 | Nobles | Minnesota | 27105 | 2410 | 18 |
681686 | 681686 | 2020-10-30 | Nobles | Minnesota | 27105 | 2368 | 18 |
678442 | 678442 | 2020-10-29 | Nobles | Minnesota | 27105 | 2343 | 18 |
675200 | 675200 | 2020-10-28 | Nobles | Minnesota | 27105 | 2319 | 18 |
671957 | 671957 | 2020-10-27 | Nobles | Minnesota | 27105 | 2309 | 16 |
668715 | 668715 | 2020-10-26 | Nobles | Minnesota | 27105 | 2276 | 16 |
665471 | 665471 | 2020-10-25 | Nobles | Minnesota | 27105 | 2268 | 16 |
662226 | 662226 | 2020-10-24 | Nobles | Minnesota | 27105 | 2257 | 16 |
658982 | 658982 | 2020-10-23 | Nobles | Minnesota | 27105 | 2219 | 16 |
655737 | 655737 | 2020-10-22 | Nobles | Minnesota | 27105 | 2195 | 16 |
652492 | 652492 | 2020-10-21 | Nobles | Minnesota | 27105 | 2174 | 16 |
649247 | 649247 | 2020-10-20 | Nobles | Minnesota | 27105 | 2164 | 16 |
646003 | 646003 | 2020-10-19 | Nobles | Minnesota | 27105 | 2140 | 16 |
642756 | 642756 | 2020-10-18 | Nobles | Minnesota | 27105 | 2117 | 16 |
639509 | 639509 | 2020-10-17 | Nobles | Minnesota | 27105 | 2106 | 16 |
636263 | 636263 | 2020-10-16 | Nobles | Minnesota | 27105 | 2093 | 16 |
633017 | 633017 | 2020-10-15 | Nobles | Minnesota | 27105 | 2085 | 16 |
629772 | 629772 | 2020-10-14 | Nobles | Minnesota | 27105 | 2072 | 16 |
626528 | 626528 | 2020-10-13 | Nobles | Minnesota | 27105 | 2064 | 16 |
623286 | 623286 | 2020-10-12 | Nobles | Minnesota | 27105 | 2057 | 16 |
620043 | 620043 | 2020-10-11 | Nobles | Minnesota | 27105 | 2052 | 16 |
616801 | 616801 | 2020-10-10 | Nobles | Minnesota | 27105 | 2038 | 16 |
613560 | 613560 | 2020-10-09 | Nobles | Minnesota | 27105 | 2034 | 16 |
610318 | 610318 | 2020-10-08 | Nobles | Minnesota | 27105 | 2024 | 16 |
607076 | 607076 | 2020-10-07 | Nobles | Minnesota | 27105 | 2019 | 16 |
603833 | 603833 | 2020-10-06 | Nobles | Minnesota | 27105 | 2016 | 16 |
600591 | 600591 | 2020-10-05 | Nobles | Minnesota | 27105 | 2013 | 16 |
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);