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

Data - OECD

~/data/oecd/

LOCATION

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

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

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

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

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