Category: Business

A Claude Code skill to find relevant parts of someone’s speech in a video

Political speeches, candidate interviews, and public hearings contain dozens of quotable moments — but finding them means scrubbing through hours of video. I created a Claude Code skill that helps me speed up the process of finding the right section of a speech.

The skill, called speech-clip-extractor, takes a video file and a set of topics you care about, then returns a table of timestamps, quotes, and reasons each moment is worth clipping. From there, it extracts the clips using ffmpeg.

Transcription with mlx-whisper

The first step is generating a subtitle file. I used mlx-whisper, Apple’s port of OpenAI Whisper optimized for Apple Silicon. Running on the Neural Engine instead of the CPU, it transcribes a 60-minute video in a few minutes rather than the better part of an hour. One gotcha: mlx-whisper only installs on arm64 Python. If you’re running Anaconda, which ships as x86_64 under Rosetta, the install will silently fail. The fix is to use Homebrew’s Python instead.

Finding the highlights

Once Claude Code has the VTT transcript, it reads the full text and looks for moments that match the topics I specified. For a recent recorded interview with a Cook County Commissioner candidate, I asked it to find moments about property taxes, vacant land, housing, and the Cook County Land Bank. Claude returned a table of eight clips with timestamps, direct quotes, and a one-line note on why each moment was notable — things like “specific stat, strong soundbite” or “names names, calls out a specific corrupt dynamic.”

I also used this skill to locate specific timestamps in Governor Pritzker’s speech from his budget address last week, to locate the parts about housing that I had heard live as he was speaking. It allowed me to quickly pull out clips to show the part when he said “everything is just too damned expensive” and when he talked about parking reform.

Cutting the clips

The skill uses ffmpeg to extract each clip and optionally concatenate them into a single video. Even if you don’t use the step of extracting each clip having the timestamps can be immensely helpful to guide you to the right spot in a long video file.

For vertical social media cuts, it applies a 9:16 center crop. When there are two speakers in the frame, it switches the crop to follow whoever is talking — cutting to the left side of the frame when the interviewer speaks and the right when the candidate answers. However, in my experience so far the crop is poorly done so I created my own crop. (I use Final Cut Pro for iPad.)

The whole workflow — transcription, analysis, extraction — takes about ten minutes for a one-hour video. What used to require scrubbing through footage manually is now a matter of describing what you’re looking for and letting the model find it.

A short list of features of the Netherlands that I still try to wrap my head around

The Netherlands is the country I’ve visited the most, going there eight times between 2011 and 2022. I’ve obsessively visited 31 cities, the Hoge Veluwe national park, and plenty of other places outside cities.

Here are three land use and infrastructure characteristics that continue to fascinate me.

Transportation systems, obviously

Learning about how the Dutch created the safest network of streets for cycling is what started my near-obsession 15 years ago.

Then I went there in 2011 and I got to experience it for myself (photos from that trip).

I think the quality, capacity, likability, and integration of their transportation systems can be summarized best, for Americans who haven’t been there, by learning the results of a Waze survey: People who primarily drive in the Netherlands are more satisfied with the driving in their country than people in other countries are with driving in theirs.

In other words…if you like driving, then you should also care about what the Netherlands because they happened to also create the most driver-friendly transportation system.

Creating land & living with flooded land

As a novice, it’s probably easier to notice and understand how the Dutch create, move, and live with flooded land from above. There have been moments while I was cycling in the country where I’ve ridden past “polders” and former lakes and seas only to realize it later that I had biked through a massively transformed area that appeared entirely natural.

When I lived in Rotterdam for three months in 2016 I tried to visit as many places across the country as I could. I especially wanted to visit Flevopolder, the larger part of the Flevoland province, built from of the sea in 1986 where 317,000 people live.

I visited both major cities on the Flevopolder in the same day, Almere and Lelystad, the capital. I cycled from Almere (photos) to the seafront of Markermeer, and…get this…had to ride uphill because the land is below sea level.

Reaching the edge of Flevopolder, where it borders the sea called Markermeer
Cycling uphill to meet the sea north of the city of Almere, in the Flevoland province of the Netherlands.

Most Dutchies live below sea level, and the country has massive land and metal engineering works to keep the water in check.

The Dutch, especially in and around Rotterdam, come up with new ways to deal with water and export this knowledge abroad.

While the existing and planned measures should be sufficient until at least 2070, too much uncertainty over the progress of climate change remains afterwards to assess whether the city will truly stay liveable.

Some assessments suggest that if the sea rises by 5m – an estimate in sight within a century, considering the unpredictability of the rate that Greenland and Antarctica’s glacier will melt – Rotterdam will have no other choice but to relocate.

