Doing Business: Difference between revisions

From Pardee Wiki
Jump to navigation Jump to search
No edit summary
 
(17 intermediate revisions by 6 users not shown)
Line 1: Line 1:
= Current Status =
The World Bank has an annual global doing business report available here <[http://www.doingbusiness.org/ http://www.doingbusiness.org/]>. The latest data has been pulled from the&nbsp;report updated on February 15, 2019 which covers 189 economies from year 2004 to year 2019.
 
Kristen Kennedy pulled and Nenani Sichone vetted this data and it was completed on April 1st for the 7.21 packaging.<br/>It should be consolidated into 7.21. Link to teamwork task:&nbsp;https://pardeecenter.teamwork.com/tasks/3766554


= Series pulled from the World Bank Doing Business report&nbsp; =
= Series pulled from the World Bank Doing Business report&nbsp; =


{| border="1" bgcolor="#ffffff" cellspacing="0"
{| cellpadding="0" cellspacing="0" border="1" width="64"
|+ <font face="Calibri" color="#000000">'''DataDict 720'''</font>
|-
| width="64" height="20" | Table
|-
| height="20" | SeriesGovBetterBusinessIndex
|-
| height="20" | SeriesGovBusinessRegulationIndex
|-
| height="20" | SeriesGovWBDoingBusConstructionPermitDays
|-
| height="20" | SeriesGovWBDoingBusConstructionPermitProcedures
|-
| height="20" | SeriesGovWBDoingBusContainerExportCostUSD<br/>
|-
| height="20" | SeriesGovWBDoingBusContainerImportCostUSD
|-
| height="20" | SeriesGovWBDoingBusContractEnforceDays
|-
| height="20" | SeriesGovWBDoingBusCostClose
|-
| height="20" | SeriesGovWBDoingBusCreditTransparency
|-
| height="20" | SeriesGovWBDoingBusDirectorLiability
|-
| height="20" | SeriesGovWBDoingBusDisclosureIndex
|-
| height="20" | SeriesGovWBDoingBusEmpRigiIndex
|-
| height="20" | SeriesGovWBDoingBusExportDocumentationNeeded
|-
| height="20" | SeriesGovWBDoingBusHiringDiffIndex
|-
| height="20" | SeriesGovWBDoingBusImportDays
|-
| height="20" | SeriesGovWBDoingBusImportDocumentationNeeded
|-
| height="20" | SeriesGovWBDoingBusinessProcedures
|-
| height="20" | SeriesGovWBDoingBusinessPropRegDays
|-
| height="20" | SeriesGovWBDoingBusinessRanking
|-
| height="20" | SeriesGovWBDoingBusinessStartDays
|-
| height="20" | SeriesGovWBDoingBusInvestorProtection
|-
| height="20" | SeriesGovWBDoingBusLegalRightsStrengthIndex
|-
| height="20" | SeriesGovWBDoingBusPropertyProceduresRequired
|-
| height="20" | SeriesGovWBDoingBusRedundancyCostperWeekSalary
|-
| height="20" | SeriesGovWBDoingBusRedundancyIndex
|-
| height="20" | SeriesGovWBDoingBusShareholderSuits
|-
| height="20" | SeriesGovWBDoingBusTax%Profit
|-
| height="20" | SeriesGovWBDoingBusTaxHoursperPerson
|-
|-
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Table</font>
| height="20" | SeriesGovWBDoingBusTimeClose
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Group</font>
|-
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Definition</font>
| height="20" | SeriesGovWBDoingBusTotalTaxRate
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Source</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Last IFs Update</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">UsedInPreprocessor</font>
! bgcolor="#c0c0c0" | <font face="Calibri" color="#000000">Years</font>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusConstructionPermitDays</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">The number of days need to get a construction permit</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/28</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusConstructionPermitProcedures</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of procedures needed to get a construction permit</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/28</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusContainerExportCostUSD</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Cost of exporting one container in USD</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusContainerImportCostUSD</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Cost of importing one container in USD</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusContractEnforceDays</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of days required to enforce a contract</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusCostClose</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Average cost of closing a business in percent of estate</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusCreditTransparency</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">World Bank index on the depth of credit information (0-6)</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusDirectorLiability</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">World Bank index on the extent of director liability</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusDisclosureIndex</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">World Bank index on the extent of disclosure</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusEmpRigiIndex</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">World Bank index on the rigidity of employment</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2010/03/30</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusExportDocumentationNeeded</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of documents needed to export</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusHiringDiffIndex</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">World Bank index documenting the difficulty in hiring workers 0-100</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2010/03/30</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusImportDays</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of days required to import</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusImportDocumentationNeeded</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of documents needed to import</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusinessCostofStarting</font>
| <font face="Calibri" color="#000000">Governance</font>
| <font face="Calibri" color="#000000">Cost of registring a business as a percent of per capita income</font>
| <font face="Calibri" color="#000000">WDI BATCH PULL</font>
| <font face="Calibri" color="#000000">2015/07/14</font>
| align="RIGHT" | <font face="Calibri" color="#000000">Yes</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusinessCustomsDays</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of days required to clear customs</font>
| <font face="Calibri" color="#000000">WDI 2015 September BATCH PULL</font>
| <font face="Calibri" color="#000000">2015/10/08</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusinessProcedures</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of procedures required to start a business</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusinessPropRegDays</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of days required to registar property</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusinessRanking</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Total overall ranking of ease of doing business</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusinessStartDays</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of days required to start a business</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusInvestorProtection</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">World bank index measuring the strength of investor protection (0-10)</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusLegalRightsStrengthIndex</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">World Bank index of the strength of legal rights, specifically property rights (0-10)</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusPropertyProceduresRequired</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of procedures required to register for property</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusRedundancyCostperWeekSalary</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Cost of firing a worker (in weeks of salary)</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2010/03/30</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusRedundancyIndex</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">World Bank index on the difficulty in firing a worker</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2010/03/30</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusShareholderSuits</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">World Bank index measuring the ability of shareholders to take legal action</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusTax%Profit</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Total tax rate as a percentage of profit</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusTaxHoursperPerson</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Number of hours per year a person works to pay taxes</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusTimeClose</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">Average number of years needed to close a business</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|- valign="TOP"
| <font face="Calibri" color="#000000">SeriesGovWBDoingBusTotalTaxRate</font>
| <font face="Calibri" color="#000000">Government</font>
| <font face="Calibri" color="#000000">The total tax rate expressed as a share of commercial profits.</font>
| <font face="Calibri" color="#000000">World Bank Doing Business; [http://www.doingbusiness.org/ http://www.doingbusiness.org/]</font>
| <font face="Calibri" color="#000000">2014/04/07</font>
| align="RIGHT" | <font face="Calibri" color="#000000">No</font>
| <br/>
|}
|}


= Instructions on pulling doing business series&nbsp; =
= Instructions on pulling doing business series&nbsp; =
#The data can be accessed from the World Bank’s Doing Business database page [http://data.worldbank.org/data-catalog/doing-business-database http://data.worldbank.org/data-catalog/doing-business-database]. By clicking on the tab entitled "Data & Resources", the raw data can be downloaded either through CSV format or Excel format.
#Using Excel files as an example, the file contains three sheets with the names Data, Series, and Footnote. The Doing Business data was acquired from the Data tab. Prior to importing the data into the IFs, the raw data needs some pre-processing. The first step is to concord the country names with the IFs country names since the IFs does not have a specific country concording list for Doing Business data. Then, the next step is to separate the data into several individual&nbsp;files based on different series. After those two procedures, the data should be ready for import.
#One thing to note in the country concording process is that there are some sub-areas in the data (e.g., China - Beijing). Those data should be ignored since we only care about the data in certain countries. However, data for areas like 'Hong Kong, China' would be different, we actually need the data for that. Thus, to differentiate from sub-areas and main areas, you should look for that dash symbol '-' (i.e., China - Beijing would be treated as a sub-area).
#Certain series we had in the system are not being measured in the Doing Business data. Thus, series that were not included in the original downloaded data were typically not updated. Since the organization constantly updates their data and methodology each year, some series will not be concordant through years. Those series will need to be handled carefully.
#Series that were not updated are as follows (11 series in total): BetterBusinessIndex, BusinessRegulationIndex, ConstructionPermitDays, ConstructionPermitProcedures, EmpRigiIndex, ExportDocumentationNeeded, ImportDocumentationNeeded,&nbsp;HiringDiffIndex, RedundancyCostperWeekSalary, RedundancyIndex, TotalTaxRate. Note that the Tax%Profit series was updated using&nbsp;the "Total tax rate (% of profit)" in the raw downloaded data.
#Series that have been updated but need to be put on hold due to inconsistency in values through years are:&nbsp;SeriesGovWBDoingBusContainerExportCostUSD, SeriesGovWBDoingBusContainerImportCostUSD, SeriesGovWBDoingBusCreditTransparency, SeriesGovWBDoingBusImportDays, SeriesGovWBDoingBusLegalRightsStrengthIndex. Those 5 series in the most recent updated data only cover the years 2014-2017 while data in IFs covers 2006-2014. Moreover, the values in the overlapping year 2014 differ so much that we might need to create them&nbsp;as new series.
== '''2019 Update''' ==
For the 2019 update, the WB Doing Business data was pulled from the website using R. It was then cleaned and concorded with the corresponding variable names and the IFs country concordance list. The R script can be found in the Data Team Shared folder and can be used for future pulls to automate the process. In 2015, there were updates to the Doing Business methodology. Specific changes that affected our pulls were for the following series, and t<span>hese series are no longer reported (stopped in 2015) and are now disaggregated into two separate series for each one.</span>
'''<span>GovWBDoingBusImportDays;&nbsp;SeriesGovWBDoingBusContainerImportCostUSD;&nbsp;SeriesGovWBDoingBusContainerExportCostUSD.</span>'''
<span>The following new series start in 2015. While they are aggregated to create the new variable, they don not relate to the old variables we have in IFs due to the change in methodology from the source.&nbsp;</span>
<font style="background-color: rgb(255, 255, 255);">GovWBDoingBusContainExportCostUSDNew, calculated by adding the Documentary compliance and Border compliance costs for import together.</font>
<font style="background-color: rgb(255, 255, 255);">GovWBDoingBusContainImportCostUSDNew, calculated by&nbsp;</font><span style="display: inline !important; float: none; background-color: rgb(255, 255, 255); color: rgb(51, 51, 51); font-family: sans-serif,arial,verdana,&quot;trebuchet ms"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">adding the Documentary compliance and Border compliance costs for export together.</span>
<font style="background-color: rgb(255, 255, 255);">GovWBDoingBusImportDaysNew, calculated by adding&nbsp;</font><span style="display: inline !important; float: none; background-color: rgb(255, 255, 255); color: rgb(51, 51, 51); font-family: sans-serif,arial,verdana,&quot;trebuchet ms"; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px;">the Documentary compliance and Border compliance time for import together.</span>
== '''2024 Update''' ==
'''For the 2024 update, the Doing Business project faced criticism and was discontinued in 2021.''' In 2020, the '''World Bank''' halted the '''Doing Business''' report after an internal audit revealed that data had been improperly altered in past reports to boost the rankings of certain countries. Specifically, it was found that the rankings of '''China''', '''Saudi Arabia''', the '''United Arab Emirates''', and '''Azerbaijan''' had been adjusted inappropriately due to pressure from senior World Bank officials. In '''September 2021''', the World Bank officially announced that it would discontinue the '''Doing Business''' report. The decision came after the findings of the investigation, which detailed significant ethical concerns, particularly with regards to the manipulation of rankings for political and economic reasons.
We updated 1 series in preprocessor, '''GovWBDoingBusinessCostofStarting.'''
* Download archive corrected data from https://archive.doingbusiness.org/en/doingbusiness[[File:Image dobu 1.png|none|thumb|878x878px]]
* Open the downloaded file and in the "All Data" tab, find the Cost - Men (% of income per capita) and Cost - Women (% of income per capita) under Starting a business.[[File:Image dobu 2.png|none|thumb|1005x1005px]]
* Take an average of the 2 columns listed above to get the new values.
* Compare the new values with the values in IFs.
* Blend in the new values to the values in IFs followed by 2 rules:
** If he new values are null, then use the values in IFs to fill the null.
** If the new values are not null, then use the new values.
* The final series contains values from 2003 to 2020.
=== Business Ready (B-READY) ===
The World Bank's "[https://www.worldbank.org/en/businessready/about-us Business Ready]" (B-READY) project is a new initiative launched to replace the discontinued "Doing Business" report. The B-READY project, which began its pilot phase in 2024, seeks to assess countries on ten key indicators, focusing on how business regulations are implemented in practice compared to what is written in law. Here are the new indicators will be provided in the BusinessReady. (<nowiki>https://www.enterprisesurveys.org/content/dam/enterprisesurveys/documents/methodology/Indicator-Description.pdf</nowiki>)
= Model implications =
What are the biggest differences (in both relative and absolute terms) in 2015? 2050? 2100?
What are the effects of these changes on other variables in the model?
Any other major changes or anomalies?

Latest revision as of 16:45, 4 October 2024

The World Bank has an annual global doing business report available here <http://www.doingbusiness.org/>. The latest data has been pulled from the report updated on February 15, 2019 which covers 189 economies from year 2004 to year 2019.

Series pulled from the World Bank Doing Business report 

Table
SeriesGovBetterBusinessIndex
SeriesGovBusinessRegulationIndex
SeriesGovWBDoingBusConstructionPermitDays
SeriesGovWBDoingBusConstructionPermitProcedures
SeriesGovWBDoingBusContainerExportCostUSD
SeriesGovWBDoingBusContainerImportCostUSD
SeriesGovWBDoingBusContractEnforceDays
SeriesGovWBDoingBusCostClose
SeriesGovWBDoingBusCreditTransparency
SeriesGovWBDoingBusDirectorLiability
SeriesGovWBDoingBusDisclosureIndex
SeriesGovWBDoingBusEmpRigiIndex
SeriesGovWBDoingBusExportDocumentationNeeded
SeriesGovWBDoingBusHiringDiffIndex
SeriesGovWBDoingBusImportDays
SeriesGovWBDoingBusImportDocumentationNeeded
SeriesGovWBDoingBusinessProcedures
SeriesGovWBDoingBusinessPropRegDays
SeriesGovWBDoingBusinessRanking
SeriesGovWBDoingBusinessStartDays
SeriesGovWBDoingBusInvestorProtection
SeriesGovWBDoingBusLegalRightsStrengthIndex
SeriesGovWBDoingBusPropertyProceduresRequired
SeriesGovWBDoingBusRedundancyCostperWeekSalary
SeriesGovWBDoingBusRedundancyIndex
SeriesGovWBDoingBusShareholderSuits
SeriesGovWBDoingBusTax%Profit
SeriesGovWBDoingBusTaxHoursperPerson
SeriesGovWBDoingBusTimeClose
SeriesGovWBDoingBusTotalTaxRate

Instructions on pulling doing business series 

  1. The data can be accessed from the World Bank’s Doing Business database page http://data.worldbank.org/data-catalog/doing-business-database. By clicking on the tab entitled "Data & Resources", the raw data can be downloaded either through CSV format or Excel format.
  2. Using Excel files as an example, the file contains three sheets with the names Data, Series, and Footnote. The Doing Business data was acquired from the Data tab. Prior to importing the data into the IFs, the raw data needs some pre-processing. The first step is to concord the country names with the IFs country names since the IFs does not have a specific country concording list for Doing Business data. Then, the next step is to separate the data into several individual files based on different series. After those two procedures, the data should be ready for import.
  3. One thing to note in the country concording process is that there are some sub-areas in the data (e.g., China - Beijing). Those data should be ignored since we only care about the data in certain countries. However, data for areas like 'Hong Kong, China' would be different, we actually need the data for that. Thus, to differentiate from sub-areas and main areas, you should look for that dash symbol '-' (i.e., China - Beijing would be treated as a sub-area).
  4. Certain series we had in the system are not being measured in the Doing Business data. Thus, series that were not included in the original downloaded data were typically not updated. Since the organization constantly updates their data and methodology each year, some series will not be concordant through years. Those series will need to be handled carefully.
  5. Series that were not updated are as follows (11 series in total): BetterBusinessIndex, BusinessRegulationIndex, ConstructionPermitDays, ConstructionPermitProcedures, EmpRigiIndex, ExportDocumentationNeeded, ImportDocumentationNeeded, HiringDiffIndex, RedundancyCostperWeekSalary, RedundancyIndex, TotalTaxRate. Note that the Tax%Profit series was updated using the "Total tax rate (% of profit)" in the raw downloaded data.
  6. Series that have been updated but need to be put on hold due to inconsistency in values through years are: SeriesGovWBDoingBusContainerExportCostUSD, SeriesGovWBDoingBusContainerImportCostUSD, SeriesGovWBDoingBusCreditTransparency, SeriesGovWBDoingBusImportDays, SeriesGovWBDoingBusLegalRightsStrengthIndex. Those 5 series in the most recent updated data only cover the years 2014-2017 while data in IFs covers 2006-2014. Moreover, the values in the overlapping year 2014 differ so much that we might need to create them as new series.

2019 Update

For the 2019 update, the WB Doing Business data was pulled from the website using R. It was then cleaned and concorded with the corresponding variable names and the IFs country concordance list. The R script can be found in the Data Team Shared folder and can be used for future pulls to automate the process. In 2015, there were updates to the Doing Business methodology. Specific changes that affected our pulls were for the following series, and these series are no longer reported (stopped in 2015) and are now disaggregated into two separate series for each one.

GovWBDoingBusImportDays; SeriesGovWBDoingBusContainerImportCostUSD; SeriesGovWBDoingBusContainerExportCostUSD.

The following new series start in 2015. While they are aggregated to create the new variable, they don not relate to the old variables we have in IFs due to the change in methodology from the source. 

GovWBDoingBusContainExportCostUSDNew, calculated by adding the Documentary compliance and Border compliance costs for import together.

GovWBDoingBusContainImportCostUSDNew, calculated by adding the Documentary compliance and Border compliance costs for export together.

GovWBDoingBusImportDaysNew, calculated by adding the Documentary compliance and Border compliance time for import together.

2024 Update

For the 2024 update, the Doing Business project faced criticism and was discontinued in 2021. In 2020, the World Bank halted the Doing Business report after an internal audit revealed that data had been improperly altered in past reports to boost the rankings of certain countries. Specifically, it was found that the rankings of China, Saudi Arabia, the United Arab Emirates, and Azerbaijan had been adjusted inappropriately due to pressure from senior World Bank officials. In September 2021, the World Bank officially announced that it would discontinue the Doing Business report. The decision came after the findings of the investigation, which detailed significant ethical concerns, particularly with regards to the manipulation of rankings for political and economic reasons.

We updated 1 series in preprocessor, GovWBDoingBusinessCostofStarting.

  • Download archive corrected data from https://archive.doingbusiness.org/en/doingbusiness
    Image dobu 1.png
  • Open the downloaded file and in the "All Data" tab, find the Cost - Men (% of income per capita) and Cost - Women (% of income per capita) under Starting a business.
    Image dobu 2.png
  • Take an average of the 2 columns listed above to get the new values.
  • Compare the new values with the values in IFs.
  • Blend in the new values to the values in IFs followed by 2 rules:
    • If he new values are null, then use the values in IFs to fill the null.
    • If the new values are not null, then use the new values.
  • The final series contains values from 2003 to 2020.

Business Ready (B-READY)

The World Bank's "Business Ready" (B-READY) project is a new initiative launched to replace the discontinued "Doing Business" report. The B-READY project, which began its pilot phase in 2024, seeks to assess countries on ten key indicators, focusing on how business regulations are implemented in practice compared to what is written in law. Here are the new indicators will be provided in the BusinessReady. (https://www.enterprisesurveys.org/content/dam/enterprisesurveys/documents/methodology/Indicator-Description.pdf)

Model implications

What are the biggest differences (in both relative and absolute terms) in 2015? 2050? 2100?

What are the effects of these changes on other variables in the model?

Any other major changes or anomalies?