musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "distorted", musiccaps_aspects contains "gospel" and musiccaps_aspects contains "haunting"
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 |
---|---|---|---|---|---|---|---|---|---|---|
REAL ANGELS SINGING PRAISES TO ALMIGHTY GOD | This is a very distorted tape recording of a gospel song. A choir with a male lead vocal can be heard singing passionately. The loud volume of electric guitar and the acoustic drums can be heard in the track. This track could be used in a nightmare sequence in the soundtrack of a horror movie. | 2012-01-30T02:34:05Z | TheCommanderMaster | Around 1987, a group of seven (7) people went to clean a church in Kansas City, Kansas to prepare for a Christian revival. As they were cleaning the church, they began to sing Capella (Hallelujah without instruments), and a man came into the church with a small tape recorder and taped their music. He just bought a brand new tape, and he began to tape their singing because it sounded so beautiful. After he recorded it, he played it back and discovered thousands and thousands of angels singing harmoniously with the seven. The angels had instruments, but the seven human people did not. The tape recording of this type is known as an EVP (Electronic Voice Phenomena). The sound was so awesome, they had it inspected (analyzed) by scientists at Oral Roberts University, and they concluded the voices were not human and the instruments were not earthly. Hell is a place for those that have no love and/or no heart in their soul. It is a real place as testified by the Bible, prophets and scribes. You must be born again (spiritually) to enter the Kingdom of God. Believe upon Jesus Christ, repent for the remission of sins, and follow His ways. Jesus' Love will guide you into salvation, eternal light, peace and happiness forever and ever. He will give you a new heart and restore your soul. God Bless Those that Hear This Song. | ["Music", "/t/dd00004"] | ["distorted", "tape recording", "choir", "male vocal", "gospel", "electric guitar", "acoustic drums", "haunting"] | 9 | 5QtjEBcZR6M | 660 |
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;