musiccaps_details (view)
3 rows where musiccaps_aspects contains "marimba" and musiccaps_aspects contains "trumpets" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- marimba · 3 ✖
- trumpets · 3 ✖
- bad sound quality 1
- brass band 1
- dance music 1
- drums 1
- flute 1
- groovy rhythm 1
- harp 1
- home music video 1
- horns 1
- instrumental squid 1
- latin dance hits 1
- latin dance music 1
- latin percussions 1
- low quality audio 1
- male singer 1
- male voice 1
- marching beat 1
- medium tempo 1
- orchestra 1
- people dancing 1
- saxophone harmony 1
- saxophones 1
- symphonic song 1
- syncopated rhythms 1
- traditional latin dance 1
- trombone 1
- tuba 1
- violins 1
- wooden xylophone 1
- yodeling 1
musiccaps_names (array) 10 ✖
- Brass instrument 1
- Drum 1
- Drum roll 1
- Music 1
- Percussion 1
- Saxophone 1
- Snare drum 1
- Song 1
- Steelpan 1
- Yodeling 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Home on the Range "Yodle Adle Eedle Idle Oo" Russian | The music features for the most part an instrumental but almost at the end of the excerpt a male voice starts to yodel. Up to that point the melody is being played by a marimba, then trumpets and horns, possibly trombones too. A tuba is holding the beat pulsation in the low register. At the end of the excerpt a harp can be heard. | 2008-07-01T06:11:14Z | Titania1989 | =) | ["Yodeling", "Music", "Song", "Steelpan"] | ["trumpets", "marimba", "horns", "tuba", "drums", "yodeling", "male voice", "harp"] | 2 | F5e-SEICJP4 | 1612 | |
John Williams Oscars 2002 | This symphonic song starts off with a melody featuring a flute, marimba and violins. The mood of this song is happy. After three bars, a snare drum plays a marching beat. This is followed by a melody played on trumpets and trombone. There are no voices in this song. This song can be played at the intro of a movie. | 2010-06-05T17:50:19Z | oQueequego | A tribute to Original Scores for motion pictures, arranged and conducted by composer John Williams. From the following movies: Casablanca, Citizen Kane, 20th Century Fox Fanfare, Star Wars, The Sea Hawk, Spellbound, Titanic, Psycho, Jaws, The Pink Panther, Exodus, Out of Africa, Doctor Zhivago, Bridge on the River Kwai, Patton, Rocky, The Magnificent Seven, The Natural, Cinema Paradiso, The Godfather, ET, Gone With the Wind | ["Drum", "Drum roll", "Snare drum", "Percussion"] | ["symphonic song", "orchestra", "marching beat", "flute", "marimba", "low quality audio", "violins", "trumpets", "trombone"] | 0 | 7_0g3tEcM0w | 860 | |
Marimba Perla de Chiapas 2010 abeja miope | The song is an instrumental. The tempo is medium with a brass including trumpets and saxophones playing in harmony, wooden xylophones and Latin percussions play accompaniment to the band along with a male singer. The song is exciting and groovy. The audio quality is poor and probably a home recording. | 2010-01-15T12:34:08Z | Jawar TresCeros | Marimba Perla de Chiapas 2010 abeja miope | ["Brass instrument", "Saxophone"] | ["marimba", "latin dance music", "saxophones", "medium tempo", "instrumental squid", "traditional latin dance", "brass band", "trumpets", "groovy rhythm", "syncopated rhythms", "dance music", "people dancing", "male singer", "saxophone harmony", "wooden xylophone", "bad sound quality", "home music video", "latin dance hits", "latin percussions", "medium tempo"] | 1 | gb8PG-5i5YI | 4040 |
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;