1 Public Data

1.1 Address

  • 1.5M company description with their creation date

address$year_t Frequency Percent year: 2022 1735533 84.77 year: 2023 311805 15.23 Total 2047338 100.00

## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
BPAD_BZEL_ID BPAD_DELETED BPAD_ID BPAD_REGISTERED BPAD_UID_ORGANISATION_ID FECHA year
Mean 1408320.49641 3.93326 1212727.67444 2.13876 188639238.48832 202224.60337 2022.15230
Std.Dev 732497.80768 3.85614 776112.28401 2.96194 120853788.60091 34.30048 0.35931
Min 4.00000 0.00000 455.00000 0.00000 100000012.00000 202210.00000 2022.00000
Q1 856853.00000 2.00000 574930.00000 1.00000 107294547.00000 202210.00000 2022.00000
Median 1290515.00000 3.00000 1098993.50000 1.00000 113527375.00000 202210.00000 2022.00000
Q3 2048933.00000 5.00000 1742807.00000 2.00000 261826591.00000 202210.00000 2022.00000
Max 2654985.00000 95.00000 2721409.00000 244.00000 499999568.00000 202310.00000 2023.00000
MAD 867031.89300 1.48260 852601.74720 0.00000 16018028.19120 0.00000 0.00000
IQR 1192080.00000 3.00000 1167876.50000 1.00000 154532044.00000 0.00000 0.00000
CV 0.52012 0.98039 0.63997 1.38488 0.64066 0.00017 0.00018
Skewness 0.08283 4.91139 0.36998 8.02631 1.21600 1.93909 1.93539
SE.Skewness 0.00171 0.00311 0.00171 0.00171 0.00171 0.00171 0.00171
Kurtosis -1.11313 45.98813 -0.97369 188.70355 0.00766 1.76802 1.74574
N.Valid 2047338.00000 620659.00000 2047338.00000 2047338.00000 2047338.00000 2047338.00000 2047338.00000
Pct.Valid 100.00000 30.31541 100.00000 100.00000 100.00000 100.00000 100.00000

1.2 Purposes

  • 1.5M company description with their creation date PURPOSES$year_t Frequency Percent year: 2022 1335550 85.07 year: 2023 234321 14.93 Total 1569871 100.00
## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
BPPU_BZEL_ID BPPU_ID BPPU_REGISTERED BPPU_UID_ORGANISATION_ID FECHA year
Mean 1390137.56942 939262.11458 1.70231 189568250.84393 202224.31265 2022.14926
Std.Dev 731297.27698 611384.10259 3.04329 121246937.54946 34.02273 0.35635
Min 4.00000 345.00000 0.00000 100000012.00000 202210.00000 2022.00000
Q1 841072.00000 442278.00000 1.00000 107242094.00000 202210.00000 2022.00000
Median 1242983.00000 839742.00000 1.00000 113491197.00000 202210.00000 2022.00000
Q3 2031140.00000 1329132.00000 1.00000 264656109.00000 202210.00000 2022.00000
Max 2654985.00000 2142066.00000 714.00000 499999568.00000 202310.00000 2023.00000
MAD 853970.18700 648886.57680 0.00000 16103117.57040 0.00000 0.00000
IQR 1190066.50000 886853.00000 0.00000 157413990.00000 0.00000 0.00000
CV 0.52606 0.65092 1.78774 0.63960 0.00017 0.00018
Skewness 0.13229 0.42701 22.42122 1.19740 1.97222 1.96853
SE.Skewness 0.00195 0.00195 0.00195 0.00195 0.00195 0.00195
Kurtosis -1.10723 -0.91907 2737.69999 -0.03857 1.89768 1.87510
N.Valid 1569871.00000 1569871.00000 1569871.00000 1569871.00000 1569871.00000 1569871.00000
Pct.Valid 100.00000 100.00000 100.00000 100.00000 100.00000 100.00000

1.3 key Figures

  • 841k Organization UID with their creation date and capital information

KEY_FIGURES$year_t Frequency Percent year: 2022 682784 81.15 year: 2023 158636 18.85 Total 841420 100.00

## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
BPKF_BZEL_ID BPKF_CAPITAL BPKF_DELETED BPKF_ID BPKF_REGISTERED BPKF_UID_ORGANISATION_ID FECHA year
Mean 1499023.15175 1865753.03160 6.5987 547321.73519 1.80097 196670294.26047 202228.10273 2022.18853
Std.Dev 758284.17920 73941004.70470 7.3526 376972.84476 4.04808 124013629.93116 37.39665 0.39114
Min 5.00000 -1976198296.00000 1.0000 271.00000 0.00000 100000012.00000 202210.00000 2022.00000
Q1 891677.00000 20000.00000 2.0000 238132.50000 1.00000 107127553.00000 202210.00000 2022.00000
Median 1529349.00000 100000.00000 4.0000 465931.50000 1.00000 114376995.00000 202210.00000 2022.00000
Q3 2159400.50000 100000.00000 8.0000 878696.50000 1.00000 283769721.00000 202210.00000 2022.00000
Max 2654985.00000 11586780315.60000 95.0000 1273734.00000 900.00000 499998882.00000 202310.00000 2023.00000
MAD 940317.55230 118608.00000 2.9652 375517.37580 0.00000 18862237.65300 0.00000 0.00000
IQR 1267723.25000 80000.00000 6.0000 640563.50000 0.00000 176642081.00000 0.00000 0.00000
CV 0.50585 39.63065 1.1142 0.68876 2.24773 0.63057 0.00018 0.00019
Skewness -0.13337 111.79994 4.0084 0.48776 27.78398 1.06999 1.59610 1.59261
SE.Skewness 0.00267 0.00269 0.0069 0.00267 0.00267 0.00267 0.00267 0.00267
Kurtosis -1.16665 14843.15733 24.3300 -1.00020 3720.28545 -0.33539 0.55436 0.53642
N.Valid 841420.00000 831123.00000 125929.0000 841420.00000 840948.00000 841420.00000 841420.00000 841420.00000
Pct.Valid 100.00000 98.77624 14.9663 100.00000 99.94390 100.00000 100.00000 100.00000

