Database variables
| Variable name | Type | Description | Possible values | Assumptions and pre-processing | References |
|---|---|---|---|---|---|
| Industry type | Categorical | Type of industry to which the megaproject belongs | Infrastructure, Extractive industry, Research and development, Consumption | – | Greiman (2013) |
| Main sector | Categorical | Specific sector related to the industry type | Category of belonging (e.g.: road and transport infrastructure, aerospace, energy, etc.) | – | Greiman (2013) |
| Initial budget (IB) | Numerical | Planned and expected cost of construction | Numbers in terms of billions USD | Converted into US dollars (USD) | Merrow (2012), Natarajan (2022) |
| Relative value in 2021 of initial budget (*) | Numerical | The value that the initial budget has in 2021 considering inflation and GDP | Numbers in terms of billions USD | Converted into USD, adjusted to 2021 value through GDP deflator | |
| IB/GDP (*) | Numerical | The ratio between the initial value and the GDP of the country in that year | Percentage | GDP converted into USD | |
| Total cost of completion (TC) | Numerical | The total investments that the megaproject needed | Numbers in terms of billions USD | Converted into USD | Merrow (2012) |
| Relative value in 2021 of the final cost (*) | Numerical | The value that the final cost of completion has in 2021 taking Into account inflation and GDP | Numbers in terms of billions USD | In case of limited availability of data and negligible time delay, assumed to be equal to the initial budget. Converted into USD, adjusted to 2021 value through GDP deflator | |
| Final cost/GDP (*) | Numerical | The ratio between the total cost of completion and the GDP of the country in that year | Percentage | GDP converted into USD | Flyvbjerg (2014) |
| Overbudget percentage (*) | Numerical | (TC2021-IB2021)/IB2021*100 | Percentage | – | Merrow (2012) |
| Years of delay (*) | Numerical | Number of years of delay | Numbers (integers) | In case of unavailability of data and negligible overbudget, assumed to be 0 | Merrow (2012) |
| Start of construction | Numerical | Year in which the construction of the megaproject begins | Years | – | Greiman (2013) |
| End of construction | Numerical | Year in which the construction of the megaproject ends | Years | – | Greiman (2013) |
| Years of delay/duration | Numerical | The ratio between the number of years of delay and the total duration of the megaproject | Percentage | – | |
| Duration (*) | Numerical | Number of years in which the megaproject has been realized | Numbers (integers) | – | Greiman (2013) |
| Owner/Contractor | Categorical | The one who has the ownership over the project and is accountable for the project’s success or failure | Public, private, PPP, governmentetc | – | Brockmann (2020) |
| Region | Categorical | Geographical location of the project | Countries and continents | – | Greiman (2013), Natarajan (2022) |
| Extension | Categorical | Geographical extension of the project impact | City, national, multi-national | – | Greiman (2013) |
| Impact categories | Categorical | The impact of the project (local, national,international) | Military scope, national economic development, social progress, environmental protection, profit interest | – | Zheng et al. (2017) |
| Variable name | Type | Description | Possible values | Assumptions and pre-processing | References |
|---|---|---|---|---|---|
| Industry type | Categorical | Type of industry to which the megaproject belongs | Infrastructure, Extractive industry, Research and development, Consumption | – | |
| Main sector | Categorical | Specific sector related to the industry type | Category of belonging (e.g.: road and transport infrastructure, aerospace, energy, etc.) | – | |
| Initial budget (IB) | Numerical | Planned and expected cost of construction | Numbers in terms of billions USD | Converted into US dollars (USD) | |
| Relative value in 2021 of initial budget (*) | Numerical | The value that the initial budget has in 2021 considering inflation and GDP | Numbers in terms of billions USD | Converted into USD, adjusted to 2021 value through GDP deflator | |
| IB/GDP (*) | Numerical | The ratio between the initial value and the GDP of the country in that year | Percentage | GDP converted into USD | |
| Total cost of completion (TC) | Numerical | The total investments that the megaproject needed | Numbers in terms of billions USD | Converted into USD | |
| Relative value in 2021 of the final cost (*) | Numerical | The value that the final cost of completion has in 2021 taking Into account inflation and GDP | Numbers in terms of billions USD | In case of limited availability of data and negligible time delay, assumed to be equal to the initial budget. Converted into USD, adjusted to 2021 value through GDP deflator | |
| Final cost/GDP (*) | Numerical | The ratio between the total cost of completion and the GDP of the country in that year | Percentage | GDP converted into USD | |
| Overbudget percentage (*) | Numerical | (TC2021-IB2021)/IB2021*100 | Percentage | – | |
| Years of delay (*) | Numerical | Number of years of delay | Numbers (integers) | In case of unavailability of data and negligible overbudget, assumed to be 0 | |
| Start of construction | Numerical | Year in which the construction of the megaproject begins | Years | – | |
| End of construction | Numerical | Year in which the construction of the megaproject ends | Years | – | |
| Years of delay/duration | Numerical | The ratio between the number of years of delay and the total duration of the megaproject | Percentage | – | |
| Duration (*) | Numerical | Number of years in which the megaproject has been realized | Numbers (integers) | – | |
| Owner/Contractor | Categorical | The one who has the ownership over the project and is accountable for the project’s success or failure | Public, private, PPP, governmentetc | – | |
| Region | Categorical | Geographical location of the project | Countries and continents | – | |
| Extension | Categorical | Geographical extension of the project impact | City, national, multi-national | – | |
| Impact categories | Categorical | The impact of the project (local, national,international) | Military scope, national economic development, social progress, environmental protection, profit interest | – |
Sharing content requires targeting cookies to be enabled. Please update your cookie preferences to use this feature.