accrued_expenses
Data source: F_Expenses
47 rows where filer_name = 79 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_zipcode, beginning_balance, amount_incurred, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
746 | 746 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY516 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 8733 | 0 | 0 | 8733 | Staff Time for Field Campaign; In-Kind to CAs for Economic Prosperity to Support Tim Sbranti for Assembly 2014 (#1364160) | PAY516 | |||||
747 | 747 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY564 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 87 | 0 | 0 | 87 | Auto Dialer for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
748 | 748 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY565 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 87 | 0 | 0 | 87 | Auto Dialer for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
749 | 749 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY566 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 39.9 | 0 | 0 | 39.9 | Office Space for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
750 | 750 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY567 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 39.9 | 0 | 0 | 39.9 | Office Space for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
751 | 751 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY568 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 3000 | 0 | 0 | 3000 | Field Campaign/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
752 | 752 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY569 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 3000 | 0 | 0 | 3000 | Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
753 | 753 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY609 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 177.2 | 0 | 0 | 177.2 | Staff Time & Food for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
754 | 754 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY610 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 177.2 | 0 | 0 | 177.2 | Staff Time & Food for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
755 | 755 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY603 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 6667.21 | 0 | 0 | 6667.21 | Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
756 | 756 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY604 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 6667.21 | 0 | 0 | 6667.21 | Field Campaign/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
757 | 757 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY605 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 59.85 | 0 | 0 | 59.85 | Office Space for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
758 | 758 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY606 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 59.85 | 0 | 0 | 59.85 | Office Space for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
759 | 759 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY607 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 515 | 0 | 0 | 515 | Staff Time & Food for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
760 | 760 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY608 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 515 | 0 | 0 | 515 | Staff Time & Food for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
761 | 761 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY611 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 87 | 0 | 0 | 87 | Auto Dialer for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
762 | 762 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY612 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 87 | 0 | 0 | 87 | Auto Dialer for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
763 | 763 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY625 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 0 | 1630 | 0 | 1630 | Staff Time, Food & Supplies for Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
764 | 764 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY626 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 0 | 1630 | 0 | 1630 | Staff Time, Food & Supplies for Field Campaign/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
765 | 765 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY627 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 2594.03 | 0 | 2594.03 | Auto Dialer, Office Rent, Food & Supplies for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | ||||||
766 | 766 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2015-01-28 | 2014-10-19 | 2014-12-31 | PAY628 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 2594.03 | 0 | 2594.03 | Auto Dialer, Office Rent, Food & Supplies for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | ||||||
908 | 908 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY516 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 8733 | 0 | 0 | 8733 | Staff Time for Field Campaign; In-Kind to CAs for Economic Prosperity to Support Tim Sbranti for Assembly 2014 (#1364160) | PAY516 | ||||
909 | 909 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY564 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 87 | 0 | 0 | 87 | Auto Dialer for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | |||||
910 | 910 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY565 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 87 | 0 | 0 | 87 | Auto Dialer for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
911 | 911 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY566 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 39.9 | 0 | 0 | 39.9 | Office Space for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
912 | 912 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY567 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 39.9 | 0 | 0 | 39.9 | Office Space for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | |||||
913 | 913 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY568 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 3000 | 0 | 0 | 3000 | Field Campaign/Support/Abel Guillen/Oakland City Council/District 2 | |||||
914 | 914 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY569 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 3000 | 0 | 0 | 3000 | Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
915 | 915 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY609 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 177.2 | 0 | 0 | 177.2 | Staff Time & Food for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | |||||
916 | 916 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY610 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 177.2 | 0 | 0 | 177.2 | Staff Time & Food for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
917 | 917 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY603 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 0 | 6667.21 | 0 | 6667.21 | Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
918 | 918 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY604 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 0 | 6667.21 | 0 | 6667.21 | Field Campaign/Support/Abel Guillen/Oakland City Council/District 2 | |||||
919 | 919 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY605 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 59.85 | 0 | 59.85 | Office Space for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | |||||
920 | 920 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY606 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 59.85 | 0 | 59.85 | Office Space for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
921 | 921 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY607 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 515 | 0 | 515 | Staff Time & Food for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
922 | 922 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY608 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 515 | 0 | 515 | Staff Time & Food for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | |||||
923 | 923 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY611 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 87 | 0 | 87 | Auto Dialer for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
924 | 924 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-23 | 2014-10-01 | 2014-10-18 | 2014-11-04 | PAY612 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 87 | 0 | 87 | Auto Dialer for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | |||||
1041 | 1041 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-06 | 2014-07-01 | 2014-09-30 | 2014-11-04 | PAY516 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 8733 | 0 | 0 | 8733 | Staff Time for Field Campaign; In-Kind to CAs for Economic Prosperity to Support Tim Sbranti for Assembly 2014 (#1364160) | PAY516 | ||||
1042 | 1042 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-06 | 2014-07-01 | 2014-09-30 | 2014-11-04 | PAY564 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 87 | 0 | 87 | Auto Dialer for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | |||||
1043 | 1043 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-06 | 2014-07-01 | 2014-09-30 | 2014-11-04 | PAY565 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 87 | 0 | 87 | Auto Dialer for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
1044 | 1044 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-06 | 2014-07-01 | 2014-09-30 | 2014-11-04 | PAY566 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 39.9 | 0 | 39.9 | Office Space for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
1045 | 1045 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-06 | 2014-07-01 | 2014-09-30 | 2014-11-04 | PAY567 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 39.9 | 0 | 39.9 | Office Space for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | |||||
1046 | 1046 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-06 | 2014-07-01 | 2014-09-30 | 2014-11-04 | PAY568 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 0 | 3000 | 0 | 3000 | Field Campaign/Support/Abel Guillen/Oakland City Council/District 2 | |||||
1047 | 1047 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-06 | 2014-07-01 | 2014-09-30 | 2014-11-04 | PAY569 | OTH | GroundWorks Campaigns, Inc. | Sacramento | CA | 95815 | 0 | 3000 | 0 | 3000 | Field Campaign/Support/Annie Campbell Washington/Oakland City Council/District 4 | |||||
1048 | 1048 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-06 | 2014-07-01 | 2014-09-30 | 2014-11-04 | PAY609 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 177.2 | 0 | 177.2 | Staff Time & Food for Phonebanking/Support/Abel Guillen/Oakland City Council/District 2 | |||||
1049 | 1049 | 1294190 81 | Unity PAC to Elect Guillen and Campbell Washington for City Council 2014, sponsored by Alameda Labor Council, AFL-CIO 79 | RCP | 2014-10-06 | 2014-07-01 | 2014-09-30 | 2014-11-04 | PAY610 | OTH | Alameda Labor Council, AFL-CIO | Oakland | CA | 94621 | 0 | 177.2 | 0 | 177.2 | Staff Time & Food for Phonebanking/Support/Annie Campbell Washington/Oakland City Council/District 4 |
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");