Black Holes Observed So Far / NASA & ESA

CREATE TABLE centaurus_a_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "conforms_to_fits_standard" BOOLEAN,
  "array_data_type" BIGINT,
  "number_of_array_dimensions" BIGINT,
  "date_this_file_was_written_yyyy_mm_dd" TIMESTAMP  -- Date This File Was Written (yyyy-mm-dd),
  "type_of_data_found_in_data_file" VARCHAR,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "equinox_of_celestial_coord_system" DOUBLE  -- Equinox Of Celestial Coord. System,
  "rootname_of_the_observation_set" VARCHAR,
  "pipeline_processing_time_mjd" DOUBLE  -- Pipeline Processing Time (MJD),
  "opus_software_system_version_number" VARCHAR,
  "calwp2_code_version" VARCHAR,
  "instr_mode_full_full_res_area_area_int" VARCHAR  -- Instr. Mode: FULL (full Res.), AREA (area Int.),
  "serial_clocks_on_off" VARCHAR  -- Serial Clocks: ON, OFF,
  "dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
  "generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
  "packet_format_code" BIGINT,
  "first_filter_name" VARCHAR,
  "second_filter_name" VARCHAR,
  "first_filter_number_0_48" BIGINT  -- First Filter Number (0-48),
  "second_filter_number_0_48" BIGINT  -- Second Filter Number (0-48),
  "partial_filter_rotation_angle_degrees" DOUBLE  -- Partial Filter Rotation Angle (degrees),
  "linear_ramp_filter_wavelength" DOUBLE,
  "bandwidth_of_the_filter" DOUBLE,
  "central_wavelength_of_the_filter" DOUBLE,
  "tec_cold_junction_1_temperature_celsius" DOUBLE  -- TEC Cold Junction #1 Temperature (Celsius),
  "tec_cold_junction_2_temperature_celsius" DOUBLE  -- TEC Cold Junction #2 Temperature (Celsius),
  "tec_cold_junction_3_temperature_celsius" DOUBLE  -- TEC Cold Junction #3 Temperature (Celsius),
  "tec_cold_junction_4_temperature_celsius" DOUBLE  -- TEC Cold Junction #4 Temperature (Celsius),
  "bay_3_a1_temperature_deg_c" DOUBLE  -- Bay 3 A1 Temperature (deg C),
  "status_of_kelsall_spot_lamps_on_off" VARCHAR  -- Status Of Kelsall Spot Lamps: ON, OFF,
  "shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
  "analog_to_digital_gain_electrons_dn" DOUBLE  -- Analog To Digital Gain (Electrons/DN),
  "do_mask_correction_perform_omit_complete" VARCHAR  -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
  "do_a_to_d_correction_perform_omit_complete" VARCHAR  -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
  "correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
  "do_bias_level_correction" VARCHAR,
  "do_bias_correction_perform_omit_complete" VARCHAR  -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
  "do_dark_correction_perform_omit_complete" VARCHAR  -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
  "do_flat_field_correction" VARCHAR,
  "do_shaded_shutter_correction" VARCHAR,
  "output_saturated_pixel_map" VARCHAR,
  "fill_photometry_keywords" VARCHAR,
  "make_histograms_perform_omit_complete" VARCHAR  -- Make Histograms: PERFORM, OMIT, COMPLETE,
  "drizzle_processing" VARCHAR,
  "output_image_datatype_real_long_short" VARCHAR  -- Output Image Datatype: REAL, LONG, SHORT,
  "name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
  "name_of_the_a_to_d_conversion_file" VARCHAR,
  "name_of_the_wf4_correction_reference_file" VARCHAR,
  "engineering_file_with_extended_register_da" VARCHAR,
  "engineering_file_dqf" VARCHAR,
  "name_of_the_bias_frame_reference_file" VARCHAR,
  "name_of_the_bias_frame_reference_dqf" VARCHAR,
  "name_of_the_dark_reference_file" VARCHAR,
  "name_of_the_dark_reference_dqf" VARCHAR,
  "name_of_the_flat_field_reference_file" VARCHAR,
  "name_of_the_flat_field_reference_dqf" VARCHAR,
  "name_of_the_reference_file_for_shutter_sha" VARCHAR,
  "name_of_the_photometry_calibration_table" VARCHAR,
  "the_hst_graph_table" VARCHAR,
  "the_hst_components_table" VARCHAR,
  "distortion_correction_table" VARCHAR,
  "drift_correction_table" VARCHAR,
  "distortion_correction_image" VARCHAR,
  "data_value_at_which_saturation_occurs" BIGINT,
  "scale_factor_for_output_image" DOUBLE,
  "zero_point_for_output_image" DOUBLE,
  "length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
  "position_angle_of_v3_axis_of_hst_deg" DOUBLE  -- Position Angle Of V3-axis Of HST (deg),
  "right_ascension_of_the_sun_deg" DOUBLE  -- Right Ascension Of The Sun (deg),
  "declination_of_the_sun_deg" DOUBLE  -- Declination Of The Sun (deg),
  "equinox_of_the_sun" DOUBLE,
  "moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN  -- Moving Target Flag; T If It Is A Moving Target,
  "equatorial_radius_of_target_km" DOUBLE  -- Equatorial Radius Of Target (km),
  "flattening_of_target" DOUBLE,
  "north_pole_declination_of_target_deg" DOUBLE  -- North Pole Declination Of Target (deg),
  "north_pole_right_ascension_of_target_deg" DOUBLE  -- North Pole Right Ascension Of Target (deg),
  "rotation_rate_of_target" DOUBLE,
  "longitude_of_prime_meridian_deg" DOUBLE  -- Longitude Of Prime Meridian (deg),
  "epoch_of_longitude_of_prime_meridian_sec" DOUBLE  -- Epoch Of Longitude Of Prime Meridian (sec),
  "surface_feature_latitude_deg" DOUBLE  -- Surface Feature Latitude (deg),
  "surface_feature_longitude_deg" DOUBLE  -- Surface Feature Longitude (deg),
  "surface_feature_altitude_km" DOUBLE  -- Surface Feature Altitude (km),
  "n_0_no_podps_fill_1_podps_fill_present" BIGINT  -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
  "n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT  -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
  "st_dcf_fill_pattern_hex" VARCHAR  -- St Dcf Fill Pattern (hex),
  "bad_data_fill_value_for_calibrated_images" BIGINT,
  "commanded_duration_of_exposure_sec" BIGINT  -- Commanded Duration Of Exposure (sec),
  "number_of_ap17_shutter_b_closes" BIGINT,
  "dark_time_seconds" DOUBLE  -- Dark Time (seconds),
  "major_frame_pulse_time_preceding_exposure_start" BIGINT,
  "predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR  -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
  "predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR  -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
  "angle_between_sun_and_v1_axis" DOUBLE,
  "angle_between_moon_and_v1_axis" DOUBLE,
  "altitude_of_the_sun_above_earth_s_limb" DOUBLE  -- Altitude Of The Sun Above Earth\u0027s Limb,
  "commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR  -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
  "number_of_gyros_scheduled_t_3_obad" BIGINT  -- Number Of Gyros Scheduled, T\u003d3+OBAD,
  "guide_star_catalog_version" VARCHAR
);

