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 Costa Rica
  • Nombre completo Selección de Costa Rica
  • Nombre corto CRI
  • País Iso code - cr Costa Rica
  • Entrenador Gustavo Alfaro
  • URL del equipo en RF //m.resultados-futbol.com/Costa-Rica
Otros Datos
  • Año de Fundación 1921
  • Marca de Ropa New Balance
Internet

Información sobre el estadio

  • Nombre del estadio Estadio Nacional de Costa Rica
  • Capacidad 35100
  • Dirección Radial Santa Ana Belén 670-1000 San José
  • Teléfono +506/2589 1450
  • Fax +506/2589 1457
  • Año de construcción 2011
  • Tamaño 105 x 68 m
Estadio Nacional de Costa Rica

Histórico de participación

Iso code - wo Amistosos Selecciones
Iso code - n1 Copa Oro Grupo 3
Iso code - wo Copa Centroamericana
Iso code - wo Clasificación Mundial CONCACAF Grupo 2
16 veces
Iso code - n2 Copa América Grupo 4
8 veces
Iso code - wo Mundial Grupo 5
8 veces
Iso code - wo Juegos Panamericanos Grupo 0
8 veces
Iso code - n1 Liga de las Naciones CONCACAF Grupo 1
6 veces
Iso code - wo Partidos Amistosos
3 veces
(2013, 2012, 2011)
Iso code - wo Juegos Olímpicos Grupo 4
2 veces
(1984, 1980)
Iso code - wo Repesca Mundial
2 veces
(2022, 2010)
Iso code - n1 Campeonato CONCACAF
1 vez
(1989)
Iso code - wo Amistosos Selecciones No Oficiales
1 vez
(2020)

Partidos del Costa Rica

Ir al LIVESCORE
05 Jul 14  Finalizado Países Bajos Países Bajos
0 - 0
Costa Rica Costa Rica 1546
29 Jun 14  Finalizado Costa Rica Tarjeta RojaCosta Rica
1 - 1
Grecia Grecia 968
24 Jun 14  Finalizado Costa Rica Costa Rica
0 - 0
Inglaterra Inglaterra 250
20 Jun 14  Finalizado Italia Italia
0 - 1
Costa Rica Costa Rica 628
14 Jun 14  Finalizado Uruguay Tarjeta RojaUruguay
1 - 3
Costa Rica Costa Rica 510
07 Jun 14  Finalizado Costa Rica Tarjeta RojaCosta Rica
1 - 1
Irlanda Irlanda 21
03 Jun 14  Finalizado Costa Rica Costa Rica
1 - 3
Japón Japón 44
06 Mar 14  Finalizado Costa Rica Costa Rica
2 - 1
Paraguay Paraguay 4
26 Ene 14  Finalizado Costa Rica Tarjeta RojaTarjeta RojaCosta Rica
0 - 1
Corea del Sur Corea del Sur 0
23 Ene 14  Finalizado Chile Chile
4 - 0
Costa Rica Costa RicaTarjeta Roja 2
15 Ago 13  Finalizado República Dominicana República Dominicana
0 - 4
Costa Rica Costa Rica 0
14 Sep 14  Finalizado Guatemala Guatemala
1 - 2
Costa Rica Costa Rica 2
07 Sep 14  Finalizado Costa Rica Costa Rica
2 - 2
Panamá Panamá 0
03 Sep 14  Finalizado Costa Rica Costa Rica
3 - 0
Nicaragua Nicaragua 1

Estadísticas

Plantilla del Costa Rica Temporada 2013/2014

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
23 38 cr 180 74 - - -
1 37 cr 185 78 - - -
18 42 cr 178 75 - - -
Defensa
16 34 cr 175 67 - - -
8 35 cr 186 78 - - -
3 36 cr 186 84 - - 1
2 40 cr 176 78 - - -
15 40 cr 185 76 - - -
4 41 cr 177 75 - - -
6 34 cr 186 85 1 - -
19 39 cr 187 75 - - -
12 33 cr 177 73 - - -
Centrocampista
10 38 cr 187 78 1 - -
5 35 cr 182 78 - - -
22 37 cr 178 74 - - 1
11 40 cr 177 71 - - -
13 38 cr 183 74 - - -
17 32 cr 179 66 - - -
Delantero
7 39 cr 178 67 - - -
20 33 cr 178 78 - - -
9 31 cr 178 70 1 - -
21 34 cr 181 70 1 - -
14 40 cr 175 72 - - -

Noticias del Costa Rica

Ver últimas noticias

Keylor Navas, lesionado, es duda para la Copa Oro

