ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
44 rows where county = "Belmont" and deaths = 26 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 |
---|---|---|---|---|---|---|---|
497665 | 497665 | 2020-09-03 | Belmont | Ohio | 39013 | 687 | 26 |
494432 | 494432 | 2020-09-02 | Belmont | Ohio | 39013 | 685 | 26 |
491198 | 491198 | 2020-09-01 | Belmont | Ohio | 39013 | 684 | 26 |
487965 | 487965 | 2020-08-31 | Belmont | Ohio | 39013 | 682 | 26 |
484732 | 484732 | 2020-08-30 | Belmont | Ohio | 39013 | 682 | 26 |
481497 | 481497 | 2020-08-29 | Belmont | Ohio | 39013 | 681 | 26 |
478263 | 478263 | 2020-08-28 | Belmont | Ohio | 39013 | 677 | 26 |
475030 | 475030 | 2020-08-27 | Belmont | Ohio | 39013 | 677 | 26 |
471796 | 471796 | 2020-08-26 | Belmont | Ohio | 39013 | 676 | 26 |
468564 | 468564 | 2020-08-25 | Belmont | Ohio | 39013 | 676 | 26 |
465336 | 465336 | 2020-08-24 | Belmont | Ohio | 39013 | 674 | 26 |
462107 | 462107 | 2020-08-23 | Belmont | Ohio | 39013 | 672 | 26 |
458879 | 458879 | 2020-08-22 | Belmont | Ohio | 39013 | 672 | 26 |
455651 | 455651 | 2020-08-21 | Belmont | Ohio | 39013 | 671 | 26 |
452423 | 452423 | 2020-08-20 | Belmont | Ohio | 39013 | 666 | 26 |
449195 | 449195 | 2020-08-19 | Belmont | Ohio | 39013 | 649 | 26 |
445967 | 445967 | 2020-08-18 | Belmont | Ohio | 39013 | 644 | 26 |
442741 | 442741 | 2020-08-17 | Belmont | Ohio | 39013 | 640 | 26 |
439514 | 439514 | 2020-08-16 | Belmont | Ohio | 39013 | 638 | 26 |
436289 | 436289 | 2020-08-15 | Belmont | Ohio | 39013 | 638 | 26 |
433063 | 433063 | 2020-08-14 | Belmont | Ohio | 39013 | 629 | 26 |
429837 | 429837 | 2020-08-13 | Belmont | Ohio | 39013 | 628 | 26 |
426612 | 426612 | 2020-08-12 | Belmont | Ohio | 39013 | 627 | 26 |
423389 | 423389 | 2020-08-11 | Belmont | Ohio | 39013 | 623 | 26 |
420166 | 420166 | 2020-08-10 | Belmont | Ohio | 39013 | 621 | 26 |
416946 | 416946 | 2020-08-09 | Belmont | Ohio | 39013 | 621 | 26 |
413725 | 413725 | 2020-08-08 | Belmont | Ohio | 39013 | 621 | 26 |
410505 | 410505 | 2020-08-07 | Belmont | Ohio | 39013 | 614 | 26 |
407285 | 407285 | 2020-08-06 | Belmont | Ohio | 39013 | 592 | 26 |
404066 | 404066 | 2020-08-05 | Belmont | Ohio | 39013 | 591 | 26 |
400848 | 400848 | 2020-08-04 | Belmont | Ohio | 39013 | 590 | 26 |
397633 | 397633 | 2020-08-03 | Belmont | Ohio | 39013 | 589 | 26 |
394416 | 394416 | 2020-08-02 | Belmont | Ohio | 39013 | 589 | 26 |
391200 | 391200 | 2020-08-01 | Belmont | Ohio | 39013 | 589 | 26 |
387983 | 387983 | 2020-07-31 | Belmont | Ohio | 39013 | 589 | 26 |
384766 | 384766 | 2020-07-30 | Belmont | Ohio | 39013 | 588 | 26 |
381548 | 381548 | 2020-07-29 | Belmont | Ohio | 39013 | 588 | 26 |
378331 | 378331 | 2020-07-28 | Belmont | Ohio | 39013 | 586 | 26 |
375114 | 375114 | 2020-07-27 | Belmont | Ohio | 39013 | 585 | 26 |
371902 | 371902 | 2020-07-26 | Belmont | Ohio | 39013 | 584 | 26 |
368690 | 368690 | 2020-07-25 | Belmont | Ohio | 39013 | 584 | 26 |
365481 | 365481 | 2020-07-24 | Belmont | Ohio | 39013 | 578 | 26 |
362275 | 362275 | 2020-07-23 | Belmont | Ohio | 39013 | 578 | 26 |
359069 | 359069 | 2020-07-22 | Belmont | Ohio | 39013 | 578 | 26 |
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);