Straits Times fields in every export
Article records carry the headline, standfirst, publication and update timestamps, section, the country or countries the story concerns, topic tags, author where bylined, word count, access level and the address.
Story country is a separate field from section, because a Singapore newsroom reporting on Indonesia produces an article whose subject and whose origin are different places. Media analysis that conflates them attributes regional coverage to the wrong market.
Access level is recorded, since subscription and open articles both appear and a corpus that mixes them without saying so produces word counts and text analysis that cannot be interpreted.
Entities mentioned are extracted where a client needs them, with the transliteration issue handled: names across Southeast Asian languages appear in several romanised forms and matching has to allow for that.
Every row carries the collection timestamp and a revision count where re-collection shows the article changed.