Employee Records

This dataset provides a comprehensive view of employee records, including personal information, job roles, departmental assignments, salary details, employment history, and performance metrics. It is designed to support workforce management, HR analytics, and organizational planning, making it ideal for data-driven decision-making in human resources.

  • opened 13 times
  • last updated 29 Oct 2025
  • by GoMask
The brief that made it

Workforce analytics and reporting

Sample rows

preview · 8 of 202 rows · all 26 columns
employee_idstringemployment_statusstringperformance_scorefloattraining_completedbooleanperformance_ratingstringfirst_namestringlast_namestringdate_of_birthdateemailstringphone_numberstringaddress_streetstringaddress_citystringaddress_statestringaddress_postal_codestringaddress_countrystringdepartmentstringjob_titlestringmanager_idstringhire_datedatesalaryfloatsalary_currencystringemployment_history_companystringemployment_history_job_titlestringemployment_history_start_datedateemployment_history_end_datedatelast_promotion_datedate
A1X7H2Active94.3trueOutstandingIsabellaMartinez1988-06-19isabella.martinez@acme.com+1-213-555-01971022 Oakwood AveLos AngelesCA90015USAEngineeringLead Software Engineerblank2016-05-02145000USDInnotechSenior Developer2012-04-012016-04-152021-11-13
B3T6K9Active89.2trueExceeds ExpectationsAdityaSingh1992-02-15aditya.singh@acme.com+91-98765-32109204 Crescent RoadMumbaiMH400001IndiaFinanceFinancial AnalystG7J2F12019-07-10680000INRMoneywiseJunior Analyst2017-06-012019-06-302022-03-25
C8F2E3Active91.8trueOutstandingSophieDurand1981-10-03sophie.durand@acme.com+33-1-45-67-891277 Boulevard VoltaireParisblank75011FranceMarketingMarketing Directorblank2012-09-1797000EURBrandixMarketing Manager2008-05-012012-08-102017-05-06
D9W5U8RetiredblankfalseblankMichaelJohnson1962-11-24m.johnson@acme.com+1-312-555-0148501 N State StreetChicagoIL60654USAOperationsOperations Managerblank2006-01-120USDLogixSenior Operations Analyst1998-03-012005-12-312012-06-01
E7G4C5Active92.5trueOutstandingMariaGonzalez1976-05-04maria.gonzalez@acme.com+34-91-555-654311 Calle MayorMadridblank28013SpainSalesSales Directorblank2010-03-08128000EURVendicoSales Manager2006-01-012010-02-152018-02-10
F6L2V7Active85.7trueExceeds ExpectationsDavidEvans1989-08-22d.evans@acme.com+44-20-7946-081225 Fleet StreetLondonblankEC4Y 1AAUKLegalLegal CounselQ4E8N22020-01-1573000GBPLawCorpJunior Counsel2018-01-012019-12-31blank
G7J2F1Active76.8trueMeets ExpectationsChenWang1997-12-05chen.wang@acme.com+86-21-5555-112288 Huaihai RoadShanghaiblank200031ChinaEngineeringJunior DeveloperA1X7H22022-02-0198000CNYTechNovaIntern2021-07-012022-01-15blank
H5U9M4Active80.1trueExceeds ExpectationsNiaMwangi1990-03-12nia.mwangi@acme.com+254-20-555-223314 Kenyatta AveNairobiblank00100KenyaOperationsOperations SpecialistD9W5U82021-06-141200000KESAfricorpLogistics Coordinator2018-03-012021-05-30blank

What the 202 rows show

from the 202-row sample

Active (employment status) stands out: 149 of its 170 rows have training_completed = true, against 0 of 32 for the rest.

  • 74%training_completed = true
  • 79.2median performance_score
  • 9departments
  • 13salary currencies
  • 30address countries
  • 52address cities
Training completed rate by employment_statustraining_completed = true
0%50%100%88%Active149 of 1700%On Leave0 of 40%Terminat…0 of 70%Retired0 of 21
performance_score175 rows, in bands of 10
0408020000015744737050100performance_score →

Median 79.2, from 0.0 to 97.2.

performance_rating175 rows with a value · 27 left blank
  1. Meets Expectations88
  2. Outstanding37
  3. Exceeds Expectations36
  4. Needs Improvement12
  5. Unsatisfactory2
26 columns by typefrom the column list below
  • string 18
  • float 2
  • date 5
  • boolean 1

Columns

26 columns in four groups
blueprint · 26 columns
columntypedescriptionexample
Text 18 columns
employee_idstringUnique identifier for each employeeuniqueA1X7H2
first_namestringEmployee's first nameIsabella
last_namestringEmployee's last nameMartinez
emailstringEmployee's work email addressuniqueaditya.singh@acme.com
phone_numberstringEmployee's contact phone numberoptional+1-213-555-0197
address_streetstringEmployee's residential street addressoptional1022 Oakwood Ave
address_citystringEmployee's city of residenceoptionalLos Angeles
address_statestringEmployee's state or province of residenceoptionalCA
address_postal_codestringEmployee's postal codeoptional90015
address_countrystringEmployee's country of residenceoptionalUSA
departmentstringDepartment where the employee works9 valuesEngineering
job_titlestringEmployee's current job titleLead Software Engineer
manager_idstringEmployee ID of the direct manageroptionalG7J2F1
employment_statusstringCurrent employment statusActive · On Leave · Terminated · RetiredActive
salary_currencystringCurrency code for salary (e.g., USD, EUR)USD
employment_history_companystringName of previous employer (most recent)optionalInnotech
employment_history_job_titlestringJob title at previous employer (most recent)optionalSenior Developer
performance_ratingstringMost recent performance rating category5 values · optionalOutstanding
Numbers 2 columns
salaryfloatCurrent annual salary of the employee in local currency0 or more145000
performance_scorefloatMost recent performance evaluation score (0-100)0 to 100 · optional94.3
Dates and times 5 columns
date_of_birthdateEmployee's date of birth1988-06-19
hire_datedateDate when the employee was hired2016-05-02
employment_history_start_datedateStart date at previous employer (most recent)optional2012-04-01
employment_history_end_datedateEnd date at previous employer (most recent)optional2016-04-15
last_promotion_datedateDate of last promotionoptional2021-11-13
True or false 1 column
training_completedbooleanIndicates if mandatory training has been completedoptionaltrue

Use it for

  • training compl…74%149 of 202 rowstraining completed by…88%Acti…0%On L…0%Term…0%Reti…

    A human resources dashboard

    The training_completed rate, performance_score by employment_status and a breakdown of performance_rating. Excel, Power BI or Tableau.

  • Why do 149 of 202 rows have training_completed = 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 employees with first_name, last_name and date_of_birth to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset202 rows26 columns
Yours10,000 rows26 columnsaddress_street: UK only

blueprint · employee-records

Behind this dataset

Same schema. As many rows as you need.

These 202 rows came out of a blueprint — 26 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
  • Hire date must be before current date
  • Salary ranges by department and seniority level
  • Manager IDs reference other employees in dataset
  • Department codes from predefined list
  • Employment status affects benefits eligibility
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
employee-records

What should your data show?

Preview 20 rows free
No signup. No card.