johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
344 rows where confirmed = 1815 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 318
- United Kingdom 7
- Sweden 5
- New Zealand 3
- Netherlands 2
- Angola 1
- China 1
- Iceland 1
- Japan 1
- Mexico 1
- Romania 1
- Russia 1
- Ukraine 1
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
308776 | 308776 | 2022-12-13 | US | Georgia | Treutlen | 13283 | 1815 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-14 04:21:04 | Treutlen, Georgia, US | |
1149837 | 1149837 | 2022-12-12 | US | Georgia | Treutlen | 13283 | 1815 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-13 04:21:01 | Treutlen, Georgia, US | |
869691 | 869691 | 2022-12-11 | US | Georgia | Treutlen | 13283 | 1815 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-12 04:21:01 | Treutlen, Georgia, US | |
258221 | 258221 | 2022-12-10 | US | Georgia | Treutlen | 13283 | 1815 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-11 04:20:50 | Treutlen, Georgia, US | |
3936935 | 3936935 | 2022-12-09 | US | Georgia | Treutlen | 13283 | 1815 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-10 04:21:02 | Treutlen, Georgia, US | |
3378267 | 3378267 | 2022-12-08 | US | Georgia | Treutlen | 13283 | 1815 | 69 | 0 | 32.40422134 | -82.56904553 | 2022-12-09 04:21:05 | Treutlen, Georgia, US | |
2415846 | 2415846 | 2022-12-05 | US | Illinois | Calhoun | 17013 | 1815 | 6 | 0 | 39.16840183 | -90.66330078 | 2022-12-06 04:21:03 | Calhoun, Illinois, US | |
3554075 | 3554075 | 2022-11-27 | US | North Dakota | Ransom | 38073 | 1815 | 28 | 0 | 46.45621782 | -97.65742504 | 2022-11-28 04:21:02 | Ransom, North Dakota, US | |
2273817 | 2273817 | 2022-10-20 | US | Missouri | Clark | 29045 | 1815 | 43 | 0 | 40.41040752 | -91.73661677 | 2022-10-21 04:22:23 | Clark, Missouri, US | |
200152 | 200152 | 2022-10-19 | US | Missouri | Clark | 29045 | 1815 | 43 | 0 | 40.41040752 | -91.73661677 | 2022-10-20 04:22:59 | Clark, Missouri, US | |
2758813 | 2758813 | 2022-10-18 | US | Missouri | Clark | 29045 | 1815 | 43 | 0 | 40.41040752 | -91.73661677 | 2022-10-19 04:22:26 | Clark, Missouri, US | |
2026647 | 2026647 | 2022-10-17 | US | Missouri | Clark | 29045 | 1815 | 43 | 0 | 40.41040752 | -91.73661677 | 2022-10-18 04:22:42 | Clark, Missouri, US | |
2161425 | 2161425 | 2022-10-16 | US | Missouri | Clark | 29045 | 1815 | 43 | 0 | 40.41040752 | -91.73661677 | 2022-10-17 04:20:31 | Clark, Missouri, US | |
517622 | 517622 | 2022-10-15 | US | Missouri | Clark | 29045 | 1815 | 43 | 0 | 40.41040752 | -91.73661677 | 2022-10-16 04:22:39 | Clark, Missouri, US | |
2034679 | 2034679 | 2022-10-14 | US | Missouri | Clark | 29045 | 1815 | 43 | 0 | 40.41040752 | -91.73661677 | 2022-10-15 04:22:00 | Clark, Missouri, US | |
3251385 | 3251385 | 2022-10-11 | US | Iowa | Pocahontas | 19151 | 1815 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-12 04:22:51 | Pocahontas, Iowa, US | |
2968644 | 2968644 | 2022-10-10 | US | Iowa | Pocahontas | 19151 | 1815 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-11 04:23:05 | Pocahontas, Iowa, US | |
3098680 | 3098680 | 2022-10-09 | US | Iowa | Pocahontas | 19151 | 1815 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-10 04:22:32 | Pocahontas, Iowa, US | |
4003905 | 4003905 | 2022-10-08 | US | Iowa | Pocahontas | 19151 | 1815 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-09 04:21:16 | Pocahontas, Iowa, US | |
397502 | 397502 | 2022-10-07 | US | Iowa | Pocahontas | 19151 | 1815 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-08 04:22:56 | Pocahontas, Iowa, US | |
2530619 | 2530619 | 2022-10-06 | US | Iowa | Pocahontas | 19151 | 1815 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-07 04:23:08 | Pocahontas, Iowa, US | |
1812013 | 1812013 | 2022-10-05 | US | Iowa | Pocahontas | 19151 | 1815 | 27 | 0 | 42.73420133 | -94.67862564 | 2022-10-06 04:21:22 | Pocahontas, Iowa, US | |
2831869 | 2831869 | 2022-08-25 | US | Texas | Coleman | 48083 | 1815 | 73 | 0 | 31.76736834 | -99.45240766 | 2022-08-26 04:21:02 | Coleman, Texas, US | |
2326402 | 2326402 | 2022-08-24 | US | Texas | Coleman | 48083 | 1815 | 73 | 0 | 31.76736834 | -99.45240766 | 2022-08-25 04:21:13 | Coleman, Texas, US | |
1253811 | 1253811 | 2022-08-23 | US | Texas | Coleman | 48083 | 1815 | 73 | 0 | 31.76736834 | -99.45240766 | 2022-08-24 04:20:46 | Coleman, Texas, US | |
2855915 | 2855915 | 2022-08-22 | US | Texas | Coleman | 48083 | 1815 | 73 | 0 | 31.76736834 | -99.45240766 | 2022-08-23 04:20:56 | Coleman, Texas, US | |
1089242 | 1089242 | 2022-08-09 | US | Texas | Marion | 48315 | 1815 | 61 | 0 | 32.79868409 | -94.3566123 | 2022-08-10 04:20:57 | Marion, Texas, US | |
1200793 | 1200793 | 2022-07-06 | US | Illinois | Edwards | 17047 | 1815 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-07-07 04:20:55 | Edwards, Illinois, US | |
3970210 | 3970210 | 2022-07-05 | United Kingdom | Falkland Islands (Malvinas) | 1815 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-06 04:20:58 | Falkland Islands (Malvinas), United Kingdom | |||
3081721 | 3081721 | 2022-07-04 | United Kingdom | Falkland Islands (Malvinas) | 1815 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-05 04:20:45 | Falkland Islands (Malvinas), United Kingdom | |||
1771003 | 1771003 | 2022-07-03 | United Kingdom | Falkland Islands (Malvinas) | 1815 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-04 04:20:54 | Falkland Islands (Malvinas), United Kingdom | |||
3368989 | 3368989 | 2022-07-02 | United Kingdom | Falkland Islands (Malvinas) | 1815 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-03 04:20:59 | Falkland Islands (Malvinas), United Kingdom | |||
597318 | 597318 | 2022-07-01 | United Kingdom | Falkland Islands (Malvinas) | 1815 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-02 04:21:16 | Falkland Islands (Malvinas), United Kingdom | |||
3943719 | 3943719 | 2022-06-30 | United Kingdom | Falkland Islands (Malvinas) | 1815 | 0 | 0 | -51.7963 | -59.5236 | 2022-07-01 04:21:10 | Falkland Islands (Malvinas), United Kingdom | |||
2493677 | 2493677 | 2022-06-29 | United Kingdom | Falkland Islands (Malvinas) | 1815 | 0 | 0 | -51.7963 | -59.5236 | 2022-06-30 04:21:01 | Falkland Islands (Malvinas), United Kingdom | |||
2148124 | 2148124 | 2022-06-27 | US | Arkansas | Dallas | 5039 | 1815 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-28 04:20:58 | Dallas, Arkansas, US | |
475925 | 475925 | 2022-06-26 | US | Arkansas | Dallas | 5039 | 1815 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-27 04:21:00 | Dallas, Arkansas, US | |
939300 | 939300 | 2022-06-25 | US | Arkansas | Dallas | 5039 | 1815 | 32 | 0 | 33.97042763 | -92.65167437 | 2022-06-26 04:21:02 | Dallas, Arkansas, US | |
3347290 | 3347290 | 2022-06-24 | US | Colorado | Rio Blanco | 8103 | 1815 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-06-25 04:20:57 | Rio Blanco, Colorado, US | |
948583 | 948583 | 2022-06-14 | US | Minnesota | Lac qui Parle | 27073 | 1815 | 29 | 0 | 44.9973857 | -96.17488219 | 2022-06-15 04:20:54 | Lac qui Parle, Minnesota, US | |
3189300 | 3189300 | 2022-05-30 | US | Virginia | Bland | 51021 | 1815 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-05-31 04:20:51 | Bland, Virginia, US | |
3201449 | 3201449 | 2022-05-29 | US | Virginia | Bland | 51021 | 1815 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-05-30 04:20:50 | Bland, Virginia, US | |
2728327 | 2728327 | 2022-05-28 | US | Virginia | Bland | 51021 | 1815 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-05-29 04:20:53 | Bland, Virginia, US | |
1317508 | 1317508 | 2022-05-27 | US | Virginia | Bland | 51021 | 1815 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-05-28 04:21:07 | Bland, Virginia, US | |
3267509 | 3267509 | 2022-05-04 | US | Montana | Madison | 30057 | 1815 | 20 | 0 | 45.30080065 | -111.9173017 | 2022-05-05 04:20:55 | Madison, Montana, US | |
3855181 | 3855181 | 2022-04-27 | US | Virginia | Lancaster | 51103 | 1815 | 31 | 0 | 37.71889653 | -76.46400482 | 2022-04-28 04:20:47 | Lancaster, Virginia, US | |
3725273 | 3725273 | 2022-04-25 | US | Texas | Delta | 48119 | 1815 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-04-26 04:20:51 | Delta, Texas, US | |
2031841 | 2031841 | 2022-04-24 | US | Texas | Delta | 48119 | 1815 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-04-25 04:20:56 | Delta, Texas, US | |
749416 | 749416 | 2022-04-23 | US | Texas | Delta | 48119 | 1815 | 25 | 0 | 33.38570922 | -95.66921122 | 2022-04-24 04:20:56 | Delta, Texas, US | |
2479879 | 2479879 | 2022-03-30 | US | Missouri | Harrison | 29081 | 1815 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-03-31 04:20:56 | Harrison, Missouri, US | |
159920 | 159920 | 2022-03-29 | US | Missouri | Harrison | 29081 | 1815 | 33 | 0 | 40.35570088 | -93.99222144 | 2022-03-30 04:20:45 | Harrison, Missouri, US | |
878396 | 878396 | 2022-03-27 | US | Nebraska | Wayne | 31179 | 1815 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-03-28 04:20:33 | Wayne, Nebraska, US | |
2165679 | 2165679 | 2022-03-26 | US | Nebraska | Wayne | 31179 | 1815 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-03-27 04:20:47 | Wayne, Nebraska, US | |
1722615 | 1722615 | 2022-03-25 | US | Nebraska | Wayne | 31179 | 1815 | 7 | 0 | 42.20934475 | -97.11926964 | 2022-03-26 04:20:23 | Wayne, Nebraska, US | |
2142943 | 2142943 | 2022-03-09 | US | Puerto Rico | Patillas | 72109 | 1815 | 0 | 0 | 18.03174 | -66.012242 | 2022-03-10 04:20:48 | Patillas, Puerto Rico, US | |
922454 | 922454 | 2022-03-08 | US | Puerto Rico | Patillas | 72109 | 1815 | 0 | 0 | 18.03174 | -66.012242 | 2022-03-09 04:20:59 | Patillas, Puerto Rico, US | |
1550741 | 1550741 | 2022-03-07 | US | Puerto Rico | Patillas | 72109 | 1815 | 0 | 0 | 18.03174 | -66.012242 | 2022-03-08 04:20:54 | Patillas, Puerto Rico, US | |
3859093 | 3859093 | 2022-02-18 | US | Texas | Winkler | 48495 | 1815 | 34 | 0 | 31.85008651 | -103.04851629999999 | 2022-02-19 04:21:11 | Winkler, Texas, US | |
236307 | 236307 | 2022-02-11 | US | Texas | Crosby | 48107 | 1815 | 44 | 0 | 33.61431553 | -101.30003640000001 | 2022-02-12 04:21:06 | Crosby, Texas, US | |
236246 | 236246 | 2022-02-11 | US | Tennessee | Van Buren | 47175 | 1815 | 45 | 0 | 35.69864497 | -85.45221699 | 2022-02-12 04:21:06 | Van Buren, Tennessee, US | |
2016315 | 2016315 | 2022-02-06 | US | Wyoming | Johnson | 56019 | 1815 | 18 | 0 | 44.04057166 | -106.58451740000001 | 2022-02-07 04:21:05 | Johnson, Wyoming, US | |
2013530 | 2013530 | 2022-02-06 | US | Georgia | Irwin | 13155 | 1815 | 42 | 0 | 31.60213036 | -83.27501387 | 2022-02-07 04:21:05 | Irwin, Georgia, US | |
1297644 | 1297644 | 2022-02-05 | US | Wyoming | Johnson | 56019 | 1815 | 18 | 0 | 44.04057166 | -106.58451740000001 | 2022-02-06 04:21:00 | Johnson, Wyoming, US | |
1294859 | 1294859 | 2022-02-05 | US | Georgia | Irwin | 13155 | 1815 | 42 | 0 | 31.60213036 | -83.27501387 | 2022-02-06 04:21:00 | Irwin, Georgia, US | |
2330972 | 2330972 | 2022-02-04 | US | Wyoming | Johnson | 56019 | 1815 | 18 | 0 | 44.04057166 | -106.58451740000001 | 2022-02-05 04:21:05 | Johnson, Wyoming, US | |
2328187 | 2328187 | 2022-02-04 | US | Georgia | Irwin | 13155 | 1815 | 42 | 0 | 31.60213036 | -83.27501387 | 2022-02-05 04:21:05 | Irwin, Georgia, US | |
2477563 | 2477563 | 2022-02-03 | US | Wyoming | Johnson | 56019 | 1815 | 18 | 0 | 44.04057166 | -106.58451740000001 | 2022-02-04 04:21:10 | Johnson, Wyoming, US | |
462994 | 462994 | 2022-02-02 | US | Wyoming | Platte | 56031 | 1815 | 38 | 0 | 42.13299116 | -104.96633100000001 | 2022-02-03 04:21:21 | Platte, Wyoming, US | |
1143119 | 1143119 | 2022-01-23 | US | New Mexico | Quay | 35037 | 1815 | 37 | 0 | 35.10403332 | -103.54817270000001 | 2022-01-24 04:21:12 | Quay, New Mexico, US | |
2835037 | 2835037 | 2022-01-22 | US | New Mexico | Quay | 35037 | 1815 | 37 | 0 | 35.10403332 | -103.54817270000001 | 2022-01-23 04:21:13 | Quay, New Mexico, US | |
2833356 | 2833356 | 2022-01-22 | US | Arkansas | Searcy | 5129 | 1815 | 35 | 0 | 35.9109364 | -92.69936482 | 2022-01-23 04:21:13 | Searcy, Arkansas, US | |
3427155 | 3427155 | 2022-01-21 | US | New Mexico | Quay | 35037 | 1815 | 37 | 0 | 35.10403332 | -103.54817270000001 | 2022-01-22 04:21:13 | Quay, New Mexico, US | |
3467511 | 3467511 | 2022-01-18 | US | Virginia | Fairfax City | 51600 | 1815 | 36 | 0 | 38.85157547 | -77.29779640000002 | 2022-01-19 04:21:23 | Fairfax City, Virginia, US | |
3465704 | 3465704 | 2022-01-18 | US | Louisiana | Red River | 22081 | 1815 | 49 | 0 | 32.09530039 | -93.34213308 | 2022-01-19 04:21:23 | Red River, Louisiana, US | |
102559 | 102559 | 2022-01-14 | US | Texas | Terry | 48445 | 1815 | 74 | 0 | 33.17402785 | -102.3354521 | 2022-01-15 04:21:07 | Terry, Texas, US | |
100278 | 100278 | 2022-01-14 | US | Idaho | Owyhee | 16073 | 1815 | 43 | 0 | 42.58016894 | -116.16938710000001 | 2022-01-15 04:21:07 | Owyhee, Idaho, US | |
3616224 | 3616224 | 2022-01-12 | US | Texas | Live Oak | 48297 | 1815 | 39 | 0 | 28.35101362 | -98.1246786 | 2022-01-13 08:00:09 | Live Oak, Texas, US | |
1694216 | 1694216 | 2022-01-10 | US | Missouri | DeKalb | 29063 | 1815 | 38 | 0 | 39.89201062 | -94.40476508 | 2022-01-11 04:22:01 | DeKalb, Missouri, US | |
130150 | 130150 | 2022-01-09 | US | Virginia | Sussex | 51183 | 1815 | 31 | 0 | 36.92432914 | -77.25791182 | 2022-01-10 04:22:07 | Sussex, Virginia, US | |
129500 | 129500 | 2022-01-09 | US | Puerto Rico | Orocovis | 72107 | 1815 | 0 | 0 | 18.215046 | -66.433604 | 2022-01-10 04:22:07 | Orocovis, Puerto Rico, US | |
1218985 | 1218985 | 2022-01-08 | US | Virginia | Sussex | 51183 | 1815 | 31 | 0 | 36.92432914 | -77.25791182 | 2022-01-09 04:21:46 | Sussex, Virginia, US | |
1393078 | 1393078 | 2022-01-07 | US | Virginia | Sussex | 51183 | 1815 | 31 | 0 | 36.92432914 | -77.25791182 | 2022-01-08 04:21:53 | Sussex, Virginia, US | |
1286850 | 1286850 | 2022-01-04 | US | Georgia | McIntosh | 13191 | 1815 | 33 | 0 | 31.49683595 | -81.40163426 | 2022-01-05 04:21:59 | McIntosh, Georgia, US | |
1703127 | 1703127 | 2022-01-03 | US | Puerto Rico | San German | 72125 | 1815 | 0 | 0 | 18.111484 | -67.03858100000001 | 2022-01-04 04:22:17 | San German, Puerto Rico, US | |
1701853 | 1701853 | 2022-01-03 | US | Louisiana | East Carroll | 22035 | 1815 | 33 | 0 | 32.73926954 | -91.23425694 | 2022-01-04 04:22:17 | East Carroll, Louisiana, US | |
3998465 | 3998465 | 2021-12-30 | China | Yunnan | 1815 | 2 | 0 | 24.974 | 101.48700000000001 | 2021-12-31 04:21:50 | Yunnan, China | |||
2112768 | 2112768 | 2021-12-26 | US | Indiana | Benton | 18007 | 1815 | 19 | 0 | 40.60626947 | -87.31093999 | 2021-12-27 04:21:58 | Benton, Indiana, US | |
2112636 | 2112636 | 2021-12-26 | US | Idaho | Franklin | 16041 | 1815 | 26 | 0 | 42.18332217 | -111.81496659999999 | 2021-12-27 04:21:58 | Franklin, Idaho, US | |
3606140 | 3606140 | 2021-12-25 | US | Indiana | Benton | 18007 | 1815 | 19 | 0 | 40.60626947 | -87.31093999 | 2021-12-26 04:21:50 | Benton, Indiana, US | |
3606008 | 3606008 | 2021-12-25 | US | Idaho | Franklin | 16041 | 1815 | 26 | 0 | 42.18332217 | -111.81496659999999 | 2021-12-26 04:21:50 | Franklin, Idaho, US | |
2964458 | 2964458 | 2021-12-24 | US | Indiana | Benton | 18007 | 1815 | 19 | 0 | 40.60626947 | -87.31093999 | 2021-12-25 04:21:37 | Benton, Indiana, US | |
2964326 | 2964326 | 2021-12-24 | US | Idaho | Franklin | 16041 | 1815 | 26 | 0 | 42.18332217 | -111.81496659999999 | 2021-12-25 04:21:37 | Franklin, Idaho, US | |
3817490 | 3817490 | 2021-12-23 | US | Indiana | Benton | 18007 | 1815 | 19 | 0 | 40.60626947 | -87.31093999 | 2021-12-24 04:21:34 | Benton, Indiana, US | |
3817358 | 3817358 | 2021-12-23 | US | Idaho | Franklin | 16041 | 1815 | 26 | 0 | 42.18332217 | -111.81496659999999 | 2021-12-24 04:21:34 | Franklin, Idaho, US | |
801280 | 801280 | 2021-12-22 | US | South Dakota | Bon Homme | 46009 | 1815 | 31 | 0 | 42.98914167 | -97.88592746 | 2021-12-23 04:21:21 | Bon Homme, South Dakota, US | |
799498 | 799498 | 2021-12-22 | US | Indiana | Benton | 18007 | 1815 | 19 | 0 | 40.60626947 | -87.31093999 | 2021-12-23 04:21:21 | Benton, Indiana, US | |
799366 | 799366 | 2021-12-22 | US | Idaho | Franklin | 16041 | 1815 | 26 | 0 | 42.18332217 | -111.81496659999999 | 2021-12-23 04:21:21 | Franklin, Idaho, US | |
3831030 | 3831030 | 2021-12-21 | US | Oklahoma | Hughes | 40063 | 1815 | 44 | 0 | 35.04912569 | -96.24921145 | 2021-12-22 04:21:54 | Hughes, Oklahoma, US | |
3829406 | 3829406 | 2021-12-21 | US | Idaho | Franklin | 16041 | 1815 | 26 | 0 | 42.18332217 | -111.81496659999999 | 2021-12-22 04:21:54 | Franklin, Idaho, US | |
1257333 | 1257333 | 2021-12-20 | US | Oklahoma | Hughes | 40063 | 1815 | 44 | 0 | 35.04912569 | -96.24921145 | 2021-12-21 03:21:27 | Hughes, 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]);