musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "bass" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- acoustic guitar · 4 ✖
- bass · 4 ✖
- no percussion 3
- instrumental 2
- no other instruments 2
- no voices 2
- slow tempo 2
- accordion 1
- blues song 1
- british hip-hop music 1
- electric guitar 1
- electronic drums 1
- female voice 1
- folk song 1
- harmonica song 1
- hip 1
- male vocal 1
- piano song 1
- pop ballad 1
- pop song 1
- rapping 1
- romantic mood 1
- urban 1
- violin 1
- waltz 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Scorcher-My Diary | This is a British hip-hop music piece. There is a male vocal rapping in the lead. The beat in the background has its main melody being played by the acoustic guitar. A faint bass sound can be heard in the background. The rhythm is provided by an electronic drum beat. The atmosphere is hip and the sound is urban. This piece could be used in the soundtrack of a teenage drama movie that takes place in Great Britain. | 2007-11-06T16:36:28Z | lozyido4life | The Best version of this song | ["Reggae"] | ["british hip-hop music", "male vocal", "rapping", "acoustic guitar", "bass", "electronic drums", "hip", "urban"] | 9 | 5s0yPPrQWxs | 701 | |
Faith Hill & Carlos Santana - Breathe (High Quality) | This pop ballad features a female voice singing the main melody. This is accompanied by an acoustic guitar playing chords. An electric guitar plays a descending lick after one line. There are no other instruments in this song. The mood of this song is romantic. This song can be played in a romantic movie. | 2009-05-23T21:06:44Z | butt3rfli3z88 | I can feel the magic floating in the air Being with you gets me that way I watch the sunlight dance across your face and I've Never been this swept away All my thoughts just seem to settle on the breeze When I'm lying wrapped up in your arms The whole world just fades away The only thing I hear Is the beating of your heart 'Cause I can feel you breathe It's washing over me Suddenly I'm melting into you There's nothing left to prove Baby all we need is just to be Caught up in the touch The slow and steady rush Baby, isn't that the way that love's supposed to be I can feel you breathe Just breathe In a way I know my heart is waking up As all the walls come tumbling down I'm closer than I've ever felt before And I know And you know There's no need for words right now 'Cause I can feel you breathe It's washing over me Suddenly I'm melting into you There's nothing left to prove Baby all we need is just to be Caught up in the touch The slow and steady rush Baby, isn't that the way that love's supposed to be I can feel you breathe Just breathe Caught up in the touch The slow and steady rush Baby, isn't that the way that love's supposed to be I can feel you breathe Just breathe I can feel the magic floating in the air Being with you gets me that way | ["Singing", "Country", "Bluegrass"] | ["pop ballad", "female voice", "acoustic guitar", "bass", "electric guitar", "no percussion", "no other instruments", "pop song", "slow tempo", "romantic mood"] | 0 | VJ1RqPqF9O4 | 2990 | |
Б.Тихонов вальс "Пушинка" | This folk song features a quarter. The main melody starts off with the accordion playing an ascending run. This is accompanied by the bass playing the root and fifth of the chords. An acoustic guitar strums chords in waltz time. After the accordion part, the violin plays the main melody and the same instruments back the violin. This song can be played in a village fair. | 2010-05-26T14:23:55Z | Сергей Боганов | Концерт в К/З МГИМ им. Шнитке 27.11.09г.: "Emotion Orchestra" под руководством Ю.Медяника | ["Accordion"] | ["folk song", "waltz", "no voices", "instrumental", "violin", "accordion", "bass", "acoustic guitar", "no percussion", "no other instruments"] | 0 | pDgWT99uaJ0 | 4691 | |
How to Make Beer - 13 - Siphoning and Bottling | This blues song features a solo played on a harmonica. It starts off with the harmonica playing three descending notes. This is followed by the same three notes but the first note is played twice followed by the remaining two notes. This is accompanied by a guitar playing a rock and roll strumming pattern. The bass plays the root note of the chord. A piano plays in the background. There are no voices in this song. This song can be played in a bar scene in a movie. | 2013-02-27T07:08:18Z | thenewboston | Join our community below for all the latest videos and tutorials! Website - https://thenewboston.com/ Discord - https://discord.gg/thenewboston GitHub - https://github.com/thenewboston-developers Reddit - https://www.reddit.com/r/thenewboston/ LinkedIn - https://www.linkedin.com/company/thenewbostoncoin/ Facebook - https://www.facebook.com/thenewbostoncoin/ Twitter - https://twitter.com/thenewboston_og Instagram - https://www.instagram.com/thenewbostoncoin/ Twitch - https://www.twitch.tv/thenewboston/videos TNBC Donations: b6e21072b6ba2eae6f78bc3ade17f6a561fa4582d5494a5120617f2027d38797 | ["Harmonica", "Wind instrument, woodwind instrument"] | ["harmonica song", "acoustic guitar", "piano song", "no voices", "bass", "instrumental", "no percussion", "no voices", "blues song", "slow tempo"] | 0 | FNnKFUkFJ5M | 1641 |
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;