Overview

In this project we explore how to connect to an API. We specifically connect to the New York Times API to request the latest list of best-selling books. Ideally, we want to receive our data from the API in JSON format. Once stored locally in our machine, it’ll be converted to a flat-file. In this case a dataframe. We want the dataframe to be “tidy”, and therefore will execute some functions to unnest lists found in the json data.

In this project we use the following library packages:

Connecting to API

In this section we set up our base url to make our initial request to the API. We make use of paste0() to seamlessly concatenate our private New York Times Developer API key. With the use of GET() we send our request and containerize it. Once we have our data locally, we check the status of the response by using status_code(). A 200 code means we successfully connected. Additionally, we use warn_for_status() to alert us of a failed connection; this function only executes if the connection is unsuccessful.

base_url <- "https://api.nytimes.com/svc/books/v3/lists/current/culture.json?api-key="
r <- GET(paste0(base_url, api_key)) #get name of best sellers list
status_code(r)
## [1] 200
warn_for_status(r)

Retrieving API Data

Next we use content() to retrieve the information stored in our variable. Second, we use fromJSON() to convert from a JSON object to an R object. Once an R object we can navigate the hierarchy until we reach our list of books [newdata$results$books]. We combined the JSON to R conversion with as.data.frame() to get our data into a “flat” state.

However, our dataframe has 2 complex columns. The columns have dataframes as values.

data <- content(r, as="text")
newdata <- fromJSON(data, flatten=TRUE)
books_df <- as.data.frame(newdata$results$books)

