MABPAT_dataset: Applications: 18 rows where Applicant_name = "NOVARTIS" 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

18 rows where Applicant_name = "NOVARTIS" and Patent_system = "USPTO"

Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number ▼	Applicant_name	Year_of_application	Patent_system
US10654816B2	NOVARTIS	2020	USPTO
US5405942A	NOVARTIS	1995	USPTO
US6440934B1	NOVARTIS	2002	USPTO
US6492112B1	NOVARTIS	2002	USPTO
US6794186B2	NOVARTIS	2004	USPTO
US6818222B1	NOVARTIS	2004	USPTO
US7186407B2	NOVARTIS	2007	USPTO
US7501128B2	NOVARTIS	2009	USPTO
US7700359B2	NOVARTIS	2010	USPTO
US7842289B2	NOVARTIS	2010	USPTO
US8008452B2	NOVARTIS	2011	USPTO
US8101349B2	NOVARTIS	2012	USPTO
US8183397B2	NOVARTIS	2012	USPTO
US8747864B2	NOVARTIS	2014	USPTO
US8758764B2	NOVARTIS	2014	USPTO
US9102729B2	NOVARTIS	2015	USPTO
US9163259B2	NOVARTIS	2015	USPTO
US9738693B2	NOVARTIS	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)
    );