musiccaps_details (view)
8 rows where musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "youtube music video"
This data as json, CSV (advanced)
musiccaps_aspects (array) 107 ✖
- medium tempo · 8 ✖
- youtube music video · 8 ✖
- emotional 6
- instrumental music 6
- soloist 4
- dance rhythm 3
- passionate 3
- poor audio quality 3
- ambient room noises 2
- average audio quality 2
- bad audio quality 2
- exciting 2
- home video 2
- male singer 2
- no percussions 2
- romantic 2
- spirited 2
- virtuoso 2
- acoustic guitar player 1
- acoustic love song 1
- acoustic song 1
- adventure music 1
- adventurous 1
- amateur play 1
- amateur player 1
- ambient echoes 1
- backing track 1
- bass drum 1
- beautiful melody 1
- bowing technique 1
- celtic music influences 1
- cheerful 1
- classical guitar accompaniment 1
- classical music 1
- cool melody 1
- country music 1
- disc scratching tones 1
- dj 1
- drum sticks 1
- drums demonstration 1
- electric guitar 1
- enthusiastic 1
- folk music 1
- freestyle disc scratching 1
- groovy 1
- groovy music 1
- groovy rhythm 1
- groovy sluice 1
- guitar amplifier 1
- guitar amplifiers 1
- guitar demo 1
- guitar demonstration 1
- guitar lessons online 1
- guitar played accompaniment style 1
- guitar solo 1
- guitar strumming rhythm 1
- happy 1
- hissing tones 1
- hobbyist 1
- home music video 1
- home music video 1
- home studio recording 1
- indie music 1
- irish jig 1
- laitin dance hits 1
- latin dance rhythm 1
- latin indie song 1
- latin love song 1
- latin pop hits 1
- learner 1
- legato playing 1
- live performance 1
- live sessions 1
- madly in love 1
- male singer chants 1
- mandolin playing 1
- melancholic music 1
- mode music video 1
- music demo 1
- music video 1
- no other instrumentation 1
- online music videos 1
- people dancing 1
- percussion practice 1
- pizzicato 1
- poignant 1
- positive 1
- practice session 1
- raspy notes 1
- recital 1
- sax cover 1
- sax tonguing 1
- saxophone lessons online 1
- soulful singer 1
- steady rhythm 1
- strumming chords 1
- style guitar playing 1
- subtle bass line 1
- suspense 1
- techno dance rhythm 1
- tenor sax 1
- tone generator 1
- vibrato style 1
- vinyl disc 1
- violin music 1
- violinist 1
- vocal chants 1
musiccaps_names (array) 25 ✖
- Music 6
- Musical instrument 4
- Guitar 3
- Plucked string instrument 3
- Electric guitar 2
- Banjo 1
- Bowed string instrument 1
- Brass instrument 1
- Chorus effect 1
- Drum 1
- Drum machine 1
- Effects unit 1
- Mandolin 1
- Percussion 1
- Pizzicato 1
- Rattle (instrument) 1
- Reverberation 1
- Saxophone 1
- Scratch 1
- Scratching (performance technique) 1
- Singing 1
- Strum 1
- Tapping (guitar technique) 1
- Violin, fiddle 1
- Zither 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Freestyle scratch | The song is an instrumental. The song is medium tempo with a groovy drum rhythm, vinyl disc scratching tones and a percussive bass line. The song is energetic and groovy. The audio quality is very poor with a lot of hissing noise. | 2007-10-28T20:37:08Z | DjSplen | Freestyle sur instru /le Jad breakbeat... | ["Scratching (performance technique)", "Music", "Scratch", "Drum machine"] | ["dj", "practice session", "vinyl disc", "youtube music video", "disc scratching tones", "home music video", "freestyle disc scratching", "groovy", "dance rhythm", "poor audio quality", "ambient room noises", "instrumental music", "people dancing", "techno dance rhythm", "hissing tones", "medium tempo"] | 1 | 2uvHgwAljPA | 414 | |
ジャズコーラスの音色とマーシャルガバナーの威力 | The song is an instrumental. The song is medium tempo with an electric guitar playing chords and strumming rhythm with no other instrumentation. The song is emotional and interesting. The song is probably a demo of a guitar or guitar amplifier. The audio is average quality. | 2011-10-24T16:02:01Z | yskpai81 | ガバナー大好き。 http://mixi.jp/view_diary.pl?id=1786483877&owner_id=11016145 ↑これです。昔は四角い形だったのに、今は流線型のボディになってます。 音は昔の方が良かったような気がします。 | ["Effects unit", "Electric guitar", "Guitar", "Music", "Musical instrument", "Chorus effect", "Plucked string instrument"] | ["electric guitar", "strumming chords", "virtuoso", "guitar lessons online", "guitar strumming rhythm", "guitar amplifiers", "guitar demonstration", "live performance", "youtube music video", "average audio quality", "medium tempo", "instrumental music", "emotional", "spirited", "soloist", "ambient room noises"] | 1 | 2xATintzaj4 | 420 | |
Mandolin Madness | The song is an instrumental. The song is a medium tempo with a mandolin player playing a cheerful melody with no other instrumentation. The song is positive and has a delightful dance rhythm. The song has an average audio quality. | 2013-10-15T23:19:40Z | Kimsey Lutherie | A compilation of all my mandolin videos- just playing, no talking. Elkhorn, Gilchrist, Kentucky, Krishot, Weber, Stanley. | ["Banjo", "Music", "Mandolin"] | ["mandolin playing", "instrumental music", "medium tempo", "online music videos", "folk music", "youtube music video", "soloist", "hobbyist", "emotional", "country music", "dance rhythm", "celtic music influences", "irish jig", "no percussions", "music video", "average audio quality", "amateur player", "happy", "positive", "dance rhythm", "cheerful", "music demo"] | 1 | 4vsI0Kwn8jY | 618 | |
tema:ni tu ni yo,art: la barra (cuarteto) fctambora. | The song is an instrumental. The song is medium tempo with a percussionist practising Latin bass drums with a drum stick to a music track with male vocals, trumpet harmony and other percussion. The audio quality is poor and boomy. | 2012-09-12T01:14:54Z | fernando castro | ["Drum", "Music", "Musical instrument", "Rattle (instrument)", "Percussion"] | ["percussion practice", "male singer", "backing track", "vocal chants", "exciting", "dance rhythm", "enthusiastic", "passionate", "drums demonstration", "steady rhythm", "latin dance rhythm", "male singer chants", "laitin dance hits", "bass drum", "drum sticks", "youtube music video", "groovy music", "medium tempo"] | 1 | CHo8wKj9J1w | 1347 | ||
1964 Fender Deluxe Reverb + 1999 Fender 52 Vintage Telecaster Part2 | The song is an instrumental. The song is medium tempo with a guitar playing solo accompaniment style, with a subtle bass line. The song is entertaining and passionate. The song audio quality is poor with a lot of ambient echoes. | 2010-03-17T17:54:45Z | GregsGuitars | 1964 Fender Deluxe Reverb is an original vintage amp - not Reissue. Tele has a Texas Special Pickup at the neck and a nocaster bridge pickup. Okko Diablo Custom made overdrive pedal with 3 channels www.gregorhilden.de | ["Reverberation", "Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "poor audio quality", "guitar solo", "ambient echoes", "guitar played accompaniment style", "guitar amplifier", "tone generator", "subtle bass line", "home video", "youtube music video", "soloist", "guitar solo", "exciting", "adventurous", "guitar demo", "passionate", "medium tempo", "emotional", "adventure music"] | 1 | DUNOn71oGCw | 1482 | |
CCB sax tenor hino 119 | The song is an instrumental. The song is medium tempo with a tenor saxophone playing a lilting melody in legato style. The song has no other instrumentation support. The audio quality is very poor. | 2010-01-07T21:22:33Z | Lucas Cerqueira | CCB sax tenor hino 119 | ["Brass instrument", "Saxophone"] | ["tenor sax", "amateur play", "legato playing", "poor audio quality", "saxophone lessons online", "recital", "vibrato style", "instrumental music", "no other instrumentation", "sax tonguing", "emotional", "romantic", "home video", "bad audio quality", "learner", "youtube music video", "sax cover", "passionate", "spirited", "classical music", "passionate", "no percussions", "medium tempo"] | 1 | m--xEFqqrLc | 4434 | |
Colby O'Donis - What You Got | A male Latin singer sings this romantic melody. The song is medium tempo with an acoustic guitar accompaniment with no other instrumentation. The song is emotional and passionate. The audio quality is poor. | 2009-02-04T21:16:04Z | esmusicatv | http://www.facebook.com/pages/ES-Musica-TV/107227706027532 And I like the way you take advantage of every man you love I see, I seem to know your game girl But I don't mind if ya come and play ya thug just don't talk too much I see, I see it so you don't have to say a word Yeah those guys wanna come treat ya right Cause you're sweeter than apple pie Everything that you want you got Girl you know that you need to stop Most beautiful thing in sight Always takin' on the spotlight Always in the club lookin hot Girl you know that you need to stop Always talkin' bout what you got Always talkin' bout what you got Always talkin' bout what you got Girl you know that you need to stop Always talkin' bout what you got Always talkin' bout what you got Always talkin' bout what you got Girl you know that you need to stop Girl I can tell you want something to love That's why you hold on to everything that pass you by Can't resist girl one can't lie Now tell if you are here for me Or everybody watchin' you shake from left to right The way you move got me hypnotized | ["Singing", "Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["acoustic guitar player", "soulful singer", "live sessions", "youtube music video", "medium tempo", "latin love song", "latin pop hits", "groovy rhythm", "beautiful melody", "latin indie song", "home studio recording", "style guitar playing", "emotional", "romantic", "groovy sluice", "soloist", "acoustic love song", "bad audio quality", "madly in love", "classical guitar accompaniment", "male singer"] | 1 | oxhFIoExrMk | 4670 | |
Hannah Epperson - Shadowless (Acoustic) | The song is an instrumental. The tempo is medium with a violinist playing a poignant melody with pizzicato played at the beginning. The song is emotional and poignant. The song is a YouTube music video. | 2013-04-26T02:26:22Z | Artino Ahmadi | Director & DOP - Artino Ahmadi http://www.freshninjafilms.com Special thanks to: Samantha Soo Ian Macdonald Alexander Marusyk | ["Zither", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["pizzicato", "violinist", "instrumental music", "violin music", "youtube music video", "virtuoso", "mode music video", "home music video", "indie music", "acoustic song", "medium tempo", "poignant", "suspense", "emotional", "cool melody", "raspy notes", "bowing technique", "melancholic music"] | 1 | vfMEPOl1Wqw | 5195 |
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;