musiccaps_details (view)
3 rows where musiccaps_aspects contains "male voice" and musiccaps_names contains "Finger snapping"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- male voice · 3 ✖
- amateur recording 1
- beatbox 1
- different recordings of the same song 1
- finger snap 1
- finger snipping 1
- instructive speaking 1
- japanese language 1
- low quality recording 1
- medium tempo 1
- metronome click 1
- trombone lesson 1
musiccaps_names (array) 8 ✖
- Finger snapping · 3 ✖
- Music 3
- Beatboxing 1
- Brass instrument 1
- Musical instrument 1
- Pop music 1
- Speech 1
- Trumpet 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Missing from YouTube | Someone is beatboxing while doing a bassline with his voice. Finger snipping can be heard supporting the beat. This song may be playing at a talent show. | ["Finger snapping", "Beatboxing", "Music"] | ["beatbox", "finger snipping", "male voice", "amateur recording", "medium tempo"] | 6 | 721 | |||||
Brio使い方のポイント⑤ | This is the recording of a trombone lesson. The male instructor is playing a note on the trombone and then speaking in an instructive manner in the Japanese language. The click of the metronome can be heard in the background. This recording can be sampled for use in beat-making. | 2011-11-03T01:40:01Z | briobrass | Brio de Brass! Ver.1の一部です。 低音を吹くときアンブシュアを緩めたり、タンギングだけで音を出さないよう気をつけましょう。 Brioを使用するときと同じフォームで吹けるようにしましょう。 | ["Brass instrument", "Finger snapping", "Music", "Musical instrument", "Trumpet", "Speech"] | ["trombone lesson", "male voice", "japanese language", "instructive speaking", "metronome click"] | 9 | II1oyaWPiD0 | 1889 | |
Grind On Me Compilation Best Grind On Me Vines Part 2 | The excerpt features a song sounding from a speaker and being recorded with an amateur device like a phone. After a finger snap, the same song can be heard recorded in similar conditions but lower in volume. | 2013-10-30T02:45:42Z | HOT Viral Videos And Vines | Grind On Me Compilation Best Grind On Me Vines Part 2 Facebook: http://on.fb.me/17i4vsU Website: http://DailyViralHumor.com Facebook: http://on.fb.me/1u7cDuw Twitter: http://twitter.com/ViralandVines - - - - - Subscribe for the best funny vines. The Best vine compilations, and some sexy vines as well, we also parody songs such as wiggle and grind on me. SUB NOW | ["Finger snapping", "Music", "Pop music"] | ["male voice", "low quality recording", "finger snap", "different recordings of the same song"] | 2 | Ob9iaGon5ak | 2449 |
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;