musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2011-04-09
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- amateur recording 1
- bass 1
- e-guitar 1
- male backing voice 1
- male voice 1
- romantic theme 1
- slow pop 1
- slow tempo 1
- synth layers 1
- trap beat 1
musiccaps_names (array) 9 ✖
- Music · 2 ✖
- Electric guitar 1
- Electronic tuner 1
- Guitar 1
- Hip hop music 1
- Musical instrument 1
- Plucked string instrument 1
- Tapping (guitar technique) 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
iZomi - Nang A Ding | This slow pop song features a male voice singing the main melody. Another male voice sings backing voices in harmony with the main melody. A synth plays the same melody as the main voice using staccato notes. This is accompanied by percussion playing a trap beat. The bass plays the root notes of the chords and flourishes during chord changes. The bass notes are played without pausing in between notes. Instead, the notes are slid into each other. The mood of this song is romantic. This song can be played in a heartbreak scene in a romantic movie. | 2011-04-09T01:25:02Z | Khan Taithul | Lasa - Muanpi Mungleuh Sangpy Laphuak - Sangpu, Muanpi, Sangpy, Khanpi Produce by Adamack Director Khanpi | ["Music", "Zing", "Hip hop music"] | ["slow pop", "trap beat", "synth layers", "male voice", "bass", "male backing voice", "slow tempo", "romantic theme"] | 0 | CM2rKZmcR0I | 1355 | |
Sperzel How To: Drop D Tuning Using "D-Thing Tuner" | Someone is playing a fast paced melody running up and down a scale. This is an amateur recording. This song may be playing soundcheck with a band. | 2011-04-09T20:41:10Z | Peter Barlow | Sperzel 1 | ["Tapping (guitar technique)", "Electric guitar", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["amateur recording", "e-guitar"] | 6 | JKbUVdMJAO8 | 1990 |
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;