musiccaps_details (view)
4 rows where musiccaps_aspects contains "groovy bass guitar" and musiccaps_names contains "Pop music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Time For Funk / Różycki - Te okolice (Official Music Video) | The Funk song features a flat male vocal singing over widely spread, funky electric guitar chords, groovy bass guitar and energetic drums. It gives off happy and fun vibes, as it is probably very good for dancing with your friends. | 2015-01-10T17:12:06Z | timeforfunk | https://www.facebook.com/TimeForFunk MP3 : http://www.cdbaby.com/cd/timeforfunk Time For Funk - Te Okolice Tekst piosenki według poezji Tomasza Różyckiego Scenariusz : Celina i Daniel Sroka Reżyseria: Aleksander Kropidłowski Zdjęcia : Patryk Kaflowski i Aleksander Kropidłowski Operator drona : Rafał Kijas Kierownictwo produkcji : Katarzyna Szczęsna-Kasprzyk Montaż: Aleksander Kropidłowski Kolor korekcja: Rafał Kijas, Aleksander Kropidłowski Produkcja : Daniel Sroka Charakteryzacja : Klaudia Linja -aho Elen Rachwał Ewelina Karpała Barbara Bajerek Asystent produkcji : Katarzyna Czesak Wystąpili : Jakub Artwik Celina Sroka Bogusław Roguż Stanisław Żurek Zuzanna Skolias Daniel Sroka Jacek Szwed Adam Leśniak Tomasz Hernik oraz: Ryszard Piekarczyk Michał Sądel Tomasz Szwed Dominik Kasprzyk Teresa Wilk Katarzyna Nowak Agnieszka Stompór - Lekka Beata Zielińska Zuzanna Kasprzyk Maja Kasprzyk Róża Lekka Marta Sroka Gosia Sroka Ryszard Sroka Ewa Sokołowska Specjalne podziękowania dla: Małgorzaty Kijas Witolda Flaszy Filipa Kobieli Muzeum Motyli w Bochni Face Art Make-Up School Piotra Wiśniowskiego Joanny Szafran Jerzego Stodolnego | ["Music", "Independent music", "Pop music", "Ska"] | ["funk", "flat female vocal", "wide funky electric guitar chords", "groovy bass guitar", "energetic drums", "happy", "fun", "dance"] | 4 | OKquGBKOgME | 2428 | |
| Chuck Berry and Etta James - Rock N Roll Music | The low quality recording features a live performance of a rock & roll song performed by passionate female vocal and male vocal ad libs, followed by groovy piano melody, funky electric guitar melody, groovy bass guitar, shimmering hi hats, punchy snare and soft kick hits. It is a bit noisy and there are some subtle microphone feedback sounds in the middle of the performance. It sounds energetic, vintage and passionate. | 2012-03-10T00:09:38Z | John1948ThreeA | Chuck Berry (Charles Edward Anderson Berry - born Oct. 18, 1926, St. Louis, Mo., U.S.) singer, songwriter, and guitarist who was one of the most popular and influential performers in rhythm-and-blues and rock-and-roll music in the 1950s, '60s, and '70s. Raised in a working-class African-American neighbourhood on the north side of the highly segregated city of St. Louis, Berry grew up in a family proud of its African-American and Native-American ancestry. He gained early exposure to music through his family's participation in the choir of the Antioch Baptist Church, through the blues and country-western music he heard on the radio, and through music classes, especially at Sumner High School. Berry was still attending high school when he was sent to serve three years for armed robbery at a Missouri prison for young offenders. After his release and return to St. Louis, he worked at an auto plant, studied hairdressing, and played music in small nightclubs. Berry traveled to Chicago in search of a recording contract; Muddy Waters directed him to the Chess brothers. Leonard and Phil Chess signed him for their Chess label, and in 1955 his first recording session produced Maybellene (a country-and-western-influenced song that Berry had originally titled Ida Red), which stayed on the pop charts for 11 weeks, cresting at number five. Berry followed this success with extensive tours and hit after hit, including Roll Over Beethoven (1956), School Day (1957), Rock and Roll Music (1957), Sweet Little Sixteen (1958), Johnny B. Goode (1958), and Reelin' and Rockin' (1958). His vivid descriptions of consumer culture and teenage life, the distinctive sounds he coaxed from his guitar, and the rhythmic and melodic virtuosity of his piano player (Johnny Johnson) made Berry's songs staples in the repertoire of almost every rock-and-roll band. At the peak of his popularity, federal authorities prosecuted Berry for violating the Mann Act, alleging that he transported an underage female across state lines for immoral purposes. After tw… | ["Singing", "Music", "Pop music", "Rock music", "Ska", "Song", "Rock and roll"] | ["low quality", "male vocal ad libs", "passionate female vocal", "shimmering hi hats", "punchy snare", "soft kick", "groovy bass guitar", "funky electric guitar melody", "groovy piano melody", "rock & roll", "live performance", "subtle microphone feedback", "noisy", "energetic", "passionate", "vintage"] | 4 | QZoclbefgak | 2628 | |
| Jonas Brothers - Take on Me Music Video | The low quality recording features a live performance of a pop rock song and it consists of flat male vocals counting down over addictive synth melody, energetic drums and groovy bass guitar. There are loud crowd screams in the background. It sounds distorted, loud and crushed, as it was probably recorded with a phone, but it is still energetic and exciting. | 2008-03-16T18:30:37Z | JBMusicOnRedbull465 | I took off the comments because i was super sick of what people were saying...maybe i'll put them back up later http://jbmusiconredbull.webs.com | ["Music", "Pop music", "Exciting music"] | ["pop rock", "flat male vocal", "low quality", "live performance", "energetic", "exciting", "crowd screaming", "loud", "addictive synth melody", "energetic drums", "groovy bass guitar", "distorted", "crushed"] | 4 | WTVC7ZI9WtY | 3098 | |
| Pocket Rocket - See The Problem (Punk Rock Music Video) | The low quality recording features a punk song that contains flat male vocal singing over punchy kick and snare hits, shimmering cymbals, wide electric guitars and groovy bass guitar. It sounds energetic, exciting and upbeat - like something you would jump to at concerts. | 2006-09-22T06:12:51Z | powerswap | The first music video of the aspiring austrian punk-rock-band "Pocket Rocket". | ["Background music", "Music", "Punk rock", "Pop music", "Ska", "Happy music"] | ["punk", "energetic", "exciting", "groovy bass guitar", "wide electric guitars", "shimmering cymbals", "punchy snare", "punchy kick", "flat male vocal", "upbeat", "low quality"] | 4 | pbVYSktQ5jE | 4726 |
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;