MABPAT_dataset: Applications: 13 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

13 rows where Applicant_name = "ROCHE DIAGNOSTICS" 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
US10391081B2	ROCHE DIAGNOSTICS	2019	USPTO
US6500941B1	ROCHE DIAGNOSTICS	2002	USPTO
US6916648B2	ROCHE DIAGNOSTICS	2005	USPTO
US7169580B1	ROCHE DIAGNOSTICS	2007	USPTO
US7279284B2	ROCHE DIAGNOSTICS	2007	USPTO
US7342102B2	ROCHE DIAGNOSTICS	2008	USPTO
US7358057B2	ROCHE DIAGNOSTICS	2008	USPTO
US7485714B2	ROCHE DIAGNOSTICS	2009	USPTO
US8298816B2	ROCHE DIAGNOSTICS	2012	USPTO
US8946385B2	ROCHE DIAGNOSTICS	2015	USPTO
US9102739B2	ROCHE DIAGNOSTICS	2015	USPTO
US9284374B2	ROCHE DIAGNOSTICS	2016	USPTO
US9297025B2	ROCHE DIAGNOSTICS	2016	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)
    );