Mechanical

{
  "business_display_name": "ADVANCED ROOFING & SHEETMETAL, LLC",
  "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": "ADVANCED ROOFING & SHEETMETAL, LLC",
  "license_number": "LCC20170002674",
  "license_status": null,
  "license_type": "Contractor",
  "mailing_or_firm_address": "NAPLES FL 34108",
  "parcel_id": "27825000844",
  "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/2020-10-issued.xlsx",
  "scope_layer": "county_permitting_authority",
  "site_address": "7225 Pelican Bay BLVD, Building, Unit #: 1001, Naples",
  "source_fields": {
    "building_type": "Commercial",
    "const_type": "Alteration",
    "contractor_city": "NAPLES",
    "contractor_name": "ADVANCED ROOFING & SHEETMETAL, LLC",
    "contractor_state": "FL",
    "contractor_type": "Contractor",
    "contractor_zip": "34108",
    "county": "Collier",
    "date_applied": "2020-08-21T09:41:58.567000",
    "date_issued": "2020-10-06T09:25:41.127000",
    "declared_value": 440,
    "license_number": "LCC20170002674",
    "owner_city": "NAPLES",
    "owner_name": "COX III, ROBERT L & JOAN B",
    "owner_state": "FL",
    "owner_zip": "34108",
    "permit_class": "Residential-Multi-Family",
    "permit_number": "PRHV20200834681",
    "permit_status": "Inspections Completed",
    "permit_type_desc": "Mechanical",
    "property_id": "27825000844",
    "site_address": "7225 Pelican Bay BLVD, Building, Unit #: 1001, Naples",
    "source_file": "2020-10-issued.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/2020-reports/2020-10-issued.xlsx",
    "total_sf": 0,
    "total_units": 1
  },
  "source_record_id": "LCC20170002674",
  "source_url": "https://www.collier.gov/files/assets/county/v/1/building-plan-review/documents/bldg-reports/2020-reports/2020-10-issued.xlsx",
  "state": "FL",
  "status": "Inspections Completed",
  "work_date": "2020-10-06T09:25:41.127000",
  "work_event_id": "PRHV20200834681",
  "work_type": "Commercial / Residential-Multi-Family / Mechanical",
  "work_value": 440,
  "work_value_source": "Collier monthly XLSX Declared Value"
}