collier_monthly_xlsx

{
  "firm_count": 18960,
  "scope_layer": "county_permitting_authority",
  "source_type": "monthly_report",
  "identity_count": 19407,
  "proof_artifact": "artifacts/florida-five-county-onboarding/2026-06-05-batch-10/collier/collier-monthly-building-permit-reports.links.json",
  "authority_level": "county",
  "high_confidence": "0",
  "import_run_count": 8,
  "source_run_count": 15,
  "business_priority": "medium",
  "last_sync_seen_at": "2026-06-05T02:34:27Z",
  "running_run_count": 0,
  "jurisdiction_scope": "Collier County monthly building permit report scope; CityView exists separately for richer portal interactions",
  "blockers_or_caveats": "Monthly reports have weak direct phone/email coverage and pre-2020 full parity was not proven from the public report family. CityView may require registered access for some workflows.",
  "field_parity_status": "material_monthly_xlsx_value_contractor_license_no_phone_email",
  "reported_rows_found": 76284,
  "first_sync_started_at": "2026-06-03T03:09:36Z",
  "proven_date_span_days": 2315,
  "proven_last_work_date": "2026-05-05",
  "continuous_sync_status": "pass_monthly_xlsx_page_watch_reingest_recent",
  "contractor_join_status": "license_present_in_monthly_report_when_exposed",
  "field_coverage_summary": "{\"continuous_sync_status\": \"pass_monthly_xlsx_page_watch_reingest_recent\", \"dbpr_join_key_status\": \"license_present_in_monthly_report_when_exposed\", \"email_present\": false, \"exact_job_value\": true, \"field_parity_status\": \"material_monthly_xlsx_value_contractor_license_no_phone_email\", \"historical_backfill_status\": \"material_import_2020-01-02_to_2026-05-05_pre2020_not_proven\", \"imported_identity_rows\": 19407, \"imported_work_events\": 339409, \"job_value_present\": true, \"missing\": [\"direct_contractor_phone\", \"direct_contractor_email\", \"pre_2020_public_report_parity\"], \"phone_present\": false, \"remaining_blockers\": [\"alternate source for pre-2020 Collier history\", \"phone/email enrichment\", \"CityView detail strategy if richer contacts are required\"], \"sample_status\": \"batch10_report_page_plus_db_import\", \"source_rows\": 19046}",
  "proven_first_work_date": "2020-01-02",
  "observed_date_span_days": 2315,
  "observed_last_work_date": "2026-05-05",
  "proven_source_row_count": 339409,
  "observed_first_work_date": "2020-01-02",
  "historical_backfill_status": "material_import_2020-01-02_to_2026-05-05_pre2020_not_proven",
  "reported_identities_upserted": 47914,
  "reported_work_events_upserted": 39424
}