Exporting CSV data

[agrabeli]

We can export csv files based on OONI measurement data for each country which could include the following columns:

1. URL: Add all of the (country-specific) tested URLs under this column.
2. Q1-Year: Add a value which describes whether each URL was blocked or not. Such values can include "Blocked (DNS, HTTP, etc.), Not blocked, Unknown".
3. Q1-Year number of tests: How many times was each URL tested in that period (Q1-Year)
4. Number of different vantage points: In how many different vantage points was each URL tested in within that period (Q1-Year)
5. Q2-Year: Same steps as above, but repeated for all the subsequent quarterly periods.

[hellais]

@agrabeli and @FedericoCeratto will discuss these requirements and understand if they are still relevant, if so integrate the input into existing or future features for the API.

[bassosimone]

How important is this issue? I have tried to assign it a priority and struggled a bit, then settled for priority/medium (@agrabeli).

[hellais]

I think we now support this in the aggregation API. We just need some UI for it.

[agrabeli]

Exporting measurements in CSV format remains very important (as political scientists/human rights defenders can more easily work with CSV files than with JSON). If we can add a UI to automate and simplify the export of CSVs (particularly since it's supported by the aggregation API), that would be marvelous!

[hellais]

Maybe another approach could be that of offering the ability to export in CSV client-side directly inside of the MAT toolkit page.

[hellais]

We should discuss this during the backend meeting so we can move it forward a bit.

[agrabeli]

@hellais @FedericoCeratto We now support the export of CSV data, but I'm not sure if we want to keep this ticket open (to make improvements)?

[FedericoCeratto]

We can close the ticket for now.