Our primary challenge is to develop programs that download minutes and agenda packets from city councils and school boards in Contra Costa County, California (although generalized solutions will be useful in other parts of the US and potentially internationally. Once we have gathered the documents for a particular jurisdiction we plan to feed them into Google's Notebook LM which analyzes the documents and allows user to query them using a chat interface.
Please refer to these repos for previous efforts to solve this problem:
https://github.com/govwiki/civic-scraper
https://github.com/govwiki/civic-scraper-v2
https://github.com/govwiki/misc_scraping_code
We have a list of Contra Costa County governments at: https://docs.google.com/spreadsheets/d/e/2PACX-1vSMYdG6nuHu31c5mmfs5SmAcI2VzfjSFe71EGkcfkd2LqOLWvswTk5I9e5_BJvZ2Y_M6iRK69s9CbbU/pubhtml
We have an example of a NotebookLM Notebook at https://notebooklm.google.com/notebook/23c7f258-3e3e-4548-8e0d-213c28013bfe .
To see it you'll need a GMail address and should send an access request to [email protected].
Also, please see the orientation slides I will be showing at the start of in-person development on March 1st: https://docs.google.com/presentation/d/15wPZuIvHUkEZOijhDRKc4QPIsDAiWYJPAJtYj3cxB5o/edit?usp=sharing
Feb. 24, 2025 - March 1, 2025
CoCoTax
Walnut Creek, CA 94596, USA
$0