Senate Investments

Data containing all electronically submitted investments by Senators

@kaggle.heresjohnnyv_congress_investments

Table List

1 table(268.7 KB)

Senatorcleaned

@kaggle.heresjohnnyv_congress_investments.senatorcleaned

268.7 KB
15666 rows
10 columns

unnamed_0 Unnamed: 0	name Name	transaction_date Transaction.Date	owner Owner	ticker Ticker	asset_name Asset.Name	asset_type Asset.Type	type Type	amount Amount	comment Comment
1	Sheldon Whitehouse	Tue Nov 25 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	M	Macy's, Inc. (NYSE)	Stock	Purchase	1001	--
2	Sheldon Whitehouse	Thu Dec 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	BEAV	B/E Aerospace Inc. (NASDAQ)	Stock	Sale (Full)	15001	--
3	Sheldon Whitehouse	Thu Dec 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	KORS	Michael Kors Holdings Limited (NYSE)	Stock	Sale (Partial)	1001	--
4	Sheldon Whitehouse	Thu Dec 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	T	AT&T, Inc. (NYSE)	Stock	Purchase	1001	--
5	Sheldon Whitehouse	Thu Dec 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	KEYS	Keysight Technologies, Inc. (NYSE)	Stock	Sale (Full)	1001	Agilent Tech common stock completed a spinoff on 10/22/14 to Keysight Tech
6	Sheldon Whitehouse	Thu Dec 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	ABBV	AbbVie Inc. (NYSE)	Stock	Purchase	1001	--
7	Sheldon Whitehouse	Thu Dec 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	SSYS	Stratasys Ltd. (NASDAQ)	Stock	Sale (Full)	1001	--
8	Sheldon Whitehouse	Thu Dec 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	HYH	Halyard Health, Inc. (NYSE)	Stock	Sale (Full)	1001	KMB completed a spinoff of its health care business business now known as HYH on 11/01/14
9	Sheldon Whitehouse	Thu Dec 18 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Self	AMGN	Amgen Inc. (NASDAQ)	Stock	Purchase	15001	--
10	Sheldon Whitehouse	Tue Nov 25 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Joint	PRU	Prudential Financial, Inc. (NYSE)	Stock	Purchase	1001	--


CREATE TABLE senatorcleaned (
  "unnamed_0" BIGINT,
  "name" VARCHAR,
  "transaction_date" TIMESTAMP,
  "owner" VARCHAR,
  "ticker" VARCHAR,
  "asset_name" VARCHAR,
  "asset_type" VARCHAR,
  "type" VARCHAR,
  "amount" DOUBLE,
  "comment" VARCHAR
);