blog_post_tags
11 rows where blog_post_hash = "029885fa64"
This data as json, CSV (advanced)
Link | blog_post_hash | tag_hash |
---|---|---|
029885fa64,0dcb092a8e | Casting the Vote for the Cloud 029885fa64 | Blog Post 0dcb092a8e |
029885fa64,1369850976 | Casting the Vote for the Cloud 029885fa64 | elections 1369850976 |
029885fa64,658fb7f85e | Casting the Vote for the Cloud 029885fa64 | security 658fb7f85e |
029885fa64,7018cf2087 | Casting the Vote for the Cloud 029885fa64 | slg 7018cf2087 |
029885fa64,a0620aa344 | Casting the Vote for the Cloud 029885fa64 | federal-government a0620aa344 |
029885fa64,a839be98d5 | Casting the Vote for the Cloud 029885fa64 | voting a839be98d5 |
029885fa64,b33c5b11be | Casting the Vote for the Cloud 029885fa64 | government b33c5b11be |
029885fa64,b9c6517fb9 | Casting the Vote for the Cloud 029885fa64 | General Public Services b9c6517fb9 |
029885fa64,c9775ad29d | Casting the Vote for the Cloud 029885fa64 | vote c9775ad29d |
029885fa64,da2fc4b856 | Casting the Vote for the Cloud 029885fa64 | state-and-local-government da2fc4b856 |
029885fa64,fa16127cd8 | Casting the Vote for the Cloud 029885fa64 | public-sector fa16127cd8 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "blog_post_tags" ( [blog_post_hash] TEXT REFERENCES [blog_posts]([hash]), [tag_hash] TEXT REFERENCES [tags]([hash]), PRIMARY KEY ([blog_post_hash], [tag_hash]) ); CREATE INDEX [idx_blog_post_tags_tag_hash] ON [blog_post_tags] ([tag_hash]); CREATE INDEX [idx_blog_post_tags_blog_post_hash] ON [blog_post_tags] ([blog_post_hash]);