musiccaps_details (view)
4 rows where musiccaps_aspects contains "romantic" and musiccaps_names contains "Ukulele"
This data as json, CSV (advanced)
musiccaps_aspects (array) 60 ✖
- romantic · 4 ✖
- duet 2
- emotional 2
- love song 2
- male singer 2
- sentimental 2
- acoustic 1
- acoustic guitar 1
- amateur singer 1
- animated singing 1
- bad audio quality 1
- band audio quality 1
- calming 1
- country hits 1
- country pop 1
- easygoing 1
- emphatic vocals 1
- energetic acoustic guitar 1
- female vocal 1
- folk music 1
- folk pop 1
- friendship 1
- groovy bass line 1
- heartfelt 1
- home music video 1
- inspiring 1
- jealous 1
- lively piano accompaniment 1
- male vocal 1
- mandolin 1
- medium fast tempo 1
- medium tempo 1
- mellifluous 1
- mellow 1
- melodious 1
- memdium tempo 1
- modern pop hits 1
- nylon string guitar 1
- orchestra 1
- orchestral string harmony 1
- passionate 1
- pop 1
- pop music 1
- pop song 1
- pop song cover 1
- simple melody 1
- simple tune 1
- soft 1
- song cover 1
- spirited spanish guitar 1
- story telling 1
- string instruments 1
- string symphony 1
- touching 1
- ukelele 1
- ukulele 1
- ukulele accompaniment 1
- ukulele playing rhythm 1
- vibrant ukelele harmony 1
- youtube music video 1
musiccaps_names (array) 6 ✖
- Music 4
- Ukulele · 4 ✖
- Singing 3
- Musical instrument 2
- Mandolin 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Ukulele Orchestra of Great Britain - "Wuthering Heights" | A male vocalist sings this animated song. The tempo is medium with vocal emphasis, a bright ukelele harmony, groovy bass guitar, rhythmic acoustic guitar and piano accompaniment. The song is emphatic, passionate, jealous, emotional, sentimental and story telling. The song has an orchestral vibe. | 2010-01-22T08:50:38Z | rud1e | The Ukulele Orchestra of Great Britain - "Wuthering Heights" from the DVD 'Anarchy in the Ukulele', available to buy from http://www.ukuleleorchestra.com | ["Singing", "Music", "Ukulele"] | ["male singer", "medium fast tempo", "romantic", "sentimental", "spirited spanish guitar", "energetic acoustic guitar", "nylon string guitar", "lively piano accompaniment", "animated singing", "emphatic vocals", "story telling", "love song", "vibrant ukelele harmony", "passionate", "jealous", "orchestra", "orchestral string harmony", "string symphony", "groovy bass line"] | 7 | FF0VaBxb27w | 1629 | |
1234/Best I Ever Had - Ukulele Cover (AJ Rafael Jenny Suk) | AJ Rafael | This is a pop music piece performed acoustically. The male and female vocals take turns singing melodically as a duet. The simple melody is being played by a ukulele. The aura of the song is very calm and easygoing. It could be used in the soundtrack of a teenage drama. The music could be playing in the background at a coffee house. | 2009-09-05T09:14:07Z | AJ Rafael | plain white t's and drake. in one sitting. ukulele cover =] check out jenny suk http://youtube.com/msxjenixe http://twitter.com/jensuki and me =] http://youtube.com/ilajil http://youtube.com/yeeitsaj http://myspace.com/ajrafael http://twitter.com/ajrafael Walk Now for Autism 2009 Orange County Chapter Join TEAM MUSIC SPEAKS! http://walknowforautism.org/orangecounty/musicspeaks walk with us! and if you're unable to walk with us on November 14, 2009 at the Anaheim Angels Stadium, please donate! -AJ booking: ajrafaelmusic@gmail.com. About AJ Rafael Hey! I’m AJ Rafael and welcome to my channel. I am passionate about music, performing, Disney and creating YouTube content to share with you. Ever since I can remember I have been creating music, playing instruments and performing. Though I love playing the piano and guitar, I also love trying out unique instruments to create new and original sounds for every song I create. On this channel you will find unique music videos, like my original music, “She Was Mine” and “Without You” and musical medleys, like “My Disney Mashup.” If you like what you see make sure you click SUBSCRIBE so you don’t miss a single note! | ["Singing", "Music", "Musical instrument", "Ukulele"] | ["pop music", "acoustic", "male vocal", "female vocal", "duet", "simple tune", "ukulele", "easygoing", "calming", "romantic"] | 9 | GSAMEMX_oAg | 1724 | |
Ukulele Tutorial #54 (Count On Me, Bruno Mars) | A male singer sings this popular song. The tempo is medium with an ukulele playing rhythm accompanying the male vocals with no other instrumentation. The song is emotional and inspiring. The audio quality is bad. | 2010-07-06T19:06:01Z | Krankthat22 | NEW WEBSITE is up and running! Check it out and let me know what you think!! Feedback is much appreciated! Thank me later. Click here now! http://tinyurl.com/Krankthat22 Em - 0432 C - 0003 Am - 2000 F - 2010 Dm - 2210 G - 0121 verse/chorus C Em Am G F bridge #1 Dm Em F G Bridge #2 ("a shoulder to cry on" part of lyrics) Dm G C G | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["male singer", "ukulele accompaniment", "bad audio quality", "inspiring", "amateur singer", "ukulele playing rhythm", "memdium tempo", "song cover", "emotional", "love song", "romantic", "touching", "youtube music video", "friendship", "touching", "heartfelt", "pop song", "pop song cover", "modern pop hits", "band audio quality", "home music video"] | 1 | MpjN21Z93JY | 2302 | |
Mandolin Orange - Wake Me @Pickathon 2014 On The Farm | This song is a pleasant love song duet. The tempo is medium with acoustic guitar and ukulele accompaniment.the song is mellow, soft, emotional, romantic, nostalgic. This song is Country/Folk pop. | 2015-01-29T23:15:41Z | Pickathon | http://pickathon.com/ Presents Mandolin Orange live at Pendarvis Farm. Filmed on August 2, 2014 Channel Host: http://Grist.org Song: Wake Me Record Label: http://www.redeyeusa.com/ Producer: Ryan Stiles Executive Producer: Zale Schoenborn Associate Producer: Eric Schoenborn, Terry Groves, Ned Failing, John MacArthur Production Manager: Seth Chandler Production Coordinator: Alisha Flaumenbaum Editor: Stephanie Manzo Camera: Emilee Booher Audio/Co-Producer: Dylan McNab http://www.mandolinorange.com/ http://pickathon.com | ["Singing", "Music", "Mandolin", "Ukulele"] | ["duet", "medium tempo", "ukelele", "folk pop", "folk music", "mellifluous", "simple melody", "country pop", "country hits", "string instruments", "folk music", "acoustic guitar", "mandolin", "melodious", "pop", "country pop", "mellifluous", "romantic", "emotional", "sentimental", "soft", "mellow"] | 7 | n1fY-23ffl0 | 4513 |
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;