Publikationer (berikade) (view)

Alla publikationer. Tematik och språk ärvs från avsändaren när inte explicit angiven på publikationen.

2 rows where sender_id = "crpd-kommitten" sorted by sender_name_short

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: languages (array), discrimination_grounds (array), legal_areas (array), rights_dimensions (array), instruments (array)

sender_id 1

  • crpd-kommitten · 2 ✖

publication_type 1

level 1

languages 1

instruments 1

fk_relevance 1

discrimination_grounds 1

tags 0

id sender_id sender_name_short ▼ title publication_type publication_type_label url languages discrimination_grounds legal_areas rights_dimensions instruments tags notes level fk_relevance
crpd__concluding-observations crpd-kommitten CRPD-kommittén Concluding Observations om Sverige yttrandeserie Yttrandeserie https://tbinternet.ohchr.org/_layouts/15/treatybodyexternal/countries.aspx?CountryCode=SWE&Lang=EN ["en", "fr"] ["funktionsnedsattning", "intersektionell"] ["funktionshinder-och-assistans", "halsa-och-sjukvard", "sjukforsakring", "utbildning", "arbetsliv"] ["tillganglighet", "skalig-anpassning", "deltagande", "esk-rattigheter", "likabehandling"] ["crpd"]   Sveriges svar rapporteras i en cykel; senaste granskning 2024. fn direkt
crpd__general-comments crpd-kommitten CRPD-kommittén CRPD General Comments yttrandeserie Yttrandeserie https://www.ohchr.org/en/treaty-bodies/crpd/general-comments ["en", "fr"] ["funktionsnedsattning", "intersektionell"] ["funktionshinder-och-assistans", "halsa-och-sjukvard", "sjukforsakring", "utbildning", "arbetsliv"] ["tillganglighet", "skalig-anpassning", "deltagande", "esk-rattigheter", "likabehandling"] ["crpd"]   No. 5 om självständigt liv är särskilt central. fn direkt

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW publications_enriched AS
        SELECT
            p.id,
            p.sender_id,
            s.name_short AS sender_name_short,
            p.title,
            p.publication_type,
            pt.label_sv AS publication_type_label,
            p.url,
            COALESCE(p.languages, s.languages) AS languages,
            COALESCE(p.discrimination_grounds, s.discrimination_grounds) AS discrimination_grounds,
            COALESCE(p.legal_areas, s.legal_areas) AS legal_areas,
            COALESCE(p.rights_dimensions, s.rights_dimensions) AS rights_dimensions,
            COALESCE(p.instruments, s.instruments) AS instruments,
            p.tags,
            p.notes,
            s.level AS level,
            s.fk_relevance AS fk_relevance
        FROM publications p
        LEFT JOIN senders s ON p.sender_id = s.id
        LEFT JOIN vocab_publication_types pt ON p.publication_type = pt.slug;