daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
79,376 rows where province_or_state = "Oklahoma" sorted by active descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active ▲ | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-10-15 | US | Oklahoma | Caddo | 40015 | 1022 | 23 | 0 | 999 | 35.17364557 | -98.37534464 | 2020-10-16 04:24:01 | Caddo, Oklahoma, US |
2021-01-10 | US | Oklahoma | Johnston | 40069 | 1010 | 11 | 0 | 999 | 34.31440473 | -96.66011537 | 2021-01-11 05:21:50 | Johnston, Oklahoma, US |
2020-07-11 | US | Oklahoma | Texas | 40139 | 1005 | 6 | 0 | 999 | 36.74777635 | -101.4889765 | 2020-07-12 04:34:30 | Texas, Oklahoma, US |
2020-07-12 | US | Oklahoma | Texas | 40139 | 1005 | 6 | 0 | 999 | 36.74777635 | -101.4889765 | 2020-07-13 04:43:04 | Texas, Oklahoma, US |
2021-01-30 | US | Oklahoma | Comanche | 40031 | 10085 | 105 | 0 | 9980 | 34.65973764 | -98.47195055 | 2021-01-31 05:22:42 | Comanche, Oklahoma, US |
2020-11-06 | US | Oklahoma | Kay | 40071 | 1015 | 17 | 0 | 998 | 36.81799745 | -97.14421435 | 2020-11-07 05:24:52 | Kay, Oklahoma, US |
2020-10-07 | US | Oklahoma | Pittsburg | 40121 | 1018 | 20 | 0 | 998 | 34.92065823 | -95.7513432 | 2020-10-08 04:23:56 | Pittsburg, Oklahoma, US |
2020-09-30 | US | Oklahoma | Bryan | 40013 | 1003 | 5 | 0 | 998 | 33.96472458 | -96.25903472 | 2020-10-01 04:23:42 | Bryan, Oklahoma, US |
2020-11-07 | US | Oklahoma | Kay | 40071 | 1015 | 17 | 0 | 998 | 36.81799745 | -97.14421435 | 2020-11-08 05:24:56 | Kay, Oklahoma, US |
2020-11-08 | US | Oklahoma | Beckham | 40009 | 1013 | 15 | 0 | 998 | 35.26862449 | -99.68128023 | 2020-11-09 05:25:45 | Beckham, Oklahoma, US |
2020-10-31 | US | Oklahoma | Mayes | 40097 | 1013 | 15 | 0 | 998 | 36.30179091 | -95.23175116 | 2020-11-01 04:36:19 | Mayes, Oklahoma, US |
2020-07-10 | US | Oklahoma | Texas | 40139 | 1004 | 6 | 0 | 998 | 36.74777635 | -101.4889765 | 2020-07-11 04:34:26 | Texas, Oklahoma, US |
2021-01-15 | US | Oklahoma | Alfalfa | 40003 | 1003 | 5 | 0 | 998 | 36.73090616 | -98.32408495 | 2021-01-16 05:22:40 | Alfalfa, Oklahoma, US |
2021-02-02 | US | Oklahoma | Nowata | 40105 | 1011 | 14 | 0 | 997 | 36.79843529 | -95.61902331 | 2021-02-03 05:22:52 | Nowata, Oklahoma, US |
2020-09-24 | US | Oklahoma | Grady | 40051 | 1008 | 11 | 0 | 997 | 35.0167709 | -97.88339847 | 2020-09-25 04:23:00 | Grady, Oklahoma, US |
2021-01-13 | US | Oklahoma | Haskell | 40061 | 1004 | 7 | 0 | 997 | 35.22257600000001 | -95.11513306 | 2021-01-14 05:22:32 | Haskell, Oklahoma, US |
2020-12-04 | US | Oklahoma | Craig | 40035 | 1000 | 3 | 0 | 997 | 36.76268118 | -95.20916602 | 2020-12-05 05:27:36 | Craig, Oklahoma, US |
2020-12-25 | US | Oklahoma | Canadian | 40017 | 10015 | 49 | 0 | 9966 | 35.5426055 | -97.98465569 | 2020-12-26 05:22:28 | Canadian, Oklahoma, US |
2020-12-24 | US | Oklahoma | Canadian | 40017 | 10015 | 49 | 0 | 9966 | 35.5426055 | -97.98465569 | 2020-12-25 05:22:48 | Canadian, Oklahoma, US |
2020-08-31 | US | Oklahoma | McCurtain | 40089 | 1025 | 29 | 0 | 996 | 34.11664328 | -94.77222373 | 2020-09-01 04:28:31 | McCurtain, Oklahoma, US |
2021-01-21 | US | Oklahoma | Hughes | 40063 | 1008 | 12 | 0 | 996 | 35.04912569 | -96.24921145 | 2021-01-22 05:22:10 | Hughes, Oklahoma, US |
2021-01-02 | US | Oklahoma | Woods | 40151 | 1001 | 5 | 0 | 996 | 36.76705782 | -98.86573064 | 2021-01-03 05:22:52 | Woods, Oklahoma, US |
2020-08-27 | US | Oklahoma | Payne | 40119 | 1001 | 5 | 0 | 996 | 36.07695283 | -96.97584944 | 2020-08-28 04:28:11 | Payne, Oklahoma, US |
2020-10-08 | US | Oklahoma | McClain | 40087 | 1003 | 7 | 0 | 996 | 35.01123903 | -97.44572302 | 2020-10-09 04:23:59 | McClain, Oklahoma, US |
2021-01-14 | US | Oklahoma | Alfalfa | 40003 | 1001 | 5 | 0 | 996 | 36.73090616 | -98.32408495 | 2021-01-15 05:22:24 | Alfalfa, Oklahoma, US |
2020-10-20 | US | Oklahoma | Custer | 40039 | 999 | 3 | 0 | 996 | 35.63853802 | -99.00170785 | 2020-10-21 04:24:14 | Custer, Oklahoma, US |
2020-10-14 | US | Oklahoma | Caddo | 40015 | 1018 | 23 | 0 | 995 | 35.17364557 | -98.37534464 | 2020-10-15 04:24:28 | Caddo, Oklahoma, US |
2020-07-04 | US | Oklahoma | Cleveland | 40027 | 1035 | 40 | 0 | 995 | 35.20413532 | -97.32519562 | 2020-07-05 04:33:46 | Cleveland, Oklahoma, US |
2020-10-09 | US | Oklahoma | Ottawa | 40115 | 1003 | 8 | 0 | 995 | 36.83532655 | -94.81011909 | 2020-10-10 04:23:57 | Ottawa, Oklahoma, US |
2020-07-09 | US | Oklahoma | Texas | 40139 | 1001 | 6 | 0 | 995 | 36.74777635 | -101.4889765 | 2020-07-10 04:34:24 | Texas, Oklahoma, US |
2021-03-05 | US | Oklahoma | Blaine | 40011 | 1003 | 8 | 0 | 995 | 35.87518314 | -98.43307003 | 2021-03-06 04:23:41 | Blaine, Oklahoma, US |
2021-01-02 | US | Oklahoma | Noble | 40103 | 1002 | 7 | 0 | 995 | 36.38953329 | -97.22928674 | 2021-01-03 05:22:52 | Noble, Oklahoma, US |
2021-03-06 | US | Oklahoma | Blaine | 40011 | 1003 | 8 | 0 | 995 | 35.87518314 | -98.43307003 | 2021-03-07 05:21:54 | Blaine, Oklahoma, US |
2020-12-25 | US | Oklahoma | Choctaw | 40023 | 1000 | 6 | 0 | 994 | 34.02807439 | -95.54771129 | 2020-12-26 05:22:28 | Choctaw, Oklahoma, US |
2020-10-15 | US | Oklahoma | Okmulgee | 40111 | 1002 | 8 | 0 | 994 | 35.64661916 | -95.96432828 | 2020-10-16 04:24:01 | Okmulgee, Oklahoma, US |
2021-02-01 | US | Oklahoma | Nowata | 40105 | 1008 | 14 | 0 | 994 | 36.79843529 | -95.61902331 | 2021-02-02 05:22:49 | Nowata, Oklahoma, US |
2020-10-04 | US | Oklahoma | Washington | 40147 | 1035 | 41 | 0 | 994 | 36.71380786 | -95.90514104 | 2020-10-05 04:23:33 | Washington, Oklahoma, US |
2020-10-03 | US | Oklahoma | Washington | 40147 | 1035 | 41 | 0 | 994 | 36.71380786 | -95.90514104 | 2020-10-04 04:23:44 | Washington, Oklahoma, US |
2020-09-21 | US | Oklahoma | Le Flore | 40079 | 1011 | 17 | 0 | 994 | 34.89851864 | -94.70392124 | 2020-09-22 04:23:00 | Le Flore, Oklahoma, US |
2020-12-24 | US | Oklahoma | Choctaw | 40023 | 1000 | 6 | 0 | 994 | 34.02807439 | -95.54771129 | 2020-12-25 05:22:48 | Choctaw, Oklahoma, US |
2020-09-30 | US | Oklahoma | Osage | 40113 | 1006 | 13 | 0 | 993 | 36.62888819 | -96.39635704 | 2020-10-01 04:23:42 | Osage, Oklahoma, US |
2021-01-31 | US | Oklahoma | Nowata | 40105 | 1007 | 14 | 0 | 993 | 36.79843529 | -95.61902331 | 2021-02-01 05:22:53 | Nowata, Oklahoma, US |
2021-01-13 | US | Oklahoma | Alfalfa | 40003 | 998 | 5 | 0 | 993 | 36.73090616 | -98.32408495 | 2021-01-14 05:22:32 | Alfalfa, Oklahoma, US |
2021-02-21 | US | Oklahoma | Unassigned | 90040 | 992 | 0 | 0 | 992 | 36.83532655 | 0.0 | 2021-02-22 05:24:21 | Unassigned, Oklahoma, US |
2020-11-10 | US | Oklahoma | Logan | 40083 | 995 | 3 | 0 | 992 | 35.91899576 | -97.44352845 | 2020-11-11 05:25:30 | Logan, Oklahoma, US |
2021-01-12 | US | Oklahoma | Alfalfa | 40003 | 997 | 5 | 0 | 992 | 36.73090616 | -98.32408495 | 2021-01-13 05:22:15 | Alfalfa, Oklahoma, US |
2021-01-12 | US | Oklahoma | Haskell | 40061 | 999 | 7 | 0 | 992 | 35.22257600000001 | -95.11513306 | 2021-01-13 05:22:15 | Haskell, Oklahoma, US |
2021-03-04 | US | Oklahoma | Blaine | 40011 | 1000 | 8 | 0 | 992 | 35.87518314 | -98.43307003 | 2021-03-05 05:26:29 | Blaine, Oklahoma, US |
2020-07-08 | US | Oklahoma | Texas | 40139 | 998 | 6 | 0 | 992 | 36.74777635 | -101.4889765 | 2020-07-09 04:34:23 | Texas, Oklahoma, US |
2020-09-20 | US | Oklahoma | Cherokee | 40021 | 999 | 7 | 0 | 992 | 35.90692775 | -94.99980896 | 2020-09-21 04:23:00 | Cherokee, Oklahoma, US |
2020-10-06 | US | Oklahoma | Pittsburg | 40121 | 1012 | 20 | 0 | 992 | 34.92065823 | -95.7513432 | 2020-10-07 04:23:40 | Pittsburg, Oklahoma, US |
2020-08-30 | US | Oklahoma | McCurtain | 40089 | 1021 | 29 | 0 | 992 | 34.11664328 | -94.77222373 | 2020-08-31 04:28:27 | McCurtain, Oklahoma, US |
2021-01-29 | US | Oklahoma | Comanche | 40031 | 10023 | 104 | 0 | 9919 | 34.65973764 | -98.47195055 | 2021-01-30 05:22:49 | Comanche, Oklahoma, US |
2021-02-03 | US | Oklahoma | Washita | 40149 | 998 | 7 | 0 | 991 | 35.29071824 | -98.99180434 | 2021-02-04 05:22:26 | Washita, Oklahoma, US |
2021-02-20 | US | Oklahoma | Unassigned | 90040 | 991 | 0 | 0 | 991 | 36.83532655 | 0.0 | 2021-02-21 05:24:33 | Unassigned, Oklahoma, US |
2020-12-12 | US | Oklahoma | McIntosh | 40091 | 1005 | 14 | 0 | 991 | 35.37235506 | -95.66599306 | 2020-12-13 05:27:20 | McIntosh, Oklahoma, US |
2020-07-07 | US | Oklahoma | Texas | 40139 | 997 | 6 | 0 | 991 | 36.74777635 | -101.4889765 | 2020-07-08 05:33:48 | Texas, Oklahoma, US |
2020-10-11 | US | Oklahoma | Delaware | 40041 | 1017 | 26 | 0 | 991 | 36.40823634 | -94.80325046 | 2020-10-12 04:23:45 | Delaware, Oklahoma, US |
2021-03-03 | US | Oklahoma | Blaine | 40011 | 998 | 8 | 0 | 990 | 35.87518314 | -98.43307003 | 2021-03-04 05:24:24 | Blaine, Oklahoma, US |
2021-02-02 | US | Oklahoma | Washita | 40149 | 996 | 6 | 0 | 990 | 35.29071824 | -98.99180434 | 2021-02-03 05:22:52 | Washita, Oklahoma, US |
2021-01-07 | US | Oklahoma | Love | 40085 | 997 | 7 | 0 | 990 | 33.95273467 | -97.23906784 | 2021-01-08 05:22:42 | Love, Oklahoma, US |
2021-03-02 | US | Oklahoma | Blaine | 40011 | 998 | 8 | 0 | 990 | 35.87518314 | -98.43307003 | 2021-03-03 05:23:28 | Blaine, Oklahoma, US |
2020-05-15 | US | Oklahoma | Oklahoma | 40109 | 1035 | 45 | 0 | 990 | 35.55140095 | -97.40716948 | 2020-05-16 02:32:19 | Oklahoma, Oklahoma, US |
2020-06-08 | US | Oklahoma | Choctaw | 40023 | 100 | 1 | 0 | 99 | 34.02807439 | -95.54771129 | 2020-06-09 03:33:03 | Choctaw, Oklahoma, US |
2020-11-10 | US | Oklahoma | Roger Mills | 40129 | 103 | 4 | 0 | 99 | 35.68711719 | -99.69666167 | 2020-11-11 05:25:30 | Roger Mills, Oklahoma, US |
2020-06-15 | US | Oklahoma | Creek | 40037 | 106 | 7 | 0 | 99 | 35.90230551 | -96.37086028 | 2020-06-16 04:33:09 | Creek, Oklahoma, US |
2020-07-01 | US | Oklahoma | Bryan | 40013 | 100 | 1 | 0 | 99 | 33.96472458 | -96.25903472 | 2020-07-02 04:33:46 | Bryan, Oklahoma, US |
2020-07-20 | US | Oklahoma | McIntosh | 40091 | 100 | 1 | 0 | 99 | 35.37235506 | -95.66599306 | 2020-07-21 04:38:46 | McIntosh, Oklahoma, US |
2020-08-29 | US | Oklahoma | Love | 40085 | 99 | 0 | 0 | 99 | 33.95273467 | -97.23906784 | 2020-08-30 04:28:22 | Love, Oklahoma, US |
2020-11-23 | US | Oklahoma | Harmon | 40057 | 99 | 0 | 0 | 99 | 34.7440135 | -99.84741652 | 2020-11-24 05:27:31 | Harmon, Oklahoma, US |
2020-10-28 | US | Oklahoma | Cotton | 40033 | 102 | 3 | 0 | 99 | 34.28845626 | -98.37053567 | 2020-10-29 04:24:49 | Cotton, Oklahoma, US |
2020-09-02 | US | Oklahoma | Woodward | 40153 | 99 | 0 | 0 | 99 | 36.42316318 | -99.26283045 | 2020-09-03 04:28:22 | Woodward, Oklahoma, US |
2020-06-09 | US | Oklahoma | Choctaw | 40023 | 100 | 1 | 0 | 99 | 34.02807439 | -95.54771129 | 2020-06-10 04:07:00 | Choctaw, Oklahoma, US |
2020-08-28 | US | Oklahoma | Noble | 40103 | 101 | 2 | 0 | 99 | 36.38953329 | -97.22928674 | 2020-08-29 04:28:19 | Noble, Oklahoma, US |
2020-08-16 | US | Oklahoma | Latimer | 40077 | 101 | 2 | 0 | 99 | 34.87844729 | -95.25215049 | 2020-08-17 04:27:20 | Latimer, Oklahoma, US |
2020-06-19 | US | Oklahoma | Adair | 40001 | 103 | 4 | 0 | 99 | 35.88494195 | -94.65859267 | 2020-06-20 04:33:19 | Adair, Oklahoma, US |
2020-07-21 | US | Oklahoma | Le Flore | 40079 | 100 | 1 | 0 | 99 | 34.89851864 | -94.70392124 | 2020-07-22 04:34:42 | Le Flore, Oklahoma, US |
2020-07-21 | US | Oklahoma | Sequoyah | 40135 | 102 | 3 | 0 | 99 | 35.49447108 | -94.75463785 | 2020-07-22 04:34:42 | Sequoyah, Oklahoma, US |
2020-06-14 | US | Oklahoma | Creek | 40037 | 106 | 7 | 0 | 99 | 35.90230551 | -96.37086028 | 2020-06-15 03:33:14 | Creek, Oklahoma, US |
2020-06-14 | US | Oklahoma | Payne | 40119 | 100 | 1 | 0 | 99 | 36.07695283 | -96.97584944 | 2020-06-15 03:33:14 | Payne, Oklahoma, US |
2020-08-26 | US | Oklahoma | Atoka | 40005 | 100 | 1 | 0 | 99 | 34.37366573 | -96.03802487 | 2020-08-27 04:28:15 | Atoka, Oklahoma, US |
2020-09-01 | US | Oklahoma | Nowata | 40105 | 100 | 1 | 0 | 99 | 36.79843529 | -95.61902331 | 2020-09-02 04:28:25 | Nowata, Oklahoma, US |
2020-07-03 | US | Oklahoma | Kay | 40071 | 106 | 7 | 0 | 99 | 36.81799745 | -97.14421435 | 2020-07-04 04:33:51 | Kay, Oklahoma, US |
2020-06-20 | US | Oklahoma | Delaware | 40041 | 115 | 16 | 0 | 99 | 36.40823634 | -94.80325046 | 2020-06-21 04:33:19 | Delaware, Oklahoma, US |
2020-08-27 | US | Oklahoma | Noble | 40103 | 101 | 2 | 0 | 99 | 36.38953329 | -97.22928674 | 2020-08-28 04:28:11 | Noble, Oklahoma, US |
2020-05-27 | US | Oklahoma | McClain | 40087 | 101 | 2 | 0 | 99 | 35.01123903 | -97.44572302 | 2020-05-28 02:32:31 | McClain, Oklahoma, US |
2020-09-23 | US | Oklahoma | Woods | 40151 | 99 | 0 | 0 | 99 | 36.76705782 | -98.86573064 | 2020-09-24 04:23:00 | Woods, Oklahoma, US |
2020-07-17 | US | Oklahoma | Custer | 40039 | 99 | 0 | 0 | 99 | 35.63853802 | -99.00170785 | 2020-07-18 04:34:45 | Custer, Oklahoma, US |
2020-05-04 | US | Oklahoma | Canadian | 40017 | 102 | 3 | 0 | 99 | 35.5426055 | -97.98465569 | 2020-05-05 02:32:34 | Canadian, Oklahoma, US |
2020-08-18 | US | Oklahoma | Latimer | 40077 | 101 | 2 | 0 | 99 | 34.87844729 | -95.25215049 | 2020-08-19 04:27:00 | Latimer, Oklahoma, US |
2020-11-22 | US | Oklahoma | Harmon | 40057 | 99 | 0 | 0 | 99 | 34.7440135 | -99.84741652 | 2020-11-23 05:25:26 | Harmon, Oklahoma, US |
2020-07-31 | US | Oklahoma | Hughes | 40063 | 100 | 1 | 0 | 99 | 35.04912569 | -96.24921145 | 2020-08-01 04:36:27 | Hughes, Oklahoma, US |
2020-09-22 | US | Oklahoma | Woods | 40151 | 99 | 0 | 0 | 99 | 36.76705782 | -98.86573064 | 2020-09-23 04:23:00 | Woods, Oklahoma, US |
2020-05-11 | US | Oklahoma | Caddo | 40015 | 108 | 9 | 0 | 99 | 35.17364557 | -98.37534464 | 2020-05-12 03:32:27 | Caddo, Oklahoma, US |
2020-11-11 | US | Oklahoma | Roger Mills | 40129 | 103 | 4 | 0 | 99 | 35.68711719 | -99.69666167 | 2020-11-12 05:25:55 | Roger Mills, Oklahoma, US |
2020-05-10 | US | Oklahoma | Caddo | 40015 | 108 | 9 | 0 | 99 | 35.17364557 | -98.37534464 | 2020-05-11 02:32:30 | Caddo, Oklahoma, US |
2020-08-05 | US | Oklahoma | Marshall | 40095 | 99 | 0 | 0 | 99 | 34.02311222 | -96.76855464 | 2020-08-06 04:35:02 | Marshall, Oklahoma, US |
2020-11-10 | US | Oklahoma | Garvin | 40049 | 997 | 8 | 0 | 989 | 34.70418038 | -97.30811132 | 2020-11-11 05:25:30 | Garvin, Oklahoma, US |
2020-11-13 | US | Oklahoma | Lincoln | 40081 | 1012 | 23 | 0 | 989 | 35.70270942 | -96.8812462 | 2020-11-14 05:25:37 | Lincoln, Oklahoma, US |
2021-01-09 | US | Oklahoma | Johnston | 40069 | 1000 | 11 | 0 | 989 | 34.31440473 | -96.66011537 | 2021-01-10 05:22:12 | Johnston, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;