Welcome to the Hawk Haven

The aim of the Haven is to keep you up to date on all things AFL / Hawthorn from a statistical perspective.

The SQL database has over 4,500 games, stretching all the way back to the 2000 season.

Next game Mar 7th 19:40 vs Swa (@SCG) in 49 days.

"Place" Thu Dec 19th, 2024.

"Placeholder" Tue Dec 10th, 2024.

placed

"Versus Streaks" Fri Dec 6th, 2024.

Finally got Streaks working in the new Database; ie. team vs opponent = '3W'.

It took a little getting my head around - but it's a lot easier with the new version of SQL.

So here goes, from a single SELECT statement;

Big List of Streaks:

#	TeamTeam	Blu SStreak	Bom SStreak	Bul SStreak	Cat SStreak	Cro SStreak	Dem SStreak	Doc SStreak	Eag SStreak	Gia SStreak	Haw SStreak	Kan SStreak	Lio SStreak	Mag SStreak	Pow SStreak	Sai SStreak	Sun SStreak	Swa SStreak	Tig SStreak
1	Blu	-	W1	L2	W1	L3	W3	W3	W4	L1	L1	W4	L1	L2	L1	L1	W3	L1	W2
2	Bom	L1	-	W1	L7	L1	L1	W1	W4	W1	W4	W11	L2	W1	L8	L1	L2	L3	W2
3	Bul	W2	L1	-	W1	L1	W1	W1	W1	W2	L3	W7	L1	W1	L4	W1	W1	W1	W3
4	Cat	L1	W7	L1	-	W4	L1	W1	W5	L2	W3	W13	L1	W1	W1	L1	L2	L1	W1
5	Cro	W3	W1	W1	L4	-	L4	L1	W5	W1	L2	W6	L1	L9	L1	W2	L1	L6	L2
6	Dem	L3	W1	L1	W1	W4	-	L3	W1	L2	W4	W6	L2	L3	L1	W5	W12	L1	W5
7	Doc	L3	L1	L1	L1	W1	W3	-	W1	L2	L1	W1	W1	D1	L3	W1	W2	W1	W2
8	Eag	L4	L4	L1	L5	L5	L1	L1	-	L1	L3	W1	L6	L2	L3	L4	W1	L4	W1
9	Gia	W1	L1	L2	W2	L1	W2	W2	W1	-	W1	W3	L1	W1	W2	W2	W4	L4	W1
10	Haw	W1	L4	W3	L3	W2	L4	W1	W3	L1	-	W6	W5	W1	L3	W1	L2	L3	W2
11	Kan	L4	L11	L7	L13	L6	L6	L1	L1	L3	L6	-	L7	L5	L5	L5	W1	L8	W1
12	Lio	W1	W2	W1	W1	W1	W2	L1	W6	W1	L5	W7	-	L3	W2	W6	W2	W4	W3
13	Mag	W2	L1	L1	L1	W9	W3	D1	W2	L1	L1	W5	W3	-	W4	L1	L1	L2	W2
14	Pow	W1	W8	W4	L1	W1	W1	W3	W3	L2	W3	W5	L2	L4	-	W6	L1	L1	W4
15	Sai	W1	W1	L1	W1	L2	L5	L1	W4	L2	L1	W5	L6	W1	L6	-	W1	W2	W3
16	Sun	L3	W2	L1	W2	W1	L12	L2	L1	L4	W2	L1	L2	W1	W1	L1	-	L3	W5
17	Swa	W1	W3	L1	W1	W6	W1	L1	W4	W4	W3	W8	L4	W2	W1	L2	W3	-	L2
18	Tig	L2	L2	L3	L1	W2	L5	L2	L1	L1	L2	L1	L3	L2	L4	L3	L5	W2	-

"Bug Spray Needed" Mon Dec 2nd, 2024.

Oh my God. So many bugs.

But I think I've fixed most of them.

Also attempted a cheat sheet and user guide - definitely a lot of work to be done.

"Utopia Crunch" Wed Nov 27th, 2024.

I thought the first table I should put an effort into resurrecting was the "Utopia" Ladder.

It imagines a perfect season - where each team plays every other team twice; home and away. The crunch searches back through the last few seasons to find all the games it needs to construct the ladder.

