Versions Compared

Old Version 9

changes.mady.by.user Former user

Saved on

compared with

New Version Current

changes.mady.by.user Wojciech Augustyn

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Statistics

Lista statystyk z podziałem na wyniki (results) i statystyki (stats). Kolumna Type może przyjmować wartości: team (jeśli statystyka dotyczy drużyny), person (jeśli statystyka dotyczy osoby) lub team_and_person jeśli statystyki dotyczy obu jednocześnie. Kolumna Show on list określa czy statystyka jest dostępna dla klienta, czy jest tylko wewnętrzna statystyka (show_on_list=no). Kolumna filter type określa jakiego typu pole należy wypełnić wpisując tę statystykę (dostępne wartości: text, checkbox, select)

...

Stats ID (IT)

...

Stats name

...

Column name (IT)

...

Type

...

Subtype

...

Scope name

...

Show on list

...

Sort order

...

Filter type

...

The complete list of statistics for events in handball is listed below.

Id

Name

Type

Data format

Description

701

Captain

person

binary


40

Goal

team and person

 

integer

 22Foulsfouls


19

yes1text

Total shots

team and person

integer


20

Shots on target

team and person

 

integer

 


21

yes2text40Goalsgoalsperson  yes3text123Offensive foulsoffensive_fouls

Shots off target

team and person

integer


29

Goalkeeper saves

team and person

integer


481

Penalties

team and person

integer


121

Penalty goals

team and person

 

integer

 15Penalties missedpenalty_missed


15

yes4text

Penalties missed

team and person

integer


122

2min. suspensions

team and person

 

integer

 


22

yes

Fouls

5

team and person

text

integer

121


123

Penalty goalspenalty_goals

Offensive fouls

team and person

 

integer

 text


8

yes6

Yellow cards

team and person

integer


9

Red cards

red_

team and person

integer


593

Blue cards

team and person

  yes7text21Shots off targetshots_off_goal

integer


35

Appearance

person

binary


470

Power play

team

integer


72

Turnovers

team and person

 

integer

 


626

yes

Players in play

8

team

textshots_on_goal

integer

20Shots on target


637

Goals conceded

team and person

 

integer

 29Shots savedshots_savedteam  yes10text19Total shotstotal_shots


638

yes9text

Throws efficiency

team and person

decimal


639

Penalties saved

team and person

integer


640

Penalties efficiency

team and person

decimal


641

9 meter total throws

team and person

 8Yellow cardsyellow_cards

integer

 yes11text


642

9 meter throws off target

team and person

integer


643

9 meter goals

team and person

 
Standings Id (IT)
Standings type
Subtype
Column name
Column description75Away standingsstandings       

Away matches played

 Away won Away draw Away lost Away goals difference Away goals scored Away goals allowed Away points Away form 23Form tableform

Form

 Last Matches 76Halftime standingsstandings

Matches played

 Won - 1st half Draw - 1st half Lost - 1st half Goals difference - 1st half Goals scored - 1st half Goals allowed - 1st half Points - 1st half 74Home standings 

Home matches played

 Home won Home draw Home lost Home goals difference Home goals scored Home goals allowed Home points Home form 73League standingsstandings

Matches played

 Won Draw Goals scored Lost Goals allowed Goals difference Points Form Last Matches 40Most popular resultsstandings

Result

 Amount Percentage 56Overall statsoverall_stats

Matches scheduled

 Matches played Home won Home won percentage Draw Draw percentage Away won Away won percentage Goals scored Home goals scored Away goals scored Average goals scored Home average goals scored Away average goals scored Average goals scored - 1st half Average goals scored - 2nd half Average goals allowed 48Streaksstandings

Wins

 Draws Losses No wins No draws No losses 95
Team overall stats
overall_stats

Matches scheduled

 Matches played Won Won percentage Draw Draw percentage Lost Lost percentage Home won Home won percentage Home draw Home lost Away won Away won percentage Away draw Away lost Goals scored Home goals scored Home average goals scored Away goals scored Average goals scored Away average goals scored Average goals scored - 1st half Average goals scored - 2nd half Percentage 72Wide standingsstandings

