ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67,883 rows where state = "Minnesota" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 27103 786
- 27109 786
- 27123 786
- 27129 786
- 27131 786
- 27139 786
- 27145 786
- 27161 786
- 27163 786
- 27171 786
- 27003 785
- 27009 785
- 27013 785
- 27019 785
- 27025 785
- 27027 785
- 27037 785
- 27045 785
- 27053 785
- 27091 785
- 27099 785
- 27039 784
- 27063 784
- 27137 784
- 27147 784
- 27157 784
- 27079 783
- 27011 782
- 27021 782
- 27073 782
- …
county >30
- Nicollet 786
- Olmsted 786
- Ramsey 786
- Renville 786
- Rice 786
- Scott 786
- Stearns 786
- Waseca 786
- Washington 786
- Wright 786
- Anoka 785
- Benton 785
- Blue Earth 785
- Carver 785
- Chisago 785
- Clay 785
- Dakota 785
- Fillmore 785
- Hennepin 785
- Martin 785
- Mower 785
- Dodge 784
- Jackson 784
- St. Louis 784
- Steele 784
- Wabasha 784
- Le Sueur 783
- Big Stone 782
- Cass 782
- Lac qui Parle 782
- …
state 1
- Minnesota · 67,783 ✖
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4770 | 4770 | 2020-03-19 | Nicollet | Minnesota | 27103 | 2 | 0 |
4771 | 4771 | 2020-03-19 | Olmsted | Minnesota | 27109 | 6 | 0 |
4772 | 4772 | 2020-03-19 | Ramsey | Minnesota | 27123 | 12 | 0 |
4773 | 4773 | 2020-03-19 | Renville | Minnesota | 27129 | 1 | 0 |
4774 | 4774 | 2020-03-19 | Rice | Minnesota | 27131 | 1 | 0 |
4775 | 4775 | 2020-03-19 | Scott | Minnesota | 27139 | 1 | 0 |
4776 | 4776 | 2020-03-19 | Stearns | Minnesota | 27145 | 4 | 0 |
4777 | 4777 | 2020-03-19 | Waseca | Minnesota | 27161 | 2 | 0 |
4778 | 4778 | 2020-03-19 | Washington | Minnesota | 27163 | 3 | 0 |
4779 | 4779 | 2020-03-19 | Wright | Minnesota | 27171 | 2 | 0 |
5581 | 5581 | 2020-03-20 | Anoka | Minnesota | 27003 | 5 | 0 |
5582 | 5582 | 2020-03-20 | Benton | Minnesota | 27009 | 1 | 0 |
5583 | 5583 | 2020-03-20 | Blue Earth | Minnesota | 27013 | 2 | 0 |
5584 | 5584 | 2020-03-20 | Carver | Minnesota | 27019 | 3 | 0 |
5585 | 5585 | 2020-03-20 | Chisago | Minnesota | 27025 | 1 | 0 |
5586 | 5586 | 2020-03-20 | Clay | Minnesota | 27027 | 1 | 0 |
5587 | 5587 | 2020-03-20 | Dakota | Minnesota | 27037 | 7 | 0 |
5588 | 5588 | 2020-03-20 | Fillmore | Minnesota | 27045 | 2 | 0 |
5589 | 5589 | 2020-03-20 | Hennepin | Minnesota | 27053 | 44 | 0 |
5590 | 5590 | 2020-03-20 | Martin | Minnesota | 27091 | 4 | 0 |
5591 | 5591 | 2020-03-20 | Mower | Minnesota | 27099 | 1 | 0 |
5592 | 5592 | 2020-03-20 | Nicollet | Minnesota | 27103 | 2 | 0 |
5593 | 5593 | 2020-03-20 | Olmsted | Minnesota | 27109 | 11 | 0 |
5594 | 5594 | 2020-03-20 | Ramsey | Minnesota | 27123 | 16 | 0 |
5595 | 5595 | 2020-03-20 | Renville | Minnesota | 27129 | 1 | 0 |
5596 | 5596 | 2020-03-20 | Rice | Minnesota | 27131 | 1 | 0 |
5597 | 5597 | 2020-03-20 | Scott | Minnesota | 27139 | 2 | 0 |
5598 | 5598 | 2020-03-20 | Stearns | Minnesota | 27145 | 4 | 0 |
5599 | 5599 | 2020-03-20 | Waseca | Minnesota | 27161 | 2 | 0 |
5600 | 5600 | 2020-03-20 | Washington | Minnesota | 27163 | 3 | 0 |
5601 | 5601 | 2020-03-20 | Wright | Minnesota | 27171 | 2 | 0 |
6549 | 6549 | 2020-03-21 | Anoka | Minnesota | 27003 | 5 | 0 |
6550 | 6550 | 2020-03-21 | Benton | Minnesota | 27009 | 1 | 0 |
6551 | 6551 | 2020-03-21 | Blue Earth | Minnesota | 27013 | 3 | 0 |
6552 | 6552 | 2020-03-21 | Carver | Minnesota | 27019 | 3 | 0 |
6553 | 6553 | 2020-03-21 | Chisago | Minnesota | 27025 | 1 | 0 |
6554 | 6554 | 2020-03-21 | Clay | Minnesota | 27027 | 1 | 0 |
6555 | 6555 | 2020-03-21 | Dakota | Minnesota | 27037 | 7 | 0 |
6556 | 6556 | 2020-03-21 | Dodge | Minnesota | 27039 | 1 | 0 |
6557 | 6557 | 2020-03-21 | Fillmore | Minnesota | 27045 | 2 | 0 |
6558 | 6558 | 2020-03-21 | Hennepin | Minnesota | 27053 | 52 | 0 |
6559 | 6559 | 2020-03-21 | Jackson | Minnesota | 27063 | 1 | 0 |
6560 | 6560 | 2020-03-21 | Martin | Minnesota | 27091 | 5 | 0 |
6561 | 6561 | 2020-03-21 | Mower | Minnesota | 27099 | 3 | 0 |
6562 | 6562 | 2020-03-21 | Nicollet | Minnesota | 27103 | 2 | 0 |
6563 | 6563 | 2020-03-21 | Olmsted | Minnesota | 27109 | 12 | 0 |
6564 | 6564 | 2020-03-21 | Ramsey | Minnesota | 27123 | 17 | 1 |
6565 | 6565 | 2020-03-21 | Renville | Minnesota | 27129 | 1 | 0 |
6566 | 6566 | 2020-03-21 | Rice | Minnesota | 27131 | 1 | 0 |
6567 | 6567 | 2020-03-21 | Scott | Minnesota | 27139 | 2 | 0 |
6568 | 6568 | 2020-03-21 | St. Louis | Minnesota | 27137 | 1 | 0 |
6569 | 6569 | 2020-03-21 | Stearns | Minnesota | 27145 | 4 | 0 |
6570 | 6570 | 2020-03-21 | Steele | Minnesota | 27147 | 2 | 0 |
6571 | 6571 | 2020-03-21 | Unknown | Minnesota | 1 | 0 | |
6572 | 6572 | 2020-03-21 | Wabasha | Minnesota | 27157 | 1 | 0 |
6573 | 6573 | 2020-03-21 | Waseca | Minnesota | 27161 | 2 | 0 |
6574 | 6574 | 2020-03-21 | Washington | Minnesota | 27163 | 4 | 0 |
6575 | 6575 | 2020-03-21 | Wright | Minnesota | 27171 | 3 | 0 |
7630 | 7630 | 2020-03-22 | Anoka | Minnesota | 27003 | 5 | 0 |
7631 | 7631 | 2020-03-22 | Benton | Minnesota | 27009 | 1 | 0 |
7632 | 7632 | 2020-03-22 | Blue Earth | Minnesota | 27013 | 4 | 0 |
7633 | 7633 | 2020-03-22 | Carver | Minnesota | 27019 | 8 | 0 |
7634 | 7634 | 2020-03-22 | Chisago | Minnesota | 27025 | 1 | 0 |
7635 | 7635 | 2020-03-22 | Clay | Minnesota | 27027 | 2 | 0 |
7636 | 7636 | 2020-03-22 | Dakota | Minnesota | 27037 | 11 | 0 |
7637 | 7637 | 2020-03-22 | Dodge | Minnesota | 27039 | 2 | 0 |
7638 | 7638 | 2020-03-22 | Fillmore | Minnesota | 27045 | 2 | 0 |
7639 | 7639 | 2020-03-22 | Hennepin | Minnesota | 27053 | 57 | 0 |
7640 | 7640 | 2020-03-22 | Jackson | Minnesota | 27063 | 1 | 0 |
7641 | 7641 | 2020-03-22 | Le Sueur | Minnesota | 27079 | 1 | 0 |
7642 | 7642 | 2020-03-22 | Martin | Minnesota | 27091 | 8 | 0 |
7643 | 7643 | 2020-03-22 | Mower | Minnesota | 27099 | 6 | 0 |
7644 | 7644 | 2020-03-22 | Nicollet | Minnesota | 27103 | 3 | 0 |
7645 | 7645 | 2020-03-22 | Olmsted | Minnesota | 27109 | 14 | 0 |
7646 | 7646 | 2020-03-22 | Ramsey | Minnesota | 27123 | 18 | 1 |
7647 | 7647 | 2020-03-22 | Renville | Minnesota | 27129 | 1 | 0 |
7648 | 7648 | 2020-03-22 | Rice | Minnesota | 27131 | 1 | 0 |
7649 | 7649 | 2020-03-22 | Scott | Minnesota | 27139 | 3 | 0 |
7650 | 7650 | 2020-03-22 | St. Louis | Minnesota | 27137 | 1 | 0 |
7651 | 7651 | 2020-03-22 | Stearns | Minnesota | 27145 | 4 | 0 |
7652 | 7652 | 2020-03-22 | Steele | Minnesota | 27147 | 3 | 0 |
7653 | 7653 | 2020-03-22 | Unknown | Minnesota | 1 | 0 | |
7654 | 7654 | 2020-03-22 | Wabasha | Minnesota | 27157 | 1 | 0 |
7655 | 7655 | 2020-03-22 | Waseca | Minnesota | 27161 | 2 | 0 |
7656 | 7656 | 2020-03-22 | Washington | Minnesota | 27163 | 7 | 0 |
7657 | 7657 | 2020-03-22 | Wright | Minnesota | 27171 | 3 | 0 |
8806 | 8806 | 2020-03-23 | Anoka | Minnesota | 27003 | 7 | 0 |
8807 | 8807 | 2020-03-23 | Benton | Minnesota | 27009 | 1 | 0 |
8808 | 8808 | 2020-03-23 | Big Stone | Minnesota | 27011 | 1 | 0 |
8809 | 8809 | 2020-03-23 | Blue Earth | Minnesota | 27013 | 5 | 0 |
8810 | 8810 | 2020-03-23 | Carver | Minnesota | 27019 | 8 | 0 |
8811 | 8811 | 2020-03-23 | Cass | Minnesota | 27021 | 1 | 0 |
8812 | 8812 | 2020-03-23 | Chisago | Minnesota | 27025 | 2 | 0 |
8813 | 8813 | 2020-03-23 | Clay | Minnesota | 27027 | 2 | 0 |
8814 | 8814 | 2020-03-23 | Dakota | Minnesota | 27037 | 18 | 0 |
8815 | 8815 | 2020-03-23 | Dodge | Minnesota | 27039 | 2 | 0 |
8816 | 8816 | 2020-03-23 | Fillmore | Minnesota | 27045 | 3 | 0 |
8817 | 8817 | 2020-03-23 | Hennepin | Minnesota | 27053 | 89 | 0 |
8818 | 8818 | 2020-03-23 | Jackson | Minnesota | 27063 | 1 | 0 |
8819 | 8819 | 2020-03-23 | Lac qui Parle | Minnesota | 27073 | 1 | 0 |
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);