Appendix C: Summary Table

C.1 Display Most Variables of the Summary Table

R Code C.1 : Display All Variables of the Summary Table with the exception of the simple & technical explanations and the methods used for computations

Code

summary_table |> 
    dplyr::select(1:12, 17) |>  
    DT::datatable(
         options = list(
           initComplete = htmlwidgets::JS(
              "function(settings, json) {",
              paste0("$(this.api().table().container()).css({'font-size': '", font.size, "'});"),
              "}")
           ) 
         )

Show entries

Search:

	Country	Country Code	Short name of variable	Type(s) of variable	Variable category	Variable level(s)	Years	Age groups	Population categories	WID.world code	Percentiles	Years available for these percentiles
1	Afghanistan	AF	National income	Average, Macroeconomic variable	Income macro variable	1, 2	1950-2017	Aggregate on all ages	Individuals	anninc992i, mnninc999i	Macro variable (not applicable)	Macro variable (not applicable)
2	Afghanistan	AF	Net domestic product	Average, Macroeconomic variable	Income macro variable	1, 2	1950-2017	Aggregate on all ages	Individuals	andpro992i, mndpro999i	Macro variable (not applicable)	Macro variable (not applicable)
3	Afghanistan	AF	Consumption of fixed capital of national economy	Average, Macroeconomic variable	Income macro variable	3	1950-2017	Aggregate on all ages	Individuals	aconfc992i, mconfc999i	Macro variable (not applicable)	Macro variable (not applicable)
4	Afghanistan	AF	Gross domestic product	Average, Macroeconomic variable	Income macro variable	3	1950-2017	Aggregate on all ages	Individuals	agdpro992i, mgdpro999i	Macro variable (not applicable)	Macro variable (not applicable)
5	Afghanistan	AF	Net foreign income	Average, Macroeconomic variable	Income macro variable	2	1979-2017	Aggregate on all ages	Individuals	annfin992i, mnnfin999i	Macro variable (not applicable)	Macro variable (not applicable)
6	Afghanistan	AF	National income price index	Index	Other macro variable	1	1971-2017	Aggregate on all ages	Individuals	inyixx999i	Macro variable (not applicable)	Macro variable (not applicable)
7	Afghanistan	AF	Population	Population	Other macro variable	1	1990-2017	Detailed separation by age (5-year brackets) available	Female, Individuals, Male	npopul111m	Macro variable (not applicable)	Macro variable (not applicable)
8	Afghanistan	AF	PPP conversion factor, LCU per EUR	Exchange rate	Other macro variable	1	1995-2017	Aggregate on all ages	Individuals	xlceup999i	Macro variable (not applicable)	Macro variable (not applicable)
9	Afghanistan	AF	Market exchange rate, LCU per EUR	Exchange rate	Other macro variable	1	2017	Aggregate on all ages	Individuals	xlceux999i	Macro variable (not applicable)	Macro variable (not applicable)
10	Afghanistan	AF	PPP conversion factor, LCU per USD	Exchange rate	Other macro variable	1	1971-2017	Aggregate on all ages	Individuals	xlcusp999i	Macro variable (not applicable)	Macro variable (not applicable)

Showing 1 to 10 of 6,253 entries

Previous1 2 3 4 5…626Next

C.2 Explaining All Variables

Go back to Appendix B

R Code C.2 : Explain All 184 Variables Found in the Summary Table

Code

summary_table |>
    dplyr::filter(Country == "USA") |> 
    dplyr::select(3, 13, 14, 15) |> 
    DT::datatable(
         options = list(
           initComplete = htmlwidgets::JS(
              "function(settings, json) {",
              paste0("$(this.api().table().container()).css({'font-size': '", font.size, "'});"),
              "}")
           ) 
         )

Show entries

Search:

	Short name of variable	Simple description of variable	Technical description of variable	Method used for computation
