posts_gdocs_links
Data license: CC-BY
5 rows where sourceId = "1HYE7uXsrYLmGnknz27z8MkAhvlMBemCodhvu2OM9gxU"
This data as json, CSV (advanced)
Suggested facets: linkType, componentType, text
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1875491 | Employment in Agriculture 1HYE7uXsrYLmGnknz27z8MkAhvlMBemCodhvu2OM9gxU | https://ourworldindata.org/food-supply | url | topic-page-intro | Food Supply | ||
1875492 | Employment in Agriculture 1HYE7uXsrYLmGnknz27z8MkAhvlMBemCodhvu2OM9gxU | https://ourworldindata.org/crop-yields | url | topic-page-intro | Crop Yields | ||
1875493 | Employment in Agriculture 1HYE7uXsrYLmGnknz27z8MkAhvlMBemCodhvu2OM9gxU | https://ourworldindata.org/land-use | url | topic-page-intro | Land Use | ||
1875494 | Employment in Agriculture 1HYE7uXsrYLmGnknz27z8MkAhvlMBemCodhvu2OM9gxU | agriculture-value-added-per-worker-wdi | grapher | all-charts | |||
1875495 | Employment in Agriculture 1HYE7uXsrYLmGnknz27z8MkAhvlMBemCodhvu2OM9gxU | share-of-the-labor-force-employed-in-agriculture | grapher | all-charts |
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");