Skip to content

GitLab

Last edited by songzp
Page history
This is an old version of this page. You can view the most recent version or browse the history.

law_office

数据来源

主体类型

company_major_type: 6

爬虫相关

爬虫工作流转表

主要业务字段

字段名 注释 样例
company_name 律师事务所名称 北京市尚权律师事务所
en_name 事务所英文名称 BEIJING SHANGQUAN LAW OFFICE
credit_no 统一信用代码 31110000794050586D
license_no 执业证号 21101200610293137
province_short 省份（英文缩写） BJ
company_type 类型 律师事务所
legal_person 负责人 毛立新
establish_date 成立日期 2006/9/15
company_address 联系地址 北京市东城区北三环东路36号环球贸易中心B座1703室
capital 注册资金(万元) 60万元
company_status 执业状态 正常
phone 电话 010-58256011
fax 传真 010-58256077
e_mail E-mail shangquan@sqxb.com
lawyer_num 律师人数 20
brief_introduction 简介 北京市尚权律师事务所,专门从事刑事辩护业务的律师事务所.业务范围:职务犯罪预防培训、刑事案件咨询、侦查阶段法律帮助、刑事辩护、死刑复核程序介入。代理：刑事附带民事代理、刑事自诉代理。
organizer 主管司法局 东城区司法局
issue_date 发证日期 2009/5/13
composion_form 组成形式 普通合伙
web_url 事务所主页 http://www.sqxb.com

上线MongoDB数据格式

中国法律服务网

{
    "companyinfo_item": {
        "company_name": "重庆道润律师事务所",
        "credit_no": "31500000552049937N",
        "establish_date": "2010-05-13",
        "company_address": "重庆市北部新区高新园区宝华大道10号1幢1区17-6、17-7、17-8、17-9、17-10",  # 有district字段的把district拼接在地址前面
        "phone": "023-67686602",
        "fax": "023-67686602",
        "lawyer_num": 5,
        "license_no": "25001201010281592",
        "brief_introduction": "",
        "company_type": "律师事务所",
        "company_major_type": 6,
        "data_source": 1,
        "data_status": 1,
        "create_time": "2021-08-21 13:58:00",
        "lastupdatetime": "2021-08-21 13:58:00",
        
    },
    "spider_name": "law_office",
    "task_params": {
        "platform": "law_office",
        "data_type": "list"
    },
    "task_result": 1000,
    "spider_start_time": "2021-08-20 13:14:27.338",
    "spider_end_time": "2021-08-20 13:16:30.341"
}

北京市司法局律师管理系统律所查询

{
    "companyinfo_item": {
        "company_name": "北京市尚权律师事务所",
        "en_name": "BEIJING SHANGQUAN LAW OFFICE",
        "credit_no": "31110000794050586D",
        "company_address": "北京市东城区北三环东路36号1号楼B1703",
        "organizer": "东城区司法局",
        "issue_date": "2009-05-13",
        "company_status": "正常",
        "capital": "60.0万元",
        "legal_person": "毛立新",
        "composion_form": "普通合伙",
        "e_mail": "shangquan@sqxb.com",
        "web_url": "http://www.sqxb.com",
        "phone": "010-58256011",
        "fax": "010-58256077",
        "brief_introduction": "北京市尚权律师事务所,专门从事刑事辩护业务的律师事务所.业务范围:职务犯罪预防培训、刑事案件咨询、侦查阶段法律帮助、刑事辩护、死刑复核程序介入。代理：刑事附带民事代理、刑事自诉代理。",
        "company_type": "律师事务所",
        "company_major_type": 6,
        "data_source": 1,
        "data_status": 1,
        "create_time": "2021-08-21 13:58:00",
        "lastupdatetime": "2021-08-21 13:58:00",
        
    },
    "spider_name": "bj_law_office",
    "task_params": {
        "platform": "bj_law_office",
        "data_type": "list"
    },
    "task_result": 1000,
    "spider_start_time": "2021-08-20 13:14:27.338",
    "spider_end_time": "2021-08-20 13:16:30.341"
}

上海法网

{
    "companyinfo_item": {
        "company_name": "北京市金杜律师事务所上海分所",
        "org_code": "13211216X",
        "credit_no": "3131000013211216XE", # 通过组织机构代码查询出统一信用代码
        "company_address": "淮海中路999号环贸广场一期16-18楼",
        "legal_person": "聂卫东",
        "company_status": "正常",
        "composion_form": "特殊的普通合伙",
        "organizer": "长宁区司法局",
        "company_type": "律师事务所",
        "company_major_type": 6,
        "data_source": 1,
        "data_status": 1,
        "create_time": "2021-08-21 13:58:00",
        "lastupdatetime": "2021-08-21 13:58:00",
        
    },
    "spider_name": "sh_law_office",
    "task_params": {
        "platform": "sh_law_office",
        "data_type": "list"
    },
    "task_result": 1000,
    "spider_start_time": "2021-08-20 13:14:27.338",
    "spider_end_time": "2021-08-20 13:16:30.341"
}

特殊主体库表结构

CREATE TABLE `special_law_office` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键',
  `province_short` varchar(5) DEFAULT NULL COMMENT '省份（英文缩写）',
  `company_name` varchar(255) NOT NULL COMMENT '律师事务所名称',
  `company_id` char(32) NOT NULL COMMENT '主体唯一键',
  `en_name` varchar(255) DEFAULT NULL COMMENT '事务所英文名称',
  `credit_no` varchar(50) DEFAULT NULL COMMENT '统一信用代码',
  `license_no` varchar(50) DEFAULT NULL COMMENT '执业证号',
  `company_type` varchar(50) DEFAULT NULL COMMENT '类型',
  `legal_person` varchar(255) DEFAULT NULL COMMENT '负责人',
  `establish_date` date DEFAULT NULL COMMENT '成立日期',
  `company_address` varchar(300) DEFAULT NULL COMMENT '联系地址',
  `capital` varchar(50) DEFAULT NULL COMMENT '注册资金(万元)',
  `company_status` varchar(50) DEFAULT NULL COMMENT '执业状态',
  `phone` varchar(50) DEFAULT NULL COMMENT '电话',
  `fax` varchar(50) DEFAULT NULL COMMENT '传真',
  `e_mail` varchar(100) DEFAULT NULL COMMENT 'E-mail',
  `lawyer_num` int(11) DEFAULT NULL COMMENT '律师人数',
  `brief_introduction` varchar(255) DEFAULT NULL COMMENT '简介',
  `organizer` varchar(100) DEFAULT NULL COMMENT '主管司法局',
  `issue_date` date DEFAULT NULL COMMENT '发证日期',
  `composion_form` varchar(100) DEFAULT NULL COMMENT '组成形式',
  `web_url` varchar(255) DEFAULT NULL COMMENT '事务所主页',
  `use_flag` tinyint(4) DEFAULT NULL COMMENT '使用标记，0有效，10废弃删除',
  `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '入库时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_digest` (`company_id`),
  KEY `idx_company_name` (`company_name`),
  KEY `idx_credit_no` (`credit_no`),
  KEY `idx_create_time` (`create_time`),
  KEY `idx_update_time` (`update_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8