musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "no percussion" and musiccaps_aspects contains "piano"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- bass · 2 ✖
- no percussion · 2 ✖
- piano · 2 ✖
- slow tempo 2
- easy listening 1
- french horn 1
- instrumental 1
- male voices 1
- minimal instruments 1
- no voices 1
- pop song 1
- relaxing 1
- romantic 1
- sad melody 1
- synth sounds 1
musiccaps_names (array) 5 ✖
- Brass instrument 1
- Echo 1
- French horn 1
- Music 1
- Sad music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
📯Nocturno Op. 7 [Franz Strauss] - French Horn Solo: Patrick Godfrey | This is an instrumental song featuring a french horn being played. The french horn plays the main melody. This is accompanied by a piano playing arpeggiated chords. A bass plays the root notes of the chords. There are no other instruments in this song. This is a slow tempo song. This song has a romantic and relaxing mood. This song can be played in a romantic movie. | 2015-01-09T14:58:58Z | FhornPatrick | MY STUFF: SHEET MUSIC: http://www.sellfy.com/fhornpatrick HORN’S I USE: CONN 8D: http://amzn.to/2mW3Ezn HOLTON 179: http://amzn.to/2nrmMRP YAMAHA 567: http://amzn.to/2mW3cAU YAMAHA 688: http://amzn.to/2nIbCLd MUTE: http://amzn.to/2nnqsn1 MIC’S I USE: SM 57: http://amzn.to/2nrkZMH SM 7B: http://amzn.to/2nrdgOO CASE I USE: http://amzn.to/2nrrUpl CAMERA I USE: http://amzn.to/2ojDiY6 ALTERNATIVE CAMERA: http://amzn.to/2nnqQSp LENS I USE: http://amzn.to/2nrlEOb ON CAMERA MIC: http://amzn.to/2oH8sFf PENCIL CLIP: http://amzn.to/2nrgvpw CLEANING KIT: http://amzn.to/2nrmGd1 OIL: http://amzn.to/2nrdtBD HEADPHONES: http://amzn.to/2opQCY6 BOOKS YOU NEED TO BUY: http://amzn.to/2ojr95D http://amzn.to/2nngaDq http://amzn.to/2nrmGd1 http://amzn.to/2nniASl http://amzn.to/2nnq08g SnapChat: FhornPatrick Facebook: https://www.facebook.com/FhornPatrick Twitter: https://twitter.com/fhornpatrick Instagram: http://instagram.com/fhornpatrick | ["Brass instrument", "French horn"] | ["french horn", "piano", "bass", "no percussion", "no voices", "instrumental", "romantic", "easy listening", "relaxing", "slow tempo"] | 0 | aC3IBcRNyro | 3518 | |
Echo | Big Hero 6 - Sad Moments | Music Video | This slow song features a male voice singing the main melody at a comfortable pitch. The tone of the voice is emotional. This is accompanied by a bass playing the root notes of the chords. After one line, a synth swell is played. A piano plays the backing chords. The mood of this song is sad. This song can be played in a sad scene in a movie. | 2015-01-28T01:11:42Z | JoshuaMacTree | **THIS IS A NON-PROFIT VIDEO and is made purely for fun. No copyright infringement intended. All footage belongs to: Big Hero 6 (2014)** MY TWITTER: https://twitter.com/JoshMacTree?lang=en-gb Hey guys! Today I'm bringing you another Music Video for the incredible film, Big Hero 6. This time it's quite a sad video, I've taken some of the best sad parts of the film and put them together so I hope you like it ^_^ WARNING: There are spoilers in this Music Video so if you don't want the Movie in any way ruined for you please avert your eyes! xD Song: Echo Echo - Jason Walker (I do NOT own the music) Movie: Big Hero 6 (I do NOT own the Movie xD) Thanks for watching guys & I will see you next time, Josh :) | ["Echo", "Music", "Sad music"] | ["pop song", "piano", "male voices", "bass", "synth sounds", "sad melody", "no percussion", "slow tempo", "minimal instruments"] | 0 | oynXCFZWxnI | 4672 |
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;