Permit Timeline Events (755)
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
- id
- Event ID
- project_id
- Link to projects table
- address
- Project address
- permit_number
- Permit number (ZP2023-0001 format)
- stage
- Processing stage (Completeness Review, Application Processing, CEQA, etc.)
- action
- Action taken (Application Complete, Corrections Issued, Approved, etc.)
- event_date
- Date of event
- assigned_to
- Staff assigned
- marked_by
- Staff who recorded the event
- comment
- Staff comments
- stage_status
- Stage completion status
- source
- Data source (accela)
- imported_at
- When data was imported
- permit_type
- Type of permit
4 rows where action = "Application Complete" and marked_by = "Desiree Dougherty" sorted by event_date descending
This data as json, CSV (advanced)
Suggested facets: project_id, address, event_date, event_date (date), imported_at (date)
stage 2
- Unknown 3
- ness Review 1
marked_by 1
- Desiree Dougherty · 4 ✖
action 1
- Application Complete · 4 ✖
| Link | rowid | id | project_id | address | permit_number | stage | action | event_date ▲ | assigned_to | marked_by | comment | stage_status | source | imported_at | permit_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 561 | 561 | 627 | 152 | 1598 UNIVERSITY Ave | ZP2022-0011 | Unknown | Application Complete | 2024-05-06 | Desiree Dougherty | Complete | accela | 2026-03-29 02:16:04 | Planning | ||
| 517 | 517 | 540 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Application Complete | 2024-05-06 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 473 | 473 | 476 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Application Complete | 2024-05-06 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 631 | 631 | 717 | 140 | 2136 SAN PABLO Ave | ZP2021-0046 | ness Review | Application Complete | 2021-04-28 | Desiree Dougherty | Complete | accela | 2026-03-30 03:14:27 | Planning |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "permit_events" ( "id" INTEGER, "project_id" INTEGER, "address" TEXT, "permit_number" TEXT, "stage" TEXT, "action" TEXT, "event_date" TEXT, "assigned_to" TEXT, "marked_by" TEXT, "comment" TEXT, "stage_status" TEXT, "source" TEXT, "imported_at" TEXT, "permit_type" TEXT ); CREATE INDEX idx_events_permit ON permit_events(permit_number); CREATE INDEX idx_events_project ON permit_events(project_id); CREATE INDEX idx_events_date ON permit_events(event_date);