home

panorama

Custom SQL query

Queries

  • Direkt FK-relevans
  • CRPD-pipelinen

Tables

publications

id, sender_id, title, publication_type, url, languages, discrimination_grounds, legal_areas, rights_dimensions, instruments, tags, notes

12 rows

senders

id, name_short, name_full, acronym, sender_type, legal_status, country, mandate, binding_force, website, parent_sender_id, discrimination_grounds, legal_areas, rights_dimensions, fk_relevance, level, instruments, languages, referenced_in, tags, notes, in_masterlist, note

41 rows

vocab_binding_force

slug, label_sv, label_en, description

4 rows

vocab_discrimination_grounds

slug, label_sv, label_en, description

9 rows

vocab_fk_relevance

slug, label_sv, label_en, description

3 rows

vocab_instruments

slug, label_sv, label_en, description

19 rows

vocab_languages

slug, label_sv, label_en, description

7 rows

vocab_legal_areas

slug, label_sv, label_en, description

14 rows

vocab_legal_statuses

slug, label_sv, label_en, description

5 rows

vocab_levels

slug, label_sv, label_en, description

7 rows

vocab_publication_types

slug, label_sv, label_en, description

9 rows

vocab_rights_dimensions

slug, label_sv, label_en, description

7 rows

vocab_sender_types

slug, label_sv, label_en, description

10 rows

Views

  • senders_enriched
  • publications_enriched
Powered by Datasette · Queries took 70.117ms