ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Cass" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
282016 | 282016 | 2020-06-28 | Cass | Michigan | 26027 | 136 | 4 |
278868 | 278868 | 2020-06-27 | Cass | Michigan | 26027 | 134 | 4 |
275720 | 275720 | 2020-06-26 | Cass | Michigan | 26027 | 134 | 4 |
272577 | 272577 | 2020-06-25 | Cass | Michigan | 26027 | 131 | 4 |
269440 | 269440 | 2020-06-24 | Cass | Michigan | 26027 | 126 | 4 |
266307 | 266307 | 2020-06-23 | Cass | Michigan | 26027 | 126 | 4 |
263181 | 263181 | 2020-06-22 | Cass | Michigan | 26027 | 124 | 4 |
260052 | 260052 | 2020-06-21 | Cass | Michigan | 26027 | 122 | 4 |
256926 | 256926 | 2020-06-20 | Cass | Michigan | 26027 | 121 | 4 |
253806 | 253806 | 2020-06-19 | Cass | Michigan | 26027 | 119 | 4 |
250691 | 250691 | 2020-06-18 | Cass | Michigan | 26027 | 119 | 4 |
247579 | 247579 | 2020-06-17 | Cass | Michigan | 26027 | 118 | 4 |
244466 | 244466 | 2020-06-16 | Cass | Michigan | 26027 | 116 | 4 |
241355 | 241355 | 2020-06-15 | Cass | Michigan | 26027 | 115 | 4 |
238246 | 238246 | 2020-06-14 | Cass | Michigan | 26027 | 115 | 4 |
235139 | 235139 | 2020-06-13 | Cass | Michigan | 26027 | 114 | 4 |
232034 | 232034 | 2020-06-12 | Cass | Michigan | 26027 | 114 | 4 |
228930 | 228930 | 2020-06-11 | Cass | Michigan | 26027 | 112 | 4 |
225828 | 225828 | 2020-06-10 | Cass | Michigan | 26027 | 110 | 4 |
222731 | 222731 | 2020-06-09 | Cass | Michigan | 26027 | 108 | 4 |
219636 | 219636 | 2020-06-08 | Cass | Michigan | 26027 | 108 | 4 |
216544 | 216544 | 2020-06-07 | Cass | Michigan | 26027 | 106 | 3 |
213456 | 213456 | 2020-06-06 | Cass | Michigan | 26027 | 104 | 3 |
210372 | 210372 | 2020-06-05 | Cass | Michigan | 26027 | 101 | 3 |
207291 | 207291 | 2020-06-04 | Cass | Michigan | 26027 | 85 | 3 |
204210 | 204210 | 2020-06-03 | Cass | Michigan | 26027 | 84 | 3 |
201133 | 201133 | 2020-06-02 | Cass | Michigan | 26027 | 83 | 3 |
198061 | 198061 | 2020-06-01 | Cass | Michigan | 26027 | 82 | 3 |
194990 | 194990 | 2020-05-31 | Cass | Michigan | 26027 | 83 | 3 |
191922 | 191922 | 2020-05-30 | Cass | Michigan | 26027 | 82 | 3 |
188858 | 188858 | 2020-05-29 | Cass | Michigan | 26027 | 80 | 3 |
185800 | 185800 | 2020-05-28 | Cass | Michigan | 26027 | 80 | 2 |
182745 | 182745 | 2020-05-27 | Cass | Michigan | 26027 | 79 | 2 |
179699 | 179699 | 2020-05-26 | Cass | Michigan | 26027 | 78 | 2 |
176655 | 176655 | 2020-05-25 | Cass | Michigan | 26027 | 77 | 2 |
173612 | 173612 | 2020-05-24 | Cass | Michigan | 26027 | 77 | 2 |
170570 | 170570 | 2020-05-23 | Cass | Michigan | 26027 | 76 | 2 |
167533 | 167533 | 2020-05-22 | Cass | Michigan | 26027 | 73 | 2 |
164497 | 164497 | 2020-05-21 | Cass | Michigan | 26027 | 68 | 2 |
161468 | 161468 | 2020-05-20 | Cass | Michigan | 26027 | 66 | 2 |
158442 | 158442 | 2020-05-19 | Cass | Michigan | 26027 | 61 | 2 |
155424 | 155424 | 2020-05-18 | Cass | Michigan | 26027 | 60 | 2 |
152410 | 152410 | 2020-05-17 | Cass | Michigan | 26027 | 59 | 2 |
149399 | 149399 | 2020-05-16 | Cass | Michigan | 26027 | 53 | 2 |
146394 | 146394 | 2020-05-15 | Cass | Michigan | 26027 | 50 | 2 |
143394 | 143394 | 2020-05-14 | Cass | Michigan | 26027 | 46 | 2 |
140399 | 140399 | 2020-05-13 | Cass | Michigan | 26027 | 44 | 2 |
137405 | 137405 | 2020-05-12 | Cass | Michigan | 26027 | 43 | 2 |
134415 | 134415 | 2020-05-11 | Cass | Michigan | 26027 | 42 | 2 |
131424 | 131424 | 2020-05-10 | Cass | Michigan | 26027 | 41 | 2 |
128434 | 128434 | 2020-05-09 | Cass | Michigan | 26027 | 41 | 2 |
125447 | 125447 | 2020-05-08 | Cass | Michigan | 26027 | 39 | 2 |
122465 | 122465 | 2020-05-07 | Cass | Michigan | 26027 | 36 | 2 |
119493 | 119493 | 2020-05-06 | Cass | Michigan | 26027 | 35 | 2 |
116532 | 116532 | 2020-05-05 | Cass | Michigan | 26027 | 34 | 2 |
113651 | 113651 | 2020-05-04 | Cass | Michigan | 26027 | 33 | 2 |
110773 | 110773 | 2020-05-03 | Cass | Michigan | 26027 | 32 | 2 |
107901 | 107901 | 2020-05-02 | Cass | Michigan | 26027 | 33 | 2 |
105037 | 105037 | 2020-05-01 | Cass | Michigan | 26027 | 30 | 2 |
102177 | 102177 | 2020-04-30 | Cass | Michigan | 26027 | 31 | 2 |
99325 | 99325 | 2020-04-29 | Cass | Michigan | 26027 | 29 | 2 |
96479 | 96479 | 2020-04-28 | Cass | Michigan | 26027 | 27 | 2 |
93644 | 93644 | 2020-04-27 | Cass | Michigan | 26027 | 27 | 2 |
90823 | 90823 | 2020-04-26 | Cass | Michigan | 26027 | 26 | 2 |
88007 | 88007 | 2020-04-25 | Cass | Michigan | 26027 | 26 | 2 |
85197 | 85197 | 2020-04-24 | Cass | Michigan | 26027 | 25 | 2 |
82393 | 82393 | 2020-04-23 | Cass | Michigan | 26027 | 23 | 2 |
79598 | 79598 | 2020-04-22 | Cass | Michigan | 26027 | 23 | 1 |
76812 | 76812 | 2020-04-21 | Cass | Michigan | 26027 | 22 | 1 |
74032 | 74032 | 2020-04-20 | Cass | Michigan | 26027 | 22 | 1 |
71260 | 71260 | 2020-04-19 | Cass | Michigan | 26027 | 22 | 1 |
68496 | 68496 | 2020-04-18 | Cass | Michigan | 26027 | 22 | 1 |
65745 | 65745 | 2020-04-17 | Cass | Michigan | 26027 | 22 | 1 |
63007 | 63007 | 2020-04-16 | Cass | Michigan | 26027 | 19 | 1 |
60285 | 60285 | 2020-04-15 | Cass | Michigan | 26027 | 17 | 1 |
57575 | 57575 | 2020-04-14 | Cass | Michigan | 26027 | 13 | 1 |
54877 | 54877 | 2020-04-13 | Cass | Michigan | 26027 | 12 | 1 |
52196 | 52196 | 2020-04-12 | Cass | Michigan | 26027 | 12 | 1 |
49526 | 49526 | 2020-04-11 | Cass | Michigan | 26027 | 12 | 1 |
46883 | 46883 | 2020-04-10 | Cass | Michigan | 26027 | 12 | 1 |
44275 | 44275 | 2020-04-09 | Cass | Michigan | 26027 | 10 | 1 |
41699 | 41699 | 2020-04-08 | Cass | Michigan | 26027 | 9 | 1 |
39147 | 39147 | 2020-04-07 | Cass | Michigan | 26027 | 9 | 1 |
36639 | 36639 | 2020-04-06 | Cass | Michigan | 26027 | 7 | 1 |
34180 | 34180 | 2020-04-05 | Cass | Michigan | 26027 | 7 | 1 |
31755 | 31755 | 2020-04-04 | Cass | Michigan | 26027 | 6 | 1 |
29377 | 29377 | 2020-04-03 | Cass | Michigan | 26027 | 6 | 1 |
27059 | 27059 | 2020-04-02 | Cass | Michigan | 26027 | 6 | 1 |
24807 | 24807 | 2020-04-01 | Cass | Michigan | 26027 | 6 | 1 |
22628 | 22628 | 2020-03-31 | Cass | Michigan | 26027 | 4 | 1 |
20517 | 20517 | 2020-03-30 | Cass | Michigan | 26027 | 4 | 0 |
18500 | 18500 | 2020-03-29 | Cass | Michigan | 26027 | 4 | 0 |
16585 | 16585 | 2020-03-28 | Cass | Michigan | 26027 | 2 | 0 |
14765 | 14765 | 2020-03-27 | Cass | Michigan | 26027 | 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);