home / election_finance

accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

139 rows where filer_id = 109 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, transaction_id, entity_type, payee_last_name, payee_first_name, payee_city, payee_zipcode, amount_paid, 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
5607 5607 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY205 OTH Deane & Company       Sacramento CA 95815 185.42 0 185.42 0      
5608 5608 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY253 OTH Deane & Company       Sacramento CA 95815 1069.92 0 1069.92 0      
5609 5609 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY273 OTH Deane & Company       Sacramento CA 95815 1194.86 0 1194.86 0      
5610 5610 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY281 OTH Deane & Company       Sacramento CA 95815 1222.3 0 626.2 596.1      
5611 5611 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY284 OTH Deane & Company       Sacramento CA 95815 1907.48 0 0 1907.48      
5612 5612 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY285 OTH Deane & Company       Sacramento CA 95815 1866.3 0 0 1866.3      
5613 5613 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY288 OTH Deane & Company       Sacramento CA 95815 1867.25 0 0 1867.25      
5614 5614 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY289 OTH Deane & Company       Sacramento CA 95815 1715.1 0 0 1715.1      
5615 5615 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY292 OTH Deane & Company       Sacramento CA 95815 989.3 0 0 989.3      
5616 5616 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY306 OTH Deane & Company       Sacramento CA 95815 211.75 0 0 211.75      
5617 5617 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-02-17 2021-01-01 2021-02-17   PAY307 OTH Deane & Company       Sacramento CA 95815 126 0 0 126      
4727 4727 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 506.74 185.42      
4728 4728 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY253 OTH Deane & Company       Sacramento CA 95815 1069.92 0 0 1069.92      
4729 4729 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY273 OTH Deane & Company       Sacramento CA 95815 1194.86 0 0 1194.86      
4730 4730 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY281 OTH Deane & Company       Sacramento CA 95815 1222.3 0 0 1222.3      
4731 4731 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY284 OTH Deane & Company       Sacramento CA 95815 1907.48 0 0 1907.48      
4732 4732 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY285 OTH Deane & Company       Sacramento CA 95815 1866.3 0 0 1866.3      
4733 4733 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY288 OTH Deane & Company       Sacramento CA 95815 1867.25 0 0 1867.25      
4734 4734 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY289 OTH Deane & Company       Sacramento CA 95815 1715.1 0 0 1715.1      
4735 4735 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY292 OTH Deane & Company       Sacramento CA 95815 989.3 0 0 989.3      
4736 4736 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY306 OTH Deane & Company       Sacramento CA 95815 0 211.75 0 211.75      
4737 4737 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY307 OTH Deane & Company       Sacramento CA 95815 0 126 0 126      
4738 4738 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY159 IND Uribe Carlos     Oakland CA 94605 2200 -2200 0 0      
4739 4739 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2021-01-30 2020-07-01 2020-12-31   PAY252 IND Uribe Carlos     Oakland CA 94605 2800 -2800 0 0     PAY252
5274 5274 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 0 692.16      
5275 5275 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY253 OTH Deane & Company       Sacramento CA 95815 1069.92 0 0 1069.92      
5276 5276 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY273 OTH Deane & Company       Sacramento CA 95815 1194.86 0 0 1194.86      
5277 5277 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY281 OTH Deane & Company       Sacramento CA 95815 1222.3 0 0 1222.3      
5278 5278 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY284 OTH Deane & Company       Sacramento CA 95815 1907.48 0 0 1907.48      
5279 5279 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY285 OTH Deane & Company       Sacramento CA 95815 1866.3 0 0 1866.3      
5280 5280 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY288 OTH Deane & Company       Sacramento CA 95815 1867.25 0 0 1867.25      
5281 5281 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY289 OTH Deane & Company       Sacramento CA 95815 1715.1 0 0 1715.1      
5282 5282 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY292 OTH Deane & Company       Sacramento CA 95815 0 989.3 0 989.3      
5283 5283 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY159 IND Uribe Carlos     Oakland CA 94605 2200 0 0 2200      
5284 5284 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-07-23 2020-01-01 2020-06-30   PAY252 IND Uribe Carlos     Oakland CA 94605 6300 -3500 0 2800     PAY252
4010 4010 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 0 692.16      
4011 4011 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY253 OTH Deane & Company       Sacramento CA 95815 1069.92 0 0 1069.92      
4012 4012 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY273 OTH Deane & Company       Sacramento CA 95815 1194.86 0 0 1194.86      
4013 4013 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY281 OTH Deane & Company       Sacramento CA 95815 1222.3 0 0 1222.3      
4014 4014 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY284 OTH Deane & Company       Sacramento CA 95815 1907.48 0 0 1907.48      
4015 4015 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY285 OTH Deane & Company       Sacramento CA 95815 1866.3 0 0 1866.3      
4016 4016 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY288 OTH Deane & Company       Sacramento CA 95815 1867.25 0 0 1867.25      
4017 4017 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY289 OTH Deane & Company       Sacramento CA 95815 0 1715.1 0 1715.1      
4018 4018 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY159 IND Uribe Carlos     Oakland CA 94605 2200 0 0 2200      
4019 4019 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2020-01-29 2019-07-01 2019-12-31   PAY252 IND Uribe Carlos     Oakland CA 94605 6300 0 0 6300      
4141 4141 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-07-16 2019-01-01 2019-06-30   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 0 692.16      
4142 4142 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-07-16 2019-01-01 2019-06-30   PAY253 OTH Deane & Company       Sacramento CA 95815 1069.92 0 0 1069.92      
4143 4143 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-07-16 2019-01-01 2019-06-30   PAY273 OTH Deane & Company       Sacramento CA 95815 1194.86 0 0 1194.86      
4144 4144 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-07-16 2019-01-01 2019-06-30   PAY281 OTH Deane & Company       Sacramento CA 95815 1222.3 0 0 1222.3      
4145 4145 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-07-16 2019-01-01 2019-06-30   PAY284 OTH Deane & Company       Sacramento CA 95815 1907.48 0 0 1907.48      
4146 4146 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-07-16 2019-01-01 2019-06-30   PAY285 OTH Deane & Company       Sacramento CA 95815 1866.3 0 0 1866.3      
4147 4147 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-07-16 2019-01-01 2019-06-30   PAY288 OTH Deane & Company       Sacramento CA 95815 0 1867.25 0 1867.25      
4148 4148 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-07-16 2019-01-01 2019-06-30   PAY159 IND Uribe Carlos     Oakland CA 94605 2200 0 0 2200      
4149 4149 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-07-16 2019-01-01 2019-06-30   PAY252 IND Uribe Carlos     Oakland CA 94605 6300 0 0 6300      
3309 3309 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-01-24 2018-07-01 2018-12-31   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 0 692.16      
3310 3310 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-01-24 2018-07-01 2018-12-31   PAY253 OTH Deane & Company       Sacramento CA 95815 1069.92 0 0 1069.92      
3311 3311 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-01-24 2018-07-01 2018-12-31   PAY273 OTH Deane & Company       Sacramento CA 95815 1194.86 0 0 1194.86      
3312 3312 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-01-24 2018-07-01 2018-12-31   PAY281 OTH Deane & Company       Sacramento CA 95815 1222.3 0 0 1222.3      
3313 3313 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-01-24 2018-07-01 2018-12-31   PAY284 OTH Deane & Company       Sacramento CA 95815 1907.48 0 0 1907.48      
3314 3314 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-01-24 2018-07-01 2018-12-31   PAY285 OTH Deane & Company       Sacramento CA 95815 0 1866.3 0 1866.3      
3315 3315 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-01-24 2018-07-01 2018-12-31   PAY159 IND Uribe Carlos     Oakland CA 94605 2200 0 0 2200      
3316 3316 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2019-01-24 2018-07-01 2018-12-31   PAY252 IND Uribe Carlos     Oakland CA 94605 6300 0 0 6300      
3833 3833 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-07-25 2018-01-01 2018-06-30   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 0 692.16      
3834 3834 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-07-25 2018-01-01 2018-06-30   PAY253 OTH Deane & Company       Sacramento CA 95815 1069.92 0 0 1069.92      
3835 3835 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-07-25 2018-01-01 2018-06-30   PAY273 OTH Deane & Company       Sacramento CA 95815 1194.86 0 0 1194.86      
3836 3836 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-07-25 2018-01-01 2018-06-30   PAY281 OTH Deane & Company       Sacramento CA 95815 1222.3 0 0 1222.3      
3837 3837 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-07-25 2018-01-01 2018-06-30   PAY284 OTH Deane & Company       Sacramento CA 95815 0 1907.48 0 1907.48      
3838 3838 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-07-25 2018-01-01 2018-06-30   PAY159 IND Uribe Carlos     Oakland CA 94605 2200 0 0 2200      
3839 3839 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-07-25 2018-01-01 2018-06-30   PAY252 IND Uribe Carlos     Oakland CA 94605 6300 0 0 6300      
2770 2770 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-01-16 2017-07-01 2017-12-31   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 0 692.16      
2771 2771 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-01-16 2017-07-01 2017-12-31   PAY253 OTH Deane & Company       Sacramento CA 95815 1069.92 0 0 1069.92      
2772 2772 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-01-16 2017-07-01 2017-12-31   PAY273 OTH Deane & Company       Sacramento CA 95815 1194.86 0 0 1194.86      
2773 2773 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-01-16 2017-07-01 2017-12-31   PAY281 OTH Deane & Company       Sacramento CA 95815 0 1222.3 0 1222.3      
2774 2774 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-01-16 2017-07-01 2017-12-31   PAY159 IND Uribe Carlos     Oakland CA 94605 2200 0 0 2200      
2775 2775 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2018-01-16 2017-07-01 2017-12-31   PAY252 IND Uribe Carlos     Oakland CA 94605 6300 0 0 6300      
2865 2865 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-13 2017-01-01 2017-06-30   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 0 692.16      
2866 2866 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-13 2017-01-01 2017-06-30   PAY248 OTH Community Printers, Inc.       Santa Cruz CA 95062 832.66 0 832.66 0      
2867 2867 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-13 2017-01-01 2017-06-30   PAY253 OTH Deane & Company       Sacramento CA 95815 1069.92 0 0 1069.92      
2868 2868 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-13 2017-01-01 2017-06-30   PAY257 OTH City Print & Mail, Inc.       Oakland CA 94612 559 0 559 0      
2869 2869 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-13 2017-01-01 2017-06-30   PAY258 OTH City Print & Mail, Inc.       Oakland CA 94612 740.46 0 740.46 0      
2870 2870 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-13 2017-01-01 2017-06-30   PAY273 OTH Deane & Company       Sacramento CA 95815 0 1194.86 0 1194.86      
2871 2871 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-13 2017-01-01 2017-06-30   PAY159 IND Uribe Carlos     Oakland CA 94605 7400 0 5200 2200      
2872 2872 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-13 2017-01-01 2017-06-30   PAY252 IND Uribe Carlos     Oakland CA 94605 6300 0 0 6300      
1909 1909 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-05 2016-10-23 2016-12-31   PAY202 OTH Community Printers, Inc.       Santa Cruz CA 95062 1543.48 0 1543.48 0      
1910 1910 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-05 2016-10-23 2016-12-31   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 0 692.16      
1911 1911 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-05 2016-10-23 2016-12-31   PAY248 OTH Community Printers, Inc.       Santa Cruz CA 95062 0 832.66 0 832.66      
1912 1912 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-05 2016-10-23 2016-12-31   PAY253 OTH Deane & Company       Sacramento CA 95815 0 1069.92 0 1069.92      
1913 1913 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-05 2016-10-23 2016-12-31   PAY257 OTH City Print & Mail, Inc.       Oakland CA 94612 0 559 0 559      
1914 1914 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-05 2016-10-23 2016-12-31   PAY258 OTH City Print & Mail, Inc.       Oakland CA 94612 0 740.46 0 740.46      
1915 1915 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-05 2016-10-23 2016-12-31   PAY159 IND Uribe Carlos     Oakland CA 94605 9400 0 2000 7400      
1916 1916 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-07-05 2016-10-23 2016-12-31   PAY252 IND Uribe Carlos     Oakland CA 94605 0 6300 0 6300      
2139 2139 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-01-21 2016-10-23 2016-12-31   PAY202 OTH Community Printers, Inc.       Santa Cruz CA 95062 1543.48 0 1543.48 0      
2140 2140 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-01-21 2016-10-23 2016-12-31   PAY205 OTH Deane & Company       Sacramento CA 95815 692.16 0 0 692.16      
2141 2141 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-01-21 2016-10-23 2016-12-31   PAY248 OTH Community Printers, Inc.       Santa Cruz CA 95062 0 832.66 0 832.66      
2142 2142 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-01-21 2016-10-23 2016-12-31   PAY253 OTH Deane & Company       Sacramento CA 95815 0 1069.92 0 1069.92      
2143 2143 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-01-21 2016-10-23 2016-12-31   PAY159 IND Uribe Carlos     Oakland CA 94605 9400 0 2000 7400      
2144 2144 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2017-01-21 2016-10-23 2016-12-31   PAY252 IND Uribe Carlos     Oakland CA 94605 0 6300 0 6300      
2350 2350 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PAY162 OTH Community Printers, Inc.       Santa Cruz CA 95062 195.23 0 195.23 0      
2351 2351 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PAY166 OTH Community Printers, Inc.       Santa Cruz CA 95062 229.93 0 229.93 0      
2352 2352 1379121 109 Roseann Torres for Oakland School Board 2016 114 CTL 2016-10-26 2016-09-25 2016-10-22 2016-11-08 PAY202 OTH Community Printers, Inc.       Santa Cruz CA 95062 0 1543.48 0 1543.48      

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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");
Powered by Datasette · Queries took 25.958ms · Data source: F_Expenses