Difference between revisions of "Marcela Interiano (Work Log)"
(7 intermediate revisions by 3 users not shown) | |||
Line 1: | Line 1: | ||
− | + | <onlyinclude>[[Marcela Interiano]] [[Work Logs]] [[Marcela Interiano (Work Log)|(log page)]]</onlyinclude> | |
− | [[Marcela Interiano]] [[Work Logs]] [[Marcela Interiano (Work Log)|(log page)]] | + | |
+ | ===Summer 2016=== | ||
06/01/2016 - Set Up Work Log Page | 06/01/2016 - Set Up Work Log Page | ||
Line 24: | Line 25: | ||
06/15/2016 - Patent System Background/Data ([[Patent Data Wiki Page]]) and restructuring [[Innovation Policy]] page (finally done!) | 06/15/2016 - Patent System Background/Data ([[Patent Data Wiki Page]]) and restructuring [[Innovation Policy]] page (finally done!) | ||
− | 06/16/2016 - | + | 06/16/2016 - [[Lex Machina]] and [[Patent Data Wiki Page]] background |
06/17/2016 - Understanding and define LexMachina variables | 06/17/2016 - Understanding and define LexMachina variables | ||
Line 30: | Line 31: | ||
06/20/2016 - LexMachina variables and understanding patent trial litigation/dockets | 06/20/2016 - LexMachina variables and understanding patent trial litigation/dockets | ||
− | 06/21/2016 - Lit review for Little Guy and [[Guide to Patent Litigation]] wiki page. | + | 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/23/2016 - SQL patent data and defining small and micro entities. | ||
Line 55: | Line 56: | ||
07/13/2016 - documented patstats, linked and created pages on wiki. | 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. | ||
+ | |||
+ | [[Category:Work Log]] |
Latest revision as of 12:10, 2 November 2017
Marcela Interiano Work Logs (log page)
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.