accrued_expenses
Data source: F_Expenses
10 rows where filer_name = 477 sorted by report_date descending
This data as json, CSV (advanced)
Suggested facets: report_date, report_start_date, report_end_date, transaction_id, payee_last_name, payee_city, payee_state, payee_zipcode, beginning_balance, amount_incurred, amount_paid, ending_balance, expenditure_description, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8428 | 8428 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-31 | 2024-10-20 | 2024-10-31 | PAY1 | OTH | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP | SACRAMENTO | CA | 95814 | 1500 | 0 | 1500 | 0 | |||||||
| 8429 | 8429 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-31 | 2024-10-20 | 2024-10-31 | PAY19 | OTH | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP | SACRAMENTO | CA | 95814 | 6063.51 | 0 | 6063.51 | 0 | |||||||
| 8430 | 8430 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-31 | 2024-10-20 | 2024-10-31 | PAY13 | OTH | LUMINARY INTELLIGENCE, INC. | AUSTIN | TX | 78745 | 10000 | 0 | 10000 | 0 | DIGITAL ADS/OPPOSE/C. FIFE/OAKLAND CITY CO. DIST 3;SEE SCHEDULE G | ||||||
| 7853 | 7853 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY1 | OTH | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP | Sacramento | CA | 95814 | 3000 | 0 | 1500 | 1500 | ||||||
| 7854 | 7854 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY2 | OTH | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP | Sacramento | CA | 95814 | 6105 | 0 | 6105 | 0 | ||||||
| 7855 | 7855 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY19 | OTH | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP | Sacramento | CA | 95814 | 0 | 6063.51 | 0 | 6063.51 | ||||||
| 7856 | 7856 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY13 | OTH | LUMINARY INTELLIGENCE, INC. | Austin | TX | 78745 | 0 | 10000 | 0 | 10000 | SEE SCHEDULE D AND G IN NEXT PERIOD | |||||
| 8574 | 8574 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY1 | OTH | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP | Sacramento | CA | 95814 | 3000 | 0 | 1500 | 1500 | ||||||
| 8575 | 8575 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY2 | OTH | NIELSEN MERKSAMER PARRINELLO GROSS & LEONI LLP | Sacramento | CA | 95814 | 6105 | 0 | 6105 | 0 | ||||||
| 8576 | 8576 | 1474607 352 | OAKLANDERS FOR COMMON SENSE, UNITED TO FIRE CARROLL FIFE AND ELECT WARREN LOGAN FOR CITY COUNCIL 2024 477 | RCP | 2024-10-24 | 2024-09-22 | 2024-10-19 | 2024-11-05 | PAY13 | OTH | LUMINARY INTELLIGENCE, INC. | Austin | TX | 78745 | 0 | 10000 | 0 | 10000 | SEE SCHEDULE D AND G IN NEXT PERIOD |
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");