Changes

#U.S. Publicly-traded firms (1980-present) ##Industry Definitions in NAICS codes for O&G vs. IT vs. BT, etc. ###According to Ed, Will might not be doing these as much as us##Competition in markets ##Stocks and flows ##Branch offices ##Presence and size of Corp VC arms ##Joins to other data ###Flow and return of private equity deals ###Mean stock and flow of patents by year and industry ####Overlaps with us###Mean stock and flow of venture backed by year and industry (# and $) ####Overlaps with us###Mean flow of M&As by year and industry (# and $) ####Overlaps with us###Mean stock and flow of JVs by year and industry (# and $?) ###Mean flow of Spinoffs by year and industry (# and $)####Overlaps with us

===Our project===#Open Innovation and Competition (Avesh & Carlin previously worked on Oil & Gas) ##Oil vs. other sectors - Is there open innovation for Oil & Gas? ##Other interns: ??? ##Measures: M&A, spinoffs, patents, etc.###A note: these can be taken from Will's project ==General data we need to proceed==*Patent data - knowledge of what we have & what we're looking for in the data*M&As by year and industry (# and $) (do we pull this from SDC?)*Spinoffs by year and industry (# and $) (do we pull this from SDC?)*How to do industry classifications**Did some work on this last semester but might want to revisit*limiting the data to companies in the S&P 500? Or no? ==Skills we probably need to proceed==*SQL technical skills - probably know basics but it might be good to know general ways we can manipulate the data once we get it*COMPUSTAT, SDC for companies' industry groups ==Timeline==*Should start off with a lit review