Sample JSON / Employees
Sample Employees JSON
Fifty employee records with departments, titles, salaries, hire dates, remote flags, and self-referencing manager IDs - a classic HR dataset for org charts and reporting exercises.
https://jsonconsole.com/api/employees.json50 records12 KBCORS: *
Download employees.json·Free for any use, no attribution required (CC0). Endpoint is stable - safe to use in tutorials and READMEs.
Preview
[
{
"id": 1,
"name": "Linus Allen",
"email": "linus.allen@company.example",
"department": "Sales",
"title": "Staff Designer",
"salary": 106000,
"hireDate": "2019-08-27",
"remote": true,
"manager": null
},
{
"id": 2,
"name": "Yukihiro Allen",
"email": "yukihiro.allen@company.example",
"department": "Finance",
"title": "Senior Manager",
"salary": 173000,
"hireDate": "2023-07-06",
"remote": false,
"manager": null
},
{
"id": 3,
"name": "Rasmus Liskov",
"email": "rasmus.liskov@company.example",
"department": "Sales",
"title": "Junior Manager",
"salary": 140000,
"hireDate": "2023-02-23",
"remote": false,
"manager": null
}
]First 3 records shown - the full file has 50 records.
Fields
| Field | Type | Notes |
|---|---|---|
| id / name / email | number / string | company.example addresses |
| department | string | 8 departments (Engineering, Design, ...) |
| title | string | Seniority + role combinations |
| salary | number | 45,000-180,000 |
| hireDate | string (date) | 2015-2026 |
| remote | boolean | ~50/50 split |
| manager | number | null | Self-referencing ID (null for top 5) |
Fetch it in code
JavaScript
const res = await fetch(
"https://jsonconsole.com/api/employees.json"
);
const data = await res.json();Python
import requests
data = requests.get(
"https://jsonconsole.com/api/employees.json"
).json()What this dataset is good for
- Org-chart and hierarchy rendering (self-referencing manager field)
- Group-by/aggregate exercises: average salary by department
- SQL practice - pair with our JSON-to-SQL converter
More sample data
You might also need
Free and in-browser, like everything on JSON Console. Browse all tools →
Mock JSON GeneratorPaste one sample record and generate up to 1,000 mock records with the same structureJSON to CSVPaste a JSON array of objects on the left and get a spreadsheet-ready CSV with headers on the rightJSON to SQLPaste a JSON array and get a CREATE TABLE statement with inferred column types plus one INSERT per rowJSON ViewerExplore documents as tree, table, or graph.JSON FormatterFormat and validate with code, tree, table, and graph views.JSON ComparePaste two JSON documents and see only real differencesJWT DecoderPaste a JWT and instantly see its decoded header and payload with expiry statusJSON to TypeScriptPaste an API response and get TypeScript interfacesJSON MinifyPaste formatted JSON and get the smallest valid version