musiccaps_details (view)
1 row where musiccaps_aspects contains "male vocal" and youtube_description = "http://philfischer.com Phil Fischer in Pakistan, Stuck on You, spreading Christian music in India, singing music in Pakistan, mercy me youtube Channel, casting crowns myspace page, download free acoustic Christian music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Spreading Christian music in India, Phil Fischer in Pakistan, Stuck on You | This is a Christian gospel music piece. There is a male vocalist singing melodically at the forefront. The simple tune is being played by a mellow acoustic guitar. The piece has a deep and passionate atmosphere. It could be used in Christian religious events and gatherings. It could also be used in the background of Christian social media content. | 2009-11-03T20:11:26Z | northwestmusician | http://philfischer.com Phil Fischer in Pakistan, Stuck on You, spreading Christian music in India, singing music in Pakistan, mercy me youtube Channel, casting crowns myspace page, download free acoustic Christian music | ["Music", "Middle Eastern music"] | ["gospel music", "christian", "acoustic", "male vocal", "melodic singing", "acoustic guitar", "simple tune", "religious", "deep", "passionate"] | 9 | 0jFQ21A6GRA | 202 |
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;