Home Data Language & Reference Quotes

849,728 Quotes Data: 14,898 Topics by 29,528 Authors

Name	n3_lyz_brainyquote.com
Data	639.03M (+ 0B)
Tables	4 (+ 0)
Columns	22 (+ 0)
Table Rows	3,431,671 (+ 0)
Media	0B (+ 0B)
Files	0 (+ 0)
Last Commit	2023-06-19 18:12:05 (+ 169 d)

This quotes database has 849,728 famous quotes records of 14,898 topics by 29,528 authors. Each record consists of the quote and the author. In table author, there are profession, nationality, born and die fields in each.

The whole quotes data set consists of 4 tables.

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_lyz/inspirational_and_famous_quote_1/ (By Table)

Tables + Columns
Media Files
Updates
Download

Tables & Columns

Tables	Rows	Columns	Non-empty
author	29,528	author	100%
		profession	99.18%
		nationality	96.58%
		born	85.74%
		die	23.83%
quote	849,728	quote	100%
quote	849,728	author_id	100%
topic	14,898	topic	100%
topic_x_quote	2,537,517	topic_id	100%
topic_x_quote	2,537,517	quote_id	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)	639.03M (+ 0B)	4 (+ 0)	22 (+ 0)	3,431,671 (+ 0)	0B (+ 0B)	0 (+ 0)
2023-01-01 (+ 95 d)	639.03M (+ 0B)	4 (+ 0)	22 (+ 0)	3,431,671 (+ 0)	0B (+ 0B)	0 (+ 0)
2022-09-27 (+ 271 d)	639.03M (+ 0B)	4 (+ 0)	22 (+ 0)	3,431,671 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-12-30 (+ 115 d)	639.03M (+ 0B)	4 (+ 0)	22 (+ 0)	3,431,671 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-09-05 (+ 150 d)	639.03M (+ 170.84M)	4 (+ 0)	22 (+ 0)	3,431,671 (+ 0)	0B (+ 0B)	0 (+ 0)
2021-04-08 (+ 68 d)	468.19M (- 0.22G)	4 (- 2)	22 (- 8)	3,431,671 (- 1,811,028)	0B (+ 0B)	0 (+ 0)
2021-01-29 (+ 120 d)	692.59M (+ 0B)	6 (+ 0)	30 (+ 0)	5,242,699 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-10-01 (+ 38 d)	692.59M (+ 0B)	6 (+ 0)	30 (+ 0)	5,242,699 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-08-23 (+ 141 d)	692.59M (+ 0B)	6 (+ 0)	30 (+ 0)	5,242,699 (+ 0)	0B (+ 0B)	0 (+ 0)
2020-04-04 (+ 196 d)	692.59M (+ 0B)	6 (+ 0)	30 (+ 0)	5,242,699 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-09-21 (+ 197 d)	692.59M (+ 0B)	6 (+ 0)	30 (+ 0)	5,242,699 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-03-07 (+ 43 d)	692.59M (+ 0B)	6 (+ 0)	30 (+ 0)	5,242,699 (+ 0)	0B (+ 0B)	0 (+ 0)
2019-01-23 (+ 44 d)	692.59M (+ 0B)	6 (+ 0)	30 (+ 0)	5,242,699 (+ 0)	0B (+ 0B)	0 (+ 0)
2018-12-09 (+ 29 d)	692.59M (+ 21.73M)	6 (- 4)	30 (- 16)	5,242,699 (- 58,757)	0B (- 8.38M)	0 (- 1,000)
2018-11-09 (+ 27 d)	670.86M (+ 186.70M)	10 (+ 0)	46 (+ 0)	5,301,456 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2018-10-13 (+ 29 d)	484.16M (+ 0B)	10 (+ 0)	46 (+ 0)	5,301,456 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2018-09-13 (+ 34 d)	484.16M (+ 6.91M)	10 (+ 1)	46 (+ 9)	5,301,456 (+ 23,987)	8.38M (+ 0B)	1,000 (+ 0)
2018-08-09 (+ 27 d)	477.25M (+ 0B)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2018-07-12 (+ 31 d)	477.25M (+ 0B)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2018-06-10 (+ 31 d)	477.25M (+ 0B)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2018-05-10 (+ 28 d)	477.25M (+ 0B)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2018-04-11 (+ 38 d)	477.25M (+ 0B)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2018-03-03 (+ 35 d)	477.25M (+ 0B)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2018-01-27 (+ 29 d)	477.25M (+ 0B)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2017-12-29 (+ 20 d)	477.25M (+ 0B)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2017-12-08 (+ 9 d)	477.25M (+ 0B)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2017-11-28 (+ 19 d)	477.25M (+ 401.05M)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 0)	8.38M (+ 0B)	1,000 (+ 0)
2017-11-09 (+ 10 d)	76.20M (+ 464K)	9 (+ 0)	37 (+ 0)	5,277,469 (+ 385,795)	8.38M (+ 8.38M)	1,000 (+ 999)
2017-10-29 (+ 19 d)	75.75M (+ 0B)	9 (+ 0)	37 (+ 0)	4,891,674 (+ 3,694,448)	6.44K (+ 0B)	1 (+ 0)
2017-10-10	75.75M	9	37	1,197,226	6.44K	1

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.