--- title: "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." slug: cricket-match-players-people-tables-sep2026 date_published: 2026-09-10T06:00:00.000Z original_url: https://www.tigzig.com/post/cricket-match-players-people-tables-sep2026 source: fresh processed_at: 2026-09-10T06:00:00.000Z --- # 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. Two new tables covering players, and 17 new SQL functions are live on the Tigzig cricket database - ODI, T20, Test and IPL ball-by-ball from 2001 till date. Refreshed twice daily. Run direct SQL on Postgres / DuckDB or download the full database. **The first is match_players**, giving the playing XI, teams and match officials for every game across 292,000+ rows. **The second is people**, an 18,500+ player registry that maps unique player identifiers directly to ESPN Cricinfo IDs with a 99.8% match rate. Alongside the new tables, 17 new SQL analytics functions are enabled on Postgres and DuckDB, covering window functions like dense_rank, lag and lead, list aggregations like string_agg and array_agg, and date extraction. The database covers ~11,000+ matches and 5.3 million+ records in total. You can query it directly with read-only SQL, or download the full database in DuckDB, SQLite, Parquet or CSV. Download manually or via API. Free, no signup, no API key. **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) ## The two new tables, and how they join Up to now, ball_by_ball and match_info had player names as plain text strings, which works fine until two players share a name or you want to pull in external stats. The match_players table connects each match_id to individual players and officials with a stable identifier, listing the full playing XI, team and match roles. Every non-null identifier in that table resolves cleanly into the people registry. In people, 99.8% of records carry the ESPN Cricinfo player ID in key_cricinfo. That means you can take any match lineup from this database and link it directly to Cricinfo profiles, career numbers or external datasets without having to write fuzzy name-matching logic. Both tables join with match_info on match_id, and people joins on identifier. Data from cricsheet.org and served as is. Run your own diagnostics and validations. [tigzig.com/apis/database](https://www.tigzig.com/apis/database) ## The new SQL functions, and what you can do with them Earlier, if you wanted a list of players in a match or cumulative partnership totals, you had to pull raw rows and stitch them together in Python or Excel. With string_agg and array_agg enabled, you can roll up an entire playing XI or dismissal sequence into a single row per match directly in your SELECT statement. The window functions like dense_rank, lag and lead let you calculate ball-by-ball momentum, batting order shifts, or compare consecutive deliveries without self-joins. And functions like date_part, variance and greatest take care of calendar splits and basic distribution stats in the query itself. Most of the new functions run on both engines, and a few follow one dialect. **The endpoints are public if you want to run SQL against them** - [db-mcp.tigzig.com/v1/query/duckdb](https://db-mcp.tigzig.com/v1/query/duckdb) - [db-mcp.tigzig.com/v1/query/postgres](https://db-mcp.tigzig.com/v1/query/postgres) And the full database with the new tables, in DuckDB, Parquet, SQLite or CSV, is at [db-mcp.tigzig.com/downloads](https://db-mcp.tigzig.com/downloads) via API, with manual downloads at [tigzig.com/apis/database](https://www.tigzig.com/apis/database). ![Two new cricket tables, match_players and people, plus 17 new SQL functions, live on the Tigzig cricket database](/images/blog/cricketNewTablesSep2026.png) ## Compliance note 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-match-players-people-tables-sep2026 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: [IPL Ball by Ball Data Is Live on the Tigzig Cricket API and Download. 1,200+ Matches, Every Season Since 2008.](https://www.tigzig.com/post/cricket-ipl-ball-by-ball-live-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), [Three New Things on the Tigzig Cricket Database. New match_info Fields, SQL Laid Out in the Docs, and a Quicker Postgres.](https://www.tigzig.com/post/cricket-db-new-fields-sql-docs-aug2026), [A Database Server With API and MCP You Can Point an AI Agent At, With Ball-by-Ball Cricket Behind It.](https://www.tigzig.com/post/db-mcp-cricket-ball-by-ball-api-aug2026), [The Full Cricket Database Is Now Downloadable. Test, ODI and T20 Ball by Ball, in Parquet, CSV, DuckDB or SQLite.](https://www.tigzig.com/post/cricket-full-data-download-live-aug2026)