Changes

Jump to navigation Jump to search
102 bytes added ,  14:07, 5 April 2016
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
);
 
CREATE TABLE patents (
Patent varchar,
Kind varchar,
Claims integer,
AppType varchar,
AppNum varchar,
GDate date,
GYear integer,
AppDate varchar,
AppYear varchar
);
Anonymous user

Navigation menu