Applicants

Contains information about entities that have applied for patents. Each record includes the applicant's name, the type of applicant (e.g., individual, organization, company), and the country where the applicant is headquartered.

Data license: CC BY 4.0 · Data source: Novel dataset reveals growing prominence of deep-sea life for marine bioprospecting · About: About MABPAT

Applicant_name
The name of the patent applicant (Primary Key). Searchable
Applicant_type
The type/category of the applicant
Applicant_country
The country where the applicant is based

3 rows where Applicant_country = "NEW ZEALAND" and Applicant_type = "UNIVERSITY"

✎ View and edit SQL

This data as json, CSV (advanced)

Applicant_type 1

  • UNIVERSITY · 3 ✖

Applicant_country 1

  • NEW ZEALAND · 3 ✖
Applicant_name ▼ Applicant_type Applicant_country
AUCKLAND UNISERVICES LIMITED; AUCKLAND; NZ; UNIVERSITY NEW ZEALAND
THE HORTICULTURE AND FOOD RESEARCH INSTITUTE OF NEW ZEALAND LIMITED UNIVERSITY NEW ZEALAND
THE NEW ZEALAND INSTITUTE FOR PLANT AND FOOD RESEARCH LIMITED; AUCKLAND UNIVERSITY NEW ZEALAND

Advanced export

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

CSV options: 

CREATE TABLE Applicants (
        Applicant_name TEXT PRIMARY KEY,
        Applicant_type TEXT,
        Applicant_country TEXT
    );