Goodreads Book Datasets With User Rating 2M

publishyear PublishYear	rating Rating	ratingdisttotal RatingDistTotal	isbn ISBN	ratingdist1 RatingDist1	publisher Publisher	publishmonth PublishMonth	id Id	name Name	authors Authors	ratingdist5 RatingDist5	ratingdist4 RatingDist4	publishday PublishDay	ratingdist2 RatingDist2	pagesnumber PagesNumber	ratingdist3 RatingDist3	countsofreview CountsOfReview	language Language
1991	3.3	total:27	0413659305	1:2	Bloomsbury Methuen Drama	16	400000	The Gigli Concert	Tom Murphy	5:3	4:10	9	2:4	96	3:8	2	nan
2006	3.76	total:76	041534302X	1:1	Routledge	30	400003	The Oral History Reader	Robert Perks	5:20	4:28	5	2:8	578	3:19		nan
2005	4.5	total:2	1582074283	1:0	Wetfeet	1	400004	Negotiating Your Salary & Perks: Wetfeet Insider Guide	Duncan Haberly	5:1	4:1	2	2:0	160	3:0	1	nan
1998	3.22	total:18	0811728536	1:2	National Book Network	1	400006	John Gill: Master of Rock PB	Pat Ament	5:1	4:8	6	2:2	2	3:5		nan
2003	4.1	total:30	0321130103	1:1	Adobe Press	14	400007	Adobe Photoshop Master Class: John Paul Caponigro	John Paul Caponigro	5:14	4:7	2	2:0	504	3:8		nan
2002	4.05	total:21	1570754152	1:0	Orbis Books	23	400009	John Main: Essential Writings	John Main	5:7	4:9	4	2:1	188	3:4	1	eng
1988	3.99	total:236	0747403473	1:3	Sphere Books	15	400011	The Deceivers	John Masters	5:74	4:102	9	2:11	320	3:46	12	eng
2007	4.12	total:8	1574412264	1:0	University of North Texas Press	19	400012	Inside John Haynie’s Studio: A Master Teacher’s Lessons on Trumpet and Life	John Haynie	5:3	4:3	1	2:0	304	3:2	2	nan
1998	3.6	total:5	0874136423	1:0	University of Delaware Press	1	400013	Into the Tunnel	Irving Malin	5:0	4:3	1	2:0	172	3:2	3	nan
2002	3.67	total:27	0465085768	1:2	Basic Books	18	400015	Empires On The Pacific	Robert Smith Thompson	5:7	4:9	12	2:1	472	3:8	4	nan


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