posts_gdocs: 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k

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
11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k veronika-samborska author 
{
    "bio": [
        {
            "type": "text",
            "value": [
                {
                    "text": "Veronika joined us in 2023. She recently finished her Ph.D. in Computational Neuroscience at the University of Oxford, and previously worked in the Data Journalism team at the Financial Times.",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "body": [
        {
            "rows": [],
            "type": "research-and-writing",
            "heading": "All work",
            "primary": [],
            "secondary": [
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1NKASbsxax57u5ILzjysEDnlQiUTb7lzZHekOYWs35p4/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1qW5ok-Jo_asj_7A7WWfHHR_PpXhoUrD3OyssHfyWHtM/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1gqIjXjFp1li7Jb6igdtePWrg5gCtAgmx3n4DKopAWi0/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1LdL7Zb-1kmgdIe4IrHV40qjPafc_SStDGMdBn6evqhM/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1tS43kJ8ckyvaSEOqBBf0WtUtJ3X7T_Yh8J66HQQZS80/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1AGZVcZQjeUZ_-XvzkpUH68SU819fjCaS9xGFL8zDjf0/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1FbKVWqPddBZy0NcHzDG-BSoCsN5tJnok3RXcLo6R9ls/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/11t6XP9vKLDHeiDOcfaPOoc4TeQxHRixSjEikAlbGe0A/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1JThdVafiH5m-oocV60ise6Sxe6wOLWp3ijAmJKkUIjM/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1bnRuD7s6HMixQgapcH6GPQFK6ccFlDk0mQ9u7tqXiqs/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://ourworldindata.org/oil-spills",
                        "title": "Oil Spills",
                        "authors": [
                            "Hannah Ritchie",
                            "Veronika Samborska",
                            "Max Roser"
                        ],
                        "filename": "Oil-Spills.png",
                        "subtitle": "How often do oil spills happen? How did the frequency of oil spills change over time?"
                    }
                }
            ],
            "parseErrors": [],
            "hide-authors": true
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "role": "Data Scientist",
    "type": "author",
    "title": "Veronika Samborska",
    "authors": [
        "Our World in Data team"
    ],
    "socials": {
        "type": "socials",
        "links": [
            {
                "url": "mailto:[email protected]",
                "text": "[email protected]",
                "type": "email"
            }
        ],
        "parseErrors": []
    },
    "featured-image": "VeronikaSamborska.png"
}
 1 2024-05-23 09:46:16 2024-05-28 12:20:09 1970-01-01 00:00:00 unlisted ALBJ4LuOfweB_qijFKNWwZQsyLyD3061FC3CtTFEGqfNQjphUv7rQNJam0Zah4NsJp6izeYSzmIkzDBBQlIrFw     Veronika Samborska

Links from other tables