快播成人

Research Impact

Researchers shed light on city governments' data

Story by Jim Davis | Illustration by Alexia Lozano Wednesday, January 18, 2023

The idea grew out of a disagreement. Eva Maxfield Brown was an undergraduate student six years ago at the Information School. She was paying close attention to a controversial issue before the Seattle City Council to allow a new NBA arena to be built in the SoDo District. So was one of her professors, Nic Weber.

When the vote occurred, they read about it the follow颅ing day. They disagreed on why a council member voted a certain way and even whether that member鈥檚 vote was de颅cisive. So they sought out the council meeting recording.

鈥淚t took us a surprising amount of time to find the re颅cording of that meeting,鈥 said Weber, who is an assistant professor at the iSchool. 鈥淥nce we found the recording, it was a matter of searching through it. We both had some颅what different takes (on what the council member said). What we shared in common was a sense that this can and should be easier.鈥

Together, they knew that the machine learning and ar颅tificial intelligence tools taught at the iSchool could help.

鈥淲e decided, 鈥楲et鈥檚 make city council meetings easier to follow,鈥欌 Brown said.

Eva Maxfield Brown
Eva Maxfield Brown

So they developed the , a website that creates searchable transcripts of city council and committee meetings as well as establishing a way to track legislation and voting records of elected officials. Now in its third iteration, the Council Data Project compiles transcripts from 17 cities across the U.S. with more soon to come.

At first, Weber and Brown expected that this would be a tool used by the public. While that happens, Weber, Brown and other volunteers have found four groups that repeatedly use the tool: journalists, researchers, activists and city staff.

One of those using the Council Data Project is Arica Schuett, a Ph.D. student at Emory University in Georgia. In her work, she鈥檚 looking at social movements such as Black Lives Matter. She is working on a theory that activists who are more specific in what they want to accomplish can more easily get those demands enacted into policy than those who are imprecise.

A colleague who studied at the UW introduced her to the Council Data Project. Schuett said, 鈥淚t almost sounded too good to be true.鈥 She鈥檚 beginning to use the meeting transcripts in her research.

鈥淪o what it鈥檚 meant for me is that I can test this theory at scale and with a variety of different cities in ways that I couldn鈥檛 previously have done,鈥 Schuett said.

Another person who uses the Council Data Project is Philip James, who advocates for housing in the Bay Area city of Alameda where he grew up and owns a home. James found the Council Data Project on the internet.

鈥淚f you want government to be effective and accountable, then the best place to start is by making it possible and easier to see what鈥檚 actually happening."

鈥淚 knew that having a tool like this would actually be invaluable because most civic governments are making progress in terms of making the recordings and the data of their meetings available, but not very accessible,鈥 James said.

He reached out to the Council Data Project, which set up a location in his community. He鈥檚 volunteered to assist with the project.

James, who is a chief technology officer for a startup, sees a housing crisis in the East Bay Area, where most people of his generation are unable to afford a home. He said the Council Data Project has kept people clued into the civic conversation.

鈥淚t鈥檚 been extraordinarily useful for getting quick summaries of what has happened at recent meetings,鈥 James said. 鈥淎nd I have seen people on Alameda politics Twitter starting to link to meetings in the Council Data Project instance.鈥

Peggy Watt is an associate professor in journalism at Western Washington University. She鈥檚 also a longtime board member of the Washington Coalition for Open Government, a nonprofit that advocates for the people鈥檚 right to access government information.

She said that forward-thinking cities are being innovative in increasing transparency. Bellingham, for instance, is posting videos of city council meetings with links to navigate agenda topics. She said she was a fan of the Council Data Project, espe颅cially the ability to search transcripts. She noted that 鈥渘ot every颅body can go down there and sit at the city council meetings.鈥

鈥淚t was interesting to see that the information was so easily accessible through this,鈥 Watt said. 鈥淎s a resident, as a journal颅ist and as a journalism professor, I鈥檓 in favor of anything that makes public information more accessible to people.鈥

Assistant Professor Nicolas Weber
Assistant Professor Nic Weber

