match_stats

10,051 rows where updated_by_run_id = 24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: shots_on_target_home, shots_on_target_away, corners_home, corners_away, yellow_cards_home, yellow_cards_away, red_cards_home, red_cards_away, fouls_home, created_by_run_id, created_at (date), updated_at (date)

Next page

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);