ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Allen" and state = "Ohio" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922498 | 922498 | 2021-01-12 | Allen | Ohio | 39003 | 9204 | 122 |
919253 | 919253 | 2021-01-11 | Allen | Ohio | 39003 | 9156 | 119 |
916008 | 916008 | 2021-01-10 | Allen | Ohio | 39003 | 9064 | 119 |
912763 | 912763 | 2021-01-09 | Allen | Ohio | 39003 | 9025 | 119 |
909518 | 909518 | 2021-01-08 | Allen | Ohio | 39003 | 8929 | 119 |
906273 | 906273 | 2021-01-07 | Allen | Ohio | 39003 | 8845 | 118 |
903027 | 903027 | 2021-01-06 | Allen | Ohio | 39003 | 8707 | 118 |
899782 | 899782 | 2021-01-05 | Allen | Ohio | 39003 | 8580 | 117 |
896537 | 896537 | 2021-01-04 | Allen | Ohio | 39003 | 8493 | 114 |
893291 | 893291 | 2021-01-03 | Allen | Ohio | 39003 | 8468 | 111 |
890045 | 890045 | 2021-01-02 | Allen | Ohio | 39003 | 8446 | 111 |
886798 | 886798 | 2021-01-01 | Allen | Ohio | 39003 | 8308 | 111 |
883553 | 883553 | 2020-12-31 | Allen | Ohio | 39003 | 8308 | 111 |
880308 | 880308 | 2020-12-30 | Allen | Ohio | 39003 | 8186 | 110 |
877063 | 877063 | 2020-12-29 | Allen | Ohio | 39003 | 8096 | 110 |
873818 | 873818 | 2020-12-28 | Allen | Ohio | 39003 | 8023 | 109 |
870573 | 870573 | 2020-12-27 | Allen | Ohio | 39003 | 7983 | 108 |
867328 | 867328 | 2020-12-26 | Allen | Ohio | 39003 | 7923 | 108 |
864083 | 864083 | 2020-12-25 | Allen | Ohio | 39003 | 7825 | 108 |
860838 | 860838 | 2020-12-24 | Allen | Ohio | 39003 | 7825 | 108 |
857593 | 857593 | 2020-12-23 | Allen | Ohio | 39003 | 7750 | 105 |
854348 | 854348 | 2020-12-22 | Allen | Ohio | 39003 | 7689 | 105 |
851103 | 851103 | 2020-12-21 | Allen | Ohio | 39003 | 7598 | 105 |
847858 | 847858 | 2020-12-20 | Allen | Ohio | 39003 | 7499 | 105 |
844613 | 844613 | 2020-12-19 | Allen | Ohio | 39003 | 7405 | 105 |
841367 | 841367 | 2020-12-18 | Allen | Ohio | 39003 | 7318 | 105 |
838122 | 838122 | 2020-12-17 | Allen | Ohio | 39003 | 7243 | 104 |
834876 | 834876 | 2020-12-16 | Allen | Ohio | 39003 | 7095 | 103 |
831630 | 831630 | 2020-12-15 | Allen | Ohio | 39003 | 7014 | 103 |
828383 | 828383 | 2020-12-14 | Allen | Ohio | 39003 | 6925 | 102 |
825137 | 825137 | 2020-12-13 | Allen | Ohio | 39003 | 6847 | 102 |
821890 | 821890 | 2020-12-12 | Allen | Ohio | 39003 | 6765 | 102 |
818644 | 818644 | 2020-12-11 | Allen | Ohio | 39003 | 6666 | 102 |
815398 | 815398 | 2020-12-10 | Allen | Ohio | 39003 | 6583 | 102 |
812152 | 812152 | 2020-12-09 | Allen | Ohio | 39003 | 6433 | 101 |
808908 | 808908 | 2020-12-08 | Allen | Ohio | 39003 | 6350 | 100 |
805663 | 805663 | 2020-12-07 | Allen | Ohio | 39003 | 6111 | 98 |
802418 | 802418 | 2020-12-06 | Allen | Ohio | 39003 | 6017 | 98 |
799173 | 799173 | 2020-12-05 | Allen | Ohio | 39003 | 5940 | 98 |
795928 | 795928 | 2020-12-04 | Allen | Ohio | 39003 | 5792 | 97 |
792683 | 792683 | 2020-12-03 | Allen | Ohio | 39003 | 5699 | 95 |
789438 | 789438 | 2020-12-02 | Allen | Ohio | 39003 | 5594 | 94 |
786193 | 786193 | 2020-12-01 | Allen | Ohio | 39003 | 5506 | 93 |
782949 | 782949 | 2020-11-30 | Allen | Ohio | 39003 | 5406 | 90 |
779703 | 779703 | 2020-11-29 | Allen | Ohio | 39003 | 5342 | 89 |
776458 | 776458 | 2020-11-28 | Allen | Ohio | 39003 | 5251 | 89 |
773213 | 773213 | 2020-11-27 | Allen | Ohio | 39003 | 5183 | 89 |
769968 | 769968 | 2020-11-26 | Allen | Ohio | 39003 | 4949 | 89 |
766722 | 766722 | 2020-11-25 | Allen | Ohio | 39003 | 4949 | 89 |
763477 | 763477 | 2020-11-24 | Allen | Ohio | 39003 | 4654 | 85 |
760232 | 760232 | 2020-11-23 | Allen | Ohio | 39003 | 4606 | 85 |
756987 | 756987 | 2020-11-22 | Allen | Ohio | 39003 | 4463 | 84 |
753740 | 753740 | 2020-11-21 | Allen | Ohio | 39003 | 4410 | 84 |
750494 | 750494 | 2020-11-20 | Allen | Ohio | 39003 | 4353 | 83 |
747248 | 747248 | 2020-11-19 | Allen | Ohio | 39003 | 4194 | 81 |
744002 | 744002 | 2020-11-18 | Allen | Ohio | 39003 | 4114 | 81 |
740755 | 740755 | 2020-11-17 | Allen | Ohio | 39003 | 4001 | 81 |
737509 | 737509 | 2020-11-16 | Allen | Ohio | 39003 | 3931 | 81 |
734265 | 734265 | 2020-11-15 | Allen | Ohio | 39003 | 3814 | 81 |
731019 | 731019 | 2020-11-14 | Allen | Ohio | 39003 | 3687 | 81 |
727775 | 727775 | 2020-11-13 | Allen | Ohio | 39003 | 3582 | 81 |
724531 | 724531 | 2020-11-12 | Allen | Ohio | 39003 | 3426 | 81 |
721288 | 721288 | 2020-11-11 | Allen | Ohio | 39003 | 3307 | 81 |
718045 | 718045 | 2020-11-10 | Allen | Ohio | 39003 | 3211 | 80 |
714802 | 714802 | 2020-11-09 | Allen | Ohio | 39003 | 3121 | 80 |
711558 | 711558 | 2020-11-08 | Allen | Ohio | 39003 | 3056 | 80 |
708314 | 708314 | 2020-11-07 | Allen | Ohio | 39003 | 3022 | 80 |
705071 | 705071 | 2020-11-06 | Allen | Ohio | 39003 | 2949 | 80 |
701828 | 701828 | 2020-11-05 | Allen | Ohio | 39003 | 2869 | 80 |
698584 | 698584 | 2020-11-04 | Allen | Ohio | 39003 | 2784 | 80 |
695341 | 695341 | 2020-11-03 | Allen | Ohio | 39003 | 2715 | 80 |
692099 | 692099 | 2020-11-02 | Allen | Ohio | 39003 | 2653 | 80 |
688855 | 688855 | 2020-11-01 | Allen | Ohio | 39003 | 2580 | 80 |
685610 | 685610 | 2020-10-31 | Allen | Ohio | 39003 | 2555 | 80 |
682367 | 682367 | 2020-10-30 | Allen | Ohio | 39003 | 2511 | 80 |
679124 | 679124 | 2020-10-29 | Allen | Ohio | 39003 | 2452 | 80 |
675881 | 675881 | 2020-10-28 | Allen | Ohio | 39003 | 2367 | 80 |
672638 | 672638 | 2020-10-27 | Allen | Ohio | 39003 | 2317 | 74 |
669396 | 669396 | 2020-10-26 | Allen | Ohio | 39003 | 2289 | 74 |
666152 | 666152 | 2020-10-25 | Allen | Ohio | 39003 | 2250 | 74 |
662907 | 662907 | 2020-10-24 | Allen | Ohio | 39003 | 2239 | 73 |
659663 | 659663 | 2020-10-23 | Allen | Ohio | 39003 | 2183 | 73 |
656419 | 656419 | 2020-10-22 | Allen | Ohio | 39003 | 2130 | 73 |
653174 | 653174 | 2020-10-21 | Allen | Ohio | 39003 | 2080 | 73 |
649929 | 649929 | 2020-10-20 | Allen | Ohio | 39003 | 2038 | 73 |
646685 | 646685 | 2020-10-19 | Allen | Ohio | 39003 | 2013 | 73 |
643439 | 643439 | 2020-10-18 | Allen | Ohio | 39003 | 1958 | 73 |
640191 | 640191 | 2020-10-17 | Allen | Ohio | 39003 | 1940 | 73 |
636945 | 636945 | 2020-10-16 | Allen | Ohio | 39003 | 1891 | 73 |
633699 | 633699 | 2020-10-15 | Allen | Ohio | 39003 | 1871 | 73 |
630454 | 630454 | 2020-10-14 | Allen | Ohio | 39003 | 1819 | 72 |
627210 | 627210 | 2020-10-13 | Allen | Ohio | 39003 | 1776 | 72 |
623968 | 623968 | 2020-10-12 | Allen | Ohio | 39003 | 1745 | 72 |
620725 | 620725 | 2020-10-11 | Allen | Ohio | 39003 | 1703 | 72 |
617483 | 617483 | 2020-10-10 | Allen | Ohio | 39003 | 1679 | 72 |
614241 | 614241 | 2020-10-09 | Allen | Ohio | 39003 | 1664 | 72 |
611000 | 611000 | 2020-10-08 | Allen | Ohio | 39003 | 1641 | 72 |
607758 | 607758 | 2020-10-07 | Allen | Ohio | 39003 | 1607 | 72 |
604515 | 604515 | 2020-10-06 | Allen | Ohio | 39003 | 1582 | 72 |
601273 | 601273 | 2020-10-05 | Allen | Ohio | 39003 | 1567 | 72 |
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);