expenditure_summaries

FPPC Form 460, Schedule D

Data source: D_Expenditure

69 rows where filer_id = 123 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_zipcode, year_to_date, expenditure_type, expenditure_description, ballot_measure_name, ballot_measure_jurisdiction, 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
1024 1024 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2017-01-30 2016-10-23 2016-12-31   eixfh88RdgPn COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-27 2771.39 156161.96 IKD Use of existing staff time to support: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1025 1025 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2017-01-30 2016-10-23 2016-12-31   7KsZuLed3RIR COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-26 46.34 156161.96 IKD Food and supplies contributed to: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1026 1026 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2017-01-30 2016-10-23 2016-12-31   drABoiO9hZYN COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-26 468 156161.96 IKD Use of existing phone lines to support: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1027 1027 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2017-01-30 2016-10-23 2016-12-31   gK5zcKvA9FRq COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-11-07 742.5 156161.96 IKD Use of existing phone lines to support: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1028 1028 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2017-01-30 2016-10-23 2016-12-31   w9CJ8RsOZ3wv COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-11-03 53.18 156161.96 IKD unitemized receipts for postage and printing                   City of Oakland Renters Upgrade Act   City of Oakland S  
1029 1029 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2017-01-30 2016-10-23 2016-12-31   wnK7LQ6ynlcR COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-11-07 450.96 156161.96 IKD Food and supplies in support of: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1030 1030 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2017-01-30 2016-10-23 2016-12-31   YaofcKkQZK5V COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-11-12 1990.75 156161.96 IKD Use of existing staff resources to support Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1031 1031 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2017-01-30 2016-10-23 2016-12-31   mAEEWidbhmry COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-12-09 178 156161.96 IKD Use of Nationbuilder website to support Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1032 1032 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2017-01-30 2016-10-23 2016-12-31   pqYUpJuGt2p3 COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-11-17 94.01 156161.96 IKD Use of supplies purchased to support Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1124 1124 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 UDPBvxnnfXfV COM Committee for Yes on V       Mountain View CA 94042 2016-10-14 5000 5000 MON                     The Community Stabilization and Fair Rent Act V City of Mountain View S  
1125 1125 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 GQ734nKw8X3v COM San Mateo Residents for Community Stability       San Mateo CA 94402 2016-10-14 6500 6500 MON                     San Mateo Community Preservation and Fair Rent Charter Amendment Q San Mateo S  
1126 1126 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 sFkNPgTuWKkW COM Burlingame Advocates for Renters Protections       Burlingame CA 94010 2016-10-14 2000 2000 MON                     Rent Stabilization Initiative R City of Burlingame S  
1127 1127 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 Z4MuKXUt8Sw4 COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-09-27 3606.43 149366.83 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1128 1128 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 qeaVrTKG2UEA COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-05 135 149366.83 IKD Use of CJJC phone lines for phone banking                   City of Oakland Renters Upgrade Act   City of Oakland S  
1129 1129 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 isexDuExp89l COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-12 3551.65 149366.83 IKD Use of existing resources of staff time for: Committed to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1130 1130 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 YyQo1Whe6OTH COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-13 126.83 149366.83 IKD Materials and food for volunteers                   City of Oakland Renters Upgrade Act   City of Oakland S  
1131 1131 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 seEKRiwN99og COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-13 153 149366.83 IKD Use of existing resources of phone lines                   City of Oakland Renters Upgrade Act   City of Oakland S  
1132 1132 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 YUjTBhfrjavM COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-09 89 149366.83 IKD contributed web platform via NationBuilder                   City of Oakland Renters Upgrade Act   City of Oakland S  
1133 1133 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 MciUcGNHz5hk COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-21 280.34 149366.83 IKD Food and materials to support Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1134 1134 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-26 2016-09-25 2016-10-22 2016-11-08 ctk2jVFAnhP6 COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-10-19 621 149366.83 IKD Use of existing phone lines to support Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
741 741 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-05 2016-07-01 2016-09-24 2016-11-08 OgSkVRBY4uzb COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-09-08 59000 140803.58 MON                     City of Oakland Renters Upgrade Act   City of Oakland S  
742 742 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-05 2016-07-01 2016-09-24 2016-11-08 PR5DWtqxVOGg COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-09-23 10000 140803.58 MON                     City of Oakland Renters Upgrade Act   City of Oakland S  
743 743 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-05 2016-07-01 2016-09-24 2016-11-08 wttvAC3PgoiS COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-08-15 519.47 140803.58 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
744 744 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-05 2016-07-01 2016-09-24 2016-11-08 dLl5lycdDcRJ COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-08-29 1020.82 140803.58 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
745 745 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-05 2016-07-01 2016-09-24 2016-11-08 B1llbgmqbmr6 COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-07-09 89 140803.58 IKD Use of web platform in support of: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
746 746 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-05 2016-07-01 2016-09-24 2016-11-08 4v686RtkQxTl COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-08-09 89 140803.58 IKD Use of web platform in support of: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
747 747 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-05 2016-07-01 2016-09-24 2016-11-08 fZgkOvHlbIDv COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-09-09 89 140803.58 IKD Use of web platform in support of: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
748 748 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-05 2016-07-01 2016-09-24 2016-11-08 EJR21dFk5lrw COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-07-13 640.71 140803.58 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
749 749 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-10-05 2016-07-01 2016-09-24 2016-11-08 kzrie4KNs2Dn COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-07-29 355.95 140803.58 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1188 1188 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 OgSkVRBY4uzb COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-09-08 59000 141948.53 MON                     City of Oakland Renters Upgrade Act   City of Oakland S  
1189 1189 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 PR5DWtqxVOGg COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-09-23 10000 141948.53 MON                     City of Oakland Renters Upgrade Act   City of Oakland S  
1190 1190 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 wttvAC3PgoiS COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-08-15 519.47 141948.53 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1191 1191 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 dLl5lycdDcRJ COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-08-29 1020.82 141948.53 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1192 1192 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 B1llbgmqbmr6 COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-07-09 89 141948.53 IKD Use of web platform in support of: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1193 1193 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 4v686RtkQxTl COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-08-09 89 141948.53 IKD Use of web platform in support of: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1194 1194 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 fZgkOvHlbIDv COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-09-09 89 141948.53 IKD Use of web platform in support of: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1195 1195 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 eQGfEpw5ks8q COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-09-13 1144.95 141948.53 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1196 1196 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 EJR21dFk5lrw COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-07-13 640.71 141948.53 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1197 1197 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-09-29 2016-07-01 2016-09-24 2016-11-08 kzrie4KNs2Dn COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-07-29 355.95 141948.53 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
708 708 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   I8R3ye8eThoi COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-06 19700 68999.63 MON Donation                   City of Oakland Renters Upgrade Act   City of Oakland S  
709 709 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   gQQwyOk2a9GB COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-03-15 1161.04 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
710 710 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   ISaHQe4nd5VE COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-03-31 1595.13 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
711 711 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   cnPl4v5gL6ej COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-15 2339.21 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
712 712 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   dDpvoJzhYCN2 COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-29 1814.22 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
713 713 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   BkYdgWbjXRTZ COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-05-15 2011.39 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
714 714 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   MHzWPPcFu8nc COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-05-31 2112.34 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
715 715 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   lXba4WedXood COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-06-15 937.01 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
716 716 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   NmAaU46O2nUe COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-06-30 1345.38 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
717 717 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   gdq9dEjBX4Mc COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-02 105 68999.63 IKD Use of paid translation services for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
718 718 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   k4ePzlHai3rx COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-15 249.96 68999.63 IKD Use of purchased meeting supplies for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
719 719 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   wb5ilBiefIIX COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-15 212.89 68999.63 IKD Use of purchased food supplies for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
720 720 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   xWSq1SEljBjM COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-03-03 200 68999.63 IKD Fee to file ballot initiative, on behalf of Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
721 721 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   PCj91xPpb3Sn COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-06-30 216.06 68999.63 IKD Unitemized contributions of materials, food and local transportation                   City of Oakland Renters Upgrade Act   City of Oakland S  
722 722 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-08-12 2016-01-01 2016-06-30   mOB3ZtXwQm61 COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-19 35000 68999.63 MON                     City of Oakland Renters Upgrade Act   City of Oakland S  
1227 1227 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 I8R3ye8eThoi COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-06 19700 68999.63 MON Donation                   City of Oakland Renters Upgrade Act   City of Oakland S  
1228 1228 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 gQQwyOk2a9GB COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-03-15 1161.04 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1229 1229 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 ISaHQe4nd5VE COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-03-31 1595.13 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1230 1230 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 cnPl4v5gL6ej COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-15 2339.21 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1231 1231 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 dDpvoJzhYCN2 COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-29 1814.22 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1232 1232 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 BkYdgWbjXRTZ COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-05-15 2011.39 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1233 1233 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 MHzWPPcFu8nc COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-05-31 2112.34 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1234 1234 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 lXba4WedXood COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-06-15 937.01 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1235 1235 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 NmAaU46O2nUe COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-06-30 1345.38 68999.63 IKD Use of existing resources of staff time for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1236 1236 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 gdq9dEjBX4Mc COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-02 105 68999.63 IKD Use of paid translation services for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1237 1237 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 k4ePzlHai3rx COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-15 249.96 68999.63 IKD Use of purchased meeting supplies for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1238 1238 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 wb5ilBiefIIX COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-15 212.89 68999.63 IKD Use of purchased food supplies for: Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1239 1239 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 xWSq1SEljBjM COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-03-03 200 68999.63 IKD Fee to file ballot initiative, on behalf of Committee to Protect Oakland Renters                   City of Oakland Renters Upgrade Act   City of Oakland S  
1240 1240 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 PCj91xPpb3Sn COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-06-30 216.06 68999.63 IKD Unitemized contributions of materials, food and local transportation                   City of Oakland Renters Upgrade Act   City of Oakland S  
1241 1241 1385949 123 Causa Justa :: Just Cause (nonprofit 501(c)(3)) 141 BMC 2016-07-27 2016-01-01 2016-06-30 2016-11-08 mOB3ZtXwQm61 COM Committee to Protect Oakland Renters       Sacramento CA 95814 2016-04-19 35000 68999.63 MON                     City of Oakland Renters Upgrade Act   City of Oakland S  

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