johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
79,376 rows where province_or_state = "Oklahoma" sorted by longitude descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude ▲ | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2917 | 2917 | 2021-12-02 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-12-03 04:23:05 | Out of OK, Oklahoma, US | |
2932 | 2932 | 2021-12-02 | US | Oklahoma | Unassigned | 90040 | 3160 | 1070 | 0 | 36.83532655 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Oklahoma, US | |
6932 | 6932 | 2021-10-28 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-10-29 04:22:03 | Out of OK, Oklahoma, US | |
6947 | 6947 | 2021-10-28 | US | Oklahoma | Unassigned | 90040 | 2180 | 0 | 0 | 36.83532655 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Oklahoma, US | |
10904 | 10904 | 2020-10-25 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-10-26 04:25:02 | Out of OK, Oklahoma, US |
10919 | 10919 | 2020-10-25 | US | Oklahoma | Unassigned | 90040 | 6 | 0 | 0 | 6 | 36.83532655 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Oklahoma, US |
14917 | 14917 | 2021-01-26 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-01-27 05:23:41 | Out of OK, Oklahoma, US |
14932 | 14932 | 2021-01-26 | US | Oklahoma | Unassigned | 90040 | 745 | 0 | 0 | 745 | 36.83532655 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Oklahoma, US |
18939 | 18939 | 2021-09-18 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-09-19 04:21:34 | Out of OK, Oklahoma, US | |
18954 | 18954 | 2021-09-18 | US | Oklahoma | Unassigned | 90040 | 7681 | 1 | 0 | 36.83532655 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Oklahoma, US | |
22950 | 22950 | 2021-05-28 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-05-29 04:20:41 | Out of OK, Oklahoma, US | |
22965 | 22965 | 2021-05-28 | US | Oklahoma | Unassigned | 90040 | 491 | 0 | 0 | 36.83532655 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Oklahoma, US | |
26988 | 26988 | 2022-03-20 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-03-21 04:20:50 | Out of OK, Oklahoma, US | |
27003 | 27003 | 2022-03-20 | US | Oklahoma | Unassigned | 90040 | 200 | 1444 | 0 | 36.83532655 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Oklahoma, US | |
31003 | 31003 | 2021-11-11 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-11-12 04:22:01 | Out of OK, Oklahoma, US | |
31018 | 31018 | 2021-11-11 | US | Oklahoma | Unassigned | 90040 | 5424 | 0 | 0 | 36.83532655 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Oklahoma, US | |
34999 | 34999 | 2021-08-25 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-08-26 04:21:28 | Out of OK, Oklahoma, US | |
35014 | 35014 | 2021-08-25 | US | Oklahoma | Unassigned | 90040 | 4511 | 0 | 0 | 36.83532655 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Oklahoma, US | |
39009 | 39009 | 2021-04-12 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-04-13 04:20:37 | Out of OK, Oklahoma, US | |
39024 | 39024 | 2021-04-12 | US | Oklahoma | Unassigned | 90040 | 3752 | 0 | 0 | 36.83532655 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Oklahoma, US | |
42205 | 42205 | 2020-04-13 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-04-13 23:07:54 | Out of OK, Oklahoma, US |
42805 | 42805 | 2020-04-13 | US | Oklahoma | Unassigned | 90040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Oklahoma, US |
46295 | 46295 | 2021-11-02 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-11-03 06:22:09 | Out of OK, Oklahoma, US | |
46310 | 46310 | 2021-11-02 | US | Oklahoma | Unassigned | 90040 | 5254 | 0 | 0 | 36.83532655 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Oklahoma, US | |
49288 | 49288 | 2020-04-17 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-04-17 23:30:52 | Out of OK, Oklahoma, US |
49898 | 49898 | 2020-04-17 | US | Oklahoma | Unassigned | 90040 | 108 | 5 | 0 | 103 | 36.83532655 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Oklahoma, US |
53371 | 53371 | 2021-05-29 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-05-30 04:20:55 | Out of OK, Oklahoma, US | |
53386 | 53386 | 2021-05-29 | US | Oklahoma | Unassigned | 90040 | 491 | 0 | 0 | 36.83532655 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Oklahoma, US | |
57382 | 57382 | 2021-03-07 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-03-08 05:24:48 | Out of OK, Oklahoma, US | |
57397 | 57397 | 2021-03-07 | US | Oklahoma | Unassigned | 90040 | 1111 | 0 | 0 | 36.83532655 | 0.0 | 2021-03-08 05:24:48 | Unassigned, Oklahoma, US | |
61430 | 61430 | 2020-07-23 | US | Oklahoma | Unassigned | 90040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-07-24 05:30:40 | Unassigned, Oklahoma, US |
62429 | 62429 | 2020-07-23 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-07-24 01:34:55 | Out of OK, Oklahoma, US |
65653 | 65653 | 2022-11-12 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-11-13 04:21:14 | Out of OK, Oklahoma, US | |
65668 | 65668 | 2022-11-12 | US | Oklahoma | Unassigned | 90040 | 150 | 2156 | 0 | 36.83532655 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Oklahoma, US | |
69644 | 69644 | 2021-09-01 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-09-02 04:21:15 | Out of OK, Oklahoma, US | |
69659 | 69659 | 2021-09-01 | US | Oklahoma | Unassigned | 90040 | 4516 | 0 | 0 | 36.83532655 | 0.0 | 2021-09-02 04:21:15 | Unassigned, Oklahoma, US | |
73678 | 73678 | 2022-02-07 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-02-08 04:21:15 | Out of OK, Oklahoma, US | |
73693 | 73693 | 2022-02-07 | US | Oklahoma | Unassigned | 90040 | 21007 | 1405 | 0 | 36.83532655 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Oklahoma, US | |
77664 | 77664 | 2020-12-03 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-12-04 05:27:27 | Out of OK, Oklahoma, US |
77679 | 77679 | 2020-12-03 | US | Oklahoma | Unassigned | 90040 | 84 | 0 | 0 | 84 | 36.83532655 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Oklahoma, US |
81658 | 81658 | 2020-10-14 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-10-15 04:24:28 | Out of OK, Oklahoma, US |
81673 | 81673 | 2020-10-14 | US | Oklahoma | Unassigned | 90040 | 26 | 0 | 0 | 26 | 36.83532655 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Oklahoma, US |
85674 | 85674 | 2021-05-25 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-05-26 04:20:35 | Out of OK, Oklahoma, US | |
85689 | 85689 | 2021-05-25 | US | Oklahoma | Unassigned | 90040 | 1097 | 0 | 0 | 36.83532655 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Oklahoma, US | |
89712 | 89712 | 2021-11-09 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-11-10 04:21:38 | Out of OK, Oklahoma, US | |
89727 | 89727 | 2021-11-09 | US | Oklahoma | Unassigned | 90040 | 5004 | 0 | 0 | 36.83532655 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Oklahoma, US | |
93730 | 93730 | 2022-07-23 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-07-24 04:20:47 | Out of OK, Oklahoma, US | |
93745 | 93745 | 2022-07-23 | US | Oklahoma | Unassigned | 90040 | 4546 | 1661 | 0 | 36.83532655 | 0.0 | 2022-07-24 04:20:47 | Unassigned, Oklahoma, US | |
97039 | 97039 | 2020-08-04 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-08-05 04:34:43 | Out of OK, Oklahoma, US |
97759 | 97759 | 2020-08-04 | US | Oklahoma | Unassigned | 90040 | 11 | 0 | 0 | 11 | 36.83532655 | 0.0 | 2020-08-05 04:34:43 | Unassigned, Oklahoma, US |
101913 | 101913 | 2022-01-14 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-01-15 04:21:07 | Out of OK, Oklahoma, US | |
101928 | 101928 | 2022-01-14 | US | Oklahoma | Unassigned | 90040 | 32054 | 1037 | 0 | 36.83532655 | 0.0 | 2022-01-15 04:21:07 | Unassigned, Oklahoma, US | |
105909 | 105909 | 2021-08-15 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-08-16 04:21:31 | Out of OK, Oklahoma, US | |
105924 | 105924 | 2021-08-15 | US | Oklahoma | Unassigned | 90040 | 8650 | 0 | 0 | 36.83532655 | 0.0 | 2021-08-16 04:21:31 | Unassigned, Oklahoma, US | |
110033 | 110033 | 2021-06-19 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-06-20 04:21:48 | Out of OK, Oklahoma, US | |
110048 | 110048 | 2021-06-19 | US | Oklahoma | Unassigned | 90040 | 651 | 0 | 0 | 36.83532655 | 0.0 | 2021-06-20 04:21:48 | Unassigned, Oklahoma, US | |
113168 | 113168 | 2020-05-08 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-05-09 02:32:35 | Out of OK, Oklahoma, US |
113819 | 113819 | 2020-05-08 | US | Oklahoma | Unassigned | 90040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-05-09 02:32:35 | Unassigned, Oklahoma, US |
117340 | 117340 | 2022-09-06 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-09-07 04:20:59 | Out of OK, Oklahoma, US | |
117355 | 117355 | 2022-09-06 | US | Oklahoma | Unassigned | 90040 | 9876 | 1976 | 0 | 36.83532655 | 0.0 | 2022-09-07 04:20:59 | Unassigned, Oklahoma, US | |
120638 | 120638 | 2020-07-19 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-07-20 05:34:40 | Out of OK, Oklahoma, US |
121354 | 121354 | 2020-07-19 | US | Oklahoma | Unassigned | 90040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-07-20 05:34:40 | Unassigned, Oklahoma, US |
125279 | 125279 | 2020-11-18 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-11-19 05:25:23 | Out of OK, Oklahoma, US |
125294 | 125294 | 2020-11-18 | US | Oklahoma | Unassigned | 90040 | 103 | 0 | 0 | 103 | 36.83532655 | 0.0 | 2020-11-19 05:25:23 | Unassigned, Oklahoma, US |
129320 | 129320 | 2022-01-09 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-01-10 04:22:07 | Out of OK, Oklahoma, US | |
129335 | 129335 | 2022-01-09 | US | Oklahoma | Unassigned | 90040 | 20791 | 947 | 0 | 36.83532655 | 0.0 | 2022-01-10 04:22:07 | Unassigned, Oklahoma, US | |
133341 | 133341 | 2022-10-04 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-10-05 04:23:06 | Out of OK, Oklahoma, US | |
133356 | 133356 | 2022-10-04 | US | Oklahoma | Unassigned | 90040 | 3280 | 2101 | 0 | 36.83532655 | 0.0 | 2022-10-05 04:23:06 | Unassigned, Oklahoma, US | |
136408 | 136408 | 2020-04-29 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-04-30 02:32:27 | Out of OK, Oklahoma, US |
137047 | 137047 | 2020-04-29 | US | Oklahoma | Unassigned | 90040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-04-30 02:32:27 | Unassigned, Oklahoma, US |
140558 | 140558 | 2021-12-04 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-12-05 04:22:25 | Out of OK, Oklahoma, US | |
140573 | 140573 | 2021-12-04 | US | Oklahoma | Unassigned | 90040 | 4448 | 1120 | 0 | 36.83532655 | 0.0 | 2021-12-05 04:22:25 | Unassigned, Oklahoma, US | |
144576 | 144576 | 2022-07-09 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-07-10 04:20:54 | Out of OK, Oklahoma, US | |
144591 | 144591 | 2022-07-09 | US | Oklahoma | Unassigned | 90040 | 2629 | 1686 | 0 | 36.83532655 | 0.0 | 2022-07-10 04:20:54 | Unassigned, Oklahoma, US | |
148531 | 148531 | 2020-08-15 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-08-16 04:27:42 | Out of OK, Oklahoma, US |
148546 | 148546 | 2020-08-15 | US | Oklahoma | Unassigned | 90040 | 4 | 0 | 0 | 4 | 36.83532655 | 0.0 | 2020-08-16 04:27:42 | Unassigned, Oklahoma, US |
152571 | 152571 | 2021-11-29 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-11-30 04:22:53 | Out of OK, Oklahoma, US | |
152586 | 152586 | 2021-11-29 | US | Oklahoma | Unassigned | 90040 | 4833 | 1024 | 0 | 36.83532655 | 0.0 | 2021-11-30 04:22:53 | Unassigned, Oklahoma, US | |
156558 | 156558 | 2021-01-08 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-01-09 05:22:18 | Out of OK, Oklahoma, US |
156573 | 156573 | 2021-01-08 | US | Oklahoma | Unassigned | 90040 | 570 | 0 | 0 | 570 | 36.83532655 | 0.0 | 2021-01-09 05:22:18 | Unassigned, Oklahoma, US |
160600 | 160600 | 2022-03-29 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-03-30 04:20:45 | Out of OK, Oklahoma, US | |
160615 | 160615 | 2022-03-29 | US | Oklahoma | Unassigned | 90040 | 199 | 1495 | 0 | 36.83532655 | 0.0 | 2022-03-30 04:20:45 | Unassigned, Oklahoma, US | |
164615 | 164615 | 2021-11-19 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-11-20 04:22:17 | Out of OK, Oklahoma, US | |
164630 | 164630 | 2021-11-19 | US | Oklahoma | Unassigned | 90040 | 2117 | 893 | 0 | 36.83532655 | 0.0 | 2021-11-20 04:22:17 | Unassigned, Oklahoma, US | |
168633 | 168633 | 2022-06-21 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-06-22 04:20:54 | Out of OK, Oklahoma, US | |
168648 | 168648 | 2022-06-21 | US | Oklahoma | Unassigned | 90040 | 4057 | 1673 | 0 | 36.83532655 | 0.0 | 2022-06-22 04:20:54 | Unassigned, Oklahoma, US | |
172623 | 172623 | 2021-04-16 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-04-17 04:20:40 | Out of OK, Oklahoma, US | |
172638 | 172638 | 2021-04-16 | US | Oklahoma | Unassigned | 90040 | 1109 | 0 | 0 | 36.83532655 | 0.0 | 2021-04-17 04:20:40 | Unassigned, Oklahoma, US | |
176670 | 176670 | 2020-07-27 | US | Oklahoma | Unassigned | 90040 | 157 | 1 | 0 | 156 | 36.83532655 | 0.0 | 2020-07-28 04:58:43 | Unassigned, Oklahoma, US |
177672 | 177672 | 2020-07-27 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-07-24 01:34:55 | Out of OK, Oklahoma, US |
180609 | 180609 | 2021-09-02 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-09-03 04:21:20 | Out of OK, Oklahoma, US | |
180624 | 180624 | 2021-09-02 | US | Oklahoma | Unassigned | 90040 | 7790 | 0 | 0 | 36.83532655 | 0.0 | 2021-09-03 04:21:20 | Unassigned, Oklahoma, US | |
184617 | 184617 | 2021-02-21 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-02-22 05:24:21 | Out of OK, Oklahoma, US |
184632 | 184632 | 2021-02-21 | US | Oklahoma | Unassigned | 90040 | 992 | 0 | 0 | 992 | 36.83532655 | 0.0 | 2021-02-22 05:24:21 | Unassigned, Oklahoma, US |
188658 | 188658 | 2022-02-13 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2022-02-14 04:20:51 | Out of OK, Oklahoma, US | |
188673 | 188673 | 2022-02-13 | US | Oklahoma | Unassigned | 90040 | 9204 | 1422 | 0 | 36.83532655 | 0.0 | 2022-02-14 04:20:51 | Unassigned, Oklahoma, US | |
192644 | 192644 | 2021-01-11 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2021-01-12 05:22:15 | Out of OK, Oklahoma, US |
192659 | 192659 | 2021-01-11 | US | Oklahoma | Unassigned | 90040 | 531 | 0 | 0 | 531 | 36.83532655 | 0.0 | 2021-01-12 05:22:15 | Unassigned, Oklahoma, US |
196635 | 196635 | 2020-08-31 | US | Oklahoma | Out of OK | 80040 | 0 | 0 | 0 | 0 | 36.83532655 | 0.0 | 2020-09-01 04:28:31 | Out of OK, Oklahoma, US |
196650 | 196650 | 2020-08-31 | US | Oklahoma | Unassigned | 90040 | 82 | 0 | 0 | 82 | 36.83532655 | 0.0 | 2020-09-01 04:28:31 | Unassigned, 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]);