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
 
24 rows where Applicant_name = "MERCK" and Patent_system = "USPTO"
This data as json, CSV (advanced)
Year_of_application 13
Patent_system 1
- USPTO · 24 ✖
 
| Patent_application_number ▼ | Applicant_name | Year_of_application | Patent_system | 
|---|---|---|---|
| US10196434B2 | MERCK | 2019 | USPTO | 
| US10227393B2 | MERCK | 2019 | USPTO | 
| US10358476B2 | MERCK | 2019 | USPTO | 
| US10695405B2 | MERCK | 2020 | USPTO | 
| US6407222B1 | MERCK | 2002 | USPTO | 
| US6485919B1 | MERCK | 2002 | USPTO | 
| US6489305B1 | MERCK | 2002 | USPTO | 
| US6569434B1 | MERCK | 2003 | USPTO | 
| US6639063B1 | MERCK | 2003 | USPTO | 
| US6653097B1 | MERCK | 2003 | USPTO | 
| US6783961B1 | MERCK | 2004 | USPTO | 
| US7060800B2 | MERCK | 2006 | USPTO | 
| US7091022B2 | MERCK | 2006 | USPTO | 
| US7208282B2 | MERCK | 2007 | USPTO | 
| US7341995B2 | MERCK | 2008 | USPTO | 
| US8283307B2 | MERCK | 2012 | USPTO | 
| US8843356B2 | MERCK | 2014 | USPTO | 
| US8945877B2 | MERCK | 2015 | USPTO | 
| US8993261B2 | MERCK | 2015 | USPTO | 
| US9138459B2 | MERCK | 2015 | USPTO | 
| US9181533B2 | MERCK | 2015 | USPTO | 
| US9229008B2 | MERCK | 2016 | USPTO | 
| US9574003B2 | MERCK | 2017 | USPTO | 
| US9850298B2 | MERCK | 2017 | USPTO | 
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)
    );