Skip to content

Spl3 - CSV Schema - Battle

AIZAWA Hina edited this page Oct 26, 2023 · 10 revisions

This is a schema information for results data that can download from https://stat.ink/downloads .
The files are updated between approximately 0:00 UTC and 3:00 UTC.

  • The CSV is encoded in UTF-8 and may contain Japanese, Chinese, Korean or Cyrillic characters.
  • If line starts with #, the line is a comment.
  • A, alpha, our are "Good Guys" and B, bravo, their are "Bad Guys".
    • The A1 is a stat.ink user (posted the battle). If you use this player's result, statistics may not be correct.
      A1はstat.inkの投稿者です。このプレーヤーを含めて統計情報を作成した場合、ブキの使用数などを過大に見積もることになります。
  • Private battles and Tricolor battles are not output.
  • Battles with disconnected players are not output.
  • Surprisingly, there are columns where JSON is stored. If you do not use an appropriate parser, you can't read the CSV correctly.

CSV Schema

Column # Column Name Type Example Meaning
0 season string Chill Season 2022
1 period datetime 2022-12-26T02:00:00+00:00 Indicates which period (2 hours window) is.
2 game-ver string 2.0.1
3 lobby key-string bankara_open regular: Regular
bankara_challenge: Anarchy (Series)
bankara_open: Anarchy (Open)
xmatch: X Battle
splatfest_challenge: Splatfest (Pro)
splatfest_open: Splatfest (Open)
event: Challenge
4 mode key-string yagura nawabari: Turf War
area: Splat Zones
yagura: Tower Control
hoko: Rainmaker
asari: Clam Blitz
5 stage key-string masaba https://stat.ink/api-info/stage3
6 time integer 308 Time length of the battle (seconds)
7 win alpha|bravo alpha Which team won
8 knockout boolean FALSE
9 rank string S C-...S, S+, S+ 0...S+ 50
10 power decimal 2345.6 Anarchy Power, Challenge Power, Splatfest Power or X Power
11 alpha-inked integer 3667 Turf War result
12 alpha-ink-percent decimal 40.2 Turf War result
13 alpha-count integer 81 Ranked-mode result
14 alpha-color color (rrggbbaa) d0bf08ff
15 alpha-theme localized-string ほのお Splatfest team name
16 bravo-inked integer
17 bravo-ink-percent decimal
18 bravo-count integer
19 bravo-color color (rrggbbaa)
20 bravo-theme localized-string
21 A1-weapon key-string wakaba Player "Alpha-1" weapon
https://stat.ink/api-info/weapon3
22 A1-kill-assist integer 12 Kills + assists
23 A1-kill integer 12 Kills
24 A1-assist integer 0 Assists
25 A1-death integer 3 Deaths
26 A1-special integer 5 Special uses
27 A1-inked integer 1062 Turf inked
28 A1-abilities JSON {...} Gear abilities. See "Abilities JSON" below.
29 A2-weapon key-string
30 A2-kill-assist integer
31 A2-kill integer
32 A2-assist integer
33 A2-death integer
34 A2-special integer
35 A2-inked integer
36 A2-abilities JSON
37 A3-weapon key-string
38 A3-kill-assist integer
39 A3-kill integer
40 A3-assist integer
41 A3-death integer
42 A3-special integer
43 A3-inked integer
44 A3-abilities JSON
45 A4-weapon key-string
46 A4-kill-assist integer
47 A4-kill integer
48 A4-assist integer
49 A4-death integer
50 A4-special integer
51 A4-inked integer
52 A4-abilities JSON
53 B1-weapon key-string
54 B1-kill-assist integer
55 B1-kill integer
56 B1-assist integer
57 B1-death integer
58 B1-special integer
59 B1-inked integer
60 B1-abilities JSON
61 B2-weapon key-string
62 B2-kill-assist integer
63 B2-kill integer
64 B2-assist integer
65 B2-death integer
66 B2-special integer
67 B2-inked integer
68 B2-abilities JSON
69 B3-weapon key-string
70 B3-kill-assist integer
71 B3-kill integer
72 B3-assist integer
73 B3-death integer
74 B3-special integer
75 B3-inked integer
76 B3-abilities JSON
77 B4-weapon key-string
78 B4-kill-assist integer
79 B4-kill integer
80 B4-assist integer
81 B4-death integer
82 B4-special integer
83 B4-inked integer
84 B4-abilities JSON
85 medal1-grade gold|silver gold
86 medal1-name string #1 Overall Splatter The English version of the name will be output as much as possible, but localized name may be output.
List of known medals
87 medal2-grade gold|silver
88 medal2-name string
87 medal3-grade gold|silver
88 medal3-name string
89 event string "New Season Challenge" Challenge name

Abilities JSON

{
  "ink_recovery_up": 1.6,
  "quick_respawn": 1,
  "ink_saver_main": 0.3,
  "run_speed_up": 0.3,
  "special_saver": 0.3,
  "swim_speed_up": 0.3,
  "drop_roller": true
}

The value indicates how many main-equivalent effects are achieved (a.k.a. "5.7 format"). The maximum is typically 5.7.
The main-only ability such as Ninja Squid, set to true.

See also https://stat.ink/api-info/ability3