ie_reports_24_hours

FPPC Form 496

Data source: 496

48 rows where filer_id = 253 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, amount, expenditure_date, expenditure_description, candidate_last_name, office_jurisdiction, district_number, report_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 amount expenditure_date expenditure_description memo_reference_number ballot_measure_name ballot_measure_number ballot_measure_jurisdiction support_or_oppose candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number
1341 1341 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-12-17       PDT264 8820.46 2024-10-18 Mailer PDT:S496:264       S Rowena Brown         City of Oakland  
1343 1343 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-12-17       PDT265 8820.46 2024-10-18 Mailer PDT:S496:265       S Zac Unger         City of Oakland 1
1344 1344 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-12-17       PDT266 8820.46 2024-10-18 Mailer PDT:S496:266       S Carroll Fife         City of Oakland 3
1345 1345 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-12-17       PDT267 8820.46 2024-10-18 Mailer PDT:S496:267       S Erin Armstrong         City of Oakland 5
1346 1346 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-12-17       PDT269 8820.46 2024-10-18 Mailer PDT:S496:269       S Rachel Latta       Board Member Oakland USD 1
1347 1347 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-12-17       PDT270 8820.46 2024-10-18 Mailer PDT:S496:270       S VanCedric Williams       Board Member Oakland USD 3
1348 1348 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-12-17       PDT271 8820.46 2024-10-18 Mailer PDT:S496:271       S Sasha Ritzie-Hernandez       Board Member Oakland USD 5
1349 1349 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-12-17       PDT272 8820.46 2024-10-18 Mailer PDT:S496:272       S Ryan Richardson         City of Oakland  
1350 1350 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-12-17       PDT275 8820.44 2024-10-18 Mailer PDT:S496:275 Authorizes Parcel and Parking Taxes to Fund Public Safety and Violence Prevention NN City of Oakland S              
1342 1342 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-11-05       PDT264 7456.82 2024-10-18 Mailer PDT:S496:264       S Rowena Brown         City of Oakland  
1355 1355 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-11-05       PDT304 5000 2024-10-25 Text Messages PDT:S496:304       S Ryan Richardson         City of Oakland  
1539 1539 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-26       PDT304 3300 2024-10-25 Text Messages (estimate) PDT:S496:304       S Ryan Richardson         City of Oakland  
1571 1571 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-23       PDT297 5226.66 2024-10-22 Mailer PDT:S496:297       S Carroll Fife         City of Oakland 3
1572 1572 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-23       PDT294 2960 2024-10-22 Mailer PDT:S496:294       S Erin Armstrong         City of Oakland 5
1573 1573 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-23       PDT293 2960 2024-10-22 Mailer PDT:S496:293       S Rowena Brown         City of Oakland  
1574 1574 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-23       PDT296 5226.67 2024-10-22 Mailer PDT:S496:296       S Rowena Brown         City of Oakland  
1575 1575 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-23       PDT292 2960 2024-10-22 Mailer PDT:S496:292       S Ryan Richardson         City of Oakland  
1576 1576 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-23       PDT295 5226.67 2024-10-22 Mailer PDT:S496:295       S Ryan Richardson         City of Oakland  
1577 1577 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-22       PDT288 1875 2024-10-20 Text Messages PDT:S496:288       S Iris Merriouns         City of Oakland 7
1578 1578 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-22       PDT287 1875 2024-10-20 Text Messages PDT:S496:287       S Erin Armstrong         City of Oakland 5
1579 1579 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-22       PDT286 1875 2024-10-20 Text Messages PDT:S496:286       S Carroll Fife         City of Oakland 3
1594 1594 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-19       PDT275 7456.8 2024-10-18 Mailer PDT:S496:275 Authorizes Parcel and Parking Taxes to Fund Public Safety and Violence Prevention NN Alameda County S              
1595 1595 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-19       PDT272 7456.82 2024-10-18 Mailer PDT:S496:272       S Ryan Richardson         City of Oakland  
1596 1596 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-19       PDT271 7456.82 2024-10-18 Mailer PDT:S496:271       S Sasha Ritzie-Hernandez       Board Member Oakland USD 5
1597 1597 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-19       PDT270 7456.82 2024-10-18 Mailer PDT:S496:270       S VanCedric Williams       Board Member Oakland USD 3
1598 1598 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-19       PDT269 7456.82 2024-10-18 Mailer PDT:S496:269       S Rachel Latta       Board Member Oakland USD 1
1599 1599 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-19       PDT267 7456.82 2024-10-18 Mailer PDT:S496:267       S Erin Armstrong         City of Oakland 5
1600 1600 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-19       PDT266 7456.82 2024-10-18 Mailer PDT:S496:266       S Carroll Fife         City of Oakland 3
1601 1601 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-19       PDT265 7456.82 2024-10-18 Mailer PDT:S496:265       S Zac Unger         City of Oakland 1
1602 1602 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-19       PDT264 7456.82 2024-10-18 Mailer PDT:S496:264       S Rowena Brown         City of Oakland  
1613 1613 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-17       PDT250 4717.5 2024-10-16 Mailer PDT:S496:250       S Iris Merriouns         City of Oakland 7
1614 1614 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-17       PDT248 4440 2024-10-16 Mailer PDT:S496:248       S Erin Armstrong         City of Oakland 5
1615 1615 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-17       PDT244 9765 2024-10-16 Mailer PDT:S496:244       S Zac Unger         City of Oakland 1
1616 1616 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-17       PDT246 7840 2024-10-16 Mailer PDT:S496:246       S Carroll Fife         City of Oakland 3
1617 1617 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-17       PDT243 9765 2024-10-16 Mailer PDT:S496:243       S Rowena Brown         City of Oakland  
1618 1618 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-17       PDT245 7840 2024-10-16 Mailer PDT:S496:245       S Rowena Brown         City of Oakland  
1619 1619 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-17       PDT247 4440 2024-10-16 Mailer PDT:S496:247       S Rowena Brown         City of Oakland  
1620 1620 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-17       PDT249 4717.5 2024-10-16 Mailer PDT:S496:249       S Rowena Brown         City of Oakland  
1326 1326 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-15       PDT217 19681.8 2024-10-14 Digital Ads PDT:S496:217       S Erin Armstrong         City of Oakland 5
1327 1327 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-15       PDT218 26102.13 2024-10-14 Digital Ads PDT:S496:218       S Carroll Fife         City of Oakland 3
1641 1641 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-12       PDT218 26102.13 2024-10-11 Digital Ads PDT:S496:218       S Carroll Fife         City of Oakland 3
1642 1642 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-12       PDT217 19681.8 2024-10-11 Digital Ads PDT:S496:217       S Erin Armstrong         City of Oakland 5
1645 1645 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2024-10-10       PDT197 80750 2024-10-10 Mailer PDT:S496:197       S Rowena Brown         City of Oakland  
1301 1301 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2023-11-01       PDT160 7900 2023-10-31 Mailer PDT:S496:160       S Sasha Ritzie-Hernandez       Board Member Oakland USD 5.0
1308 1308 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2023-10-27       PDT159 7900 2023-10-27 Mailer PDT:S496:159       S Sasha Ritzie-Hernandez       Board Member Oakland USD 5.0
1309 1309 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2023-10-24       PDT158 7900 2023-10-24 Mailer PDT:S496:158       S Sasha Ritzie-Hernandez       Board Member Oakland USD 5.0
692 692 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2020-10-23       EDT46 16311.28 2020-10-22 Mailer EDT:S496:46       S Dan Kalb         City of Oakland 1
716 716 1433122 253 California Workers' Justice Coalition sponsored by Service Employees International Union Local 1021 325 RCP 2020-10-15       EDT7 16386.49 2020-10-15 Mailer EDT:S496:7       S Dan Kalb         City of Oakland 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ie_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,
  "amount" NUMERIC,
  "expenditure_date" TEXT,
  "expenditure_description" TEXT,
  "memo_reference_number" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "support_or_oppose" TEXT,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id));
CREATE INDEX ["ie_reports_24_hours_filer_id"] ON [ie_reports_24_hours]("filer_id");
CREATE INDEX ["ie_reports_24_hours_filer_name"] ON [ie_reports_24_hours]("filer_name");