http://voksenlia.net/spaceengine/RG_0-6-69455-197.db (uncompressed, 54MB)
http://voksenlia.net/spaceengine/RG_0-6-69455-197.db.bz2 (compressed, 12MB)
This is an sqlite3 database. It can be accessed running it with the sqlite3 commandline shell which can be downloaded from
sqlite.org.
The table definition is:
CREATE TABLE stars (name PRIMARY KEY, type TEXT, multiple INTEGER, spectrum TEXT, diameter FLOAT, mass FLOAT, luminosity FLOAT, temperature INTEGER, planets INTEGER, life INTEGER)
If you're unfamiliar with SQL, here are some sample queries:
(Get basic info on systems with more than 3 worlds with life)
sqlite> select name, multiple, planets, life from stars where life > 3;
RS 0-6-69455-197-950-7-1771407-2808|2|15|4
RS 0-6-69455-197-3145-8-2676708-709|2|15|4
RS 0-6-69455-197-3145-8-2685649420|2|14|4
RS 0-6-69455-197-3584-8-4235209-323|4|10|4
RS 0-6-69455-197-3600-9-78385751-6|2|13|5
(Show the top 5 systems with most stars:)
sqlite> select name, multiple from stars order by multiple desc limit 5;
RS 0-6-69455-197-1385-9-19224043-66|7
RS 0-6~69455-197-1389-7-494521-1033|7
RS 0-6-69455-197-1389--8-2904647-1095|7
RS 0-6-69455-197-1824-8-14321313-463|7
RS 0-6-69455-197-3147-8-14981032-92|7
(Show the top 5 planet rich systems:)
sqlite> select name, planets from stars order by planets desc limit 5;
RS 0-6-69455-197-950-8-S852848-9|111
RS 0-6-6945S-197-3147-8-14982892-33|90
RS 0-6-69455-197-3591-7-549122-2S8|53
RS 0-6-69455-197-3145-8-2901137-1143|30
RS 0-6-69455-197-3145-8~2901221-185|29
(Note that the three first entries are surely bogus.)
(Find the top 5 biggest systems which have "bright" in the star type:)
sqlite> select name, type, diameter, planets from stars where type like "%bright%" order by diameter desc limit 5;
RS 0-6-69455-197-2710-0-3-15|Red bright giant|1553873082.9609|3
RS 0-6-69455-197-2282-0-0-0|Red bright giant|1469499883.8861|4
RS 0-6-6945S-197-2282-0-0-0|Red bright giant|1469499883.8861|4
RS U-6-694SS-197-3588-U-U-11|Red bright giant|1437635537.427|6
RS 0-6-69455-197-3243-0-0-0|Red bright giant|1333066625.8077|4
(List the frequency of different multiple star systems:)
sqlite> select count(*) from stars where multiple = 7;
13
sqlite> select count(*) from stars where multiple = 6;
50
sqlite> select count(*) from stars where multiple = 5;
603
sqlite> select count(*) from stars where multiple = 4;
4568
sqlite> select count(*) from stars where multiple = 3;
25867
sqlite> select count(*) from stars where multiple = 2;
151144
sqlite> select count(*) from stars where multiple = 1;
182443