language data world languages integrated
Reading
This dataset catalogs 7,130 world languages, each row keyed by a unique ISO 639-3 code paired with a language name. Only two of the eight columns (iso_639_3, name) parsed cleanly as text; the other six — including data_sources, glottolog, speaker_count, and us_indigenous — were skipped as nested or non-scalar structures and will need flattening before they yield insight. The name column is the most interesting surface feature: it averages about 9 characters, is single-word ~73% of the time, and its top tokens reveal heavy use of regional qualifiers like 'southern', 'northern', 'eastern', and 'central', plus 152–153 entries containing 'language' or 'sign'. Start by unpacking the skipped object columns (especially speaker_count and glottolog) and look at name-token frequencies to understand naming conventions and language-family clustering.
citing: row_count · column_count · columns.iso_639_3.n_unique · columns.iso_639_3.stats.len_mean · columns.name.stats.len_mean · columns.name.stats.one_word_rate · columns.name.top_words · kinds
Charts the summary said to look at first
Show data table
| chars | count |
|---|---|
| 1 – 2 | 25 |
| 2 – 3 | 195 |
| 3 – 4 | 761 |
| 4 – 5 | 1106 |
| 5 – 6 | 1096 |
| 6 – 7 | 847 |
| 7 – 8 | 529 |
| 8 – 9 | 351 |
| 9 – 10 | 278 |
| 10 – 12 | 238 |
| 12 – 13 | 213 |
| 13 – 14 | 215 |
| 14 – 15 | 191 |
| 15 – 16 | 202 |
| 16 – 17 | 149 |
| 17 – 18 | 95 |
| 18 – 19 | 75 |
| 19 – 20 | 72 |
| 20 – 21 | 66 |
| 21 – 22 | 70 |
| 22 – 23 | 154 |
| 23 – 24 | 50 |
| 24 – 25 | 26 |
| 25 – 26 | 30 |
| 26 – 27 | 23 |
| 27 – 28 | 8 |
| 28 – 29 | 7 |
| 29 – 30 | 10 |
| 30 – 31 | 14 |
| 31 – 32 | 6 |
| 32 – 34 | 8 |
| 34 – 35 | 2 |
| 35 – 36 | 10 |
| 36 – 37 | 1 |
| 37 – 38 | 4 |
| 38 – 39 | 0 |
| 39 – 40 | 1 |
| 40 – 41 | 0 |
| 41 – 42 | 1 |
| 42 – 43 | 1 |
Show data table
| chars | count |
|---|---|
| 1 – 2 | 25 |
| 2 – 3 | 195 |
| 3 – 4 | 761 |
| 4 – 5 | 1106 |
| 5 – 6 | 1096 |
| 6 – 7 | 847 |
| 7 – 8 | 529 |
| 8 – 9 | 351 |
| 9 – 10 | 278 |
| 10 – 12 | 238 |
| 12 – 13 | 213 |
| 13 – 14 | 215 |
| 14 – 15 | 191 |
| 15 – 16 | 202 |
| 16 – 17 | 149 |
| 17 – 18 | 95 |
| 18 – 19 | 75 |
| 19 – 20 | 72 |
| 20 – 21 | 66 |
| 21 – 22 | 70 |
| 22 – 23 | 154 |
| 23 – 24 | 50 |
| 24 – 25 | 26 |
| 25 – 26 | 30 |
| 26 – 27 | 23 |
| 27 – 28 | 8 |
| 28 – 29 | 7 |
| 29 – 30 | 10 |
| 30 – 31 | 14 |
| 31 – 32 | 6 |
| 32 – 34 | 8 |
| 34 – 35 | 2 |
| 35 – 36 | 10 |
| 36 – 37 | 1 |
| 37 – 38 | 4 |
| 38 – 39 | 0 |
| 39 – 40 | 1 |
| 40 – 41 | 0 |
| 41 – 42 | 1 |
| 42 – 43 | 1 |
Schema
8 columns| Alerts | ||||
|---|---|---|---|---|
| iso_639_3 | text | 0.0% | 7,130 |
near_unique
one_word
short_text
|
| name | text | 0.0% | 7,130 |
near_unique
one_word
|
| joshua_project | unknown | 0.0% | — |
skipped
|
| glottolog | unknown | 0.0% | — |
skipped
|
| language_history | unknown | 0.0% | — |
skipped
|
| us_indigenous | unknown | 0.0% | — |
skipped
|
| speaker_count | unknown | 0.0% | — |
skipped
|
| data_sources | unknown | 0.0% | — |
skipped
|
iso_639_3
text identifier near_unique one_word short_textThis column holds ISO 639-3 language codes: every value is exactly 3 characters, single-word, and unique across all 7130 rows (vocab_size 7130, len_min/max 3, one_word_rate 1.0). With n_unique equal to n and zero nulls or duplicates, it functions as a primary key for languages rather than a feature. Sample tokens like 'aou', 'aiw', 'aas' match the ISO 639-3 three-letter convention. Treatment: Use as the join key to language-level metadata; do not feed into a model directly.
- n
- 7,130
- nulls
- 0 (0.0%)
- unique
- 7,130
- len_min
- 3
- len_max
- 3
- len_mean
- 3
- len_median
- 3
- len_p95
- 3
- word_mean
- 1
- word_median
- 1
- n_empty
- 0
- n_duplicates
- 0
- duplicate_rate
- 0
- vocab_size
- 7,130
- readability_flesch_mean
- 120.4
- emoji_rate
- 0
- url_rate
- 0
- one_word_rate
- 1
- allcaps_rate
- 0
- boilerplate_rate
- 0
name
text identifier near_unique one_wordThis column appears to be a unique name identifier, likely for languages given the prominence of 'language', 'sign', 'zapotec', 'mixtec', and 'naga' in top words. All 7130 values are unique (n_unique equals n) with zero nulls or duplicates, and 72.9% are single words with a mean length of ~9 characters. The directional modifiers (southern, northern, western, eastern, central) suggest many entries are regional language variants. Treatment: Use as a primary key or label; do not feed raw into models.
- n
- 7,130
- nulls
- 0 (0.0%)
- unique
- 7,130
- len_min
- 1
- len_max
- 43
- len_mean
- 8.994
- len_median
- 7
- len_p95
- 21
- word_mean
- 1.372
- word_median
- 1
- n_empty
- 0
- n_duplicates
- 0
- duplicate_rate
- 0
- vocab_size
- 7,124
- readability_flesch_mean
- 56.15
- emoji_rate
- 0
- url_rate
- 0
- one_word_rate
- 0.7292
- allcaps_rate
- 0
- boilerplate_rate
- 0
joshua_project
unknown other skippedThe column "joshua_project" was skipped by the profiler, so no type, cardinality, or value statistics are available beyond a row count of 7130 and a null rate of 0.0. Without unique counts or sample values it is not possible to infer whether this is an identifier, code, or descriptive field. The name suggests a reference to the Joshua Project (an ethnographic/missiological dataset), which would typically indicate a people-group code or link. Treatment: Re-profile with the skip cleared to determine type and cardinality before deciding on use.
- n
- 7,130
- nulls
- 0 (0.0%)
- unique
- —
glottolog
unknown identifier skippedThe column 'glottolog' was skipped by the profiler and carries no computed statistics beyond a row count of 7130 and a null rate of 0.0. The name suggests Glottolog language identifiers (e.g., codes like 'stan1293'), which would align with the ~7000-language scale of that catalogue, but uniqueness, type, and value distribution are all unknown here. No further signal is available to characterise it. Treatment: Re-profile with parsing enabled; if confirmed as Glottolog codes, treat as a foreign key to join against the Glottolog reference.
- n
- 7,130
- nulls
- 0 (0.0%)
- unique
- —
language_history
unknown other skippedThe column `language_history` was skipped by the profiler, which emitted no type, uniqueness, or value statistics. All 7130 rows are non-null, but with `kind` reported as unknown and `stats` empty, nothing can be inferred about the contents from this evidence alone. The name suggests a record of languages (possibly a list or sequence per row), which would explain why a scalar profiler bailed out. Treatment: Re-profile after parsing the field (e.g., explode list values) before deciding on use.
- n
- 7,130
- nulls
- 0 (0.0%)
- unique
- —
us_indigenous
unknown other skippedThe column `us_indigenous` was skipped by the profiler, so its data type and value distribution are unknown. We can only confirm it has 7130 rows with a 0.0 null rate; cardinality and any descriptive statistics are missing. Without further inspection it is impossible to tell whether this is a flag, category, or something else. Treatment: Re-profile or inspect manually to determine type before any downstream use.
- n
- 7,130
- nulls
- 0 (0.0%)
- unique
- —
speaker_count
unknown other skippedColumn `speaker_count` was skipped by the profiler, so no type, cardinality, or distribution stats are available beyond a row count of 7130 and zero nulls. The name suggests an integer count of speakers per record, but this cannot be confirmed from the evidence. Re-profile with the appropriate parser before drawing conclusions. Treatment: Re-run the profiler on this column to recover type and distribution before use.
- n
- 7,130
- nulls
- 0 (0.0%)
- unique
- —
data_sources
unknown other skippedThe column 'data_sources' was skipped by saturn's profiler (alerts: 'skipped') and reports kind 'unknown' with no unique count or stats. Only the row count (7130) and a null_rate of 0.0 are available, so the actual content and structure are unverified here. Likely a nested or non-scalar field (e.g. list/struct of source identifiers) that the profiler could not flatten. Treatment: Inspect manually and parse/explode the structure before any downstream modelling.
- n
- 7,130
- nulls
- 0 (0.0%)
- unique
- —