ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Washington" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922580 | 922580 | 2021-01-12 | Washington | Ohio | 39167 | 3480 | 39 |
919335 | 919335 | 2021-01-11 | Washington | Ohio | 39167 | 3447 | 39 |
916090 | 916090 | 2021-01-10 | Washington | Ohio | 39167 | 3385 | 39 |
912845 | 912845 | 2021-01-09 | Washington | Ohio | 39167 | 3373 | 39 |
909600 | 909600 | 2021-01-08 | Washington | Ohio | 39167 | 3310 | 39 |
906355 | 906355 | 2021-01-07 | Washington | Ohio | 39167 | 3286 | 39 |
903109 | 903109 | 2021-01-06 | Washington | Ohio | 39167 | 3218 | 39 |
899864 | 899864 | 2021-01-05 | Washington | Ohio | 39167 | 3173 | 39 |
896619 | 896619 | 2021-01-04 | Washington | Ohio | 39167 | 3144 | 39 |
893373 | 893373 | 2021-01-03 | Washington | Ohio | 39167 | 3102 | 39 |
890127 | 890127 | 2021-01-02 | Washington | Ohio | 39167 | 3066 | 38 |
886880 | 886880 | 2021-01-01 | Washington | Ohio | 39167 | 2996 | 38 |
883635 | 883635 | 2020-12-31 | Washington | Ohio | 39167 | 2996 | 38 |
880390 | 880390 | 2020-12-30 | Washington | Ohio | 39167 | 2932 | 38 |
877145 | 877145 | 2020-12-29 | Washington | Ohio | 39167 | 2909 | 38 |
873900 | 873900 | 2020-12-28 | Washington | Ohio | 39167 | 2882 | 38 |
870655 | 870655 | 2020-12-27 | Washington | Ohio | 39167 | 2857 | 37 |
867410 | 867410 | 2020-12-26 | Washington | Ohio | 39167 | 2827 | 35 |
864165 | 864165 | 2020-12-25 | Washington | Ohio | 39167 | 2763 | 35 |
860920 | 860920 | 2020-12-24 | Washington | Ohio | 39167 | 2763 | 35 |
857675 | 857675 | 2020-12-23 | Washington | Ohio | 39167 | 2693 | 35 |
854430 | 854430 | 2020-12-22 | Washington | Ohio | 39167 | 2674 | 35 |
851185 | 851185 | 2020-12-21 | Washington | Ohio | 39167 | 2635 | 32 |
847940 | 847940 | 2020-12-20 | Washington | Ohio | 39167 | 2559 | 32 |
844695 | 844695 | 2020-12-19 | Washington | Ohio | 39167 | 2520 | 32 |
841449 | 841449 | 2020-12-18 | Washington | Ohio | 39167 | 2469 | 32 |
838204 | 838204 | 2020-12-17 | Washington | Ohio | 39167 | 2418 | 32 |
834958 | 834958 | 2020-12-16 | Washington | Ohio | 39167 | 2389 | 32 |
831712 | 831712 | 2020-12-15 | Washington | Ohio | 39167 | 2368 | 32 |
828465 | 828465 | 2020-12-14 | Washington | Ohio | 39167 | 2317 | 32 |
825219 | 825219 | 2020-12-13 | Washington | Ohio | 39167 | 2280 | 32 |
821972 | 821972 | 2020-12-12 | Washington | Ohio | 39167 | 2209 | 32 |
818726 | 818726 | 2020-12-11 | Washington | Ohio | 39167 | 2133 | 33 |
815480 | 815480 | 2020-12-10 | Washington | Ohio | 39167 | 2075 | 33 |
812234 | 812234 | 2020-12-09 | Washington | Ohio | 39167 | 2029 | 30 |
808990 | 808990 | 2020-12-08 | Washington | Ohio | 39167 | 1988 | 29 |
805745 | 805745 | 2020-12-07 | Washington | Ohio | 39167 | 1869 | 29 |
802500 | 802500 | 2020-12-06 | Washington | Ohio | 39167 | 1835 | 29 |
799255 | 799255 | 2020-12-05 | Washington | Ohio | 39167 | 1792 | 29 |
796010 | 796010 | 2020-12-04 | Washington | Ohio | 39167 | 1752 | 29 |
792765 | 792765 | 2020-12-03 | Washington | Ohio | 39167 | 1641 | 29 |
789520 | 789520 | 2020-12-02 | Washington | Ohio | 39167 | 1547 | 28 |
786275 | 786275 | 2020-12-01 | Washington | Ohio | 39167 | 1496 | 28 |
783031 | 783031 | 2020-11-30 | Washington | Ohio | 39167 | 1431 | 27 |
779785 | 779785 | 2020-11-29 | Washington | Ohio | 39167 | 1408 | 27 |
776540 | 776540 | 2020-11-28 | Washington | Ohio | 39167 | 1354 | 27 |
773295 | 773295 | 2020-11-27 | Washington | Ohio | 39167 | 1334 | 27 |
770050 | 770050 | 2020-11-26 | Washington | Ohio | 39167 | 1252 | 27 |
766804 | 766804 | 2020-11-25 | Washington | Ohio | 39167 | 1252 | 27 |
763559 | 763559 | 2020-11-24 | Washington | Ohio | 39167 | 1219 | 27 |
760314 | 760314 | 2020-11-23 | Washington | Ohio | 39167 | 1164 | 27 |
757069 | 757069 | 2020-11-22 | Washington | Ohio | 39167 | 1124 | 27 |
753822 | 753822 | 2020-11-21 | Washington | Ohio | 39167 | 1079 | 27 |
750576 | 750576 | 2020-11-20 | Washington | Ohio | 39167 | 967 | 27 |
747330 | 747330 | 2020-11-19 | Washington | Ohio | 39167 | 930 | 27 |
744084 | 744084 | 2020-11-18 | Washington | Ohio | 39167 | 902 | 27 |
740837 | 740837 | 2020-11-17 | Washington | Ohio | 39167 | 892 | 27 |
737591 | 737591 | 2020-11-16 | Washington | Ohio | 39167 | 860 | 27 |
734347 | 734347 | 2020-11-15 | Washington | Ohio | 39167 | 833 | 27 |
731101 | 731101 | 2020-11-14 | Washington | Ohio | 39167 | 782 | 26 |
727857 | 727857 | 2020-11-13 | Washington | Ohio | 39167 | 740 | 26 |
724613 | 724613 | 2020-11-12 | Washington | Ohio | 39167 | 714 | 26 |
721370 | 721370 | 2020-11-11 | Washington | Ohio | 39167 | 678 | 26 |
718127 | 718127 | 2020-11-10 | Washington | Ohio | 39167 | 650 | 25 |
714884 | 714884 | 2020-11-09 | Washington | Ohio | 39167 | 627 | 25 |
711640 | 711640 | 2020-11-08 | Washington | Ohio | 39167 | 619 | 25 |
708396 | 708396 | 2020-11-07 | Washington | Ohio | 39167 | 604 | 25 |
705153 | 705153 | 2020-11-06 | Washington | Ohio | 39167 | 580 | 25 |
701910 | 701910 | 2020-11-05 | Washington | Ohio | 39167 | 540 | 25 |
698666 | 698666 | 2020-11-04 | Washington | Ohio | 39167 | 508 | 25 |
695423 | 695423 | 2020-11-03 | Washington | Ohio | 39167 | 492 | 25 |
692181 | 692181 | 2020-11-02 | Washington | Ohio | 39167 | 470 | 25 |
688937 | 688937 | 2020-11-01 | Washington | Ohio | 39167 | 461 | 25 |
685692 | 685692 | 2020-10-31 | Washington | Ohio | 39167 | 454 | 25 |
682449 | 682449 | 2020-10-30 | Washington | Ohio | 39167 | 431 | 25 |
679206 | 679206 | 2020-10-29 | Washington | Ohio | 39167 | 412 | 25 |
675963 | 675963 | 2020-10-28 | Washington | Ohio | 39167 | 394 | 24 |
672720 | 672720 | 2020-10-27 | Washington | Ohio | 39167 | 391 | 24 |
669478 | 669478 | 2020-10-26 | Washington | Ohio | 39167 | 381 | 24 |
666234 | 666234 | 2020-10-25 | Washington | Ohio | 39167 | 373 | 24 |
662989 | 662989 | 2020-10-24 | Washington | Ohio | 39167 | 357 | 24 |
659745 | 659745 | 2020-10-23 | Washington | Ohio | 39167 | 355 | 24 |
656501 | 656501 | 2020-10-22 | Washington | Ohio | 39167 | 351 | 24 |
653256 | 653256 | 2020-10-21 | Washington | Ohio | 39167 | 344 | 24 |
650011 | 650011 | 2020-10-20 | Washington | Ohio | 39167 | 333 | 23 |
646767 | 646767 | 2020-10-19 | Washington | Ohio | 39167 | 330 | 23 |
643521 | 643521 | 2020-10-18 | Washington | Ohio | 39167 | 324 | 23 |
640273 | 640273 | 2020-10-17 | Washington | Ohio | 39167 | 323 | 23 |
637027 | 637027 | 2020-10-16 | Washington | Ohio | 39167 | 316 | 23 |
633781 | 633781 | 2020-10-15 | Washington | Ohio | 39167 | 309 | 23 |
630536 | 630536 | 2020-10-14 | Washington | Ohio | 39167 | 301 | 23 |
627292 | 627292 | 2020-10-13 | Washington | Ohio | 39167 | 300 | 23 |
624050 | 624050 | 2020-10-12 | Washington | Ohio | 39167 | 293 | 23 |
620807 | 620807 | 2020-10-11 | Washington | Ohio | 39167 | 284 | 23 |
617565 | 617565 | 2020-10-10 | Washington | Ohio | 39167 | 277 | 23 |
614323 | 614323 | 2020-10-09 | Washington | Ohio | 39167 | 276 | 23 |
611082 | 611082 | 2020-10-08 | Washington | Ohio | 39167 | 273 | 23 |
607840 | 607840 | 2020-10-07 | Washington | Ohio | 39167 | 270 | 23 |
604597 | 604597 | 2020-10-06 | Washington | Ohio | 39167 | 269 | 23 |
601355 | 601355 | 2020-10-05 | Washington | Ohio | 39167 | 268 | 23 |
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);