match_stats

1 row where match_id = 64698

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: created_at (date), updated_at (date)

match_stats_id ▼ match_id possession_home possession_away ppda_home ppda_away shots_home shots_away shots_on_target_home shots_on_target_away shots_blocked_home shots_blocked_away big_chances_home big_chances_away big_chances_missed_home big_chances_missed_away xg_home xg_away npxg_home npxg_away total_passes_home total_passes_away pass_accuracy_home pass_accuracy_away key_passes_home key_passes_away corners_home corners_away free_kicks_home free_kicks_away yellow_cards_home yellow_cards_away red_cards_home red_cards_away fouls_home fouls_away offsides_home offsides_away saves_home saves_away created_at updated_at created_by_run_id updated_by_run_id source_id source_raw_key
7369 64698     12.777777777777779 7.869565217391305 5 9 1 4             0.149649 1.27085 0.149649 1.27085             1 8     2 0 0 0 17 12         2026-06-11T16:07:49.340904 2026-06-11T19:03:36.356411 22 22 24 24 understat+footballdata 13  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE match_stats (
	match_stats_id INTEGER NOT NULL, 
	match_id INTEGER NOT NULL, 
	possession_home FLOAT, 
	possession_away FLOAT, 
	ppda_home FLOAT, 
	ppda_away FLOAT, 
	shots_home INTEGER, 
	shots_away INTEGER, 
	shots_on_target_home INTEGER, 
	shots_on_target_away INTEGER, 
	shots_blocked_home INTEGER, 
	shots_blocked_away INTEGER, 
	big_chances_home INTEGER, 
	big_chances_away INTEGER, 
	big_chances_missed_home INTEGER, 
	big_chances_missed_away INTEGER, 
	xg_home FLOAT, 
	xg_away FLOAT, 
	npxg_home FLOAT, 
	npxg_away FLOAT, 
	total_passes_home INTEGER, 
	total_passes_away INTEGER, 
	pass_accuracy_home FLOAT, 
	pass_accuracy_away FLOAT, 
	key_passes_home INTEGER, 
	key_passes_away INTEGER, 
	corners_home INTEGER, 
	corners_away INTEGER, 
	free_kicks_home INTEGER, 
	free_kicks_away INTEGER, 
	yellow_cards_home INTEGER, 
	yellow_cards_away INTEGER, 
	red_cards_home INTEGER, 
	red_cards_away INTEGER, 
	fouls_home INTEGER, 
	fouls_away INTEGER, 
	offsides_home INTEGER, 
	offsides_away INTEGER, 
	saves_home INTEGER, 
	saves_away INTEGER, 
	created_at DATETIME NOT NULL, 
	updated_at DATETIME NOT NULL, 
	created_by_run_id INTEGER, 
	updated_by_run_id INTEGER, 
	source_id INTEGER NOT NULL, 
	source_raw_key VARCHAR(512), 
	PRIMARY KEY (match_stats_id), 
	FOREIGN KEY(match_id) REFERENCES "match" (match_id), 
	FOREIGN KEY(created_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(updated_by_run_id) REFERENCES ingestion_run (run_id), 
	FOREIGN KEY(source_id) REFERENCES data_source (source_id)
);
CREATE INDEX ix_match_stats_source_id ON match_stats (source_id);
CREATE INDEX ix_match_stats_created_by_run_id ON match_stats (created_by_run_id);
CREATE INDEX ix_match_stats_updated_by_run_id ON match_stats (updated_by_run_id);
CREATE INDEX ix_match_stats_source_raw_key ON match_stats (source_raw_key);
CREATE UNIQUE INDEX ix_match_stats_match_id ON match_stats (match_id);