Difference between revisions of "Marcela Interiano (Work Log)"
(16 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 10: | Line 11: | ||
06/06/2016 - Continued Organizing Public Wiki Page | 06/06/2016 - Continued Organizing Public Wiki Page | ||
− | 06/07/2016 - Public Wiki Page on TPP | + | 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/08/2016 - Working on [[Innovation Policy]] Wiki Page research and writing |
− | 06/09/2016 - Innovation Policy | + | 06/09/2016 - [[Innovation Policy]] and reworking links |
− | 06/10/2016 - Patent Reform linked pages | + | 06/10/2016 - Patent Reform linked pages ([[Innovation Policy]]) |
− | 06/13/2016 - Innovation Act | + | 06/13/2016 - [[Innovation Act]] |
− | 06/14/2016 - Innovation Policy Page | + | 06/14/2016 - [[Innovation Policy]] Page |
− | 06/15/2016 - Patent System Background/Data and restructuring | + | 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 | + | 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. | ||
− | 06/24/2016 - Wiki page for small and micro entities, SQL patent data. | + | 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/27/2016 - Made tables in SQL patent data (ex: US only assignees) , looked at potential tables that need to made for the paper. | ||
Line 42: | Line 43: | ||
06/29/2016 - Finished LexMachina Spreadsheet and refined SQL tables. Added another problem on the Wiki Page for the database. | 06/29/2016 - Finished LexMachina Spreadsheet and refined SQL tables. Added another problem on the Wiki Page for the database. | ||
− | 07/ | + | 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. | ||
+ | |||
+ | [[Category:Work Log]] |
Latest revision as of 12:10, 2 November 2017
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.