musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "mono" and musiccaps_names contains "French horn"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- emotional · 2 ✖
- low quality 2
- mono · 2 ✖
- noisy 2
- passionate 2
- arpeggiated guitar melody 1
- beatiful 1
- buzzy 1
- french horn melody 1
- mellow french horn melody 1
- mellow piano chords 1
- playback 1
- shimmering hi hats 1
- snappy rimshots 1
musiccaps_names (array) 3 ✖
- Brass instrument 2
- French horn · 2 ✖
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
What a wonderful world Bb Horn | The low quality recording features a french horn melody played over playback that consists of snappy rimshots, shimmering hi hats and arpeggiated guitar melody. It sounds emotional and passionate, even though the recording is in mono and noisy. | 2009-01-31T21:52:21Z | KamilToni | Playing what a wonderful world on a Berkeley Bb piccolo/ mini french horn with a strawberries and creme mouthpieces MDC from kelly mouthpieces. i wasn't feeling good and i just wanted to post something up with this instrument.. | ["Brass instrument", "French horn"] | ["low quality", "mono", "noisy", "playback", "arpeggiated guitar melody", "snappy rimshots", "shimmering hi hats", "french horn melody", "emotional", "passionate"] | 4 | MNlzpCwdh4g | 2261 | |
French horn Romance opus 36 | The low quality recording features a mellow french horn melody, followed by mellow piano chords. It sounds passionate, emotional and beautiful, despite the fact that the recording is noisy, buzzy and in mono. | 2007-11-26T14:54:40Z | Tara S | Me playing Camille Saint-Saens Solo jaarconcert Oranje Harmonie | ["Brass instrument", "French horn", "Trumpet"] | ["low quality", "noisy", "buzzy", "mono", "mellow french horn melody", "mellow piano chords", "passionate", "emotional", "beatiful"] | 4 | QIzSxE0WlKE | 2611 |
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;