High-tech Patent Applications To The EPO By Priority Year (1977-2013)

Eurostat code: pat_ep_ntec · (1977 - 2013)

@eurostat.pat_ep_ntec

Table List

2 tables(251.38 KB)

High-tech Patent Applications To The EPO By Priority Year (1977-2013) - Raw

High-tech Patent Applications To The EPO By Priority Year (1977-2013) - Unpivoted

High-tech Patent Applications To The EPO By Priority Year (1977-2013) - Unpivoted

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

103.01 KB
20194 rows
6 columns

freq Freq	ipc Ipc	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Aviation	Number	Euro area - 18 countries (2014)	1977	3
Annual	Aviation	Number	Euro area - 19 countries (2015-2022)	1977	3
Annual	Aviation	Number	European Union - 28 countries (2013-2020)	1977	4
Annual	Aviation	Number	France	1977	2
Annual	Aviation	Number	Italy	1977	1
Annual	Aviation	Number	Sweden	1977	1
Annual	Aviation	Number	United States	1977	2
Annual	Aviation	Number	All countries of the world	1977	6
Annual	Aviation	Per million inhabitants	Euro area - 18 countries (2014)	1977	0.01
Annual	Aviation	Per million inhabitants	European Union - 28 countries (2013-2020)	1977	0.009


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

Share link

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