“Rotterdam: A bastion against rising sea, for now”
By Zuza Nazaruk

The country may rely on electricity to survive more than most: it’s needed to keep the pumps working, to keep the water in the sea instead of in and over the land.

How productive their agriculture industry is

By land area, the Netherlands is a very small country; it would be the tenth smallest state in the United States. By population, it would be the fifth largest state (17.6 million, greater than Pennsylvania’s 13 million).

Given that, how is it that the Netherlands is the world’s second largest exporter of agricultural products by value, after the United States?

Simple answer: High-quality, high-value, high-demand foodstuffs; space-efficient farming practices, including a significant amount of food grown vertically and in greenhouses. And, I don’t remember if this was in the article, very good transport connections to trading partners through seaports, canals, railways, and motorways.

I was surprised to see that both brands of canned cold brew coffee sold at the convenience store in my apartment building are produced in the Netherlands.

It’s impossible to track the many investment programs in disinvested Chicago neighborhoods

An article in the Chicago Tribune that announces Chase bank’s increase in the amount of grants it is offering in Chicago goes on to detail myriad existing grant, loan, and donation programs from public and private sources for neighborhoods that have few jobs, few resources, no privilege, and lots of quality of life problems.

But not all of the programs. There are more, but I don’t even know how many more, nor do I know all of their names. I just know that I’ve read about them before.

The article is where I learned that Benefit Chicago – a $100 million investment fund  operated by the Chicago Community Trust, MacArthur Foundation, and Calvert Foundation, but hasn’t finished raising all the money – has started giving out loans and grants to Chicago recipients, including Garfield Produce Company.

Calvert Foundation has a brokerage (I think that’s the best name for it) through which regular Chicagoans can invest $20 minimum and earn 1.0% interest on that investment after 1 year. Longer periods net higher returns.

Anyway, back to my point…

If I were a business owner in Chicago, and I wanted financial assistance to expand my business – say, buy more kitchen equipment to be able to produce more food – where would I start looking?

Is there a list somewhere? Will my alder know? Is there a group in my neighborhood that can help me track down a funder? Is this more complicated than getting a VC to fund a “Bodega killer“?

One of the things I’ve tried to do with the tens of thousands of maps on Chicago Cityscape is highlight when a business or property owner could be eligible for financial assistance based purely on their geography.

Map of areas where you, as a business or property owner, can get funding assistance from publicly-funded programs.

These geographers where government funding is available are marked with a green icon of a dollar bill that links to a Resources page I adapted from a pamphlet the city’s planning department used to produce. These include:

  • TIF (tax increment financing) districts, including whether the district participates in the Small Business Improvement Fund
  • MMRP (micro market recovery program)
  • Enterprise Zone (a state of Illinois program)
  • Industrial Growth Zone (expedited approval processes + environmental remediation money)
  • Special Service Area (SSA; business improvement district)
  • Chicago landmark and National Register of Historic Places districts
  • Planned Manufacturing Districts (PMD), although I forget what assistance is available here
  • Neighborhood Opportunity Fund zones (an interesting policy that charges developers for additional density and grants that money to small business owners on the South and West Sides)

Not every area within the above categories is in a disinvested neighborhood because not every program was designed for that. 

Green dollar bill signs on Chicago Cityscape

Once you know this, I guess you can target your research. But there’s still a lot more to do. To start: Where the heck is Chase investing? Where the heck is Benefit Chicago investing? They don’t publish maps, as far as I can tell.

Actually, thinking about this more, as I reach nearly 400 words in this blog post, I’ve got another idea: Show up at Rahm’s new Small Business Center at City Hall and ask them.

The inside track on how Aldertrack works

Mike Fourcher and Claudia Morell talk about Aldertrack at ChiHackNight

Crappy iPhone shot of Mike Fourcher (left) and Claudia Morell (right) talking about the information that Aldertrack collects on Chicago City Council, boards, commissions, and electeds.

Mike Fourcher, founder of Aldertrack, and perpetual “news startup antagonist” (okay, I don’t remember the actual adjective he used), joined his colleague Claudia Morell, a reporter, and us at ChiHackNight on Tuesday night to explain how Aldertrack works.

ChiHackNight heard from Aldertrack’s former staffer Jimm Dispensa earlier in the year about the tools and processes they use to publish, but it’s hard to call tonight’s meeting a followup from the meeting with Dispensa, because they were focused on entirely different parts of the operation.

Tonight was more about the politics that Aldertrack “interferes” with.

