johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
695 rows where active = 297 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 592
- Russia 11
- France 9
- Japan 9
- Tanzania 9
- Germany 5
- India 5
- Malaysia 5
- Chile 4
- China 4
- Latvia 4
- Mexico 4
- Ukraine 4
- Australia 2
- Cabo Verde 2
- Colombia 2
- Cuba 2
- Italy 2
- Netherlands 2
- Singapore 2
- Andorra 1
- Bhutan 1
- Congo (Kinshasa) 1
- Denmark 1
- Eswatini 1
- Georgia 1
- Jordan 1
- Liberia 1
- Liechtenstein 1
- Lithuania 1
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3683499 | 3683499 | 2021-08-02 | Japan | Yamanashi | 2503 | 21 | 2185 | 297 | 35.612364 | 138.61148899999998 | 2021-08-03 04:21:39 | Yamanashi, Japan | ||
3015164 | 3015164 | 2021-08-01 | China | Jiangsu | 1041 | 0 | 744 | 297 | 32.9711 | 119.455 | 2021-08-02 04:21:36 | Jiangsu, China | ||
1330077 | 1330077 | 2021-07-24 | China | Yunnan | 703 | 2 | 404 | 297 | 24.974 | 101.487 | 2021-07-25 04:22:12 | Yunnan, China | ||
3476141 | 3476141 | 2021-07-22 | China | Yunnan | 691 | 2 | 392 | 297 | 24.974 | 101.487 | 2021-07-23 04:21:29 | Yunnan, China | ||
3635597 | 3635597 | 2021-07-14 | Ukraine | Sumy Oblast | 78098 | 1331 | 76470 | 297 | 50.9077 | 34.7981 | 2021-07-15 04:21:48 | Sumy Oblast, Ukraine | ||
3744727 | 3744727 | 2021-07-12 | Ukraine | Zhytomyr Oblast | 88570 | 1794 | 86479 | 297 | 50.2547 | 28.6587 | 2021-07-13 04:21:18 | Zhytomyr Oblast, Ukraine | ||
625800 | 625800 | 2021-07-10 | Germany | Thuringen | 128839 | 4350 | 124200 | 297 | 51.011 | 10.8453 | 2021-07-11 04:21:43 | Thuringen, Germany | ||
1499287 | 1499287 | 2021-07-03 | Malaysia | Terengganu | 11348 | 77 | 10974 | 297 | 5.3117 | 103.1324 | 2021-07-04 04:21:38 | Terengganu, Malaysia | ||
2295460 | 2295460 | 2021-06-24 | Japan | Hiroshima | 11451 | 171 | 10983 | 297 | 34.605309000000005 | 132.788719 | 2021-06-25 04:21:33 | Hiroshima, Japan | ||
2884573 | 2884573 | 2021-06-20 | Russia | Kalmykia Republic | 21202 | 398 | 20507 | 297 | 46.2313018 | 45.3275745 | 2021-06-21 04:21:41 | Kalmykia Republic, Russia | ||
107440 | 107440 | 2021-06-19 | Italy | P.A. Bolzano | 73246 | 1180 | 71769 | 297 | 46.49933453 | 11.35662422 | 2021-06-20 04:21:48 | P.A. Bolzano, Italy | ||
1564274 | 1564274 | 2021-06-14 | Russia | Adygea Republic | 14790 | 218 | 14275 | 297 | 44.6939006 | 40.1520421 | 2021-06-15 04:22:22 | Adygea Republic, Russia | ||
3381436 | 3381436 | 2021-06-13 | Liberia | 2484 | 93 | 2094 | 297 | 6.4280550000000005 | -9.429499 | 2021-06-14 04:22:46 | Liberia | |||
3381411 | 3381411 | 2021-06-13 | Japan | Shiga | 5405 | 84 | 5024 | 297 | 35.21582700000001 | 136.138064 | 2021-06-14 04:22:46 | Shiga, Japan | ||
3145305 | 3145305 | 2021-06-07 | Bhutan | 1703 | 1 | 1405 | 297 | 27.5142 | 90.4336 | 2021-06-08 04:22:35 | Bhutan | |||
3089607 | 3089607 | 2021-05-30 | Russia | Amur Oblast | 22727 | 292 | 22138 | 297 | 52.8032368 | 128.437295 | 2021-05-31 03:08:59 | Amur Oblast, Russia | ||
2450774 | 2450774 | 2021-05-02 | Japan | Aomori | 1620 | 23 | 1300 | 297 | 40.781541 | 140.828896 | 2021-05-03 04:20:39 | Aomori, Japan | ||
1842221 | 1842221 | 2021-04-14 | Singapore | 60719 | 30 | 60392 | 297 | 1.2833 | 103.8333 | 2021-04-15 04:20:54 | Singapore | |||
3710381 | 3710381 | 2021-04-03 | Russia | Sakhalin Oblast | 22052 | 39 | 21716 | 297 | 49.7219665 | 143.448533 | 2021-04-04 04:20:49 | Sakhalin Oblast, Russia | ||
702612 | 702612 | 2021-03-16 | Russia | Kemerovo Oblast | 32546 | 586 | 31663 | 297 | 54.53357809999999 | 87.342861 | 2021-03-17 05:25:07 | Kemerovo Oblast, Russia | ||
1736163 | 1736163 | 2021-03-14 | US | Alaska | Chugach | 2063 | 300 | 3 | 0 | 297 | 61.16666 | -149.9 | 2021-04-02 15:13:53 | Chugach, Alaska, US |
3663815 | 3663815 | 2021-03-09 | Russia | Kemerovo Oblast | 32163 | 568 | 31298 | 297 | 54.53357809999999 | 87.342861 | 2021-03-10 05:24:35 | Kemerovo Oblast, Russia | ||
3669758 | 3669758 | 2021-03-06 | US | Nevada | Mineral | 32021 | 303 | 6 | 0 | 297 | 38.53841696 | -118.4344506 | 2021-03-07 05:21:54 | Mineral, Nevada, US |
3253837 | 3253837 | 2021-03-02 | Andorra | 10908 | 110 | 10501 | 297 | 42.5063 | 1.5218 | 2021-03-03 05:23:28 | Andorra | |||
1001828 | 1001828 | 2021-03-01 | US | Virginia | Rappahannock | 51157 | 299 | 2 | 0 | 297 | 38.68295619 | -78.15826963 | 2021-03-02 05:23:30 | Rappahannock, Virginia, US |
2370886 | 2370886 | 2021-02-28 | US | Virginia | Rappahannock | 51157 | 299 | 2 | 0 | 297 | 38.68295619 | -78.15826963 | 2021-03-01 05:23:01 | Rappahannock, Virginia, US |
3067762 | 3067762 | 2021-02-27 | US | Minnesota | Traverse | 27155 | 302 | 5 | 0 | 297 | 45.77298854 | -96.47062949 | 2021-02-28 05:22:20 | Traverse, Minnesota, US |
2186935 | 2186935 | 2021-02-26 | US | Virginia | King and Queen | 51097 | 303 | 6 | 0 | 297 | 37.71044922 | -76.88689628 | 2021-02-27 05:22:28 | King and Queen, Virginia, US |
283868 | 283868 | 2021-02-24 | Malaysia | Terengganu | 3168 | 11 | 2860 | 297 | 5.3117 | 103.1324 | 2021-02-25 05:24:57 | Terengganu, Malaysia | ||
3540372 | 3540372 | 2021-02-12 | US | Idaho | Boise | 16015 | 299 | 2 | 0 | 297 | 43.98829931 | -115.7309284 | 2021-02-13 05:22:12 | Boise, Idaho, US |
2638582 | 2638582 | 2021-02-11 | US | Georgia | Schley | 13249 | 299 | 2 | 0 | 297 | 32.2654021 | -84.31258912 | 2021-02-12 05:23:29 | Schley, Georgia, US |
1527935 | 1527935 | 2021-02-09 | Japan | Shizuoka | 4776 | 87 | 4392 | 297 | 34.916975 | 138.40778400000002 | 2021-02-10 05:22:41 | Shizuoka, Japan | ||
616451 | 616451 | 2021-02-08 | US | Puerto Rico | Rincon | 72117 | 297 | 0 | 0 | 297 | 18.335443 | -67.23174 | 2021-02-09 05:23:30 | Rincon, Puerto Rico, US |
343360 | 343360 | 2021-02-03 | US | Texas | Garza | 48169 | 506 | 18 | 0 | 297 | 33.17969345 | -101.2984114 | 2021-02-04 05:22:26 | Garza, Texas, US |
1684537 | 1684537 | 2021-02-02 | Japan | Shiga | 2158 | 33 | 1828 | 297 | 35.21582700000001 | 136.138064 | 2021-02-03 05:22:52 | Shiga, Japan | ||
2211693 | 2211693 | 2021-01-30 | Japan | Nagasaki | 1522 | 26 | 1199 | 297 | 33.235712 | 129.608033 | 2021-01-31 05:22:42 | Nagasaki, Japan | ||
1899925 | 1899925 | 2021-01-29 | US | Puerto Rico | Santa Isabel | 72133 | 297 | 0 | 0 | 297 | 17.994525 | -66.388913 | 2021-01-30 05:22:49 | Santa Isabel, Puerto Rico, US |
2483593 | 2483593 | 2021-01-28 | US | Michigan | Federal Correctional Institution (FCI) | 302 | 5 | 0 | 297 | 47.63197653 | 0.0 | 2021-01-29 05:22:23 | Federal Correctional Institution (FCI), Michigan, US | |
3156741 | 3156741 | 2021-01-27 | US | Texas | Kinney | 48271 | 353 | 3 | 0 | 297 | 29.34967888 | -100.4186638 | 2021-01-28 05:22:24 | Kinney, Texas, US |
3155228 | 3155228 | 2021-01-27 | US | Michigan | Federal Correctional Institution (FCI) | 302 | 5 | 0 | 297 | 47.63197653 | 0.0 | 2021-01-28 05:22:24 | Federal Correctional Institution (FCI), Michigan, US | |
13963 | 13963 | 2021-01-26 | US | Michigan | Federal Correctional Institution (FCI) | 302 | 5 | 0 | 297 | 47.63197653 | 0.0 | 2021-01-27 05:23:41 | Federal Correctional Institution (FCI), Michigan, US | |
2569287 | 2569287 | 2021-01-25 | US | Michigan | Federal Correctional Institution (FCI) | 302 | 5 | 0 | 297 | 47.63197653 | 0.0 | 2021-01-26 05:22:02 | Federal Correctional Institution (FCI), Michigan, US | |
1762985 | 1762985 | 2021-01-24 | Malaysia | W.P. Putrajaya | 781 | 6 | 478 | 297 | 2.9264 | 101.6964 | 2021-01-25 05:22:16 | W.P. Putrajaya, Malaysia | ||
1760654 | 1760654 | 2021-01-24 | US | Kentucky | Ballard | 21007 | 300 | 3 | 0 | 297 | 37.05842757 | -88.99427697 | 2021-01-25 05:22:16 | Ballard, Kentucky, US |
1760445 | 1760445 | 2021-01-24 | US | Iowa | Adams | 19003 | 300 | 3 | 0 | 297 | 41.02903567 | -94.69932645 | 2021-01-25 05:22:16 | Adams, Iowa, US |
2467233 | 2467233 | 2021-01-22 | US | Alaska | Sitka | 2220 | 297 | 0 | 0 | 297 | 57.24124555 | -135.3206587 | 2021-01-23 05:22:03 | Sitka, Alaska, US |
435784 | 435784 | 2021-01-21 | US | Alaska | Sitka | 2220 | 297 | 0 | 0 | 297 | 57.24124555 | -135.3206587 | 2021-01-22 05:22:10 | Sitka, Alaska, US |
1095072 | 1095072 | 2021-01-20 | US | Illinois | Hardin | 17069 | 305 | 8 | 0 | 297 | 37.51810645 | -88.26873022 | 2021-01-21 05:22:01 | Hardin, Illinois, US |
908140 | 908140 | 2021-01-19 | India | Puducherry | 38706 | 643 | 37766 | 297 | 11.882658 | 78.86498 | 2021-01-20 05:21:54 | Puducherry, India | ||
240707 | 240707 | 2021-01-18 | US | West Virginia | Clay | 54015 | 301 | 4 | 0 | 297 | 38.46231092 | -81.07652217 | 2021-01-19 05:22:15 | Clay, West Virginia, US |
776012 | 776012 | 2021-01-12 | US | Michigan | Ontonagon | 26131 | 313 | 16 | 0 | 297 | 46.665226200000006 | -89.31390481 | 2021-01-13 05:22:15 | Ontonagon, Michigan, US |
192253 | 192253 | 2021-01-11 | US | New Mexico | Guadalupe | 35019 | 303 | 6 | 0 | 297 | 34.86319296 | -104.790669 | 2021-01-12 05:22:15 | Guadalupe, New Mexico, US |
2629025 | 2629025 | 2021-01-10 | US | Texas | Marion | 48315 | 398 | 19 | 0 | 297 | 32.79868409 | -94.3566123 | 2021-01-11 05:21:50 | Marion, Texas, US |
2628004 | 2628004 | 2021-01-10 | US | Nevada | Lincoln | 32017 | 298 | 1 | 0 | 297 | 37.64268459 | -114.8790388 | 2021-01-11 05:21:50 | Lincoln, Nevada, US |
3902092 | 3902092 | 2021-01-09 | US | Nevada | Lincoln | 32017 | 298 | 1 | 0 | 297 | 37.64268459 | -114.8790388 | 2021-01-10 05:22:12 | Lincoln, Nevada, US |
2544308 | 2544308 | 2021-01-07 | US | South Dakota | Ziebach | 46137 | 305 | 8 | 0 | 297 | 44.97881876 | -101.6654622 | 2021-01-08 05:22:42 | Ziebach, South Dakota, US |
2544172 | 2544172 | 2021-01-07 | US | Puerto Rico | San German | 72125 | 297 | 0 | 0 | 297 | 18.111484 | -67.03858100000001 | 2021-01-08 05:22:42 | San German, Puerto Rico, US |
2866080 | 2866080 | 2021-01-06 | US | Kentucky | Bracken | 21023 | 300 | 3 | 0 | 297 | 38.69158994 | -84.08532444 | 2021-01-07 05:22:03 | Bracken, Kentucky, US |
3232544 | 3232544 | 2021-01-03 | US | Nebraska | Nuckolls | 31129 | 298 | 1 | 0 | 297 | 40.17637905 | -98.04743961 | 2021-01-04 05:22:02 | Nuckolls, Nebraska, US |
3232117 | 3232117 | 2021-01-03 | US | Michigan | Oscoda | 26135 | 313 | 16 | 0 | 297 | 44.68192279 | -84.12939244 | 2021-01-04 05:22:02 | Oscoda, Michigan, US |
2229495 | 2229495 | 2021-01-02 | US | Montana | Broadwater | 30007 | 298 | 1 | 0 | 297 | 46.33277565 | -111.4955813 | 2021-01-03 05:22:52 | Broadwater, Montana, US |
2229472 | 2229472 | 2021-01-02 | US | Missouri | Shelby | 29205 | 301 | 4 | 0 | 297 | 39.79742518 | -92.07634971 | 2021-01-03 05:22:52 | Shelby, Missouri, US |
2229186 | 2229186 | 2021-01-02 | US | Michigan | Oscoda | 26135 | 313 | 16 | 0 | 297 | 44.68192279 | -84.12939244 | 2021-01-03 05:22:52 | Oscoda, Michigan, US |
1139772 | 1139772 | 2021-01-01 | US | South Dakota | Potter | 46107 | 300 | 3 | 0 | 297 | 45.06583079 | -99.95498503 | 2021-01-02 05:22:33 | Potter, South Dakota, US |
1139642 | 1139642 | 2021-01-01 | US | Puerto Rico | Penuelas | 72111 | 297 | 0 | 0 | 297 | 18.059645 | -66.721572 | 2021-01-02 05:22:33 | Penuelas, Puerto Rico, US |
1138356 | 1138356 | 2021-01-01 | US | Kentucky | Wolfe | 21237 | 300 | 3 | 0 | 297 | 37.73941626 | -83.49303612 | 2021-01-02 05:22:33 | Wolfe, Kentucky, US |
3698951 | 3698951 | 2020-12-31 | US | West Virginia | Braxton | 54007 | 298 | 1 | 0 | 297 | 38.70036159 | -80.72011184 | 2021-01-01 05:23:07 | Braxton, West Virginia, US |
3698378 | 3698378 | 2020-12-31 | US | South Dakota | Potter | 46107 | 300 | 3 | 0 | 297 | 45.06583079 | -99.95498503 | 2021-01-01 05:23:07 | Potter, South Dakota, US |
3698248 | 3698248 | 2020-12-31 | US | Puerto Rico | Penuelas | 72111 | 297 | 0 | 0 | 297 | 18.059645 | -66.721572 | 2021-01-01 05:23:07 | Penuelas, Puerto Rico, US |
3696962 | 3696962 | 2020-12-31 | US | Kentucky | Wolfe | 21237 | 300 | 3 | 0 | 297 | 37.73941626 | -83.49303612 | 2021-01-01 05:23:07 | Wolfe, Kentucky, US |
1011777 | 1011777 | 2020-12-30 | US | Kentucky | Wolfe | 21237 | 300 | 3 | 0 | 297 | 37.73941626 | -83.49303612 | 2020-12-31 05:22:49 | Wolfe, Kentucky, US |
768698 | 768698 | 2020-12-29 | US | North Dakota | Bowman | 38011 | 302 | 4 | 0 | 297 | 46.11285362 | -103.5203343 | 2020-12-30 05:22:34 | Bowman, North Dakota, US |
768639 | 768639 | 2020-12-29 | US | North Carolina | Hyde | 37095 | 302 | 5 | 0 | 297 | 35.42017674 | -76.15180542 | 2020-12-30 05:22:34 | Hyde, North Carolina, US |
767792 | 767792 | 2020-12-29 | US | Kentucky | Wolfe | 21237 | 300 | 3 | 0 | 297 | 37.73941626 | -83.49303612 | 2020-12-30 05:22:34 | Wolfe, Kentucky, US |
766346 | 766346 | 2020-12-29 | Japan | Nagasaki | 611 | 3 | 311 | 297 | 33.235712 | 129.608033 | 2020-12-30 05:22:34 | Nagasaki, Japan | ||
3764472 | 3764472 | 2020-12-28 | US | South Dakota | Potter | 46107 | 299 | 2 | 0 | 297 | 45.06583079 | -99.95498503 | 2020-12-29 05:22:37 | Potter, South Dakota, US |
3763605 | 3763605 | 2020-12-28 | US | Montana | Teton | 30099 | 300 | 3 | 0 | 297 | 47.83741052 | -112.2410688 | 2020-12-29 05:22:37 | Teton, Montana, US |
3779925 | 3779925 | 2020-12-27 | US | Montana | Teton | 30099 | 300 | 3 | 0 | 297 | 47.83741052 | -112.2410688 | 2020-12-28 05:22:06 | Teton, Montana, US |
2225887 | 2225887 | 2020-12-26 | US | North Dakota | Bowman | 38011 | 300 | 4 | 0 | 297 | 46.11285362 | -103.5203343 | 2020-12-27 05:22:55 | Bowman, North Dakota, US |
2225530 | 2225530 | 2020-12-26 | US | Montana | Teton | 30099 | 300 | 3 | 0 | 297 | 47.83741052 | -112.2410688 | 2020-12-27 05:22:55 | Teton, Montana, US |
3694979 | 3694979 | 2020-12-24 | US | West Virginia | Ritchie | 54085 | 304 | 7 | 0 | 297 | 39.18094587 | -81.06356878 | 2020-12-25 05:22:48 | Ritchie, West Virginia, US |
2410107 | 2410107 | 2020-12-23 | US | Vermont | Orange | 50017 | 298 | 1 | 0 | 297 | 44.00470222 | -72.37640104 | 2020-12-24 05:23:04 | Orange, Vermont, US |
3773153 | 3773153 | 2020-12-22 | US | Vermont | Orange | 50017 | 298 | 1 | 0 | 297 | 44.00470222 | -72.37640104 | 2020-12-23 05:22:03 | Orange, Vermont, US |
3772767 | 3772767 | 2020-12-22 | US | South Dakota | Sanborn | 46111 | 300 | 3 | 0 | 297 | 44.02351092 | -98.0909816 | 2020-12-23 05:22:03 | Sanborn, South Dakota, US |
3770912 | 3770912 | 2020-12-22 | US | Illinois | Scott | 17171 | 298 | 1 | 0 | 297 | 39.6429169 | -90.47814431 | 2020-12-23 05:22:03 | Scott, Illinois, US |
930969 | 930969 | 2020-12-21 | US | Vermont | Orange | 50017 | 298 | 1 | 0 | 297 | 44.00470222 | -72.37640104 | 2020-12-22 05:22:33 | Orange, Vermont, US |
930583 | 930583 | 2020-12-21 | US | South Dakota | Sanborn | 46111 | 300 | 3 | 0 | 297 | 44.02351092 | -98.0909816 | 2020-12-22 05:22:33 | Sanborn, South Dakota, US |
930551 | 930551 | 2020-12-21 | US | South Dakota | Faulk | 46049 | 307 | 10 | 0 | 297 | 45.07082625 | -99.14535601 | 2020-12-22 05:22:33 | Faulk, South Dakota, US |
2122604 | 2122604 | 2020-12-20 | US | South Dakota | Sanborn | 46111 | 300 | 3 | 0 | 297 | 44.02351092 | -98.0909816 | 2020-12-21 05:27:58 | Sanborn, South Dakota, US |
2122572 | 2122572 | 2020-12-20 | US | South Dakota | Faulk | 46049 | 307 | 10 | 0 | 297 | 45.07082625 | -99.14535601 | 2020-12-21 05:27:58 | Faulk, South Dakota, US |
2934111 | 2934111 | 2020-12-19 | US | South Dakota | Sanborn | 46111 | 300 | 3 | 0 | 297 | 44.02351092 | -98.0909816 | 2020-12-20 05:27:32 | Sanborn, South Dakota, US |
2934085 | 2934085 | 2020-12-19 | US | South Dakota | Hanson | 46061 | 300 | 3 | 0 | 297 | 43.6746384 | -97.78715148 | 2020-12-20 05:27:32 | Hanson, South Dakota, US |
2934079 | 2934079 | 2020-12-19 | US | South Dakota | Faulk | 46049 | 307 | 10 | 0 | 297 | 45.07082625 | -99.14535601 | 2020-12-20 05:27:32 | Faulk, South Dakota, US |
2932249 | 2932249 | 2020-12-19 | US | Illinois | Putnam | 17155 | 297 | 0 | 0 | 297 | 41.2013541 | -89.2869272 | 2020-12-20 05:27:32 | Putnam, Illinois, US |
1904057 | 1904057 | 2020-12-18 | US | South Dakota | Sanborn | 46111 | 300 | 3 | 0 | 297 | 44.02351092 | -98.0909816 | 2020-12-19 05:27:52 | Sanborn, South Dakota, US |
1904031 | 1904031 | 2020-12-18 | US | South Dakota | Hanson | 46061 | 300 | 3 | 0 | 297 | 43.6746384 | -97.78715148 | 2020-12-19 05:27:52 | Hanson, South Dakota, US |
1904025 | 1904025 | 2020-12-18 | US | South Dakota | Faulk | 46049 | 307 | 10 | 0 | 297 | 45.07082625 | -99.14535601 | 2020-12-19 05:27:52 | Faulk, South Dakota, US |
1903565 | 1903565 | 2020-12-18 | US | North Dakota | McIntosh | 38051 | 303 | 7 | 0 | 297 | 46.11182017 | -99.44145858 | 2020-12-19 05:27:52 | McIntosh, North Dakota, US |
1903475 | 1903475 | 2020-12-18 | US | North Carolina | Gates | 37073 | 308 | 11 | 0 | 297 | 36.44667547 | -76.69749701 | 2020-12-19 05:27:52 | Gates, North Carolina, US |
2130883 | 2130883 | 2020-12-17 | US | South Dakota | Sanborn | 46111 | 300 | 3 | 0 | 297 | 44.02351092 | -98.0909816 | 2020-12-18 05:28:18 | Sanborn, South Dakota, 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]);