H_Loans
29 rows
This data as json, CSV (advanced)
Suggested facets: Filer_ID, Filer_NamL, Report_Num, Committee_Type, Rpt_Date, From_Date, Thru_Date, Tran_ID, Entity_Cd, Lndr_NamL, Loan_City, Loan_Zip4, Loan_Date1, Loan_Amt1, Loan_Amt2, Loan_Amt3, Loan_Amt4, Cmte_ID, Loan_Amt5, Loan_Amt6, Loan_Amt8, 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 | 1361954 | Dan Kalb City Council Officeholder Committee | 0 | CTL | 2015-01-25 00:00:00 | 2014-07-01 00:00:00 | 2014-12-31 00:00:00 | LOAN | H | bxunwSAvnJll | COM | Oaklanders for Good Government & Safe Neighborhoods, a Kalb Committee for YES on CC and YES on Z | Oakland | CA | 94618 | 2014-10-07 00:00:00 | 1100.0 | 1100.0 | 3081.08 | 0.0 | n | 1372103 | 0.0 | 0.0 | 0.0 | 1100.0 | |||||||||||||||||||||||||||||||||||
| 2 | 2 | 1361954 | Dan Kalb City Council Officeholder 2013 | 0 | CTL | 2015-07-31 00:00:00 | 2015-01-01 00:00:00 | 2015-06-30 00:00:00 | LOAN | H | bxunwSAvnJll | COM | Oaklanders for Good Government & Safe Neighborhoods, a Kalb Committee for YES on CC and YES on Z | Oakland | CA | 94618 | 2014-10-07 00:00:00 | 0.0 | 0.0 | 928.85 | 1100.0 | n | 1372103 | 171.15 | 928.85 | 0.0 | 1100.0 | |||||||||||||||||||||||||||||||||||
| 3 | 3 | 1385949 | Causa Justa :: Just Cause (nonprofit 501(c)(3)) | 1 | BMC | 2016-08-12 00:00:00 | 2016-01-01 00:00:00 | 2016-06-30 00:00:00 | LOAN | H | mOB3ZtXwQm61 | COM | Committee to Protect Oakland Renters | Sacramento | CA | 95814 | 2016-04-19 00:00:00 | 07/25/2016 | 35000.0 | 35000.0 | 68999.63 | 0.0 | 0.0 | n | 1364564 | 0.0 | 0.0 | 0.0 | 35000.0 | |||||||||||||||||||||||||||||||||
| 4 | 4 | 1385949 | Causa Justa :: Just Cause (nonprofit 501(c)(3)) | 1 | BMC | 2016-10-05 00:00:00 | 2016-07-01 00:00:00 | 2016-09-24 00:00:00 | 2016-11-08 00:00:00 | LOAN | H | pRBOH2CrIoGY | COM | Committee to Protect Oakland Renters | Sacramento | CA | 95814 | 2016-04-19 00:00:00 | 0.0 | 0.0 | 140803.58 | 35000.0 | n | 1364564 | 0.0 | 35000.0 | 0.0 | 35000.0 | ||||||||||||||||||||||||||||||||||
| 5 | 5 | 1385949 | Causa Justa :: Just Cause (nonprofit 501(c)(3)) | 0 | BMC | 2016-09-29 00:00:00 | 2016-07-01 00:00:00 | 2016-09-24 00:00:00 | 2016-11-08 00:00:00 | LOAN | H | pRBOH2CrIoGY | COM | Committee to Protect Oakland Renters | Sacramento | CA | 95814 | 2016-04-19 00:00:00 | 0.0 | 0.0 | 141948.53 | 35000.0 | n | 1364564 | 0.0 | 35000.0 | 0.0 | 35000.0 | ||||||||||||||||||||||||||||||||||
| 6 | 6 | 1385949 | Causa Justa :: Just Cause (nonprofit 501(c)(3)) | 0 | BMC | 2016-07-27 00:00:00 | 2016-01-01 00:00:00 | 2016-06-30 00:00:00 | 2016-11-08 00:00:00 | LOAN | H | mOB3ZtXwQm61 | COM | Committee to Protect Oakland Renters | Sacramento | CA | 95814 | 2016-04-19 00:00:00 | 07/25/2016 | 35000.0 | 35000.0 | 68999.63 | 0.0 | 0.0 | n | 1364564 | 0.0 | 0.0 | 0.0 | 35000.0 | ||||||||||||||||||||||||||||||||
| 7 | 7 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-28 00:00:00 | 2018-01-01 00:00:00 | 2018-06-30 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612 | 2018-06-29 00:00:00 | 1580.0 | 1580.0 | 1580.0 | 0.0 | UC Berkeley | Assistant Dean | n | 0.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 8 | 8 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2018-07-01 00:00:00 | 2018-12-31 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612 | 2018-06-29 00:00:00 | 0.0 | 1550.0 | 1580.0 | 1580.0 | UC Berkeley | Assistant Dean | n | 30.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 9 | 9 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2019-01-01 00:00:00 | 2019-06-30 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612 | 2018-06-29 00:00:00 | 0.0 | 1550.0 | 0.0 | 1550.0 | UC Berkeley | Assistant Dean | n | 0.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 10 | 10 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2019-07-01 00:00:00 | 2019-12-31 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612 | 2018-06-29 00:00:00 | 0.0 | 1450.0 | 0.0 | 1550.0 | UC Berkeley | Assistant Dean | n | 100.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 11 | 11 | 1428904 | Committee for an Affordable East Bay | 1 | RCP | 2021-07-16 00:00:00 | 2020-10-18 00:00:00 | 2020-12-31 00:00:00 | LOAN | H | RCV57 | OTH | East Bay Voter Guide for More Homes | Oakland | CA | 94607 | 2020-10-27 00:00:00 | 4400.0 | 0.0 | 4400.0 | 0.0 | n | 1431737.0 | RCV57 | 4400.0 | 0.0 | 0.0 | 4400.0 | ||||||||||||||||||||||||||||||||||
| 12 | 12 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2020-01-01 00:00:00 | 2020-06-30 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612 | 2018-06-29 00:00:00 | 0.0 | 1380.0 | 0.0 | 1450.0 | UC Berkeley | Assistant Dean | n | 70.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 13 | 13 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-12-31 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612 | 2018-06-29 00:00:00 | 0.0 | 1195.0 | 0.0 | 1380.0 | UC Berkeley | Assistant Dean | n | 185.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 14 | 14 | 1428904 | Committee for an Affordable East Bay supporting Derreck Johnson and opposing Rebecca Kaplan for Oakland City Council At-Large 2020 | 0 | BMC | 2021-01-21 00:00:00 | 2020-10-18 00:00:00 | 2020-12-31 00:00:00 | LOAN | H | RCV57 | OTH | East Bay Voter Guide for More Homes | Oakland | CA | 94607 | 2020-10-27 00:00:00 | 4400.0 | 0.0 | 4400.0 | 0.0 | n | 1431737.0 | RCV57 | 4400.0 | 0.0 | 0.0 | 4400.0 | ||||||||||||||||||||||||||||||||||
| 15 | 15 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2021-01-01 00:00:00 | 2021-06-30 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612.0 | 2018-06-29 00:00:00 | 0.0 | 1015.0 | 0.0 | 1195.0 | UC Berkeley | Assistant Dean | n | 180.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 16 | 16 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 | LOAN | H | tjHeinicRtes | OTH | Annie Campbell Washington | 2021-12-01 00:00:00 | 100.0 | 100.0 | 100.0 | 0.0 | n | 0.0 | 0.0 | 0.0 | 100.0 | |||||||||||||||||||||||||||||||||||||||
| 17 | 17 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2021-07-01 00:00:00 | 2021-12-31 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612.0 | 2018-06-29 00:00:00 | 0.0 | 1015.0 | 0.0 | 1015.0 | UC Berkeley | Assistant Dean | n | 0.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 18 | 18 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2022-01-01 00:00:00 | 2022-06-30 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612.0 | 2018-06-29 00:00:00 | 0.0 | 970.0 | 0.0 | 1015.0 | UC Berkeley | Assistant Dean | n | 45.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 19 | 19 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-06-30 00:00:00 | 2022-01-01 00:00:00 | 2022-06-30 00:00:00 | LOAN | H | tjHeinicRtes | OTH | Annie Campbell Washington | 2021-12-01 00:00:00 | 0.0 | 100.0 | 0.0 | 100.0 | n | 0.0 | 0.0 | 0.0 | 100.0 | |||||||||||||||||||||||||||||||||||||||
| 20 | 20 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-12-31 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612.0 | 2018-06-29 00:00:00 | 0.0 | 970.0 | 0.0 | 970.0 | UC Berkeley | Assistant Dean | n | 0.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 21 | 21 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-07-01 00:00:00 | 2022-07-01 00:00:00 | 2022-12-31 00:00:00 | LOAN | H | amFjfyoffyw7 | IND | Campbell Washington | Anne | Oakland | CA | 94612.0 | 2021-12-01 00:00:00 | 0.0 | 45.0 | 0.0 | 100.0 | UC Berkeley | Assistant Dean | n | 55.0 | 0.0 | 0.0 | 100.0 | |||||||||||||||||||||||||||||||||
| 22 | 22 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-07-01 00:00:00 | 2023-01-01 00:00:00 | 2023-06-30 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612 | 2018-06-29 00:00:00 | 0.0 | 960.39 | 0.0 | 970.0 | UC Berkeley | Assistant Dean | n | 9.61 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 23 | 23 | 1365610 | Annie Campbell Washington 2014 Officeholder Committee | 1 | CTL | 2024-07-01 00:00:00 | 2023-07-01 00:00:00 | 2023-12-31 00:00:00 | LOAN | H | lNbIugPKrI5I | IND | Campbell Washington | Anne | Oakland | CA | 94612 | 2018-06-29 00:00:00 | 0.0 | 900.39 | 0.0 | 960.39 | UC Berkeley | Assistant Dean | n | 60.0 | 0.0 | 0.0 | 1580.0 | |||||||||||||||||||||||||||||||||
| 24 | 24 | 1467180 | Foundational Oakland Unites (nonprofit 501(c)(4)) | 0 | RCP | 2025-01-31 00:00:00 | 2024-10-20 00:00:00 | 2024-12-31 00:00:00 | LOAN | H | RCV6 | COM | Oakland United To Recall Sheng Thao | Oakland | CA | 94607 | 2024-04-09 00:00:00 | 0.0 | 3000.0 | 13000.0 | 3000.0 | 0.0 | n | 1466653 | 0.0 | 0.0 | 0.0 | 3000.0 | ||||||||||||||||||||||||||||||||||
| 25 | 25 | 1467180 | Foundational Oakland Unites (nonprofit 501(c)(4)) | 0 | RCP | 2025-01-31 00:00:00 | 2024-10-20 00:00:00 | 2024-12-31 00:00:00 | LOAN | H | RCV8 | COM | Oakland United To Recall Sheng Thao | Oakland | CA | 94607 | 2024-05-23 00:00:00 | 0.0 | 10000.0 | 13000.0 | 10000.0 | 0.0 | n | 1466653 | 0.0 | 0.0 | 0.0 | 10000.0 | ||||||||||||||||||||||||||||||||||
| 26 | 26 | 1467180 | Foundational Oakland Unites (nonprofit 501(c)(4)) | 0 | RCP | 2024-10-24 00:00:00 | 2024-07-01 00:00:00 | 2024-10-19 00:00:00 | LOAN | H | RCV6 | COM | Oakland United To Recall Sheng Thao | Oakland | CA | 94607 | 2024-04-09 00:00:00 | 0.0 | 3000.0 | 13000.0 | 3000.0 | 0.0 | n | 1466653 | 0.0 | 0.0 | 0.0 | 3000.0 | ||||||||||||||||||||||||||||||||||
| 27 | 27 | 1467180 | Foundational Oakland Unites (nonprofit 501(c)(4)) | 0 | RCP | 2024-10-24 00:00:00 | 2024-07-01 00:00:00 | 2024-10-19 00:00:00 | LOAN | H | RCV8 | COM | Oakland United To Recall Sheng Thao | Oakland | CA | 94607 | 2024-05-23 00:00:00 | 0.0 | 10000.0 | 13000.0 | 10000.0 | 0.0 | n | 1466653 | 0.0 | 0.0 | 0.0 | 10000.0 | ||||||||||||||||||||||||||||||||||
| 28 | 28 | 1467180 | Foundational Oakland Unites (nonprofit 501(c)(4)) | 0 | RCP | 2024-07-25 00:00:00 | 2024-01-01 00:00:00 | 2024-06-30 00:00:00 | LOAN | H | RCV6 | COM | Oakland United To Recall Sheng Thao | Oakland | CA | 94607 | 2024-04-09 00:00:00 | 3000.0 | 3000.0 | 13000.0 | 0.0 | 0.0 | n | 1466653 | 0.0 | 0.0 | 0.0 | 3000.0 | ||||||||||||||||||||||||||||||||||
| 29 | 29 | 1467180 | Foundational Oakland Unites (nonprofit 501(c)(4)) | 0 | RCP | 2024-07-25 00:00:00 | 2024-01-01 00:00:00 | 2024-06-30 00:00:00 | LOAN | H | RCV8 | COM | Oakland United To Recall Sheng Thao | Oakland | CA | 94607 | 2024-05-23 00:00:00 | 10000.0 | 10000.0 | 13000.0 | 0.0 | 0.0 | n | 1466653 | 0.0 | 0.0 | 0.0 | 10000.0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "H_Loans" ( "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, "Lndr_NamL" TEXT, "Lndr_NamF" TEXT, "Lndr_NamT" TEXT, "Lndr_NamS" TEXT, "Loan_Adr1" TEXT, "Loan_Adr2" TEXT, "Loan_City" TEXT, "Loan_ST" TEXT, "Loan_Zip4" TEXT, "Loan_Date1" TEXT, "Loan_Date2" TEXT, "Loan_Amt1" TEXT, "Loan_Amt2" TEXT, "Loan_Amt3" TEXT, "Loan_Amt4" TEXT, "Loan_Rate" TEXT, "Loan_EMP" TEXT, "Loan_OCC" TEXT, "Loan_Self" 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, "B2Lender_Name-Inter_name" TEXT, "Intr_NamF" TEXT, "Intr_NamT" TEXT, "Intr_NamS" TEXT, "Intr_Adr1" TEXT, "Intr_Adr2" TEXT, "Intr_City" TEXT, "Intr_ST" TEXT, "Intr_ZIP4" TEXT, "Memo_Code" TEXT, "Memo_RefNo" TEXT, "BakRef_TID" TEXT, "XRef_SchNm" TEXT, "XRef_Match" TEXT, "Loan_Amt5" TEXT, "Loan_Amt6" TEXT, "Loan_Amt7" TEXT, "Loan_Amt8" TEXT );