European Football Games

Most up to date football set 2004/2005 to 2018/2019

@kaggle.waterchiller_european_football_games

Table List

1 table(2.1 MB)

Data

@kaggle.waterchiller_european_football_games.data

2.1 MB
27350 rows
68 columns

away_coach Away Coach	away_goals Away Goals	away_name Away Name	away_player_0 Away Player 0	away_player_1 Away Player 1	away_player_10 Away Player 10	away_player_11 Away Player 11	away_player_12 Away Player 12	away_player_13 Away Player 13	away_player_2 Away Player 2	away_player_3 Away Player 3	away_player_4 Away Player 4	away_player_5 Away Player 5	away_player_6 Away Player 6	away_player_7 Away Player 7	away_player_8 Away Player 8	away_player_9 Away Player 9	date Date	gameday Gameday	home_coach Home Coach	home_goals Home Goals	home_name Home Name	home_player_0 Home Player 0	home_player_1 Home Player 1	home_player_10 Home Player 10	home_player_11 Home Player 11	home_player_12 Home Player 12	home_player_13 Home Player 13	home_player_14 Home Player 14	home_player_2 Home Player 2	home_player_3 Home Player 3	home_player_4 Home Player 4	home_player_5 Home Player 5	home_player_6 Home Player 6	home_player_7 Home Player 7	home_player_8 Home Player 8	home_player_9 Home Player 9	league League	location Location	referee Referee	season Season	stadium Stadium	time Time	visitor_count Visitor Count
Gregorio Manzano		FC Malaga	Juan Jesus Calatayud	Alexis	Alex Geijo	nan	nan	nan	Fernando Sanz	Vicente Valcarce	Miguel Angel	Sergio Duda	Juanito	Ivan Leko	Juan Rodriguez	Manu	28.08.2004	1	César Ferrando	2	Atletico Madrid	Leonardo Franco	Diego Simeone	Fernando Torres	nan	nan	nan	nan	Sergi	José Antonio García Calvo	Pablo	Luis Perea	Colsa	Ariel Ibagaza	Jorge	Kizito Musampa	Primera División	nan	Eduardo Ilturralde Gonzalez	2004/2005	nan	20:00	40000
Lorenzo Serra Ferrer	1	Real Betis	Antonio Prats	Melli	Ricardo Oliveira	nan	nan	nan	Marcos Assunçao	Paolo Castellini	Juanito	Daniel Alejandro Lembo	Fernando	Arturo Arzu	Joaquín	Lopez Ismael	28.08.2004	1	Francisco Lopez	1	CD Numancia	Alvaro Nunez	Patricio Graff	Toché	nan	nan	nan	nan	Jaime Molina	Juan Ochoa	Stephane Pignol	Jesus Enrique Velasco	Ros	Juanlu	César Palacios	Luis Tevenet	Primera División	nan	Lizondo Cortés	2004/2005	nan	20:00	9000
Javier Iruretagoyena	1	Deportivo La Coruna	Molina	Jorge Andrade	Victor	nan	nan	nan	César	Manuel Pablo	Enrique Romero	Mauro Da Silva	Sergio González Soriano	Juan Carlos Valeron	Albert Luque	Walter Pandiani	28.08.2004	1	Miguel Angel Lotina	1	Espanyol Barcelona	Idris Carlos Kameni	David Garcia de la Cruz	Raúl Tamudo	nan	nan	nan	nan	Daniel Jarque	Alberto Lopo	Mauricio Pochettino Trossero	Ito	Iván de la Peña	Dani	Maxi Rodríguez	Óscar Serrano	Primera División	nan	Amtonio Rubinos Perez	2004/2005	nan	22:00	34100
Enrique Sánchez Flores	1	FC Getafe	José Antonio	Mariano Pernia	Sergio Sanchez	nan	nan	nan	Manuel Tena	Nano	Mario Cotelo	Francisco Gallardo	Diego Rivas	Angel Manuel Vivar	Yordi	Valentín Pachón	29.08.2004	1	Victor Munoz	3	Real Saragossa	Luis Garcia	Luis Carlos Cuartero	Javier Moreno	nan	nan	nan	nan	Alvaro	Gabriel Milito	Delio César Toledo	Alberto Zapater	Luciano Galletti	José María Movilla	Savio	David Villa	Primera División	nan	Miguel Angel Perez Lasa	2004/2005	nan	19:30	33000
Bernd Schuster	1	Levante UD	Juan Luis Mora	José Antonio Culebras	Gustavo Enrique Reggi	nan	nan	nan	Ian Harte	Johan Mjällby	Pablo Pinillos	Diego Camacho	Felix Ettien	Nacho	Alberto Rivera	Ángel Manuel Cuellar	29.08.2004	1	José Mari Amorrortu	1	Real Sociedad	Asier Riesgo	Jérémie Bréchet	Kahveci Nihat	nan	nan	nan	nan	Javier Garrido	Igor Jauregui	Aitor Lopez Rekarte	Bittor Alkiza	Mikel Arteta	Igor Gabilondo	Valeri Karpin	Darko Kovacevic	Primera División	nan	Fernando Carmona Carmona Méndez	2004/2005	nan	19:30	23100
Jose Antonio Camacho	1	Real Madrid	Iker Casillas	Raul Bravo	Ronaldo	nan	nan	nan	Roberto Carlos	Iván Helguera	Francisco Pavon	Michel Salgado	David Beckham	Figo	Zidane Zinedine	Raúl	29.08.2004	1	Benito Floro		RCD Mallorca	Miquel Angel Moya	David Cortés	Luis Garcia	nan	nan	nan	nan	Poli	Nino	Patrick Müller	Alejandro Campano	Marcos Jr	Guillermo Pereyra	Marcos Vales	Juan Arango	Primera División	nan	Javier Turienzo Alvarez	2004/2005	nan	19:30	23000
Jose Gonzalez		Albacete Balompie	Raúl Valbuena	Miguel Buades	Francisco	nan	nan	nan	Rubén	Òscar Montiel Marin	Paco Peña	Mingo	Pablo Redondo	Alvaro Rubio	Laurent Viaud	Antonio Pacheco	29.08.2004	1	Joaquin Caparros	1	FC Sevilla	Esteban Suarez	Dani Alves	Dario Silva	nan	nan	nan	nan	David Castedo	Francisco Javier Navarro	Pablo Ruiz	Francisco Casquero	Josep Martí	Jesuli	Fernando Sales	Julio Baptista	Primera División	nan	Evaristo Puentes Leira	2004/2005	nan	19:30	41000
Ernesto Valverde	1	Athletic Bilbao	Daniel Aranzubia	Pablo Orbaiz	Santiago Ezquerro	nan	nan	nan	Luis Prieto	Jonan	Carlos Gurpegui	Asier del Horno	Andoni Iraola	Tiko	Yeste	Joseba Etxeberria	29.08.2004	1	Javier Aguirre	1	CA Osasuna	Ricardo Sanzol	Enrique Corrales	Pierre Webo	nan	nan	nan	nan	César Cruchaga	José Izquierdo	Josetxo	Pablo Garcia	Yacoubi Moha	Juan Ortiz	Francisco Puñal	Savo Milosevic	Primera División	nan	nan	2004/2005	nan	19:30
Frank Rijkaard	2	FC Barcelona	Victor Valdés	Juliano Belletti	Henrik Larsson	nan	nan	nan	Rafael Marquez	Carles Puyol	Giovanni van Bronckhorst	Ludovic Giuly	Xavi	Thiago Motta	Deco	Samuel Eto'o	29.08.2004	1	Luis Lucas Alcaraz		Racing Santander	Dudu Aouate	Christian Alvarez	Mario Regueiro	nan	nan	nan	nan	Pablo Casar	Ayoze Diaz	Mora	Yossi Benayoun	Diego Mateo	Mehdi Nafti	Anderson	Javi Guerrero	Primera División	nan	Alberto Undiano Mallenco	2004/2005	nan	21:30	17600
Manuel Pellegrini	1	FC Villarreal	Pepe Reina	Quique Alvarez	Diego Forlán	nan	nan	nan	Armando Sa	Gonzalo Rodriguez	Javier Venta	Santi Cazorla	Josico	Juan Roman Riquelme	Marcos Senna	Sonny Anderson da Silva	30.08.2004	1	Claudio Ranieri	2	FC Valencia	José Santiago Canizares	Amedeo Carboni	Mista	nan	nan	nan	nan	Carlos Marchena	David Navarro	Cristóbal Torres	David Albelda	Ruben Baraja	Vicente	Francisco Rufete	Marco Di Vaio	Primera División	nan	Rafael Ramirez Dominguez	2004/2005	nan	21:00	42000


