musiccaps_details (view)

1 row where musiccaps_aspects contains "ambient noise", musiccaps_aspects contains "emotional", musiccaps_aspects contains "home video" and musiccaps_names contains "Ambient music"

✎ View and edit SQL

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
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

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;