New query

Query Builder

The form below is a builder for SQL SELECT queries on the ZTF database of objects. If you are logged in to Lasair, you can name and save your query, share it with others, run it in real-time as alerts come in, and have results kept for you or pushed to you. First you pick the tables to be joined for your query. The "objects" table is mandatory.


First pick your tables: ("objects" is mandatory)
objects sherlock_classifications crossmatch_tns
Watchlist
    __TNS__, ID=1
    BL Lac for TeV, ID=35
    AM CVn, ID=58
    AM Her, ID=118
    Milliquas_1000000, ID=137
    E+A galaxies, ID=139
    Gaia DR2 white dwarfs, ID=147
    Cataclysmic Variables, ID=226 (inactive)
    BL Lac for TeV, ID=235 (inactive)
    AM CVn, ID=258
    AM Her, ID=318
    Stripe82 AGN, ID=355
    Abell Clusters, ID=398
    Giant Binaries, ID=399
    IPs, ID=400
    HPM, ID=515 (inactive)
    E+A galaxies, ID=521
    Strong Lensing, ID=565
    TAOE sample IAC80 2 Oct 2021, ID=595
    V1117 Her Deep Fade, ID=624
    PR Her in outburst, ID=632
    Change_Me_281, ID=642
    Change_Me_61, ID=643
    Change_Me_71, ID=645
    BASS_BZ_AGN, ID=830
    BASS_nonBZ_AGN, ID=833
    BASS_Sy1_AGN, ID=836
    BASS_Sy1215_AGN, ID=839
    BASS_Sy2_AGN, ID=842
    BASS_Sy1819_AGN, ID=845
    TAOE 2022, ID=878
    TAOE 2022, 7 Nov. 2022, ID=887
Area
    SDSS, ID=2
    Rectangle, ID=3
    GW170817, ID=4
Annotator
    alerce_lc
    alerce_stamp
    fastfinder
    fink_early_sn
    test
SELECT clause here. Which attributes to return? See list at right. The SQL WHERE. Which objects to return. See list at right.
LIMIT
OFFSET
 
Click on the table name to see the schema:

objects

sherlock_classifications

crossmatch_tns

annotations


Check this box for JSON output