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

24 rows where Applicant_name = "SEKISUI CHEMICAL" and Patent_system = "JPO"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 9

  • 2005 7
  • 2004 4
  • 2009 4
  • 2010 3
  • 2006 2
  • 1993 1
  • 2002 1
  • 2012 1
  • 2014 1

Patent_system 1

  • JPO · 24 ✖
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
JP1993049479A SEKISUI CHEMICAL 1993 JPO
JP2002262883A SEKISUI CHEMICAL 2002 JPO
JP2004024095A SEKISUI CHEMICAL 2004 JPO
JP2004026714A SEKISUI CHEMICAL 2004 JPO
JP2004081199A SEKISUI CHEMICAL 2004 JPO
JP2004085542A SEKISUI CHEMICAL 2004 JPO
JP2005046066A SEKISUI CHEMICAL 2005 JPO
JP2005046067A SEKISUI CHEMICAL 2005 JPO
JP2005046068A SEKISUI CHEMICAL 2005 JPO
JP2005082537A SEKISUI CHEMICAL 2005 JPO
JP2005110591A SEKISUI CHEMICAL 2005 JPO
JP2005253432A SEKISUI CHEMICAL 2005 JPO
JP2005312445A SEKISUI CHEMICAL 2005 JPO
JP2006166845A SEKISUI CHEMICAL 2006 JPO
JP2006280239A SEKISUI CHEMICAL 2006 JPO
JP2009102306A SEKISUI CHEMICAL 2009 JPO
JP2009203181A SEKISUI CHEMICAL 2009 JPO
JP2009215211A SEKISUI CHEMICAL 2009 JPO
JP2009249303A SEKISUI CHEMICAL 2009 JPO
JP2010006745A SEKISUI CHEMICAL 2010 JPO
JP2010159218A SEKISUI CHEMICAL 2010 JPO
JP2010235492A SEKISUI CHEMICAL 2010 JPO
JP2012120507A SEKISUI CHEMICAL 2012 JPO
JP2014132832A SEKISUI CHEMICAL 2014 JPO

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 13.132ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT