48
edits
Firefox/Input/Data: Difference between revisions
Corrections
(→Summary: Added feedback URLs) |
(Corrections) |
||
| Line 6: | Line 6: | ||
* ''[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 | ||
Both tables | 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''. | ||
== TSV Coding == | == TSV Coding == | ||
| Line 15: | Line 15: | ||
== Opinions == | == Opinions == | ||
Fields | ==== Fields ==== | ||
;1. Opinion ID | ;1. Opinion ID | ||
:coded as base10 integer number, used to lookup ratings or items on the input website | :coded as base10 integer number, used to lookup ratings or items on the input website | ||
| Line 43: | Line 43: | ||
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. | ||
Fields | ==== Fields ==== | ||
;1. Opinion ID | ;1. Opinion ID | ||
:base10 integer, used to group related ratings | :base10 integer, used to group related ratings | ||
;2. Rating Type | ;2. Rating Type | ||
:one of '' | :one of ''startup'', ''pageload'', ''responsive'', ''crashy'' (higher = more stable), ''features'' | ||
;3. Rating Value | ;3. Rating Value | ||
:base10 integer ranging from | :base10 integer ranging from 1 to 5 | ||