Dataset: Patent Applications To The EPO By Country Of Applicants And Inventors (2004 And Onwards)

About this Dataset

Patent Applications To The EPO By Country Of Applicants And Inventors (2004 And Onwards)

This Eurostat dataset contains data on patent applications to the epo by country of applicants and inventors (2004 and onwards), as collected and published by the Statistical Office of the European Union.

Tables included:

raw: Original table as downloaded from Eurostat.
tidy: A cleaned and transformed version of the raw table, where time period values appear as rows instead of columns (unpivoted format).

Last updated: 2025-03-28T23:00:00+0100

Tables

Patent Applications To The EPO By Country Of Applicants And Inventors (2004 And Onwards) - Raw

@eurostat.pat_ep_tot.raw

32.37 KB
152 rows
25 columns


CREATE TABLE raw (
  "freq" VARCHAR,
  "coop_ptn" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2004" DOUBLE,
  "n_2005" DOUBLE,
  "n_2006" DOUBLE,
  "n_2007" DOUBLE,
  "n_2008" DOUBLE,
  "n_2009" DOUBLE,
  "n_2010" DOUBLE,
  "n_2011" DOUBLE,
  "n_2012" DOUBLE,
  "n_2013" DOUBLE,
  "n_2014" DOUBLE,
  "n_2015" DOUBLE,
  "n_2016" DOUBLE,
  "n_2017" DOUBLE,
  "n_2018" DOUBLE,
  "n_2019" DOUBLE,
  "n_2020" DOUBLE,
  "n_2021" DOUBLE,
  "n_2022" DOUBLE,
  "n_2023" DOUBLE,
  "n_2024" DOUBLE
);

Patent Applications To The EPO By Country Of Applicants And Inventors (2004 And Onwards) - Unpivoted

@eurostat.pat_ep_tot.tidy

17.84 KB
2586 rows
6 columns


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