7,612
edits
Changes
Jump to navigation
Jump to search
|Is billed to=|Has notes=|Has project status=Active|Is dependent on=|Depends upon it=Tabled
Small Inventors Project (view source)
Revision as of 13:34, 21 September 2020
, 13:34, 21 September 2020no edit summary
{{McNair ProjectsProject|Has project output=|ImageHas sponsor= McNair Center
|Has title=Small Inventors Project
|Has owner=Avesh Krishna
|Has deadline=201705
|Has keywords=Patents, Small Business
}}
==See Also==
*[[Small Entity vs. Micro Entity]]
==General==
*What do they do with their IP (license/transfer)
*What are they valued at
*Also see [[Patent Rules]]
===Short Term deliverables===
*count of patents by type by year
*count of citations of type by year
*mean term of patents granted by year
:*can break down by type as well
::NOTE: mean stock of patents by type and year
*other idea
: mean number of patents per assignee by size over time (stock)
==Micro Entities==
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;
originality vs generality and whole, jaffey, tratjenberg. 4 standard measures : citations made, received, originality, generality.
citations across classes.
Whole (2005) paper that corrects the bias inherent in those measure,
Built initialsize1 table which had each patent and it's size at first fee event and it's grant date.
Also have an excel sheet with the number of patents granted of each size by year
Joined initialsize1 and citation_count to get the number of citations on and by each patent with the size and grant date.
