myurl1 <- "https://api.nytimes.com/svc/books/v3/lists/2019-10-26/hardcover-fiction.json?api-key=wl3OA7v4AV7cjxGya142nvRGGv46HdNG"
myresponse1 <- fromJSON(myurl1)
myresponse1$results$books %>% kable() %>% kable_styling() %>% scroll_box(width = "910px", height = "400px")| rank | rank_last_week | weeks_on_list | asterisk | dagger | primary_isbn10 | primary_isbn13 | publisher | description | price | title | author | contributor | contributor_note | book_image | book_image_width | book_image_height | amazon_product_url | age_group | book_review_link | first_chapter_link | sunday_review_link | article_chapter_link | isbns | buy_links | book_uri |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0 | 1 | 0 | 0 | 0316420271 | 9780316420273 | Little, Brown | In the 19th installment of the Women’s Murder Club series, detective Lindsay Boxer and company take on a fearsome criminal known only as “Loman.” | 0 | THE 19TH CHRISTMAS | James Patterson and Maxine Paetro | by James Patterson and Maxine Paetro | https://s1.nyt.com/du/books/images/9780316494021.jpg | 321 | 495 | https://www.amazon.com/19th-Christmas-Womens-Murder-Club-ebook/dp/B07P1SSF9S?tag=NYTBS-20 | list(isbn10 = c(“0316420271”, “031649402X”), isbn13 = c(“9780316420273”, “9780316494021”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/19th-Christmas-Womens-Murder-Club-ebook/dp/B07P1SSF9S?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=THE+19TH+CHRISTMAS&author=James+Patterson+and+Maxine+Paetro”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780316420273”, “http://www.indiebound.org/book/9780316420273?aff=NYT”)) | nyt://book/8a6cd41d-3325-5e3d-a20e-7e051a28014e | ||||||
| 2 | 3 | 58 | 0 | 0 | 0735219095 | 9780735219090 | Putnam | A woman who survived alone in the marsh becomes a murder suspect. | 0 | WHERE THE CRAWDADS SING | Delia Owens | by Delia Owens | https://s1.nyt.com/du/books/images/9780735219090.jpg | 328 | 495 | https://www.amazon.com/Where-Crawdads-Sing-Delia-Owens/dp/0735219095?tag=NYTBS-20 | list(isbn10 = c(“0735219095”, “0735219117”, “0525640371”, “0593105419”), isbn13 = c(“9780735219090”, “9780735219113”, “9780525640370”, “9780593105412”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Where-Crawdads-Sing-Delia-Owens/dp/0735219095?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=WHERE+THE+CRAWDADS+SING&author=Delia+Owens”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780735219090”, “http://www.indiebound.org/book/9780735219090?aff=NYT”)) | nyt://book/053b4109-4555-5aa1-9b39-cc40549bcdf0 | ||||||
| 3 | 0 | 1 | 0 | 0 | 0316435570 | 9780316435574 | Little, Brown | In the sequel to “Winter in Paradise,” Irene Steele visits the island of St. John to get to the bottom of the mysterious life and death of her husband. | 0 | WHAT HAPPENS IN PARADISE | Elin Hilderbrand | by Elin Hilderbrand | https://s1.nyt.com/du/books/images/9780316435574.jpg | 319 | 495 | https://www.amazon.com/What-Happens-Paradise-Elin-Hilderbrand/dp/0316435570?tag=NYTBS-20 | list(isbn10 = c(“0316435570”, “0316426075”), isbn13 = c(“9780316435574”, “9780316426077”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/What-Happens-Paradise-Elin-Hilderbrand/dp/0316435570?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=WHAT+HAPPENS+IN+PARADISE&author=Elin+Hilderbrand”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780316435574”, “http://www.indiebound.org/book/9780316435574?aff=NYT”)) | nyt://book/8ba462d1-3a6a-5728-8922-532bbcf58680 | ||||||
| 4 | 0 | 1 | 0 | 0 | 1250313074 | 9781250313072 | Flatiron | After mysteriously surviving a multiple homicide, Galaxy Stern comes face to face with dark magic, murder and more at Yale University. | 0 | NINTH HOUSE | Leigh Bardugo | by Leigh Bardugo | https://s1.nyt.com/du/books/images/9781250313072.jpg | 325 | 495 | https://www.amazon.com/Ninth-House-Leigh-Bardugo/dp/1250313074?tag=NYTBS-20 | https://www.nytimes.com/2019/10/08/books/review/ninth-house-leigh-bardugo.html | list(isbn10 = c(“1250313074”, “1250266459”), isbn13 = c(“9781250313072”, “9781250266453”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Ninth-House-Leigh-Bardugo/dp/1250313074?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=NINTH+HOUSE&author=Leigh+Bardugo”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250313072”, “http://www.indiebound.org/book/9781250313072?aff=NYT”)) | nyt://book/65f94f17-7cfb-508e-99c4-ec09ead9948c | |||||
| 5 | 2 | 5 | 0 | 0 | 1982110562 | 9781982110567 | Scribner | Children with special talents are abducted and sequestered in an institution where the sinister staff seeks to extract their gifts through harsh methods. | 0 | THE INSTITUTE | Stephen King | by Stephen King | https://s1.nyt.com/du/books/images/9781982110567.jpg | 328 | 495 | https://www.amazon.com/Institute-Novel-Stephen-King/dp/1982110562?tag=NYTBS-20 | https://www.nytimes.com/2019/09/08/books/review-institute-stephen-king.html | list(isbn10 = c(“1982110562”, “1982110597”, “1508279071”, “1508279063”, “1432870122”), isbn13 = c(“9781982110567”, “9781982110598”, “9781508279075”, “9781508279068”, “9781432870126”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Institute-Novel-Stephen-King/dp/1982110562?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=THE+INSTITUTE&author=Stephen+King”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781982110567”, “http://www.indiebound.org/book/9781982110567?aff=NYT”)) | nyt://book/ef08eed0-f900-53fe-9764-da9152bd5e8f | |||||
| 6 | 1 | 3 | 0 | 0 | 0399590595 | 9780399590597 | One World | A young man who was gifted with a mysterious power becomes part of a war between slavers and the enslaved. | 0 | THE WATER DANCER | Ta-Nehisi Coates | by Ta-Nehisi Coates | https://s1.nyt.com/du/books/images/9780399590597.jpg | 326 | 495 | https://www.amazon.com/Water-Dancer-Oprahs-Book-Club/dp/0399590595?tag=NYTBS-20 | https://www.nytimes.com/2019/09/20/books/review-water-dancer-ta-nehisi-coates.html | list(isbn10 = c(“0399590595”, “0525494847”), isbn13 = c(“9780399590597”, “9780525494843”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Water-Dancer-Oprahs-Book-Club/dp/0399590595?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=THE+WATER+DANCER&author=Ta-Nehisi+Coates”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780399590597”, “http://www.indiebound.org/book/9780399590597?aff=NYT”)) | nyt://book/30d61b66-0e7d-582c-a3ab-ddce005d5361 | |||||
| 7 | 4 | 3 | 0 | 0 | 0062963678 | 9780062963673 | Harper | A sibling relationship is impacted when the family goes from poverty to wealth and back again over the course of many decades. | 0 | THE DUTCH HOUSE | Ann Patchett | by Ann Patchett | https://s1.nyt.com/du/books/images/9780062963673.jpg | 328 | 495 | https://www.amazon.com/Dutch-House-Novel-Ann-Patchett/dp/0062963678?tag=NYTBS-20 | https://www.nytimes.com/2019/09/21/books/review-dutch-house-ann-patchett.html | list(isbn10 = c(“0062963678”, “0062963694”), isbn13 = c(“9780062963673”, “9780062963697”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Dutch-House-Novel-Ann-Patchett/dp/0062963678?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=THE+DUTCH+HOUSE&author=Ann+Patchett”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780062963673”, “http://www.indiebound.org/book/9780062963673?aff=NYT”)) | nyt://book/0ad5db6c-4d15-5624-bef3-1385f93f78e2 | |||||
| 8 | 6 | 5 | 0 | 0 | 0385543786 | 9780385543781 | Nan A. Talese/Doubleday | In a sequel to “The Handmaid’s Tale,” old secrets bring three women together as the Republic of Gilead’s theocratic regime shows signs of decay. | 0 | THE TESTAMENTS | Margaret Atwood | by Margaret Atwood | https://s1.nyt.com/du/books/images/9780385543781.jpg | 326 | 495 | https://www.amazon.com/Testaments-Sequel-Handmaids-Tale/dp/0385543786?tag=NYTBS-20 | list(isbn10 = c(“0385543786”, “0385543794”, “0525590455”), isbn13 = c(“9780385543781”, “9780385543798”, “9780525590453”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Testaments-Sequel-Handmaids-Tale/dp/0385543786?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=THE+TESTAMENTS&author=Margaret+Atwood”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385543781”, “http://www.indiebound.org/book/9780385543781?aff=NYT”)) | nyt://book/e1e18717-04bb-51a2-942a-45743507535f | ||||||
| 9 | 0 | 1 | 0 | 0 | 039917950X | 9780399179501 | Delacorte | A prestigious New York lawyer learns that the life she constructed for her children and herself isn’t exactly what she thought it was. | 0 | CHILD’S PLAY | Danielle Steel | by Danielle Steel | https://s1.nyt.com/du/books/images/9780399179518.jpg | 326 | 495 | https://www.amazon.com/Childs-Play-Novel-Danielle-Steel-ebook/dp/B07MGDJT1N?tag=NYTBS-20 | list(isbn10 = c(“039917950X”, “0399179518”), isbn13 = c(“9780399179501”, “9780399179518”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Childs-Play-Novel-Danielle-Steel-ebook/dp/B07MGDJT1N?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=CHILD%27S+PLAY&author=Danielle+Steel”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780399179501”, “http://www.indiebound.org/book/9780399179501?aff=NYT”)) | nyt://book/7425ca98-5374-5a6c-8381-890b33710a6b | ||||||
| 10 | 0 | 1 | 0 | 0 | 0399562486 | 9780399562488 | Pamela Dorman/Viking | In Depression-era America, five women refuse to be cowed by men or convention as they deliver books throughout the mountains of Kentucky. | 0 | THE GIVER OF STARS | Jojo Moyes | by Jojo Moyes | https://s1.nyt.com/du/books/images/9780399562501.jpg | 328 | 495 | https://www.amazon.com/Giver-Stars-Novel-Jojo-Moyes/dp/0399562486?tag=NYTBS-20 | list(isbn10 = c(“0399562486”, “0399562508”), isbn13 = c(“9780399562488”, “9780399562501”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Giver-Stars-Novel-Jojo-Moyes/dp/0399562486?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=THE+GIVER+OF+STARS&author=Jojo+Moyes”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780399562488”, “http://www.indiebound.org/book/9780399562488?aff=NYT”)) | nyt://book/0365e66e-8090-5ec1-8d8c-2ed89027d374 | ||||||
| 11 | 5 | 2 | 0 | 0 | 0525536612 | 9780525536611 | Putnam | The 12th book in the Virgil Flowers series. A fight between university departments turns deadly. | 0 | BLOODY GENIUS | John Sandford | by John Sandford | https://s1.nyt.com/du/books/images/9780525536611.jpg | 328 | 495 | https://www.amazon.com/Bloody-Genius-Virgil-Flowers-Novel/dp/0525536612?tag=NYTBS-20 | list(isbn10 = “0525536612”, isbn13 = “9780525536611”) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Bloody-Genius-Virgil-Flowers-Novel/dp/0525536612?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=BLOODY+GENIUS&author=John+Sandford”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780525536611”, “http://www.indiebound.org/book/9780525536611?aff=NYT”)) | nyt://book/fea821b6-6392-50b8-b5ae-048621b34a82 | ||||||
| 12 | 7 | 3 | 0 | 0 | 1501190628 | 9781501190629 | Emily Bestler/Atria | Mexican cartels, ISIS and a possible pandemic bring Mitch Rapp back into action. | 0 | VINCE FLYNN: LETHAL AGENT | Kyle Mills | by Kyle Mills | https://s1.nyt.com/du/books/images/9781501190643.jpg | 326 | 495 | https://www.amazon.com/Lethal-Agent-Mitch-Rapp-Novel-ebook/dp/B07NBJSFFJ?tag=NYTBS-20 | list(isbn10 = c(“1501190628”, “1982140127”, “1501190644”, “1508287716”, “1508287708”), isbn13 = c(“9781501190629”, “9781982140120”, “9781501190643”, “9781508287711”, “9781508287704”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Lethal-Agent-Mitch-Rapp-Novel-ebook/dp/B07NBJSFFJ?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=VINCE+FLYNN%3A+LETHAL+AGENT&author=Kyle+Mills”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781501190629”, “http://www.indiebound.org/book/9781501190629?aff=NYT”)) | nyt://book/86e28126-9c5c-5a00-b21f-80352e72ca2d | ||||||
| 13 | 8 | 2 | 0 | 0 | 1250265703 | 9781250265708 | St. Martin’s | A 16-year-old, who sleeps with a concentration camp commandant in order to survive, is sentenced to a Siberian prison camp where she cares for the ill. | 0 | CILKA’S JOURNEY | Heather Morris | by Heather Morris | https://s1.nyt.com/du/books/images/9781250265708.jpg | 326 | 495 | https://www.amazon.com/Cilkas-Journey-Novel-Tattooist-Auschwitz/dp/1250265703?tag=NYTBS-20 | list(isbn10 = c(“1250265703”, “1250265797”), isbn13 = c(“9781250265708”, “9781250265791”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Cilkas-Journey-Novel-Tattooist-Auschwitz/dp/1250265703?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=CILKA%27S+JOURNEY&author=Heather+Morris”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250265708”, “http://www.indiebound.org/book/9781250265708?aff=NYT”)) | nyt://book/014cbbe5-9d31-59d6-9f09-dd39d04421a0 | ||||||
| 14 | 10 | 2 | 0 | 0 | 1538731339 | 9781538731338 | Grand Central | After disappearing for six days, a boy emerges from the woods with a voice in his head that sends him on a mission. | 0 | IMAGINARY FRIEND | Stephen Chbosky | by Stephen Chbosky | https://s1.nyt.com/du/books/images/9781538731338.jpg | 328 | 495 | https://www.amazon.com/Imaginary-Friend-Stephen-Chbosky/dp/1538731339?tag=NYTBS-20 | https://www.nytimes.com/2019/10/07/books/review/imaginary-friend-stephen-chbosky.html | list(isbn10 = “1538731339”, isbn13 = “9781538731338”) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Imaginary-Friend-Stephen-Chbosky/dp/1538731339?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=IMAGINARY+FRIEND&author=Stephen+Chbosky”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781538731338”, “http://www.indiebound.org/book/9781538731338?aff=NYT”)) | nyt://book/8458120f-fd20-5f6f-8c1d-3182a4a0d79e | |||||
| 15 | 13 | 6 | 0 | 0 | 1629996297 | 9781629996295 | Front Line | A traveler discovers mysteries hidden behind seven locked doors. | 0 | THE ORACLE | Jonathan Cahn | by Jonathan Cahn | https://s1.nyt.com/du/books/images/9781629996295.jpg | 330 | 488 | https://www.amazon.com/Oracle-Jubilean-Mysteries-Unveiled/dp/1629996297?tag=NYTBS-20 | list(isbn10 = c(“1629996297”, “1629996300”), isbn13 = c(“9781629996295”, “9781629996301”)) | list(name = c(“Amazon”, “Apple Books”, “Barnes and Noble”, “Local Booksellers”), url = c(“https://www.amazon.com/Oracle-Jubilean-Mysteries-Unveiled/dp/1629996297?tag=NYTBS-20”, “http://du-gae-books-dot-nyt-du-prd.appspot.com/buy?title=THE+ORACLE&author=Jonathan+Cahn”, “http://www.anrdoezrs.net/click-7990613-11819508?url=http%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781629996295”, “http://www.indiebound.org/book/9781629996295?aff=NYT”)) | nyt://book/94a69adb-1890-5c29-980d-daea1072a316 |
myurl2 <- "https://api.nytimes.com/svc/books/v3/lists/2019-10-26/hardcover-nonfiction.json?api-key=wl3OA7v4AV7cjxGya142nvRGGv46HdNG"
myresponse2 <- fromJSON(myurl2)
myresponse2$results$books %>% kable() %>% kable_styling() %>% scroll_box(width = "910px", height = "400px")
myurl3 <- "https://api.nytimes.com/svc/books/v3/reviews.json?author=Stephen+King&api-key=wl3OA7v4AV7cjxGya142nvRGGv46HdNG"
myresponse3 <- fromJSON(myurl3)
str(myresponse3)## List of 4
## $ status : chr "OK"
## $ copyright : chr "Copyright (c) 2019 The New York Times Company. All Rights Reserved."
## $ num_results: int 66
## $ results :'data.frame': 66 obs. of 9 variables:
## ..$ url : chr [1:66] "http://www.nytimes.com/2011/11/13/books/review/11-22-63-by-stephen-king-book-review.html" "http://www.nytimes.com/2011/10/31/books/stephen-kings-11-23-63-review.html" "http://www.nytimes.com/2004/01/04/books/the-quest-for-the-north-central-positronics.html" "http://www.nytimes.com/1993/10/24/books/in-short-fiction-284093.html" ...
## ..$ publication_dt: chr [1:66] "2011-11-13" "2011-10-31" "2004-01-04" "1993-10-24" ...
## ..$ byline : chr [1:66] "ERROL MORRIS" "JANET MASLIN" "ANDREW O'HEHIR" "RICHARD E. NICHOLLS" ...
## ..$ book_title : chr [1:66] "11/22/63" "11/22/63" "Wolves of the Calla" "Nightmares and Dreamscapes" ...
## ..$ book_author : chr [1:66] "Stephen King" "Stephen King" "Stephen King" "Stephen King" ...
## ..$ summary : chr [1:66] "Stephen King’s time traveler tries to undo some painful history." "Stephen King’s latest novel, “11/22/63,” tells of a schoolteacher who travels back to 1958 to alter history, an"| __truncated__ "" "" ...
## ..$ uuid : chr [1:66] "00000000-0000-0000-0000-000000000000" "00000000-0000-0000-0000-000000000000" "00000000-0000-0000-0000-000000000000" "00000000-0000-0000-0000-000000000000" ...
## ..$ uri : chr [1:66] "nyt://book/00000000-0000-0000-0000-000000000000" "nyt://book/00000000-0000-0000-0000-000000000000" "nyt://book/00000000-0000-0000-0000-000000000000" "nyt://book/00000000-0000-0000-0000-000000000000" ...
## ..$ isbn13 :List of 66
## .. ..$ : chr [1:12] "9780307951434" "9780606351461" "9781442344280" "9781442344303" ...
## .. ..$ : chr [1:12] "9780307951434" "9780606351461" "9781442344280" "9781442344303" ...
## .. ..$ : chr "9781848941137"
## .. ..$ : chr "9781441615299"
## .. ..$ : chr "9780375504396"
## .. ..$ : chr "9781848940833"
## .. ..$ : chr "9780816151776"
## .. ..$ : chr "9781598877427"
## .. ..$ : chr "9780670846504"
## .. ..$ : chr "9781439568200"
## .. ..$ : chr "9780451169518"
## .. ..$ : chr [1:8] "9781439192566" "9781439192597" "9781439192603" "9781441677112" ...
## .. ..$ : chr "9780671026073"
## .. ..$ : chr "9781416537816"
## .. ..$ : chr "9781568952611"
## .. ..$ : chr "9781451698855"
## .. ..$ : chr "9781451698855"
## .. ..$ : chr "9781781162644"
## .. ..$ : chr "9781476735474"
## .. ..$ : chr "9781476735474"
## .. ..$ : chr [1:6] "9781410473837" "9781442372764" "9781442372788" "9781476770383" ...
## .. ..$ : chr [1:6] "9781410473837" "9781442372764" "9781442372788" "9781476770383" ...
## .. ..$ : chr "9781416523352"
## .. ..$ : chr "9781416586654"
## .. ..$ : chr "9781416586654"
## .. ..$ : chr "9781416552963"
## .. ..$ : chr "9781416552963"
## .. ..$ : chr "9781416523352"
## .. ..$ : chr [1:8] "9781410469007" "9781442369788" "9781442371347" "9781442395404" ...
## .. ..$ : chr "9780896960763"
## .. ..$ : chr "9780670451937"
## .. ..$ : chr "9780670272662"
## .. ..$ : chr "9780670272662"
## .. ..$ : chr "9780670220267"
## .. ..$ : chr "9780670220267"
## .. ..$ : chr "9780385182447"
## .. ..$ : NULL
## .. ..$ : NULL
## .. ..$ : chr "9780670813643"
## .. ..$ : chr "9780670813643"
## .. ..$ : chr "9780399133145"
## .. ..$ : chr "9780399133145"
## .. ..$ : NULL
## .. ..$ : NULL
## .. ..$ : chr "9780452267404"
## .. ..$ : chr "9780670839537"
## .. ..$ : chr "9780670855032"
## .. ..$ : chr "9780670858699"
## .. ..$ : chr "9780684853505"
## .. ..$ : chr "9780684867625"
## .. ..$ : chr "9780684867625"
## .. ..$ : chr [1:16] "9780606222549" "9780606231862" "9780671024253" "9780684853529" ...
## .. ..$ : chr [1:16] "9780606222549" "9780606231862" "9780671024253" "9780684853529" ...
## .. ..$ : chr "9780743211383"
## .. ..$ : chr "9780743211383"
## .. ..$ : chr "9780743211376"
## .. ..$ : chr "9780743211376"
## .. ..$ : chr "9781880418598"
## .. ..$ : chr "9780743292337"
## .. ..$ : chr "9780743292337"
## .. ..$ : chr [1:6] "9781410479501" "9781442384347" "9781501100079" "9781501100123" ...
## .. ..$ : chr [1:5] "9781410489906" "9781501129742" "9781501134142" "9781501134159" ...
## .. ..$ : chr "9781501180989"
## .. ..$ : chr "9781982102319"
## .. ..$ : chr "9781982110567"
## .. ..$ : chr "9781982110567"df <- fromJSON(myurl3, flatten = TRUE) %>% data.frame()
str(df)## 'data.frame': 66 obs. of 12 variables:
## $ status : Factor w/ 1 level "OK": 1 1 1 1 1 1 1 1 1 1 ...
## $ copyright : Factor w/ 1 level "Copyright (c) 2019 The New York Times Company. All Rights Reserved.": 1 1 1 1 1 1 1 1 1 1 ...
## $ num_results : int 66 66 66 66 66 66 66 66 66 66 ...
## $ results.url : chr "http://www.nytimes.com/2011/11/13/books/review/11-22-63-by-stephen-king-book-review.html" "http://www.nytimes.com/2011/10/31/books/stephen-kings-11-23-63-review.html" "http://www.nytimes.com/2004/01/04/books/the-quest-for-the-north-central-positronics.html" "http://www.nytimes.com/1993/10/24/books/in-short-fiction-284093.html" ...
## $ results.publication_dt: chr "2011-11-13" "2011-10-31" "2004-01-04" "1993-10-24" ...
## $ results.byline : chr "ERROL MORRIS" "JANET MASLIN" "ANDREW O'HEHIR" "RICHARD E. NICHOLLS" ...
## $ results.book_title : chr "11/22/63" "11/22/63" "Wolves of the Calla" "Nightmares and Dreamscapes" ...
## $ results.book_author : chr "Stephen King" "Stephen King" "Stephen King" "Stephen King" ...
## $ results.summary : chr "Stephen King’s time traveler tries to undo some painful history." "Stephen King’s latest novel, “11/22/63,” tells of a schoolteacher who travels back to 1958 to alter history, an"| __truncated__ "" "" ...
## $ results.uuid : chr "00000000-0000-0000-0000-000000000000" "00000000-0000-0000-0000-000000000000" "00000000-0000-0000-0000-000000000000" "00000000-0000-0000-0000-000000000000" ...
## $ results.uri : chr "nyt://book/00000000-0000-0000-0000-000000000000" "nyt://book/00000000-0000-0000-0000-000000000000" "nyt://book/00000000-0000-0000-0000-000000000000" "nyt://book/00000000-0000-0000-0000-000000000000" ...
## $ results.isbn13 :List of 66
## ..$ : chr "9780307951434" "9780606351461" "9781442344280" "9781442344303" ...
## ..$ : chr "9780307951434" "9780606351461" "9781442344280" "9781442344303" ...
## ..$ : chr "9781848941137"
## ..$ : chr "9781441615299"
## ..$ : chr "9780375504396"
## ..$ : chr "9781848940833"
## ..$ : chr "9780816151776"
## ..$ : chr "9781598877427"
## ..$ : chr "9780670846504"
## ..$ : chr "9781439568200"
## ..$ : chr "9780451169518"
## ..$ : chr "9781439192566" "9781439192597" "9781439192603" "9781441677112" ...
## ..$ : chr "9780671026073"
## ..$ : chr "9781416537816"
## ..$ : chr "9781568952611"
## ..$ : chr "9781451698855"
## ..$ : chr "9781451698855"
## ..$ : chr "9781781162644"
## ..$ : chr "9781476735474"
## ..$ : chr "9781476735474"
## ..$ : chr "9781410473837" "9781442372764" "9781442372788" "9781476770383" ...
## ..$ : chr "9781410473837" "9781442372764" "9781442372788" "9781476770383" ...
## ..$ : chr "9781416523352"
## ..$ : chr "9781416586654"
## ..$ : chr "9781416586654"
## ..$ : chr "9781416552963"
## ..$ : chr "9781416552963"
## ..$ : chr "9781416523352"
## ..$ : chr "9781410469007" "9781442369788" "9781442371347" "9781442395404" ...
## ..$ : chr "9780896960763"
## ..$ : chr "9780670451937"
## ..$ : chr "9780670272662"
## ..$ : chr "9780670272662"
## ..$ : chr "9780670220267"
## ..$ : chr "9780670220267"
## ..$ : chr "9780385182447"
## ..$ : NULL
## ..$ : NULL
## ..$ : chr "9780670813643"
## ..$ : chr "9780670813643"
## ..$ : chr "9780399133145"
## ..$ : chr "9780399133145"
## ..$ : NULL
## ..$ : NULL
## ..$ : chr "9780452267404"
## ..$ : chr "9780670839537"
## ..$ : chr "9780670855032"
## ..$ : chr "9780670858699"
## ..$ : chr "9780684853505"
## ..$ : chr "9780684867625"
## ..$ : chr "9780684867625"
## ..$ : chr "9780606222549" "9780606231862" "9780671024253" "9780684853529" ...
## ..$ : chr "9780606222549" "9780606231862" "9780671024253" "9780684853529" ...
## ..$ : chr "9780743211383"
## ..$ : chr "9780743211383"
## ..$ : chr "9780743211376"
## ..$ : chr "9780743211376"
## ..$ : chr "9781880418598"
## ..$ : chr "9780743292337"
## ..$ : chr "9780743292337"
## ..$ : chr "9781410479501" "9781442384347" "9781501100079" "9781501100123" ...
## ..$ : chr "9781410489906" "9781501129742" "9781501134142" "9781501134159" ...
## ..$ : chr "9781501180989"
## ..$ : chr "9781982102319"
## ..$ : chr "9781982110567"
## ..$ : chr "9781982110567"df1 <- select(df, results.book_title, results.url, results.book_author, results.summary, results.publication_dt)
df1 %>% kable() %>% kable_styling() %>% scroll_box(width = "910px", height = "400px")| results.book_title | results.url | results.book_author | results.summary | results.publication_dt |
|---|---|---|---|---|
| 11/22/63 | http://www.nytimes.com/2011/11/13/books/review/11-22-63-by-stephen-king-book-review.html | Stephen King | Stephen King’s time traveler tries to undo some painful history. | 2011-11-13 |
| 11/22/63 | http://www.nytimes.com/2011/10/31/books/stephen-kings-11-23-63-review.html | 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. | 2011-10-31 |
| Wolves of the Calla | http://www.nytimes.com/2004/01/04/books/the-quest-for-the-north-central-positronics.html | Stephen King | 2004-01-04 | |
| Nightmares and Dreamscapes | http://www.nytimes.com/1993/10/24/books/in-short-fiction-284093.html | Stephen King | 1993-10-24 | |
| Black House | http://www.nytimes.com/2001/11/04/books/books-in-brief-fiction-poetry-851302.html | Stephen King | 2001-11-04 | |
| The Stand | http://www.nytimes.com/1990/05/13/books/armageddon-complete-and-uncut.html | Stephen King | 1990-05-13 | |
| Four Past Midnight | http://www.nytimes.com/1990/09/02/books/scared-but-safe.html | Stephen King | 1990-09-02 | |
| Needful Things | http://www.nytimes.com/1991/10/20/books/l-defending-stephen-king-075091.html | Stephen King | 1991-10-20 | |
| Gerald’s Game | http://www.nytimes.com/1992/06/29/books/books-of-the-times-to-be-read-in-daylight-away-from-hungry-dogs.html | Stephen King | 1992-06-29 | |
| Everything’s Eventual : 14 Dark Tales | http://www.nytimes.com/2002/04/14/books/the-horror-etc.html | Stephen King | 2002-04-14 | |
| It | http://www.nytimes.com/1986/08/21/books/books-of-the-times-547486.html | Stephen King | 1986-08-21 | |
| Full Dark, No Stars | http://www.nytimes.com/2010/11/28/books/review/Rafferty-t.html | Stephen King | 2010-11-28 | |
| Bag of Bones | http://www.nytimes.com/1998/09/27/books/familiar-terrors.html | Stephen King | 1998-09-27 | |
| Everything’s Eventual : 14 Dark Tales | http://www.nytimes.com/2002/03/18/books/books-of-the-times-storytelling-mogul-decides-to-sweep-out-odds-and-ends.html | Stephen King | 2002-03-18 | |
| Rose Madder | http://www.nytimes.com/1995/07/02/books/in-short-fiction-077895.html | Stephen King | 1995-07-02 | |
| Doctor Sleep | http://www.nytimes.com/2013/09/16/books/doctor-sleep-is-stephen-kings-sequel-to-the-shining.html | Stephen King | In “Doctor Sleep” Stephen King offers a sequel to “The Shining.” | 2013-09-16 |
| Doctor Sleep | http://www.nytimes.com/2013/09/22/books/review/stephen-kings-shining-sequel-doctor-sleep.html | 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.” | 2013-09-22 |
| Joyland | http://www.nytimes.com/2013/06/23/books/review/joyland-by-stephen-king.html | Stephen King | Stephen King’s lovelorn narrator takes a summer job at a haunted Southern amusement park. | 2013-06-23 |
| Under the Dome | http://www.nytimes.com/2009/11/08/books/review/JParker-t.html | 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. | 2009-11-08 |
| Under the Dome | http://www.nytimes.com/2009/11/12/books/12book.html | Stephen King | “Under the Dome” gravely threatens Stephen King’s status as a mere chart-busting pop cultural phenomenon. | 2009-11-12 |
| Revival | http://www.nytimes.com/2014/11/14/books/stephen-kings-revival.html | 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. | 2014-11-14 |
| Revival | http://www.nytimes.com/2014/11/23/books/review/stephen-kings-revival.html | 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. | 2014-11-23 |
| Lisey’s Story | http://www.nytimes.com/2006/11/12/books/review/Windolf.t.html | Stephen King | When Stephen King really wants to put a scare into you, he brings on his most fearsome monster of all, the writer. | 2006-11-12 |
| Just After Sunset | http://www.nytimes.com/2008/11/05/books/05masl.html | Stephen King | Everyday situations became open portals to fantasy and horror in Stephen King’s succinct, fast-moving new collection. | 2008-11-05 |
| Just After Sunset | http://www.nytimes.com/2008/11/23/books/review/Taylor-t.html | Stephen King | A new short-story collection takes Stephen King back to the form that gave him his seat-of-the-pants start. | 2008-11-23 |
| Duma Key | http://www.nytimes.com/2008/01/21/books/21maslin.html | 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. | 2008-01-21 |
| Duma Key | http://www.nytimes.com/2008/03/02/books/review/Campbell-t.html | Stephen King | In Stephen King’s new novel, a man recuperating in the Florida Keys begins to paint, with sinister results. | 2008-03-02 |
| Lisey’s Story | http://www.nytimes.com/2006/10/23/books/23masl.html | Stephen King | In his new book, Stephen King delivers his version of Joycean wordplay, idiosyncrasy, voluptuousness and stubborn, obsessive chronology. | 2006-10-23 |
| Mr. Mercedes | http://www.nytimes.com/2014/06/08/books/review/stephen-kings-mr-mercedes.html | Stephen King | With one eye on Philip Marlowe, Stephen King takes a crack at the detective novel. | 2014-06-08 |
| Stephen King’s Danse Macabre | http://www.nytimes.com/1981/05/10/books/scare-tactics.html | Stephen King | 1981-05-10 | |
| Cujo | http://www.nytimes.com/1981/08/14/books/books-of-the-times-books-of-the-times.html | Stephen King | 1981-08-14 | |
| Different Seasons | http://www.nytimes.com/1982/08/11/books/books-of-the-times-074639.html | Stephen King | 1982-08-11 | |
| Different Seasons | http://www.nytimes.com/1982/08/29/books/horror-writer-s-holiday.html | Stephen King | 1982-08-29 | |
| Christine | http://www.nytimes.com/1983/04/03/books/the-other-woman-was-a-car.html | Stephen King | 1983-04-03 | |
| Christine | http://www.nytimes.com/1983/04/12/books/books-of-the-times-093019.html | Stephen King | 1983-04-12 | |
| Pet Sematary | http://www.nytimes.com/1983/10/21/books/books-of-the-times-243538.html | Stephen King | 1983-10-21 | |
| Skeleton Crew | http://www.nytimes.com/1985/06/09/books/don-t-turn-your-back-on-this-book.html | Stephen King | 1985-06-09 | |
| The Eyes of the Dragon | http://www.nytimes.com/1987/02/22/books/what-the-wicked-magician-did.html | Stephen King | 1987-02-22 | |
| Misery | http://www.nytimes.com/1987/05/31/books/summer-reading-sheldon-gets-the-ax.html | Stephen King | 1987-05-31 | |
| Misery | http://www.nytimes.com/1987/06/08/books/books-of-the-times-301987.html | Stephen King | 1987-06-08 | |
| The Tommyknockers | http://www.nytimes.com/1987/11/05/books/books-of-the-times-950387.html | Stephen King | 1987-11-05 | |
| The Tommyknockers | http://www.nytimes.com/1987/12/20/books/not-with-a-bang-but-an-eeeooooarrrhmm.html | Stephen King | 1987-12-20 | |
| The Dark Half | http://www.nytimes.com/1989/10/23/books/books-of-the-times-from-stephen-king-a-writer-s-demon.html | Stephen King | 1989-10-23 | |
| The Dark Half | http://www.nytimes.com/1989/10/29/books/his-alter-ego-is-a-killer.html | Stephen King | 1989-10-29 | |
| The Waste Lands: The Dark Tower Book III | http://www.nytimes.com/1991/09/29/books/avaunt-thee-recreant-cyborg.html | Stephen King | 1991-09-29 | |
| Needful Things: The Last Castle Rock Story | http://www.nytimes.com/1991/10/03/books/books-of-the-times-turning-favors-into-catastrophe.html | Stephen King | 1991-10-03 | |
| Insomnia,Stephen King Library Ed. | http://www.nytimes.com/1994/10/06/books/books-of-the-times-lack-of-sleep-the-least-of-his-problems.html | Stephen King | 1994-10-06 | |
| Rose Madder | http://www.nytimes.com/1995/06/26/books/book-review-a-punch-in-the-nose-then-a-new-life-begins.html | Stephen King | 1995-06-26 | |
| Bag of Bones | http://www.nytimes.com/1998/09/21/books/books-of-the-times-death-terror-and-writer-s-block.html | Stephen King | 1998-09-21 | |
| The Girl Who Loved Tom Gordon : A Novel | http://www.nytimes.com/1999/04/15/books/books-of-the-times-a-modern-fairy-tale-of-the-dark-north-woods.html | Stephen King | 1999-04-15 | |
| The Girl Who Loved Tom Gordon : A Novel | http://www.nytimes.com/1999/05/16/books/books-in-brief-fiction-583618.html | Stephen King | 1999-05-16 | |
| On Writing: a Memoir of the Craft | http://www.nytimes.com/2000/10/05/books/books-of-the-times-how-to-write-if-you-re-stephen-king.html | Stephen King | 2000-10-05 | |
| On Writing: a Memoir of the Craft | http://www.nytimes.com/2000/10/08/books/making-it.html | Stephen King | 2000-10-08 | |
| Dreamcatcher | http://www.nytimes.com/2001/03/15/books/books-of-the-times-a-fateful-step-off-a-curb-and-into-alien-territory.html | Stephen King | 2001-03-15 | |
| Dreamcatcher | http://www.nytimes.com/2001/04/15/books/weasel-from-another-planet.html | Stephen King | 2001-04-15 | |
| From a Buick 8 | http://www.nytimes.com/2002/09/23/books/books-of-the-times-cruising-the-dark-side-forget-about-seat-belts.html | Stephen King | 2002-09-23 | |
| From a Buick 8 | http://www.nytimes.com/2002/09/29/books/not-your-father-s-roadmaster.html | Stephen King | 2002-09-29 | |
| The Dark Tower VI | http://www.nytimes.com/2004/06/20/books/books-in-brief-fiction-937851.html | Stephen King | 2004-06-20 | |
| Cell | http://www.nytimes.com/2006/01/23/books/23masl.html | Stephen King | 2006-01-23 | |
| Cell | http://www.nytimes.com/2006/02/05/books/review/05itzkoff.html | Stephen King | 2006-02-05 | |
| Finders Keepers | http://www.nytimes.com/2015/05/31/books/review/stephen-kings-finders-keepers.html | Stephen King | Laura Lippman reviews Stephen King’s “Finders Keepers,” the second entry in a planned trilogy that began with “Mr. Mercedes.” | 2015-05-31 |
| End of Watch | http://www.nytimes.com/2016/06/12/books/review/stephen-kings-end-of-watch.html | Stephen King | A retired police detective sees the return of his nemesis in this suspense story with a supernatural twist. | 2016-06-12 |
| The Outsider | https://www.nytimes.com/2018/05/22/books/review/outsider-stephen-king.html | Stephen King | “The Outsider” starts out as a routine police procedural but before long transforms into something much more sinister. | 2018-05-22 |
| Elevation | https://www.nytimes.com/2018/10/26/books/review/stephen-king-elevation.html | 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. | 2018-10-26 |
| The Institute | https://www.nytimes.com/2019/09/08/books/review-institute-stephen-king.html | 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. | 2019-09-08 |
| The Institute | https://www.nytimes.com/2019/09/10/books/review/stephen-king-the-institute.html | 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. | 2019-09-10 |