Raw dump of calendar

[troughc]

User Story

I need a swiss army knife spreadsheet (all the data, including metadata) that I want to create my own custom reports.
I am not a programmer, but I am skilled at using (excel) spreadsheets.
I know how to use v-lookups and other types of lookups tables (LUTs), meaning I am comfortable joining IDs together. I like using pivot tables. I don't work in JSON.
I often create reports for my stakeholders and I need access to the data to customize these.

Current state

Right now Bulk download has alot of columns in the download spreadsheet - and it doesn't include all data.
This is why we created Reports that are simple to understand and useful to everyone.

Task

We need raw data dump (CSV) that we could deliver to a client, who could then pull what they want from it.
The CSV would need to be organized differently, with fewer columns (@saumier maybe you could help with this).
Suggestion: Create multiple rows instead of multiple columns (see OpenRefine); even for multiple languages
Action: create a new API that can output multiple CSV files (tables)
NOTE: this is a different approach for a different user story. It is not 'Bulk download' which is to do bulk changes; this is to create a raw data dump for someone to build reports.

Background info

The request from Signe Laval is for April. They are asking for this
I would need an export of users and one of the events until April 1, 2025!
For the event report, is it possible to add the columns: accessibility, attending mode (virtual), information from artist files (city of residence), keywords and information from venue files (accessibility of the venue and neighborhood).