posts_gdocs: 1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo

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
1dt3Y98Z2S07ijr0kPq4FXzV2MgL1CycNzP9y-6D-3Fo fiona-spooner author 
{
    "bio": [
        {
            "type": "text",
            "value": [
                {
                    "text": "Fiona joined us in 2021. She was previously a Turing postdoctoral fellow at the University of Exeter working on tracking the Sustainable Development Goals and modeling the Covid-19 pandemic. She has a Ph.D. in Ecology and Environment from UCL (London, UK) and an MSc in Conservation Science from Imperial College (London, UK).",
                    "spanType": "span-simple-text"
                }
            ],
            "parseErrors": []
        }
    ],
    "body": [
        {
            "rows": [],
            "type": "research-and-writing",
            "heading": "All work",
            "primary": [],
            "secondary": [
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1LxPdXAyLDz61bVRINQ1MM7oCxxPCvKVYQD8yrWPcr_w/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1h37-KpdZ3qAJ9xSA4OhbmGfmLr3Ydc_z9oHtDTszBuQ/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1srs-VlnCNd1lMZBiuzNRUBsT41wWnGWddFRMiZ0jNaE/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1mDkPiGSy3dHCfnIFc1HAPU2XU3yz9iKWBNWfRUTniCw/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1MIqYC2m9BbCQWZp6g_1N6BDAXeXkEUAx-KaJrlWbcrE/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/16tVxsM1-wzwm_wpno-Y-M_IEInOCPJuWZqHfMLywNJc/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://ourworldindata.org/biodiversity",
                        "title": "Biodiversity",
                        "authors": [
                            "Hannah Ritchie",
                            "Fiona Spooner"
                        ],
                        "filename": "Biodiversity-thumbnail.png",
                        "subtitle": "Explore the diversity of wildlife across the planet. What are species threatened with? What can we do to prevent biodiversity loss?"
                    }
                },
                {
                    "value": {
                        "url": "https://ourworldindata.org/migration",
                        "title": "Migration",
                        "authors": [
                            "Esteban Ortiz-Ospina",
                            "Max Roser",
                            "Hannah Ritchie",
                            "Fiona Spooner",
                            "Marcel Gerber"
                        ],
                        "filename": "Migration.png",
                        "subtitle": "Migration has been an important source of economic development and poverty reduction. Explore data on global migration."
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1GhlZrbyAReOwQhdFG9eTsjLXTS_R8YhEK5WvxnM2O9Y/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1lmIiF_8Vlm2_ysg5UXeRPmQ_M8XbmXqzRs7g2uGwGyc/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1ZGKUXlb0RBlR5QJaEOzNq2rsIG2243r1fYUzg-ApHOs/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1pRAxZhIjvgSDkKHws4lcG3cXIT5fpwFW8ekkucWVG2M/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1RryPcgVJcANE76CPq5peAHTF3ag1WJe5BPujAXEjDkg/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1szX11tRqr-NDnar2J7gZBQWMCFB4JFj5BEw0RkReFkU/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1I3zjWv9OyeTZ4plQzxa4mdTeadqSn1bEbAKr-Vm3Du0/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/17jHJscbIFyrcDXNb3tUTVZJzLylcKEi0J-qNldo-efY/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1MQ9geOm4jFHY-tOEpdRe9VeahFfr38x2bZipD7rQt5k/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1oe_-FKOkoR8-QWg_6WuxZBZ4sxitO1j8m3g5-m8rXeI/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1iTocsoZaQQ_n-24LmYIT7XrOaPb9B6_3L-bbzQwu43M/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1dx9w3r4Wor4TDGAt4_Oggwuj-SVOzF7eT86CaO5efw8/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1vb0BMBIbn8XvTgQcsiVEkGU8O61hMzbafLfQH8D1G-c/edit"
                    }
                },
                {
                    "value": {
                        "url": "https://docs.google.com/document/d/1i01kXxNVBZcCmjKySFALGDz13zwoYnsJYj4LWRf21hE/edit"
                    }
                }
            ],
            "parseErrors": [],
            "hide-authors": true
        }
    ],
    "refs": {
        "errors": [],
        "definitions": {}
    },
    "role": "Senior Data Scientist",
    "type": "author",
    "title": "Fiona Spooner",
    "authors": [
        "Our World in Data team"
    ],
    "socials": {
        "type": "socials",
        "links": [
            {
                "url": "mailto:[email protected]",
                "text": "[email protected]",
                "type": "email"
            },
            {
                "url": "https://twitter.com/f_spooner",
                "text": "@f_spooner",
                "type": "x"
            }
        ],
        "parseErrors": []
    },
    "featured-image": "fiona_pic-e1622645364561.jpeg"
}
 1 2024-05-23 09:48:04 2024-05-28 12:20:17 1970-01-01 00:00:00 unlisted ALBJ4LvQLwKQ_Z_O04pB60qZEQodBzerAT5WVN_36Iqniimfa2In795QB-ds-ak7TfsjVDTvfT6t8YCpNjJ08w     Fiona Spooner

Links from other tables