Tools and Research

The NASA Exoplanet archive can be accessed using sql queries via their TAP interface.
I use several queries to update Habitable Zone Exoplanet Visualizer.

Query 1 searches the PS database for exoplanets within the distance of the first radio broadcast by Marconi on May 13, 1897 (with a 5% buffer) and within an estimated Habitable Zone of the host star (.9 to 1.67 AUs of adjusted host luminosity).
View PS table Exoplanet Query

Query 2 searches the PSComps database for exoplanets using the same criteria as query 1.
View PScomps Exoplanet Query

Query 3 returns the number of systems reached by human radio communication based on the distance from Earth. It is used to calculate the corresponding column at the bottom of the Habitable Exoplanet Visualizer. The distances are calculated in real-time using the dates on the table.
View Query

Selected Research:
×

SQL Query

This query retrieves data from the database:


        
        Copied!