Mechanical

{
  "business_display_name": "UNION COMPLETE SERVICE INC",
  "city": null,
  "confidence_notes": "Mapped from official Collier monthly workbook row; contractor contact limited to city/state/zip.",
  "county": "Collier",
  "description": "Mechanical",
  "email": null,
  "insurance_or_bond_summary": null,
  "jurisdiction_scope": "Collier monthly building report scope",
  "legal_or_dba_name": "UNION COMPLETE SERVICE INC",
  "license_number": "LCC20210000273",
  "license_status": null,
  "license_type": "Contractor",
  "mailing_or_firm_address": "ANDOVER MA 01845",
  "parcel_id": "51740600007",
  "phone": null,
  "portal_key": "collier_monthly_xlsx",
  "postal_code": null,
  "qualifier_name": null,
  "raw_payload_path": "artifacts/business-backfills/collier_monthly_xlsx/run_date=2026-06-05/2022-4-issued-permits.xlsx",
  "scope_layer": "county_permitting_authority",
  "site_address": "6710 Pelican Bay BLVD, Unit #: 443, Naples, Multi Family",
  "source_fields": {
    "building_type": "Commercial",
    "const_type": "Alteration/Remodel",
    "contractor_city": "ANDOVER",
    "contractor_name": "UNION COMPLETE SERVICE INC",
    "contractor_state": "MA",
    "contractor_type": "Contractor",
    "contractor_zip": "01845",
    "county": "Collier",
    "date_applied": "2022-04-12T15:40:02.967000",
    "date_issued": "2022-04-18T13:21:52.103000",
    "declared_value": 7152,
    "license_number": "LCC20210000273",
    "owner_city": "ANDOVER",
    "owner_name": "COUGHLAN III, BASIL J & MARY K",
    "owner_state": "MA",
    "owner_zip": "01845",
    "permit_class": "Residential-Multi-Family",
    "permit_number": "PRAR20220417373",
    "permit_status": "Inspections Commenced",
    "permit_type_desc": "Mechanical",
    "property_id": "51740600007",
    "site_address": "6710 Pelican Bay BLVD, Unit #: 443, Naples, Multi Family",
    "source_file": "2022-4-issued-permits.xlsx",
    "source_report_kind": "issued",
    "source_system": "Collier monthly building permit XLSX",
    "source_url": "https://www.collier.gov/files/assets/county/v/1/building-plan-review/documents/bldg-reports/2022-reports/2022-4-issued-permits.xlsx",
    "total_sf": 0,
    "total_units": 0
  },
  "source_record_id": "LCC20210000273",
  "source_url": "https://www.collier.gov/files/assets/county/v/1/building-plan-review/documents/bldg-reports/2022-reports/2022-4-issued-permits.xlsx",
  "state": "FL",
  "status": "Inspections Commenced",
  "work_date": "2022-04-18T13:21:52.103000",
  "work_event_id": "PRAR20220417373",
  "work_type": "Commercial / Residential-Multi-Family / Mechanical",
  "work_value": 7152,
  "work_value_source": "Collier monthly XLSX Declared Value"
}