johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
132 rows where active = 1690 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 14
- Colombia 4
- Netherlands 3
- India 2
- Senegal 2
- Cabo Verde 1
- Chile 1
- Italy 1
- Jordan 1
- Malaysia 1
- Mauritania 1
- South Sudan 1
- Sweden 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3137624 | 3137624 | 2021-07-23 | Mauritania | 23378 | 520 | 21168 | 1690 | 21.0079 | -10.9408 | 2021-07-24 00:21:36 | Mauritania | |||
483800 | 483800 | 2021-07-19 | Russia | Kemerovo Oblast | 43452 | 914 | 40848 | 1690 | 54.53357809999999 | 87.342861 | 2021-07-20 04:21:48 | Kemerovo Oblast, Russia | ||
50551 | 50551 | 2021-05-29 | Cabo Verde | 30273 | 263 | 28320 | 1690 | 16.5388 | -23.0418 | 2021-05-30 04:20:55 | Cabo Verde | |||
3054387 | 3054387 | 2021-05-13 | Russia | Ingushetia Republic | 15577 | 188 | 13699 | 1690 | 43.11542075 | 45.01713552 | 2021-05-14 04:20:41 | Ingushetia Republic, Russia | ||
1424940 | 1424940 | 2021-05-09 | Colombia | Boyaca | 56995 | 1311 | 53994 | 1690 | 5.4545 | -73.362 | 2021-05-10 04:20:38 | Boyaca, Colombia | ||
887957 | 887957 | 2021-04-26 | Colombia | Boyaca | 52302 | 1225 | 49387 | 1690 | 5.4545 | -73.362 | 2021-04-27 04:20:52 | Boyaca, Colombia | ||
2645999 | 2645999 | 2021-04-08 | Russia | Stavropol Krai | 51160 | 1255 | 48215 | 1690 | 44.86325770000001 | 43.4406913 | 2021-04-09 04:21:13 | Stavropol Krai, Russia | ||
3067838 | 3067838 | 2021-02-27 | US | Mississippi | Stone | 28131 | 1719 | 29 | 0 | 1690 | 30.79187949 | -89.11547539 | 2021-02-28 05:22:20 | Stone, Mississippi, US |
281617 | 281617 | 2021-02-24 | US | Kentucky | McCreary | 21147 | 1710 | 20 | 0 | 1690 | 36.73874143 | -84.48102924 | 2021-02-25 05:24:57 | McCreary, Kentucky, US |
1939132 | 1939132 | 2021-02-23 | US | Pennsylvania | Montour | 42093 | 1748 | 58 | 0 | 1690 | 41.03023987 | -76.66345939 | 2021-02-24 05:29:16 | Montour, Pennsylvania, US |
1936696 | 1936696 | 2021-02-23 | Russia | Smolensk Oblast | 25801 | 592 | 23519 | 1690 | 55.03434960000001 | 33.0192065 | 2021-02-24 05:29:16 | Smolensk Oblast, Russia | ||
1936580 | 1936580 | 2021-02-23 | Netherlands | Unknown | 2147 | 22 | 0 | 1690 | 2021-02-24 05:29:16 | Unknown, Netherlands | ||||
183363 | 183363 | 2021-02-21 | US | Kansas | Pottawatomie | 20149 | 1716 | 26 | 0 | 1690 | 39.37925655 | -96.34564657 | 2021-02-22 05:24:21 | Pottawatomie, Kansas, US |
181986 | 181986 | 2021-02-21 | India | Gujarat | 267104 | 4405 | 261009 | 1690 | 22.694884 | 71.590923 | 2021-02-22 05:24:21 | Gujarat, India | ||
744212 | 744212 | 2021-02-20 | US | Missouri | Henry | 29083 | 1726 | 36 | 0 | 1690 | 38.38482826 | -93.79293734 | 2021-02-21 05:24:33 | Henry, Missouri, US |
743637 | 743637 | 2021-02-20 | US | Kansas | Pottawatomie | 20149 | 1716 | 26 | 0 | 1690 | 39.37925655 | -96.34564657 | 2021-02-21 05:24:33 | Pottawatomie, Kansas, US |
474386 | 474386 | 2021-02-19 | US | Tennessee | Polk | 47139 | 1696 | 21 | 0 | 1690 | 35.12245443 | -84.52075859 | 2021-02-20 05:22:51 | Polk, Tennessee, US |
472824 | 472824 | 2021-02-19 | US | Kentucky | Johnson | 21115 | 1708 | 18 | 0 | 1690 | 37.85106355 | -82.8264322 | 2021-02-20 05:22:51 | Johnson, Kentucky, US |
472735 | 472735 | 2021-02-19 | US | Kansas | Pottawatomie | 20149 | 1716 | 26 | 0 | 1690 | 39.37925655 | -96.34564657 | 2021-02-20 05:22:51 | Pottawatomie, Kansas, US |
1154611 | 1154611 | 2021-02-18 | US | Louisiana | Concordia | 22029 | 1745 | 55 | 0 | 1690 | 31.44817835 | -91.63814433 | 2021-02-19 05:24:16 | Concordia, Louisiana, US |
1153360 | 1153360 | 2021-02-18 | Russia | Ryazan Oblast | 23693 | 272 | 21731 | 1690 | 54.42267320000001 | 40.57052460000001 | 2021-02-19 05:24:16 | Ryazan Oblast, Russia | ||
3053703 | 3053703 | 2021-02-16 | US | Wisconsin | Crawford | 55023 | 1707 | 17 | 0 | 1690 | 43.23870316 | -90.93073686 | 2021-02-17 05:23:10 | Crawford, Wisconsin, US |
2286942 | 2286942 | 2021-02-14 | US | Wisconsin | Adams | 55001 | 1705 | 15 | 0 | 1690 | 43.96974651 | -89.76782777 | 2021-02-15 05:24:49 | Adams, Wisconsin, US |
2679326 | 2679326 | 2021-02-13 | US | Louisiana | Jackson | 22049 | 1735 | 45 | 0 | 1690 | 32.30251776 | -92.55692092 | 2021-02-14 05:23:43 | Jackson, Louisiana, US |
3540959 | 3540959 | 2021-02-12 | US | Louisiana | Jackson | 22049 | 1735 | 45 | 0 | 1690 | 32.30251776 | -92.55692092 | 2021-02-13 05:22:12 | Jackson, Louisiana, US |
2641406 | 2641406 | 2021-02-11 | Malaysia | Sarawak | 6190 | 55 | 4445 | 1690 | 1.5533 | 110.3592 | 2021-02-12 05:23:29 | Sarawak, Malaysia | ||
2640713 | 2640713 | 2021-02-11 | US | Tennessee | Unicoi | 47171 | 1732 | 46 | 0 | 1690 | 36.10890856 | -82.43709629 | 2021-02-12 05:23:29 | Unicoi, Tennessee, US |
2638176 | 2638176 | 2021-02-11 | US | Arkansas | Ashley | 5003 | 1719 | 29 | 0 | 1690 | 33.19153461 | -91.7698471 | 2021-02-12 05:23:29 | Ashley, Arkansas, US |
1531274 | 1531274 | 2021-02-09 | US | Virginia | Page | 51139 | 1731 | 41 | 0 | 1690 | 38.61807452 | -78.48797204 | 2021-02-10 05:22:41 | Page, Virginia, US |
976136 | 976136 | 2021-02-06 | US | Iowa | O'Brien | 19141 | 1748 | 58 | 0 | 1690 | 43.08310673 | -95.62474482 | 2021-02-07 05:23:00 | O'Brien, Iowa, US |
793784 | 793784 | 2021-02-04 | US | Virginia | Southampton | 51175 | 1736 | 46 | 0 | 1690 | 36.72231125 | -77.10642712 | 2021-02-05 05:22:38 | Southampton, Virginia, US |
792169 | 792169 | 2021-02-04 | US | Mississippi | Clay | 28025 | 1735 | 45 | 0 | 1690 | 33.65358105 | -88.77784255 | 2021-02-05 05:22:38 | Clay, Mississippi, US |
1686914 | 1686914 | 2021-02-02 | US | North Dakota | Richland | 38077 | 1713 | 16 | 0 | 1690 | 46.26440649 | -96.94852979 | 2021-02-03 05:22:52 | Richland, North Dakota, US |
1678061 | 1678061 | 2021-02-01 | US | Massachusetts | Franklin | 25011 | 1787 | 67 | 0 | 1690 | 42.58119713 | -72.58602547 | 2021-02-02 05:22:49 | Franklin, Massachusetts, US |
1677994 | 1677994 | 2021-02-01 | US | Louisiana | St. James | 22093 | 1738 | 48 | 0 | 1690 | 30.02531716 | -90.80212061 | 2021-02-02 05:22:49 | St. James, Louisiana, US |
2482209 | 2482209 | 2021-01-28 | Russia | Ryazan Oblast | 21582 | 225 | 19667 | 1690 | 54.42267320000001 | 40.57052460000001 | 2021-01-29 05:22:23 | Ryazan Oblast, Russia | ||
3154058 | 3154058 | 2021-01-27 | US | Arkansas | Arkansas | 5001 | 1726 | 36 | 0 | 1690 | 34.29145151 | -91.37277296 | 2021-01-28 05:22:24 | Arkansas, Arkansas, US |
3153844 | 3153844 | 2021-01-27 | Russia | Ryazan Oblast | 21477 | 223 | 19564 | 1690 | 54.42267320000001 | 40.57052460000001 | 2021-01-28 05:22:24 | Ryazan Oblast, Russia | ||
2570454 | 2570454 | 2021-01-25 | US | South Carolina | Abbeville | 45001 | 1718 | 28 | 0 | 1690 | 34.22333378 | -82.46170658 | 2021-01-26 05:22:02 | Abbeville, South Carolina, US |
2466588 | 2466588 | 2021-01-22 | Chile | Araucania | 29059 | 374 | 26995 | 1690 | -38.9489 | -72.3311 | 2021-01-23 05:22:03 | Araucania, Chile | ||
1095216 | 1095216 | 2021-01-20 | US | Indiana | Starke | 18149 | 1739 | 49 | 0 | 1690 | 41.27890281 | -86.64686895 | 2021-01-21 05:22:01 | Starke, Indiana, US |
240580 | 240580 | 2021-01-18 | US | Virginia | Halifax | 51083 | 1737 | 47 | 0 | 1690 | 36.76654925 | -78.93512622 | 2021-01-19 05:22:15 | Halifax, Virginia, US |
3880109 | 3880109 | 2021-01-14 | US | California | Colusa | 6011 | 1696 | 7 | 0 | 1690 | 39.17881957 | -122.2331726 | 2021-01-15 05:22:24 | Colusa, California, US |
3308983 | 3308983 | 2021-01-13 | US | Georgia | Dodge | 13091 | 1759 | 69 | 0 | 1690 | 32.17265114 | -83.16948926 | 2021-01-14 05:22:32 | Dodge, Georgia, US |
3308668 | 3308668 | 2021-01-13 | US | Arkansas | Columbia | 5027 | 1736 | 46 | 0 | 1690 | 33.21230701 | -93.22642793 | 2021-01-14 05:22:32 | Columbia, Arkansas, US |
190558 | 190558 | 2021-01-11 | US | Arkansas | Lawrence | 5075 | 1729 | 39 | 0 | 1690 | 36.04188196 | -91.10867198 | 2021-01-12 05:22:15 | Lawrence, Arkansas, US |
2626000 | 2626000 | 2021-01-10 | Netherlands | Unknown | 2377 | 36 | 0 | 1690 | 2021-01-11 05:21:50 | Unknown, Netherlands | ||||
3035954 | 3035954 | 2021-01-05 | US | Michigan | Mecosta | 26107 | 1704 | 14 | 0 | 1690 | 43.64064262 | -85.32463223 | 2021-01-06 05:22:16 | Mecosta, Michigan, US |
2229864 | 2229864 | 2021-01-02 | US | North Carolina | Person | 37145 | 1711 | 21 | 0 | 1690 | 36.38989032 | -78.97217358 | 2021-01-03 05:22:52 | Person, North Carolina, US |
768529 | 768529 | 2020-12-29 | US | New York | Allegany | 36003 | 1762 | 72 | 0 | 1690 | 42.25748406 | -78.02750466 | 2020-12-30 05:22:34 | Allegany, New York, US |
767352 | 767352 | 2020-12-29 | US | Illinois | Saline | 17165 | 1721 | 31 | 0 | 1690 | 37.75332999 | -88.54119706 | 2020-12-30 05:22:34 | Saline, Illinois, US |
767168 | 767168 | 2020-12-29 | US | Georgia | Pickens | 13227 | 1709 | 19 | 0 | 1690 | 34.46589159 | -84.46406611 | 2020-12-30 05:22:34 | Pickens, Georgia, US |
2225650 | 2225650 | 2020-12-26 | US | New Hampshire | Belknap | 33001 | 1732 | 42 | 0 | 1690 | 43.51637314 | -71.41684235 | 2020-12-27 05:22:55 | Belknap, New Hampshire, US |
2225615 | 2225615 | 2020-12-26 | US | Nebraska | Saunders | 31155 | 1700 | 10 | 0 | 1690 | 41.2278103 | -96.63773905 | 2020-12-27 05:22:55 | Saunders, Nebraska, US |
204362 | 204362 | 2020-12-25 | US | Nebraska | Saunders | 31155 | 1700 | 10 | 0 | 1690 | 41.2278103 | -96.63773905 | 2020-12-26 05:22:28 | Saunders, Nebraska, US |
3695017 | 3695017 | 2020-12-24 | US | Wisconsin | Iowa | 55049 | 1696 | 6 | 0 | 1690 | 43.00050278 | -90.13469017 | 2020-12-25 05:22:48 | Iowa, Wisconsin, US |
3772824 | 3772824 | 2020-12-22 | US | Tennessee | Johnson | 47091 | 1704 | 27 | 0 | 1690 | 36.45523950000001 | -81.84886538 | 2020-12-23 05:22:03 | Johnson, Tennessee, US |
928888 | 928888 | 2020-12-21 | US | Iowa | Jackson | 19097 | 1719 | 29 | 0 | 1690 | 42.17178824 | -90.57354837 | 2020-12-22 05:22:33 | Jackson, Iowa, US |
2120909 | 2120909 | 2020-12-20 | US | Iowa | Jackson | 19097 | 1719 | 29 | 0 | 1690 | 42.17178824 | -90.57354837 | 2020-12-21 05:27:58 | Jackson, Iowa, US |
2129137 | 2129137 | 2020-12-17 | US | Indiana | Wells | 18179 | 1739 | 49 | 0 | 1690 | 40.72934187 | -85.22132966 | 2020-12-18 05:28:18 | Wells, Indiana, US |
3153194 | 3153194 | 2020-12-16 | US | Wyoming | Park | 56029 | 1697 | 7 | 0 | 1690 | 44.52157546 | -109.5852825 | 2020-12-17 05:28:12 | Park, Wyoming, US |
3152056 | 3152056 | 2020-12-16 | US | Ohio | Highland | 39071 | 1724 | 34 | 0 | 1690 | 39.1839264 | -83.60331456 | 2020-12-17 05:28:12 | Highland, Ohio, US |
1600169 | 1600169 | 2020-12-10 | India | Jharkhand | 111003 | 993 | 108320 | 1690 | 23.654536 | 85.557631 | 2020-12-11 05:26:59 | Jharkhand, India | ||
1819676 | 1819676 | 2020-12-08 | US | Georgia | Wayne | 13305 | 1739 | 49 | 0 | 1690 | 31.5521809 | -81.91894878 | 2020-12-09 05:28:01 | Wayne, Georgia, US |
3863323 | 3863323 | 2020-12-04 | US | West Virginia | Ohio | 54069 | 1708 | 18 | 0 | 1690 | 40.0955451 | -80.62203992 | 2020-12-05 05:27:36 | Ohio, West Virginia, US |
78005 | 78005 | 2020-12-03 | US | Tennessee | Cocke | 47029 | 1725 | 30 | 0 | 1690 | 35.9278914 | -83.11828725 | 2020-12-04 05:27:27 | Cocke, Tennessee, US |
77955 | 77955 | 2020-12-03 | US | South Dakota | Hughes | 46065 | 1709 | 19 | 0 | 1690 | 44.39091534 | -99.99661148 | 2020-12-04 05:27:27 | Hughes, South Dakota, US |
3567570 | 3567570 | 2020-11-29 | US | Illinois | Logan | 17107 | 1701 | 11 | 0 | 1690 | 40.12581572 | -89.36638784 | 2020-11-30 05:26:13 | Logan, Illinois, US |
2938642 | 2938642 | 2020-11-28 | US | Virginia | Washington | 51191 | 1721 | 31 | 0 | 1690 | 36.72341572 | -81.95666289 | 2020-11-29 05:25:55 | Washington, Virginia, US |
393927 | 393927 | 2020-11-27 | US | Minnesota | Carlton | 27017 | 1704 | 14 | 0 | 1690 | 46.59180601 | -92.67601019 | 2020-11-28 05:25:50 | Carlton, Minnesota, US |
393605 | 393605 | 2020-11-27 | US | Kentucky | Calloway | 21035 | 1706 | 16 | 0 | 1690 | 36.62093411 | -88.2731593 | 2020-11-28 05:25:50 | Calloway, Kentucky, US |
679437 | 679437 | 2020-11-23 | US | Indiana | Shelby | 18145 | 1745 | 55 | 0 | 1690 | 39.52305623 | -85.79158570000001 | 2020-11-24 05:27:31 | Shelby, Indiana, US |
2703483 | 2703483 | 2020-11-20 | US | Montana | Big Horn | 30003 | 1738 | 48 | 0 | 1690 | 45.42335905 | -107.492347 | 2020-11-21 05:25:51 | Big Horn, Montana, US |
123395 | 123395 | 2020-11-18 | US | Florida | Hardee | 12049 | 1708 | 18 | 0 | 1690 | 27.49293939 | -81.80956574 | 2020-11-19 05:25:23 | Hardee, Florida, US |
2882918 | 2882918 | 2020-11-15 | US | Puerto Rico | Caguas | 72025 | 1690 | 0 | 0 | 1690 | 18.211615 | -66.050779 | 2020-11-16 05:25:57 | Caguas, Puerto Rico, US |
2880392 | 2880392 | 2020-11-15 | Russia | Belgorod Oblast | 13720 | 64 | 11966 | 1690 | 50.7080119 | 37.5837615 | 2020-11-16 05:25:57 | Belgorod Oblast, Russia | ||
2918490 | 2918490 | 2020-11-14 | US | Virginia | Charlottesville | 51540 | 1721 | 31 | 0 | 1690 | 38.03527919 | -78.48569588 | 2020-11-15 05:26:53 | Charlottesville, Virginia, US |
2916773 | 2916773 | 2020-11-14 | US | Massachusetts | Hampshire | 25015 | 1850 | 126 | 0 | 1690 | 42.33997957 | -72.65898478 | 2020-11-15 05:26:53 | Hampshire, Massachusetts, US |
1546889 | 1546889 | 2020-11-07 | US | Tennessee | Jefferson | 47089 | 1698 | 25 | 0 | 1690 | 36.04818632 | -83.45148924 | 2020-11-08 05:24:56 | Jefferson, Tennessee, US |
2919706 | 2919706 | 2020-11-04 | US | Arkansas | White | 5145 | 1727 | 37 | 0 | 1690 | 35.25688493 | -91.74908296 | 2020-11-05 06:05:03 | White, Arkansas, US |
2246343 | 2246343 | 2020-10-30 | US | Tennessee | McMinn | 47107 | 1763 | 39 | 0 | 1690 | 35.42812616 | -84.61520715 | 2020-10-31 04:24:44 | McMinn, Tennessee, US |
2245318 | 2245318 | 2020-10-30 | US | Missouri | Pettis | 29159 | 1709 | 19 | 0 | 1690 | 38.72798918 | -93.28471706 | 2020-10-31 04:24:44 | Pettis, Missouri, US |
1797846 | 1797846 | 2020-10-19 | US | Texas | Taylor | 48441 | 3174 | 62 | 0 | 1690 | 32.30163422 | -99.89007449 | 2020-10-20 04:24:22 | Taylor, Texas, US |
1794619 | 1794619 | 2020-10-19 | Italy | P.A. Bolzano | 4904 | 294 | 2920 | 1690 | 46.49933453 | 11.35662422 | 2020-10-20 04:24:22 | P.A. Bolzano, Italy | ||
1044495 | 1044495 | 2020-10-07 | US | Pennsylvania | Monroe | 42089 | 1824 | 134 | 0 | 1690 | 41.05934058 | -75.34031025 | 2020-10-08 04:23:56 | Monroe, Pennsylvania, US |
3121020 | 3121020 | 2020-10-06 | US | Wisconsin | Jefferson | 55055 | 1698 | 8 | 0 | 1690 | 43.02054068 | -88.77529134 | 2020-10-07 04:23:40 | Jefferson, Wisconsin, US |
3120466 | 3120466 | 2020-10-06 | US | Tennessee | Trousdale | 47169 | 1691 | 7 | 0 | 1690 | 36.39026213 | -86.16087954 | 2020-10-07 04:23:40 | Trousdale, Tennessee, US |
3119769 | 3119769 | 2020-10-06 | US | North Carolina | Chatham | 37037 | 1749 | 59 | 0 | 1690 | 35.70394416 | -79.25541492 | 2020-10-07 04:23:40 | Chatham, North Carolina, US |
3389739 | 3389739 | 2020-10-02 | US | Alabama | Colbert | 1033 | 1716 | 26 | 0 | 1690 | 34.69847452 | -87.80168544 | 2020-10-03 04:23:40 | Colbert, Alabama, US |
2380725 | 2380725 | 2020-10-01 | US | Indiana | Madison | 18095 | 1769 | 79 | 0 | 1690 | 40.16143691 | -85.71964711 | 2020-10-02 04:23:51 | Madison, Indiana, US |
1518316 | 1518316 | 2020-09-28 | US | Tennessee | Gibson | 47053 | 1716 | 23 | 0 | 1690 | 35.99438059 | -88.93358327 | 2020-09-29 04:23:42 | Gibson, Tennessee, US |
1517698 | 1517698 | 2020-09-28 | US | North Carolina | Granville | 37077 | 1740 | 50 | 0 | 1690 | 36.30337451 | -78.65184241 | 2020-09-29 04:23:42 | Granville, North Carolina, US |
1516118 | 1516118 | 2020-09-28 | US | Florida | Unassigned | 90012 | 1690 | 0 | 0 | 1690 | 30.86747479 | 0.0 | 2020-09-29 04:23:42 | Unassigned, Florida, US |
2607445 | 2607445 | 2020-09-24 | US | Kentucky | Madison | 21151 | 1696 | 6 | 0 | 1690 | 37.71659336 | -84.27220275 | 2020-09-25 04:23:00 | Madison, Kentucky, US |
2607354 | 2607354 | 2020-09-24 | US | Kansas | Seward | 20175 | 1695 | 5 | 0 | 1690 | 37.19324632 | -100.8507201 | 2020-09-25 04:23:00 | Seward, Kansas, US |
2836660 | 2836660 | 2020-09-21 | Colombia | Cauca | 8340 | 226 | 6424 | 1690 | 2.705 | -76.826 | 2020-09-22 04:23:00 | Cauca, Colombia | ||
3093538 | 3093538 | 2020-09-20 | Netherlands | Flevoland | 1790 | 97 | 0 | 1690 | 52.550383 | 5.515162 | 2020-09-21 04:23:00 | Flevoland, Netherlands | ||
1121638 | 1121638 | 2020-09-17 | Jordan | 4131 | 26 | 2415 | 1690 | 31.24 | 36.51 | 2020-09-18 05:05:00 | Jordan | |||
344513 | 344513 | 2020-09-14 | Russia | Sakha (Yakutiya) Republic | 8198 | 90 | 6418 | 1690 | 66.941626 | 129.642371 | 2020-09-15 03:22:50 | Sakha (Yakutiya) Republic, Russia | ||
1444441 | 1444441 | 2020-09-11 | Colombia | Risaralda | 8062 | 168 | 6204 | 1690 | 5.3158 | -75.9928 | 2020-09-12 04:25:05 | Risaralda, Colombia |
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]);