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-24 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 |
---|---|---|---|---|---|---|---|
10101 | 10101 | 2020-03-24 | Anoka | Minnesota | 27003 | 7 | 0 |
10102 | 10102 | 2020-03-24 | Benton | Minnesota | 27009 | 1 | 0 |
10103 | 10103 | 2020-03-24 | Big Stone | Minnesota | 27011 | 1 | 0 |
10104 | 10104 | 2020-03-24 | Blue Earth | Minnesota | 27013 | 5 | 0 |
10105 | 10105 | 2020-03-24 | Carver | Minnesota | 27019 | 8 | 0 |
10106 | 10106 | 2020-03-24 | Cass | Minnesota | 27021 | 1 | 0 |
10107 | 10107 | 2020-03-24 | Chisago | Minnesota | 27025 | 2 | 0 |
10108 | 10108 | 2020-03-24 | Clay | Minnesota | 27027 | 3 | 0 |
10109 | 10109 | 2020-03-24 | Dakota | Minnesota | 27037 | 21 | 0 |
10110 | 10110 | 2020-03-24 | Dodge | Minnesota | 27039 | 3 | 0 |
10111 | 10111 | 2020-03-24 | Fillmore | Minnesota | 27045 | 3 | 0 |
10112 | 10112 | 2020-03-24 | Hennepin | Minnesota | 27053 | 103 | 0 |
10113 | 10113 | 2020-03-24 | Jackson | Minnesota | 27063 | 1 | 0 |
10114 | 10114 | 2020-03-24 | Lac qui Parle | Minnesota | 27073 | 1 | 0 |
10115 | 10115 | 2020-03-24 | Le Sueur | Minnesota | 27079 | 5 | 0 |
10116 | 10116 | 2020-03-24 | Martin | Minnesota | 27091 | 8 | 0 |
10117 | 10117 | 2020-03-24 | Mower | Minnesota | 27099 | 6 | 0 |
10118 | 10118 | 2020-03-24 | Nicollet | Minnesota | 27103 | 3 | 0 |
10119 | 10119 | 2020-03-24 | Olmsted | Minnesota | 27109 | 18 | 0 |
10120 | 10120 | 2020-03-24 | Ramsey | Minnesota | 27123 | 26 | 1 |
10121 | 10121 | 2020-03-24 | Renville | Minnesota | 27129 | 1 | 0 |
10122 | 10122 | 2020-03-24 | Rice | Minnesota | 27131 | 2 | 0 |
10123 | 10123 | 2020-03-24 | Scott | Minnesota | 27139 | 5 | 0 |
10124 | 10124 | 2020-03-24 | Sherburne | Minnesota | 27141 | 1 | 0 |
10125 | 10125 | 2020-03-24 | St. Louis | Minnesota | 27137 | 2 | 0 |
10126 | 10126 | 2020-03-24 | Stearns | Minnesota | 27145 | 5 | 0 |
10127 | 10127 | 2020-03-24 | Steele | Minnesota | 27147 | 5 | 0 |
10128 | 10128 | 2020-03-24 | Unknown | Minnesota | 1 | 0 | |
10129 | 10129 | 2020-03-24 | Wabasha | Minnesota | 27157 | 1 | 0 |
10130 | 10130 | 2020-03-24 | Waseca | Minnesota | 27161 | 2 | 0 |
10131 | 10131 | 2020-03-24 | Washington | Minnesota | 27163 | 10 | 0 |
10132 | 10132 | 2020-03-24 | 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);