Patent Applications To The EPO By Priority Year And Other Typologies (1977-2012)

Eurostat code: urt_pat_eptot · (1977 - 2012)

@eurostat.urt_pat_eptot

Table List

2 tables(121.71 KB)

Patent Applications To The EPO By Priority Year And Other Typologies (1977-2012) - Raw

Patent Applications To The EPO By Priority Year And Other Typologies (1977-2012) - Unpivoted

Patent Applications To The EPO By Priority Year And Other Typologies (1977-2012) - Unpivoted

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

49.66 KB
8356 rows
6 columns

freq Freq	unit Unit	terrtypo Terrtypo	geo Geo	time_period Time Period	value Value
Annual	Number	Border regions	Austria	1977	29.17
Annual	Number	Border regions	Belgium	1977	37.58
Annual	Number	Border regions	Switzerland	1977	172.64
Annual	Number	Border regions	Germany	1977	158.21
Annual	Number	Border regions	Denmark	1977	24.33
Annual	Number	Border regions	Spain	1977	1
Annual	Number	Border regions	Finland	1977	2.5
Annual	Number	Border regions	France	1977	59.07
Annual	Number	Border regions	Hungary	1977	2
Annual	Number	Border regions	Ireland	1977	1


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

Share link

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