musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic drums" and musiccaps_names contains "Inside, large room or hall"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- electronic drums · 2 ✖
- female voice 2
- background-noises 1
- banjo 1
- changing songs 1
- child-like vocal 1
- comedic sound effects 1
- crowd sounds 1
- dance 1
- energetic 1
- live performance 1
- loud 1
- pop music 1
- pop/country 1
- strong bass 1
- synthesizer 1
- uptempo 1
musiccaps_names (array) 6 ✖
- Inside, large room or hall · 2 ✖
- Music 2
- Roaring cats (lions, tigers) 1
- Singing 1
- Synthetic singing 1
- Telephone bell ringing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Front Row for Britney Spears performing BIG FAT BASS on Jimmy Kimmel LIVE! HD | This is the live recording of a pop music piece. The track is being performed with playback. There is a female vocal with child-like characteristics. There is a strong electronic drum beat in the rhythmic background. A fuzzy synth bass is playing the melodic part. There are lots of beat repeat effects. The atmosphere is loud and energetic. There are sounds that can be heard coming from the crowd cheering. | 2011-03-31T06:43:19Z | Rene Carta | Steadiest hand yet, you won't get dizzy watching it! =D | ["Singing", "Music", "Synthetic singing", "Inside, large room or hall"] | ["pop music", "live performance", "female voice", "child-like vocal", "electronic drums", "synthesizer", "strong bass", "loud", "energetic", "dance", "crowd sounds"] | 9 | TTytcT_1dmY | 2838 | |
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 |
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;