The National Archives

Monday 23 November

   
 
 NDAD: The National Digital Archive of Datasets
Welcome (home page) About NDAD Users Contributors  
Search Browse News Help (new window)  
 
 

Dataset details: CRDA/71/DS/4

1992

 
 
Quick reference Full details
 
  View in hierarchy
 

Jump to :

  Context   |   Identity statement   |   Administrative context   |   Source of acquisition   |   Nature and content   |   Conditions of access and use   |   Allied materials   |   Structure   |   Validation   |   Related datasets  

Context

Conservation Database
Top of pagetop of page

Identity statement

Title 1992
NDAD reference CRDA/71/DS/4
Dates of creation of datasets 1992
Dates of contents of datasets 1992
Date of last input to datasets 1992
Date of last access to datasets 1992
Extent of datasets 1 dataset: 0.40 MB after processing by NDAD; 1 table comprising 1071 records.
ISAD(G) level of description File
Top of pagetop of page

Administrative context

Aim and purpose
Statement of responsibility
Top of pagetop of page

Source of acquisition

Source of acquisition The dataset was transferred to NDAD by The National Archives on a CD on 16 March 2006.
Top of pagetop of page

Nature and content

Scope and content

The dataset is a record of conservation work carried out for the year 1992. For further information, see the Series catalogue.

Digital processing and conversion

The dataset was received as a single Microsoft Excel spreadsheet. The data was exported in CSV format; the first record contained column headings and this was removed. The last 2 records comprised one blank line and one line with totals for the numeric data columns; these 2 records were also removed.

All DOS record delimiters were replaced with the Unix equivalent.

Top of pagetop of page

Conditions of access and use

Access conditions
Top of pagetop of page

Allied materials

Related units of description
Associated material
Publications produced by the originating department
Publications produced by researchers working on the datasets
Top of pagetop of page

Structure

Logical structure and schema

The dataset comprises a single table. Field names were taken from the original MS Excel spreadsheet column headings, with any embedded spaces or other non-alphanumeric characters removed or replaced with underscores. Some column headings occurred more than once, and these were altered by adding numeric suffixes to differentiate them. Data types were assigned by inspection of the data.

In some cases the Excel column headings provided an adequate field description; in the remaining cases, descriptions were taken from the accompanying dataset documentation.

The dataset comprises the following table(s):

Table numberNDAD referenceNameTitle
1CRDA/71/DS/4/1INFO921992
How data was originally captured and validated
Constraints on the reliability of the data
Top of pagetop of page

Validation

Content validation

Although no datatypes appear to have been explicitly defined in the original MS Excel spreadsheets by the original department, the data was checked against the datatypes inferred by NDAD, and against some datatypes assigned automatically by Excel.

The field NoParts, assigned the integer datatype, includes one record with the value '\'.

Transformation validation

The number of data records in the Excel spreadsheet was compared with the number of records in the exported data file, and was found to be consistent.

Some basic statistical operations (maximum, sum, mean) were carried out on randomly-selected numeric fields from the Excel spreadsheet; the same operations were carried out on the converted data file. No discrepancies were found.

Top of pagetop of page

Links to related datasets

Related datasets
NDAD reference Title (link leads to Dataset Catalogue)
CRDA/71/DS/1 1978-1989
CRDA/71/DS/2 1990
CRDA/71/DS/3 1991
CRDA/71/DS/5 1993
CRDA/71/DS/6 1994
CRDA/71/DS/7 1995
CRDA/71/DS/8 1995-2003

Top of pagetop of page

Last updated 2006-07-12 11:21:08

 
 

NDAD v3.0