Ipsoot.Data

What We’ve Built / Data

Pulling records from APIs and public downloads into one clean source

What public records say about an employer is spread across dozens of government databases, each with its own format and its own spelling of the employer’s name. Pulling it together by hand is slow, and it’s out of date by the time it’s done.

Pulledfrom government APIs and data downloads
Checkedbefore it replaces what you have
Matchedinto one record per employer
Kept currenton each source’s own schedule

What the union gets

One list of employers, built from public records and kept current. Each employer appears once, with everything the records say about it: its legal and trade names, where it operates, the licences it holds and, where a state publishes them, its workers’ compensation claims. It’s already linked to the contracts that name it and to the bargaining notices filed with federal mediators.

Straight from the source

Where an agency offers a data service (an API), we connect to it directly. Where it publishes data files instead, they’re downloaded automatically each time the agency updates them. When a source limits how much can be requested in a day, collection is paced to stay within the limit and picks up where it left off the next day.

Checked before it’s used

Every delivery is tested before it goes any further: required fields present, record counts in the expected range, nothing malformed. A source that arrives incomplete is flagged instead of quietly passed along.

One employer, one record

The same hospital or contractor turns up under a dozen spellings, trade names and addresses. Names, addresses and ID numbers are standardized, then matched, so each employer becomes a single record linked to every source it appears in. Clear matches are settled by rules; only the hard cases go to our local AI, as described on our Ethical AI page.

Example: employers in Oregon and Washington

Our employer list is built from:

  • the Oregon and Washington business registries, and Washington’s business licences;
  • IRS records of nonprofit organizations;
  • federal registries of health care providers, colleges and school districts, and the Census Bureau’s list of local governments;
  • Oregon contractor, building trades, liquor and cannabis licences, and workers’ compensation records.

Ready for your research

The same employer records connect our contract collection, bargaining notices and corporate research, so a question about an employer starts from everything we know about it. The same approach works for any source your campaign depends on.