received_loans
Data source: B1_Loans
8 rows where filer_name = 424 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, report_start_date, report_end_date, transaction_id, loan_start_date, amount_received, outstanding_balance, contributions_to_date, balance_at_period_start, original_amount, report_date (date), report_start_date (date), report_end_date (date), election_date (date), loan_start_date (date)
| Link | rowid | filer_id | filer_name | committee_type | report_date ▲ | report_start_date | report_end_date | election_date | transaction_id | entity_type | lender_last_name | lender_first_name | lender_prefix | lender_suffix | city | state | zipcode | loan_start_date | loan_due_date | amount_received | outstanding_balance | contributions_to_date | balance_at_period_start | interest_rate | lender_employer | lender_occupation | lender_self_employed | committee_id | memo_reference_number | amount_paid_in_period | amount_forgiven_in_period | interest_paid_in_period | original_amount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1570 | 1570 | 1462429 312 | Ryan Richardson for Oakland City Attorney 2024 424 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | PAY457 | IND | Richardson | Ryan | Oakland | CA | 94608.0 | 2024-09-20 | 0 | 38000 | 49500 | 38000 | 0 | City Of Oakland 2163 | Candidate / Lawyer | n | 0 | 0 | 0 | 38000 | |||||
| 1571 | 1571 | 1462429 312 | Ryan Richardson for Oakland City Attorney 2024 424 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | PAY798 | IND | Richardson | Ryan | Oakland | CA | 94608.0 | 2024-11-22 | 5000 | 5000 | 49500 | 0 | 0 | City Of Oakland 2163 | Candidate / Lawyer | n | 0 | 0 | 0 | 5000 | |||||
| 1572 | 1572 | 1462429 312 | Ryan Richardson for Oakland City Attorney 2024 424 | CTL | 2025-01-30 | 2024-10-20 | 2024-12-31 | 2024-11-05 | PAY800 | IND | Richardson | Ryan | Oakland | CA | 94608.0 | 2024-11-22 | 500 | 500 | 49500 | 0 | 0 | City Of Oakland 2163 | Candidate / Lawyer | n | 0 | 0 | 0 | 500 | |||||
| 1550 | 1550 | 1462429 312 | Ryan Richardson for Oakland City Attorney 2024 424 | CTL | 2024-12-20 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY457 | IND | Richardson | Ryan | Oakland | CA | 94608.0 | 2024-09-20 | 0 | 38000 | 44000 | 38000 | 0 | City Of Oakland 2163 | Candidate / Lawyer | n | 0 | 0 | 0 | 38000 | |||||
| 1542 | 1542 | 1462429 312 | Ryan Richardson for Oakland City Attorney 2024 424 | CTL | 2024-12-12 | 2024-07-01 | 2024-09-21 | 2024-11-05 | PAY457 | IND | Richardson | Ryan | Oakland | CA | 94608.0 | 2024-09-20 | 38000 | 38000 | 44000 | 0 | 0 | City Of Oakland 2163 | Candidate / Lawyer | n | 0 | 0 | 0 | 38000 | |||||
| 1551 | 1551 | 1462429 312 | Ryan Richardson for Oakland City Attorney 2024 424 | CTL | 2024-12-12 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY457 | IND | Richardson | Ryan | Oakland | CA | 94608.0 | 2024-09-20 | 0 | 38000 | 44000 | 38000 | 0 | City Of Oakland 2163 | Candidate / Lawyer | n | 0 | 0 | 0 | 38000 | |||||
| 1602 | 1602 | 1462429 312 | Ryan Richardson for Oakland City Attorney 2024 424 | CTL | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY457 | IND | Richardson | Ryan | Oakland | CA | 94608.0 | 2024-09-20 | 0 | 38000 | 44000 | 38000 | 0 | City Of Oakland 2163 | Candidate / Lawyer | n | 0 | 0 | 0 | 38000 | |||||
| 1623 | 1623 | 1462429 312 | Ryan Richardson for Oakland City Attorney 2024 424 | CTL | 2024-09-25 | 2024-07-01 | 2024-09-21 | 2024-11-05 | PAY457 | IND | Richardson | Ryan | Oakland | CA | 94608.0 | 2024-09-20 | 38000 | 38000 | 44000 | 0 | 0 | City Of Oakland 2163 | Candidate / Lawyer | n | 0 | 0 | 0 | 38000 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "received_loans" (
"filer_id" INTEGER,
"filer_name" INTEGER,
"committee_type" TEXT,
"report_date" TEXT,
"report_start_date" TEXT,
"report_end_date" TEXT,
"election_date" TEXT,
"transaction_id" TEXT,
"entity_type" TEXT,
"lender_last_name" TEXT,
"lender_first_name" TEXT,
"lender_prefix" INTEGER,
"lender_suffix" INTEGER,
"city" TEXT,
"state" TEXT,
"zipcode" TEXT,
"loan_start_date" TEXT,
"loan_due_date" TEXT,
"amount_received" INTEGER,
"outstanding_balance" INTEGER,
"contributions_to_date" INTEGER,
"balance_at_period_start" INTEGER,
"interest_rate" NUMERIC,
"lender_employer" INTEGER,
"lender_occupation" TEXT,
"lender_self_employed" TEXT,
"committee_id" INTEGER,
"memo_reference_number" INTEGER,
"amount_paid_in_period" INTEGER,
"amount_forgiven_in_period" INTEGER,
"interest_paid_in_period" INTEGER,
"original_amount" INTEGER
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id),
FOREIGN KEY ("lender_employer") REFERENCES [businesses](id));
CREATE INDEX ["received_loans_filer_id"] ON [received_loans]("filer_id");
CREATE INDEX ["received_loans_filer_name"] ON [received_loans]("filer_name");
CREATE INDEX ["received_loans_committee_id"] ON [received_loans]("committee_id");
CREATE INDEX ["received_loans_lender_employer"] ON [received_loans]("lender_employer");