ar_disbursements_total

where rpt_id = 247098

✎ 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
102036 102036 247098 247098 1257227 80789 167720 472596 636459 519450 0 0 111604   148436 0 529547 133726 186190 769590 0 0 0 0 1038060 518949 501 54162 465288 49135 96569 0 126683 246904 25257 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)
);