johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
129 rows where active = 1820 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3015569 | 3015569 | 2021-08-01 | Russia | Kurgan Oblast | 25899 | 495 | 23584 | 1820 | 55.7655302 | 64.5632681 | 2021-08-02 04:21:36 | Kurgan Oblast, Russia | ||
3137464 | 3137464 | 2021-07-23 | Germany | Hessen | 293393 | 7573 | 284000 | 1820 | 50.6521 | 9.1624 | 2021-07-24 00:21:36 | Hessen, Germany | ||
3476224 | 3476224 | 2021-07-22 | Germany | Hessen | 293201 | 7573 | 284000 | 1820 | 50.6521 | 9.1624 | 2021-07-23 04:21:29 | Hessen, Germany | ||
778204 | 778204 | 2021-07-08 | Colombia | Cesar | 82157 | 2259 | 78078 | 1820 | 9.3373 | -73.6536 | 2021-07-09 04:21:21 | Cesar, Colombia | ||
526524 | 526524 | 2021-06-09 | Yemen | 6832 | 1337 | 3675 | 1820 | 15.552727 | 48.516388 | 2021-06-10 04:23:17 | Yemen | |||
3089611 | 3089611 | 2021-05-30 | Russia | Belgorod Oblast | 38727 | 690 | 36217 | 1820 | 50.7080119 | 37.5837615 | 2021-05-31 03:08:59 | Belgorod Oblast, Russia | ||
1310020 | 1310020 | 2021-05-26 | Colombia | Magdalena | 68773 | 2604 | 64349 | 1820 | 10.4113 | -74.4057 | 2021-05-27 04:20:59 | Magdalena, Colombia | ||
1913460 | 1913460 | 2021-05-20 | Russia | Tambov Oblast | 32307 | 513 | 29974 | 1820 | 52.9019574 | 41.3578918 | 2021-05-21 04:20:43 | Tambov Oblast, Russia | ||
2390958 | 2390958 | 2021-05-18 | Russia | Bashkortostan Republic | 37039 | 493 | 34726 | 1820 | 54.8573563 | 57.1439682 | 2021-05-19 04:20:42 | Bashkortostan Republic, Russia | ||
3574510 | 3574510 | 2021-05-17 | Germany | Mecklenburg-Vorpommern | 42961 | 1079 | 40100 | 1820 | 53.6127 | 12.4296 | 2021-05-18 04:20:33 | Mecklenburg-Vorpommern, Germany | ||
1081768 | 1081768 | 2021-05-14 | Colombia | Cesar | 60182 | 1605 | 56757 | 1820 | 9.3373 | -73.6536 | 2021-05-15 04:20:58 | Cesar, Colombia | ||
2247357 | 2247357 | 2021-04-07 | India | Puducherry | 42949 | 687 | 40442 | 1820 | 11.882658 | 78.86498 | 2021-04-08 04:21:13 | Puducherry, India | ||
3003156 | 3003156 | 2021-04-06 | Colombia | Magdalena | 47091 | 1716 | 43555 | 1820 | 10.4113 | -74.4057 | 2021-04-07 04:20:53 | Magdalena, Colombia | ||
1881201 | 1881201 | 2021-03-26 | Russia | Krasnoyarsk Krai | 66165 | 3107 | 61238 | 1820 | 63.3233807 | 97.0979974 | 2021-03-27 05:25:04 | Krasnoyarsk Krai, Russia | ||
1798861 | 1798861 | 2021-03-23 | Russia | Mordovia Republic | 18756 | 193 | 16743 | 1820 | 54.4419829 | 44.4661144 | 2021-03-24 05:25:40 | Mordovia Republic, Russia | ||
3257544 | 3257544 | 2021-03-02 | US | Virginia | Salem | 51775 | 1861 | 41 | 0 | 1820 | 37.2836193 | -80.06219455 | 2021-03-03 05:23:28 | Salem, Virginia, US |
2185861 | 2185861 | 2021-02-26 | US | North Carolina | Ashe | 37009 | 1860 | 40 | 0 | 1820 | 36.43296207 | -81.49862729 | 2021-02-27 05:22:28 | Ashe, North Carolina, US |
2183833 | 2183833 | 2021-02-26 | Russia | Tomsk Oblast | 30164 | 308 | 28036 | 1820 | 58.6124279 | 82.04753149999998 | 2021-02-27 05:22:28 | Tomsk Oblast, Russia | ||
1937094 | 1937094 | 2021-02-23 | US | Colorado | Routt | 8107 | 1892 | 19 | 0 | 1820 | 40.48596505 | -106.9905548 | 2021-02-24 05:29:16 | Routt, Colorado, US |
532286 | 532286 | 2021-02-22 | US | Maryland | Talbot | 24041 | 1851 | 31 | 0 | 1820 | 38.76618159 | -76.10882561 | 2021-02-23 05:23:41 | Talbot, Maryland, US |
3052739 | 3052739 | 2021-02-16 | US | Oklahoma | Marshall | 40095 | 1832 | 12 | 0 | 1820 | 34.02311222 | -96.76855464 | 2021-02-17 05:23:10 | Marshall, Oklahoma, US |
1341854 | 1341854 | 2021-02-15 | US | Wisconsin | Vernon | 55123 | 1859 | 39 | 0 | 1820 | 43.59422667 | -90.8324691 | 2021-02-16 05:24:38 | Vernon, Wisconsin, US |
2641110 | 2641110 | 2021-02-11 | US | Virginia | Radford | 51750 | 1831 | 11 | 0 | 1820 | 37.12222899 | -80.56027320000003 | 2021-02-12 05:23:29 | Radford, Virginia, US |
2638193 | 2638193 | 2021-02-11 | US | Arkansas | Cross | 5037 | 1867 | 47 | 0 | 1820 | 35.29631396 | -90.77185818 | 2021-02-12 05:23:29 | Cross, Arkansas, US |
617072 | 617072 | 2021-02-08 | US | Virginia | Prince Edward | 51147 | 1840 | 20 | 0 | 1820 | 37.22554789 | -78.43597949 | 2021-02-09 05:23:30 | Prince Edward, Virginia, US |
616256 | 616256 | 2021-02-08 | US | Oklahoma | Murray | 40099 | 1840 | 20 | 0 | 1820 | 34.48116015 | -97.06826283 | 2021-02-09 05:23:30 | Murray, Oklahoma, US |
615342 | 615342 | 2021-02-08 | US | Michigan | Menominee | 26109 | 1856 | 36 | 0 | 1820 | 45.58038692 | -87.55370409 | 2021-02-09 05:23:30 | Menominee, Michigan, US |
1684963 | 1684963 | 2021-02-02 | US | Arkansas | Clark | 5019 | 1855 | 35 | 0 | 1820 | 34.04613432 | -93.17484713 | 2021-02-03 05:22:52 | Clark, Arkansas, US |
1676837 | 1676837 | 2021-02-01 | US | Alabama | Fayette | 1057 | 1858 | 38 | 0 | 1820 | 33.72076938 | -87.73886638 | 2021-02-02 05:22:49 | Fayette, Alabama, US |
1462666 | 1462666 | 2021-01-31 | US | Tennessee | Bledsoe | 47007 | 1881 | 11 | 0 | 1820 | 35.59942968 | -85.20611967 | 2021-02-01 05:22:53 | Bledsoe, Tennessee, US |
2212305 | 2212305 | 2021-01-30 | US | Colorado | Pitkin | 8097 | 1875 | 4 | 0 | 1820 | 39.21720112 | -106.9310027 | 2021-01-31 05:22:42 | Pitkin, Colorado, US |
1898036 | 1898036 | 2021-01-29 | US | Georgia | Union | 13291 | 1875 | 55 | 0 | 1820 | 34.82995757 | -83.98967069 | 2021-01-30 05:22:49 | Union, Georgia, US |
2428824 | 2428824 | 2021-01-23 | US | Missouri | McDonald | 29119 | 1844 | 24 | 0 | 1820 | 36.62869595 | -94.34867205 | 2021-01-24 05:22:35 | McDonald, Missouri, US |
2467295 | 2467295 | 2021-01-22 | US | Arkansas | Lawrence | 5075 | 1860 | 40 | 0 | 1820 | 36.04188196 | -91.10867198 | 2021-01-23 05:22:03 | Lawrence, Arkansas, US |
1097230 | 1097230 | 2021-01-20 | US | Texas | Lavaca | 48285 | 1856 | 63 | 0 | 1820 | 29.38508402 | -96.93186692 | 2021-01-21 05:22:01 | Lavaca, Texas, US |
909410 | 909410 | 2021-01-19 | US | Iowa | Tama | 19171 | 1877 | 57 | 0 | 1820 | 42.07991767 | -92.53266945 | 2021-01-20 05:21:54 | Tama, Iowa, US |
908386 | 908386 | 2021-01-19 | Russia | Khakassia Republic | 19507 | 341 | 17346 | 1820 | 53.72258845 | 91.44293627 | 2021-01-20 05:21:54 | Khakassia Republic, Russia | ||
3505463 | 3505463 | 2021-01-17 | US | Nebraska | Saline | 31151 | 1823 | 3 | 0 | 1820 | 40.52418865 | -97.14085859 | 2021-01-18 05:22:34 | Saline, Nebraska, US |
3882092 | 3882092 | 2021-01-14 | US | Ohio | Wyandot | 39175 | 1869 | 49 | 0 | 1820 | 40.84339621 | -83.30734173 | 2021-01-15 05:22:24 | Wyandot, Ohio, US |
191497 | 191497 | 2021-01-11 | US | Kentucky | Marshall | 21157 | 1845 | 25 | 0 | 1820 | 36.88007070000001 | -88.32803576 | 2021-01-12 05:22:15 | Marshall, Kentucky, US |
2628108 | 2628108 | 2021-01-10 | US | New York | Montgomery | 36057 | 1883 | 63 | 0 | 1820 | 42.90123494 | -74.44011632 | 2021-01-11 05:21:50 | Montgomery, New York, US |
3901360 | 3901360 | 2021-01-09 | US | Kentucky | Harlan | 21095 | 1845 | 25 | 0 | 1820 | 36.85699301 | -83.21899516 | 2021-01-10 05:22:12 | Harlan, Kentucky, US |
157463 | 157463 | 2021-01-08 | US | West Virginia | Logan | 54045 | 1882 | 62 | 0 | 1820 | 37.8299889 | -81.93528571 | 2021-01-09 05:22:18 | Logan, West Virginia, US |
155748 | 155748 | 2021-01-08 | US | Minnesota | Waseca | 27161 | 1836 | 16 | 0 | 1820 | 44.02211116 | -93.58720034 | 2021-01-09 05:22:18 | Waseca, Minnesota, US |
3232303 | 3232303 | 2021-01-03 | US | Mississippi | Winston | 28159 | 1872 | 52 | 0 | 1820 | 33.08747908 | -89.03391385 | 2021-01-04 05:22:02 | Winston, Mississippi, US |
3698562 | 3698562 | 2020-12-31 | US | Texas | Fannin | 48147 | 2001 | 52 | 0 | 1820 | 33.59564294 | -96.10751083 | 2021-01-01 05:23:07 | Fannin, Texas, US |
1012239 | 1012239 | 2020-12-30 | US | Missouri | Perry | 29157 | 1839 | 19 | 0 | 1820 | 37.70660776 | -89.82741088 | 2020-12-31 05:22:49 | Perry, Missouri, US |
767148 | 767148 | 2020-12-29 | US | Georgia | Lumpkin | 13187 | 1842 | 22 | 0 | 1820 | 34.57286511 | -84.00425681 | 2020-12-30 05:22:34 | Lumpkin, Georgia, US |
3764386 | 3764386 | 2020-12-28 | US | South Carolina | Colleton | 45029 | 1874 | 54 | 0 | 1820 | 32.87582989 | -80.67641292 | 2020-12-29 05:22:37 | Colleton, South Carolina, US |
3764049 | 3764049 | 2020-12-28 | US | Ohio | Holmes | 39075 | 1896 | 76 | 0 | 1820 | 40.56163713 | -81.92635677 | 2020-12-29 05:22:37 | Holmes, Ohio, US |
203619 | 203619 | 2020-12-25 | US | Kentucky | Boyle | 21021 | 1820 | 0 | 0 | 1820 | 37.62680923 | -84.8633779 | 2020-12-26 05:22:28 | Boyle, Kentucky, US |
3692842 | 3692842 | 2020-12-24 | US | Kentucky | Boyle | 21021 | 1820 | 0 | 0 | 1820 | 37.62680923 | -84.8633779 | 2020-12-25 05:22:48 | Boyle, Kentucky, US |
2408194 | 2408194 | 2020-12-23 | US | Kentucky | Boyle | 21021 | 1820 | 0 | 0 | 1820 | 37.62680923 | -84.8633779 | 2020-12-24 05:23:04 | Boyle, Kentucky, US |
3770269 | 3770269 | 2020-12-22 | US | Alabama | Pike | 1109 | 1843 | 23 | 0 | 1820 | 31.80396383 | -85.9408295 | 2020-12-23 05:22:03 | Pike, Alabama, US |
2933051 | 2933051 | 2020-12-19 | US | Mississippi | Prentiss | 28117 | 1860 | 40 | 0 | 1820 | 34.61810501 | -88.51986294 | 2020-12-20 05:27:32 | Prentiss, Mississippi, US |
1902055 | 1902055 | 2020-12-18 | US | Georgia | Wayne | 13305 | 1869 | 49 | 0 | 1820 | 31.5521809 | -81.91894878 | 2020-12-19 05:27:52 | Wayne, Georgia, US |
2130261 | 2130261 | 2020-12-17 | US | New York | Wayne | 36117 | 1848 | 28 | 0 | 1820 | 43.15494365 | -77.02976528 | 2020-12-18 05:28:18 | Wayne, New York, US |
3152426 | 3152426 | 2020-12-16 | US | South Carolina | Williamsburg | 45089 | 1874 | 54 | 0 | 1820 | 33.62190129 | -79.72767442 | 2020-12-17 05:28:12 | Williamsburg, South Carolina, US |
847301 | 847301 | 2020-12-12 | US | Minnesota | Mille Lacs | 27095 | 1858 | 38 | 0 | 1820 | 45.93705297 | -93.63236823 | 2020-12-13 05:27:20 | Mille Lacs, Minnesota, US |
1822394 | 1822394 | 2020-12-08 | US | Wyoming | Teton | 56039 | 1822 | 2 | 0 | 1820 | 43.93522482 | -110.5890801 | 2020-12-09 05:28:01 | Teton, Wyoming, US |
2349397 | 2349397 | 2020-12-07 | US | Montana | Big Horn | 30003 | 1871 | 51 | 0 | 1820 | 45.42335905 | -107.492347 | 2020-12-08 05:27:42 | Big Horn, Montana, US |
1007794 | 1007794 | 2020-12-06 | US | Louisiana | Jefferson Davis | 22053 | 1874 | 54 | 0 | 1820 | 30.26896765 | -92.81210004 | 2020-12-07 05:26:14 | Jefferson Davis, Louisiana, US |
741259 | 741259 | 2020-12-02 | US | Tennessee | Marshall | 47117 | 1861 | 22 | 0 | 1820 | 35.45798777 | -86.76420988 | 2020-12-03 05:28:22 | Marshall, Tennessee, US |
2539980 | 2539980 | 2020-12-01 | US | Oklahoma | Sequoyah | 40135 | 1834 | 14 | 0 | 1820 | 35.49447108 | -94.75463785 | 2020-12-02 05:27:41 | Sequoyah, Oklahoma, US |
1587458 | 1587458 | 2020-11-30 | US | Virginia | Bedford | 51019 | 1839 | 19 | 0 | 1820 | 37.3080028 | -79.5281964 | 2020-12-01 05:26:18 | Bedford, Virginia, US |
3569507 | 3569507 | 2020-11-29 | US | Tennessee | Henderson | 47077 | 1858 | 34 | 0 | 1820 | 35.65581134 | -88.38600175 | 2020-11-30 05:26:13 | Henderson, Tennessee, US |
3836727 | 3836727 | 2020-11-21 | Russia | Stavropol Krai | 25686 | 503 | 23363 | 1820 | 44.86325770000001 | 43.4406913 | 2020-11-22 05:25:45 | Stavropol Krai, Russia | ||
122951 | 122951 | 2020-11-18 | Russia | Tambov Oblast | 11761 | 70 | 9871 | 1820 | 52.9019574 | 41.3578918 | 2020-11-19 05:25:23 | Tambov Oblast, Russia | ||
3341618 | 3341618 | 2020-11-17 | US | Texas | Caldwell | 48055 | 1562 | 39 | 0 | 1820 | 29.83668859 | -97.61814775 | 2020-11-18 05:40:31 | Caldwell, Texas, US |
3339272 | 3339272 | 2020-11-17 | US | Florida | DeSoto | 12027 | 1853 | 33 | 0 | 1820 | 27.18677893 | -81.80941373 | 2020-11-18 05:40:31 | DeSoto, Florida, US |
865856 | 865856 | 2020-11-12 | US | Indiana | Henry | 18065 | 1854 | 34 | 0 | 1820 | 39.93029017 | -85.39625719 | 2020-11-13 05:25:30 | Henry, Indiana, US |
376700 | 376700 | 2020-11-06 | US | Arkansas | St. Francis | 5123 | 1830 | 10 | 0 | 1820 | 35.02201976 | -90.74828138 | 2020-11-07 05:24:52 | St. Francis, Arkansas, US |
376602 | 376602 | 2020-11-06 | US | Alaska | Matanuska-Susitna | 2170 | 1823 | 3 | 0 | 1820 | 62.31305045 | -149.5741743 | 2020-11-07 05:24:52 | Matanuska-Susitna, Alaska, US |
1179150 | 1179150 | 2020-10-22 | US | Michigan | Muskegon | 26121 | 1897 | 77 | 0 | 1820 | 43.29123859 | -86.15176712 | 2020-10-23 04:24:46 | Muskegon, Michigan, US |
3993964 | 3993964 | 2020-10-20 | US | Virginia | Lynchburg | 51680 | 1844 | 24 | 0 | 1820 | 37.40021399 | -79.19888138 | 2020-10-21 04:24:14 | Lynchburg, Virginia, US |
3993721 | 3993721 | 2020-10-20 | US | Texas | Hunt | 48231 | 943 | 43 | 0 | 1820 | 33.12351514 | -96.08551032 | 2020-10-21 04:24:14 | Hunt, Texas, US |
3993077 | 3993077 | 2020-10-20 | US | Ohio | Lake | 39085 | 1883 | 63 | 0 | 1820 | 41.69710807 | -81.23676539 | 2020-10-21 04:24:14 | Lake, Ohio, US |
3992263 | 3992263 | 2020-10-20 | US | Michigan | Monroe | 26115 | 1851 | 31 | 0 | 1820 | 41.92734151 | -83.53749864 | 2020-10-21 04:24:14 | Monroe, Michigan, US |
1797741 | 1797741 | 2020-10-19 | US | Texas | Hunt | 48231 | 939 | 43 | 0 | 1820 | 33.12351514 | -96.08551032 | 2020-10-20 04:24:22 | Hunt, Texas, US |
1794713 | 1794713 | 2020-10-19 | Mexico | Guanajuato | 45163 | 3218 | 40125 | 1820 | 21.019 | -101.2574 | 2020-10-20 04:24:22 | Guanajuato, Mexico | ||
765893 | 765893 | 2020-10-18 | US | Wisconsin | Waupaca | 55135 | 1849 | 29 | 0 | 1820 | 44.47068056 | -88.96534501 | 2020-10-19 04:24:16 | Waupaca, Wisconsin, US |
765424 | 765424 | 2020-10-18 | US | Texas | Hunt | 48231 | 936 | 43 | 0 | 1820 | 33.12351514 | -96.08551032 | 2020-10-19 04:24:16 | Hunt, Texas, US |
1029931 | 1029931 | 2020-10-17 | US | Wisconsin | Waupaca | 55135 | 1849 | 29 | 0 | 1820 | 44.47068056 | -88.96534501 | 2020-10-18 04:24:25 | Waupaca, Wisconsin, US |
1029462 | 1029462 | 2020-10-17 | US | Texas | Hunt | 48231 | 929 | 43 | 0 | 1820 | 33.12351514 | -96.08551032 | 2020-10-18 04:24:25 | Hunt, Texas, US |
2860426 | 2860426 | 2020-10-16 | US | Wisconsin | Waupaca | 55135 | 1849 | 29 | 0 | 1820 | 44.47068056 | -88.96534501 | 2020-10-17 04:24:12 | Waupaca, Wisconsin, US |
1042158 | 1042158 | 2020-10-07 | US | Alabama | Autauga | 1001 | 1847 | 27 | 0 | 1820 | 32.53952745 | -86.64408227 | 2020-10-08 04:23:56 | Autauga, Alabama, US |
3119764 | 3119764 | 2020-10-06 | US | North Carolina | Caldwell | 37027 | 1838 | 18 | 0 | 1820 | 35.95204977 | -81.54799522 | 2020-10-07 04:23:40 | Caldwell, North Carolina, US |
3117857 | 3117857 | 2020-10-06 | US | Alabama | Lauderdale | 1077 | 1857 | 37 | 0 | 1820 | 34.90171875 | -87.65624729 | 2020-10-07 04:23:40 | Lauderdale, Alabama, US |
3804431 | 3804431 | 2020-10-05 | US | Oklahoma | Garfield | 40047 | 1842 | 22 | 0 | 1820 | 36.3791334 | -97.78265517 | 2020-10-06 04:23:33 | Garfield, Oklahoma, US |
3389441 | 3389441 | 2020-10-02 | Korea, South | 24027 | 420 | 21787 | 1820 | 35.90775700000001 | 127.766922 | 2020-10-03 04:23:40 | Korea, South | |||
1048819 | 1048819 | 2020-09-30 | US | Texas | Bastrop | 48021 | 1869 | 30 | 0 | 1820 | 30.10370699 | -97.31206354 | 2020-10-01 04:23:42 | Bastrop, Texas, US |
1518477 | 1518477 | 2020-09-28 | US | Texas | Grayson | 48181 | 1873 | 46 | 0 | 1820 | 33.62744998 | -96.67753461 | 2020-09-29 04:23:42 | Grayson, Texas, US |
1516246 | 1516246 | 2020-09-28 | US | Georgia | Rockdale | 13247 | 1856 | 36 | 0 | 1820 | 33.65145002 | -84.02202167 | 2020-09-29 04:23:42 | Rockdale, Georgia, US |
3316573 | 3316573 | 2020-09-22 | US | Alabama | Cullman | 1043 | 1839 | 19 | 0 | 1820 | 34.13020303 | -86.86888037 | 2020-09-23 04:23:00 | Cullman, Alabama, US |
1125217 | 1125217 | 2020-09-17 | Ukraine | Volyn Oblast | 6593 | 140 | 4633 | 1820 | 50.7472 | 25.3254 | 2020-09-18 05:05:00 | Volyn Oblast, Ukraine | ||
1176535 | 1176535 | 2020-09-10 | US | Virginia | Manassas | 51683 | 1844 | 24 | 0 | 1820 | 38.7464321 | -77.48509905 | 2020-09-11 04:46:23 | Manassas, Virginia, US |
3161578 | 3161578 | 2020-09-06 | India | Manipur | 7022 | 38 | 5164 | 1820 | 24.738975 | 93.882541 | 2020-09-07 04:28:30 | Manipur, India | ||
2665190 | 2665190 | 2020-09-04 | US | Washington | Chelan | 53007 | 1834 | 14 | 0 | 1820 | 47.87046092 | -120.6173956 | 2020-09-05 04:28:19 | Chelan, Washington, US |
1107615 | 1107615 | 2020-09-02 | US | Nebraska | Hall | 31079 | 1866 | 46 | 0 | 1820 | 40.87257079 | -98.50218293 | 2020-09-03 04:28:22 | Hall, Nebraska, US |
1106461 | 1106461 | 2020-09-02 | US | Idaho | Bonneville | 16019 | 1831 | 11 | 0 | 1820 | 43.38713372 | -111.6161537 | 2020-09-03 04:28:22 | Bonneville, 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]);