El portero de la selección de Costa Rica y del Real Madrid Keylor Navas será sometido mañana, miércoles, a exámenes médicos para determinar el alcance de una lesión que padece en un tendón de Aquiles y que pone en riesgo su presencia en la Copa Oro.

La pitada a Piqué protagonista en los diarios deportivos españoles

Los principales periódicos deportivos de España resaltan la pitada de los aficionados al jugador del Barcelona, Gerard Piqué, por parte del público asistente al triunfo del combinado español sobre Costa Rica (2-1) en León.

2-1. España remonta en un juicio sin sentido a Piqué

La selección española se reencontró con el triunfo, remontando en un duelo amistoso a Costa Rica en el Reino de León con goles de Paco Alcácer y Cesc Fábregas, en un ambiente de fiesta que se ensombreció con los silbidos a Gerard Piqué de su propia afición, en un juicio de poco sentido.

'Cada uno es libre de pitar, pero volvería a decir lo que dije'

El defensa del FC Barcelona Gerard Piqué se ha tomado con buen humor los silbidos recibidos a lo largo de todo el encuentro España-Costa Rica en el "Reino de León", porque, según ha explicado, "cada uno es libre de pitar y expresarse como crea conveniente", después de que fuera abucheado cada vez que tocaba el balón tras entrar en el terreno de juego en lugar de Sergio Ramos.

España, obligada a recuperar buenas sensaciones

La selección española retoma el pulso tras dos meses y medio de parón, obligada a recuperar buenas sensaciones y cambiar la dinámica de los amistosos tras su derrota con mala imagen en su última prueba en Holanda, con un partido ante una de las revelaciones del Mundial de Brasil, Costa Rica, antes de un cita clave camino de la Eurocopa 2016.




  USO DE MEMORIA  
5,594,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.6811
Total Execution Time  0.6829
  CADENA URL  
/Costa-Rica/2014
  GET DATOS  
$_GET['/Costa-Rica/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0293  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 3385
0.0152  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 3602
0.0152  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 37702
0.0155  SELECT c.*, l.*, cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 37703
0.0168  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 = '3813' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0150  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 = 37703 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 3385 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0152  (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 calendars2014 as c ON c.league_id = l.id WHERE (c.datateam1 = 3813 or c.datateam2 = 3813) AND l.year = 2014 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0154  (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 calendars2014 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 = 3813 or c.datateam2 = 3813) AND l.year = 2014 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0166  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2014 as c ON c.league_id = l.id INNER JOIN events2014 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 = 3813 or c.datateam2 = 3813) AND l.year = 2014)
0.0221  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=3813 AND l.year in (2013,2014,2015) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (37705,35253,16498,4262,3810,1906) 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.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 3810 AND teamId = 3813
0.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 35253 AND teamId = 3813
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 37705 AND teamId = 3813
0.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 16498 AND teamId = 3813
0.0169  SELECT count(id) as num_players from rel_players WHERE league_id = 4262 AND teamId = 3813
0.0197  SELECT count(id) as num_players from rel_players WHERE league_id = 1906 AND teamId = 3813
0.0160  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 3385 AND t.round = 3 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0188  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 events2014 e ON e.player_id = p.id AND e.league_id = 3385 WHERE rp.league_id = 3385 AND rp.teamId = 3813 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.0161  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 events2014 e ON e.player_id = p.id AND e.league_id = 3385 WHERE rp.league_id = 3385 AND rp.teamId = 3813 AND (e.action = 4 or e.action = 5) 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 events2014 e ON e.player_id = p.id AND e.league_id = 3385 WHERE rp.league_id = 3385 AND rp.teamId = 3813 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 3813 AND rp.league_id = 3385 AND l.year= 2014 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1
0.0150  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=64712 GROUP BY dp.id ORDER BY dp.role>0 DESC, dp.role ASC, dp.nick ASC, dp.id
0.0145  SELECT rp.player_id, rp.pj, rp.lineup FROM rel_players AS rp WHERE rp.team_id=64712
0.0151  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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=64712 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.0161  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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=64712 and (e.action = 4 or e.action = 5) GROUP BY dp.id ORDER BY cuenta DESC
0.0158  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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=64712 and (e.action = 3 or e.action = 4) GROUP BY dp.id ORDER BY cuenta DESC
0.0159   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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=64712 AND (e.action = 22) GROUP BY dp.id ORDER BY cuenta DESC
0.0151  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 events2014 e ON rp.league_id = e.league_id AND rp.player_id = e.player_id WHERE rp.team_id=64712 and (e.action = 19) GROUP BY dp.id ORDER BY cuenta DESC