ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where county = "Rice" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
921829 | 921829 | 2021-01-12 | Rice | Minnesota | 27131 | 5891 | 64 |
918584 | 918584 | 2021-01-11 | Rice | Minnesota | 27131 | 5872 | 64 |
915339 | 915339 | 2021-01-10 | Rice | Minnesota | 27131 | 5853 | 63 |
912094 | 912094 | 2021-01-09 | Rice | Minnesota | 27131 | 5830 | 62 |
908849 | 908849 | 2021-01-08 | Rice | Minnesota | 27131 | 5773 | 62 |
905603 | 905603 | 2021-01-07 | Rice | Minnesota | 27131 | 5724 | 60 |
902358 | 902358 | 2021-01-06 | Rice | Minnesota | 27131 | 5689 | 60 |
899113 | 899113 | 2021-01-05 | Rice | Minnesota | 27131 | 5665 | 57 |
895868 | 895868 | 2021-01-04 | Rice | Minnesota | 27131 | 5626 | 57 |
892621 | 892621 | 2021-01-03 | Rice | Minnesota | 27131 | 5600 | 57 |
889375 | 889375 | 2021-01-02 | Rice | Minnesota | 27131 | 5570 | 55 |
886129 | 886129 | 2021-01-01 | Rice | Minnesota | 27131 | 5516 | 55 |
882884 | 882884 | 2020-12-31 | Rice | Minnesota | 27131 | 5516 | 55 |
879639 | 879639 | 2020-12-30 | Rice | Minnesota | 27131 | 5478 | 55 |
876394 | 876394 | 2020-12-29 | Rice | Minnesota | 27131 | 5463 | 52 |
873149 | 873149 | 2020-12-28 | Rice | Minnesota | 27131 | 5451 | 52 |
869904 | 869904 | 2020-12-27 | Rice | Minnesota | 27131 | 5435 | 52 |
866659 | 866659 | 2020-12-26 | Rice | Minnesota | 27131 | 5358 | 50 |
863414 | 863414 | 2020-12-25 | Rice | Minnesota | 27131 | 5312 | 48 |
860169 | 860169 | 2020-12-24 | Rice | Minnesota | 27131 | 5312 | 48 |
856924 | 856924 | 2020-12-23 | Rice | Minnesota | 27131 | 5264 | 47 |
853679 | 853679 | 2020-12-22 | Rice | Minnesota | 27131 | 5243 | 47 |
850434 | 850434 | 2020-12-21 | Rice | Minnesota | 27131 | 5229 | 47 |
847189 | 847189 | 2020-12-20 | Rice | Minnesota | 27131 | 5201 | 47 |
843943 | 843943 | 2020-12-19 | Rice | Minnesota | 27131 | 5150 | 47 |
840698 | 840698 | 2020-12-18 | Rice | Minnesota | 27131 | 5108 | 47 |
837453 | 837453 | 2020-12-17 | Rice | Minnesota | 27131 | 5015 | 47 |
834207 | 834207 | 2020-12-16 | Rice | Minnesota | 27131 | 4973 | 47 |
830960 | 830960 | 2020-12-15 | Rice | Minnesota | 27131 | 4934 | 46 |
827714 | 827714 | 2020-12-14 | Rice | Minnesota | 27131 | 4916 | 46 |
824467 | 824467 | 2020-12-13 | Rice | Minnesota | 27131 | 4885 | 45 |
821221 | 821221 | 2020-12-12 | Rice | Minnesota | 27131 | 4842 | 45 |
817975 | 817975 | 2020-12-11 | Rice | Minnesota | 27131 | 4765 | 45 |
814729 | 814729 | 2020-12-10 | Rice | Minnesota | 27131 | 4707 | 42 |
811484 | 811484 | 2020-12-09 | Rice | Minnesota | 27131 | 4674 | 40 |
808239 | 808239 | 2020-12-08 | Rice | Minnesota | 27131 | 4642 | 40 |
804994 | 804994 | 2020-12-07 | Rice | Minnesota | 27131 | 4612 | 39 |
801749 | 801749 | 2020-12-06 | Rice | Minnesota | 27131 | 4559 | 39 |
798504 | 798504 | 2020-12-05 | Rice | Minnesota | 27131 | 4527 | 39 |
795259 | 795259 | 2020-12-04 | Rice | Minnesota | 27131 | 4384 | 39 |
792014 | 792014 | 2020-12-03 | Rice | Minnesota | 27131 | 4323 | 38 |
788769 | 788769 | 2020-12-02 | Rice | Minnesota | 27131 | 4277 | 38 |
785524 | 785524 | 2020-12-01 | Rice | Minnesota | 27131 | 4229 | 37 |
782280 | 782280 | 2020-11-30 | Rice | Minnesota | 27131 | 4192 | 37 |
779034 | 779034 | 2020-11-29 | Rice | Minnesota | 27131 | 4128 | 36 |
775789 | 775789 | 2020-11-28 | Rice | Minnesota | 27131 | 4031 | 36 |
772544 | 772544 | 2020-11-27 | Rice | Minnesota | 27131 | 3933 | 35 |
769299 | 769299 | 2020-11-26 | Rice | Minnesota | 27131 | 3860 | 33 |
766053 | 766053 | 2020-11-25 | Rice | Minnesota | 27131 | 3860 | 33 |
762808 | 762808 | 2020-11-24 | Rice | Minnesota | 27131 | 3777 | 32 |
759563 | 759563 | 2020-11-23 | Rice | Minnesota | 27131 | 3614 | 31 |
756316 | 756316 | 2020-11-22 | Rice | Minnesota | 27131 | 3503 | 31 |
753070 | 753070 | 2020-11-21 | Rice | Minnesota | 27131 | 3431 | 30 |
749824 | 749824 | 2020-11-20 | Rice | Minnesota | 27131 | 3358 | 28 |
746578 | 746578 | 2020-11-19 | Rice | Minnesota | 27131 | 3248 | 27 |
743331 | 743331 | 2020-11-18 | Rice | Minnesota | 27131 | 3071 | 27 |
740084 | 740084 | 2020-11-17 | Rice | Minnesota | 27131 | 2954 | 25 |
736840 | 736840 | 2020-11-16 | Rice | Minnesota | 27131 | 2879 | 25 |
733594 | 733594 | 2020-11-15 | Rice | Minnesota | 27131 | 2758 | 25 |
730349 | 730349 | 2020-11-14 | Rice | Minnesota | 27131 | 2600 | 23 |
727106 | 727106 | 2020-11-13 | Rice | Minnesota | 27131 | 2466 | 21 |
723863 | 723863 | 2020-11-12 | Rice | Minnesota | 27131 | 2411 | 20 |
720620 | 720620 | 2020-11-11 | Rice | Minnesota | 27131 | 2328 | 20 |
717377 | 717377 | 2020-11-10 | Rice | Minnesota | 27131 | 2237 | 15 |
714133 | 714133 | 2020-11-09 | Rice | Minnesota | 27131 | 2179 | 15 |
710889 | 710889 | 2020-11-08 | Rice | Minnesota | 27131 | 2145 | 15 |
707645 | 707645 | 2020-11-07 | Rice | Minnesota | 27131 | 2074 | 14 |
704402 | 704402 | 2020-11-06 | Rice | Minnesota | 27131 | 1990 | 13 |
701160 | 701160 | 2020-11-05 | Rice | Minnesota | 27131 | 1919 | 13 |
697916 | 697916 | 2020-11-04 | Rice | Minnesota | 27131 | 1865 | 13 |
694673 | 694673 | 2020-11-03 | Rice | Minnesota | 27131 | 1823 | 12 |
691431 | 691431 | 2020-11-02 | Rice | Minnesota | 27131 | 1798 | 12 |
688186 | 688186 | 2020-11-01 | Rice | Minnesota | 27131 | 1783 | 12 |
684942 | 684942 | 2020-10-31 | Rice | Minnesota | 27131 | 1761 | 12 |
681699 | 681699 | 2020-10-30 | Rice | Minnesota | 27131 | 1742 | 10 |
678455 | 678455 | 2020-10-29 | Rice | Minnesota | 27131 | 1702 | 10 |
675213 | 675213 | 2020-10-28 | Rice | Minnesota | 27131 | 1683 | 10 |
671970 | 671970 | 2020-10-27 | Rice | Minnesota | 27131 | 1674 | 10 |
668728 | 668728 | 2020-10-26 | Rice | Minnesota | 27131 | 1648 | 10 |
665484 | 665484 | 2020-10-25 | Rice | Minnesota | 27131 | 1633 | 10 |
662239 | 662239 | 2020-10-24 | Rice | Minnesota | 27131 | 1628 | 9 |
658995 | 658995 | 2020-10-23 | Rice | Minnesota | 27131 | 1605 | 9 |
655750 | 655750 | 2020-10-22 | Rice | Minnesota | 27131 | 1592 | 9 |
652505 | 652505 | 2020-10-21 | Rice | Minnesota | 27131 | 1586 | 9 |
649260 | 649260 | 2020-10-20 | Rice | Minnesota | 27131 | 1581 | 9 |
646016 | 646016 | 2020-10-19 | Rice | Minnesota | 27131 | 1578 | 9 |
642769 | 642769 | 2020-10-18 | Rice | Minnesota | 27131 | 1562 | 9 |
639522 | 639522 | 2020-10-17 | Rice | Minnesota | 27131 | 1555 | 8 |
636276 | 636276 | 2020-10-16 | Rice | Minnesota | 27131 | 1522 | 8 |
633030 | 633030 | 2020-10-15 | Rice | Minnesota | 27131 | 1508 | 8 |
629785 | 629785 | 2020-10-14 | Rice | Minnesota | 27131 | 1506 | 8 |
626541 | 626541 | 2020-10-13 | Rice | Minnesota | 27131 | 1498 | 8 |
623299 | 623299 | 2020-10-12 | Rice | Minnesota | 27131 | 1492 | 8 |
620056 | 620056 | 2020-10-11 | Rice | Minnesota | 27131 | 1479 | 8 |
616814 | 616814 | 2020-10-10 | Rice | Minnesota | 27131 | 1468 | 8 |
613573 | 613573 | 2020-10-09 | Rice | Minnesota | 27131 | 1454 | 8 |
610331 | 610331 | 2020-10-08 | Rice | Minnesota | 27131 | 1428 | 8 |
607089 | 607089 | 2020-10-07 | Rice | Minnesota | 27131 | 1419 | 8 |
603846 | 603846 | 2020-10-06 | Rice | Minnesota | 27131 | 1406 | 8 |
600604 | 600604 | 2020-10-05 | Rice | Minnesota | 27131 | 1398 | 8 |
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);