Goodreads Book Datasets With User Rating 2M

id Id	name Name	ratingdist1 RatingDist1	pagesnumber PagesNumber	ratingdist4 RatingDist4	ratingdisttotal RatingDistTotal	publishmonth PublishMonth	publishday PublishDay	publisher Publisher	countsofreview CountsOfReview	publishyear PublishYear	language Language	authors Authors	rating Rating	ratingdist2 RatingDist2	ratingdist5 RatingDist5	isbn ISBN	ratingdist3 RatingDist3
1	Harry Potter and the Half-Blood Prince (Harry Potter, #6)	1:9896	652	4:556485	total:2298124	16	9	Scholastic Inc.	28062	2006	eng	J.K. Rowling	4.57	2:25317	5:1546466	nan	3:159960
2	Harry Potter and the Order of the Phoenix (Harry Potter, #5)	1:12455	870	4:604283	total:2358637	1	9	Scholastic Inc.	29770	2004	eng	J.K. Rowling	4.5	2:37005	5:1493113	0439358078	3:211781
3	Harry Potter and the Sorcerer's Stone (Harry Potter, #1)	1:108202	309	4:1513191	total:6587388	1	11	Scholastic Inc	75911	2003	eng	J.K. Rowling	4.47	2:130310	5:4268227	nan	3:567458
4	Harry Potter and the Chamber of Secrets (Harry Potter, #2)	1:11896	352	4:706082	total:2560657	1	11	Scholastic	244	2003	eng	J.K. Rowling	4.42	2:49353	5:1504505	0439554896	3:288821
5	Harry Potter and the Prisoner of Azkaban (Harry Potter, #3)	1:10128	435	4:630534	total:2610317	1	5	Scholastic Inc.	37093	2004	eng	J.K. Rowling	4.57	2:24849	5:1749958	043965548X	3:194848
6	Harry Potter and the Goblet of Fire (Harry Potter, #4)	1:9419	734	4:606800	total:2431085	28	9	Scholastic	31978	2002	eng	J.K. Rowling	4.5600000000000005	2:24282	5:1612165	nan	3:178419
8	Harry Potter Boxed Set, Books 1-5 (Harry Potter, #1-5)	1:402	2690	4:4650	total:43968	13	9	Scholastic	166	2004	eng	J.K. Rowling	4.78	2:283	5:37432	0439682584	3:1201
9	Unauthorized Harry Potter Book Seven News: "Half-Blood Prince" Analysis and Speculation	1:0	152	4:7	total:28	26	4	Nimble Books	1	2005	en-US	W. Frederick Zimmerman	3.79	2:5	5:10	0976540606	3:6
10	Harry Potter Collection (Harry Potter, #1-6)	1:257	3342	4:4358	total:30313	12	9	Scholastic	809	2005	eng	J.K. Rowling	4.73	2:218	5:24406	0439827604	3:1074
12	The Ultimate Hitchhiker's Guide: Five Complete Novels and One Story (Hitchhiker's Guide to the Galaxy, #1-5)	1:3443	815	4:75683	total:274268	1	11	Gramercy Books	255	2005	eng	Douglas Adams	4.37	2:7613	5:157499	0517226952	3:30030


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