B1_Loans

1,688 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Report_Num, Committee_Type, Elect_Date, Entity_Cd, Lndr_NamT, Loan_City, Loan_ST, Loan_Zip4, Loan_Rate, Cmte_ID, Memo_Code, Loan_Amt7, Rpt_Date (date), From_Date (date), Thru_Date (date), Elect_Date (date), Loan_Date1 (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 Lndr_NamL Lndr_NamF Lndr_NamT Lndr_NamS Loan_Adr1 Loan_Adr2 Loan_City Loan_ST Loan_Zip4 Loan_Date1 Loan_Date2 Loan_Amt1 Loan_Amt2 Loan_Amt3 Loan_Amt4 Loan_Rate Loan_EMP Loan_OCC Loan_Self Cmte_ID Tres_NamL Tres_NamF Tres_NamT Tres_NamS Tres_Adr1 Tres_Adr2 Tres_City Tres_ST Tres_ZIP4 B2Lender_Name-Inter_name Intr_NamF Intr_NamT Intr_NamS Intr_Adr1 Intr_Adr2 Intr_City Intr_ST Intr_ZIP4 Memo_Code Memo_RefNo BakRef_TID XRef_SchNm XRef_Match Loan_Amt5 Loan_Amt6 Loan_Amt7 Loan_Amt8
1 1 1327636 Harland For Mayor 0 CTL 2014-04-01 00:00:00 2010-10-04 00:00:00 2010-12-31 00:00:00 2010-11-10 00:00:00     LOAN B1 f9jqoHKKpLeF IND Harland Gregory & Joan         Oakland CA 94611 2010-08-10 00:00:00 08/10/2011 0 20000 40000 20000 0 Greg - Self-employedJoan - Law Offices of Leona L. Lauder Greg- InvestorJoan - Patent Agent n                                                 0 0 0 20000
2 2 1327636 Harland For Mayor 0 CTL 2014-04-01 00:00:00 2010-10-04 00:00:00 2010-12-31 00:00:00 2010-11-10 00:00:00     LOAN B1 deBhbHXlu93x IND Harland Gregory & Joan         Oakland CA 94611 2010-09-02 00:00:00 09/02/2011 0 20000 40000 20000 0 Greg - Self-employedJoan - Law Offices of Leona L. Lauder Greg- InvestorJoan - Patent Agent n                                                 0 0 0 20000
3 3 1327636 Harland For Mayor 0 CTL 2014-04-01 00:00:00 2011-01-01 00:00:00 2011-06-30 00:00:00       LOAN B1 f9jqoHKKpLeF IND Harland Gregory & Joan         Oakland CA 94611 2010-08-10 00:00:00 08/10/2011 0 0 -28476 20000 0 Greg - Self-employedJoan - Law Offices of Leona L. Lauder Greg- InvestorJoan - Patent Agent n                                                 17119 2881 0 20000
4 4 1327636 Harland For Mayor 0 CTL 2014-04-01 00:00:00 2011-01-01 00:00:00 2011-06-30 00:00:00       LOAN B1 deBhbHXlu93x IND Harland Gregory & Joan         Oakland CA 94611 2010-09-02 00:00:00 09/02/2011 0 0 -28476 20000 0 Greg - Self-employedJoan - Law Offices of Leona L. Lauder Greg- InvestorJoan - Patent Agent n                                                 17119 2881 0 20000
5 5 1342709 Derrick H Muhammad for City Council 2012 0 RCP 2012-01-31 00:00:00 2011-01-01 00:00:00 2011-12-31 00:00:00       LOAN B1 B1-21 IND Muhammad Derrick         Oakland CA 94607 2011-12-01 00:00:00 01/01/2013 1000 1000 1025 0 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 1000
6 6 1342709 Derrick H Muhammad for City Council 2012 1 CTL 2012-10-11 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 B1-21 IND Muhammad Derrick         Oakland CA 94607 2011-12-01 00:00:00 01/01/2013 0 1000 648 1000 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 1000
7 7 1342709 Derrick H Muhammad for City Council 2012 1 CTL 2012-10-11 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 B1-30 IND Muhammad Derrick         Oakland CA 94607 2012-01-27 00:00:00 01/26/2013 0 223 648 223 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 223
8 8 1342709 Derrick H Muhammad for City Council 2012 1 CTL 2012-10-11 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 B1-122 IND Muhammad Derrick         Oakland CA 94607 2012-03-29 00:00:00 03/29/2013 0 100 648 100 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 100
9 9 1342709 Derrick H Muhammad for City Council 2012 1 CTL 2012-10-11 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 B1-120 IND Muhammad Derrick         Oakland CA 94607 2012-06-11 00:00:00 06/13/2013 0 325 648 325 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 325
10 10 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       LOAN B1 eh6nbEcnttua IND Parker Barbara         Oakland CA 94602 2011-11-30 00:00:00   0 29993 29993 29993   City of Oakland City Attorney n                                                 0 0 0 29993
11 11 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       LOAN B1 F8UL6fVs225J IND Parker Barbara         Oakland CA 94602 2012-09-30 00:00:00   10000 10000 29993 0   City of Oakland City Attorney n                                                 0 0 0 10000
12 12 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       LOAN B1 yJ8Ta7qVpE6f IND Parker Barbara         Oakland CA 94602 2012-11-08 00:00:00   19993 19993 29993 0   City of Oakland City Attorney n                                                 0 0 0 19993
13 13 1236617 Desley Brooks 0 CTL 2014-10-15 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 aUKlMSzYv1p5 OTH Desley Brooks           Oakland CA 94612 2012-02-01 00:00:00   11087 0 11087 0       n 1236617                                               0 11087 0 11087
14 14 1343281 Committee to Recall Mayor Quan Now 0 BMC 2013-07-29 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       LOAN B1 BTGUbe4H7Bv7 IND Raphael Leonard         Oakland CA 94618 2012-06-30 00:00:00   0 2000 2000 2000   self CPA n                                                 0 0 0 2000
15 15 1343281 Committee to Recall Mayor Quan Now 0 BMC 2013-07-29 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 BTGUbe4H7Bv7 IND Raphael Leonard         Oakland CA 94618 2012-06-30 00:00:00   0 2000 2000 2000   self CPA n                                                 0 0 0 2000
16 16 1343281 Committee to Recall Mayor Quan Now 0 BMC 2013-07-29 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 BTGUbe4H7Bv7 IND Raphael Leonard         Oakland CA 94618 2012-06-30 00:00:00   0 2000 2000 2000   self CPA n                                                 0 0 0 2000
17 17 1341977 Friends of Dewitt for Oakland City Council 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     LOAN B1 6OSVEhFBqBEY IND Dewitt Nyeisha         Oakland CA 94609 2012-07-06 00:00:00   410 410 19032 0       n                                                 0 0 0 410
18 18 1341977 Friends of Dewitt for Oakland City Council 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     LOAN B1 5pzFpN92jyUw IND Dewitt Nyeisha         Oakland CA 94609 2012-07-19 00:00:00   2000 2000 19032 0       n                                                 0 0 0 2000
19 19 1341977 Friends of Dewitt for Oakland City Council 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     LOAN B1 gpiPvqjThdue IND Dewitt Nyeisha         Oakland CA 94609 2012-09-21 00:00:00   2000 2000 19032 0       n                                                 0 0 0 2000
20 20 1341977 Friends of Dewitt for Oakland City Council 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     LOAN B1 PHzfNS5jbdyx IND Dewitt Nyeisha         Oakland CA 94609 2012-09-29 00:00:00   422 422 19032 0       n                                                 0 0 0 422
21 21 1341977 Friends of Dewitt for Oakland City Council 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     LOAN B1 4aVh8nyXvL9j IND Dewitt Nyeisha         Oakland CA 94609 2012-09-30 00:00:00   1918 1918 19032 0       n                                                 0 0 0 1918
22 22 1341977 Friends of Dewitt for Oakland City Council 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     LOAN B1 fVrQEHyub5vf IND Dewitt Nyeisha         Oakland CA 94609 2012-09-30 00:00:00   12000 12000 19032 0       n                                                 0 0 0 12000
23 23 1341977 Friends of Dewitt for Oakland City Council 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     LOAN B1 zukL2krQukuD IND Dewitt Nyeisha         Oakland CA 94609 2012-10-02 00:00:00   250 250 19032 0       n                                                 0 0 0 250
24 24 1350016 Len Raphael for City Council 2012 0 CTL 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY93 IND Raphael Leonard         Oakland CA 94618 2012-07-26 00:00:00   0 0 41764.96 300 0.00% Raphael & Associates Certified Public Accountant n                                       PAY93         0 300 0 300
25 25 1350016 Len Raphael for City Council 2012 0 CTL 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY96 IND Raphael Leonard         Oakland CA 94618 2012-08-16 00:00:00   0 0 41764.96 100 0.00% Raphael & Associates Certified Public Accountant n                                                 0 100 0 100
26 26 1350016 Len Raphael for City Council 2012 0 CTL 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY5 IND Raphael Leonard         Oakland CA 94618 2012-08-28 00:00:00   0 0 41764.96 13000   Raphael & Associates Certified Public Accountant n                                                 0 13000 0 25000
27 27 1350016 Len Raphael for City Council 2012 0 CTL 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY156 IND Raphael Leonard         Oakland CA 94618 2012-10-19 00:00:00   0 0 41764.96 11200   Raphael & Associates Certified Public Accountant n                                                 0 11200 0 11200
28 28 1350016 Len Raphael for City Council 2012 0 CTL 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY184 IND Raphael Leonard         Oakland CA 94618 2012-10-20 00:00:00   0 0 41764.96 300   Raphael & Associates Certified Public Accountant n                                                 0 300 0 300
29 29 1350016 Len Raphael for City Council 2012 0 CTL 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY242 IND Raphael Leonard         Oakland CA 94618 2012-10-25 00:00:00   2000 0 41764.96 0   Raphael & Associates Certified Public Accountant n                                                 0 2000 0 2000
30 30 1350016 Len Raphael for City Council 2012 0 CTL 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY256 IND Raphael Leonard         Oakland CA 94618 2012-10-29 00:00:00   6000 0 41764.96 0   Raphael & Associates Certified Public Accountant n                                                 0 6000 0 6000
31 31 1350016 Len Raphael for City Council 2012 0 CTL 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY285 IND Raphael Leonard         Oakland CA 94618 2012-11-05 00:00:00   2500 0 41764.96 0   Raphael & Associates Certified Public Accountant n                                                 0 2500 0 2500
32 32 1350016 Len Raphael for City Council 2012 0 CTL 2013-01-31 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY296 IND Raphael Leonard         Oakland CA 94618 2012-11-16 00:00:00   2400 0 41764.96 0   Raphael & Associates Certified Public Accountant n                                                 0 2400 0 2400
33 33 1313157 Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee 0 RCP 2013-01-31 00:00:00 2012-07-01 00:00:00 2012-12-31 00:00:00       LOAN B1 PAY2 OTH Oakland Chamber of Commerce           Oakland CA 94612 2008-10-21 00:00:00   0 500 447.18 500       n                                                 0 0 0 500
34 34 1313157 Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee 0 RCP 2013-01-31 00:00:00 2012-07-01 00:00:00 2012-12-31 00:00:00       LOAN B1 PAY4 OTH Oakland Chamber of Commerce           Oakland CA 94612 2008-10-28 00:00:00   0 1030 447.18 1030       n                                                 0 0 0 1030
35 35 1313157 Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee 0 RCP 2013-01-31 00:00:00 2012-07-01 00:00:00 2012-12-31 00:00:00       LOAN B1 PAY20 OTH Oakland Chamber of Commerce           Oakland CA 94612 2008-12-16 00:00:00   0 2615.33 447.18 2615.33 0.00%     n                                                 0 0 0 2615.33
36 36 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     LOAN B1 89c1nBiUyN46 IND Parker Barbara         Oakland CA 94602 2012-09-30 00:00:00 09/30/2013 10000 10000 29993 0 0 City of Oakland City Attorney n                                                 0 0 0 10000
37 37 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     LOAN B1 cxDx3fSkZsxe IND Parker Barbara         Oakland CA 94602 2012-11-08 00:00:00 11/08/2013 19993 19993 29993 0 0 City of Oakland City Attorney n                                                 0 0 0 19993
38 38 1343715 Dan Kalb for City Council 2012 0 CTL 2013-01-30 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       LOAN B1 2CbTAYhQnQk9 IND Kalb Dan         Oakland CA 94618 2012-01-27 00:00:00   0 4500 11100 4500 0 Self-employed, No Separate Business Name Environmental Consultant n                                                 0 0 0 4500
39 39 1343715 Dan Kalb for City Council 2012 0 CTL 2013-01-30 00:00:00 2012-10-21 00:00:00 2012-12-31 00:00:00       LOAN B1 cBJKEsb6ggk1 IND Kalb Dan         Oakland CA 94618 2012-06-15 00:00:00   0 4500 11100 4500 0 Self-employed, No Separate Business Name Environmental Consultant n                                                 0 0 0 4500
40 40 1346638 Committee to Elect Don Link to City Council 0 CTL 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 12266751 IND Link Gordon 'Don'         Oakland CA 94609 2012-07-01 00:00:00   0 15900 20700 15900 0.00 %     n                                                 0 0   15900
41 41 1346638 Committee to Elect Don Link to City Council 0 CTL 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 12536363 IND Link Gordon 'Don'         Oakland CA 94609 2012-10-15 00:00:00   4800 4800 20700 0 0.00 %     n                                                 0 0   4800
42 42 1350016 Len Raphael for City Council 2012 0 CTL 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY93 IND Raphael Leonard         Oakland CA 94618 2012-07-26 00:00:00   0 300 28864.96 300 0.00% Raphael & Associates Certified Public Accountant n                                       PAY93         0 0 0 300
43 43 1350016 Len Raphael for City Council 2012 0 CTL 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY96 IND Raphael Leonard         Oakland CA 94618 2012-08-16 00:00:00   0 100 28864.96 100 0.00% Raphael & Associates Certified Public Accountant n                                                 0 0 0 100
44 44 1350016 Len Raphael for City Council 2012 0 CTL 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY5 IND Raphael Leonard         Oakland CA 94618 2012-08-28 00:00:00   0 13000 28864.96 17000   Raphael & Associates Certified Public Accountant n                                                 4000 0 0 25000
45 45 1350016 Len Raphael for City Council 2012 0 CTL 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY156 IND Raphael Leonard         Oakland CA 94618 2012-10-19 00:00:00   11200 11200 28864.96 0   Raphael & Associates Certified Public Accountant n                                                 0 0 0 11200
46 46 1350016 Len Raphael for City Council 2012 0 CTL 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY184 IND Raphael Leonard         Oakland CA 94618 2012-10-20 00:00:00   300 300 28864.96 0   Raphael & Associates Certified Public Accountant n                                                 0 0 0 300
47 47 1343715 Dan Kalb for City Council 2012 0 CTL 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 11805394 IND Kalb Dan         Oakland CA 94618 2012-01-27 00:00:00   0 4500 11100 4500 0.00 % Self-employed, No Separate Business Name Environmental Consultant n                                                 0 0   4500
48 48 1343715 Dan Kalb for City Council 2012 0 CTL 2012-10-25 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 11805424 IND Kalb Dan         Oakland CA 94618 2012-06-15 00:00:00   0 4500 11100 4500 0.00 % Self-employed, No Separate Business Name Environmental Consultant n                                                 0 0   4500
49 49 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-10-24 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00       LOAN B1 B1-21 IND Muhammad Derrick         Oakland CA 94607 2011-12-01 00:00:00 01/01/2013 0 1000 648 1000 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 1000
50 50 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-10-24 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00       LOAN B1 B1-30 IND Muhammad Derrick         Oakland CA 94607 2012-01-27 00:00:00 01/26/2013 0 223 648 223 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 223
51 51 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-10-24 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00       LOAN B1 B1-122 IND Muhammad Derrick         Oakland CA 94607 2012-03-29 00:00:00 03/29/2013 0 100 648 100 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 100
52 52 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-10-24 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00       LOAN B1 B1-120 IND Muhammad Derrick         Oakland CA 94607 2012-06-11 00:00:00 06/13/2013 0 325 648 325 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 325
53 53   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-10-20 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 C5302656 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-07-06 00:00:00   0 410 19000 410 0 OPA Director of Community Collaboration n                                                 0 0 0 410
54 54   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-10-20 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 C5332310 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-07-19 00:00:00   0 2000 19000 2000 0 OPA Director of Community Collaboration n                                                 0 0 0 2000
55 55   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-10-20 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 C5565490 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-09-21 00:00:00   0 2000 19000 2000 0 OPA Director of Community Collaboration n                                                 0 0 0 2000
56 56   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-10-20 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 C5565491 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-09-29 00:00:00   0 422 19000 422 0 OPA Director of Community Collaboration n                                                 0 0 0 422
57 57   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-10-20 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 C5565488 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-09-30 00:00:00   0 12000 19000 12000 0 OPA Director of Community Collaboration n                                                 0 0 0 12000
58 58   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-10-20 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 C5565489 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-09-30 00:00:00   0 1918 19000 1918 0 OPA Director of Community Collaboration n                                                 0 0 0 1918
59 59   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-10-20 00:00:00 2012-10-01 00:00:00 2012-10-20 00:00:00 2012-11-06 00:00:00     LOAN B1 C5565492 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-10-02 00:00:00   250 250 19000 0 0 OPA Director of Community Collaboration n                                                 0 0 0 250
60 60 1350016 Len Raphael for City Council 2012 0 CTL 2012-10-03 00:00:00 2012-01-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY93 IND Raphael Leonard         Oakland CA 94618 2012-07-26 00:00:00   300 300 21364.96 0 0.00% Raphael & Associates Certified Public Accountant n                                       PAY93         0 0 0 300
61 61 1350016 Len Raphael for City Council 2012 0 CTL 2012-10-03 00:00:00 2012-01-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY96 IND Raphael Leonard         Oakland CA 94618 2012-08-16 00:00:00   100 100 21364.96 0 0.00% Raphael & Associates Certified Public Accountant n                                                 0 0 0 100
62 62 1350016 Len Raphael for City Council 2012 0 CTL 2012-10-03 00:00:00 2012-01-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 PAY5 IND Raphael Leonard         Oakland CA 94618 2012-08-28 00:00:00   25000 17000 21364.96 0   Raphael & Associates Certified Public Accountant n                                                 8000 0 0 25000
63 63 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-10-05 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 B1-21 IND Muhammad Derrick         Oakland CA 94607 2011-12-01 00:00:00 01/01/2013 0 1000 648 1000 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 1000
64 64 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-10-05 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 B1-30 IND Muhammad Derrick         Oakland CA 94607 2012-01-27 00:00:00 01/26/2013 0 223 648 223 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 223
65 65 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-10-05 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 B1-122 IND Muhammad Derrick         Oakland CA 94607 2012-03-29 00:00:00 03/29/2013 0 100 648 100 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 100
66 66 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-10-05 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 B1-120 IND Muhammad Derrick         Oakland CA 94607 2012-06-11 00:00:00 06/13/2013 0 325 648 325 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 325
67 67 1346638 Committee to Elect Don Link to City Council 0 CTL 2012-10-05 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 12266751 IND Link Gordon 'Don'         Oakland CA 94609 2012-07-01 00:00:00   15900 15900 15900 0 0.00 %     n                                                 0 0   15900
68 68   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 C5302656 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-07-06 00:00:00   410 410 18750 0 0 OPA Director of Community Collaboration n                                                 0 0 0 410
69 69   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 C5332310 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-07-19 00:00:00   2000 2000 18750 0 0 OPA Director of Community Collaboration n                                                 0 0 0 2000
70 70   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 C5565490 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-09-21 00:00:00   2000 2000 18750 0 0 OPA Director of Community Collaboration n                                                 0 0 0 2000
71 71   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 C5565491 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-09-29 00:00:00   422 422 18750 0 0 OPA Director of Community Collaboration n                                                 0 0 0 422
72 72   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 C5565488 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-09-30 00:00:00   12000 12000 18750 0 0 OPA Director of Community Collaboration n                                                 0 0 0 12000
73 73   Friends of Nyeisha Dewitt for City Council 2012 0 CTL 2012-09-30 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00 2012-11-06 00:00:00     LOAN B1 C5565489 IND DeWitt Nyeisha         Oakland CA 94612-2332 2012-09-30 00:00:00   1918 1918 18750 0 0 OPA Director of Community Collaboration n                                                 0 0 0 1918
74 74 1343715 Dan Kalb for City Council 2012 0 CTL 2012-10-05 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 11805394 IND Kalb Dan         Oakland CA 94618 2012-01-27 00:00:00   0 4500 10825 4500 0.00 % Self-employed, No Separate Business Name Environmental Consultant n                                                 0 0   4500
75 75 1343715 Dan Kalb for City Council 2012 0 CTL 2012-10-05 00:00:00 2012-07-01 00:00:00 2012-09-30 00:00:00       LOAN B1 11805424 IND Kalb Dan         Oakland CA 94618 2012-06-15 00:00:00   0 4500 10825 4500 0.00 % Self-employed, No Separate Business Name Environmental Consultant n                                                 0 0   4500
76 76 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-07-31 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 B1-21 IND Muhammad Derrick         Oakland CA 94607 2011-12-01 00:00:00 01/01/2013 0 1000 648 1000 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 1000
77 77 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-07-31 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 B1-30 IND Muhammad Derrick         Oakland CA 94607 2012-01-27 00:00:00 01/26/2013 223 223 648 0 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 223
78 78 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-07-31 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 B1-122 IND Muhammad Derrick         Oakland CA 94607 2012-03-29 00:00:00 03/29/2013 100 100 648 0 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 100
79 79 1342709 Derrick H Muhammad for City Council 2012 0 CTL 2012-07-31 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 B1-120 IND Muhammad Derrick         Oakland CA 94607 2012-06-11 00:00:00 06/13/2013 325 325 648 0 0 Pacific Maritime Assn/ILWU Longshoreman n                                                 0 0 0 325
80 80 1343715 Dan Kalb for City Council 2012 0 CTL 2012-07-31 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 11805394 IND Kalb Dan         Oakland CA 94618 2012-01-27 00:00:00   4500 4500 9425 0 0.00 % Self-employed, No Separate Business Name Environmental Consultant n                                                 0 0   4500
81 81 1343715 Dan Kalb for City Council 2012 0 CTL 2012-07-31 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 11805424 IND Kalb Dan         Oakland CA 94618 2012-06-15 00:00:00   4500 4500 9425 0 0.00 % Self-employed, No Separate Business Name Environmental Consultant n                                                 0 0   4500
82 82 1313157 Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee 0 RCP 2012-07-20 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 PAY2 OTH Oakland Chamber of Commerce           Oakland CA 94612 2008-10-21 00:00:00   0 500 447.18 500       n                                                 0 0 0 500
83 83 1313157 Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee 0 RCP 2012-07-20 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 PAY4 OTH Oakland Chamber of Commerce           Oakland CA 94612 2008-10-28 00:00:00   0 1030 447.18 1030       n                                                 0 0 0 1030
84 84 1313157 Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee 0 RCP 2012-07-20 00:00:00 2012-01-01 00:00:00 2012-06-30 00:00:00       LOAN B1 PAY20 OTH Oakland Chamber of Commerce           Oakland CA 94612 2008-12-16 00:00:00   0 2615.33 447.18 2615.33 0.00%     n                                                 0 0 0 2615.33
85 85 1344614 Moving Oakland Forward 0 BMC 2012-07-15 00:00:00 2012-04-01 00:00:00 2012-06-30 00:00:00       LOAN B1 PAY37 IND Navarro Sofia         Alameda CA 94501 2012-03-09 00:00:00   0 0 0 500   Unity Advisors Workforce Development Director n                                                 500 0 0 500
86 86 1236617 Desley Brooks 1 CTL 2014-01-30 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00       LOAN B1 SyHX5sE7mgiO OTH Desley Brooks           Oakland CA 94612 2013-03-29 00:00:00   2500 2500 2500 0       n 1236617                                               0 0 0 2500
87 87 1362261 Libby Schaaf for Oakland Mayor 2014 2 CTL 2014-02-19 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       LOAN B1 VNHZWC2RJX9 IND Schaaf Libby         Oakland CA 94602-1856 2013-11-24 00:00:00 12/31/2014 1050 1050 1050 0 0 City of Oakland City Council Member n 1362261                                               0 0 0 1050
88 88 1362261 Libby Schaaf for Oakland Mayor 2014 1 CTL 2014-02-19 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       LOAN B1 VNHZWC2RJX9 IND Schaaf Libby         Oakland CA 94602-1856 2013-11-24 00:00:00   1050 1050 1050 0 0 City of Oakland City Council Member n 1362261                                               0 0 0 1050
89 89 1348648 Tolbert for City Council 2012 0 CTL 2014-02-28 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 OXW6sbnOaEAH IND Tolbert Dr. Joel         Oakland CA 94608 2012-07-15 00:00:00   0 0 20509.04 12127       n                                                 0 12127 305.04 12127
90 90 1348648 Tolbert for City Council 2012 0 CTL 2014-02-28 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00 2012-11-06 00:00:00     LOAN B1 SkkIL1RcNANY IND Tolbert Dr. Joel         Oakland CA 94608 2012-09-15 00:00:00   0 0 20509.04 8077       n                                                 0 8077 0 8077
91 91 1348648 Tolbert for City Council 2012 0 CTL 2014-02-28 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00 2012-11-06 00:00:00     LOAN B1 OXW6sbnOaEAH IND Tolbert Dr. Joel         Oakland CA 94608 2012-07-15 00:00:00   0 12127 0 12127       n                                                 0 0 0 12127
92 92 1348648 Tolbert for City Council 2012 0 CTL 2014-02-28 00:00:00 2013-01-01 00:00:00 2013-06-30 00:00:00 2012-11-06 00:00:00     LOAN B1 SkkIL1RcNANY IND Tolbert Dr. Joel         Oakland CA 94608 2012-09-15 00:00:00   0 8077 0 8077       n                                                 0 0 0 8077
93 93 COAK-1536 Committee to Elect Michael V. Johnson City Council 2014 0 CAO 2014-01-31 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       LOAN B1 VN8V4C3XRD1 IND Johnson Michael         Oakland CA 94619-3714 2013-07-25 00:00:00   205 205 205 0 0 Abbott Diabetes Care Healthcare Adminstration n                                                 0 0 0 205
94 94 1342185 Barbara Parker for Oakland City Attorney 2012 0 CTL 2014-01-31 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       LOAN B1 eh6nbEcnttua IND Parker Barbara         Oakland CA 94602 2011-11-30 00:00:00   0 25993 -4000 25993   City of Oakland City Attorney n                                                 0 0 0 29993
95 95 1342185 Barbara Parker for Oakland City Attorney 2012 0 CTL 2014-01-31 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       LOAN B1 F8UL6fVs225J IND Parker Barbara         Oakland CA 94602 2012-09-30 00:00:00   0 10000 -4000 10000   City of Oakland City Attorney n                                                 0 0 0 10000
96 96 1342185 Barbara Parker for Oakland City Attorney 2012 0 CTL 2014-01-31 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       LOAN B1 yJ8Ta7qVpE6f IND Parker Barbara         Oakland CA 94602 2012-11-08 00:00:00   0 19993 -4000 19993   City of Oakland City Attorney n                                                 0 0 0 19993
97 97 1342416 Committee to Elect Lynette Gibson-McElhaney for Council 2012 0 CTL 2014-01-31 00:00:00 2013-01-01 00:00:00 2013-12-31 00:00:00       LOAN B1 nN8dQE5x4Vuj IND Gibson-McElhaney Lynette         Oakland CA 94609 2012-06-27 00:00:00 08/30/2013 0 0 -15250 15250 0 Neighborhood Housing Services, Inc. Executive Director n                                                 15250 0 0 15250
98 98 1313157 Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee 0 RCP 2014-01-02 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       LOAN B1 PAY2 OTH Oakland Chamber of Commerce           Oakland CA 94612 2008-10-21 00:00:00   0 500 0 500       n                                                 0 0 0 500
99 99 1313157 Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee 0 RCP 2014-01-02 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       LOAN B1 PAY4 OTH Oakland Chamber of Commerce           Oakland CA 94612 2008-10-28 00:00:00   0 1030 0 1030       n                                                 0 0 0 1030
100 100 1313157 Oakland Metropolitan Chamber of Commerce Independent Expenditure Committee 0 RCP 2014-01-02 00:00:00 2013-07-01 00:00:00 2013-12-31 00:00:00       LOAN B1 PAY20 OTH Oakland Chamber of Commerce           Oakland CA 94612 2008-12-16 00:00:00   0 2615.33 0 2615.33 0.00%     n                                                 0 0 0 2615.33

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "B1_Loans" (
"Filer_ID" INTEGER,
  "Filer_NamL" TEXT,
  "Report_Num" INTEGER,
  "Committee_Type" TEXT,
  "Rpt_Date" TEXT,
  "From_Date" TEXT,
  "Thru_Date" TEXT,
  "Elect_Date" TEXT,
  "tblCover_Office_Cd" INTEGER,
  "tblCover_Offic_Dscr" INTEGER,
  "Rec_Type" TEXT,
  "Form_Type" TEXT,
  "Tran_ID" TEXT,
  "Entity_Cd" TEXT,
  "Lndr_NamL" TEXT,
  "Lndr_NamF" TEXT,
  "Lndr_NamT" INTEGER,
  "Lndr_NamS" INTEGER,
  "Loan_Adr1" INTEGER,
  "Loan_Adr2" INTEGER,
  "Loan_City" TEXT,
  "Loan_ST" TEXT,
  "Loan_Zip4" INTEGER,
  "Loan_Date1" TEXT,
  "Loan_Date2" TEXT,
  "Loan_Amt1" INTEGER,
  "Loan_Amt2" INTEGER,
  "Loan_Amt3" INTEGER,
  "Loan_Amt4" INTEGER,
  "Loan_Rate" INTEGER,
  "Loan_EMP" TEXT,
  "Loan_OCC" TEXT,
  "Loan_Self" TEXT,
  "Cmte_ID" INTEGER,
  "Tres_NamL" INTEGER,
  "Tres_NamF" INTEGER,
  "Tres_NamT" INTEGER,
  "Tres_NamS" INTEGER,
  "Tres_Adr1" INTEGER,
  "Tres_Adr2" INTEGER,
  "Tres_City" INTEGER,
  "Tres_ST" INTEGER,
  "Tres_ZIP4" INTEGER,
  "B2Lender_Name-Inter_name" INTEGER,
  "Intr_NamF" INTEGER,
  "Intr_NamT" INTEGER,
  "Intr_NamS" INTEGER,
  "Intr_Adr1" INTEGER,
  "Intr_Adr2" INTEGER,
  "Intr_City" INTEGER,
  "Intr_ST" INTEGER,
  "Intr_ZIP4" INTEGER,
  "Memo_Code" INTEGER,
  "Memo_RefNo" INTEGER,
  "BakRef_TID" INTEGER,
  "XRef_SchNm" INTEGER,
  "XRef_Match" INTEGER,
  "Loan_Amt5" INTEGER,
  "Loan_Amt6" INTEGER,
  "Loan_Amt7" INTEGER,
  "Loan_Amt8" INTEGER
);