musiccaps_details (view)
3 rows where search matches "guitar" and "youtube_published" is on date 2011-04-03
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- emotional 2
- medium tempo 2
- vocal harmony 2
- acoustic drums 1
- african rhythms 1
- backup singers 1
- bad audio quality 1
- bass 1
- bass guitar 1
- country music 1
- dance hits 1
- easy listening 1
- emotional song 1
- female vocal 1
- folk rock 1
- groovy dance rhythm 1
- groovy drumming rhythm 1
- guitar rhythm 1
- guitar song 1
- high pitched singing 1
- inspiring 1
- love song 1
- male singer 1
- male voices 1
- mandolin 1
- medium-to-high pitch singing 1
- passionate 1
- percussive bass line 1
- poor audio quality 1
- pop hits 1
- relaxing song 1
- romantic 1
- slow tempo 1
- spirited 1
- story telling mood 1
- touching 1
- various percussion hits 1
- xylophone 1
musiccaps_names (array) 9 ✖
- Music 3
- Pop music 2
- Christmas music 1
- Country 1
- Independent music 1
- Maraca 1
- Psychedelic rock 1
- Rock music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Academy of Country Music Awards - Road to ACM Award - Band Perry Takes Vegas! | This is a country music piece. There is a female vocalist singing melodically as the lead at a medium-to-high range. A mandolin is playing the main theme while being backed by a bass guitar. The rhythmic background consists of a simple 4/4 acoustic drum beat. | 2011-04-03T18:39:30Z | CBS | Follow The Band Perry as they take on Vegas! Tune into the ACM Awards Sunday, April 3 at 8/7c | ["Country", "Music", "Psychedelic rock", "Pop music", "Rock music"] | ["country music", "female vocal", "medium-to-high pitch singing", "mandolin", "acoustic drums", "bass guitar", "touching", "emotional", "inspiring", "medium tempo"] | 9 | 2OI4QeokeRQ | 360 | |
Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) | A male singer sings this passionately with backup singers in vocal harmony. The song is medium tempo with a steady drumming rhythm, various percussion, percussive bass line, guitar rhythm and keyboard harmony . The song is passionate and romantic with a cool dance groove. The song has poor audio quality. | 2011-04-03T16:51:56Z | NaaKwame | Kwabena Kwabena - Odo Nkoa (Feat. Kofi B) Album: Dabi | ["Singing", "Music", "Pop music", "Maraca"] | ["male singer", "backup singers", "african rhythms", "poor audio quality", "guitar rhythm", "xylophone", "vocal harmony", "groovy drumming rhythm", "percussive bass line", "various percussion hits", "medium tempo", "groovy dance rhythm", "pop hits", "dance hits", "love song", "passionate", "emotional", "spirited", "bad audio quality", "high pitched singing", "romantic"] | 1 | IPO79GrOYjg | 1904 | |
Mass Effect 2 - Sounds of Silence by Simon & Garfunkel | This folk rock song features two male voices singing in harmony. This is accompanied by a guitar playing a fingerpicking pattern. The bass plays the root notes of the chords. There is no percussion in this song. The voices are calming and the song is relaxing to listen to. The voice sings in a story-telling mood. This song can be played in a coming of age movie. | 2011-04-03T18:18:33Z | charming Charlie | A user called chaosapiant over at Bioware Social requested "Sounds of Silence". So I thought I would give it a go, hope you like it. Beware there are spoilers from the Arrival DLC in the video. | ["Christmas music", "Music", "Independent music"] | ["folk rock", "guitar song", "male voices", "vocal harmony", "slow tempo", "bass", "story telling mood", "emotional song", "relaxing song", "easy listening"] | 0 | iqEQBCrOLWc | 4219 |
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;