posts_gdocs_links

Data license: CC-BY

21 rows where sourceId = "1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y"

✎ 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
1838941 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y plastics-top-rivers grapher chart   ?country=Pasig+%28Philippines%29~Tullahan+%28Philippines%29~Ganges+%28India%29~Ulhas+%28India%29~Klang+%28Malaysia%29~Meycauayan+%28Philippines%29~Pampanga+%28Philippines%29~Libmanan+%28Philippines%29~Rio+Grande+de+Mindanao+%28Philippines%29~Agno+%28Philippines%29  
1838942 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y https://theoceancleanup.com/sources/ url span-link provides a beautiful interactive map    
1838943 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y world-population-by-world-regions-post-1820 grapher span-link 60% of the world population ?stackMode=relative  
1838944 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y share-of-global-plastic-waste-emitted-to-the-ocean grapher chart   ?tab=chart&country=Africa~Asia~Europe~South+America~North+America~Oceania  
1838945 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y share-of-global-plastic-waste-emitted-to-the-ocean grapher chart   ?tab=map  
1838946 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y per-capita-ocean-plastic-waste grapher span-link on a per capita basis    
1838947 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y ocean-plastic-waste-per-capita-vs-gdp grapher chart      
1838948 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y plastic-waste-per-capita grapher span-link plastic waste per person    
1838949 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y plastic-waste-generation-total grapher span-link total plastic waste generation    
1838950 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y mismanaged-plastic-waste-per-capita grapher span-link Per capita mismanaged waste    
1838951 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y plastic-waste-mismanaged grapher span-link each country’s total    
1838952 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y share-of-global-mismanaged-plastic-waste grapher chart   ?country=Asia~Africa~Europe~South+America~North+America~Oceania  
1838953 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y probability-mismanaged-plastic-ocean grapher chart   ?country=MYS~PHL~CHN~IND~LKA~BRA~NGA~TZA  
1838954 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y https://www.sciencedirect.com/science/article/pii/S0048969716310154 url span-link Plastic waste in the marine environment: A review of sources, occurrence and effects    
1838955 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y https://www.nature.com/articles/s41598-018-22939-w url span-link Evidence that the Great Pacific Garbage Patch is rapidly accumulating plastic    
1838956 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y https://www.nature.com/articles/s41598-018-22939-w url span-link Evidence that the Great Pacific Garbage Patch is rapidly accumulating plastic    
1838957 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y https://www.nature.com/articles/ncomms15611 url span-link River plastic emissions to the world’s oceans    
1838958 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y https://pubs.acs.org/doi/10.1021/acs.est.7b02368 url span-link Export of plastic debris by rivers into the sea    
1838959 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y https://advances.sciencemag.org/content/7/18/eaaz5803 url span-link More than 1000 rivers account for 80% of global riverine plastic emissions into the ocean    
1838960 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y https://www.nature.com/articles/ncomms15611 url span-link River plastic emissions to the world’s oceans    
1838961 Where does the plastic in our oceans come from? 1d2Itim4lEFukKs4EU2YWJK2_cG5CwvCZTZbfdD2yc9Y plastic-waste-generation-total grapher span-link Plastic waste inputs from land into the ocean    

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