SQL access to data

| HyperLeda home | Documentation | Search by name | Search near a position | Define a sample | SQL Search |

Query:

Note that the output of a query may be large (Gigabytes) and may overflow the capacity of your client, in particular if it is a web browser. We advise you to check carefully your query.

Click here to have the list of astrophysical parameters and here for explanations about their computation.

Examples:

• SELECT objname, al2000, de2000 FROM a000 WHERE de2000>76 and al2000<1
• SELECT al2000, de2000, hl_names(pgc) FROM a000 WHERE objname=objname('m31')
• SELECT * FROM a000 WHERE de2000>88 and objtype='G'
• SELECT objname, type, bt, logd25 FROM a000 WHERE bt<10
• SELECT count(*) FROM a000 WHERE bt<15 or logd25>1.0
• SELECT objname, celposJ(pgc), bar FROM a000 WHERE bar IS NOT NULL
• SELECT pgc, hl_names(pgc) FROM a000 WHERE de2000>88 ORDER BY al2000
• Compute H0 from M31 sosies [explanations]