Baselight
Sign In

Hardware-in-the-loop Laboratory Performance Verification Of Flexible Building Equipment In A Typical Commercial Building: Performance Of Heating, Ventilation, And Air Conditioning And Thermal Energy Storage Across The United States

National Institute of Standards and Technology

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738

Loading...
Loading...

About this Dataset

Hardware-in-the-loop Laboratory Performance Verification Of Flexible Building Equipment In A Typical Commercial Building: Performance Of Heating, Ventilation, And Air Conditioning And Thermal Energy Storage Across The United States

This high-fidelity dataset measures the holistic load flexibility performance of a suite of commonly used commercial building heating, ventilating, and air-conditioning (HVAC) and thermal storage equipment, under a variety of testing conditions. It was generated as a part DOE award number DE-EE0009153: Hardware-in-the-loop Laboratory Performance Verification of Flexible Building Equipment in a Typical Commercial Building.
Organization: National Institute of Standards and Technology
Last updated: 2024-09-11T04:30:21.605393
Tags: air-conditioning, commercial-building, flexible-building-equipment, heating, holistic-load-flexibility-performance, hvac, thermal-storage-equipment, ventilating

Tables

ASHP/data/Atlanta/Shed/STD2019/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_atlanta_shed_std2019_data
  • 147.31 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_atlanta_shed_std2019_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Atlanta/Shed/TES/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_atlanta_shed_tes_data
  • 144.89 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_atlanta_shed_tes_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Atlanta/Shift/Default/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_atlanta_shift_default_data
  • 147.83 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_atlanta_shift_default_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" DOUBLE,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Atlanta/Shift/EnergySave/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_atlanta_shift_energysave_data
  • 147.77 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_atlanta_shift_energysave_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" DOUBLE,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Atlanta/Shift/ExtrmSum/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_atlanta_shift_extrmsum_data
  • 152.64 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_atlanta_shift_extrmsum_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" DOUBLE,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Atlanta/Shift/MPC/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_atlanta_shift_mpc_data
  • 150.92 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_atlanta_shift_mpc_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" DOUBLE,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Atlanta/Shift/STD2019/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_atlanta_shift_std2019_data
  • 148.79 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_atlanta_shift_std2019_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" DOUBLE,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Eff/Default/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_eff_default_data
  • 145.24 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_buffalo_eff_default_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Eff/DenseOcc/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_eff_denseocc_data
  • 197.69 KB
  • 1440 rows
  • 225 columns
Loading... 

CREATE TABLE ashp_data_buffalo_eff_denseocc_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Eff/EnergySave/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_eff_energysave_data
  • 146.16 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_buffalo_eff_energysave_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Eff/MPC/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_eff_mpc_data
  • 145.55 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_buffalo_eff_mpc_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Eff/STD2019/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_eff_std2019_data
  • 145.91 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_buffalo_eff_std2019_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Eff/TES/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_eff_tes_data
  • 145.66 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_buffalo_eff_tes_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Shed/MPC/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_shed_mpc_data
  • 146.44 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_buffalo_shed_mpc_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Shed/STD2019/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_shed_std2019_data
  • 145.94 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_buffalo_shed_std2019_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Shed/TES/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_shed_tes_data
  • 144.71 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_buffalo_shed_tes_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" BIGINT,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Shift/Default/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_shift_default_data
  • 147.57 KB
  • 1440 rows
  • 153 columns
Loading... 

CREATE TABLE ashp_data_buffalo_shift_default_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" DOUBLE,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/Buffalo/Shift/DenseOcc/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_buffalo_shift_denseocc_data
  • 199.38 KB
  • 1440 rows
  • 225 columns
Loading... 

CREATE TABLE ashp_data_buffalo_shift_denseocc_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" DOUBLE,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

ASHP/data/NewYorkCity/Shift/DenseOcc/data

@usgov.national_institute_of_standard_hardware_in_the_loop_la_5d10a738.ashp_data_newyorkcity_shift_denseocc_data
  • 198.81 KB
  • 1440 rows
  • 225 columns
Loading... 

