E&I Governance Policy Report

From edegan.com
Revision as of 12:44, 21 September 2020 by Ed (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search


Project
E&I Governance Policy Report
Project logo 02.png
Project Information
Has title E&I Governance Policy Report
Has owner Albert Nabiullin, Catherine Kirby, Dylan Dickens, Eliza Martin
Has start date
Has deadline date
Has project status Tabled
Has sponsor McNair Center
Has project output Data, Tool, Content
Copyright © 2019 edegan.com. All Rights Reserved.

See also

Supreme Court Cases

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

Note: significant supreme court cases are on the RDP and on Ed's slack*

Keywords used:

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

Bills

Executive Orders

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

same keywords

Descriptive Statistics

E&I executive orders from 1980 to 1992 focused on updating and restructuring the Small Business Administration (SBA). New programs housed under the SBA focused on subsets of small business owners, such as women, minorities, and the disabled. Other applicable executive orders also amended licensing regulations to reduce barriers to entry for new firms. Note that we did not count occupational licensing in our designation for E&I executive orders. For example, an executive order allowing hair dressers to operate without a license does not count as an E&I executive order. These executive orders did not discuss entrepreneurship, patents, venture capital, accelerators, and incubators. Thus, executive orders from this period had a more narrow focus than our general relevancy test for E&I executive orders.

Secretary of State Science and Tech Advisor

Office of Science and Technology Policy

Commerce Department

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

Change 2

  • 11/29: Updated code again to count the occurrences of buzzwords in the bill.
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\Bills1129.txt

Christy and Peter:

  • 12/1: Created a modified text file that has an extra column with a 0 if the bill has not passed and a 1 if the bill has passed. The columns with whether the bill contains buzz words and the number of buzz words are still present. The file is located in:
E:\McNair\Projects\E&I Governance Policy Report\Restructured.txt


Executive Orders

Top 5 executive orders from 1993-2016 *all other significant bills are in the RDP file and on Ed's slack* Executive Order 13539 -- President's Council of Advisors on Science and Technology Established the President's Council of Advisors on Science and Technology (PCAST). Council will advise the President on science, tech, and innovation policy. OSTP will provide funding necessary for PCAST operations. E.O. 12539 expired in two years.

Executive Order 13704—Presidential Innovation Fellows Program Establish the Presidential Innovation Fellows Program (Program) to enable exceptional individuals with proven track records to serve time-limited appointments in executive branch departments and agencies. Link to program: https://www.whitehouse.gov/innovationfellows. Example of PIF work deliverable: http://worker.gov/.

Executive Order 13329-- Encouraging Innovation in Manufacturing This order attempts to encourage innovation in manufacturing by requiring department and agency heads to give priority to manufacturing related research and development, submit reports to the small business administration and more.

Executive Order 13169—Assistance to Small Business Exporters and Dislocated Workers Works to help small business exporters and dislocated workers capitalize on new markets in china, sub-Saharan Africa and the Caribbean basin. Federal agencies should take steps to assist small businesses gain benefits, especially those headed by underserved populations.

Executive Order 13170-- Increasing Opportunities and Access for Disadvantaged Busi­nesses Attempted to increase opportunities and access for disadvantaged businesses for federal contracting opportunities. All agencies are required to take steps to implement terms of the order and ensure non-discrimination for business in the Small Disadvantaged Business Program in the Small Business Administration.

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.

Christy:

  • 11/29: Adapted Harsh's script to produce txt file analysis of the Executive Orders that includes number of times the buzzwords occur.
Code: E:\McNair\Projects\Executive_order_crawler\executive\extractor.py
Output: E:\McNair\Projects\Executive_order_crawler\executive\ExecutiveOrders1129.txt