expenditure_summaries

FPPC Form 460, Schedule D

Data source: D_Expenditure

71 rows where filer_name = 99 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, entity_type, payee_last_name, payee_city, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, expenditure_description, candidate_last_name, candidate_first_name, office_sought, office_jurisdiction, district_number, ballot_measure_name, ballot_measure_number, support_or_oppose, report_date (date), report_start_date (date), report_end_date (date), election_date (date), expenditure_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type payee_last_name payee_first_name payee_prefix payee_suffix payee_city payee_state payee_zipcode expenditure_date expenditure_amt year_to_date expenditure_type expenditure_description committee_id candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number incumbent ballot_measure_name ballot_measure_number ballot_measure_jurisdiction support_or_oppose memo_reference_number
1218 1218 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2016-08-01 2016-01-01 2016-06-30 2016-11-08 YEc4Oe5jbwtU COM Mayor Libby Schaaf Officeholder Committee       Oakland CA 94610 2016-06-30 700 700 MON Contribution to officeholder committee   Schaaf Libby     MAY Oakland           S  
1219 1219 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2016-08-01 2016-01-01 2016-06-30 2016-11-08 oOj3dsr2wavY COM Nate Miley for Supervisor       Oakland CA 94604 2016-06-04 860 860 MON Contribution to Candidate Committee   Miley Nate     CSU Alameda           S  
1220 1220 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2016-08-01 2016-01-01 2016-06-30 2016-11-08 tc3Di18b24sb COM Skinner for Senate 2016       Oakland CA 94609 2016-05-31 840 840 MON Monetary contribution   Skinner Nancy     SEN   9         S  
347 347 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 bM1YDZSgwdXv COM Kaplan for Mayor       Oakland CA 94612 2014-09-27 700 1444.45 MON     Kaplan Rebecca     MAY Oakland           S  
348 348 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 QdPrCYRrlZ45 COM Kriss Worthington for City Council       Berkeley CA 94705 2014-09-27 250 679.45 MON     Worthington Kriss     CCM Berkeley 7.0         S  
349 349 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 kmYMu7pJWZTO COM Libby Schaaf for Oakland Mayor       Oakland CA 94612 2014-10-14 700 1444.45 MON     Schaaf Libby     MAY Oakland           S  
350 350 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 dof6hCiclSZO COM Friends of Desley Brooks       Oakland CA 94612 2014-10-16 700 1129.45 MON     Brooks Desley     CCM Oakland 6.0         S  
351 351 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 WIBF93EbqveD COM Dana King for City Council 2014       Oakland CA 94606 2014-10-17 700 1129.45 MON     King Dana     CCM Oakland 2.0         S  
352 352 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 u71ysROcZpQp COM East Bay Express       Oakland CA 94607 2014-10-16 210 1129.45 IND Print ad mentioning support for candidate   Brooks Desley     CCM Oakland 6.0         S  
353 353 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 2FfTmSSupjtG COM East Bay Express       Oakland CA 94607 2014-10-16 420 1444.45 IND Print ad mentioning support for candidate   Kaplan Rebecca     MAY Oakland           S  
354 354 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 U7jietIrvxNi COM East Bay Express       Oakland CA 94607 2014-10-16 420 1444.45 IND Print ad mentioning support for candidate   Schaaf Libby     MAY Oakland           S  
355 355 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 7kEm4PmOVCbC COM East Bay Express       Oakland CA 94607 2014-10-16 210 679.45 IND Print ad mentioning support for candidate   Worthington Kriss     CCM Berkeley 7.0         S  
356 356 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 HNxY9kVXhJse COM East Bay Express       Oakland CA 94607 2014-10-16 42 177.45 IND Print ad mentioning support for candidate   Arreguin Jessie     CCM Berkeley 4.0         S  
357 357 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 ia7353CCMnmi COM East Bay Express       Oakland CA 94607 2014-10-16 42 177.45 IND Print ad mentioning support for candidate   Quirk Bill     ASM   20.0         S  
358 358 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 KNAY2XsiO3UF COM East Bay Express       Oakland CA 94607 2014-10-16 210 429.45 IND Print ad mentioning support for candidate   Guillen Abel     CCM Oakland 2.0         S  
359 359 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 oV7EIaTH8ETC COM East Bay Express       Oakland CA 94607 2014-10-16 21 145.95 IND Print ad mentioning support for candidate   Newsom Gavin     LTG             S  
360 360 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 Wa2nxKgcjQ6R COM East Bay Express       Oakland CA 94607 2014-10-16 21 156.45 IND Print ad mentioning support for candidate   Lee Barbara     OTH California Federal 13.0         S  
361 361 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 NePhOq3cx2Rl COM East Bay Express       Oakland CA 94607 2014-10-16 21 145.95 IND Print ad mentioning support for candidate   Gold Ron     ATT             S  
362 362 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 3uFFs5ufuIR9 COM East Bay Express       Oakland CA 94607 2014-10-16 21 145.95 IND Print ad mentioning support for candidate   Yee Betty     CON             S  
363 363 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 g1GIaCpZSmQs COM East Bay Express       Oakland CA 94607 2014-10-16 210 1129.45 IND Print ad mentioning support for candidate   King Dana     CCM Oakland 2.0         S  
364 364 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 NJvifPEWQwuZ COM East Bay Express       Oakland CA 94607 2014-10-16 115.5 173.25 IND Print ad mentioning support of Proposition 47                   Proposition 47 47 California S  
365 365 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 pL8lUvvJaiZB COM East Bay Express       Oakland CA 94607 2014-10-16 115.5 173.25 IND Pint ad mentioning opposition to Proposition 46                   Proposition 46 46 California O  
366 366 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 tpOKsuGal9YO COM East Bay Express       Oakland CA 94607 2014-10-10 210 1444.45 IND Print ad mentioning support for candidate   Kaplan Rebecca     MAY Oakland           S  
367 367 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 CIst78ZeMyj2 COM East Bay Express       Oakland CA 94607 2014-10-10 210 1444.45 IND Print ad mentioning support for candidate   Schaaf Libby     MAY Oakland           S  
368 368 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 m2kPCZXcrFo1 COM East Bay Express       Oakland CA 94607 2014-10-10 105 1129.45 IND Print ad mentioning support for candidate   King Dana     CCM Oakland 2.0         S  
369 369 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 iqdHaLe5WIjX COM East Bay Express       Oakland CA 94607 2014-10-10 105 429.45 IND Print ad mentioning support for candidate   Guillen Abel     CCM Oakland 2.0         S  
370 370 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 GelTGMpVF7SQ COM East Bay Express       Oakland CA 94607 2014-10-10 105 679.45 IND Print ad mentioning support for candidate   Worthington Kriss     CCM Berkeley 7.0         S  
371 371 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 DDSFaiSDbihu COM East Bay Express       Oakland CA 94607 2014-10-10 105 1129.45 IND Print ad mentioning support for candidate   Brooks Desley     CCM Oakland 6.0         S  
372 372 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 Hw9DocSkMbck COM East Bay Express       Oakland CA 94607 2014-10-10 21 177.45 IND Print ad mentioning support for candidate   Arreguin Jessie     CCM Berkeley 4.0         S  
373 373 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 lhGLfDBUWRoi COM East Bay Express       Oakland CA 94607 2014-10-10 21 177.45 IND Print ad mentioning support for candidate   Quirk Bill     ASM   20.0         S  
374 374 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 1gMlV6nrhjY7 COM East Bay Express       Oakland CA 94607 2014-10-10 21 156.45 IND Print ad mentioning support for candidate   Lee Barbara     OTH California Federal 13.0         S  
375 375 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 TpzygSUZWLEf COM East Bay Express       Oakland CA 94607 2014-10-10 10.5 145.95 IND Print ad mentioning support for candidate   Newsom Gavin     LTG             S  
376 376 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 qF86KxVd34qK COM East Bay Express       Oakland CA 94607 2014-10-10 10.5 145.95 IND Print ad mentioning support for candidate   Gold Ron     ATT             S  
377 377 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 abeyxikrahKp COM East Bay Express       Oakland CA 94607 2014-10-10 10.5 145.95 IND Print ad mentioning support for candidate   Yee Betty     CON             S  
378 378 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 6SYeFV2B6v8r COM East Bay Express       Oakland CA 94607 2014-10-10 57.75 173.25 IND Print ad mentioning support for Proposition 47                   Proposition 47 47 California S  
379 379 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 bKjHehiu7Yfr COM East Bay Express       Oakland CA 94607 2014-10-10 57.75 173.25 IND Print ad mentioning opposition to Proposition 46                   Proposition 46 46 California O  
380 380 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 8LDOLrZKZ2yp IND ScanArt       Emeryville CA 94608 2014-10-23 114.45 114.45 IND Information Card listing endorsement                         O  
381 381 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 JqKPPNpwFmv8 IND ScanArt       Emeryville CA 94608 2014-10-23 114.45 114.45 IND Information Card listing endorsement                         S  
382 382 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 mMyN58ifO9Qq COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 429.45 IND Information Card listing endorsement   Guillen Abel     CCM Oakland 2.0         S  
383 383 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 6rqsey7kcjmt COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 145.95 IND Information Card listing endorsement   Yee Betty     CON             S  
384 384 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 VXKVUrmHmhs3 COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 156.45 IND Information Card listing endorsement   Lee Barbara     OTH California Federal 13.0         S  
385 385 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 IPasUnpVlsov COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 145.95 IND Information Card listing endorsement   Gold Ron     ATT             S  
386 386 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 44Chr15jIcqW COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 177.45 IND Information Card listing endorsement   Quirk Bill     ASM   20.0         S  
387 387 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 eAJWOZd53Yib COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 1129.45 IND Information Card listing endorsement   Brooks Desley     CCM Oakland 6.0         S  
388 388 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 TPT6c1IA4mAX COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 679.45 IND Information Card listing endorsement   Worthington Kriss     CCM Berkeley 7.0         S  
389 389 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 Xd96q9Vq54tP COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 1129.45 IND Information Card listing endorsement   King Dana     CCM Oakland 2.0         S  
390 390 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 JSFdOliDb1ol COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 1444.45 IND Information Card listing endorsement   Kaplan Rebecca     MAY Oakland           S  
391 391 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 1MPsNbQsIlT8 COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 1444.45 IND Information Card listing endorsement   Schaaf Libby     MAY Oakland           S  
392 392 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 3oqRbzvA3UY2 COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 145.95 IND Information Card listing endorsement   Newsom Gavin     LTG             S  
393 393 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2015-01-30 2014-07-01 2014-12-31 2014-11-04 IRJrSYz5FU1X COM ScanArt       Emeryville CA 94608 2014-10-23 114.45 177.45 IND Information Card listing endorsement   Arreguin Jessie     CCM Berkeley 4.0         S  
422 422 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 u71ysROcZpQp COM East Bay Express       Oakland CA 94607 2014-10-16 210 1015 IND Print ad mentioning support for candidate   Brooks Desley     CCM Oakland 6.0         S  
423 423 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 2FfTmSSupjtG COM East Bay Express       Oakland CA 94607 2014-10-16 420 1330 IND Print ad mentioning support for candidate   Kaplan Rebecca     MAY Oakland           S  
424 424 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 U7jietIrvxNi COM East Bay Express       Oakland CA 94607 2014-10-16 420 1330 IND Print ad mentioning support for candidate   Schaaf Libby     MAY Oakland           S  
425 425 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 7kEm4PmOVCbC COM East Bay Express       Oakland CA 94607 2014-10-16 210 565 IND Print ad mentioning support for candidate   Worthington Kriss     CCM Berkeley 7.0         S  
426 426 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 KNAY2XsiO3UF COM East Bay Express       Oakland CA 94607 2014-10-16 210 315 IND Print ad mentioning support for candidate   Guillen Abel     CCM Oakland 2.0         S  
427 427 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 g1GIaCpZSmQs COM East Bay Express       Oakland CA 94607 2014-10-16 210 1015 IND Print ad mentioning support for candidate   King Dana     CCM Oakland 2.0         S  
428 428 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 NJvifPEWQwuZ COM East Bay Express       Oakland CA 94607 2014-10-16 115.5 173.25 IND Print ad mentioning support of Proposition 47                   Proposition 47 47 California S  
429 429 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 pL8lUvvJaiZB COM East Bay Express       Oakland CA 94607 2014-10-16 115.5 173.25 IND Pint ad mentioning opposition to Proposition 46                   Proposition 46 46 California O  
430 430 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 tpOKsuGal9YO COM East Bay Express       Oakland CA 94607 2014-10-10 210 1330 IND Print ad mentioning support for candidate   Kaplan Rebecca     MAY Oakland           S  
431 431 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 bM1YDZSgwdXv COM Kaplan for Mayor       Oakland CA 94612 2014-09-27 700 1330 MON     Kaplan Rebecca     MAY Oakland           S  
432 432 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 kmYMu7pJWZTO COM Libby Schaaf for Oakland Mayor       Oakland CA 94612 2014-10-14 700 1330 MON     Schaaf Libby     MAY Oakland           S  
433 433 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 dof6hCiclSZO COM Friends of Desley Brooks       Oakland CA 94612 2014-10-16 700 1015 MON     Brooks Desley     CCM Oakland 6.0         S  
434 434 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 QdPrCYRrlZ45 COM Kriss Worthington for City Council       Berkeley CA 94705 2014-09-27 250 565 MON     Worthington Kriss     CCM Berkeley 7.0         S  
435 435 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 WIBF93EbqveD COM Dana King for City Council 2014       Oakland CA 94606 2014-10-17 700 1015 MON     King Dana     CCM Oakland 2.0         S  
436 436 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 CIst78ZeMyj2 COM East Bay Express       Oakland CA 94607 2014-10-10 210 1330 IND Print ad mentioning support for candidate   Schaaf Libby     MAY Oakland           S  
437 437 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 m2kPCZXcrFo1 COM East Bay Express       Oakland CA 94607 2014-10-10 105 1015 IND Print ad mentioning support for candidate   King Dana     CCM Oakland 2.0         S  
438 438 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 iqdHaLe5WIjX COM East Bay Express       Oakland CA 94607 2014-10-10 105 315 IND Print ad mentioning support for candidate   Guillen Abel     CCM Oakland 2.0         S  
439 439 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 GelTGMpVF7SQ COM East Bay Express       Oakland CA 94607 2014-10-10 105 565 IND Print ad mentioning support for candidate   Worthington Kriss     CCM Berkeley 7.0         S  
440 440 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 DDSFaiSDbihu COM East Bay Express       Oakland CA 94607 2014-10-10 105 1015 IND Print ad mentioning support for candidate   Brooks Desley     CCM Oakland 6.0         S  
441 441 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 6SYeFV2B6v8r COM East Bay Express       Oakland CA 94607 2014-10-10 57.75 173.25 IND Print ad mentioning support for Proposition 47                   Proposition 47 47 California S  
442 442 1372459 98 Oakland Civil Liberties Alliance 99 RCP 2014-10-23 2014-09-23 2014-10-18 2014-11-04 bKjHehiu7Yfr COM East Bay Express       Oakland CA 94607 2014-10-10 57.75 173.25 IND Print ad mentioning opposition to Proposition 46                   Proposition 46 46 California O  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "expenditure_summaries" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "committee_type" TEXT,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "payee_last_name" TEXT,
  "payee_first_name" TEXT,
  "payee_prefix" TEXT,
  "payee_suffix" TEXT,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "payee_zipcode" TEXT,
  "expenditure_date" TEXT,
  "expenditure_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "expenditure_type" TEXT,
  "expenditure_description" TEXT,
  "committee_id" INTEGER,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT,
  "incumbent" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "support_or_oppose" TEXT,
  "memo_reference_number" TEXT
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id));
CREATE INDEX ["expenditure_summaries_filer_id"] ON [expenditure_summaries]("filer_id");
CREATE INDEX ["expenditure_summaries_filer_name"] ON [expenditure_summaries]("filer_name");
CREATE INDEX ["expenditure_summaries_committee_id"] ON [expenditure_summaries]("committee_id");