johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
182 rows where active = 1302 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3632199 | 3632199 | 2021-07-14 | Russia | Ryazan Oblast | 32867 | 716 | 30849 | 1302 | 54.42267320000001 | 40.57052460000001 | 2021-07-15 04:21:48 | Ryazan Oblast, Russia | ||
778625 | 778625 | 2021-07-08 | Russia | Yamalo-Nenets Autonomous Okrug | 40830 | 436 | 39092 | 1302 | 67.1471631 | 74.3415488 | 2021-07-09 04:21:21 | Yamalo-Nenets Autonomous Okrug, Russia | ||
1440843 | 1440843 | 2021-07-07 | Russia | Vladimir Oblast | 37797 | 1298 | 35197 | 1302 | 56.0503336 | 40.6561633 | 2021-07-08 04:21:26 | Vladimir Oblast, Russia | ||
2589796 | 2589796 | 2021-06-27 | Chile | OHiggins | 65063 | 1322 | 62439 | 1302 | -34.5755 | -71.0022 | 2021-06-28 04:21:29 | OHiggins, Chile | ||
3958698 | 3958698 | 2021-06-26 | Russia | Bryansk Oblast | 43266 | 459 | 41505 | 1302 | 52.8873315 | 33.41585300000001 | 2021-06-27 04:21:39 | Bryansk Oblast, Russia | ||
2911150 | 2911150 | 2021-06-17 | Italy | Abruzzo | 74545 | 2507 | 70736 | 1302 | 42.35122196 | 13.39843823 | 2021-06-18 04:22:16 | Abruzzo, Italy | ||
3381639 | 3381639 | 2021-06-13 | Russia | Zabaykalsky Krai | 43983 | 686 | 41995 | 1302 | 52.248521 | 115.956325 | 2021-06-14 04:22:46 | Zabaykalsky Krai, Russia | ||
522892 | 522892 | 2021-06-09 | Japan | Saitama | 44691 | 808 | 42581 | 1302 | 35.997101 | 139.347635 | 2021-06-10 04:23:17 | Saitama, Japan | ||
522698 | 522698 | 2021-06-09 | Colombia | Casanare | 23366 | 550 | 21514 | 1302 | 5.7589 | -71.5724 | 2021-06-10 04:23:17 | Casanare, Colombia | ||
3145690 | 3145690 | 2021-06-07 | Moldova | 255501 | 6137 | 248062 | 1302 | 47.4116 | 28.3699 | 2021-06-08 04:22:35 | Moldova | |||
2004878 | 2004878 | 2021-05-12 | Russia | Kursk Oblast | 37247 | 750 | 35195 | 1302 | 51.6568453 | 36.4852695 | 2021-05-13 04:20:51 | Kursk Oblast, Russia | ||
2501882 | 2501882 | 2021-05-07 | Colombia | Narino | 55314 | 1799 | 52213 | 1302 | 1.2892 | -77.3579 | 2021-05-08 04:21:04 | Narino, Colombia | ||
2414526 | 2414526 | 2021-04-19 | Malaysia | Sabah | 56911 | 415 | 55194 | 1302 | 5.9788 | 116.0753 | 2021-04-20 04:20:41 | Sabah, Malaysia | ||
3710391 | 3710391 | 2021-04-03 | Russia | Tver Oblast | 37687 | 740 | 35645 | 1302 | 57.1134475 | 35.174442799999994 | 2021-04-04 04:20:49 | Tver Oblast, Russia | ||
1302316 | 1302316 | 2021-04-01 | Rwanda | 21918 | 308 | 20308 | 1302 | -1.9403 | 29.8739 | 2021-04-02 04:20:36 | Rwanda | |||
637927 | 637927 | 2021-03-31 | Japan | Chiba | 29698 | 568 | 27828 | 1302 | 35.510141 | 140.198917 | 2021-04-01 04:27:05 | Chiba, Japan | ||
352147 | 352147 | 2021-03-11 | Colombia | Magdalena | 36763 | 1368 | 34093 | 1302 | 10.4113 | -74.4057 | 2021-03-12 05:26:50 | Magdalena, Colombia | ||
3966206 | 3966206 | 2021-03-10 | Malaysia | W.P. Kuala Lumpur | 36011 | 107 | 34602 | 1302 | 3.139 | 101.6869 | 2021-03-11 05:25:48 | W.P. Kuala Lumpur, Malaysia | ||
1617613 | 1617613 | 2021-03-05 | US | Kentucky | Butler | 21031 | 1325 | 23 | 0 | 1302 | 37.20946153 | -86.68748787 | 2021-03-06 04:23:41 | Butler, Kentucky, US |
2209800 | 2209800 | 2021-03-04 | US | New Hampshire | Coos | 33007 | 1338 | 36 | 0 | 1302 | 44.69063265 | -71.30633239 | 2021-03-05 05:26:29 | Coos, New Hampshire, US |
2209024 | 2209024 | 2021-03-04 | US | Kentucky | Butler | 21031 | 1325 | 23 | 0 | 1302 | 37.20946153 | -86.68748787 | 2021-03-05 05:26:29 | Butler, Kentucky, US |
3067741 | 3067741 | 2021-02-27 | US | Minnesota | Pennington | 27113 | 1318 | 16 | 0 | 1302 | 48.06642577 | -96.0370814 | 2021-02-28 05:22:20 | Pennington, Minnesota, US |
1860230 | 1860230 | 2021-02-25 | US | New York | Essex | 36031 | 1328 | 26 | 0 | 1302 | 44.11630765 | -73.77297842 | 2021-02-26 05:22:40 | Essex, New York, US |
282279 | 282279 | 2021-02-24 | US | Nebraska | Otoe | 31131 | 1309 | 7 | 0 | 1302 | 40.64843556 | -96.13374142 | 2021-02-25 05:24:57 | Otoe, Nebraska, US |
183496 | 183496 | 2021-02-21 | US | Kentucky | Rockcastle | 21203 | 1315 | 13 | 0 | 1302 | 37.36642393 | -84.31176452 | 2021-02-22 05:24:21 | Rockcastle, Kentucky, US |
745031 | 745031 | 2021-02-20 | US | Puerto Rico | Canovanas | 72029 | 1302 | 0 | 0 | 1302 | 18.328802 | -65.887612 | 2021-02-21 05:24:33 | Canovanas, Puerto Rico, US |
1155838 | 1155838 | 2021-02-18 | US | Puerto Rico | Canovanas | 72029 | 1302 | 0 | 0 | 1302 | 18.328802 | -65.887612 | 2021-02-19 05:24:16 | Canovanas, Puerto Rico, US |
3539811 | 3539811 | 2021-02-12 | US | Alabama | Cleburne | 1029 | 1336 | 34 | 0 | 1302 | 33.67679204 | -85.52005899 | 2021-02-13 05:22:12 | Cleburne, Alabama, US |
2641004 | 2641004 | 2021-02-11 | US | Vermont | Washington | 50023 | 1314 | 12 | 0 | 1302 | 44.27343241 | -72.61604978 | 2021-02-12 05:23:29 | Washington, Vermont, US |
2640516 | 2640516 | 2021-02-11 | US | South Carolina | Bamberg | 45009 | 1349 | 47 | 0 | 1302 | 33.21927586 | -81.05659969 | 2021-02-12 05:23:29 | Bamberg, South Carolina, US |
2638461 | 2638461 | 2021-02-11 | US | Georgia | Bacon | 13005 | 1334 | 32 | 0 | 1302 | 31.55456473 | -82.45936528 | 2021-02-12 05:23:29 | Bacon, Georgia, US |
2638074 | 2638074 | 2021-02-11 | US | Alabama | Cleburne | 1029 | 1335 | 33 | 0 | 1302 | 33.67679204 | -85.52005899 | 2021-02-12 05:23:29 | Cleburne, Alabama, US |
3979316 | 3979316 | 2021-02-10 | US | Georgia | Bacon | 13005 | 1334 | 32 | 0 | 1302 | 31.55456473 | -82.45936528 | 2021-02-11 05:23:55 | Bacon, Georgia, US |
1673302 | 1673302 | 2021-02-07 | US | Georgia | Oglethorpe | 13221 | 1321 | 19 | 0 | 1302 | 33.878629600000004 | -83.08278123 | 2021-02-08 05:22:39 | Oglethorpe, Georgia, US |
1673196 | 1673196 | 2021-02-07 | US | Georgia | Bacon | 13005 | 1333 | 31 | 0 | 1302 | 31.55456473 | -82.45936528 | 2021-02-08 05:22:39 | Bacon, Georgia, US |
978500 | 978500 | 2021-02-06 | US | Wisconsin | Washburn | 55129 | 1322 | 20 | 0 | 1302 | 45.89838588 | -91.79050449 | 2021-02-07 05:23:00 | Washburn, Wisconsin, US |
975657 | 975657 | 2021-02-06 | US | Georgia | Bacon | 13005 | 1333 | 31 | 0 | 1302 | 31.55456473 | -82.45936528 | 2021-02-07 05:23:00 | Bacon, Georgia, US |
975276 | 975276 | 2021-02-06 | US | Alabama | Crenshaw | 1041 | 1351 | 49 | 0 | 1302 | 31.72941803 | -86.31593104 | 2021-02-07 05:23:00 | Crenshaw, Alabama, US |
975269 | 975269 | 2021-02-06 | US | Alabama | Clay | 1027 | 1354 | 52 | 0 | 1302 | 33.26984193 | -85.85836077 | 2021-02-07 05:23:00 | Clay, Alabama, US |
1588030 | 1588030 | 2021-02-05 | Colombia | Norte de Santander | 49266 | 2585 | 45379 | 1302 | 7.9463 | -72.8988 | 2021-02-06 05:23:55 | Norte de Santander, Colombia | ||
791777 | 791777 | 2021-02-04 | US | Kentucky | Garrard | 21079 | 1306 | 4 | 0 | 1302 | 37.6388668 | -84.53289319 | 2021-02-05 05:22:38 | Garrard, Kentucky, US |
343313 | 343313 | 2021-02-03 | US | Texas | Childress | 48075 | 1435 | 13 | 0 | 1302 | 34.529304100000004 | -100.2077916 | 2021-02-04 05:22:26 | Childress, Texas, US |
1686209 | 1686209 | 2021-02-02 | US | Minnesota | Fillmore | 27045 | 1310 | 8 | 0 | 1302 | 43.67394126 | -92.08980382 | 2021-02-03 05:22:52 | Fillmore, Minnesota, US |
2213640 | 2213640 | 2021-01-30 | US | Missouri | Wright | 29229 | 1326 | 24 | 0 | 1302 | 37.27029221 | -92.46914488 | 2021-01-31 05:22:42 | Wright, Missouri, US |
3155302 | 3155302 | 2021-01-27 | US | Minnesota | Chippewa | 27023 | 1334 | 32 | 0 | 1302 | 45.02343421 | -95.56403693 | 2021-01-28 05:22:24 | Chippewa, Minnesota, US |
14037 | 14037 | 2021-01-26 | US | Minnesota | Chippewa | 27023 | 1334 | 32 | 0 | 1302 | 45.02343421 | -95.56403693 | 2021-01-27 05:23:41 | Chippewa, Minnesota, US |
1762973 | 1762973 | 2021-01-24 | Malaysia | Melaka | 2983 | 9 | 1672 | 1302 | 2.1896 | 102.2501 | 2021-01-25 05:22:16 | Melaka, Malaysia | ||
2430089 | 2430089 | 2021-01-23 | US | Texas | Pecos | 48371 | 1039 | 28 | 0 | 1302 | 30.78097267 | -102.7241261 | 2021-01-24 05:22:35 | Pecos, Texas, US |
2469991 | 2469991 | 2021-01-22 | US | Texas | Pecos | 48371 | 1037 | 26 | 0 | 1302 | 30.78097267 | -102.7241261 | 2021-01-23 05:22:03 | Pecos, Texas, US |
436713 | 436713 | 2021-01-21 | US | Kentucky | Anderson | 21005 | 1310 | 8 | 0 | 1302 | 38.00671029 | -84.99171713 | 2021-01-22 05:22:10 | Anderson, Kentucky, US |
1097444 | 1097444 | 2021-01-20 | US | Virginia | Louisa | 51109 | 1313 | 11 | 0 | 1302 | 37.97850256 | -77.96274807 | 2021-01-21 05:22:01 | Louisa, Virginia, US |
3506704 | 3506704 | 2021-01-17 | US | Virginia | Hopewell | 51670 | 1314 | 12 | 0 | 1302 | 37.29186313 | -77.29754684 | 2021-01-18 05:22:34 | Hopewell, Virginia, US |
3504712 | 3504712 | 2021-01-17 | US | Kentucky | Adair | 21001 | 1345 | 43 | 0 | 1302 | 37.10459774 | -85.28129668 | 2021-01-18 05:22:34 | Adair, Kentucky, US |
3101916 | 3101916 | 2021-01-16 | US | Arkansas | Franklin | 5047 | 1330 | 28 | 0 | 1302 | 35.51202821 | -93.89299569 | 2021-01-17 05:22:17 | Franklin, Arkansas, US |
3881692 | 3881692 | 2021-01-14 | US | Nebraska | Unassigned | 90031 | 1309 | 7 | 0 | 1302 | 42.8997274 | 0.0 | 2021-01-15 05:22:24 | Unassigned, Nebraska, US |
3881438 | 3881438 | 2021-01-14 | US | Missouri | Benton | 29015 | 1321 | 19 | 0 | 1302 | 38.29503305 | -93.28756116 | 2021-01-15 05:22:24 | Benton, Missouri, US |
193442 | 193442 | 2021-01-11 | US | Virginia | Nottoway | 51135 | 1327 | 25 | 0 | 1302 | 37.1435975 | -78.05065922 | 2021-01-12 05:22:15 | Nottoway, Virginia, US |
2628309 | 2628309 | 2021-01-10 | US | Ohio | Carroll | 39019 | 1333 | 31 | 0 | 1302 | 40.5789686 | -81.09178213 | 2021-01-11 05:21:50 | Carroll, Ohio, US |
3900353 | 3900353 | 2021-01-09 | US | Alabama | Randolph | 1111 | 1334 | 32 | 0 | 1302 | 33.29526734 | -85.45708831 | 2021-01-10 05:22:12 | Randolph, Alabama, US |
2544480 | 2544480 | 2021-01-07 | US | Texas | Fayette | 48149 | 1406 | 37 | 0 | 1302 | 29.87788372 | -96.92076062 | 2021-01-08 05:22:42 | Fayette, Texas, US |
2544195 | 2544195 | 2021-01-07 | US | South Carolina | Abbeville | 45001 | 1328 | 26 | 0 | 1302 | 34.22333378 | -82.46170658 | 2021-01-08 05:22:42 | Abbeville, South Carolina, US |
2542036 | 2542036 | 2021-01-07 | US | Colorado | Montezuma | 8083 | 1473 | 18 | 0 | 1302 | 37.33859579 | -108.5958857 | 2021-01-08 05:22:42 | Montezuma, Colorado, US |
1064064 | 1064064 | 2021-01-04 | US | New York | Chenango | 36017 | 1326 | 24 | 0 | 1302 | 42.49430041 | -75.60887553 | 2021-01-05 05:21:49 | Chenango, New York, US |
1063369 | 1063369 | 2021-01-04 | US | Louisiana | St. James | 22093 | 1345 | 43 | 0 | 1302 | 30.02531716 | -90.80212061 | 2021-01-05 05:21:49 | St. James, Louisiana, US |
3230678 | 3230678 | 2021-01-03 | Russia | North Ossetia - Alania Republic | 12270 | 101 | 10867 | 1302 | 42.79336110000001 | 44.6324493 | 2021-01-04 05:22:02 | North Ossetia - Alania Republic, Russia | ||
1137841 | 1137841 | 2021-01-01 | US | Illinois | Carroll | 17015 | 1333 | 31 | 0 | 1302 | 42.06823429 | -89.93395545 | 2021-01-02 05:22:33 | Carroll, Illinois, US |
3696447 | 3696447 | 2020-12-31 | US | Illinois | Carroll | 17015 | 1333 | 31 | 0 | 1302 | 42.06823429 | -89.93395545 | 2021-01-01 05:23:07 | Carroll, Illinois, US |
1013112 | 1013112 | 2020-12-30 | US | South Carolina | Fairfield | 45039 | 1355 | 53 | 0 | 1302 | 34.39287073 | -81.1195624 | 2020-12-31 05:22:49 | Fairfield, South Carolina, US |
768784 | 768784 | 2020-12-29 | US | Ohio | Hocking | 39073 | 1345 | 43 | 0 | 1302 | 39.49537927 | -82.47991446 | 2020-12-30 05:22:34 | Hocking, Ohio, US |
3763079 | 3763079 | 2020-12-28 | US | Louisiana | Grant | 22043 | 1342 | 40 | 0 | 1302 | 31.59882456 | -92.56124347 | 2020-12-29 05:22:37 | Grant, Louisiana, US |
3762486 | 3762486 | 2020-12-28 | US | Hawaii | Maui | 15009 | 1319 | 17 | 0 | 1302 | 20.86399628 | -156.56890969999995 | 2020-12-29 05:22:37 | Maui, Hawaii, US |
3779399 | 3779399 | 2020-12-27 | US | Louisiana | Grant | 22043 | 1340 | 38 | 0 | 1302 | 31.59882456 | -92.56124347 | 2020-12-28 05:22:06 | Grant, Louisiana, US |
2224677 | 2224677 | 2020-12-26 | US | Iowa | Clayton | 19043 | 1341 | 39 | 0 | 1302 | 42.84443388 | -91.34133693 | 2020-12-27 05:22:55 | Clayton, Iowa, US |
2223766 | 2223766 | 2020-12-26 | Russia | Volgograd Oblast | 34052 | 433 | 32317 | 1302 | 49.6048339 | 44.29035820000001 | 2020-12-27 05:22:55 | Volgograd Oblast, Russia | ||
2408400 | 2408400 | 2020-12-23 | US | Maryland | Garrett | 24023 | 1339 | 37 | 0 | 1302 | 39.52786077 | -79.27355126 | 2020-12-24 05:23:04 | Garrett, Maryland, US |
2407088 | 2407088 | 2020-12-23 | Russia | Volgograd Oblast | 33215 | 419 | 31494 | 1302 | 49.6048339 | 44.29035820000001 | 2020-12-24 05:23:04 | Volgograd Oblast, Russia | ||
2407087 | 2407087 | 2020-12-23 | Russia | Vladimir Oblast | 17134 | 421 | 15411 | 1302 | 56.0503336 | 40.6561633 | 2020-12-24 05:23:04 | Vladimir Oblast, Russia | ||
928530 | 928530 | 2020-12-21 | US | Georgia | Monroe | 13207 | 1363 | 61 | 0 | 1302 | 33.014289 | -83.92097166 | 2020-12-22 05:22:33 | Monroe, Georgia, US |
2932440 | 2932440 | 2020-12-19 | US | Iowa | Page | 19145 | 1315 | 13 | 0 | 1302 | 40.7393172 | -95.1497813 | 2020-12-20 05:27:32 | Page, Iowa, US |
3153074 | 3153074 | 2020-12-16 | US | West Virginia | Marion | 54049 | 1310 | 8 | 0 | 1302 | 39.50984542 | -80.24244659 | 2020-12-17 05:28:12 | Marion, West Virginia, US |
1037888 | 1037888 | 2020-12-15 | US | Wisconsin | Adams | 55001 | 1314 | 12 | 0 | 1302 | 43.96974651 | -89.76782777 | 2020-12-16 05:28:04 | Adams, Wisconsin, US |
848799 | 848799 | 2020-12-12 | US | Texas | Upshur | 48459 | 1344 | 25 | 0 | 1302 | 32.73706798 | -94.93999853 | 2020-12-13 05:27:20 | Upshur, Texas, US |
863290 | 863290 | 2020-12-11 | US | Oregon | Klamath | 41035 | 1313 | 11 | 0 | 1302 | 42.68762984 | -121.64964609999998 | 2020-12-12 05:26:19 | Klamath, Oregon, US |
863186 | 863186 | 2020-12-11 | US | Ohio | Van Wert | 39161 | 1346 | 44 | 0 | 1302 | 40.8554138 | -84.59111700000003 | 2020-12-12 05:26:19 | Van Wert, Ohio, US |
1601349 | 1601349 | 2020-12-10 | US | Indiana | Sullivan | 18153 | 1325 | 23 | 0 | 1302 | 39.08952258 | -87.41414469 | 2020-12-11 05:26:59 | Sullivan, Indiana, US |
2978004 | 2978004 | 2020-12-09 | US | Puerto Rico | Vega Baja | 72145 | 1302 | 0 | 0 | 1302 | 18.428262 | -66.397924 | 2020-12-10 05:26:19 | Vega Baja, Puerto Rico, US |
1008557 | 1008557 | 2020-12-06 | US | New York | Tompkins | 36109 | 1306 | 4 | 0 | 1302 | 42.44945765 | -76.47229843 | 2020-12-07 05:26:14 | Tompkins, New York, US |
1007088 | 1007088 | 2020-12-06 | US | Georgia | Franklin | 13119 | 1325 | 23 | 0 | 1302 | 34.37525597 | -83.23159927 | 2020-12-07 05:26:14 | Franklin, Georgia, US |
76578 | 76578 | 2020-12-03 | US | Louisiana | De Soto | 22031 | 1341 | 39 | 0 | 1302 | 32.05457447 | -93.74130302 | 2020-12-04 05:27:27 | De Soto, Louisiana, US |
739689 | 739689 | 2020-12-02 | US | Kentucky | Floyd | 21071 | 1309 | 7 | 0 | 1302 | 37.56213922 | -82.74750924 | 2020-12-03 05:28:22 | Floyd, Kentucky, US |
739037 | 739037 | 2020-12-02 | US | Georgia | Appling | 13001 | 1343 | 41 | 0 | 1302 | 31.74847232 | -82.28909114 | 2020-12-03 05:28:22 | Appling, Georgia, US |
1586359 | 1586359 | 2020-11-30 | US | New Mexico | Rio Arriba | 35039 | 1325 | 23 | 0 | 1302 | 36.51072137 | -106.6931674 | 2020-12-01 05:26:18 | Rio Arriba, New Mexico, US |
3567267 | 3567267 | 2020-11-29 | US | Florida | Lafayette | 12067 | 1322 | 20 | 0 | 1302 | 29.98484137 | -83.18166636 | 2020-11-30 05:26:13 | Lafayette, Florida, US |
2937367 | 2937367 | 2020-11-28 | US | Nevada | Nye | 32023 | 1329 | 27 | 0 | 1302 | 38.04264256 | -116.4722702 | 2020-11-29 05:25:55 | Nye, Nevada, US |
925875 | 925875 | 2020-11-26 | US | New Mexico | Otero | 35035 | 1325 | 23 | 0 | 1302 | 32.61348406 | -105.7417604 | 2020-11-27 05:26:53 | Otero, New Mexico, US |
1353759 | 1353759 | 2020-11-24 | US | Washington | Okanogan | 53047 | 1318 | 16 | 0 | 1302 | 48.54855019 | -119.7387224 | 2020-11-25 05:27:20 | Okanogan, Washington, US |
1350772 | 1350772 | 2020-11-24 | US | Arkansas | Baxter | 5005 | 1329 | 27 | 0 | 1302 | 36.28784385 | -92.33782872 | 2020-11-25 05:27:20 | Baxter, Arkansas, US |
1350508 | 1350508 | 2020-11-24 | Russia | Chechen Republic | 3763 | 59 | 2402 | 1302 | 43.39761470000001 | 45.6985005 | 2020-11-25 05:27:20 | Chechen Republic, Russia | ||
3839753 | 3839753 | 2020-11-21 | US | Vermont | Chittenden | 50007 | 1341 | 39 | 0 | 1302 | 44.46322849 | -73.08359212 | 2020-11-22 05:25:45 | Chittenden, Vermont, US |
3838189 | 3838189 | 2020-11-21 | US | Minnesota | Freeborn | 27047 | 1307 | 5 | 0 | 1302 | 43.67385583 | -93.34884422 | 2020-11-22 05:25:45 | Freeborn, Minnesota, 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]);