musiccaps_details (view)
3 rows where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "live performance" and musiccaps_aspects contains "loud"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- electronic drums · 3 ✖
- energetic 3
- live performance · 3 ✖
- loud · 3 ✖
- strong bass 2
- aggressive 1
- amateur recording 1
- child-like vocal 1
- crowd sounds 1
- dance 1
- dubstep 1
- electronic dance 1
- female voice 1
- poor quality 1
- pop music 1
- rising pattern 1
- synth 1
- synthesizer 1
- techno 1
- upbeat 1
- vocal sample 1
- wide variety synth 1
musiccaps_names (array) 9 ✖
- Music 3
- Electronic music 2
- Bang 1
- Crowd 1
- Dubstep 1
- House music 1
- Inside, large room or hall 1
- Singing 1
- Synthetic singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Диджей 100го уровня. Ловкость рук и никакого обмана. Dubstep | This is the live recording of a dubstep performance. The DJ is performing the beat on a MIDI control panel. There is an ever-changing synth sound that plays the melody and also provides the strong and fuzzy bass. The rhythmic background consists of an aggressive electronic drum sound. The atmosphere is loud and energetic. This piece could be played at rave parties and at nightclubs. | 2011-12-18T10:54:25Z | SupaDupaChannel | Смотреть до конца! Читать комменты в обязательном порядке, там много ржаки и исполняемые треки) | ["Electronic music", "Music", "Dubstep"] | ["dubstep", "techno", "live performance", "electronic drums", "wide variety synth", "strong bass", "energetic", "loud", "aggressive"] | 9 | APTh9uhf7WQ | 1113 | |
Justice - Stress (live at sónar08) | This is a live performance of an electronic dance music piece. There is a vocal sample repeating the same line. A synth is playing the tune while the electronic drums are playing the rhythm. There is a rising pattern and an energetic atmosphere. If it were not for the poor quality of the recording, this piece would fit nicely at a nightclub. | 2008-06-23T11:12:06Z | djfmv | Justice live! @ Sónar 2008, Barcelona (20.6.08) by DJF | ["Electronic music", "House music", "Crowd", "Music", "Bang"] | ["electronic dance", "live performance", "amateur recording", "vocal sample", "synth", "rising pattern", "electronic drums", "loud", "energetic", "upbeat", "poor quality"] | 9 | G22YfD5xxMU | 1687 | |
Front Row for Britney Spears performing BIG FAT BASS on Jimmy Kimmel LIVE! HD | This is the live recording of a pop music piece. The track is being performed with playback. There is a female vocal with child-like characteristics. There is a strong electronic drum beat in the rhythmic background. A fuzzy synth bass is playing the melodic part. There are lots of beat repeat effects. The atmosphere is loud and energetic. There are sounds that can be heard coming from the crowd cheering. | 2011-03-31T06:43:19Z | Rene Carta | Steadiest hand yet, you won't get dizzy watching it! =D | ["Singing", "Music", "Synthetic singing", "Inside, large room or hall"] | ["pop music", "live performance", "female voice", "child-like vocal", "electronic drums", "synthesizer", "strong bass", "loud", "energetic", "dance", "crowd sounds"] | 9 | TTytcT_1dmY | 2838 |
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;