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.

  • last updated 5 Sept 2025
  • by GoMask
The brief that made it

Analyzing employee productivity trends in hybrid work settings

Sample rows

preview · 8 of 200 rows · all 23 columns
log_idstringmanager_idstringhours_workedfloatis_billablebooleanlocation_address_citystringemployee_idstringemployee_namestringdepartmentstringdatedatestart_timedatetimeend_timedatetimework_locationstringtask_idstringtask_namestringtask_categorystringproject_idstringproject_namestringlocation_address_streetstringlocation_address_statestringlocation_address_postal_codestringlocation_address_countrystringnotesstringtask_descriptionstring
A2B9-3KQXMGR016trueSan FranciscoEMP1052Priya NatarajanEngineering2024-06-242024-06-24T08:10:002024-06-24T14:10:00officeTSK-146Backend API integrationcodingPRJ-8905Fintech Gateway501 Market StreetCA94105USADeployment prep for project milestone.Implemented authentication and data flow for new payment microservice.
6JXQ1Z9BMGR033falseblankEMP9921Emily ZhangSupport2024-06-282024-06-28T11:00:002024-06-28T14:00:00remoteTSK-243Client ticket resolutionsupportblankblankblankblankblankblankAll tickets closed successfully.Resolved three Tier 2 tickets for client ACME Corp relating to login issues.
XZ4QWJ8DMGR073.5trueSão PauloEMP2104Lucas OliveiraDesign2024-06-252024-06-25T09:30:002024-06-25T13:00:00client-siteTSK-159Branding workshop presentationdesignPRJ-6721Client RebrandRua Augusta 320SP01304-000BrazilPositive client feedback.Led branding strategy session at client site in São Paulo, discussed logo concepts.
L47K-J9T8MGR063falseBerlinEMP0087Amina HassanDocumentation2024-06-272024-06-27T10:45:002024-06-27T13:45:00officeTSK-115User manual update sprintdocumentationblankblankHauptstrasse 14BE10115GermanyblankReviewed and updated user manual sections for the new release, incorporating QA feedback.
9QJK2Z8WMGR092falseMexico CityEMP5123Carlos MendozaHR2024-06-242024-06-24T13:00:002024-06-24T15:00:00officeTSK-201Onboarding session for new hiresmeetingblankblankAve. Insurgentes 510CDMX03100MexicoSession completed, documents distributed.Conducted onboarding presentation for five new employees, explained benefits and policies.
JMK5Z2Q9blank24falseblankEMP7786Sofia NilssonDocumentation2024-06-262024-06-26T00:00:002024-06-26T00:00:00remoteTSK-209Release notes marathon sessiondocumentationblankblankblankblankblankblankEdge case: 24-hour session due to release deadline.Completed a 24-hour documentation session for urgent release notes, covering all sprint features.
ZK3J-9X7TMGR028.5trueChicagoEMP3208David LeeEngineering2024-06-232024-06-23T09:00:002024-06-23T17:30:00officeTSK-133System performance reviewreviewPRJ-4321Core Platform233 Wacker DriveIL60606USAReviewed server logs and performance charts.Analyzed and documented system performance metrics for quarterly review.
M8WQK-2Z7blank2trueDubaiEMP4231Fatima Al FahimDesign2024-06-262024-06-26T16:00:002024-06-26T18:00:00client-siteTSK-105UX workshop with stakeholdersmeetingPRJ-1184UX Redesign ProjectSheikh Zayed Rd 183DU00000UAEStakeholder engagement above expectations.Facilitated UX workshop at Dubai client office, gathered stakeholder feedback on prototypes.

What the 200 rows show

from the 200-row sample

MGR07 (manager id) stands out: 22 of its 22 rows have is_billable = true, against 52 of 160 for the rest.

  • 44%is_billable = true
  • 3.5median hours_worked
  • 3work locations
  • 5departments
  • 7task categories
  • 19location address states
Is billable rate by manager_idis_billable = true
0%50%100%14%MGR…6 of…0%MGR…0 of…73%MGR…16 o…100%MGR…22 o…77%MGR…17 o…72%MGR…13 o…0%MGR…0 of…0%MGR…0 of…
hours_worked200 rows, in bands of 2.5
0408076731724610003012.525hours_worked →

Median 3.5, from 0.0 to 24.0.

location_address_city135 rows with a value · 65 left blank
  1. San Francisco27
  2. New York20
  3. Chicago14
  4. Dubai11
  5. Stockholm9
  6. São Paulo8
  7. Berlin7
  8. London6
  9. Paris6
  10. Mexico City5
23 columns by typefrom the column list below
  • string 18
  • float 1
  • date 1
  • datetime 2
  • boolean 1

Columns

23 columns in four groups
blueprint · 23 columns
columntypedescriptionexample
Text 18 columns
log_idstringUnique identifier for each productivity time log entryuniqueA2B9-3KQX
employee_idstringUnique identifier for the employeeEMP1052
employee_namestringFull name of the employeePriya Natarajan
departmentstringDepartment where the employee works5 departmentsEngineering
manager_idstringUnique identifier for the employee's manager8 managers · optionalMGR01
work_locationstringLocation where the work was performed (e.g., office, remote, client site)office · remote · client-site · otheroffice
task_idstringUnique identifier for the task performedTSK-146
task_namestringName or short description of the taskBackend API integration
task_categorystringCategory of the task (e.g., meeting, coding, documentation, support)7 valuescoding
task_descriptionstringDetailed description of the task performedoptionalImplemented authenticatio…
project_idstringUnique identifier for the project associated with the taskoptionalPRJ-8905
project_namestringName of the project associated with the taskoptionalFintech Gateway
location_address_streetstringStreet address of the work location (if office or client site)optional501 Market Street
location_address_citystringCity of the work locationoptionalSan Francisco
location_address_statestringState or province of the work locationoptionalCA
location_address_postal_codestringPostal code of the work locationoptional94105
location_address_countrystringCountry of the work locationoptionalUSA
notesstringAdditional notes or comments regarding the log entryoptionalDeployment successful.
Numbers 1 column
hours_workedfloatTotal hours spent on the task during the log entry0 to 246
Dates and times 3 columns
datedateDate of the work log entry2024-06-24
start_timedatetimeTimestamp when the employee started working2024-06-24T08:10:00
end_timedatetimeTimestamp when the employee finished working2024-06-24T14:10:00
True or false 1 column
is_billablebooleanIndicates if the task is billable to a client or projectoptionaltrue

Use it for

  • is billable44%87 of 200 rowsmean hours worked by …3.2MGR034.3MGR065.6MGR012.4MGR07

    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.

  • A software demo

    Believable logs with employee_id, employee_name and department to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 23 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows23 columns
Yours1,000 rows23 columnswork_location: UK only

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.

Rules it was built with
  • Include work mode (remote, office, hybrid)
  • Log daily task completion status
  • Record time spent per task
  • Flag overtime and underperformance
  • Anonymize employee identifiers
Rows
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
hybrid-productivity-time-logs

What should your data show?

Preview 20 rows free
No signup. No card.