ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
63 rows where deaths = 15, fips = 27089 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1103562 | 1103562 | 2021-03-09 | Marshall | Minnesota | 27089 | 788 | 15 |
1100316 | 1100316 | 2021-03-08 | Marshall | Minnesota | 27089 | 787 | 15 |
1097069 | 1097069 | 2021-03-07 | Marshall | Minnesota | 27089 | 787 | 15 |
1093822 | 1093822 | 2021-03-06 | Marshall | Minnesota | 27089 | 786 | 15 |
1090576 | 1090576 | 2021-03-05 | Marshall | Minnesota | 27089 | 784 | 15 |
1087331 | 1087331 | 2021-03-04 | Marshall | Minnesota | 27089 | 780 | 15 |
1084086 | 1084086 | 2021-03-03 | Marshall | Minnesota | 27089 | 780 | 15 |
1080840 | 1080840 | 2021-03-02 | Marshall | Minnesota | 27089 | 778 | 15 |
1077594 | 1077594 | 2021-03-01 | Marshall | Minnesota | 27089 | 778 | 15 |
1074348 | 1074348 | 2021-02-28 | Marshall | Minnesota | 27089 | 778 | 15 |
1071102 | 1071102 | 2021-02-27 | Marshall | Minnesota | 27089 | 776 | 15 |
1067857 | 1067857 | 2021-02-26 | Marshall | Minnesota | 27089 | 774 | 15 |
1064612 | 1064612 | 2021-02-25 | Marshall | Minnesota | 27089 | 770 | 15 |
1061368 | 1061368 | 2021-02-24 | Marshall | Minnesota | 27089 | 768 | 15 |
1058122 | 1058122 | 2021-02-23 | Marshall | Minnesota | 27089 | 766 | 15 |
1054876 | 1054876 | 2021-02-22 | Marshall | Minnesota | 27089 | 764 | 15 |
1051629 | 1051629 | 2021-02-21 | Marshall | Minnesota | 27089 | 764 | 15 |
1048382 | 1048382 | 2021-02-20 | Marshall | Minnesota | 27089 | 761 | 15 |
1045136 | 1045136 | 2021-02-19 | Marshall | Minnesota | 27089 | 758 | 15 |
1041891 | 1041891 | 2021-02-18 | Marshall | Minnesota | 27089 | 756 | 15 |
1038646 | 1038646 | 2021-02-17 | Marshall | Minnesota | 27089 | 754 | 15 |
1035401 | 1035401 | 2021-02-16 | Marshall | Minnesota | 27089 | 748 | 15 |
1032156 | 1032156 | 2021-02-15 | Marshall | Minnesota | 27089 | 746 | 15 |
1028909 | 1028909 | 2021-02-14 | Marshall | Minnesota | 27089 | 741 | 15 |
1025663 | 1025663 | 2021-02-13 | Marshall | Minnesota | 27089 | 735 | 15 |
1022418 | 1022418 | 2021-02-12 | Marshall | Minnesota | 27089 | 731 | 15 |
1019173 | 1019173 | 2021-02-11 | Marshall | Minnesota | 27089 | 729 | 15 |
1015928 | 1015928 | 2021-02-10 | Marshall | Minnesota | 27089 | 726 | 15 |
1012683 | 1012683 | 2021-02-09 | Marshall | Minnesota | 27089 | 723 | 15 |
1009438 | 1009438 | 2021-02-08 | Marshall | Minnesota | 27089 | 720 | 15 |
1006191 | 1006191 | 2021-02-07 | Marshall | Minnesota | 27089 | 718 | 15 |
1002945 | 1002945 | 2021-02-06 | Marshall | Minnesota | 27089 | 715 | 15 |
999700 | 999700 | 2021-02-05 | Marshall | Minnesota | 27089 | 711 | 15 |
996454 | 996454 | 2021-02-04 | Marshall | Minnesota | 27089 | 709 | 15 |
993208 | 993208 | 2021-02-03 | Marshall | Minnesota | 27089 | 708 | 15 |
989962 | 989962 | 2021-02-02 | Marshall | Minnesota | 27089 | 709 | 15 |
986715 | 986715 | 2021-02-01 | Marshall | Minnesota | 27089 | 709 | 15 |
983468 | 983468 | 2021-01-31 | Marshall | Minnesota | 27089 | 708 | 15 |
980222 | 980222 | 2021-01-30 | Marshall | Minnesota | 27089 | 708 | 15 |
976976 | 976976 | 2021-01-29 | Marshall | Minnesota | 27089 | 705 | 15 |
973731 | 973731 | 2021-01-28 | Marshall | Minnesota | 27089 | 705 | 15 |
970486 | 970486 | 2021-01-27 | Marshall | Minnesota | 27089 | 704 | 15 |
967241 | 967241 | 2021-01-26 | Marshall | Minnesota | 27089 | 703 | 15 |
963997 | 963997 | 2021-01-25 | Marshall | Minnesota | 27089 | 704 | 15 |
960752 | 960752 | 2021-01-24 | Marshall | Minnesota | 27089 | 703 | 15 |
957506 | 957506 | 2021-01-23 | Marshall | Minnesota | 27089 | 703 | 15 |
954261 | 954261 | 2021-01-22 | Marshall | Minnesota | 27089 | 703 | 15 |
951016 | 951016 | 2021-01-21 | Marshall | Minnesota | 27089 | 703 | 15 |
947770 | 947770 | 2021-01-20 | Marshall | Minnesota | 27089 | 703 | 15 |
944523 | 944523 | 2021-01-19 | Marshall | Minnesota | 27089 | 702 | 15 |
941278 | 941278 | 2021-01-18 | Marshall | Minnesota | 27089 | 703 | 15 |
938033 | 938033 | 2021-01-17 | Marshall | Minnesota | 27089 | 703 | 15 |
934788 | 934788 | 2021-01-16 | Marshall | Minnesota | 27089 | 701 | 15 |
931543 | 931543 | 2021-01-15 | Marshall | Minnesota | 27089 | 701 | 15 |
928298 | 928298 | 2021-01-14 | Marshall | Minnesota | 27089 | 701 | 15 |
925052 | 925052 | 2021-01-13 | Marshall | Minnesota | 27089 | 698 | 15 |
921807 | 921807 | 2021-01-12 | Marshall | Minnesota | 27089 | 696 | 15 |
918562 | 918562 | 2021-01-11 | Marshall | Minnesota | 27089 | 696 | 15 |
915317 | 915317 | 2021-01-10 | Marshall | Minnesota | 27089 | 695 | 15 |
912072 | 912072 | 2021-01-09 | Marshall | Minnesota | 27089 | 695 | 15 |
908827 | 908827 | 2021-01-08 | Marshall | Minnesota | 27089 | 692 | 15 |
905581 | 905581 | 2021-01-07 | Marshall | Minnesota | 27089 | 689 | 15 |
902336 | 902336 | 2021-01-06 | Marshall | Minnesota | 27089 | 687 | 15 |
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);