Times of India fields in every export
The article record covers canonical URL, headline, summary, section and subsection, city edition where applicable, byline, publication timestamp, last updated timestamp, item type and the article identifier.
The city edition field is the one that makes an Indian market analysis honest. Without it a story in one city edition reads as national coverage, which overstates reach, and national coverage of a local issue reads as local, which understates it. Every row carries the edition it was collected from.
Both timestamps are kept separately, as everywhere, and matter here because the site updates stories in place through the day.
Front observations run on the national front and on whichever city fronts a client cares about, recording which stories appeared, in what order and when. Given the volume, promotion is a far better proxy for reach than a count.
Then the context fields: topic tags where published, publicly rendered body text and word count, lead image URL, outbound links, and the collection timestamp on every row.