Sub-series details: CRDA/24/DS/1991

This dataset was transferred from the Department of Health on a CD-ROM which was received by NDAD on 1 October 1999.

This sub-series holds public health data for 1990. Further information about the Public Health Common Datasets (PHCDS) is provided in the Series Catalogue and Dataset Documentation Catalogues. The sub-series consists of 4 datasets comprising a total of 68 tables which contain various indicators for health regions in England. Data is arranged by administrative areas, namely District Health Authorities (DHAs), Family Health Service Authorities (FHSAs). National and Regional data is replicated for comparison purposes thus the first batch of lines in the 2 'equivalent' spreadsheets (eg a1 and fa1) is the same. The dataset provides data on population and demography, fertility, births, stillbirths and abortions, deaths and standardised mortality ratios, and morbidity. The main additions to the data since 1990 are: the inclusion of data for Family Health Services Authorities and morbidity data from cancer registrations and from the notification of congenital malformation and infectious diseases. Changes to existing data items can be seen on page 1 of CRDA/24/DD/1/2. District Health Authority mergers of the time were not incorporated in the data. A detailed description of the indicators can be seen in the data definitions and user guide in the dataset documentation catalogue see CRDA/24/DD/1/2.

The 4 datasets which comprise CRDA/24/DS/1991 were transferred to NDAD in the form of Symphony (WR1) spreadsheet files. Copies of the Symphony files were processed using Microsoft Excel 97 and Microsoft Visual Basic (under Windows 95 / 98) and converted to comma-separated (CSV) format. All headings and metadata present in the original spreadsheets were removed before converting the files to CSV, along with blank rows and columns which had been included in the spreadsheets for layout purposes.

Some original spreadsheets contain formatting of numeric fields, for example fields are set to display as integers when they actually hold real numbers. Fields with many figures after the decimal point are displayed with just 2 figures after the decimal point. In order to preserve the more detailed figures, the formatting of numeric fields was set to Microsoft Excel General format before converting the files to CSV. However, it must be assumed that original users of the spreadsheets would have seen the data as it had been originally formatted. Although some files contain fields that have many decimal places, users are advised that NDAD recommends that all data in the PHCDS is not quoted at more than two decimal places. This is because fields are not formatted with more than two decimal places in the original spreadsheet files. NDAD assumes that this is because the data creators considered the data to be accurate to, at most, two decimal places.

The PHCDS in its original format does not use specific field names as such: generally, spreadsheet packages do not require data to be held within named fields. The indicators within PHCDS do have original names which have been preserved but these equate to the table name within NDAD. In other words the heading of each spreadsheet equates to the title of the indicator and forms the title of the table in NDAD. To identify fields within a table, NDAD has allocated names sequentially; however to differentiate between tables that hold data relating to DHAs and the other 'type' of tables which hold data relating to FHSAs, the first 2 fields have been named D_CODE or F_CODE (depending on whether the table covers DHAs or FHSAs) and AREA (for the name of the area); subsequent field names run sequentially ie the next field is named F3, then F4 etc. The column headings in the spreadsheet, supplemented at times by information from the 'Data definition and user guide', form the basis of the field descriptions.

No access conditions apply.

The language of the materials is .

The User Guide for the 1991 PHCDS has been transferred to NDAD, reference CRDA/24/DD/1/2, and can be consulted via the Dataset Documentation Catalogue. The User Guide provides data definitions for the indicators and is a user guide for the original computer files. Information from the metadata contained in the original spreadsheet files and the 1991 User Guide has been used in compiling the Table catalogues in the individual datasets.

The data is available for District Health Authorities (DHAs), Family Health Service Authorities (FHSAs), NHS Regions and nationally for England, and England and Wales. The data has been organised into four datasets by topic. For access to these datasets, see Links to dataset catalogues.

Details of the sources which were used to produce the Public Health Common Data Set and how the data was validated are given in the Series Catalogue.

No discrepancies were noted in the original spreadsheet files as compared to the expected contents as described in the User Guide for the 1991 PHCDS, reference CRDA/24/DD/1/2.

Spot checks were carried out to compare the transformed data against the data in the original Symphony files. These included comparing the values of specific fields and checking that the totals of numeric fields were the same. In addition, each table was checked to ensure that the overall number of records and fields remained the same. No discrepancies were detected between the original and transformed data. The only differences found resulted from rounding and/or floating point representation, particularly for example where the original numbers had 12 figures after the decimal point. The transformed data is restricted to the level of accuracy provided by the general format in Excel (generally 8 figures after the decimal point).

Dataset catalogues provide more detailed information about individual datasets, and are currently available for the following dataset(s):