johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
109 rows where active = 1797 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 83
- Russia 14
- Colombia 3
- India 3
- Ukraine 2
- Afghanistan 1
- Burkina Faso 1
- Germany 1
- Spain 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3907612 | 3907612 | 2021-07-31 | Ukraine | Sevastopol* | 20801 | 852 | 18152 | 1797 | 44.6054 | 33.522 | 2021-08-01 04:21:50 | Sevastopol*, Ukraine | ||
3296379 | 3296379 | 2021-07-30 | Russia | Ivanovo Oblast | 41276 | 1386 | 38093 | 1797 | 56.9167446 | 41.43521370000001 | 2021-07-31 04:21:35 | Ivanovo Oblast, Russia | ||
3218159 | 3218159 | 2021-07-26 | Colombia | Tolima | 103877 | 3397 | 98683 | 1797 | 4.0925 | -75.1545 | 2021-07-27 04:21:18 | Tolima, Colombia | ||
2422834 | 2422834 | 2021-06-23 | India | Delhi | 1433366 | 24940 | 1406629 | 1797 | 28.646519 | 77.10898 | 2021-06-24 04:21:55 | Delhi, India | ||
1872799 | 1872799 | 2021-05-15 | Colombia | Cesar | 60656 | 1620 | 57239 | 1797 | 9.3373 | -73.6536 | 2021-05-16 04:20:49 | Cesar, Colombia | ||
3085522 | 3085522 | 2021-04-05 | Russia | Mordovia Republic | 19235 | 211 | 17227 | 1797 | 54.4419829 | 44.4661144 | 2021-04-06 04:20:32 | Mordovia Republic, Russia | ||
3710361 | 3710361 | 2021-04-03 | Russia | Mordovia Republic | 19162 | 208 | 17157 | 1797 | 54.4419829 | 44.4661144 | 2021-04-04 04:20:49 | Mordovia Republic, Russia | ||
241477 | 241477 | 2021-04-02 | Russia | Mordovia Republic | 19125 | 207 | 17121 | 1797 | 54.4419829 | 44.4661144 | 2021-04-03 04:20:44 | Mordovia Republic, Russia | ||
2209066 | 2209066 | 2021-03-04 | US | Kentucky | Johnson | 21115 | 1815 | 18 | 0 | 1797 | 37.85106355 | -82.8264322 | 2021-03-05 05:26:29 | Johnson, Kentucky, US |
1093707 | 1093707 | 2021-03-03 | Ukraine | Rivne Oblast | 49282 | 628 | 46857 | 1797 | 50.6199 | 26.2516 | 2021-03-04 05:24:24 | Rivne Oblast, Ukraine | ||
1001498 | 1001498 | 2021-03-01 | US | Texas | DeWitt | 48123 | 3904 | 57 | 0 | 1797 | 29.08101855 | -97.3568117 | 2021-03-02 05:23:30 | DeWitt, Texas, US |
999843 | 999843 | 2021-03-01 | US | Kentucky | Hart | 21099 | 1830 | 33 | 0 | 1797 | 37.29943898 | -85.88461055 | 2021-03-02 05:23:30 | Hart, Kentucky, US |
998893 | 998893 | 2021-03-01 | US | Arkansas | Ashley | 5003 | 1826 | 29 | 0 | 1797 | 33.19153461 | -91.7698471 | 2021-03-02 05:23:30 | Ashley, Arkansas, US |
2370556 | 2370556 | 2021-02-28 | US | Texas | DeWitt | 48123 | 3904 | 57 | 0 | 1797 | 29.08101855 | -97.3568117 | 2021-03-01 05:23:01 | DeWitt, Texas, US |
532984 | 532984 | 2021-02-22 | US | North Carolina | Ashe | 37009 | 1837 | 40 | 0 | 1797 | 36.43296207 | -81.49862729 | 2021-02-23 05:23:41 | Ashe, North Carolina, US |
531215 | 531215 | 2021-02-22 | US | Arkansas | Polk | 5113 | 1859 | 62 | 0 | 1797 | 34.48254879 | -94.22728802 | 2021-02-23 05:23:41 | Polk, Arkansas, US |
531170 | 531170 | 2021-02-22 | US | Arkansas | Cleburne | 5023 | 1864 | 67 | 0 | 1797 | 35.53864922 | -92.02640019 | 2021-02-23 05:23:41 | Cleburne, Arkansas, US |
182504 | 182504 | 2021-02-21 | US | Arkansas | Cleburne | 5023 | 1864 | 67 | 0 | 1797 | 35.53864922 | -92.02640019 | 2021-02-22 05:24:21 | Cleburne, Arkansas, US |
472541 | 472541 | 2021-02-19 | US | Indiana | Starke | 18149 | 1847 | 50 | 0 | 1797 | 41.27890281 | -86.64686895 | 2021-02-20 05:22:51 | Starke, Indiana, US |
1153811 | 1153811 | 2021-02-18 | US | Florida | Gulf | 12045 | 1832 | 35 | 0 | 1797 | 29.93543004 | -85.24270990000002 | 2021-02-19 05:24:16 | Gulf, Florida, US |
1530023 | 1530023 | 2021-02-09 | US | Nevada | Churchill | 32001 | 1846 | 49 | 0 | 1797 | 39.58105744 | -118.3394607 | 2021-02-10 05:22:41 | Churchill, Nevada, US |
1527864 | 1527864 | 2021-02-09 | India | Telangana | 295988 | 1613 | 292578 | 1797 | 18.1124 | 79.0193 | 2021-02-10 05:22:41 | Telangana, India | ||
615814 | 615814 | 2021-02-08 | US | Nevada | Churchill | 32001 | 1846 | 49 | 0 | 1797 | 39.58105744 | -118.3394607 | 2021-02-09 05:23:30 | Churchill, Nevada, US |
343695 | 343695 | 2021-02-03 | US | Washington | Adams | 53001 | 1817 | 20 | 0 | 1797 | 46.98299757 | -118.5601734 | 2021-02-04 05:22:26 | Adams, Washington, US |
1676984 | 1676984 | 2021-02-01 | US | Arkansas | Randolph | 5121 | 1843 | 46 | 0 | 1797 | 36.3415714 | -91.02455531 | 2021-02-02 05:22:49 | Randolph, Arkansas, US |
1676661 | 1676661 | 2021-02-01 | Russia | Buryatia Republic | 30569 | 669 | 28103 | 1797 | 52.7182426 | 109.492143 | 2021-02-02 05:22:49 | Buryatia Republic, Russia | ||
1460466 | 1460466 | 2021-01-31 | US | Florida | Madison | 12079 | 1834 | 37 | 0 | 1797 | 30.44396917 | -83.47398594 | 2021-02-01 05:22:53 | Madison, Florida, US |
2212129 | 2212129 | 2021-01-30 | US | Arkansas | Clark | 5019 | 1831 | 34 | 0 | 1797 | 34.04613432 | -93.17484713 | 2021-01-31 05:22:42 | Clark, Arkansas, US |
2570917 | 2570917 | 2021-01-25 | US | Texas | Young | 48503 | 1816 | 34 | 0 | 1797 | 33.17659707 | -98.68790885 | 2021-01-26 05:22:02 | Young, Texas, US |
1762549 | 1762549 | 2021-01-24 | US | Texas | Young | 48503 | 1816 | 34 | 0 | 1797 | 33.17659707 | -98.68790885 | 2021-01-25 05:22:16 | Young, Texas, US |
2430156 | 2430156 | 2021-01-23 | US | Texas | Young | 48503 | 1816 | 34 | 0 | 1797 | 33.17659707 | -98.68790885 | 2021-01-24 05:22:35 | Young, Texas, US |
2429803 | 2429803 | 2021-01-23 | US | South Dakota | Union | 46127 | 1833 | 36 | 0 | 1797 | 42.83112163 | -96.6557828 | 2021-01-24 05:22:35 | Union, South Dakota, US |
2467035 | 2467035 | 2021-01-22 | Russia | Novosibirsk Oblast | 31034 | 1148 | 28089 | 1797 | 54.9720169 | 79.48139240000002 | 2021-01-23 05:22:03 | Novosibirsk Oblast, Russia | ||
436499 | 436499 | 2021-01-21 | US | Indiana | Washington | 18175 | 1820 | 23 | 0 | 1797 | 38.60219804 | -86.1049363 | 2021-01-22 05:22:10 | Washington, Indiana, US |
3101199 | 3101199 | 2021-01-16 | Burkina Faso | 9000 | 101 | 7102 | 1797 | 12.2383 | -1.5616 | 2021-01-17 05:22:17 | Burkina Faso | |||
3519011 | 3519011 | 2021-01-15 | US | Wyoming | Uinta | 56041 | 1806 | 9 | 0 | 1797 | 41.2878183 | -110.54757820000002 | 2021-01-16 05:22:40 | Uinta, Wyoming, US |
3881801 | 3881801 | 2021-01-14 | US | New York | Fulton | 36035 | 1844 | 47 | 0 | 1797 | 43.11363907 | -74.41798804 | 2021-01-15 05:22:24 | Fulton, New York, US |
3879823 | 3879823 | 2021-01-14 | Russia | Tambov Oblast | 19885 | 220 | 17868 | 1797 | 52.9019574 | 41.3578918 | 2021-01-15 05:22:24 | Tambov Oblast, Russia | ||
2628959 | 2628959 | 2021-01-10 | US | Texas | Gonzales | 48177 | 1848 | 25 | 0 | 1797 | 29.45634206 | -97.49424032 | 2021-01-11 05:21:50 | Gonzales, Texas, US |
3903047 | 3903047 | 2021-01-09 | US | Texas | Gonzales | 48177 | 1848 | 25 | 0 | 1797 | 29.45634206 | -97.49424032 | 2021-01-10 05:22:12 | Gonzales, Texas, US |
3901388 | 3901388 | 2021-01-09 | US | Kentucky | Marshall | 21157 | 1822 | 25 | 0 | 1797 | 36.88007070000001 | -88.32803576 | 2021-01-10 05:22:12 | Marshall, Kentucky, US |
2866683 | 2866683 | 2021-01-06 | US | Missouri | Washington | 29221 | 1838 | 41 | 0 | 1797 | 37.96130078 | -90.87948158 | 2021-01-07 05:22:03 | Washington, Missouri, US |
2865412 | 2865412 | 2021-01-06 | US | Florida | Holmes | 12059 | 1826 | 29 | 0 | 1797 | 30.86747479 | -85.81319222 | 2021-01-07 05:22:03 | Holmes, Florida, US |
3037075 | 3037075 | 2021-01-05 | US | Puerto Rico | Trujillo Alto | 72139 | 1797 | 0 | 0 | 1797 | 18.336159 | -65.99888399999999 | 2021-01-06 05:22:16 | Trujillo Alto, Puerto Rico, US |
1063379 | 1063379 | 2021-01-04 | US | Louisiana | Union | 22111 | 1863 | 66 | 0 | 1797 | 32.83121059 | -92.3749373 | 2021-01-05 05:21:49 | Union, Louisiana, US |
1010792 | 1010792 | 2020-12-30 | US | Arkansas | Johnson | 5071 | 1817 | 20 | 0 | 1797 | 35.56759135 | -93.46036368 | 2020-12-31 05:22:49 | Johnson, Arkansas, US |
1010552 | 1010552 | 2020-12-30 | Russia | Tambov Oblast | 17493 | 183 | 15513 | 1797 | 52.9019574 | 41.3578918 | 2020-12-31 05:22:49 | Tambov Oblast, Russia | ||
769667 | 769667 | 2020-12-29 | US | Virginia | James City | 51095 | 1825 | 28 | 0 | 1797 | 37.31156958 | -76.76950618 | 2020-12-30 05:22:34 | James City, Virginia, US |
3778166 | 3778166 | 2020-12-27 | Russia | Zabaykalsky Krai | 26258 | 374 | 24087 | 1797 | 52.248521 | 115.956325 | 2020-12-28 05:22:06 | Zabaykalsky Krai, Russia | ||
2223739 | 2223739 | 2020-12-26 | Russia | Omsk Oblast | 28866 | 834 | 26235 | 1797 | 56.09352629999999 | 73.5099936 | 2020-12-27 05:22:55 | Omsk Oblast, Russia | ||
205738 | 205738 | 2020-12-25 | US | West Virginia | Marshall | 54051 | 1848 | 51 | 0 | 1797 | 39.86064362 | -80.66591062 | 2020-12-26 05:22:28 | Marshall, West Virginia, US |
2408642 | 2408642 | 2020-12-23 | US | Mississippi | Leake | 28079 | 1846 | 49 | 0 | 1797 | 32.7536828 | -89.52402044 | 2020-12-24 05:23:04 | Leake, Mississippi, US |
3770868 | 3770868 | 2020-12-22 | US | Illinois | Jersey | 17083 | 1823 | 26 | 0 | 1797 | 39.08869046 | -90.35393073 | 2020-12-23 05:22:03 | Jersey, Illinois, US |
2120443 | 2120443 | 2020-12-20 | US | Florida | Taylor | 12123 | 1822 | 25 | 0 | 1797 | 30.04848048 | -83.60445406 | 2020-12-21 05:27:58 | Taylor, Florida, US |
2934768 | 2934768 | 2020-12-19 | US | Wisconsin | Langlade | 55067 | 1837 | 40 | 0 | 1797 | 45.26271619 | -89.07483625 | 2020-12-20 05:27:32 | Langlade, Wisconsin, US |
1903393 | 1903393 | 2020-12-18 | US | New York | Genesee | 36037 | 1823 | 26 | 0 | 1797 | 43.0022601 | -78.19135193 | 2020-12-19 05:27:52 | Genesee, New York, US |
1036888 | 1036888 | 2020-12-15 | US | Ohio | Williams | 39171 | 1829 | 32 | 0 | 1797 | 41.56052014 | -84.58429552 | 2020-12-16 05:28:04 | Williams, Ohio, US |
1754101 | 1754101 | 2020-12-14 | US | South Carolina | Williamsburg | 45089 | 1851 | 54 | 0 | 1797 | 33.62190129 | -79.72767442 | 2020-12-15 05:26:38 | Williamsburg, South Carolina, US |
860857 | 860857 | 2020-12-11 | Russia | Adygea Republic | 9133 | 71 | 7265 | 1797 | 44.6939006 | 40.1520421 | 2020-12-12 05:26:19 | Adygea Republic, Russia | ||
1634771 | 1634771 | 2020-12-05 | US | Ohio | Jefferson | 39081 | 1838 | 41 | 0 | 1797 | 40.38614126 | -80.76259514 | 2020-12-06 05:26:18 | Jefferson, Ohio, US |
3863034 | 3863034 | 2020-12-04 | US | Texas | San Patricio | 48409 | 2146 | 86 | 0 | 1797 | 28.00880118 | -97.51763891 | 2020-12-05 05:27:36 | San Patricio, Texas, US |
924437 | 924437 | 2020-11-26 | US | Georgia | Camden | 13039 | 1817 | 20 | 0 | 1797 | 30.92951916 | -81.66601818 | 2020-11-27 05:26:53 | Camden, Georgia, US |
3837354 | 3837354 | 2020-11-21 | US | Georgia | Thomas | 13275 | 1878 | 81 | 0 | 1797 | 30.86392347 | -83.91847289 | 2020-11-22 05:25:45 | Thomas, Georgia, US |
2704956 | 2704956 | 2020-11-20 | US | Washington | Skagit | 53057 | 1822 | 25 | 0 | 1797 | 48.48171488 | -121.766131 | 2020-11-21 05:25:51 | Skagit, Washington, US |
2704776 | 2704776 | 2020-11-20 | US | Utah | Wasatch | 49051 | 1808 | 11 | 0 | 1797 | 40.33110236 | -111.1691419 | 2020-11-21 05:25:51 | Wasatch, Utah, US |
125029 | 125029 | 2020-11-18 | US | North Carolina | Lenoir | 37107 | 1843 | 46 | 0 | 1797 | 35.24032589999999 | -77.64245615 | 2020-11-19 05:25:23 | Lenoir, North Carolina, US |
1988812 | 1988812 | 2020-11-09 | Russia | Altai Krai | 21265 | 384 | 19084 | 1797 | 52.6932243 | 82.69314240000001 | 2020-11-10 05:40:07 | Altai Krai, Russia | ||
1547205 | 1547205 | 2020-11-07 | US | Utah | Tooele | 49045 | 1804 | 7 | 0 | 1797 | 40.44862644 | -113.1295715 | 2020-11-08 05:24:56 | Tooele, Utah, US |
893282 | 893282 | 2020-11-05 | US | Iowa | Cerro Gordo | 19033 | 1826 | 29 | 0 | 1797 | 43.08177563 | -93.2612239 | 2020-11-06 05:24:55 | Cerro Gordo, Iowa, US |
3306291 | 3306291 | 2020-11-02 | US | Nebraska | Platte | 31141 | 1804 | 7 | 0 | 1797 | 41.57246836 | -97.52144359 | 2020-11-03 06:00:16 | Platte, Nebraska, US |
3411689 | 3411689 | 2020-11-01 | US | New York | Putnam | 36079 | 1861 | 64 | 0 | 1797 | 41.42630093 | -73.74965532 | 2020-11-02 05:25:04 | Putnam, New York, US |
756887 | 756887 | 2020-10-28 | US | Oklahoma | Texas | 40139 | 1807 | 10 | 0 | 1797 | 36.74777635 | -101.4889765 | 2020-10-29 04:24:49 | Texas, Oklahoma, US |
3651413 | 3651413 | 2020-10-24 | Colombia | Cesar | 24452 | 764 | 21891 | 1797 | 9.3373 | -73.6536 | 2020-10-25 04:24:36 | Cesar, Colombia | ||
3993618 | 3993618 | 2020-10-20 | US | Texas | Bee | 48025 | 2382 | 39 | 0 | 1797 | 28.41761668 | -97.74215593 | 2020-10-21 04:24:14 | Bee, Texas, US |
3990955 | 3990955 | 2020-10-20 | US | Alabama | Chilton | 1021 | 1828 | 31 | 0 | 1797 | 32.85044126 | -86.7173256 | 2020-10-21 04:24:14 | Chilton, Alabama, US |
1028772 | 1028772 | 2020-10-17 | US | North Dakota | Ward | 38101 | 1895 | 24 | 0 | 1797 | 48.22390169 | -101.5436763 | 2020-10-18 04:24:25 | Ward, North Dakota, US |
2857311 | 2857311 | 2020-10-16 | US | Arkansas | Crawford | 5033 | 1821 | 24 | 0 | 1797 | 35.58928601 | -94.2446814 | 2020-10-17 04:24:12 | Crawford, Arkansas, US |
787194 | 787194 | 2020-10-15 | US | Georgia | Laurens | 13175 | 1879 | 82 | 0 | 1797 | 32.46325233 | -82.92221316 | 2020-10-16 04:24:01 | Laurens, Georgia, US |
81011 | 81011 | 2020-10-14 | US | Missouri | Newton | 29145 | 1813 | 16 | 0 | 1797 | 36.90519407 | -94.3394104 | 2020-10-15 04:24:28 | Newton, Missouri, US |
79007 | 79007 | 2020-10-14 | Germany | Sachsen | 8742 | 250 | 7073 | 1797 | 51.1045 | 13.2017 | 2020-10-15 04:24:28 | Sachsen, Germany | ||
3786246 | 3786246 | 2020-10-11 | US | Alabama | Colbert | 1033 | 1824 | 27 | 0 | 1797 | 34.69847452 | -87.80168544 | 2020-10-12 04:23:45 | Colbert, Alabama, US |
1824605 | 1824605 | 2020-10-04 | US | Mississippi | Oktibbeha | 28105 | 1850 | 53 | 0 | 1797 | 33.42491685 | -88.87905132 | 2020-10-05 04:23:33 | Oktibbeha, Mississippi, US |
1823178 | 1823178 | 2020-10-04 | US | Alabama | Russell | 1113 | 1800 | 3 | 0 | 1797 | 32.28725256 | -85.18415324 | 2020-10-05 04:23:33 | Russell, Alabama, US |
1823121 | 1823121 | 2020-10-04 | US | Alabama | Autauga | 1001 | 1824 | 27 | 0 | 1797 | 32.53952745 | -86.64408227 | 2020-10-05 04:23:33 | Autauga, Alabama, US |
2606878 | 2606878 | 2020-09-24 | US | Georgia | Rockdale | 13247 | 1833 | 36 | 0 | 1797 | 33.65145002 | -84.02202167 | 2020-09-25 04:23:00 | Rockdale, Georgia, US |
347813 | 347813 | 2020-09-14 | US | Wisconsin | La Crosse | 55063 | 1799 | 2 | 0 | 1797 | 43.90632465 | -91.11451093 | 2020-09-15 03:22:50 | La Crosse, Wisconsin, US |
2173983 | 2173983 | 2020-09-09 | US | Ohio | Columbiana | 39029 | 1878 | 81 | 0 | 1797 | 40.76932373 | -80.78094576 | 2020-09-10 04:29:01 | Columbiana, Ohio, US |
1246200 | 1246200 | 2020-09-08 | US | Ohio | Fairfield | 39045 | 1837 | 40 | 0 | 1797 | 39.75107189 | -82.63088163 | 2020-09-09 04:28:48 | Fairfield, Ohio, US |
3934088 | 3934088 | 2020-08-30 | US | Nebraska | Hall | 31079 | 1843 | 46 | 0 | 1797 | 40.87257079 | -98.50218293 | 2020-08-31 04:28:27 | Hall, Nebraska, US |
1999013 | 1999013 | 2020-08-26 | US | North Dakota | Burleigh | 38015 | 1852 | 13 | 0 | 1797 | 46.97847375 | -100.4645214 | 2020-08-27 04:28:15 | Burleigh, North Dakota, US |
3565155 | 3565155 | 2020-08-25 | US | Oregon | Clackamas | 41005 | 1852 | 55 | 0 | 1797 | 45.18787398 | -122.2179634 | 2020-08-26 04:28:11 | Clackamas, Oregon, US |
3485455 | 3485455 | 2020-08-20 | US | Iowa | Buena Vista | 19021 | 1809 | 12 | 0 | 1797 | 42.73545875 | -95.15100162 | 2020-08-21 04:27:41 | Buena Vista, Iowa, US |
3532504 | 3532504 | 2020-08-12 | US | Indiana | Cass | 18017 | 1806 | 9 | 0 | 1797 | 40.76135835 | -86.34830753 | 2020-08-13 04:29:15 | Cass, Indiana, US |
3790910 | 3790910 | 2020-08-05 | US | Georgia | Houston | 13153 | 1847 | 50 | 0 | 1797 | 32.45802497 | -83.66879087 | 2020-08-06 04:35:02 | Houston, Georgia, US |
2805960 | 2805960 | 2020-08-02 | US | Texas | Kaufman | 48257 | 1627 | 19 | 0 | 1797 | 32.599141700000004 | -96.28734728 | 2020-08-03 04:34:35 | Kaufman, Texas, US |
751528 | 751528 | 2020-08-01 | US | Texas | Kaufman | 48257 | 1606 | 19 | 0 | 1797 | 32.599141700000004 | -96.28734728 | 2020-08-02 04:34:47 | Kaufman, Texas, US |
3261450 | 3261450 | 2020-07-31 | US | Colorado | Boulder | 8013 | 2054 | 69 | 0 | 1797 | 40.09313619 | -105.3546767 | 2020-08-01 04:36:27 | Boulder, Colorado, US |
1501802 | 1501802 | 2020-07-25 | US | North Carolina | Rowan | 37159 | 1842 | 45 | 0 | 1797 | 35.64003916 | -80.52446628 | 2020-07-26 04:35:00 | Rowan, North Carolina, US |
2707997 | 2707997 | 2020-07-17 | US | Georgia | Troup | 13285 | 1841 | 44 | 0 | 1797 | 33.03349196 | -85.02812115 | 2020-07-18 04:34:45 | Troup, Georgia, US |
2748032 | 2748032 | 2020-07-15 | India | Jharkhand | 4320 | 38 | 2485 | 1797 | 23.654536 | 85.557631 | 2020-07-16 04:44:59 | Jharkhand, India |
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]);