Goodreads' Best Books Ever 📚

Data on the best books ever, scraped from Goodreads

@kaggle.arnabchaki_goodreads_best_books_ever

Table List

1 table(37.26 MB)

Books 1 Best Books Ever

@kaggle.arnabchaki_goodreads_best_books_ever.books_1_best_books_ever

37.26 MB
52478 rows
23 columns

title Title	series Series	author Author	rating Rating	description Description	language Language	isbn Isbn	genres Genres	characters Characters	bookformat BookFormat	edition Edition	pages Pages	publisher Publisher	publishdate PublishDate	firstpublishdate FirstPublishDate	awards Awards	numratings NumRatings	ratingsbystars RatingsByStars	likedpercent LikedPercent	setting Setting	bbescore BbeScore	bbevotes BbeVotes	price Price
The Hunger Games	The Hunger Games #1	Suzanne Collins	4.33	WINNING MEANS FAME AND FORTUNE.LOSING MEANS CERTAIN DEATH.THE HUNGER GAMES HAVE BEGUN. . . .In the ruins of a place once known as North America lies the nation of Panem, a shining Capitol surrounded by twelve outlying districts. The Capitol is harsh and cruel and keeps the districts in line by forci…	English	9.78044E+12	['Young Adult', 'Fiction', 'Dystopia', 'Fantasy', 'Science Fiction', 'Romance', 'Adventure', 'Teen', 'Post Apocalyptic', 'Action']	['Katniss Everdeen', 'Peeta Mellark', 'Cato (Hunger Games)', 'Primrose Everdeen', 'Gale Hawthorne', 'Effie Trinket', 'Haymitch Abernathy', 'Cinna', 'President Coriolanus Snow', 'Rue', 'Flavius', 'Lavinia (Hunger Games)', 'Marvel', 'Glimmer', 'Clove', 'Foxface', 'Thresh', 'Greasy Sae', 'Madge Underse…	Hardcover	First Edition	374	Scholastic Press	09/14/08	nan	['Locus Award Nominee for Best Young Adult Book (2009)', 'Georgia Peach Book Award (2009)', 'Buxtehuder Bulle (2009)', 'Golden Duck Award for Young Adult (Hal Clement Award) (2009)', "Grand Prix de l'Imaginaire Nominee for Roman jeunesse étranger (2010)", 'Books I Loved Best Yearly (BILBY) Awards fo…	6376780	['3444695', '1921313', '745221', '171994', '93557']	96	['District 12, Panem', 'Capitol, Panem', 'Panem (United States)']	2993816	30516	5.09
Harry Potter and the Order of the Phoenix	Harry Potter #5	J.K. Rowling, Mary GrandPré (Illustrator)	4.5	There is a door at the end of a silent corridor. And it’s haunting Harry Pottter’s dreams. Why else would he be waking in the middle of the night, screaming in terror?Harry has a lot on his mind for this, his fifth year at Hogwarts: a Defense Against the Dark Arts teacher with a personality like poi…	English	9.78044E+12	['Fantasy', 'Young Adult', 'Fiction', 'Magic', 'Childrens', 'Adventure', 'Audiobook', 'Middle Grade', 'Classics', 'Science Fiction Fantasy']	['Sirius Black', 'Draco Malfoy', 'Ron Weasley', 'Petunia Dursley', 'Vernon Dursley', 'Dudley Dursley', 'Severus Snape', 'Rubeus Hagrid', 'Lord Voldemort', 'Minerva McGonagall', 'Neville Longbottom', 'Fred Weasley', 'George Weasley', 'Percy Weasley', 'Ginny Weasley', 'Colin Creevey', 'Filius Flitwick…	Paperback	US Edition	870	Scholastic Inc.	09/28/04	06/21/03	['Bram Stoker Award for Works for Young Readers (2003)', 'Anthony Award for Young Adult (2004)', "Mythopoeic Fantasy Award for Children's Literature (2008)", 'Audie Award for Audiobook of the Year (2004)', 'Books I Loved Best Yearly (BILBY) Awards for Older Readers (2004)', 'Colorado Blue Spruce You…	2507623	['1593642', '637516', '222366', '39573', '14526']	98	['Hogwarts School of Witchcraft and Wizardry (United Kingdom)', 'London, England']	2632233	26923	7.38
To Kill a Mockingbird	To Kill a Mockingbird	Harper Lee	4.28	The unforgettable novel of a childhood in a sleepy Southern town and the crisis of conscience that rocked it, To Kill A Mockingbird became both an instant bestseller and a critical success when it was first published in 1960. It went on to win the Pulitzer Prize in 1961 and was later made into an Ac…	English	1E+13	['Classics', 'Fiction', 'Historical Fiction', 'School', 'Literature', 'Young Adult', 'Historical', 'Novels', 'Read For School', 'High School']	['Scout Finch', 'Atticus Finch', 'Jem Finch', 'Arthur Radley', 'Mayella Ewell', 'Aunt Alexandra', 'Bob Ewell', 'Calpurnia (housekeeper)', 'Tom Robinson', 'Miss Maudie Atkinson', 'Judge John Taylor', 'Dill Harris', 'Heck Tate', 'Stephanie Crawford']	Paperback	nan	324	Harper Perennial Modern Classics	05/23/06	07-11-1960	['Pulitzer Prize for Fiction (1961)', 'Audie Award for Classic (2007)', 'National Book Award Finalist for Fiction (1961)', 'Alabama Author Award for Fiction (1961)']	4501075	['2363896', '1333153', '573280', '149952', '80794']	95	['Maycomb, Alabama (United States)']	2269402	23328	nan
Pride and Prejudice	nan	Jane Austen, Anna Quindlen (Introduction)	4.26	Alternate cover edition of ISBN 9780679783268Since its immediate success in 1813, Pride and Prejudice has remained one of the most popular novels in the English language. Jane Austen called this brilliant work "her own darling child" and its vivacious heroine, Elizabeth Bennet, "as delightful a crea…	English	1E+13	['Classics', 'Fiction', 'Romance', 'Historical Fiction', 'Literature', 'Historical', 'Novels', 'Historical Romance', 'Classic Literature', 'Adult']	['Mr. Bennet', 'Mrs. Bennet', 'Jane Bennet', 'Elizabeth Bennet', 'Mary Bennet', 'Kitty Bennet', 'Lydia Bennet', 'Louisa Hurst', 'Caroline Bingley', 'Fitzwilliam Darcy', 'Georgiana Darcy', 'Lady Catherine de Bourgh', 'Anne de Bourgh', 'Colonel Fitzwilliam', 'Mr. Gardiner', 'Mrs. Gardiner', 'Sir Willi…	Paperback	Modern Library Classics, USA / CAN	279	Modern Library	10-10-2000	01/28/13	[]	2998241	['1617567', '816659', '373311', '113934', '76770']	94	['United Kingdom', 'Derbyshire, England (United Kingdom)', 'England', 'Hertfordshire, England (United Kingdom)']	1983116	20452	nan
Twilight	The Twilight Saga #1	Stephenie Meyer	3.6	About three things I was absolutely positive. First, Edward was a vampire. Second, there was a part of him—and I didn't know how dominant that part might be—that thirsted for my blood. And third, I was unconditionally and irrevocably in love with him. Deeply seductive and extraordinarily suspens…	English	9.78032E+12	['Young Adult', 'Fantasy', 'Romance', 'Vampires', 'Fiction', 'Paranormal', 'Paranormal Romance', 'Supernatural', 'Teen', 'Urban Fantasy']	['Edward Cullen', 'Jacob Black', 'Laurent', 'Renee', 'Bella Swan', 'Billy Black', 'Esme Cullen', 'Alice Cullen', 'Jasper Hale', 'Carlisle Cullen', 'Emmett Cullen', 'Rosalie Hale', 'Charlie Swan', 'Mike Newton', 'Jessica Stanley', 'Angela Weber', 'Tyler Crowley']	Paperback	nan	501	Little, Brown and Company	09-06-2006	10-05-2005	['Georgia Peach Book Award (2007)', 'Buxtehuder Bulle (2006)', 'Kentucky Bluegrass Award for 9-12 (2007)', 'Prijs van de Kinder- en Jeugdjury Vlaanderen (2008)', 'Books I Loved Best Yearly (BILBY) Awards for Older Readers (2009)', "West Australian Young Readers' Book Award (WAYRBA) for Older Readers…	4964519	['1751460', '1113682', '1008686', '542017', '548674']	78	['Forks, Washington (United States)', 'Phoenix, Arizona (United States)', 'Washington (state) (United States)']	1459448	14874	2.1
The Book Thief	nan	Markus Zusak (Goodreads Author)	4.37	Librarian's note: An alternate cover edition can be found hereIt is 1939. Nazi Germany. The country is holding its breath. Death has never been busier, and will be busier still.By her brother's graveside, Liesel's life is changed when she picks up a single object, partially hidden in the snow. It is…	English	9.78038E+12	['Historical Fiction', 'Fiction', 'Young Adult', 'Historical', 'Classics', 'War', 'Holocaust', 'World War II', 'Books About Books', 'Audiobook']	['Liesel Meminger', 'Hans Hubermann', 'Rudy Steiner', 'Rosa Hubermann', 'Max Vandenburg', 'Tommy Müller', 'Ilsa Hermann', 'Frau Holtzapfel']	Hardcover	First American Edition	552	Alfred A. Knopf	03/14/06	09-01-2005	['National Jewish Book Award for Children’s and Young Adult Literature (2006)', "Book Sense Book of the Year Award for Children's Literature (2007)", 'Buxtehuder Bulle (2008)', 'Sydney Taylor Book Award for Teen Readers (2007)', 'Prijs van de Kinder- en Jeugdjury Vlaanderen (2009)', 'Michael L. Prin…	1834276	['1048230', '524674', '186297', '48864', '26211']	96	['Molching (Germany)', 'Germany']	1372809	14168	3.8
Animal Farm	nan	George Orwell, Russell Baker (Preface), C.M. Woodhouse (Introduction)	3.95	Librarian's note: There is an Alternate Cover Edition for this edition of this book here.A farm is taken over by its overworked, mistreated animals. With flaming idealism and stirring slogans, they set out to create a paradise of progress, justice, and equality. Thus the stage is set for one of the …	English	9.78045E+12	['Classics', 'Fiction', 'Dystopia', 'Fantasy', 'Literature', 'Politics', 'School', 'Science Fiction', 'Novels', 'Read For School']	['Snowball', 'Napoleon', 'Clover', 'Boxer', 'Old Major', 'Muriel', 'Jones', 'Squealer', 'Moses the Raven', 'Benjamin']	Mass Market Paperback	nan	141	Signet Classics	04/28/96	08/17/45	['Prometheus Hall of Fame Award (2011)', 'Retro Hugo Award for Best Novella (1996)']	2740713	['986764', '958699', '545475', '165093', '84682']	91	['England', 'United Kingdom']	1276599	13264	4.42
The Chronicles of Narnia	The Chronicles of Narnia (Publication Order) #1–7	C.S. Lewis, Pauline Baynes (Illustrator)	4.26	Journeys to the end of the world, fantastic creatures, and epic battles between good and evil—what more could any reader ask for in one book? The book that has it all is The Lion, the Witch and the Wardrobe, written in 1949 by Clive Staples Lewis. But Lewis did not stop there. Six more books followe…	English	1E+13	['Fantasy', 'Classics', 'Fiction', 'Young Adult', 'Childrens', 'Christian', 'Adventure', 'Science Fiction Fantasy', 'Middle Grade', 'Christian Fiction']	['Polly', 'Aslan', 'Lucy Pevensie', 'Edmund Pevensie', 'Eustace Scrubb', 'Prince Caspian', 'Jill Pole', 'Prince Rilian', 'Puddleglum', 'Trumpkin', 'Jewel', 'Aravis', 'Mr. Tumnus', 'Puzzle', 'King Tirian', 'Digory Kirke', 'Peter Pevensie', 'Susan Pevensie', 'Reepicheep', 'Jadis', 'Bacchus (god)', 'Mr…	Paperback	Reissue Edition	767	HarperCollins	09/16/02	10/28/56	[]	517740	['254964', '167572', '74362', '15423', '5419']	96	['London, England']	1238556	12949	nan
J.R.R. Tolkien 4-Book Boxed Set: The Hobbit and The Lord of the Rings	The Lord of the Rings #0-3	J.R.R. Tolkien	4.6	This four-volume, boxed set contains J.R.R. Tolkien's epic masterworks The Hobbit and the three volumes of The Lord of the Rings (The Fellowship of the Ring, The Two Towers, and The Return of the King).In The Hobbit, Bilbo Baggins is whisked away from his comfortable, unambitious life in Hobbiton by…	English	9.78035E+12	['Fantasy', 'Fiction', 'Classics', 'Adventure', 'Science Fiction Fantasy', 'Epic Fantasy', 'High Fantasy', 'Young Adult', 'Literature', 'Magic']	['Frodo Baggins', 'Gandalf', 'Bilbo Baggins', 'Gollum']	Mass Market Paperback	Hobbit Movie Tie-in Boxed set	1728	Ballantine Books	09/25/12	10/20/55	[]	110146	['78217', '22857', '6628', '1477', '967']	98	['Middle-earth']	1159802	12111	21.15
Gone with the Wind	nan	Margaret Mitchell	4.3	Scarlett O'Hara, the beautiful, spoiled daughter of a well-to-do Georgia plantation owner, must use every means at her disposal to claw her way out of the poverty she finds herself in after Sherman's March to the Sea.	English	9.78045E+12	['Classics', 'Historical Fiction', 'Fiction', 'Romance', 'Historical', 'War', 'Literature', 'Civil War', 'Historical Romance', 'Novels']	["Scarlett O'Hara", 'Rhett Butler', 'Ashley Wilkes', 'Melanie Hamilton Wilkes', 'Wade Hampton Hamilton', 'Ella Lorena Kennedy', 'Eugenie Victoria "Bonnie Blue" Butler', 'Beau Wilkes', 'India Wilkes', 'Honey Wilkes', 'John Wilkes', "Gerald O'Hara", "Ellen O'Hara", "Suellen O'Hara", "Carreen O'Hara",…	Mass Market Paperback	nan	1037	Warner Books	04-01-1999	06/30/36	['Pulitzer Prize for Novel (1937)', 'National Book Award for Novel (1936)']	1074620	['602138', '275517', '133535', '39008', '24422']	94	['Atlanta, Georgia (United States)']	1087732	11211	5.58


CREATE TABLE books_1_best_books_ever (
  "title" VARCHAR,
  "series" VARCHAR,
  "author" VARCHAR,
  "rating" DOUBLE,
  "description" VARCHAR,
  "language" VARCHAR,
  "isbn" VARCHAR,
  "genres" VARCHAR,
  "characters" VARCHAR,
  "bookformat" VARCHAR,
  "edition" VARCHAR,
  "pages" VARCHAR,
  "publisher" VARCHAR,
  "publishdate" VARCHAR,
  "firstpublishdate" VARCHAR,
  "awards" VARCHAR,
  "numratings" BIGINT,
  "ratingsbystars" VARCHAR,
  "likedpercent" DOUBLE,
  "setting" VARCHAR,
  "bbescore" BIGINT,
  "bbevotes" BIGINT,
  "price" VARCHAR
);