Patent Applications To The European Patent Office By Applicants' / Inventors' Country Of Residence

Eurostat code: sdg_09_40 · (2004 - 2024)

@eurostat.sdg_09_40

Table List

2 tables(50.21 KB)

Patent Applications To The European Patent Office By Applicants' / Inventors' Country Of Residence - Raw

Patent Applications To The European Patent Office By Applicants' / Inventors' Country Of Residence - Unpivoted

Patent Applications To The European Patent Office By Applicants' / Inventors' Country Of Residence - Unpivoted

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

17.84 KB
2586 rows
6 columns

freq Freq	coop_ptn Coop Ptn	unit Unit	geo Geo	time_period Time Period	value Value
Annual	Applicant	Number	Austria	2004	1000
Annual	Applicant	Number	Belgium	2004	1493
Annual	Applicant	Number	Bulgaria	2004	16
Annual	Applicant	Number	Switzerland	2004	4663
Annual	Applicant	Number	Cyprus	2004	20
Annual	Applicant	Number	Czechia	2004	84
Annual	Applicant	Number	Germany	2004	23044
Annual	Applicant	Number	Denmark	2004	984
Annual	Applicant	Number	Estonia	2004	4
Annual	Applicant	Number	Greece	2004	69


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

Share link

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