Derby County

Entrenador: Paul Warne

Temporada 1995/1996

Información sobre Derby County

Enviar Datos

Información

Nombre del equipo Derby County
Nombre completo Derby County Football Club
Nombre corto DER
País Inglaterra
Ciudad Derby
Entrenador Paul Warne
URL del equipo en RF //m.resultados-futbol.com/Derby-County-Fc

Otros Datos

Año de Fundación 1884
Presupuesto 14000000
Patrocinador 32Red
Marca de Ropa Umbro
Socios 14000

Internet

Sitio Web https://www.dcfc.co.uk/
Twitter principal @dcfcofficial

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

Histórico de participación

FA Cup

68 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1984, 1983, 1978, 1977, 1976, 1973, 1972, 1970, 1950, 1949, 1948, 1946, 1936, 1933, 1928, 1923, 1911, 1909, 1907, 1906, 1905, 1904, 1903, 1902, 1899, 1898, 1897, 1896, 1894)

Premier League

67 veces

(2008, 2002, 2001, 2000, 1999, 1998, 1997, 1991, 1990, 1989, 1988, 1980, 1979, 1978, 1977, 1976, 1975, 1974, 1973, 1972, 1971, 1970, 1956, 1953, 1952, 1951, 1950, 1949, 1948, 1947, 1940, 1939, 1938, 1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1921, 1920, 1914, 1913, 1907, 1906, 1905, 1904, 1903, 1902, 1901, 1900, 1899, 1898, 1897, 1896, 1895, 1894, 1893, 1892, 1891, 1890, 1889)

Championship

54 veces

(2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2007, 2006, 2005, 2004, 2003, 1996, 1995, 1994, 1993, 1992, 1987, 1984, 1983, 1982, 1981, 1969, 1968, 1967, 1966, 1965, 1964, 1963, 1962, 1961, 1960, 1959, 1958, 1955, 1954, 1926, 1925, 1924, 1923, 1922, 1915, 1912, 1911, 1910, 1909, 1908)

Partidos Amistosos

14 veces

(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011)

Championship - Play Offs Ascenso

5 veces

(2019, 2018, 2016, 2014, 2007)

Partidos del Derby County

Ir al LIVESCORE

FA Cup »

07 Ene 96

Finalizado

Derby County

2 - 4

Leeds United

EFL Cup »

25 Oct 95	Finalizado	Derby County	0 - 1	Leeds United
04 Oct 95	Finalizado	Derby County	1 - 1	Shrewsbury Town
19 Sep 95	Finalizado	Shrewsbury Town	1 - 3	Derby County

Championship »

05 May 96	Finalizado	West Bromwich Albion	3 - 2	Derby County
28 Abr 96	Finalizado	Derby County	2 - 1	Crystal Palace
20 Abr 96	Finalizado	Derby County	1 - 1	Birmingham City
14 Abr 96	Finalizado	Charlton Athletic	0 - 0	Derby County
08 Abr 96	Finalizado	Derby County	6 - 2	Tranmere Rovers
06 Abr 96	Finalizado	Oldham Athletic AFC	0 - 1	Derby County
02 Abr 96	Finalizado	Ipswich Town	1 - 0	Derby County
30 Mar 96	Finalizado	Derby County	3 - 1	Stoke City
23 Mar 96	Finalizado	Norwich City	1 - 0	Derby County
16 Mar 96	Finalizado	Derby County	1 - 1	Watford
09 Mar 96	Finalizado	Sunderland	3 - 0	Derby County
05 Mar 96	Finalizado	Watford	0 - 0	Derby County
02 Mar 96	Finalizado	Derby County	3 - 2	Huddersfield Town
28 Feb 96	Finalizado	Leicester	0 - 0	Derby County
24 Feb 96	Finalizado	Derby County	3 - 2	Portsmouth
21 Feb 96	Finalizado	Derby County	1 - 1	Luton Town
17 Feb 96	Finalizado	Southend United	1 - 2	Derby County
10 Feb 96	Finalizado	Derby County	0 - 0	Wolves
03 Feb 96	Finalizado	Grimsby Town	1 - 1	Derby County
20 Ene 96	Finalizado	Port Vale	1 - 1	Derby County
13 Ene 96	Finalizado	Derby County	3 - 0	Reading
01 Ene 96	Finalizado	Derby County	2 - 1	Norwich City
26 Dic 95	Finalizado	Huddersfield Town	0 - 1	Derby County
23 Dic 95	Finalizado	Derby County	3 - 1	Sunderland
16 Dic 95	Finalizado	Millwall	0 - 1	Derby County
09 Dic 95	Finalizado	Derby County	4 - 1	Barnsley
02 Dic 95	Finalizado	Derby County	4 - 2	Sheffield United
25 Nov 95	Finalizado	Crystal Palace	0 - 0	Derby County
21 Nov 95	Finalizado	Birmingham City	1 - 4	Derby County
18 Nov 95	Finalizado	Derby County	2 - 0	Charlton Athletic
11 Nov 95	Finalizado	Derby County	3 - 0	West Bromwich Albion
04 Nov 95	Finalizado	Tranmere Rovers	5 - 1	Derby County
28 Oct 95	Finalizado	Derby County	2 - 1	Oldham Athletic AFC
22 Oct 95	Finalizado	Stoke City	1 - 1	Derby County
14 Oct 95	Finalizado	Derby County	1 - 1	Ipswich Town
07 Oct 95	Finalizado	Sheffield United	0 - 2	Derby County
01 Oct 95	Finalizado	Derby County	2 - 2	Millwall
23 Sep 95	Finalizado	Barnsley	2 - 0	Derby County
16 Sep 95	Finalizado	Portsmouth	2 - 2	Derby County
13 Sep 95	Finalizado	Derby County	1 - 0	Southend United
10 Sep 95	Finalizado	Derby County	0 - 1	Leicester
02 Sep 95	Finalizado	Luton Town	1 - 2	Derby County
30 Ago 95	Finalizado	Wolves	3 - 0	Derby County
26 Ago 95	Finalizado	Derby County	1 - 1	Grimsby Town
19 Ago 95	Finalizado	Reading	3 - 2	Derby County
13 Ago 95	Finalizado	Derby County	0 - 0	Port Vale

