posts_gdocs_x_tags
Data license: CC-BY
4 rows where tagId = 180
This data as json, CSV (advanced)
Link | gdocId | tagId |
---|---|---|
10FI0qLs-7iARtFoegIC9glFAhKn79W99g8E24ZE4160,180 | 10FI0qLs-7iARtFoegIC9glFAhKn79W99g8E24ZE4160 | Homelessness 180 |
1MifBwpobE_3seoJcvCq2EPamQaSDPdmS96yD7_6PsTo,180 | Homelessness 1MifBwpobE_3seoJcvCq2EPamQaSDPdmS96yD7_6PsTo | Homelessness 180 |
1QI5s-U6Yt7LMyAKdB0tz5M0WyatyuIEpu1dsrN2ENOY,180 | 1QI5s-U6Yt7LMyAKdB0tz5M0WyatyuIEpu1dsrN2ENOY | Homelessness 180 |
1fZ0aai4iNKzLpHz8hGXhAVFKf0HyV11TThbH6I1O0NQ,180 | Homelessness and poverty in rich countries 1fZ0aai4iNKzLpHz8hGXhAVFKf0HyV11TThbH6I1O0NQ | Homelessness 180 |
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");