musiccaps_details (view)
1 row where musiccaps_aspects contains "meditative", musiccaps_aspects contains "pensive" and musiccaps_aspects contains "solemn"
This data as json, CSV (advanced)
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 |
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;