Pardee Wiki - User contributions [en]

IRF World Road Statistics

2023-09-21T21:36:34Z

Greg.Gillen: Reformatted and added data source summary

== Data Source Summary ==
The International Road Federation (IRF) maintains a database known as World Road Statistics (WRS), comprising over 200 series for over 200 countries. The database is a tremendous resource for infrastructure data, specifically transportation network data. WRS contains information on total road length, but also contains filters to view paved vs. unpaved roads, the kinds of traffic (commercial vs. private), the vehicles using the roadway, accidents and the consequences of them, and more.

To IFs, the IRF provides an important window into the transportation infrastructure of a country. A robust, paved road network makes it easier for a country's exporters to access ports, and for its citizens to find jobs if they are scarce locally. IFs uses three preprocessors from this data source: RoadsPavedKm, the total length of paved roads in a country measured in kilometers; RoadsTotalNetwork, the total length of roads paved or unpaved; and RoadsPaved%, the proportion of the total network which is paved.

=== Pulling Instructions: ===

# Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse[[File:IRF world Road.png|center|frameless|545x545px|IRF World Road Statistics Login Page]]
# Select "Country Comparison - Multiple Years" under Chart Type.[[File:Chart Type Road networks.png|center|frameless|579x579px|Select Country Comparison (Multiple Years)]]
# Manually select each continent in the selection box. In the countries box, select "all countries".
# [[File:Continent and Country selector Road Networks.png|center|frameless|549x549px|Select each continent manually, then "all countries"]]Under themes, select "road network"
# For the preprocessor RoadPavedKm, select "Total Road Network- All Road Types - Paved"
# For the preprocessor RoadsTotalNetwork, select "Total Road Network- All Road Types - Total"
# For the preprocessor RoadsPaved%, select "Paved Network Ratio"
# Select "Show Graph"
# Click on the three bar menu in the upper right corner of the graph, then "download as CSV" or "download as XLS".[[File:World Road menu.png|center|frameless|632x632px|Select the three bar menu in the upper right corner of the graph]]
# The downloaded spreadsheet is in time series data. If necessary, pivot the Excel sheet to bring it into IFs import format.

IRF World Road Statistics

2023-09-20T17:59:36Z

Greg.Gillen: Pulling instructions page created

=== Pulling Instructions: ===

# Navigate to https://datawarehouse.worldroadstatistics.org/users/login. If necessary, register. The registration process is short, and provides immediate access to the data warehouse
# Select "Country Comparison - Multiple Years" under Chart Type.
# Manually select each continent in the selection box. In the countries box, select "all countries".
# Under themes, select "road network"
# For the preprocessor RoadPavedKm, select "Total Road Network- All Road Types - Paved"
# For the preprocessor RoadsTotalNetwork, select "Total Road Network- All Road Types - Total"
# For the preprocessor RoadsPaved%, select "Paved Network Ratio"
# Select "Show Graph"
# Click on the three bar menu in the upper right corner of the graph, then "download as CSV" or "download as XLS".
# The downloaded spreadsheet is in time series data. If necessary, pivot the Excel sheet to bring it into IFs import format.

[[File:IRF world Road.png|thumb|IRF World Road Statistics Login Page]]
[[File:Chart Type Road networks.png|thumb|Select Country Comparison (Multiple Years)]]
[[File:Continent and Country selector Road Networks.png|thumb|Select each continent manually, then "all countries"]]
[[File:World Road menu.png|thumb|Select the three bar menu in the upper right corner of the graph]]

File:World Road menu.png

2023-09-20T17:56:06Z

Greg.Gillen:

World Road graph with menu

File:Continent and Country selector Road Networks.png

2023-09-20T17:46:02Z

Greg.Gillen:

World Road Statistics continent and country selector

File:Chart Type Road networks.png

2023-09-20T17:39:08Z

Greg.Gillen:

A highlighted menu option for World Road pulls

File:IRF world Road.png

2023-09-20T17:12:21Z

Greg.Gillen:

Landing page for IRF world road statistics

File:ED-eqn2.11.png

2023-05-26T16:16:57Z

Greg.Gillen:

Indicators