1.5 Status information

  • 1.2 MM organization UID with their creation and deletion date (729k missing) informed. This info should be connected with shab dates

STATUS_DATES$year_t Frequency Percent year: 1000 1 0.00007907 year: 1001 7 0.00055347 year: 1196 1 0.00007907 year: 13 1 0.00007907 year: 1791 1 0.00007907 year: 1877 1 0.00007907 year: 1882 1 0.00007907 year: 1883 240 0.01897619 year: 1884 58 0.00458591 year: 1885 47 0.00371617 year: 1886 42 0.00332083 year: 1887 106 0.00838115 year: 1888 167 0.01320426 year: 1889 114 0.00901369 year: 1890 94 0.00743234 year: 1891 97 0.00766954 year: 1892 119 0.00940903 year: 1893 103 0.00814395 year: 1894 75 0.00593006 year: 1895 100 0.00790674 year: 1896 122 0.00964623 year: 1897 123 0.00972530 year: 1898 137 0.01083224 year: 1899 117 0.00925089 year: 1900 97 0.00766954 year: 1901 101 0.00798581 year: 1902 106 0.00838115 year: 1903 144 0.01138571 year: 1904 140 0.01106944 year: 1905 174 0.01375774 year: 1906 170 0.01344147 year: 1907 165 0.01304613 year: 1908 200 0.01581349 year: 1909 207 0.01636696 year: 1910 237 0.01873898 year: 1911 219 0.01731577 year: 1912 244 0.01929246 year: 1913 242 0.01913432 year: 1914 163 0.01288799 year: 1915 139 0.01099038 year: 1916 282 0.02229702 year: 1917 241 0.01905525 year: 1918 198 0.01565535 year: 1919 243 0.01921339 year: 1920 213 0.01684137 year: 1921 240 0.01897619 year: 1922 236 0.01865992 year: 1923 214 0.01692043 year: 1924 201 0.01589256 year: 1925 240 0.01897619 year: 1926 236 0.01865992 year: 1927 251 0.01984593 year: 1928 245 0.01937152 year: 1929 301 0.02379930 year: 1930 354 0.02798988 year: 1931 315 0.02490625 year: 1932 279 0.02205982 year: 1933 349 0.02759454 year: 1934 272 0.02150635 year: 1935 294 0.02324583 year: 1936 318 0.02514345 year: 1937 322 0.02545972 year: 1938 283 0.02237609 year: 1939 237 0.01873898 year: 1940 232 0.01834365 year: 1941 343 0.02712013 year: 1942 507 0.04008720 year: 1943 557 0.04404057 year: 1944 502 0.03969186 year: 1945 640 0.05060317 year: 1946 812 0.06420277 year: 1947 866 0.06847241 year: 1948 710 0.05613789 year: 1949 636 0.05028690 year: 1950 673 0.05321239 year: 1951 627 0.04957529 year: 1952 654 0.05171011 year: 1953 816 0.06451904 year: 1954 881 0.06965842 year: 1955 928 0.07337459 year: 1956 953 0.07535128 year: 1957 962 0.07606288 year: 1958 1023 0.08088600 year: 1959 1296 0.10247141 year: 1960 1524 0.12049879 year: 1961 1598 0.12634978 year: 1962 1751 0.13844710 year: 1963 1877 0.14840960 year: 1964 1861 0.14714452 year: 1965 1747 0.13813083 year: 1966 1874 0.14817240 year: 1967 2074 0.16398588 year: 1968 2156 0.17046942 year: 1969 2696 0.21316584 year: 1970 2811 0.22225859 year: 1971 3270 0.25855055 year: 1972 3513 0.27776394 year: 1973 3678 0.29081007 year: 1974 3689 0.29167981 year: 1975 4043 0.31966969 year: 1976 4091 0.32346493 year: 1977 4445 0.35145480 year: 1978 4774 0.37746799 year: 1979 5431 0.42941530 year: 1980 5613 0.44380558 year: 1981 5810 0.45938187 year: 1982 5957 0.47100478 year: 1983 6751 0.53378433 year: 1984 7322 0.57893185 year: 1985 7638 0.60391716 year: 1986 8055 0.63688828 year: 1987 8898 0.70354214 year: 1988 9980 0.78909312 year: 1989 11259 0.89022038 year: 1990 11363 0.89844340 year: 1991 12056 0.95323714 year: 1992 11635 0.91994974 year: 1993 12542 0.99166392 year: 1994 14485 1.14529197 year: 1995 16244 1.28437161 year: 1996 18376 1.45294340 year: 1997 21393 1.69148989 year: 1998 23858 1.88639115 year: 1999 25225 1.99447635 year: 2000 27861 2.20289814 year: 2001 29098 2.30070457 year: 2002 30239 2.39092053 year: 2003 32054 2.53442794 year: 2004 34615 2.73691967 year: 2005 34545 2.73138495 year: 2006 35456 2.80341540 year: 2007 37852 2.99286100 year: 2008 37034 2.92818383 year: 2009 36008 2.84706063 year: 2010 38200 3.02037647 year: 2011 39419 3.11675969 year: 2012 39262 3.10434610 year: 2013 40522 3.20397108 year: 2014 41254 3.26184845 year: 2015 41094 3.24919766 year: 2016 41614 3.29031274 year: 2017 43854 3.46742382 year: 2018 43892 3.47042838 year: 2019 45567 3.60286635 year: 2020 47460 3.75254103 year: 2021 50603 4.00105002 year: 2022 49237 3.89304388 year: 2023 38740 3.06307289 year: 2100 1 0.00007907 year: 214 1 0.00007907 year: 217 1 0.00007907 year: NA 293 0.02316676 Total 1264743 100.00000000

