ar_disbursements_total

where rpt_id = 247985

✎ 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
102971 102971 247985 247985 378596 48273 12335 122771 214756 158314 15594 0 85983   36903 0 254059 256649 571621 190485 0 0 0 0 56971 159186 -872 137827 20487 0 50546 28157 8135 22308 40555 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)
);