Bug Report Resolution Timelines
This dataset provides comprehensive logs of software bug reports, including detailed descriptions, severity, priority, assignment, and timestamps for each stage of the bug lifecycle. It enables in-depth analysis of resolution timelines, developer efficiency, and project quality, making it valuable for process optimization and engineering management.
Sample rows
preview · 8 of 76 rows · all 17 columns| bug_idstring | statusstring | resolution_time_hoursfloat | assignee_idstring | titlestring | reporter_idstring | project_idstring | severitystring | prioritystring | created_atdatetime | updated_atdatetime | resolved_atdatetime | closed_atdatetime | componentstring | environmentstring | tagsstring | descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| BUG-20240601-001 | closed | 7.25 | DEV-201 | App crashes on login | USR-101 | PROJ-ALPHA | critical | urgent | 2024-04-11T09:15:22 | 2024-04-12T14:42:19 | 2024-04-11T16:30:00 | 2024-04-12T14:42:19 | Authentication | production | crash,login,urgent | After entering valid credentials, the application crashes unexpectedly. Steps: Open app, enter username and password, tap login. |
| BUG-20240601-002 | resolved | 26.78 | DEV-205 | UI glitch on dashboard widgets | USR-103 | PROJ-ALPHA | medium | normal | 2024-04-15T10:08:17 | 2024-04-16T13:20:43 | 2024-04-16T12:55:00 | blank | Dashboard | development | ui,widget,resize | Dashboard widgets overlap on screen resize. Steps: Log in, resize window, observe widget positions. |
| BUG-20240601-003 | in_progress | blank | DEV-202 | Slow response after submitting form | USR-107 | PROJ-BETA | high | high | 2024-04-17T15:04:31 | 2024-04-18T10:00:12 | blank | blank | Registration | staging | performance,form | Submitting the registration form takes over 10 seconds to respond. Steps: Fill registration form, click submit. |
| BUG-20240601-004 | open | blank | DEV-207 | Forgot password email not sent | USR-110 | PROJ-GAMMA | high | urgent | 2024-05-01T11:51:09 | 2024-05-01T11:51:09 | blank | blank | Email Service | production | email,forgot_password | No reset email received after requesting password reset. Steps: Click 'Forgot Password', check email inbox. |
| BUG-20240601-005 | duplicate | blank | DEV-203 | Data not syncing between devices | USR-102 | PROJ-ALPHA | medium | normal | 2024-04-10T08:05:17 | 2024-04-10T15:40:00 | blank | blank | Sync Engine | production | sync,mobile,web | Updated data on one device doesn't reflect on another. Steps: Add note on mobile, check on web app. |
| BUG-20240601-006 | wont_fix | blank | DEV-204 | Exported CSV has wrong delimiter | USR-108 | PROJ-DELTA | low | low | 2024-04-23T13:32:05 | 2024-04-24T09:12:01 | blank | blank | Export | staging | csv,delimiter,export | CSV export uses semicolons instead of commas. Steps: Export data, open file in Excel. |
| BUG-20240601-007 | resolved | 18.46 | DEV-209 | Profile picture upload fails for large files | USR-105 | PROJ-ALPHA | medium | normal | 2024-04-28T17:39:45 | 2024-04-29T13:00:00 | 2024-04-29T12:07:00 | blank | User Profile | testing | upload,image,profile | Images over 5MB fail to upload. Steps: Go to profile, upload a 6MB image. |
| BUG-20240601-008 | closed | 30.75 | DEV-206 | Session expires too quickly | USR-101 | PROJ-ALPHA | low | low | 2024-04-18T09:00:00 | 2024-04-20T11:22:00 | 2024-04-19T15:45:00 | 2024-04-20T11:22:00 | Session Manager | production | session,timeout | Users are logged out after 5 minutes of inactivity, should be 30 minutes. Steps: Log in, wait 6 minutes. |
| BUG-20240601-009 | in_progress | blank | DEV-208 | Notification badge not clearing | USR-106 | PROJ-BETA | medium | normal | 2024-04-24T08:16:38 | 2024-04-28T13:05:10 | blank | blank | Notifications | production | notification,badge | After reading all messages, notification badge remains visible. Steps: Read all messages, observe badge. |
| BUG-20240601-010 | open | blank | DEV-202 | Incorrect timezone displayed | USR-109 | PROJ-GAMMA | low | normal | 2024-05-03T15:55:10 | 2024-05-03T15:55:10 | blank | blank | Calendar | staging | timezone,event | Event times are shown in UTC instead of local timezone. Steps: Create event, check event time. |
| BUG-20240601-011 | reopened | blank | DEV-205 | Search returns duplicate results | USR-102 | PROJ-DELTA | medium | high | 2024-04-12T11:20:33 | 2024-04-15T13:41:00 | blank | blank | Search | testing | search,duplicate | Searching for a term returns the same record multiple times. Steps: Use search bar, observe results. |
| BUG-20240601-012 | resolved | 4.97 | DEV-210 | Button label truncates on mobile | USR-105 | PROJ-BETA | low | low | 2024-04-13T13:10:47 | 2024-04-13T18:19:22 | 2024-04-13T18:09:00 | blank | UI | development | mobile,ui,label | Submit button label is cut off on small screens. Steps: Open app on mobile, view submit button. |
| BUG-20240601-013 | in_progress | blank | DEV-203 | API returns HTTP 500 error | USR-110 | PROJ-GAMMA | critical | urgent | 2024-04-30T08:30:00 | 2024-05-01T09:20:00 | blank | blank | API | production | api,server,error | POST request to /api/items sometimes fails with 500. Steps: Send multiple requests, observe error. |
| BUG-20240601-014 | closed | 53.25 | DEV-202 | Settings page not loading | USR-104 | PROJ-ALPHA | high | high | 2024-04-19T11:45:00 | 2024-04-22T16:10:00 | 2024-04-21T17:00:00 | 2024-04-22T16:10:00 | Settings | production | settings,blank | Settings page displays blank screen. Steps: Log in, navigate to settings. |
| BUG-20240601-015 | wont_fix | blank | DEV-206 | App freezes on logout | USR-107 | PROJ-BETA | medium | normal | 2024-04-14T13:30:20 | 2024-04-17T15:00:00 | blank | blank | Session Manager | testing | logout,freeze | Freezes when logging out. Steps: Tap logout from main menu. |
| BUG-20240601-016 | resolved | 1.75 | DEV-204 | Incorrect error message shown | USR-106 | PROJ-DELTA | low | low | 2024-04-20T08:45:00 | 2024-04-20T10:40:00 | 2024-04-20T10:30:00 | blank | Authentication | development | error,message | Displays 'Invalid password' when username is wrong. Steps: Enter wrong username, any password. |
| BUG-20240601-017 | open | blank | DEV-210 | Analytics chart not rendering | USR-103 | PROJ-GAMMA | medium | normal | 2024-05-04T10:15:12 | 2024-05-04T10:15:12 | blank | blank | Analytics | staging | analytics,chart,blank | Blank area where analytics chart should be. Steps: Go to analytics page. |
| BUG-20240601-018 | resolved | 8.58 | DEV-208 | User can't change password | USR-109 | PROJ-DELTA | high | high | 2024-04-27T09:10:00 | 2024-04-27T18:00:00 | 2024-04-27T17:45:00 | blank | User Profile | production | password,profile | Error shown when trying to update password. Steps: Profile > Change Password > Save. |
| BUG-20240601-019 | in_progress | blank | DEV-206 | Push notifications not received on iOS | USR-101 | PROJ-ALPHA | critical | urgent | 2024-04-26T08:50:00 | 2024-04-28T14:00:00 | blank | blank | Notifications | production | push,ios,notifications | No push notifications received on iOS devices. Steps: Enable notifications in app settings, trigger event. |
| BUG-20240601-020 | open | blank | DEV-205 | App version not updating | USR-108 | PROJ-GAMMA | low | low | 2024-05-05T08:22:09 | 2024-05-05T08:22:09 | blank | blank | Release | production | version,update | App store shows old version after update. Steps: Update app, check version in app store. |
What the 76 rows show
from the 76-row sampleClosed status stands out: mean resolution_
- 18.7median resolution_
time_ hours - 4severities
- 4priorities
- 4environments
- 8projects
- 16reporters
Median 18.7, from 1.8 to 100.5.
- string 12
- float 1
- datetime 4
Columns
17 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
bug_id | string | Unique identifier for the bug reportunique | BUG-20240601-001 |
title | string | Short, descriptive title of the bugup to 200 | App crashes on login |
description | string | Detailed description of the bug, including steps to reproduce | After entering valid cred… |
reporter_id | string | Unique identifier for the user who reported the bug | USR-101 |
assignee_id | string | Unique identifier for the developer assigned to resolve the bugoptional | DEV-201 |
project_id | string | Identifier for the project or software module where the bug was found8 projects | PROJ-ALPHA |
severity | string | Severity level of the bugcritical · high · medium · low | critical |
priority | string | Priority assigned to the bug for resolutionurgent · high · normal · low | urgent |
status | string | Current status of the bug report7 values | closed |
component | string | Specific software component or module affected by the bugup to 100 · optional | Authentication |
environment | string | Environment in which the bug was observed (e.g., production, staging, development)production · staging · development · testing · optional | production |
tags | string | Comma-separated list of tags or keywords associated with the bugoptional | crash,login,urgent |
| Numbers 1 column | |||
resolution_time_hours | float | Time taken to resolve the bug in hours, calculated as the difference between created_at and resolved_at0 or more · optional | 7.25 |
| Dates and times 4 columns | |||
created_at | datetime | Timestamp when the bug report was created | 2024-04-11T09:15:22 |
updated_at | datetime | Timestamp of the most recent update to the bug report | 2024-04-12T14:42:19 |
resolved_at | datetime | Timestamp when the bug was marked as resolvedoptional | 2024-04-11T16:30:00 |
closed_at | datetime | Timestamp when the bug was closedoptional | 2024-04-12T14:42:19 |
Use it for
A technology dashboard
Resolution_
time_ hours by status and a breakdown of assignee_ id. Excel, Power BI or Tableau. Why do the 12 closed rows have a mean resolution_
time_ hours of 28.9? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Bugs76BUG-20240601-0017.25closedBUG-20240601-00226.78resolvedBUG-20240601-003in_progr…
A software demo
Believable bugs with title, description and reporter_
id to fill a screen in front of a buyer.
This dataset76 rows17 columns
Yours1,000 rows17 columns
blueprint · bug-report-resolution-timelines
Behind this dataset
Same schema. As many rows as you need.
These 76 rows came out of a blueprint — 17 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Record bug report and resolution dates
- Categorize bugs by severity
- Flag bugs unresolved after 7 days
- Aggregate mean time to resolution
- Sort by assigned developer
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- bug-report-resolution-timelines