File:ED-eqn2.10.png

2023-05-26T16:14:56Z

Greg.Gillen:

GDP at MER and PPP

File:ED-eqn2.7.3.png

2023-05-26T15:49:51Z

Greg.Gillen:

Economic Impacts of Climate Change

File:ED eqn2.5.6.png

2023-05-26T15:32:18Z

Greg.Gillen:

Exogenous Parameters

File:ED eqn2.5.5.png

2023-05-26T15:30:39Z

Greg.Gillen:

Country Specific Correction

File:ED-eqn2.4.4.png

2023-05-26T14:44:24Z

Greg.Gillen:

Driver Cluster Knowledge Capital

File:ED-eqn2.4.3.png

2023-05-26T14:41:16Z

Greg.Gillen:

Physical Capital Driver

File:ED-eqn2.4.2.png

2023-05-26T14:39:09Z

Greg.Gillen:

Social capital Drivers

File:ED-eqn2.4.1.2.png

2023-05-26T14:35:57Z

Greg.Gillen:

Human Capital Specification Cont.

File:ED-eqn2.4.1.png

2023-05-26T14:33:49Z

Greg.Gillen:

Human Capital specification

File:ED-eqn2.2-reupload.png

2023-05-26T14:23:03Z

Greg.Gillen:

Total factor productivity growth components

File:ED-eqn2.3.png

2023-05-26T14:21:21Z

Greg.Gillen:

Total Factor productivity growth factors

File:ED-eqn2.2.png

2023-05-26T14:19:27Z

Greg.Gillen:

Total Endogenous productivity factor eqn.

File:ED-eq2.2.png

2023-05-26T14:12:40Z

Greg.Gillen:

The core Cobb-Douglas Production function

File:ED Fig1.1.png

2023-05-26T14:04:47Z

Greg.Gillen:

Models within IFs relating to SDGs

World Poverty Clock

2023-02-08T16:28:26Z

Greg.Gillen: Page creation and list of series. Data pulling instructions in progress

