ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
769 rows where county = "Houston" and state = "Minnesota" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
320052 | 320052 | 2020-07-10 | Houston | Minnesota | 27055 | 29 | 0 |
316877 | 316877 | 2020-07-09 | Houston | Minnesota | 27055 | 29 | 0 |
313703 | 313703 | 2020-07-08 | Houston | Minnesota | 27055 | 28 | 0 |
310533 | 310533 | 2020-07-07 | Houston | Minnesota | 27055 | 27 | 0 |
307365 | 307365 | 2020-07-06 | Houston | Minnesota | 27055 | 26 | 0 |
304198 | 304198 | 2020-07-05 | Houston | Minnesota | 27055 | 25 | 0 |
301034 | 301034 | 2020-07-04 | Houston | Minnesota | 27055 | 25 | 0 |
297871 | 297871 | 2020-07-03 | Houston | Minnesota | 27055 | 25 | 0 |
294713 | 294713 | 2020-07-02 | Houston | Minnesota | 27055 | 25 | 0 |
291559 | 291559 | 2020-07-01 | Houston | Minnesota | 27055 | 24 | 0 |
288408 | 288408 | 2020-06-30 | Houston | Minnesota | 27055 | 24 | 0 |
285258 | 285258 | 2020-06-29 | Houston | Minnesota | 27055 | 23 | 0 |
282113 | 282113 | 2020-06-28 | Houston | Minnesota | 27055 | 21 | 0 |
278965 | 278965 | 2020-06-27 | Houston | Minnesota | 27055 | 20 | 0 |
275817 | 275817 | 2020-06-26 | Houston | Minnesota | 27055 | 17 | 0 |
272674 | 272674 | 2020-06-25 | Houston | Minnesota | 27055 | 16 | 0 |
269537 | 269537 | 2020-06-24 | Houston | Minnesota | 27055 | 15 | 0 |
266404 | 266404 | 2020-06-23 | Houston | Minnesota | 27055 | 15 | 0 |
263278 | 263278 | 2020-06-22 | Houston | Minnesota | 27055 | 13 | 0 |
260149 | 260149 | 2020-06-21 | Houston | Minnesota | 27055 | 13 | 0 |
257023 | 257023 | 2020-06-20 | Houston | Minnesota | 27055 | 10 | 0 |
253903 | 253903 | 2020-06-19 | Houston | Minnesota | 27055 | 7 | 0 |
250788 | 250788 | 2020-06-18 | Houston | Minnesota | 27055 | 8 | 0 |
247676 | 247676 | 2020-06-17 | Houston | Minnesota | 27055 | 7 | 0 |
244563 | 244563 | 2020-06-16 | Houston | Minnesota | 27055 | 5 | 0 |
241452 | 241452 | 2020-06-15 | Houston | Minnesota | 27055 | 5 | 0 |
238343 | 238343 | 2020-06-14 | Houston | Minnesota | 27055 | 5 | 0 |
235236 | 235236 | 2020-06-13 | Houston | Minnesota | 27055 | 5 | 0 |
232130 | 232130 | 2020-06-12 | Houston | Minnesota | 27055 | 5 | 0 |
229026 | 229026 | 2020-06-11 | Houston | Minnesota | 27055 | 5 | 0 |
225924 | 225924 | 2020-06-10 | Houston | Minnesota | 27055 | 5 | 0 |
222826 | 222826 | 2020-06-09 | Houston | Minnesota | 27055 | 5 | 0 |
219731 | 219731 | 2020-06-08 | Houston | Minnesota | 27055 | 4 | 0 |
216639 | 216639 | 2020-06-07 | Houston | Minnesota | 27055 | 3 | 0 |
213551 | 213551 | 2020-06-06 | Houston | Minnesota | 27055 | 3 | 0 |
210467 | 210467 | 2020-06-05 | Houston | Minnesota | 27055 | 3 | 0 |
207386 | 207386 | 2020-06-04 | Houston | Minnesota | 27055 | 2 | 0 |
204305 | 204305 | 2020-06-03 | Houston | Minnesota | 27055 | 2 | 0 |
201228 | 201228 | 2020-06-02 | Houston | Minnesota | 27055 | 2 | 0 |
198155 | 198155 | 2020-06-01 | Houston | Minnesota | 27055 | 2 | 0 |
195084 | 195084 | 2020-05-31 | Houston | Minnesota | 27055 | 2 | 0 |
192016 | 192016 | 2020-05-30 | Houston | Minnesota | 27055 | 2 | 0 |
188952 | 188952 | 2020-05-29 | Houston | Minnesota | 27055 | 2 | 0 |
185894 | 185894 | 2020-05-28 | Houston | Minnesota | 27055 | 2 | 0 |
182839 | 182839 | 2020-05-27 | Houston | Minnesota | 27055 | 2 | 0 |
179793 | 179793 | 2020-05-26 | Houston | Minnesota | 27055 | 2 | 0 |
176749 | 176749 | 2020-05-25 | Houston | Minnesota | 27055 | 2 | 0 |
173706 | 173706 | 2020-05-24 | Houston | Minnesota | 27055 | 2 | 0 |
170664 | 170664 | 2020-05-23 | Houston | Minnesota | 27055 | 2 | 0 |
167627 | 167627 | 2020-05-22 | Houston | Minnesota | 27055 | 2 | 0 |
164591 | 164591 | 2020-05-21 | Houston | Minnesota | 27055 | 2 | 0 |
161562 | 161562 | 2020-05-20 | Houston | Minnesota | 27055 | 2 | 0 |
158536 | 158536 | 2020-05-19 | Houston | Minnesota | 27055 | 2 | 0 |
155518 | 155518 | 2020-05-18 | Houston | Minnesota | 27055 | 2 | 0 |
152504 | 152504 | 2020-05-17 | Houston | Minnesota | 27055 | 2 | 0 |
149493 | 149493 | 2020-05-16 | Houston | Minnesota | 27055 | 2 | 0 |
146488 | 146488 | 2020-05-15 | Houston | Minnesota | 27055 | 2 | 0 |
143488 | 143488 | 2020-05-14 | Houston | Minnesota | 27055 | 2 | 0 |
140493 | 140493 | 2020-05-13 | Houston | Minnesota | 27055 | 2 | 0 |
137499 | 137499 | 2020-05-12 | Houston | Minnesota | 27055 | 2 | 0 |
134509 | 134509 | 2020-05-11 | Houston | Minnesota | 27055 | 2 | 0 |
131518 | 131518 | 2020-05-10 | Houston | Minnesota | 27055 | 2 | 0 |
128528 | 128528 | 2020-05-09 | Houston | Minnesota | 27055 | 2 | 0 |
125541 | 125541 | 2020-05-08 | Houston | Minnesota | 27055 | 2 | 0 |
122559 | 122559 | 2020-05-07 | Houston | Minnesota | 27055 | 2 | 0 |
119586 | 119586 | 2020-05-06 | Houston | Minnesota | 27055 | 1 | 0 |
116626 | 116626 | 2020-05-05 | Houston | Minnesota | 27055 | 1 | 0 |
113745 | 113745 | 2020-05-04 | Houston | Minnesota | 27055 | 1 | 0 |
110866 | 110866 | 2020-05-03 | Houston | Minnesota | 27055 | 1 | 0 |
107995 | 107995 | 2020-05-02 | Houston | Minnesota | 27055 | 1 | 0 |
105130 | 105130 | 2020-05-01 | Houston | Minnesota | 27055 | 1 | 0 |
102270 | 102270 | 2020-04-30 | Houston | Minnesota | 27055 | 1 | 0 |
99418 | 99418 | 2020-04-29 | Houston | Minnesota | 27055 | 1 | 0 |
96572 | 96572 | 2020-04-28 | Houston | Minnesota | 27055 | 1 | 0 |
93737 | 93737 | 2020-04-27 | Houston | Minnesota | 27055 | 1 | 0 |
90916 | 90916 | 2020-04-26 | Houston | Minnesota | 27055 | 1 | 0 |
88100 | 88100 | 2020-04-25 | Houston | Minnesota | 27055 | 1 | 0 |
85290 | 85290 | 2020-04-24 | Houston | Minnesota | 27055 | 1 | 0 |
82486 | 82486 | 2020-04-23 | Houston | Minnesota | 27055 | 1 | 0 |
79690 | 79690 | 2020-04-22 | Houston | Minnesota | 27055 | 1 | 0 |
76905 | 76905 | 2020-04-21 | Houston | Minnesota | 27055 | 1 | 0 |
74125 | 74125 | 2020-04-20 | Houston | Minnesota | 27055 | 1 | 0 |
71352 | 71352 | 2020-04-19 | Houston | Minnesota | 27055 | 1 | 0 |
68588 | 68588 | 2020-04-18 | Houston | Minnesota | 27055 | 1 | 0 |
65837 | 65837 | 2020-04-17 | Houston | Minnesota | 27055 | 1 | 0 |
63098 | 63098 | 2020-04-16 | Houston | Minnesota | 27055 | 1 | 0 |
60376 | 60376 | 2020-04-15 | Houston | Minnesota | 27055 | 1 | 0 |
57666 | 57666 | 2020-04-14 | Houston | Minnesota | 27055 | 1 | 0 |
54968 | 54968 | 2020-04-13 | Houston | Minnesota | 27055 | 1 | 0 |
52286 | 52286 | 2020-04-12 | Houston | Minnesota | 27055 | 1 | 0 |
49616 | 49616 | 2020-04-11 | Houston | Minnesota | 27055 | 1 | 0 |
46971 | 46971 | 2020-04-10 | Houston | Minnesota | 27055 | 1 | 0 |
44362 | 44362 | 2020-04-09 | Houston | Minnesota | 27055 | 1 | 0 |
41786 | 41786 | 2020-04-08 | Houston | Minnesota | 27055 | 1 | 0 |
39233 | 39233 | 2020-04-07 | Houston | Minnesota | 27055 | 1 | 0 |
36724 | 36724 | 2020-04-06 | Houston | Minnesota | 27055 | 1 | 0 |
34264 | 34264 | 2020-04-05 | Houston | Minnesota | 27055 | 1 | 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);