Of course it's a dream - you can't have a 34 round season. But you can see what it would look like using the link in the menu to the left.

"Updates" Tue Nov 26th, 2024.

Version 1.05
- squashed a HUGE list of bugs.
- added %2 (SANFL type percentages).
- added margins eg. -6,6m3 for plus or minus a goal at 3QT.
- added selection of tables to custom crunches.
- added scope and modifiers to columns. eg. "/+".
- added reverse sorting to columns (click second time).

"First Try" Mon Nov 25th, 2024.

Testing everything out with our first table. Columns are sortable (click the heading) and you can bring up the last 25 games by clicking on any of the teams. At the bottom is the column averages (hover for totals).

Simple 2024 Ladder:

#	TeamTeam	PPlayed	WGames Won	LGames Lost	DGames Drawn	PFAverage Points For	PAAverage Points Against	PPPremiership Pts	%Percentage	OFAverage Opponent Finish	L5Last 5 W/L
1	Swa	26	19	7	0	95.6	78.1	76	122.4^%	9.1	W-W-W-W-L
2	Lio	27	18	8	1	94.4	76.4	74	123.6^%	9.2	W-W-W-W-W
3	Pow	26	17	9	0	84.6	79.1	68	106.9^%	9.9	W-W-L-W-L
4	Cat	25	16	9	0	95.5	83.1	64	114.9^%	9.6	W-L-W-W-L
5	Haw	25	15	10	0	90.4	76.0	60	119.0^%	9.5	W-W-W-W-L
6	Gia	25	15	10	0	88.6	82.3	60	107.7^%	8.5	W-W-L-L-L
7	Bul	24	14	10	0	93.0	76.5	56	121.7^%	9.2	W-L-W-W-L
8	Blu	24	13	11	0	92.6	85.5	52	108.3^%	9.2	L-L-W-L-L
9	Mag	23	12	9	2	86.6	84.5	52	102.5^%	9.0	W-W-L-W-W
10	Doc	23	12	10	1	85.4	76.3	50	111.9^%	9.5	W-L-L-L-L
11	Bom	23	11	11	1	82.3	88.0	46	93.5^%	9.8	L-W-L-L-L
12	Sai	23	11	12	0	76.0	76.4	44	99.4^%	9.3	W-L-W-W-W
13	Sun	23	11	12	0	83.7	84.5	44	99.1^%	10.0	L-L-W-L-W
14	Dem	23	11	12	0	77.6	78.8	44	98.5^%	8.9	L-L-L-W-L
15	Cro	23	8	14	1	82.9	83.6	34	99.1^%	8.0	L-L-W-L-L
16	Eag	23	5	18	0	69.3	101.7	20	68.1^%	10.1	L-W-W-L-L
17	Kan	23	3	20	0	70.4	110.9	12	63.5^%	9.0	L-W-L-L-L
18	Tig	23	2	21	0	65.4	102.8	8	63.7^%	8.9	L-L-L-L-L
		24.0432	11.8213	11.8213	0.36	84.11,514.3	84.71,524.3	48.0864	101.31823.8	9.3166.8

"And We're Back" Sun Nov 24th, 2024.

Ok. It's taken a while - but I've copied the Database across to the new domain and repaired (most of) it. Getting my head around MariaDB - which seems pretty awesome. And converting the old code into PHP/Javascript.

At the moment the database only goes back to 2000.

Menu:

Crunches:

Contact:

Links:

Welcome to the Hawk Haven

