monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

40 rows where employer = 7206 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, election_date, transaction_id, last_name, first_name, city, state, zipcode, 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
43089 43089 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-07-29 2018-10-21 2018-12-31 2018-11-16 KBpajeCUegsy IND Buchheim Richard   Alameda CA 94501 self, no separate business name 7206 management consultant n   2018-10-24 100 450      
43128 43128 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-07-29 2018-10-21 2018-12-31 2018-11-16 mlNGXXgEEYRE IND Bergeson Dylan   Emeryville CA 94608 self, no separate business name 7206 journalist n   2018-10-27 50 300      
43167 43167 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-07-29 2018-10-21 2018-12-31 2018-11-16 XvobxRIucigM IND Romero Gianoli Ricardo 'Monk'   Oakland CA 94606 self, no separate business name 7206 Electrician n   2018-10-28 150 170      
43252 43252 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-07-29 2018-10-21 2018-12-31 2018-11-16 FImZMjHaWlE4 IND Buchheim Richard   Alameda CA 94501 self, no separate business name 7206 management consultant n   2018-11-05 100 450      
42233 42233 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 zggQCvzrPGj1 IND Nichols Leila   Oakland CA 94601 self, no separate business name 7206 prop stylist n   2018-09-28 100 100      
42299 42299 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 dw7nXHiyekAg IND Bergeson Dylan   Emeryville CA 94608 self, no separate business name 7206 journalist n   2018-10-07 250 250      
42300 42300 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 s5oy8NxeFx1h IND Buchheim Richard   Alameda CA 94501 self, no separate business name 7206 management consultant n   2018-10-07 250 250      
42304 42304 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 W1TCHbvgqbxn IND Costello Mollie   Oakland CA 94612 self, no separate business name 7206 Social Justice worker n   2018-10-07 100 100      
42309 42309 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 YazPwTcOjZ2x IND Gates Chris   Oakland CA 94608 self, no separate business name 7206 video producer n   2018-10-07 100 100      
42310 42310 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 EAXFlMPQwJ3N IND Glass Kevin   Oakland CA 94609 self, no separate business name 7206 actor n   2018-10-07 100 100      
42314 42314 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 vFgCftnfDsNb IND Karol Angelisse   Oakland CA 94611 self, no separate business name 7206 design consultant n   2018-10-07 100 100      
42335 42335 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 ahQAr6rQlZbo IND Whitbeck John   Monroe CT 06468 self, no separate business name 7206 IT consultant n   2018-10-09 100 100      
42337 42337 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 NiYpphKjrua4 IND Cooper Amanda   Alameda CA 94501 self, no separate business name 7206 Communications consultant n   2018-10-10 100 100      
42347 42347 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 QysFJPNju2ix IND Schechter Mara   Oakland CA 94610 self, no separate business name 7206 digital campaign consultant n   2018-10-11 800 800      
42349 42349 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 pQkf9itvEaut IND Vinal Sam   Los Angeles CA 90065 self, no separate business name 7206 filmmaker n   2018-10-11 800 800      
42366 42366 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 yAnsi3E2SxCk IND Early Steve   Richmond CA 94801 self, no separate business name 7206 Journalist n   2018-10-14 250 250      
42384 42384 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 bKmyERuOnESn IND Ramesh Dhriti   Goleta CA 93117 self, no separate business name 7206 administrative clerk n   2018-10-15 250 250      
42391 42391 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 B5dOUoRdLnEh IND Wilder Drew   Oakland CA 94607 self, no separate business name 7206 yoga teacher n   2018-10-16 100 100      
42396 42396 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 qc26GHbJCweb IND Myers Regina   Piedmont CA 94611 self, no separate business name 7206 free lance musician n   2018-10-17 800 800      
42399 42399 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-09-23 2018-10-20 2018-11-06 FySWbMr3trJF IND Haas Claire   Oakland CA 94601 self, no separate business name 7206 Coach and consultant n   2018-10-18 100 100      
44263 44263 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-10-21 2018-12-31 2018-11-06 KBpajeCUegsy IND Buchheim Richard   Alameda CA 94501 self, no separate business name 7206 management consultant n   2018-10-24 100 450      
44302 44302 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-10-21 2018-12-31 2018-11-06 mlNGXXgEEYRE IND Bergeson Dylan   Emeryville CA 94608 self, no separate business name 7206 journalist n   2018-10-27 50 300      
44341 44341 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-10-21 2018-12-31 2018-11-06 XvobxRIucigM IND Romero Gianoli Ricardo 'Monk'   Oakland CA 94606 self, no separate business name 7206 Electrician n   2018-10-28 150 170      
44426 44426 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2019-01-31 2018-10-21 2018-12-31 2018-11-06 FImZMjHaWlE4 IND Buchheim Richard   Alameda CA 94501 self, no separate business name 7206 management consultant n   2018-11-05 100 450      
45831 45831 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 zggQCvzrPGj1 IND Nichols Leila   Oakland CA 94601 self, no separate business name 7206 prop stylist n   2018-09-28 100 100      
45897 45897 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 dw7nXHiyekAg IND Bergeson Dylan   Emeryville CA 94608 self, no separate business name 7206 journalist n   2018-10-07 250 250      
45898 45898 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 s5oy8NxeFx1h IND Buchheim Richard   Alameda CA 94501 self, no separate business name 7206 management consultant n   2018-10-07 250 250      
45902 45902 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 W1TCHbvgqbxn IND Costello Mollie   Oakland CA 94612 self, no separate business name 7206 Social Justice worker n   2018-10-07 100 100      
45907 45907 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 YazPwTcOjZ2x IND Gates Chris   Oakland CA 94608 self, no separate business name 7206 video producer n   2018-10-07 100 100      
45908 45908 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 EAXFlMPQwJ3N IND Glass Kevin   Oakland CA 94609 self, no separate business name 7206 actor n   2018-10-07 100 100      
45912 45912 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 vFgCftnfDsNb IND Karol Angelisse   Oakland CA 94611 self, no separate business name 7206 design consultant n   2018-10-07 100 100      
45931 45931 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 ahQAr6rQlZbo IND Whitbeck John   Monroe CT 06468 self, no separate business name 7206 IT consultant n   2018-10-09 100 100      
45933 45933 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 NiYpphKjrua4 IND Cooper Amanda   Alameda CA 94501 self, no separate business name 7206 Communications consultant n   2018-10-10 100 100      
45942 45942 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 QysFJPNju2ix IND Schechter Mara   Oakland CA 94610 self, no separate business name 7206 digital campaign consultant n   2018-10-11 800 800      
45944 45944 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 pQkf9itvEaut IND Vinal Sam   Los Angeles CA 90065 self, no separate business name 7206 filmmaker n   2018-10-11 800 800      
45961 45961 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 yAnsi3E2SxCk IND Early Steve   Richmond CA 94801 self, no separate business name 7206 Journalist n   2018-10-14 250 250      
45979 45979 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 bKmyERuOnESn IND Ramesh Dhriti   Goleta CA 93117 self, no separate business name 7206 administrative clerk n   2018-10-15 250 250      
45986 45986 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 B5dOUoRdLnEh IND Wilder Drew   Oakland CA 94607 self, no separate business name 7206 yoga teacher n   2018-10-16 100 100      
45991 45991 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 qc26GHbJCweb IND Myers Regina   Piedmont CA 94611 self, no separate business name 7206 free lance musician n   2018-10-17 800 800      
45994 45994 1405474 153 Polk 'Cat Brooks' for Mayor 2018; Sheilagh, ID # 1405474 191 2018-10-25 2018-09-23 2018-10-20 2018-11-06 FySWbMr3trJF IND Haas Claire   Oakland CA 94601 self, no separate business name 7206 Coach and consultant n   2018-10-18 100 100      

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