The New York Times web site provides a rich set of APIs, as described here: https://developer.nytimes.com/apis You’ll need to start by signing up for an API key. Your task is to choose one of the New York Times APIs, construct an interface in R to read in the JSON data, and transform it into an R DataFrame.
library(RCurl)## Loading required package: bitopslibrary(dplyr)##
## Attaching package: 'dplyr'## The following objects are masked from 'package:stats':
##
## filter, lag## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, unionlibrary(stringr)
library(httr)
library(jsonlite)
library(DT)
library(rvest)## Loading required package: xml2library(kableExtra)##
## Attaching package: 'kableExtra'## The following object is masked from 'package:dplyr':
##
## group_rowsGetting a list of best seller books where author is Stephen King from the Book API in New York Times
jsonFile1 <- "https://api.nytimes.com/svc/books/v3/reviews.json?author=Stephen+King&api-key=6Ll00ebXWXzaPjr4FQ3yMhevWwY0CHr0"Creating a data frame using the json file that we just retrieved from NYT Books API
Stephen_King_Books <- tbl_df(as.data.frame(fromJSON(jsonFile1)))
Stephen_King_Books %>%
kable ()%>%
kable_styling(bootstrap_options = "striped", font_size = 10) %>%
scroll_box(height = "500px", width = "100%")| status | copyright | num_results | results.url | results.publication_dt | results.byline | results.book_title | results.book_author | results.summary | results.uuid | results.uri | results.isbn13 |
|---|---|---|---|---|---|---|---|---|---|---|---|
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2011/11/13/books/review/11-22-63-by-stephen-king-book-review.html | 2011-11-13 | ERROL MORRIS | 11/22/63 | Stephen King | Stephen King’s time traveler tries to undo some painful history. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9780307951434”, “9780606351461”, “9781442344280”, “9781442344303”, “9781442391635”, “9781444727326”, “9781451627282”, “9781451627299”, “9781451627305”, “9781451651645”, “9781501120602”, “9781594135590”) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2011/10/31/books/stephen-kings-11-23-63-review.html | 2011-10-31 | JANET MASLIN | 11/22/63 | Stephen King | Stephen King’s latest novel, “11/22/63,” tells of a schoolteacher who travels back to 1958 to alter history, and falls in love as well. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9780307951434”, “9780606351461”, “9781442344280”, “9781442344303”, “9781442391635”, “9781444727326”, “9781451627282”, “9781451627299”, “9781451627305”, “9781451651645”, “9781501120602”, “9781594135590”) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2004/01/04/books/the-quest-for-the-north-central-positronics.html | 2004-01-04 | ANDREW O’HEHIR | Wolves of the Calla | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781848941137 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1993/10/24/books/in-short-fiction-284093.html | 1993-10-24 | RICHARD E. NICHOLLS | Nightmares and Dreamscapes | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781441615299 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2001/11/04/books/books-in-brief-fiction-poetry-851302.html | 2001-11-04 | MARY ELIZABETH WILLIAMS | Black House | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780375504396 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1990/05/13/books/armageddon-complete-and-uncut.html | 1990-05-13 | ROBERT KIELY | The Stand | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781848940833 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1990/09/02/books/scared-but-safe.html | 1990-09-02 | ANDY SOLOMON | Four Past Midnight | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780816151776 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1991/10/20/books/l-defending-stephen-king-075091.html | 1991-10-20 | Needful Things | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781598877427 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1992/06/29/books/books-of-the-times-to-be-read-in-daylight-away-from-hungry-dogs.html | 1992-06-29 | CHRISTOPHER LEHMANN-HAUPT | Gerald’s Game | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670846504 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2002/04/14/books/the-horror-etc.html | 2002-04-14 | WALTER KIRN | Everything’s Eventual : 14 Dark Tales | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781439568200 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1986/08/21/books/books-of-the-times-547486.html | 1986-08-21 | CHRISTOPHER LEHMANN-HAUPT | It | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780451169518 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2010/11/28/books/review/Rafferty-t.html | 2010-11-28 | TERRENCE RAFFERTY | Full Dark, No Stars | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9781439192566”, “9781439192597”, “9781439192603”, “9781441677112”, “9781442335769”, “9781444712582”, “9781451650600”, “9781602859463”) | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1998/09/27/books/familiar-terrors.html | 1998-09-27 | DANIEL MENDELSOHN | Bag of Bones | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780671026073 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2002/03/18/books/books-of-the-times-storytelling-mogul-decides-to-sweep-out-odds-and-ends.html | 2002-03-18 | JANET MASLIN | Everything’s Eventual : 14 Dark Tales | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781416537816 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1995/07/02/books/in-short-fiction-077895.html | 1995-07-02 | RICHARD E. NICHOLLS | Rose Madder | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781568952611 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2013/09/16/books/doctor-sleep-is-stephen-kings-sequel-to-the-shining.html | 2013-09-16 | JANET MASLIN | Doctor Sleep | Stephen King | In “Doctor Sleep” Stephen King offers a sequel to “The Shining.” | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781451698855 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2013/09/22/books/review/stephen-kings-shining-sequel-doctor-sleep.html | 2013-09-22 | MARGARET ATWOOD | Doctor Sleep | Stephen King | “Doctor Sleep” picks up the story of Danny, the little boy with psycho-intuitive powers from Stephen King’s 1977 novel “The Shining.” | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781451698855 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2013/06/23/books/review/joyland-by-stephen-king.html | 2013-06-23 | WALTER KIRN | Joyland | Stephen King | Stephen King’s lovelorn narrator takes a summer job at a haunted Southern amusement park. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781781162644 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2009/11/08/books/review/JParker-t.html | 2009-11-08 | JAMES PARKER | Under the Dome | Stephen King | When an enormous transparent dome settles over a small town in Maine in Stephen King’s new novel, it’s just fine with Big Jim, the local tyrant-in-waiting, and his pet goon squad. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781476735474 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2009/11/12/books/12book.html | 2009-11-12 | JANET MASLIN | Under the Dome | Stephen King | “Under the Dome” gravely threatens Stephen King’s status as a mere chart-busting pop cultural phenomenon. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781476735474 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2014/11/14/books/stephen-kings-revival.html | 2014-11-14 | JANET MASLIN | Revival | Stephen King | In Stephen King’s “Revival,” a boy is befriended by a charismatic minister with whom he will reconnect in eerie and unsettling ways as an adult. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9781410473837”, “9781442372764”, “9781442372788”, “9781476770383”, “9781476770390”, “9781476770406”) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2014/11/23/books/review/stephen-kings-revival.html | 2014-11-23 | DANIELLE TRUSSONI | Revival | Stephen King | Two men are locked in a battle of wills in Stephen King’s novel of fanaticism and what might exist on the other side of life. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9781410473837”, “9781442372764”, “9781442372788”, “9781476770383”, “9781476770390”, “9781476770406”) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2006/11/12/books/review/Windolf.t.html | 2006-11-12 | JIM WINDOLF | Lisey’s Story | Stephen King | When Stephen King really wants to put a scare into you, he brings on his most fearsome monster of all, the writer. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781416523352 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2008/11/05/books/05masl.html | 2008-11-05 | JANET MASLIN | Just After Sunset | Stephen King | Everyday situations became open portals to fantasy and horror in Stephen King’s succinct, fast-moving new collection. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781416586654 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2008/11/23/books/review/Taylor-t.html | 2008-11-23 | CHARLES TAYLOR | Just After Sunset | Stephen King | A new short-story collection takes Stephen King back to the form that gave him his seat-of-the-pants start. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781416586654 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2008/01/21/books/21maslin.html | 2008-01-21 | JANET MASLIN | Duma Key | Stephen King | Stephen King’s use of horror is not what it used to be. It may still be the impetus for his stories, but it is no longer the foremost reason they’re interesting. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781416552963 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2008/03/02/books/review/Campbell-t.html | 2008-03-02 | JAMES CAMPBELL | Duma Key | Stephen King | In Stephen King’s new novel, a man recuperating in the Florida Keys begins to paint, with sinister results. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781416552963 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2006/10/23/books/23masl.html | 2006-10-23 | JANET MASLIN | Lisey’s Story | Stephen King | In his new book, Stephen King delivers his version of Joycean wordplay, idiosyncrasy, voluptuousness and stubborn, obsessive chronology. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781416523352 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2014/06/08/books/review/stephen-kings-mr-mercedes.html | 2014-06-08 | MEGAN ABBOTT | Mr. Mercedes | Stephen King | With one eye on Philip Marlowe, Stephen King takes a crack at the detective novel. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9781410469007”, “9781442369788”, “9781442371347”, “9781442395404”, “9781476754451”, “9781476754468”, “9781476754475”, “9781501125607”) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1981/05/10/books/scare-tactics.html | 1981-05-10 | MICHELE SLUNG | Stephen King’s Danse Macabre | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780896960763 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1981/08/14/books/books-of-the-times-books-of-the-times.html | 1981-08-14 | Cujo | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670451937 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1982/08/11/books/books-of-the-times-074639.html | 1982-08-11 | Different Seasons | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670272662 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1982/08/29/books/horror-writer-s-holiday.html | 1982-08-29 | ALAN CHEUSE | Different Seasons | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670272662 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1983/04/03/books/the-other-woman-was-a-car.html | 1983-04-03 | PHILLIPE VAN RJNDT | Christine | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670220267 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1983/04/12/books/books-of-the-times-093019.html | 1983-04-12 | Christine | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670220267 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1983/10/21/books/books-of-the-times-243538.html | 1983-10-21 | Pet Sematary | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780385182447 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1985/06/09/books/don-t-turn-your-back-on-this-book.html | 1985-06-09 | SUSAN BOLOTIN | Skeleton Crew | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | NULL | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1987/02/22/books/what-the-wicked-magician-did.html | 1987-02-22 | BARBARA TRITEL | The Eyes of the Dragon | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | NULL | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1987/05/31/books/summer-reading-sheldon-gets-the-ax.html | 1987-05-31 | JOHN KATZENBACH | Misery | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670813643 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1987/06/08/books/books-of-the-times-301987.html | 1987-06-08 | Misery | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670813643 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1987/11/05/books/books-of-the-times-950387.html | 1987-11-05 | The Tommyknockers | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780399133145 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1987/12/20/books/not-with-a-bang-but-an-eeeooooarrrhmm.html | 1987-12-20 | NINA AUERBACH | The Tommyknockers | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780399133145 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1989/10/23/books/books-of-the-times-from-stephen-king-a-writer-s-demon.html | 1989-10-23 | The Dark Half | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | NULL | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1989/10/29/books/his-alter-ego-is-a-killer.html | 1989-10-29 | GEORGE STADE | The Dark Half | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | NULL | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1991/09/29/books/avaunt-thee-recreant-cyborg.html | 1991-09-29 | RICHARD E. NICHOLLS | The Waste Lands: The Dark Tower Book III | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780452267404 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1991/10/03/books/books-of-the-times-turning-favors-into-catastrophe.html | 1991-10-03 | Needful Things: The Last Castle Rock Story | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670839537 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1994/10/06/books/books-of-the-times-lack-of-sleep-the-least-of-his-problems.html | 1994-10-06 | Insomnia,Stephen King Library Ed. | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670855032 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1995/06/26/books/book-review-a-punch-in-the-nose-then-a-new-life-begins.html | 1995-06-26 | Rose Madder | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780670858699 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1998/09/21/books/books-of-the-times-death-terror-and-writer-s-block.html | 1998-09-21 | Bag of Bones | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780684853505 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1999/04/15/books/books-of-the-times-a-modern-fairy-tale-of-the-dark-north-woods.html | 1999-04-15 | The Girl Who Loved Tom Gordon : A Novel | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780684867625 | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/1999/05/16/books/books-in-brief-fiction-583618.html | 1999-05-16 | ANDREW ESSEX | The Girl Who Loved Tom Gordon : A Novel | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780684867625 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2000/10/05/books/books-of-the-times-how-to-write-if-you-re-stephen-king.html | 2000-10-05 | JANET MASLIN | On Writing: a Memoir of the Craft | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9780606222549”, “9780606231862”, “9780671024253”, “9780684853529”, “9780743204361”, “9780743211536”, “9780743455961”, “9780743563376”, “9781416549864”, “9781417647019”, “9781439156810”, “9781439193631”, “9781441658869”, “9781444723250”, “9781848941083”, “9781931208048”) | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2000/10/08/books/making-it.html | 2000-10-08 | FREDERICK BUSCH | On Writing: a Memoir of the Craft | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9780606222549”, “9780606231862”, “9780671024253”, “9780684853529”, “9780743204361”, “9780743211536”, “9780743455961”, “9780743563376”, “9781416549864”, “9781417647019”, “9781439156810”, “9781439193631”, “9781441658869”, “9781444723250”, “9781848941083”, “9781931208048”) | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2001/03/15/books/books-of-the-times-a-fateful-step-off-a-curb-and-into-alien-territory.html | 2001-03-15 | JANET MASLIN | Dreamcatcher | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780743211383 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2001/04/15/books/weasel-from-another-planet.html | 2001-04-15 | COLIN HARRISON | Dreamcatcher | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780743211383 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2002/09/23/books/books-of-the-times-cruising-the-dark-side-forget-about-seat-belts.html | 2002-09-23 | JANET MASLIN | From a Buick 8 | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780743211376 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2002/09/29/books/not-your-father-s-roadmaster.html | 2002-09-29 | LAURA MILLER | From a Buick 8 | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780743211376 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2004/06/20/books/books-in-brief-fiction-937851.html | 2004-06-20 | BEN SISARIO | The Dark Tower VI | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781880418598 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2006/01/23/books/23masl.html | 2006-01-23 | JANET MASLIN | Cell | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780743292337 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2006/02/05/books/review/05itzkoff.html | 2006-02-05 | DAVE ITZKOFF | Cell | Stephen King | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9780743292337 | |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2015/05/31/books/review/stephen-kings-finders-keepers.html | 2015-05-31 | LAURA LIPPMAN | Finders Keepers | Stephen King | Laura Lippman reviews Stephen King’s “Finders Keepers,” the second entry in a planned trilogy that began with “Mr. Mercedes.” | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9781410479501”, “9781442384347”, “9781501100079”, “9781501100123”, “9781501100130”, “9781594138522”) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | http://www.nytimes.com/2016/06/12/books/review/stephen-kings-end-of-watch.html | 2016-06-12 | DENISE MINA | End of Watch | Stephen King | A retired police detective sees the return of his nemesis in this suspense story with a supernatural twist. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | c(“9781410489906”, “9781501129742”, “9781501134142”, “9781501134159”, “9781508211358”) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | https://www.nytimes.com/2018/05/22/books/review/outsider-stephen-king.html | 2018-05-22 | VICTOR LAVALLE | The Outsider | Stephen King | “The Outsider” starts out as a routine police procedural but before long transforms into something much more sinister. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781501180989 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | https://www.nytimes.com/2018/10/26/books/review/stephen-king-elevation.html | 2018-10-26 | GILBERT CRUZ | Elevation | Stephen King | King’s slim new novel, “Elevation,” returns us to Castle Rock, where prejudice drives a plot that blends the fantastical with the mundane. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781982102319 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | https://www.nytimes.com/2019/09/08/books/review-institute-stephen-king.html | 2019-09-08 | DWIGHT GARNER | The Institute | Stephen King | In his latest, King tells the story of an institution where children with special powers are cultivated — but that’s just where the nightmare begins. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781982110567 |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 66 | https://www.nytimes.com/2019/09/10/books/review/stephen-king-the-institute.html | 2019-09-10 | LAURA MILLER | The Institute | Stephen King | The terror doesn’t come from ghosts or fiends or clowns — it’s ordinary people, folks just like you and me, who are the evil ones. | 00000000-0000-0000-0000-000000000000 | nyt://book/00000000-0000-0000-0000-000000000000 | 9781982110567 |
Getting a list of Best seller history books
jsonFile2 <- "https://api.nytimes.com/svc/books/v3/lists/best-sellers/history.json?&api-key=6Ll00ebXWXzaPjr4FQ3yMhevWwY0CHr0"Converting the json file to a dataframe
BestSeller <- tbl_df(as.data.frame(fromJSON(jsonFile2)))
BestSeller %>%
kable ()%>%
kable_styling(bootstrap_options = "striped", font_size = 10) %>%
scroll_box(height = "500px", width = "100%")| status | copyright | num_results | results.title | results.description | results.contributor | results.author | results.contributor_note | results.price | results.age_group | results.publisher | results.isbns | results.ranks_history | results.reviews |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | “I GIVE YOU MY BODY …” | The author of the Outlander novels gives tips on writing sex scenes, drawing on examples from the books. | by Diana Gabaldon | Diana Gabaldon | 0.00 | Dell | list(isbn10 = “0399178570”, isbn13 = “9780399178573”) | list(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 = NA, asterisk = 0, dagger = 0) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | “MOST BLESSED OF THE PATRIARCHS” | A character study that attempts to make sense of Jefferson’s contradictions. | by Annette Gordon-Reed and Peter S. Onuf | Annette Gordon-Reed and Peter S Onuf | 0.00 | Liveright | list(isbn10 = “0871404427”, isbn13 = “9780871404428”) | list(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 = NA, asterisk = 1, dagger = 0) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | #ASKGARYVEE | The entrepreneur expands on subjects addressed on his Internet show, like marketing, management and social media. | by Gary Vaynerchuk | Gary Vaynerchuk | 0.00 | HarperCollins | list(isbn10 = c(“0062273124”, “0062273132”), isbn13 = c(“9780062273123”, “9780062273130”)) | list(primary_isbn10 = c(“0062273124”, “0062273124”), primary_isbn13 = c(“9780062273123”, “9780062273123”), rank = 5:6, list_name = c(“Business Books”, “Advice How-To and Miscellaneous”), display_name = c(“Business”, “Advice, How-To & Miscellaneous”), published_date = c(“2016-04-10”, “2016-03-27”), bestsellers_date = c(“2016-03-26”, “2016-03-12”), weeks_on_list = 0:1, ranks_last_week = c(NA, NA), asterisk = c(0, 0), dagger = c(1, 1)) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | #GIRLBOSS | An online fashion retailer traces her path to success. | by Sophia Amoruso | Sophia Amoruso | 0.00 | Portfolio/Penguin/Putnam | list(isbn10 = c(“039916927X”, “1591847931”), isbn13 = c(“9780399169274”, “9781591847939”)) | list(primary_isbn10 = c(“1591847931”, “1591847931”, “1591847931”, “1591847931”, “039916927X”, “039916927X”), primary_isbn13 = c(“9781591847939”, “9781591847939”, “9781591847939”, “9781591847939”, “9780399169274”, “9780399169274”), rank = c(8, 9, 9, 8, 10, 8), list_name = c(“Business Books”, “Business Books”, “Business Books”, “Business Books”, “Business Books”, “Business Books”), display_name = c(“Business”, “Business”, “Business”, “Business”, “Business”, “Business”), published_date = c(“2016-03-13”, “2016-01-17”, “2015-12-13”, “2015-11-15”, “2014-11-09”, “2014-10-12”), bestsellers_date = c(“2016-02-27”, “2016-01-02”, “2015-11-28”, “2015-10-31”, “2014-10-25”, “2014-09-27”), weeks_on_list = c(0, 0, 0, 0, 0, 0), ranks_last_week = c(NA, NA, NA, NA, NA, NA), asterisk = c(0, 0, 0, 0, 0, 0), dagger = c(0, 0, 0, 0, 0, 0)) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | #IMOMSOHARD | by Kristin Hensley and Jen Smedley | Kristin Hensley and Jen Smedley | 0.00 | HarperOne | list(isbn10 = “006285769X”, isbn13 = “9780062857699”) | list(primary_isbn10 = “006285769X”, primary_isbn13 = “9780062857699”, rank = 10, list_name = “Advice How-To and Miscellaneous”, display_name = “Advice, How-To & Miscellaneous”, published_date = “2019-04-21”, bestsellers_date = “2019-04-06”, weeks_on_list = 1, ranks_last_week = NA, asterisk = 0, dagger = 1) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | |||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | #NEVERAGAIN | Students from Marjory Stoneman Douglas High School describe the Valentine’s Day mass shooting and outline ways to prevent similar incidents. | by David Hogg and Lauren Hogg | David Hogg and Lauren Hogg | 0.00 | Random House | list(isbn10 = “198480183X”, isbn13 = “9781984801838”) | list(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 = NA, asterisk = 0, dagger = 0) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | $100 STARTUP | How to build a profitable start up for $100 or less and be your own boss. | by Chris Guillebeau | Chris Guillebeau | 23.00 | Crown Business | list(isbn10 = “0307951529”, isbn13 = “9780307951526”) | list() | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | $20 PER GALLON | by Christopher Steiner | Christopher Steiner | 0.00 | Grand Central | list() | list() | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | |||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | ’57, Chicago | NA | NA | Steve Monroe | NA | 0.00 | NA | NA | list(isbn10 = “0786867302”, isbn13 = “9780786867301”) | list() | list(book_review_link = "“, first_chapter_link = NA, sunday_review_link =”https://www.nytimes.com/2001/07/29/books/books-in-brief-fiction-poetry-319660.html", article_chapter_link = NA) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | ‘ROCK OF AGES:’‘ROLLING STONE’’ HISTORY OF ROCK AND ROLL’ | NA | NA | GEOFFREY STOKES, KEN TUCKER’ ’ED WARD | NA | 0.00 | NA | NA | list(isbn10 = “0671630687”, isbn13 = “9780671630683”) | list() | list(book_review_link = "“, first_chapter_link = NA, sunday_review_link =”https://www.nytimes.com/1986/12/28/books/three-chord-music-in-a-three-piece-suit.html", article_chapter_link = NA) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | ‘THE HIGH ROAD TO CHINA: GEORGE BOGLE, THE PANCHEN LAMA AND THE FIRST BRITISH EXPEDITION TO TIBET’ | NA | NA | KATE TELTSCHER | NA | 0.00 | NA | NA | list(isbn10 = “0374217009”, isbn13 = “9780374217006”) | list() | list(book_review_link = "“, first_chapter_link = NA, sunday_review_link =”https://www.nytimes.com/2007/04/22/books/review/Stuart.t.html", article_chapter_link = NA) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | ’TIL DEATH | by Sharon Sala | Sharon Sala | 0.00 | Harlequin Mira | list(isbn10 = “0778314278”, isbn13 = “9780778314271”) | list() | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | |||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | ’TIL DEATH DO US PART | A matchmaker in Victorian England turns to a crime novelist for help when she starts receiving a series of disturbingly personalized trinkets. | by Amanda Quick | Amanda Quick | 0.00 | Berkley | list(isbn10 = c(“069819361X”, “039917446X”), isbn13 = c(“9780698193611”, “9780399174469”)) | list(primary_isbn10 = c(“069819361X”, “069819361X”), primary_isbn13 = c(“9780698193611”, “9780698193611”), rank = c(9, 15), list_name = c(“E-Book Fiction”, “Combined Print and E-Book Fiction”), display_name = c(“E-Book Fiction”, “Combined Print & E-Book Fiction”), published_date = c(“2016-05-08”, “2016-05-08”), bestsellers_date = c(“2016-04-23”, “2016-04-23”), weeks_on_list = c(1, 1), ranks_last_week = c(NA, NA), asterisk = c(0, 0), dagger = c(0, 0)) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | ’Til Faith Do Us Part: How Interfaith Marriage is Transforming America | NA | NA | Naomi Schaefer Riley | NA | 0.00 | NA | NA | list(isbn10 = “0199873747”, isbn13 = “9780199873746”) | list() | list(book_review_link = "“, first_chapter_link = NA, 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 = NA) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | ’TIS THE SEASON | Two classic holiday stories — “Under the Christmas Tree” (2009) and “Midnight Confessions” (2010) — plus the novella “Backward Glance” (1991). | by Robyn Carr | Ron Carr | 0.00 | Harlequin Mira | list(isbn10 = “0778316645”, isbn13 = “9780778316640”) | list(primary_isbn10 = c(“0778316645”, “0778316645”), primary_isbn13 = c(“9780778316640”, “9780778316640”), rank = c(18, 6), list_name = c(“Mass Market Paperback”, “Mass Market Paperback”), display_name = c(“Paperback Mass-Market Fiction”, “Paperback Mass-Market Fiction”), published_date = c(“2014-11-30”, “2014-11-16”), bestsellers_date = c(“2014-11-15”, “2014-11-01”), weeks_on_list = 0:1, ranks_last_week = c(NA, NA), asterisk = 0:1, dagger = c(0, 0)) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | ——, THAT’S DELICIOUS | by Action Bronson with Rachel Wharton | Action Bronson with Rachel Wharton | 0.00 | Abrams | list(isbn10 = “1419726552”, isbn13 = “9781419726552”) | list(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 = NA, asterisk = 0, dagger = 1) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | |||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | …and the Horse He Rode In On: The People V. Kenneth Starr | NA | NA | James Carville | NA | 0.00 | NA | NA | list(isbn10 = “0684857340”, isbn13 = “9780684857343”) | list() | list(book_review_link = "“, first_chapter_link = NA, sunday_review_link =”https://www.nytimes.com/1998/10/18/books/preaching-to-the-converted.html", article_chapter_link = NA) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | .HACK G.U. , VOL. 5 | This series, set in the future, is about an online, multiplayer game run amok. This volume concludes the tale. | by Hamazaki Tatsuya | Hamazaki Tatsuya | 10.99 | TOKYOPOP | list() | list() | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") | ||
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | 1 Ragged Ridge Road | NA | NA | David Adams Richards | NA | 0.00 | NA | NA | list(isbn10 = “0671003542”, isbn13 = “9780671003548”) | list() | list(book_review_link = "“, first_chapter_link = NA, sunday_review_link =”https://www.nytimes.com/1997/08/31/books/books-in-brief-fiction-747866.html", article_chapter_link = NA) |
| OK | Copyright (c) 2019 The New York Times Company. All Rights Reserved. | 32476 | 1,000 PLACES TO SEE BEFORE YOU DIE | A guide for traveling the world; second edition updated with new entries. | by Patricia Schultz | Patricia Schultz | 0.00 | Workman | list(isbn10 = c(“0761156860”, “0761104844”), isbn13 = c(“9780761156864”, “9780761104841”)) | list(primary_isbn10 = c(“0761156860”, “0761156860”, “0761156860”), primary_isbn13 = c(“9780761156864”, “9780761156864”, “9780761156864”), rank = c(10, 8, 12), list_name = c(“Travel”, “Travel”, “Travel”), display_name = c(“Travel”, “Travel”, “Travel”), published_date = c(“2015-04-12”, “2015-03-15”, “2015-01-11”), bestsellers_date = c(“2015-03-28”, “2015-02-28”, “2014-12-27”), weeks_on_list = c(0, 0, 0), ranks_last_week = c(NA, NA, NA), asterisk = c(0, 0, 0), dagger = c(0, 0, 0)) | list(book_review_link = "“, first_chapter_link =”“, sunday_review_link =”“, article_chapter_link =”") |