Hybrid Productivity Time Logs
This dataset provides granular time log entries for employees working in hybrid environments, detailing work hours, tasks, locations, and project associations. It enables managers to analyze productivity trends, optimize resource allocation, and balance remote versus office workflows for improved operational efficiency.
Sample rows
preview · 8 of 200 rows · all 23 columns| log_idstring | manager_idstring | hours_workedfloat | is_billableboolean | location_address_citystring | employee_idstring | employee_namestring | departmentstring | datedate | start_timedatetime | end_timedatetime | work_locationstring | task_idstring | task_namestring | task_categorystring | project_idstring | project_namestring | location_address_streetstring | location_address_statestring | location_address_postal_codestring | location_address_countrystring | notesstring | task_descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A2B9-3KQX | MGR01 | 6 | true | San Francisco | EMP1052 | Priya Natarajan | Engineering | 2024-06-24 | 2024-06-24T08:10:00 | 2024-06-24T14:10:00 | office | TSK-146 | Backend API integration | coding | PRJ-8905 | Fintech Gateway | 501 Market Street | CA | 94105 | USA | Deployment prep for project milestone. | Implemented authentication and data flow for new payment microservice. |
| 6JXQ1Z9B | MGR03 | 3 | false | blank | EMP9921 | Emily Zhang | Support | 2024-06-28 | 2024-06-28T11:00:00 | 2024-06-28T14:00:00 | remote | TSK-243 | Client ticket resolution | support | blank | blank | blank | blank | blank | blank | All tickets closed successfully. | Resolved three Tier 2 tickets for client ACME Corp relating to login issues. |
| XZ4QWJ8D | MGR07 | 3.5 | true | São Paulo | EMP2104 | Lucas Oliveira | Design | 2024-06-25 | 2024-06-25T09:30:00 | 2024-06-25T13:00:00 | client-site | TSK-159 | Branding workshop presentation | design | PRJ-6721 | Client Rebrand | Rua Augusta 320 | SP | 01304-000 | Brazil | Positive client feedback. | Led branding strategy session at client site in São Paulo, discussed logo concepts. |
| L47K-J9T8 | MGR06 | 3 | false | Berlin | EMP0087 | Amina Hassan | Documentation | 2024-06-27 | 2024-06-27T10:45:00 | 2024-06-27T13:45:00 | office | TSK-115 | User manual update sprint | documentation | blank | blank | Hauptstrasse 14 | BE | 10115 | Germany | blank | Reviewed and updated user manual sections for the new release, incorporating QA feedback. |
| 9QJK2Z8W | MGR09 | 2 | false | Mexico City | EMP5123 | Carlos Mendoza | HR | 2024-06-24 | 2024-06-24T13:00:00 | 2024-06-24T15:00:00 | office | TSK-201 | Onboarding session for new hires | meeting | blank | blank | Ave. Insurgentes 510 | CDMX | 03100 | Mexico | Session completed, documents distributed. | Conducted onboarding presentation for five new employees, explained benefits and policies. |
| JMK5Z2Q9 | blank | 24 | false | blank | EMP7786 | Sofia Nilsson | Documentation | 2024-06-26 | 2024-06-26T00:00:00 | 2024-06-26T00:00:00 | remote | TSK-209 | Release notes marathon session | documentation | blank | blank | blank | blank | blank | blank | Edge case: 24-hour session due to release deadline. | Completed a 24-hour documentation session for urgent release notes, covering all sprint features. |
| ZK3J-9X7T | MGR02 | 8.5 | true | Chicago | EMP3208 | David Lee | Engineering | 2024-06-23 | 2024-06-23T09:00:00 | 2024-06-23T17:30:00 | office | TSK-133 | System performance review | review | PRJ-4321 | Core Platform | 233 Wacker Drive | IL | 60606 | USA | Reviewed server logs and performance charts. | Analyzed and documented system performance metrics for quarterly review. |
| M8WQK-2Z7 | blank | 2 | true | Dubai | EMP4231 | Fatima Al Fahim | Design | 2024-06-26 | 2024-06-26T16:00:00 | 2024-06-26T18:00:00 | client-site | TSK-105 | UX workshop with stakeholders | meeting | PRJ-1184 | UX Redesign Project | Sheikh Zayed Rd 183 | DU | 00000 | UAE | Stakeholder engagement above expectations. | Facilitated UX workshop at Dubai client office, gathered stakeholder feedback on prototypes. |
| QK9X8Z4W | MGR03 | 3 | false | blank | EMP0591 | John McGregor | Support | 2024-06-24 | 2024-06-24T23:00:00 | 2024-06-25T02:00:00 | remote | TSK-172 | Overnight system monitoring | support | blank | blank | blank | blank | blank | blank | Edge case: overnight monitoring. | Monitored batch processes overnight, ensured successful backups and processed alerts. |
| VQ1JXK79 | MGR06 | 2 | false | blank | EMP6217 | Lina Schmidt | Documentation | 2024-06-25 | 2024-06-25T12:00:00 | 2024-06-25T14:00:00 | remote | TSK-201 | Documentation for new feature | documentation | blank | blank | blank | blank | blank | blank | blank | Drafted help center articles for newly released feature, coordinated with QA for details. |
| WQXJ-7K8Z | MGR05 | 6 | false | Tokyo | EMP1804 | Miyuki Tanaka | Engineering | 2024-06-26 | 2024-06-26T08:00:00 | 2024-06-26T14:00:00 | office | TSK-144 | Frontend component refactor | coding | blank | blank | 1-9 Akasaka | ST | 1070052 | Japan | Refactor covered 6 components. | Refactored React components for improved maintainability, reduced code duplication. |
| KJ8X4ZQW | MGR01 | 4 | false | Stockholm | EMP2762 | Anna Svensson | Engineering | 2024-06-25 | 2024-06-25T13:00:00 | 2024-06-25T17:00:00 | office | TSK-158 | Code review and merge | review | blank | blank | Kungsgatan 25 | ST | 11135 | Sweden | blank | Reviewed pull requests for new mobile features, merged and deployed to QA branch. |
| B9JKWQX3 | MGR03 | 1 | false | blank | EMP5892 | Chike Okafor | Support | 2024-06-27 | 2024-06-27T15:00:00 | 2024-06-27T16:00:00 | remote | TSK-210 | Ticket escalation follow-up | support | blank | blank | blank | blank | blank | blank | blank | Followed up on two escalated support tickets, coordinated with engineering for fix deployment. |
| N4JQKX87 | MGR02 | 8 | true | Cairo | EMP3978 | Omar El-Gamal | Engineering | 2024-06-23 | 2024-06-23T10:00:00 | 2024-06-23T18:00:00 | office | TSK-155 | Microservice architecture planning | design | PRJ-9922 | NextGen Systems | 5th Floor, Nile Tower | CAI | 11511 | Egypt | Architecture approved by CTO. | Outlined microservice architecture for upcoming release, created initial diagrams. |
| Q7KZJX28 | MGR09 | 1 | false | New York | EMP1349 | Samantha Riley | HR | 2024-06-28 | 2024-06-28T09:00:00 | 2024-06-28T10:00:00 | office | TSK-239 | Benefits Q&A session | meeting | blank | blank | 120 Broadway | NY | 10271 | USA | blank | Answered employee questions regarding health insurance, leave, and payroll. |
| ZKQXJ-871 | MGR05 | 6 | true | Shanghai | EMP4192 | Wei Chen | Engineering | 2024-06-27 | 2024-06-27T16:00:00 | 2024-06-27T22:00:00 | office | TSK-134 | Database migration testing | coding | PRJ-8234 | Migration Initiative | 88 Xintiandi Road | SH | 200021 | China | No migration errors found. | Tested migration scripts for new database, validated data integrity and rollback procedures. |
| 7KQJX9W4 | MGR03 | 3 | false | blank | EMP6724 | Santiago Ramos | Support | 2024-06-28 | 2024-06-28T10:00:00 | 2024-06-28T13:00:00 | remote | TSK-217 | Live chat customer support | support | blank | blank | blank | blank | blank | blank | blank | Handled live chat support for Spanish-speaking customers, resolved six queries. |
| K8JQXW29 | MGR01 | 8.75 | true | Toronto | EMP8231 | Nia Williams | Engineering | 2024-06-23 | 2024-06-23T07:45:00 | 2024-06-23T16:30:00 | office | TSK-176 | Infrastructure deployment | coding | PRJ-7215 | Cloud Migration | 400 King Street West | ON | M5V 1K2 | Canada | Deployment completed ahead of schedule. | Deployed and configured new cloud infrastructure for production environment. |
| JQXK9Z47 | MGR02 | 1 | false | Dublin | EMP5167 | Liam Murphy | Engineering | 2024-06-25 | 2024-06-25T17:00:00 | 2024-06-25T18:00:00 | office | TSK-169 | Sprint retrospective meeting | meeting | blank | blank | Fitzwilliam Street 12 | DU | D02 YT21 | Ireland | blank | Participated in sprint retrospective, discussed team challenges and successes. |
| KJQX87Z9 | blank | 3 | true | London | EMP3402 | Anastasia Petrova | Design | 2024-06-28 | 2024-06-28T14:00:00 | 2024-06-28T17:00:00 | client-site | TSK-195 | Design review meeting | review | PRJ-8520 | UI Revamp | 221B Baker Street | LDN | NW1 6XE | UK | Client requested additional mockups. | Presented design review to client in London, collected feedback for next phase. |
What the 200 rows show
from the 200-row sampleMGR07 (manager id) stands out: 22 of its 22 rows have is_
- 44%is_
billable = true - 3.5median hours_
worked - 3work locations
- 5departments
- 7task categories
- 19location address states
Median 3.5, from 0.0 to 24.0.
- string 18
- float 1
- date 1
- datetime 2
- boolean 1
Columns
23 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
log_id | string | Unique identifier for each productivity time log entryunique | A2B9-3KQX |
employee_id | string | Unique identifier for the employee | EMP1052 |
employee_name | string | Full name of the employee | Priya Natarajan |
department | string | Department where the employee works5 departments | Engineering |
manager_id | string | Unique identifier for the employee's manager8 managers · optional | MGR01 |
work_location | string | Location where the work was performed (e.g., office, remote, client site)office · remote · client-site · other | office |
task_id | string | Unique identifier for the task performed | TSK-146 |
task_name | string | Name or short description of the task | Backend API integration |
task_category | string | Category of the task (e.g., meeting, coding, documentation, support)7 values | coding |
task_description | string | Detailed description of the task performedoptional | Implemented authenticatio… |
project_id | string | Unique identifier for the project associated with the taskoptional | PRJ-8905 |
project_name | string | Name of the project associated with the taskoptional | Fintech Gateway |
location_address_street | string | Street address of the work location (if office or client site)optional | 501 Market Street |
location_address_city | string | City of the work locationoptional | San Francisco |
location_address_state | string | State or province of the work locationoptional | CA |
location_address_postal_code | string | Postal code of the work locationoptional | 94105 |
location_address_country | string | Country of the work locationoptional | USA |
notes | string | Additional notes or comments regarding the log entryoptional | Deployment successful. |
| Numbers 1 column | |||
hours_worked | float | Total hours spent on the task during the log entry0 to 24 | 6 |
| Dates and times 3 columns | |||
date | date | Date of the work log entry | 2024-06-24 |
start_time | datetime | Timestamp when the employee started working | 2024-06-24T08:10:00 |
end_time | datetime | Timestamp when the employee finished working | 2024-06-24T14:10:00 |
| True or false 1 column | |||
is_billable | boolean | Indicates if the task is billable to a client or projectoptional | true |
Use it for
A human resources dashboard
The is_
billable rate, hours_ worked by manager_ id and a breakdown of location_ address_ city. Excel, Power BI or Tableau. Why do 87 of 200 rows have is_
billable = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Logs200A2B9-3KQX6MGR016JXQ1Z9B3MGR03XZ4QWJ8D3.5MGR07
A software demo
Believable logs with employee_
id, employee_ name and department to fill a screen in front of a buyer.
blueprint · hybrid-productivity-time-logs
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 23 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.
- Include work mode (remote, office, hybrid)
- Log daily task completion status
- Record time spent per task
- Flag overtime and underperformance
- Anonymize employee identifiers
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
- hybrid-productivity-time-logs