posts_gdocs: 12ADdYAyzt9FQwxkVVDjH3vwRvEmUuc5e90GwXnsILVs

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
12ADdYAyzt9FQwxkVVDjH3vwRvEmUuc5e90GwXnsILVs the-rise-and-fall-of-homicides-in-europe data-insight 
{
    "body": [
        {
            "size": "narrow",
            "type": "image",
            "filename": "homicide-rate-who-age-standardized-desktop.png",
            "hasOutline": false,
            "parseErrors": [],
            "smallFilename": "homicide-rate-who-age-standardized-mobile.png"
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Homicide rates in Europe surged in the second half of the twentieth century but have dropped over the last 30 years.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "The chart shows the rates for several European countries based on data from the WHO Mortality Database.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "You can see that this trend was most pronounced in Italy. Homicide rates more than doubled from less than 1 per 100,000 people in the late 1960s to more than 2 in the late 1980s and early 1990s. Since then, rates have even fallen below earlier levels.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "This rise and fall in homicides is relatively consistent across other European countries, although the timing and magnitude of these changes differ. France, for example, saw a wave of homicides in the late 1950s and early 1960s.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "url": "https://ourworldindata.org/grapher/homicide-rate-who-age-standardized?tab=chart&facet=entity&uniformYAxis=0&country=ITA~GBR~SWE~FRA~ESP~NLD",
                    "children": [
                        {
                            "text": "Explore this data country by country",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": " \u2192",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "data-insight",
    "title": "The rise and fall of homicides in Europe",
    "authors": [
        "Bastian Herre"
    ],
    "approved-by": "Ed",
    "grapher-url": "https://ourworldindata.org/grapher/homicide-rate-who-age-standardized?tab=chart&facet=entity&uniformYAxis=0&country=ITA~GBR~SWE~FRA~ESP~NLD"
}
 1 2024-06-07 07:43:51 2024-07-12 05:00:00 2024-07-10 08:13:28 unlisted ALBJ4Ls09s_pTT6UYsAaAaEa4GFA6ISQRWw9QtVQYUAjSQD-RogG_4K0rUs6eRxjMzzIxCWfnyOfVCY9ld4ZZA   <Image filename="homicide-rate-who-age-standardized-desktop.png"/> Homicide rates in Europe surged in the second half of the twentieth century but have dropped over the last 30 years. The chart shows the rates for several European countries based on data from the WHO Mortality Database. You can see that this trend was most pronounced in Italy. Homicide rates more than doubled from less than 1 per 100,000 people in the late 1960s to more than 2 in the late 1980s and early 1990s. Since then, rates have even fallen below earlier levels. This rise and fall in homicides is relatively consistent across other European countries, although the timing and magnitude of these changes differ. France, for example, saw a wave of homicides in the late 1950s and early 1960s. [Explore this data](https://ourworldindata.org/grapher/homicide-rate-who-age-standardized?tab=chart&facet=entity&uniformYAxis=0&country=ITA~GBR~SWE~FRA~ESP~NLD) → The rise and fall of homicides in Europe

Links from other tables