knitr::kable(head(books_df[, 1:26]), "simple")
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 0 0 0 1455539740 9781455539741 Grand Central/Melcher Media The libretto of the Grammy-, Tony- and Pulitzer Prize-winning musical, annotated by its creator, along with backstage photos,interviews and a production history. 0.00 HAMILTON: THE REVOLUTION Lin-Manuel Miranda and Jeremy McCarter by Lin-Manuel Miranda and Jeremy McCarter https://storage.googleapis.com/du-prd/books/images/9781455567539.jpg 330 398 http://www.amazon.com/Hamilton-The-Revolution-Lin-Manuel-Miranda-ebook/dp/B015X056G4?tag=NYTBSREV-20 1455539740 , 1455567531 , 1478913649 , 1495069885 , 9781455539741, 9781455567539, 9781478913641, 9781495069888 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , http://www.amazon.com/Hamilton-The-Revolution-Lin-Manuel-Miranda-ebook/dp/B015X056G4?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781455539741?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781455539741 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FHAMILTON%25253A%252BTHE%252BREVOLUTION%252FLin-Manuel%252BMiranda%252Band%252BJeremy%252BMcCarter%252F9781455539741&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DHAMILTON%25253A%252BTHE%252BREVOLUTION%252BLin-Manuel%252BMiranda%252Band%252BJeremy%252BMcCarter, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781455539741&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DHAMILTON%253A%2BTHE%2BREVOLUTION , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781455539741%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DHAMILTON%253A%2BTHE%2BREVOLUTION%2BLin-Manuel%2BMiranda%2Band%2BJeremy%2BMcCarter%26aff%3DNYT nyt://book/56194ce1-3f36-5e94-82df-af4b0e208936
2 0 0 0 0 0399588175 9780399588174 Spiegel & Grau A memoir about growing up in South Africa by the comedian, now the host of “The Daily Show,” whose parents were in an illegal (under apartheid) interracial relationship. 0.00 BORN A CRIME Trevor Noah by Trevor Noah https://storage.googleapis.com/du-prd/books/images/9780399588181.jpg 326 495 https://www.amazon.com/Born-Crime-Stories-African-Childhood-ebook/dp/B01DHWACVY?tag=NYTBSREV-20 0399588175 , 0399588183 , 1531865038 , 1531865046 , 0399588191 , 9780399588174, 9780399588181, 9781531865030, 9781531865047, 9780399588198 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/Born-Crime-Stories-African-Childhood-ebook/dp/B01DHWACVY?tag=NYTBSREV-20 , https://goto.applebooks.apple/9780399588174?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780399588174 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FBORN%252BA%252BCRIME%252FTrevor%252BNoah%252F9780399588174&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DBORN%252BA%252BCRIME%252BTrevor%252BNoah, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9780399588174&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DBORN%2BA%2BCRIME , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9780399588174%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DBORN%2BA%2BCRIME%2BTrevor%2BNoah%26aff%3DNYT nyt://book/f6f9b274-6e97-51e2-b784-bd71d0dd21f6
3 0 0 0 0 1455565385 9781455565382 Grand Central An oral history of the show, based on extensive interviews with Jon Stewart and others. 0.00 THE DAILY SHOW (THE BOOK) Chris Smith by Chris Smith https://storage.googleapis.com/du-prd/books/images/9781455565382.jpg 327 495 https://www.amazon.com/Daily-Show-Book-History-Correspondents/dp/1455565385?tag=NYTBSREV-20 https://www.nytimes.com/2016/12/01/books/review/daily-show-oral-history-chris-smith.html 1455565385 , 1455565350 , 9781455565382, 9781455565351 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/Daily-Show-Book-History-Correspondents/dp/1455565385?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781455565382?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781455565382 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FTHE%252BDAILY%252BSHOW%252B%252528THE%252BBOOK%252529%252FChris%252BSmith%252F9781455565382&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DTHE%252BDAILY%252BSHOW%252B%252528THE%252BBOOK%252529%252BChris%252BSmith, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781455565382&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DTHE%2BDAILY%2BSHOW%2B%2528THE%2BBOOK%2529 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781455565382%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DTHE%2BDAILY%2BSHOW%2B%2528THE%2BBOOK%2529%2BChris%2BSmith%26aff%3DNYT nyt://book/36699959-1f8e-54a1-a8fb-c3ec4fc583cc
4 0 0 0 0 0062571370 9780062571373 HarperDesign Filmmaking secrets, photography and artwork from “Fantastic Beasts and Where to Find Them,” written by J. K. Rowling. 0.00 THE CASE OF BEASTS Mark Salisbury by Mark Salisbury https://storage.googleapis.com/du-prd/books/images/9780062571373.jpg 330 389 https://www.amazon.com/Case-Beasts-Explore-Wizardry-Fantastic/dp/0062571370?tag=NYTBSREV-20 0062571370 , 9780062571373 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , https://www.amazon.com/Case-Beasts-Explore-Wizardry-Fantastic/dp/0062571370?tag=NYTBSREV-20 , https://goto.applebooks.apple/9780062571373?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780062571373 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FTHE%252BCASE%252BOF%252BBEASTS%252FMark%252BSalisbury%252F9780062571373&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DTHE%252BCASE%252BOF%252BBEASTS%252BMark%252BSalisbury, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9780062571373&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DTHE%2BCASE%2BOF%2BBEASTS , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9780062571373%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DTHE%2BCASE%2BOF%2BBEASTS%2BMark%2BSalisbury%26aff%3DNYT nyt://book/c086fc7a-e541-50cb-b2c6-c2a697cbbca0
5 0 0 0 0 1250058902 9781250058904 St. Martin’s Photographs and interviews from the creator of the blog and the book “Humans of New York.” 0.00 HUMANS OF NEW YORK: STORIES Brandon Stanton by Brandon Stanton https://storage.googleapis.com/du-prd/books/images/9781250058904.jpg 330 422 http://www.amazon.com/Humans-New-York-Brandon-Stanton/dp/1250058902?tag=NYTBSREV-20 1250058902 , 9781250058904 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , http://www.amazon.com/Humans-New-York-Brandon-Stanton/dp/1250058902?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781250058904?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250058904 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FHUMANS%252BOF%252BNEW%252BYORK%25253A%252BSTORIES%252FBrandon%252BStanton%252F9781250058904&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DHUMANS%252BOF%252BNEW%252BYORK%25253A%252BSTORIES%252BBrandon%252BStanton, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781250058904&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DHUMANS%2BOF%2BNEW%2BYORK%253A%2BSTORIES , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781250058904%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DHUMANS%2BOF%2BNEW%2BYORK%253A%2BSTORIES%2BBrandon%2BStanton%26aff%3DNYT nyt://book/bb67f8cc-7a34-55ad-a03b-f10f64e9d900
6 0 0 0 0 0062316095 9780062316097 Harper How Homo sapiens became Earth’s dominant species. 0.00 SAPIENS Yuval Noah Harari by Yuval Noah Harari https://storage.googleapis.com/du-prd/books/images/9780062316097.jpg 128 192 http://www.amazon.com/Sapiens-A-Brief-History-Humankind-ebook/dp/B00ICN066A?tag=NYTBSREV-20 0062316095 , 0062316109 , 0062796232 , 1494576902 , 0062316117 , 1494506904 , 1494556901 , 1473523788 , 1538456583 , 1538456605 , 1538456591 , 9780062316097, 9780062316103, 9780062796233, 9781494576905, 9780062316110, 9781494506902, 9781494556907, 9781473523784, 9781538456583, 9781538456606, 9781538456590 Amazon , Apple Books , Barnes and Noble , Books-A-Million , Bookshop , IndieBound , http://www.amazon.com/Sapiens-A-Brief-History-Humankind-ebook/dp/B00ICN066A?tag=NYTBSREV-20 , https://goto.applebooks.apple/9780062316097?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780062316097 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FSAPIENS%252FYuval%252BNoah%252BHarari%252F9780062316097&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DSAPIENS%252BYuval%252BNoah%252BHarari, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9780062316097&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DSAPIENS , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9780062316097%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DSAPIENS%2BYuval%2BNoah%2BHarari%26aff%3DNYT nyt://book/6321e78d-5215-5c51-bcea-79cfffbc3db9

