# My COVID-19 App to Venezuela and South America **URL:** \ **Category:** Project Showcase\ **Created:** [March 25, 2020, 7:39pm UTC](https://community.glideapps.com/t/my-covid-19-app-to-venezuela-and-south-america/5849 "2020-03-25T19:39:13Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 25, 2020, 7:39pm UTC](https://community.glideapps.com/t/my-covid-19-app-to-venezuela-and-south-america/5849/1 "2020-03-25T19:39:13Z")
Hi friends, It is my contribution to keep informing the CODIV-19 status in my country (Venezuela) and South America [https://vzla-covid19.glideapp.io/](https://vzla-covid19.glideapp.io/) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/4517e5fa198eb35999f99581528f08df0bd6c007.jpeg) I used Charts and Maps to make it more friendly and usefull with data generated by _Johns Hopkins CSSE_ and [https://covid-19.datasettes.com](https://covid-19.datasettes.com) everyday. The data is read and handled automatically by my App using this query: **_select day, country\_or\_region, province\_or\_state, confirmed, deaths, recovered, last\_update from daily\_reports where country\_or\_region=‘Venezuela’ order by day limit 101_** but if you load it from Google Sheet, the syntax must be: =IMPORTHTML(“[https://covid-19.datasettes.com/covid?sql=select+day%2C+country\_or\_region%2C+province\_or\_state%2C+confirmed%2C+deaths%2C+recovered%2C+last\_update+from+daily\_reports+where+country\_or\_region%3D’Venezuela’+order+by+day+limit+101](https://covid-19.datasettes.com/covid?sql=select+day%2C+country_or_region%2C+province_or_state%2C+confirmed%2C+deaths%2C+recovered%2C+last_update+from+daily_reports+where+country_or_region%3D%27Venezuela%27+order+by+day+limit+101)”; “table”; 1) The data has a delay of 24 hours, I have 2 days testing it and its updating works fine. I still don;t know if the refresing time is ruled by Johns Hopkins CSSE or GitHub’s folks but if they improve it, my App will do as well. I hope it can help everyone and we overcome this crisis in the best way. Greetings and take care. Saludos para todos! Gavp ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [March 25, 2020, 7:45pm UTC](https://community.glideapps.com/t/my-covid-19-app-to-venezuela-and-south-america/5849/2 "2020-03-25T19:45:26Z")
It looks FANTASTIC! ---
**Author:** ![Krivo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/krivo/32/5363_2.png) [@Krivo](https://community.glideapps.com/u/Krivo)\ **Post date:** [March 25, 2020, 8:33pm UTC](https://community.glideapps.com/t/my-covid-19-app-to-venezuela-and-south-america/5849/3 "2020-03-25T20:33:42Z")
Looks really cool. Keep up the good work 👍👍 ---
**Author:** ![Kingi\_Gilbert](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kingi_gilbert/32/4674_2.png) [@Kingi\_Gilbert](https://community.glideapps.com/u/Kingi_Gilbert)\ **Post date:** [March 26, 2020, 10:10am UTC](https://community.glideapps.com/t/my-covid-19-app-to-venezuela-and-south-america/5849/4 "2020-03-26T10:10:49Z")
Awesome! I need to study your skills! here is my COVID app www.resilient.im for New Zealand. ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 26, 2020, 2:52pm UTC](https://community.glideapps.com/t/my-covid-19-app-to-venezuela-and-south-america/5849/5 "2020-03-26T14:52:16Z")
Hi @Kingi_Gilbert I see you are using your our charts based on Google Sheet, although they look fine too, the Glide’s ones do the job better and consume less time to set up (my point of view). Good point/idea to include a news section in your app. The only problem I see is that one has to do that job manually and I try avoing it, I just want App to do this dirty job automatically 🙂 Best regards Saludos! Gavp ---
**Author:** ![eltintero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eltintero/32/76520_2.png) [@eltintero](https://community.glideapps.com/u/eltintero)\ **Post date:** [March 26, 2020, 2:57pm UTC](https://community.glideapps.com/t/my-covid-19-app-to-venezuela-and-south-america/5849/6 "2020-03-26T14:57:55Z")
felicidades @gvalero !! Quedó super bien! ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [March 28, 2020, 6:53pm UTC](https://community.glideapps.com/t/my-covid-19-app-to-venezuela-and-south-america/5849/7 "2020-03-28T18:53:55Z")
Please add it here: [covid-apps.glideapp.io](http://covid-apps.glideapp.io)