4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Derby County

Derby County

Entrenador: Paul Warne

Información
Otros Datos
  • Año de Fundación 1884
  • Presupuesto 14000000
  • Patrocinador 32Red
  • Marca de Ropa Umbro
  • Socios 14000
Internet

Información sobre el estadio

  • Nombre del estadio iPro Stadium
  • Capacidad 33597
  • Dirección Pride Park, Royal Way
  • Teléfono +44 (870) 444 1884
  • Fax +44 (1332) 667 540
  • Año de construcción 1997
  • Tamaño 104x64
iPro Stadium

Histórico de participación

FA Cup
Premier League
Championship
EFL Cup
Partidos Amistosos
14 veces
Championship - Play Offs Ascenso
5 veces
EFL Trophy
3 veces
(2024, 2024, 2023)
Champions League
2 veces
(1976, 1973)
League One
2 veces
(2024, 2023)
Europa League
2 veces
(1977, 1975)
Community Shield
1 vez
(1976)
Trofeo Colombino
1 vez
(1974)
Trofeo Costa del Sol
1 vez
(1975)

Partidos del Derby County

Ir al LIVESCORE
08 Ene 22  Finalizado Coventry City
1 - 0
Derby County 35
24 Ago 21  Finalizado Sheffield United
2 - 1
Derby County 29
10 Ago 21  Finalizado Derby County
3 - 3
Salford City 17
07 May 22  Finalizado Derby County
0 - 1
Cardiff City 7
30 Abr 22  Finalizado Blackpool
0 - 2
Derby County 21
23 Abr 22  Finalizado Derby County
1 - 3
Bristol City 8
18 Abr 22  Finalizado Queens Park Rangers
1 - 0
Derby CountyTarjeta Roja 87
15 Abr 22  Finalizado Derby County
2 - 1
Fulham 93
09 Abr 22  Finalizado Swansea City
2 - 1
Derby County 3
02 Abr 22  Finalizado Tarjeta RojaDerby County
1 - 0
Preston North EndTarjeta Roja 12
19 Mar 22  Finalizado Derby County
1 - 1
Coventry City 19
15 Mar 22  Finalizado Blackburn Rovers
3 - 1
Derby County 92
12 Mar 22  Finalizado AFC Bournemouth
2 - 0
Derby County 33
05 Mar 22  Finalizado Derby County
2 - 0
Barnsley 14
01 Mar 22  Finalizado Cardiff City
1 - 0
Derby County 52
26 Feb 22  Finalizado Luton Town
1 - 0
Derby County 15
23 Feb 22  Finalizado Derby County
1 - 2
Millwall 51
19 Feb 22  Finalizado Tarjeta RojaDerby County
1 - 0
Peterborough UnitedTarjeta Roja 34
12 Feb 22  Finalizado Middlesbrough
4 - 1
Derby County 26
08 Feb 22  Finalizado Derby County
3 - 1
Hull City 60
02 Feb 22  Finalizado Huddersfield Town
2 - 0
Derby CountyTarjeta Roja 141
30 Ene 22  Finalizado Derby County
2 - 2
Birmingham City 103
22 Ene 22  Finalizado Nottingham Forest
2 - 1
Derby CountyTarjeta Roja 40
15 Ene 22  Finalizado Derby County
2 - 0
Sheffield United 27
03 Ene 22  Finalizado Reading
2 - 2
Derby County 131
30 Dic 21  Finalizado Stoke City
1 - 2
Derby County 398
27 Dic 21  Finalizado Derby County
1 - 0
West Bromwich Albion 295
11 Dic 21  Finalizado Derby County
1 - 0
Blackpool 6
04 Dic 21  Finalizado Bristol City
1 - 0
Derby County 3
29 Nov 21  Finalizado Derby County
1 - 2
Queens Park Rangers 123
24 Nov 21  Finalizado Fulham
0 - 0
Derby County 187
21 Nov 21  Finalizado Derby County
3 - 2
AFC Bournemouth 43
06 Nov 21  Finalizado Millwall
1 - 1
Derby CountyTarjeta Roja 8
03 Nov 21  Finalizado Barnsley
2 - 1
Derby County 9
30 Oct 21  Finalizado Derby County
1 - 2
Blackburn Rovers 11
23 Oct 21  Finalizado Coventry City
1 - 1
Derby County 5
19 Oct 21  Finalizado Derby County
2 - 2
Luton Town 5
16 Oct 21  Finalizado Preston North End
0 - 0
Derby County 7
02 Oct 21  Finalizado Derby County
0 - 0
Swansea City 3
29 Sep 21  Finalizado Derby County
1 - 0
Reading 25
25 Sep 21  Finalizado Sheffield United
1 - 0
Derby CountyTarjeta Roja 23
18 Sep 21  Finalizado Derby County
2 - 1
Stoke City 9
14 Sep 21  Finalizado West Bromwich Albion
0 - 0
Derby County 61
10 Sep 21  Finalizado Birmingham City
2 - 0
Derby County 64
28 Ago 21  Finalizado Derby County
1 - 1
Nottingham Forest 10
21 Ago 21  Finalizado Derby County
0 - 0
Middlesbrough 10
18 Ago 21  Finalizado Hull City
0 - 1
Derby County 114
14 Ago 21  Finalizado Peterborough United
2 - 1
Derby County 29
07 Ago 21  Finalizado Derby County
1 - 1
Huddersfield Town 10
01 Ago 21  Finalizado Notts County
0 - 2
Derby County 1
28 Jul 21  Finalizado Derby County
1 - 0
Real Betis 59
24 Jul 21  Finalizado Salford City
2 - 1
Derby County 0
18 Jul 21  Finalizado Derby County
1 - 2
Manchester United 51

