ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 39029 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
623981 | 623981 | 2020-10-12 | Columbiana | Ohio | 39029 | 2024 | 86 |
620738 | 620738 | 2020-10-11 | Columbiana | Ohio | 39029 | 2014 | 86 |
617496 | 617496 | 2020-10-10 | Columbiana | Ohio | 39029 | 2010 | 86 |
614254 | 614254 | 2020-10-09 | Columbiana | Ohio | 39029 | 2006 | 86 |
611013 | 611013 | 2020-10-08 | Columbiana | Ohio | 39029 | 2003 | 86 |
607771 | 607771 | 2020-10-07 | Columbiana | Ohio | 39029 | 1998 | 85 |
604528 | 604528 | 2020-10-06 | Columbiana | Ohio | 39029 | 1993 | 83 |
601286 | 601286 | 2020-10-05 | Columbiana | Ohio | 39029 | 1991 | 82 |
598043 | 598043 | 2020-10-04 | Columbiana | Ohio | 39029 | 1981 | 82 |
594800 | 594800 | 2020-10-03 | Columbiana | Ohio | 39029 | 1980 | 82 |
591559 | 591559 | 2020-10-02 | Columbiana | Ohio | 39029 | 1977 | 82 |
588318 | 588318 | 2020-10-01 | Columbiana | Ohio | 39029 | 1966 | 80 |
585078 | 585078 | 2020-09-30 | Columbiana | Ohio | 39029 | 1959 | 80 |
581838 | 581838 | 2020-09-29 | Columbiana | Ohio | 39029 | 1951 | 80 |
578598 | 578598 | 2020-09-28 | Columbiana | Ohio | 39029 | 1940 | 80 |
575357 | 575357 | 2020-09-27 | Columbiana | Ohio | 39029 | 1932 | 80 |
572113 | 572113 | 2020-09-26 | Columbiana | Ohio | 39029 | 1931 | 80 |
568871 | 568871 | 2020-09-25 | Columbiana | Ohio | 39029 | 1929 | 80 |
565630 | 565630 | 2020-09-24 | Columbiana | Ohio | 39029 | 1924 | 80 |
562389 | 562389 | 2020-09-23 | Columbiana | Ohio | 39029 | 1923 | 80 |
559152 | 559152 | 2020-09-22 | Columbiana | Ohio | 39029 | 1921 | 80 |
555915 | 555915 | 2020-09-21 | Columbiana | Ohio | 39029 | 1920 | 80 |
552678 | 552678 | 2020-09-20 | Columbiana | Ohio | 39029 | 1919 | 80 |
549439 | 549439 | 2020-09-19 | Columbiana | Ohio | 39029 | 1918 | 80 |
546200 | 546200 | 2020-09-18 | Columbiana | Ohio | 39029 | 1914 | 80 |
542963 | 542963 | 2020-09-17 | Columbiana | Ohio | 39029 | 1907 | 78 |
539727 | 539727 | 2020-09-16 | Columbiana | Ohio | 39029 | 1900 | 78 |
536490 | 536490 | 2020-09-15 | Columbiana | Ohio | 39029 | 1900 | 71 |
533254 | 533254 | 2020-09-14 | Columbiana | Ohio | 39029 | 1897 | 71 |
530019 | 530019 | 2020-09-13 | Columbiana | Ohio | 39029 | 1895 | 71 |
526782 | 526782 | 2020-09-12 | Columbiana | Ohio | 39029 | 1893 | 71 |
523546 | 523546 | 2020-09-11 | Columbiana | Ohio | 39029 | 1891 | 71 |
520310 | 520310 | 2020-09-10 | Columbiana | Ohio | 39029 | 1889 | 71 |
517074 | 517074 | 2020-09-09 | Columbiana | Ohio | 39029 | 1878 | 69 |
513839 | 513839 | 2020-09-08 | Columbiana | Ohio | 39029 | 1876 | 69 |
510606 | 510606 | 2020-09-07 | Columbiana | Ohio | 39029 | 1870 | 68 |
507373 | 507373 | 2020-09-06 | Columbiana | Ohio | 39029 | 1867 | 68 |
504141 | 504141 | 2020-09-05 | Columbiana | Ohio | 39029 | 1866 | 68 |
500907 | 500907 | 2020-09-04 | Columbiana | Ohio | 39029 | 1865 | 68 |
497673 | 497673 | 2020-09-03 | Columbiana | Ohio | 39029 | 1849 | 66 |
494440 | 494440 | 2020-09-02 | Columbiana | Ohio | 39029 | 1843 | 66 |
491206 | 491206 | 2020-09-01 | Columbiana | Ohio | 39029 | 1841 | 66 |
487973 | 487973 | 2020-08-31 | Columbiana | Ohio | 39029 | 1828 | 64 |
484740 | 484740 | 2020-08-30 | Columbiana | Ohio | 39029 | 1820 | 64 |
481505 | 481505 | 2020-08-29 | Columbiana | Ohio | 39029 | 1814 | 64 |
478271 | 478271 | 2020-08-28 | Columbiana | Ohio | 39029 | 1798 | 64 |
475038 | 475038 | 2020-08-27 | Columbiana | Ohio | 39029 | 1786 | 64 |
471804 | 471804 | 2020-08-26 | Columbiana | Ohio | 39029 | 1781 | 63 |
468572 | 468572 | 2020-08-25 | Columbiana | Ohio | 39029 | 1773 | 63 |
465344 | 465344 | 2020-08-24 | Columbiana | Ohio | 39029 | 1771 | 63 |
462115 | 462115 | 2020-08-23 | Columbiana | Ohio | 39029 | 1765 | 63 |
458887 | 458887 | 2020-08-22 | Columbiana | Ohio | 39029 | 1761 | 63 |
455659 | 455659 | 2020-08-21 | Columbiana | Ohio | 39029 | 1755 | 63 |
452431 | 452431 | 2020-08-20 | Columbiana | Ohio | 39029 | 1746 | 63 |
449203 | 449203 | 2020-08-19 | Columbiana | Ohio | 39029 | 1737 | 62 |
445975 | 445975 | 2020-08-18 | Columbiana | Ohio | 39029 | 1733 | 62 |
442749 | 442749 | 2020-08-17 | Columbiana | Ohio | 39029 | 1729 | 62 |
439522 | 439522 | 2020-08-16 | Columbiana | Ohio | 39029 | 1721 | 62 |
436297 | 436297 | 2020-08-15 | Columbiana | Ohio | 39029 | 1712 | 62 |
433071 | 433071 | 2020-08-14 | Columbiana | Ohio | 39029 | 1704 | 61 |
429845 | 429845 | 2020-08-13 | Columbiana | Ohio | 39029 | 1699 | 60 |
426620 | 426620 | 2020-08-12 | Columbiana | Ohio | 39029 | 1683 | 60 |
423397 | 423397 | 2020-08-11 | Columbiana | Ohio | 39029 | 1671 | 60 |
420174 | 420174 | 2020-08-10 | Columbiana | Ohio | 39029 | 1665 | 60 |
416954 | 416954 | 2020-08-09 | Columbiana | Ohio | 39029 | 1658 | 60 |
413733 | 413733 | 2020-08-08 | Columbiana | Ohio | 39029 | 1656 | 60 |
410513 | 410513 | 2020-08-07 | Columbiana | Ohio | 39029 | 1634 | 60 |
407293 | 407293 | 2020-08-06 | Columbiana | Ohio | 39029 | 1618 | 60 |
404074 | 404074 | 2020-08-05 | Columbiana | Ohio | 39029 | 1607 | 60 |
400856 | 400856 | 2020-08-04 | Columbiana | Ohio | 39029 | 1583 | 60 |
397641 | 397641 | 2020-08-03 | Columbiana | Ohio | 39029 | 1582 | 60 |
394424 | 394424 | 2020-08-02 | Columbiana | Ohio | 39029 | 1570 | 60 |
391208 | 391208 | 2020-08-01 | Columbiana | Ohio | 39029 | 1566 | 60 |
387991 | 387991 | 2020-07-31 | Columbiana | Ohio | 39029 | 1565 | 60 |
384774 | 384774 | 2020-07-30 | Columbiana | Ohio | 39029 | 1547 | 60 |
381556 | 381556 | 2020-07-29 | Columbiana | Ohio | 39029 | 1523 | 60 |
378339 | 378339 | 2020-07-28 | Columbiana | Ohio | 39029 | 1510 | 60 |
375122 | 375122 | 2020-07-27 | Columbiana | Ohio | 39029 | 1507 | 60 |
371910 | 371910 | 2020-07-26 | Columbiana | Ohio | 39029 | 1492 | 60 |
368698 | 368698 | 2020-07-25 | Columbiana | Ohio | 39029 | 1489 | 60 |
365489 | 365489 | 2020-07-24 | Columbiana | Ohio | 39029 | 1486 | 60 |
362283 | 362283 | 2020-07-23 | Columbiana | Ohio | 39029 | 1483 | 60 |
359077 | 359077 | 2020-07-22 | Columbiana | Ohio | 39029 | 1477 | 62 |
355873 | 355873 | 2020-07-21 | Columbiana | Ohio | 39029 | 1469 | 62 |
352670 | 352670 | 2020-07-20 | Columbiana | Ohio | 39029 | 1467 | 62 |
349467 | 349467 | 2020-07-19 | Columbiana | Ohio | 39029 | 1458 | 62 |
346266 | 346266 | 2020-07-18 | Columbiana | Ohio | 39029 | 1451 | 60 |
343067 | 343067 | 2020-07-17 | Columbiana | Ohio | 39029 | 1433 | 60 |
339869 | 339869 | 2020-07-16 | Columbiana | Ohio | 39029 | 1418 | 60 |
336673 | 336673 | 2020-07-15 | Columbiana | Ohio | 39029 | 1411 | 60 |
333479 | 333479 | 2020-07-14 | Columbiana | Ohio | 39029 | 1405 | 60 |
330287 | 330287 | 2020-07-13 | Columbiana | Ohio | 39029 | 1395 | 60 |
327100 | 327100 | 2020-07-12 | Columbiana | Ohio | 39029 | 1385 | 60 |
323915 | 323915 | 2020-07-11 | Columbiana | Ohio | 39029 | 1378 | 60 |
320735 | 320735 | 2020-07-10 | Columbiana | Ohio | 39029 | 1350 | 60 |
317558 | 317558 | 2020-07-09 | Columbiana | Ohio | 39029 | 1324 | 60 |
314385 | 314385 | 2020-07-08 | Columbiana | Ohio | 39029 | 1309 | 60 |
311213 | 311213 | 2020-07-07 | Columbiana | Ohio | 39029 | 1306 | 60 |
308044 | 308044 | 2020-07-06 | Columbiana | Ohio | 39029 | 1307 | 60 |
304877 | 304877 | 2020-07-05 | Columbiana | Ohio | 39029 | 1303 | 60 |
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);