proyecto26/colombia

Departamentos y Municipios de Colombia 🇨🇴

MIT

Departamentos y Municipios de Colombia

Data extracted from Departamento Administrativo Nacional de Estadística.

Info

Entity name: Ministerio de Tecnologías de La Información y Las Comunicaciones (MinTIC).
Date: 2017-05-11

JSON Data

Departments: https://github.com/proyecto26/colombia/raw/master/departments.json
Cities: https://github.com/proyecto26/colombia/raw/master/cities.json

SQL Tables

Departments

CREATE TABLE IF NOT EXISTS department (
  id INT PRIMARY KEY,
  `name` VARCHAR(80) NOT NULL
);

Cities

CREATE TABLE IF NOT EXISTS city (
  id INT PRIMARY KEY,
  `name` VARCHAR(50) NOT NULL,
  `departmentId` INT NOT NULL,
  CONSTRAINT `fk_city_department`
    FOREIGN KEY (`departmentId`)
    REFERENCES `department` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION
);

Supporting 🍻

I believe in Unicorns 🦄 Support me, if you do too.

Donate Ethereum, ADA, BNB, SHIBA, USDT/USDC, DOGE, etc:

Wallet address: jdnichollsc.eth

Please let us know your contributions! 🙏

Happy coding 💯

Made with ❤️