posts_gdocs: 1jRZdtQFxP039-0a1klv4IXxaYdeeciNNmJS6Vf7rrDk

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.

This data as json

id slug type content published createdAt publishedAt updatedAt publicationContext revisionId breadcrumbs markdown title
1jRZdtQFxP039-0a1klv4IXxaYdeeciNNmJS6Vf7rrDk violence-between-mexican-drug-cartels-has-surged-in-recent-years data-insight 
{
    "body": [
        {
            "size": "narrow",
            "type": "image",
            "filename": "deaths-in-non-state-conflicts-desktop.png",
            "hasOutline": false,
            "parseErrors": [],
            "smallFilename": "deaths-in-non-state-conflicts-mobile.png"
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "In recent years, tens of thousands of people have died due to fighting between drug cartels in Mexico.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "The chart uses data from the Uppsala Conflict Data Program to show the country's deaths from \u201c",
                    "spanType": "span-simple-text"
                },
                {
                    "id": "nonstate-ucdp",
                    "children": [
                        {
                            "text": "non-state conflicts",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-dod"
                },
                {
                    "text": "\u201d over the last thirty years.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "These conflicts involve fighting between non-state armed groups, which in Mexico are criminal organizations like the Jalisco, Juarez, Los Zetas, and Sinaloa drug cartels.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Before the 2000s, there were relatively few deaths from these conflicts. The number of deaths then began to increase, reaching a peak of over 18,000 deaths in 2021.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "url": "https://ourworldindata.org/grapher/deaths-in-non-state-conflicts?tab=chart&country=~MEX",
                    "children": [
                        {
                            "text": "Explore this data for other countries",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": " \u2192",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "data-insight",
    "title": "Violence between Mexican drug cartels has surged in recent years",
    "authors": [
        "Bastian Herre"
    ],
    "approved-by": "Max Roser",
    "grapher-url": "https://ourworldindata.org/grapher/deaths-in-non-state-conflicts?tab=chart&country=~MEX"
}
 1 2024-06-14 11:23:09 2024-07-16 05:00:00 2024-07-08 11:39:54 unlisted ALBJ4LswjHdv_jESpJG1JfYLTx8cSAsv76p4jP-5w3I8d9n9k0NqLTlb3ZD8vYQDbQprUJKFNPfw3KjY9ix2jQ   <Image filename="deaths-in-non-state-conflicts-desktop.png"/> In recent years, tens of thousands of people have died due to fighting between drug cartels in Mexico. The chart uses data from the Uppsala Conflict Data Program to show the country's deaths from “non-state conflicts” over the last thirty years. These conflicts involve fighting between non-state armed groups, which in Mexico are criminal organizations like the Jalisco, Juarez, Los Zetas, and Sinaloa drug cartels. Before the 2000s, there were relatively few deaths from these conflicts. The number of deaths then began to increase, reaching a peak of over 18,000 deaths in 2021. [Explore this data for other countries](https://ourworldindata.org/grapher/deaths-in-non-state-conflicts?tab=chart&country=~MEX) → Violence between Mexican drug cartels has surged in recent years

Links from other tables