johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
330 rows where active = 707 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 22
- US 286
- Russia 8
- Chile 6
- Colombia 4
- Malaysia 3
- Mexico 3
- Gabon 2
- Italy 2
- Japan 2
- Spain 2
- Bosnia and Herzegovina 1
- Cabo Verde 1
- Canada 1
- Croatia 1
- Germany 1
- India 1
- Madagascar 1
- Sierra Leone 1
- Suriname 1
- Ukraine 1
- United Kingdom 1
- Vietnam 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3331714 | 3331714 | 2021-07-21 | Russia | Adygea Republic | 15768 | 281 | 14780 | 707 | 44.6939006 | 40.1520421 | 2021-07-22 04:21:19 | Adygea Republic, Russia | ||
483596 | 483596 | 2021-07-19 | Japan | Fukuoka | 36431 | 528 | 35196 | 707 | 33.526032 | 130.666949 | 2021-07-20 04:21:48 | Fukuoka, Japan | ||
522778 | 522778 | 2021-06-09 | Germany | Schleswig-Holstein | 63452 | 1609 | 61200 | 707 | 54.2194 | 9.6961 | 2021-06-10 04:23:17 | Schleswig-Holstein, Germany | ||
3145772 | 3145772 | 2021-06-07 | Russia | Buryatia Republic | 39153 | 917 | 37529 | 707 | 52.7182426 | 109.492143 | 2021-06-08 04:22:35 | Buryatia Republic, Russia | ||
2450624 | 2450624 | 2021-05-02 | Colombia | Meta | 47156 | 1079 | 45370 | 707 | 3.272 | -73.0877 | 2021-05-03 04:20:39 | Meta, Colombia | ||
982732 | 982732 | 2021-04-17 | Chile | Arica y Parinacota | 18909 | 372 | 17830 | 707 | -18.594 | -69.4785 | 2021-04-18 04:20:41 | Arica y Parinacota, Chile | ||
36213 | 36213 | 2021-04-12 | Chile | Arica y Parinacota | 18473 | 363 | 17403 | 707 | -18.594 | -69.4785 | 2021-04-13 04:20:37 | Arica y Parinacota, Chile | ||
2649432 | 2649432 | 2021-04-08 | Malaysia | Perak | 13644 | 44 | 12893 | 707 | 4.5921 | 101.0901 | 2021-04-09 04:21:13 | Perak, Malaysia | ||
1301888 | 1301888 | 2021-04-01 | Colombia | Bolivar | 69780 | 1409 | 67664 | 707 | 8.6704 | -74.03 | 2021-04-02 04:20:36 | Bolivar, Colombia | ||
638128 | 638128 | 2021-03-31 | Russia | Kamchatka Krai | 14120 | 201 | 13212 | 707 | 57.1914882 | 160.03838190000005 | 2021-04-01 04:27:05 | Kamchatka Krai, Russia | ||
1798837 | 1798837 | 2021-03-23 | Russia | Ivanovo Oblast | 32028 | 1013 | 30308 | 707 | 56.9167446 | 41.43521370000001 | 2021-03-24 05:25:40 | Ivanovo Oblast, Russia | ||
3452868 | 3452868 | 2021-03-18 | Japan | Hokkaido | 20182 | 719 | 18756 | 707 | 43.385711 | 142.552318 | 2021-03-19 05:26:09 | Hokkaido, Japan | ||
702646 | 702646 | 2021-03-16 | Russia | Sakha (Yakutiya) Republic | 33152 | 538 | 31907 | 707 | 66.941626 | 129.642371 | 2021-03-17 05:25:07 | Sakha (Yakutiya) Republic, Russia | ||
1841581 | 1841581 | 2021-03-12 | United Kingdom | Isle of Man | 1157 | 26 | 424 | 707 | 54.2361 | -4.5481 | 2021-03-13 05:25:15 | Isle of Man, United Kingdom | ||
1093545 | 1093545 | 2021-03-03 | US | West Virginia | Gilmer | 54021 | 715 | 8 | 0 | 707 | 38.9251277 | -80.85952723 | 2021-03-04 05:24:24 | Gilmer, West Virginia, US |
1089918 | 1089918 | 2021-03-03 | Colombia | Cesar | 40605 | 1186 | 38712 | 707 | 9.3373 | -73.6536 | 2021-03-04 05:24:24 | Cesar, Colombia | ||
3257528 | 3257528 | 2021-03-02 | US | Virginia | Poquoson | 51735 | 722 | 15 | 0 | 707 | 37.14259351 | -76.35798148 | 2021-03-03 05:23:28 | Poquoson, Virginia, US |
1001654 | 1001654 | 2021-03-01 | US | Texas | Stephens | 48429 | 802 | 24 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-03-02 05:23:30 | Stephens, Texas, US |
2370712 | 2370712 | 2021-02-28 | US | Texas | Stephens | 48429 | 802 | 24 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-03-01 05:23:01 | Stephens, Texas, US |
3069214 | 3069214 | 2021-02-27 | US | Texas | Stephens | 48429 | 802 | 24 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-02-28 05:22:20 | Stephens, Texas, US |
3067557 | 3067557 | 2021-02-27 | US | Maine | Washington | 23029 | 721 | 14 | 0 | 707 | 45.01607142 | -67.62813524 | 2021-02-28 05:22:20 | Washington, Maine, US |
2186484 | 2186484 | 2021-02-26 | US | South Dakota | Walworth | 46129 | 722 | 15 | 0 | 707 | 45.43019636 | -100.0307514 | 2021-02-27 05:22:28 | Walworth, South Dakota, US |
1858477 | 1858477 | 2021-02-25 | US | Arkansas | Dallas | 5039 | 719 | 12 | 0 | 707 | 33.97042763 | -92.65167437 | 2021-02-26 05:22:40 | Dallas, Arkansas, US |
1939778 | 1939778 | 2021-02-23 | US | Virginia | Floyd | 51063 | 725 | 18 | 0 | 707 | 36.9302126 | -80.36738849 | 2021-02-24 05:29:16 | Floyd, Virginia, US |
183941 | 183941 | 2021-02-21 | US | Missouri | Howard | 29089 | 712 | 5 | 0 | 707 | 39.1435761 | -92.69756691 | 2021-02-22 05:24:21 | Howard, Missouri, US |
183335 | 183335 | 2021-02-21 | US | Kansas | Kingman | 20095 | 720 | 13 | 0 | 707 | 37.55909527 | -98.13638678 | 2021-02-22 05:24:21 | Kingman, Kansas, US |
743609 | 743609 | 2021-02-20 | US | Kansas | Kingman | 20095 | 720 | 13 | 0 | 707 | 37.55909527 | -98.13638678 | 2021-02-21 05:24:33 | Kingman, Kansas, US |
472707 | 472707 | 2021-02-19 | US | Kansas | Kingman | 20095 | 720 | 13 | 0 | 707 | 37.55909527 | -98.13638678 | 2021-02-20 05:22:51 | Kingman, Kansas, US |
1156783 | 1156783 | 2021-02-18 | Vietnam | 2347 | 35 | 1605 | 707 | 14.058324 | 108.277199 | 2021-02-19 05:24:16 | Vietnam | |||
3604349 | 3604349 | 2021-02-17 | US | Virginia | Charlotte | 51037 | 718 | 11 | 0 | 707 | 37.01909701 | -78.66314092 | 2021-02-18 05:22:58 | Charlotte, Virginia, US |
1341155 | 1341155 | 2021-02-15 | US | South Dakota | McCook | 46087 | 731 | 24 | 0 | 707 | 43.6742571 | -97.36863144 | 2021-02-16 05:24:38 | McCook, South Dakota, US |
2286306 | 2286306 | 2021-02-14 | US | South Dakota | McCook | 46087 | 731 | 24 | 0 | 707 | 43.6742571 | -97.36863144 | 2021-02-15 05:24:49 | McCook, South Dakota, US |
2284610 | 2284610 | 2021-02-14 | US | Iowa | Greene | 19073 | 717 | 10 | 0 | 707 | 42.03614551 | -94.39658081 | 2021-02-15 05:24:49 | Greene, Iowa, US |
2680850 | 2680850 | 2021-02-13 | US | Texas | Brooks | 48047 | 768 | 32 | 0 | 707 | 27.03103197 | -98.21808402 | 2021-02-14 05:23:43 | Brooks, Texas, US |
2679010 | 2679010 | 2021-02-13 | US | Iowa | Greene | 19073 | 717 | 10 | 0 | 707 | 42.03614551 | -94.39658081 | 2021-02-14 05:23:43 | Greene, Iowa, US |
3540329 | 3540329 | 2021-02-12 | US | Georgia | Taylor | 13269 | 729 | 22 | 0 | 707 | 32.55792548 | -84.25077141 | 2021-02-13 05:22:12 | Taylor, Georgia, US |
2638906 | 2638906 | 2021-02-11 | US | Iowa | Greene | 19073 | 716 | 9 | 0 | 707 | 42.03614551 | -94.39658081 | 2021-02-12 05:23:29 | Greene, Iowa, US |
3981945 | 3981945 | 2021-02-10 | US | Virginia | Nelson | 51125 | 713 | 6 | 0 | 707 | 37.78790447 | -78.88498513 | 2021-02-11 05:23:55 | Nelson, Virginia, US |
3981181 | 3981181 | 2021-02-10 | US | Oregon | Crook | 41013 | 723 | 16 | 0 | 707 | 44.14230227 | -120.356297 | 2021-02-11 05:23:55 | Crook, Oregon, US |
3980181 | 3980181 | 2021-02-10 | US | Michigan | Arenac | 26011 | 731 | 24 | 0 | 707 | 44.0636262 | -83.89277559 | 2021-02-11 05:23:55 | Arenac, Michigan, US |
614872 | 614872 | 2021-02-08 | US | Iowa | Greene | 19073 | 715 | 8 | 0 | 707 | 42.03614551 | -94.39658081 | 2021-02-09 05:23:30 | Greene, Iowa, US |
614861 | 614861 | 2021-02-08 | US | Iowa | Davis | 19051 | 730 | 23 | 0 | 707 | 40.74773536 | -92.41005468 | 2021-02-09 05:23:30 | Davis, Iowa, US |
1673630 | 1673630 | 2021-02-07 | US | Iowa | Davis | 19051 | 730 | 23 | 0 | 707 | 40.74773536 | -92.41005468 | 2021-02-08 05:22:39 | Davis, Iowa, US |
976091 | 976091 | 2021-02-06 | US | Iowa | Davis | 19051 | 730 | 23 | 0 | 707 | 40.74773536 | -92.41005468 | 2021-02-07 05:23:00 | Davis, Iowa, US |
1591395 | 1591395 | 2021-02-05 | US | Texas | Swisher | 48437 | 868 | 15 | 0 | 707 | 34.53028891 | -101.7349174 | 2021-02-06 05:23:55 | Swisher, Texas, US |
1589936 | 1589936 | 2021-02-05 | US | Minnesota | Stevens | 27149 | 715 | 8 | 0 | 707 | 45.58613007 | -96.00163705 | 2021-02-06 05:23:55 | Stevens, Minnesota, US |
1589349 | 1589349 | 2021-02-05 | US | Iowa | Davis | 19051 | 730 | 23 | 0 | 707 | 40.74773536 | -92.41005468 | 2021-02-06 05:23:55 | Davis, Iowa, US |
792175 | 792175 | 2021-02-04 | US | Mississippi | Franklin | 28037 | 726 | 19 | 0 | 707 | 31.47786634 | -90.89672989 | 2021-02-05 05:22:38 | Franklin, Mississippi, US |
790739 | 790739 | 2021-02-04 | US | Alabama | Coosa | 1037 | 728 | 21 | 0 | 707 | 32.93690146 | -86.24847739 | 2021-02-05 05:22:38 | Coosa, Alabama, US |
343490 | 343490 | 2021-02-03 | US | Texas | Stephens | 48429 | 799 | 21 | 0 | 707 | 32.73553157 | -98.83631615 | 2021-02-04 05:22:26 | Stephens, Texas, US |
342067 | 342067 | 2021-02-03 | US | Mississippi | Franklin | 28037 | 726 | 19 | 0 | 707 | 31.47786634 | -90.89672989 | 2021-02-04 05:22:26 | Franklin, Mississippi, US |
1678879 | 1678879 | 2021-02-01 | US | North Dakota | Pembina | 38067 | 719 | 11 | 0 | 707 | 48.76623521 | -97.5523809 | 2021-02-02 05:22:49 | Pembina, North Dakota, US |
1462167 | 1462167 | 2021-01-31 | US | North Dakota | Pembina | 38067 | 718 | 11 | 0 | 707 | 48.76623521 | -97.5523809 | 2021-02-01 05:22:53 | Pembina, North Dakota, US |
2214075 | 2214075 | 2021-01-30 | US | North Dakota | Pembina | 38067 | 718 | 11 | 0 | 707 | 48.76623521 | -97.5523809 | 2021-01-31 05:22:42 | Pembina, North Dakota, US |
1900326 | 1900326 | 2021-01-29 | US | Texas | Morris | 48343 | 872 | 19 | 0 | 707 | 33.11304005 | -94.73255695 | 2021-01-30 05:22:49 | Morris, Texas, US |
1899562 | 1899562 | 2021-01-29 | US | North Dakota | Pembina | 38067 | 718 | 11 | 0 | 707 | 48.76623521 | -97.5523809 | 2021-01-30 05:22:49 | Pembina, North Dakota, US |
3156161 | 3156161 | 2021-01-27 | US | Oklahoma | Kiowa | 40075 | 720 | 13 | 0 | 707 | 34.91671958 | -98.97720696 | 2021-01-28 05:22:24 | Kiowa, Oklahoma, US |
14897 | 14897 | 2021-01-26 | US | Oklahoma | Latimer | 40077 | 714 | 7 | 0 | 707 | 34.87844729 | -95.25215049 | 2021-01-27 05:23:41 | Latimer, Oklahoma, US |
14173 | 14173 | 2021-01-26 | US | Mississippi | Quitman | 28119 | 716 | 9 | 0 | 707 | 34.25157572 | -90.28908 | 2021-01-27 05:23:41 | Quitman, Mississippi, US |
13601 | 13601 | 2021-01-26 | US | Kansas | Clay | 20027 | 730 | 23 | 0 | 707 | 39.34948772 | -97.16518128 | 2021-01-27 05:23:41 | Clay, Kansas, US |
13158 | 13158 | 2021-01-26 | US | Georgia | Jenkins | 13165 | 743 | 36 | 0 | 707 | 32.79248718 | -81.96040187 | 2021-01-27 05:23:41 | Jenkins, Georgia, US |
2570221 | 2570221 | 2021-01-25 | US | Oklahoma | Latimer | 40077 | 714 | 7 | 0 | 707 | 34.87844729 | -95.25215049 | 2021-01-26 05:22:02 | Latimer, Oklahoma, US |
2568925 | 2568925 | 2021-01-25 | US | Kansas | Clay | 20027 | 730 | 23 | 0 | 707 | 39.34948772 | -97.16518128 | 2021-01-26 05:22:02 | Clay, Kansas, US |
1761323 | 1761323 | 2021-01-24 | US | Montana | Valley | 30105 | 717 | 10 | 0 | 707 | 48.36435097 | -106.6669635 | 2021-01-25 05:22:16 | Valley, Montana, US |
438361 | 438361 | 2021-01-21 | US | Texas | Archer | 48009 | 741 | 10 | 0 | 707 | 33.61569967 | -98.68754589 | 2021-01-22 05:22:10 | Archer, Texas, US |
435661 | 435661 | 2021-01-21 | Suriname | 7880 | 146 | 7027 | 707 | 3.9193 | -56.0278 | 2021-01-22 05:22:10 | Suriname | |||
1096679 | 1096679 | 2021-01-20 | US | Oklahoma | Unassigned | 90040 | 707 | 0 | 0 | 707 | 36.83532655 | 0.0 | 2021-01-21 05:22:01 | Unassigned, Oklahoma, US |
911854 | 911854 | 2021-01-19 | Malaysia | Melaka | 2233 | 7 | 1519 | 707 | 2.1896 | 102.2501 | 2021-01-20 05:21:54 | Melaka, Malaysia | ||
909426 | 909426 | 2021-01-19 | US | Kansas | Anderson | 20003 | 715 | 8 | 0 | 707 | 38.21413251 | -95.29272815 | 2021-01-20 05:21:54 | Anderson, Kansas, US |
238489 | 238489 | 2021-01-18 | US | Kansas | Anderson | 20003 | 715 | 8 | 0 | 707 | 38.21413251 | -95.29272815 | 2021-01-19 05:22:15 | Anderson, Kansas, US |
3505432 | 3505432 | 2021-01-17 | US | Nebraska | Holt | 31089 | 721 | 14 | 0 | 707 | 42.45522056 | -98.78402558 | 2021-01-18 05:22:34 | Holt, Nebraska, US |
3104795 | 3104795 | 2021-01-16 | US | Virginia | Lexington | 51678 | 721 | 14 | 0 | 707 | 37.78258621 | -79.44262866 | 2021-01-17 05:22:17 | Lexington, Virginia, US |
3103384 | 3103384 | 2021-01-16 | US | Missouri | Ralls | 29173 | 716 | 9 | 0 | 707 | 39.52817427 | -91.51838643 | 2021-01-17 05:22:17 | Ralls, Missouri, US |
3517346 | 3517346 | 2021-01-15 | US | Missouri | Ralls | 29173 | 716 | 9 | 0 | 707 | 39.52817427 | -91.51838643 | 2021-01-16 05:22:40 | Ralls, Missouri, US |
3516596 | 3516596 | 2021-01-15 | US | Iowa | Ida | 19093 | 737 | 30 | 0 | 707 | 42.38696136 | -95.51355387 | 2021-01-16 05:22:40 | Ida, Iowa, US |
3883254 | 3883254 | 2021-01-14 | Malaysia | Perak | 4130 | 19 | 3404 | 707 | 4.5921 | 101.0901 | 2021-01-15 05:22:24 | Perak, Malaysia | ||
3310353 | 3310353 | 2021-01-13 | US | New Hampshire | Sullivan | 33019 | 713 | 6 | 0 | 707 | 43.36094111 | -72.22203125 | 2021-01-14 05:22:32 | Sullivan, New Hampshire, US |
776619 | 776619 | 2021-01-12 | US | New York | Yates | 36123 | 722 | 15 | 0 | 707 | 42.63505484 | -77.10369919 | 2021-01-13 05:22:15 | Yates, New York, US |
190907 | 190907 | 2021-01-11 | US | Georgia | Montgomery | 13209 | 718 | 11 | 0 | 707 | 32.17201038 | -82.53527476 | 2021-01-12 05:22:15 | Montgomery, Georgia, US |
190583 | 190583 | 2021-01-11 | US | Arkansas | Scott | 5127 | 721 | 14 | 0 | 707 | 34.85588887 | -94.0632176 | 2021-01-12 05:22:15 | Scott, Arkansas, US |
2628357 | 2628357 | 2021-01-10 | US | Ohio | Morgan | 39115 | 721 | 14 | 0 | 707 | 39.62081738 | -81.85308173 | 2021-01-11 05:21:50 | Morgan, Ohio, US |
154795 | 154795 | 2021-01-08 | US | Georgia | Irwin | 13155 | 725 | 18 | 0 | 707 | 31.60213036 | -83.27501387 | 2021-01-09 05:22:18 | Irwin, Georgia, US |
154772 | 154772 | 2021-01-08 | US | Georgia | Evans | 13109 | 721 | 14 | 0 | 707 | 32.15328841 | -81.8870105 | 2021-01-09 05:22:18 | Evans, Georgia, US |
154764 | 154764 | 2021-01-08 | US | Georgia | Dooly | 13093 | 732 | 25 | 0 | 707 | 32.15630737 | -83.79746561 | 2021-01-09 05:22:18 | Dooly, Georgia, US |
2542163 | 2542163 | 2021-01-07 | US | Georgia | Candler | 13043 | 744 | 37 | 0 | 707 | 32.40209349 | -82.07702563 | 2021-01-08 05:22:42 | Candler, Georgia, US |
2541681 | 2541681 | 2021-01-07 | Sierra Leone | 2757 | 77 | 1973 | 707 | 8.460555000000001 | -11.779889 | 2021-01-08 05:22:42 | Sierra Leone | |||
2865594 | 2865594 | 2021-01-06 | US | Georgia | Turner | 13287 | 732 | 25 | 0 | 707 | 31.71612656 | -83.62069378 | 2021-01-07 05:22:03 | Turner, Georgia, US |
3230247 | 3230247 | 2021-01-03 | Chile | Tarapaca | 16108 | 290 | 15111 | 707 | -19.9232 | -69.5132 | 2021-01-04 05:22:02 | Tarapaca, Chile | ||
2230237 | 2230237 | 2021-01-02 | US | Puerto Rico | Catano | 72033 | 707 | 0 | 0 | 707 | 18.437269 | -66.14330600000001 | 2021-01-03 05:22:52 | Catano, Puerto Rico, US |
2229302 | 2229302 | 2021-01-02 | US | Mississippi | Claiborne | 28021 | 727 | 20 | 0 | 707 | 31.97061673 | -90.90702196 | 2021-01-03 05:22:52 | Claiborne, Mississippi, US |
1139598 | 1139598 | 2021-01-01 | US | Puerto Rico | Camuy | 72027 | 707 | 0 | 0 | 707 | 18.418578 | -66.860206 | 2021-01-02 05:22:33 | Camuy, Puerto Rico, US |
1139367 | 1139367 | 2021-01-01 | US | Ohio | Monroe | 39111 | 735 | 28 | 0 | 707 | 39.72984936 | -81.08464734 | 2021-01-02 05:22:33 | Monroe, Ohio, US |
1139230 | 1139230 | 2021-01-01 | US | North Carolina | Polk | 37149 | 720 | 13 | 0 | 707 | 35.27820615 | -82.16812354 | 2021-01-02 05:22:33 | Polk, North Carolina, US |
3697973 | 3697973 | 2020-12-31 | US | Ohio | Monroe | 39111 | 735 | 28 | 0 | 707 | 39.72984936 | -81.08464734 | 2021-01-01 05:23:07 | Monroe, Ohio, US |
3697836 | 3697836 | 2020-12-31 | US | North Carolina | Polk | 37149 | 720 | 13 | 0 | 707 | 35.27820615 | -82.16812354 | 2021-01-01 05:23:07 | Polk, North Carolina, US |
1013312 | 1013312 | 2020-12-30 | US | Texas | Bailey | 48017 | 794 | 12 | 0 | 707 | 34.06854817 | -102.8299707 | 2020-12-31 05:22:49 | Bailey, Texas, US |
1012865 | 1012865 | 2020-12-30 | US | Oklahoma | Major | 40093 | 711 | 4 | 0 | 707 | 36.31149996 | -98.53467076 | 2020-12-31 05:22:49 | Major, Oklahoma, US |
1011527 | 1011527 | 2020-12-30 | US | Iowa | Pocahontas | 19151 | 718 | 11 | 0 | 707 | 42.73420133 | -94.67862564 | 2020-12-31 05:22:49 | Pocahontas, Iowa, US |
1011250 | 1011250 | 2020-12-30 | US | Idaho | Teton | 16081 | 709 | 2 | 0 | 707 | 43.75303583 | -111.2056773 | 2020-12-31 05:22:49 | Teton, Idaho, US |
767025 | 767025 | 2020-12-29 | US | Florida | Liberty | 12077 | 721 | 14 | 0 | 707 | 30.23766008 | -84.8829258 | 2020-12-30 05:22:34 | Liberty, Florida, 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]);