Turnover From Innovation

Joint Research Centre

@ecjrc.jrc_10113_rio_tsdec340

Table List

1 table(10.85 KB)

Turnover From Innovation

@ecjrc.jrc_10113_rio_tsdec340.turnover_from_innovation

10.85 KB
404 rows
13 columns

freq FREQ	time_format TIME FORMAT	time_period TIME PERIOD	break_sd BREAK SD	geo GEO	obs_value OBS VALUE	freq_desc FREQ DESC	time_format_desc TIME FORMAT DESC	time_period_desc TIME PERIOD DESC	obs_status_desc OBS STATUS DESC	break_sd_desc BREAK SD DESC	geo_desc GEO DESC
A	P1Y	2010	SERV	IE	8.1	Annual	Annual	Year 2010	No data	Services	Ireland
A	P1Y	2010	SERV	CZ	10.5	Annual	Annual	Year 2010	No data	Services	Czechia
A	P1Y	2010	SERV	DE	9.1	Annual	Annual	Year 2010	No data	Services	Germany
A	P1Y	2010	SERV	DK	8.4	Annual	Annual	Year 2010	No data	Services	Denmark
A	P1Y	2010	SERV	EE	10.9	Annual	Annual	Year 2010	No data	Services	Estonia
A	P1Y	2010	SERV	ES	16.7	Annual	Annual	Year 2010	No data	Services	Spain
A	P1Y	2012	SERV	IT	9.8	Annual	Annual	Year 2012	No data	Services	Italy
A	P1Y	2012	SERV	LT	4.6	Annual	Annual	Year 2012	No data	Services	Lithuania
A	P1Y	2012	SERV	LU	5.6	Annual	Annual	Year 2012	No data	Services	Luxembourg
A	P1Y	2012	SERV	LV	3	Annual	Annual	Year 2012	No data	Services	Latvia


CREATE TABLE turnover_from_innovation (
  "freq" VARCHAR,
  "time_format" VARCHAR,
  "time_period" BIGINT,
  "break_sd" VARCHAR,
  "geo" VARCHAR,
  "obs_status" VARCHAR,
  "obs_value" DOUBLE,
  "freq_desc" VARCHAR,
  "time_format_desc" VARCHAR,
  "time_period_desc" VARCHAR,
  "obs_status_desc" VARCHAR,
  "break_sd_desc" VARCHAR,
  "geo_desc" VARCHAR
);