CREATE TABLE g_3c273_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "conforms_to_fits_standard" BOOLEAN,
  "array_data_type" BIGINT,
  "number_of_array_dimensions" BIGINT,
  "number_of_standard_extensions" BIGINT,
  "name_of_file" VARCHAR,
  "type_of_data_found_in_data_file" VARCHAR,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "equinox_of_celestial_coord_system" DOUBLE  -- Equinox Of Celestial Coord. System,
  "rootname_of_the_observation_set" VARCHAR,
  "type_of_exposure_identifier" VARCHAR,
  "instrument_designated_as_prime" VARCHAR,
  "proposer_s_target_name" VARCHAR  -- Proposer\u0027s Target Name,
  "right_ascension_of_the_target_deg_j2000" DOUBLE  -- Right Ascension Of The Target (deg) (J2000),
  "declination_of_the_target_deg_j2000" DOUBLE  -- Declination Of The Target (deg) (J2000),
  "pep_proposal_identifier" BIGINT,
  "proposal_logsheet_line_number" DOUBLE,
  "last_name_of_principal_investigator" VARCHAR,
  "first_name_of_principal_investigator" VARCHAR,
  "middle_name_initial_of_principal_investigat" VARCHAR  -- Middle Name / Initial Of Principal Investigat,
  "angle_between_sun_and_v1_axis" DOUBLE,
  "angle_between_moon_and_v1_axis" DOUBLE,
  "commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR  -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
  "number_of_gyros_scheduled_t_3_obad" VARCHAR  -- Number Of Gyros Scheduled, T\u003d3+OBAD,
  "guide_star_catalog_version" VARCHAR,
  "moving_target_flag_t_if_it_is_a_moving_target" VARCHAR  -- Moving Target Flag; T If It Is A Moving Target,
  "ut_date_of_start_of_observation_yyyy_mm_dd" TIMESTAMP  -- UT Date Of Start Of Observation (yyyy-mm-dd),
  "ut_time_of_start_of_observation_hh_mm_ss" VARCHAR  -- UT Time Of Start Of Observation (hh:mm:ss),
  "exposure_start_time_modified_julian_date" DOUBLE  -- Exposure Start Time (Modified Julian Date),
  "exposure_end_time_modified_julian_date" DOUBLE  -- Exposure End Time (Modified Julian Date),
  "exposure_duration_seconds_calculated" DOUBLE  -- Exposure Duration (seconds)--calculated,
  "exposure_interruption_indicator" VARCHAR,
  "fiducial_pixel_dark_time_secs" DOUBLE  -- Fiducial Pixel Dark Time (secs),
  "position_angle_of_v3_axis_of_hst_deg" DOUBLE  -- Position Angle Of V3-axis Of HST (deg),
  "pipeline_processing_time_mjd" DOUBLE  -- Pipeline Processing Time (MJD),
  "data_processing_software_system_versi" VARCHAR,
  "cloud_infrastructure_package_version" VARCHAR,
  "cloud_docker_image_version" VARCHAR,
  "calibration_software_system_version_id" VARCHAR,
  "calwf3_code_version" VARCHAR,
  "observation_type_imaging_or_spectroscopic" VARCHAR  -- Observation Type - Imaging Or Spectroscopic,
  "operating_mode" VARCHAR,
  "type_of_charge_transfer_image_if_applicable" VARCHAR  -- Type Of Charge Transfer Image, If Applicable,
  "lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR  -- Lamp Status, NONE Or Name Of Lamp Which Is On,
  "number_of_repeat_exposures_in_set_default_1" BIGINT  -- Number Of Repeat Exposures In Set: Default 1,
  "data_from_a_subarray_t_or_full_frame_f" BOOLEAN  -- Data From A Subarray (T) Or Full Frame (F),
  "detector_in_use_uvis_or_ir" VARCHAR  -- Detector In Use: UVIS Or IR,
  "element_selected_from_filter_wheel" VARCHAR,
  "aperture_name" VARCHAR,
  "proposed_aperture_name" VARCHAR,
  "direct_image_for_grism_or_prism_exposure" VARCHAR,
  "cte_measurement_direction_serial_or_parallel" VARCHAR  -- CTE Measurement Direction: Serial Or Parallel,
  "number_of_cosmic_ray_split_exposures" BIGINT,
  "name_of_the_cte_algorithm" VARCHAR,
  "version_number_of_the_cte_algorithm" VARCHAR,
  "date_of_wfc3_uvis_installation_in_hst_mjd" DOUBLE  -- Date Of WFC3/UVIS Installation In HST (MJD),
  "reference_date_of_cte_model_pinning_mjd" DOUBLE  -- Reference Date Of CTE Model Pinning (MJD),
  "maximum_length_of_cte_trail" DOUBLE,
  "read_noise_amplitude" DOUBLE,
  "number_iterations_used_in_cte_forward_modeling" BIGINT,
  "number_of_iterations_used_in_parallel_transfer" BIGINT,
  "scaling_of_cte_model_relative_to_ctedate1" DOUBLE  -- Scaling Of CTE Model (relative To CTEDATE1),
  "read_noise_mitigation_algorithm" BIGINT,
  "over_subtraction_threshold" DOUBLE,
  "fix_readout_cosmic_rays" BIGINT,
  "c_bostrophidon_d_c_with_dwell_n_n_a" VARCHAR  -- C:bostrophidon; D:C With Dwell; N:N/A,
  "scan_width_arcsec" DOUBLE  -- Scan Width (arcsec),
  "angle_between_sides_of_parallelogram_deg" DOUBLE  -- Angle Between Sides Of Parallelogram (deg),
  "dwell_pts_line_for_scan_pointing_1_99_0_if_na" BIGINT  -- Dwell Pts/line For Scan Pointing (1-99,0 If NA),
  "wait_time_duration_at_each_dwell_point_sec" DOUBLE  -- Wait Time (duration) At Each Dwell Point (sec),
  "position_angle_of_scan_line_deg" DOUBLE  -- Position Angle Of Scan Line (deg),
  "commanded_rate_of_the_line_scan_arcsec_sec" DOUBLE  -- Commanded Rate Of The Line Scan (arcsec/sec),
  "number_of_lines_per_scan_1_99_0_if_na" BIGINT  -- Number Of Lines Per Scan (1-99,0 If NA),
  "scan_length_arcsec" DOUBLE  -- Scan Length (arcsec),
  "scan_coordinate_frame_of_ref_celestial_vehicle" VARCHAR  -- Scan Coordinate Frame Of Ref: Celestial,vehicle,
  "channel_select_mechanism_id" VARCHAR,
  "write_out_error_array_extension" BOOLEAN,
  "data_quality_initialization" VARCHAR,
  "correct_for_a_to_d_conversion_errors" VARCHAR,
  "subtract_bias_level_computed_from_overscan" VARCHAR,
  "subtract_bias_image" VARCHAR,
  "post_flash_correction" VARCHAR,
  "combine_observations_to_reject_cosmic_rays" VARCHAR,
  "process_individual_observations_after_cr_reject" VARCHAR,
  "apply_shutter_shading_correction" VARCHAR,
  "subtract_dark_image" VARCHAR,
  "flat_field_data" VARCHAR,
  "cte_correction" VARCHAR,
  "populate_photometric_header_keywords" VARCHAR,
  "drizzle_processing" VARCHAR,
  "scale_uvis2_to_match_uvis1_using_phtratio" VARCHAR,
  "bad_pixel_table" VARCHAR,
  "detector_calibration_parameters" VARCHAR,
  "analog_to_digital_correction_file" VARCHAR,
  "detector_overscan_table" VARCHAR,
  "bias_image_file_name" VARCHAR,
  "post_flash_correction_file_name" VARCHAR,
  "cosmic_ray_rejection_parameters" VARCHAR,
  "shutter_shading_correction_file" VARCHAR
);

CREATE TABLE h1821_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "data_conform_to_fits_standard" BOOLEAN,
  "bits_per_data_value" BIGINT,
  "number_of_data_axes" BIGINT,
  "file_may_contain_standard_extensions" BOOLEAN,
  "number_of_standard_extensions" BIGINT,
  "image_is_in_group_format" BOOLEAN,
  "date_this_file_was_written_yyyy_mm_dd" TIMESTAMP  -- Date This File Was Written (yyyy-mm-dd),
  "name_of_file" VARCHAR,
  "type_of_data_found_in_data_file" VARCHAR,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "equinox_of_celestial_coord_system" DOUBLE  -- Equinox Of Celestial Coord. System,
  "rootname_of_the_observation_set" VARCHAR,
  "instrument_designated_as_prime" VARCHAR,
  "proposer_s_target_name" VARCHAR  -- Proposer\u0027s Target Name,
  "right_ascension_of_the_target_deg_j2000" DOUBLE  -- Right Ascension Of The Target (deg) (J2000),
  "declination_of_the_target_deg_j2000" DOUBLE  -- Declination Of The Target (deg) (J2000),
  "pep_proposal_identifier" BIGINT,
  "proposal_logsheet_line_number" DOUBLE,
  "last_name_of_principal_investigator" VARCHAR,
  "first_name_of_principal_investigator" VARCHAR,
  "middle_name_initial_of_principal_investigat" VARCHAR  -- Middle Name / Initial Of Principal Investigat,
  "ut_date_of_start_of_first_exposure_in_file" TIMESTAMP,
  "ut_start_time_of_first_exposure_in_file" VARCHAR,
  "start_time_mjd_of_1st_exposure_in_file" DOUBLE  -- Start Time (MJD) Of 1st Exposure In File,
  "end_time_mjd_of_last_exposure_in_the_file" DOUBLE  -- End Time (MJD) Of Last Exposure In The File,
  "total_exposure_time_seconds" DOUBLE  -- Total Exposure Time (seconds),
  "postarg_in_axis_1_direction" DOUBLE,
  "postarg_in_axis_2_direction" DOUBLE,
  "number_of_science_data_overflows" BIGINT,
  "data_processing_software_system_version" VARCHAR,
  "calstis_code_version" VARCHAR,
  "pipeline_processing_time_mjd" DOUBLE  -- Pipeline Processing Time (MJD),
  "calibration_software_system_version_id" VARCHAR,
  "configuration_status_support_avail_eng" VARCHAR  -- Configuration Status (support., Avail., Eng.),
  "observation_type_imaging_or_spectroscopic" VARCHAR  -- Observation Type - Imaging Or Spectroscopic,
  "operating_mode" VARCHAR,
  "obser" VARCHAR,
  "lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR  -- Lamp Status, NONE Or Name Of Lamp Which Is On,
  "spectral_cal_lamp_current_value_milliamps" DOUBLE  -- Spectral Cal Lamp Current Value (milliamps),
  "number_of_repeat_exposures_in_set_default_1" BIGINT  -- Number Of Repeat Exposures In Set: Default 1,
  "data_from_a_subarray_t_or_full_frame_f" BOOLEAN  -- Data From A Subarray (T) Or Full Frame (F),
  "detector_in_use_nuv_mama_fuv_mama_or_ccd" VARCHAR  -- Detector In Use: NUV-MAMA, FUV-MAMA, Or CCD,
  "optical_element_in_use" VARCHAR,
  "aperture_name" VARCHAR,
  "proposed_aperture_name" VARCHAR,
  "filter_in_use" VARCHAR,
  "aperture_field_of_view" VARCHAR,
  "number_of_cosmic_ray_split_exposures" BIGINT,
  "ccd_amplifier_read_out_a_b_c_d" VARCHAR  -- CCD Amplifier Read Out (A,B,C,D),
  "commanded_gain_of_ccd" BIGINT,
  "commanded_ccd_bias_offset" BIGINT,
  "subarray_axis1_center_pt_in_unbinned_dect_pix" BIGINT  -- Subarray Axis1 Center Pt In Unbinned Dect. Pix,
  "subarray_axis2_center_pt_in_unbinned_dect_pix" BIGINT  -- Subarray Axis2 Center Pt In Unbinned Dect. Pix,
  "subarray_axis1_size_in_unbinned_detector_pixels" BIGINT,
  "subarray_axis2_size_in_unbinned_detector_pixels" BIGINT,
  "axis1_data_bin_size_in_unbinned_detector_pixels" BIGINT,
  "axis2_data_bin_size_in_unbinned_detector_pixels" BIGINT,
  "inverse_sensitivity_ergs_s_cm2_ang_per_count_s" DOUBLE  -- Inverse Sensitivity, Ergs/s/cm2/Ang Per Count/s,
  "st_magnitude_zero_point" DOUBLE,
  "pivot_wavelength_angstroms" DOUBLE  -- Pivot Wavelength (Angstroms),
  "rms_bandwidth_of_filter_plus_detector" DOUBLE,
  "data_quality_initialization" VARCHAR,
  "subtract_bias_level_computed_from_overscan_img" VARCHAR,
  "subtract_bias_image" VARCHAR,
  "combine_observations_to_reject_cosmic_rays" VARCHAR,
  "add_individual_repeat_observations" VARCHAR,
  "process_individual_observations_after_cr_reject" VARCHAR,
  "subtract_dark_image" VARCHAR,
  "flat_field_data" VARCHAR,
  "populate_photometric_header_keywords" VARCHAR,
  "calculate_statistics" BOOLEAN  -- Calculate Statistics?,
  "perform_geometric_correction_for_imaging_modes" VARCHAR,
  "bad_pixel_table" VARCHAR,
  "dark_image_file_name" VARCHAR,
  "pixel_to_pixel_flat_field_file_name" VARCHAR,
  "low_order_flat" VARCHAR,
  "photometric_throughput_table" VARCHAR,
  "imaging_photometric_table" VARCHAR,
  "relative_aperture_throughput_table" VARCHAR,
  "ccd_calibration_parameters" VARCHAR,
  "bias_image_file_name" VARCHAR,
  "cosmic_ray_rejection_parameters" VARCHAR,
  "image_distortion_correction_table" VARCHAR,
  "time_dependent_sensitivity_algorithm_used" VARCHAR,
  "reference_exposure_time_for_parameters" DOUBLE,
  "multiplicative_scale_factor_applied_to_noise" DOUBLE,
  "initial_guess_method_min_or_med" VARCHAR  -- Initial Guess Method (MIN Or MED),
  "sky_value_subtracted_mode_or_none" VARCHAR  -- Sky Value Subtracted (MODE Or NONE),
  "sky_level_from_the_sum_of_all_constituent_image" DOUBLE,
  "statistical_rejection_criteria" VARCHAR,
  "rejection_propagation_radius_pixels" DOUBLE  -- Rejection Propagation Radius (pixels),
  "rejection_propagation_threshold" DOUBLE,
  "data_quality_flag_bits_to_reject" BIGINT,
  "rate_at_which_pixels_are_affected_by_cosmic_ray" DOUBLE,
  "flag_cr_rejected_pixels_in_input_files_t_f" BOOLEAN  -- Flag CR-rejected Pixels In Input Files (T/F),
  "calibrated_ccd_amplifier_gain_value" DOUBLE,
  "calibrated_ccd_read_noise_value" DOUBLE,
  "bandwidth_of_the_data" DOUBLE
);

