Tournaments - Club Abbreviations

club_id	club_name	club_short	region_name	region_short

4	Cambridge	CAM	Midlands	MID
15	Hamilton	HAM	Midlands	MID
17	Hae Taekwon-Do	HAE	Midlands	MID
19	HR Tauranga	HRT	Midlands	MID
53	Silla	SIL	Midlands	MID
59	Te Awamutu	TEA	Midlands	MID
2	Avondale	AVO	Auckland North	AN
16	Hart TKD	HAR	Auckland North	AN
22	JiS Kerikeri	JSKK	Auckland North	AN
24	JiS Royal Oak	ROA	Auckland North	AN
25	JS Glenfield	JGF	Auckland North	AN
26	JS Long Bay	JSLB	Auckland North	AN
27	JS Red Beach	JRB	Auckland North	AN
28	JS Stanmore Bay	JSB	Auckland North	AN
29	JS Warkworth	JSW	Auckland North	AN
44	PM Glendowie	PMG	Auckland North	AN
49	Remuera	REM	Auckland North	AN
58	Tamaki	TAM	Auckland North	AN
66	Warrior	WRR	Auckland North	AN
67	Warrior Dio	DIO	Auckland North	AN
72	O-Haeng Taekwon-Do	O-Haeng	Auckland North	AN
5	CB Hauraki Plains	CBH	Counties Manukau	CM
8	DS Papatoetoe	DSP	Counties Manukau	CM
11	Eas Howick	EHWK	Counties Manukau	CM
12	Eastern	EPAK	Counties Manukau	CM
23	JiS Maraetai	JSMR	Counties Manukau	CM
45	PM Papakura	PMP	Counties Manukau	CM
46	PM Waiau Pa	PMWP	Counties Manukau	CM
62	TMT	TMT A	Counties Manukau	CM
70	Xtreme Academy	XTRA	Counties Manukau	CM
7	Dannevirke	DVK	Central Districts	CD
10	DS Wanganui	DSW	Central Districts	CD
13	Guardians	GRD	Central Districts	CD
41	Phoenix	PHX	Central Districts	CD
51	RTR	RTR	Central Districts	CD
54	Southern Cross	SCT	Central Districts	CD
61	Tiger	TIG	Central Districts	CD
3	Berhampore	BER	Wellington	WN
6	Courage TKD	CRG	Wellington	WN
30	Kapiti	KAP	Wellington	WN
31	Khandallah	KHA	Wellington	WN
32	Legacy	LGC	Wellington	WN
33	Lyall Bay TKD	LYA	Wellington	WN
34	Miramar	MIR	Wellington	WN
39	North Wellington	NWN	Wellington	WN
43	Pil Sung	PIL	Wellington	WN
55	SP Kelburn	KEL	Wellington	WN
56	SP Newlands	NEW	Wellington	WN
1	Alexandra	ALX	South Island	SI
14	Halswell	HAL	South Island	SI
35	Mosgiel	MOS	South Island	SI
37	Nelson	NEL	South Island	SI
40	Otago University	OTA	South Island	SI
50	Riccarton	RIC	South Island	SI
60	Threshold	THR	South Island	SI