ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
60 rows where county = "Lac qui Parle", deaths = 16 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 |
---|---|---|---|---|---|---|---|
1100309 | 1100309 | 2021-03-08 | Lac qui Parle | Minnesota | 27073 | 688 | 16 |
1097062 | 1097062 | 2021-03-07 | Lac qui Parle | Minnesota | 27073 | 688 | 16 |
1093815 | 1093815 | 2021-03-06 | Lac qui Parle | Minnesota | 27073 | 687 | 16 |
1090569 | 1090569 | 2021-03-05 | Lac qui Parle | Minnesota | 27073 | 686 | 16 |
1087324 | 1087324 | 2021-03-04 | Lac qui Parle | Minnesota | 27073 | 686 | 16 |
1084079 | 1084079 | 2021-03-03 | Lac qui Parle | Minnesota | 27073 | 685 | 16 |
1080833 | 1080833 | 2021-03-02 | Lac qui Parle | Minnesota | 27073 | 684 | 16 |
1077587 | 1077587 | 2021-03-01 | Lac qui Parle | Minnesota | 27073 | 683 | 16 |
1074341 | 1074341 | 2021-02-28 | Lac qui Parle | Minnesota | 27073 | 683 | 16 |
1071095 | 1071095 | 2021-02-27 | Lac qui Parle | Minnesota | 27073 | 682 | 16 |
1067850 | 1067850 | 2021-02-26 | Lac qui Parle | Minnesota | 27073 | 682 | 16 |
1064605 | 1064605 | 2021-02-25 | Lac qui Parle | Minnesota | 27073 | 682 | 16 |
1061361 | 1061361 | 2021-02-24 | Lac qui Parle | Minnesota | 27073 | 682 | 16 |
1058115 | 1058115 | 2021-02-23 | Lac qui Parle | Minnesota | 27073 | 679 | 16 |
1054869 | 1054869 | 2021-02-22 | Lac qui Parle | Minnesota | 27073 | 679 | 16 |
1051622 | 1051622 | 2021-02-21 | Lac qui Parle | Minnesota | 27073 | 679 | 16 |
1048375 | 1048375 | 2021-02-20 | Lac qui Parle | Minnesota | 27073 | 677 | 16 |
1045129 | 1045129 | 2021-02-19 | Lac qui Parle | Minnesota | 27073 | 676 | 16 |
1041884 | 1041884 | 2021-02-18 | Lac qui Parle | Minnesota | 27073 | 675 | 16 |
1038639 | 1038639 | 2021-02-17 | Lac qui Parle | Minnesota | 27073 | 675 | 16 |
1035394 | 1035394 | 2021-02-16 | Lac qui Parle | Minnesota | 27073 | 674 | 16 |
1032149 | 1032149 | 2021-02-15 | Lac qui Parle | Minnesota | 27073 | 674 | 16 |
1028902 | 1028902 | 2021-02-14 | Lac qui Parle | Minnesota | 27073 | 674 | 16 |
1025656 | 1025656 | 2021-02-13 | Lac qui Parle | Minnesota | 27073 | 674 | 16 |
1022411 | 1022411 | 2021-02-12 | Lac qui Parle | Minnesota | 27073 | 673 | 16 |
1019166 | 1019166 | 2021-02-11 | Lac qui Parle | Minnesota | 27073 | 673 | 16 |
1015921 | 1015921 | 2021-02-10 | Lac qui Parle | Minnesota | 27073 | 672 | 16 |
1012676 | 1012676 | 2021-02-09 | Lac qui Parle | Minnesota | 27073 | 670 | 16 |
1009431 | 1009431 | 2021-02-08 | Lac qui Parle | Minnesota | 27073 | 669 | 16 |
1006184 | 1006184 | 2021-02-07 | Lac qui Parle | Minnesota | 27073 | 669 | 16 |
1002938 | 1002938 | 2021-02-06 | Lac qui Parle | Minnesota | 27073 | 667 | 16 |
999693 | 999693 | 2021-02-05 | Lac qui Parle | Minnesota | 27073 | 667 | 16 |
996447 | 996447 | 2021-02-04 | Lac qui Parle | Minnesota | 27073 | 667 | 16 |
993201 | 993201 | 2021-02-03 | Lac qui Parle | Minnesota | 27073 | 666 | 16 |
989955 | 989955 | 2021-02-02 | Lac qui Parle | Minnesota | 27073 | 665 | 16 |
986708 | 986708 | 2021-02-01 | Lac qui Parle | Minnesota | 27073 | 665 | 16 |
983461 | 983461 | 2021-01-31 | Lac qui Parle | Minnesota | 27073 | 664 | 16 |
980215 | 980215 | 2021-01-30 | Lac qui Parle | Minnesota | 27073 | 664 | 16 |
976969 | 976969 | 2021-01-29 | Lac qui Parle | Minnesota | 27073 | 664 | 16 |
973724 | 973724 | 2021-01-28 | Lac qui Parle | Minnesota | 27073 | 663 | 16 |
970479 | 970479 | 2021-01-27 | Lac qui Parle | Minnesota | 27073 | 662 | 16 |
967234 | 967234 | 2021-01-26 | Lac qui Parle | Minnesota | 27073 | 661 | 16 |
963990 | 963990 | 2021-01-25 | Lac qui Parle | Minnesota | 27073 | 661 | 16 |
960745 | 960745 | 2021-01-24 | Lac qui Parle | Minnesota | 27073 | 661 | 16 |
957499 | 957499 | 2021-01-23 | Lac qui Parle | Minnesota | 27073 | 660 | 16 |
954254 | 954254 | 2021-01-22 | Lac qui Parle | Minnesota | 27073 | 657 | 16 |
951009 | 951009 | 2021-01-21 | Lac qui Parle | Minnesota | 27073 | 657 | 16 |
947763 | 947763 | 2021-01-20 | Lac qui Parle | Minnesota | 27073 | 657 | 16 |
944516 | 944516 | 2021-01-19 | Lac qui Parle | Minnesota | 27073 | 657 | 16 |
941271 | 941271 | 2021-01-18 | Lac qui Parle | Minnesota | 27073 | 657 | 16 |
938026 | 938026 | 2021-01-17 | Lac qui Parle | Minnesota | 27073 | 657 | 16 |
934781 | 934781 | 2021-01-16 | Lac qui Parle | Minnesota | 27073 | 656 | 16 |
931536 | 931536 | 2021-01-15 | Lac qui Parle | Minnesota | 27073 | 654 | 16 |
928291 | 928291 | 2021-01-14 | Lac qui Parle | Minnesota | 27073 | 652 | 16 |
925045 | 925045 | 2021-01-13 | Lac qui Parle | Minnesota | 27073 | 651 | 16 |
921800 | 921800 | 2021-01-12 | Lac qui Parle | Minnesota | 27073 | 648 | 16 |
918555 | 918555 | 2021-01-11 | Lac qui Parle | Minnesota | 27073 | 646 | 16 |
915310 | 915310 | 2021-01-10 | Lac qui Parle | Minnesota | 27073 | 645 | 16 |
912065 | 912065 | 2021-01-09 | Lac qui Parle | Minnesota | 27073 | 645 | 16 |
908820 | 908820 | 2021-01-08 | Lac qui Parle | Minnesota | 27073 | 640 | 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);