The Cricsheet Register
Cricsheet provides two registers, one for People and one for Venues. Each register has multiple entries with identifiers from multiple sites so that a single person or venue can be identified.
The People register
The People Register consists of two CSV files containing a unique identifier for 18,651 people, and including 28,556 identifiers from 12 sources, all linked together so that an id from one site can be used to find the identifier for that same person at another site. The data also contains 8,818 name variations for the people covered.
The people covered by the data include:
- Every player and official who appears in a match for which Cricsheet provides data.
- Every player who appears in a match covered by the Cricket Scorecard Accuracy Project.
- A smattering of random players encountered while fixing some incorrect data on matches Cricsheet covers.
Bear in mind that not all ids are available for each person in the data. Only those required by either Cricsheet itself, or the Cricket Scorecard Accuracy Project will be provided.
What sites are covered?
The data includes identifiers from 12 different sites. They, along with the number of identifiers from each, are:
- BCCI (1,329)
- Big Bash (296)
- Cricbuzz (50)
- CricHeroes (111)
- CricHQ (24)
- Cricingif (130)
- CricketArchive (4,509)
- Cricketworld (127)
- ESPNcricinfo (18,788)
- NV Play (1,178)
- Opta (68)
- Pulse (2,023)
Where is the People Register currently used?
The data is currently used within 2 projects:
- Cricsheet itself uses the data in order to recognise and map players and officials when processing various data sources for matches, and has also added the Cricsheet identifier from the Register to the match data. Most of the initial work of collecting ids was done to make Cricsheet work easier.
- The Cricket Scorecard Accuracy Project (CSAP) uses Register data to check whether the players mentioned in the different scorecards for a match are actually the same person. CSAP provided a valuable push in getting this project into a releasable state, as I suddenly had a second case where I needed the mapping data, and also had to collect, and check, many more mappings into order for the project to work.
What data is available?
People
The entries in the People Register can be found in the file people.csv.
This file is a CSV consisting of a single row for each person, containing the id for the person, as assigned by Cricsheet and used in Cricsheet data, their name, a unique version of their name (as sometimes used in the match data files), and columns for the various identifiers used for the person on various websites. Not all ids are provided for all people, only those determined so far through use in Cricsheet or the Cricket Scorecard Accuracy Project.
The fields on each row (after the header) include, but are not limited to, the following:
- identifier
- The Cricsheet identifier for the person, as used in
people.csv - name
- The name used for the person in Cricsheet data. This can (and will) be used for multiple people of the same name
- unique_name
- The unique name used for the person in Cricsheet data. Guaranteed not to be used for another person
- key_bcci
- The person's identifier on BCCI
- key_bigbash
- The person's identifier on Big Bash
- key_cricbuzz
- The person's identifier on Cricbuzz
- key_cricheroes
- The person's identifier on CricHeroes
- key_crichq
- The person's identifier on CricHQ
- key_cricingif
- The person's identifier on Cricingif
- key_cricketarchive
- The person's identifier on CricketArchive
- key_cricketworld
- The person's identifier on Cricketworld
- key_cricinfo
- The person's identifier on ESPNcricinfo
- key_nvplay
- The person's identifier on NV Play
- key_opta
- The person's identifier on Opta
- key_pulse
- The person's identifier on Pulse
Names
The file names.csv provides a list of alternate or variant names for people, if they are different from that provided for the person in people.csv. These names generally include the variations used on the different sources, although some will be due to name changes (for a variety of reasons). These names are not unique, so the same name may appear multiple times.
Each row of the file, other than the header, consists of the following fields:
- identifier
- The Cricsheet identifier for the person
- name
- The variant name for the person
The Venue register
The Venue Register also consists of two CSV files containing a unique identifier for 250 venues, and including 250 identifiers from 1 source, all linked together so that an id from one site can be used to find the identifier for that same venue at another site. The data also contains 137 name variations for the venues covered.
What data is available?
Venues
The entries in the Venue Register can be found in the file venues.csv.
This file is a CSV consisting of a single row for each venue, containing the id for the venue, as assigned by Cricsheet and used in Cricsheet data, the name of the venue, a unique version of the name (as sometimes used in the match data files), and columns for the various identifiers used for the venue on various websites. Not all ids are provided for all venues, only those determined so far through use in Cricsheet.
The fields on each row (after the header) include, but are not limited to, the following:
- identifier
- The Cricsheet identifier for the venue, as used in
venues.csv - name
- The name used for the venue in Cricsheet data. This can be used for multiple venues of the same name
- unique_name
- The unique name used for the venue in Cricsheet data. Guaranteed not to be used for another venue
- key_cricinfo
- The venue's identifier on ESPNcricinfo
Names
The file venue_names.csv provides a list of alternate or variant names for venues, if they are different from that provided for the venue in venues.csv. These names generally include the variations used on the different sources, although some will be due to name changes (for a variety of reasons, such as sponsorship). These names are not unique, so the same name may appear multiple times.
Each row of the file, other than the header, consists of the following fields:
- identifier
- The Cricsheet identifier for the venue
- name
- The variant name for the venue
How often are the files updated?
The data is updated whenever either a new person or venue is added to the Cricsheet match data, or a new identifier is added for an existing person or venue. The files are then uploaded to this site when it is rebuild.
What if I spot an issue/error?
If you spot an issue or error in the Register data you should get in touch by following the instructions on the Contact page.
License
The data for both the People and Venue Registers is available under the Open Data Commons Attribution License. Full details can be found on the Licensing page.