feep/senate_financial_disclosures

US Senate Financial Disclosures

12,821 entries
806.77 KB size
CSV format
latest commit: 13 days ago
Readme

US Senate Financial Disclosures

Do you want to know what your Senators are buying on the stock market?

The STOCK Act

The STOCK act requires every Member of Congress to publicly file and disclose selected financial transactions within 45 days.

The Senate’s disclosures are available at efdsearch.senate.gov.

Crawling the site

@neelsomani shared a Selenium script to crawl the disclosures.

Super useful, but it takes 2.5 hours to run on my slowish internet connection. I am making the crawled data available as a CSV.

Using the data

If you are planning on running an analysis on this dataset, some things to note:

  • Disclosures do not have have to be filed until 45 days after the transaction.
  • Senator reports are available until six years after the individual ceases to be a member.
  • Candidate reports are available for one year after the individual is no longer a candidate.
  • Early filings are filed as scans. They do not show up in the table There are no records before 2014, and things are spotty for a period after that.
  • Some tickers are missing or filled in by company name.
  • If the ticker is not available on Yahoo Finance, the trade is ignored.
  • Transaction amounts are filed as ranges.
Meta

Theme

government

Keywords

government
US Senate
financial disclosures

Description

No description provided

Body Preview
field_1field_2field_3field_4field_5field_6field_7field_8
1file_datetx_datefirst_namelast_nameorder_typetickertx_range_low
202014-01-312014-01-29Susan MCollinsPurchaseMSFT1001
312014-01-312014-01-29Susan MCollinsSale (Partial)C1001
422014-01-312014-01-29Susan MCollinsSale (Partial)C1001
532014-01-312014-01-28Susan MCollinsSale (Partial)EBAY1001
642014-01-312014-01-24Susan MCollinsPurchaseFB1001
752014-01-312014-01-24Susan MCollinsPurchaseCRM1001
862014-01-312014-01-24Susan MCollinsSale (Partial)GE1001
902014-02-052014-01-30Susan MCollinsSale (Partial)REGN1001
1012014-02-052014-01-30Susan MCollinsSale (Partial)CELG1001
1122014-02-052014-01-30Susan MCollinsSale (Partial)GM1001
1232014-02-052014-01-30Susan MCollinsPurchaseMSFT1001
1342014-02-052014-01-30Susan MCollinsPurchaseHON1001
1452014-02-052014-01-30Susan MCollinsPurchaseCVS1001
1502014-02-062014-01-06SaxbyChamblissSale (Full)SNV1001
1602014-02-112014-02-04Susan MCollinsSale (Partial)BA1001
1712014-02-112014-02-04Susan MCollinsPurchaseFB1001
1822014-02-112014-02-04Susan MCollinsPurchaseCP1001
1932014-02-112014-01-31Susan MCollinsSale (Partial)GE1001
2042014-02-112014-02-07Susan MCollinsSale (Partial)BA1001
2152014-02-112014-02-06Susan MCollinsSale (Partial)CVX1001
2262014-02-112014-02-06Susan MCollinsPurchaseMCK1001
2372014-02-112014-02-06Susan MCollinsPurchaseMSFT1001
2482014-02-112014-02-06Susan MCollinsPurchaseHON1001
2592014-02-112014-02-06Susan MCollinsPurchaseCMCSA1001
2602014-02-122014-01-31ThadCochranPurchaseDFS15001
2712014-02-122014-01-23ThadCochranSale (Full)L1001
2822014-02-122014-01-31ThadCochranSale (Full)ARP15001
2932014-02-122014-01-21ThadCochranSale (Full)GS15001
3042014-02-122014-01-16ThadCochranSale (Full)LGCY15001
3102014-02-142014-02-12Susan MCollinsSale (Partial)LNKD1001
3212014-02-142014-02-11Susan MCollinsSale (Partial)NWSA1001
3322014-02-142014-02-11Susan MCollinsPurchaseCRM1001
3402014-02-242014-01-22MarkBegichSale (Partial)KERX1001
3512014-02-242014-01-22MarkBegichPurchaseIMH1001
3602014-02-252014-02-13Susan MCollinsPurchaseMCK1001
3712014-02-252014-02-19Susan MCollinsPurchaseFB1001
3822014-02-252014-02-20Susan MCollinsSale (Partial)AIG1001
3902014-02-272014-02-06Rafael ECruzPurchaseBFK15001
4012014-02-272014-02-21Rafael ECruzPurchaseEPD50001
4102014-02-272014-01-31SheldonWhitehouseSale (Full)CLX15001
4212014-02-272014-02-10SheldonWhitehouseSale (Partial)AAPL15001
4322014-02-272014-02-10SheldonWhitehouseSale (Full)EMR1001
4432014-02-272014-02-10SheldonWhitehouseSale (Full)GIS15001
4542014-02-272014-02-10SheldonWhitehouseSale (Partial)NSRGY15001
4652014-02-272014-01-29SheldonWhitehouseSale (Full)BA15001
4762014-02-272014-01-29SheldonWhitehouseSale (Full)SYMC15001
4872014-02-272014-02-10SheldonWhitehousePurchaseV15001
4982014-02-272014-02-10SheldonWhitehousePurchaseNEE15001
5092014-02-272014-02-10SheldonWhitehousePurchaseCMRE15001
51102014-02-272014-01-29SheldonWhitehousePurchaseLNKD1001
52112014-02-272014-01-31SheldonWhitehousePurchaseMO1001
53122014-02-272014-01-31SheldonWhitehousePurchaseLOW1001
5402014-03-042014-02-26Susan MCollinsSale (Partial)ESRX1001
5512014-03-042014-02-26Susan MCollinsPurchaseRHT1001
5622014-03-042014-02-26Susan MCollinsPurchaseMCK1001
5702014-03-052014-02-21John FReedSale (Full)VOD1001
5802014-03-062014-02-21Thomas RCarperPurchaseSJR1001
5912014-03-062014-02-27Thomas RCarperSale (Full)EC1001
6022014-03-062014-02-27Thomas RCarperPurchaseRIG1001
6102014-03-112014-02-19JohnHoevenPurchaseIBM50001
6212014-03-112014-02-19JohnHoevenPurchaseVFC50001
6322014-03-112014-02-19JohnHoevenPurchaseCTSH50001
6402014-03-112014-02-13ThadCochranPurchaseLKQ1001
6512014-03-112014-02-12ThadCochranPurchaseLKQ1001
6602014-03-122014-03-28ThadCochranSale (Full)MWE15001
6712014-03-122014-02-13ThadCochranPurchaseLKQ1001
6822014-03-122014-02-12ThadCochranPurchaseLKQ1001
6902014-03-192014-03-12Susan MCollinsSale (Partial)NWL1001
7012014-03-192014-03-11Susan MCollinsSale (Partial)ACE1001
7122014-03-192014-03-11Susan MCollinsPurchaseVRX1001
7232014-03-192014-03-07Susan MCollinsPurchaseFB1001
7342014-03-192014-03-07Susan MCollinsPurchaseSLB1001
7452014-03-192014-03-07Susan MCollinsSale (Partial)GE1001
7562014-03-192014-03-04Susan MCollinsPurchaseRHT1001
7602014-03-242014-02-19John DRockefeller, IVPurchasePEP250001
7712014-03-242014-02-19John DRockefeller, IVSale (Partial)PEP250001
7802014-03-252014-03-18Susan MCollinsSale (Partial)AIG1001
7912014-03-252014-03-19Susan MCollinsPurchaseBA1001
8022014-03-252014-03-19Susan MCollinsSale (Partial)CRM1001
8132014-03-252014-03-14Susan MCollinsSale (Partial)AEP1001
8202014-03-262014-03-13SheldonWhitehousePurchaseJPJQL15001
8312014-03-262014-03-13SheldonWhitehouseSale (Full)CLX1001
8422014-03-262014-03-13SheldonWhitehouseSale (Partial)GE1001
8532014-03-262014-03-13SheldonWhitehouseSale (Partial)AAPL1001
8642014-03-262014-03-13SheldonWhitehouseSale (Partial)KO1001
8752014-03-262014-03-13SheldonWhitehouseSale (Partial)VFC1001
8862014-03-262014-02-19SheldonWhitehousePurchaseORCL1001
8972014-03-262014-02-19SheldonWhitehouseSale (Full)VAR15001
9082014-03-262014-02-19SheldonWhitehousePurchaseTWX1001
9192014-03-262014-02-19SheldonWhitehousePurchaseJPM1001
92102014-03-262014-03-13SheldonWhitehouseSale (Partial)VFC1001
93112014-03-262014-03-13SheldonWhitehousePurchaseBEAV15001
94122014-03-262014-02-25SheldonWhitehouseSale (Partial)DHR1001
95132014-03-262014-02-25SheldonWhitehousePurchasePANW1001
96142014-03-262014-02-25SheldonWhitehousePurchaseQLIK1001
97152014-03-262014-02-19SheldonWhitehousePurchaseV15001
98162014-03-262014-02-19SheldonWhitehousePurchaseEL1001
99172014-03-262014-02-19SheldonWhitehousePurchaseACE1001
100182014-03-262014-02-19SheldonWhitehouseSale (Full)CLX15001
Previewing 100 of 12,821 entries