Windshield recycling PATSTAT data

The dataset includes several Excel sheets, each listing the records obtained from Patstat online database (https://data.epo.org/expert-services/index.html) by means of SQL queries run in Patstat online (Autumn 2017 ed.). Such investigation is aimed at retrieving patent documents data including in particular: • the individual patent application identification code (appln_id attribute in the table), • the application authorities (i.e. the patent offices to whom the patent applications are filed), • the earliest filing year, • the docdb_family_id code univocally identifying a single patent family (a.k.a. DOCDB family), • the patent applications titles and abstracts, • the classification codes (IPC and CPC, respectively) assigned to each patent application, • the patent publication authority, • the patent publication number, • the patent publication kind, • the denomination of each assignee/applicant (psn_name) and • the type of applicant (psn_sector allowing for distinguishing companies, universities, individuals etc. among applicants/assignees). PDF files (named as the corresponding Excel) may be present. Each provides lists of the documents downloadable from PATSTAT online. The number of documents corresponds to the amount of non-duplicated appln_id values (eg. 1125 for PHASE A in the pdf, as arguable from the PHASE A Excel file). URLs are provided for each record to link to Espacenet (https://worldwide.espacenet.com/) • PHASE A TABLE concern a broad search regarding glass recycling. • PHASE B concerns a more specific search, based on keywords AND IPC/CPC codes, regarding recycling of laminated glass by means of mechanical comminution. Data rather based on keywords are argued from PHASE B_query A. Records selected by means of cpc code Y02W30/521 are included in PHASE B Query B TABLE. • PHASE C Query C1 TABLE concerns recycling of glass with poly-vinyl-butyral interlayer (PVB) • PHASE C Query C2’ TABLE concerns recycling of glass with ethyl-vinyl-acetate interlayer (EVA) • PHASE C Query C2’’ TABLE concerns recycling of glass with (thermoplastic) poly-urethane interlayer (TPU). One file with SQL scripts not detailed in other publications is included (PATSTAT SCRIPTS). The file contains two scripts to be run with Patstat: the former is aimed at ranking the patent families depending on the co-occurrence of IPC classification codes, while the latter is aimed at ranking the granted patents depending on the number of annual fee payments and the date of patent validity expiration. SQL scripts are included in a manuscript submitted to Data in Brief journal, accompanying the manuscript submitted to World Patent Information for review (WPI_2018_95 _R1).本数据集包含多个Excel工作表，每张工作表均收录了通过在2017年秋季版Patstat在线数据库（Patstat online, Autumn 2017 ed.）中运行SQL查询，从Patstat官方在线数据库（https://data.epo.org/expert-services/index.html）获取的记录。本调研的目标为检索专利文献数据，具体涵盖以下内容： • 单条专利申请的识别码（对应数据表中的appln_id属性） • 专利申请的受理机构（即提交专利申请的专利局） • 最早申请年份 • 用于唯一标识单个专利家族的docdb_family_id代码（又称DOCDB家族） • 专利申请的标题与摘要 • 分配给每条专利申请的分类代码（分别为IPC分类号与CPC分类号） • 专利公开机构 • 专利公开号 • 专利公开类型 • 各专利权人/申请人的名称（psn_name） • 申请人所属类型（psn_sector，用于区分企业、高校、个人等不同申请人/专利权人群体）。 部分工作表可能配有与工作表同名的PDF文件，其中列出了可从Patstat在线数据库下载的文献列表，文献总数与去重后的appln_id值数量一致（例如PHASE A对应的PDF文件包含1125条记录，可通过PHASE A的Excel文件验证）。每条记录均提供了指向Espacenet专利检索平台（https://worldwide.espacenet.com/）的链接。 各阶段数据集详情如下： • PHASE A数据表：针对玻璃回收领域的广谱检索结果。 • PHASE B：基于关键词与IPC/CPC分类号的精准检索，聚焦采用机械粉碎工艺的夹层玻璃回收场景。其中，仅通过关键词筛选得到的数据集来自PHASE B_query A；通过CPC分类号Y02W30/521筛选出的记录收录于PHASE B Query B数据表。 • PHASE C Query C1数据表：针对含聚乙烯醇缩丁醛（PVB）夹层的玻璃回收相关研究。 • PHASE C Query C2’数据表：针对含乙烯-醋酸乙烯酯（EVA）夹层的玻璃回收相关研究。 • PHASE C Query C2’’数据表：针对含（热塑性）聚氨酯（TPU）夹层的玻璃回收相关研究。 本数据集还包含一份未在其他出版物中详述的SQL脚本文件（PATSTAT SCRIPTS），其中包含两段可在Patstat环境中运行的脚本：第一段用于基于IPC分类号的共现情况对专利家族进行排序，第二段则用于基于年费缴纳次数与专利有效期截止日期对授权专利进行排序。 上述SQL脚本已随两篇投稿论文一并提交：一篇投稿至《Data in Brief》期刊，另一篇投稿至《World Patent Information》期刊进行同行评审（稿件编号：WPI_2018_95_R1）。