Firefox/Input/Data: Difference between revisions

no edit summary
(Fix parser link)
No edit summary
Line 5: Line 5:
* ''[http://input.mozilla.com/data/opinions.tsv.bz2 opinions.tsv.bz2]'' offers the everything but ratings
* ''[http://input.mozilla.com/data/opinions.tsv.bz2 opinions.tsv.bz2]'' offers the everything but ratings
* ''[http://input.mozilla.com/data/ratings.tsv.bz2 ratings.tsv.bz2]'' has the ratings data
* ''[http://input.mozilla.com/data/ratings.tsv.bz2 ratings.tsv.bz2]'' has the ratings data
Exports happen every night between 2am and 3am (PDT).


Both tables form a '''1:n''' relationship and can be joined using the first column (the opinion id). Both tables are compressed using bzip2, so decompress them e.g. using ''bunzip2'' or ''bzip2 -d''.
Both tables form a '''1:n''' relationship and can be joined using the first column (the opinion id). Both tables are compressed using bzip2, so decompress them e.g. using ''bunzip2'' or ''bzip2 -d''.
Line 44: Line 46:
== Ratings ==
== Ratings ==
One line per (opinion x rating category). Keyed to opinion table using opinion ID.
One line per (opinion x rating category). Keyed to opinion table using opinion ID.
Please note that the feedback form has not been allowing ratings for several months now, so there will not be any recent ratings in the export.


==== Fields ====
==== Fields ====
48

edits