musiccaps_details (view)
5 rows where "youtube_published" is on date 2011-04-03
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 46 ✖
- emotional 2
- low quality 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
- calming 1
- country music 1
- dance hits 1
- easy listening 1
- emotional song 1
- female vocal 1
- flat male 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
- mono 1
- noisy 1
- passionate 1
- percussive bass line 1
- poor audio quality 1
- pop hits 1
- quiet bowl resonating sounds 1
- relaxing song 1
- romantic 1
- slow tempo 1
- spirited 1
- story telling mood 1
- touching 1
- tutorial 1
- various percussion hits 1
- wide choir female vocals 1
- xylophone 1
musiccaps_names (array) 11 ✖
- Music 3
- Pop music 2
- Christmas music 1
- Country 1
- Independent music 1
- Maraca 1
- New-age music 1
- Psychedelic rock 1
- Rock music 1
- Singing 1
- Singing bowl 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 | |
klankschalen massage | The low quality recording features a quiet bowl resonating sounds and even though the recording is so noisy and in mono, it is still calming. | 2011-04-03T19:10:15Z | pluddeku | ["Singing bowl"] | ["low quality", "mono", "noisy", "quiet bowl resonating sounds", "calming"] | 4 | _6C2ffY_-mc | 3444 | ||
Conrad Doll Short Log Carrier by Cranes Etc TV | The low quality recording features a wide choir female vocals singing, while there is a flat male vocal talking over it. It sounds like a tutorial of sorts. | 2011-04-03T11:42:13Z | CranesEtcTV | This is the Cranes Etc TV review of Conrad's model of a Doll Short Log Carrier in 1/50 scale. The model number is 72183. The full review is on the Cranes Etc website: http://www.CranesEtc.co.uk. | ["New-age music"] | ["wide choir female vocals", "flat male vocal", "low quality", "tutorial"] | 4 | aSyRV5j2zV4 | 3540 | |
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;