home / MABPAT_dataset

Applications

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

14 rows where Applicant_name = "RIKEN" and Patent_system = "WIPO"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 9

  • 2004 4
  • 2003 3
  • 2005 1
  • 2006 1
  • 2008 1
  • 2014 1
  • 2015 1
  • 2016 1
  • 2018 1

Patent_system 1

  • WIPO · 14 ✖
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
WO2003033693A1 RIKEN 2003 WIPO
WO2003104460A1 RIKEN 2003 WIPO
WO2003104461A1 RIKEN 2003 WIPO
WO2004018671A1 RIKEN 2004 WIPO
WO2004070024A1 RIKEN 2004 WIPO
WO2004111235A1 RIKEN 2004 WIPO
WO2004111236A1 RIKEN 2004 WIPO
WO2005113772A1 RIKEN 2005 WIPO
WO2006104200A1 RIKEN 2006 WIPO
WO2008001947A1 RIKEN 2008 WIPO
WO2014133158A1 RIKEN 2014 WIPO
WO2015025959A1 RIKEN 2015 WIPO
WO2016129636A1 RIKEN 2016 WIPO
WO2018043716A1 RIKEN 2018 WIPO

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
    );
Powered by Datasette · Queries took 4559.969ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT