posts_gdocs_x_tags
Data license: CC-BY
4 rows where tagId = 40
This data as json, CSV (advanced)
Link | gdocId | tagId |
---|---|---|
1HYE7uXsrYLmGnknz27z8MkAhvlMBemCodhvu2OM9gxU,40 | Employment in Agriculture 1HYE7uXsrYLmGnknz27z8MkAhvlMBemCodhvu2OM9gxU | Employment in Agriculture 40 |
1PI7YG21Bp5mMo647c0JP_LqpqXIk4Cgu6b6OoMirL7s,40 | Employment in agriculture: data sources and definitions 1PI7YG21Bp5mMo647c0JP_LqpqXIk4Cgu6b6OoMirL7s | Employment in Agriculture 40 |
1np14OnYAwksLdiATjtiTzVQNISFmY7p-4yGB-d0_E8g,40 | The service sector now represents about half of employment across the world 1np14OnYAwksLdiATjtiTzVQNISFmY7p-4yGB-d0_E8g | Employment in Agriculture 40 |
1suQJtHnrIPA0zawZe1uCeM5rHZPOvUlZKq4fQnj41O0,40 | Smallholders produce one-third of the world’s food, less than half of what many headlines claim 1suQJtHnrIPA0zawZe1uCeM5rHZPOvUlZKq4fQnj41O0 | Employment in Agriculture 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "posts_gdocs_x_tags" ( "gdocId" VARCHAR(255) NOT NULL , "tagId" INTEGER NOT NULL , PRIMARY KEY ("gdocId", "tagId"), FOREIGN KEY("gdocId") REFERENCES "posts_gdocs" ("id") ON UPDATE RESTRICT ON DELETE CASCADE, FOREIGN KEY("tagId") REFERENCES "tags" ("id") ON UPDATE RESTRICT ON DELETE CASCADE ); CREATE INDEX "FK_posts_gdocs_x_tags_tag_id" ON "posts_gdocs_x_tags" ("tagId");