ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where fips = 26047 and state = "Michigan" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
7607 | 7607 | 2020-03-22 | Emmet | Michigan | 26047 | 1 | 0 |
8780 | 8780 | 2020-03-23 | Emmet | Michigan | 26047 | 1 | 0 |
10069 | 10069 | 2020-03-24 | Emmet | Michigan | 26047 | 2 | 0 |
11481 | 11481 | 2020-03-25 | Emmet | Michigan | 26047 | 2 | 0 |
13062 | 13062 | 2020-03-26 | Emmet | Michigan | 26047 | 2 | 0 |
14772 | 14772 | 2020-03-27 | Emmet | Michigan | 26047 | 3 | 0 |
16592 | 16592 | 2020-03-28 | Emmet | Michigan | 26047 | 4 | 0 |
18508 | 18508 | 2020-03-29 | Emmet | Michigan | 26047 | 4 | 0 |
20526 | 20526 | 2020-03-30 | Emmet | Michigan | 26047 | 4 | 0 |
22637 | 22637 | 2020-03-31 | Emmet | Michigan | 26047 | 5 | 0 |
27069 | 27069 | 2020-04-02 | Emmet | Michigan | 26047 | 6 | 1 |
29387 | 29387 | 2020-04-03 | Emmet | Michigan | 26047 | 6 | 2 |
24816 | 24816 | 2020-04-01 | Emmet | Michigan | 26047 | 7 | 1 |
31765 | 31765 | 2020-04-04 | Emmet | Michigan | 26047 | 7 | 2 |
34190 | 34190 | 2020-04-05 | Emmet | Michigan | 26047 | 13 | 2 |
36649 | 36649 | 2020-04-06 | Emmet | Michigan | 26047 | 13 | 2 |
39157 | 39157 | 2020-04-07 | Emmet | Michigan | 26047 | 14 | 2 |
41709 | 41709 | 2020-04-08 | Emmet | Michigan | 26047 | 15 | 2 |
44285 | 44285 | 2020-04-09 | Emmet | Michigan | 26047 | 16 | 2 |
46893 | 46893 | 2020-04-10 | Emmet | Michigan | 26047 | 17 | 2 |
49536 | 49536 | 2020-04-11 | Emmet | Michigan | 26047 | 21 | 2 |
52206 | 52206 | 2020-04-12 | Emmet | Michigan | 26047 | 21 | 2 |
54887 | 54887 | 2020-04-13 | Emmet | Michigan | 26047 | 21 | 2 |
57585 | 57585 | 2020-04-14 | Emmet | Michigan | 26047 | 21 | 2 |
60295 | 60295 | 2020-04-15 | Emmet | Michigan | 26047 | 21 | 2 |
63017 | 63017 | 2020-04-16 | Emmet | Michigan | 26047 | 21 | 2 |
65755 | 65755 | 2020-04-17 | Emmet | Michigan | 26047 | 21 | 2 |
68506 | 68506 | 2020-04-18 | Emmet | Michigan | 26047 | 21 | 2 |
71270 | 71270 | 2020-04-19 | Emmet | Michigan | 26047 | 21 | 2 |
74042 | 74042 | 2020-04-20 | Emmet | Michigan | 26047 | 21 | 2 |
76822 | 76822 | 2020-04-21 | Emmet | Michigan | 26047 | 21 | 2 |
82403 | 82403 | 2020-04-23 | Emmet | Michigan | 26047 | 21 | 2 |
85207 | 85207 | 2020-04-24 | Emmet | Michigan | 26047 | 21 | 2 |
88017 | 88017 | 2020-04-25 | Emmet | Michigan | 26047 | 21 | 2 |
90833 | 90833 | 2020-04-26 | Emmet | Michigan | 26047 | 21 | 2 |
93654 | 93654 | 2020-04-27 | Emmet | Michigan | 26047 | 21 | 2 |
96489 | 96489 | 2020-04-28 | Emmet | Michigan | 26047 | 21 | 2 |
99335 | 99335 | 2020-04-29 | Emmet | Michigan | 26047 | 21 | 2 |
102187 | 102187 | 2020-04-30 | Emmet | Michigan | 26047 | 21 | 2 |
105047 | 105047 | 2020-05-01 | Emmet | Michigan | 26047 | 21 | 2 |
107911 | 107911 | 2020-05-02 | Emmet | Michigan | 26047 | 21 | 2 |
110783 | 110783 | 2020-05-03 | Emmet | Michigan | 26047 | 21 | 2 |
113661 | 113661 | 2020-05-04 | Emmet | Michigan | 26047 | 21 | 2 |
116542 | 116542 | 2020-05-05 | Emmet | Michigan | 26047 | 21 | 2 |
119503 | 119503 | 2020-05-06 | Emmet | Michigan | 26047 | 21 | 2 |
122475 | 122475 | 2020-05-07 | Emmet | Michigan | 26047 | 21 | 2 |
125457 | 125457 | 2020-05-08 | Emmet | Michigan | 26047 | 21 | 2 |
128444 | 128444 | 2020-05-09 | Emmet | Michigan | 26047 | 21 | 2 |
131434 | 131434 | 2020-05-10 | Emmet | Michigan | 26047 | 21 | 2 |
134425 | 134425 | 2020-05-11 | Emmet | Michigan | 26047 | 21 | 2 |
137415 | 137415 | 2020-05-12 | Emmet | Michigan | 26047 | 21 | 2 |
140409 | 140409 | 2020-05-13 | Emmet | Michigan | 26047 | 21 | 2 |
143404 | 143404 | 2020-05-14 | Emmet | Michigan | 26047 | 21 | 2 |
146404 | 146404 | 2020-05-15 | Emmet | Michigan | 26047 | 21 | 2 |
149409 | 149409 | 2020-05-16 | Emmet | Michigan | 26047 | 21 | 2 |
152420 | 152420 | 2020-05-17 | Emmet | Michigan | 26047 | 21 | 2 |
155434 | 155434 | 2020-05-18 | Emmet | Michigan | 26047 | 21 | 2 |
158452 | 158452 | 2020-05-19 | Emmet | Michigan | 26047 | 21 | 2 |
161478 | 161478 | 2020-05-20 | Emmet | Michigan | 26047 | 21 | 2 |
164507 | 164507 | 2020-05-21 | Emmet | Michigan | 26047 | 21 | 2 |
167543 | 167543 | 2020-05-22 | Emmet | Michigan | 26047 | 21 | 2 |
170580 | 170580 | 2020-05-23 | Emmet | Michigan | 26047 | 21 | 2 |
173622 | 173622 | 2020-05-24 | Emmet | Michigan | 26047 | 21 | 2 |
176665 | 176665 | 2020-05-25 | Emmet | Michigan | 26047 | 21 | 2 |
179709 | 179709 | 2020-05-26 | Emmet | Michigan | 26047 | 21 | 2 |
182755 | 182755 | 2020-05-27 | Emmet | Michigan | 26047 | 21 | 2 |
185810 | 185810 | 2020-05-28 | Emmet | Michigan | 26047 | 21 | 2 |
188868 | 188868 | 2020-05-29 | Emmet | Michigan | 26047 | 21 | 2 |
191932 | 191932 | 2020-05-30 | Emmet | Michigan | 26047 | 21 | 2 |
195000 | 195000 | 2020-05-31 | Emmet | Michigan | 26047 | 21 | 2 |
79608 | 79608 | 2020-04-22 | Emmet | Michigan | 26047 | 22 | 2 |
198071 | 198071 | 2020-06-01 | Emmet | Michigan | 26047 | 27 | 2 |
201143 | 201143 | 2020-06-02 | Emmet | Michigan | 26047 | 27 | 2 |
204220 | 204220 | 2020-06-03 | Emmet | Michigan | 26047 | 27 | 2 |
207301 | 207301 | 2020-06-04 | Emmet | Michigan | 26047 | 27 | 2 |
210382 | 210382 | 2020-06-05 | Emmet | Michigan | 26047 | 27 | 2 |
213466 | 213466 | 2020-06-06 | Emmet | Michigan | 26047 | 27 | 2 |
216554 | 216554 | 2020-06-07 | Emmet | Michigan | 26047 | 27 | 2 |
219646 | 219646 | 2020-06-08 | Emmet | Michigan | 26047 | 27 | 2 |
222741 | 222741 | 2020-06-09 | Emmet | Michigan | 26047 | 27 | 2 |
225838 | 225838 | 2020-06-10 | Emmet | Michigan | 26047 | 27 | 2 |
228940 | 228940 | 2020-06-11 | Emmet | Michigan | 26047 | 27 | 2 |
232044 | 232044 | 2020-06-12 | Emmet | Michigan | 26047 | 27 | 2 |
235149 | 235149 | 2020-06-13 | Emmet | Michigan | 26047 | 27 | 2 |
238256 | 238256 | 2020-06-14 | Emmet | Michigan | 26047 | 27 | 2 |
241365 | 241365 | 2020-06-15 | Emmet | Michigan | 26047 | 27 | 2 |
244476 | 244476 | 2020-06-16 | Emmet | Michigan | 26047 | 27 | 2 |
247589 | 247589 | 2020-06-17 | Emmet | Michigan | 26047 | 27 | 2 |
253816 | 253816 | 2020-06-19 | Emmet | Michigan | 26047 | 27 | 2 |
256936 | 256936 | 2020-06-20 | Emmet | Michigan | 26047 | 27 | 2 |
260062 | 260062 | 2020-06-21 | Emmet | Michigan | 26047 | 27 | 2 |
263191 | 263191 | 2020-06-22 | Emmet | Michigan | 26047 | 27 | 2 |
266317 | 266317 | 2020-06-23 | Emmet | Michigan | 26047 | 27 | 2 |
272587 | 272587 | 2020-06-25 | Emmet | Michigan | 26047 | 27 | 2 |
275730 | 275730 | 2020-06-26 | Emmet | Michigan | 26047 | 27 | 2 |
278878 | 278878 | 2020-06-27 | Emmet | Michigan | 26047 | 27 | 2 |
282026 | 282026 | 2020-06-28 | Emmet | Michigan | 26047 | 27 | 2 |
285171 | 285171 | 2020-06-29 | Emmet | Michigan | 26047 | 27 | 2 |
288321 | 288321 | 2020-06-30 | Emmet | Michigan | 26047 | 27 | 2 |
250701 | 250701 | 2020-06-18 | Emmet | Michigan | 26047 | 28 | 2 |
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);