LV4.2 Andrew Lammie Mill o Tifty's Annie Scots Jeannie Robertson Hamish Henderson & Jean Ritchie 1953.09 School of Scottish Studies Sound Archive, SA1953.197.5 Fyvie Mill of Tifty 98 1018 233 21 verses. love; tragedy; murder http://www.tobarandualchais.co.uk/fullrecord/24187/1 / http://canmore.rcahms.gov.uk/en/site/19194/details/mill+of+tifty+waterwheel/ [Yes]
LV5.1 The Bonnie Hoose o Airlie Scots Jeannie Robertson Hamish Henderson & Jean Ritchie 1952 School of Scottish Studies Sound Archive, SA1952.043.A10 Airlie, Angus 794 233 199 6 verses. murder; castle; arson http://www.tobarandualchais.co.uk/fullrecord/49656/1
LV6.1 The Laird o Drum Scots Jeannie Robertson Hamish Henderson & Jean Ritchie 1962.05 School of Scottish Studies Sound Archive, SA1962.013.A11 Drum Castle, Drumoak, Aberdeenshire 247 835 236 Fragment only. marriage; social class http://www.tobarandualchais.co.uk/fullrecord/23305/1 [Yes]
LV7.1 The Cauld Water Well Scots / English Hamish Robb Local Voices 2013.08.24 Local Voices Sound Archive [local ref] Dundee No other source known. Also recorded but with fewer verses on Local Voices Sound Archive refs [refs.] wishing well; river
"""
# Falkirk Fair (LV1.1)
version = Version()
version.lv_id = "LV1.1"
version.title = "Falkirk Fair"
version.language = "Scots"
version.singer = singer_ids[0] # Rab Morrison
version.collector = "Hamish Henderson"
version.collected_date = "1962-05"
version.source = "School of Scottish Studies Sound Archive, SA1962.016.A9"
version.add_location(name="Falkirk")
version.add_reference("ROUD", "10368")
version.comments = "Fragments only"
version.tags = ["bothy", "farm", "bawdy"]
version.media_url = "http://www.tobarandualchais.co.uk/fullrecord/23006/1"
# version.lyrics = ""
# version.photo_url = ""
version.song = song_ids[0]
version.save(host=settings.ELASTIC_SEARCH_HOST, index=settings.ELASTIC_SEARCH_DB, refresh=True)
version_ids.append(version.id)
# Falkirk Fair (LV1.2)
version = Version()
version.lv_id = "LV1.2"
singid = SINGER_LV_ID_MAP.get(singlv)
version.singer = singid
# rows 17 to 24 are singer data which has already been imported
collector = _normalise(row[25])
if collector is not None:
version.collector = collector
cdate = _normalise(row[26])
if cdate is not None:
cdate = cdate.replace(".", "-")
version.collected_date = cdate
vsource = _normalise(row[27])
if vsource is not None:
version.source = vsource
loc1p = _normalise(row[28])
loc1lat = _normalise(row[29])
loc1lon = _normalise(row[30])
if loc1p is not None or loc1lat is not None or loc1lon is not None:
version.add_location(relation="main", lat=loc1lat, lon=loc1lon, name=loc1p)
loc2p = _normalise(row[31])
loc2lat = _normalise(row[32])
loc2lon = _normalise(row[33])
if loc2p is not None or loc2lat is not None or loc2lon is not None:
version.add_location(lat=loc2lat, lon=loc2lon, name=loc2p)
loc3p = _normalise(row[34])
loc3lat = _normalise(row[35])