Department of Health: Public Health Common Dataset
Department of Health: Public Health Common Dataset
The Public Health Common Dataset (PHCDS) contains annual datasets of public health statistics from all regional and district health authorities, and family health services authorities.
Each PHCDS dataset consists of a number of indicators on topics such as demography, fertility, mortality, morbidity, and the decennial census. Indicators are aggregated statistical measures describing a group of patients or a population, compiled from measures or assessments made on people in the group or population. Indicators are available for administrative areas within the NHS in England from 1996; data is also available for local authority areas.
The data within the PHCDS is by administrative areas, therefore it is important to understand the administrative structure of the NHS. However, the administrative areas of the NHS have undergone significant re-organisation during the years that the PHCDS has been produced. In 1988 the Department of Health (DoH) was responsible for the NHS, NHS Regional Health Authorities (RHAs), District Health Authorities (DHAs), and Family Health Service Authorities (FHSAs). In 1996 DHAs and FHSAs were merged and replaced by Health Authorities (HAs). The structure of the NHS includes HAs and Primary Care Groups (PCGs).
The scope and content of the PHCDS has changed and developed since its inception. In 1998, the PHCDS itself was absorbed into the Compendium of Clinical and Health Indicators which are based on mortality data. In addition some indicators look at hospitalisation for specific causes, some screening activities and regional data on health and lifestyle. The set also includes some basic social and demographic indicators, mainly derived from the 1991 census.
The PHCDS includes many hundreds of health indicators calculated from individual health and local authorities (where possible) in England and Wales. A health indicator is a characteristic of an individual, population or an environment which can be measured and used to describe one or more aspects of the health of an individual or population.
The datasets in this series are available to download. Links to individual datasets can be found at piece level.
Hardware: For the 1988 to 1996 PHCDS the data was distributed on 3.5 inch floppy disks. (The 1990 User Guide states that HAs could request the data on 5.25 inch disks.) The number of disks per year differed depending on the number of files. For the 1997 and 1998 PHCDS the data was distributed on a CD-ROM.
Operating System: Microsoft DOS (MS-DOS) and Microsoft Windows.
Application Software: For 1988 to 1995 the data was distributed in Symphony (WR1) spreadsheets. To read the data a copy of Symphony (version 1.1 or upwards), or Lotus 1-2-3, or a spreadsheet package that could import Lotus files, was required.
For 1996 the data was distributed as compressed (ZIP) files. These files had to be copied onto the hard disk of a PC and then uncompressed. The uncompressed files were Lotus 1-2-3 (WK3) files.
For 1997 the data was distributed as Lotus 1-2-3 (WK3) files.
For 1998 and 1999 the PHCDS data was distributed as Lotus 1-2-3 (WK4) files; the Compendium data was supplied in two formats, Lotus 1-2-3 (WK3) and Microsoft Excel 97.
Logical structure and schema: One table has been created for each spreadsheet file. The structure of each table reflects the structure of the original file. Each dataset consists of the tables relating to that year of the PHCDS. Within each year tables are grouped by topic, e.g. tables on population are grouped together. Some topics are only available for some years, which reflects the development of the PHCDS. To allow users to combine fields from more than one file, relationships were set up by NDAD between all tables (for the same type of NHS administrative area) within a topic. For example in the 1988 dataset, all tables within the first topic (Population and Demography) are linked.
How data was originally captured and validated: The organisations that provided data for the PHCDS include OPCS's successor, the Office for National Statistics (ONS), the DoH and the NHS via RHAs, HAs and hospitals. The major data collection/statistical systems that provide source data for the PHCDS include:
Generally, the data used in the PHCDS was validated by the original data collectors before being used. The source data for the PHCDS was usually processed by the organisations producing the PHCDS to create the indicators. Many indicators are a rate per population, so that HAs can be compared. The processing methodology of each indicator is described in the User Guides included with the dataset documentation.
Constraints on the reliability of the data: There are a small number of tables in which some figures are displayed as percentages within the original spreadsheet (when viewed via Excel) but are exported to CSV as figures between 0 and 1, and are therefore held as such.
Validation performed after transfer: Details of the content and transformation validation checks performed by NDAD on each dataset are recorded in the catalogues of individual datasets.
|Held by:||The National Archives, Kew|
|Former reference in The National Archives||CRDA/24|
|Legal status:||Public Record|
|Creator:||Department of Health, 1988-|
|Physical description:||120 datasets and documentation|
|Restriction on use:||The Public Health Common datasets are subject to Crown Copyright; copies may be made for private study and research purposes only.|
|Immediate source of acquisition:||In 2010 the United Kingdom National Digital Archive of Datasets|
|Custodial history:||Originally transferred from the Department of Health. The United Kingdom National Digital Archive of Datasets (NDAD) then held the datasets until 2010 when they were transferred to The National Archives (TNA).|
|Accruals:||Further accruals are not anticipated.|
|Publication note:||Various Health Authority public health reports are published yearly.|
|Unpublished finding aids:||Extent of documentation: 121 documents, Dates of creation of documentation: 1990-2005|
|Administrative / biographical background:||
The Public Health Common Dataset (PHCDS) has been commissioned annually by the Department of Health (DoH) for the National Health Service (NHS) since 1988/89. Within the Department of Health, the Public Health Group has responsibility for the development of the Our Healthier Nation public health strategy across government. Within the NHS Executive (NHSE), the NHS Public Health Development Unit (PHDU) is responsible for public health strategy and function in the NHS. The PHCDS is a compendium of data across a range of nationally identified items with a relevance to public health. The DoH commissions external organisations to create the PHCDS on its behalf.
The 1988 PHCDS was produced by the Epidemiology and Public Health Research Unit at the University of Surrey. By the 1991 PHCDS this organisation had changed its name to the Institute of Public Health, and by the 1996 PHCDS it had become the National Institute of Epidemiology. The 1998 PHCDS was produced by the Centre for Public Health Monitoring at the London School of Hygiene and Tropical Medicine (LSHTM).
The purpose of the PHCDS has developed from helping directors of public health agencies produce their annual reports, to encompass monitoring progress in achieving Health of the Nation (HoN) targets, and subsequently Our Healthier Nation targets. The PHCDS also monitors clinical outcomes. The Public Health Common Data Set (known as the Compendium of Clinical and Health Indicators since 1998) provides health authorities with a 'common currency' for studying and comparing information about health.