received_loans
Data source: B1_Loans
5 rows where filer_name = 453 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_start_date, report_end_date, balance_at_period_start, amount_forgiven_in_period, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1538 | 1538 | 1463583 324 | SOS Oakland 453 | RCP | 2025-03-25 | 2024-01-01 | 2024-06-30 | PAY5 | OTH | The McConnell Group | Oakland | CA | 94612.0 | 2023-11-29 | 0 | 2793.5 | 2206.5 | 5000 | 0 | n | 0 | 2206.5 | 0 | 5000 | |||||||||
| 1583 | 1583 | 1463583 324 | SOS Oakland 453 | RCP | 2025-01-14 | 2024-10-20 | 2024-12-31 | PAY5 | OTH | The McConnell Group | Oakland | CA | 94612.0 | 2023-11-29 | 0 | 2793.5 | 2206.5 | 2793.5 | 0 | n | 0 | 0 | 0 | 5000 | |||||||||
| 1603 | 1603 | 1463583 324 | SOS Oakland 453 | RCP | 2024-10-20 | 2024-07-01 | 2024-10-19 | 2024-11-05 | PAY5 | OTH | The McConnell Group | Oakland | CA | 94612.0 | 2023-11-29 | 0 | 2793.5 | 2206.5 | 2793.5 | 0 | n | 0 | 0 | 0 | 5000 | ||||||||
| 1539 | 1539 | 1463583 324 | SOS Oakland 453 | RCP | 2024-08-08 | 2024-01-01 | 2024-06-30 | PAY5 | OTH | The McConnell Group | Oakland | CA | 94612.0 | 2023-11-29 | 0 | 2793.5 | 2206.5 | 5000 | 0 | n | 0 | 2206.5 | 0 | 5000 | |||||||||
| 1656 | 1656 | 1463583 324 | SOS Oakland 453 | RCP | 2024-07-21 | 2024-01-01 | 2024-06-30 | PAY5 | OTH | The McConnell Group | Oakland | CA | 94612.0 | 2023-11-29 | 0 | 2793.5 | 2206.5 | 5000 | 0 | n | 0 | 2206.5 | 0 | 5000 |
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");