CREATE TABLE ic1101_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "conforms_to_fits_standard" BOOLEAN,
  "array_data_type" BIGINT,
  "number_of_array_dimensions" BIGINT,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "type_of_exposure_identifier" VARCHAR,
  "instrument_designated_as_prime" VARCHAR,
  "proposer_s_target_name" VARCHAR  -- Proposer\u0027s Target Name,
  "pep_proposal_identifier" BIGINT,
  "angle_between_sun_and_v1_axis" DOUBLE,
  "angle_between_moon_and_v1_axis" DOUBLE,
  "altitude_of_the_sun_above_earth_s_limb" DOUBLE  -- Altitude Of The Sun Above Earth\u0027s Limb,
  "commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR  -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
  "number_of_gyros_scheduled_t_3_obad" BIGINT  -- Number Of Gyros Scheduled, T\u003d3+OBAD,
  "ut_date_of_start_of_observation_yyyy_mm_dd" TIMESTAMP  -- UT Date Of Start Of Observation (yyyy-mm-dd),
  "exposure_start_time_modified_julian_date" DOUBLE  -- Exposure Start Time (Modified Julian Date),
  "exposure_end_time_modified_julian_date" DOUBLE  -- Exposure End Time (Modified Julian Date),
  "exposure_duration_seconds_calculated" DOUBLE  -- Exposure Duration (seconds)--calculated,
  "exposure_interruption_indicator" VARCHAR,
  "postarg_in_axis_1_direction" DOUBLE,
  "postarg_in_axis_2_direction" DOUBLE,
  "cloud_infrastructure_package_version" VARCHAR,
  "cloud_docker_image_version" VARCHAR,
  "calibration_software_system_version_id" VARCHAR,
  "observation_type_imaging_or_spectroscopic" VARCHAR  -- Observation Type - Imaging Or Spectroscopic,
  "operating_mode" VARCHAR,
  "type_of_charge_transfer_image_if_applicable" VARCHAR  -- Type Of Charge Transfer Image, If Applicable,
  "lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR  -- Lamp Status, NONE Or Name Of Lamp Which Is On,
  "number_of_repeat_exposures_in_set_default_1" BIGINT  -- Number Of Repeat Exposures In Set: Default 1,
  "data_from_a_subarray_t_or_full_frame_f" BOOLEAN  -- Data From A Subarray (T) Or Full Frame (F),
  "detector_in_use_wfc_hrc_or_sbc" VARCHAR  -- Detector In Use: WFC, HRC, Or SBC,
  "element_selected_from_filter_wheel_1" VARCHAR,
  "element_selected_from_filter_wheel_2" VARCHAR,
  "computed_filter_wheel_offset" BIGINT,
  "filter_wheel_position_error_flag" BOOLEAN,
  "proposed_linear_ramp_filter_wavelength" DOUBLE,
  "aperture_name" VARCHAR,
  "proposed_aperture_name" VARCHAR,
  "direct_image_for_grism_or_prism_exposure" VARCHAR,
  "write_out_error_array_extension" BOOLEAN,
  "data_quality_initialization" VARCHAR,
  "flag_pixels_for_local_and_global_nonlinearities" VARCHAR,
  "subtract_dark_image" VARCHAR,
  "flat_field_data" VARCHAR,
  "populate_photometric_header_keywords" VARCHAR,
  "drizzle_processing" VARCHAR,
  "bad_pixel_table" VARCHAR,
  "dark_image_file_name" VARCHAR,
  "delta_flat_field_file_name" VARCHAR,
  "low_order_flat" VARCHAR,
  "photometric_throughput_table" VARCHAR,
  "the_hst_graph_table" VARCHAR,
  "the_hst_components_table" VARCHAR,
  "distortion_correction_image" VARCHAR,
  "multidrizzle_parameter_table" VARCHAR,
  "coronagraphic_spot_image" VARCHAR,
  "coronagraphic_spot_offset_table" VARCHAR,
  "image_photometry_table" VARCHAR,
  "primary_pattern_type" VARCHAR,
  "primary_pattern_shape" VARCHAR,
  "primary_pattern_purpose" VARCHAR,
  "number_of_points_in_primary_pattern" BIGINT,
  "point_spacing_for_primary_pattern_arc_sec" DOUBLE  -- Point Spacing For Primary Pattern (arc-sec),
  "line_spacing_for_primary_pattern_arc_sec" DOUBLE  -- Line Spacing For Primary Pattern (arc-sec),
  "angle_between_sides_of_parallelogram_patt_deg" DOUBLE  -- Angle Between Sides Of Parallelogram Patt (deg),
  "coordinate_frame_of_primary_pattern" VARCHAR,
  "orientation_of_pattern_to_coordinate_frame_deg" DOUBLE  -- Orientation Of Pattern To Coordinate Frame (deg,
  "center_pattern_relative_to_pointing_yes_no" VARCHAR  -- Center Pattern Relative To Pointing (yes/no),
  "position_number_of_this_point_in_the_pattern" BIGINT,
  "origin_of_polynomial_distortion" VARCHAR,
  "origin_of_sip_polynomial_distortion_model" VARCHAR,
  "distortion_model_name" VARCHAR,
  "version_of_stwcs_used_to_updated_the_wcs" VARCHAR,
  "version_of_pywcs_used_to_updated_the_wcs" DOUBLE,
  "version_id_for_header_kw_rules_file" DOUBLE,
  "version_of_blendheader_software_used" VARCHAR,
  "name_of_header_kw_rules_file" VARCHAR,
  "drizzle_no_images_drizzled_onto_output" BIGINT  -- Drizzle, No. Images Drizzled Onto Output,
  "drizzle_task_version" VARCHAR  -- Drizzle, Task Version,
  "drizzle_source_of_geometric_information" VARCHAR  -- Drizzle, Source Of Geometric Information,
  "drizzle_input_data_image" VARCHAR  -- Drizzle, Input Data Image,
  "drizzle_input_image_exposure_time_s" DOUBLE  -- Drizzle, Input Image Exposure Time (s),
  "drizzle_output_data_image" VARCHAR  -- Drizzle, Output Data Image,
  "drizzle_output_weighting_image" VARCHAR  -- Drizzle, Output Weighting Image,
  "drizzle_output_context_image" VARCHAR  -- Drizzle, Output Context Image,
  "drizzle_input_weighting_image" VARCHAR  -- Drizzle, Input Weighting Image,
  "drizzle_weighting_factor_for_input_image" BIGINT  -- Drizzle, Weighting Factor For Input Image,
  "drizzle_form_of_weight_distribution_kernel" VARCHAR  -- Drizzle, Form Of Weight Distribution Kernel,
  "drizzle_linear_size_of_drop" DOUBLE  -- Drizzle, Linear Size Of Drop,
  "drizzle_source_of_coefficients" VARCHAR  -- Drizzle, Source Of Coefficients,
  "drizzle_units_of_output_image_counts_or_cps" VARCHAR  -- Drizzle, Units Of Output Image - Counts Or Cps,
  "drizzle_fill_value_for_zero_weight_output_pix" VARCHAR  -- Drizzle, Fill Value For Zero Weight Output Pix,
  "input_image_wcs_version_used" VARCHAR,
  "drizzle_pixel_size_arcsec_of_output_image" DOUBLE  -- Drizzle, Pixel Size (arcsec) Of Output Image,
  "drizzle_default_idctab_pixel_size_arcsec" DOUBLE  -- Drizzle, Default IDCTAB Pixel Size(arcsec)
);

