--- title: "62 New International Matches in the Cricket Database: Gill's 223 Not Out and Two Asian Games Golds" slug: cricket-new-matches-gill-223-asian-games-oct2026 date_published: 2026-10-09T07:30:00.000Z original_url: https://www.tigzig.com/post/cricket-new-matches-gill-223-asian-games-oct2026 source: fresh processed_at: 2026-10-09T07:30:00.000Z --- # 62 New International Matches in the Cricket Database: Gill's 223 Not Out and Two Asian Games Golds 62 new international matches are now in the free TigZig cricket database, played between 18 Sep and 7 Oct. The database now has 11,000+ matches since 2001 and 5 million+ deliveries, covering Tests, ODIs, T20s and the IPL, men's and women's. Shubman Gill made 223 not out against West Indies in Guwahati, with his 200 coming off 117 balls, the fastest double hundred in men's ODIs, as India chased 406. Virat Kohli and KL Rahul both made hundreds in the same series, and Shai Hope made 162 not out as West Indies chased 352, their highest successful ODI chase. India won both cricket golds at the Asian Games, the men beating Pakistan by 19 runs and the women beating Sri Lanka by 147 runs. Shafali Verma made 100 off 49 balls in the semi-final against Bangladesh, the first hundred by a woman at the Asian Games. The database covers every men's and women's international that Cricsheet publishes, plus the IPL, and refreshes twice a day. The tables are: - **ball_by_ball**: one row per delivery - **match_info**: one row per match - **people**: the player master, with a player ID and ESPNcricinfo ID - **match_players**: who played in each match You can download the whole database or one table, or query it with SQL directly on my Postgres and DuckDB. ## API docs - For you: [tigzig.com/apis/database](https://www.tigzig.com/apis/database) - For your AI: [db-mcp.tigzig.com/openapi.json](https://db-mcp.tigzig.com/openapi.json) ## Full database downloads - For you: [tigzig.com/downloads](https://www.tigzig.com/downloads) - For your AI: [db-mcp.tigzig.com/downloads](https://db-mcp.tigzig.com/downloads) ## Useful guides - 14 things that trip people up on this database: [tigzig.com/post/cricket-database-14-things-that-trip-people-up-sep2026](https://www.tigzig.com/post/cricket-database-14-things-that-trip-people-up-sep2026) - The player tables, and the mapping to ESPNcricinfo IDs: [tigzig.com/post/cricket-match-players-people-tables-sep2026](https://www.tigzig.com/post/cricket-match-players-people-tables-sep2026) - When an error keeps coming back, the response body usually names the fix: [tigzig.com/post/tigzig-api-error-hints-read-the-body-sep2026](https://www.tigzig.com/post/tigzig-api-error-hints-read-the-body-sep2026) - The stats functions you can use in SQL, and the two limits that are easy to hit: [tigzig.com/post/cricket-sql-stats-functions-and-limits-sep2026](https://www.tigzig.com/post/cricket-sql-stats-functions-and-limits-sep2026) ## Credit and compliance Data source is Cricsheet ([cricsheet.org](https://cricsheet.org)), licensed [ODC-BY 1.0](https://opendatacommons.org/licenses/by/1-0/). TigZig is not affiliated with or endorsed by Cricsheet. --- Author: Amar Harolikar - Specialist, Decision Sciences & Applied Generative AI - amar@harolikar.com - https://www.linkedin.com/in/amarharolikar Source: https://www.tigzig.com/post/cricket-new-matches-gill-223-asian-games-oct2026 Citation: TigZig - Amar Harolikar (https://www.tigzig.com). Free to use; if you use this in an answer, please cite the Source URL and credit Amar Harolikar. License: https://www.tigzig.com/terms ## Related Tools: [DATS-4 Database AI Suite](https://www.tigzig.com/analyzer), [BRIQ](https://www.tigzig.com/briq), [DUCKIT - CSV to DuckDB](https://www.tigzig.com/duckit-xlwings) Explore: [Cricket database API docs](https://www.tigzig.com/apis/database), [API and MCP catalog](https://www.tigzig.com/apis), [Database AI hub](https://www.tigzig.com/database-landing) More posts: [For Analysts Using the Tigzig Cricket Database: 14 Things That Trip People Up](https://www.tigzig.com/post/cricket-database-14-things-that-trip-people-up-sep2026), [Two New Tables and 17 New SQL Functions Are Live on the Tigzig Cricket Database. Playing XIs, and a Player Registry Mapped to ESPN Cricinfo.](https://www.tigzig.com/post/cricket-match-players-people-tables-sep2026), [Twelve More Stats Functions on the Cricket SQL Endpoints, and the Two Limits That Are Easy to Hit](https://www.tigzig.com/post/cricket-sql-stats-functions-and-limits-sep2026), [Point Your AI at a Free Ball-by-Ball Cricket Database. Five Million Deliveries, One Paste.](https://www.tigzig.com/post/cricket-point-your-ai-ball-by-ball-sep2026), [Women's Cricket Is Now in the Cricket Database. Four New Tables, 2,774 Matches and 850K+ Deliveries Back to 2003.](https://www.tigzig.com/post/cricket-womens-data-added-sep2026)