MABPAT_dataset: Applications: 12 rows where Applicant_name = "BAYER" and Patent

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

12 rows where Applicant_name = "BAYER" and Patent_system = "JPO"

Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number ▼	Applicant_name	Year_of_application	Patent_system
JP2002510205A	BAYER	2002	JPO
JP2002519051A	BAYER	2002	JPO
JP2004516828A	BAYER	2004	JPO
JP2006520582A	BAYER	2006	JPO
JP2008054689A	BAYER	2008	JPO
JP2013515470A	BAYER	2013	JPO
JP2014510089A	BAYER	2014	JPO
JP2014511834A	BAYER	2014	JPO
JP2016511003A	BAYER	2016	JPO
JP2016514964A	BAYER	2016	JPO
JP2017514789A	BAYER	2017	JPO
JP2018113983A	BAYER	2018	JPO

Advanced export

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

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)
    );