ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
767 rows where county = "Swift" and state = "Minnesota" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
39265 | 39265 | 2020-04-07 | Swift | Minnesota | 27151 | 1 | 0 |
41819 | 41819 | 2020-04-08 | Swift | Minnesota | 27151 | 1 | 0 |
44395 | 44395 | 2020-04-09 | Swift | Minnesota | 27151 | 1 | 0 |
47005 | 47005 | 2020-04-10 | Swift | Minnesota | 27151 | 1 | 0 |
49650 | 49650 | 2020-04-11 | Swift | Minnesota | 27151 | 1 | 0 |
52322 | 52322 | 2020-04-12 | Swift | Minnesota | 27151 | 1 | 0 |
55004 | 55004 | 2020-04-13 | Swift | Minnesota | 27151 | 1 | 0 |
57702 | 57702 | 2020-04-14 | Swift | Minnesota | 27151 | 1 | 0 |
60413 | 60413 | 2020-04-15 | Swift | Minnesota | 27151 | 1 | 0 |
63136 | 63136 | 2020-04-16 | Swift | Minnesota | 27151 | 1 | 0 |
65875 | 65875 | 2020-04-17 | Swift | Minnesota | 27151 | 1 | 0 |
68627 | 68627 | 2020-04-18 | Swift | Minnesota | 27151 | 1 | 0 |
71393 | 71393 | 2020-04-19 | Swift | Minnesota | 27151 | 1 | 0 |
74166 | 74166 | 2020-04-20 | Swift | Minnesota | 27151 | 1 | 0 |
76947 | 76947 | 2020-04-21 | Swift | Minnesota | 27151 | 1 | 0 |
79732 | 79732 | 2020-04-22 | Swift | Minnesota | 27151 | 1 | 0 |
82528 | 82528 | 2020-04-23 | Swift | Minnesota | 27151 | 1 | 0 |
85332 | 85332 | 2020-04-24 | Swift | Minnesota | 27151 | 1 | 0 |
88142 | 88142 | 2020-04-25 | Swift | Minnesota | 27151 | 1 | 0 |
90958 | 90958 | 2020-04-26 | Swift | Minnesota | 27151 | 1 | 0 |
93779 | 93779 | 2020-04-27 | Swift | Minnesota | 27151 | 1 | 0 |
96614 | 96614 | 2020-04-28 | Swift | Minnesota | 27151 | 2 | 0 |
99460 | 99460 | 2020-04-29 | Swift | Minnesota | 27151 | 2 | 0 |
102312 | 102312 | 2020-04-30 | Swift | Minnesota | 27151 | 2 | 0 |
105173 | 105173 | 2020-05-01 | Swift | Minnesota | 27151 | 2 | 0 |
108038 | 108038 | 2020-05-02 | Swift | Minnesota | 27151 | 2 | 0 |
110909 | 110909 | 2020-05-03 | Swift | Minnesota | 27151 | 2 | 0 |
113788 | 113788 | 2020-05-04 | Swift | Minnesota | 27151 | 2 | 0 |
116670 | 116670 | 2020-05-05 | Swift | Minnesota | 27151 | 2 | 0 |
119630 | 119630 | 2020-05-06 | Swift | Minnesota | 27151 | 2 | 0 |
122604 | 122604 | 2020-05-07 | Swift | Minnesota | 27151 | 2 | 0 |
125586 | 125586 | 2020-05-08 | Swift | Minnesota | 27151 | 3 | 0 |
128573 | 128573 | 2020-05-09 | Swift | Minnesota | 27151 | 3 | 0 |
131563 | 131563 | 2020-05-10 | Swift | Minnesota | 27151 | 5 | 0 |
134554 | 134554 | 2020-05-11 | Swift | Minnesota | 27151 | 8 | 0 |
137544 | 137544 | 2020-05-12 | Swift | Minnesota | 27151 | 9 | 0 |
140538 | 140538 | 2020-05-13 | Swift | Minnesota | 27151 | 9 | 0 |
143533 | 143533 | 2020-05-14 | Swift | Minnesota | 27151 | 10 | 0 |
146533 | 146533 | 2020-05-15 | Swift | Minnesota | 27151 | 11 | 0 |
149538 | 149538 | 2020-05-16 | Swift | Minnesota | 27151 | 12 | 0 |
152549 | 152549 | 2020-05-17 | Swift | Minnesota | 27151 | 13 | 0 |
155563 | 155563 | 2020-05-18 | Swift | Minnesota | 27151 | 13 | 0 |
158581 | 158581 | 2020-05-19 | Swift | Minnesota | 27151 | 13 | 0 |
161607 | 161607 | 2020-05-20 | Swift | Minnesota | 27151 | 13 | 0 |
164636 | 164636 | 2020-05-21 | Swift | Minnesota | 27151 | 14 | 0 |
167672 | 167672 | 2020-05-22 | Swift | Minnesota | 27151 | 15 | 0 |
170710 | 170710 | 2020-05-23 | Swift | Minnesota | 27151 | 15 | 0 |
173752 | 173752 | 2020-05-24 | Swift | Minnesota | 27151 | 15 | 0 |
176795 | 176795 | 2020-05-25 | Swift | Minnesota | 27151 | 16 | 0 |
179839 | 179839 | 2020-05-26 | Swift | Minnesota | 27151 | 16 | 0 |
182885 | 182885 | 2020-05-27 | Swift | Minnesota | 27151 | 17 | 0 |
185941 | 185941 | 2020-05-28 | Swift | Minnesota | 27151 | 17 | 0 |
188999 | 188999 | 2020-05-29 | Swift | Minnesota | 27151 | 18 | 0 |
192063 | 192063 | 2020-05-30 | Swift | Minnesota | 27151 | 18 | 0 |
195131 | 195131 | 2020-05-31 | Swift | Minnesota | 27151 | 18 | 0 |
198202 | 198202 | 2020-06-01 | Swift | Minnesota | 27151 | 19 | 0 |
201275 | 201275 | 2020-06-02 | Swift | Minnesota | 27151 | 19 | 0 |
204352 | 204352 | 2020-06-03 | Swift | Minnesota | 27151 | 19 | 0 |
207433 | 207433 | 2020-06-04 | Swift | Minnesota | 27151 | 19 | 0 |
210514 | 210514 | 2020-06-05 | Swift | Minnesota | 27151 | 19 | 1 |
213598 | 213598 | 2020-06-06 | Swift | Minnesota | 27151 | 19 | 1 |
216686 | 216686 | 2020-06-07 | Swift | Minnesota | 27151 | 19 | 1 |
219778 | 219778 | 2020-06-08 | Swift | Minnesota | 27151 | 19 | 1 |
222873 | 222873 | 2020-06-09 | Swift | Minnesota | 27151 | 19 | 1 |
225971 | 225971 | 2020-06-10 | Swift | Minnesota | 27151 | 19 | 1 |
229073 | 229073 | 2020-06-11 | Swift | Minnesota | 27151 | 19 | 1 |
232177 | 232177 | 2020-06-12 | Swift | Minnesota | 27151 | 19 | 1 |
235283 | 235283 | 2020-06-13 | Swift | Minnesota | 27151 | 19 | 1 |
238390 | 238390 | 2020-06-14 | Swift | Minnesota | 27151 | 19 | 1 |
241499 | 241499 | 2020-06-15 | Swift | Minnesota | 27151 | 20 | 1 |
244610 | 244610 | 2020-06-16 | Swift | Minnesota | 27151 | 20 | 1 |
247723 | 247723 | 2020-06-17 | Swift | Minnesota | 27151 | 20 | 1 |
250835 | 250835 | 2020-06-18 | Swift | Minnesota | 27151 | 20 | 1 |
253950 | 253950 | 2020-06-19 | Swift | Minnesota | 27151 | 20 | 1 |
257070 | 257070 | 2020-06-20 | Swift | Minnesota | 27151 | 20 | 1 |
260196 | 260196 | 2020-06-21 | Swift | Minnesota | 27151 | 20 | 1 |
263325 | 263325 | 2020-06-22 | Swift | Minnesota | 27151 | 20 | 1 |
266451 | 266451 | 2020-06-23 | Swift | Minnesota | 27151 | 20 | 1 |
269584 | 269584 | 2020-06-24 | Swift | Minnesota | 27151 | 20 | 1 |
272721 | 272721 | 2020-06-25 | Swift | Minnesota | 27151 | 20 | 1 |
275864 | 275864 | 2020-06-26 | Swift | Minnesota | 27151 | 20 | 1 |
279012 | 279012 | 2020-06-27 | Swift | Minnesota | 27151 | 20 | 1 |
282160 | 282160 | 2020-06-28 | Swift | Minnesota | 27151 | 20 | 1 |
285305 | 285305 | 2020-06-29 | Swift | Minnesota | 27151 | 20 | 1 |
288455 | 288455 | 2020-06-30 | Swift | Minnesota | 27151 | 20 | 1 |
291606 | 291606 | 2020-07-01 | Swift | Minnesota | 27151 | 20 | 1 |
294760 | 294760 | 2020-07-02 | Swift | Minnesota | 27151 | 21 | 1 |
297918 | 297918 | 2020-07-03 | Swift | Minnesota | 27151 | 21 | 1 |
301081 | 301081 | 2020-07-04 | Swift | Minnesota | 27151 | 21 | 1 |
304245 | 304245 | 2020-07-05 | Swift | Minnesota | 27151 | 21 | 1 |
307412 | 307412 | 2020-07-06 | Swift | Minnesota | 27151 | 22 | 1 |
310580 | 310580 | 2020-07-07 | Swift | Minnesota | 27151 | 22 | 1 |
313750 | 313750 | 2020-07-08 | Swift | Minnesota | 27151 | 23 | 1 |
316924 | 316924 | 2020-07-09 | Swift | Minnesota | 27151 | 25 | 1 |
320099 | 320099 | 2020-07-10 | Swift | Minnesota | 27151 | 29 | 1 |
323278 | 323278 | 2020-07-11 | Swift | Minnesota | 27151 | 33 | 1 |
326461 | 326461 | 2020-07-12 | Swift | Minnesota | 27151 | 33 | 1 |
329647 | 329647 | 2020-07-13 | Swift | Minnesota | 27151 | 35 | 1 |
332834 | 332834 | 2020-07-14 | Swift | Minnesota | 27151 | 35 | 1 |
336027 | 336027 | 2020-07-15 | Swift | Minnesota | 27151 | 39 | 1 |
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);