monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

29 rows where filer_name = 91 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, entity_type, last_name, first_name, city, state, zipcode, employer, occupation, transaction_date, transaction_amt, year_to_date, 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
27597 27597 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-10-16 2015-07-01 2015-10-16 2014-11-04 M6ozxfcEcp5Y IND Johnson Michael   Oakland CA 94619-3714 Abbott Diabetes Care 765 Healthcare Administration n   2015-10-16 12845.87 12691.74      
11204 11204 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 Qpcn7eNK8kqa IND Baker J.D. Clarence   Oakland CA 94612 Self-employed: Clarence Baker Law Offices 3325 Attorney n   2014-10-21 100 100      
11205 11205 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 IxX1b3wL19ZY IND Drennon Sarah   Seagoville TX 75159-1223 Baylor 3326 Lab Technician n   2014-10-21 100 100      
11206 11206 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 w3Bb6ZkXeIri IND Miller Jerome   Richmond CA 94804 Chevron Products Company 3327 Operations Technical Writer n   2014-10-21 100 428      
11207 11207 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 rKZZcAqIiM8w IND Barnette Christa   Vacaville CA 95688-9272 Kaiser Permanente 137 Nurse n   2014-10-23 50 125      
11208 11208 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 BJUezTdafZ81 IND Stein David   Oakland CA 94610-3432 Donahue Fitzgerald LLP 2406 Attorney n   2014-10-23 100 200      
11209 11209 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 pbgkAcIbnVUP IND Laday Frances   Oakland CA 94619 Retired Abbott ADC 3328 Retired n   2014-10-24 100 253      
11210 11210 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 qHJjvkRFdLiW IND Schroeder Susan   Oakland CA 94619-3727 Retired/Alameda County 3329 Hospital Administrator n   2014-10-24 100 325      
11211 11211 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 tlNCW3tTyQgT COM League of Conservation Voters of the East Bay     Oakland CA 94612     n   2014-10-25 200 200   247.0  
11212 11212 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 P5q2ZOJXfqWC IND Mattox Darlene   Oakland CA 9465-1514 Kaiser Permanente 137 Consultant n   2014-10-25 100 100      
11213 11213 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 58bxYmN4vbss IND Pierson Willie   San Jose CA 95148 Alum Rock School District 3330 Teacher n   2014-10-25 150 150      
11214 11214 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 TIMU5tc92izp IND Stanchina Sonja   Danville CA 94526 Contra Costa Water District 3331 HR Supervisor n   2014-10-25 100 300      
11215 11215 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 DrcTdvSmYURh IND Davidson Ronald   Oakland CA 94619-2728 Laney College 2772 Instructor n   2014-10-26 100 100      
11216 11216 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 h7lNlNlsEZRt IND Love Earl   Oakland CA 94607-2829 Kaiser Permanente 137 Medical Technology n   2014-10-27 150 150      
11217 11217 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 uVehg39c8YLe IND Nalls David   Vallejo CA 94590-3123 Retired 124 Retired Police Officer n   2014-10-27 25 325      
11218 11218 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 oCllHiVE5GGP IND Payne Jackson   Lakeland TN 38002 Self-employed: Jackson Payne DDS 3332 Dentist n   2014-10-27 100 100      
11219 11219 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 EJwHUdDjxxlg IND Tabron Sadie   San Leandro CA 94577-5868 None-Disability 3333 RN n   2014-10-28 25 125      
11220 11220 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 4chiNJc5i3ic IND Johnson Jessie   Alameda CA 94501 Retired Kaiser Permanente 3334 Retired n   2014-10-29 10 135      
11221 11221 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 TY2oGfDmdrIA IND Blue Debra   Richmond CA 94805-1130 Contra Costa Community College District 3335 Vice Chancellor n   2014-10-30 100 100      
11222 11222 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 HkKm1hFt47N7 IND Mak Vin   Livermore CA 94551 Self-employed: VinMak LLC 3336 Owner n   2014-10-31 100 100      
11223 11223 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 tzdYJ8xDdV1Y IND Cook Nate   Oakland CA 94603 IGI 3337 General Manager n   2014-11-01 100 100      
11224 11224 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 yLomoMfhjx6u IND Husband Brenda   Pinole CA 94564-2318 UCSF Benioff Children's Hospital Oakland 3338 Manager of Compliance, Employee & Labor Relations n   2014-11-01 215 665      
11225 11225 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 B4xeUNP7vhMv IND Mejia John   Alameda CA 94501 Lawrence Berkeley National Laboratory 1013 Program Manager n   2014-11-01 100 300      
11226 11226 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 p9eW1NfM9MFy IND Johnson Carolyn   Alameda CA 94501-5068 Peralta Community College District 1080 Instructor n   2014-11-03 50 350      
11227 11227 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 qzLb6DKGq2J3 IND Walker Troy   Oakland CA 94605 Fritolay Inc 3339 Sales Representative n   2014-11-08 40 440      
11228 11228 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 OpDFzkvlVKHu IND Nalls David   Vallejo CA 94590-3123 Retired 124 Retired Police Officer n   2014-11-27 25 325      
11229 11229 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 pd2XZCYLcsLd IND Hansen Chris   Oakland CA 94610-1620 Coldwell Banker 248 Realtor n   2014-12-27 10 180      
11230 11230 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 I8tIn2NvWgkN IND Roby Sheila   Oakland CA 94606 Self-employed: Colonial Life 3340 Insurance Sales n   2014-12-27 30 305      
11231 11231 1360826 91 COMMITTEE TO ELECT MICHAEL V. JOHNSON CITY COUNCIL 2014 91 2015-09-11 2014-10-19 2014-12-31 2014-11-04 xhcp5XdGiylN IND Winegan Vanessa   Oakland CA 94605-1011 Self-employed: Semme Boutique 3341 Owner/Manager n   2014-12-27 75 200      

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