How this data is derived
Every figure on Council Watch is computed from the City's records, as kept in the Berkeley public-records archive. This page explains how, and where each figure stops.
At a glance
| Measure | Source | Keep in mind |
|---|---|---|
| Minutes of staff and Council time | Caption transcripts | Meeting time only; 38 of 73 transcripts give estimates |
| Minutes of spoken public comment | Caption transcripts | The public-comment span of each item |
| Letters | Annotated agendas | The Clerk's count; officials' submissions left out |
| Items members wrote, by role | Annotated agendas (the From line) | Roles as printed; routine items compared apart |
| Votes, motions, attendance | Annotated agendas | As the Clerk recorded them |
| Consent calendar items and amounts | Annotated agendas | Amounts as printed: authorized, with spending not shown |
| Topic of an item | This site | This site's grouping, reviewed and published |
Meeting time, and what it leaves out
Minutes measure time in Council meetings. They do not measure the rest of the Council's and staff's time. An item a member writes takes work before any meeting: drafting, agenda review, staff and legal review. That is true whether the Council discusses it or adopts it on the consent calendar in a single vote. No record measures that work in minutes, so the topic pages also count the items members wrote on each subject, heard or not.
Routine meeting business is not counted in minutes: ceremonies, the consent calendar as a block, Council and City Manager comments, general public comment, and adjournment.
Where the minutes come from
- Timestamped transcripts (Zoom captions, most of 2026 and late 2025) give caption time: when an item begins and ends.
- Court-reporter transcripts (most of 2025) have no timestamps. An item's minutes are its share of the transcript's words times the meeting's length: adjournment, less call to order, less recesses. These are estimates, drawn hatched.
- How good the estimate is. Tested on the timestamped transcripts, across 89 items of 10 minutes or more, the estimate's median ratio to true time is 1.01; the middle half fall between 0.98 and 1.05, and the extremes are 0.78 and 1.13.
Where an item begins and ends
Each transcript was divided into agenda items and procedural blocks by reading it. The boundaries have not yet been checked against the meeting video, so they are marked as inferred. Each records the words where it begins and its place in the transcript, so anyone can check it; the structure is published in the archive.
On a topic's chart, each bar links to its meeting's row in the table below it; on the Council time page, to that row on the topic's page. A bar adds up every item on the topic at that meeting, so it goes to the meeting's row.
Topics
- A topic groups items by subject so their time can be read side by side. Topics are this site's grouping and say nothing about an item's merit.
- City finances is shown as five separate topics on one scale, so no part is hidden inside a total.
- Audits go to their subject. Items presented by or about the City Auditor are also listed together.
- State, federal and international positions, such as resolutions and letters on bills, are a separate topic.
- Gaza had one agenda item. Speaker turns about it during general and consent public comment are also counted, when the turn was about it; turns that only touched on it are not.
- The classification is published in the source repository and changes only by reviewed pull request.
Letters
The count the Clerk gives in each annotated agenda: one per listed entry, the number printed after a name, or the number of "similarly worded form letters". Submissions from Councilmembers, the Mayor, staff and commissions are left out. Letters filed under an item take that item's topic; letters under a subject heading take the heading's.
The consent calendar
- Items adopted on the consent calendar pass in one vote with the rest of the calendar, with no separate discussion.
- A filled tick marks a meeting where at least one such item on the topic shows, in the annotated agenda, more than a routine item: an ordinance, member authorship, a move from the action calendar, revision at adoption, speakers, or letters. A taller tick means a larger amount, on a log scale from $1,000 to $1 billion. A number beside a tick counts the consent items on that topic at that meeting, when there is more than one.
- An amount is as printed: the largest figure under Financial Implications, otherwise the first in the Recommendation. It is the amount authorized; spending is not shown.
- An amendment to the annual budget counts once, at its first reading, on its net appropriation. Amendments are not cumulative. The full budget is adopted on the action calendar.
Who brought an item
The annotated agenda names an item's sponsors and, usually, their role. Six roles are kept apart and never added together: lead author (the only author, or the one the agenda's Contact line names), joint author (any other author or co-author), co-sponsor on the agenda as posted, co-sponsor added at the meeting (the transcript shows it), co-sponsor added later where the record does not say when, and named with no role. Comparisons between members count items on City business, leaving out routine items (relinquishments, donations, commemorations, appointments, excused absences) and counting state, federal and international positions separately.
Votes, motions and attendance
- The vote counted for an item is the vote on its final motion, as printed.
- Where the Clerk printed "All Ayes" without names, that vote is shown as "All Ayes", because the record does not show who was present at that moment.
- A failed motion followed by the one that decided the item is shown as competing, unless the transcript confirms it was a substitute.
- Attendance is absence at roll call and later arrival, as recorded. It says nothing about reasons, and early departures are not recorded.
Data and corrections
All the data behind these pages is on the Data page, and the code and the full method are in the source repository (council time, members). To report an error, open an issue with the source and the page or timestamp that supports it.