posts_unified

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

695 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: type, publicationContext, publishedAt (date), updatedAt (date), createdAt (date), authors (array)

id ▼ slug title type publishedAt updatedAt authors createdAt publicationContext gdocId wordpressId
1 data-pages-texts-gini-coefficient-pip Data pages texts – Gini Coefficient | PIP fragment 2023-06-16 14:43:15 2023-12-28 16:31:00 
[
    "Our World in Data team"
]
 2023-04-14 08:56:51 unlisted Data pages texts – Gini Coefficient | PIP 1__qnfvbuEsT5EkU-3-TF65jShUuOefyxvy5CUmZRAvI  
2 natural-disasters Natural Disasters topic-page 2022-12-07 23:02:31 2024-03-12 16:14:53 
[
    "Hannah Ritchie",
    "Pablo Rosado"
]
 2023-11-09 23:02:09 unlisted Natural Disasters 1_1Lulu1muRprdpbPB1nN1UPDQfPOEUFR3aCbfOvagJM  
3 risk-ratios-odds-ratios-risk-differences-how-do-researchers-calculate-the-risk-from-a-risk-factor Risk ratios, odds ratios, risk differences: How do researchers calculate the risk from a risk factor? article 2023-08-09 13:28:47 2023-12-28 16:31:02 
[
    "Saloni Dattani"
]
 2023-08-07 09:32:13 listed Risk ratios, odds ratios, risk differences: How do researchers calculate the risk from a risk factor? 1_huRz73MdBfxe_DtZhc4BDVwNJsUwRS2MgzXtY1UJbY  
4 deaths-from-tetanus-have-been-reduced-massively Deaths from tetanus have been reduced massively data-insight 2024-06-05 05:24:35 2024-04-08 12:03:43 
[
    "Saloni Dattani"
]
 2024-04-04 13:20:57 unlisted Deaths from tetanus have been reduced massively 1_M63k9gi0ObqYlzNacx0Qokf7rWi1S3_lOeXRhyAomU  
5 indias-population-growth-will-come-to-an-end India's population growth will come to an end: the number of children has already peaked article 2019-01-15 11:00:14 2024-03-18 15:41:59 
[
    "Hannah Ritchie"
]
 2023-03-20 10:58:03 listed India's population growth will come to an end: the number of children has already peaked 1_S_O04KDyANxCxG5iTZdZaQjItTNldSy61OlIpsK4Fg  
6 colonialism-meant-that-for-centuries-many-territories-and-people-were-ruled-from-elsewhere Colonialism meant that for centuries, many territories and people were ruled from elsewhere data-insight 2024-03-22 08:05:19 2024-03-26 09:36:41 
[
    "Bastian Herre"
]
 2024-02-07 13:43:11 unlisted Colonialism meant that for centuries, many territories and people were ruled from elsewhere 1-8ym_g3-B-YgH-WXhRejwuQ2dTYVYMJVJ6c8RIeWYpE  
7 higher-poverty-global-line Global poverty in an unequal world: Who is considered poor in a rich country? And what does this mean for our understanding of global poverty? article 2021-03-05 11:02:06 2023-12-28 16:31:02 
[
    "Max Roser"
]
 2023-10-13 16:23:24 listed Global poverty in an unequal world: Who is considered poor in a rich country? And what does this mean for our understanding of global poverty? 1-kIEUSceYmhNRmjOjQ0zc1MgXRX4jd4jjqhPypanPVc  
8 personal-relations-econ-outcomes The importance of personal relations for economic outcomes article 2019-11-15 11:00:52 2024-02-14 21:33:32 
[
    "Esteban Ortiz-Ospina"
]
 2024-02-14 21:25:55 listed The importance of personal relations for economic outcomes 1-moDkA6s2Yv4liptTqlc8ZWjzXlohGfNJWJxaKK4jiI  
9 kurzgesagt-coronavirus-video We teamed up with Kurzgesagt to make a video about the COVID-19 pandemic article 2020-03-23 08:52:00 2024-03-18 15:41:59 
[
    "Max Roser",
    "Hannah Ritchie"
]
 2024-01-30 14:26:54 listed We teamed up with Kurzgesagt to make a video about the COVID-19 pandemic 1-OyaOVareb9UzOFB8bpBzdIR6pW9nZMfWrj-urzV6y0  
10 leaded-gasoline-phase-out How the world eliminated lead from gasoline article 2022-01-11 08:53:44 2024-03-01 20:04:23 
[
    "Hannah Ritchie"
]
 2024-03-01 19:56:50 listed How the world eliminated lead from gasoline 1-q5j1Q9qKqsTJNgX4qekUzOc3RxQSJwelPcFxkEJmBc  
11 owid-homepage OWID Homepage homepage 2024-02-28 15:02:00 2024-03-25 11:31:28 
[
    "Our World in Data"
]
 2024-02-22 21:04:05 unlisted OWID Homepage 1-X5zMYoLTJqD6kidXYd1GuIDj1uhlPe5-Em5B7vsgNo  
12 covid-19-was-the-third-largest-cause-of-death-in-2021 COVID-19 was the third largest cause of death in 2021 data-insight 2024-06-24 04:00:00 2024-06-18 14:56:55 
[
    "Fiona Spooner"
]
 2024-06-14 15:12:48 unlisted COVID-19 was the third largest cause of death in 2021 1-yuHpr-R9pMRy3WdGkAIqasZaU9HiSDoqh1AjOqpeI4  
13 covid-mobility-trends Google Mobility Trends: How has the pandemic changed the movement of people around the world? article 2020-06-02 09:38:53 2024-02-22 13:18:39 
[
    "Hannah Ritchie"
]
 2024-02-15 21:53:21 listed Google Mobility Trends: How has the pandemic changed the movement of people around the world? 1-zLDiKKlLAYqDxCdW_1r-aPiJ3NMqIhDVA60jNQ01Og  
14 stunting-definition What is childhood stunting? article 2022-02-04 14:48:18 2024-03-04 12:48:55 
[
    "Hannah Ritchie"
]
 2023-05-15 22:38:29 listed What is childhood stunting? 10_Rd495M2omFB-oWqDk3Sey7TXONQI3HoP-rIRiLcOA  
15 child-labor Child Labor linear-topic-page 2016-02-01 15:27:00 2024-03-18 09:19:28 
[
    "Esteban Ortiz-Ospina",
    "Max Roser"
]
 2023-11-10 15:26:36 unlisted Child Labor 1049NVx1QWUKDro4Ztuu3L8hGMw7GyHtv5EZFpPp2uzg  
16 carbon-deforestation-trade Carbon emissions from deforestation: are they driven by domestic demand or international trade? article 2021-02-06 17:10:29 2024-01-15 14:47:53 
[
    "Hannah Ritchie"
]
 2023-10-01 16:27:54 unlisted Carbon emissions from deforestation: are they driven by domestic demand or international trade? 10AH7TExXrcsO5tiGPU7t1kLqh8N_u7ogBnjN6e6FMig  
17 renewable-energy Renewable Energy article 2020-12-17 13:50:00 2024-03-11 13:18:43 
[
    "Hannah Ritchie",
    "Max Roser",
    "Pablo Rosado"
]
 2023-10-09 15:53:30 unlisted Renewable Energy 10dLcR7-nm5JlO1m1InDCTGCmDt_L3fO7jz0yxmcjxdw  
18 which-countries-have-fertility-rates-above-or-below-the-replacement-level Which countries have fertility rates above or below the “replacement level”? data-insight 2024-06-10 06:40:50 2024-06-03 13:53:27 
[
    "Hannah Ritchie"
]
 2024-05-27 11:03:55 unlisted Which countries have fertility rates above or below the “replacement level”? 10eJMNqSS0UB2hNUmfGcJgPT40z96eU4hwu851htPjg0  
19 covid-deaths-by-vaccination How do death rates from COVID-19 differ between people who are vaccinated and those who are not? article 2021-11-23 15:00:00 2024-03-18 15:41:59 
[
    "Edouard Mathieu",
    "Max Roser"
]
 2023-12-28 11:46:12 listed How do death rates from COVID-19 differ between people who are vaccinated and those who are not? 10jlQ3AeAbDLEMztLNTunen7yZZ6QFT-TcVOQyyV-MJY  
20 the-global-malaria-death-rate-increased-for-the-first-time-in-20-years-due-to-covid-19 The global malaria death rate increased for the first time in 20 years due to COVID-19 data-insight 2024-07-08 05:00:00 2024-06-28 13:33:39 
[
    "Fiona Spooner"
]
 2024-06-21 10:35:17 unlisted The global malaria death rate increased for the first time in 20 years due to COVID-19 10Jr8gCMHoxmW2kcyn1_UatF3vFIFIWuE5QekD5gMsW0  
21 democracies-age In most countries, democracy is a recent achievement. Dictatorship is far from a distant memory article 2022-02-03 11:43:37 2024-03-18 15:41:59 
[
    "Bastian Herre"
]
 2023-07-21 16:16:52 listed In most countries, democracy is a recent achievement. Dictatorship is far from a distant memory 10mpw95MM1OZO__0g75j1rHhEp2pjBlDnUcY08uyvn_E  
22 data-pages-texts-self-reported-life-satisfaction-world-happiness-report Data pages texts – self-reported life satisfaction | World Happiness Report fragment 2023-06-16 14:40:26 2023-12-28 16:31:02 
[
    "Joe Hasell",
    "Matthieu Bergel"
]
 2023-04-27 10:14:03 unlisted Data pages texts – self-reported life satisfaction | World Happiness Report 10NGR-wbXo9gPzlop90tH0poslBylWwZkYSySO1HPqF8  
23 living-planet-index-understanding How the Living Planet project helps us understand changes in the world’s wildlife article 2021-05-17 09:00:00 2024-02-27 18:14:24 
[
    "Hannah Ritchie"
]
 2024-02-27 18:10:16 listed How the Living Planet project helps us understand changes in the world’s wildlife 10Pf_NPQgAIFW9cRlc8Yz7rM7P6rc81e3-vsqgUHlwto  
24 depression-lifetime-risk What is the lifetime risk of depression? article 2022-05-18 10:00:00 2024-03-18 15:41:59 
[
    "Saloni Dattani"
]
 2023-12-28 10:45:20 listed What is the lifetime risk of depression? 10PyCsSb21U7iOMohyrmNWYc2GtX7Tqpf8aG5jktJTuQ  
