Line 242:
Line 242:
We are testing a new kind of tool to provide the data: every day an SQL database is fed by the regular daily CSV export, and published online thanks to Datasette tool.
We are testing a new kind of tool to provide the data: every day an SQL database is fed by the regular daily CSV export, and published online thanks to Datasette tool.
−
The tool, called Mirabelle, can be found here: http://mirabelle.openfoodfacts.org/
+
The tool, called ''Mirabelle'', can be found here: http://mirabelle.openfoodfacts.org/
The whole CSV export can be found here: http://mirabelle.openfoodfacts.org/products/all
The whole CSV export can be found here: http://mirabelle.openfoodfacts.org/products/all
Line 248:
Line 248:
* The tool supports simple queries with a form, and also facet navigation.
* The tool supports simple queries with a form, and also facet navigation.
* For those who know SQL language, it allows rich and complex queries.
* For those who know SQL language, it allows rich and complex queries.
−
What's different with [https://world.openfoodfacts.org/cgi/search.pl Open Food Facts advanced search]?
What's different with [https://world.openfoodfacts.org/cgi/search.pl Open Food Facts advanced search]?
Line 273:
Line 272:
Maybe you have to wait several seconds. It will download a product.csv file.
Maybe you have to wait several seconds. It will download a product.csv file.
+
+
==== Tips ====
+
+
* Several fields -- such as <code>countries_en</code>, <code>categories_en</code>, etc. -- contain multiple values. To query a particular value you have to use the operator <code>like</code> and use percents like this: <code>like %italy%</code>.