CREATE TABLE markarian_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "conforms_to_fits_standard" BOOLEAN,
  "array_data_type" BIGINT,
  "number_of_array_dimensions" BIGINT,
  "date_this_file_was_written_yyyy_mm_dd" TIMESTAMP  -- Date This File Was Written (yyyy-mm-dd),
  "type_of_data_found_in_data_file" VARCHAR,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "equinox_of_celestial_coord_system" DOUBLE  -- Equinox Of Celestial Coord. System,
  "rootname_of_the_observation_set" VARCHAR,
  "pipeline_processing_time_mjd" DOUBLE  -- Pipeline Processing Time (MJD),
  "opus_software_system_version_number" VARCHAR,
  "calwp2_code_version" VARCHAR,
  "instr_mode_full_full_res_area_area_int" VARCHAR  -- Instr. Mode: FULL (full Res.), AREA (area Int.),
  "serial_clocks_on_off" VARCHAR  -- Serial Clocks: ON, OFF,
  "dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
  "generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
  "packet_format_code" BIGINT,
  "first_filter_name" VARCHAR,
  "second_filter_name" VARCHAR,
  "first_filter_number_0_48" BIGINT  -- First Filter Number (0-48),
  "second_filter_number_0_48" BIGINT  -- Second Filter Number (0-48),
  "partial_filter_rotation_angle_degrees" DOUBLE  -- Partial Filter Rotation Angle (degrees),
  "linear_ramp_filter_wavelength" DOUBLE,
  "bandwidth_of_the_filter" DOUBLE,
  "central_wavelength_of_the_filter" DOUBLE,
  "tec_cold_junction_1_temperature_celsius" DOUBLE  -- TEC Cold Junction #1 Temperature (Celsius),
  "tec_cold_junction_2_temperature_celsius" DOUBLE  -- TEC Cold Junction #2 Temperature (Celsius),
  "tec_cold_junction_3_temperature_celsius" DOUBLE  -- TEC Cold Junction #3 Temperature (Celsius),
  "tec_cold_junction_4_temperature_celsius" DOUBLE  -- TEC Cold Junction #4 Temperature (Celsius),
  "bay_3_a1_temperature_deg_c" DOUBLE  -- Bay 3 A1 Temperature (deg C),
  "status_of_kelsall_spot_lamps_on_off" VARCHAR  -- Status Of Kelsall Spot Lamps: ON, OFF,
  "shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
  "analog_to_digital_gain_electrons_dn" DOUBLE  -- Analog To Digital Gain (Electrons/DN),
  "do_mask_correction_perform_omit_complete" VARCHAR  -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
  "do_a_to_d_correction_perform_omit_complete" VARCHAR  -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
  "correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
  "do_bias_level_correction" VARCHAR,
  "do_bias_correction_perform_omit_complete" VARCHAR  -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
  "do_dark_correction_perform_omit_complete" VARCHAR  -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
  "do_flat_field_correction" VARCHAR,
  "do_shaded_shutter_correction" VARCHAR,
  "output_saturated_pixel_map" VARCHAR,
  "fill_photometry_keywords" VARCHAR,
  "make_histograms_perform_omit_complete" VARCHAR  -- Make Histograms: PERFORM, OMIT, COMPLETE,
  "drizzle_processing" VARCHAR,
  "output_image_datatype_real_long_short" VARCHAR  -- Output Image Datatype: REAL, LONG, SHORT,
  "name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
  "name_of_the_a_to_d_conversion_file" VARCHAR,
  "name_of_the_wf4_correction_reference_file" VARCHAR,
  "engineering_file_with_extended_register_da" VARCHAR,
  "engineering_file_dqf" VARCHAR,
  "name_of_the_bias_frame_reference_file" VARCHAR,
  "name_of_the_bias_frame_reference_dqf" VARCHAR,
  "name_of_the_dark_reference_file" VARCHAR,
  "name_of_the_dark_reference_dqf" VARCHAR,
  "name_of_the_flat_field_reference_file" VARCHAR,
  "name_of_the_flat_field_reference_dqf" VARCHAR,
  "name_of_the_reference_file_for_shutter_sha" VARCHAR,
  "name_of_the_photometry_calibration_table" VARCHAR,
  "the_hst_graph_table" VARCHAR,
  "the_hst_components_table" VARCHAR,
  "distortion_correction_table" VARCHAR,
  "drift_correction_table" VARCHAR,
  "distortion_correction_image" VARCHAR,
  "data_value_at_which_saturation_occurs" BIGINT,
  "scale_factor_for_output_image" DOUBLE,
  "zero_point_for_output_image" DOUBLE,
  "length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
  "position_angle_of_v3_axis_of_hst_deg" DOUBLE  -- Position Angle Of V3-axis Of HST (deg),
  "right_ascension_of_the_sun_deg" DOUBLE  -- Right Ascension Of The Sun (deg),
  "declination_of_the_sun_deg" DOUBLE  -- Declination Of The Sun (deg),
  "equinox_of_the_sun" DOUBLE,
  "moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN  -- Moving Target Flag; T If It Is A Moving Target,
  "equatorial_radius_of_target_km" DOUBLE  -- Equatorial Radius Of Target (km),
  "flattening_of_target" DOUBLE,
  "north_pole_declination_of_target_deg" DOUBLE  -- North Pole Declination Of Target (deg),
  "north_pole_right_ascension_of_target_deg" DOUBLE  -- North Pole Right Ascension Of Target (deg),
  "rotation_rate_of_target" DOUBLE,
  "longitude_of_prime_meridian_deg" DOUBLE  -- Longitude Of Prime Meridian (deg),
  "epoch_of_longitude_of_prime_meridian_sec" DOUBLE  -- Epoch Of Longitude Of Prime Meridian (sec),
  "surface_feature_latitude_deg" DOUBLE  -- Surface Feature Latitude (deg),
  "surface_feature_longitude_deg" DOUBLE  -- Surface Feature Longitude (deg),
  "surface_feature_altitude_km" DOUBLE  -- Surface Feature Altitude (km),
  "n_0_no_podps_fill_1_podps_fill_present" BIGINT  -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
  "n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT  -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
  "st_dcf_fill_pattern_hex" VARCHAR  -- St Dcf Fill Pattern (hex),
  "bad_data_fill_value_for_calibrated_images" BIGINT,
  "commanded_duration_of_exposure_sec" BIGINT  -- Commanded Duration Of Exposure (sec),
  "number_of_ap17_shutter_b_closes" BIGINT,
  "dark_time_seconds" DOUBLE  -- Dark Time (seconds),
  "major_frame_pulse_time_preceding_exposure_start" BIGINT,
  "predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR  -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
  "predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR  -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
  "angle_between_sun_and_v1_axis" DOUBLE,
  "angle_between_moon_and_v1_axis" DOUBLE,
  "altitude_of_the_sun_above_earth_s_limb" DOUBLE  -- Altitude Of The Sun Above Earth\u0027s Limb,
  "commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR  -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
  "number_of_gyros_scheduled_t_3_obad" BIGINT  -- Number Of Gyros Scheduled, T\u003d3+OBAD,
  "guide_star_catalog_version" VARCHAR
);