Tidying Data

The final task is to tidy our dataframe. In this case we chose to pivot wider, however, pivot longer can also be done. For sake of this project we pivot wider to reduce the number of observations. We pipe the unnest_wider function for each complex column. The result is a fully flat file.

final_df <- books_df |>
  unnest_wider(isbns) |>
  unnest_wider(buy_links)

knitr::kable(head(final_df[, 1:28]), "simple")
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 isbn10 isbn13 name url book_uri
1 0 0 0 0 1455539740 9781455539741 Grand Central/Melcher Media The libretto of the Grammy-, Tony- and Pulitzer Prize-winning musical, annotated by its creator, along with backstage photos,interviews and a production history. 0.00 HAMILTON: THE REVOLUTION Lin-Manuel Miranda and Jeremy McCarter by Lin-Manuel Miranda and Jeremy McCarter https://storage.googleapis.com/du-prd/books/images/9781455567539.jpg 330 398 http://www.amazon.com/Hamilton-The-Revolution-Lin-Manuel-Miranda-ebook/dp/B015X056G4?tag=NYTBSREV-20 1455539740, 1455567531, 1478913649, 1495069885 9781455539741, 9781455567539, 9781478913641, 9781495069888 Amazon , Apple Books , Barnes and Noble, Books-A-Million , Bookshop , IndieBound http://www.amazon.com/Hamilton-The-Revolution-Lin-Manuel-Miranda-ebook/dp/B015X056G4?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781455539741?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781455539741 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FHAMILTON%25253A%252BTHE%252BREVOLUTION%252FLin-Manuel%252BMiranda%252Band%252BJeremy%252BMcCarter%252F9781455539741&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DHAMILTON%25253A%252BTHE%252BREVOLUTION%252BLin-Manuel%252BMiranda%252Band%252BJeremy%252BMcCarter, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781455539741&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DHAMILTON%253A%2BTHE%2BREVOLUTION , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781455539741%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DHAMILTON%253A%2BTHE%2BREVOLUTION%2BLin-Manuel%2BMiranda%2Band%2BJeremy%2BMcCarter%26aff%3DNYT nyt://book/56194ce1-3f36-5e94-82df-af4b0e208936
2 0 0 0 0 0399588175 9780399588174 Spiegel & Grau A memoir about growing up in South Africa by the comedian, now the host of “The Daily Show,” whose parents were in an illegal (under apartheid) interracial relationship. 0.00 BORN A CRIME Trevor Noah by Trevor Noah https://storage.googleapis.com/du-prd/books/images/9780399588181.jpg 326 495 https://www.amazon.com/Born-Crime-Stories-African-Childhood-ebook/dp/B01DHWACVY?tag=NYTBSREV-20 0399588175, 0399588183, 1531865038, 1531865046, 0399588191 9780399588174, 9780399588181, 9781531865030, 9781531865047, 9780399588198 Amazon , Apple Books , Barnes and Noble, Books-A-Million , Bookshop , IndieBound https://www.amazon.com/Born-Crime-Stories-African-Childhood-ebook/dp/B01DHWACVY?tag=NYTBSREV-20 , https://goto.applebooks.apple/9780399588174?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780399588174 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FBORN%252BA%252BCRIME%252FTrevor%252BNoah%252F9780399588174&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DBORN%252BA%252BCRIME%252BTrevor%252BNoah, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9780399588174&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DBORN%2BA%2BCRIME , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9780399588174%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DBORN%2BA%2BCRIME%2BTrevor%2BNoah%26aff%3DNYT nyt://book/f6f9b274-6e97-51e2-b784-bd71d0dd21f6
3 0 0 0 0 1455565385 9781455565382 Grand Central An oral history of the show, based on extensive interviews with Jon Stewart and others. 0.00 THE DAILY SHOW (THE BOOK) Chris Smith by Chris Smith https://storage.googleapis.com/du-prd/books/images/9781455565382.jpg 327 495 https://www.amazon.com/Daily-Show-Book-History-Correspondents/dp/1455565385?tag=NYTBSREV-20 https://www.nytimes.com/2016/12/01/books/review/daily-show-oral-history-chris-smith.html 1455565385, 1455565350 9781455565382, 9781455565351 Amazon , Apple Books , Barnes and Noble, Books-A-Million , Bookshop , IndieBound https://www.amazon.com/Daily-Show-Book-History-Correspondents/dp/1455565385?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781455565382?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781455565382 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FTHE%252BDAILY%252BSHOW%252B%252528THE%252BBOOK%252529%252FChris%252BSmith%252F9781455565382&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DTHE%252BDAILY%252BSHOW%252B%252528THE%252BBOOK%252529%252BChris%252BSmith, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781455565382&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DTHE%2BDAILY%2BSHOW%2B%2528THE%2BBOOK%2529 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781455565382%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DTHE%2BDAILY%2BSHOW%2B%2528THE%2BBOOK%2529%2BChris%2BSmith%26aff%3DNYT nyt://book/36699959-1f8e-54a1-a8fb-c3ec4fc583cc
4 0 0 0 0 0062571370 9780062571373 HarperDesign Filmmaking secrets, photography and artwork from “Fantastic Beasts and Where to Find Them,” written by J. K. Rowling. 0.00 THE CASE OF BEASTS Mark Salisbury by Mark Salisbury https://storage.googleapis.com/du-prd/books/images/9780062571373.jpg 330 389 https://www.amazon.com/Case-Beasts-Explore-Wizardry-Fantastic/dp/0062571370?tag=NYTBSREV-20 0062571370 9780062571373 Amazon , Apple Books , Barnes and Noble, Books-A-Million , Bookshop , IndieBound https://www.amazon.com/Case-Beasts-Explore-Wizardry-Fantastic/dp/0062571370?tag=NYTBSREV-20 , https://goto.applebooks.apple/9780062571373?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780062571373 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FTHE%252BCASE%252BOF%252BBEASTS%252FMark%252BSalisbury%252F9780062571373&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DTHE%252BCASE%252BOF%252BBEASTS%252BMark%252BSalisbury, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9780062571373&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DTHE%2BCASE%2BOF%2BBEASTS , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9780062571373%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DTHE%2BCASE%2BOF%2BBEASTS%2BMark%2BSalisbury%26aff%3DNYT nyt://book/c086fc7a-e541-50cb-b2c6-c2a697cbbca0
5 0 0 0 0 1250058902 9781250058904 St. Martin’s Photographs and interviews from the creator of the blog and the book “Humans of New York.” 0.00 HUMANS OF NEW YORK: STORIES Brandon Stanton by Brandon Stanton https://storage.googleapis.com/du-prd/books/images/9781250058904.jpg 330 422 http://www.amazon.com/Humans-New-York-Brandon-Stanton/dp/1250058902?tag=NYTBSREV-20 1250058902 9781250058904 Amazon , Apple Books , Barnes and Noble, Books-A-Million , Bookshop , IndieBound http://www.amazon.com/Humans-New-York-Brandon-Stanton/dp/1250058902?tag=NYTBSREV-20 , https://goto.applebooks.apple/9781250058904?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250058904 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FHUMANS%252BOF%252BNEW%252BYORK%25253A%252BSTORIES%252FBrandon%252BStanton%252F9781250058904&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DHUMANS%252BOF%252BNEW%252BYORK%25253A%252BSTORIES%252BBrandon%252BStanton, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9781250058904&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DHUMANS%2BOF%2BNEW%2BYORK%253A%2BSTORIES , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9781250058904%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DHUMANS%2BOF%2BNEW%2BYORK%253A%2BSTORIES%2BBrandon%2BStanton%26aff%3DNYT nyt://book/bb67f8cc-7a34-55ad-a03b-f10f64e9d900
6 0 0 0 0 0062316095 9780062316097 Harper How Homo sapiens became Earth’s dominant species. 0.00 SAPIENS Yuval Noah Harari by Yuval Noah Harari https://storage.googleapis.com/du-prd/books/images/9780062316097.jpg 128 192 http://www.amazon.com/Sapiens-A-Brief-History-Humankind-ebook/dp/B00ICN066A?tag=NYTBSREV-20 0062316095, 0062316109, 0062796232, 1494576902, 0062316117, 1494506904, 1494556901, 1473523788, 1538456583, 1538456605, 1538456591 9780062316097, 9780062316103, 9780062796233, 9781494576905, 9780062316110, 9781494506902, 9781494556907, 9781473523784, 9781538456583, 9781538456606, 9781538456590 Amazon , Apple Books , Barnes and Noble, Books-A-Million , Bookshop , IndieBound http://www.amazon.com/Sapiens-A-Brief-History-Humankind-ebook/dp/B00ICN066A?tag=NYTBSREV-20 , https://goto.applebooks.apple/9780062316097?at=10lIEQ , https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780062316097 , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fp%252FSAPIENS%252FYuval%252BNoah%252BHarari%252F9780062316097&url2=https%3A%2F%2Fwww.anrdoezrs.net%2Fclick-7990613-35140%3Furl%3Dhttps%253A%252F%252Fwww.booksamillion.com%252Fsearch%253Fquery%253DSAPIENS%252BYuval%252BNoah%252BHarari, https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fbookshop.org%2Fa%2F3546%2F9780062316097&url2=https%3A%2F%2Fbookshop.org%2Fbooks%3Faffiliate%3D3546%26keywords%3DSAPIENS , https://du-gae-books-dot-nyt-du-prd.appspot.com/redirect?url1=https%3A%2F%2Fwww.indiebound.org%2Fbook%2F9780062316097%3Faff%3DNYT&url2=https%3A%2F%2Fwww.indiebound.org%2Fsearch%2Fbook%3Fkeys%3DSAPIENS%2BYuval%2BNoah%2BHarari%26aff%3DNYT nyt://book/6321e78d-5215-5c51-bcea-79cfffbc3db9