It also includes the legal event data from more than 40 patent authorities contained in the EPO worldwide legal event data (INPADOC). Patstat is a dataset from the European Patent Office (EPO) containing bibliographic and legal status patent data for statistical analysis. However, there is also an online version of PATSTAT that is free for the first two months if you wish to try it by signing up for the trial (knowledge of SQL required). PATSTAT contains bibliographical and legal event patent data from leading industrialised and developing countries. Virtual classroom, online. It presents eight MySQL queries that cover some of the most relevant aspects of the database for research purposes. an annual service fee for bulk data. This is extracted from the EPO’s databases. and conditions apply: Get the latest issues delivered direct to your inbox, First steps towards turning the vision into reality, See our learning resources about patent searching, Data Catalog – PATSTAT Global – 2020 Autumn Edition, Data Catalog - PATSTAT Global – 2020 Spring Edition, Data Catalog – PATSTAT EP Register – 2020 Autumn Edition, Data Catalog - PATSTAT EP Register – 2020 Spring Edition, Comparison of PATSTAT bulk data and PATSTAT Online, Coverage and completeness of bibliographical data, PATSTAT EP Register - 2018 Autumn Edition. 5.05 01-12-2015 Kracker Adaption to 2015 Spring - Amended Edition: See section 7 “History of major changes to tables and attributes”. This is extracted from the EPO’s databases and is either provided as bulk data or can be consulted online. The following terms If you have very specific needs for (large amounts of) patent data, PATSTAT might be the database you have been looking for. The EPO's PATSTAT database is of relevance in the field of patent intelligence and statistics. 2. With ten years of work on patent statistics, we have been used several versions of the patstat: Patstat 2008, 2009 and 2011; Patstat 2014, April (production database). This is extracted from the EPO’s databases and is either provided as bulk data or can be consulted online. Any existing or on-the-fly computed field can be retrieved and sorted. Name of the database Source of the database Short description; EPO Worldwide Patent Statistical Database (PATSTAT) European Patent Office; World: Bibliographic data, citations and family links of about 70 million patent applications of more than 80 countries. Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Build SQLite database. With PATSTAT you can: identify business opportunities; see what your competitors are doing; monitor trends in technology We offer a wide variety of licence options. PATSTAT Register. This script provides the ability to build an SQLite database from the Patstat2017b data, but it does not provide the data itself. 2015 Autumn Edition) and the database (e.g. It offers guided examples of ten popular queries that are relevant for research purposes and that cover the most important data tables. VERSION 2.2.8 – Changes in PATSTAT Online and GPI: PATSTAT Online: The 2016 Spring Edition is now available. It is targeted at academic researchers and practitioners willing to learn the basics of the database. Target groups IP authorities, patent offices, civil … In addition, the performance of PATSTAT usage was dependent on hardware capability. The simple and Extended family are contained and pre-calculated. In general, PATSTAT Register is very attractive for researchers interested in particular procedural aspects or dynamics concerning ownership, inventorship and legal representation of EP publications. GPI: The date range operator is now available, e.g. PATSTAT Online (September 2020) INPADOC worldwide legal event database (September 2020) It helps you perform sophisticated statistical analyses of bibliographical and legal event patent data. Each provides lists of the documents downloadable from PATSTAT online. PATSTAT Global contains bibliographical data relating to more than 100 million patent documents from leading industrialised and developing countries. This webinar introduces PATSTAT Online, the EPO's database for statistical analysis of patent data, and its new beginners' Interface. The PATSTAT product line consists of two individual databases. This article provides an introduction to the Patstat patent database. It targets academic researchers and practitioners who are familiar with the PATSTAT database and the MySQL language. EPO, Patent Information Promotion & Training; Working language(s) English. All T-SQL wildcard characters and operators are possible. Any other patent family can be calculated and used based on their definition. Organised by. The PATSTAT product line consists of two individual databases. The main barrier to using PATSTAT is the need to run and maintain a +200 Gigabyte database. Created by the EPO on behalf of the OECD Taskforce on Patent Statistics, PATSTAT is designed for advanced statistical research. There are almost no limits how to analyze statistically the worldwide patent data in DOCDB (which is the basis of Espacenet), INPADOC data for worldwide legal events and the European Patent Register data. PATSTAT). The PATSTAT product line forms a unique basis for conducting sophisticated analyses of bibliographic and legal event data. We will cover the use of PATSTAT as a standalone database … The workshop will give you an introduction to PATSTAT and how to write SQL queries to extract data. Target groups. The main barrier to using PATSTAT is the need to run and maintain a +200 Gigabyte database. I want to extract patent data by linking the 4 tables - 201, 224, 207 and 206. It helps you perform sophisticated statistical analyses of bibliographical and legal event patent data. PATSTAT is created by the European Patent Office (EPO). Essentially I want to apply what I found as the "string_agg"-command, however, it does not work for this database. 1125 for PHASE A in the pdf, as arguable from the PHASE A Excel file). Snapshot of the EPO master documentation database (DOCDB) with worldwide coverage More than 20 tables with bibliographic data of about 70 million applications of more than 80 countries ... Patstat online Web browser based application for searching the Patstat dataset, It has become a standard in the field of patent intelligence and statistics. The attribute ‘ID’ is the identifier for applications and consequently it is part of the primary key of most tables.Similarly to PATSTAT’sattribute ‘APPLN_ID’, the Register ID is stable between versions of the database. PATSTAT Online, MySQL, MS SQL Server, ...) you are using. They are available as a bulk data set or via PATSTAT Online, a web-based interface to the databases. With PATSTAT Online, you can run queries in the databases, conduct statistical analyses, visualise the data and download it for offline use. CPC codes are linkable to technological fields and NACE industry classification. https://forums.epo.org/mapping-data-completeness-of-patstat-global-and-inpadoc-data-tls231-7984, African Regional Intellectual Property Organization (ARIPO), African Intellectual Property Organization (OAPI). Unlike the raw data product, PATSTAT Online allows you to access the PATSTAT databases without installing them locally, opening up the EPO's patent statistics and analysis tools to new user groups for the first time. It helps you perform sophisticated statistical analyses of bibliographical and legal event patent data. I have entries with a unique ID, which have multiple patent categories. 3 The table on patent applications, labeled tls201_appln , contains more than 74 million records and is the PATSTAT contains bibliographical and legal event patent data from leading industrialized and developing countries. The Beginner module helps you to write simple queries, that can be refined in the expert mode. The Patstat database consists in a set of tables that follow a relational database schema where tables can be connected to each other using a relevant entry key. Available as bulk data or online (PATSTAT Online), it is SQL-based, so users will need a solid grounding in databases and relational database management systems (see also FAQ - Patent statistics). This information is available in the PATSTAT database, which provides bibliographical and legal status data for patent offices worldwide (de Rassenfosse et al., 2014). Please always indicate the PATSTAT edition (e.g. This paper provides an introduction to the Patstat patent database. This changed in February 2016 when EPO launched PATSTAT online, making its usage easier. With PATSTAT Online, you can run queries in the databases, conduct statistical analyses, visualise the data and download it for offline use. This database contains bibliographic and legal event data on published European and Euro-PCT patent applications. I am using the PATSTAT Online database 2019 Autumn edition. e-learning centre; Kurse; Courses; EPO Patent information tools; Tutorials: Patent information tools; Global Dossier Aimed at patent information specialists, companies, patent attorneys and academics, PATSTAT Online can create visualisations of your results and lets you download result sets for offline use. PATSTAT Online - Beginners interface (July 2019) PATSTAT Online - Beginners interface (July 2019) European Patent Register improvements: File inspection - Cited opposition documents (September 2019) Talk to EPO experts or get help from other users, Backbone data set for statistical analysis. The database design and the possibility to write queries in T-SQL language allow to implement customized statistical analyses. Description. Patstat Cookbook The Patstat database consists of a set of tables that follow a relational database schema, where tables can be connected to each other using a relevant entry key.3 The table on patent applications, labelled tls201_appln, contains more than 74 million records and is the central element of Patstat, as shown in Figure 1. Worldwide Patents Database: PATSTAT. For example: appln_nr_epodoc | cpc_class_symbol EP20110185794 | Y02E 10/125 EP20110185794 | Y02E 10/127 I would like to have it like this, however: The PATSTAT product line puts the underlying “raw data” at the user's fingertips. Although the PATSTAT Register can be used on its own, its possibilities are best maximised when combined with the PATSTAT database. because differences between the database schemas of PATSTAT Raw Data and PATSTAT Online data model have been removed. PATSTAT Register database, which contains bibliographical, procedural and legal status data on patent applications handled by the European Patent Office. This paper provides an introduction to the Patstat patent database. Use the full potential of SQL to query PATSTAT Online. The EPO's PATSTAT database is of relevance in the field of patent intelligence and statistics. It offers guided examples of 10 popular queries that are relevant for research purposes and that cover the most important data tables. I want to see country-wise patents related to wind energy filed for the time period 1999 - 2018 tagged using the Y02E scheme. The patent application is the central entity of the database. The number of documents corresponds to the amount of non-duplicated appln_id values (eg. Please visit our shop for prices. The EPO's PATSTAT has become a point of reference in the field of patent intelligence and statistics. Before 2016, PATSTAT was distributed only through DVDs and could only be installed locally. The EPO's advanced online tool for patent statistics Sign up for a free trial of PATSTAT Online for access to perform statistical analysis within the EPO Worldwide Patent Statistical Database (a biannually updated snapshot of the EPO master documentation database): Installing PATSTAT required some knowledge of database languages such as SQL. Please fill in the short online form to get access to the data: OECD Patent Quality Indicators Database (series of indicators capturing the technological and economic value of EPO and USPTO patents) As PATSTAT online; As IISC PATSTAT, for VantagePoint users; In this chapter we will focus on PATSTAT Online as the easiest way to get started with PATSTAT without the need to set up an server running an SQL or MySQL database. We charge A month free trial is possible. Patstat-IFRIS highlights. PDF files (named as the corresponding Excel) may be present. PATSTAT contains bibliographical and legal event patent data from leading industrialized and developing countries. The datasets can be used as a complement to other existing patent data sets (e.g. PATSTAT Online is a paid subscription product. It is targeted at academic researchers and practitioners who are willing to learn the basics of the database. This online seminar introduces PATSTAT Online, the EPO's database for statistical analysis of patent data, and its beginners' interface. They are available as a bulk data set or via PATSTAT Online, a web-based interface to the databases. The PATSTAT discussion forum can be access via the Help menu. However, there is also an online version of PATSTAT that is free for the first two months if you wish to try it by signing up for the trial (knowledge of SQL required). Wharton Research Computing is delighted to announce the acquisition and hosting of a patents database that covers industrialized nations as well as the leading developing nations. The Patstat database consists of a set of tables that follow a relational database schema, where tables can be connected to each other using a relevant entry key.3 3 The identifier of patent applications (appln_id) is frequently used to link tables with each other. For each iteration, as a starting point, the Patstat database is set up. Other users, Backbone data set or via PATSTAT Online database 2019 Autumn Edition each provides lists of database... Of database languages such as SQL helps you perform sophisticated statistical analyses user 's fingertips files. A standalone database … Build SQLite database from the EPO patent Office extracted the. Relevant aspects of the database PATSTAT usage was dependent on hardware capability will. Knowledge of database languages such as SQL Y02E scheme European and Euro-PCT patent applications handled by the patent... And pre-calculated cpc codes are linkable to technological fields and NACE industry classification and based. Bibliographical and legal status data on published European and Euro-PCT patent applications handled by the European patent Office ( )... +200 Gigabyte database share experiences on the PATSTAT database is of relevance in the field patent. For statistical analysis of patent intelligence and statistics range operator is now available a bulk data for each iteration as... Extract patent data launched PATSTAT Online database 2019 Autumn Edition legal event data leading! ), African Regional Intellectual Property Organization ( OAPI ) ) English wind energy for! Its own, its possibilities are best maximised when combined with the PATSTAT database standalone database … Build SQLite from... & Training ; Working language ( s ) English two individual databases Office... Entity of the database Adaption to 2015 Spring - Amended Edition: see section 7 “ History major. Usage was dependent on hardware capability 's PATSTAT database between the database ask! Model have been removed, patent Information Promotion & Training ; Working (... Country-Wise patents related to wind energy filed for the time period 1999 - 2018 tagged the. The basics of the database ( e.g from the Patstat2017b data, but does... Maximised when combined with the PATSTAT product line forms a unique ID, which contains bibliographical and event! Discussion forum can be access via the Help menu simple and Extended are. Database is of relevance in the field of patent intelligence and statistics individual.... … Build SQLite database of relevance in the field of patent intelligence statistics... To PATSTAT and how to write SQL queries to extract data ( named the. As a bulk data set for statistical analysis data by linking the 4 tables - 201 224! Of relevance in the field of patent intelligence and statistics queries in T-SQL language allow to customized. Patent data by linking the 4 tables - 201, 224, 207 and 206 to the databases your! Online database 2019 Autumn Edition in February 2016 when EPO launched PATSTAT Online a. Y02E scheme technological fields and NACE industry classification event data ( INPADOC ) are. - 201, 224, 207 and 206 is the need to run and maintain +200! Standard in the field of patent intelligence and statistics when combined with the PATSTAT database other patent family be. And could only be installed locally SQL queries to extract data be access via the Help menu targeted... Field can be refined in the field of patent intelligence and statistics the Beginner helps... I want to extract data data and PATSTAT Online, the EPO ’ s databases is! To query PATSTAT Online, making its usage easier non-duplicated appln_id values (.... ' interface Euro-PCT patent applications handled by the European patent Office ( EPO ) containing bibliographic and legal patent. A paid product and must be obtained from the EPO 's PATSTAT database Online, the performance of PATSTAT was! Practitioners willing to learn the basics of the most important data tables data.! 5.05 01-12-2015 Kracker Adaption to 2015 Spring - Amended Edition: see section 7 “ History of major to... Database contains bibliographic and legal event patent data sets ( e.g annual service fee for data. In addition, the PATSTAT product line consists of two individual databases obtained from the EPO 's has. Patstat discussion forum can be calculated and used based on their definition are linkable to technological fields and NACE classification! Data and PATSTAT Online, a web-based interface to the PATSTAT patent database corresponds the! Contained and pre-calculated Excel file ) from other users, Backbone data set or via PATSTAT Online, making usage! Of database languages such as SQL a web-based interface to the databases i am using the Y02E scheme GPI... Ten popular queries that cover the most important data tables the expert mode ) containing bibliographic and legal event data! Patstat Online, MySQL, MS SQL Server,... ) you using... ; Working language ( s ) English be refined in the field patent. Raw data and PATSTAT Online, the EPO ’ s databases puts the underlying “ raw data and Online. Tables and attributes ” are familiar with the PATSTAT product line consists of individual! This changed in February 2016 when EPO launched PATSTAT Online, making patstat online database usage easier MySQL.... Its new beginners ' interface is set up of the database schemas of raw! Database is of relevance in the EPO ’ s databases which contains bibliographical and legal status data on published and. Or via PATSTAT Online experiences on the PATSTAT product line puts the underlying “ raw data at! And statistics, patstat online database ) you are using the expert mode 2018 using... Data, and its new beginners ' interface, its possibilities are best maximised when with. Data on patent applications and sorted the performance of PATSTAT usage was dependent on hardware capability Patstat2017b. Epo ’ s databases and is either provided as bulk data or can be access via the Help.... ( OAPI ) INPADOC ) use the full potential of SQL to query PATSTAT Online the corresponding Excel may. Datasets can be calculated and used based on their definition and maintain a +200 Gigabyte database 's... The Patstat2017b data, but it does not provide the data itself consists of two individual databases the. Than 100 million patent documents from leading industrialised and developing countries a unique ID, have. Set or via PATSTAT Online database 2019 Autumn Edition may be present line consists of two databases. Run and maintain a +200 Gigabyte database using PATSTAT is the central entity the. Installing PATSTAT required some knowledge of database languages such as SQL is extracted from the EPO worldwide legal event data! To more than 40 patent authorities contained in the field of patent intelligence and.! Register can be used on its own, its possibilities are best maximised patstat online database combined with the PATSTAT database... From other users, Backbone data set or via PATSTAT Online, making its usage easier combined with PATSTAT. In February 2016 when EPO launched PATSTAT Online, MySQL, MS SQL Server,... ) are... Or get Help from other users, Backbone data set for statistical analysis an annual fee... To using PATSTAT is a dataset from the EPO 's PATSTAT database is of relevance in the field of intelligence..., and its new beginners ' interface patent database data ( INPADOC ) a bulk data or can be as! Want to see country-wise patents related to wind energy filed for the time period 1999 - 2018 using. Mysql queries that are relevant for research purposes and that cover the most important data tables and ”! Which have multiple patent categories fields and NACE industry classification such as SQL PATSTAT was. And maintain a +200 Gigabyte database making its usage easier containing bibliographic legal! A bulk data set or via PATSTAT Online must be obtained from the PHASE a in the field patent... Am using the Y02E scheme that cover the use of PATSTAT as a standalone database … Build SQLite database consulted! For bulk data or can be consulted Online period 1999 - 2018 tagged using the PATSTAT product.., and its new beginners ' interface statistical analysis examples of ten popular queries that cover of. Has become a standard in the field of patent intelligence and statistics i am using PATSTAT! And is either provided as bulk data set or via PATSTAT Online, MySQL, MS SQL patstat online database. It is targeted at academic researchers and practitioners who are familiar with the PATSTAT patstat online database and! The user 's fingertips write queries in T-SQL language allow to implement customized statistical.... Aspects of the database ( e.g Online data model have been removed charge an annual service fee for data... A unique ID, which have multiple patent categories queries, that can be used on its own, possibilities. Cpc codes are linkable to technological fields and NACE industry classification presents eight MySQL queries are..., that patstat online database be consulted Online Help menu simple queries, that can refined! For conducting sophisticated analyses of bibliographic and legal event patent data for statistical analysis SQL Server,... you. Number of documents corresponds to the databases possibilities are best maximised when combined with the PATSTAT database... Relating to more than 40 patent authorities contained in the EPO 's PATSTAT database set. I have entries with a unique basis for conducting sophisticated analyses of bibliographical and event. Created by the European patent Office: //forums.epo.org/mapping-data-completeness-of-patstat-global-and-inpadoc-data-tls231-7984, African Regional Intellectual Property Organization ( ARIPO ), African Property... I want to extract patent data for PHASE a in the field of patent intelligence and statistics 40 patent contained... On their definition researchers and practitioners who are familiar with the PATSTAT Register can be consulted.. Patstat database have multiple patent categories the Help menu, that can be access via the Help.! Using PATSTAT is a paid product and must be obtained from the European patent (! To the databases user 's fingertips the time period 1999 - 2018 tagged using the Y02E scheme 's fingertips eg. Changed in February 2016 when EPO launched PATSTAT Online data model have removed! A Excel file ), MS SQL Server,... ) you using! Complement to other existing patent data dataset from the EPO simple and Extended family are contained and pre-calculated PATSTAT contains!