{"catalog_version":1,"view":"app_detail","app":"cricket","app_title":"CRICKET","status":"ok","generated_at":"2026-10-22T12:57:06Z","summary_url":"https://api.tigzig.com/downloads","source_index_url":"https://api.tigzig.com/cricket/v1/downloads/manifest","query_in_place":{"http_range_requests":true,"formats":["parquet"],"how":"Parquet files support HTTP range requests, so DuckDB, pyarrow, polars or a browser can query them in place and read only the parts a query needs.","example_sql":"SELECT count(*) FROM read_parquet('https://api.tigzig.com/cricket/v1/download/ball_by_ball.parquet');","example_curl":"curl -H \"Range: bytes=-8\" https://api.tigzig.com/cricket/v1/download/ball_by_ball.parquet","limits":"Range reads have their own per-IP budget, separate from whole-file downloads. Every response carries X-RateLimit headers."},"datasets":[{"id":"cricket.all_tables","table":"all","title":"All cricket tables in one database file","description":"Every table above in a single file. Open it locally and every table is already loaded.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["whole database","sqlite","duckdb"],"slice":false,"all":true,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"duckdb.zip","label":"DuckDB.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/cricket_all_tables.duckdb.zip","size_bytes":16224551,"generated_at":"2026-10-22T06:25:26Z","row_count":5406535},{"format":"duckdb.gz","label":"DuckDB.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/cricket_all_tables.duckdb.gz","size_bytes":16223199,"generated_at":"2026-10-22T06:25:26Z","row_count":5406535},{"format":"sqlite.zip","label":"SQLite.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/cricket_all_tables.sqlite.zip","size_bytes":102316593,"generated_at":"2026-10-22T06:25:26Z","row_count":5406535},{"format":"sqlite.gz","label":"SQLite.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/cricket_all_tables.sqlite.gz","size_bytes":102315241,"generated_at":"2026-10-22T06:25:26Z","row_count":5406535}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":5406535,"data_as_of":"2026-10-14"},{"id":"cricket.ball_by_ball","table":"ball_by_ball","title":"Every delivery, all formats","description":"One row per ball across Test, ODI and T20 internationals, men's and women's, plus the IPL. Filter on the gender and team_type columns.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":false,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball.csv.gz","size_bytes":57326736,"generated_at":"2026-10-22T06:25:26Z","row_count":5080431},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball.csv.zip","size_bytes":57326848,"generated_at":"2026-10-22T06:25:26Z","row_count":5080431},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball.parquet","size_bytes":14408312,"generated_at":"2026-10-22T06:25:26Z","row_count":5080431,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":5080431,"data_as_of":"2026-10-14"},{"id":"cricket.ball_by_ball_ipl","table":"ball_by_ball_ipl","title":"Deliveries: IPL","description":"A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":true,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_ipl.csv.gz","size_bytes":3491344,"generated_at":"2026-10-22T06:25:26Z","row_count":295732},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_ipl.csv.zip","size_bytes":3491464,"generated_at":"2026-10-22T06:25:26Z","row_count":295732},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_ipl.parquet","size_bytes":920785,"generated_at":"2026-10-22T06:25:26Z","row_count":295732,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":295732,"data_as_of":"2026-05-31"},{"id":"cricket.ball_by_ball_odi_men","table":"ball_by_ball_odi_men","title":"Deliveries: ODI, men","description":"A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":true,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_odi_men.csv.gz","size_bytes":15895648,"generated_at":"2026-10-22T06:25:26Z","row_count":1377050},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_odi_men.csv.zip","size_bytes":15895776,"generated_at":"2026-10-22T06:25:26Z","row_count":1377050},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_odi_men.parquet","size_bytes":3842644,"generated_at":"2026-10-22T06:25:26Z","row_count":1377050,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":1377050,"data_as_of":"2026-10-13"},{"id":"cricket.ball_by_ball_odi_women","table":"ball_by_ball_odi_women","title":"Deliveries: ODI, women","description":"A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":true,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_odi_women.csv.gz","size_bytes":3705910,"generated_at":"2026-10-22T06:25:26Z","row_count":323305},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_odi_women.csv.zip","size_bytes":3706042,"generated_at":"2026-10-22T06:25:26Z","row_count":323305},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_odi_women.parquet","size_bytes":900325,"generated_at":"2026-10-22T06:25:26Z","row_count":323305,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":323305,"data_as_of":"2026-10-14"},{"id":"cricket.ball_by_ball_t20_men","table":"ball_by_ball_t20_men","title":"Deliveries: T20 internationals, men","description":"A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":true,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_t20_men.csv.gz","size_bytes":9541701,"generated_at":"2026-10-22T06:25:26Z","row_count":816237},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_t20_men.csv.zip","size_bytes":9541829,"generated_at":"2026-10-22T06:25:26Z","row_count":816237},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_t20_men.parquet","size_bytes":3222847,"generated_at":"2026-10-22T06:25:26Z","row_count":816237,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":816237,"data_as_of":"2026-10-14"},{"id":"cricket.ball_by_ball_t20_women","table":"ball_by_ball_t20_women","title":"Deliveries: T20 internationals, women","description":"A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":true,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_t20_women.csv.gz","size_bytes":5719183,"generated_at":"2026-10-22T06:25:26Z","row_count":496500},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_t20_women.csv.zip","size_bytes":5719315,"generated_at":"2026-10-22T06:25:26Z","row_count":496500},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_t20_women.parquet","size_bytes":1846627,"generated_at":"2026-10-22T06:25:26Z","row_count":496500,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":496500,"data_as_of":"2026-10-07"},{"id":"cricket.ball_by_ball_test_men","table":"ball_by_ball_test_men","title":"Deliveries: Test, men","description":"A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":true,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_test_men.csv.gz","size_bytes":18482849,"generated_at":"2026-10-22T06:25:26Z","row_count":1724856},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_test_men.csv.zip","size_bytes":18482979,"generated_at":"2026-10-22T06:25:26Z","row_count":1724856},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_test_men.parquet","size_bytes":3228427,"generated_at":"2026-10-22T06:25:26Z","row_count":1724856,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":1724856,"data_as_of":"2026-10-09"},{"id":"cricket.ball_by_ball_test_women","table":"ball_by_ball_test_women","title":"Deliveries: Test, women","description":"A slice of ball_by_ball with identical columns. The slices sum to it exactly, so take the slice or the whole, never both.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":true,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_test_women.csv.gz","size_bytes":496149,"generated_at":"2026-10-22T06:25:26Z","row_count":46751},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_test_women.csv.zip","size_bytes":496283,"generated_at":"2026-10-22T06:25:26Z","row_count":46751},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/ball_by_ball_test_women.parquet","size_bytes":97817,"generated_at":"2026-10-22T06:25:26Z","row_count":46751,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":46751,"data_as_of":"2026-07-10"},{"id":"cricket.match_info","table":"match_info","title":"Matches","description":"One row per match across every format: teams, venue, date, toss and result.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":false,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/match_info.csv.gz","size_bytes":581814,"generated_at":"2026-10-22T06:25:26Z","row_count":11186},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/match_info.csv.zip","size_bytes":581922,"generated_at":"2026-10-22T06:25:26Z","row_count":11186},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/match_info.parquet","size_bytes":361980,"generated_at":"2026-10-22T06:25:26Z","row_count":11186,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":11186,"data_as_of":"2026-10-14"},{"id":"cricket.match_players","table":"match_players","title":"Match players","description":"Who played in each match, one row per player per match.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":false,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/match_players.csv.gz","size_bytes":1882396,"generated_at":"2026-10-22T06:25:26Z","row_count":296267},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/match_players.csv.zip","size_bytes":1882510,"generated_at":"2026-10-22T06:25:26Z","row_count":296267},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/match_players.parquet","size_bytes":1432133,"generated_at":"2026-10-22T06:25:26Z","row_count":296267,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":296267,"data_as_of":null},{"id":"cricket.people","table":"people","title":"Player register","description":"One row per person, with the identifiers used across the other tables.","category":"sports","kind":"bulk_download","publisher":"Cricsheet (cricsheet.org)","update_cadence":"twice daily","tags":["cricket","sports","ball by ball"],"slice":false,"docs_url":"https://www.tigzig.com/apis/database","app":"cricket","files":[{"format":"csv.gz","label":"CSV.gz","role":"data","url":"https://api.tigzig.com/cricket/v1/download/people.csv.gz","size_bytes":470186,"generated_at":"2026-10-22T06:25:26Z","row_count":18651},{"format":"csv.zip","label":"CSV.zip","role":"data","url":"https://api.tigzig.com/cricket/v1/download/people.csv.zip","size_bytes":470286,"generated_at":"2026-10-22T06:25:26Z","row_count":18651},{"format":"parquet","label":"Parquet","role":"data","url":"https://api.tigzig.com/cricket/v1/download/people.parquet","size_bytes":519983,"generated_at":"2026-10-22T06:25:26Z","row_count":18651,"http_range_requests":true}],"validation_url":"https://validation.tigzig.com/","tool_url":"https://www.tigzig.com/apis/database","methodology_url":"https://www.tigzig.com/apis/database#source","row_count":18651,"data_as_of":null}]}