######### Changelog ######### +----------+-----------+-------------------------------------------------------------------+ | Version | Date | Content / Updates | +==========+===========+===================================================================+ | 1.0 | Jan 2022 | First release | +----------+-----------+-------------------------------------------------------------------+ | 1.1 | Jun 2022 | Added *byear_min*, *last_exp_shared*, *age_left*, | | | | *age_right*, *same_study_time* and *same_work_time*. | + + +-------------------------------------------------------------------+ | | | Fixed *cofounders* in U03_entrepreneur_dyads | | | | (calculated as the max across ind_id_left-ind_id_right-org_id). | + + +-------------------------------------------------------------------+ | | | Changelog added. | + + +-------------------------------------------------------------------+ | | | Retargeted *Documentation* shortcut in root dir to local doc | | | | files (target was doc files hosted on GitHub before). | +----------+-----------+-------------------------------------------------------------------+ | 1.2 | Jul 2022 | Created a new baseline for counterfactuals (startups cofounded) | | | | within a 3-year period, and added indicators for within 2-years | | | | and within 1-year | + + +-------------------------------------------------------------------+ | | | Added variables for founder market size | + + +-------------------------------------------------------------------+ | | | New table: T21_cofounders_count | +----------+-----------+-------------------------------------------------------------------+ | 2.0 | Feb 2023 | New table: T22_employee_turnover | + + +-------------------------------------------------------------------+ | | | New table: T23_orbis_financial_data | + + +-------------------------------------------------------------------+ | | | Fixed missing exp_ey in work events that were ongoing at the | | | | time of data collection | + + +-------------------------------------------------------------------+ | | | Fixed "seq" variable in the flat experience table | + + +-------------------------------------------------------------------+ | | | New variables in the dyads table: employee turnover, | | | | ongoing job at the time of data collection, Orbis financial data | +----------+-----------+-------------------------------------------------------------------+ | 2.1 | Mar 2023 | New variables in the dyads table: same_org_nr, same_org_time_nr | | | | same_org_duo_nr, same_org_duo_time_nr, same_org_guo_nr, | | | | same_org_guo_time_nr, | | | | same_sector_nr, same_sector_time_nr, same_funct_area_nr and | | | | same_funct_area_time_nr | +----------+-----------+-------------------------------------------------------------------+ | 2.2 | Apr 2023 | New variables in the dyads table: same_fut_org_id_nr, | | | | same_fut_org_id_cofound_nr | + + +-------------------------------------------------------------------+ | | | Fixed ISCED fields (keywords for fields 3 and 4 were mixed up in | | | | previous versions, and field 10 was missing) | +----------+-----------+-------------------------------------------------------------------+ | 2.3 | Oct 2023 | New variables in the dyads table: same_org_time_last_shared_yr, | | | | same_org_duo_time_last_shared_yr, | | | | same_org_guo_time_last_shared_yr, | | | | same_sector_time_last_shared_yr, | | | | same_funct_area_time_last_shared_yr, | | | | same_edu_time_last_shared_yr, | | | | same_isced_field_time_last_shared_yr, | +----------+-----------+-------------------------------------------------------------------+ | 2.3 | Dec 2023 | Fixed org_id-bvd_id match in public.orbis_fin, | | | | Rebuilt the dyads table, | | | | Added multiple categories to the employee_turnover table | +----------+-----------+-------------------------------------------------------------------+ | 2.4 | Mar 2023 | Improved the link to Orbis through manual matching and checks. | | | | New tables Crunchbase data. Rebuilt the dyads table using | | | | only the Crunchbase startups as focal startups (previous versions | | | | included 'startups' that we detected on LinkedIn but are not | | | | in Crunchbase). New variables in the employee turnover table. | +----------+-----------+-------------------------------------------------------------------+