Level 200 characters in MapleLegends

This is a data visualization of level 200 characters in MapleLegends, an old-school MapleStory private server started in 2015. This dataset was scraped from the ranking page. Only characters that have made it to level 200, the max level in the game, are included in the ranking table. The leveling table includes the leveling history of each of the characters in the ranking.

Find the source code here. See this notebook for exploratory analysis on the data. The compiled SQLite database can be directly queried within the browser via SQL.js in the editor tab. Visualizations are rendered from the database using Plotly.

Here are direct links to the JSON and SQLite datasets, last updated on 2021-01-01.

• ranking.json
• leveling.json
• ranking.db

Take me to the homepage.

• Dashboard
• Editor
• Notes

xxxxxxxxxx

select

  job,

  count(distinct name) as count

from

  ranking

group by

  job

order by

  count desc

xxxxxxxxxx

with latest as (

  select

    name,

    timestamp as latest_timestamp

  from

    leveling

  where

    level = 200

),

earliest as (

  select

    name,

    min(level) as level,

    min(timestamp) as earliest_timestamp

  from

    leveling

  group by

    name

),

ages as (

  select

    name,

    round(

      date_diff_js(latest_timestamp, earliest_timestamp, "days")

    ) as age_days

  from

    latest

    join earliest using (name)

  where

    level = 2

)

select

  age_days

from

  ages

xxxxxxxxxx

SELECT

  month_js(timestamp) as month,

  count(distinct name) as count

FROM

  leveling

WHERE

  level = 200

GROUP BY

  month

ORDER BY

  month

xxxxxxxxxx

with extracted as (

  select

    name,

    level,

    timestamp,

    lag(timestamp) over (

      partition by name

      order by

        timestamp asc

    ) as prev_timestamp

  from

    leveling

)

select

  level,

  date_diff_js(timestamp, prev_timestamp, "hours") as gap

from

  extracted

where

  prev_timestamp is not null