ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Greene" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
636972 | 636972 | 2020-10-16 | Greene | Ohio | 39057 | 2037 | 40 |
633726 | 633726 | 2020-10-15 | Greene | Ohio | 39057 | 1976 | 39 |
630481 | 630481 | 2020-10-14 | Greene | Ohio | 39057 | 1951 | 39 |
627237 | 627237 | 2020-10-13 | Greene | Ohio | 39057 | 1914 | 38 |
623995 | 623995 | 2020-10-12 | Greene | Ohio | 39057 | 1890 | 38 |
620752 | 620752 | 2020-10-11 | Greene | Ohio | 39057 | 1870 | 38 |
617510 | 617510 | 2020-10-10 | Greene | Ohio | 39057 | 1839 | 38 |
614268 | 614268 | 2020-10-09 | Greene | Ohio | 39057 | 1805 | 37 |
611027 | 611027 | 2020-10-08 | Greene | Ohio | 39057 | 1774 | 37 |
607785 | 607785 | 2020-10-07 | Greene | Ohio | 39057 | 1722 | 37 |
604542 | 604542 | 2020-10-06 | Greene | Ohio | 39057 | 1707 | 37 |
601300 | 601300 | 2020-10-05 | Greene | Ohio | 39057 | 1688 | 37 |
598057 | 598057 | 2020-10-04 | Greene | Ohio | 39057 | 1661 | 37 |
594814 | 594814 | 2020-10-03 | Greene | Ohio | 39057 | 1639 | 37 |
591573 | 591573 | 2020-10-02 | Greene | Ohio | 39057 | 1619 | 36 |
588332 | 588332 | 2020-10-01 | Greene | Ohio | 39057 | 1589 | 34 |
585092 | 585092 | 2020-09-30 | Greene | Ohio | 39057 | 1561 | 34 |
581852 | 581852 | 2020-09-29 | Greene | Ohio | 39057 | 1536 | 34 |
578612 | 578612 | 2020-09-28 | Greene | Ohio | 39057 | 1490 | 34 |
575371 | 575371 | 2020-09-27 | Greene | Ohio | 39057 | 1465 | 33 |
572127 | 572127 | 2020-09-26 | Greene | Ohio | 39057 | 1453 | 32 |
568885 | 568885 | 2020-09-25 | Greene | Ohio | 39057 | 1444 | 32 |
565644 | 565644 | 2020-09-24 | Greene | Ohio | 39057 | 1420 | 32 |
562403 | 562403 | 2020-09-23 | Greene | Ohio | 39057 | 1397 | 32 |
559166 | 559166 | 2020-09-22 | Greene | Ohio | 39057 | 1376 | 32 |
555929 | 555929 | 2020-09-21 | Greene | Ohio | 39057 | 1367 | 28 |
552692 | 552692 | 2020-09-20 | Greene | Ohio | 39057 | 1352 | 28 |
549453 | 549453 | 2020-09-19 | Greene | Ohio | 39057 | 1338 | 27 |
546214 | 546214 | 2020-09-18 | Greene | Ohio | 39057 | 1313 | 26 |
542977 | 542977 | 2020-09-17 | Greene | Ohio | 39057 | 1288 | 26 |
539741 | 539741 | 2020-09-16 | Greene | Ohio | 39057 | 1278 | 27 |
536504 | 536504 | 2020-09-15 | Greene | Ohio | 39057 | 1244 | 26 |
533268 | 533268 | 2020-09-14 | Greene | Ohio | 39057 | 1224 | 25 |
530033 | 530033 | 2020-09-13 | Greene | Ohio | 39057 | 1218 | 25 |
526796 | 526796 | 2020-09-12 | Greene | Ohio | 39057 | 1201 | 25 |
523560 | 523560 | 2020-09-11 | Greene | Ohio | 39057 | 1182 | 25 |
520324 | 520324 | 2020-09-10 | Greene | Ohio | 39057 | 1149 | 25 |
517088 | 517088 | 2020-09-09 | Greene | Ohio | 39057 | 1136 | 21 |
513853 | 513853 | 2020-09-08 | Greene | Ohio | 39057 | 1125 | 20 |
510620 | 510620 | 2020-09-07 | Greene | Ohio | 39057 | 1117 | 20 |
507387 | 507387 | 2020-09-06 | Greene | Ohio | 39057 | 1102 | 20 |
504155 | 504155 | 2020-09-05 | Greene | Ohio | 39057 | 1084 | 20 |
500921 | 500921 | 2020-09-04 | Greene | Ohio | 39057 | 1063 | 20 |
497687 | 497687 | 2020-09-03 | Greene | Ohio | 39057 | 1035 | 20 |
494454 | 494454 | 2020-09-02 | Greene | Ohio | 39057 | 1020 | 20 |
491220 | 491220 | 2020-09-01 | Greene | Ohio | 39057 | 992 | 19 |
487987 | 487987 | 2020-08-31 | Greene | Ohio | 39057 | 977 | 18 |
484754 | 484754 | 2020-08-30 | Greene | Ohio | 39057 | 969 | 18 |
481519 | 481519 | 2020-08-29 | Greene | Ohio | 39057 | 956 | 17 |
478285 | 478285 | 2020-08-28 | Greene | Ohio | 39057 | 945 | 16 |
475052 | 475052 | 2020-08-27 | Greene | Ohio | 39057 | 932 | 16 |
471818 | 471818 | 2020-08-26 | Greene | Ohio | 39057 | 916 | 16 |
468586 | 468586 | 2020-08-25 | Greene | Ohio | 39057 | 896 | 16 |
465358 | 465358 | 2020-08-24 | Greene | Ohio | 39057 | 885 | 15 |
462129 | 462129 | 2020-08-23 | Greene | Ohio | 39057 | 871 | 15 |
458901 | 458901 | 2020-08-22 | Greene | Ohio | 39057 | 862 | 14 |
455673 | 455673 | 2020-08-21 | Greene | Ohio | 39057 | 854 | 14 |
452445 | 452445 | 2020-08-20 | Greene | Ohio | 39057 | 842 | 14 |
449217 | 449217 | 2020-08-19 | Greene | Ohio | 39057 | 821 | 14 |
445989 | 445989 | 2020-08-18 | Greene | Ohio | 39057 | 812 | 14 |
442763 | 442763 | 2020-08-17 | Greene | Ohio | 39057 | 806 | 13 |
439536 | 439536 | 2020-08-16 | Greene | Ohio | 39057 | 799 | 13 |
436311 | 436311 | 2020-08-15 | Greene | Ohio | 39057 | 773 | 12 |
433085 | 433085 | 2020-08-14 | Greene | Ohio | 39057 | 765 | 12 |
429859 | 429859 | 2020-08-13 | Greene | Ohio | 39057 | 742 | 12 |
426634 | 426634 | 2020-08-12 | Greene | Ohio | 39057 | 730 | 12 |
423411 | 423411 | 2020-08-11 | Greene | Ohio | 39057 | 718 | 12 |
420188 | 420188 | 2020-08-10 | Greene | Ohio | 39057 | 703 | 12 |
416968 | 416968 | 2020-08-09 | Greene | Ohio | 39057 | 690 | 12 |
413747 | 413747 | 2020-08-08 | Greene | Ohio | 39057 | 684 | 12 |
410527 | 410527 | 2020-08-07 | Greene | Ohio | 39057 | 662 | 12 |
407307 | 407307 | 2020-08-06 | Greene | Ohio | 39057 | 656 | 11 |
404088 | 404088 | 2020-08-05 | Greene | Ohio | 39057 | 644 | 11 |
400870 | 400870 | 2020-08-04 | Greene | Ohio | 39057 | 635 | 11 |
397655 | 397655 | 2020-08-03 | Greene | Ohio | 39057 | 626 | 11 |
394438 | 394438 | 2020-08-02 | Greene | Ohio | 39057 | 619 | 11 |
391222 | 391222 | 2020-08-01 | Greene | Ohio | 39057 | 617 | 11 |
388005 | 388005 | 2020-07-31 | Greene | Ohio | 39057 | 610 | 11 |
384788 | 384788 | 2020-07-30 | Greene | Ohio | 39057 | 599 | 11 |
381570 | 381570 | 2020-07-29 | Greene | Ohio | 39057 | 587 | 11 |
378353 | 378353 | 2020-07-28 | Greene | Ohio | 39057 | 568 | 11 |
375136 | 375136 | 2020-07-27 | Greene | Ohio | 39057 | 554 | 11 |
371924 | 371924 | 2020-07-26 | Greene | Ohio | 39057 | 545 | 11 |
368712 | 368712 | 2020-07-25 | Greene | Ohio | 39057 | 538 | 11 |
365503 | 365503 | 2020-07-24 | Greene | Ohio | 39057 | 526 | 11 |
362297 | 362297 | 2020-07-23 | Greene | Ohio | 39057 | 507 | 10 |
359091 | 359091 | 2020-07-22 | Greene | Ohio | 39057 | 503 | 10 |
355887 | 355887 | 2020-07-21 | Greene | Ohio | 39057 | 485 | 10 |
352684 | 352684 | 2020-07-20 | Greene | Ohio | 39057 | 472 | 10 |
349481 | 349481 | 2020-07-19 | Greene | Ohio | 39057 | 461 | 10 |
346280 | 346280 | 2020-07-18 | Greene | Ohio | 39057 | 454 | 10 |
343081 | 343081 | 2020-07-17 | Greene | Ohio | 39057 | 432 | 9 |
339883 | 339883 | 2020-07-16 | Greene | Ohio | 39057 | 411 | 9 |
336687 | 336687 | 2020-07-15 | Greene | Ohio | 39057 | 385 | 9 |
333493 | 333493 | 2020-07-14 | Greene | Ohio | 39057 | 380 | 9 |
330301 | 330301 | 2020-07-13 | Greene | Ohio | 39057 | 365 | 9 |
327114 | 327114 | 2020-07-12 | Greene | Ohio | 39057 | 346 | 9 |
323929 | 323929 | 2020-07-11 | Greene | Ohio | 39057 | 343 | 9 |
320749 | 320749 | 2020-07-10 | Greene | Ohio | 39057 | 322 | 9 |
317572 | 317572 | 2020-07-09 | Greene | Ohio | 39057 | 300 | 9 |
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);