ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
444 rows where county = "Crawford" and deaths = 5 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
date (date) >30 ✖
- 2020-10-01 4
- 2020-10-02 4
- 2020-08-12 3
- 2020-08-13 3
- 2020-08-14 3
- 2020-08-15 3
- 2020-08-16 3
- 2020-08-17 3
- 2020-08-18 3
- 2020-08-19 3
- 2020-09-13 3
- 2020-09-14 3
- 2020-09-23 3
- 2020-09-24 3
- 2020-09-25 3
- 2020-09-26 3
- 2020-09-27 3
- 2020-09-28 3
- 2020-09-30 3
- 2020-10-03 3
- 2020-10-04 3
- 2020-10-05 3
- 2020-10-06 3
- 2020-10-07 3
- 2020-10-08 3
- 2020-06-14 2
- 2020-06-15 2
- 2020-06-16 2
- 2020-06-17 2
- 2020-06-18 2
- …
state 11
county 1
- Crawford · 444 ✖
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
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 |
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 |
304106 | 304106 | 2020-07-05 | Crawford | Michigan | 26039 | 70 | 5 |
307273 | 307273 | 2020-07-06 | Crawford | Michigan | 26039 | 70 | 5 |
285167 | 285167 | 2020-06-29 | Crawford | Michigan | 26039 | 71 | 5 |
310441 | 310441 | 2020-07-07 | Crawford | Michigan | 26039 | 81 | 5 |
313611 | 313611 | 2020-07-08 | Crawford | Michigan | 26039 | 81 | 5 |
316785 | 316785 | 2020-07-09 | Crawford | Michigan | 26039 | 81 | 5 |
319960 | 319960 | 2020-07-10 | Crawford | Michigan | 26039 | 82 | 5 |
323139 | 323139 | 2020-07-11 | Crawford | Michigan | 26039 | 82 | 5 |
329508 | 329508 | 2020-07-13 | Crawford | Michigan | 26039 | 84 | 5 |
332695 | 332695 | 2020-07-14 | Crawford | Michigan | 26039 | 84 | 5 |
335888 | 335888 | 2020-07-15 | Crawford | Michigan | 26039 | 84 | 5 |
339084 | 339084 | 2020-07-16 | Crawford | Michigan | 26039 | 84 | 5 |
326322 | 326322 | 2020-07-12 | Crawford | Michigan | 26039 | 86 | 5 |
342280 | 342280 | 2020-07-17 | Crawford | Michigan | 26039 | 86 | 5 |
345480 | 345480 | 2020-07-18 | Crawford | Michigan | 26039 | 86 | 5 |
348681 | 348681 | 2020-07-19 | Crawford | Michigan | 26039 | 86 | 5 |
351881 | 351881 | 2020-07-20 | Crawford | Michigan | 26039 | 86 | 5 |
355083 | 355083 | 2020-07-21 | Crawford | Michigan | 26039 | 90 | 5 |
358286 | 358286 | 2020-07-22 | Crawford | Michigan | 26039 | 92 | 5 |
361491 | 361491 | 2020-07-23 | Crawford | Michigan | 26039 | 92 | 5 |
364698 | 364698 | 2020-07-24 | Crawford | Michigan | 26039 | 93 | 5 |
377542 | 377542 | 2020-07-28 | Crawford | Michigan | 26039 | 93 | 5 |
380759 | 380759 | 2020-07-29 | Crawford | Michigan | 26039 | 93 | 5 |
383976 | 383976 | 2020-07-30 | Crawford | Michigan | 26039 | 93 | 5 |
367905 | 367905 | 2020-07-25 | Crawford | Michigan | 26039 | 94 | 5 |
371115 | 371115 | 2020-07-26 | Crawford | Michigan | 26039 | 94 | 5 |
374327 | 374327 | 2020-07-27 | Crawford | Michigan | 26039 | 94 | 5 |
387194 | 387194 | 2020-07-31 | Crawford | Michigan | 26039 | 94 | 5 |
390411 | 390411 | 2020-08-01 | Crawford | Michigan | 26039 | 95 | 5 |
393628 | 393628 | 2020-08-02 | Crawford | Michigan | 26039 | 97 | 5 |
396844 | 396844 | 2020-08-03 | Crawford | Michigan | 26039 | 99 | 5 |
400058 | 400058 | 2020-08-04 | Crawford | Michigan | 26039 | 101 | 5 |
403275 | 403275 | 2020-08-05 | Crawford | Michigan | 26039 | 103 | 5 |
406493 | 406493 | 2020-08-06 | Crawford | Michigan | 26039 | 103 | 5 |
409713 | 409713 | 2020-08-07 | Crawford | Michigan | 26039 | 105 | 5 |
412933 | 412933 | 2020-08-08 | Crawford | Michigan | 26039 | 106 | 5 |
416153 | 416153 | 2020-08-09 | Crawford | Michigan | 26039 | 106 | 5 |
419374 | 419374 | 2020-08-10 | Crawford | Michigan | 26039 | 107 | 5 |
422596 | 422596 | 2020-08-11 | Crawford | Michigan | 26039 | 107 | 5 |
425818 | 425818 | 2020-08-12 | Crawford | Michigan | 26039 | 107 | 5 |
429042 | 429042 | 2020-08-13 | Crawford | Michigan | 26039 | 107 | 5 |
432269 | 432269 | 2020-08-14 | Crawford | Michigan | 26039 | 108 | 5 |
435495 | 435495 | 2020-08-15 | Crawford | Michigan | 26039 | 109 | 5 |
438720 | 438720 | 2020-08-16 | Crawford | Michigan | 26039 | 110 | 5 |
441947 | 441947 | 2020-08-17 | Crawford | Michigan | 26039 | 110 | 5 |
445173 | 445173 | 2020-08-18 | Crawford | Michigan | 26039 | 111 | 5 |
448399 | 448399 | 2020-08-19 | Crawford | Michigan | 26039 | 111 | 5 |
451627 | 451627 | 2020-08-20 | Crawford | Michigan | 26039 | 111 | 5 |
454855 | 454855 | 2020-08-21 | Crawford | Michigan | 26039 | 111 | 5 |
458083 | 458083 | 2020-08-22 | Crawford | Michigan | 26039 | 112 | 5 |
461310 | 461310 | 2020-08-23 | Crawford | Michigan | 26039 | 112 | 5 |
464541 | 464541 | 2020-08-24 | Crawford | Michigan | 26039 | 113 | 5 |
467770 | 467770 | 2020-08-25 | Crawford | Michigan | 26039 | 113 | 5 |
471000 | 471000 | 2020-08-26 | Crawford | Michigan | 26039 | 113 | 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);