ie_reports_24_hours

FPPC Form 496

Data source: 496

48 rows where filer_name = 333 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_sought, 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
1007 1007 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       PDT1 157.64 2022-05-31 Digital ad design (actual cost) PDT:S496:1       S Pamela Price         Alameda  
1008 1008 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       EDT28 210 2022-05-31 Digital ads (estimated) EDT:S496:28       S Pamela Price         Alameda  
1009 1009 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       PDT2 157.64 2022-05-31 Digital ad design (actual cost) PDT:S496:2       S Alysse Castro       Superintendent of Schools Alameda  
1010 1010 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       EDT27 210 2022-05-31 Digital ads (estimated) EDT:S496:27       S Alysse Castro       Superintendent of Schools Alameda  
1011 1011 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       PDT3 157.64 2022-05-31 Digital ad design (actual cost) PDT:S496:3       S Rebecca Kaplan       Board of Supervisor Alameda  
1012 1012 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       EDT26 210 2022-05-31 Digital ads (estimated) EDT:S496:26       S Rebecca Kaplan       Board of Supervisor Alameda  
1013 1013 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       PDT4 157.64 2022-05-31 Digital ad design (actual cost) PDT:S496:4       S Jennifer Esteen           20.0
1014 1014 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       EDT29 210 2022-05-31 Digital ads (estimated) EDT:S496:29       S Jennifer Esteen           20.0
1015 1015 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       PDT7 120.1 2022-05-31 Digital ad design (actual cost) PDT:S496:7       S Liz Oretega-Toro           20.0
1016 1016 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-03       EDT30 160 2022-05-31 Digital ads (estimated) EDT:S496:30       S Liz Oretega-Toro           20.0
1270 1270 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT30 160 2022-05-31 Digital ads (estimated) EDT:S496:30       S Liz Oretega-Toro           20.0
1271 1271 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT33 80 2022-05-31 Digital ads design (estimated) EDT:S496:33       S Liz Oretega-Toro           20.0
1272 1272 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT29 210 2022-05-31 Digital ads (estimated) EDT:S496:29       S Jennifer Esteen           20.0
1273 1273 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT36 105 2022-05-31 Digital ads design (estimated) EDT:S496:36       S Jennifer Esteen           20.0
1274 1274 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT26 210 2022-05-31 Digital ads (estimated) EDT:S496:26       S Rebecca Kaplan       Board of Supervisor Alameda  
1275 1275 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT35 105 2022-05-31 Digital ads design (estimated) EDT:S496:35       S Rebecca Kaplan       Board of Supervisor Alameda  
1276 1276 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT28 210 2022-05-31 Digital ads (estimated) EDT:S496:28       S Pamela Price         Alameda  
1277 1277 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT31 105 2022-05-31 Digital ads design (estimated) EDT:S496:31       S Pamela Price         Alameda  
1278 1278 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT27 210 2022-05-31 Digital ads (estimated) EDT:S496:27       S Alysse Castro       Superintendent of Schools Alameda  
1279 1279 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-06-01       EDT34 105 2022-05-31 Digital ads design (estimated) EDT:S496:34       S Alysse Castro       Superintendent of Schools Alameda  
994 994 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT5 5943.92 2022-05-04 Voter guide printing (actual cost) EDT:S496:5       S Alysse Castro       Superintendent of Schools    
995 995 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT20 617.1 2022-05-04 Actual cost of voter guide design and mailing list EDT:S496:20       S Alysse Castro       Superintendent of Schools    
996 996 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT2 5943.91 2022-05-04 Voter guide (actual cost) EDT:S496:2       S Jennifer Esteen           20.0
997 997 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT21 617.1 2022-05-04 Actual cost of voter guide design and mailing list EDT:S496:21       S Jennifer Esteen           20.0
998 998 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT22 470.17 2022-05-04 Actual cost of voter guide design and mailing list EDT:S496:22       S Liz Oretega-Toro           20.0
999 999 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT3 4528.69 2022-05-05 Voter guide printing (actual cost) EDT:S496:3       S Liz Oretega-Toro           20.0
1000 1000 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT1 5943.91 2022-05-04 Voter guide printing (actual cost) EDT:S496:1       S Pamela Price            
1001 1001 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT18 617.1 2022-05-04 Actual cost of voter guide design and mailing list EDT:S496:18       S Pamela Price            
1002 1002 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT4 5943.91 2022-05-04 Voter guide printing (actual cost) EDT:S496:4       S Rebecca Kaplan       Board of Supervisor    
1003 1003 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-05-12       EDT19 617.1 2022-05-04 Actual cost of voter guide design and mailing list EDT:S496:19       S Rebecca Kaplan       Board of Supervisor    
1004 1004 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT4 5943.91 2022-04-28 Voter guide EDT:S496:4       S Rebecca Kaplan       Board of Supervisor    
1005 1005 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT8 336 2022-04-29 Estimate design cost EDT:S496:8       S Rebecca Kaplan       Board of Supervisor    
1006 1006 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT13 315 2022-04-29 Mailing list EDT:S496:13       S Rebecca Kaplan       Board of Supervisor    
1280 1280 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT4 5943.91 2022-04-28 Voter guide EDT:S496:4       S         Board of Supervisor    
1281 1281 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT8 336 2022-04-29 Estimate design cost EDT:S496:8       S         Board of Supervisor    
1282 1282 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT13 315 2022-04-29 Mailing list EDT:S496:13       S         Board of Supervisor    
1283 1283 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT1 5943.91 2022-04-28 Voter guide EDT:S496:1       S Pamela Price            
1284 1284 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT6 336 2022-04-29 Estimate design cost EDT:S496:6       S Pamela Price            
1285 1285 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT11 315 2022-04-29 Mailing list EDT:S496:11       S Pamela Price            
1286 1286 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT3 4528.69 2022-04-28 Voter guide EDT:S496:3       S Liz Oretega-Toro           20.0
1287 1287 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT10 256 2022-04-29 Estimate design cost EDT:S496:10       S Liz Oretega-Toro           20.0
1288 1288 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT15 240 2022-04-29 Mailing list EDT:S496:15       S Liz Oretega-Toro           20.0
1289 1289 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT2 5943.91 2022-04-28 Voter guide EDT:S496:2       S Jennifer Esteen           20.0
1290 1290 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT7 336 2022-04-29 Estimate design cost EDT:S496:7       S Jennifer Esteen           20.0
1291 1291 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT12 315 2022-04-29 Mailing list EDT:S496:12       S Jennifer Esteen           20.0
1292 1292 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT5 5943.92 2022-04-28 Voter guide EDT:S496:5       S         Superintendent of Schools    
1293 1293 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT9 336 2022-04-29 Estimate design cost EDT:S496:9       S         Superintendent of Schools    
1294 1294 1332115 37 Oakland Rising Committee Sponsored by Center for Empowered Politics 333 RCP 2022-04-29       EDT14 315 2022-04-29 Mailing list EDT:S496:14       S         Superintendent of Schools    

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