musiccaps_details (view)
5 rows where musiccaps_aspects contains "high spirited", musiccaps_author = 7 and musiccaps_names contains "Music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Zina Rifia "houbak nar" by SOFALK, ABDER, NABIL - Rai'n'B Fever 4 | A male vocalist sings this energetic pop song. The tempo is fast with piano accompaniment, bright digital drumming, synthesiser arrangements and groovy bass lines. The song is youthful, fresh, catchy, vivacious, upbeat, sprightly and buoyant with a dance groove. This song is a Hip-Hop Pop song. | 2011-05-01T14:45:49Z | Najim Sofalk | ZINA RIFIA AVEC SOFALK, ABDER, NABIL ET J-BEEZY ... MERCI POUR VOS COMMENTAIRES C'EST JUSTE ENORME !! | ["Music of Africa", "Music"] | ["male vocalist", "medium fast", "foreign language", "pop", "hip-hop pop", "groovy bass line", "lively piano", "digital drums", "synthesiser arrangements", "youthful", "spirited", "dance groove", "club music", "dance pop", "dance music", "groovy", "funky", "youthful", "high spirited"] | 7 | Jk2mvFrdZTU | 2030 | |
| Rickenbacker 4003 Chili Peppers Funk Slap Bass Thing by Carl Seager | This music is instrumental. The tempo is fast with an energetic electric guitar lead harmony. The music is emphatic, seasoned, enthusiastic,engaging and high-spirited. This music is a Hard Rock instrumental. | 2007-07-11T09:42:44Z | Carl Seager | A couple of Chilis riffs (Good Time Boys & Stone Cold Bush) altered somewhat and stuck together as an exercise. Carl's band (Flying Heroes) has a new album 'BROADCAST' out now on Amazon/iTunes/Tesco, etc. The link below will take you to their Amazon download page where you can listen to clips or buy should you like what you hear... http://www.amazon.co.uk/Broadcast/dp/B003U22M4C/ref=sr_shvl_album_1?ie=UTF8&qid=1289915365&sr=301-1 | ["Bass guitar", "Tapping (guitar technique)", "Funk", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "fast tempo", "hard rock instrumental", "electric guitar", "rock", "hard rock", "metal", "heavy metal", "minimalist", "home recording", "electric guitar lead", "electric guitar harmony", "hoe recording", "clean notes", "energetic", "high spirited", "amplified music", "stringed instrument", "sonic power", "loud guitar feedback", "room acoustics"] | 7 | YW4AKwkpYxs | 3290 | |
| Origami Rabbit by Stephen O'Hanlon | This music is an instrumental with a medium fast tempo. The music is orchestral with a lively brass band harmony, violin accompaniment, xylophone beats, a bright trombone and cello bass. The music is animated, lively, playful,whimsical, perky and puckish. | 2009-04-01T12:48:37Z | Mari Michaelis -Marigami | Download the diagram and follow along with the video! This video gives instructions for how to fold Stephen O'Hanlon's Rabbit. This cute Rabbit is quick and easy to fold and they multiply quickly. Level: low intermediate Visit www.marigami.com for links to the diagram and more origami videos. | ["Music", "Vibraphone"] | ["instrumental", "fast tempo", "orchestra", "cello", "xylophone", "animated", "whimsical", "perky", "high spirited", "violin", "trumpet", "trombone", "wind instrument", "brass instrument", "playful music", "violin harmony", "happy", "cheerful", "soothing"] | 7 | a4BjqKd8FsI | 3514 | |
| Torvill and Dean 1983 Rock n Roll OSP | This music is a high energy Rock and Roll. The tempo is fast with a vivacious electric guitar melody, punchy drumming, animated trumpets, funky bass line, keyboard and acoustic guitar accompaniment . The music is high energy, vivacious, bright, groovy,enthusiastic and animated Rock and Roll instrumental. | 2007-11-18T01:14:20Z | BJH1981 | Torvill & Dean's Rock n Roll OSP from 1983 World Championships | ["Music", "Roll", "Rock and roll"] | ["instrumental", "fast tempo", "ambient background sounds", "clapping", "live performance", "poor audio quality", "muffled music", "cheering", "people talking", "enthusiastic electronic guitar melody", "hard hitting drumming", "bright trumpeting", "groovy bass line", "rhythmic acoustic guitar", "keyboard harmony", "brass band", "wind instruments", "dance groove", "jive", "rock and roll", "retro rock", "energetic", "enthusiastic", "pulsating", "buoyant", "upbeat", "high spirited"] | 7 | fEHsR679g1M | 3934 | |
| Inno Ufficiale Torino Calcio | This song is a Latin Football team anthem. The song is medium tempo with lively keyboard, flute harmony, synthesiser arrangements , shakers and infectious drumming. The song is youthful, energetic,encouraging, celebratory, cheerful and happy. | 2012-11-30T16:01:45Z | alexone97able | Questo è l'inno a parer mio piu bello del torino | ["Music of Africa", "Music"] | ["male vocalist", "medium tempo", "italian song", "cheerful", "upbeat", "engaging", "high spirited", "italian music", "italian foot ball team", "anthem", "energetic", "enthusiastic", "cheerful", "determination", "unity", "sportsmanship", "energy", "loyalty", "fervent", "melodic spanish guitar", "infectious drumming", "lively keyboard harmony", "synthesiser arrangements"] | 7 | p4T1pddBia0 | 4686 |
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;