posts_links

Data license: CC-BY

8 rows where sourceId = 16236

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: target, linkType, componentType, queryString

id ▼ sourceId target linkType componentType text queryString hash
5763 World map region definitions 16236 continents-according-to-our-world-in-data grapher href   ?overlay=data  
5764 World map region definitions 16236 https://data.worldbank.org/country url href      
5765 World map region definitions 16236 http://www.who.int/about/regions/en url href      
5766 World map region definitions 16236 https://unstats.un.org/sdgs/indicators/regional-groups/ url href      
5767 World map region definitions 16236 continents-according-to-our-world-in-data grapher src      
5768 World map region definitions 16236 world-regions-according-to-the-world-bank grapher src      
5769 World map region definitions 16236 who-regions grapher src      
5770 World map region definitions 16236 world-regions-according-to-the-united-nations grapher src      

Advanced export

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

CSV options: 

CREATE TABLE "posts_links" (
	"id" INTEGER PRIMARY KEY AUTOINCREMENT,
	"sourceId" INTEGER NOT NULL  ,
	"target" VARCHAR(2047) 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" ("id") ON UPDATE CASCADE ON DELETE CASCADE
);