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 = "Documents Uploaded" sorted by event_date descending
This data as json, CSV (advanced)
Suggested facets: project_id, address, permit_number, imported_at, event_date (date), imported_at (date)
| Link | rowid | id | project_id | address | permit_number | stage | action | event_date ▲ | assigned_to | marked_by | comment | stage_status | source | imported_at | permit_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 696 | 696 | 927 | 150 | 3030 TELEGRAPH Ave | ZP2022-0170 | Resubmittal-Revision | Documents Uploaded | 2026-02-24 | ADM | Active | accela | 2026-03-30 03:27:10 | Planning | ||
| 655 | 655 | 742 | 161 | 2555 COLLEGE Ave | ZP2022-0019 | Stage: Resubmittal-Revision | Documents Uploaded | 2024-02-02 | ADM | Active | accela | 2026-03-30 03:14:27 | Planning | ||
| 729 | 729 | 960 | 150 | 3030 TELEGRAPH Ave | ZP2022-0170 | Resubmittal-Revision | Documents Uploaded | 2024-01-25 | ADM | Active | accela | 2026-03-30 03:27:10 | Planning | ||
| 654 | 654 | 741 | 161 | 2555 COLLEGE Ave | ZP2022-0019 | Stage: Resubmittal-Revision | Documents Uploaded | 2023-09-21 | ADM | Active | 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);