## `summarise()` has grouped output by 'year_t'. You can override using the
## `.groups` argument.

STATUS_DATES_1$year_t_del Frequency Percent year: 13 1 0.0001869 year: 14 1 0.0001869 year: 15 2 0.0003737 year: 1972 1 0.0001869 year: 1975 1 0.0001869 year: 1978 1 0.0001869 year: 1979 1 0.0001869 year: 1992 1 0.0001869 year: 1993 3 0.0005606 year: 1994 16 0.0029896 year: 1995 5 0.0009343 year: 1996 7 0.0013080 year: 1997 12 0.0022422 year: 1998 6 0.0011211 year: 1999 3 0.0005606 year: 2000 4 0.0007474 year: 2001 1 0.0001869 year: 2002 253 0.0472736 year: 2003 21675 4.0500241 year: 2004 23691 4.4267184 year: 2005 24024 4.4889402 year: 2006 21998 4.1103774 year: 2007 21274 3.9750963 year: 2008 19633 3.6684717 year: 2009 21988 4.1085089 year: 2010 23671 4.4229813 year: 2011 26346 4.9228113 year: 2012 27105 5.0646322 year: 2013 26180 4.8917938 year: 2014 26612 4.9725140 year: 2015 26711 4.9910124 year: 2016 27708 5.1773042 year: 2017 28502 5.3256649 year: 2018 29223 5.4603854 year: 2019 30902 5.7741105 year: 2020 28503 5.3258518 year: 2021 28090 5.2486818 year: 2022 27968 5.2258858 year: 2023 23058 4.3084409 year: 205 1 0.0001869 Total 535182 100.0000000 [1] 729561

## 
## Attaching package: 'summarytools'
## 
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## 
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## 
## The following object is masked from 'package:tibble':
## 
##     view
BPHD_BZEL_ID BPHD_ID BPHD_UID_ORGANISATION_ID FECHA FECHA_del year year_del
Mean 1359556.39664 737366.55651 201406075.53040 200514.18439 201355.10478 2005.07750 2013.48730
Std.Dev 721383.13114 466990.58765 125226269.33644 1687.29757 845.64697 16.87360 8.45718
Min 4.00000 279.00000 100000012.00000 1312.00000 1310.00000 13.00000 13.00000
Q1 831598.00000 356348.00000 108106335.00000 199906.00000 200901.00000 1999.00000 2009.00000
Median 1184217.00000 672577.00000 114786666.00000 200902.00000 201405.00000 2009.00000 2014.00000
Q3 1986347.00000 1056315.00000 294210600.00000 201701.00000 201902.00000 2017.00000 2019.00000
Max 2654985.00000 1653913.00000 499999568.00000 210004.00000 202310.00000 2100.00000 2023.00000
MAD 807760.51020 513918.08580 19648521.21960 1319.51400 741.30000 13.34340 7.41300
IQR 1154747.50000 699966.00000 186104232.00000 1795.00000 1001.00000 18.00000 10.00000
CV 0.53060 0.63332 0.62176 0.00841 0.00420 0.00842 0.00420
Skewness 0.19473 0.36556 0.99875 -6.67558 -117.08814 -6.67464 -117.05672
SE.Skewness 0.00218 0.00218 0.00218 0.00218 0.00335 0.00218 0.00335
Kurtosis -1.05163 -0.93548 -0.48532 444.62845 27254.95136 444.54792 27245.26184
N.Valid 1264743.00000 1264743.00000 1264743.00000 1264450.00000 535182.00000 1264450.00000 535182.00000
Pct.Valid 100.00000 100.00000 100.00000 99.97683 42.31547 99.97683 42.31547

1.6 Shab Dates

  • 5.6 MM organization UID with their shab date informed. It is the date that shows changes in the status of the company