Plantilla del Derby County Temporada 2021/2022

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
21 31 nl 196 90 - 1 1
31 31 gb 189 79 - - 3
Defensa
33 39 sl 188 76 4 - 9
3 35 ss 189 83 3 - 3
41 22 ie 184 72 1 - 2
36 21 ie 180 64 2 - 4
26 23 gb 179 67 - - 4
2 31 gb 180 73 - 1 13
16 36 gb 191 73 - 1 3
Centrocampista
38 23 ie 173 63 2 - 2
5 26 pl 192 78 1 - 1
17 22 gb 183 74 1 - 5
42 21 gb 173 62 - - 4
35 22 ie 177 66 - - 1
8 23 gb 183 68 2 1 2
11 31 jm 175 71 4 1 9
Delantero
13 37 tr 185 68 3 - 1
46 18 gi 173 - - - -
34 22 ss 183 69 1 - 1
48 21 gb 188 76 4 - 1
32 20 gb 185 80 1 - 2
10 30 wa 175 69 11 2 11

Noticias del Derby County

Ver últimas noticias

El Derby County accede a dejar a Rawson cedido en el Rotherham hasta fin de temporada

Farrend Rawson terminará la temporada defendiendo la camiseta del Rotherham United, tras prolongar su cesión por parte del Derby County.

El Derby County pesca a un ex del Mallorca

El equipo inglés está cuajando una gran temporada y los últimos resultados también decantan la balanza a favor. Con el mercado de fichajes abierto, las nuevas incorporaciones son constantes y, esta vez, el Derby County ficha a un ex de la Liga española.

Precioso duelo entre los segundos de Mou y Ancelotti por el título

Los entrenadores asistentes elegidos en su día por José Mourinho y Carlo Ancelotti luchan por el título del Championship inglés, equivalente a la Segunda División Española.

Tom Ince dijo no al Inter para triunfar en la Premier

El jugador del Derby County Tom Ince tuvo la posibilidad de fichar por el Inter de Milán. El futbolista llegó a sentarse a negociar con los dirigentes del club, sin embargo, desestimó la oferta para seguir en el fútbol inglés.

Areola libra al Villarreal de caer vencido frente al Derby County

Una buena actuación del portero Alphonse Aerola en la segunda parte, salvó al Villarreal de perder frente al Derby County en partido amistoso disputado en el Ipro Stadium de Derby (Reino Unido).




  USO DE MEMORIA  
6,482,328 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0029
Controller Execution Time ( Home / Category )  0.1730
Total Execution Time  0.1760
  CADENA URL  
/Derby-County-Fc/2022
  GET DATOS  
$_GET['/Derby-County-Fc/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (23)  
0.0045  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '916' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2022 as c ON c.league_id = l.id WHERE (c.datateam1 = 916 or c.datateam2 = 916) AND l.year = 2022 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0032  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2022 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 916 or c.datateam2 = 916) AND l.year = 2022 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0026  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2022 as c ON c.league_id = l.id INNER JOIN events2022 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 916 or c.datateam2 = 916) AND l.year = 2022)
0.0034  SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=916 AND l.year in (2021,2022,2023) ORDER BY l.id DESC, l.year DESC ;
0.0021  SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (68393,68334,68038,68031,67320,62730) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 62730 AND teamId = 916
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 68031 AND teamId = 916
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 68334 AND teamId = 916
0.0033  SELECT count(id) as num_players from rel_players WHERE league_id = 68038 AND teamId = 916
0.0032  SELECT count(id) as num_players from rel_players WHERE league_id = 68393 AND teamId = 916
0.0225  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 916
0.0049  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 62730 WHERE rp.league_id = 62730 AND rp.teamId = 916 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0039  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 62730 WHERE rp.league_id = 62730 AND rp.teamId = 916 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 62730 WHERE rp.league_id = 62730 AND rp.teamId = 916 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 916 AND rp.league_id = 62730 AND l.year= 2022 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0024  SELECT dp.id, dp.nick, dp.name, dp.last_name, dp.alias, dp.role, dp.height,dp.weight,dp.foot,dp.side,dp.birthdate,IF(dp.birthdate != '0000-00-00 00:00:00', YEAR(CURDATE())-YEAR(dp.birthdate) + IF(DATE_FORMAT(CURDATE(),'%m-%d') > DATE_FORMAT(dp.birthdate,'%m-%d'), 0, -1) , NULL) as age,rp.squadNumber,rp.captain,IF(dp.CountryCode IS NULL,'',dp.CountryCode) AS CountryCode,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id and rp.in_squad=1 WHERE rp.team_id=6442204 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0018  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6442204
0.0027  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442204 and (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY dp.id ORDER BY cuenta DESC
0.0028  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442204 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0025  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442204 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0026   SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442204 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0029  SELECT dp.id,count(rp.id) as cuenta FROM rel_players as rp inner join dataplayers as dp on rp.player_id=dp.id INNER JOIN events2022 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6442204 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC