johns_hopkins_csse_daily_reports

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette

26,604 rows where province_or_state = "Oklahoma" sorted by day descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

province_or_state

  • Oklahoma · 26,604 ✖

country_or_region

  • US 26,604
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
803806 803806 2021-03-01 US Oklahoma Adair 40001 3096 24 0 3072 35.88494195 -94.65859267 2021-03-02 05:23:30 Adair, Oklahoma, US
803807 803807 2021-03-01 US Oklahoma Alfalfa 40003 1148 5 0 1143 36.73090616 -98.32408495 2021-03-02 05:23:30 Alfalfa, Oklahoma, US
803808 803808 2021-03-01 US Oklahoma Atoka 40005 1766 12 0 1754 34.37366573 -96.03802487 2021-03-02 05:23:30 Atoka, Oklahoma, US
803809 803809 2021-03-01 US Oklahoma Beaver 40007 440 6 0 434 36.7496847 -100.4758872 2021-03-02 05:23:30 Beaver, Oklahoma, US
803810 803810 2021-03-01 US Oklahoma Beckham 40009 2708 37 0 2671 35.26862449 -99.68128023 2021-03-02 05:23:30 Beckham, Oklahoma, US
803811 803811 2021-03-01 US Oklahoma Blaine 40011 996 8 0 988 35.87518314 -98.43307003 2021-03-02 05:23:30 Blaine, Oklahoma, US
803812 803812 2021-03-01 US Oklahoma Bryan 40013 5911 55 0 5856 33.96472458 -96.25903472 2021-03-02 05:23:30 Bryan, Oklahoma, US
803813 803813 2021-03-01 US Oklahoma Caddo 40015 3811 56 0 3755 35.17364557 -98.37534464 2021-03-02 05:23:30 Caddo, Oklahoma, US
803814 803814 2021-03-01 US Oklahoma Canadian 40017 15885 95 0 15790 35.5426055 -97.98465569 2021-03-02 05:23:30 Canadian, Oklahoma, US
803815 803815 2021-03-01 US Oklahoma Carter 40019 5728 60 0 5668 34.25103751 -97.28552485 2021-03-02 05:23:30 Carter, Oklahoma, US
803816 803816 2021-03-01 US Oklahoma Cherokee 40021 5419 43 0 5376 35.90692775 -94.99980896 2021-03-02 05:23:30 Cherokee, Oklahoma, US
803817 803817 2021-03-01 US Oklahoma Choctaw 40023 1553 14 0 1539 34.02807439 -95.54771129 2021-03-02 05:23:30 Choctaw, Oklahoma, US
803818 803818 2021-03-01 US Oklahoma Cimarron 40025 176 1 0 175 36.74817177 -102.5173885 2021-03-02 05:23:30 Cimarron, Oklahoma, US
803819 803819 2021-03-01 US Oklahoma Cleveland 40027 28727 273 0 28454 35.20413532 -97.32519562 2021-03-02 05:23:30 Cleveland, Oklahoma, US
803820 803820 2021-03-01 US Oklahoma Coal 40029 683 14 0 669 34.58840127 -96.29798747 2021-03-02 05:23:30 Coal, Oklahoma, US
803821 803821 2021-03-01 US Oklahoma Comanche 40031 12053 135 0 11918 34.65973764 -98.47195055 2021-03-02 05:23:30 Comanche, Oklahoma, US
803822 803822 2021-03-01 US Oklahoma Cotton 40033 651 13 0 638 34.28845626 -98.37053567 2021-03-02 05:23:30 Cotton, Oklahoma, US
803823 803823 2021-03-01 US Oklahoma Craig 40035 1892 11 0 1881 36.76268118 -95.20916602 2021-03-02 05:23:30 Craig, Oklahoma, US
803824 803824 2021-03-01 US Oklahoma Creek 40037 6538 117 0 6421 35.90230551 -96.37086028 2021-03-02 05:23:30 Creek, Oklahoma, US
803825 803825 2021-03-01 US Oklahoma Custer 40039 4003 70 0 3933 35.63853802 -99.00170785 2021-03-02 05:23:30 Custer, Oklahoma, US
803826 803826 2021-03-01 US Oklahoma Delaware 40041 4372 62 0 4310 36.40823634 -94.80325046 2021-03-02 05:23:30 Delaware, Oklahoma, US
803827 803827 2021-03-01 US Oklahoma Dewey 40043 534 6 0 528 35.98772922 -99.00730714 2021-03-02 05:23:30 Dewey, Oklahoma, US
803828 803828 2021-03-01 US Oklahoma Ellis 40045 350 3 0 347 36.2180194 -99.75324573 2021-03-02 05:23:30 Ellis, Oklahoma, US
803829 803829 2021-03-01 US Oklahoma Garfield 40047 7588 78 0 7510 36.3791334 -97.78265517 2021-03-02 05:23:30 Garfield, Oklahoma, US
803830 803830 2021-03-01 US Oklahoma Garvin 40049 3469 52 0 3417 34.70418038 -97.30811132 2021-03-02 05:23:30 Garvin, Oklahoma, US
803831 803831 2021-03-01 US Oklahoma Grady 40051 5647 76 0 5571 35.0167709 -97.88339847 2021-03-02 05:23:30 Grady, Oklahoma, US
803832 803832 2021-03-01 US Oklahoma Grant 40053 535 7 0 528 36.796297 -97.78638765 2021-03-02 05:23:30 Grant, Oklahoma, US
803833 803833 2021-03-01 US Oklahoma Greer 40055 532 17 0 515 34.93535801 -99.5605612 2021-03-02 05:23:30 Greer, Oklahoma, US
803834 803834 2021-03-01 US Oklahoma Harmon 40057 290 3 0 287 34.7440135 -99.84741652 2021-03-02 05:23:30 Harmon, Oklahoma, US
803835 803835 2021-03-01 US Oklahoma Harper 40059 408 4 0 404 36.78836519 -99.6679804 2021-03-02 05:23:30 Harper, Oklahoma, US
803836 803836 2021-03-01 US Oklahoma Haskell 40061 1214 10 0 1204 35.22257600000001 -95.11513306 2021-03-02 05:23:30 Haskell, Oklahoma, US
803837 803837 2021-03-01 US Oklahoma Hughes 40063 1159 17 0 1142 35.04912569 -96.24921145 2021-03-02 05:23:30 Hughes, Oklahoma, US
803838 803838 2021-03-01 US Oklahoma Jackson 40065 2918 44 0 2874 34.58781741 -99.41138784 2021-03-02 05:23:30 Jackson, Oklahoma, US
803839 803839 2021-03-01 US Oklahoma Jefferson 40067 672 11 0 661 34.11130184 -97.83182974 2021-03-02 05:23:30 Jefferson, Oklahoma, US
803840 803840 2021-03-01 US Oklahoma Johnston 40069 1329 20 0 1309 34.31440473 -96.66011537 2021-03-02 05:23:30 Johnston, Oklahoma, US
803841 803841 2021-03-01 US Oklahoma Kay 40071 5084 80 0 5004 36.81799745 -97.14421435 2021-03-02 05:23:30 Kay, Oklahoma, US
803842 803842 2021-03-01 US Oklahoma Kingfisher 40073 1987 24 0 1963 35.94530008 -97.94193268 2021-03-02 05:23:30 Kingfisher, Oklahoma, US
803843 803843 2021-03-01 US Oklahoma Kiowa 40075 789 16 0 773 34.91671958 -98.97720696 2021-03-02 05:23:30 Kiowa, Oklahoma, US
803844 803844 2021-03-01 US Oklahoma Latimer 40077 801 9 0 792 34.87844729 -95.25215049 2021-03-02 05:23:30 Latimer, Oklahoma, US
803845 803845 2021-03-01 US Oklahoma Le Flore 40079 5324 44 0 5280 34.89851864 -94.70392124 2021-03-02 05:23:30 Le Flore, Oklahoma, US
803846 803846 2021-03-01 US Oklahoma Lincoln 40081 3036 54 0 2982 35.70270942 -96.8812462 2021-03-02 05:23:30 Lincoln, Oklahoma, US
803847 803847 2021-03-01 US Oklahoma Logan 40083 3973 28 0 3945 35.91899576 -97.44352845 2021-03-02 05:23:30 Logan, Oklahoma, US
803848 803848 2021-03-01 US Oklahoma Love 40085 1425 11 0 1414 33.95273467 -97.23906784 2021-03-02 05:23:30 Love, Oklahoma, US
803849 803849 2021-03-01 US Oklahoma Major 40093 938 11 0 927 36.31149996 -98.53467076 2021-03-02 05:23:30 Major, Oklahoma, US
803850 803850 2021-03-01 US Oklahoma Marshall 40095 1862 12 0 1850 34.02311222 -96.76855464 2021-03-02 05:23:30 Marshall, Oklahoma, US
803851 803851 2021-03-01 US Oklahoma Mayes 40097 4005 38 0 3967 36.30179091 -95.23175116 2021-03-02 05:23:30 Mayes, Oklahoma, US
803852 803852 2021-03-01 US Oklahoma McClain 40087 5039 48 0 4991 35.01123903 -97.44572302 2021-03-02 05:23:30 McClain, Oklahoma, US
803853 803853 2021-03-01 US Oklahoma McCurtain 40089 3796 64 0 3732 34.11664328 -94.77222373 2021-03-02 05:23:30 McCurtain, Oklahoma, US
803854 803854 2021-03-01 US Oklahoma McIntosh 40091 1925 34 0 1891 35.37235506 -95.66599306 2021-03-02 05:23:30 McIntosh, Oklahoma, US
803855 803855 2021-03-01 US Oklahoma Murray 40099 1918 22 0 1896 34.48116015 -97.06826283 2021-03-02 05:23:30 Murray, Oklahoma, US
803856 803856 2021-03-01 US Oklahoma Muskogee 40101 9094 104 0 8990 35.61318461 -95.37802952 2021-03-02 05:23:30 Muskogee, Oklahoma, US
803857 803857 2021-03-01 US Oklahoma Noble 40103 1347 13 0 1334 36.38953329 -97.22928674 2021-03-02 05:23:30 Noble, Oklahoma, US
803858 803858 2021-03-01 US Oklahoma Nowata 40105 1099 16 0 1083 36.79843529 -95.61902331 2021-03-02 05:23:30 Nowata, Oklahoma, US
803859 803859 2021-03-01 US Oklahoma Okfuskee 40107 1744 20 0 1724 35.46485198 -96.32639984 2021-03-02 05:23:30 Okfuskee, Oklahoma, US
803860 803860 2021-03-01 US Oklahoma Oklahoma 40109 80858 753 0 80105 35.55140095 -97.40716948 2021-03-02 05:23:30 Oklahoma, Oklahoma, US
803861 803861 2021-03-01 US Oklahoma Okmulgee 40111 3624 47 0 3577 35.64661916 -95.96432828 2021-03-02 05:23:30 Okmulgee, Oklahoma, US
803862 803862 2021-03-01 US Oklahoma Osage 40113 4489 50 0 4439 36.62888819 -96.39635704 2021-03-02 05:23:30 Osage, Oklahoma, US
803863 803863 2021-03-01 US Oklahoma Ottawa 40115 3624 45 0 3579 36.83532655 -94.81011909 2021-03-02 05:23:30 Ottawa, Oklahoma, US
803864 803864 2021-03-01 US Oklahoma Out of OK 80040 0 0 0 0 36.83532655 0.0 2021-03-02 05:23:30 Out of OK, Oklahoma, US
803865 803865 2021-03-01 US Oklahoma Pawnee 40117 1704 32 0 1672 36.31743373 -96.7033176 2021-03-02 05:23:30 Pawnee, Oklahoma, US
803866 803866 2021-03-01 US Oklahoma Payne 40119 8360 47 0 8313 36.07695283 -96.97584944 2021-03-02 05:23:30 Payne, Oklahoma, US
803867 803867 2021-03-01 US Oklahoma Pittsburg 40121 4415 36 0 4379 34.92065823 -95.7513432 2021-03-02 05:23:30 Pittsburg, Oklahoma, US
803868 803868 2021-03-01 US Oklahoma Pontotoc 40123 4935 48 0 4887 34.72959848 -96.68337199 2021-03-02 05:23:30 Pontotoc, Oklahoma, US
803869 803869 2021-03-01 US Oklahoma Pottawatomie 40125 7888 78 0 7810 35.20614018 -96.94923008 2021-03-02 05:23:30 Pottawatomie, Oklahoma, US
803870 803870 2021-03-01 US Oklahoma Pushmataha 40127 984 14 0 970 34.41635232 -95.37603505 2021-03-02 05:23:30 Pushmataha, Oklahoma, US
803871 803871 2021-03-01 US Oklahoma Roger Mills 40129 382 7 0 375 35.68711719 -99.69666167 2021-03-02 05:23:30 Roger Mills, Oklahoma, US
803872 803872 2021-03-01 US Oklahoma Rogers 40131 9897 119 0 9778 36.37004357 -95.60406759 2021-03-02 05:23:30 Rogers, Oklahoma, US
803873 803873 2021-03-01 US Oklahoma Seminole 40133 2752 39 0 2713 35.16478725 -96.61686741 2021-03-02 05:23:30 Seminole, Oklahoma, US
803874 803874 2021-03-01 US Oklahoma Sequoyah 40135 3915 31 0 3884 35.49447108 -94.75463785 2021-03-02 05:23:30 Sequoyah, Oklahoma, US
803875 803875 2021-03-01 US Oklahoma Stephens 40137 4677 67 0 4610 34.48556989 -97.85141892 2021-03-02 05:23:30 Stephens, Oklahoma, US
803876 803876 2021-03-01 US Oklahoma Texas 40139 3448 24 0 3424 36.74777635 -101.4889765 2021-03-02 05:23:30 Texas, Oklahoma, US
803877 803877 2021-03-01 US Oklahoma Tillman 40141 749 14 0 735 34.37288446 -98.92426619 2021-03-02 05:23:30 Tillman, Oklahoma, US
803878 803878 2021-03-01 US Oklahoma Tulsa 40143 70999 710 0 70289 36.11939621 -95.94013939 2021-03-02 05:23:30 Tulsa, Oklahoma, US
803879 803879 2021-03-01 US Oklahoma Unassigned 90040 2 0 0 2 36.83532655 0.0 2021-03-02 05:23:30 Unassigned, Oklahoma, US
803880 803880 2021-03-01 US Oklahoma Wagoner 40145 7702 83 0 7619 35.96024096 -95.51911308 2021-03-02 05:23:30 Wagoner, Oklahoma, US
803881 803881 2021-03-01 US Oklahoma Washington 40147 4772 89 0 4683 36.71380786 -95.90514104 2021-03-02 05:23:30 Washington, Oklahoma, US
803882 803882 2021-03-01 US Oklahoma Washita 40149 1054 9 0 1045 35.29071824 -98.99180434 2021-03-02 05:23:30 Washita, Oklahoma, US
803883 803883 2021-03-01 US Oklahoma Woods 40151 1185 11 0 1174 36.76705782 -98.86573064 2021-03-02 05:23:30 Woods, Oklahoma, US
803884 803884 2021-03-01 US Oklahoma Woodward 40153 3086 18 0 3068 36.42316318 -99.26283045 2021-03-02 05:23:30 Woodward, Oklahoma, US
1068948 1068948 2021-02-28 US Oklahoma Adair 40001 3096 24 0 3072 35.88494195 -94.65859267 2021-03-01 05:23:01 Adair, Oklahoma, US
1068949 1068949 2021-02-28 US Oklahoma Alfalfa 40003 1148 5 0 1143 36.73090616 -98.32408495 2021-03-01 05:23:01 Alfalfa, Oklahoma, US
1068950 1068950 2021-02-28 US Oklahoma Atoka 40005 1764 12 0 1752 34.37366573 -96.03802487 2021-03-01 05:23:01 Atoka, Oklahoma, US
1068951 1068951 2021-02-28 US Oklahoma Beaver 40007 440 6 0 434 36.7496847 -100.4758872 2021-03-01 05:23:01 Beaver, Oklahoma, US
1068952 1068952 2021-02-28 US Oklahoma Beckham 40009 2708 37 0 2671 35.26862449 -99.68128023 2021-03-01 05:23:01 Beckham, Oklahoma, US
1068953 1068953 2021-02-28 US Oklahoma Blaine 40011 994 8 0 986 35.87518314 -98.43307003 2021-03-01 05:23:01 Blaine, Oklahoma, US
1068954 1068954 2021-02-28 US Oklahoma Bryan 40013 5907 55 0 5852 33.96472458 -96.25903472 2021-03-01 05:23:01 Bryan, Oklahoma, US
1068955 1068955 2021-02-28 US Oklahoma Caddo 40015 3804 56 0 3748 35.17364557 -98.37534464 2021-03-01 05:23:01 Caddo, Oklahoma, US
1068956 1068956 2021-02-28 US Oklahoma Canadian 40017 15843 95 0 15748 35.5426055 -97.98465569 2021-03-01 05:23:01 Canadian, Oklahoma, US
1068957 1068957 2021-02-28 US Oklahoma Carter 40019 5718 59 0 5659 34.25103751 -97.28552485 2021-03-01 05:23:01 Carter, Oklahoma, US
1068958 1068958 2021-02-28 US Oklahoma Cherokee 40021 5416 42 0 5374 35.90692775 -94.99980896 2021-03-01 05:23:01 Cherokee, Oklahoma, US
1068959 1068959 2021-02-28 US Oklahoma Choctaw 40023 1551 14 0 1537 34.02807439 -95.54771129 2021-03-01 05:23:01 Choctaw, Oklahoma, US
1068960 1068960 2021-02-28 US Oklahoma Cimarron 40025 176 1 0 175 36.74817177 -102.5173885 2021-03-01 05:23:01 Cimarron, Oklahoma, US
1068961 1068961 2021-02-28 US Oklahoma Cleveland 40027 28695 268 0 28427 35.20413532 -97.32519562 2021-03-01 05:23:01 Cleveland, Oklahoma, US
1068962 1068962 2021-02-28 US Oklahoma Coal 40029 683 14 0 669 34.58840127 -96.29798747 2021-03-01 05:23:01 Coal, Oklahoma, US
1068963 1068963 2021-02-28 US Oklahoma Comanche 40031 11995 131 0 11864 34.65973764 -98.47195055 2021-03-01 05:23:01 Comanche, Oklahoma, US
1068964 1068964 2021-02-28 US Oklahoma Cotton 40033 651 13 0 638 34.28845626 -98.37053567 2021-03-01 05:23:01 Cotton, Oklahoma, US
1068965 1068965 2021-02-28 US Oklahoma Craig 40035 1892 11 0 1881 36.76268118 -95.20916602 2021-03-01 05:23:01 Craig, Oklahoma, US
1068966 1068966 2021-02-28 US Oklahoma Creek 40037 6530 115 0 6415 35.90230551 -96.37086028 2021-03-01 05:23:01 Creek, Oklahoma, US
1068967 1068967 2021-02-28 US Oklahoma Custer 40039 4000 70 0 3930 35.63853802 -99.00170785 2021-03-01 05:23:01 Custer, Oklahoma, US
1068968 1068968 2021-02-28 US Oklahoma Delaware 40041 4370 62 0 4308 36.40823634 -94.80325046 2021-03-01 05:23:01 Delaware, Oklahoma, US

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [johns_hopkins_csse_daily_reports] (
   [day] TEXT,
   [country_or_region] TEXT,
   [province_or_state] TEXT,
   [admin2] TEXT,
   [fips] TEXT,
   [confirmed] INTEGER,
   [deaths] INTEGER,
   [recovered] INTEGER,
   [active] TEXT,
   [latitude] TEXT,
   [longitude] TEXT,
   [last_update] TEXT,
   [combined_key] TEXT
);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day]
    ON [johns_hopkins_csse_daily_reports] ([day]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state]
    ON [johns_hopkins_csse_daily_reports] ([province_or_state]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region]
    ON [johns_hopkins_csse_daily_reports] ([country_or_region]);
CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key]
    ON [johns_hopkins_csse_daily_reports] ([combined_key]);