As with most of my posts derived from my notes on the ChiHackNight collaborative agenda document these are paraphrased sentences, not quotations.

Presentation title: “Not really open data”

There are ~70 different boards and commissions in the City of Chicago, but information about each is sparse. Most don’t have their own website, but the bigger ones do.

In our quarterly report product – the first was published in August – we display a picture, a name, background on their day job, an email, and a phone number. It was hard to find this kind of information. If their appointment requires City Council approval then it can be a little easier to find the resolution that appointed them.

Issues in hunting down information

  • Sometimes information didn’t match.
  • Sometimes the source documents is missing data, like the appointment or expiration date.
  • The mayor’s fashion council, we weren’t sure if they met, what their purpose was.
  • Eventually we found pension board compensation amounts in state law.

Fourcher: City agency staff have basically been trained that they should never answer any questions from the press. The rule is to refer press to the mayor’s press office, so that they can make it hard for the press to get information. There’s a lot of information that’s obscure, whether purposely or not.

We published the Quarterly Report as a PDF but eventually we want to put it online so that you can click on someone’s name and see what other boards they serve on.

The content we find, and put in our Quarterly Report and Clout.wiki, is something we refer to in our reporting.

[I didn’t take any notes about the Clout.wiki, but there’s a lot of information in the questions and answers below.]

Q&A

Alex Soble: Does the city council do more than we think they do?

Claudia: There’s this perception that aldermen are a rubber stamp, or just there to approve the mayor’s agenda. I think that’s part of the problem.

Because people think that the news media is less likely to cover the things that are covered in the “big” committees (like finance). The education committee doesn’t seem to matter to a wider audience.

We put the TIF expenditures data in our newsletter, and I don’t think that’s something you found in the Tribune.

I also come from the NYC city council, where it operates differently. There’s less conflict in Chicago, especially when it comes to the budget [Claudia described how the city council ripped Bloomberg’s proposed budget to shreds and inserted their own pieces.]. There’s no speaker here that decides what bills get voted on, while Chicago’s mayor presides over the meeting.

Mike: Chicago isn’t a true representative democracy, but it’s less of a terrible thing than people think it is.

Eric Sherman: Why isn’t the wiki open?

Mike: It’s our site, and we don’t want to take the risk that people write dumb things. We close it off to everyone. We would love to hear from someone who has information, and we would check it, and then post it. We want to run it through the journalistic process we adhere to.
Claudia: We don’t have enough staff to moderate the wiki.
Mike: I don’t think even one full-time person could do it.

Forest Gregg: Many of the application processes are hard to figure out in Chicago. I love the documenting you’ve been doing of all the different commissions. What have you heard from users if they would like to hear things more on how things work? Lucas Museum…a number of steps that have to happen, a number of bodies that have to sign off on it. For developers, there’s a cottage industry around permit expeditors, but there’s the same problem of knowing how to step through other development processes.

Claudia: Land use boards…Zoning Board of Appeals that’s a 4-member panel that decides whether or not you can get a special use permit (to build a set back garage, or something).
Mike: We initially had this idea that we would have a regular city council product, and a separate zoning product. What we learned is that people who have an interest in land use, have a passing interest. Once the thing you’re interested in is “over”, like a proposed project that gets approved, then you’re not interested anymore.
The people that fall into the category of perpetual interest in land use, they all know each other. We decided to roll that into the main subscription. We have thought of doing trainings on how zoning works, here’s how you build a building in Chicago.
Forest: I think you’re in a good position to…make some flow charts. That information is shockingly hard to find right now, unless you have a professional interest in that area.

Jerry Mandujano: You started with campaigns [I missed the rest of the question] Is there something else that people should know?

Claudia: Property taxes, most other press focuses on how the changes would affect you on a personal level. What we do, we tend to be focused on the nitty gritty, the language of the ordinance, what conversations are going on around City Hall.
Mike: The demands of most of the news organizations is very different, and we have a blank slate. Every time someone zigs, let’s zag, and see what happens. If you read just one day of our product, you’re going to react, “Omg, what is this stuff? There’s so much detail.” If you read us over time then you’re going to get a good picture.
Fran Spielman, that woman is a freaking machine at the Sun-Times, she writes so much, and I mean this in the most positive way. She went on vacation for two weeks, and on the day she came back she published three articles. She has her head above water and she’s easily doing backstrokes.

[Someone commented that there used to be the City News Bureau which did a lot of what Aldertrack is doing.]

Steven Vance: Alderman show their true selves on social media. Many alderman have few followers and I think you’re spreading their thoughts further than they have been themselves. (I was referring to a new section on the free Aldertrack newsletter where they were posting links to weird or interesting tweets.)

