Web app · Free · Louisville, Kentucky

Lou

Ask where Louisville's money goes, in plain English. Lou answers from the city's own open data and shows its work.

What it does

A question in, a number out.

Louisville Metro publishes what it spends, but the records are millions of rows in spreadsheets, and finding one answer means knowing which file, which column and which of several spellings of an agency's name to look for. Lou is for you if you live in Louisville, cover it, or work with the city, and you want the answer without the spreadsheet.

Ask it like a person

How much did the Fire department spend on vehicles in 2024? Which agencies spend the most? What do top officials earn? You type the question the way you would say it.

Answers from the city's records

Lou reads spending, salary, capital project, contractor and staffing data published by Louisville Metro, for fiscal years 2008 to 2027.

A figure, a chart and a table

Each answer leads with the number, charts it when a chart helps, and gives you the rows behind it to sort or download.

It shows its work

Open How Lou got this answer to see every step it took and the exact query it ran, so you can check a number before you rely on it.

Context when there is some

When council legislation explains a line of spending, Lou cites it by file number.

Nothing to install

It runs in your browser. There is no account and it is free.

The app

What it looks like.

Lou's home page: the heading Where does Louisville's money go?, a question box with an Ask Lou button, and example questions about spending, people and pay, and contracts and projects
Start with your own question or one of the examples
How it works

Three steps.

01

Ask

Type a question about spending, salaries, contracts or capital projects, or pick one of the examples.

02

Read the answer

You get the figure, a short explanation, and a chart or table when there is one to show.

03

Check it

Look at the query Lou ran. It is a proof of concept and the answers are AI-generated, so check before you quote a number.

Good to know

An independent project, built on public data.

The data comes from the Louisville Metro Open Data Portal and is provided as-is. Lou is not affiliated with or endorsed by Louisville Metro Government.

  • The questions you ask and the ratings you give are stored to improve Lou. Please do not type personal information.
  • It is a proof of concept. Expect hiccups.
  • Answers are written by an AI model from the query results. The query is always shown.
  • The code is public on GitHub.
  • Open Lou →