Baselight
Sign In

Key Indicators - Quarterly Data

Eurostat code: nasq_10_ki ยท (1980-Q1 - 2024-Q4)

@eurostat.nasq_10_ki

Key Indicators - Quarterly Data - Unpivoted
@eurostat.nasq_10_ki.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.

  • 95.33 KB
  • 24768 rows
  • 8 columns
freq

Freq

unit

Unit

s_adj

S Adj

na_item

Na Item

sector

Sector

geo

Geo

time_period

Time Period

value

Value

QuarterlyPercentageUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Gross profit share of non-financial corporations (B2G_B3G/B1Q*100)Non-financial corporationsFrance1980-Q126.66
QuarterlyPercentageUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Gross investment rate of non-financial corporations (P51/B1G*100)Non-financial corporationsFrance1980-Q121.4
QuarterlyPercentageUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Gross investment rate of households (P51/(B6G+D8Net)*100)Households; non-profit institutions serving householdsFrance1980-Q114.62
QuarterlyPercentageUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Gross household saving rate (B8G/(B6G+D8Net)*100)Households; non-profit institutions serving householdsFrance1980-Q115.66
QuarterlyPercentageSeasonally and calendar adjusted dataGross profit share of non-financial corporations (B2G_B3G/B1Q*100)Non-financial corporationsFrance1980-Q126.37
QuarterlyPercentageSeasonally and calendar adjusted dataGross disposable income of households in real terms per capita (2010=100)Households; non-profit institutions serving householdsFrance1980-Q162.84
QuarterlyPercentageSeasonally and calendar adjusted dataGross investment rate of non-financial corporations (P51/B1G*100)Non-financial corporationsFrance1980-Q121.65
QuarterlyPercentageSeasonally and calendar adjusted dataGross investment rate of households (P51/(B6G+D8Net)*100)Households; non-profit institutions serving householdsFrance1980-Q114.41
QuarterlyPercentageSeasonally and calendar adjusted dataGross household saving rate (B8G/(B6G+D8Net)*100)Households; non-profit institutions serving householdsFrance1980-Q116.4
QuarterlyPercentageUnadjusted data (i.e. neither seasonally adjusted nor calendar adjusted data)Gross profit share of non-financial corporations (B2G_B3G/B1Q*100)Non-financial corporationsFrance1980-Q227.69

CREATE TABLE tidy (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "s_adj" VARCHAR,
  "na_item" VARCHAR,
  "sector" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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