received_loans
Data source: B1_Loans
6 rows where filer_name = 524 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_start_date, report_end_date, transaction_id, entity_type, lender_last_name, city, state, zipcode, loan_start_date, amount_received, contributions_to_date, balance_at_period_start, amount_paid_in_period, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1677 | 1677 | 1478436 387 | Kanitha Matoury Oakland City Council District 2 524 | CTL | 2025-04-03 | 2025-01-01 | 2025-03-01 | 2025-04-15 | cT4PgEfGOVgq | IND | Matoury | Kanitha | Oakland | CA | 94612 | 2025-03-01 | 2077.1 | 2077.1 | 2202.1 | 0 | Self 228 | HM LLC | n | 0 | 0 | 0 | 2077.1 | ||||||
| 1678 | 1678 | 1478436 387 | Kanitha Matoury Oakland City Council District 2 524 | CTL | 2025-04-03 | 2025-01-01 | 2025-03-01 | 2025-04-15 | RhyrvdEXn55v | OTH | USAA Credit Card | San Antonio | TX | 78288 | 2025-03-01 | 5337.67 | 5337.67 | 5337.67 | 0 | n | 0 | 0 | 0 | 5337.67 | |||||||||
| 1681 | 1681 | 1478436 387 | Kanitha Matoury Oakland City Council District 2 524 | CTL | 2025-04-03 | 2025-03-02 | 2025-03-29 | 2025-04-15 | cT4PgEfGOVgq | IND | Matoury | Kanitha | Oakland | CA | 94612 | 2025-03-01 | 0 | 1077.1 | 7012.09 | 2077.1 | Self 228 | HM LLC | n | 1000 | 0 | 0 | 2077.1 | ||||||
| 1682 | 1682 | 1478436 387 | Kanitha Matoury Oakland City Council District 2 524 | CTL | 2025-04-03 | 2025-03-02 | 2025-03-29 | 2025-04-15 | RhyrvdEXn55v | OTH | USAA Credit Card | San Antonio | TX | 78288 | 2025-03-01 | 0 | 2337.67 | 2575.02 | 5337.67 | n | 3000 | 0 | 0 | 5337.67 | |||||||||
| 1683 | 1683 | 1478436 387 | Kanitha Matoury Oakland City Council District 2 524 | CTL | 2025-04-03 | 2025-03-02 | 2025-03-29 | 2025-04-15 | jUGL5vz4Ts8p | IND | Matoury | Kanitha | Oakland | CA | 94612 | 2025-03-29 | 5809.99 | 5809.99 | 7012.09 | 0 | Self 228 | HM LLC | n | 0 | 0 | 0 | 5809.99 | ||||||
| 1684 | 1684 | 1478436 387 | Kanitha Matoury Oakland City Council District 2 524 | CTL | 2025-04-03 | 2025-03-02 | 2025-03-29 | 2025-04-15 | CFNwY7C7uq5C | OTH | USAA Credit Card | San Antonio | TX | 78288 | 2025-03-29 | 237.35 | 237.35 | 2575.02 | 0 | n | 0 | 0 | 0 | 237.35 |
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");