Financial accounts - non consolidated - SNA 2008 - SNA_TABLE620R

Data - OECD

Author

François Geerolf


Layout - By country

  • OECD Website. html

Nobs

Code 
SNA_TABLE620R %>%
  left_join(SNA_TABLE620R_var %>% pluck("TRANSACT"), by = c("TRANSACT" = "id")) %>%
  rename(`TRANSACT Description` = label) %>%
  group_by(TRANSACT, `TRANSACT Description`, SECTOR, MEASURE) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

Data Structure

Code 
SNA_TABLE620R_var %>%
  pluck("VAR_DESC") %>%
  {if (is_html_output()) print_table(.) else .}
id description
LOCATION Country
TRANSACT Transaction
SECTOR Sector
MEASURE Measure
TIME Time
OBS_VALUE Observation Value
TIME_FORMAT Time Format
OBS_STATUS Observation Status
UNIT Unit
POWERCODE Unit multiplier
REFERENCEPERIOD Reference period

TRANSACT

Code 
SNA_TABLE620R %>%
  left_join(SNA_TABLE620R_var$TRANSACT, by = c("TRANSACT" = "id")) %>%
  rename(`TRANSACT Description` = label) %>%
  group_by(TRANSACT, `TRANSACT Description`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

SECTOR

Code 
SNA_TABLE620R %>%
  left_join(SNA_TABLE620R_var$SECTOR, by = c("SECTOR" = "id")) %>%
  rename(`SECTOR Description` = label) %>%
  group_by(SECTOR, `SECTOR Description`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

MEASURE

Code 
SNA_TABLE620R %>%
  left_join(SNA_TABLE620R_var$SECTOR, by = c("SECTOR" = "id")) %>%
  rename(`SECTOR Description` = label) %>%
  group_by(SECTOR, `SECTOR Description`) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
SECTOR SECTOR Description Nobs
RS1 Total economy 105174
RS12 Financial corporations 102790
RS2 Rest of the world 101165
RS121_2_3 Monetary financial institutions 97406
RS128_9 Insurance corporations and pension funds 96131
RS13 General Government 95903
RS11 Non-financial corporations 95701
RS125_6_7 Other financial institutions, exc. Non MMFs investment funds 93051
RS122_3 Monetary financial institutions other than Central bank 92841
RS14_S15 Households and NPISH 91932
RS121 Central Bank 90854
RS1311 Central government 90724
RS124 Non MMF investment funds 89106
RS1313 Local government 81919
RS1314 Social Security Funds 75899
RS14 Households 75594
RS122 Deposit taking corporations, exc.the Central Bank 74241
RS15 NPISHs 73106
RS128 Insurance corporations 69849
RS129 Pension funds 68169
RS123 Money market funds 67035
RS125 Other financial intermediaries ex insur. corp. & pension funds 57627
RS126 Financial auxiliaries 52029
RS127 Captive financial institutions and money lenders 51923
RS1312 State government 37844
RS1101 All public non-financial corporations 16251
RS1201 Public financial corporations 8841
RS11DO Domestically controlled non-financial corporations 352
RS1102 National private non-financial corporations 351
RS11FO Foreign controlled non-financial corporations 342
RS11011 o/w Public NFC, which are part of domestic multinationals 308
RS11021 o/w National private NFC, which are part of domestic multinationals 308
RS12011 o/w Public FC, which are part of domestic multinationals 198
RS1202 National private financial corporations 198
RS12021 o/w National private FC, which are part of domestic multinationals 198
RS12FO Foreign controlled financial corporations 198
RS12DO Domestically controlled financial corporations 153