musiccaps_details (view)
2 rows where musiccaps_aspects contains "fun", musiccaps_aspects contains "groovy bass" and musiccaps_aspects contains "soft kick"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- fun · 2 ✖
- groovy bass · 2 ✖
- happy 2
- shimmering shakers 2
- soft kick · 2 ✖
- children song 1
- echoing wide pig oink sound effects 1
- groovy piano melody 1
- groovy synth keys chords 1
- happy tinny bells melody 1
- joyful 1
- low quality 1
- mellow 1
- muffled claps 1
- passionate 1
- passionate boys vocals 1
- passionate girls vocals 1
- simple piano 1
- soft 1
- soft snare 1
- synth lead melody 1
musiccaps_names (array) 4 ✖
- Music 2
- Christmas music 1
- Music for children 1
- Oink 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
تعليم اللغة العربية mari belajar bahasa arab | The low quality recording features a children's song that consists of passionate girls and boys singing over soft kick and snare hits, shimmering shakers located in the left channel of the stereo image, groovy bass, synth lead melody and groovy piano melody. It sounds soft, mellow, passionate, happy, fun and joyful - like something kids and babies would listen to. | 2009-01-17T06:13:40Z | Candy Crush Hamidi Lajis | Pengajaran dan pembelajaran Bahasa Arab Tahun 1 di Sekolah Kebangsaan berguna untuk rujukan murid dan guru-guru j-QAF | ["Christmas music", "Music", "Music for children"] | ["low quality", "shimmering shakers", "groovy piano melody", "synth lead melody", "groovy bass", "soft kick", "soft snare", "passionate boys vocals", "passionate girls vocals", "children song", "soft", "mellow", "passionate", "happy", "fun", "joyful"] | 4 | 98YBS2tdpdU | 977 | |
PEPPA PIG - En la busqueda del tesoro! | This kids song features groovy synth keys, chords, simple piano melody, echoing and wide pig oink sound effects, shimmering shakers, muffled claps, soft kick hits and groovy bass. It sounds fun and happy - like something that children would listen to in their favorite tv shows. | 2015-08-24T16:32:53Z | eximent | Show en Vivo de Peppa Pig Mayor informacion del evento visite www.eximent.com //Live event under Rights EONE for © for Exim Entertainment (EXIMENT) LIVE SHOWS: | ["Music", "Oink"] | ["simple piano", "groovy synth keys chords", "echoing wide pig oink sound effects", "happy tinny bells melody", "shimmering shakers", "muffled claps", "groovy bass", "soft kick", "fun", "happy"] | 4 | tmabzx6yxqs | 5063 |
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;