Goodbooks-10k

Ten thousand books, one million ratings. Also books marked to read, and tags.

@kaggle.zygmunt_goodbooks_10k

Table List

5 tables(9.65 MB)

Books

Book Tags

Ratings

Books

@kaggle.zygmunt_goodbooks_10k.books

1.61 MB
10000 rows
23 columns

id Id	book_id Book Id	best_book_id Best Book Id	work_id Work Id	books_count Books Count	isbn Isbn	isbn13 Isbn13	authors Authors	original_publication_year Original Publication Year	original_title Original Title	title Title	language_code Language Code	average_rating Average Rating	ratings_count Ratings Count	work_ratings_count Work Ratings Count	work_text_reviews_count Work Text Reviews Count	ratings_1 Ratings 1	ratings_2 Ratings 2	ratings_3 Ratings 3	ratings_4 Ratings 4	ratings_5 Ratings 5	image_url Image Url	small_image_url Small Image Url
1	2767052	2767052	2792775	272	439023483	9780439023480	Suzanne Collins	2008	The Hunger Games	The Hunger Games (The Hunger Games, #1)	eng	4.34	4780653	4942365	155254	66715	127936	560092	1481305	2706317	https://images.gr-assets.com/books/1447303603m/2767052.jpg	https://images.gr-assets.com/books/1447303603s/2767052.jpg
2	3	3	4640799	491	439554934	9780439554930	J.K. Rowling, Mary GrandPré	1997	Harry Potter and the Philosopher's Stone	Harry Potter and the Sorcerer's Stone (Harry Potter, #1)	eng	4.44	4602479	4800065	75867	75504	101676	455024	1156318	3011543	https://images.gr-assets.com/books/1474154022m/3.jpg	https://images.gr-assets.com/books/1474154022s/3.jpg
3	41865	41865	3212258	226	316015849	9780316015840	Stephenie Meyer	2005	Twilight	Twilight (Twilight, #1)	en-US	3.57	3866839	3916824	95009	456191	436802	793319	875073	1355439	https://images.gr-assets.com/books/1361039443m/41865.jpg	https://images.gr-assets.com/books/1361039443s/41865.jpg
4	2657	2657	3275794	487	61120081	9780061120080	Harper Lee	1960	To Kill a Mockingbird	To Kill a Mockingbird	eng	4.25	3198671	3340896	72586	60427	117415	446835	1001952	1714267	https://images.gr-assets.com/books/1361975680m/2657.jpg	https://images.gr-assets.com/books/1361975680s/2657.jpg
5	4671	4671	245494	1356	743273567	9780743273560	F. Scott Fitzgerald	1925	The Great Gatsby	The Great Gatsby	eng	3.89	2683664	2773745	51992	86236	197621	606158	936012	947718	https://images.gr-assets.com/books/1490528560m/4671.jpg	https://images.gr-assets.com/books/1490528560s/4671.jpg
6	11870085	11870085	16827462	226	525478817	9780525478810	John Green	2012	The Fault in Our Stars	The Fault in Our Stars	eng	4.26	2346404	2478609	140739	47994	92723	327550	698471	1311871	https://images.gr-assets.com/books/1360206420m/11870085.jpg	https://images.gr-assets.com/books/1360206420s/11870085.jpg
7	5907	5907	1540236	969	618260307	9780618260300	J.R.R. Tolkien	1937	The Hobbit or There and Back Again	The Hobbit	en-US	4.25	2071616	2196809	37653	46023	76784	288649	665635	1119718	https://images.gr-assets.com/books/1372847500m/5907.jpg	https://images.gr-assets.com/books/1372847500s/5907.jpg
8	5107	5107	3036731	360	316769177	9780316769170	J.D. Salinger	1951	The Catcher in the Rye	The Catcher in the Rye	eng	3.79	2044241	2120637	44920	109383	185520	455042	661516	709176	https://images.gr-assets.com/books/1398034300m/5107.jpg	https://images.gr-assets.com/books/1398034300s/5107.jpg
9	960	960	3338963	311	1416524797	9781416524790	Dan Brown	2000	Angels & Demons	Angels & Demons (Robert Langdon, #1)	en-CA	3.85	2001311	2078754	25112	77841	145740	458429	716569	680175	https://images.gr-assets.com/books/1303390735m/960.jpg	https://images.gr-assets.com/books/1303390735s/960.jpg
10	1885	1885	3060926	3455	679783261	9780679783270	Jane Austen	1813	Pride and Prejudice	Pride and Prejudice	eng	4.24	2035490	2191465	49152	54700	86485	284852	609755	1155673	https://images.gr-assets.com/books/1320399351m/1885.jpg	https://images.gr-assets.com/books/1320399351s/1885.jpg


CREATE TABLE books (
  "id" BIGINT,
  "book_id" BIGINT,
  "best_book_id" BIGINT,
  "work_id" BIGINT,
  "books_count" BIGINT,
  "isbn" VARCHAR,
  "isbn13" DOUBLE,
  "authors" VARCHAR,
  "original_publication_year" DOUBLE,
  "original_title" VARCHAR,
  "title" VARCHAR,
  "language_code" VARCHAR,
  "average_rating" DOUBLE,
  "ratings_count" BIGINT,
  "work_ratings_count" BIGINT,
  "work_text_reviews_count" BIGINT,
  "ratings_1" BIGINT,
  "ratings_2" BIGINT,
  "ratings_3" BIGINT,
  "ratings_4" BIGINT,
  "ratings_5" BIGINT,
  "image_url" VARCHAR,
  "small_image_url" VARCHAR
);