ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
779 rows where county = "Okmulgee", fips = 40111 and state = "Oklahoma" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1094656 | 1094656 | 2021-03-06 | Okmulgee | Oklahoma | 40111 | 3640 | 50 |
1091410 | 1091410 | 2021-03-05 | Okmulgee | Oklahoma | 40111 | 3638 | 50 |
1088164 | 1088164 | 2021-03-04 | Okmulgee | Oklahoma | 40111 | 3635 | 50 |
1084919 | 1084919 | 2021-03-03 | Okmulgee | Oklahoma | 40111 | 3629 | 50 |
1081673 | 1081673 | 2021-03-02 | Okmulgee | Oklahoma | 40111 | 3625 | 50 |
1078427 | 1078427 | 2021-03-01 | Okmulgee | Oklahoma | 40111 | 3624 | 47 |
1075182 | 1075182 | 2021-02-28 | Okmulgee | Oklahoma | 40111 | 3623 | 46 |
1071936 | 1071936 | 2021-02-27 | Okmulgee | Oklahoma | 40111 | 3620 | 46 |
1068690 | 1068690 | 2021-02-26 | Okmulgee | Oklahoma | 40111 | 3615 | 45 |
1065445 | 1065445 | 2021-02-25 | Okmulgee | Oklahoma | 40111 | 3615 | 45 |
1062201 | 1062201 | 2021-02-24 | Okmulgee | Oklahoma | 40111 | 3606 | 45 |
1058955 | 1058955 | 2021-02-23 | Okmulgee | Oklahoma | 40111 | 3601 | 45 |
1055709 | 1055709 | 2021-02-22 | Okmulgee | Oklahoma | 40111 | 3589 | 45 |
1052463 | 1052463 | 2021-02-21 | Okmulgee | Oklahoma | 40111 | 3584 | 45 |
1049216 | 1049216 | 2021-02-20 | Okmulgee | Oklahoma | 40111 | 3577 | 45 |
1045969 | 1045969 | 2021-02-19 | Okmulgee | Oklahoma | 40111 | 3572 | 44 |
1042724 | 1042724 | 2021-02-18 | Okmulgee | Oklahoma | 40111 | 3562 | 44 |
1039479 | 1039479 | 2021-02-17 | Okmulgee | Oklahoma | 40111 | 3556 | 44 |
1036234 | 1036234 | 2021-02-16 | Okmulgee | Oklahoma | 40111 | 3546 | 44 |
1032989 | 1032989 | 2021-02-15 | Okmulgee | Oklahoma | 40111 | 3543 | 44 |
1029743 | 1029743 | 2021-02-14 | Okmulgee | Oklahoma | 40111 | 3537 | 43 |
1026496 | 1026496 | 2021-02-13 | Okmulgee | Oklahoma | 40111 | 3534 | 42 |
1023251 | 1023251 | 2021-02-12 | Okmulgee | Oklahoma | 40111 | 3526 | 41 |
1020006 | 1020006 | 2021-02-11 | Okmulgee | Oklahoma | 40111 | 3520 | 39 |
1016761 | 1016761 | 2021-02-10 | Okmulgee | Oklahoma | 40111 | 3504 | 39 |
1013516 | 1013516 | 2021-02-09 | Okmulgee | Oklahoma | 40111 | 3489 | 39 |
1010271 | 1010271 | 2021-02-08 | Okmulgee | Oklahoma | 40111 | 3483 | 39 |
1007025 | 1007025 | 2021-02-07 | Okmulgee | Oklahoma | 40111 | 3476 | 39 |
1003779 | 1003779 | 2021-02-06 | Okmulgee | Oklahoma | 40111 | 3467 | 39 |
1000533 | 1000533 | 2021-02-05 | Okmulgee | Oklahoma | 40111 | 3448 | 39 |
997287 | 997287 | 2021-02-04 | Okmulgee | Oklahoma | 40111 | 3437 | 39 |
994041 | 994041 | 2021-02-03 | Okmulgee | Oklahoma | 40111 | 3400 | 39 |
990795 | 990795 | 2021-02-02 | Okmulgee | Oklahoma | 40111 | 3377 | 39 |
987549 | 987549 | 2021-02-01 | Okmulgee | Oklahoma | 40111 | 3370 | 39 |
984302 | 984302 | 2021-01-31 | Okmulgee | Oklahoma | 40111 | 3368 | 39 |
981055 | 981055 | 2021-01-30 | Okmulgee | Oklahoma | 40111 | 3292 | 39 |
977809 | 977809 | 2021-01-29 | Okmulgee | Oklahoma | 40111 | 3281 | 39 |
974564 | 974564 | 2021-01-28 | Okmulgee | Oklahoma | 40111 | 3261 | 38 |
971319 | 971319 | 2021-01-27 | Okmulgee | Oklahoma | 40111 | 3244 | 38 |
968074 | 968074 | 2021-01-26 | Okmulgee | Oklahoma | 40111 | 3214 | 37 |
964830 | 964830 | 2021-01-25 | Okmulgee | Oklahoma | 40111 | 3213 | 37 |
961585 | 961585 | 2021-01-24 | Okmulgee | Oklahoma | 40111 | 3212 | 37 |
958340 | 958340 | 2021-01-23 | Okmulgee | Oklahoma | 40111 | 3180 | 36 |
955094 | 955094 | 2021-01-22 | Okmulgee | Oklahoma | 40111 | 3164 | 36 |
951849 | 951849 | 2021-01-21 | Okmulgee | Oklahoma | 40111 | 3147 | 35 |
948604 | 948604 | 2021-01-20 | Okmulgee | Oklahoma | 40111 | 3125 | 35 |
945358 | 945358 | 2021-01-19 | Okmulgee | Oklahoma | 40111 | 3105 | 34 |
942111 | 942111 | 2021-01-18 | Okmulgee | Oklahoma | 40111 | 3091 | 34 |
938866 | 938866 | 2021-01-17 | Okmulgee | Oklahoma | 40111 | 3087 | 34 |
935621 | 935621 | 2021-01-16 | Okmulgee | Oklahoma | 40111 | 3059 | 34 |
932376 | 932376 | 2021-01-15 | Okmulgee | Oklahoma | 40111 | 3039 | 34 |
929131 | 929131 | 2021-01-14 | Okmulgee | Oklahoma | 40111 | 3017 | 33 |
925886 | 925886 | 2021-01-13 | Okmulgee | Oklahoma | 40111 | 2994 | 32 |
922640 | 922640 | 2021-01-12 | Okmulgee | Oklahoma | 40111 | 2966 | 30 |
919395 | 919395 | 2021-01-11 | Okmulgee | Oklahoma | 40111 | 2959 | 30 |
916150 | 916150 | 2021-01-10 | Okmulgee | Oklahoma | 40111 | 2944 | 30 |
912905 | 912905 | 2021-01-09 | Okmulgee | Oklahoma | 40111 | 2916 | 30 |
909660 | 909660 | 2021-01-08 | Okmulgee | Oklahoma | 40111 | 2880 | 30 |
906415 | 906415 | 2021-01-07 | Okmulgee | Oklahoma | 40111 | 2843 | 30 |
903169 | 903169 | 2021-01-06 | Okmulgee | Oklahoma | 40111 | 2817 | 29 |
899924 | 899924 | 2021-01-05 | Okmulgee | Oklahoma | 40111 | 2751 | 29 |
896679 | 896679 | 2021-01-04 | Okmulgee | Oklahoma | 40111 | 2738 | 29 |
893433 | 893433 | 2021-01-03 | Okmulgee | Oklahoma | 40111 | 2724 | 29 |
890187 | 890187 | 2021-01-02 | Okmulgee | Oklahoma | 40111 | 2660 | 28 |
886940 | 886940 | 2021-01-01 | Okmulgee | Oklahoma | 40111 | 2600 | 27 |
883695 | 883695 | 2020-12-31 | Okmulgee | Oklahoma | 40111 | 2600 | 27 |
880450 | 880450 | 2020-12-30 | Okmulgee | Oklahoma | 40111 | 2549 | 27 |
877205 | 877205 | 2020-12-29 | Okmulgee | Oklahoma | 40111 | 2516 | 26 |
873960 | 873960 | 2020-12-28 | Okmulgee | Oklahoma | 40111 | 2503 | 26 |
870715 | 870715 | 2020-12-27 | Okmulgee | Oklahoma | 40111 | 2480 | 26 |
867470 | 867470 | 2020-12-26 | Okmulgee | Oklahoma | 40111 | 2446 | 26 |
864225 | 864225 | 2020-12-25 | Okmulgee | Oklahoma | 40111 | 2424 | 26 |
860980 | 860980 | 2020-12-24 | Okmulgee | Oklahoma | 40111 | 2424 | 26 |
857735 | 857735 | 2020-12-23 | Okmulgee | Oklahoma | 40111 | 2388 | 26 |
854490 | 854490 | 2020-12-22 | Okmulgee | Oklahoma | 40111 | 2345 | 26 |
851245 | 851245 | 2020-12-21 | Okmulgee | Oklahoma | 40111 | 2321 | 25 |
848000 | 848000 | 2020-12-20 | Okmulgee | Oklahoma | 40111 | 2299 | 25 |
844755 | 844755 | 2020-12-19 | Okmulgee | Oklahoma | 40111 | 2252 | 25 |
841509 | 841509 | 2020-12-18 | Okmulgee | Oklahoma | 40111 | 2216 | 25 |
838264 | 838264 | 2020-12-17 | Okmulgee | Oklahoma | 40111 | 2175 | 25 |
835018 | 835018 | 2020-12-16 | Okmulgee | Oklahoma | 40111 | 2149 | 25 |
831772 | 831772 | 2020-12-15 | Okmulgee | Oklahoma | 40111 | 2121 | 25 |
828525 | 828525 | 2020-12-14 | Okmulgee | Oklahoma | 40111 | 2108 | 25 |
825279 | 825279 | 2020-12-13 | Okmulgee | Oklahoma | 40111 | 2099 | 25 |
822032 | 822032 | 2020-12-12 | Okmulgee | Oklahoma | 40111 | 2066 | 25 |
818786 | 818786 | 2020-12-11 | Okmulgee | Oklahoma | 40111 | 2049 | 25 |
815540 | 815540 | 2020-12-10 | Okmulgee | Oklahoma | 40111 | 2009 | 25 |
812294 | 812294 | 2020-12-09 | Okmulgee | Oklahoma | 40111 | 1985 | 25 |
809050 | 809050 | 2020-12-08 | Okmulgee | Oklahoma | 40111 | 1960 | 25 |
805805 | 805805 | 2020-12-07 | Okmulgee | Oklahoma | 40111 | 1955 | 25 |
802560 | 802560 | 2020-12-06 | Okmulgee | Oklahoma | 40111 | 1937 | 24 |
799315 | 799315 | 2020-12-05 | Okmulgee | Oklahoma | 40111 | 1906 | 23 |
796070 | 796070 | 2020-12-04 | Okmulgee | Oklahoma | 40111 | 1882 | 22 |
792825 | 792825 | 2020-12-03 | Okmulgee | Oklahoma | 40111 | 1868 | 22 |
789580 | 789580 | 2020-12-02 | Okmulgee | Oklahoma | 40111 | 1855 | 22 |
786335 | 786335 | 2020-12-01 | Okmulgee | Oklahoma | 40111 | 1825 | 21 |
783091 | 783091 | 2020-11-30 | Okmulgee | Oklahoma | 40111 | 1817 | 21 |
779845 | 779845 | 2020-11-29 | Okmulgee | Oklahoma | 40111 | 1801 | 20 |
776600 | 776600 | 2020-11-28 | Okmulgee | Oklahoma | 40111 | 1788 | 20 |
773355 | 773355 | 2020-11-27 | Okmulgee | Oklahoma | 40111 | 1755 | 20 |
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);