Utah FORGE: Well 16A(78)-32 Drilling Data
Department of Energy
@usgov.doe_gov_utah_forge_well_16a78_32_drilling_data_868c2
Department of Energy
@usgov.doe_gov_utah_forge_well_16a78_32_drilling_data_868c2
CREATE TABLE n_16a78_32_drilling_data_10s_intervals (
"time" VARCHAR,
"block_position" DOUBLE,
"weight_on_bit" DOUBLE,
"hookload" DOUBLE,
"slips_set" DOUBLE,
"rop_depth_hour" DOUBLE,
"mwd_gamma_api" DOUBLE,
"on_bottom" DOUBLE,
"top_drive_rpm" DOUBLE,
"top_drive_torque_ft_lbs" DOUBLE,
"flow_in" DOUBLE,
"pump_pressure" DOUBLE,
"spm_total" DOUBLE,
"pit_volume_active" DOUBLE,
"pit_g_l_active" DOUBLE,
"gas_total_units" DOUBLE,
"trip_volume_active" DOUBLE,
"trip_g_l" DOUBLE,
"return_flow" DOUBLE,
"rigmode" DOUBLE,
"rockit_on_off" DOUBLE,
"res_ps_2mhz_18in" DOUBLE,
"res_ps_400khz_18in" DOUBLE,
"mwd_inclination" DOUBLE,
"mwd_azimuth" DOUBLE,
"mud_temp" DOUBLE,
"h2s_01" DOUBLE,
"rss_azimuth" DOUBLE,
"rigeventcode" DOUBLE,
"total_depth" DOUBLE,
"bit_diameter" DOUBLE,
"bit_rpm" DOUBLE,
"depth_hole_tvd" DOUBLE,
"differential_pressure" DOUBLE,
"downhole_torque" DOUBLE,
"drill_mode" DOUBLE
);
CREATE TABLE n_16a78_32_drilling_data_1s_intervals (
"time" VARCHAR,
"block_position" DOUBLE,
"weight_on_bit" DOUBLE,
"hookload" DOUBLE,
"slips_set" DOUBLE,
"rop_depth_hour" DOUBLE,
"mwd_gamma_api" DOUBLE,
"on_bottom" DOUBLE,
"top_drive_rpm" DOUBLE,
"top_drive_torque_ft_lbs" DOUBLE,
"flow_in" DOUBLE,
"pump_pressure" DOUBLE,
"spm_total" DOUBLE,
"pit_volume_active" DOUBLE,
"pit_g_l_active" DOUBLE,
"gas_total_units" DOUBLE,
"trip_volume_active" DOUBLE,
"trip_g_l" DOUBLE,
"return_flow" DOUBLE,
"rigmode" DOUBLE,
"rockit_on_off" DOUBLE,
"mwd_inclination" DOUBLE,
"mwd_azimuth" DOUBLE,
"mud_temp" DOUBLE,
"h2s_01" DOUBLE,
"rss_azimuth" DOUBLE,
"rigeventcode" DOUBLE,
"total_depth" DOUBLE,
"bit_diameter" DOUBLE,
"bit_rpm" DOUBLE,
"depth_hole_tvd" DOUBLE,
"differential_pressure" DOUBLE,
"downhole_torque" DOUBLE,
"drill_mode" DOUBLE
);
CREATE TABLE standard_16a78_32_drilling_data_10s_intervals (
"date" VARCHAR,
"date_date_only" VARCHAR,
"date_time_only" VARCHAR,
"autodriller_system_enabled" VARCHAR,
"azimuth" VARCHAR,
"azimuth_survey" VARCHAR,
"bit_depth" VARCHAR,
"bit_diameter" VARCHAR,
"bit_revolutions_per_minute" VARCHAR,
"block_position" VARCHAR,
"depth_hole_total_vertical_depth" VARCHAR,
"differential_pressure" VARCHAR,
"dog_leg_severity_measured_while_drilling" VARCHAR,
"downhole_torque" VARCHAR,
"flow_in" VARCHAR,
"gamma_depth_measured_while_drilling" VARCHAR,
"gamma_measured_while_drilling" VARCHAR,
"gas_carbon_dioxide" VARCHAR,
"h2s_01" VARCHAR,
"hookload" VARCHAR,
"hookload_string" VARCHAR,
"inclination" VARCHAR,
"inclination_survey" VARCHAR,
"measured_while_drilling_tool_depth" VARCHAR,
"mechanical_specific_energy" VARCHAR,
"mechanical_specific_energy_downhole" VARCHAR,
"mechanical_specific_energy_surface" VARCHAR,
"mechanical_specific_energy_total" VARCHAR,
"mud_motor_factor" VARCHAR,
"mud_motor_maximum_differential_pressure" VARCHAR,
"mud_motor_maximum_torque" VARCHAR,
"mud_motor_revolutions_per_minute" VARCHAR,
"mud_temperature" VARCHAR,
"on_bottom" VARCHAR,
"over_pull" VARCHAR,
"pump_pressure" VARCHAR,
"rate_of_penetration_depth_hour" VARCHAR,
"rate_of_penetration_minute_depth" VARCHAR,
"return_flow" VARCHAR,
"rig_mode" VARCHAR,
"rig_state" VARCHAR,
"running_speed_down" VARCHAR,
"running_speed_up" VARCHAR,
"stick_slip" VARCHAR,
"tool_temperature" VARCHAR,
"tool_temperature_survey" VARCHAR,
"top_drive_revolutions_per_minute" VARCHAR,
"top_drive_torque" VARCHAR,
"total_strokes_per_minute" VARCHAR,
"weight_on_bit" VARCHAR
);
CREATE TABLE standard_16a78_32_drilling_data_1s_intervals (
"date" VARCHAR,
"date_date_only" VARCHAR,
"date_time_only" VARCHAR,
"autodriller_system_enabled" VARCHAR,
"azimuth" VARCHAR,
"azimuth_survey" VARCHAR,
"bit_depth" VARCHAR,
"bit_diameter" VARCHAR,
"bit_revolutions_per_minute" VARCHAR,
"block_position" VARCHAR,
"depth_hole_total_vertical_depth" VARCHAR,
"differential_pressure" VARCHAR,
"dog_leg_severity_measured_while_drilling" VARCHAR,
"downhole_torque" VARCHAR,
"flow_in" VARCHAR,
"gamma_depth_measured_while_drilling" VARCHAR,
"gamma_measured_while_drilling" VARCHAR,
"gas_carbon_dioxide" VARCHAR,
"h2s_01" VARCHAR,
"hookload" VARCHAR,
"hookload_string" VARCHAR,
"inclination" VARCHAR,
"inclination_survey" VARCHAR,
"measured_while_drilling_tool_depth" VARCHAR,
"mechanical_specific_energy" VARCHAR,
"mechanical_specific_energy_downhole" VARCHAR,
"mechanical_specific_energy_surface" VARCHAR,
"mechanical_specific_energy_total" VARCHAR,
"mud_motor_factor" VARCHAR,
"mud_motor_maximum_differential_pressure" VARCHAR,
"mud_motor_maximum_torque" VARCHAR,
"mud_motor_revolutions_per_minute" VARCHAR,
"mud_temperature" VARCHAR,
"on_bottom" VARCHAR,
"over_pull" VARCHAR,
"pump_pressure" VARCHAR,
"rate_of_penetration_depth_hour" VARCHAR,
"rate_of_penetration_minute_depth" VARCHAR,
"return_flow" VARCHAR,
"rig_mode" VARCHAR,
"rig_state" VARCHAR,
"running_speed_down" VARCHAR,
"running_speed_up" VARCHAR,
"stick_slip" VARCHAR,
"tool_temperature" VARCHAR,
"tool_temperature_survey" VARCHAR,
"top_drive_revolutions_per_minute" VARCHAR,
"top_drive_torque" VARCHAR,
"total_strokes_per_minute" VARCHAR,
"weight_on_bit" VARCHAR
);
Anyone who has the link will be able to view this.