johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
47,584 rows where province_or_state = "South Carolina" sorted by deaths
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1400537 | 1400537 | 2022-05-06 | US | South Carolina | Unassigned | 90045 | -3073 | -82 | 0 | 35.05122251 | -83.06742317 | 2022-05-07 04:21:09 | Unassigned, South Carolina, US | |
2600892 | 2600892 | 2022-05-05 | US | South Carolina | Unassigned | 90045 | -3073 | -82 | 0 | 35.05122251 | -83.06742317 | 2022-05-06 04:21:00 | Unassigned, South Carolina, US | |
3173 | 3173 | 2021-12-02 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-12-03 04:23:05 | Unassigned, South Carolina, US | |
7188 | 7188 | 2021-10-28 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-10-29 04:22:03 | Unassigned, South Carolina, US | |
11160 | 11160 | 2020-10-25 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-10-26 04:25:02 | Unassigned, South Carolina, US |
15173 | 15173 | 2021-01-26 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-01-27 05:23:41 | Unassigned, South Carolina, US |
19195 | 19195 | 2021-09-18 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-09-19 04:21:34 | Unassigned, South Carolina, US | |
23206 | 23206 | 2021-05-28 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-05-29 04:20:41 | Unassigned, South Carolina, US | |
27244 | 27244 | 2022-03-20 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2022-03-21 04:20:50 | Unassigned, South Carolina, US | |
31259 | 31259 | 2021-11-11 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-11-12 04:22:01 | Unassigned, South Carolina, US | |
35255 | 35255 | 2021-08-25 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-08-26 04:21:28 | Unassigned, South Carolina, US | |
39265 | 39265 | 2021-04-12 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-04-13 04:20:37 | Unassigned, South Carolina, US | |
40340 | 40340 | 2020-04-13 | US | South Carolina | Abbeville | 45001 | 9 | 0 | 0 | 9 | 34.22333378 | -82.46170658 | 2020-04-13 23:07:54 | Abbeville, South Carolina, US |
40382 | 40382 | 2020-04-13 | US | South Carolina | Allendale | 45005 | 5 | 0 | 0 | 5 | 32.98837386 | -81.35321066 | 2020-04-13 23:07:54 | Allendale, South Carolina, US |
40448 | 40448 | 2020-04-13 | US | South Carolina | Bamberg | 45009 | 7 | 0 | 0 | 7 | 33.21927586 | -81.05659969 | 2020-04-13 23:07:54 | Bamberg, South Carolina, US |
40457 | 40457 | 2020-04-13 | US | South Carolina | Barnwell | 45011 | 5 | 0 | 0 | 5 | 33.26679302 | -81.43584352 | 2020-04-13 23:07:54 | Barnwell, South Carolina, US |
40753 | 40753 | 2020-04-13 | US | South Carolina | Cherokee | 45021 | 8 | 0 | 0 | 8 | 35.05122251 | -81.61828622 | 2020-04-13 23:07:54 | Cherokee, South Carolina, US |
40759 | 40759 | 2020-04-13 | US | South Carolina | Chester | 45023 | 20 | 0 | 0 | 20 | 34.69249168 | -81.1583216 | 2020-04-13 23:07:54 | Chester, South Carolina, US |
40761 | 40761 | 2020-04-13 | US | South Carolina | Chesterfield | 45025 | 23 | 0 | 0 | 23 | 34.64137396 | -80.15640140000002 | 2020-04-13 23:07:54 | Chesterfield, South Carolina, US |
40857 | 40857 | 2020-04-13 | US | South Carolina | Colleton | 45029 | 17 | 0 | 0 | 17 | 32.87582989 | -80.67641292 | 2020-04-13 23:07:54 | Colleton, South Carolina, US |
40965 | 40965 | 2020-04-13 | US | South Carolina | Darlington | 45031 | 43 | 0 | 0 | 43 | 34.33358335 | -79.96027485 | 2020-04-13 23:07:54 | Darlington, South Carolina, US |
41017 | 41017 | 2020-04-13 | US | South Carolina | Dillon | 45033 | 5 | 0 | 0 | 5 | 34.39007791 | -79.37741872 | 2020-04-13 23:07:54 | Dillon, South Carolina, US |
41072 | 41072 | 2020-04-13 | US | South Carolina | Edgefield | 45037 | 10 | 0 | 0 | 10 | 33.77221995 | -81.96231108 | 2020-04-13 23:07:54 | Edgefield, South Carolina, US |
41112 | 41112 | 2020-04-13 | US | South Carolina | Fairfield | 45039 | 23 | 0 | 0 | 23 | 34.39287073 | -81.1195624 | 2020-04-13 23:07:54 | Fairfield, South Carolina, US |
41305 | 41305 | 2020-04-13 | US | South Carolina | Greenwood | 45047 | 18 | 0 | 0 | 18 | 34.15272415 | -82.12715789 | 2020-04-13 23:07:54 | Greenwood, South Carolina, US |
41341 | 41341 | 2020-04-13 | US | South Carolina | Hampton | 45049 | 9 | 0 | 0 | 9 | 32.77419582 | -81.13845571 | 2020-04-13 23:07:54 | Hampton, South Carolina, US |
41520 | 41520 | 2020-04-13 | US | South Carolina | Jasper | 45053 | 12 | 0 | 0 | 12 | 32.43171982 | -81.02487495 | 2020-04-13 23:07:54 | Jasper, South Carolina, US |
41676 | 41676 | 2020-04-13 | US | South Carolina | Lancaster | 45057 | 66 | 0 | 0 | 66 | 34.68270843 | -80.70513032 | 2020-04-13 23:07:54 | Lancaster, South Carolina, US |
41877 | 41877 | 2020-04-13 | US | South Carolina | Marlboro | 45069 | 15 | 0 | 0 | 15 | 34.59905577 | -79.67561152 | 2020-04-13 23:07:54 | Marlboro, South Carolina, US |
42142 | 42142 | 2020-04-13 | US | South Carolina | Oconee | 45073 | 14 | 0 | 0 | 14 | 34.75225169 | -83.06742317 | 2020-04-13 23:07:54 | Oconee, South Carolina, US |
42176 | 42176 | 2020-04-13 | US | South Carolina | Orangeburg | 45075 | 37 | 0 | 0 | 37 | 33.4391073 | -80.79886287 | 2020-04-13 23:07:54 | Orangeburg, South Carolina, US |
42272 | 42272 | 2020-04-13 | US | South Carolina | Pickens | 45077 | 28 | 0 | 0 | 28 | 34.88807695 | -82.72791551 | 2020-04-13 23:07:54 | Pickens, South Carolina, US |
42473 | 42473 | 2020-04-13 | US | South Carolina | Saluda | 45081 | 6 | 0 | 0 | 6 | 34.00795823 | -81.72713237 | 2020-04-13 23:07:54 | Saluda, South Carolina, US |
42831 | 42831 | 2020-04-13 | US | South Carolina | Union | 45087 | 22 | 0 | 0 | 22 | 34.68835752 | -81.61730349 | 2020-04-13 23:07:54 | Union, South Carolina, US |
43001 | 43001 | 2020-04-13 | US | South Carolina | Williamsburg | 45089 | 15 | 0 | 0 | 15 | 33.62190129 | -79.72767442 | 2020-04-13 23:07:54 | Williamsburg, South Carolina, US |
46551 | 46551 | 2021-11-02 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-11-03 06:22:09 | Unassigned, South Carolina, US | |
47395 | 47395 | 2020-04-17 | US | South Carolina | Abbeville | 45001 | 10 | 0 | 0 | 10 | 34.22333378 | -82.46170658 | 2020-04-17 23:30:52 | Abbeville, South Carolina, US |
47440 | 47440 | 2020-04-17 | US | South Carolina | Allendale | 45005 | 6 | 0 | 0 | 6 | 32.98837386 | -81.35321066 | 2020-04-17 23:30:52 | Allendale, South Carolina, US |
47507 | 47507 | 2020-04-17 | US | South Carolina | Bamberg | 45009 | 7 | 0 | 0 | 7 | 33.21927586 | -81.05659969 | 2020-04-17 23:30:52 | Bamberg, South Carolina, US |
47517 | 47517 | 2020-04-17 | US | South Carolina | Barnwell | 45011 | 5 | 0 | 0 | 5 | 33.26679302 | -81.43584352 | 2020-04-17 23:30:52 | Barnwell, South Carolina, US |
47814 | 47814 | 2020-04-17 | US | South Carolina | Cherokee | 45021 | 13 | 0 | 0 | 13 | 35.05122251 | -81.61828622 | 2020-04-17 23:30:52 | Cherokee, South Carolina, US |
47820 | 47820 | 2020-04-17 | US | South Carolina | Chester | 45023 | 23 | 0 | 0 | 23 | 34.69249168 | -81.1583216 | 2020-04-17 23:30:52 | Chester, South Carolina, US |
47822 | 47822 | 2020-04-17 | US | South Carolina | Chesterfield | 45025 | 31 | 0 | 0 | 31 | 34.64137396 | -80.15640140000002 | 2020-04-17 23:30:52 | Chesterfield, South Carolina, US |
48028 | 48028 | 2020-04-17 | US | South Carolina | Darlington | 45031 | 52 | 0 | 0 | 52 | 34.33358335 | -79.96027485 | 2020-04-17 23:30:52 | Darlington, South Carolina, US |
48082 | 48082 | 2020-04-17 | US | South Carolina | Dillon | 45033 | 11 | 0 | 0 | 11 | 34.39007791 | -79.37741872 | 2020-04-17 23:30:52 | Dillon, South Carolina, US |
48137 | 48137 | 2020-04-17 | US | South Carolina | Edgefield | 45037 | 10 | 0 | 0 | 10 | 33.77221995 | -81.96231108 | 2020-04-17 23:30:52 | Edgefield, South Carolina, US |
48176 | 48176 | 2020-04-17 | US | South Carolina | Fairfield | 45039 | 25 | 0 | 0 | 25 | 34.39287073 | -81.1195624 | 2020-04-17 23:30:52 | Fairfield, South Carolina, US |
48369 | 48369 | 2020-04-17 | US | South Carolina | Greenwood | 45047 | 32 | 0 | 0 | 32 | 34.15272415 | -82.12715789 | 2020-04-17 23:30:52 | Greenwood, South Carolina, US |
48405 | 48405 | 2020-04-17 | US | South Carolina | Hampton | 45049 | 18 | 0 | 0 | 18 | 32.77419582 | -81.13845571 | 2020-04-17 23:30:52 | Hampton, South Carolina, US |
48588 | 48588 | 2020-04-17 | US | South Carolina | Jasper | 45053 | 15 | 0 | 0 | 15 | 32.43171982 | -81.02487495 | 2020-04-17 23:30:52 | Jasper, South Carolina, US |
48951 | 48951 | 2020-04-17 | US | South Carolina | Marlboro | 45069 | 25 | 0 | 0 | 25 | 34.59905577 | -79.67561152 | 2020-04-17 23:30:52 | Marlboro, South Carolina, US |
49224 | 49224 | 2020-04-17 | US | South Carolina | Oconee | 45073 | 14 | 0 | 0 | 14 | 34.75225169 | -83.06742317 | 2020-04-17 23:30:52 | Oconee, South Carolina, US |
49258 | 49258 | 2020-04-17 | US | South Carolina | Orangeburg | 45075 | 41 | 0 | 0 | 41 | 33.4391073 | -80.79886287 | 2020-04-17 23:30:52 | Orangeburg, South Carolina, US |
49356 | 49356 | 2020-04-17 | US | South Carolina | Pickens | 45077 | 36 | 0 | 0 | 36 | 34.88807695 | -82.72791551 | 2020-04-17 23:30:52 | Pickens, South Carolina, US |
49562 | 49562 | 2020-04-17 | US | South Carolina | Saluda | 45081 | 9 | 0 | 0 | 9 | 34.00795823 | -81.72713237 | 2020-04-17 23:30:52 | Saluda, South Carolina, US |
49926 | 49926 | 2020-04-17 | US | South Carolina | Union | 45087 | 23 | 0 | 0 | 23 | 34.68835752 | -81.61730349 | 2020-04-17 23:30:52 | Union, South Carolina, US |
50098 | 50098 | 2020-04-17 | US | South Carolina | Williamsburg | 45089 | 19 | 0 | 0 | 19 | 33.62190129 | -79.72767442 | 2020-04-17 23:30:52 | Williamsburg, South Carolina, US |
53627 | 53627 | 2021-05-29 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-05-30 04:20:55 | Unassigned, South Carolina, US | |
57638 | 57638 | 2021-03-07 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-03-08 05:24:48 | Unassigned, South Carolina, US | |
61435 | 61435 | 2020-07-23 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-07-24 05:30:40 | Unassigned, South Carolina, US |
65909 | 65909 | 2022-11-12 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2022-11-13 04:21:14 | Unassigned, South Carolina, US | |
69900 | 69900 | 2021-09-01 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-09-02 04:21:15 | Unassigned, South Carolina, US | |
73934 | 73934 | 2022-02-07 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2022-02-08 04:21:15 | Unassigned, South Carolina, US | |
77920 | 77920 | 2020-12-03 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-12-04 05:27:27 | Unassigned, South Carolina, US |
81914 | 81914 | 2020-10-14 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-10-15 04:24:28 | Unassigned, South Carolina, US |
85930 | 85930 | 2021-05-25 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-05-26 04:20:35 | Unassigned, South Carolina, US | |
89968 | 89968 | 2021-11-09 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-11-10 04:21:38 | Unassigned, South Carolina, US | |
93986 | 93986 | 2022-07-23 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2022-07-24 04:20:47 | Unassigned, South Carolina, US | |
97764 | 97764 | 2020-08-04 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-08-05 04:34:43 | Unassigned, South Carolina, US |
102169 | 102169 | 2022-01-14 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2022-01-15 04:21:07 | Unassigned, South Carolina, US | |
106165 | 106165 | 2021-08-15 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-08-16 04:21:31 | Unassigned, South Carolina, US | |
110289 | 110289 | 2021-06-19 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2021-06-20 04:21:48 | Unassigned, South Carolina, US | |
111152 | 111152 | 2020-05-08 | US | South Carolina | Abbeville | 45001 | 34 | 0 | 0 | 34 | 34.22333378 | -82.46170658 | 2020-05-09 02:32:35 | Abbeville, South Carolina, US |
111268 | 111268 | 2020-05-08 | US | South Carolina | Bamberg | 45009 | 14 | 0 | 0 | 14 | 33.21927586 | -81.05659969 | 2020-05-09 02:32:35 | Bamberg, South Carolina, US |
111278 | 111278 | 2020-05-08 | US | South Carolina | Barnwell | 45011 | 32 | 0 | 0 | 32 | 33.26679302 | -81.43584352 | 2020-05-09 02:32:35 | Barnwell, South Carolina, US |
111593 | 111593 | 2020-05-08 | US | South Carolina | Cherokee | 45021 | 21 | 0 | 0 | 21 | 35.05122251 | -81.61828622 | 2020-05-09 02:32:35 | Cherokee, South Carolina, US |
111599 | 111599 | 2020-05-08 | US | South Carolina | Chester | 45023 | 39 | 0 | 0 | 39 | 34.69249168 | -81.1583216 | 2020-05-09 02:32:35 | Chester, South Carolina, US |
111881 | 111881 | 2020-05-08 | US | South Carolina | Dillon | 45033 | 84 | 0 | 0 | 84 | 34.39007791 | -79.37741872 | 2020-05-09 02:32:35 | Dillon, South Carolina, US |
112195 | 112195 | 2020-05-08 | US | South Carolina | Greenwood | 45047 | 62 | 0 | 0 | 62 | 34.15272415 | -82.12715789 | 2020-05-09 02:32:35 | Greenwood, South Carolina, US |
112233 | 112233 | 2020-05-08 | US | South Carolina | Hampton | 45049 | 27 | 0 | 0 | 27 | 32.77419582 | -81.13845571 | 2020-05-09 02:32:35 | Hampton, South Carolina, US |
113102 | 113102 | 2020-05-08 | US | South Carolina | Oconee | 45073 | 36 | 0 | 0 | 36 | 34.75225169 | -83.06742317 | 2020-05-09 02:32:35 | Oconee, South Carolina, US |
113462 | 113462 | 2020-05-08 | US | South Carolina | Saluda | 45081 | 84 | 0 | 0 | 84 | 34.00795823 | -81.72713237 | 2020-05-09 02:32:35 | Saluda, South Carolina, US |
113823 | 113823 | 2020-05-08 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-05-09 02:32:35 | Unassigned, South Carolina, US |
113850 | 113850 | 2020-05-08 | US | South Carolina | Union | 45087 | 29 | 0 | 0 | 29 | 34.68835752 | -81.61730349 | 2020-05-09 02:32:35 | Union, South Carolina, US |
117596 | 117596 | 2022-09-06 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2022-09-07 04:20:59 | Unassigned, South Carolina, US | |
121359 | 121359 | 2020-07-19 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-07-20 05:34:40 | Unassigned, South Carolina, US |
121386 | 121386 | 2020-07-19 | US | South Carolina | Union | 45087 | 198 | 0 | 0 | 198 | 34.68835752 | -81.61730349 | 2020-07-20 05:34:40 | Union, South Carolina, US |
125535 | 125535 | 2020-11-18 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2020-11-19 05:25:23 | Unassigned, South Carolina, US |
129576 | 129576 | 2022-01-09 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2022-01-10 04:22:07 | Unassigned, South Carolina, US | |
133597 | 133597 | 2022-10-04 | US | South Carolina | Unassigned | 90045 | 0 | 0 | 0 | 35.05122251 | -83.06742317 | 2022-10-05 04:23:06 | Unassigned, South Carolina, US | |
134436 | 134436 | 2020-04-29 | US | South Carolina | Abbeville | 45001 | 29 | 0 | 0 | 29 | 34.22333378 | -82.46170658 | 2020-04-30 02:32:27 | Abbeville, South Carolina, US |
134550 | 134550 | 2020-04-29 | US | South Carolina | Bamberg | 45009 | 9 | 0 | 0 | 9 | 33.21927586 | -81.05659969 | 2020-04-30 02:32:27 | Bamberg, South Carolina, US |
134560 | 134560 | 2020-04-29 | US | South Carolina | Barnwell | 45011 | 17 | 0 | 0 | 17 | 33.26679302 | -81.43584352 | 2020-04-30 02:32:27 | Barnwell, South Carolina, US |
134867 | 134867 | 2020-04-29 | US | South Carolina | Cherokee | 45021 | 15 | 0 | 0 | 15 | 35.05122251 | -81.61828622 | 2020-04-30 02:32:27 | Cherokee, South Carolina, US |
134873 | 134873 | 2020-04-29 | US | South Carolina | Chester | 45023 | 27 | 0 | 0 | 27 | 34.69249168 | -81.1583216 | 2020-04-30 02:32:27 | Chester, South Carolina, US |
134875 | 134875 | 2020-04-29 | US | South Carolina | Chesterfield | 45025 | 48 | 0 | 0 | 48 | 34.64137396 | -80.15640140000002 | 2020-04-30 02:32:27 | Chesterfield, South Carolina, US |
135147 | 135147 | 2020-04-29 | US | South Carolina | Dillon | 45033 | 47 | 0 | 0 | 47 | 34.39007791 | -79.37741872 | 2020-04-30 02:32:27 | Dillon, South Carolina, US |
135450 | 135450 | 2020-04-29 | US | South Carolina | Greenwood | 45047 | 46 | 0 | 0 | 46 | 34.15272415 | -82.12715789 | 2020-04-30 02:32:27 | Greenwood, South Carolina, US |
135488 | 135488 | 2020-04-29 | US | South Carolina | Hampton | 45049 | 23 | 0 | 0 | 23 | 32.77419582 | -81.13845571 | 2020-04-30 02:32:27 | Hampton, South Carolina, US |
136057 | 136057 | 2020-04-29 | US | South Carolina | Marlboro | 45069 | 43 | 0 | 0 | 43 | 34.59905577 | -79.67561152 | 2020-04-30 02:32:27 | Marlboro, South Carolina, 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]);