In the era of "big data" and with the advent of web 2.0 technologies, ESASky (http://sky.esa.int) aims at providing a modern and visual way to access astronomical science-ready data products and metadata. The main goal of the application is to simplify the interaction between the scientific community and the ever-growing amount of data collected over the past decades from the most important astronomy missions. The ESASky concept is to offer a complementary scientific application to the more-traditional table-oriented exploitation of astronomical data, by allowing a more natural and visual approach and enabling the exploration of astronomical objects across the entire electromagnetic spectrum. To fulfill this goal, ESASky provides a multiwavelength interface to a set of astronomy data from an increasing number of missions and surveys, with the intention of becoming the single-point of entry to perform visual analysis and cross-matching among different energy ranges. A lot of effort has been invested on the design of a user-friendly, responsive Graphical User Interface (GUI) by the definition and optimisation of algorithms running behind each visual feature offered. In this contribution, we describe in detail the design and solutions adopted for the technical challenges arising during the development. We present the data services and features implemented in the latest version of ESASky (v2.1), including a Mission Planning Tool to support current James Webb Space Telescope (JWST) planning, the possibility to search for observations of Solar System Objects (planets, comets and moons) taken by astronomy missions, the integration of the SAO/NASA Astrophysics Data System (ADS) publication system in the ESASky GUI, and the retrieval of metadata and data products available within a specific region of the sky.

We present 27 new L subdwarfs and classify five of them as esdL and 22 as sdL. Our L subdwarf candidates were selected with the UKIRT Infrared Deep Sky Survey and Sloan Digital Sky Survey. Spectroscopic follow-up was carried out primarily with the OSIRIS spectrograph on the Gran Telescopio Canarias. Some of these new objects were followed up with the X-shooter instrument on the Very Large Telescope. We studied the photometric properties of the population of known L subdwarfs using colour-spectral type diagrams and colour-colour diagrams, by comparison with L dwarfs and main-sequence stars, and identified new colour spaces for L subdwarf selection/study in current and future surveys. We further discussed the brown dwarf transition-zone and the observational stellar/substellar boundary. We found that about one-third of 66 known L subdwarfs are substellar objects, with two-thirds being very low-mass stars. We also present the Hertzsprung-Russell diagrams, spectral type-absolute magnitude corrections, and tangential velocities of 20 known L subdwarfs observed by the Gaia astrometry satellite. One of our L subdwarf candidates, ULAS J233227.03+123452.0, is a mildly metal-poor spectroscopic binary brown dwarf: a ~L6p dwarf and a ~T4p dwarf. This binary is likely a thick disc member according to its kinematics.

We report the discovery of an esdL3 subdwarf, ULAS J020858.62+020657.0, and a usdL4.5 subdwarf, ULAS J230711.01+014447.1. They were identified as L subdwarfs by optical spectra obtained with the Gran Telescopio Canarias, and followed up by optical-to-near-infrared spectroscopy with the Very Large Telescope. We also obtained an optical-to-near-infrared spectrum of a previously known L subdwarf, ULAS J135058.85+081506.8, and reclassified it as a usdL3 subdwarf. These three objects all have typical halo kinematics. They have $T_{\rm eff}$ around 2050$-$2250 K, $-$1.8 $\leq$ [Fe/H] $\leq -$1.5, and mass around 0.0822$-$0.0833 M$_{\odot}$, according to model spectral fitting and evolutionary models. These sources are likely halo transitional brown dwarfs with unsteady hydrogen fusion, as their masses are just below the hydrogen-burning minimum mass, which is $\sim$ 0.0845 M$_{\odot}$ at [Fe/H] = $-$1.6 and $\sim$ 0.0855 M$_{\odot}$ at [Fe/H] = $-$1.8. Including these, there are now nine objects in the `halo brown dwarf transition zone', which is a `substellar subdwarf gap' that spans a wide temperature range within a narrow mass range of the substellar population.

SONYC -- Substellar Objects in Nearby Young Clusters -- is a survey program to investigate the frequency and properties of substellar objects in nearby star-forming regions. We present a new imaging and spectroscopic survey conducted in the young (~1 Myr), nearby (~200 pc) star-forming region Lupus 3. Deep optical and near-infrared images were obtained with MOSAIC-II and NEWFIRM at the CTIO-4m telescope, covering ~1.4 sqdeg on the sky. The i-band completeness limit of 20.3 mag is equivalent to 0.009-0.02 MSun, for Av \leq 5. Photometry and 11-12 yr baseline proper motions were used to select candidate low-mass members of Lupus 3. We performed spectroscopic follow-up of 123 candidates, using VIMOS at the Very Large Telescope (VLT), and identify 7 probable members, among which 4 have spectral type later than M6.0 and Teff \leq 3000K, i.e. are probably substellar in nature. Two of the new probable members of Lupus 3 appear underluminous for their spectral class and exhibit emission line spectrum with strong Halpha or forbidden lines associated with active accretion. We derive a relation between the spectral type and effective temperature: Teff=(4120 +- 175) - (172 +- 26) x SpT, where SpT refers to the M spectral subtype between 1 and 9. Combining our results with the previous works on Lupus 3, we show that the spectral type distribution is consistent with that in other star forming regions, as well as is the derived star-to-BD ratio of 2.0-3.3. We compile a census of all spectroscopically confirmed low-mass members with spectral type M0 or later.