johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
428 rows where active = 477 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 357
- Russia 16
- Colombia 9
- Japan 5
- Germany 3
- Mexico 3
- Pakistan 3
- Sweden 3
- Brazil 2
- Chile 2
- Guinea-Bissau 2
- Kosovo 2
- Malaysia 2
- Mali 2
- Cambodia 1
- Chad 1
- Congo (Kinshasa) 1
- Cuba 1
- Eritrea 1
- Georgia 1
- India 1
- Italy 1
- Niger 1
- Norway 1
- San Marino 1
- Sao Tome and Principe 1
- Sri Lanka 1
- Syria 1
- Trinidad and Tobago 1
- Ukraine 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2673653 | 2673653 | 2021-07-18 | Colombia | Caqueta | 21474 | 833 | 20164 | 477 | 0.8699 | -73.8419 | 2021-07-19 04:21:24 | Caqueta, Colombia | ||
299636 | 299636 | 2021-07-15 | Ukraine | Dnipropetrovsk Oblast | 135961 | 4466 | 131018 | 477 | 48.4647 | 35.0462 | 2021-07-16 04:21:22 | Dnipropetrovsk Oblast, Ukraine | ||
625884 | 625884 | 2021-07-10 | Japan | Fukuoka | 35895 | 525 | 34893 | 477 | 33.526032 | 130.666949 | 2021-07-11 04:21:43 | Fukuoka, Japan | ||
2590233 | 2590233 | 2021-06-27 | Russia | North Ossetia - Alania Republic | 17264 | 231 | 16556 | 477 | 42.79336110000001 | 44.6324493 | 2021-06-28 04:21:29 | North Ossetia - Alania Republic, Russia | ||
1712211 | 1712211 | 2021-06-25 | Eritrea | 5720 | 21 | 5222 | 477 | 15.1794 | 39.7823 | 2021-06-26 04:21:43 | Eritrea | |||
3970802 | 3970802 | 2021-06-11 | Russia | Tula Oblast | 40730 | 2097 | 38156 | 477 | 53.9570701 | 37.3690909 | 2021-06-12 04:22:22 | Tula Oblast, Russia | ||
3970755 | 3970755 | 2021-06-11 | Russia | Kamchatka Krai | 14800 | 238 | 14085 | 477 | 57.1914882 | 160.03838190000005 | 2021-06-12 04:22:22 | Kamchatka Krai, Russia | ||
522768 | 522768 | 2021-06-09 | Germany | Bremen | 27280 | 475 | 26340 | 477 | 53.0793 | 8.8017 | 2021-06-10 04:23:17 | Bremen, Germany | ||
2585832 | 2585832 | 2021-06-05 | Colombia | Choco | 12307 | 310 | 11520 | 477 | 5.2528 | -76.82600000000002 | 2021-06-06 04:24:03 | Choco, Colombia | ||
2315146 | 2315146 | 2021-06-04 | Colombia | Choco | 12210 | 309 | 11424 | 477 | 5.2528 | -76.82600000000002 | 2021-06-05 04:23:03 | Choco, Colombia | ||
3089207 | 3089207 | 2021-05-30 | Chile | Aysen | 5849 | 35 | 5337 | 477 | -45.9864 | -73.7669 | 2021-05-31 03:08:59 | Aysen, Chile | ||
50800 | 50800 | 2021-05-29 | Japan | Gunma | 7793 | 137 | 7179 | 477 | 36.504479 | 138.985605 | 2021-05-30 04:20:55 | Gunma, Japan | ||
50576 | 50576 | 2021-05-29 | Chile | Aysen | 5774 | 35 | 5262 | 477 | -45.9864 | -73.7669 | 2021-05-30 04:20:55 | Aysen, Chile | ||
1082109 | 1082109 | 2021-05-14 | Russia | Amur Oblast | 22488 | 288 | 21723 | 477 | 52.8032368 | 128.437295 | 2021-05-15 04:20:58 | Amur Oblast, Russia | ||
1081947 | 1081947 | 2021-05-14 | Japan | Mie | 4361 | 96 | 3788 | 477 | 34.508018 | 136.376013 | 2021-05-15 04:20:58 | Mie, Japan | ||
3054419 | 3054419 | 2021-05-13 | Russia | North Ossetia - Alania Republic | 16851 | 198 | 16176 | 477 | 42.79336110000001 | 44.6324493 | 2021-05-14 04:20:41 | North Ossetia - Alania Republic, Russia | ||
3954720 | 3954720 | 2021-05-11 | Russia | North Ossetia - Alania Republic | 16833 | 198 | 16158 | 477 | 42.79336110000001 | 44.6324493 | 2021-05-12 04:21:29 | North Ossetia - Alania Republic, Russia | ||
3242256 | 3242256 | 2021-04-21 | Guinea-Bissau | 3713 | 66 | 3170 | 477 | 11.8037 | -15.1804 | 2021-04-22 04:20:53 | Guinea-Bissau | |||
2020652 | 2020652 | 2021-04-20 | Guinea-Bissau | 3713 | 66 | 3170 | 477 | 11.8037 | -15.1804 | 2021-04-21 04:21:14 | Guinea-Bissau | |||
1301902 | 1301902 | 2021-04-01 | Colombia | La Guajira | 18099 | 665 | 16957 | 477 | 11.3548 | -72.5205 | 2021-04-02 04:20:36 | La Guajira, Colombia | ||
3647235 | 3647235 | 2021-03-30 | Malaysia | Sabah | 54699 | 391 | 53831 | 477 | 5.9788 | 116.0753 | 2021-03-31 04:26:25 | Sabah, Malaysia | ||
1837783 | 1837783 | 2021-03-12 | Colombia | Meta | 42907 | 983 | 41447 | 477 | 3.272 | -73.0877 | 2021-03-13 05:25:15 | Meta, Colombia | ||
3669737 | 3669737 | 2021-03-06 | US | Nebraska | Thayer | 31169 | 481 | 4 | 0 | 477 | 40.17626377 | -97.59504381 | 2021-03-07 05:21:54 | Thayer, Nebraska, US |
3669014 | 3669014 | 2021-03-06 | US | Kentucky | Fulton | 21075 | 485 | 8 | 0 | 477 | 36.55238827 | -89.20140068 | 2021-03-07 05:21:54 | Fulton, Kentucky, US |
3667383 | 3667383 | 2021-03-06 | Cambodia | 987 | 0 | 510 | 477 | 11.55 | 104.9167 | 2021-03-07 05:21:54 | Cambodia | |||
1618358 | 1618358 | 2021-03-05 | US | Nebraska | Thayer | 31169 | 481 | 4 | 0 | 477 | 40.17626377 | -97.59504381 | 2021-03-06 04:23:41 | Thayer, Nebraska, US |
1090716 | 1090716 | 2021-03-03 | US | Colorado | Rio Blanco | 8103 | 509 | 4 | 0 | 477 | 39.97913541 | -108.2179009 | 2021-03-04 05:24:24 | Rio Blanco, Colorado, US |
3255104 | 3255104 | 2021-03-02 | US | Illinois | Calhoun | 17013 | 479 | 2 | 0 | 477 | 39.16840183 | -90.66330078 | 2021-03-03 05:23:28 | Calhoun, Illinois, US |
1000630 | 1000630 | 2021-03-01 | US | New Mexico | Los Alamos | 35028 | 482 | 5 | 0 | 477 | 35.86631386 | -106.3134985 | 2021-03-02 05:23:30 | Los Alamos, New Mexico, US |
2370821 | 2370821 | 2021-02-28 | US | Virginia | Fairfax City | 51600 | 490 | 13 | 0 | 477 | 38.85157547 | -77.29779640000002 | 2021-03-01 05:23:01 | Fairfax City, Virginia, US |
185406 | 185406 | 2021-02-21 | US | Virginia | Middlesex | 51119 | 493 | 16 | 0 | 477 | 37.63191998 | -76.55064617 | 2021-02-22 05:24:21 | Middlesex, Virginia, US |
1156058 | 1156058 | 2021-02-18 | US | Tennessee | Hancock | 47067 | 503 | 11 | 0 | 477 | 36.52692871 | -83.22375847 | 2021-02-19 05:24:16 | Hancock, Tennessee, US |
3603789 | 3603789 | 2021-02-17 | US | Puerto Rico | Luquillo | 72089 | 477 | 0 | 0 | 477 | 18.342114 | -65.72509699999999 | 2021-02-18 05:22:58 | Luquillo, Puerto Rico, US |
3601928 | 3601928 | 2021-02-17 | US | Georgia | Warren | 13301 | 487 | 10 | 0 | 477 | 33.41146451 | -82.67795848 | 2021-02-18 05:22:58 | Warren, Georgia, US |
3053113 | 3053113 | 2021-02-16 | US | Tennessee | Hancock | 47067 | 501 | 11 | 0 | 477 | 36.52692871 | -83.22375847 | 2021-02-17 05:23:10 | Hancock, Tennessee, US |
3052239 | 3052239 | 2021-02-16 | US | Nebraska | Furnas | 31065 | 481 | 4 | 0 | 477 | 40.17642064 | -99.91247454 | 2021-02-17 05:23:10 | Furnas, Nebraska, US |
3051403 | 3051403 | 2021-02-16 | US | Iowa | Ringgold | 19159 | 493 | 16 | 0 | 477 | 40.73518949 | -94.24368535 | 2021-02-17 05:23:10 | Ringgold, Iowa, US |
3051063 | 3051063 | 2021-02-16 | US | Georgia | Warren | 13301 | 487 | 10 | 0 | 477 | 33.41146451 | -82.67795848 | 2021-02-17 05:23:10 | Warren, Georgia, US |
1340338 | 1340338 | 2021-02-15 | US | Nebraska | Furnas | 31065 | 481 | 4 | 0 | 477 | 40.17642064 | -99.91247454 | 2021-02-16 05:24:38 | Furnas, Nebraska, US |
1339502 | 1339502 | 2021-02-15 | US | Iowa | Ringgold | 19159 | 493 | 16 | 0 | 477 | 40.73518949 | -94.24368535 | 2021-02-16 05:24:38 | Ringgold, Iowa, US |
2286541 | 2286541 | 2021-02-14 | US | Texas | Hudspeth | 48229 | 640 | 11 | 0 | 477 | 31.45628381 | -105.388178 | 2021-02-15 05:24:49 | Hudspeth, Texas, US |
2285489 | 2285489 | 2021-02-14 | US | Nebraska | Furnas | 31065 | 481 | 4 | 0 | 477 | 40.17642064 | -99.91247454 | 2021-02-15 05:24:49 | Furnas, Nebraska, US |
2681332 | 2681332 | 2021-02-13 | US | West Virginia | Tucker | 54093 | 484 | 7 | 0 | 477 | 39.11240885 | -79.57053576 | 2021-02-14 05:23:43 | Tucker, West Virginia, US |
2679889 | 2679889 | 2021-02-13 | US | Nebraska | Furnas | 31065 | 481 | 4 | 0 | 477 | 40.17642064 | -99.91247454 | 2021-02-14 05:23:43 | Furnas, Nebraska, US |
3540394 | 3540394 | 2021-02-12 | US | Idaho | Lemhi | 16059 | 486 | 9 | 0 | 477 | 44.9438088 | -113.9309747 | 2021-02-13 05:22:12 | Lemhi, Idaho, US |
1528386 | 1528386 | 2021-02-09 | US | Arkansas | Lafayette | 5073 | 484 | 7 | 0 | 477 | 33.24116713 | -93.60677071 | 2021-02-10 05:22:41 | Lafayette, Arkansas, US |
617052 | 617052 | 2021-02-08 | US | Virginia | Mathews | 51115 | 484 | 7 | 0 | 477 | 37.44164146 | -76.34098896 | 2021-02-09 05:23:30 | Mathews, Virginia, US |
1672592 | 1672592 | 2021-02-07 | Niger | 4612 | 165 | 3970 | 477 | 17.607789 | 8.081666 | 2021-02-08 05:22:39 | Niger | |||
1672238 | 1672238 | 2021-02-07 | Chad | 3497 | 125 | 2895 | 477 | 15.4542 | 18.7322 | 2021-02-08 05:22:39 | Chad | |||
1590464 | 1590464 | 2021-02-05 | US | North Carolina | Camden | 37029 | 482 | 5 | 0 | 477 | 36.33804939 | -76.15568396 | 2021-02-06 05:23:55 | Camden, North Carolina, US |
1589162 | 1589162 | 2021-02-05 | US | Illinois | Henderson | 17071 | 485 | 8 | 0 | 477 | 40.81908672 | -90.92491462 | 2021-02-06 05:23:55 | Henderson, Illinois, US |
793245 | 793245 | 2021-02-04 | US | South Dakota | Gregory | 46053 | 504 | 27 | 0 | 477 | 43.19419064 | -99.18883902 | 2021-02-05 05:22:38 | Gregory, South Dakota, US |
1687861 | 1687861 | 2021-02-02 | US | Virginia | Madison | 51113 | 483 | 6 | 0 | 477 | 38.41531222 | -78.28220331 | 2021-02-03 05:22:52 | Madison, Virginia, US |
2211527 | 2211527 | 2021-01-30 | Colombia | Sucre | 19261 | 716 | 18068 | 477 | 8.814 | -74.7233 | 2021-01-31 05:22:42 | Sucre, Colombia | ||
1900314 | 1900314 | 2021-01-29 | US | Texas | McCulloch | 48307 | 468 | 14 | 0 | 477 | 31.1925468 | -99.34682807 | 2021-01-30 05:22:49 | McCulloch, Texas, US |
2485130 | 2485130 | 2021-01-28 | US | Texas | McCulloch | 48307 | 468 | 14 | 0 | 477 | 31.1925468 | -99.34682807 | 2021-01-29 05:22:23 | McCulloch, Texas, US |
3156765 | 3156765 | 2021-01-27 | US | Texas | McCulloch | 48307 | 468 | 14 | 0 | 477 | 31.1925468 | -99.34682807 | 2021-01-28 05:22:24 | McCulloch, Texas, US |
3156150 | 3156150 | 2021-01-27 | US | Oklahoma | Grant | 40053 | 482 | 5 | 0 | 477 | 36.796297 | -97.78638765 | 2021-01-28 05:22:24 | Grant, Oklahoma, US |
13314 | 13314 | 2021-01-26 | US | Illinois | Edwards | 17047 | 485 | 8 | 0 | 477 | 38.41353228 | -88.05720863 | 2021-01-27 05:23:41 | Edwards, Illinois, US |
2469664 | 2469664 | 2021-01-22 | US | South Dakota | Fall River | 46047 | 491 | 14 | 0 | 477 | 43.23929297 | -103.5275691 | 2021-01-23 05:22:03 | Fall River, South Dakota, US |
2467844 | 2467844 | 2021-01-22 | US | Illinois | Stark | 17175 | 497 | 20 | 0 | 477 | 41.09309773 | -89.79745866 | 2021-01-23 05:22:03 | Stark, Illinois, US |
436213 | 436213 | 2021-01-21 | US | Georgia | Randolph | 13243 | 508 | 31 | 0 | 477 | 31.76622818 | -84.75732369 | 2021-01-22 05:22:10 | Randolph, Georgia, US |
1096164 | 1096164 | 2021-01-20 | US | Nebraska | Howard | 31093 | 491 | 14 | 0 | 477 | 41.2200529 | -98.5166499 | 2021-01-21 05:22:01 | Howard, Nebraska, US |
910254 | 910254 | 2021-01-19 | US | Nebraska | Howard | 31093 | 491 | 14 | 0 | 477 | 41.2200529 | -98.5166499 | 2021-01-20 05:21:54 | Howard, Nebraska, US |
239317 | 239317 | 2021-01-18 | US | Nebraska | Howard | 31093 | 491 | 14 | 0 | 477 | 41.2200529 | -98.5166499 | 2021-01-19 05:22:15 | Howard, Nebraska, US |
3505434 | 3505434 | 2021-01-17 | US | Nebraska | Howard | 31093 | 491 | 14 | 0 | 477 | 41.2200529 | -98.5166499 | 2021-01-18 05:22:34 | Howard, Nebraska, US |
3505291 | 3505291 | 2021-01-17 | US | Missouri | Ozark | 29153 | 482 | 5 | 0 | 477 | 36.64916339 | -92.44459066 | 2021-01-18 05:22:34 | Ozark, Missouri, US |
3104162 | 3104162 | 2021-01-16 | US | Puerto Rico | Ciales | 72039 | 477 | 0 | 0 | 477 | 18.28885 | -66.516475 | 2021-01-17 05:22:17 | Ciales, Puerto Rico, US |
3104151 | 3104151 | 2021-01-16 | US | Puerto Rico | Barceloneta | 72017 | 477 | 0 | 0 | 477 | 18.445533 | -66.56053100000001 | 2021-01-17 05:22:17 | Barceloneta, Puerto Rico, US |
3516960 | 3516960 | 2021-01-15 | US | Maine | Washington | 23029 | 484 | 7 | 0 | 477 | 45.01607142 | -67.62813524 | 2021-01-16 05:22:40 | Washington, Maine, US |
3516024 | 3516024 | 2021-01-15 | US | Colorado | Lake | 8065 | 491 | 0 | 0 | 477 | 39.20278823 | -106.3555697 | 2021-01-16 05:22:40 | Lake, Colorado, US |
3882844 | 3882844 | 2021-01-14 | US | Vermont | Addison | 50001 | 481 | 4 | 0 | 477 | 44.03217337 | -73.14130877 | 2021-01-15 05:22:24 | Addison, Vermont, US |
190026 | 190026 | 2021-01-11 | India | Manipur | 28693 | 365 | 27851 | 477 | 24.738975 | 93.882541 | 2021-01-12 05:22:15 | Manipur, India | ||
2626751 | 2626751 | 2021-01-10 | US | Georgia | Twiggs | 13289 | 497 | 20 | 0 | 477 | 32.67435595 | -83.43078662 | 2021-01-11 05:21:50 | Twiggs, Georgia, US |
2626697 | 2626697 | 2021-01-10 | US | Georgia | Lincoln | 13181 | 490 | 13 | 0 | 477 | 33.79201475 | -82.45024131 | 2021-01-11 05:21:50 | Lincoln, Georgia, US |
3902367 | 3902367 | 2021-01-09 | US | North Dakota | Pierce | 38069 | 499 | 22 | 0 | 477 | 48.24977025 | -99.96407787 | 2021-01-10 05:22:12 | Pierce, North Dakota, US |
156761 | 156761 | 2021-01-08 | US | Puerto Rico | Villalba | 72149 | 477 | 0 | 0 | 477 | 18.127951 | -66.473115 | 2021-01-09 05:22:18 | Villalba, Puerto Rico, US |
155786 | 155786 | 2021-01-08 | US | Mississippi | Jefferson | 28063 | 494 | 17 | 0 | 477 | 31.73397872 | -91.03764977 | 2021-01-09 05:22:18 | Jefferson, Mississippi, US |
154892 | 154892 | 2021-01-08 | US | Idaho | Benewah | 16009 | 482 | 5 | 0 | 477 | 47.21754179 | -116.6586851 | 2021-01-09 05:22:18 | Benewah, Idaho, US |
2544850 | 2544850 | 2021-01-07 | US | Washington | Pend Oreille | 53051 | 481 | 4 | 0 | 477 | 48.53234021 | -117.2741804 | 2021-01-08 05:22:42 | Pend Oreille, Washington, US |
2867998 | 2867998 | 2021-01-06 | US | Vermont | Windsor | 50027 | 480 | 3 | 0 | 477 | 43.58010937 | -72.58595157 | 2021-01-07 05:22:03 | Windsor, Vermont, US |
2867266 | 2867266 | 2021-01-06 | US | Oklahoma | Jefferson | 40067 | 481 | 4 | 0 | 477 | 34.11130184 | -97.83182974 | 2021-01-07 05:22:03 | Jefferson, Oklahoma, US |
2866601 | 2866601 | 2021-01-06 | US | Missouri | Daviess | 29061 | 486 | 9 | 0 | 477 | 39.96145298 | -93.98519678 | 2021-01-07 05:22:03 | Daviess, Missouri, US |
3037398 | 3037398 | 2021-01-05 | US | Texas | Hamilton | 48193 | 527 | 17 | 0 | 477 | 31.70470573 | -98.11083887 | 2021-01-06 05:22:16 | Hamilton, Texas, US |
1065458 | 1065458 | 2021-01-04 | US | Wyoming | Weston | 56045 | 479 | 2 | 0 | 477 | 43.83961191 | -104.5674881 | 2021-01-05 05:21:49 | Weston, Wyoming, US |
3231280 | 3231280 | 2021-01-03 | US | Georgia | Macon | 13193 | 493 | 16 | 0 | 477 | 32.35207048 | -84.04234127 | 2021-01-04 05:22:02 | Macon, Georgia, US |
2227543 | 2227543 | 2021-01-02 | Japan | Miyagi | 2225 | 16 | 1732 | 477 | 38.446859 | 140.927086 | 2021-01-03 05:22:52 | Miyagi, Japan | ||
1139979 | 1139979 | 2021-01-01 | US | Texas | Hamilton | 48193 | 526 | 16 | 0 | 477 | 31.70470573 | -98.11083887 | 2021-01-02 05:22:33 | Hamilton, Texas, US |
3698585 | 3698585 | 2020-12-31 | US | Texas | Hamilton | 48193 | 526 | 16 | 0 | 477 | 31.70470573 | -98.11083887 | 2021-01-01 05:23:07 | Hamilton, Texas, US |
1013058 | 1013058 | 2020-12-30 | US | Puerto Rico | Naguabo | 72103 | 477 | 0 | 0 | 477 | 18.230637 | -65.753897 | 2020-12-31 05:22:49 | Naguabo, Puerto Rico, US |
769073 | 769073 | 2020-12-29 | US | Puerto Rico | Naguabo | 72103 | 477 | 0 | 0 | 477 | 18.230637 | -65.753897 | 2020-12-30 05:22:34 | Naguabo, Puerto Rico, US |
768245 | 768245 | 2020-12-29 | US | Missouri | Montgomery | 29139 | 486 | 9 | 0 | 477 | 38.94022054 | -91.47000721 | 2020-12-30 05:22:34 | Montgomery, Missouri, US |
767153 | 767153 | 2020-12-29 | US | Georgia | McIntosh | 13191 | 487 | 10 | 0 | 477 | 31.49683595 | -81.40163426 | 2020-12-30 05:22:34 | McIntosh, Georgia, US |
3779958 | 3779958 | 2020-12-27 | US | Nebraska | Dixon | 31051 | 483 | 6 | 0 | 477 | 42.49188363 | -96.86782408 | 2020-12-28 05:22:06 | Dixon, Nebraska, US |
3779197 | 3779197 | 2020-12-27 | US | Kansas | Kearny | 20093 | 485 | 8 | 0 | 477 | 38.00017981 | -101.321681 | 2020-12-28 05:22:06 | Kearny, Kansas, US |
2225563 | 2225563 | 2020-12-26 | US | Nebraska | Dixon | 31051 | 483 | 6 | 0 | 477 | 42.49188363 | -96.86782408 | 2020-12-27 05:22:55 | Dixon, Nebraska, US |
2224802 | 2224802 | 2020-12-26 | US | Kansas | Kearny | 20093 | 485 | 8 | 0 | 477 | 38.00017981 | -101.321681 | 2020-12-27 05:22:55 | Kearny, Kansas, US |
2224649 | 2224649 | 2020-12-26 | US | Indiana | Warren | 18171 | 486 | 9 | 0 | 477 | 40.34728141 | -87.35602659 | 2020-12-27 05:22:55 | Warren, Indiana, US |
204310 | 204310 | 2020-12-25 | US | Nebraska | Dixon | 31051 | 483 | 6 | 0 | 477 | 42.49188363 | -96.86782408 | 2020-12-26 05:22:28 | Dixon, Nebraska, US |
203549 | 203549 | 2020-12-25 | US | Kansas | Kearny | 20093 | 485 | 8 | 0 | 477 | 38.00017981 | -101.321681 | 2020-12-26 05:22:28 | Kearny, Kansas, 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]);