Chile Economic

Contains data from the FAOSTAT bulk data service Price Indices, Deflators.

@kaggle.willianoliveiragibin_chile_economic

Table List

3 tables(141.43 KB)

Custo Perc Chl New

Indice Price Chl

Produ Price Chl New

Produ Price Chl New

@kaggle.willianoliveiragibin_chile_economic.produ_price_chl_new

96.24 KB
9389 rows
18 columns

iso3 Iso3	startdate StartDate	enddate EndDate	area_code Area Code	area_code_m49 Area Code (M49)	area Area	item_code Item Code	item_code_cpc Item Code (CPC)	item Item	element_code Element Code	element Element	year_code Year Code	year Year	months_code Months Code	months Months	unit Unit	value Value	flag Flag
CHL	Tue Jan 01 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Dec 31 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	1991	1991	7021	Annual value	LCU	75.310.000.000	A
CHL	Wed Jan 01 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 31 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	1992	1992	7021	Annual value	LCU	81.144.000.000	A
CHL	Fri Jan 01 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	1993	1993	7021	Annual value	LCU	58.317.000.000	A
CHL	Sat Jan 01 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Dec 31 1994 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	1994	1994	7021	Annual value	LCU	65.474.000.000	A
CHL	Sun Jan 01 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Dec 31 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	1995	1995	7021	Annual value	LCU	89.900.000.000	A
CHL	Mon Jan 01 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Dec 31 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	1996	1996	7021	Annual value	LCU	87.490.000.000	A
CHL	Wed Jan 01 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Dec 31 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	1997	1997	7021	Annual value	LCU	90.468.000.000	A
CHL	Thu Jan 01 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Dec 31 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	1998	1998	7021	Annual value	LCU	70.378.000.000	A
CHL	Fri Jan 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Dec 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	1999	1999	7021	Annual value	LCU	60.240.000.000	A
CHL	Sat Jan 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Dec 31 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	40	152	Chile	515	01341	Apples	5530	Producer Price (LCU/tonne)	2000	2000	7021	Annual value	LCU	105.990.000.000	A


CREATE TABLE produ_price_chl_new (
  "iso3" VARCHAR,
  "startdate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "area_code" BIGINT,
  "area_code_m49" BIGINT,
  "area" VARCHAR,
  "item_code" BIGINT,
  "item_code_cpc" VARCHAR,
  "item" VARCHAR,
  "element_code" BIGINT,
  "element" VARCHAR,
  "year_code" BIGINT,
  "year" BIGINT,
  "months_code" BIGINT,
  "months" VARCHAR,
  "unit" VARCHAR,
  "value" VARCHAR,
  "flag" VARCHAR
);