musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "folk rock" and musiccaps_names contains "Independent music" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- folk rock · 2 ✖
- acoustic drums 1
- bass 1
- bass guitar 1
- chill 1
- easy listening 1
- electric guitar 1
- emotional song 1
- guitar song 1
- keyboard 1
- male vocal 1
- male voices 1
- melodic singing 1
- psychedelic 1
- psychedelic rock 1
- relaxing song 1
- slow tempo 1
- story telling mood 1
- trippy 1
- vocal harmony 1
musiccaps_names (array) 3 ✖
- Independent music · 2 ✖
- Music 2
- Christmas music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Donovan - Wear your love like heaven. | This is a psychedelic rock music piece. There is a male vocalist singing melodically in the lead. The main melody is being played by the keyboard with the backing of the electric guitar and the bass guitar. The rhythmic background consists of a rock acoustic drum beat. The atmosphere is chill and trippy. This piece could be used in the soundtrack of a drama movie or a TV series that has scenes of hallucinogenic trip sequences. It could also be playing in the background at a hippie coffee shop. | 2007-08-27T17:00:17Z | Zack Taylor | Note: I do not own any of the content in this video Please support me by clicking the ads on my videos :) Thanks Donovan - Wear your love like heaven. Peace out. | ["Music", "Independent music"] | ["psychedelic rock", "folk rock", "male vocal", "melodic singing", "electric guitar", "keyboard", "bass guitar", "acoustic drums", "chill", "trippy", "psychedelic"] | 9 | 5i0zq91Ocz0 | 684 |
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;