ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
768 rows where county = "Presque Isle" and state = "Michigan" 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 |
---|---|---|---|---|---|---|---|
36689 | 36689 | 2020-04-06 | Presque Isle | Michigan | 26141 | 1 | 0 |
39198 | 39198 | 2020-04-07 | Presque Isle | Michigan | 26141 | 1 | 0 |
41750 | 41750 | 2020-04-08 | Presque Isle | Michigan | 26141 | 1 | 0 |
44326 | 44326 | 2020-04-09 | Presque Isle | Michigan | 26141 | 1 | 0 |
46935 | 46935 | 2020-04-10 | Presque Isle | Michigan | 26141 | 2 | 0 |
49579 | 49579 | 2020-04-11 | Presque Isle | Michigan | 26141 | 2 | 0 |
52249 | 52249 | 2020-04-12 | Presque Isle | Michigan | 26141 | 2 | 0 |
54931 | 54931 | 2020-04-13 | Presque Isle | Michigan | 26141 | 2 | 0 |
57629 | 57629 | 2020-04-14 | Presque Isle | Michigan | 26141 | 2 | 0 |
60339 | 60339 | 2020-04-15 | Presque Isle | Michigan | 26141 | 2 | 0 |
63061 | 63061 | 2020-04-16 | Presque Isle | Michigan | 26141 | 2 | 0 |
65799 | 65799 | 2020-04-17 | Presque Isle | Michigan | 26141 | 2 | 0 |
68550 | 68550 | 2020-04-18 | Presque Isle | Michigan | 26141 | 2 | 0 |
71314 | 71314 | 2020-04-19 | Presque Isle | Michigan | 26141 | 2 | 0 |
74086 | 74086 | 2020-04-20 | Presque Isle | Michigan | 26141 | 2 | 0 |
76866 | 76866 | 2020-04-21 | Presque Isle | Michigan | 26141 | 6 | 0 |
79652 | 79652 | 2020-04-22 | Presque Isle | Michigan | 26141 | 6 | 0 |
82447 | 82447 | 2020-04-23 | Presque Isle | Michigan | 26141 | 8 | 0 |
85251 | 85251 | 2020-04-24 | Presque Isle | Michigan | 26141 | 9 | 0 |
88061 | 88061 | 2020-04-25 | Presque Isle | Michigan | 26141 | 10 | 0 |
90877 | 90877 | 2020-04-26 | Presque Isle | Michigan | 26141 | 10 | 0 |
93698 | 93698 | 2020-04-27 | Presque Isle | Michigan | 26141 | 11 | 0 |
96533 | 96533 | 2020-04-28 | Presque Isle | Michigan | 26141 | 11 | 0 |
99379 | 99379 | 2020-04-29 | Presque Isle | Michigan | 26141 | 12 | 0 |
102231 | 102231 | 2020-04-30 | Presque Isle | Michigan | 26141 | 11 | 0 |
105091 | 105091 | 2020-05-01 | Presque Isle | Michigan | 26141 | 11 | 0 |
107955 | 107955 | 2020-05-02 | Presque Isle | Michigan | 26141 | 11 | 0 |
110827 | 110827 | 2020-05-03 | Presque Isle | Michigan | 26141 | 11 | 0 |
113705 | 113705 | 2020-05-04 | Presque Isle | Michigan | 26141 | 11 | 0 |
116586 | 116586 | 2020-05-05 | Presque Isle | Michigan | 26141 | 11 | 0 |
119547 | 119547 | 2020-05-06 | Presque Isle | Michigan | 26141 | 11 | 0 |
122519 | 122519 | 2020-05-07 | Presque Isle | Michigan | 26141 | 12 | 0 |
125501 | 125501 | 2020-05-08 | Presque Isle | Michigan | 26141 | 11 | 0 |
128488 | 128488 | 2020-05-09 | Presque Isle | Michigan | 26141 | 11 | 0 |
131478 | 131478 | 2020-05-10 | Presque Isle | Michigan | 26141 | 11 | 0 |
134469 | 134469 | 2020-05-11 | Presque Isle | Michigan | 26141 | 11 | 0 |
137459 | 137459 | 2020-05-12 | Presque Isle | Michigan | 26141 | 11 | 0 |
140453 | 140453 | 2020-05-13 | Presque Isle | Michigan | 26141 | 11 | 0 |
143448 | 143448 | 2020-05-14 | Presque Isle | Michigan | 26141 | 11 | 0 |
146448 | 146448 | 2020-05-15 | Presque Isle | Michigan | 26141 | 11 | 0 |
149453 | 149453 | 2020-05-16 | Presque Isle | Michigan | 26141 | 11 | 0 |
152464 | 152464 | 2020-05-17 | Presque Isle | Michigan | 26141 | 11 | 0 |
155478 | 155478 | 2020-05-18 | Presque Isle | Michigan | 26141 | 11 | 0 |
158496 | 158496 | 2020-05-19 | Presque Isle | Michigan | 26141 | 11 | 0 |
161522 | 161522 | 2020-05-20 | Presque Isle | Michigan | 26141 | 11 | 0 |
164551 | 164551 | 2020-05-21 | Presque Isle | Michigan | 26141 | 11 | 0 |
167587 | 167587 | 2020-05-22 | Presque Isle | Michigan | 26141 | 11 | 0 |
170624 | 170624 | 2020-05-23 | Presque Isle | Michigan | 26141 | 11 | 0 |
173666 | 173666 | 2020-05-24 | Presque Isle | Michigan | 26141 | 11 | 0 |
176709 | 176709 | 2020-05-25 | Presque Isle | Michigan | 26141 | 11 | 0 |
179753 | 179753 | 2020-05-26 | Presque Isle | Michigan | 26141 | 11 | 0 |
182799 | 182799 | 2020-05-27 | Presque Isle | Michigan | 26141 | 11 | 0 |
185854 | 185854 | 2020-05-28 | Presque Isle | Michigan | 26141 | 11 | 0 |
188912 | 188912 | 2020-05-29 | Presque Isle | Michigan | 26141 | 11 | 0 |
191976 | 191976 | 2020-05-30 | Presque Isle | Michigan | 26141 | 11 | 0 |
195044 | 195044 | 2020-05-31 | Presque Isle | Michigan | 26141 | 11 | 0 |
198115 | 198115 | 2020-06-01 | Presque Isle | Michigan | 26141 | 11 | 0 |
201188 | 201188 | 2020-06-02 | Presque Isle | Michigan | 26141 | 11 | 0 |
204265 | 204265 | 2020-06-03 | Presque Isle | Michigan | 26141 | 11 | 0 |
207346 | 207346 | 2020-06-04 | Presque Isle | Michigan | 26141 | 11 | 0 |
210427 | 210427 | 2020-06-05 | Presque Isle | Michigan | 26141 | 11 | 0 |
213511 | 213511 | 2020-06-06 | Presque Isle | Michigan | 26141 | 11 | 0 |
216599 | 216599 | 2020-06-07 | Presque Isle | Michigan | 26141 | 11 | 0 |
219691 | 219691 | 2020-06-08 | Presque Isle | Michigan | 26141 | 11 | 0 |
222786 | 222786 | 2020-06-09 | Presque Isle | Michigan | 26141 | 11 | 0 |
225884 | 225884 | 2020-06-10 | Presque Isle | Michigan | 26141 | 11 | 0 |
228986 | 228986 | 2020-06-11 | Presque Isle | Michigan | 26141 | 12 | 0 |
232090 | 232090 | 2020-06-12 | Presque Isle | Michigan | 26141 | 12 | 0 |
235195 | 235195 | 2020-06-13 | Presque Isle | Michigan | 26141 | 12 | 0 |
238302 | 238302 | 2020-06-14 | Presque Isle | Michigan | 26141 | 12 | 0 |
241411 | 241411 | 2020-06-15 | Presque Isle | Michigan | 26141 | 12 | 0 |
244522 | 244522 | 2020-06-16 | Presque Isle | Michigan | 26141 | 12 | 0 |
247635 | 247635 | 2020-06-17 | Presque Isle | Michigan | 26141 | 12 | 0 |
250747 | 250747 | 2020-06-18 | Presque Isle | Michigan | 26141 | 12 | 0 |
253862 | 253862 | 2020-06-19 | Presque Isle | Michigan | 26141 | 12 | 0 |
256982 | 256982 | 2020-06-20 | Presque Isle | Michigan | 26141 | 12 | 0 |
260108 | 260108 | 2020-06-21 | Presque Isle | Michigan | 26141 | 12 | 0 |
263237 | 263237 | 2020-06-22 | Presque Isle | Michigan | 26141 | 12 | 0 |
266363 | 266363 | 2020-06-23 | Presque Isle | Michigan | 26141 | 12 | 0 |
269496 | 269496 | 2020-06-24 | Presque Isle | Michigan | 26141 | 12 | 0 |
272633 | 272633 | 2020-06-25 | Presque Isle | Michigan | 26141 | 12 | 0 |
275776 | 275776 | 2020-06-26 | Presque Isle | Michigan | 26141 | 12 | 0 |
278924 | 278924 | 2020-06-27 | Presque Isle | Michigan | 26141 | 12 | 0 |
282072 | 282072 | 2020-06-28 | Presque Isle | Michigan | 26141 | 12 | 0 |
285217 | 285217 | 2020-06-29 | Presque Isle | Michigan | 26141 | 12 | 0 |
288367 | 288367 | 2020-06-30 | Presque Isle | Michigan | 26141 | 12 | 0 |
291518 | 291518 | 2020-07-01 | Presque Isle | Michigan | 26141 | 13 | 0 |
294672 | 294672 | 2020-07-02 | Presque Isle | Michigan | 26141 | 13 | 0 |
297830 | 297830 | 2020-07-03 | Presque Isle | Michigan | 26141 | 13 | 0 |
300993 | 300993 | 2020-07-04 | Presque Isle | Michigan | 26141 | 13 | 0 |
304157 | 304157 | 2020-07-05 | Presque Isle | Michigan | 26141 | 13 | 0 |
307324 | 307324 | 2020-07-06 | Presque Isle | Michigan | 26141 | 13 | 0 |
310492 | 310492 | 2020-07-07 | Presque Isle | Michigan | 26141 | 14 | 0 |
313662 | 313662 | 2020-07-08 | Presque Isle | Michigan | 26141 | 13 | 0 |
316836 | 316836 | 2020-07-09 | Presque Isle | Michigan | 26141 | 13 | 0 |
320011 | 320011 | 2020-07-10 | Presque Isle | Michigan | 26141 | 13 | 0 |
323190 | 323190 | 2020-07-11 | Presque Isle | Michigan | 26141 | 13 | 0 |
326373 | 326373 | 2020-07-12 | Presque Isle | Michigan | 26141 | 13 | 0 |
329559 | 329559 | 2020-07-13 | Presque Isle | Michigan | 26141 | 16 | 0 |
332746 | 332746 | 2020-07-14 | Presque Isle | Michigan | 26141 | 15 | 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);