Microlensing Planets Data Column Definitions

Data Columns in the Microlensing Planets Table

The following table lists all of the data columns in the Microlensing Planets Table. These parameters can also be retrieved programmatically through the archive's application programing interface (API), described below.

More details on microlensing resources in the archive are listed on the Microlensing Resources page.

Query-based Access to the Microlensing Table

The Microlensing Table is connected to the archive's API service, which enables automated data retrieval using queries or scripts. To build a query, review the API User Guide and use the database column names on this page.

Please note: The Microlensing Table's database table name (ML) and column names were changed in April 2021, so queries developed before the redesign will not return the most current data. This page lists all of the current database column names and their definitions.No columns were added or removed as part of the redesign, and all default columns remain the same. This document maps the old and new column names to help you update your queries. The mapping document is also available as a comma-separated values (CSV) file.

Digital Object Identifier

If you use archive data or services for your research, please include the following Digital Object Identifier (DOI) as part of your acknowledgment:

DOI 10.26133/NEA7

See Acknowledging the Archive for data set-specific language. See the full list of NASA Exoplanet Archive DOIs for other data sets and services.

_______________________________________________

Skip to a subsection:

Default Columns
Coordinate Columns
Microlensing Parameters
Magnitude Columns
Color Columns
Model Columns

_______________________________________________

Top

Default Columns

Default columns are those that display in the Microlensing interactive table when the table is first loaded and when the Reset Filters button is clicked. To add or remove other columns to the interactive table, click the Select Columns button in the upper-left corner of the interface to access Column Controls.

For more information on using the archive's interactive tables, see the User Guide.

Database
Column Name
Table Label Description Uncertainties Column
(positive +)
(negative -)
Limit Column
pl_name Planet Name Planet name    
rastr RA [sexagesimal] Right ascension of the microlensing event, in sexagesimal format    
decstr Dec [sexagesimal] Declination of the microlensing event, in sexagesimal format    
pl_massj Planet Mass [Jupiter mass] Mass of planet, in Jupiter masses (+) pl_orbmassjerr1
(-) pl_massjerr2
pl_massjlim
pl_masse Planet Mass [Earth mass] Mass of planet, in Earth masses (+) pl_orbmasseerr1
(-) pl_masseerr2
pl_masselim
pl_orbsmax Planet-star Projected Semi-major Axis [au] Projected physical separation of the planet and the host star in the plane of the sky at the time of the event (+) pl_orbsmaxerr1
(-) pl_orbsmaxerr2
pl_orbsmaxlim
st_mass Lens Mass [Solar mass] Host star mass (+) st_masserr1
(-) st_masserr2
sy_dist
sy_dist Lens Distance [pc] Distance from the observer to the lens system (+) sy_disterr1
(-) sy_disterr2
sy_distlim
ml_dists Source Distance [pc] Distance from the observer to the source system (+) ml_distserr1
(-) ml_distserr2
ml_distslim
ml_tsepmin Time of Lens-source Minimum Separation [days] Time of lense-source minimum separation in the plane of the sky (+) ml_tsepminerr1
(-) ml_tsepminerr2
ml_tsepmin
ml_sepminnorm Normalized Lens-source Minimum Separation Angular lens-source minimum separation in the plane of the sky, normalized to the angular Einstein radius (microlens impact parameter) (+) ml_sepminnormerr1
(-) ml_sepminnormerr2
ml_sepminnormlim
ml_xtimeein Einstein Crossing Time [days] Time for the lens-source separation to change by one angular Einstein radius (+) ml_xtimeeinerr1
(-) ml_xtimeeinerr2
ml_xtimeeinlim
ml_radsnorm Normalized Source Angular Radius (10-3) Ratio of angular source star radius to the angular Einstein radius (x 10-3) (+) ml_radsnormerr1
(-) ml_radsnormerr2
ml_radsnormlim
ml_sepinsnorp Instantaneous Planet-star Projected and Normalized Separation Projected, angular separation of the planet and the host star in the plane of the sky at the time of the event, normalized to the angular Einstein radius (+) ml_sepinsnorperr1
(-) ml_sepinsnorperr2
mlmassratio
ml_massratio Planet-star Mass Ratio (10-4) Ratio of the planet mass to the host star mass (lens system; x 10-4) (+) ml_massratioerr1
(-) ml_massratioerr2
ml_massratiolim
ml_angstlax Source Trajectory-lens Axis Angle [rad] Angle of the source system trajectory relative to the lens system axis (+) ml_angstlaxerr1
(-) ml_angstlaxerr2
ml_angstlaxlim
ml_magis Source I-band [mag] Brightness of the unmagnified source star, in I-band (+) ml_magiserr1
(-) ml_magiserr2
ml_magislim
ml_magibl Blend I-band [mag] Brightness of all objects, excluding the source star, superposed at the time of the event, in I-band (+) ml_magiblerr1
(-) ml_magiblerr2
ml_magibllim
ml_radeinang Angular Einstein Radius [mas] Angular radius of the Einstein ring (+) ml_radeinangerr1
(-) ml_radeinangerr2
ml_radeinanglim
ml_pmrells Lens-source Relative Proper Motion [mas/yr] Lens-source relative proper motion (+) ml_pmrellserr1
(-) ml_pmrellserr2
ml_pmrellslim
ml_modeldef Default Model Binary flag indicating whether given microlens model is the default; best-fit model (1=yes; 0=no)    


