ANBERD (Analytical Business Enterprise R&D) database - ANBERD_REV4

Data - OECD

Author

François Geerolf

LOCATION

Code 
ANBERD_REV4 %>%
  left_join(ANBERD_REV4_var$LOCATION, by = "LOCATION") %>%
  group_by(LOCATION, Location) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  mutate(Flag = gsub(" ", "-", str_to_lower(Location)),
         Flag = paste0('<img src="../../icon/flag/vsmall/', Flag, '.png" alt="Flag">')) %>%
  select(Flag, everything()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F, escape = F) else .}

CRITERIA

Code 
ANBERD_REV4 %>%
  left_join(ANBERD_REV4_var$CRITERIA, by = "CRITERIA") %>%
  group_by(CRITERIA, Criteria) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}

CUR

Code 
ANBERD_REV4 %>%
  left_join(ANBERD_REV4_var$CUR, by = "CUR") %>%
  group_by(CUR, Cur) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
CUR Cur Nobs
CONSTNATCUR National currency - 2015 prices 56335
CONSTPPP PPP dollars - 2015 prices 56335
NATCUR National currency - current prices 56335
USDPPP PPP dollars - current prices 56335

IND

Code 
ANBERD_REV4 %>%
  left_join(ANBERD_REV4_var$IND, by = "IND") %>%
  group_by(IND, Ind) %>%
  summarise(Nobs = n()) %>%
  arrange(-Nobs) %>%
  {if (is_html_output()) print_table(.) else .}
