Baselight

Persons Visiting A Doctor In The Last 12 Months By Sex, Age, Level Of Disability (activity Limitation), Medical Specialty And Number Of Visits

Eurostat code: ilc_hch20 ยท (2017 - 2022)

@eurostat.ilc_hch20

Persons Visiting A Doctor In The Last 12 Months By Sex, Age, Level Of Disability (activity Limitation), Medical Specialty And Number Of Visits - Unpivoted
@eurostat.ilc_hch20.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.

  • 346.03 KB
  • 247545 rows
  • 10 columns
freq

Freq

frequenc

Frequenc

lev_limit

Lev Limit

med_spec

Med Spec

age

Age

sex

Sex

unit

Unit

geo

Geo

time_period

Time Period

value

Value

AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageAlbania201739.2
AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageAustria201743.2
AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageBelgium201739.4
AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageBulgaria201725.4
AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageSwitzerland201743
AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageCyprus201746.3
AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageCzechia201753
AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageGermany201745
AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageDenmark201715.8
AnnualFrom 1 to 2 timesNoneGeneralist medical practitionersTotalFemalesPercentageEstonia201749.4

CREATE TABLE tidy (
  "freq" VARCHAR,
  "frequenc" VARCHAR,
  "lev_limit" VARCHAR,
  "med_spec" VARCHAR,
  "age" VARCHAR,
  "sex" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "time_period" VARCHAR,
  "value" DOUBLE
);

Share link

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