posts_gdocs_x_tags
Data license: CC-BY
3 rows where tagId = 161
This data as json, CSV (advanced)
Link | gdocId | tagId |
---|---|---|
1CbGF3JSwBJqIGTduV8dyRkylyqUisbI5GLK0yIWuU1U,161 | Light at Night 1CbGF3JSwBJqIGTduV8dyRkylyqUisbI5GLK0yIWuU1U | Light at Night 161 |
1i1yvwIHH5dm6kFm6usdzLN5YH9BHyGx_spfyv_qZbeA,161 | The price of lighting has dropped over 99.9% since 1700 1i1yvwIHH5dm6kFm6usdzLN5YH9BHyGx_spfyv_qZbeA | Light at Night 161 |
1jtyhfrddwM315O4nmFwHbJM_CNCZ_PZHX4PTakRj7Lc,161 | From 5% to 71% in 25 years: Kenya has made substantial progress in providing access to electricity 1jtyhfrddwM315O4nmFwHbJM_CNCZ_PZHX4PTakRj7Lc | Light at Night 161 |
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");