report_technologies

4 rows where report_id = "50018e52-d1fb-4971-8765-b3171694ba58"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type

Link report_id name type source
50018e52-d1fb-4971-8765-b3171694ba58,Google Fonts,runtime https://mindthegap.skane.se/ 50018e52-d1fb-4971-8765-b3171694ba58 Google Fonts tools runtime
50018e52-d1fb-4971-8765-b3171694ba58,Matomo Tag Manager,runtime https://mindthegap.skane.se/ 50018e52-d1fb-4971-8765-b3171694ba58 Matomo Tag Manager analytics runtime
50018e52-d1fb-4971-8765-b3171694ba58,Whitespace Analys,runtime https://mindthegap.skane.se/ 50018e52-d1fb-4971-8765-b3171694ba58 Whitespace Analys analytics runtime
50018e52-d1fb-4971-8765-b3171694ba58,WordPress,runtime https://mindthegap.skane.se/ 50018e52-d1fb-4971-8765-b3171694ba58 WordPress platform runtime

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);