musiccaps_details (view)
2 rows where musiccaps_aspects contains "bad audio quality" and musiccaps_aspects contains "great adventure"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- bad audio quality · 2 ✖
- great adventure · 2 ✖
- adventurous 1
- animated movie soundtrack 1
- backing track 1
- breathy villainous voice 1
- building tension 1
- children’s movie 1
- church organ 1
- country music 1
- cymbals crashing 1
- deteriorated audio quality 1
- exciting 1
- gain issues 1
- guitar rhythm 1
- instrumental music 1
- male actor voice 1
- medium tempo 1
- monsters 1
- movie soundtrack 1
- movie themes 1
- mysterious 1
- no percussion instruments 1
- organ accompaniment 1
- passionate 1
- retro classics 1
- romantic 1
- scary 1
- string section harmony 1
- sunday cartoons 1
- tambourine percussion 1
- tense music 1
- vintage hits 1
- vintage pop 1
- vocal monologue 1
musiccaps_names (array) 9 ✖
- Electric piano 1
- Electronic organ 1
- Hammond organ 1
- Keyboard (musical) 1
- Music 1
- Organ 1
- Piano 1
- Scary music 1
- Speech 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
d85 yamaha organ solo one man band | The song is an instrumental. The tempo is medium with a church organ playing melody, steady drumming rhythm, cymbals crashing, tambourine percussion, steady bass, and guitar playing rhythm. The song is exciting and retro nostalgia. The audio quality is poor. | 2009-02-01T04:39:30Z | fathau | one man band | ["Organ", "Electric piano", "Hammond organ", "Electronic organ", "Keyboard (musical)", "Piano"] | ["church organ", "country music", "backing track", "medium tempo", "instrumental music", "tambourine percussion", "cymbals crashing", "guitar rhythm", "organ accompaniment", "vintage hits", "bad audio quality", "gain issues", "exciting", "adventurous", "retro classics", "passionate", "great adventure", "romantic", "movie themes", "vintage pop"] | 1 | A_Yd5huF2Pg | 1136 | |
Ep 3: Mastering the King | Paddle Pop | DinoTerra | The soundtrack is mysterious and builds anticipation. The tempo is medium with male actors vocalising a monologue, along with a terse string section harmony. The soundtrack builds anticipation and fear. The audio quality is bad. | 2013-10-15T07:20:58Z | PaddlePopEpisodes | Paddle Pop and friends meet Nikko, a spunky little turtle. They help Nikko to save the Hard Shell tribe’s village from a giant crocodile. Paddle Pop Adventures: DinoTerra is an exciting animated adventure series for kids aged 6 to 12. Starring the heroic young king of the Lion Kingdom, Paddle Pop Lion; his loyal friend Leena; as well as a cast of humorous and fun-loving companions, these episodic tales entertain young minds while showing the importance of friendship and teamwork. In this season, our heroes travel back in time to the age of dinosaurs to prevent Shadow Master from gaining the power of the Dino Crystals and changing history. Join Paddle Pop in your own multiplayer online game adventure — http://www.paddlepop.co.za/ Want more videos and games? — http://www.paddlepop.co.za/kids-games/default.aspx Subscribe: http://www.youtube.com/subscription_center?add_user=PaddlePopEpisodes | ["Music", "Speech", "Scary music"] | ["tense music", "movie soundtrack", "bad audio quality", "animated movie soundtrack", "children’s movie", "great adventure", "scary", "monsters", "vocal monologue", "deteriorated audio quality", "sunday cartoons", "breathy villainous voice", "male actor voice", "building tension", "scary", "mysterious", "string section harmony", "no percussion instruments"] | 1 | itT0_RhSipQ | 4221 |
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;