MABPAT_dataset: Applications: 22 rows where Applicant_name = "TAKARA HOLDINGS" and Patent

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

22 rows where Applicant_name = "TAKARA HOLDINGS" and Patent_system = "JPO"

Search:

descending

✎ View and edit SQL

This data as json, CSV (advanced)

Patent_application_number ▼	Applicant_name	Year_of_application	Patent_system
JP1994253855A	TAKARA HOLDINGS	1994	JPO
JP1995184660A	TAKARA HOLDINGS	1995	JPO
JP1995298881A	TAKARA HOLDINGS	1995	JPO
JP1995327685A	TAKARA HOLDINGS	1995	JPO
JP1996009979A	TAKARA HOLDINGS	1996	JPO
JP2002330767A	TAKARA HOLDINGS	2002	JPO
JP2003052380A	TAKARA HOLDINGS	2003	JPO
JP2004298200A	TAKARA HOLDINGS	2004	JPO
JP2004329217A	TAKARA HOLDINGS	2004	JPO
JP2004532606A	TAKARA HOLDINGS	2004	JPO
JP2004536571A	TAKARA HOLDINGS	2004	JPO
JP2005245465A	TAKARA HOLDINGS	2005	JPO
JP2005507657A	TAKARA HOLDINGS	2005	JPO
JP2006288400A	TAKARA HOLDINGS	2006	JPO
JP2006340729A	TAKARA HOLDINGS	2006	JPO
JP2007300932A	TAKARA HOLDINGS	2007	JPO
JP2008048746A	TAKARA HOLDINGS	2008	JPO
JP2009131260A	TAKARA HOLDINGS	2009	JPO
JP2010017186A	TAKARA HOLDINGS	2010	JPO
JP2012183071A	TAKARA HOLDINGS	2012	JPO
JP2015227382A	TAKARA HOLDINGS	2015	JPO
JP2017051208A	TAKARA HOLDINGS	2017	JPO

Advanced export

JSON shape: default, array, newline-delimited, object

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)
    );