25 there-are-large-differences-in-lgbt-rights-across-the-world There are large differences in LGBT+ rights across the world data-insight 2024-06-03 10:32:11 2024-06-03 10:31:35 
[
    "Bastian Herre"
]
 2024-05-16 07:56:30 unlisted There are large differences in LGBT+ rights across the world 10rO92R2yalg8EAukD4njwrDNQ40LH2Xhtnn3SnuzJlE  
26 decline-lead-poisoning Many countries have achieved an impressive reduction in lead poisoning article 2022-01-11 09:16:48 2024-03-01 20:09:06 
[
    "Hannah Ritchie"
]
 2024-03-01 20:05:16 listed Many countries have achieved an impressive reduction in lead poisoning 10TTu-Bky1HZIJj1Q8UbVk4uNPmL6VnZHnmbRJUj_W7M  
27 palm-oil Palm Oil article 2021-02-04 14:39:00 2024-01-15 14:52:15 
[
    "Hannah Ritchie"
]
 2023-10-02 04:49:41 unlisted Palm Oil 10vsjfsq76RM-loU5y8INFGwwvkHGVJxPjXZqB9aWXzs  
28 a-history-of-global-living-conditions The short history of global living conditions and why it matters that we know it article 2016-12-14 14:40:45 2024-03-19 22:04:08 
[
    "Max Roser"
]
 2023-10-16 11:38:49 listed The short history of global living conditions and why it matters that we know it 10xzhxqLpGUdeXB11WLvDYQb2DO3NUggjMuPFJGKZoLg  
29 oral-rehydration-therapy Oral rehydration therapy: a low-tech solution that has saved millions of lives article 2019-08-27 11:00:13 2024-03-18 15:41:59 
[
    "Bernadeta Dadonaite"
]
 2023-07-06 14:30:12 listed Oral rehydration therapy: a low-tech solution that has saved millions of lives 10YlW6aWgcX9oBiKIk6-NQ5V8BA9jxErcEIliG1C1JD4  
30 veronika-samborska Veronika Samborska author 2024-05-28 12:20:09 1970-01-01 00:00:00 
[
    "Our World in Data team"
]
 2024-05-23 09:46:16 unlisted Veronika Samborska 11cOaZmA-tR81eI7l-Imcz_3GaEHYBhkASc6PHgxZh8k  
31 child-mortality-big-problem-in-brief Child mortality: an everyday tragedy of enormous scale that we can make progress against article 2021-07-21 09:00:00 2024-03-18 15:41:59 
[
    "Max Roser"
]
 2023-08-29 13:27:52 listed Child mortality: an everyday tragedy of enormous scale that we can make progress against 11jqsIwg5rtHxx6dXfcSydC4JFdlfnSq9xfqxDfjUqSQ  
32 parents-losing-their-child How often did parents see their children die? article 2019-09-12 10:00:17 2024-03-18 15:41:59 
[
    "Max Roser"
]
 2023-08-29 13:37:53 listed How often did parents see their children die? 11s41-PjJiMQzWRzgx7QQ8Xfr0cRfRI4hgdSNsHK7ZsI  
33 artificial-intelligence Artificial Intelligence topic-page 2023-09-21 13:44:07 2024-01-31 10:23:53 
[
    "Charlie Giattino",
    "Edouard Mathieu",
    "Veronika Samborska",
    "Max Roser"
]
 2023-08-30 14:18:42 listed Artificial Intelligence 11t6XP9vKLDHeiDOcfaPOoc4TeQxHRixSjEikAlbGe0A  
34 water-sanitation-2020-update The world is making progress on clean water and sanitation, but is far behind its target to ensure universal access by 2030 article 2021-07-01 14:45:00 2024-03-18 15:41:59 
[
    "Hannah Ritchie"
]
 2023-09-29 14:51:42 listed The world is making progress on clean water and sanitation, but is far behind its target to ensure universal access by 2030 123VZrjdAkaWKdoBzLUGfTuqha_Hnan_SwM8RMbuq-vE  
35 homepage-redesign We’ve redesigned our homepage article 2024-02-28 15:00:15 2024-03-04 08:59:45 
[
    "Matt Munday",
    "Joe Hasell",
    "Marwa Boukarim",
    "Ike Saunders",
    "Sophia Mersmann",
    "Max Roser"
]
 2024-02-23 15:35:02 listed We’ve redesigned our homepage 12aB8hv0GererRKBogq6jSbA33NuIbMmA1xZq3mVKFFM  
36 the-rise-and-fall-of-homicides-in-europe The rise and fall of homicides in Europe data-insight 2024-07-12 05:00:00 2024-07-10 08:13:28 
[
    "Bastian Herre"
]
 2024-06-07 07:43:51 unlisted The rise and fall of homicides in Europe 12ADdYAyzt9FQwxkVVDjH3vwRvEmUuc5e90GwXnsILVs  
37 renewable-electricity-2023 30% of the world's electricity came from renewable sources in 2023 data-insight 2024-05-08 08:50:09 2024-05-08 08:40:57 
[
    "Hannah Ritchie",
    "Pablo Rosado"
]
 2024-05-07 13:36:52 unlisted 30% of the world's electricity came from renewable sources in 2023 12gem-7WfQKJaIunmrCUJ_mm8U-mFuSVKalJA_GoxDNg  
38 moores-law What is Moore's Law? article 2023-03-28 07:03:00 2024-02-01 18:32:53 
[
    "Max Roser",
    "Hannah Ritchie",
    "Edouard Mathieu"
]
 2024-02-01 18:23:46 listed What is Moore's Law? 12hNREWcrwyOrJugzc7gYHN5Qv_UJBJ-GnY_FzMbXByE  
39 population-projections The UN has made population projections for more than 50 years – how accurate have they been? article 2023-06-20 12:45:19 2023-12-28 16:31:02 
[
    "Hannah Ritchie"
]
 2023-05-30 13:56:14 unlisted The UN has made population projections for more than 50 years – how accurate have they been? 12pOUzwnLDAhepgTRRKf6j2dvVY77SSo45j-rTsZ67yI  
40 the-future-is-vast The future is vast – what does this mean for our own life? article 2022-03-15 11:00:00 2024-03-18 15:41:59 
[
    "Max Roser"
]
 2023-07-10 15:36:03 listed The future is vast – what does this mean for our own life? 12RDi6GKPy1UhESltINgvN5NYhx3CrBySUZt20qR0lko  
41 sdgs/life-on-land Sustainably manage forests, combat desertification, halt and reverse land degradation, halt biodiversity loss article 2023-07-18 14:12:44 2023-12-28 16:31:02 
[
    "Our World in Data team"
]
 2022-10-13 07:16:29 unlisted Sustainably manage forests, combat desertification, halt and reverse land degradation, halt biodiversity loss 12VBBcMsdQqVpP2lCVmyxsjtu8ilmw9ruXTJvbJ9JUWY  
42 us-weather-climate How are extreme weather events and the climate evolving in the United States? article 2024-05-20 10:16:54 2024-04-18 09:18:55 
[
    "Hannah Ritchie"
]
 2024-04-08 08:29:31 unlisted How are extreme weather events and the climate evolving in the United States? 12wKSUdc4v2Za_xoR8JW-9X8YRV6SQnUUtpcQ646E4uQ  
43 in-which-countries-do-people-drink-the-most-alcohol In which countries do people drink the most alcohol? data-insight 2024-07-26 05:00:00 2024-07-22 07:33:32 
[
    "Charlie Giattino"
]
 2024-06-27 21:50:45 unlisted In which countries do people drink the most alcohol? 12YbG1W5F9OU6EM018--Cuinp9rG_nwGz90I0CrihD_U  
44 fossil-fuels Fossil fuels article 2017-10-02 05:40:00 2024-01-05 10:51:18 
[
    "Hannah Ritchie",
    "Pablo Rosado"
]
 2023-10-06 18:49:52 unlisted Fossil fuels 1367JYppXDeRKREHYCj8x3mnvp69UUJIpun2P2yHjUXc  
45 population-growth Population Growth topic-page 2023-07-11 09:17:05 2024-06-17 09:15:09 
[
    "Hannah Ritchie",
    "Lucas Rod\u00e9s-Guirao",
    "Edouard Mathieu",
    "Marcel Gerber",
    "Esteban Ortiz-Ospina",
    "Joe Hasell",
    "Max Roser"
]
 2024-06-17 09:12:40 unlisted Population Growth 138RBPWhDv0CWxZFTcS_uaDIbAGDlcaIgcOvfA12RQ-k  
46 inequality-co2 Global inequalities in CO2 emissions article 2023-08-31 17:14:18 2023-12-28 16:31:02 
[
    "Hannah Ritchie"
]
 2023-08-30 16:26:35 unlisted Global inequalities in CO2 emissions 13DQKzRHfgLPuaTxuSh3ljJJPFC_lFRn39ixunDPh8AY  
47 how-are-causes-of-death-registered-around-the-world How are causes of death registered around the world? article 2023-08-09 13:40:03 2023-12-28 16:31:02 
[
    "Saloni Dattani"
]
 2023-07-17 14:08:18 listed How are causes of death registered around the world? 13dQWV1hDG1I0bf0HLvYGrgGxlW-7l1ci6rhL9Wf2XQc  
48 travel-carbon-footprint Which form of transport has the smallest carbon footprint? article 2023-08-30 18:50:13 2024-03-18 15:41:59 
[
    "Hannah Ritchie"
]
 2023-08-30 16:33:25 listed Which form of transport has the smallest carbon footprint? 13FDcmn5r9qfHI9cwOffAils92yk-lzm5WzfKuFP84K4  
49 china-has-been-expanding-its-nuclear-weapons-arsenal China has been expanding its nuclear weapons arsenal data-insight 2024-04-18 06:57:01 2024-04-16 12:26:43 
[
    "Bastian Herre"
]
 2024-04-10 08:06:57 unlisted China has been expanding its nuclear weapons arsenal 13Gv4VhZ6llymEvrRTE1VYzLw0hg_1Ai3zTBenH2i_Ms  
50 sdgs/good-health-wellbeing Ensure healthy lives and promote well-being for all at all ages article 2023-07-18 14:12:07 2024-02-26 13:40:42 
[
    "Our World in Data team"
]
 2022-10-07 16:47:56 unlisted Ensure healthy lives and promote well-being for all at all ages 13h0YhjQ62qnXLAePmDSV0TEahnjf3Nd82Ke2c4ggVCY  
