datasets real and made-up data to practise on

Datasets

Data for the Playground, Database Lab and Performance Lab. Pick one and open its files.

dataset

size

Every confirmed planet outside the solar system, with its orbit, size, mass and host star.

260 planets1 tableJan 1992 – Oct 2026

what to watch for

Tricky rows

Planets with no radius estimate1 rows
Planets whose host star has no age80 rows
Planet rows whose host-star values differ from another planet of the same star2 rows

files

Open a file to see what one row means, its columns and a preview. Open in Playground starts a new file there with code that loads it.

planets260 rows · 28 columns · CSV

One confirmed exoplanet, with facts about the star it orbits.

In your code: data/planets.csv

pl_nametextkey
Planet name
hostnametext
Host star name
sy_snuminteger · can be empty
Number of stars in the system
sy_pnuminteger · can be empty
Number of known planets in the system
discoverymethodtext
How the planet was found (Transit, Radial Velocity, …)
disc_yearinteger · can be empty
Year of discovery
disc_facilitytext · can be empty
Observatory or mission that found it
disc_telescopetext · can be empty
Telescope used
pl_orbperdecimal · can be empty
Orbital period, days
pl_orbsmaxdecimal · can be empty
Average distance from its star, astronomical units (Earth = 1)
pl_radedecimal · can be empty
Planet radius, Earth radii
pl_radjdecimal · can be empty
Planet radius, Jupiter radii
pl_bmassedecimal · can be empty
Planet mass (or minimum mass), Earth masses
pl_bmassjdecimal · can be empty
Planet mass (or minimum mass), Jupiter masses
pl_orbeccendecimal · can be empty
Orbital eccentricity (0 = circular)
pl_insoldecimal · can be empty
Light received, relative to Earth (Earth = 1)
pl_eqtdecimal · can be empty
Estimated temperature, kelvin
st_spectypetext · can be empty
Host star spectral type
st_teffdecimal · can be empty
Host star temperature, kelvin
st_raddecimal · can be empty
Host star radius, solar radii
st_massdecimal · can be empty
Host star mass, solar masses
st_metdecimal · can be empty
Host star metallicity, dex
st_agedecimal · can be empty
Host star age, billions of years
st_lumdecimal · can be empty
Host star luminosity, log10 of the Sun’s
radecimal · can be empty
Right ascension, degrees
decdecimal · can be empty
Declination, degrees
sy_distdecimal · can be empty
Distance from Earth, parsecs
sy_vmagdecimal · can be empty
Brightness of the system in V band (magnitude; smaller is brighter)