musiccaps_details (view)
2 rows where musiccaps_aspects contains "percussive bass line", musiccaps_aspects contains "steady drumming rhythm" and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- emotional 2
- medium tempo 2
- percussive bass line · 2 ✖
- steady drumming rhythm · 2 ✖
- ambient room noise 1
- babies sleeping 1
- backup singers 1
- bells harmony 1
- calming 1
- cheerful 1
- children dancing 1
- christmas carols 1
- christmas presents 1
- dancing 1
- death metal 1
- deteriorated audio 1
- distorted guitar rhythm 1
- e emotional 1
- exciting 1
- female singer 1
- female singers 1
- festive cheer 1
- groovy 1
- happiness 1
- haunting 1
- holiday fun 1
- holidays 1
- live audience 1
- live performance 1
- lullaby 1
- passionate 1
- poor audio quality 1
- rebellious 1
- relaxing 1
- retro death metal hits 1
- santa claus 1
- screaming vocals 1
- snow 1
- teenage age angst 1
- vocal harmony 1
- winter wonderland 1
musiccaps_names (array) 8 ✖
- Music 2
- Singing · 2 ✖
- Choir 1
- Christmas music 1
- Grunge 1
- Rock music 1
- Song 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hole - Dicknail (live) | A female singer sings this screaming metal melody. The song is medium tempo with a steady metal drumming rhythm, steady bass line and a distorted guitar playing rhythm. The song is rebellious and passionate. The audio quality is very poor. | 2006-11-03T22:44:40Z | distillersdemon | Just a video of Hole performing Dicknail... | ["Singing", "Music", "Rock music", "Yell", "Grunge"] | ["poor audio quality", "death metal", "retro death metal hits", "female singer", "screaming vocals", "haunting", "rebellious", "poor audio quality", "live audience", "live performance", "teenage age angst", "rebellious", "passionate", "emotional", "poor audio quality", "deteriorated audio", "steady drumming rhythm", "distorted guitar rhythm", "percussive bass line", "ambient room noise", "medium tempo"] | 1 | Cwbtn_h6TP8 | 1416 | |
A Christmas Lullaby with Lyrics | Christmas Carol & Song | Female singers sing this Christmas carol in vocal harmony. The song is medium tempo with bells percussions, keyboard accompaniment, steady drumming rhythm and a percussive bass line. The song is a Christmas carol that doubles as a lullaby. The song is cheerful and festive. | 2013-11-13T03:32:57Z | Christmas Songs and Carols - Love to Sing | A Christmas Lullaby with Lyrics Christmas carol & song. A popular traditional Christmas song beautifully sung by our choir Love to Sing - great for singing along, performances, concerts, choirs, church and home. Merry Christmas 🎵 Subscribe: https://www.youtube.com/c/ChristmasSongsandCarolsLovetoSing?sub_confirmation=1 🎄 Christmas Songs and Carols Album with a BEAUTIFUL Book Download: https://www.christmassongsandcarols.com/products/christmas-songs-and-carols-album-and-ebook 👕 Merch https://www.christmassongsandcarols.com/collections/all 🎅 Free lyric sheet: https://www.christmassongsandcarols.com/products/a-christmas-lullaby ❄ LIVE Christmas Countdown: https://www.christmassongsandcarols.com/pages/christmas-countdown-clock 🧦 Buy our Favorite Christmas Socks https://amzn.to/3gIr563 __________________________________________________ Spotify: https://open.spotify.com/album/1TsEGg1GHQZBF4LutWIDSs?si=WylU0_mzScmjKnlgdXhx7A Apple Music: https://music.apple.com/us/artist/love-to-sing/351051489 YouTube Music: https://music.youtube.com/channel/UCjDkTzwSifCid5vl3gLtfbQ #christmassong #christmasmusic #christmassongsandcarols __________________________________________________ GET IN TOUCH! ❤ Facebook: https://www.facebook.com/christmassongsandcarols 💮 Pinterest:https://www.pinterest.nz/christmassongsandcarols 📷 Instagram: https://www.instagram.com/christmassongsandcarols/ Feel the Christmas JOY with Christmas Songs and carols - Love to Sing Lyrics: Hushaby, hushaby Christmas stars are in the sky Sweet the bells of Christmas Eve Babies, each a kiss receive Hushaby, goodnight Hushaby, goodnight Lullaby, lullaby Babies in their cradles lie Every one in white is gowned Hush, make not a single sound Lullaby, goodnight Lullaby, goodnight Rockaby, rockaby Christmastide draweth nigh Quiet now the tiny feet Babies sleep so still and sweet Sweetest dreams, goodnight Sweetest dreams, goodnight | ["Christmas music", "Singing", "Music", "Song", "Choir"] | ["female singers", "bells harmony", "medium tempo", "emotional", "winter wonderland", "christmas carols", "lullaby", "babies sleeping", "exciting", "festive cheer", "steady drumming rhythm", "percussive bass line", "groovy", "calming", "relaxing", "holidays", "holiday fun", "children dancing", "snow", "christmas presents", "e emotional", "cheerful", "happiness", "dancing", "santa claus", "backup singers", "vocal harmony"] | 1 | Ekoh6TJpA88 | 1586 |
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;