blog_post_tags
11 rows where blog_post_hash = "090054ac05"
This data as json, CSV (advanced)
Link | blog_post_hash | tag_hash |
---|---|---|
090054ac05,0d8458edfc | April 2018 Top Blog Roundup 090054ac05 | non-profit 0d8458edfc |
090054ac05,0dcb092a8e | April 2018 Top Blog Roundup 090054ac05 | Blog Post 0dcb092a8e |
090054ac05,126eaa809b | April 2018 Top Blog Roundup 090054ac05 | digitalglobe 126eaa809b |
090054ac05,1990756a80 | April 2018 Top Blog Roundup 090054ac05 | nonprofit 1990756a80 |
090054ac05,56ac99eab2 | April 2018 Top Blog Roundup 090054ac05 | Education 56ac99eab2 |
090054ac05,b33c5b11be | April 2018 Top Blog Roundup 090054ac05 | government b33c5b11be |
090054ac05,b9c6517fb9 | April 2018 Top Blog Roundup 090054ac05 | General Public Services b9c6517fb9 |
090054ac05,d803ccd79d | April 2018 Top Blog Roundup 090054ac05 | roda d803ccd79d |
090054ac05,d8df1e4faf | April 2018 Top Blog Roundup 090054ac05 | education d8df1e4faf |
090054ac05,f7ee552a30 | April 2018 Top Blog Roundup 090054ac05 | april-round-up f7ee552a30 |
090054ac05,fa16127cd8 | April 2018 Top Blog Roundup 090054ac05 | 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]);