musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2011-11-03
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- electric guitar chords 1
- emotional 1
- groovy bass 1
- heartfelt 1
- instructive speaking 1
- japanese language 1
- male voice 1
- melancholic female vocal 1
- mellow piano melody 1
- metronome click 1
- organ keys chords 1
- passionate 1
- punchy snare 1
- r&b 1
- shimmering hi hats 1
- soft kick hits 1
- synth lead melody 1
- trombone lesson 1
musiccaps_names (array) 8 ✖
- Music · 2 ✖
- Brass instrument 1
- Electronic organ 1
- Finger snapping 1
- Independent music 1
- Musical instrument 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Lana del Rey - Kill Kill | The R&B song features a melancholic female vocal singing over mellow piano melody, electric guitar chords, synth lead melody, groovy bass, organ keys chords, shimmering hi hats, punchy snare and soft kick hits. It sounds emotional, passionate and heartfelt. | 2011-11-03T15:59:06Z | zentalau | Lana del Rey - Kill Kill ound up the stairs I'm in the shower Do you know I am going to leave you? Do you know I am going To leave you? I'm in love with a dying man I'm in love with a dying man All our love's flying in the sand I'm in love with a dying man I'm in love with a dying man I have done everything I can Tell me about Brian and his girl Do I know, Brian is going to meet you? Love you, I do Stay here, I won't As stars fade from your eyes I'm in love with a dying man I'm in love with a dying man All our love flying in the sand I'm in love with a dying man I'm in love with a dying man I have done everything I can Want to Make it fun Don't trust Anyone I'm in love with a dying man I'm in love with a dying man I have done everything I can I'm in love with a dying man I'm in love with a dying man I have done everything I can... | ["Electronic organ", "Music", "Independent music"] | ["r&b", "synth lead melody", "melancholic female vocal", "mellow piano melody", "electric guitar chords", "groovy bass", "organ keys chords", "shimmering hi hats", "punchy snare", "soft kick hits", "emotional", "passionate", "heartfelt"] | 4 | hHS5C0RKa8A | 4091 |
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;