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 the table author, there are profession, nationality, born and die fields in each.
The whole quotes data set consists of 4 tables.
| 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) |
Data Samples
Database APIs
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%
|
| author_id |
100%
|
||
| topic | 14,898 | topic |
100%
|
| topic_x_quote | 2,537,517 | topic_id |
100%
|
| 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.
