contribution_reports_24_hours

FPPC Form 497

Data source: 497

4 rows where committee_id = 444 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_id, filer_name, transaction_id, entity_last_name, entity_city, entity_zipcode, contribution_date, amount, candidate_last_name, office_jurisdiction, report_date (date), contribution_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type entity_last_name entity_first_name entity_prefix entity_suffix entity_city entity_state entity_zipcode contributor_employer contributor_occupation contributor_self_employed contribution_date amount 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 memo_reference_number
256 256 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-11-23       EXP22 COM Re-Elect Jumoke Hinton Hodge for Oakland School Board 2016       Oakland CA 94601       2016-10-24 00:00:00 0 1386416 444 Jumoke Hodge       OTH Alameda County, Dist. 3            
312 312 1380387 113 Oakland Charter Advocates for Excellent Public Schools 123 RCP 2016-10-25       EXP22 COM Re-Elect Jumoke Hinton Hodge for Oakland School Board 2016       Oakland CA 94601       2016-10-24 00:00:00 1000 1386416 444 Jumoke Hodge       OTH Alameda County            
235 235 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 RCP 2016-09-16       EXP2638 COM RE-ELECT JUMOKE HINTON HODGE FOR OAKLAND SCHOOL BOARD 2016       OAKLAND CA 94607       2016-08-24 00:00:00 1500 1386416 444 JUMOKE HINTON HODGE       OTH OAKLAND UNIFIED SCHOOL DISTRICT 3.0          
516 516 1331137 36 FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES 131 RCP 2016-08-25       EXP2638 COM RE-ELECT JUMOKE HINTON HODGE FOR OAKLAND SCHOOL BOARD 2016       OAKLAND CA 94607       2016-08-24 00:00:00 1500 1386416 444 JUMOKE HINTON HODGE       OTH OAKLAND UNIFIED SCHOOL DISTRICT 3.0          

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "contribution_reports_24_hours" (
"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,
  "entity_last_name" TEXT,
  "entity_first_name" TEXT,
  "entity_prefix" TEXT,
  "entity_suffix" TEXT,
  "entity_city" TEXT,
  "entity_state" TEXT,
  "entity_zipcode" TEXT,
  "contributor_employer" INTEGER,
  "contributor_occupation" TEXT,
  "contributor_self_employed" TEXT,
  "contribution_date" TEXT,
  "amount" NUMERIC,
  "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,
  "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),
    FOREIGN KEY ("contributor_employer") REFERENCES [businesses](id));
CREATE INDEX ["contribution_reports_24_hours_filer_id"] ON [contribution_reports_24_hours]("filer_id");
CREATE INDEX ["contribution_reports_24_hours_filer_name"] ON [contribution_reports_24_hours]("filer_name");
CREATE INDEX ["contribution_reports_24_hours_committee_id"] ON [contribution_reports_24_hours]("committee_id");
CREATE INDEX ["contribution_reports_24_hours_contributor_employer"] ON [contribution_reports_24_hours]("contributor_employer");