bluedoor data·Licensed Contractors API·bluedoor.sh ↗

HomeSourcesfranklin_citizenserve

franklin_citizenserve

Franklin County - source with 20,227 work events from - contractors.

Source

Portal keyfranklin_citizenserve
CountyFranklin
Authority level-
Scope layer-
Source roleCore Work Event
Source type-
Work events20,227
Valued events0
Identities-
Contractors-
Observed first-
Observed last-

Full source record

Portal Keyfranklin_citizenserve
CountyFranklin
Source Rolecore_work_event
Work Event Count20227
Valued Event Count0
Local Identity Count-
First Work Date-
Last Work Date-
Detail Attempted0
Detail Errors0
Extra
{
  "firm_count": 5802,
  "scope_layer": "county_permitting_authority",
  "source_type": "citizenserve_date_windowed_reports",
  "identity_count": 20229,
  "proof_artifact": "artifacts/source-probes/citizenserve-county/2026-06-05/franklin_citizenserve/source-probe-summary.json",
  "authority_level": "county",
  "high_confidence": "1",
  "import_run_count": 3,
  "source_run_count": 26,
  "business_priority": "medium",
  "last_sync_seen_at": "2026-06-05T15:38:27Z",
  "running_run_count": 0,
  "jurisdiction_scope": "Franklin County Citizenserve permit and contractor-registration portal",
  "blockers_or_caveats": "Direct unauthenticated POST should not be treated as the connector path. Contractor report has only two all-license rows in the sampled run; issued-permit rows are strong work events but mostly name-only for contractor joins.",
  "field_parity_status": "pass_work_events_partial_identity_license",
  "reported_rows_found": 20229,
  "first_sync_started_at": "2026-06-05T07:19:42Z",
  "proven_date_span_days": 7822,
  "proven_last_work_date": "2026-06-04",
  "continuous_sync_status": "pass_date_windowed_citizenserve_report_flow",
  "contractor_join_status": "contractor_report_limited_license_rows_issued_rows_name_only",
  "field_coverage_summary": "{\"continuous_sync_status\": \"pass_date_windowed_citizenserve_report_flow\", \"dbpr_join_key_status\": \"contractor_report_limited_license_rows_issued_rows_name_only\", \"field_parity_status\": \"pass_work_events_partial_identity_license\", \"historical_backfill_status\": \"pass_observed_2005_to_2026_2004_and_2000_no_result\", \"observed_first_work_date\": \"2005-01-03\", \"observed_last_work_date\": \"2026-06-02\", \"remaining_blockers\": \"License join is limited; expand contractor report by license type and join issued applicants by name/license where possible.\", \"sample_status\": \"live_report_execution_rows_returned\", \"source_rows\": 584}",
  "proven_first_work_date": "2005-01-03",
  "observed_date_span_days": 7822,
  "observed_last_work_date": "2026-06-04",
  "proven_source_row_count": 20227,
  "observed_first_work_date": "2005-01-03",
  "historical_backfill_status": "pass_observed_2005_to_2026_2004_and_2000_no_result",
  "reported_identities_upserted": 20229,
  "reported_work_events_upserted": 20227
}
Get this page with API

Rendered from the bluedoor Licensed Contractors API. Reproduce it:

GET https://api.bluedoor.sh/licensed-contractors/v1/sources/franklin_citizenserveJSON