CREATE TABLE messier106_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "conforms_to_fits_standard" BOOLEAN,
  "array_data_type" BIGINT,
  "number_of_array_dimensions" BIGINT,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "type_of_exposure_identifier" VARCHAR,
  "instrument_designated_as_prime" VARCHAR,
  "proposer_s_target_name" VARCHAR  -- Proposer\u0027s Target Name,
  "pep_proposal_identifier" BIGINT,
  "angle_between_sun_and_v1_axis" DOUBLE,
  "angle_between_moon_and_v1_axis" DOUBLE,
  "altitude_of_the_sun_above_earth_s_limb" DOUBLE  -- Altitude Of The Sun Above Earth\u0027s Limb,
  "commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR  -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
  "number_of_gyros_scheduled_t_3_obad" BIGINT  -- Number Of Gyros Scheduled, T\u003d3+OBAD,
  "ut_date_of_start_of_observation_yyyy_mm_dd" TIMESTAMP  -- UT Date Of Start Of Observation (yyyy-mm-dd),
  "exposure_start_time_modified_julian_date" DOUBLE  -- Exposure Start Time (Modified Julian Date),
  "exposure_end_time_modified_julian_date" DOUBLE  -- Exposure End Time (Modified Julian Date),
  "exposure_duration_seconds_calculated" DOUBLE  -- Exposure Duration (seconds)--calculated,
  "exposure_interruption_indicator" VARCHAR,
  "fiducial_pixel_dark_time_secs" DOUBLE  -- Fiducial Pixel Dark Time (secs),
  "postarg_in_axis_1_direction" DOUBLE,
  "postarg_in_axis_2_direction" DOUBLE,
  "calibration_software_system_version_id" VARCHAR,
  "observation_type_imaging_or_spectroscopic" VARCHAR  -- Observation Type - Imaging Or Spectroscopic,
  "operating_mode" VARCHAR,
  "type_of_charge_transfer_image_if_applicable" VARCHAR  -- Type Of Charge Transfer Image, If Applicable,
  "lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR  -- Lamp Status, NONE Or Name Of Lamp Which Is On,
  "number_of_repeat_exposures_in_set_default_1" BIGINT  -- Number Of Repeat Exposures In Set: Default 1,
  "data_from_a_subarray_t_or_full_frame_f" BOOLEAN  -- Data From A Subarray (T) Or Full Frame (F),
  "detector_in_use_wfc_hrc_or_sbc" VARCHAR  -- Detector In Use: WFC, HRC, Or SBC,
  "element_selected_from_filter_wheel_1" VARCHAR,
  "element_selected_from_filter_wheel_2" VARCHAR,
  "computed_filter_wheel_offset" BIGINT,
  "filter_wheel_position_error_flag" BOOLEAN,
  "proposed_linear_ramp_filter_wavelength" DOUBLE,
  "aperture_name" VARCHAR,
  "proposed_aperture_name" VARCHAR,
  "direct_image_for_grism_or_prism_exposure" VARCHAR,
  "cte_measurement_direction_serial_or_parallel" VARCHAR  -- CTE Measurement Direction: Serial Or Parallel,
  "number_of_cosmic_ray_split_exposures" BIGINT,
  "write_out_error_array_extension" BOOLEAN,
  "data_quality_initialization" VARCHAR,
  "correct_for_a_to_d_conversion_errors" VARCHAR,
  "subtract_bias_level_computed_from_overscan_img" VARCHAR,
  "subtract_bias_image" VARCHAR,
  "post_flash_correction" VARCHAR,
  "combine_observations_to_reject_cosmic_rays" VARCHAR,
  "process_individual_observations_after_cr_reject" VARCHAR,
  "apply_shutter_shading_correction" VARCHAR,
  "subtract_dark_image" VARCHAR,
  "flat_field_data" VARCHAR,
  "populate_photometric_header_keywords" VARCHAR,
  "drizzle_processing" VARCHAR,
  "flag_sink_pixels" VARCHAR,
  "bad_pixel_table" VARCHAR,
  "ccd_calibration_parameters" VARCHAR,
  "analog_to_digital_correction_file" VARCHAR,
  "ccd_overscan_table" VARCHAR,
  "bias_image_file_name" VARCHAR,
  "post_flash_correction_file_name" VARCHAR,
  "cosmic_ray_rejection_parameters" VARCHAR,
  "shutter_shading_correction_file" VARCHAR,
  "dark_image_file_name" VARCHAR,
  "delta_flat_field_file_name" VARCHAR,
  "low_order_flat" VARCHAR,
  "photometric_throughput_table" VARCHAR,
  "the_hst_graph_table" VARCHAR,
  "the_hst_components_table" VARCHAR,
  "distortion_correction_image" VARCHAR,
  "multidrizzle_parameter_table" VARCHAR,
  "coronagraphic_spot_image" VARCHAR,
  "coronagraphic_spot_offset_table" VARCHAR,
  "image_photometry_table" VARCHAR,
  "map_of_sink_pixels" VARCHAR,
  "ccd_pixel_saturation_onset_map" VARCHAR,
  "reference_exposure_time_for_parameters" DOUBLE,
  "multiplicative_scale_factor_applied_to_noise" DOUBLE,
  "sky_value_subtracted_mode_or_none" VARCHAR  -- Sky Value Subtracted (MODE Or NONE),
  "sky_level_from_the_sum_of_all_constituent_image" DOUBLE,
  "rejection_propagation_radius_pixels" DOUBLE  -- Rejection Propagation Radius (pixels),
  "rejection_propagation_threshold" DOUBLE,
  "data_quality_flag_bits_to_reject" BIGINT,
  "rate_at_which_pixels_are_affected_by_cosmic_ray" DOUBLE,
  "flag_cr_rejected_pixels_in_input_files_t_f" BOOLEAN  -- Flag CR-rejected Pixels In Input Files (T/F),
  "primary_pattern_type" VARCHAR,
  "primary_pattern_shape" VARCHAR,
  "primary_pattern_purpose" VARCHAR,
  "number_of_points_in_primary_pattern" BIGINT,
  "point_spacing_for_primary_pattern_arc_sec" DOUBLE  -- Point Spacing For Primary Pattern (arc-sec),
  "line_spacing_for_primary_pattern_arc_sec" DOUBLE  -- Line Spacing For Primary Pattern (arc-sec),
  "angle_between_sides_of_parallelogram_patt_deg" DOUBLE  -- Angle Between Sides Of Parallelogram Patt (deg),
  "coordinate_frame_of_primary_pattern" VARCHAR,
  "orientation_of_pattern_to_coordinate_frame_deg" DOUBLE  -- Orientation Of Pattern To Coordinate Frame (deg,
  "center_pattern_relative_to_pointing_yes_no" VARCHAR  -- Center Pattern Relative To Pointing (yes/no),
  "position_number_of_this_point_in_the_pattern" BIGINT,
  "exposure_time_in_seconds_0_1_to_409_5" DOUBLE  -- Exposure Time In Seconds: 0.1 To 409.5,
  "post_flash_current_off_low_med_high" VARCHAR  -- Post Flash Current: OFF, LOW, MED, HIGH,
  "status_successful_aborted_not_performed" VARCHAR  -- Status: SUCCESSFUL, ABORTED, NOT PERFORMED,
  "shutter_position_a_or_b" VARCHAR  -- Shutter Position: A Or B
);

