Changes

Small Inventors Project (view source)

651 bytes added , 19:03, 9 March 2017

Created times_cited which counts the number of times a patent is cited

DROP TABLE citation_cleaned

CREATE TABLE citation_cleaned AS

SELECT patent, cited

FROM citation

WHERE (patent IS NOT NULL AND

citation is NOT NULL);

#SELECT 74164171

ALTER TABLE citation_cleaned RENAME patent to citing;

DROP TABLE citations_made

CREATE TABLE citations_made AS

SELECT citing, count(*) as numcitations FROM citation_cleaned GROUP BY citing;

#SELECT 5214098

DROP TABLE times_cited

CREATE TABLE times_cited AS

SELECT cited, count(*) as citednum FROM citation_cleaned GROUP BY cited;

#SELECT 6977741

ALTER TABLE citations_made RENAME citing to patent;

ALTER TABLE times_cited RENAME cited to patent;

215

edits