--3818842
Note : The assignees table was updated on 6/23 to remove the 'null' string and the '-1' values.
-- ==Patents ==
Patentdata:
appdate | date |
appyear | integer |
Column Names:
patent int,
kind varchar,
claims int,
apptype int,
appnum int,
gdate date,
gyear int,
appdate date,
appyear int
filename | varchar |
Column Names:
patentnumber int,
kind varchar,
grantdate date,
type varchar,
applicationnumber varchar,
filingdate date,
prioritydate date,
prioritycountry varchar,
prioritypatentnumber varchar,
ussubclass varchar,
maingroup varchar,
subgroup varchar,
cpcsubclass varchar,
cpcmaingroup varchar,
cpcsubgroup varchar,
classificationnationalcountry varchar,
classificationnationalclass varchar,
title varchar,
numberofclaims int,
primaryexaminerfirstname varchar,
primaryexaminerlastname varchar,
primaryexaminerdepartment varchar,
pctpatentnumber varchar,
filename varchar
Combined Schema:
appdate date,
appyear int
patentnumber int, -- patent kind varchar, -- kind grantdate date, --gdate type varchar, applicationnumber varchar, filingdate date, prioritydate date, prioritycountry varchar, prioritypatentnumber varchar, ussubclass varchar, maingroup varchar, subgroup varchar, cpcsubclass varchar, cpcmaingroup varchar, cpcsubgroup varchar, classificationnationalcountry varchar, classificationnationalclass varchar, title varchar, numberofclaims int, primaryexaminerfirstname varchar, primaryexaminerlastname varchar, primaryexaminerdepartment varchar, pctpatentnumber varchar, filename varchar claims int, apptype int, appnum int, gyear int, appdate date, appyear int
Output Schema: patents
primaryexaminerdepartment,
pctpatentnumber,
filename,
-1,
-1,
********** ==== INDEX CREATION **************====
ALTER TABLE patents ADD PRIMARY KEY (patentnumber);
CREATE INDEX
**== Citations==
To Extract Patents with Numbers Only and to Ignore Other RegExes
$$ LANGUAGE plperl;
************ Columns *********************
patentdata:
Column | Type | Modifiers