johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
392 rows where confirmed = 2013 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755942 | 2755942 | 2022-12-29 | US | Texas | Brooks | 48047 | 2013 | 53 | 0 | 27.03103197 | -98.21808402 | 2022-12-30 04:21:04 | Brooks, Texas, US | |
1076948 | 1076948 | 2022-12-28 | US | Texas | Brooks | 48047 | 2013 | 53 | 0 | 27.03103197 | -98.21808402 | 2022-12-29 04:21:01 | Brooks, Texas, US | |
219863 | 219863 | 2022-12-26 | US | Missouri | Caldwell | 29025 | 2013 | 41 | 0 | 39.65620858 | -93.98308093 | 2022-12-27 04:21:07 | Caldwell, Missouri, US | |
3224320 | 3224320 | 2022-12-25 | US | Missouri | Caldwell | 29025 | 2013 | 41 | 0 | 39.65620858 | -93.98308093 | 2022-12-26 04:21:06 | Caldwell, Missouri, US | |
1020234 | 1020234 | 2022-12-24 | US | Missouri | Caldwell | 29025 | 2013 | 41 | 0 | 39.65620858 | -93.98308093 | 2022-12-25 04:21:04 | Caldwell, Missouri, US | |
692257 | 692257 | 2022-12-23 | US | Missouri | Caldwell | 29025 | 2013 | 41 | 0 | 39.65620858 | -93.98308093 | 2022-12-24 04:21:02 | Caldwell, Missouri, US | |
2181467 | 2181467 | 2022-12-22 | US | Missouri | Caldwell | 29025 | 2013 | 41 | 0 | 39.65620858 | -93.98308093 | 2022-12-23 04:21:04 | Caldwell, Missouri, US | |
453271 | 453271 | 2022-12-21 | US | Missouri | Caldwell | 29025 | 2013 | 41 | 0 | 39.65620858 | -93.98308093 | 2022-12-22 04:20:56 | Caldwell, Missouri, US | |
2954443 | 2954443 | 2022-12-20 | US | Texas | Coleman | 48083 | 2013 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-12-21 04:21:03 | Coleman, Texas, US | |
2953270 | 2953270 | 2022-12-20 | US | Missouri | Caldwell | 29025 | 2013 | 41 | 0 | 39.65620858 | -93.98308093 | 2022-12-21 04:21:03 | Caldwell, Missouri, US | |
3176845 | 3176845 | 2022-12-19 | US | Texas | Coleman | 48083 | 2013 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-12-20 04:21:04 | Coleman, Texas, US | |
1631362 | 1631362 | 2022-12-18 | US | Texas | Coleman | 48083 | 2013 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-12-19 04:21:03 | Coleman, Texas, US | |
506741 | 506741 | 2022-12-17 | US | Texas | Coleman | 48083 | 2013 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-12-18 04:21:03 | Coleman, Texas, US | |
3327313 | 3327313 | 2022-12-16 | US | Texas | Coleman | 48083 | 2013 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-12-17 04:21:04 | Coleman, Texas, US | |
545825 | 545825 | 2022-12-15 | US | Texas | Coleman | 48083 | 2013 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-12-16 04:21:01 | Coleman, Texas, US | |
351353 | 351353 | 2022-12-14 | US | Texas | Coleman | 48083 | 2013 | 74 | 0 | 31.76736834 | -99.45240766 | 2022-12-15 04:20:58 | Coleman, Texas, US | |
3280541 | 3280541 | 2022-10-23 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2013 | 0 | 0 | -7.9467 | -14.3559 | 2022-10-24 04:22:29 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2271579 | 2271579 | 2022-10-22 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2013 | 0 | 0 | -7.9467 | -14.3559 | 2022-10-23 04:22:46 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
1595879 | 1595879 | 2022-10-21 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2013 | 0 | 0 | -7.9467 | -14.3559 | 2022-10-22 04:22:53 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2275595 | 2275595 | 2022-10-20 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2013 | 0 | 0 | -7.9467 | -14.3559 | 2022-10-21 04:22:23 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
201930 | 201930 | 2022-10-19 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2013 | 0 | 0 | -7.9467 | -14.3559 | 2022-10-20 04:22:59 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2760591 | 2760591 | 2022-10-18 | United Kingdom | Saint Helena, Ascension and Tristan da Cunha | 2013 | 0 | 0 | -7.9467 | -14.3559 | 2022-10-19 04:22:26 | Saint Helena, Ascension and Tristan da Cunha, United Kingdom | |||
2032587 | 2032587 | 2022-10-14 | China | Liaoning | 2013 | 2 | 0 | 41.2956 | 122.6085 | 2022-10-15 04:22:00 | Liaoning, China | |||
2968395 | 2968395 | 2022-10-10 | US | Illinois | Edwards | 17047 | 2013 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-10-11 04:23:05 | Edwards, Illinois, US | |
3098431 | 3098431 | 2022-10-09 | US | Illinois | Edwards | 17047 | 2013 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-10-10 04:22:32 | Edwards, Illinois, US | |
4003656 | 4003656 | 2022-10-08 | US | Illinois | Edwards | 17047 | 2013 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-10-09 04:21:16 | Edwards, Illinois, US | |
397253 | 397253 | 2022-10-07 | US | Illinois | Edwards | 17047 | 2013 | 28 | 0 | 38.41353228 | -88.05720863 | 2022-10-08 04:22:56 | Edwards, Illinois, US | |
1396662 | 1396662 | 2022-09-02 | US | Tennessee | Pickett | 47137 | 2013 | 38 | 0 | 36.55606529 | -85.077633 | 2022-09-03 04:21:04 | Pickett, Tennessee, US | |
1876778 | 1876778 | 2022-08-28 | China | Hebei | 2013 | 7 | 0 | 37.8957 | 114.9042 | 2022-08-29 04:21:06 | Hebei, China | |||
1349386 | 1349386 | 2022-08-10 | US | Texas | Crosby | 48107 | 2013 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-08-11 04:20:49 | Crosby, Texas, US | |
1073202 | 1073202 | 2022-08-07 | US | Virginia | Bland | 51021 | 2013 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-08-08 04:21:08 | Bland, Virginia, US | |
1943790 | 1943790 | 2022-08-06 | US | Virginia | Bland | 51021 | 2013 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-08-07 04:20:54 | Bland, Virginia, US | |
883589 | 883589 | 2022-08-05 | US | Virginia | Bland | 51021 | 2013 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-08-06 04:20:56 | Bland, Virginia, US | |
1611627 | 1611627 | 2022-07-20 | US | Virginia | Lancaster | 51103 | 2013 | 33 | 0 | 37.71889653 | -76.46400482 | 2022-07-21 04:21:10 | Lancaster, Virginia, US | |
3969928 | 3969928 | 2022-07-05 | US | Virginia | Middlesex | 51119 | 2013 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-07-06 04:20:58 | Middlesex, Virginia, US | |
3078583 | 3078583 | 2022-07-04 | US | Arkansas | Prairie | 5117 | 2013 | 42 | 0 | 34.83624419 | -91.55162157 | 2022-07-05 04:20:45 | Prairie, Arkansas, US | |
596415 | 596415 | 2022-07-01 | US | Puerto Rico | Las Marias | 72083 | 2013 | 0 | 0 | 18.23679 | -66.98362 | 2022-07-02 04:21:16 | Las Marias, Puerto Rico, US | |
2241721 | 2241721 | 2022-06-28 | US | North Carolina | Gates | 37073 | 2013 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-29 04:20:59 | Gates, North Carolina, US | |
2149963 | 2149963 | 2022-06-27 | US | North Carolina | Gates | 37073 | 2013 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-28 04:20:58 | Gates, North Carolina, US | |
477764 | 477764 | 2022-06-26 | US | North Carolina | Gates | 37073 | 2013 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-27 04:21:00 | Gates, North Carolina, US | |
941139 | 941139 | 2022-06-25 | US | North Carolina | Gates | 37073 | 2013 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-26 04:21:02 | Gates, North Carolina, US | |
3348959 | 3348959 | 2022-06-24 | US | North Carolina | Gates | 37073 | 2013 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-25 04:20:57 | Gates, North Carolina, US | |
1650700 | 1650700 | 2022-06-23 | US | North Carolina | Gates | 37073 | 2013 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-24 04:20:58 | Gates, North Carolina, US | |
2189935 | 2189935 | 2022-06-22 | US | North Carolina | Gates | 37073 | 2013 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-23 04:20:55 | Gates, North Carolina, US | |
947755 | 947755 | 2022-06-14 | US | Georgia | Wilcox | 13315 | 2013 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-06-15 04:20:54 | Wilcox, Georgia, US | |
2980163 | 2980163 | 2022-06-13 | US | Georgia | Wilcox | 13315 | 2013 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-06-14 04:20:52 | Wilcox, Georgia, US | |
2236289 | 2236289 | 2022-06-12 | US | Georgia | Wilcox | 13315 | 2013 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-06-13 04:21:14 | Wilcox, Georgia, US | |
3142487 | 3142487 | 2022-06-11 | US | Georgia | Wilcox | 13315 | 2013 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-06-12 04:20:53 | Wilcox, Georgia, US | |
1945403 | 1945403 | 2022-06-10 | US | Georgia | Wilcox | 13315 | 2013 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-06-11 04:21:01 | Wilcox, Georgia, US | |
3160369 | 3160369 | 2022-06-09 | US | Puerto Rico | Ceiba | 72037 | 2013 | 0 | 0 | 18.251818 | -65.666416 | 2022-06-10 04:20:55 | Ceiba, Puerto Rico, US | |
3158542 | 3158542 | 2022-06-09 | US | Georgia | Wilcox | 13315 | 2013 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-06-10 04:20:55 | Wilcox, Georgia, US | |
1422009 | 1422009 | 2022-06-08 | US | Georgia | Wilcox | 13315 | 2013 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-06-09 04:20:54 | Wilcox, Georgia, US | |
3508435 | 3508435 | 2022-06-05 | US | Illinois | Schuyler | 17169 | 2013 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-06-06 04:20:57 | Schuyler, Illinois, US | |
3528512 | 3528512 | 2022-06-04 | US | Illinois | Schuyler | 17169 | 2013 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-06-05 04:20:55 | Schuyler, Illinois, US | |
3134598 | 3134598 | 2022-06-03 | US | Illinois | Schuyler | 17169 | 2013 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-06-04 04:20:58 | Schuyler, Illinois, US | |
3579673 | 3579673 | 2022-06-02 | US | Illinois | Schuyler | 17169 | 2013 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-06-03 04:20:58 | Schuyler, Illinois, US | |
2727761 | 2727761 | 2022-05-28 | US | Puerto Rico | Guanica | 72055 | 2013 | 0 | 0 | 17.982429 | -66.919643 | 2022-05-29 04:20:53 | Guanica, Puerto Rico, US | |
1111782 | 1111782 | 2022-05-21 | US | New Mexico | Quay | 35037 | 2013 | 55 | 0 | 35.10403332 | -103.5481727 | 2022-05-22 04:20:52 | Quay, New Mexico, US | |
1171406 | 1171406 | 2022-05-20 | US | New Mexico | Quay | 35037 | 2013 | 55 | 0 | 35.10403332 | -103.5481727 | 2022-05-21 04:20:58 | Quay, New Mexico, US | |
1188319 | 1188319 | 2022-05-18 | US | Wisconsin | Pepin | 55091 | 2013 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-05-19 04:20:54 | Pepin, Wisconsin, US | |
1188252 | 1188252 | 2022-05-18 | US | West Virginia | Pendleton | 54071 | 2013 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-19 04:20:54 | Pendleton, West Virginia, US | |
1187165 | 1187165 | 2022-05-18 | US | North Dakota | Pembina | 38067 | 2013 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-05-19 04:20:54 | Pembina, North Dakota, US | |
1505355 | 1505355 | 2022-05-16 | US | Minnesota | Pipestone | 27117 | 2013 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-05-17 04:20:59 | Pipestone, Minnesota, US | |
2085714 | 2085714 | 2022-05-15 | US | Minnesota | Pipestone | 27117 | 2013 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-05-16 04:20:47 | Pipestone, Minnesota, US | |
3356424 | 3356424 | 2022-05-14 | US | Minnesota | Pipestone | 27117 | 2013 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-05-15 04:20:53 | Pipestone, Minnesota, US | |
660069 | 660069 | 2022-05-13 | US | Minnesota | Pipestone | 27117 | 2013 | 34 | 0 | 44.02301619 | -96.25841142 | 2022-05-14 04:20:48 | Pipestone, Minnesota, US | |
225309 | 225309 | 2022-05-09 | US | Virginia | Buena Vista | 51530 | 2013 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-05-10 04:20:50 | Buena Vista, Virginia, US | |
2334694 | 2334694 | 2022-05-08 | US | Virginia | Buena Vista | 51530 | 2013 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-05-09 04:20:54 | Buena Vista, Virginia, US | |
363656 | 363656 | 2022-05-07 | US | Virginia | Buena Vista | 51530 | 2013 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-05-08 04:20:49 | Buena Vista, Virginia, US | |
1401007 | 1401007 | 2022-05-06 | US | Virginia | Buena Vista | 51530 | 2013 | 44 | 0 | 37.73484642 | -79.35296097 | 2022-05-07 04:21:09 | Buena Vista, Virginia, US | |
3269014 | 3269014 | 2022-05-04 | US | West Virginia | Tucker | 54093 | 2013 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-05-05 04:20:55 | Tucker, West Virginia, US | |
1575653 | 1575653 | 2022-05-03 | US | West Virginia | Tucker | 54093 | 2013 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-05-04 04:20:59 | Tucker, West Virginia, US | |
1699082 | 1699082 | 2022-04-28 | US | Puerto Rico | Hormigueros | 72067 | 2013 | 0 | 0 | 18.134532 | -67.113972 | 2022-04-29 04:20:59 | Hormigueros, Puerto Rico, US | |
2031717 | 2031717 | 2022-04-24 | US | Tennessee | Hancock | 47067 | 2013 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-04-25 04:20:56 | Hancock, Tennessee, US | |
749292 | 749292 | 2022-04-23 | US | Tennessee | Hancock | 47067 | 2013 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-04-24 04:20:56 | Hancock, Tennessee, US | |
3439777 | 3439777 | 2022-04-22 | US | Tennessee | Hancock | 47067 | 2013 | 37 | 0 | 36.52692871 | -83.22375847 | 2022-04-23 04:20:50 | Hancock, Tennessee, US | |
2446264 | 2446264 | 2022-04-13 | US | West Virginia | Pocahontas | 54075 | 2013 | 28 | 0 | 38.32758728 | -80.00993811 | 2022-04-13 23:21:06 | Pocahontas, West Virginia, US | |
1952021 | 1952021 | 2022-04-12 | US | West Virginia | Pocahontas | 54075 | 2013 | 28 | 0 | 38.32758728 | -80.00993811 | 2022-04-13 04:21:03 | Pocahontas, West Virginia, US | |
3209774 | 3209774 | 2022-04-11 | US | West Virginia | Pocahontas | 54075 | 2013 | 28 | 0 | 38.32758728 | -80.00993811 | 2022-04-12 04:20:49 | Pocahontas, West Virginia, US | |
1541243 | 1541243 | 2022-03-31 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-04-01 04:20:28 | Ellsworth, Kansas, US | |
2479256 | 2479256 | 2022-03-30 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-31 04:20:56 | Ellsworth, Kansas, US | |
159297 | 159297 | 2022-03-29 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-30 04:20:45 | Ellsworth, Kansas, US | |
1437868 | 1437868 | 2022-03-28 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-29 04:20:46 | Ellsworth, Kansas, US | |
877549 | 877549 | 2022-03-27 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-28 04:20:33 | Ellsworth, Kansas, US | |
2164832 | 2164832 | 2022-03-26 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-27 04:20:47 | Ellsworth, Kansas, US | |
1721768 | 1721768 | 2022-03-25 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-26 04:20:23 | Ellsworth, Kansas, US | |
1469385 | 1469385 | 2022-03-24 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-25 04:20:46 | Ellsworth, Kansas, US | |
3023559 | 3023559 | 2022-03-23 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-24 04:20:43 | Ellsworth, Kansas, US | |
1906481 | 1906481 | 2022-03-22 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-23 04:20:48 | Ellsworth, Kansas, US | |
3239612 | 3239612 | 2022-03-21 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-22 04:20:54 | Ellsworth, Kansas, US | |
25685 | 25685 | 2022-03-20 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-21 04:20:50 | Ellsworth, Kansas, US | |
1657695 | 1657695 | 2022-03-19 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-20 04:20:45 | Ellsworth, Kansas, US | |
337221 | 337221 | 2022-03-18 | US | Kansas | Ellsworth | 20053 | 2013 | 31 | 0 | 38.69677695 | -98.20462799 | 2022-03-19 04:20:47 | Ellsworth, Kansas, US | |
2263706 | 2263706 | 2022-03-14 | China | Yunnan | 2013 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-15 04:20:47 | Yunnan, China | |||
2201854 | 2201854 | 2022-03-06 | US | New Mexico | Sierra | 35051 | 2013 | 70 | 0 | 33.13028233 | -107.1925893 | 2022-03-07 04:20:47 | Sierra, New Mexico, US | |
2201583 | 2201583 | 2022-03-06 | US | Missouri | Oregon | 29149 | 2013 | 32 | 0 | 36.68710164 | -91.4033755 | 2022-03-07 04:20:47 | Oregon, Missouri, US | |
2094311 | 2094311 | 2022-03-05 | US | New Mexico | Sierra | 35051 | 2013 | 70 | 0 | 33.13028233 | -107.1925893 | 2022-03-06 04:20:49 | Sierra, New Mexico, US | |
2094040 | 2094040 | 2022-03-05 | US | Missouri | Oregon | 29149 | 2013 | 32 | 0 | 36.68710164 | -91.4033755 | 2022-03-06 04:20:49 | Oregon, Missouri, US | |
2668011 | 2668011 | 2022-03-04 | US | New Mexico | Sierra | 35051 | 2013 | 70 | 0 | 33.13028233 | -107.1925893 | 2022-03-05 04:21:10 | Sierra, New Mexico, US | |
2667740 | 2667740 | 2022-03-04 | US | Missouri | Oregon | 29149 | 2013 | 32 | 0 | 36.68710164 | -91.4033755 | 2022-03-05 04:21:10 | Oregon, Missouri, 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]);