posts_gdocs: 1T16aVjbEL7aweA3y2fQrMSUXPRkRLTsi97tQRy9saGE

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
1T16aVjbEL7aweA3y2fQrMSUXPRkRLTsi97tQRy9saGE core-lgbt-rights-are-becoming-more-protected-in-some-countries data-insight 
{
    "body": [
        {
            "size": "narrow",
            "type": "image",
            "filename": "countries-protecting-core-lgbt-rights-desktop.png",
            "hasOutline": false,
            "parseErrors": [],
            "smallFilename": "countries-protecting-core-lgbt-rights-mobile.png"
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Important LGBT+ rights are becoming better protected in some countries, according to the work of researcher Kristopher Velasco.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "The chart shows that in the early 1990s, very few countries protected LGBT+ rights beyond allowing same-sex sexual acts. Back then, no countries allowed same-sex partners to marry or adopt children, none recognized a third gender, and only two made it easy to change one\u2019s gender marker legally.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "text": "Over the last few decades, more countries have offered and protected these rights. Most countries have now legalized same-sex relationships, and same-sex marriage, adoption, third-gender recognition, and gender marker changes are becoming more common. However, most countries still do not recognize these important rights.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        },
        {
            "type": "text",
            "value": [
                {
                    "url": "https://ourworldindata.org/grapher/countries-protecting-core-lgbt-rights",
                    "children": [
                        {
                            "text": "Explore this data",
                            "spanType": "span-simple-text"
                        }
                    ],
                    "spanType": "span-link"
                },
                {
                    "text": " \u2192",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "type": "data-insight",
    "title": "Core LGBT+ rights are becoming more protected in some countries",
    "authors": [
        "Bastian Herre"
    ],
    "approved-by": "Ed",
    "grapher-url": "https://ourworldindata.org/grapher/countries-protecting-core-lgbt-rights"
}
 1 2024-05-17 14:12:57 2024-06-07 06:53:42 2024-05-27 11:50:55 unlisted ALBJ4LscRExvTUzlndYHf1bYOZgLwN7rvmZhSbvJgb8l88qDvzkCNfH1KR9fHp1x67cRLcD2sX9FXK1HmycE9w   <Image filename="countries-protecting-core-lgbt-rights-desktop.png"/> Important LGBT+ rights are becoming better protected in some countries, according to the work of researcher Kristopher Velasco. The chart shows that in the early 1990s, very few countries protected LGBT+ rights beyond allowing same-sex sexual acts. Back then, no countries allowed same-sex partners to marry or adopt children, none recognized a third gender, and only two made it easy to change one’s gender marker legally. Over the last few decades, more countries have offered and protected these rights. Most countries have now legalized same-sex relationships, and same-sex marriage, adoption, third-gender recognition, and gender marker changes are becoming more common. However, most countries still do not recognize these important rights. [Explore this data](https://ourworldindata.org/grapher/countries-protecting-core-lgbt-rights) → Core LGBT+ rights are becoming more protected in some countries

Links from other tables