This is a comprehensive Collins English dictionary database with 342,813 records by 7,094 categories. Each record is comprised of word, letter & category.
In addition to this, there are 4 tables mostly related with these words, they are 519,650 contents with title, def and grammar in each; 736,182 descriptions; 137,951 sentence records and 426,958 title records with punctuation, grammar, letter, category and word in each.
There are 7 tables in the whole Collins English dictionary data set.
| Name | n3_chennan_dictionary_collinsdictionary_com |
|---|---|
| Data | 312.72M (+ 22.67M) |
| Tables | 7 (- 2) |
| Columns | 40 (- 11) |
| Table Rows | 2,170,675 (+ 544,788) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category | 7,094 | category |
100%
|
| letter |
100%
|
||
| content | 519,650 | grammar |
4.84%
|
| def |
92.23%
|
||
| def_other |
9.81%
|
||
| title_id |
100%
|
||
| description | 736,182 | description |
100%
|
| word_id |
100%
|
||
| letter | 27 | letter |
100%
|
| sentence | 137,951 | sentence |
100%
|
| word_id |
100%
|
||
| title | 426,958 | title |
100%
|
| punctuation |
41.27%
|
||
| grammar |
73.08%
|
||
| letter |
100%
|
||
| category |
100%
|
||
| word |
100%
|
||
| word_id |
100%
|
||
| word | 342,813 | word |
100%
|
| letter |
100%
|
||
| category |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
No media sets.
