Baselight

Football Data From Transfermarkt

Football (Soccer) data scraped from Transfermarkt website

@kaggle.davidcariboo_player_scores

Appearances
@kaggle.davidcariboo_player_scores.appearances

  • 25.36 MB
  • 1669732 rows
  • 13 columns
appearance_id

Appearance Id

game_id

Game Id

player_id

Player Id

player_club_id

Player Club Id

player_current_club_id

Player Current Club Id

date

Date

player_name

Player Name

competition_id

Competition Id

yellow_cards

Yellow Cards

red_cards

Red Cards

goals

Goals

assists

Assists

minutes_played

Minutes Played

2231978_38004223197838004853235Tue Jul 03 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Aurélien JoachimCLQ290
2233748_7923222337487923288412698Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Ruslan AbyshovELQ90
2234413_427922234413427926251465Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Sander PuriELQ45
2234418_7333322344187333312746646Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Vegar HedenstadELQ90
2234421_12201122344211220111953008Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Markus HenriksenELQ190
2234421_14688922344211468891952778Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Peter AnkersenELQ190
2235539_287162235539287162827185Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Adi AdilovicELQ90
2235539_6944522355396944528219771Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Ivan SesarELQ1190
2235545_19409223554519409317200Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Willem JanssenELQ45
2235545_30003223554530003317317Thu Jul 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)Wout BramaELQ90

CREATE TABLE appearances (
  "appearance_id" VARCHAR,
  "game_id" BIGINT,
  "player_id" BIGINT,
  "player_club_id" BIGINT,
  "player_current_club_id" BIGINT,
  "date" TIMESTAMP,
  "player_name" VARCHAR,
  "competition_id" VARCHAR,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "goals" BIGINT,
  "assists" BIGINT,
  "minutes_played" BIGINT
);

Share link

Anyone who has the link will be able to view this.