Applications

Contains information about each patent application linked to marine genetic sequences. Information includes the patent application number, the year of application, and the patent system under which the application was filed.

Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT

Patent_application_number
Patent application number in corresponding patent system (Primary Key). Searchable
Applicant_name
Name of the applicant, linking to the Applicants table. Searchable
Year_of_application
The year the patent application was filed
Patent_system
The patent system (e.g., USPTO, EPO) under which the application was filed

18 rows where Applicant_name = "KYOWA HAKKO"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 12

Patent_system 3

Patent_application_number ▼ Applicant_name Year_of_application Patent_system
JP1987143693A KYOWA HAKKO 1987 JPO
JP1987224297A KYOWA HAKKO 1987 JPO
JP1987234096A KYOWA HAKKO 1987 JPO
JP1988304997A KYOWA HAKKO 1988 JPO
JP1993207883A KYOWA HAKKO 1993 JPO
JP1993268969A KYOWA HAKKO 1993 JPO
JP2002119288A KYOWA HAKKO 2002 JPO
JP2017184690A KYOWA HAKKO 2017 JPO
US7951381B2 KYOWA HAKKO 2011 USPTO
US8623619B2 KYOWA HAKKO 2014 USPTO
US9700594B2 KYOWA HAKKO 2017 USPTO
WO2006126589A1 KYOWA HAKKO 2006 WIPO
WO2008114733A1 KYOWA HAKKO 2008 WIPO
WO2010053077A1 KYOWA HAKKO 2010 WIPO
WO2010126073A1 KYOWA HAKKO 2010 WIPO
WO2015025920A1 KYOWA HAKKO 2015 WIPO
WO2020032258A1 KYOWA HAKKO 2020 WIPO
WO2020032261A1 KYOWA HAKKO 2020 WIPO

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE Applications (
        Patent_application_number TEXT PRIMARY KEY,
        Applicant_name TEXT,
        Year_of_application TEXT,
        Patent_system TEXT,
        FOREIGN KEY (Applicant_name) REFERENCES Applicants (Applicant_name)
    );