# Free Template w/ full details of every UN country

**URL:** https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467
**Category:** Community Resources
**Created:** [June 26, 2020, 2:25am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467 "2020-06-26T02:25:48Z")
**Posts on this page:** 20
**Page:** 1

<div class="post-metadata">

### Author: ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [June 26, 2020, 2:25am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/1 "2020-06-26T02:25:48Z")

</div>

Hey all,

I had to collect global country data for a project so thought I would share more widely so that people can use the data.

It’s a full list of 197 countries, their flags, country code & co-ordinates. That’s all 193 UN member states, plus Palestine, Taiwan, Kosovo and the Vatican. The data is from Google.

Pretty handy data in case you ever need to plot every country on a map or show every country in a choice component.

In the app, you can check off countries you’ve visited and view them on a map.

Copy away, have fun & post a link to anything cool you create in here.

> **[Countries](https://197countries.glideapp.io/)**
>
> Keep track of which countries you've visited. A list of 197 countries - all 193 UN member states, plus Palestine, Taiwan, Kosovo and the Vatican.

 ![Screen Shot 2020-06-26 at 12.19.58 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/6/6edb343be7ed9f1345a463e942d6a4f41e28ff70.png)

 ![Screen Shot 2020-06-26 at 12.22.18 pm](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/f/feda2aceb1dd9a81608481e161d5f3ce6e7c63a3.png)

---

<div class="post-metadata">

### Author: ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)
#### Post date: [June 26, 2020, 2:31am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/2 "2020-06-26T02:31:07Z")

</div>

Thank you.

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 26, 2020, 2:34am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/3 "2020-06-26T02:34:51Z")

</div>

Thank you Jaime.

---

<div class="post-metadata">

### 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: [June 26, 2020, 2:46am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/4 "2020-06-26T02:46:42Z")

</div>

Thanks… great tool!

---

<div class="post-metadata">

### Author: ![Ofer\_Chama](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/ofer_chama/32/9007_2.png) [@Ofer\_Chama](https://community.glideapps.com/u/Ofer_Chama)
#### Post date: [June 26, 2020, 11:12am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/5 "2020-06-26T11:12:06Z")

</div>

Thanks Jaime, that’s super helpful!

Too bad I compiled a list of my own just a week ago ☹

Yours is more detailed though, so I’ll definitely use it in the future.

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [June 26, 2020, 11:14am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/6 "2020-06-26T11:14:13Z")

</div>

Nice app!

Now you know the 24 countries & continents where I’ve been! 😄👍🏻

---

<div class="post-metadata">

### Author: ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [June 27, 2020, 4:03am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/7 "2020-06-27T04:03:01Z")

</div>

Nice, good list 😃

---

<div class="post-metadata">

### Author: ![valerio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/valerio/32/5158_2.png) [@valerio](https://community.glideapps.com/u/valerio)
#### Post date: [June 27, 2020, 8:28am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/8 "2020-06-27T08:28:02Z")

</div>

Great !!

---

<div class="post-metadata">

### 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: [June 27, 2020, 11:10am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/9 "2020-06-27T11:10:15Z")

</div>

@Christophe_HK and I know as well 😉

