E&I Governance Policy Report

McNair Project

E&I Governance Policy Report
Project Information
Project Title
Start Date
Deadline
Primary Billing
Notes
Has project status
Copyright © 2016 edegan.com. All Rights Reserved.

Supreme Court Cases

https://docs.google.com/spreadsheets/d/10S0ysa5UkS3V__v_EsraE7I7ZFL-vY4GrjGP_Nd1oEU/edit#gid=0

Keywords used:

• entrepreneur!
• angel investor
• small business!
• venture capital
• incubator
• accelerator
• innovat!
• patent!
• copyright
• trademark
• infringe!
• patent troll
• freedom to operate
• inventor
• thicket
• portfolio
• prior art

Executive Orders

https://docs.google.com/spreadsheets/d/1HRCdFBs1584jnUBBLG4yR_K1dz2_os6ILVGXeAjZ1pE/edit#gid=0

same keywords

Council of Economic Advisors

Google “Council of Economic Advisers Economic Report of the President [year]” for every year back to 1980. Go to Appendix A, and see whether or not there is a innovation/entrepreneurship expert working that year. Give their name, their area of expertise, and the total number of economists working at the CEA at that time. (Don’t worry about research assistants or administrative positions) Then give the CEA a “grade” for that year. A for Entrepreneurship/Innovation, B for IO or Small Business, C for other peripheral activities, F if there are no related experts that year.

the total number of CEA economists was determined by adding the total number of senior staff economists listed in the economic report and adding the members (usually two) and the chairman together.

https://docs.google.com/spreadsheets/d/14v1oPB8MIbtYmPP5fENtqA1wfAR_ban-SfhJgQEtd3Y/edit#gid=0

Code

Christy:

Output: E:\McNair\Projects\Govtrack Bill search\Innovation Bills\Bills.txt OUTPUT IS CURRENTLY RUNNING BUT IT WILL GO THERE

Code: E:\McNair\Projects\Govtrack Bill search\Innovation Bills\Gov Track.py to run: change the filepath variable to the directory your .txt files are in. press run. Expected file format: congressnumber/year_something_billnumber.txt

Change

11/22: We needed to remove the regex searches for "infringe", "patently" and "venture" so I fixed and tested it and reran the program on the Bills data from Harsh.

Code is in the same place as above:

Code: E:\McNair\Projects\Govtrack Bill search\Innovation Bills\Gov Track.py to run: change the filepath variable to the directory your .txt files are in. press run. Expected file format: congressnumber/year_something_billnumber.txt

The new output is: E:\McNair\Projects\Govtrack Bill search\Innovation Bills\BillsNew.txt

Executive Orders

Peter:

Data is stored in:

E:\McNair\Projects\Executive_order_crawler 

The file named executive.txt is a tab delimited text file that contains executive orders from 1993-Present with the following information: Subject, Link, Sign Date, and Order Number.

The Orders folder contains all the executive orders from 1993-Present, and each order is named by its order number.

To use the executive order crawler: From the command line, change directories to:

E:\McNair\Projects\Executive_order_crawler\executive 

Run the following command to output the data to a csv file:

scrapy crawl executive_spider -o filename.csv

Note: Running the script will download all executive orders as PDFs.

Converting PDF to text (FOR FUTURE KNOWLEDGE) using Adobe Acrobat Pro DC, A Step by Step Guide:

Open AdobeAcrobat Pro DC!
Go to Tools 
Scroll Down and select Action Wizard (Under Customize)
Select New Action 
Under files to be processed, select the folder or files that you wish to be processed.
Click the dropdown menu on the left titled Save & Export
Click Save
Click Specify Settings
Click export Files to Alternate Format
Select Plain Text from the drop down menu
Click Save and name your action
To run the action, select it from the Actions List on the Right Hand side of the screen

Note: This crashes fairly frequently and needs some human supervision.