Choose a database in the left panel then select the table you want!

(The bold columns are indexed columns)
Column NameDescriptionDatatype
b_totTotal fluxes in b filter. See survey paper for derivation detailDOUBLE
clusterName of the corresponding cluster, when there is an associated photometric catalogue. Objects in the COSMOS or SXDF photometric catalogues are identified with those labels, unless there is a GOGREEN spectroscopic redshift, in which case we use the name of the associated target. Note that SXDF49 and SXDF87 share a field, and are identified here only by SXDF49. Similarly SXDF76a and SXDF76b are identified here as SXDF76.VARCHAR(n)
cphotidThis is a unique identifier for each object in this table. The first digit identifies the source of the photometry (1: GOGREEN; 2: GCLASS; 3: UltraVISTA/COSMOS; 4:SPLASH/SXDF). The next two digits are the cluster_id column from Table 2. The remaining numbers are the PHOTID identifier in the main photometric cataloguesINTEGER
decJ2000 positions, in degrees. Calibrated with SDSS DR7 or USNO-b whenever a cluster falls outside of the SDSS footprint.DOUBLE
eb_totTotal fluxes in eb filter. See survey paper for derivation detailDOUBLE
efuv_totTotal fluxes in efuv filter. See survey paper for derivation detailDOUBLE
eg_totTotal fluxes in eg filter. See survey paper for derivation detailDOUBLE
eh_totTotal fluxes in eh filter. See survey paper for derivation detailDOUBLE
ei_totTotal fluxes in ei filter. See survey paper for derivation detailDOUBLE
eia484_totTotal fluxes in eia484 filter. See survey paper for derivation detailDOUBLE
eia527_totTotal fluxes in eia527 filter. See survey paper for derivation detailDOUBLE
eia624_totTotal fluxes in eia624 filter. See survey paper for derivation detailDOUBLE
eia679_totTotal fluxes in eia679 filter. See survey paper for derivation detailDOUBLE
eia738_totTotal fluxes in eia738 filter. See survey paper for derivation detailDOUBLE
eia767_totTotal fluxes in eia767 filter. See survey paper for derivation detailDOUBLE
eib427_totTotal fluxes in eib427 filter. See survey paper for derivation detailDOUBLE
eib464_totTotal fluxes in eib464 filter. See survey paper for derivation detailDOUBLE
eib505_totTotal fluxes in eib505 filter. See survey paper for derivation detailDOUBLE
eib574_totTotal fluxes in eib574 filter. See survey paper for derivation detailDOUBLE
eib709_totTotal fluxes in eib709 filter. See survey paper for derivation detailDOUBLE
eib827_totTotal fluxes in eib827 filter. See survey paper for derivation detailDOUBLE
eirac1_totTotal fluxes in eirac1 filter. See survey paper for derivation detailDOUBLE
eirac2_totTotal fluxes in eirac2 filter. See survey paper for derivation detailDOUBLE
eirac3_totTotal fluxes in eirac3 filter. See survey paper for derivation detailDOUBLE
eirac4_totTotal fluxes in eirac4 filter. See survey paper for derivation detailDOUBLE
ej_totTotal fluxes in ej filter. See survey paper for derivation detailDOUBLE
ek_totTotal fluxes in ek filter. See survey paper for derivation detailDOUBLE
eks_totTotal fluxes in eks filter. See survey paper for derivation detailDOUBLE
emips24_totTotal fluxes in emips24 filter. See survey paper for derivation detailDOUBLE
enuv_totTotal fluxes in enuv filter. See survey paper for derivation detailDOUBLE
er_totTotal fluxes in er filter. See survey paper for derivation detailDOUBLE
eu_totTotal fluxes in eu filter. See survey paper for derivation detailDOUBLE
ev_totTotal fluxes in ev filter. See survey paper for derivation detailDOUBLE
ey_totTotal fluxes in ey filter. See survey paper for derivation detailDOUBLE
ez_totTotal fluxes in ez filter. See survey paper for derivation detailDOUBLE
fuv_totTotal fluxes in fuv filter. See survey paper for derivation detailDOUBLE
g_totTotal fluxes in g filter. See survey paper for derivation detailDOUBLE
h_totTotal fluxes in h filter. See survey paper for derivation detailDOUBLE
htm9HTM index (order 9 => ~10 arcmin size)INTEGER
i_totTotal fluxes in i filter. See survey paper for derivation detailDOUBLE
ia484_totTotal fluxes in ia484 filter. See survey paper for derivation detailDOUBLE
ia527_totTotal fluxes in ia527 filter. See survey paper for derivation detailDOUBLE
ia624_totTotal fluxes in ia624 filter. See survey paper for derivation detailDOUBLE
ia679_totTotal fluxes in a679 filter. See survey paper for derivation detailDOUBLE
ia738_totTotal fluxes in ia738 filter. See survey paper for derivation detailDOUBLE
ia767_totTotal fluxes in ia767 filter. See survey paper for derivation detailDOUBLE
ib427_totTotal fluxes in ib427 filter. See survey paper for derivation detailDOUBLE
ib464_totTotal fluxes in ib464 filter. See survey paper for derivation detailDOUBLE
ib505_totTotal fluxes in ib505 filter. See survey paper for derivation detailDOUBLE
ib574_totTotal fluxes in ib574 filter. See survey paper for derivation detailDOUBLE
ib709_totTotal fluxes in ib709 filter. See survey paper for derivation detailDOUBLE
ib827_totTotal fluxes in ib827 filter. See survey paper for derivation detailDOUBLE
irac1_totTotal fluxes in irac1 filter. See survey paper for derivation detailDOUBLE
irac2_totTotal fluxes in irac2 filter. See survey paper for derivation detailDOUBLE
irac3_totTotal fluxes in irac3 filter. See survey paper for derivation detailDOUBLE
irac4_totTotal fluxes in irac4 filter. See survey paper for derivation detailDOUBLE
j_totTotal fluxes in j filter. See survey paper for derivation detailDOUBLE
k_flagSExtractor flag in the K -band.DOUBLE
k_totTotal fluxes in k filter. See survey paper for derivation detailDOUBLE
ks_totTotal fluxes in ks filter. See survey paper for derivation detailDOUBLE
mips24_totTotal fluxes in mips24 filter. See survey paper for derivation detailDOUBLE
mstellarTotal stellar masses, measured with the FAST (Kriek et al. 2009) code and assuming the best redshift for the object (spectroscopic or zphot). These assume τ-model star formation histories, and are known to underestimate the stellar mass obtained with a non-parametric star formation history, by up to 0.3 dex (Leja et al. 2019). For objects in COSMOS and SXDF the stellar masses are taken from their respective catalogues.DOUBLE
nest4096HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec sizeINTEGER
nuv_totTotal fluxes in nuv filter. See survey paper for derivation detailDOUBLE
r_totTotal fluxes in g filter. See survey paper for derivation detailDOUBLE
raJ2000 positions, in degrees. Calibrated with SDSS DR7 or USNO-b whenever a cluster falls outside of the SDSS footprint.DOUBLE
random_idRandom ID in the range 0.0 => 100.0REAL
redshift_qualityQuality flag for associated spectrum in zspecDOUBLE
ring256HEALPIX index (Nsides 256, Ring scheme => ~14 arcmin size)INTEGER
specidThe ID corresponding to Table 4 for objects with a corresponding GCLASS or GOGREEN spectrumINTEGER
starStar/galaxy classification based on colours, as described in van der Burg et al. (2020). Flag is 1 for a star, and 0 otherwise.DOUBLE
totmaskManual mask at position of detection, where objects are masked (totmask= 1) if they do not have an image in all available filters for that cluster. Only sources with totmask=0 are included in this compilation catalogue. Photometry for other sources must be obtained from the original catalogues.DOUBLE
u_totTotal fluxes in u filter. See survey paper for derivation detail.DOUBLE
uminvU - V, Rest-frame colours between Johnson U and V, as measured with EAZY (Brammer et al. 2008). Small offsets, as described in van der Burg et al. (2020), have been applied on a cluster-by-cluster basis to improve correspondence with UltraVISTA. For the COSMOS galaxies the rest-frame colours are from the UltraVISTA catalogue.DOUBLE
v_totTotal fluxes in v filter. See survey paper for derivation detailDOUBLE
vminj, Rest-frame colours between Johnson V and J, as measured with EAZY (Brammer et al. 2008). Small offsets, as described in van der Burg et al. (2020), have been applied on a cluster-by-cluster basis to improve correspondence with UltraVISTA. For the COSMOS galaxies the rest-frame colours are from the UltraVISTA catalogue.V - JDOUBLE
y_totTotal fluxes in y filter. See survey paper for derivation detailDOUBLE
z_totTotal fluxes in z filter. See survey paper for derivation detailDOUBLE
zphotPhotometric redshift from the 68 per cent confidence region. Based on the zpeak output from EAZY (Brammer et al. 2008), where for the GOGREEN galaxies a polynomial correction is applied to improve the correspondence with spectroscopy.DOUBLE
zphot_l68Photometric redshift loweri uncertainty for zphotDOUBLE
zphot_u68Photometric redshift upper uncertainty for zphotDOUBLE
zspecThe spectroscopic redshift for the associated spectrum, if any. (See redshift_quality for the quality flag). Redshifts without a corresponding Redshift_Quality are copied from the parent (UltraVISTA or SPLASH) catalogue.DOUBLE