musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "groovy bass", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "regional mexican"
This data as json, CSV (advanced)
Suggested facets: youtube_description
musiccaps_aspects (array) 24 ✖
- groovy bass · 3 ✖
- passionate · 3 ✖
- regional mexican · 3 ✖
- passionate male vocal 2
- accordion melody 1
- acoustic rhythm guitar 1
- bright brass melody 1
- emotional 1
- energetic 1
- groovy 1
- guiro percussion 1
- happy 1
- harmonizing male vocals 1
- joyful 1
- low quality 1
- punchy kick 1
- repetitive acoustic guitar chord 1
- shimmering cymbals 1
- shimmering shakers 1
- soulful 1
- strings melody 1
- wide acoustic rhythm guitar 1
- wide bouncy wooden percussion 1
- wooden percussions 1
musiccaps_names (array) 5 ✖
- Music 3
- Country 1
- Music of Latin America 1
- Salsa music 1
- Ska 1
youtube_published (date) 3 ✖
- 2009-02-08 1
- 2009-07-28 1
- 2009-09-17 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
El Pali - De Agujeritos! | The low quality recording features a regional Mexican song that consists of harmonizing male vocals singing over wide, bouncy wooden percussion, wide acoustic rhythm guitar, groovy bass, punchy kick and strings melody. It sounds passionate, energetic and groovy. | 2009-02-08T22:49:27Z | frager046 | ["Music", "Ska"] | ["regional mexican", "low quality", "wide bouncy wooden percussion", "wide acoustic rhythm guitar", "harmonizing male vocals", "groovy bass", "punchy kick", "strings melody", "passionate", "energetic", "groovy"] | 4 | 3rbWoeUg9yo | 508 | ||
Chango - Henry Fiol | The Regional Mexican song features a passionate male vocal singing over guiro percussion, followed by wooden percussion, shimmering cymbals, acoustic rhythm guitar in the left channel of the stereo image and bright brass melody in the right channel. It sounds joyful, happy and passionate. | 2009-09-17T01:58:57Z | Pedro Velazco | ["Music", "Music of Latin America", "Salsa music"] | ["regional mexican", "passionate male vocal", "guiro percussion", "wooden percussions", "shimmering cymbals", "bright brass melody", "groovy bass", "acoustic rhythm guitar", "passionate", "happy", "joyful"] | 4 | UJA5AWbt6HM | 2905 | ||
El Rey - George Strait - Twang (George Sings SPANISH) | The Regional Mexican song features a passionate male vocal singing over repetitive acoustic guitar chord and groovy bass, after which there are shimmering shakers and accordion melody playing. It sounds passionate, emotional and soulful. | 2009-07-28T20:20:14Z | Frank Drebbin | That's right, first copy of the song.. and its GRAIT | ["Country", "Music"] | ["regional mexican", "repetitive acoustic guitar chord", "groovy bass", "passionate male vocal", "shimmering shakers", "accordion melody", "passionate", "emotional", "soulful"] | 4 | wt-f7K_suBc | 5291 |
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;