目录
本文是房产信息管理系统开发实现的表数据。
各个表的属性
表1 业主表(Owner)
字段名称 | 字段编码 | 数据类型 | 字段大小 | 必填字段 | 备注 |
身份证号 | PersonID | Char | 18 | 是 | 主键 |
姓名 | Name | Varchar | 20 | 是 | |
性别 | Gender | Char | 2 | 是 | |
职业 | Occupation | Varchar | 20 | 是 | |
身份地址 | Addr | Varchar | 50 | 是 | |
电话 | Tel | Varchar | 11 | 是 |
表2 房产表(Estate)
字段名称 | 字段编码 | 数据类型 | 字段大小 | 必填字段 | 备注 |
房产编号 | EstateID | Char | 15 | 是 | 主键 |
房产名称 | EstateName | Varchar | 50 | 是 | |
房产楼盘 | EstateBuildName | Varchar | 50 | 是 | |
房产地址 | EstateAddr | Varchar | 60 | 是 | |
房产城市 | EstateCity | Varchar | 60 | 是 | |
房产类型 | EstateType | Char | 4 | 是 | 取值范围:住宅、商铺、车位、别墅 |
产权面积 | PropertyArea | Numeric | (5,2) | 是 | |
使用面积 | UsableArea | Numeric | (5,2) | 是 | |
竣工日期 | CompletedDate | Date | 是 | ||
产权年限 | YearLength | Int | 是 | 默认值70 | |
备注 | Remark | Varchar | 100 | 否 |
表3 产权登记表(Registration)
字段名称 | 字段编码 | 数据类型 | 字段大小 | 必填字段 | 备注 |
登记编号 | RegisterID | Int | 是 | 主键 | |
身份证号 | PersonID | Char | 18 | 是 | 外键 |
房产编号 | EstateID | Char | 15 | 是 | 外键 |
购买金额 | Price | Money | 是 | ||
购买日期 | PurchasedDate | Date | 是 | ||
交付日期 | DeliverDate | Date | 是 |
业主表
INSERT INTO owner values
('32092519791217009X','李波','女','服装/纺织/皮革','湖北省楠县锡山仇路f座 281896','18606744896'),
('371721196511115646','吴鹏','男','公司业务部门经理/主管','上海市东莞县华龙香港路o座 104653','14717257158'),
('150105196407293739','陈帅','男','房地产销售与中介','湖南省秀兰县沈北新韦路L座 896034','15678816949'),
('341800198708146312','张楠','女','会务/会展主管','广西壮族自治区海燕县长寿阜新路a座 198849','14782318098'),
('210112196912222763','王坤','女','砌筑工','新疆维吾尔自治区军市门头沟魏街i座 911680','18646689031'),
('632822198110172776','李云','女','板房/楦头/底格出格师','吉林省旭县孝南汕尾街m座 595411','18074424709'),
('451402196110177138','陈丽华','女','固废工程师','浙江省关岭县江北马路d座 448448','15115874368'),
('621021199601042142','万淑珍','女','物流/仓储','河南省西安市璧山王街u座 380358','18797022345'),
('410300197803130226','李海燕','男','洗车工','福建省杭州市丰都哈尔滨路P座 302770','13926191912'),
('230230199406300699','刘桂珍','男','房地产客服','重庆市乌鲁木齐县花溪呼和浩特街z座 784216','15347405612'),
('370827200203273871','杨洋','女','服装领班','福建省荆门县友好北京路S座 328072','14704411415'),
('421222199109146863','张龙','男','教师','辽宁省佳市华龙万路G座 968574','15399257577'),
('130202200204031722','王秀荣','女','安全员','辽宁省贵阳县高明缪街a座 346072','15634661885'),
('410823193310252405','彭华','女','服装/纺织设计','江西省杰市花溪杨街r座 879025','18831191899'),
('520324196803023967','谢博','女','采购经理','青海省倩市孝南汕尾街h座 316163','18022846668'),
('500114196703015516','马晶','女','装订工','安徽省阜新县金平惠州路f座 471079','15555060598'),
('640500193507124572','孙峰','男','渠道/分销专员','四川省淑兰县华龙海口街U座 867695','15087199453'),
('522300193312169328','刘岩','女','促销主管/督导','西藏自治区福州县怀柔齐齐哈尔街o座 638696','15768884300'),
('500104194306074676','姚艳','女','网络信息安全工程师','黑龙江省哈尔滨市长寿哈尔滨街o座 264852','18915802179'),
('451424193605287480','杨志强','男','音效师','香港特别行政区玉英县牧野潮州街O座 392570','15796339165'),
('632525193806222516','袁雪梅','男','西餐厨师','内蒙古自治区秀荣市城东高街S座 740890','18536133347'),
('621121198801203802','高秀珍','女','招投标管理','香港特别行政区兴城县翔安张路W座 214972','13229746917'),
('620421195709066253','周凤英','男','行政专员/助理','山西省南京市沙市杜路b座 210544','15338611333'),
('150825196002053132','卢秀荣','女','电池/电源开发','天津市建华县永川郭街r座 821686','13827985756'),
('632323195703136688','湛玉','女','财务总监','河北省梧州市长寿唐路X座 152369','15700273600')
房产表
insert into estate values
('7048559328340','闵行 金虹桥','名都城(公寓)','闵行 金虹桥','成都','车位','139.62','139.62','1999-12-30','70',' '),
('8042336233946','长宁 中山公园','宁锦小区','长宁 中山公园','成都','商铺','31.95','31.95','1998-6-22','70',' '),
('8179626486099','长宁 仙霞','天申小区','长宁 仙霞','武汉','住宅','113.6','113.6','1971-11-1','70',' '),
('0425233068802','闵行 航华','新明星花园二期','闵行 航华','北京','别墅','128.85','128.85','1979-8-31','70',' '),
('3370134573147','长宁 中山公园','春天花园','长宁 中山公园','北京','车位','129.25','129.25','2011-9-27','70',' '),
('5920242276418','闵行 金虹桥','万源新城南区','闵行 金虹桥','深圳','商铺','53.38','53.38','1970-6-21','70',' '),
('3220716362052','徐汇 康健','康乐小区(徐汇)','徐汇 康健','深圳','别墅','45.57','45.57','2003-7-2','70',' '),
('2749679339012','青浦 赵巷','崧泽华城佳福雅苑(一区)','青浦 赵巷','深圳','住宅','56.58','56.58','1991-7-11','70',' '),
('7530559324214','长宁 古北','虹南小区','长宁 古北','北京','住宅','59.45','59.45','1988-1-25','70',' '),
('0819626927954','长宁 中山公园','上海花城','长宁 中山公园','北京','车位','133.1','133.1','1997-2-24','70',' '),
('5495107717580','徐汇 康健','康健公寓','徐汇 康健','武汉','车位','107.31','107.31','2017-8-19','70',' '),
('6032742352361','闵行 金汇','锦绣江南(一期)','闵行 金汇','北京','别墅','113.41','113.41','1991-10-8','70',' '),
('4826744238167','青浦 赵巷','崧泽华城秀景苑','青浦 赵巷','北京','商铺','68.72','68.72','2003-7-17','70',' '),
('0200196264383','青浦 赵巷','崧泽华城佳福雅苑(五区)','青浦 赵巷','上海','别墅','75.22','75.22','1981-1-23','70',' '),
('7649755764802','浦东 航头','海洲桃花园一期','浦东 航头','上海','别墅','80.58','80.58','1991-5-30','70',' '),
('0302088001922','闵行 龙柏','龙柏一村','闵行 龙柏','深圳','别墅','58.33','58.33','1988-9-28','70',' '),
('9603877706347','徐汇 康健','寿祥坊','徐汇 康健','武汉','车位','32.06','32.06','2020-3-14','70',' '),
('3539571022422','闵行 金汇','锦绣江南(一期)','闵行 金汇','北京','车位','142.5','142.5','2013-12-19','70',' '),
('5939994385204','浦东 张江','春港丽园(公寓)','浦东 张江','成都','车位','77.48','77.48','2010-12-22','70',' '),
('0670597072698','长宁 中山公园','天义小区','长宁 中山公园','成都','车位','30.85','30.85','1987-6-26','70',' '),
('7657377455593','青浦 赵巷','昱秀欣苑','青浦 赵巷','武汉','车位','79.9','79.9','1989-3-26','70',' '),
('0534637617382','徐汇 康健','欣园新邨','徐汇 康健','深圳','住宅','65.52','65.52','1999-10-10','70',' '),
('9442026387458','浦东 川沙','黄楼花苑','浦东 川沙','北京','车位','76.47','76.47','1986-9-4','70',' '),
('2541025083519','浦东 周浦','瑞阳苑','浦东 周浦','成都','车位','75.13','75.13','1984-12-4','70',' '),
('1247653728722','奉贤 奉贤金汇','天和尚上海','奉贤 奉贤金汇','北京','车位','90.0','90.0','2000-3-12','70',' '),
('3674881547417','浦东 北蔡','艾东小区','浦东 北蔡','上海','商铺','44.01','44.01','2017-7-3','70',' '),
('6653430697705','静安 闸北公园','和玉苑','静安 闸北公园','北京','住宅','98.48','98.48','1981-9-21','70',' '),
('5114124185781','徐汇 田林','田林体育公寓','徐汇 田林','深圳','别墅','87.1','87.1','2014-5-11','70',' '),
('8837775748631','闵行 金虹桥','奥森公寓','闵行 金虹桥','上海','别墅','94.16','94.16','1998-3-15','70',' '),
('4047297649660','普陀 长寿路','云都苑','普陀 长寿路','武汉','别墅','93.58','93.58','2020-4-2','70',' '),
('4683358822010','武侯 五大花园','会所金澜苑','武侯 五大花园','北京','别墅','87.19','87.19','1999-1-23','70',' '),
('4426423111293','温江 温江大学城','水韵尚城','温江 温江大学城','深圳','住宅','214.19','214.19','1990-8-10','70',' '),
('0329284951753','温江 国色天乡','鹭湖宫五号社区','温江 国色天乡','成都','商铺','142.4','142.4','1990-4-5','70',' '),
('4708368422905','温江 温江老城','华丽花园','温江 温江老城','上海','商铺','169.16','169.16','2019-9-16','70',' '),
('7318014459326','高新 新北','美洲花园二期','高新 新北','成都','商铺','117.74','117.74','1975-9-26','70',' '),
('3826510725518','锦江 合江亭','锦江印象','锦江 合江亭','成都','别墅','97.62','97.62','2013-11-3','70',' '),
('5544204379480','锦江 合江亭','时代豪庭三期','锦江 合江亭','深圳','住宅','173.86','173.86','1999-5-11','70',' '),
('3222195010334','龙泉驿 航天','富丽苑二期','龙泉驿 航天','上海','别墅','95.95','95.95','2010-10-25','70',' '),
('3110966299542','龙泉驿 大面','凯德卓锦万黛','龙泉驿 大面','深圳','别墅','89.72','89.72','2012-4-7','70',' '),
('5219775297630','金牛 高家庄','华宇西城雅郡','金牛 高家庄','成都','商铺','77.0','77.0','1994-3-16','70',' '),
('6710840105406','郫都 犀浦','朗基少帅府','郫都 犀浦','上海','别墅','82.5','82.5','2001-4-7','70',' '),
('7639300274367','郫都 郫县万达','滨河花园(郫都)','郫都 郫县万达','北京','别墅','132.95','132.95','2012-7-19','70',' '),
('5937518064115','高新 远大','嘉年华国际社区','高新 远大','上海','车位','153.99','153.99','2017-12-24','70',' '),
('4428309591402','新都 大丰','北新国际广场','新都 大丰','上海','车位','88.03','88.03','1990-5-1','70',' '),
('5566436313664','高新 大源','嘉祥瑞庭南城','高新 大源','上海','车位','86.62','86.62','1996-9-4','70',' '),
('6752232140550','青羊 金沙','蓝光凯丽美域','青羊 金沙','武汉','车位','119.38','119.38','2018-5-8','70',' '),
('5248076445420','成华 猛追湾','西南电力设计院小区','成华 猛追湾','上海','车位','88.92','88.92','1985-2-15','70',' '),
('6819409374951','新都 大丰','保利城二期','新都 大丰','武汉','商铺','91.15','91.15','1998-8-18','70',' '),
('7800103329275','温江 光华大道沿线','春天大道','温江 光华大道沿线','武汉','住宅','134.91','134.91','2023-2-5','70',' '),
('4941941722239','龙泉驿 大面','恒大绿洲','龙泉驿 大面','深圳','别墅','106.16','106.16','2008-7-20','70',' '),
('1468706435835','龙泉驿 大面','世茂城三期','龙泉驿 大面','上海','别墅','84.24','84.24','2009-11-8','70',' '),
('3267064130771','双流 蛟龙港','景茂名都','双流 蛟龙港','北京','车位','110.99','110.99','1991-3-12','70',' '),
('3833816793419','天府新区 华阳','左岸花都','天府新区 华阳','武汉','车位','140.58','140.58','1980-11-4','70',' '),
('3922633689357','龙泉驿 龙泉驿城区','富力山水人家','龙泉驿 龙泉驿城区','武汉','车位','127.82','127.82','1994-1-5','70',' '),
('9772539583990','双流 东升镇','西安路一段142号','双流 东升镇','深圳','住宅','130.0','130.0','1991-3-8','70',' '),
('1094517347712','双流 蛟龙港','万科第五城','双流 蛟龙港','成都','别墅','116.98','116.98','1989-8-26','70',' '),
('8857258232155','青羊 万家湾','清溪雅筑','青羊 万家湾','深圳','别墅','89.73','89.73','2000-4-2','70',' '),
('0846646312494','锦江 东湖','翡翠城五期','锦江 东湖','北京','商铺','120.42','120.42','2002-7-14','70',' '),
('0566786708720','青羊 万家湾','恒大翡翠华庭','青羊 万家湾','北京','别墅','85.81','85.81','1991-4-26','70',' '),
('7735814020932','天府新区 南湖','中海锦江城云熙二期','天府新区 南湖','武汉','商铺','94.8','94.8','1997-1-9','70',' '),
('0876120469844','通州 九棵树(家乐福)','龙湖蔚澜香醍','通州 九棵树(家乐福)','武汉','住宅','144.08','144.08','1994-7-30','70',' '),
('9026463364336','通州 通州北苑','世纪星城','通州 通州北苑','上海','商铺','92.2','92.2','2019-9-27','70',' '),
('9277961077677','朝阳 太阳宫','太阳公元北区','朝阳 太阳宫','成都','别墅','162.52','162.52','1988-5-27','70',' '),
('4817565640687','朝阳 双井','百环家园','朝阳 双井','上海','别墅','139.67','139.67','1972-12-2','70',' '),
('2393807790278','昌平 回龙观','风雅园三区','昌平 回龙观','武汉','车位','155.88','155.88','1987-11-1','70',' '),
('7416032975134','西城 牛街','南线阁41号院','西城 牛街','武汉','商铺','107.63','107.63','1986-8-29','70',' '),
('0520754967896','朝阳 劲松','农光里','朝阳 劲松','成都','住宅','110.7','110.7','2021-2-8','70',' '),
('2267199835097','房山 长阳','五矿名品','房山 长阳','北京','车位','137.77','137.77','2006-7-9','70',' '),
('2387422007134','大兴 亦庄开发区其它','北京城建海梓府','大兴 亦庄开发区其它','上海','别墅','280.73','280.73','2000-6-6','70',' '),
('4833038097012','昌平 天通苑','天通苑东一区','昌平 天通苑','武汉','商铺','176.83','176.83','2007-5-3','70',' '),
('0252041807538','海淀 西三旗','新康园','海淀 西三旗','北京','别墅','85.83','85.83','2015-6-23','70',' '),
('4650331834665','东城 和平里','和平里五区','东城 和平里','深圳','商铺','92.68','92.68','2004-5-12','70',' '),
('0092573970557','朝阳 常营','万象新天二区','朝阳 常营','成都','商铺','165.56','165.56','1995-5-14','70',' '),
('7248639767142','密云 密云镇','城建上河湾北区','密云 密云镇','武汉','别墅','90.54','90.54','1970-4-13','70',' '),
('6453419209749','通州 武夷花园','京贸国际城','通州 武夷花园','成都','商铺','138.08','138.08','2007-11-8','70',' '),
('9816724336722','朝阳 酒仙桥','阳光上东','朝阳 酒仙桥','北京','别墅','180.55','180.55','1994-2-4','70',' '),
('2081734423526','昌平 天通苑','天通苑北三区','昌平 天通苑','成都','别墅','126.35','126.35','2009-4-17','70',' '),
('1676728133851','朝阳 安贞','国典华园','朝阳 安贞','上海','住宅','139.55','139.55','1986-3-17','70',' '),
('2402059879715','海淀 玉泉路','玉海园五里','海淀 玉泉路','深圳','别墅','79.61','79.61','1999-2-20','70',' '),
('1725081793302','东城 安贞','安外大街','东城 安贞','北京','车位','61.11','61.11','1982-5-2','70',' '),
('1937129552452','房山 长阳','天资华府','房山 长阳','武汉','商铺','94.19','94.19','2014-12-25','70',' '),
('3447082818592','东城 朝阳门外','潘家坡胡同4号院','东城 朝阳门外','北京','别墅','43.63','43.63','1979-5-13','70',' '),
('0637173071376','石景山 苹果园','西山枫林一二期','石景山 苹果园','上海','别墅','97.65','97.65','2021-8-12','70',' '),
('7695179133961','房山 窦店','北京城建琨廷南区','房山 窦店','成都','车位','143.94','143.94','2008-5-26','70',' '),
('7761248843791','昌平 回龙观','流星花园三区','昌平 回龙观','武汉','商铺','140.43','140.43','1996-5-7','70',' '),
('6091645180472','大兴 高米店','翡翠城一期','大兴 高米店','北京','商铺','214.96','214.96','1984-4-10','70',' '),
('5087542889554','朝阳 望京','东湖湾三期','朝阳 望京','深圳','别墅','126.39','126.39','1986-9-25','70',' '),
('9014177502903','朝阳 定福庄','美然动力A3区','朝阳 定福庄','深圳','车位','113.53','113.53','1973-9-22','70',' '),
('9483054201829','丰台 草桥','恋日嘉园二期','丰台 草桥','北京','住宅','189.85','189.85','1970-11-26','70',' '),
('9211545927330','朝阳 常营','万象新天一区','朝阳 常营','成都','商铺','153.94','153.94','1997-9-12','70',' '),
('3741991933472','南山区 西丽','俊峰丽舍','南山区 西丽','上海','商铺','106.93','106.93','1977-1-8','70',' '),
('2034238086111','龙华区 民治','世纪春城三期','龙华区 民治','北京','住宅','108.82','108.82','1998-12-5','70',' '),
('0108985819289','福田区 梅林','梅林一村三区','福田区 梅林','上海','商铺','90.29','90.29','1989-12-18','70',' '),
('5237533110457','宝安区 西乡','金港华庭','宝安区 西乡','上海','车位','119.18','119.18','1973-2-25','70',' '),
('2212184143493','南山区 蛇口','南海玫瑰花园二期','南山区 蛇口','成都','车位','127.13','127.13','2019-10-17','70',' '),
('8457283955681','龙岗区 大运新城','海逸雅居','龙岗区 大运新城','成都','别墅','96.92','96.92','2020-12-8','70',' '),
('9946047482875','罗湖区 黄贝岭','深业东岭一期','罗湖区 黄贝岭','成都','商铺','33.5','33.5','1978-4-16','70',' '),
('8979129086848','福田区 新洲','祥云天都世纪大厦','福田区 新洲','上海','车位','56.75','56.75','1985-9-15','70',' '),
('8397399426669','宝安区 曦城','招商华侨城曦城二期','宝安区 曦城','上海','别墅','283.86','283.86','2001-2-22','70',' '),
('8754329055118','南山区 后海','信和自由广场','南山区 后海','武汉','商铺','68.06','68.06','2002-7-28','70',' '),
('0671003259833','龙华区 民治','金地梅陇镇四期','龙华区 民治','成都','别墅','47.12','47.12','2013-3-11','70',' '),
('2050560485264','罗湖区 春风路','金鼎大厦','罗湖区 春风路','北京','商铺','44.11','44.11','2014-2-15','70',' '),
('4415941940912','罗湖区 春风路','钻石时代','罗湖区 春风路','上海','车位','26.85','26.85','2007-6-23','70',' '),
('0019669731032','罗湖区 春风路','长丰苑','罗湖区 春风路','深圳','别墅','68.29','68.29','1991-6-6','70',' '),
('3220162580766','坪山区 坪山','大东城二期','坪山区 坪山','深圳','车位','86.62','86.62','1982-10-11','70',' '),
('5872649856146','龙岗区 丹竹头','左庭右院北区','龙岗区 丹竹头','成都','车位','78.66','78.66','2018-1-14','70',' '),
('5040524637676','罗湖区 翠竹','花岗石公司','罗湖区 翠竹','成都','商铺','94.37','94.37','1972-2-23','70',' '),
('7629990420285','福田区 上步','台湾花园','福田区 上步','北京','车位','109.68','109.68','1971-9-3','70',' '),
('7509274064748','福田区 石厦','皇庭世纪','福田区 石厦','成都','住宅','92.12','92.12','2012-8-4','70',' '),
('2051984168144','南山区 南山中心','阳光里雅居','南山区 南山中心','北京','住宅','65.87','65.87','1974-8-14','70',' '),
('1865704859352','盐田区 沙头角','东部翠海轩','盐田区 沙头角','武汉','车位','60.07','60.07','2014-6-22','70',' '),
('3297734445785','南山区 南山中心','向南瑞峰花园','南山区 南山中心','武汉','住宅','66.72','66.72','2004-5-30','70',' '),
('0329339279482','罗湖区 螺岭','京基东方华都','罗湖区 螺岭','成都','车位','38.96','38.96','1970-12-3','70',' '),
('2238946908772','龙岗区 横岗','信义御城豪园','龙岗区 横岗','武汉','商铺','89.37','89.37','1970-5-7','70',' '),
('5706534790282','龙岗区 坂田','信义嘉御山','龙岗区 坂田','深圳','住宅','88.75','88.75','1996-9-9','70',' '),
('0670676289597','龙岗区 布吉街','阳光花园五期','龙岗区 布吉街','成都','车位','46.37','46.37','1983-1-5','70',' '),
('7804709151036','宝安区 翻身','汇宝苑','宝安区 翻身','成都','车位','94.07','94.07','1976-11-21','70',' '),
('2698152852776','龙岗区 布吉水径','金域中央花园一期','龙岗区 布吉水径','上海','商铺','70.2','70.2','1978-1-15','70',' '),
('9937734131905','坪山区 坪山','金地朗悦','坪山区 坪山','北京','车位','89.03','89.03','2000-8-8','70',' '),
('5164238899880','南山区 科技园','大冲新城花园','南山区 科技园','上海','住宅','59.13','59.13','1999-10-1','70',' '),
('3826528318951','罗湖区 布心','今日家园','罗湖区 布心','武汉','别墅','100.83','100.83','1974-2-21','70',' '),
('8815427443918','南山区 南山中心','向南瑞峰花园','南山区 南山中心','武汉','商铺','123.39','123.39','1989-12-27','70',' '),
('7510224481111','盐田区 沙头角','碧桐海苑','盐田区 沙头角','深圳','别墅','71.04','71.04','1994-4-4','70',' '),
('0943262927062','盐田区 盐田港','幸福海','盐田区 盐田港','武汉','车位','80.82','80.82','1997-3-31','70',' '),
('1213930055407','南山区 红树湾','世纪村二期','南山区 红树湾','深圳','车位','128.82','128.82','1975-3-8','70',' '),
('9226821915542','南山区 南山中心','万象新园','南山区 南山中心','成都','商铺','103.79','103.79','2016-1-16','70',' '),
('8806404041543','宝安区 松岗','中海西岸华府北区','宝安区 松岗','上海','别墅','126.24','126.24','2018-9-16','70',' '),
('6465932377681','龙华区 梅林关','龙光玖龙玺','龙华区 梅林关','北京','别墅','137.66','137.66','2022-3-29','70',' '),
('5232514453944','南山区 蛇口','海月花园三期','南山区 蛇口','武汉','车位','209.59','209.59','1973-10-18','70',' '),
('2531347087158','南山区 南山中心','缤纷假日豪园','南山区 南山中心','成都','别墅','106.1','106.1','1992-10-27','70',' '),
('4228906014039','福田区 景田','怡枫园','福田区 景田','北京','商铺','209.26','209.26','1989-3-30','70',' '),
('9755575632768','盐田区 盐田港','佳兆业盐田城市广场','盐田区 盐田港','成都','车位','105.69','105.69','2013-7-2','70',' '),
('3505456475555','龙岗区 坂田','万科第五园三期','龙岗区 坂田','成都','别墅','145.61','145.61','2002-9-28','70',' '),
('4975164137450','龙岗区 龙岗中心城','城龙花园','龙岗区 龙岗中心城','北京','车位','105.41','105.41','2019-10-4','70',' '),
('1261185547597','龙岗区 布吉街','花语岸','龙岗区 布吉街','武汉','车位','88.63','88.63','2013-5-26','70',' '),
('9260880492429','南山区 前海','阳光棕榈园三期','南山区 前海','武汉','别墅','114.27','114.27','2000-3-1','70',' '),
('8022614939002','福田区 梅林','绿景虹湾','福田区 梅林','北京','车位','143.22','143.22','1998-2-13','70',' '),
('3764599193496','南山区 前海','星海名城二期八组团','南山区 前海','成都','商铺','106.2','106.2','1973-2-27','70',' '),
('2990329512345','龙华区 梅林关','星河丹堤','龙华区 梅林关','上海','别墅','171.33','171.33','1982-8-16','70',' '),
('4829699797020','龙岗区 龙岗中心城','吉祥里','龙岗区 龙岗中心城','北京','商铺','88.88','88.88','1992-1-31','70',' '),
('4497189118757','龙岗区 坂田','德润荣君府','龙岗区 坂田','深圳','住宅','85.78','85.78','2021-10-22','70',' '),
('0775257242352','坪山区 坪山','心海城','坪山区 坪山','成都','商铺','87.87','87.87','2011-6-28','70',' '),
('2996364228041','龙岗区 龙岗中心城','鸿进花园','龙岗区 龙岗中心城','上海','车位','97.65','97.65','1998-1-6','70',' '),
('4933618780021','坪山区 坪山','京基御景印象四期','坪山区 坪山','北京','车位','77.76','77.76','1976-5-30','70',' '),
('4141628970808','南山区 后海','南海花园别墅区','南山区 后海','上海','住宅','206.91','206.91','2009-9-9','70',' '),
('5271069103886','南山区 南头','东关乐尚林居','南山区 南头','深圳','住宅','176.64','176.64','1974-4-13','70',' '),
('9429808790738','盐田区 盐田港','金水湾御园','盐田区 盐田港','武汉','住宅','71.03','71.03','1973-11-17','70',' '),
('5556872717437','龙岗区 横岗','银信中心二期','龙岗区 横岗','武汉','商铺','143.65','143.65','2009-9-26','70',' '),
('1553918513615','南山区 前海','阳光棕榈园三期','南山区 前海','成都','车位','104.56','104.56','1998-7-26','70',' '),
('5448404805852','龙岗区 龙岗中心城','尚景欣园','龙岗区 龙岗中心城','上海','别墅','152.42','152.42','2001-10-27','70',' '),
('1808772887895','龙岗区 坂田','万科四季花城三期','龙岗区 坂田','深圳','商铺','169.24','169.24','1985-10-6','70',' '),
('3787472880117','宝安区 宝安中心','菁英趣庭','宝安区 宝安中心','成都','商铺','75.47','75.47','2019-6-18','70',' '),
('2260456499228','坪山区 坪山','深城投中心公馆','坪山区 坪山','北京','商铺','86.27','86.27','2010-1-4','70',' '),
('8518178434160','南山区 蛇口','海月花园一期','南山区 蛇口','北京','车位','108.46','108.46','1974-3-12','70',' '),
('2592627689593','福田区 梅林','文伟阁','福田区 梅林','北京','别墅','163.94','163.94','2005-7-28','70',' '),
('0348479292529','福田区 梅林','山水居','福田区 梅林','北京','车位','80.72','80.72','1989-4-26','70',' '),
('3033476317108','龙华区 红山','龙光玖钻','龙华区 红山','深圳','车位','39.7','39.7','1977-5-10','70',' '),
('8370713452825','罗湖区 翠竹','贝悦汇大厦','罗湖区 翠竹','上海','车位','30.57','30.57','1977-7-3','70',' '),
('4025916012315','南山区 南山中心','现代城华庭','南山区 南山中心','北京','别墅','105.88','105.88','1975-3-1','70',' '),
('7622056571019','龙岗区 坂田','珠江旭景佳园','龙岗区 坂田','北京','车位','106.12','106.12','1973-1-25','70',' '),
('6762064756664','龙岗区 龙岗中心城','万科天誉二期','龙岗区 龙岗中心城','深圳','车位','66.29','66.29','1983-10-8','70',' '),
('8661793266214','罗湖区 螺岭','金城华庭','罗湖区 螺岭','北京','别墅','107.36','107.36','1985-9-1','70',' '),
('2949011155118','龙华区 龙华中心','鸿荣源·壹城中心第五区','龙华区 龙华中心','武汉','车位','71.17','71.17','1978-3-8','70',' '),
('7335329648929','龙华区 龙华中心','保利悦都','龙华区 龙华中心','武汉','别墅','89.33','89.33','2010-12-29','70',' '),
('5673985605755','盐田区 沙头角','壹海城四区','盐田区 沙头角','深圳','车位','61.78','61.78','1990-9-3','70',' '),
('6659536484546','龙岗区 坪地','中骏四季阳光一期','龙岗区 坪地','成都','商铺','86.97','86.97','1985-1-10','70',' '),
('2953186367636','龙岗区 龙岗中心城','万科天誉二期','龙岗区 龙岗中心城','成都','商铺','66.39','66.39','2019-3-2','70',' '),
('1322391362356','福田区 香蜜湖','东海国际公寓','福田区 香蜜湖','深圳','车位','134.59','134.59','2007-4-15','70',' '),
('1923547693512','宝安区 福永','福永花园','宝安区 福永','深圳','车位','67.15','67.15','2015-1-27','70',' '),
('7922569231247','盐田区 沙头角','碧海蓝天名苑','盐田区 沙头角','成都','商铺','64.64','64.64','1995-7-7','70',' '),
('5964065832807','罗湖区 春风路','金源大厦','罗湖区 春风路','上海','别墅','39.93','39.93','2003-6-27','70',' '),
('1442431751215','南山区 南山中心','汉京山','南山区 南山中心','深圳','住宅','57.87','57.87','2004-11-15','70',' '),
('1251285478409','罗湖区 莲塘','东方凤雅台','罗湖区 莲塘','上海','别墅','63.75','63.75','2004-8-8','70',' '),
('5590696793650','龙岗区 龙岗中心城','中央悦城','龙岗区 龙岗中心城','武汉','商铺','163.91','163.91','1991-12-17','70',' '),
('3341496269521','罗湖区 螺岭','金城华庭','罗湖区 螺岭','深圳','车位','39.08','39.08','2004-12-29','70',' '),
('0640172588749','龙岗区 龙岗中心城','碧湖花园','龙岗区 龙岗中心城','北京','商铺','120.33','120.33','2001-11-20','70',' '),
('8675082958244','龙华区 龙华中心','鸿荣源·壹城中心第八区','龙华区 龙华中心','武汉','车位','115.15','115.15','2000-10-15','70',' '),
('3613919328866','龙岗区 龙岗中心城','宝能悦澜山花园','龙岗区 龙岗中心城','武汉','别墅','87.98','87.98','2010-3-28','70',' '),
('6145146706676','盐田区 沙头角','诗宁大厦','盐田区 沙头角','北京','别墅','91.44','91.44','2017-1-6','70',' '),
('9257199041859','坪山区 坪山','心海城','坪山区 坪山','深圳','住宅','93.55','93.55','1990-10-11','70',' '),
('6385201677001','龙岗区 横岗','名门世家','龙岗区 横岗','成都','车位','143.86','143.86','2018-12-7','70',' '),
('6086573527389','龙华区 龙华新区','风和日丽花园三期','龙华区 龙华新区','武汉','商铺','104.97','104.97','1985-11-3','70',' '),
('1924490182996','龙岗区 龙岗中心城','香林玫瑰花园','龙岗区 龙岗中心城','深圳','别墅','109.1','109.1','1992-11-15','70',' '),
('0651631000399','龙华区 龙华中心','鸿荣源·壹成中心第六区','龙华区 龙华中心','上海','住宅','88.27','88.27','2012-12-27','70',' '),
('2159605040062','龙岗区 布吉水径','中海怡翠山庄四期','龙岗区 布吉水径','北京','住宅','70.53','70.53','2015-3-19','70',' '),
('4709436585605','宝安区 新安','黄金大厦','宝安区 新安','北京','商铺','48.61','48.61','1993-9-28','70',' '),
('4369372730106','罗湖区 东门','华盛君荟名庭','罗湖区 东门','上海','商铺','88.52','88.52','1980-1-24','70',' '),
('2381870497374','罗湖区 清水河','旭飞华天苑','罗湖区 清水河','深圳','别墅','15.38','15.38','1971-3-5','70',' '),
('1779091869909','龙华区 红山','龙光玖钻','龙华区 红山','武汉','别墅','70.48','70.48','1971-11-6','70',' '),
('5010323279397','龙岗区 龙岗双龙','怡龙枫景园','龙岗区 龙岗双龙','北京','车位','88.62','88.62','1977-9-17','70',' '),
('8873299251750','龙岗区 龙岗中心城','龙岗天健郡城','龙岗区 龙岗中心城','深圳','住宅','109.44','109.44','2001-8-31','70',' '),
('3275907334023','福田区 园岭','园岭新村','福田区 园岭','上海','车位','80.83','80.83','2021-7-26','70',' '),
('9032674645600','罗湖区 罗湖口岸','庐山花园','罗湖区 罗湖口岸','上海','车位','55.17','55.17','1996-8-13','70',' '),
('8426547205999','龙华区 红山','龙光玖钻','龙华区 红山','上海','车位','39.67','39.67','2011-11-24','70',' '),
('4015820528157','龙岗区 横岗','中海大山地北区','龙岗区 横岗','深圳','别墅','89.7','89.7','1995-7-8','70',' '),
('2015893448005','罗湖区 百仕达','东乐花园','罗湖区 百仕达','深圳','商铺','95.26','95.26','1993-10-23','70',' '),
('4307078840363','坪山区 坪山','深城投中心公馆','坪山区 坪山','深圳','住宅','32.22','32.22','1979-8-24','70',' '),
('7922036644340','龙岗区 龙岗中心城','依山郡花园三期','龙岗区 龙岗中心城','上海','商铺','90.28','90.28','2017-5-27','70',' '),
('9109186997695','福田区 新洲','嘉葆润金座','福田区 新洲','深圳','住宅','61.41','61.41','1970-11-22','70',' '),
('7968022153739','龙岗区 龙岗中心城','远洋新干线晶钻广场','龙岗区 龙岗中心城','上海','住宅','65.24','65.24','1972-10-16','70',' '),
('5137075455390','南山区 南头','豪方天际花园','南山区 南头','成都','别墅','142.6','142.6','2000-3-31','70',' '),
('3929404129473','南山区 南头','绿茵丰和家园','南山区 南头','北京','住宅','112.26','112.26','2018-9-2','70',' '),
('4293283676549','宝安区 松岗','满京华云著一期','宝安区 松岗','武汉','车位','88.82','88.82','2006-12-17','70',' '),
('7524144446390','龙岗区 龙岗中心城','瑞华园','龙岗区 龙岗中心城','上海','别墅','124.05','124.05','1973-8-27','70',' '),
('9259621134485','龙岗区 坂田','佳兆业中央广场一期','龙岗区 坂田','深圳','住宅','89.23','89.23','2021-8-11','70',' '),
('1560464293321','龙岗区 龙岗双龙','满京华喜悦里','龙岗区 龙岗双龙','北京','别墅','88.09','88.09','1974-3-19','70',' '),
('6344462354930','南山区 科技园','华润城润府一期','南山区 科技园','上海','别墅','89.09','89.09','1992-10-18','70',' '),
('8574688457120','南山区 前海','诺德假日花园','南山区 前海','北京','商铺','66.5','66.5','2003-9-1','70',' '),
('0365736170159','南山区 南山中心','向南西海花园','南山区 南山中心','武汉','车位','71.76','71.76','1991-11-26','70',' '),
('1210897403783','龙华区 红山','绿景公馆1866北区','龙华区 红山','深圳','别墅','88.42','88.42','1988-12-11','70',' '),
('2774728742738','硚口 宗关','博学仕府','硚口 宗关','上海','车位','135.62','135.62','2009-11-9','70',' '),
('6439331241571','江岸 百步亭','怡和苑南区','江岸 百步亭','成都','商铺','129.08','129.08','2004-7-23','70',' '),
('0221476057771','汉阳 四新','金地澜菲溪岸','汉阳 四新','武汉','车位','95.02','95.02','1984-12-27','70',' '),
('7621212333546','东湖高新 光谷东','光谷188国际社区','东湖高新 光谷东','武汉','别墅','128.07','128.07','2000-6-30','70',' '),
('9497525109036','东西湖 金银湖','万丰丰泽园','东西湖 金银湖','深圳','商铺','112.08','112.08','2007-4-27','70',' '),
('9193649533749','东湖高新 光谷东','北辰优+国际青年互动特区','东湖高新 光谷东','武汉','车位','81.68','81.68','1987-7-25','70',' '),
('7891197867221','洪山 珞狮南路','保利心语七期','洪山 珞狮南路','成都','别墅','121.23','121.23','1984-9-26','70',' '),
('9729801234646','汉阳 王家湾','当代万国城MOMΛ','汉阳 王家湾','成都','别墅','113.84','113.84','1989-6-10','70',' '),
('9586067803647','武昌 南湖沃尔玛','水域天际','武昌 南湖沃尔玛','上海','车位','80.86','80.86','1972-12-22','70',' '),
('9838024065809','江夏 庙山','武汉碧桂园天玺湾','江夏 庙山','北京','商铺','118.13','118.13','1981-4-14','70',' '),
('0783068180704','江岸 百步亭','百步亭花园世博园','江岸 百步亭','深圳','住宅','72.03','72.03','1990-2-24','70',' '),
('5942745709641','江岸 百步亭','百步亭花园世博园','江岸 百步亭','武汉','别墅','135.83','135.83','1979-8-14','70',' '),
('1105285964116','武昌 中北路','复地东湖国际三期','武昌 中北路','北京','商铺','139.87','139.87','1992-1-25','70',' '),
('7510122653609','汉阳 四新','纽宾凯汉city国际社区锦城','汉阳 四新','成都','住宅','104.73','104.73','1978-10-8','70',' '),
('1857484442062','武昌 南湖沃尔玛','水域天际','武昌 南湖沃尔玛','成都','别墅','127.3','127.3','1974-4-30','70',' '),
('7022127216944','洪山 徐东','鹏程花园','洪山 徐东','武汉','别墅','103.98','103.98','1974-9-23','70',' '),
('4524475812042','洪山 新南湖','保利中央公馆','洪山 新南湖','成都','商铺','88.85','88.85','1972-8-9','70',' '),
('1560155004590','新洲 阳逻','阳光新港中央花园城','新洲 阳逻','武汉','别墅','93.11','93.11','1977-11-24','70',' '),
('7193839283421','新洲 阳逻','住开盛世长江','新洲 阳逻','北京','商铺','144.96','144.96','1984-8-6','70',' '),
('4527443786029','武昌 中北路','复地东湖国际六期','武昌 中北路','北京','车位','88.49','88.49','1997-7-6','70',' '),
('3312243183456','洪山 徐东','长航蓝晶绿洲一二期','洪山 徐东','北京','商铺','126.95','126.95','2003-8-10','70',' '),
('1607295120635','武昌 水果湖','小洪山西区','武昌 水果湖','上海','商铺','68.28','68.28','1980-7-8','70',' '),
('7130768422370','洪山 杨园','保利才盛景苑','洪山 杨园','深圳','车位','91.12','91.12','1983-2-18','70',' '),
('9057366580908','东西湖 金银湖','融创观澜壹号','东西湖 金银湖','北京','别墅','113.09','113.09','1981-11-3','70',' '),
('5876520645693','青山 青山','冶金106街坊','青山 青山','深圳','住宅','84.7','84.7','1985-1-23','70',' '),
('0314803871445','汉阳 四新','金地澜菲溪岸','汉阳 四新','武汉','别墅','92.0','92.0','2013-6-30','70',' '),
('5759824086061','洪山 团结大道','金地自在城','洪山 团结大道','北京','商铺','91.45','91.45','1993-3-10','70',' '),
('2818274497292','洪山 新南湖','金地格林小城莱茵区','洪山 新南湖','北京','商铺','126.56','126.56','1980-11-7','70',' '),
('2135790453549','汉阳 四新','广电兰亭时代','汉阳 四新','上海','商铺','89.23','89.23','2010-7-20','70',' '),
('2196178356504','东湖高新 华科大','新世界恒大华府','东湖高新 华科大','上海','别墅','128.61','128.61','2008-4-19','70',' '),
('9721998836308','浦东 北蔡','绿川新苑','浦东 北蔡','成都','车位','82.4','82.4','2031-4-29','70',' '),
('8899237893032','徐汇 漕河泾','虹梅小区','徐汇 漕河泾','北京','别墅','56.25','56.25','2023-9-15','70',' '),
('2058143673669','徐汇 田林','田林体育公寓','徐汇 田林','成都','别墅','87.1','87.1','2043-2-10','70',' '),
('2049309513241','浦东 唐镇','毕加索小镇(一期)(公寓)','浦东 唐镇','深圳','车位','66.34','66.34','2029-1-16','70',' '),
('2616123650325','长宁 中山公园','云雾山路551弄','长宁 中山公园','成都','住宅','44.1','44.1','2031-3-15','70',' '),
('1441273455257','闵行 古美','古美小区','闵行 古美','武汉','车位','57.66','57.66','2026-3-9','70',' '),
('0551845238147','静安 永和','成亿花园','静安 永和','武汉','别墅','174.08','174.08','2050-6-1','70',' '),
('0585550950920','徐汇 华东理工','梅陇五村','徐汇 华东理工','成都','车位','52.78','52.78','2042-5-20','70',' '),
('2067290826679','闵行 浦江','浦江颐城晶寓','闵行 浦江','武汉','住宅','128.62','128.62','2029-10-30','70',' '),
('0510201450840','闵行 航华','航华二村梧柏小区','闵行 航华','深圳','住宅','38.84','38.84','2025-8-9','70',' '),
('8946617779978','浦东 北蔡','南新四村','浦东 北蔡','深圳','别墅','52.94','52.94','2032-8-15','70',' '),
('8303458676212','浦东 塘桥','塘东小区','浦东 塘桥','深圳','车位','39.04','39.04','2040-3-1','70',' '),
('5222180897667','浦东 塘桥','新都花园','浦东 塘桥','成都','住宅','132.72','132.72','2024-1-16','70',' '),
('1558169411614','静安 闸北公园','和玉苑','静安 闸北公园','深圳','商铺','98.48','98.48','2042-6-16','70',' '),
('9867811870404','嘉定 安亭','嘉亭菁苑','嘉定 安亭','深圳','别墅','143.14','143.14','2038-6-16','70',' '),
('2139101298628','浦东 梅园','梅园五街坊','浦东 梅园','深圳','车位','51.51','51.51','2033-5-20','70',' '),
('7641437640619','静安 曹家渡','静安四季公寓','静安 曹家渡','成都','别墅','81.62','81.62','2030-9-16','70',' '),
('8835779713943','长宁 中山公园','天山三村','长宁 中山公园','成都','住宅','36.28','36.28','2031-3-10','70',' '),
('4771798520712','嘉定 安亭','恒大名都','嘉定 安亭','成都','车位','75.22','75.22','2028-3-10','70',' '),
('2743523362669','宝山 淞宝','宝钢四村','宝山 淞宝','上海','别墅','72.88','72.88','2043-1-15','70',' '),
('5762808098171','奉贤 西渡','文怡花园','奉贤 西渡','深圳','别墅','95.1','95.1','2022-6-24','70',' '),
('9151683985970','浦东 川沙','东锦苑','浦东 川沙','成都','商铺','79.54','79.54','2047-6-4','70',' '),
('0332982681087','松江 泗泾','绿叶小区(松江)','松江 泗泾','北京','商铺','126.72','126.72','2041-8-7','70',' '),
('6260068066048','静安 闸北公园','紫薇阁','静安 闸北公园','上海','商铺','98.34','98.34','2048-8-17','70',' '),
('5590198102387','徐汇 植物园','东泉小区','徐汇 植物园','武汉','商铺','68.0','68.0','2046-10-4','70',' '),
('3915246126270','普陀 长寿路','玉佛城','普陀 长寿路','北京','车位','160.73','160.73','2045-12-18','70',' '),
('4675512052173','宝山 大华','大华一村','宝山 大华','深圳','车位','78.69','78.69','2036-1-2','70',' '),
('8921536375120','闵行 春申','祥生瑞和苑','闵行 春申','成都','住宅','85.97','85.97','2046-12-9','70',' '),
('7622400299444','长宁 仙霞','仙逸小区','长宁 仙霞','武汉','商铺','45.72','45.72','2036-10-8','70',' '),
('6181555710460','闵行 老闵行','万科公园大道','闵行 老闵行','上海','住宅','97.42','97.42','2030-9-28','70',' '),
('5572318512513','长宁 中山公园','长江小区','长宁 中山公园','成都','住宅','50.42','50.42','2045-5-13','70',' '),
('2524505851901','闵行 莘庄南广场','新空间家园','闵行 莘庄南广场','北京','商铺','133.73','133.73','2031-3-28','70',' '),
('4370684218188','普陀 真光','真光新村第二小区','普陀 真光','深圳','车位','49.38','49.38','2029-9-5','70',' '),
('0077079913182','浦东 康桥','绿地康桥新苑','浦东 康桥','成都','车位','87.49','87.49','2025-6-16','70',' '),
('2107755712069','浦东 周浦','印象春城','浦东 周浦','上海','住宅','91.4','91.4','2042-8-27','70',' '),
('5493742427158','闵行 古美','古美三村','闵行 古美','武汉','车位','73.81','73.81','2020-1-25','70',' '),
('9325996862888','嘉定 丰庄','丰庄十二街坊','嘉定 丰庄','上海','别墅','62.37','62.37','2040-11-27','70',' '),
('1712106769110','普陀 长风','华师大一村','普陀 长风','北京','别墅','66.66','66.66','2028-12-7','70',' '),
('4283003961776','浦东 三林','永泰花苑','浦东 三林','深圳','车位','71.23','71.23','2048-11-16','70',' '),
('8805375071059','浦东 北蔡','由由七村','浦东 北蔡','上海','别墅','66.34','66.34','2047-4-15','70',' '),
('7830470456115','普陀 真光','阳光威尼斯(二期)','普陀 真光','成都','商铺','131.82','131.82','2035-3-22','70',' '),
('6810326995173','嘉定 江桥','富友嘉园','嘉定 江桥','武汉','车位','72.18','72.18','2036-10-26','70',' '),
('6176668658908','闵行 静安新城','静安新城五区','闵行 静安新城','上海','商铺','65.48','65.48','2043-6-22','70',' '),
('1360854675905','闵行 古美','平南一二村','闵行 古美','上海','车位','65.72','65.72','2033-10-31','70',' '),
('2670053734144','闵行 航华','航华三村一街坊','闵行 航华','武汉','商铺','70.5','70.5','2033-9-22','70',' '),
('5765421377880','闵行 颛桥','颛溪七村','闵行 颛桥','北京','商铺','59.64','59.64','2030-12-1','70',' '),
('2261960192152','静安 闸北公园','和玉苑','静安 闸北公园','成都','商铺','69.85','69.85','2046-4-24','70',' '),
('4673940417891','徐汇 田林','田林十四村','徐汇 田林','上海','车位','73.59','73.59','2022-4-28','70',' '),
('8496316601014','浦东 世博','济阳一村','浦东 世博','上海','别墅','57.84','57.84','2047-9-11','70',' '),
('5086424288195','普陀 武宁','武宁小城','普陀 武宁','成都','别墅','137.7','137.7','2039-4-14','70',' '),
('7474767096110','宝山 顾村','保利叶语(二期)(公寓)','宝山 顾村','武汉','住宅','127.81','127.81','2020-1-17','70',' '),
('7303862816096','奉贤 海湾','绿地香颂(奉贤)(别墅)','奉贤 海湾','北京','商铺','235.08','235.08','2046-1-7','70',' '),
('3707900592096','静安 南京西路','远中风华园(公寓)','静安 南京西路','深圳','商铺','159.16','159.16','2024-12-11','70',' '),
('2795689742944','徐汇 康健','光大会展中心','徐汇 康健','深圳','别墅','133.91','133.91','2046-11-29','70',' '),
('8672731376736','闵行 老闵行','万科城','闵行 老闵行','深圳','车位','90.93','90.93','2020-4-4','70',' '),
('2805417775099','浦东 宣桥','海志花苑','浦东 宣桥','北京','别墅','92.16','92.16','2049-10-9','70',' '),
('0334097276208','嘉定 嘉定老城','清水颐园','嘉定 嘉定老城','武汉','别墅','134.07','134.07','2029-11-18','70',' '),
('0708893238370','闵行 古美','新梅公寓二期','闵行 古美','北京','商铺','108.53','108.53','2045-5-22','70',' '),
('4604677099196','杨浦 东外滩','新江浦公寓','杨浦 东外滩','深圳','别墅','80.72','80.72','2029-6-1','70',' '),
('5220607459173','宝山 上大','保利熙悦名邸','宝山 上大','北京','商铺','98.01','98.01','2024-1-14','70',' '),
('3583403284025','闵行 古美','新梅公寓一期','闵行 古美','武汉','车位','92.97','92.97','2041-3-22','70',' '),
('2278589402602','松江 泗泾','新凯二期(北区)','松江 泗泾','成都','别墅','92.98','92.98','2039-7-6','70',' '),
('9314166040596','浦东 唐镇','毕加索小镇(一期)(公寓)','浦东 唐镇','成都','车位','93.09','93.09','2040-3-18','70',' '),
('1229768206244','静安 大宁','童家浜小区','静安 大宁','成都','别墅','33.59','33.59','2038-1-27','70',' '),
('9623727919708','徐汇 康健','康宁坊','徐汇 康健','深圳','车位','56.03','56.03','2024-7-4','70',' '),
('1815965438561','宝山 杨行','天馨花园(公寓)','宝山 杨行','上海','车位','89.6','89.6','2024-9-2','70',' '),
('0630521176447','徐汇 华东理工','松风花园','徐汇 华东理工','成都','别墅','90.82','90.82','2037-3-24','70',' '),
('0433228356754','闵行 古美','东兰新村','闵行 古美','武汉','别墅','66.56','66.56','2026-11-20','70',' '),
('5406119941001','闵行 七宝','万科朗润园','闵行 七宝','武汉','别墅','100.3','100.3','2023-4-13','70',' '),
('6663313371477','嘉定 安亭','新城尚上城','嘉定 安亭','深圳','住宅','92.75','92.75','2022-12-26','70',' '),
('3282213501958','青浦 徐泾','招商虹桥公馆一期','青浦 徐泾','上海','别墅','97.65','97.65','2048-3-9','70',' '),
('8014788050652','闵行 古美','平吉二村','闵行 古美','深圳','商铺','62.1','62.1','2047-3-17','70',' '),
('3676203763846','浦东 川沙','银光苑','浦东 川沙','成都','别墅','116.86','116.86','2025-1-11','70',' '),
('9239745743956','浦东 金杨','金杨新村九街坊','浦东 金杨','成都','商铺','56.05','56.05','2046-6-23','70',' '),
('2430335326415','浦东 川沙','玉宇新苑','浦东 川沙','北京','车位','133.36','133.36','2050-1-7','70',' '),
('5778796998836','青浦 白鹤','绿地时代名邸','青浦 白鹤','北京','车位','87.47','87.47','2046-4-13','70',' '),
('8156996580314','闵行 龙柏','龙柏五村','闵行 龙柏','上海','车位','75.56','75.56','2026-9-18','70',' '),
('9547872499337','浦东 金桥','金新花苑','浦东 金桥','深圳','车位','77.38','77.38','2032-4-4','70',' '),
('7132340036637','松江 泗泾','金地玺华邨','松江 泗泾','成都','车位','120.52','120.52','2033-4-14','70',' '),
('8094559502148','奉贤 西渡','闸园新村','奉贤 西渡','成都','住宅','52.91','52.91','2034-12-17','70',' '),
('7329849255342','浦东 北蔡','大华锦绣华城(一街区)','浦东 北蔡','北京','车位','73.74','73.74','2028-4-26','70',' '),
('6054765579723','嘉定 嘉定老城','李园一村','嘉定 嘉定老城','深圳','商铺','57.17','57.17','2022-12-24','70',' '),
('2751336210356','浦东 联洋','天安花园','浦东 联洋','上海','别墅','152.31','152.31','2040-1-13','70',' '),
('2787436127993','长宁 仙霞','芙蓉小区','长宁 仙霞','成都','别墅','35.69','35.69','2048-1-21','70',' '),
('0986677747012','金山 金山','蓝色收获板桥东路888弄','金山 金山','深圳','住宅','70.45','70.45','2040-8-22','70',' '),
('4740738367972','杨浦 周家嘴路','华升新苑','杨浦 周家嘴路','成都','车位','103.03','103.03','2029-1-5','70',' '),
('1593296283359','奉贤 西渡','新南家园','奉贤 西渡','深圳','别墅','102.22','102.22','2039-9-28','70',' '),
('8051043206122','浦东 临港新城','保利玲珑公馆','浦东 临港新城','北京','车位','92.48','92.48','2031-6-30','70',' '),
('2136036114317','闵行 莘庄南广场','莘城公寓','闵行 莘庄南广场','上海','车位','93.39','93.39','2037-7-7','70',' '),
('9961812737087','嘉定 徐行','禹洲丁香里','嘉定 徐行','成都','别墅','121.73','121.73','2026-12-17','70',' ')
产权登记表
insert into registration values
('1','410300197803130226','7048559328340','48126129.753','1985-10-31','2044-9-17'),
('2','621121198801203802','8042336233946','18046482.426','2021-5-4','2022-6-11'),
('3','520324196803023967','8179626486099','79599221.687','2014-7-9','2021-11-25'),
('4','410300197803130226','0425233068802','72981462.475','2003-12-15','2030-7-24'),
('5','451424193605287480','3370134573147','12957816.737','2022-2-28','2030-4-27'),
('6','640500193507124572','5920242276418','79728434.439','1975-11-21','2026-3-15'),
('7','150825196002053132','3220716362052','76665989.12','1987-2-21','2022-10-27'),
('8','621021199601042142','2749679339012','63251634.573','2001-1-28','2020-7-31'),
('9','371721196511115646','7530559324214','98761094.616','1986-4-3','2047-8-22'),
('10','451402196110177138','0819626927954','97116678.249','2008-5-7','2030-6-28'),
('11','451424193605287480','5495107717580','13607266.85','2007-8-22','2028-5-31'),
('12','371721196511115646','6032742352361','43676457.203','1985-5-16','2034-1-11'),
('13','500104194306074676','4826744238167','60157471.985','1989-11-10','2033-6-16'),
('14','500104194306074676','0200196264383','73149761.173','1994-10-9','2038-8-20'),
('15','421222199109146863','7649755764802','94159248.95','1980-1-22','2034-5-22'),
('16','370827200203273871','0302088001922','68879985.027','1984-3-1','2020-9-9'),
('17','210112196912222763','9603877706347','65047771.25','1975-1-11','2047-7-24'),
('18','371721196511115646','3539571022422','84300725.299','2021-1-15','2022-9-23'),
('19','371721196511115646','5939994385204','66781668.137','1971-10-28','2036-2-1'),
('20','621121198801203802','0670597072698','33460321.201','1970-2-3','2048-3-1'),
('21','421222199109146863','7657377455593','62769226.143','1972-6-1','2028-8-29'),
('22','632525193806222516','0534637617382','43727738.182','1973-12-21','2033-3-6'),
('23','410823193310252405','9442026387458','63551385.045','1991-1-30','2041-7-16'),
('24','150825196002053132','2541025083519','73492860.494','1983-7-27','2021-1-2'),
('25','632525193806222516','1247653728722','89254824.757','2016-9-13','2040-2-20'),
('26','500114196703015516','3674881547417','13180931.068','1999-8-5','2027-5-27'),
('27','621121198801203802','6653430697705','74508342.049','2011-3-1','2048-12-28'),
('28','371721196511115646','5114124185781','32536690.681','2002-8-25','2045-8-10'),
('29','451402196110177138','8837775748631','84391700.908','2013-1-10','2044-7-30'),
('30','370827200203273871','4047297649660','6573873.101','1983-6-3','2029-7-26'),
('31','421222199109146863','4683358822010','47680780.511','1974-8-4','2029-10-29'),
('32','410823193310252405','4426423111293','35599136.1','1980-3-22','2023-7-17'),
('33','621021199601042142','0329284951753','93562138.367','2020-9-22','2050-6-5'),
('34','520324196803023967','4708368422905','83365903.77','2004-5-24','2031-11-11'),
('35','520324196803023967','7318014459326','95045319.439','1972-5-14','2022-11-15'),
('36','522300193312169328','3826510725518','15701036.965','1997-4-9','2040-2-28'),
('37','230230199406300699','5544204379480','95308786.52','2001-6-30','2034-1-11'),
('38','632525193806222516','3222195010334','21512451.144','2012-1-7','2024-11-23'),
('39','210112196912222763','3110966299542','29426220.578','1974-1-24','2047-7-7'),
('40','520324196803023967','5219775297630','35638517.303','1979-11-8','2046-12-26'),
('41','451402196110177138','6710840105406','23464446.984','2002-11-29','2050-5-4'),
('42','230230199406300699','7639300274367','64577262.996','2007-8-15','2033-1-12'),
('43','451424193605287480','5937518064115','30536498.395','1979-11-4','2045-8-25'),
('44','500104194306074676','4428309591402','41303840.321','2019-9-18','2046-12-4'),
('45','621021199601042142','5566436313664','40771280.31','1992-12-17','2042-10-17'),
('46','32092519791217009X','6752232140550','97740380.754','1983-3-23','2038-9-17'),
('47','150105196407293739','5248076445420','13328245.629','1994-8-13','2042-4-25'),
('48','410300197803130226','6819409374951','91182254.142','2022-9-16','2046-4-1'),
('49','371721196511115646','7800103329275','98146674.575','2000-11-3','2032-12-30'),
('50','632822198110172776','4941941722239','34019096.678','2013-1-25','2027-3-17'),
('51','632525193806222516','1468706435835','54741317.105','2015-2-23','2026-6-23'),
('52','620421195709066253','3267064130771','99499055.601','2004-4-19','2027-4-26'),
('53','500104194306074676','3833816793419','75938935.952','2007-10-20','2046-9-8'),
('54','621121198801203802','3922633689357','90594806.549','1999-8-8','2022-3-18'),
('55','632822198110172776','9772539583990','97808483.611','1985-4-9','2046-10-7'),
('56','150105196407293739','1094517347712','2185130.793','2014-10-28','2047-2-13'),
('57','621021199601042142','8857258232155','2694581.07','1995-1-12','2030-2-18'),
('58','520324196803023967','0846646312494','91464492.349','2011-10-6','2038-12-22'),
('59','500104194306074676','0566786708720','58851182.225','1998-7-10','2044-2-18'),
('60','370827200203273871','7735814020932','8927131.828','2021-10-14','2040-4-17'),
('61','130202200204031722','0876120469844','75010355.344','2015-12-10','2027-3-1'),
('62','620421195709066253','9026463364336','7201814.59','1973-6-30','2042-11-9'),
('63','632525193806222516','9277961077677','83355424.996','1977-12-4','2042-7-9'),
('64','341800198708146312','4817565640687','52059164.692','1986-11-29','2033-8-19'),
('65','621021199601042142','2393807790278','31218001.292','2020-7-31','2030-4-16'),
('66','230230199406300699','7416032975134','70988496.611','1972-6-22','2027-5-28'),
('67','520324196803023967','0520754967896','67240198.024','1997-6-29','2050-5-6'),
('68','370827200203273871','2267199835097','12242416.928','1980-7-22','2028-12-31'),
('69','620421195709066253','2387422007134','47148532.732','1975-5-29','2020-6-14'),
('70','451402196110177138','4833038097012','57853312.879','2023-1-26','2020-11-14'),
('71','371721196511115646','0252041807538','95874611.629','2022-2-8','2050-6-15'),
('72','621021199601042142','4650331834665','24265158.759','2000-1-7','2034-11-9'),
('73','230230199406300699','0092573970557','15870621.164','2009-7-1','2032-12-23'),
('74','621021199601042142','7248639767142','69794842.428','1994-9-5','2022-9-5'),
('75','150105196407293739','6453419209749','68341711.147','2004-12-15','2026-5-19'),
('76','621121198801203802','9816724336722','74791683.278','1990-7-31','2027-12-26'),
('77','341800198708146312','2081734423526','74230621.688','2012-5-6','2020-10-28'),
('78','522300193312169328','1676728133851','3602346.886','2017-3-21','2048-12-7'),
('79','451424193605287480','2402059879715','75404669.354','1991-9-29','2038-10-8'),
('80','32092519791217009X','1725081793302','38016184.418','1980-12-21','2044-3-8'),
('81','522300193312169328','1937129552452','27995133.554','1984-7-24','2036-4-23'),
('82','341800198708146312','3447082818592','12979387.254','1999-1-17','2024-9-6'),
('83','522300193312169328','0637173071376','17647962.717','1972-1-20','2036-5-14'),
('84','621021199601042142','7695179133961','10051349.195','1975-5-4','2049-8-21'),
('85','230230199406300699','7761248843791','9029656.916','1999-8-16','2022-8-26'),
('86','32092519791217009X','6091645180472','70010664.754','1993-5-1','2028-1-4'),
('87','620421195709066253','5087542889554','19408205.303','2001-7-26','2029-7-14'),
('88','32092519791217009X','9014177502903','32483923.942','1970-5-3','2041-9-12'),
('89','230230199406300699','9483054201829','99091230.475','2002-9-29','2031-1-12'),
('90','621021199601042142','9211545927330','40864948.782','1984-8-16','2043-2-10'),
('91','130202200204031722','3741991933472','17262038.446','1978-5-31','2038-9-20'),
('92','640500193507124572','2034238086111','85039689.14','2006-1-2','2026-12-29'),
('93','370827200203273871','0108985819289','17754338.33','2002-6-5','2047-5-9'),
('94','370827200203273871','5237533110457','65777365.593','2005-5-19','2044-8-19'),
('95','632525193806222516','2212184143493','9844162.367','1978-11-13','2026-8-30'),
('96','632525193806222516','8457283955681','21634370.794','2012-12-24','2034-6-24'),
('97','410823193310252405','9946047482875','47333329.784','1998-10-18','2040-11-16'),
('98','150825196002053132','8979129086848','97244551.443','1985-2-21','2025-4-24'),
('99','130202200204031722','8397399426669','15383450.067','1992-8-26','2025-2-11'),
('100','410823193310252405','8754329055118','14237443.309','2005-6-26','2020-9-3'),
('101','620421195709066253','0671003259833','4064417.392','1996-12-1','2028-11-24'),
('102','130202200204031722','2050560485264','31455748.928','2020-4-28','2041-4-25'),
('103','520324196803023967','4415941940912','69667486.433','2018-1-30','2032-4-9'),
('104','150825196002053132','0019669731032','66557726.781','1998-6-29','2039-7-28'),
('105','371721196511115646','3220162580766','97281988.993','2012-11-21','2036-4-28'),
('106','500104194306074676','5872649856146','96267933.706','1998-8-7','2032-6-28'),
('107','130202200204031722','5040524637676','71966352.574','2006-11-20','2031-7-30'),
('108','640500193507124572','7629990420285','98752176.285','1980-8-18','2035-9-24'),
('109','150105196407293739','7509274064748','31464442.488','1982-9-11','2046-1-27'),
('110','500114196703015516','2051984168144','63861157.632','1982-6-2','2048-6-9'),
('111','130202200204031722','1865704859352','78872543.661','1997-6-5','2041-9-20'),
('112','421222199109146863','3297734445785','57321194.918','1994-10-16','2049-7-28'),
('113','410300197803130226','0329339279482','5189673.808','1994-4-25','2048-1-25'),
('114','621021199601042142','2238946908772','47611531.082','1970-8-23','2035-3-27'),
('115','520324196803023967','5706534790282','42412047.215','1992-11-7','2020-1-2'),
('116','632822198110172776','0670676289597','6391395.197','2007-8-1','2043-5-9'),
('117','230230199406300699','7804709151036','36349479.836','1999-3-19','2021-6-30'),
('118','210112196912222763','2698152852776','86122634.586','2004-1-4','2036-3-15'),
('119','632323195703136688','9937734131905','84351514.179','1972-8-30','2025-4-19'),
('120','500114196703015516','5164238899880','31905453.471','2016-10-10','2049-12-27'),
('121','451424193605287480','3826528318951','86020703.927','1977-11-11','2038-1-27'),
('122','150825196002053132','8815427443918','52867383.209','2016-1-20','2021-10-23'),
('123','620421195709066253','7510224481111','98091066.597','1972-10-14','2036-1-1'),
('124','451402196110177138','0943262927062','71484208.22','2004-10-13','2040-12-15'),
('125','500104194306074676','1213930055407','40785416.808','2020-5-30','2023-4-5'),
('126','632525193806222516','9226821915542','69972823.563','2014-9-10','2027-4-3'),
('127','32092519791217009X','8806404041543','62634061.253','2001-7-12','2048-4-15'),
('128','150105196407293739','6465932377681','20832239.334','1991-12-1','2045-11-17'),
('129','150825196002053132','5232514453944','23420110.068','2009-5-24','2031-3-12'),
('130','632525193806222516','2531347087158','29898839.617','1997-6-28','2048-8-12'),
('131','522300193312169328','4228906014039','84918796.651','2012-2-16','2045-2-18'),
('132','370827200203273871','9755575632768','44614586.279','1999-12-1','2028-9-6'),
('133','522300193312169328','3505456475555','17183346.785','2001-10-17','2048-7-3'),
('134','500104194306074676','4975164137450','27333603.228','2000-12-12','2036-12-8'),
('135','230230199406300699','1261185547597','90684615.817','1982-2-19','2048-11-13'),
('136','230230199406300699','9260880492429','98637787.92','2010-9-29','2031-2-12'),
('137','500104194306074676','8022614939002','16987974.378','1990-5-31','2035-12-13'),
('138','150825196002053132','3764599193496','51858647.556','2001-5-31','2022-5-21'),
('139','520324196803023967','2990329512345','47985610.803','2015-9-12','2034-7-18'),
('140','632525193806222516','4829699797020','47812976.476','2022-10-28','2020-11-6'),
('141','621121198801203802','4497189118757','99605562.116','1991-7-12','2028-9-27'),
('142','632525193806222516','0775257242352','51055604.384','1970-12-2','2047-2-19'),
('143','371721196511115646','2996364228041','54821072.823','1981-4-29','2041-12-16'),
('144','150825196002053132','4933618780021','92064822.968','2007-3-15','2050-4-24'),
('145','410300197803130226','4141628970808','99418067.2','2014-5-31','2035-10-3'),
('146','620421195709066253','5271069103886','46841235.489','1995-8-28','2044-5-20'),
('147','130202200204031722','9429808790738','16006898.701','1997-5-20','2029-1-22'),
('148','410300197803130226','5556872717437','10988911.245','2004-4-30','2048-7-6'),
('149','410823193310252405','1553918513615','96843921.077','1972-11-5','2045-1-23'),
('150','150825196002053132','5448404805852','63430321.377','1994-6-4','2042-1-11'),
('151','410300197803130226','1808772887895','31323362.815','2015-11-8','2046-4-13'),
('152','500114196703015516','3787472880117','90258483.566','1983-12-11','2041-4-25'),
('153','520324196803023967','2260456499228','60154713.684','1992-3-8','2035-12-21'),
('154','370827200203273871','8518178434160','79335192.404','1989-7-27','2026-11-19'),
('155','632822198110172776','2592627689593','47870856.999','2007-10-13','2039-9-21'),
('156','451402196110177138','0348479292529','34672270.773','1980-11-14','2046-12-17'),
('157','451424193605287480','3033476317108','99245007.35','2012-11-3','2030-5-19'),
('158','520324196803023967','8370713452825','98914775.075','1977-7-27','2022-8-27'),
('159','150105196407293739','4025916012315','64462223.618','2004-6-26','2030-12-21'),
('160','451402196110177138','7622056571019','45930474.533','2021-6-27','2050-5-7'),
('161','500104194306074676','6762064756664','38676552.802','1990-10-8','2021-8-27'),
('162','421222199109146863','8661793266214','77488234.938','2003-2-17','2042-4-23'),
('163','500104194306074676','2949011155118','85296704.548','2022-7-10','2044-6-5'),
('164','421222199109146863','7335329648929','43789604.615','1991-6-27','2038-9-26'),
('165','150825196002053132','5673985605755','91462799.065','1985-10-24','2031-5-20'),
('166','640500193507124572','6659536484546','43040028.666','1989-2-17','2042-12-19'),
('167','500114196703015516','2953186367636','46472983.021','2013-12-5','2028-5-19'),
('168','451402196110177138','1322391362356','48589684.213','1973-11-20','2025-9-28'),
('169','341800198708146312','1923547693512','78464238.63','1990-6-1','2021-7-31'),
('170','520324196803023967','7922569231247','28775219.993','1997-6-28','2024-4-18'),
('171','632525193806222516','5964065832807','83283142.557','2008-8-12','2020-9-17'),
('172','451424193605287480','1442431751215','68212518.28','1989-3-17','2024-4-20'),
('173','520324196803023967','1251285478409','63230133.345','1991-4-10','2047-2-26'),
('174','370827200203273871','5590696793650','83167989.808','1988-6-5','2041-12-8'),
('175','451402196110177138','3341496269521','65114995.318','2019-4-29','2046-10-31'),
('176','32092519791217009X','0640172588749','86027928.808','2009-7-9','2032-3-18'),
('177','451424193605287480','8675082958244','21150933.798','1984-3-14','2045-2-8'),
('178','500114196703015516','3613919328866','78494434.443','2015-5-22','2039-4-28'),
('179','370827200203273871','6145146706676','43199373.363','2001-9-21','2036-12-30'),
('180','410823193310252405','9257199041859','84310897.396','2005-4-27','2028-4-26'),
('181','621021199601042142','6385201677001','55039535.396','1995-3-4','2042-2-5'),
('182','520324196803023967','6086573527389','70295822.33','1977-7-6','2030-5-23'),
('183','341800198708146312','1924490182996','71243714.158','2016-6-24','2042-12-8'),
('184','341800198708146312','0651631000399','82128272.8','1972-8-9','2026-2-15'),
('185','410300197803130226','2159605040062','84544416.437','1998-2-15','2024-6-2'),
('186','632822198110172776','4709436585605','18399913.277','2003-12-13','2028-3-25'),
('187','150105196407293739','4369372730106','64992565.294','2005-9-11','2045-11-14'),
('188','130202200204031722','2381870497374','69340581.865','1991-12-20','2047-5-23'),
('189','451402196110177138','1779091869909','73567204.57','2016-3-24','2046-7-4'),
('190','522300193312169328','5010323279397','25144816.25','1979-7-13','2025-3-22'),
('191','32092519791217009X','8873299251750','30125852.429','1984-6-1','2047-7-15'),
('192','230230199406300699','3275907334023','87571404.413','2018-11-6','2038-11-22'),
('193','230230199406300699','9032674645600','65924139.601','2004-5-3','2031-4-10'),
('194','451424193605287480','8426547205999','57801732.548','1989-9-8','2048-7-27'),
('195','621121198801203802','4015820528157','31697501.044','2002-4-16','2031-10-25'),
('196','500114196703015516','2015893448005','70024213.715','2014-6-16','2032-4-29'),
('197','621121198801203802','4307078840363','71419097.353','2008-2-6','2040-1-7'),
('198','410823193310252405','7922036644340','18146864.406','1977-10-18','2033-7-11'),
('199','520324196803023967','9109186997695','10368386.749','1973-8-9','2033-8-11'),
('200','632323195703136688','7968022153739','8968587.886','1996-2-3','2020-3-1'),
('201','410823193310252405','5137075455390','20668296.115','2017-1-28','2033-1-2'),
('202','451402196110177138','3929404129473','85892816.521','1994-5-11','2031-3-8'),
('203','451424193605287480','4293283676549','30207261.158','1970-11-9','2043-7-16'),
('204','632822198110172776','7524144446390','70017028.417','1993-6-21','2035-9-25'),
('205','451424193605287480','9259621134485','72646211.843','2004-12-13','2046-1-26'),
('206','500104194306074676','1560464293321','57362632.627','1999-3-30','2049-8-27'),
('207','230230199406300699','6344462354930','90331779.585','1978-5-23','2043-2-22'),
('208','620421195709066253','8574688457120','35911167.554','1974-1-31','2033-10-15'),
('209','370827200203273871','0365736170159','57154954.626','2022-6-20','2036-12-16'),
('210','32092519791217009X','1210897403783','7645537.457','2021-6-23','2039-1-31'),
('211','632525193806222516','2774728742738','43838647.929','2022-3-1','2021-11-30'),
('212','210112196912222763','6439331241571','14811656.267','2009-4-20','2027-5-24'),
('213','621021199601042142','0221476057771','48672229.885','1979-1-31','2047-7-25'),
('214','210112196912222763','7621212333546','29015708.998','2015-8-23','2028-10-1'),
('215','632525193806222516','9497525109036','33413247.208','1971-5-29','2029-1-30'),
('216','621121198801203802','9193649533749','17436612.02','1975-8-14','2039-2-18'),
('217','520324196803023967','7891197867221','50152059.7','1989-8-17','2028-4-24'),
('218','620421195709066253','9729801234646','33658577.24','2001-5-2','2029-7-24'),
('219','150105196407293739','9586067803647','99052067.373','2016-2-12','2044-5-20'),
('220','520324196803023967','9838024065809','46601050.19','2012-5-13','2042-5-25'),
('221','150825196002053132','0783068180704','94306432.747','2005-7-20','2030-3-29'),
('222','632525193806222516','5942745709641','55803592.301','1982-2-28','2040-9-18'),
('223','621121198801203802','1105285964116','22376178.469','1988-4-14','2027-8-7'),
('224','621021199601042142','7510122653609','3424730.411','1996-1-13','2020-7-21'),
('225','632525193806222516','1857484442062','17950243.645','2019-11-3','2021-1-29'),
('226','32092519791217009X','7022127216944','38878468.018','2020-9-13','2041-8-15'),
('227','632525193806222516','4524475812042','64554121.84','1986-6-4','2037-1-13'),
('228','632525193806222516','1560155004590','93852340.868','1987-10-25','2048-6-29'),
('229','520324196803023967','7193839283421','60494034.397','1978-6-21','2039-4-16'),
('230','410300197803130226','4527443786029','54186206.014','2021-3-9','2036-3-24'),
('231','632525193806222516','3312243183456','66318505.822','1970-6-22','2042-6-4'),
('232','520324196803023967','1607295120635','53599494.564','2012-2-21','2042-7-26'),
('233','632525193806222516','7130768422370','73233872.892','2011-6-22','2033-12-9'),
('234','640500193507124572','9057366580908','22650628.57','1983-1-21','2039-2-28'),
('235','371721196511115646','5876520645693','49318812.103','2023-1-5','2037-7-22'),
('236','210112196912222763','0314803871445','58501404.487','1975-7-31','2026-6-2'),
('237','632822198110172776','5759824086061','41943945.028','1990-10-1','2039-11-7'),
('238','150105196407293739','2818274497292','71815715.462','2015-9-22','2045-5-20'),
('239','130202200204031722','2135790453549','98067893.825','1973-7-30','2043-6-25'),
('240','150825196002053132','2196178356504','23135955.888','1970-12-12','2021-6-15'),
('241','230230199406300699','9721998836308','48705880.551','1978-10-25','2044-7-20'),
('242','620421195709066253','8899237893032','94640138.985','2022-3-21','2031-1-19'),
('243','632323195703136688','2058143673669','82931036.013','1995-10-21','2021-5-31'),
('244','410300197803130226','2049309513241','63043947.917','2001-4-10','2029-1-18'),
('245','520324196803023967','2616123650325','8416648.237','2014-11-7','2048-7-26'),
('246','621021199601042142','1441273455257','66848268.126','1996-12-28','2027-11-15'),
('247','632323195703136688','0551845238147','69522357.977','1987-9-11','2040-10-2'),
('248','130202200204031722','0585550950920','14281835.773','1987-8-12','2034-6-28'),
('249','451424193605287480','2067290826679','21269432.86','1972-10-25','2028-3-8'),
('250','410823193310252405','0510201450840','51701359.459','2022-8-10','2048-4-24'),
('251','421222199109146863','8946617779978','46360909.49','1989-12-7','2027-10-28'),
('252','421222199109146863','8303458676212','40184178.408','2015-4-9','2042-7-7'),
('253','150825196002053132','5222180897667','83552752.86','1992-12-8','2044-8-6'),
('254','621121198801203802','1558169411614','80233072.582','2000-8-28','2043-9-6'),
('255','500114196703015516','9867811870404','37956481.008','2003-1-9','2038-7-20'),
('256','451424193605287480','2139101298628','80521647.025','2001-7-7','2025-4-26'),
('257','500104194306074676','7641437640619','46612863.088','1979-1-16','2020-8-21'),
('258','620421195709066253','8835779713943','55674974.175','1988-4-14','2021-12-1'),
('259','150105196407293739','4771798520712','55079974.721','1991-3-5','2043-7-1'),
('260','632323195703136688','2743523362669','27054999.629','2005-1-19','2039-1-28'),
('261','341800198708146312','5762808098171','62488100.184','1998-3-5','2040-5-5'),
('262','451424193605287480','9151683985970','31525587.687','2022-3-14','2025-7-28'),
('263','410823193310252405','0332982681087','26860451.749','1995-11-16','2025-11-15'),
('264','421222199109146863','6260068066048','74747866.732','1980-11-20','2026-1-18'),
('265','620421195709066253','5590198102387','46360263.253','1977-2-5','2021-11-18'),
('266','451402196110177138','3915246126270','96677631.17','1989-3-19','2024-12-29'),
('267','522300193312169328','4675512052173','6612612.928','1980-7-6','2020-7-10'),
('268','500104194306074676','8921536375120','2043679.336','1981-5-3','2042-1-27'),
('269','370827200203273871','7622400299444','7380256.064','2014-6-22','2025-12-7'),
('270','451402196110177138','6181555710460','58832416.265','1992-11-11','2049-11-9'),
('271','421222199109146863','5572318512513','55885418.126','1986-9-22','2039-2-7'),
('272','421222199109146863','2524505851901','20211799.874','1997-5-3','2047-3-25'),
('273','520324196803023967','4370684218188','27345765.797','1998-12-31','2037-1-13'),
('274','632323195703136688','0077079913182','86489784.433','1982-1-21','2035-1-21'),
('275','150105196407293739','2107755712069','69421145.339','1994-7-15','2040-10-11'),
('276','370827200203273871','5493742427158','41453708.668','2015-3-4','2035-8-22'),
('277','621021199601042142','9325996862888','11358971.543','1983-2-1','2034-5-21'),
('278','632323195703136688','1712106769110','87618087.47','1993-5-8','2040-6-19'),
('279','410300197803130226','4283003961776','95636818.049','1984-11-30','2024-12-1'),
('280','230230199406300699','8805375071059','70668376.865','2019-3-27','2026-9-19'),
('281','620421195709066253','7830470456115','95309791.011','1972-9-23','2045-2-14'),
('282','620421195709066253','6810326995173','38520848.26','1978-11-3','2044-8-15'),
('283','451402196110177138','6176668658908','64751319.817','1972-12-24','2038-5-20'),
('284','632323195703136688','1360854675905','11864068.494','2005-1-13','2038-1-13'),
('285','150825196002053132','2670053734144','54252497.897','2000-3-11','2032-1-5'),
('286','520324196803023967','5765421377880','77909646.712','1990-8-19','2041-6-21'),
('287','621021199601042142','2261960192152','41165103.582','2015-4-21','2047-11-15'),
('288','150825196002053132','4673940417891','40175549.38','1970-1-4','2038-5-4'),
('289','621021199601042142','8496316601014','56075287.811','2011-12-2','2043-7-28'),
('290','410300197803130226','5086424288195','28821197.343','2012-4-26','2036-2-29'),
('291','640500193507124572','7474767096110','43470414.359','2017-5-9','2043-8-10'),
('292','620421195709066253','7303862816096','18670905.373','2004-4-28','2024-11-28'),
('293','130202200204031722','3707900592096','73385454.011','2014-7-29','2025-8-22'),
('294','621021199601042142','2795689742944','51308771.299','1971-1-22','2041-9-14'),
('295','500104194306074676','8672731376736','36918231.119','1985-4-29','2022-6-18'),
('296','341800198708146312','2805417775099','44132860.019','2006-9-23','2036-6-4'),
('297','621121198801203802','0334097276208','88425802.471','1984-9-16','2050-1-22'),
('298','632525193806222516','0708893238370','28453266.517','1998-7-22','2026-7-5'),
('299','410300197803130226','4604677099196','12669970.702','2002-10-15','2038-7-12'),
('300','621121198801203802','5220607459173','19713555.401','1974-8-12','2027-7-20'),
('301','500114196703015516','3583403284025','80967818.213','2023-5-15','2021-6-30'),
('302','451424193605287480','2278589402602','25754210.05','2023-9-24','2038-12-26'),
('303','500104194306074676','9314166040596','84655453.476','2023-8-4','2025-1-25'),
('304','451402196110177138','1229768206244','66505398.416','2023-12-19','2045-11-21'),
('305','230230199406300699','9623727919708','7083376.488','2023-1-15','2032-7-11'),
('306','621121198801203802','1815965438561','58696167.935','2023-4-30','2025-11-22'),
('307','500104194306074676','0630521176447','96543049.257','2023-11-23','2031-2-9'),
('308','230230199406300699','0433228356754','70881208.833','2023-6-4','2038-12-3'),
('309','421222199109146863','5406119941001','99619296.028','2023-3-6','2023-4-10'),
('310','500104194306074676','6663313371477','31965075.726','2023-8-14','2037-5-13'),
('311','632525193806222516','3282213501958','72172720.02','2023-11-6','2029-6-17'),
('312','632822198110172776','8014788050652','7100947.777','2023-9-21','2045-1-9'),
('313','632525193806222516','3676203763846','96849282.449','2023-9-29','2023-1-8'),
('314','621121198801203802','9239745743956','6853833.063','2023-3-12','2035-7-25'),
('315','150105196407293739','2430335326415','78773686.303','2023-5-27','2030-6-28'),
('316','410300197803130226','5778796998836','61884863.782','2023-5-10','2027-2-25'),
('317','451402196110177138','8156996580314','34264507.814','2023-10-21','2030-3-18'),
('318','520324196803023967','9547872499337','69188383.654','2023-11-12','2031-9-22'),
('319','421222199109146863','7132340036637','67827205.236','2023-6-25','2045-1-25'),
('320','620421195709066253','8094559502148','94886428.144','2023-6-11','2034-4-29'),
('321','32092519791217009X','7329849255342','46030168.377','2023-2-1','2038-11-17'),
('322','640500193507124572','6054765579723','16405359.355','2023-1-1','2035-9-7'),
('323','621021199601042142','2751336210356','33225122.356','2023-2-18','2026-10-29'),
('324','621021199601042142','2787436127993','95435685.263','2023-7-26','2048-12-2'),
('325','451424193605287480','0986677747012','5098091.013','2023-7-21','2045-5-17'),
('326','410300197803130226','4740738367972','22352111.886','2023-11-11','2029-7-15'),
('327','410823193310252405','1593296283359','9955322.047','2023-11-11','2030-1-19'),
('328','522300193312169328','8051043206122','69450166.589','2023-1-20','2037-10-13'),
('329','210112196912222763','2136036114317','47542001.302','2023-1-5','2038-9-30'),
('330','500104194306074676','9961812737087','71108287.519','2023-3-7','2037-8-19')