musiccaps_details (view)
1 row where musiccaps_aspects contains "noisy", musiccaps_aspects contains "shimmering shakers", musiccaps_aspects contains "wind" and musiccaps_names contains "Splash, splatter"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Grand Cayman Turtle Experience - Holding & Swimming with Turtles!! | The low quality recording features a loud wind and water splashing sound effects, while there is a widely spread electric guitar melody and marimba, followed by smooth bass, soft kick, shimmering shakers and tambourine playing in the background. It is noisy and it sounds like it was recorded with the phone, while the music was added in post production. | 2015-07-11T04:52:37Z | Family Fun Pack | This was one of the coolest places we have ever been. We visited the Cayman Turtle Farm, an attraction we highly recommend. We were able to have an amazing time looking at and holding turtles, with turtles, looking at alligators and sharks, feeding birds, sliding down a fun water slide, and we even saw a variety of wild lizards! This internationally renowned research and conservation center for sea turtles was a memorable part of our trip. The reason you only see some of us for most of this experience and Zac just does a couple activities is because we were at the doctor for his eye most of the day. This was the day after he was in an accident on the Carnival Magic Cruise Ship in the waterpark where the water pressure was too high and sprayed him full force directly in the eye. My kids went with their super nice grandparents, aunt, uncle and cousins so they could still participate in this excursion. We are thankful they took our kids for the day for us! Subscribe For The Latest Family Fun Pack Videos! http://bit.ly/1MkLfhI Shop our video and bring the fun home: Realistic Loggerhead Turtle toy http://go.magik.ly/ml/1i8v/ Toy shark collection http://go.magik.ly/ml/1je6/ Toy alligator http://go.magik.ly/ml/1jeb/ Fodor's In Focus Cayman Islands (Full-color Travel Guide) http://go.magik.ly/ml/1jed/ *above are affiliate links, clicking could earn us commissions This is my family vlog, made for people my own age, with similar life situations to myself so that they can relate to me. I am speaking to people of my own age in this vlog, while featuring the people I care most about in this world--my family. #grandcayman #familytravel #bucketlisttravel Family Fun Pack consists of Alyssa, David, Zac & Chris, all born within 39 months of each other.... and their new baby brother Michael! Our motto is "Fun with the family, every day"-- and we really stick to this!! | ["Music", "Splash, splatter"] | ["low quality", "wind", "splashing water", "exotic instrumental", "electric guitar melody", "marimba", "smooth bass", "shimmering shakers", "tambourine", "soft kick", "happy", "fun", "loud", "noisy"] | 4 | oGbNzR_lpSk | 4614 |
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;