musiccaps_details (view)
2 rows where musiccaps_aspects contains "reverb" and musiccaps_names contains "Keyboard (musical)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- reverb · 2 ✖
- haunting 1
- live recording 1
- male voice 1
- music fading out 1
- operatic organ playing 1
- organ 1
- piano song 1
- poor audio quality 1
- ringing guitar chord 1
- romantic mood 1
- room acoustics 1
- slow pop 1
- slow tempo 1
musiccaps_names (array) 6 ✖
- Keyboard (musical) · 2 ✖
- Electric piano 1
- Hammond organ 1
- Harpsichord 1
- Organ 1
- Piano 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Resolution - Jack's Mannequin (Live, Acoustic) | This slow pop song features the end of a song. A male voice sings one syllable. The piano plays three notes followed by two high pitch notes. A guitar chord is heard ringing in the background. There is no percussion in this song. There are no other instruments in this song. The mood of this song is romantic. This song can be played in a romantic movie. | 2008-11-30T20:47:21Z | cassielovesandrew | ⓒBuzznet 2008, enjoy & comment! :) | ["Electric piano", "Keyboard (musical)", "Piano"] | ["slow pop", "piano song", "reverb", "male voice", "music fading out", "slow tempo", "ringing guitar chord", "romantic mood"] | 0 | QmIhKF1BqCg | 2640 | |
Rachmaninoff Prelude Opus 3 No.2 - Transcription for Organ | This clip features an organ being played in an operatic style. The sound is haunting and emotional. It's played live in a room, and the quality of the audio in the recording is poor. We hear the acoustics of the room which heavily echo. | 2007-06-07T20:52:43Z | Minh Nguyen | I played at recital on June 5, 2007. The pipe organ is Casavant Fre`res. | ["Organ", "Hammond organ", "Harpsichord", "Keyboard (musical)"] | ["organ", "operatic organ playing", "haunting", "live recording", "poor audio quality", "reverb", "room acoustics"] | 3 | TArWNq2retM | 2819 |
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;