How to check if a Kansas City business is licensed

Somebody is about to put a roof on your house, wire a basement, cut hair, or take a deposit. The question that comes to mind is not complicated, and it has a free public answer in Kansas City: has this business actually got a license?

You can have the answer in about a minute. What takes longer to understand, and what nobody tells you on the way in, is what the answer means. The city’s public list of license holders was last refreshed on January 15, 2026, and 94.3 percent of the licenses in it had already expired before 2026 began. It is a photograph of last year’s counter, and it is the only photograph the public gets.

The thirty-second version

Go to data.kcmo.org. Open dataset pnm4-68wg, “Business License Holders”. Type the name into the search box on the dataset page. That is it: 28,245 records, free, no account, no records request.

Each row gives you the trade name, the street address, the city, the ZIP code, the type of business, and the license year.

Read the license year before you read anything else. On the file as it stands, that year has usually already ended.

What a row actually tells you

More than most city files, and less than you want.

The columns are the trade name (dba_name), a legal company name (business_name) where the city has one, the address, the city, the state, the ZIP code, a business type, a license year (valid_license_for), and a map point. There is no owner, no phone number, no application date, no complaint history, and no revocation flag.

The license year is the field that carries the weight, and it is stored as a plain date. When The Kansas City Stare pulled the file on September 15, 2026, it broke down like this:

26,646 records, 94.3 percent of the file, carry a license year that ended before this one started.

The catch: the file stopped in January

The city last changed this file on January 15, 2026. That is eight months before this pull, and it is the reason the table above looks the way it does. Anything issued, renewed, lapsed, or revoked since mid-January is not in the public copy, in either direction.

That cuts both ways, and the second direction matters more than the first. A business that appears here was licensed at some point, which is real information. A business that does not appear here has not been shown to be unlicensed, because eight months of issuing and renewing are missing from the file. Neither a hit nor a miss settles the question on its own.

The city’s own position on this is reasonable and worth stating plainly: the live register lives in the Revenue Division’s system, and the portal file is a publication of it rather than the register itself. The Stare has not established why the publication stopped in January, and asserts no reason. What is established is narrower: the public copy of who holds a Kansas City business license has not moved since January 15, 2026, and the licenses inside it had mostly run out by then.

The second catch: one keystroke returns a confident zero

The trade names in this file are stored in capital letters, on 28,238 of the 28,245 rows. The portal’s column filter is case-sensitive, and it fails silently.

The Stare ran the same search three ways on September 15, 2026:

A zero from the column filter looks exactly like a business with no license. It is not an error, a warning, or a “no results for that spelling”. It is a clean zero, and the only thing wrong is the shift key.

Use the search box at the top of the dataset page. It ignores capitalization, and it searches every column rather than one, which is why it returns more. If you prefer the column filter, type the name in capitals.

The third catch: five files, one of them empty

Searching the portal for “license” returns what look like five or six separate datasets. They are mostly the same file wearing different hats. On September 15, 2026:

Every live one of them carries the same January 15, 2026 refresh date, so picking a different one buys you nothing.

The odd one is uwwp-6sdi, published as “Out of State Business License Holders”. It reports the same 28,245 rows as the full file, and every record it hands back is empty, because it is published as a chart rather than a table and carries no columns at all. Its written description is the most useful thing about it, and it is a plain statement of the underlying law: a business operating in the city must obtain an occupational license, whatever its size or composition.

A trap for anyone counting

If you use this file to say what Kansas City licenses most, read the business-type column carefully first. It holds two vocabularies at once.

Most of its 812 distinct values are industries: Commercial and Institutional Building Construction at 3,025 rows, All Other Professional Scientific and Technical Services at 2,928, Beauty Salons at 694. Then 2,050 rows carry a billing code instead, with values like Misc Rate 129 on 355 rows and Flat Rate 42 on 185. Those rows say how the license was priced rather than what the business does, and counting them as a trade will hand you a category that does not exist.

One more thing to know before you generalise from an address: the address in a row belongs to the licensee rather than to the work site. Of the 28,245 records, 16,802 give Kansas City as the city, and the file carries 1,678 distinct city values, including licensees based in the suburbs and out of state. A contractor working on your block can be licensed here and based anywhere.

What the file will not tell you

• Whether a license was revoked or suspended. There is no status column of any kind.
• Complaints, inspections, or discipline. None of it is in this file.
• Trade licensure. A city occupational license is not an electrician’s or a plumber’s license, and this file does not carry trade credentials.
• State registration. Whether the company exists as a legal entity is a Missouri Secretary of State question.
• Who owns it. 19,178 rows carry a trade name and nothing else.

How to check us

Every number above came from one unauthenticated request each against the city’s own data service on September 15, 2026. No key, no account. The count of the whole file is this:

# Count every business license in the file
curl "https://data.kcmo.org/resource/pnm4-68wg.json?\$select=count(1)"

It returned 28245. The expired share is this:

# Count the licenses whose year had already ended
curl "https://data.kcmo.org/resource/pnm4-68wg.json?\$select=count(1)&\$where=valid_license_for%3C'20260101'"

It returned 26646. The captures behind every other figure are archived with the story.

What we are asking the city: whether the public file will be refreshed on a schedule, and what a resident should use in the meantime to check a license that was issued after January 15, 2026. When the Revenue Division answers, this page gets the answer and a dateline. If you check a business here and find the answer did not match what the city told you on the phone, tell us: tips@kcstare.com.