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

25 rows where Applicant_name = "SANOFI"

✎ View and edit SQL

This data as json, CSV (advanced)

Year_of_application 12

  • 2004 4
  • 2018 4
  • 2008 3
  • 2006 2
  • 2011 2
  • 2012 2
  • 2015 2
  • 2016 2
  • 2007 1
  • 2017 1
  • 2020 1
  • 2021 1

Patent_system 4

  • USPTO 13
  • WIPO 6
  • JPO 4
  • EPO 2
Patent_application_number ▼ Applicant_name Year_of_application Patent_system
EP1418185A1 SANOFI 2004 EPO
EP3362565A1 SANOFI 2018 EPO
JP2006518187A SANOFI 2006 JPO
JP2016047055A SANOFI 2016 JPO
JP2018121660A SANOFI 2018 JPO
JP2018531017A SANOFI 2018 JPO
US6673600B2 SANOFI 2004 USPTO
US6696273B2 SANOFI 2004 USPTO
US7227006B2 SANOFI 2007 USPTO
US7364887B2 SANOFI 2008 USPTO
US7429449B2 SANOFI 2008 USPTO
US7884084B2 SANOFI 2011 USPTO
US8030276B2 SANOFI 2011 USPTO
US8119770B2 SANOFI 2012 USPTO
US8207314B2 SANOFI 2012 USPTO
US8946174B2 SANOFI 2015 USPTO
US9062299B2 SANOFI 2015 USPTO
US9493529B2 SANOFI 2016 USPTO
US9611310B2 SANOFI 2017 USPTO
WO2004044003A2 SANOFI 2004 WIPO
WO2006074802A1 SANOFI 2006 WIPO
WO2008033304A2 SANOFI 2008 WIPO
WO2018151841A1 SANOFI 2018 WIPO
WO2020056294A1 SANOFI 2020 WIPO
WO2021081058A1 SANOFI 2021 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 717.532ms · Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT