johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
66 rows where active = 39, country_or_region = "US" and province_or_state = "Oklahoma" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 1
- US · 66 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2917773 | 2917773 | 2020-11-14 | US | Oklahoma | Unassigned | 90040 | 39 | 0 | 0 | 39 | 36.83532655 | 0.0 | 2020-11-15 05:26:53 | Unassigned, Oklahoma, US |
212767 | 212767 | 2020-10-29 | US | Oklahoma | Cimarron | 40025 | 39 | 0 | 0 | 39 | 36.74817177 | -102.5173885 | 2020-10-30 04:24:49 | Cimarron, Oklahoma, US |
756829 | 756829 | 2020-10-28 | US | Oklahoma | Cimarron | 40025 | 39 | 0 | 0 | 39 | 36.74817177 | -102.5173885 | 2020-10-29 04:24:49 | Cimarron, Oklahoma, US |
1455113 | 1455113 | 2020-10-27 | US | Oklahoma | Cimarron | 40025 | 39 | 0 | 0 | 39 | 36.74817177 | -102.5173885 | 2020-10-28 04:24:39 | Cimarron, Oklahoma, US |
2604618 | 2604618 | 2020-10-10 | US | Oklahoma | Unassigned | 90040 | 39 | 0 | 0 | 39 | 36.83532655 | 0.0 | 2020-10-11 04:23:46 | Unassigned, Oklahoma, US |
3804481 | 3804481 | 2020-10-05 | US | Oklahoma | Unassigned | 90040 | 39 | 0 | 0 | 39 | 36.83532655 | 0.0 | 2020-10-06 04:23:33 | Unassigned, Oklahoma, US |
3095957 | 3095957 | 2020-09-20 | US | Oklahoma | Grant | 40053 | 39 | 0 | 0 | 39 | 36.796297 | -97.78638765 | 2020-09-21 04:23:00 | Grant, Oklahoma, US |
1124100 | 1124100 | 2020-09-17 | US | Oklahoma | Alfalfa | 40003 | 39 | 0 | 0 | 39 | 36.73090616 | -98.32408495 | 2020-09-18 05:05:00 | Alfalfa, Oklahoma, US |
1124132 | 1124132 | 2020-09-17 | US | Oklahoma | Jefferson | 40067 | 39 | 0 | 0 | 39 | 34.11130184 | -97.83182974 | 2020-09-18 05:05:00 | Jefferson, Oklahoma, US |
2062420 | 2062420 | 2020-09-01 | US | Oklahoma | Harmon | 40057 | 39 | 0 | 0 | 39 | 34.7440135 | -99.84741652 | 2020-09-02 04:28:25 | Harmon, Oklahoma, US |
196605 | 196605 | 2020-08-31 | US | Oklahoma | Harmon | 40057 | 39 | 0 | 0 | 39 | 34.7440135 | -99.84741652 | 2020-09-01 04:28:31 | Harmon, Oklahoma, US |
3934560 | 3934560 | 2020-08-30 | US | Oklahoma | Harmon | 40057 | 39 | 0 | 0 | 39 | 34.7440135 | -99.84741652 | 2020-08-31 04:28:27 | Harmon, Oklahoma, US |
612231 | 612231 | 2020-08-29 | US | Oklahoma | Kiowa | 40075 | 40 | 1 | 0 | 39 | 34.91671958 | -98.97720696 | 2020-08-30 04:28:22 | Kiowa, Oklahoma, US |
1525726 | 1525726 | 2020-08-28 | US | Oklahoma | Kiowa | 40075 | 40 | 1 | 0 | 39 | 34.91671958 | -98.97720696 | 2020-08-29 04:28:19 | Kiowa, Oklahoma, US |
2512727 | 2512727 | 2020-08-27 | US | Oklahoma | Kiowa | 40075 | 40 | 1 | 0 | 39 | 34.91671958 | -98.97720696 | 2020-08-28 04:28:11 | Kiowa, Oklahoma, US |
1999187 | 1999187 | 2020-08-26 | US | Oklahoma | Kiowa | 40075 | 40 | 1 | 0 | 39 | 34.91671958 | -98.97720696 | 2020-08-27 04:28:15 | Kiowa, Oklahoma, US |
3565111 | 3565111 | 2020-08-25 | US | Oklahoma | Kiowa | 40075 | 40 | 1 | 0 | 39 | 34.91671958 | -98.97720696 | 2020-08-26 04:28:11 | Kiowa, Oklahoma, US |
2993815 | 2993815 | 2020-08-24 | US | Oklahoma | Kiowa | 40075 | 40 | 1 | 0 | 39 | 34.91671958 | -98.97720696 | 2020-08-25 04:28:02 | Kiowa, Oklahoma, US |
840158 | 840158 | 2020-08-17 | US | Oklahoma | Major | 40093 | 40 | 1 | 0 | 39 | 36.31149996 | -98.53467076 | 2020-08-18 04:27:56 | Major, Oklahoma, US |
1558474 | 1558474 | 2020-08-16 | US | Oklahoma | Beaver | 40007 | 39 | 0 | 0 | 39 | 36.7496847 | -100.4758872 | 2020-08-17 04:27:20 | Beaver, Oklahoma, US |
1558514 | 1558514 | 2020-08-16 | US | Oklahoma | Major | 40093 | 40 | 1 | 0 | 39 | 36.31149996 | -98.53467076 | 2020-08-17 04:27:20 | Major, Oklahoma, US |
148476 | 148476 | 2020-08-15 | US | Oklahoma | Beaver | 40007 | 39 | 0 | 0 | 39 | 36.7496847 | -100.4758872 | 2020-08-16 04:27:42 | Beaver, Oklahoma, US |
1614751 | 1614751 | 2020-08-14 | US | Oklahoma | Beaver | 40007 | 39 | 0 | 0 | 39 | 36.7496847 | -100.4758872 | 2020-08-15 04:27:31 | Beaver, Oklahoma, US |
585335 | 585335 | 2020-08-13 | US | Oklahoma | Beaver | 40007 | 39 | 0 | 0 | 39 | 36.7496847 | -100.4758872 | 2020-08-14 04:51:19 | Beaver, Oklahoma, US |
3533953 | 3533953 | 2020-08-12 | US | Oklahoma | Beaver | 40007 | 39 | 0 | 0 | 39 | 36.7496847 | -100.4758872 | 2020-08-13 04:29:15 | Beaver, Oklahoma, US |
664859 | 664859 | 2020-08-11 | US | Oklahoma | Coal | 40029 | 39 | 0 | 0 | 39 | 34.58840127 | -96.29798747 | 2020-08-12 04:27:29 | Coal, Oklahoma, US |
3789815 | 3789815 | 2020-08-05 | US | Oklahoma | Blaine | 40011 | 39 | 0 | 0 | 39 | 35.87518314 | -98.43307003 | 2020-08-06 04:35:02 | Blaine, Oklahoma, US |
3262669 | 3262669 | 2020-07-31 | US | Oklahoma | Johnston | 40069 | 39 | 0 | 0 | 39 | 34.31440473 | -96.66011537 | 2020-08-01 04:36:27 | Johnston, Oklahoma, US |
1925131 | 1925131 | 2020-07-30 | US | Oklahoma | Blaine | 40011 | 39 | 0 | 0 | 39 | 35.87518314 | -98.43307003 | 2020-07-31 04:35:18 | Blaine, Oklahoma, US |
843349 | 843349 | 2020-07-22 | US | Oklahoma | Murray | 40099 | 39 | 0 | 0 | 39 | 34.48116015 | -97.06826283 | 2020-07-23 05:15:04 | Murray, Oklahoma, US |
325939 | 325939 | 2020-07-20 | US | Oklahoma | Pushmataha | 40127 | 39 | 0 | 0 | 39 | 34.41635232 | -95.37603505 | 2020-07-21 04:38:46 | Pushmataha, Oklahoma, US |
120817 | 120817 | 2020-07-19 | US | Oklahoma | Pushmataha | 40127 | 39 | 0 | 0 | 39 | 34.41635232 | -95.37603505 | 2020-07-20 05:34:40 | Pushmataha, Oklahoma, US |
2707275 | 2707275 | 2020-07-17 | US | Oklahoma | Nowata | 40105 | 40 | 1 | 0 | 39 | 36.79843529 | -95.61902331 | 2020-07-18 04:34:45 | Nowata, Oklahoma, US |
366094 | 366094 | 2020-07-16 | US | Oklahoma | Nowata | 40105 | 40 | 1 | 0 | 39 | 36.79843529 | -95.61902331 | 2020-07-17 04:34:50 | Nowata, Oklahoma, US |
3235790 | 3235790 | 2020-07-10 | US | Oklahoma | Lincoln | 40081 | 41 | 2 | 0 | 39 | 35.70270942 | -96.8812462 | 2020-07-11 04:34:26 | Lincoln, Oklahoma, US |
1003611 | 1003611 | 2020-07-09 | US | Oklahoma | Kingfisher | 40073 | 39 | 0 | 0 | 39 | 35.94530008 | -97.94193268 | 2020-07-10 04:34:24 | Kingfisher, Oklahoma, US |
885645 | 885645 | 2020-07-07 | US | Oklahoma | Love | 40085 | 39 | 0 | 0 | 39 | 33.95273467 | -97.23906784 | 2020-07-08 05:33:48 | Love, Oklahoma, US |
414025 | 414025 | 2020-07-05 | US | Oklahoma | Noble | 40103 | 40 | 1 | 0 | 39 | 36.38953329 | -97.22928674 | 2020-07-04 00:33:51 | Noble, Oklahoma, US |
528588 | 528588 | 2020-07-04 | US | Oklahoma | Noble | 40103 | 40 | 1 | 0 | 39 | 36.38953329 | -97.22928674 | 2020-07-04 00:33:51 | Noble, Oklahoma, US |
2233250 | 2233250 | 2020-07-03 | US | Oklahoma | Noble | 40103 | 40 | 1 | 0 | 39 | 36.38953329 | -97.22928674 | 2020-07-04 00:33:51 | Noble, Oklahoma, US |
301738 | 301738 | 2020-07-01 | US | Oklahoma | Noble | 40103 | 39 | 0 | 0 | 39 | 36.38953329 | -97.22928674 | 2020-07-02 04:33:46 | Noble, Oklahoma, US |
2973118 | 2973118 | 2020-06-30 | US | Oklahoma | Noble | 40103 | 39 | 0 | 0 | 39 | 36.38953329 | -97.22928674 | 2020-07-01 04:33:52 | Noble, Oklahoma, US |
1520878 | 1520878 | 2020-06-23 | US | Oklahoma | McIntosh | 40091 | 40 | 1 | 0 | 39 | 35.37235506 | -95.66599306 | 2020-06-24 04:33:28 | McIntosh, Oklahoma, US |
1509074 | 1509074 | 2020-06-22 | US | Oklahoma | McIntosh | 40091 | 40 | 1 | 0 | 39 | 35.37235506 | -95.66599306 | 2020-06-23 04:33:22 | McIntosh, Oklahoma, US |
3681479 | 3681479 | 2020-06-18 | US | Oklahoma | Pawnee | 40117 | 41 | 2 | 0 | 39 | 36.31743373 | -96.7033176 | 2020-06-19 04:33:17 | Pawnee, Oklahoma, US |
1194683 | 1194683 | 2020-06-17 | US | Oklahoma | Pawnee | 40117 | 41 | 2 | 0 | 39 | 36.31743373 | -96.7033176 | 2020-06-18 04:33:18 | Pawnee, Oklahoma, US |
2385405 | 2385405 | 2020-06-16 | US | Oklahoma | Ottawa | 40115 | 41 | 2 | 0 | 39 | 36.83532655 | -94.81011909 | 2020-06-17 04:33:21 | Ottawa, Oklahoma, US |
2385447 | 2385447 | 2020-06-16 | US | Oklahoma | Pawnee | 40117 | 41 | 2 | 0 | 39 | 36.31743373 | -96.7033176 | 2020-06-17 04:33:21 | Pawnee, Oklahoma, US |
286010 | 286010 | 2020-06-15 | US | Oklahoma | Pawnee | 40117 | 41 | 2 | 0 | 39 | 36.31743373 | -96.7033176 | 2020-06-16 04:33:09 | Pawnee, Oklahoma, US |
1835963 | 1835963 | 2020-06-14 | US | Oklahoma | Pawnee | 40117 | 41 | 2 | 0 | 39 | 36.31743373 | -96.7033176 | 2020-06-15 03:33:14 | Pawnee, Oklahoma, US |
3060015 | 3060015 | 2020-06-13 | US | Oklahoma | Pawnee | 40117 | 41 | 2 | 0 | 39 | 36.31743373 | -96.7033176 | 2020-06-14 03:33:15 | Pawnee, Oklahoma, US |
1207788 | 1207788 | 2020-06-09 | US | Oklahoma | Bryan | 40013 | 40 | 1 | 0 | 39 | 33.96472458 | -96.25903472 | 2020-06-10 04:07:00 | Bryan, Oklahoma, US |
216111 | 216111 | 2020-06-08 | US | Oklahoma | Pittsburg | 40121 | 42 | 3 | 0 | 39 | 34.92065823 | -95.7513432 | 2020-06-09 03:33:03 | Pittsburg, Oklahoma, US |
2798909 | 2798909 | 2020-06-07 | US | Oklahoma | Pittsburg | 40121 | 42 | 3 | 0 | 39 | 34.92065823 | -95.7513432 | 2020-06-08 03:33:22 | Pittsburg, Oklahoma, US |
3866085 | 3866085 | 2020-06-03 | US | Oklahoma | Stephens | 40137 | 40 | 1 | 0 | 39 | 34.48556989 | -97.85141892 | 2020-06-04 02:33:14 | Stephens, Oklahoma, US |
3293585 | 3293585 | 2020-05-07 | US | Oklahoma | Grady | 40051 | 41 | 2 | 0 | 39 | 35.0167709 | -97.88339847 | 2020-05-08 02:32:32 | Grady, Oklahoma, US |
2108811 | 2108811 | 2020-05-06 | US | Oklahoma | Grady | 40051 | 41 | 2 | 0 | 39 | 35.0167709 | -97.88339847 | 2020-05-07 02:32:28 | Grady, Oklahoma, US |
136543 | 136543 | 2020-04-29 | US | Oklahoma | Pottawatomie | 40125 | 43 | 4 | 0 | 39 | 35.20614018 | -96.94923008 | 2020-04-30 02:32:27 | Pottawatomie, Oklahoma, US |
270759 | 270759 | 2020-04-28 | US | Oklahoma | Pottawatomie | 40125 | 43 | 4 | 0 | 39 | 35.20614018 | -96.94923008 | 2020-04-29 02:32:29 | Pottawatomie, Oklahoma, US |
1198517 | 1198517 | 2020-04-22 | US | Oklahoma | Rogers | 40131 | 42 | 3 | 0 | 39 | 36.37004357 | -95.60406759 | 2020-04-22 23:30:53 | Rogers, Oklahoma, US |
521371 | 521371 | 2020-04-21 | US | Oklahoma | Payne | 40119 | 39 | 0 | 0 | 39 | 36.07695283 | -96.97584944 | 2020-04-21 23:30:50 | Payne, Oklahoma, US |
2472455 | 2472455 | 2020-04-20 | US | Oklahoma | Payne | 40119 | 39 | 0 | 0 | 39 | 36.07695283 | -96.97584944 | 2020-04-20 23:36:47 | Payne, Oklahoma, US |
2565474 | 2565474 | 2020-04-11 | US | Oklahoma | Kay | 40071 | 42 | 3 | 0 | 39 | 36.81799745 | -97.14421435 | 2020-04-11 22:45:33 | Kay, Oklahoma, US |
3559662 | 3559662 | 2020-04-08 | US | Oklahoma | Canadian | 40017 | 40 | 1 | 0 | 39 | 35.5426055 | -97.98465569 | 2020-04-08 22:51:58 | Canadian, Oklahoma, US |
3019359 | 3019359 | 2020-04-07 | US | Oklahoma | Canadian | 40017 | 40 | 1 | 0 | 39 | 35.5426055 | -97.98465569 | 2020-04-07 23:04:49 | Canadian, Oklahoma, US |
587016 | 587016 | 2020-04-05 | US | Oklahoma | Comanche | 40031 | 39 | 0 | 0 | 39 | 34.65973764 | -98.47195055 | 2020-04-05 23:06:45 | Comanche, Oklahoma, US |
Advanced export
JSON shape: default, array, newline-delimited
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]);