09ICT_BERDPPS_27APR by xiuliliaofz

VIEWS: 0 PAGES: 7

									General description:
This workbook contains Draft NACE Rev. 2 datasets for BERD by ICT sectors in current prices

Source for EU27:
Statistics on Research and Development (Eurostat)
Community Innovation Survey (Eurostat)
Source for United States:
Business R&D and Innovation Survey (BRDIS)
GVA from National Accounts (BEA)
Production from Input-Output Accounts (BEA)
Source for Japan:
Annual Survey of Research and Development (R&D)
GVA from National Accounts (ESRI)
GVA from annual manufacturing census (METI)
Sales from Survey on Selected Service Industries (METI)

Description of worksheet containing data:
Worksheet 'BERD2008' contains current prices values of BERD by ICT sectors in 2008
Worksheet 'BERD2009' contains current prices values of BERD by ICT sectors in 2009
Data coverage: European Union (27 countries) including all member states and United States
Data are presented in millions of PPS (Purchasing Power Standard)

Sheets in this workbook:
Metadata sheets:
             ICT sectors codes                              Row categories in worksheets
             2007 OECD ICT sector                           This is the 2007 OECD ICT sector definition based on ISIC Rev. 4 (NACE Rev. 2)
             ICT codes and OECD conc                        Correspondence from ICT code rows to OECD ICT sector rows
             Country codes                                  Column categories in worksheets

Main data sheets:
            BERD2008                                        BERD at current prices in 2008
            BERD2009                                        BERD at current prices in 2009

Notes:
Special values:
     na       not available

Methodology:
The elaboration of the ICT sector database for the UE countries has been based on the information provided by Eurostat
The main source of Business Expenditure R&D data is Statistics on Research and Development (Eurostat). We use data provided by country and industry.
The majority of sectors gaps have been filled following these steps:
  - In the case where a country has data for a year in Statistics on R&D, applying the same percentage structure for next year.
  - Using Community Innovation Survey to cover the lack of data in some sectors.
  - Using the average weight of R&D expenditure in countries with data in sectors 951 and 582 (sample: 17 countries).
  - Using the percentage structure of Turnover: weight of the sector J631 in 63 in Turnover data and distribution of the sector 26 to 3-digits (for FI, LV, GR, LU, NE, SE) the Turnover structure is used .

The elaboration of the ICT sector database for the US has been based on the information provided by U.S. Census Bureau and National Science Foundation.
The R&D expenditures has been distributed among ICT (and non ICT) sectors using:
ICT SECTORS CODES


    rICT     Description
   ICTTOT    ICT Total
   ICTman    ICT manufacturing industries
       261   Manufacture of electronic components and boards
       262   Manufacture of computers and peripheral equipment
       263   Manufacture of communication equipment
       264   Manufacture of consumer electronics
       268   Manufacture of magnetic and optical media
 ICTtotser   ICT total services
  ICTtrade   ICT trade industries
      4651   Wholesale of computers, computer peripheral equipment and software
      4652   Wholesale of electronic and telecommunications equipment and parts
    ICTser   ICT services industries
      5820   Software publishing
        61   Telecommunications
        62   Computer programming, consultancy and related activities
       631   Data processing, hosting and related activities; web portals
       951   Repair of computers and communication equipment
2007 OECD ICT SECTOR DEFINITION


NACE Rev.
            Description
 2 code
   261      Manufacture of electronic components and boards
   262      Manufacture of computers and peripheral equipment
   263      Manufacture of communication equipment
   264      Manufacture of consumer electronics
   268      Manufacture of magnetic and optical media
  4651      Wholesale of computers, computer peripheral equipment and software
  4652      Wholesale of electronic and telecommunications equipment and parts
  5820      Software publishing
  6110      Wired telecommunications activities
  6120      Wireless telecommunications activities
  6130      Satellite telecommunications activities
  6190      Other telecommunications activities
  6201      Computer programming activities
  6202      Computer consultancy activities
  6203      Computer facilities management activities
  6209      Other information technology and computer service activities
  6311      Data processing, hosting and related activities
  6312      Web portals
  9511      Repair of computers and peripheral equipment
  9512      Repair of communication equipment
