Flashscore fields in every export
The fixture record covers sport, competition and stage, season, match identifier, home and away team, scheduled kickoff in both local time and UTC, venue where published, and match status.
Live state is delivered as its own timestamped rows rather than overwriting the fixture: current score, half time score, elapsed minute, and the event stream of goals with scorer and assist where published, cards, substitutions and penalties. Keeping the stream means a client can reconstruct the state of a match at any point rather than only its ending.
Lineups are collected where the source publishes them: starting eleven with positions and shirt numbers, substitutes, and formation. Lineup publication timing is itself informative, since teams are usually confirmed about an hour before kickoff and that is when a great deal of downstream activity happens.
Match statistics are captured as published per competition, which varies: possession, shots, shots on target, corners, fouls and the more advanced measures where a competition supplies them. We record what exists rather than filling gaps with estimates, and the absence of a metric is recorded as absence.
Every row carries the collection timestamp and the source competition, and time zones are stored explicitly, because a kickoff time without a zone is the single most common cause of a fixture dataset being an hour wrong twice a year.