# The Three Types of Data

> Structured, semi-structured and unstructured data, and how to tell them apart. What each one looks like, where it is kept, and why the shape matters.

**Course:** [Data Engineering Basics](https://learn.benibix.com/learn/data-foundations)  
**Time:** 10 min

**After this lesson you can:**

- Sort a piece of data into one of the three types
- Say where each type is usually kept
- Explain why shape decides how easy data is to count

## How structured, semi-structured and unstructured data differ

Data comes in three shapes. Structured data fits in rows and columns, like a table of orders. Semi-structured data carries labels but no fixed table, like a JSON file. Unstructured data has no labels at all, like an email, a photo or a phone call. The shape decides how easy the data is to search and count.

Structured data has a fixed set of columns, and every row fills the same ones. A table of orders has an order number, a date, a customer and a total. Because the shape is known, a database can check each value as it is saved. It can also add up millions of rows in a second.

Semi-structured data labels each value but lets records differ. In JSON, one order might list a coupon and the next might not. A record can also hold a list inside it, such as five items in one order. Logs from apps and replies from web APIs usually come in this shape.

Unstructured data has no labels a computer can use. A support email says the parcel came late, but there is no field called late. A photo of a broken item holds the facts in pixels. To count anything in it, a person or a model has to read it first and pull the facts out.

Most data moves toward more structure over its life. A team takes a JSON log and flattens it into a table. A model reads emails and tags each one with a topic. Each step makes the data easier to count. Each step can also lose something the original said.

People often call JSON unstructured because it is not a table. But it has a label on every value. A program can read it without guessing. That makes it semi-structured. Most warehouses today can query it as it is.

## The three types side by side

| Type | Looks like | Labels on values | Usually kept in |
| --- | --- | --- | --- |
| Structured | A table of orders | Yes, fixed columns | A database or warehouse |
| Semi-structured | A JSON file, an app log | Yes, but records can differ | Files, or a warehouse that reads JSON |
| Unstructured | Emails, photos, calls | No | Files in cheap storage |

## Where to keep each one

1. **Structured.** Keep it in a database or a warehouse. There, each column is checked as rows come in.
2. **Semi-structured.** Land it as files first. Then flatten the fields you use most into a table.
3. **Unstructured.** Keep the files in cheap storage. Save the facts you pull out of them as a table beside them.

![Three panels. Structured: a small table with order, date and total columns and three rows of numbers. Semi-structured: two JSON records, the first with an order number, a coupon and items, the second with no coupon. Unstructured, drawn with a dashed border: the start of a support email about a late, torn parcel, plus a photo and a call recording.](https://learn.benibix.com/diagrams/dfd-data-types.svg)

### Example: One shop, three shapes

Emma's shop holds 12,000 orders in a table, 2 million app log lines in JSON and 3,000 support emails.

Counting orders by day takes one query. Counting late parcels took a week. Then a model tagged each email and saved the tags as a table.

**Words in this lesson:** [Structured Data](https://learn.benibix.com/term/data/structured-data), [Semi-Structured Data](https://learn.benibix.com/term/data/semi-structured-data), [Unstructured Data](https://learn.benibix.com/term/data/unstructured-data)

> **The one thing to remember.** Structured data has fixed columns. Semi-structured data has labels, but they can vary. Unstructured data has no labels at all. Something must read it before you can count it.

**Question:** Which type of data is a JSON file from an app?

**Answer:** Semi-structured. Every value in JSON carries a label, but records do not all need the same fields. That is the mark of semi-structured data.

---

Source: https://learn.benibix.com/learn/data-foundations/types-of-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-19
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
