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

12 rows where Applicant_name = "UNIVERSITY OF CALIFORNIA" and Patent_system = "JPO"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 9

Patent_system 1

  • JPO · 12 ✖
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
JP1982126455A UNIVERSITY OF CALIFORNIA 1982 JPO
JP2003517817A UNIVERSITY OF CALIFORNIA 2003 JPO
JP2003518246A UNIVERSITY OF CALIFORNIA 2003 JPO
JP2004530423A UNIVERSITY OF CALIFORNIA 2004 JPO
JP2005501525A UNIVERSITY OF CALIFORNIA 2005 JPO
JP2005517381A UNIVERSITY OF CALIFORNIA 2005 JPO
JP2005522211A UNIVERSITY OF CALIFORNIA 2005 JPO
JP2008500398A UNIVERSITY OF CALIFORNIA 2008 JPO
JP2010046067A UNIVERSITY OF CALIFORNIA 2010 JPO
JP2011510611A UNIVERSITY OF CALIFORNIA 2011 JPO
JP2013544516A UNIVERSITY OF CALIFORNIA 2013 JPO
JP2014506464A UNIVERSITY OF CALIFORNIA 2014 JPO

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