johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
126 rows where active = 1483 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2884589 | 2884589 | 2021-06-20 | Russia | Leningrad Oblast | 47226 | 1654 | 44089 | 1483 | 60.1853296 | 32.3925325 | 2021-06-21 04:21:41 | Leningrad Oblast, Russia | ||
1409157 | 1409157 | 2021-04-23 | Namibia | 47383 | 622 | 45278 | 1483 | -22.9576 | 18.4904 | 2021-04-24 04:20:38 | Namibia | |||
3670893 | 3670893 | 2021-03-06 | US | Vermont | Bennington | 50003 | 1492 | 9 | 0 | 1483 | 43.03519828 | -73.09048868 | 2021-03-07 05:21:54 | Bennington, Vermont, US |
1619393 | 1619393 | 2021-03-05 | US | Texas | Llano | 48299 | 1701 | 48 | 0 | 1483 | 30.70645047 | -98.68475262 | 2021-03-06 04:23:41 | Llano, Texas, US |
2209325 | 2209325 | 2021-03-04 | US | Michigan | Out of MI | 80026 | 1494 | 11 | 0 | 1483 | 47.63197653 | 0.0 | 2021-03-05 05:26:29 | Out of MI, Michigan, US |
2208336 | 2208336 | 2021-03-04 | US | Florida | Dixie | 12029 | 1504 | 21 | 0 | 1483 | 29.60631086 | -83.15724673 | 2021-03-05 05:26:29 | Dixie, Florida, US |
2208173 | 2208173 | 2021-03-04 | US | Arkansas | Sharp | 5135 | 1528 | 45 | 0 | 1483 | 36.16258158 | -91.47819342 | 2021-03-05 05:26:29 | Sharp, Arkansas, US |
1939596 | 1939596 | 2021-02-23 | US | Texas | Leon | 48289 | 1876 | 36 | 0 | 1483 | 31.29872538 | -95.9936328 | 2021-02-24 05:29:16 | Leon, Texas, US |
533851 | 533851 | 2021-02-22 | US | Texas | Leon | 48289 | 1876 | 36 | 0 | 1483 | 31.29872538 | -95.9936328 | 2021-02-23 05:23:41 | Leon, Texas, US |
745359 | 745359 | 2021-02-20 | US | Texas | Colorado | 48089 | 1534 | 24 | 0 | 1483 | 29.622098 | -96.5273805 | 2021-02-21 05:24:33 | Colorado, Texas, US |
745260 | 745260 | 2021-02-20 | US | Tennessee | Humphreys | 47085 | 1536 | 21 | 0 | 1483 | 36.03958805 | -87.77992872 | 2021-02-21 05:24:33 | Humphreys, Tennessee, US |
474457 | 474457 | 2021-02-19 | US | Texas | Colorado | 48089 | 1534 | 24 | 0 | 1483 | 29.622098 | -96.5273805 | 2021-02-20 05:22:51 | Colorado, Texas, US |
1156166 | 1156166 | 2021-02-18 | US | Texas | Colorado | 48089 | 1534 | 24 | 0 | 1483 | 29.622098 | -96.5273805 | 2021-02-19 05:24:16 | Colorado, Texas, US |
1154792 | 1154792 | 2021-02-18 | US | Michigan | Out of MI | 80026 | 1494 | 11 | 0 | 1483 | 47.63197653 | 0.0 | 2021-02-19 05:24:16 | Out of MI, Michigan, US |
3540315 | 3540315 | 2021-02-12 | US | Georgia | Rabun | 13241 | 1521 | 38 | 0 | 1483 | 34.88389445 | -83.40304637 | 2021-02-13 05:22:12 | Rabun, Georgia, US |
978316 | 978316 | 2021-02-06 | US | Virginia | Scott | 51169 | 1528 | 45 | 0 | 1483 | 36.71466456 | -82.60171704 | 2021-02-07 05:23:00 | Scott, Virginia, US |
977842 | 977842 | 2021-02-06 | US | Tennessee | Decatur | 47039 | 1521 | 32 | 0 | 1483 | 35.60048904 | -88.11043779 | 2021-02-07 05:23:00 | Decatur, Tennessee, US |
1591628 | 1591628 | 2021-02-05 | US | Washington | Stevens | 53065 | 1505 | 22 | 0 | 1483 | 48.40035475 | -117.8542701 | 2021-02-06 05:23:55 | Stevens, Washington, US |
342967 | 342967 | 2021-02-03 | US | Pennsylvania | Susquehanna | 42115 | 1532 | 49 | 0 | 1483 | 41.82147784 | -75.80071959 | 2021-02-04 05:22:26 | Susquehanna, Pennsylvania, US |
1688010 | 1688010 | 2021-02-02 | US | West Virginia | Upshur | 54097 | 1506 | 23 | 0 | 1483 | 38.89285061 | -80.23689136 | 2021-02-03 05:22:52 | Upshur, West Virginia, US |
1462751 | 1462751 | 2021-01-31 | US | Tennessee | Union | 47173 | 1570 | 25 | 0 | 1483 | 36.28590426 | -83.83651902 | 2021-02-01 05:22:53 | Union, Tennessee, US |
1897900 | 1897900 | 2021-01-29 | US | Georgia | Berrien | 13019 | 1518 | 35 | 0 | 1483 | 31.27590016 | -83.22529920000002 | 2021-01-30 05:22:49 | Berrien, Georgia, US |
2570025 | 2570025 | 2021-01-25 | US | North Carolina | Transylvania | 37175 | 1497 | 14 | 0 | 1483 | 35.20383864 | -82.79638423 | 2021-01-26 05:22:02 | Transylvania, North Carolina, US |
1762270 | 1762270 | 2021-01-24 | US | Tennessee | Polk | 47139 | 1471 | 17 | 0 | 1483 | 35.12245443 | -84.52075859 | 2021-01-25 05:22:16 | Polk, Tennessee, US |
438833 | 438833 | 2021-01-21 | US | West Virginia | Jackson | 54035 | 1526 | 43 | 0 | 1483 | 38.84263974 | -81.68148753 | 2021-01-22 05:22:10 | Jackson, West Virginia, US |
436057 | 436057 | 2021-01-21 | US | Florida | Lafayette | 12067 | 1506 | 23 | 0 | 1483 | 29.98484137 | -83.18166636 | 2021-01-22 05:22:10 | Lafayette, Florida, US |
910967 | 910967 | 2021-01-19 | US | South Carolina | Abbeville | 45001 | 1510 | 27 | 0 | 1483 | 34.22333378 | -82.46170658 | 2021-01-20 05:21:54 | Abbeville, South Carolina, US |
910226 | 910226 | 2021-01-19 | US | Nebraska | Colfax | 31037 | 1502 | 19 | 0 | 1483 | 41.57486951 | -97.0868542 | 2021-01-20 05:21:54 | Colfax, Nebraska, US |
239289 | 239289 | 2021-01-18 | US | Nebraska | Colfax | 31037 | 1502 | 19 | 0 | 1483 | 41.57486951 | -97.0868542 | 2021-01-19 05:22:15 | Colfax, Nebraska, US |
3505406 | 3505406 | 2021-01-17 | US | Nebraska | Colfax | 31037 | 1502 | 19 | 0 | 1483 | 41.57486951 | -97.0868542 | 2021-01-18 05:22:34 | Colfax, Nebraska, US |
3504671 | 3504671 | 2021-01-17 | US | Kansas | Neosho | 20133 | 1497 | 14 | 0 | 1483 | 37.55862897 | -95.30670046 | 2021-01-18 05:22:34 | Neosho, Kansas, US |
3102754 | 3102754 | 2021-01-16 | US | Kansas | Neosho | 20133 | 1497 | 14 | 0 | 1483 | 37.55862897 | -95.30670046 | 2021-01-17 05:22:17 | Neosho, Kansas, US |
3101949 | 3101949 | 2021-01-16 | US | Arkansas | Polk | 5113 | 1534 | 51 | 0 | 1483 | 34.48254879 | -94.22728802 | 2021-01-17 05:22:17 | Polk, Arkansas, US |
3516716 | 3516716 | 2021-01-15 | US | Kansas | Neosho | 20133 | 1497 | 14 | 0 | 1483 | 37.55862897 | -95.30670046 | 2021-01-16 05:22:40 | Neosho, Kansas, US |
192533 | 192533 | 2021-01-11 | US | Ohio | Hocking | 39073 | 1530 | 47 | 0 | 1483 | 39.49537927 | -82.47991446 | 2021-01-12 05:22:15 | Hocking, Ohio, US |
2628280 | 2628280 | 2021-01-10 | US | North Dakota | Ramsey | 38071 | 1490 | 28 | 0 | 1483 | 48.26886249 | -98.72223879 | 2021-01-11 05:21:50 | Ramsey, North Dakota, US |
3901148 | 3901148 | 2021-01-09 | US | Iowa | Hardin | 19083 | 1512 | 29 | 0 | 1483 | 42.38353877 | -93.23654611 | 2021-01-10 05:22:12 | Hardin, Iowa, US |
3900450 | 3900450 | 2021-01-09 | US | Arkansas | Lee | 5077 | 1511 | 28 | 0 | 1483 | 34.78498904 | -90.78383866 | 2021-01-10 05:22:12 | Lee, Arkansas, US |
156797 | 156797 | 2021-01-08 | US | South Carolina | Jasper | 45053 | 1509 | 26 | 0 | 1483 | 32.43171982 | -81.02487495 | 2021-01-09 05:22:18 | Jasper, South Carolina, US |
155162 | 155162 | 2021-01-08 | US | Iowa | Fayette | 19065 | 1505 | 22 | 0 | 1483 | 42.86271799 | -91.8441231 | 2021-01-09 05:22:18 | Fayette, Iowa, US |
1065310 | 1065310 | 2021-01-04 | US | West Virginia | Brooke | 54009 | 1510 | 27 | 0 | 1483 | 40.27367263 | -80.57915332 | 2021-01-05 05:21:49 | Brooke, West Virginia, US |
2229401 | 2229401 | 2021-01-02 | US | Missouri | Cooper | 29053 | 1503 | 20 | 0 | 1483 | 38.844478 | -92.80896081 | 2021-01-03 05:22:52 | Cooper, Missouri, US |
3762290 | 3762290 | 2020-12-28 | US | Florida | Madison | 12079 | 1516 | 33 | 0 | 1483 | 30.44396917 | -83.47398594 | 2020-12-29 05:22:37 | Madison, Florida, US |
3779701 | 3779701 | 2020-12-27 | US | Mississippi | Holmes | 28051 | 1547 | 64 | 0 | 1483 | 33.12345854 | -90.08923538 | 2020-12-28 05:22:06 | Holmes, Mississippi, US |
3778091 | 3778091 | 2020-12-27 | Russia | Belgorod Oblast | 21082 | 240 | 19359 | 1483 | 50.7080119 | 37.5837615 | 2020-12-28 05:22:06 | Belgorod Oblast, Russia | ||
202124 | 202124 | 2020-12-25 | Congo (Brazzaville) | 6571 | 100 | 4988 | 1483 | -0.228 | 15.8277 | 2020-12-26 05:22:28 | Congo (Brazzaville) | |||
3691347 | 3691347 | 2020-12-24 | Congo (Brazzaville) | 6571 | 100 | 4988 | 1483 | -0.228 | 15.8277 | 2020-12-25 05:22:48 | Congo (Brazzaville) | |||
2406699 | 2406699 | 2020-12-23 | Congo (Brazzaville) | 6571 | 100 | 4988 | 1483 | -0.228 | 15.8277 | 2020-12-24 05:23:04 | Congo (Brazzaville) | |||
3769745 | 3769745 | 2020-12-22 | Congo (Brazzaville) | 6571 | 100 | 4988 | 1483 | -0.228 | 15.8277 | 2020-12-23 05:22:03 | Congo (Brazzaville) | |||
928860 | 928860 | 2020-12-21 | US | Iowa | Clay | 19041 | 1494 | 11 | 0 | 1483 | 43.08247182 | -95.15096481 | 2020-12-22 05:22:33 | Clay, Iowa, US |
2121442 | 2121442 | 2020-12-20 | US | Minnesota | Martin | 27091 | 1506 | 23 | 0 | 1483 | 43.67429718 | -94.55099908 | 2020-12-21 05:27:58 | Martin, Minnesota, US |
2120756 | 2120756 | 2020-12-20 | US | Illinois | Union | 17181 | 1511 | 28 | 0 | 1483 | 37.47119609 | -89.25548938 | 2020-12-21 05:27:58 | Union, Illinois, US |
2933164 | 2933164 | 2020-12-19 | US | Missouri | Randolph | 29175 | 1498 | 15 | 0 | 1483 | 39.44007257 | -92.4971374 | 2020-12-20 05:27:32 | Randolph, Missouri, US |
2129201 | 2129201 | 2020-12-17 | US | Iowa | Mahaska | 19123 | 1515 | 32 | 0 | 1483 | 41.33521503 | -92.64083907 | 2020-12-18 05:28:18 | Mahaska, Iowa, US |
1752920 | 1752920 | 2020-12-14 | US | Michigan | Menominee | 26109 | 1505 | 22 | 0 | 1483 | 45.58038692 | -87.55370409 | 2020-12-15 05:26:38 | Menominee, Michigan, US |
1751463 | 1751463 | 2020-12-14 | Russia | Ingushetia Republic | 10642 | 123 | 9036 | 1483 | 43.11542075 | 45.01713552 | 2020-12-15 05:26:38 | Ingushetia Republic, Russia | ||
849095 | 849095 | 2020-12-12 | US | Wisconsin | Crawford | 55023 | 1493 | 10 | 0 | 1483 | 43.23870316 | -90.93073686 | 2020-12-13 05:27:20 | Crawford, Wisconsin, US |
1603757 | 1603757 | 2020-12-10 | US | Wisconsin | Iowa | 55049 | 1489 | 6 | 0 | 1483 | 43.00050278 | -90.13469017 | 2020-12-11 05:26:59 | Iowa, Wisconsin, US |
1635105 | 1635105 | 2020-12-05 | US | South Carolina | Colleton | 45029 | 1534 | 51 | 0 | 1483 | 32.87582989 | -80.67641292 | 2020-12-06 05:26:18 | Colleton, South Carolina, US |
1634860 | 1634860 | 2020-12-05 | US | Oklahoma | Lincoln | 40081 | 1509 | 26 | 0 | 1483 | 35.70270942 | -96.8812462 | 2020-12-06 05:26:18 | Lincoln, Oklahoma, US |
3863214 | 3863214 | 2020-12-04 | US | Virginia | Prince George | 51149 | 1490 | 7 | 0 | 1483 | 37.18497668 | -77.22922187 | 2020-12-05 05:27:36 | Prince George, Virginia, US |
2537945 | 2537945 | 2020-12-01 | US | California | Mendocino | 6045 | 1507 | 23 | 0 | 1483 | 39.4381191 | -123.3911313 | 2020-12-02 05:27:41 | Mendocino, California, US |
1586268 | 1586268 | 2020-11-30 | US | Nebraska | Saline | 31151 | 1486 | 3 | 0 | 1483 | 40.52418865 | -97.14085859 | 2020-12-01 05:26:18 | Saline, Nebraska, US |
1352591 | 1352591 | 2020-11-24 | US | North Carolina | Alexander | 37003 | 1498 | 15 | 0 | 1483 | 35.922379600000006 | -81.17751948 | 2020-11-25 05:27:20 | Alexander, North Carolina, US |
681000 | 681000 | 2020-11-23 | US | Pennsylvania | Somerset | 42111 | 1492 | 9 | 0 | 1483 | 39.97172723 | -79.02699593 | 2020-11-24 05:27:31 | Somerset, Pennsylvania, US |
124549 | 124549 | 2020-11-18 | US | Mississippi | Union | 28145 | 1508 | 25 | 0 | 1483 | 34.49162015 | -89.00776006 | 2020-11-19 05:25:23 | Union, Mississippi, US |
3172966 | 3172966 | 2020-11-16 | US | Virginia | Frederick | 51069 | 1499 | 16 | 0 | 1483 | 39.20172582 | -78.25974949 | 2020-11-17 05:25:54 | Frederick, Virginia, US |
3172576 | 3172576 | 2020-11-16 | US | Tennessee | Haywood | 47075 | 1501 | 28 | 0 | 1483 | 35.58332824 | -89.28536625 | 2020-11-17 05:25:54 | Haywood, Tennessee, US |
2882174 | 2882174 | 2020-11-15 | US | Missouri | Webster | 29225 | 1506 | 23 | 0 | 1483 | 37.2813734 | -92.876329 | 2020-11-16 05:25:57 | Webster, Missouri, US |
2917152 | 2917152 | 2020-11-14 | US | Missouri | Webster | 29225 | 1506 | 23 | 0 | 1483 | 37.2813734 | -92.876329 | 2020-11-15 05:26:53 | Webster, Missouri, US |
1731583 | 1731583 | 2020-11-08 | US | Texas | Harrison | 48203 | 1249 | 39 | 0 | 1483 | 32.54935988 | -94.36934071 | 2020-11-09 05:25:45 | Harrison, Texas, US |
1546883 | 1546883 | 2020-11-07 | US | Tennessee | Henderson | 47077 | 1500 | 29 | 0 | 1483 | 35.65581134 | -88.38600175 | 2020-11-08 05:24:56 | Henderson, Tennessee, US |
895649 | 895649 | 2020-11-05 | US | Wisconsin | Dunn | 55033 | 1484 | 1 | 0 | 1483 | 44.94562799 | -91.8962481 | 2020-11-06 05:24:55 | Dunn, Wisconsin, US |
2920950 | 2920950 | 2020-11-04 | US | Minnesota | Winona | 27169 | 1503 | 20 | 0 | 1483 | 43.98772283 | -91.78081305 | 2020-11-05 06:05:03 | Winona, Minnesota, US |
2500331 | 2500331 | 2020-11-03 | US | North Carolina | Halifax | 37083 | 1511 | 28 | 0 | 1483 | 36.25669272 | -77.6556109 | 2020-11-04 05:25:09 | Halifax, North Carolina, US |
3304921 | 3304921 | 2020-11-02 | US | Florida | Taylor | 12123 | 1501 | 18 | 0 | 1483 | 30.04848048 | -83.60445406 | 2020-11-03 06:00:16 | Taylor, Florida, US |
2082057 | 2082057 | 2020-10-31 | US | Nevada | Elko | 32007 | 1497 | 14 | 0 | 1483 | 41.14531606 | -115.3577619 | 2020-11-01 04:36:19 | Elko, Nevada, US |
210763 | 210763 | 2020-10-29 | US | Arkansas | White | 5145 | 1516 | 33 | 0 | 1483 | 35.25688493 | -91.74908296 | 2020-10-30 04:24:49 | White, Arkansas, US |
1452906 | 1452906 | 2020-10-27 | Sweden | Varmland | 1558 | 75 | 0 | 1483 | 59.7294 | 13.2354 | 2020-10-28 04:24:39 | Varmland, Sweden | ||
3480221 | 3480221 | 2020-10-26 | Germany | Brandenburg | 6515 | 184 | 5203 | 1483 | 52.4125 | 12.5316 | 2020-10-27 04:24:45 | Brandenburg, Germany | ||
3993914 | 3993914 | 2020-10-20 | US | Virginia | Charlottesville | 51540 | 1515 | 32 | 0 | 1483 | 38.03527919 | -78.48569588 | 2020-10-21 04:24:14 | Charlottesville, Virginia, US |
2857092 | 2857092 | 2020-10-16 | Russia | Tambov Oblast | 8632 | 46 | 7103 | 1483 | 52.9019574 | 41.3578918 | 2020-10-17 04:24:12 | Tambov Oblast, Russia | ||
81853 | 81853 | 2020-10-14 | US | Puerto Rico | Toa Alta | 72135 | 1483 | 0 | 0 | 1483 | 18.362406 | -66.246616 | 2020-10-15 04:24:28 | Toa Alta, Puerto Rico, US |
79955 | 79955 | 2020-10-14 | US | Georgia | Thomas | 13275 | 1551 | 68 | 0 | 1483 | 30.86392347 | -83.91847289 | 2020-10-15 04:24:28 | Thomas, Georgia, US |
819911 | 819911 | 2020-10-09 | US | North Carolina | Rockingham | 37157 | 1500 | 17 | 0 | 1483 | 36.39593137 | -79.77504841 | 2020-10-10 04:23:57 | Rockingham, North Carolina, US |
817923 | 817923 | 2020-10-09 | US | Alabama | Dale | 1045 | 1532 | 49 | 0 | 1483 | 31.43037123 | -85.61095742 | 2020-10-10 04:23:57 | Dale, Alabama, US |
2517089 | 2517089 | 2020-10-03 | US | Tennessee | Dyer | 47045 | 1523 | 18 | 0 | 1483 | 36.05931946 | -89.41542855 | 2020-10-04 04:23:44 | Dyer, Tennessee, US |
2614154 | 2614154 | 2020-09-26 | Netherlands | Groningen | 1525 | 20 | 0 | 1483 | 53.217922 | 6.741514 | 2020-09-27 04:23:00 | Groningen, Netherlands | ||
2815330 | 2815330 | 2020-09-25 | US | Oklahoma | Texas | 40139 | 1491 | 8 | 0 | 1483 | 36.74777635 | -101.4889765 | 2020-09-26 04:23:00 | Texas, Oklahoma, US |
2656757 | 2656757 | 2020-09-23 | US | Tennessee | Wayne | 47181 | 1495 | 6 | 0 | 1483 | 35.23868267 | -87.78644456 | 2020-09-24 04:23:00 | Wayne, Tennessee, US |
2849069 | 2849069 | 2020-09-18 | Russia | Orel Oblast | 7925 | 121 | 6321 | 1483 | 52.9685433 | 36.0692477 | 2020-09-19 04:22:00 | Orel Oblast, Russia | ||
347633 | 347633 | 2020-09-14 | US | Virginia | Montgomery | 51121 | 1487 | 4 | 0 | 1483 | 37.17746986 | -80.37868691 | 2020-09-15 03:22:50 | Montgomery, Virginia, US |
547113 | 547113 | 2020-09-12 | US | Alabama | Escambia | 1053 | 1506 | 23 | 0 | 1483 | 31.1256789 | -87.15918694 | 2020-09-13 04:30:52 | Escambia, Alabama, US |
1174711 | 1174711 | 2020-09-10 | US | Louisiana | Washington | 22117 | 1543 | 60 | 0 | 1483 | 30.85288548 | -90.03866652 | 2020-09-11 04:46:23 | Washington, Louisiana, US |
429138 | 429138 | 2020-09-07 | US | Mississippi | Lamar | 28073 | 1515 | 32 | 0 | 1483 | 31.20572971 | -89.5077704 | 2020-09-08 04:28:25 | Lamar, Mississippi, US |
3163423 | 3163423 | 2020-09-06 | US | Mississippi | Lamar | 28073 | 1515 | 32 | 0 | 1483 | 31.20572971 | -89.5077704 | 2020-09-07 04:28:30 | Lamar, Mississippi, US |
2665407 | 2665407 | 2020-09-04 | Ukraine | Zhytomyr Oblast | 3550 | 69 | 1998 | 1483 | 50.2547 | 28.6587 | 2020-09-05 04:28:19 | Zhytomyr Oblast, Ukraine | ||
2664763 | 2664763 | 2020-09-04 | US | Tennessee | Wayne | 47181 | 1437 | 2 | 0 | 1483 | 35.23868267 | -87.78644456 | 2020-09-05 04:28:19 | Wayne, Tennessee, US |
1106205 | 1106205 | 2020-09-02 | US | Connecticut | New London | 9011 | 1590 | 107 | 0 | 1483 | 41.48896435 | -72.10430976 | 2020-09-03 04:28:22 | New London, Connecticut, US |
3931865 | 3931865 | 2020-08-30 | Colombia | Boyaca | 3761 | 73 | 2205 | 1483 | 5.4545 | -73.362 | 2020-08-31 04:28:27 | Boyaca, 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]);