musiccaps_details (view)
2 rows where musiccaps_aspects contains "meditative", musiccaps_aspects contains "medium tempo" and musiccaps_aspects contains "pensive"
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 | |
PROGRESSIVE ROCK Madrugada Reborn from "Madrugada" (1974) | This music is instrumental. The tempo is medium with atmospheric synthesiser, soft keyboard harmony and subtle bass lines in the background. The music is progressive with a lot of digital sounds giving it a psychedelic,meditative, trippy, trance like vibe. This instrumental is Synth Rock/Progressive Rock. | 2008-06-22T13:32:05Z | Otnip54 | Madrugada Reborn (Gianfranco Pinto) MADRUGADA: Gianfranco Pinto: Keyboards & Vocals Billy Zanelli: Bass & Vocals Pietro Rapelli: Drums & Vocals Madrugada (1974) new issue from BTF (2007) Buy at: http://amzn.to/1tlD1CJ Incastro (1976) new issue from BTF (2007) Buy at: http://amzn.to/1tlDZ23 More on: http://www.italianprog.com/a_madrugada.htm | ["Sampler", "Music", "Synthesizer"] | ["instrumental", "medium tempo", "indie rock", "experimental", "meditative", "pensive", "grimelectronic music", "atmospheric synthesiser", "surround sound", "intense", "psychedelic", "trippy", "halluciatory", "trance music", "keyboard harmony", "subtle bass", "rock", "alternative rock", "synth pop", "indie roc", "progressive rock"] | 7 | xb07gLlmkL8 | 5342 |
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;