posts_gdocs_links

Data license: CC-BY

27 rows where sourceId = "1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE"

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ sourceId target linkType componentType text queryString hash
1877191 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE share-of-deaths-registered grapher span-link deaths    
1877192 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE share-of-deaths-cause-is-registered grapher span-link cause    
1877193 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://ourworldindata.org/homicides url span-link homicides    
1877194 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://ourworldindata.org/homicides url span-link topic page    
1877195 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE homicide-rate-ihme-vs-unodc grapher span-link Brazil and South Africa ?country=BRA~ZAF  
1877196 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE homicide-rate-ihme-vs-unodc grapher span-link Japan and Oman ?country=JPN~OMN  
1877197 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE homicide-rate-across-sources grapher chart      
1877198 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://ourworldindata.org/how-are-causes-of-death-registered-around-the-world?utm_source=substack&utm_medium=email#what-share-of-deaths-are-registered url span-link registered ?utm_source=substack&utm_medium=email #what-share-of-deaths-are-registered
1877199 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://ourworldindata.org/homicides url span-link Homicides topic page    
1877200 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://platform.who.int/mortality url span-link https://platform.who.int/mortality    
1877201 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://dataunodc.un.org/dp-intentional-homicide-victims url span-link Intentional Homicides    
1877202 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.journals.uchicago.edu/doi/abs/10.1086/652229 url span-link Long-Term Historical Trends in Violent Crime    
1877203 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.journals.uchicago.edu/doi/10.1086/677662 url span-link From Swords to Words: Does Macro-Level Change in Self-Control Predict Long-Term Variation in Levels of Homicide?    
1877204 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.thelancet.com/journals/lancet/article/PIIS0140-6736(20)30925-9/fulltext url span-link Global burden of 369 diseases and injuries in 204 countries and territories, 1990-2019: a systematic analysis for the Global Burden of Disease Study 2019    
1877205 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.who.int/data/global-health-estimates url span-link Global Health Estimates 2019: deaths by cause, age, sex, by country and by region, 2000–2019    
1877206 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.journals.uchicago.edu/doi/abs/10.1086/652229 url span-link Long-Term Historical Trends in Violent Crime    
1877207 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.ijcv.org/index.php/ijcv/article/view/2769 url span-link Modernity Strikes Back? A Historical Perspective on the Latest Increase in Interpersonal Violence (1960-1990)    
1877208 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.journals.uchicago.edu/doi/10.1086/677662 url span-link From Swords to Words: Does Macro-Level Change in Self-Control Predict Long-Term Variation in Levels of Homicide?    
1877209 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.thelancet.com/journals/lancet/article/PIIS0140-6736(20)30925-9/fulltext url span-link Global burden of 369 diseases and injuries in 204 countries and territories, 1990-2019: a systematic analysis for the Global Burden of Disease Study 2019    
1877210 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.thelancet.com/cms/10.1016/S0140-6736(20)30925-9/attachment/7709ecbd-5dbc-4da6-93b2-3fd0bedc16cc/mmc1.pdf url span-link Global burden of 369 diseases and injuries in 204 countries and territories, 1990-2019: a systematic analysis for the Global Burden of Disease Study 2019    
1877211 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://journals.sagepub.com/doi/abs/10.1177/1088767917715670 url span-link A Cautionary Note about the Use of Estimated Homicide Data for Cross-National Research    
1877212 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.annualreviews.org/doi/abs/10.1146/annurev-criminol-030521-102909 url span-link A Review and Analysis of the Impact of Homicide Measurement on Cross-National Research    
1877213 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.unodc.org/documents/data-and-analysis/gsh/Meth_Annex_GHS.pdf url span-link Methodological Annex to The Global Study on Homicide 2019    
1877214 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://dataunodc.un.org/sites/dataunodc.un.org/files/metadata_intentional_homicide.pdf url span-link Intentional Homicides Metadata information    
1877215 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.who.int/docs/default-source/gho-documents/global-health-estimates/ghe2019_cod_methods.pdf url span-link WHO methods and data sources for country-level causes of death 2000-2019    
1877216 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://www.who.int/data/gho/indicator-metadata-registry/imr-details/4464 url span-link Estimates of number of homicides    
1877217 Homicide data: how sources differ and when to use which one 1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE https://journals.sagepub.com/doi/abs/10.1177/1088767917715670 url span-link A Cautionary Note about the Use of Estimated Homicide Data for Cross-National Research    

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