You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
677 lines
59 KiB
677 lines
59 KiB
create table bureau (
|
|
id int(11) default null,
|
|
c2 int(11) default null,
|
|
c3 varchar(20),
|
|
c4 varchar(20),
|
|
c5 int(11) default null,
|
|
c6 int(11) default null,
|
|
c7 varchar(20),
|
|
c8 varchar(20),
|
|
c9 varchar(20),
|
|
c10 int(11) default null,
|
|
c11 double default null,
|
|
c12 varchar(20),
|
|
c13 varchar(20),
|
|
c14 double default null,
|
|
c15 varchar(20),
|
|
c16 int(11) default null,
|
|
amt_annuity varchar(20),
|
|
key bureau (id,c2),
|
|
key bureau_i2 (c2)
|
|
) engine=innodb default charset=utf8mb4 collate=utf8mb4_0900_ai_ci;
|
|
Warnings:
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
Warning 1681 Integer display width is deprecated and will be removed in a future release.
|
|
set session sql_mode='';
|
|
load data infile '../../std_data/inconsistent_scan.csv' into table bureau columns terminated by "," ignore 1 lines;
|
|
set big_tables=0;
|
|
create table t1 as
|
|
select id, c2, count(*) over w cnt,
|
|
c3,
|
|
c4, c5,
|
|
c6, c7, c8,
|
|
c9, c10, c11,
|
|
c12, c13,
|
|
c14, c15, c16
|
|
from bureau window w as (partition by id);
|
|
set big_tables=1;
|
|
create table t2 as
|
|
select id, c2, count(*) over w cnt,
|
|
c3,
|
|
c4, c5,
|
|
c6, c7, c8,
|
|
c9, c10, c11,
|
|
c12, c13,
|
|
c14, c15, c16
|
|
from bureau window w as (partition by id);
|
|
create table t3 as
|
|
select * from t1 union select * from t2;
|
|
select * from t1;
|
|
id c2 cnt c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16
|
|
119939 5714566 17 Closed currency 1 -2279 0 -1945.0 -2033.0 0.0 0 39541.5 0.0 0.0 0 Consumer credit -2033
|
|
119939 5714567 17 Closed currency 1 -2247 0 -1123.0 -1733.0 0.0 0 135000 0.0 0.0 0 Credit card -1733
|
|
119939 5714568 17 Closed currency 1 -1447 0 -331.0 -1272.0 0.0 0 99000 -2692.17 137692.17 0 Credit card -1272
|
|
119939 5714569 17 Closed currency 1 -1390 0 -331.0 -1263.0 0.0 0 135000 -149.04 135149.04 0 Credit card -1263
|
|
119939 5714570 17 Active currency 1 -1390 0 -696.0 0.0 0 4500 -2.565 2.565 0 Credit card -691
|
|
119939 5714571 17 Active currency 1 -733 0 1100.0 0.0 0 337500 242596.395 94903.605 0 Credit card -687
|
|
119939 5714573 17 Closed currency 1 -1188 0 1369.0 -1090.0 0 450000 0.0 0.0 0 Consumer credit -429
|
|
119939 5714574 17 Closed currency 1 -437 0 1389.0 -225.0 0 1226250 0.0 0.0 0 Consumer credit -194
|
|
119939 5714575 17 Closed currency 1 -944 0 335.0 -548.0 0 1215000 0.0 0.0 0 Consumer credit -513
|
|
119939 5714577 17 Active currency 1 -1102 0 4.0 0 225000 210730.5 0.0 0 Credit card -10
|
|
119939 5714578 17 Closed currency 1 -1572 0 -1179.0 -987.0 0 225000 0 Consumer credit -984
|
|
119939 5714579 17 Closed currency 1 -1791 0 -1703.0 -987.0 0 22770 0 Consumer credit -984
|
|
119939 5714580 17 Active currency 1 -2401 0 0.0 0 99000 45036.0 53962.695 0 Credit card -22
|
|
119939 5714581 17 Closed currency 1 -1624 0 203.0 -1085.0 40.5 0 765000 0 Consumer credit -1085
|
|
119939 5714582 17 Closed currency 1 -1617 0 9341.0 -1083.0 6007.5 0 144000 0 Credit card -1083
|
|
119939 5714583 17 Closed currency 1 -937 0 889.0 -156.0 0.0 0 675000 0 Consumer credit -156
|
|
119939 5714585 17 Active currency 1 -314 0 1512.0 0.0 0 900000 0 Consumer credit -40
|
|
136226 5714502 2 Active currency 1 -521 0 551.0 0 112500 0.0 0.0 0 Credit card -30
|
|
136226 5714503 2 Closed currency 1 -559 0 -355.0 0.0 0 110250 0.0 0.0 0 Credit card -351
|
|
162297 5714469 6 Closed currency 1 -1896 0 -1684.0 -1710.0 14985.0 0 76878.45 0.0 0.0 0 Consumer credit -1710
|
|
162297 5714470 6 Closed currency 1 -1146 0 -811.0 -840.0 0.0 0 103007.7 0.0 0.0 0 Consumer credit -840
|
|
162297 5714471 6 Active currency 1 -1146 0 -484.0 0.0 0 4500 0.0 0.0 0 Credit card -690
|
|
162297 5714472 6 Active currency 1 -1146 0 -180.0 0.0 0 337500 0.0 0.0 0 Credit card -690
|
|
162297 5714473 6 Closed currency 1 -2456 0 -629.0 -825.0 0 675000 0.0 0.0 0 Consumer credit -706
|
|
162297 5714474 6 Active currency 1 -277 0 5261.0 0.0 0 7033500 0 Mortgage -31
|
|
166034 5714697 8 Closed currency 1 -1283 0 -1069.0 -1083.0 3727.89 0 19399.5 0.0 0.0 0 Consumer credit -1068
|
|
166034 5714698 8 Closed currency 1 -828 0 -613.0 -642.0 13590.0 0 70692.84 0.0 0.0 0 Consumer credit -642
|
|
166034 5714699 8 Active currency 1 -828 0 916.0 0.0 0 4500 0.0 4500.0 0 Credit card -676
|
|
166034 5714700 8 Closed currency 1 -1207 0 -1021.0 -1021.0 0 93240 0.0 0.0 0 Consumer credit -981
|
|
166034 5714701 8 Active currency 1 -706 0 369.0 0 459000 483534.0 0.0 0 Credit card -4
|
|
166034 5714702 8 Active currency 1 -262 0 103.0 0 450000 174519.0 0 Consumer credit -7
|
|
166034 5714704 8 Active currency 1 -718 0 2189.205 0 45000 43357.5 1638.765 0 Credit card -22
|
|
166034 5714705 8 Closed currency 1 -612 0 -245.0 -207.0 13225.725 0 178335 0.0 0.0 0 Consumer credit -206
|
|
173404 5714710 4 Closed currency 1 -1103 0 -304.0 -303.0 0 216000 0.0 0.0 0 Credit card -303
|
|
173404 5714711 4 Closed currency 1 -1166 0 -915.0 -915.0 0 107037 0.0 0.0 0 Consumer credit -752
|
|
173404 5714712 4 Active currency 1 -45 0 320.0 0 234000 234000.0 0.0 0 Consumer credit -26
|
|
173404 5714713 4 Closed currency 1 -1165 0 -860.0 -915.0 0.0 0 107037 0.0 0.0 0 Consumer credit -825
|
|
215354 5714462 7 Closed currency 1 -497 0 -153.0 -153.0 0 91323 0.0 0 Consumer credit -131
|
|
215354 5714463 7 Active currency 1 -208 0 1075.0 0 225000 171342.0 0 Credit card -20
|
|
215354 5714464 7 Active currency 1 -203 0 528.0 0 464323.5 0 Consumer credit -16
|
|
215354 5714465 7 Active currency 1 -203 0 0 90000 0 Credit card -16
|
|
215354 5714466 7 Active currency 1 -629 0 1197.0 77674.5 0 2700000 0 Consumer credit -21
|
|
215354 5714467 7 Active currency 1 -273 0 27460.0 0.0 0 180000 71017.38 108982.62 0 Credit card -31
|
|
215354 5714468 7 Active currency 1 -43 0 79.0 0.0 0 42103.8 42103.8 0.0 0 Consumer credit -22
|
|
222183 5714491 6 Active currency 1 -784 0 1008.0 0.0 0 0 -411.615 411.615 0 Credit card -694
|
|
222183 5714492 6 Active currency 1 -774 0 625.0 0 127840.5 0.0 0.0 0 Credit card -210
|
|
222183 5714493 6 Active currency 1 -395 0 1431.0 0 1350000 1185493.5 0.0 0 Consumer credit -24
|
|
222183 5714495 6 Closed currency 1 -2744 0 -2561.0 -2559.0 310.5 0 18157.5 0 Consumer credit -2559
|
|
222183 5714496 6 Closed currency 1 -1103 0 -7.0 -343.0 20493.27 0 675000 0.0 0.0 0 Consumer credit -343
|
|
222183 5714497 6 Active currency 1 -315 0 1512.0 88821.0 0 3709552.5 0 Car loan -32
|
|
234931 5714557 6 Active currency 1 -1272 0 -667.0 0 135000 17982.0 0.0 0 Consumer credit -721
|
|
234931 5714558 6 Closed currency 1 -1602 0 -1332.0 -987.0 0 42894 0 Consumer credit -984
|
|
234931 5714559 6 Closed currency 1 -1273 0 -667.0 -649.0 0 135000 0 Consumer credit -643
|
|
234931 5714560 6 Closed currency 1 -371 0 -130.0 -130.0 0 63522 0.0 0 Consumer credit -110
|
|
234931 5714561 6 Closed currency 1 -2638 0 -1208.0 -1518.0 18293.265 0 1143000 0.0 0.0 0 Car loan -704
|
|
234931 5714562 6 Closed currency 1 -1495 0 -635.0 -40.0 12618.0 0 46831.5 0 Consumer credit -34
|
|
238881 5714482 7 Closed currency 1 -318 0 -187.0 -187.0 0 0 0.0 0.0 0 Credit card -185
|
|
238881 5714484 7 Closed currency 1 -2911 0 -2607.0 -2604.0 0 48555 0 Consumer credit -2601
|
|
238881 5714485 7 Closed currency 1 -2148 0 -1595.0 -987.0 0 135000 0 Consumer credit -984
|
|
238881 5714486 7 Active currency 1 -381 0 0 450000 520920.0 0 Consumer credit -4
|
|
238881 5714487 7 Active currency 1 -95 0 1720.0 0 67500 8131.5 0 Credit card -7
|
|
238881 5714488 7 Closed currency 1 -444 0 -77.0 -77.0 0.0 0 107184.06 0.0 0.0 0 Consumer credit -71
|
|
238881 5714489 7 Active currency 1 -392 0 0.0 0 252000 23679.0 228320.1 0 Credit card -22
|
|
241216 5714692 2 Closed currency 1 -259 0 -139.0 -230.0 0.0 0 10464.435 0.0 0.0 0 Consumer credit -227
|
|
241216 5714693 2 Active currency 1 -199 0 -14.0 0.0 0 40810.5 8055.0 0.0 0 Consumer credit -22
|
|
242993 5714537 13 Closed currency 1 -2785 0 -958.0 -1769.0 0 225000 0.0 0.0 0 Consumer credit -908
|
|
242993 5714538 13 Closed currency 1 -683 0 -654.0 -654.0 0 40500 0.0 0.0 0 Consumer credit -624
|
|
242993 5714539 13 Closed currency 1 -744 0 -717.0 -717.0 0 45000 0.0 0.0 0 Consumer credit -624
|
|
242993 5714541 13 Closed currency 1 -801 0 -773.0 -773.0 0 45000 0.0 0.0 0 Consumer credit -624
|
|
242993 5714542 13 Closed currency 1 -1841 0 -1473.0 -1466.0 0 225000 0.0 0.0 0 Consumer credit -1195
|
|
242993 5714543 13 Active currency 1 -2237 0 -1868.0 0 135000 0 Consumer credit -1874
|
|
242993 5714544 13 Closed currency 1 -1201 0 -1081.0 -987.0 0 157500 0 Consumer credit -984
|
|
242993 5714545 13 Closed currency 1 -1844 0 -1473.0 -987.0 0 225000 0 Consumer credit -984
|
|
242993 5714547 13 Closed currency 1 -705 0 -614.0 -586.0 0 158566.5 0 Consumer credit -580
|
|
242993 5714548 13 Closed currency 1 -605 0 -577.0 -577.0 0 13500 0 Consumer credit -572
|
|
242993 5714549 13 Closed currency 1 -564 0 -535.0 -535.0 0 45000 0 Consumer credit -531
|
|
242993 5714550 13 Active currency 1 -382 0 1464.0 0 58500 59809.5 0 Credit card -341
|
|
242993 5714551 13 Closed currency 1 -865 0 -742.0 -833.0 0.0 0 29250 0.0 0.0 0 Consumer credit -833
|
|
253882 5714648 4 Closed currency 1 -1341 0 -241.0 -749.0 0 0 0.0 0 Credit card -747
|
|
253882 5714649 4 Active currency 1 -758 0 1095.0 0 315000 54895.5 0 Credit card 0
|
|
253882 5714650 4 Closed currency 1 -1531 0 -800.0 -805.0 0.0 0 138987 0.0 0.0 0 Consumer credit -805
|
|
253882 5714651 4 Closed currency 1 -770 0 -467.0 -467.0 0.0 0 50301 0.0 0.0 0 Consumer credit -463
|
|
280788 5714715 4 Active currency 1 -221 0 875.0 0 220675.5 0 Consumer credit -30
|
|
280788 5714716 4 Active currency 1 -221 0 0 90000 0 Credit card -9
|
|
280788 5714717 4 Active currency 1 -728 0 2.0 3520.8 0 112500 5926.5 0.0 0 Consumer credit -27
|
|
280788 5714718 4 Closed currency 1 -637 0 -120.0 -120.0 1856.34 0 56532.645 0.0 0.0 0 Consumer credit -120
|
|
286014 5714690 1 Active currency 1 -137 0 27460.0 0.0 0 22500 18765.63 76.59 0 Credit card -31
|
|
293201 5714620 5 Closed currency 1 -2730 0 -2454.0 -2514.0 0.0 0 14058 0.0 0.0 0 Consumer credit -2514
|
|
293201 5714621 5 Closed currency 1 -2389 0 -1365.0 -1780.0 11250.0 0 225000 -701.28 225701.28 0 Credit card -1780
|
|
293201 5714622 5 Closed currency 1 -2255 0 -1982.0 -1987.0 6492.42 0 46033.92 0.0 0.0 0 Consumer credit -1981
|
|
293201 5714624 5 Active currency 1 -1425 0 -757.0 0.0 0 4500 0.0 4500.0 0 Credit card -695
|
|
293201 5714625 5 Closed currency 1 -2540 0 -713.0 -2209.0 0 360000 0.0 0.0 0 Consumer credit -1261
|
|
303740 5714552 4 Closed currency 1 -1423 0 -1119.0 -1118.0 0 79744.5 0.0 0.0 0 Consumer credit -1118
|
|
303740 5714553 4 Closed currency 1 -666 0 -574.0 -574.0 0.0 0 36916.56 0.0 0.0 0 Consumer credit -568
|
|
303740 5714554 4 Active currency 1 -581 0 0.0 0 384750 263056.5 121690.17 0 Credit card -22
|
|
303740 5714555 4 Closed currency 1 -433 0 -320.0 -320.0 0.0 0 67500 0.0 0.0 0 Consumer credit -316
|
|
311918 5714563 2 Closed currency 1 -2904 0 -2723.0 -2723.0 0 32899.5 0.0 0 Consumer credit -2723
|
|
311918 5714564 2 Active currency 1 -146 0 37.0 0.0 0 59085 20835.0 0.0 0 Consumer credit -24
|
|
335122 5714653 5 Closed currency 1 -1189 0 -109.0 -874.0 0 225000 0.0 0.0 0 Consumer credit -860
|
|
335122 5714654 5 Closed currency 1 -2426 0 -600.0 -556.0 0 540000 0.0 0.0 0 Consumer credit -188
|
|
335122 5714655 5 Active currency 1 -644 0 1182.0 0 900000 0 Consumer credit -30
|
|
335122 5714656 5 Active currency 1 -885 0 210.0 0 900000 0 Consumer credit -30
|
|
335122 5714657 5 Closed currency 1 -2740 0 -2434.0 -2496.0 0.0 0 54000 0.0 0.0 0 Consumer credit -2494
|
|
338464 5714626 8 Closed currency 1 -2655 0 -2319.0 -2348.0 0.0 0 20165.4 0.0 0.0 0 Consumer credit -831
|
|
338464 5714627 8 Closed currency 1 -2539 0 -1427.0 -651.0 0.0 0 45000 0.0 0.0 0 Credit card -651
|
|
338464 5714628 8 Closed currency 1 -2343 0 -2008.0 -2219.0 0.0 0 19192.5 0.0 0.0 0 Consumer credit -2219
|
|
338464 5714629 8 Closed currency 1 -857 0 -523.0 -582.0 3285.0 0 33853.5 0.0 0.0 0 Consumer credit -582
|
|
338464 5714630 8 Active currency 1 -857 0 765.0 1704.78 0 45000 38294.37 6705.63 0 Credit card -675
|
|
338464 5714631 8 Active currency 1 -1131 0 -27.0 0 270000 0.0 0.0 0 Credit card -17
|
|
338464 5714633 8 Closed currency 1 -1706 0 -976.0 -1260.0 0 247500 0.0 0.0 0 Consumer credit -538
|
|
338464 5714634 8 Active currency 1 -140 0 0.0 0 144000 143019.0 980.28 0 Credit card -22
|
|
351919 5714658 1 Active currency 1 -769 0 1057.0 0 409500 295542.0 0.0 0 Consumer credit -14
|
|
373324 5714674 14 Active currency 1 -837 0 -453.0 0.0 0 0 -45.36 45.36 0 Credit card -685
|
|
373324 5714675 14 Active currency 1 -341 0 -160.0 0.0 0 63496.17 63496.17 0.0 0 Consumer credit -234
|
|
373324 5714676 14 Closed currency 1 -586 0 -402.0 -402.0 0 90180 0.0 0.0 0 Consumer credit -400
|
|
373324 5714677 14 Closed currency 1 -1439 0 -1134.0 -1123.0 0 60399 0.0 0.0 0 Consumer credit -775
|
|
373324 5714679 14 Active currency 1 -577 0 521.0 0 225000 45324.0 0.0 0 Credit card -25
|
|
373324 5714681 14 Closed currency 1 -2819 0 -2516.0 -2516.0 0 24903 0.0 0 Consumer credit -2516
|
|
373324 5714682 14 Closed currency 1 -2673 0 -2307.0 -2307.0 0 31788 0.0 0 Consumer credit -2307
|
|
373324 5714683 14 Closed currency 1 -1438 0 -1134.0 -1153.0 0 60399 0.0 0 Consumer credit -1128
|
|
373324 5714684 14 Closed currency 1 -1913 0 -1609.0 -1609.0 0 53410.5 0.0 0 Consumer credit -1128
|
|
373324 5714685 14 Closed currency 1 -1593 0 -1109.0 -987.0 0 79456.5 0 Consumer credit -984
|
|
373324 5714686 14 Closed currency 1 -986 0 -805.0 -740.0 0 68850 0 Consumer credit -738
|
|
373324 5714687 14 Closed currency 1 -2455 0 -2273.0 -1925.0 0.0 0 31410 0.0 0.0 0 Consumer credit -1924
|
|
373324 5714688 14 Closed currency 1 -2216 0 -2121.0 -2095.0 0.0 0 20002.5 0.0 0.0 0 Consumer credit -2095
|
|
373324 5714689 14 Closed currency 1 -1805 0 -320.0 0.0 0 13500 0.0 0.0 0 Credit card -229
|
|
387080 5714598 14 Closed currency 1 -983 0 -623.0 -900.0 0 52987.5 0.0 0.0 0 Consumer credit -802
|
|
387080 5714600 14 Closed currency 1 -1104 0 -738.0 -731.0 0 194400 0.0 0.0 0 Consumer credit -731
|
|
387080 5714601 14 Closed currency 1 -1766 0 -1219.0 -1256.0 0 135000 0.0 0.0 0 Consumer credit -1252
|
|
387080 5714602 14 Active currency 1 -1082 0 745.0 0 197820 105840.0 0.0 0 Consumer credit -10
|
|
387080 5714603 14 Active currency 1 -1239 0 -149.0 0 225000 185953.5 0.0 0 Credit card -10
|
|
387080 5714604 14 Active currency 1 -681 0 1145.0 0 328500 244791.0 0.0 0 Consumer credit -10
|
|
387080 5714606 14 Closed currency 1 -2897 0 -2350.0 -2357.0 0 67500 0 Consumer credit -2357
|
|
387080 5714607 14 Closed currency 1 -1603 0 -1299.0 -1087.0 0 70335 0.0 0 Consumer credit -1087
|
|
387080 5714608 14 Closed currency 1 -2093 0 -1949.0 -987.0 0 44968.5 0 Consumer credit -984
|
|
387080 5714609 14 Active currency 1 -69 0 263.0 0 84361.5 0 Consumer credit -6
|
|
387080 5714610 14 Closed currency 1 -2299 0 -1932.0 -1932.0 0.0 0 72600.75 0.0 0.0 0 Consumer credit -1603
|
|
387080 5714611 14 Closed currency 1 -549 0 -364.0 -488.0 0.0 0 37935 0.0 0.0 0 Consumer credit -486
|
|
387080 5714612 14 Closed currency 1 -388 0 -21.0 -84.0 0.0 0 98446.5 0.0 0.0 0 Consumer credit -84
|
|
387080 5714614 14 Active currency 1 -18 0 378.0 0.0 0 76500 76500.0 0.0 0 Consumer credit -14
|
|
388421 5714587 4 Active currency 1 -685 0 410.0 0.0 0 135000 0.0 135000.0 0 Credit card -236
|
|
388421 5714590 4 Closed currency 1 -325 0 223.0 -112.0 0 87286.5 0.0 0.0 0 Consumer credit -106
|
|
388421 5714591 4 Active currency 1 -674 0 1152.0 0 868500 662139.0 0.0 0 Consumer credit -25
|
|
388421 5714593 4 Active currency 1 -378 0 1449.0 0.0 0 991800 0 Consumer credit -31
|
|
389074 5714667 3 Closed currency 1 -957 0 -342.0 -341.0 0 13500 0.0 0.0 0 Credit card -334
|
|
389074 5714668 3 Closed currency 1 -705 0 -433.0 -404.0 0 135729 0 Consumer credit -398
|
|
389074 5714669 3 Closed currency 1 -1049 0 -378.0 -378.0 0.0 0 113496.885 0.0 0.0 0 Consumer credit -372
|
|
389599 5714529 7 Closed currency 1 -672 0 10285.0 -531.0 0 135000 0.0 0.0 0 Credit card -429
|
|
389599 5714530 7 Closed currency 1 -1304 0 1253.0 -1287.0 0 225000 0.0 0.0 0 Consumer credit -429
|
|
389599 5714531 7 Closed currency 1 -1253 0 -887.0 -887.0 0 43105.5 0.0 0.0 0 Consumer credit -687
|
|
389599 5714532 7 Closed currency 1 -1130 0 331.0 -858.0 0 450000 0.0 0.0 0 Consumer credit -847
|
|
389599 5714533 7 Active currency 1 -831 0 277.0 0 270000 274225.5 0.0 0 Credit card -10
|
|
389599 5714534 7 Active currency 1 -329 0 1497.0 0 589500 521478.0 0.0 0 Consumer credit -8
|
|
389599 5714536 7 Closed currency 1 -700 0 -600.0 -600.0 0.0 0 68715 0.0 0.0 0 Consumer credit -596
|
|
399459 5714708 2 Closed currency 1 -1141 0 -837.0 -784.0 0 113359.5 0 Consumer credit -781
|
|
399459 5714709 2 Active currency 1 -49 0 316.0 0.0 0 24763.5 22968.0 0.0 0 Consumer credit -19
|
|
400486 5714504 5 Closed currency 1 -2413 0 -1864.0 -2128.0 0 180000 0.0 0.0 0 Consumer credit -708
|
|
400486 5714506 5 Active currency 1 -941 0 -17.0 0 40500 0.0 0.0 0 Credit card -15
|
|
400486 5714507 5 Closed currency 1 -1110 0 -745.0 -727.0 0 114727.5 0.0 0.0 0 Consumer credit -658
|
|
400486 5714508 5 Closed currency 1 -2133 0 -1038.0 -1127.0 0 225000 0.0 0.0 0 Consumer credit -708
|
|
400486 5714509 5 Active currency 1 -391 0 705.0 0 142290 108315.0 0.0 0 Consumer credit -30
|
|
402440 5714475 1 Active currency 1 -96 0 269.0 0.0 0 89910 76905.0 0.0 0 Consumer credit -22
|
|
406724 5714661 4 Closed currency 1 -1293 0 -1155.0 -1155.0 0 13500 0.0 0.0 0 Credit card -775
|
|
406724 5714662 4 Closed currency 1 -1433 0 -1251.0 -1245.0 0 23067 0.0 0.0 0 Consumer credit -783
|
|
406724 5714663 4 Closed currency 1 -1432 0 -1251.0 -1251.0 0 23067 0.0 0 Consumer credit -1142
|
|
406724 5714665 4 Active currency 1 -167 0 1298.0 0.0 0 606496.995 574827.21 0.0 0 Consumer credit -5
|
|
419892 5714594 4 Closed currency 1 -1697 0 -1148.0 -1148.0 0 70695 0.0 0.0 0 Consumer credit -696
|
|
419892 5714595 4 Closed currency 1 -1238 0 -878.0 -1120.0 0 22320 0.0 0.0 0 Consumer credit -1119
|
|
419892 5714596 4 Active currency 1 -381 0 0 2767500 2739622.5 0 Mortgage -27
|
|
419892 5714597 4 Closed currency 1 -584 0 511.0 -405.0 0.0 0 238603.5 0.0 0.0 0 Consumer credit -405
|
|
426155 5714498 4 Closed currency 1 -1331 0 -994.0 -1023.0 1350.0 0 39433.5 0.0 0.0 0 Consumer credit -1023
|
|
426155 5714499 4 Closed currency 1 -2534 0 -2352.0 -2347.0 0 38830.5 0.0 0.0 0 Consumer credit -2345
|
|
426155 5714500 4 Closed currency 1 -845 0 -480.0 -480.0 0.0 0 67500 0.0 0.0 0 Consumer credit -480
|
|
426155 5714501 4 Closed currency 1 -529 0 -343.0 -343.0 0.0 0 182791.44 0.0 0.0 0 Consumer credit -337
|
|
435112 5714512 11 Closed currency 1 -1412 0 -861.0 -849.0 0 85288.5 0.0 0.0 0 Consumer credit -753
|
|
435112 5714513 11 Closed currency 1 -1590 0 -1344.0 -1276.0 0 100129.5 0.0 0.0 0 Consumer credit -783
|
|
435112 5714514 11 Closed currency 1 -1181 0 -875.0 -872.0 0 44419.5 0.0 0.0 0 Consumer credit -872
|
|
435112 5714516 11 Closed currency 1 -1475 0 -1293.0 -1322.0 0 21690 0.0 0 Consumer credit -1322
|
|
435112 5714517 11 Closed currency 1 -1411 0 -861.0 -861.0 0 85293 0.0 0 Consumer credit -855
|
|
435112 5714518 11 Active currency 1 -1483 0 0 200250 0.0 0 Credit card -848
|
|
435112 5714519 11 Closed currency 1 -1589 0 -1344.0 -1292.0 3980.52 0 100129.5 0.0 0.0 0 Consumer credit -736
|
|
435112 5714520 11 Closed currency 1 -829 0 -508.0 -508.0 0.0 0 159386.085 0.0 0.0 0 Consumer credit -508
|
|
435112 5714521 11 Closed currency 1 -739 0 -525.0 -525.0 0.0 0 48645 0.0 0.0 0 Consumer credit -519
|
|
435112 5714522 11 Active currency 1 -508 0 1318.0 0.0 0 1058823.54 858768.57 0.0 0 Consumer credit -7
|
|
435112 5714523 11 Active currency 1 -416 0 680.0 0.0 0 256500 183528.0 0.0 0 Consumer credit -43
|
|
444864 5714635 12 Closed currency 1 -2209 0 -2086.0 -2115.0 0.0 0 16645.5 0.0 0.0 0 Consumer credit -2115
|
|
444864 5714636 12 Closed currency 1 -2130 0 -1886.0 -1883.0 0 66600 0.0 0.0 0 Consumer credit -791
|
|
444864 5714637 12 Closed currency 1 -1125 0 -881.0 -881.0 0 82795.5 0.0 0.0 0 Consumer credit -752
|
|
444864 5714638 12 Closed currency 1 -1872 0 -1568.0 -1549.0 0 49936.5 0.0 0.0 0 Consumer credit -801
|
|
444864 5714639 12 Closed currency 1 -2030 0 31111.0 -1750.0 0 85050 0.0 0.0 0 Credit card -555
|
|
444864 5714640 12 Closed currency 1 -1776 0 -680.0 -712.0 0 157500 0.0 0.0 0 Consumer credit -188
|
|
444864 5714642 12 Closed currency 1 -1124 0 -881.0 -881.0 0 82795.5 0.0 0 Consumer credit -876
|
|
444864 5714643 12 Closed currency 1 -1871 0 -1568.0 -1568.0 0 49936.5 0.0 0 Consumer credit -820
|
|
444864 5714644 12 Closed currency 1 -2129 0 -1886.0 -1886.0 0 66600 0.0 0 Consumer credit -820
|
|
444864 5714645 12 Closed currency 1 -1416 0 -685.0 -685.0 0.0 0 182119.5 0.0 0.0 0 Consumer credit -680
|
|
444864 5714646 12 Closed currency 1 -312 0 -130.0 -130.0 0.0 0 52488 0.0 0.0 0 Consumer credit -127
|
|
444864 5714647 12 Active currency 1 -286 0 0.0 0 364500 0.0 364500.0 0 Credit card -29
|
|
452585 5714524 4 Closed currency 1 -2642 0 -2307.0 -2332.0 1800.0 0 15921 0.0 0.0 0 Consumer credit -2306
|
|
452585 5714525 4 Active currency 1 -2538 0 -1427.0 0.0 0 45000 0.0 0.0 0 Credit card -682
|
|
452585 5714527 4 Active currency 1 -42 0 -26.0 0 45000 54000.0 0.0 0 Consumer credit -31
|
|
452585 5714528 4 Closed currency 1 -2898 0 -2722.0 -2344.0 0 11340 0 Consumer credit -2344
|
|
select * from t2;
|
|
id c2 cnt c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16
|
|
119939 5714566 17 Closed currency 1 -2279 0 -1945.0 -2033.0 0.0 0 39541.5 0.0 0.0 0 Consumer credit -2033
|
|
119939 5714567 17 Closed currency 1 -2247 0 -1123.0 -1733.0 0.0 0 135000 0.0 0.0 0 Credit card -1733
|
|
119939 5714568 17 Closed currency 1 -1447 0 -331.0 -1272.0 0.0 0 99000 -2692.17 137692.17 0 Credit card -1272
|
|
119939 5714569 17 Closed currency 1 -1390 0 -331.0 -1263.0 0.0 0 135000 -149.04 135149.04 0 Credit card -1263
|
|
119939 5714570 17 Active currency 1 -1390 0 -696.0 0.0 0 4500 -2.565 2.565 0 Credit card -691
|
|
119939 5714571 17 Active currency 1 -733 0 1100.0 0.0 0 337500 242596.395 94903.605 0 Credit card -687
|
|
119939 5714573 17 Closed currency 1 -1188 0 1369.0 -1090.0 0 450000 0.0 0.0 0 Consumer credit -429
|
|
119939 5714574 17 Closed currency 1 -437 0 1389.0 -225.0 0 1226250 0.0 0.0 0 Consumer credit -194
|
|
119939 5714575 17 Closed currency 1 -944 0 335.0 -548.0 0 1215000 0.0 0.0 0 Consumer credit -513
|
|
119939 5714577 17 Active currency 1 -1102 0 4.0 0 225000 210730.5 0.0 0 Credit card -10
|
|
119939 5714578 17 Closed currency 1 -1572 0 -1179.0 -987.0 0 225000 0 Consumer credit -984
|
|
119939 5714579 17 Closed currency 1 -1791 0 -1703.0 -987.0 0 22770 0 Consumer credit -984
|
|
119939 5714580 17 Active currency 1 -2401 0 0.0 0 99000 45036.0 53962.695 0 Credit card -22
|
|
119939 5714581 17 Closed currency 1 -1624 0 203.0 -1085.0 40.5 0 765000 0 Consumer credit -1085
|
|
119939 5714582 17 Closed currency 1 -1617 0 9341.0 -1083.0 6007.5 0 144000 0 Credit card -1083
|
|
119939 5714583 17 Closed currency 1 -937 0 889.0 -156.0 0.0 0 675000 0 Consumer credit -156
|
|
119939 5714585 17 Active currency 1 -314 0 1512.0 0.0 0 900000 0 Consumer credit -40
|
|
136226 5714502 2 Active currency 1 -521 0 551.0 0 112500 0.0 0.0 0 Credit card -30
|
|
136226 5714503 2 Closed currency 1 -559 0 -355.0 0.0 0 110250 0.0 0.0 0 Credit card -351
|
|
162297 5714469 6 Closed currency 1 -1896 0 -1684.0 -1710.0 14985.0 0 76878.45 0.0 0.0 0 Consumer credit -1710
|
|
162297 5714470 6 Closed currency 1 -1146 0 -811.0 -840.0 0.0 0 103007.7 0.0 0.0 0 Consumer credit -840
|
|
162297 5714471 6 Active currency 1 -1146 0 -484.0 0.0 0 4500 0.0 0.0 0 Credit card -690
|
|
162297 5714472 6 Active currency 1 -1146 0 -180.0 0.0 0 337500 0.0 0.0 0 Credit card -690
|
|
162297 5714473 6 Closed currency 1 -2456 0 -629.0 -825.0 0 675000 0.0 0.0 0 Consumer credit -706
|
|
162297 5714474 6 Active currency 1 -277 0 5261.0 0.0 0 7033500 0 Mortgage -31
|
|
166034 5714697 8 Closed currency 1 -1283 0 -1069.0 -1083.0 3727.89 0 19399.5 0.0 0.0 0 Consumer credit -1068
|
|
166034 5714698 8 Closed currency 1 -828 0 -613.0 -642.0 13590.0 0 70692.84 0.0 0.0 0 Consumer credit -642
|
|
166034 5714699 8 Active currency 1 -828 0 916.0 0.0 0 4500 0.0 4500.0 0 Credit card -676
|
|
166034 5714700 8 Closed currency 1 -1207 0 -1021.0 -1021.0 0 93240 0.0 0.0 0 Consumer credit -981
|
|
166034 5714701 8 Active currency 1 -706 0 369.0 0 459000 483534.0 0.0 0 Credit card -4
|
|
166034 5714702 8 Active currency 1 -262 0 103.0 0 450000 174519.0 0 Consumer credit -7
|
|
166034 5714704 8 Active currency 1 -718 0 2189.205 0 45000 43357.5 1638.765 0 Credit card -22
|
|
166034 5714705 8 Closed currency 1 -612 0 -245.0 -207.0 13225.725 0 178335 0.0 0.0 0 Consumer credit -206
|
|
173404 5714710 4 Closed currency 1 -1103 0 -304.0 -303.0 0 216000 0.0 0.0 0 Credit card -303
|
|
173404 5714711 4 Closed currency 1 -1166 0 -915.0 -915.0 0 107037 0.0 0.0 0 Consumer credit -752
|
|
173404 5714712 4 Active currency 1 -45 0 320.0 0 234000 234000.0 0.0 0 Consumer credit -26
|
|
173404 5714713 4 Closed currency 1 -1165 0 -860.0 -915.0 0.0 0 107037 0.0 0.0 0 Consumer credit -825
|
|
215354 5714462 7 Closed currency 1 -497 0 -153.0 -153.0 0 91323 0.0 0 Consumer credit -131
|
|
215354 5714463 7 Active currency 1 -208 0 1075.0 0 225000 171342.0 0 Credit card -20
|
|
215354 5714464 7 Active currency 1 -203 0 528.0 0 464323.5 0 Consumer credit -16
|
|
215354 5714465 7 Active currency 1 -203 0 0 90000 0 Credit card -16
|
|
215354 5714466 7 Active currency 1 -629 0 1197.0 77674.5 0 2700000 0 Consumer credit -21
|
|
215354 5714467 7 Active currency 1 -273 0 27460.0 0.0 0 180000 71017.38 108982.62 0 Credit card -31
|
|
215354 5714468 7 Active currency 1 -43 0 79.0 0.0 0 42103.8 42103.8 0.0 0 Consumer credit -22
|
|
222183 5714491 6 Active currency 1 -784 0 1008.0 0.0 0 0 -411.615 411.615 0 Credit card -694
|
|
222183 5714492 6 Active currency 1 -774 0 625.0 0 127840.5 0.0 0.0 0 Credit card -210
|
|
222183 5714493 6 Active currency 1 -395 0 1431.0 0 1350000 1185493.5 0.0 0 Consumer credit -24
|
|
222183 5714495 6 Closed currency 1 -2744 0 -2561.0 -2559.0 310.5 0 18157.5 0 Consumer credit -2559
|
|
222183 5714496 6 Closed currency 1 -1103 0 -7.0 -343.0 20493.27 0 675000 0.0 0.0 0 Consumer credit -343
|
|
222183 5714497 6 Active currency 1 -315 0 1512.0 88821.0 0 3709552.5 0 Car loan -32
|
|
234931 5714557 6 Active currency 1 -1272 0 -667.0 0 135000 17982.0 0.0 0 Consumer credit -721
|
|
234931 5714558 6 Closed currency 1 -1602 0 -1332.0 -987.0 0 42894 0 Consumer credit -984
|
|
234931 5714559 6 Closed currency 1 -1273 0 -667.0 -649.0 0 135000 0 Consumer credit -643
|
|
234931 5714560 6 Closed currency 1 -371 0 -130.0 -130.0 0 63522 0.0 0 Consumer credit -110
|
|
234931 5714561 6 Closed currency 1 -2638 0 -1208.0 -1518.0 18293.265 0 1143000 0.0 0.0 0 Car loan -704
|
|
234931 5714562 6 Closed currency 1 -1495 0 -635.0 -40.0 12618.0 0 46831.5 0 Consumer credit -34
|
|
238881 5714482 7 Closed currency 1 -318 0 -187.0 -187.0 0 0 0.0 0.0 0 Credit card -185
|
|
238881 5714484 7 Closed currency 1 -2911 0 -2607.0 -2604.0 0 48555 0 Consumer credit -2601
|
|
238881 5714485 7 Closed currency 1 -2148 0 -1595.0 -987.0 0 135000 0 Consumer credit -984
|
|
238881 5714486 7 Active currency 1 -381 0 0 450000 520920.0 0 Consumer credit -4
|
|
238881 5714487 7 Active currency 1 -95 0 1720.0 0 67500 8131.5 0 Credit card -7
|
|
238881 5714488 7 Closed currency 1 -444 0 -77.0 -77.0 0.0 0 107184.06 0.0 0.0 0 Consumer credit -71
|
|
238881 5714489 7 Active currency 1 -392 0 0.0 0 252000 23679.0 228320.1 0 Credit card -22
|
|
241216 5714692 2 Closed currency 1 -259 0 -139.0 -230.0 0.0 0 10464.435 0.0 0.0 0 Consumer credit -227
|
|
241216 5714693 2 Active currency 1 -199 0 -14.0 0.0 0 40810.5 8055.0 0.0 0 Consumer credit -22
|
|
242993 5714537 13 Closed currency 1 -2785 0 -958.0 -1769.0 0 225000 0.0 0.0 0 Consumer credit -908
|
|
242993 5714538 13 Closed currency 1 -683 0 -654.0 -654.0 0 40500 0.0 0.0 0 Consumer credit -624
|
|
242993 5714539 13 Closed currency 1 -744 0 -717.0 -717.0 0 45000 0.0 0.0 0 Consumer credit -624
|
|
242993 5714541 13 Closed currency 1 -801 0 -773.0 -773.0 0 45000 0.0 0.0 0 Consumer credit -624
|
|
242993 5714542 13 Closed currency 1 -1841 0 -1473.0 -1466.0 0 225000 0.0 0.0 0 Consumer credit -1195
|
|
242993 5714543 13 Active currency 1 -2237 0 -1868.0 0 135000 0 Consumer credit -1874
|
|
242993 5714544 13 Closed currency 1 -1201 0 -1081.0 -987.0 0 157500 0 Consumer credit -984
|
|
242993 5714545 13 Closed currency 1 -1844 0 -1473.0 -987.0 0 225000 0 Consumer credit -984
|
|
242993 5714547 13 Closed currency 1 -705 0 -614.0 -586.0 0 158566.5 0 Consumer credit -580
|
|
242993 5714548 13 Closed currency 1 -605 0 -577.0 -577.0 0 13500 0 Consumer credit -572
|
|
242993 5714549 13 Closed currency 1 -564 0 -535.0 -535.0 0 45000 0 Consumer credit -531
|
|
242993 5714550 13 Active currency 1 -382 0 1464.0 0 58500 59809.5 0 Credit card -341
|
|
242993 5714551 13 Closed currency 1 -865 0 -742.0 -833.0 0.0 0 29250 0.0 0.0 0 Consumer credit -833
|
|
253882 5714648 4 Closed currency 1 -1341 0 -241.0 -749.0 0 0 0.0 0 Credit card -747
|
|
253882 5714649 4 Active currency 1 -758 0 1095.0 0 315000 54895.5 0 Credit card 0
|
|
253882 5714650 4 Closed currency 1 -1531 0 -800.0 -805.0 0.0 0 138987 0.0 0.0 0 Consumer credit -805
|
|
253882 5714651 4 Closed currency 1 -770 0 -467.0 -467.0 0.0 0 50301 0.0 0.0 0 Consumer credit -463
|
|
280788 5714715 4 Active currency 1 -221 0 875.0 0 220675.5 0 Consumer credit -30
|
|
280788 5714716 4 Active currency 1 -221 0 0 90000 0 Credit card -9
|
|
280788 5714717 4 Active currency 1 -728 0 2.0 3520.8 0 112500 5926.5 0.0 0 Consumer credit -27
|
|
280788 5714718 4 Closed currency 1 -637 0 -120.0 -120.0 1856.34 0 56532.645 0.0 0.0 0 Consumer credit -120
|
|
286014 5714690 1 Active currency 1 -137 0 27460.0 0.0 0 22500 18765.63 76.59 0 Credit card -31
|
|
293201 5714620 5 Closed currency 1 -2730 0 -2454.0 -2514.0 0.0 0 14058 0.0 0.0 0 Consumer credit -2514
|
|
293201 5714621 5 Closed currency 1 -2389 0 -1365.0 -1780.0 11250.0 0 225000 -701.28 225701.28 0 Credit card -1780
|
|
293201 5714622 5 Closed currency 1 -2255 0 -1982.0 -1987.0 6492.42 0 46033.92 0.0 0.0 0 Consumer credit -1981
|
|
293201 5714624 5 Active currency 1 -1425 0 -757.0 0.0 0 4500 0.0 4500.0 0 Credit card -695
|
|
293201 5714625 5 Closed currency 1 -2540 0 -713.0 -2209.0 0 360000 0.0 0.0 0 Consumer credit -1261
|
|
303740 5714552 4 Closed currency 1 -1423 0 -1119.0 -1118.0 0 79744.5 0.0 0.0 0 Consumer credit -1118
|
|
303740 5714553 4 Closed currency 1 -666 0 -574.0 -574.0 0.0 0 36916.56 0.0 0.0 0 Consumer credit -568
|
|
303740 5714554 4 Active currency 1 -581 0 0.0 0 384750 263056.5 121690.17 0 Credit card -22
|
|
303740 5714555 4 Closed currency 1 -433 0 -320.0 -320.0 0.0 0 67500 0.0 0.0 0 Consumer credit -316
|
|
311918 5714563 2 Closed currency 1 -2904 0 -2723.0 -2723.0 0 32899.5 0.0 0 Consumer credit -2723
|
|
311918 5714564 2 Active currency 1 -146 0 37.0 0.0 0 59085 20835.0 0.0 0 Consumer credit -24
|
|
335122 5714653 5 Closed currency 1 -1189 0 -109.0 -874.0 0 225000 0.0 0.0 0 Consumer credit -860
|
|
335122 5714654 5 Closed currency 1 -2426 0 -600.0 -556.0 0 540000 0.0 0.0 0 Consumer credit -188
|
|
335122 5714655 5 Active currency 1 -644 0 1182.0 0 900000 0 Consumer credit -30
|
|
335122 5714656 5 Active currency 1 -885 0 210.0 0 900000 0 Consumer credit -30
|
|
335122 5714657 5 Closed currency 1 -2740 0 -2434.0 -2496.0 0.0 0 54000 0.0 0.0 0 Consumer credit -2494
|
|
338464 5714626 8 Closed currency 1 -2655 0 -2319.0 -2348.0 0.0 0 20165.4 0.0 0.0 0 Consumer credit -831
|
|
338464 5714627 8 Closed currency 1 -2539 0 -1427.0 -651.0 0.0 0 45000 0.0 0.0 0 Credit card -651
|
|
338464 5714628 8 Closed currency 1 -2343 0 -2008.0 -2219.0 0.0 0 19192.5 0.0 0.0 0 Consumer credit -2219
|
|
338464 5714629 8 Closed currency 1 -857 0 -523.0 -582.0 3285.0 0 33853.5 0.0 0.0 0 Consumer credit -582
|
|
338464 5714630 8 Active currency 1 -857 0 765.0 1704.78 0 45000 38294.37 6705.63 0 Credit card -675
|
|
338464 5714631 8 Active currency 1 -1131 0 -27.0 0 270000 0.0 0.0 0 Credit card -17
|
|
338464 5714633 8 Closed currency 1 -1706 0 -976.0 -1260.0 0 247500 0.0 0.0 0 Consumer credit -538
|
|
338464 5714634 8 Active currency 1 -140 0 0.0 0 144000 143019.0 980.28 0 Credit card -22
|
|
351919 5714658 1 Active currency 1 -769 0 1057.0 0 409500 295542.0 0.0 0 Consumer credit -14
|
|
373324 5714674 14 Active currency 1 -837 0 -453.0 0.0 0 0 -45.36 45.36 0 Credit card -685
|
|
373324 5714675 14 Active currency 1 -341 0 -160.0 0.0 0 63496.17 63496.17 0.0 0 Consumer credit -234
|
|
373324 5714676 14 Closed currency 1 -586 0 -402.0 -402.0 0 90180 0.0 0.0 0 Consumer credit -400
|
|
373324 5714677 14 Closed currency 1 -1439 0 -1134.0 -1123.0 0 60399 0.0 0.0 0 Consumer credit -775
|
|
373324 5714679 14 Active currency 1 -577 0 521.0 0 225000 45324.0 0.0 0 Credit card -25
|
|
373324 5714681 14 Closed currency 1 -2819 0 -2516.0 -2516.0 0 24903 0.0 0 Consumer credit -2516
|
|
373324 5714682 14 Closed currency 1 -2673 0 -2307.0 -2307.0 0 31788 0.0 0 Consumer credit -2307
|
|
373324 5714683 14 Closed currency 1 -1438 0 -1134.0 -1153.0 0 60399 0.0 0 Consumer credit -1128
|
|
373324 5714684 14 Closed currency 1 -1913 0 -1609.0 -1609.0 0 53410.5 0.0 0 Consumer credit -1128
|
|
373324 5714685 14 Closed currency 1 -1593 0 -1109.0 -987.0 0 79456.5 0 Consumer credit -984
|
|
373324 5714686 14 Closed currency 1 -986 0 -805.0 -740.0 0 68850 0 Consumer credit -738
|
|
373324 5714687 14 Closed currency 1 -2455 0 -2273.0 -1925.0 0.0 0 31410 0.0 0.0 0 Consumer credit -1924
|
|
373324 5714688 14 Closed currency 1 -2216 0 -2121.0 -2095.0 0.0 0 20002.5 0.0 0.0 0 Consumer credit -2095
|
|
373324 5714689 14 Closed currency 1 -1805 0 -320.0 0.0 0 13500 0.0 0.0 0 Credit card -229
|
|
387080 5714598 14 Closed currency 1 -983 0 -623.0 -900.0 0 52987.5 0.0 0.0 0 Consumer credit -802
|
|
387080 5714600 14 Closed currency 1 -1104 0 -738.0 -731.0 0 194400 0.0 0.0 0 Consumer credit -731
|
|
387080 5714601 14 Closed currency 1 -1766 0 -1219.0 -1256.0 0 135000 0.0 0.0 0 Consumer credit -1252
|
|
387080 5714602 14 Active currency 1 -1082 0 745.0 0 197820 105840.0 0.0 0 Consumer credit -10
|
|
387080 5714603 14 Active currency 1 -1239 0 -149.0 0 225000 185953.5 0.0 0 Credit card -10
|
|
387080 5714604 14 Active currency 1 -681 0 1145.0 0 328500 244791.0 0.0 0 Consumer credit -10
|
|
387080 5714606 14 Closed currency 1 -2897 0 -2350.0 -2357.0 0 67500 0 Consumer credit -2357
|
|
387080 5714607 14 Closed currency 1 -1603 0 -1299.0 -1087.0 0 70335 0.0 0 Consumer credit -1087
|
|
387080 5714608 14 Closed currency 1 -2093 0 -1949.0 -987.0 0 44968.5 0 Consumer credit -984
|
|
387080 5714609 14 Active currency 1 -69 0 263.0 0 84361.5 0 Consumer credit -6
|
|
387080 5714610 14 Closed currency 1 -2299 0 -1932.0 -1932.0 0.0 0 72600.75 0.0 0.0 0 Consumer credit -1603
|
|
387080 5714611 14 Closed currency 1 -549 0 -364.0 -488.0 0.0 0 37935 0.0 0.0 0 Consumer credit -486
|
|
387080 5714612 14 Closed currency 1 -388 0 -21.0 -84.0 0.0 0 98446.5 0.0 0.0 0 Consumer credit -84
|
|
387080 5714614 14 Active currency 1 -18 0 378.0 0.0 0 76500 76500.0 0.0 0 Consumer credit -14
|
|
388421 5714587 4 Active currency 1 -685 0 410.0 0.0 0 135000 0.0 135000.0 0 Credit card -236
|
|
388421 5714590 4 Closed currency 1 -325 0 223.0 -112.0 0 87286.5 0.0 0.0 0 Consumer credit -106
|
|
388421 5714591 4 Active currency 1 -674 0 1152.0 0 868500 662139.0 0.0 0 Consumer credit -25
|
|
388421 5714593 4 Active currency 1 -378 0 1449.0 0.0 0 991800 0 Consumer credit -31
|
|
389074 5714667 3 Closed currency 1 -957 0 -342.0 -341.0 0 13500 0.0 0.0 0 Credit card -334
|
|
389074 5714668 3 Closed currency 1 -705 0 -433.0 -404.0 0 135729 0 Consumer credit -398
|
|
389074 5714669 3 Closed currency 1 -1049 0 -378.0 -378.0 0.0 0 113496.885 0.0 0.0 0 Consumer credit -372
|
|
389599 5714529 7 Closed currency 1 -672 0 10285.0 -531.0 0 135000 0.0 0.0 0 Credit card -429
|
|
389599 5714530 7 Closed currency 1 -1304 0 1253.0 -1287.0 0 225000 0.0 0.0 0 Consumer credit -429
|
|
389599 5714531 7 Closed currency 1 -1253 0 -887.0 -887.0 0 43105.5 0.0 0.0 0 Consumer credit -687
|
|
389599 5714532 7 Closed currency 1 -1130 0 331.0 -858.0 0 450000 0.0 0.0 0 Consumer credit -847
|
|
389599 5714533 7 Active currency 1 -831 0 277.0 0 270000 274225.5 0.0 0 Credit card -10
|
|
389599 5714534 7 Active currency 1 -329 0 1497.0 0 589500 521478.0 0.0 0 Consumer credit -8
|
|
389599 5714536 7 Closed currency 1 -700 0 -600.0 -600.0 0.0 0 68715 0.0 0.0 0 Consumer credit -596
|
|
399459 5714708 2 Closed currency 1 -1141 0 -837.0 -784.0 0 113359.5 0 Consumer credit -781
|
|
399459 5714709 2 Active currency 1 -49 0 316.0 0.0 0 24763.5 22968.0 0.0 0 Consumer credit -19
|
|
400486 5714504 5 Closed currency 1 -2413 0 -1864.0 -2128.0 0 180000 0.0 0.0 0 Consumer credit -708
|
|
400486 5714506 5 Active currency 1 -941 0 -17.0 0 40500 0.0 0.0 0 Credit card -15
|
|
400486 5714507 5 Closed currency 1 -1110 0 -745.0 -727.0 0 114727.5 0.0 0.0 0 Consumer credit -658
|
|
400486 5714508 5 Closed currency 1 -2133 0 -1038.0 -1127.0 0 225000 0.0 0.0 0 Consumer credit -708
|
|
400486 5714509 5 Active currency 1 -391 0 705.0 0 142290 108315.0 0.0 0 Consumer credit -30
|
|
402440 5714475 1 Active currency 1 -96 0 269.0 0.0 0 89910 76905.0 0.0 0 Consumer credit -22
|
|
406724 5714661 4 Closed currency 1 -1293 0 -1155.0 -1155.0 0 13500 0.0 0.0 0 Credit card -775
|
|
406724 5714662 4 Closed currency 1 -1433 0 -1251.0 -1245.0 0 23067 0.0 0.0 0 Consumer credit -783
|
|
406724 5714663 4 Closed currency 1 -1432 0 -1251.0 -1251.0 0 23067 0.0 0 Consumer credit -1142
|
|
406724 5714665 4 Active currency 1 -167 0 1298.0 0.0 0 606496.995 574827.21 0.0 0 Consumer credit -5
|
|
419892 5714594 4 Closed currency 1 -1697 0 -1148.0 -1148.0 0 70695 0.0 0.0 0 Consumer credit -696
|
|
419892 5714595 4 Closed currency 1 -1238 0 -878.0 -1120.0 0 22320 0.0 0.0 0 Consumer credit -1119
|
|
419892 5714596 4 Active currency 1 -381 0 0 2767500 2739622.5 0 Mortgage -27
|
|
419892 5714597 4 Closed currency 1 -584 0 511.0 -405.0 0.0 0 238603.5 0.0 0.0 0 Consumer credit -405
|
|
426155 5714498 4 Closed currency 1 -1331 0 -994.0 -1023.0 1350.0 0 39433.5 0.0 0.0 0 Consumer credit -1023
|
|
426155 5714499 4 Closed currency 1 -2534 0 -2352.0 -2347.0 0 38830.5 0.0 0.0 0 Consumer credit -2345
|
|
426155 5714500 4 Closed currency 1 -845 0 -480.0 -480.0 0.0 0 67500 0.0 0.0 0 Consumer credit -480
|
|
426155 5714501 4 Closed currency 1 -529 0 -343.0 -343.0 0.0 0 182791.44 0.0 0.0 0 Consumer credit -337
|
|
435112 5714512 11 Closed currency 1 -1412 0 -861.0 -849.0 0 85288.5 0.0 0.0 0 Consumer credit -753
|
|
435112 5714513 11 Closed currency 1 -1590 0 -1344.0 -1276.0 0 100129.5 0.0 0.0 0 Consumer credit -783
|
|
435112 5714514 11 Closed currency 1 -1181 0 -875.0 -872.0 0 44419.5 0.0 0.0 0 Consumer credit -872
|
|
435112 5714516 11 Closed currency 1 -1475 0 -1293.0 -1322.0 0 21690 0.0 0 Consumer credit -1322
|
|
435112 5714517 11 Closed currency 1 -1411 0 -861.0 -861.0 0 85293 0.0 0 Consumer credit -855
|
|
435112 5714518 11 Active currency 1 -1483 0 0 200250 0.0 0 Credit card -848
|
|
435112 5714519 11 Closed currency 1 -1589 0 -1344.0 -1292.0 3980.52 0 100129.5 0.0 0.0 0 Consumer credit -736
|
|
435112 5714520 11 Closed currency 1 -829 0 -508.0 -508.0 0.0 0 159386.085 0.0 0.0 0 Consumer credit -508
|
|
435112 5714521 11 Closed currency 1 -739 0 -525.0 -525.0 0.0 0 48645 0.0 0.0 0 Consumer credit -519
|
|
435112 5714522 11 Active currency 1 -508 0 1318.0 0.0 0 1058823.54 858768.57 0.0 0 Consumer credit -7
|
|
435112 5714523 11 Active currency 1 -416 0 680.0 0.0 0 256500 183528.0 0.0 0 Consumer credit -43
|
|
444864 5714635 12 Closed currency 1 -2209 0 -2086.0 -2115.0 0.0 0 16645.5 0.0 0.0 0 Consumer credit -2115
|
|
444864 5714636 12 Closed currency 1 -2130 0 -1886.0 -1883.0 0 66600 0.0 0.0 0 Consumer credit -791
|
|
444864 5714637 12 Closed currency 1 -1125 0 -881.0 -881.0 0 82795.5 0.0 0.0 0 Consumer credit -752
|
|
444864 5714638 12 Closed currency 1 -1872 0 -1568.0 -1549.0 0 49936.5 0.0 0.0 0 Consumer credit -801
|
|
444864 5714639 12 Closed currency 1 -2030 0 31111.0 -1750.0 0 85050 0.0 0.0 0 Credit card -555
|
|
444864 5714640 12 Closed currency 1 -1776 0 -680.0 -712.0 0 157500 0.0 0.0 0 Consumer credit -188
|
|
444864 5714642 12 Closed currency 1 -1124 0 -881.0 -881.0 0 82795.5 0.0 0 Consumer credit -876
|
|
444864 5714643 12 Closed currency 1 -1871 0 -1568.0 -1568.0 0 49936.5 0.0 0 Consumer credit -820
|
|
444864 5714644 12 Closed currency 1 -2129 0 -1886.0 -1886.0 0 66600 0.0 0 Consumer credit -820
|
|
444864 5714645 12 Closed currency 1 -1416 0 -685.0 -685.0 0.0 0 182119.5 0.0 0.0 0 Consumer credit -680
|
|
444864 5714646 12 Closed currency 1 -312 0 -130.0 -130.0 0.0 0 52488 0.0 0.0 0 Consumer credit -127
|
|
444864 5714647 12 Active currency 1 -286 0 0.0 0 364500 0.0 364500.0 0 Credit card -29
|
|
452585 5714524 4 Closed currency 1 -2642 0 -2307.0 -2332.0 1800.0 0 15921 0.0 0.0 0 Consumer credit -2306
|
|
452585 5714525 4 Active currency 1 -2538 0 -1427.0 0.0 0 45000 0.0 0.0 0 Credit card -682
|
|
452585 5714527 4 Active currency 1 -42 0 -26.0 0 45000 54000.0 0.0 0 Consumer credit -31
|
|
452585 5714528 4 Closed currency 1 -2898 0 -2722.0 -2344.0 0 11340 0 Consumer credit -2344
|
|
select * from t3;
|
|
id c2 cnt c3 c4 c5 c6 c7 c8 c9 c10 c11 c12 c13 c14 c15 c16
|
|
119939 5714566 17 Closed currency 1 -2279 0 -1945.0 -2033.0 0.0 0 39541.5 0.0 0.0 0 Consumer credit -2033
|
|
119939 5714567 17 Closed currency 1 -2247 0 -1123.0 -1733.0 0.0 0 135000 0.0 0.0 0 Credit card -1733
|
|
119939 5714568 17 Closed currency 1 -1447 0 -331.0 -1272.0 0.0 0 99000 -2692.17 137692.17 0 Credit card -1272
|
|
119939 5714569 17 Closed currency 1 -1390 0 -331.0 -1263.0 0.0 0 135000 -149.04 135149.04 0 Credit card -1263
|
|
119939 5714570 17 Active currency 1 -1390 0 -696.0 0.0 0 4500 -2.565 2.565 0 Credit card -691
|
|
119939 5714571 17 Active currency 1 -733 0 1100.0 0.0 0 337500 242596.395 94903.605 0 Credit card -687
|
|
119939 5714573 17 Closed currency 1 -1188 0 1369.0 -1090.0 0 450000 0.0 0.0 0 Consumer credit -429
|
|
119939 5714574 17 Closed currency 1 -437 0 1389.0 -225.0 0 1226250 0.0 0.0 0 Consumer credit -194
|
|
119939 5714575 17 Closed currency 1 -944 0 335.0 -548.0 0 1215000 0.0 0.0 0 Consumer credit -513
|
|
119939 5714577 17 Active currency 1 -1102 0 4.0 0 225000 210730.5 0.0 0 Credit card -10
|
|
119939 5714578 17 Closed currency 1 -1572 0 -1179.0 -987.0 0 225000 0 Consumer credit -984
|
|
119939 5714579 17 Closed currency 1 -1791 0 -1703.0 -987.0 0 22770 0 Consumer credit -984
|
|
119939 5714580 17 Active currency 1 -2401 0 0.0 0 99000 45036.0 53962.695 0 Credit card -22
|
|
119939 5714581 17 Closed currency 1 -1624 0 203.0 -1085.0 40.5 0 765000 0 Consumer credit -1085
|
|
119939 5714582 17 Closed currency 1 -1617 0 9341.0 -1083.0 6007.5 0 144000 0 Credit card -1083
|
|
119939 5714583 17 Closed currency 1 -937 0 889.0 -156.0 0.0 0 675000 0 Consumer credit -156
|
|
119939 5714585 17 Active currency 1 -314 0 1512.0 0.0 0 900000 0 Consumer credit -40
|
|
136226 5714502 2 Active currency 1 -521 0 551.0 0 112500 0.0 0.0 0 Credit card -30
|
|
136226 5714503 2 Closed currency 1 -559 0 -355.0 0.0 0 110250 0.0 0.0 0 Credit card -351
|
|
162297 5714469 6 Closed currency 1 -1896 0 -1684.0 -1710.0 14985.0 0 76878.45 0.0 0.0 0 Consumer credit -1710
|
|
162297 5714470 6 Closed currency 1 -1146 0 -811.0 -840.0 0.0 0 103007.7 0.0 0.0 0 Consumer credit -840
|
|
162297 5714471 6 Active currency 1 -1146 0 -484.0 0.0 0 4500 0.0 0.0 0 Credit card -690
|
|
162297 5714472 6 Active currency 1 -1146 0 -180.0 0.0 0 337500 0.0 0.0 0 Credit card -690
|
|
162297 5714473 6 Closed currency 1 -2456 0 -629.0 -825.0 0 675000 0.0 0.0 0 Consumer credit -706
|
|
162297 5714474 6 Active currency 1 -277 0 5261.0 0.0 0 7033500 0 Mortgage -31
|
|
166034 5714697 8 Closed currency 1 -1283 0 -1069.0 -1083.0 3727.89 0 19399.5 0.0 0.0 0 Consumer credit -1068
|
|
166034 5714698 8 Closed currency 1 -828 0 -613.0 -642.0 13590.0 0 70692.84 0.0 0.0 0 Consumer credit -642
|
|
166034 5714699 8 Active currency 1 -828 0 916.0 0.0 0 4500 0.0 4500.0 0 Credit card -676
|
|
166034 5714700 8 Closed currency 1 -1207 0 -1021.0 -1021.0 0 93240 0.0 0.0 0 Consumer credit -981
|
|
166034 5714701 8 Active currency 1 -706 0 369.0 0 459000 483534.0 0.0 0 Credit card -4
|
|
166034 5714702 8 Active currency 1 -262 0 103.0 0 450000 174519.0 0 Consumer credit -7
|
|
166034 5714704 8 Active currency 1 -718 0 2189.205 0 45000 43357.5 1638.765 0 Credit card -22
|
|
166034 5714705 8 Closed currency 1 -612 0 -245.0 -207.0 13225.725 0 178335 0.0 0.0 0 Consumer credit -206
|
|
173404 5714710 4 Closed currency 1 -1103 0 -304.0 -303.0 0 216000 0.0 0.0 0 Credit card -303
|
|
173404 5714711 4 Closed currency 1 -1166 0 -915.0 -915.0 0 107037 0.0 0.0 0 Consumer credit -752
|
|
173404 5714712 4 Active currency 1 -45 0 320.0 0 234000 234000.0 0.0 0 Consumer credit -26
|
|
173404 5714713 4 Closed currency 1 -1165 0 -860.0 -915.0 0.0 0 107037 0.0 0.0 0 Consumer credit -825
|
|
215354 5714462 7 Closed currency 1 -497 0 -153.0 -153.0 0 91323 0.0 0 Consumer credit -131
|
|
215354 5714463 7 Active currency 1 -208 0 1075.0 0 225000 171342.0 0 Credit card -20
|
|
215354 5714464 7 Active currency 1 -203 0 528.0 0 464323.5 0 Consumer credit -16
|
|
215354 5714465 7 Active currency 1 -203 0 0 90000 0 Credit card -16
|
|
215354 5714466 7 Active currency 1 -629 0 1197.0 77674.5 0 2700000 0 Consumer credit -21
|
|
215354 5714467 7 Active currency 1 -273 0 27460.0 0.0 0 180000 71017.38 108982.62 0 Credit card -31
|
|
215354 5714468 7 Active currency 1 -43 0 79.0 0.0 0 42103.8 42103.8 0.0 0 Consumer credit -22
|
|
222183 5714491 6 Active currency 1 -784 0 1008.0 0.0 0 0 -411.615 411.615 0 Credit card -694
|
|
222183 5714492 6 Active currency 1 -774 0 625.0 0 127840.5 0.0 0.0 0 Credit card -210
|
|
222183 5714493 6 Active currency 1 -395 0 1431.0 0 1350000 1185493.5 0.0 0 Consumer credit -24
|
|
222183 5714495 6 Closed currency 1 -2744 0 -2561.0 -2559.0 310.5 0 18157.5 0 Consumer credit -2559
|
|
222183 5714496 6 Closed currency 1 -1103 0 -7.0 -343.0 20493.27 0 675000 0.0 0.0 0 Consumer credit -343
|
|
222183 5714497 6 Active currency 1 -315 0 1512.0 88821.0 0 3709552.5 0 Car loan -32
|
|
234931 5714557 6 Active currency 1 -1272 0 -667.0 0 135000 17982.0 0.0 0 Consumer credit -721
|
|
234931 5714558 6 Closed currency 1 -1602 0 -1332.0 -987.0 0 42894 0 Consumer credit -984
|
|
234931 5714559 6 Closed currency 1 -1273 0 -667.0 -649.0 0 135000 0 Consumer credit -643
|
|
234931 5714560 6 Closed currency 1 -371 0 -130.0 -130.0 0 63522 0.0 0 Consumer credit -110
|
|
234931 5714561 6 Closed currency 1 -2638 0 -1208.0 -1518.0 18293.265 0 1143000 0.0 0.0 0 Car loan -704
|
|
234931 5714562 6 Closed currency 1 -1495 0 -635.0 -40.0 12618.0 0 46831.5 0 Consumer credit -34
|
|
238881 5714482 7 Closed currency 1 -318 0 -187.0 -187.0 0 0 0.0 0.0 0 Credit card -185
|
|
238881 5714484 7 Closed currency 1 -2911 0 -2607.0 -2604.0 0 48555 0 Consumer credit -2601
|
|
238881 5714485 7 Closed currency 1 -2148 0 -1595.0 -987.0 0 135000 0 Consumer credit -984
|
|
238881 5714486 7 Active currency 1 -381 0 0 450000 520920.0 0 Consumer credit -4
|
|
238881 5714487 7 Active currency 1 -95 0 1720.0 0 67500 8131.5 0 Credit card -7
|
|
238881 5714488 7 Closed currency 1 -444 0 -77.0 -77.0 0.0 0 107184.06 0.0 0.0 0 Consumer credit -71
|
|
238881 5714489 7 Active currency 1 -392 0 0.0 0 252000 23679.0 228320.1 0 Credit card -22
|
|
241216 5714692 2 Closed currency 1 -259 0 -139.0 -230.0 0.0 0 10464.435 0.0 0.0 0 Consumer credit -227
|
|
241216 5714693 2 Active currency 1 -199 0 -14.0 0.0 0 40810.5 8055.0 0.0 0 Consumer credit -22
|
|
242993 5714537 13 Closed currency 1 -2785 0 -958.0 -1769.0 0 225000 0.0 0.0 0 Consumer credit -908
|
|
242993 5714538 13 Closed currency 1 -683 0 -654.0 -654.0 0 40500 0.0 0.0 0 Consumer credit -624
|
|
242993 5714539 13 Closed currency 1 -744 0 -717.0 -717.0 0 45000 0.0 0.0 0 Consumer credit -624
|
|
242993 5714541 13 Closed currency 1 -801 0 -773.0 -773.0 0 45000 0.0 0.0 0 Consumer credit -624
|
|
242993 5714542 13 Closed currency 1 -1841 0 -1473.0 -1466.0 0 225000 0.0 0.0 0 Consumer credit -1195
|
|
242993 5714543 13 Active currency 1 -2237 0 -1868.0 0 135000 0 Consumer credit -1874
|
|
242993 5714544 13 Closed currency 1 -1201 0 -1081.0 -987.0 0 157500 0 Consumer credit -984
|
|
242993 5714545 13 Closed currency 1 -1844 0 -1473.0 -987.0 0 225000 0 Consumer credit -984
|
|
242993 5714547 13 Closed currency 1 -705 0 -614.0 -586.0 0 158566.5 0 Consumer credit -580
|
|
242993 5714548 13 Closed currency 1 -605 0 -577.0 -577.0 0 13500 0 Consumer credit -572
|
|
242993 5714549 13 Closed currency 1 -564 0 -535.0 -535.0 0 45000 0 Consumer credit -531
|
|
242993 5714550 13 Active currency 1 -382 0 1464.0 0 58500 59809.5 0 Credit card -341
|
|
242993 5714551 13 Closed currency 1 -865 0 -742.0 -833.0 0.0 0 29250 0.0 0.0 0 Consumer credit -833
|
|
253882 5714648 4 Closed currency 1 -1341 0 -241.0 -749.0 0 0 0.0 0 Credit card -747
|
|
253882 5714649 4 Active currency 1 -758 0 1095.0 0 315000 54895.5 0 Credit card 0
|
|
253882 5714650 4 Closed currency 1 -1531 0 -800.0 -805.0 0.0 0 138987 0.0 0.0 0 Consumer credit -805
|
|
253882 5714651 4 Closed currency 1 -770 0 -467.0 -467.0 0.0 0 50301 0.0 0.0 0 Consumer credit -463
|
|
280788 5714715 4 Active currency 1 -221 0 875.0 0 220675.5 0 Consumer credit -30
|
|
280788 5714716 4 Active currency 1 -221 0 0 90000 0 Credit card -9
|
|
280788 5714717 4 Active currency 1 -728 0 2.0 3520.8 0 112500 5926.5 0.0 0 Consumer credit -27
|
|
280788 5714718 4 Closed currency 1 -637 0 -120.0 -120.0 1856.34 0 56532.645 0.0 0.0 0 Consumer credit -120
|
|
286014 5714690 1 Active currency 1 -137 0 27460.0 0.0 0 22500 18765.63 76.59 0 Credit card -31
|
|
293201 5714620 5 Closed currency 1 -2730 0 -2454.0 -2514.0 0.0 0 14058 0.0 0.0 0 Consumer credit -2514
|
|
293201 5714621 5 Closed currency 1 -2389 0 -1365.0 -1780.0 11250.0 0 225000 -701.28 225701.28 0 Credit card -1780
|
|
293201 5714622 5 Closed currency 1 -2255 0 -1982.0 -1987.0 6492.42 0 46033.92 0.0 0.0 0 Consumer credit -1981
|
|
293201 5714624 5 Active currency 1 -1425 0 -757.0 0.0 0 4500 0.0 4500.0 0 Credit card -695
|
|
293201 5714625 5 Closed currency 1 -2540 0 -713.0 -2209.0 0 360000 0.0 0.0 0 Consumer credit -1261
|
|
303740 5714552 4 Closed currency 1 -1423 0 -1119.0 -1118.0 0 79744.5 0.0 0.0 0 Consumer credit -1118
|
|
303740 5714553 4 Closed currency 1 -666 0 -574.0 -574.0 0.0 0 36916.56 0.0 0.0 0 Consumer credit -568
|
|
303740 5714554 4 Active currency 1 -581 0 0.0 0 384750 263056.5 121690.17 0 Credit card -22
|
|
303740 5714555 4 Closed currency 1 -433 0 -320.0 -320.0 0.0 0 67500 0.0 0.0 0 Consumer credit -316
|
|
311918 5714563 2 Closed currency 1 -2904 0 -2723.0 -2723.0 0 32899.5 0.0 0 Consumer credit -2723
|
|
311918 5714564 2 Active currency 1 -146 0 37.0 0.0 0 59085 20835.0 0.0 0 Consumer credit -24
|
|
335122 5714653 5 Closed currency 1 -1189 0 -109.0 -874.0 0 225000 0.0 0.0 0 Consumer credit -860
|
|
335122 5714654 5 Closed currency 1 -2426 0 -600.0 -556.0 0 540000 0.0 0.0 0 Consumer credit -188
|
|
335122 5714655 5 Active currency 1 -644 0 1182.0 0 900000 0 Consumer credit -30
|
|
335122 5714656 5 Active currency 1 -885 0 210.0 0 900000 0 Consumer credit -30
|
|
335122 5714657 5 Closed currency 1 -2740 0 -2434.0 -2496.0 0.0 0 54000 0.0 0.0 0 Consumer credit -2494
|
|
338464 5714626 8 Closed currency 1 -2655 0 -2319.0 -2348.0 0.0 0 20165.4 0.0 0.0 0 Consumer credit -831
|
|
338464 5714627 8 Closed currency 1 -2539 0 -1427.0 -651.0 0.0 0 45000 0.0 0.0 0 Credit card -651
|
|
338464 5714628 8 Closed currency 1 -2343 0 -2008.0 -2219.0 0.0 0 19192.5 0.0 0.0 0 Consumer credit -2219
|
|
338464 5714629 8 Closed currency 1 -857 0 -523.0 -582.0 3285.0 0 33853.5 0.0 0.0 0 Consumer credit -582
|
|
338464 5714630 8 Active currency 1 -857 0 765.0 1704.78 0 45000 38294.37 6705.63 0 Credit card -675
|
|
338464 5714631 8 Active currency 1 -1131 0 -27.0 0 270000 0.0 0.0 0 Credit card -17
|
|
338464 5714633 8 Closed currency 1 -1706 0 -976.0 -1260.0 0 247500 0.0 0.0 0 Consumer credit -538
|
|
338464 5714634 8 Active currency 1 -140 0 0.0 0 144000 143019.0 980.28 0 Credit card -22
|
|
351919 5714658 1 Active currency 1 -769 0 1057.0 0 409500 295542.0 0.0 0 Consumer credit -14
|
|
373324 5714674 14 Active currency 1 -837 0 -453.0 0.0 0 0 -45.36 45.36 0 Credit card -685
|
|
373324 5714675 14 Active currency 1 -341 0 -160.0 0.0 0 63496.17 63496.17 0.0 0 Consumer credit -234
|
|
373324 5714676 14 Closed currency 1 -586 0 -402.0 -402.0 0 90180 0.0 0.0 0 Consumer credit -400
|
|
373324 5714677 14 Closed currency 1 -1439 0 -1134.0 -1123.0 0 60399 0.0 0.0 0 Consumer credit -775
|
|
373324 5714679 14 Active currency 1 -577 0 521.0 0 225000 45324.0 0.0 0 Credit card -25
|
|
373324 5714681 14 Closed currency 1 -2819 0 -2516.0 -2516.0 0 24903 0.0 0 Consumer credit -2516
|
|
373324 5714682 14 Closed currency 1 -2673 0 -2307.0 -2307.0 0 31788 0.0 0 Consumer credit -2307
|
|
373324 5714683 14 Closed currency 1 -1438 0 -1134.0 -1153.0 0 60399 0.0 0 Consumer credit -1128
|
|
373324 5714684 14 Closed currency 1 -1913 0 -1609.0 -1609.0 0 53410.5 0.0 0 Consumer credit -1128
|
|
373324 5714685 14 Closed currency 1 -1593 0 -1109.0 -987.0 0 79456.5 0 Consumer credit -984
|
|
373324 5714686 14 Closed currency 1 -986 0 -805.0 -740.0 0 68850 0 Consumer credit -738
|
|
373324 5714687 14 Closed currency 1 -2455 0 -2273.0 -1925.0 0.0 0 31410 0.0 0.0 0 Consumer credit -1924
|
|
373324 5714688 14 Closed currency 1 -2216 0 -2121.0 -2095.0 0.0 0 20002.5 0.0 0.0 0 Consumer credit -2095
|
|
373324 5714689 14 Closed currency 1 -1805 0 -320.0 0.0 0 13500 0.0 0.0 0 Credit card -229
|
|
387080 5714598 14 Closed currency 1 -983 0 -623.0 -900.0 0 52987.5 0.0 0.0 0 Consumer credit -802
|
|
387080 5714600 14 Closed currency 1 -1104 0 -738.0 -731.0 0 194400 0.0 0.0 0 Consumer credit -731
|
|
387080 5714601 14 Closed currency 1 -1766 0 -1219.0 -1256.0 0 135000 0.0 0.0 0 Consumer credit -1252
|
|
387080 5714602 14 Active currency 1 -1082 0 745.0 0 197820 105840.0 0.0 0 Consumer credit -10
|
|
387080 5714603 14 Active currency 1 -1239 0 -149.0 0 225000 185953.5 0.0 0 Credit card -10
|
|
387080 5714604 14 Active currency 1 -681 0 1145.0 0 328500 244791.0 0.0 0 Consumer credit -10
|
|
387080 5714606 14 Closed currency 1 -2897 0 -2350.0 -2357.0 0 67500 0 Consumer credit -2357
|
|
387080 5714607 14 Closed currency 1 -1603 0 -1299.0 -1087.0 0 70335 0.0 0 Consumer credit -1087
|
|
387080 5714608 14 Closed currency 1 -2093 0 -1949.0 -987.0 0 44968.5 0 Consumer credit -984
|
|
387080 5714609 14 Active currency 1 -69 0 263.0 0 84361.5 0 Consumer credit -6
|
|
387080 5714610 14 Closed currency 1 -2299 0 -1932.0 -1932.0 0.0 0 72600.75 0.0 0.0 0 Consumer credit -1603
|
|
387080 5714611 14 Closed currency 1 -549 0 -364.0 -488.0 0.0 0 37935 0.0 0.0 0 Consumer credit -486
|
|
387080 5714612 14 Closed currency 1 -388 0 -21.0 -84.0 0.0 0 98446.5 0.0 0.0 0 Consumer credit -84
|
|
387080 5714614 14 Active currency 1 -18 0 378.0 0.0 0 76500 76500.0 0.0 0 Consumer credit -14
|
|
388421 5714587 4 Active currency 1 -685 0 410.0 0.0 0 135000 0.0 135000.0 0 Credit card -236
|
|
388421 5714590 4 Closed currency 1 -325 0 223.0 -112.0 0 87286.5 0.0 0.0 0 Consumer credit -106
|
|
388421 5714591 4 Active currency 1 -674 0 1152.0 0 868500 662139.0 0.0 0 Consumer credit -25
|
|
388421 5714593 4 Active currency 1 -378 0 1449.0 0.0 0 991800 0 Consumer credit -31
|
|
389074 5714667 3 Closed currency 1 -957 0 -342.0 -341.0 0 13500 0.0 0.0 0 Credit card -334
|
|
389074 5714668 3 Closed currency 1 -705 0 -433.0 -404.0 0 135729 0 Consumer credit -398
|
|
389074 5714669 3 Closed currency 1 -1049 0 -378.0 -378.0 0.0 0 113496.885 0.0 0.0 0 Consumer credit -372
|
|
389599 5714529 7 Closed currency 1 -672 0 10285.0 -531.0 0 135000 0.0 0.0 0 Credit card -429
|
|
389599 5714530 7 Closed currency 1 -1304 0 1253.0 -1287.0 0 225000 0.0 0.0 0 Consumer credit -429
|
|
389599 5714531 7 Closed currency 1 -1253 0 -887.0 -887.0 0 43105.5 0.0 0.0 0 Consumer credit -687
|
|
389599 5714532 7 Closed currency 1 -1130 0 331.0 -858.0 0 450000 0.0 0.0 0 Consumer credit -847
|
|
389599 5714533 7 Active currency 1 -831 0 277.0 0 270000 274225.5 0.0 0 Credit card -10
|
|
389599 5714534 7 Active currency 1 -329 0 1497.0 0 589500 521478.0 0.0 0 Consumer credit -8
|
|
389599 5714536 7 Closed currency 1 -700 0 -600.0 -600.0 0.0 0 68715 0.0 0.0 0 Consumer credit -596
|
|
399459 5714708 2 Closed currency 1 -1141 0 -837.0 -784.0 0 113359.5 0 Consumer credit -781
|
|
399459 5714709 2 Active currency 1 -49 0 316.0 0.0 0 24763.5 22968.0 0.0 0 Consumer credit -19
|
|
400486 5714504 5 Closed currency 1 -2413 0 -1864.0 -2128.0 0 180000 0.0 0.0 0 Consumer credit -708
|
|
400486 5714506 5 Active currency 1 -941 0 -17.0 0 40500 0.0 0.0 0 Credit card -15
|
|
400486 5714507 5 Closed currency 1 -1110 0 -745.0 -727.0 0 114727.5 0.0 0.0 0 Consumer credit -658
|
|
400486 5714508 5 Closed currency 1 -2133 0 -1038.0 -1127.0 0 225000 0.0 0.0 0 Consumer credit -708
|
|
400486 5714509 5 Active currency 1 -391 0 705.0 0 142290 108315.0 0.0 0 Consumer credit -30
|
|
402440 5714475 1 Active currency 1 -96 0 269.0 0.0 0 89910 76905.0 0.0 0 Consumer credit -22
|
|
406724 5714661 4 Closed currency 1 -1293 0 -1155.0 -1155.0 0 13500 0.0 0.0 0 Credit card -775
|
|
406724 5714662 4 Closed currency 1 -1433 0 -1251.0 -1245.0 0 23067 0.0 0.0 0 Consumer credit -783
|
|
406724 5714663 4 Closed currency 1 -1432 0 -1251.0 -1251.0 0 23067 0.0 0 Consumer credit -1142
|
|
406724 5714665 4 Active currency 1 -167 0 1298.0 0.0 0 606496.995 574827.21 0.0 0 Consumer credit -5
|
|
419892 5714594 4 Closed currency 1 -1697 0 -1148.0 -1148.0 0 70695 0.0 0.0 0 Consumer credit -696
|
|
419892 5714595 4 Closed currency 1 -1238 0 -878.0 -1120.0 0 22320 0.0 0.0 0 Consumer credit -1119
|
|
419892 5714596 4 Active currency 1 -381 0 0 2767500 2739622.5 0 Mortgage -27
|
|
419892 5714597 4 Closed currency 1 -584 0 511.0 -405.0 0.0 0 238603.5 0.0 0.0 0 Consumer credit -405
|
|
426155 5714498 4 Closed currency 1 -1331 0 -994.0 -1023.0 1350.0 0 39433.5 0.0 0.0 0 Consumer credit -1023
|
|
426155 5714499 4 Closed currency 1 -2534 0 -2352.0 -2347.0 0 38830.5 0.0 0.0 0 Consumer credit -2345
|
|
426155 5714500 4 Closed currency 1 -845 0 -480.0 -480.0 0.0 0 67500 0.0 0.0 0 Consumer credit -480
|
|
426155 5714501 4 Closed currency 1 -529 0 -343.0 -343.0 0.0 0 182791.44 0.0 0.0 0 Consumer credit -337
|
|
435112 5714512 11 Closed currency 1 -1412 0 -861.0 -849.0 0 85288.5 0.0 0.0 0 Consumer credit -753
|
|
435112 5714513 11 Closed currency 1 -1590 0 -1344.0 -1276.0 0 100129.5 0.0 0.0 0 Consumer credit -783
|
|
435112 5714514 11 Closed currency 1 -1181 0 -875.0 -872.0 0 44419.5 0.0 0.0 0 Consumer credit -872
|
|
435112 5714516 11 Closed currency 1 -1475 0 -1293.0 -1322.0 0 21690 0.0 0 Consumer credit -1322
|
|
435112 5714517 11 Closed currency 1 -1411 0 -861.0 -861.0 0 85293 0.0 0 Consumer credit -855
|
|
435112 5714518 11 Active currency 1 -1483 0 0 200250 0.0 0 Credit card -848
|
|
435112 5714519 11 Closed currency 1 -1589 0 -1344.0 -1292.0 3980.52 0 100129.5 0.0 0.0 0 Consumer credit -736
|
|
435112 5714520 11 Closed currency 1 -829 0 -508.0 -508.0 0.0 0 159386.085 0.0 0.0 0 Consumer credit -508
|
|
435112 5714521 11 Closed currency 1 -739 0 -525.0 -525.0 0.0 0 48645 0.0 0.0 0 Consumer credit -519
|
|
435112 5714522 11 Active currency 1 -508 0 1318.0 0.0 0 1058823.54 858768.57 0.0 0 Consumer credit -7
|
|
435112 5714523 11 Active currency 1 -416 0 680.0 0.0 0 256500 183528.0 0.0 0 Consumer credit -43
|
|
444864 5714635 12 Closed currency 1 -2209 0 -2086.0 -2115.0 0.0 0 16645.5 0.0 0.0 0 Consumer credit -2115
|
|
444864 5714636 12 Closed currency 1 -2130 0 -1886.0 -1883.0 0 66600 0.0 0.0 0 Consumer credit -791
|
|
444864 5714637 12 Closed currency 1 -1125 0 -881.0 -881.0 0 82795.5 0.0 0.0 0 Consumer credit -752
|
|
444864 5714638 12 Closed currency 1 -1872 0 -1568.0 -1549.0 0 49936.5 0.0 0.0 0 Consumer credit -801
|
|
444864 5714639 12 Closed currency 1 -2030 0 31111.0 -1750.0 0 85050 0.0 0.0 0 Credit card -555
|
|
444864 5714640 12 Closed currency 1 -1776 0 -680.0 -712.0 0 157500 0.0 0.0 0 Consumer credit -188
|
|
444864 5714642 12 Closed currency 1 -1124 0 -881.0 -881.0 0 82795.5 0.0 0 Consumer credit -876
|
|
444864 5714643 12 Closed currency 1 -1871 0 -1568.0 -1568.0 0 49936.5 0.0 0 Consumer credit -820
|
|
444864 5714644 12 Closed currency 1 -2129 0 -1886.0 -1886.0 0 66600 0.0 0 Consumer credit -820
|
|
444864 5714645 12 Closed currency 1 -1416 0 -685.0 -685.0 0.0 0 182119.5 0.0 0.0 0 Consumer credit -680
|
|
444864 5714646 12 Closed currency 1 -312 0 -130.0 -130.0 0.0 0 52488 0.0 0.0 0 Consumer credit -127
|
|
444864 5714647 12 Active currency 1 -286 0 0.0 0 364500 0.0 364500.0 0 Credit card -29
|
|
452585 5714524 4 Closed currency 1 -2642 0 -2307.0 -2332.0 1800.0 0 15921 0.0 0.0 0 Consumer credit -2306
|
|
452585 5714525 4 Active currency 1 -2538 0 -1427.0 0.0 0 45000 0.0 0.0 0 Credit card -682
|
|
452585 5714527 4 Active currency 1 -42 0 -26.0 0 45000 54000.0 0.0 0 Consumer credit -31
|
|
452585 5714528 4 Closed currency 1 -2898 0 -2722.0 -2344.0 0 11340 0 Consumer credit -2344
|
|
select count(*) from t1;
|
|
count(*)
|
|
201
|
|
select count(*) from t2;
|
|
count(*)
|
|
201
|
|
select count(*) from t3;
|
|
count(*)
|
|
201
|
|
checksum table t1, t2, t3;
|
|
Table Checksum
|
|
test.t1 1688521217
|
|
test.t2 1688521217
|
|
test.t3 1688521217
|
|
drop table bureau;
|
|
drop table t1, t2, t3;
|
|
|