posts_unified
Data license: CC-BY
1 row where gdocId = "10Jr8gCMHoxmW2kcyn1_UatF3vFIFIWuE5QekD5gMsW0"
This data as json, CSV (advanced)
Suggested facets: publishedAt (date), updatedAt (date), createdAt (date), authors (array)
id ▼ | slug | title | type | publishedAt | updatedAt | authors | createdAt | publicationContext | gdocId | wordpressId |
---|---|---|---|---|---|---|---|---|---|---|
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );