musiccaps_details (view)

2 rows where musiccaps_aspects contains "calming atmosphere" and musiccaps_author = 2

✎ View and edit SQL

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
The Stellas with Lennon and Maisy - Believe The music features a few girl voices singing a melody in harmony. An acoustic guitar accompanies the singers with strummed chords. The overall atmosphere is calming and moving at the same time. 2013-10-18T07:20:24Z TheMJ1025 The Stellas are joined by daughters Lennon and Maisy from ABC's Nashville at 3rd & Lindsley 10/16/13 ["Singing", "Country", "Music", "/t/dd00004"] ["girl voices", "vocal harmony", "acoustic guitar", "calming atmosphere"] 2 9zW-E0XdWdw 1053
The Sound of Bronkow Music Festival-Rückblick 2013 The music features a calm male voice singing a short melody. An acoustic guitar is accompanying the singer and playing chords throughout the music excerpt. In the background car horn-like sounds can be heard playing long notes. The overall atmosphere is calming. 2013-12-17T10:22:24Z kundfrecords So war das, beim The Sound of Bronkow Music Festival 2013 rund um das Dresdner Societaetstheater. Mehr Infos unter www.kfrecords.de/sob-festival. Termin 2014: 5.9. bis 7.9., Vorverkauf ab März 2014 Kamera & Schnitt: Florian Franik, Musik: O Emperor - This is It K&F Records 2013 ["Effects unit", "Music", "Sad music"] ["calming male voice", "acoustic guitar", "car horn-like sounds", "calming atmosphere"] 2 TdHdD1wxu_0 2854

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;