musiccaps_details (view)
2 rows where musiccaps_aspects contains "lullaby", musiccaps_author = 4 and musiccaps_names contains "Vibraphone"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- lullaby · 2 ✖
- creepy 1
- euphoric 1
- fruity male vocal 1
- haunting bells melody 1
- low quality 1
- mellow 1
- mellow sustained brass melody 1
- mysticalm 1
- nostalgic 1
- shimmering bells 1
- soft 1
- sustained strings swell 1
- tinny bells melody 1
musiccaps_names (array) 3 ✖
- Music 2
- Vibraphone · 2 ✖
- Inside, large room or hall 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
First Look at the Goblins Inside Gringotts Bank | This lullaby features a fruity male vocal talking over a haunting bell melody. At the end of the loop, there is a sustained string swell. It sounds creepy, haunting, mystical and like a theme song for a movie. | 2014-05-08T14:12:39Z | Universal Orlando Resort | Who's excited to visit the vaults of Gringotts? Here's a first look at the goblins that will be featured in Harry Potter and the Escape from Gringotts -- the groundbreaking marquee attraction that will be opening this summer in The Wizarding World of Harry Potter -- Diagon Alley. Connect with Universal Orlando: SUBSCRIBE - http://bit.ly/1oqJLp4 LIKE - Facebook: http://on.fb.me/1g0nBcx FOLLOW - Twitter: http://bit.ly/1q6f38t FOLLOW - Instagram: http://bit.ly/1nct8ij | ["Music", "Vibraphone", "Inside, large room or hall"] | ["fruity male vocal", "creepy", "haunting bells melody", "sustained strings swell", "lullaby", "mysticalm"] | 4 | 1tz4xNRRR4M | 316 | |
One day with The Samsung Galaxy Tab | The low quality recording features a shimmering bells alongside mellow sustained brass melody and tinny bells melody. It gives off nostalgic and euphoric vibes and it also sounds soft and mellow - almost like a lullaby. | 2010-12-20T23:40:33Z | AndroidHD | From Paris with My Samsung Galaxy Tab (unofficial Ad ) The Samsung Galaxy Tab is perfect for life on the go. The 7" touchscreen packs incredible entertainment and communication features, while a slim and light weight design ensures both comfort and portability. It features the new Android 2.2 operating system, voice and face-to-face video calling, and four new amazing Hubs (Music, Media, Readers and Social) for the ultimate tablet experience. The Galaxy Tab also supports Flash 10.1 and delivers the full web experience for you to enjoy. Enjoy life without limits with the Galaxy Tab. AndroidHD : http://androidhd.blogspot.com/2010/12/live-without-limit-with-samsung-galaxy.html SAMSUNG GALAXY Tab (GT-P1000) APPS : Google navigation , google maps , Location ,street view , Video futur , l'equipe.fr , Facebook ,Ttwitter , Swype, ExZeus , Need For Speed Shift , Gmail , Layar, Google Earth, TV-OUT, Relay.fr, 20 minutes,..... | ["Music", "Vibraphone"] | ["low quality", "shimmering bells", "tinny bells melody", "mellow sustained brass melody", "mellow", "soft", "euphoric", "nostalgic", "lullaby"] | 4 | fa0lR26K23E | 3963 |
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;