CREATE TABLE ngc4151_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "data_conform_to_fits_standard" BOOLEAN,
  "bits_per_data_value" BIGINT,
  "number_of_data_axes" BIGINT,
  "file_may_contain_standard_extensions" BOOLEAN,
  "number_of_standard_extensions" BIGINT,
  "image_is_in_group_format" BOOLEAN,
  "date_this_file_was_written_yyyy_mm_dd" TIMESTAMP  -- Date This File Was Written (yyyy-mm-dd),
  "name_of_file" VARCHAR,
  "type_of_data_found_in_data_file" VARCHAR,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "equinox_of_celestial_coord_system" DOUBLE  -- Equinox Of Celestial Coord. System,
  "rootname_of_the_observation_set" VARCHAR,
  "instrument_designated_as_prime" VARCHAR,
  "proposer_s_target_name" VARCHAR  -- Proposer\u0027s Target Name,
  "right_ascension_of_the_target_deg_j2000" DOUBLE  -- Right Ascension Of The Target (deg) (J2000),
  "declination_of_the_target_deg_j2000" DOUBLE  -- Declination Of The Target (deg) (J2000),
  "pep_proposal_identifier" BIGINT,
  "proposal_logsheet_line_number" DOUBLE,
  "last_name_of_principal_investigator" VARCHAR,
  "first_name_of_principal_investigator" VARCHAR,
  "middle_name_initial_of_principal_investigat" VARCHAR  -- Middle Name / Initial Of Principal Investigat,
  "ut_date_of_start_of_first_exposure_in_file" TIMESTAMP,
  "ut_start_time_of_first_exposure_in_file" VARCHAR,
  "start_time_mjd_of_1st_exposure_in_file" DOUBLE  -- Start Time (MJD) Of 1st Exposure In File,
  "end_time_mjd_of_last_exposure_in_the_file" DOUBLE  -- End Time (MJD) Of Last Exposure In The File,
  "total_exposure_time_seconds" DOUBLE  -- Total Exposure Time (seconds),
  "postarg_in_axis_1_direction" DOUBLE,
  "postarg_in_axis_2_direction" DOUBLE,
  "number_of_science_data_overflows" BIGINT,
  "data_processing_software_system_version" VARCHAR,
  "calstis_code_version" VARCHAR,
  "pipeline_processing_time_mjd" DOUBLE  -- Pipeline Processing Time (MJD),
  "calibration_software_system_version_id" VARCHAR,
  "configuration_status_support_avail_eng" VARCHAR  -- Configuration Status (support., Avail., Eng.),
  "observation_type_imaging_or_spectroscopic" VARCHAR  -- Observation Type - Imaging Or Spectroscopic,
  "operating_mode" VARCHAR,
  "observation_con" VARCHAR,
  "lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR  -- Lamp Status, NONE Or Name Of Lamp Which Is On,
  "spectral_cal_lamp_current_value_milliamps" DOUBLE  -- Spectral Cal Lamp Current Value (milliamps),
  "number_of_repeat_exposures_in_set_default_1" BIGINT  -- Number Of Repeat Exposures In Set: Default 1,
  "data_from_a_subarray_t_or_full_frame_f" BOOLEAN  -- Data From A Subarray (T) Or Full Frame (F),
  "detector_in_use_nuv_mama_fuv_mama_or_ccd" VARCHAR  -- Detector In Use: NUV-MAMA, FUV-MAMA, Or CCD,
  "optical_element_in_use" VARCHAR,
  "aperture_name" VARCHAR,
  "proposed_aperture_name" VARCHAR,
  "filter_in_use" VARCHAR,
  "aperture_field_of_view" VARCHAR,
  "number_of_cosmic_ray_split_exposures" BIGINT,
  "ccd_amplifier_read_out_a_b_c_d" VARCHAR  -- CCD Amplifier Read Out (A,B,C,D),
  "commanded_gain_of_ccd" BIGINT,
  "commanded_ccd_bias_offset" BIGINT,
  "subarray_axis1_center_pt_in_unbinned_dect_pix" BIGINT  -- Subarray Axis1 Center Pt In Unbinned Dect. Pix,
  "subarray_axis2_center_pt_in_unbinned_dect_pix" BIGINT  -- Subarray Axis2 Center Pt In Unbinned Dect. Pix,
  "subarray_axis1_size_in_unbinned_detector_pixels" BIGINT,
  "subarray_axis2_size_in_unbinned_detector_pixels" BIGINT,
  "axis1_data_bin_size_in_unbinned_detector_pixels" BIGINT,
  "axis2_data_bin_size_in_unbinned_detector_pixels" BIGINT,
  "inverse_sensitivity_ergs_s_cm2_ang_per_count_s" DOUBLE  -- Inverse Sensitivity, Ergs/s/cm2/Ang Per Count/s,
  "st_magnitude_zero_point" DOUBLE,
  "pivot_wavelength_angstroms" DOUBLE  -- Pivot Wavelength (Angstroms),
  "rms_bandwidth_of_filter_plus_detector" DOUBLE,
  "data_quality_initialization" VARCHAR,
  "subtract_bias_level_computed_from_overscan_img" VARCHAR,
  "subtract_bias_image" VARCHAR,
  "combine_observations_to_reject_cosmic_rays" VARCHAR,
  "add_individual_repeat_observations" VARCHAR,
  "process_individual_observations_after_cr_reject" VARCHAR,
  "subtract_dark_image" VARCHAR,
  "flat_field_data" VARCHAR,
  "populate_photometric_header_keywords" VARCHAR,
  "calculate_statistics" BOOLEAN  -- Calculate Statistics?,
  "perform_geometric_correction_for_imaging_modes" VARCHAR,
  "bad_pixel_table" VARCHAR,
  "dark_image_file_name" VARCHAR,
  "pixel_to_pixel_flat_field_file_name" VARCHAR,
  "low_order_flat" VARCHAR,
  "photometric_throughput_table" VARCHAR,
  "imaging_photometric_table" VARCHAR,
  "relative_aperture_throughput_table" VARCHAR,
  "ccd_calibration_parameters" VARCHAR,
  "bias_image_file_name" VARCHAR,
  "cosmic_ray_rejection_parameters" VARCHAR,
  "image_distortion_correction_table" VARCHAR,
  "time_dependent_sensitivity_algorithm_used" VARCHAR,
  "reference_exposure_time_for_parameters" DOUBLE,
  "multiplicative_scale_factor_applied_to_noise" DOUBLE,
  "initial_guess_method_min_or_med" VARCHAR  -- Initial Guess Method (MIN Or MED),
  "sky_value_subtracted_mode_or_none" VARCHAR  -- Sky Value Subtracted (MODE Or NONE),
  "sky_level_from_the_sum_of_all_constituent_image" DOUBLE,
  "statistical_rejection_criteria" VARCHAR,
  "rejection_propagation_radius_pixels" DOUBLE  -- Rejection Propagation Radius (pixels),
  "rejection_propagation_threshold" DOUBLE,
  "data_quality_flag_bits_to_reject" BIGINT,
  "rate_at_which_pixels_are_affected_by_cosmic_ray" DOUBLE,
  "flag_cr_rejected_pixels_in_input_files_t_f" BOOLEAN  -- Flag CR-rejected Pixels In Input Files (T/F),
  "calibrated_ccd_amplifier_gain_value" DOUBLE,
  "calibrated_ccd_read_noise_value" DOUBLE,
  "bandwidth_of_the_data" DOUBLE
);

CREATE TABLE oj287_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "conforms_to_fits_standard" BOOLEAN,
  "array_data_type" BIGINT,
  "number_of_array_dimensions" BIGINT,
  "date_this_file_was_written_yyyy_mm_dd" TIMESTAMP  -- Date This File Was Written (yyyy-mm-dd),
  "type_of_data_found_in_data_file" VARCHAR,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "equinox_of_celestial_coord_system" DOUBLE  -- Equinox Of Celestial Coord. System,
  "rootname_of_the_observation_set" VARCHAR,
  "pipeline_processing_time_mjd" DOUBLE  -- Pipeline Processing Time (MJD),
  "opus_software_system_version_number" VARCHAR,
  "calwp2_code_version" VARCHAR,
  "instr_mode_full_full_res_area_area_int" VARCHAR  -- Instr. Mode: FULL (full Res.), AREA (area Int.),
  "serial_clocks_on_off" VARCHAR  -- Serial Clocks: ON, OFF,
  "dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
  "generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
  "packet_format_code" BIGINT,
  "first_filter_name" VARCHAR,
  "second_filter_name" VARCHAR,
  "first_filter_number_0_48" BIGINT  -- First Filter Number (0-48),
  "second_filter_number_0_48" BIGINT  -- Second Filter Number (0-48),
  "partial_filter_rotation_angle_degrees" DOUBLE  -- Partial Filter Rotation Angle (degrees),
  "linear_ramp_filter_wavelength" DOUBLE,
  "bandwidth_of_the_filter" DOUBLE,
  "central_wavelength_of_the_filter" DOUBLE,
  "tec_cold_junction_1_temperature_celsius" DOUBLE  -- TEC Cold Junction #1 Temperature (Celsius),
  "tec_cold_junction_2_temperature_celsius" DOUBLE  -- TEC Cold Junction #2 Temperature (Celsius),
  "tec_cold_junction_3_temperature_celsius" DOUBLE  -- TEC Cold Junction #3 Temperature (Celsius),
  "tec_cold_junction_4_temperature_celsius" DOUBLE  -- TEC Cold Junction #4 Temperature (Celsius),
  "bay_3_a1_temperature_deg_c" DOUBLE  -- Bay 3 A1 Temperature (deg C),
  "status_of_kelsall_spot_lamps_on_off" VARCHAR  -- Status Of Kelsall Spot Lamps: ON, OFF,
  "shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
  "analog_to_digital_gain_electrons_dn" DOUBLE  -- Analog To Digital Gain (Electrons/DN),
  "do_mask_correction_perform_omit_complete" VARCHAR  -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
  "do_a_to_d_correction_perform_omit_complete" VARCHAR  -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
  "correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
  "do_bias_level_correction" VARCHAR,
  "do_bias_correction_perform_omit_complete" VARCHAR  -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
  "do_dark_correction_perform_omit_complete" VARCHAR  -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
  "do_flat_field_correction" VARCHAR,
  "do_shaded_shutter_correction" VARCHAR,
  "output_saturated_pixel_map" VARCHAR,
  "fill_photometry_keywords" VARCHAR,
  "make_histograms_perform_omit_complete" VARCHAR  -- Make Histograms: PERFORM, OMIT, COMPLETE,
  "drizzle_processing" VARCHAR,
  "output_image_datatype_real_long_short" VARCHAR  -- Output Image Datatype: REAL, LONG, SHORT,
  "name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
  "name_of_the_a_to_d_conversion_file" VARCHAR,
  "name_of_the_wf4_correction_reference_file" VARCHAR,
  "engineering_file_with_extended_register_da" VARCHAR,
  "engineering_file_dqf" VARCHAR,
  "name_of_the_bias_frame_reference_file" VARCHAR,
  "name_of_the_bias_frame_reference_dqf" VARCHAR,
  "name_of_the_dark_reference_file" VARCHAR,
  "name_of_the_dark_reference_dqf" VARCHAR,
  "name_of_the_flat_field_reference_file" VARCHAR,
  "name_of_the_flat_field_reference_dqf" VARCHAR,
  "name_of_the_reference_file_for_shutter_sha" VARCHAR,
  "name_of_the_photometry_calibration_table" VARCHAR,
  "the_hst_graph_table" VARCHAR,
  "the_hst_components_table" VARCHAR,
  "distortion_correction_table" VARCHAR,
  "drift_correction_table" VARCHAR,
  "distortion_correction_image" VARCHAR,
  "data_value_at_which_saturation_occurs" BIGINT,
  "scale_factor_for_output_image" DOUBLE,
  "zero_point_for_output_image" DOUBLE,
  "length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
  "position_angle_of_v3_axis_of_hst_deg" DOUBLE  -- Position Angle Of V3-axis Of HST (deg),
  "right_ascension_of_the_sun_deg" DOUBLE  -- Right Ascension Of The Sun (deg),
  "declination_of_the_sun_deg" DOUBLE  -- Declination Of The Sun (deg),
  "equinox_of_the_sun" DOUBLE,
  "moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN  -- Moving Target Flag; T If It Is A Moving Target,
  "equatorial_radius_of_target_km" DOUBLE  -- Equatorial Radius Of Target (km),
  "flattening_of_target" DOUBLE,
  "north_pole_declination_of_target_deg" DOUBLE  -- North Pole Declination Of Target (deg),
  "north_pole_right_ascension_of_target_deg" DOUBLE  -- North Pole Right Ascension Of Target (deg),
  "rotation_rate_of_target" DOUBLE,
  "longitude_of_prime_meridian_deg" DOUBLE  -- Longitude Of Prime Meridian (deg),
  "epoch_of_longitude_of_prime_meridian_sec" DOUBLE  -- Epoch Of Longitude Of Prime Meridian (sec),
  "surface_feature_latitude_deg" DOUBLE  -- Surface Feature Latitude (deg),
  "surface_feature_longitude_deg" DOUBLE  -- Surface Feature Longitude (deg),
  "surface_feature_altitude_km" DOUBLE  -- Surface Feature Altitude (km),
  "n_0_no_podps_fill_1_podps_fill_present" BIGINT  -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
  "n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT  -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
  "st_dcf_fill_pattern_hex" VARCHAR  -- St Dcf Fill Pattern (hex),
  "bad_data_fill_value_for_calibrated_images" BIGINT,
  "commanded_duration_of_exposure_sec" BIGINT  -- Commanded Duration Of Exposure (sec),
  "number_of_ap17_shutter_b_closes" BIGINT,
  "dark_time_seconds" DOUBLE  -- Dark Time (seconds),
  "major_frame_pulse_time_preceding_exposure_start" BIGINT,
  "predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR  -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
  "predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR  -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
  "angle_between_sun_and_v1_axis" DOUBLE,
  "angle_between_moon_and_v1_axis" DOUBLE,
  "altitude_of_the_sun_above_earth_s_limb" DOUBLE  -- Altitude Of The Sun Above Earth\u0027s Limb,
  "commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR  -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
  "number_of_gyros_scheduled_t_3_obad" BIGINT  -- Number Of Gyros Scheduled, T\u003d3+OBAD,
  "guide_star_catalog_version" VARCHAR
);

