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

45,248 rows where province_or_state = "Oklahoma" sorted by day descending

✎ View and edit SQL

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

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

province_or_state

  • Oklahoma · 45,248 ✖

country_or_region

  • US 45,248
Link rowid day ▲ country_or_region province_or_state admin2 fips confirmed deaths recovered active latitude longitude last_update combined_key
34811 34811 2021-10-23 US Oklahoma Adair 40001 4850 61 0   35.88494195 -94.65859267 2021-10-24 04:21:22 Adair, Oklahoma, US
34812 34812 2021-10-23 US Oklahoma Alfalfa 40003 1299 7 0   36.73090616 -98.32408495 2021-10-24 04:21:22 Alfalfa, Oklahoma, US
34813 34813 2021-10-23 US Oklahoma Atoka 40005 2724 32 0   34.37366573 -96.03802487 2021-10-24 04:21:22 Atoka, Oklahoma, US
34814 34814 2021-10-23 US Oklahoma Beaver 40007 565 9 0   36.7496847 -100.4758872 2021-10-24 04:21:22 Beaver, Oklahoma, US
34815 34815 2021-10-23 US Oklahoma Beckham 40009 3445 74 0   35.26862449 -99.68128023 2021-10-24 04:21:22 Beckham, Oklahoma, US
34816 34816 2021-10-23 US Oklahoma Blaine 40011 1492 27 0   35.87518314 -98.43307003 2021-10-24 04:21:22 Blaine, Oklahoma, US
34817 34817 2021-10-23 US Oklahoma Bryan 40013 8651 106 0   33.96472458 -96.25903472 2021-10-24 04:21:22 Bryan, Oklahoma, US
34818 34818 2021-10-23 US Oklahoma Caddo 40015 5175 129 0   35.17364557 -98.37534464 2021-10-24 04:21:22 Caddo, Oklahoma, US
34819 34819 2021-10-23 US Oklahoma Canadian 40017 22956 280 0   35.5426055 -97.98465569 2021-10-24 04:21:22 Canadian, Oklahoma, US
34820 34820 2021-10-23 US Oklahoma Carter 40019 8921 184 0   34.25103751 -97.28552485 2021-10-24 04:21:22 Carter, Oklahoma, US
34821 34821 2021-10-23 US Oklahoma Cherokee 40021 8983 113 0   35.90692775 -94.99980896 2021-10-24 04:21:22 Cherokee, Oklahoma, US
34822 34822 2021-10-23 US Oklahoma Choctaw 40023 2728 49 0   34.02807439 -95.54771129 2021-10-24 04:21:22 Choctaw, Oklahoma, US
34823 34823 2021-10-23 US Oklahoma Cimarron 40025 323 2 0   36.74817177 -102.5173885 2021-10-24 04:21:22 Cimarron, Oklahoma, US
34824 34824 2021-10-23 US Oklahoma Cleveland 40027 43056 599 0   35.20413532 -97.32519562 2021-10-24 04:21:22 Cleveland, Oklahoma, US
34825 34825 2021-10-23 US Oklahoma Coal 40029 1052 20 0   34.58840127 -96.29798747 2021-10-24 04:21:22 Coal, Oklahoma, US
34826 34826 2021-10-23 US Oklahoma Comanche 40031 21021 292 0   34.65973764 -98.47195055 2021-10-24 04:21:22 Comanche, Oklahoma, US
34827 34827 2021-10-23 US Oklahoma Cotton 40033 981 22 0   34.28845626 -98.37053567 2021-10-24 04:21:22 Cotton, Oklahoma, US
34828 34828 2021-10-23 US Oklahoma Craig 40035 2989 32 0   36.76268118 -95.20916602 2021-10-24 04:21:22 Craig, Oklahoma, US
34829 34829 2021-10-23 US Oklahoma Creek 40037 11050 252 0   35.90230551 -96.37086028 2021-10-24 04:21:22 Creek, Oklahoma, US
34830 34830 2021-10-23 US Oklahoma Custer 40039 4978 128 0   35.63853802 -99.00170785 2021-10-24 04:21:22 Custer, Oklahoma, US
34831 34831 2021-10-23 US Oklahoma Delaware 40041 7274 159 0   36.40823634 -94.80325046 2021-10-24 04:21:22 Delaware, Oklahoma, US
34832 34832 2021-10-23 US Oklahoma Dewey 40043 666 18 0   35.98772922 -99.00730714 2021-10-24 04:21:22 Dewey, Oklahoma, US
34833 34833 2021-10-23 US Oklahoma Ellis 40045 453 6 0   36.218019399999996 -99.75324573 2021-10-24 04:21:22 Ellis, Oklahoma, US
34834 34834 2021-10-23 US Oklahoma Garfield 40047 10077 199 0   36.3791334 -97.78265517 2021-10-24 04:21:22 Garfield, Oklahoma, US
34835 34835 2021-10-23 US Oklahoma Garvin 40049 4692 100 0   34.70418038 -97.30811132 2021-10-24 04:21:22 Garvin, Oklahoma, US
34836 34836 2021-10-23 US Oklahoma Grady 40051 8007 182 0   35.0167709 -97.88339847 2021-10-24 04:21:22 Grady, Oklahoma, US
34837 34837 2021-10-23 US Oklahoma Grant 40053 692 8 0   36.796296999999996 -97.78638765 2021-10-24 04:21:22 Grant, Oklahoma, US
34838 34838 2021-10-23 US Oklahoma Greer 40055 744 25 0   34.93535801 -99.56056120000001 2021-10-24 04:21:22 Greer, Oklahoma, US
34839 34839 2021-10-23 US Oklahoma Harmon 40057 361 6 0   34.7440135 -99.84741652 2021-10-24 04:21:22 Harmon, Oklahoma, US
34840 34840 2021-10-23 US Oklahoma Harper 40059 486 9 0   36.78836519 -99.6679804 2021-10-24 04:21:22 Harper, Oklahoma, US
34841 34841 2021-10-23 US Oklahoma Haskell 40061 1837 27 0   35.22257600000001 -95.11513306 2021-10-24 04:21:22 Haskell, Oklahoma, US
34842 34842 2021-10-23 US Oklahoma Hughes 40063 1710 43 0   35.04912569 -96.24921145 2021-10-24 04:21:22 Hughes, Oklahoma, US
34843 34843 2021-10-23 US Oklahoma Jackson 40065 3884 83 0   34.58781741 -99.41138784 2021-10-24 04:21:22 Jackson, Oklahoma, US
34844 34844 2021-10-23 US Oklahoma Jefferson 40067 933 20 0   34.11130184 -97.83182974 2021-10-24 04:21:22 Jefferson, Oklahoma, US
34845 34845 2021-10-23 US Oklahoma Johnston 40069 1933 45 0   34.31440473 -96.66011537 2021-10-24 04:21:22 Johnston, Oklahoma, US
34846 34846 2021-10-23 US Oklahoma Kay 40071 7166 164 0   36.81799745 -97.14421435 2021-10-24 04:21:22 Kay, Oklahoma, US
34847 34847 2021-10-23 US Oklahoma Kingfisher 40073 2576 55 0   35.94530008 -97.94193268 2021-10-24 04:21:22 Kingfisher, Oklahoma, US
34848 34848 2021-10-23 US Oklahoma Kiowa 40075 1135 39 0   34.91671958 -98.97720696 2021-10-24 04:21:22 Kiowa, Oklahoma, US
34849 34849 2021-10-23 US Oklahoma Latimer 40077 1469 18 0   34.87844729 -95.25215049 2021-10-24 04:21:22 Latimer, Oklahoma, US
34850 34850 2021-10-23 US Oklahoma Le Flore 40079 7963 85 0   34.89851864 -94.70392124 2021-10-24 04:21:22 Le Flore, Oklahoma, US
34851 34851 2021-10-23 US Oklahoma Lincoln 40081 4839 107 0   35.70270942 -96.8812462 2021-10-24 04:21:22 Lincoln, Oklahoma, US
34852 34852 2021-10-23 US Oklahoma Logan 40083 6053 111 0   35.91899576 -97.44352845 2021-10-24 04:21:22 Logan, Oklahoma, US
34853 34853 2021-10-23 US Oklahoma Love 40085 1983 29 0   33.95273467 -97.23906784 2021-10-24 04:21:22 Love, Oklahoma, US
34854 34854 2021-10-23 US Oklahoma Major 40093 1251 32 0   36.31149996 -98.53467076 2021-10-24 04:21:22 Major, Oklahoma, US
34855 34855 2021-10-23 US Oklahoma Marshall 40095 2695 27 0   34.02311222 -96.76855464 2021-10-24 04:21:22 Marshall, Oklahoma, US
34856 34856 2021-10-23 US Oklahoma Mayes 40097 6703 122 0   36.30179091 -95.23175116 2021-10-24 04:21:22 Mayes, Oklahoma, US
34857 34857 2021-10-23 US Oklahoma McClain 40087 7399 100 0   35.01123903 -97.44572302 2021-10-24 04:21:22 McClain, Oklahoma, US
34858 34858 2021-10-23 US Oklahoma McCurtain 40089 5668 121 0   34.11664328 -94.77222373 2021-10-24 04:21:22 McCurtain, Oklahoma, US
34859 34859 2021-10-23 US Oklahoma McIntosh 40091 2855 90 0   35.37235506 -95.66599306 2021-10-24 04:21:22 McIntosh, Oklahoma, US
34860 34860 2021-10-23 US Oklahoma Murray 40099 2598 53 0   34.48116015 -97.06826283 2021-10-24 04:21:22 Murray, Oklahoma, US
34861 34861 2021-10-23 US Oklahoma Muskogee 40101 13336 256 0   35.61318461 -95.37802952 2021-10-24 04:21:22 Muskogee, Oklahoma, US
34862 34862 2021-10-23 US Oklahoma Noble 40103 1882 30 0   36.38953329 -97.22928674 2021-10-24 04:21:22 Noble, Oklahoma, US
34863 34863 2021-10-23 US Oklahoma Nowata 40105 1778 28 0   36.79843529 -95.61902331 2021-10-24 04:21:22 Nowata, Oklahoma, US
34864 34864 2021-10-23 US Oklahoma Okfuskee 40107 2292 45 0   35.46485198 -96.32639984 2021-10-24 04:21:22 Okfuskee, Oklahoma, US
34865 34865 2021-10-23 US Oklahoma Oklahoma 40109 118645 1835 0   35.55140095 -97.40716948 2021-10-24 04:21:22 Oklahoma, Oklahoma, US
34866 34866 2021-10-23 US Oklahoma Okmulgee 40111 5853 138 0   35.64661916 -95.96432828 2021-10-24 04:21:22 Okmulgee, Oklahoma, US
34867 34867 2021-10-23 US Oklahoma Osage 40113 6827 125 0   36.62888819 -96.39635704 2021-10-24 04:21:22 Osage, Oklahoma, US
34868 34868 2021-10-23 US Oklahoma Ottawa 40115 6039 100 0   36.83532655 -94.81011909 2021-10-24 04:21:22 Ottawa, Oklahoma, US
34869 34869 2021-10-23 US Oklahoma Out of OK 80040 0 0 0   36.83532655 0.0 2021-10-24 04:21:22 Out of OK, Oklahoma, US
34870 34870 2021-10-23 US Oklahoma Pawnee 40117 2625 65 0   36.31743373 -96.70331759999999 2021-10-24 04:21:22 Pawnee, Oklahoma, US
34871 34871 2021-10-23 US Oklahoma Payne 40119 11873 111 0   36.07695283 -96.97584944 2021-10-24 04:21:22 Payne, Oklahoma, US
34872 34872 2021-10-23 US Oklahoma Pittsburg 40121 6705 155 0   34.92065823 -95.75134320000001 2021-10-24 04:21:22 Pittsburg, Oklahoma, US
34873 34873 2021-10-23 US Oklahoma Pontotoc 40123 6764 97 0   34.72959848 -96.68337199 2021-10-24 04:21:22 Pontotoc, Oklahoma, US
34874 34874 2021-10-23 US Oklahoma Pottawatomie 40125 12022 189 0   35.20614018 -96.94923008 2021-10-24 04:21:22 Pottawatomie, Oklahoma, US
34875 34875 2021-10-23 US Oklahoma Pushmataha 40127 1770 38 0   34.41635232 -95.37603505 2021-10-24 04:21:22 Pushmataha, Oklahoma, US
34876 34876 2021-10-23 US Oklahoma Roger Mills 40129 494 12 0   35.68711719 -99.69666167 2021-10-24 04:21:22 Roger Mills, Oklahoma, US
34877 34877 2021-10-23 US Oklahoma Rogers 40131 15620 284 0   36.37004357 -95.60406759 2021-10-24 04:21:22 Rogers, Oklahoma, US
34878 34878 2021-10-23 US Oklahoma Seminole 40133 3815 102 0   35.16478725 -96.61686741 2021-10-24 04:21:22 Seminole, Oklahoma, US
34879 34879 2021-10-23 US Oklahoma Sequoyah 40135 6673 84 0   35.49447108 -94.75463785 2021-10-24 04:21:22 Sequoyah, Oklahoma, US
34880 34880 2021-10-23 US Oklahoma Stephens 40137 7474 138 0   34.48556989 -97.85141892 2021-10-24 04:21:22 Stephens, Oklahoma, US
34881 34881 2021-10-23 US Oklahoma Texas 40139 4048 39 0   36.74777635 -101.4889765 2021-10-24 04:21:22 Texas, Oklahoma, US
34882 34882 2021-10-23 US Oklahoma Tillman 40141 986 24 0   34.37288446 -98.92426619 2021-10-24 04:21:22 Tillman, Oklahoma, US
34883 34883 2021-10-23 US Oklahoma Tulsa 40143 106577 1640 0   36.11939621 -95.94013939 2021-10-24 04:21:22 Tulsa, Oklahoma, US
34884 34884 2021-10-23 US Oklahoma Unassigned 90040 3711 7 0   36.83532655 0.0 2021-10-24 04:21:22 Unassigned, Oklahoma, US
34885 34885 2021-10-23 US Oklahoma Wagoner 40145 12579 199 0   35.96024096 -95.51911308 2021-10-24 04:21:22 Wagoner, Oklahoma, US
34886 34886 2021-10-23 US Oklahoma Washington 40147 8365 193 0   36.71380786 -95.90514104 2021-10-24 04:21:22 Washington, Oklahoma, US
34887 34887 2021-10-23 US Oklahoma Washita 40149 1483 30 0   35.29071824 -98.99180434 2021-10-24 04:21:22 Washita, Oklahoma, US
34888 34888 2021-10-23 US Oklahoma Woods 40151 1628 25 0   36.76705782 -98.86573064 2021-10-24 04:21:22 Woods, Oklahoma, US
34889 34889 2021-10-23 US Oklahoma Woodward 40153 3752 50 0   36.42316318 -99.26283045 2021-10-24 04:21:22 Woodward, Oklahoma, US
315295 315295 2021-10-22 US Oklahoma Adair 40001 4850 61 0   35.88494195 -94.65859267 2021-10-23 04:21:32 Adair, Oklahoma, US
315296 315296 2021-10-22 US Oklahoma Alfalfa 40003 1299 7 0   36.73090616 -98.32408495 2021-10-23 04:21:32 Alfalfa, Oklahoma, US
315297 315297 2021-10-22 US Oklahoma Atoka 40005 2724 32 0   34.37366573 -96.03802487 2021-10-23 04:21:32 Atoka, Oklahoma, US
315298 315298 2021-10-22 US Oklahoma Beaver 40007 565 9 0   36.7496847 -100.4758872 2021-10-23 04:21:32 Beaver, Oklahoma, US
315299 315299 2021-10-22 US Oklahoma Beckham 40009 3445 74 0   35.26862449 -99.68128023 2021-10-23 04:21:32 Beckham, Oklahoma, US
315300 315300 2021-10-22 US Oklahoma Blaine 40011 1492 27 0   35.87518314 -98.43307003 2021-10-23 04:21:32 Blaine, Oklahoma, US
315301 315301 2021-10-22 US Oklahoma Bryan 40013 8651 106 0   33.96472458 -96.25903472 2021-10-23 04:21:32 Bryan, Oklahoma, US
315302 315302 2021-10-22 US Oklahoma Caddo 40015 5175 129 0   35.17364557 -98.37534464 2021-10-23 04:21:32 Caddo, Oklahoma, US
315303 315303 2021-10-22 US Oklahoma Canadian 40017 22956 280 0   35.5426055 -97.98465569 2021-10-23 04:21:32 Canadian, Oklahoma, US
315304 315304 2021-10-22 US Oklahoma Carter 40019 8921 184 0   34.25103751 -97.28552485 2021-10-23 04:21:32 Carter, Oklahoma, US
315305 315305 2021-10-22 US Oklahoma Cherokee 40021 8983 113 0   35.90692775 -94.99980896 2021-10-23 04:21:32 Cherokee, Oklahoma, US
315306 315306 2021-10-22 US Oklahoma Choctaw 40023 2728 49 0   34.02807439 -95.54771129 2021-10-23 04:21:32 Choctaw, Oklahoma, US
315307 315307 2021-10-22 US Oklahoma Cimarron 40025 323 2 0   36.74817177 -102.5173885 2021-10-23 04:21:32 Cimarron, Oklahoma, US
315308 315308 2021-10-22 US Oklahoma Cleveland 40027 43056 599 0   35.20413532 -97.32519562 2021-10-23 04:21:32 Cleveland, Oklahoma, US
315309 315309 2021-10-22 US Oklahoma Coal 40029 1052 20 0   34.58840127 -96.29798747 2021-10-23 04:21:32 Coal, Oklahoma, US
315310 315310 2021-10-22 US Oklahoma Comanche 40031 21021 292 0   34.65973764 -98.47195055 2021-10-23 04:21:32 Comanche, Oklahoma, US
315311 315311 2021-10-22 US Oklahoma Cotton 40033 981 22 0   34.28845626 -98.37053567 2021-10-23 04:21:32 Cotton, Oklahoma, US
315312 315312 2021-10-22 US Oklahoma Craig 40035 2989 32 0   36.76268118 -95.20916602 2021-10-23 04:21:32 Craig, Oklahoma, US
315313 315313 2021-10-22 US Oklahoma Creek 40037 11050 252 0   35.90230551 -96.37086028 2021-10-23 04:21:32 Creek, Oklahoma, US
315314 315314 2021-10-22 US Oklahoma Custer 40039 4978 128 0   35.63853802 -99.00170785 2021-10-23 04:21:32 Custer, Oklahoma, US
315315 315315 2021-10-22 US Oklahoma Delaware 40041 7274 159 0   36.40823634 -94.80325046 2021-10-23 04:21:32 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]);