ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "Logan" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
955080 | 955080 | 2021-01-22 | Logan | Oklahoma | 40083 | 3402 | 20 |
951835 | 951835 | 2021-01-21 | Logan | Oklahoma | 40083 | 3374 | 17 |
948590 | 948590 | 2021-01-20 | Logan | Oklahoma | 40083 | 3350 | 17 |
945344 | 945344 | 2021-01-19 | Logan | Oklahoma | 40083 | 3334 | 17 |
942097 | 942097 | 2021-01-18 | Logan | Oklahoma | 40083 | 3315 | 16 |
938852 | 938852 | 2021-01-17 | Logan | Oklahoma | 40083 | 3298 | 16 |
935607 | 935607 | 2021-01-16 | Logan | Oklahoma | 40083 | 3255 | 15 |
932362 | 932362 | 2021-01-15 | Logan | Oklahoma | 40083 | 3209 | 15 |
929117 | 929117 | 2021-01-14 | Logan | Oklahoma | 40083 | 3173 | 15 |
925872 | 925872 | 2021-01-13 | Logan | Oklahoma | 40083 | 3147 | 15 |
922626 | 922626 | 2021-01-12 | Logan | Oklahoma | 40083 | 3105 | 15 |
919381 | 919381 | 2021-01-11 | Logan | Oklahoma | 40083 | 3086 | 15 |
916136 | 916136 | 2021-01-10 | Logan | Oklahoma | 40083 | 3024 | 14 |
912891 | 912891 | 2021-01-09 | Logan | Oklahoma | 40083 | 2869 | 14 |
909646 | 909646 | 2021-01-08 | Logan | Oklahoma | 40083 | 2830 | 14 |
906401 | 906401 | 2021-01-07 | Logan | Oklahoma | 40083 | 2748 | 12 |
903155 | 903155 | 2021-01-06 | Logan | Oklahoma | 40083 | 2728 | 10 |
899910 | 899910 | 2021-01-05 | Logan | Oklahoma | 40083 | 2704 | 8 |
896665 | 896665 | 2021-01-04 | Logan | Oklahoma | 40083 | 2695 | 8 |
893419 | 893419 | 2021-01-03 | Logan | Oklahoma | 40083 | 2666 | 8 |
890173 | 890173 | 2021-01-02 | Logan | Oklahoma | 40083 | 2597 | 8 |
886926 | 886926 | 2021-01-01 | Logan | Oklahoma | 40083 | 2547 | 8 |
883681 | 883681 | 2020-12-31 | Logan | Oklahoma | 40083 | 2547 | 8 |
880436 | 880436 | 2020-12-30 | Logan | Oklahoma | 40083 | 2524 | 8 |
877191 | 877191 | 2020-12-29 | Logan | Oklahoma | 40083 | 2504 | 7 |
873946 | 873946 | 2020-12-28 | Logan | Oklahoma | 40083 | 2495 | 7 |
870701 | 870701 | 2020-12-27 | Logan | Oklahoma | 40083 | 2448 | 7 |
867456 | 867456 | 2020-12-26 | Logan | Oklahoma | 40083 | 2418 | 7 |
864211 | 864211 | 2020-12-25 | Logan | Oklahoma | 40083 | 2357 | 7 |
860966 | 860966 | 2020-12-24 | Logan | Oklahoma | 40083 | 2357 | 7 |
857721 | 857721 | 2020-12-23 | Logan | Oklahoma | 40083 | 2333 | 7 |
854476 | 854476 | 2020-12-22 | Logan | Oklahoma | 40083 | 2285 | 6 |
851231 | 851231 | 2020-12-21 | Logan | Oklahoma | 40083 | 2249 | 6 |
847986 | 847986 | 2020-12-20 | Logan | Oklahoma | 40083 | 2197 | 6 |
844741 | 844741 | 2020-12-19 | Logan | Oklahoma | 40083 | 2130 | 5 |
841495 | 841495 | 2020-12-18 | Logan | Oklahoma | 40083 | 2114 | 5 |
838250 | 838250 | 2020-12-17 | Logan | Oklahoma | 40083 | 2086 | 5 |
835004 | 835004 | 2020-12-16 | Logan | Oklahoma | 40083 | 2062 | 5 |
831758 | 831758 | 2020-12-15 | Logan | Oklahoma | 40083 | 2051 | 5 |
828511 | 828511 | 2020-12-14 | Logan | Oklahoma | 40083 | 2026 | 5 |
825265 | 825265 | 2020-12-13 | Logan | Oklahoma | 40083 | 2010 | 5 |
822018 | 822018 | 2020-12-12 | Logan | Oklahoma | 40083 | 1957 | 5 |
818772 | 818772 | 2020-12-11 | Logan | Oklahoma | 40083 | 1908 | 5 |
815526 | 815526 | 2020-12-10 | Logan | Oklahoma | 40083 | 1868 | 5 |
812280 | 812280 | 2020-12-09 | Logan | Oklahoma | 40083 | 1848 | 5 |
809036 | 809036 | 2020-12-08 | Logan | Oklahoma | 40083 | 1821 | 4 |
805791 | 805791 | 2020-12-07 | Logan | Oklahoma | 40083 | 1786 | 4 |
802546 | 802546 | 2020-12-06 | Logan | Oklahoma | 40083 | 1777 | 4 |
799301 | 799301 | 2020-12-05 | Logan | Oklahoma | 40083 | 1745 | 4 |
796056 | 796056 | 2020-12-04 | Logan | Oklahoma | 40083 | 1673 | 4 |
792811 | 792811 | 2020-12-03 | Logan | Oklahoma | 40083 | 1613 | 3 |
789566 | 789566 | 2020-12-02 | Logan | Oklahoma | 40083 | 1603 | 3 |
786321 | 786321 | 2020-12-01 | Logan | Oklahoma | 40083 | 1577 | 3 |
783077 | 783077 | 2020-11-30 | Logan | Oklahoma | 40083 | 1529 | 3 |
779831 | 779831 | 2020-11-29 | Logan | Oklahoma | 40083 | 1500 | 3 |
776586 | 776586 | 2020-11-28 | Logan | Oklahoma | 40083 | 1469 | 3 |
773341 | 773341 | 2020-11-27 | Logan | Oklahoma | 40083 | 1398 | 3 |
770096 | 770096 | 2020-11-26 | Logan | Oklahoma | 40083 | 1358 | 3 |
766850 | 766850 | 2020-11-25 | Logan | Oklahoma | 40083 | 1358 | 3 |
763605 | 763605 | 2020-11-24 | Logan | Oklahoma | 40083 | 1318 | 3 |
760360 | 760360 | 2020-11-23 | Logan | Oklahoma | 40083 | 1295 | 3 |
757115 | 757115 | 2020-11-22 | Logan | Oklahoma | 40083 | 1252 | 3 |
753868 | 753868 | 2020-11-21 | Logan | Oklahoma | 40083 | 1233 | 3 |
750622 | 750622 | 2020-11-20 | Logan | Oklahoma | 40083 | 1197 | 3 |
747376 | 747376 | 2020-11-19 | Logan | Oklahoma | 40083 | 1174 | 3 |
744130 | 744130 | 2020-11-18 | Logan | Oklahoma | 40083 | 1153 | 3 |
740883 | 740883 | 2020-11-17 | Logan | Oklahoma | 40083 | 1128 | 3 |
737637 | 737637 | 2020-11-16 | Logan | Oklahoma | 40083 | 1122 | 3 |
734393 | 734393 | 2020-11-15 | Logan | Oklahoma | 40083 | 1102 | 3 |
731147 | 731147 | 2020-11-14 | Logan | Oklahoma | 40083 | 1061 | 3 |
727903 | 727903 | 2020-11-13 | Logan | Oklahoma | 40083 | 1044 | 3 |
724659 | 724659 | 2020-11-12 | Logan | Oklahoma | 40083 | 1031 | 3 |
721416 | 721416 | 2020-11-11 | Logan | Oklahoma | 40083 | 1019 | 3 |
718173 | 718173 | 2020-11-10 | Logan | Oklahoma | 40083 | 995 | 3 |
714930 | 714930 | 2020-11-09 | Logan | Oklahoma | 40083 | 987 | 2 |
711686 | 711686 | 2020-11-08 | Logan | Oklahoma | 40083 | 973 | 2 |
708442 | 708442 | 2020-11-07 | Logan | Oklahoma | 40083 | 973 | 2 |
705199 | 705199 | 2020-11-06 | Logan | Oklahoma | 40083 | 939 | 2 |
701956 | 701956 | 2020-11-05 | Logan | Oklahoma | 40083 | 934 | 2 |
698712 | 698712 | 2020-11-04 | Logan | Oklahoma | 40083 | 928 | 2 |
695469 | 695469 | 2020-11-03 | Logan | Oklahoma | 40083 | 913 | 2 |
692227 | 692227 | 2020-11-02 | Logan | Oklahoma | 40083 | 912 | 2 |
688983 | 688983 | 2020-11-01 | Logan | Oklahoma | 40083 | 907 | 2 |
685738 | 685738 | 2020-10-31 | Logan | Oklahoma | 40083 | 890 | 2 |
682495 | 682495 | 2020-10-30 | Logan | Oklahoma | 40083 | 881 | 2 |
679252 | 679252 | 2020-10-29 | Logan | Oklahoma | 40083 | 870 | 2 |
676009 | 676009 | 2020-10-28 | Logan | Oklahoma | 40083 | 862 | 2 |
672766 | 672766 | 2020-10-27 | Logan | Oklahoma | 40083 | 861 | 2 |
669524 | 669524 | 2020-10-26 | Logan | Oklahoma | 40083 | 849 | 2 |
666280 | 666280 | 2020-10-25 | Logan | Oklahoma | 40083 | 843 | 2 |
663035 | 663035 | 2020-10-24 | Logan | Oklahoma | 40083 | 837 | 2 |
659791 | 659791 | 2020-10-23 | Logan | Oklahoma | 40083 | 812 | 2 |
656547 | 656547 | 2020-10-22 | Logan | Oklahoma | 40083 | 806 | 2 |
653302 | 653302 | 2020-10-21 | Logan | Oklahoma | 40083 | 791 | 2 |
650057 | 650057 | 2020-10-20 | Logan | Oklahoma | 40083 | 770 | 2 |
646813 | 646813 | 2020-10-19 | Logan | Oklahoma | 40083 | 745 | 2 |
643567 | 643567 | 2020-10-18 | Logan | Oklahoma | 40083 | 728 | 2 |
640319 | 640319 | 2020-10-17 | Logan | Oklahoma | 40083 | 722 | 2 |
637073 | 637073 | 2020-10-16 | Logan | Oklahoma | 40083 | 720 | 2 |
633827 | 633827 | 2020-10-15 | Logan | Oklahoma | 40083 | 696 | 2 |
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);