Baselight
Sign In

RIO Country-based Indicators

Joint Research Centre

@ecjrc.n_8619155c_d4d3_4a3f_975b_1bca32edeb0b

Country-based Indicators
@ecjrc.n_8619155c_d4d3_4a3f_975b_1bca32edeb0b.country_based_indicators

Automatically maintained background data for the RIO Country Reports

  • 175.96 KB
  • 34329 rows
  • 15 columns
ind_group

IND GROUP

group_desc

GROUP DESC

indicator

INDICATOR

indicator_desc

INDICATOR DESC

datasource

DATASOURCE

country_code

COUNTRY CODE

country

COUNTRY

unitcode

UNITCODE

unitcode_desc

UNITCODE DESC

year

YEAR

year_str

YEAR STR

value

VALUE

observation_status

OBSERVATION STATUS

observation_status_descr

OBSERVATION STATUS DESCR

last_update

LAST UPDATE

MAIN_ECONOMICTable 01: Main economic indicatorsGDP_PER_CAPITAGDP per capita (euro per capita)ESTATUKUnited KingdomCP_EUR_HABCurrent prices, euro per capita2006Year 200635470 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)
FACT_SHEETRIO FactsheetGDP_PER_CAPITAGDP per capita (euro per capita)ESTATUKUnited KingdomCP_EUR_HABCurrent prices, euro per capita2006Year 200635470 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)
MAIN_ECONOMICTable 01: Main economic indicatorsGDP_PER_CAPITAGDP per capita (euro per capita)ESTATALAlbaniaCP_EUR_HABCurrent prices, euro per capita2007Year 20072630 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)
FACT_SHEETRIO FactsheetGDP_PER_CAPITAGDP per capita (euro per capita)ESTATALAlbaniaCP_EUR_HABCurrent prices, euro per capita2007Year 20072630 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)
MAIN_ECONOMICTable 01: Main economic indicatorsGDP_PER_CAPITAGDP per capita (euro per capita)ESTATATAustriaCP_EUR_HABCurrent prices, euro per capita2007Year 200734230 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)
FACT_SHEETRIO FactsheetGDP_PER_CAPITAGDP per capita (euro per capita)ESTATATAustriaCP_EUR_HABCurrent prices, euro per capita2007Year 200734230 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)
MAIN_ECONOMICTable 01: Main economic indicatorsGDP_PER_CAPITAGDP per capita (euro per capita)ESTATBEBelgiumCP_EUR_HABCurrent prices, euro per capita2007Year 200732340 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)
FACT_SHEETRIO FactsheetGDP_PER_CAPITAGDP per capita (euro per capita)ESTATBEBelgiumCP_EUR_HABCurrent prices, euro per capita2007Year 200732340 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)
MAIN_ECONOMICTable 01: Main economic indicatorsGDP_PER_CAPITAGDP per capita (euro per capita)ESTATBGBulgariaCP_EUR_HABCurrent prices, euro per capita2007Year 20074240 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)
FACT_SHEETRIO FactsheetGDP_PER_CAPITAGDP per capita (euro per capita)ESTATBGBulgariaCP_EUR_HABCurrent prices, euro per capita2007Year 20074240 Thu Nov 12 2020 18:04:13 GMT+0000 (Coordinated Universal Time)

CREATE TABLE country_based_indicators (
  "ind_group" VARCHAR,
  "group_desc" VARCHAR,
  "indicator" VARCHAR,
  "indicator_desc" VARCHAR,
  "datasource" VARCHAR,
  "country_code" VARCHAR,
  "country" VARCHAR,
  "unitcode" VARCHAR,
  "unitcode_desc" VARCHAR,
  "year" BIGINT,
  "year_str" VARCHAR,
  "value" DOUBLE,
  "observation_status" VARCHAR,
  "observation_status_descr" VARCHAR,
  "last_update" TIMESTAMP
);

Share link

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