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
500000	The New York Times Sunday Crossword Omnibus, Volume 2	Will Weng	0812936167	4.6	2004	12	10	Random House Puzzles & Games	5:3	4:2	3:0	2:0	1:0	total:5		nan	240
500003	Driftwood: 101 Poems & "Hanna"-A Spiritual Story about How a Broken Marriage Affects a Little Girl's Life.	Andrew D. Everstine	0595129951		2001	1	1	Writers Club Press	5:0	4:0	3:0	2:0	1:0	total:0		nan	424
500005	Once Upon a Rhyme: 101 Poems for Young Children	Sara Corrin	0571119131	5	1982	1	1	Faber & Faber	5:1	4:0	3:0	2:0	1:0	total:1		nan	157
500006	New York Times Practical Traveler Handbook:, The: An A-Z Guide for Being Well Prepared on Trips of All Kinds	Betsy Wade	0812921895	3.5	1994	26	4	Three Rivers Press	5:0	4:1	3:1	2:0	1:0	total:2		nan	286
500008	New York Times Practical Traveler	Paul Grimes	0812911520	3	1985	12	4	Three Rivers Press	5:0	4:0	3:2	2:0	1:0	total:2		nan	411
500009	The Meditations of Marcus Aurelius	Marcus Aurelius	142092611X	4.24	2005	1	1	Digireads.com	5:54568	4:32619	3:15411	2:4062	1:1821	total:108481	1	nan	104
500010	101 Great Poems of America	Contemporary Books, Inc.	0809239272	4	1992	30	6	McGraw-Hill/Contemporary	5:0	4:1	3:0	2:0	1:0	total:1		nan	142
500012	101 Patriotic Poems	Contemporary Books Inc.	0071418679	3.5	2003	21	5	McGraw-Hill	5:1	4:1	3:1	2:1	1:0	total:4		nan	144
500014	The Apology, Phaedo & Crito of Plato/Golden Sayings of Epictetus/Meditations of Marcus Aurelius 2 Harvard Classics	Charles William Eliot	1432614568	4.17	2004	11	1	Kessinger Publishing	5:92	4:86	3:38	2:7	1:1	total:224	1	nan	360
500016	Modern American Poetry (Bloom's Period Studies)	Harold Bloom	0791082377	4	2005	1	3	Chelsea House Publications	5:1	4:1	3:1	2:0	1:0	total:3		nan	509


CREATE TABLE book500k_600k (
  "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
);