musiccaps_details (view)
1 row where musiccaps_aspects contains "boomy", musiccaps_aspects contains "soft rock" and musiccaps_names contains "Christmas music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Top 10 christian indie Pop/Rock songs | The low quality recording features a soft rock song that consists of harmonizing mixed vocals singing passionately over mellow piano chords, soft synth pad chords, boomy kick and reverberant claps. It sounds boomy, muddy and dull, as the low frequencies are clashing, bu it is also emotional regardless. | 2014-08-29T16:08:19Z | Yexus | Top 10 christian indie pop/rock songs by christian artists/bands What's Indie? Indie pop/rock is a genre of alternative rock music that originated in the United Kingdom in the mid-1980s, with its roots in Scottish post-punk bands. Indie pop was inspired by punk's DIY ethic and related ideologies, and it generated a thriving fanzine, label, and club and gig circuit. Indie pop differs from indie rock to the extent that it is more melodic, less abrasive, and relatively angst-free. 10. all sons and daughters-all the poor and powerless 9.as cities burn -made to pretty 8. jonazetta-busy body 7. the city harmonic-manifesto 6.pompton lakes- hope 5.rend collective experiment-keep me near 4.hosanna-so long forgotten 3.anchor and braille-in with the new 2. house of heroes-in the valley of the dying sun 1.citizens!-made alive Thanks for watching God bless, Yexus. | ["Christmas music", "Christian music", "Music", "Pop music", "Rock music", "Soul music"] | ["low quality", "passionate harmonizing mixed vocals", "soft rock", "mellow piano chords", "soft synth pad chords", "boomy kick", "reverberant claps", "bad mix", "boomy", "muddy", "dull"] | 4 | eXWBC3XfiXY | 3875 |
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;