MacroEconomic Monthly 50 Countries,17000 Series

MacroEconomic Monthly with > 50 countries and17000 series from OECD, 2010-2023 M

@kaggle.pawankumark_macroeconomic_monthly_50_countries17000_series

Table List

14 tables(83.12 MB)

Med Merged

Med All Features

P5–2

P5–3

P5–1–1

P5–1–2

P5–1–3

P8

@kaggle.pawankumark_macroeconomic_monthly_50_countries17000_series.p8

66.95 KB
8736 rows
19 columns

location LOCATION	country Country	subject SUBJECT	subject_fda041 Subject	measure MEASURE	measure_277efb Measure	frequency FREQUENCY	frequency_659f01 Frequency	time TIME	time_660678 Time	unit_code Unit Code	unit Unit	powercode_code PowerCode Code	powercode PowerCode	value Value
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Fri Jan 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Jan-2010	USD	US Dollar	6	Millions	7844.1
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Mon Feb 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Feb-2010	USD	US Dollar	6	Millions	7647.6
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Mon Mar 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Mar-2010	USD	US Dollar	6	Millions	8074.2
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Thu Apr 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Apr-2010	USD	US Dollar	6	Millions	7956.4
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Sat May 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	May-2010	USD	US Dollar	6	Millions	7312.6
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Tue Jun 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Jun-2010	USD	US Dollar	6	Millions	8172.5
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Jul-2010	USD	US Dollar	6	Millions	7788.9
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Sun Aug 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Aug-2010	USD	US Dollar	6	Millions	7740.1
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Wed Sep 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Sep-2010	USD	US Dollar	6	Millions	8220.5
KOR	Korea	B6DBSE01	Balance of payments BPM6 > Current account Debits > Services > Total Debits	CXCUSA	US Dollars, sum over component sub-periods, s.a.	M	Monthly	Fri Oct 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Oct-2010	USD	US Dollar	6	Millions	8995.4


CREATE TABLE p8 (
  "location" VARCHAR,
  "country" VARCHAR,
  "subject" VARCHAR,
  "subject_fda041" VARCHAR,
  "measure" VARCHAR,
  "measure_277efb" VARCHAR,
  "frequency" VARCHAR,
  "frequency_659f01" VARCHAR,
  "time" TIMESTAMP,
  "time_660678" VARCHAR,
  "unit_code" VARCHAR,
  "unit" VARCHAR,
  "powercode_code" BIGINT,
  "powercode" VARCHAR,
  "reference_period_code" VARCHAR,
  "reference_period" VARCHAR,
  "value" DOUBLE,
  "flag_codes" VARCHAR,
  "flags" VARCHAR
);