--- title: "The SQL Pitch Is Ready. Bring on the Strike Bowlers: Cricket Data With 11,000+ Matches and 5 Million+ Balls, Direct SQL on DuckDB and Postgres" slug: cricket-sql-pitch-ready-strike-bowlers-nov2026 date_published: 2026-11-10T10:50:00.000Z original_url: https://www.tigzig.com/post/cricket-sql-pitch-ready-strike-bowlers-nov2026 source: fresh processed_at: 2026-11-10T10:50:00.000Z --- # The SQL Pitch Is Ready. Bring on the Strike Bowlers: Cricket Data With 11,000+ Matches and 5 Million+ Balls, Direct SQL on DuckDB and Postgres The cricket database now has South Africa's Test series against Australia, India's T20 series in New Zealand and the ODI tri-series in Pakistan. The latest match in the data is from 2 Nov. Pakistan beat Sri Lanka in the tri-series final in Lahore, chasing 326. That chase equals the highest in an ODI final, India's 326 against England in 2002, and the 656 runs in the match are the most in any ODI final, per ESPNcricinfo. For your AI agent "Go to tigzig.com and let me know what cricket data is available and how to access it" For you tigzig.com ➜ Agents & APIs ➜ Database Credit & Compliance: Data source is Cricsheet (cricsheet.org), licensed ODC-BY 1.0. TigZig is not affiliated with or endorsed by Cricsheet. ## A few quick points ▸ The main tables are ball_by_ball (one row per delivery), match_info (one row per match), match_players (the playing XI and officials) and people (the player registry, with ESPNcricinfo IDs). ▸ team1 and team2 do not tell you who batted first. Use the margin columns: winner_runs is filled when the side batting first won, and winner_wickets when the side chasing won. ▸ Venue names were standardised across all matches on 4 Nov, so each big ground now has one name. [tigzig.com/post/cricket-venue-names-standardised-nov2026](https://www.tigzig.com/post/cricket-venue-names-standardised-nov2026) Useful links that save time on this data ▸ The 14 things that trip people up: [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 SQL functions you can use, and the limits to know about: [tigzig.com/post/cricket-sql-stats-functions-and-limits-sep2026](https://www.tigzig.com/post/cricket-sql-stats-functions-and-limits-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 SQL pitch is ready, bring on the strike bowlers: a red cricket one-pager with 11,000+ matches and 5 million+ balls, direct SQL on DuckDB and Postgres, the full database download, Kaggle and Hugging Face, and the GitHub index](/images/blog/CricketPitchReadyNov2026.png) --- 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-sql-pitch-ready-strike-bowlers-nov2026 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), [Download hub](https://www.tigzig.com/downloads) More posts: [Cricket Database: One Name for Each Ground, After Venue Names Were Standardised on 5,145 Older Matches](https://www.tigzig.com/post/cricket-venue-names-standardised-nov2026), [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), [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), [Back From Sunday Cricket? Some Cricket SQL Now: A Free Ball-by-Ball Database on DuckDB, Postgres or One Download](https://www.tigzig.com/post/cricket-back-from-sunday-sql-oct2026), [IPL and International Cricket Data Is Now on Kaggle and Hugging Face, Refreshed Daily, With a GitHub Index of Every TigZig Dataset](https://www.tigzig.com/post/cricket-data-kaggle-hugging-face-github-nov2026)