With Curator we use an indexer with Curator called SOLR so that we can search in Curator web apps in a timely fashion without having to query the database directly. We can query SOLR just like we can in Curator and create reports converting them to CSVs if required.

To do this, firstly browse to SOLR on the Curator Server: http://localhost:8983/solr/#/

Once you have made it to the SOLR dashboard, you will need to select the correct core. 
on the left-hand panel, on the drop-down 'Core Selector' Choose the core with the highest value

Once selected, again on the left-hand panel, select 'Query' 
The query panel will then open on the right-hand side.

in the 'Q' Section enter your query. 
you can use the 'fl' section to filter your results. 
you can also use the 'rows' section to increase the results shown 
Once built, hit execute to populate your search 
Example below

Once you are happy with your search and results, you can convert it into a CSV or another format if you wish. 
To do this, on the 'wt' dropdown, select the format desired, once selected, hit 'execute' 
This will list your query in a format you can copy.

Alternatively, open the address shown at the top of the results in another tab.