id | name | type | circulation_numbers | pub_date | publisher_id |
---|---|---|---|---|---|
(→ Publishers.id) | |||||
1 | The New York Times | Newspaper | 20000 | 2023-01-01 | 1 |
2 | USA Today | Newspaper | 18000 | 2023-01-02 | 1 |
3 | Time Magazine | Magazine | 20000 | 2023-01-03 | 2 |
4 | National Geographic | Magazine | 19000 | 2023-01-04 | 3 |
5 | Wired | Magazine | 17000 | 2023-01-05 | 4 |
6 | Forbes | Newspaper | 15000 | 2023-01-06 | 5 |
7 | Vanity Fair | Magazine | 16000 | 2023-01-07 | 6 |
id | name |
---|---|
1 | Jane Austen |
2 | Charles Dickens |
3 | Mark Twain |
4 | George Orwell |
5 | Fyodor Dostoevsky |
6 | Leo Tolstoy |
7 | Harper Lee |
8 | Herman Melville |
9 | Emily Bronte |
10 | William Shakespeare |
id | title | content | pub_date | periodical_id | author_id |
---|---|---|---|---|---|
(→ Periodicals.id) | (→ Authors.id) | ||||
1 | A Tale of Two Cities | This novel by Charles Dickens tells... | 2023-01-01 | 1 | 2 |
2 | Pride and Prejudice | This classic love story by Jane Austen... | 2023-01-02 | 2 | 1 |
3 | Great Expectations | Another masterpiece by Charles Dickens... | 2023-01-03 | 3 | 3 |
4 | War and Peace | Tolstoy's epic tale of love during war... | 2023-01-04 | 4 | 6 |
5 | To Kill a Mockingbird | Harper Lee's Pulitzer Prize winning book... | 2023-01-05 | 5 | 7 |
6 | Moby Dick | Classic adventure novel by Herman Melville. | 2023-01-06 | 6 | 8 |
7 | 1984 | Orwell's dystopian vision of a totalitarian society. | 2023-01-07 | 7 | 9 |
8 | Crime and Punishment | Dostoevsky's psychological thriller about guilt and redemption. | 2023-01-08 | 8 | 10 |
9 | The Great Gatsby | Scott Fitzgerald's timeless portrayal of the American Dream. | 2023-01-09 | 9 | 1 |
10 | Animal Farm | George Orwell's allegory on political corruption. | 2023-01-10 | 10 | 2 |
id | name |
---|---|
1 | McClatchy Company |
2 | Gannett Company |
3 | Meredith Corporation |
4 | Conde Nast |
5 | Hearst Communications |
6 | Rupert Murdoch's News Corporation |
7 | Time Inc. |
8 | Newsweek Media Group |
9 | The Washington Post |
10 | Dow Jones & Company |