Top

Coordinate Columns

Database
Column Name
Table Label Description
ra RA [deg] Right ascension of the microlensing event, in decimal degrees
dec Dec [deg] Declination of the microlensing event, in decimal degrees
glon Galactic Longitude [deg] Galactic longitude of the microlensing event, in decimal degrees
glat Galactic Latitude [deg] Galactic latitude of the microlensing event, in decimal degrees


Top

Microlensing Parameter Columns

Database
Column Name
Table Label Description Uncertainties Column
(positive +)
(negative -)
Limit Column
ml_plxrel Lens-source Relative Parallax Lens-source relative parallax (+) ml_plxrelerr1
(-) ml_plxrelerr2
ml_plxrellim
ml_plxmicro Microlens Parallax Lens-source relative parallax normalized to the angular Einstein radius (+) ml_plxmicroerr1
(-) ml_plxmicroerr2
ml_plxicrolim
ml_plxmicron Microlens Parallax (North Component) North component of the microlens parallax (+) ml_plxmicronerr1
(-) ml_plxmicronerr2
ml_plxmicronlim
ml_plxmicroe Microlens Parallax (East Component) East component of the microlens parallax (+) ml_plxmicroeerr1
(-) ml_plxmicroeerr2
ml_plxmicroelim
ml_dsdt Planet-star Separation Rate of Change [yr-1] Time rate of change of the projected, angular, normalized separation of the planet and host star in the plane of the sky due to orbital motion of the lens components (+) ml_dsdterr1
(-) ml_dsdterr2
ml_dsdtlim
ml_dalphadt Source Trajectory Angle Rate of Change [rad/yr] Time rate of change of the angle of the source system trajectory to the lens system axis due to the orbital motion of the lens components (+) ml_dalphadterr1
(-) ml_dalphadterr2
ml_dalphadtlim
ml_radsang Source Angular Radius [microas] Angular source star radius (+) ml_radsangerr1
(-) ml_radsangerr2
ml_radsanglim
ml_radsphy Source Physical Radius [Solar radii] Physical source star radius (+) ml_radsphyerr1
(-) ml_radsphyerr2
ml_radsphylim
ml_xtimesrc Source Crossing Time [days] Time for the lens-source separation to change by one angular source radius (+) ml_xtimesrcerr1
(-) ml_xtimesrcerr2
ml_xtimesrclim
ml_efftime Effective Timescale [days] Effective timescale, equal to the product of the microlens impact parameter and the Einstein crossing time (+) ml_efftimeerr1
(-) ml_efftimeerr2
ml_efftimelim
ml_pms Source Proper Motion [mas/yr] Source system proper motion (+) ml_pmserr1
(-) ml_pmserr2
ml_pmslim


Top

Magnitude Columns