SHAB_DATES$year_t Frequency Percent year: 1689 1 0.00001766 year: 1826 1 0.00001766 year: 1900 1 0.00001766 year: 1902 1 0.00001766 year: 1903 1 0.00001766 year: 1905 1 0.00001766 year: 1914 1 0.00001766 year: 1916 2 0.00003531 year: 1917 1 0.00001766 year: 1920 1 0.00001766 year: 1922 1 0.00001766 year: 1923 3 0.00005297 year: 1925 2 0.00003531 year: 1926 2 0.00003531 year: 1928 2 0.00003531 year: 1929 3 0.00005297 year: 1930 1 0.00001766 year: 1931 9 0.00015890 year: 1932 7 0.00012359 year: 1933 9 0.00015890 year: 1934 16 0.00028249 year: 1935 10 0.00017656 year: 1936 7 0.00012359 year: 1937 5 0.00008828 year: 1938 13 0.00022952 year: 1939 9 0.00015890 year: 1940 10 0.00017656 year: 1941 9 0.00015890 year: 1942 13 0.00022952 year: 1943 19 0.00033546 year: 1944 23 0.00040608 year: 1945 21 0.00037077 year: 1946 33 0.00058264 year: 1947 39 0.00068857 year: 1948 62 0.00109465 year: 1949 47 0.00082982 year: 1950 58 0.00102403 year: 1951 66 0.00116528 year: 1952 58 0.00102403 year: 1953 72 0.00127121 year: 1954 92 0.00162432 year: 1955 89 0.00157136 year: 1956 116 0.00204806 year: 1957 114 0.00201275 year: 1958 124 0.00218930 year: 1959 139 0.00245414 year: 1960 200 0.00353114 year: 1961 205 0.00361942 year: 1962 205 0.00361942 year: 1963 238 0.00420205 year: 1964 298 0.00526139 year: 1965 314 0.00554389 year: 1966 409 0.00722118 year: 1967 467 0.00824520 year: 1968 475 0.00838645 year: 1969 546 0.00964000 year: 1970 679 0.01198821 year: 1971 778 0.01373612 year: 1972 861 0.01520154 year: 1973 974 0.01719664 year: 1974 1110 0.01959781 year: 1975 1344 0.02372924 year: 1976 1438 0.02538888 year: 1977 1725 0.03045606 year: 1978 2071 0.03656492 year: 1979 2530 0.04466888 year: 1980 2770 0.04890625 year: 1981 2850 0.05031870 year: 1982 3389 0.05983512 year: 1983 4423 0.07809110 year: 1984 5034 0.08887872 year: 1985 5796 0.10233235 year: 1986 6609 0.11668642 year: 1987 7717 0.13624892 year: 1988 9430 0.16649311 year: 1989 11664 0.20593591 year: 1990 14529 0.25651945 year: 1991 19831 0.35012989 year: 1992 25826 0.45597573 year: 1993 37939 0.66983904 year: 1994 47183 0.83304819 year: 1995 53527 0.94505586 year: 1996 61327 1.08277021 year: 1997 82398 1.45479315 year: 1998 81569 1.44015658 year: 1999 86078 1.51976607 year: 2000 95984 1.69466329 year: 2001 116124 2.05024879 year: 2002 119036 2.10166214 year: 2003 148635 2.62425277 year: 2004 157078 2.77331972 year: 2005 154336 2.72490783 year: 2006 158633 2.80077431 year: 2007 163903 2.89381977 year: 2008 178125 3.14491892 year: 2009 230952 4.07761580 year: 2010 212561 3.75291010 year: 2011 204481 3.61025216 year: 2012 205807 3.63366360 year: 2013 315755 5.57487088 year: 2014 210539 3.71721030 year: 2015 215335 3.80188697 year: 2016 219403 3.87371030 year: 2017 227527 4.01714508 year: 2018 233801 4.12791685 year: 2019 244550 4.31769781 year: 2020 248705 4.39105718 year: 2021 292299 5.16073912 year: 2022 257383 4.54427322 year: 2023 205745 3.63256895 year: 2100 3 0.00005297 year: NA 259128 4.57508239 Total 5663898 100.00000000

## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
BPSD_BZEL_ID BPSD_ID BPSD_REF BPSD_UID_ORGANISATION_ID FECHA year
Mean 1496022.53626 3648210.07296 5.46027 164396964.30017 201102.40649 2010.95805
Std.Dev 736082.18396 2583682.40813 11.04777 108030485.45312 870.12964 8.70209
Min 4.00000 1204.00000 0.00000 100000012.00000 168903.00000 1689.00000
Q1 926907.00000 1549470.00000 1.00000 105760685.00000 200510.00000 2005.00000
Median 1397125.00000 3042238.50000 3.00000 110055931.00000 201211.00000 2012.00000
Q3 2165821.00000 5659811.00000 6.00000 161887764.00000 201807.00000 2018.00000
Max 2654985.00000 8773690.00000 901.00000 499999568.00000 210011.00000 2100.00000
MAD 851061.32580 2494827.35880 2.96520 8458811.21400 896.97300 8.89560
IQR 1238914.00000 4110340.50000 5.00000 56127077.50000 1297.00000 13.00000
CV 0.49203 0.70821 2.02330 0.65713 0.00433 0.00433
Skewness 0.03003 0.57046 22.69346 1.75230 -0.88591 -0.88521
SE.Skewness 0.00103 0.00103 0.00103 0.00103 0.00105 0.00105
Kurtosis -1.18025 -0.90220 1066.83431 1.68074 1.61493 1.61372
N.Valid 5663898.00000 5663898.00000 5663898.00000 5663898.00000 5404770.00000 5404770.00000
Pct.Valid 100.00000 100.00000 100.00000 100.00000 95.42492 95.42492

1.7 Shab Logs

  • 1,8 MM publications from uid organizations that have appeared in the registry with their publication date. Relevant information from cantons, town, zip code, etc.
## `summarise()` has grouped output by 'SHLP_CANTONS'. You can override using the
## `.groups` argument.

SHAB_LOGS$SHLP_CANTONS Frequency Percent AG 113796 5.9967 AI 6791 0.3579 AR 15898 0.8378 BE 154448 8.1389 BL 46625 2.4570 BS 57377 3.0236 FR 53436 2.8159 GE 186420 9.8237 GL 8654 0.4560 GR 39593 2.0864 JU 12676 0.6680 LU 75693 3.9888 NE 30703 1.6179 NULL 10026 0.5283 NW 13138 0.6923 OW 9777 0.5152 SG 91795 4.8373 SH 15544 0.8191 SO 42747 2.2526 SZ 49033 2.5839 TG 43872 2.3119 TI 129072 6.8016 UR 5163 0.2721 VD 159143 8.3863 VS 71866 3.7871 ZG 122224 6.4408 ZH 332149 17.5031 Total 1897659 100.0000

SHAB_LOGS$year_t Frequency Percent year: 2018 115073 6.06395 year: 2019 352187 18.55902 year: 2020 357072 18.81645 year: 2021 406644 21.42872 year: 2022 372898 19.65042 year: 2023 293560 15.46959 year: NA 225 0.01186 Total 1897659 100.00000 [1] 89643

