# Semi-Structured Data

> Data with labels but no fixed shape. JSON is the best known kind.

**Field:** Data Engineering  
**Category:** Foundations

## Think of it like

It is like a box of labeled jars. Each jar has a name tag, but the jars are not all the same.

## Definition

Semi-structured data has labels but no fixed table shape. Each record names its own fields, so two records can hold different fields. Records can also nest, with a list or a group inside a field. JSON, XML and log lines are common kinds. It is easy to write but takes more work to query.

## Example

One order record holds a gift note, and the next one does not. Both are still valid JSON.

## Example code

```json
{"id": 42, "total": 19.5,
 "items": [{"sku": "A1", "qty": 2}],
 "gift_note": "Happy birthday"}
```

One order. The fields name themselves, and the items sit nested inside it.

## Why it matters

Apps and APIs speak JSON. Most new data arrives in this shape before anyone puts it in a table.

## Common mistake

Calling it unstructured. It has a shape, just not one fixed for every record.

## Three principles

- **Self-describing.** Each record names its own fields.
- **Flexible.** Records may hold different fields.
- **Nested.** Lists and groups can sit inside fields.

## Related terms

- [Structured Data](https://learn.benibix.com/term/data/structured-data)
- [Unstructured Data](https://learn.benibix.com/term/data/unstructured-data)
- [JavaScript Object Notation (JSON)](https://learn.benibix.com/term/development/json)
- [Extensible Markup Language (XML)](https://learn.benibix.com/term/development/xml)
- [Schema-on-Read](https://learn.benibix.com/term/data/schema-on-read)

## Taught in

- [The Three Types of Data](https://learn.benibix.com/learn/data-foundations/types-of-data): Data Engineering Basics, 7/11

---

Source: https://learn.benibix.com/term/data/semi-structured-data
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-20
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
