Goodreads Book Datasets With User Rating 2M

id Id	name Name	authors Authors	isbn ISBN	rating Rating	publishyear PublishYear	publishmonth PublishMonth	publishday PublishDay	publisher Publisher	ratingdist5 RatingDist5	ratingdist4 RatingDist4	ratingdist3 RatingDist3	ratingdist2 RatingDist2	ratingdist1 RatingDist1	ratingdisttotal RatingDistTotal	countsofreview CountsOfReview	language Language	pagesnumber PagesNumber	description Description	count_of_text_reviews Count Of Text Reviews
900000	Cabinet 03: Weather	Jeffrey Kastner	1932698019	4	2004	2	1	Cabinet	5:0	4:2	3:0	2:0	1:0	total:2		nan	112	Artwork by Joe Amrhein, Maria Blondeel, Spencer Finch, Allan Lamb, Gordon Monahan, Jenny Perlin, Chris Watson, Olafur Eliasson, Douglas Gordon, Vik Muniz, Matthew Ritchie. Photographs by Joel Sternfeld. Edited by Jeffrey Kastner.
900001	Workouts in a Binder for Swimmers, Triathletes, and Coaches	Nick Hansen	1931382743	4.48	2005	18	11	Velo Press	5:24	4:17	3:3	2:0	1:0	total:44	2	nan	101	This waterproof book of 100 swimming workouts offers swimmers and triathletes a wide variety of structured workouts to improve swimming fitness, technique, and speed. Using all four competitive swim strokes (freestyle, breaststroke, backstroke, and butterfly), swimmers and triathletes will strengthe…	2
900002	Las 120 jornadas de Sodoma	Marquis de Sade	8472233847	3.12	1992	1	3	TusQuets	5:1745	4:2246	3:2935	2:1753	1:1408	total:10087	9	nan	424	The 120 Days of Sodom by Marquis de Sade relates the story of four wealthy men who enslave 24 mostly teenaged victims and sexually torture them while listening to stories told by old prostitutes. The book was written while Sade was imprisoned in the Bastille and the manuscript was lost during the st…	9
900004	The Traveler: An American Odyssey in the Himalayas	Eric Hansen	0871563509	4.18	1995	6	6	Random House, Inc.	5:6	4:8	3:3	2:0	1:0	total:17	1	nan	102	This loving memorial to Swift is a moving photographic portrait of Himalayan life, a testimonial to a generation of trekkers and the questing spirit that motivated them. Hansen offers a sage perspective on Swift's adventuring career, placing it in the globe-shrinking change of the last 20 years. 56 …	1
900006	Vertical Smile	Richard Condon	0297994026	3.74	1972	20	4	Littlehampton Book Services Ltd	5:7	4:17	3:13	2:2	1:0	total:39	1	nan	334	nan	1
900009	The Best Laid Plans	Sidney Sheldon	0006510558	3.69	1998	1	5	HarperCollins Publishers	5:4797	4:7824	3:6849	2:1769	1:366	total:21605	28	eng	344	"The Best Laid Plans" tells the explosive story of the beautiful and ambitious Leslie Stewart, who learns that for some men power is the greatest aphrodisiac, and of Oliver Russell, the handsome governor of a small southern state, who finds out why hell has no fury like a woman scorned. With the une…	28
900012	Morning, Noon & Night	Sidney Sheldon	000649806X	3.66	1996	1	5	HarperCollins	5:3657	4:5491	3:5445	2:1474	1:287	total:16354	16	nan	375	Harry Stanford is one of the wealthiest men in the world, and his family one of the most respected in America. When he mysteriously drowns while cruising on his yacht, things begin to change. Is the beautiful young woman who appears at the funeral really who she claims to be, or is she an imposter?	16
900013	Sex, Botany And Empire	Patricia Fara	1840465735	3.3	2007	1	12	Icon Books	5:8	4:36	3:54	2:16	1:1	total:115	2	en-GB	168	Eighteenth century botany, starring Cook, Banks, and Linnaeus, was sexy, dangerous, and big business, and Fara reveals the existence, barely concealed under the camouflage of noble enlightenment, of the more seedy drives to conquer, subdue and deflower in the name of the British Empire.	2
900015	Memory	Patricia Fara	0521032180	2.8	2006	14	12	Cambridge University Press	5:0	4:1	3:3	2:0	1:1	total:5		nan	208	Bringing together influential writers such as A. S. Byatt with leading scientists including Steven Rose, this engaging collection of essay s explores the topic of memory in a uniquely interdisciplinary way. Generously illustrated and accessibly written for the general reader, with cutting edge insig…
900017	Pandora's Breeches: Women, Science & Power in the Enlightenment	Patricia Fara	1844130827	3.79	2004	4	3	Pimlico	5:5	4:13	3:9	2:1	1:0	total:28	5	eng	288	nan	5


CREATE TABLE book900k_1000k (
  "id" BIGINT,
  "name" VARCHAR,
  "authors" VARCHAR,
  "isbn" VARCHAR,
  "rating" DOUBLE,
  "publishyear" BIGINT,
  "publishmonth" BIGINT,
  "publishday" BIGINT,
  "publisher" VARCHAR,
  "ratingdist5" VARCHAR,
  "ratingdist4" VARCHAR,
  "ratingdist3" VARCHAR,
  "ratingdist2" VARCHAR,
  "ratingdist1" VARCHAR,
  "ratingdisttotal" VARCHAR,
  "countsofreview" BIGINT,
  "language" VARCHAR,
  "pagesnumber" BIGINT,
  "description" VARCHAR,
  "count_of_text_reviews" BIGINT
);