USDA Production Supply And Distribution - Complete

Yearly time series of USDA estimations on soft commodities

@kaggle.jeffersongranado_usdapsd

Table List

1 table(59.08 MB)

Final

@kaggle.jeffersongranado_usdapsd.final

59.08 MB
9402563 rows
9 columns

unnamed_0 Unnamed: 0	commodity_description Commodity Description	country_code Country Code	country_name Country Name	year Year	attribute_description Attribute Description	unit_description Unit Description	value Value	seen_on Seen On
	Almonds, Shelled Basis	GR	Greece	1983	Beginning Stocks	(MT)		198400
1	Almonds, Shelled Basis	GR	Greece	1983	Domestic Consumption	(MT)	9700	198400
2	Almonds, Shelled Basis	GR	Greece	1983	Ending Stocks	(MT)	345	198400
3	Almonds, Shelled Basis	GR	Greece	1983	Exports	(MT)	4300	198400
4	Almonds, Shelled Basis	GR	Greece	1983	Imports	(MT)	45	198400
5	Almonds, Shelled Basis	GR	Greece	1983	Production	(MT)	14300	198400
6	Almonds, Shelled Basis	GR	Greece	1983	Total Distribution	(MT)	14345	198400
7	Almonds, Shelled Basis	GR	Greece	1983	Total Supply	(MT)	14345	198400
8	Almonds, Shelled Basis	GR	Greece	1984	Beginning Stocks	(MT)	345	198500
9	Almonds, Shelled Basis	GR	Greece	1984	Domestic Consumption	(MT)	11500	198500


CREATE TABLE final (
  "unnamed_0" BIGINT,
  "commodity_description" VARCHAR,
  "country_code" VARCHAR,
  "country_name" VARCHAR,
  "year" BIGINT,
  "attribute_description" VARCHAR,
  "unit_description" VARCHAR,
  "value" DOUBLE,
  "seen_on" BIGINT
);