musiccaps_details (view)
1 row where musiccaps_aspects contains "synthesizer evolving pad sound" and musiccaps_aspects contains "very sad atmosphere"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Chameleon - Up There (Official Music Video) | This song contains a evolving synth pad sound in the higher register with noise. A piano is playing a sad minor chord progression in the mid range. Then a strong industrial sounding digital drum comes. This song may be playing in a very sad movie scene. | 2016-07-29T15:59:42Z | WEARECHAMELEON | Chameleon - Up There ( Official Music Video ) "Up There" - Featured Single from "Black | Part One" Available Now on iTunes - https://itunes.apple.com/us/album/black-part-one-ep/id1133842229 Credits: Band: CHAMELEON - Chloe Lowery, Andrew Ross, Gabe Marshall, Aurelien Budynek, Georgios Pesios - www.wearechameleon.com Producers: Chloe Elaine Lowery, Andrew Ross & Jimmy Negron Director: Jimmy Negron (www.jimmynegron.com) Band Manager: Loreen Domijan Cast: Cancer Survivor - Linda Carey As himself - Bob Carey (tutu) PTSD Survivor - Damond McFarland US Marine - Patrick Jabbour, USMC, SSGT Domestic violence survivor - Patricia Mercado Domestic violence abuser - Miguel Angel Espada Domestic violence child - Malachi Young Crew: 1st Assistant Director - Loreen Domijan Cinematographer - Jimmy Negron Ronin owner & operator - Rickstarr Ferragamo Up There - Song Credits (Lowery, Ross) Produced by: CHAMELEON Chloe Lowery - Vocals, Keys. Andrew Ross - Vocals, Guitar Aurelien Budynek - Guitar and Lead Guitar Georgios Pesios - Bass Gabe Marshall - Drums Asha Mevlana - Violins Don Ross - Spoken Intro Additional Production: Georgios Pesios Mixed by: Georgios Pesios Mastered by: Joe Lambert Drum sessions engineered by: Dennis Leeflang at The Situation Room, NJ Recorded at: Center of the Universe Studios, NYC Up There - Lyrics Remember how it used to be It seemed so easy to believe But I’m feeling nothing now and nothing is so hard So what do you do, what do you do, what do you do? I feel I don't deserve to pray It never helped me anyway Once I had something, but that something broke my heart What did I do, what did I do, what did I do? So take this all away, all away, all away I'm breaking anyway anyway anyway I’ll find a way to go, way to go, way to go Is there anybody up there oh Is there anybody up there I need Anybody up there oh Is there anybody up there I need Anybody up there oh Is there anybody up there calling for me The weather never tested me Saw lightning and I'd count to three I felt so grounded now I'… | ["Music", "Sad music"] | ["pop", "synthesizer evolving pad sound", "piano", "digital drums", "very sad atmosphere", "medium to uptempo"] | 6 | vp6p45b-038 | 5207 |
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;