contribution_reports_24_hours

FPPC Form 497

Data source: 497

58 rows where filer_id = 71 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: filer_name, entity_type, entity_first_name, entity_city, entity_state, entity_zipcode, contributor_employer, contributor_occupation, committee_id, 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
536 536 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2017-04-12       EXP606 COM Fair and Affordable Santa Rosa, Yes on Measure C - 2017       Santa Rosa CA 95403       2017-04-12 00:00:00 35000 1.39431e+06 514                 Rent Stabilization - Just cause evictions & termination limits. Measure C   City of Santa Rosa  
531 531 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2017-02-23       NON598 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-10-27 00:00:00 2771.39 1.38595e+06 397                       NON:S497:598
532 532 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2017-02-23       NON576 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-11-03 00:00:00 53.18 1.38595e+06 397                        
533 533 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2017-02-23       NON577 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-11-07 00:00:00 742.5 1.38595e+06 397                        
534 534 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2017-02-23       NON578 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-11-07 00:00:00 450.96 1.38595e+06 397                        
262 262 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-11-07       NON576 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-11-03 00:00:00 53.18 1385949 405                       NON:S497:576
263 263 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-11-07       NON577 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-11-07 00:00:00 742.5 1385949 405                        
264 264 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-11-07       NON578 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-11-07 00:00:00 450.96 1385949 405                        
270 270 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-11-05       NON514 COM SEIU Local 2015 Issues PAC       Los Angeles CA 90057       2016-10-01 00:00:00 471.78 1378400 449                       NON:S497:514
271 271 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-11-05       NON573 COM SEIU Local 2015 Issues PAC       Los Angeles CA 90057       2016-11-05 00:00:00 7388.87 1378400 449                       NON:S497:573
274 274 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-11-04       INC572 OTH Youth Uprising       Oakland CA 94605       2016-11-03 00:00:00 10000                          
288 288 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-31       NON553 COM Oakland Working Families, sponsored by labor and community organizations       Oakland CA 94601       2016-10-24 00:00:00 53.4 1390566 454                       NON:S497:553
289 289 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-31       NON554 COM Oakland Working Families, sponsored by labor and community organizations       Oakland CA 94601       2016-10-28 00:00:00 11845.16 1390566 454                        
313 313 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-25       EXP513 COM Alameda Renters' Coalition       Alameda CA 94501       2016-10-25 00:00:00 2500 1384224 456                 Charter Amendment to Establish Rent Control, a Rent Control Board and Regulate Termination of Tenancies, Measure M1   City of Alameda  
314 314 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-24       NON499 COM Oakland Rising Committee sponsored by Movement Strategy Action Center       Oakland CA 94612       2016-10-23 00:00:00 12296 1332115 457                       NON:S497:499
316 316 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-24       NON504 OTH Asian Pacific Environmental Network       Oakland CA 94612       2016-10-13 00:00:00 3591                         NON:S497:504
317 317 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-24       NON505 OTH Asian Pacific Environmental Network       Oakland CA 94612       2016-10-23 00:00:00 5363                         NON:S497:505
318 318 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-24       INC508 OTH Instructional Telecommunications Foundation, Inc. dba Voqal USA       Boulder CO 80306       2016-10-24 00:00:00 5000                          
325 325 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-21       NON498 COM Oakland Rising Committee sponsored by Movement Strategy Action Center       Oakland CA 94612       2016-10-01 00:00:00 24966 1332115 457                       NON:S497:498
328 328 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-21       NON496 COM Mayor Libby Schaaf for Oakland       Oakland CA 94612       2016-10-19 00:00:00 3970.84 1379188 445                        
347 347 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-20       INC493 IND Blackwell Angela G     Oakland CA 94610 Policy Link 96 Founder/Chief Executive Officer   2016-10-20 00:00:00 2000                          
351 351 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-19       IDT69 IND Rose Kalima     Oakland CA 94612 PolicyLink Center 4813 Senior Director   2016-08-16 00:00:00 250                         IDT:S497:69
352 352 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-19       INC491 OTH East Bay Asian Local Development Corporation       Oakland CA 94612       2016-10-19 00:00:00 2500                          
353 353 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-19       IDT151 IND Rose Kalima     Oakland CA 94612 PolicyLink Center 4813 Senior Director   2016-10-19 00:00:00 1750                          
359 359 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-18       INC489 COM International Federation of Professional and Technical Engineers, Local 21 Issues PAC       San Francisco CA 94103       2016-10-17 00:00:00 5000 1362080 251                        
360 360 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-18       INC490 OTH The San Francisco Foundation       San Francisco CA 94111       2016-10-17 00:00:00 50000                          
366 366 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-14       INC480 OTH See Forward Fund, In.       Northhampton MA 01060       2016-10-14 00:00:00 10000                          
382 382 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-12       NON472 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-10-09 00:00:00 4585.65 1385949 405                       NON:S497:472
395 395 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-11       INC471 COM Enterprise Community Investment, Inc.       Columbia MD 21044       2016-09-28 00:00:00 5000                          
400 400 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-11       IDT89 IND Delaney Mary Quinn     Oakland CA 94612 Akonadi Foundation 158 Grantmaker   2016-10-11 00:00:00 5000                          
402 402 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-10       IDT88 COM Park Shiela     Seattle WA 98136   Artist   2016-10-08 00:00:00 5000                          
407 407 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-07       NON469 COM Mayor Libby Schaaf for Oakland       Oakland CA 94612       2016-10-06 00:00:00 1200 1379188 445                        
408 408 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-07       NON468 COM Oakland Working Families, sponsored by labor and community organizations       Oakland CA 94601       2016-10-07 00:00:00 11845.16 1390566 454                        
421 421 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-07       IDT86 IND Aguilar Orson     Berkeley CA 94602 Greenlining 5076 Director   2016-10-07 00:00:00 5000                          
422 422 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-07       IDT87 IND Aguilar Orson     Berkeley CA 94602 Greenlining 5076 Director   2016-10-07 00:00:00 100                          
447 447 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-10-04       NON464 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-09-13 00:00:00 1144.95 1385949 405                        
451 451 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-29       INC455 IND Liu Celine     Oakland CA 94609 Alameda County Office of Education 2536 Program Manager   2016-09-28 00:00:00 3420                          
452 452 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-29       INC454 IND Perry Pamela     Oakland CA 94618 Pamela Perry, Therapist 5092 Therapist   2016-09-28 00:00:00 1000                          
456 456 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-27       INC447 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-09-26 00:00:00 10000 1385949 405                        
457 457 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-27       IDT77 IND Fox Marie     Oakland CA 94610       2016-09-26 00:00:00 1000                          
462 462 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-26       NON441 COM Oakland Working Families, sponsored by labor and community organizations       Oakland CA 94601       2016-09-24 00:00:00 1650.76 1390566 454                        
238 238 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-23       INC407 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-09-09 00:00:00 59089 1385949 405                        
468 468 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-23       PAY439 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-09-23 00:00:00 35000 1385949 405                       PAY:S497:439
477 477 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-22       INC437 COM Service Employees International Union Local 1021 Issues PAC       Oakland CA 94609       2016-09-21 00:00:00 12000 1296947 238                        
492 492 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-12       INC425 OTH ACCE Institute       Los Angeles CA 90007       2016-09-12 00:00:00 40000                          
493 493 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-09-12       INC407 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-09-09 00:00:00 59000 1385949 405                        
507 507 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-08-31       NON398 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-08-15 00:00:00 519.47 1385949 405                       NON:S497:398
508 508 1364564 71 Committee to Protect Oakland Renters - Yes on Measure JJ, sponsored by labor and community organizations 128 BMC 2016-08-31       NON399 COM Causa Justa :: Just Cause (Nonprofit 501 (C)(3))       Oakland CA 94608       2016-08-29 00:00:00 1020.82 1385949 405                       NON:S497:399
12 12 1364564 71 Lift Up Oakland - Yes on Measure FF - for better wages, healthy families and a healthy economy sponsored by labor and community organizations 68 BMC 2014-11-04       INC218 COM Service Employees International Union Local 1021 Issues PAC       Oakland CA 94609       2014-11-03 00:00:00 20000 1.29695e+06 148                        
65 65 1364564 71 Lift Up Oakland - Yes on Measure FF - for better wages, healthy families and a healthy economy sponsored by labor and community organizations 68 BMC 2014-10-16       INC203 COM International Federation of Professional and Technical Engineers, Local 21 Issues PAC       San Francisco CA 94102       2014-10-16 00:00:00 2500 1.36208e+06 287                        
77 77 1364564 71 Lift Up Oakland - Yes on Measure FF - for better wages, healthy families and a healthy economy sponsored by labor and community organizations 68 BMC 2014-10-10       INC178 COM California State Council of Service Employees Issues Committee       Sacramento CA 95814       2014-10-09 00:00:00 25000 960895 250                        
96 96 1364564 71 Lift Up Oakland - Yes on Measure FF - for better wages, healthy families and a healthy economy sponsored by labor and community organizations 68 BMC 2014-10-08       NON158 OTH International Brotherhood of Electrical Workers Local 595       Dublin CA 94568       2014-10-07 00:00:00 5000                          
155 155 1364564 71 Lift Up Oakland - Yes on Measure FF - for better wages, healthy families and a healthy economy sponsored by labor and community organizations 68 BMC 2014-09-30       INC144 COM Dignity CA SEIU-United Long Term Care Workers Local 6434       Los Angeles CA 90057       2014-09-30 00:00:00 55000 1.35726e+06 150                        
157 157 1364564 71 Lift Up Oakland - Yes on Measure FF - for better wages, healthy families and a healthy economy sponsored by labor and community organizations 68 BMC 2014-09-30       INC143 OTH International Brotherhood of Teamsters       Washington DC 20001       2014-09-29 00:00:00 5000                          
192 192 1364564 71 Lift Up Oakland - Yes on Measure FF - for better wages, healthy families and a healthy economy sponsored by labor and community organizations 68 BMC 2014-09-19       NON140 COM Guillen & Campbell Washington for City Council 2014, sponsored committee of the Alameda Labor Council, AFL-CIO Unity PAC to Elect     Oakland CA 94621       2014-09-18 00:00:00 1215 1.29419e+06 147                        
198 198 1364564 71 Lift Up Oakland - Yes on Measure FF - for better wages, healthy families and a healthy economy sponsored by labor and community organizations 68 BMC 2014-09-17       INC139 COM Service Employees International Union Local 1021 Issues PAC       Oakland CA 94609       2014-09-16 00:00:00 20000 1.29695e+06 148                        
202 202 1364564 71 Lift Up Oakland - Yes on Measure FF - for better wages, healthy families and a healthy economy sponsored by labor and community organizations 68 BMC 2014-09-12       INC137 OTH Arizmendi Cooperative Inc.       Oakland CA 94610       2014-09-12 00:00:00 1000                          
206 206 1364564 71 Lift Up Oakland for better wages, healthy families and a healthy economy sponsored by labor and community organizations 71 BMC 2014-08-25       INC122 IND Silberstein Stephen M.     Belvedere CA 94920   Retired   2014-08-25 00:00:00 25000                          

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