Workspace/Understand data
← Datasets

demo-users.ndjson

NDJSON
Clean data
Download
Format details

Original file preserves the source exactly, including all Excel sheets.

Excel saves values as text, nested values as JSON text and empty values as blank cells. Lossless Parquet stores complete records in one JSON column. Typed Parquet creates analytical columns: nested/mixed values and numbers outside exact decimal limits become text; missing and null merge.

CSV stores nested values as JSON text. TOML uses a records wrapper and cannot represent null values. Check format changes to review your actual data before downloading.

More tools

← Back to data

Understand your data

Checked 100 of 100 rows.

active · boolean
Missing: 0Null: 0Empty text: 0Repeated non-null: 98Distinct: 2

Common values in checked rows

  • true · 67
  • false · 33
amount · number
Missing: 0Null: 0Empty text: 0Repeated non-null: 0Distinct: 100Minimum: 42.42Maximum: 9989.89Mean (approximate): 5096.27780000

Common values in checked rows (tracked values only)

  • 1148.48 · 1
  • 1204.04 · 1
  • 1553.53 · 1
  • 1609.09 · 1
  • 1665.65 · 1
category · string
Missing: 0Null: 0Empty text: 0Repeated non-null: 96Distinct: 4

Common values in checked rows

  • "analytics" · 25
  • "engineering" · 25
  • "platform" · 25
  • "retail" · 25
country · string
Missing: 0Null: 0Empty text: 0Repeated non-null: 96Distinct: 4

Common values in checked rows

  • "DE" · 25
  • "GB" · 25
  • "JP" · 25
  • "US" · 25
email · string
Missing: 0Null: 0Empty text: 0Repeated non-null: 0Distinct: 100

Common values in checked rows (tracked values only)

id · number
Missing: 0Null: 0Empty text: 0Repeated non-null: 0Distinct: 100Minimum: 1Maximum: 100Mean (approximate): 50.50000000

Common values in checked rows (tracked values only)

  • 1 · 1
  • 10 · 1
  • 11 · 1
  • 12 · 1
  • 13 · 1
name · string
Missing: 0Null: 0Empty text: 0Repeated non-null: 94Distinct: 6

Common values in checked rows

  • "Ada Lovelace" · 17
  • "Grace Hopper" · 17
  • "Margaret Hamilton" · 17
  • "山田 太郎" · 17
  • "Linus Torvalds" · 16
note · string
Missing: 0Null: 0Empty text: 0Repeated non-null: 0Distinct: 100

Common values in checked rows (tracked values only)

  • "users record 1 · synthetic test data" · 1
  • "users record 10 · synthetic test data" · 1
  • "users record 11 · synthetic test data" · 1
  • "users record 12 · synthetic test data" · 1
  • "users record 13 · synthetic test data" · 1
profile · string
Missing: 0Null: 0Empty text: 0Repeated non-null: 99Distinct: 1

Common values in checked rows

  • "users" · 100
role · string
Missing: 0Null: 0Empty text: 0Repeated non-null: 97Distinct: 3

Common values in checked rows

  • "admin" · 34
  • "editor" · 33
  • "member" · 33
timestamp · string
Missing: 0Null: 0Empty text: 0Repeated non-null: 0Distinct: 100

Common values in checked rows (tracked values only)

  • "2024-01-01T00:00:00Z" · 1
  • "2024-01-01T00:00:01Z" · 1
  • "2024-01-01T00:00:02Z" · 1
  • "2024-01-01T00:00:03Z" · 1
  • "2024-01-01T00:00:04Z" · 1

Suggestions start a new set of changes. Previews do not modify the source. Common values are bounded to 64 tracked common values per column.