H&M Stores Dataset (2022)

H&M Global Stores Location

@kaggle.shivamb_hm_stores_dataset

Table List

1 table(553.19 KB)

Hm All Stores

@kaggle.shivamb_hm_stores_dataset.hm_all_stores

553.19 KB
4292 rows
21 columns

storecode StoreCode	storeclass StoreClass	name Name	phone Phone	city City	country Country	countrycode CountryCode	longitude Longitude	latitude Latitude	timezoneindex TimeZoneIndex	mon_open_hours Mon Open Hours	tue_open_hours Tue Open Hours	wed_open_hours Wed Open Hours	thu_open_hours Thu Open Hours	fri_open_hours Fri Open Hours	sat_open_hours Sat Open Hours	sun_open_hours Sun Open Hours	streetname1 StreetName1	streetname2 StreetName2	state State	address_string Address String
AE0122	Red	Mirdiff city center	+971-42316646	Dubai	United Arab Emirates	AE	55.42484	25.22628	165	10:00-22:00	10:00-22:00	10:00-22:00	10:00-23:55	10:00-23:55	10:00-23:55	10:00-22:00	Mirdiff city center	Sheikh Mohammad Bin Zayed Road	Dubai	Mirdiff city center;Sheikh Mohammad Bin Zayed Road;Dubai;Dubai;Dubai
AE0149	Flagship	Dubai Mall	+971-44190346	Dubai	United Arab Emirates	AE	55.278446	25.197506	165	10:00-23:00	10:00-23:00	10:00-23:00	10:00-23:55	10:00-23:55	10:00-23:00	10:00-23:00	Dubai Mall	Sheikh Zayed Road	Dubai	Dubai Mall;Sheikh Zayed Road;Dubai;Dubai;Dubai
AE0209	Blue	Al Markaziyah	+971-26120870	Abu Dhabi	United Arab Emirates	AE	54.357462	24.487245	165	10:00-22:00	10:00-22:00	10:00-22:00	10:00-23:00	10:00-23:00	10:00-22:00	10:00-22:00	Al Markaziyah	World Trade Center Mall	Abu Dhabi	Al Markaziyah;World Trade Center Mall;123;Abu Dhabi
AE0223	Blue	Abu Dhabi-Dubai Rd - Abu Dhabi	+971-26120851	Abu Dhabi	United Arab Emirates	AE	54.671499	24.523875	165	10:00-22:00	10:00-22:00	10:00-22:00	10:00-23:55	10:00-23:55	10:00-20:00	10:00-22:00	Abu Dhabi-Dubai Rd - Abu Dhabi	Al Bahia - Al Shahama	Abu Dhabi	Abu Dhabi-Dubai Rd - Abu Dhabi;Al Bahia - Al Shahama;Abu Dhabi;39996;Abu Dhabi
AE0273	Flagship	Yas Mall	+971-24926530	Abu Dhabi	United Arab Emirates	AE	54.60972	24.488684	165	10:00-22:00	10:00-22:00	10:00-22:00	10:00-23:55	10:00-23:55	10:00-22:00	10:00-22:00	Yas Mall	nan	Abu Dhabi	Yas Mall;;x;Abu Dhabi
AE0412	Red	Street E	+971-44190590	Dubai	United Arab Emirates	AE	55.140564	25.077058	165	10:00-22:00	10:00-22:00	10:00-22:00	10:00-23:55	10:00-23:55	10:00-22:00	10:00-22:00	Street E	Dubai Marina Mall	Dubai	Street E;Dubai Marina Mall;9440;St. E, Dubai Marina Mall, U.A.E.;Dubai
AE0420	Blue	Fujairah City Center	+971-92029601	Fujairah	United Arab Emirates	AE	56.301462	25.125555	165	10:00-23:00	10:00-23:00	10:00-23:00	10:00-23:55	10:00-23:55	10:00-23:00	10:00-23:00	Fujairah City Center	New Al Najaimat rd.	Fujairah	Fujairah City Center;New Al Najaimat rd.;Fujairah;Fujairah;Fujairah
AE0427	Red	Al whada mall	+971-26958180	Abu Dhabi	United Arab Emirates	AE	54.373245	24.469616	165	10:00-22:00	10:00-22:00	10:00-22:00	10:00-23:00	10:00-23:00	10:00-22:00	10:00-22:00	Al whada mall	Hazaa Bin Zayed the First Street, Al Wahdah	Abu Dhabi	Al whada mall;Hazaa Bin Zayed the First Street, Al Wahdah;Abu Dhabi;Abu Dhabi;Abu Dhabi
AE0428	Red	Manar Mall	+971-72264925	Ras Al Khaimah	United Arab Emirates	AE	55.966096	25.784772	165	10:00-22:00	10:00-22:00	10:00-22:00	10:00-23:55	10:00-23:55	10:00-22:00	10:00-22:00	Manar Mall	nan	Ras Al Khaimah	Manar Mall;;RAK;Ras Al Khaimah;Ras Al Khaimah
AE0433	Flagship	dubai	+971-43415440	Dubai	United Arab Emirates	AE	55.199507	25.119017	165	10:00-22:00	10:00-22:00	10:00-22:00	10:00-23:55	10:00-23:55	10:00-23:55	10:00-22:00	dubai	nan	Dubai	dubai;;00971;Dubai


CREATE TABLE hm_all_stores (
  "storecode" VARCHAR,
  "storeclass" VARCHAR,
  "name" VARCHAR,
  "phone" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "countrycode" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "timezoneindex" DOUBLE,
  "mon_open_hours" VARCHAR,
  "tue_open_hours" VARCHAR,
  "wed_open_hours" VARCHAR,
  "thu_open_hours" VARCHAR,
  "fri_open_hours" VARCHAR,
  "sat_open_hours" VARCHAR,
  "sun_open_hours" VARCHAR,
  "streetname1" VARCHAR,
  "streetname2" VARCHAR,
  "state" VARCHAR,
  "address_string" VARCHAR
);