Matches played

 Won Draw Lost Goals difference Goals scored Goals allowed Points Form Home matches played Home won Home draw Home lost Home goals difference Home goals scored Home goals allowed Home points Home form Away matches played Away won Away draw Away lost Away goals difference Away goals scored Away goals allowed Away points Away form Last Matches Percentage 

integer

 yes12text

 

Standings

W kolumnie Create type określamy sposób tworzenia tabel (manual - dla tabel, które będą tworzone ręcznie), a auto_create dla tabel tworzonych automatycznie. W kolumnie Standings type wpisujemy typ tabeli np:

'standings','under_over','form','overall_stats', 'event_standings'. W kolumnie Columns opisujemy, jakie kolumny zawiera tabela, a w kolumnie Order rules/Sources podajemy sposób sortowania tabel, a dla tabel tworzonych ręcznie również źródło danych.


644

9 meter throws saved

team and person

integer


645

9 meter throws efficiency

team and person

decimal


646

6 meter ground throws

team and person

integer


647

6 meter ground throws

team and person

integer


648

6 meter ground goals

team and person

integer


649

6 meter ground throws saved

team and person

integer


650

6 meter ground throws efficiency

team and person

decimal


651

6 meter air throws

team and person

integer


652

6 meter air throws missed

team and person

integer


653

6 meter air goals

team and person

integer


654

6 meter air throws saved

team and person

integer


655

6 meter air throws efficiency

team and person

decimal


656

6 meter wings throws

team and person

integer


657

6 meter wings throws missed

team and person

integer


658

6 meter wings goals

team and person

integer


659

6 meter wings throws saved

team and person

integer


660

6 meter wings throws efficiency

team and person

decimal


661

6 meter total throws

team and person

integer


662

6 meter throws efficiency

team and person

decimal


663

Fast attack goals

team and person

integer


664

Fast attack unsuccessful

team and person

integer


665

Total fast attacks

team and person

integer


666

Fast attack efficiency

team and person

decimal


667

Successful blocks

team and person

integer


668

Fouls causing penalty

team and person

integer


669

Top left goals

team and person

integer


670

Top center goals

team and person

integer


671

Top right goals

team and person

integer


672

Bottom left goals

team and person

integer


673

Bottom center goals

team and person

integer


674

Bottom right goals

team and person

integer


675

Top left goals conceded

team and person

integer


676

Top center goals conceded

team and person

integer


677

Top right goals conceded

team and person

integer


678

Bottom left goals conceded

team and person

integer


679

Bottom center goals conceded

team and person

integer


680

Bottom right goals conceded

team and person

integer


681

Goals 1-10m

team and person

integer


682

Goals 11-20m

team and person

integer


683

Goals 21-30m

team and person

integer


684

Goals 31-40m

team and person

integer


685

Goals 41-50m

team and person

integer


686

Goals 51-60m

team and person

integer


687

Goals conceded 1-10m

team and person

integer


688

Goals conceded 11-20m

team and person

integer


689

Goals conceded 21-30m

team and person

integer


690

Goals conceded 31-40m

team and person

integer


691

Goals conceded 41-50m

team and person

integer


692

Goals conceded 51-60m

team and person

integer


693

Number of injuries

team and person

integer


694

Goalkeeper goals

team and person

integer


695

Goalkeeper efficiency

team and person

decimal


696

6 meter goals

team and person

integer


697

Penalties unsuccessful

team and person

integer


698

Time stopping incidents

team and person

integer


699

Goalkeeper penalties efficiency

team and person

decimal


700

Penalty goals conceded

team and person

integer


41

Assists

team and person

integer


832

Goals lost after turnover

team

integer


833

Number of fast attacks

team

integer


834

No goal fast attacks

team

integer


835

Goals after fast attack

team and person

integer


836

Empty net goals

team and person

integer


471

Empty net

team

integer


718

Skin

team

integer


70

Steals

team and person

integer

1214

Wing goals

team and person

integer

1215

Wing total throws

team and person

integer

1216

Wing goals efficiency

team

decimal

1384

6 meter throws saved

team and person

integer

1385

6 meter throws missed

team and person

integer