SELECT E.ESTCOD AS IDESTACION, E.ESTNOM AS ESTACION, TD.TIPO, NVL(CV.TOTAL,0) AS TOTAL FROM(SELECT REGEXP_SUBSTR('NORMAL,SABADO,DOMINGO,FERIADO', '[^,]+', 1, LEVEL) AS TIPO FROM DUAL CONNECT BY REGEXP_SUBSTR('NORMAL,SABADO,DOMINGO,FERIADO', '[^,]+', 1, LEVEL) IS NOT NULL) TD JOIN (SELECT ESTCOD, ESTNOM,ORDEN FROM TB_ESTACION WHERE TIPCOD = 0 ) E ON 1=1 LEFT JOIN (SELECT * FROM( SELECT 'NORMAL' AS TIPO, V.ESTCOD, SUM(V.VALCAN) AS TOTAL FROM TM_VALIDACION V JOIN TB_FECHA F ON F.FECPERFEC = V.VALPERFEC AND DIACOD IN (1, 2, 3, 4, 5) AND FECFER = 0 AND F.FECFEC BETWEEN TO_DATE('2010-07-01', 'YYYY-MM-DD') AND TO_DATE('2024-04-19', 'YYYY-MM-DD') GROUP BY V.ESTCOD UNION SELECT 'SABADO' AS TIPO, V.ESTCOD, SUM(V.VALCAN) AS TOTAL FROM TM_VALIDACION V JOIN TB_FECHA F ON F.FECPERFEC = V.VALPERFEC AND DIACOD = 6 AND FECFER = 0 AND F.FECFEC BETWEEN TO_DATE('2010-07-01', 'YYYY-MM-DD') AND TO_DATE('2024-04-19', 'YYYY-MM-DD') GROUP BY V.ESTCOD UNION SELECT 'DOMINGO' AS TIPO, V.ESTCOD, SUM(V.VALCAN) AS TOTAL FROM TM_VALIDACION V JOIN TB_FECHA F ON F.FECPERFEC = V.VALPERFEC AND DIACOD = 7 AND FECFER = 0 AND F.FECFEC BETWEEN TO_DATE('2010-07-01', 'YYYY-MM-DD') AND TO_DATE('2024-04-19', 'YYYY-MM-DD') GROUP BY V.ESTCOD UNION SELECT 'FERIADO' AS TIPO, V.ESTCOD, SUM(V.VALCAN) AS TOTAL FROM TM_VALIDACION V JOIN TB_FECHA F ON F.FECPERFEC = V.VALPERFEC AND FECFER = 1 AND F.FECFEC BETWEEN TO_DATE('2010-07-01', 'YYYY-MM-DD') AND TO_DATE('2024-04-19', 'YYYY-MM-DD') GROUP BY V.ESTCOD )) CV ON CV.ESTCOD = E.ESTCOD AND CV.TIPO = TD.TIPO ORDER BY E.ORDEN, TD.TIPO
Filtrar por:
desde
hasta
por el Tramo
por Estacion
N° Estacion Dias Habiles Dias Sabados Dias Domingos Dias Feriados Total
1 Naranjal 255,986,853 38,134,630 15,012,095 4,121,309 313,254,887
2 Izaguirre 34,948,549 5,262,963 2,136,884 656,653 43,005,049
3 Pacifico 5,409,690 983,642 427,427 125,723 6,946,482
4 Independencia 15,618,763 2,328,490 931,671 273,092 19,152,016
5 Los jazmines 5,726,339 1,034,069 492,979 137,350 7,390,737
6 Tomas Valle 41,346,134 6,799,720 3,426,060 784,205 52,356,119
7 El Milagro 7,785,121 1,251,295 562,731 163,061 9,762,208
8 Honorio Delgado 9,193,859 1,402,817 556,717 144,828 11,298,221
9 Uni 31,329,130 4,516,988 1,832,340 501,528 38,179,986
10 Parque del Trabajo 5,710,209 892,910 425,888 118,975 7,147,982
11 Caqueta 14,455,448 2,449,567 1,184,226 295,284 18,384,525
12 Ramon Castilla 20,935,958 3,334,788 1,462,645 357,816 26,091,207
13 Tacna 17,947,401 2,980,993 1,434,671 435,440 22,798,505
14 Jiron de la Union 35,705,287 5,085,102 2,261,125 730,485 43,781,999
15 Colmena 27,312,844 4,168,310 1,457,222 491,583 33,429,959
16 2 de Mayo 16,984,437 2,452,225 816,563 292,962 20,546,187
17 Quilca 12,606,026 1,748,590 795,002 237,258 15,386,876
18 España 44,375,700 6,354,581 2,297,173 655,950 53,683,404
19 Estacion Central 75,333,893 12,118,690 4,715,025 1,381,355 93,548,963
20 Estadio Nacional 19,306,567 3,174,035 1,655,419 346,979 24,483,000
21 México 19,095,228 3,102,371 1,339,458 363,586 23,900,643
22 Canadá 39,100,011 5,442,978 2,350,001 610,170 47,503,160
23 Javier Prado 49,109,599 6,071,953 2,272,977 674,483 58,129,012
24 Canaval y Moreyra 62,412,280 4,701,404 1,425,458 630,588 69,169,730
25 Aramburu 25,392,640 2,272,055 884,872 325,621 28,875,188
26 Domingo Orué 10,417,897 1,336,095 607,254 193,772 12,555,018
27 Angamos 64,654,950 9,760,147 3,513,566 1,036,108 78,964,771
28 Ricardo Palma 30,106,539 4,160,667 1,905,006 528,351 36,700,563
29 Benavides 38,514,442 4,545,702 1,805,178 570,274 45,435,596
30 28 de Julio 14,102,586 1,871,050 856,174 261,719 17,091,529
31 Plaza de Flores 22,936,410 3,217,376 1,075,609 349,227 27,578,622
32 Balta 17,852,439 3,174,975 1,904,506 499,075 23,430,995
33 Bulevar 11,656,253 2,450,391 1,792,146 381,825 16,280,615
34 Estadio Union 9,398,788 1,512,095 975,941 241,009 12,127,833
35 Escuela Militar 4,779,898 717,722 590,308 129,747 6,217,675
36 Terán 9,609,614 1,748,283 1,023,447 248,900 12,630,244
37 Rosario de Villa 12,234,196 2,345,945 1,405,791 382,186 16,368,118
38 Matellini 88,973,174 13,821,247 7,064,462 1,750,614 111,609,497