posts_unified: 123

This table merges gdocs and wordpress posts. Use this one over either the posts or posts_gdocs table if you want to query for content. This table adds several very useful convenience features: In our publishing pipeline, GDocs posts take precedence over wordpress posts with the same slug. This table likewise shows only the published gdocs post result row and hides the wordpress post row with the same slug if there is one. The Gdocs posts have a type column. This table also retrofits this type to wordpress posts. The type is one of: topic-page - modular topic pages with key insights etc article - article pages (which also contains some admin-like pages e.g. the /privacy-policy page) linear-topic-page - old style linear topic pages (formerly called entries) data-insights - the new short data insights author - author pages about-page - about pages like the team page fragment - utility page fragments like the details on demand doc or data page FAQs homepage - a special type just for the homepage The wordpressId and gdocId columns respectively can be used to a) figure out which of the two is the source for any given row and b) join to the corresponding entity. This table does not contain either archieml nor markdown content (for space reasons). If you care for those, consult the view posts_unified_with_content

Data license: CC-BY

This data as json

id slug title type publishedAt updatedAt authors createdAt publicationContext gdocId wordpressId
123 food-waste-emissions Food waste is responsible for 6% of global greenhouse gas emissions article 2020-03-18 10:00:00 2024-03-18 15:41:59 
[
    "Hannah Ritchie"
]
 2023-09-01 15:59:25 listed 19JMZ5eAiHlnY5Kb_AXu6e286aWELPXizQO7e5qdWgGQ