musiccaps_details (view)
1 row where musiccaps_aspects contains "low quality" and musiccaps_names contains "Tubular bells" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 4 ✖
- calming 1
- low quality · 1 ✖
- relaxing 1
- wide resonating bowl tones 1
musiccaps_names (array) 2 ✖
- Singing bowl 1
- Tubular bells · 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tibetan Singing Bowls Meditation Part 2/4 Hans Cousto: Release your mind (BINAURAL USE HEADPHONES) | The low quality recording features a widely spread resonating bowl tones. It sounds calming and relaxing, like something you would hear in a yoga session. | 2010-11-24T03:55:44Z | varshapavitra | Hello good people, I hope you will enjoy this session. Please adjust your volume to a comfortable level at 08:03 min. This will be the loudest point in this session. It's designed to play inside and outside of your head while laying down with eyes closed. You can only have this effect with headphones. The encoding process removed some quality unfortunately. Some effects got lost by this. I'll try to figure a way around this. I have designed this track to go through all planet frequencies according to Hans Cousto's calculations: -Mars, Saturn, Mercury, Pluto, Jupiter, Venus, Neptune -Sun and Schuman resonance -Hydrogen Gamma -Geomagnetic field -Earth: Synodic / sideric day and year, Platonic year, Tropical year. -Moon: Culmination Period, Synodic Month, Apsides rotation, metonic cycle, moon knot. If I left something out, they're all in the track no worries :) | ["Tubular bells", "Singing bowl"] | ["low quality", "wide resonating bowl tones", "relaxing", "calming"] | 4 | zjZV0tvur2I | 5507 |
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;