Our most interesting data is at the track and source level. We need to make this available efficiently at higher levels: - [ ] show_source_information - [x] **source**: has_soundboard_source - [x] **source**: source_count - [x] **source**: max_avg_rating_weighted - [x] **source**: has_flac - [ ] **track**: jamchart_track_count - [ ] year - [x] **source**: duration - [x] **source**: avg_duration - [x] **show/source**: avg_rating - [x] **source**: source_count - [x] **show**: show_count - [ ] **track**: jamchart_track_count - [ ] venue_show_counts - [x] **show**: shows_at_venue - [ ] **track**: jamchart_track_count - [ ] setlist_songs_plays_information - [ ] **track**: is_jamchart (only possible for `features.setlist_song_play_maps_to_track`, uses `track_id`) - [ ] **track**: duration (only possible for `features.setlist_song_play_maps_to_track`, uses `track_id`)
Our most interesting data is at the track and source level. We need to make this available efficiently at higher levels:
show_source_information
year
venue_show_counts
setlist_songs_plays_information
features.setlist_song_play_maps_to_track, usestrack_id)features.setlist_song_play_maps_to_track, usestrack_id)