CREATE TABLE data (
  "away_blocked_by_goalkeeper" DOUBLE,
  "away_coach" VARCHAR,
  "away_corners" DOUBLE,
  "away_fouls" DOUBLE,
  "away_freekicks" DOUBLE,
  "away_goals" DOUBLE,
  "away_name" VARCHAR,
  "away_offside" DOUBLE,
  "away_passes_quote" DOUBLE,
  "away_player_0" VARCHAR,
  "away_player_1" VARCHAR,
  "away_player_10" VARCHAR,
  "away_player_11" VARCHAR,
  "away_player_12" VARCHAR,
  "away_player_13" VARCHAR,
  "away_player_2" VARCHAR,
  "away_player_3" VARCHAR,
  "away_player_4" VARCHAR,
  "away_player_5" VARCHAR,
  "away_player_6" VARCHAR,
  "away_player_7" VARCHAR,
  "away_player_8" VARCHAR,
  "away_player_9" VARCHAR,
  "away_possession" DOUBLE,
  "away_red_cards" DOUBLE,
  "away_shots_missing_target" DOUBLE,
  "away_shots_on_target" DOUBLE,
  "away_tackles_won" DOUBLE,
  "away_yellow_cards" DOUBLE,
  "date" VARCHAR,
  "gameday" DOUBLE,
  "home_blocked_by_goalkeeper" DOUBLE,
  "home_coach" VARCHAR,
  "home_corners" DOUBLE,
  "home_fouls" DOUBLE,
  "home_freekicks" DOUBLE,
  "home_goals" DOUBLE,
  "home_name" VARCHAR,
  "home_offside" DOUBLE,
  "home_passes_quote" DOUBLE,
  "home_player_0" VARCHAR,
  "home_player_1" VARCHAR,
  "home_player_10" VARCHAR,
  "home_player_11" VARCHAR,
  "home_player_12" VARCHAR,
  "home_player_13" VARCHAR,
  "home_player_14" VARCHAR,
  "home_player_2" VARCHAR,
  "home_player_3" VARCHAR,
  "home_player_4" VARCHAR,
  "home_player_5" VARCHAR,
  "home_player_6" VARCHAR,
  "home_player_7" VARCHAR,
  "home_player_8" VARCHAR,
  "home_player_9" VARCHAR,
  "home_possession" DOUBLE,
  "home_red_cards" DOUBLE,
  "home_shots_missing_target" DOUBLE,
  "home_shots_on_target" DOUBLE,
  "home_tackles_won" DOUBLE,
  "home_yellow_cards" DOUBLE,
  "league" VARCHAR,
  "location" VARCHAR,
  "referee" VARCHAR,
  "season" VARCHAR,
  "stadium" VARCHAR,
  "time" VARCHAR,
  "visitor_count" DOUBLE
);