musiccaps_details (view)
2 rows where musiccaps_aspects contains "flat female vocal", musiccaps_aspects contains "fun" and musiccaps_aspects contains "low quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- flat female vocal · 2 ✖
- fun · 2 ✖
- happy 2
- low quality · 2 ✖
- baby goat bleating sound effect 1
- bagpipe melody 1
- children song 1
- church bells melody 1
- clock ticking 1
- drum roll 1
- groovy bass 1
- groovy piano melody 1
- joyful 1
- mono 1
- noisy 1
- plucked strings melody 1
- regional mexican 1
- wide acoustic guitar chords 1
musiccaps_names (array) 5 ✖
- Music 2
- Glockenspiel 1
- Goat 1
- Music for children 1
- Tick 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sukey's Circle! Vol. 1: Tick Tock (expanded version) - (SD) | The low quality recording features a children's song that consists of a clock ticking, church bells melody, plucked strings melody and flat female vocal singing over it. It sounds happy, joyful and fun. The recording is mono and noisy. | 2011-05-02T13:30:42Z | SukeyMolloy | Learn more about Sukeys Circle! at http://www.sukeymolloy.com. Join Sukey Molloy and her favorite friends Sunny and Tick Tock at Sukey’s Circle! for ‘Tick Tock’. Sukey dances, plays, and sings with Tick Tock while rocking, jumping, hopping and clapping. This is the original expanded version. You can also see Tick Tock on Vol. 3, and listen to the Tick Tock song on Sukey’s first CD, Circle Songs created for ages 1-5. | ["Music", "Music for children", "Tick", "Glockenspiel"] | ["low quality", "clock ticking", "church bells melody", "flat female vocal", "plucked strings melody", "happy", "joyful", "fun", "children song", "noisy", "mono"] | 4 | YLlbLSNxdQ4 | 3277 | |
Parto de un cabra murciana|MrSaravillo|. | The low quality recording features a baby goat bleating sound effects and regional Mexican song, that consists of wide acoustic guitar chords, groovy piano melody, drum roll, bagpipe melody and groovy, playing in the background. It sounds fun and happy and it seems like it is some kind of animal related TV show. | 2013-03-29T17:31:44Z | Mr Saravillo | Os invitamos a ver cómo pare una cabra en la cuadra del Queso de Saravillo. Cabritos para el Queso de Saravillo. www.quesodesaravillo.com info@quesodesaravillo.com | ["Goat", "Music"] | ["baby goat bleating sound effect", "regional mexican", "wide acoustic guitar chords", "groovy bass", "drum roll", "bagpipe melody", "flat female vocal", "groovy piano melody", "fun", "happy", "low quality"] | 4 | hTNKYJ6suII | 4108 |
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;