Bulgarian Regions & Cities (PostgreSQL)

bulgarian.regions.and.cities.sql

-- Regions
CREATE TABLE regions(
    region_id SERIAL PRIMARY KEY,
    name      character varying(255)
);

-- Cities
CREATE TABLE cities (
    city_id   SERIAL PRIMARY KEY,
    region_id integer,
    name      character varying(255),
    CONSTRAINT cities_region_id_fk FOREIGN KEY(region_id) REFERENCES regions(region_id) ON DELETE RESTRICT
);

INSERT INTO regions(name) VALUES('Благоевград');
INSERT INTO cities(region_id,name) VALUES(1,'Банско');
INSERT INTO cities(region_id,name) VALUES(1,'Белица');
INSERT INTO cities(region_id,name) VALUES(1,'Благоевград');
INSERT INTO cities(region_id,name) VALUES(1,'Гоце Делчев');
INSERT INTO cities(region_id,name) VALUES(1,'Добринище');
INSERT INTO cities(region_id,name) VALUES(1,'Кресна');
INSERT INTO cities(region_id,name) VALUES(1,'Мелник');
INSERT INTO cities(region_id,name) VALUES(1,'Петрич');
INSERT INTO cities(region_id,name) VALUES(1,'Разлог');
INSERT INTO cities(region_id,name) VALUES(1,'Сандански');
INSERT INTO cities(region_id,name) VALUES(1,'Симитли');
INSERT INTO cities(region_id,name) VALUES(1,'Хаджидимово');
INSERT INTO cities(region_id,name) VALUES(1,'Якоруда');

INSERT INTO regions(name) VALUES('Бургас');
INSERT INTO cities(region_id,name) VALUES(2,'Айтос');
INSERT INTO cities(region_id,name) VALUES(2,'Ахтопол');
INSERT INTO cities(region_id,name) VALUES(2,'Бургас');
INSERT INTO cities(region_id,name) VALUES(2,'Долни чифлик');
INSERT INTO cities(region_id,name) VALUES(2,'Каблешково');
INSERT INTO cities(region_id,name) VALUES(2,'Камено');
INSERT INTO cities(region_id,name) VALUES(2,'Карнобат');
INSERT INTO cities(region_id,name) VALUES(2,'Китен');
INSERT INTO cities(region_id,name) VALUES(2,'Малко Търново');
INSERT INTO cities(region_id,name) VALUES(2,'Несебър');
INSERT INTO cities(region_id,name) VALUES(2,'Обзор');
INSERT INTO cities(region_id,name) VALUES(2,'Поморие');
INSERT INTO cities(region_id,name) VALUES(2,'Приморско');
INSERT INTO cities(region_id,name) VALUES(2,'Свети Влас');
INSERT INTO cities(region_id,name) VALUES(2,'Созопол');
INSERT INTO cities(region_id,name) VALUES(2,'Средец');
INSERT INTO cities(region_id,name) VALUES(2,'Сунгурларе');
INSERT INTO cities(region_id,name) VALUES(2,'Царево');
INSERT INTO cities(region_id,name) VALUES(2,'Ахелой');

INSERT INTO regions(name) VALUES('Варна');
INSERT INTO cities(region_id,name) VALUES(3,'Аксаково');
INSERT INTO cities(region_id,name) VALUES(3,'Белослав');
INSERT INTO cities(region_id,name) VALUES(3,'Бяла');
INSERT INTO cities(region_id,name) VALUES(3,'Варна');
INSERT INTO cities(region_id,name) VALUES(3,'Вълчидол');
INSERT INTO cities(region_id,name) VALUES(3,'Девня');
INSERT INTO cities(region_id,name) VALUES(3,'Дългопол');
INSERT INTO cities(region_id,name) VALUES(3,'Провадия');
INSERT INTO cities(region_id,name) VALUES(3,'Суворово');
INSERT INTO cities(region_id,name) VALUES(3,'Игнатиево');

INSERT INTO regions(name) VALUES('Велико Търново');
INSERT INTO cities(region_id,name) VALUES(4,'Бяла черква');
INSERT INTO cities(region_id,name) VALUES(4,'Велико Търново');
INSERT INTO cities(region_id,name) VALUES(4,'Горна Оряховица');
INSERT INTO cities(region_id,name) VALUES(4,'Дебелец');
INSERT INTO cities(region_id,name) VALUES(4,'Долна Оряховица');
INSERT INTO cities(region_id,name) VALUES(4,'Елена');
INSERT INTO cities(region_id,name) VALUES(4,'Златарица');
INSERT INTO cities(region_id,name) VALUES(4,'Килифарево');
INSERT INTO cities(region_id,name) VALUES(4,'Лясковец');
INSERT INTO cities(region_id,name) VALUES(4,'Павликени');
INSERT INTO cities(region_id,name) VALUES(4,'Полски Тръмбеш');
INSERT INTO cities(region_id,name) VALUES(4,'Свищов');
INSERT INTO cities(region_id,name) VALUES(4,'Стражица');
INSERT INTO cities(region_id,name) VALUES(4,'Сухиндол');

INSERT INTO regions(name) VALUES('Видин');
INSERT INTO cities(region_id,name) VALUES(5,'Белоградчик');
INSERT INTO cities(region_id,name) VALUES(5,'Брегово');
INSERT INTO cities(region_id,name) VALUES(5,'Видин');
INSERT INTO cities(region_id,name) VALUES(5,'Грамада');
INSERT INTO cities(region_id,name) VALUES(5,'Димово');
INSERT INTO cities(region_id,name) VALUES(5,'Дунавци');
INSERT INTO cities(region_id,name) VALUES(5,'Кула');

INSERT INTO regions(name) VALUES('Враца');
INSERT INTO cities(region_id,name) VALUES(6,'Бяла Слатина');
INSERT INTO cities(region_id,name) VALUES(6,'Враца');
INSERT INTO cities(region_id,name) VALUES(6,'Козлодуй');
INSERT INTO cities(region_id,name) VALUES(6,'Криводол');
INSERT INTO cities(region_id,name) VALUES(6,'Мездра');
INSERT INTO cities(region_id,name) VALUES(6,'Мизия');
INSERT INTO cities(region_id,name) VALUES(6,'Оряхово');
INSERT INTO cities(region_id,name) VALUES(6,'Роман');

INSERT INTO regions(name) VALUES('Габрово');
INSERT INTO cities(region_id,name) VALUES(7,'Габрово');
INSERT INTO cities(region_id,name) VALUES(7,'Дряново');
INSERT INTO cities(region_id,name) VALUES(7,'Плачковци');
INSERT INTO cities(region_id,name) VALUES(7,'Севлиево');
INSERT INTO cities(region_id,name) VALUES(7,'Трявна');

INSERT INTO regions(name) VALUES('Добрич');
INSERT INTO cities(region_id,name) VALUES(8,'Балчик');
INSERT INTO cities(region_id,name) VALUES(8,'Генерал Тошево');
INSERT INTO cities(region_id,name) VALUES(8,'Добрич');
INSERT INTO cities(region_id,name) VALUES(8,'Каварна');
INSERT INTO cities(region_id,name) VALUES(8,'Тервел');
INSERT INTO cities(region_id,name) VALUES(8,'Шабла');

INSERT INTO regions(name) VALUES('Кърджали');
INSERT INTO cities(region_id,name) VALUES(9,'Ардино');
INSERT INTO cities(region_id,name) VALUES(9,'Джебел');
INSERT INTO cities(region_id,name) VALUES(9,'Крумовград');
INSERT INTO cities(region_id,name) VALUES(9,'Кърджали');
INSERT INTO cities(region_id,name) VALUES(9,'Момчилград');

INSERT INTO regions(name) VALUES('Кюстендил');
INSERT INTO cities(region_id,name) VALUES(10,'Бобов дол');
INSERT INTO cities(region_id,name) VALUES(10,'Бобошево');
INSERT INTO cities(region_id,name) VALUES(10,'Дупница');
INSERT INTO cities(region_id,name) VALUES(10,'Кочериново');
INSERT INTO cities(region_id,name) VALUES(10,'Кюстендил');
INSERT INTO cities(region_id,name) VALUES(10,'Рила');
INSERT INTO cities(region_id,name) VALUES(10,'Сапарева баня');

INSERT INTO regions(name) VALUES('Ловеч');
INSERT INTO cities(region_id,name) VALUES(11,'Априлци');
INSERT INTO cities(region_id,name) VALUES(11,'Летница');
INSERT INTO cities(region_id,name) VALUES(11,'Ловеч');
INSERT INTO cities(region_id,name) VALUES(11,'Луковит');
INSERT INTO cities(region_id,name) VALUES(11,'Тетевен');
INSERT INTO cities(region_id,name) VALUES(11,'Троян');
INSERT INTO cities(region_id,name) VALUES(11,'Угърчин');
INSERT INTO cities(region_id,name) VALUES(11,'Ябланица');

INSERT INTO regions(name) VALUES('Монтана');
INSERT INTO cities(region_id,name) VALUES(12,'Берковица');
INSERT INTO cities(region_id,name) VALUES(12,'Бойчиновци');
INSERT INTO cities(region_id,name) VALUES(12,'Брусарци');
INSERT INTO cities(region_id,name) VALUES(12,'Вълчедръм');
INSERT INTO cities(region_id,name) VALUES(12,'Вършец');
INSERT INTO cities(region_id,name) VALUES(12,'Лом');
INSERT INTO cities(region_id,name) VALUES(12,'Монтана');
INSERT INTO cities(region_id,name) VALUES(12,'Чипровци');

INSERT INTO regions(name) VALUES('Пазарджик');
INSERT INTO cities(region_id,name) VALUES(13,'Батак');
INSERT INTO cities(region_id,name) VALUES(13,'Белово');
INSERT INTO cities(region_id,name) VALUES(13,'Брацигово');
INSERT INTO cities(region_id,name) VALUES(13,'Велинград');
INSERT INTO cities(region_id,name) VALUES(13,'Ветрен');
INSERT INTO cities(region_id,name) VALUES(13,'Костандово');
INSERT INTO cities(region_id,name) VALUES(13,'Пазарджик');
INSERT INTO cities(region_id,name) VALUES(13,'Панагюрище');
INSERT INTO cities(region_id,name) VALUES(13,'Пещера');
INSERT INTO cities(region_id,name) VALUES(13,'Ракитово');
INSERT INTO cities(region_id,name) VALUES(13,'Септември');
INSERT INTO cities(region_id,name) VALUES(13,'Стрелча');
INSERT INTO cities(region_id,name) VALUES(13,'Сърница');

INSERT INTO regions(name) VALUES('Перник');
INSERT INTO cities(region_id,name) VALUES(14,'Батановци');
INSERT INTO cities(region_id,name) VALUES(14,'Брезник');
INSERT INTO cities(region_id,name) VALUES(14,'Земен');
INSERT INTO cities(region_id,name) VALUES(14,'Перник');
INSERT INTO cities(region_id,name) VALUES(14,'Радомир');
INSERT INTO cities(region_id,name) VALUES(14,'Трън');

INSERT INTO regions(name) VALUES('Плевен');
INSERT INTO cities(region_id,name) VALUES(15,'Белене');
INSERT INTO cities(region_id,name) VALUES(15,'Гулянци');
INSERT INTO cities(region_id,name) VALUES(15,'Долна Митрополия');
INSERT INTO cities(region_id,name) VALUES(15,'Долни Дъбник');
INSERT INTO cities(region_id,name) VALUES(15,'Искър');
INSERT INTO cities(region_id,name) VALUES(15,'Кнежа');
INSERT INTO cities(region_id,name) VALUES(15,'Койнаре');
INSERT INTO cities(region_id,name) VALUES(15,'Левски');
INSERT INTO cities(region_id,name) VALUES(15,'Никопол');
INSERT INTO cities(region_id,name) VALUES(15,'Плевен');
INSERT INTO cities(region_id,name) VALUES(15,'Пордим');
INSERT INTO cities(region_id,name) VALUES(15,'Славяново');
INSERT INTO cities(region_id,name) VALUES(15,'Тръстеник');
INSERT INTO cities(region_id,name) VALUES(15,'Червен бряг');

INSERT INTO regions(name) VALUES('Пловдив');
INSERT INTO cities(region_id,name) VALUES(16,'Асеновград');
INSERT INTO cities(region_id,name) VALUES(16,'Баня');
INSERT INTO cities(region_id,name) VALUES(16,'Брезово');
INSERT INTO cities(region_id,name) VALUES(16,'Калофер');
INSERT INTO cities(region_id,name) VALUES(16,'Карлово');
INSERT INTO cities(region_id,name) VALUES(16,'Клисура');
INSERT INTO cities(region_id,name) VALUES(16,'Кричим');
INSERT INTO cities(region_id,name) VALUES(16,'Куклен');
INSERT INTO cities(region_id,name) VALUES(16,'Лъки');
INSERT INTO cities(region_id,name) VALUES(16,'Перущица');
INSERT INTO cities(region_id,name) VALUES(16,'Пловдив');
INSERT INTO cities(region_id,name) VALUES(16,'Първомай');
INSERT INTO cities(region_id,name) VALUES(16,'Раковски');
INSERT INTO cities(region_id,name) VALUES(16,'Садово');
INSERT INTO cities(region_id,name) VALUES(16,'Сопот');
INSERT INTO cities(region_id,name) VALUES(16,'Стамболийски');
INSERT INTO cities(region_id,name) VALUES(16,'Съединение');
INSERT INTO cities(region_id,name) VALUES(16,'Хисаря');
INSERT INTO cities(region_id,name) VALUES(16,'Баня');

INSERT INTO regions(name) VALUES('Разград');
INSERT INTO cities(region_id,name) VALUES(17,'Завет');
INSERT INTO cities(region_id,name) VALUES(17,'Исперих');
INSERT INTO cities(region_id,name) VALUES(17,'Кубрат');
INSERT INTO cities(region_id,name) VALUES(17,'Лозница');
INSERT INTO cities(region_id,name) VALUES(17,'Разград');
INSERT INTO cities(region_id,name) VALUES(17,'Цар Калоян');

INSERT INTO regions(name) VALUES('Русе');
INSERT INTO cities(region_id,name) VALUES(18,'Борово');
INSERT INTO cities(region_id,name) VALUES(18,'Бяла');
INSERT INTO cities(region_id,name) VALUES(18,'Ветово');
INSERT INTO cities(region_id,name) VALUES(18,'Глоджево');
INSERT INTO cities(region_id,name) VALUES(18,'Две могили');
INSERT INTO cities(region_id,name) VALUES(18,'Мартен');
INSERT INTO cities(region_id,name) VALUES(18,'Русе');
INSERT INTO cities(region_id,name) VALUES(18,'Сеново');
INSERT INTO cities(region_id,name) VALUES(18,'Сливо поле');

INSERT INTO regions(name) VALUES('Силистра');
INSERT INTO cities(region_id,name) VALUES(19,'Алфатар');
INSERT INTO cities(region_id,name) VALUES(19,'Главиница');
INSERT INTO cities(region_id,name) VALUES(19,'Дулово');
INSERT INTO cities(region_id,name) VALUES(19,'Силистра');
INSERT INTO cities(region_id,name) VALUES(19,'Тутракан');

INSERT INTO regions(name) VALUES('Сливен');
INSERT INTO cities(region_id,name) VALUES(20,'Кермен');
INSERT INTO cities(region_id,name) VALUES(20,'Котел');
INSERT INTO cities(region_id,name) VALUES(20,'Нова Загора');
INSERT INTO cities(region_id,name) VALUES(20,'Сливен');
INSERT INTO cities(region_id,name) VALUES(20,'Твърдица');
INSERT INTO cities(region_id,name) VALUES(20,'Шивачево');

INSERT INTO regions(name) VALUES('Смолян');
INSERT INTO cities(region_id,name) VALUES(21,'Девин');
INSERT INTO cities(region_id,name) VALUES(21,'Доспат');
INSERT INTO cities(region_id,name) VALUES(21,'Златоград');
INSERT INTO cities(region_id,name) VALUES(21,'Мадан');
INSERT INTO cities(region_id,name) VALUES(21,'Неделино');
INSERT INTO cities(region_id,name) VALUES(21,'Рудозем');
INSERT INTO cities(region_id,name) VALUES(21,'Смолян');
INSERT INTO cities(region_id,name) VALUES(21,'Чепеларе');

