Source Fields
{
"application_date": "2025-07-29",
"business_display_name": "Shamrock Plumbing & Drain Cleaning LLC",
"completion_date": "2025-10-06",
"confidence_notes": "Issued permit name matched one contractor registry row by normalized business name.",
"contractor_license_number": "CFC1427181",
"contractor_name": "Shamrock Plumbing & Drain Cleaning LLC",
"county": "Sumter",
"description": "Whole House Re-pipe",
"email": "[email protected]",
"issue_date": "2025-09-23",
"issued_report_name": "Shamrock Plumbing & Drain Cleaning LLC",
"join_confidence": "registry_name_exact",
"jurisdiction_scope": "Sumter County Citizenserve issued-permit report scope",
"legal_or_dba_name": "Shamrock Plumbing & Drain Cleaning LLC",
"license_number": "CFC1427181",
"license_status": "expires 2026-08-31",
"license_type": "Plumbing Contractor (State): CFC1427181 (08/31/2026)",
"mailing_or_firm_address": "4032 Old Winter Garden Road Orlando FL 32805",
"normalized_license_number": "CFC1427181",
"observed_project_value": 4104,
"parcel_id": "G05C058",
"permit_number": "P25-000217",
"phone": "(P): (407) 292-8881",
"portal_key": "sumter_citizenserve",
"qualifier_name": "Mark Norman",
"raw_payload_path": "artifacts/source-probes/sumter-citizenserve/2026-06-05/sumter_citizenserve/raw/issued-2025-01-01-to-2025-12-31.html",
"scope_layer": "county_permitting_authority",
"site_address": "723 N WARFIELD AVE",
"source_fields_json": "{\"Address\":\"723 N WARFIELD AVE\",\"Application Date\":\"07/29/2025\",\"Completion Date\":\"10/06/2025\",\"Estimated Cost of Construction\":\"4104.00\",\"Issue Date\":\"09/23/2025\",\"Owners Name\":\"Shamrock Plumbing & Drain Cleaning LLC\",\"Parcel Number\":\"G05C058\",\"Permit Subtype\":\"Repipe\",\"Permit Type\":\"Sumter County - Plumbing Permit\",\"Permit#\":\"P25-000217\",\"Project Name\":\"Whole House Re-pipe\",\"Status Code\":\"Finaled\",\"Subtype Details\":\"Whole House Re-pipe\"}",
"source_record_id": "CFC1427181",
"source_url": "Citizenserve report_ID=892 Issued Permits",
"state": "FL",
"status": "Finaled",
"work_date": "2025-09-23",
"work_event_id": "P25-000217",
"work_type": "Repipe / Whole House Re-pipe",
"work_value": "4104.00",
"work_value_source": "Sumter issued-permit report Estimated Cost of Construction"
}