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 = "AJINOMOTO" and Patent_system = "JPO"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 9

  • 2009 3
  • 2016 3
  • 2012 2
  • 1995 1
  • 1997 1
  • 2008 1
  • 2010 1
  • 2017 1
  • 2018 1

Patent_system 1

  • JPO · 14 ✖
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
JP1995023787A AJINOMOTO 1995 JPO
JP1997308456A AJINOMOTO 1997 JPO
JP2008109924A AJINOMOTO 2008 JPO
JP2009207460A AJINOMOTO 2009 JPO
JP2009232844A AJINOMOTO 2009 JPO
JP2009254323A AJINOMOTO 2009 JPO
JP2010246483A AJINOMOTO 2010 JPO
JP2012100537A AJINOMOTO 2012 JPO
JP2012196144A AJINOMOTO 2012 JPO
JP2016158599A AJINOMOTO 2016 JPO
JP2016165225A AJINOMOTO 2016 JPO
JP2016192903A AJINOMOTO 2016 JPO
JP2017046673A AJINOMOTO 2017 JPO
JP2018046814A AJINOMOTO 2018 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 11.775ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT