Registered Community Designs (RCD) (2003-2016)

Eurostat code: ipr_dr_tot · (2003 - 2016)

@eurostat.ipr_dr_tot

Table List

2 tables(23.65 KB)

Registered Community Designs (RCD) (2003-2016) - Raw

Registered Community Designs (RCD) (2003-2016) - Unpivoted

Registered Community Designs (RCD) (2003-2016) - Raw

@eurostat.ipr_dr_tot.raw

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

15.88 KB
51 rows
17 columns

freq Freq	unit Unit	geo Geo	n_2003 2003	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
Annual	Number	Austria	344	1388	1501	1908	2197	1851	2252	1910	2262	2383	2299	2329	2037	2002
Annual	Number	Australia	84	250	291	311	208	350	265	335	448	590	402	449	361	220
Annual	Number	Belgium	287	1077	1527	1237	1082	1125	1125	1250	1484	1123	1055	1050	974	886
Annual	Number	Bulgaria		7		20	84	134	126	105	157	305	651	1192	811	400
Annual	Number	Brazil	16	173	31	25	53	188	209	102	221	81	301	197	211	47
Annual	Number	Canada	81	181	210	243	254	323	683	521	408	539	758	463	415	342
Annual	Number	Switzerland	549	1555	1740	1836	2724	2446	2142	2004	2528	1447	2122	2317	1896	2743
Annual	Number	China except Hong Kong	70	180	283	406	694	930	846	1264	1904	2483	3776	4487	5761	3840
Annual	Number	Cyprus	1	23	10	42	24	10	6	39	50	31	53	51	27	104
Annual	Number	Czechia	82	109	371	387	686	712	438	606	644	941	640	711	793	411


CREATE TABLE raw (
  "freq" VARCHAR,
  "unit" VARCHAR,
  "geo" VARCHAR,
  "n_2003" DOUBLE,
  "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
);

Share link

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