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 - Raw

@eurostat.sdg_09_40.raw

This table contains the original data as downloaded from the Eurostat API, with labels mapped where available.

32.37 KB
152 rows
25 columns

freq Freq	coop_ptn Coop Ptn	unit Unit	geo Geo	n_2004 2004	n_2005 2005	n_2006 2006	n_2007 2007	n_2008 2008	n_2009 2009	n_2010 2010	n_2011 2011	n_2012 2012	n_2013 2013	n_2014 2014	n_2015 2015	n_2016 2016	n_2017 2017	n_2018 2018	n_2019 2019	n_2020 2020	n_2021 2021	n_2022 2022	n_2023 2023	n_2024 2024
Annual	Applicant	Number	Albania						1					3		2			2		3	7	8	11
Annual	Applicant	Number	Austria	1000	1053	1146	1382	1503	1496	1744	1734	1874	1993	1964	1989	2024	2209	2281	2346	2306	2309	2381	2332	2146
Annual	Applicant	Number	Bosnia and Herzegovina						1	2		3	1			2		1	2	4	1	7	8	6
Annual	Applicant	Number	Belgium	1493	1658	1842	1898	1899	1629	2045	2014	1886	1882	1927	2041	2211	2152	2348	2422	2406	2480	2603	2587	2615
Annual	Applicant	Number	Bulgaria	16	11	12	16	15	19	11	16	13	23	34	33	20	32	31	35	54	43	46	41	53
Annual	Applicant	Number	Switzerland	4663	5027	5503	5871	5942	5887	6864	6553	6746	6742	6910	7116	7302	7354	7961	8266	8125	8504	9160	9656	9966
Annual	Applicant	Number	Cyprus	20	35	47	42	56	42	49	55	56	41	44	39	36	49	49	48	65	42	43	56	62
Annual	Applicant	Number	Czechia	84	73	82	96	110	135	167	162	140	151	167	213	189	206	248	203	206	201	222	239	252
Annual	Applicant	Number	Germany	23044	23789	24806	25190	26667	25118	27328	26202	27249	26510	25633	24807	24932	25539	26663	26762	25882	25891	24612	24942	25033
Annual	Applicant	Number	Denmark	984	1174	1246	1400	1584	1477	1817	1782	1605	1942	1983	1920	1855	2089	2385	2415	2420	2646	2685	2597	2539


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
);

Share link

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