This dataset mirrors bugs (defects, enhancements, tasks) reported in the
Bugzilla bug tracker.
The dataset is accessible via
eng_workflow.bmobugs table with the
Telemetry (BigQuery) data source.
The unique ID of the bug. The bug can be accessed at
bugmail of the user who filed the bug
bugmail of the user the bug has been assigned to
by default, this is
bugmail of the user who is responsible for answering
QA questions about the bug; This field is assigned on a per-
The product in which the bug was filed; see the Bugzilla product descriptions for details
The component of the product in which the bug was filed
The status of the bug:
Controlled vocabulary keywords assigned to the bug
Bugzilla groups to which the bug has been assigned
Flags requested by users of other users
name: the name of the flag such as
bugmailof the user requesting the flag
bugmailof the user who the flag was requested of
The bug's priority, as set by the developers who triage the product::component
---, the resolution of the bug; which includes
Bugs which much be resolved before this bug can be worked on or resolved
Bugs depending on the resolution of this bug before they can be resolved.
If the bug has been resolved as
DUPLICATE, the id of the bug of which
this is a duplicate
List of bugs which have been resolved as duplicates of this bug
The version number of the branch of Nightly in which the change set associated with the bug was landed; note that version numbers vary by product
The version of Firefox in which the bug was reported
The timestamp of when the bug was last modified
The timestamp of when the bug was filed
Select the number of bugs in the Core product filed in the past 7 days:
product = 'Core'
AND date_diff(current_date(), date(parse_timestamp('%Y-%m-%d %H:%M:%S', creation_ts)), DAY) <= 7
AND date(submission_timestamp) >= '2019-01-01' -- required submission date filter
The dataset is populated via the simple ping service on Bugzilla.