4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información
  • Nombre del equipo Norwich City
  • Nombre completo Norwich City Football Club
  • Nombre corto NOR
  • País Inglaterra
  • Ciudad Norwich
  • Entrenador David Wagner
  • URL del equipo en RF //m.resultados-futbol.com/Norwich-City-Fc
Otros Datos
  • Año de Fundación 1902
  • Patrocinador Lotus Cars
  • Marca de Ropa Joma
Internet

Información sobre el estadio

  • Nombre del estadio Carrow Road
  • Capacidad 27033
  • Dirección Carrow Road
  • Teléfono +44 (1603) 760 760
  • Fax +44 (1603) 613 886
  • Año de construcción 1935
Carrow Road

Partidos del Norwich City

Ir al LIVESCORE
28 Ene 24  Finalizado Liverpool Liverpool
5 - 2
Norwich City Norwich City 117
17 Ene 24  Finalizado Bristol Rovers Bristol Rovers
1 - 3
Norwich City Norwich City 195
06 Ene 24  Finalizado Norwich City Norwich City
1 - 1
Bristol Rovers Bristol Rovers 78
04 May 24  en 3 días Birmingham City Birmingham City
13:30
Norwich City Norwich City 1
27 Abr 24  Finalizado Norwich City Norwich City
2 - 2
Swansea City Swansea City 47
20 Abr 24  Finalizado Norwich City Norwich City
1 - 1
Bristol City Bristol City 69
13 Abr 24  Finalizado Preston North End Preston North End
0 - 1
Norwich City Norwich City 33
09 Abr 24  Finalizado Sheffield Wednesday Sheffield Wednesday
2 - 2
Norwich City Norwich City 120
06 Abr 24  Finalizado Norwich City Norwich City
1 - 0
Ipswich Town Ipswich Town 295
01 Abr 24  Finalizado Leicester Leicester
3 - 1
Norwich City Norwich City 213
29 Mar 24  Finalizado Norwich City Norwich City
2 - 1
Plymouth Argyle Plymouth Argyle 217
16 Mar 24  Finalizado Stoke City Stoke City
0 - 3
Norwich City Norwich City 23
09 Mar 24  Finalizado Norwich City Norwich City
5 - 0
Rotherham United Rotherham United 31
06 Mar 24  Finalizado Middlesbrough Middlesbrough
3 - 1
Norwich City Norwich CityTarjeta Roja 339
02 Mar 24  Finalizado Norwich City Norwich City
1 - 0
Sunderland Sunderland 20
24 Feb 24  Finalizado Blackburn Rovers Blackburn Rovers
1 - 1
Norwich City Norwich City 22
17 Feb 24  Finalizado Norwich City Norwich City
4 - 1
Cardiff City Cardiff City 19
13 Feb 24  Finalizado Norwich City Norwich City
4 - 2
Watford Watford 84
10 Feb 24  Finalizado Queens Park Rangers Queens Park Rangers
2 - 2
Norwich City Norwich City 20
03 Feb 24  Finalizado Norwich City Norwich City
2 - 1
Coventry City Coventry CityTarjeta Roja 47
24 Ene 24  Finalizado Leeds United Leeds United
1 - 0
Norwich City Norwich City 113
20 Ene 24  Finalizado Norwich City Norwich City
2 - 0
West Bromwich Albion West Bromwich Albion 50
12 Ene 24  Finalizado Hull City Hull City
1 - 2
Norwich City Norwich City 202
01 Ene 24  Finalizado Norwich City Norwich City
1 - 1
Southampton Southampton 221

Plantilla del Norwich City Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
28 28 ss 196 77 - - 1
51 18 gb - - - - -
37 23 wa 195 82 - - -
12 30 gb 193 88 - - -
Defensa
6 31 gb 185 78 - - 6
16 30 ch 185 77 6 - 4
30 28 gr 178 68 - - 6
21 33 gb 191 90 1 - -
49 20 pt 185 78 - - -
5 32 ss 188 76 - - 1
3 28 gb 180 68 1 - 5
35 19 gb 182 - - - 1
15 23 gb 177 68 1 - 3
24 32 ie 193 76 1 - 9
48 17 za - - - - -
Centrocampista
43 19 gb - - - - -
17 24 br 177 69 13 - 5
19 26 dk 184 74 1 - 1
23 32 ss 180 70 1 - 11
8 21 gb 178 - - - 3
26 24 cl 173 73 2 - 6
47 21 br 184 - - - -
Delantero
10 34 gb 185 71 6 - 5
7 23 es 174 75 6 2 4
27 20 gb 178 - 12 - 5
9 24 us 185 79 16 - 2
44 19 gb 183 - - - -
25 31 cu 172 69 - - 2
14 24 nl 190 80 - - -

Noticias del Norwich City

Ver últimas noticias

Garrido regresa a la Liga con Las Palmas

El equipo canario ha confirmado la llegada del ex futbolista de la Real Sociedad para reforzar el lateral izquierdo.

El central Ignasi Miquel, del Norwich City, ficha por la Ponferradina

La Ponferradina ha llegado a un acuerdo para incorporar a su plantilla al central español Ignasi Miquel (23), que procede del Norwich City y que se proclamara con la selección española sub-19 campeón de Europa de la categoría en 2011.

Larrivey volverá al Celta tras rechazar su fichaje el Norwich

El delantero argentino Joaquín Larrivey, futbolista del Celta de Vigo, volverá a entrenarse este lunes con el Celta a las órdenes de Eduardo "Toto" Berizzo, después de que el Norwich City haya descartado su fichaje.

Larrivey, con pie y medio en el Norwich City

El delantero argentino Joaquín Larrivey, futbolista del Celta de Vigo, ha viajado este viernes a Inglaterra para cerrar su traspaso al Norwich City, un recién ascendido a la Premier League.

El Celta hace caja por Larrivey

El delantero del Celta Joaquín Larrivey ha cerrado su traspaso al Norwich City, un recién ascendido a la Premier League.




  USO DE MEMORIA  
6,047,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4434
Total Execution Time  0.4452
  CADENA URL  
/Norwich-City-Fc/
  GET DATOS  
$_GET['/Norwich-City-Fc/']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0141  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 = '1824' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 72033 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  (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 calendars2024 as c ON c.league_id = l.id WHERE (c.datateam1 = 1824 or c.datateam2 = 1824) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0134  (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 calendars2024 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 = 1824 or c.datateam2 = 1824) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0131  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 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 = 1824 or c.datateam2 = 1824) AND ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())<120*3600*24 AND l.year = 2024)
0.0136  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=1824 AND l.year in (2023,2024,2025) 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 (72728,72258,72033,71432) 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.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 72033 AND teamId = 1824
0.0138  SELECT count(id) as num_players from rel_players WHERE league_id = 72728 AND teamId = 1824
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 72258 AND teamId = 1824
0.0224  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 1824
0.0149  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 events2024 e ON e.player_id = p.id AND e.league_id = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1824 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.0151  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 events2024 e ON e.player_id = p.id AND e.league_id = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1824 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0139  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 events2024 e ON e.player_id = p.id AND e.league_id = 72033 WHERE rp.league_id = 72033 AND rp.teamId = 1824 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 1824 AND rp.league_id = 72033 AND l.year= 2024 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0131  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=6582238 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0125  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=6582238
0.0138  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582238 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.0139  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582238 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0133  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582238 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0136   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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582238 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0136  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 events2024 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=6582238 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC