posts_gdocs_links
Data license: CC-BY
6 rows where sourceId = "1FuRapgh4hqI2NDcfhhZskWoVaJd9VpLtqWkzC_2DYP8"
This data as json, CSV (advanced)
Suggested facets: linkType, componentType, queryString
id ▼ | sourceId | target | linkType | componentType | text | queryString | hash |
---|---|---|---|---|---|---|---|
1859873 | When will countries phase out coal power? 1FuRapgh4hqI2NDcfhhZskWoVaJd9VpLtqWkzC_2DYP8 | global-energy-substitution | grapher | span-link | world’s oldest | ?country=~OWID_WRL | |
1859874 | When will countries phase out coal power? 1FuRapgh4hqI2NDcfhhZskWoVaJd9VpLtqWkzC_2DYP8 | https://ourworldindata.org/safest-sources-of-energy | url | span-link | world’s dirtiest fuel | ||
1859875 | When will countries phase out coal power? 1FuRapgh4hqI2NDcfhhZskWoVaJd9VpLtqWkzC_2DYP8 | https://ourworldindata.org/air-pollution | url | span-link | air pollution | ||
1859876 | When will countries phase out coal power? 1FuRapgh4hqI2NDcfhhZskWoVaJd9VpLtqWkzC_2DYP8 | coal-phase-out-timeline | grapher | chart | |||
1859877 | When will countries phase out coal power? 1FuRapgh4hqI2NDcfhhZskWoVaJd9VpLtqWkzC_2DYP8 | energy | explorer | prominent-link | Which countries get the most energy from coal? | ?facet=none&country=USA~GBR~CHN~OWID_WRL~IND~BRA~ZAF&Total+or+Breakdown=Select+a+source&Select+a+source=Coal&Energy+or+Electricity=Primary+energy&Metric=Share+of+total | |
1859878 | When will countries phase out coal power? 1FuRapgh4hqI2NDcfhhZskWoVaJd9VpLtqWkzC_2DYP8 | https://ourworldindata.org/energy | url | prominent-link | Explore all of our data and writing about energy |
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");