lm_data: 246908
This data as json
| rpt_id | 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 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 246908 | BRICKLAYERS AFL-CIO | BAC | 530173 | JUN 6 | NORTHERN OHIO | 1993-08-01 | 2007-10-17 | F | 300000 | 2004-07-01 | 2005-06-30 | F | F | 3279702 | F | 0 | DC | 23914 | 4111460 | 3481343 | 4007 | 2005-09-19 09:32:16.0 | F | F | T | F | T | T | F | F | 2006-09 | F | F | F | 2005 | 0 | 2005-09-19 09:32:16.0 | 194086 | UNION 201 | ROBERT | FOZIO | 16600 W SPRAGUE RD SUITE 275 | MIDDLEBURG HEIGHTS | OH | 441306398 | 2005-09-19 09:32:16.211 | 10000 | T | LM-2 |
Links from other tables
- 0 rows from rpt_id in ar_assets_accts_rcvbl
- 3 rows from rpt_id in ar_assets_fixed
- 8 rows from rpt_id in ar_assets_investments
- 0 rows from rpt_id in ar_assets_loans_rcvbl
- 1 row from rpt_id in ar_assets_other
- 1 row from rpt_id in ar_assets_total
- 2 rows from rpt_id in ar_disbursements_benefits
- 25 rows from rpt_id in ar_disbursements_emp_off
- 14 rows from rpt_id in ar_disbursements_genrl
- 5 rows from rpt_id in ar_disbursements_inv_purchases
- 1 row from rpt_id in ar_disbursements_total
- 0 rows from rpt_id in ar_liabilities_accts_paybl
- 3 rows from rpt_id in ar_liabilities_loans_paybl
- 3 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
- 17 rows from rpt_id in ar_payer_payee
- 5 rows from rpt_id in ar_rates_dues_fees
- 4 rows from rpt_id in ar_receipts_inv_fa_sales
- 9 rows from rpt_id in ar_receipts_other
- 1 row from rpt_id in ar_receipts_total