51 how-rinderpest-was-eradicated How rinderpest was eradicated article 2018-09-30 11:05:56 2024-03-14 11:05:19 
[
    "Sophie Ochmann",
    "Hannah Behrens"
]
 2024-03-12 22:53:04 listed How rinderpest was eradicated 13HyOhuWuBojrXbv9h-pH-qp0HCJGMlThys_hSWgFMvU  
52 energy-gdp-decoupling A number of countries have decoupled economic growth from energy use, even if we take offshored production into account article 2021-11-30 10:34:32 2023-12-28 16:31:03 
[
    "Hannah Ritchie"
]
 2023-10-09 19:16:20 unlisted A number of countries have decoupled economic growth from energy use, even if we take offshored production into account 13jeFKD5_wOCYZQEZtRufYxPwDLr9e9pDpOphBMa022Y  
53 micronutrient-deficiency Micronutrient Deficiency linear-topic-page 2017-08-01 15:12:27 2024-02-29 10:54:41 
[
    "Hannah Ritchie",
    "Max Roser"
]
 2023-11-10 16:11:20 unlisted Micronutrient Deficiency 13s3a_bgPT8_VRu50K1pf9Nc7zhu-IyxqYzUDR95NCRw  
54 covid-exemplar-germany Emerging COVID-19 success story: Germany's push to maintain progress article 2021-03-20 15:02:00 2024-03-13 21:20:11 
[
    "Guest Authors"
]
 2024-03-12 22:13:48 listed Emerging COVID-19 success story: Germany's push to maintain progress 13X37nTrNZRFr6-QanpbsbitHnN7GF2Ks8V6GZzvMcmc  
55 climate-change-support More people care about climate change than you think article 2024-03-25 10:48:30 2024-03-25 10:48:41 
[
    "Hannah Ritchie"
]
 2024-02-20 11:51:20 listed More people care about climate change than you think 149zTbHYFsEqfAI2fwNhWOg-1kEDZIfwT92JsibJRcwg  
56 gender-ratio Gender Ratio linear-topic-page 2019-06-01 22:10:00 2024-03-12 16:17:43 
[
    "Hannah Ritchie",
    "Max Roser"
]
 2023-11-09 23:09:21 unlisted Gender Ratio 14AUl03LTD3lJpit0HeBfq86zpu-yRrRVsTCwDS22Z_8  
57 progress-on-reducing-global-hunger-has-stagnated Progress on reducing global hunger has stagnated data-insight 2024-07-17 05:00:00 2024-06-28 09:44:34 
[
    "Hannah Ritchie"
]
 2024-03-17 14:06:55 unlisted Progress on reducing global hunger has stagnated 14DcvAmNNSD9GmNPk74pFxuGmrnFb80PYz3cI3UJb13o  
58 what-are-ppps What are PPP adjustments and why do we need them? article 2017-03-16 15:10:49 2024-02-11 22:44:27 
[
    "Esteban Ortiz-Ospina",
    "Marco Molteni"
]
 2024-02-11 22:33:06 listed What are PPP adjustments and why do we need them? 14dh8njbqF56gV72IrCXo6HgNEkSfVpgM1bC5p_wqmWk  
59 food-supply Food Supply linear-topic-page 2013-03-05 15:22:59 2024-01-02 15:53:23 
[
    "Max Roser",
    "Hannah Ritchie",
    "Pablo Rosado"
]
 2023-11-10 15:22:11 unlisted Food Supply 14eHWSP57fDnIsbKVIkpEFf2nFlXP_egrcdIDp881QfM  
60 rise-of-aquaculture The world now produces more seafood from fish farms than wild catch article 2019-09-13 10:00:15 2024-02-09 11:16:46 
[
    "Hannah Ritchie"
]
 2024-02-08 20:06:41 listed The world now produces more seafood from fish farms than wild catch 14JDuSUr7hpnF7IwFidmpdnW2ltcVn_Fnmzo1kNpj99E  
61 human-rights-have-improved-in-all-world-regions-over-the-last-century Human rights have improved in all world regions over the last century data-insight 2024-06-14 07:03:43 2024-05-15 12:06:36 
[
    "Bastian Herre"
]
 2024-05-03 11:04:07 unlisted Human rights have improved in all world regions over the last century 14L18me_2cLhZVs7_QSIcTPOZTFS87gkrAJeXLPVt7iw  
62 much-better-awful-can-be-better The world is awful. The world is much better. The world can be much better. article 2022-07-20 10:00:00 2024-03-18 15:41:59 
[
    "Max Roser"
]
 2023-08-10 18:11:09 listed The world is awful. The world is much better. The world can be much better. 14Ldxb-r3ibr2hX7GrxsnKXJAbpCkZiznwlFRK7CFE8E  
63 greenhouse-gas-emissions-food How much of global greenhouse gas emissions come from food? article 2021-03-18 12:00:00 2024-03-18 15:41:59 
[
    "Hannah Ritchie"
]
 2023-09-01 16:01:36 listed How much of global greenhouse gas emissions come from food? 14mP-ggvpZzAWxJKgLVkMOG908r61Vcc-X9in1_VFD1g  
