ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,514 rows where county = "Emmet" sorted by county
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 |
24816 | 24816 | 2020-04-01 | Emmet | Michigan | 26047 | 7 | 1 |
27069 | 27069 | 2020-04-02 | Emmet | Michigan | 26047 | 6 | 1 |
29387 | 29387 | 2020-04-03 | Emmet | Michigan | 26047 | 6 | 2 |
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 |
79608 | 79608 | 2020-04-22 | Emmet | Michigan | 26047 | 22 | 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 |
140001 | 140001 | 2020-05-13 | Emmet | Iowa | 19063 | 1 | 0 |
140409 | 140409 | 2020-05-13 | Emmet | Michigan | 26047 | 21 | 2 |
142997 | 142997 | 2020-05-14 | Emmet | Iowa | 19063 | 1 | 0 |
143404 | 143404 | 2020-05-14 | Emmet | Michigan | 26047 | 21 | 2 |
145997 | 145997 | 2020-05-15 | Emmet | Iowa | 19063 | 1 | 0 |
146404 | 146404 | 2020-05-15 | Emmet | Michigan | 26047 | 21 | 2 |
149001 | 149001 | 2020-05-16 | Emmet | Iowa | 19063 | 1 | 0 |
149409 | 149409 | 2020-05-16 | Emmet | Michigan | 26047 | 21 | 2 |
152011 | 152011 | 2020-05-17 | Emmet | Iowa | 19063 | 1 | 0 |
152420 | 152420 | 2020-05-17 | Emmet | Michigan | 26047 | 21 | 2 |
155023 | 155023 | 2020-05-18 | Emmet | Iowa | 19063 | 1 | 0 |
155434 | 155434 | 2020-05-18 | Emmet | Michigan | 26047 | 21 | 2 |
158039 | 158039 | 2020-05-19 | Emmet | Iowa | 19063 | 2 | 0 |
158452 | 158452 | 2020-05-19 | Emmet | Michigan | 26047 | 21 | 2 |
161065 | 161065 | 2020-05-20 | Emmet | Iowa | 19063 | 6 | 0 |
161478 | 161478 | 2020-05-20 | Emmet | Michigan | 26047 | 21 | 2 |
164093 | 164093 | 2020-05-21 | Emmet | Iowa | 19063 | 6 | 0 |
164507 | 164507 | 2020-05-21 | Emmet | Michigan | 26047 | 21 | 2 |
167126 | 167126 | 2020-05-22 | Emmet | Iowa | 19063 | 7 | 0 |
167543 | 167543 | 2020-05-22 | Emmet | Michigan | 26047 | 21 | 2 |
170163 | 170163 | 2020-05-23 | Emmet | Iowa | 19063 | 7 | 0 |
170580 | 170580 | 2020-05-23 | Emmet | Michigan | 26047 | 21 | 2 |
173204 | 173204 | 2020-05-24 | Emmet | Iowa | 19063 | 7 | 0 |
173622 | 173622 | 2020-05-24 | Emmet | Michigan | 26047 | 21 | 2 |
176248 | 176248 | 2020-05-25 | Emmet | Iowa | 19063 | 7 | 0 |
176665 | 176665 | 2020-05-25 | Emmet | Michigan | 26047 | 21 | 2 |
179292 | 179292 | 2020-05-26 | Emmet | Iowa | 19063 | 7 | 0 |
179709 | 179709 | 2020-05-26 | Emmet | Michigan | 26047 | 21 | 2 |
182337 | 182337 | 2020-05-27 | Emmet | Iowa | 19063 | 12 | 0 |
182755 | 182755 | 2020-05-27 | Emmet | Michigan | 26047 | 21 | 2 |
185391 | 185391 | 2020-05-28 | Emmet | Iowa | 19063 | 13 | 0 |
185810 | 185810 | 2020-05-28 | Emmet | Michigan | 26047 | 21 | 2 |
188449 | 188449 | 2020-05-29 | Emmet | Iowa | 19063 | 14 | 0 |
188868 | 188868 | 2020-05-29 | Emmet | Michigan | 26047 | 21 | 2 |
191514 | 191514 | 2020-05-30 | Emmet | Iowa | 19063 | 14 | 0 |
191932 | 191932 | 2020-05-30 | Emmet | Michigan | 26047 | 21 | 2 |
194581 | 194581 | 2020-05-31 | Emmet | Iowa | 19063 | 15 | 0 |
195000 | 195000 | 2020-05-31 | Emmet | Michigan | 26047 | 21 | 2 |
197651 | 197651 | 2020-06-01 | Emmet | Iowa | 19063 | 17 | 0 |
198071 | 198071 | 2020-06-01 | Emmet | Michigan | 26047 | 27 | 2 |
200724 | 200724 | 2020-06-02 | Emmet | Iowa | 19063 | 18 | 0 |
201143 | 201143 | 2020-06-02 | Emmet | Michigan | 26047 | 27 | 2 |
203800 | 203800 | 2020-06-03 | Emmet | Iowa | 19063 | 19 | 0 |
204220 | 204220 | 2020-06-03 | Emmet | Michigan | 26047 | 27 | 2 |
206880 | 206880 | 2020-06-04 | Emmet | Iowa | 19063 | 26 | 0 |
207301 | 207301 | 2020-06-04 | Emmet | Michigan | 26047 | 27 | 2 |
209961 | 209961 | 2020-06-05 | Emmet | Iowa | 19063 | 27 | 0 |
210382 | 210382 | 2020-06-05 | Emmet | Michigan | 26047 | 27 | 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);