johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
127 rows where active = 1802 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 99
- Russia 9
- Central African Republic 5
- Chile 2
- India 2
- Mozambique 2
- Colombia 1
- Malaysia 1
- Mali 1
- Netherlands 1
- Peru 1
- Senegal 1
- Spain 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1378714 | 1378714 | 2021-07-25 | Russia | Kamchatka Krai | 16460 | 238 | 14420 | 1802 | 57.1914882 | 160.03838190000005 | 2021-07-26 04:21:28 | Kamchatka Krai, Russia | ||
2768612 | 2768612 | 2021-07-01 | Malaysia | Perak | 26775 | 130 | 24843 | 1802 | 4.5921 | 101.0901 | 2021-07-02 04:21:47 | Perak, Malaysia | ||
1736297 | 1736297 | 2021-06-12 | Chile | Los Lagos | 81090 | 1108 | 78180 | 1802 | -41.9198 | -72.1416 | 2021-06-13 04:22:44 | Los Lagos, Chile | ||
1188699 | 1188699 | 2021-05-31 | India | Lakshadweep | 8077 | 33 | 6242 | 1802 | 13.6999972 | 72.18333259999999 | 2021-06-01 04:23:09 | Lakshadweep, India | ||
726277 | 726277 | 2021-05-22 | Central African Republic | 7010 | 96 | 5112 | 1802 | 6.6111 | 20.9394 | 2021-05-23 04:20:51 | Central African Republic | |||
1952292 | 1952292 | 2021-05-21 | Central African Republic | 7010 | 96 | 5112 | 1802 | 6.6111 | 20.9394 | 2021-05-22 04:20:45 | Central African Republic | |||
1912991 | 1912991 | 2021-05-20 | Central African Republic | 7010 | 96 | 5112 | 1802 | 6.6111 | 20.9394 | 2021-05-21 04:20:43 | Central African Republic | |||
2255512 | 2255512 | 2021-05-19 | Central African Republic | 7010 | 96 | 5112 | 1802 | 6.6111 | 20.9394 | 2021-05-20 04:21:05 | Central African Republic | |||
2390550 | 2390550 | 2021-05-18 | Central African Republic | 7010 | 96 | 5112 | 1802 | 6.6111 | 20.9394 | 2021-05-19 04:20:42 | Central African Republic | |||
3003520 | 3003520 | 2021-04-06 | Russia | Krasnoyarsk Krai | 67516 | 3223 | 62491 | 1802 | 63.3233807 | 97.0979974 | 2021-04-07 04:20:53 | Krasnoyarsk Krai, Russia | ||
3667874 | 3667874 | 2021-03-06 | Russia | Tver Oblast | 34552 | 651 | 32099 | 1802 | 57.1134475 | 35.174442799999994 | 2021-03-07 05:21:54 | Tver Oblast, Russia | ||
2211286 | 2211286 | 2021-03-04 | Ukraine | Rivne Oblast | 49484 | 631 | 47051 | 1802 | 50.6199 | 26.2516 | 2021-03-05 05:26:29 | Rivne Oblast, Ukraine | ||
2208898 | 2208898 | 2021-03-04 | US | Iowa | Winneshiek | 19191 | 1830 | 28 | 0 | 1802 | 43.29094334 | -91.84422722 | 2021-03-05 05:26:29 | Winneshiek, Iowa, US |
3254601 | 3254601 | 2021-03-02 | US | Arkansas | Ashley | 5003 | 1831 | 29 | 0 | 1802 | 33.19153461 | -91.7698471 | 2021-03-03 05:23:28 | Ashley, Arkansas, US |
999256 | 999256 | 2021-03-01 | US | Georgia | Jefferson | 13163 | 1860 | 58 | 0 | 1802 | 33.05867328 | -82.41609057 | 2021-03-02 05:23:30 | Jefferson, Georgia, US |
2368314 | 2368314 | 2021-02-28 | US | Georgia | Jefferson | 13163 | 1860 | 58 | 0 | 1802 | 33.05867328 | -82.41609057 | 2021-03-01 05:23:01 | Jefferson, Georgia, US |
1939696 | 1939696 | 2021-02-23 | US | Texas | Wilbarger | 48487 | 1907 | 51 | 0 | 1802 | 34.07945812 | -99.24178437 | 2021-02-24 05:29:16 | Wilbarger, Texas, US |
1937619 | 1937619 | 2021-02-23 | US | Iowa | Clay | 19041 | 1827 | 25 | 0 | 1802 | 43.08247182 | -95.15096481 | 2021-02-24 05:29:16 | Clay, Iowa, US |
530967 | 530967 | 2021-02-22 | Russia | Yamalo-Nenets Autonomous Okrug | 36859 | 395 | 34662 | 1802 | 67.1471631 | 74.3415488 | 2021-02-23 05:23:41 | Yamalo-Nenets Autonomous Okrug, Russia | ||
742149 | 742149 | 2021-02-20 | Colombia | Atlantico | 121411 | 3980 | 115629 | 1802 | 10.6966 | -74.8741 | 2021-02-21 05:24:33 | Atlantico, Colombia | ||
2285727 | 2285727 | 2021-02-14 | US | North Carolina | Dare | 37055 | 1810 | 8 | 0 | 1802 | 35.66520691 | -75.71767334 | 2021-02-15 05:24:49 | Dare, North Carolina, US |
2681223 | 2681223 | 2021-02-13 | US | Virginia | Salem | 51775 | 1835 | 33 | 0 | 1802 | 37.2836193 | -80.06219455 | 2021-02-14 05:23:43 | Salem, Virginia, US |
3980703 | 3980703 | 2021-02-10 | US | Nevada | Churchill | 32001 | 1851 | 49 | 0 | 1802 | 39.58105744 | -118.3394607 | 2021-02-11 05:23:55 | Churchill, Nevada, US |
978283 | 978283 | 2021-02-06 | US | Virginia | Mecklenburg | 51117 | 1848 | 46 | 0 | 1802 | 36.67882005 | -78.36131056 | 2021-02-07 05:23:00 | Mecklenburg, Virginia, US |
793771 | 793771 | 2021-02-04 | US | Virginia | Radford | 51750 | 1811 | 9 | 0 | 1802 | 37.12222899 | -80.56027320000003 | 2021-02-05 05:22:38 | Radford, Virginia, US |
790854 | 790854 | 2021-02-04 | US | Arkansas | Cross | 5037 | 1847 | 45 | 0 | 1802 | 35.29631396 | -90.77185818 | 2021-02-05 05:22:38 | Cross, Arkansas, US |
1685102 | 1685102 | 2021-02-02 | US | Colorado | Crowley | 8025 | 1826 | 14 | 0 | 1802 | 38.32608609 | -103.7844965 | 2021-02-03 05:22:52 | Crowley, Colorado, US |
1677072 | 1677072 | 2021-02-01 | US | Colorado | Crowley | 8025 | 1826 | 14 | 0 | 1802 | 38.32608609 | -103.7844965 | 2021-02-02 05:22:49 | Crowley, Colorado, US |
1462366 | 1462366 | 2021-01-31 | US | Oregon | Douglas | 41019 | 1850 | 48 | 0 | 1802 | 43.27941273 | -123.167291 | 2021-02-01 05:22:53 | Douglas, Oregon, US |
2214274 | 2214274 | 2021-01-30 | US | Oregon | Douglas | 41019 | 1850 | 48 | 0 | 1802 | 43.27941273 | -123.167291 | 2021-01-31 05:22:42 | Douglas, Oregon, US |
2212518 | 2212518 | 2021-01-30 | US | Georgia | Pike | 13231 | 1830 | 28 | 0 | 1802 | 33.09310242 | -84.38790389 | 2021-01-31 05:22:42 | Pike, Georgia, US |
2212268 | 2212268 | 2021-01-30 | US | Colorado | Crowley | 8025 | 1825 | 14 | 0 | 1802 | 38.32608609 | -103.7844965 | 2021-01-31 05:22:42 | Crowley, Colorado, US |
2211736 | 2211736 | 2021-01-30 | Mali | 8069 | 330 | 5937 | 1802 | 17.570692 | -3.996166000000001 | 2021-01-31 05:22:42 | Mali | |||
1900567 | 1900567 | 2021-01-29 | US | Virginia | Waynesboro | 51820 | 1825 | 23 | 0 | 1802 | 38.06451466 | -78.90293905 | 2021-01-30 05:22:49 | Waynesboro, Virginia, US |
1900244 | 1900244 | 2021-01-29 | US | Texas | Gray | 48179 | 2475 | 47 | 0 | 1802 | 35.40081878 | -100.8129222 | 2021-01-30 05:22:49 | Gray, Texas, US |
1900061 | 1900061 | 2021-01-29 | US | Tennessee | Bledsoe | 47007 | 1860 | 11 | 0 | 1802 | 35.59942968 | -85.20611967 | 2021-01-30 05:22:49 | Bledsoe, Tennessee, US |
2482444 | 2482444 | 2021-01-28 | US | Arkansas | Drew | 5043 | 1833 | 31 | 0 | 1802 | 33.59035001 | -91.71777921 | 2021-01-29 05:22:23 | Drew, Arkansas, US |
3156907 | 3156907 | 2021-01-27 | US | Virginia | Buckingham | 51029 | 1819 | 17 | 0 | 1802 | 37.57242268 | -78.52518834 | 2021-01-28 05:22:24 | Buckingham, Virginia, US |
3156695 | 3156695 | 2021-01-27 | US | Texas | Gray | 48179 | 2473 | 45 | 0 | 1802 | 35.40081878 | -100.8129222 | 2021-01-28 05:22:24 | Gray, Texas, US |
3155259 | 3155259 | 2021-01-27 | US | Michigan | Menominee | 26109 | 1838 | 36 | 0 | 1802 | 45.58038692 | -87.55370409 | 2021-01-28 05:22:24 | Menominee, Michigan, US |
3153786 | 3153786 | 2021-01-27 | Russia | Adygea Republic | 12844 | 115 | 10927 | 1802 | 44.6939006 | 40.1520421 | 2021-01-28 05:22:24 | Adygea Republic, Russia | ||
15260 | 15260 | 2021-01-26 | US | Tennessee | Crockett | 47033 | 1889 | 39 | 0 | 1802 | 35.81830662 | -89.14916269 | 2021-01-27 05:23:41 | Crockett, Tennessee, US |
2570564 | 2570564 | 2021-01-25 | US | South Dakota | Union | 46127 | 1838 | 36 | 0 | 1802 | 42.83112163 | -96.6557828 | 2021-01-26 05:22:02 | Union, South Dakota, US |
1762196 | 1762196 | 2021-01-24 | US | South Dakota | Union | 46127 | 1838 | 36 | 0 | 1802 | 42.83112163 | -96.6557828 | 2021-01-25 05:22:16 | Union, South Dakota, US |
1094271 | 1094271 | 2021-01-20 | Russia | Amur Oblast | 18346 | 121 | 16423 | 1802 | 52.8032368 | 128.437295 | 2021-01-21 05:22:01 | Amur Oblast, Russia | ||
1093870 | 1093870 | 2021-01-20 | Chile | Antofagasta | 28282 | 605 | 25875 | 1802 | -23.6509 | -70.3975 | 2021-01-21 05:22:01 | Antofagasta, Chile | ||
240546 | 240546 | 2021-01-18 | US | Virginia | Carroll | 51035 | 1846 | 44 | 0 | 1802 | 36.73066666 | -80.73455942 | 2021-01-19 05:22:15 | Carroll, Virginia, US |
3506152 | 3506152 | 2021-01-17 | US | South Carolina | Barnwell | 45011 | 1841 | 39 | 0 | 1802 | 33.26679302 | -81.43584352 | 2021-01-18 05:22:34 | Barnwell, South Carolina, US |
3516210 | 3516210 | 2021-01-15 | US | Georgia | Harris | 13145 | 1835 | 33 | 0 | 1802 | 32.73709786 | -84.90538572 | 2021-01-16 05:22:40 | Harris, Georgia, US |
193156 | 193156 | 2021-01-11 | US | Texas | Gonzales | 48177 | 1853 | 25 | 0 | 1802 | 29.45634206 | -97.49424032 | 2021-01-12 05:22:15 | Gonzales, Texas, US |
157557 | 157557 | 2021-01-08 | US | Wisconsin | Taylor | 55119 | 1821 | 19 | 0 | 1802 | 45.21179252 | -90.5004405 | 2021-01-09 05:22:18 | Taylor, Wisconsin, US |
156426 | 156426 | 2021-01-08 | US | Ohio | Coshocton | 39031 | 1843 | 41 | 0 | 1802 | 40.30096166 | -81.91729018 | 2021-01-09 05:22:18 | Coshocton, Ohio, US |
155191 | 155191 | 2021-01-08 | US | Iowa | Mahaska | 19123 | 1837 | 35 | 0 | 1802 | 41.33521503 | -92.64083907 | 2021-01-09 05:22:18 | Mahaska, Iowa, US |
2544843 | 2544843 | 2021-01-07 | US | Washington | Kittitas | 53037 | 1830 | 28 | 0 | 1802 | 47.12521214 | -120.679439 | 2021-01-08 05:22:42 | Kittitas, Washington, US |
2544498 | 2544498 | 2021-01-07 | US | Texas | Grimes | 48185 | 2497 | 46 | 0 | 1802 | 30.54579585 | -95.98902499 | 2021-01-08 05:22:42 | Grimes, Texas, US |
2866978 | 2866978 | 2021-01-06 | US | New York | Tioga | 36107 | 1856 | 54 | 0 | 1802 | 42.16852837 | -76.30835812 | 2021-01-07 05:22:03 | Tioga, New York, US |
1064795 | 1064795 | 2021-01-04 | US | Tennessee | Johnson | 47091 | 1814 | 28 | 0 | 1802 | 36.45523950000001 | -81.84886538 | 2021-01-05 05:21:49 | Johnson, Tennessee, US |
1063706 | 1063706 | 2021-01-04 | US | Missouri | Audrain | 29007 | 1834 | 32 | 0 | 1802 | 39.215877 | -91.84242683 | 2021-01-05 05:21:49 | Audrain, Missouri, US |
1140282 | 1140282 | 2021-01-01 | US | Virginia | Smyth | 51173 | 1857 | 55 | 0 | 1802 | 36.84455636 | -81.53344948 | 2021-01-02 05:22:33 | Smyth, Virginia, US |
1139468 | 1139468 | 2021-01-01 | US | Oklahoma | Seminole | 40133 | 1820 | 18 | 0 | 1802 | 35.16478725 | -96.61686741 | 2021-01-02 05:22:33 | Seminole, Oklahoma, US |
3698074 | 3698074 | 2020-12-31 | US | Oklahoma | Seminole | 40133 | 1820 | 18 | 0 | 1802 | 35.16478725 | -96.61686741 | 2021-01-01 05:23:07 | Seminole, Oklahoma, US |
769476 | 769476 | 2020-12-29 | US | Texas | Matagorda | 48321 | 1844 | 64 | 0 | 1802 | 28.81955746 | -96.01230294 | 2020-12-30 05:22:34 | Matagorda, Texas, US |
768985 | 768985 | 2020-12-29 | US | Pennsylvania | Jefferson | 42065 | 1842 | 40 | 0 | 1802 | 41.12913106 | -78.9986361 | 2020-12-30 05:22:34 | Jefferson, Pennsylvania, US |
3764740 | 3764740 | 2020-12-28 | US | Texas | Matagorda | 48321 | 1827 | 64 | 0 | 1802 | 28.81955746 | -96.01230294 | 2020-12-29 05:22:37 | Matagorda, Texas, US |
3762412 | 3762412 | 2020-12-28 | US | Georgia | Lumpkin | 13187 | 1824 | 22 | 0 | 1802 | 34.57286511 | -84.00425681 | 2020-12-29 05:22:37 | Lumpkin, Georgia, US |
3779838 | 3779838 | 2020-12-27 | US | Missouri | Perry | 29157 | 1821 | 19 | 0 | 1802 | 37.70660776 | -89.82741088 | 2020-12-28 05:22:06 | Perry, Missouri, US |
3778732 | 3778732 | 2020-12-27 | US | Georgia | Lumpkin | 13187 | 1823 | 21 | 0 | 1802 | 34.57286511 | -84.00425681 | 2020-12-28 05:22:06 | Lumpkin, Georgia, US |
203400 | 203400 | 2020-12-25 | US | Indiana | Wells | 18179 | 1853 | 51 | 0 | 1802 | 40.72934187 | -85.22132966 | 2020-12-26 05:22:28 | Wells, Indiana, US |
202486 | 202486 | 2020-12-25 | Russia | Omsk Oblast | 28623 | 828 | 25993 | 1802 | 56.09352629999999 | 73.5099936 | 2020-12-26 05:22:28 | Omsk Oblast, Russia | ||
3693605 | 3693605 | 2020-12-24 | US | Nevada | Douglas | 32005 | 1817 | 15 | 0 | 1802 | 38.912862 | -119.6171333 | 2020-12-25 05:22:48 | Douglas, Nevada, US |
2120557 | 2120557 | 2020-12-20 | US | Georgia | Oconee | 13219 | 1839 | 37 | 0 | 1802 | 33.83749973 | -83.43679568 | 2020-12-21 05:27:58 | Oconee, Georgia, US |
2129500 | 2129500 | 2020-12-17 | US | Louisiana | Morehouse | 22067 | 1842 | 40 | 0 | 1802 | 32.81686191 | -91.80421614 | 2020-12-18 05:28:18 | Morehouse, Louisiana, US |
3152478 | 3152478 | 2020-12-16 | US | South Dakota | Oglala Lakota | 46102 | 1835 | 33 | 0 | 1802 | 43.33749164 | -102.5555498 | 2020-12-17 05:28:12 | Oglala Lakota, South Dakota, US |
3850592 | 3850592 | 2020-12-13 | US | South Carolina | Dillon | 45033 | 1856 | 54 | 0 | 1802 | 34.39007791 | -79.37741872 | 2020-12-14 05:26:27 | Dillon, South Carolina, US |
3849621 | 3849621 | 2020-12-13 | US | Mississippi | Scott | 28123 | 1833 | 31 | 0 | 1802 | 32.406704100000006 | -89.53789439 | 2020-12-14 05:26:27 | Scott, Mississippi, US |
2350916 | 2350916 | 2020-12-07 | US | West Virginia | Ohio | 54069 | 1822 | 20 | 0 | 1802 | 40.0955451 | -80.62203992 | 2020-12-08 05:27:42 | Ohio, West Virginia, US |
394565 | 394565 | 2020-11-27 | US | North Carolina | McDowell | 37111 | 1836 | 34 | 0 | 1802 | 35.67736232 | -82.0482425 | 2020-11-28 05:25:50 | McDowell, North Carolina, US |
392797 | 392797 | 2020-11-27 | US | California | San Benito | 6069 | 1816 | 15 | 0 | 1802 | 36.60308176 | -121.069975 | 2020-11-28 05:25:50 | San Benito, California, US |
1975319 | 1975319 | 2020-11-25 | US | Puerto Rico | Guaynabo | 72061 | 1802 | 0 | 0 | 1802 | 18.345114 | -66.11452299999999 | 2020-11-26 05:27:44 | Guaynabo, Puerto Rico, US |
1353312 | 1353312 | 2020-11-24 | US | Tennessee | Wayne | 47181 | 1832 | 10 | 0 | 1802 | 35.23868267 | -87.78644456 | 2020-11-25 05:27:20 | Wayne, Tennessee, US |
1351249 | 1351249 | 2020-11-24 | US | Idaho | Jerome | 16053 | 1814 | 12 | 0 | 1802 | 42.68891267 | -114.2655033 | 2020-11-25 05:27:20 | Jerome, Idaho, US |
1350904 | 1350904 | 2020-11-24 | US | California | Yuba | 6115 | 1811 | 10 | 0 | 1802 | 39.26255932 | -121.3535644 | 2020-11-25 05:27:20 | Yuba, California, US |
3338704 | 3338704 | 2020-11-17 | Mozambique | 14566 | 118 | 12646 | 1802 | -18.665695 | 35.529562 | 2020-11-18 05:40:31 | Mozambique | |||
2881477 | 2881477 | 2020-11-15 | US | Kansas | Ellis | 20051 | 1820 | 18 | 0 | 1802 | 38.91458712 | -99.31751551 | 2020-11-16 05:25:57 | Ellis, Kansas, US |
2916455 | 2916455 | 2020-11-14 | US | Kansas | Ellis | 20051 | 1820 | 18 | 0 | 1802 | 38.91458712 | -99.31751551 | 2020-11-15 05:26:53 | Ellis, Kansas, US |
2786277 | 2786277 | 2020-11-13 | US | Kansas | Ellis | 20051 | 1820 | 18 | 0 | 1802 | 38.91458712 | -99.31751551 | 2020-11-14 05:25:37 | Ellis, Kansas, US |
894967 | 894967 | 2020-11-05 | US | South Dakota | Codington | 46029 | 1818 | 16 | 0 | 1802 | 44.97788119 | -97.18827677 | 2020-11-06 05:24:55 | Codington, South Dakota, US |
2919850 | 2919850 | 2020-11-04 | US | Florida | Baker | 12003 | 1826 | 24 | 0 | 1802 | 30.33060121 | -82.28467476 | 2020-11-05 06:05:03 | Baker, Florida, US |
2501616 | 2501616 | 2020-11-03 | US | Wyoming | Natrona | 56025 | 1813 | 11 | 0 | 1802 | 42.96180148 | -106.797885 | 2020-11-04 05:25:09 | Natrona, Wyoming, US |
2499839 | 2499839 | 2020-11-03 | US | Mississippi | Neshoba | 28099 | 1913 | 111 | 0 | 1802 | 32.75339664 | -89.11726492 | 2020-11-04 05:25:09 | Neshoba, Mississippi, US |
3304451 | 3304451 | 2020-11-02 | Russia | Vologda Oblast | 7224 | 73 | 5349 | 1802 | 60.0391461 | 43.1215213 | 2020-11-03 06:00:16 | Vologda Oblast, Russia | ||
2083527 | 2083527 | 2020-10-31 | US | Wyoming | Laramie | 56021 | 1808 | 6 | 0 | 1802 | 41.30702520000001 | -104.6887497 | 2020-11-01 04:36:19 | Laramie, Wyoming, US |
1455595 | 1455595 | 2020-10-27 | US | Texas | Bee | 48025 | 2417 | 39 | 0 | 1802 | 28.41761668 | -97.74215593 | 2020-10-28 04:24:39 | Bee, Texas, US |
1056171 | 1056171 | 2020-10-23 | US | North Carolina | Rockingham | 37157 | 1821 | 19 | 0 | 1802 | 36.39593137 | -79.77504841 | 2020-10-24 04:24:46 | Rockingham, North Carolina, US |
2291801 | 2291801 | 2020-10-12 | US | Alabama | Dallas | 1047 | 1828 | 26 | 0 | 1802 | 32.32688101 | -87.10866709999998 | 2020-10-13 04:24:02 | Dallas, Alabama, US |
2602901 | 2602901 | 2020-10-10 | US | Georgia | Tift | 13277 | 1861 | 59 | 0 | 1802 | 31.45743864 | -83.5236119 | 2020-10-11 04:23:46 | Tift, Georgia, US |
1825792 | 1825792 | 2020-10-04 | US | Texas | Bee | 48025 | 2328 | 36 | 0 | 1802 | 28.41761668 | -97.74215593 | 2020-10-05 04:23:33 | Bee, Texas, US |
1825321 | 1825321 | 2020-10-04 | US | Oklahoma | Garfield | 40047 | 1824 | 22 | 0 | 1802 | 36.3791334 | -97.78265517 | 2020-10-05 04:23:33 | Garfield, Oklahoma, US |
2516705 | 2516705 | 2020-10-03 | US | Oklahoma | Garfield | 40047 | 1824 | 22 | 0 | 1802 | 36.3791334 | -97.78265517 | 2020-10-04 04:23:44 | Garfield, Oklahoma, US |
2514534 | 2514534 | 2020-10-03 | US | Alabama | Franklin | 1059 | 1832 | 30 | 0 | 1802 | 34.44235334 | -87.84289505 | 2020-10-04 04:23:44 | Franklin, Alabama, 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]);