musiccaps_details (view)

1 row where musiccaps_names contains "Stomach rumble"

✎ View and edit SQL

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

CSV options: 

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;