CREATE TABLE sagittarius_a_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "conforms_to_fits_standard" BOOLEAN,
  "array_data_type" BIGINT,
  "number_of_array_dimensions" BIGINT,
  "date_this_file_was_written_yyyy_mm_dd" TIMESTAMP  -- Date This File Was Written (yyyy-mm-dd),
  "type_of_data_found_in_data_file" VARCHAR,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "equinox_of_celestial_coord_system" DOUBLE  -- Equinox Of Celestial Coord. System,
  "rootname_of_the_observation_set" VARCHAR,
  "pipeline_processing_time_mjd" DOUBLE  -- Pipeline Processing Time (MJD),
  "opus_software_system_version_number" VARCHAR,
  "calwp2_code_version" VARCHAR,
  "instr_mode_full_full_res_area_area_int" VARCHAR  -- Instr. Mode: FULL (full Res.), AREA (area Int.),
  "serial_clocks_on_off" VARCHAR  -- Serial Clocks: ON, OFF,
  "dark_bias_iflat_uflat_vflat_kspot_ext_ecal" VARCHAR,
  "generic_bias_dark_pref_flat_mask_atod_no" VARCHAR,
  "packet_format_code" BIGINT,
  "first_filter_name" VARCHAR,
  "second_filter_name" VARCHAR,
  "first_filter_number_0_48" BIGINT  -- First Filter Number (0-48),
  "second_filter_number_0_48" BIGINT  -- Second Filter Number (0-48),
  "partial_filter_rotation_angle_degrees" DOUBLE  -- Partial Filter Rotation Angle (degrees),
  "linear_ramp_filter_wavelength" DOUBLE,
  "bandwidth_of_the_filter" DOUBLE,
  "central_wavelength_of_the_filter" DOUBLE,
  "tec_cold_junction_1_temperature_celsius" DOUBLE  -- TEC Cold Junction #1 Temperature (Celsius),
  "tec_cold_junction_2_temperature_celsius" DOUBLE  -- TEC Cold Junction #2 Temperature (Celsius),
  "tec_cold_junction_3_temperature_celsius" DOUBLE  -- TEC Cold Junction #3 Temperature (Celsius),
  "tec_cold_junction_4_temperature_celsius" DOUBLE  -- TEC Cold Junction #4 Temperature (Celsius),
  "bay_3_a1_temperature_deg_c" DOUBLE  -- Bay 3 A1 Temperature (deg C),
  "status_of_kelsall_spot_lamps_on_off" VARCHAR  -- Status Of Kelsall Spot Lamps: ON, OFF,
  "shutter_in_place_at_beginning_of_the_exposure" VARCHAR,
  "analog_to_digital_gain_electrons_dn" DOUBLE  -- Analog To Digital Gain (Electrons/DN),
  "do_mask_correction_perform_omit_complete" VARCHAR  -- Do Mask Correction: PERFORM, OMIT, COMPLETE,
  "do_a_to_d_correction_perform_omit_complete" VARCHAR  -- Do A-to-D Correction: PERFORM, OMIT, COMPLETE,
  "correct_wf4_data_for_temp_dependent_amp_error" VARCHAR,
  "do_bias_level_correction" VARCHAR,
  "do_bias_correction_perform_omit_complete" VARCHAR  -- Do Bias Correction: PERFORM, OMIT, COMPLETE,
  "do_dark_correction_perform_omit_complete" VARCHAR  -- Do Dark Correction: PERFORM, OMIT, COMPLETE,
  "do_flat_field_correction" VARCHAR,
  "do_shaded_shutter_correction" VARCHAR,
  "output_saturated_pixel_map" VARCHAR,
  "fill_photometry_keywords" VARCHAR,
  "make_histograms_perform_omit_complete" VARCHAR  -- Make Histograms: PERFORM, OMIT, COMPLETE,
  "drizzle_processing" VARCHAR,
  "output_image_datatype_real_long_short" VARCHAR  -- Output Image Datatype: REAL, LONG, SHORT,
  "name_of_the_input_dqf_of_known_bad_pixels" VARCHAR,
  "name_of_the_a_to_d_conversion_file" VARCHAR,
  "name_of_the_wf4_correction_reference_file" VARCHAR,
  "engineering_file_with_extended_register_da" VARCHAR,
  "engineering_file_dqf" VARCHAR,
  "name_of_the_bias_frame_reference_file" VARCHAR,
  "name_of_the_bias_frame_reference_dqf" VARCHAR,
  "name_of_the_dark_reference_file" VARCHAR,
  "name_of_the_dark_reference_dqf" VARCHAR,
  "name_of_the_flat_field_reference_file" VARCHAR,
  "name_of_the_flat_field_reference_dqf" VARCHAR,
  "name_of_the_reference_file_for_shutter_sha" VARCHAR,
  "name_of_the_photometry_calibration_table" VARCHAR,
  "the_hst_graph_table" VARCHAR,
  "the_hst_components_table" VARCHAR,
  "distortion_correction_table" VARCHAR,
  "drift_correction_table" VARCHAR,
  "distortion_correction_image" VARCHAR,
  "data_value_at_which_saturation_occurs" BIGINT,
  "scale_factor_for_output_image" DOUBLE,
  "zero_point_for_output_image" DOUBLE,
  "length_of_time_for_ccd_readout_in_clock_ticks" BIGINT,
  "position_angle_of_v3_axis_of_hst_deg" DOUBLE  -- Position Angle Of V3-axis Of HST (deg),
  "right_ascension_of_the_sun_deg" DOUBLE  -- Right Ascension Of The Sun (deg),
  "declination_of_the_sun_deg" DOUBLE  -- Declination Of The Sun (deg),
  "equinox_of_the_sun" DOUBLE,
  "moving_target_flag_t_if_it_is_a_moving_target" BOOLEAN  -- Moving Target Flag; T If It Is A Moving Target,
  "equatorial_radius_of_target_km" DOUBLE  -- Equatorial Radius Of Target (km),
  "flattening_of_target" DOUBLE,
  "north_pole_declination_of_target_deg" DOUBLE  -- North Pole Declination Of Target (deg),
  "north_pole_right_ascension_of_target_deg" DOUBLE  -- North Pole Right Ascension Of Target (deg),
  "rotation_rate_of_target" DOUBLE,
  "longitude_of_prime_meridian_deg" DOUBLE  -- Longitude Of Prime Meridian (deg),
  "epoch_of_longitude_of_prime_meridian_sec" DOUBLE  -- Epoch Of Longitude Of Prime Meridian (sec),
  "surface_feature_latitude_deg" DOUBLE  -- Surface Feature Latitude (deg),
  "surface_feature_longitude_deg" DOUBLE  -- Surface Feature Longitude (deg),
  "surface_feature_altitude_km" DOUBLE  -- Surface Feature Altitude (km),
  "n_0_no_podps_fill_1_podps_fill_present" BIGINT  -- 0\u003d(no Podps Fill); 1\u003d(podps Fill Present),
  "n_0_no_st_dcf_fill_1_st_dcf_fill_present" BIGINT  -- 0\u003d(no St Dcf Fill); 1\u003d(st Dcf Fill Present),
  "st_dcf_fill_pattern_hex" VARCHAR  -- St Dcf Fill Pattern (hex),
  "bad_data_fill_value_for_calibrated_images" BIGINT,
  "commanded_duration_of_exposure_sec" BIGINT  -- Commanded Duration Of Exposure (sec),
  "number_of_ap17_shutter_b_closes" BIGINT,
  "dark_time_seconds" DOUBLE  -- Dark Time (seconds),
  "major_frame_pulse_time_preceding_exposure_start" BIGINT,
  "predicted_obs_start_time_yyyy_ddd_hh_mm_ss" VARCHAR  -- Predicted Obs. Start Time (yyyy.ddd:hh:mm:ss),
  "predicted_obs_stop_time_yyyy_ddd_hh_mm_ss" VARCHAR  -- Predicted Obs. Stop Time (yyyy.ddd:hh:mm:ss),
  "angle_between_sun_and_v1_axis" DOUBLE,
  "angle_between_moon_and_v1_axis" DOUBLE,
  "altitude_of_the_sun_above_earth_s_limb" DOUBLE  -- Altitude Of The Sun Above Earth\u0027s Limb,
  "commanded_fgs_lock_fine_coarse_gyros_unknown" VARCHAR  -- Commanded FGS Lock (FINE,COARSE,GYROS,UNKNOWN),
  "number_of_gyros_scheduled_t_3_obad" BIGINT  -- Number Of Gyros Scheduled, T\u003d3+OBAD,
  "guide_star_catalog_version" VARCHAR
);

