1 BCS Data

1.1 Dates >=2020

Bankrupcy Information uidOrganisationId hrRegistrationDate hrDeletionDate hrBankruptcyDate
Min. :100016450 Length:185848 Length:185848 Length:185848
1st Qu.:219801957 Class :character Class :character Class :character
Median :313030656 Mode :character Mode :character Mode :character
Mean :312897057
3rd Qu.:406710556
Max. :499999568

 FECHA             year        FECHA_t             year_t

Min. :202001 Min. :2020 Length:185848 Length:185848
1st Qu.:202012 1st Qu.:2020 Class :character Class :character
Median :202111 Median :2021 Mode :character Mode :character
Mean :202149 Mean :2021
3rd Qu.:202211 3rd Qu.:2022
Max. :210004 Max. :2100

FECHA_bankrupt year_bankrupt
Min. :201906 Min. :2019
1st Qu.:202207 1st Qu.:2022
Median :202302 Median :2023
Mean :202254 Mean :2022
3rd Qu.:202306 3rd Qu.:2023
Max. :202310 Max. :2023
NA’s :183934 NA’s :183934
BCS_DATES_1$year_bankrupt Frequency Percent Valid Percent 2019 1 0.0005381 0.05225 2020 7 0.0037665 0.36573 2021 154 0.0828634 8.04598 2022 667 0.3588954 34.84848 2023 1085 0.5838104 56.68757 NA’s 183934 98.9701261
Total 185848 100.0000000 100.00000

1.2 BCS Persons Company DATES >=2020

Indiv.ID vs Org.ID. Start date and End year date information.

iidIndividualId uidOrganisationId startDate endDate
Min. :10000004 Min. :100000012 Min. :2020-01-02 Length:764549
1st Qu.:20759592 1st Qu.:109700127 1st Qu.:2021-01-13 Class :character
Median :23390243 Median :204921710 Median :2021-12-16 Mode :character
Mean :21209539 Mean :238479433 Mean :2021-12-06
3rd Qu.:23705976 3rd Qu.:354012856 3rd Qu.:2022-11-16
Max. :23939667 Max. :499999568 Max. :2100-08-21

signature FECHA year FECHA_t
Min. :0.000 Min. :202001 Min. :2020 Length:764549
1st Qu.:0.000 1st Qu.:202101 1st Qu.:2021 Class :character
Median :0.000 Median :202112 Median :2021 Mode :character
Mean :0.498 Mean :202152 Mean :2021
3rd Qu.:1.000 3rd Qu.:202211 3rd Qu.:2022
Max. :1.000 Max. :210008 Max. :2100

year_t            FECHA_end         year_end

Length:764549 Min. :199802 Min. :1998
Class :character 1st Qu.:202112 1st Qu.:2021
Mode :character Median :202209 Median :2022
Mean :202214 Mean :2022
3rd Qu.:202304 3rd Qu.:2023
Max. :202310 Max. :2023
NA’s :664136 NA’s :664136
BCS_PERSONS_COMPANY_DATES_1$year_end Frequency Percent Valid Percent 1998 1 0.0001308 0.0009959 1999 1 0.0001308 0.0009959 2000 1 0.0001308 0.0009959 2020 5864 0.7669881 5.8398813 2021 19798 2.5895005 19.7165706 2022 36010 4.7099663 35.8618904 2023 38738 5.0667779 38.5786701 NA’s 664136 86.8663748
Total 764549 100.0000000 100.0000000

1.3 Transactions >=2020

Transaction dates & amount information

BCS_TRANSACTIONS_1$year Frequency Percent 2020 45772 21.95 2021 52555 25.20 2022 60905 29.20 2023 49323 23.65 Total 208555 100.00 attr(,“title”) [1] “Year Reported”

1.4 Collections >=2020

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.

BCS_CASES_1$year Frequency Percent 2020 10847 22.26 2021 11762 24.13 2022 12874 26.42 2023 13252 27.19 Total 48735 100.00

1.5 Contracts >=2020

Amount information per request dates

BCS_CONTRACTS_1$year Frequency Percent 2020 56015 24.34 2021 59574 25.88 2022 73141 31.78 2023 41421 18.00 Total 230151 100.00