ar_disbursements_total

where rpt_id = 247479

✎ 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
100510 100510 247479 247479 157513 1111 5454 42003 86913 83841 0 3251 0   26097 0 11225 60106 15148 105411 0 5151 140553 0 31366 83841 0 53069 30772 0 19157 0 454 27386 20331 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)
);