64 shrink-emissions-not-the-economy Shrink emissions, not the economy article 2018-03-25 20:35:00 2024-03-18 15:41:59 
[
    "Guest Authors"
]
 2023-08-31 15:46:44 listed Shrink emissions, not the economy 14njaJuIyfkr6o2s2SWCVZwrgClCkawnOsEtQSn4cNyo  
65 progress-lgbt-rights LGBT+ rights have become more protected in dozens of countries, but are not recognized across most of the world article 2024-06-24 08:00:00 2024-06-24 08:03:32 
[
    "Bastian Herre",
    "Pablo Arriagada"
]
 2024-05-27 07:48:04 listed LGBT+ rights have become more protected in dozens of countries, but are not recognized across most of the world 14o4qiXQqQHuJiQNTjrmxP28VRjL9EVqDYRxXJjbRMkY  
66 human-development-index The Human Development Index and related indices: what they are and what we can learn from them article 2023-11-01 12:23:21 2024-02-12 20:23:25 
[
    "Bastian Herre",
    "Pablo Arriagada"
]
 2023-08-30 14:42:08 listed The Human Development Index and related indices: what they are and what we can learn from them 14oZiFSKZfaBkWTcYg0-k2q5riIcow_vcwpcIJxTljeg  
67 taxation Taxation linear-topic-page 2016-09-01 14:40:31 2024-03-22 08:47:07 
[
    "Esteban Ortiz-Ospina",
    "Max Roser"
]
 2023-11-10 15:39:05 unlisted Taxation 14PxOpHswe28nQkeIBo_0pHqXkGdiAwsGnMcGn82Ub-U  
68 extinction-risk-definition What does it mean for a species to be at risk of extinction? article 2023-02-20 10:56:33 2024-03-10 13:17:38 
[
    "Hannah Ritchie"
]
 2024-03-10 13:14:26 listed What does it mean for a species to be at risk of extinction? 14SGOgwH7D0N51LGCXHhHMnRR1FbZqEfTNI98ipiRmrk  
69 less-democratic The world has recently become less democratic article 2022-09-06 10:40:47 2024-03-18 15:41:59 
[
    "Bastian Herre"
]
 2023-07-21 16:25:49 listed The world has recently become less democratic 14ThFloGyQv4uSGdEeZROWq_2yvHC9ggnAFij_9Oyz6g  
70 owid-for-teaching-feedback Our World in Data for teaching – what we are learning from your feedback article 2018-07-23 06:04:11 2024-02-13 17:46:46 
[
    "Esteban Ortiz-Ospina"
]
 2024-02-13 17:41:08 listed Our World in Data for teaching – what we are learning from your feedback 14vky93tgncE1UGNhPVPvTQM6SXftTx7VlLeUHF6WfFQ  
71 vaccines-children-saved Vaccines have saved 150 million children over the last 50 years article 2024-05-06 07:05:37 2024-05-06 07:02:37 
[
    "Hannah Ritchie"
]
 2024-04-29 13:25:03 listed Vaccines have saved 150 million children over the last 50 years 14VyENlA3wIGTzYmhNvIpVjjXCSKVgXIi2wcJLXffEDM  
72 worlds-energy-problem The world’s energy problem article 2020-12-10 11:00:00 2024-03-18 15:41:59 
[
    "Max Roser"
]
 2023-09-01 14:38:18 listed The world’s energy problem 14ZnX7uW1aOuJAM7CPFmxwdq8fniYwBqDfbp4mlS0ZZA  
73 vdem-electoral-democracy-data The 'Varieties of Democracy' data: how do researchers measure democracy? article 2022-11-30 12:54:36 2023-12-28 16:31:03 
[
    "Bastian Herre"
]
 2023-07-21 11:42:08 unlisted The 'Varieties of Democracy' data: how do researchers measure democracy? 14zTYMg-mkPcMC68DqgQNb1eAe8VBwoD93yzyKGIeguw  
74 every-country-has-now-banned-the-use-of-leaded-gasoline-in-cars Every country has now banned the use of leaded gasoline in cars data-insight 2024-07-15 05:00:00 2024-03-21 09:07:18 
[
    "Hannah Ritchie"
]
 2024-03-11 11:43:02 unlisted Every country has now banned the use of leaded gasoline in cars 15A_-CBK20q0Qp6FMR2Gxv1__RATGGcHxvOz1sPyh6eg  
75 global-economic-inequality-introduction Global economic inequality: what matters most for your living conditions is not who you are, but where you are article 2021-12-09 11:30:00 2024-03-18 15:41:59 
[
    "Max Roser"
]
 2023-06-29 06:22:49 listed Global economic inequality: what matters most for your living conditions is not who you are, but where you are 15du6zm00Ll6DtJWlhu4o_lZgb72RKFyd43tflYSKIVA  
76 primary-education-in-morocco-from-less-than-half-to-nearly-universal-attendance Primary education in Morocco: from less than half to nearly universal attendance data-insight 2024-04-26 06:57:16 2024-04-11 07:52:40 
[
    "Veronika Samborska"
]
 2024-03-28 17:23:56 unlisted Primary education in Morocco: from less than half to nearly universal attendance 15fyG6ZxnUIvED-iIW0UsfBZcSCwMBUuWu7IiC7LXbZs  
77 yields-vs-land-use-how-has-the-world-produced-enough-food-for-a-growing-population Yields vs. land use: how the Green Revolution enabled us to feed a growing population article 2017-08-22 17:00:29 2024-02-01 18:17:55 
[
    "Hannah Ritchie"
]
 2024-01-31 12:53:04 listed Yields vs. land use: how the Green Revolution enabled us to feed a growing population 15hEchniGhmgO8mLsSi5mXek2a9na-Mo1VFtrsWcQw1g  
78 meat-production Meat and Dairy Production linear-topic-page 2019-11-01 13:24:08 2024-01-02 15:52:39 
[
    "Hannah Ritchie",
    "Pablo Rosado",
    "Max Roser"
]
 2023-11-10 14:22:45 unlisted Meat and Dairy Production 15jCyYwvJJnTVjTbYhGvq1fTnZEWOOQapIkcNHa77P0o  
79 billions-of-chickens-ducks-and-pigs-are-slaughtered-for-meat-every-year More than 80 billion land animals are slaughtered for meat every year data-insight 2024-05-31 06:52:00 2024-05-30 13:28:04 
[
    "Pablo Rosado"
]
 2024-05-17 14:11:01 unlisted More than 80 billion land animals are slaughtered for meat every year 15LrKgrEf63Nd2fR7NPG_L8sbTZM5mJ3Bt_QxejR7CVY  
80 adopting-slower-growing-breeds-of-chicken-would-reduce-animal-suffering-significantly Adopting slower-growing breeds of chicken would reduce animal suffering significantly article 2023-09-25 05:35:39 2023-12-28 16:31:03 
[
    "Hannah Ritchie"
]
 2023-08-15 14:48:49 unlisted Adopting slower-growing breeds of chicken would reduce animal suffering significantly 15lz5fnYyQmZX8cceYO8cu9O_QuoTidUUnQSjU7l3HVo  
81 disaster-database-limitations Is the number of natural disasters increasing? article 2024-06-03 10:04:00 2024-05-20 10:03:34 
[
    "Hannah Ritchie",
    "Pablo Rosado"
]
 2024-02-16 18:21:18 listed Is the number of natural disasters increasing? 15sjB_Kv--BQpTknXV_Qn4G_AU2WyASscEuqNq392epU  
82 democracy-health Does democracy lead to better health? article 2019-06-24 12:00:50 2024-03-18 15:41:59 
[
    "Esteban Ortiz-Ospina"
]
 2023-07-21 12:08:44 listed Does democracy lead to better health? 15TD9DyPmgOUFC8pMzMczLJmNTIw_j-gBM32JpInPJIU  
83 in-less-than-a-decade-peru-has-become-the-worlds-second-largest-blueberry-producer In less than a decade, Peru has become the world's second-largest blueberry producer data-insight 2024-05-23 06:09:20 2024-04-16 12:20:59 
[
    "Esteban Ortiz-Ospina"
]
 2024-04-09 20:34:53 unlisted In less than a decade, Peru has become the world's second-largest blueberry producer 15V5Fjl02ReEmdXgb8D9m78x96fV_TzJgfyku2UBddBQ  
84 cardiovascular-diseases-types-and-death-tolls What are the different types of cardiovascular diseases, and how many deaths do they cause? article 2023-12-14 11:38:09 2023-12-28 16:31:03 
[
    "Saloni Dattani"
]
 2023-12-03 13:37:31 unlisted What are the different types of cardiovascular diseases, and how many deaths do they cause? 15wEMvh8BRhU_AlICfnuam2JAbMKU3BRO4Syl7NG70q8  
85 air-conditioning-causes-around-greenhouse-gas-emissions-will-change-future Air conditioning causes around 3% of greenhouse gas emissions. How will this change in the future? article 2024-07-29 06:35:00 2024-07-16 13:22:56 
[
    "Hannah Ritchie"
]
 2024-06-25 10:41:52 listed Air conditioning causes around 3% of greenhouse gas emissions. How will this change in the future? 164FakXXyQZ0e8ScHZELNSr5FFS33uuTBgMvoUzFJ6MQ  
86 number-without-electricity The number of people without electricity more than halved over the last 20 years article 2021-11-30 11:12:46 2023-12-28 16:31:03 
[
    "Hannah Ritchie"
]
 2023-10-09 19:13:28 unlisted The number of people without electricity more than halved over the last 20 years 16deDiPnu75GLQavXz0R8ed1el5735Gl0uXqRSyQ3X38  
87 what-is-economic-growth What is economic growth? And why is it so important? article 2021-05-13 10:18:00 2024-03-18 15:41:59 
[
    "Max Roser"
]
 2023-08-10 15:26:51 listed What is economic growth? And why is it so important? 16Dlsel_vZgqtCDFMg280YAwnMNY2pn6KADXzLW5iSCA  
88 vaccines-antibiotic-dependence How new vaccines can help with our antibiotic dependence article 2017-11-18 15:52:06 2024-03-18 15:41:59 
[
    "Samantha Vanderslott"
]
 2023-07-11 15:23:02 listed How new vaccines can help with our antibiotic dependence 16HnUAgsqBGfcVnVtkadCgF4rCYAqqoxZ9xX36ojPTO8  
