on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

45 rows where filer_id = 40 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, transaction_id, entity_type, payee_last_name, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, expenditure_description, 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
897 897 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 EDT30 IND Bellino Dan     Oakland CA 94611 2015-02-16 320 500   Campaign Worker   Parker Bryan     MAY City of Oakland, CA              
898 898 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-07-27 2015-01-01 2015-06-30 2014-11-04 EDT31 IND Bellino Dan     Oakland CA 94611 2015-02-16 180 500   Campaign Worker   Parker Bryan     MAY City of Oakland, CA              
509 509 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-02-02 2014-10-19 2014-12-31 2014-11-04 EDT29 OTH California State Board of Equalization       Oakland CA 94612 2014-10-31 363.02 4480.09 CMP Sales Tax   Parker Bryan     MAY City of Oakland, CA              
357 357 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-01-16 2014-10-01 2014-10-18 2014-11-04 EDT28 OTH California State Board of Equalization       Oakland CA 94612 2014-10-01 201.82 4117.07 CMP Sales Tax   Parker Bryan     MAY City of Oakland, CA              
358 358 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-01-16 2014-10-01 2014-10-18 2014-11-04 EDT26 OTH California State Board of Equalization       Oakland CA 94612 2014-10-09 1361.01 4117.07 LIT Sales Tax   Parker Bryan     MAY City of Oakland, CA              
359 359 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-01-16 2014-10-01 2014-10-18 2014-11-04 PDT3 OTH California State Board of Equalization       Oakland CA 94612 2014-10-16 140.74 4117.07 CMP Sales Tax   Parker Bryan     MAY City of Oakland, CA              
360 360 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-01-16 2014-10-01 2014-10-18 2014-11-04 EDT25 OTH United States Postal Service       Oakland CA 94612 2014-10-09 10800 58685.6 POS     Parker Bryan     MAY City of Oakland, CA              
361 361 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-01-16 2014-10-01 2014-10-18 2014-11-04 EDT27 OTH United States Postal Service       Oakland CA 94612 2014-10-16 10025 58685.6 POS     Parker Bryan     MAY City of Oakland, CA              
362 362 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-01-16 2014-10-01 2014-10-18 2014-11-04 PDT4 OTH United States Postal Service       Oakland CA 94612 2014-10-16 10025 58685.6 LIT     Parker Bryan     MAY City of Oakland, CA              
363 363 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2015-01-16 2014-10-01 2014-10-18 2014-11-04 PDT5 OTH United States Postal Service       Oakland CA 94612 2014-10-16 10025 58685.6 POS     Parker Bryan     MAY City of Oakland, CA              
702 702 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 EDT28 OTH California State Board of Equalization       Oakland CA 94612 2014-10-01 201.82 4117.07 CMP Sales Tax   Parker Bryan     MAY City of Oakland, CA              
703 703 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 EDT26 OTH California State Board of Equalization       Oakland CA 94612 2014-10-09 1361.01 4117.07 LIT Sales Tax   Parker Bryan     MAY City of Oakland, CA              
704 704 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT3 OTH California State Board of Equalization       Oakland CA 94612 2014-10-16 140.74 4117.07 CMP Sales Tax   Parker Bryan     MAY City of Oakland, CA              
705 705 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 EDT25 OTH United States Postal Service       Oakland CA 94612 2014-10-09 10800 58685.6 POS     Parker Bryan     MAY City of Oakland, CA              
706 706 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 EDT27 OTH United States Postal Service       Oakland CA 94612 2014-10-16 10025 58685.6 POS     Parker Bryan     MAY City of Oakland, CA              
707 707 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT4 OTH United States Postal Service       Oakland CA 94612 2014-10-16 10025 58685.6 LIT     Parker Bryan     MAY City of Oakland, CA              
708 708 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-22 2014-10-01 2014-10-18 2014-11-04 PDT5 OTH United States Postal Service       Oakland CA 94612 2014-10-16 10025 58685.6 POS     Parker Bryan     MAY City of Oakland, CA              
767 767 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT13 OTH California State Board of Equalization       Oakland CA 94612 2014-07-11 126.06 2413.5 LIT Sales Tax   Parker Bryan     MAY City of Oakland, CA              
768 768 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT16 OTH California State Board of Equalization       Oakland CA 94612 2014-07-30 119.09 2413.5 LIT Sales Tax   Parker Bryan     MAY City of Oakland, CA              
769 769 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT17 OTH California State Board of Equalization       Oakland CA 94612 2014-07-30 121.18 2413.5 LIT Sales Tax   Parker Bryan     MAY City of Oakland, CA              
770 770 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT19 OTH California State Board of Equalization       Oakland CA 94612 2014-08-14 123.87 2413.5 LIT Sales Tax   Parker Bryan     MAY City of Oakland, CA              
771 771 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT21 OTH California State Board of Equalization       Oakland CA 94612 2014-08-14 122.89 2413.5 LIT Sales Tax   Parker Bryan     MAY City of Oakland, CA              
772 772 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT23 OTH California State Board of Equalization       Oakland CA 94612 2014-09-29 450 2413.5 CMP Sales Tax   Parker Bryan     MAY City of Oakland, CA              
773 773 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT24 OTH California State Board of Equalization       Oakland CA 94612 2014-09-29 234.59 2413.5 CMP Sales Tax   Parker Bryan     MAY City of Oakland, CA              
774 774 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT9 OTH United States Postal Service       Oakland CA 94612 2014-07-11 663.49 17810.6 POS     Parker Bryan     MAY City of Oakland, CA              
775 775 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT14 OTH United States Postal Service       Oakland CA 94612 2014-07-30 680.44 17810.6 POS     Parker Bryan     MAY City of Oakland, CA              
776 776 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT15 OTH United States Postal Service       Oakland CA 94612 2014-07-30 655.1 17810.6 POS     Parker Bryan     MAY City of Oakland, CA              
777 777 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT18 OTH United States Postal Service       Oakland CA 94612 2014-08-14 674.31 17810.6 POS     Parker Bryan     MAY City of Oakland, CA              
778 778 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-10-06 2014-07-01 2014-09-30 2014-11-04 EDT20 OTH United States Postal Service       Oakland CA 94612 2014-08-14 664.01 17810.6 POS     Parker Bryan     MAY City of Oakland, CA              
127 127 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-09-16 2014-01-01 2014-06-30 2014-11-04 PDT1 OTH California State Board of Equalization       Oakland CA 94612 2014-06-25 126.12 1115.82 LIT     Parker Bryan     MAY City of Oakland, CA              
128 128 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-09-16 2014-01-01 2014-06-30 2014-11-04 EDT11 OTH California State Board of Equalization       Oakland CA 94612 2014-06-19 129.06 1115.82 LIT     Parker Bryan     MAY City of Oakland, CA              
129 129 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-09-16 2014-01-01 2014-06-30 2014-11-04 EDT7 OTH United States Postal Service       Oakland CA 94612 2014-06-12 645.05 14473.25 POS     Parker Bryan     MAY City of Oakland, CA              
130 130 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-09-16 2014-01-01 2014-06-30 2014-11-04 EDT5 OTH United States Postal Service       Oakland CA 94612 2014-04-04 12500 14473.25 POS     Parker Bryan     MAY City of Oakland, CA              
131 131 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-09-16 2014-01-01 2014-06-30 2014-11-04 PDT2 OTH United States Postal Service       Oakland CA 94612 2014-06-25 654.95 14473.25 POS     Parker Bryan     MAY City of Oakland, CA              
132 132 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-09-16 2014-01-01 2014-06-30 2014-11-04 EDT4 OTH California State Board of Equalization       Oakland CA 94612 2014-04-04 737.55 1115.82 CMP     Parker Bryan     MAY City of Oakland, CA              
133 133 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-09-16 2014-01-01 2014-06-30 2014-11-04 EDT6 OTH United States Postal Service       Oakland CA 94612 2014-06-19 673.25 14473.25 POS     Parker Bryan     MAY City of Oakland, CA              
134 134 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-09-16 2014-01-01 2014-06-30 2014-11-04 EDT10 OTH California State Board of Equalization       Oakland CA 94612 2014-06-12 123.09 1115.82 LIT     Parker Bryan     MAY City of Oakland, CA              
834 834 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 PDT2 OTH United States Postal Service       Oakland CA 94612 2014-06-25 654.95 14473.25 POS     Parker Bryan     MAY City of Oakland, CA              
835 835 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT10 OTH California State Board of Equalization       Oakland CA 94612 2014-06-12 123.09 1115.82 LIT     Parker Bryan     MAY City of Oakland, CA              
836 836 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT6 OTH United States Postal Service       Oakland CA 94612 2014-06-19 673.25 14473.25 POS     Parker Bryan     MAY City of Oakland, CA              
837 837 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT4 OTH California State Board of Equalization       Oakland CA 94612 2014-04-04 737.55 1115.82 CMP     Parker Bryan     MAY City of Oakland, CA              
838 838 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT11 OTH California State Board of Equalization       Oakland CA 94612 2014-06-19 129.06 1115.82 LIT     Parker Bryan     MAY City of Oakland, CA              
839 839 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT7 OTH United States Postal Service       Oakland CA 94612 2014-06-12 645.05 14473.25 POS     Parker Bryan     MAY City of Oakland, CA              
840 840 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 PDT1 OTH California State Board of Equalization       Oakland CA 94612 2014-06-25 126.12 1115.82 LIT     Parker Bryan     MAY City of Oakland, CA              
841 841 1357609 40 Parker for Oakland Mayor 2014 34 CTL 2014-07-31 2014-01-01 2014-06-30 2014-11-04 EDT5 OTH United States Postal Service       Oakland CA 94612 2014-04-04 12500 14473.25 POS     Parker Bryan     MAY City of Oakland, CA              

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "on_behalf_of_expenditures" (
"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 ["on_behalf_of_expenditures_filer_id"] ON [on_behalf_of_expenditures]("filer_id");
CREATE INDEX ["on_behalf_of_expenditures_filer_name"] ON [on_behalf_of_expenditures]("filer_name");
CREATE INDEX ["on_behalf_of_expenditures_committee_id"] ON [on_behalf_of_expenditures]("committee_id");