musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "electric guitar" and musiccaps_aspects contains "joyful" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 27 ✖
- bass guitar 3
- electric guitar · 3 ✖
- joyful · 3 ✖
- acoustic guitar 2
- male vocals 2
- acoustic drums 1
- acoustic sounding drums 1
- country music 1
- cozy 1
- danceable 1
- doo wop 1
- easygoing 1
- energetic 1
- female vocal 1
- generic 1
- harp 1
- instrumental 1
- keyboard 1
- live performance 1
- melodic singing 1
- no singer 1
- pop-rock 1
- positive 1
- rock 1
- simple tune 1
- ukulele 1
- upbeat 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Videos - Trickle Trickle | This is a doo wop music piece. There are male vocals singing melodically. The main tune is being played by the electric guitar and the keyboard while the bass guitar is playing in the background. The rhythm is provided by the acoustic drums. The atmosphere is danceable and joyful. This piece could be playing at a dance club for an oldies night. | 2009-03-10T17:37:32Z | chargertom | Oldies favorite "Trickle Trickle" by The Videos. Another record selection from the Oldies Jukebox at www.fhs1961.com | ["Music", "Ska"] | ["doo wop", "rock", "male vocals", "melodic singing", "electric guitar", "bass guitar", "keyboard", "acoustic drums", "danceable", "energetic", "joyful"] | 9 | KV99GJg0tvA | 2089 | |
❤ My Morning Routine ❤ | This is an instrumental pop-rock piece. There is a harp playing the main melody while a ukulele is strumming chords. An electric guitar and a bass guitar join the melodic background later on. A simple acoustic drum beat is in the rhythmic background. It has a joyful aura, but the sounds used are very generic. The best use for this piece could be the background of a tutorial/instructive type of video. | 2013-03-28T02:56:49Z | Ashley Love | My morning routine is finally up! Enjoy :) Thanks for watching. Subscribe to make my day. Instagram: Ashley_Tan13 Twitter: AshleyLovesx My previous video: http://www.youtube.com/watch?v=IlYuPAAD7AI Ask me questions here: http://www.spillit.me/ashleylovesx Subscribe to my friend(Mark O'dea), he is an amazing singer!! Check him out :) http://www.youtube.com/user/markodea/videos?view=0 Love, Ashley | ["Music", "Ukulele"] | ["pop-rock", "no singer", "instrumental", "ukulele", "harp", "electric guitar", "bass guitar", "acoustic guitar", "generic", "joyful", "positive"] | 9 | Mwy5Y0S5jfM | 2311 | |
Mandolin Bridge Part 1 | This is the live performance of a country music piece. There is a female vocal and two male vocals taking turns and sometimes singing the words at the same time. The melody consists of an electric guitar, an acoustic guitar and a bass guitar while in the rhythmic background there is an acoustic sounding upbeat drum beat. The atmosphere is cozy. There is an easygoing aura to it. This piece could be used in the soundtrack of a movie or a TV show that takes place in rural USA. | 2014-04-08T18:01:39Z | janrohan | This video is about the Mandolin Bridge band Ohio -- rocking country, dance and oldies! Visit us at www.mandolinbridge.com ! | ["Singing", "Country", "Music", "Mandolin", "Ska", "Song"] | ["country music", "female vocal", "male vocals", "electric guitar", "acoustic guitar", "acoustic sounding drums", "bass guitar", "simple tune", "easygoing", "cozy", "joyful", "upbeat", "live performance"] | 9 | QSaX7QfeWog | 2620 |
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;