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
3 rows where action = "Application Complete" and marked_by = "Niloufar Karimzadegan" sorted by event_date descending
This data as json, CSV (advanced)
Suggested facets: event_date (date), imported_at (date)
stage 2
permit_type 1
- Planning 3
marked_by 1
- Niloufar Karimzadegan · 3 ✖
action 1
- Application Complete · 3 ✖
| Link | rowid | id | project_id | address | permit_number | stage | action | event_date ▲ | assigned_to | marked_by | comment | stage_status | source | imported_at | permit_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 389 | 389 | 389 | 5 | 2425 Durant Ave | ZP2024-0162 | Completeness Review | Application Complete | 2025-03-13 | TBD | Niloufar Karimzadegan | Unknown | accela | 2026-03-28 16:22:27 | Planning | |
| 164 | 164 | 164 | 121 | 2100 Milvia | ZP2023-0163 | Completeness Review | Application Complete | 2024-05-17 | Niloufar Karimzadegan | Niloufar Karimzadegan | Complete | accela | 2026-03-28 16:22:27 | Planning | |
| 133 | 133 | 133 | 36 | 2733 SAN PABLO Ave | ZP2023-0090 | Due 05/10/2024, assigned to Niloufar Karimzadegan Marked as Resubmittal Pending Staff on 04/10/2024 by Niloufar Karimzadegan | Application Complete | 2024-05-09 | Niloufar Karimzadegan Marked as Application Complete on 05/09/2024 by Niloufar Karimzadegan | Niloufar Karimzadegan | Active | accela | 2026-03-28 16:22: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);