Source Fields
{
"business_display_name": "NIAN ROOFING, INC. (DBA) BT ROOFING",
"city": null,
"confidence_notes": "Mapped from official Collier monthly workbook row; contractor contact limited to city/state/zip.",
"county": "Collier",
"description": "Reroof",
"email": null,
"insurance_or_bond_summary": null,
"jurisdiction_scope": "Collier monthly building report scope",
"legal_or_dba_name": "NIAN ROOFING, INC. (DBA) BT ROOFING",
"license_number": "LCC20200000049",
"license_status": null,
"license_type": "Contractor",
"mailing_or_firm_address": "MERCER PA 16137",
"parcel_id": "54754880001",
"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": "110 Jumento Cay LN, Bonita Springs",
"source_fields": {
"building_type": "1 to 2 Family",
"const_type": "Alteration/Remodel",
"contractor_city": "MERCER ",
"contractor_name": "NIAN ROOFING, INC. (DBA) BT ROOFING",
"contractor_state": "PA",
"contractor_type": "Contractor",
"contractor_zip": "16137 ",
"county": "Collier",
"date_applied": "2026-04-15T14:04:32.300000",
"date_issued": "2026-04-23T18:12:15.437000",
"declared_value": "62000",
"license_number": "LCC20200000049",
"owner_city": "MERCER ",
"owner_name": "KNOPP, DAVID C & VICTORIA L",
"owner_state": "PA",
"owner_zip": "16137 ",
"permit_class": "Res.1&2 or Guest House",
"permit_number": "PRRF20260415764",
"permit_status": "Issued",
"permit_type_desc": "Reroof",
"property_id": "54754880001",
"site_address": "110 Jumento Cay LN, Bonita Springs",
"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": "1"
},
"source_record_id": "LCC20200000049",
"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-23T18:12:15.437000",
"work_event_id": "PRRF20260415764",
"work_type": "1 to 2 Family / Res.1&2 or Guest House / Reroof",
"work_value": "62000",
"work_value_source": "Collier monthly XLSX Declared Value"
}