musiccaps_details (view)
4 rows where musiccaps_aspects contains "bad audio quality", musiccaps_aspects contains "romantic" and musiccaps_aspects contains "soloist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 62 ✖
- bad audio quality · 4 ✖
- romantic · 4 ✖
- soloist · 4 ✖
- emotional 3
- instrumental music 3
- exciting 2
- medium tempo 2
- slow tempo 2
- western classical music 2
- youtube music video 2
- accordion harmony 1
- accordion lessons 1
- accordion player 1
- acoustic guitar player 1
- acoustic love song 1
- ambient room noises 1
- bach 1
- beautiful melody 1
- bow 1
- cascade of notes 1
- cellist 1
- cello 1
- cello suite 1
- cheerful 1
- clarinetist 1
- classical guitar accompaniment 1
- classical masterpieces 1
- fingering technique 1
- great composers 1
- groovy 1
- groovy rhythm 1
- groovy sluice 1
- harp playing beautifully 1
- harpist 1
- high gain music 1
- home recording 1
- home studio recording 1
- home video 1
- latin indie song 1
- latin love song 1
- latin pop hits 1
- life is beautiful 1
- lilting music 1
- live audience 1
- live performance 1
- live recording 1
- live sessions 1
- low pitched notes 1
- madly in love 1
- male singer 1
- melancholic 1
- nostalgic 1
- passionate 1
- practice session 1
- precious moments 1
- screechy tones 1
- soulful singer 1
- soundboard 1
- string quartet 1
- strings 1
- studio session 1
- style guitar playing 1
musiccaps_names (array) 11 ✖
- Accordion 1
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Guitar 1
- Harp 1
- Music 1
- Musical instrument 1
- Plucked string instrument 1
- Singing 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
J.S.Bach - Cello Suite No.1 - Prelude - Double Bass | The song is an instrumental. The tempo is medium with a cellist playing a JS Bach tune with exemplary skill in a rehearsal session. The song has bad audio quality. The song is a western classical music tune. | 2014-09-03T19:30:44Z | TESEO | J.S.Bach - Suite No.1 for Double Bass BWV 1007 - Prelude - Plays Francesco Tesei - New Fan Page - https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Cello", "Double bass", "Bowed string instrument"] | ["cello suite", "cello", "cellist", "home video", "emotional", "passionate", "romantic", "nostalgic", "instrumental music", "medium tempo", "bad audio quality", "western classical music", "bach", "practice session", "live recording", "exciting", "low pitched notes", "strings", "soundboard", "fingering technique", "bow", "studio session", "great composers", "soloist"] | 1 | B1ixRtiUJ-U | 1194 | |
Kitty (Pogues Cover) | The song is an instrumental. The song is medium tempo with an accordion playing in an accompaniment style with both medley and harmony and no other instrumentation. The music is romantic and melancholic. The audio quality is poor. | 2007-08-03T07:52:34Z | Hale Bopp | A cover of the song Kitty by the incredible Irish punk band The Pouges on my accordion. (in a different key though) Lyrics: Oh Kitty, My Darling, remember That the doom will be mine if I stay 'Tis far better to part, though it's hard to Than to rot in their prison away 'Tis far better to part, though it's hard to Than to rot in their prison away So softly he kissed her pale lips 'Twas the same story over an o'er Hush Mavourneen, the Police are watching And you know that I must go ashore Hush now Bernie, the Police are watching And you know that I must go ashore Any day I'll be over the mountain There'll be time enough left for to cry So good night and God gaurd you forever And write to me once you get by So good night and God gaurd you forever And write to me once you get by | ["Accordion"] | ["accordion player", "accordion harmony", "youtube music video", "accordion lessons", "high gain music", "bad audio quality", "soloist", "home recording", "slow tempo", "lilting music", "emotional", "cheerful", "melancholic", "groovy", "romantic", "instrumental music", "emotional", "screechy tones"] | 1 | o1E579RL33w | 4603 | |
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 | |
Ravel Introduction et Allegro for Harp, stringquartet, flute, clarinet | The song is an instrumental. The song is in medium tempo with a harpist playing a beautiful cascade of notes while the orchestra watches. The song is exciting and passionate. The audio quality is poor. | 2008-10-20T22:15:32Z | eefkedegeus | Introduction et Allegro M. Ravel Harp, stringquartet, flute, clarinet. From left to right Mariana, Angela, David, Cristina, Eefke, Miguel, Germaine. M. Ravel - Introduction et Allegro Royal Conservatory Den Haag, Holland | ["Harp"] | ["harpist", "harp playing beautifully", "clarinetist", "string quartet", "bad audio quality", "live audience", "life is beautiful", "precious moments", "classical masterpieces", "live performance", "ambient room noises", "slow tempo", "cascade of notes", "live performance", "soloist", "western classical music", "exciting", "romantic", "instrumental music"] | 1 | u8aB6EALonk | 5091 |
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;