ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where deaths = 29 and fips = 26157 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535740 | 535740 | 2020-09-15 | Tuscola | Michigan | 26157 | 474 | 29 |
532505 | 532505 | 2020-09-14 | Tuscola | Michigan | 26157 | 473 | 29 |
529269 | 529269 | 2020-09-13 | Tuscola | Michigan | 26157 | 471 | 29 |
526033 | 526033 | 2020-09-12 | Tuscola | Michigan | 26157 | 471 | 29 |
522797 | 522797 | 2020-09-11 | Tuscola | Michigan | 26157 | 469 | 29 |
519560 | 519560 | 2020-09-10 | Tuscola | Michigan | 26157 | 473 | 29 |
516325 | 516325 | 2020-09-09 | Tuscola | Michigan | 26157 | 469 | 29 |
513091 | 513091 | 2020-09-08 | Tuscola | Michigan | 26157 | 469 | 29 |
509859 | 509859 | 2020-09-07 | Tuscola | Michigan | 26157 | 469 | 29 |
506626 | 506626 | 2020-09-06 | Tuscola | Michigan | 26157 | 467 | 29 |
503393 | 503393 | 2020-09-05 | Tuscola | Michigan | 26157 | 467 | 29 |
500159 | 500159 | 2020-09-04 | Tuscola | Michigan | 26157 | 466 | 29 |
496925 | 496925 | 2020-09-03 | Tuscola | Michigan | 26157 | 462 | 29 |
493692 | 493692 | 2020-09-02 | Tuscola | Michigan | 26157 | 459 | 29 |
490458 | 490458 | 2020-09-01 | Tuscola | Michigan | 26157 | 455 | 29 |
487225 | 487225 | 2020-08-31 | Tuscola | Michigan | 26157 | 454 | 29 |
483991 | 483991 | 2020-08-30 | Tuscola | Michigan | 26157 | 451 | 29 |
480756 | 480756 | 2020-08-29 | Tuscola | Michigan | 26157 | 446 | 29 |
477524 | 477524 | 2020-08-28 | Tuscola | Michigan | 26157 | 442 | 29 |
474291 | 474291 | 2020-08-27 | Tuscola | Michigan | 26157 | 432 | 29 |
471059 | 471059 | 2020-08-26 | Tuscola | Michigan | 26157 | 431 | 29 |
467829 | 467829 | 2020-08-25 | Tuscola | Michigan | 26157 | 427 | 29 |
464600 | 464600 | 2020-08-24 | Tuscola | Michigan | 26157 | 422 | 29 |
461369 | 461369 | 2020-08-23 | Tuscola | Michigan | 26157 | 417 | 29 |
458142 | 458142 | 2020-08-22 | Tuscola | Michigan | 26157 | 415 | 29 |
454914 | 454914 | 2020-08-21 | Tuscola | Michigan | 26157 | 394 | 29 |
451686 | 451686 | 2020-08-20 | Tuscola | Michigan | 26157 | 394 | 29 |
448458 | 448458 | 2020-08-19 | Tuscola | Michigan | 26157 | 392 | 29 |
445232 | 445232 | 2020-08-18 | Tuscola | Michigan | 26157 | 391 | 29 |
442006 | 442006 | 2020-08-17 | Tuscola | Michigan | 26157 | 386 | 29 |
438779 | 438779 | 2020-08-16 | Tuscola | Michigan | 26157 | 385 | 29 |
435554 | 435554 | 2020-08-15 | Tuscola | Michigan | 26157 | 383 | 29 |
432328 | 432328 | 2020-08-14 | Tuscola | Michigan | 26157 | 377 | 29 |
429101 | 429101 | 2020-08-13 | Tuscola | Michigan | 26157 | 367 | 29 |
425877 | 425877 | 2020-08-12 | Tuscola | Michigan | 26157 | 362 | 29 |
422655 | 422655 | 2020-08-11 | Tuscola | Michigan | 26157 | 356 | 29 |
419433 | 419433 | 2020-08-10 | Tuscola | Michigan | 26157 | 356 | 29 |
416212 | 416212 | 2020-08-09 | Tuscola | Michigan | 26157 | 350 | 29 |
412992 | 412992 | 2020-08-08 | Tuscola | Michigan | 26157 | 342 | 29 |
409772 | 409772 | 2020-08-07 | Tuscola | Michigan | 26157 | 334 | 29 |
406552 | 406552 | 2020-08-06 | Tuscola | Michigan | 26157 | 330 | 29 |
403334 | 403334 | 2020-08-05 | Tuscola | Michigan | 26157 | 324 | 29 |
400117 | 400117 | 2020-08-04 | Tuscola | Michigan | 26157 | 322 | 29 |
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);