musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "vintage" and musiccaps_names contains "Swing music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- low quality 3
- noisy · 3 ✖
- vintage · 3 ✖
- clapping 1
- cool 1
- country blues 1
- energetic 1
- fruity male vocal 1
- groovy 1
- groovy bass 1
- groovy electric guitar melodies 1
- groovy spanish acoustic guitar melody 1
- harmonizing background vocals 1
- mellow snare 1
- mono 1
- passionate 1
- passionate male vocal 1
- punchy snare 1
- rock 1
- saxophone melody 1
- shimmering cymbals 1
- simple hi hats 1
- smooth bass 1
- soft kick hits 1
- thin kick 1
- uplifting 1
- uptempo 1
musiccaps_names (array) 10 ✖
- Music 3
- Swing music · 3 ✖
- Blues 1
- Country 1
- Music of Africa 1
- Music of Latin America 1
- Rhythm and blues 1
- Singing 1
- Ska 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Blues, Country Blues, Rhythm & Blues | The low quality recording features a country blues song that consists of fruity male vocal singing over groovy electric guitar melodies, groovy bass, shimmering cymbals, mellow snare, soft kick hits and clapping. The recording is a bit noisy, as it is vintage, and it sounds passionate, groovy, uptempo and cool. | 2010-06-04T21:51:03Z | StrontiumDawg | 3 fine slices of blues music. Got my mojo workin' - Muddy Waters, Frankie - Missisipi John Hurt, Crawling up a hill - John Mayall | ["Blues", "Singing", "Swing music", "Country", "Music", "Rhythm and blues", "Music of Latin America"] | ["low quality", "country blues", "vintage", "noisy", "fruity male vocal", "groovy electric guitar melodies", "groovy bass", "shimmering cymbals", "mellow snare", "soft kick hits", "clapping", "uptempo", "groovy", "passionate", "cool"] | 4 | ZzyWbehtt0M | 3433 | |
Camarón & Paco Cepero - Tangos - 1976 | The low quality recording features a groovy Spanish acoustic guitar. It sounds very noisy, vintage and the guitar was recorded in mono. | 2011-12-09T02:59:34Z | QuintoSertorio1987 | IV Festival Joaquín el de la Paula 1976 | ["Swing music", "Music", "Soul music"] | ["low quality", "groovy spanish acoustic guitar melody", "noisy", "mono", "vintage"] | 4 | ktTrTDQidsE | 4363 | |
Edsels - Rama Lama Ding Dong - Youngstown Ohio Doo Wop Sound | The low quality recording features a rock song that consists of harmonizing background vocals, alongside passionate male vocals, singing over, at least, punchy snare, simple hi hats, smooth bass, thin kick and punchy snare hits. The recording is so noisy that the actual song can barely be heard, but regardless it sounds vintage, energetic and uplifting. | 2010-04-13T01:59:16Z | PJDooWop | This is a true doo wop classic, coming to you from the very rare original "Lama Rama Ding Dong" pressing on Dub records. | ["Swing music", "Music of Africa", "Music", "Ska"] | ["low quality", "noisy", "vintage", "harmonizing background vocals", "passionate male vocal", "punchy snare", "saxophone melody", "rock", "simple hi hats", "thin kick", "smooth bass", "uplifting", "energetic"] | 4 | s6U8DtBK3Us | 4925 |
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;