ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Gratiot" and state = "Michigan" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14777 | 14777 | 2020-03-27 | Gratiot | Michigan | 26057 | 1 | 0 |
16597 | 16597 | 2020-03-28 | Gratiot | Michigan | 26057 | 2 | 0 |
18513 | 18513 | 2020-03-29 | Gratiot | Michigan | 26057 | 3 | 0 |
20531 | 20531 | 2020-03-30 | Gratiot | Michigan | 26057 | 3 | 0 |
22642 | 22642 | 2020-03-31 | Gratiot | Michigan | 26057 | 3 | 0 |
24821 | 24821 | 2020-04-01 | Gratiot | Michigan | 26057 | 3 | 0 |
27074 | 27074 | 2020-04-02 | Gratiot | Michigan | 26057 | 5 | 0 |
29392 | 29392 | 2020-04-03 | Gratiot | Michigan | 26057 | 5 | 0 |
31770 | 31770 | 2020-04-04 | Gratiot | Michigan | 26057 | 5 | 0 |
34195 | 34195 | 2020-04-05 | Gratiot | Michigan | 26057 | 4 | 0 |
36654 | 36654 | 2020-04-06 | Gratiot | Michigan | 26057 | 5 | 0 |
39162 | 39162 | 2020-04-07 | Gratiot | Michigan | 26057 | 6 | 0 |
41714 | 41714 | 2020-04-08 | Gratiot | Michigan | 26057 | 5 | 0 |
44290 | 44290 | 2020-04-09 | Gratiot | Michigan | 26057 | 6 | 0 |
46898 | 46898 | 2020-04-10 | Gratiot | Michigan | 26057 | 6 | 0 |
49541 | 49541 | 2020-04-11 | Gratiot | Michigan | 26057 | 7 | 0 |
52211 | 52211 | 2020-04-12 | Gratiot | Michigan | 26057 | 7 | 0 |
54892 | 54892 | 2020-04-13 | Gratiot | Michigan | 26057 | 7 | 0 |
57590 | 57590 | 2020-04-14 | Gratiot | Michigan | 26057 | 7 | 0 |
60300 | 60300 | 2020-04-15 | Gratiot | Michigan | 26057 | 7 | 0 |
63022 | 63022 | 2020-04-16 | Gratiot | Michigan | 26057 | 7 | 0 |
65760 | 65760 | 2020-04-17 | Gratiot | Michigan | 26057 | 7 | 0 |
68511 | 68511 | 2020-04-18 | Gratiot | Michigan | 26057 | 7 | 0 |
71275 | 71275 | 2020-04-19 | Gratiot | Michigan | 26057 | 8 | 1 |
74047 | 74047 | 2020-04-20 | Gratiot | Michigan | 26057 | 8 | 1 |
76827 | 76827 | 2020-04-21 | Gratiot | Michigan | 26057 | 8 | 1 |
79613 | 79613 | 2020-04-22 | Gratiot | Michigan | 26057 | 8 | 1 |
82408 | 82408 | 2020-04-23 | Gratiot | Michigan | 26057 | 8 | 1 |
85212 | 85212 | 2020-04-24 | Gratiot | Michigan | 26057 | 8 | 1 |
88022 | 88022 | 2020-04-25 | Gratiot | Michigan | 26057 | 8 | 1 |
90838 | 90838 | 2020-04-26 | Gratiot | Michigan | 26057 | 8 | 1 |
93659 | 93659 | 2020-04-27 | Gratiot | Michigan | 26057 | 10 | 1 |
96494 | 96494 | 2020-04-28 | Gratiot | Michigan | 26057 | 10 | 1 |
99340 | 99340 | 2020-04-29 | Gratiot | Michigan | 26057 | 13 | 1 |
102192 | 102192 | 2020-04-30 | Gratiot | Michigan | 26057 | 13 | 1 |
105052 | 105052 | 2020-05-01 | Gratiot | Michigan | 26057 | 21 | 1 |
107916 | 107916 | 2020-05-02 | Gratiot | Michigan | 26057 | 23 | 1 |
110788 | 110788 | 2020-05-03 | Gratiot | Michigan | 26057 | 26 | 2 |
113666 | 113666 | 2020-05-04 | Gratiot | Michigan | 26057 | 25 | 2 |
116547 | 116547 | 2020-05-05 | Gratiot | Michigan | 26057 | 26 | 2 |
119508 | 119508 | 2020-05-06 | Gratiot | Michigan | 26057 | 26 | 2 |
122480 | 122480 | 2020-05-07 | Gratiot | Michigan | 26057 | 27 | 2 |
125462 | 125462 | 2020-05-08 | Gratiot | Michigan | 26057 | 27 | 2 |
128449 | 128449 | 2020-05-09 | Gratiot | Michigan | 26057 | 29 | 3 |
131439 | 131439 | 2020-05-10 | Gratiot | Michigan | 26057 | 36 | 3 |
134430 | 134430 | 2020-05-11 | Gratiot | Michigan | 26057 | 38 | 4 |
137420 | 137420 | 2020-05-12 | Gratiot | Michigan | 26057 | 38 | 4 |
140414 | 140414 | 2020-05-13 | Gratiot | Michigan | 26057 | 39 | 4 |
143409 | 143409 | 2020-05-14 | Gratiot | Michigan | 26057 | 40 | 4 |
146409 | 146409 | 2020-05-15 | Gratiot | Michigan | 26057 | 40 | 4 |
149414 | 149414 | 2020-05-16 | Gratiot | Michigan | 26057 | 47 | 4 |
152425 | 152425 | 2020-05-17 | Gratiot | Michigan | 26057 | 47 | 4 |
155439 | 155439 | 2020-05-18 | Gratiot | Michigan | 26057 | 54 | 4 |
158457 | 158457 | 2020-05-19 | Gratiot | Michigan | 26057 | 55 | 4 |
161483 | 161483 | 2020-05-20 | Gratiot | Michigan | 26057 | 61 | 4 |
164512 | 164512 | 2020-05-21 | Gratiot | Michigan | 26057 | 62 | 4 |
167548 | 167548 | 2020-05-22 | Gratiot | Michigan | 26057 | 68 | 5 |
170585 | 170585 | 2020-05-23 | Gratiot | Michigan | 26057 | 72 | 5 |
173627 | 173627 | 2020-05-24 | Gratiot | Michigan | 26057 | 75 | 6 |
176670 | 176670 | 2020-05-25 | Gratiot | Michigan | 26057 | 77 | 6 |
179714 | 179714 | 2020-05-26 | Gratiot | Michigan | 26057 | 77 | 6 |
182760 | 182760 | 2020-05-27 | Gratiot | Michigan | 26057 | 80 | 8 |
185815 | 185815 | 2020-05-28 | Gratiot | Michigan | 26057 | 80 | 8 |
188873 | 188873 | 2020-05-29 | Gratiot | Michigan | 26057 | 80 | 8 |
191937 | 191937 | 2020-05-30 | Gratiot | Michigan | 26057 | 80 | 9 |
195005 | 195005 | 2020-05-31 | Gratiot | Michigan | 26057 | 80 | 10 |
198076 | 198076 | 2020-06-01 | Gratiot | Michigan | 26057 | 80 | 11 |
201148 | 201148 | 2020-06-02 | Gratiot | Michigan | 26057 | 82 | 11 |
204225 | 204225 | 2020-06-03 | Gratiot | Michigan | 26057 | 82 | 11 |
207306 | 207306 | 2020-06-04 | Gratiot | Michigan | 26057 | 82 | 11 |
210387 | 210387 | 2020-06-05 | Gratiot | Michigan | 26057 | 92 | 11 |
213471 | 213471 | 2020-06-06 | Gratiot | Michigan | 26057 | 94 | 11 |
216559 | 216559 | 2020-06-07 | Gratiot | Michigan | 26057 | 94 | 11 |
219651 | 219651 | 2020-06-08 | Gratiot | Michigan | 26057 | 94 | 11 |
222746 | 222746 | 2020-06-09 | Gratiot | Michigan | 26057 | 94 | 11 |
225843 | 225843 | 2020-06-10 | Gratiot | Michigan | 26057 | 94 | 11 |
228945 | 228945 | 2020-06-11 | Gratiot | Michigan | 26057 | 95 | 11 |
232049 | 232049 | 2020-06-12 | Gratiot | Michigan | 26057 | 94 | 12 |
235154 | 235154 | 2020-06-13 | Gratiot | Michigan | 26057 | 97 | 12 |
238261 | 238261 | 2020-06-14 | Gratiot | Michigan | 26057 | 97 | 12 |
241370 | 241370 | 2020-06-15 | Gratiot | Michigan | 26057 | 97 | 12 |
244481 | 244481 | 2020-06-16 | Gratiot | Michigan | 26057 | 97 | 12 |
247594 | 247594 | 2020-06-17 | Gratiot | Michigan | 26057 | 97 | 12 |
250706 | 250706 | 2020-06-18 | Gratiot | Michigan | 26057 | 98 | 12 |
253821 | 253821 | 2020-06-19 | Gratiot | Michigan | 26057 | 98 | 13 |
256941 | 256941 | 2020-06-20 | Gratiot | Michigan | 26057 | 99 | 13 |
260067 | 260067 | 2020-06-21 | Gratiot | Michigan | 26057 | 99 | 13 |
263196 | 263196 | 2020-06-22 | Gratiot | Michigan | 26057 | 99 | 13 |
266322 | 266322 | 2020-06-23 | Gratiot | Michigan | 26057 | 99 | 13 |
269455 | 269455 | 2020-06-24 | Gratiot | Michigan | 26057 | 99 | 13 |
272592 | 272592 | 2020-06-25 | Gratiot | Michigan | 26057 | 98 | 13 |
275735 | 275735 | 2020-06-26 | Gratiot | Michigan | 26057 | 98 | 13 |
278883 | 278883 | 2020-06-27 | Gratiot | Michigan | 26057 | 98 | 13 |
282031 | 282031 | 2020-06-28 | Gratiot | Michigan | 26057 | 98 | 13 |
285176 | 285176 | 2020-06-29 | Gratiot | Michigan | 26057 | 98 | 13 |
288326 | 288326 | 2020-06-30 | Gratiot | Michigan | 26057 | 98 | 13 |
291477 | 291477 | 2020-07-01 | Gratiot | Michigan | 26057 | 98 | 13 |
294631 | 294631 | 2020-07-02 | Gratiot | Michigan | 26057 | 98 | 13 |
297789 | 297789 | 2020-07-03 | Gratiot | Michigan | 26057 | 99 | 13 |
300951 | 300951 | 2020-07-04 | Gratiot | Michigan | 26057 | 99 | 13 |
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);