== Overview ==
The World Poverty Clock is a data source that aggregates data relating to global poverty. It can be accessed at [https://worldpoverty.io worldpoverty.io]

== List of Series ==
{| class="wikitable"
|SeriesPovRate1D90cBothSexes0-14WPC
|-
|SeriesPovRate1D90cBothSexes15-24WPC
|-
|SeriesPovRate1D90cBothSexes25-34WPC
|-
|SeriesPovRate1D90cBothSexes35-39WPC
|-
|SeriesPovRate1D90cBothSexes40-49WPC
|-
|SeriesPovRate1D90cBothSexes50-54WPC
|-
|SeriesPovRate1D90cBothSexes55-59WPC
|-
|SeriesPovRate1D90cBothSexes60+WPC
|-
|SeriesPovRate1D90cBothSexesAllAgeWPC
|-
|SeriesPovRate1D90cFemale0-14WPC
|-
|SeriesPovRate1D90cFemale15-24WPC
|-
|SeriesPovRate1D90cFemale25-34WPC
|-
|SeriesPovRate1D90cFemale35-39WPC
|-
|SeriesPovRate1D90cFemale40-49WPC
|-
|SeriesPovRate1D90cFemale50-54WPC
|-
|SeriesPovRate1D90cFemale55-59WPC
|-
|SeriesPovRate1D90cFemale60+WPC
|-
|SeriesPovRate1D90cFemaleAllAgeWPC
|-
|SeriesPovRate1D90cMale0-14WPC
|-
|SeriesPovRate1D90cMale15-24WPC
|-
|SeriesPovRate1D90cMale25-34WPC
|-
|SeriesPovRate1D90cMale35-39WPC
|-
|SeriesPovRate1D90cMale40-49WPC
|-
|SeriesPovRate1D90cMale50-54WPC
|-
|SeriesPovRate1D90cMale55-59WPC
|-
|SeriesPovRate1D90cMale60+WPC
|-
|SeriesPovRate1D90cMaleAllAgeWPC
|-
|SeriesPovRate3D20cBothSexes0-14WPC
|-
|SeriesPovRate3D20cBothSexes15-24WPC
|-
|SeriesPovRate3D20cBothSexes25-34WPC
|-
|SeriesPovRate3D20cBothSexes35-39WPC
|-
|SeriesPovRate3D20cBothSexes40-49WPC
|-
|SeriesPovRate3D20cBothSexes50-54WPC
|-
|SeriesPovRate3D20cBothSexes55-59WPC
|-
|SeriesPovRate3D20cBothSexes60+WPC
|-
|SeriesPovRate3D20cBothSexesAllAgeWPC
|-
|SeriesPovRate3D20cFemale0-14WPC
|-
|SeriesPovRate3D20cFemale15-24WPC
|-
|SeriesPovRate3D20cFemale25-34WPC
|-
|SeriesPovRate3D20cFemale35-39WPC
|-
|SeriesPovRate3D20cFemale40-49WPC
|-
|SeriesPovRate3D20cFemale50-54WPC
|-
|SeriesPovRate3D20cFemale55-59WPC
|-
|SeriesPovRate3D20cFemale60+WPC
|-
|SeriesPovRate3D20cFemaleAllAgeWPC
|-
|SeriesPovRate3D20cMale0-14WPC
|-
|SeriesPovRate3D20cMale15-24WPC
|-
|SeriesPovRate3D20cMale25-34WPC
|-
|SeriesPovRate3D20cMale35-39WPC
|-
|SeriesPovRate3D20cMale40-49WPC
|-
|SeriesPovRate3D20cMale50-54WPC
|-
|SeriesPovRate3D20cMale55-59WPC
|-
|SeriesPovRate3D20cMale60+WPC
|-
|SeriesPovRate3D20cMaleAllAgeWPC
|-
|SeriesPovRate5D50cBothSexes0-14WPC
|-
|SeriesPovRate5D50cBothSexes15-24WPC
|-
|SeriesPovRate5D50cBothSexes25-34WPC
|-
|SeriesPovRate5D50cBothSexes35-39WPC
|-
|SeriesPovRate5D50cBothSexes40-49WPC
|-
|SeriesPovRate5D50cBothSexes50-54WPC
|-
|SeriesPovRate5D50cBothSexes55-59WPC
|-
|SeriesPovRate5D50cBothSexes60+WPC
|-
|SeriesPovRate5D50cBothSexesAllAgeWPC
|-
|SeriesPovRate5D50cFemale0-14WPC
|-
|SeriesPovRate5D50cFemale15-24WPC
|-
|SeriesPovRate5D50cFemale25-34WPC
|-
|SeriesPovRate5D50cFemale35-39WPC
|-
|SeriesPovRate5D50cFemale40-49WPC
|-
|SeriesPovRate5D50cFemale50-54WPC
|-
|SeriesPovRate5D50cFemale55-59WPC
|-
|SeriesPovRate5D50cFemale60+WPC
|-
|SeriesPovRate5D50cFemaleAllAgeWPC
|-
|SeriesPovRate5D50cMale0-14WPC
|-
|SeriesPovRate5D50cMale15-24WPC
|-
|SeriesPovRate5D50cMale25-34WPC
|-
|SeriesPovRate5D50cMale35-39WPC
|-
|SeriesPovRate5D50cMale40-49WPC
|-
|SeriesPovRate5D50cMale50-54WPC
|-
|SeriesPovRate5D50cMale55-59WPC
|-
|SeriesPovRate5D50cMale60+WPC
|-
|SeriesPovRate5D50cMaleAllAgeWPC
|-
|SeriesPovRateBothSexes0-14WPC
|-
|SeriesPovRateBothSexes15-24WPC
|-
|SeriesPovRateBothSexes25-34WPC
|-
|SeriesPovRateBothSexes35-39WPC
|-
|SeriesPovRateBothSexes40-49WPC
|-
|SeriesPovRateBothSexes50-54WPC
|-
|SeriesPovRateBothSexes55-59WPC
|-
|SeriesPovRateBothSexes60+WPC
|-
|SeriesPovRateBothSexesAllAgeWPC
|-
|SeriesPovRateFemale0-14WPC
|-
|SeriesPovRateFemale15-24WPC
|-
|SeriesPovRateFemale25-34WPC
|-
|SeriesPovRateFemale35-39WPC
|-
|SeriesPovRateFemale40-49WPC
|-
|SeriesPovRateFemale50-54WPC
|-
|SeriesPovRateFemale55-59WPC
|-
|SeriesPovRateFemale60+WPC
|-
|SeriesPovRateFemaleAllAgeWPC
|-
|SeriesPovRateMale0-14WPC
|-
|SeriesPovRateMale15-24WPC
|-
|SeriesPovRateMale25-34WPC
|-
|SeriesPovRateMale35-39WPC
|-
|SeriesPovRateMale40-49WPC
|-
|SeriesPovRateMale50-54WPC
|-
|SeriesPovRateMale55-59WPC
|-
|SeriesPovRateMale60+WPC
|-
|SeriesPovRateMaleAllAgeWPC
|}

== Data Pulling Instructions ==

Pulling Data From ILO

2023-01-17T17:33:49Z

Greg.Gillen: Page creation. Walkthrough of ILO pull

The ILOSTAT database can be accessed via direct link or through the ILO organization's main page. Instructions here begin from the main page, [https://www.ilo.org/ ilo.org].

=== 1. ILO Main page ===
Access the ILO's main page at [https://www.ilo.org/ ilo.org]. From the top bar, select 'Statistics and Databases'.
[[File:ILO main.png|center|frameless|837x837px]]

=== 2. Statistics Page ===
Scroll down until ILOSTAT is an available option and select it. ILOSTAT is also available directly at [https://ilostat.ilo.org/ ilostat.ilo.org].
[[File:ILO stat.png|center|frameless|522x522px]]

=== 3. ILOSTAT main page ===
From the ILOSTAT main page, there are two basic ways to access the data. One is via the topics, and the second via the data tab in the top bar.
[[File:ILOSTAT topics.png|center|frameless|625x625px]]

=== 4. Via Topics ===
From a selected topics page, select 'data catalogue' or scroll down to the catalog. Excel downloads of all indicators will be available here. Many indicators will have multiple series to choose from, differing by frequency. Be sure to pay attention to whether the series is annual, quarterly, or monthly.
[[File:ILO data catalog.png|center|frameless|585x585px]]

=== 5. Via Data Tab ===
The data tab has an indicator catalog which automatically searches all indicators by subject, frequency, and classification. Classification is the filter on the subject: in the example 'Informal employment by sex and age', sex and age are classifications. The 'Frequency' filter should also be used. When a filter is added, no additional keystroke or search button is needed, the catalog will update as you filter.
[[File:Indicator Catalog.png|center|frameless|724x724px]]

File:Indicator Catalog.png

2023-01-17T17:31:28Z

Greg.Gillen:

Indicator Catalog at ILOSTAT

File:ILO data catalog.png

2023-01-17T17:24:08Z

Greg.Gillen:

The topics page data catalog from ILOSTAT

File:ILOSTAT topics.png

2023-01-17T17:18:13Z

Greg.Gillen:

The main page of ILOSTAT

File:ILO stat.png

2023-01-17T17:09:59Z

Greg.Gillen:

Access of ILOSTAT through ILO main website

File:ILO main.png

2023-01-17T17:06:42Z

Greg.Gillen:

The ILO main page with highlighted statistics option

ILO

2023-01-17T16:56:02Z

Greg.Gillen: Formatting

== Summary ==
The International Labour Organization (ILO) is an agency of the United Nations concerned with global labor rights and standards. The organization's statistics branch, ILOSTAT, aggregates and processes data from national labor statistics agencies.The Pardee center uses ILOSTAT for statistics on employment, wages, the informal economy, and other topics related to labor. For detailed instructions on pulling data from ILOSTAT, visit the [[Pulling Data From ILO]] Wiki page.

'''ILO Data series'''

'''World Bank: Loayza Informal Labor Forecasts'''

The informal labor forecast series uses the “Toolkit for Informality Scenario Analysis”, created by Norman Loayza, to code information on forecasts for the formal and modern informal labor sectors for 96 countries, and covers the years 2010, 2020 and 2030. The projections are based on the model described in Loayza (2016) “Informality in the Process of Development and Growth,” Policy Research Working Paper WPS7858, World Bank. In the tool, the labor force is allocated into three sectors: the formal sector, the modern informal sector, and a rudimentary informal sector. The aim of the tool is to allow users to generate estimates of the size and evolution of informal labor, using historical data and exogenous projections from the ILO and World Bank, as well as estimates of key parameters from the literature.

IFs has drawn primarily on their forecasts for the formal labor and modern informal labor sector.

Loayza, Norman. 2016. Informality in the Process of Development and Growth. Policy Research Working Paper no. WPS7858. Washington, D.C.: World Bank Group. [http://documents.worldbank.org/curated/en/998481476291165295/Informality-in-theprocess-of-development-and-growth http://documents.worldbank.org/curated/en/998481476291165295/Informality-in-theprocess-of-development-and-growth]

'''Instructions on Importing Informal Labor Forecast data into IFs:'''

This section explains the methodology that is to be followed when importing Informal Labor forecast data from Loayza into IFs. It also describes certain problems that a user might face in interpreting and understanding the data.

'''Source: '''Informal labor data is published by The World Bank. The data is available at this website, [https://data.worldbank.org/data-catalog/informality-scenario-analysis https://data.worldbank.org/data-catalog/informality-scenario-analysis]

'''Types of data: '''Following categories of data need to be imported into IFs:

1.'''Baseline Formal Labor Forecast-'''Labor productivity grows at the same rate as labor costs in the formal labor sector

2.'''Reformist Formal Labor Forecast-'''Labor productivity grows at a faster rate than labor costs in the formal labor sector

3.'''Baseline Informal Labor Forecast-''' Labor productivity grows at the same rate as labor costs in the informal labor sector

4.'''Reformist Informal Labor Forecast-''' Labor productivity grows at a faster rate than labor costs in the informal labor sector

These can be found within the Toolkit spreadsheet, on the user-friendly Menu tab. The options we are concerned with are: '''Basic Scenario Selected ('''Baseline/Reformist) and '''Range for Background Data '''(earliest to most recent).

[[File:Informal labor 1.png|RTENOTITLE]]

'''A summary of the Formal labor and Modern Informal Labor projections for all countries can be found at the bottom of the page.'''

[[File:Informal labor 2.png|RTENOTITLE]]

 

 '''Instructions on Pulling ILO Data Series (Preprossessor and Non-preprocessor series):'''

The following section is on how to pull data series from the ILO website for importing into IFs

'''Source: '''www.ilo.org/ilostat

'''Series:'''

'''LaborInformalFemale%FormalSec, LaborInformalMale%FormalSec'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Employment > Informal employment and informal sector as a percent of employment by sex
#Make sure all years are selected in "Time & Frequency"
#Download
#Filter by Sex (Female or Male) and Economic Activity (Total)

'''LaborParRate15PlusFemale%, LaborParRate15PlusMale, LaborParRate15PlusTotal%'''

#Go to www.ilo.org/ilostat
#Click "Download" in the banner at the top
#Under Select Indicators, choose:
##Population and labor force > Labor force participation rate by sex and ae
#Make sure all years are selected in "Time & Frequency"
#Download
#Filter by Sex (Female, Male, or Total)

'''LaborWageSexRatio'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Earnings and labour cost > mean nominal monthly earnings of employers by sex and economic activity
#Make sure all yeats are selected in "Time & Frequency"
#Download
#Filter classif1.label by Activity(Total)
#Divide Female country-year rate by male

'''Labor15PlusFemale, Labor15PlusMale, Labor15PlusTotal'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##ILO modelled estimates > Labour Force by sex and age - ILO modelled estimates
#Download
#Filter by Age (15+)
#Filter by sex
#Divide observed value by 1,000 (data provided in thousands, IFs requires millions as the units for this series)

'''LabInformNonAgFemale, LabInformNonAgMale, LaborInformNonAgTotal'''

#Go to www.ilo.org/ilostat
#Click "Download" in bannere at the top
#Under Select Indicators, choose:
##Employment > Informal employment and informal sector as a percent of employment by sex
#Download
#Filter by classif1.label (Activity: Non-agriculture)
#Filter by classif2.label (Component: Informal employment)
#Filter by sex

'''Labor InformalFemale&AllProdInformal, LaborInformalMale%AllProdInformal'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Employment > Informal employment and informal sector as a percent of employment by sex
#Download
#Filter by classif2.label (Component: Informal employment)
#Divide sex country-year by total country-year

'''LaborWageMeanNominalFemale, LaborWageMeanNominalMale, LaborWageMeanNominalTotal'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Earnings and labour cost > Mean nominal monthly earnings of employees by sex and occupation
#Download
#Filter by classif1.label(Total)
#Filter by Sex

'''LaborInformalAll, LaborInformalFemale, LaborInformalMale'''

#Go to www.ilo.org/ilostat
#Click "Download"
#Under Select Indicators, choose:
##Employment > Informal employment and informal sector by sex
#Download
#Filter by classif1.label (Component: Informal Employment)
#Filter by sex

'''Population15PlusFemale, Population1PlusMale, Population15PlusTotal'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Population and labour force > Working-age population by sex and age
#Download
#Filter by classif1.label (15+)
#Filter by sex

'''WageRatio'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Earnings and labour cost > Mean nominal monthly earnings of employees by sex and economic activity
#Download
#FIlter by classif1.label (Activity:Total)
#Divided female country-year by male country-year

ILO

2023-01-17T16:55:43Z

Greg.Gillen: Added Summary that links to Pulling data from ILOSTAT. Deletion of outdated info below should be considered.

== Summary ==
The International Labour Organization (ILO) is an agency of the United Nations concerned with global labor rights and standards. The organization's statistics branch, ILOSTAT, aggregates and processes data from national labor statistics agencies.The Pardee center uses ILOSTAT for statistics on employment, wages, the informal economy, and other topics related to labor. For detailed instructions on pulling data from ILOSTAT, visit the [[Pulling Data From ILO]] Wiki page.'''ILO Data series'''

'''World Bank: Loayza Informal Labor Forecasts'''

The informal labor forecast series uses the “Toolkit for Informality Scenario Analysis”, created by Norman Loayza, to code information on forecasts for the formal and modern informal labor sectors for 96 countries, and covers the years 2010, 2020 and 2030. The projections are based on the model described in Loayza (2016) “Informality in the Process of Development and Growth,” Policy Research Working Paper WPS7858, World Bank. In the tool, the labor force is allocated into three sectors: the formal sector, the modern informal sector, and a rudimentary informal sector. The aim of the tool is to allow users to generate estimates of the size and evolution of informal labor, using historical data and exogenous projections from the ILO and World Bank, as well as estimates of key parameters from the literature.

IFs has drawn primarily on their forecasts for the formal labor and modern informal labor sector.

Loayza, Norman. 2016. Informality in the Process of Development and Growth. Policy Research Working Paper no. WPS7858. Washington, D.C.: World Bank Group. [http://documents.worldbank.org/curated/en/998481476291165295/Informality-in-theprocess-of-development-and-growth http://documents.worldbank.org/curated/en/998481476291165295/Informality-in-theprocess-of-development-and-growth]

'''Instructions on Importing Informal Labor Forecast data into IFs:'''

This section explains the methodology that is to be followed when importing Informal Labor forecast data from Loayza into IFs. It also describes certain problems that a user might face in interpreting and understanding the data.

'''Source: '''Informal labor data is published by The World Bank. The data is available at this website, [https://data.worldbank.org/data-catalog/informality-scenario-analysis https://data.worldbank.org/data-catalog/informality-scenario-analysis]

'''Types of data: '''Following categories of data need to be imported into IFs:

1.'''Baseline Formal Labor Forecast-'''Labor productivity grows at the same rate as labor costs in the formal labor sector

2.'''Reformist Formal Labor Forecast-'''Labor productivity grows at a faster rate than labor costs in the formal labor sector

3.'''Baseline Informal Labor Forecast-''' Labor productivity grows at the same rate as labor costs in the informal labor sector

4.'''Reformist Informal Labor Forecast-''' Labor productivity grows at a faster rate than labor costs in the informal labor sector

These can be found within the Toolkit spreadsheet, on the user-friendly Menu tab. The options we are concerned with are: '''Basic Scenario Selected ('''Baseline/Reformist) and '''Range for Background Data '''(earliest to most recent).

[[File:Informal labor 1.png|RTENOTITLE]]

'''A summary of the Formal labor and Modern Informal Labor projections for all countries can be found at the bottom of the page.'''

[[File:Informal labor 2.png|RTENOTITLE]]

 

 '''Instructions on Pulling ILO Data Series (Preprossessor and Non-preprocessor series):'''

The following section is on how to pull data series from the ILO website for importing into IFs

'''Source: '''www.ilo.org/ilostat

'''Series:'''

'''LaborInformalFemale%FormalSec, LaborInformalMale%FormalSec'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Employment > Informal employment and informal sector as a percent of employment by sex
#Make sure all years are selected in "Time & Frequency"
#Download
#Filter by Sex (Female or Male) and Economic Activity (Total)

'''LaborParRate15PlusFemale%, LaborParRate15PlusMale, LaborParRate15PlusTotal%'''

#Go to www.ilo.org/ilostat
#Click "Download" in the banner at the top
#Under Select Indicators, choose:
##Population and labor force > Labor force participation rate by sex and ae
#Make sure all years are selected in "Time & Frequency"
#Download
#Filter by Sex (Female, Male, or Total)

'''LaborWageSexRatio'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Earnings and labour cost > mean nominal monthly earnings of employers by sex and economic activity
#Make sure all yeats are selected in "Time & Frequency"
#Download
#Filter classif1.label by Activity(Total)
#Divide Female country-year rate by male

'''Labor15PlusFemale, Labor15PlusMale, Labor15PlusTotal'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##ILO modelled estimates > Labour Force by sex and age - ILO modelled estimates
#Download
#Filter by Age (15+)
#Filter by sex
#Divide observed value by 1,000 (data provided in thousands, IFs requires millions as the units for this series)

'''LabInformNonAgFemale, LabInformNonAgMale, LaborInformNonAgTotal'''

#Go to www.ilo.org/ilostat
#Click "Download" in bannere at the top
#Under Select Indicators, choose:
##Employment > Informal employment and informal sector as a percent of employment by sex
#Download
#Filter by classif1.label (Activity: Non-agriculture)
#Filter by classif2.label (Component: Informal employment)
#Filter by sex

'''Labor InformalFemale&AllProdInformal, LaborInformalMale%AllProdInformal'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Employment > Informal employment and informal sector as a percent of employment by sex
#Download
#Filter by classif2.label (Component: Informal employment)
#Divide sex country-year by total country-year

'''LaborWageMeanNominalFemale, LaborWageMeanNominalMale, LaborWageMeanNominalTotal'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Earnings and labour cost > Mean nominal monthly earnings of employees by sex and occupation
#Download
#Filter by classif1.label(Total)
#Filter by Sex

'''LaborInformalAll, LaborInformalFemale, LaborInformalMale'''

#Go to www.ilo.org/ilostat
#Click "Download"
#Under Select Indicators, choose:
##Employment > Informal employment and informal sector by sex
#Download
#Filter by classif1.label (Component: Informal Employment)
#Filter by sex

'''Population15PlusFemale, Population1PlusMale, Population15PlusTotal'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Population and labour force > Working-age population by sex and age
#Download
#Filter by classif1.label (15+)
#Filter by sex

'''WageRatio'''

#Go to www.ilo.org/ilostat
#Click "Download" in banner at the top
#Under Select Indicators, choose:
##Earnings and labour cost > Mean nominal monthly earnings of employees by sex and economic activity
#Download
#FIlter by classif1.label (Activity:Total)
#Divided female country-year by male country-year

SeriesGDPPCPPPCUR2011ICP

2022-11-30T17:06:12Z

Greg.Gillen: Page created for data manipulation aid.

The conversion of GDP at Purchasing Power Parity from one currency year to another requires some data manipulation and data from multiple sources. Sources and processes are outlined below.

== Data sources ==

GDP and Population data are supplied by https://tntcat.iiasa.ac.at/SspDb/dsd?Action=htmlpage&page=60. The format for GDP is in billions of 2005 US Dollars.

To convert from 2005 to 2011 dollars, two additional pieces of data must be brought, both available from the World Bank. The first is the GDP deflator, available at https://data.worldbank.org/indicator/NY.GDP.DEFL.KD.ZG

The second is the PPP conversion factor, available at https://data.worldbank.org/indicator/PA.NUS.PPP

Both of the World Bank statistics must be pulled in the initial and target currency year, in this case 2005 and 2011.
[[File:Databank PPP.png|thumb|Only the years 2005 and 2011 are needed. The GDP deflator pull will look very similar.]]

== Data Manipulation ==
The GDP Deflator is a measure of inflation; the conversion of GDP from 2005 to 2011 requires 2005 dollars to be divided by the deflator in 2005 and multiplied by the deflator in 2011. Conversely, the GDP must be multiplied by the 2005 PPP conversion factor and divided by the 2011 conversion factor. Thus, the formula for conversion to 2011 dollars is: <math>\frac{2005$ * PPP2005 * Deflator2011}{PPP2011 * Deflator2005}</math>

For per capita GDP at PPP calculations, this must be divided by population.

File:Databank PPP.png

2022-11-30T16:25:05Z

Greg.Gillen:

The necessary pull from the World Bank Data Bank, using years 2005 and 2011

Pulling SSPs

2022-11-10T04:00:12Z

Greg.Gillen: Page creation

== IIASA + OECD ==

*[[GDP]]
*[[Population]]

Data

2022-11-10T03:57:19Z

Greg.Gillen: Added 'Saving SSPs' under Data Sources

International Futures (IFs) modeling application contains a large historical database that enables model users to explore patterns, understand relationships and estimate parameters. The database consists of a large collection of country level time series tables covering a large number of variables on IFs model issue areas like population, education, health, agriculture, energy, economics, environment, infrastructure, governance and international politics. The database is compiled, in most cases, from publicly available cross-country data series, e.g., World Development Indicators, UNESCO Institute for Education database on education, FAO database on agricultural production, Correlates of War data on conflicts etc. IFs data team add new series to the database and update the existing ones on a regular basis.

At present IFs data tables contain data for 186 countries. Temporal coverage, in most cases, start in 1960.

*[[Database_files_in_IFs|Database files in IFs]]
*[[Importing_data_(general_instructions)|Importing data (general instructions)]]
*[[Vetting_data|Vetting data]]
*[[Consolidating_data|Consolidating data]]
*[[Sub-regional_data|Sub-Regional data]]
*[[IFs_Base_comparson|IFs Base comparison]]
[[File:World Bank.png|thumb|World Bank Logo (pulling data demo)]]
[[File:Test1.png|thumb|Test Image (edit source)]]

= Data Sources =
*[[(NEW) Master Sheet of Tables Series|(NEW) Master Sheet of Tables Series (A - GDP)]]
*[[(NEW) Master Sheet of Tables Series (GE-Z)|(NEW) Master Sheet of Tables Series (GEM - Z)]]
*[[Core Series|Pulling Core Series]]
*[[Pulling Other Series]]
*[[Pulling SSPs]]
*[[(NEW) Country Concordance]]
*[[(NEW) Series Name]]
*[[(NEW) Tutorial Series Name]]

= Preprocessor =

*[[Agriculture_preprocessor|Agriculture preprocessor]]
*[[Economic_preprocessor|Economic_preprocessor]]
*[[Education_data|Education data]]
*[[Energy_data|Energy data]]
*[[Environmental_data|Environmental data]]
*[[Health_preprocessor|Health_preprocessor]]
*[[Infrastructure_data|Infrastructure data]]
*[[Population_data|Population data]]
*[[Socio-Political_data|Socio-Political data]]
*[[State_failure_data|State failure data]]
*[[Water_data|Water data]]
*[[World_Value_Survey_data|World Value Survey data]]

[[EconDash|EconDash]]

[[SDG_data|SDG_data]]