Building Permits (11)
Data license: Public Domain (CC0) · Data source: City of Berkeley Accela, Alameda County GIS
- id
- Permit ID
- project_id
- Link to projects table
- permit_number
- Building permit number (B2023-00001 format)
- permit_type
- Type of permit (Building, Electrical, etc.)
- address
- Project address
- status
- Permit status
- filed_date
- Date filed
- finaled_date
- Date finaled
- job_value
- Construction value
- description
- Work description
- owner
- Property owner
- applicant
- Permit applicant
- source
- Data source
- imported_at
- Import timestamp
1 row where status = "Issued"
This data as json, CSV (advanced)
Suggested facets: filed_date (date), imported_at (date)
status 1
- Issued · 1 ✖
permit_type 1
| Link | rowid ▼ | id | project_id | permit_number | permit_type | address | status | filed_date | finaled_date | job_value | description | owner | applicant | source | imported_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 3 | 3 | 13 | B2016-01435-REV01 | Building Revision | 2420 SHATTUCK AVE | Issued | 2016-12-14 | Revision for restaurant TI - alter front elevation, exterior storage area, deck coating, bar updates | accela | 2026-03-28 16:22:35 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "building_permits" ( "id" INTEGER, "project_id" INTEGER, "permit_number" TEXT, "permit_type" TEXT, "address" TEXT, "status" TEXT, "filed_date" TEXT, "finaled_date" TEXT, "job_value" TEXT, "description" TEXT, "owner" TEXT, "applicant" TEXT, "source" TEXT, "imported_at" TEXT ); CREATE INDEX idx_bp_permit ON building_permits(permit_number);