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

36 rows where Applicant_name = "KAO CORPORATION" and Patent_system = "JPO"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 9

  • 2017 10
  • 2016 5
  • 2018 5
  • 2010 4
  • 2020 4
  • 2019 3
  • 2015 2
  • 2021 2
  • 2013 1

Patent_system 1

  • JPO · 36 ✖
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
JP2010213627A KAO CORPORATION 2010 JPO
JP2010213628A KAO CORPORATION 2010 JPO
JP2010213664A KAO CORPORATION 2010 JPO
JP2010213665A KAO CORPORATION 2010 JPO
JP2013252115A KAO CORPORATION 2013 JPO
JP2015177771A KAO CORPORATION 2015 JPO
JP2015213467A KAO CORPORATION 2015 JPO
JP2016007154A KAO CORPORATION 2016 JPO
JP2016034258A KAO CORPORATION 2016 JPO
JP2016054703A KAO CORPORATION 2016 JPO
JP2016214182A KAO CORPORATION 2016 JPO
JP2016214183A KAO CORPORATION 2016 JPO
JP2017029122A KAO CORPORATION 2017 JPO
JP2017051152A KAO CORPORATION 2017 JPO
JP2017051153A KAO CORPORATION 2017 JPO
JP2017079639A KAO CORPORATION 2017 JPO
JP2017093321A KAO CORPORATION 2017 JPO
JP2017093325A KAO CORPORATION 2017 JPO
JP2017192342A KAO CORPORATION 2017 JPO
JP2017195861A KAO CORPORATION 2017 JPO
JP2017201905A KAO CORPORATION 2017 JPO
JP2017209064A KAO CORPORATION 2017 JPO
JP2018088902A KAO CORPORATION 2018 JPO
JP2018099107A KAO CORPORATION 2018 JPO
JP2018126095A KAO CORPORATION 2018 JPO
JP2018143192A KAO CORPORATION 2018 JPO
JP2018174793A KAO CORPORATION 2018 JPO
JP2019047756A KAO CORPORATION 2019 JPO
JP2019050750A KAO CORPORATION 2019 JPO
JP2019216643A KAO CORPORATION 2019 JPO
JP2020031561A KAO CORPORATION 2020 JPO
JP2020058321A KAO CORPORATION 2020 JPO
JP2020058322A KAO CORPORATION 2020 JPO
JP2020080698A KAO CORPORATION 2020 JPO
JP2021101628A KAO CORPORATION 2021 JPO
JP2021108558A KAO CORPORATION 2021 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 6638.308ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT