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 = "MERCK" and Patent_system = "USPTO"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 13

  • 2015 4
  • 2002 3
  • 2003 3
  • 2019 3
  • 2006 2
  • 2017 2
  • 2004 1
  • 2007 1
  • 2008 1
  • 2012 1
  • 2014 1
  • 2016 1
  • 2020 1

Patent_system 1

  • USPTO · 24 ✖
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
US10196434B2 MERCK 2019 USPTO
US10227393B2 MERCK 2019 USPTO
US10358476B2 MERCK 2019 USPTO
US10695405B2 MERCK 2020 USPTO
US6407222B1 MERCK 2002 USPTO
US6485919B1 MERCK 2002 USPTO
US6489305B1 MERCK 2002 USPTO
US6569434B1 MERCK 2003 USPTO
US6639063B1 MERCK 2003 USPTO
US6653097B1 MERCK 2003 USPTO
US6783961B1 MERCK 2004 USPTO
US7060800B2 MERCK 2006 USPTO
US7091022B2 MERCK 2006 USPTO
US7208282B2 MERCK 2007 USPTO
US7341995B2 MERCK 2008 USPTO
US8283307B2 MERCK 2012 USPTO
US8843356B2 MERCK 2014 USPTO
US8945877B2 MERCK 2015 USPTO
US8993261B2 MERCK 2015 USPTO
US9138459B2 MERCK 2015 USPTO
US9181533B2 MERCK 2015 USPTO
US9229008B2 MERCK 2016 USPTO
US9574003B2 MERCK 2017 USPTO
US9850298B2 MERCK 2017 USPTO

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