Wide format stores one row per entity and places the entity’s measurements or attributes in columns. Adding measurements therefore makes the table wider. Choosing between wide and long formats is a data-modeling decision shaped by the questions the data must answer. section 3.1.1
Football results
A football-results table is wide when each row represents a match and columns hold the date, competition, teams, and goals. Adding a Winner column supports questions such as which country won the most World Cup games. Counting participation is harder because each match contains both Home team and Away team fields; a long-format version uses one row per participant instead. section 3.1.1
