pgx
AI 에이전트를 위한 경량 Postgres, Rust로 구현, 하나의 런타임에서 수천 개의 격리된 데이터베이스 제공
LMIA를 통해 외국인 임시 근로자를 채용하는 캐나다 고용주와 위치, 승인·거부 현황을 매일 업데이트
Which Canadian employers are applying to hire temporary foreign workers through an LMIA, where, and which were approved or refused. Updated nightly.
데이터Python · TypeScriptGitHub @LMIAwatch온라인운영자 미확인
써 보셨어요? 한 번만 눌러 주세요. 로그인은 필요 없어요.
아직 감지된 업데이트가 없습니다. GitHub 릴리스가 나오면 여기에 보입니다.
개인 계정의 공개 저장소 소유자는 GitHub로 로그인해 운영자를 확인하고 소개를 직접 관리할 수 있습니다. 관리자 승인은 필요하지 않습니다.
로그인한 뒤 확인 파일을 만들어 이 저장소의 기본 브랜치에 30분 안에 커밋해 주세요. 다른 브랜치나 포크의 파일은 인정하지 않습니다. 파일을 올린 뒤 아래에서 확인하면 관리자 승인 없이 관리할 수 있습니다. 자격을 유지하려면 파일을 남겨 두세요.
로그인이 필요하면 로그인 화면으로 이동합니다. 로그인 후 이곳으로 돌아와 원하는 확인 버튼을 다시 눌러 주세요.
프로젝트 폴더에서 /nomorevibe verify를 실행하면 소유권을 확인하고 소개를 직접 관리할 수 있습니다.
1분 만에 확인하기Public records of Labour Market Impact Assessment (LMIA) activity in Canada
저장소 README에서 가져옴
README 전체를 불러오는 중입니다.
README 전문 보기 ↗Public records of Labour Market Impact Assessment (LMIA) activity in Canada: which employers are applying to hire temporary foreign workers, where, when, and which applications were approved or refused. Every row links to the government record it came from. The site rebuilds itself once a day, at midnight UTC, from the sources (retried at 06:00 and 12:00 UTC when that run did not finish clean); the scheduled run is the only way its data changes.
pipeline/ Python: scrape, load, merge, indicators, export (owns data/lmia.sqlite)
site/ Cloudflare Worker: pages + JSON API over the pipeline's static JSON
pipeline/schema.sql the one schema both halves use
data/ raw downloads and outputs (git-ignored)
site/design/wireframes/ the page structure the site implements
.github/workflows/nightly.yml the one scheduled run that refreshes data and deploys
.github/workflows/deploy-site.yml a manual site-only deploy that cannot touch the data (docs/site-deploy.md)
The data ships as static assets with the Worker, the browser filters the map page, a database of its own answers the search page over every record since 2014 (the static files are its fallback), another holds only what visitors submit, and object storage holds the downloads.
cd pipeline && pip install -e .[dev] && pytest
python -m lmia_pipeline run --limit 1 --detail-budget 2 --db ../data/lmia.sqlite
cd ../site && npm install && npm run db:local && npm run data:local && npm run dev
The operating rules (operator anonymity, crawl politeness, what is stored and what is published) are kept outside the repository.
The ESDC positive and negative LMIA employer lists are published on open.canada.ca
under the Open Government Licence, Canada. Job Bank content is Government of Canada
material reproduced with attribution. The IRCC list of employers found non-compliant
is published on canada.ca. The program conditions page reads three ESDC pages on
canada.ca (LMIA processing times, the low-wage refusal-to-process list, the wage
thresholds), reproduced under the canada.ca terms and conditions
(docs/program-conditions.md). Each derived file keeps the terms of its sources.
Files derived only from ESDC's lists and the federal corporations extract are under
the Open Government Licence, Canada. Job Bank and IRCC material stays under the
Government of Canada terms of use on canada.ca. Quebec register fields are under
CC BY-NC-SA 4.0. Profiles also show federal grants and contributions (Open
Government Licence, Canada), Alberta Employer Records (Open Government Licence,
Alberta) and US FMCSA carrier census records (public domain), each matched to
employers by name and place (see docs/grants.md, docs/alberta-employer-records.md
and docs/fmcsa.md). The licence table on the site's Data page is the reference.
The files derived from ESDC's lists (the approved and refused quarterly lists and the index of source files with their checksums) are deposited on Zenodo, one version per ESDC quarter.
| DOI | |
|---|---|
| All versions (resolves to the newest) | 10.5281/zenodo.23488706 |
| 2026 Q1 | 10.5281/zenodo.23488707 |
To cite a figure, use the version you worked from:
LMIA Watch (2026). LMIA Watch: ESDC positive and negative LMIA employer lists, derived files (Version 2026Q1) [Data set]. Zenodo. https://doi.org/10.5281/zenodo.23488707
Later versions are listed on the record page, and the site's Data page shows the citation for the newest one.
The code, documentation, page text, design and brand in this repository are source-available under LICENSE.md: published for inspection, not licensed for copying, redistribution or running another site. The data licences above are unaffected. The project does not accept issues, pull requests or contributions; reports about records go through the site's corrections form.