Kazakhstan Candles Import Data 2022

Analyze the problem from real life

@kaggle.sultansagynov_kazakhstan_candles_import_data_2022

Table List

1 table(318.81 KB)

Candles Kz 2022

@kaggle.sultansagynov_kazakhstan_candles_import_data_2022.candles_kz_2022

318.81 KB
22942 rows
10 columns

transportation_id Transportation ID	date_of_registration Date Of Registration	registration_month Registration Month	transport_type Transport Type	code_of_sender Code Of Sender	name_of_receiver Name Of Receiver	product_description Product Description	mass_netto_kg Mass Netto Kg	price_usd Price USD	production_country_code Production Country Code
10009000/140322/С379985	Mon Mar 14 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Feb 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	31 Состав транспортных средств (тягач с полуприцепом или прицепом)	6227009062	AL-MAHDI ТОО (АСТАНА, КАЗАХСТАН)	СВЕЧИ ДЛЯ ТОРТА	1.185	9.91	CN
10009000/080422/С477648	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	99 Прочие	7723707764	BEAUTY OUTLET	SHLFC01: СВЕЧА АРОМАТИЗИРОВАННАЯ THE URBAN GARDNER 250 ГР	48328.8	456.74	AU
10009000/080422/С477648	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	99 Прочие	7723707764	BEAUTY OUTLET	R-SHLFC02: СВЕЧА АРОМАТИЗИРОВАННАЯ A RIPENING SUN 250 ГР (ТЕСТЕР)	0.05	0.01	AU
10009000/080422/С477648	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	99 Прочие	7723707764	BEAUTY OUTLET	SHLFC03: СВЕЧА АРОМАТИЗИРОВАННАЯ BEDTIME STORIES 250 ГР	48328.8	456.74	AU
10009000/080422/С477648	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	99 Прочие	7723707764	BEAUTY OUTLET	SHLFC04: СВЕЧА АРОМАТИЗИРОВАННАЯ AFTER THE BALL 250 ГР	48328.8	456.74	AU
10009000/080422/С477648	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	99 Прочие	7723707764	BEAUTY OUTLET	SHLFC02: СВЕЧА АРОМАТИЗИРОВАННАЯ A RIPENING SUN 250 ГР	48328.8	456.74	AU
10009000/080422/С477648	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	99 Прочие	7723707764	BEAUTY OUTLET	EMFC02: СВЕЧА АРОМАТИЗИРОВАННАЯ SNOW GARDENIA 380 ГР	32219.2	304.49	AU
10009000/080422/С477648	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	99 Прочие	7723707764	BEAUTY OUTLET	SHLFC06: СВЕЧА АРОМАТИЗИРОВАННАЯ BEACH BLUE BABY 250 ГР	48328.8	456.74	AU
10009000/080422/С477648	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	99 Прочие	7723707764	BEAUTY OUTLET	R-SHLFC06: СВЕЧА АРОМАТИЗИРОВАННАЯ BEACH BLUE BABY 250 ГР (ТЕСТЕР)	0.05	0.01	AU
10009000/080422/С477648	Fri Apr 08 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Tue Mar 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	99 Прочие	7723707764	BEAUTY OUTLET	R-EMFC06: СВЕЧА АРОМАТИЗИРОВАННАЯ BOHEMIENNE 380 ГР (ТЕСТЕР)	0.03	0.01	AU


CREATE TABLE candles_kz_2022 (
  "transportation_id" VARCHAR,
  "date_of_registration" TIMESTAMP,
  "registration_month" TIMESTAMP,
  "transport_type" VARCHAR,
  "code_of_sender" BIGINT,
  "name_of_receiver" VARCHAR,
  "product_description" VARCHAR,
  "mass_netto_kg" DOUBLE,
  "price_usd" DOUBLE,
  "production_country_code" VARCHAR
);