CREATE TABLE sombrero_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "data_conform_to_fits_standard" BOOLEAN,
  "bits_per_data_value" BIGINT,
  "number_of_data_axes" BIGINT,
  "file_may_contain_standard_extensions" BOOLEAN,
  "number_of_standard_extensions" BIGINT,
  "image_is_in_group_format" BOOLEAN,
  "date_this_file_was_written_yyyy_mm_dd" TIMESTAMP  -- Date This File Was Written (yyyy-mm-dd),
  "name_of_file" VARCHAR,
  "type_of_data_found_in_data_file" VARCHAR,
  "telescope_used_to_acquire_data" VARCHAR,
  "identifier_for_instrument_used_to_acquire_data" VARCHAR,
  "equinox_of_celestial_coord_system" DOUBLE  -- Equinox Of Celestial Coord. System,
  "rootname_of_the_observation_set" VARCHAR,
  "instrument_designated_as_prime" VARCHAR,
  "proposer_s_target_name" VARCHAR  -- Proposer\u0027s Target Name,
  "right_ascension_of_the_target_deg_j2000" DOUBLE  -- Right Ascension Of The Target (deg) (J2000),
  "declination_of_the_target_deg_j2000" DOUBLE  -- Declination Of The Target (deg) (J2000),
  "pep_proposal_identifier" BIGINT,
  "proposal_logsheet_line_number" DOUBLE,
  "last_name_of_principal_investigator" VARCHAR,
  "first_name_of_principal_investigator" VARCHAR,
  "middle_name_initial_of_principal_investigat" VARCHAR  -- Middle Name / Initial Of Principal Investigat,
  "ut_date_of_start_of_first_exposure_in_file" TIMESTAMP,
  "ut_start_time_of_first_exposure_in_file" VARCHAR,
  "start_time_mjd_of_1st_exposure_in_file" DOUBLE  -- Start Time (MJD) Of 1st Exposure In File,
  "end_time_mjd_of_last_exposure_in_the_file" DOUBLE  -- End Time (MJD) Of Last Exposure In The File,
  "total_exposure_time_seconds" DOUBLE  -- Total Exposure Time (seconds),
  "postarg_in_axis_1_direction" DOUBLE,
  "postarg_in_axis_2_direction" DOUBLE,
  "number_of_science_data_overflows" BIGINT,
  "data_processing_software_system_version" VARCHAR,
  "calstis_code_version" VARCHAR,
  "pipeline_processing_time_mjd" DOUBLE  -- Pipeline Processing Time (MJD),
  "calibration_software_system_version_id" VARCHAR,
  "configuration_status_support_avail_eng" VARCHAR  -- Configuration Status (support., Avail., Eng.),
  "observation_type_imaging_or_spectroscopic" VARCHAR  -- Observation Type - Imaging Or Spectroscopic,
  "operating_mode" VARCHAR,
  "observation_con" VARCHAR,
  "lamp_status_none_or_name_of_lamp_which_is_on" VARCHAR  -- Lamp Status, NONE Or Name Of Lamp Which Is On,
  "spectral_cal_lamp_current_value_milliamps" DOUBLE  -- Spectral Cal Lamp Current Value (milliamps),
  "number_of_repeat_exposures_in_set_default_1" BIGINT  -- Number Of Repeat Exposures In Set: Default 1,
  "data_from_a_subarray_t_or_full_frame_f" BOOLEAN  -- Data From A Subarray (T) Or Full Frame (F),
  "detector_in_use_nuv_mama_fuv_mama_or_ccd" VARCHAR  -- Detector In Use: NUV-MAMA, FUV-MAMA, Or CCD,
  "optical_element_in_use" VARCHAR,
  "aperture_name" VARCHAR,
  "proposed_aperture_name" VARCHAR,
  "filter_in_use" VARCHAR,
  "aperture_field_of_view" VARCHAR,
  "number_of_cosmic_ray_split_exposures" BIGINT,
  "ccd_amplifier_read_out_a_b_c_d" VARCHAR  -- CCD Amplifier Read Out (A,B,C,D),
  "commanded_gain_of_ccd" BIGINT,
  "commanded_ccd_bias_offset" BIGINT,
  "subarray_axis1_center_pt_in_unbinned_dect_pix" BIGINT  -- Subarray Axis1 Center Pt In Unbinned Dect. Pix,
  "subarray_axis2_center_pt_in_unbinned_dect_pix" BIGINT  -- Subarray Axis2 Center Pt In Unbinned Dect. Pix,
  "subarray_axis1_size_in_unbinned_detector_pixels" BIGINT,
  "subarray_axis2_size_in_unbinned_detector_pixels" BIGINT,
  "axis1_data_bin_size_in_unbinned_detector_pixels" BIGINT,
  "axis2_data_bin_size_in_unbinned_detector_pixels" BIGINT,
  "inverse_sensitivity_ergs_s_cm2_ang_per_count_s" DOUBLE  -- Inverse Sensitivity, Ergs/s/cm2/Ang Per Count/s,
  "st_magnitude_zero_point" DOUBLE,
  "pivot_wavelength_angstroms" DOUBLE  -- Pivot Wavelength (Angstroms),
  "rms_bandwidth_of_filter_plus_detector" DOUBLE,
  "data_quality_initialization" VARCHAR,
  "subtract_bias_level_computed_from_overscan_img" VARCHAR,
  "subtract_bias_image" VARCHAR,
  "combine_observations_to_reject_cosmic_rays" VARCHAR,
  "add_individual_repeat_observations" VARCHAR,
  "process_individual_observations_after_cr_reject" VARCHAR,
  "subtract_dark_image" VARCHAR,
  "flat_field_data" VARCHAR,
  "populate_photometric_header_keywords" VARCHAR,
  "calculate_statistics" BOOLEAN  -- Calculate Statistics?,
  "perform_geometric_correction_for_imaging_modes" VARCHAR,
  "bad_pixel_table" VARCHAR,
  "dark_image_file_name" VARCHAR,
  "pixel_to_pixel_flat_field_file_name" VARCHAR,
  "low_order_flat" VARCHAR,
  "photometric_throughput_table" VARCHAR,
  "imaging_photometric_table" VARCHAR,
  "relative_aperture_throughput_table" VARCHAR,
  "ccd_calibration_parameters" VARCHAR,
  "bias_image_file_name" VARCHAR,
  "cosmic_ray_rejection_parameters" VARCHAR,
  "image_distortion_correction_table" VARCHAR,
  "time_dependent_sensitivity_algorithm_used" VARCHAR,
  "reference_exposure_time_for_parameters" DOUBLE,
  "multiplicative_scale_factor_applied_to_noise" DOUBLE,
  "initial_guess_method_min_or_med" VARCHAR  -- Initial Guess Method (MIN Or MED),
  "sky_value_subtracted_mode_or_none" VARCHAR  -- Sky Value Subtracted (MODE Or NONE),
  "sky_level_from_the_sum_of_all_constituent_image" DOUBLE,
  "statistical_rejection_criteria" VARCHAR,
  "rejection_propagation_radius_pixels" DOUBLE  -- Rejection Propagation Radius (pixels),
  "rejection_propagation_threshold" DOUBLE,
  "data_quality_flag_bits_to_reject" BIGINT,
  "rate_at_which_pixels_are_affected_by_cosmic_ray" DOUBLE,
  "flag_cr_rejected_pixels_in_input_files_t_f" BOOLEAN  -- Flag CR-rejected Pixels In Input Files (T/F),
  "calibrated_ccd_amplifier_gain_value" DOUBLE,
  "calibrated_ccd_read_noise_value" DOUBLE,
  "bandwidth_of_the_data" DOUBLE
);