posts_gdocs_x_tags
Data license: CC-BY
4 rows where tagId = 1823
This data as json, CSV (advanced)
Link | gdocId | tagId |
---|---|---|
1-8ym_g3-B-YgH-WXhRejwuQ2dTYVYMJVJ6c8RIeWYpE,1823 | Colonialism meant that for centuries, many territories and people were ruled from elsewhere 1-8ym_g3-B-YgH-WXhRejwuQ2dTYVYMJVJ6c8RIeWYpE | State Capacity 1823 |
1AbIxBJogVVqguRGggYYM9RVF4j0MFy1wlnnHmS3Xabo,1823 | In the last 200 years, many countries have built institutions to collect statistics on their populations 1AbIxBJogVVqguRGggYYM9RVF4j0MFy1wlnnHmS3Xabo | State Capacity 1823 |
1S6VFP5hrLbEKkn84DrShd438w_Bi9KrT9-VkVPszb1o,1823 | The rise of tax revenues in Southern Europe 1S6VFP5hrLbEKkn84DrShd438w_Bi9KrT9-VkVPszb1o | State Capacity 1823 |
1nOUoyu2agBn453a8IVvKfXElvE4o_Yo_JYIzPtdK0t0,1823 | State Capacity 1nOUoyu2agBn453a8IVvKfXElvE4o_Yo_JYIzPtdK0t0 | State Capacity 1823 |
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");