What this site is

This site has two linked databases, both sourced from Government of Canada open data:

What "approved" does and doesn't mean

The LMIA Database only shows positive (approved) decisions. The federal government does not publish a list of pending or refused LMIA applications — that information isn't public from any source, so there is no "application status" tracker beyond "this employer has, at some point, had at least one LMIA approved." An employer can appear here with a large number of approved positions and have never been found non-compliant; the reverse is also possible. Treat the two databases as separate facts, cross-referenced by name only where both independently exist.

Data sources, licensing & architecture

Violations data is pulled from canada.ca/.../non_compliant.json, which backs the official page Employers who have been found non-compliant. LMIA Database data is aggregated from every quarterly/annual release (2014–present) of the Positive LMIA Employers List open dataset. The Map page's location circles use postal-code-area (FSA) centroids from GeoNames (CC BY 4.0), matched to each employer's postal code — this gives neighbourhood-level, not exact-address, positioning. All of this is reproduced here in part under the Canada.ca non-commercial reuse terms / Open Government Licence – Canada, with attribution and a link to the original. This site is independently run and has no affiliation with, and is not endorsed by, the Government of Canada.

Because the LMIA dataset alone covers roughly 400,000 historical records, the site ships it as a single indexed SQLite database (data/site.sqlite) that your browser downloads once and queries directly using sql.js (SQLite compiled to WebAssembly) — rather than as a giant JSON file, which would be too large to load or search efficiently. The violations list is small enough to stay in the same database. Both datasets are updated by re-running the import scripts in this project's GitHub repository; see the timestamp on each database page for the last snapshot.

Why this exists

Reporting and court records show that abuse of the TFW program is a real, documented problem, not an isolated one:

This site's purpose is to make the government's own enforcement record easier to search and browse — not to accuse any specific business of wrongdoing beyond what the government has already formally found and published. If you believe an entry is inaccurate, it should be raised with ESDC/IRCC directly, since this site only mirrors their published data.