Approval Patterns

Extended-hours permit approvals (EXTH/EXTR) grouped by approver and month. Government/quasi-public entities are flagged separately — city agencies, universities, utilities, hospital systems. Solo approvals are permits where issued_by = entered_by with no second reviewer on record.

—

Total EXTH/EXTR permits

—

Govt / quasi-public entity

—

Solo approvals (no second reviewer)

—

Midnight–5 AM work hours

Monthly Volume — EXTH/EXTR

Govt/quasi-public Other

Approver Breakdown

Govt permits only

Staff	Total	Govt #	Govt %	EXTR #	Govt EXTR	Solo	Night	Active

Deep Renewal Chains (3+ permits, ranked by EXTR depth)

Govt only

Address / Project	Govt	Depth	EXTR#	Span	Top Approver	Approver %	Approvers