johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
197 rows where active = 1228 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 20
- US 146
- Russia 15
- Chile 5
- Colombia 4
- Italy 4
- Sweden 3
- Canada 2
- Ghana 2
- Malaysia 2
- Mexico 2
- South Sudan 2
- Ukraine 2
- Bahamas 1
- Cabo Verde 1
- Czechia 1
- India 1
- Japan 1
- Netherlands 1
- Sierra Leone 1
- Zimbabwe 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1893351 | 1893351 | 2021-06-30 | Russia | Kemerovo Oblast | 39950 | 819 | 37903 | 1228 | 54.53357809999999 | 87.342861 | 2021-07-01 04:21:19 | Kemerovo Oblast, Russia | ||
400275 | 400275 | 2021-06-29 | Japan | Hokkaido | 41294 | 1394 | 38672 | 1228 | 43.385711 | 142.552318 | 2021-06-30 04:21:41 | Hokkaido, Japan | ||
1712578 | 1712578 | 2021-06-25 | Russia | Tomsk Oblast | 33851 | 464 | 32159 | 1228 | 58.6124279 | 82.04753149999998 | 2021-06-26 04:21:43 | Tomsk Oblast, Russia | ||
2911096 | 2911096 | 2021-06-17 | Ghana | 94824 | 790 | 92806 | 1228 | 7.9465 | -1.0232 | 2021-06-18 04:22:16 | Ghana | |||
3030214 | 3030214 | 2021-06-16 | Ghana | 94824 | 790 | 92806 | 1228 | 7.9465 | -1.0232 | 2021-06-17 04:22:36 | Ghana | |||
1740178 | 1740178 | 2021-06-12 | Zimbabwe | 39852 | 1632 | 36992 | 1228 | -19.015438 | 29.154857 | 2021-06-13 04:22:44 | Zimbabwe | |||
1310026 | 1310026 | 2021-05-26 | Colombia | Risaralda | 61666 | 1561 | 58877 | 1228 | 5.3158 | -75.9928 | 2021-05-27 04:20:59 | Risaralda, Colombia | ||
1913469 | 1913469 | 2021-05-20 | Russia | Vladimir Oblast | 32998 | 1164 | 30606 | 1228 | 56.0503336 | 40.6561633 | 2021-05-21 04:20:43 | Vladimir Oblast, Russia | ||
3954744 | 3954744 | 2021-05-11 | Russia | Tver Oblast | 40666 | 943 | 38495 | 1228 | 57.1134475 | 35.174442799999994 | 2021-05-12 04:21:29 | Tver Oblast, Russia | ||
1568096 | 1568096 | 2021-04-22 | Italy | P.A. Trento | 43372 | 1333 | 40811 | 1228 | 46.06893511 | 11.12123097 | 2021-04-23 04:20:52 | P.A. Trento, Italy | ||
2247155 | 2247155 | 2021-04-07 | Cabo Verde | 18214 | 175 | 16811 | 1228 | 16.5388 | -23.0418 | 2021-04-08 04:21:13 | Cabo Verde | |||
1748161 | 1748161 | 2021-03-20 | Ukraine | Kherson Oblast | 22778 | 673 | 20877 | 1228 | 46.6354 | 32.6169 | 2021-03-21 05:25:44 | Kherson Oblast, Ukraine | ||
3670360 | 3670360 | 2021-03-06 | US | Puerto Rico | Humacao | 72069 | 1228 | 0 | 0 | 1228 | 18.145211 | -65.810174 | 2021-03-07 05:21:54 | Humacao, Puerto Rico, US |
1618500 | 1618500 | 2021-03-05 | US | New York | Schoharie | 36095 | 1241 | 13 | 0 | 1228 | 42.58831742 | -74.44339029999998 | 2021-03-06 04:23:41 | Schoharie, New York, US |
1617950 | 1617950 | 2021-03-05 | US | Minnesota | Faribault | 27043 | 1245 | 17 | 0 | 1228 | 43.67381499 | -93.94787458 | 2021-03-06 04:23:41 | Faribault, Minnesota, US |
1092409 | 1092409 | 2021-03-03 | US | North Carolina | Mitchell | 37121 | 1244 | 16 | 0 | 1228 | 36.01059309 | -82.1582442 | 2021-03-04 05:24:24 | Mitchell, North Carolina, US |
3256481 | 3256481 | 2021-03-02 | US | North Carolina | Mitchell | 37121 | 1244 | 16 | 0 | 1228 | 36.01059309 | -82.1582442 | 2021-03-03 05:23:28 | Mitchell, North Carolina, US |
3255309 | 3255309 | 2021-03-02 | US | Iowa | Cass | 19029 | 1279 | 51 | 0 | 1228 | 41.33149454 | -94.92792482 | 2021-03-03 05:23:28 | Cass, Iowa, US |
1000773 | 1000773 | 2021-03-01 | US | North Carolina | Mitchell | 37121 | 1244 | 16 | 0 | 1228 | 36.01059309 | -82.1582442 | 2021-03-02 05:23:30 | Mitchell, North Carolina, US |
183834 | 183834 | 2021-02-21 | US | Mississippi | Greene | 28041 | 1261 | 33 | 0 | 1228 | 31.21444233 | -88.63922281 | 2021-02-22 05:24:21 | Greene, Mississippi, US |
742963 | 742963 | 2021-02-20 | US | Colorado | Teller | 8119 | 1295 | 14 | 0 | 1228 | 38.88133511 | -105.1614893 | 2021-02-21 05:24:33 | Teller, Colorado, US |
475093 | 475093 | 2021-02-19 | Malaysia | Pulau Pinang | 10372 | 15 | 9129 | 1228 | 5.4141 | 100.3288 | 2021-02-20 05:22:51 | Pulau Pinang, Malaysia | ||
1155045 | 1155045 | 2021-02-18 | US | Missouri | Mississippi | 29133 | 1252 | 24 | 0 | 1228 | 36.82516239 | -89.29505753 | 2021-02-19 05:24:16 | Mississippi, Missouri, US |
1153936 | 1153936 | 2021-02-18 | US | Georgia | Jasper | 13159 | 1258 | 30 | 0 | 1228 | 33.31535543 | -83.68844964 | 2021-02-19 05:24:16 | Jasper, Georgia, US |
3601650 | 3601650 | 2021-02-17 | US | Colorado | Elbert | 8039 | 1318 | 12 | 0 | 1228 | 39.28656773 | -104.1358721 | 2021-02-18 05:22:58 | Elbert, Colorado, US |
3053651 | 3053651 | 2021-02-16 | US | West Virginia | Hardy | 54031 | 1248 | 20 | 0 | 1228 | 39.00683177 | -78.85855301 | 2021-02-17 05:23:10 | Hardy, West Virginia, US |
3050014 | 3050014 | 2021-02-16 | Colombia | Caldas | 46058 | 951 | 43879 | 1228 | 5.2983 | -75.2479 | 2021-02-17 05:23:10 | Caldas, Colombia | ||
1341953 | 1341953 | 2021-02-15 | Malaysia | Negeri Sembilan | 13205 | 27 | 11950 | 1228 | 2.7258 | 101.9424 | 2021-02-16 05:24:38 | Negeri Sembilan, Malaysia | ||
2679978 | 2679978 | 2021-02-13 | US | New Hampshire | Sullivan | 33019 | 1247 | 19 | 0 | 1228 | 43.36094111 | -72.22203125 | 2021-02-14 05:23:43 | Sullivan, New Hampshire, US |
3542306 | 3542306 | 2021-02-12 | US | South Dakota | Charles Mix | 46023 | 1246 | 18 | 0 | 1228 | 43.20660134 | -98.58856175 | 2021-02-13 05:22:12 | Charles Mix, South Dakota, US |
2638839 | 2638839 | 2021-02-11 | US | Indiana | Pike | 18125 | 1258 | 30 | 0 | 1228 | 38.40112197 | -87.23574907 | 2021-02-12 05:23:29 | Pike, Indiana, US |
3980045 | 3980045 | 2021-02-10 | US | Kentucky | Union | 21225 | 1239 | 11 | 0 | 1228 | 37.66166713 | -87.94300009 | 2021-02-11 05:23:55 | Union, Kentucky, US |
1530379 | 1530379 | 2021-02-09 | US | Ohio | Meigs | 39105 | 1261 | 33 | 0 | 1228 | 39.09224872 | -82.0305041 | 2021-02-10 05:22:41 | Meigs, Ohio, US |
1528172 | 1528172 | 2021-02-09 | Sierra Leone | 3801 | 79 | 2494 | 1228 | 8.460555000000001 | -11.779889 | 2021-02-10 05:22:41 | Sierra Leone | |||
1675979 | 1675979 | 2021-02-07 | US | Wisconsin | Burnett | 55013 | 1251 | 23 | 0 | 1228 | 45.86303537 | -92.36711412 | 2021-02-08 05:22:39 | Burnett, Wisconsin, US |
977071 | 977071 | 2021-02-06 | US | New Hampshire | Unassigned | 90033 | 1232 | 4 | 0 | 1228 | 44.69063265 | 0.0 | 2021-02-07 05:23:00 | Unassigned, New Hampshire, US |
976103 | 976103 | 2021-02-06 | US | Iowa | Grundy | 19075 | 1258 | 30 | 0 | 1228 | 42.40183723 | -92.78829551 | 2021-02-07 05:23:00 | Grundy, Iowa, US |
790371 | 790371 | 2021-02-04 | Italy | Molise | 8597 | 282 | 7087 | 1228 | 41.55774754 | 14.65916051 | 2021-02-05 05:22:38 | Molise, Italy | ||
1687851 | 1687851 | 2021-02-02 | US | Virginia | King George | 51099 | 1239 | 11 | 0 | 1228 | 38.26818502 | -77.15852768 | 2021-02-03 05:22:52 | King George, Virginia, US |
2214959 | 2214959 | 2021-01-30 | US | Virginia | Appomattox | 51011 | 1236 | 8 | 0 | 1228 | 37.37569884 | -78.81340003 | 2021-01-31 05:22:42 | Appomattox, Virginia, US |
2211503 | 2211503 | 2021-01-30 | Colombia | Bolivar | 63425 | 1267 | 60930 | 1228 | 8.6704 | -74.03 | 2021-01-31 05:22:42 | Bolivar, Colombia | ||
1896860 | 1896860 | 2021-01-29 | Bahamas | 8167 | 175 | 6764 | 1228 | 25.025885 | -78.035889 | 2021-01-30 05:22:49 | Bahamas | |||
2484747 | 2484747 | 2021-01-28 | US | Puerto Rico | Vega Alta | 72143 | 1228 | 0 | 0 | 1228 | 18.409346 | -66.33725 | 2021-01-29 05:22:23 | Vega Alta, Puerto Rico, US |
2484155 | 2484155 | 2021-01-28 | US | New Mexico | Grant | 35017 | 1256 | 28 | 0 | 1228 | 32.73911281 | -108.3827845 | 2021-01-29 05:22:23 | Grant, New Mexico, US |
3156266 | 3156266 | 2021-01-27 | US | Pennsylvania | Forest | 42053 | 1244 | 16 | 0 | 1228 | 41.51095103 | -79.23229292 | 2021-01-28 05:22:24 | Forest, Pennsylvania, US |
15723 | 15723 | 2021-01-26 | US | Virginia | Powhatan | 51145 | 1235 | 7 | 0 | 1228 | 37.55016038 | -77.91267882 | 2021-01-27 05:23:41 | Powhatan, Virginia, US |
2568824 | 2568824 | 2021-01-25 | US | Iowa | Calhoun | 19025 | 1237 | 9 | 0 | 1228 | 42.38521079 | -94.64046046 | 2021-01-26 05:22:02 | Calhoun, Iowa, US |
1762013 | 1762013 | 2021-01-24 | US | Puerto Rico | Canovanas | 72029 | 1228 | 0 | 0 | 1228 | 18.328802 | -65.887612 | 2021-01-25 05:22:16 | Canovanas, Puerto Rico, US |
1759996 | 1759996 | 2021-01-24 | US | Florida | Jefferson | 12065 | 1247 | 19 | 0 | 1228 | 30.43669112 | -83.89442308 | 2021-01-25 05:22:16 | Jefferson, Florida, US |
438926 | 438926 | 2021-01-21 | US | Wisconsin | Rusk | 55107 | 1243 | 15 | 0 | 1228 | 45.47498854 | -91.1333012 | 2021-01-22 05:22:10 | Rusk, Wisconsin, US |
1097342 | 1097342 | 2021-01-20 | US | Texas | Zavala | 48507 | 1376 | 28 | 0 | 1228 | 28.86617238 | -99.76050829 | 2021-01-21 05:22:01 | Zavala, Texas, US |
908660 | 908660 | 2021-01-19 | US | Arkansas | Howard | 5061 | 1248 | 20 | 0 | 1228 | 34.09007427 | -93.9934871 | 2021-01-20 05:21:54 | Howard, Arkansas, US |
237723 | 237723 | 2021-01-18 | US | Arkansas | Howard | 5061 | 1248 | 20 | 0 | 1228 | 34.09007427 | -93.9934871 | 2021-01-19 05:22:15 | Howard, Arkansas, US |
3516759 | 3516759 | 2021-01-15 | US | Kentucky | Anderson | 21005 | 1232 | 4 | 0 | 1228 | 38.00671029 | -84.99171713 | 2021-01-16 05:22:40 | Anderson, Kentucky, US |
3881541 | 3881541 | 2021-01-14 | US | Missouri | Vernon | 29217 | 1257 | 29 | 0 | 1228 | 37.8457799 | -94.34127305 | 2021-01-15 05:22:24 | Vernon, Missouri, US |
3309352 | 3309352 | 2021-01-13 | US | Iowa | Allamakee | 19005 | 1254 | 26 | 0 | 1228 | 43.28383218 | -91.37860922 | 2021-01-14 05:22:32 | Allamakee, Iowa, US |
156927 | 156927 | 2021-01-08 | US | Tennessee | Humphreys | 47085 | 1284 | 15 | 0 | 1228 | 36.03958805 | -87.77992872 | 2021-01-09 05:22:18 | Humphreys, Tennessee, US |
154244 | 154244 | 2021-01-08 | Russia | Yaroslavl Oblast | 23807 | 227 | 22352 | 1228 | 57.77819760000001 | 39.0021095 | 2021-01-09 05:22:18 | Yaroslavl Oblast, Russia | ||
2866339 | 2866339 | 2021-01-06 | US | Michigan | Gladwin | 26051 | 1262 | 34 | 0 | 1228 | 43.98901072 | -84.38774817 | 2021-01-07 05:22:03 | Gladwin, Michigan, US |
2866336 | 2866336 | 2021-01-06 | US | Michigan | Emmet | 26047 | 1261 | 33 | 0 | 1228 | 45.52625509 | -84.89083249 | 2021-01-07 05:22:03 | Emmet, Michigan, US |
2865678 | 2865678 | 2021-01-06 | US | Illinois | Clay | 17025 | 1260 | 32 | 0 | 1228 | 38.75388572 | -88.48914513 | 2021-01-07 05:22:03 | Clay, Illinois, US |
2864919 | 2864919 | 2021-01-06 | Russia | Kamchatka Krai | 10551 | 82 | 9241 | 1228 | 57.1914882 | 160.03838190000005 | 2021-01-07 05:22:03 | Kamchatka Krai, Russia | ||
3036591 | 3036591 | 2021-01-05 | US | North Carolina | Caswell | 37033 | 1237 | 9 | 0 | 1228 | 36.39312665 | -79.33353281 | 2021-01-06 05:22:16 | Caswell, North Carolina, US |
3036165 | 3036165 | 2021-01-05 | US | Missouri | Benton | 29015 | 1244 | 16 | 0 | 1228 | 38.29503305 | -93.28756116 | 2021-01-06 05:22:16 | Benton, Missouri, US |
1062667 | 1062667 | 2021-01-04 | US | Georgia | Jones | 13169 | 1252 | 24 | 0 | 1228 | 33.02512137 | -83.56019163 | 2021-01-05 05:21:49 | Jones, Georgia, US |
1062109 | 1062109 | 2021-01-04 | Russia | Yaroslavl Oblast | 23048 | 209 | 21611 | 1228 | 57.77819760000001 | 39.0021095 | 2021-01-05 05:21:49 | Yaroslavl Oblast, Russia | ||
3232029 | 3232029 | 2021-01-03 | US | Maryland | Talbot | 24041 | 1236 | 8 | 0 | 1228 | 38.76618159 | -76.10882561 | 2021-01-04 05:22:02 | Talbot, Maryland, US |
2228335 | 2228335 | 2021-01-02 | US | Georgia | Jeff Davis | 13161 | 1263 | 35 | 0 | 1228 | 31.80405727 | -82.63724870000001 | 2021-01-03 05:22:52 | Jeff Davis, Georgia, US |
769393 | 769393 | 2020-12-29 | US | Texas | Fayette | 48149 | 1257 | 32 | 0 | 1228 | 29.87788372 | -96.92076062 | 2020-12-30 05:22:34 | Fayette, Texas, US |
767793 | 767793 | 2020-12-29 | US | Kentucky | Woodford | 21239 | 1229 | 1 | 0 | 1228 | 38.04178222 | -84.7417556 | 2020-12-30 05:22:34 | Woodford, Kentucky, US |
205110 | 205110 | 2020-12-25 | US | South Dakota | Dewey | 46041 | 1240 | 12 | 0 | 1228 | 45.15639647 | -100.8709139 | 2020-12-26 05:22:28 | Dewey, South Dakota, US |
3694333 | 3694333 | 2020-12-24 | US | South Dakota | Dewey | 46041 | 1240 | 12 | 0 | 1228 | 45.15639647 | -100.8709139 | 2020-12-25 05:22:48 | Dewey, South Dakota, US |
3771088 | 3771088 | 2020-12-22 | US | Iowa | Mills | 19129 | 1241 | 13 | 0 | 1228 | 41.03299766 | -95.61920963 | 2020-12-23 05:22:03 | Mills, Iowa, US |
930982 | 930982 | 2020-12-21 | US | Virginia | Amherst | 51009 | 1236 | 8 | 0 | 1228 | 37.60308293 | -79.14548696 | 2020-12-22 05:22:33 | Amherst, Virginia, US |
2120521 | 2120521 | 2020-12-20 | US | Georgia | Harris | 13145 | 1257 | 29 | 0 | 1228 | 32.73709786 | -84.90538572 | 2020-12-21 05:27:58 | Harris, Georgia, US |
1902736 | 1902736 | 2020-12-18 | US | Maryland | Garrett | 24023 | 1258 | 30 | 0 | 1228 | 39.52786077 | -79.27355126 | 2020-12-19 05:27:52 | Garrett, Maryland, US |
1901660 | 1901660 | 2020-12-18 | US | Arkansas | Logan | 5083 | 1238 | 10 | 0 | 1228 | 35.21413234 | -93.71951016 | 2020-12-19 05:27:52 | Logan, Arkansas, US |
2128358 | 2128358 | 2020-12-17 | US | Alabama | Fayette | 1057 | 1246 | 18 | 0 | 1228 | 33.72076938 | -87.73886638 | 2020-12-18 05:28:18 | Fayette, Alabama, US |
3151582 | 3151582 | 2020-12-16 | US | Montana | Glacier | 30035 | 1250 | 22 | 0 | 1228 | 48.70513576 | -112.9934235 | 2020-12-17 05:28:12 | Glacier, Montana, US |
3150430 | 3150430 | 2020-12-16 | US | Georgia | Monroe | 13207 | 1289 | 61 | 0 | 1228 | 33.014289 | -83.92097166 | 2020-12-17 05:28:12 | Monroe, Georgia, US |
1752260 | 1752260 | 2020-12-14 | US | Illinois | Jo Daviess | 17085 | 1248 | 20 | 0 | 1228 | 42.36542373 | -90.21094405 | 2020-12-15 05:26:38 | Jo Daviess, Illinois, US |
846738 | 846738 | 2020-12-12 | US | Iowa | Clayton | 19043 | 1252 | 24 | 0 | 1228 | 42.84443388 | -91.34133693 | 2020-12-13 05:27:20 | Clayton, Iowa, US |
1603617 | 1603617 | 2020-12-10 | US | Virginia | Smyth | 51173 | 1264 | 36 | 0 | 1228 | 36.84455636 | -81.53344948 | 2020-12-11 05:26:59 | Smyth, Virginia, US |
1600558 | 1600558 | 2020-12-10 | US | Alabama | Barbour | 1005 | 1258 | 30 | 0 | 1228 | 31.868263 | -85.3871286 | 2020-12-11 05:26:59 | Barbour, Alabama, US |
1821050 | 1821050 | 2020-12-08 | US | New York | Tioga | 36107 | 1280 | 52 | 0 | 1228 | 42.16852837 | -76.30835812 | 2020-12-09 05:28:01 | Tioga, New York, US |
2350830 | 2350830 | 2020-12-07 | US | Virginia | Tazewell | 51185 | 1236 | 8 | 0 | 1228 | 37.12191123 | -81.56685568 | 2020-12-08 05:27:42 | Tazewell, Virginia, US |
2348643 | 2348643 | 2020-12-07 | US | Iowa | Page | 19145 | 1233 | 5 | 0 | 1228 | 40.7393172 | -95.1497813 | 2020-12-08 05:27:42 | Page, Iowa, US |
1632763 | 1632763 | 2020-12-05 | US | Arkansas | Chicot | 5017 | 1256 | 28 | 0 | 1228 | 33.26458973 | -91.29539209 | 2020-12-06 05:26:18 | Chicot, Arkansas, US |
3862242 | 3862242 | 2020-12-04 | US | North Dakota | Richland | 38077 | 1281 | 11 | 0 | 1228 | 46.26440649 | -96.94852979 | 2020-12-05 05:27:36 | Richland, North Dakota, US |
738683 | 738683 | 2020-12-02 | US | Alabama | Marengo | 1091 | 1252 | 24 | 0 | 1228 | 32.24767634 | -87.78796182 | 2020-12-03 05:28:22 | Marengo, Alabama, US |
2539912 | 2539912 | 2020-12-01 | US | Oklahoma | Adair | 40001 | 1241 | 13 | 0 | 1228 | 35.88494195 | -94.65859267 | 2020-12-02 05:27:41 | Adair, Oklahoma, US |
1586130 | 1586130 | 2020-11-30 | US | Missouri | Warren | 29219 | 1230 | 2 | 0 | 1228 | 38.76529479 | -91.16124662 | 2020-12-01 05:26:18 | Warren, Missouri, US |
1585523 | 1585523 | 2020-11-30 | US | Kentucky | Bell | 21013 | 1247 | 19 | 0 | 1228 | 36.73355174 | -83.67766671 | 2020-12-01 05:26:18 | Bell, Kentucky, US |
1584916 | 1584916 | 2020-11-30 | US | Georgia | Burke | 13033 | 1243 | 15 | 0 | 1228 | 33.05917989 | -81.99928721 | 2020-12-01 05:26:18 | Burke, Georgia, US |
1976025 | 1976025 | 2020-11-25 | US | Washington | Lewis | 53041 | 1246 | 18 | 0 | 1228 | 46.57756476 | -122.3925769 | 2020-11-26 05:27:44 | Lewis, Washington, US |
1352012 | 1352012 | 2020-11-24 | US | Minnesota | Cass | 27021 | 1236 | 8 | 0 | 1228 | 46.95043611 | -94.32603968 | 2020-11-25 05:27:20 | Cass, Minnesota, US |
3192035 | 3192035 | 2020-11-22 | US | Nebraska | Colfax | 31037 | 1238 | 10 | 0 | 1228 | 41.57486951 | -97.0868542 | 2020-11-23 05:25:26 | Colfax, Nebraska, US |
3190966 | 3190966 | 2020-11-22 | US | Illinois | Fulton | 17057 | 1237 | 9 | 0 | 1228 | 40.47289135 | -90.20862357 | 2020-11-23 05:25:26 | Fulton, Illinois, US |
3838894 | 3838894 | 2020-11-21 | US | North Dakota | Rolette | 38079 | 1265 | 14 | 0 | 1228 | 48.77245354 | -99.84097493 | 2020-11-22 05:25:45 | Rolette, North Dakota, US |
3837871 | 3837871 | 2020-11-21 | US | Kentucky | Franklin | 21073 | 1242 | 14 | 0 | 1228 | 38.2379395 | -84.87962551 | 2020-11-22 05:25:45 | Franklin, Kentucky, 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]);