monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

22 rows where filer_id = 172 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, transaction_id, entity_type, last_name, first_name, city, zipcode, employer, occupation, transaction_date, transaction_amt, year_to_date, committee_id, report_date (date), report_start_date (date), report_end_date (date), election_date (date), transaction_date (date)

Link rowid filer_id filer_name report_date ▲ report_start_date report_end_date election_date transaction_id entity_type last_name first_name prefix city state zipcode employer occupation self_employed transaction_type transaction_date transaction_amt year_to_date transaction_description committee_id memo_reference_number
43037 43037 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2018-10-21 2018-12-31 2018-11-06 2g1bVS4jMFcm COM International Brotherhood of Electrical Workers, Local 595 Issues PAC     Dublin CA 94568     n   2018-10-29 1000 1000   547.0  
43038 43038 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2018-10-21 2018-12-31 2018-11-06 o18moCYXdKWi COM Sheet Metal Workers Int'l Assoc. Local 104 PAC     San Ramon CA 94583     n   2018-11-01 1000 1000   81.0  
43039 43039 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2018-10-21 2018-12-31 2018-11-06 vUA4AT4IxVsz OTH IBEW Union 1245 Educational Fund     Vacaville CA 95687     n   2018-11-02 1500 1500      
43040 43040 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2018-10-21 2018-12-31 2018-11-06 8yQvYsbZgU12 IND Cornu Sharon   Oakland CA 94602 St. Mary's Center 7381 Consultant n   2018-11-05 250 250      
43041 43041 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2018-10-21 2018-12-31 2018-11-06 DRT4XraBDXhg IND Weber Alice   Oakland CA 94618 Gordon & Associates, Inc. 342 Database Manager n   2018-11-05 200 200      
43042 43042 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2018-10-21 2018-12-31 2018-11-06 xXJWap8ZH3dN IND Tolbert Carol Lee   Oakland CA 94608 Tolbert & Associates 7382 Consultant n   2018-11-06 100 100      
43043 43043 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2018-10-21 2018-12-31 2018-11-06 qpFsa1BYzVji OTH Int'l Association of Heat & Frost Insulators & Allied Workers Local 16     Benicia CA 94510     n   2018-11-08 1000 1000      
43044 43044 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2018-10-21 2018-12-31 2018-11-06 yym3yenAw8EW OTH Sprinkler Fitters & Apprentices Local 483     Hayward CA 94545     n   2018-11-14 500 500      
43045 43045 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2018-10-21 2018-12-31 2018-11-06 45zeTFCgCX9V COM Mayor Libby Schaaf 2014 Officeholder Committee     Los Angeles CA 90017     n   2018-12-19 1000 2000   560.0  
55468 55468 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2019-01-01 2019-06-30 2018-11-06 9Dw2bnIHB7OO COM Oakland Police Officers Association PAC     Sacramento CA 95815     n   2019-01-10 2000 2000   222.0  
55469 55469 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-07-14 2019-01-01 2019-06-30 2018-11-06 hRso1fZPd5yQ COM Re-elect Dan Kalb Oakland City Council 2016     Oakland CA 94601     n   2019-04-15 150 150   506.0  
44590 44590 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-01-31 2018-10-21 2018-12-31 2018-11-06 2g1bVS4jMFcm COM International Brotherhood of Electrical Workers, Local 595 Issues PAC     Dublin CA 94568     n   2018-10-29 1000 1000   547.0  
44591 44591 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-01-31 2018-10-21 2018-12-31 2018-11-06 o18moCYXdKWi COM Sheet Metal Workers Int'l Assoc. Local 104 PAC     San Ramon CA 94583     n   2018-11-01 1000 1000   81.0  
44592 44592 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-01-31 2018-10-21 2018-12-31 2018-11-06 vUA4AT4IxVsz OTH IBEW Union 1245 Educational Fund     Vacaville CA 95687     n   2018-11-02 1500 1500      
44593 44593 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-01-31 2018-10-21 2018-12-31 2018-11-06 DRT4XraBDXhg IND Weber Alice   Oakland CA 94618 Gordon & Associates, Inc. 342 Database Manager n   2018-11-05 200 200      
44594 44594 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-01-31 2018-10-21 2018-12-31 2018-11-06 qpFsa1BYzVji OTH Int'l Association of Heat & Frost Insulators & Allied Workers Local 16     Benicia CA 94510     n   2018-11-08 1000 1000      
44595 44595 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-01-31 2018-10-21 2018-12-31 2018-11-06 yym3yenAw8EW OTH Sprinkler Fitters & Apprentices Local 483     Hayward CA 94545     n   2018-11-14 500 500      
44596 44596 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2019-01-31 2018-10-21 2018-12-31 2018-11-06 45zeTFCgCX9V COM Mayor Libby Schaaf 2014 Officeholder Committee     Los Angeles CA 90017     n   2018-12-19 1000 2000   560.0  
45706 45706 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2018-10-25 2018-09-28 2018-10-20 2018-11-06 5BYiKdppIr9E COM International Association of Firefighters Local 55 PAC     Oakland CA 94612     n   2018-10-05 5000 5000   59.0  
45707 45707 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2018-10-25 2018-09-28 2018-10-20 2018-11-06 arCB4PAgF4M4 COM IFPTE Local 21 Issues PAC Fund     San Francisco CA 94103     n   2018-10-15 10000 10000   251.0  
45708 45708 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2018-10-25 2018-09-28 2018-10-20 2018-11-06 PngeCxN4rT2K COM Mayor Libby Schaaf 2014 Officeholder Committee     Los Angeles CA 90017     n   2018-10-20 1000 1000   560.0  
45709 45709 1412582 172 Oaklanders for Fair Taxation & Improved City Services, a Kalb ballot measure Committee in Favor of Measure X 218 2018-10-25 2018-09-28 2018-10-20 2018-11-06 rxBKc7vkqCkn OTH Services Employees International Union Local 1021 Issues PACCommittee ID #1296947     Sacramento CA 95814     n   2018-10-20 5000 5000      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "monetary_contributions" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "last_name" TEXT,
  "first_name" TEXT,
  "prefix" INTEGER,
  "city" TEXT,
  "state" TEXT,
  "zipcode" TEXT,
  "employer" INTEGER,
  "occupation" TEXT,
  "self_employed" TEXT,
  "transaction_type" INTEGER,
  "transaction_date" TEXT,
  "transaction_amt" INTEGER,
  "year_to_date" INTEGER,
  "transaction_description" INTEGER,
  "committee_id" TEXT,
  "memo_reference_number" INTEGER
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id),
    FOREIGN KEY ("employer") REFERENCES [businesses](id));
CREATE INDEX ["monetary_contributions_filer_id"] ON [monetary_contributions]("filer_id");
CREATE INDEX ["monetary_contributions_filer_name"] ON [monetary_contributions]("filer_name");
CREATE INDEX ["monetary_contributions_committee_id"] ON [monetary_contributions]("committee_id");
CREATE INDEX ["monetary_contributions_employer"] ON [monetary_contributions]("employer");