musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "minimalist"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- emotional · 3 ✖
- instrumental · 3 ✖
- minimalist · 3 ✖
- melancholic 2
- nostalgic 2
- sentimental 2
- slow tempo 2
- arabic music 1
- classic pop 1
- classical music 1
- contemplative 1
- deliberate 1
- dreamy 1
- keyboard harmony 1
- lonely 1
- love song 1
- meditative 1
- medium tempo 1
- melancholic cello 1
- mellow 1
- melodic 1
- middle eastern music 1
- oud melody 1
- pensive 1
- percussion 1
- pop 1
- reflective 1
- regional music 1
- romantic 1
- soft 1
- solemn 1
- song introduction 1
- stringed instrument 1
- syncopated rhythm 1
- upbeat ukelele 1
- wistful 1
musiccaps_names (array) 8 ✖
- Music 2
- Bluegrass 1
- Electric piano 1
- Keyboard (musical) 1
- Mandolin 1
- Middle Eastern music 1
- Piano 1
- Yip 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Horus" -- (RESCUED!) Dog at Collin County Animal Services | This music is a pensive instrumental.The tempo is medium with a melancholic cello, rhythmic ukulele and a percussion instrument. The song is pensive, contemplative, meditative, melancholic ,solemn and dreamy. | 2012-06-28T16:02:16Z | CCASAdoptable | Neutered, Micro-chipped and up-to-date on vaccinations! Hi there, my name is Horus! I am a 2 year old Lab Mix. I am a very sweet and happy dog. I am full of personality and charm. Come meet me, you won't regret it! We can play all day or give sweet kisses, it's up to you! Just hurry up and come see! Animal ID#: 353654 Name: Horus Sex: Male Age: Approx 2 years Breed: Lab mix Neutered: Yes For additional information on rescue or adopting contact the shelter directly. You need the ID NUMBER AND NOT NAME WHEN INQUIRING ON THE ANIMAL Collin County Animal Services 4750 Community Blvd. Collin County Justice Complex Mckinney, TX 75071 Email: animalshelter@co.collin.tx.us and ldrummonds@co.collin.tx.us (to inquire about an animal email is the best if no response then call) Phone: 972-547-7292 Hours of Operation Tues-Fri 9am-6pm and Sat 12pm-5pm Sunday 12pm-5pm Monday - closed to public, search for a lost dog by appointment only. | ["Music", "Mandolin", "Yip", "Bluegrass"] | ["instrumental", "upbeat ukelele", "contemplative", "medium tempo", "syncopated rhythm", "deliberate", "meditative", "solemn", "dreamy", "reflective", "melancholic cello", "percussion", "minimalist", "pensive", "emotional"] | 7 | 1FU5odlgLmo | 249 | |
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 | |
Very sad rabab music رباب by gulnoor parachinar | This music is instrumental. The tempo is slow with an Oud solo. The music is minimalist, simple, melancholic, nostalgic, emotional, wistful, pensive; poignant and intense. This is Middle Eastern classical music. | 2014-09-29T13:20:28Z | Gulfam Hussain Noor | Gulfam Hussain Noor Zeran Lalmay Parachinar Gulfam_12345@yahoo.com | ["Music", "Middle Eastern music"] | ["instrumental", "slow tempo", "oud melody", "classical music", "regional music", "arabic music", "middle eastern music", "stringed instrument", "melancholic", "lonely", "nostalgic", "sentimental", "emotional", "wistful", "minimalist"] | 7 | dSyue3RJllA | 3788 |
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;