Baselight

Artificial Intelligence By NACE Rev. 2 Activity

Eurostat code: isoc_eb_ain2 ยท (2018 - 2024)

@eurostat.isoc_eb_ain2

Artificial Intelligence By NACE Rev. 2 Activity - Unpivoted
@eurostat.isoc_eb_ain2.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.

  • 1.05 MB
  • 446514 rows
  • 8 columns
freq

Freq

size_emp

Size Emp

nace_r2

Nace R2

indic_is

Indic Is

unit

Unit

geo

Geo

time_period

Time Period

value

Value

Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesAustria20183.01
Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesBulgaria20182.07
Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesCyprus20181.35
Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesCzechia20182.32
Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesGermany20183.69
Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesDenmark20184.6
Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesEuro area (EA11-1999, EA12-2001, EA13-2007, EA15-2008, EA16-2009, EA17-2011, EA18-2014, EA19-2015, EA20-2023)20184.52
Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesEstonia20180.75
Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesSpain20186.08
Annual10 persons employed or moreManufacturingUse service robotsPercentage of enterprisesEuropean Union - 15 countries (1995-2004)20184.54

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

Share link

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