johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
176 rows where active = 1365 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 18
- US 134
- Russia 15
- Chile 4
- India 3
- Mexico 3
- Colombia 2
- Japan 2
- South Sudan 2
- Ukraine 2
- Azerbaijan 1
- Cote d'Ivoire 1
- Eswatini 1
- Greece 1
- Italy 1
- Niger 1
- Peru 1
- Timor-Leste 1
- West Bank and Gaza 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3468162 | 3468162 | 2021-08-03 | Italy | Liguria | 105621 | 4366 | 99890 | 1365 | 44.41149315 | 8.9326992 | 2021-08-04 04:21:25 | Liguria, Italy | ||
3015193 | 3015193 | 2021-08-01 | Colombia | Cesar | 86578 | 2401 | 82812 | 1365 | 9.3373 | -73.6536 | 2021-08-02 04:21:36 | Cesar, Colombia | ||
3476546 | 3476546 | 2021-07-22 | Russia | Orel Oblast | 39420 | 808 | 37247 | 1365 | 52.96854329999999 | 36.0692477 | 2021-07-23 04:21:29 | Orel Oblast, Russia | ||
3632158 | 3632158 | 2021-07-14 | Russia | Ivanovo Oblast | 39519 | 1336 | 36818 | 1365 | 56.9167446 | 41.43521370000001 | 2021-07-15 04:21:48 | Ivanovo Oblast, Russia | ||
3632144 | 3632144 | 2021-07-14 | Russia | Amur Oblast | 25549 | 319 | 23865 | 1365 | 52.8032368 | 128.437295 | 2021-07-15 04:21:48 | Amur Oblast, Russia | ||
778614 | 778614 | 2021-07-08 | Russia | Tomsk Oblast | 34722 | 481 | 32876 | 1365 | 58.6124279 | 82.04753149999998 | 2021-07-09 04:21:21 | Tomsk Oblast, Russia | ||
1165116 | 1165116 | 2021-07-04 | India | Himachal Pradesh | 202642 | 3483 | 197794 | 1365 | 31.927213 | 77.233081 | 2021-07-05 04:21:28 | Himachal Pradesh, India | ||
3145616 | 3145616 | 2021-06-07 | Japan | Saitama | 44487 | 802 | 42320 | 1365 | 35.997101 | 139.347635 | 2021-06-08 04:22:35 | Saitama, Japan | ||
825830 | 825830 | 2021-06-06 | Russia | Stavropol Krai | 55198 | 1542 | 52291 | 1365 | 44.86325770000001 | 43.4406913 | 2021-06-07 04:22:51 | Stavropol Krai, Russia | ||
20213 | 20213 | 2021-05-28 | Colombia | Cesar | 66814 | 1816 | 63633 | 1365 | 9.3373 | -73.6536 | 2021-05-29 04:20:41 | Cesar, Colombia | ||
1416697 | 1416697 | 2021-05-24 | Ukraine | Zakarpattia Oblast | 61360 | 1576 | 58419 | 1365 | 48.6208 | 22.2879 | 2021-05-25 04:21:08 | Zakarpattia Oblast, Ukraine | ||
2255960 | 2255960 | 2021-05-19 | Russia | Nizhny Novgorod Oblast | 116385 | 3447 | 111573 | 1365 | 55.47180329999999 | 44.0911594 | 2021-05-20 04:21:05 | Nizhny Novgorod Oblast, Russia | ||
2502362 | 2502362 | 2021-05-07 | Timor-Leste | 2965 | 4 | 1596 | 1365 | -8.874217 | 125.727539 | 2021-05-08 04:21:04 | Timor-Leste | |||
2571468 | 2571468 | 2021-04-13 | Chile | Los Rios | 30559 | 340 | 28854 | 1365 | -40.231 | -72.3311 | 2021-04-14 04:20:41 | Los Rios, Chile | ||
241471 | 241471 | 2021-04-02 | Russia | Kurgan Oblast | 19301 | 354 | 17582 | 1365 | 55.7655302 | 64.5632681 | 2021-04-03 04:20:44 | Kurgan Oblast, Russia | ||
3369587 | 3369587 | 2021-03-21 | Russia | Volgograd Oblast | 52420 | 902 | 50153 | 1365 | 49.6048339 | 44.29035820000001 | 2021-03-22 05:25:43 | Volgograd Oblast, Russia | ||
3421177 | 3421177 | 2021-03-19 | Russia | Volgograd Oblast | 52156 | 891 | 49900 | 1365 | 49.6048339 | 44.29035820000001 | 2021-03-20 05:25:46 | Volgograd Oblast, Russia | ||
2211044 | 2211044 | 2021-03-04 | US | Virginia | Richmond | 51159 | 1374 | 9 | 0 | 1365 | 37.937575 | -76.72920628 | 2021-03-05 05:26:29 | Richmond, Virginia, US |
2186347 | 2186347 | 2021-02-26 | US | Puerto Rico | Rio Grande | 72119 | 1365 | 0 | 0 | 1365 | 18.346329 | -65.813742 | 2021-02-27 05:22:28 | Rio Grande, Puerto Rico, US |
182391 | 182391 | 2021-02-21 | US | Alabama | Clay | 1027 | 1419 | 54 | 0 | 1365 | 33.26984193 | -85.85836077 | 2021-02-22 05:24:21 | Clay, Alabama, US |
182298 | 182298 | 2021-02-21 | Russia | Volgograd Oblast | 47988 | 731 | 45892 | 1365 | 49.6048339 | 44.29035820000001 | 2021-02-22 05:24:21 | Volgograd Oblast, Russia | ||
474206 | 474206 | 2021-02-19 | US | South Carolina | Bamberg | 45009 | 1413 | 48 | 0 | 1365 | 33.21927586 | -81.05659969 | 2021-02-20 05:22:51 | Bamberg, South Carolina, US |
1153479 | 1153479 | 2021-02-18 | US | Alabama | Crenshaw | 1041 | 1416 | 51 | 0 | 1365 | 31.72941803 | -86.31593104 | 2021-02-19 05:24:16 | Crenshaw, Alabama, US |
1341557 | 1341557 | 2021-02-15 | US | Vermont | Washington | 50023 | 1377 | 12 | 0 | 1365 | 44.27343241 | -72.61604978 | 2021-02-16 05:24:38 | Washington, Vermont, US |
1338239 | 1338239 | 2021-02-15 | India | Rajasthan | 319005 | 2781 | 314859 | 1365 | 26.583423 | 73.847973 | 2021-02-16 05:24:38 | Rajasthan, India | ||
2678084 | 2678084 | 2021-02-13 | Russia | Volgograd Oblast | 46336 | 682 | 44289 | 1365 | 49.6048339 | 44.29035820000001 | 2021-02-14 05:23:43 | Volgograd Oblast, Russia | ||
2638218 | 2638218 | 2021-02-11 | US | Arkansas | Madison | 5087 | 1384 | 19 | 0 | 1365 | 36.01038185 | -93.72524943 | 2021-02-12 05:23:29 | Madison, Arkansas, US |
342210 | 342210 | 2021-02-03 | US | Missouri | Pemiscot | 29155 | 1390 | 25 | 0 | 1365 | 36.2130572 | -89.78742322 | 2021-02-04 05:22:26 | Pemiscot, Missouri, US |
341482 | 341482 | 2021-02-03 | US | Iowa | Lyon | 19119 | 1402 | 37 | 0 | 1365 | 43.38107862 | -96.20926845 | 2021-02-04 05:22:26 | Lyon, Iowa, US |
1686251 | 1686251 | 2021-02-02 | US | Minnesota | Renville | 27129 | 1405 | 40 | 0 | 1365 | 44.72836381 | -94.94553734 | 2021-02-03 05:22:52 | Renville, Minnesota, US |
1685708 | 1685708 | 2021-02-02 | US | Iowa | Lyon | 19119 | 1402 | 37 | 0 | 1365 | 43.38107862 | -96.20926845 | 2021-02-03 05:22:52 | Lyon, Iowa, US |
1678406 | 1678406 | 2021-02-01 | US | Missouri | Pemiscot | 29155 | 1389 | 24 | 0 | 1365 | 36.2130572 | -89.78742322 | 2021-02-02 05:22:49 | Pemiscot, Missouri, US |
2483283 | 2483283 | 2021-01-28 | US | Kansas | Nemaha | 20131 | 1415 | 50 | 0 | 1365 | 39.78345387 | -96.01392079 | 2021-01-29 05:22:23 | Nemaha, Kansas, US |
3155758 | 3155758 | 2021-01-27 | US | New Hampshire | Unassigned | 90033 | 1366 | 1 | 0 | 1365 | 44.69063265 | 0.0 | 2021-01-28 05:22:24 | Unassigned, New Hampshire, US |
3154918 | 3154918 | 2021-01-27 | US | Kansas | Nemaha | 20131 | 1415 | 50 | 0 | 1365 | 39.78345387 | -96.01392079 | 2021-01-28 05:22:24 | Nemaha, Kansas, US |
2568641 | 2568641 | 2021-01-25 | US | Illinois | Ford | 17053 | 1408 | 43 | 0 | 1365 | 40.59706922 | -88.22350769 | 2021-01-26 05:22:02 | Ford, Illinois, US |
438928 | 438928 | 2021-01-21 | US | Wisconsin | Sawyer | 55113 | 1382 | 17 | 0 | 1365 | 45.87931905 | -91.14504927 | 2021-01-22 05:22:10 | Sawyer, Wisconsin, US |
1097641 | 1097641 | 2021-01-20 | US | Wisconsin | Marquette | 55077 | 1390 | 25 | 0 | 1365 | 43.81911946 | -89.40073763 | 2021-01-21 05:22:01 | Marquette, Wisconsin, US |
1097068 | 1097068 | 2021-01-20 | US | Tennessee | Sequatchie | 47153 | 1330 | 18 | 0 | 1365 | 35.36979721 | -85.41022136 | 2021-01-21 05:22:01 | Sequatchie, Tennessee, US |
1095252 | 1095252 | 2021-01-20 | US | Iowa | Cherokee | 19035 | 1392 | 27 | 0 | 1365 | 42.73538914 | -95.62389402 | 2021-01-21 05:22:01 | Cherokee, Iowa, US |
1095107 | 1095107 | 2021-01-20 | US | Illinois | Moultrie | 17139 | 1385 | 20 | 0 | 1365 | 39.64187451 | -88.62099969 | 2021-01-21 05:22:01 | Moultrie, Illinois, US |
1094491 | 1094491 | 2021-01-20 | US | Alabama | Washington | 1129 | 1391 | 26 | 0 | 1365 | 31.4092794 | -88.20689944 | 2021-01-21 05:22:01 | Washington, Alabama, US |
1093886 | 1093886 | 2021-01-20 | Chile | Valparaiso | 40456 | 1323 | 37768 | 1365 | -33.0472 | -71.6127 | 2021-01-21 05:22:01 | Valparaiso, Chile | ||
911575 | 911575 | 2021-01-19 | US | Virginia | Scott | 51169 | 1405 | 40 | 0 | 1365 | 36.71466456 | -82.60171704 | 2021-01-20 05:21:54 | Scott, Virginia, US |
240638 | 240638 | 2021-01-18 | US | Virginia | Scott | 51169 | 1405 | 40 | 0 | 1365 | 36.71466456 | -82.60171704 | 2021-01-19 05:22:15 | Scott, Virginia, US |
3103189 | 3103189 | 2021-01-16 | US | Minnesota | Redwood | 27127 | 1392 | 27 | 0 | 1365 | 44.40555844 | -95.25207021 | 2021-01-17 05:22:17 | Redwood, Minnesota, US |
777136 | 777136 | 2021-01-12 | US | South Carolina | Abbeville | 45001 | 1391 | 26 | 0 | 1365 | 34.22333378 | -82.46170658 | 2021-01-13 05:22:15 | Abbeville, South Carolina, US |
191206 | 191206 | 2021-01-11 | US | Indiana | Vermillion | 18165 | 1399 | 34 | 0 | 1365 | 39.8523352 | -87.46160542 | 2021-01-12 05:22:15 | Vermillion, Indiana, US |
190888 | 190888 | 2021-01-11 | US | Georgia | Jones | 13169 | 1389 | 24 | 0 | 1365 | 33.02512137 | -83.56019163 | 2021-01-12 05:22:15 | Jones, Georgia, US |
2627460 | 2627460 | 2021-01-10 | US | Massachusetts | Franklin | 25011 | 1458 | 65 | 0 | 1365 | 42.58119713 | -72.58602547 | 2021-01-11 05:21:50 | Franklin, Massachusetts, US |
2626006 | 2626006 | 2021-01-10 | Niger | 3877 | 126 | 2386 | 1365 | 17.607789 | 8.081666 | 2021-01-11 05:21:50 | Niger | |||
3900932 | 3900932 | 2021-01-09 | US | Illinois | Edgar | 17045 | 1396 | 31 | 0 | 1365 | 39.6809186 | -87.74759563 | 2021-01-10 05:22:12 | Edgar, Illinois, US |
3900732 | 3900732 | 2021-01-09 | US | Georgia | Cook | 13075 | 1393 | 28 | 0 | 1365 | 31.16068491 | -83.42947229 | 2021-01-10 05:22:12 | Cook, Georgia, US |
3037719 | 3037719 | 2021-01-05 | US | Virginia | Wythe | 51197 | 1393 | 28 | 0 | 1365 | 36.91582035 | -81.07834059 | 2021-01-06 05:22:16 | Wythe, Virginia, US |
3037599 | 3037599 | 2021-01-05 | US | Virginia | Botetourt | 51023 | 1383 | 18 | 0 | 1365 | 37.55531756 | -79.80982182 | 2021-01-06 05:22:16 | Botetourt, Virginia, US |
3230708 | 3230708 | 2021-01-03 | Russia | Volgograd Oblast | 36229 | 474 | 34390 | 1365 | 49.6048339 | 44.29035820000001 | 2021-01-04 05:22:02 | Volgograd Oblast, Russia | ||
3764195 | 3764195 | 2020-12-28 | US | Oregon | Jefferson | 41031 | 1381 | 16 | 0 | 1365 | 44.62806839 | -121.17832 | 2020-12-29 05:22:37 | Jefferson, Oregon, US |
2122230 | 2122230 | 2020-12-20 | US | Ohio | Wyandot | 39175 | 1389 | 24 | 0 | 1365 | 40.84339621 | -83.30734173 | 2020-12-21 05:27:58 | Wyandot, Ohio, US |
2933063 | 2933063 | 2020-12-19 | US | Mississippi | Tishomingo | 28141 | 1415 | 50 | 0 | 1365 | 34.74023475 | -88.23917219 | 2020-12-20 05:27:32 | Tishomingo, Mississippi, US |
2932409 | 2932409 | 2020-12-19 | US | Iowa | Hardin | 19083 | 1387 | 22 | 0 | 1365 | 42.38353877 | -93.23654611 | 2020-12-20 05:27:32 | Hardin, Iowa, US |
1903048 | 1903048 | 2020-12-18 | US | Missouri | Cooper | 29053 | 1379 | 14 | 0 | 1365 | 38.844478 | -92.80896081 | 2020-12-19 05:27:52 | Cooper, Missouri, US |
2131600 | 2131600 | 2020-12-17 | US | Wyoming | Uinta | 56041 | 1372 | 7 | 0 | 1365 | 41.2878183 | -110.54757820000002 | 2020-12-18 05:28:18 | Uinta, Wyoming, US |
1037279 | 1037279 | 2020-12-15 | US | Tennessee | Bledsoe | 47007 | 1405 | 6 | 0 | 1365 | 35.59942968 | -85.20611967 | 2020-12-16 05:28:04 | Bledsoe, Tennessee, US |
3849835 | 3849835 | 2020-12-13 | US | Nebraska | Colfax | 31037 | 1379 | 14 | 0 | 1365 | 41.57486951 | -97.0868542 | 2020-12-14 05:26:27 | Colfax, Nebraska, US |
1602803 | 1602803 | 2020-12-10 | US | Oklahoma | Seminole | 40133 | 1380 | 15 | 0 | 1365 | 35.16478725 | -96.61686741 | 2020-12-11 05:26:59 | Seminole, Oklahoma, US |
1602260 | 1602260 | 2020-12-10 | US | Nebraska | Cass | 31025 | 1372 | 7 | 0 | 1365 | 40.90899107 | -96.13971217 | 2020-12-11 05:26:59 | Cass, Nebraska, US |
2978530 | 2978530 | 2020-12-09 | US | Virginia | Campbell | 51031 | 1379 | 14 | 0 | 1365 | 37.20553386 | -79.09678609 | 2020-12-10 05:26:19 | Campbell, Virginia, US |
2977022 | 2977022 | 2020-12-09 | US | Mississippi | Hancock | 28045 | 1410 | 45 | 0 | 1365 | 30.41830223 | -89.48851033 | 2020-12-10 05:26:19 | Hancock, Mississippi, US |
1822219 | 1822219 | 2020-12-08 | US | Washington | Grays Harbor | 53027 | 1384 | 19 | 0 | 1365 | 47.14003705 | -123.7820567 | 2020-12-09 05:28:01 | Grays Harbor, Washington, US |
1821927 | 1821927 | 2020-12-08 | US | Texas | Lamb | 48279 | 1668 | 53 | 0 | 1365 | 34.06859623 | -102.3516289 | 2020-12-09 05:28:01 | Lamb, Texas, US |
1821875 | 1821875 | 2020-12-08 | US | Texas | Gonzales | 48177 | 1326 | 24 | 0 | 1365 | 29.45634206 | -97.49424032 | 2020-12-09 05:28:01 | Gonzales, Texas, US |
2348913 | 2348913 | 2020-12-07 | US | Louisiana | De Soto | 22031 | 1406 | 41 | 0 | 1365 | 32.05457447 | -93.74130302 | 2020-12-08 05:27:42 | De Soto, Louisiana, US |
741787 | 741787 | 2020-12-02 | US | West Virginia | Mineral | 54057 | 1385 | 20 | 0 | 1365 | 39.41561583 | -78.94104895 | 2020-12-03 05:28:22 | Mineral, West Virginia, US |
740790 | 740790 | 2020-12-02 | US | Ohio | Ottawa | 39123 | 1405 | 40 | 0 | 1365 | 41.53781826 | -83.0940185 | 2020-12-03 05:28:22 | Ottawa, Ohio, US |
1585200 | 1585200 | 2020-11-30 | US | Illinois | Shelby | 17173 | 1388 | 23 | 0 | 1365 | 39.39133527 | -88.80611122 | 2020-12-01 05:26:18 | Shelby, Illinois, US |
3568506 | 3568506 | 2020-11-29 | US | Missouri | Polk | 29167 | 1377 | 12 | 0 | 1365 | 37.6162296 | -93.39828174 | 2020-11-30 05:26:13 | Polk, Missouri, US |
1353300 | 1353300 | 2020-11-24 | US | Tennessee | Smith | 47159 | 1387 | 19 | 0 | 1365 | 36.25359775 | -85.95411046 | 2020-11-25 05:27:20 | Smith, Tennessee, US |
3193486 | 3193486 | 2020-11-22 | US | West Virginia | Raleigh | 54081 | 1380 | 15 | 0 | 1365 | 37.76936795 | -81.2456041 | 2020-11-23 05:25:26 | Raleigh, West Virginia, US |
3190006 | 3190006 | 2020-11-22 | Japan | Kanagawa | 11340 | 185 | 9790 | 1365 | 35.415312 | 139.338983 | 2020-11-23 05:25:26 | Kanagawa, Japan | ||
3838217 | 3838217 | 2020-11-21 | US | Minnesota | Nicollet | 27103 | 1388 | 23 | 0 | 1365 | 44.35291112 | -94.24710352 | 2020-11-22 05:25:45 | Nicollet, Minnesota, US |
822433 | 822433 | 2020-11-19 | US | Georgia | Stephens | 13257 | 1412 | 47 | 0 | 1365 | 34.55151201 | -83.29405315 | 2020-11-20 05:26:28 | Stephens, Georgia, US |
3339878 | 3339878 | 2020-11-17 | US | Kansas | Harvey | 20079 | 1373 | 8 | 0 | 1365 | 38.04293782 | -97.42747573 | 2020-11-18 05:40:31 | Harvey, Kansas, US |
3172436 | 3172436 | 2020-11-16 | US | South Carolina | Chester | 45023 | 1397 | 32 | 0 | 1365 | 34.69249168 | -81.1583216 | 2020-11-17 05:25:54 | Chester, South Carolina, US |
3170923 | 3170923 | 2020-11-16 | US | Kansas | Harvey | 20079 | 1373 | 8 | 0 | 1365 | 38.04293782 | -97.42747573 | 2020-11-17 05:25:54 | Harvey, Kansas, US |
2918152 | 2918152 | 2020-11-14 | US | Tennessee | Overton | 47133 | 1435 | 33 | 0 | 1365 | 36.34117832 | -85.28989535 | 2020-11-15 05:26:53 | Overton, Tennessee, US |
2914973 | 2914973 | 2020-11-14 | Chile | Los Lagos | 17754 | 158 | 16231 | 1365 | -41.9198 | -72.1416 | 2020-11-15 05:26:53 | Los Lagos, Chile | ||
2787541 | 2787541 | 2020-11-13 | US | Oklahoma | Custer | 40039 | 1374 | 9 | 0 | 1365 | 35.63853802 | -99.00170785 | 2020-11-14 05:25:37 | Custer, Oklahoma, US |
867574 | 867574 | 2020-11-12 | US | South Carolina | Dillon | 45033 | 1414 | 49 | 0 | 1365 | 34.39007791 | -79.37741872 | 2020-11-13 05:25:30 | Dillon, South Carolina, US |
3443999 | 3443999 | 2020-11-11 | US | Texas | Polk | 48373 | 1545 | 40 | 0 | 1365 | 30.79472531 | -94.8276624 | 2020-11-12 05:25:55 | Polk, Texas, US |
272978 | 272978 | 2020-11-10 | US | Georgia | Liberty | 13179 | 1392 | 27 | 0 | 1365 | 31.82588896 | -81.49251135 | 2020-11-11 05:25:30 | Liberty, Georgia, US |
1731479 | 1731479 | 2020-11-08 | US | Tennessee | White | 47185 | 1380 | 16 | 0 | 1365 | 35.92929884 | -85.45591799 | 2020-11-09 05:25:45 | White, Tennessee, US |
1729069 | 1729069 | 2020-11-08 | US | California | Yuba | 6115 | 1374 | 10 | 0 | 1365 | 39.26255932 | -121.3535644 | 2020-11-09 05:25:45 | Yuba, California, US |
895402 | 895402 | 2020-11-05 | US | Virgin Islands | 78 | 1388 | 23 | 0 | 1365 | 18.3358 | -64.8963 | 2020-11-06 05:24:55 | Virgin Islands, US | |
2922464 | 2922464 | 2020-11-04 | US | Virgin Islands | 78 | 1388 | 23 | 0 | 1365 | 18.3358 | -64.8963 | 2020-11-05 06:05:03 | Virgin Islands, US | |
2500944 | 2500944 | 2020-11-03 | US | Tennessee | Franklin | 47051 | 1393 | 26 | 0 | 1365 | 35.15634626 | -86.09201039 | 2020-11-04 05:25:09 | Franklin, Tennessee, US |
2498211 | 2498211 | 2020-11-03 | Russia | Chuvashia Republic | 10074 | 155 | 8554 | 1365 | 55.4259922 | 47.0849429 | 2020-11-04 05:25:09 | Chuvashia Republic, Russia | ||
3307570 | 3307570 | 2020-11-02 | US | Virginia | Pittsylvania | 51143 | 1382 | 17 | 0 | 1365 | 36.81980341 | -79.39731264 | 2020-11-03 06:00:16 | Pittsylvania, Virginia, US |
3304154 | 3304154 | 2020-11-02 | India | Nagaland | 9096 | 42 | 7689 | 1365 | 26.06702 | 94.470302 | 2020-11-03 06:00:16 | Nagaland, India | ||
3412784 | 3412784 | 2020-11-01 | US | Virginia | Henry | 51089 | 1397 | 32 | 0 | 1365 | 36.68542395 | -79.87634026 | 2020-11-02 05:25:04 | Henry, Virginia, US |
3412396 | 3412396 | 2020-11-01 | US | Tennessee | Macon | 47111 | 1391 | 25 | 0 | 1365 | 36.53157855 | -86.00778595 | 2020-11-02 05:25:04 | Macon, Tennessee, 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]);