Piror to MIDS program at Duke, I have been climbing referee rank ladder in China from 2019 to 2022 (2018 in the U.S., yes, I am a USSF referee as well).
This project is focuing on creating SQLite3 database via codespaces by using the data I have collected by my own through out the years. Then try to gain insights from .db database using SQL queries.
The highest profile game I have officied is the 2022 pre-season clash between two Chinese Super League teams (TOP 1 professional soccer league in China), Chengdu Rongcheng FC 1:1 Henan Songshan Longmen FC on April 27, 2022.
Wikipedia of Chinese Super League: https://en.wikipedia.org/wiki/Chinese_Super_League
The proudest game I have officiated as Referee is the derby between my local teams in Sichuan, Chengdu Rongcheng 4:2 Sichuan Jiuniu on April 29, 2022.
Command Line Python Script
python sql.py
| Questions | Answer |
|---|---|
| How many 11vs11 games I have officiated between Jan. 2021 and July 2022? | 129 |
| How many 8vs8 games I have officiated between Jan. 2021 and July 2022? | 80 |
| How many games I have officiated as Referee between Jan. 2021 and July 2022? | 108 |
| How many games I have officiated as Assistant Referee between Jan. 2021 and July 2022? | 37 |
| How many games I have officiated as 4th Official between Jan. 2021 and July 2022? | 82 |
| How many Yellow Cards I have shown as Referee between Jan. 2021 and July 2022? | 182 |
| How many Red Cards I have shown as Referee between Jan. 2021 and July 2022? | 8 |
| How many Yellow Cards per game when I officiate as Referee between Jan. 2021 and July 2022? | 1.69 |
| How many Red Cards per game when I officiate as Referee between Jan. 2021 and July 2022? | 0.07 |
The most cards shown in a game as a referee was 11, (YC: 9, 2nd YC: 2, and RC: 2), 成都龙耀 v 德驰娱乐 (Final Score: 1:2, 成甲总Semi-Final) on 1/16/22 at 锦江仁德 A4. My running distance was 8.13 kilometers. Other officials were: 秦立港、李阳、李飞.
成都龙耀 v 德驰娱乐 Game Photos:
The most distance covered in a game as a referee was 9.90 kilometers, 成都之己 v 成都大学 (Final Score: 2:2, 成超 2022 Season Gameday 8; YC: 2, 2nd YC: 0, and RC: 0) on 7/3/22 at 城东体育公园.
成都之己 v 成都大学 Game Photos:
