MABPAT_dataset: Applications: 11 rows where Applicant_name = "ROCHE DIAGNOSTICS" 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

11 rows where Applicant_name = "ROCHE DIAGNOSTICS" 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
JP1999199507A	ROCHE DIAGNOSTICS	1999	JPO
JP2001527389A	ROCHE DIAGNOSTICS	2001	JPO
JP2002504364A	ROCHE DIAGNOSTICS	2002	JPO
JP2003505082A	ROCHE DIAGNOSTICS	2003	JPO
JP2005512574A	ROCHE DIAGNOSTICS	2005	JPO
JP2006513700A	ROCHE DIAGNOSTICS	2006	JPO
JP2006516094A	ROCHE DIAGNOSTICS	2006	JPO
JP2007014342A	ROCHE DIAGNOSTICS	2007	JPO
JP2009159948A	ROCHE DIAGNOSTICS	2009	JPO
JP2010531647A	ROCHE DIAGNOSTICS	2010	JPO
JP2011516026A	ROCHE DIAGNOSTICS	2011	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)
    );