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

19 rows where Applicant_name = "OTSUKA PHARMACEUTICAL"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 11

  • 2013 5
  • 2003 3
  • 2010 2
  • 2012 2
  • 1998 1
  • 1999 1
  • 2002 1
  • 2009 1
  • 2016 1
  • 2018 1
  • 2021 1

Patent_system 5

  • KIPO 5
  • USPTO 5
  • JPO 4
  • WIPO 3
  • EPO 2
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
EP2404994A1 OTSUKA PHARMACEUTICAL 2012 EPO
EP2404995A1 OTSUKA PHARMACEUTICAL 2012 EPO
JP1998248581A OTSUKA PHARMACEUTICAL 1998 JPO
JP1999178578A OTSUKA PHARMACEUTICAL 1999 JPO
JP2010273647A OTSUKA PHARMACEUTICAL 2010 JPO
JP2013051966A OTSUKA PHARMACEUTICAL 2013 JPO
KR20100101161A OTSUKA PHARMACEUTICAL 2010 KIPO
KR20130006513A OTSUKA PHARMACEUTICAL 2013 KIPO
KR20130008074A OTSUKA PHARMACEUTICAL 2013 KIPO
KR20130133893A OTSUKA PHARMACEUTICAL 2013 KIPO
KR20130133894A OTSUKA PHARMACEUTICAL 2013 KIPO
US10100095B2 OTSUKA PHARMACEUTICAL 2018 USPTO
US6403785B1 OTSUKA PHARMACEUTICAL 2002 USPTO
US6562947B2 OTSUKA PHARMACEUTICAL 2003 USPTO
US6620923B1 OTSUKA PHARMACEUTICAL 2003 USPTO
US9316588B2 OTSUKA PHARMACEUTICAL 2016 USPTO
WO2003004640A1 OTSUKA PHARMACEUTICAL 2003 WIPO
WO2009084603A1 OTSUKA PHARMACEUTICAL 2009 WIPO
WO2021106231A1 OTSUKA PHARMACEUTICAL 2021 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 19.383ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT