There are two datasets derived from the National Lottery Awards database. The first dataset is a snapshot of the system taken in March 2001 which includes details of successful awards made between February 1995 and March 2001. It also contains information on failed applications between January 1995 and March 1997. After this date the Distributing Bodies ceased supplying information on failed applications to Department for Culture, Media and Sport (DCMS). A second snapshot of the system was transferred to the National Digital Archive of Datasets (NDAD) in July 2006 containing details of successful awards up to and including 2 September 2006.
The AWAWDS table, covering successful awards contains the majority of the data input to the database. In the first dataset the table contained details of more than 83,000 lottery awards. In the 2006 snapshot the number of awards had increased to more than 250,000. The data in this table includes the following details:
- Unique identifiers for the award, distributing body and distributing body sector. The distributing body sector is a sub classification of the distributing body (for example, in the case of an award made by Sport England, the particular sport benefiting from the award would be the distributing body sector).
- Details of the organisation receiving the award, including the name and address and an indication of whether or not it holds charitable status.
- Information about the project, including a short description, the amount awarded, the total cost of the project, the date of the award, the project completion date and the status of the award (i.e. successful, completed, stopped or withdrawn).
- Location details used as part of the various reporting functions within the database. These include the electoral ward, local authority, county, UK and European Parliamentary constituencies and UK region.
In addition to the awards data the database also contains data relating to UK Members of Parliament. This is supplied to DCMS by a private company, QAS Ltd on a quarterly basis. Data supplied by QAS is used to validate the postcodes of organisations receiving lottery awards. These are then used to derive values for those fields in the AWAWDS table covering location; for example county, local authority area and region. Changes to the data that are made as a result of data supplied by QAS are recorded separately in the AWREDERIVE table.
The datasets in this series are available to download. Links to individual datasets can be found at piece level.