MotionSense Dataset : Smartphone Sensor Data - HAR
Human Activity and Attribute Recognition: Phone Accelerometer and Gyroscope
@kaggle.malekzadeh_motionsense_dataset
Human Activity and Attribute Recognition: Phone Accelerometer and Gyroscope
@kaggle.malekzadeh_motionsense_dataset
CREATE TABLE data_subjects_info (
"code" BIGINT,
"weight" BIGINT,
"height" BIGINT,
"age" BIGINT,
"gender" BIGINT
);
CREATE TABLE sub_10 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_19 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_9 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_22 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_14 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_15 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_13 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_5 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_2 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_6 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_23 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_17 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_12 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_4 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_20 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_21 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_8 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_1 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_24 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_7 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_11 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_16 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_3 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
CREATE TABLE sub_18 (
"unnamed_0" BIGINT,
"attitude_roll" DOUBLE,
"attitude_pitch" DOUBLE,
"attitude_yaw" DOUBLE,
"gravity_x" DOUBLE,
"gravity_y" DOUBLE,
"gravity_z" DOUBLE,
"rotationrate_x" DOUBLE,
"rotationrate_y" DOUBLE,
"rotationrate_z" DOUBLE,
"useracceleration_x" DOUBLE,
"useracceleration_y" DOUBLE,
"useracceleration_z" DOUBLE
);
Anyone who has the link will be able to view this.