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 = "Corrections - Pending Applicant" and marked_by = "Katrina Lapira" sorted by event_date descending
This data as json, CSV (advanced)
Suggested facets: project_id, address, permit_number, stage_status, event_date (date), imported_at (date)
stage 3
permit_type 1
- Planning 3
marked_by 1
- Katrina Lapira · 3 ✖
action 1
- Corrections - Pending Applicant · 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 356 | 356 | 356 | 132 | 1627 Jaynes St | ZP2024-0129 | Application Processing | Corrections - Pending Applicant | 2024-11-06 | Katrina Lapira | Complete | accela | 2026-03-28 16:22:27 | Planning | ||
| 212 | 212 | 212 | 117 | 2317 CHANNING Way | ZP2024-0033 | Due 08/01/2024, assigned to Katrina Lapira Marked as Resubmittal - Pending Staff Review on 07/02/2024 by Katrina Lapira | Corrections - Pending Applicant | 2024-07-30 | Katrina Lapira Marked as Corrections - Pending Applicant on 07/30/2024 by Katrina Lapira | Katrina Lapira | Active | accela | 2026-03-28 16:22:27 | Planning | |
| 211 | 211 | 211 | 117 | 2317 CHANNING Way | ZP2024-0033 | Stage: Application Processing | Corrections - Pending Applicant | 2024-05-16 | Katrina Lapira Marked as Corrections - Pending Applicant on 05/16/2024 by Katrina Lapira | Katrina Lapira | 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);