Greetings to the Verified Database Network.
Thanks for checking us out, and have fun downloading SHGA PartialDump, we just released!
In approximately August 2022, Shanghai SHGA Police breached by ChinaDan. Not: This is partial data not full data, full data is consist of different tables: 1. Chinese Users (980m users) 2. Police Case Data (1b+ records) 3. Delivery Orders (this is 22TB data). Credit to @ChinaDan
Password: leakeddatabases.com
Source: Shanghai SHGA Police
Amount: 750k
File Formatting: JSON
Sample of address_merge_with_mobile_data:
{"_source":{"APP_TYPE":"1229999","ATTR_IDENT_LABEL":"07","ATTR_IDENT_LABEL_DETL":"{"LABEL_DETL":[{"07":"shga_wa.ods_nb_tab_goods"}]}","BIG_SOURCE":"WA","COUNT":"3","DATA_SOURCE":"115","DETAIL":"{"nameinfo":[{"name":"刘婵女士"}]}","FIRST_TIME":"1562126476","IDENTITY_TYPE":"mobile","IDENTITY_VALUE":"18627855112","LAST_TIME":"1562557677","MRG_ID":"cda7c53c06248628cd33777dff71d9a3","SRC_ADDRESS":"智慧e谷大楼(5楼)","SRC_ID":"cda7c53c06248628cd33777dff71d9a3","TABLE_SOURCE":"shga_wa.ods_nb_tab_goods"},"_type":"a","sort":[33150]}
{"_source":{"APP_TYPE":"1240002","ATTR_IDENT_LABEL":"07","ATTR_IDENT_LABEL_DETL":"{"LABEL_DETL":[{"07":"shga_wa.ods_nb_app_icpoof_delivery"}]}","BIG_SOURCE":"WA","COUNT":"1","DATA_SOURCE":"115","DETAIL":"{"nameinfo":[{"name":"蔡达芳"}]}","FIRST_TIME":"1598073511","IDENTITY_TYPE":"mobile","IDENTITY_VALUE":"18608531229","LAST_TIME":"1598073511","MRG_ID":"91171627c7237c4fe531fa45cd013d43","SRC_ADDRESS":"贵州省安顺市贵州省/安顺市/普定县贵州省贵州省安顺市普定县城关镇红旗路新天地","SRC_ID":"91171627c7237c4fe531fa45cd013d43","TABLE_SOURCE":"shga_wa.ods_nb_app_icpoof_delivery"},"_type":"a","sort":[33150]}
{"_source":{"APP_TYPE":"1240002","ATTR_IDENT_LABEL":"07","ATTR_IDENT_LABEL_DETL":"{"LABEL_DETL":[{"07":"shga_wa.ods_nb_app_icpoof_expressdelivery"}]}","BIG_SOURCE":"WA","COUNT":"15","DATA_SOURCE":"115","DETAIL":"{"nameinfo":[{"name":"胡**"}]}","FIRST_TIME":"1552456962","IDENTITY_TYPE":"mobile","IDENTITY_VALUE":"176****5368","LAST_TIME":"1576833954","MRG_ID":"7fee05e2d44d366826d211adc75b6c86","SRC_ADDRESS":"浙江省湖州市吴兴区织里镇大河新村1区49-6后门","SRC_ID":"7fee05e2d44d366826d211adc75b6c86","TABLE_SOURCE":"shga_wa.ods_nb_app_icpoof_expressdelivery"},"_type":"a","sort":[33150]}
{"_source":{"APP_TYPE":"1240002","ATTR_IDENT_LABEL":"07","ATTR_IDENT_LABEL_DETL":"{"LABEL_DETL":[{"07":"shga_wa.ods_nb_app_icpoof_expressdelivery"}]}","BIG_SOURCE":"WA","COUNT":"1","DATA_SOURCE":"115","DETAIL":"{"nameinfo":[{"name":"严栎"}]}","FIRST_TIME":"1575267531","IDENTITY_TYPE":"mobile","IDENTITY_VALUE":"15147681115","LAST_TIME":"1575267531","MRG_ID":"d7756953439d146c6ff883e4e4cb9440","SRC_ADDRESS":"内蒙古自治区赤峰市内蒙古自治区.赤峰市.新城区如意家园东门南走松山农商银行","SRC_ID":"d7756953439d146c6ff883e4e4cb9440","TABLE_SOURCE":"shga_wa.ods_nb_app_icpoof_expressdelivery"},"_type":"a","sort":[33150]}
{"_source":{"APP_TYPE":"1240002","ATTR_IDENT_LABEL":"07","ATTR_IDENT_LABEL_DETL":"{"LABEL_DETL":[{"07":"shga_wa.ods_nb_app_icpoof_expressdelivery"}]}","BIG_SOURCE":"WA","COUNT":"1","DATA_SOURCE":"115","DETAIL":"{"nameinfo":[{"name":"赵**"}]}","FIRST_TIME":"1575594385","IDENTITY_TYPE":"mobile","IDENTITY_VALUE":"138****8850","LAST_TIME":"1575594385","MRG_ID":"a61f5cf0e9624b0339491f463f07ffe6","SRC_ADDRESS":"北京北京市顺义区胜利街道怡磬家园15号楼5门702","SRC_ID":"a61f5cf0e9624b0339491f463f07ffe6","TABLE_SOURCE":"shga_wa.ods_nb_app_icpoof_expressdelivery"},"_type":"a","sort":[33150]}
Sample of case data:
{"_id":"AW5jztHfLFOCNVwb7b7a","_index":"nb_theme_address_case_dwd-total","_score":null,"_source":{"ADDR_DETL":"{"CASE":{"BRIEF_CASE":"2010年8月23日10时26分,王斌(男,户籍地址:上海市徐汇区梅陇六村6号401室,现住地址:上海市闵行区罗秀路1339弄29号801室,身份证号码:310104198211137219)拨打"110"报警称:2010年8月23日10时,其在上海市闵行区梅陇镇行南村11队3号电脑工作室内发现电脑显示器7台、电脑机箱8台被盗。民警到场,通知刑队到场后,告知报警人到所报案。","CASE_TYPE":null,"CASE_STATE":null},"ORGANIZER_POLICE_TYPE":null,"ORGANIZER":{"ORGANIZER_NAME":null,"ORGANIZER_AREA":null},"TIME":{"ACCEPTANCE_TIME":null,"REGISTER_TIME":null,"CLOSING_TIME":null,"PUNISH_TIME":null,"CASE_TIME":null,"REPORT_TIME":null},"ACCEPTANCE_UNIT_JSON":{"ACCEPTANCE_UNIT_NUMBER":null,"ACCEPTANCE_UNIT_NAME":null},"TABLE_SOURCE":"shga_dwd.base_wsba_hx_a_jbxx_df","CASE_ADDRESS":"上海市闵行区梅陇镇行南村11队3号"}","ADDR_TYPE":"01","BLOCK_L4":"梅陇镇","CASE_NUMBER":"B3101124100002010081664","CITY_L2":"上海市","COUNTY_L3":"闵行区","LOC_SOURCE":"1","MCS_ID":"0256c65a2aea0df198f3623da0cdad49","NUMBER_L7":"3号","PROVINCE_L1":"上海市","STD_ADDRESS":"上海市上海市闵行区梅陇镇3号"},"_type":"a","sort":[26091]}
{"_id":"AW5jzHSecR021UzXCID1","_index":"nb_theme_address_case_dwd-total","_score":null,"_source":{"ADDR_DETL":"{"CASE":{"BRIEF_CASE":"2014年12月1日20时许,报案人罗友军来所报案,2014年11月29日15时许,其在本市普陀区枣阳路465弄21号门口与一男子发生纠纷,被该男子殴打一拳,打在其右侧脸部,后该男子逃走。2014年12月1日,其到普陀区中心医院检查为外伤性鼓膜穿孔,故到所报案。","CASE_TYPE":null,"CASE_STATE":null},"ORGANIZER_POLICE_TYPE":null,"ORGANIZER":{"ORGANIZER_NAME":null,"ORGANIZER_AREA":null},"TIME":{"ACCEPTANCE_TIME":null,"REGISTER_TIME":null,"CLOSING_TIME":null,"PUNISH_TIME":null,"CASE_TIME":null,"REPORT_TIME":null},"ACCEPTANCE_UNIT_JSON":{"ACCEPTANCE_UNIT_NUMBER":null,"ACCEPTANCE_UNIT_NAME":null},"TABLE_SOURCE":"shga_dwd.base_wsba_hx_a_ajjbqk_df","CASE_ADDRESS":"上海市普陀区枣阳路465弄21号门口"}","ADDR_TYPE":"02","BLOCK_L4":"长风新村街道","BUILDING_L9":"21号","CASE_NAME":"罗友军被殴打案","CASE_NUMBER":"C3101075700002014120057","CITY_L2":"上海市","CONFIDENCE":"5","COUNTY_L3":"普陀区","GEOHASH7":"wtw3dt2","GEOHASH8":"wtw3dt2e","GEOHASH9":"wtw3dt2es","LATITUDE":"31.230651","LOC_SOURCE":"0","LONGITUDE":"121.399804","MCS_ID":"b97b8f4cf9a621c2d8121217e5e126cc","NONG_L6":"465弄","PROVINCE_L1":"上海市","ROAD_L5":"枣阳路","STD_ADDRESS":"上海市上海市普陀区长风新村街道枣阳路465弄21号"},"_type":"a","sort":[26091]}
{"_id":"AW5jyqdftfclQ77Vahnj","_index":"nb_theme_address_case_dwd-total","_score":null,"_source":{"ADDR_DETL":"{"CASE":{"BRIEF_CASE":"2018-05-16 23:05:57,手机号:15317001758,报警人在仓汇路1345弄东门口,称:苏A278A1 挪车","CASE_TYPE":null,"CASE_STATE":null},"ORGANIZER_POLICE_TYPE":null,"ORGANIZER":{"ORGANIZER_NAME":null,"ORGANIZER_AREA":null},"TIME":{"ACCEPTANCE_TIME":null,"REGISTER_TIME":null,"CLOSING_TIME":null,"PUNISH_TIME":null,"CASE_TIME":null,"REPORT_TIME":"2018-05-16 23:05:57"},"ACCEPTANCE_UNIT_JSON":{"ACCEPTANCE_UNIT_NUMBER":null,"ACCEPTANCE_UNIT_NAME":null},"TABLE_SOURCE":"shga_dwd.base_xwsba_case_gg_jqxx_df","CASE_ADDRESS":"仓汇路1345弄东门口"}","ADDR_TYPE":"01","CASE_NUMBER":"20180516230557937016","CITY_L2":"上海市","COUNTY_L3":"松江区","LOC_SOURCE":"0","MCS_ID":"9be691c89f13ff9314bf08f651eff9a7","NONG_L6":"1345弄","PROVINCE_L1":"上海市","ROAD_L5":"仓汇路","STD_ADDRESS":"上海市上海市松江区仓汇路1345弄"},"_type":"a","sort":[26091]}
{"_id":"AW5jyySo2-_qJnb6UtuU","_index":"nb_theme_address_case_dwd-total","_score":null,"_source":{"ADDR_DETL":"{"CASE":{"BRIEF_CASE":"设法联系车主将车驶离","CASE_TYPE":null,"CASE_STATE":null},"ORGANIZER_POLICE_TYPE":null,"ORGANIZER":{"ORGANIZER_NAME":null,"ORGANIZER_AREA":null},"TIME":{"ACCEPTANCE_TIME":null,"REGISTER_TIME":null,"CLOSING_TIME":null,"PUNISH_TIME":null,"CASE_TIME":null,"REPORT_TIME":null},"ACCEPTANCE_UNIT_JSON":{"ACCEPTANCE_UNIT_NUMBER":null,"ACCEPTANCE_UNIT_NAME":null},"TABLE_SOURCE":"shga_dwd.base_wsba_hx_a_jbxx_df","CASE_ADDRESS":"上海市闵行区"}","ADDR_TYPE":"01","CASE_NUMBER":"20180106123559794010","LOC_SOURCE":"1","MCS_ID":"8d913e2285740dfd24b43abcac27f87c"},"_type":"a","sort":[26091]}
{"_id":"AW5jxpKUy8Qm8bx7q1wn","_index":"nb_theme_address_case_dwd-total","_score":null,"_source":{"ADDR_DETL":"{"CASE":{"BRIEF_CASE":"2014年09月12日16时51分,报警人王正芳使用13817262927拨打110报警称:其前夫钱龙详(身份证:310225195711201217)在外欠债,有欠条,债主现带4-5个人在其位于上海市浦东新区周浦镇牛桥村周泰路32弄12号802室讨债,但其称已与前夫离婚,与其无关。但债主称2个月前报警人在以前的住处答应其会还清欠款的。故现场双方发生债务纠纷。rn民警到场,系债务纠纷,现经民警工作,现场暂时平息。","CASE_TYPE":null,"CASE_STATE":null},"ORGANIZER_POLICE_TYPE":null,"ORGANIZER":{"ORGANIZER_NAME":null,"ORGANIZER_AREA":null},"TIME":{"ACCEPTANCE_TIME":null,"REGISTER_TIME":null,"CLOSING_TIME":null,"PUNISH_TIME":null,"CASE_TIME":null,"REPORT_TIME":null},"ACCEPTANCE_UNIT_JSON":{"ACCEPTANCE_UNIT_NUMBER":null,"ACCEPTANCE_UNIT_NAME":null},"TABLE_SOURCE":"shga_dwd.base_wsba_hx_a_jbxx_df","CASE_ADDRESS":"上海市浦东新区周浦镇牛桥村周泰路32弄12号802室"}","ADDR_TYPE":"01","BLOCK_L4":"周浦镇","BUILDING_L9":"12号","CASE_NUMBER":"B3101158500002014090251","CITY_L2":"上海市","CONFIDENCE":"5","COUNTY_L3":"浦东新区","GEOHASH7":"wtw2zjg","GEOHASH8":"wtw2zjgd","GEOHASH9":"wtw2zjgdy","LATITUDE":"31.101418","LOC_SOURCE":"0","LONGITUDE":"121.601765","MCS_ID":"ba6250261017a8e1a8d8894523e99d0c","NONG_L6":"32弄","PROVINCE_L1":"上海市","ROAD_L5":"周泰路","ROOM_L12":"802室","STD_ADDRESS":"上海市上海市浦东新区周浦镇周泰路32弄12号802室"},"_type":"a","sort":[26091]}
Sample of person_info:
{"_id":"AXtapGbijcEAuoI0lDsp","_index":"person_address_label_info_master","_score":null,"_source":{"AGE":48,"BIRTHDAY":"1973","BPLACE":"吉林省吉林市磐石县","IDNO":"22022319730217702x","IDTYPE":"01","QUERY_STRING":" 吉林省吉林市磐石县 48 73 1973 ","RNAME":"崔太花","SEX":"女"},"_type":"a","sort":[6754190]}
{"_id":"AXtaqlGHjcEAuoI0v_NI","_index":"person_address_label_info_master","_score":null,"_source":{"AGE":45,"BIRTHDAY":"1976","BPLACE":"四川省重庆市綦江县","IDNO":"510223197609052714","IDTYPE":"01","QUERY_STRING":" 四川省重庆市綦江县 45 76 1976 ","RNAME":"朱廷力","SEX":"男"},"_type":"a","sort":[6754190]}
{"_id":"AXtamq1fgpreNtWiOa87","_index":"person_address_label_info_master","_score":null,"_source":{"AGE":26,"BIRTHDAY":"1995","BPLACE":"浙江省杭州市富阳市","HHPLACE":"杭州市富阳区大源镇骆村村秦骆661号","IDNO":"330183199512062613","IDTYPE":"01","PHOTO":"{"身份证":["http://oss-cn-shanghai-shga-d01-a.ops.ga.sh/shga-ryzp/CSJ/ZHEJIANG_CZRK_ZP/51853153_330111.jpg"]}","QUERY_STRING":" 浙江省杭州市富阳市 杭州市富阳区大源镇骆村村秦骆661号 26 95 1995 上海市上海市青浦区香花桥街道久远路1660弄24号102室","RNAME":"骆路峰","SEX":"男","STD_ADDRESS":"上海市上海市青浦区香花桥街道久远路1660弄24号102室"},"_type":"a","sort":[6754190]}
{"_id":"AXtaJ3qPy8Qm8bx7JyV5","_index":"person_address_label_info_master","_score":null,"_source":{"AGE":54,"BIRTHDAY":"1967","BPLACE":"四川省南充地区华蓥市","IDNO":"512902196708170058","IDTYPE":"01","QUERY_STRING":" 四川省南充地区华蓥市 54 67 1967 ","RNAME":"卿波","SEX":"男"},"_type":"a","sort":[6754190]}
{"_id":"AXtapFH4dfH-9WxV_Chm","_index":"person_address_label_info_master","_score":null,"_source":{"AGE":20,"BIRTHDAY":"2001","BPLACE":"辽宁省铁岭市开原市","HEIGHT":"170","IDNO":"211282200103310418","IDTYPE":"01","QUERY_STRING":" 辽宁省铁岭市开原市 20 01 2001 ","RNAME":"杨越铭","SEX":"男"},"_type":"a","sort":[6754190]}
