Applications

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

10 rows where Applicant_name = "PFIZER" and Patent_system = "JPO"

✎ View and edit SQL

This data as json, CSV (advanced)

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