## 
## Attaching package: 'summarytools'
## 
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## 
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## 
## The following object is masked from 'package:tibble':
## 
##     view
FECHA SHLP_SHLO_ID SHLP_UID_ORGANISATION_ID year
Mean 202083.00348 954798.76455 226018716.84138 2020.76460
Std.Dev 148.78276 552056.01112 130300907.49952 1.49547
Min 201809.00000 4.00000 0.00000 2018.00000
Q1 202001.00000 475892.00000 109621924.00000 2020.00000
Median 202104.00000 955820.00000 175034928.00000 2021.00000
Q3 202207.00000 1432008.00000 337412746.00000 2022.00000
Max 202310.00000 1911035.00000 2147483647.00000 2023.00000
MAD 152.70780 708767.30820 104691317.12760 1.48260
IQR 206.00000 956115.00000 227790822.00000 2.00000
CV 0.00074 0.57819 0.57650 0.00074
Skewness -0.07879 0.00105 0.65785 -0.08489
SE.Skewness 0.00178 0.00178 0.00191 0.00178
Kurtosis -1.07389 -1.19969 -0.88313 -1.05496
N.Valid 1897434.00000 1897659.00000 1646910.00000 1897434.00000
Pct.Valid 99.98814 100.00000 86.78640 99.98814

1.8 Mandates

  • 6,4 MM individual mandate reports with function, position and date information.
## `summarise()` has grouped output by 'BPMA_FUNCTION'. You can override using the
## `.groups` argument.

MANDATES$year_t Frequency Percent year: 2022 4744962 74.11 year: 2023 1657968 25.89 Total 6402930 100.00

## 
## Attaching package: 'summarytools'
## 
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## 
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## 
## The following object is masked from 'package:tibble':
## 
##     view
BPMA_BZEL_ID BPMA_DELETED BPMA_ID BPMA_REGISTERED BPMA_UID_ORGANISATION_ID FECHA year
Mean 1598429.22146 9.95887 5149488.55367 5.24064 163008679.29939 202234.97629 2022.25894
Std.Dev 771755.55457 19.49822 4211217.07659 15.22680 107313877.29029 42.11482 0.43805
Min 4.00000 0.00000 1839.00000 0.00000 100000012.00000 202210.00000 2022.00000
Q1 957748.00000 3.00000 1773708.00000 1.00000 105702647.00000 202210.00000 2022.00000
Median 1642659.00000 5.00000 3575796.50000 1.00000 109700245.00000 202210.00000 2022.00000
Q3 2385694.00000 10.00000 8926142.00000 4.00000 155220250.00000 202301.00000 2023.00000
Max 2654985.00000 814.00000 13501905.00000 809.00000 499999568.00000 202310.00000 2023.00000
MAD 1057830.65220 4.44780 3536493.22320 0.00000 8403680.73300 0.00000 0.00000
IQR 1427945.75000 7.00000 7152433.50000 3.00000 49517603.00000 91.00000 1.00000
CV 0.48282 1.95787 0.81779 2.90552 0.65833 0.00021 0.00022
Skewness -0.18414 13.89471 0.70837 18.84814 1.78325 1.10404 1.10060
SE.Skewness 0.00097 0.00127 0.00097 0.00112 0.00097 0.00097 0.00097
Kurtosis -1.25297 348.73888 -0.94407 640.70218 1.79116 -0.77536 -0.78867
N.Valid 6402930.00000 3735484.00000 6402930.00000 4788960.00000 6402930.00000 6402930.00000 6402930.00000
Pct.Valid 100.00000 58.34023 100.00000 74.79326 100.00000 100.00000 100.00000

2 Requests

2.1 CDP

  • 296k out of 1.1M requests with UID from old system CDP

[1] 321068 [1] 365632 [1] 310407 [1] 77 [1] 43

## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
FECHA HALT_CODE ID NUMERIC_RATING year
Mean 202167.42185 6.00000 299257627.60242 5.48708 2021.61007
Std.Dev 49.49389 0.00000 20342953.14426 4.81884 0.49772
Min 202101.00000 6.00000 257316875.00000 0.00000 2021.00000
Q1 202109.00000 6.00000 283112903.50000 2.00000 2021.00000
Median 202203.00000 6.00000 303685074.50000 2.00000 2022.00000
Q3 202207.00000 6.00000 315836840.00000 12.00000 2022.00000
Max 202301.00000 6.00000 331783034.00000 60.00000 2023.00000
MAD 10.37820 0.00000 22826131.09770 0.00000 0.00000
IQR 98.00000 0.00000 32723928.75000 10.00000 1.00000
CV 0.00024 0.00000 0.06798 0.87822 0.00025
Skewness -0.34048 NaN -0.36192 0.77891 -0.33141
SE.Skewness 0.00231 0.00231 0.00231 0.00231 0.00231
Kurtosis -1.59895 NaN -0.96147 -0.95138 -1.58347
N.Valid 1120952.00000 1120952.00000 1120952.00000 1120674.00000 1120952.00000
Pct.Valid 100.00000 100.00000 100.00000 99.97520 100.00000

2.2 WEB

  • 347k requests with UID
## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
FECHA logID year
Mean 202215.10080 1007903.79074 2022.08303
Std.Dev 77.09805 521795.09125 0.78138
Min 202102.00000 100003.00000 2021.00000
Q1 202112.00000 542518.00000 2021.00000
Median 202208.00000 1012160.50000 2022.00000
Q3 202303.00000 1472624.00000 2023.00000
Max 202311.00000 1875288.00000 2023.00000
MAD 142.32960 688993.87200 1.48260
IQR 191.00000 930102.00000 2.00000
CV 0.00038 0.51770 0.00039
Skewness -0.13873 -0.02792 -0.14594
SE.Skewness 0.00416 0.00416 0.00416
Kurtosis -1.35000 -1.23432 -1.34948
N.Valid 347434.00000 347434.00000 347434.00000
Pct.Valid 100.00000 100.00000 100.00000

2.3 CI

  • 691k requests with UID
## `summarise()` has grouped output by 'CLRS_BCS_ALPHA'. You can override using
## the `.groups` argument.

