NGO chapter registry match (federated)
Atlas view
NGO chapter registry match (federated)
api_v1.ngo_chapter_registry_matchThe 9 federated NGOs' chapters, found by name pattern in Brønnøysundregistrene's register.
Built from
This Atlas view joins data from the following upstream sources. Click through for provenance, methodology, and citation.
Showing direct dbt parents. See full lineage in /lineage/ →
Columns
| Column | Description |
|---|---|
| chapter_orgnr | The chapter's own 9-digit organisasjonsnummer. Natural key for this view. |
| chapter_id | '<ngo_slug>-<chapter_orgnr>', the conformed cross-NGO chapter identifier. |
| ngo_orgnr | 9-digit Brreg organisasjonsnummer of the parent NGO. |
| name | Legal name from Brreg, verbatim. |
| chapter_level | national (the NGO's own row) / regional / local / related_entity (e.g. an owned AS or STI, not a chapter). |
| kommune_nr | Resolved from Brreg's own kommune field. Null where Brreg carries none. |
| is_active | Whether Brreg's own registry shows the entity as active (not konkurs/avviklet). |
| web | Brreg's own hjemmeside field for this entity, verbatim. Null where Brreg carries none. |
| confidence | high only for chapter_orgnr = ngo_orgnr; medium or low for every name-matched row — see the model header. |
| match_method | How this row was matched — Brreg's own orgnr, a strong name pattern (optionally corroborated by a matching website), or a weaker name pattern. |
| registration | Always 'legal_entity' — every row here is a Brreg-registered organisation, not a scraped/unregistered unit. |
| reconciliation | Always 'registry_only' — no NGO site crawl has corroborated these rows yet. |
| parent_chapter_id | The NGO's own national row's chapter_id. Null for the national row itself. |
| parent_method | Always null — the registry states no parent link for these rows (reserved for a future reconciliation method). |
| source_url | The live Brreg Enhetsregisteret API URL for this chapter_orgnr. |
Sample query
Live PostgREST query that returns the first 5 rows. URL adapts to the current host — local dev shows api-atlas.localhost; the deployed site shows the configured API base.
https://api-atlas.urbalurba.com/ngo_chapter_registry_match?limit=5
About this view
The 9 federated NGOs' chapters, found by name pattern in Brønnøysundregistrene's register.
Registry-only: confidence tops out at `medium` (`high` only for an NGO's own national
row) — no NGO's own website has been crawled yet to corroborate a strong name match.
See the model's own header (int_ngo_chapter_registry_match.sql) for the matching method.