posts_gdocs_x_tags
Data license: CC-BY
4 rows where tagId = 1560
This data as json, CSV (advanced)
Link | gdocId | tagId |
---|---|---|
10YlW6aWgcX9oBiKIk6-NQ5V8BA9jxErcEIliG1C1JD4,1560 | Oral rehydration therapy: a low-tech solution that has saved millions of lives 10YlW6aWgcX9oBiKIk6-NQ5V8BA9jxErcEIliG1C1JD4 | Diarrheal Diseases 1560 |
17qaWKnVg7YF4QEnEBm0TZkK7EHm5_KBBchBi_ujmkl0,1560 | More than half a million children die from diarrhea each year. How do we prevent this? 17qaWKnVg7YF4QEnEBm0TZkK7EHm5_KBBchBi_ujmkl0 | Diarrheal Diseases 1560 |
1mDkPiGSy3dHCfnIFc1HAPU2XU3yz9iKWBNWfRUTniCw,1560 | Diarrheal Diseases 1mDkPiGSy3dHCfnIFc1HAPU2XU3yz9iKWBNWfRUTniCw | Diarrheal Diseases 1560 |
1zzTqdQC1XVVfDbq9iZKDk09Re0y8nRgL7zMpZnul-zM,1560 | Rotavirus vaccine - an effective tool that prevents children dying from diarrhea 1zzTqdQC1XVVfDbq9iZKDk09Re0y8nRgL7zMpZnul-zM | Diarrheal Diseases 1560 |
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");