Database
Column Name
Table Label Description Uncertainties Column
(positive +)
(negative -)
Limit Column
ml_magvs Source V-band [mag] Brightness of the unmagnified source star, in V-band (+) ml_magvserr1
(-) ml_magvserr2
ml_magvslim
ml_magvso Source De-reddened V-band [mag] De-reddened brightness of the unmagnified source star, in V-band (+) ml_magvsoerr1
(-) ml_magvsoerr2
ml_magvsolim
ml_magiso Source De-reddened I-band [mag] De-reddened brightness of the unmagnified source star, in I-band (+) ml_magisoerr1
(-) ml_magisoerr2
ml_magisolim
ml_magjs Source J-band [mag] Brightness of the unmagnified source star, in J-band (+) ml_magjserr1
(-) ml_magjserr2
ml_magjslim
ml_magjso Source De-reddened J-band [mag] De-reddened brightness of the unmagnified source star, in J-band (+) ml_magjsoerr1
(-) ml_magjsoerr2
ml_magjsolim
ml_maghs Source H-band [mag] Brightness of the unmagnified source star, in H-band (+) ml_maghserr1
(-) ml_maghserr2
ml_maghslim
ml_maghso Source De-reddened H-band [mag] De-reddened brightness of the unmagnified source star, in H-band (+) ml_maghsoerr1
(-) ml_maghsoerr2
ml_maghsolim
ml_magks Source K-band [mag] Brightness of the unmagnified source star, in K-band (+) ml_magkserr1
(-) ml_magkserr2
ml_magkslim
ml_magkso Source De-reddened K-band [mag] De-reddened brightness of the unmagnified source star, in K-band (+) ml_magksoerr1
(-) ml_magksoerr2
ml_magksolim
ml_magibase Event Baseline I-band [mag] Brightness of all objects, including the unmagnified source star, superposed at the time of the event, in I-band (+) ml_magibaseerr1
(-) ml_magibaseerr2
ml_magibaselim
sy_vmag Lens V-band [mag] Brightness of the lens star, in V-band (+) sy_vmagerr1
(-) sy_vmagerr2
sy_vmaglim
sy_icmag Lens I-band [mag] Brightness of the lens star, in I-band (+) sy_icmagerr1
(-) sy_icmagerr2
sy_icmaglim
sy_jmag Lens J-band [mag] Brightness of the lens star, in J-band (+) sy_jmagerr1
(-) sy_jmagerr2
sy_jmaglim
sy_hmag Lens H-band [mag] Brightness of the lens star, in H-band (+) sy_hmagerr1
(-) sy_hmagerr2
sy_hmaglim
sy_kmag Lens K-band [mag] Brightness of the lens star, in K-band (+) sy_kmagerr1
(-) sy_kmagerr2
sy_kmaglim
ml_extvfld Line-of-sight V-Band Extinction [mag] Line-of-sight extinction toward the source system, in V-band (+) ml_extvflderr1
(-) ml_extvflderr2
ml_extvfldlim
ml_extifld Line-of-sight I-Band Extinction [mag] Line-of-sight extinction toward the source system, in I-band (+) ml_extiflderr1
(-) ml_extiflderr2
ml_extifldlim
ml_extjfld Line-of-sight J-Band Extinction [mag] Line-of-sight extinction toward the source system, in J-band (+) ml_extjflderr1
(-) ml_extjflderr2
ml_extjfldlim
ml_exthfld Line-of-sight H-Band Extinction [mag] Line-of-sight extinction toward the source system, in H-band (+) ml_exthflderr1
(-) ml_exthflderr2
ml_exthfldlim
ml_extkfld Line-of-sight K-Band Extinction [mag] Line-of-sight extinction toward the source system, in K-band (+) ml_extkflderr1
(-) ml_extkflderr2
ml_extkfldlim


Top

Color Columns

Database
Column Name
Table Label Description Uncertainties Column
(positive +)
(negative -)
Limit Column
ml_colvis Source (V-I) [mag] Color of the unmagnified source star, V minus I (+) ml_colviserr1
(-) ml_colviserr2
ml_colvislim
ml_mcolviso Source De-reddened (V-I) [mag] De-reddened color of the unmagnified source star, V minus I (+) ml_mcolvisoerr1
(-) ml_mcolvisoerr2
ml_mcolvisolim
ml_colvks Source (V-K) [mag] Color of the unmagnified source star, V minus K (+) ml_colvkserr1
(-) ml_colvkserr2
ml_colvkslim
ml_colvkso Source De-reddened (V-K) [mag] De-reddened color of the unmagnified source star, V minus K (+) ml_colvksoerr1
(-) ml_colvksoerr2
ml_colvksolim
ml_colihs Source (I-H) [mag] Color of the unmagnified source star, I minus H (+) ml_colihserr1
(-) ml_colihserr2
ml_colihslim
ml_colihso Source De-reddened (I-H) [mag] De-reddened color of the unmagnified source star, I minus H (+) ml_colihsoerr1
(-) ml_colihoserr2
ml_colihsolim
ml_colhks Source (H-K) [mag] Color of the unmagnified source star, H minus K (+) ml_colhkserr1
(-) ml_colhkserr2
ml_colhkslim
ml_colhkso Source De-reddened (H-K) [mag] De-reddened color of the unmagnified source star, H minus K (+) ml_colhksoerr1
(-) ml_colhkoserr2
ml_colhksolim
ml_colvibl Blend (V-I) [mag] Combined color of all objects, excluding the source star, superposed at the time of the event, V minus I (+) ml_colviblerr1
(-) ml_colviblerr2
ml_colvibllim
ml_redvi Line-of-sght Reddening E(V-I) [mag] Line-of-sight reddening toward the source system, E(V-I) (+) ml_redvierr1
(-) ml_redvierr2
ml_redvilim
ml_redvk Line-of-sight Reddening E(V-K) [mag] Line-of-sight reddening toward the source system, E(V-K) (+) ml_redvkerr1
(-) ml_redvkerr2
ml_redvklim
ml_redhk Line-of-sight Reddening E(H-K) [mag] Line-of-sight reddening toward the source system, E(H-K) (+) ml_redhkerr1
(-) ml_redhkerr2
ml_redhklim


Top

Model Columns

Database
Column Name
Table Label Description
ml_modelchisq Model Chi-squared Chi-squared of the microlens model selected as the best fit
cb_flag Circumbinary Flag Binary flag indicating whether lens system is a stellar binary (1=yes; 0=no)
ml_description Model Description Microlensing model description and notes




Last updated: 23 April 2021