musiccaps_details (view)
2 rows where musiccaps_aspects contains "shaker" and musiccaps_names contains "Christmas music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- shaker · 2 ✖
- bongo drums 1
- brass instruments 1
- child vocalists 1
- children's choir 1
- choral vocals 1
- christmas music 1
- fun 1
- holiday mood 1
- jolly 1
- keyboard 1
- latin american music 1
- lively 1
- male voice 1
- moderate tempo 1
- programmed percussion 1
- reggae song 1
- spanish folk music 1
- string instruments 1
- trumpet 1
- violin 1
musiccaps_names (array) 3 ✖
- Christmas music · 2 ✖
- Music 2
- Christian music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Christmas Remix - Sha-la-la (non-stop mix) | This reggae song features a male voice. He sings the first line and laughs at the end of the first sentence. He continues to sing the melody. The voice is accompanied by programmed percussion playing a simple beat. The bass plays the root notes of the chords. A keyboard plays chords in the background with a reggae feel. Another keyboard plays a fill in between lines. At the end, backing singers sing in harmony. This song has a holiday mood. This song can be played in a holiday movie. | 2010-12-11T06:20:36Z | brYaz 214 | an Christmas remix present "Sha-la-la (non-stop mix)" Remix all 14 songs in just 12:33 minutes All Christmas Remix songs: Christmas Remix - Sha-la-la (radio edit) Christmas Remix - Sha-la-la (non-stop mix) Christmas Remix - Dayang-dayang (radio edit) Christmas Remix - Dayang-dayang (non-stop mix) Download link: http://www.4shared.com/audio/OLTt4F6W/Sha_La_La__Non_Stop_Remix_.html type: Mp3 file name: Sha-la-la (non-stop mix) file size: 11.5mb(11,798kb) Hosting Site: 4shared | ["Christmas music", "Music"] | ["reggae song", "male voice", "holiday mood", "programmed percussion", "keyboard", "shaker", "moderate tempo"] | 0 | gWRfk8nCcPs | 4035 | |
Villancicos Navideños de Los niños cantores de Huaraz - Popurri 2 | This is a Spanish Christmas song with child vocalists. The song has a jolly and positive vibe to it. There are string instruments and brass instruments. The brass plays a three note motif that is vibrant and positive. | 2008-12-01T05:41:23Z | Carito MC | Esta es la 2da parte del popurrí, las canciones son las siguientes: - Cholo, cholito - No se niño hermoso - El churumbel - Una nueva ronda - Dulce Jesús mío - Fiesta en el pesebre - Niño Manuelito - Villancico inglés | ["Christmas music", "Christian music", "Music"] | ["latin american music", "spanish folk music", "christmas music", "child vocalists", "choral vocals", "children's choir", "string instruments", "violin", "brass instruments", "trumpet", "lively", "fun", "jolly", "bongo drums", "shaker"] | 3 | s3Q8pVDY7ZI | 4920 |
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;