The New York Times web site provides a rich set of APIs, as described here: http://developer.nytimes.com/docs. We chose the New York Times’ Books API, constructed an interface in R to read in the JSON data, and transformed it to an R dataframe.
First, we pull in our data from the API using our API key.
library(RCurl)## Loading required package: bitopskey <- "TPSygBadMHg7XTCodHE1xq3eSbQVsgLh"
url <- "https://api.nytimes.com/svc/books/v3/lists/best-sellers/history.json"
pull <- getURL(paste0(url,'?api-key=', key))
pull## [1] "{\"status\":\"OK\",\"copyright\":\"Copyright (c) 2019 The New York Times Company. All Rights Reserved.\",\"num_results\":31955,\"results\":[{\"title\":\"\\\"I GIVE YOU MY BODY ...\\\"\",\"description\":\"The author of the Outlander novels gives tips on writing sex scenes, drawing on examples from the books.\",\"contributor\":\"by Diana Gabaldon\",\"author\":\"Diana Gabaldon\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Dell\",\"isbns\":[{\"isbn10\":\"0399178570\",\"isbn13\":\"9780399178573\"}],\"ranks_history\":[{\"primary_isbn10\":\"0399178570\",\"primary_isbn13\":\"9780399178573\",\"rank\":8,\"list_name\":\"Advice How-To and Miscellaneous\",\"display_name\":\"Advice, How-To & Miscellaneous\",\"published_date\":\"2016-09-04\",\"bestsellers_date\":\"2016-08-20\",\"weeks_on_list\":1,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0}],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"\\\"MOST BLESSED OF THE PATRIARCHS\\\"\",\"description\":\"A character study that attempts to make sense of Jefferson’s contradictions.\",\"contributor\":\"by Annette Gordon-Reed and Peter S. Onuf\",\"author\":\"Annette Gordon-Reed and Peter S Onuf\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Liveright\",\"isbns\":[{\"isbn10\":\"0871404427\",\"isbn13\":\"9780871404428\"}],\"ranks_history\":[{\"primary_isbn10\":\"0871404427\",\"primary_isbn13\":\"9780871404428\",\"rank\":16,\"list_name\":\"Hardcover Nonfiction\",\"display_name\":\"Hardcover Nonfiction\",\"published_date\":\"2016-05-01\",\"bestsellers_date\":\"2016-04-16\",\"weeks_on_list\":1,\"ranks_last_week\":null,\"asterisk\":1,\"dagger\":0}],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"#ASKGARYVEE\",\"description\":\"The entrepreneur expands on subjects addressed on his Internet show, like marketing, management and social media.\",\"contributor\":\"by Gary Vaynerchuk\",\"author\":\"Gary Vaynerchuk\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"HarperCollins\",\"isbns\":[{\"isbn10\":\"0062273124\",\"isbn13\":\"9780062273123\"},{\"isbn10\":\"0062273132\",\"isbn13\":\"9780062273130\"}],\"ranks_history\":[{\"primary_isbn10\":\"0062273124\",\"primary_isbn13\":\"9780062273123\",\"rank\":5,\"list_name\":\"Business Books\",\"display_name\":\"Business\",\"published_date\":\"2016-04-10\",\"bestsellers_date\":\"2016-03-26\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":1},{\"primary_isbn10\":\"0062273124\",\"primary_isbn13\":\"9780062273123\",\"rank\":6,\"list_name\":\"Advice How-To and Miscellaneous\",\"display_name\":\"Advice, How-To & Miscellaneous\",\"published_date\":\"2016-03-27\",\"bestsellers_date\":\"2016-03-12\",\"weeks_on_list\":1,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":1}],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"#GIRLBOSS\",\"description\":\"An online fashion retailer traces her path to success.\",\"contributor\":\"by Sophia Amoruso\",\"author\":\"Sophia Amoruso\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Portfolio/Penguin/Putnam\",\"isbns\":[{\"isbn10\":\"039916927X\",\"isbn13\":\"9780399169274\"},{\"isbn10\":\"1591847931\",\"isbn13\":\"9781591847939\"}],\"ranks_history\":[{\"primary_isbn10\":\"1591847931\",\"primary_isbn13\":\"9781591847939\",\"rank\":8,\"list_name\":\"Business Books\",\"display_name\":\"Business\",\"published_date\":\"2016-03-13\",\"bestsellers_date\":\"2016-02-27\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"1591847931\",\"primary_isbn13\":\"9781591847939\",\"rank\":9,\"list_name\":\"Business Books\",\"display_name\":\"Business\",\"published_date\":\"2016-01-17\",\"bestsellers_date\":\"2016-01-02\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"1591847931\",\"primary_isbn13\":\"9781591847939\",\"rank\":9,\"list_name\":\"Business Books\",\"display_name\":\"Business\",\"published_date\":\"2015-12-13\",\"bestsellers_date\":\"2015-11-28\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"1591847931\",\"primary_isbn13\":\"9781591847939\",\"rank\":8,\"list_name\":\"Business Books\",\"display_name\":\"Business\",\"published_date\":\"2015-11-15\",\"bestsellers_date\":\"2015-10-31\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"039916927X\",\"primary_isbn13\":\"9780399169274\",\"rank\":10,\"list_name\":\"Business Books\",\"display_name\":\"Business\",\"published_date\":\"2014-11-09\",\"bestsellers_date\":\"2014-10-25\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"039916927X\",\"primary_isbn13\":\"9780399169274\",\"rank\":8,\"list_name\":\"Business Books\",\"display_name\":\"Business\",\"published_date\":\"2014-10-12\",\"bestsellers_date\":\"2014-09-27\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"039916927X\",\"primary_isbn13\":\"9780399169274\",\"rank\":14,\"list_name\":\"Advice How-To and Miscellaneous\",\"display_name\":\"Advice, How-To & Miscellaneous\",\"published_date\":\"2014-09-21\",\"bestsellers_date\":\"2014-09-06\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0}],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"#NEVERAGAIN\",\"description\":\"Students from Marjory Stoneman Douglas High School describe the Valentine's Day mass shooting and outline ways to prevent similar incidents.\",\"contributor\":\"by David Hogg and Lauren Hogg\",\"author\":\"David Hogg and Lauren Hogg\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Random House\",\"isbns\":[{\"isbn10\":\"198480183X\",\"isbn13\":\"9781984801838\"}],\"ranks_history\":[{\"primary_isbn10\":\"198480183X\",\"primary_isbn13\":\"9781984801838\",\"rank\":9,\"list_name\":\"Paperback Nonfiction\",\"display_name\":\"Paperback Nonfiction\",\"published_date\":\"2018-07-08\",\"bestsellers_date\":\"2018-06-23\",\"weeks_on_list\":1,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0}],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"$100 STARTUP\",\"description\":\"How to build a profitable start up for $100 or less and be your own boss.\",\"contributor\":\"by Chris Guillebeau\",\"author\":\"Chris Guillebeau\",\"contributor_note\":\"\",\"price\":23,\"age_group\":\"\",\"publisher\":\"Crown Business\",\"isbns\":[{\"isbn10\":\"0307951529\",\"isbn13\":\"9780307951526\"}],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"$20 PER GALLON\",\"description\":\"\",\"contributor\":\"by Christopher Steiner\",\"author\":\"Christopher Steiner\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Grand Central\",\"isbns\":[],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"'57, Chicago\",\"description\":null,\"contributor\":null,\"author\":\"Steve Monroe\",\"contributor_note\":null,\"price\":0,\"age_group\":null,\"publisher\":null,\"isbns\":[{\"isbn10\":\"0786867302\",\"isbn13\":\"9780786867301\"}],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":null,\"sunday_review_link\":\"https://www.nytimes.com/2001/07/29/books/books-in-brief-fiction-poetry-319660.html\",\"article_chapter_link\":null}]},{\"title\":\"'ROCK OF AGES: ''ROLLING STONE'' HISTORY OF ROCK AND ROLL'\",\"description\":null,\"contributor\":null,\"author\":\"GEOFFREY STOKES, KEN TUCKER' 'ED WARD\",\"contributor_note\":null,\"price\":0,\"age_group\":null,\"publisher\":null,\"isbns\":[{\"isbn10\":\"0671630687\",\"isbn13\":\"9780671630683\"}],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":null,\"sunday_review_link\":\"https://www.nytimes.com/1986/12/28/books/three-chord-music-in-a-three-piece-suit.html\",\"article_chapter_link\":null}]},{\"title\":\"'THE HIGH ROAD TO CHINA: GEORGE BOGLE, THE PANCHEN LAMA AND THE FIRST BRITISH EXPEDITION TO TIBET'\",\"description\":null,\"contributor\":null,\"author\":\"KATE TELTSCHER\",\"contributor_note\":null,\"price\":0,\"age_group\":null,\"publisher\":null,\"isbns\":[{\"isbn10\":\"0374217009\",\"isbn13\":\"9780374217006\"}],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":null,\"sunday_review_link\":\"https://www.nytimes.com/2007/04/22/books/review/Stuart.t.html\",\"article_chapter_link\":null}]},{\"title\":\"'TIL DEATH\",\"description\":\"\",\"contributor\":\"by Sharon Sala\",\"author\":\"Sharon Sala\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Harlequin Mira\",\"isbns\":[{\"isbn10\":\"0778314278\",\"isbn13\":\"9780778314271\"}],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"'TIL DEATH DO US PART\",\"description\":\"A matchmaker in Victorian England turns to a crime novelist for help when she starts receiving a series of disturbingly personalized trinkets.\",\"contributor\":\"by Amanda Quick\",\"author\":\"Amanda Quick\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Berkley\",\"isbns\":[{\"isbn10\":\"069819361X\",\"isbn13\":\"9780698193611\"},{\"isbn10\":\"039917446X\",\"isbn13\":\"9780399174469\"}],\"ranks_history\":[{\"primary_isbn10\":\"069819361X\",\"primary_isbn13\":\"9780698193611\",\"rank\":9,\"list_name\":\"E-Book Fiction\",\"display_name\":\"E-Book Fiction\",\"published_date\":\"2016-05-08\",\"bestsellers_date\":\"2016-04-23\",\"weeks_on_list\":1,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"069819361X\",\"primary_isbn13\":\"9780698193611\",\"rank\":15,\"list_name\":\"Combined Print and E-Book Fiction\",\"display_name\":\"Combined Print & E-Book Fiction\",\"published_date\":\"2016-05-08\",\"bestsellers_date\":\"2016-04-23\",\"weeks_on_list\":1,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0}],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"'Til Faith Do Us Part: How Interfaith Marriage is Transforming America\",\"description\":null,\"contributor\":null,\"author\":\"Naomi Schaefer Riley\",\"contributor_note\":null,\"price\":0,\"age_group\":null,\"publisher\":null,\"isbns\":[{\"isbn10\":\"0199873747\",\"isbn13\":\"9780199873746\"}],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":null,\"sunday_review_link\":\"https://www.nytimes.com/2013/05/26/books/review/til-faith-do-us-part-by-naomi-schaefer-riley.html\",\"article_chapter_link\":null}]},{\"title\":\"'TIS THE SEASON\",\"description\":\"Two classic holiday stories — \\\"Under the Christmas Tree\\\" (2009) and \\\"Midnight Confessions\\\" (2010) — plus the novella \\\"Backward Glance\\\" (1991).\",\"contributor\":\"by Robyn Carr\",\"author\":\"Ron Carr\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Harlequin Mira\",\"isbns\":[{\"isbn10\":\"0778316645\",\"isbn13\":\"9780778316640\"}],\"ranks_history\":[{\"primary_isbn10\":\"0778316645\",\"primary_isbn13\":\"9780778316640\",\"rank\":18,\"list_name\":\"Mass Market Paperback\",\"display_name\":\"Paperback Mass-Market Fiction\",\"published_date\":\"2014-11-30\",\"bestsellers_date\":\"2014-11-15\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"0778316645\",\"primary_isbn13\":\"9780778316640\",\"rank\":6,\"list_name\":\"Mass Market Paperback\",\"display_name\":\"Paperback Mass-Market Fiction\",\"published_date\":\"2014-11-16\",\"bestsellers_date\":\"2014-11-01\",\"weeks_on_list\":1,\"ranks_last_week\":null,\"asterisk\":1,\"dagger\":0}],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"------, THAT'S DELICIOUS\",\"description\":\"\",\"contributor\":\"by Action Bronson with Rachel Wharton\",\"author\":\"Action Bronson with Rachel Wharton\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Abrams\",\"isbns\":[{\"isbn10\":\"1419726552\",\"isbn13\":\"9781419726552\"}],\"ranks_history\":[{\"primary_isbn10\":\"1419726552\",\"primary_isbn13\":\"9781419726552\",\"rank\":9,\"list_name\":\"Advice How-To and Miscellaneous\",\"display_name\":\"Advice, How-To & Miscellaneous\",\"published_date\":\"2017-10-01\",\"bestsellers_date\":\"2017-09-16\",\"weeks_on_list\":1,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":1}],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"...and the Horse He Rode In On: The People V. Kenneth Starr\",\"description\":null,\"contributor\":null,\"author\":\"James Carville\",\"contributor_note\":null,\"price\":0,\"age_group\":null,\"publisher\":null,\"isbns\":[{\"isbn10\":\"0684857340\",\"isbn13\":\"9780684857343\"}],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":null,\"sunday_review_link\":\"https://www.nytimes.com/1998/10/18/books/preaching-to-the-converted.html\",\"article_chapter_link\":null}]},{\"title\":\".HACK G.U. , VOL. 5\",\"description\":\"This series, set in the future, is about an online, multiplayer game run amok. This volume concludes the tale.\",\"contributor\":\"by Hamazaki Tatsuya\",\"author\":\"Hamazaki Tatsuya\",\"contributor_note\":\"\",\"price\":10.99,\"age_group\":\"\",\"publisher\":\"TOKYOPOP\",\"isbns\":[],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"1 Ragged Ridge Road\",\"description\":null,\"contributor\":null,\"author\":\"David Adams Richards\",\"contributor_note\":null,\"price\":0,\"age_group\":null,\"publisher\":null,\"isbns\":[{\"isbn10\":\"0671003542\",\"isbn13\":\"9780671003548\"}],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":null,\"sunday_review_link\":\"https://www.nytimes.com/1997/08/31/books/books-in-brief-fiction-747866.html\",\"article_chapter_link\":null}]},{\"title\":\"1,000 PLACES TO SEE BEFORE YOU DIE\",\"description\":\"A guide for traveling the world; second edition updated with new entries.\",\"contributor\":\"by Patricia Schultz\",\"author\":\"Patricia Schultz\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Workman\",\"isbns\":[{\"isbn10\":\"0761156860\",\"isbn13\":\"9780761156864\"},{\"isbn10\":\"0761104844\",\"isbn13\":\"9780761104841\"}],\"ranks_history\":[{\"primary_isbn10\":\"0761156860\",\"primary_isbn13\":\"9780761156864\",\"rank\":10,\"list_name\":\"Travel\",\"display_name\":\"Travel\",\"published_date\":\"2015-04-12\",\"bestsellers_date\":\"2015-03-28\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"0761156860\",\"primary_isbn13\":\"9780761156864\",\"rank\":8,\"list_name\":\"Travel\",\"display_name\":\"Travel\",\"published_date\":\"2015-03-15\",\"bestsellers_date\":\"2015-02-28\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0},{\"primary_isbn10\":\"0761156860\",\"primary_isbn13\":\"9780761156864\",\"rank\":12,\"list_name\":\"Travel\",\"display_name\":\"Travel\",\"published_date\":\"2015-01-11\",\"bestsellers_date\":\"2014-12-27\",\"weeks_on_list\":0,\"ranks_last_week\":null,\"asterisk\":0,\"dagger\":0}],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]},{\"title\":\"1,000 RECORDINGS TO HEAR BEFORE YOU DIE\",\"description\":\"Operas, rock albums, blues, classical music, world music and other essentials, from a musician and music journalist.\",\"contributor\":\"by Tom Moon\",\"author\":\"Tom Moon\",\"contributor_note\":\"\",\"price\":0,\"age_group\":\"\",\"publisher\":\"Workman\",\"isbns\":[],\"ranks_history\":[],\"reviews\":[{\"book_review_link\":\"\",\"first_chapter_link\":\"\",\"sunday_review_link\":\"\",\"article_chapter_link\":\"\"}]}]}"Next, and finally, we convert our JSON file into a dataframe using the JSONLite package.
library(jsonlite)
booksJSON <- fromJSON(pull)[[4]]
typeof(booksJSON)## [1] "list"booksJSON## title
## 1 "I GIVE YOU MY BODY ..."
## 2 "MOST BLESSED OF THE PATRIARCHS"
## 3 #ASKGARYVEE
## 4 #GIRLBOSS
## 5 #NEVERAGAIN
## 6 $100 STARTUP
## 7 $20 PER GALLON
## 8 '57, Chicago
## 9 'ROCK OF AGES: ''ROLLING STONE'' HISTORY OF ROCK AND ROLL'
## 10 'THE HIGH ROAD TO CHINA: GEORGE BOGLE, THE PANCHEN LAMA AND THE FIRST BRITISH EXPEDITION TO TIBET'
## 11 'TIL DEATH
## 12 'TIL DEATH DO US PART
## 13 'Til Faith Do Us Part: How Interfaith Marriage is Transforming America
## 14 'TIS THE SEASON
## 15 ------, THAT'S DELICIOUS
## 16 ...and the Horse He Rode In On: The People V. Kenneth Starr
## 17 .HACK G.U. , VOL. 5
## 18 1 Ragged Ridge Road
## 19 1,000 PLACES TO SEE BEFORE YOU DIE
## 20 1,000 RECORDINGS TO HEAR BEFORE YOU DIE
## description
## 1 The author of the Outlander novels gives tips on writing sex scenes, drawing on examples from the books.
## 2 A character study that attempts to make sense of Jefferson’s contradictions.
## 3 The entrepreneur expands on subjects addressed on his Internet show, like marketing, management and social media.
## 4 An online fashion retailer traces her path to success.
## 5 Students from Marjory Stoneman Douglas High School describe the Valentine's Day mass shooting and outline ways to prevent similar incidents.
## 6 How to build a profitable start up for $100 or less and be your own boss.
## 7
## 8 <NA>
## 9 <NA>
## 10 <NA>
## 11
## 12 A matchmaker in Victorian England turns to a crime novelist for help when she starts receiving a series of disturbingly personalized trinkets.
## 13 <NA>
## 14 Two classic holiday stories — "Under the Christmas Tree" (2009) and "Midnight Confessions" (2010) — plus the novella "Backward Glance" (1991).
## 15
## 16 <NA>
## 17 This series, set in the future, is about an online, multiplayer game run amok. This volume concludes the tale.
## 18 <NA>
## 19 A guide for traveling the world; second edition updated with new entries.
## 20 Operas, rock albums, blues, classical music, world music and other essentials, from a musician and music journalist.
## contributor
## 1 by Diana Gabaldon
## 2 by Annette Gordon-Reed and Peter S. Onuf
## 3 by Gary Vaynerchuk
## 4 by Sophia Amoruso
## 5 by David Hogg and Lauren Hogg
## 6 by Chris Guillebeau
## 7 by Christopher Steiner
## 8 <NA>
## 9 <NA>
## 10 <NA>
## 11 by Sharon Sala
## 12 by Amanda Quick
## 13 <NA>
## 14 by Robyn Carr
## 15 by Action Bronson with Rachel Wharton
## 16 <NA>
## 17 by Hamazaki Tatsuya
## 18 <NA>
## 19 by Patricia Schultz
## 20 by Tom Moon
## author contributor_note price age_group
## 1 Diana Gabaldon 0.00
## 2 Annette Gordon-Reed and Peter S Onuf 0.00
## 3 Gary Vaynerchuk 0.00
## 4 Sophia Amoruso 0.00
## 5 David Hogg and Lauren Hogg 0.00
## 6 Chris Guillebeau 23.00
## 7 Christopher Steiner 0.00
## 8 Steve Monroe <NA> 0.00 <NA>
## 9 GEOFFREY STOKES, KEN TUCKER' 'ED WARD <NA> 0.00 <NA>
## 10 KATE TELTSCHER <NA> 0.00 <NA>
## 11 Sharon Sala 0.00
## 12 Amanda Quick 0.00
## 13 Naomi Schaefer Riley <NA> 0.00 <NA>
## 14 Ron Carr 0.00
## 15 Action Bronson with Rachel Wharton 0.00
## 16 James Carville <NA> 0.00 <NA>
## 17 Hamazaki Tatsuya 10.99
## 18 David Adams Richards <NA> 0.00 <NA>
## 19 Patricia Schultz 0.00
## 20 Tom Moon 0.00
## publisher
## 1 Dell
## 2 Liveright
## 3 HarperCollins
## 4 Portfolio/Penguin/Putnam
## 5 Random House
## 6 Crown Business
## 7 Grand Central
## 8 <NA>
## 9 <NA>
## 10 <NA>
## 11 Harlequin Mira
## 12 Berkley
## 13 <NA>
## 14 Harlequin Mira
## 15 Abrams
## 16 <NA>
## 17 TOKYOPOP
## 18 <NA>
## 19 Workman
## 20 Workman
## isbns
## 1 0399178570, 9780399178573
## 2 0871404427, 9780871404428
## 3 0062273124, 0062273132, 9780062273123, 9780062273130
## 4 039916927X, 1591847931, 9780399169274, 9781591847939
## 5 198480183X, 9781984801838
## 6 0307951529, 9780307951526
## 7 NULL
## 8 0786867302, 9780786867301
## 9 0671630687, 9780671630683
## 10 0374217009, 9780374217006
## 11 0778314278, 9780778314271
## 12 069819361X, 039917446X, 9780698193611, 9780399174469
## 13 0199873747, 9780199873746
## 14 0778316645, 9780778316640
## 15 1419726552, 9781419726552
## 16 0684857340, 9780684857343
## 17 NULL
## 18 0671003542, 9780671003548
## 19 0761156860, 0761104844, 9780761156864, 9780761104841
## 20 NULL
## ranks_history
## 1 0399178570, 9780399178573, 8, Advice How-To and Miscellaneous, Advice, How-To & Miscellaneous, 2016-09-04, 2016-08-20, 1, NA, 0, 0
## 2 0871404427, 9780871404428, 16, Hardcover Nonfiction, Hardcover Nonfiction, 2016-05-01, 2016-04-16, 1, NA, 1, 0
## 3 0062273124, 0062273124, 9780062273123, 9780062273123, 5, 6, Business Books, Advice How-To and Miscellaneous, Business, Advice, How-To & Miscellaneous, 2016-04-10, 2016-03-27, 2016-03-26, 2016-03-12, 0, 1, NA, NA, 0, 0, 1, 1
## 4 1591847931, 1591847931, 1591847931, 1591847931, 039916927X, 039916927X, 039916927X, 9781591847939, 9781591847939, 9781591847939, 9781591847939, 9780399169274, 9780399169274, 9780399169274, 8, 9, 9, 8, 10, 8, 14, Business Books, Business Books, Business Books, Business Books, Business Books, Business Books, Advice How-To and Miscellaneous, Business, Business, Business, Business, Business, Business, Advice, How-To & Miscellaneous, 2016-03-13, 2016-01-17, 2015-12-13, 2015-11-15, 2014-11-09, 2014-10-12, 2014-09-21, 2016-02-27, 2016-01-02, 2015-11-28, 2015-10-31, 2014-10-25, 2014-09-27, 2014-09-06, 0, 0, 0, 0, 0, 0, 0, NA, NA, NA, NA, NA, NA, NA, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0
## 5 198480183X, 9781984801838, 9, Paperback Nonfiction, Paperback Nonfiction, 2018-07-08, 2018-06-23, 1, NA, 0, 0
## 6 NULL
## 7 NULL
## 8 NULL
## 9 NULL
## 10 NULL
## 11 NULL
## 12 069819361X, 069819361X, 9780698193611, 9780698193611, 9, 15, E-Book Fiction, Combined Print and E-Book Fiction, E-Book Fiction, Combined Print & E-Book Fiction, 2016-05-08, 2016-05-08, 2016-04-23, 2016-04-23, 1, 1, NA, NA, 0, 0, 0, 0
## 13 NULL
## 14 0778316645, 0778316645, 9780778316640, 9780778316640, 18, 6, Mass Market Paperback, Mass Market Paperback, Paperback Mass-Market Fiction, Paperback Mass-Market Fiction, 2014-11-30, 2014-11-16, 2014-11-15, 2014-11-01, 0, 1, NA, NA, 0, 1, 0, 0
## 15 1419726552, 9781419726552, 9, Advice How-To and Miscellaneous, Advice, How-To & Miscellaneous, 2017-10-01, 2017-09-16, 1, NA, 0, 1
## 16 NULL
## 17 NULL
## 18 NULL
## 19 0761156860, 0761156860, 0761156860, 9780761156864, 9780761156864, 9780761156864, 10, 8, 12, Travel, Travel, Travel, Travel, Travel, Travel, 2015-04-12, 2015-03-15, 2015-01-11, 2015-03-28, 2015-02-28, 2014-12-27, 0, 0, 0, NA, NA, NA, 0, 0, 0, 0, 0, 0
## 20 NULL
## reviews
## 1 , , ,
## 2 , , ,
## 3 , , ,
## 4 , , ,
## 5 , , ,
## 6 , , ,
## 7 , , ,
## 8 , NA, https://www.nytimes.com/2001/07/29/books/books-in-brief-fiction-poetry-319660.html, NA
## 9 , NA, https://www.nytimes.com/1986/12/28/books/three-chord-music-in-a-three-piece-suit.html, NA
## 10 , NA, https://www.nytimes.com/2007/04/22/books/review/Stuart.t.html, NA
## 11 , , ,
## 12 , , ,
## 13 , NA, https://www.nytimes.com/2013/05/26/books/review/til-faith-do-us-part-by-naomi-schaefer-riley.html, NA
## 14 , , ,
## 15 , , ,
## 16 , NA, https://www.nytimes.com/1998/10/18/books/preaching-to-the-converted.html, NA
## 17 , , ,
## 18 , NA, https://www.nytimes.com/1997/08/31/books/books-in-brief-fiction-747866.html, NA
## 19 , , ,
## 20 , , ,