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
2 rows where permit_type = "Building Electrical Mechanical Plumbing Permit"
This data as json, CSV (advanced)
Suggested facets: filed_date (date), finaled_date (date), imported_at (date)
status 2
permit_type 1
- Building Electrical Mechanical Plumbing Permit · 2 ✖
| Link | rowid ▼ | id | project_id | permit_number | permit_type | address | status | filed_date | finaled_date | job_value | description | owner | applicant | source | imported_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2 | 2 | 13 | B2019-05657 | Building Electrical Mechanical Plumbing Permit | 2420 SHATTUCK AVE | Closed Expired | 2019-12-30 | TI to convert old Gio's pizza to Edel restaurant, new kitchen layout, walk-in cooler | accela | 2026-03-28 16:22:35 | ||||
| 4 | 4 | 4 | 13 | B2016-01435 | Building Electrical Mechanical Plumbing Permit | 2420 SHATTUCK AVE | Finaled | 2016-03-29 | 2015-11-04 | Commercial Restaurant T.I. for Giovanni's | 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);