posts_gdocs_links

Data license: CC-BY

13 rows where sourceId = "1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target, linkType, componentType, text, queryString

id ▼ sourceId target linkType componentType text queryString hash
1858540 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig https://ourworldindata.org/energy-mix url span-link Energy Mix    
1858541 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig https://ourworldindata.org/electricity-mix url span-link Electricity Mix    
1858542 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig https://www.bp.com/en/global/corporate/energy-economics/statistical-review-of-world-energy.html url span-link Statistical Review of World Energy    
1858543 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig global-energy-substitution grapher chart      
1858544 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig change-energy-consumption grapher chart   ?tab=chart&country=~OWID_WRL  
1858545 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig primary-energy-cons grapher chart      
1858546 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig energy-use-per-capita grapher chart      
1858547 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig change-energy-consumption grapher chart   ?tab=map  
1858548 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig electricity-generation grapher chart      
1858549 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig per-capita-electricity-generation grapher chart      
1858550 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig https://ourworldindata.org/energy-mix url span-link Energy Mix    
1858551 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig https://ourworldindata.org/electricity-mix url span-link Electricity Mix    
1858552 Energy Production and Consumption 1gcKsv-WyTITlMwbmFJpclF1ob7WKlsqD2gZERvmsKig http://vaclavsmil.com/2016/12/14/energy-transitions-global-and-national-perspectives-second-expanded-and-updated-edition/ url span-link Energy Transitions: Global and National Perspectives    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");