musiccaps_details (view)
4 rows where musiccaps_aspects contains "punchy snare" and musiccaps_names contains "Happy music"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Cristina D'Avena - Shugo Chara - La Magia del Cuore Videosigle HD Dvd version 2 minuti | The low quality recording features a rock song that consists of a passionate female vocal, alongside harmonizing background female vocals, singing over wide acoustic guitar chords, groovy bass, punchy kick and snare hits. It sounds addictive and easygoing, even though the recording is a bit messy. | 2011-03-15T21:08:19Z | Mondosigle | Cristina D'Avena - Shugo Chara - La Magia del Cuore Videosigle HD Dvd version 2 minuti | ["Music", "Happy music"] | ["low quality", "rock", "wide acoustic guitar chords", "groovy bass", "harmonizing background female vocals", "passionate female vocal", "punchy kick", "punchy snare", "shimmering hi hats", "addictive", "easygoing", "messy"] | 4 | 7RtQpW2dSU4 | 846 | |
| Jarzynkowe Święta | The Children song features wide harmonizing vocals singing over shimmering shakers, groovy bass, punchy snare, soft kick hits, groovy piano chords, shimmering bells melody and acoustic rhythm guitar chords. It sounds addictive, happy and fun - as every children's song should sound. | 2015-12-07T22:41:58Z | Jarzynki i przyjaciele | Od teraz najmłodsi też mają swoją świąteczną piosenkę! "Jarzynkowe Święta" w wykonaniu Jarzynek i przyjaciół zwiastują długogrającą płytę dla dzieci z udziałem znanych polskich artystów, która ukaże się w najbliższych miesiącach. Muzyka i tekst: Anna Komin Produkcja: Maciej Muraszko i Anna Komin Gitary, ukulele, bas: Kuba Frydrych Instrumenty perkusyjne: Maciej Muraszko Realizacja nagrania: Sergiusz Supron Grafika i animacja: Bartosz Choryan i Kamil Krotofil Facebook: https://www.facebook.com/jarzynki JARZYNKOWE ŚWIĘTA REF Święta, Święta, Święta To magiczny czas i radości moc Święta, Święta, Święta Mikołaj znów przyniesie prezentów stos Przy choince zasiądziemy wszyscy razem Aby jak co roku poczuć magię Świąt! 1. My, Jarzynki i Przyjaciele Bardzo lubimy Święta Bo w ten radosny czas Złych chwil nikt nie pamięta Każdy z nas skrycie marzy By znaleźć się wtedy na stole I wylądować w waszych brzuszkach Jak barszczyk, rybka i uszka, o! REF Święta, Święta, Święta To magiczny czas i radości moc Święta, Święta, Święta Mikołaj znów przyniesie prezentów stos Przy choince zasiądziemy wszyscy razem Aby jak co roku poczuć magię Świąt! 2. Na sankach zjedziemy razem z górki Z górki na pazurki! I ulepimy bałwana Nim przyjdzie tęgi mróz (No dobrze by było!) Na choince zawiesimy bombki A gdy nastanie wieczór już Przywitamy Mikołaja Co prezentów przyniesie wór! REF Święta, Święta, Święta To magiczny czas i radości moc Święta, Święta, Święta Mikołaj znów przyniesie prezentów stos Przy choince zasiądziemy wszyscy razem Aby jak co roku poczuć magię Świąt! | ["Music", "Music for children", "Happy music"] | ["children song", "wide harmonizing vocals", "shimmering shakers", "groovy bass", "punchy snare", "soft kick hits", "groovy piano chords", "shimmering bells melody", "fun", "happy", "acoustic rhythm guitar chords", "addictive"] | 4 | KDuusOmEMHg | 2067 | |
| Pocket Rocket - See The Problem (Punk Rock Music Video) | The low quality recording features a punk song that contains flat male vocal singing over punchy kick and snare hits, shimmering cymbals, wide electric guitars and groovy bass guitar. It sounds energetic, exciting and upbeat - like something you would jump to at concerts. | 2006-09-22T06:12:51Z | powerswap | The first music video of the aspiring austrian punk-rock-band "Pocket Rocket". | ["Background music", "Music", "Punk rock", "Pop music", "Ska", "Happy music"] | ["punk", "energetic", "exciting", "groovy bass guitar", "wide electric guitars", "shimmering cymbals", "punchy snare", "punchy kick", "flat male vocal", "upbeat", "low quality"] | 4 | pbVYSktQ5jE | 4726 | |
| [HD] House Season 7 Promo Music | Macy Gray - Help Me | The low quality recording features a funk/soul song that consists of a passionate female vocal singing over groovy bass guitar, wide strings chords, low repetitive plucked strings melody, punchy snare layered with claps, soft kicks and shimmering cymbals. It sounds emotional, passionate and addictive. | 2010-09-03T17:57:32Z | mercman | Music from one of the promos of seventh season of House on FOX. | ["Music", "Happy music"] | ["low quality", "soul/funk", "passionate female vocal", "groovy bass guitar", "repetitive low plucked string melody", "wide strings chords", "punchy snare", "claps", "shimmering cymbals", "soft kick hits", "emotional", "passionate", "addictive"] | 4 | tnDUwvxQU3k | 5065 |
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;