http://www.edegan.com/mediawiki/api.php?action=feedcontributions&user=Avesh&feedformat=atomedegan.com - User contributions [en]2024-03-29T06:41:48ZUser contributionsMediaWiki 1.34.2http://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna&diff=19198Avesh Krishna2017-07-11T22:13:07Z<p>Avesh: /* Education */</p>
<hr />
<div>{{McNair Staff<br />
|position=Research Team<br />
|name=Avesh Krishna<br />
|user_image=Avesh_Krishna_Picture.jpg | 300px<br />
|degree=BA<br />
|major=Political Science; Policy Studies; Pre-Law<br />
|class=2019<br />
|join_date=September 2016<br />
|skills=Python, R, Writing, Public Speaking<br />
|interests=Live Music, Public Policy, Food, Art and Design<br />
|email=avesh@rice.edu<br />
|skype_name=avesh.tx<br />
|status=Active<br />
}}<br />
Avesh J. Krishna is a sophomore at Rice University studying Political Science and Policy Studies. He currently works as a research assistant for the Baker Institute for Public Policy’s McNair Center for Entrepreneurship and Innovation. <br />
<br />
==Early Life==<br />
<br />
Avesh was born in Westchester County, New York to parents Dr. Arvind and Mrs. Sonia Krishna. Since 2005, the Krishna family has lived in Ridgefield, Connecticut. He has a younger sister, Tarini Krishna, who currently attends Ridgefield High School. <br />
<br />
==Education==<br />
<br />
Avesh graduated from Ridgefield High School in Ridgefield, Connecticut in June 2015. At Ridgefield High School Avesh was the captain of the Mock Trial Team and Debate Team as well as serving in leadership roles in student government and the National Honor Society chapter. His involvement in debate and mock trial motivated him to pursue further study in the social sciences, and flirts with the idea of attending law school or pursuing postgraduate degrees in the social sciences. In August 2015, Avesh began his undergraduate education at Rice University in Houston, Texas where he currently is a sophomore Political Science & Economics major pursuing a minor in statistics. He is a member of Brown College at Rice and serves on its executive cabinet (government).<br />
<br />
==Work Experience==<br />
<br />
In Summer 2017, Avesh worked as a political & research intern for the New American Leaders Project in New York, New York. He additionally conducted data analysis for the Connecticut Democratic Party as their data fellow. The prior summer, Avesh worked as a research intern at IBM Research in Yorktown Heights, New York. He worked with the Deep Learning group to develop visualization techniques for training processes. Avesh is also working with the Center for Local Elections for American Politics as a research assistant where he works on reports and academic research regarding the electoral landscape and candidate emergence (with special focus on gender and racial factors). Additionally, Avesh worked as an intellectual property analyst at Intellectual Profit LLC where he gained experience with the legal and commercial aspects of innovation.<br />
<br />
==Other Activities==<br />
Avesh is involved at Brown College as a committee chair and an academic fellow. He additionally DJs for Rice’s radio station KTRU. You can listen to him on KTRU from 8 to 10 AM Wednesday mornings. <br />
<br />
<br />
==McNair Updates==<br />
[[Avesh Krishna (Work Log)]]<br />
<br />
[[Avesh Krishna (Research Plan)]]<br />
<br />
<!-- null edit dummy -->[[Category:McNair Staff]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna&diff=19197Avesh Krishna2017-07-11T22:11:11Z<p>Avesh: /* Work Experience */</p>
<hr />
<div>{{McNair Staff<br />
|position=Research Team<br />
|name=Avesh Krishna<br />
|user_image=Avesh_Krishna_Picture.jpg | 300px<br />
|degree=BA<br />
|major=Political Science; Policy Studies; Pre-Law<br />
|class=2019<br />
|join_date=September 2016<br />
|skills=Python, R, Writing, Public Speaking<br />
|interests=Live Music, Public Policy, Food, Art and Design<br />
|email=avesh@rice.edu<br />
|skype_name=avesh.tx<br />
|status=Active<br />
}}<br />
Avesh J. Krishna is a sophomore at Rice University studying Political Science and Policy Studies. He currently works as a research assistant for the Baker Institute for Public Policy’s McNair Center for Entrepreneurship and Innovation. <br />
<br />
==Early Life==<br />
<br />
Avesh was born in Westchester County, New York to parents Dr. Arvind and Mrs. Sonia Krishna. Since 2005, the Krishna family has lived in Ridgefield, Connecticut. He has a younger sister, Tarini Krishna, who currently attends Ridgefield High School. <br />
<br />
==Education==<br />
<br />
Avesh graduated from Ridgefield High School in Ridgefield, Connecticut in June 2015. At Ridgefield High School Avesh was the captain of the Mock Trial Team and Debate Team as well as serving in leadership roles in student government and the National Honor Society chapter. His involvement in debate and mock trial motivated him to pursue further study in the social sciences, and flirts with the idea of attending law school. In August 2015, Avesh began his undergraduate education at Rice University in Houston, Texas where he currently is a sophomore Political Science major and pursuing a minor in statistics. He is a member of Brown College at Rice.<br />
<br />
==Work Experience==<br />
<br />
In Summer 2017, Avesh worked as a political & research intern for the New American Leaders Project in New York, New York. He additionally conducted data analysis for the Connecticut Democratic Party as their data fellow. The prior summer, Avesh worked as a research intern at IBM Research in Yorktown Heights, New York. He worked with the Deep Learning group to develop visualization techniques for training processes. Avesh is also working with the Center for Local Elections for American Politics as a research assistant where he works on reports and academic research regarding the electoral landscape and candidate emergence (with special focus on gender and racial factors). Additionally, Avesh worked as an intellectual property analyst at Intellectual Profit LLC where he gained experience with the legal and commercial aspects of innovation.<br />
<br />
==Other Activities==<br />
Avesh is involved at Brown College as a committee chair and an academic fellow. He additionally DJs for Rice’s radio station KTRU. You can listen to him on KTRU from 8 to 10 AM Wednesday mornings. <br />
<br />
<br />
==McNair Updates==<br />
[[Avesh Krishna (Work Log)]]<br />
<br />
[[Avesh Krishna (Research Plan)]]<br />
<br />
<!-- null edit dummy -->[[Category:McNair Staff]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=18083Small Inventors Project2017-04-28T20:09:46Z<p>Avesh: /* Short Term deliverables */</p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==See Also==<br />
<br />
*[[Small Entity vs. Micro Entity]]<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
*Also see [[Patent Rules]]<br />
<br />
<br />
===Short Term deliverables===<br />
<br />
*count of patents by type by year<br />
*count of citations of type by year<br />
*mean term of patents granted by year <br />
:*can break down by type as well<br />
<br />
<br />
::NOTE: mean stock of patents by type and year<br />
<br />
*other idea<br />
: mean number of patents per assignee by size over time (stock)<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]<br />
<br />
Want to create a new table with all small and micro patents and if they are small or micro<br />
<br />
Then find all patents citing a small or micro patent<br />
:basically a left join of the table and the citations table (so including small micro or large designation is shown)<br />
<br />
<br />
Look to see how many patents cite knowledge used by small or micro firms <br />
:break down by category small medium large<br />
<br />
Find \<br />
<br />
==Patent Database==<br />
<br />
created citation_cleaned table which removed all rows with NULL value in either column<br />
<br />
Created citations_made table which counts the number of patents cited by a patent<br />
<br />
Created times_cited which counts the number of times a patent is cited<br />
<br />
DROP TABLE citation_cleaned<br />
CREATE TABLE citation_cleaned AS<br />
SELECT patent, cited<br />
FROM citation<br />
WHERE (patent IS NOT NULL AND<br />
citation is NOT NULL);<br />
#SELECT 74164171<br />
<br />
ALTER TABLE citation_cleaned RENAME patent to citing;<br />
<br />
DROP TABLE citations_made<br />
CREATE TABLE citations_made AS<br />
SELECT citing, count(*) as numcitations FROM citation_cleaned GROUP BY citing;<br />
#SELECT 5214098<br />
<br />
DROP TABLE times_cited<br />
CREATE TABLE times_cited AS<br />
SELECT cited, count(*) as citednum FROM citation_cleaned GROUP BY cited;<br />
#SELECT 6977741<br />
<br />
ALTER TABLE citations_made RENAME citing to patent;<br />
ALTER TABLE times_cited RENAME cited to patent;<br />
<br />
<br />
originality vs generality and whole, jaffey, tratjenberg. 4 standard measures : citations made, received, originality, generality. <br />
<br />
citations across classes. <br />
<br />
Whole (2005) paper that corrects the bias inherent in those measure,<br />
<br />
Built initialsize1 table which had each patent and it's size at first fee event and it's grant date.<br />
<br />
Also have an excel sheet with the number of patents granted of each size by year<br />
<br />
Joined initialsize1 and citation_count to get the number of citations on and by each patent with the size and grant date.</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=18082Avesh Krishna (Work Log)2017-04-28T19:59:11Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]<br />
<br />
2/15/2017 14:00-17:00 - Helping Catherine with medical data<br />
<br />
2/16/2017 15:45-17:30 - Finding information on small inventors<br />
<br />
2/17/2017 15:00-17:00 - Explaining XML files<br />
<br />
2/22/2017 14:00-16:00 - Figuring out the Patent SQL database<br />
<br />
2/23/2017 15:00 - 16:30 - Helping Catherine with medical centers<br />
<br />
2/24/2017 13:00 - 13:00 - Trying to decrypt what all the tables in the patent database are<br />
<br />
2/28/2017 16:00 - 17:30 - [[Small Inventors Project]]<br />
<br />
3/1/2017 13:30 - 16:00 - [[Small Inventors Project]]<br />
<br />
3/2/2017 15:45-17:30 - building SQL citation tables <br />
<br />
3/3/2017 14:00-16:00 - sql citation tables<br />
<br />
3/7/2017 15:45-17:00 - trying to count small patents by year<br />
<br />
3/8/2017 13:30 - 16:00 writing up wiki page with patent rules [[Patent Rules]]<br />
<br />
3/9/2017 16:00-17:30 [[Patent Rules]]<br />
<br />
3/10/2017 14:15-16:00 Thinking of method for renewals<br />
<br />
3/21/2017 16:00-17:30 <br />
<br />
3/22/2017 15:00-19:30 Patent dinner meeting<br />
<br />
3/23/2017 16:00-17:30 Helping with medical center project<br />
<br />
3/24/2017 13:00-15:00 Cleaning citation tables<br />
<br />
3/28/2017 15:45-17:30 Patent Start End calculations<br />
<br />
3/29/2017 13:00-16:00 Finding patents by size and grant date, splitting by year<br />
<br />
4/4/2017<br />
<br />
4/5/2017<br />
<br />
4/6/2017<br />
<br />
4/11/2017<br />
<br />
4/12/2017<br />
<br />
4/13/2017<br />
<br />
4/14/2017 (Sorry was bad about keeping my worklog by see [[Patent Rules]]<br />
[[Category:Work Log]]<br />
<br />
4/18/2017 15:45-17:30 - Writing out term rules for Sonia<br />
<br />
4/19/2017</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Patent_Expiration_Rules&diff=18081Patent Expiration Rules2017-04-28T19:52:36Z<p>Avesh: /* Updating the Patent Term Calculcations */</p>
<hr />
<div>Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a patent is valid for after that fee is paid. The DaysDuration is how many total days the patent has been valid for since it's grant date. DaysDuration is the key variable, for each fee paid, we add DaysIncrement to DaysDuration. The DaysDuration past the grant date is the validity of the patent. <br />
<br />
NOTE: This version does not distinguish when to count from filedate or grant date - it only uses grantdate. Prior to XXX (TO BE FILLED IN BY AVESH), patents had statutory terms of 18 yrs from grant. Subsequent to XXX patents have 20 years from application.<br />
<br />
ALSO- keep in mind this is in *allpatentsprocessed* DB, not in the *patent* database.<br />
<br />
Located in <br />
Z:\LBO\Clean\patentExpirationRules.txt<br />
<br />
{| class="wikitable"<br />
! FeeCode<br />
! Description<br />
! DaysIncrement<br />
! DaysDuration<br />
|-<br />
| EXP.<br />
| Patent Expired for Failure to Pay Maintenance Fees.<br />
| 0<br />
| 0<br />
|-<br />
| EXPX<br />
| Patent Reinstated After Maintenance Fee Payment Confirmed.<br />
| 0<br />
| 0<br />
|-<br />
| M1551<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M1552<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M1553<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M1559<br />
| Payment of Maintenance Fee under 1.28(c).<br />
| 0<br />
| 0<br />
|-<br />
| M170<br />
| Payment of Maintenance Fee, 4th Year, PL 96-517.<br />
| 1460<br />
| 2920<br />
|-<br />
| M171<br />
| Payment of Maintenance Fee, 8th Year, PL 96-517.<br />
| 1460<br />
| 4380<br />
|-<br />
| M172<br />
| Payment of Maintenance Fee, 12th Year, PL 96-517.<br />
| 2920<br />
| 7300<br />
|-<br />
| M173<br />
| Payment of Maintenance Fee, 4th Year, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M174<br />
| Payment of Maintenance Fee, 8th Year, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M175<br />
| Payment of Maintenance Fee, 12th Year, PL 97-247<br />
| 2920<br />
| 7300<br />
|-<br />
| M183<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M184<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M185<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M2551<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M2552<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M2553<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M273<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M274<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M275<br />
| Payment of Maintenance Fee,12th Yr, Small Entity, PL 97-247.<br />
| 2920<br />
| 7300<br />
|-<br />
| M283<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M284<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M285<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M3551<br />
| Payment of Maintenance Fee, 4th Year, Micro Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M3552<br />
| Payment of Maintenance Fee, 8th Year, Micro Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M3553<br />
| Payment of Maintenance Fee, 12th Year, Micro Entity.<br />
| 2920<br />
| 7300<br />
|}<br />
<br />
== Building Start and End Table ==<br />
<br />
Created PatentExpirationRules table using the data shown in the table above. Maintfeeevents is a table with all of the USPTO data on fees paid. The earliest grantdate in this dataset is 1981-09-01 and the latest is 2016-06-28. The earliest feedate is 1980-12-19 and the latest feedate is 5000-01-1 (NO THIS IS NOT A TYPO- someone please fix why we have fees being paid in the year 5000). The second latest feedate is 2016-06-13.<br />
<br />
SQL steps are located at <br />
E:\McNair\Projects\LBO\Clean\Building the Patent Start End Table.sql<br />
<br />
/*<br />
These are instructions for building the patentstartend table, which identifies for each patent (number) the dates at which it is granted and at which it expired.<br />
It uses a database of all maintenance fee events and a list of the types of maintenance fee events and their effect the length of patent life <br />
*/<br />
<br />
--First, we need to import the table of Maintenance fee events (from copy in Z:\LBO\Clean, originally from Z:\USPTO_Consolidated\Maint_Fee_Events)<br />
<br />
CREATE TABLE Maintfeeevents (<br />
patentNumber VARCHAR(7) NOT NULL,<br />
appNumber VARCHAR(8) NOT NULL,<br />
smallEntity VARCHAR(1) NOT NULL,<br />
appFilingDate DATE NOT NULL,<br />
grantDate DATE NOT NULL,<br />
feeDate DATE NOT NULL,<br />
feeCode VARCHAR(5) NOT NULL<br />
);<br />
<br />
<nowiki>\COPY Maintfeeevents FROM 'MaintFeeEvents_20160613.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV;</nowiki><br />
<br />
--Now import table of fee codes (and the duration of the extensions) from (Z:\LBO\Clean)<br />
--daysDuration represents the number of days from grantdate that patent will remain active due to maintenance fee event<br />
--I.e., 8 years for 4th year extension, 12 years for 8th year extension, 20 years for 12th year extension<br />
--Note that we give the expiration events a value of 0 since these can occur after any such extension (or lack thereof).<br />
<br />
CREATE TABLE PatentExpirationRules (<br />
feeCode VARCHAR(5) NOT NULL,<br />
description VARCHAR(255) NOT NULL,<br />
daysIncrement INTEGER NOT NULL,<br />
daysDuration INTEGER NOT NULL<br />
);<br />
\COPY PatentExpirationRules FROM 'patentExpirationRules.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV;<br />
<br />
--We can approximate the actual expiration date by taking the max of daysDuration and adding that number of days to the original grantdate<br />
SELECT M.patentnumber, MAX(M.grantdate) as grantdate, MAX(GREATEST(M.grantdate + P.daysDuration, M.grantdate + 1460)) as expdate<br />
INTO patentstartend<br />
FROM maintfeeevents as M RIGHT JOIN patentexpirationrules as P ON M.feecode = P.feecode<br />
GROUP BY M.patentnumber<br />
;<br />
<br />
/*<br />
There is an alternative way to do this using fee expiration events; however, there are two problems:<br />
1) The USPTO may have accidentally omitted some expiration events<br />
2) Sometimes there are late payments; this leads to reinstatement of the patent. Should be solved by taking last expiration event, but there are potential problems:<br />
2a) See problem 1<br />
2b) Might not have expiration event at conclusion of 20 years (after all three extensions expire)<br />
*/<br />
<br />
== Updating the Patent Term Calculcations ==<br />
*Patent filed after June 8 1995: term of 20 years from US filing date (based on fees paid)<br />
<br />
*Pending on June 8 1995 or issued after June 7 1978 but not expired before june 8 19985 have the term max(17 years from issue date, 20 years from date of filing)<br />
<br />
*Patents issued before June 7 1978 have term of 17 years from date of issue<br />
<br />
<br />
*Maintenance Fees at 3.5, 7.5, and 11.5 years from date of issue. aka 4, 8 , 12<br />
<br />
<br />
<br />
So patent filed after june 8 1995<br />
:add 4 years (1460 days) to issue date to start<br />
:add 4 years to issue date after 3.5yr fee<br />
:add 4 years to issue date after 7.5 year fee<br />
:add difference up to 20 years from filing date after 11.5 year fee<br />
<br />
*Patent issued between june 7 1978 and june 8 1995 will have the term which max(file date + 20 years, issue date + 17 years)<br />
<br />
::for those patents using 20 years + file date, same as after june 8 1995<br />
<br />
::for those using 17 years + issue date<br />
:::add 4 years to issue date to start<br />
:::add 4 years to issue date after 3.5yr fee<br />
:::add 4 years to issue date after 7.5yr fee<br />
:::add 5 years to issue date after 11.5 yr fee<br />
*Use same method as above for patents issued before June 7 1978<br />
<br />
<br />
<br />
*For patents filed after May 28,2000<br />
::if issue date more than 3 years after file date, then term of patent extended by number of days exceeding 3 years<br />
<br />
<br />
Use the new fee data for this</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=18080Avesh Krishna (Work Log)2017-04-28T19:50:00Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]<br />
<br />
2/15/2017 14:00-17:00 - Helping Catherine with medical data<br />
<br />
2/16/2017 15:45-17:30 - Finding information on small inventors<br />
<br />
2/17/2017 15:00-17:00 - Explaining XML files<br />
<br />
2/22/2017 14:00-16:00 - Figuring out the Patent SQL database<br />
<br />
2/23/2017 15:00 - 16:30 - Helping Catherine with medical centers<br />
<br />
2/24/2017 13:00 - 13:00 - Trying to decrypt what all the tables in the patent database are<br />
<br />
2/28/2017 16:00 - 17:30 - [[Small Inventors Project]]<br />
<br />
3/1/2017 13:30 - 16:00 - [[Small Inventors Project]]<br />
<br />
3/2/2017 15:45-17:30 - building SQL citation tables <br />
<br />
3/3/2017 14:00-16:00 - sql citation tables<br />
<br />
3/7/2017 15:45-17:00 - trying to count small patents by year<br />
<br />
3/8/2017 13:30 - 16:00 writing up wiki page with patent rules [[Patent Rules]]<br />
<br />
3/9/2017 16:00-17:30 [[Patent Rules]]<br />
<br />
3/10/2017 14:15-16:00 Thinking of method for renewals<br />
<br />
3/21/2017 16:00-17:30 <br />
<br />
3/22/2017 15:00-19:30 Patent dinner meeting<br />
<br />
3/23/2017 16:00-17:30 Helping with medical center project<br />
<br />
3/24/2017 13:00-15:00 Cleaning citation tables<br />
<br />
3/28/2017 15:45-17:30 Patent Start End calculations<br />
<br />
3/29/2017 13:00-16:00 Finding patents by size and grant date, splitting by year<br />
<br />
4/4/2017<br />
<br />
4/5/2017<br />
<br />
4/6/2017<br />
<br />
4/11/2017<br />
<br />
4/12/2017<br />
<br />
4/13/2017<br />
<br />
4/14/2017 (Sorry was bad about keeping my worklog by see [[Patent Rules]]<br />
[[Category:Work Log]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=17815Avesh Krishna (Work Log)2017-04-14T20:40:38Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]<br />
<br />
2/15/2017 14:00-17:00 - Helping Catherine with medical data<br />
<br />
2/16/2017 15:45-17:30 - Finding information on small inventors<br />
<br />
2/17/2017 15:00-17:00 - Explaining XML files<br />
<br />
2/22/2017 14:00-16:00 - Figuring out the Patent SQL database<br />
<br />
2/23/2017 15:00 - 16:30 - Helping Catherine with medical centers<br />
<br />
2/24/2017 13:00 - 13:00 - Trying to decrypt what all the tables in the patent database are<br />
<br />
2/28/2017 16:00 - 17:30 - [[Small Inventors Project]]<br />
<br />
3/1/2017 13:30 - 16:00 - [[Small Inventors Project]]<br />
<br />
3/2/2017 15:45-17:30 - building SQL citation tables <br />
<br />
3/3/2017 14:00-16:00 - sql citation tables<br />
<br />
3/7/2017 15:45-17:00 - trying to count small patents by year<br />
<br />
3/8/2017 13:30 - 16:00 writing up wiki page with patent rules [[Patent Rules]]<br />
<br />
3/9/2017 16:00-17:30 [[Patent Rules]]<br />
<br />
3/10/2017 14:15-16:00 Thinking of method for renewals<br />
<br />
3/21/2017 16:00-17:30 <br />
<br />
3/22/2017 15:00-19:30 Patent dinner meeting<br />
<br />
3/23/2017 16:00-17:30 Helping with medical center project<br />
<br />
3/24/2017 13:00-15:00 Cleaning citation tables<br />
<br />
3/28/2017 15:45-17:30 Patent Start End calculations<br />
<br />
3/29/2017 13:00-16:00 Finding patents by size and grant date, splitting by year<br />
<br />
4/4/2017<br />
<br />
4/5/2017<br />
<br />
4/6/2017<br />
<br />
4/11/2017<br />
<br />
4/12/2017<br />
<br />
4/13/2017<br />
<br />
4/14/2017<br />
[[Category:Work Log]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Patent_Expiration_Rules&diff=17814Patent Expiration Rules2017-04-14T20:27:49Z<p>Avesh: </p>
<hr />
<div>Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a patent is valid for after that fee is paid. The DaysDuration is how many total days the patent has been valid for since it's grant date. DaysDuration is the key variable, for each fee paid, we add DaysIncrement to DaysDuration. The DaysDuration past the grant date is the validity of the patent. <br />
<br />
NOTE: This version does not distinguish when to count from filedate or grant date - it only uses grantdate. Prior to XXX (TO BE FILLED IN BY AVESH), patents had statutory terms of 18 yrs from grant. Subsequent to XXX patents have 20 years from application.<br />
<br />
ALSO- keep in mind this is in *allpatentsprocessed* DB, not in the *patent* database.<br />
<br />
Located in <br />
Z:\LBO\Clean\patentExpirationRules.txt<br />
<br />
{| class="wikitable"<br />
! FeeCode<br />
! Description<br />
! DaysIncrement<br />
! DaysDuration<br />
|-<br />
| EXP.<br />
| Patent Expired for Failure to Pay Maintenance Fees.<br />
| 0<br />
| 0<br />
|-<br />
| EXPX<br />
| Patent Reinstated After Maintenance Fee Payment Confirmed.<br />
| 0<br />
| 0<br />
|-<br />
| M1551<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M1552<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M1553<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M1559<br />
| Payment of Maintenance Fee under 1.28(c).<br />
| 0<br />
| 0<br />
|-<br />
| M170<br />
| Payment of Maintenance Fee, 4th Year, PL 96-517.<br />
| 1460<br />
| 2920<br />
|-<br />
| M171<br />
| Payment of Maintenance Fee, 8th Year, PL 96-517.<br />
| 1460<br />
| 4380<br />
|-<br />
| M172<br />
| Payment of Maintenance Fee, 12th Year, PL 96-517.<br />
| 2920<br />
| 7300<br />
|-<br />
| M173<br />
| Payment of Maintenance Fee, 4th Year, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M174<br />
| Payment of Maintenance Fee, 8th Year, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M175<br />
| Payment of Maintenance Fee, 12th Year, PL 97-247<br />
| 2920<br />
| 7300<br />
|-<br />
| M183<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M184<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M185<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M2551<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M2552<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M2553<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M273<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M274<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M275<br />
| Payment of Maintenance Fee,12th Yr, Small Entity, PL 97-247.<br />
| 2920<br />
| 7300<br />
|-<br />
| M283<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M284<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M285<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M3551<br />
| Payment of Maintenance Fee, 4th Year, Micro Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M3552<br />
| Payment of Maintenance Fee, 8th Year, Micro Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M3553<br />
| Payment of Maintenance Fee, 12th Year, Micro Entity.<br />
| 2920<br />
| 7300<br />
|}<br />
<br />
== Building Start and End Table ==<br />
<br />
Created PatentExpirationRules table using the data shown in the table above. Maintfeeevents is a table with all of the USPTO data on fees paid. The earliest grantdate in this dataset is 1981-09-01 and the latest is 2016-06-28. The earliest feedate is 1980-12-19 and the latest feedate is 5000-01-1 (NO THIS IS NOT A TYPO- someone please fix why we have fees being paid in the year 5000). The second latest feedate is 2016-06-13.<br />
<br />
SQL steps are located at <br />
E:\McNair\Projects\LBO\Clean\Building the Patent Start End Table.sql<br />
<br />
/*<br />
These are instructions for building the patentstartend table, which identifies for each patent (number) the dates at which it is granted and at which it expired.<br />
It uses a database of all maintenance fee events and a list of the types of maintenance fee events and their effect the length of patent life <br />
*/<br />
<br />
--First, we need to import the table of Maintenance fee events (from copy in Z:\LBO\Clean, originally from Z:\USPTO_Consolidated\Maint_Fee_Events)<br />
<br />
CREATE TABLE Maintfeeevents (<br />
patentNumber VARCHAR(7) NOT NULL,<br />
appNumber VARCHAR(8) NOT NULL,<br />
smallEntity VARCHAR(1) NOT NULL,<br />
appFilingDate DATE NOT NULL,<br />
grantDate DATE NOT NULL,<br />
feeDate DATE NOT NULL,<br />
feeCode VARCHAR(5) NOT NULL<br />
);<br />
<br />
\COPY Maintfeeevents FROM 'MaintFeeEvents_20160613.txt' WITH DELIMITER AS E' ' HEADER NULL AS '' CSV;<br />
<br />
--Now import table of fee codes (and the duration of the extensions) from (Z:\LBO\Clean)<br />
--daysDuration represents the number of days from grantdate that patent will remain active due to maintenance fee event<br />
--I.e., 8 years for 4th year extension, 12 years for 8th year extension, 20 years for 12th year extension<br />
--Note that we give the expiration events a value of 0 since these can occur after any such extension (or lack thereof).<br />
<br />
CREATE TABLE PatentExpirationRules (<br />
feeCode VARCHAR(5) NOT NULL,<br />
description VARCHAR(255) NOT NULL,<br />
daysIncrement INTEGER NOT NULL,<br />
daysDuration INTEGER NOT NULL<br />
);<br />
\COPY PatentExpirationRules FROM 'patentExpirationRules.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV;<br />
<br />
--We can approximate the actual expiration date by taking the max of daysDuration and adding that number of days to the original grantdate<br />
SELECT M.patentnumber, MAX(M.grantdate) as grantdate, MAX(GREATEST(M.grantdate + P.daysDuration, M.grantdate + 1460)) as expdate<br />
INTO patentstartend<br />
FROM maintfeeevents as M RIGHT JOIN patentexpirationrules as P ON M.feecode = P.feecode<br />
GROUP BY M.patentnumber<br />
;<br />
<br />
/*<br />
There is an alternative way to do this using fee expiration events; however, there are two problems:<br />
1) The USPTO may have accidentally omitted some expiration events<br />
2) Sometimes there are late payments; this leads to reinstatement of the patent. Should be solved by taking last expiration event, but there are potential problems:<br />
2a) See problem 1<br />
2b) Might not have expiration event at conclusion of 20 years (after all three extensions expire)<br />
*/<br />
<br />
<br />
== Updating the Patent Term Calculcations ==</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=17813Small Inventors Project2017-04-14T20:16:07Z<p>Avesh: /* Short Term deliverables */</p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==See Also==<br />
<br />
*[[Small Entity vs. Micro Entity]]<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
*Also see [[Patent Rules]]<br />
<br />
<br />
===Short Term deliverables===<br />
<br />
*count of patents by type by year<br />
*count of citations of type by year<br />
*mean term of patents granted by year <br />
:*can break down by type as well<br />
<br />
<br />
::NOTE: mean stock of patents by type and year<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]<br />
<br />
Want to create a new table with all small and micro patents and if they are small or micro<br />
<br />
Then find all patents citing a small or micro patent<br />
:basically a left join of the table and the citations table (so including small micro or large designation is shown)<br />
<br />
<br />
Look to see how many patents cite knowledge used by small or micro firms <br />
:break down by category small medium large<br />
<br />
Find \<br />
<br />
==Patent Database==<br />
<br />
created citation_cleaned table which removed all rows with NULL value in either column<br />
<br />
Created citations_made table which counts the number of patents cited by a patent<br />
<br />
Created times_cited which counts the number of times a patent is cited<br />
<br />
DROP TABLE citation_cleaned<br />
CREATE TABLE citation_cleaned AS<br />
SELECT patent, cited<br />
FROM citation<br />
WHERE (patent IS NOT NULL AND<br />
citation is NOT NULL);<br />
#SELECT 74164171<br />
<br />
ALTER TABLE citation_cleaned RENAME patent to citing;<br />
<br />
DROP TABLE citations_made<br />
CREATE TABLE citations_made AS<br />
SELECT citing, count(*) as numcitations FROM citation_cleaned GROUP BY citing;<br />
#SELECT 5214098<br />
<br />
DROP TABLE times_cited<br />
CREATE TABLE times_cited AS<br />
SELECT cited, count(*) as citednum FROM citation_cleaned GROUP BY cited;<br />
#SELECT 6977741<br />
<br />
ALTER TABLE citations_made RENAME citing to patent;<br />
ALTER TABLE times_cited RENAME cited to patent;<br />
<br />
<br />
originality vs generality and whole, jaffey, tratjenberg. 4 standard measures : citations made, received, originality, generality. <br />
<br />
citations across classes. <br />
<br />
Whole (2005) paper that corrects the bias inherent in those measure,<br />
<br />
Built initialsize1 table which had each patent and it's size at first fee event and it's grant date.<br />
<br />
Also have an excel sheet with the number of patents granted of each size by year<br />
<br />
Joined initialsize1 and citation_count to get the number of citations on and by each patent with the size and grant date.</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=17494Small Inventors Project2017-04-05T21:43:07Z<p>Avesh: /* Patent Database */</p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==See Also==<br />
<br />
*[[Small Entity vs. Micro Entity]]<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
*Also see [[Patent Rules]]<br />
<br />
<br />
===Short Term deliverables===<br />
<br />
*count of patents by type by year<br />
*count of citations of type by year<br />
*mean term of patents granted by year <br />
:*can break down by type as well<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]<br />
<br />
Want to create a new table with all small and micro patents and if they are small or micro<br />
<br />
Then find all patents citing a small or micro patent<br />
:basically a left join of the table and the citations table (so including small micro or large designation is shown)<br />
<br />
<br />
Look to see how many patents cite knowledge used by small or micro firms <br />
:break down by category small medium large<br />
<br />
Find \<br />
<br />
==Patent Database==<br />
<br />
created citation_cleaned table which removed all rows with NULL value in either column<br />
<br />
Created citations_made table which counts the number of patents cited by a patent<br />
<br />
Created times_cited which counts the number of times a patent is cited<br />
<br />
DROP TABLE citation_cleaned<br />
CREATE TABLE citation_cleaned AS<br />
SELECT patent, cited<br />
FROM citation<br />
WHERE (patent IS NOT NULL AND<br />
citation is NOT NULL);<br />
#SELECT 74164171<br />
<br />
ALTER TABLE citation_cleaned RENAME patent to citing;<br />
<br />
DROP TABLE citations_made<br />
CREATE TABLE citations_made AS<br />
SELECT citing, count(*) as numcitations FROM citation_cleaned GROUP BY citing;<br />
#SELECT 5214098<br />
<br />
DROP TABLE times_cited<br />
CREATE TABLE times_cited AS<br />
SELECT cited, count(*) as citednum FROM citation_cleaned GROUP BY cited;<br />
#SELECT 6977741<br />
<br />
ALTER TABLE citations_made RENAME citing to patent;<br />
ALTER TABLE times_cited RENAME cited to patent;<br />
<br />
<br />
originality vs generality and whole, jaffey, tratjenberg. 4 standard measures : citations made, received, originality, generality. <br />
<br />
citations across classes. <br />
<br />
Whole (2005) paper that corrects the bias inherent in those measure,<br />
<br />
Built initialsize1 table which had each patent and it's size at first fee event and it's grant date.<br />
<br />
Also have an excel sheet with the number of patents granted of each size by year<br />
<br />
Joined initialsize1 and citation_count to get the number of citations on and by each patent with the size and grant date.</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=16678Small Inventors Project2017-03-21T22:32:14Z<p>Avesh: /* General */</p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
*Also see [[Patent Rules]]<br />
<br />
<br />
===Short Term deliverables===<br />
<br />
*count of patents by type by year<br />
*count of citations of type by year<br />
*mean term of patents granted by year <br />
:*can break down by type as well<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]<br />
<br />
Want to create a new table with all small and micro patents and if they are small or micro<br />
<br />
Then find all patents citing a small or micro patent<br />
:basically a left join of the table and the citations table (so including small micro or large designation is shown)<br />
<br />
<br />
Look to see how many patents cite knowledge used by small or micro firms <br />
:break down by category small medium large<br />
<br />
Find \<br />
<br />
==Patent Database==<br />
<br />
created citation_cleaned table which removed all rows with NULL value in either column<br />
<br />
Created citations_made table which counts the number of patents cited by a patent<br />
<br />
Created times_cited which counts the number of times a patent is cited<br />
<br />
DROP TABLE citation_cleaned<br />
CREATE TABLE citation_cleaned AS<br />
SELECT patent, cited<br />
FROM citation<br />
WHERE (patent IS NOT NULL AND<br />
citation is NOT NULL);<br />
#SELECT 74164171<br />
<br />
ALTER TABLE citation_cleaned RENAME patent to citing;<br />
<br />
DROP TABLE citations_made<br />
CREATE TABLE citations_made AS<br />
SELECT citing, count(*) as numcitations FROM citation_cleaned GROUP BY citing;<br />
#SELECT 5214098<br />
<br />
DROP TABLE times_cited<br />
CREATE TABLE times_cited AS<br />
SELECT cited, count(*) as citednum FROM citation_cleaned GROUP BY cited;<br />
#SELECT 6977741<br />
<br />
ALTER TABLE citations_made RENAME citing to patent;<br />
ALTER TABLE times_cited RENAME cited to patent;<br />
<br />
<br />
originality vs generality and whole, jaffey, tratjenberg. 4 standard measures : citations made, received, originality, generality. <br />
<br />
citations across classes. <br />
<br />
Whole (2005) paper that corrects the bias inherent in those measure,</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=16677Avesh Krishna (Work Log)2017-03-21T22:30:54Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]<br />
<br />
2/15/2017 14:00-17:00 - Helping Catherine with medical data<br />
<br />
2/16/2017 15:45-17:30 - Finding information on small inventors<br />
<br />
2/17/2017 15:00-17:00 - Explaining XML files<br />
<br />
2/22/2017 14:00-16:00 - Figuring out the Patent SQL database<br />
<br />
2/23/2017 15:00 - 16:30 - Helping Catherine with medical centers<br />
<br />
2/24/2017 13:00 - 13:00 - Trying to decrypt what all the tables in the patent database are<br />
<br />
2/28/2017 16:00 - 17:30 - [[Small Inventors Project]]<br />
<br />
3/1/2017 13:30 - 16:00 - [[Small Inventors Project]]<br />
<br />
3/2/2017 15:45-17:30 - building SQL citation tables <br />
<br />
3/3/2017 14:00-16:00 - sql citation tables<br />
<br />
3/7/2017 15:45-17:00 - trying to count small patents by year<br />
<br />
3/8/2017 13:30 - 16:00 writing up wiki page with patent rules [[Patent Rules]]<br />
<br />
3/9/2017 16:00-17:30 [[Patent Rules]]<br />
<br />
3/10/2017 14:15-16:00 Thinking of method for renewals<br />
[[Category:Work Log]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=16049Small Inventors Project2017-03-10T20:57:01Z<p>Avesh: /* General */</p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
*Also see [[Patent Rules]]<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]<br />
<br />
Want to create a new table with all small and micro patents and if they are small or micro<br />
<br />
Then find all patents citing a small or micro patent<br />
:basically a left join of the table and the citations table (so including small micro or large designation is shown)<br />
<br />
<br />
Look to see how many patents cite knowledge used by small or micro firms <br />
:break down by category small medium large<br />
<br />
Find \<br />
<br />
==Patent Database==<br />
<br />
created citation_cleaned table which removed all rows with NULL value in either column<br />
<br />
Created citations_made table which counts the number of patents cited by a patent<br />
<br />
Created times_cited which counts the number of times a patent is cited<br />
<br />
DROP TABLE citation_cleaned<br />
CREATE TABLE citation_cleaned AS<br />
SELECT patent, cited<br />
FROM citation<br />
WHERE (patent IS NOT NULL AND<br />
citation is NOT NULL);<br />
#SELECT 74164171<br />
<br />
ALTER TABLE citation_cleaned RENAME patent to citing;<br />
<br />
DROP TABLE citations_made<br />
CREATE TABLE citations_made AS<br />
SELECT citing, count(*) as numcitations FROM citation_cleaned GROUP BY citing;<br />
#SELECT 5214098<br />
<br />
DROP TABLE times_cited<br />
CREATE TABLE times_cited AS<br />
SELECT cited, count(*) as citednum FROM citation_cleaned GROUP BY cited;<br />
#SELECT 6977741<br />
<br />
ALTER TABLE citations_made RENAME citing to patent;<br />
ALTER TABLE times_cited RENAME cited to patent;<br />
<br />
<br />
originality vs generality and whole, jaffey, tratjenberg. 4 standard measures : citations made, received, originality, generality. <br />
<br />
citations across classes. <br />
<br />
Whole (2005) paper that corrects the bias inherent in those measure,</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=16023Small Inventors Project2017-03-09T23:03:34Z<p>Avesh: /* Patent Database */</p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]<br />
<br />
Want to create a new table with all small and micro patents and if they are small or micro<br />
<br />
Then find all patents citing a small or micro patent<br />
:basically a left join of the table and the citations table (so including small micro or large designation is shown)<br />
<br />
<br />
Look to see how many patents cite knowledge used by small or micro firms <br />
:break down by category small medium large<br />
<br />
Find \<br />
<br />
==Patent Database==<br />
<br />
created citation_cleaned table which removed all rows with NULL value in either column<br />
<br />
Created citations_made table which counts the number of patents cited by a patent<br />
<br />
Created times_cited which counts the number of times a patent is cited<br />
<br />
DROP TABLE citation_cleaned<br />
CREATE TABLE citation_cleaned AS<br />
SELECT patent, cited<br />
FROM citation<br />
WHERE (patent IS NOT NULL AND<br />
citation is NOT NULL);<br />
#SELECT 74164171<br />
<br />
ALTER TABLE citation_cleaned RENAME patent to citing;<br />
<br />
DROP TABLE citations_made<br />
CREATE TABLE citations_made AS<br />
SELECT citing, count(*) as numcitations FROM citation_cleaned GROUP BY citing;<br />
#SELECT 5214098<br />
<br />
DROP TABLE times_cited<br />
CREATE TABLE times_cited AS<br />
SELECT cited, count(*) as citednum FROM citation_cleaned GROUP BY cited;<br />
#SELECT 6977741<br />
<br />
ALTER TABLE citations_made RENAME citing to patent;<br />
ALTER TABLE times_cited RENAME cited to patent;<br />
<br />
<br />
originality vs generality and whole, jaffey, tratjenberg. 4 standard measures : citations made, received, originality, generality. <br />
<br />
citations across classes. <br />
<br />
Whole (2005) paper that corrects the bias inherent in those measure,</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Patent_Expiration_Rules&diff=16022Patent Expiration Rules2017-03-09T22:59:12Z<p>Avesh: /* Building Start and End Table */</p>
<hr />
<div>==Patent Expiration Rules==<br />
<br />
Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a patent is valid for after that fee is paid. The DaysDuration is how many total days the patent has been valid for since it's grant date. DaysDuration is the key variable, for each fee paid, we add DaysIncrement to DaysDuration. The DaysDuration past the grant date is the validity of the patent. (NOTE: does not seem to distinguish counting from filedate or grant date, only seems to do it from grantdate) {note to self: find when <br />
<br />
ALSO- keep in mind this is in *allpatentsprocessed* DB, not in the *patent* database.<br />
<br />
Located in <br />
Z:\LBO\Clean\patentExpirationRules.txt<br />
<br />
{| class="wikitable"<br />
! FeeCode<br />
! Description<br />
! DaysIncrement<br />
! DaysDuration<br />
|-<br />
| EXP.<br />
| Patent Expired for Failure to Pay Maintenance Fees.<br />
| 0<br />
| 0<br />
|-<br />
| EXPX<br />
| Patent Reinstated After Maintenance Fee Payment Confirmed.<br />
| 0<br />
| 0<br />
|-<br />
| M1551<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M1552<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M1553<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M1559<br />
| Payment of Maintenance Fee under 1.28(c).<br />
| 0<br />
| 0<br />
|-<br />
| M170<br />
| Payment of Maintenance Fee, 4th Year, PL 96-517.<br />
| 1460<br />
| 2920<br />
|-<br />
| M171<br />
| Payment of Maintenance Fee, 8th Year, PL 96-517.<br />
| 1460<br />
| 4380<br />
|-<br />
| M172<br />
| Payment of Maintenance Fee, 12th Year, PL 96-517.<br />
| 2920<br />
| 7300<br />
|-<br />
| M173<br />
| Payment of Maintenance Fee, 4th Year, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M174<br />
| Payment of Maintenance Fee, 8th Year, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M175<br />
| Payment of Maintenance Fee, 12th Year, PL 97-247<br />
| 2920<br />
| 7300<br />
|-<br />
| M183<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M184<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M185<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M2551<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M2552<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M2553<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M273<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M274<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M275<br />
| Payment of Maintenance Fee,12th Yr, Small Entity, PL 97-247.<br />
| 2920<br />
| 7300<br />
|-<br />
| M283<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M284<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M285<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M3551<br />
| Payment of Maintenance Fee, 4th Year, Micro Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M3552<br />
| Payment of Maintenance Fee, 8th Year, Micro Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M3553<br />
| Payment of Maintenance Fee, 12th Year, Micro Entity.<br />
| 2920<br />
| 7300<br />
|}<br />
<br />
== Building Start and End Table ==<br />
<br />
Created PatentExpirationRules table using the data shown in the table above. Maintfeeevents is a table with all of the USPTO data on fees paid. The earliest grantdate in this dataset is 1981-09-01 and the latest is 2016-06-28. The earliest feedate is 1980-12-19 and the latest feedate is 5000-01-1 (NO THIS IS NOT A TYPO- someone please fix why we have fees being paid in the year 5000). The second latest feedate is 2016-06-13.<br />
<br />
SQL steps are located at <br />
E:\McNair\Projects\LBO\Clean\Building the Patent Start End Table.sql<br />
<br />
/*<br />
These are instructions for building the patentstartend table, which identifies for each patent (number) the dates at which it is granted and at which it expired.<br />
It uses a database of all maintenance fee events and a list of the types of maintenance fee events and their effect the length of patent life <br />
*/<br />
<br />
--First, we need to import the table of Maintenance fee events (from copy in Z:\LBO\Clean, originally from Z:\USPTO_Consolidated\Maint_Fee_Events)<br />
<br />
CREATE TABLE Maintfeeevents (<br />
patentNumber VARCHAR(7) NOT NULL,<br />
appNumber VARCHAR(8) NOT NULL,<br />
smallEntity VARCHAR(1) NOT NULL,<br />
appFilingDate DATE NOT NULL,<br />
grantDate DATE NOT NULL,<br />
feeDate DATE NOT NULL,<br />
feeCode VARCHAR(5) NOT NULL<br />
);<br />
<br />
\COPY Maintfeeevents FROM 'MaintFeeEvents_20160613.txt' WITH DELIMITER AS E' ' HEADER NULL AS '' CSV;<br />
<br />
--Now import table of fee codes (and the duration of the extensions) from (Z:\LBO\Clean)<br />
--daysDuration represents the number of days from grantdate that patent will remain active due to maintenance fee event<br />
--I.e., 8 years for 4th year extension, 12 years for 8th year extension, 20 years for 12th year extension<br />
--Note that we give the expiration events a value of 0 since these can occur after any such extension (or lack thereof).<br />
<br />
CREATE TABLE PatentExpirationRules (<br />
feeCode VARCHAR(5) NOT NULL,<br />
description VARCHAR(255) NOT NULL,<br />
daysIncrement INTEGER NOT NULL,<br />
daysDuration INTEGER NOT NULL<br />
);<br />
\COPY PatentExpirationRules FROM 'patentExpirationRules.txt' WITH DELIMITER AS E'\t' HEADER NULL AS '' CSV;<br />
<br />
--We can approximate the actual expiration date by taking the max of daysDuration and adding that number of days to the original grantdate<br />
SELECT M.patentnumber, MAX(M.grantdate) as grantdate, MAX(GREATEST(M.grantdate + P.daysDuration, M.grantdate + 1460)) as expdate<br />
INTO patentstartend<br />
FROM maintfeeevents as M RIGHT JOIN patentexpirationrules as P ON M.feecode = P.feecode<br />
GROUP BY M.patentnumber<br />
;<br />
<br />
/*<br />
There is an alternative way to do this using fee expiration events; however, there are two problems:<br />
1) The USPTO may have accidentally omitted some expiration events<br />
2) Sometimes there are late payments; this leads to reinstatement of the patent. Should be solved by taking last expiration event, but there are potential problems:<br />
2a) See problem 1<br />
2b) Might not have expiration event at conclusion of 20 years (after all three extensions expire)<br />
*/</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Patent_Expiration_Rules&diff=16020Patent Expiration Rules2017-03-09T22:57:31Z<p>Avesh: /* Patent Expiration Rules */</p>
<hr />
<div>==Patent Expiration Rules==<br />
<br />
Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a patent is valid for after that fee is paid. The DaysDuration is how many total days the patent has been valid for since it's grant date. DaysDuration is the key variable, for each fee paid, we add DaysIncrement to DaysDuration. The DaysDuration past the grant date is the validity of the patent. (NOTE: does not seem to distinguish counting from filedate or grant date, only seems to do it from grantdate) {note to self: find when <br />
<br />
ALSO- keep in mind this is in *allpatentsprocessed* DB, not in the *patent* database.<br />
<br />
Located in <br />
Z:\LBO\Clean\patentExpirationRules.txt<br />
<br />
{| class="wikitable"<br />
! FeeCode<br />
! Description<br />
! DaysIncrement<br />
! DaysDuration<br />
|-<br />
| EXP.<br />
| Patent Expired for Failure to Pay Maintenance Fees.<br />
| 0<br />
| 0<br />
|-<br />
| EXPX<br />
| Patent Reinstated After Maintenance Fee Payment Confirmed.<br />
| 0<br />
| 0<br />
|-<br />
| M1551<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M1552<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M1553<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M1559<br />
| Payment of Maintenance Fee under 1.28(c).<br />
| 0<br />
| 0<br />
|-<br />
| M170<br />
| Payment of Maintenance Fee, 4th Year, PL 96-517.<br />
| 1460<br />
| 2920<br />
|-<br />
| M171<br />
| Payment of Maintenance Fee, 8th Year, PL 96-517.<br />
| 1460<br />
| 4380<br />
|-<br />
| M172<br />
| Payment of Maintenance Fee, 12th Year, PL 96-517.<br />
| 2920<br />
| 7300<br />
|-<br />
| M173<br />
| Payment of Maintenance Fee, 4th Year, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M174<br />
| Payment of Maintenance Fee, 8th Year, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M175<br />
| Payment of Maintenance Fee, 12th Year, PL 97-247<br />
| 2920<br />
| 7300<br />
|-<br />
| M183<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M184<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M185<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M2551<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M2552<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M2553<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M273<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M274<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M275<br />
| Payment of Maintenance Fee,12th Yr, Small Entity, PL 97-247.<br />
| 2920<br />
| 7300<br />
|-<br />
| M283<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M284<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M285<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M3551<br />
| Payment of Maintenance Fee, 4th Year, Micro Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M3552<br />
| Payment of Maintenance Fee, 8th Year, Micro Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M3553<br />
| Payment of Maintenance Fee, 12th Year, Micro Entity.<br />
| 2920<br />
| 7300<br />
|}<br />
<br />
== Building Start and End Table ==<br />
<br />
Created PatentExpirationRules table using the data shown in the table above. Maintfeeevents is a table with all of the USPTO data on fees paid. The earliest grantdate in this dataset is 1981-09-01 and the latest is 2016-06-28. The earliest feedate is 1980-12-19 and the latest feedate is 5000-01-1 (NO THIS IS NOT A TYPO- someone please fix why we have fees being paid in the year 5000). The second latest feedate is 2016-06-13.<br />
<br />
SQL steps are located at <br />
E:\McNair\Projects\LBO\Clean\Building the Patent Start End Table.sql</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Patent_Expiration_Rules&diff=16019Patent Expiration Rules2017-03-09T22:57:20Z<p>Avesh: </p>
<hr />
<div>==Patent Expiration Rules==<br />
<br />
Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a patent is valid for after that fee is paid. The DaysDuration is how many total days the patent has been valid for since it's grant date. DaysDuration is the key variable, for each fee paid, we add DaysIncrement to DaysDuration. The DaysDuration past the grant date is the validity of the patent. (NOTE: does not seem to distinguish counting from filedate or grant date, only seems to do it from grantdate) {note to self: find when <br />
<br />
ALSO- keep in mind this is in *allpatentsprocessed* DB, not in the *patent* database.<br />
<br />
Located in Z:\LBO\Clean\patentExpirationRules.txt<br />
<br />
{| class="wikitable"<br />
! FeeCode<br />
! Description<br />
! DaysIncrement<br />
! DaysDuration<br />
|-<br />
| EXP.<br />
| Patent Expired for Failure to Pay Maintenance Fees.<br />
| 0<br />
| 0<br />
|-<br />
| EXPX<br />
| Patent Reinstated After Maintenance Fee Payment Confirmed.<br />
| 0<br />
| 0<br />
|-<br />
| M1551<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M1552<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M1553<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M1559<br />
| Payment of Maintenance Fee under 1.28(c).<br />
| 0<br />
| 0<br />
|-<br />
| M170<br />
| Payment of Maintenance Fee, 4th Year, PL 96-517.<br />
| 1460<br />
| 2920<br />
|-<br />
| M171<br />
| Payment of Maintenance Fee, 8th Year, PL 96-517.<br />
| 1460<br />
| 4380<br />
|-<br />
| M172<br />
| Payment of Maintenance Fee, 12th Year, PL 96-517.<br />
| 2920<br />
| 7300<br />
|-<br />
| M173<br />
| Payment of Maintenance Fee, 4th Year, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M174<br />
| Payment of Maintenance Fee, 8th Year, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M175<br />
| Payment of Maintenance Fee, 12th Year, PL 97-247<br />
| 2920<br />
| 7300<br />
|-<br />
| M183<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M184<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M185<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M2551<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M2552<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M2553<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M273<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M274<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M275<br />
| Payment of Maintenance Fee,12th Yr, Small Entity, PL 97-247.<br />
| 2920<br />
| 7300<br />
|-<br />
| M283<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M284<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M285<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M3551<br />
| Payment of Maintenance Fee, 4th Year, Micro Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M3552<br />
| Payment of Maintenance Fee, 8th Year, Micro Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M3553<br />
| Payment of Maintenance Fee, 12th Year, Micro Entity.<br />
| 2920<br />
| 7300<br />
|}<br />
<br />
== Building Start and End Table ==<br />
<br />
Created PatentExpirationRules table using the data shown in the table above. Maintfeeevents is a table with all of the USPTO data on fees paid. The earliest grantdate in this dataset is 1981-09-01 and the latest is 2016-06-28. The earliest feedate is 1980-12-19 and the latest feedate is 5000-01-1 (NO THIS IS NOT A TYPO- someone please fix why we have fees being paid in the year 5000). The second latest feedate is 2016-06-13.<br />
<br />
SQL steps are located at <br />
E:\McNair\Projects\LBO\Clean\Building the Patent Start End Table.sql</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Patent_Expiration_Rules&diff=16017Patent Expiration Rules2017-03-09T22:40:53Z<p>Avesh: /* Patent Expiration Rules */</p>
<hr />
<div>==Patent Expiration Rules==<br />
<br />
Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a patent is valid for after that fee is paid. The DaysDuration is how many total days the patent has been valid for since it's grant date. DaysDuration is the key variable, for each fee paid, we add DaysIncrement to DaysDuration. The DaysDuration past the grant date is the validity of the patent. (NOTE: does not seem to distinguish counting from filedate or grant date, only seems to do it from grantdate) {note to self: find when <br />
<br />
ALSO- keep in mind this is in *allpatentsprocessed* DB, not in the *patent* database.<br />
<br />
<br />
{| class="wikitable"<br />
! FeeCode<br />
! Description<br />
! DaysIncrement<br />
! DaysDuration<br />
|-<br />
| EXP.<br />
| Patent Expired for Failure to Pay Maintenance Fees.<br />
| 0<br />
| 0<br />
|-<br />
| EXPX<br />
| Patent Reinstated After Maintenance Fee Payment Confirmed.<br />
| 0<br />
| 0<br />
|-<br />
| M1551<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M1552<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M1553<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M1559<br />
| Payment of Maintenance Fee under 1.28(c).<br />
| 0<br />
| 0<br />
|-<br />
| M170<br />
| Payment of Maintenance Fee, 4th Year, PL 96-517.<br />
| 1460<br />
| 2920<br />
|-<br />
| M171<br />
| Payment of Maintenance Fee, 8th Year, PL 96-517.<br />
| 1460<br />
| 4380<br />
|-<br />
| M172<br />
| Payment of Maintenance Fee, 12th Year, PL 96-517.<br />
| 2920<br />
| 7300<br />
|-<br />
| M173<br />
| Payment of Maintenance Fee, 4th Year, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M174<br />
| Payment of Maintenance Fee, 8th Year, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M175<br />
| Payment of Maintenance Fee, 12th Year, PL 97-247<br />
| 2920<br />
| 7300<br />
|-<br />
| M183<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M184<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M185<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M2551<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M2552<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M2553<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M273<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M274<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M275<br />
| Payment of Maintenance Fee,12th Yr, Small Entity, PL 97-247.<br />
| 2920<br />
| 7300<br />
|-<br />
| M283<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M284<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M285<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M3551<br />
| Payment of Maintenance Fee, 4th Year, Micro Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M3552<br />
| Payment of Maintenance Fee, 8th Year, Micro Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M3553<br />
| Payment of Maintenance Fee, 12th Year, Micro Entity.<br />
| 2920<br />
| 7300<br />
|}<br />
<br />
== Building Start and End Table ==<br />
<br />
Created PatentExpirationRules table using the data shown in the table above. Maintfeeevents is a table with all of the USPTO data on fees paid. The earliest grantdate in this dataset is 1981-09-01 and the latest is 2016-06-28. The earliest feedate is 1980-12-19 and the latest feedate is 5000-01-1 (NO THIS IS NOT A TYPO- someone please fix why we have fees being paid in the year 5000). The second latest feedate is 2016-06-13.</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=16016Small Inventors Project2017-03-09T22:35:47Z<p>Avesh: /* Patent Database */</p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]<br />
<br />
Want to create a new table with all small and micro patents and if they are small or micro<br />
<br />
Then find all patents citing a small or micro patent<br />
:basically a left join of the table and the citations table (so including small micro or large designation is shown)<br />
<br />
<br />
Look to see how many patents cite knowledge used by small or micro firms <br />
:break down by category small medium large<br />
<br />
Find \<br />
<br />
==Patent Database==<br />
<br />
created citation_cleaned table which removed all rows with NULL value in either column<br />
<br />
Created citations_made table which counts the number of patents cited by a patent<br />
<br />
Created times_cited which counts the number of times a patent is cited<br />
<br />
<br />
originality vs generality and whole, jaffey, tratjenberg. 4 standard measures : citations made, received, originality, generality. <br />
<br />
citations across classes. <br />
<br />
Whole (2005) paper that corrects the bias inherent in those measure,</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=16015Small Inventors Project2017-03-09T22:32:47Z<p>Avesh: /* Small Entities */</p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]<br />
<br />
Want to create a new table with all small and micro patents and if they are small or micro<br />
<br />
Then find all patents citing a small or micro patent<br />
:basically a left join of the table and the citations table (so including small micro or large designation is shown)<br />
<br />
<br />
Look to see how many patents cite knowledge used by small or micro firms <br />
:break down by category small medium large<br />
<br />
Find \<br />
<br />
==Patent Database==<br />
<br />
created citation_cleaned table which removed all rows with NULL value in either column<br />
<br />
Created citations_made table which counts the number of patents cited by a patent<br />
<br />
Created times_cited which counts the number of times a patent is cited</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Patent_Expiration_Rules&diff=16014Patent Expiration Rules2017-03-09T22:23:47Z<p>Avesh: </p>
<hr />
<div>==Patent Expiration Rules==<br />
<br />
Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a patent is valid for after that fee is paid. The DaysDuration is how many total days the patent has been valid for since it's grant date. DaysDuration is the key variable, for each fee paid, we add DaysIncrement to DaysDuration. The DaysDuration past the grant date is the validity of the patent. (NOTE: does not seem to distinguish counting from filedate or grant date, only seems to do it from grantdate)<br />
<br />
ALSO- keep in mind this is in *allpatentsprocessed* DB, not in the *patent* database.<br />
<br />
<br />
{| class="wikitable"<br />
! FeeCode<br />
! Description<br />
! DaysIncrement<br />
! DaysDuration<br />
|-<br />
| EXP.<br />
| Patent Expired for Failure to Pay Maintenance Fees.<br />
| 0<br />
| 0<br />
|-<br />
| EXPX<br />
| Patent Reinstated After Maintenance Fee Payment Confirmed.<br />
| 0<br />
| 0<br />
|-<br />
| M1551<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M1552<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M1553<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M1559<br />
| Payment of Maintenance Fee under 1.28(c).<br />
| 0<br />
| 0<br />
|-<br />
| M170<br />
| Payment of Maintenance Fee, 4th Year, PL 96-517.<br />
| 1460<br />
| 2920<br />
|-<br />
| M171<br />
| Payment of Maintenance Fee, 8th Year, PL 96-517.<br />
| 1460<br />
| 4380<br />
|-<br />
| M172<br />
| Payment of Maintenance Fee, 12th Year, PL 96-517.<br />
| 2920<br />
| 7300<br />
|-<br />
| M173<br />
| Payment of Maintenance Fee, 4th Year, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M174<br />
| Payment of Maintenance Fee, 8th Year, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M175<br />
| Payment of Maintenance Fee, 12th Year, PL 97-247<br />
| 2920<br />
| 7300<br />
|-<br />
| M183<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M184<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M185<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M2551<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M2552<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M2553<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M273<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M274<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M275<br />
| Payment of Maintenance Fee,12th Yr, Small Entity, PL 97-247.<br />
| 2920<br />
| 7300<br />
|-<br />
| M283<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M284<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M285<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M3551<br />
| Payment of Maintenance Fee, 4th Year, Micro Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M3552<br />
| Payment of Maintenance Fee, 8th Year, Micro Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M3553<br />
| Payment of Maintenance Fee, 12th Year, Micro Entity.<br />
| 2920<br />
| 7300<br />
|}<br />
<br />
== Building Start and End Table ==<br />
<br />
Created PatentExpirationRules table using the data shown in the table above. Maintfeeevents is a table with all of the USPTO data on fees paid. The earliest grantdate in this dataset is 1981-09-01 and the latest is 2016-06-28. The earliest feedate is 1980-12-19 and the latest feedate is 5000-01-1 (NO THIS IS NOT A TYPO- someone please fix why we have fees being paid in the year 5000). The second latest feedate is 2016-06-13.</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Patent_Expiration_Rules&diff=15967Patent Expiration Rules2017-03-08T20:28:12Z<p>Avesh: </p>
<hr />
<div>==Patent Expiration Rules==<br />
<br />
Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a patent is valid for after that fee is paid. The DaysDuration is how many total days the patent has been valid for since it's grant date. DaysDuration is the key variable, for each fee paid, we add DaysIncrement to DaysDuration. The DaysDuration past the grant date is the validity of the patent. (NOTE: does not seem to distinguish counting from filedate or grant date, only seems to do it from grantdate)<br />
<br />
ALSO- keep in mind this is in *allpatentsprocessed* DB, not in the *patent* database.<br />
<br />
<br />
{| class="wikitable"<br />
! FeeCode<br />
! Description<br />
! DaysIncrement<br />
! DaysDuration<br />
|-<br />
| EXP.<br />
| Patent Expired for Failure to Pay Maintenance Fees.<br />
| 0<br />
| 0<br />
|-<br />
| EXPX<br />
| Patent Reinstated After Maintenance Fee Payment Confirmed.<br />
| 0<br />
| 0<br />
|-<br />
| M1551<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M1552<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M1553<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M1559<br />
| Payment of Maintenance Fee under 1.28(c).<br />
| 0<br />
| 0<br />
|-<br />
| M170<br />
| Payment of Maintenance Fee, 4th Year, PL 96-517.<br />
| 1460<br />
| 2920<br />
|-<br />
| M171<br />
| Payment of Maintenance Fee, 8th Year, PL 96-517.<br />
| 1460<br />
| 4380<br />
|-<br />
| M172<br />
| Payment of Maintenance Fee, 12th Year, PL 96-517.<br />
| 2920<br />
| 7300<br />
|-<br />
| M173<br />
| Payment of Maintenance Fee, 4th Year, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M174<br />
| Payment of Maintenance Fee, 8th Year, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M175<br />
| Payment of Maintenance Fee, 12th Year, PL 97-247<br />
| 2920<br />
| 7300<br />
|-<br />
| M183<br />
| Payment of Maintenance Fee, 4th Year, Large Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M184<br />
| Payment of Maintenance Fee, 8th Year, Large Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M185<br />
| Payment of Maintenance Fee, 12th Year, Large Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M2551<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M2552<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M2553<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M273<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 2920<br />
|-<br />
| M274<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity, PL 97-247.<br />
| 1460<br />
| 4380<br />
|-<br />
| M275<br />
| Payment of Maintenance Fee,12th Yr, Small Entity, PL 97-247.<br />
| 2920<br />
| 7300<br />
|-<br />
| M283<br />
| Payment of Maintenance Fee, 4th Yr, Small Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M284<br />
| Payment of Maintenance Fee, 8th Yr, Small Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M285<br />
| Payment of Maintenance Fee, 12th Yr, Small Entity.<br />
| 2920<br />
| 7300<br />
|-<br />
| M3551<br />
| Payment of Maintenance Fee, 4th Year, Micro Entity.<br />
| 1460<br />
| 2920<br />
|-<br />
| M3552<br />
| Payment of Maintenance Fee, 8th Year, Micro Entity.<br />
| 1460<br />
| 4380<br />
|-<br />
| M3553<br />
| Payment of Maintenance Fee, 12th Year, Micro Entity.<br />
| 2920<br />
| 7300<br />
|}</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Patent_Expiration_Rules&diff=15966Patent Expiration Rules2017-03-08T20:26:43Z<p>Avesh: Created page with "==Patent Expiration Rules== Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a..."</p>
<hr />
<div>==Patent Expiration Rules==<br />
<br />
Based on the fees paid, we can determine the validity of a patent. Each fee is coded and the DaysIncrement variable indicates how many more days a patent is valid for after that fee is paid. The DaysDuration is how many total days the patent has been valid for since it's grant date. DaysDuration is the key variable, for each fee paid, we add DaysIncrement to DaysDuration. The DaysDuration past the grant date is the validity of the patent. (NOTE: does not seem to distinguish counting from filedate or grant date, only seems to do it from grantdate)<br />
<br />
ALSO- keep in mind this is in *allpatentsprocessed* DB, not in the *patent* database.<br />
<br />
<br />
{|<br />
! FeeCode || Description || DaysIncrement || DaysDuration<br />
|-<br />
| EXP. || Patent Expired for Failure to Pay Maintenance Fees. || 0 || 0<br />
|-<br />
| EXPX || Patent Reinstated After Maintenance Fee Payment Confirmed. || 0 || 0<br />
|-<br />
| M1551 || Payment of Maintenance Fee, 4th Year, Large Entity. || 1460 || 2920<br />
|-<br />
| M1552 || Payment of Maintenance Fee, 8th Year, Large Entity. || 1460 || 4380<br />
|-<br />
| M1553 || Payment of Maintenance Fee, 12th Year, Large Entity. || 2920 || 7300<br />
|-<br />
| M1559 || Payment of Maintenance Fee under 1.28(c). || 0 || 0<br />
|-<br />
| M170 || Payment of Maintenance Fee, 4th Year, PL 96-517. || 1460 || 2920<br />
|-<br />
| M171 || Payment of Maintenance Fee, 8th Year, PL 96-517. || 1460 || 4380<br />
|-<br />
| M172 || Payment of Maintenance Fee, 12th Year, PL 96-517. || 2920 || 7300<br />
|-<br />
| M173 || Payment of Maintenance Fee, 4th Year, PL 97-247. || 1460 || 2920<br />
|-<br />
| M174 || Payment of Maintenance Fee, 8th Year, PL 97-247. || 1460 || 4380<br />
|-<br />
| M175 || Payment of Maintenance Fee, 12th Year, PL 97-247 || 2920 || 7300<br />
|-<br />
| M183 || Payment of Maintenance Fee, 4th Year, Large Entity. || 1460 || 2920<br />
|-<br />
| M184 || Payment of Maintenance Fee, 8th Year, Large Entity. || 1460 || 4380<br />
|-<br />
| M185 || Payment of Maintenance Fee, 12th Year, Large Entity. || 2920 || 7300<br />
|-<br />
| M2551 || Payment of Maintenance Fee, 4th Yr, Small Entity. || 1460 || 2920<br />
|-<br />
| M2552 || Payment of Maintenance Fee, 8th Yr, Small Entity. || 1460 || 4380<br />
|-<br />
| M2553 || Payment of Maintenance Fee, 12th Yr, Small Entity. || 2920 || 7300<br />
|-<br />
| M273 || Payment of Maintenance Fee, 4th Yr, Small Entity, PL 97-247. || 1460 || 2920<br />
|-<br />
| M274 || Payment of Maintenance Fee, 8th Yr, Small Entity, PL 97-247. || 1460 || 4380<br />
|-<br />
| M275 || Payment of Maintenance Fee,12th Yr, Small Entity, PL 97-247. || 2920 || 7300<br />
|-<br />
| M283 || Payment of Maintenance Fee, 4th Yr, Small Entity. || 1460 || 2920<br />
|-<br />
| M284 || Payment of Maintenance Fee, 8th Yr, Small Entity. || 1460 || 4380<br />
|-<br />
| M285 || Payment of Maintenance Fee, 12th Yr, Small Entity. || 2920 || 7300<br />
|-<br />
| M3551 || Payment of Maintenance Fee, 4th Year, Micro Entity. || 1460 || 2920<br />
|-<br />
| M3552 || Payment of Maintenance Fee, 8th Year, Micro Entity. || 1460 || 4380<br />
|-<br />
| M3553 || Payment of Maintenance Fee, 12th Year, Micro Entity. || 2920 || 7300<br />
|}</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=15962Avesh Krishna (Work Log)2017-03-08T19:52:09Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]<br />
<br />
2/15/2017 14:00-17:00 - Helping Catherine with medical data<br />
<br />
2/16/2017 15:45-17:30 - Finding information on small inventors<br />
<br />
2/17/2017 15:00-17:00 - Explaining XML files<br />
<br />
2/22/2017 14:00-16:00 - Figuring out the Patent SQL database<br />
<br />
2/23/2017 15:00 - 16:30 - Helping Catherine with medical centers<br />
<br />
2/24/2017 13:00 - 13:00 - Trying to decrypt what all the tables in the patent database are<br />
<br />
2/28/2017 16:00 - 17:30 - [[Small Inventors Project]]<br />
<br />
3/1/2017 13:30 - 16:00 - [[Small Inventors Project]]<br />
<br />
3/2/2017 15:45-17:30 - building SQL citation tables <br />
<br />
3/3/2017 14:00-16:00 - sql citation tables<br />
<br />
3/7/2017 15:45-17:00 - trying to count small patents by year<br />
<br />
3/8/2017 13:30 - 16:00 writing up wiki page with patent rules [[Patent Rules]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=15960Avesh Krishna (Work Log)2017-03-08T19:51:25Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]<br />
<br />
2/15/2017 14:00-17:00 - Helping Catherine with medical data<br />
<br />
2/16/2017 15:45-17:30 - Finding information on small inventors<br />
<br />
2/17/2017 15:00-17:00 - Explaining XML files<br />
<br />
2/22/2017 14:00-16:00 - Figuring out the Patent SQL database<br />
<br />
2/23/2017 15:00 - 16:30 - Helping Catherine with medical centers<br />
<br />
2/24/2017 13:00 - 13:00 - Trying to decrypt what all the tables in the patent database are<br />
<br />
2/28/2017 16:00 - 17:30 - [[Small Inventors Project]]<br />
<br />
3/1/2017 13:30 - 16:00 - [[Small Inventors Project]]<br />
<br />
3/2/2017 15:45-17:30 - building SQL citation tables <br />
<br />
3/3/2017 14:00-16:00 - sql citation tables<br />
<br />
3/7/2017 15:45-17:00 - trying to count small patents by year</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna&diff=15958Avesh Krishna2017-03-08T19:49:36Z<p>Avesh: /* Education */</p>
<hr />
<div>{{McNair Staff<br />
|position=Research Team<br />
|name=Avesh Krishna<br />
|user_image=Avesh_Krishna_Picture.jpg | 300px<br />
|degree=BA<br />
|major=Political Science; Policy Studies; Pre-Law<br />
|class=2019<br />
|join_date=September 2016<br />
|skills=Python, R, Writing, Public Speaking<br />
|interests=Live Music, Public Policy, Food, Art and Design<br />
|email=avesh@rice.edu<br />
|skype_name=avesh.tx<br />
|status=Active<br />
}}<br />
Avesh J. Krishna is a sophomore at Rice University studying Political Science and Policy Studies. He currently works as a research assistant for the Baker Institute for Public Policy’s McNair Center for Entrepreneurship and Innovation. <br />
<br />
==Early Life==<br />
<br />
Avesh was born in Westchester County, New York to parents Dr. Arvind and Mrs. Sonia Krishna. Since 2005, the Krishna family has lived in Ridgefield, Connecticut. He has a younger sister, Tarini Krishna, who currently attends Ridgefield High School. <br />
<br />
==Education==<br />
<br />
Avesh graduated from Ridgefield High School in Ridgefield, Connecticut in June 2015. At Ridgefield High School Avesh was the captain of the Mock Trial Team and Debate Team as well as serving in leadership roles in student government and the National Honor Society chapter. His involvement in debate and mock trial motivated him to pursue further study in the social sciences, and flirts with the idea of attending law school. In August 2015, Avesh began his undergraduate education at Rice University in Houston, Texas where he currently is a sophomore Political Science major and pursuing a minor in statistics. He is a member of Brown College at Rice.<br />
<br />
==Work Experience==<br />
<br />
This past summer, Avesh worked as a research intern at IBM Research in Yorktown Heights, New York. He worked with the Deep Learning group to develop visualization techniques for training processes. Avesh has also worked with the Local Elections for America Project as a research assistant collecting and analyzing local governments across the nation. The prior summer, Avesh worked as an intellectual property analyst at Intellectual Profit LLC where he gained experience with the legal and commercial aspects of innovation. <br />
<br />
==Other Activities==<br />
Avesh is involved at Brown College as a committee chair and an academic fellow. He additionally DJs for Rice’s radio station KTRU. You can listen to him on KTRU from 8 to 10 AM Wednesday mornings. <br />
<br />
<br />
==McNair Updates==<br />
[[Avesh Krishna (Work Log)]]<br />
<br />
[[Avesh Krishna (Research Plan)]]<br />
<br />
<!-- null edit dummy -->[[Category:McNair Staff]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=14948Avesh Krishna (Work Log)2017-03-01T21:49:04Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]<br />
<br />
2/15/2017 14:00-17:00 - Helping Catherine with medical data<br />
<br />
2/16/2017 15:45-17:30 - Finding information on small inventors<br />
<br />
2/17/2017 15:00-17:00 - Explaining XML files<br />
<br />
2/22/2017 14:00-16:00 - Figuring out the Patent SQL database<br />
<br />
2/23/2017 15:00 - 16:30 - Helping Catherine with medical centers<br />
<br />
2/24/2017 13:00 - 13:00 - Trying to decrypt what all the tables in the patent database are<br />
<br />
2/28/2017 16:00 - 17:30 - [[Small Inventors Project]]<br />
<br />
3/1/2017 13:30 - 16:00 - [[Small Inventors Project]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=14947Small Inventors Project2017-03-01T21:47:10Z<p>Avesh: /* Small Entities */</p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]<br />
<br />
<br />
==Patent Database==<br />
<br />
created citation_cleaned table which removed all rows with NULL value in either column<br />
<br />
Created citations_made table which counts the number of patents cited by a patent<br />
<br />
Created times_cited which counts the number of times a patent is cited</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=14945Small Inventors Project2017-03-01T21:05:29Z<p>Avesh: </p>
<hr />
<div>{{McNair Projects<br />
|Image= <br />
|Has title=Small Inventors Project<br />
|Has owner=Avesh Krishna<br />
|Has start date=201702<br />
|Has deadline=201705<br />
|Has keywords=Patents, Small Business<br />
|Is billed to=<br />
|Has notes=<br />
|Has project status=Active<br />
|Is dependent on=<br />
|Depends upon it=<br />
}}<br />
<br />
==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=14942Small Inventors Project2017-03-01T21:03:09Z<p>Avesh: /* Small Entities */</p>
<hr />
<div>==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business<br />
<br />
How to find: <br />
[[Fee Status Table]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=14940Avesh Krishna (Work Log)2017-03-01T20:07:17Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]<br />
<br />
2/15/2017 14:00-17:00 - Helping Catherine with medical data<br />
<br />
2/16/2017 15:45-17:30 - Finding information on small inventors<br />
<br />
2/17/2017 15:00-17:00 - Explaining XML files<br />
<br />
2/22/2017 14:00-16:00 - Figuring out the Patent SQL database<br />
<br />
2/23/2017 15:00 - 16:30 - Helping Catherine with medical centers<br />
<br />
2/24/2017 13:00 - 13:00 - Trying to decrypt what all the tables in the patent database are</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=14207Avesh Krishna (Work Log)2017-02-22T20:35:42Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]<br />
<br />
2/15/2017 14:00-17:00 - Helping Catherine with medical data<br />
<br />
2/16/2017 15:45-17:30 - Finding information on small inventors<br />
<br />
2/17/2017 15:00-17:00 - Explaining XML files</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=14206Small Inventors Project2017-02-22T20:33:47Z<p>Avesh: /* General */</p>
<hr />
<div>==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at<br />
<br />
==Micro Entities==<br />
<br />
Include institutes of higher education (those meeting definition in 20 U.S. Code § 1001: https://www.law.cornell.edu/uscode/text/20/1001<br />
: either an employee of institute of higher education OR<br />
: rights to patent will be assigned to institute of higher education<br />
:: however if the university applies for a patent with the university as the investor/applicant then cannot be a microentity<br />
<br />
==Small Entities==<br />
<br />
Is a person or small business</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=14002Small Inventors Project2017-02-14T22:37:59Z<p>Avesh: </p>
<hr />
<div>==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
*Identify small inventors<br />
*Are they patenting more or less<br />
*Has AIA helped them<br />
*Are their patents being attacked in IPR/litigation<br />
*What do they do with their IP (license/transfer)<br />
*What are they valued at</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Small_Inventors_Project&diff=14000Small Inventors Project2017-02-14T22:36:25Z<p>Avesh: Created page with "==General== Story: What happened to the American Small Inventor Identify small inventors Are they patenting more or less Has AIA helped them Are their patents being a..."</p>
<hr />
<div>==General==<br />
<br />
Story: What happened to the American Small Inventor<br />
Identify small inventors<br />
Are they patenting more or less<br />
Has AIA helped them<br />
Are their patents being attacked in IPR/litigation<br />
What do they do with their IP (license/transfer)<br />
What are they valued at</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=13999Avesh Krishna (Work Log)2017-02-14T22:34:53Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project<br />
<br />
2/14/2017 15:45-17:30 - [[Small Inventors Project]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=13997Avesh Krishna (Work Log)2017-02-14T22:31:41Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester<br />
<br />
1/27/2017 13:00-15:00 [[Federal Grant Data]]<br />
<br />
2/1/2017 15:45-17:30 Discussing possible projects with Ed<br />
<br />
2/2/2017 14:00-17:00 Downloading XML files and writing wiki pages up<br />
<br />
2/3/2017 15:45-17:30 <br />
<br />
2/4/2017 13:00-15:00 Ending grant and clinical trial data<br />
<br />
2/7/2017 15:45-17:00 - Thinking about next steps<br />
<br />
2/13/2017 13:00-14:00 - Small Inventor Patent Data Project</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Federal_Grant_Data&diff=13450Federal Grant Data2017-01-26T23:10:28Z<p>Avesh: /* NSF Grant Data */</p>
<hr />
<div>==General==<br />
<br />
Finding NIH, NSF, and other federal grant data<br />
<br />
==grants.gov==<br />
<br />
Lists agency, estimated funding, opportunity title. opportunity number, and the date. Can be used to look up who was awarded the grants. I downloaded all grants offered by the NIH since 2005 (when the data was available)<br />
E:\McNair\Projects\Federal Grant Data\NIH<br />
<br />
==NSF Grant Data==<br />
<br />
The NSF grant data are in folders by year, each grant is an xml file. The format of a typical file is shown below. There is data available from 1959 onwards, and full records after 1976. In 2016 there were ~10,000 awards. <br />
<br />
Each year can be downloaded from: [https://www.nsf.gov/awardsearch/download.jsp https://www.nsf.gov/awardsearch/download.jsp]<br />
<br />
Data is located in:<br />
E:\McNair\Projects\Federal Grant Data\NSF<br />
<br />
Sample XML schema <br />
<br />
<rootTag><br />
<Award><br />
<AwardTitle><br />
Collaborative Research: Hybrid Organic-Inorganic Thermoelectric Materials<br />
</AwardTitle><br />
<AwardEffectiveDate>08/31/2016</AwardEffectiveDate><br />
<AwardExpirationDate>06/30/2017</AwardExpirationDate><br />
<AwardAmount>95461</AwardAmount><br />
<AwardInstrument><br />
<Value>Standard Grant</Value><br />
</AwardInstrument><br />
<Organization><br />
<Code>07030000</Code><br />
<Directorate><br />
<LongName>Directorate For Engineering</LongName><br />
</Directorate><br />
<Division><br />
<LongName>Div Of Civil, Mechanical, & Manufact Inn</LongName><br />
</Division><br />
</Organization><br />
<ProgramOfficer><br />
<SignBlockName>Thomas F. Kuech</SignBlockName><br />
</ProgramOfficer><br />
<AbstractNarration><br />
Thermoelectric materials are materials which can be used to convert thermal energy directly to electricity. The performance of a thermoelectric material is measured by the "figure of merit", termed ZT. There has been much research into increasing thermoelectric materials, figure of merit, however, progress in this area has been slow and most of the researched thermoelectric materials up to now are suffering from either high fabrication cost, usage of rare earth or toxic elements, or poor mechanical properties. Organic thermoelectric materials (OTEs) have recently attracted attention for low temperature applications (< 300K), especially cooling purposes, as they are flexible, low-cost and abundant, and low-cost fabrication methods for synthesizing them exist... A large class of semiconducting nanostructures (e.g. Si, CdTe, Bi, and PbTe nanowires and holely structures) combined with conjugated polymers (e.g., chemically-modified PEDOT and low bandgap polymers) and organic molecules (specifically charged chemical species attached to molecules such as CF3- substituted styrene molecules) will be simulated, synthesized and optimized to identify new hybrid materials with a potentially high ZT.<br />
</AbstractNarration><br />
<MinAmdLetterDate>12/22/2016</MinAmdLetterDate><br />
<MaxAmdLetterDate>12/22/2016</MaxAmdLetterDate><br />
<ARRAAmount/><br />
<AwardID>1723353</AwardID><br />
<Investigator><br />
<FirstName>Mona</FirstName><br />
<LastName>Zebarjadi</LastName><br />
<EmailAddress>mz6g@virginia.edu</EmailAddress><br />
<StartDate>12/22/2016</StartDate><br />
<EndDate/><br />
<RoleCode>Principal Investigator</RoleCode><br />
</Investigator><br />
<Institution><br />
<Name>University of Virginia Main Campus</Name><br />
<CityName>CHARLOTTESVILLE</CityName><br />
<ZipCode>229044195</ZipCode><br />
<PhoneNumber>4349244270</PhoneNumber><br />
<StreetAddress>P.O. BOX 400195</StreetAddress><br />
<CountryName>United States</CountryName><br />
<StateName>Virginia</StateName><br />
<StateCode>VA</StateCode><br />
</Institution><br />
<ProgramElement><br />
<Code>8092</Code><br />
<Text>Materials Eng. & Processing</Text><br />
</ProgramElement><br />
<ProgramReference><br />
<Code>024E</Code><br />
<Text>MATERIALS DESIGN</Text><br />
</ProgramReference><br />
<ProgramReference><br />
<Code>036E</Code><br />
<Text>CIVIL INFRASTRUCTURE</Text><br />
</ProgramReference><br />
</Award><br />
</rootTag><br />
<br />
==Survey of Federal Funds for Research and Development Fiscal Years 2014–16==<br />
<br />
Excel spreadsheets with data regarding Federal Agency budgets and spending on R&D [https://ncsesdata.nsf.gov/fedfunds/2014/]<br />
<br />
E:\McNair\Projects\Federal Grant Data\NSF\NSF Data Tables<br />
<br />
==NIH==<br />
<br />
NIH grants for a given year can be downloaded from [https://report.nih.gov/award/index.cfm https://report.nih.gov/award/index.cfm]<br />
<br />
This does not specify what the grant was for, but it does list the amount and organization who received the grant. Additionally, the city and state of the organization are included. The number of awards received by each organization in a given year is listed as well. Excel Tables can be downloaded for each each year at this site. I downloaded the table for 2016 as a sample.<br />
E:\McNair\Projects\Federal Grant Data\NIH</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Federal_Grant_Data&diff=13449Federal Grant Data2017-01-26T23:10:18Z<p>Avesh: /* grants.gov */</p>
<hr />
<div>==General==<br />
<br />
Finding NIH, NSF, and other federal grant data<br />
<br />
==grants.gov==<br />
<br />
Lists agency, estimated funding, opportunity title. opportunity number, and the date. Can be used to look up who was awarded the grants. I downloaded all grants offered by the NIH since 2005 (when the data was available)<br />
E:\McNair\Projects\Federal Grant Data\NIH<br />
<br />
==NSF Grant Data==<br />
<br />
The NSF grant data are in folders by year, each grant is an xml file. The format of a typical file is shown below. There is data available from 1959 onwards, and full records after 1976. In 2016 there were ~10,000 awards. <br />
<br />
Each year can be downloaded from: [https://www.nsf.gov/awardsearch/download.jsp https://www.nsf.gov/awardsearch/download.jsp]<br />
<br />
Data is located in:<br />
E:\McNair\Projects\Federal Grant Data\NSF<br />
<br />
Sample XML schema <br />
<br />
<rootTag><br />
<Award><br />
<AwardTitle><br />
Collaborative Research: Hybrid Organic-Inorganic Thermoelectric Materials<br />
</AwardTitle><br />
<AwardEffectiveDate>08/31/2016</AwardEffectiveDate><br />
<AwardExpirationDate>06/30/2017</AwardExpirationDate><br />
<AwardAmount>95461</AwardAmount><br />
<AwardInstrument><br />
<Value>Standard Grant</Value><br />
</AwardInstrument><br />
<Organization><br />
<Code>07030000</Code><br />
<Directorate><br />
<LongName>Directorate For Engineering</LongName><br />
</Directorate><br />
<Division><br />
<LongName>Div Of Civil, Mechanical, & Manufact Inn</LongName><br />
</Division><br />
</Organization><br />
<ProgramOfficer><br />
<SignBlockName>Thomas F. Kuech</SignBlockName><br />
</ProgramOfficer><br />
<AbstractNarration><br />
Thermoelectric materials are materials which can be used to convert thermal energy directly to electricity. The performance of a thermoelectric material is measured by the "figure of merit", termed ZT. There has been much research into increasing thermoelectric materials, figure of merit, however, progress in this area has been slow and most of the researched thermoelectric materials up to now are suffering from either high fabrication cost, usage of rare earth or toxic elements, or poor mechanical properties. Organic thermoelectric materials (OTEs) have recently attracted attention for low temperature applications (< 300K), especially cooling purposes, as they are flexible, low-cost and abundant, and low-cost fabrication methods for synthesizing them exist... A large class of semiconducting nanostructures (e.g. Si, CdTe, Bi, and PbTe nanowires and holely structures) combined with conjugated polymers (e.g., chemically-modified PEDOT and low bandgap polymers) and organic molecules (specifically charged chemical species attached to molecules such as CF3- substituted styrene molecules) will be simulated, synthesized and optimized to identify new hybrid materials with a potentially high ZT.<br />
</AbstractNarration><br />
<MinAmdLetterDate>12/22/2016</MinAmdLetterDate><br />
<MaxAmdLetterDate>12/22/2016</MaxAmdLetterDate><br />
<ARRAAmount/><br />
<AwardID>1723353</AwardID><br />
<Investigator><br />
<FirstName>Mona</FirstName><br />
<LastName>Zebarjadi</LastName><br />
<EmailAddress>mz6g@virginia.edu</EmailAddress><br />
<StartDate>12/22/2016</StartDate><br />
<EndDate/><br />
<RoleCode>Principal Investigator</RoleCode><br />
</Investigator><br />
<Institution><br />
<Name>University of Virginia Main Campus</Name><br />
<CityName>CHARLOTTESVILLE</CityName><br />
<ZipCode>229044195</ZipCode><br />
<PhoneNumber>4349244270</PhoneNumber><br />
<StreetAddress>P.O. BOX 400195</StreetAddress><br />
<CountryName>United States</CountryName><br />
<StateName>Virginia</StateName><br />
<StateCode>VA</StateCode><br />
</Institution><br />
<ProgramElement><br />
<Code>8092</Code><br />
<Text>Materials Eng. & Processing</Text><br />
</ProgramElement><br />
<ProgramReference><br />
<Code>024E</Code><br />
<Text>MATERIALS DESIGN</Text><br />
</ProgramReference><br />
<ProgramReference><br />
<Code>036E</Code><br />
<Text>CIVIL INFRASTRUCTURE</Text><br />
</ProgramReference><br />
</Award><br />
</rootTag><br />
<br />
==Survey of Federal Funds for Research and Development Fiscal Years 2014–16==<br />
<br />
Excel spreadsheets with data regarding Federal Agency budgets and spending on R&D [https://ncsesdata.nsf.gov/fedfunds/2014/]<br />
<br />
E:\McNair\Projects\Federal Grant Data\NSF\NSF Data Tables<br />
<br />
==NIH==<br />
<br />
NIH grants for a given year can be downloaded from [https://report.nih.gov/award/index.cfm https://report.nih.gov/award/index.cfm]<br />
<br />
This does not specify what the grant was for, but it does list the amount and organization who received the grant. Additionally, the city and state of the organization are included. The number of awards received by each organization in a given year is listed as well. Excel Tables can be downloaded for each each year at this site. I downloaded the table for 2016 as a sample.<br />
E:\McNair\Projects\Federal Grant Data\NIH</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Federal_Grant_Data&diff=13448Federal Grant Data2017-01-26T23:10:00Z<p>Avesh: /* NIH */</p>
<hr />
<div>==General==<br />
<br />
Finding NIH, NSF, and other federal grant data<br />
<br />
==grants.gov==<br />
<br />
Lists agency, estimated funding, opportunity title. opportunity number, and the date. Can be used to look up who was awarded the grants. I downloaded all grants offered by the NIH since 2005 (when the data was available)<br />
E:\McNair\Projects\Federal Grant Data\NIH<br />
<br />
==NSF Grant Data==<br />
<br />
The NSF grant data are in folders by year, each grant is an xml file. The format of a typical file is shown below. There is data available from 1959 onwards, and full records after 1976. In 2016 there were ~10,000 awards. <br />
<br />
Each year can be downloaded from: [https://www.nsf.gov/awardsearch/download.jsp https://www.nsf.gov/awardsearch/download.jsp]<br />
<br />
Data is located in:<br />
E:\McNair\Projects\Federal Grant Data\NSF<br />
<br />
Sample XML schema <br />
<br />
<rootTag><br />
<Award><br />
<AwardTitle><br />
Collaborative Research: Hybrid Organic-Inorganic Thermoelectric Materials<br />
</AwardTitle><br />
<AwardEffectiveDate>08/31/2016</AwardEffectiveDate><br />
<AwardExpirationDate>06/30/2017</AwardExpirationDate><br />
<AwardAmount>95461</AwardAmount><br />
<AwardInstrument><br />
<Value>Standard Grant</Value><br />
</AwardInstrument><br />
<Organization><br />
<Code>07030000</Code><br />
<Directorate><br />
<LongName>Directorate For Engineering</LongName><br />
</Directorate><br />
<Division><br />
<LongName>Div Of Civil, Mechanical, & Manufact Inn</LongName><br />
</Division><br />
</Organization><br />
<ProgramOfficer><br />
<SignBlockName>Thomas F. Kuech</SignBlockName><br />
</ProgramOfficer><br />
<AbstractNarration><br />
Thermoelectric materials are materials which can be used to convert thermal energy directly to electricity. The performance of a thermoelectric material is measured by the "figure of merit", termed ZT. There has been much research into increasing thermoelectric materials, figure of merit, however, progress in this area has been slow and most of the researched thermoelectric materials up to now are suffering from either high fabrication cost, usage of rare earth or toxic elements, or poor mechanical properties. Organic thermoelectric materials (OTEs) have recently attracted attention for low temperature applications (< 300K), especially cooling purposes, as they are flexible, low-cost and abundant, and low-cost fabrication methods for synthesizing them exist... A large class of semiconducting nanostructures (e.g. Si, CdTe, Bi, and PbTe nanowires and holely structures) combined with conjugated polymers (e.g., chemically-modified PEDOT and low bandgap polymers) and organic molecules (specifically charged chemical species attached to molecules such as CF3- substituted styrene molecules) will be simulated, synthesized and optimized to identify new hybrid materials with a potentially high ZT.<br />
</AbstractNarration><br />
<MinAmdLetterDate>12/22/2016</MinAmdLetterDate><br />
<MaxAmdLetterDate>12/22/2016</MaxAmdLetterDate><br />
<ARRAAmount/><br />
<AwardID>1723353</AwardID><br />
<Investigator><br />
<FirstName>Mona</FirstName><br />
<LastName>Zebarjadi</LastName><br />
<EmailAddress>mz6g@virginia.edu</EmailAddress><br />
<StartDate>12/22/2016</StartDate><br />
<EndDate/><br />
<RoleCode>Principal Investigator</RoleCode><br />
</Investigator><br />
<Institution><br />
<Name>University of Virginia Main Campus</Name><br />
<CityName>CHARLOTTESVILLE</CityName><br />
<ZipCode>229044195</ZipCode><br />
<PhoneNumber>4349244270</PhoneNumber><br />
<StreetAddress>P.O. BOX 400195</StreetAddress><br />
<CountryName>United States</CountryName><br />
<StateName>Virginia</StateName><br />
<StateCode>VA</StateCode><br />
</Institution><br />
<ProgramElement><br />
<Code>8092</Code><br />
<Text>Materials Eng. & Processing</Text><br />
</ProgramElement><br />
<ProgramReference><br />
<Code>024E</Code><br />
<Text>MATERIALS DESIGN</Text><br />
</ProgramReference><br />
<ProgramReference><br />
<Code>036E</Code><br />
<Text>CIVIL INFRASTRUCTURE</Text><br />
</ProgramReference><br />
</Award><br />
</rootTag><br />
<br />
==Survey of Federal Funds for Research and Development Fiscal Years 2014–16==<br />
<br />
Excel spreadsheets with data regarding Federal Agency budgets and spending on R&D [https://ncsesdata.nsf.gov/fedfunds/2014/]<br />
<br />
E:\McNair\Projects\Federal Grant Data\NSF\NSF Data Tables<br />
<br />
==NIH==<br />
<br />
NIH grants for a given year can be downloaded from [https://report.nih.gov/award/index.cfm https://report.nih.gov/award/index.cfm]<br />
<br />
This does not specify what the grant was for, but it does list the amount and organization who received the grant. Additionally, the city and state of the organization are included. The number of awards received by each organization in a given year is listed as well. Excel Tables can be downloaded for each each year at this site. I downloaded the table for 2016 as a sample.<br />
E:\McNair\Projects\Federal Grant Data\NIH</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Federal_Grant_Data&diff=13447Federal Grant Data2017-01-26T23:09:18Z<p>Avesh: </p>
<hr />
<div>==General==<br />
<br />
Finding NIH, NSF, and other federal grant data<br />
<br />
==grants.gov==<br />
<br />
Lists agency, estimated funding, opportunity title. opportunity number, and the date. Can be used to look up who was awarded the grants. I downloaded all grants offered by the NIH since 2005 (when the data was available)<br />
E:\McNair\Projects\Federal Grant Data\NIH<br />
<br />
==NSF Grant Data==<br />
<br />
The NSF grant data are in folders by year, each grant is an xml file. The format of a typical file is shown below. There is data available from 1959 onwards, and full records after 1976. In 2016 there were ~10,000 awards. <br />
<br />
Each year can be downloaded from: [https://www.nsf.gov/awardsearch/download.jsp https://www.nsf.gov/awardsearch/download.jsp]<br />
<br />
Data is located in:<br />
E:\McNair\Projects\Federal Grant Data\NSF<br />
<br />
Sample XML schema <br />
<br />
<rootTag><br />
<Award><br />
<AwardTitle><br />
Collaborative Research: Hybrid Organic-Inorganic Thermoelectric Materials<br />
</AwardTitle><br />
<AwardEffectiveDate>08/31/2016</AwardEffectiveDate><br />
<AwardExpirationDate>06/30/2017</AwardExpirationDate><br />
<AwardAmount>95461</AwardAmount><br />
<AwardInstrument><br />
<Value>Standard Grant</Value><br />
</AwardInstrument><br />
<Organization><br />
<Code>07030000</Code><br />
<Directorate><br />
<LongName>Directorate For Engineering</LongName><br />
</Directorate><br />
<Division><br />
<LongName>Div Of Civil, Mechanical, & Manufact Inn</LongName><br />
</Division><br />
</Organization><br />
<ProgramOfficer><br />
<SignBlockName>Thomas F. Kuech</SignBlockName><br />
</ProgramOfficer><br />
<AbstractNarration><br />
Thermoelectric materials are materials which can be used to convert thermal energy directly to electricity. The performance of a thermoelectric material is measured by the "figure of merit", termed ZT. There has been much research into increasing thermoelectric materials, figure of merit, however, progress in this area has been slow and most of the researched thermoelectric materials up to now are suffering from either high fabrication cost, usage of rare earth or toxic elements, or poor mechanical properties. Organic thermoelectric materials (OTEs) have recently attracted attention for low temperature applications (< 300K), especially cooling purposes, as they are flexible, low-cost and abundant, and low-cost fabrication methods for synthesizing them exist... A large class of semiconducting nanostructures (e.g. Si, CdTe, Bi, and PbTe nanowires and holely structures) combined with conjugated polymers (e.g., chemically-modified PEDOT and low bandgap polymers) and organic molecules (specifically charged chemical species attached to molecules such as CF3- substituted styrene molecules) will be simulated, synthesized and optimized to identify new hybrid materials with a potentially high ZT.<br />
</AbstractNarration><br />
<MinAmdLetterDate>12/22/2016</MinAmdLetterDate><br />
<MaxAmdLetterDate>12/22/2016</MaxAmdLetterDate><br />
<ARRAAmount/><br />
<AwardID>1723353</AwardID><br />
<Investigator><br />
<FirstName>Mona</FirstName><br />
<LastName>Zebarjadi</LastName><br />
<EmailAddress>mz6g@virginia.edu</EmailAddress><br />
<StartDate>12/22/2016</StartDate><br />
<EndDate/><br />
<RoleCode>Principal Investigator</RoleCode><br />
</Investigator><br />
<Institution><br />
<Name>University of Virginia Main Campus</Name><br />
<CityName>CHARLOTTESVILLE</CityName><br />
<ZipCode>229044195</ZipCode><br />
<PhoneNumber>4349244270</PhoneNumber><br />
<StreetAddress>P.O. BOX 400195</StreetAddress><br />
<CountryName>United States</CountryName><br />
<StateName>Virginia</StateName><br />
<StateCode>VA</StateCode><br />
</Institution><br />
<ProgramElement><br />
<Code>8092</Code><br />
<Text>Materials Eng. & Processing</Text><br />
</ProgramElement><br />
<ProgramReference><br />
<Code>024E</Code><br />
<Text>MATERIALS DESIGN</Text><br />
</ProgramReference><br />
<ProgramReference><br />
<Code>036E</Code><br />
<Text>CIVIL INFRASTRUCTURE</Text><br />
</ProgramReference><br />
</Award><br />
</rootTag><br />
<br />
==Survey of Federal Funds for Research and Development Fiscal Years 2014–16==<br />
<br />
Excel spreadsheets with data regarding Federal Agency budgets and spending on R&D [https://ncsesdata.nsf.gov/fedfunds/2014/]<br />
<br />
E:\McNair\Projects\Federal Grant Data\NSF\NSF Data Tables<br />
<br />
==NIH==<br />
<br />
NIH grants for a given year can be downloaded from [https://report.nih.gov/award/index.cfm https://report.nih.gov/award/index.cfm]<br />
<br />
This does not specify what the grant was for, but it does list the amount and organization who received the grant. Additionally, the city and state of the organization are included. The number of awards received by each organization in a given year is listed as well. Excel Tables can be downloaded for each each year at this site. I downloaded the table for 2016 as a sample.</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=13437Avesh Krishna (Work Log)2017-01-26T22:02:19Z<p>Avesh: /* Spring 2017 */</p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 15:45-17:45 [[Federal Grant Data]], discussed projects with Ed<br />
<br />
1/25/2017 14:45-17:15 Helped Carlin with Perl normalizer, [[Federal Grant Data]]<br />
<br />
1/26/2017 15:45-17:30 [[Federal Grant Data]], hopefully beginning on Project for this semester</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Federal_Grant_Data&diff=13428Federal Grant Data2017-01-25T21:27:42Z<p>Avesh: /* General */</p>
<hr />
<div>==General==<br />
<br />
Finding NIH, NSF, and other federal grant data<br />
<br />
==grants.gov==<br />
<br />
Lists agency, estimated funding, opportunity title. opportunity number, and the date. Can be used to look up who was awarded the grants. I downloaded all grants offered by the NIH since 2005 (when the data was available)<br />
E:\McNair\Projects\Federal Grant Data\NIH<br />
<br />
==NSF Grant Data==<br />
<br />
The NSF grant data are in folders by year, each grant is an xml file. The format of a typical file is shown below. There is data available from 1959 onwards, and full records after 1976. In 2016 there were ~10,000 awards. <br />
<br />
Each year can be downloaded from: [https://www.nsf.gov/awardsearch/download.jsp https://www.nsf.gov/awardsearch/download.jsp]<br />
<br />
Data is located in:<br />
E:\McNair\Projects\Federal Grant Data\NSF<br />
<br />
Sample XML schema <br />
<br />
<rootTag><br />
<Award><br />
<AwardTitle><br />
Collaborative Research: Hybrid Organic-Inorganic Thermoelectric Materials<br />
</AwardTitle><br />
<AwardEffectiveDate>08/31/2016</AwardEffectiveDate><br />
<AwardExpirationDate>06/30/2017</AwardExpirationDate><br />
<AwardAmount>95461</AwardAmount><br />
<AwardInstrument><br />
<Value>Standard Grant</Value><br />
</AwardInstrument><br />
<Organization><br />
<Code>07030000</Code><br />
<Directorate><br />
<LongName>Directorate For Engineering</LongName><br />
</Directorate><br />
<Division><br />
<LongName>Div Of Civil, Mechanical, & Manufact Inn</LongName><br />
</Division><br />
</Organization><br />
<ProgramOfficer><br />
<SignBlockName>Thomas F. Kuech</SignBlockName><br />
</ProgramOfficer><br />
<AbstractNarration><br />
Thermoelectric materials are materials which can be used to convert thermal energy directly to electricity. The performance of a thermoelectric material is measured by the "figure of merit", termed ZT. There has been much research into increasing thermoelectric materials, figure of merit, however, progress in this area has been slow and most of the researched thermoelectric materials up to now are suffering from either high fabrication cost, usage of rare earth or toxic elements, or poor mechanical properties. Organic thermoelectric materials (OTEs) have recently attracted attention for low temperature applications (< 300K), especially cooling purposes, as they are flexible, low-cost and abundant, and low-cost fabrication methods for synthesizing them exist... A large class of semiconducting nanostructures (e.g. Si, CdTe, Bi, and PbTe nanowires and holely structures) combined with conjugated polymers (e.g., chemically-modified PEDOT and low bandgap polymers) and organic molecules (specifically charged chemical species attached to molecules such as CF3- substituted styrene molecules) will be simulated, synthesized and optimized to identify new hybrid materials with a potentially high ZT.<br />
</AbstractNarration><br />
<MinAmdLetterDate>12/22/2016</MinAmdLetterDate><br />
<MaxAmdLetterDate>12/22/2016</MaxAmdLetterDate><br />
<ARRAAmount/><br />
<AwardID>1723353</AwardID><br />
<Investigator><br />
<FirstName>Mona</FirstName><br />
<LastName>Zebarjadi</LastName><br />
<EmailAddress>mz6g@virginia.edu</EmailAddress><br />
<StartDate>12/22/2016</StartDate><br />
<EndDate/><br />
<RoleCode>Principal Investigator</RoleCode><br />
</Investigator><br />
<Institution><br />
<Name>University of Virginia Main Campus</Name><br />
<CityName>CHARLOTTESVILLE</CityName><br />
<ZipCode>229044195</ZipCode><br />
<PhoneNumber>4349244270</PhoneNumber><br />
<StreetAddress>P.O. BOX 400195</StreetAddress><br />
<CountryName>United States</CountryName><br />
<StateName>Virginia</StateName><br />
<StateCode>VA</StateCode><br />
</Institution><br />
<ProgramElement><br />
<Code>8092</Code><br />
<Text>Materials Eng. & Processing</Text><br />
</ProgramElement><br />
<ProgramReference><br />
<Code>024E</Code><br />
<Text>MATERIALS DESIGN</Text><br />
</ProgramReference><br />
<ProgramReference><br />
<Code>036E</Code><br />
<Text>CIVIL INFRASTRUCTURE</Text><br />
</ProgramReference><br />
</Award><br />
</rootTag></div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=13412Avesh Krishna (Work Log)2017-01-24T22:30:50Z<p>Avesh: </p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
==Fall 2016==<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
==Spring 2017==<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 [[Federal Grant Data]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Avesh_Krishna_(Work_Log)&diff=13411Avesh Krishna (Work Log)2017-01-24T22:30:08Z<p>Avesh: </p>
<hr />
<div><br />
[[Category:Work Log]]<br />
[[Category:Internal]]<br />
<br />
[[Avesh Krishna]] [[Work Logs]] [[Avesh Krishna (Work Log)|(Log Page)]]<br />
<br />
09/08/2016 1430-1600 - Catch up to McNair Center work on patents and innovation. Set up personal wikipages and work log<br />
<br />
09/09/2016 1400-1600 - Research current areas in patent policy, planning blog post<br />
<br />
09/12/2016 1400-1600 - Researching for blog post<br />
<br />
09/13/2016 1445-1600 - Drafting blog post on patent regulations/innovation<br />
<br />
09/14/2016 1400-1700 - Researching legislation and court cases for blog post<br />
<br />
09/15/2016 1430-1600 - Finished first draft of blog post<br />
<br />
09/19/2016 0900- 1100 - Create wiki page for [[Regulatory Challenges for Innovation Policy (Blog Post)]]<br />
<br />
09/20/2016 1445-1600 - Exploring universities, patent trolls, and generating revenue from research/innovation. Possible blog post or research idea<br />
<br />
09/21/2016 1400-1730 - Collecting data, figures and general research for Market of Ideas issue brief<br />
<br />
09/22/2016 0930-1050, - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1430-1600 - Finding references for patent valuations and patent statistics<br />
<br />
09/22/2016 1700-1800 - Met with Ed to go over Market of Ideas issue brief data<br />
<br />
09/23/2016 1000- 1240 - producing notes on AIA and creating figures using patent data, working with Ed on issue brief framing<br />
<br />
09/26/2016 1000-1100, 1700-1800 - Organizing notes on Market of Ideas Research<br />
<br />
09/27/2016 1430-1600 - Creating wikipage with notes for Market of Ideas issue brief [[Market of Ideas Research Notes]]<br />
<br />
09/28/2016 1400-1800 - Continued finding data for expanded Market of Ideas paper [[Market of Ideas Research Notes]]<br />
<br />
09/29/2016 1430-1600 - Market of Ideas research<br />
<br />
09/30/2016 1500-1630 - exploring areas for market of ideas research<br />
<br />
10/03/2016 1600-1730 - SBDE excel sheet creation<br />
<br />
10/04/2016 1430-1600 - SBDE resource creation and discussed future of patent work with Ed<br />
<br />
10/05/2016 1400-1730 - creating tables and brainstorming how to create SBDE deliverable<br />
<br />
10/06/2016 1430-1615 - adding conditional semantic tables to each SBDE resource page<br />
<br />
10/10/2016 1530 - 1700 - researching for patent paper<br />
<br />
10/11/2016 1530-1730 - Adding content on bills to [[Market of Ideas Research Notes]], finding information on federal research funding<br />
<br />
10/12/2016 1400-1730 - Creating outline and finding data for Market of Ideas issue brief. Added draft outline to [[Market of Ideas Research Notes]]<br />
<br />
10/13/2016 0920-1050 - Working on outline and agency funding for [[Market of Ideas Research Notes]]<br />
<br />
10/17/2016 0910-1050, 1600-1630 - Collecting names of patent players for [[Market of Ideas Research Notes]], business portal work<br />
<br />
10/18/2016 1430-1600, 1715-1930 - Patent Quality information for [[Market of Ideas Research Notes]], McNair dinner<br />
<br />
10/19/2016 1400- 1800- Working on Small Biz Dev Ecosystem (small tasks)<br />
<br />
10/20/2016 1430-1600 - Discussed ideas for patent project, brainstorming ways to work with patent data<br />
<br />
10/21/2016 1400-1545 - Looking into resources available for a report on patent quality, bloggers meeting<br />
<br />
10/24/2016 1600-1800 - Weekly Roundup planning meeting<br />
<br />
10/25/2016 1500-1600 - Editing blog post, patent quality ideas<br />
<br />
10/26/2016 1400-1730 - Blog post edits, working on creating deliverable on patent quality<br />
<br />
10/27/2016 1430-1600 - SQL training<br />
<br />
10/28/2016 1400-1600 - Weekly Roundup innovation<br />
<br />
10/31/2015 1530-1730 - Patent blog post<br />
<br />
11/1/2016 1430-1600 - Oil and gas innovation <br />
<br />
11/2/2016 1400-1630 - background research for oil and gas innovation, edits to blog post<br />
<br />
11/3/2016 1430-1630 - SQL training w/ Ed<br />
<br />
11/4/2016 1400-1700 - Weekly Roundup <br />
<br />
11/7/2016 1440-1640 - Researching ways to measure innovation [[Measuring Innovation]]<br />
<br />
11/8/2016 1430-1600 - Roundup post drafting<br />
<br />
11/9/2016 1400-1700 - Roundup post writing<br />
<br />
11/10/2016 1500-1645 - Editing roundup post, brainstorming project ideas<br />
<br />
11/14/2016 1530- 1730 - Project ideas, blog post ideas<br />
<br />
11/15/2016 1430-1600, 1715-1800 - Creating SQL database for VC Policy Report<br />
<br />
11/16/2016 1400-1730 [[VC Policy Report]] reducing<br />
<br />
11/17/2016 1430-1615 [[VC Policy Report]] matching and weekly roundup<br />
<br />
11/18/2016 1430-1745 [[VC Policy Report]] matching to VC and weekly roundup draft in to Anne<br />
<br />
11/28/2016 1445-1700 Finding roundup articles, training from Ed on Accelerator project<br />
<br />
11/29/2016 1430-1630 Accelerator data collection<br />
<br />
11/30/2016 1400-1730 Accelerator data collection, explaining RegEx to Eliza and Ramee<br />
<br />
12/1/2016 1500-1700 Weekly Roundup draft writing<br />
<br />
12/2/2016 1430-17630 Weekly Roundup, Accelerators, Christmas Photo + Dog<br />
<br />
#Spring 2017<br />
<br />
1/11/2017 1500-1700 [[FDA Trials Data]]<br />
<br />
1/12/2017 1545-1730 [[FDA Trials Data]]<br />
<br />
1/18/2017 1500-1730 [[Federal Grant Data]]<br />
<br />
1/20/2017 1400-1530 Staff Meeting<br />
<br />
1/24/2017 [[Federal Grant Data]]</div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=FDA_Trials_Data&diff=13406FDA Trials Data2017-01-24T22:21:10Z<p>Avesh: /* Clinical Trials */</p>
<hr />
<div>==General==<br />
<br />
Attempting to find raw large-scale data on all FDA trials<br />
<br />
Part of [[Federal Grant Data]]<br />
<br />
==Clinical Trials==<br />
<br />
[https://clinicaltrials.gov clinicaltrials.gov] is a registry and results database for publicly and privately supported clinical studies globally.<br />
<br />
Not limited to just completed trials with results and records can be downloaded in XML format. <br />
<br />
Downloaded all US trials (and results in trials where available) as XML<br />
<br />
Downloaded list of all trial records as CSV<br />
<br />
In <br />
E:\McNair\Projects\FDA Trials<br />
<br />
Can Narrow based on completion status using advanced search<br />
<br />
''study_fields'' file is a header file for the xml documents. Contains the fields listed below.<br />
<br />
xml files in study records folder, example of such file contained below. Where applicable, the XML file also includes the results of the study.<br />
<br />
Clinical trial data downloaded has every US trial that began after 1997 (mandatory record keeping as a result of the Food and Drug Administration Modernization Act of 1997 (FDAMA)), but there are trials from as early as 1985 in the dataset<br />
<br />
==List of Records==<br />
<br />
'''Contains:'''<br />
*Rank <br />
*NCT Number<br />
*Title <br />
*Recruitment <br />
*Study Results <br />
*Conditions <br />
*Interventions <br />
*Sponsor/Collaborators <br />
*Gender <br />
*Age <br />
*Phases<br />
**indicates phase in FDA approval process, detailed in reference [http://www.fda.gov/ForPatients/Approvals/Drugs/ucm405622.htm#Clinical_Research_Phase_Studies]<br />
**Phase 1-3 are pre-FDA approval, phase 0 is before FDA is involved and Phase 4 is post approval <br />
*Enrollment <br />
*Funded Bys <br />
*Study Types <br />
*Study Designs <br />
*Other IDs <br />
*First Received <br />
*Start Date <br />
*Completion Date <br />
*Last Updated <br />
*Last Verified <br />
*Results First Received <br />
*Acronym <br />
*Primary Completion Date <br />
*Outcome Measures <br />
*URL<br />
<br />
==Example XML==<br />
<br />
<clinical_study rank="91460"><br />
<!--<br />
This xml conforms to an XML Schema at:<br />
https://clinicaltrials.gov/ct2/html/images/info/public.xsd <br />
--><br />
<required_header><br />
<download_date><br />
ClinicalTrials.gov processed this data on January 11, 2017<br />
</download_date><br />
<link_text>Link to the current ClinicalTrials.gov record.</link_text><br />
<url>https://clinicaltrials.gov/show/NCT00002322</url><br />
</required_header><br />
<id_info><br />
<org_study_id>210A</org_study_id><br />
<secondary_id>M/3330/0018</secondary_id><br />
<nct_id>NCT00002322</nct_id><br />
</id_info><br />
<brief_title><br />
A Study of Different Doses of Atevirdine Mesylate Plus Zidovudine in HIV-Positive Patients<br />
</brief_title><br />
<official_title><br />
Randomized, Double-Blind, Placebo-Controlled Comparative Dose-Response Study of Two Doses of Atevirdine Mesylate (U-87201E) in Combination With Fixed Doses of Zidovudine (AZT) in HIV+ Patients<br />
</official_title><br />
<sponsors><br />
<lead_sponsor><br />
<agency>Pharmacia and Upjohn</agency><br />
<agency_class>Industry</agency_class><br />
</lead_sponsor><br />
</sponsors><br />
<source>NIH AIDS Clinical Trials Information Service</source><br />
<oversight_info><br />
<authority>United States: Food and Drug Administration</authority><br />
</oversight_info><br />
<brief_summary><br />
<textblock><br />
To determine the tolerance and antiviral response of two different doses of atevirdine mesylate (U-87201E) in symptomatic HIV-positive patients with CD4 counts of 50-350 cells/mm3, who also take zidovudine (AZT).<br />
</textblock><br />
</brief_summary><br />
<detailed_description><br />
<textblock><br />
Patients are randomized to 1 of 3 treatment groups: U-87201E at 1 of 2 doses or placebo administered every 8 hours. Patients must have taken AZT for at least 3 months prior to randomization.<br />
</textblock><br />
</detailed_description><br />
<overall_status>Completed</overall_status><br />
<phase>Phase 2</phase><br />
<study_type>Interventional</study_type><br />
<study_design><br />
Endpoint Classification: Pharmacokinetics Study, Masking: Double-Blind, Primary Purpose: Treatment<br />
</study_design><br />
<condition>HIV Infections</condition><br />
<intervention><br />
<intervention_type>Drug</intervention_type><br />
<intervention_name>Atevirdine mesylate</intervention_name><br />
</intervention><br />
<intervention>...</intervention><br />
<eligibility><br />
<criteria><br />
<textblock><br />
Inclusion Criteria Concurrent Medication: Allowed: - Primary or secondary prophylaxis for opportunistic infections. Patients must have: - HIV infection. - Symptoms (currently or prior to enrollment) included in Category B or C of CDC classification, although THE FOLLOWING CURRENT ACUTE MEDICAL CONDITIONS ARE NOT ALLOWED: - Cryptococcosis - Pneumocystis carinii pneumonia - Herpes zoster - Histoplasmosis - CMV - Hepatic or renal disease - Lymphoma. - CD4 count 50 - 350 cells/mm3 within 14 days prior to study entry. - Ongoing therapy with AZT at 500 - 600 mg total daily dose for at least 3 months prior to study entry. - Consent of parent, guardian, or person with power of attorney if less than 18 years of age. Exclusion Criteria Co-existing Condition: Patients with the following conditions are excluded: - Intolerance to AZT. - Current diagnosis of malignancy for which systemic therapy will be required during the study. Concurrent Medication: Excluded: - Any other investigational drugs. Prior Medication: Excluded: - Cytotoxic chemotherapy within 1 month prior to study entry. - Prior U-87201E or any other non-nucleoside antiretroviral medications, including but not limited to nevirapine, TIBO R-82150 or TIBO R-82913, L-697639 or L-696229, U-90152S, or any protease inhibitors. - Antiretroviral agents other than AZT within 3 months prior to study entry. Required: - AZT for at least 3 months prior to study entry. Present use of excessive alcohol or illicit drugs.<br />
</textblock><br />
</criteria><br />
<gender>Both</gender><br />
<minimum_age>13 Years</minimum_age><br />
<maximum_age>N/A</maximum_age><br />
<healthy_volunteers>No</healthy_volunteers><br />
</eligibility><br />
<location><br />
<facility><br />
<name><br />
Los Angeles County / Health Research Assoc / Drew Med Ctr<br />
</name><br />
<address><br />
<city>Los Angeles</city><br />
<state>California</state><br />
<zip>90033</zip><br />
<country>United States</country><br />
</address><br />
</facility><br />
</location><br />
<location>...</location><br />
...<br />
<location_countries>...</location_countries><br />
<verification_date>November 1996</verification_date><br />
<lastchanged_date>June 23, 2005</lastchanged_date><br />
<firstreceived_date>November 2, 1999</firstreceived_date><br />
<keyword>Drug Therapy, Combination</keyword><br />
<keyword>Acquired Immunodeficiency Syndrome</keyword><br />
<keyword>AIDS-Related Complex</keyword><br />
<keyword>Antiviral Agents</keyword><br />
<has_expanded_access>No</has_expanded_access><br />
<condition_browse><br />
<!--<br />
CAUTION: The following MeSH terms are assigned with an imperfect algorithm <br />
--><br />
<mesh_term>HIV Infections</mesh_term><br />
</condition_browse><br />
<intervention_browse><br />
<!--<br />
CAUTION: The following MeSH terms are assigned with an imperfect algorithm <br />
--><br />
<mesh_term>Zidovudine</mesh_term><br />
<mesh_term>Atevirdine</mesh_term><br />
</intervention_browse><br />
<!-- Results have not yet been posted for this study --><br />
</clinical_study></div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Federal_Grant_Data&diff=13405Federal Grant Data2017-01-24T22:20:01Z<p>Avesh: /* NSF Grant Data */</p>
<hr />
<div>==General==<br />
<br />
Finding NIH, NSF, and other federal grant data<br />
<br />
==NSF Grant Data==<br />
<br />
The NSF grant data are in folders by year, each grant is an xml file. The format of a typical file is shown below. There is data available from 1959 onwards, and full records after 1976. In 2016 there were ~10,000 awards. <br />
<br />
Each year can be downloaded from: [https://www.nsf.gov/awardsearch/download.jsp https://www.nsf.gov/awardsearch/download.jsp]<br />
<br />
Data is located in:<br />
E:\McNair\Projects\Federal Grant Data\NSF<br />
<br />
Sample XML schema <br />
<br />
<rootTag><br />
<Award><br />
<AwardTitle><br />
Collaborative Research: Hybrid Organic-Inorganic Thermoelectric Materials<br />
</AwardTitle><br />
<AwardEffectiveDate>08/31/2016</AwardEffectiveDate><br />
<AwardExpirationDate>06/30/2017</AwardExpirationDate><br />
<AwardAmount>95461</AwardAmount><br />
<AwardInstrument><br />
<Value>Standard Grant</Value><br />
</AwardInstrument><br />
<Organization><br />
<Code>07030000</Code><br />
<Directorate><br />
<LongName>Directorate For Engineering</LongName><br />
</Directorate><br />
<Division><br />
<LongName>Div Of Civil, Mechanical, & Manufact Inn</LongName><br />
</Division><br />
</Organization><br />
<ProgramOfficer><br />
<SignBlockName>Thomas F. Kuech</SignBlockName><br />
</ProgramOfficer><br />
<AbstractNarration><br />
Thermoelectric materials are materials which can be used to convert thermal energy directly to electricity. The performance of a thermoelectric material is measured by the "figure of merit", termed ZT. There has been much research into increasing thermoelectric materials, figure of merit, however, progress in this area has been slow and most of the researched thermoelectric materials up to now are suffering from either high fabrication cost, usage of rare earth or toxic elements, or poor mechanical properties. Organic thermoelectric materials (OTEs) have recently attracted attention for low temperature applications (< 300K), especially cooling purposes, as they are flexible, low-cost and abundant, and low-cost fabrication methods for synthesizing them exist... A large class of semiconducting nanostructures (e.g. Si, CdTe, Bi, and PbTe nanowires and holely structures) combined with conjugated polymers (e.g., chemically-modified PEDOT and low bandgap polymers) and organic molecules (specifically charged chemical species attached to molecules such as CF3- substituted styrene molecules) will be simulated, synthesized and optimized to identify new hybrid materials with a potentially high ZT.<br />
</AbstractNarration><br />
<MinAmdLetterDate>12/22/2016</MinAmdLetterDate><br />
<MaxAmdLetterDate>12/22/2016</MaxAmdLetterDate><br />
<ARRAAmount/><br />
<AwardID>1723353</AwardID><br />
<Investigator><br />
<FirstName>Mona</FirstName><br />
<LastName>Zebarjadi</LastName><br />
<EmailAddress>mz6g@virginia.edu</EmailAddress><br />
<StartDate>12/22/2016</StartDate><br />
<EndDate/><br />
<RoleCode>Principal Investigator</RoleCode><br />
</Investigator><br />
<Institution><br />
<Name>University of Virginia Main Campus</Name><br />
<CityName>CHARLOTTESVILLE</CityName><br />
<ZipCode>229044195</ZipCode><br />
<PhoneNumber>4349244270</PhoneNumber><br />
<StreetAddress>P.O. BOX 400195</StreetAddress><br />
<CountryName>United States</CountryName><br />
<StateName>Virginia</StateName><br />
<StateCode>VA</StateCode><br />
</Institution><br />
<ProgramElement><br />
<Code>8092</Code><br />
<Text>Materials Eng. & Processing</Text><br />
</ProgramElement><br />
<ProgramReference><br />
<Code>024E</Code><br />
<Text>MATERIALS DESIGN</Text><br />
</ProgramReference><br />
<ProgramReference><br />
<Code>036E</Code><br />
<Text>CIVIL INFRASTRUCTURE</Text><br />
</ProgramReference><br />
</Award><br />
</rootTag></div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Federal_Grant_Data&diff=13404Federal Grant Data2017-01-24T22:15:31Z<p>Avesh: /* NSF Grant Data */</p>
<hr />
<div>==General==<br />
<br />
Finding NIH, NSF, and other federal grant data<br />
<br />
==NSF Grant Data==<br />
<br />
The NSF grant data are in folders by year, each grant is an xml file. The format of a typical file is shown below. <br />
<br />
Each year can be downloaded from: [https://www.nsf.gov/awardsearch/download.jsp https://www.nsf.gov/awardsearch/download.jsp]<br />
<br />
Data is located in:<br />
E:\McNair\Projects\Federal Grant Data\NSF<br />
<br />
Sample XML schema <br />
<br />
<rootTag><br />
<Award><br />
<AwardTitle><br />
Collaborative Research: Hybrid Organic-Inorganic Thermoelectric Materials<br />
</AwardTitle><br />
<AwardEffectiveDate>08/31/2016</AwardEffectiveDate><br />
<AwardExpirationDate>06/30/2017</AwardExpirationDate><br />
<AwardAmount>95461</AwardAmount><br />
<AwardInstrument><br />
<Value>Standard Grant</Value><br />
</AwardInstrument><br />
<Organization><br />
<Code>07030000</Code><br />
<Directorate><br />
<LongName>Directorate For Engineering</LongName><br />
</Directorate><br />
<Division><br />
<LongName>Div Of Civil, Mechanical, & Manufact Inn</LongName><br />
</Division><br />
</Organization><br />
<ProgramOfficer><br />
<SignBlockName>Thomas F. Kuech</SignBlockName><br />
</ProgramOfficer><br />
<AbstractNarration><br />
Thermoelectric materials are materials which can be used to convert thermal energy directly to electricity. The performance of a thermoelectric material is measured by the "figure of merit", termed ZT. There has been much research into increasing thermoelectric materials, figure of merit, however, progress in this area has been slow and most of the researched thermoelectric materials up to now are suffering from either high fabrication cost, usage of rare earth or toxic elements, or poor mechanical properties. Organic thermoelectric materials (OTEs) have recently attracted attention for low temperature applications (< 300K), especially cooling purposes, as they are flexible, low-cost and abundant, and low-cost fabrication methods for synthesizing them exist... A large class of semiconducting nanostructures (e.g. Si, CdTe, Bi, and PbTe nanowires and holely structures) combined with conjugated polymers (e.g., chemically-modified PEDOT and low bandgap polymers) and organic molecules (specifically charged chemical species attached to molecules such as CF3- substituted styrene molecules) will be simulated, synthesized and optimized to identify new hybrid materials with a potentially high ZT.<br />
</AbstractNarration><br />
<MinAmdLetterDate>12/22/2016</MinAmdLetterDate><br />
<MaxAmdLetterDate>12/22/2016</MaxAmdLetterDate><br />
<ARRAAmount/><br />
<AwardID>1723353</AwardID><br />
<Investigator><br />
<FirstName>Mona</FirstName><br />
<LastName>Zebarjadi</LastName><br />
<EmailAddress>mz6g@virginia.edu</EmailAddress><br />
<StartDate>12/22/2016</StartDate><br />
<EndDate/><br />
<RoleCode>Principal Investigator</RoleCode><br />
</Investigator><br />
<Institution><br />
<Name>University of Virginia Main Campus</Name><br />
<CityName>CHARLOTTESVILLE</CityName><br />
<ZipCode>229044195</ZipCode><br />
<PhoneNumber>4349244270</PhoneNumber><br />
<StreetAddress>P.O. BOX 400195</StreetAddress><br />
<CountryName>United States</CountryName><br />
<StateName>Virginia</StateName><br />
<StateCode>VA</StateCode><br />
</Institution><br />
<ProgramElement><br />
<Code>8092</Code><br />
<Text>Materials Eng. & Processing</Text><br />
</ProgramElement><br />
<ProgramReference><br />
<Code>024E</Code><br />
<Text>MATERIALS DESIGN</Text><br />
</ProgramReference><br />
<ProgramReference><br />
<Code>036E</Code><br />
<Text>CIVIL INFRASTRUCTURE</Text><br />
</ProgramReference><br />
</Award><br />
</rootTag></div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Federal_Grant_Data&diff=13403Federal Grant Data2017-01-24T22:15:06Z<p>Avesh: /* NSF Grant Data */</p>
<hr />
<div>==General==<br />
<br />
Finding NIH, NSF, and other federal grant data<br />
<br />
==NSF Grant Data==<br />
<br />
The NSF grant data are in folders by year, each grant is an xml file. The format of a typical file is shown below. <br />
<br />
Each year can be downloaded from: [https://www.nsf.gov/awardsearch/download.jsp https://www.nsf.gov/awardsearch/download.jsp]<br />
<br />
Data is located in:<br />
E:\McNair\Projects\Federal Grant Data\NSF<br />
<br />
<br />
<rootTag><br />
<Award><br />
<AwardTitle><br />
Collaborative Research: Hybrid Organic-Inorganic Thermoelectric Materials<br />
</AwardTitle><br />
<AwardEffectiveDate>08/31/2016</AwardEffectiveDate><br />
<AwardExpirationDate>06/30/2017</AwardExpirationDate><br />
<AwardAmount>95461</AwardAmount><br />
<AwardInstrument><br />
<Value>Standard Grant</Value><br />
</AwardInstrument><br />
<Organization><br />
<Code>07030000</Code><br />
<Directorate><br />
<LongName>Directorate For Engineering</LongName><br />
</Directorate><br />
<Division><br />
<LongName>Div Of Civil, Mechanical, & Manufact Inn</LongName><br />
</Division><br />
</Organization><br />
<ProgramOfficer><br />
<SignBlockName>Thomas F. Kuech</SignBlockName><br />
</ProgramOfficer><br />
<AbstractNarration><br />
Thermoelectric materials are materials which can be used to convert thermal energy directly to electricity. The performance of a thermoelectric material is measured by the "figure of merit", termed ZT. There has been much research into increasing thermoelectric materials, figure of merit, however, progress in this area has been slow and most of the researched thermoelectric materials up to now are suffering from either high fabrication cost, usage of rare earth or toxic elements, or poor mechanical properties. Organic thermoelectric materials (OTEs) have recently attracted attention for low temperature applications (< 300K), especially cooling purposes, as they are flexible, low-cost and abundant, and low-cost fabrication methods for synthesizing them exist... A large class of semiconducting nanostructures (e.g. Si, CdTe, Bi, and PbTe nanowires and holely structures) combined with conjugated polymers (e.g., chemically-modified PEDOT and low bandgap polymers) and organic molecules (specifically charged chemical species attached to molecules such as CF3- substituted styrene molecules) will be simulated, synthesized and optimized to identify new hybrid materials with a potentially high ZT.<br />
</AbstractNarration><br />
<MinAmdLetterDate>12/22/2016</MinAmdLetterDate><br />
<MaxAmdLetterDate>12/22/2016</MaxAmdLetterDate><br />
<ARRAAmount/><br />
<AwardID>1723353</AwardID><br />
<Investigator><br />
<FirstName>Mona</FirstName><br />
<LastName>Zebarjadi</LastName><br />
<EmailAddress>mz6g@virginia.edu</EmailAddress><br />
<StartDate>12/22/2016</StartDate><br />
<EndDate/><br />
<RoleCode>Principal Investigator</RoleCode><br />
</Investigator><br />
<Institution><br />
<Name>University of Virginia Main Campus</Name><br />
<CityName>CHARLOTTESVILLE</CityName><br />
<ZipCode>229044195</ZipCode><br />
<PhoneNumber>4349244270</PhoneNumber><br />
<StreetAddress>P.O. BOX 400195</StreetAddress><br />
<CountryName>United States</CountryName><br />
<StateName>Virginia</StateName><br />
<StateCode>VA</StateCode><br />
</Institution><br />
<ProgramElement><br />
<Code>8092</Code><br />
<Text>Materials Eng. & Processing</Text><br />
</ProgramElement><br />
<ProgramReference><br />
<Code>024E</Code><br />
<Text>MATERIALS DESIGN</Text><br />
</ProgramReference><br />
<ProgramReference><br />
<Code>036E</Code><br />
<Text>CIVIL INFRASTRUCTURE</Text><br />
</ProgramReference><br />
</Award><br />
</rootTag></div>Aveshhttp://www.edegan.com/mediawiki/index.php?title=Federal_Grant_Data&diff=13314Federal Grant Data2017-01-19T23:06:35Z<p>Avesh: </p>
<hr />
<div>==General==<br />
<br />
Finding NIH, NSF, and other federal grant data<br />
<br />
==NSF Grant Data==<br />
<br />
The NSF grant data are in folders by year, each grant is an xml file. The format of a typical file is shown below. <br />
<br />
Each year can be downloaded from: [https://www.nsf.gov/awardsearch/download.jsp https://www.nsf.gov/awardsearch/download.jsp]<br />
<br />
<rootTag><br />
<Award><br />
<AwardTitle><br />
Collaborative Research: Hybrid Organic-Inorganic Thermoelectric Materials<br />
</AwardTitle><br />
<AwardEffectiveDate>08/31/2016</AwardEffectiveDate><br />
<AwardExpirationDate>06/30/2017</AwardExpirationDate><br />
<AwardAmount>95461</AwardAmount><br />
<AwardInstrument><br />
<Value>Standard Grant</Value><br />
</AwardInstrument><br />
<Organization><br />
<Code>07030000</Code><br />
<Directorate><br />
<LongName>Directorate For Engineering</LongName><br />
</Directorate><br />
<Division><br />
<LongName>Div Of Civil, Mechanical, & Manufact Inn</LongName><br />
</Division><br />
</Organization><br />
<ProgramOfficer><br />
<SignBlockName>Thomas F. Kuech</SignBlockName><br />
</ProgramOfficer><br />
<AbstractNarration><br />
Thermoelectric materials are materials which can be used to convert thermal energy directly to electricity. The performance of a thermoelectric material is measured by the "figure of merit", termed ZT. There has been much research into increasing thermoelectric materials, figure of merit, however, progress in this area has been slow and most of the researched thermoelectric materials up to now are suffering from either high fabrication cost, usage of rare earth or toxic elements, or poor mechanical properties. Organic thermoelectric materials (OTEs) have recently attracted attention for low temperature applications (< 300K), especially cooling purposes, as they are flexible, low-cost and abundant, and low-cost fabrication methods for synthesizing them exist... A large class of semiconducting nanostructures (e.g. Si, CdTe, Bi, and PbTe nanowires and holely structures) combined with conjugated polymers (e.g., chemically-modified PEDOT and low bandgap polymers) and organic molecules (specifically charged chemical species attached to molecules such as CF3- substituted styrene molecules) will be simulated, synthesized and optimized to identify new hybrid materials with a potentially high ZT.<br />
</AbstractNarration><br />
<MinAmdLetterDate>12/22/2016</MinAmdLetterDate><br />
<MaxAmdLetterDate>12/22/2016</MaxAmdLetterDate><br />
<ARRAAmount/><br />
<AwardID>1723353</AwardID><br />
<Investigator><br />
<FirstName>Mona</FirstName><br />
<LastName>Zebarjadi</LastName><br />
<EmailAddress>mz6g@virginia.edu</EmailAddress><br />
<StartDate>12/22/2016</StartDate><br />
<EndDate/><br />
<RoleCode>Principal Investigator</RoleCode><br />
</Investigator><br />
<Institution><br />
<Name>University of Virginia Main Campus</Name><br />
<CityName>CHARLOTTESVILLE</CityName><br />
<ZipCode>229044195</ZipCode><br />
<PhoneNumber>4349244270</PhoneNumber><br />
<StreetAddress>P.O. BOX 400195</StreetAddress><br />
<CountryName>United States</CountryName><br />
<StateName>Virginia</StateName><br />
<StateCode>VA</StateCode><br />
</Institution><br />
<ProgramElement><br />
<Code>8092</Code><br />
<Text>Materials Eng. & Processing</Text><br />
</ProgramElement><br />
<ProgramReference><br />
<Code>024E</Code><br />
<Text>MATERIALS DESIGN</Text><br />
</ProgramReference><br />
<ProgramReference><br />
<Code>036E</Code><br />
<Text>CIVIL INFRASTRUCTURE</Text><br />
</ProgramReference><br />
</Award><br />
</rootTag></div>Avesh