In Montana, volunteers set up a location that has created tran颅scripts for the City of Missoula. They鈥檝e also used the tool to pro颅vide transcripts of congressional debates and are working to use it to create transcripts of meetings of the Montana Legislature.

DemocracyLab Executive Director Mark Frischmuth was the one who brought the Council Data Project to Montana, working with software engineer Smai Fullerton. DemocracyLab is a nonprofit that pairs skilled volunteers and socially responsi颅ble companies with worthwhile projects.

鈥淚鈥檓 a big believer that sunlight鈥檚 the best disinfectant,鈥 Frischmuth said. 鈥淚f you want government to be effective and accountable, then the best place to start is by making it possible and easier to see what鈥檚 actually happening. And I think that this project does a great job of that.鈥

Frischmuth, who moved to Montana a year ago from Seattle, knew Brown when they both were organizers of a group called Open Seattle, a Code for America brigade that advocates for open data and civic technology. Frischmuth said that the earlier ver颅sions of the Council Data Project were clunky, or as he recalls Brown describ颅ing it, having 鈥渁 front-end interface only a back-end developer could love.鈥

鈥淭he big, big leap that they made a few years ago was making it some颅thing that was dead simple to use,鈥 Frischmuth said.

The Council Data Project continues to develop new tools to make city coun颅cil data accessible. For instance, a new feature being rolled out allows broad颅cast journalists to download a video or audio clip of a portion of the transcript to use on the air, offering those journal颅ists easy access to testimony at meet颅ings that they may not have attended.

About 1,500 local governments oper颅ate in the U.S. between cities, counties, legislatures and other jurisdictions. Most follow open meeting laws that re颅quire meetings to be open to the public and deliberations as well as decisions to be recorded for future access by the public. Most also use software called Legistar that compiles the votes.

鈥淥ur infrastructure really changes the kinds of questions you can ask, and ultimately what you can answer about local gover颅nance in action.鈥

The Council Data Project obtains most of its data from Legistar and pairs it with the recordings of the meetings. With machine learning techniques us颅ing open-source tools, the project team was able to take recorded speeches at council meetings and transform them into written texts.

鈥淣inety-nine percent of it is automat颅ed,鈥 Brown said. 鈥淚 just go to a dash颅board every day to see if everything is running OK. Then, I close it and I go work on other stuff.鈥

Weber directs the project while Brown holds the lone paid position maintain颅ing the Council Data Project. Brown is pursuing a Ph.D. at the iSchool in infor颅mation science with a special interest in open infrastructure. More than 50 peo颅ple 鈥 including several iSchool alums 鈥 have volunteered on the project.

Brown said she was taken aback by how opaque city government can be. 鈥淥ne of the things I鈥檝e discovered that surprised me is that most city council websites do not even have a page for a voting record,鈥 Brown said.

One of the hard decisions that the team made early 鈥 and a decision that has paid off 鈥 was to upload committee hearings onto the website, Weber said.

鈥淚f you think city councils aren鈥檛 stud颅ied, committees in city councils are not studied at all,鈥 Weber said. 鈥淲hen you have arguments about budgets and you have arguments about union contracts, those debates get settled in committee before it even comes to the city council. It is shocking how little attention is paid to committee deliberations.鈥

The Council Data Project hasn鈥檛 incorporated some other local govern颅ments, such as school boards, into its work. The reason is that the meeting laws are slightly different at school boards and recordings are not as de颅pendable as municipal government.

The goal for the next two years is to have the Council Data Project host pages for the 50 largest cities in the U.S. The challenge is funding. While most of the work is automated, there is a cost to set up each location. It鈥檚 been hard to communicate the need for a searchable council database and its uses to philan颅thropies and other funders.

鈥淓veryone that we talk to that鈥檚 either a researcher, a journalist or even just a civic technologist, it takes five or 10 minutes to explain the premise of the project, but once they start playing with it, they get it,鈥 Weber said. 鈥淥ur infrastructure really changes the kinds of questions you can ask, and ultimately what you can answer about local gover颅nance in action.鈥

Visit the Council Data Project at .