musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "motivational" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- inspiring 2
- keyboard harmony · 2 ✖
- medium tempo 2
- motivational · 2 ✖
- acoustic song 1
- ambient noise 1
- backup singers 1
- charitable organisation advertisement 1
- choral harmony 1
- christian praise songs 1
- congregational 1
- congregational singing 1
- devotional 1
- emotional 1
- female singer 1
- good ending 1
- groovy bass line 1
- guitar accompaniment 1
- guitar lead 1
- guitar rhythm 1
- home video 1
- instrumental music 1
- male singer 1
- meditative 1
- mixed audio tracks 1
- poor audio quality 1
- praise and worship 1
- prayer 1
- sad story 1
- street noises 1
- string drumming rhythm 1
- vocal duet 1
- wind noise 1
musiccaps_names (array) 3 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Homeless dog living in a cardboard box gets rescued & has a heartwarming transformation. | The song is instrumental. The song is medium tempo with a guitar accompaniment, piano playing pensively along with a keyboard harmony. The song is emotional and sad. The song is probably a social awareness message with ambient Street sounds included with the music track. | 2014-10-15T23:44:08Z | Howl Of A Dog | To support HOWL OF A DOG rescue & help more homeless dogs find forever homes please visit: https://www.howlofadog.org . Thank you! A homeless dog's transformation: sick, sad and lonely on the streets, he is rescued and turns into a joyful dog surrounded by friends. Buzu was living in a cardboard box, on the streets and was in a very miserable shape when we rescued him. We do not know if he ever had an owner as he didn’t have a microchip but taking into account his skin condition, he seemed to have been roaming the streets for a very long time: full of fleas, he developed an allergic dermatitis which led to hair loss on some parts of his body (especially on his neck and back). Untreated, it progressed, became chronic and got infected with Malassezia, a yeast that also caused him otitis. We had him on specific medication and medicated shampoos, but hair has still to grow on the affected areas. Except for the stubborn skin problem that we hope will be solved, Buzu is a healthy dog. He is ~5-6 years old, still a little shy with people he doesn’t know, very submissive and calm. He’s not very interested in exploring new territories and feels safer in the areas he knows, he likes to take a few runs in the garden, then to relax in the sun. He is friendly with other dogs and his best friend is a cat :) He appreciates most the things he didn’t have on the street: love, food and security. He is the kindest dog we’ve ever met and it’s so hard to understand how could have someone abandoned him and why he had been on the streets for so many years. Anyone willing to offer him the love and home he deserves please contact us on contact@howlofadog.org. Thank you! Additional info: Buzu has an up-to-date medical record with all necessary vaccines and treatments and is now microchiped and neutered. ...................... UPDATE 15 FEB 2015: BUZU WAS ADOPTED! https://www.howlofadog.org/buzu-adopted-in-england/ We managed to find Buzu a wonderful adoptive family in England. After a very long trip (~2000 km) he arrived yesterday at his… | ["Music", "Ambient music"] | ["emotional", "guitar accompaniment", "street noises", "motivational", "good ending", "keyboard harmony", "guitar accompaniment", "home video", "charitable organisation advertisement", "medium tempo", "ambient noise", "wind noise", "mixed audio tracks", "inspiring", "sad story", "acoustic song", "instrumental music"] | 1 | RD8kf4453cY | 2677 | |
Mighty To Save | A male and female singer sing this vocal duet with a choral vocal harmony. The song is medium tempo with a groovy bass line, steady drumming rhythm, guitar lead, guitars playing rhythm and keyboard harmony. The song is devotional and congregational. The song is a Christian praise and worship song with poor audio quality. | 2007-01-03T22:51:34Z | Rachel Thomson | PLEASE READ - Comments have been disabled. If you do have any positive comments you would like to share, please do mail me. I’d be really encouraged to hear from you. John 13 v 34-35 "A new command I give you: Love one another. As I have loved you, so you must love one another. 35 By this everyone will know that you are my disciples, if you love one another." I know the reference should be 2 Chronicles 7:14, at the end, not 2 Corinthians 7:14. Sorry for that mistake, but I can't amend it. This is one of my favourite songs ever , the message is fantastic, it speaks of how God is mighty to save us and how is so mighty that he can move mountains. Also, there is no copyright infringement intended here, just the spreading of Gods word. Also, I don't own the bible verses, they're from God's word, which He wants the whole world to hear, so no fear of copyright there! Haha. His Word is unique :) Enjoy, | ["Christian music", "Music"] | ["poor audio quality", "male singer", "female singer", "guitar lead", "choral harmony", "backup singers", "vocal duet", "congregational singing", "christian praise songs", "praise and worship", "medium tempo", "guitar rhythm", "groovy bass line", "keyboard harmony", "meditative", "congregational", "devotional", "inspiring", "prayer", "motivational", "string drumming rhythm"] | 1 | sR8rlTIU8_Y | 4949 |
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;