johns_hopkins_csse_daily_reports

⚠️ 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

10,646 rows where province_or_state = "Oklahoma" sorted by day descending

View and edit SQL

Suggested facets: day (date), last_update (date)

province_or_state

  • Oklahoma · 10,646

country_or_region

  • US 10,646
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
496311 2020-08-11 US Oklahoma Ottawa 40115 387 3 0 384 36.83532655 -94.81011909 2020-08-12 04:27:29 Ottawa, Oklahoma, US
496312 2020-08-11 US Oklahoma Adair 40001 344 6 0 338 35.88494195 -94.65859267 2020-08-12 04:27:29 Adair, Oklahoma, US
496313 2020-08-11 US Oklahoma Mayes 40097 326 6 0 320 36.30179091 -95.23175116 2020-08-12 04:27:29 Mayes, Oklahoma, US
496314 2020-08-11 US Oklahoma Seminole 40133 241 5 0 236 35.16478725 -96.61686741 2020-08-12 04:27:29 Seminole, Oklahoma, US
496315 2020-08-11 US Oklahoma Love 40085 75 0 0 75 33.95273467 -97.23906784 2020-08-12 04:27:29 Love, Oklahoma, US
496316 2020-08-11 US Oklahoma Nowata 40105 58 1 0 57 36.79843529 -95.61902331 2020-08-12 04:27:29 Nowata, Oklahoma, US
496317 2020-08-11 US Oklahoma Woodward 40153 41 0 0 41 36.42316318 -99.26283045 2020-08-12 04:27:29 Woodward, Oklahoma, US
496318 2020-08-11 US Oklahoma Beaver 40007 37 0 0 37 36.7496847 -100.4758872 2020-08-12 04:27:29 Beaver, Oklahoma, US
496331 2020-08-11 US Oklahoma Ellis 40045 5 0 0 5 36.2180194 -99.75324573 2020-08-12 04:27:29 Ellis, Oklahoma, US
496681 2020-08-11 US Oklahoma Garfield 40047 492 5 0 487 36.3791334 -97.78265517 2020-08-12 04:27:29 Garfield, Oklahoma, US
496682 2020-08-11 US Oklahoma Grady 40051 445 7 0 438 35.0167709 -97.88339847 2020-08-12 04:27:29 Grady, Oklahoma, US
496683 2020-08-11 US Oklahoma Delaware 40041 438 20 0 418 36.40823634 -94.80325046 2020-08-12 04:27:29 Delaware, Oklahoma, US
496684 2020-08-11 US Oklahoma Sequoyah 40135 354 4 0 350 35.49447108 -94.75463785 2020-08-12 04:27:29 Sequoyah, Oklahoma, US
496685 2020-08-11 US Oklahoma Kay 40071 251 11 0 240 36.81799745 -97.14421435 2020-08-12 04:27:29 Kay, Oklahoma, US
496686 2020-08-11 US Oklahoma Pontotoc 40123 207 2 0 205 34.72959848 -96.68337199 2020-08-12 04:27:29 Pontotoc, Oklahoma, US
496687 2020-08-11 US Oklahoma McIntosh 40091 194 1 0 193 35.37235506 -95.66599306 2020-08-12 04:27:29 McIntosh, Oklahoma, US
496688 2020-08-11 US Oklahoma Murray 40099 76 0 0 76 34.48116015 -97.06826283 2020-08-12 04:27:29 Murray, Oklahoma, US
496689 2020-08-11 US Oklahoma Tillman 40141 59 1 0 58 34.37288446 -98.92426619 2020-08-12 04:27:29 Tillman, Oklahoma, US
496690 2020-08-11 US Oklahoma Coal 40029 39 0 0 39 34.58840127 -96.29798747 2020-08-12 04:27:29 Coal, Oklahoma, US
496722 2020-08-11 US Oklahoma Tulsa 40143 10747 108 0 10639 36.11939621 -95.94013939 2020-08-12 04:27:29 Tulsa, Oklahoma, US
496726 2020-08-11 US Oklahoma Cimarron 40025 1 0 0 1 36.74817177 -102.5173885 2020-08-12 04:27:29 Cimarron, Oklahoma, US
497185 2020-08-11 US Oklahoma Okmulgee 40111 479 3 0 476 35.64661916 -95.96432828 2020-08-12 04:27:29 Okmulgee, Oklahoma, US
497186 2020-08-11 US Oklahoma Osage 40113 431 11 0 420 36.62888819 -96.39635704 2020-08-12 04:27:29 Osage, Oklahoma, US
497188 2020-08-11 US Oklahoma Custer 40039 209 0 0 209 35.63853802 -99.00170785 2020-08-12 04:27:29 Custer, Oklahoma, US
497189 2020-08-11 US Oklahoma Latimer 40077 93 1 0 92 34.87844729 -95.25215049 2020-08-12 04:27:29 Latimer, Oklahoma, US
497190 2020-08-11 US Oklahoma Craig 40035 86 1 0 85 36.76268118 -95.20916602 2020-08-12 04:27:29 Craig, Oklahoma, US
497191 2020-08-11 US Oklahoma Major 40093 35 1 0 34 36.31149996 -98.53467076 2020-08-12 04:27:29 Major, Oklahoma, US
497229 2020-08-11 US Oklahoma Canadian 40017 1238 9 0 1229 35.5426055 -97.98465569 2020-08-12 04:27:29 Canadian, Oklahoma, US
497648 2020-08-11 US Oklahoma Pottawatomie 40125 459 9 0 450 35.20614018 -96.94923008 2020-08-12 04:27:29 Pottawatomie, Oklahoma, US
497649 2020-08-11 US Oklahoma Le Flore 40079 360 1 0 359 34.89851864 -94.70392124 2020-08-12 04:27:29 Le Flore, Oklahoma, US
497650 2020-08-11 US Oklahoma Pawnee 40117 149 3 0 146 36.31743373 -96.7033176 2020-08-12 04:27:29 Pawnee, Oklahoma, US
497651 2020-08-11 US Oklahoma Marshall 40095 110 1 0 109 34.02311222 -96.76855464 2020-08-12 04:27:29 Marshall, Oklahoma, US
497652 2020-08-11 US Oklahoma Haskell 40061 62 0 0 62 35.22257600000001 -95.11513306 2020-08-12 04:27:29 Haskell, Oklahoma, US
497686 2020-08-11 US Oklahoma Texas 40139 1058 7 0 1051 36.74777635 -101.4889765 2020-08-12 04:27:29 Texas, Oklahoma, US
497690 2020-08-11 US Oklahoma Harmon 40057 32 0 0 32 34.7440135 -99.84741652 2020-08-12 04:27:29 Harmon, Oklahoma, US
497691 2020-08-11 US Oklahoma Woods 40151 20 0 0 20 36.76705782 -98.86573064 2020-08-12 04:27:29 Woods, Oklahoma, US
497692 2020-08-11 US Oklahoma Cotton 40033 19 2 0 17 34.28845626 -98.37053567 2020-08-12 04:27:29 Cotton, Oklahoma, US
497693 2020-08-11 US Oklahoma Roger Mills 40129 9 1 0 8 35.68711719 -99.69666167 2020-08-12 04:27:29 Roger Mills, Oklahoma, US
497694 2020-08-11 US Oklahoma Unassigned 90040 3 0 0 3 36.83532655 0.0 2020-08-12 04:27:29 Unassigned, Oklahoma, US
497695 2020-08-11 US Oklahoma Alfalfa 40003 3 0 0 3 36.73090616 -98.32408495 2020-08-12 04:27:29 Alfalfa, Oklahoma, US
498122 2020-08-11 US Oklahoma Cherokee 40021 449 2 0 447 35.90692775 -94.99980896 2020-08-12 04:27:29 Cherokee, Oklahoma, US
498123 2020-08-11 US Oklahoma Caddo 40015 427 17 0 410 35.17364557 -98.37534464 2020-08-12 04:27:29 Caddo, Oklahoma, US
498124 2020-08-11 US Oklahoma Logan 40083 225 1 0 224 35.91899576 -97.44352845 2020-08-12 04:27:29 Logan, Oklahoma, US
498125 2020-08-11 US Oklahoma Lincoln 40081 174 2 0 172 35.70270942 -96.8812462 2020-08-12 04:27:29 Lincoln, Oklahoma, US
498126 2020-08-11 US Oklahoma Pushmataha 40127 109 0 0 109 34.41635232 -95.37603505 2020-08-12 04:27:29 Pushmataha, Oklahoma, US
498127 2020-08-11 US Oklahoma Greer 40055 83 8 0 75 34.93535801 -99.5605612 2020-08-12 04:27:29 Greer, Oklahoma, US
498165 2020-08-11 US Oklahoma Oklahoma 40109 10794 115 0 10679 35.55140095 -97.40716948 2020-08-12 04:27:29 Oklahoma, Oklahoma, US
498166 2020-08-11 US Oklahoma Rogers 40131 1020 17 0 1003 36.37004357 -95.60406759 2020-08-12 04:27:29 Rogers, Oklahoma, US
498167 2020-08-11 US Oklahoma Wagoner 40145 890 23 0 867 35.96024096 -95.51911308 2020-08-12 04:27:29 Wagoner, Oklahoma, US
498173 2020-08-11 US Oklahoma Kiowa 40075 30 1 0 29 34.91671958 -98.97720696 2020-08-12 04:27:29 Kiowa, Oklahoma, US
498174 2020-08-11 US Oklahoma Out of OK 80040 0 0 0 0 36.83532655 0.0 2020-08-12 04:27:29 Out of OK, Oklahoma, US
498636 2020-08-11 US Oklahoma Payne 40119 754 4 0 750 36.07695283 -96.97584944 2020-08-12 04:27:29 Payne, Oklahoma, US
498637 2020-08-11 US Oklahoma Jackson 40065 527 7 0 520 34.58781741 -99.41138784 2020-08-12 04:27:29 Jackson, Oklahoma, US
498639 2020-08-11 US Oklahoma Kingfisher 40073 138 0 0 138 35.94530008 -97.94193268 2020-08-12 04:27:29 Kingfisher, Oklahoma, US
498640 2020-08-11 US Oklahoma Noble 40103 87 2 0 85 36.38953329 -97.22928674 2020-08-12 04:27:29 Noble, Oklahoma, US
498641 2020-08-11 US Oklahoma Atoka 40005 76 0 0 76 34.37366573 -96.03802487 2020-08-12 04:27:29 Atoka, Oklahoma, US
498642 2020-08-11 US Oklahoma Okfuskee 40107 71 1 0 70 35.46485198 -96.32639984 2020-08-12 04:27:29 Okfuskee, Oklahoma, US
498643 2020-08-11 US Oklahoma Blaine 40011 45 0 0 45 35.87518314 -98.43307003 2020-08-12 04:27:29 Blaine, Oklahoma, US
498676 2020-08-11 US Oklahoma Cleveland 40027 3048 56 0 2992 35.20413532 -97.32519562 2020-08-12 04:27:29 Cleveland, Oklahoma, US
498677 2020-08-11 US Oklahoma McCurtain 40089 865 28 0 837 34.11664328 -94.77222373 2020-08-12 04:27:29 McCurtain, Oklahoma, US
499114 2020-08-11 US Oklahoma Washington 40147 642 39 0 603 36.71380786 -95.90514104 2020-08-12 04:27:29 Washington, Oklahoma, US
499115 2020-08-11 US Oklahoma Creek 40037 621 14 0 607 35.90230551 -96.37086028 2020-08-12 04:27:29 Creek, Oklahoma, US
499116 2020-08-11 US Oklahoma Muskogee 40101 520 16 0 504 35.61318461 -95.37802952 2020-08-12 04:27:29 Muskogee, Oklahoma, US
499117 2020-08-11 US Oklahoma Pittsburg 40121 377 4 0 373 34.92065823 -95.7513432 2020-08-12 04:27:29 Pittsburg, Oklahoma, US
499119 2020-08-11 US Oklahoma Choctaw 40023 191 1 0 190 34.02807439 -95.54771129 2020-08-12 04:27:29 Choctaw, Oklahoma, US
499120 2020-08-11 US Oklahoma Hughes 40063 141 2 0 139 35.04912569 -96.24921145 2020-08-12 04:27:29 Hughes, Oklahoma, US
499121 2020-08-11 US Oklahoma Beckham 40009 61 1 0 60 35.26862449 -99.68128023 2020-08-12 04:27:29 Beckham, Oklahoma, US
499122 2020-08-11 US Oklahoma Johnston 40069 48 0 0 48 34.31440473 -96.66011537 2020-08-12 04:27:29 Johnston, Oklahoma, US
499159 2020-08-11 US Oklahoma Jefferson 40067 33 0 0 33 34.11130184 -97.83182974 2020-08-12 04:27:29 Jefferson, Oklahoma, US
499600 2020-08-11 US Oklahoma Comanche 40031 840 10 0 830 34.65973764 -98.47195055 2020-08-12 04:27:29 Comanche, Oklahoma, US
499601 2020-08-11 US Oklahoma Bryan 40013 465 1 0 464 33.96472458 -96.25903472 2020-08-12 04:27:29 Bryan, Oklahoma, US
499602 2020-08-11 US Oklahoma McClain 40087 454 4 0 450 35.01123903 -97.44572302 2020-08-12 04:27:29 McClain, Oklahoma, US
499603 2020-08-11 US Oklahoma Carter 40019 349 5 0 344 34.25103751 -97.28552485 2020-08-12 04:27:29 Carter, Oklahoma, US
499604 2020-08-11 US Oklahoma Garvin 40049 235 4 0 231 34.70418038 -97.30811132 2020-08-12 04:27:29 Garvin, Oklahoma, US
499605 2020-08-11 US Oklahoma Stephens 40137 202 3 0 199 34.48556989 -97.85141892 2020-08-12 04:27:29 Stephens, Oklahoma, US
499656 2020-08-11 US Oklahoma Harper 40059 10 0 0 10 36.78836519 -99.6679804 2020-08-12 04:27:29 Harper, Oklahoma, US
499920 2020-08-11 US Oklahoma Washita 40149 29 0 0 29 35.29071824 -98.99180434 2020-08-12 04:27:29 Washita, Oklahoma, US
499921 2020-08-11 US Oklahoma Grant 40053 16 0 0 16 36.796297 -97.78638765 2020-08-12 04:27:29 Grant, Oklahoma, US
499922 2020-08-11 US Oklahoma Dewey 40043 10 0 0 10 35.98772922 -99.00730714 2020-08-12 04:27:29 Dewey, Oklahoma, US
274085 2020-08-10 US Oklahoma Adair 40001 341 6 0 335 35.88494195 -94.65859267 2020-08-11 04:35:08 Adair, Oklahoma, US
274120 2020-08-10 US Oklahoma Alfalfa 40003 3 0 0 3 36.73090616 -98.32408495 2020-08-11 04:35:08 Alfalfa, Oklahoma, US
274188 2020-08-10 US Oklahoma Atoka 40005 70 0 0 70 34.37366573 -96.03802487 2020-08-11 04:35:08 Atoka, Oklahoma, US
274249 2020-08-10 US Oklahoma Beaver 40007 36 0 0 36 36.7496847 -100.4758872 2020-08-11 04:35:08 Beaver, Oklahoma, US
274253 2020-08-10 US Oklahoma Beckham 40009 59 1 0 58 35.26862449 -99.68128023 2020-08-11 04:35:08 Beckham, Oklahoma, US
274304 2020-08-10 US Oklahoma Blaine 40011 42 0 0 42 35.87518314 -98.43307003 2020-08-11 04:35:08 Blaine, Oklahoma, US
274384 2020-08-10 US Oklahoma Bryan 40013 458 1 0 457 33.96472458 -96.25903472 2020-08-11 04:35:08 Bryan, Oklahoma, US
274424 2020-08-10 US Oklahoma Caddo 40015 425 16 0 409 35.17364557 -98.37534464 2020-08-11 04:35:08 Caddo, Oklahoma, US
274466 2020-08-10 US Oklahoma Canadian 40017 1224 7 0 1217 35.5426055 -97.98465569 2020-08-11 04:35:08 Canadian, Oklahoma, US
274499 2020-08-10 US Oklahoma Carter 40019 342 4 0 338 34.25103751 -97.28552485 2020-08-11 04:35:08 Carter, Oklahoma, US
274568 2020-08-10 US Oklahoma Cherokee 40021 445 2 0 443 35.90692775 -94.99980896 2020-08-11 04:35:08 Cherokee, Oklahoma, US
274594 2020-08-10 US Oklahoma Choctaw 40023 188 1 0 187 34.02807439 -95.54771129 2020-08-11 04:35:08 Choctaw, Oklahoma, US
274604 2020-08-10 US Oklahoma Cimarron 40025 1 0 0 1 36.74817177 -102.5173885 2020-08-11 04:35:08 Cimarron, Oklahoma, US
274661 2020-08-10 US Oklahoma Cleveland 40027 3017 55 0 2962 35.20413532 -97.32519562 2020-08-11 04:35:08 Cleveland, Oklahoma, US
274674 2020-08-10 US Oklahoma Coal 40029 37 0 0 37 34.58840127 -96.29798747 2020-08-11 04:35:08 Coal, Oklahoma, US
274713 2020-08-10 US Oklahoma Comanche 40031 831 10 0 821 34.65973764 -98.47195055 2020-08-11 04:35:08 Comanche, Oklahoma, US
274739 2020-08-10 US Oklahoma Cotton 40033 18 2 0 16 34.28845626 -98.37053567 2020-08-11 04:35:08 Cotton, Oklahoma, US
274747 2020-08-10 US Oklahoma Craig 40035 86 0 0 86 36.76268118 -95.20916602 2020-08-11 04:35:08 Craig, Oklahoma, US
274763 2020-08-10 US Oklahoma Creek 40037 607 14 0 593 35.90230551 -96.37086028 2020-08-11 04:35:08 Creek, Oklahoma, US
274796 2020-08-10 US Oklahoma Custer 40039 206 0 0 206 35.63853802 -99.00170785 2020-08-11 04:35:08 Custer, Oklahoma, US
274858 2020-08-10 US Oklahoma Delaware 40041 431 19 0 412 36.40823634 -94.80325046 2020-08-11 04:35:08 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] INTEGER,
   [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]);
Powered by Datasette · Query took 2028.986ms · Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette