TechCrunch fields in every export
The post record covers post identifier, canonical URL, headline, subheading or excerpt, publication timestamp, modification timestamp, slug, and post type so that sponsored and event posts are separable from editorial ones.
Author and taxonomy fields arrive resolved. Author identifiers are looked up to names and profile URLs, category and tag identifiers to their labels, so what lands in your table is TechCrunch Startups and a named reporter rather than a pair of integers. This is dull work and it is exactly the part that clients arrive having given up on.
Body text is delivered clean: the rendered HTML stripped of newsletter blocks, embed wrappers and promotional inserts, with word count and reading structure preserved. Outbound links are kept as a separate list, which is what makes the funding use case work at all, since a round announcement almost always links to the company and often to the investor.
Front and category observations sit alongside, recording which posts were featured, in what order and when. On a site with this much volume the difference between a featured post and one that appeared only in the firehose is most of the signal.
Where a post is about funding we extract the entity mentions that are actually present in the text: company names, investor names, round labels and amounts as written. We do not infer a round that the article does not state, and every extracted value keeps a pointer to the sentence it came from.