report_technologies
2 rows where report_id = "d897fbcd-4506-4a03-89b0-3432fd24a50b"
This data as json, CSV (advanced)
| Link | report_id | name | type | source |
|---|---|---|---|---|
| d897fbcd-4506-4a03-89b0-3432fd24a50b,Rekai,runtime | https://www.nrm.se/natur--och-miljoovervakning/pollenovervakning/pollenrapporten d897fbcd-4506-4a03-89b0-3432fd24a50b | Rekai | tools | runtime |
| d897fbcd-4506-4a03-89b0-3432fd24a50b,SiteVision,runtime | https://www.nrm.se/natur--och-miljoovervakning/pollenovervakning/pollenrapporten d897fbcd-4506-4a03-89b0-3432fd24a50b | SiteVision | platform | runtime |
Advanced export
JSON shape: default, array, newline-delimited, object
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);