musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical music", musiccaps_aspects contains "female singer" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 68 ✖
- classical music · 3 ✖
- female singer · 3 ✖
- celestial 2
- dreamy 2
- enchanting 2
- enthralling 2
- falsetto 2
- high notes 2
- meditative 2
- melodic 2
- slow tempo 2
- soprano 2
- amateur recording 1
- ambient auditorium sounds 1
- ancient lineage instrument 1
- angelic 1
- buzzing sound 1
- calming 1
- captivating 1
- catholic prayer 1
- catholic salutation 1
- cello 1
- chant like 1
- chanting 1
- clapping 1
- classical song 1
- descan 1
- descant 1
- droning 1
- dulcet 1
- elegy 1
- ethereal 1
- extemporaneous 1
- female harpist 1
- folk song 1
- harp 1
- hynoptic 1
- incoherent music 1
- lao folk music 1
- laos classical song 1
- laos folk song 1
- laotian classical music 1
- latin music 1
- latin song 1
- lilting 1
- live performance 1
- medium fast tempo 1
- mellifluous 1
- melodic violin 1
- mesmerising 1
- mystical 1
- oldest instrument 1
- opera singer 1
- orchestra 1
- people talking 1
- philharmonic 1
- pleasant 1
- plucking 1
- resonator 1
- serene 1
- small hand cymbals 1
- soothing 1
- symphony orchestra 1
- viola 1
- violin symphony 1
- vocal backup 1
- western classical 1
- xylophone like instrument 1
musiccaps_names (array) 6 ✖
- Music 3
- Opera 2
- Folk music 1
- Musical instrument 1
- Percussion 1
- Rattle (instrument) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lao Traditional Music 2013 4 (ຂັບທຸ້ມຫຼວງພະບາງ) | A female vocalist sings this loud chant like folk song in a foreign language. The tempo is medium fast with vocal backup, rhythmic small hand cymbals and xylophone like instruments. The audio quality is inferior so the music is incoherent. This song is a live performance or concert with ambient sounds. The song is loud, lilting, chant-like, meditative, droning, hynoptic, melodious and classical. This song is a Classical Laos Folk song. | 2013-04-27T04:36:46Z | vkone kone | ຂັບທຸ້ມຫຼວງພະບາງສະບັບເກົ່າ ນຳສະແດງໂດຍຄະນະສິນລະປະວັນນະຄະດີເຮືອນວັດທະນທຳພວງຈຳປາ ເນຶ່່່ອງໃນໂອກາດໄປສະແດງທີ່ປະເທດຝຮັ່ງ. | ["Folk music", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | ["female singer", "medium fast tempo", "lilting", "chant like", "droning", "hynoptic", "folk song", "classical song", "laos classical song", "laos folk song", "melodic", "extemporaneous", "incoherent music", "live performance", "ambient auditorium sounds", "people talking", "clapping", "amateur recording", "lao folk music", "vocal backup", "small hand cymbals", "xylophone like instrument", "classical music", "laotian classical music", "chanting", "meditative", "soothing"] | 7 | 8MbxazeMw2E | 917 | |
Ave Maria by Schubert, Soprano and harpist Marsha Long | A female vocalist sings this melodious harmony. The tempo is slow with a dulcet Harp accompaniment . The song is soft, mellow, meditative, angelic, celestial,mystical, dreamy and mellifluous. This song is a Catholic prayer or salutation. | 2006-08-09T21:52:26Z | cherubofmusic | Ave Maria by Schubert performed by soprano and harpist Marsha Long | ["Music", "Opera"] | ["female singer", "slow tempo", "dreamy", "meditative", "calming", "dulcet", "high notes", "soprano", "falsetto", "buzzing sound", "harp", "female harpist", "plucking", "melodic", "celestial", "enchanting", "mystical", "enthralling", "ancient lineage instrument", "classical music", "western classical", "resonator", "oldest instrument", "latin song", "latin music", "elegy", "catholic prayer", "catholic salutation", "serene", "calming"] | 7 | ByOqw8M2U-Q | 1310 | |
Lord of the Rings - In Dreams (Soundtrack) | A female opera singer sings this soprano melody. The tempo is slow with an ethereal violin symphony accompaniment. The song is mellifluous , soft, enchanting, enigmatic, mystical, ethereal,celestial and dreamy. This is a Classic Opera. | 2011-04-11T07:29:38Z | Z7TomC7Z | (In Dreams) Main Theme of The Lord of the Rings - In Dreams (Soundtrack) Fellowship of the Ring (Theme song) (Choir) By Howard Shore Lyrics When the cold of Winter comes Starless night will cover day In the veiling of the sun We will walk in bitter rain But in dreams I can hear your name And in dreams We will meet again When the seas and mountains fall And we come to end of days In the dark I hear a call Calling me there I will go there And back again Lord of the Rings - In Dreams (Soundtrack) Chior Theme Lord of the Rings - In Dreams (Soundtrack) Chior Theme Disclaimer to rights of video. I did not take the pictures or create/write the music in this video. | ["Music", "Opera"] | ["female singer", "slow tempo", "soprano", "falsetto", "descant", "high notes", "melodic violin", "violin symphony", "cello", "viola", "orchestra", "philharmonic", "symphony orchestra", "classical music", "ethereal", "angelic", "celestial", "enthralling", "captivating", "mesmerising", "pleasant", "dreamy", "mellifluous", "enchanting", "descan", "opera singer"] | 7 | Ha-FS_CHmGw | 1818 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;