posts_links
Data license: CC-BY
10 rows where sourceId = 2809
This data as json, CSV (advanced)
Suggested facets: linkType, componentType, queryString
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
9041 | Crop Yields 2809 | https://ourworldindata.org/land-use | url | href | |||
9042 | Crop Yields 2809 | https://ourworldindata.org/poverty | url | href | |||
9043 | Crop Yields 2809 | https://ourworldindata.org/biodiversity | url | href | |||
9044 | Crop Yields 2809 | https://ourworldindata.org/fertilizers | url | href | |||
9045 | Crop Yields 2809 | https://ourworldindata.org/yields-habitat-loss | url | href | |||
9046 | Crop Yields 2809 | https://ourworldindata.org/peak-agriculture-land | url | href | |||
9047 | Crop Yields 2809 | https://ourworldindata.org/yields-vs-land-use-how-has-the-world-produced-enough-food-for-a-growing-population | url | href | |||
9048 | Crop Yields 2809 | crop-yields | explorer | src | ?facet=none&country=IND~USA~ITA~GBR~NGA~LKA~BRA~PER~AGO&Crop=Wheat&Metric=Actual+yield&hideControls=false | ||
9049 | Crop Yields 2809 | https://ourworldindata.org/africa-yields-problem | url | prominent-link | |||
9050 | Crop Yields 2809 | https://ourworldindata.org/soil-lifespans | url | prominent-link |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "posts_links" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "sourceId" INTEGER NOT NULL , "target" VARCHAR(2047) 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" ("id") ON UPDATE CASCADE ON DELETE CASCADE );