Open Data & Research Portal

Raw Dataset Bulk Exports

Download structured historical archives recorded across Eternal Lands. All datasets are streamed directly from the database and optimized for analysis with Python (Pandas / Polars), R, Jupyter Notebooks, Excel, or local SQL / SQLite databases.

← Back to Analytics Dashboard API Documentation →
7 Complete Datasets
CSV & JSON Streaming Formats
UTF-8 + BOM Excel & Python Ready

Download Center

Available Datasets

No Authentication Required (Open Data)

Click on CSV or JSON to download the full dataset stream directly.

EL Daily Lottery History

719 records

Winner names, dates, and won gold amounts across all recorded draws.

Columns: idlottery, lotterydate, winner, amount
Endpoint: /analytics/export/lottery

Special Days History

19,624 records

Complete log of special days, day descriptions, game dates, and donors.

Columns: idSpecialDay, spdaydate, gamedate, donatedby, specialday_text
Endpoint: /analytics/export/specialdays

Invance Raids

6,827 records

Level brackets (40-60 up to 145-200), timestamps, and game dates.

Columns: idinvance, invancedate, gamedate, level
Endpoint: /analytics/export/invances

Pear Finder Broadcasts

15,897 records

Timestamped player announcements of finding pears throughout Draia.

Columns: idmodmessages, timestamp, gametime, message
Endpoint: /analytics/export/pears

Joker Encounters & Rewards

7,619 records

Joker finder records with player names and items rewarded.

Columns: idmodmessages, timestamp, gametime, message
Endpoint: /analytics/export/jokers

GIWS & Invasion Alerts

16,669 records

Global Invasion Warning System logs, monster spawn locations, and end alerts.

Columns: idmodmessages, timestamp, gametime, message
Endpoint: /analytics/export/invasions

Moderator & Server Broadcasts

Historical server and moderator notices, excluding pear/joker messages.

Columns: idmodmessages, timestamp, gametime, message
Endpoint: /analytics/export/announcements

Developers & Data Science

Export Query Filters & Code Snippets

GET Query Parameters

All dataset export endpoints accept optional query parameters for filtered analyses or subsets:

Parameter Type Default Description
format string csv Output format: csv (compatible with Excel & Pandas) or json (array of objects).
limit integer 50000 Maximum records to stream (range: 1 to 100,000).
year integer all Filters historical events by calendar year (e.g. year=2025).

Python / Pandas Example

import pandas as pd

# Load lottery history stream directly into a DataFrame
url = "http://mercator.holy-eternalland.de/analytics/export/lottery?format=csv?year=2025"
df = pd.read_csv(url)

print(df.info())
print(df.describe())

cURL / Shell Example

# Stream Special Days as JSON
curl -s "http://mercator.holy-eternalland.de/analytics/export/specialdays?format=json?limit=10000" \
     -o specialdays.json

# Fetch aggregated analytical summary JSON
curl -s "http://mercator.holy-eternalland.de/api/analytics/summary" | jq .