opdr
Tables
ar_assets_accts_rcvbl
oid, acct_type, name, past_due_90, past_due_180, liquidated, total, rpt_id
98,382 rows
ar_assets_fixed
oid, description, cost_basis, depreciation, book_value, value, asset_type, rpt_id
338,629 rows
ar_assets_loans_rcvbl
oid, loan_type, name, purpose, security, terms, outstanding_start_amt, outstanding_end_amt, new_loan_amt, cash_repayments, non_cash_repayments, rpt_id
81,573 rows
ar_assets_total
rpt_id, cash_start, cash_end, accounts_receivable_start, accounts_receivable_end, investments_start, investments_end, fixed_assets_start, fixed_assets_end, treasury_securities_start, treasury_securities_end, other_assets_start, other_assets_end, loans_receivable_start, loans_receivable_end, total_start, market_sec_total_cost, market_sec_total_book_value, other_inv_total_cost, other_inv_total_book_value
355,110 rows
ar_disbursements_emp_off
oid, emp_off_type, first_name, middle_name, last_name, title, status_other_payer, gross_salary, allowances, official_business, other_not_rptd, total, rep_pct, pol_pct, cont_pct, gen_ovrhd_pct, admin_pct, rpt_id, item_num
4,391,458 rows
ar_disbursements_genrl
oid, disbursement_type, purpose, date, amount, payer_payee_id, rpt_id
2,544,442 rows
ar_disbursements_inv_purchases
oid, inv_type, description, cost, book_value, cash_paid, rpt_id
208,109 rows
ar_disbursements_total
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
355,110 rows
ar_liabilities_accts_paybl
oid, acct_type, name, total, past_due_90, past_due_180, liquidated, rpt_id
102,504 rows
ar_liabilities_loans_paybl
oid, source, loans_owed_start, loans_obtained, cash_repayment, non_cash_repayment, loans_owed_end, rpt_id
29,144 rows
ar_liabilities_total
rpt_id, accounts_payable_start, accounts_payable_end, loans_payable_start, loans_payable_end, mortgage_payable_start, mortgage_payable_end, other_liabilities_start, other_liabilities_end, total_start
355,110 rows
ar_payer_payee
payer_payee_id, payer_payee_type, rcpt_disb_type, name, po_box, street, city, state, zip, type_or_class, itemized, non_itemized, total, rpt_id
1,822,493 rows
ar_receipts_inv_fa_sales
oid, inv_type, description, cost, book_value, gross_sales_price, amount_recd, rpt_id
98,858 rows
ar_receipts_total
rpt_id, dues, tax, investments, supplies, loans_made, interest, dividends, rents, fees, loans_obtained, other_receipts, affiliates, members, inv_sale_reinvestments, all_other_receipts
355,110 rows
lm_data
union_name, aff_abbr, f_num, fye, unit_name, est_date, term_date, shortage, maximum_bond, pd_covered_from, pd_covered_to, constitution_bylaw, terminate, ttl_assets, subsidiary, desiq_pre, desig_num, desig_suf, desig_name, ttl_liabilities, ttl_receipts, ttl_disbursements, members, register_date, amended, hardship, has_trust, pac_funds, outside_audit, has_property_change, assets_pledged, contingent, next_election, has_liquidated_liabilities, has_extended_loan_credit, has_liquidated_receivables, has_subsidiary, num_attachments, rpt_id, yr_covered, amendment, receive_date, adr_id, address_type, mail_firstname, mail_lastname, build_num, street_adr, city, state, zip, voice, mod_date, mod_id, record_kept, form_type
547,622 rows
... and 6 hidden tables
Download SQLite DB: opdr.db 985.7 MB