ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
32 rows where "date" is on date 2020-03-23 and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips 32
county 32
- Anoka 1
- Benton 1
- Big Stone 1
- Blue Earth 1
- Carver 1
- Cass 1
- Chisago 1
- Clay 1
- Dakota 1
- Dodge 1
- Fillmore 1
- Hennepin 1
- Jackson 1
- Lac qui Parle 1
- Le Sueur 1
- Martin 1
- Mower 1
- Nicollet 1
- Olmsted 1
- Ramsey 1
- Renville 1
- Rice 1
- Scott 1
- Sherburne 1
- St. Louis 1
- Stearns 1
- Steele 1
- Unknown 1
- Wabasha 1
- Waseca 1
- Washington 1
- Wright 1
state 1
- Minnesota · 32 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
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 |
8820 | 8820 | 2020-03-23 | Le Sueur | Minnesota | 27079 | 1 | 0 |
8821 | 8821 | 2020-03-23 | Martin | Minnesota | 27091 | 8 | 0 |
8822 | 8822 | 2020-03-23 | Mower | Minnesota | 27099 | 6 | 0 |
8823 | 8823 | 2020-03-23 | Nicollet | Minnesota | 27103 | 3 | 0 |
8824 | 8824 | 2020-03-23 | Olmsted | Minnesota | 27109 | 16 | 0 |
8825 | 8825 | 2020-03-23 | Ramsey | Minnesota | 27123 | 24 | 1 |
8826 | 8826 | 2020-03-23 | Renville | Minnesota | 27129 | 1 | 0 |
8827 | 8827 | 2020-03-23 | Rice | Minnesota | 27131 | 2 | 0 |
8828 | 8828 | 2020-03-23 | Scott | Minnesota | 27139 | 5 | 0 |
8829 | 8829 | 2020-03-23 | Sherburne | Minnesota | 27141 | 1 | 0 |
8830 | 8830 | 2020-03-23 | St. Louis | Minnesota | 27137 | 2 | 0 |
8831 | 8831 | 2020-03-23 | Stearns | Minnesota | 27145 | 5 | 0 |
8832 | 8832 | 2020-03-23 | Steele | Minnesota | 27147 | 3 | 0 |
8833 | 8833 | 2020-03-23 | Unknown | Minnesota | 1 | 0 | |
8834 | 8834 | 2020-03-23 | Wabasha | Minnesota | 27157 | 1 | 0 |
8835 | 8835 | 2020-03-23 | Waseca | Minnesota | 27161 | 2 | 0 |
8836 | 8836 | 2020-03-23 | Washington | Minnesota | 27163 | 10 | 0 |
8837 | 8837 | 2020-03-23 | Wright | Minnesota | 27171 | 3 | 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);