ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Midland" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282058 | 282058 | 2020-06-28 | Midland | Michigan | 26111 | 164 | 9 |
278910 | 278910 | 2020-06-27 | Midland | Michigan | 26111 | 160 | 9 |
275762 | 275762 | 2020-06-26 | Midland | Michigan | 26111 | 160 | 9 |
272619 | 272619 | 2020-06-25 | Midland | Michigan | 26111 | 161 | 9 |
269482 | 269482 | 2020-06-24 | Midland | Michigan | 26111 | 160 | 9 |
266349 | 266349 | 2020-06-23 | Midland | Michigan | 26111 | 160 | 9 |
263223 | 263223 | 2020-06-22 | Midland | Michigan | 26111 | 159 | 9 |
260094 | 260094 | 2020-06-21 | Midland | Michigan | 26111 | 159 | 9 |
256968 | 256968 | 2020-06-20 | Midland | Michigan | 26111 | 158 | 9 |
253848 | 253848 | 2020-06-19 | Midland | Michigan | 26111 | 156 | 9 |
250733 | 250733 | 2020-06-18 | Midland | Michigan | 26111 | 153 | 9 |
247621 | 247621 | 2020-06-17 | Midland | Michigan | 26111 | 153 | 9 |
244508 | 244508 | 2020-06-16 | Midland | Michigan | 26111 | 152 | 9 |
241397 | 241397 | 2020-06-15 | Midland | Michigan | 26111 | 153 | 9 |
238288 | 238288 | 2020-06-14 | Midland | Michigan | 26111 | 152 | 9 |
235181 | 235181 | 2020-06-13 | Midland | Michigan | 26111 | 152 | 9 |
232076 | 232076 | 2020-06-12 | Midland | Michigan | 26111 | 145 | 9 |
228972 | 228972 | 2020-06-11 | Midland | Michigan | 26111 | 140 | 9 |
225870 | 225870 | 2020-06-10 | Midland | Michigan | 26111 | 138 | 9 |
222772 | 222772 | 2020-06-09 | Midland | Michigan | 26111 | 128 | 9 |
219677 | 219677 | 2020-06-08 | Midland | Michigan | 26111 | 125 | 9 |
216585 | 216585 | 2020-06-07 | Midland | Michigan | 26111 | 121 | 9 |
213497 | 213497 | 2020-06-06 | Midland | Michigan | 26111 | 120 | 9 |
210413 | 210413 | 2020-06-05 | Midland | Michigan | 26111 | 120 | 9 |
207332 | 207332 | 2020-06-04 | Midland | Michigan | 26111 | 120 | 8 |
204251 | 204251 | 2020-06-03 | Midland | Michigan | 26111 | 120 | 8 |
201174 | 201174 | 2020-06-02 | Midland | Michigan | 26111 | 120 | 8 |
198101 | 198101 | 2020-06-01 | Midland | Michigan | 26111 | 82 | 8 |
195030 | 195030 | 2020-05-31 | Midland | Michigan | 26111 | 82 | 8 |
191962 | 191962 | 2020-05-30 | Midland | Michigan | 26111 | 82 | 8 |
188898 | 188898 | 2020-05-29 | Midland | Michigan | 26111 | 81 | 8 |
185840 | 185840 | 2020-05-28 | Midland | Michigan | 26111 | 81 | 8 |
182785 | 182785 | 2020-05-27 | Midland | Michigan | 26111 | 80 | 8 |
179739 | 179739 | 2020-05-26 | Midland | Michigan | 26111 | 79 | 8 |
176695 | 176695 | 2020-05-25 | Midland | Michigan | 26111 | 79 | 8 |
173652 | 173652 | 2020-05-24 | Midland | Michigan | 26111 | 79 | 8 |
170610 | 170610 | 2020-05-23 | Midland | Michigan | 26111 | 79 | 8 |
167573 | 167573 | 2020-05-22 | Midland | Michigan | 26111 | 79 | 8 |
164537 | 164537 | 2020-05-21 | Midland | Michigan | 26111 | 76 | 8 |
161508 | 161508 | 2020-05-20 | Midland | Michigan | 26111 | 76 | 8 |
158482 | 158482 | 2020-05-19 | Midland | Michigan | 26111 | 76 | 8 |
155464 | 155464 | 2020-05-18 | Midland | Michigan | 26111 | 71 | 8 |
152450 | 152450 | 2020-05-17 | Midland | Michigan | 26111 | 70 | 8 |
149439 | 149439 | 2020-05-16 | Midland | Michigan | 26111 | 70 | 8 |
146434 | 146434 | 2020-05-15 | Midland | Michigan | 26111 | 69 | 8 |
143434 | 143434 | 2020-05-14 | Midland | Michigan | 26111 | 67 | 8 |
140439 | 140439 | 2020-05-13 | Midland | Michigan | 26111 | 67 | 8 |
137445 | 137445 | 2020-05-12 | Midland | Michigan | 26111 | 67 | 8 |
134455 | 134455 | 2020-05-11 | Midland | Michigan | 26111 | 66 | 8 |
131464 | 131464 | 2020-05-10 | Midland | Michigan | 26111 | 66 | 8 |
128474 | 128474 | 2020-05-09 | Midland | Michigan | 26111 | 66 | 8 |
125487 | 125487 | 2020-05-08 | Midland | Michigan | 26111 | 66 | 8 |
122505 | 122505 | 2020-05-07 | Midland | Michigan | 26111 | 63 | 8 |
119533 | 119533 | 2020-05-06 | Midland | Michigan | 26111 | 63 | 7 |
116572 | 116572 | 2020-05-05 | Midland | Michigan | 26111 | 62 | 7 |
113691 | 113691 | 2020-05-04 | Midland | Michigan | 26111 | 62 | 7 |
110813 | 110813 | 2020-05-03 | Midland | Michigan | 26111 | 62 | 6 |
107941 | 107941 | 2020-05-02 | Midland | Michigan | 26111 | 62 | 6 |
105077 | 105077 | 2020-05-01 | Midland | Michigan | 26111 | 60 | 6 |
102217 | 102217 | 2020-04-30 | Midland | Michigan | 26111 | 61 | 5 |
99365 | 99365 | 2020-04-29 | Midland | Michigan | 26111 | 59 | 5 |
96519 | 96519 | 2020-04-28 | Midland | Michigan | 26111 | 56 | 4 |
93684 | 93684 | 2020-04-27 | Midland | Michigan | 26111 | 56 | 3 |
90863 | 90863 | 2020-04-26 | Midland | Michigan | 26111 | 52 | 3 |
88047 | 88047 | 2020-04-25 | Midland | Michigan | 26111 | 51 | 3 |
85237 | 85237 | 2020-04-24 | Midland | Michigan | 26111 | 50 | 3 |
82433 | 82433 | 2020-04-23 | Midland | Michigan | 26111 | 51 | 3 |
79638 | 79638 | 2020-04-22 | Midland | Michigan | 26111 | 47 | 3 |
76852 | 76852 | 2020-04-21 | Midland | Michigan | 26111 | 48 | 3 |
74072 | 74072 | 2020-04-20 | Midland | Michigan | 26111 | 47 | 3 |
71300 | 71300 | 2020-04-19 | Midland | Michigan | 26111 | 45 | 2 |
68536 | 68536 | 2020-04-18 | Midland | Michigan | 26111 | 43 | 2 |
65785 | 65785 | 2020-04-17 | Midland | Michigan | 26111 | 42 | 1 |
63047 | 63047 | 2020-04-16 | Midland | Michigan | 26111 | 41 | 1 |
60325 | 60325 | 2020-04-15 | Midland | Michigan | 26111 | 36 | 1 |
57615 | 57615 | 2020-04-14 | Midland | Michigan | 26111 | 33 | 1 |
54917 | 54917 | 2020-04-13 | Midland | Michigan | 26111 | 33 | 1 |
52236 | 52236 | 2020-04-12 | Midland | Michigan | 26111 | 31 | 1 |
49566 | 49566 | 2020-04-11 | Midland | Michigan | 26111 | 30 | 1 |
46922 | 46922 | 2020-04-10 | Midland | Michigan | 26111 | 28 | 1 |
44313 | 44313 | 2020-04-09 | Midland | Michigan | 26111 | 28 | 1 |
41737 | 41737 | 2020-04-08 | Midland | Michigan | 26111 | 24 | 1 |
39185 | 39185 | 2020-04-07 | Midland | Michigan | 26111 | 22 | 0 |
36676 | 36676 | 2020-04-06 | Midland | Michigan | 26111 | 22 | 0 |
34217 | 34217 | 2020-04-05 | Midland | Michigan | 26111 | 18 | 0 |
31792 | 31792 | 2020-04-04 | Midland | Michigan | 26111 | 17 | 0 |
29414 | 29414 | 2020-04-03 | Midland | Michigan | 26111 | 16 | 0 |
27095 | 27095 | 2020-04-02 | Midland | Michigan | 26111 | 15 | 0 |
24842 | 24842 | 2020-04-01 | Midland | Michigan | 26111 | 12 | 0 |
22662 | 22662 | 2020-03-31 | Midland | Michigan | 26111 | 10 | 0 |
20551 | 20551 | 2020-03-30 | Midland | Michigan | 26111 | 9 | 0 |
18532 | 18532 | 2020-03-29 | Midland | Michigan | 26111 | 8 | 0 |
16616 | 16616 | 2020-03-28 | Midland | Michigan | 26111 | 8 | 0 |
14796 | 14796 | 2020-03-27 | Midland | Michigan | 26111 | 8 | 0 |
13084 | 13084 | 2020-03-26 | Midland | Michigan | 26111 | 6 | 0 |
11500 | 11500 | 2020-03-25 | Midland | Michigan | 26111 | 6 | 0 |
10085 | 10085 | 2020-03-24 | Midland | Michigan | 26111 | 5 | 0 |
8791 | 8791 | 2020-03-23 | Midland | Michigan | 26111 | 5 | 0 |
7617 | 7617 | 2020-03-22 | Midland | Michigan | 26111 | 5 | 0 |
6537 | 6537 | 2020-03-21 | Midland | Michigan | 26111 | 3 | 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);