ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where county = "Crawford" and state = "Michigan" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-03-27 1
- 2020-03-28 1
- 2020-03-29 1
- 2020-03-30 1
- 2020-03-31 1
- 2020-04-01 1
- 2020-04-02 1
- 2020-04-03 1
- 2020-04-04 1
- 2020-04-05 1
- 2020-04-06 1
- 2020-04-07 1
- 2020-04-08 1
- 2020-04-09 1
- 2020-04-10 1
- 2020-04-11 1
- 2020-04-12 1
- 2020-04-13 1
- 2020-04-14 1
- 2020-04-15 1
- 2020-04-16 1
- 2020-04-17 1
- 2020-04-18 1
- 2020-04-19 1
- 2020-04-20 1
- 2020-04-21 1
- 2020-04-22 1
- 2020-04-23 1
- 2020-04-24 1
- 2020-04-25 1
- …
state 1
- Michigan · 778 ✖
fips 1
- 26039 778
county 1
- Crawford · 778 ✖
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
14770 | 14770 | 2020-03-27 | Crawford | Michigan | 26039 | 1 | 0 |
16590 | 16590 | 2020-03-28 | Crawford | Michigan | 26039 | 1 | 0 |
18506 | 18506 | 2020-03-29 | Crawford | Michigan | 26039 | 1 | 0 |
20523 | 20523 | 2020-03-30 | Crawford | Michigan | 26039 | 1 | 0 |
22634 | 22634 | 2020-03-31 | Crawford | Michigan | 26039 | 1 | 0 |
24813 | 24813 | 2020-04-01 | Crawford | Michigan | 26039 | 1 | 0 |
27065 | 27065 | 2020-04-02 | Crawford | Michigan | 26039 | 1 | 0 |
29383 | 29383 | 2020-04-03 | Crawford | Michigan | 26039 | 1 | 0 |
31761 | 31761 | 2020-04-04 | Crawford | Michigan | 26039 | 1 | 0 |
34186 | 34186 | 2020-04-05 | Crawford | Michigan | 26039 | 1 | 0 |
36645 | 36645 | 2020-04-06 | Crawford | Michigan | 26039 | 2 | 0 |
39153 | 39153 | 2020-04-07 | Crawford | Michigan | 26039 | 5 | 1 |
41705 | 41705 | 2020-04-08 | Crawford | Michigan | 26039 | 5 | 1 |
44281 | 44281 | 2020-04-09 | Crawford | Michigan | 26039 | 5 | 1 |
46889 | 46889 | 2020-04-10 | Crawford | Michigan | 26039 | 5 | 1 |
49532 | 49532 | 2020-04-11 | Crawford | Michigan | 26039 | 8 | 1 |
52202 | 52202 | 2020-04-12 | Crawford | Michigan | 26039 | 12 | 1 |
54883 | 54883 | 2020-04-13 | Crawford | Michigan | 26039 | 12 | 1 |
57581 | 57581 | 2020-04-14 | Crawford | Michigan | 26039 | 15 | 1 |
60291 | 60291 | 2020-04-15 | Crawford | Michigan | 26039 | 16 | 1 |
63013 | 63013 | 2020-04-16 | Crawford | Michigan | 26039 | 18 | 1 |
65751 | 65751 | 2020-04-17 | Crawford | Michigan | 26039 | 22 | 2 |
68502 | 68502 | 2020-04-18 | Crawford | Michigan | 26039 | 26 | 2 |
71266 | 71266 | 2020-04-19 | Crawford | Michigan | 26039 | 29 | 2 |
74038 | 74038 | 2020-04-20 | Crawford | Michigan | 26039 | 29 | 2 |
76818 | 76818 | 2020-04-21 | Crawford | Michigan | 26039 | 30 | 2 |
79604 | 79604 | 2020-04-22 | Crawford | Michigan | 26039 | 32 | 2 |
82399 | 82399 | 2020-04-23 | Crawford | Michigan | 26039 | 43 | 2 |
85203 | 85203 | 2020-04-24 | Crawford | Michigan | 26039 | 46 | 3 |
88013 | 88013 | 2020-04-25 | Crawford | Michigan | 26039 | 45 | 3 |
90829 | 90829 | 2020-04-26 | Crawford | Michigan | 26039 | 46 | 3 |
93650 | 93650 | 2020-04-27 | Crawford | Michigan | 26039 | 50 | 3 |
96485 | 96485 | 2020-04-28 | Crawford | Michigan | 26039 | 51 | 4 |
99331 | 99331 | 2020-04-29 | Crawford | Michigan | 26039 | 54 | 4 |
102183 | 102183 | 2020-04-30 | Crawford | Michigan | 26039 | 54 | 4 |
105043 | 105043 | 2020-05-01 | Crawford | Michigan | 26039 | 53 | 4 |
107907 | 107907 | 2020-05-02 | Crawford | Michigan | 26039 | 57 | 4 |
110779 | 110779 | 2020-05-03 | Crawford | Michigan | 26039 | 56 | 4 |
113657 | 113657 | 2020-05-04 | Crawford | Michigan | 26039 | 56 | 4 |
116538 | 116538 | 2020-05-05 | Crawford | Michigan | 26039 | 56 | 4 |
119499 | 119499 | 2020-05-06 | Crawford | Michigan | 26039 | 56 | 4 |
122471 | 122471 | 2020-05-07 | Crawford | Michigan | 26039 | 56 | 4 |
125453 | 125453 | 2020-05-08 | Crawford | Michigan | 26039 | 56 | 4 |
128440 | 128440 | 2020-05-09 | Crawford | Michigan | 26039 | 57 | 4 |
131430 | 131430 | 2020-05-10 | Crawford | Michigan | 26039 | 57 | 4 |
134421 | 134421 | 2020-05-11 | Crawford | Michigan | 26039 | 57 | 4 |
137411 | 137411 | 2020-05-12 | Crawford | Michigan | 26039 | 57 | 4 |
140405 | 140405 | 2020-05-13 | Crawford | Michigan | 26039 | 57 | 4 |
143400 | 143400 | 2020-05-14 | Crawford | Michigan | 26039 | 57 | 4 |
146400 | 146400 | 2020-05-15 | Crawford | Michigan | 26039 | 57 | 4 |
149405 | 149405 | 2020-05-16 | Crawford | Michigan | 26039 | 57 | 4 |
152416 | 152416 | 2020-05-17 | Crawford | Michigan | 26039 | 57 | 4 |
155430 | 155430 | 2020-05-18 | Crawford | Michigan | 26039 | 57 | 4 |
158448 | 158448 | 2020-05-19 | Crawford | Michigan | 26039 | 57 | 5 |
161474 | 161474 | 2020-05-20 | Crawford | Michigan | 26039 | 58 | 5 |
164503 | 164503 | 2020-05-21 | Crawford | Michigan | 26039 | 58 | 5 |
167539 | 167539 | 2020-05-22 | Crawford | Michigan | 26039 | 58 | 5 |
170576 | 170576 | 2020-05-23 | Crawford | Michigan | 26039 | 58 | 5 |
173618 | 173618 | 2020-05-24 | Crawford | Michigan | 26039 | 58 | 5 |
176661 | 176661 | 2020-05-25 | Crawford | Michigan | 26039 | 58 | 5 |
179705 | 179705 | 2020-05-26 | Crawford | Michigan | 26039 | 58 | 5 |
182751 | 182751 | 2020-05-27 | Crawford | Michigan | 26039 | 58 | 5 |
185806 | 185806 | 2020-05-28 | Crawford | Michigan | 26039 | 58 | 5 |
188864 | 188864 | 2020-05-29 | Crawford | Michigan | 26039 | 58 | 5 |
191928 | 191928 | 2020-05-30 | Crawford | Michigan | 26039 | 58 | 5 |
194996 | 194996 | 2020-05-31 | Crawford | Michigan | 26039 | 58 | 5 |
198067 | 198067 | 2020-06-01 | Crawford | Michigan | 26039 | 62 | 5 |
201139 | 201139 | 2020-06-02 | Crawford | Michigan | 26039 | 62 | 5 |
204216 | 204216 | 2020-06-03 | Crawford | Michigan | 26039 | 63 | 5 |
207297 | 207297 | 2020-06-04 | Crawford | Michigan | 26039 | 63 | 5 |
210378 | 210378 | 2020-06-05 | Crawford | Michigan | 26039 | 63 | 5 |
213462 | 213462 | 2020-06-06 | Crawford | Michigan | 26039 | 63 | 5 |
216550 | 216550 | 2020-06-07 | Crawford | Michigan | 26039 | 63 | 5 |
219642 | 219642 | 2020-06-08 | Crawford | Michigan | 26039 | 63 | 5 |
222737 | 222737 | 2020-06-09 | Crawford | Michigan | 26039 | 63 | 5 |
225834 | 225834 | 2020-06-10 | Crawford | Michigan | 26039 | 63 | 5 |
228936 | 228936 | 2020-06-11 | Crawford | Michigan | 26039 | 63 | 5 |
232040 | 232040 | 2020-06-12 | Crawford | Michigan | 26039 | 63 | 5 |
235145 | 235145 | 2020-06-13 | Crawford | Michigan | 26039 | 63 | 5 |
238252 | 238252 | 2020-06-14 | Crawford | Michigan | 26039 | 63 | 5 |
241361 | 241361 | 2020-06-15 | Crawford | Michigan | 26039 | 65 | 5 |
244472 | 244472 | 2020-06-16 | Crawford | Michigan | 26039 | 65 | 5 |
247585 | 247585 | 2020-06-17 | Crawford | Michigan | 26039 | 65 | 5 |
250697 | 250697 | 2020-06-18 | Crawford | Michigan | 26039 | 65 | 5 |
253812 | 253812 | 2020-06-19 | Crawford | Michigan | 26039 | 66 | 5 |
256932 | 256932 | 2020-06-20 | Crawford | Michigan | 26039 | 66 | 5 |
260058 | 260058 | 2020-06-21 | Crawford | Michigan | 26039 | 66 | 5 |
263187 | 263187 | 2020-06-22 | Crawford | Michigan | 26039 | 66 | 5 |
266313 | 266313 | 2020-06-23 | Crawford | Michigan | 26039 | 66 | 5 |
269446 | 269446 | 2020-06-24 | Crawford | Michigan | 26039 | 68 | 5 |
272583 | 272583 | 2020-06-25 | Crawford | Michigan | 26039 | 68 | 5 |
275726 | 275726 | 2020-06-26 | Crawford | Michigan | 26039 | 68 | 5 |
278874 | 278874 | 2020-06-27 | Crawford | Michigan | 26039 | 68 | 5 |
282022 | 282022 | 2020-06-28 | Crawford | Michigan | 26039 | 68 | 5 |
285167 | 285167 | 2020-06-29 | Crawford | Michigan | 26039 | 71 | 5 |
288317 | 288317 | 2020-06-30 | Crawford | Michigan | 26039 | 70 | 5 |
291468 | 291468 | 2020-07-01 | Crawford | Michigan | 26039 | 70 | 5 |
294622 | 294622 | 2020-07-02 | Crawford | Michigan | 26039 | 70 | 5 |
297780 | 297780 | 2020-07-03 | Crawford | Michigan | 26039 | 70 | 5 |
300942 | 300942 | 2020-07-04 | Crawford | Michigan | 26039 | 70 | 5 |
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);