Skip to content

Instantly share code, notes, and snippets.

@ShahzadNaser

ShahzadNaser/cities in pakistan

Last active August 27, 2024 08:18
Show Gist options
  • Save ShahzadNaser/443f771607d793a345802d172272585a to your computer and use it in GitHub Desktop.
Save ShahzadNaser/443f771607d793a345802d172272585a to your computer and use it in GitHub Desktop.
Download ZIP
All major cities of Pakistan
Raw
cities in pakistan
INSERT INTO `cities` (`id`, `name`) VALUES
(48, 'Adezai'),
(205, 'Ahmed Nager Chatha'),
(50, 'Akora Khattak'),
(206, 'Ali Khan Abad'),
(207, 'Alipur'),
(49, 'Alpuri'),
(16, 'Alyabad Hunza'),
(51, 'Amirabad'),
(208, 'Arifwala'),
(2, 'Astore'),
(209, 'Attock'),
(52, 'Ayubia'),
(212, 'Bahawalnagar'),
(213, 'Bahawalpur'),
(53, 'Banda Daud Shah'),
(54, 'Bannu'),
(124, 'Barkhan'),
(55, 'Batkhela'),
(56, 'Battagram'),
(214, 'Bhakkar'),
(211, 'Bhalwal'),
(210, 'Bhera'),
(132, 'Bhiria City'),
(133, 'Bhiria Road'),
(131, 'Bhirkan'),
(57, 'Birote'),
(3, 'Bunji (or Boanzhi)'),
(215, 'Burewala'),
(135, 'Chak'),
(219, 'Chak Jhumra'),
(58, 'Chakdara'),
(218, 'Chakwal'),
(20, 'Chalt (Nagar)'),
(59, 'Charsadda'),
(60, 'Cherat'),
(220, 'Chichawatni'),
(4, 'Chilas'),
(216, 'Chillianwala'),
(5, 'Chillinji'),
(221, 'Chiniot'),
(6, 'Chiran'),
(61, 'Chitral'),
(217, 'Choa Saidanshah'),
(223, 'Chunian'),
(136, 'Dadu'),
(62, 'Daggar'),
(224, 'Dajkot'),
(63, 'Dargai'),
(227, 'Darya Khan'),
(225, 'Daska'),
(226, 'Davispur'),
(11, 'Dayore - Gilgit'),
(228, 'Dera Ghazi Khan'),
(64, 'Dera Ismail Khan'),
(229, 'Dhaular'),
(232, 'Dhudial Chakwal'),
(137, 'Digri'),
(230, 'Dina'),
(231, 'Dinga'),
(233, 'Dipalpur'),
(138, 'Diplo'),
(66, 'Dir'),
(65, 'Doaba'),
(139, 'Dokri'),
(67, 'Drosh'),
(234, 'Faisalabad'),
(235, 'Fateh Jang'),
(7, 'Gakuch'),
(236, 'Ghakhar Mandi'),
(8, 'Ghangche'),
(9, 'Ghizer'),
(140, 'Ghotki'),
(28, 'Ghulmat (Nagar)'),
(10, 'Gilgit'),
(237, 'Gojra'),
(17, 'Gorikot'),
(240, 'Gujar Khan'),
(238, 'Gujranwala'),
(239, 'Gujrat'),
(18, 'Gulmit'),
(141, 'Haala'),
(242, 'Hafizabad'),
(68, 'Hangu'),
(241, 'Harappa'),
(69, 'Haripur'),
(243, 'Haroonabad'),
(244, 'Hasilpur'),
(245, 'Haveli Lakha'),
(25, 'Hussain Abad'),
(142, 'Hyderabad'),
(30, 'Ishkoman'),
(265, 'Islamabad'),
(143, 'Islamkot'),
(144, 'Jacobabad'),
(19, 'Jaglot'),
(14, 'Jalalabad Gilgit'),
(246, 'Jalalpur Jattan'),
(247, 'Jampur'),
(145, 'Jamshoro'),
(248, 'Jaranwala'),
(263, 'Jauharabad'),
(249, 'Jhang'),
(250, 'Jhelum'),
(146, 'Jungshahi'),
(15, 'Jutial Gilgit'),
(252, 'Kalabagh'),
(251, 'Kallar Syedan'),
(255, 'Kamalia'),
(147, 'Kandhkot'),
(148, 'Kandiaro'),
(149, 'Karachi'),
(70, 'Karak'),
(29, 'Karimabad (Hunza)'),
(253, 'Karor Lal Esan'),
(150, 'Kashmore'),
(254, 'Kasur'),
(151, 'Keti Bandar'),
(152, 'Khadro'),
(153, 'Khairpur'),
(24, 'Khana Abad'),
(257, 'Khanewal'),
(258, 'Khanpur'),
(259, 'Khanqah Sharif'),
(31, 'Khaplu'),
(260, 'Kharian'),
(154, 'Khipro'),
(261, 'Khushab'),
(71, 'Kohat'),
(262, 'Kot Adu'),
(155, 'Kotri'),
(72, 'Kulachi'),
(256, 'Kāmoke'),
(264, 'Lahore'),
(202, 'Lakhi ghulam shah'),
(73, 'Lakki Marwat'),
(266, 'Lalamusa'),
(156, 'Larkana'),
(74, 'Latamber'),
(268, 'Lawa Chakwal'),
(267, 'Layyah'),
(269, 'Liaquat Pur'),
(270, 'Lodhran'),
(75, 'Madyan'),
(273, 'Mailsi'),
(271, 'Malakwal'),
(272, 'Mamoori'),
(274, 'Mandi Bahauddin'),
(201, 'Manjhand'),
(76, 'Mansehra'),
(199, 'Maqsoodo Rind'),
(77, 'Mardan'),
(78, 'Mastuj'),
(157, 'Matiari'),
(23, 'Mayoon'),
(158, 'Mehar'),
(162, 'Mehrabpur'),
(197, 'Mehrabpur'),
(275, 'Mian Channu'),
(203, 'Mian Sahib'),
(277, 'Miani'),
(276, 'Mianwali'),
(281, 'Mianwali Bangla'),
(79, 'Mingora'),
(32, 'Minimerg'),
(159, 'Mirpur Khas'),
(33, 'Misgar'),
(160, 'Mithani'),
(161, 'Mithi'),
(163, 'Moro'),
(278, 'Multan'),
(280, 'Muridke'),
(279, 'Murree'),
(282, 'Muzaffargarh'),
(27, 'Nagar Proper'),
(164, 'Nagarparkar'),
(284, 'Nankana Sahib'),
(80, 'Naran Kaghan Valley'),
(283, 'Narowal'),
(22, 'Nasir Abad'),
(165, 'Naudero'),
(166, 'Naushahro Feroze'),
(167, 'Naushara'),
(168, 'Nawabshah'),
(81, 'Nowshera'),
(285, 'Okara'),
(13, 'oshikhanda Gilgit'),
(83, 'Pabbi'),
(82, 'Paharpur'),
(287, 'Pakpattan'),
(34, 'Passu'),
(288, 'Pattoki'),
(84, 'Peshawar'),
(290, 'Pind Dadan Khan'),
(289, 'Pindi Bhattian'),
(194, 'Pir jo goth'),
(291, 'Pir Mahal'),
(191, 'Piryaloi'),
(292, 'Qaimpur'),
(169, 'Qambar'),
(170, 'Qasimabad'),
(26, 'Qasimabad Masoot (Nagar)'),
(293, 'Qila Didar Singh'),
(196, 'Qubo Saeed Khan'),
(294, 'Rabwah'),
(297, 'Rahim Yar Khan'),
(295, 'Raiwind'),
(296, 'Rajanpur'),
(134, 'Rajo Khanani'),
(171, 'Ranipur'),
(172, 'Ratodero'),
(298, 'Rawalpindi'),
(286, 'Renala Khurd'),
(85, 'Risalpur'),
(173, 'Rohri'),
(299, 'Sadiqabad'),
(300, 'Sagri'),
(301, 'Sahiwal'),
(86, 'Saidu Sharif'),
(174, 'Sakrand'),
(198, 'Samaro'),
(302, 'Sambrial'),
(303, 'Samundri'),
(175, 'Sanghar'),
(304, 'Sangla Hill'),
(200, 'Sann'),
(305, 'Sarai Alamgir'),
(306, 'Sargodha'),
(176, 'Shahbandar'),
(177, 'Shahdadkot'),
(178, 'Shahdadpur'),
(179, 'Shahpur Chakar'),
(195, 'Shahpur jahania'),
(307, 'Shakargarh'),
(308, 'Sheikhupura'),
(87, 'Shewa Adda'),
(180, 'Shikarpaur'),
(35, 'Shimshal'),
(309, 'Shujaabad'),
(310, 'Sialkot'),
(181, 'Sinjhoro'),
(313, 'Siranwali'),
(193, 'Sita Road'),
(36, 'Skardu'),
(311, 'Sohawa'),
(312, 'Soianwala'),
(182, 'Sukkur'),
(12, 'Sultanabad - Gilgit'),
(37, 'Sust'),
(88, 'Swabi'),
(89, 'Swat'),
(38, 'Taghafari'),
(315, 'Talagang'),
(314, 'Tandlianwala'),
(184, 'Tando Adam Khan'),
(185, 'Tando Allahyar'),
(186, 'Tando Muhammad Khan'),
(90, 'Tangi'),
(183, 'Tangwani'),
(91, 'Tank'),
(316, 'Taxila'),
(92, 'Thall'),
(188, 'Thari Mirwah'),
(192, 'Tharushah'),
(187, 'Thatta'),
(21, 'Thole (Nagar)'),
(39, 'Thorar'),
(93, 'Timergara'),
(317, 'Toba Tek Singh'),
(94, 'Tordher'),
(189, 'Umerkot'),
(318, 'Vehari'),
(319, 'Wah Cantonment'),
(190, 'Warah'),
(320, 'Wazirabad'),
(321, 'Yazman'),
(322, 'Zafarwal'),
(116, 'District Nushki '),
(120, 'Harnai'),
(108, 'Jhal'),
(110, 'Kachhi'),
(96, 'Kalat'),
(104, 'Kech'),
(97, 'Kharan'),
(98, 'Khuzdar'),
(41, 'Khyber'),
(115, 'Killa Abdullah'),
(125, 'Killa Saifullah '),
(121, 'Kohlu'),
(42, 'Kurram'),
(99, 'Lasbela'),
(112, 'Lehri'),
(109, 'Magsi'),
(106, 'Mand'),
(100, 'Mastung'),
(43, 'Mohmand'),
(127, 'Musakhel'),
(111, 'Nasirabad'),
(44, 'North Waziristan'),
(45, 'Orakzai'),
(105, 'Panjgur'),
(118, 'Quetta'),
(128, 'Sherani'),
(122, 'Sibi'),
(113, 'Sohbatpur'),
(46, 'South Waziristan'),
(101, 'Washuk'),
(129, 'Zhob'),
(123, 'Ziarat'),
(47, 'Abbottabad'),
(204, 'Ahmadpur East'),
(1, 'Askole'),
(95, 'Awaran'),
(130, 'Badin'),
(40, 'Bajaur'),
(114, 'Chagai'),
(222, 'Chishtian'),
(119, 'Dera Bugti'),
(126, 'District Loralai'),
(103, 'Gwadar'),
(107, 'Jafarabad'),
(102, 'Makran'),
(117, 'Pishin');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment