pgx
PGX — Lightweight Postgres for AI agents. Written in Rust. Thousands of isolated databases in one runtime. 🐘
翻译准备中
尚未检测到更新。GitHub 发布版本后会显示在这里。
个人 GitHub 账号下公开仓库的所有者可以登录并验证所有权,自行管理介绍,无需管理员批准。
登录并生成验证文件,在 30 分钟内将其提交到此仓库的默认分支。其他分支或分叉仓库中的文件无效。然后在下方检查文件,即可无需管理员批准直接管理项目。请保留文件以维持管理权限。
如需登录,将前往登录页面。登录后请回到此处,再次点击所选的验证按钮。
在项目文件夹中运行 /nomorevibe verify,即可验证所有权并自行管理介绍。
一分钟完成验证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.