IND Ind Nobs
DTOTAL TOTAL BUSINESS ENTERPRISE 4228
D10T33 MANUFACTURING 4140
D45T99 TOTAL SERVICES 4016
D10T12 FOOD PRODUCTS, BEVERAGES AND TOBACCO 3940
D26T30 COMPUTER, ELECTRONIC AND OPTICAL PRODUCTS, ELECTRICAL EQUIPMENT, MACHINERY, MOTOR VEHICLES AND OTHER TRANSPORT EQUIPMENT 3928
D24T25 BASIC METALS AND FABRICATED METAL PRODUCTS, EXCEPT MACHINERY AND EQUIPMENT 3852
D35T39 ELECTRICITY, GAS AND WATER SUPPLY; SEWERAGE, WASTE MANAGEMENT AND REMEDIATION ACTIVITIES 3676
D19T23 CHEMICAL, RUBBER, PLASTICS, FUEL PRODUCTS AND OTHER NON-METALLIC MINERAL PRODUCTS 3672
D26 Computer, electronic and optical products 3668
D72 Scientific research and development 3652
D41T43 CONSTRUCTION 3636
D13T15 TEXTILES, WEARING APPAREL, LEATHER AND RELATED PRODUCTS 3604
D05T09 MINING AND QUARRYING 3600
D16T18 WOOD, PAPER, PRINTING AND REPRODUCTION OF RECORDED MEDIA 3596
D28 Machinery and equipment n.e.c. 3528
D25 Fabricated metal products, except machinery and equipment 3504
D29 Motor vehicles, trailers and semi-trailers 3480
D31T33 FURNITURE, OTHER MANUFACTURING AND REPAIR AND INSTALLATION OF MACHINERY AND EQUIPMENT 3468
D01T03 AGRICULTURE, FORESTRY AND FISHING 3448
D27 Electrical equipment 3440
D24 Basic metals 3424
D21 Pharmaceuticals, medicinal chemical and botanical products 3416
D23 Other non-metallic mineral products 3364
D30 Other transport equipment 3360
D22 Rubber and plastic products 3312
D45T82 SERVICES OF THE BUSINESS ECONOMY 3276
D45T47 Wholesale and retail trade, repair of motor vehicles and motorcycles 3244
D20T21 Chemical and pharmaceutical products 3208
D58T63 Information and communication 3204
D20 Chemicals and chemical products 3112
D68T82 Real estate activities; professional, scientific, technical, administrative and support service activities 3104
D17 Paper and paper products 2996
D16 Wood and of products of wood and cork, except furniture; articles of straw and plaiting materials 2968
D19 Coke and refined petroleum products 2928
D84T99 COMMUNITY, SOCIAL AND PERSONAL SERVICES 2908
D18 Printing and reproduction of recorded media 2892
D64T66 Financial and insurance activities 2856
D49T53 Transportation and storage 2836
D262 Computers and peripheral equipment 2636
D13 Textiles 2500
D61 Telecommunications 2480
D242T32 Non-ferrous metals 2420
D241T31 Iron and steel 2416
D303 Air and spacecraft and related machinery 2392
D55T56 Accommodation and food service activities 2392
D69T82 Professional, scientific, technical, administrative and support service activities 2348
D14 Wearing apparel 2344
D15 Leather and related products, footwear 2344
D69T75 Professional, scientific and technical activities 2188
D69T75X Professional, scientific and technical activities (except scientific research and development) 2156
D32 Other manufacturing 2148
D62T63 IT and other information services 2112
D301 Building of ships and boats 2092
D68 Real estate activities 2088
D31 Furniture 2076
D62 Computer programming, consultancy and related activities 2016
D77T82 Administrative and support service activities 2004
D33 Repair and installation of machinery and equipment 1896
D261 Electronic components and boards 1780
D58T60 Publishing, audiovisual and broadcasting activities 1768
D63 Information service activities 1768
D86T88 Human health and social work activities 1760
D263 Communication equipment 1756
D265 Instruments and appliances for measuring, testing and navigation; watches and clocks 1748
D325 Medical and dental instruments and supplies 1700
D32X Other manufacturing (except medical and dental instruments) 1700
D35T36 ELECTRICITY, GAS, STEAM AND AIR CONDITIONING SUPPLY; WATER COLLECTION, TREATMENT AND SUPPLY 1640
D37T39 SEWERAGE, WASTE MANAGEMENT, REMEDIATION ACTIVITIES 1640
D90T93 Arts, entertainement and recreation 1568
D84T85 Public administration and defence; compulsory social security and education 1556
D94T99 Other service activities; activities of houselholds as employers and of extraterritorial organisations and bodies 1536
D58 Publishing activities 1452
D266 Irradiation, electromedical and electrotherapeutic equipment 1448
D59T60 Motion picture, video, television programme production; programming and broadcasting activities 1404
D264 Consumer electronics 1388
D45T47X Wholesale (except information and communication equipment) and retail trade, repair of motor vehicles and motorcycles 1280
D4651A2 Wholesale of information and communication equipment 1280
D267 Optical instruments and photographic equipment 1248
D268 Magnetic and optical media 1144
D581 Publishing of books, periodicals and other publishing activities 1140
D582 Software publishing 1096
D252 Weapons and ammunition 1048
D25X Fabricated metal products except weapons and ammunition 1048
D10T11 Food products and beverages 980
D631 Data processing, hosting and related activities; web portals 980
D12 Tobacco products 972
D60 Programming and broadcasting activities 964
D639 Other information service activities 964
D59 Motion picture, video and television programme production, sound recording and music publishing activities 960
D302 Railway locomotives and rolling stock 912
D309 Transport equipment n.e.c. 824
D87T88 Residential care activities and social work activities 772
D86 Human health activities 764
D304 Military fighting vehicles 588
D182 Reproduction of recorded media 568
D94T99X Other services except repair of computers and communication equipment; houselholds as employers; extraterritorial organisations 568
D951 Repair of computers and communication equipment 568
D181 Printing and service activities related to printing 544
D85 Education 496
D84 Public administration and defence; compulsory social security 488

obsTime

Code 
ANBERD_REV4 %>%
  group_by(obsTime) %>%
  summarise(Nobs = n()) %>%
  {if (is_html_output()) datatable(., filter = 'top', rownames = F) else .}