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.