ar_disbursements_total

where rpt_id = 247892

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ rpt_id representational political contributions general_overhead union_administration withheld members supplies fees administration direct_taxes strike_benefits per_capita_tax to_officers investments benefits loans_made loans_payment affiliates other_disbursements to_employees less_total_disbursed withheld_not_disbursed officer_deductions employee_deductions inv_purch_reinvestments all_other_rep_activities all_other_pol_activities all_other_contributions all_other_gen_overhead all_other_union_admin off_admin_expense edu_pub_expense pro_fees
103550 103550 247892 247892 173208 14925 8909 80039 76010 91965 0 1372 12629   20071 0 51686 129176 56935 97316 0 0 0 0 40913 89617 2348 81685 10280 0 3000 0 2850 27780 2207 0   0 
CREATE TABLE ar_disbursements_total (
rpt_id INTEGER NOT NULL, representational INTEGER NULL, political INTEGER NULL, contributions INTEGER NULL, general_overhead INTEGER NULL, union_administration INTEGER NULL, withheld INTEGER NULL, members INTEGER NULL, supplies INTEGER NULL, fees INTEGER NULL, administration INTEGER NULL, direct_taxes INTEGER NULL, strike_benefits INTEGER NULL, per_capita_tax INTEGER NULL, to_officers INTEGER NULL, investments INTEGER NULL, benefits INTEGER NULL, loans_made INTEGER NULL, loans_payment INTEGER NULL, affiliates INTEGER NULL, other_disbursements INTEGER NULL, to_employees INTEGER NULL, less_total_disbursed INTEGER NULL, withheld_not_disbursed INTEGER NULL, officer_deductions INTEGER NULL, employee_deductions INTEGER NULL, inv_purch_reinvestments INTEGER NULL, all_other_rep_activities INTEGER NULL, all_other_pol_activities INTEGER NULL, all_other_contributions INTEGER NULL, all_other_gen_overhead INTEGER NULL, all_other_union_admin INTEGER NULL, off_admin_expense INTEGER NULL, edu_pub_expense INTEGER NULL, pro_fees INTEGER NULL, FOREIGN KEY(rpt_id) REFERENCES lm_data(rpt_id)
);