ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where county = "McClain" and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
922631 | 922631 | 2021-01-12 | McClain | Oklahoma | 40087 | 4127 | 31 |
919386 | 919386 | 2021-01-11 | McClain | Oklahoma | 40087 | 4090 | 30 |
916141 | 916141 | 2021-01-10 | McClain | Oklahoma | 40087 | 4043 | 30 |
912896 | 912896 | 2021-01-09 | McClain | Oklahoma | 40087 | 3971 | 30 |
909651 | 909651 | 2021-01-08 | McClain | Oklahoma | 40087 | 3935 | 30 |
906406 | 906406 | 2021-01-07 | McClain | Oklahoma | 40087 | 3878 | 29 |
903160 | 903160 | 2021-01-06 | McClain | Oklahoma | 40087 | 3830 | 28 |
899915 | 899915 | 2021-01-05 | McClain | Oklahoma | 40087 | 3798 | 28 |
896670 | 896670 | 2021-01-04 | McClain | Oklahoma | 40087 | 3778 | 28 |
893424 | 893424 | 2021-01-03 | McClain | Oklahoma | 40087 | 3749 | 28 |
890178 | 890178 | 2021-01-02 | McClain | Oklahoma | 40087 | 3659 | 28 |
886931 | 886931 | 2021-01-01 | McClain | Oklahoma | 40087 | 3561 | 28 |
883686 | 883686 | 2020-12-31 | McClain | Oklahoma | 40087 | 3561 | 28 |
880441 | 880441 | 2020-12-30 | McClain | Oklahoma | 40087 | 3514 | 27 |
877196 | 877196 | 2020-12-29 | McClain | Oklahoma | 40087 | 3493 | 26 |
873951 | 873951 | 2020-12-28 | McClain | Oklahoma | 40087 | 3464 | 25 |
870706 | 870706 | 2020-12-27 | McClain | Oklahoma | 40087 | 3434 | 24 |
867461 | 867461 | 2020-12-26 | McClain | Oklahoma | 40087 | 3405 | 24 |
864216 | 864216 | 2020-12-25 | McClain | Oklahoma | 40087 | 3342 | 23 |
860971 | 860971 | 2020-12-24 | McClain | Oklahoma | 40087 | 3342 | 23 |
857726 | 857726 | 2020-12-23 | McClain | Oklahoma | 40087 | 3297 | 21 |
854481 | 854481 | 2020-12-22 | McClain | Oklahoma | 40087 | 3276 | 21 |
851236 | 851236 | 2020-12-21 | McClain | Oklahoma | 40087 | 3238 | 21 |
847991 | 847991 | 2020-12-20 | McClain | Oklahoma | 40087 | 3208 | 21 |
844746 | 844746 | 2020-12-19 | McClain | Oklahoma | 40087 | 3174 | 21 |
841500 | 841500 | 2020-12-18 | McClain | Oklahoma | 40087 | 3121 | 20 |
838255 | 838255 | 2020-12-17 | McClain | Oklahoma | 40087 | 3078 | 20 |
835009 | 835009 | 2020-12-16 | McClain | Oklahoma | 40087 | 3041 | 20 |
831763 | 831763 | 2020-12-15 | McClain | Oklahoma | 40087 | 3016 | 20 |
828516 | 828516 | 2020-12-14 | McClain | Oklahoma | 40087 | 2993 | 20 |
825270 | 825270 | 2020-12-13 | McClain | Oklahoma | 40087 | 2977 | 20 |
822023 | 822023 | 2020-12-12 | McClain | Oklahoma | 40087 | 2923 | 20 |
818777 | 818777 | 2020-12-11 | McClain | Oklahoma | 40087 | 2899 | 20 |
815531 | 815531 | 2020-12-10 | McClain | Oklahoma | 40087 | 2856 | 20 |
812285 | 812285 | 2020-12-09 | McClain | Oklahoma | 40087 | 2828 | 19 |
809041 | 809041 | 2020-12-08 | McClain | Oklahoma | 40087 | 2798 | 19 |
805796 | 805796 | 2020-12-07 | McClain | Oklahoma | 40087 | 2770 | 19 |
802551 | 802551 | 2020-12-06 | McClain | Oklahoma | 40087 | 2735 | 18 |
799306 | 799306 | 2020-12-05 | McClain | Oklahoma | 40087 | 2698 | 18 |
796061 | 796061 | 2020-12-04 | McClain | Oklahoma | 40087 | 2628 | 17 |
792816 | 792816 | 2020-12-03 | McClain | Oklahoma | 40087 | 2549 | 17 |
789571 | 789571 | 2020-12-02 | McClain | Oklahoma | 40087 | 2531 | 17 |
786326 | 786326 | 2020-12-01 | McClain | Oklahoma | 40087 | 2505 | 17 |
783082 | 783082 | 2020-11-30 | McClain | Oklahoma | 40087 | 2475 | 17 |
779836 | 779836 | 2020-11-29 | McClain | Oklahoma | 40087 | 2455 | 17 |
776591 | 776591 | 2020-11-28 | McClain | Oklahoma | 40087 | 2429 | 17 |
773346 | 773346 | 2020-11-27 | McClain | Oklahoma | 40087 | 2372 | 17 |
770101 | 770101 | 2020-11-26 | McClain | Oklahoma | 40087 | 2331 | 17 |
766855 | 766855 | 2020-11-25 | McClain | Oklahoma | 40087 | 2331 | 17 |
763610 | 763610 | 2020-11-24 | McClain | Oklahoma | 40087 | 2303 | 16 |
760365 | 760365 | 2020-11-23 | McClain | Oklahoma | 40087 | 2247 | 16 |
757120 | 757120 | 2020-11-22 | McClain | Oklahoma | 40087 | 2195 | 16 |
753873 | 753873 | 2020-11-21 | McClain | Oklahoma | 40087 | 2150 | 16 |
750627 | 750627 | 2020-11-20 | McClain | Oklahoma | 40087 | 2097 | 16 |
747381 | 747381 | 2020-11-19 | McClain | Oklahoma | 40087 | 2059 | 16 |
744135 | 744135 | 2020-11-18 | McClain | Oklahoma | 40087 | 2021 | 16 |
740888 | 740888 | 2020-11-17 | McClain | Oklahoma | 40087 | 1986 | 16 |
737642 | 737642 | 2020-11-16 | McClain | Oklahoma | 40087 | 1957 | 16 |
734398 | 734398 | 2020-11-15 | McClain | Oklahoma | 40087 | 1905 | 16 |
731152 | 731152 | 2020-11-14 | McClain | Oklahoma | 40087 | 1849 | 16 |
727908 | 727908 | 2020-11-13 | McClain | Oklahoma | 40087 | 1806 | 16 |
724664 | 724664 | 2020-11-12 | McClain | Oklahoma | 40087 | 1760 | 16 |
721421 | 721421 | 2020-11-11 | McClain | Oklahoma | 40087 | 1711 | 16 |
718178 | 718178 | 2020-11-10 | McClain | Oklahoma | 40087 | 1678 | 16 |
714935 | 714935 | 2020-11-09 | McClain | Oklahoma | 40087 | 1656 | 16 |
711691 | 711691 | 2020-11-08 | McClain | Oklahoma | 40087 | 1617 | 16 |
708447 | 708447 | 2020-11-07 | McClain | Oklahoma | 40087 | 1617 | 16 |
705204 | 705204 | 2020-11-06 | McClain | Oklahoma | 40087 | 1543 | 16 |
701961 | 701961 | 2020-11-05 | McClain | Oklahoma | 40087 | 1521 | 16 |
698717 | 698717 | 2020-11-04 | McClain | Oklahoma | 40087 | 1466 | 16 |
695474 | 695474 | 2020-11-03 | McClain | Oklahoma | 40087 | 1445 | 15 |
692232 | 692232 | 2020-11-02 | McClain | Oklahoma | 40087 | 1435 | 14 |
688988 | 688988 | 2020-11-01 | McClain | Oklahoma | 40087 | 1416 | 14 |
685743 | 685743 | 2020-10-31 | McClain | Oklahoma | 40087 | 1386 | 13 |
682500 | 682500 | 2020-10-30 | McClain | Oklahoma | 40087 | 1367 | 13 |
679257 | 679257 | 2020-10-29 | McClain | Oklahoma | 40087 | 1359 | 11 |
676014 | 676014 | 2020-10-28 | McClain | Oklahoma | 40087 | 1337 | 11 |
672771 | 672771 | 2020-10-27 | McClain | Oklahoma | 40087 | 1327 | 10 |
669529 | 669529 | 2020-10-26 | McClain | Oklahoma | 40087 | 1316 | 10 |
666285 | 666285 | 2020-10-25 | McClain | Oklahoma | 40087 | 1310 | 10 |
663040 | 663040 | 2020-10-24 | McClain | Oklahoma | 40087 | 1290 | 9 |
659796 | 659796 | 2020-10-23 | McClain | Oklahoma | 40087 | 1267 | 9 |
656552 | 656552 | 2020-10-22 | McClain | Oklahoma | 40087 | 1246 | 9 |
653307 | 653307 | 2020-10-21 | McClain | Oklahoma | 40087 | 1231 | 9 |
650062 | 650062 | 2020-10-20 | McClain | Oklahoma | 40087 | 1211 | 9 |
646818 | 646818 | 2020-10-19 | McClain | Oklahoma | 40087 | 1180 | 9 |
643572 | 643572 | 2020-10-18 | McClain | Oklahoma | 40087 | 1169 | 9 |
640324 | 640324 | 2020-10-17 | McClain | Oklahoma | 40087 | 1160 | 9 |
637078 | 637078 | 2020-10-16 | McClain | Oklahoma | 40087 | 1148 | 9 |
633832 | 633832 | 2020-10-15 | McClain | Oklahoma | 40087 | 1135 | 8 |
630587 | 630587 | 2020-10-14 | McClain | Oklahoma | 40087 | 1131 | 8 |
627343 | 627343 | 2020-10-13 | McClain | Oklahoma | 40087 | 1103 | 8 |
624101 | 624101 | 2020-10-12 | McClain | Oklahoma | 40087 | 1086 | 7 |
620858 | 620858 | 2020-10-11 | McClain | Oklahoma | 40087 | 1073 | 7 |
617616 | 617616 | 2020-10-10 | McClain | Oklahoma | 40087 | 1044 | 7 |
614374 | 614374 | 2020-10-09 | McClain | Oklahoma | 40087 | 1024 | 7 |
611133 | 611133 | 2020-10-08 | McClain | Oklahoma | 40087 | 1003 | 7 |
607891 | 607891 | 2020-10-07 | McClain | Oklahoma | 40087 | 987 | 7 |
604648 | 604648 | 2020-10-06 | McClain | Oklahoma | 40087 | 970 | 7 |
601406 | 601406 | 2020-10-05 | McClain | Oklahoma | 40087 | 962 | 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);