musiccaps_details (view)
2 rows where musiccaps_aspects contains "emotional", musiccaps_author = 7 and musiccaps_names contains "Mandolin"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- emotional · 2 ✖
- medium tempo 2
- acoustic guitar 1
- contemplative 1
- country hits 1
- country pop 1
- deliberate 1
- dreamy 1
- duet 1
- folk music 1
- folk pop 1
- instrumental 1
- mandolin 1
- meditative 1
- melancholic cello 1
- mellifluous 1
- mellow 1
- melodious 1
- minimalist 1
- pensive 1
- percussion 1
- pop 1
- reflective 1
- romantic 1
- sentimental 1
- simple melody 1
- soft 1
- solemn 1
- string instruments 1
- syncopated rhythm 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 | |
Mandolin Orange - Wake Me @Pickathon 2014 On The Farm | This song is a pleasant love song duet. The tempo is medium with acoustic guitar and ukulele accompaniment.the song is mellow, soft, emotional, romantic, nostalgic. This song is Country/Folk pop. | 2015-01-29T23:15:41Z | Pickathon | http://pickathon.com/ Presents Mandolin Orange live at Pendarvis Farm. Filmed on August 2, 2014 Channel Host: http://Grist.org Song: Wake Me Record Label: http://www.redeyeusa.com/ Producer: Ryan Stiles Executive Producer: Zale Schoenborn Associate Producer: Eric Schoenborn, Terry Groves, Ned Failing, John MacArthur Production Manager: Seth Chandler Production Coordinator: Alisha Flaumenbaum Editor: Stephanie Manzo Camera: Emilee Booher Audio/Co-Producer: Dylan McNab http://www.mandolinorange.com/ http://pickathon.com | ["Singing", "Music", "Mandolin", "Ukulele"] | ["duet", "medium tempo", "ukelele", "folk pop", "folk music", "mellifluous", "simple melody", "country pop", "country hits", "string instruments", "folk music", "acoustic guitar", "mandolin", "melodious", "pop", "country pop", "mellifluous", "romantic", "emotional", "sentimental", "soft", "mellow"] | 7 | n1fY-23ffl0 | 4513 |
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;