musiccaps_details (view)
2 rows where musiccaps_aspects contains "new age" and musiccaps_aspects contains "organ accompaniment"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- melancholic 2
- new age · 2 ✖
- organ accompaniment · 2 ✖
- abstract 1
- art music 1
- celestial 1
- celtic folk music 1
- celtic new age 1
- delicate 1
- documentary soundtrack 1
- downtempo 1
- electronic 1
- emotional 1
- enigmatic 1
- ethereal 1
- experimental 1
- female singer 1
- haunting 1
- inspirational 1
- instrumental music 1
- keyboard accompaniment 1
- meditative 1
- mellow 1
- memdium tempo 1
- modern classical 1
- moog bass 1
- motivational 1
- mysterious 1
- opera 1
- playful 1
- poignant 1
- soft 1
- song introduction 1
- strong bass line 1
- sublime 1
musiccaps_names (array) 3 ✖
- Music 2
- Harmonic 1
- New-age music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tom Dugan's Backyard bmx fun | The song is an instrumental. The song is medium tempo with a moog bass accompaniment, keyboard organ tone and a strong bass line. The song is emotional and poignant. The song is a new age pop soundtrack. | 2011-12-13T22:50:28Z | MrBMXBEAST666 | Uploaded by brycejrich on Aug 16, 2011 A session of the half built backyard at the 316 House, Austin, Texas. Tom Dugan, Cody Nutter, Joeseph Franz, Levi Brewer, Jared Allen Swafford, Danny Hickerson, Will, Mike McFrench Molineri, Jay, Cassie Nutter, Daria Nutter (the Puppy Dog) and friend. | ["Music", "Harmonic"] | ["moog bass", "keyboard accompaniment", "experimental", "experimental", "abstract", "art music", "documentary soundtrack", "instrumental music", "memdium tempo", "organ accompaniment", "strong bass line", "emotional", "melancholic", "poignant", "playful", "inspirational", "motivational", "new age", "song introduction"] | 1 | BWSJjF32tQA | 1249 | |
Enya - Evening Falls | A female vocalist sings this delicate harmony. The tempo is slow with an organ accompaniment. It is soft, mellow, meditative, enigmatic, mysterious, melancholic and haunting. This song is a Modern Classical. | 2006-11-01T15:54:46Z | Servet Tonga | Evening Falls video clip | ["New-age music", "Music"] | ["female singer", "opera", "organ accompaniment", "enigmatic", "mysterious", "soft", "mellow", "ethereal", "celestial", "new age", "meditative", "modern classical", "downtempo", "electronic", "melancholic", "celtic new age", "celtic folk music", "delicate", "haunting", "sublime", "soft", "mellow", "delicate"] | 7 | _nrz_BawPMY | 3492 |
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;