1	Post-tax national income	Post-tax national income is the sum of primary incomes over all sectors (private and public), minus taxes.	[Post-tax national income]=[Post-tax disposable income]+[Public spending]	WID.world computations using wid.world/gpinter.
2	Pre-tax factor income	Factor national income is the sum of all pre-tax personal income flows of personal sector accruing directly or indirectly to the individual owners of the production factors, labor and capital, before taking into account the operation of the tax/transfer system, and before taking into account the operation of pension system.	Pre-tax factor income=Factor labor income [total pre-tax factor income ranking]+Factor capital income [total pre-tax factor income ranking]	WID.world computations using wid.world/gpinter.
3	National income	National income aims to measure the total income available to the residents of a given country. It is equal to the gross domestic product (the total value of goods and services produced on the territory of a given country during a given year), minus fixed capital used in production processes (e.g. replacement of obsolete machines or maintenance of roads) plus the net foreign income earned by residents in the rest of the world.// National income has many limitations. However it is the only income concept that has an internationally agreed definition (established by the United Nations System of National Accounts, see SNA 2008). So we use it as our reference concept (with tax havens correction). To be improved.The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.	[National income]=[Net domestic product]+[Net foreign income]
4	Net domestic product	Net domestic product is the total value of the goods and services produced in a country, minus the value of the fixed capital used up in production (e.g. replacement of obsolete machines or maintenance of roads).The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.	[Net domestic product]=[Gross domestic product]-[Consumption of fixed capital of national economy]
5	Consumption of fixed capital of national economy	Consumption of fixed capital of national economy is the decline in total value of fixed assets (e.g. roads, machines) which are owned and used by a producer. In other words, the amounts required to maintain the quality of fixed assets from a year to another. The decline in value is a result of physical deterioration, normal obsolescence or normal accidental damage.The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.
6	Gross domestic product	Gross domestic product is the total value of goods and services produced by the national economy.The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.
7	Net foreign income	Net foreign income is the difference between the total value of a country's citizens and companies earned abroad, and the total value of foreign citizens and overseas companies earned in that country.The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.	[Net foreign income]=[Property income received from abroad]-[Property income paid abroad]+[Compensation of employees received from abroad]-[Compensation of employees paid to rest of the world]
8	Net personal wealth	Net personal wealth is the total value of non-financial and financial assets (housing, land, deposits, bonds, equities, etc.) held by households, minus their debts. . The personal or household sector - in the national accounts sense - includes all households and private individuals (including those living in institutions), as well as unincorporated enterprises whose accounts are not separated from those of the households who own them.	[Net personal wealth]=[Personal non-financial assets]+[Personal financial assets]-[Personal debt]	WID.world computations using wid.world/gpinter.
9	Net corporate saving	Net corporate saving is the total value of gross saving, minus capital depreciation of the corporate sector (companies). The corporate sector - in the national accounts sense - includes all financial and non-financial corporations with an economic activity in a given country, whatever their legal status (with the exceptions of unincorporated enterprises included in the personal sector).	[Net corporate saving]=[Gross corporate saving]-[Corporate capital depreciation]
10	Corporate capital depreciation	Corporate capital depreciation is the gradual decrease in the economic value of the assets owned by the corporate sector (companies). It is the difference between net saving and gross saving. The corporate sector - in the national accounts sense - includes all financial and non-financial corporations with an economic activity in a given country, whatever their legal status (with the exceptions of unincorporated enterprises included in the personal sector).

Showing 1 to 10 of 184 entries

Previous1 2 3 4 5…19Next

C.3 Explain Austria’s 21 Variables

Go back to Appendix B

R Code C.3 : Explain All 21 Variables Registered with Austria in the Summary Table

Code

summary_table |>
    dplyr::filter(Country == "Austria") |> 
    dplyr::select(1, 3, 13, 14, 15) |> 
    DT::datatable(
         options = list(
           initComplete = htmlwidgets::JS(
              "function(settings, json) {",
              paste0("$(this.api().table().container()).css({'font-size': '", font.size, "'});"),
              "}"),
           pageLength = 25,
           lengthMenu = c(5, 10, 15, 20, 25)
           ) 
         )

Show entries

Search:

	Country	Short name of variable	Simple description of variable	Technical description of variable	Method used for computation
