musiccaps_details (view)
2 rows where musiccaps_names contains "Inside, large room or hall" and musiccaps_names contains "Telephone bell ringing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- background-noises 1
- banjo 1
- changing songs 1
- comedic sound effects 1
- electric rhythm guitar plays 1
- electronic drums 1
- energetic 1
- enthusiastic 1
- female voice 1
- groovy music 1
- hip hop music 1
- keyboard accompaniment 1
- keyboard beep tones 1
- male singer 1
- medium tempo 1
- passionate 1
- poor audio quality 1
- pop/country 1
- rapping vocals 1
- rough male vocals 1
- slick drumming rhythm 1
- song fade 1
- song stops playing 1
- story telling 1
- telephone ringing 1
- uptempo 1
musiccaps_names (array) 5 ✖
- Inside, large room or hall · 2 ✖
- Music 2
- Telephone bell ringing · 2 ✖
- Inside, small room 1
- Roaring cats (lions, tigers) 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Uncle Grandpa - Funny Face (Preview) Clip 1 | This piece of audio contains a modern pop song with drums, effects panned to left and right, a female voice singing with delay before changing into a totally different song that sounds more like a fast paced country song with a synthesizer- melody; acoustic drums and a banjo playing a fast melody along. This recording is also full of voice samples, a tiger or lion roaring, a telephone ringing. According to all these sounds and fast paced changes, it can be assumed that this recording is best played at a comedic television show for kids. | 2014-04-14T04:21:14Z | Cartoon Network Asia | When Uncle Grandpa accidentally unleashes a floating Funny Face that's so funny you laugh yourself to insanity, the guys realize that only Gus' seriousness can save them, but will he help them after they've hurt his feelings? Watch more of Uncle Grandpa on Cartoon Network! Watch more Uncle Grandpa videos: http://www.cartoonnetworkasia.com/video/uncle-grandpa Check out our Cartoon Network Facebook pages: http://www.facebook.com/asia.cartoonnetwork http://www.facebook.com/CartoonNetworkPhilippines | ["Music", "Telephone bell ringing", "Roaring cats (lions, tigers)", "Inside, large room or hall"] | ["pop/country", "changing songs", "electronic drums", "banjo", "female voice", "comedic sound effects", "background-noises", "uptempo"] | 6 | e57SBRbMXbI | 3842 | |
'For Little Jimmy' (Official Music Video) - Ron Killings aka WWE Superstar "R-Truth" | A male singer with a rough voice sings this hip hop dance song. The song is medium tempo with a distorted electric guitar playing rhythm, keyboard accompaniment, slick drumming rhythm, telephone ring tones and various percussion hits. The song ends with a fade . The song has poor audio quality. | 2013-02-10T14:09:09Z | RonKillingsTV | 'For Little Jimmy' official music video from Ron Killings aka WWE Superstar "R-Truth" #RTruth #WWE #ForLittleJimmy #RonKillings #LittleJimmy Subscribe to RonKillingsTV: https://www.youtube.com/channel/UCkK8dn3G5IxAigWgRbdJmyw Website: https://www.theofficialronkillings.com Merchandise: https://www.ronkillings.com Facebook: https://www.facebook.com/ronkillings Twitter: https://www.twitter.com/ronkillings Tik Tok: https://www.tiktok.com/ronkillings1 Youtube: https://www.youtube.com/ronkillingstv IG: https://www.instagram.com/ronkillings1 Booking info: ronkillingsbooking1@gmail.com https://www.textrke.com (fan text line) (310) 406-7100 Director IG handle(s): @shotbyreginald | ["Music", "Telephone bell ringing", "Inside, small room", "Inside, large room or hall"] | ["male singer", "rapping vocals", "hip hop music", "telephone ringing", "slick drumming rhythm", "song stops playing", "keyboard beep tones", "keyboard accompaniment", "story telling", "enthusiastic", "medium tempo", "rough male vocals", "energetic", "passionate", "poor audio quality", "groovy music", "electric rhythm guitar plays", "song fade"] | 1 | sgJT5lIFttM | 4970 |
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;