Baselight

BERD By Size Class And Source Of Funds

Eurostat code: rd_e_berdsize ยท (1980 - 2023)

@eurostat.rd_e_berdsize

BERD By Size Class And Source Of Funds - Unpivoted
@eurostat.rd_e_berdsize.tidy

This table contains the same data as the raw table, but in a tidy format: time period values are unpivoted into rows under a single time_period column, making the dataset easier to analyze and visualize.

  • 886.42 KB
  • 221887 rows
  • 7 columns
freq

Freq

sectfund

Sectfund

sizeclas

Sizeclas

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualBusiness enterprise sectorTotalEuro per inhabitantJapan198083.481
AnnualBusiness enterprise sectorTotalEuro per inhabitantUnited States198096.12
AnnualBusiness enterprise sectorTotalMillion euroJapan19809772.242
AnnualBusiness enterprise sectorTotalMillion euroUnited States198021888.961
AnnualBusiness enterprise sectorTotalMillion units of national currencyJapan19803078647
AnnualBusiness enterprise sectorTotalMillion units of national currencyUnited States198030476
AnnualBusiness enterprise sectorTotalMillion purchasing power standards (PPS) at 2005 pricesJapan198021303.288
AnnualBusiness enterprise sectorTotalMillion purchasing power standards (PPS) at 2005 pricesUnited States198051728.806
AnnualBusiness enterprise sectorTotalPercentage of gross domestic product (GDP)Japan19801.2
AnnualBusiness enterprise sectorTotalPercentage of gross domestic product (GDP)United States19801.07

CREATE TABLE tidy (
  "freq" VARCHAR,
  "sectfund" VARCHAR,
  "sizeclas" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

Anyone who has the link will be able to view this.