musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "minimalist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- instrumental · 2 ✖
- keyboard harmony · 2 ✖
- minimalist · 2 ✖
- slow tempo 2
- ambient outdoor sounds 1
- animated movie 1
- animated voice 1
- birds chirping 1
- cartoon 1
- children’s movie 1
- children’s show 1
- classic pop 1
- emotional 1
- love song 1
- melancholic 1
- mellow 1
- melodic 1
- nostalgic 1
- playful 1
- pop 1
- romantic 1
- sentimental 1
- sinister music 1
- soft 1
- song introduction 1
- superimposed male voice 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kenny Rogers & Dolly Parton - Sometimes When We Touch | This music is a soft instrumental. The tempo is slow with a beautiful keyboard harmony. The music is soft, mellow, sentimental, nostalgic, melancholic and romantic. This song is classic pop. | 2009-06-23T23:40:32Z | Kristin Tehvan | One of the best love songs ever. | ["Electric piano", "Keyboard (musical)", "Piano"] | ["instrumental", "slow tempo", "keyboard harmony", "pop", "classic pop", "melancholic", "nostalgic", "minimalist", "song introduction", "soft", "mellow", "romantic", "melodic", "emotional", "sentimental", "love song"] | 7 | BMxgDBoPv_0 | 1233 | |
Kris Kyer as the voice of ROUBLARD in THE THREE LITTLE PIGS | This music is instrumental.The tempo is slow with a keyboard harmony, a male voice talking over the music and the sound of birds chirping. The music is playful, naughty, animated, simple and minimalist. The music style and dialogue indicate that this is an animated movie. | 2008-07-16T19:18:14Z | blakeburdette | Kris Kyer as the voice of ROUBLARD the Fox in the animated film The Three LIttle Pigs. | ["Wind instrument, woodwind instrument", "Shofar"] | ["instrumental", "slow tempo", "superimposed male voice", "ambient outdoor sounds", "cartoon", "animated movie", "children’s movie", "children’s show", "sinister music", "keyboard harmony", "minimalist", "animated voice", "playful", "birds chirping"] | 7 | pCW5ab3SNcQ | 4690 |
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;