Marcela Interiano (Work Log)
Summer 2016
06/01/2016 - Set Up Work Log Page
06/02/2016 - Refined Wiki Organization and Content
06/03/2016 - Organized Topic Areas and Worked on Public Wiki Page
06/06/2016 - Continued Organizing Public Wiki Page
06/07/2016 - Public Wiki Page on TPP (Trans-Pacific Partnership (Wiki Page))
06/08/2016 - Working on Innovation Policy Wiki Page research and writing
06/09/2016 - Innovation Policy and reworking links
06/10/2016 - Patent Reform linked pages (Innovation Policy)
06/13/2016 - Innovation Act
06/14/2016 - Innovation Policy Page
06/15/2016 - Patent System Background/Data (Patent Data Wiki Page) and restructuring Innovation Policy page (finally done!)
06/16/2016 - Lex Machina and Patent Data Wiki Page background
06/17/2016 - Understanding and define LexMachina variables
06/20/2016 - LexMachina variables and understanding patent trial litigation/dockets
06/21/2016 - Lit review for Little Guy Academic Paper and Guide to Patent Litigation wiki page.
06/23/2016 - SQL patent data and defining small and micro entities.
06/24/2016 - Wiki page for small and micro entities (Small Entity vs. Micro Entity), SQL patent data.
06/27/2016 - Made tables in SQL patent data (ex: US only assignees) , looked at potential tables that need to made for the paper.
06/28/2016 - Worked on including firms no country and counting patent assignees and finishing Lex Machina Variables.
06/29/2016 - Finished LexMachina Spreadsheet and refined SQL tables. Added another problem on the Wiki Page for the database.
07/05/2016 - Exported Judges/Courts into Excel spreadsheet, finalized LexMachina data pull.
07/06/2016 - Began designing the Patent Data Wiki Page and working with assignee data.
07/07/2016 - Worked on finding errors in citation table in patent. Found errors with cited patent entries and worked on solving the problems (blanks, long codes).
07/08/2016 - America Invents Act, Wiki page work and organizing lex machina proposal.
07/11/2016 - Wrote data proposal, worked on wiki page and SQL data.
07/12/2016 - found patstats, wiki page cleanup.
07/13/2016 - documented patstats, linked and created pages on wiki.
Spring 2017
03/24/2017 - created ptoassignee_current table by creating a series of 5 other tables.
03/28/2017 - created ptoassignee_currentusa table, cleaned documentids. began working on patentmsa table by looking at string-to-array functions. was unable to make code work but have a direction moving forward. checked that ptoassignee_current had taken most recent recorded_date for the patents.
