posts_gdocs_links
Data license: CC-BY
4 rows where sourceId = "17jqDNVdCSdYwAbOEEej4kY_7XuC1YvDHGidQ9qV2Z3Q"
This data as json, CSV (advanced)
Suggested facets: linkType, componentType
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1828508 | Global comparison: how much energy do people consume? 17jqDNVdCSdYwAbOEEej4kY_7XuC1YvDHGidQ9qV2Z3Q | https://ourworldindata.org/energy-poverty-air-pollution | url | span-link | burning of some solid fuels for cooking | ||
1828509 | Global comparison: how much energy do people consume? 17jqDNVdCSdYwAbOEEej4kY_7XuC1YvDHGidQ9qV2Z3Q | per-capita-energy-use | grapher | chart | |||
1828510 | Global comparison: how much energy do people consume? 17jqDNVdCSdYwAbOEEej4kY_7XuC1YvDHGidQ9qV2Z3Q | https://ourworldindata.org/energy-offshoring | url | span-link | related article | ||
1828511 | Global comparison: how much energy do people consume? 17jqDNVdCSdYwAbOEEej4kY_7XuC1YvDHGidQ9qV2Z3Q | energy | explorer | span-link | Energy Data Explorer |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "posts_gdocs_links" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "sourceId" VARCHAR(255) NULL , "target" TEXT NOT NULL , "linkType" TEXT NULL , "componentType" VARCHAR(255) NOT NULL , "text" VARCHAR(255) NOT NULL , "queryString" VARCHAR(2047) NOT NULL , "hash" VARCHAR(2047) NOT NULL, FOREIGN KEY("sourceId") REFERENCES "posts_gdocs" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION ); CREATE INDEX "sourceId" ON "posts_gdocs_links" ("sourceId");