[1] 11742 [1] 347547

## 
## Attaching package: 'summarytools'
## 
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## 
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## 
## The following object is masked from 'package:tibble':
## 
##     view
CLAL_RESPONSE_ID FECHA year
Mean 53190274.41993 202280.15665 2022.73833
Std.Dev 11619405.93725 42.79875 0.44286
Min 7806065.00000 202104.00000 2021.00000
Q1 44044414.00000 202212.00000 2022.00000
Median 53798713.00000 202304.00000 2023.00000
Q3 62345699.00000 202307.00000 2023.00000
Max 74032941.00000 202310.00000 2023.00000
MAD 13422966.69420 4.44780 0.00000
IQR 18301230.75000 95.00000 1.00000
CV 0.21845 0.00021 0.00022
Skewness -0.21903 -1.13360 -1.13493
SE.Skewness 0.00295 0.00295 0.00295
Kurtosis -0.77205 -0.52458 -0.56330
N.Valid 691674.00000 691674.00000 691674.00000
Pct.Valid 100.00000 100.00000 100.00000

3 BCS Data

3.1 Dates

  • Bankrupcy, registration and deletion dates.

BCS_DATES_1$year_bankrupt Frequency Percent Valid Percent 2018 2125 0.1680 7.28 2019 5031 0.3979 17.24 2020 4259 0.3368 14.59 2021 5814 0.4598 19.92 2022 6531 0.5165 22.37 2023 5430 0.4294 18.60 NA’s 1235349 97.6916
Total 1264539 100.0000 100.00

## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
FECHA FECHA_bankrupt uidOrganisationId year year_bankrupt
Mean 200513.92512 202095.00284 201389340.59625 2005.07491 2020.88678
Std.Dev 1687.27562 155.59489 125220433.43794 16.87339 1.56384
Min 1312.00000 201809.00000 100000012.00000 13.00000 2018.00000
Q1 199906.00000 202001.00000 108105241.00000 1999.00000 2020.00000
Median 200902.00000 202107.00000 114785483.00000 2009.00000 2021.00000
Q3 201701.00000 202209.00000 294176587.00000 2017.00000 2022.00000
Max 210004.00000 202310.00000 499999568.00000 2100.00000 2023.00000
MAD 1319.51400 154.19040 19644131.24100 13.34340 1.48260
IQR 1795.00000 208.00000 186071323.00000 18.00000 2.00000
CV 0.00841 0.00077 0.62178 0.00842 0.00077
Skewness -6.67661 -0.24115 0.99900 -6.67566 -0.24742
SE.Skewness 0.00218 0.01434 0.00218 0.00218 0.01434
Kurtosis 444.71963 -1.11789 -0.48481 444.63849 -1.09671
N.Valid 1264246.00000 29190.00000 1264539.00000 1264246.00000 29190.00000
Pct.Valid 99.97683 2.30835 100.00000 99.97683 2.30835

3.2 BCS Persons Company DATES

  • Individual.ID vs Org.ID. Start date and End year date information.

BCS_PERSONS_COMPANY_DATES_1$signature Frequency Percent 0 2608822 54.34 1 2191742 45.66 Total 4800564 100.00

BCS_PERSONS_COMPANY_DATES_1$year_end Frequency Percent Valid Percent 1900 1 0.00002083 0.00004248 1905 1 0.00002083 0.00004248 1915 1 0.00002083 0.00004248 1922 1 0.00002083 0.00004248 1928 1 0.00002083 0.00004248 1930 1 0.00002083 0.00004248 1939 2 0.00004166 0.00008496 1948 1 0.00002083 0.00004248 1955 2 0.00004166 0.00008496 1959 1 0.00002083 0.00004248 1960 4 0.00008332 0.00016991 1961 5 0.00010415 0.00021239 1962 1 0.00002083 0.00004248 1963 3 0.00006249 0.00012743 1964 1 0.00002083 0.00004248 1965 7 0.00014582 0.00029735 1966 9 0.00018748 0.00038230 1967 13 0.00027080 0.00055222 1968 12 0.00024997 0.00050974 1969 9 0.00018748 0.00038230 1970 15 0.00031246 0.00063717 1971 17 0.00035413 0.00072213 1972 27 0.00056243 0.00114691 1973 21 0.00043745 0.00089204 1974 14 0.00029163 0.00059469 1975 15 0.00031246 0.00063717 1976 16 0.00033329 0.00067965 1977 33 0.00068742 0.00140178 1978 34 0.00070825 0.00144426 1979 32 0.00066659 0.00135930 1980 60 0.00124985 0.00254869 1981 44 0.00091656 0.00186904 1982 28 0.00058326 0.00118939 1983 55 0.00114570 0.00233630 1984 56 0.00116653 0.00237878 1985 61 0.00127068 0.00259117 1986 66 0.00137484 0.00280356 1987 81 0.00168730 0.00344073 1988 95 0.00197893 0.00403543 1989 90 0.00187478 0.00382304 1990 126 0.00262469 0.00535225 1991 2568 0.05349371 0.10908396 1992 9547 0.19887247 0.40553915 1993 13452 0.28021707 0.57141643 1994 14623 0.30461004 0.62115838 1995 19121 0.39830737 0.81222522 1996 25731 0.53599952 1.09300597 1997 34807 0.72506064 1.47853790 1998 40040 0.83406866 1.70082620 1999 45018 0.93776481 1.91228256 2000 53805 1.12080581 2.28553830 2001 69720 1.45232935 2.96157849 2002 68526 1.42745727 2.91085955 2003 70889 1.47668066 3.01123548 2004 74656 1.55515060 3.17125077 2005 72689 1.51417625 3.08769620 2006 73286 1.52661229 3.11305567 2007 76844 1.60072858 3.26419302 2008 99997 2.08302608 4.24769025 2009 96294 2.00588931 4.09039356 2010 89409 1.86246866 3.79793131 2011 90015 1.87509218 3.82367309 2012 88510 1.84374169 3.75974343 2013 91267 1.90117245 3.87685577 2014 93373 1.94504229 3.96631481 2015 93798 1.95389542 3.98436803 2016 96822 2.01688802 4.11282204 2017 99921 2.08144293 4.24446191 2018 103777 2.16176683 4.40825776 2019 109484 2.28064869 4.65068071 2020 108306 2.25610991 4.60064142 2021 114759 2.39053161 4.87475310 2022 118167 2.46152327 5.01951872 2023 93867 1.95533275 3.98729903 NA’s 2446414 50.96097042
Total 4800564 100.00000000 100.00000000

## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
FECHA FECHA_end iidIndividualId signature uidOrganisationId year year_end
Mean 200850.37124 201126.87342 18465974.11187 0.45656 169541703.73502 2008.43869 2011.20354
Std.Dev 1070.41642 792.61691 4451805.86403 0.49811 111555289.07343 10.70471 7.92750
Min 21402.00000 190010.00000 10000002.00000 0.00000 100000012.00000 214.00000 1900.00000
Q1 200107.00000 200508.00000 18577848.00000 0.00000 105835573.00000 2001.00000 2005.00000
Median 201003.00000 201205.00000 19666301.50000 0.00000 109995098.00000 2010.00000 2012.00000
Q3 201709.00000 201807.00000 21501687.50000 1.00000 190248141.00000 2017.00000 2018.00000
Max 210008.00000 202310.00000 23939667.00000 1.00000 499999568.00000 2100.00000 2023.00000
MAD 1186.08000 898.45560 2341953.50760 0.00000 8896981.78320 11.86080 8.89560
IQR 1602.00000 1299.00000 2923838.75000 1.00000 84412568.00000 16.00000 13.00000
CV 0.00533 0.00394 0.24108 1.09101 0.65798 0.00533 0.00394
Skewness -8.15625 -0.36456 -0.97422 0.17442 1.61133 -8.15420 -0.36446
SE.Skewness 0.00112 0.00160 0.00112 0.00112 0.00112 0.00112 0.00160
Kurtosis 1118.18807 -0.72093 -0.47496 -1.96958 1.17399 1117.84320 -0.72042
N.Valid 4800278.00000 2354150.00000 4800564.00000 4800564.00000 4800564.00000 4800278.00000 2354150.00000
Pct.Valid 99.99404 49.03903 100.00000 100.00000 100.00000 99.99404 49.03903

3.3 Transactions

  • Transaction dates & amount information.

BCS_TRANSACTIONS_1$year Frequency Percent 2006 152 0.0688160 2007 219 0.0991493 2008 148 0.0670050 2009 102 0.0461791 2010 3 0.0013582 2014 2 0.0009055 2015 2 0.0009055 2017 257 0.1163533 2018 1396 0.6320202 2019 10043 4.5468333 2020 45772 20.7226581 2021 52555 23.7935702 2022 60905 27.5739206 2023 49323 22.3303257 Total 220879 100.0000000 attr(,“title”) [1] “Year Reported”

## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
amount FECHA sourceId uidOrganisationId year
Mean 374.03796 202142.54007 5.00000 188180913.05786 2021.36185
Std.Dev 975.88345 141.81373 0.00000 120425491.20534 1.42616
Min 0.01000 200602.00000 5.00000 100000012.00000 2006.00000
Q1 85.00000 202012.00000 5.00000 107250490.00000 2020.00000
Median 178.50000 202112.00000 5.00000 113619161.00000 2021.00000
Q3 380.00000 202211.00000 5.00000 261466446.00000 2022.00000
Max 100000.00000 202310.00000 5.00000 499982384.00000 2023.00000
MAD 178.65330 148.26000 0.00000 12589649.12520 1.48260
IQR 295.00000 199.00000 0.00000 154204533.00000 2.00000
CV 2.60905 0.00070 0.00000 0.63995 0.00071
Skewness 22.80931 -2.92152 NaN 1.22945 -2.87706
SE.Skewness 0.00521 0.00521 0.00521 0.00521 0.00521
Kurtosis 1155.01595 26.09236 NaN 0.04333 25.50661
N.Valid 220879.00000 220879.00000 220879.00000 220879.00000 220879.00000
Pct.Valid 100.00000 100.00000 100.00000 100.00000 100.00000

3.4 Collections Cases

  • Start and enda dates, legal status, closing reason ad industry codes. Also amount, balance and payment information.
## `summarise()` has grouped output by 'year_t'. You can override using the
## `.groups` argument.
## `summarise()` has grouped output by 'year_t'. You can override using the
## `.groups` argument.
## 
## Attaching package: 'summarytools'
## 
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## 
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## 
## The following object is masked from 'package:tibble':
## 
##     view
accountBalance amount caseRef FECHA industryCode legalState uidOrganisationId year
Mean 1483.01841 2020.26490 2341665631929.76221 201994.64925 1004.35475 0.42688 228253655.35151 2019.88047
Std.Dev 11106.09578 11751.43031 12588012248181.58984 280.63695 3.23533 0.49463 130101430.79153 2.80972
Min -21365.70000 0.00000 66342.00000 199208.00000 1000.00000 0.00000 100000928.00000 1992.00000
Q1 0.00000 148.90000 8706352.00000 201812.00000 1001.00000 0.00000 112313239.00000 2018.00000
Median 101.35000 469.95000 10213677.00000 202012.00000 1004.00000 0.00000 178598191.00000 2020.00000
Q3 892.65000 1452.20000 11418910.00000 202207.00000 1006.00000 1.00000 340844514.00000 2022.00000
Max 1641210.00000 1641210.00000 70010015033399.00000 202310.00000 1013.00000 1.00000 499987252.00000 2023.00000
MAD 150.26151 573.69207 1951366.98540 290.58960 2.96520 0.00000 107595736.45800 2.96520
IQR 892.62500 1303.30000 2712283.00000 395.00000 5.00000 1.00000 228531275.00000 4.00000
CV 7.48885 5.81678 5.37567 0.00139 0.00322 1.15870 0.56999 0.00139
Skewness 66.18146 57.36641 5.18953 -1.30856 0.31643 0.29565 0.62542 -1.30408
SE.Skewness 0.00887 0.00887 0.00887 0.00887 0.00887 0.00887 0.00887 0.00887
Kurtosis 7528.35448 6031.05736 24.93152 2.61568 -0.46774 -1.91262 -1.08217 2.60095
N.Valid 76239.00000 76239.00000 76239.00000 76239.00000 76239.00000 76239.00000 76239.00000 76239.00000
Pct.Valid 100.00000 100.00000 100.00000 100.00000 100.00000 100.00000 100.00000 100.00000

