home / opdr / lm_data

lm_data: 248368

This data as json

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
STATE COUNTY AND MUNI EMPLS AFL-CIO AFSCME 71060 6 PENNSYLVANIA PUBLIC EMPLOYEES 1970-12-01   F 500000 2004-07-01 2005-06-30 F F 49412840 F   13   C 16858523 31966039 37734452 50938 2005-09-27 10:54:34.0 F F T T T F F F 2007-04 F F F     248368 2005 0 2005-09-27 10:54:34.0 195317 201 JESSE EVANS   4031 EXECUTIVE PARK DRIVE HARRISBURG PA 171111599   2005-09-27 10:54:34.511 10000 T LM-2

Links from other tables

  • 1 row from rpt_id in ar_assets_accts_rcvbl
  • 17 rows from rpt_id in ar_assets_fixed
  • 9 rows from rpt_id in ar_assets_investments
  • 4 rows from rpt_id in ar_assets_loans_rcvbl
  • 2 rows from rpt_id in ar_assets_other
  • 1 row from rpt_id in ar_assets_total
  • 5 rows from rpt_id in ar_disbursements_benefits
  • 143 rows from rpt_id in ar_disbursements_emp_off
  • 233 rows from rpt_id in ar_disbursements_genrl
  • 3 rows from rpt_id in ar_disbursements_inv_purchases
  • 1 row from rpt_id in ar_disbursements_total
  • 1 row from rpt_id in ar_liabilities_accts_paybl
  • 0 rows from rpt_id in ar_liabilities_loans_paybl
  • 5 rows from rpt_id in ar_liabilities_other
  • 1 row from rpt_id in ar_liabilities_total
  • 2 rows from rpt_id in ar_membership
  • 156 rows from rpt_id in ar_payer_payee
  • 5 rows from rpt_id in ar_rates_dues_fees
  • 2 rows from rpt_id in ar_receipts_inv_fa_sales
  • 16 rows from rpt_id in ar_receipts_other
  • 1 row from rpt_id in ar_receipts_total
Powered by Datasette · Queries took 2.368ms