Financial accounts - non consolidated - SNA_TABLE620

Data - OECD

Author

François Geerolf


Layout - By country

  • OECD Website. html

Nobs

Code 
SNA_TABLE620 %>%
  left_join(SNA_TABLE620_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_TABLE620_var %>%
  pluck("VAR_DESC") %>%
  {if (is_html_output()) print_table(.) else .}
id description
LOCATION Country
TRANSACT Transaction
SECTOR Sector
MEASURE Measure
TIME Year
OBS_VALUE Observation Value
TIME_FORMAT Time Format
OBS_STATUS Observation Status
UNIT Unit
POWERCODE Unit multiplier
REFERENCEPERIOD Reference period

TRANSACT

Code 
SNA_TABLE620 %>%
  left_join(SNA_TABLE620_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_TABLE620 %>%
  left_join(SNA_TABLE620_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_TABLE620 %>%
  left_join(SNA_TABLE620_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
S1 Total economy 69592
S12 Financial corporations 67550
S2 Rest of the world 63162
S121_S122 Central bank and other depository corporations 62502
S125 Insurance corporations and pension funds 58806
S11 Non-financial corporations 57152
S13 General government 56240
S123 Other financial intermediaries 55580
S1311 Central government 51616
S14_S15 Households and non-profit institutions serving households 51254
S122 Other depository corporations 50618
S121 Central bank 46330
S1313 Local government 42234
S124 Financial auxiliaries 41580
S1314 Social security funds 33672
S14 Households 18216
S1312 State government 16318
S15 Non-profit institutions serving households 14466
SN Not sectorized 1620