ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Steele" and state = "Minnesota" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-21 1
- 2020-03-22 1
- 2020-03-23 1
- 2020-03-24 1
- 2020-03-25 1
- 2020-03-26 1
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- …
state 1
- Minnesota · 784 ✖
fips 1
- 27147 784
county 1
- Steele · 784 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
6570 | 6570 | 2020-03-21 | Steele | Minnesota | 27147 | 2 | 0 |
7652 | 7652 | 2020-03-22 | Steele | Minnesota | 27147 | 3 | 0 |
8832 | 8832 | 2020-03-23 | Steele | Minnesota | 27147 | 3 | 0 |
10127 | 10127 | 2020-03-24 | Steele | Minnesota | 27147 | 5 | 0 |
11545 | 11545 | 2020-03-25 | Steele | Minnesota | 27147 | 5 | 0 |
13135 | 13135 | 2020-03-26 | Steele | Minnesota | 27147 | 5 | 0 |
14851 | 14851 | 2020-03-27 | Steele | Minnesota | 27147 | 5 | 0 |
16673 | 16673 | 2020-03-28 | Steele | Minnesota | 27147 | 5 | 0 |
18593 | 18593 | 2020-03-29 | Steele | Minnesota | 27147 | 5 | 0 |
20615 | 20615 | 2020-03-30 | Steele | Minnesota | 27147 | 6 | 0 |
22730 | 22730 | 2020-03-31 | Steele | Minnesota | 27147 | 6 | 0 |
24912 | 24912 | 2020-04-01 | Steele | Minnesota | 27147 | 6 | 0 |
27166 | 27166 | 2020-04-02 | Steele | Minnesota | 27147 | 6 | 0 |
29485 | 29485 | 2020-04-03 | Steele | Minnesota | 27147 | 6 | 0 |
31865 | 31865 | 2020-04-04 | Steele | Minnesota | 27147 | 8 | 0 |
34292 | 34292 | 2020-04-05 | Steele | Minnesota | 27147 | 8 | 0 |
36754 | 36754 | 2020-04-06 | Steele | Minnesota | 27147 | 8 | 0 |
39264 | 39264 | 2020-04-07 | Steele | Minnesota | 27147 | 8 | 0 |
41818 | 41818 | 2020-04-08 | Steele | Minnesota | 27147 | 8 | 0 |
44394 | 44394 | 2020-04-09 | Steele | Minnesota | 27147 | 8 | 0 |
47004 | 47004 | 2020-04-10 | Steele | Minnesota | 27147 | 9 | 0 |
49649 | 49649 | 2020-04-11 | Steele | Minnesota | 27147 | 9 | 0 |
52321 | 52321 | 2020-04-12 | Steele | Minnesota | 27147 | 9 | 0 |
55003 | 55003 | 2020-04-13 | Steele | Minnesota | 27147 | 9 | 0 |
57701 | 57701 | 2020-04-14 | Steele | Minnesota | 27147 | 9 | 0 |
60412 | 60412 | 2020-04-15 | Steele | Minnesota | 27147 | 9 | 0 |
63135 | 63135 | 2020-04-16 | Steele | Minnesota | 27147 | 9 | 0 |
65874 | 65874 | 2020-04-17 | Steele | Minnesota | 27147 | 9 | 0 |
68626 | 68626 | 2020-04-18 | Steele | Minnesota | 27147 | 9 | 0 |
71392 | 71392 | 2020-04-19 | Steele | Minnesota | 27147 | 9 | 0 |
74165 | 74165 | 2020-04-20 | Steele | Minnesota | 27147 | 9 | 0 |
76946 | 76946 | 2020-04-21 | Steele | Minnesota | 27147 | 9 | 0 |
79731 | 79731 | 2020-04-22 | Steele | Minnesota | 27147 | 10 | 0 |
82527 | 82527 | 2020-04-23 | Steele | Minnesota | 27147 | 10 | 0 |
85331 | 85331 | 2020-04-24 | Steele | Minnesota | 27147 | 11 | 0 |
88141 | 88141 | 2020-04-25 | Steele | Minnesota | 27147 | 12 | 0 |
90957 | 90957 | 2020-04-26 | Steele | Minnesota | 27147 | 12 | 0 |
93778 | 93778 | 2020-04-27 | Steele | Minnesota | 27147 | 14 | 0 |
96613 | 96613 | 2020-04-28 | Steele | Minnesota | 27147 | 14 | 0 |
99459 | 99459 | 2020-04-29 | Steele | Minnesota | 27147 | 15 | 0 |
102311 | 102311 | 2020-04-30 | Steele | Minnesota | 27147 | 16 | 0 |
105172 | 105172 | 2020-05-01 | Steele | Minnesota | 27147 | 18 | 0 |
108037 | 108037 | 2020-05-02 | Steele | Minnesota | 27147 | 20 | 0 |
110908 | 110908 | 2020-05-03 | Steele | Minnesota | 27147 | 21 | 0 |
113787 | 113787 | 2020-05-04 | Steele | Minnesota | 27147 | 24 | 0 |
116669 | 116669 | 2020-05-05 | Steele | Minnesota | 27147 | 25 | 0 |
119629 | 119629 | 2020-05-06 | Steele | Minnesota | 27147 | 29 | 0 |
122603 | 122603 | 2020-05-07 | Steele | Minnesota | 27147 | 37 | 0 |
125585 | 125585 | 2020-05-08 | Steele | Minnesota | 27147 | 45 | 0 |
128572 | 128572 | 2020-05-09 | Steele | Minnesota | 27147 | 58 | 0 |
131562 | 131562 | 2020-05-10 | Steele | Minnesota | 27147 | 60 | 0 |
134553 | 134553 | 2020-05-11 | Steele | Minnesota | 27147 | 65 | 0 |
137543 | 137543 | 2020-05-12 | Steele | Minnesota | 27147 | 73 | 0 |
140537 | 140537 | 2020-05-13 | Steele | Minnesota | 27147 | 73 | 0 |
143532 | 143532 | 2020-05-14 | Steele | Minnesota | 27147 | 85 | 0 |
146532 | 146532 | 2020-05-15 | Steele | Minnesota | 27147 | 92 | 0 |
149537 | 149537 | 2020-05-16 | Steele | Minnesota | 27147 | 100 | 0 |
152548 | 152548 | 2020-05-17 | Steele | Minnesota | 27147 | 105 | 0 |
155562 | 155562 | 2020-05-18 | Steele | Minnesota | 27147 | 111 | 0 |
158580 | 158580 | 2020-05-19 | Steele | Minnesota | 27147 | 115 | 0 |
161606 | 161606 | 2020-05-20 | Steele | Minnesota | 27147 | 116 | 0 |
164635 | 164635 | 2020-05-21 | Steele | Minnesota | 27147 | 122 | 0 |
167671 | 167671 | 2020-05-22 | Steele | Minnesota | 27147 | 134 | 0 |
170709 | 170709 | 2020-05-23 | Steele | Minnesota | 27147 | 138 | 0 |
173751 | 173751 | 2020-05-24 | Steele | Minnesota | 27147 | 140 | 0 |
176794 | 176794 | 2020-05-25 | Steele | Minnesota | 27147 | 141 | 0 |
179838 | 179838 | 2020-05-26 | Steele | Minnesota | 27147 | 144 | 0 |
182884 | 182884 | 2020-05-27 | Steele | Minnesota | 27147 | 148 | 0 |
185939 | 185939 | 2020-05-28 | Steele | Minnesota | 27147 | 149 | 0 |
188997 | 188997 | 2020-05-29 | Steele | Minnesota | 27147 | 151 | 0 |
192061 | 192061 | 2020-05-30 | Steele | Minnesota | 27147 | 159 | 0 |
195129 | 195129 | 2020-05-31 | Steele | Minnesota | 27147 | 158 | 0 |
198200 | 198200 | 2020-06-01 | Steele | Minnesota | 27147 | 160 | 0 |
201273 | 201273 | 2020-06-02 | Steele | Minnesota | 27147 | 164 | 0 |
204350 | 204350 | 2020-06-03 | Steele | Minnesota | 27147 | 167 | 0 |
207431 | 207431 | 2020-06-04 | Steele | Minnesota | 27147 | 167 | 0 |
210512 | 210512 | 2020-06-05 | Steele | Minnesota | 27147 | 170 | 0 |
213596 | 213596 | 2020-06-06 | Steele | Minnesota | 27147 | 171 | 0 |
216684 | 216684 | 2020-06-07 | Steele | Minnesota | 27147 | 172 | 0 |
219776 | 219776 | 2020-06-08 | Steele | Minnesota | 27147 | 173 | 0 |
222871 | 222871 | 2020-06-09 | Steele | Minnesota | 27147 | 173 | 0 |
225969 | 225969 | 2020-06-10 | Steele | Minnesota | 27147 | 173 | 0 |
229071 | 229071 | 2020-06-11 | Steele | Minnesota | 27147 | 173 | 0 |
232175 | 232175 | 2020-06-12 | Steele | Minnesota | 27147 | 175 | 0 |
235281 | 235281 | 2020-06-13 | Steele | Minnesota | 27147 | 175 | 0 |
238388 | 238388 | 2020-06-14 | Steele | Minnesota | 27147 | 175 | 0 |
241497 | 241497 | 2020-06-15 | Steele | Minnesota | 27147 | 175 | 0 |
244608 | 244608 | 2020-06-16 | Steele | Minnesota | 27147 | 175 | 0 |
247721 | 247721 | 2020-06-17 | Steele | Minnesota | 27147 | 179 | 0 |
250833 | 250833 | 2020-06-18 | Steele | Minnesota | 27147 | 181 | 0 |
253948 | 253948 | 2020-06-19 | Steele | Minnesota | 27147 | 183 | 0 |
257068 | 257068 | 2020-06-20 | Steele | Minnesota | 27147 | 186 | 0 |
260194 | 260194 | 2020-06-21 | Steele | Minnesota | 27147 | 194 | 0 |
263323 | 263323 | 2020-06-22 | Steele | Minnesota | 27147 | 199 | 0 |
266449 | 266449 | 2020-06-23 | Steele | Minnesota | 27147 | 200 | 0 |
269582 | 269582 | 2020-06-24 | Steele | Minnesota | 27147 | 202 | 0 |
272719 | 272719 | 2020-06-25 | Steele | Minnesota | 27147 | 206 | 0 |
275862 | 275862 | 2020-06-26 | Steele | Minnesota | 27147 | 209 | 0 |
279010 | 279010 | 2020-06-27 | Steele | Minnesota | 27147 | 212 | 0 |
282158 | 282158 | 2020-06-28 | Steele | Minnesota | 27147 | 212 | 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);