Baselight

Consultation Of A Dentist Per Inhabitant

Eurostat code: hlth_hc_dent ยท (1960 - 2022)

@eurostat.hlth_hc_dent

Consultation Of A Dentist Per Inhabitant - Unpivoted
@eurostat.hlth_hc_dent.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.

  • 6.63 KB
  • 781 rows
  • 5 columns
freq

Freq

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualNumber per inhabitantAustria19601
AnnualNumber per inhabitantPoland19601.2
AnnualNumber per inhabitantUnited Kingdom19600.29
AnnualNumber per inhabitantAustria19611.1
AnnualNumber per inhabitantUnited Kingdom19610.31
AnnualNumber per inhabitantAustria19621.1
AnnualNumber per inhabitantUnited Kingdom19620.32
AnnualNumber per inhabitantAustria19631.1
AnnualNumber per inhabitantNetherlands19631.1
AnnualNumber per inhabitantUnited Kingdom19630.34

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

Share link

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