musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2012-12-25
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- accordion harmony 1
- acoustic and digital percussion's 1
- alto backup vocals 1
- classical 1
- dance 1
- dulcet 1
- electronica/dance 1
- emotional 1
- female vocalist 1
- german folk song 1
- german song 1
- heart-touching 1
- higher register singing voice upbeat 1
- live performance 1
- male 1
- mellow 1
- mellow acoustic guitar 1
- melodious 1
- passionate 1
- peaceful 1
- piano 1
- pleasant 1
- soft 1
- soft elbow 1
- soothing 1
- swiss folk song 1
- synthesizer 1
- vocal backup 1
musiccaps_names (array) 9 ✖
- Music · 3 ✖
- Afrobeat 1
- Christmas music 1
- Classical music 1
- Hip hop music 1
- Keyboard (musical) 1
- Music of Africa 1
- Musical instrument 1
- Piano 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Oesch's die Dritten - Ein Jodler für's Christkind 2012 | A female vocalist sings this soft melody. The song is slow tempo with accordion harmony and acoustic guitar accompaniment and alto vocal harmony. The song is mellow, soft, pleasant, dulcet, emotional, romantic and nostalgic. This song is a Swiss/German folk song. | 2012-12-25T03:35:04Z | fritz5109 | Oesch's die Dritten - Ein Jodler für's Christkind 2012 Ein Jodler für's Christkind, wir bringen ihn gern denn er soll die Freud' an Weihnachten hör'n Ein Jodler für's Christkind klingt heut durch die Nacht der Engel des Herrn hat die Botschaft gebracht. (Jodler) Hundert Tage ist es Winter und es fällt der weisse Schnee leise höre ich die Glocken von der Kirche in der Näh'. Aller Trubel ist vergessen, endlich ist es nun soweit Frohe, frohe Weihnachtszeit. Ein Jodler für's Christkind, wir bringen ihn gern denn er soll die Freud' an Weihnachten hör'n Ein Jodler für's Christkind klingt heut durch die Nacht der Engel des Herrn hat die Botschaft gebracht. (Jodler) | ["Christmas music", "Music"] | ["female vocalist", "vocal backup", "accordion harmony", "german folk song", "soft", "mellow", "melodious", "alto backup vocals", "swiss folk song", "german song", "soft elbow", "dulcet", "pleasant", "soothing", "peaceful", "mellow acoustic guitar"] | 7 | BXUS7pTYDzI | 1252 | |
PARODIE- D'BANJ - OLIVER TWIST - MAROC | This song sounds fun to dance along. It has digital and acoustic percussion, a catchy bassline/synthesizer sound and a male singer that sounds to be in a good mood. This song may be playing and dancing along. | 2012-12-25T03:45:54Z | FDALABIT | je tiens a preciser que ce remix a la marocaine n'est qu'une recreation en attendant que la scene marocaine bouge un peu . je reprecise que l'oeuvre originale appartient a D'banj l'artiste nigerien . merci beaucoup , pas de quoi , HAUT LES MAINS | ["Afrobeat", "Music of Africa", "Music", "Hip hop music"] | ["electronica/dance", "acoustic and digital percussion's", "synthesizer", "dance", "male", "higher register singing voice upbeat"] | 6 | uXMMzpgrY2g | 5120 | |
Schubert: Impromptu in G flat Op. 90 No. 3 | This is a classical music performance. The piece is played by a classical piano which is complex with rising and falling sequences. The atmosphere is filled with emotion and passion. This heart-touching piece could certainly be used in the soundtrack of a drama movie or a TV show. | 2012-12-25T19:58:02Z | Boris Bizjak | Piano recital by Olga Jegunova - http://www.jegunova.com/ Bishopsgate Institute (London), October 2012. Franz Schubert: Impromptu in G flat Op. 90 No. 3 Multimedia engineer - Boris Bizjak http://www.borisbizjak.com/#!hedone | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Classical music"] | ["classical", "piano", "live performance", "emotional", "passionate", "heart-touching"] | 9 | w_z9oSn-eIM | 5277 |
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;