musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "digital keyboard song", musiccaps_aspects contains "piano" and musiccaps_names contains "Stomach rumble"
This data as json, CSV (advanced)
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 |
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;