musiccaps_details (view)
5 rows where musiccaps_aspects contains "live performance", musiccaps_author = 4 and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- live performance · 5 ✖
- low quality 5
- noisy 4
- passionate 3
- crowd cheering 2
- energetic 2
- mono 2
- punchy snare 2
- shimmering hi hats 2
- "4 on the floor" kick pattern 1
- accordion melody 1
- addictive synth bass melody 1
- bells melody 1
- crowd chattering 1
- crowd clapping 1
- electric guitar melody 1
- electro song 1
- emotional 1
- fade out 1
- flat mel vocal 1
- folk 1
- footstep sound 1
- fruity male vocal 1
- groovy 1
- groovy bass 1
- harmonizing male vocals 1
- haze machine sounds 1
- mixed harmonizing choir 1
- pop 1
- punk 1
- soulful 1
- suspenseful 1
- traditional 1
- wide synth pad 1
- wooden percussions 1
musiccaps_names (array) 19 ✖
- Music 5
- Speech · 5 ✖
- Singing 2
- /m/05zppz 1
- /t/dd00003 1
- Accordion 1
- Choir 1
- Folk music 1
- Inside, public space 1
- Music of Latin America 1
- Musical instrument 1
- Opera 1
- Orchestra 1
- Pop music 1
- Rattle (instrument) 1
- Rock music 1
- Traditional music 1
- Whale vocalization 1
- Yell 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
I.R.A - punk PUNK DE LOS 90 | The low quality recording features, in the first half of the loop, a mono and noisy recording of a punk live performance with some crowd cheering noises. It sounds energetic and the recording suddenly fades out, transitioning into the second part of the loop which features a side synth pad that sounds suspenseful. | 2009-01-21T20:09:19Z | CAFAMOVA | nadie_molinin@hotmail.com | ["Whale vocalization", "Music", "Rock music", "Speech"] | ["low quality", "mono", "noisy", "crowd cheering", "fade out", "wide synth pad", "suspenseful", "energetic", "punk", "live performance"] | 4 | GcOOmVSM8Uw | 1740 | |
Treorchy Male Choir & Tom Jones singing Amazing Grace | The low quality recording features a live performance of a harmonizing mixed choir, introduced by a fruity male vocal. There is a footstep and crowd clapping sound right after introduction. The recording is a bit noisy, in mono and it sounds passionate, emotional and soulful. | 2009-11-27T01:22:15Z | Llantrisant | Tom Jones and the Treorchy Male Choir performing "Amazing Grace" on his Christmas TV Show, 1969. Visit www.treorchymalechoir.com | ["Singing", "Music", "Opera", "/m/05zppz", "Speech", "Choir", "/t/dd00003"] | ["low quality", "noisy", "mono", "footstep sound", "fruity male vocal", "crowd clapping", "mixed harmonizing choir", "emotional", "passionate", "soulful", "live performance"] | 4 | V5HMIxuAtv8 | 2973 | |
Musik Tradisional Madura_Semut ireng | The low quality recording features a live performance of a traditional song and it consists of a bell melody, followed by wooden percussion. There are some flat male vocals talking, after which there are harmonizing male vocals singing over it. It sounds passionate, even though the recording is noisy. | 2013-12-11T10:31:53Z | Achmad Syauqi | Musik Tradisional Madura_Semut ireng | ["Folk music", "Music", "Rattle (instrument)", "Speech"] | ["low quality", "noisy", "live performance", "traditional", "bells melody", "wooden percussions", "flat mel vocal", "harmonizing male vocals", "passionate"] | 4 | bBy0NCoCEHc | 3611 | |
Burn It Up - Yassi Pressman | The low quality recording features a live performance with an electro song playing in the background and crowd cheering sounds. The song consists of a "4 on the floor" kick pattern, addictive synth bass melody, punchy snare and shimmering hi-hats. It sounds energetic and the recording is noisy as it was probably recorded with a phone. | 2016-04-04T05:54:17Z | dealwithjames | Happy Truck #Happinas Mid Prod Yassi Pressman - Burn It Up | ["Music", "Pop music", "Yell", "Speech", "Inside, public space"] | ["crowd cheering", "electro song", "haze machine sounds", "live performance", "\"4 on the floor\" kick pattern", "pop", "punchy snare", "addictive synth bass melody", "shimmering hi hats", "energetic", "low quality", "noisy"] | 4 | ykkVTInYctY | 5434 |
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;