3.5 Contracts

  • Amount information per request dates.

uidOrganisationId contractId sourceId amount
Min. :100000012 Length:272887 Min. :5 Min. : 0
1st Qu.:107422331 Class :character 1st Qu.:5 1st Qu.: 58
Median :114262831 Mode :character Median :5 Median : 144
Mean :190198117 Mean :5 Mean : 431
3rd Qu.:263765720 3rd Qu.:5 3rd Qu.: 339
Max. :499982384 Max. :5 Max. :150470

requestDate FECHA year FECHA_t
Length:272887 Min. :201707 Min. :2017 Length:272887
Class :character 1st Qu.:202006 1st Qu.:2020 Class :character
Mode :character Median :202109 Median :2021 Mode :character
Mean :202101 Mean :2021
3rd Qu.:202208 3rd Qu.:2022
Max. :202310 Max. :2023
NA’s :110 NA’s :110
year_t
Length:272887
Class :character
Mode :character

BCS_CONTRACTS_1$year Frequency Percent Valid Percent 2017 7392 2.70881 2.710 2018 14140 5.18163 5.184 2019 21094 7.72994 7.733 2020 56015 20.52681 20.535 2021 59574 21.83101 21.840 2022 73141 26.80267 26.813 2023 41421 15.17881 15.185 NA’s 110 0.04031
Total 272887 100.00000 100.000

## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
accountBalance amount caseRef FECHA industryCode legalState uidOrganisationId year
Mean 1483.01841 2020.26490 2341665631929.76221 201994.64925 1004.35475 0.42688 228253655.35151 2019.88047
Std.Dev 11106.09578 11751.43031 12588012248181.58984 280.63695 3.23533 0.49463 130101430.79153 2.80972
Min -21365.70000 0.00000 66342.00000 199208.00000 1000.00000 0.00000 100000928.00000 1992.00000
Q1 0.00000 148.90000 8706352.00000 201812.00000 1001.00000 0.00000 112313239.00000 2018.00000
Median 101.35000 469.95000 10213677.00000 202012.00000 1004.00000 0.00000 178598191.00000 2020.00000
Q3 892.65000 1452.20000 11418910.00000 202207.00000 1006.00000 1.00000 340844514.00000 2022.00000
Max 1641210.00000 1641210.00000 70010015033399.00000 202310.00000 1013.00000 1.00000 499987252.00000 2023.00000
MAD 150.26151 573.69207 1951366.98540 290.58960 2.96520 0.00000 107595736.45800 2.96520
IQR 892.62500 1303.30000 2712283.00000 395.00000 5.00000 1.00000 228531275.00000 4.00000
CV 7.48885 5.81678 5.37567 0.00139 0.00322 1.15870 0.56999 0.00139
Skewness 66.18146 57.36641 5.18953 -1.30856 0.31643 0.29565 0.62542 -1.30408
SE.Skewness 0.00887 0.00887 0.00887 0.00887 0.00887 0.00887 0.00887 0.00887
Kurtosis 7528.35448 6031.05736 24.93152 2.61568 -0.46774 -1.91262 -1.08217 2.60095
N.Valid 76239.00000 76239.00000 76239.00000 76239.00000 76239.00000 76239.00000 76239.00000 76239.00000
Pct.Valid 100.00000 100.00000 100.00000 100.00000 100.00000 100.00000 100.00000 100.00000

3.6 Target Bankruptcy

  • Union of 3 tables to get the bankruptcy target BCS_SHAB_RESPONSES_TO_SCORE, BCS_HR_DATES_TO_SCORE and BCS_CASES_TO_SCORE. The information has been filtered from 2018.
## 
## Attaching package: 'summarytools'
## The following objects are masked from 'package:Hmisc':
## 
##     label, label<-
## The following objects are masked from 'package:descr':
## 
##     descr, freq
## The following object is masked from 'package:tibble':
## 
##     view
FECHA uidOrganisationId year
Mean 202065.11147 300302125.69407 2020.58856
Std.Dev 164.99135 116117180.98938 1.65327
Min 201801.00000 100006799.00000 2018.00000
Q1 201909.00000 201127762.00000 2019.00000
Median 202103.00000 300626282.00000 2021.00000
Q3 202206.00000 400541309.00000 2022.00000
Max 210004.00000 2147483647.00000 2100.00000
MAD 158.63820 147792085.50960 1.48260
IQR 297.00000 199411094.00000 3.00000
CV 0.00082 0.38667 0.00082
Skewness 0.24053 0.05533 0.24389
SE.Skewness 0.00427 0.00427 0.00427
Kurtosis 15.09518 -0.03041 14.98398
N.Valid 328583.00000 328583.00000 328583.00000
Pct.Valid 100.00000 100.00000 100.00000