johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
519 rows where active = 449 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region >30
- US 439
- Russia 11
- Colombia 10
- Japan 8
- Mexico 7
- Chile 5
- Malaysia 5
- Spain 4
- Canada 3
- Sri Lanka 2
- Ukraine 2
- Algeria 1
- Armenia 1
- Austria 1
- Cabo Verde 1
- Cuba 1
- France 1
- Germany 1
- Guinea-Bissau 1
- Guyana 1
- India 1
- Iraq 1
- Lebanon 1
- Liberia 1
- Maldives 1
- Mauritania 1
- Mozambique 1
- San Marino 1
- Sierra Leone 1
- Singapore 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468213 | 3468213 | 2021-08-03 | Japan | Shiga | 6201 | 93 | 5659 | 449 | 35.21582700000001 | 136.138064 | 2021-08-04 04:21:25 | Shiga, Japan | ||
3467954 | 3467954 | 2021-08-03 | Canada | Saskatchewan | 50120 | 578 | 49093 | 449 | 52.9399 | -106.4509 | 2021-08-04 04:21:25 | Saskatchewan, Canada | ||
2371298 | 2371298 | 2021-07-20 | Chile | Coquimbo | 47036 | 897 | 45690 | 449 | -29.959 | -71.3389 | 2021-07-21 04:21:40 | Coquimbo, Chile | ||
295862 | 295862 | 2021-07-15 | Colombia | La Guajira | 40532 | 1276 | 38807 | 449 | 11.3548 | -72.5205 | 2021-07-16 04:21:22 | La Guajira, Colombia | ||
829547 | 829547 | 2021-07-09 | India | Jharkhand | 346223 | 5119 | 340655 | 449 | 23.654536 | 85.557631 | 2021-07-10 04:21:25 | Jharkhand, India | ||
778216 | 778216 | 2021-07-08 | Colombia | Putumayo | 14041 | 575 | 13017 | 449 | 0.436 | -75.5277 | 2021-07-09 04:21:21 | Putumayo, Colombia | ||
1165362 | 1165362 | 2021-07-04 | Russia | Chechen Republic | 13016 | 166 | 12401 | 449 | 43.39761470000001 | 45.6985005 | 2021-07-05 04:21:28 | Chechen Republic, Russia | ||
1164961 | 1164961 | 2021-07-04 | Chile | Nuble | 34238 | 578 | 33211 | 449 | -36.7226 | -71.7622 | 2021-07-05 04:21:28 | Nuble, Chile | ||
403892 | 403892 | 2021-06-29 | Ukraine | Kherson Oblast | 35738 | 1133 | 34156 | 449 | 46.6354 | 32.6169 | 2021-06-30 04:21:41 | Kherson Oblast, Ukraine | ||
400469 | 400469 | 2021-06-29 | Russia | Kalmykia Republic | 21569 | 410 | 20710 | 449 | 46.2313018 | 45.3275745 | 2021-06-30 04:21:41 | Kalmykia Republic, Russia | ||
563156 | 563156 | 2021-06-22 | Russia | Astrakhan Oblast | 35222 | 825 | 33948 | 449 | 47.1878186 | 47.608851 | 2021-06-23 04:21:46 | Astrakhan Oblast, Russia | ||
3033929 | 3033929 | 2021-06-16 | Ukraine | Vinnytsia Oblast | 70914 | 1685 | 68780 | 449 | 49.2331 | 28.4682 | 2021-06-17 04:22:36 | Vinnytsia Oblast, Ukraine | ||
3030363 | 3030363 | 2021-06-16 | Mauritania | 20199 | 479 | 19271 | 449 | 21.0079 | -10.9408 | 2021-06-17 04:22:36 | Mauritania | |||
523134 | 523134 | 2021-06-09 | Singapore | 62223 | 34 | 61740 | 449 | 1.2833 | 103.8333 | 2021-06-10 04:23:17 | Singapore | |||
2390999 | 2390999 | 2021-05-18 | Russia | North Ossetia - Alania Republic | 16896 | 203 | 16244 | 449 | 42.79336110000001 | 44.6324493 | 2021-05-19 04:20:42 | North Ossetia - Alania Republic, Russia | ||
1409088 | 1409088 | 2021-04-23 | Japan | Wakayama | 1979 | 22 | 1508 | 449 | 33.911879 | 135.505446 | 2021-04-24 04:20:38 | Wakayama, Japan | ||
1571780 | 1571780 | 2021-04-22 | Malaysia | Kedah | 9319 | 25 | 8845 | 449 | 6.1184 | 100.3685 | 2021-04-23 04:20:52 | Kedah, Malaysia | ||
3129546 | 3129546 | 2021-04-18 | Japan | Nagano | 3505 | 52 | 3004 | 449 | 36.132134 | 138.045528 | 2021-04-19 04:20:57 | Nagano, Japan | ||
2645951 | 2645951 | 2021-04-08 | Russia | Ivanovo Oblast | 33063 | 1074 | 31540 | 449 | 56.9167446 | 41.43521370000001 | 2021-04-09 04:21:13 | Ivanovo Oblast, Russia | ||
3003311 | 3003311 | 2021-04-06 | Japan | Fukuoka | 19211 | 333 | 18429 | 449 | 33.526032 | 130.666949 | 2021-04-07 04:20:53 | Fukuoka, Japan | ||
1736172 | 1736172 | 2021-03-14 | Malaysia | Negeri Sembilan | 16703 | 30 | 16224 | 449 | 2.7258 | 101.9424 | 2021-03-15 05:25:51 | Negeri Sembilan, Malaysia | ||
3962372 | 3962372 | 2021-03-10 | Colombia | Meta | 42765 | 980 | 41336 | 449 | 3.272 | -73.0877 | 2021-03-11 05:25:48 | Meta, Colombia | ||
58480 | 58480 | 2021-03-07 | Malaysia | Kelantan | 5145 | 21 | 4675 | 449 | 6.1254 | 102.2381 | 2021-03-08 05:24:48 | Kelantan, Malaysia | ||
2367927 | 2367927 | 2021-02-28 | US | Alaska | Southeast Fairbanks | 2240 | 452 | 3 | 0 | 449 | 63.87692095 | -143.2127643 | 2021-03-01 05:23:01 | Southeast Fairbanks, Alaska, US |
3067444 | 3067444 | 2021-02-27 | US | Kentucky | Nicholas | 21181 | 455 | 6 | 0 | 449 | 38.33342292 | -84.01889177 | 2021-02-28 05:22:20 | Nicholas, Kentucky, US |
3066429 | 3066429 | 2021-02-27 | US | Alaska | Southeast Fairbanks | 2240 | 452 | 3 | 0 | 449 | 63.87692095 | -143.2127643 | 2021-02-28 05:22:20 | Southeast Fairbanks, Alaska, US |
3066190 | 3066190 | 2021-02-27 | Russia | Chechen Republic | 11287 | 111 | 10727 | 449 | 43.39761470000001 | 45.6985005 | 2021-02-28 05:22:20 | Chechen Republic, Russia | ||
2184013 | 2184013 | 2021-02-26 | US | Alaska | Southeast Fairbanks | 2240 | 452 | 3 | 0 | 449 | 63.87692095 | -143.2127643 | 2021-02-27 05:22:28 | Southeast Fairbanks, Alaska, US |
472053 | 472053 | 2021-02-19 | US | Colorado | Rio Blanco | 8103 | 481 | 4 | 0 | 449 | 39.97913541 | -108.2179009 | 2021-02-20 05:22:51 | Rio Blanco, Colorado, US |
1153762 | 1153762 | 2021-02-18 | US | Colorado | Rio Blanco | 8103 | 478 | 4 | 0 | 449 | 39.97913541 | -108.2179009 | 2021-02-19 05:24:16 | Rio Blanco, Colorado, US |
2286750 | 2286750 | 2021-02-14 | US | Virginia | Fairfax City | 51600 | 461 | 12 | 0 | 449 | 38.85157547 | -77.29779640000002 | 2021-02-15 05:24:49 | Fairfax City, Virginia, US |
3542661 | 3542661 | 2021-02-12 | US | Texas | Sabine | 48403 | 504 | 37 | 0 | 449 | 31.34318809 | -93.85440451 | 2021-02-13 05:22:12 | Sabine, Texas, US |
2640924 | 2640924 | 2021-02-11 | US | Texas | Sabine | 48403 | 504 | 37 | 0 | 449 | 31.34318809 | -93.85440451 | 2021-02-12 05:23:29 | Sabine, Texas, US |
2639732 | 2639732 | 2021-02-11 | US | Montana | Pondera | 30073 | 452 | 3 | 0 | 449 | 48.22773388 | -112.2252703 | 2021-02-12 05:23:29 | Pondera, Montana, US |
3980965 | 3980965 | 2021-02-10 | US | North Dakota | Eddy | 38027 | 451 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-11 05:23:55 | Eddy, North Dakota, US |
1530285 | 1530285 | 2021-02-09 | US | North Dakota | Eddy | 38027 | 450 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-10 05:22:41 | Eddy, North Dakota, US |
1529989 | 1529989 | 2021-02-09 | US | Nebraska | Morrill | 31123 | 464 | 15 | 0 | 449 | 41.71711774 | -103.0061405 | 2021-02-10 05:22:41 | Morrill, Nebraska, US |
616076 | 616076 | 2021-02-08 | US | North Dakota | Eddy | 38027 | 450 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-09 05:23:30 | Eddy, North Dakota, US |
1589887 | 1589887 | 2021-02-05 | US | Minnesota | Grant | 27051 | 457 | 8 | 0 | 449 | 45.93424769 | -96.01139609 | 2021-02-06 05:23:55 | Grant, Minnesota, US |
792771 | 792771 | 2021-02-04 | US | North Dakota | Eddy | 38027 | 449 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-05 05:22:38 | Eddy, North Dakota, US |
343639 | 343639 | 2021-02-03 | US | Virginia | Mathews | 51115 | 455 | 6 | 0 | 449 | 37.44164146 | -76.34098896 | 2021-02-04 05:22:26 | Mathews, Virginia, US |
342821 | 342821 | 2021-02-03 | US | Oklahoma | Greer | 40055 | 462 | 13 | 0 | 449 | 34.93535801 | -99.5605612 | 2021-02-04 05:22:26 | Greer, Oklahoma, US |
342663 | 342663 | 2021-02-03 | US | North Dakota | Eddy | 38027 | 448 | 6 | 0 | 449 | 47.71701474 | -98.90432337 | 2021-02-04 05:22:26 | Eddy, North Dakota, US |
1688035 | 1688035 | 2021-02-02 | US | Wisconsin | Florence | 55037 | 461 | 12 | 0 | 449 | 45.84963535 | -88.39804137 | 2021-02-03 05:22:52 | Florence, Wisconsin, US |
1685867 | 1685867 | 2021-02-02 | US | Kentucky | Bracken | 21023 | 452 | 3 | 0 | 449 | 38.69158994 | -84.08532444 | 2021-02-03 05:22:52 | Bracken, Kentucky, US |
1678370 | 1678370 | 2021-02-01 | US | Missouri | Hickory | 29085 | 459 | 10 | 0 | 449 | 37.94163617 | -93.3203037 | 2021-02-02 05:22:49 | Hickory, Missouri, US |
1461712 | 1461712 | 2021-01-31 | US | Missouri | Shannon | 29203 | 459 | 10 | 0 | 449 | 37.15772072 | -91.40190382 | 2021-02-01 05:22:53 | Shannon, Missouri, US |
1461658 | 1461658 | 2021-01-31 | US | Missouri | Hickory | 29085 | 459 | 10 | 0 | 449 | 37.94163617 | -93.3203037 | 2021-02-01 05:22:53 | Hickory, Missouri, US |
2214522 | 2214522 | 2021-01-30 | US | South Dakota | Deuel | 46039 | 457 | 8 | 0 | 449 | 44.75994309 | -96.66943645 | 2021-01-31 05:22:42 | Deuel, South Dakota, US |
2213566 | 2213566 | 2021-01-30 | US | Missouri | Hickory | 29085 | 459 | 10 | 0 | 449 | 37.94163617 | -93.3203037 | 2021-01-31 05:22:42 | Hickory, Missouri, US |
2212499 | 2212499 | 2021-01-30 | US | Georgia | Marion | 13197 | 460 | 11 | 0 | 449 | 32.3483402 | -84.52733571 | 2021-01-31 05:22:42 | Marion, Georgia, US |
1900009 | 1900009 | 2021-01-29 | US | South Dakota | Deuel | 46039 | 457 | 8 | 0 | 449 | 44.75994309 | -96.66943645 | 2021-01-30 05:22:49 | Deuel, South Dakota, US |
1899053 | 1899053 | 2021-01-29 | US | Missouri | Hickory | 29085 | 459 | 10 | 0 | 449 | 37.94163617 | -93.3203037 | 2021-01-30 05:22:49 | Hickory, Missouri, US |
2484825 | 2484825 | 2021-01-28 | US | South Dakota | Deuel | 46039 | 457 | 8 | 0 | 449 | 44.75994309 | -96.66943645 | 2021-01-29 05:22:23 | Deuel, South Dakota, US |
2484821 | 2484821 | 2021-01-28 | US | South Dakota | Corson | 46031 | 460 | 11 | 0 | 449 | 45.70889983 | -101.1970473 | 2021-01-29 05:22:23 | Corson, South Dakota, US |
3156460 | 3156460 | 2021-01-27 | US | South Dakota | Deuel | 46039 | 457 | 8 | 0 | 449 | 44.75994309 | -96.66943645 | 2021-01-28 05:22:24 | Deuel, South Dakota, US |
13297 | 13297 | 2021-01-26 | US | Illinois | Calhoun | 17013 | 451 | 2 | 0 | 449 | 39.16840183 | -90.66330078 | 2021-01-27 05:23:41 | Calhoun, Illinois, US |
2568621 | 2568621 | 2021-01-25 | US | Illinois | Calhoun | 17013 | 450 | 1 | 0 | 449 | 39.16840183 | -90.66330078 | 2021-01-26 05:22:02 | Calhoun, Illinois, US |
1760253 | 1760253 | 2021-01-24 | US | Illinois | Calhoun | 17013 | 450 | 1 | 0 | 449 | 39.16840183 | -90.66330078 | 2021-01-25 05:22:16 | Calhoun, Illinois, US |
2427860 | 2427860 | 2021-01-23 | US | Illinois | Calhoun | 17013 | 450 | 1 | 0 | 449 | 39.16840183 | -90.66330078 | 2021-01-24 05:22:35 | Calhoun, Illinois, US |
2466660 | 2466660 | 2021-01-22 | Colombia | Putumayo | 6974 | 270 | 6255 | 449 | 0.436 | -75.5277 | 2021-01-23 05:22:03 | Putumayo, Colombia | ||
436663 | 436663 | 2021-01-21 | US | Kansas | Meade | 20119 | 456 | 7 | 0 | 449 | 37.23859987 | -100.364831 | 2021-01-22 05:22:10 | Meade, Kansas, US |
436342 | 436342 | 2021-01-21 | US | Illinois | Henderson | 17071 | 456 | 7 | 0 | 449 | 40.81908672 | -90.92491462 | 2021-01-22 05:22:10 | Henderson, Illinois, US |
1095394 | 1095394 | 2021-01-20 | US | Kansas | Meade | 20119 | 456 | 7 | 0 | 449 | 37.23859987 | -100.364831 | 2021-01-21 05:22:01 | Meade, Kansas, US |
1095073 | 1095073 | 2021-01-20 | US | Illinois | Henderson | 17071 | 456 | 7 | 0 | 449 | 40.81908672 | -90.92491462 | 2021-01-21 05:22:01 | Henderson, Illinois, US |
911353 | 911353 | 2021-01-19 | US | Texas | Newton | 48351 | 394 | 20 | 0 | 449 | 30.78548982 | -93.74408813 | 2021-01-20 05:21:54 | Newton, Texas, US |
911283 | 911283 | 2021-01-19 | US | Texas | Hemphill | 48211 | 560 | 2 | 0 | 449 | 35.83764858 | -100.2703577 | 2021-01-20 05:21:54 | Hemphill, Texas, US |
909664 | 909664 | 2021-01-19 | US | Louisiana | Cameron | 22023 | 453 | 4 | 0 | 449 | 29.87592238 | -93.19310676 | 2021-01-20 05:21:54 | Cameron, Louisiana, US |
3503639 | 3503639 | 2021-01-17 | South Sudan | 3693 | 63 | 3181 | 449 | 6.877000000000002 | 31.307 | 2021-01-18 05:22:34 | South Sudan | |||
3103750 | 3103750 | 2021-01-16 | US | North Carolina | Gates | 37073 | 461 | 12 | 0 | 449 | 36.44667547 | -76.69749701 | 2021-01-17 05:22:17 | Gates, North Carolina, US |
3517093 | 3517093 | 2021-01-15 | US | Minnesota | Big Stone | 27011 | 452 | 3 | 0 | 449 | 45.42712824 | -96.41403739 | 2021-01-16 05:22:40 | Big Stone, Minnesota, US |
3516339 | 3516339 | 2021-01-15 | US | Idaho | Lincoln | 16063 | 458 | 9 | 0 | 449 | 43.0012336 | -114.1358773 | 2021-01-16 05:22:40 | Lincoln, Idaho, US |
3516048 | 3516048 | 2021-01-15 | US | Colorado | San Miguel | 8113 | 547 | 0 | 0 | 449 | 38.00450883 | -108.4020725 | 2021-01-16 05:22:40 | San Miguel, Colorado, US |
3881610 | 3881610 | 2021-01-14 | US | Nebraska | Boone | 31011 | 453 | 4 | 0 | 449 | 41.70759415 | -98.06737183 | 2021-01-15 05:22:24 | Boone, Nebraska, US |
3880549 | 3880549 | 2021-01-14 | US | Illinois | Edwards | 17047 | 456 | 7 | 0 | 449 | 38.41353228 | -88.05720863 | 2021-01-15 05:22:24 | Edwards, Illinois, US |
3880512 | 3880512 | 2021-01-14 | US | Idaho | Lincoln | 16063 | 458 | 9 | 0 | 449 | 43.0012336 | -114.1358773 | 2021-01-15 05:22:24 | Lincoln, Idaho, US |
3311523 | 3311523 | 2021-01-13 | US | Virginia | Essex | 51057 | 452 | 3 | 0 | 449 | 37.93357639 | -76.94230311 | 2021-01-14 05:22:32 | Essex, Virginia, US |
3309139 | 3309139 | 2021-01-13 | US | Idaho | Lincoln | 16063 | 458 | 9 | 0 | 449 | 43.0012336 | -114.1358773 | 2021-01-14 05:22:32 | Lincoln, Idaho, US |
3308063 | 3308063 | 2021-01-13 | Colombia | Sucre | 18054 | 686 | 16919 | 449 | 8.814 | -74.7233 | 2021-01-14 05:22:32 | Sucre, Colombia | ||
778030 | 778030 | 2021-01-12 | Malaysia | Sarawak | 1574 | 19 | 1106 | 449 | 1.5533 | 110.3592 | 2021-01-13 05:22:15 | Sarawak, Malaysia | ||
775696 | 775696 | 2021-01-12 | US | Kansas | Washington | 20201 | 457 | 8 | 0 | 449 | 39.78420784 | -97.0875323 | 2021-01-13 05:22:15 | Washington, Kansas, US |
774967 | 774967 | 2021-01-12 | US | Colorado | Kit Carson | 8063 | 505 | 10 | 0 | 449 | 39.30497777 | -102.6022199 | 2021-01-13 05:22:15 | Kit Carson, Colorado, US |
774874 | 774874 | 2021-01-12 | US | Arkansas | Woodruff | 5147 | 453 | 4 | 0 | 449 | 35.18902527 | -91.2439489 | 2021-01-13 05:22:15 | Woodruff, Arkansas, US |
193357 | 193357 | 2021-01-11 | US | Virginia | Amelia | 51007 | 456 | 7 | 0 | 449 | 37.34081025 | -77.98584649 | 2021-01-12 05:22:15 | Amelia, Virginia, US |
191417 | 191417 | 2021-01-11 | US | Kansas | Washington | 20201 | 457 | 8 | 0 | 449 | 39.78420784 | -97.0875323 | 2021-01-12 05:22:15 | Washington, Kansas, US |
154009 | 154009 | 2021-01-08 | Japan | Nagasaki | 956 | 7 | 500 | 449 | 33.235712 | 129.608033 | 2021-01-09 05:22:18 | Nagasaki, Japan | ||
154006 | 154006 | 2021-01-08 | Japan | Miyagi | 2488 | 17 | 2022 | 449 | 38.446859 | 140.927086 | 2021-01-09 05:22:18 | Miyagi, Japan | ||
2544695 | 2544695 | 2021-01-07 | US | Virginia | Amelia | 51007 | 456 | 7 | 0 | 449 | 37.34081025 | -77.98584649 | 2021-01-08 05:22:42 | Amelia, Virginia, US |
2865490 | 2865490 | 2021-01-06 | US | Georgia | Crawford | 13079 | 457 | 8 | 0 | 449 | 32.71391813 | -83.98061238 | 2021-01-07 05:22:03 | Crawford, Georgia, US |
3037674 | 3037674 | 2021-01-05 | US | Virginia | Northumberland | 51133 | 459 | 10 | 0 | 449 | 37.89202088 | -76.41949732 | 2021-01-06 05:22:16 | Northumberland, Virginia, US |
3037504 | 3037504 | 2021-01-05 | US | Texas | San Augustine | 48405 | 345 | 24 | 0 | 449 | 31.39457611 | -94.17000399 | 2021-01-06 05:22:16 | San Augustine, Texas, US |
3037497 | 3037497 | 2021-01-05 | US | Texas | Refugio | 48391 | 508 | 17 | 0 | 449 | 28.3238976 | -97.15766311 | 2021-01-06 05:22:16 | Refugio, Texas, US |
3037067 | 3037067 | 2021-01-05 | US | Puerto Rico | Salinas | 72123 | 449 | 0 | 0 | 449 | 18.010386999999994 | -66.256592 | 2021-01-06 05:22:16 | Salinas, Puerto Rico, US |
1065049 | 1065049 | 2021-01-04 | US | Texas | San Augustine | 48405 | 345 | 24 | 0 | 449 | 31.39457611 | -94.17000399 | 2021-01-05 05:21:49 | San Augustine, Texas, US |
3233652 | 3233652 | 2021-01-03 | US | Texas | San Augustine | 48405 | 345 | 24 | 0 | 449 | 31.39457611 | -94.17000399 | 2021-01-04 05:22:02 | San Augustine, Texas, US |
3233171 | 3233171 | 2021-01-03 | US | Puerto Rico | Ciales | 72039 | 449 | 0 | 0 | 449 | 18.28885 | -66.516475 | 2021-01-04 05:22:02 | Ciales, Puerto Rico, US |
2230963 | 2230963 | 2021-01-02 | US | Washington | Pend Oreille | 53051 | 453 | 4 | 0 | 449 | 48.53234021 | -117.2741804 | 2021-01-03 05:22:52 | Pend Oreille, Washington, US |
2230721 | 2230721 | 2021-01-02 | US | Texas | San Augustine | 48405 | 345 | 24 | 0 | 449 | 31.39457611 | -94.17000399 | 2021-01-03 05:22:52 | San Augustine, Texas, US |
2230240 | 2230240 | 2021-01-02 | US | Puerto Rico | Ciales | 72039 | 449 | 0 | 0 | 449 | 18.28885 | -66.516475 | 2021-01-03 05:22:52 | Ciales, Puerto Rico, US |
2229063 | 2229063 | 2021-01-02 | US | Maine | Franklin | 23007 | 454 | 5 | 0 | 449 | 44.97330019 | -70.44381045 | 2021-01-03 05:22:52 | Franklin, Maine, 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]);