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
95 rows where permit_type = "Other" sorted by event_date descending
This data as json, CSV (advanced)
Suggested facets: project_id, address, permit_number, stage_status, imported_at, event_date (date), imported_at (date)
stage 21
- Unknown 56
- Completeness Review 7
- Stage: Case Closed 5
- ness Review 5
- CEQA Determination 2
- Case Closed 2
- LPC Meeting 2
- Posted Project Notices 2
- Public Notification 2
- Appeal 1
- CEQA Determination - LPC Staff Report 1
- Mailed Project Notices 1
- Notice of Decision 1
- Staff Decision 1
- Staff Report 1
- Stage: Appeal 1
- Stage: CEQA Determination 1
- Stage: Hearing Notice 1
- Stage: Notice of Decision 1
- Stage: Public Hearing 1
- Stage: Staff Decision 1
action 17
- Completed 19
- Approved 18
- Application Complete 9
- Incomplete Pending Applicant 8
- Resubmittal Pending Staff 8
- Void 8
- No Notice Required 5
- Categorically Exempt 4
- Complete 3
- Continued off Calendar 3
- Appeal to City Council 2
- City Council Approved 2
- Notice Issued 2
- Continuing legal use 1
- No Appeal 1
- Research Completed 1
- TBD 1
marked_by 12
- Desiree Dougherty 33
- Katrina Lapira 14
- MJ 10
- SU 8
- Allison Riemer 7
- AA CONV 4
- RW 3
- M. 2
- MJ (Notice of Decision) 2
- NC 2
- Unknown 2
- Samella Stover 1
permit_type 1
- Other · 95 ✖
| Link | rowid | id | project_id | address | permit_number | stage | action | event_date ▲ | assigned_to | marked_by | comment | stage_status | source | imported_at | permit_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 33 | 33 | 33 | 2 | 2276 SHATTUCK Ave | LMSAP2024-0005 | Public Notification | Completed | 2025-12-23 | accela | 2026-03-28 16:22:26 | Other | ||||
| 32 | 32 | 32 | 2 | 2276 SHATTUCK Ave | LMSAP2024-0005 | CEQA Determination - LPC Staff Report | Completed | 2025-12-23 | accela | 2026-03-28 16:22:26 | Other | ||||
| 35 | 35 | 35 | 2 | 2276 SHATTUCK Ave | LMSAP2024-0005 | LPC Meeting | Approved | 2025-12-04 | accela | 2026-03-28 16:22:26 | Other | ||||
| 31 | 31 | 31 | 2 | 2276 SHATTUCK Ave | LMSAP2024-0005 | CEQA Determination | Categorically Exempt | 2025-12-04 | accela | 2026-03-28 16:22:26 | Other | ||||
| 34 | 34 | 34 | 2 | 2276 SHATTUCK Ave | LMSAP2024-0005 | LPC Meeting | Continued off Calendar | 2025-08-07 | accela | 2026-03-28 16:22:26 | Other | ||||
| 30 | 30 | 30 | 2 | 2276 SHATTUCK Ave | LMSAP2024-0005 | Completeness Review | Application Complete | 2025-08-07 | accela | 2026-03-28 16:22:26 | Other | ||||
| 501 | 501 | 504 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Case Closed | Research Completed | 2025-02-24 | Samella Stover | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 45 | 45 | 45 | 127 | 2820 San Pablo | P2022-0038 | Case Closed | Approved | 2024-12-06 | Allison Riemer | Complete | accela | 2026-03-28 16:22:26 | Other | ||
| 44 | 44 | 44 | 127 | 2820 San Pablo | P2022-0038 | Appeal | No Appeal | 2024-12-06 | Allison Riemer | Complete | accela | 2026-03-28 16:22:26 | Other | ||
| 42 | 42 | 42 | 127 | 2820 San Pablo | P2022-0038 | CEQA Determination | Categorically Exempt | 2024-11-21 | NC | Complete | accela | 2026-03-28 16:22:26 | Other | ||
| 43 | 43 | 43 | 127 | 2820 San Pablo | P2022-0038 | Staff Decision | Approved | 2024-11-19 | NC | Complete | accela | 2026-03-28 16:22:26 | Other | ||
| 525 | 525 | 548 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Approved | 2024-07-14 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 521 | 521 | 544 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Completed | 2024-07-14 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 481 | 481 | 484 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Approved | 2024-07-14 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 477 | 477 | 480 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Completed | 2024-07-14 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 524 | 524 | 547 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Approved | 2024-06-20 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 480 | 480 | 483 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Approved | 2024-06-20 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 522 | 522 | 545 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | No Notice Required | 2024-06-12 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 519 | 519 | 542 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Completed | 2024-06-12 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 478 | 478 | 481 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | No Notice Required | 2024-06-12 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 475 | 475 | 478 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Completed | 2024-06-12 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 520 | 520 | 543 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Completed | 2024-06-06 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 476 | 476 | 479 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Completed | 2024-06-06 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 523 | 523 | 546 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Continued off Calendar | 2024-05-16 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 479 | 479 | 482 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Continued off Calendar | 2024-05-16 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 518 | 518 | 541 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Completed | 2024-05-09 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 474 | 474 | 477 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Completed | 2024-05-09 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 517 | 517 | 540 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Application Complete | 2024-05-06 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 473 | 473 | 476 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Application Complete | 2024-05-06 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 538 | 538 | 561 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Approved | 2023-10-27 | MJ | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 494 | 494 | 497 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Approved | 2023-10-27 | MJ | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 29 | 29 | 29 | 134 | 2480 BANCROFT | DRCF2023-0005 | Case Closed | Approved | 2023-10-02 | TBD | Desiree Dougherty | Complete | accela | 2026-03-28 16:22:26 | Other | |
| 25 | 25 | 25 | 134 | 2480 BANCROFT | DRCF2023-0005 | Public Notification | Completed | 2023-10-02 | TBD | Desiree Dougherty | Complete | accela | 2026-03-28 16:22:26 | Other | |
| 537 | 537 | 560 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | City Council Approved | 2023-09-26 | MJ (Notice of Decision) | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 493 | 493 | 496 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | City Council Approved | 2023-09-26 | MJ (Notice of Decision) | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 28 | 28 | 28 | 134 | 2480 BANCROFT | DRCF2023-0005 | Posted Project Notices | Approved | 2023-09-21 | TBD | Desiree Dougherty | Complete | accela | 2026-03-28 16:22:26 | Other | |
| 27 | 27 | 27 | 134 | 2480 BANCROFT | DRCF2023-0005 | Posted Project Notices | Completed | 2023-09-13 | TBD | Desiree Dougherty | Complete | accela | 2026-03-28 16:22:26 | Other | |
| 26 | 26 | 26 | 134 | 2480 BANCROFT | DRCF2023-0005 | Mailed Project Notices | No Notice Required | 2023-09-13 | TBD | Desiree Dougherty | Complete | accela | 2026-03-28 16:22:26 | Other | |
| 24 | 24 | 24 | 134 | 2480 BANCROFT | DRCF2023-0005 | Staff Report | Completed | 2023-09-13 | TBD | Unknown | Complete | accela | 2026-03-28 16:22:26 | Other | |
| 536 | 536 | 559 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Notice Issued | 2023-09-12 | MJ | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 492 | 492 | 495 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Notice Issued | 2023-09-12 | MJ | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 23 | 23 | 23 | 134 | 2480 BANCROFT | DRCF2023-0005 | Completeness Review | Application Complete | 2023-09-12 | TBD | Unknown | Complete | accela | 2026-03-28 16:22:26 | Other | |
| 541 | 541 | 564 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Completed | 2023-09-11 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 497 | 497 | 500 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Completed | 2023-09-11 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 535 | 535 | 558 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Appeal to City Council | 2023-06-01 | MJ | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 491 | 491 | 494 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Appeal to City Council | 2023-06-01 | MJ | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 534 | 534 | 557 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Approved | 2023-05-11 | MJ | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 533 | 533 | 556 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Categorically Exempt | 2023-05-11 | MJ | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 490 | 490 | 493 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Approved | 2023-05-11 | MJ | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 489 | 489 | 492 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Categorically Exempt | 2023-05-11 | MJ | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 544 | 544 | 567 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Approved | 2023-05-04 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 500 | 500 | 503 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Approved | 2023-05-04 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 543 | 543 | 566 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Approved | 2023-04-20 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 499 | 499 | 502 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Approved | 2023-04-20 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 542 | 542 | 565 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | No Notice Required | 2023-04-13 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 540 | 540 | 563 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Completed | 2023-04-13 | Desiree Dougherty | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 498 | 498 | 501 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | No Notice Required | 2023-04-13 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 496 | 496 | 499 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Completed | 2023-04-13 | Desiree Dougherty | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 532 | 532 | 555 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Application Complete | 2023-01-23 | Katrina Lapira | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 488 | 488 | 491 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Application Complete | 2023-01-23 | Katrina Lapira | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 509 | 509 | 512 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Case Closed | Void | 2023-01-18 | SU | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 508 | 508 | 511 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Notice of Decision | Void | 2023-01-18 | SU | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 507 | 507 | 510 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Public Hearing | Void | 2023-01-18 | SU | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 506 | 506 | 509 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Hearing Notice | Void | 2023-01-18 | SU | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 505 | 505 | 508 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Appeal | Void | 2023-01-18 | SU | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 504 | 504 | 507 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Staff Decision | Void | 2023-01-18 | SU | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 503 | 503 | 506 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: CEQA Determination | Void | 2023-01-18 | SU | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 502 | 502 | 505 | 153 | 1701 SAN PABLO Ave | 1701 | ness Review | Void | 2023-01-18 | SU | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 531 | 531 | 554 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Resubmittal Pending Staff | 2022-12-23 | Katrina Lapira | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 487 | 487 | 490 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Resubmittal Pending Staff | 2022-12-23 | Katrina Lapira | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 539 | 539 | 562 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Application Complete | 2022-12-01 | M. | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 530 | 530 | 553 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Incomplete Pending Applicant | 2022-12-01 | Katrina Lapira | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 495 | 495 | 498 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Application Complete | 2022-12-01 | M. | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 486 | 486 | 489 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Incomplete Pending Applicant | 2022-12-01 | Katrina Lapira | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 529 | 529 | 552 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Resubmittal Pending Staff | 2022-11-01 | Katrina Lapira | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 485 | 485 | 488 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Resubmittal Pending Staff | 2022-11-01 | Katrina Lapira | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 528 | 528 | 551 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Incomplete Pending Applicant | 2022-10-20 | Katrina Lapira | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 484 | 484 | 487 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Incomplete Pending Applicant | 2022-10-20 | Katrina Lapira | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 41 | 41 | 41 | 127 | 2820 San Pablo | P2022-0038 | Completeness Review | Application Complete | 2022-09-29 | Allison Riemer | Complete | accela | 2026-03-28 16:22:26 | Other | ||
| 527 | 527 | 550 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Resubmittal Pending Staff | 2022-09-22 | Katrina Lapira | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 483 | 483 | 486 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Resubmittal Pending Staff | 2022-09-22 | Katrina Lapira | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 40 | 40 | 40 | 127 | 2820 San Pablo | P2022-0038 | Completeness Review | Resubmittal Pending Staff | 2022-08-30 | Allison Riemer | Complete | accela | 2026-03-28 16:22:26 | Other | ||
| 526 | 526 | 549 | 152 | 1598 UNIVERSITY AVE | DRCF2024-0004 | Unknown | Incomplete Pending Applicant | 2022-08-24 | Katrina Lapira | Complete | accela | 2026-03-29 00:46:10 | Other | ||
| 482 | 482 | 485 | 152 | 1598 UNIVERSITY Ave | 1598 | Unknown | Incomplete Pending Applicant | 2022-08-24 | Katrina Lapira | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 39 | 39 | 39 | 127 | 2820 San Pablo | P2022-0038 | Completeness Review | Incomplete Pending Applicant | 2022-08-10 | Allison Riemer | Complete | accela | 2026-03-28 16:22:26 | Other | ||
| 38 | 38 | 38 | 127 | 2820 San Pablo | P2022-0038 | Completeness Review | Resubmittal Pending Staff | 2022-07-15 | Allison Riemer | Complete | accela | 2026-03-28 16:22:26 | Other | ||
| 37 | 37 | 37 | 127 | 2820 San Pablo | P2022-0038 | Completeness Review | Incomplete Pending Applicant | 2022-05-06 | Allison Riemer | Complete | accela | 2026-03-28 16:22:26 | Other | ||
| 512 | 512 | 515 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Case Closed | Approved | 2013-08-08 | RW | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 510 | 510 | 513 | 153 | 1701 SAN PABLO Ave | 1701 | ness Review | Complete | 2013-07-31 | RW | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 511 | 511 | 514 | 153 | 1701 SAN PABLO Ave | 1701 | ness Review | Continuing legal use | 2013-05-01 | RW | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 514 | 514 | 517 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Case Closed | Completed | 2010-09-03 | AA CONV | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 516 | 516 | 519 | 153 | 1701 SAN PABLO Ave | 1701 | Stage: Case Closed | Completed | 2010-07-28 | AA CONV | Active | accela | 2026-03-29 00:42:06 | Other | ||
| 515 | 515 | 518 | 153 | 1701 SAN PABLO Ave | 1701 | ness Review | Complete | 2010-07-28 | AA CONV | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 513 | 513 | 516 | 153 | 1701 SAN PABLO Ave | 1701 | ness Review | Complete | 2010-06-24 | AA CONV | Complete | accela | 2026-03-29 00:42:06 | Other | ||
| 36 | 36 | 36 | 2 | 2276 SHATTUCK Ave | LMSAP2024-0005 | Notice of Decision | TBD | accela | 2026-03-28 16:22:26 | Other |
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);