Full table, first 1000 rows

SELECT TOP 1000 *
FROM einsteinprobe.obscore_extended

EP FXT level 2 data

SELECT *
FROM einsteinprobe.obscore_extended
WHERE instrument_name = 'FXT'
AND calib_level = '2'

Cone search on the NGC 247

SELECT *
FROM einsteinprobe.obscore a
WHERE INTERSECTS(CIRCLE('ICRS',11.7856,-20.7604,0.5),
    CIRCLE('ICRS', a.s_ra, a.s_dec, 0.5)) = 1
AND (a.instrument_name = 'FXT' OR a.instrument_name = 'WXT')
ORDER by a.obs_id ASC
        

All EP FXT light curves

SELECT *
FROM einsteinprobe.obscore_extended
WHERE instrument_name = 'FXT'
AND dataproduct_type = 'timeseries'
        

Query by time range

SELECT *
FROM einsteinprobe.fxt_product
WHERE utc_t_start >= '2024-09-01T00:00:00'
AND utc_t_stop <  '2024-10-01T00:00:00'
        

All EP FXT metadata

SELECT TOP 1000 o.*, f.*
FROM einsteinprobe.obscore_extended AS o
JOIN einsteinprobe.fxt_product AS f
    ON o.filename = f.filename
WHERE o.instrument_name = 'FXT'
ORDER BY o.obs_id ASC