Skip to content

Instantly share code, notes, and snippets.

@adegbengaagoro

adegbengaagoro/SettingsCitiesSeeder.ts

Created April 25, 2022 10:40
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save adegbengaagoro/44ef2a05940a386a87c96b9a965be05b to your computer and use it in GitHub Desktop.
Save adegbengaagoro/44ef2a05940a386a87c96b9a965be05b to your computer and use it in GitHub Desktop.
Download ZIP
Country, State and Cities Seeder - Nigeria focused for AdonisJS
Raw
SettingsCitiesSeeder.ts
import BaseSeeder from '@ioc:Adonis/Lucid/Seeder'
import Database from '@ioc:Adonis/Lucid/Database'
import SettingsCity from 'App/Models/SettingsCity'
export default class SettingsCitiesSeeder extends BaseSeeder {
public async run() {
const citiesData = [
{
city_label: 'Agege LGA',
state_id: 25,
},
{
city_label: 'Ajeromi-Ifelodun LGA',
state_id: 25,
},
{
city_label: 'Alimosho LGA',
state_id: 25,
},
{
city_label: 'Amuwo-Odofin LGA',
state_id: 25,
},
{
city_label: 'Apapa LGA',
state_id: 25,
},
{
city_label: 'Badagry LGA',
state_id: 25,
},
{
city_label: 'Epe LGA',
state_id: 25,
},
{
city_label: 'Eti Osa LGA',
state_id: 25,
},
{
city_label: 'Ibeju-Lekki LGA',
state_id: 25,
},
{
city_label: 'Ifako-Ijaiye LGA',
state_id: 25,
},
{
city_label: 'Ikeja LGA',
state_id: 25,
},
{
city_label: 'Ikorodu LGA',
state_id: 25,
},
{
city_label: 'Kosofe LGA',
state_id: 25,
},
{
city_label: 'Lagos Island LGA',
state_id: 25,
},
{
city_label: 'Lagos Mainland LGA',
state_id: 25,
},
{
city_label: 'Mushin LGA',
state_id: 25,
},
{
city_label: 'Ojo LGA',
state_id: 25,
},
{
city_label: 'Oshodi-Isolo LGA',
state_id: 25,
},
{
city_label: 'Shomolu LGA',
state_id: 25,
},
{
city_label: 'Surulere LGA',
state_id: 25,
},
{
city_label: 'Aba North',
state_id: 1,
},
{
city_label: 'Arochukwu',
state_id: 1,
},
{
city_label: 'Aba South',
state_id: 1,
},
{
city_label: 'Bende',
state_id: 1,
},
{
city_label: 'Isiala Ngwa North',
state_id: 1,
},
{
city_label: 'Ikwuano',
state_id: 1,
},
{
city_label: 'Isiala Ngwa South',
state_id: 1,
},
{
city_label: 'Isuikwuato',
state_id: 1,
},
{
city_label: 'Obi Ngwa',
state_id: 1,
},
{
city_label: 'Ohafia',
state_id: 1,
},
{
city_label: 'Osisioma',
state_id: 1,
},
{
city_label: 'Ugwunagbo',
state_id: 1,
},
{
city_label: 'Ukwa East',
state_id: 1,
},
{
city_label: 'Ukwa West',
state_id: 1,
},
{
city_label: 'Umuahia North',
state_id: 1,
},
{
city_label: 'Umuahia South',
state_id: 1,
},
{
city_label: 'Umu Nneochi',
state_id: 1,
},
{
city_label: 'Demsa',
state_id: 2,
},
{
city_label: 'Fufure',
state_id: 2,
},
{
city_label: 'Ganye',
state_id: 2,
},
{
city_label: 'Gayuk',
state_id: 2,
},
{
city_label: 'Gombi',
state_id: 2,
},
{
city_label: 'Grie',
state_id: 2,
},
{
city_label: 'Hong',
state_id: 2,
},
{
city_label: 'Jada',
state_id: 2,
},
{
city_label: 'Larmurde',
state_id: 2,
},
{
city_label: 'Madagali',
state_id: 2,
},
{
city_label: 'Maiha',
state_id: 2,
},
{
city_label: 'Mayo Belwa',
state_id: 2,
},
{
city_label: 'Michika',
state_id: 2,
},
{
city_label: 'Mubi North',
state_id: 2,
},
{
city_label: 'Mubi South',
state_id: 2,
},
{
city_label: 'Numan',
state_id: 2,
},
{
city_label: 'Shelleng',
state_id: 2,
},
{
city_label: 'Song',
state_id: 2,
},
{
city_label: 'Toungo',
state_id: 2,
},
{
city_label: 'Yola North',
state_id: 2,
},
{
city_label: 'Yola South',
state_id: 2,
},
{
city_label: 'Abak',
state_id: 3,
},
{
city_label: 'Eastern Obolo',
state_id: 3,
},
{
city_label: 'Eket',
state_id: 3,
},
{
city_label: 'Esit Eket',
state_id: 3,
},
{
city_label: 'Essien Udim',
state_id: 3,
},
{
city_label: 'Etim Ekpo',
state_id: 3,
},
{
city_label: 'Etinan',
state_id: 3,
},
{
city_label: 'Ibeno',
state_id: 3,
},
{
city_label: 'Ibesikpo Asutan',
state_id: 3,
},
{
city_label: 'Ibiono-Ibom',
state_id: 3,
},
{
city_label: 'Ikot Abasi',
state_id: 3,
},
{
city_label: 'Ika',
state_id: 3,
},
{
city_label: 'Ikono',
state_id: 3,
},
{
city_label: 'Ikot Ekpene',
state_id: 3,
},
{
city_label: 'Ini',
state_id: 3,
},
{
city_label: 'Mkpat-Enin',
state_id: 3,
},
{
city_label: 'Itu',
state_id: 3,
},
{
city_label: 'Mbo',
state_id: 3,
},
{
city_label: 'Nsit-Atai',
state_id: 3,
},
{
city_label: 'Nsit-Ibom',
state_id: 3,
},
{
city_label: 'Nsit-Ubium',
state_id: 3,
},
{
city_label: 'Obot Akara',
state_id: 3,
},
{
city_label: 'Okobo',
state_id: 3,
},
{
city_label: 'Onna',
state_id: 3,
},
{
city_label: 'Oron',
state_id: 3,
},
{
city_label: 'Udung-Uko',
state_id: 3,
},
{
city_label: 'Ukanafun',
state_id: 3,
},
{
city_label: 'Oruk Anam',
state_id: 3,
},
{
city_label: 'Uruan',
state_id: 3,
},
{
city_label: 'Urue-Offong/Oruko',
state_id: 3,
},
{
city_label: 'Uruan',
state_id: 3,
},
{
city_label: 'Aguata',
state_id: 4,
},
{
city_label: 'Anambra East',
state_id: 4,
},
{
city_label: 'Anaocha',
state_id: 4,
},
{
city_label: 'Awka North',
state_id: 4,
},
{
city_label: 'Anambra West',
state_id: 4,
},
{
city_label: 'Awka South',
state_id: 4,
},
{
city_label: 'Ayamelum',
state_id: 4,
},
{
city_label: 'Dunukofia',
state_id: 4,
},
{
city_label: 'Ekwusigo',
state_id: 4,
},
{
city_label: 'Idemili North',
state_id: 4,
},
{
city_label: 'Idemili South',
state_id: 4,
},
{
city_label: 'Ihiala',
state_id: 4,
},
{
city_label: 'Njikoka',
state_id: 4,
},
{
city_label: 'Nnewi North',
state_id: 4,
},
{
city_label: 'Nnewi South',
state_id: 4,
},
{
city_label: 'Ogbaru',
state_id: 4,
},
{
city_label: 'Onitsha North',
state_id: 4,
},
{
city_label: 'Onitsha South',
state_id: 4,
},
{
city_label: 'Orumba North',
state_id: 4,
},
{
city_label: 'Orumba South',
state_id: 4,
},
{
city_label: 'Oyi',
state_id: 4,
},
{
city_label: 'Alkaleri',
state_id: 5,
},
{
city_label: 'Bauchi',
state_id: 5,
},
{
city_label: 'Bogoro',
state_id: 5,
},
{
city_label: 'Damban',
state_id: 5,
},
{
city_label: 'Darazo',
state_id: 5,
},
{
city_label: 'Dass',
state_id: 5,
},
{
city_label: 'Gamawa',
state_id: 5,
},
{
city_label: 'Ganjuwa',
state_id: 5,
},
{
city_label: 'Giade',
state_id: 5,
},
{
city_label: 'Itas/Gadau',
state_id: 5,
},
{
city_label: 'Jama-are',
state_id: 5,
},
{
city_label: 'Katagum',
state_id: 5,
},
{
city_label: 'Kirfi',
state_id: 5,
},
{
city_label: 'Misau',
state_id: 5,
},
{
city_label: 'Ningi',
state_id: 5,
},
{
city_label: 'Shira',
state_id: 5,
},
{
city_label: 'Tafawa Balewa',
state_id: 5,
},
{
city_label: 'Toro',
state_id: 5,
},
{
city_label: 'Warji',
state_id: 5,
},
{
city_label: 'Zaki',
state_id: 5,
},
{
city_label: 'Brass',
state_id: 6,
},
{
city_label: 'Ekeremor',
state_id: 6,
},
{
city_label: 'Kolokuma/Opokuma',
state_id: 6,
},
{
city_label: 'Nembe',
state_id: 6,
},
{
city_label: 'Ogbia',
state_id: 6,
},
{
city_label: 'Sagbama',
state_id: 6,
},
{
city_label: 'Southern Ijaw',
state_id: 6,
},
{
city_label: 'Yenagoa',
state_id: 6,
},
{
city_label: 'Agatu',
state_id: 7,
},
{
city_label: 'Apa',
state_id: 7,
},
{
city_label: 'Ado',
state_id: 7,
},
{
city_label: 'Buruku',
state_id: 7,
},
{
city_label: 'Gboko',
state_id: 7,
},
{
city_label: 'Guma',
state_id: 7,
},
{
city_label: 'Gwer East',
state_id: 7,
},
{
city_label: 'Gwer West',
state_id: 7,
},
{
city_label: 'Akwa Ibom-Ala',
state_id: 7,
},
{
city_label: 'Konshisha',
state_id: 7,
},
{
city_label: 'Kwande',
state_id: 7,
},
{
city_label: 'Logo',
state_id: 7,
},
{
city_label: 'Makurdi',
state_id: 7,
},
{
city_label: 'Obi',
state_id: 7,
},
{
city_label: 'Ogbadibo',
state_id: 7,
},
{
city_label: 'Ohimini',
state_id: 7,
},
{
city_label: 'Oju',
state_id: 7,
},
{
city_label: 'Okpokwu',
state_id: 7,
},
{
city_label: 'Oturkpo',
state_id: 7,
},
{
city_label: 'Tarka',
state_id: 7,
},
{
city_label: 'Ukum',
state_id: 7,
},
{
city_label: 'Ushongo',
state_id: 7,
},
{
city_label: 'Vandeikya',
state_id: 7,
},
{
city_label: 'Abadam',
state_id: 8,
},
{
city_label: 'Askira/Uba',
state_id: 8,
},
{
city_label: 'Bama',
state_id: 8,
},
{
city_label: 'Bayo',
state_id: 8,
},
{
city_label: 'Biu',
state_id: 8,
},
{
city_label: 'Chibok',
state_id: 8,
},
{
city_label: 'Damboa',
state_id: 8,
},
{
city_label: 'Dikwa',
state_id: 8,
},
{
city_label: 'Guzamala',
state_id: 8,
},
{
city_label: 'Gubio',
state_id: 8,
},
{
city_label: 'Hawul',
state_id: 8,
},
{
city_label: 'Gwoza',
state_id: 8,
},
{
city_label: 'Jere',
state_id: 8,
},
{
city_label: 'Kaga',
state_id: 8,
},
{
city_label: 'Kala/Balge',
state_id: 8,
},
{
city_label: 'Konduga',
state_id: 8,
},
{
city_label: 'Kukawa',
state_id: 8,
},
{
city_label: 'Kwaya Kusar',
state_id: 8,
},
{
city_label: 'Mafa',
state_id: 8,
},
{
city_label: 'Magumeri',
state_id: 8,
},
{
city_label: 'Maiduguri',
state_id: 8,
},
{
city_label: 'Mobbar',
state_id: 8,
},
{
city_label: 'Marte',
state_id: 8,
},
{
city_label: 'Monguno',
state_id: 8,
},
{
city_label: 'Ngala',
state_id: 8,
},
{
city_label: 'Nganzai',
state_id: 8,
},
{
city_label: 'Shani',
state_id: 8,
},
{
city_label: 'Abi',
state_id: 9,
},
{
city_label: 'Akamkpa',
state_id: 9,
},
{
city_label: 'Akpabuyo',
state_id: 9,
},
{
city_label: 'Bakassi',
state_id: 9,
},
{
city_label: 'Bekwarra',
state_id: 9,
},
{
city_label: 'Biase',
state_id: 9,
},
{
city_label: 'Boki',
state_id: 9,
},
{
city_label: 'Calabar Municipal',
state_id: 9,
},
{
city_label: 'Calabar South',
state_id: 9,
},
{
city_label: 'Etung',
state_id: 9,
},
{
city_label: 'Ikom',
state_id: 9,
},
{
city_label: 'Obanliku',
state_id: 9,
},
{
city_label: 'Obubra',
state_id: 9,
},
{
city_label: 'Obudu',
state_id: 9,
},
{
city_label: 'Odukpani',
state_id: 9,
},
{
city_label: 'Ogoja',
state_id: 9,
},
{
city_label: 'Yakuur',
state_id: 9,
},
{
city_label: 'Yala',
state_id: 9,
},
{
city_label: 'Aniocha North',
state_id: 10,
},
{
city_label: 'Aniocha South',
state_id: 10,
},
{
city_label: 'Bomadi',
state_id: 10,
},
{
city_label: 'Burutu',
state_id: 10,
},
{
city_label: 'Ethiope West',
state_id: 10,
},
{
city_label: 'Ethiope East',
state_id: 10,
},
{
city_label: 'Ika North East',
state_id: 10,
},
{
city_label: 'Ika South',
state_id: 10,
},
{
city_label: 'Isoko North',
state_id: 10,
},
{
city_label: 'Isoko South',
state_id: 10,
},
{
city_label: 'Ndokwa East',
state_id: 10,
},
{
city_label: 'Ndokwa West',
state_id: 10,
},
{
city_label: 'Okpe',
state_id: 10,
},
{
city_label: 'Oshimili North',
state_id: 10,
},
{
city_label: 'Oshimili South',
state_id: 10,
},
{
city_label: 'Patani',
state_id: 10,
},
{
city_label: 'Sapele',
state_id: 10,
},
{
city_label: 'Udu',
state_id: 10,
},
{
city_label: 'Ughelli North',
state_id: 10,
},
{
city_label: 'Ukwuani',
state_id: 10,
},
{
city_label: 'Ughelli South',
state_id: 10,
},
{
city_label: 'Uvwie',
state_id: 10,
},
{
city_label: 'Warri North',
state_id: 10,
},
{
city_label: 'Warri South',
state_id: 10,
},
{
city_label: 'Warri South West',
state_id: 10,
},
{
city_label: 'Abakaliki',
state_id: 11,
},
{
city_label: 'Afikpo North',
state_id: 11,
},
{
city_label: 'Ebonyi',
state_id: 11,
},
{
city_label: 'Afikpo South',
state_id: 11,
},
{
city_label: 'Ezza North',
state_id: 11,
},
{
city_label: 'Ikwo',
state_id: 11,
},
{
city_label: 'Ezza South',
state_id: 11,
},
{
city_label: 'Ivo',
state_id: 11,
},
{
city_label: 'Ishielu',
state_id: 11,
},
{
city_label: 'Izzi',
state_id: 11,
},
{
city_label: 'Ohaozara',
state_id: 11,
},
{
city_label: 'Ohaukwu',
state_id: 11,
},
{
city_label: 'Onicha',
state_id: 11,
},
{
city_label: 'Akoko-Edo',
state_id: 12,
},
{
city_label: 'Egor',
state_id: 12,
},
{
city_label: 'Esan Central',
state_id: 12,
},
{
city_label: 'Esan North-East',
state_id: 12,
},
{
city_label: 'Esan South-East',
state_id: 12,
},
{
city_label: 'Esan West',
state_id: 12,
},
{
city_label: 'Etsako Central',
state_id: 12,
},
{
city_label: 'Etsako East',
state_id: 12,
},
{
city_label: 'Etsako West',
state_id: 12,
},
{
city_label: 'Igueben',
state_id: 12,
},
{
city_label: 'Ikpoba Okha',
state_id: 12,
},
{
city_label: 'Orhionmwon',
state_id: 12,
},
{
city_label: 'Oredo',
state_id: 12,
},
{
city_label: 'Ovia North-East',
state_id: 12,
},
{
city_label: 'Ovia South-West',
state_id: 12,
},
{
city_label: 'Owan East',
state_id: 12,
},
{
city_label: 'Owan West',
state_id: 12,
},
{
city_label: 'Uhunmwonde',
state_id: 12,
},
{
city_label: 'Ado Ekiti',
state_id: 13,
},
{
city_label: 'Efon',
state_id: 13,
},
{
city_label: 'Ekiti East',
state_id: 13,
},
{
city_label: 'Ekiti South-West',
state_id: 13,
},
{
city_label: 'Ekiti West',
state_id: 13,
},
{
city_label: 'Emure',
state_id: 13,
},
{
city_label: 'Gbonyin',
state_id: 13,
},
{
city_label: 'Ido Osi',
state_id: 13,
},
{
city_label: 'Ijero',
state_id: 13,
},
{
city_label: 'Ikere',
state_id: 13,
},
{
city_label: 'Ilejemeje',
state_id: 13,
},
{
city_label: 'Irepodun/Ifelodun',
state_id: 13,
},
{
city_label: 'Ikole',
state_id: 13,
},
{
city_label: 'Ise/Orun',
state_id: 13,
},
{
city_label: 'Moba',
state_id: 13,
},
{
city_label: 'Oye',
state_id: 13,
},
{
city_label: 'Awgu',
state_id: 14,
},
{
city_label: 'Aninri',
state_id: 14,
},
{
city_label: 'Enugu East',
state_id: 14,
},
{
city_label: 'Enugu North',
state_id: 14,
},
{
city_label: 'Ezeagu',
state_id: 14,
},
{
city_label: 'Enugu South',
state_id: 14,
},
{
city_label: 'Igbo Etiti',
state_id: 14,
},
{
city_label: 'Igbo Eze North',
state_id: 14,
},
{
city_label: 'Igbo Eze South',
state_id: 14,
},
{
city_label: 'Isi Uzo',
state_id: 14,
},
{
city_label: 'Nkanu East',
state_id: 14,
},
{
city_label: 'Nkanu West',
state_id: 14,
},
{
city_label: 'Nsukka',
state_id: 14,
},
{
city_label: 'Udenu',
state_id: 14,
},
{
city_label: 'Oji River',
state_id: 14,
},
{
city_label: 'Uzo Uwani',
state_id: 14,
},
{
city_label: 'Udi',
state_id: 14,
},
{
city_label: 'Abaji',
state_id: 15,
},
{
city_label: 'Bwari',
state_id: 15,
},
{
city_label: 'Gwagwalada',
state_id: 15,
},
{
city_label: 'Kuje',
state_id: 15,
},
{
city_label: 'Kwali',
state_id: 15,
},
{
city_label: 'Municipal Area Council',
state_id: 15,
},
{
city_label: 'Akko',
state_id: 16,
},
{
city_label: 'Balanga',
state_id: 16,
},
{
city_label: 'Billiri',
state_id: 16,
},
{
city_label: 'Dukku',
state_id: 16,
},
{
city_label: 'Funakaye',
state_id: 16,
},
{
city_label: 'Gombe',
state_id: 16,
},
{
city_label: 'Kaltungo',
state_id: 16,
},
{
city_label: 'Kwami',
state_id: 16,
},
{
city_label: 'Nafada',
state_id: 16,
},
{
city_label: 'Shongom',
state_id: 16,
},
{
city_label: 'Yamaltu/Deba',
state_id: 16,
},
{
city_label: 'Aboh Mbaise',
state_id: 17,
},
{
city_label: 'Ahiazu Mbaise',
state_id: 17,
},
{
city_label: 'Ehime Mbano',
state_id: 17,
},
{
city_label: 'Ezinihitte',
state_id: 17,
},
{
city_label: 'Ideato North',
state_id: 17,
},
{
city_label: 'Ideato South',
state_id: 17,
},
{
city_label: 'Ihitte/Uboma',
state_id: 17,
},
{
city_label: 'Ikeduru',
state_id: 17,
},
{
city_label: 'Isiala Mbano',
state_id: 17,
},
{
city_label: 'Mbaitoli',
state_id: 17,
},
{
city_label: 'Isu',
state_id: 17,
},
{
city_label: 'Ngor Okpala',
state_id: 17,
},
{
city_label: 'Njaba',
state_id: 17,
},
{
city_label: 'Nkwerre',
state_id: 17,
},
{
city_label: 'Nwangele',
state_id: 17,
},
{
city_label: 'Obowo',
state_id: 17,
},
{
city_label: 'Oguta',
state_id: 17,
},
{
city_label: 'Ohaji/Egbema',
state_id: 17,
},
{
city_label: 'Okigwe',
state_id: 17,
},
{
city_label: 'Orlu',
state_id: 17,
},
{
city_label: 'Orsu',
state_id: 17,
},
{
city_label: 'Oru East',
state_id: 17,
},
{
city_label: 'Oru West',
state_id: 17,
},
{
city_label: 'Owerri Municipal',
state_id: 17,
},
{
city_label: 'Owerri North',
state_id: 17,
},
{
city_label: 'Unuimo',
state_id: 17,
},
{
city_label: 'Owerri West',
state_id: 17,
},
{
city_label: 'Auyo',
state_id: 18,
},
{
city_label: 'Babura',
state_id: 18,
},
{
city_label: 'Buji',
state_id: 18,
},
{
city_label: 'Biriniwa',
state_id: 18,
},
{
city_label: 'Birnin Kud',
state_id: 18,
},
{
city_label: 'Dutse',
state_id: 18,
},
{
city_label: 'Gagarawa',
state_id: 18,
},
{
city_label: 'Garki',
state_id: 18,
},
{
city_label: 'Gumel',
state_id: 18,
},
{
city_label: 'Guri',
state_id: 18,
},
{
city_label: 'Gwaram',
state_id: 18,
},
{
city_label: 'Gwiwa',
state_id: 18,
},
{
city_label: 'Hadejia',
state_id: 18,
},
{
city_label: 'Jahun',
state_id: 18,
},
{
city_label: 'Kafin Haus',
state_id: 18,
},
{
city_label: 'Kazaure',
state_id: 18,
},
{
city_label: 'Kiri Kasam',
state_id: 18,
},
{
city_label: 'Kiyawa',
state_id: 18,
},
{
city_label: 'Kaugama',
state_id: 18,
},
{
city_label: 'Maigatari',
state_id: 18,
},
{
city_label: 'Malam Mador',
state_id: 18,
},
{
city_label: 'Miga',
state_id: 18,
},
{
city_label: 'Sule Tankarka',
state_id: 18,
},
{
city_label: 'Roni',
state_id: 17,
},
{
city_label: 'Ringim',
state_id: 17,
},
{
city_label: 'Yankwashi',
state_id: 17,
},
{
city_label: 'Taura',
state_id: 18,
},
{
city_label: 'Birnin Gwari',
state_id: 19,
},
{
city_label: 'Chikun',
state_id: 19,
},
{
city_label: 'Giwa',
state_id: 19,
},
{
city_label: 'Ikara',
state_id: 19,
},
{
city_label: 'Igabi',
state_id: 19,
},
{
city_label: 'Jaba',
state_id: 18,
},
{
city_label: 'Jema-a',
state_id: 18,
},
{
city_label: 'Kachia',
state_id: 18,
},
{
city_label: 'Kaduna North',
state_id: 18,
},
{
city_label: 'Kaduna South',
state_id: 18,
},
{
city_label: 'Kagarko',
state_id: 18,
},
{
city_label: 'Kajuru',
state_id: 18,
},
{
city_label: 'Kaura',
state_id: 18,
},
{
city_label: 'Kauru',
state_id: 18,
},
{
city_label: 'Kubau',
state_id: 18,
},
{
city_label: 'Kudan',
state_id: 18,
},
{
city_label: 'Lere',
state_id: 18,
},
{
city_label: 'Makarfi',
state_id: 18,
},
{
city_label: 'Sabon Gari',
state_id: 18,
},
{
city_label: 'Sanga',
state_id: 18,
},
{
city_label: 'Soba',
state_id: 18,
},
{
city_label: 'Zangon Kataf',
state_id: 18,
},
{
city_label: 'Zaria',
state_id: 19,
},
{
city_label: 'Ajingi',
state_id: 20,
},
{
city_label: 'Albasu',
state_id: 20,
},
{
city_label: 'Bagwai',
state_id: 20,
},
{
city_label: 'Bebeji',
state_id: 20,
},
{
city_label: 'Bichi',
state_id: 20,
},
{
city_label: 'Bunkure',
state_id: 20,
},
{
city_label: 'Dala',
state_id: 20,
},
{
city_label: 'Dambatta',
state_id: 20,
},
{
city_label: 'Dawakin Kudu',
state_id: 20,
},
{
city_label: 'Dawakin Tofa',
state_id: 20,
},
{
city_label: 'Doguwa',
state_id: 20,
},
{
city_label: 'Fagge',
state_id: 20,
},
{
city_label: 'Gabasawa',
state_id: 20,
},
{
city_label: 'Garko',
state_id: 20,
},
{
city_label: 'Garun Mallam',
state_id: 20,
},
{
city_label: 'Gezawa',
state_id: 20,
},
{
city_label: 'Gaya',
state_id: 20,
},
{
city_label: 'Gwale',
state_id: 20,
},
{
city_label: 'Gwarzo',
state_id: 20,
},
{
city_label: 'Kabo',
state_id: 20,
},
{
city_label: 'Kano Municipal',
state_id: 20,
},
{
city_label: 'Karaye',
state_id: 20,
},
{
city_label: 'Kibiya',
state_id: 20,
},
{
city_label: 'Kiru',
state_id: 20,
},
{
city_label: 'Kumbotso',
state_id: 20,
},
{
city_label: 'Kunchi',
state_id: 20,
},
{
city_label: 'Kura',
state_id: 20,
},
{
city_label: 'Madobi',
state_id: 20,
},
{
city_label: 'Makoda',
state_id: 20,
},
{
city_label: 'Minjibir',
state_id: 20,
},
{
city_label: 'Nasarawa',
state_id: 20,
},
{
city_label: 'Rano',
state_id: 20,
},
{
city_label: 'Rimin Gado',
state_id: 20,
},
{
city_label: 'Makoda',
state_id: 20,
},
{
city_label: 'Rogo',
state_id: 20,
},
{
city_label: 'Shanono',
state_id: 20,
},
{
city_label: 'Takai',
state_id: 20,
},
{
city_label: 'Sumaila',
state_id: 20,
},
{
city_label: 'Tarauni',
state_id: 20,
},
{
city_label: 'Tofa',
state_id: 20,
},
{
city_label: 'Tsanyawa',
state_id: 20,
},
{
city_label: 'Tudun Wada',
state_id: 20,
},
{
city_label: 'Ungogo',
state_id: 20,
},
{
city_label: 'Warawa',
state_id: 20,
},
{
city_label: 'Wudil',
state_id: 20,
},
{
city_label: 'Bakori',
state_id: 21,
},
{
city_label: 'Batagarawa',
state_id: 21,
},
{
city_label: 'Batsari',
state_id: 21,
},
{
city_label: 'Baure',
state_id: 21,
},
{
city_label: 'Bindawa',
state_id: 21,
},
{
city_label: 'Charanchi',
state_id: 21,
},
{
city_label: 'Danja',
state_id: 21,
},
{
city_label: 'Dandume',
state_id: 21,
},
{
city_label: 'Dan Musa',
state_id: 21,
},
{
city_label: 'Daura',
state_id: 21,
},
{
city_label: 'Dutsi',
state_id: 21,
},
{
city_label: 'Dutsin Ma',
state_id: 21,
},
{
city_label: 'Faskari',
state_id: 21,
},
{
city_label: 'Funtua',
state_id: 21,
},
{
city_label: 'Ingawa',
state_id: 21,
},
{
city_label: 'Jibia',
state_id: 21,
},
{
city_label: 'Kafur',
state_id: 21,
},
{
city_label: 'Kaita',
state_id: 21,
},
{
city_label: 'Kankara',
state_id: 21,
},
{
city_label: 'Kankia',
state_id: 21,
},
{
city_label: 'Katsina',
state_id: 21,
},
{
city_label: 'Kurfi',
state_id: 21,
},
{
city_label: 'Kusada',
state_id: 21,
},
{
city_label: 'Mai-Adua',
state_id: 21,
},
{
city_label: 'Malumfashi',
state_id: 21,
},
{
city_label: 'Mani',
state_id: 21,
},
{
city_label: 'Mashi',
state_id: 21,
},
{
city_label: 'Matazu',
state_id: 21,
},
{
city_label: 'Musawa',
state_id: 21,
},
{
city_label: 'Rimi',
state_id: 21,
},
{
city_label: 'Sabuwa',
state_id: 21,
},
{
city_label: 'Safana',
state_id: 21,
},
{
city_label: 'Sandamu',
state_id: 21,
},
{
city_label: 'Zango',
state_id: 21,
},
{
city_label: 'Aleiro',
state_id: 22,
},
{
city_label: 'Argungu',
state_id: 22,
},
{
city_label: 'Arewa Dandi',
state_id: 22,
},
{
city_label: 'Augie',
state_id: 22,
},
{
city_label: 'Bagudo',
state_id: 22,
},
{
city_label: 'Birnin Kebbi',
state_id: 22,
},
{
city_label: 'Bunza',
state_id: 22,
},
{
city_label: 'Dandi',
state_id: 22,
},
{
city_label: 'Fakai',
state_id: 22,
},
{
city_label: 'Gwandu',
state_id: 22,
},
{
city_label: 'Jega',
state_id: 22,
},
{
city_label: 'Kalgo',
state_id: 22,
},
{
city_label: 'Koko/Besse',
state_id: 22,
},
{
city_label: 'Maiyama',
state_id: 22,
},
{
city_label: 'Ngaski',
state_id: 22,
},
{
city_label: 'Shanga',
state_id: 22,
},
{
city_label: 'Suru',
state_id: 22,
},
{
city_label: 'Sakaba',
state_id: 22,
},
{
city_label: 'Wasagu/Danko',
state_id: 22,
},
{
city_label: 'Yauri',
state_id: 22,
},
{
city_label: 'Zuru',
state_id: 22,
},
{
city_label: 'Ajaokuta',
state_id: 23,
},
{
city_label: 'Adavi',
state_id: 23,
},
{
city_label: 'Ankpa',
state_id: 23,
},
{
city_label: 'Dekina',
state_id: 23,
},
{
city_label: 'Ibaji',
state_id: 23,
},
{
city_label: 'Idah',
state_id: 23,
},
{
city_label: 'Igalamela Odolu',
state_id: 23,
},
{
city_label: 'Ijumu',
state_id: 23,
},
{
city_label: 'Kabba/Bunu',
state_id: 23,
},
{
city_label: 'Kogi',
state_id: 23,
},
{
city_label: 'Lokoja',
state_id: 23,
},
{
city_label: 'Ofu',
state_id: 23,
},
{
city_label: 'Mopa Muro',
state_id: 23,
},
{
city_label: 'Ogori/Magongo',
state_id: 23,
},
{
city_label: 'Okehi',
state_id: 23,
},
{
city_label: 'Okene',
state_id: 23,
},
{
city_label: 'Olamaboro',
state_id: 23,
},
{
city_label: 'Omala',
state_id: 23,
},
{
city_label: 'Yagba East',
state_id: 23,
},
{
city_label: 'Yagba West',
state_id: 23,
},
{
city_label: 'Asa',
state_id: 24,
},
{
city_label: 'Baruten',
state_id: 24,
},
{
city_label: 'Edu',
state_id: 24,
},
{
city_label: 'Ilorin East',
state_id: 24,
},
{
city_label: 'Ifelodun',
state_id: 24,
},
{
city_label: 'Ilorin South',
state_id: 24,
},
{
city_label: 'Ekiti Kwara State',
state_id: 24,
},
{
city_label: 'Ilorin West',
state_id: 24,
},
{
city_label: 'Irepodun',
state_id: 24,
},
{
city_label: 'Isin',
state_id: 24,
},
{
city_label: 'Kaiama',
state_id: 24,
},
{
city_label: 'Moro',
state_id: 24,
},
{
city_label: 'Offa',
state_id: 24,
},
{
city_label: 'Oke Ero',
state_id: 24,
},
{
city_label: 'Oyun',
state_id: 24,
},
{
city_label: 'Pategi',
state_id: 24,
},
{
city_label: 'Akwanga',
state_id: 26,
},
{
city_label: 'Awe',
state_id: 26,
},
{
city_label: 'Doma',
state_id: 26,
},
{
city_label: 'Karu',
state_id: 26,
},
{
city_label: 'Keana',
state_id: 26,
},
{
city_label: 'Keffi',
state_id: 26,
},
{
city_label: 'Lafia',
state_id: 26,
},
{
city_label: 'Kokona',
state_id: 26,
},
{
city_label: 'Nasarawa Egon',
state_id: 26,
},
{
city_label: 'Nasarawa',
state_id: 26,
},
{
city_label: 'Obi',
state_id: 26,
},
{
city_label: 'Toto',
state_id: 26,
},
{
city_label: 'Wamba',
state_id: 26,
},
{
city_label: 'Agaie',
state_id: 27,
},
{
city_label: 'Agwara',
state_id: 27,
},
{
city_label: 'Bida',
state_id: 27,
},
{
city_label: 'Borgu',
state_id: 27,
},
{
city_label: 'Bosso',
state_id: 27,
},
{
city_label: 'Chanchaga',
state_id: 27,
},
{
city_label: 'Edati',
state_id: 27,
},
{
city_label: 'Gbako',
state_id: 27,
},
{
city_label: 'Gurara',
state_id: 27,
},
{
city_label: 'Katcha',
state_id: 27,
},
{
city_label: 'Kontagora',
state_id: 27,
},
{
city_label: 'Lapai',
state_id: 27,
},
{
city_label: 'Lavun',
state_id: 27,
},
{
city_label: 'Mariga',
state_id: 27,
},
{
city_label: 'Magama',
state_id: 27,
},
{
city_label: 'Mokwa',
state_id: 27,
},
{
city_label: 'Mashegu',
state_id: 27,
},
{
city_label: 'Moya',
state_id: 27,
},
{
city_label: 'Paikoro',
state_id: 27,
},
{
city_label: 'Rafi',
state_id: 27,
},
{
city_label: 'Rijau',
state_id: 27,
},
{
city_label: 'Shiroro',
state_id: 27,
},
{
city_label: 'Suleja',
state_id: 27,
},
{
city_label: 'Tafa',
state_id: 27,
},
{
city_label: 'Wushishi',
state_id: 27,
},
{
city_label: 'Abeokuta North',
state_id: 28,
},
{
city_label: 'Abeokuta South',
state_id: 28,
},
{
city_label: 'Ado-Odo/Ota',
state_id: 28,
},
{
city_label: 'Egbado North',
state_id: 28,
},
{
city_label: 'Ewekoro',
state_id: 28,
},
{
city_label: 'Egbado South',
state_id: 28,
},
{
city_label: 'Ijebu North',
state_id: 28,
},
{
city_label: 'Ijebu East',
state_id: 28,
},
{
city_label: 'Ifo',
state_id: 28,
},
{
city_label: 'Ijebu Ode',
state_id: 28,
},
{
city_label: 'Ijebu North East',
state_id: 28,
},
{
city_label: 'Imeko Afon',
state_id: 28,
},
{
city_label: 'Ikenne',
state_id: 28,
},
{
city_label: 'Ipokia',
state_id: 28,
},
{
city_label: 'Odeda',
state_id: 28,
},
{
city_label: 'Obafemi Owode',
state_id: 28,
},
{
city_label: 'Odogbolu',
state_id: 28,
},
{
city_label: 'Remo North',
state_id: 28,
},
{
city_label: 'Ogun Waterside',
state_id: 28,
},
{
city_label: 'Shagamu',
state_id: 28,
},
{
city_label: 'Akoko North-East',
state_id: 29,
},
{
city_label: 'Akoko North-West',
state_id: 29,
},
{
city_label: 'Akoko South-West',
state_id: 29,
},
{
city_label: 'Akoko South-East',
state_id: 29,
},
{
city_label: 'Akure North',
state_id: 29,
},
{
city_label: 'Akure South',
state_id: 29,
},
{
city_label: 'Ese Odo',
state_id: 29,
},
{
city_label: 'Idanre',
state_id: 29,
},
{
city_label: 'Ifedore',
state_id: 29,
},
{
city_label: 'Ilaje',
state_id: 29,
},
{
city_label: 'Irele',
state_id: 29,
},
{
city_label: 'Ile Oluji/Okeigbo',
state_id: 29,
},
{
city_label: 'Odigbo',
state_id: 29,
},
{
city_label: 'Okitipupa',
state_id: 29,
},
{
city_label: 'Ondo West',
state_id: 29,
},
{
city_label: 'Ose',
state_id: 29,
},
{
city_label: 'Ondo East',
state_id: 29,
},
{
city_label: 'Owo',
state_id: 29,
},
{
city_label: 'Aiyedire',
state_id: 30,
},
{
city_label: 'Atakunmosa West',
state_id: 30,
},
{
city_label: 'Atakunmosa East',
state_id: 30,
},
{
city_label: 'Aiyedaade',
state_id: 30,
},
{
city_label: 'Boluwaduro',
state_id: 30,
},
{
city_label: 'Boripe',
state_id: 30,
},
{
city_label: 'Ife East',
state_id: 30,
},
{
city_label: 'Ede South',
state_id: 30,
},
{
city_label: 'Ife North',
state_id: 30,
},
{
city_label: 'Ede North',
state_id: 30,
},
{
city_label: 'Ife South',
state_id: 30,
},
{
city_label: 'Ejigbo',
state_id: 30,
},
{
city_label: 'Ife Central',
state_id: 30,
},
{
city_label: 'Ifedayo',
state_id: 30,
},
{
city_label: 'Egbedore',
state_id: 30,
},
{
city_label: 'Ila',
state_id: 30,
},
{
city_label: 'Ifelodun',
state_id: 30,
},
{
city_label: 'Ilesa East',
state_id: 30,
},
{
city_label: 'Ilesa West',
state_id: 30,
},
{
city_label: 'Irepodun',
state_id: 30,
},
{
city_label: 'Irewole',
state_id: 30,
},
{
city_label: 'Isokan',
state_id: 30,
},
{
city_label: 'Iwo',
state_id: 30,
},
{
city_label: 'Obokun',
state_id: 30,
},
{
city_label: 'Odo Otin',
state_id: 30,
},
{
city_label: 'Ola Oluwa',
state_id: 30,
},
{
city_label: 'Olorunda',
state_id: 30,
},
{
city_label: 'Oriade',
state_id: 30,
},
{
city_label: 'Orolu',
state_id: 30,
},
{
city_label: 'Osogbo',
state_id: 30,
},
{
city_label: 'Afijio',
state_id: 31,
},
{
city_label: 'Akinyele',
state_id: 31,
},
{
city_label: 'Atiba',
state_id: 31,
},
{
city_label: 'Atisbo',
state_id: 31,
},
{
city_label: 'Egbeda',
state_id: 31,
},
{
city_label: 'Ibadan North',
state_id: 31,
},
{
city_label: 'Ibadan North-East',
state_id: 31,
},
{
city_label: 'Ibadan North-West',
state_id: 31,
},
{
city_label: 'Ibadan South-East',
state_id: 31,
},
{
city_label: 'Ibarapa Central',
state_id: 31,
},
{
city_label: 'Ibadan South-West',
state_id: 31,
},
{
city_label: 'Ibarapa East',
state_id: 31,
},
{
city_label: 'Ido',
state_id: 31,
},
{
city_label: 'Ibarapa North',
state_id: 31,
},
{
city_label: 'Irepo',
state_id: 31,
},
{
city_label: 'Iseyin',
state_id: 31,
},
{
city_label: 'Itesiwaju',
state_id: 31,
},
{
city_label: 'Iwajowa',
state_id: 31,
},
{
city_label: 'Kajola',
state_id: 31,
},
{
city_label: 'Lagelu',
state_id: 31,
},
{
city_label: 'Ogbomosho North',
state_id: 31,
},
{
city_label: 'Ogbomosho South',
state_id: 31,
},
{
city_label: 'Ogo Oluwa',
state_id: 31,
},
{
city_label: 'Olorunsogo',
state_id: 31,
},
{
city_label: 'Oluyole',
state_id: 31,
},
{
city_label: 'Ona Ara',
state_id: 31,
},
{
city_label: 'Orelope',
state_id: 31,
},
{
city_label: 'Ori Ire',
state_id: 31,
},
{
city_label: 'Oyo',
state_id: 31,
},
{
city_label: 'Oyo East',
state_id: 31,
},
{
city_label: 'Saki East',
state_id: 31,
},
{
city_label: 'Saki West',
state_id: 31,
},
{
city_label: 'Surulere Oyo State',
state_id: 31,
},
{
city_label: 'Bokkos',
state_id: 32,
},
{
city_label: 'Barkin Ladi',
state_id: 32,
},
{
city_label: 'Bassa',
state_id: 32,
},
{
city_label: 'Jos East',
state_id: 32,
},
{
city_label: 'Jos North',
state_id: 32,
},
{
city_label: 'Jos South',
state_id: 32,
},
{
city_label: 'Kanam',
state_id: 32,
},
{
city_label: 'Kanke',
state_id: 32,
},
{
city_label: 'Langtang South',
state_id: 32,
},
{
city_label: 'Langtang North',
state_id: 32,
},
{
city_label: 'Mangu',
state_id: 32,
},
{
city_label: 'Mikang',
state_id: 32,
},
{
city_label: 'Pankshin',
state_id: 32,
},
{
city_label: 'Qua-an Pan',
state_id: 32,
},
{
city_label: 'Riyom',
state_id: 32,
},
{
city_label: 'Shendam',
state_id: 32,
},
{
city_label: 'Wase',
state_id: 32,
},
{
city_label: 'Abua–Odual',
state_id: 33,
},
{
city_label: 'Ahoada East',
state_id: 33,
},
{
city_label: 'Ahoada West',
state_id: 33,
},
{
city_label: 'Akuku-Toru',
state_id: 33,
},
{
city_label: 'Asari-Toru',
state_id: 33,
},
{
city_label: 'Andoni',
state_id: 33,
},
{
city_label: 'Bonny',
state_id: 33,
},
{
city_label: 'Degema',
state_id: 33,
},
{
city_label: 'Eleme',
state_id: 33,
},
{
city_label: 'Emohua',
state_id: 33,
},
{
city_label: 'Etche',
state_id: 33,
},
{
city_label: 'Gokana',
state_id: 33,
},
{
city_label: 'Ikwerre',
state_id: 33,
},
{
city_label: 'Khana',
state_id: 33,
},
{
city_label: 'Obio-Akpor',
state_id: 33,
},
{
city_label: 'Ogba–Egbema–Ndoni',
state_id: 33,
},
{
city_label: 'Ogu–Bolo',
state_id: 33,
},
{
city_label: 'Okrika',
state_id: 33,
},
{
city_label: 'Omuma',
state_id: 33,
},
{
city_label: 'Opobo–Nkoro',
state_id: 33,
},
{
city_label: 'Oyigbo',
state_id: 33,
},
{
city_label: 'Port Harcourt',
state_id: 33,
},
{
city_label: 'Tai',
state_id: 33,
},
{
city_label: 'Gudu',
state_id: 34,
},
{
city_label: 'Gwadabawa',
state_id: 34,
},
{
city_label: 'Illela',
state_id: 34,
},
{
city_label: 'Isa',
state_id: 34,
},
{
city_label: 'Kebbe',
state_id: 34,
},
{
city_label: 'Kware',
state_id: 34,
},
{
city_label: 'Rabah',
state_id: 34,
},
{
city_label: 'Sabon Birni',
state_id: 34,
},
{
city_label: 'Shagari',
state_id: 34,
},
{
city_label: 'Silame',
state_id: 34,
},
{
city_label: 'Sokoto North',
state_id: 34,
},
{
city_label: 'Sokoto South',
state_id: 34,
},
{
city_label: 'Tambuwal',
state_id: 34,
},
{
city_label: 'Tangaza',
state_id: 34,
},
{
city_label: 'Tureta',
state_id: 34,
},
{
city_label: 'Wamako',
state_id: 34,
},
{
city_label: 'Wurno',
state_id: 34,
},
{
city_label: 'Yabo',
state_id: 34,
},
{
city_label: 'Binji',
state_id: 34,
},
{
city_label: 'Bodinga',
state_id: 34,
},
{
city_label: 'Dange Shuni',
state_id: 34,
},
{
city_label: 'Goronyo',
state_id: 34,
},
{
city_label: 'Gada',
state_id: 34,
},
{
city_label: 'Ardo Kola',
state_id: 35,
},
{
city_label: 'Bali',
state_id: 35,
},
{
city_label: 'Donga',
state_id: 35,
},
{
city_label: 'Gashaka',
state_id: 35,
},
{
city_label: 'Gassol',
state_id: 35,
},
{
city_label: 'Ibi',
state_id: 35,
},
{
city_label: 'Jalingo',
state_id: 35,
},
{
city_label: 'Karim Lamido',
state_id: 35,
},
{
city_label: 'Kumi',
state_id: 35,
},
{
city_label: 'Lau',
state_id: 35,
},
{
city_label: 'Sardauna',
state_id: 35,
},
{
city_label: 'Takum',
state_id: 35,
},
{
city_label: 'Ussa',
state_id: 35,
},
{
city_label: 'Wukari',
state_id: 35,
},
{
city_label: 'Yorro',
state_id: 35,
},
{
city_label: 'Zing',
state_id: 35,
},
{
city_label: 'Bade',
state_id: 36,
},
{
city_label: 'Bursari',
state_id: 36,
},
{
city_label: 'Damaturu',
state_id: 36,
},
{
city_label: 'fika',
state_id: 36,
},
{
city_label: 'Fune',
state_id: 36,
},
{
city_label: 'Geidam',
state_id: 36,
},
{
city_label: 'Gujba',
state_id: 36,
},
{
city_label: 'Gulani',
state_id: 36,
},
{
city_label: 'Jakusko',
state_id: 36,
},
{
city_label: 'Karasuwa',
state_id: 36,
},
{
city_label: 'Machina',
state_id: 36,
},
{
city_label: 'Nangere',
state_id: 36,
},
{
city_label: 'Nguru',
state_id: 36,
},
{
city_label: 'Potiskum',
state_id: 36,
},
{
city_label: 'Tarmuwa',
state_id: 36,
},
{
city_label: 'Yunusari',
state_id: 36,
},
{
city_label: 'Anka',
state_id: 37,
},
{
city_label: 'Birnin Magaji/Kiyaw',
state_id: 37,
},
{
city_label: 'Bakura',
state_id: 37,
},
{
city_label: 'Bukkuyum',
state_id: 37,
},
{
city_label: 'Bungudu',
state_id: 37,
},
{
city_label: 'Gummi',
state_id: 37,
},
{
city_label: 'Gusau',
state_id: 37,
},
{
city_label: 'Kaura Namoda',
state_id: 37,
},
{
city_label: 'Maradun',
state_id: 37,
},
{
city_label: 'Shinkafi',
state_id: 37,
},
{
city_label: 'Maru',
state_id: 37,
},
{
city_label: 'Talata Mafara',
state_id: 37,
},
{
city_label: 'Tsafe',
state_id: 37,
},
{
city_label: 'Zurmi',
state_id: 37,
},
]
Database.raw('SET FOREIGN_KEY_CHECKS = 0;')
await SettingsCity.truncate()
await SettingsCity.createMany(citiesData)
Database.raw('SET FOREIGN_KEY_CHECKS = 1;')
}
}
Raw
SettingsCountrySeeder.ts
import BaseSeeder from '@ioc:Adonis/Lucid/Seeder'
import Database from '@ioc:Adonis/Lucid/Database'
import SettingsCountry from 'App/Models/SettingsCountry'
export default class SettingsCountrySeeder extends BaseSeeder {
public async run() {
const countriesData = [
{
// id: 1,
country_label: 'Nigeria',
iso2_code: 'NG',
iso3_code: 'NGA',
country_code: '234',
currency: 'Naira',
is_cheery_supported: true,
},
{
country_label: 'Afghanistan',
iso2_code: 'AF',
iso3_code: 'AFG',
country_code: '93',
currency: 'Afghani',
},
{
country_label: 'Albania',
iso2_code: 'AL',
iso3_code: 'ALB',
country_code: '355',
currency: 'Lek',
},
{
country_label: 'Algeria',
iso2_code: 'DZ',
iso3_code: 'DZA',
country_code: '213',
currency: 'Dinar',
},
{
country_label: 'American Samoa',
iso2_code: 'AS',
iso3_code: 'ASM',
country_code: '1-684',
currency: 'Dollar',
},
{
country_label: 'Andorra',
iso2_code: 'AD',
iso3_code: 'AND',
country_code: '376',
currency: 'Euro',
},
{
country_label: 'Angola',
iso2_code: 'AO',
iso3_code: 'AGO',
country_code: '244',
currency: 'Kwanza',
},
{
country_label: 'Anguilla',
iso2_code: 'AI',
iso3_code: 'AIA',
country_code: '1-264',
currency: 'Dollar',
},
{
country_label: 'Antarctica',
iso2_code: 'AQ',
iso3_code: 'ATA',
country_code: '672',
currency: 'Antarctic Dollar',
},
{
country_label: 'Antigua and Barbuda',
iso2_code: 'AG',
iso3_code: 'ATG',
country_code: '1-268',
currency: 'Dollar',
},
{
country_label: 'Argentina',
iso2_code: 'AR',
iso3_code: 'ARG',
country_code: '54',
currency: 'Peso',
},
{
country_label: 'Armenia',
iso2_code: 'AM',
iso3_code: 'ARM',
country_code: '374',
currency: 'Dram',
},
{
country_label: 'Aruba',
iso2_code: 'AW',
iso3_code: 'ABW',
country_code: '297',
currency: 'Guilder',
},
{
country_label: 'Australia',
iso2_code: 'AU',
iso3_code: 'AUS',
country_code: '61',
currency: 'Dollar',
},
{
country_label: 'Austria',
iso2_code: 'AT',
iso3_code: 'AUT',
country_code: '43',
currency: 'Euro',
},
{
country_label: 'Azerbaijan',
iso2_code: 'AZ',
iso3_code: 'AZE',
country_code: '994',
currency: 'Manat',
},
{
country_label: 'Bahamas',
iso2_code: 'BS',
iso3_code: 'BHS',
country_code: '1-242',
currency: 'Dollar',
},
{
country_label: 'Bahrain',
iso2_code: 'BH',
iso3_code: 'BHR',
country_code: '973',
currency: 'Dinar',
},
{
country_label: 'Bangladesh',
iso2_code: 'BD',
iso3_code: 'BGD',
country_code: '880',
currency: 'Taka',
},
{
country_label: 'Barbados',
iso2_code: 'BB',
iso3_code: 'BRB',
country_code: '1-246',
currency: 'Dollar',
},
{
country_label: 'Belarus',
iso2_code: 'BY',
iso3_code: 'BLR',
country_code: '375',
currency: 'Ruble',
},
{
country_label: 'Belgium',
iso2_code: 'BE',
iso3_code: 'BEL',
country_code: '32',
currency: 'Euro',
},
{
country_label: 'Belize',
iso2_code: 'BZ',
iso3_code: 'BLZ',
country_code: '501',
currency: 'Dollar',
},
{
country_label: 'Benin',
iso2_code: 'BJ',
iso3_code: 'BEN',
country_code: '229',
currency: 'Franc',
},
{
country_label: 'Bermuda',
iso2_code: 'BM',
iso3_code: 'BMU',
country_code: '1-441',
currency: 'Dollar',
},
{
country_label: 'Bhutan',
iso2_code: 'BT',
iso3_code: 'BTN',
country_code: '975',
currency: 'Ngultrum',
},
{
country_label: 'Bolivia',
iso2_code: 'BO',
iso3_code: 'BOL',
country_code: '591',
currency: 'Boliviano',
},
{
country_label: 'Bosnia and Herzegovina',
iso2_code: 'BA',
iso3_code: 'BIH',
country_code: '387',
currency: 'Marka',
},
{
country_label: 'Botswana',
iso2_code: 'BW',
iso3_code: 'BWA',
country_code: '267',
currency: 'Pula',
},
{
country_label: 'Brazil',
iso2_code: 'BR',
iso3_code: 'BRA',
country_code: '55',
currency: 'Real',
},
{
country_label: 'British Indian Ocean Territory',
iso2_code: 'IO',
iso3_code: 'IOT',
country_code: '246',
currency: 'Dollar',
},
{
country_label: 'British Virgin Islands',
iso2_code: 'VG',
iso3_code: 'VGB',
country_code: '1-284',
currency: 'Dollar',
},
{
country_label: 'Brunei',
iso2_code: 'BN',
iso3_code: 'BRN',
country_code: '673',
currency: 'Dollar',
},
{
country_label: 'Bulgaria',
iso2_code: 'BG',
iso3_code: 'BGR',
country_code: '359',
currency: 'Lev',
},
{
country_label: 'Burkina Faso',
iso2_code: 'BF',
iso3_code: 'BFA',
country_code: '226',
currency: 'Franc',
},
{
country_label: 'Burundi',
iso2_code: 'BI',
iso3_code: 'BDI',
country_code: '257',
currency: 'Franc',
},
{
country_label: 'Cambodia',
iso2_code: 'KH',
iso3_code: 'KHM',
country_code: '855',
currency: 'Riels',
},
{
country_label: 'Cameroon',
iso2_code: 'CM',
iso3_code: 'CMR',
country_code: '237',
currency: 'Franc',
},
{
country_label: 'Canada',
iso2_code: 'CA',
iso3_code: 'CAN',
country_code: '1',
currency: 'Dollar',
},
{
country_label: 'Cape Verde',
iso2_code: 'CV',
iso3_code: 'CPV',
country_code: '238',
currency: 'Escudo',
},
{
country_label: 'Cayman Islands',
iso2_code: 'KY',
iso3_code: 'CYM',
country_code: '1-345',
currency: 'Dollar',
},
{
country_label: 'Central African Republic',
iso2_code: 'CF',
iso3_code: 'CAF',
country_code: '236',
currency: 'Franc',
},
{
country_label: 'Chad',
iso2_code: 'TD',
iso3_code: 'TCD',
country_code: '235',
currency: 'Franc',
},
{
country_label: 'Chile',
iso2_code: 'CL',
iso3_code: 'CHL',
country_code: '56',
currency: 'Peso',
},
{
country_label: 'China',
iso2_code: 'CN',
iso3_code: 'CHN',
country_code: '86',
currency: 'Yuan Renminbi',
},
{
country_label: 'Christmas Island',
iso2_code: 'CX',
iso3_code: 'CXR',
country_code: '61',
currency: 'Dollar',
},
{
country_label: 'Cocos Islands',
iso2_code: 'CC',
iso3_code: 'CCK',
country_code: '61',
currency: 'Dollar',
},
{
country_label: 'Colombia',
iso2_code: 'CO',
iso3_code: 'COL',
country_code: '57',
currency: 'Peso',
},
{
country_label: 'Comoros',
iso2_code: 'KM',
iso3_code: 'COM',
country_code: '269',
currency: 'Franc',
},
{
country_label: 'Cook Islands',
iso2_code: 'CK',
iso3_code: 'COK',
country_code: '682',
currency: 'Dollar',
},
{
country_label: 'Costa Rica',
iso2_code: 'CR',
iso3_code: 'CRI',
country_code: '506',
currency: 'Colon',
},
{
country_label: 'Croatia',
iso2_code: 'HR',
iso3_code: 'HRV',
country_code: '385',
currency: 'Kuna',
},
{
country_label: 'Cuba',
iso2_code: 'CU',
iso3_code: 'CUB',
country_code: '53',
currency: 'Peso',
},
{
country_label: 'Curacao',
iso2_code: 'CW',
iso3_code: 'CUW',
country_code: '599',
currency: 'Guilder',
},
{
country_label: 'Cyprus',
iso2_code: 'CY',
iso3_code: 'CYP',
country_code: '357',
currency: 'Euro',
},
{
country_label: 'Czech Republic',
iso2_code: 'CZ',
iso3_code: 'CZE',
country_code: '420',
currency: 'Koruna',
},
{
country_label: 'Democratic Republic of the Congo',
iso2_code: 'CD',
iso3_code: 'COD',
country_code: '243',
currency: 'Franc',
},
{
country_label: 'Denmark',
iso2_code: 'DK',
iso3_code: 'DNK',
country_code: '45',
currency: 'Krone',
},
{
country_label: 'Djibouti',
iso2_code: 'DJ',
iso3_code: 'DJI',
country_code: '253',
currency: 'Franc',
},
{
country_label: 'Dominica',
iso2_code: 'DM',
iso3_code: 'DMA',
country_code: '1-767',
currency: 'Dollar',
},
{
country_label: 'Dominican Republic',
iso2_code: 'DO',
iso3_code: 'DOM',
country_code: '1-809, 1-829, 1-849',
currency: 'Peso',
},
{
country_label: 'East Timor',
iso2_code: 'TL',
iso3_code: 'TLS',
country_code: '670',
currency: 'Dollar',
},
{
country_label: 'Ecuador',
iso2_code: 'EC',
iso3_code: 'ECU',
country_code: '593',
currency: 'Dollar',
},
{
country_label: 'Egypt',
iso2_code: 'EG',
iso3_code: 'EGY',
country_code: '20',
currency: 'Pound',
},
{
country_label: 'El Salvador',
iso2_code: 'SV',
iso3_code: 'SLV',
country_code: '503',
currency: 'Dollar',
},
{
country_label: 'Equatorial Guinea',
iso2_code: 'GQ',
iso3_code: 'GNQ',
country_code: '240',
currency: 'Franc',
},
{
country_label: 'Eritrea',
iso2_code: 'ER',
iso3_code: 'ERI',
country_code: '291',
currency: 'Nakfa',
},
{
country_label: 'Estonia',
iso2_code: 'EE',
iso3_code: 'EST',
country_code: '372',
currency: 'Euro',
},
{
country_label: 'Ethiopia',
iso2_code: 'ET',
iso3_code: 'ETH',
country_code: '251',
currency: 'Birr',
},
{
country_label: 'Falkland Islands',
iso2_code: 'FK',
iso3_code: 'FLK',
country_code: '500',
currency: 'Pound',
},
{
country_label: 'Faroe Islands',
iso2_code: 'FO',
iso3_code: 'FRO',
country_code: '298',
currency: 'Krone',
},
{
country_label: 'Fiji',
iso2_code: 'FJ',
iso3_code: 'FJI',
country_code: '679',
currency: 'Dollar',
},
{
country_label: 'Finland',
iso2_code: 'FI',
iso3_code: 'FIN',
country_code: '358',
currency: 'Euro',
},
{
country_label: 'France',
iso2_code: 'FR',
iso3_code: 'FRA',
country_code: '33',
currency: 'Euro',
},
{
country_label: 'French Polynesia',
iso2_code: 'PF',
iso3_code: 'PYF',
country_code: '689',
currency: 'Franc',
},
{
country_label: 'Gabon',
iso2_code: 'GA',
iso3_code: 'GAB',
country_code: '241',
currency: 'Franc',
},
{
country_label: 'Gambia',
iso2_code: 'GM',
iso3_code: 'GMB',
country_code: '220',
currency: 'Dalasi',
},
{
country_label: 'Georgia',
iso2_code: 'GE',
iso3_code: 'GEO',
country_code: '995',
currency: 'Lari',
},
{
country_label: 'Germany',
iso2_code: 'DE',
iso3_code: 'DEU',
country_code: '49',
currency: 'Euro',
},
{
country_label: 'Ghana',
iso2_code: 'GH',
iso3_code: 'GHA',
country_code: '233',
currency: 'Cedi',
},
{
country_label: 'Gibraltar',
iso2_code: 'GI',
iso3_code: 'GIB',
country_code: '350',
currency: 'Pound',
},
{
country_label: 'Greece',
iso2_code: 'GR',
iso3_code: 'GRC',
country_code: '30',
currency: 'Euro',
},
{
country_label: 'Greenland',
iso2_code: 'GL',
iso3_code: 'GRL',
country_code: '299',
currency: 'Krone',
},
{
country_label: 'Grenada',
iso2_code: 'GD',
iso3_code: 'GRD',
country_code: '1-473',
currency: 'Dollar',
},
{
country_label: 'Guam',
iso2_code: 'GU',
iso3_code: 'GUM',
country_code: '1-671',
currency: 'Dollar',
},
{
country_label: 'Guatemala',
iso2_code: 'GT',
iso3_code: 'GTM',
country_code: '502',
currency: 'Quetzal',
},
{
country_label: 'Guernsey',
iso2_code: 'GG',
iso3_code: 'GGY',
country_code: '44-1481',
currency: 'Pound',
},
{
country_label: 'Guinea',
iso2_code: 'GN',
iso3_code: 'GIN',
country_code: '224',
currency: 'Franc',
},
{
country_label: 'Guinea-Bissau',
iso2_code: 'GW',
iso3_code: 'GNB',
country_code: '245',
currency: 'Franc',
},
{
country_label: 'Guyana',
iso2_code: 'GY',
iso3_code: 'GUY',
country_code: '592',
currency: 'Dollar',
},
{
country_label: 'Haiti',
iso2_code: 'HT',
iso3_code: 'HTI',
country_code: '509',
currency: 'Gourde',
},
{
country_label: 'Honduras',
iso2_code: 'HN',
iso3_code: 'HND',
country_code: '504',
currency: 'Lempira',
},
{
country_label: 'Hong Kong',
iso2_code: 'HK',
iso3_code: 'HKG',
country_code: '852',
currency: 'Dollar',
},
{
country_label: 'Hungary',
iso2_code: 'HU',
iso3_code: 'HUN',
country_code: '36',
currency: 'Forint',
},
{
country_label: 'Iceland',
iso2_code: 'IS',
iso3_code: 'ISL',
country_code: '354',
currency: 'Krona',
},
{
country_label: 'India',
iso2_code: 'IN',
iso3_code: 'IND',
country_code: '91',
currency: 'Rupee',
},
{
country_label: 'Indonesia',
iso2_code: 'ID',
iso3_code: 'IDN',
country_code: '62',
currency: 'Rupiah',
},
{
country_label: 'Iran',
iso2_code: 'IR',
iso3_code: 'IRN',
country_code: '98',
currency: 'Rial',
},
{
country_label: 'Iraq',
iso2_code: 'IQ',
iso3_code: 'IRQ',
country_code: '964',
currency: 'Dinar',
},
{
country_label: 'Ireland',
iso2_code: 'IE',
iso3_code: 'IRL',
country_code: '353',
currency: 'Euro',
},
{
country_label: 'Isle of Man',
iso2_code: 'IM',
iso3_code: 'IMN',
country_code: '44-1624',
currency: 'Pound',
},
{
country_label: 'Israel',
iso2_code: 'IL',
iso3_code: 'ISR',
country_code: '972',
currency: 'Shekel',
},
{
country_label: 'Italy',
iso2_code: 'IT',
iso3_code: 'ITA',
country_code: '39',
currency: 'Euro',
},
{
country_label: 'Ivory Coast',
iso2_code: 'CI',
iso3_code: 'CIV',
country_code: '225',
currency: 'Franc',
},
{
country_label: 'Jamaica',
iso2_code: 'JM',
iso3_code: 'JAM',
country_code: '1-876',
currency: 'Dollar',
},
{
country_label: 'Japan',
iso2_code: 'JP',
iso3_code: 'JPN',
country_code: '81',
currency: 'Yen',
},
{
country_label: 'Jersey',
iso2_code: 'JE',
iso3_code: 'JEY',
country_code: '44-1534',
currency: 'Pound',
},
{
country_label: 'Jordan',
iso2_code: 'JO',
iso3_code: 'JOR',
country_code: '962',
currency: 'Dinar',
},
{
country_label: 'Kazakhstan',
iso2_code: 'KZ',
iso3_code: 'KAZ',
country_code: '7',
currency: 'Tenge',
},
{
country_label: 'Kenya',
iso2_code: 'KE',
iso3_code: 'KEN',
country_code: '254',
currency: 'Shilling',
},
{
country_label: 'Kiribati',
iso2_code: 'KI',
iso3_code: 'KIR',
country_code: '686',
currency: 'Dollar',
},
{
country_label: 'Kosovo',
iso2_code: 'XK',
iso3_code: 'XKX',
country_code: '383',
currency: 'Euro',
},
{
country_label: 'Kuwait',
iso2_code: 'KW',
iso3_code: 'KWT',
country_code: '965',
currency: 'Dinar',
},
{
country_label: 'Kyrgyzstan',
iso2_code: 'KG',
iso3_code: 'KGZ',
country_code: '996',
currency: 'Som',
},
{
country_label: 'Laos',
iso2_code: 'LA',
iso3_code: 'LAO',
country_code: '856',
currency: 'Kip',
},
{
country_label: 'Latvia',
iso2_code: 'LV',
iso3_code: 'LVA',
country_code: '371',
currency: 'Euro',
},
{
country_label: 'Lebanon',
iso2_code: 'LB',
iso3_code: 'LBN',
country_code: '961',
currency: 'Pound',
},
{
country_label: 'Lesotho',
iso2_code: 'LS',
iso3_code: 'LSO',
country_code: '266',
currency: 'Loti',
},
{
country_label: 'Liberia',
iso2_code: 'LR',
iso3_code: 'LBR',
country_code: '231',
currency: 'Dollar',
},
{
country_label: 'Libya',
iso2_code: 'LY',
iso3_code: 'LBY',
country_code: '218',
currency: 'Dinar',
},
{
country_label: 'Liechtenstein',
iso2_code: 'LI',
iso3_code: 'LIE',
country_code: '423',
currency: 'Franc',
},
{
country_label: 'Lithuania',
iso2_code: 'LT',
iso3_code: 'LTU',
country_code: '370',
currency: 'Euro',
},
{
country_label: 'Luxembourg',
iso2_code: 'LU',
iso3_code: 'LUX',
country_code: '352',
currency: 'Euro',
},
{
country_label: 'Macau',
iso2_code: 'MO',
iso3_code: 'MAC',
country_code: '853',
currency: 'Pataca',
},
{
country_label: 'Macedonia',
iso2_code: 'MK',
iso3_code: 'MKD',
country_code: '389',
currency: 'Denar',
},
{
country_label: 'Madagascar',
iso2_code: 'MG',
iso3_code: 'MDG',
country_code: '261',
currency: 'Ariary',
},
{
country_label: 'Malawi',
iso2_code: 'MW',
iso3_code: 'MWI',
country_code: '265',
currency: 'Kwacha',
},
{
country_label: 'Malaysia',
iso2_code: 'MY',
iso3_code: 'MYS',
country_code: '60',
currency: 'Ringgit',
},
{
country_label: 'Maldives',
iso2_code: 'MV',
iso3_code: 'MDV',
country_code: '960',
currency: 'Rufiyaa',
},
{
country_label: 'Mali',
iso2_code: 'ML',
iso3_code: 'MLI',
country_code: '223',
currency: 'Franc',
},
{
country_label: 'Malta',
iso2_code: 'MT',
iso3_code: 'MLT',
country_code: '356',
currency: 'Euro',
},
{
country_label: 'Marshall Islands',
iso2_code: 'MH',
iso3_code: 'MHL',
country_code: '692',
currency: 'Dollar',
},
{
country_label: 'Mauritania',
iso2_code: 'MR',
iso3_code: 'MRT',
country_code: '222',
currency: 'Ouguiya',
},
{
country_label: 'Mauritius',
iso2_code: 'MU',
iso3_code: 'MUS',
country_code: '230',
currency: 'Rupee',
},
{
country_label: 'Mayotte',
iso2_code: 'YT',
iso3_code: 'MYT',
country_code: '262',
currency: 'Euro',
},
{
country_label: 'Mexico',
iso2_code: 'MX',
iso3_code: 'MEX',
country_code: '52',
currency: 'Peso',
},
{
country_label: 'Micronesia',
iso2_code: 'FM',
iso3_code: 'FSM',
country_code: '691',
currency: 'Dollar',
},
{
country_label: 'Moldova',
iso2_code: 'MD',
iso3_code: 'MDA',
country_code: '373',
currency: 'Leu',
},
{
country_label: 'Monaco',
iso2_code: 'MC',
iso3_code: 'MCO',
country_code: '377',
currency: 'Euro',
},
{
country_label: 'Mongolia',
iso2_code: 'MN',
iso3_code: 'MNG',
country_code: '976',
currency: 'Tugrik',
},
{
country_label: 'Montenegro',
iso2_code: 'ME',
iso3_code: 'MNE',
country_code: '382',
currency: 'Euro',
},
{
country_label: 'Montserrat',
iso2_code: 'MS',
iso3_code: 'MSR',
country_code: '1-664',
currency: 'Dollar',
},
{
country_label: 'Morocco',
iso2_code: 'MA',
iso3_code: 'MAR',
country_code: '212',
currency: 'Dirham',
},
{
country_label: 'Mozambique',
iso2_code: 'MZ',
iso3_code: 'MOZ',
country_code: '258',
currency: 'Metical',
},
{
country_label: 'Myanmar',
iso2_code: 'MM',
iso3_code: 'MMR',
country_code: '95',
currency: 'Kyat',
},
{
country_label: 'Namibia',
iso2_code: 'NA',
iso3_code: 'NAM',
country_code: '264',
currency: 'Dollar',
},
{
country_label: 'Nauru',
iso2_code: 'NR',
iso3_code: 'NRU',
country_code: '674',
currency: 'Dollar',
},
{
country_label: 'Nepal',
iso2_code: 'NP',
iso3_code: 'NPL',
country_code: '977',
currency: 'Rupee',
},
{
country_label: 'Netherlands',
iso2_code: 'NL',
iso3_code: 'NLD',
country_code: '31',
currency: 'Euro',
},
{
country_label: 'Netherlands Antilles',
iso2_code: 'AN',
iso3_code: 'ANT',
country_code: '599',
currency: 'Guilder',
},
{
country_label: 'New Caledonia',
iso2_code: 'NC',
iso3_code: 'NCL',
country_code: '687',
currency: 'Franc',
},
{
country_label: 'New Zealand',
iso2_code: 'NZ',
iso3_code: 'NZL',
country_code: '64',
currency: 'Dollar',
},
{
country_label: 'Nicaragua',
iso2_code: 'NI',
iso3_code: 'NIC',
country_code: '505',
currency: 'Cordoba',
},
{
country_label: 'Niger',
iso2_code: 'NE',
iso3_code: 'NER',
country_code: '227',
currency: 'Franc',
},
{
country_label: 'Niue',
iso2_code: 'NU',
iso3_code: 'NIU',
country_code: '683',
currency: 'Dollar',
},
{
country_label: 'North Korea',
iso2_code: 'KP',
iso3_code: 'PRK',
country_code: '850',
currency: 'Won',
},
{
country_label: 'Northern Mariana Islands',
iso2_code: 'MP',
iso3_code: 'MNP',
country_code: '1-670',
currency: 'Dollar',
},
{
country_label: 'Norway',
iso2_code: 'NO',
iso3_code: 'NOR',
country_code: '47',
currency: 'Krone',
},
{
country_label: 'Oman',
iso2_code: 'OM',
iso3_code: 'OMN',
country_code: '968',
currency: 'Rial',
},
{
country_label: 'Pakistan',
iso2_code: 'PK',
iso3_code: 'PAK',
country_code: '92',
currency: 'Rupee',
},
{
country_label: 'Palau',
iso2_code: 'PW',
iso3_code: 'PLW',
country_code: '680',
currency: 'Dollar',
},
{
country_label: 'Palestine',
iso2_code: 'PS',
iso3_code: 'PSE',
country_code: '970',
currency: 'Shekel',
},
{
country_label: 'Panama',
iso2_code: 'PA',
iso3_code: 'PAN',
country_code: '507',
currency: 'Balboa',
},
{
country_label: 'Papua New Guinea',
iso2_code: 'PG',
iso3_code: 'PNG',
country_code: '675',
currency: 'Kina',
},
{
country_label: 'Paraguay',
iso2_code: 'PY',
iso3_code: 'PRY',
country_code: '595',
currency: 'Guarani',
},
{
country_label: 'Peru',
iso2_code: 'PE',
iso3_code: 'PER',
country_code: '51',
currency: 'Sol',
},
{
country_label: 'Philippines',
iso2_code: 'PH',
iso3_code: 'PHL',
country_code: '63',
currency: 'Peso',
},
{
country_label: 'Pitcairn',
iso2_code: 'PN',
iso3_code: 'PCN',
country_code: '64',
currency: 'Dollar',
},
{
country_label: 'Poland',
iso2_code: 'PL',
iso3_code: 'POL',
country_code: '48',
currency: 'Zloty',
},
{
country_label: 'Portugal',
iso2_code: 'PT',
iso3_code: 'PRT',
country_code: '351',
currency: 'Euro',
},
{
country_label: 'Puerto Rico',
iso2_code: 'PR',
iso3_code: 'PRI',
country_code: '1-787, 1-939',
currency: 'Dollar',
},
{
country_label: 'Qatar',
iso2_code: 'QA',
iso3_code: 'QAT',
country_code: '974',
currency: 'Rial',
},
{
country_label: 'Republic of the Congo',
iso2_code: 'CG',
iso3_code: 'COG',
country_code: '242',
currency: 'Franc',
},
{
country_label: 'Reunion',
iso2_code: 'RE',
iso3_code: 'REU',
country_code: '262',
currency: 'Euro',
},
{
country_label: 'Romania',
iso2_code: 'RO',
iso3_code: 'ROU',
country_code: '40',
currency: 'Leu',
},
{
country_label: 'Russia',
iso2_code: 'RU',
iso3_code: 'RUS',
country_code: '7',
currency: 'Ruble',
},
{
country_label: 'Rwanda',
iso2_code: 'RW',
iso3_code: 'RWA',
country_code: '250',
currency: 'Franc',
},
{
country_label: 'Saint Barthelemy',
iso2_code: 'BL',
iso3_code: 'BLM',
country_code: '590',
currency: 'Euro',
},
{
country_label: 'Saint Helena',
iso2_code: 'SH',
iso3_code: 'SHN',
country_code: '290',
currency: 'Pound',
},
{
country_label: 'Saint Kitts and Nevis',
iso2_code: 'KN',
iso3_code: 'KNA',
country_code: '1-869',
currency: 'Dollar',
},
{
country_label: 'Saint Lucia',
iso2_code: 'LC',
iso3_code: 'LCA',
country_code: '1-758',
currency: 'Dollar',
},
{
country_label: 'Saint Martin',
iso2_code: 'MF',
iso3_code: 'MAF',
country_code: '590',
currency: 'Euro',
},
{
country_label: 'Saint Pierre and Miquelon',
iso2_code: 'PM',
iso3_code: 'SPM',
country_code: '508',
currency: 'Euro',
},
{
country_label: 'Saint Vincent and the Grenadines',
iso2_code: 'VC',
iso3_code: 'VCT',
country_code: '1-784',
currency: 'Dollar',
},
{
country_label: 'Samoa',
iso2_code: 'WS',
iso3_code: 'WSM',
country_code: '685',
currency: 'Tala',
},
{
country_label: 'San Marino',
iso2_code: 'SM',
iso3_code: 'SMR',
country_code: '378',
currency: 'Euro',
},
{
country_label: 'Sao Tome and Principe',
iso2_code: 'ST',
iso3_code: 'STP',
country_code: '239',
currency: 'Dobra',
},
{
country_label: 'Saudi Arabia',
iso2_code: 'SA',
iso3_code: 'SAU',
country_code: '966',
currency: 'Rial',
},
{
country_label: 'Senegal',
iso2_code: 'SN',
iso3_code: 'SEN',
country_code: '221',
currency: 'Franc',
},
{
country_label: 'Serbia',
iso2_code: 'RS',
iso3_code: 'SRB',
country_code: '381',
currency: 'Dinar',
},
{
country_label: 'Seychelles',
iso2_code: 'SC',
iso3_code: 'SYC',
country_code: '248',
currency: 'Rupee',
},
{
country_label: 'Sierra Leone',
iso2_code: 'SL',
iso3_code: 'SLE',
country_code: '232',
currency: 'Leone',
},
{
country_label: 'Singapore',
iso2_code: 'SG',
iso3_code: 'SGP',
country_code: '65',
currency: 'Dollar',
},
{
country_label: 'Sint Maarten',
iso2_code: 'SX',
iso3_code: 'SXM',
country_code: '1-721',
currency: 'Guilder',
},
{
country_label: 'Slovakia',
iso2_code: 'SK',
iso3_code: 'SVK',
country_code: '421',
currency: 'Euro',
},
{
country_label: 'Slovenia',
iso2_code: 'SI',
iso3_code: 'SVN',
country_code: '386',
currency: 'Euro',
},
{
country_label: 'Solomon Islands',
iso2_code: 'SB',
iso3_code: 'SLB',
country_code: '677',
currency: 'Dollar',
},
{
country_label: 'Somalia',
iso2_code: 'SO',
iso3_code: 'SOM',
country_code: '252',
currency: 'Shilling',
},
{
country_label: 'South Africa',
iso2_code: 'ZA',
iso3_code: 'ZAF',
country_code: '27',
currency: 'Rand',
},
{
country_label: 'South Korea',
iso2_code: 'KR',
iso3_code: 'KOR',
country_code: '82',
currency: 'Won',
},
{
country_label: 'South Sudan',
iso2_code: 'SS',
iso3_code: 'SSD',
country_code: '211',
currency: 'Pound',
},
{
country_label: 'Spain',
iso2_code: 'ES',
iso3_code: 'ESP',
country_code: '34',
currency: 'Euro',
},
{
country_label: 'Sri Lanka',
iso2_code: 'LK',
iso3_code: 'LKA',
country_code: '94',
currency: 'Rupee',
},
{
country_label: 'Sudan',
iso2_code: 'SD',
iso3_code: 'SDN',
country_code: '249',
currency: 'Pound',
},
{
country_label: 'Suriname',
iso2_code: 'SR',
iso3_code: 'SUR',
country_code: '597',
currency: 'Dollar',
},
{
country_label: 'Svalbard and Jan Mayen',
iso2_code: 'SJ',
iso3_code: 'SJM',
country_code: '47',
currency: 'Krone',
},
{
country_label: 'Swaziland',
iso2_code: 'SZ',
iso3_code: 'SWZ',
country_code: '268',
currency: 'Lilangeni',
},
{
country_label: 'Sweden',
iso2_code: 'SE',
iso3_code: 'SWE',
country_code: '46',
currency: 'Krona',
},
{
country_label: 'Switzerland',
iso2_code: 'CH',
iso3_code: 'CHE',
country_code: '41',
currency: 'Franc',
},
{
country_label: 'Syria',
iso2_code: 'SY',
iso3_code: 'SYR',
country_code: '963',
currency: 'Pound',
},
{
country_label: 'Taiwan',
iso2_code: 'TW',
iso3_code: 'TWN',
country_code: '886',
currency: 'Dollar',
},
{
country_label: 'Tajikistan',
iso2_code: 'TJ',
iso3_code: 'TJK',
country_code: '992',
currency: 'Somoni',
},
{
country_label: 'Tanzania',
iso2_code: 'TZ',
iso3_code: 'TZA',
country_code: '255',
currency: 'Shilling',
},
{
country_label: 'Thailand',
iso2_code: 'TH',
iso3_code: 'THA',
country_code: '66',
currency: 'Baht',
},
{
country_label: 'Togo',
iso2_code: 'TG',
iso3_code: 'TGO',
country_code: '228',
currency: 'Franc',
},
{
country_label: 'Tokelau',
iso2_code: 'TK',
iso3_code: 'TKL',
country_code: '690',
currency: 'Dollar',
},
{
country_label: 'Tonga',
iso2_code: 'TO',
iso3_code: 'TON',
country_code: '676',
currency: 'Pa"anga',
},
{
country_label: 'Trinidad and Tobago',
iso2_code: 'TT',
iso3_code: 'TTO',
country_code: '1-868',
currency: 'Dollar',
},
{
country_label: 'Tunisia',
iso2_code: 'TN',
iso3_code: 'TUN',
country_code: '216',
currency: 'Dinar',
},
{
country_label: 'Turkey',
iso2_code: 'TR',
iso3_code: 'TUR',
country_code: '90',
currency: 'Lira',
},
{
country_label: 'Turkmenistan',
iso2_code: 'TM',
iso3_code: 'TKM',
country_code: '993',
currency: 'Manat',
},
{
country_label: 'Turks and Caicos Islands',
iso2_code: 'TC',
iso3_code: 'TCA',
country_code: '1-649',
currency: 'Dollar',
},
{
country_label: 'Tuvalu',
iso2_code: 'TV',
iso3_code: 'TUV',
country_code: '688',
currency: 'Dollar',
},
{
country_label: 'U.S. Virgin Islands',
iso2_code: 'VI',
iso3_code: 'VIR',
country_code: '1-340',
currency: 'Dollar',
},
{
country_label: 'Uganda',
iso2_code: 'UG',
iso3_code: 'UGA',
country_code: '256',
currency: 'Shilling',
},
{
country_label: 'Ukraine',
iso2_code: 'UA',
iso3_code: 'UKR',
country_code: '380',
currency: 'Hryvnia',
},
{
country_label: 'United Arab Emirates',
iso2_code: 'AE',
iso3_code: 'ARE',
country_code: '971',
currency: 'Dirham',
},
{
country_label: 'United Kingdom',
iso2_code: 'GB',
iso3_code: 'GBR',
country_code: '44',
currency: 'Pound',
},
{
country_label: 'United States',
iso2_code: 'US',
iso3_code: 'USA',
country_code: '1',
currency: 'Dollar',
},
{
country_label: 'Uruguay',
iso2_code: 'UY',
iso3_code: 'URY',
country_code: '598',
currency: 'Peso',
},
{
country_label: 'Uzbekistan',
iso2_code: 'UZ',
iso3_code: 'UZB',
country_code: '998',
currency: 'Som',
},
{
country_label: 'Vanuatu',
iso2_code: 'VU',
iso3_code: 'VUT',
country_code: '678',
currency: 'Vatu',
},
{
country_label: 'Vatican',
iso2_code: 'VA',
iso3_code: 'VAT',
country_code: '379',
currency: 'Euro',
},
{
country_label: 'Venezuela',
iso2_code: 'VE',
iso3_code: 'VEN',
country_code: '58',
currency: 'Bolivar',
},
{
country_label: 'Vietnam',
iso2_code: 'VN',
iso3_code: 'VNM',
country_code: '84',
currency: 'Dong',
},
{
country_label: 'Wallis and Futuna',
iso2_code: 'WF',
iso3_code: 'WLF',
country_code: '681',
currency: 'Franc',
},
{
country_label: 'Western Sahara',
iso2_code: 'EH',
iso3_code: 'ESH',
country_code: '212',
currency: 'Dirham',
},
{
country_label: 'Yemen',
iso2_code: 'YE',
iso3_code: 'YEM',
country_code: '967',
currency: 'Rial',
},
{
country_label: 'Zambia',
iso2_code: 'ZM',
iso3_code: 'ZMB',
country_code: '260',
currency: 'Kwacha',
},
{
country_label: 'Zimbabwe',
iso2_code: 'ZW',
iso3_code: 'ZWE',
country_code: '263',
currency: 'Dollar',
},
]
Database.raw('SET FOREIGN_KEY_CHECKS = 0;')
await SettingsCountry.truncate(true)
await SettingsCountry.createMany(countriesData)
Database.raw('SET FOREIGN_KEY_CHECKS = 1;')
}
}
Raw
SettingsStatesSeeder.ts
import BaseSeeder from '@ioc:Adonis/Lucid/Seeder'
import Database from '@ioc:Adonis/Lucid/Database'
import SettingsState from 'App/Models/SettingsState'
export default class SettingsStatesSeeder extends BaseSeeder {
public async run() {
const statesData = [
{
country_id: 1,
state_label: 'Abia',
},
{
country_id: 1,
state_label: 'Adamawa',
},
{
country_id: 1,
state_label: 'Akwa Ibom',
},
{
country_id: 1,
state_label: 'Anambra',
},
{
country_id: 1,
state_label: 'Bauchi',
},
{
country_id: 1,
state_label: 'Bayelsa',
},
{
country_id: 1,
state_label: 'Benue',
},
{
country_id: 1,
state_label: 'Borno',
},
{
country_id: 1,
state_label: 'Cross Rivers',
},
{
country_id: 1,
state_label: 'Delta',
},
{
country_id: 1,
state_label: 'Ebonyi',
},
{
country_id: 1,
state_label: 'Edo',
},
{
country_id: 1,
state_label: 'Ekiti',
},
{
country_id: 1,
state_label: 'Enugu',
},
{
country_id: 1,
state_label: 'Federal Capital Territory',
},
{
country_id: 1,
state_label: 'Gombe',
},
{
country_id: 1,
state_label: 'Imo',
},
{
country_id: 1,
state_label: 'Jigawa',
},
{
country_id: 1,
state_label: 'Kaduna',
},
{
country_id: 1,
state_label: 'Kano',
},
{
country_id: 1,
state_label: 'Katsina',
},
{
country_id: 1,
state_label: 'Kebbi',
},
{
country_id: 1,
state_label: 'Kogi',
},
{
country_id: 1,
state_label: 'Kwara',
},
{
country_id: 1,
state_label: 'Lagos',
},
{
country_id: 1,
state_label: 'Nasarawa',
},
{
country_id: 1,
state_label: 'Niger',
},
{
country_id: 1,
state_label: 'Ogun',
},
{
country_id: 1,
state_label: 'Ondo',
},
{
country_id: 1,
state_label: 'Osun',
},
{
country_id: 1,
state_label: 'Oyo',
},
{
country_id: 1,
state_label: 'Plateau',
},
{
country_id: 1,
state_label: 'Rivers',
},
{
country_id: 1,
state_label: 'Sokoto',
},
{
country_id: 1,
state_label: 'Taraba',
},
{
country_id: 1,
state_label: 'Yobe',
},
{
country_id: 1,
state_label: 'Zamfara',
},
]
Database.raw('SET FOREIGN_KEY_CHECKS = 0;')
await SettingsState.truncate(true)
await SettingsState.createMany(statesData)
Database.raw('SET FOREIGN_KEY_CHECKS = 1;')
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment