match
408 rows where home_team_id = 381 sorted by date descending
This data as json, CSV (advanced)
Suggested facets: season_id, home_score, away_score, result, created_at, updated_at, created_by_run_id, updated_by_run_id, source_id, date (date), created_at (date), updated_at (date)
| match_id | season_id | date ▲ | kickoff | home_team_id | away_team_id | home_score | away_score | result | round_stage | matchday | venue | city | country | referee | attendance | is_neutral | is_postponed | is_cancelled | created_at | updated_at | created_by_run_id | updated_by_run_id | source_id | source_raw_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60912 | 2023-2024 1939 | 2024-05-15 | OGC Nice 381 | Paris Saint-Germain 337 | 1 | 2 | A | 32 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Paris SG:15/05/2024 | ||||||
| 60904 | 2023-2024 1939 | 2024-05-10 | OGC Nice 381 | Le Havre AC 390 | 1 | 0 | H | 33 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Le Havre:10/05/2024 | ||||||
| 60875 | 2023-2024 1939 | 2024-04-19 | OGC Nice 381 | Lorient 369 | 3 | 0 | H | 30 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Lorient:19/04/2024 | ||||||
| 60857 | 2023-2024 1939 | 2024-03-31 | OGC Nice 381 | FC Nantes 388 | 1 | 2 | A | 27 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Nantes:31/03/2024 | ||||||
| 60833 | 2023-2024 1939 | 2024-03-08 | OGC Nice 381 | Montpellier HSC 382 | 1 | 2 | A | 25 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Montpellier:08/03/2024 | ||||||
| 60820 | 2023-2024 1939 | 2024-02-25 | OGC Nice 381 | Clermont Foot 379 | 0 | 0 | D | 23 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Clermont:25/02/2024 | ||||||
| 60805 | 2023-2024 1939 | 2024-02-11 | OGC Nice 381 | AS Monaco 387 | 2 | 3 | A | 21 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Monaco:11/02/2024 | ||||||
| 60780 | 2023-2024 1939 | 2024-01-27 | OGC Nice 381 | Metz 376 | 1 | 0 | H | 19 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Metz:27/01/2024 | ||||||
| 60765 | 2023-2024 1939 | 2023-12-20 | OGC Nice 381 | Lens 371 | 2 | 0 | H | 17 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Lens:20/12/2023 | ||||||
| 60746 | 2023-2024 1939 | 2023-12-10 | OGC Nice 381 | Stade de Reims 384 | 2 | 1 | H | 15 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Reims:10/12/2023 | ||||||
| 60725 | 2023-2024 1939 | 2023-11-26 | OGC Nice 381 | Toulouse FC 389 | 1 | 0 | H | 12 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Toulouse:26/11/2023 | ||||||
| 60713 | 2023-2024 1939 | 2023-11-05 | OGC Nice 381 | Stade Rennais FC 391 | 2 | 0 | H | 11 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Rennes:05/11/2023 | ||||||
| 60690 | 2023-2024 1939 | 2023-10-21 | OGC Nice 381 | Olympique de Marseille 342 | 1 | 0 | H | 9 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Marseille:21/10/2023 | ||||||
| 60676 | 2023-2024 1939 | 2023-10-01 | OGC Nice 381 | Stade Brestois 29 386 | 0 | 0 | D | 7 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Brest:01/10/2023 | ||||||
| 60651 | 2023-2024 1939 | 2023-09-03 | OGC Nice 381 | RC Strasbourg Alsace 393 | 2 | 0 | H | 4 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Strasbourg:03/09/2023 | ||||||
| 60643 | 2023-2024 1939 | 2023-08-27 | OGC Nice 381 | Olympique Lyonnais 343 | 0 | 0 | D | 3 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Lyon:27/08/2023 | ||||||
| 60617 | 2023-2024 1939 | 2023-08-11 | OGC Nice 381 | Lille OSC 344 | 1 | 1 | D | 1 | France | 0 | 0 | 0 | 2026-06-09 10:00:00 | 2026-06-09 10:00:00 | 999 999 | 999 999 | International Results CSV 1 | csv:///FRA2324:Nice:Lille:11/08/2023 | ||||||
| 54242 | 2022-2023 1965 | 2023-05-21 | OGC Nice 381 | Toulouse FC 389 | 0 | 0 | D | 36 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54217 | 2022-2023 1965 | 2023-05-06 | OGC Nice 381 | Stade Rennais FC 391 | 2 | 1 | H | 34 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54263 | 2022-2023 1965 | 2023-04-24 | OGC Nice 381 | Olympique Lyonnais 343 | 3 | 1 | H | 38 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54204 | 2022-2023 1965 | 2023-04-23 | OGC Nice 381 | Clermont Foot 379 | 1 | 2 | A | 32 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54179 | 2022-2023 1965 | 2023-04-08 | OGC Nice 381 | Paris Saint-Germain 337 | 0 | 2 | A | 30 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54163 | 2022-2023 1965 | 2023-03-19 | OGC Nice 381 | Lorient 369 | 1 | 1 | D | 28 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54137 | 2022-2023 1965 | 2023-03-03 | OGC Nice 381 | Auxerre 397 | 1 | 1 | D | 26 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54118 | 2022-2023 1965 | 2023-02-18 | OGC Nice 381 | Stade de Reims 384 | 0 | 0 | D | 24 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54107 | 2022-2023 1965 | 2023-02-10 | OGC Nice 381 | Ajaccio 410 | 3 | 0 | H | 23 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54080 | 2022-2023 1965 | 2023-01-29 | OGC Nice 381 | Lille OSC 344 | 1 | 0 | H | 20 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54045 | 2022-2023 1965 | 2022-12-29 | OGC Nice 381 | Lens 371 | 0 | 0 | D | 16 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54064 | 2022-2023 1965 | 2022-12-05 | OGC Nice 381 | Montpellier HSC 382 | 6 | 1 | H | 18 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54022 | 2022-2023 1965 | 2022-11-06 | OGC Nice 381 | Stade Brestois 29 386 | 1 | 0 | H | 14 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 54005 | 2022-2023 1965 | 2022-10-23 | OGC Nice 381 | FC Nantes 388 | 1 | 1 | D | 12 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 53983 | 2022-2023 1965 | 2022-10-09 | OGC Nice 381 | Troyes 406 | 3 | 2 | H | 10 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 53962 | 2022-2023 1965 | 2022-09-18 | OGC Nice 381 | Angers 420 | 0 | 1 | A | 8 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 53946 | 2022-2023 1965 | 2022-09-04 | OGC Nice 381 | AS Monaco 387 | 0 | 1 | A | 6 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 53923 | 2022-2023 1965 | 2022-08-28 | OGC Nice 381 | Olympique de Marseille 342 | 0 | 3 | A | 4 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 53904 | 2022-2023 1965 | 2022-08-14 | OGC Nice 381 | RC Strasbourg Alsace 393 | 1 | 1 | D | 2 | 0 | 0 | 0 | 2026-06-08T23:19:53.453559 | 2026-06-08T23:19:53.453559 | RSSSF Historical Results 8 | ||||||||||
| 62428 | 2021-2022 1964 | 2022-05-14 | OGC Nice 381 | Lille OSC 344 | 1 | 3 | A | 37 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62421 | 2021-2022 1964 | 2022-05-11 | OGC Nice 381 | AS Saint-Étienne 396 | 4 | 2 | H | 36 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62400 | 2021-2022 1964 | 2022-04-24 | OGC Nice 381 | Troyes 406 | 1 | 0 | H | 34 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62376 | 2021-2022 1964 | 2022-04-17 | OGC Nice 381 | Lorient 369 | 2 | 1 | H | 32 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62353 | 2021-2022 1964 | 2022-04-02 | OGC Nice 381 | Stade Rennais FC 391 | 1 | 1 | D | 30 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62325 | 2021-2022 1964 | 2022-03-05 | OGC Nice 381 | Paris Saint-Germain 337 | 1 | 0 | H | 27 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62306 | 2021-2022 1964 | 2022-02-20 | OGC Nice 381 | Angers 420 | 1 | 0 | H | 25 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62287 | 2021-2022 1964 | 2022-02-06 | OGC Nice 381 | Clermont Foot 379 | 0 | 1 | A | 23 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62258 | 2021-2022 1964 | 2022-01-14 | OGC Nice 381 | FC Nantes 388 | 2 | 1 | H | 21 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62248 | 2021-2022 1964 | 2021-12-22 | OGC Nice 381 | Lens 371 | 2 | 1 | H | 19 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62230 | 2021-2022 1964 | 2021-12-05 | OGC Nice 381 | RC Strasbourg Alsace 393 | 0 | 3 | A | 17 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62204 | 2021-2022 1964 | 2021-11-27 | OGC Nice 381 | Metz 376 | 0 | 1 | A | 15 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62191 | 2021-2022 1964 | 2021-11-07 | OGC Nice 381 | Montpellier HSC 382 | 0 | 1 | A | 12 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62172 | 2021-2022 1964 | 2021-10-27 | OGC Nice 381 | Olympique de Marseille 342 | 1 | 1 | D | 3 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62165 | 2021-2022 1964 | 2021-10-24 | OGC Nice 381 | Olympique Lyonnais 343 | 3 | 2 | H | 11 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62144 | 2021-2022 1964 | 2021-10-02 | OGC Nice 381 | Stade Brestois 29 386 | 2 | 1 | H | 9 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62115 | 2021-2022 1964 | 2021-09-19 | OGC Nice 381 | AS Monaco 387 | 2 | 2 | D | 6 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62093 | 2021-2022 1964 | 2021-08-28 | OGC Nice 381 | FC Girondins de Bordeaux 404 | 4 | 0 | H | 4 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 62068 | 2021-2022 1964 | 2021-08-08 | OGC Nice 381 | Stade de Reims 384 | 0 | 0 | D | 1 | 0 | 0 | 0 | 2026-06-09 10:03:27 | 2026-06-09 10:03:27 | 1 1 | 1 1 | FBref 2 | ||||||||
| 55093 | 2020-2021 1963 | 2021-05-01 | OGC Nice 381 | RC Strasbourg Alsace 393 | 0 | 2 | A | 37 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 55084 | 2020-2021 1963 | 2021-04-24 | OGC Nice 381 | Stade Brestois 29 386 | 3 | 2 | H | 36 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 55067 | 2020-2021 1963 | 2021-04-10 | OGC Nice 381 | Montpellier HSC 382 | 3 | 1 | H | 34 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 55054 | 2020-2021 1963 | 2021-03-27 | OGC Nice 381 | Stade de Reims 384 | 0 | 0 | D | 32 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 55034 | 2020-2021 1963 | 2021-03-13 | OGC Nice 381 | Olympique de Marseille 342 | 3 | 0 | H | 30 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 55004 | 2020-2021 1963 | 2021-02-13 | OGC Nice 381 | Metz 376 | 1 | 2 | A | 26 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54988 | 2020-2021 1963 | 2021-01-30 | OGC Nice 381 | Angers 420 | 3 | 0 | H | 24 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54969 | 2020-2021 1963 | 2021-01-16 | OGC Nice 381 | AS Saint-Étienne 396 | 0 | 1 | A | 22 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54956 | 2020-2021 1963 | 2021-01-02 | OGC Nice 381 | Girondins Bordeaux 476 | 0 | 3 | A | 20 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54927 | 2020-2021 1963 | 2020-12-12 | OGC Nice 381 | Lorient 369 | 2 | 2 | D | 17 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54920 | 2020-2021 1963 | 2020-12-05 | OGC Nice 381 | Olympique Lyonnais 343 | 1 | 4 | A | 16 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54905 | 2020-2021 1963 | 2020-11-21 | OGC Nice 381 | Stade Rennais FC 391 | 0 | 1 | A | 14 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54876 | 2020-2021 1963 | 2020-10-24 | OGC Nice 381 | AS Monaco 387 | 1 | 2 | A | 10 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54859 | 2020-2021 1963 | 2020-10-10 | OGC Nice 381 | Lille OSC 344 | 1 | 1 | D | 8 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54840 | 2020-2021 1963 | 2020-09-26 | OGC Nice 381 | FC Nantes 388 | 2 | 1 | H | 6 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54824 | 2020-2021 1963 | 2020-09-12 | OGC Nice 381 | Paris Saint-Germain 337 | 0 | 3 | A | 4 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54802 | 2020-2021 1963 | 2020-08-22 | OGC Nice 381 | Lens 371 | 2 | 1 | H | 1 | France | 0 | 0 | 0 | 2026-06-08 22:45:40 | 2026-06-08 22:45:40 | ||||||||||
| 54793 | 2019-2020 1962 | 2020-02-15 | OGC Nice 381 | AS Monaco 387 | 2 | 1 | H | 28 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54775 | 2019-2020 1962 | 2020-02-01 | OGC Nice 381 | Stade Brestois 29 386 | 2 | 2 | D | 26 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54762 | 2019-2020 1962 | 2020-01-18 | OGC Nice 381 | Nimes 523 | 1 | 3 | A | 24 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54748 | 2019-2020 1962 | 2020-01-04 | OGC Nice 381 | Olympique Lyonnais 343 | 2 | 1 | H | 22 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54734 | 2019-2020 1962 | 2019-12-28 | OGC Nice 381 | Stade Rennais FC 391 | 1 | 1 | D | 21 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54706 | 2019-2020 1962 | 2019-11-30 | OGC Nice 381 | Metz 376 | 4 | 1 | H | 17 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54688 | 2019-2020 1962 | 2019-11-16 | OGC Nice 381 | Angers 420 | 3 | 1 | H | 15 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54670 | 2019-2020 1962 | 2019-11-02 | OGC Nice 381 | Girondins Bordeaux 476 | 1 | 1 | D | 13 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54667 | 2019-2020 1962 | 2019-10-26 | OGC Nice 381 | Stade de Reims 384 | 2 | 0 | H | 12 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54646 | 2019-2020 1962 | 2019-10-12 | OGC Nice 381 | Paris Saint-Germain 337 | 1 | 4 | A | 10 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54633 | 2019-2020 1962 | 2019-09-28 | OGC Nice 381 | Lille OSC 344 | 1 | 1 | D | 8 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54617 | 2019-2020 1962 | 2019-09-14 | OGC Nice 381 | Dijon 413 | 2 | 1 | H | 6 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 54596 | 2019-2020 1962 | 2019-08-24 | OGC Nice 381 | Olympique de Marseille 342 | 1 | 2 | A | 3 | France | 0 | 0 | 0 | 2026-06-08 22:45:36 | 2026-06-08 22:45:36 | ||||||||||
| 60613 | 2018-2019 1961 | 2019-05-24 | OGC Nice 381 | AS Monaco 387 | 2 | 0 | H | 38 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60592 | 2018-2019 1961 | 2019-05-11 | OGC Nice 381 | FC Nantes 388 | 1 | 1 | D | 36 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60573 | 2018-2019 1961 | 2019-04-28 | OGC Nice 381 | EA Guingamp 419 | 3 | 0 | H | 34 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60560 | 2018-2019 1961 | 2019-04-20 | OGC Nice 381 | Caen 417 | 0 | 1 | A | 33 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60541 | 2018-2019 1961 | 2019-04-07 | OGC Nice 381 | Montpellier HSC 382 | 1 | 0 | H | 31 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60516 | 2018-2019 1961 | 2019-03-15 | OGC Nice 381 | Toulouse 373 | 1 | 1 | D | 29 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60503 | 2018-2019 1961 | 2019-03-03 | OGC Nice 381 | RC Strasbourg Alsace 393 | 1 | 0 | H | 27 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60469 | 2018-2019 1961 | 2019-02-10 | OGC Nice 381 | Olympique Lyonnais 343 | 1 | 0 | H | 24 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60447 | 2018-2019 1961 | 2019-01-26 | OGC Nice 381 | Nimes 523 | 2 | 0 | H | 22 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60422 | 2018-2019 1961 | 2019-01-12 | OGC Nice 381 | FC Girondins de Bordeaux 404 | 1 | 0 | H | 20 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60403 | 2018-2019 1961 | 2018-12-16 | OGC Nice 381 | AS Saint-Étienne 396 | 1 | 1 | D | 18 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60389 | 2018-2019 1961 | 2018-12-04 | OGC Nice 381 | Angers 420 | 0 | 0 | D | 16 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60376 | 2018-2019 1961 | 2018-11-25 | OGC Nice 381 | Lille OSC 344 | 2 | 0 | H | 14 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60351 | 2018-2019 1961 | 2018-11-03 | OGC Nice 381 | Amiens 409 | 1 | 0 | H | 12 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 | ||||||||||
| 60335 | 2018-2019 1961 | 2018-10-21 | OGC Nice 381 | Olympique de Marseille 342 | 0 | 1 | A | 10 | France | 0 | 0 | 0 | 2026-06-09 08:11:43 | 2026-06-09 08:11:43 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE match (
match_id INTEGER NOT NULL,
season_id INTEGER NOT NULL,
date DATE NOT NULL,
kickoff DATETIME,
home_team_id INTEGER NOT NULL,
away_team_id INTEGER NOT NULL,
home_score INTEGER,
away_score INTEGER,
result VARCHAR(1),
round_stage VARCHAR(64),
matchday INTEGER,
venue VARCHAR(256),
city VARCHAR(128),
country VARCHAR(128),
referee VARCHAR(128),
attendance INTEGER,
is_neutral BOOLEAN NOT NULL,
is_postponed BOOLEAN NOT NULL,
is_cancelled BOOLEAN NOT NULL,
created_at DATETIME NOT NULL,
updated_at DATETIME NOT NULL,
created_by_run_id INTEGER,
updated_by_run_id INTEGER,
source_id INTEGER,
source_raw_key VARCHAR(512),
CONSTRAINT pk_match PRIMARY KEY (match_id),
CONSTRAINT fk_match_season FOREIGN KEY(season_id) REFERENCES season (season_id),
CONSTRAINT fk_match_home_team FOREIGN KEY(home_team_id) REFERENCES team (team_id),
CONSTRAINT fk_match_away_team FOREIGN KEY(away_team_id) REFERENCES team (team_id),
CONSTRAINT fk_match_source FOREIGN KEY(source_id) REFERENCES data_source (source_id),
CONSTRAINT fk_match_created_by_run FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id),
CONSTRAINT fk_match_updated_by_run FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id)
);
CREATE INDEX ix_match_away_team_id ON match (away_team_id);
CREATE INDEX ix_match_created_by_run_id ON match (created_by_run_id);
CREATE INDEX ix_match_source_id ON match (source_id);
CREATE INDEX ix_match_updated_by_run_id ON match (updated_by_run_id);
CREATE INDEX ix_match_date ON match (date);
CREATE INDEX ix_match_season_id ON match (season_id);
CREATE INDEX ix_match_source_raw_key ON match (source_raw_key);
CREATE INDEX ix_match_home_team_id ON match (home_team_id);
CREATE UNIQUE INDEX ux_match_season_date_teams ON match(season_id, date, home_team_id, away_team_id);