report_technologies

6 rows where report_id = "bfea0f46-2dcc-4631-9f84-64bf620814b5"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, type, source

Link report_id name type source
bfea0f46-2dcc-4631-9f84-64bf620814b5,Font Awesome,runtime https://etjanst.msb.se/ bfea0f46-2dcc-4631-9f84-64bf620814b5 Font Awesome tools runtime
bfea0f46-2dcc-4631-9f84-64bf620814b5,Matomo,runtime https://etjanst.msb.se/ bfea0f46-2dcc-4631-9f84-64bf620814b5 Matomo analytics runtime
bfea0f46-2dcc-4631-9f84-64bf620814b5,Matomo Tag Manager,runtime https://etjanst.msb.se/ bfea0f46-2dcc-4631-9f84-64bf620814b5 Matomo Tag Manager analytics runtime
bfea0f46-2dcc-4631-9f84-64bf620814b5,Readspeaker,csp https://etjanst.msb.se/ bfea0f46-2dcc-4631-9f84-64bf620814b5 Readspeaker tools csp
bfea0f46-2dcc-4631-9f84-64bf620814b5,Readspeaker,runtime https://etjanst.msb.se/ bfea0f46-2dcc-4631-9f84-64bf620814b5 Readspeaker tools runtime
bfea0f46-2dcc-4631-9f84-64bf620814b5,Screen9,csp https://etjanst.msb.se/ bfea0f46-2dcc-4631-9f84-64bf620814b5 Screen9 video csp

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE report_technologies (
  report_id TEXT NOT NULL REFERENCES reports(id) ON DELETE CASCADE,
  name      TEXT NOT NULL,
  type      TEXT NOT NULL,
  source    TEXT NOT NULL,
  PRIMARY KEY (report_id, name, source)
);
CREATE INDEX idx_report_technologies_name ON report_technologies(name);