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
40 rows where Applicant_name = "NOVARTIS"
This data as json, CSV (advanced)
Year_of_application 21
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)
);