musiccaps_details (view)
6 rows where search matches "guitar", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "piano" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- acoustic guitar · 6 ✖
- piano · 6 ✖
- e-bass 3
- male voice singing 3
- acoustic drums 2
- female voice singing 2
- medium tempo 2
- medium to uptempo 2
- upright bass 2
- backing track 1
- banjo 1
- brass 1
- country 1
- digital drums 1
- digital keyboard song 1
- dreamy 1
- e-guitar 1
- electronic/meditation 1
- emotional 1
- higher key 1
- higher register 1
- jazzy 1
- melancholic 1
- pop 1
- pop/rock/ singer-songwriter 1
- rock&roll/soul 1
- sad sounding 1
- slow to medium tempo 1
- strings 1
- synth bass 1
- …
musiccaps_names (array) 10 ✖
- Music 5
- Song 2
- Brass instrument 1
- Independent music 1
- New-age music 1
- Pop music 1
- Sad music 1
- Soul music 1
- Stomach rumble 1
- Trumpet 1
youtube_published (date) 6 ✖
- 2008-09-13 1
- 2009-11-26 1
- 2009-11-28 1
- 2012-05-05 1
- 2014-10-25 1
- 2014-11-25 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Why does your tummy rumble? | This song contains digital drums playing a simple groove along with two guitars. One strumming chords along with the snare the other one playing a melody on top. An e-bass is playing the footnote while a piano is playing a major and minor chord progression. A trumpet is playing a loud melody alongside the guitar. All the instruments sound flat and are being played by a keyboard. There are little bongo hits in the background panned to the left side of the speakers. Apart from the music you can hear eating sounds and a stomach rumbling. This song may be playing for an advertisement. | 2014-10-25T18:30:03Z | APPUSERIES | Why does your tummy rumble? Your tummy talks to you. Try to understand what it's telling you... The bumble tumbles are here to show you what some of these rumbles could be... Our YouTube Channels: English Channel: https://www.youtube.com/user/APPUSERIES Hindi Channel: https://www.youtube.com/user/APPUSERIESHINDI Kannada Channel: https://www.youtube.com/user/APPUSERIESKANNADA Tamil Channel: https://www.youtube.com/user/APPUSERIESTAMIL Telugu Channel: https://www.youtube.com/user/APPUSERIESTELUGU Gujarati Channel: https://www.youtube.com/user/APPUSERIESGUJARATI Marathi Channel: https://www.youtube.com/user/APPUSERIESMARATHI Sindhi Channel: https://www.youtube.com/user/APPUSERIESSINDHI Bengali Channel: https://www.youtube.com/user/APPUSERIESBENGALI Academy Channel: https://www.youtube.com/user/AppuSeriesAcademy Other Similar Videos: https://www.youtube.com/watch?v=p1vqvJvg5Uw https://www.youtube.com/watch?v=OFkrRdh1YtY https://www.youtube.com/watch?v=9dGwkrmnDZ0 Stay Connected With Us : Facebook - https://www.facebook.com/APPUTHEYOGICELEPHANT/ Instagram - https://www.instagram.com/appuseries/ Twitter - https://twitter.com/AppuSeries Join Appu's Rhymes Club on FaceBook: https://www.facebook.com/groups/287855061654522/ Get our Android Apps: https://play.google.com/store/apps/de... Get our eBooks: https://itunes.apple.com/us/artist/ap... Subscribe now and be the first one to watch our new videos: https://www.youtube.com/user/appuseries To buy our Books and CDs, please visit us at http://www.appuseries.com | ["Stomach rumble", "Music"] | ["backing track", "jazzy", "digital drums", "piano", "e-bass", "trumpet", "acoustic guitar", "digital keyboard song", "medium tempo"] | 6 | -0xzrMun0Rs | 4 | |
Sweet Soul Music 31 Scorching Classics 1964 | A male voice is singing along to a blues/rock bassline and acoustic drums. A e-guitar and a banjo are playing the same melody as the bass. All the instruments are playing when the male voice is not singing. Then after fading out a new song starts with a percussive sound, an upright bass, piano and a female voice singing.This song may be playing in a bar. | 2009-11-28T18:40:58Z | BearFamilyRecords | Various Artists Sweet Soul Music 29 Scorching Classics 1964 (1-CD DigiPac with 96-page booklet. 29 tracks, playing time: 79:48) -- Here comes the eagerly anticipated sequel to our first five volumes of 'Sweet Soul Music,' as well as the highly acclaimed, award-winning R&B series 'Blowin' The Fuse.' This is ehe sound that influences musicians who weren't even born when it came out, like Amy Winehouse and Joss Stone! All the greatest and most influential soul hits of the 1960s, including some surprisingly hard-to-find selections! Every song is the original version. The ultimate soul collection spread across ten individual CDs! The soul-searing soundtrack to the 1960s! Massive, beautifully illustrated booklets with detailed notes, incredible vintage photos, and ephemera. -- Over the course of ten spectacular years, R&B morphed into soul music with a side order of funk, and became the soundtrack to a social revolution. The riveting story of that incredible decade is told in full for the first time on Bear Family's 'Sweet Soul Music' series. Some record companies have compiled anthologies from their own vaults, but Bear Family has gone the extra mile... and then some, licensing classic recordings from virtually every record label at the epicenter of '60s soul to compile the greatest hits with the finest sound quality. -- The second five volumes, available now, cover the years 1966-1970. Though gospel remained the bedrock of soul music, the sound was transforming fast, thanks to Motown, Stax, the regional innovations of Chicago, New Orleans, and Muscle Shoals, and the funk revolution, led by James Brown and Sly & The Family Stone. The civil rights and antiwar movements were now rolling full speed ahead, and the messages at the heart of the music were often as powerful and invigorating as the grooves themselves. The second half of this incredible story is just as fascinating as the first. Bill Dahl's track-by-track commentary provides extensive biographical info on every artist on every disc. -- The prelude to this seri… | ["Music", "Pop music", "Soul music"] | ["rock&roll/soul", "e-guitar", "e-bass", "acoustic guitar", "piano", "banjo", "two songs", "male voice singing", "female voice singing", "upright bass", "medium to uptempo"] | 6 | DGbMEkQerYs | 1458 | |
6 WHITE BOOMERS 2013 | This song contains a piano playing short rhythmic chords along with an acoustic guitar and an upright bass playing the same melody. A brass melody is opening the scene. sound A male voice is singing in a higher register. This song may be playing while celebrating with the whole family on a national holiday. | 2014-11-25T23:03:53Z | Snapshot 21st Century | ["Brass instrument", "Trumpet"] | ["country", "acoustic guitar", "piano", "acoustic drums", "upright bass", "male voice singing", "higher key", "brass", "uptempo", "uplifting energy"] | 6 | Qu76GhRO9Yk | 2648 | ||
Dave Darrell - Children | This piece contains a lot of reverb and the instruments are using delay to create long arpeggio landscapes and rhythms. An acoustic guitar is being picked creating an arpeggio melody. A piano is playing a countermelody with a lot of reverb. A synth bassline playing one note in a 8th note rhythm is holding the ground of this composition. This song may be playing while dancing alone in your room. | 2008-09-13T15:02:12Z | a6n1a9 | Dave Darrell(or Darell, I don't know) - Children This video is dedicated to my bloody best friend! I wanna thank her for everything! I Love You Dick! =D ----------------------------- | ["New-age music", "Music"] | ["electronic/meditation", "acoustic guitar", "e-bass", "piano", "synth bass", "dreamy", "medium to uptempo"] | 6 | UeYmnV-B8so | 2931 | |
KHMER MUSIC 2012 | An acoustic guitar and a piano are playing the same chords as single notes with strings underlining the composition. A female voice is singing, sounding fragile and sad. This song may be playing during a sad movie scene. | 2012-05-05T22:33:39Z | sok chea | http://khmerjoke24.com/ KHMER Joke,Khmer Music, Khmer star ចំរៀងខ្មែរ khmer karaoke,Kuma,គូម៉ា | ["Music", "Song", "Sad music"] | ["pop", "acoustic guitar", "piano", "strings", "female voice singing", "sad sounding", "slow to medium tempo"] | 6 | dsibOgkezN8 | 3824 | |
Hästpojken Gitarrer & Bas, Trummor & Hat | The male voice singing sounds emotional and sad while a piano is playing a minor chord progression along with an acoustic guitar strumming chords. Then a fat sounding acoustic drum comes in with a simple groove along with an e-bass. This song may be playing on headphones while sitting in the bus riding downtown being lost in thoughts. | 2009-11-26T17:51:55Z | TussilagoSwe | Hästpojken Gitarrer & Bas, Trummor & Hat. Musikvideo: Tussilago, Theo Gabay Skivbolag: Roxy Recordings | ["Music", "Independent music", "Song"] | ["pop/rock/ singer-songwriter", "piano", "acoustic guitar", "acoustic drums", "male voice singing", "higher register", "emotional", "melancholic", "medium tempo"] | 6 | qRCjs90-1RQ | 4784 |
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;