Choose a database in the left panel then select the table you want!
Table: gaia_dr2.tsstat
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| abbe_mag_bp | Abbe value for BP observations | DOUBLE |
| abbe_mag_g_fov | Abbe value for G FoV transits | DOUBLE |
| abbe_mag_rp | Abbe value for RP observations | DOUBLE |
| iqr_mag_bp | Interquartile BP magnitude range | DOUBLE |
| iqr_mag_g_fov | Interquartile range for G FoV transits | DOUBLE |
| iqr_mag_rp | Interquartile RP magnitude range | DOUBLE |
| kurtosis_mag_bp | Standardized unweighted BP magnitude kurtosis | DOUBLE |
| kurtosis_mag_g_fov | Standardized unweighted G FoV magnitude kurtosis | DOUBLE |
| kurtosis_mag_rp | Standardized unweighted RP magnitude kurtosis | DOUBLE |
| mad_mag_bp | Median Absolute Deviation (MAD) for BP observations | DOUBLE |
| mad_mag_g_fov | Median Absolute Deviation (MAD) for G FoV transits | DOUBLE |
| mad_mag_rp | Median Absolute Deviation (MAD) for RP observations | DOUBLE |
| max_mag_bp | Maximum BP magnitude | DOUBLE |
| max_mag_g_fov | Maximum G FoV magnitude | DOUBLE |
| max_mag_rp | Maximum RP magnitude | DOUBLE |
| mean_mag_bp | Mean BP magnitude | DOUBLE |
| mean_mag_g_fov | Mean G FoV magnitude | DOUBLE |
| mean_mag_rp | Mean RP magnitude | DOUBLE |
| mean_obs_time_bp | Mean observation time for BP observations | DOUBLE |
| mean_obs_time_g_fov | Mean observation time for G FoV transits | DOUBLE |
| mean_obs_time_rp | Mean observation time for RP observations | DOUBLE |
| median_mag_bp | Median BP magnitude | DOUBLE |
| median_mag_g_fov | Median G FoV magnitude | DOUBLE |
| median_mag_rp | Median RP magnitude | DOUBLE |
| min_mag_bp | Minimum BP magnitude | DOUBLE |
| min_mag_g_fov | Minimum G FoV magnitude | DOUBLE |
| min_mag_rp | Minimum RP magnitude | DOUBLE |
| num_selected_bp | Total number of BP observations selected for variability analysis | SMALLINT |
| num_selected_g_fov | Total number of G FOV transits selected for variability analysis | SMALLINT |
| num_selected_rp | Total number of RP observations selected for variability analysis | SMALLINT |
| range_mag_bp | Difference between the highest and lowest BP magnitudes | DOUBLE |
| range_mag_g_fov | Difference between the highest and lowest G FoV magnitudes | DOUBLE |
| range_mag_rp | Difference between the highest and lowest RP magnitudes | DOUBLE |
| skewness_mag_bp | Standardized unweighted BP magnitude skewness | DOUBLE |
| skewness_mag_g_fov | Standardized unweighted G FoV magnitude skewness | DOUBLE |
| skewness_mag_rp | Standardized unweighted RP magnitude skewness | DOUBLE |
| solution_id | Solution Identifier | BIGINT |
| source_id | Unique source identifier | BIGINT |
| std_dev_mag_bp | Square root of the unweighted BP magnitude variance | DOUBLE |
| std_dev_mag_g_fov | Square root of the unweighted G FoV magnitude variance | DOUBLE |
| std_dev_mag_rp | Square root of the unweighted RP magnitude variance | DOUBLE |
| time_duration_bp | Time duration of the BP time series | DOUBLE |
| time_duration_g_fov | Time duration of the time series for G FoV transits | DOUBLE |
| time_duration_rp | Time duration of the RP time series | DOUBLE |
