monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

38 rows where filer_name = 92 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, 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
15201 15201 1366842 92 Karl Debro for School Board 2014 92 2014-10-23 2014-10-01 2014-10-18 2014-11-04 SdJZVxMBLcc8 OTH AFSCME council 57     sacramento CA 95814     n   2014-10-06 1000 1000      
15202 15202 1366842 92 Karl Debro for School Board 2014 92 2014-10-23 2014-10-01 2014-10-18 2014-11-04 bbqeeQUwsJ3E IND bowerman MARGARET   oakland CA 94602 unknown 1518 unknown n   2014-10-14 100 100      
15203 15203 1366842 92 Karl Debro for School Board 2014 92 2014-10-23 2014-10-01 2014-10-18 2014-11-04 frGKQtqwiZix IND HOM aRT   crestmont CA 94619 unknown 1518 unknown n   2014-10-17 100 100      
15204 15204 1366842 92 Karl Debro for School Board 2014 92 2014-10-23 2014-10-01 2014-10-18 2014-11-04 RfTsd1fQJSwU IND johnson jonnie   sacratmento CA 95813 unknown 1518 unknown n   2014-10-11 250 250      
15205 15205 1366842 92 Karl Debro for School Board 2014 92 2014-10-23 2014-10-01 2014-10-18 2014-11-04 oXdyMg6MBJ4r IND TAYLOR SUSAN   OAKLAND CA 94618 RETIRED 2892 RETIRED n   2014-10-11 250 250      
18052 18052 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 BltvTbBDrnat IND Marcone Monica   Oakland CA 94618 Sabre Foods 3998 Marketing n   2014-08-07 100 100      
18053 18053 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 GYwPV1fiuTOc IND Lismer Liz   San Leandro CA 94577 Retired 124   n   2014-08-08 100 100      
18054 18054 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 NuaP9x1cCFel IND Cuomo Douglass   Brooklyn NY 11215 Self 228 Composer n   2014-08-13 250 250      
18055 18055 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 XASvrzoWxRfs IND McMahon Jeff   Torrance CA 90503 El Camino College 3999 Instructor n   2014-08-15 100 100      
18056 18056 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 6HMc4yl4ikg7 IND Ginsberg Barbara   Oakland CA 94602 self 543 lawyer n   2014-08-20 100 100      
18057 18057 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 PDNCEKVHlSEL IND Adams Chris   Oakland CA 94605 CBRE 899 Real Estate n   2014-08-21 150 150      
18058 18058 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 vYwKs5kJDU2v IND Broughton Janet   Oakland CA 94602 University of California, Berkeley 384 Vice Provost for Faculty n   2014-08-21 500 500      
18059 18059 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 giFcOiCCyjBp IND Collins (Regina Stroud) Linda   Oakland CA 94618 Career Ladders Project 4000 Founder and Executive Director n   2014-08-21 250 250      
18060 18060 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 GFfMMEGnHYb8 IND Cook Catherine   Alameda CA 94501 Da Vinci Center 4001 President n   2014-08-21 100 100      
18061 18061 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 TXRr8E3GIkNT IND Donaldson Brian   Oakland CA 94602 East Bay Regional Parks 4002 Park Ranger n   2014-08-21 300 300      
18062 18062 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 nErRdf2EuHwL IND Mayeda Kevin   Oakland CA 94605 Weston Geophysical 4003 seismologist n   2014-08-21 150 150      
18063 18063 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 S1fwN1JHGrL6 IND Olnes Dave   Oakland CA 94605 Dave Olnes P.E., Inc. 4004 Eningeer n   2014-08-21 150 150      
18064 18064 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 oRhg7x6OA2JQ IND Stroud (Linda Collins) Regina   Oakland CA 94618 Skyline College 4005 President n   2014-08-21 250 250      
18065 18065 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 okipdeadgz1F IND Barbour Janis   Berkeley CA 94705 unemployed 665 retired n   2014-09-07 700 700      
18066 18066 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 7CmO6OmwEiUn IND Barbour Steve   Berkeley CA 94705 Retired 124   n   2014-09-08 700 700      
18067 18067 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 8ZuYaH6bMLcc IND Douglas Christopher   Frisco TX 75033 Tarrant County College 4006 Faculty n   2014-09-10 100 100      
18068 18068 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 fcByplLpUX2V IND Gilkerson Tammeil   Oakland CA 94602 Contra Costa College 2484 Vice President n   2014-09-23 100 100      
18069 18069 1366842 92 Karl Debro for School Board 2014 92 2014-09-30 2014-07-01 2014-09-30 2014-11-04 PfdkA8K4LJ5C IND Gorham Patricia   Oakland CA 94605 OUSD 1223 Teacher n   2014-09-27 200 200      
18070 18070 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 8n5qHM8iGwxD IND Haddad Michael Mr. Oakland CA 94611 Haddad and Sherwin 4007 Attorney n   2014-05-05 700 700      
18071 18071 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 TQshZcMHExr1 IND Sherwin Julia Ms. Oakland CA 94611 Haddad and Sherwin 4007 Attorney n   2014-05-05 700 700      
18072 18072 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 rXYiQI9QYa6r IND Debro Karl   Oakland CA 94619 Contra Costa College 2484 Educator/Administrator n   2014-05-07 700 700      
18073 18073 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 33oO5cltEteN IND Debro Chris   Oakland CA 94619 self 543 homemaker n   2014-05-08 500 500      
18074 18074 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 URdOakNfMxbQ IND McLane Catherin   Oakland CA 94611 retired 411 Principal (OUSD) n   2014-05-12 100 125      
18075 18075 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 mZBNALlGmMjd IND Smith Marica   New York NY 10031 Firelight Media 4008 Producer n   2014-05-12 100 100      
18076 18076 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 jLbBppVmbFSZ IND McLane Catherin   Oakland CA 94611 retired 411 Principal (OUSD) n   2014-05-16 25 125      
18077 18077 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 OrzpBcriwSOK IND Akiyama Amelia   Castro Valley CA 94546 retired 411 retired n   2014-05-22 100 100      
18078 18078 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 DclHuDSaaiDC IND Saddler Denise   Oakland CA 94619 Berryessa Unified School District 4009 Administrator n   2014-05-31 100 100      
18079 18079 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 hR12pBS2Ty6v IND Taylor Mitchell   Oakland CA 94602 Wells Fargo Bank 178 Banker n   2014-06-01 700 700      
18080 18080 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 FhbViC3j8bUS IND Yeong Michael   Pittsburg CA 94513 Los Medanos College 4010 Teacher n   2014-06-01 100 100      
18081 18081 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 T6G1TT48dxuG IND Apaydin Janan   Oakland CA 94602 OUSD 1223 Teacher n   2014-06-02 400 400      
18082 18082 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 LDMe88kAUYai IND Donaldson Dorris   Castro Valley CA 94546 retired 411 retired n   2014-06-07 300 300      
18083 18083 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 AcsczVBeGgjF IND Austin Barbara   Bay Point CA 94565 Los Medanos College 4010 Professor n   2014-06-12 500 500      
18084 18084 1366842 92 Karl Debro for School Board 2014 92 2014-08-06 2014-05-01 2014-06-30 2014-11-04 kqC8jEHmR93A IND Debro Julies   Seattle WA 98125 retired (University of Washington_ 4011 retired n   2014-06-23 200 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");