Community Designs (CD) Filed (2003-2016)

Eurostat code: ipr_dfa_tot · (2003 - 2016)

@eurostat.ipr_dfa_tot

Table List

2 tables(23.85 KB)

Community Designs (CD) Filed (2003-2016) - Raw

Community Designs (CD) Filed (2003-2016) - Unpivoted

Community Designs (CD) Filed (2003-2016) - Raw

@eurostat.ipr_dfa_tot.raw

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

15.91 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	808	1309	1376	1725	2300	1823	2210	1986	2234	2409	2260	2282	2078	1908
Annual	Number	Australia	187	240	263	280	283	279	277	314	454	594	463	437	309	197
Annual	Number	Belgium	586	1053	1482	1067	1172	1041	1110	1250	1476	1190	1012	1069	969	859
Annual	Number	Bulgaria		7	5	15	135	95	128	113	141	316	838	994	818	410
Annual	Number	Brazil	164	31	26	26	67	196	197	96	232	216	176	195	208	144
Annual	Number	Canada	153	177	209	198	292	342	691	522	341	611	724	481	388	364
Annual	Number	Switzerland	1150	1325	1624	1775	2777	2278	2150	1984	2579	1897	2184	2272	2380	1781
Annual	Number	China except Hong Kong	102	214	251	441	713	973	821	1297	1928	2587	4007	4230	5941	3802
Annual	Number	Cyprus	22	2	10	43	24	9	13	39	46	31	56	45	29	102
Annual	Number	Czechia	91	104	387	506	691	616	458	557	686	934	619	716	774	436


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.