Campaign Finances

Report of US Companies Endorsing Political Campaigns

@kaggle.rishidamarla_campaign_finances

Table List

1 table(126.77 KB)

Campaign Finance Expenditures Dataset 1

@kaggle.rishidamarla_campaign_finances.campaign_finance_expenditures_dataset_1

126.77 KB
3152 rows
18 columns

payee Payee	paid_by Paid By	payment_amount Payment Amount	payment_date Payment Date	payee_type Payee Type	payee_address Payee Address	city_state_zip City State Zip	payment_year Payment Year	expenditure_type Expenditure Type	date_reported Date Reported	report_filed Report Filed	expense_description Expense Description	political_obligation Political Obligation	reimbursement_intended Reimbursement Intended	correction Correction	view_report View Report	transaction_id TRANSACTION ID
Austin's Pizza	Austin Unites	$196.35	Sat Apr 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	2222 Rio Grande St #110	Austin, TX, 78705	2016	Political Expenditure from Political Contributions	Mon Jul 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	SPAC: Specific-Purpose Committee Campaign Finance Report	Food/Beverage Expense \| Volunteer Food	Yes	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258188)	R20160718161156-F0001
Moreland Consulting, LLC	Austin4All PAC	$2725.00	Wed Mar 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	5202 Woodmoor Dr	Austin, TX, 78221	2016	Political Expenditure from Political Contributions	Mon Jul 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	SPAC: Specific-Purpose Committee Campaign Finance Report	Consulting	Yes	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258185)	R20160718161720-F0003
Wells Fargo	Austin4All PAC	$15.00	Thu Mar 03 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	3949 S Lamar Blvd	Austin, TX, 78704	2016	Non-political Expenditure Made From Political Contributions	Mon Jul 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	SPAC: Specific-Purpose Committee Campaign Finance Report	Fee	No	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258185)	R20160718161720-F0004
Wells Fargo	Austin4All PAC	$14.00	Tue May 31 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	3949 S Lamar Blvd	Austin, TX, 78704	2016	Non-political Expenditure Made From Political Contributions	Mon Jul 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	SPAC: Specific-Purpose Committee Campaign Finance Report	Fee	No	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258185)	R20160718161720-F0005
Wells Fargo	Austin4All PAC	$14.00	Thu Jun 30 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	3949 S Lamar Blvd	Austin, TX, 78704	2016	Non-political Expenditure Made From Political Contributions	Mon Jul 18 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	SPAC: Specific-Purpose Committee Campaign Finance Report	Fee	No	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258185)	R20160718161720-F0006
IEEE US Bank	Pressley, Laura	$350.00	Wed Jan 20 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	P. O. Box 790408	St. Louis, MO, 63179	2016	Political Expenditure from Political Contributions	Tue Jul 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C/OH: Candidate/Officeholder Campaign Finance Report	CC payment	No	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258178)	R20160726163007-F0003
Capital One	Pressley, Laura	$300.00	Tue Feb 16 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	P.O. Box 60599	City Of Industry, CA, 91716	2016	Political Expenditure from Political Contributions	Tue Jul 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C/OH: Candidate/Officeholder Campaign Finance Report	CC payment	No	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258178)	R20160726163007-F0007
Discover	Pressley, Laura	$250.00	Wed Feb 17 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	P.O. Box 6103	Carol Steam, IL, 60197	2016	Political Expenditure from Political Contributions	Tue Jul 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C/OH: Candidate/Officeholder Campaign Finance Report	CC payment	No	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258178)	R20160726163007-F0008
Citi Card	Pressley, Laura	$610.00	Wed Feb 17 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	P.O. Box 183037	Columbus, OH, 43218	2016	Political Expenditure from Political Contributions	Tue Jul 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C/OH: Candidate/Officeholder Campaign Finance Report	CC payment	No	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258178)	R20160726163007-F0010
Office Depot	Pressley, Laura	$108.24	Mon Feb 29 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	Entity	816 Tirado St	Austin, TX, 78752	2016	Political Expenditure from Political Contributions	Tue Jul 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	C/OH: Candidate/Officeholder Campaign Finance Report	Printing Supplies	No	nan	nan	View Report (http://www.austintexas.gov/edims/document.cfm?id=258178)	R20160726163007-F0011


CREATE TABLE campaign_finance_expenditures_dataset_1 (
  "payee" VARCHAR,
  "paid_by" VARCHAR,
  "payment_amount" VARCHAR,
  "payment_date" TIMESTAMP,
  "payee_type" VARCHAR,
  "payee_address" VARCHAR,
  "city_state_zip" VARCHAR,
  "payment_year" BIGINT,
  "expenditure_type" VARCHAR,
  "date_reported" TIMESTAMP,
  "report_filed" VARCHAR,
  "expense_description" VARCHAR,
  "travel_outside_texas" VARCHAR,
  "political_obligation" VARCHAR,
  "reimbursement_intended" VARCHAR,
  "correction" VARCHAR,
  "view_report" VARCHAR,
  "transaction_id" VARCHAR
);