CREATE TABLE ashp_data_newyorkcity_shift_denseocc_data (
  "date_time" VARCHAR,
  "id_power" BIGINT,
  "od_power" BIGINT,
  "oa_temp" DOUBLE,
  "oa_temp_dp" DOUBLE,
  "sa_temp" DOUBLE,
  "sa_temp_dp" DOUBLE,
  "zn_temp" DOUBLE,
  "zn_temp_dp" DOUBLE,
  "sa_flow" BIGINT,
  "local_pres" DOUBLE,
  "ref_flow" DOUBLE,
  "oa_temp_sim" DOUBLE,
  "oa_temp_dp_sim" DOUBLE,
  "oa_temp_spt_emu" DOUBLE,
  "oa_temp_dp_spt_emu" DOUBLE,
  "zn_temp_cspt" DOUBLE,
  "zn_temp_hspt" DOUBLE,
  "zn_temp_sim" DOUBLE,
  "zn_temp_dp_sim" DOUBLE,
  "zn_temp_spt_emu" DOUBLE,
  "zn_temp_dp_spt_emu" DOUBLE,
  "stat" BIGINT,
  "stg" BIGINT,
  "grid_signal_type" BIGINT,
  "grid_signal_shed" BIGINT,
  "grid_signal_price" DOUBLE,
  "occ01_gender" BIGINT,
  "occ01_accept_low" BIGINT,
  "occ01_accept_up" BIGINT,
  "occ01_zn" BIGINT,
  "occ01_pres" BIGINT,
  "occ01_loc_x" DOUBLE,
  "occ01_loc_y" DOUBLE,
  "occ01_sen" DOUBLE,
  "occ01_comfort" BIGINT,
  "occ01_met" DOUBLE,
  "occ01_clo" DOUBLE,
  "occ01_ph" BIGINT,
  "occ01_ph_power" BIGINT,
  "occ01_pf" BIGINT,
  "occ01_pf_power" BIGINT,
  "occ01_spt" BIGINT,
  "occ01_drink" BIGINT,
  "occ01_act" BIGINT,
  "occ02_gender" BIGINT,
  "occ02_accept_low" BIGINT,
  "occ02_accept_up" BIGINT,
  "occ02_zn" BIGINT,
  "occ02_pres" BIGINT,
  "occ02_loc_x" DOUBLE,
  "occ02_loc_y" DOUBLE,
  "occ02_sen" DOUBLE,
  "occ02_comfort" BIGINT,
  "occ02_met" DOUBLE,
  "occ02_clo" DOUBLE,
  "occ02_ph" BIGINT,
  "occ02_ph_power" BIGINT,
  "occ02_pf" BIGINT,
  "occ02_pf_power" BIGINT,
  "occ02_spt" BIGINT,
  "occ02_drink" BIGINT,
  "occ02_act" BIGINT,
  "occ03_gender" BIGINT,
  "occ03_accept_low" BIGINT,
  "occ03_accept_up" BIGINT,
  "occ03_zn" BIGINT,
  "occ03_pres" BIGINT,
  "occ03_loc_x" DOUBLE,
  "occ03_loc_y" DOUBLE,
  "occ03_sen" DOUBLE,
  "occ03_comfort" BIGINT,
  "occ03_met" DOUBLE,
  "occ03_clo" DOUBLE,
  "occ03_ph" BIGINT,
  "occ03_ph_power" BIGINT,
  "occ03_pf" BIGINT,
  "occ03_pf_power" BIGINT,
  "occ03_spt" BIGINT,
  "occ03_drink" BIGINT,
  "occ03_act" BIGINT,
  "occ04_gender" BIGINT,
  "occ04_accept_low" BIGINT,
  "occ04_accept_up" BIGINT,
  "occ04_zn" BIGINT,
  "occ04_pres" BIGINT,
  "occ04_loc_x" DOUBLE,
  "occ04_loc_y" DOUBLE,
  "occ04_sen" DOUBLE,
  "occ04_comfort" BIGINT,
  "occ04_met" DOUBLE,
  "occ04_clo" DOUBLE,
  "occ04_ph" BIGINT,
  "occ04_ph_power" BIGINT,
  "occ04_pf" BIGINT,
  "occ04_pf_power" BIGINT,
  "occ04_spt" BIGINT,
  "occ04_drink" BIGINT,
  "occ04_act" BIGINT,
  "occ05_gender" BIGINT
);

Share link

Anyone who has the link will be able to view this.