Mike: And we’ve been getting some ire for that! There’s a lot of information out there, and we scoop it up, sift through it, and that’s shoe leather reporting. There’s a lot of sitting on the phone and calling people.

Jefferson Park station renovation highlights train station planning deficiencies

Jefferson Park train station rendering

Jefferson Park train station rendering from the City of Chicago. The only difference you see is canopies. What you don’t see is a walkable connection ut thisetween shops southeast of here and the train station – they’re separated by a strip of parking.

Plans for the renovation of the Jefferson Park CTA station are illustrative of the City’s failure to think deeply about how to design the projects that is funding in a way that maximizes potential for residential and commercial development around train stations.

The changes proposed for one of Chicagoland’s most important transit centers are weak. There’s no development plan, or any kind of neighborhood plan or “Corridor Development Initiative” for the Jefferson Park transit center.

Current city policy identifies train stations as optimal places to build new housing and commercial uses.

Without challenging the design to respond to this policy the transit center will continue to use neighborhood space inefficiently and doesn’t respond to demands from residents to improve pedestrian and bicyclist safety and increase economic development.

Judging by the renderings, nothing is changing at the Jefferson Park Blue Line station (4917 N Milwaukee Ave). All of the improvements save for the canopy are invisible in this rendering. The CTA’s list of improvements reads like the superficial makeover that many stations got in the Station Renewal program almost three years ago, a stopgap measure until Your New Blue could begin.

There will be LED lighting, new paint, new escalators and stairs, new paving, and a new canopy. Only a few of those things make the station easier to access and use.

Jefferson Park is a major asset to the neighborhood and the city. The station serves CTA trains, Metra trains, CTA buses, and Pace buses to Chicago’s suburbs. The CTA’s September 2014 ridership report [PDF] said there are an average of 7,420 people boarding the Blue Line here each weekday, a 0.1% increase over September 2013. It’s the busiest Blue Line station outside of the Loop and O’Hare airport.*

On Twitter I said that the station should be surrounded by buildings, not bus bays. I’m not familiar with how many routes and buses use the station daily, and I’m not suggesting that space for buses go away. I’m challenging the Chicago Transit Authority and Mayor Rahm Emanuel to come up with a better plan for vehicle and pedestrian movements, and to start welcoming new development.

I pointed out the new Wiehle-Reston Silver Line station in Virginia where a residential building was constructed atop a bus bay (where I transferred from the Washington Flyer bus from Dulles). A plaza connects the bus bay to and apartment lobby and the Metrorail station.

Bus bays under an apartment building in Reston

The bus bay at the Wiehle-Reston Silver Line station in Reston, Virginia, is under an apartment building and plaza linking it to the Metrorail station.

The Metropolitan Planning Council conducted a consultation for the Logan Square Blue Line station – Your New Blue will make upgrades here, too – and the next door city-owned parking lot. Their consultation involved 700 people to decide what development at this station should look like. Their desires were pretty specific: there should be affordable housing, but not any higher than six stories.

The current policy, enacted as an ordinance and expressed in other city documents, allows developers to build more units in the same plot and save them and their tenants money by building less parking. But this policy is insufficient in that has no design review or public consultation attached. It also provides no zoning recommendations to expand the number of places to which it can apply.

A development plan, for which the CDI serves as a good, starting model, would bring residents – and people who want to live in the neighborhood – to discussions about if and how the neighborhood should change. It would hook into another city proposal, from the Chicago Department of Transportation, to build protected bike lanes on Milwaukee, but which ultimately failed. The process would probably uncover latent demand to build new housing in the neighborhood that’s stymied by incompatible zoning.**

The city’s recent choices for development and (lack of) urban design at this station as well as across from the Halsted Green Line station in Englewood where the city is selling vacant land to build a Whole Foods-anchored strip mall demonstrates how little deliberation there is in maximizing transit-oriented development, or TOD.

Their suburban forms are the antithesis of how we should be designing the stations and their environs – they should have higher densities and walkable places.

* Metra has published its 2014 station-level counts! This station had 599 daily boardings, yet not every train stops here. The Union Pacific Northwest (UP-NW) line that stops at Jefferson Park saw a 3.8% increase in ridership [PDF] from January to September 2014 versus the same period in 2013.

** There are no parcels near the Jefferson Park transit center that allow the transit-adjacent development ordinance to take effect; developers have to go through an arduous and sometimes costly process to persuade the alderman to change the zoning. The ordinance only affects Bx-3 districts (where x is 1-3 and -3 is the allowable density identifier).