musiccaps_details (view)
2 rows where musiccaps_aspects contains "buzzing sound" and musiccaps_author = 7 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- buzzing sound · 2 ✖
- ancient lineage instrument 1
- bubbling sound 1
- calming 1
- catholic prayer 1
- catholic salutation 1
- celestial 1
- classical music 1
- dissonant sounds 1
- dreamy 1
- dulcet 1
- electronic instrumentation 1
- electronic music 1
- elegy 1
- enchanting 1
- enthralling 1
- falsetto 1
- female harpist 1
- female singer 1
- harp 1
- high notes 1
- incoherent music 1
- inferior audio quality 1
- latin music 1
- latin song 1
- meditative 1
- melodic 1
- mystical 1
- oldest instrument 1
- phone vibrations 1
- plucking 1
- resonator 1
- serene 1
- slow tempo 1
- soprano 1
- steady drumming 1
- western classical 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Boiling water and mobile phone | This song is an electronic instrumental. The audio quality is poor so the music is incoherent. The song has an electronic harmony, slick drumming, dissonant buzzing and bubbling sound. | 2008-06-17T13:07:45Z | eric bany | Might be not enought to make popcorn but what about pasta | ["Liquid", "Music", "Boiling"] | ["electronic music", "buzzing sound", "bubbling sound", "dissonant sounds", "incoherent music", "inferior audio quality", "phone vibrations", "steady drumming", "electronic instrumentation"] | 7 | mzDq-abtAKs | 4508 |
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;