ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Isanti" and state = "Minnesota" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
18573 | 18573 | 2020-03-29 | Isanti | Minnesota | 27059 | 1 | 0 |
20593 | 20593 | 2020-03-30 | Isanti | Minnesota | 27059 | 2 | 0 |
22707 | 22707 | 2020-03-31 | Isanti | Minnesota | 27059 | 2 | 0 |
24889 | 24889 | 2020-04-01 | Isanti | Minnesota | 27059 | 2 | 0 |
27142 | 27142 | 2020-04-02 | Isanti | Minnesota | 27059 | 2 | 0 |
29461 | 29461 | 2020-04-03 | Isanti | Minnesota | 27059 | 2 | 0 |
31839 | 31839 | 2020-04-04 | Isanti | Minnesota | 27059 | 3 | 0 |
34265 | 34265 | 2020-04-05 | Isanti | Minnesota | 27059 | 4 | 0 |
36725 | 36725 | 2020-04-06 | Isanti | Minnesota | 27059 | 4 | 0 |
39234 | 39234 | 2020-04-07 | Isanti | Minnesota | 27059 | 4 | 0 |
41787 | 41787 | 2020-04-08 | Isanti | Minnesota | 27059 | 4 | 0 |
44363 | 44363 | 2020-04-09 | Isanti | Minnesota | 27059 | 4 | 0 |
46972 | 46972 | 2020-04-10 | Isanti | Minnesota | 27059 | 4 | 0 |
49617 | 49617 | 2020-04-11 | Isanti | Minnesota | 27059 | 4 | 0 |
52287 | 52287 | 2020-04-12 | Isanti | Minnesota | 27059 | 4 | 0 |
54969 | 54969 | 2020-04-13 | Isanti | Minnesota | 27059 | 4 | 0 |
57667 | 57667 | 2020-04-14 | Isanti | Minnesota | 27059 | 4 | 0 |
60377 | 60377 | 2020-04-15 | Isanti | Minnesota | 27059 | 4 | 0 |
63099 | 63099 | 2020-04-16 | Isanti | Minnesota | 27059 | 4 | 0 |
65838 | 65838 | 2020-04-17 | Isanti | Minnesota | 27059 | 4 | 0 |
68589 | 68589 | 2020-04-18 | Isanti | Minnesota | 27059 | 5 | 0 |
71353 | 71353 | 2020-04-19 | Isanti | Minnesota | 27059 | 5 | 0 |
74126 | 74126 | 2020-04-20 | Isanti | Minnesota | 27059 | 6 | 0 |
76906 | 76906 | 2020-04-21 | Isanti | Minnesota | 27059 | 6 | 0 |
79691 | 79691 | 2020-04-22 | Isanti | Minnesota | 27059 | 6 | 0 |
82487 | 82487 | 2020-04-23 | Isanti | Minnesota | 27059 | 6 | 0 |
85291 | 85291 | 2020-04-24 | Isanti | Minnesota | 27059 | 6 | 0 |
88101 | 88101 | 2020-04-25 | Isanti | Minnesota | 27059 | 7 | 0 |
90917 | 90917 | 2020-04-26 | Isanti | Minnesota | 27059 | 6 | 0 |
93738 | 93738 | 2020-04-27 | Isanti | Minnesota | 27059 | 6 | 0 |
96573 | 96573 | 2020-04-28 | Isanti | Minnesota | 27059 | 6 | 0 |
99419 | 99419 | 2020-04-29 | Isanti | Minnesota | 27059 | 6 | 0 |
102271 | 102271 | 2020-04-30 | Isanti | Minnesota | 27059 | 6 | 0 |
105131 | 105131 | 2020-05-01 | Isanti | Minnesota | 27059 | 6 | 0 |
107996 | 107996 | 2020-05-02 | Isanti | Minnesota | 27059 | 6 | 0 |
110867 | 110867 | 2020-05-03 | Isanti | Minnesota | 27059 | 6 | 0 |
113746 | 113746 | 2020-05-04 | Isanti | Minnesota | 27059 | 6 | 0 |
116627 | 116627 | 2020-05-05 | Isanti | Minnesota | 27059 | 6 | 0 |
119587 | 119587 | 2020-05-06 | Isanti | Minnesota | 27059 | 7 | 0 |
122560 | 122560 | 2020-05-07 | Isanti | Minnesota | 27059 | 7 | 0 |
125542 | 125542 | 2020-05-08 | Isanti | Minnesota | 27059 | 7 | 0 |
128529 | 128529 | 2020-05-09 | Isanti | Minnesota | 27059 | 7 | 0 |
131519 | 131519 | 2020-05-10 | Isanti | Minnesota | 27059 | 7 | 0 |
134510 | 134510 | 2020-05-11 | Isanti | Minnesota | 27059 | 8 | 0 |
137500 | 137500 | 2020-05-12 | Isanti | Minnesota | 27059 | 10 | 0 |
140494 | 140494 | 2020-05-13 | Isanti | Minnesota | 27059 | 10 | 0 |
143489 | 143489 | 2020-05-14 | Isanti | Minnesota | 27059 | 11 | 0 |
146489 | 146489 | 2020-05-15 | Isanti | Minnesota | 27059 | 16 | 0 |
149494 | 149494 | 2020-05-16 | Isanti | Minnesota | 27059 | 17 | 0 |
152505 | 152505 | 2020-05-17 | Isanti | Minnesota | 27059 | 20 | 0 |
155519 | 155519 | 2020-05-18 | Isanti | Minnesota | 27059 | 19 | 0 |
158537 | 158537 | 2020-05-19 | Isanti | Minnesota | 27059 | 19 | 0 |
161563 | 161563 | 2020-05-20 | Isanti | Minnesota | 27059 | 20 | 0 |
164592 | 164592 | 2020-05-21 | Isanti | Minnesota | 27059 | 20 | 0 |
167628 | 167628 | 2020-05-22 | Isanti | Minnesota | 27059 | 21 | 0 |
170666 | 170666 | 2020-05-23 | Isanti | Minnesota | 27059 | 24 | 0 |
173708 | 173708 | 2020-05-24 | Isanti | Minnesota | 27059 | 25 | 0 |
176751 | 176751 | 2020-05-25 | Isanti | Minnesota | 27059 | 28 | 0 |
179795 | 179795 | 2020-05-26 | Isanti | Minnesota | 27059 | 30 | 0 |
182841 | 182841 | 2020-05-27 | Isanti | Minnesota | 27059 | 33 | 0 |
185896 | 185896 | 2020-05-28 | Isanti | Minnesota | 27059 | 32 | 0 |
188954 | 188954 | 2020-05-29 | Isanti | Minnesota | 27059 | 32 | 0 |
192018 | 192018 | 2020-05-30 | Isanti | Minnesota | 27059 | 32 | 0 |
195086 | 195086 | 2020-05-31 | Isanti | Minnesota | 27059 | 35 | 0 |
198157 | 198157 | 2020-06-01 | Isanti | Minnesota | 27059 | 35 | 0 |
201230 | 201230 | 2020-06-02 | Isanti | Minnesota | 27059 | 35 | 0 |
204307 | 204307 | 2020-06-03 | Isanti | Minnesota | 27059 | 35 | 0 |
207388 | 207388 | 2020-06-04 | Isanti | Minnesota | 27059 | 36 | 0 |
210469 | 210469 | 2020-06-05 | Isanti | Minnesota | 27059 | 36 | 0 |
213553 | 213553 | 2020-06-06 | Isanti | Minnesota | 27059 | 37 | 0 |
216641 | 216641 | 2020-06-07 | Isanti | Minnesota | 27059 | 39 | 0 |
219733 | 219733 | 2020-06-08 | Isanti | Minnesota | 27059 | 41 | 0 |
222828 | 222828 | 2020-06-09 | Isanti | Minnesota | 27059 | 43 | 0 |
225926 | 225926 | 2020-06-10 | Isanti | Minnesota | 27059 | 44 | 0 |
229028 | 229028 | 2020-06-11 | Isanti | Minnesota | 27059 | 48 | 0 |
232132 | 232132 | 2020-06-12 | Isanti | Minnesota | 27059 | 48 | 0 |
235238 | 235238 | 2020-06-13 | Isanti | Minnesota | 27059 | 49 | 0 |
238345 | 238345 | 2020-06-14 | Isanti | Minnesota | 27059 | 49 | 0 |
241454 | 241454 | 2020-06-15 | Isanti | Minnesota | 27059 | 50 | 0 |
244565 | 244565 | 2020-06-16 | Isanti | Minnesota | 27059 | 50 | 0 |
247678 | 247678 | 2020-06-17 | Isanti | Minnesota | 27059 | 50 | 0 |
250790 | 250790 | 2020-06-18 | Isanti | Minnesota | 27059 | 51 | 0 |
253905 | 253905 | 2020-06-19 | Isanti | Minnesota | 27059 | 52 | 0 |
257025 | 257025 | 2020-06-20 | Isanti | Minnesota | 27059 | 53 | 0 |
260151 | 260151 | 2020-06-21 | Isanti | Minnesota | 27059 | 55 | 0 |
263280 | 263280 | 2020-06-22 | Isanti | Minnesota | 27059 | 56 | 0 |
266406 | 266406 | 2020-06-23 | Isanti | Minnesota | 27059 | 56 | 0 |
269539 | 269539 | 2020-06-24 | Isanti | Minnesota | 27059 | 56 | 0 |
272676 | 272676 | 2020-06-25 | Isanti | Minnesota | 27059 | 56 | 0 |
275819 | 275819 | 2020-06-26 | Isanti | Minnesota | 27059 | 56 | 0 |
278967 | 278967 | 2020-06-27 | Isanti | Minnesota | 27059 | 58 | 0 |
282115 | 282115 | 2020-06-28 | Isanti | Minnesota | 27059 | 60 | 0 |
285260 | 285260 | 2020-06-29 | Isanti | Minnesota | 27059 | 61 | 0 |
288410 | 288410 | 2020-06-30 | Isanti | Minnesota | 27059 | 61 | 0 |
291561 | 291561 | 2020-07-01 | Isanti | Minnesota | 27059 | 64 | 0 |
294715 | 294715 | 2020-07-02 | Isanti | Minnesota | 27059 | 65 | 0 |
297873 | 297873 | 2020-07-03 | Isanti | Minnesota | 27059 | 72 | 0 |
301036 | 301036 | 2020-07-04 | Isanti | Minnesota | 27059 | 72 | 0 |
304200 | 304200 | 2020-07-05 | Isanti | Minnesota | 27059 | 72 | 0 |
307367 | 307367 | 2020-07-06 | Isanti | Minnesota | 27059 | 73 | 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);