Triadic Patent Families By Earliest Priority Year (1977-2012)

Eurostat code: pat_td_ntot · (1977 - 2012)

@eurostat.pat_td_ntot

Table List

2 tables(92.24 KB)

Triadic Patent Families By Earliest Priority Year (1977-2012) - Raw

Triadic Patent Families By Earliest Priority Year (1977-2012) - Unpivoted

Triadic Patent Families By Earliest Priority Year (1977-2012) - Unpivoted

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

30.57 KB
6732 rows
5 columns

freq Freq	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Nominal GDP in billion euro	Austria	1977	0.16
Annual	Nominal GDP in billion euro	Australia	1977	0.12
Annual	Nominal GDP in billion euro	Belgium	1977	0.3
Annual	Nominal GDP in billion euro	Canada	1977	0.06
Annual	Nominal GDP in billion euro	Germany	1977	0.76
Annual	Nominal GDP in billion euro	Denmark	1977	0.23
Annual	Nominal GDP in billion euro	Finland	1977	0.03
Annual	Nominal GDP in billion euro	France	1977	0.35
Annual	Nominal GDP in billion euro	Italy	1977	0.03
Annual	Nominal GDP in billion euro	Japan	1977	0.11


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.