on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

71 rows where filer_id = 318 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, payee_last_name, payee_city, payee_state, payee_zipcode, expenditure_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
5982 5982 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-09-22 2024-10-19 2024-11-05 EDT16 OTH ACC Printers       Berkeley CA 94703 2024-10-11 347.29 14527.2 LIT                     Recall of District Attorney Pamela Price   Alameda County O  
5983 5983 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-09-22 2024-10-19 2024-11-05 EDT20 OTH ACC Printers       Berkeley CA 94703 2024-10-19 619.16 14527.2 CMP                     Recall of District Attorney Pamela Price   Alameda County O  
5984 5984 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-09-22 2024-10-19 2024-11-05 EDT15 OTH AdCreative.ai       Paris, le-de-France   75004 2024-09-30 279 0 WEB To Be Refunded                   Recall of District Attorney Pamela Price   Alameda County O  
5985 5985 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-09-22 2024-10-19 2024-11-05 EDT18 OTH AdCreative.ai       Paris, le-de-France   75004 2024-10-11 -279 0 WEB Refund                   Recall of District Attorney Pamela Price   Alameda County O  
5986 5986 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-09-22 2024-10-19 2024-11-05 EDT19 OTH Expedia       Seattle WA 98119 2024-10-11 301.79 301.79 TRC 10/1/24, Lodging While Attending Fundraiser, 1, Candidate                   Recall of District Attorney Pamela Price   Alameda County O  
5987 5987 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-09-22 2024-10-19 2024-11-05 EDT17 OTH Facebook       Menlo Park CA 94025 2024-10-11 1635.12 2537.42 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
5988 5988 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-09-22 2024-10-19 2024-11-05 PDT9 OTH Facebook       Menlo Park CA 94025 2024-10-19 902.3 2537.42 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
5989 5989 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-09-22 2024-10-19 2024-11-05 EDT14 OTH Political Data Intelligence       Long Beach CA 90806 2024-09-30 500 3500 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
5990 5990 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-09-22 2024-10-19 2024-11-05 EDT13 OTH United States Post Office       Oakland CA 94615 2024-09-30 37649.18 41152.37 POS                     Recall of District Attorney Pamela Price   Alameda County O  
6294 6294 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT13 OTH ACC Printers       Berkeley CA 94703 2024-10-30 1467.65 17342.11 CMP                     Recall of District Attorney Pamela Price   Alameda County O  
6295 6295 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT18 OTH Adobe       San Jose CA 95110 2024-12-31 119.88 119.88 OFC                     Recall of District Attorney Pamela Price   Alameda County O  
6296 6296 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT23 OTH Alameda Publishing Corp.       Oakland CA 94612 2024-10-25 2500 3750 PRT                     Recall of District Attorney Pamela Price   Alameda County O  
6297 6297 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT27 OTH Alameda Publishing Corp.       Oakland CA 94612 2024-10-25 1250 3750 PRT                     Recall of District Attorney Pamela Price   Alameda County O  
6298 6298 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT12 OTH Alpha Media       Portland OR 97204 2024-11-08 1960 1960 RAD                     Recall of District Attorney Pamela Price   Alameda County O  
6299 6299 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT26 OTH Facebook       Menlo Park CA 94025 2024-10-25 900 3684.81 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6300 6300 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT28 OTH Facebook       Menlo Park CA 94025 2024-10-25 47.2 3684.81 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6301 6301 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT32 OTH Facebook       Menlo Park CA 94025 2024-12-04 200.19 3684.81 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6302 6302 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT11 OTH Fiverr       New York NY 10013 2024-11-08 232.1 495.85 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6303 6303 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT31 OTH Fiverr       New York NY 10013 2024-12-04 263.75 495.85 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6304 6304 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT21 OTH Geoffrey's Inner Circle       Oakland CA 94612 2024-12-31 500 500 CVC                     Recall of District Attorney Pamela Price   Alameda County O  
6305 6305 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT14 OTH Google       Mountain View CA 94043 2024-10-30 275.64 657.42 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6306 6306 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT30 OTH Google       Mountain View CA 94043 2024-12-04 381.78 657.42 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6307 6307 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT15 OTH Jan Carlo Mes Productions       New York NY 10123 2024-11-08 411.9 411.9 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6308 6308 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT29 OTH KU Creatives       Sheridan WY 82801 2024-10-30 1600 1800 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6309 6309 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT25 OTH LH3 Luxury Transportation       Euclid OH 44123 2024-10-25 200 200   Transportation for Speaker                   Recall of District Attorney Pamela Price   Alameda County O  
6310 6310 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT17 OTH NationBuilder       Los Angeles CA 90071 2024-12-10 1980 1980 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6311 6311 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT10 OTH Shift Technologies       San Francisco CA 94114 2024-10-22 468 458   To Be Refunded                   Recall of District Attorney Pamela Price   Alameda County O  
6312 6312 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT22 OTH Shift Technologies       San Francisco CA 94114 2024-10-25 -468 458   Refund                   Recall of District Attorney Pamela Price   Alameda County O  
6313 6313 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT16 OTH Shift Technologies       San Francisco CA 94114 2024-12-04 458 458 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6314 6314 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT33 OTH The UPS Store       Hayward CA 94541 2024-12-04 123 410 OFC PO Box Fee                   Recall of District Attorney Pamela Price   Alameda County O  
6315 6315 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT19 OTH Upwork.com       San Francisco CA 94111 2024-12-31 375.49 2131.11 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6316 6316 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   PDT20 OTH Upwork.com       San Francisco CA 94111 2024-12-31 1269.99 2131.11 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6317 6317 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT24 OTH ACC Printers       Berkeley CA 94703 2024-11-07 1347.26 17342.11 CMP                     Recall of District Attorney Pamela Price   Alameda County O  
6318 6318 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2025-01-29 2024-10-20 2024-12-31   EDT21 OTH Southwest Airlines       Dallas TX 75235 2024-10-25 640.96 1062.92 TRS Airfare for Fundraiser, 1                   Recall of District Attorney Pamela Price   Alameda County O  
5947 5947 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-07-01 2024-09-21 2024-11-05 EDT10 OTH Alameda County Registrar of Voters       Oakland CA 94612 2024-09-04 360 28150 OFC                     Recall of District Attorney Pamela Price   Alameda County O  
5948 5948 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-07-01 2024-09-21 2024-11-05 PDT7 OTH KU Creatives       Sheridan WY 82801 2024-09-09 200 200 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
5949 5949 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-07-01 2024-09-21 2024-11-05 EDT9 OTH Political Data Intelligence       Long Beach CA 90806 2024-09-04 500 3000 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
5950 5950 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-07-01 2024-09-21 2024-11-05 PDT6 OTH Political Data Intelligence       Long Beach CA 90806 2024-09-09 500 3000 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
5951 5951 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-07-01 2024-09-21 2024-11-05 PDT5 OTH Political Data Intelligence       Long Beach CA 90806 2024-09-21 2000 3000 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
5952 5952 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-07-01 2024-09-21 2024-11-05 PDT8 OTH Southwest Airlines       Dallas TX 75235 2024-09-21 421.96 421.96 TRC 10/1/24, Airfare to Attend Fundraiser, 1, Candidate                   Recall of District Attorney Pamela Price   Alameda County O  
5953 5953 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-07-01 2024-09-21 2024-11-05 EDT11 OTH United States Post Office       Oakland CA 94615 2024-09-19 2622.69 3503.19 POS                     Recall of District Attorney Pamela Price   Alameda County O  
5954 5954 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-07-01 2024-09-21 2024-11-05 EDT12 OTH United States Post Office       Oakland CA 94615 2024-09-19 880.5 3503.19 POS                     Recall of District Attorney Pamela Price   Alameda County O  
6479 6479 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-09-22 2024-10-19 2024-11-05 EDT16 OTH ACC Printers       Berkeley CA 94703 2024-10-11 347.29 14527.2 LIT                     Recall of District Attorney Pamela Price   Alameda County O  
6480 6480 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-09-22 2024-10-19 2024-11-05 EDT20 OTH ACC Printers       Berkeley CA 94703 2024-10-19 619.16 14527.2 CMP                     Recall of District Attorney Pamela Price   Alameda County O  
6481 6481 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-09-22 2024-10-19 2024-11-05 EDT15 OTH AdCreative.ai       Paris, le-de-France   75004 2024-09-30 279 0 WEB To Be Refunded                   Recall of District Attorney Pamela Price   Alameda County O  
6482 6482 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-09-22 2024-10-19 2024-11-05 EDT18 OTH AdCreative.ai       Paris, le-de-France   75004 2024-10-11 -279 0 WEB Refund                   Recall of District Attorney Pamela Price   Alameda County O  
6483 6483 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-09-22 2024-10-19 2024-11-05 EDT19 OTH Expedia       Seattle WA 98119 2024-10-11 301.79 301.79 TRC 10/1/24, Lodging While Attending Fundraiser, 1, Candidate                   Recall of District Attorney Pamela Price   Alameda County O  
6484 6484 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-09-22 2024-10-19 2024-11-05 EDT17 OTH Facebook       Menlo Park CA 94025 2024-10-11 1635.12 2537.42 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6485 6485 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-09-22 2024-10-19 2024-11-05 PDT9 OTH Facebook       Menlo Park CA 94025 2024-10-19 902.3 2537.42 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6486 6486 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-09-22 2024-10-19 2024-11-05 EDT14 OTH Political Data Intelligence       Long Beach CA 90806 2024-09-30 500 3500 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6487 6487 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-10-24 2024-09-22 2024-10-19 2024-11-05 EDT13 OTH United States Post Office       Oakland CA 94615 2024-09-30 37649.18 41152.37 POS                     Recall of District Attorney Pamela Price   Alameda County O  
6535 6535 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-09-26 2024-07-01 2024-09-21 2024-11-05 EDT10 OTH Alameda County Registrar of Voters       Oakland CA 94612 2024-09-04 360 28150 OFC                     Recall of District Attorney Pamela Price   Alameda County O  
6536 6536 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-09-26 2024-07-01 2024-09-21 2024-11-05 PDT7 OTH KU Creatives       Sheridan WY 82801 2024-09-09 200 200 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6537 6537 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-09-26 2024-07-01 2024-09-21 2024-11-05 EDT9 OTH Political Data Intelligence       Long Beach CA 90806 2024-09-04 500 3000 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6538 6538 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-09-26 2024-07-01 2024-09-21 2024-11-05 PDT6 OTH Political Data Intelligence       Long Beach CA 90806 2024-09-09 500 3000 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6539 6539 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-09-26 2024-07-01 2024-09-21 2024-11-05 PDT5 OTH Political Data Intelligence       Long Beach CA 90806 2024-09-21 2000 3000 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6540 6540 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-09-26 2024-07-01 2024-09-21 2024-11-05 PDT8 OTH Southwest Airlines       Dallas TX 75235 2024-09-21 421.96 421.96 TRC 10/1/24, Airfare to Attend Fundraiser, 1, Candidate                   Recall of District Attorney Pamela Price   Alameda County O  
6541 6541 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-09-26 2024-07-01 2024-09-21 2024-11-05 EDT11 OTH United States Post Office       Oakland CA 94615 2024-09-19 2622.69 3503.19 POS                     Recall of District Attorney Pamela Price   Alameda County O  
6542 6542 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-09-26 2024-07-01 2024-09-21 2024-11-05 EDT12 OTH United States Post Office       Oakland CA 94615 2024-09-19 880.5 3503.19 POS                     Recall of District Attorney Pamela Price   Alameda County O  
6604 6604 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-07-25 2024-04-01 2024-06-30   PDT3 OTH ImageCube       Sylmar CA 91342 2024-06-30 1702.85 1702.85 LIT                     Recall of District Attorney Pamela Price   Alameda County O  
6605 6605 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-07-25 2024-04-01 2024-06-30   EDT8 OTH Payoneer.com       New York NY 10007 2024-06-30 736.25 736.25 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6606 6606 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-07-25 2024-04-01 2024-06-30   PDT4 OTH ScanArt       Emeryville CA 94608 2024-06-30 382.14 1285.8 LIT                     Recall of District Attorney Pamela Price   Alameda County O  
6607 6607 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-07-25 2024-04-01 2024-06-30   EDT7 OTH The UPS Store       Hayward CA 94541 2024-06-30 287 287 OFC                     Recall of District Attorney Pamela Price   Alameda County O  
6608 6608 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-07-25 2024-04-01 2024-06-30   EDT6 OTH Upwork.com       San Francisco CA 94111 2024-05-04 315 485.63 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6609 6609 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-07-25 2024-04-01 2024-06-30   PDT2 OTH Upwork.com       San Francisco CA 94111 2024-06-30 170.63 485.63 WEB                     Recall of District Attorney Pamela Price   Alameda County O  
6672 6672 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-04-30 2024-01-01 2024-03-31   EDT4 OTH Audacy Operations Inc       Philadelphia   19103 2024-02-07 5094.9 5094.9 RAD                     Recall of District Attorney Pamela Price   Alameda County O  
6673 6673 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-04-30 2024-01-01 2024-03-31   EDT5 OTH ScanArt       Emeryville CA 94608 2024-03-18 903.66 903.66 LIT                     Recall of District Attorney Pamela Price   Alameda County O  
5742 5742 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-01-31 2023-10-01 2023-12-31   EDT1 OTH Fluid510       Alameda CA 94501 2023-11-08 1161.5 1810.7 FND 11/16/23, Fundraiser, 100, Candidate                   Recall of District Attorney Pamela Price   Alameda County O  
5743 5743 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-01-31 2023-10-01 2023-12-31   EDT2 OTH Fluid510       Alameda CA 94501 2023-11-22 649.2 1810.7 FND 11/16/23, Fundraiser, 100, Candidate                   Recall of District Attorney Pamela Price   Alameda County O  
5744 5744 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-01-31 2023-10-01 2023-12-31   PDT1 OTH ScanArt       Emeryville CA 94608 2023-12-31 581.44 2227.89 LIT                     Recall of District Attorney Pamela Price   Alameda County O  
5745 5745 1462695 318 Protect the Win for Public Safety, Oppose the Recall of DA Price (Price Ballot Measure Committee) 435 BMC 2024-01-31 2023-10-01 2023-12-31   EDT3 OTH ScanArt       Emeryville CA 94608 2023-12-28 1646.45 2227.89 LIT                     Recall of District Attorney Pamela Price   Alameda County O  

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