#	TeamTeam	Blu SStreak	Bom SStreak	Bul SStreak	Cat SStreak	Cro SStreak	Dem SStreak	Doc SStreak	Eag SStreak	Gia SStreak	Haw SStreak	Kan SStreak	Lio SStreak	Mag SStreak	Pow SStreak	Sai SStreak	Sun SStreak	Swa SStreak	Tig SStreak
1	Blu	-	W1	L2	W1	L3	W3	W3	W4	L1	L1	W4	L1	L2	L1	L1	W3	L1	W2
2	Bom	L1	-	W1	L7	L1	L1	W1	W4	W1	W4	W11	L2	W1	L8	L1	L2	L3	W2
3	Bul	W2	L1	-	W1	L1	W1	W1	W1	W2	L3	W7	L1	W1	L4	W1	W1	W1	W3
4	Cat	L1	W7	L1	-	W4	L1	W1	W5	L2	W3	W13	L1	W1	W1	L1	L2	L1	W1
5	Cro	W3	W1	W1	L4	-	L4	L1	W5	W1	L2	W6	L1	L9	L1	W2	L1	L6	L2
6	Dem	L3	W1	L1	W1	W4	-	L3	W1	L2	W4	W6	L2	L3	L1	W5	W12	L1	W5
7	Doc	L3	L1	L1	L1	W1	W3	-	W1	L2	L1	W1	W1	D1	L3	W1	W2	W1	W2
8	Eag	L4	L4	L1	L5	L5	L1	L1	-	L1	L3	W1	L6	L2	L3	L4	W1	L4	W1
9	Gia	W1	L1	L2	W2	L1	W2	W2	W1	-	W1	W3	L1	W1	W2	W2	W4	L4	W1
10	Haw	W1	L4	W3	L3	W2	L4	W1	W3	L1	-	W6	W5	W1	L3	W1	L2	L3	W2
11	Kan	L4	L11	L7	L13	L6	L6	L1	L1	L3	L6	-	L7	L5	L5	L5	W1	L8	W1
12	Lio	W1	W2	W1	W1	W1	W2	L1	W6	W1	L5	W7	-	L3	W2	W6	W2	W4	W3
13	Mag	W2	L1	L1	L1	W9	W3	D1	W2	L1	L1	W5	W3	-	W4	L1	L1	L2	W2
14	Pow	W1	W8	W4	L1	W1	W1	W3	W3	L2	W3	W5	L2	L4	-	W6	L1	L1	W4
15	Sai	W1	W1	L1	W1	L2	L5	L1	W4	L2	L1	W5	L6	W1	L6	-	W1	W2	W3
16	Sun	L3	W2	L1	W2	W1	L12	L2	L1	L4	W2	L1	L2	W1	W1	L1	-	L3	W5
17	Swa	W1	W3	L1	W1	W6	W1	L1	W4	W4	W3	W8	L4	W2	W1	L2	W3	-	L2
18	Tig	L2	L2	L3	L1	W2	L5	L2	L1	L1	L2	L1	L3	L2	L4	L3	L5	W2	-

#	TeamTeam	Blu SStreak	Bom SStreak	Bul SStreak	Cat SStreak	Cro SStreak	Dem SStreak	Doc SStreak	Eag SStreak	Gia SStreak	Haw SStreak	Kan SStreak	Lio SStreak	Mag SStreak	Pow SStreak	Sai SStreak	Sun SStreak	Swa SStreak	Tig SStreak
1	Blu	-	W1	L2	W1	L3	W3	W3	W4	L1	L1	W4	L1	L2	L1	L1	W3	L1	W2
2	Bom	L1	-	W1	L7	L1	L1	W1	W4	W1	W4	W11	L2	W1	L8	L1	L2	L3	W2
3	Bul	W2	L1	-	W1	L1	W1	W1	W1	W2	L3	W7	L1	W1	L4	W1	W1	W1	W3
4	Cat	L1	W7	L1	-	W4	L1	W1	W5	L2	W3	W13	L1	W1	W1	L1	L2	L1	W1
5	Cro	W3	W1	W1	L4	-	L4	L1	W5	W1	L2	W6	L1	L9	L1	W2	L1	L6	L2
6	Dem	L3	W1	L1	W1	W4	-	L3	W1	L2	W4	W6	L2	L3	L1	W5	W12	L1	W5
7	Doc	L3	L1	L1	L1	W1	W3	-	W1	L2	L1	W1	W1	D1	L3	W1	W2	W1	W2
8	Eag	L4	L4	L1	L5	L5	L1	L1	-	L1	L3	W1	L6	L2	L3	L4	W1	L4	W1
9	Gia	W1	L1	L2	W2	L1	W2	W2	W1	-	W1	W3	L1	W1	W2	W2	W4	L4	W1
10	Haw	W1	L4	W3	L3	W2	L4	W1	W3	L1	-	W6	W5	W1	L3	W1	L2	L3	W2
11	Kan	L4	L11	L7	L13	L6	L6	L1	L1	L3	L6	-	L7	L5	L5	L5	W1	L8	W1
12	Lio	W1	W2	W1	W1	W1	W2	L1	W6	W1	L5	W7	-	L3	W2	W6	W2	W4	W3
13	Mag	W2	L1	L1	L1	W9	W3	D1	W2	L1	L1	W5	W3	-	W4	L1	L1	L2	W2
14	Pow	W1	W8	W4	L1	W1	W1	W3	W3	L2	W3	W5	L2	L4	-	W6	L1	L1	W4
15	Sai	W1	W1	L1	W1	L2	L5	L1	W4	L2	L1	W5	L6	W1	L6	-	W1	W2	W3
16	Sun	L3	W2	L1	W2	W1	L12	L2	L1	L4	W2	L1	L2	W1	W1	L1	-	L3	W5
17	Swa	W1	W3	L1	W1	W6	W1	L1	W4	W4	W3	W8	L4	W2	W1	L2	W3	-	L2
18	Tig	L2	L2	L3	L1	W2	L5	L2	L1	L1	L2	L1	L3	L2	L4	L3	L5	W2	-

