posts_unified
Data license: CC-BY
1 row where gdocId = "14vky93tgncE1UGNhPVPvTQM6SXftTx7VlLeUHF6WfFQ"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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) );