Changes
Jump to navigation
Jump to search
no edit summary
This page records how to load/use the Harvard Dataverse.
==Getting the data==
Where we get the Harvard Dataverse data:
For more information about the patent data:
[[Patent Data]]
==Accessing the dbase==
On the database server, the entire Harvard Dataverse for Patent Data is downloaded in directory
/bulk/Software/Database\ Scripts/droptables.sql
==Creating the tables==
The following is the schema for the 10 tables in this database:
CREATE TABLE patents (
Patent varchar,#to int Kind varchar, #only types NULL, A1, B1, B2, E1 (check E1 is numeric)
Claims integer,
AppType varchar,#to int (http://www.uspto.gov/web/offices/ac/ido/oeip/taf/filingyr.htm) 29 is design AppNum varchar, #to int
GDate date,
GYear integer,
AppDate varchar, #date AppYear varchar #to int
);
CREATE TABLE classes (
Patent varchar, #to int
Prim integer,
Class varchar,
CREATE TABLE assignees (
Patent varchar, #to int AsgType varchar,#to int
Assignee varchar,
City varchar,