INSERT INTO regions(name) VALUES('София');
INSERT INTO cities(region_id,name) VALUES(22,'Банкя');
INSERT INTO cities(region_id,name) VALUES(22,'Божурище');
INSERT INTO cities(region_id,name) VALUES(22,'Ботевград');
INSERT INTO cities(region_id,name) VALUES(22,'Бухово');
INSERT INTO cities(region_id,name) VALUES(22,'Българово');
INSERT INTO cities(region_id,name) VALUES(22,'Годеч');
INSERT INTO cities(region_id,name) VALUES(22,'Долна баня');
INSERT INTO cities(region_id,name) VALUES(22,'Драгоман');
INSERT INTO cities(region_id,name) VALUES(22,'Елин Пелин');
INSERT INTO cities(region_id,name) VALUES(22,'Етрополе');
INSERT INTO cities(region_id,name) VALUES(22,'Златица');
INSERT INTO cities(region_id,name) VALUES(22,'Ихтиман');
INSERT INTO cities(region_id,name) VALUES(22,'Копривщица');
INSERT INTO cities(region_id,name) VALUES(22,'Костенец');
INSERT INTO cities(region_id,name) VALUES(22,'Костинброд');
INSERT INTO cities(region_id,name) VALUES(22,'Момин проход');
INSERT INTO cities(region_id,name) VALUES(22,'Нови Искър');
INSERT INTO cities(region_id,name) VALUES(22,'Пирдоп');
INSERT INTO cities(region_id,name) VALUES(22,'Правец');
INSERT INTO cities(region_id,name) VALUES(22,'Самоков');
INSERT INTO cities(region_id,name) VALUES(22,'Своге');
INSERT INTO cities(region_id,name) VALUES(22,'Сливница');
INSERT INTO cities(region_id,name) VALUES(22,'София');

INSERT INTO regions(name) VALUES('Стара Загора');
INSERT INTO cities(region_id,name) VALUES(23,'Гурково');
INSERT INTO cities(region_id,name) VALUES(23,'Гълъбово');
INSERT INTO cities(region_id,name) VALUES(23,'Казанлък');
INSERT INTO cities(region_id,name) VALUES(23,'Мъглиж');
INSERT INTO cities(region_id,name) VALUES(23,'Николаево');
INSERT INTO cities(region_id,name) VALUES(23,'Павел баня');
INSERT INTO cities(region_id,name) VALUES(23,'Раднево');
INSERT INTO cities(region_id,name) VALUES(23,'Стара Загора');
INSERT INTO cities(region_id,name) VALUES(23,'Чирпан');
INSERT INTO cities(region_id,name) VALUES(23,'Шипка');

INSERT INTO regions(name) VALUES('Търговище');
INSERT INTO cities(region_id,name) VALUES(23,'Антоново');
INSERT INTO cities(region_id,name) VALUES(23,'Омуртаг');
INSERT INTO cities(region_id,name) VALUES(23,'Опака');
INSERT INTO cities(region_id,name) VALUES(23,'Попово');
INSERT INTO cities(region_id,name) VALUES(23,'Търговище');

INSERT INTO regions(name) VALUES('Хасково');
INSERT INTO cities(region_id,name) VALUES(24,'Върбица');
INSERT INTO cities(region_id,name) VALUES(24,'Димитровград');
INSERT INTO cities(region_id,name) VALUES(24,'Ивайловград');
INSERT INTO cities(region_id,name) VALUES(24,'Любимец');
INSERT INTO cities(region_id,name) VALUES(24,'Маджарово');
INSERT INTO cities(region_id,name) VALUES(24,'Меричлери');
INSERT INTO cities(region_id,name) VALUES(24,'Свиленград');
INSERT INTO cities(region_id,name) VALUES(24,'Симеоновград');
INSERT INTO cities(region_id,name) VALUES(24,'Тополовград');
INSERT INTO cities(region_id,name) VALUES(24,'Харманли');
INSERT INTO cities(region_id,name) VALUES(24,'Хасково');

INSERT INTO regions(name) VALUES('Шумен');
INSERT INTO cities(region_id,name) VALUES(25,'Върбица');
INSERT INTO cities(region_id,name) VALUES(25,'Димитровград');
INSERT INTO cities(region_id,name) VALUES(25,'Ивайловград');
INSERT INTO cities(region_id,name) VALUES(25,'Любимец');
INSERT INTO cities(region_id,name) VALUES(25,'Маджарово');
INSERT INTO cities(region_id,name) VALUES(25,'Меричлери');
INSERT INTO cities(region_id,name) VALUES(25,'Свиленград');
INSERT INTO cities(region_id,name) VALUES(25,'Симеоновград');
INSERT INTO cities(region_id,name) VALUES(25,'Тополовград');
INSERT INTO cities(region_id,name) VALUES(25,'Харманли');
INSERT INTO cities(region_id,name) VALUES(25,'Хасково');

INSERT INTO regions(name) VALUES('Ямбол');
INSERT INTO cities(region_id,name) VALUES(26,'Елхово');
INSERT INTO cities(region_id,name) VALUES(26,'Стралджа');
INSERT INTO cities(region_id,name) VALUES(26,'Ямбол');