全国省市区数据SQL - 邮编

DROP TABLE IF EXISTS `zipcode`;
CREATE TABLE `zipcode` (
  `id` int(11) NOT NULL auto_increment,
  `areaid` varchar(20) NOT NULL,
  `zip` varchar(20) NOT NULL,
  `code` varchar(20) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3145 ;


insert into zipcode(id,areaid,zip,code) values(1,'110101','100000','010');
insert into zipcode(id,areaid,zip,code) values(2,'110102','100000','010');
insert into zipcode(id,areaid,zip,code) values(3,'110103','100000','010');
insert into zipcode(id,areaid,zip,code) values(4,'110104','100000','010');
insert into zipcode(id,areaid,zip,code) values(5,'110105','100000','010');
insert into zipcode(id,areaid,zip,code) values(6,'110106','100000','010');
insert into zipcode(id,areaid,zip,code) values(7,'110107','100000','010');
insert into zipcode(id,areaid,zip,code) values(8,'110108','100000','010');
insert into zipcode(id,areaid,zip,code) values(9,'110109','102300','010');
insert into zipcode(id,areaid,zip,code) values(10,'110111','102400','010');
insert into zipcode(id,areaid,zip,code) values(11,'110112','101100','010');
insert into zipcode(id,areaid,zip,code) values(12,'110113','101300','010');
insert into zipcode(id,areaid,zip,code) values(13,'110114','102200','010');
insert into zipcode(id,areaid,zip,code) values(14,'110115','102600','010');
insert into zipcode(id,areaid,zip,code) values(15,'110116','101400','010');
insert into zipcode(id,areaid,zip,code) values(16,'110117','101200','010');
insert into zipcode(id,areaid,zip,code) values(17,'110228','101500','010');
insert into zipcode(id,areaid,zip,code) values(18,'110229','102100','010');
insert into zipcode(id,areaid,zip,code) values(19,'120101','300000','022');
insert into zipcode(id,areaid,zip,code) values(20,'120102','300000','022');
insert into zipcode(id,areaid,zip,code) values(21,'120103','300000','022');
insert into zipcode(id,areaid,zip,code) values(22,'120104','300000','022');
insert into zipcode(id,areaid,zip,code) values(23,'120105','300000','022');
insert into zipcode(id,areaid,zip,code) values(24,'120106','300000','022');
insert into zipcode(id,areaid,zip,code) values(25,'120107','300450','022');
insert into zipcode(id,areaid,zip,code) values(26,'120108','300480','022');
insert into zipcode(id,areaid,zip,code) values(27,'120109','300000','022');
insert into zipcode(id,areaid,zip,code) values(28,'120110','300000','022');
insert into zipcode(id,areaid,zip,code) values(29,'120111','300000','022');
insert into zipcode(id,areaid,zip,code) values(30,'120112','300000','022');
insert into zipcode(id,areaid,zip,code) values(31,'120113','300000','022');
insert into zipcode(id,areaid,zip,code) values(32,'120114','301700','022');
insert into zipcode(id,areaid,zip,code) values(33,'120115','301800','022');
insert into zipcode(id,areaid,zip,code) values(34,'120221','301500','022');
insert into zipcode(id,areaid,zip,code) values(35,'120223','301600','022');
insert into zipcode(id,areaid,zip,code) values(36,'120225','301900','022');
insert into zipcode(id,areaid,zip,code) values(37,'130101','050000','0311');
insert into zipcode(id,areaid,zip,code) values(38,'130102','050000','0311');
insert into zipcode(id,areaid,zip,code) values(39,'130103','050000','0311');
insert into zipcode(id,areaid,zip,code) values(40,'130104','050000','0311');
insert into zipcode(id,areaid,zip,code) values(41,'130105','050000','0311');
insert into zipcode(id,areaid,zip,code) values(42,'130107','051000','0311');
insert into zipcode(id,areaid,zip,code) values(43,'130108','050000','0311');
insert into zipcode(id,areaid,zip,code) values(44,'130121','050300','0311');
insert into zipcode(id,areaid,zip,code) values(45,'130123','050800','0311');
insert into zipcode(id,areaid,zip,code) values(46,'130124','051430','0311');
insert into zipcode(id,areaid,zip,code) values(47,'130125','050600','0311');
insert into zipcode(id,areaid,zip,code) values(48,'130126','050500','0311');
insert into zipcode(id,areaid,zip,code) values(49,'130127','051330','0311');
insert into zipcode(id,areaid,zip,code) values(50,'130128','052500','0311');
insert into zipcode(id,areaid,zip,code) values(51,'130129','051230','0311');
insert into zipcode(id,areaid,zip,code) values(52,'130130','052400','0311');
insert into zipcode(id,areaid,zip,code) values(53,'130131','050400','0311');
insert into zipcode(id,areaid,zip,code) values(54,'130132','051130','0311');
insert into zipcode(id,areaid,zip,code) values(55,'130133','051530','0311');
insert into zipcode(id,areaid,zip,code) values(56,'130181','052300','0311');
insert into zipcode(id,areaid,zip,code) values(57,'130182','052160','0311');
insert into zipcode(id,areaid,zip,code) values(58,'130183','052200','0311');
insert into zipcode(id,areaid,zip,code) values(59,'130184','050700','0311');
insert into zipcode(id,areaid,zip,code) values(60,'130185','050200','0311');
insert into zipcode(id,areaid,zip,code) values(61,'130201','063000','0315');
insert into zipcode(id,areaid,zip,code) values(62,'130202','063000','0315');
insert into zipcode(id,areaid,zip,code) values(63,'130203','063000','0315');
insert into zipcode(id,areaid,zip,code) values(64,'130204','063000','0315');
insert into zipcode(id,areaid,zip,code) values(65,'130205','063000','0315');
insert into zipcode(id,areaid,zip,code) values(66,'130207','063300','0315');
insert into zipcode(id,areaid,zip,code) values(67,'130208','063000','0315');
insert into zipcode(id,areaid,zip,code) values(68,'130223','063700','0315');
insert into zipcode(id,areaid,zip,code) values(69,'130224','063500','0315');
insert into zipcode(id,areaid,zip,code) values(70,'130225','063600','0315');
insert into zipcode(id,areaid,zip,code) values(71,'130227','064300','0315');
insert into zipcode(id,areaid,zip,code) values(72,'130229','064100','0315');
insert into zipcode(id,areaid,zip,code) values(73,'130230','063200','0315');
insert into zipcode(id,areaid,zip,code) values(74,'130281','064200','0315');
insert into zipcode(id,areaid,zip,code) values(75,'130283','064400','0315');
insert into zipcode(id,areaid,zip,code) values(76,'130301','066000','0335');
insert into zipcode(id,areaid,zip,code) values(77,'130302','066000','0335');
insert into zipcode(id,areaid,zip,code) values(78,'130303','066200','0335');
insert into zipcode(id,areaid,zip,code) values(79,'130304','066100','0335');
insert into zipcode(id,areaid,zip,code) values(80,'130321','066500','0335');
insert into zipcode(id,areaid,zip,code) values(81,'130322','066600','0335');
insert into zipcode(id,areaid,zip,code) values(82,'130323','066300','0335');
insert into zipcode(id,areaid,zip,code) values(83,'130324','066400','0335');
insert into zipcode(id,areaid,zip,code) values(84,'130401','056000','0310');
insert into zipcode(id,areaid,zip,code) values(85,'130402','056000','0310');
insert into zipcode(id,areaid,zip,code) values(86,'130403','056000','0310');
insert into zipcode(id,areaid,zip,code) values(87,'130404','056000','0310');
insert into zipcode(id,areaid,zip,code) values(88,'130406','056200','0310');
insert into zipcode(id,areaid,zip,code) values(89,'130421','056000','0310');
insert into zipcode(id,areaid,zip,code) values(90,'130423','056600','0310');
insert into zipcode(id,areaid,zip,code) values(91,'130424','056700','0310');
insert into zipcode(id,areaid,zip,code) values(92,'130425','056900','0310');
insert into zipcode(id,areaid,zip,code) values(93,'130426','056400','0310');
insert into zipcode(id,areaid,zip,code) values(94,'130427','056500','0310');
insert into zipcode(id,areaid,zip,code) values(95,'130428','057550','0310');
insert into zipcode(id,areaid,zip,code) values(96,'130429','057150','0310');
insert into zipcode(id,areaid,zip,code) values(97,'130430','057450','0310');
insert into zipcode(id,areaid,zip,code) values(98,'130431','057350','0310');
insert into zipcode(id,areaid,zip,code) values(99,'130432','057650','0310');
insert into zipcode(id,areaid,zip,code) values(100,'130433','057750','0310');
insert into zipcode(id,areaid,zip,code) values(101,'130434','056800','0310');
insert into zipcode(id,areaid,zip,code) values(102,'130435','057250','0310');
insert into zipcode(id,areaid,zip,code) values(103,'130481','056300','0310');
insert into zipcode(id,areaid,zip,code) values(104,'130501','054000','0319');
insert into zipcode(id,areaid,zip,code) values(105,'130502','054000','0319');
insert into zipcode(id,areaid,zip,code) values(106,'130503','054000','0319');
insert into zipcode(id,areaid,zip,code) values(107,'130521','054000','0319');
insert into zipcode(id,areaid,zip,code) values(108,'130522','054300','0319');
insert into zipcode(id,areaid,zip,code) values(109,'130523','054200','0319');
insert into zipcode(id,areaid,zip,code) values(110,'130524','055450','0319');
insert into zipcode(id,areaid,zip,code) values(111,'130525','055350','0319');
insert into zipcode(id,areaid,zip,code) values(112,'130526','055150','0319');
insert into zipcode(id,areaid,zip,code) values(113,'130527','054400','0319');
insert into zipcode(id,areaid,zip,code) values(114,'130528','055550','0319');
insert into zipcode(id,areaid,zip,code) values(115,'130529','055250','0319');
insert into zipcode(id,areaid,zip,code) values(116,'130530','051730','0319');
insert into zipcode(id,areaid,zip,code) values(117,'130531','054600','0319');
insert into zipcode(id,areaid,zip,code) values(118,'130532','054500','0319');
insert into zipcode(id,areaid,zip,code) values(119,'130533','054700','0319');
insert into zipcode(id,areaid,zip,code) values(120,'130534','054800','0319');
insert into zipcode(id,areaid,zip,code) values(121,'130535','054900','0319');
insert into zipcode(id,areaid,zip,code) values(122,'130581','051800','0319');
insert into zipcode(id,areaid,zip,code) values(123,'130582','054100','0319');
insert into zipcode(id,areaid,zip,code) values(124,'130601','071000','0312');
insert into zipcode(id,areaid,zip,code) values(125,'130602','071000','0312');
insert into zipcode(id,areaid,zip,code) values(126,'130603','071000','0312');
insert into zipcode(id,areaid,zip,code) values(127,'130604','071000','0312');
insert into zipcode(id,areaid,zip,code) values(128,'130621','072150','0312');
insert into zipcode(id,areaid,zip,code) values(129,'130622','071100','0312');
insert into zipcode(id,areaid,zip,code) values(130,'130623','074100','0312');
insert into zipcode(id,areaid,zip,code) values(131,'130624','073200','0312');
insert into zipcode(id,areaid,zip,code) values(132,'130625','072550','0312');
insert into zipcode(id,areaid,zip,code) values(133,'130626','072650','0312');
insert into zipcode(id,areaid,zip,code) values(134,'130627','072350','0312');
insert into zipcode(id,areaid,zip,code) values(135,'130628','071500','0312');
insert into zipcode(id,areaid,zip,code) values(136,'130629','071700','0312');
insert into zipcode(id,areaid,zip,code) values(137,'130630','102900','0312');
insert into zipcode(id,areaid,zip,code) values(138,'130631','072450','0312');
insert into zipcode(id,areaid,zip,code) values(139,'130632','071600','0312');
insert into zipcode(id,areaid,zip,code) values(140,'130633','074200','0312');
insert into zipcode(id,areaid,zip,code) values(141,'130634','073100','0312');
insert into zipcode(id,areaid,zip,code) values(142,'130635','071400','0312');
insert into zipcode(id,areaid,zip,code) values(143,'130636','072250','0312');
insert into zipcode(id,areaid,zip,code) values(144,'130637','071300','0312');
insert into zipcode(id,areaid,zip,code) values(145,'130638','071800','0312');
insert into zipcode(id,areaid,zip,code) values(146,'130681','072750','0312');
insert into zipcode(id,areaid,zip,code) values(147,'130682','073000','0312');
insert into zipcode(id,areaid,zip,code) values(148,'130683','071200','0312');
insert into zipcode(id,areaid,zip,code) values(149,'130684','074000','0312');
insert into zipcode(id,areaid,zip,code) values(150,'130701','075000','0313');
insert into zipcode(id,areaid,zip,code) values(151,'130702','075000','0313');
insert into zipcode(id,areaid,zip,code) values(152,'130703','075000','0313');
insert into zipcode(id,areaid,zip,code) values(153,'130705','075000','0313');
insert into zipcode(id,areaid,zip,code) values(154,'130706','075000','0313');
insert into zipcode(id,areaid,zip,code) values(155,'130721','075100','0313');
insert into zipcode(id,areaid,zip,code) values(156,'130722','076450','0313');
insert into zipcode(id,areaid,zip,code) values(157,'130723','076650','0313');
insert into zipcode(id,areaid,zip,code) values(158,'130724','076550','0313');
insert into zipcode(id,areaid,zip,code) values(159,'130725','076750','0313');
insert into zipcode(id,areaid,zip,code) values(160,'130726','075700','0313');
insert into zipcode(id,areaid,zip,code) values(161,'130727','075800','0313');
insert into zipcode(id,areaid,zip,code) values(162,'130728','076150','0313');
insert into zipcode(id,areaid,zip,code) values(163,'130729','076250','0313');
insert into zipcode(id,areaid,zip,code) values(164,'130730','075400','0313');
insert into zipcode(id,areaid,zip,code) values(165,'130731','075600','0313');
insert into zipcode(id,areaid,zip,code) values(166,'130732','075500','0313');
insert into zipcode(id,areaid,zip,code) values(167,'130733','076350','0313');
insert into zipcode(id,areaid,zip,code) values(168,'130801','067000','0314');
insert into zipcode(id,areaid,zip,code) values(169,'130802','067000','0314');
insert into zipcode(id,areaid,zip,code) values(170,'130803','067000','0314');
insert into zipcode(id,areaid,zip,code) values(171,'130804','067200','0314');
insert into zipcode(id,areaid,zip,code) values(172,'130821','067400','0314');
insert into zipcode(id,areaid,zip,code) values(173,'130822','067300','0314');
insert into zipcode(id,areaid,zip,code) values(174,'130823','067500','0314');
insert into zipcode(id,areaid,zip,code) values(175,'130824','068250','0314');
insert into zipcode(id,areaid,zip,code) values(176,'130825','068150','0314');
insert into zipcode(id,areaid,zip,code) values(177,'130826','068350','0314');
insert into zipcode(id,areaid,zip,code) values(178,'130827','067600','0314');
insert into zipcode(id,areaid,zip,code) values(179,'130828','068450','0314');
insert into zipcode(id,areaid,zip,code) values(180,'130901','061000','0317');
insert into zipcode(id,areaid,zip,code) values(181,'130902','061000','0317');
insert into zipcode(id,areaid,zip,code) values(182,'130903','061000','0317');
insert into zipcode(id,areaid,zip,code) values(183,'130921','061000','0317');
insert into zipcode(id,areaid,zip,code) values(184,'130922','062650','0315');
insert into zipcode(id,areaid,zip,code) values(185,'130923','061600','0317');
insert into zipcode(id,areaid,zip,code) values(186,'130924','061200','0317');
insert into zipcode(id,areaid,zip,code) values(187,'130925','061300','0317');
insert into zipcode(id,areaid,zip,code) values(188,'130926','062350','0317');
insert into zipcode(id,areaid,zip,code) values(189,'130927','061500','0317');
insert into zipcode(id,areaid,zip,code) values(190,'130928','061800','0317');
insert into zipcode(id,areaid,zip,code) values(191,'130929','062250','0317');
insert into zipcode(id,areaid,zip,code) values(192,'130930','061400','0317');
insert into zipcode(id,areaid,zip,code) values(193,'130981','062150','0317');
insert into zipcode(id,areaid,zip,code) values(194,'130982','062550','0317');
insert into zipcode(id,areaid,zip,code) values(195,'130983','061100','0317');
insert into zipcode(id,areaid,zip,code) values(196,'130984','062450','0317');
insert into zipcode(id,areaid,zip,code) values(197,'131001','065000','0316');
insert into zipcode(id,areaid,zip,code) values(198,'131002','065000','0316');
insert into zipcode(id,areaid,zip,code) values(199,'131003','065000','0316');
insert into zipcode(id,areaid,zip,code) values(200,'131022','065500','0316');
insert into zipcode(id,areaid,zip,code) values(201,'131023','065600','0316');
insert into zipcode(id,areaid,zip,code) values(202,'131024','065400','0316');
insert into zipcode(id,areaid,zip,code) values(203,'131025','065900','0316');
insert into zipcode(id,areaid,zip,code) values(204,'131026','065800','0316');
insert into zipcode(id,areaid,zip,code) values(205,'131028','065300','0316');
insert into zipcode(id,areaid,zip,code) values(206,'131081','065700','0316');
insert into zipcode(id,areaid,zip,code) values(207,'131082','065200','0316');
insert into zipcode(id,areaid,zip,code) values(208,'131101','053000','0318');
insert into zipcode(id,areaid,zip,code) values(209,'131102','053000','0318');
insert into zipcode(id,areaid,zip,code) values(210,'131121','053100','0318');
insert into zipcode(id,areaid,zip,code) values(211,'131122','053400','0318');
insert into zipcode(id,areaid,zip,code) values(212,'131123','053300','0318');
insert into zipcode(id,areaid,zip,code) values(213,'131124','053900','0318');
insert into zipcode(id,areaid,zip,code) values(214,'131125','053600','0318');
insert into zipcode(id,areaid,zip,code) values(215,'131126','053800','0318');
insert into zipcode(id,areaid,zip,code) values(216,'131127','053500','0318');
insert into zipcode(id,areaid,zip,code) values(217,'131128','053700','0318');
insert into zipcode(id,areaid,zip,code) values(218,'131181','053200','0318');
insert into zipcode(id,areaid,zip,code) values(219,'131182','052800','0318');
insert into zipcode(id,areaid,zip,code) values(220,'140101','030000','0351');
insert into zipcode(id,areaid,zip,code) values(221,'140105','030000','0351');
insert into zipcode(id,areaid,zip,code) values(222,'140106','030000','0351');
insert into zipcode(id,areaid,zip,code) values(223,'140107','030000','0351');
insert into zipcode(id,areaid,zip,code) values(224,'140108','030000','0351');
insert into zipcode(id,areaid,zip,code) values(225,'140109','030000','0351');
insert into zipcode(id,areaid,zip,code) values(226,'140110','030000','0351');
insert into zipcode(id,areaid,zip,code) values(227,'140121','030400','0351');
insert into zipcode(id,areaid,zip,code) values(228,'140122','030100','0351');
insert into zipcode(id,areaid,zip,code) values(229,'140123','030300','0351');
insert into zipcode(id,areaid,zip,code) values(230,'140181','030200','0351');
insert into zipcode(id,areaid,zip,code) values(231,'140201','037000','0352');
insert into zipcode(id,areaid,zip,code) values(232,'140202','037000','0352');
insert into zipcode(id,areaid,zip,code) values(233,'140203','037000','0352');
insert into zipcode(id,areaid,zip,code) values(234,'140211','037000','0352');
insert into zipcode(id,areaid,zip,code) values(235,'140212','037000','0352');
insert into zipcode(id,areaid,zip,code) values(236,'140221','038100','0352');
insert into zipcode(id,areaid,zip,code) values(237,'140222','038200','0352');
insert into zipcode(id,areaid,zip,code) values(238,'140223','037500','0352');
insert into zipcode(id,areaid,zip,code) values(239,'140224','034400','0352');
insert into zipcode(id,areaid,zip,code) values(240,'140225','037400','0352');
insert into zipcode(id,areaid,zip,code) values(241,'140226','037100','0352');
insert into zipcode(id,areaid,zip,code) values(242,'140227','037300','0352');
insert into zipcode(id,areaid,zip,code) values(243,'140301','045000','0353');
insert into zipcode(id,areaid,zip,code) values(244,'140302','045000','0353');
insert into zipcode(id,areaid,zip,code) values(245,'140303','045000','0353');
insert into zipcode(id,areaid,zip,code) values(246,'140311','045000','0353');
insert into zipcode(id,areaid,zip,code) values(247,'140321','045200','0353');
insert into zipcode(id,areaid,zip,code) values(248,'140322','045100','0353');
insert into zipcode(id,areaid,zip,code) values(249,'140401','046000','0355');
insert into zipcode(id,areaid,zip,code) values(250,'140402','046000','0355');
insert into zipcode(id,areaid,zip,code) values(251,'140411','046000','0355');
insert into zipcode(id,areaid,zip,code) values(252,'140421','046000','0355');
insert into zipcode(id,areaid,zip,code) values(253,'140423','046200','0355');
insert into zipcode(id,areaid,zip,code) values(254,'140424','046100','0355');
insert into zipcode(id,areaid,zip,code) values(255,'140425','047400','0355');
insert into zipcode(id,areaid,zip,code) values(256,'140426','047600','0355');
insert into zipcode(id,areaid,zip,code) values(257,'140427','047300','0355');
insert into zipcode(id,areaid,zip,code) values(258,'140428','046600','0355');
insert into zipcode(id,areaid,zip,code) values(259,'140429','046300','0355');
insert into zipcode(id,areaid,zip,code) values(260,'140430','046400','0355');
insert into zipcode(id,areaid,zip,code) values(261,'140431','046500','0355');
insert into zipcode(id,areaid,zip,code) values(262,'140481','047500','0355');
insert into zipcode(id,areaid,zip,code) values(263,'140501','048000','0356');
insert into zipcode(id,areaid,zip,code) values(264,'140502','048000','0356');
insert into zipcode(id,areaid,zip,code) values(265,'140521','048200','0356');
insert into zipcode(id,areaid,zip,code) values(266,'140522','048100','0356');
insert into zipcode(id,areaid,zip,code) values(267,'140524','048300','0356');
insert into zipcode(id,areaid,zip,code) values(268,'140525','048000','0356');
insert into zipcode(id,areaid,zip,code) values(269,'140581','046700','0356');
insert into zipcode(id,areaid,zip,code) values(270,'140601','038500','0349');
insert into zipcode(id,areaid,zip,code) values(271,'140602','038500','0349');
insert into zipcode(id,areaid,zip,code) values(272,'140603','038500','0349');
insert into zipcode(id,areaid,zip,code) values(273,'140621','038400','0349');
insert into zipcode(id,areaid,zip,code) values(274,'140622','037600','0349');
insert into zipcode(id,areaid,zip,code) values(275,'140623','037200','0349');
insert into zipcode(id,areaid,zip,code) values(276,'140624','038300','0349');
insert into zipcode(id,areaid,zip,code) values(277,'140701','030600','0354');
insert into zipcode(id,areaid,zip,code) values(278,'140702','030600','0354');
insert into zipcode(id,areaid,zip,code) values(279,'140721','031800','0354');
insert into zipcode(id,areaid,zip,code) values(280,'140722','032600','0354');
insert into zipcode(id,areaid,zip,code) values(281,'140723','032700','0354');
insert into zipcode(id,areaid,zip,code) values(282,'140724','045300','0354');
insert into zipcode(id,areaid,zip,code) values(283,'140725','031700','0354');
insert into zipcode(id,areaid,zip,code) values(284,'140726','030800','0354');
insert into zipcode(id,areaid,zip,code) values(285,'140727','030900','0354');
insert into zipcode(id,areaid,zip,code) values(286,'140728','031100','0354');
insert into zipcode(id,areaid,zip,code) values(287,'140729','031300','0354');
insert into zipcode(id,areaid,zip,code) values(288,'140781','031200','0354');
insert into zipcode(id,areaid,zip,code) values(289,'140801','044000','0359');
insert into zipcode(id,areaid,zip,code) values(290,'140802','044000','0359');
insert into zipcode(id,areaid,zip,code) values(291,'140821','044100','0359');
insert into zipcode(id,areaid,zip,code) values(292,'140822','044200','0359');
insert into zipcode(id,areaid,zip,code) values(293,'140823','043800','0359');
insert into zipcode(id,areaid,zip,code) values(294,'140824','043200','0359');
insert into zipcode(id,areaid,zip,code) values(295,'140825','043100','0359');
insert into zipcode(id,areaid,zip,code) values(296,'140826','043600','0359');
insert into zipcode(id,areaid,zip,code) values(297,'140827','043700','0359');
insert into zipcode(id,areaid,zip,code) values(298,'140828','044400','0359');
insert into zipcode(id,areaid,zip,code) values(299,'140829','044300','0359');
insert into zipcode(id,areaid,zip,code) values(300,'140830','044600','0359');
insert into zipcode(id,areaid,zip,code) values(301,'140881','044500','0359');
insert into zipcode(id,areaid,zip,code) values(302,'140882','043300','0359');
insert into zipcode(id,areaid,zip,code) values(303,'140901','034000','0350');
insert into zipcode(id,areaid,zip,code) values(304,'140902','034000','0350');
insert into zipcode(id,areaid,zip,code) values(305,'140921','035400','0350');
insert into zipcode(id,areaid,zip,code) values(306,'140922','035500','0350');
insert into zipcode(id,areaid,zip,code) values(307,'140923','034200','0350');
insert into zipcode(id,areaid,zip,code) values(308,'140924','034300','0350');
insert into zipcode(id,areaid,zip,code) values(309,'140925','036000','0350');
insert into zipcode(id,areaid,zip,code) values(310,'140926','035100','0350');
insert into zipcode(id,areaid,zip,code) values(311,'140927','036100','0350');
insert into zipcode(id,areaid,zip,code) values(312,'140928','036200','0350');
insert into zipcode(id,areaid,zip,code) values(313,'140929','036300','0350');
insert into zipcode(id,areaid,zip,code) values(314,'140930','036500','0350');
insert into zipcode(id,areaid,zip,code) values(315,'140931','036600','0350');
insert into zipcode(id,areaid,zip,code) values(316,'140932','036400','0350');
insert into zipcode(id,areaid,zip,code) values(317,'140981','034100','0350');
insert into zipcode(id,areaid,zip,code) values(318,'141001','041000','0350');
insert into zipcode(id,areaid,zip,code) values(319,'141002','041000','0357');
insert into zipcode(id,areaid,zip,code) values(320,'141021','043400','0357');
insert into zipcode(id,areaid,zip,code) values(321,'141022','043500','0357');
insert into zipcode(id,areaid,zip,code) values(322,'141023','041500','0357');
insert into zipcode(id,areaid,zip,code) values(323,'141024','031600','0357');
insert into zipcode(id,areaid,zip,code) values(324,'141025','042400','0357');
insert into zipcode(id,areaid,zip,code) values(325,'141026','042500','0357');
insert into zipcode(id,areaid,zip,code) values(326,'141027','042600','0357');
insert into zipcode(id,areaid,zip,code) values(327,'141028','042200','0357');
insert into zipcode(id,areaid,zip,code) values(328,'141029','042100','0357');
insert into zipcode(id,areaid,zip,code) values(329,'141030','042300','0357');
insert into zipcode(id,areaid,zip,code) values(330,'141031','041300','0357');
insert into zipcode(id,areaid,zip,code) values(331,'141032','041400','0357');
insert into zipcode(id,areaid,zip,code) values(332,'141033','041200','0357');
insert into zipcode(id,areaid,zip,code) values(333,'141034','031500','0357');
insert into zipcode(id,areaid,zip,code) values(334,'141081','043000','0357');
insert into zipcode(id,areaid,zip,code) values(335,'141082','031400','0357');
insert into zipcode(id,areaid,zip,code) values(336,'141101','033000','0358');
insert into zipcode(id,areaid,zip,code) values(337,'141102','033000','0358');
insert into zipcode(id,areaid,zip,code) values(338,'141121','032100','0358');
insert into zipcode(id,areaid,zip,code) values(339,'141122','030500','0358');
insert into zipcode(id,areaid,zip,code) values(340,'141123','035300','0358');
insert into zipcode(id,areaid,zip,code) values(341,'141124','033200','0358');
insert into zipcode(id,areaid,zip,code) values(342,'141125','033300','0358');
insert into zipcode(id,areaid,zip,code) values(343,'141126','032500','0358');
insert into zipcode(id,areaid,zip,code) values(344,'141127','035200','0358');
insert into zipcode(id,areaid,zip,code) values(345,'141128','033100','0358');
insert into zipcode(id,areaid,zip,code) values(346,'141129','033400','0358');
insert into zipcode(id,areaid,zip,code) values(347,'141130','032400','0358');
insert into zipcode(id,areaid,zip,code) values(348,'141181','032300','0358');
insert into zipcode(id,areaid,zip,code) values(349,'141182','032200','0358');
insert into zipcode(id,areaid,zip,code) values(350,'150101','010000','0471');
insert into zipcode(id,areaid,zip,code) values(351,'150102','010000','0471');
insert into zipcode(id,areaid,zip,code) values(352,'150103','010000','0471');
insert into zipcode(id,areaid,zip,code) values(353,'150104','010000','0471');
insert into zipcode(id,areaid,zip,code) values(354,'150105','010000','0471');
insert into zipcode(id,areaid,zip,code) values(355,'150121','010100','0471');
insert into zipcode(id,areaid,zip,code) values(356,'150122','010200','0471');
insert into zipcode(id,areaid,zip,code) values(357,'150123','011500','0471');
insert into zipcode(id,areaid,zip,code) values(358,'150124','011600','0471');
insert into zipcode(id,areaid,zip,code) values(359,'150125','011700','0471');
insert into zipcode(id,areaid,zip,code) values(360,'150201','014000','0472');
insert into zipcode(id,areaid,zip,code) values(361,'150202','014000','0472');
insert into zipcode(id,areaid,zip,code) values(362,'150203','014000','0472');
insert into zipcode(id,areaid,zip,code) values(363,'150204','014000','0472');
insert into zipcode(id,areaid,zip,code) values(364,'150205','014000','0472');
insert into zipcode(id,areaid,zip,code) values(365,'150206','014000','0472');
insert into zipcode(id,areaid,zip,code) values(366,'150207','014000','0472');
insert into zipcode(id,areaid,zip,code) values(367,'150221','014100','0472');
insert into zipcode(id,areaid,zip,code) values(368,'150222','014200','0472');
insert into zipcode(id,areaid,zip,code) values(369,'150223','014500','0472');
insert into zipcode(id,areaid,zip,code) values(370,'150301','016000','0473');
insert into zipcode(id,areaid,zip,code) values(371,'150302','016000','0473');
insert into zipcode(id,areaid,zip,code) values(372,'150303','016000','0473');
insert into zipcode(id,areaid,zip,code) values(373,'150304','016000','0473');
insert into zipcode(id,areaid,zip,code) values(374,'150401','024000','0476');
insert into zipcode(id,areaid,zip,code) values(375,'150402','024000','0476');
insert into zipcode(id,areaid,zip,code) values(376,'150403','024000','0476');
insert into zipcode(id,areaid,zip,code) values(377,'150404','024000','0476');
insert into zipcode(id,areaid,zip,code) values(378,'150421','025500','0476');
insert into zipcode(id,areaid,zip,code) values(379,'150422','025450','0476');
insert into zipcode(id,areaid,zip,code) values(380,'150423','025150','0476');
insert into zipcode(id,areaid,zip,code) values(381,'150424','025250','0476');
insert into zipcode(id,areaid,zip,code) values(382,'150425','025350','0476');
insert into zipcode(id,areaid,zip,code) values(383,'150426','024500','0476');
insert into zipcode(id,areaid,zip,code) values(384,'150428','024400','0476');
insert into zipcode(id,areaid,zip,code) values(385,'150429','024200','0476');
insert into zipcode(id,areaid,zip,code) values(386,'150430','024300','0476');
insert into zipcode(id,areaid,zip,code) values(387,'150501','028000','0475');
insert into zipcode(id,areaid,zip,code) values(388,'150502','028000','0475');
insert into zipcode(id,areaid,zip,code) values(389,'150521','029300','0475');
insert into zipcode(id,areaid,zip,code) values(390,'150522','028100','0475');
insert into zipcode(id,areaid,zip,code) values(391,'150523','028400','0475');
insert into zipcode(id,areaid,zip,code) values(392,'150524','028200','0475');
insert into zipcode(id,areaid,zip,code) values(393,'150525','028300','0475');
insert into zipcode(id,areaid,zip,code) values(394,'150526','029100','0475');
insert into zipcode(id,areaid,zip,code) values(395,'150581','029200','0475');
insert into zipcode(id,areaid,zip,code) values(396,'150602','017000','0477');
insert into zipcode(id,areaid,zip,code) values(397,'150621','017000','0477');
insert into zipcode(id,areaid,zip,code) values(398,'150622','017100','0477');
insert into zipcode(id,areaid,zip,code) values(399,'150623','016200','0477');
insert into zipcode(id,areaid,zip,code) values(400,'150624','016100','0477');
insert into zipcode(id,areaid,zip,code) values(401,'150625','017400','0477');
insert into zipcode(id,areaid,zip,code) values(402,'150626','017300','0477');
insert into zipcode(id,areaid,zip,code) values(403,'150627','017200','0477');
insert into zipcode(id,areaid,zip,code) values(404,'150701','021000','0470');
insert into zipcode(id,areaid,zip,code) values(405,'150702','021000','0470');
insert into zipcode(id,areaid,zip,code) values(406,'150721','162750','0470');
insert into zipcode(id,areaid,zip,code) values(407,'150722','162850','0470');
insert into zipcode(id,areaid,zip,code) values(408,'150723','022450','0470');
insert into zipcode(id,areaid,zip,code) values(409,'150724','021100','0470');
insert into zipcode(id,areaid,zip,code) values(410,'150725','021500','0470');
insert into zipcode(id,areaid,zip,code) values(411,'150726','021200','0470');
insert into zipcode(id,areaid,zip,code) values(412,'150727','021300','0470');
insert into zipcode(id,areaid,zip,code) values(413,'150781','021400','0470');
insert into zipcode(id,areaid,zip,code) values(414,'150782','022150','0470');
insert into zipcode(id,areaid,zip,code) values(415,'150783','162650','0470');
insert into zipcode(id,areaid,zip,code) values(416,'150784','022250','0470');
insert into zipcode(id,areaid,zip,code) values(417,'150785','022350','0470');
insert into zipcode(id,areaid,zip,code) values(418,'150801','015000','0478');
insert into zipcode(id,areaid,zip,code) values(419,'150802','015000','0478');
insert into zipcode(id,areaid,zip,code) values(420,'150821','015100','0478');
insert into zipcode(id,areaid,zip,code) values(421,'150822','015200','0478');
insert into zipcode(id,areaid,zip,code) values(422,'150823','014400','0478');
insert into zipcode(id,areaid,zip,code) values(423,'150824','015300','0478');
insert into zipcode(id,areaid,zip,code) values(424,'150825','015500','0478');
insert into zipcode(id,areaid,zip,code) values(425,'150826','015400','0478');
insert into zipcode(id,areaid,zip,code) values(426,'150901','012000','0474');
insert into zipcode(id,areaid,zip,code) values(427,'150902','012000','0474');
insert into zipcode(id,areaid,zip,code) values(428,'150921','012300','0474');
insert into zipcode(id,areaid,zip,code) values(429,'150922','013350','0474');
insert into zipcode(id,areaid,zip,code) values(430,'150923','013400','0474');
insert into zipcode(id,areaid,zip,code) values(431,'150924','013650','0474');
insert into zipcode(id,areaid,zip,code) values(432,'150925','013750','0474');
insert into zipcode(id,areaid,zip,code) values(433,'150926','012200','0474');
insert into zipcode(id,areaid,zip,code) values(434,'150927','013500','0474');
insert into zipcode(id,areaid,zip,code) values(435,'150928','012400','0474');
insert into zipcode(id,areaid,zip,code) values(436,'150929','011800','0474');
insert into zipcode(id,areaid,zip,code) values(437,'150981','012100','0474');
insert into zipcode(id,areaid,zip,code) values(438,'152201','137400','0482');
insert into zipcode(id,areaid,zip,code) values(439,'152202','137400','0482');
insert into zipcode(id,areaid,zip,code) values(440,'152221','137400','0482');
insert into zipcode(id,areaid,zip,code) values(441,'152222','029400','0482');
insert into zipcode(id,areaid,zip,code) values(442,'152223','137600','0482');
insert into zipcode(id,areaid,zip,code) values(443,'152224','137500','0482');
insert into zipcode(id,areaid,zip,code) values(444,'152501','012600','0479');
insert into zipcode(id,areaid,zip,code) values(445,'152502','026000','0479');
insert into zipcode(id,areaid,zip,code) values(446,'152522','011400','0479');
insert into zipcode(id,areaid,zip,code) values(447,'152523','011300','0479');
insert into zipcode(id,areaid,zip,code) values(448,'152524','011200','0479');
insert into zipcode(id,areaid,zip,code) values(449,'152525','026300','0479');
insert into zipcode(id,areaid,zip,code) values(450,'152526','026200','0479');
insert into zipcode(id,areaid,zip,code) values(451,'152527','027000','0479');
insert into zipcode(id,areaid,zip,code) values(452,'152528','013250','0479');
insert into zipcode(id,areaid,zip,code) values(453,'152529','013800','0479');
insert into zipcode(id,areaid,zip,code) values(454,'152530','027200','0479');
insert into zipcode(id,areaid,zip,code) values(455,'152531','027300','0479');
insert into zipcode(id,areaid,zip,code) values(456,'152921','750300','0483');
insert into zipcode(id,areaid,zip,code) values(457,'152922','737300','0483');
insert into zipcode(id,areaid,zip,code) values(458,'152923','735400','0483');
insert into zipcode(id,areaid,zip,code) values(459,'210101','110000','024');
insert into zipcode(id,areaid,zip,code) values(460,'210102','110000','024');
insert into zipcode(id,areaid,zip,code) values(461,'210103','110000','024');
insert into zipcode(id,areaid,zip,code) values(462,'210104','110000','024');
insert into zipcode(id,areaid,zip,code) values(463,'210105','110000','024');
insert into zipcode(id,areaid,zip,code) values(464,'210106','110020','024');
insert into zipcode(id,areaid,zip,code) values(465,'210111','110100','024');
insert into zipcode(id,areaid,zip,code) values(466,'210112','110000','024');
insert into zipcode(id,areaid,zip,code) values(467,'210113','110000','024');
insert into zipcode(id,areaid,zip,code) values(468,'210114','110000','024');
insert into zipcode(id,areaid,zip,code) values(469,'210122','110200','024');
insert into zipcode(id,areaid,zip,code) values(470,'210123','110500','024');
insert into zipcode(id,areaid,zip,code) values(471,'210124','110400','024');
insert into zipcode(id,areaid,zip,code) values(472,'210181','110300','024');
insert into zipcode(id,areaid,zip,code) values(473,'210201','116000','0411');
insert into zipcode(id,areaid,zip,code) values(474,'210202','116000','0411');
insert into zipcode(id,areaid,zip,code) values(475,'210203','116000','0411');
insert into zipcode(id,areaid,zip,code) values(476,'210204','116000','0411');
insert into zipcode(id,areaid,zip,code) values(477,'210211','116000','0411');
insert into zipcode(id,areaid,zip,code) values(478,'210212','116000','0411');
insert into zipcode(id,areaid,zip,code) values(479,'210213','116000','0411');
insert into zipcode(id,areaid,zip,code) values(480,'210224','116500','0411');
insert into zipcode(id,areaid,zip,code) values(481,'210281','116300','0411');
insert into zipcode(id,areaid,zip,code) values(482,'210282','116200','0411');
insert into zipcode(id,areaid,zip,code) values(483,'210283','116400','0411');
insert into zipcode(id,areaid,zip,code) values(484,'210301','114000','0412');
insert into zipcode(id,areaid,zip,code) values(485,'210302','114000','0412');
insert into zipcode(id,areaid,zip,code) values(486,'210303','114000','0412');
insert into zipcode(id,areaid,zip,code) values(487,'210304','114000','0412');
insert into zipcode(id,areaid,zip,code) values(488,'210311','114000','0412');
insert into zipcode(id,areaid,zip,code) values(489,'210321','114100','0412');
insert into zipcode(id,areaid,zip,code) values(490,'210323','118400','0412');
insert into zipcode(id,areaid,zip,code) values(491,'210381','114200','0412');
insert into zipcode(id,areaid,zip,code) values(492,'210401','113000','0413');
insert into zipcode(id,areaid,zip,code) values(493,'210402','113000','0413');
insert into zipcode(id,areaid,zip,code) values(494,'210403','113000','0413');
insert into zipcode(id,areaid,zip,code) values(495,'210404','113000','0413');
insert into zipcode(id,areaid,zip,code) values(496,'210411','113000','0413');
insert into zipcode(id,areaid,zip,code) values(497,'210421','113100','0413');
insert into zipcode(id,areaid,zip,code) values(498,'210422','113200','0413');
insert into zipcode(id,areaid,zip,code) values(499,'210423','113300','0413');
insert into zipcode(id,areaid,zip,code) values(500,'210501','117000','0414');
insert into zipcode(id,areaid,zip,code) values(501,'210502','117000','0414');
insert into zipcode(id,areaid,zip,code) values(502,'210503','117000','0414');
insert into zipcode(id,areaid,zip,code) values(503,'210504','117000','0414');
insert into zipcode(id,areaid,zip,code) values(504,'210505','117000','0414');
insert into zipcode(id,areaid,zip,code) values(505,'210521','117100','0414');
insert into zipcode(id,areaid,zip,code) values(506,'210522','117200','0414');
insert into zipcode(id,areaid,zip,code) values(507,'210601','118000','0415');
insert into zipcode(id,areaid,zip,code) values(508,'210602','118000','0415');
insert into zipcode(id,areaid,zip,code) values(509,'210603','118000','0415');
insert into zipcode(id,areaid,zip,code) values(510,'210604','118000','0415');
insert into zipcode(id,areaid,zip,code) values(511,'210624','118200','0415');
insert into zipcode(id,areaid,zip,code) values(512,'210681','118300','0415');
insert into zipcode(id,areaid,zip,code) values(513,'210682','118100','0415');
insert into zipcode(id,areaid,zip,code) values(514,'210701','121000','0416');
insert into zipcode(id,areaid,zip,code) values(515,'210702','121000','0416');
insert into zipcode(id,areaid,zip,code) values(516,'210703','121000','0416');
insert into zipcode(id,areaid,zip,code) values(517,'210711','121000','0416');
insert into zipcode(id,areaid,zip,code) values(518,'210726','121400','0416');
insert into zipcode(id,areaid,zip,code) values(519,'210727','121100','0416');
insert into zipcode(id,areaid,zip,code) values(520,'210781','121200','0416');
insert into zipcode(id,areaid,zip,code) values(521,'210782','121300','0416');
insert into zipcode(id,areaid,zip,code) values(522,'210801','115000','0417');
insert into zipcode(id,areaid,zip,code) values(523,'210802','115000','0417');
insert into zipcode(id,areaid,zip,code) values(524,'210803','115000','0417');
insert into zipcode(id,areaid,zip,code) values(525,'210804','115000','0417');
insert into zipcode(id,areaid,zip,code) values(526,'210811','115000','0417');
insert into zipcode(id,areaid,zip,code) values(527,'210881','115200','0417');
insert into zipcode(id,areaid,zip,code) values(528,'210882','115100','0417');
insert into zipcode(id,areaid,zip,code) values(529,'210901','123000','0418');
insert into zipcode(id,areaid,zip,code) values(530,'210902','123000','0418');
insert into zipcode(id,areaid,zip,code) values(531,'210903','123000','0418');
insert into zipcode(id,areaid,zip,code) values(532,'210904','123000','0418');
insert into zipcode(id,areaid,zip,code) values(533,'210905','123000','0418');
insert into zipcode(id,areaid,zip,code) values(534,'210911','123000','0418');
insert into zipcode(id,areaid,zip,code) values(535,'210921','123100','0418');
insert into zipcode(id,areaid,zip,code) values(536,'210922','123200','0418');
insert into zipcode(id,areaid,zip,code) values(537,'211001','111000','0419');
insert into zipcode(id,areaid,zip,code) values(538,'211002','111000','0419');
insert into zipcode(id,areaid,zip,code) values(539,'211003','111000','0419');
insert into zipcode(id,areaid,zip,code) values(540,'211004','111000','0419');
insert into zipcode(id,areaid,zip,code) values(541,'211005','111000','0419');
insert into zipcode(id,areaid,zip,code) values(542,'211011','111000','0419');
insert into zipcode(id,areaid,zip,code) values(543,'211021','111200','0419');
insert into zipcode(id,areaid,zip,code) values(544,'211081','111300','0419');
insert into zipcode(id,areaid,zip,code) values(545,'211101','124000','0427');
insert into zipcode(id,areaid,zip,code) values(546,'211102','124000','0427');
insert into zipcode(id,areaid,zip,code) values(547,'211103','124000','0427');
insert into zipcode(id,areaid,zip,code) values(548,'211121','124200','0427');
insert into zipcode(id,areaid,zip,code) values(549,'211122','124100','0427');
insert into zipcode(id,areaid,zip,code) values(550,'211201','112000','0410');
insert into zipcode(id,areaid,zip,code) values(551,'211202','112000','0410');
insert into zipcode(id,areaid,zip,code) values(552,'211204','112000','0410');
insert into zipcode(id,areaid,zip,code) values(553,'211221','112600','0410');
insert into zipcode(id,areaid,zip,code) values(554,'211223','112400','0410');
insert into zipcode(id,areaid,zip,code) values(555,'211224','112500','0410');
insert into zipcode(id,areaid,zip,code) values(556,'211281','112700','0410');
insert into zipcode(id,areaid,zip,code) values(557,'211282','112300','0410');
insert into zipcode(id,areaid,zip,code) values(558,'211301','122000','0421');
insert into zipcode(id,areaid,zip,code) values(559,'211302','122000','0421');
insert into zipcode(id,areaid,zip,code) values(560,'211303','122000','0421');
insert into zipcode(id,areaid,zip,code) values(561,'211321','122000','0421');
insert into zipcode(id,areaid,zip,code) values(562,'211322','122400','0421');
insert into zipcode(id,areaid,zip,code) values(563,'211324','122300','0421');
insert into zipcode(id,areaid,zip,code) values(564,'211381','122100','0421');
insert into zipcode(id,areaid,zip,code) values(565,'211382','122500','0421');
insert into zipcode(id,areaid,zip,code) values(566,'211401','125000','0429');
insert into zipcode(id,areaid,zip,code) values(567,'211402','125000','0429');
insert into zipcode(id,areaid,zip,code) values(568,'211403','125000','0429');
insert into zipcode(id,areaid,zip,code) values(569,'211404','125000','0429');
insert into zipcode(id,areaid,zip,code) values(570,'211421','125200','0429');
insert into zipcode(id,areaid,zip,code) values(571,'211422','125300','0429');
insert into zipcode(id,areaid,zip,code) values(572,'211481','125100','0429');
insert into zipcode(id,areaid,zip,code) values(573,'220101','130000','0431');
insert into zipcode(id,areaid,zip,code) values(574,'220102','130000','0431');
insert into zipcode(id,areaid,zip,code) values(575,'220103','130000','0431');
insert into zipcode(id,areaid,zip,code) values(576,'220104','130000','0431');
insert into zipcode(id,areaid,zip,code) values(577,'220105','130000','0431');
insert into zipcode(id,areaid,zip,code) values(578,'220106','130000','0431');
insert into zipcode(id,areaid,zip,code) values(579,'220112','130600','0431');
insert into zipcode(id,areaid,zip,code) values(580,'220122','130200','0431');
insert into zipcode(id,areaid,zip,code) values(581,'220181','130500','0431');
insert into zipcode(id,areaid,zip,code) values(582,'220182','130400','0431');
insert into zipcode(id,areaid,zip,code) values(583,'220183','130300','0431');
insert into zipcode(id,areaid,zip,code) values(584,'220201','132000','0432');
insert into zipcode(id,areaid,zip,code) values(585,'220202','132000','0432');
insert into zipcode(id,areaid,zip,code) values(586,'220203','132000','0432');
insert into zipcode(id,areaid,zip,code) values(587,'220204','132000','0432');
insert into zipcode(id,areaid,zip,code) values(588,'220211','132000','0432');
insert into zipcode(id,areaid,zip,code) values(589,'220221','132100','0432');
insert into zipcode(id,areaid,zip,code) values(590,'220281','132500','0432');
insert into zipcode(id,areaid,zip,code) values(591,'220282','132400','0432');
insert into zipcode(id,areaid,zip,code) values(592,'220283','132600','0432');
insert into zipcode(id,areaid,zip,code) values(593,'220284','132300','0432');
insert into zipcode(id,areaid,zip,code) values(594,'220301','136000','0434');
insert into zipcode(id,areaid,zip,code) values(595,'220302','136000','0434');
insert into zipcode(id,areaid,zip,code) values(596,'220303','136000','0434');
insert into zipcode(id,areaid,zip,code) values(597,'220322','136500','0434');
insert into zipcode(id,areaid,zip,code) values(598,'220323','130700','0434');
insert into zipcode(id,areaid,zip,code) values(599,'220381','136100','0434');
insert into zipcode(id,areaid,zip,code) values(600,'220382','136400','0434');
insert into zipcode(id,areaid,zip,code) values(601,'220401','136200','0437');
insert into zipcode(id,areaid,zip,code) values(602,'220402','136200','0437');
insert into zipcode(id,areaid,zip,code) values(603,'220403','136200','0437');
insert into zipcode(id,areaid,zip,code) values(604,'220421','136300','0437');
insert into zipcode(id,areaid,zip,code) values(605,'220422','136600','0437');
insert into zipcode(id,areaid,zip,code) values(606,'220501','134000','0435');
insert into zipcode(id,areaid,zip,code) values(607,'220502','134000','0435');
insert into zipcode(id,areaid,zip,code) values(608,'220503','134000','0435');
insert into zipcode(id,areaid,zip,code) values(609,'220521','134100','0435');
insert into zipcode(id,areaid,zip,code) values(610,'220523','135100','0448');
insert into zipcode(id,areaid,zip,code) values(611,'220524','135300','0448');
insert into zipcode(id,areaid,zip,code) values(612,'220581','135000','0448');
insert into zipcode(id,areaid,zip,code) values(613,'220582','134200','0435');
insert into zipcode(id,areaid,zip,code) values(614,'220601','134300','0439');
insert into zipcode(id,areaid,zip,code) values(615,'220602','134300','0439');
insert into zipcode(id,areaid,zip,code) values(616,'220621','134500','0439');
insert into zipcode(id,areaid,zip,code) values(617,'220622','135200','0439');
insert into zipcode(id,areaid,zip,code) values(618,'220623','134400','0439');
insert into zipcode(id,areaid,zip,code) values(619,'220625','134700','0439');
insert into zipcode(id,areaid,zip,code) values(620,'220681','134600','0439');
insert into zipcode(id,areaid,zip,code) values(621,'220701','138000','0438');
insert into zipcode(id,areaid,zip,code) values(622,'220702','138000','0438');
insert into zipcode(id,areaid,zip,code) values(623,'220721','131100','0438');
insert into zipcode(id,areaid,zip,code) values(624,'220722','131500','0438');
insert into zipcode(id,areaid,zip,code) values(625,'220723','131400','0438');
insert into zipcode(id,areaid,zip,code) values(626,'220724','131200','0438');
insert into zipcode(id,areaid,zip,code) values(627,'220801','137000','0436');
insert into zipcode(id,areaid,zip,code) values(628,'220802','137000','0436');
insert into zipcode(id,areaid,zip,code) values(629,'220821','137300','0436');
insert into zipcode(id,areaid,zip,code) values(630,'220822','137200','0436');
insert into zipcode(id,areaid,zip,code) values(631,'220881','137100','0436');
insert