Overview — Gig Dashboard

16

Total Gigs

1

Projects Tracked

Gigs Over 30 Days ↗

Marked Critical ↗

16.4

Avg Age (days)

Project Rankings

Project	Total	Open	Over 30d ↓	Δ Total	Δ Over 30d	Critical	Avg Age	Oldest	Top Type
Oregon (02/11)	16	16	2	-14	-10	0	16.4	52	Missing_Photo (9)

Top Gig Types — Overall

Gig Type	Count	Share
Missing_Photo	9
Conduit_Other	2
Structure_Gradelevel	1
Other	1
Fiber_Other	1
Restoration_Hardscape_Asphalt	1
Restoration_Other	1

Gigs by Crew / Contractor

Crew	Count	Share
Region	14
Unassigned	2

Gig Types by Project

Oregon

Missing_Photo	9
Conduit_Other	2
Structure_Gradelevel	1
Other	1
Fiber_Other	1
Restoration_Hardscape_Asphalt	1
Other (misc.)	1

Aging — Days Open, by Project

Project	0-7 days	8-14 days	15-30 days	31-60 days	61-90 days	90+ days	Unknown	Avg Age
Oregon	5	4	5	2	0	0	0	16.4
All Projects	5	4	5	2	0	0	0

Trends — Gig Count Over Time

Oldest Open Gigs

Project	Type	Status	Supervisor	Age (days)	Created
Oregon	Structure_Gradelevel	OPEN	Unassigned	52	2026-09-16
Oregon	Other	OPEN	Unassigned	42	2026-09-25
Oregon	Fiber_Other	OPEN	Unassigned	29	2026-10-08
Oregon	Missing_Photo	MISSING_PHOTO	885448	22	2026-10-15
Oregon	Missing_Photo	MISSING_PHOTO	Unassigned	22	2026-10-15
Oregon	Restoration_Hardscape_Asphalt	OPEN	Unassigned	22	2026-10-15
Oregon	Missing_Photo	MISSING_PHOTO	885448	16	2026-10-21
Oregon	Conduit_Other	OPEN	Unassigned	10	2026-10-27
Oregon	Restoration_Other	OPEN	Unassigned	10	2026-10-27
Oregon	Missing_Photo	MISSING_PHOTO	Unassigned	9	2026-10-28
Oregon	Missing_Photo	MISSING_PHOTO	Unassigned	9	2026-10-28
Oregon	Conduit_Other	OPEN	Unassigned	4	2026-11-02
Oregon	Missing_Photo	MISSING_PHOTO	Unassigned	4	2026-11-02
Oregon	Missing_Photo	MISSING_PHOTO	Unassigned	4	2026-11-02
Oregon	Missing_Photo	MISSING_PHOTO	Unassigned	4	2026-11-02
Oregon	Missing_Photo	MISSING_PHOTO	Unassigned	4	2026-11-02

Source Files Loaded

Oregon__Gig_List.csv