posts_gdocs: 1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE

This table contains the GDocs posts. A lot of interesting data is the content column which is a json blob containing, among other things, the archieml as parsed json. For easy searching etc, a markdown copy of the content is available in the markdown column. If you want to query all posts (both wordpress and gdocs), use the posts_unified table or the posts_unified_with_content view.

Data license: CC-BY

This data as json

id slug type content published createdAt publishedAt updatedAt publicationContext revisionId breadcrumbs markdown title
1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE homicides topic-page 
{
    "toc": [],
    "body": [
        {
            "type": "topic-page-intro",
            "content": [
                {
                    "type": "text",
                    "value": [
                        {
                            "text": "Homicides \u2014 when people intentionally and illegally kill others for personal reasons \u2014 are the most serious crime.",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "parseErrors": []
                },
                {
                    "type": "text",
                    "value": [
                        {
                            "text": "They are a common cause of death globally and a leading cause of death in some countries.",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "parseErrors": []
                },
                {
                    "type": "text",
                    "value": [
                        {
                            "text": "They not only rob the victims of their lives: they also hurt the victims\u2019 friends and families, they harm the broader community, and they may burden the perpetrators themselves and lead to their imprisonment or execution.",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "parseErrors": []
                },
                {
                    "type": "text",
                    "value": [
                        {
                            "text": "This page provides data and research on how frequent homicides are, how this differs across countries, and whether they are becoming less common over time.",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "parseErrors": []
                }
            ],
            "parseErrors": [],
            "relatedTopics": [
                {
                    "url": "https://ourworldindata.org/causes-of-death",
                    "text": "Causes of Death",
                    "type": "topic-page-intro-related-topic"
                },
                {
                    "url": "https://ourworldindata.org/war-and-peace",
                    "text": "War and Peace",
                    "type": "topic-page-intro-related-topic"
                },
                {
                    "url": "https://ourworldindata.org/terrorism",
                    "text": "Terrorism",
                    "type": "topic-page-intro-related-topic"
                },
                {
                    "url": "https://ourworldindata.org/suicide",
                    "text": "Suicides",
                    "type": "topic-page-intro-related-topic"
                }
            ]
        },
        {
            "more": {
                "heading": "More Articles on Homicides",
                "articles": [
                    {
                        "value": {
                            "url": "https://docs.google.com/document/d/18v00Z9ep-vvKP3VXIfWKd25BdrcReSX3qClOBt3d5zM/edit"
                        }
                    },
                    {
                        "value": {
                            "url": "https://docs.google.com/document/d/1Raish4hOXi6PwlhyFsTRFnOCZWLr7roteYW-0qBawZo/edit"
                        }
                    }
                ]
            },
            "rows": [],
            "type": "research-and-writing",
            "primary": [
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1UdKf375jChVw4SpFrhNaRJH0Ve7VDXtjFz_CP7mon54/edit"
                    }
                }
            ],
            "secondary": [],
            "parseErrors": []
        },
        {
            "top": [
                {
                    "url": "https://ourworldindata.org/grapher/homicide-rate-unodc"
                },
                {
                    "url": "https://ourworldindata.org/grapher/distribution-of-homicide-rates"
                },
                {
                    "url": "https://ourworldindata.org/grapher/homicide-rates-across-western-europe"
                }
            ],
            "type": "all-charts",
            "heading": "Interactive Charts on Homicides",
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "topic-page",
    "title": "Homicides",
    "authors": [
        "Bastian Herre",
        "Fiona Spooner",
        "Max Roser"
    ],
    "excerpt": "How common are homicides? How does this differ across countries? And how is this changing over time? Explore global data on homicides.",
    "sticky-nav": [
        {
            "text": "Introduction",
            "target": "#introduction"
        },
        {
            "text": "Research & Writing",
            "target": "#research-writing"
        },
        {
            "text": "Charts",
            "target": "#all-charts"
        },
        {
            "text": "Endnotes",
            "target": "#article-endnotes"
        },
        {
            "text": "Cite This Work",
            "target": "#article-citation"
        },
        {
            "text": "Reuse This Work",
            "target": "#article-licence"
        }
    ],
    "featured-image": "homicides-featured-image.png"
}
 1 2023-07-18 17:37:51 2013-07-06 20:05:33 2023-12-28 16:31:07 unlisted ALBJ4Luol2qaGJwnuQwekPdCdichOC4qK3E-AdK7DkEVnY7DHA6BUyqsUBp5B-Ug3Dzi1i9v2A0rcNc1vfetYg   Homicides — when people intentionally and illegally kill others for personal reasons — are the most serious crime. They are a common cause of death globally and a leading cause of death in some countries. They not only rob the victims of their lives: they also hurt the victims’ friends and families, they harm the broader community, and they may burden the perpetrators themselves and lead to their imprisonment or execution. This page provides data and research on how frequent homicides are, how this differs across countries, and whether they are becoming less common over time. ## Related research and writing * https://docs.google.com/document/d/1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE/edit ,* https://docs.google.com/document/d/1UdKf375jChVw4SpFrhNaRJH0Ve7VDXtjFz_CP7mon54/edit ,* https://docs.google.com/document/d/18v00Z9ep-vvKP3VXIfWKd25BdrcReSX3qClOBt3d5zM/edit ,* https://docs.google.com/document/d/1Raish4hOXi6PwlhyFsTRFnOCZWLr7roteYW-0qBawZo/edit <AllCharts heading="Interactive Charts on Homicides"/> Homicides

Links from other tables