johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,484 rows where confirmed = 110 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 1,407
- Japan 12
- Canada 11
- Barbados 6
- United Kingdom 5
- China 4
- Dominica 4
- Malaysia 4
- Bhutan 2
- Chile 2
- Colombia 2
- Nepal 2
- Rwanda 2
- Singapore 2
- Timor-Leste 2
- Ukraine 2
- Bahrain 1
- Cambodia 1
- Egypt 1
- Georgia 1
- Honduras 1
- Iraq 1
- Kenya 1
- Lebanon 1
- Madagascar 1
- Mainland China 1
- Malta 1
- Papua New Guinea 1
- Russia 1
- Saint Lucia 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
350903 | 350903 | 2022-12-14 | US | Oklahoma | Unassigned | 90040 | 110 | 1983 | 0 | 36.83532655 | 0.0 | 2022-12-15 04:20:58 | Unassigned, Oklahoma, US | |
310491 | 310491 | 2022-12-13 | US | Oklahoma | Unassigned | 90040 | 110 | 1983 | 0 | 36.83532655 | 0.0 | 2022-12-14 04:21:04 | Unassigned, Oklahoma, US | |
1151552 | 1151552 | 2022-12-12 | US | Oklahoma | Unassigned | 90040 | 110 | 1983 | 0 | 36.83532655 | 0.0 | 2022-12-13 04:21:01 | Unassigned, Oklahoma, US | |
871406 | 871406 | 2022-12-11 | US | Oklahoma | Unassigned | 90040 | 110 | 1983 | 0 | 36.83532655 | 0.0 | 2022-12-12 04:21:01 | Unassigned, Oklahoma, US | |
259936 | 259936 | 2022-12-10 | US | Oklahoma | Unassigned | 90040 | 110 | 1983 | 0 | 36.83532655 | 0.0 | 2022-12-11 04:20:50 | Unassigned, Oklahoma, US | |
3938650 | 3938650 | 2022-12-09 | US | Oklahoma | Unassigned | 90040 | 110 | 1983 | 0 | 36.83532655 | 0.0 | 2022-12-10 04:21:02 | Unassigned, Oklahoma, US | |
3379982 | 3379982 | 2022-12-08 | US | Oklahoma | Unassigned | 90040 | 110 | 1983 | 0 | 36.83532655 | 0.0 | 2022-12-09 04:21:05 | Unassigned, Oklahoma, US | |
1987253 | 1987253 | 2022-12-07 | US | Oklahoma | Unassigned | 90040 | 110 | 1944 | 0 | 36.83532655 | 0.0 | 2022-12-08 04:21:07 | Unassigned, Oklahoma, US | |
3716776 | 3716776 | 2022-12-06 | US | Oklahoma | Unassigned | 90040 | 110 | 1944 | 0 | 36.83532655 | 0.0 | 2022-12-07 04:20:58 | Unassigned, Oklahoma, US | |
2417481 | 2417481 | 2022-12-05 | US | Oklahoma | Unassigned | 90040 | 110 | 1944 | 0 | 36.83532655 | 0.0 | 2022-12-06 04:21:03 | Unassigned, Oklahoma, US | |
721089 | 721089 | 2022-12-04 | US | Oklahoma | Unassigned | 90040 | 110 | 1944 | 0 | 36.83532655 | 0.0 | 2022-12-05 04:20:58 | Unassigned, Oklahoma, US | |
2819378 | 2819378 | 2022-12-03 | US | Oklahoma | Unassigned | 90040 | 110 | 1944 | 0 | 36.83532655 | 0.0 | 2022-12-04 04:20:56 | Unassigned, Oklahoma, US | |
836234 | 836234 | 2022-12-02 | US | Oklahoma | Unassigned | 90040 | 110 | 1944 | 0 | 36.83532655 | 0.0 | 2022-12-03 04:21:02 | Unassigned, Oklahoma, US | |
2138764 | 2138764 | 2022-12-01 | US | Oklahoma | Unassigned | 90040 | 110 | 1944 | 0 | 36.83532655 | 0.0 | 2022-12-02 04:21:07 | Unassigned, Oklahoma, US | |
3553780 | 3553780 | 2022-11-27 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-28 04:21:02 | Thomas, Nebraska, US | |
2102260 | 2102260 | 2022-11-26 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-27 04:21:05 | Thomas, Nebraska, US | |
489751 | 489751 | 2022-11-25 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-26 04:21:11 | Thomas, Nebraska, US | |
3525580 | 3525580 | 2022-11-24 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-25 04:21:06 | Thomas, Nebraska, US | |
3314839 | 3314839 | 2022-11-23 | US | Oklahoma | Unassigned | 90040 | 110 | 2184 | 0 | 36.83532655 | 0.0 | 2022-11-24 04:21:09 | Unassigned, Oklahoma, US | |
3314363 | 3314363 | 2022-11-23 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-24 04:21:09 | Thomas, Nebraska, US | |
1622880 | 1622880 | 2022-11-22 | US | Oklahoma | Unassigned | 90040 | 110 | 2184 | 0 | 36.83532655 | 0.0 | 2022-11-23 04:21:06 | Unassigned, Oklahoma, US | |
1622404 | 1622404 | 2022-11-22 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-23 04:21:06 | Thomas, Nebraska, US | |
3462768 | 3462768 | 2022-11-21 | US | Oklahoma | Unassigned | 90040 | 110 | 2184 | 0 | 36.83532655 | 0.0 | 2022-11-22 04:20:47 | Unassigned, Oklahoma, US | |
3462292 | 3462292 | 2022-11-21 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-22 04:20:47 | Thomas, Nebraska, US | |
1642953 | 1642953 | 2022-11-20 | US | Oklahoma | Unassigned | 90040 | 110 | 2184 | 0 | 36.83532655 | 0.0 | 2022-11-21 04:21:05 | Unassigned, Oklahoma, US | |
1642477 | 1642477 | 2022-11-20 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-21 04:21:05 | Thomas, Nebraska, US | |
2066510 | 2066510 | 2022-11-19 | US | Oklahoma | Unassigned | 90040 | 110 | 2184 | 0 | 36.83532655 | 0.0 | 2022-11-20 04:21:08 | Unassigned, Oklahoma, US | |
2066034 | 2066034 | 2022-11-19 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-20 04:21:08 | Thomas, Nebraska, US | |
1757904 | 1757904 | 2022-11-18 | US | Oklahoma | Unassigned | 90040 | 110 | 2184 | 0 | 36.83532655 | 0.0 | 2022-11-19 04:21:14 | Unassigned, Oklahoma, US | |
1757428 | 1757428 | 2022-11-18 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-19 04:21:14 | Thomas, Nebraska, US | |
3028897 | 3028897 | 2022-11-17 | US | Oklahoma | Unassigned | 90040 | 110 | 2184 | 0 | 36.83532655 | 0.0 | 2022-11-18 04:21:15 | Unassigned, Oklahoma, US | |
3028421 | 3028421 | 2022-11-17 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-18 04:21:15 | Thomas, Nebraska, US | |
2488132 | 2488132 | 2022-11-16 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-17 04:21:11 | Thomas, Nebraska, US | |
294143 | 294143 | 2022-11-15 | US | Nebraska | Thomas | 31171 | 110 | 1 | 0 | 41.91358968 | -100.5556632 | 2022-11-16 04:21:09 | Thomas, Nebraska, US | |
2433541 | 2433541 | 2022-11-09 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-10 04:21:16 | Unassigned, Oklahoma, US | |
482197 | 482197 | 2022-11-08 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-09 04:21:22 | Unassigned, Oklahoma, US | |
2441347 | 2441347 | 2022-11-07 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-08 04:21:21 | Unassigned, Oklahoma, US | |
1052445 | 1052445 | 2022-11-06 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-07 04:21:26 | Unassigned, Oklahoma, US | |
620469 | 620469 | 2022-11-05 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-06 04:21:24 | Unassigned, Oklahoma, US | |
1024973 | 1024973 | 2022-11-04 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-05 04:21:52 | Unassigned, Oklahoma, US | |
433964 | 433964 | 2022-11-03 | US | Oklahoma | Unassigned | 90040 | 110 | 2146 | 0 | 36.83532655 | 0.0 | 2022-11-04 04:22:11 | Unassigned, Oklahoma, US | |
852206 | 852206 | 2022-11-02 | US | Oklahoma | Unassigned | 90040 | 110 | 2139 | 0 | 36.83532655 | 0.0 | 2022-11-03 04:22:05 | Unassigned, Oklahoma, US | |
713057 | 713057 | 2022-11-01 | US | Oklahoma | Unassigned | 90040 | 110 | 2139 | 0 | 36.83532655 | 0.0 | 2022-11-02 04:22:09 | Unassigned, Oklahoma, US | |
3287506 | 3287506 | 2022-10-31 | US | Oklahoma | Unassigned | 90040 | 110 | 2139 | 0 | 36.83532655 | 0.0 | 2022-11-01 04:22:36 | Unassigned, Oklahoma, US | |
322539 | 322539 | 2022-10-30 | US | Oklahoma | Unassigned | 90040 | 110 | 2139 | 0 | 36.83532655 | 0.0 | 2022-10-31 04:21:36 | Unassigned, Oklahoma, US | |
914815 | 914815 | 2022-10-29 | US | Oklahoma | Unassigned | 90040 | 110 | 2139 | 0 | 36.83532655 | 0.0 | 2022-10-30 04:22:14 | Unassigned, Oklahoma, US | |
1369084 | 1369084 | 2022-10-28 | US | Oklahoma | Unassigned | 90040 | 110 | 2139 | 0 | 36.83532655 | 0.0 | 2022-10-29 04:21:13 | Unassigned, Oklahoma, US | |
3040939 | 3040939 | 2022-10-27 | US | Oklahoma | Unassigned | 90040 | 110 | 2139 | 0 | 36.83532655 | 0.0 | 2022-10-28 04:22:31 | Unassigned, Oklahoma, US | |
541359 | 541359 | 2022-10-26 | US | Oklahoma | Unassigned | 90040 | 110 | 2105 | 0 | 36.83532655 | 0.0 | 2022-10-27 04:22:01 | Unassigned, Oklahoma, US | |
2011720 | 2011720 | 2022-08-04 | US | Texas | Borden | 48033 | 110 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-08-05 04:20:52 | Borden, Texas, US | |
1101147 | 1101147 | 2022-08-03 | US | Texas | Borden | 48033 | 110 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-08-04 04:20:58 | Borden, Texas, US | |
1408072 | 1408072 | 2022-08-02 | US | Texas | Borden | 48033 | 110 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-08-03 04:20:59 | Borden, Texas, US | |
3620110 | 3620110 | 2022-08-01 | US | Texas | Borden | 48033 | 110 | 2 | 0 | 32.74363984 | -101.4316509 | 2022-08-02 04:20:53 | Borden, Texas, US | |
3406511 | 3406511 | 2022-07-17 | US | Illinois | Unassigned | 90017 | 110 | 4480 | 0 | 42.36542373 | 0.0 | 2022-07-18 04:20:59 | Unassigned, Illinois, US | |
2152711 | 2152711 | 2022-07-16 | US | Illinois | Unassigned | 90017 | 110 | 4480 | 0 | 42.36542373 | 0.0 | 2022-07-17 04:21:15 | Unassigned, Illinois, US | |
2419944 | 2419944 | 2022-07-15 | US | Illinois | Unassigned | 90017 | 110 | 4480 | 0 | 42.36542373 | 0.0 | 2022-07-16 04:21:05 | Unassigned, Illinois, US | |
632050 | 632050 | 2022-07-12 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-13 04:20:58 | Esmeralda, Nevada, US | |
1213694 | 1213694 | 2022-07-11 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-12 04:20:51 | Esmeralda, Nevada, US | |
2791176 | 2791176 | 2022-07-10 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-11 04:20:46 | Esmeralda, Nevada, US | |
144129 | 144129 | 2022-07-09 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-10 04:20:54 | Esmeralda, Nevada, US | |
1419229 | 1419229 | 2022-07-08 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-09 04:20:59 | Esmeralda, Nevada, US | |
2743154 | 2743154 | 2022-07-07 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-08 04:20:56 | Esmeralda, Nevada, US | |
1201949 | 1201949 | 2022-07-06 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-07 04:20:55 | Esmeralda, Nevada, US | |
3968692 | 3968692 | 2022-07-05 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-06 04:20:58 | Esmeralda, Nevada, US | |
3080203 | 3080203 | 2022-07-04 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-05 04:20:45 | Esmeralda, Nevada, US | |
1769485 | 1769485 | 2022-07-03 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-04 04:20:54 | Esmeralda, Nevada, US | |
3367471 | 3367471 | 2022-07-02 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-03 04:20:59 | Esmeralda, Nevada, US | |
595800 | 595800 | 2022-07-01 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-02 04:21:16 | Esmeralda, Nevada, US | |
3942201 | 3942201 | 2022-06-30 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-07-01 04:21:10 | Esmeralda, Nevada, US | |
2492159 | 2492159 | 2022-06-29 | US | Nevada | Esmeralda | 32009 | 110 | 3 | 0 | 37.78436681 | -117.6319999 | 2022-06-30 04:21:01 | Esmeralda, Nevada, US | |
1649312 | 1649312 | 2022-06-23 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-24 04:20:58 | Clark, Idaho, US | |
2188547 | 2188547 | 2022-06-22 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-23 04:20:55 | Clark, Idaho, US | |
166978 | 166978 | 2022-06-21 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-22 04:20:54 | Clark, Idaho, US | |
1764261 | 1764261 | 2022-06-20 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-21 04:20:56 | Clark, Idaho, US | |
3270447 | 3270447 | 2022-06-19 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-20 04:21:01 | Clark, Idaho, US | |
3398359 | 3398359 | 2022-06-18 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-19 04:20:51 | Clark, Idaho, US | |
2312236 | 2312236 | 2022-06-17 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-18 04:21:10 | Clark, Idaho, US | |
559740 | 559740 | 2022-06-16 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-17 04:20:56 | Clark, Idaho, US | |
3983542 | 3983542 | 2022-06-15 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-16 04:20:55 | Clark, Idaho, US | |
947783 | 947783 | 2022-06-14 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-15 04:20:54 | Clark, Idaho, US | |
2980191 | 2980191 | 2022-06-13 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-14 04:20:52 | Clark, Idaho, US | |
2236317 | 2236317 | 2022-06-12 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-13 04:21:14 | Clark, Idaho, US | |
3142515 | 3142515 | 2022-06-11 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-12 04:20:53 | Clark, Idaho, US | |
1945431 | 1945431 | 2022-06-10 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-11 04:21:01 | Clark, Idaho, US | |
3158570 | 3158570 | 2022-06-09 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-10 04:20:55 | Clark, Idaho, US | |
1422037 | 1422037 | 2022-06-08 | US | Idaho | Clark | 16033 | 110 | 1 | 0 | 44.28496071 | -112.3505704 | 2022-06-09 04:20:54 | Clark, Idaho, US | |
1996318 | 1996318 | 2022-03-01 | United Kingdom | Falkland Islands (Malvinas) | 110 | 0 | 0 | -51.7963 | -59.5236 | 2022-03-02 04:21:07 | Falkland Islands (Malvinas), United Kingdom | |||
946492 | 946492 | 2022-02-28 | United Kingdom | Falkland Islands (Malvinas) | 110 | 0 | 0 | -51.7963 | -59.5236 | 2022-03-01 04:21:09 | Falkland Islands (Malvinas), United Kingdom | |||
2735111 | 2735111 | 2022-02-27 | US | Nebraska | Hooker | 31091 | 110 | 2 | 0 | 41.91586243 | -101.1354293 | 2022-02-28 04:21:05 | Hooker, Nebraska, US | |
3048264 | 3048264 | 2022-02-26 | US | Nebraska | Hooker | 31091 | 110 | 2 | 0 | 41.91586243 | -101.1354293 | 2022-02-27 04:21:04 | Hooker, Nebraska, US | |
576919 | 576919 | 2022-02-25 | US | Nebraska | Hooker | 31091 | 110 | 2 | 0 | 41.91586243 | -101.1354293 | 2022-02-26 04:21:12 | Hooker, Nebraska, US | |
1513495 | 1513495 | 2022-02-24 | US | Nebraska | Hooker | 31091 | 110 | 2 | 0 | 41.91586243 | -101.1354293 | 2022-02-25 04:21:11 | Hooker, Nebraska, US | |
1059936 | 1059936 | 2022-02-23 | US | Nebraska | Hooker | 31091 | 110 | 2 | 0 | 41.91586243 | -101.1354293 | 2022-02-24 04:21:14 | Hooker, Nebraska, US | |
2448859 | 2448859 | 2022-02-22 | US | Nebraska | Hooker | 31091 | 110 | 2 | 0 | 41.91586243 | -101.1354293 | 2022-02-23 04:21:09 | Hooker, Nebraska, US | |
1962690 | 1962690 | 2022-01-20 | US | Nebraska | Wheeler | 31183 | 110 | 0 | 0 | 41.91482725 | -98.52798941 | 2022-01-21 04:21:09 | Wheeler, Nebraska, US | |
3690713 | 3690713 | 2022-01-13 | US | Texas | Terrell | 48443 | 110 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-01-14 04:21:54 | Terrell, Texas, US | |
3616297 | 3616297 | 2022-01-12 | US | Texas | Terrell | 48443 | 110 | 3 | 0 | 30.22429013 | -102.0766732 | 2022-01-13 08:00:09 | Terrell, Texas, US | |
1219229 | 1219229 | 2022-01-08 | United Kingdom | Montserrat | 110 | 1 | 0 | 16.742498 | -62.187366000000004 | 2022-01-09 04:21:46 | Montserrat, United Kingdom | |||
1282918 | 1282918 | 2022-01-05 | US | Idaho | Camas | 16025 | 110 | 1 | 0 | 43.46665742 | -114.8065892 | 2022-01-06 04:22:09 | Camas, Idaho, US | |
1286934 | 1286934 | 2022-01-04 | US | Idaho | Camas | 16025 | 110 | 1 | 0 | 43.46665742 | -114.8065892 | 2022-01-05 04:21:59 | Camas, Idaho, 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]);