------------------------------------------------------------ WORLDWIDE COUNTRIES LIST Wecare.LGBT opensource repository ------------------------------------------------------------ Table of Contents 1. Worldwide Countries List 1.1 Structure 1.2 How to use the data 1.3 Wecare.LGBT User groups 1.4 How to help 2. About Wecare.LGBT 2.1 Support 2.2 Licence 2.3 Essential Documentation ------------------------- 1. WORLDWIDE COUNTRIES LIST ------------------------- A list of 254 countries and territories worldwide. The CSV file provides essential information such as continent and region and FIPS codes. The database also contains LGBTQIA+ related information, such as whether any given country criminalizes same-sex relationships and if the maximum penalty of death applies. ------------------------- 1.1 STRUCTURE ------------------------- The database contains 32 fields (columns) and will be available in CSV format. Supporting images (if applicable) will be available via a zipped file and in various image formats (jpegs, gifs and pngs) and sizes. The database schema is as follows: - ------------------------------------------------------- Field Name | Type | Description ------------------------------------------------------- CtyId | Text | The unique identifier of the country CtyCode | Text | The unique country code of the database CtyFipsCode | Text | The Federal Information Processing Standard, known as FIPS Code, is a two-character country code CtyIso2 | Text | The ISO 3166-1 alpha two-character country code CtyIso3 | Text | The ISO 3166-1 alpha three-character country code CtyNumCode | Number | The three-digit numeric code used by many statistical tools and services CtySubdivCode | Text | The full ISO 3166-2 country code CtyConCode | Text | The three-character continent code - see continent codes CtySubConCode | Text | The three-character sub region code - see region codes CtyWhoRegion | Text | The World Health Organisation region code CtyIndepd | Boolean | The status of whether a country is independent (yes or no) CtyName | Text | The name of a country CtyOfficialName | Text | The official name of a country CtySovn | Text | The sovereignty of a country CtyAltName | Text | The alternative names in different languages of a country CtyCapital | Text | The capital city of a country CtyTld | Text | The internet suffix or a country CtyCurrencyCode | Text | The currency code used by a particular country CtyCurrencyName | Text | The name of the currency used by a specific country CtyDialNo | Text | The telephone dialling code used by a particular country CtyAreaKm2 | Number | The total area of a country (in km2) CtyAreaMi2 | Number | The total area of a country (in mi2) CtyLandKm2 | Number | The total land area of a country (in km2) CtyLandMi2 | Number | The total land area of a country (in mi2) CtyWaterKm2 | Number | The total water area of a country (in km2) CtyWaterMi2 | Number | The total water area of a country (in mi2) CtyLargIsland | Text | The name of the largest island CtyNoIslands | Number | The total number of islands - if unknown, 0 might be used CtyLgbtIllegal | Boolean | The status of whether it is illegal to form same-sex relationships (Yes or No) CtyLgbtPenalty | Text | The maximum penalty, if prosecuted (none, not enforced, mild, heavy, vigilante, death) - see penalty meaning CtyLgbtMarriage | Boolean | The status of same-sex marriage within a particular country (Yes or No) CtyLgbtUnion | Boolean | The status of same-sex unions or partnerships within a specific country (Yes or No) - - - - - - - - - - CONTINENT CODES: - - - - - - - - - - AFR: Africa AME: Americas ASI: Asia EUR: Europe OCE: Oceania - - - - - - - - - - REGION CODES: - - - - - - - - - - AFC: Central Africa AFE: Eastern Africa AFN: Northern Africa AFS: Southern Africa AFW: Western Africa AMA: Caribbean AMC: Central America AMN: North America AMS: South America ASC: South-central Asia ASE: Eastern Asia ASS: South-eastern Asia ASW: Western Asia EUE: Eastern Europe EUN: Northern Europe EUS: Southern Europe EUW: Western Europe OCA: Australasia OCI: Micronesia OCM: Melanesia OCP: Polynesia - - - - - - - - - - PENALTY MEANING - - - - - - - - - - NONE: not illegal, no penalties exist NOT ENFORCED: illegal exists, but the country does not enforce prosecutions MILD: prosecutions up to two years imprisonment HEAVY: prosecutions two years to life imprisonment VIGILANTE: groups of vigilantes, beatings and executions not condemned or stopped by authorities DEATH: the death penalty exists ----------------------------- Sample entries ----------------------------- "c0059","EC","EC","EC","ECU","218","ISO 3166-2:EC","AME","AMS","LATIN AMERICA","Yes","Ecuador","The Republic of Ecuador","UN Member State","Eacuador (Scots Gaelic), Ekwadhor-ईक्वाडोर (Hindi), Ecuador (Afrikaans, Alemannic, Aragonese, Aromanian, Danish, Dutch, Estonian, Finnish, German, Hungarian, Italian, Malay, Norwegian, Romanian, Spanish, Võro), Èguāduō’ěr - 厄瓜多爾 / 厄瓜多尔 (Mandarin Chinese), Èkuador (Acehnese), Ekuador (Indonesian), Ekuadoru - エクアドル (Japanese), Ekuator (Guaraní), Ekvador - Էկվադոր (Armenian), Ekvador - Еквадор (Bulgarian, Macedonian, Serbian, Ukrainian), Ekvador (Croatian, Faroese, Icelandic, Slovene, Turkish), Ekvádor (Czech, Slovak), Ekador - אקודור (Hebrew), Ekvâdor - اكوادور (Persian), Ekvador - Эквадор (Russian), Ekvadora (Latvian), Ekvadoras (Lithuanian), Ekvadori - ეკვადორი (Georgian, Mingrelian), Ekador (Esperanto), Ekador (Filipino/Tagalog, Polish), Ekwador - เอกวาดอร์ (Thai), Ekwadoreu / Ek'wadorŭ - 에콰도르 (Korean), Equador (Portuguese), Équateur (French), Ekadora (Inuktitut), Ikwadoraya - ඉක්වදෝරය (Sinhala), Ekador (Quechua), al-Ikwādūr - الإكوادور (Arabic), Isimerinós - Ισημερινός (Greek), l-Ekwador (Maltese), எக்குவடோர் (Tamil)","Quito",".ec","USD","Dollar","503","276,841","106,889","256,369","98,985","6,720","2,595","Isabela Island","0","Yes","None","Yes","Yes" ------------------------- 1.2 HOW TO USE THE DATA ------------------------- The latest CSV file will be available each week. To use the data, subject to the licence terms and conditions, all you need to do is click on the link and download the link to your local machine. The CSV file and structure is designed to help you quickly upload the data into a database or table such as MySQL. The table and text are available in UTF-8 (UCS Transformation Format 8). 1) Visit the download page (https://wecare.lgbt/download) 2) To quickly and easily upload the data to your chosen database or table, many free and paid tools are available to help - - MYSQL TABLE DATA EXPORT/IMPORT WIZARD - information about the MySQL wizard can be found by visiting the MySQL support documents (https://dev.mysql.com/doc/workbench/en/wb-admin-export-import-table.html) - - WORDPRESS - plugins such as WP All Import and WP Ultimate CSV importer can help and be found within the wordpress.org plugins repository (https://en-gb.wordpress.org/plugins/) - - DRUPAL - modules such as CSV Importer and CKEditor can help and be found within the Drupal.org repository (https://www.drupal.org/project/project_module) - - JOOMLA - extensions such as content uploader and vdata can help and found within the Joomla Extensions Directory (https://extensions.joomla.org/) - - WIX - you can upload the CSV file via the 'Content Manager' in your dashboard. Select the collection you want to open, click on the 'show more' icon and select import items ------------------------- 1.3 WECARE.LGBT USER GROUPS ------------------------- The users of the Wecare.LGBT opensource project typically falls into two groups: - - DATA CONTRIBUTORS – the contributors will typically be service, event organizers or LGBTQIA+ individuals wishing to highlight and promote important events, services and tools for the benefit of the wider community - - DATA RECIPIENTS – the recipients, will typically be creators, website owners, influencers, service providers and information tools. The recipients will make the information available to their users and visitors The list is not exhaustive; however, it highlights the two key group ------------------------- 1.4 HOW YOU CAN HELP ------------------------- The nature of open-source projects means that data contributors and recipients can freely share and use publicly available information. Wecare.LGBT endeavours to provide the latest and most up-to-date information to its users and relies on all parties to help promote and keep the data accurate. If you are a data contributor, create an account and manage your profile and relevant listings. Doing so means that the database will be kept up to date and communicated to a wide variety of services and creators. Services, tools, and websites inform the global LGBTQIA+ community on an ongoing basis. Should you be a data contributor and have any information you wish to share. You can do so by using the contact us page or emailing us at data@wecare.LGBT. Wecare.LGBT is free to use the tool, and we appreciate all those wishing to take part and contribute to the accuracy and completeness of the data ------------------------- 2. ABOUT WECARE.LGBT ------------------------- Wecare.LGBT is an open-source project focused on collecting, organizing and sharing LGBTQ+ related information with the world. The project was created to ensure that community information is recorded and made available freely in a format that is accessible to all. The project aims to become a central library for all LGBTQ+ related data that will grow over time and become a valuable resource widely accessed and used worldwide. Wecare.LGBT was designed so that those from within the community can add and manage the data. The opensource project has two key objectives. The first objective is to share and promote LGBTQIA+ related information, such as upcoming events and tailored and designed resources for the global community. The second is to ensure that the wider internet and visitors to the various websites offering LGBTQIA+ information have up-to-date and accurate information directly from the service creators or event organizers. The nature of the opensource means that the service or event organizers can choose what they share. Encouraging the various types of websites, services and creators worldwide to use the most up to date information. A central repository that the internet can use freely, subject to the permitted purposes and terms of the opensource To learn more about Wecare.LGBT, please visit https://wecare.LGBT ------------------------- 2.1 SUPPORT ------------------------- If you have any questions or problems regarding any of the Wecare.LGBT, please visit the contact us page (https://wecare.lgbt/contact) or via email (support@wecare.lgbt) ------------------------- 2.2 LICENCE ------------------------- Licenced under the creative commons ShareAlike 4.0 - International Public Licence. Copyright 2021 All rights reserved. Wecare.LGBT For the acceptable use and more information about the licence and attribution, please visit https://wecare.lgbt/licensing#license ------------------------- 2.3 ESSENTIAL DOCUMENTATION ------------------------- - - Wecare.LGBT Disclaimer (https://wecare.lgbt/licensing#disclaimer) - - Wecare.LGBT License - ShareAlike 4.0 - International Public Licence (https://wecare.lgbt/licensing#license) - - Wecare.LGBT Code of Conduct (https://wecare.lgbt/licensing#conduct) - - Wecare.LGBT Privacy Notice (https://wecare.lgbt/privacy) - - Creative Commons Attribution-ShareAlike 4.0 - CC BY-SA 4.0 (https://creativecommons.org/licenses/by-sa/4.0/)