johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
26,731 rows where deaths = 19 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
These facets timed out: province_or_state
country_or_region >30
- US 25,048
- Japan 380
- Malaysia 315
- Russia 198
- Colombia 146
- Netherlands 94
- Cyprus 54
- Australia 39
- Ukraine 36
- Canada 32
- Georgia 27
- India 22
- Chile 21
- United Kingdom 19
- Sweden 16
- Uzbekistan 15
- Mauritius 14
- Peru 12
- Timor-Leste 10
- France 9
- Mainland China 9
- Cabo Verde 8
- Guyana 8
- Mozambique 8
- Belize 7
- Maldives 7
- Monaco 7
- Uruguay 7
- Kazakhstan 6
- Latvia 6
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756480 | 2756480 | 2022-12-29 | US | Wisconsin | Pepin | 55091 | 2270 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-30 04:21:04 | Pepin, Wisconsin, US | |
2756386 | 2756386 | 2022-12-29 | US | West Virginia | Doddridge | 54017 | 2474 | 19 | 0 | 39.27057157 | -80.70671527 | 2022-12-30 04:21:04 | Doddridge, West Virginia, US | |
2755807 | 2755807 | 2022-12-29 | US | South Dakota | Perkins | 46105 | 786 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-30 04:21:04 | Perkins, South Dakota, US | |
2755335 | 2755335 | 2022-12-29 | US | North Dakota | Sioux | 38085 | 1611 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-12-30 04:21:04 | Sioux, North Dakota, US | |
2755194 | 2755194 | 2022-12-29 | US | North Carolina | Alleghany | 37005 | 3578 | 19 | 0 | 36.49360862 | -81.12857041 | 2022-12-30 04:21:04 | Alleghany, North Carolina, US | |
2755054 | 2755054 | 2022-12-29 | US | Nevada | Mineral | 32021 | 1461 | 19 | 0 | 38.53841696 | -118.4344506 | 2022-12-30 04:21:04 | Mineral, Nevada, US | |
2755013 | 2755013 | 2022-12-29 | US | Nebraska | Nuckolls | 31129 | 1076 | 19 | 0 | 40.17637905 | -98.04743961 | 2022-12-30 04:21:04 | Nuckolls, Nebraska, US | |
2755002 | 2755002 | 2022-12-29 | US | Nebraska | Knox | 31107 | 1900 | 19 | 0 | 42.63758421 | -97.89178836 | 2022-12-30 04:21:04 | Knox, Nebraska, US | |
2754978 | 2754978 | 2022-12-29 | US | Nebraska | Fillmore | 31059 | 1267 | 19 | 0 | 40.52458567 | -97.59646937 | 2022-12-30 04:21:04 | Fillmore, Nebraska, US | |
2754683 | 2754683 | 2022-12-29 | US | Minnesota | Wabasha | 27157 | 6550 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-12-30 04:21:04 | Wabasha, Minnesota, US | |
2754256 | 2754256 | 2022-12-29 | US | Kansas | Sheridan | 20179 | 896 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-12-30 04:21:04 | Sheridan, Kansas, US | |
2754233 | 2754233 | 2022-12-29 | US | Kansas | Ness | 20135 | 883 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-12-30 04:21:04 | Ness, Kansas, US | |
2754030 | 2754030 | 2022-12-29 | US | Indiana | Ohio | 18115 | 1705 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-30 04:21:04 | Ohio, Indiana, US | |
2753904 | 2753904 | 2022-12-29 | US | Illinois | Henderson | 17071 | 1506 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-12-30 04:21:04 | Henderson, Illinois, US | |
2753827 | 2753827 | 2022-12-29 | US | Idaho | Bear Lake | 16007 | 1132 | 19 | 0 | 42.28269683 | -111.3289238 | 2022-12-30 04:21:04 | Bear Lake, Idaho, US | |
2753555 | 2753555 | 2022-12-29 | US | Colorado | Phillips | 8095 | 1078 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-12-30 04:21:04 | Phillips, Colorado, US | |
2753518 | 2753518 | 2022-12-29 | US | Colorado | Costilla | 8023 | 934 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-12-30 04:21:04 | Costilla, Colorado, US | |
1077486 | 1077486 | 2022-12-28 | US | Wisconsin | Pepin | 55091 | 2267 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-29 04:21:01 | Pepin, Wisconsin, US | |
1077392 | 1077392 | 2022-12-28 | US | West Virginia | Doddridge | 54017 | 2470 | 19 | 0 | 39.27057157 | -80.70671527 | 2022-12-29 04:21:01 | Doddridge, West Virginia, US | |
1076813 | 1076813 | 2022-12-28 | US | South Dakota | Perkins | 46105 | 786 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-29 04:21:01 | Perkins, South Dakota, US | |
1076341 | 1076341 | 2022-12-28 | US | North Dakota | Sioux | 38085 | 1611 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-12-29 04:21:01 | Sioux, North Dakota, US | |
1076200 | 1076200 | 2022-12-28 | US | North Carolina | Alleghany | 37005 | 3578 | 19 | 0 | 36.49360862 | -81.12857041 | 2022-12-29 04:21:01 | Alleghany, North Carolina, US | |
1076060 | 1076060 | 2022-12-28 | US | Nevada | Mineral | 32021 | 1461 | 19 | 0 | 38.53841696 | -118.4344506 | 2022-12-29 04:21:01 | Mineral, Nevada, US | |
1076019 | 1076019 | 2022-12-28 | US | Nebraska | Nuckolls | 31129 | 1076 | 19 | 0 | 40.17637905 | -98.04743961 | 2022-12-29 04:21:01 | Nuckolls, Nebraska, US | |
1076008 | 1076008 | 2022-12-28 | US | Nebraska | Knox | 31107 | 1900 | 19 | 0 | 42.63758421 | -97.89178836 | 2022-12-29 04:21:01 | Knox, Nebraska, US | |
1075984 | 1075984 | 2022-12-28 | US | Nebraska | Fillmore | 31059 | 1267 | 19 | 0 | 40.52458567 | -97.59646937 | 2022-12-29 04:21:01 | Fillmore, Nebraska, US | |
1075689 | 1075689 | 2022-12-28 | US | Minnesota | Wabasha | 27157 | 6539 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-12-29 04:21:01 | Wabasha, Minnesota, US | |
1075641 | 1075641 | 2022-12-28 | US | Minnesota | Jackson | 27063 | 2591 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-29 04:21:01 | Jackson, Minnesota, US | |
1075262 | 1075262 | 2022-12-28 | US | Kansas | Sheridan | 20179 | 896 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-12-29 04:21:01 | Sheridan, Kansas, US | |
1075239 | 1075239 | 2022-12-28 | US | Kansas | Ness | 20135 | 883 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-12-29 04:21:01 | Ness, Kansas, US | |
1075036 | 1075036 | 2022-12-28 | US | Indiana | Ohio | 18115 | 1705 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-29 04:21:01 | Ohio, Indiana, US | |
1074910 | 1074910 | 2022-12-28 | US | Illinois | Henderson | 17071 | 1504 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-12-29 04:21:01 | Henderson, Illinois, US | |
1074833 | 1074833 | 2022-12-28 | US | Idaho | Bear Lake | 16007 | 1132 | 19 | 0 | 42.28269683 | -111.3289238 | 2022-12-29 04:21:01 | Bear Lake, Idaho, US | |
1074561 | 1074561 | 2022-12-28 | US | Colorado | Phillips | 8095 | 1078 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-12-29 04:21:01 | Phillips, Colorado, US | |
1074524 | 1074524 | 2022-12-28 | US | Colorado | Costilla | 8023 | 934 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-12-29 04:21:01 | Costilla, Colorado, US | |
331483 | 331483 | 2022-12-27 | US | Wisconsin | Pepin | 55091 | 2267 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-28 04:21:04 | Pepin, Wisconsin, US | |
331389 | 331389 | 2022-12-27 | US | West Virginia | Doddridge | 54017 | 2469 | 19 | 0 | 39.27057157 | -80.70671527 | 2022-12-28 04:21:04 | Doddridge, West Virginia, US | |
330810 | 330810 | 2022-12-27 | US | South Dakota | Perkins | 46105 | 781 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-28 04:21:04 | Perkins, South Dakota, US | |
330338 | 330338 | 2022-12-27 | US | North Dakota | Sioux | 38085 | 1611 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-12-28 04:21:04 | Sioux, North Dakota, US | |
330197 | 330197 | 2022-12-27 | US | North Carolina | Alleghany | 37005 | 3578 | 19 | 0 | 36.49360862 | -81.12857041 | 2022-12-28 04:21:04 | Alleghany, North Carolina, US | |
330057 | 330057 | 2022-12-27 | US | Nevada | Mineral | 32021 | 1459 | 19 | 0 | 38.53841696 | -118.4344506 | 2022-12-28 04:21:04 | Mineral, Nevada, US | |
330016 | 330016 | 2022-12-27 | US | Nebraska | Nuckolls | 31129 | 1076 | 19 | 0 | 40.17637905 | -98.04743961 | 2022-12-28 04:21:04 | Nuckolls, Nebraska, US | |
330005 | 330005 | 2022-12-27 | US | Nebraska | Knox | 31107 | 1900 | 19 | 0 | 42.63758421 | -97.89178836 | 2022-12-28 04:21:04 | Knox, Nebraska, US | |
329981 | 329981 | 2022-12-27 | US | Nebraska | Fillmore | 31059 | 1267 | 19 | 0 | 40.52458567 | -97.59646937 | 2022-12-28 04:21:04 | Fillmore, Nebraska, US | |
329686 | 329686 | 2022-12-27 | US | Minnesota | Wabasha | 27157 | 6539 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-12-28 04:21:04 | Wabasha, Minnesota, US | |
329638 | 329638 | 2022-12-27 | US | Minnesota | Jackson | 27063 | 2591 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-28 04:21:04 | Jackson, Minnesota, US | |
329259 | 329259 | 2022-12-27 | US | Kansas | Sheridan | 20179 | 895 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-12-28 04:21:04 | Sheridan, Kansas, US | |
329236 | 329236 | 2022-12-27 | US | Kansas | Ness | 20135 | 882 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-12-28 04:21:04 | Ness, Kansas, US | |
329033 | 329033 | 2022-12-27 | US | Indiana | Ohio | 18115 | 1705 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-28 04:21:04 | Ohio, Indiana, US | |
328907 | 328907 | 2022-12-27 | US | Illinois | Henderson | 17071 | 1503 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-12-28 04:21:04 | Henderson, Illinois, US | |
328830 | 328830 | 2022-12-27 | US | Idaho | Bear Lake | 16007 | 1130 | 19 | 0 | 42.28269683 | -111.3289238 | 2022-12-28 04:21:04 | Bear Lake, Idaho, US | |
328558 | 328558 | 2022-12-27 | US | Colorado | Phillips | 8095 | 1078 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-12-28 04:21:04 | Phillips, Colorado, US | |
328521 | 328521 | 2022-12-27 | US | Colorado | Costilla | 8023 | 934 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-12-28 04:21:04 | Costilla, Colorado, US | |
221556 | 221556 | 2022-12-26 | US | Wisconsin | Pepin | 55091 | 2266 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-27 04:21:07 | Pepin, Wisconsin, US | |
221462 | 221462 | 2022-12-26 | US | West Virginia | Doddridge | 54017 | 2464 | 19 | 0 | 39.27057157 | -80.70671527 | 2022-12-27 04:21:07 | Doddridge, West Virginia, US | |
220883 | 220883 | 2022-12-26 | US | South Dakota | Perkins | 46105 | 781 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-27 04:21:07 | Perkins, South Dakota, US | |
220411 | 220411 | 2022-12-26 | US | North Dakota | Sioux | 38085 | 1611 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-12-27 04:21:07 | Sioux, North Dakota, US | |
220270 | 220270 | 2022-12-26 | US | North Carolina | Alleghany | 37005 | 3578 | 19 | 0 | 36.49360862 | -81.12857041 | 2022-12-27 04:21:07 | Alleghany, North Carolina, US | |
220130 | 220130 | 2022-12-26 | US | Nevada | Mineral | 32021 | 1459 | 19 | 0 | 38.53841696 | -118.4344506 | 2022-12-27 04:21:07 | Mineral, Nevada, US | |
220089 | 220089 | 2022-12-26 | US | Nebraska | Nuckolls | 31129 | 1076 | 19 | 0 | 40.17637905 | -98.04743961 | 2022-12-27 04:21:07 | Nuckolls, Nebraska, US | |
220078 | 220078 | 2022-12-26 | US | Nebraska | Knox | 31107 | 1900 | 19 | 0 | 42.63758421 | -97.89178836 | 2022-12-27 04:21:07 | Knox, Nebraska, US | |
220054 | 220054 | 2022-12-26 | US | Nebraska | Fillmore | 31059 | 1267 | 19 | 0 | 40.52458567 | -97.59646937 | 2022-12-27 04:21:07 | Fillmore, Nebraska, US | |
219759 | 219759 | 2022-12-26 | US | Minnesota | Wabasha | 27157 | 6539 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-12-27 04:21:07 | Wabasha, Minnesota, US | |
219711 | 219711 | 2022-12-26 | US | Minnesota | Jackson | 27063 | 2591 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-27 04:21:07 | Jackson, Minnesota, US | |
219332 | 219332 | 2022-12-26 | US | Kansas | Sheridan | 20179 | 895 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-12-27 04:21:07 | Sheridan, Kansas, US | |
219309 | 219309 | 2022-12-26 | US | Kansas | Ness | 20135 | 882 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-12-27 04:21:07 | Ness, Kansas, US | |
219106 | 219106 | 2022-12-26 | US | Indiana | Ohio | 18115 | 1705 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-27 04:21:07 | Ohio, Indiana, US | |
218980 | 218980 | 2022-12-26 | US | Illinois | Henderson | 17071 | 1502 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-12-27 04:21:07 | Henderson, Illinois, US | |
218903 | 218903 | 2022-12-26 | US | Idaho | Bear Lake | 16007 | 1130 | 19 | 0 | 42.28269683 | -111.3289238 | 2022-12-27 04:21:07 | Bear Lake, Idaho, US | |
218631 | 218631 | 2022-12-26 | US | Colorado | Phillips | 8095 | 1078 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-12-27 04:21:07 | Phillips, Colorado, US | |
218594 | 218594 | 2022-12-26 | US | Colorado | Costilla | 8023 | 934 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-12-27 04:21:07 | Costilla, Colorado, US | |
3226013 | 3226013 | 2022-12-25 | US | Wisconsin | Pepin | 55091 | 2265 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-26 04:21:06 | Pepin, Wisconsin, US | |
3225919 | 3225919 | 2022-12-25 | US | West Virginia | Doddridge | 54017 | 2464 | 19 | 0 | 39.27057157 | -80.70671527 | 2022-12-26 04:21:06 | Doddridge, West Virginia, US | |
3225340 | 3225340 | 2022-12-25 | US | South Dakota | Perkins | 46105 | 781 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-26 04:21:06 | Perkins, South Dakota, US | |
3224868 | 3224868 | 2022-12-25 | US | North Dakota | Sioux | 38085 | 1611 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-12-26 04:21:06 | Sioux, North Dakota, US | |
3224727 | 3224727 | 2022-12-25 | US | North Carolina | Alleghany | 37005 | 3578 | 19 | 0 | 36.49360862 | -81.12857041 | 2022-12-26 04:21:06 | Alleghany, North Carolina, US | |
3224587 | 3224587 | 2022-12-25 | US | Nevada | Mineral | 32021 | 1459 | 19 | 0 | 38.53841696 | -118.4344506 | 2022-12-26 04:21:06 | Mineral, Nevada, US | |
3224546 | 3224546 | 2022-12-25 | US | Nebraska | Nuckolls | 31129 | 1076 | 19 | 0 | 40.17637905 | -98.04743961 | 2022-12-26 04:21:06 | Nuckolls, Nebraska, US | |
3224535 | 3224535 | 2022-12-25 | US | Nebraska | Knox | 31107 | 1900 | 19 | 0 | 42.63758421 | -97.89178836 | 2022-12-26 04:21:06 | Knox, Nebraska, US | |
3224511 | 3224511 | 2022-12-25 | US | Nebraska | Fillmore | 31059 | 1267 | 19 | 0 | 40.52458567 | -97.59646937 | 2022-12-26 04:21:06 | Fillmore, Nebraska, US | |
3224216 | 3224216 | 2022-12-25 | US | Minnesota | Wabasha | 27157 | 6539 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-12-26 04:21:06 | Wabasha, Minnesota, US | |
3224168 | 3224168 | 2022-12-25 | US | Minnesota | Jackson | 27063 | 2591 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-26 04:21:06 | Jackson, Minnesota, US | |
3223789 | 3223789 | 2022-12-25 | US | Kansas | Sheridan | 20179 | 895 | 19 | 0 | 39.35018161 | -100.4418259 | 2022-12-26 04:21:06 | Sheridan, Kansas, US | |
3223766 | 3223766 | 2022-12-25 | US | Kansas | Ness | 20135 | 882 | 19 | 0 | 38.47974157 | -99.91547333 | 2022-12-26 04:21:06 | Ness, Kansas, US | |
3223563 | 3223563 | 2022-12-25 | US | Indiana | Ohio | 18115 | 1705 | 19 | 0 | 38.955305 | -84.96515993 | 2022-12-26 04:21:06 | Ohio, Indiana, US | |
3223437 | 3223437 | 2022-12-25 | US | Illinois | Henderson | 17071 | 1502 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-12-26 04:21:06 | Henderson, Illinois, US | |
3223360 | 3223360 | 2022-12-25 | US | Idaho | Bear Lake | 16007 | 1130 | 19 | 0 | 42.28269683 | -111.3289238 | 2022-12-26 04:21:06 | Bear Lake, Idaho, US | |
3223088 | 3223088 | 2022-12-25 | US | Colorado | Phillips | 8095 | 1076 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-12-26 04:21:06 | Phillips, Colorado, US | |
3223051 | 3223051 | 2022-12-25 | US | Colorado | Costilla | 8023 | 933 | 19 | 0 | 37.27732493 | -105.4276548 | 2022-12-26 04:21:06 | Costilla, Colorado, US | |
1021927 | 1021927 | 2022-12-24 | US | Wisconsin | Pepin | 55091 | 2265 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-25 04:21:04 | Pepin, Wisconsin, US | |
1021833 | 1021833 | 2022-12-24 | US | West Virginia | Doddridge | 54017 | 2464 | 19 | 0 | 39.27057157 | -80.70671527 | 2022-12-25 04:21:04 | Doddridge, West Virginia, US | |
1021254 | 1021254 | 2022-12-24 | US | South Dakota | Perkins | 46105 | 781 | 19 | 0 | 45.49049506 | -102.4755586 | 2022-12-25 04:21:04 | Perkins, South Dakota, US | |
1020782 | 1020782 | 2022-12-24 | US | North Dakota | Sioux | 38085 | 1611 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-12-25 04:21:04 | Sioux, North Dakota, US | |
1020641 | 1020641 | 2022-12-24 | US | North Carolina | Alleghany | 37005 | 3578 | 19 | 0 | 36.49360862 | -81.12857041 | 2022-12-25 04:21:04 | Alleghany, North Carolina, US | |
1020501 | 1020501 | 2022-12-24 | US | Nevada | Mineral | 32021 | 1459 | 19 | 0 | 38.53841696 | -118.4344506 | 2022-12-25 04:21:04 | Mineral, Nevada, US | |
1020460 | 1020460 | 2022-12-24 | US | Nebraska | Nuckolls | 31129 | 1076 | 19 | 0 | 40.17637905 | -98.04743961 | 2022-12-25 04:21:04 | Nuckolls, Nebraska, US | |
1020449 | 1020449 | 2022-12-24 | US | Nebraska | Knox | 31107 | 1900 | 19 | 0 | 42.63758421 | -97.89178836 | 2022-12-25 04:21:04 | Knox, Nebraska, US | |
1020425 | 1020425 | 2022-12-24 | US | Nebraska | Fillmore | 31059 | 1267 | 19 | 0 | 40.52458567 | -97.59646937 | 2022-12-25 04:21:04 | Fillmore, Nebraska, US | |
1020130 | 1020130 | 2022-12-24 | US | Minnesota | Wabasha | 27157 | 6539 | 19 | 0 | 44.28424356 | -92.23121312 | 2022-12-25 04:21:04 | Wabasha, Minnesota, US | |
1020082 | 1020082 | 2022-12-24 | US | Minnesota | Jackson | 27063 | 2591 | 19 | 0 | 43.67423373 | -95.15398258 | 2022-12-25 04:21:04 | Jackson, Minnesota, 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]);