T20 World Cup Dataset README

Introduction

Welcome to the T20 World Cup Dataset! This project is designed to manage and store data related to the T20 Cricket World Cup, including teams, players, matches, and statistics. This README provides an overview of the project, usage guidelines, and contribution protocols.

Table of Contents

• Introduction
• Features
• Usage
• Structure
• Data Schema
• Contributing
• License
• Contact

Features

• Team Management: Add, update, and delete teams participating in the T20 World Cup.

• Player Management: Add, update, and delete player information.

• Match Records: Store and retrieve match details including scores, dates, and venues.

• Statistics: Generate and view various statistics related to players and teams.

• Search Functionality: Efficiently search for teams, players, and match details.

• Data Export/Import: Export and import data in CSV format for easy sharing and backup.

Usage

Structure

t20-world-cup-dataset/
│
├── README.md             # This README file
├── data/                 # Data storage directory
        ├── csv/
        ├── json/
        ├── zip/                 
├── models/               # Data models

Data Schema

• Season

  {
      "season_id": "integer",
      "name": "string",
      "year": "string",
      "description": "string",
      "season": "string",
      "startDate": "string",
      "endDate": "string",
      "totalSquads": "integer"
  }

• Teams

  {
      "team_id": "integer",
      "team_name": "string",
      "team_abbrevaion": "string",
      "image": "string",
      "country_id": "integer"
  }   

• Matches

  {
      "season_id": "integer",
      "match_id": "integer",
      "slug": "string",
      "title": "string",
      "time_of_day": "string",
      "date": "string",
      "time": "string",
      "status": "string",
      "status_description": "string",
      "winner_team_id": "integer",
      "toss_winner_team_id": "integer",
      "toss_choice": "integer",
      "ground_id": "integer",
      "team_1_id": "integer",
      "team_2_id": "integer",
      "team_1_score": "string",
      "team_1_scoreInfo": "string",
      "team_2_scoreInfo": "string"
  }   

• Grounds

  {
      "Ground ID": "integer",
      "Ground Name": "string",
      "Ground Slug": "string",
      "Town ID": "integer",
      "Capacity": "string"
  }

• Ball By Balls

  {
  "index": "integer",
  "match_id": "integer",
  "inningNumber": "integer",
  "overNumber": "integer",
  "ballNumber": "integer",
  "oversUnique": "integer",
  "oversActual": "integer",
  "batsmanPlayerId": "integer",
  "bowlerPlayerId": "integer",
  "pitchLine": "string",
  "pitchLength":"string",
  "isFour": "string",
  "isSix": "string",
  "isWicket": "string",
  "byes": "integer",
  "legbyes": "integer",
  "wides": "integer",
  "noballs": "integer",
  "penalties": "integer",
  "run": "integer",
  "batsmanRuns": "integer",
  "totalRuns": "integer",
  "totalWickets": "integer",
  "outPlayerId": "integer",
  "shotType": "string"
  }
  

• Countrys

  {
      "Country ID": "integer",
      "Country Name": "string",
      "Country Abbreviation": "string"
  }

• Towns

  {
      "Town ID": "integer",
      "Town Name": "string",
      "Country ID": "integer"
  }

Contributing

We welcome contributions! Please follow these steps:

1. Fork the repository

2. Create a new branch

   git checkout -b feature/your-feature-name

3. Commit your changes

   git commit -m "Add your message here"

4. Push to the branch

   git push origin feature/your-feature-name

5. Open a Pull Request

License

This project is licensed under the Apache License. See the LICENSE file for more details.

Contact

For any questions or suggestions, please contact:

• Name: Ritesh Ojha
• Email: [email protected]
• GitHub: ritesh-ojha

Thank you for using the T20 World Cup Warehouse!