89 sdgs/responsible-consumption-production Ensure sustainable consumption and production patterns article 2023-07-18 14:15:10 2023-12-28 16:31:03 
[
    "Our World in Data team"
]
 2022-10-12 18:33:08 unlisted Ensure sustainable consumption and production patterns 16HusWInEqUpBTrDd0z2NgKNKIanHN1J9aQP_wTBil_M  
90 extreme-poverty-though-vastly-reduced-is-still-very-high-in-sub-saharan-africa Extreme poverty, though lower than in the past, is still very high in Sub-Saharan Africa data-insight 2024-06-17 07:09:43 2024-06-06 10:43:21 
[
    "Pablo Arriagada"
]
 2024-05-31 09:59:13 unlisted Extreme poverty, though lower than in the past, is still very high in Sub-Saharan Africa 16Hv7MxMHd87y4TZR8KDyEV7UVGdA3iBoIN0KTVYP8aI  
91 hygiene Hygiene and Handwashing article 2021-07-01 05:30:00 2024-01-16 13:43:32 
[
    "Hannah Ritchie",
    "Fiona Spooner",
    "Max Roser"
]
 2023-09-29 09:32:35 unlisted Hygiene and Handwashing 16i-Mku4DJyQJTa3q40necGrp7HqyoZHnE4k0GE6en1E  
92 maternal-mortality Maternal Mortality linear-topic-page 2013-11-12 15:21:27 2024-03-14 16:38:21 
[
    "Max Roser",
    "Hannah Ritchie"
]
 2023-11-10 15:20:27 unlisted Maternal Mortality 16tNgWH3Yzmwt3D2GGE3JAO95i2oTJ6upWoe2J9fpnZI  
93 influenza Influenza topic-page 2023-05-18 08:46:00 2024-02-15 13:47:43 
[
    "Saloni Dattani",
    "Fiona Spooner",
    "Hannah Ritchie",
    "Max Roser"
]
 2023-12-28 14:51:28 unlisted Influenza 16tVxsM1-wzwm_wpno-Y-M_IEInOCPJuWZqHfMLywNJc  
94 daniels-example-faqs Daniel's Example FAQs fragment 2023-08-04 10:26:02 2023-08-04 08:26:02 
[
    "Our World In Data"
]
 2023-08-04 08:24:28 unlisted Daniel's Example FAQs 16uGVylqtS-Ipc3OCxqapJ3BEVGjWf648wvZpzio1QFE  
95 drug-resistant-tuberculosis-is-much-more-expensive-to-treat Drug-resistant tuberculosis is much more expensive to treat data-insight 2024-05-15 06:21:29 2024-05-15 06:20:49 
[
    "Saloni Dattani"
]
 2024-04-04 13:39:18 unlisted Drug-resistant tuberculosis is much more expensive to treat 16zZpjoDKdGHL4ireE1IeUVmVYf3ChV21mGSi7azJV0A  
96 what-is-the-gini-coefficient Measuring inequality: what is the Gini coefficient? article 2023-06-30 07:18:32 2023-12-28 16:31:03 
[
    "Joe Hasell"
]
 2023-02-24 10:14:44 listed Measuring inequality: what is the Gini coefficient? 17-2C6H3kPd7w9DxWT2RG2QuLP0Pzxvm4H2RVsWFWUzM  
97 more-countries-have-legalized-same-sex-marriage-but-others-have-explicitly-banned-it More countries have legalized same-sex marriage, but others have explicitly banned it data-insight 2024-06-28 04:00:00 2024-06-24 13:17:21 
[
    "Bastian Herre"
]
 2024-05-24 11:45:44 unlisted More countries have legalized same-sex marriage, but others have explicitly banned it 17-5At7OXghZLCmsEg3dWMDBbwhNcCMI9vNX3uF4fL3M  
98 china-now-uses-about-the-same-amount-of-energy-per-person-as-the-european-union China now uses about the same amount of energy per person as the European Union data-insight 2024-07-01 05:00:00 2024-06-28 15:27:45 
[
    "Hannah Ritchie",
    "Pablo Rosado"
]
 2024-06-26 14:04:06 unlisted China now uses about the same amount of energy per person as the European Union 17a8PITVoE8_OIPjk7ELNV-ArjIptEiG-ph4IPrlKa7Y  
99 migration-definition Migration data: our sources and definitions article 2022-03-08 20:30:40 2024-03-04 19:46:32 
[
    "Hannah Ritchie",
    "Fiona Spooner"
]
 2024-03-04 19:40:59 listed Migration data: our sources and definitions 17jHJscbIFyrcDXNb3tUTVZJzLylcKEi0J-qNldo-efY  
100 per-capita-energy Global comparison: how much energy do people consume? article 2021-11-30 11:07:05 2023-12-28 16:31:03 
[
    "Hannah Ritchie"
]
 2023-10-09 19:04:14 unlisted Global comparison: how much energy do people consume? 17jqDNVdCSdYwAbOEEej4kY_7XuC1YvDHGidQ9qV2Z3Q  

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE posts_unified (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            slug TEXT,
            title TEXT,
            type TEXT,
            publishedAt TEXT,
            updatedAt TEXT,
            authors TEXT,
            createdAt TEXT,
            publicationContext TEXT,
            gdocId TEXT,
            wordpressId INTEGER,
            FOREIGN KEY(gdocId) REFERENCES posts_gdocs(id),
            FOREIGN KEY(wordpressId) REFERENCES posts(id)
            );