Noticias del Derby County

Ver últimas noticias

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

Juan Ribón - Martes, 05 Enero 2016

0 101

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

Adrián Becerra - Martes, 05 Enero 2016

0 964

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

Sergio Álvarez - Martes, 29 Diciembre 2015

3 4.006

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

BeSoccer - Lunes, 28 Septiembre 2015

0 855

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

BeSoccer - Jueves, 30 Julio 2015

0 335

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).

Ver más noticias del equipo»

Pos	Equipos	Pts
1		Sunderland	83
2		Derby County	79
3		Crystal Palace	75
4		Stoke City	73
5		Charlton Athletic	71
6		Leicester	71
7		Ipswich Town	69
8		Huddersfield Town	63
9		Sheffield United	62
10		Barnsley	60
11		Port Vale	60
12		West Bromwich Albion	60
13		Tranmere Rovers	59
14		Southend United	59
15		Birmingham City	58
16		Norwich City	57
17		Oldham Athletic AFC	56
18		Reading	56
19		Grimsby Town	56
20		Wolves	55
21		Portsmouth	52
22		Millwall	52
23		Watford	48
24		Luton Town	45

Pos

Equipos

Pts

USO DE MEMORIA

5,843,312 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.5838
Total Execution Time	0.5857

CADENA URL

/Derby-County-Fc/1996

GET DATOS

$_GET['/Derby-County-Fc/1996']

POST DATOS

No hay datos POST existentes

CONSULTAS (30)

0.0124	SELECT type FROM routes WHERE alias = 'derby-county-fc'
0.0151	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Derby-County-Fc' AND l.year = 1996 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=916 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=916 AND type_rel = 2
0.0131	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 916 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (4320,14163,30924,31965,32142) ORDER BY n.cover_points DESC, update_date DESC
0.0270	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '916' ORDER BY l.year DESC,cat.coefficient DESC
0.0144	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '916' AND l.year = 1996 ORDER BY l.year DESC,cat.coefficient DESC
0.0155	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.0272	(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 calendars1996 as c ON c.league_id = l.id WHERE (c.datateam1 = 916 or c.datateam2 = 916) AND l.year = 1996 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0278	(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 calendars1996 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 = 1996 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0275	(SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars1996 as c ON c.league_id = l.id INNER JOIN events1996 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 = 1996)
0.0142	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 (1995,1996,1997) ORDER BY l.id DESC, l.year DESC ;
0.0126	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 (23242,14538,474,334) 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.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 334 AND teamId = 916
0.0125	SELECT count(id) as num_players from rel_players WHERE league_id = 474 AND teamId = 916
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 14538 AND teamId = 916
0.0132	SELECT count(id) as num_players from rel_players WHERE league_id = 23242 AND teamId = 916
0.0129	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '916' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '916' and rp.type = 4
0.0128	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '916' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127	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 events1996 e ON e.player_id = p.id AND e.league_id = 473 WHERE rp.league_id = 473 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.0126	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 events1996 e ON e.player_id = p.id AND e.league_id = 473 WHERE rp.league_id = 473 AND rp.teamId = 916 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127	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 events1996 e ON e.player_id = p.id AND e.league_id = 473 WHERE rp.league_id = 473 AND rp.teamId = 916 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0127	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 = 473 AND l.year= 1996 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0127	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 = 473 AND l.year= 1996 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0127	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 = 473 AND l.year= 1996 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1

Derby County

Información sobre Derby County

Información

Otros Datos

Internet

Opciones de envio

Datos del equipo

Información sobre el estadio

Histórico de participación

FA Cup

Premier League

Championship

EFL Cup

Partidos Amistosos

Championship - Play Offs Ascenso

EFL Trophy

Champions League

League One

Europa League

Community Shield

Trofeo Colombino

Trofeo Costa del Sol

Partidos del Derby County

Noticias del Derby County

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

El Derby County pesca a un ex del Mallorca

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

Tom Ince dijo no al Inter para triunfar en la Premier

Areola libra al Villarreal de caer vencido frente al Derby County

Derby County

Selecciona un equipo

Competiciones que juega

Championship

RIVALES EN Championship

RIVALES EN EFL Cup

RIVALES EN FA Cup