I've done this so that the interviews can be sorted and filtered by date, which requires the field to be in a true date format. We should probably move this into another field so that the title field is left with only the person's name.Īudio-dates.txt gives a list of the dates from the date field in the spreadsheet (renamed to date_old) and a new date field which extracts a single date. Notice that some titles have an added phrase after the person's name (I've separated it with a semi-colon). Decide what fields can be consolidated.Īudio-title.txt is a list of the objectid and titles for the db. )Īudio-fielduse.txt is the listing of the fields with recurring values in fields, along with the count of each occurrence of that value. In most cases, I've been able to remove traces of the indication in the note field, but some of them remain (which is why you'll see an occasional letter (T, L, etc.) in the note field. Note that, due to Amita's machine-like precision in recording the OH status in the notes (F, L, C, R, T) I was easily able to extract this and put the data into new fields of the corresponding name so that we can operate on that field (filter, sort). This is a much simpler db, so it should be quick to check for completeness, use of fields, etc. Audio-v7.txt is the complete dump of the oral-histories-v5.xls spreadsheet.

Audionotes database