musiccaps_details (view)
1 row where musiccaps_aspects contains "easy listening", musiccaps_aspects contains "relaxing" and musiccaps_names contains "French horn"
This data as json, CSV (advanced)
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 |
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;