ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
468 rows where deaths = 7 and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2495208 | 2495208 | 2022-05-11 | Unknown | Ohio | 0 | 7 | |
2491950 | 2491950 | 2022-05-10 | Unknown | Ohio | 0 | 7 | |
2488692 | 2488692 | 2022-05-09 | Unknown | Ohio | 0 | 7 | |
2485435 | 2485435 | 2022-05-08 | Unknown | Ohio | 0 | 7 | |
2482177 | 2482177 | 2022-05-07 | Unknown | Ohio | 0 | 7 | |
2478919 | 2478919 | 2022-05-06 | Unknown | Ohio | 0 | 7 | |
2475661 | 2475661 | 2022-05-05 | Unknown | Ohio | 0 | 7 | |
2088512 | 2088512 | 2022-01-06 | Unknown | Ohio | 0 | 7 | |
2085261 | 2085261 | 2022-01-05 | Unknown | Ohio | 0 | 7 | |
2082009 | 2082009 | 2022-01-04 | Unknown | Ohio | 0 | 7 | |
2078757 | 2078757 | 2022-01-03 | Unknown | Ohio | 0 | 7 | |
2075506 | 2075506 | 2022-01-02 | Unknown | Ohio | 0 | 7 | |
2072255 | 2072255 | 2022-01-01 | Unknown | Ohio | 0 | 7 | |
2069004 | 2069004 | 2021-12-31 | Unknown | Ohio | 0 | 7 | |
847938 | 847938 | 2020-12-20 | Vinton | Ohio | 39163 | 449 | 7 |
844693 | 844693 | 2020-12-19 | Vinton | Ohio | 39163 | 443 | 7 |
841447 | 841447 | 2020-12-18 | Vinton | Ohio | 39163 | 421 | 7 |
838202 | 838202 | 2020-12-17 | Vinton | Ohio | 39163 | 415 | 7 |
834956 | 834956 | 2020-12-16 | Vinton | Ohio | 39163 | 406 | 7 |
831710 | 831710 | 2020-12-15 | Vinton | Ohio | 39163 | 410 | 7 |
828463 | 828463 | 2020-12-14 | Vinton | Ohio | 39163 | 400 | 7 |
825217 | 825217 | 2020-12-13 | Vinton | Ohio | 39163 | 396 | 7 |
821896 | 821896 | 2020-12-12 | Brown | Ohio | 39015 | 1710 | 7 |
821970 | 821970 | 2020-12-12 | Vinton | Ohio | 39163 | 395 | 7 |
818650 | 818650 | 2020-12-11 | Brown | Ohio | 39015 | 1669 | 7 |
818724 | 818724 | 2020-12-11 | Vinton | Ohio | 39163 | 381 | 7 |
815404 | 815404 | 2020-12-10 | Brown | Ohio | 39015 | 1618 | 7 |
812158 | 812158 | 2020-12-09 | Brown | Ohio | 39015 | 1565 | 7 |
808914 | 808914 | 2020-12-08 | Brown | Ohio | 39015 | 1497 | 7 |
747326 | 747326 | 2020-11-19 | Union | Ohio | 39159 | 1623 | 7 |
734264 | 734264 | 2020-11-15 | Adams | Ohio | 39001 | 510 | 7 |
731018 | 731018 | 2020-11-14 | Adams | Ohio | 39001 | 501 | 7 |
727774 | 727774 | 2020-11-13 | Adams | Ohio | 39001 | 479 | 7 |
724530 | 724530 | 2020-11-12 | Adams | Ohio | 39001 | 438 | 7 |
721287 | 721287 | 2020-11-11 | Adams | Ohio | 39001 | 422 | 7 |
721349 | 721349 | 2020-11-11 | Paulding | Ohio | 39125 | 415 | 7 |
718106 | 718106 | 2020-11-10 | Paulding | Ohio | 39125 | 403 | 7 |
714863 | 714863 | 2020-11-09 | Paulding | Ohio | 39125 | 394 | 7 |
688863 | 688863 | 2020-11-01 | Carroll | Ohio | 39019 | 265 | 7 |
685618 | 685618 | 2020-10-31 | Carroll | Ohio | 39019 | 246 | 7 |
682375 | 682375 | 2020-10-30 | Carroll | Ohio | 39019 | 244 | 7 |
679132 | 679132 | 2020-10-29 | Carroll | Ohio | 39019 | 242 | 7 |
675889 | 675889 | 2020-10-28 | Carroll | Ohio | 39019 | 229 | 7 |
672646 | 672646 | 2020-10-27 | Carroll | Ohio | 39019 | 224 | 7 |
669404 | 669404 | 2020-10-26 | Carroll | Ohio | 39019 | 221 | 7 |
666160 | 666160 | 2020-10-25 | Carroll | Ohio | 39019 | 218 | 7 |
662915 | 662915 | 2020-10-24 | Carroll | Ohio | 39019 | 217 | 7 |
659671 | 659671 | 2020-10-23 | Carroll | Ohio | 39019 | 215 | 7 |
656427 | 656427 | 2020-10-22 | Carroll | Ohio | 39019 | 200 | 7 |
653182 | 653182 | 2020-10-21 | Carroll | Ohio | 39019 | 193 | 7 |
649937 | 649937 | 2020-10-20 | Carroll | Ohio | 39019 | 191 | 7 |
649967 | 649967 | 2020-10-20 | Jackson | Ohio | 39079 | 441 | 7 |
646693 | 646693 | 2020-10-19 | Carroll | Ohio | 39019 | 186 | 7 |
646723 | 646723 | 2020-10-19 | Jackson | Ohio | 39079 | 425 | 7 |
643447 | 643447 | 2020-10-18 | Carroll | Ohio | 39019 | 188 | 7 |
643477 | 643477 | 2020-10-18 | Jackson | Ohio | 39079 | 419 | 7 |
640199 | 640199 | 2020-10-17 | Carroll | Ohio | 39019 | 184 | 7 |
640229 | 640229 | 2020-10-17 | Jackson | Ohio | 39079 | 407 | 7 |
636953 | 636953 | 2020-10-16 | Carroll | Ohio | 39019 | 179 | 7 |
636983 | 636983 | 2020-10-16 | Jackson | Ohio | 39079 | 388 | 7 |
633707 | 633707 | 2020-10-15 | Carroll | Ohio | 39019 | 179 | 7 |
633714 | 633714 | 2020-10-15 | Crawford | Ohio | 39033 | 365 | 7 |
633737 | 633737 | 2020-10-15 | Jackson | Ohio | 39079 | 377 | 7 |
630462 | 630462 | 2020-10-14 | Carroll | Ohio | 39019 | 177 | 7 |
630469 | 630469 | 2020-10-14 | Crawford | Ohio | 39033 | 353 | 7 |
630476 | 630476 | 2020-10-14 | Fayette | Ohio | 39047 | 386 | 7 |
630492 | 630492 | 2020-10-14 | Jackson | Ohio | 39079 | 365 | 7 |
627218 | 627218 | 2020-10-13 | Carroll | Ohio | 39019 | 174 | 7 |
627232 | 627232 | 2020-10-13 | Fayette | Ohio | 39047 | 371 | 7 |
627248 | 627248 | 2020-10-13 | Jackson | Ohio | 39079 | 359 | 7 |
627281 | 627281 | 2020-10-13 | Scioto | Ohio | 39145 | 690 | 7 |
623976 | 623976 | 2020-10-12 | Carroll | Ohio | 39019 | 175 | 7 |
623990 | 623990 | 2020-10-12 | Fayette | Ohio | 39047 | 360 | 7 |
624006 | 624006 | 2020-10-12 | Jackson | Ohio | 39079 | 351 | 7 |
624039 | 624039 | 2020-10-12 | Scioto | Ohio | 39145 | 677 | 7 |
620733 | 620733 | 2020-10-11 | Carroll | Ohio | 39019 | 174 | 7 |
620747 | 620747 | 2020-10-11 | Fayette | Ohio | 39047 | 357 | 7 |
620763 | 620763 | 2020-10-11 | Jackson | Ohio | 39079 | 339 | 7 |
620796 | 620796 | 2020-10-11 | Scioto | Ohio | 39145 | 669 | 7 |
617491 | 617491 | 2020-10-10 | Carroll | Ohio | 39019 | 174 | 7 |
617505 | 617505 | 2020-10-10 | Fayette | Ohio | 39047 | 349 | 7 |
617521 | 617521 | 2020-10-10 | Jackson | Ohio | 39079 | 332 | 7 |
617554 | 617554 | 2020-10-10 | Scioto | Ohio | 39145 | 654 | 7 |
614249 | 614249 | 2020-10-09 | Carroll | Ohio | 39019 | 171 | 7 |
614263 | 614263 | 2020-10-09 | Fayette | Ohio | 39047 | 334 | 7 |
614279 | 614279 | 2020-10-09 | Jackson | Ohio | 39079 | 328 | 7 |
614312 | 614312 | 2020-10-09 | Scioto | Ohio | 39145 | 643 | 7 |
611008 | 611008 | 2020-10-08 | Carroll | Ohio | 39019 | 168 | 7 |
611022 | 611022 | 2020-10-08 | Fayette | Ohio | 39047 | 324 | 7 |
611038 | 611038 | 2020-10-08 | Jackson | Ohio | 39079 | 317 | 7 |
611071 | 611071 | 2020-10-08 | Scioto | Ohio | 39145 | 627 | 7 |
607766 | 607766 | 2020-10-07 | Carroll | Ohio | 39019 | 164 | 7 |
607796 | 607796 | 2020-10-07 | Jackson | Ohio | 39079 | 315 | 7 |
607829 | 607829 | 2020-10-07 | Scioto | Ohio | 39145 | 617 | 7 |
604523 | 604523 | 2020-10-06 | Carroll | Ohio | 39019 | 164 | 7 |
604552 | 604552 | 2020-10-06 | Huron | Ohio | 39077 | 629 | 7 |
604553 | 604553 | 2020-10-06 | Jackson | Ohio | 39079 | 306 | 7 |
604586 | 604586 | 2020-10-06 | Scioto | Ohio | 39145 | 592 | 7 |
601281 | 601281 | 2020-10-05 | Carroll | Ohio | 39019 | 160 | 7 |
601310 | 601310 | 2020-10-05 | Huron | Ohio | 39077 | 618 | 7 |
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);