Investment In Building Construction

Tracking Monthly Investment Trends in Residential and Non-Residential Constructi

@kaggle.noeyislearning_investment_in_building_construction

Table List

1 table(32.27 MB)

Invesment In Building Construction

@kaggle.noeyislearning_investment_in_building_construction.invesment_in_building_construction

32.27 MB
4173840 rows
17 columns

ref_date REF DATE	geo GEO	dguid DGUID	type_of_structure Type Of Structure	type_of_work Type Of Work	investment_value Investment Value	uom UOM	uom_id UOM ID	scalar_factor SCALAR FACTOR	vector VECTOR	coordinate COORDINATE	value VALUE	status STATUS
2017-01	Canada	2021A000011124	Total residential and non-residential	Types of work, total	Unadjusted - current	Dollars	81	units	v1579154855	1.1.1.1	12770784729	nan
2017-01	Canada	2021A000011124	Total residential and non-residential	Types of work, total	Unadjusted - constant	Dollars	81	units	v1579154856	1.1.1.2	12190291125	nan
2017-01	Canada	2021A000011124	Total residential and non-residential	Types of work, total	Seasonally adjusted - current	Dollars	81	units	v1579154857	1.1.1.3	13750534038	nan
2017-01	Canada	2021A000011124	Total residential and non-residential	Types of work, total	Seasonally adjusted - constant	Dollars	81	units	v1579154858	1.1.1.4	13131833260	nan
2017-01	Canada	2021A000011124	Total residential and non-residential	New construction	Unadjusted - current	Dollars	81	units	v1579154859	1.1.2.1	6522886834	nan
2017-01	Canada	2021A000011124	Total residential and non-residential	New construction	Unadjusted - constant	Dollars	81	units	v1579154860	1.1.2.2		..
2017-01	Canada	2021A000011124	Total residential and non-residential	New construction	Seasonally adjusted - current	Dollars	81	units	v1579154861	1.1.2.3		..
2017-01	Canada	2021A000011124	Total residential and non-residential	New construction	Seasonally adjusted - constant	Dollars	81	units	v1579154862	1.1.2.4		..
2017-01	Canada	2021A000011124	Total residential and non-residential	Renovations total	Unadjusted - current	Dollars	81	units	v1579154863	1.1.3.1	5239554095	nan
2017-01	Canada	2021A000011124	Total residential and non-residential	Renovations total	Unadjusted - constant	Dollars	81	units	v1579154864	1.1.3.2		..


CREATE TABLE invesment_in_building_construction (
  "ref_date" VARCHAR,
  "geo" VARCHAR,
  "dguid" VARCHAR,
  "type_of_structure" VARCHAR,
  "type_of_work" VARCHAR,
  "investment_value" VARCHAR,
  "uom" VARCHAR,
  "uom_id" BIGINT,
  "scalar_factor" VARCHAR,
  "scalar_id" BIGINT,
  "vector" VARCHAR,
  "coordinate" VARCHAR,
  "value" DOUBLE,
  "status" VARCHAR,
  "symbol" VARCHAR,
  "terminated" VARCHAR,
  "decimals" BIGINT
);