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

23 rows where Applicant_name = "BAYER" and Patent_system = "WIPO"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 13

  • 2002 4
  • 2008 3
  • 2005 2
  • 2006 2
  • 2010 2
  • 2011 2
  • 2012 2
  • 2001 1
  • 2003 1
  • 2004 1
  • 2007 1
  • 2014 1
  • 2015 1

Patent_system 1

  • WIPO · 23 ✖
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
WO2001009296A1 BAYER 2001 WIPO
WO2002002459A1 BAYER 2002 WIPO
WO2002002469A1 BAYER 2002 WIPO
WO2002002470A1 BAYER 2002 WIPO
WO2002002508A1 BAYER 2002 WIPO
WO2003052108A2 BAYER 2003 WIPO
WO2004052926A1 BAYER 2004 WIPO
WO2005000885A1 BAYER 2005 WIPO
WO2005038017A2 BAYER 2005 WIPO
WO2006012080A2 BAYER 2006 WIPO
WO2006081976A1 BAYER 2006 WIPO
WO2007140983A1 BAYER 2007 WIPO
WO2008011468A2 BAYER 2008 WIPO
WO2008095622A2 BAYER 2008 WIPO
WO2008095623A2 BAYER 2008 WIPO
WO2010045324A1 BAYER 2010 WIPO
WO2010121818A1 BAYER 2010 WIPO
WO2011076877A1 BAYER 2011 WIPO
WO2011076889A1 BAYER 2011 WIPO
WO2012130684A1 BAYER 2012 WIPO
WO2012130685A1 BAYER 2012 WIPO
WO2014135535A1 BAYER 2014 WIPO
WO2015135946A1 BAYER 2015 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 3518.512ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT