musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "male voice speaking" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- male voice speaking · 4 ✖
- amateur recording 3
- acoustic guitar 2
- e-guitar 2
- advertisement 1
- background song 1
- background voices 1
- bagpipe 1
- crowd cheering and clapping 1
- djembe 1
- e-bass 1
- frame drum 1
- kids voice 1
- medium tempo 1
- medium to uptempo 1
- traditional/folkmusic 1
- whistling 1
- xylophone 1
musiccaps_names (array) 11 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Rig Rundown - Robert Randolph | A male voice is speaking while someone is playing an e-guitar with a lot of reverb and a little delay running down the strings. This is an amateur recording. This may be playing while demonstrating someone your guitar. | 2011-12-27T18:07:26Z | Premier Guitar | http://www.premierguitar.com PG's Jason Shadrick is On Location in Iowa City, IA, at the Englert Theatre where he catches up with pedal steel guitarist Robert Randolph who walks us through his current touring rig consisting of Fender amps, Fender guitars, Fuchs amplifiers, Electro-Harmonix effects, and various other products. For more Rig Rundown videos or to watch one of Premier Guitar's 1500 other videos online for free, be sure to visit http://www.premierguitar.com/video | ["Guitar", "Music", "Musical instrument", "Steel guitar, slide guitar", "Speech", "Plucked string instrument"] | ["amateur recording", "male voice speaking", "e-guitar"] | 6 | EPjfqS5NvCY | 1552 | |
Cascades papier essuie-tout enviro 100% recyclé, pour plante | A male voice is talking in a typical advertisement manner. In the background you can hear a song containing a strummed acoustic guitar, a melody played with a xylophone and whistling in the same melody. An e-bass is underlining the song with a walking bassline. A kid's voice talks for a moment then the song stops as it comes to its end. This song may be playing in a happy advertisement. | 2008-04-13T17:32:03Z | cascadesgroupetissu | Essuie-tout Enviro 100% recyclé de Cascades est un produit écologique car il est fabriqué de matériaux recyclés.C'est le temps de changer. | ["Music", "Music for children", "Speech"] | ["advertisement", "male voice speaking", "e-bass", "kids voice", "background song", "acoustic guitar", "xylophone", "whistling", "medium tempo"] | 6 | EY8boPZ1hPs | 1566 | |
Tartan Terrors - Stump the Piper | This song contains someone playing a rhythm on a djembe along with a frame drum. Someone is strumming chords on guitar while the bagpipes are taking the main melody. Then a male voice starts speaking and the crowd is cheering and clapping their hands. This song may be playing live at a traditional concert. | 2006-10-20T03:14:46Z | jayedeye | Bagpipes with flair... from the Pennsylvania Rennaissance Faire 10-14-06. This is stump the bagpiper | ["Harmonica", "Wind instrument, woodwind instrument"] | ["traditional/folkmusic", "acoustic guitar", "djembe", "frame drum", "bagpipe", "male voice speaking", "crowd cheering and clapping", "medium to uptempo", "amateur recording"] | 6 | Q2Omtt4A8ls | 2591 | |
King Krule - Out Getting Ribs live (Hyères) 2011 | This audio contains someone strumming one only chord on a e-guitar then a male voice starts speaking in the midrange. In the background you can hear people talking. | 2011-10-15T23:37:15Z | lamiresonique | King Krule playing Out Getting Ribs at Midi Festival 2011 in Hyères | ["Echo", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Outside, urban or manmade"] | ["amateur recording", "e-guitar", "male voice speaking", "background voices"] | 6 | TObYoD2pGb0 | 2834 |
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;