Correspondence from ICT code rows to OECD ICT sector rows


                                                                                NACE Rev.
   rICT    ICT sector description                                                           OECD ICT sector description
                                                                                 2 code
     261   Manufacture of electronic components and boards                         261      Manufacture of electronic components and boards
     262   Manufacture of computers and peripheral equipment                       262      Manufacture of computers and peripheral equipment
     263   Manufacture of communication equipment                                  263      Manufacture of communication equipment
     264   Manufacture of consumer electronics                                     264      Manufacture of consumer electronics
     268   Manufacture of magnetic and optical media                               268      Manufacture of magnetic and optical media
    4651   Wholesale of computers, computer peripheral equipment and software     4651      Wholesale of computers, computer peripheral equipment and software
    4652   Wholesale of electronic and telecommunications equipment and parts     4652      Wholesale of electronic and telecommunications equipment and parts
    5820   Software publishing                                                    5820      Software publishing
      61   Telecommunications                                                     6110      Wired telecommunications activities
      61   Telecommunications                                                     6120      Wireless telecommunications activities
      61   Telecommunications                                                     6130      Satellite telecommunications activities
      61   Telecommunications                                                     6190      Other telecommunications activities
      62   Computer programming, consultancy and related activities               6201      Computer programming activities
      62   Computer programming, consultancy and related activities               6202      Computer consultancy activities
      62   Computer programming, consultancy and related activities               6203      Computer facilities management activities
      62   Computer programming, consultancy and related activities               6209      Other information technology and computer service activities
     631   Data processing, hosting and related activities; web portals           6311      Data processing, hosting and related activities
     631   Data processing, hosting and related activities; web portals           6312      Web portals
     951   Repair of computers and communication equipment                        9511      Repair of computers and peripheral equipment
     951   Repair of computers and communication equipment                        9512      Repair of communication equipment
COUNTRY CODES


 cCountry   Country description
