musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "bass" and musiccaps_names contains "Christmas music" sorted by youtube_id
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 17 ✖
- bass · 2 ✖
- conga percussion 1
- easy listening 1
- emotional song 1
- female voice 1
- folk rock 1
- folk song 1
- guitar 1
- guitar song 1
- hippie style song 1
- male voices 1
- moderate tempo 1
- organ 1
- relaxing song 1
- slow tempo 1
- story telling mood 1
- vocal harmony 1
musiccaps_names (array) 7 ✖
- Christmas music · 2 ✖
- Music 2
- Christian music 1
- Independent music 1
- Progressive rock 1
- Rock music 1
- Song 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 | |
Renaissance - Carpet of the Sun - Progressive rock 70's | This folk song features a female voice. This is accompanied by percussion played on the Congas. An acoustic guitar strums the chords. The bass plays a running bassline providing fills and giving depth to the low end of the musicscape. An organ plays chords in the background. The song has a hippie feel. This song can be used in a retro movie with a hippie movement theme. | 2011-03-26T13:31:46Z | Johnnyprogger | johnnyprogger chanel - art rock music. Listen to other progressive rock bands like Genesis, Focus, Pink Floyd, ELP, Yes, Rush, Niacin, Queen, Jehtro Tull, Kansas, Gentle Giant, Marillion, Camel, besides Deep Purple, Beatles, Iron Maiden. Carpet of the Sun (lyrics) Come along with me Down into the world of seeing Come and you'll be free Take the time to find the feeling See everything on it's own And you'll find you know the way And you'll know the things you're shown Owe everything to the day Chorus: See the carpet of the sun The green grass soft and sweet Sands upon the shores of time Of oceans mountains deep Part of the world that you live in You are the part that you're giving Come into the day Feel the sunshine warmth around you Sounds from far away Music of the love that found you The seed that you plant today Tomorrow will be a tree And living goes on this way It's all part of you and me Repeat chorus two times See the carpet of the sun See the carpet of the sun See the carpet of the sun See the carpet of the sun | ["Christmas music", "Christian music", "Music", "Rock music", "Song", "Progressive rock"] | ["folk song", "female voice", "guitar", "organ", "bass", "conga percussion", "moderate tempo", "hippie style song"] | 0 | piY4mt4F9xg | 4731 |
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;