Senate Investments
Data containing all electronically submitted investments by Senators
@kaggle.heresjohnnyv_congress_investments
Data containing all electronically submitted investments by Senators
@kaggle.heresjohnnyv_congress_investments
The STOCK Act (Stop Trading on Congressional Knowledge) was signed into law by President Barack Obama in 2012. This law prevents insider trading by members of Congress and other government employees that may have access to non-public information. As a result, every Senator is required to publicly file any transaction of stock, bond, commodities futures, and other securities within 45 days.
Disclosures can be found here: https://efdsearch.senate.gov/
Data was collected using a Python script with the Selenium and Pandas modules. The program accessed the site and scrolled through all electronically submitted disclosures, adding each to a data frame.
The data set contains 9 columns:
It's important to note that I wasn't able to scrape data that was physically submitted, meaning some Senators submit handwritten documents to disclose trades. I arranged my code to skip over these documents because I simply lack the knowledge to scrape handwriting with Python.
I'd love to see how Senators' investment returns compare to those of 'normal' people. I plan on running my script again to scrape additional government employee investments to see how they compare!
CREATE TABLE senatorcleaned (
"unnamed_0" BIGINT -- Unnamed: 0,
"name" VARCHAR,
"transaction_date" TIMESTAMP,
"owner" VARCHAR,
"ticker" VARCHAR,
"asset_name" VARCHAR,
"asset_type" VARCHAR,
"type" VARCHAR,
"amount" DOUBLE,
"comment" VARCHAR
);Anyone who has the link will be able to view this.