MABPAT_dataset: Applications: 16 rows where Applicant_name = "SCRIPPS RESEARCH INSTITUTE" 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

16 rows where Applicant_name = "SCRIPPS RESEARCH INSTITUTE" and Patent_system = "JPO"

Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number ▼	Applicant_name	Year_of_application	Patent_system
JP2005502322A	SCRIPPS RESEARCH INSTITUTE	2005	JPO
JP2005537784A	SCRIPPS RESEARCH INSTITUTE	2005	JPO
JP2007508034A	SCRIPPS RESEARCH INSTITUTE	2007	JPO
JP2008513040A	SCRIPPS RESEARCH INSTITUTE	2008	JPO
JP2008516637A	SCRIPPS RESEARCH INSTITUTE	2008	JPO
JP2008517631A	SCRIPPS RESEARCH INSTITUTE	2008	JPO
JP2009132704A	SCRIPPS RESEARCH INSTITUTE	2009	JPO
JP2009529328A	SCRIPPS RESEARCH INSTITUTE	2009	JPO
JP2009529877A	SCRIPPS RESEARCH INSTITUTE	2009	JPO
JP2009538136A	SCRIPPS RESEARCH INSTITUTE	2009	JPO
JP2012254073A	SCRIPPS RESEARCH INSTITUTE	2012	JPO
JP2013009682A	SCRIPPS RESEARCH INSTITUTE	2013	JPO
JP2013539751A	SCRIPPS RESEARCH INSTITUTE	2013	JPO
JP2015511601A	SCRIPPS RESEARCH INSTITUTE	2015	JPO
JP2016112021A	SCRIPPS RESEARCH INSTITUTE	2016	JPO
JP2018532384A	SCRIPPS RESEARCH INSTITUTE	2018	JPO

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