musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard harmony", musiccaps_aspects contains "motivational" and musiccaps_aspects contains "steady drumming rhythm"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- inspiring 2
- keyboard harmony · 2 ✖
- motivational · 2 ✖
- steady drumming rhythm · 2 ✖
- black gospel music 1
- children choir 1
- christian contemporary music 1
- devotional 1
- distorted sound quality 1
- documentary soundtrack 1
- echoes 1
- gospel music 1
- groovy bass line 1
- instrumental music 1
- meditative 1
- medium tempo 1
- movie soundtrack 1
- never give up 1
- never say die 1
- passionate 1
- philharmonic orchestra 1
- poignant 1
- poor audio quality 1
- poor sound quality 1
- retro christian songs 1
- slow tempo 1
- spirited 1
- string section harmony 1
- strong bass line 1
- violin playing emotionally 1
musiccaps_names (array) 5 ✖
- Music 2
- /t/dd00003 1
- /t/dd00004 1
- Child singing 1
- Sad music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Holy Ghost music takes over secular show.. Kids singing old time Black Gospel | A children’s choir sings this devotional melody. The song is medium tempo with a steady bass line, drumming rhythm and clapping percussion. The song is black gospel choral music played in front of a live congregation. The audio quality is very poor. | 2010-01-10T20:27:36Z | JoeDH | Had this on an old video, the tape is a litle worn, but found it going through some old tapes. I remember loving this so much, so thought I'd share it with everyone. God will get his word out someway to the secular world. Don't know where these kids are now, but they have a great talent and Anointing. hope you enjoy!! | ["Music", "/t/dd00003", "/t/dd00004", "Child singing"] | ["gospel music", "poor sound quality", "children choir", "medium tempo", "black gospel music", "distorted sound quality", "meditative", "devotional", "inspiring", "motivational", "christian contemporary music", "steady drumming rhythm", "groovy bass line", "keyboard harmony", "retro christian songs"] | 1 | -8C-gydUbR8 | 20 | |
You will never win if you never begin(Nick Vujicic: Life Without Limbs).wmv | The song is an instrumental. The tempo is slow with a lion playing an emotional solo, string section harmony, strong drumming rhythm and a steady bass line. The song is emotional and inspiring. The audio quality is poor. | 2011-01-21T20:42:38Z | 89chatty | The man originally born to win life. | ["Music", "Sad music"] | ["instrumental music", "violin playing emotionally", "never say die", "string section harmony", "slow tempo", "steady drumming rhythm", "echoes", "keyboard harmony", "philharmonic orchestra", "strong bass line", "inspiring", "motivational", "poor audio quality", "poignant", "spirited", "passionate", "documentary soundtrack", "movie soundtrack", "never give up"] | 1 | KxjiEi2Eywk | 2135 |
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;