AT          Austria
BE          Belgium
BG          Bulgaria
CY          Cyprus
CZ          Czech Republic
DK          Denmark
EE          Estonia
FI          Finland
FR          France
DE          Germany
GR          Greece
HU          Hungary
IE          Ireland
IT          Italy
LV          Latvia
LT          Lithuania
LU          Luxembourg
MT          Malta
NL          Netherlands
PL          Poland
PT          Portugal
RO          Romania
SK          Slovakia
SI          Slovenia
ES          Spain
SE          Sweden
UK          United Kingdom
EU27        European Union (27 countries)
US          United States
BERD at current prices in 2008
Millions of PPS

     rICT ICT sector description                         AT        BE        BG        CY          CZ        DK        EE         FI         FR         DE        GR       HU        IE         IT        LV          LT          LU        MT        NL        PL        PT        RO        SK          SI         ES         SE         UK         EU27         US
    ICTTOT ICT Total                                      700.88    634.85     25.07        8.35    299.26    651.34     63.11   2,793.34   4,333.47   6,067.59    88.55    124.38    385.31   2,037.59        8.44        8.20     58.23    13.14     670.23    109.64    405.77    22.88         5.25     64.11   1,413.11   2,162.07   3,906.45   27,060.60          na
   ICTman ICT manufacturing industries                    425.88    312.33      1.85        0.10     73.10     80.65      2.60   2,413.48   2,004.41   4,136.89    46.25     58.64    105.41     881.35        2.34        3.43     37.91      5.05    347.01     22.97     36.51      7.61        2.02     43.65     209.32   1,693.76     675.92   13,630.44   35,184.16
           Manufacture of electronic components and
       261                                                300.20   148.16       0.24        0.00    12.50      18.64      1.61     24.95     962.18    1,405.82     3.50      5.65    76.35     352.31         1.34        0.15      0.00      5.05   148.83       0.94    11.40       2.04        2.02     5.54      48.25     105.14     346.34     3,989.16   17,453.31
           boards
           Manufacture of computers and peripheral
       262                                                 18.69    15.19       0.00        0.00      4.13      6.01      0.12      4.11      67.51     689.26      2.37      0.82    19.59      38.76         0.05        0.05    10.09       0.00   175.37       1.49      2.64      5.39        0.00     1.00      14.60      35.83     129.58     1,242.65    7,447.60
           equipment
       263 Manufacture of communication equipment          56.13   147.07       1.61        0.00    39.83      27.06     0.81    2,382.90     930.55   1,755.01    38.66     51.57     8.93      486.22        0.82        3.23    27.82       0.00    13.88     17.85      9.63       0.18        0.00    36.05      112.04   1,533.33     199.99    7,881.18   10,087.80
       264 Manufacture of consumer electronics             50.85     1.90       0.00        0.10    16.65      28.94     0.05        1.49      43.12     284.76     1.66      0.60     0.38        2.68        0.13        0.00     0.00       0.00     8.93      2.69     12.84       0.01        0.00     1.06       34.43      19.46       0.00      512.74      193.64
       268 Manufacture of magnetic and optical media        0.00     0.01       0.00        0.00     0.00       0.00     0.00        0.02       1.04       2.04     0.06      0.00     0.15        1.38        0.00        0.00     0.00       0.00     0.00      0.01      0.00       0.00        0.00     0.00        0.00       0.00       0.00        4.71        1.81
 ICTtotser ICT total services                             274.99   322.51      23.22        8.25   226.16     570.69    60.51      379.86   2,329.06   1,930.70    42.31     65.74   279.90    1,156.24        6.10        4.78    20.32       8.09   323.22     86.67    369.26      15.27        3.24    20.46    1,203.79     468.31   3,230.53   13,430.16          na
  ICTtrade ICT trade industries                            10.87     4.93       0.34        0.00     5.55      50.29     2.61        2.52     108.70       6.23     0.20      2.31     7.83       28.89        0.46        0.99     0.14       0.00    18.02      1.67      2.81       0.73        0.00     0.00      122.36      28.28     129.45      536.18          na
           Wholesale of computers, computer peripheral
      4651                                                   na        na        na          na        na        na        na         na         na         na        na       na        na         na          na          na        na        na        na        na        na        na          na        na         na         na         na          na          na
           equipment and software
           Wholesale of electronic and
      4652                                                   na        na        na          na        na        na        na         na         na         na        na       na        na         na          na          na        na        na        na        na        na        na          na        na         na         na         na          na          na
           telecommunications equipment and parts
    ICTser ICT services industries                        264.13   317.58      22.87        8.25   220.61     520.40    57.90     377.34    2,220.36   1,924.48    42.10     63.43   272.06    1,127.35        5.65        3.79    20.18       8.09   305.20     85.00    366.45      14.54        3.24    20.46    1,081.42    440.04    3,101.07   12,893.98          na
      5820 Software publishing                             23.66     0.20       0.00        0.00    16.66      85.45     0.00       9.82      714.40       7.69     7.54      3.03    30.63        2.42        0.00        0.09     0.74       3.39    21.87     12.10     22.20       7.58        0.00     1.76       64.78     46.32       47.53    1,129.85   22,063.69
        61 Telecommunications                              46.00   114.22       7.25        0.13    24.80      32.73     9.71      48.76      660.77     191.16    29.16      2.43     4.78      891.19        0.00        0.72     1.49       0.23    15.39     40.67    186.39       0.24        0.47     1.24      254.49    158.38    1,619.67    4,342.45    1,316.58
           Computer programming, consultancy and
        62                                                161.86   187.63      10.73        8.07   135.76     398.97    46.73     309.52     788.35    1,666.09     4.93     57.37   233.62     219.84         5.65        2.68    17.51       4.44   266.67     31.79    152.96       6.70        2.77    16.77     729.99     225.22    1,433.26    7,125.86    9,495.96
           related activities
           Data processing, hosting and related
       631                                                 32.56    15.47       4.89        0.05    41.76       3.25      1.46      8.85      53.68      59.46      0.43      0.34     2.92      12.24         0.00        0.30      0.41      0.03      0.84      0.45      4.90      0.03        0.00     0.69      27.89       9.43       0.00      282.33     2,310.86
           activities; web portals
           Repair of computers and communication
       951                                                  0.05      0.07      0.00        0.00      1.64      0.00      0.00      0.38       3.16       0.07      0.04      0.27     0.12       1.66         0.00        0.00      0.04      0.00      0.43      0.00      0.00      0.00        0.00     0.00       4.27       0.69       0.61       13.49          na
           equipment
