NGO registry
Atlas view
NGO registry
api_v1.ngo_indexOne row per NGO in dim_ngo with chapter_count and has_supply decorations.
First 5 rows ·
api_v1.ngo_indexsnapshot 2026-05-12
| orgnr | slug | name | brand_name | website_url | tier | chapter_data_shape | has_chapters | primary_focus | icnpo_code_1 | icnpo_code_2 | icnpo_code_3 | chapter_count | has_supply |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 943838240 | fire-h | 4H Norge | — | https://www.4h.no | A | cms_bins | true | youth | — | — | — | 0 | false |
| 970169113 | diabetesforbundet | Diabetesforbundet | — | https://www.diabetes.no | A | cms_bins | true | patient_support | — | — | — | 0 | false |
| 938498318 | frelsesarmeen | Frelsesarmeen | — | https://www.frelsesarmeen.no | A | cms_bins | true | social | — | — | — | 0 | false |
| 940190738 | lhl | Landsforeningen for hjerte- og lungesyke | LHL | https://www.lhl.no | A | cms_bins | true | patient_support | — | — | — | 0 | false |
| 971322926 | mental-helse | Mental Helse | — | https://mentalhelse.no | A | cms_bins | true | patient_support | — | — | — | 0 | false |
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 |
|---|---|
| orgnr | 9-digit Brreg organisasjonsnummer (text — leading zeros are preserved). Natural key for this view. |
| slug | kebab-case URL-friendly identifier (e.g. 'redcross', 'kirkens-bymisjon'). |
| name | Legal name from Brreg. |
| brand_name | Common brand name when distinct from legal name (e.g. 'Sanitetskvinnene' vs N.K.S.). NULL when the brand equals the legal name. |
| website_url | NGO's primary website. Used as the outbound link from the index page. |
| tier | Structural-fit tier (A / B / C) from docs/research/ngo-landscape.md. v1 includes Tier A only. |
| chapter_data_shape | How this NGO models its chapters. Values: 'distrikt+local' (Red Cross), 'flat' (single-tier), 'none' (no chapters). Drives which supply staging model the NGO uses. |
| has_chapters | True when the NGO has any chapters at all (regardless of activity). |
| primary_focus | One-line description of the NGO's main mission area. |
| icnpo_code_1 | ICNPO classification code (primary). See ref_icnpo. NULL when unclassified. |
| icnpo_code_2 | ICNPO classification code (secondary). NULL when not used. |
| icnpo_code_3 | ICNPO classification code (tertiary). NULL when not used. |
| chapter_count | Count of active chapters for this NGO (filtered by dim_chapter.is_active = true). Zero if the NGO has no chapters or all chapters are dormant. |
| has_supply | Convenience boolean: chapter_count > 0. True when the NGO has at least one active chapter — i.e. it appears on the supply side of Atlas. |
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 api-atlas.sovereignsky.no.
https://api-atlas.sovereignsky.no/ngo_index?limit=5
About this view
One row per NGO in dim_ngo with chapter_count and has_supply
decorations. Backs the NGO landing page (atlas-frontend /ngo) and
is equivalent to the listNgos() inline query.
chapter_count counts only active chapters (dim_chapter.is_active),
so a defunct NGO sits at 0 even if its historical chapters are
retained. has_supply is the convenience boolean (chapter_count > 0).
The full table is small (~11 rows in v1, growing as new NGOs
land), so PostgREST consumers typically read all of it.