Changes
Jump to navigation
Jump to search
);
CREATE TABLE patents (
Patent varchar,
Kind varchar,
Claims integer,
AppType varchar,
AppNum varchar,
GDate date,
GYear integer,
AppDate varchar,
AppYear varchar
no edit summary
This page records how to load/use the Harvard Dataverse.
Where we get the Harvard Dataverse data:
[https://dataverse.harvard.edu/dataset.xhtml?persistentId=hdl:1902.1/15705 Harvard Dataverse]
For more information about the patent data:
[[Patent Data]]
On the database server, the entire Harvard Dataverse for Patent Data is downloaded in directory
The following is the schema for the 10 tables in this database:
CREATE TABLE patents (
Patent varchar,
Kind varchar,
Claims integer,
AppType varchar,
AppNum varchar,
GDate date,
GYear integer,
AppDate varchar,
AppYear varchar
);
CREATE TABLE classes (
Nationality varchar,
InvSeq integer
);