Home Data Language & Reference Dictionary

Collins English Dictionary Data: 342,813 Words by 7,094 Categories

Name	n3_chennan_dictionary_collinsdictionary_com
Data	701.72M (+ 389M)
Tables	7 (+ 0)
Columns	40 (+ 0)
Table Rows	2,170,675 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2023-06-19 18:36:38 (+ 169 d)

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.

Data Samples

Main List (for Desktop / for Mobile) / JSON / XML / Excel / CSV (Download CSV) / View by Table

Data APIs

http://n3.datasn.io/data/api/v1/n3_chennan/collins_english_dictionary/ (By Table)

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
category	7,094	category	100%
category	7,094	letter	100%
content	519,650	grammar	4.84%
		def	92.23%
		def_other	9.81%
		title_id	100%
description	736,182	description	100%
description	736,182	word_id	100%
letter	27	letter	100%
sentence	137,951	sentence	100%
sentence	137,951	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.

Commits / Updates

Time	Data	Tables	Columns	Rows	Media	Files
2023-06-19 (+ 169 d)	701.72M (+ 389M)	7 (+ 0)	40 (+ 0)	2,170,675 (+ 0)	0B (+ 0B)	0 (+ 0)
2023-01-01 (+ 95 d)	312.72M (+ 22.67M)	7 (- 2)	40 (- 11)	2,170,675 (+ 544,788)	0B (+ 0B)	0 (+ 0)
2022-09-27 (+ 271 d)	290.05M (- 0.68G)	9 (+ 1)	51 (+ 10)	1,625,887 (- 5,544,008)	0B (+ 0B)	0 (+ 0)
2021-12-30 (+ 115 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-09-05 (+ 150 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-04-08 (+ 68 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-01-29 (+ 120 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-10-01 (+ 38 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-08-23 (+ 141 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-04-04 (+ 196 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-09-21 (+ 197 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	0.97G (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-11-09 (+ 27 d)	0.97G (+ 726.81M)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-10-13 (+ 29 d)	264.33M (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-09-13 (+ 34 d)	264.33M (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-08-09 (+ 27 d)	264.33M (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-07-12 (+ 31 d)	264.33M (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-06-10 (+ 31 d)	264.33M (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-05-10 (+ 28 d)	264.33M (+ 0B)	8 (+ 0)	41 (+ 0)	7,169,895 (+ 2,751,482)	0B (+ 0B)	0 (+ 0)
2018-04-11	264.33M	8	41	4,418,413	0B	0

Download Latest Commit

In the same time, you can also access this data set via API.

Access Now!

How to use

View the page for data details.
Sign up for an account and log in.
Open Online Query to build API addresses / calls.
Open the API address / call to access the data.

FAQ

How to access the data?

Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
Why are data size increments not in line with those of number of rows?

The scanning and profiling of data size increments are done separately from those of the number of rows.