1	Austria	Post-tax national income	Post-tax national income is the sum of primary incomes over all sectors (private and public), minus taxes.	[Post-tax national income]=[Post-tax disposable income]+[Public spending]
2	Austria	National income	National income aims to measure the total income available to the residents of a given country. It is equal to the gross domestic product (the total value of goods and services produced on the territory of a given country during a given year), minus fixed capital used in production processes (e.g. replacement of obsolete machines or maintenance of roads) plus the net foreign income earned by residents in the rest of the world.// National income has many limitations. However it is the only income concept that has an internationally agreed definition (established by the United Nations System of National Accounts, see SNA 2008). So we use it as our reference concept (with tax havens correction). To be improved.The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.	[National income]=[Net domestic product]+[Net foreign income]	From 1950 to 1969, we computed net foreign income based on its share in GDP in 1970.
3	Austria	Net domestic product	Net domestic product is the total value of the goods and services produced in a country, minus the value of the fixed capital used up in production (e.g. replacement of obsolete machines or maintenance of roads).The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.	[Net domestic product]=[Gross domestic product]-[Consumption of fixed capital of national economy]	Calculated as GDP minus CFC. See subcomponents series for additional information.
4	Austria	Consumption of fixed capital of national economy	Consumption of fixed capital of national economy is the decline in total value of fixed assets (e.g. roads, machines) which are owned and used by a producer. In other words, the amounts required to maintain the quality of fixed assets from a year to another. The decline in value is a result of physical deterioration, normal obsolescence or normal accidental damage.The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.		From 1950 to 1985, we impute the value of CFC (see methodological note for details). From 1986 to 1994, we use CFC as a % of GDP from the UN SNA detailed tables (series 300). From 1995 to 2015, we use CFC as a % of GDP from the UN SNA detailed tables (series 1000). From 2016 to 2017, we impute the value of CFC (see methodological note for details).
5	Austria	Gross domestic product	Gross domestic product is the total value of goods and services produced by the national economy.The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.		GDP level in 2016 from the UN SNA main tables. Until 1959, we use the GDP growth rates from Maddison (2007). Between 1960 and 1969, we use the GDP growth rates from the World Bank. Between 1970 and 2015, we use the GDP growth rates from the UN SNA main tables. After 2016, we use the GDP growth rates from the World Bank Global Economic Monitor.
6	Austria	Net foreign income	Net foreign income is the difference between the total value of a country's citizens and companies earned abroad, and the total value of foreign citizens and overseas companies earned in that country.The national economy - in the national accounts sense - includes all domestic sectors, i.e. all entities that are resident of a given country (in the sense of their economic activity), whether they belong to the private sector, the corporate sector, the governement sector.	[Net foreign income]=[Property income received from abroad]-[Property income paid abroad]+[Compensation of employees received from abroad]-[Compensation of employees paid to rest of the world]	From 1970 to 2016, we use NFI as a % of GDP from the OECD. In 2017, we use NFI as a % of GDP from the IMF.
7	Austria	Pre-tax national income	Pre-tax national income is the sum of all pre-tax personal income flows accruing to the owners of the production factors, labor and capital, before taking into account the operation of the tax/transfer system, but after taking into account the operation of pension system. The central difference between personal factor income and pre-tax income is the treatment of pensions, which are counted on a contribution basis by factor income and on a distribution basis by pre-tax income.	Pre-tax national income =Pre-tax labor income [total pre-tax income ranking]+Pre-tax capital income [total pre-tax income ranking]
8	Austria	Post-tax national income	Post-tax national income is the sum of primary incomes over all sectors (private and public), minus taxes.	[Post-tax national income]=[Post-tax disposable income]+[Public spending]
9	Austria	Pre-tax national income	Pre-tax national income is the sum of all pre-tax personal income flows accruing to the owners of the production factors, labor and capital, before taking into account the operation of the tax/transfer system, but after taking into account the operation of pension system. The central difference between personal factor income and pre-tax income is the treatment of pensions, which are counted on a contribution basis by factor income and on a distribution basis by pre-tax income.	Pre-tax national income =Pre-tax labor income [total pre-tax income ranking]+Pre-tax capital income [total pre-tax income ranking]
10	Austria	Post-tax national income	Post-tax national income is the sum of primary incomes over all sectors (private and public), minus taxes.	[Post-tax national income]=[Post-tax disposable income]+[Public spending]
11	Austria	Pre-tax national income	Pre-tax national income is the sum of all pre-tax personal income flows accruing to the owners of the production factors, labor and capital, before taking into account the operation of the tax/transfer system, but after taking into account the operation of pension system. The central difference between personal factor income and pre-tax income is the treatment of pensions, which are counted on a contribution basis by factor income and on a distribution basis by pre-tax income.	Pre-tax national income =Pre-tax labor income [total pre-tax income ranking]+Pre-tax capital income [total pre-tax income ranking]
12	Austria	Post-tax national income	Post-tax national income is the sum of primary incomes over all sectors (private and public), minus taxes.	[Post-tax national income]=[Post-tax disposable income]+[Public spending]
13	Austria	Pre-tax national income	Pre-tax national income is the sum of all pre-tax personal income flows accruing to the owners of the production factors, labor and capital, before taking into account the operation of the tax/transfer system, but after taking into account the operation of pension system. The central difference between personal factor income and pre-tax income is the treatment of pensions, which are counted on a contribution basis by factor income and on a distribution basis by pre-tax income.	Pre-tax national income =Pre-tax labor income [total pre-tax income ranking]+Pre-tax capital income [total pre-tax income ranking]
14	Austria	National income price index	Price index that reflects the evolution of the price level for all new, domestically produced, final goods and services in the economy.		From 1960 to 1970, we use the GDP deflator from the World Bank. From 1971 to 2016, we use the GDP deflator from the UN SNA. In 2017, delta_def_gem.
15	Austria	Population	Number of individuals in a group.
16	Austria	PPP conversion factor, LCU per EUR	PPP conversion factor of current local currency to current PPP EUR.		Using the evolution of the price index relative to the reference country, we extrapolate the PPP from the 2011 ICP.
17	Austria	Market exchange rate, LCU per EUR	Official exchange rate of the local currency to EUR.
18	Austria	PPP conversion factor, LCU per USD	PPP conversion factor of current local currency to current PPP USD.		Using the evolution of the price index relative to the reference country, we extrapolate the PPP from the 2011 ICP.
19	Austria	Market exchange rate, LCU per USD	Official exchange rate of the local currency to USD.
20	Austria	PPP conversion factor, LCU per CNY	PPP conversion factor of current local currency to current PPP CNY.		Using the evolution of the price index relative to the reference country, we extrapolate the PPP from the 2011 ICP.
21	Austria	Market exchange rate, LCU per CNY	Official exchange rate of the local currency to CNY.