> [@Copy this app - GDPR databreach](https://community.glideapps.com/t/copy-this-app-gdpr-databreach/11534):
>
> My app’s URL: any copyable app - but example : [https://197countries.glideapp.io/](https://197countries.glideapp.io/) When an app with sign-in “public with e-mail” is made copyable the Users sheet still contains the existing users e-mail adress when it is copied. That is a GDPR databreach. The rest of the user specific data seems to be removed but the actual user specific entries (which countries have you visited) are actually accessable in the builder if you use the “Preview as” Edit Favorites which is user-specific data are al…

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [June 27, 2020, 11:18am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/10 "2020-06-27T11:18:46Z")

</div>

I still wait your invitation to drink a beer @Krivo, I then will be able to add one more country in my shared list!

---

<div class="post-metadata">

### 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: [June 27, 2020, 11:21am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/11 "2020-06-27T11:21:08Z")

</div>

@Christophe_HK Hereby given 🙂 When will you be here? I have a large tent in the garden with draft beer - son finished high school yesterday.  
You can just give a call when you are in the vicinity of Copenhagen

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [June 27, 2020, 11:24am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/12 "2020-06-27T11:24:10Z")

</div>

Challenge accepted! It would be nice to meet! If you come in Nice area, do not hesitate to let me know, we have also draft beer (local!) and our “limoncello” is tasty (with ice cubes, lot of ice cubes!) !

---

<div class="post-metadata">

### Author: ![Christophe\_HK](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christophe_hk/32/4161_2.png) [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [June 27, 2020, 11:25am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/13 "2020-06-27T11:25:13Z")

</div>

Yep, personal user specific data should be avoided, and all personal data should remain in a gsheet (in a pro Gsuite drive)…

> [@Sad (but now HAPPY) story. Lost 8 projects over GDPR issues - new feature added](https://community.glideapps.com/t/sad-story-lost-8-projects-over-gdpr-issues/10944/71):
>
> Hey @Rosewebstudio Problem is that to keep in sync with GDPR requirements, you have to proof the user has voluntarily and clearly given his consentement and that he’s been clearly informed about the why, the what and the how. So in your database, you have to store the date of his consentement, and even the name of the consentement form. That means you do need at least one checkbox to collect his email for sign-up and/or login, plus other checkboxes if you also need his consentement for other pu…

---

<div class="post-metadata">

### Author: ![Lucas\_Pires](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lucas_pires/32/64863_2.png) [@Lucas\_Pires](https://community.glideapps.com/u/Lucas_Pires)
#### Post date: [June 28, 2020, 4:51am UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/14 "2020-06-28T04:51:33Z")

</div>

Thanks @Jaime! I’ve visited only my own, unfortunately lol

---

<div class="post-metadata">

### Author: ![Jaybird\_Farrow](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaybird_farrow/32/135_2.png) [@Jaybird\_Farrow](https://community.glideapps.com/u/Jaybird_Farrow)
#### Post date: [June 28, 2020, 7:16pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/15 "2020-06-28T19:16:07Z")

</div>

Thank you for this… i’m working on a project this will come in handy… much appreciated…

---

<div class="post-metadata">

### Author: ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [June 28, 2020, 10:27pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/16 "2020-06-28T22:27:44Z")

</div>

Glad I could be of assistance 👍

---

<div class="post-metadata">

### Author: ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)
#### Post date: [June 29, 2020, 6:36pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/17 "2020-06-29T18:36:36Z")

</div>

I am teaching a class on using glide to build a basic app. I shared this with some of my students. I had someone ask if anyone made a similar one for the 50 states of the USA.

Is there anyone out there who has made one for visiting states in the United States?

Thanks for this great resource!

---

<div class="post-metadata">

### Author: ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [June 29, 2020, 9:15pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/18 "2020-06-29T21:15:13Z")

</div>

Nice. If you get hold of the state data send it through and I’ll add it to the app

---

<div class="post-metadata">

### Author: ![spencersRus](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/spencersrus/32/69_2.png) [@spencersRus](https://community.glideapps.com/u/spencersRus)
#### Post date: [July 3, 2020, 10:49pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/19 "2020-07-03T22:49:55Z")

</div>

Well, not as fancy as your masterpiece (I kept it public for my kids to use) - But I copied your app and changed the facts to the USA.

[https://50nifty.glideapp.io/](https://50nifty.glideapp.io/)

---

<div class="post-metadata">

### Author: ![Jaime](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jaime/32/72726_2.png) [@Jaime](https://community.glideapps.com/u/Jaime)
#### Post date: [July 3, 2020, 11:44pm UTC](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467/20 "2020-07-03T23:44:51Z")

</div>

Nice, thanks @spencersRus. I’ve added the states to the USA.

And now you can set your location & see how far each country is away from you, using the location component.

 ![Screen Shot 2020-07-04 at 9.42.06 am](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/8/85168ab07e0669dfead5afb4c2aaf4912e06f47a.png)

 ![Screen Shot 2020-07-04 at 9.42.24 am](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/9/91c0f7f6bcfc3878f3d5a132a0aa2c567e26d8e3.png)

[Next page](https://community.glideapps.com/t/free-template-w-full-details-of-every-un-country/11467.md?page=2)
