Patent Applications To The EPO By Priority Year By NUTS 3 Region (1977-2012)

Eurostat code: pat_ep_rtot · (1977 - 2012)

@eurostat.pat_ep_rtot

Table List

2 tables(1.18 MB)

Patent Applications To The EPO By Priority Year By NUTS 3 Region (1977-2012) - Raw

Patent Applications To The EPO By Priority Year By NUTS 3 Region (1977-2012) - Unpivoted

Patent Applications To The EPO By Priority Year By NUTS 3 Region (1977-2012) - Unpivoted

@eurostat.pat_ep_rtot.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.

595.2 KB
104106 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Number	Austria	1977	30.67
Annual	Number	Ostösterreich	1977	9.67
Annual	Number	Niederösterreich	1977	1.42
Annual	Number	Mostviertel-Eisenwurzen	1977	0.5
Annual	Number	Wiener Umland/Südteil	1977	0.92
Annual	Number	Wien	1977	8.25
Annual	Number	Wien	1977	8.25
Annual	Number	Südösterreich	1977	2
Annual	Number	Kärnten	1977	1
Annual	Number	Klagenfurt-Villach	1977	1


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.