BERD at current prices in 2009
Millions of PPS

     rICT ICT sector description                         AT        BE        BG        CY          CZ        DK        EE         FI         FR         DE        GR       HU        IE         IT        LV          LT          LU       MT        NL        PL        PT        RO        SK          SI        ES         SE         UK         EU27         US
    ICTTOT ICT Total                                      609.32    619.06    15.64         8.64    270.95    635.23    53.64    2,609.39   4,235.12   5,380.38    65.32    196.80    435.24   2,185.84        8.53        9.83    50.40    12.08     647.42    153.73    477.27    77.67         4.01    63.15   1,228.33   1,835.17   3,176.17   25,064.34   65,897.39
   ICTman ICT manufacturing industries                    393.48    298.07      1.34        0.04     48.21     79.33      3.20   2,282.55   1,736.19   2,883.33    23.30     75.17    120.08     892.44        1.71        4.00    31.82      5.43    300.78     24.69     23.06      7.06        1.10    34.56     168.74   1,442.31     452.33   11,334.33   33,810.92
           Manufacture of electronic components and
       261                                               267.58    138.21       0.04        0.00     7.32     19.28      1.91      21.45     940.75    1,078.85     7.12      5.08    87.28     478.51         1.22        0.17     0.00      5.43   122.70      1.66      3.36       1.78        1.10     5.52     45.59      39.43     119.36     3,400.72   16,772.11
           boards
           Manufacture of computers and peripheral
       262                                                17.52     13.28       0.22        0.00     3.10       5.89     0.16       5.24      21.46     601.45      4.97      1.25    22.20      29.96         0.03        0.05     9.28      0.00   153.87      2.74      1.78       5.04        0.00     0.51     13.50      28.61     154.82     1,096.92    7,156.92
           equipment
       263 Manufacture of communication equipment         60.15    144.65      1.09         0.00    26.36     27.04      1.08    2,254.54     763.28     953.18     8.84    67.80     10.24      377.69        0.40        3.77    22.54      0.00    12.70     18.96      7.33       0.24        0.00    26.94      77.96   1,359.48      90.29    6,316.56    9,694.07
       264 Manufacture of consumer electronics            48.23      1.93      0.00         0.04    11.44     27.12      0.04        1.31       8.08     247.58     2.33     1.05      0.29        5.81        0.05        0.00     0.00      0.00    11.51      1.33     10.58       0.00        0.00     1.58      31.69      14.79      87.60      514.38      185.43
       268 Manufacture of magnetic and optical media       0.00      0.01      0.00         0.00     0.00      0.00      0.00        0.01       2.62       2.28     0.04     0.00      0.06        0.47        0.00        0.00     0.00      0.00     0.00      0.00      0.00       0.00        0.00     0.00       0.00       0.00       0.26        5.75        2.40
 ICTtotser ICT total services                            215.84    320.98     14.29         8.60   222.74    555.89     50.44      326.84   2,498.94   2,497.04    42.02   121.63    315.16    1,293.39        6.83        5.83    18.58      6.65   346.64    129.04    454.21      70.61        2.91    28.59   1,059.59     392.86   2,723.84   13,730.01   32,086.46
  ICTtrade ICT trade industries                           10.31      5.23      1.09         0.00     5.01     50.01      2.46        2.70     164.11       8.80     0.21     4.98     11.61       28.01        0.26        0.42     0.14      0.00    18.38      1.93      1.14       0.95        0.00     2.81      72.83      23.35      87.19      503.94          na
           Wholesale of computers, computer peripheral
      4651                                                   na        na        na          na        na        na        na         na         na         na        na       na        na         na          na          na        na       na        na        na        na        na          na        na        na         na         na          na          na
           equipment and software
           Wholesale of electronic and
      4652                                                   na        na        na          na        na        na        na         na         na         na        na       na        na         na          na          na        na       na        na        na        na        na          na        na        na         na         na          na          na
           telecommunications equipment and parts
    ICTser ICT services industries                       205.52    315.75     13.20         8.60   217.73    505.88     47.99     324.15    2,334.82   2,488.24    41.81   116.64    303.55    1,265.38        6.57        5.41    18.44      6.65   328.26    127.10    453.08      69.67        2.91    25.79    986.76     369.51    2,636.65   13,226.06          na
      5820 Software publishing                             9.73      0.27      0.25         0.00    12.57     83.22      0.00       7.06      620.02      15.07     7.63     6.33     32.77        2.67        0.00        0.09     0.17      2.13    18.41     10.88     24.47      36.61        0.00     0.04     31.74      37.35       39.70      999.20   19,895.23
        61 Telecommunications                             41.16    107.04      1.74         0.06    22.45     31.50      7.90      38.61      611.42     546.37    28.56     2.88      5.30      983.12        0.00        0.24     1.39      0.18    14.68     58.06    264.26       0.88        1.25     2.42    223.48     133.22    1,194.54    4,322.72      988.73
           Computer programming, consultancy and
        62                                               138.18    189.03       7.87        8.39   137.80    387.96     38.85     268.82    1,015.65   1,877.53     5.10   105.04    261.99     259.47         6.57        4.90    16.45      4.31   294.70     57.47    160.13      32.05        1.65    22.79    696.09     189.79    1,338.08    7,526.66    9,467.10
           related activities
           Data processing, hosting and related
       631                                                16.42     19.32       3.33        0.15    43.27       3.20     1.24       9.23      84.05      47.28      0.46      1.97     3.32      19.35         0.00        0.18     0.40      0.03     0.00      0.69      4.21       0.12        0.00     0.54     32.77       8.46      62.12      362.12     1,735.41
           activities; web portals
           Repair of computers and communication
       951                                                  0.04     0.09       0.00        0.00     1.63       0.00     0.00       0.43       3.68       2.00      0.05      0.42     0.17       0.78         0.00        0.00     0.04      0.00     0.47      0.00      0.00       0.00        0.00     0.00      2.68       0.70       2.20       15.36          na
           equipment

								
To top