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 = "MERCK"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 19

  • 2002 4
  • 2003 4
  • 2015 4
  • 2019 3
  • 2004 2
  • 2006 2
  • 2012 2
  • 2014 2
  • 2016 2
  • 2017 2
  • 2001 1
  • 2007 1
  • 2008 1
  • 2009 1
  • 2010 1
  • 2011 1
  • 2013 1
  • 2018 1
  • 2020 1

Patent_system 3

  • USPTO 24
  • JPO 10
  • WIPO 2
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
JP2001506588A MERCK 2001 JPO
JP2002517507A MERCK 2002 JPO
JP2003512859A MERCK 2003 JPO
JP2004501375A MERCK 2004 JPO
JP2010519930A MERCK 2010 JPO
JP2011514157A MERCK 2011 JPO
JP2012533298A MERCK 2012 JPO
JP2014527809A MERCK 2014 JPO
JP2016501023A MERCK 2016 JPO
JP2018533976A MERCK 2018 JPO
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
WO2009077577A2 MERCK 2009 WIPO
WO2013103434A1 MERCK 2013 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 17.799ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT