musiccaps_details (view)
1 row where youtube_description = "Cody Jinks live from the Crown Royal Texas Stage with a performance of "Cast No Stones" from his 'Adobe Sessions' CD Connect to The Texas Music Scene: web: http://www.TexasMusicScene.com facebook: http://www.facebook.com/TXmusicTV twitter: https://twitter.com/TXmusicTV youtube: http://www.youtube.com/TXmusicTV "The Texas Music Scene" is a TV series that currently airs throughout Texas. HELP US SPREAD TEXAS MUSIC ACROSS THE NATION! Contact your local broadcast stations and cable providers, and DEMAND THE TEXAS MUSIC SCENE!"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Cody Jinks performs "Cast No Stones" on The Texas Music Scene | A deeper male voice is talking for a moment before changing to another male voice talking about something. In the background you can hear a professional recording containing an e-bass playing single long notes along with an organ and an acoustic piano playing chords in the midrange. An acoustic drum is holding a simple beat in the background. This song may be playing in a gospel church band. | 2015-02-17T18:12:12Z | The Texas Music Scene TV | Cody Jinks live from the Crown Royal Texas Stage with a performance of "Cast No Stones" from his 'Adobe Sessions' CD Connect to The Texas Music Scene: web: http://www.TexasMusicScene.com facebook: http://www.facebook.com/TXmusicTV twitter: https://twitter.com/TXmusicTV youtube: http://www.youtube.com/TXmusicTV "The Texas Music Scene" is a TV series that currently airs throughout Texas. HELP US SPREAD TEXAS MUSIC ACROSS THE NATION! Contact your local broadcast stations and cable providers, and DEMAND THE TEXAS MUSIC SCENE! | ["Music", "Speech", "Tender music"] | ["rockballad", "male voices talking", "background music", "acoustic drums", "e-bass", "acoustic piano", "organ", "slower tempo"] | 6 | 1Is1xfDjZrw | 256 |
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;