posts_gdocs_links
Data license: CC-BY
2 rows where sourceId = "1_M63k9gi0ObqYlzNacx0Qokf7rWi1S3_lOeXRhyAomU"
This data as json, CSV (advanced)
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1878804 | Deaths from tetanus have been reduced massively 1_M63k9gi0ObqYlzNacx0Qokf7rWi1S3_lOeXRhyAomU | number-of-deaths-from-tetanus | grapher | front-matter | ?tab=chart&country=~OWID_WRL | ||
1878805 | Deaths from tetanus have been reduced massively 1_M63k9gi0ObqYlzNacx0Qokf7rWi1S3_lOeXRhyAomU | number-of-deaths-from-tetanus | grapher | span-link | Explore this data | ?tab=chart&country=~OWID_WRL |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "posts_gdocs_links" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "sourceId" VARCHAR(255) NULL , "target" TEXT NOT NULL , "linkType" TEXT NULL , "componentType" VARCHAR(255) NOT NULL , "text" VARCHAR(255) NOT NULL , "queryString" VARCHAR(2047) NOT NULL , "hash" VARCHAR(2047) NOT NULL, FOREIGN KEY("sourceId") REFERENCES "posts_gdocs" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION ); CREATE INDEX "sourceId" ON "posts_gdocs_links" ("sourceId");