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 ❤️