musiccaps_details (view)
2 rows where musiccaps_aspects contains "funny video" and musiccaps_aspects contains "medium tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- funny video · 2 ✖
- medium tempo · 2 ✖
- ad jingle 1
- animated vocals 1
- animation 1
- background music 1
- bad audio quality 1
- ball bouncing sound 1
- cellos 1
- comedy show 1
- harmonium accompaniment 1
- high gain audio 1
- indian music 1
- instrumental music 1
- laughing tones 1
- male and female conversation 1
- movie soundtrack 1
- news report 1
- percussive hits 1
- philharmonic orchestra 1
- poor audio quality 1
- retro ad 1
- south indian language 1
- string section harmony 1
- telugu news report 1
- timpani’s playing loud 1
- tutorial video soundtrack 1
- violins playing 1
- vocal dialogue 1
musiccaps_names (array) 3 ✖
- Music 2
- Bouncing 1
- Conversation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Bouncing Ball Animation | The song is an instrumental. The song is medium tempo with a string section accompaniment, timpani playing and other percussion instruments. There are other funny sounds like ball bouncing and other percussion tones. The song is an ad jingle soundtrack. The audio track is of poor quality. | 2011-07-16T15:38:32Z | M PROJECT FILMS OFFICIAL | This bouncing ball animation is created using 7 Basic Principles of Animation. | ["Music", "Bouncing"] | ["ball bouncing sound", "string section harmony", "tutorial video soundtrack", "animation", "poor audio quality", "timpani’s playing loud", "violins playing", "cellos", "philharmonic orchestra", "medium tempo", "movie soundtrack", "instrumental music", "retro ad", "ad jingle", "funny video"] | 1 | 40vmsGsFBsw | 533 | |
Bithiri Sathi Imitates PM Modi's Speech On Independence Day | Teenmaar News | V6 News | A male and female news reporter engage in a funny vocal banter. The background music is in medium tempo with harmonium accompaniment and subtle percussive rhythm with sudden percussion hits. The vocal dialogue is funny and engaging. The audio quality is overall very poor with painfully high gains. | 2016-08-12T16:30:01Z | V6 News Telugu | Bithiri Sathi had a satirical conversation with news presenter Savitri over PM Modi's Independence Day Speech. Watch V6 special program Teenmaar news with Savitri, Bithiri Sathi & Mangli in a Telangana slang. V6 IOS App ► https://goo.gl/EfEqlJ Download V6 Android App ► http://bit.ly/V6NewsAPP Subscribe at http://goo.gl/t2pFrq Visit our Website ► http://V6news.tv Twitter ► https://twitter.com/V6News Facebook ► http://www.facebook.com/V6News.tv Google+ ► https://plus.google.com/109903438943940210337 V6 News, Official YouTube V6 News Channel owned by VIL Media Pvt Ltd. V6 News, a 24 hour Telugu News Broadcaster, dedicated to report news across Telangana and other parts of the world through live reports, breaking news, sports updates, weather reports, entertainment, business trends, exclusive interviews, and current affairs. The channel airs programs like 'Teenmaar News,Telangana Yatra,Telangana Shakam,Rangeela,Top News,Taara,Cinema Talkies, 70MM, Mangli Adda,Janapadam etc'. Sports, Movies, Politics Controversies, Current Affairs, Technology.. you name it and you find it at the click of a button. | ["Conversation", "Music"] | ["vocal dialogue", "south indian language", "comedy show", "high gain audio", "news report", "funny video", "laughing tones", "percussive hits", "background music", "indian music", "harmonium accompaniment", "medium tempo", "male and female conversation", "animated vocals", "bad audio quality", "comedy show", "telugu news report"] | 1 | J7jVR6y6REA | 1971 |
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;