/CricketDjango

Cricket Database website made using Django that parses api data and populates a relational postgreSQL database with it.

Primary LanguagePython

CricketDjango

This project is [Deprecated] due to this API: https://www.cricbuzz.com/match-api/livematches.json being deprecated.

Project for Database Sessional Course, done by Tasin Ishmam and Ashiqur Rahman.

Here's a Demo of the data it collected:

Players Table

player_id full_name nationality bat_style bowl_style speciality
12094 Prithvi Shaw RIGHT Right Arm off break Batsman
1446 Shikhar Dhawan LEFT Right Arm off break Batsman
8085 Colin Munro LEFT Right Arm medium Batting Allrounder
1454 Amit Mishra RIGHT Right Arm leg break Bowler
702 Ishant Sharma RIGHT Right Arm fast medium Bowler
8117 Trent Boult RIGHT Left Arm fast medium Bowler
8333 Chris Morris RIGHT Right Arm fast medium Bowling Allrounder
11158 Sandeep Lamichhane RIGHT Right Arm leg break Bowler
8755 Bandaru Ayyappa RIGHT Right Arm medium Bowler
7664 Colin Ingram LEFT Right Arm leg break Batsman
1457 Martin Guptill RIGHT Right Arm off break Batsman
1836 Manish Pandey RIGHT Right Arm medium Batsman
6326 Kane Williamson RIGHT Right Arm off break Batsman
8204 Vijay Shankar RIGHT Right Arm medium Batting Allrounder
3007 Mohammad Nabi RIGHT Right Arm off break Bowling Allrounder

Umpires Table

umpire_id full_name nationality
7498 S Ravi IND
6841 Bruce Oxenford AUS
8294 Anil Chaudhary IND
3395 Andy Pycroft ZIM
8865 Nitin Pandit IND
10271 Sadashiv Iyer IND
8859 Krishnaraj Srinath IND
11373 GS Lakshmi IND

MatchPerformance Table

match_id innings_no team_id player_id runs_scored balls_batted fours_scored sixes_scored overs_bowled maidens runs_conceded wickets_taken no_balls wides final_out_condition
22457 1 65 1739 70 62 6 1 0 0 0 0 0 0 not out
22457 1 65 6507 1 6 0 0 0 0 0 0 0 0 c Ashwin b Mujeeb
22457 1 65 8204 26 27 2 0 0 0 0 0 0 0 c Rahul b Ashwin
22457 1 65 3007 12 7 0 0 3.5 0 42 0 0 0 run out (Ashwin)
22457 1 65 1836 19 15 2 0 0 0 0 0 0 0 c (sub)Nair b Shami
22457 1 65 9427 14 3 2 1 0 0 0 0 0 0 not out
22457 1 65 790 0 0 0 0 0 0 0 0 0 0 Did not bat
22457 1 65 10738 0 0 0 0 4.0 0 20 1 0 0 Did not bat
22457 1 65 1726 0 0 0 0 4.0 0 25 0 0 0 Did not bat
22457 1 65 1828 0 0 0 0 4.0 0 42 1 0 0 Did not bat
22457 1 65 8356 0 0 0 0 4.0 0 21 2 0 0 Did not bat
22457 2 255 8733 71 53 7 1 0 0 0 0 0 0 not out
22457 2 255 247 16 14 1 1 0 0 0 0 0 0 c Deepak Hooda b Rashid Khan
22457 2 255 2195 55 43 3 3 0 0 0 0 0 0 c Vijay Shankar b Sandeep Sharma
22457 2 255 6349 1 3 0 0 0 0 0 0 0 0 c Deepak Hooda b Sandeep Sharma
22457 2 255 6319 2 3 0 0 0 0 0 0 0 0 c Deepak Hooda b S Kaul
22457 2 255 10420 5 3 0 0 4.0 0 30 0 0 0 not out
22457 2 255 9429 0 0 0 0 0 0 0 0 0 0 Did not bat
22457 2 255 1593 0 0 0 0 4.0 0 30 1 0 0 Did not bat
22457 2 255 8924 0 0 0 0 4.0 0 21 0 0 1 Did not bat
22457 2 255 7909 0 0 0 0 4.0 0 30 1 0 0 Did not bat
22457 2 255 12071 0 0 0 0 4.0 0 34 1 0 2 Did not bat

Teams Table

team_id team_name league
61 Delhi Capitals Indian Premier League 2019
255 Sunrisers Hyderabad Indian Premier League 2019
446 Trailblazers Domestic
530 Velocity Domestic

Series Table

series_id series_name mots winner
2810 Indian Premier League 2019 Jasprit Bumrah Mumbari Indians
2822 Womens T20 Challenge 2019 Jemimah Rodrigues IPL Supernovas