musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "happy" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- groovy bass · 3 ✖
- happy · 3 ✖
- joyful 3
- passionate · 3 ✖
- groovy piano melody 2
- low quality 2
- shimmering shakers 2
- wooden percussions 2
- acoustic rhythm guitar 1
- breathy flute melody 1
- bright brass melody 1
- children song 1
- folk 1
- fun 1
- guiro percussion 1
- mellow 1
- passionate boys vocals 1
- passionate girls vocals 1
- passionate male vocal 1
- regional mexican 1
- shimmering cymbals 1
- soft 1
- soft kick 1
- soft snare 1
- sustained strings melody 1
- synth lead melody 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sozan Namo ( Seny Pr Ihm )* kurdish Music * | The low quality recording features a folk song that consists of a wooden percussion, groovy bass, breathy flute melody, groovy piano melody, shimmering shakers and sustained strings melody. It sounds passionate, joyful and happy. | 2010-05-10T13:43:42Z | Hemmen A M | Best Song .......... | ["Music", "Happy music"] | ["low quality", "folk", "wooden percussions", "groovy bass", "breathy flute melody", "groovy piano melody", "sustained strings melody", "shimmering shakers", "passionate", "happy", "joyful"] | 4 | -mA_bqD1tgU | 83 | |
تعليم اللغة العربية 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 | |
Chango - Henry Fiol | The Regional Mexican song features a passionate male vocal singing over guiro percussion, followed by wooden percussion, shimmering cymbals, acoustic rhythm guitar in the left channel of the stereo image and bright brass melody in the right channel. It sounds joyful, happy and passionate. | 2009-09-17T01:58:57Z | Pedro Velazco | ["Music", "Music of Latin America", "Salsa music"] | ["regional mexican", "passionate male vocal", "guiro percussion", "wooden percussions", "shimmering cymbals", "bright brass melody", "groovy bass", "acoustic rhythm guitar", "passionate", "happy", "joyful"] | 4 | UJA5AWbt6HM | 2905 |
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;