posts_links
Data license: CC-BY
9 rows where sourceId = 30322
This data as json, CSV (advanced)
Suggested facets: linkType, componentType, queryString
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
9287 | Agricultural Production 30322 | https://ourworldindata.org/employment-in-agriculture | url | href | |||
9288 | Agricultural Production 30322 | https://ourworldindata.org/hunger-and-undernourishment | url | href | |||
9289 | Agricultural Production 30322 | https://ourworldindata.org/land-use | url | href | |||
9290 | Agricultural Production 30322 | https://ourworldindata.org/crop-yields | url | href | |||
9291 | Agricultural Production 30322 | https://ourworldindata.org/diet-compositions | url | href | |||
9292 | Agricultural Production 30322 | https://ourworldindata.org/environmental-impacts-of-food | url | href | |||
9293 | Agricultural Production 30322 | https://ourworldindata.org/meat-production | url | href | |||
9294 | Agricultural Production 30322 | https://ourworldindata.org/fish-and-overfishing | url | href | |||
9295 | Agricultural Production 30322 | global-food | explorer | src | ?facet=none&Food=Maize+%28corn%29&Metric=Production&Per+Capita=false&country=USA~DEU~FRA~GBR~BRA~ZAF;hideControls=false |
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 );