monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

46 rows where filer_id = 118 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, report_date, report_start_date, report_end_date, transaction_id, last_name, city, state, zipcode, 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
38500 38500 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2017-03-17 2017-01-01 2017-03-16   INC702 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2017-03-16 -164497.27 -164497.27   513.0 INC702
30308 30308 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2017-01-24 2016-09-25 2016-10-22 2016-11-08 INC419 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-07 250000 5400000      
30309 30309 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2017-01-24 2016-09-25 2016-10-22 2016-11-08 INC428 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-13 200000 5400000      
30310 30310 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2017-01-24 2016-09-25 2016-10-22 2016-11-08 INC429 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-14 500000 5400000      
31554 31554 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2017-01-24 2016-10-23 2016-12-31   INC547 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-26 1500000 7470000      
31555 31555 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2017-01-24 2016-10-23 2016-12-31   INC624 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-11-01 570000 7470000      
31556 31556 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2017-01-24 2016-10-23 2016-12-31   INC659 COM D.R.I.V.E. - DEMOCRAT, REPUBLICAN, INDEPENDENT VOTER EDUCATION     Washington DC 20001     n   2016-11-07 1000 1000   41.0  
28868 28868 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-12-28 2016-07-01 2016-09-24 2016-11-08 INC102 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-07-06 250000 4450000      
28869 28869 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-12-28 2016-07-01 2016-09-24 2016-11-08 INC168 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-07-26 200000 4450000      
28870 28870 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-12-28 2016-07-01 2016-09-24 2016-11-08 INC196 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-08-03 200000 4450000      
28871 28871 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-12-28 2016-07-01 2016-09-24 2016-11-08 INC218 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-08-05 200000 4450000      
28872 28872 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-12-28 2016-07-01 2016-09-24 2016-11-08 INC222 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-08-08 3000000 4450000      
30311 30311 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-12-28 2016-09-25 2016-10-22 2016-11-08 INC419 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-07 250000 5400000      
30312 30312 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-12-28 2016-09-25 2016-10-22 2016-11-08 INC428 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-13 200000 5400000      
30313 30313 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-12-28 2016-09-25 2016-10-22 2016-11-08 INC429 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-14 500000 5400000      
28680 28680 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-28 2016-01-01 2016-06-30   INC1 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-04-22 50000 600000      
28681 28681 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-28 2016-01-01 2016-06-30   INC15 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-05-10 50000 600000      
28682 28682 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-28 2016-01-01 2016-06-30   INC23 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-05-18 200000 600000      
28683 28683 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-28 2016-01-01 2016-06-30   INC69 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-06-22 100000 600000      
28684 28684 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-28 2016-01-01 2016-06-30   INC78 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-06-24 100000 600000      
28685 28685 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-28 2016-01-01 2016-06-30   INC85 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-06-27 100000 600000      
28873 28873 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-27 2016-07-01 2016-09-24 2016-11-08 INC102 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-07-06 250000 4450000      
28874 28874 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-27 2016-07-01 2016-09-24 2016-11-08 INC168 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-07-26 200000 4450000      
28875 28875 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-27 2016-07-01 2016-09-24 2016-11-08 INC196 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-08-03 200000 4450000      
28876 28876 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-27 2016-07-01 2016-09-24 2016-11-08 INC218 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-08-05 200000 4450000      
28877 28877 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-27 2016-07-01 2016-09-24 2016-11-08 INC222 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-08-08 3000000 4450000      
32278 32278 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-27 2016-09-25 2016-10-22 2016-11-08 INC419 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-07 250000 5400000      
32279 32279 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-27 2016-09-25 2016-10-22 2016-11-08 INC428 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-13 200000 5400000      
32280 32280 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-10-27 2016-09-25 2016-10-22 2016-11-08 INC429 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-10-14 500000 5400000      
34087 34087 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC102 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-07-06 250000 4450000   406.0  
34088 34088 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC168 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-07-26 200000 4450000   406.0  
34089 34089 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC196 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-08-03 200000 4450000   406.0  
34090 34090 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC218 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-08-05 200000 4450000   406.0  
34091 34091 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-29 2016-07-01 2016-09-24 2016-11-08 INC222 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-08-08 3000000 4450000   406.0  
28674 28674 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-25 2016-01-01 2016-06-30   INC1 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-04-22 50000 600000   406.0  
28675 28675 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-25 2016-01-01 2016-06-30   INC15 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-05-10 50000 600000   406.0  
28676 28676 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-25 2016-01-01 2016-06-30   INC23 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-05-18 200000 600000   406.0  
28677 28677 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-25 2016-01-01 2016-06-30   INC69 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-06-22 100000 600000   406.0  
28678 28678 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-25 2016-01-01 2016-06-30   INC78 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-06-24 100000 600000   406.0  
28679 28679 1385180 118 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 133 2016-09-25 2016-01-01 2016-06-30   INC85 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-06-27 100000 600000   406.0  
35160 35160 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 2016-08-01 2016-01-01 2016-06-30   INC1 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-04-22 50000 600000   406.0  
35161 35161 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 2016-08-01 2016-01-01 2016-06-30   INC15 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-05-10 50000 600000   406.0  
35162 35162 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 2016-08-01 2016-01-01 2016-06-30   INC23 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-05-18 200000 600000   406.0  
35163 35163 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 2016-08-01 2016-01-01 2016-06-30   INC69 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-06-22 100000 600000   406.0  
35164 35164 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 2016-08-01 2016-01-01 2016-06-30   INC78 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-06-24 100000 600000   406.0  
35165 35165 1385180 118 NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC 169 2016-08-01 2016-01-01 2016-06-30   INC85 COM AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC (NON-PROFIT 501(C)(6))     San Rafael CA 94901     n   2016-06-27 100000 600000   406.0  

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");