Showing 1 to 21 of 21 entries

Previous1Next

---
format: 
  html:
    page-layout: custom
---

# Summary Table {#sec-full-summary-table}

```{r}
#| label: setup
#| results: hold
#| include: false

font.size <- "10pt"

summary_table <- readRDS("data/chap81/summary_table.rds")

```


## Display Most Variables of the Summary Table

Go back to @sec-summary-table

:::::{.my-r-code}
:::{.my-r-code-header}
:::::: {#cnj-full-summary-table}
: Display All Variables of the Summary Table with the exception of the simple & technical explanations and the methods used for computations
::::::
:::
::::{.my-r-code-container}
```{r}
#| label: summary-table

summary_table |> 
    dplyr::select(1:12, 17) |>  
    DT::datatable(
         options = list(
           initComplete = htmlwidgets::JS(
              "function(settings, json) {",
              paste0("$(this.api().table().container()).css({'font-size': '", font.size, "'});"),
              "}")
           ) 
         )
```


::::
:::::




## Explaining All Variables {#sec-explain-variables}

Go back to @sec-summary-table



:::::{.my-r-code}
:::{.my-r-code-header}
:::::: {#cnj-explain-all-variables}
: Explain All 184 Variables Found in the Summary Table
::::::
:::
::::{.my-r-code-container}

```{r}
#| label: explain-all-variables

summary_table |>
    dplyr::filter(Country == "USA") |> 
    dplyr::select(3, 13, 14, 15) |> 
    DT::datatable(
         options = list(
           initComplete = htmlwidgets::JS(
              "function(settings, json) {",
              paste0("$(this.api().table().container()).css({'font-size': '", font.size, "'});"),
              "}")
           ) 
         )
```


::::
:::::


## Explain Austria's 21 Variables {#sec-explain-austria-variables}

Go back to @sec-summary-table


:::::{.my-r-code}
:::{.my-r-code-header}
:::::: {#cnj-explain-austria-variables}
: Explain All 21 Variables Registered with Austria in the Summary Table
::::::
:::
::::{.my-r-code-container}

```{r}
#| label: explain-austria-variables

summary_table |>
    dplyr::filter(Country == "Austria") |> 
    dplyr::select(1, 3, 13, 14, 15) |> 
    DT::datatable(
         options = list(
           initComplete = htmlwidgets::JS(
              "function(settings, json) {",
              paste0("$(this.api().table().container()).css({'font-size': '", font.size, "'});"),
              "}"),
           pageLength = 25,
           lengthMenu = c(5, 10, 15, 20, 25)
           ) 
         )
```


::::
:::::