Newest sealed read: 2026-08-29. We read this source every day. We hold 54 sealed runs going back to 2026-06-26.
What this page is18,752 rows held · newest sealed read 2026-08-29
- We hold 18,752 companies across 4 metros.
- We have sealed 60 collection runs, on 54 separate days, from 26 Jun 2026 to 29 Aug 2026.
- Each city file is read on the same schedule. What differs is how much each city publishes, not how often we look.
- A company is kept once, on the day we first see it. Reading the same file again tomorrow does not create a second copy of a company we already hold.
Real rows out of our sealed copies
These are rows we read out of dated copies we keep ourselves. The live source shows today only, so once a row moves, what it said before is gone from the place you would go to look.
| Metro | The file we read | Companies held | Days we read it | Days something new arrived | Last new arrival | Last read |
|---|---|---|---|---|---|---|
| Los Angeles | https://data.lacity.org/resource/6rrh-rzua.json | 8,700 | 54 | 46 | 29 Aug 2026 | 29 Aug 2026 |
| San Francisco | https://data.sfgov.org/resource/g8m3-pdis.json | 4,539 | 54 | 53 | 29 Aug 2026 | 29 Aug 2026 |
| Chicago | https://data.cityofchicago.org/resource/r5kz-chrr.json | 3,376 | 54 | 37 | 29 Aug 2026 | 29 Aug 2026 |
| New York City | https://data.cityofnewyork.us/resource/w7w3-xahh.json | 2,137 | 27 | 2 | 20 Aug 2026 | 29 Aug 2026 |
| Column | Los Angeles | San Francisco | Chicago | New York City |
|---|---|---|---|---|
| Trading name | never filled in | 4,539 of 4,539 | 3,376 of 3,376 | 28 of 2,137 |
| Address | 8,700 of 8,700 | 4,539 of 4,539 | 3,376 of 3,376 | 1,612 of 2,137 |
| What the city calls the trade | 8,500 of 8,700 | 2,063 of 4,539 | never filled in | never filled in |
| What it is licensed to do | never filled in | never filled in | 3,376 of 3,376 | 2,137 of 2,137 |
| Licence standing | never filled in | never filled in | 3,376 of 3,376 | 2,137 of 2,137 |
| Trade code | 8,500 of 8,700 | 2,072 of 4,539 | never filled in | never filled in |
| Postcode | 8,700 of 8,700 | 4,536 of 4,539 | 3,370 of 3,376 | 2,137 of 2,137 |
| Map position | never filled in | never filled in | 2,966 of 3,376 | never filled in |
What this page cannot tell you
- Four metros. That is all this feed covers. If you sell into a fifth, we do not have it and we will say so rather than sell you the four.
- None of these files is a list of new companies. They are lists of businesses the city registered or licensed. A company that needs neither will never appear.
- Because we keep one permanent row per filing, this feed shows what appeared. It cannot show what was removed from a city's list, and it cannot show a field changing on a company we already hold.
- The four cities do not fill in the same columns. The table above is the real count of what is filled in, not a promise.
- 11 of the 65 days between 26 Jun 2026 and 29 Aug 2026 brought back no file with rows in it: 4 Jul 2026, 8 Jul 2026, 15 Jul 2026, 8 Aug 2026 and a 7-day stretch from 11 Aug 2026 to 17 Aug 2026. A business registered and struck off inside one of those gaps was never in front of us, and a quiet stretch on this page is us not looking as often as it is the city being quiet.
See the file we hold
You do not have to take our word for what is in the file. Here are 25 rows of the real thing, carrying all 7 of its columns, cut out of the dated copies we sealed ourselves. Nothing in it is made up and nothing in it is tidied up.
- Open the 25 rows as a CSVA plain spreadsheet file. It saves to your machine rather than painting itself into a browser tab, and it opens in Excel, Numbers or Google Sheets.
- The same 25 rows as JSONThe same rows again, laid out for reading with code.
Nothing on this page is for sale. The sample file is free to read, and so is every row on the page above it.
These 25 rows are a slice of the file, not the whole of it. What we cannot show you here is how far back it goes: the file goes back further than these rows do.
Start the thread
No pay button on this one yet. Email operations@ustechautomations.com. We are not charging for this feed. A monthly price is a promise that a new file turns up next month, and we will not make that promise until our store can keep more than one dated copy of a filing — it records each filing once, at first sight, so it can show you that a row appeared and never that anything about it changed. The dated copies below are real and they are free to read. Name the cities you follow. We reply with how far back our copies go for each, and how many days behind that city we currently are, before you spend anything.
Email us the cities you followWe hold 54 dated copies, from 26 Jun 2026 to 29 Aug 2026, and every filing carries its own filing date, which the source gives away for free. They are not evenly spread: the last dated copy carrying any Chicago row is 29 Aug 2026, and there are 37 of those. There is nothing to buy yet.
More from this feed
- Up one level: New business filingsThe whole feed, its price, and how the file arrives.