D_Expenditure

3,564 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Report_Num, Committee_Type, Elect_Date, Entity_Cd, Payee_State, Expn_ChkNo, Expn_Code, Tres_NamL, Tres_NamF, Office_Cd, Juris_Cd, Off_S_H_Cd, Sup_Opp_Cd, Rpt_Date (date), From_Date (date), Thru_Date (date), Elect_Date (date), Expn_Date (date)

Link rowid ▼ Filer_ID Filer_NamL Report_Num Committee_Type Rpt_Date From_Date Thru_Date Elect_Date tblCover_Office_Cd tblCover_Offic_Dscr Rec_Type Form_Type Tran_ID Entity_Cd Payee_NamL Payee_NamF Payee_NamT Payee_NamS Payee_Adr1 Payee_Adr2 Payee_City Payee_State Payee_Zip4 Expn_Date Amount Cum_YTD Expn_ChkNo Expn_Code Expn_Dscr Agent_NamL Agent_NamF Agent_NamT Agent_NamS Cmte_ID Tres_NamL Tres_NamF Tres_NamT Tres_NamS Tres_Adr1 Tres_Adr2 Tres_City Tres_ST Tres_ZIP4 Cand_NamL Cand_NamF Cand_NamT Cand_NamS Office_Cd Offic_Dscr Juris_Cd Juris_Dscr Dist_No Off_S_H_Cd Bal_Name Bal_Num Bal_Juris Sup_Opp_Cd Memo_Code Memo_RefNo BakRef_TID G_From_E_F XRef_SchNm XRef_Match
1 1 1342185 Barbara Parker for Oakland City Attorney 2012 1 CTL 2013-07-30 00:00:00 2012-07-01 00:00:00 2012-12-31 00:00:00       EXPN D WgFaqC4rlCIC COM Oakland United Democratic Campaign           Oakland CA 94612.0 2012-09-06 00:00:00 250.0 250.0   MON Donation                                                       S            
2 2 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D PDT20 COM Amy Lemley for City Council 2012           Oakland CA 94618.0 2012-11-09 00:00:00 2000.0 15307.75   IND Design of mailer in support of Amy Lemley for Oakland City Council         1346362.0                   Amy Lemley       CCM   OTH Oakland, CA 1         S            
3 3 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT98 COM Barbara Parker for Oakland City Attorney 2012           Oakland CA 94612.0 2012-10-29 00:00:00 8580.0 11245.42   IND Outdoor advertising in support of Barbara Parker for Oakland City Attorney 2012         1342185.0                   Barbara Parker       CAT   OTH City of Oakland           S            
4 4 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT99 COM Barbara Parker for Oakland City Attorney 2012           Oakland CA 94612.0 2012-10-29 00:00:00 1365.42 11245.42   IND Outdoor advertising in support of Barbara Parker for Oakland City Attorney 2012         1342185.0                   Barbara Parker       CAT   OTH City of Oakland           S            
5 5 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EXP1434 COM Committee to Elect Lynette McElhaney for City Council 2012           Oakland CA 94610.0 2012-11-20 00:00:00 600.0 1300.0   MON           1342416.0                   Lynette McElhaney       CCM   OTH Oakland, CA 3         S            
6 6 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EXP1430 COM Dan Kalb for City Council 2012           Oakland CA 94612.0 2012-11-20 00:00:00 1300.0 1300.0   MON           1343715.0                   Dan Kalb       CCM   OTH City of Oakland 1 H       S            
7 7 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EXP1432 COM Kaplan for Oakland City Council 2012           Oakland CA 94612.0 2012-11-20 00:00:00 600.0 1300.0   MON           1341827.0                   Rebecca Kaplan       CCM   OTH City of Oakland AL         S            
8 8 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EXP1431 COM Noel Gallo for Oakland City Council 2012           Oakland CA 94601.0 2012-11-20 00:00:00 1300.0 1300.0   MON           1345905.0                   Noel Gallo       CCM   OTH City of Oakland 3 H       S            
9 9 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT101 COM Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee           Oakland CA 94612.0 2012-12-15 00:00:00 1052.6 1102.6   IKD Accounting Services         1313157.0                   Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee       OTH Political Action Committee               S   EDT101        
10 10 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT102 COM Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee           Oakland CA 94612.0 2012-12-27 00:00:00 50.0 1102.6   IKD Annual Committee Registration Fee         1313157.0                   Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee       OTH Political Action Committee               S   EDT102        
11 11 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT12 COM Berkeley Measure U, 2012                 2012-10-24 00:00:00 12000.0 31000.0   IND Payment for appearance on slate mailer in opposition to City of Berkeley Measure U                                                 Initiative Ordinance Enacting New Requirements for the City Council and Rent Stabilization Board and Boards and Commissions Relating to Agendas and Meetings U City of Berkeley, CA O            
12 12 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EXP1708 COM Committee to Elect Lynette Gibson McElhaney for City Council 2012           Oakland CA 94610.0 2012-11-27 00:00:00 500.0 500.0   MON           1342416.0                   Lynette McElhaney       CCM   OTH Oakland, CA 3 S       S            
13 13 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EXP1383 COM Ignacio De La Fuente Committee           Oakland CA 94611.0 2012-10-22 00:00:00 1300.0 1300.0   MON           970650.0                   Ignacio De La Fuente       CCM   OTH City of Oakland, CA (Office Holder Acct) 5 H       S            
14 14 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT14 COM Jay James, 2012                 2012-11-02 00:00:00 2000.0 2737.59   IND Advertising in support of Jay James for Rent Stabilization Board Commissioner 2012                             Jay James       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
15 15 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT18 COM Jay James, 2012                 2012-11-02 00:00:00 487.59 2737.59   IND Advertising in support of Jay James for Rent Stabilization Board Commissioner 2012                             Jay James       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
16 16 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT13 COM Judy Hunt, 2012                 2012-11-02 00:00:00 2000.0 2737.58   IND Advertising in support of Judy Hunt for Rent Stabilization Board Commissioner                             Judy Hunt       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
17 17 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT17 COM Judy Hunt, 2012                 2012-11-02 00:00:00 487.58 2737.58   IND Advertising in support of Judy Hunt for Rent Stabilization Board Commissioner                             Judy Hunt       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
18 18 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT15 COM Kiran Shenoy, 2012                 2012-11-02 00:00:00 2000.0 2737.59   IND Advertising in support of Kiran Shenoy for Rent Stabilization Board Commissioner 2012                             Kiran Shenoy       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
19 19 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT19 COM Kiran Shenoy, 2012                 2012-11-02 00:00:00 487.59 2737.59   IND Advertising in support of Kiran Shenoy for Rent Stabilization Board Commissioner 2012                             Kiran Shenoy       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
20 20 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT16 COM Nicole Drake, 2012                 2012-11-02 00:00:00 2000.0 2737.59   IND Advertising in support of Nicole Drake for Rent Stabilization Board Commissioner 2012                             Nicole Drake       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
21 21 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-01-21 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       EXPN D EDT20 COM Nicole Drake, 2012                 2012-11-02 00:00:00 487.59 2737.59   IND Advertising in support of Nicole Drake for Rent Stabilization Board Commissioner 2012                             Nicole Drake       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
22 22 1284364 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 0 CTL 2013-01-31 00:00:00 2012-07-01 00:00:00 2012-12-31 00:00:00       EXPN D dfTFmTOb6Yjd COM East Bay Young Democrats           Oakland CA 94610.0 2012-12-21 00:00:00 100.0 100.0   MON Sponsorship of 4th Annual Gala                                                       S            
23 23 1342185 Barbara Parker for Oakland City Attorney 2012 0 CTL 2013-01-31 00:00:00 2012-07-01 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     EXPN D WgFaqC4rlCIC COM Oakland United Democratic Campaign           Oakland CA 94612.0 2012-09-06 00:00:00 250.0 250.0   MON Donation                                                       S            
24 24 943526 Oakland Police Officer's Association - Political Action Committee 0 RCP 2012-11-02 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00       EXPN D 12730241 IND             Oakland CA 94607.0 2012-10-10 00:00:00 1998.75 1998.75   IND Say NO to Mario brochure                             Juarez Mario     CCM   CIT   5         O            
25 25 943526 Oakland Police Officer's Association - Political Action Committee 0 RCP 2012-11-02 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00       EXPN D 12730239 IND             Oakland CA 94607.0 2012-10-19 00:00:00 2345.95 2345.95   IND No Kaplan brochure                             Kaplan Rebecca     CCM   CIT             O            
26 26 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-10-23 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D PDT18 COM Amy Lemley for City Council 2012           Oakland CA 94618.0 2012-10-19 00:00:00 5181.44 13307.75   IND Printing & mailing of a mailer in support of Amy Lemley for Oakland City Council,         1346362.0                   Amy Lemley       CCM   OTH Oakland, CA 1         S            
27 27 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-10-23 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D PDT19 COM Amy Lemley for City Council 2012           Oakland CA 94618.0 2012-10-19 00:00:00 6826.31 13307.75   IND Postage for a mailer in support of Amy Lemley for Oakland City Council, Dist. 1         1346362.0                   Amy Lemley       CCM   OTH Oakland, CA 1         S            
28 28 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D EXP1356 COM Barbara Parker for Oakland City Attorney 2012           Oakland CA 94610.0 2012-10-12 00:00:00 1300.0 1300.0   MON           1342185.0                   Barbara Parker       CAT   OTH City of Oakland, CA   S       S            
29 29 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D EDT6 COM Berkeley Measure U, 2012                 2012-10-12 00:00:00 1000.0 19000.0   IND Payment for appearance on slate mailer in opposition to City of Berkeley Measure U                                                 Initiative Ordinance Enacting New Requirements for the City Council and Rent Stabilization Board and Boards and Commissions Relating to Agendas and Meetings U City of Berkeley, CA O            
30 30 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D EDT11 COM Berkeley Measure U, 2012                 2012-10-16 00:00:00 18000.0 19000.0   IND Payment for appearance on slate mailer in opposition to City of Berkeley Measure U                                                 Initiative Ordinance Enacting New Requirements for the City Council and Rent Stabilization Board and Boards and Commissions Relating to Agendas and Meetings U City of Berkeley, CA O            
31 31 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D EDT7 COM Jay James, 2012                 2012-10-12 00:00:00 250.0 250.0   IND Payment for appearance on slate mailer in support of Jay James for Rent Stabilization Board Commissioner                             Jay James       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
32 32 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D EDT8 COM Judy Hunt, 2012                 2012-10-12 00:00:00 250.0 250.0   IND Payment for appearance on slate mailer in support of Judy Hunt for Rent Stabilization Board Commissioner                             Judy Hunt       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
33 33 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D EDT9 COM Kiran Shenoy, 2012                 2012-10-12 00:00:00 250.0 250.0   IND Payment for appearance on slate mailer in support of Kiran Shenoy for Rent Stabilization Board Commissioner                             Kiran Shenoy       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
34 34 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D EXP1355 COM Neighbors for Sean Sullivan for City Council 2012           Emeryville CA 94608.0 2012-10-12 00:00:00 700.0 700.0   MON           1336895.0                   Sean Sullivan       CCM   OTH City of Oakland, CA 3 S       S            
35 35 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D EDT10 COM Nicole Drake, 2012                 2012-10-12 00:00:00 250.0 250.0   IND Payment for appearance on slate mailer in support of Nicole Drake for Rent Stabilization Board Commissioner                             Nicole Drake       OTH Rent Stabilization Board Commissioner OTH City of Berkeley, CA           S            
36 36 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     EXPN D EXP1357 COM Re-Elect Larry Reid for City Council 2012           Oakland CA 94603.0 2012-10-12 00:00:00 1300.0 1300.0   MON           1345266.0                   Larry Reid       CCM   OTH City of Oakland, CA 7 H       S            
37 37 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1405 COM Abel Guillen for Assembly 2012           Oakland CA 94609.0 2012-09-07 00:00:00 1000.0 1000.0   MON           1338631.0                   Abel Guillen       ASM   ASM   18         S            
38 38 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1401 COM Amy Lemley for City Council 2012           Oakland CA 94618.0 2012-09-07 00:00:00 1300.0 1300.0   MON           1346362.0                   Amy Lemley       CCM   OTH Oakland, CA 1         S            
39 39 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1399 COM Barbara Parker for Oakland City Attorney 2012           Oakland CA 94612.0 2012-09-07 00:00:00 1300.0 1300.0   MON           1342185.0                   Barbara Parker       CAT   OTH City of Oakland           S            
40 40 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1412 COM Committee to Elect Lynette McElhaney for City Council 2012           Oakland CA 94610.0 2012-09-10 00:00:00 700.0 700.0   MON           1342416.0                   Lynette McElhaney       CCM   OTH Oakland, CA 3         S            
41 41 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1400 COM De La Fuente for City Council 2012           Oakland CA 94601.0 2012-09-07 00:00:00 1300.0 1300.0   MON           1349495.0                   Ignacio de la Fuente       CCM   OTH Oakland, CA 5         S            
42 42 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1411 COM Friends of Jody London for School Board 2012           Oakland CA 94618.0 2012-09-07 00:00:00 350.0 350.0   MON           1303019.0                   Jody London       OTH School Board OTH Oakland, CA 1         S            
43 43 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1408 COM James Harris for Oakland School Board 2012           Oakland CA 94612.0 2012-09-07 00:00:00 700.0 700.0   MON           1345919.0                   James Harris       OTH School Board OTH Oakland, CA 7         S            
44 44 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1415 COM Kaplan for Oakland City Council 2012           Oakland CA 94612.0 2012-09-10 00:00:00 700.0 700.0   MON           1341827.0                   Rebecca Kaplan       CCM   OTH Oakland, CA AL         S            
45 45 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1403 COM Mario Juarez for Council 2012           Oakland CA 94601.0 2012-09-07 00:00:00 1300.0 1300.0   MON           1335572.0                   Mario Juarez       CCM   OTH Oakland, CA 5         S            
46 46 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1402 COM Neighbors for Sean Sullivan for Oakland City Council 2012           Oakland CA 94608.0 2012-09-07 00:00:00 1300.0 1300.0   MON           1336895.0                   Sean Sullivan       CCM   OTH Oakland, CA 3         S            
47 47 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1409 COM Parents for Richard Fuentes for Oakland School Board 2012           Oakland CA 94608.0 2012-09-07 00:00:00 700.0 700.0   MON           1337648.0                   Richard Fuentes       OTH School Board OTH Oakland, CA 3         S            
48 48 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1406 COM Raya for City Council 2012           Oakland CA 94611.0 2012-09-07 00:00:00 700.0 700.0   MON           1344049.0                   Richard Raya       CCM   OTH Oakland, CA 1         S            
49 49 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1414 COM Re-Elect Larry Reid for City Council 2012           Oakland CA 94618.0 2012-09-10 00:00:00 1300.0 1300.0   MON           1345266.0                   Larry Reid       CCM   OTH Oakland, CA 7         S            
50 50 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1404 COM Rob Bonta for State Assembly 2012           Alameda CA 94501.0 2012-09-07 00:00:00 1000.0 1000.0   MON           1339722.0                   Rob Bonta       ASM   ASM   18         S            
51 51 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1410 COM Roseann Torres for Oakland School Board 2012           Oakland CA 94602.0 2012-09-07 00:00:00 350.0 350.0   MON           1348353.0                   Roseann Torres       OTH School Board OTH Oakland, CA 5         S            
52 52 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1407 COM Shelly Garza for City Council District 5 2012           Oakland CA 94601.0 2012-09-07 00:00:00 700.0 700.0   MON           1345618.0                   Shelly Garza       CCM   OTH Oakland, CA 5         S            
53 53 983545 OAKPAC, OAKLAND METROPOLITAN CHAMBER OF COMMERCE 0 RCP 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1413 COM Walton for City Council 2012           Oakland CA 94619.0 2012-09-10 00:00:00 700.0 700.0   MON           1345683.0                   Sheryl Walton       CCM   OTH Oakland, CA 7         S            
54 54 1342695 East Bay Rental Housing Association PAC 0 RCP 2012-10-03 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     EXPN D EXP1349 COM Rob Bonta for State Assembly 2012           Alameda CA 94501.0 2012-09-19 00:00:00 750.0 750.0   MON           1339722.0                   Rob Bonta       ASM   ASM   18         S            
55 55 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2014-01-29 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D EDT104 COM Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee           Oakland CA 94612 2013-10-04 00:00:00 362.35 1124.95   IKD Accounting Services         1313157.0                   Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee       OTH Political Action Committee OTH City of Oakland, CA           S            
56 56 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2014-01-29 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D EDT105 COM Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee           Oakland CA 94612 2013-11-15 00:00:00 134.2 1124.95   IKD Accounting Services         1313157.0                   Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee       OTH Political Action Committee OTH City of Oakland, CA           S            
57 57 943526 Oakland Police Officer's Association - Political Action Committee 0 RCP 2014-01-10 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D EXP84 COM Nancy O'Malley for District Attorney 2014           Alameda CA 94501 2013-08-19 00:00:00 500.0 500.0   MON           1322240.0                   Nancy O'Malley       DAT   OTH Alameda County, CA           S            
58 58 943526 Oakland Police Officer's Association - Political Action Committee 0 RCP 2014-01-10 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D EXP96 COM Rob Bonta for State Assembly 2014           Sacramento CA 95815 2013-12-04 00:00:00 2000.0 4100.0   MON           1353796.0                   Rob Bonta       ASM   ASM   18         S            
59 59 1284364 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 0 CTL 2014-01-31 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D sFbSadGqUMK4 COM United Democratic Campaign of Alameda County           Hayward CA 94545 2013-09-28 00:00:00 100.0 100.0   MON 2013 UDC Unity Dinner on September 28                                                       S            
60 60 1284364 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 0 CTL 2014-01-31 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D RKlWa5EAB6Em COM East Bay Young Democrats           Oakland CA 94610 2013-11-01 00:00:00 250.0 250.0   MON 10th Anniversary Gala on November 4                                                       S            
61 61 1284364 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 0 CTL 2014-01-31 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D gKisUvp1wgKb COM Black Young Democrats, East Bay           Oakland CA 946XX 2013-11-14 00:00:00 125.0 125.0   MON 2nd Annual Sankofa Knight Award's Ceremony and Fundraiser on November 16                                                       S            
62 62 1343715 Dan Kalb for City Council 2012 0 CTL 2014-01-30 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D fJLVVytqcpcU COM Keep Oakland Firesafe 2013           Oakland CA 94607 2013-08-09 00:00:00 400.0 400.0   MON                                                         S            
63 63 1343715 Dan Kalb for City Council 2012 0 CTL 2014-01-30 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D YpQB6F6VEm9l COM DAVE JONES FOR INSURANCE COMMISSIONER 2014           Sacramento CA 95814-3940 2013-08-28 00:00:00 120.0 120.0   MON                                                         S            
64 64 1343715 Dan Kalb for City Council 2012 0 CTL 2014-01-30 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D p2iIDMUIeoa7 COM Alameda County Democratic Central Committee           Hayward CA 94541 2013-10-04 00:00:00 150.0 150.0   MON                                                         S            
65 65 1343715 Dan Kalb for City Council 2012 0 CTL 2014-01-30 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D U9jrfLzlmMyC COM League of Conservation Voters of the East Bay           Oakland CA 94612 2013-10-04 00:00:00 100.0 100.0   MON                                                         S            
66 66 1343715 Dan Kalb for City Council 2012 0 CTL 2014-01-30 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D NKQNDk6pmzyE COM East Bay Young Democrats           Concord CA 94518 2013-11-04 00:00:00 100.0 100.0   MON                                                         S            
67 67 1343715 Dan Kalb for City Council 2012 0 CTL 2014-01-30 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D rQBNtJl24brd COM Dan Kalb City Council Officeholder Committee           Oakland CA 94612 2013-11-08 00:00:00 200.0 200.0   MON                                                         S            
68 68 1343715 Dan Kalb for City Council 2012 0 CTL 2014-01-30 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D vCLrzPwBHAwD COM Betty Yee for Controller 2014           Los Angeles CA 90048 2013-11-17 00:00:00 100.0 100.0   MON                                                         S            
69 69 1342695 East Bay Rental Housing Association PAC 0 RCP 2014-01-30 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D EXP3641 COM Rob Bonta for State Assembly 2014           Sacramento CA 95814 2013-12-30 00:00:00 500.0 500.0   MON           1353796.0                   Rob Bonta       ASM   ASM   18 H       S            
70 70 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2014-01-28 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       EXPN D D262 COM                   2013-12-04 00:00:00 200.0 200.0   MON                               Teresa Cox for Assembly 2014                         S            
71 71 1343715 Dan Kalb for City Council 2012 0 CTL 2013-08-02 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D azbRpsLIPnZS COM National Women's Political Caucus Alameda North PAC           Oakland CA 94610 2013-04-28 00:00:00 150.0 150.0   MON                                                         S            
72 72 1284364 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 0 CTL 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D X5glDo9jq6R2 COM Betty Yee for Controller 2014           San Francisco CA 94104 2013-03-19 00:00:00 125.0 125.0   MON Attendance to Betty Yee for Controller 2013 event on March 20, 2013                             Yee Betty     CON   STW             S            
73 73 1284364 Courtney Ruby 2010 Oakland City Auditor Officeholder Account 0 CTL 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D tFjkU4Thap5X COM National Women's Political Caucus Alameda North Political Action Committee           Oakland CA 94610 2013-04-28 00:00:00 250.0 250.0   MON Attendance/Sponsorship of 2013 Annual Susan B. Event on April 28, 2013                                                       S            
74 74 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D EXP1459 COM Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee           Oakland CA 94612 2013-01-09 00:00:00 50.0 628.4   MON           1313157.0                   Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee       OTH Political Action Committee OTH City of Oakland, CA           S            
75 75 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 0 RCP 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D EDT103 COM Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee           Oakland CA 94612 2013-05-09 00:00:00 578.4 628.4   IKD Accounting Services         1313157.0                   Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee       OTH Political Action Committee OTH City of Oakland, CA           S            
76 76 1307016 Oakland Jobs PAC 0 RCP 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D EXP445 COM Kaplan for Oakland City Council 2012           Oakland CA 94612 2013-01-29 00:00:00 700.0 700.0   MON           1341827.0                   Rebecca Kaplan       CCM   OTH City of Oakland, CA AL         S            
77 77 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D EXP2414 COM Barbara Parker City Attorney Officeholder Account 2008-2012           Oakland CA 94610 2013-05-13 00:00:00 500.0 500.0   MON           1352921.0                   Barbara Parker       CAT   OTH City of Oakland, CA   H       S   EXP2414        
78 78 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D EXP2416 COM Bob Wieckowski for Senate 2014           Sacramento CA 95814 2013-05-13 00:00:00 1000.0 1000.0   MON           1354452.0                   Bob Wieckowski       SEN   SEN   10 S       S            
79 79 1342695 East Bay Rental Housing Association PAC 0 RCP 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D EXP2415 COM Libby Schaaf for Council 2010           Oakland CA 94602 2013-05-13 00:00:00 500.0 500.0   MON           1324270.0                   Libby Schaaf       CCM   OTH City of Oakland 4 H       S   EXP2415        
80 80 1280436 Pat Kernighan Office Holder 0 CTL 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D aR7s67kqP1GW COM Dan Kalb for City Council           Oakland CA 94612 2013-06-02 00:00:00 150.0 0.0   MON                                                         S            
81 81 1280436 Pat Kernighan Office Holder 0 CTL 2013-07-31 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       EXPN D Bvjf7zSjDXOe COM Dan Kalb for City Council           Oakland CA 94612 2013-06-25 00:00:00 -150.0 0.0   MON Return of contribution                                                       S            
82 82 1336895 Neighbors for Sean Sullivan for Oakland City Council 2012 0 CTL 2013-07-28 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00 2012-11-06 00:00:00     EXPN D y3Jc1QkrJlLr COM Anthony Duarte for School Board 2013           Covina CA 91722 2013-05-02 00:00:00 100.0 100.0   MON                                                         S            
83 83 1336895 Neighbors for Sean Sullivan for Oakland City Council 2012 0 CTL 2013-07-28 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00 2012-11-06 00:00:00     EXPN D EJJteNiH94Jg COM Oakland Rainbow PAC           Oakland CA 94608 2013-05-02 00:00:00 250.0 250.0   MON                                                         S            
84 84 1367792 East Bay Alliance for a Sustainable Economy Committee for Yes on Measure FF 1 BMC 2014-10-06 00:00:00 2014-01-01 00:00:00 2014-06-30 00:00:00 2014-11-04 00:00:00     EXPN D D1 COM                   2014-06-30 00:00:00 1225.7 1225.7   MON                                                   Minimum Wage Increase   City of Oakland S            
85 85 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 1 RCP 2014-08-27 00:00:00 2014-01-01 00:00:00 2014-06-30 00:00:00       EXPN D EXP1522 COM Karen L. Monroe for County Superintendent 2014           Oakland CA 94607 2014-02-05 00:00:00 1000.0 1000.0   MON           1357615                   Karen L. Monroe       OTH County?Superintendent?of?Schools OTH Alameda County           S            
86 86 983545 OAKPAC, Oakland Metropolitan Chamber of Commerce 1 RCP 2014-08-27 00:00:00 2014-01-01 00:00:00 2014-06-30 00:00:00       EXPN D EXP1523 COM Rob Bonta for Assembly 2014           Alameda CA 94501 2014-02-05 00:00:00 1000.0 1000.0   MON           1353796                   Rob Bonta       ASM   ASM   18.0         S            
87 87 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT29 COM Anne Campbell Washington for Oakland City Council 2014           Oakland CA 94611 2014-09-22 00:00:00 881.87 6132.89   IND Coroplast Signs         1365610                   Anne Campbell Washington       CCM   OTH City of Oakland, CA 4.0         S            
88 88 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT30 COM Anne Campbell Washington for Oakland City Council 2014           Oakland CA 94611 2014-09-22 00:00:00 750.0 6132.89   IND Design for Signs         1365610                   Anne Campbell Washington       CCM   OTH City of Oakland, CA 4.0         S            
89 89 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT33 COM Anne Campbell Washington for Oakland City Council 2014           Oakland CA 94611 2014-09-22 00:00:00 365.55 6132.89   IND Data         1365610                   Anne Campbell Washington       CCM   OTH City of Oakland, CA 4.0         S            
90 90 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT35 COM Anne Campbell Washington for Oakland City Council 2014           Oakland CA 94611 2014-09-22 00:00:00 2300.02 6132.89   IND Printing for Mailer         1365610                   Anne Campbell Washington       CCM   OTH City of Oakland, CA 4.0         S            
91 91 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT37 COM Anne Campbell Washington for Oakland City Council 2014           Oakland CA 94611 2014-09-23 00:00:00 435.45 6132.89   IND Mass Email         1365610                   Anne Campbell Washington       CCM   OTH City of Oakland, CA 4.0         S            
92 92 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EXP118 COM Brenda Roberts for Oakland City Auditor 2014           Oakland CA 94618 2014-09-22 00:00:00 1400.0 1400.0   MON           1368410                   Brenda Roberts       OTH City Auditor OTH City of Oakland, CA   S       S            
93 93 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EXP116 COM Friends of Desley Brooks           Oakland CA 94619 2014-08-13 00:00:00 700.0 1400.0   MON           1236617                   Desley Brooks       CCM   OTH City of Oakland, CA 6.0 H       S            
94 94 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT58 COM Jerry Brown 2014                 2014-09-22 00:00:00 255.56 255.56   IND Printing for Mailer                             Jerry Brown       GOV   STW     H       S            
95 95 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EXP143 COM Nancy O'Malley for District Attorney 2014           Alameda CA 94501 2014-07-28 00:00:00 1000.0 1000.0   MON           1322240                   Nancy O'Malley       DAT   OTH Alameda County, CA           S            
96 96 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT31 COM Neighbors for a Safer Oakland 2014, Yes on Z           Oakland CA 94618 2014-09-22 00:00:00 750.0 2062.11   IND Design for Signs         1369855                                       Maintain a Parcel Tax and a Parking Tax Surcharge For a Period of Ten Years To Improve Police, Fire and Emergency Services Z City of Oakland, CA S            
97 97 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT32 COM Neighbors for a Safer Oakland 2014, Yes on Z           Oakland CA 94618 2014-09-22 00:00:00 365.54 2062.11   IND Data         1369855                                       Maintain a Parcel Tax and a Parking Tax Surcharge For a Period of Ten Years To Improve Police, Fire and Emergency Services Z City of Oakland, CA S            
98 98 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT34 COM Neighbors for a Safer Oakland 2014, Yes on Z           Oakland CA 94618 2014-09-22 00:00:00 511.12 2062.11   IND Printing for Mailer         1369855                                       Maintain a Parcel Tax and a Parking Tax Surcharge For a Period of Ten Years To Improve Police, Fire and Emergency Services Z City of Oakland, CA S            
99 99 943526 Oakland Police Officer's Association - Political Action Committee 3 RCP 2015-04-10 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT36 COM Neighbors for a Safer Oakland 2014, Yes on Z           Oakland CA 94618 2014-09-23 00:00:00 435.45 2062.11   IND Mass Email         1369855                                       Maintain a Parcel Tax and a Parking Tax Surcharge For a Period of Ten Years To Improve Police, Fire and Emergency Services Z City of Oakland, CA S            
100 100 943526 Oakland Police Officer's Association - Political Action Committee 2 RCP 2014-10-22 00:00:00 2014-07-01 00:00:00 2014-09-30 00:00:00 2014-11-04 00:00:00     EXPN D EDT29 COM Anne Campbell Washington for Oakland City Council 2014           Oakland CA 94611 2014-09-22 00:00:00 881.87 6132.89   IND Coroplast Signs         1365610                   Anne Campbell Washington       CCM   OTH City of Oakland, CA 4.0         S            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "D_Expenditure" (
"Filer_ID" TEXT,
  "Filer_NamL" TEXT,
  "Report_Num" TEXT,
  "Committee_Type" TEXT,
  "Rpt_Date" TEXT,
  "From_Date" TEXT,
  "Thru_Date" TEXT,
  "Elect_Date" TEXT,
  "tblCover_Office_Cd" TEXT,
  "tblCover_Offic_Dscr" TEXT,
  "Rec_Type" TEXT,
  "Form_Type" TEXT,
  "Tran_ID" TEXT,
  "Entity_Cd" TEXT,
  "Payee_NamL" TEXT,
  "Payee_NamF" TEXT,
  "Payee_NamT" TEXT,
  "Payee_NamS" TEXT,
  "Payee_Adr1" TEXT,
  "Payee_Adr2" TEXT,
  "Payee_City" TEXT,
  "Payee_State" TEXT,
  "Payee_Zip4" TEXT,
  "Expn_Date" TEXT,
  "Amount" TEXT,
  "Cum_YTD" TEXT,
  "Expn_ChkNo" TEXT,
  "Expn_Code" TEXT,
  "Expn_Dscr" TEXT,
  "Agent_NamL" TEXT,
  "Agent_NamF" TEXT,
  "Agent_NamT" TEXT,
  "Agent_NamS" TEXT,
  "Cmte_ID" TEXT,
  "Tres_NamL" TEXT,
  "Tres_NamF" TEXT,
  "Tres_NamT" TEXT,
  "Tres_NamS" TEXT,
  "Tres_Adr1" TEXT,
  "Tres_Adr2" TEXT,
  "Tres_City" TEXT,
  "Tres_ST" TEXT,
  "Tres_ZIP4" TEXT,
  "Cand_NamL" TEXT,
  "Cand_NamF" TEXT,
  "Cand_NamT" TEXT,
  "Cand_NamS" TEXT,
  "Office_Cd" TEXT,
  "Offic_Dscr" TEXT,
  "Juris_Cd" TEXT,
  "Juris_Dscr" TEXT,
  "Dist_No" TEXT,
  "Off_S_H_Cd" TEXT,
  "Bal_Name" TEXT,
  "Bal_Num" TEXT,
  "Bal_Juris" TEXT,
  "Sup_Opp_Cd" TEXT,
  "Memo_Code" TEXT,
  "Memo_RefNo" TEXT,
  "BakRef_TID" TEXT,
  "G_From_E_F" TEXT,
  "XRef_SchNm" TEXT,
  "XRef_Match" TEXT
);