#	TeamTeam	Blu SStreak	Bom SStreak	Bul SStreak	Cat SStreak	Cro SStreak	Dem SStreak	Doc SStreak	Eag SStreak	Gia SStreak	Haw SStreak	Kan SStreak	Lio SStreak	Mag SStreak	Pow SStreak	Sai SStreak	Sun SStreak	Swa SStreak	Tig SStreak
1	Blu	-	W1	L2	W1	L3	W3	W3	W4	L1	L1	W4	L1	L2	L1	L1	W3	L1	W2
2	Bom	L1	-	W1	L7	L1	L1	W1	W4	W1	W4	W11	L2	W1	L8	L1	L2	L3	W2
3	Bul	W2	L1	-	W1	L1	W1	W1	W1	W2	L3	W7	L1	W1	L4	W1	W1	W1	W3
4	Cat	L1	W7	L1	-	W4	L1	W1	W5	L2	W3	W13	L1	W1	W1	L1	L2	L1	W1
5	Cro	W3	W1	W1	L4	-	L4	L1	W5	W1	L2	W6	L1	L9	L1	W2	L1	L6	L2
6	Dem	L3	W1	L1	W1	W4	-	L3	W1	L2	W4	W6	L2	L3	L1	W5	W12	L1	W5
7	Doc	L3	L1	L1	L1	W1	W3	-	W1	L2	L1	W1	W1	D1	L3	W1	W2	W1	W2
8	Eag	L4	L4	L1	L5	L5	L1	L1	-	L1	L3	W1	L6	L2	L3	L4	W1	L4	W1
9	Gia	W1	L1	L2	W2	L1	W2	W2	W1	-	W1	W3	L1	W1	W2	W2	W4	L4	W1
10	Haw	W1	L4	W3	L3	W2	L4	W1	W3	L1	-	W6	W5	W1	L3	W1	L2	L3	W2
11	Kan	L4	L11	L7	L13	L6	L6	L1	L1	L3	L6	-	L7	L5	L5	L5	W1	L8	W1
12	Lio	W1	W2	W1	W1	W1	W2	L1	W6	W1	L5	W7	-	L3	W2	W6	W2	W4	W3
13	Mag	W2	L1	L1	L1	W9	W3	D1	W2	L1	L1	W5	W3	-	W4	L1	L1	L2	W2
14	Pow	W1	W8	W4	L1	W1	W1	W3	W3	L2	W3	W5	L2	L4	-	W6	L1	L1	W4
15	Sai	W1	W1	L1	W1	L2	L5	L1	W4	L2	L1	W5	L6	W1	L6	-	W1	W2	W3
16	Sun	L3	W2	L1	W2	W1	L12	L2	L1	L4	W2	L1	L2	W1	W1	L1	-	L3	W5
17	Swa	W1	W3	L1	W1	W6	W1	L1	W4	W4	W3	W8	L4	W2	W1	L2	W3	-	L2
18	Tig	L2	L2	L3	L1	W2	L5	L2	L1	L1	L2	L1	L3	L2	L4	L3	L5	W2	-