musiccaps_details (view)
3 rows where musiccaps_aspects contains "brass melody" and musiccaps_aspects contains "strings melody"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- brass melody · 3 ✖
- low quality 3
- strings melody · 3 ✖
- emotional 2
- passionate 2
- bouncy snare 1
- classical 1
- energetic 1
- exciting 1
- folk 1
- groovy bass 1
- harmonizing vocals 1
- harpsichord melody 1
- jingle 1
- live performance 1
- mellow percussions 1
- mono 1
- noisy 1
- opera 1
- passionate female vocal 1
- snare roll 1
- synth keys chords 1
- tom roll 1
musiccaps_names (array) 8 ✖
- Music 2
- Classical music 1
- Folk music 1
- Harpsichord 1
- Keyboard (musical) 1
- Opera 1
- Singing 1
- Snicker 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LAUGHTER DA MASTER SEASON 2 SEMIFINAL EPISODE 18 PART 1 OF 8 | The low quality recording features a jingle that consists of harmonizing vocals talking over snare roll, toms roll, brass melody and groovy bass, after which there is a folk song that starts playing. The folk song contains strings melody, bouncy snare, shimmering hi hats and synth keys chords. It sounds energetic and exciting, and like something you would hear on some TV show. | 2013-01-08T17:16:36Z | LaughterDaMaster2 | ["Folk music", "Music", "Snicker"] | ["harmonizing vocals", "snare roll", "jingle", "tom roll", "brass melody", "groovy bass", "low quality", "mono", "folk", "bouncy snare", "strings melody", "synth keys chords", "energetic", "exciting"] | 4 | bzOeufhFITk | 3670 | ||
3.Allegro - Concerto For Two Harpsichords In C Minor BWV 1060 J.S.BACH | The low quality recording features a classical song that consists of a harpsichord melody played over strings and brass melody. It sounds emotional and passionate. | 2009-01-17T22:14:44Z | bussinez | Allegro( 3rd mov)- Concerto For Two Harpsichords In C Minor BWV 1060 J.S.BACH Gustav Leonhardt - harpsichord; Eduard Mueller - harpsichord; Leonhardt-Consort, con. Gustav Leonhardt. High Quality Version: http://www.youtube.com/watch?v=fE7tbn6Fnw4&feature=channel_page&fmt=18 | ["Harpsichord", "Keyboard (musical)"] | ["low quality", "classical", "strings melody", "harpsichord melody", "brass melody", "passionate", "emotional"] | 4 | fE7tbn6Fnw4 | 3932 | |
Teen Opera Singer Aria Tesolin at 13 | The low quality recording features a live performance of an opera that consists of a passionate female vocal singing over strings melody, brass melody and mellow percussion. It sounds emotional and passionate. | 2007-05-17T22:15:55Z | Aria Tesolin | Teen opera singer, Aria Tesolin sings Mozart aria Voi Che Sapete. The teen talent's videos are Amazing 8 Year Old Child Opera Singing Sensation, Youngest Opera Singer in the World, & Teen Opera Singer Sings Puccini | ["Singing", "Music", "Opera", "Classical music"] | ["low quality", "noisy", "live performance", "opera", "passionate female vocal", "strings melody", "brass melody", "mellow percussions", "passionate", "emotional"] | 4 | hlHb9HwNxk8 | 4136 |
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;