musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "bass" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- amateur recording · 3 ✖
- bass · 3 ✖
- pop · 3 ✖
- digital drums 2
- uptempo 2
- crowd cheering and singing 1
- guitar melody 1
- harmonica 1
- instrumental 1
- jazz percussion 1
- jazz song 1
- male voices singing 1
- no voices 1
- slow tempo 1
- synthesizer 1
musiccaps_names (array) 7 ✖
- Music 2
- Bellow 1
- Burst, pop 1
- Crowd 1
- Harmonica 1
- Pop music 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Elite car show Golf sound system | Someone is playing a song out of a speaker. The song contains a guitar melody and a digital drum hitting the bass drum on every beat along with a bass-melody. This is an amateur recording. The song is in very poor audio-quality. | 2010-07-04T23:20:07Z | Guillermo Leal | ["Music", "Burst, pop"] | ["pop", "amateur recording", "digital drums", "guitar melody", "bass", "uptempo"] | 6 | Qz8hNRg-7G0 | 2655 | ||
[HD Fancam] 121027 GD&TOP Stage - Big Bang ALIVE Tour in Malaysia | This song contains digital drums with a kick on every beat and an open hi hat on the backbeat. A synth bass is playing a melody along with an e-bass. A male voice is singing along with a male backing singer. The crowd is cheering and singing along. This is an amateur recording and of poor audio-quality. This song may be playing at a live concert. | 2012-10-28T10:36:56Z | Choi Rain | Song - High High and Knock Out Credit to Me | ["Crowd", "Music", "Pop music", "Bellow"] | ["pop", "amateur recording", "digital drums", "synthesizer", "bass", "male voices singing", "crowd cheering and singing", "uptempo"] | 6 | cabjr3xtcR4 | 3722 | |
Harmonica - Nature Boy - Music Sheet - Nat King Cole | This song features a harmonica playing the main melody. This is accompanied by percussion playing a simple beat with the focus on the snare. The bass plays the root note of the chord. Due to the low quality of the audio, the other instruments cannot be heard. T. | 2008-01-31T13:16:17Z | alliax | http://www.ALLIAX.net Please comment my videos. Nature Boy by Eden Ahbez played on chromatic harmonica. There's a famous version by Nat King Cole, search for it on YouTube, you'll like it. I've added the music sheet to the video, but at the end there was a glitch and it's all black now. Doesn't matter much since it's three times the same melody... Ahbez composed the song which told a fantasy of a "strange enchanted boy... who wandered very far" only to learn that "the greatest thing... was just to love and be loved in return." The Yiddish songwriter Herman Yablakoff alleged that the melody to "Nature Boy" came from his song "Sveig Mein Hartz" ("Be Still My Heart"); his legal action was settled out of court. Actually, one needs go further back to Antonin Dvorak's Piano Quintet No. 2 in A, Opus 81 (1887). The melody of Nature Boy sits there loud and clear in multiple passages. This Dvorak piece is considered by some to be the greatest piece of chamber music ever composed. There were most probably Yiddish theaters in Prague during that period in history ... or perhaps Mr. Yablakoff was influenced by the classics. If you play the harmonica and have videos on YouTube then join the Harmonica Group: http://www.youtube.com/group/harmonica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["jazz song", "pop", "harmonica", "jazz percussion", "no voices", "instrumental", "amateur recording", "bass", "slow tempo"] | 0 | sEIn8YYD9jw | 4932 |
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;