accrued_expenses
Data source: F_Expenses
11 rows where filer_name = 372 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: beginning_balance, amount_incurred, ending_balance, report_date (date), report_start_date (date), report_end_date (date), election_date (date)
| Link | rowid | filer_id | filer_name | committee_type | report_date ▲ | report_start_date | report_end_date | election_date | transaction_id | entity_type | payee_last_name | payee_first_name | payee_prefix | payee_suffix | payee_city | payee_state | payee_zipcode | beginning_balance | amount_incurred | amount_paid | ending_balance | expenditure_description | committee_id | memo_reference_number |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7036 | 7036 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | 4hMC9iRuhlXh | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 1700 | 0 | 1700 | Boy Scouts contribution for Troop 97 recharter | 1.45344e+06 1092 | ||||
| 7037 | 7037 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | 5VHWLNTVo7cY | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 1300 | 0 | 1300 | Cub Scouts contribution for recharter | 1.45344e+06 1092 | ||||
| 7038 | 7038 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | wYqBTwlFpE3k | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 1000 | 0 | 1000 | Contribution to Montera Wood Project c/o Troop #305 | 1.45344e+06 1092 | ||||
| 7039 | 7039 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | CQve5XluybCU | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 1500 | 0 | 1500 | Financial Reporting services | 1.45344e+06 1092 | ||||
| 7040 | 7040 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | eYI4D9ehcg44 | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 7500 | 0 | 7500 | Consulting Fee | 1.45344e+06 1092 | ||||
| 7041 | 7041 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | PmzF7PAlWP6g | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 3500 | 0 | 3500 | Campaign volunteer appreciation event | 1.45344e+06 1092 | ||||
| 7042 | 7042 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | Cg2WjBt4nnCb | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 1106.3 | 0 | 1106.3 | Campaign Signs | 1.45344e+06 1092 | ||||
| 7043 | 7043 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | nfiRPub9kAqL | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 1470 | 0 | 1470 | Campaign Literature | 1.45344e+06 1092 | ||||
| 7044 | 7044 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | QVTL14l1QRFX | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 1000 | 0 | 1000 | Consultant Fee | 1.45344e+06 1092 | ||||
| 7045 | 7045 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | ftSY3ehPaaTz | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 0 | 375.64 | 0 | 375.64 | T-shirts | 1.45344e+06 1092 | ||||
| 7046 | 7046 | 1453436 288 | LOWE FOR CITY COUNCIL 2022 372 | CTL | 2024-08-02 | 2022-10-23 | 2023-01-01 | 2022-11-07 | BHITJbqtyAdP | COM | LOWE FOR CITY COUNCIL 2022 | Oakland | CA | 94606 | 176 | 0 | 0 | 176 | Banking Fees | 1.45344e+06 1092 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "accrued_expenses" (
"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,
"payee_last_name" TEXT,
"payee_first_name" INTEGER,
"payee_prefix" INTEGER,
"payee_suffix" INTEGER,
"payee_city" TEXT,
"payee_state" TEXT,
"payee_zipcode" TEXT,
"beginning_balance" INTEGER,
"amount_incurred" INTEGER,
"amount_paid" INTEGER,
"ending_balance" INTEGER,
"expenditure_description" TEXT,
"committee_id" INTEGER,
"memo_reference_number" 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));
CREATE INDEX ["accrued_expenses_filer_id"] ON [accrued_expenses]("filer_id");
CREATE INDEX ["accrued_expenses_filer_name"] ON [accrued_expenses]("filer_name");
CREATE INDEX ["accrued_expenses_committee_id"] ON [accrued_expenses]("committee_id");