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 |
---|---|---|---|---|---|---|---|
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 |
301714 | 301714 | 2020-07-04 | Columbiana | Ohio | 39029 | 1295 | 60 |
298551 | 298551 | 2020-07-03 | Columbiana | Ohio | 39029 | 1288 | 60 |
295391 | 295391 | 2020-07-02 | Columbiana | Ohio | 39029 | 1209 | 60 |
292236 | 292236 | 2020-07-01 | Columbiana | Ohio | 39029 | 1209 | 60 |
289084 | 289084 | 2020-06-30 | Columbiana | Ohio | 39029 | 1205 | 60 |
285934 | 285934 | 2020-06-29 | Columbiana | Ohio | 39029 | 1202 | 59 |
282789 | 282789 | 2020-06-28 | Columbiana | Ohio | 39029 | 1197 | 59 |
279643 | 279643 | 2020-06-27 | Columbiana | Ohio | 39029 | 1093 | 59 |
276495 | 276495 | 2020-06-26 | Columbiana | Ohio | 39029 | 1087 | 59 |
273348 | 273348 | 2020-06-25 | Columbiana | Ohio | 39029 | 1033 | 59 |
270209 | 270209 | 2020-06-24 | Columbiana | Ohio | 39029 | 984 | 60 |
267075 | 267075 | 2020-06-23 | Columbiana | Ohio | 39029 | 983 | 59 |
263947 | 263947 | 2020-06-22 | Columbiana | Ohio | 39029 | 975 | 58 |
260819 | 260819 | 2020-06-21 | Columbiana | Ohio | 39029 | 961 | 58 |
257692 | 257692 | 2020-06-20 | Columbiana | Ohio | 39029 | 956 | 58 |
254567 | 254567 | 2020-06-19 | Columbiana | Ohio | 39029 | 954 | 58 |
251452 | 251452 | 2020-06-18 | Columbiana | Ohio | 39029 | 940 | 58 |
248337 | 248337 | 2020-06-17 | Columbiana | Ohio | 39029 | 923 | 58 |
245224 | 245224 | 2020-06-16 | Columbiana | Ohio | 39029 | 921 | 57 |
242112 | 242112 | 2020-06-15 | Columbiana | Ohio | 39029 | 920 | 57 |
239003 | 239003 | 2020-06-14 | Columbiana | Ohio | 39029 | 917 | 56 |
235895 | 235895 | 2020-06-13 | Columbiana | Ohio | 39029 | 916 | 56 |
232790 | 232790 | 2020-06-12 | Columbiana | Ohio | 39029 | 914 | 55 |
229685 | 229685 | 2020-06-11 | Columbiana | Ohio | 39029 | 911 | 55 |
226581 | 226581 | 2020-06-10 | Columbiana | Ohio | 39029 | 903 | 55 |
223481 | 223481 | 2020-06-09 | Columbiana | Ohio | 39029 | 901 | 55 |
220386 | 220386 | 2020-06-08 | Columbiana | Ohio | 39029 | 899 | 54 |
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);