Mechanical

{
  "business_display_name": "J.P. BRETT & SONS, 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": "J.P. BRETT & SONS, INC.",
  "license_number": "C17474",
  "license_status": null,
  "license_type": "Contractor",
  "mailing_or_firm_address": "BARRINGTON IL 60010",
  "parcel_id": "64752003443",
  "phone": null,
  "portal_key": "collier_monthly_xlsx",
  "postal_code": null,
  "qualifier_name": null,
  "raw_payload_path": "artifacts/business-layer-samples/collier_monthly_xlsx/run_date=2026-06-02/normalized-preview.csv",
  "scope_layer": "county_permitting_authority",
  "site_address": "3311 Fanny Bay LN, Naples",
  "source_fields": {
    "building_type": "1 to 2 Family",
    "const_type": "Alteration/Remodel",
    "contractor_city": "BARRINGTON",
    "contractor_name": "J.P. BRETT & SONS, INC.",
    "contractor_state": "IL",
    "contractor_type": "Contractor",
    "contractor_zip": "60010",
    "county": "Collier",
    "date_applied": "2026-04-29T10:41:03.847000",
    "date_issued": "2026-04-29T10:48:10.860000",
    "declared_value": "15680",
    "license_number": "C17474",
    "owner_city": "BARRINGTON",
    "owner_name": "SANDRA LYNN SARGENT REV TRUST",
    "owner_state": "IL",
    "owner_zip": "60010",
    "permit_class": "Not Identified",
    "permit_number": "PRAR20260418130",
    "permit_status": "Issued",
    "permit_type_desc": "Mechanical",
    "property_id": "64752003443",
    "site_address": "3311 Fanny Bay LN, Naples",
    "source_file": "2026-4-issued-permits.xlsx",
    "source_report_kind": "issued",
    "source_system": "Collier monthly building permit XLSX",
    "source_url": "https://www.collier.gov/files/content/county/v/55/business-resources/building-permits-construction/meetings-advisory-boards-reports/monthly-building-permit-reports/2026-4-issued-permits.xlsx",
    "total_sf": "0",
    "total_units": "0"
  },
  "source_record_id": "C17474",
  "source_url": "https://www.collier.gov/files/content/county/v/55/business-resources/building-permits-construction/meetings-advisory-boards-reports/monthly-building-permit-reports/2026-4-issued-permits.xlsx",
  "state": "FL",
  "status": "Issued",
  "work_date": "2026-04-29T10:48:10.860000",
  "work_event_id": "PRAR20260418130",
  "work_type": "1 to 2 Family / Not Identified / Mechanical",
  "work_value": "15680",
  "work_value_source": "Collier monthly XLSX Declared Value"
}