musiccaps_details (view)
4 rows where musiccaps_aspects contains "low quality", musiccaps_author = 4 and musiccaps_names contains "Humming"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- low quality · 4 ✖
- noisy 2
- soft 2
- arpeggiated acoustic guitar melody 1
- audio crackles 1
- calming 1
- emotional 1
- gospel 1
- harmonizing mixed vocals 1
- hypnotic 1
- lullaby 1
- male vocal onomatopoeia 1
- mellow 1
- mellow arpeggiated acoustic guitar melody 1
- mono 1
- muffled female soft vocal 1
- passionate 1
- relaxing 1
- sad 1
- soft passionate female vocal melody 1
- sustained strings melody 1
musiccaps_names (array) 9 ✖
- Humming · 4 ✖
- Music 4
- A capella 1
- Acoustic guitar 1
- Choir 1
- New-age music 1
- Singing 1
- Tender music 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Teresinha de Jesus MPBaby Humming | The low quality recording features a lullaby sung by soft, passionate female vocals over a mellow, arpeggiated acoustic guitar melody. It sounds hypnotic, relaxing, calming and soft. It is in mono, so that is the only thing that could make this fall in the low quality category. | 2015-09-28T17:46:43Z | Igor Guimarães | ["Humming", "Acoustic guitar", "Music"] | ["low quality", "lullaby", "soft passionate female vocal melody", "mellow arpeggiated acoustic guitar melody", "calming", "relaxing", "soft", "mono", "hypnotic"] | 4 | EQVZLtlDkHw | 1556 | ||
Castlevania: Lament of Innocence Music: A Pumpkin Humming | The low quality recording features an onomatopoeia, performed by male vocalists. The recording is noisy and it is crackling. | 2009-08-02T03:14:48Z | jumpropeman | Music: A Pumpkin Humming Source: Castlevania: Lament of Innocence | ["Humming", "Music"] | ["male vocal onomatopoeia", "noisy", "audio crackles", "low quality"] | 4 | UdA6I_tXVHE | 2930 | |
Gospel Touch Gospel Choir - Amazing Grace (EXCLUSIVE) - Best Version 2022 | The low quality recording features a gospel song that contains a harmonizing mixed vocals singing. The recording is a bit noisy and it sounds emotional and passionate. | 2014-05-26T20:33:06Z | Gospel Touch | Gospel Touch Gospel Choir - Amazing Grace (EXCLUSIVE) Hire Gospel Touch Choir Recorded by: BBC1 - The One Show - Gospel Touch Version Gospel Touch Choir https://www.gtchoir.com Bookings: admin@gospeltouch.net | +447956005371 This is one of the best version of gospel song. #gospeltouch #amazinggrace #theoneshow | ["Singing", "Humming", "Music", "Choir", "Vocal music", "A capella"] | ["low quality", "noisy", "gospel", "harmonizing mixed vocals", "emotional", "passionate"] | 4 | maeSHVZX8xc | 4481 | |
Creepy Music Joker | The low quality recording features a muffled female soft vocal singing over sustained strings melody and arpeggiated acoustic guitar melody. It sounds mellow, soft and sad - even though the quality is bad. | 2009-06-13T06:28:50Z | b3your0wnp3t | To all the Jokers...not all of them are Heath Ledger... | ["Humming", "New-age music", "Music", "Tender music"] | ["low quality", "muffled female soft vocal", "sustained strings melody", "arpeggiated acoustic guitar melody", "mellow", "soft", "sad"] | 4 | rez5KDmIZoc | 4890 |
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;