musiccaps_details (view)
1 row where musiccaps_aspects contains "spanish female speech" and musiccaps_names contains "Pizzicato"
This data as json, CSV (advanced)
musiccaps_aspects (array) 6 ✖
- american male speech 1
- liquid splashing sound 1
- live recording 1
- narration 1
- spanish female speech · 1 ✖
- upright bass playing 1
musiccaps_names (array) 4 ✖
- Bowed string instrument 1
- Cello 1
- Double bass 1
- Pizzicato · 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Raw sauerkraut: a fermented, probiotic superfood | First, we have a bass intro that is played on the upright bass - it lasts for around five seconds. And then we heard some women speaking in Spanish while there was the sound of a liquid splashing in the background. There is then an American man who speaks. Part of this clip was recorded live and then the narration dubbed over it. | 2010-07-13T05:25:15Z | Kirsten Dirksen | "Sauerkraut is almost a perfect food," explains Alexander Valley Gourmet's founder David Ehreth. "It has cabbage which is a good thing to eat [ranked as one of the 10 best foods you're not eating] and then fermented it is a particularly healthful food because it has a lot of probiotic and probiotic just means the bacteria that is normal in our bodies and that needs to be reinforced on a regular basis which is what sauerkraut does." In this video, Ehreth shows us his fresh, unpasteurized sauerkraut and talks about the trend toward more probiotic foods in the market. Video where we try to make fermented sauerkraut at home: http://www.youtube.com/watch?v=ZruwvuTtdRI Video with fermentation guru Alex Hozven of The Cultured Pickle: http://faircompanies.com/videos/view/the-coca-cola-fermented-foods-pickling-any-vegetable/ Original story: http://faircompanies.com/videos/view/raw-sauerkraut-a-fermented-probiotic-superfood/ | ["Cello", "Double bass", "Pizzicato", "Bowed string instrument"] | ["upright bass playing", "liquid splashing sound", "spanish female speech", "american male speech", "narration", "live recording"] | 3 | Vy00ycBpqpc | 3047 |
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;