MATH167R: Programming for data analysis

Peter Gao

Overview of today

  • Programming for data science
  • Functional R programming with apply, lapply, mapply
  • Working with APIs
  • Looping through many files

Programming for data science

In the first half of the semester, we covered skills for exploratory data analysis: visualization and descriptive statistics.

Today, we’ll combine those skills with programming concepts.

Motivating example

Each week, the New York Times publishes a list of the bestselling books in the US. Suppose we want to know:

  • How long has the current #1 book been #1?

  • How many different books have been on the bestseller list this month?

Alternatively, suppose that we wish to create a visualization/analysis that we can easily update each week when the data is released.

Motivating example

Ideally, we can write functions that will allow us to produce results automatically each week for new data:

## skeleton 
update_analysis <- function() {
  # load new data
  results <- load_data() |>
    clean_data() |>
    update_visualizations() 
  return(results)
}
load_data <- function() {
  # BODY OF FUNCTION
}
clean_data <- function() {
  # BODY OF FUNCTION
}
update_visualizations <- function() {
  # BODY OF FUNCTION
}

Functional programming

Today we’ll discuss some tools in R for running these kinds of automated analyses. In particular, we’ll focus on using R for functional programming.

Functional programming is a paradigm that focuses on writing and composing functions to perform tasks. Functional programming is an example of a declarative programming style which focuses on specifying what a program should accomplish, rather than how. On the other hand, imperative programming focuses on describing how a program operates.

Functional programming

The benefits of functional programming include:

  • Tasks are broken up into modular functions that can be analyzed in isolation
  • Tasks may be easier to optimise or parallelize
  • Unexpected side effects are avoided

Some downsides include:

  • Functional programming may be less efficient than imperative programming
  • Less transparency about how tasks are executed

Functional programming

Many functional languages require functions to be pure, meaning that:

  • The output of a function depends only on the inputs, so if you call it with the same inputs, you get the same outputs.
  • Functions have no side effects like changing the values of variables in the global environment.

R doesn’t require functions to be pure, but writing pure functions can help make your code understandable, at least in terms of clarifying what each function does.

Imperative vs. declarative

Imperative programming: for loop

out <- 0
x <- 1:10
for (i in x) {
  out <- out + i
}
out
[1] 55

Declarative programming:

sum(x)
[1] 55

Example: a complicated for loop

# Not the most transparent code
library(palmerpenguins)
data(penguins)
penguins$centered_mass <- NA
for (i in unique(penguins$species)) {
  current_data <- penguins[penguins$species == i,]
  species_mean_mass <- mean(current_data$body_mass_g, na.rm = T)
  penguins$centered_mass[penguins$species == i] <- 
    current_data$body_mass_g - species_mean_mass
}

Example: a functional programming approach

library(tidyverse)
penguins <- penguins |>
  group_by(species) |>
  mutate(centered_mass = body_mass_g - mean(body_mass_g, na.rm = T)) |>
  ungroup()

Functionals

Functionals are functions that takes a function (and potentially other parameters) as input and returns a vector as output. For example, here is a simple functional. What do you think the following code does?

randomize <- function(f) f(runif(1000))
randomize(mean)
[1] 0.5033129

Functionals are often used to replace for loops.

The main drawback of for loops is that they are not expressive, meaning that they do not clearly commmunicate a high level goal. Functionals can more clearly communicate their purpose.

lapply(): Apply a function to every element of a list

The lapply() function takes two arguments, X (an atomic vector or list), and a function FUN that can be applied to element of X. lapply() returns a list.

Remember, we can think of every data frame as a list of columns.

lapply(penguins, class)
$species
[1] "factor"

$island
[1] "factor"

$bill_length_mm
[1] "numeric"

$bill_depth_mm
[1] "numeric"

$flipper_length_mm
[1] "integer"

$body_mass_g
[1] "integer"

$sex
[1] "factor"

$year
[1] "integer"

$centered_mass
[1] "numeric"

lapply(): Apply a function to every element of a list

Note that lapply() always returns a list. We can use the unlist() function to turn this into a vector (but be careful).

unlist(lapply(penguins, class))
          species            island    bill_length_mm     bill_depth_mm 
         "factor"          "factor"         "numeric"         "numeric" 
flipper_length_mm       body_mass_g               sex              year 
        "integer"         "integer"          "factor"         "integer" 
    centered_mass 
        "numeric" 

lapply(): Apply a function to every element of a list

lapply() is especially helpful when we have datasets of different sizes:

# Create 20 random datasets
l <- replicate(20, runif(sample(1:10, 1)), simplify = FALSE)
l
[[1]]
[1] 0.75392784 0.04397956

[[2]]
[1] 0.1171737 0.8826849 0.4137036 0.9416546 0.5691964 0.4724422 0.8084333
[8] 0.6727758

[[3]]
[1] 0.4550587 0.9974555 0.9116955 0.1195449 0.3161031 0.3455121 0.4667985
[8] 0.4714195 0.4205552

[[4]]
[1] 0.3626950 0.4874761 0.5672627 0.9545976

[[5]]
[1] 0.30639545 0.80912909 0.57823769 0.01668841 0.50965492 0.42379140 0.04386622

[[6]]
[1] 0.06468632 0.73883809 0.09992750 0.18450633

[[7]]
[1] 0.6123281 0.4359723 0.9349763 0.5948979

[[8]]
[1] 0.7053785 0.1504692

[[9]]
[1] 0.7542147

[[10]]
[1] 0.84822729 0.40956745 0.02456765 0.85132770 0.21205826

[[11]]
[1] 0.9522930 0.8347866 0.7153259

[[12]]
[1] 0.7461352 0.4973994 0.8034720

[[13]]
[1] 0.7456755 0.7758405 0.9785635 0.5629637 0.4008721 0.7209267 0.3135298
[8] 0.5673543

[[14]]
[1] 0.07747491 0.16509085 0.95084328 0.28955425 0.85497358 0.05304540 0.03943823

[[15]]
[1] 0.95930749 0.57514662 0.36981421 0.43962002 0.06311152

[[16]]
[1] 0.1565886 0.5867627 0.5717541 0.3700248 0.3613710 0.2602328 0.3736455

[[17]]
[1] 0.4217495 0.1525661 0.9946047

[[18]]
[1] 0.8174423 0.4372762

[[19]]
 [1] 0.07375109 0.90103091 0.43071631 0.27077084 0.24694033 0.33341102
 [7] 0.77885469 0.58168766 0.84773589 0.80506215

[[20]]
[1] 0.05376803

lapply(): Apply a function to every element of a list

We can use lapply() to summarize all of our datasets:

# Print the length of each dataset
unlist(lapply(l, length))
 [1]  2  8  9  4  7  4  4  2  1  5  3  3  8  7  5  7  3  2 10  1

vapply()

There are many other variants of lapply(), including mapply(), sapply(), and vapply(). The only one we will cover today is vapply(), which returns a vector or matrix instead of a list. When we use vapply(), we specify an additional parameter, FUN.VALUE which specifies a template for the return value from FUN.

# Print the length of each dataset
vapply(l, length, FUN.VALUE = numeric(1))
 [1]  2  8  9  4  7  4  4  2  1  5  3  3  8  7  5  7  3  2 10  1

Back to our motivating example

First, let’s get the data for each week over the last three months. To do so, we need to access the New York Times API (application programming interface)

APIs allow programs to interact–one of the most common usages is for automatically downloading data using code.

APIs for getting data

To use the New York Times API, we need to:

  • Make an account and obtain an API key (an ID that will tell the New York Times who is downloading their data)
  • Review the documentation to identify the relevant endpoints.
  • Review any rules about usage/limits.

API endpoints

APIs provide endpoints, which are addresses from which we can obtain the relevant data.

API rate limits

In order to prevent users from abusing these services, many APIs have limits on how quickly a user can download data.

Downloading the current list

library(tidyverse)
library(jsonlite)
api_key <- readLines("~/Dropbox/teaching/math167R-f23/internal/nyt-key.txt")
current_list <- jsonlite::fromJSON(
  paste0(
    "https://api.nytimes.com/svc/books/v3/lists/2024-03-05/hardcover-fiction.json?api-key=",
    api_key
  )
)$results$books
title author publisher rank rank_last_week weeks_on_list
THE WOMEN Kristin Hannah St. Martin's 1 1 3
FOURTH WING Rebecca Yarros Red Tower 2 2 42
IRON FLAME Rebecca Yarros Red Tower 3 3 16
HOUSE OF FLAME AND SHADOW Sarah J. Maas Bloomsbury 4 4 4
THE HEAVEN & EARTH GROCERY STORE James McBride Riverhead 5 5 27
FIRST LIE WINS Ashley Elston Pamela Dorman 6 6 8
GOTHIKANA RuNyx Bramble 7 9 5
LESSONS IN CHEMISTRY Bonnie Garmus Doubleday 8 8 94
CROSSHAIRS James Patterson and James O. Born Little, Brown 9 7 2
THE CHAOS AGENT Mark Greaney Berkley 10 0 1
REMARKABLY BRIGHT CREATURES Shel Van Pelt Ecco 11 11 39
THE FURY Alex Michaelides Celadon 12 12 6
THE ATLAS MANEUVER Steve Berry Grand Central 13 0 1
DEMON COPPERHEAD Barbara Kingsolver Harper 14 13 69
THE COVENANT OF WATER Abraham Verghese Grove 15 14 38

Downloading the past three months’ data

dates <- seq(as.Date("2024-03-05"), by = -7, length.out = 12)
bestseller_lists <- lapply(
  dates,
  function(x) {
    # slow down execution by waiting 12 seconds
    Sys.sleep(15)
    jsonlite::fromJSON(
      paste0(
        "https://api.nytimes.com/svc/books/v3/lists/",
        x,
        "/hardcover-fiction.json?api-key=",
        api_key
      )
    )$results$books
  }
)
names(bestseller_lists) <- dates

Looping through many data files

What if we want to get the #1 book for the last 12 weeks?

vapply(bestseller_lists, function(x) x$title[1], character(1))
                 2024-03-05                  2024-02-27 
                "THE WOMEN"                 "THE WOMEN" 
                 2024-02-20                  2024-02-13 
                "THE WOMEN" "HOUSE OF FLAME AND SHADOW" 
                 2024-02-06                  2024-01-30 
              "FOURTH WING"               "FOURTH WING" 
                 2024-01-23                  2024-01-16 
              "FOURTH WING"               "FOURTH WING" 
                 2024-01-09                  2024-01-02 
              "FOURTH WING"               "FOURTH WING" 
                 2023-12-26                  2023-12-19 
              "FOURTH WING"               "FOURTH WING" 

Looping through many data files

Suppose we wish to see the performance of the books that have been top three at some point in the last three months

top_titles <- 
  lapply(bestseller_lists, function(x) x$title[1:3]) |>
  unlist() |>
  unique()
top_book_data <- 
  lapply(bestseller_lists, function(x) x[x$title %in% top_titles, ])

Looping through many data files

We can use the bind_rows() to create a data frame combining all the entries in this list. The .id argument creates a column from the list’s names. We can convert these names into a Date variable.

top_book_data <- bind_rows(top_book_data, .id = "date")
top_book_data$date <- as.Date(top_book_data$date)
date title author rank rank_last_week weeks_on_list publisher
2024-03-05 THE WOMEN Kristin Hannah 1 1 3 St. Martin's
2024-03-05 FOURTH WING Rebecca Yarros 2 2 42 Red Tower
2024-03-05 IRON FLAME Rebecca Yarros 3 3 16 Red Tower
2024-03-05 HOUSE OF FLAME AND SHADOW Sarah J. Maas 4 4 4 Bloomsbury
2024-03-05 THE HEAVEN & EARTH GROCERY STORE James McBride 5 5 27 Riverhead
2024-03-05 THE FURY Alex Michaelides 12 12 6 Celadon
2024-02-27 THE WOMEN Kristin Hannah 1 1 2 St. Martin's
2024-02-27 FOURTH WING Rebecca Yarros 2 3 41 Red Tower
2024-02-27 IRON FLAME Rebecca Yarros 3 4 15 Red Tower
2024-02-27 HOUSE OF FLAME AND SHADOW Sarah J. Maas 4 2 3 Bloomsbury
2024-02-27 THE HEAVEN & EARTH GROCERY STORE James McBride 5 5 26 Riverhead
2024-02-27 THE FURY Alex Michaelides 12 8 5 Celadon
2024-02-20 THE WOMEN Kristin Hannah 1 0 1 St. Martin's
2024-02-20 HOUSE OF FLAME AND SHADOW Sarah J. Maas 2 1 2 Bloomsbury
2024-02-20 FOURTH WING Rebecca Yarros 3 2 40 Red Tower
2024-02-20 IRON FLAME Rebecca Yarros 4 3 14 Red Tower
2024-02-20 THE HEAVEN & EARTH GROCERY STORE James McBride 5 4 25 Riverhead
2024-02-20 THE FURY Alex Michaelides 8 7 4 Celadon
2024-02-13 HOUSE OF FLAME AND SHADOW Sarah J. Maas 1 0 1 Bloomsbury
2024-02-13 FOURTH WING Rebecca Yarros 2 1 39 Red Tower
2024-02-13 IRON FLAME Rebecca Yarros 3 2 13 Red Tower
2024-02-13 THE HEAVEN & EARTH GROCERY STORE James McBride 4 5 24 Riverhead
2024-02-13 THE FURY Alex Michaelides 7 7 3 Celadon
2024-02-13 RANDOM IN DEATH J.D. Robb 11 3 2 St. Martin's
2024-02-06 FOURTH WING Rebecca Yarros 1 1 38 Red Tower
2024-02-06 IRON FLAME Rebecca Yarros 2 2 12 Red Tower
2024-02-06 RANDOM IN DEATH J.D. Robb 3 0 1 St. Martin's
2024-02-06 THE HEAVEN & EARTH GROCERY STORE James McBride 5 4 23 Riverhead
2024-02-06 THE FURY Alex Michaelides 7 3 2 Celadon
2024-01-30 FOURTH WING Rebecca Yarros 1 1 37 Red Tower
2024-01-30 IRON FLAME Rebecca Yarros 2 2 11 Red Tower
2024-01-30 THE FURY Alex Michaelides 3 0 1 Celadon
2024-01-30 THE HEAVEN & EARTH GROCERY STORE James McBride 4 4 22 Riverhead
2024-01-30 SANCTUARY OF THE SHADOW Aurora Ascher 10 3 2 Red Tower
2024-01-23 FOURTH WING Rebecca Yarros 1 1 36 Red Tower
2024-01-23 IRON FLAME Rebecca Yarros 2 2 10 Red Tower
2024-01-23 SANCTUARY OF THE SHADOW Aurora Ascher 3 0 1 Red Tower
2024-01-23 THE HEAVEN & EARTH GROCERY STORE James McBride 4 3 21 Riverhead
2024-01-16 FOURTH WING Rebecca Yarros 1 1 35 Red Tower
2024-01-16 IRON FLAME Rebecca Yarros 2 2 9 Red Tower
2024-01-16 THE HEAVEN & EARTH GROCERY STORE James McBride 3 3 20 Riverhead
2024-01-09 FOURTH WING Rebecca Yarros 1 1 34 Red Tower
2024-01-09 IRON FLAME Rebecca Yarros 2 3 8 Red Tower
2024-01-09 THE HEAVEN & EARTH GROCERY STORE James McBride 3 2 19 Riverhead
2024-01-02 FOURTH WING Rebecca Yarros 1 1 33 Red Tower
2024-01-02 THE HEAVEN & EARTH GROCERY STORE James McBride 2 2 18 Riverhead
2024-01-02 IRON FLAME Rebecca Yarros 3 3 7 Red Tower
2023-12-26 FOURTH WING Rebecca Yarros 1 1 32 Red Tower
2023-12-26 THE HEAVEN & EARTH GROCERY STORE James McBride 2 3 17 Riverhead
2023-12-26 IRON FLAME Rebecca Yarros 3 2 6 Red Tower
2023-12-19 FOURTH WING Rebecca Yarros 1 1 31 Red Tower
2023-12-19 IRON FLAME Rebecca Yarros 2 2 5 Red Tower
2023-12-19 THE HEAVEN & EARTH GROCERY STORE James McBride 3 4 16 Riverhead

Looping through many data files

library(ggplot2)
ggplot(top_book_data, aes(x = date, y = rank, color = title)) + 
  geom_line() + 
  scale_y_continuous(breaks = 1:20, trans = "reverse") +
  xlab("Date") +
  ylab("Rank") +
  ggtitle(paste0("Recent NYT Best Seller Ranks")) 

Looping through many data files

We can also pull the top 5 books from each list:

top_5s <- lapply(bestseller_lists, function(x) x[1:5, ])
top_5s
$`2024-03-05`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1             3        0      0     1250178630
2    2              2            42        0      0     1649374046
3    3              3            16        0      0     1649374178
4    4              4             4        0      0     1635574102
5    5              5            27        0      0     0593422945
  primary_isbn13    publisher
1  9781250178633 St. Martin's
2  9781649374042    Red Tower
3  9781649374172    Red Tower
4  9781635574104   Bloomsbury
5  9780593422946    Riverhead
                                                                                                                        description
1                  In 1965, a nursing student follows her brother to serve during the Vietnam War and returns to a divided America.
2  Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
3 The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
4                The third book in the Crescent City series. Bryce wants to return home while Hunt is trapped in Asteri's dungeons.
5        Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
  price                            title         author       contributor
1  0.00                        THE WOMEN Kristin Hannah by Kristin Hannah
2  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
3  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
4  0.00        HOUSE OF FLAME AND SHADOW  Sarah J. Maas  by Sarah J. Maas
5  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781250178633.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
3 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
4 https://storage.googleapis.com/du-prd/books/images/9781635574104.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
  book_image_width book_image_height
1              333               500
2              309               500
3              309               500
4              325               500
5              331               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1250178630?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/1635574102?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1                                                                                  1250178630, 1250178657, 9781250178633, 9781250178657
2 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
3                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
4                                                                                                             1635574102, 9781635574104
5                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                   Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1250178630?tag=NYTBSREV-20, https://goto.applebooks.apple/9781250178633?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250178633, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BWOMEN%2FKristin%2BHannah%2F9781250178633, https://bookshop.org/a/3546/9781250178633, https://www.indiebound.org/book/9781250178633?aff=NYT
2                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
3                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
4            Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1635574102?tag=NYTBSREV-20, https://goto.applebooks.apple/9781635574104?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781635574104, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FHOUSE%2BOF%2BFLAME%2BAND%2BSHADOW%2FSarah%2BJ.%2BMaas%2F9781635574104, https://bookshop.org/a/3546/9781635574104, https://www.indiebound.org/book/9781635574104?aff=NYT
5 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
                                         book_uri
1 nyt://book/9ce735af-71cf-5ff3-a367-43ee07e3fdd7
2 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
3 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
4 nyt://book/fd8d95af-3496-5a1b-81d2-d3f7a7a54e90
5 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9

$`2024-02-27`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1             2        0      0     1250178630
2    2              3            41        0      0     1649374046
3    3              4            15        0      0     1649374178
4    4              2             3        0      0     1635574102
5    5              5            26        0      0     0593422945
  primary_isbn13    publisher
1  9781250178633 St. Martin's
2  9781649374042    Red Tower
3  9781649374172    Red Tower
4  9781635574104   Bloomsbury
5  9780593422946    Riverhead
                                                                                                                        description
1                  In 1965, a nursing student follows her brother to serve during the Vietnam War and returns to a divided America.
2  Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
3 The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
4                The third book in the Crescent City series. Bryce wants to return home while Hunt is trapped in Asteri's dungeons.
5        Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
  price                            title         author       contributor
1  0.00                        THE WOMEN Kristin Hannah by Kristin Hannah
2  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
3  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
4  0.00        HOUSE OF FLAME AND SHADOW  Sarah J. Maas  by Sarah J. Maas
5  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781250178633.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
3 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
4 https://storage.googleapis.com/du-prd/books/images/9781635574104.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
  book_image_width book_image_height
1              333               500
2              309               500
3              309               500
4              325               500
5              331               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1250178630?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/1635574102?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1                                                                                  1250178630, 1250178657, 9781250178633, 9781250178657
2 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
3                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
4                                                                                                             1635574102, 9781635574104
5                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                   Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1250178630?tag=NYTBSREV-20, https://goto.applebooks.apple/9781250178633?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250178633, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BWOMEN%2FKristin%2BHannah%2F9781250178633, https://bookshop.org/a/3546/9781250178633, https://www.indiebound.org/book/9781250178633?aff=NYT
2                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
3                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
4            Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1635574102?tag=NYTBSREV-20, https://goto.applebooks.apple/9781635574104?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781635574104, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FHOUSE%2BOF%2BFLAME%2BAND%2BSHADOW%2FSarah%2BJ.%2BMaas%2F9781635574104, https://bookshop.org/a/3546/9781635574104, https://www.indiebound.org/book/9781635574104?aff=NYT
5 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
                                         book_uri
1 nyt://book/9ce735af-71cf-5ff3-a367-43ee07e3fdd7
2 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
3 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
4 nyt://book/fd8d95af-3496-5a1b-81d2-d3f7a7a54e90
5 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9

$`2024-02-20`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              0             1        0      0     1250178630
2    2              1             2        0      0     1635574102
3    3              2            40        0      0     1649374046
4    4              3            14        0      0     1649374178
5    5              4            25        0      0     0593422945
  primary_isbn13    publisher
1  9781250178633 St. Martin's
2  9781635574104   Bloomsbury
3  9781649374042    Red Tower
4  9781649374172    Red Tower
5  9780593422946    Riverhead
                                                                                                                        description
1                  In 1965, a nursing student follows her brother to serve during the Vietnam War and returns to a divided America.
2                The third book in the Crescent City series. Bryce wants to return home while Hunt is trapped in Asteri's dungeons.
3  Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
4 The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
5        Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
  price                            title         author       contributor
1  0.00                        THE WOMEN Kristin Hannah by Kristin Hannah
2  0.00        HOUSE OF FLAME AND SHADOW  Sarah J. Maas  by Sarah J. Maas
3  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
4  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
5  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781250178633.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781635574104.jpg
3 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
4 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
  book_image_width book_image_height
1              333               500
2              325               500
3              309               500
4              309               500
5              331               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1250178630?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1635574102?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1                                                                                  1250178630, 1250178657, 9781250178633, 9781250178657
2                                                                                                             1635574102, 9781635574104
3 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
4                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
5                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                   Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1250178630?tag=NYTBSREV-20, https://goto.applebooks.apple/9781250178633?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250178633, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BWOMEN%2FKristin%2BHannah%2F9781250178633, https://bookshop.org/a/3546/9781250178633, https://www.indiebound.org/book/9781250178633?aff=NYT
2            Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1635574102?tag=NYTBSREV-20, https://goto.applebooks.apple/9781635574104?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781635574104, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FHOUSE%2BOF%2BFLAME%2BAND%2BSHADOW%2FSarah%2BJ.%2BMaas%2F9781635574104, https://bookshop.org/a/3546/9781635574104, https://www.indiebound.org/book/9781635574104?aff=NYT
3                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
4                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
5 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
                                         book_uri
1 nyt://book/9ce735af-71cf-5ff3-a367-43ee07e3fdd7
2 nyt://book/fd8d95af-3496-5a1b-81d2-d3f7a7a54e90
3 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
4 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
5 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9

$`2024-02-13`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              0             1        0      0     1635574102
2    2              1            39        0      0     1649374046
3    3              2            13        0      0     1649374178
4    4              5            24        0      0     0593422945
5    5              4             2        0      0     1250334209
  primary_isbn13  publisher
1  9781635574104 Bloomsbury
2  9781649374042  Red Tower
3  9781649374172  Red Tower
4  9780593422946  Riverhead
5  9781250334206    Bramble
                                                                                                                                           description
1                                   The third book in the Crescent City series. Bryce wants to return home while Hunt is trapped in Asteri's dungeons.
2                     Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
3                    The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
4                           Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
5 A century-old mystery brings Corvina Clemm and Vad Deverell together at a university based in a castle at the top of a mountain with a dark history.
  price                            title         author       contributor
1  0.00        HOUSE OF FLAME AND SHADOW  Sarah J. Maas  by Sarah J. Maas
2  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
3  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
4  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
5  0.00                        GOTHIKANA          RuNyx          by RuNyx
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781635574104.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
3 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
4 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
5 https://storage.googleapis.com/du-prd/books/images/9781250334206.jpg
  book_image_width book_image_height
1              325               500
2              309               500
3              309               500
4              331               500
5              325               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1635574102?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/1250334209?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1                                                                                                             1635574102, 9781635574104
2 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
3                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
4                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
5                                                                                  1250334209, 1250334217, 9781250334206, 9781250334213
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1            Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1635574102?tag=NYTBSREV-20, https://goto.applebooks.apple/9781635574104?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781635574104, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FHOUSE%2BOF%2BFLAME%2BAND%2BSHADOW%2FSarah%2BJ.%2BMaas%2F9781635574104, https://bookshop.org/a/3546/9781635574104, https://www.indiebound.org/book/9781635574104?aff=NYT
2                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
3                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
4 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
5                                                Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1250334209?tag=NYTBSREV-20, https://goto.applebooks.apple/9781250334206?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250334206, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FGOTHIKANA%2FRuNyx%2F9781250334206, https://bookshop.org/a/3546/9781250334206, https://www.indiebound.org/book/9781250334206?aff=NYT
                                         book_uri
1 nyt://book/fd8d95af-3496-5a1b-81d2-d3f7a7a54e90
2 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
3 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
4 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9
5 nyt://book/0501bc11-beef-570b-befd-d551de1006c8

$`2024-02-06`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1            38        0      0     1649374046
2    2              2            12        0      0     1649374178
3    3              0             1        0      0     1250289548
4    4              0             1        0      0     1250334209
5    5              4            23        0      0     0593422945
  primary_isbn13    publisher
1  9781649374042    Red Tower
2  9781649374172    Red Tower
3  9781250289544 St. Martin's
4  9781250334206      Bramble
5  9780593422946    Riverhead
                                                                                                                                           description
1                     Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
2                    The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
3                      The 58th book of the In Death series. Eve Dallas searches for the person who jabbed a teenager with a vial of toxic substances.
4 A century-old mystery brings Corvina Clemm and Vad Deverell together at a university based in a castle at the top of a mountain with a dark history.
5                           Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
  price                            title         author       contributor
1  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
2  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
3  0.00                  RANDOM IN DEATH      J.D. Robb      by J.D. Robb
4  0.00                        GOTHIKANA          RuNyx          by RuNyx
5  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
3 https://storage.googleapis.com/du-prd/books/images/9781250289544.jpg
4 https://storage.googleapis.com/du-prd/books/images/9781250334206.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
  book_image_width book_image_height
1              309               500
2              309               500
3              329               500
4              325               500
5              331               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/1250289548?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/1250334209?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
2                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
3                                                       1250289548, 1250289556, 1250328802, 9781250289544, 9781250289551, 9781250328809
4                                                                                  1250334209, 1250334217, 9781250334206, 9781250334213
5                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
2                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
3                                Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1250289548?tag=NYTBSREV-20, https://goto.applebooks.apple/9781250289544?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250289544, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FRANDOM%2BIN%2BDEATH%2FJ.D.%2BRobb%2F9781250289544, https://bookshop.org/a/3546/9781250289544, https://www.indiebound.org/book/9781250289544?aff=NYT
4                                                Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1250334209?tag=NYTBSREV-20, https://goto.applebooks.apple/9781250334206?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250334206, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FGOTHIKANA%2FRuNyx%2F9781250334206, https://bookshop.org/a/3546/9781250334206, https://www.indiebound.org/book/9781250334206?aff=NYT
5 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
                                         book_uri
1 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
2 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
3 nyt://book/2d26fabd-b55d-5993-b89f-62d701215083
4 nyt://book/0501bc11-beef-570b-befd-d551de1006c8
5 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9

$`2024-01-30`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1            37        0      0     1649374046
2    2              2            11        0      0     1649374178
3    3              0             1        0      0     125075898X
4    4              4            22        0      0     0593422945
5    5              5             3        0      0     0593492919
  primary_isbn13     publisher
1  9781649374042     Red Tower
2  9781649374172     Red Tower
3  9781250758989       Celadon
4  9780593422946     Riverhead
5  9780593492918 Pamela Dorman
                                                                                                                        description
1  Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
2 The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
3                    Violence erupts when a former movie star brings a group of her friends to her private Greek island for Easter.
4        Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
5                                 A woman who works for a mysterious boss takes on a new identity to dig up information on someone.
  price                            title           author         contributor
1  0.00                      FOURTH WING   Rebecca Yarros   by Rebecca Yarros
2  0.00                       IRON FLAME   Rebecca Yarros   by Rebecca Yarros
3  0.00                         THE FURY Alex Michaelides by Alex Michaelides
4  0.00 THE HEAVEN & EARTH GROCERY STORE    James McBride    by James McBride
5  0.00                   FIRST LIE WINS    Ashley Elston    by Ashley Elston
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
3 https://storage.googleapis.com/du-prd/books/images/9781250758989.jpg
4 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780593492918.jpg
  book_image_width book_image_height
1              309               500
2              309               500
3              331               500
4              331               500
5              331               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/125075898X?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/0593492919?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
2                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
3                                                                                  125075898X, 1250759005, 9781250758989, 9781250759009
4                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
5                                                       0593492919, 0593492927, 0593789687, 9780593492918, 9780593492925, 9780593789681
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
2                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
3                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/125075898X?tag=NYTBSREV-20, https://goto.applebooks.apple/9781250758989?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781250758989, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BFURY%2FAlex%2BMichaelides%2F9781250758989, https://bookshop.org/a/3546/9781250758989, https://www.indiebound.org/book/9781250758989?aff=NYT
4 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
5                             Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593492919?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593492918?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593492918, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFIRST%2BLIE%2BWINS%2FAshley%2BElston%2F9780593492918, https://bookshop.org/a/3546/9780593492918, https://www.indiebound.org/book/9780593492918?aff=NYT
                                         book_uri
1 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
2 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
3 nyt://book/3b064e93-0e77-5d37-8ba3-4d32b82a83c5
4 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9
5 nyt://book/d5aa005c-08a5-5bd9-ba0e-6dcd5e7e31f8

$`2024-01-23`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1            36        0      0     1649374046
2    2              2            10        0      0     1649374178
3    3              0             1        0      0     1649374119
4    4              3            21        0      0     0593422945
5    5              5             2        0      0     0593492919
  primary_isbn13     publisher
1  9781649374042     Red Tower
2  9781649374172     Red Tower
3  9781649374110     Red Tower
4  9780593422946     Riverhead
5  9780593492918 Pamela Dorman
                                                                                                                        description
1  Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
2 The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
3                 When Harrow takes an interest in a winged beast new to the area, old enemies turn up to get their revenge on her.
4        Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
5                                 A woman who works for a mysterious boss takes on a new identity to dig up information on someone.
  price                            title         author       contributor
1  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
2  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
3  0.00          SANCTUARY OF THE SHADOW  Aurora Ascher  by Aurora Ascher
4  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
5  0.00                   FIRST LIE WINS  Ashley Elston  by Ashley Elston
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
3 https://storage.googleapis.com/du-prd/books/images/9781649374110.jpg
4 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780593492918.jpg
  book_image_width book_image_height
1              309               500
2              309               500
3              309               500
4              331               500
5              331               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/1649374119?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/0593492919?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
2                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
3                                                                                  1649374119, 1649373112, 9781649374110, 9781649373113
4                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
5                                                       0593492919, 0593492927, 0593789687, 9780593492918, 9780593492925, 9780593789681
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
2                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
3                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374119?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374110?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374110, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FSANCTUARY%2BOF%2BTHE%2BSHADOW%2FAurora%2BAscher%2F9781649374110, https://bookshop.org/a/3546/9781649374110, https://www.indiebound.org/book/9781649374110?aff=NYT
4 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
5                             Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593492919?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593492918?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593492918, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFIRST%2BLIE%2BWINS%2FAshley%2BElston%2F9780593492918, https://bookshop.org/a/3546/9780593492918, https://www.indiebound.org/book/9780593492918?aff=NYT
                                         book_uri
1 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
2 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
3 nyt://book/210bcb4e-8cd2-5583-8bb0-b84846174642
4 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9
5 nyt://book/d5aa005c-08a5-5bd9-ba0e-6dcd5e7e31f8

$`2024-01-16`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1            35        0      0     1649374046
2    2              2             9        0      0     1649374178
3    3              3            20        0      0     0593422945
4    4             13            32        0      0     0063204150
5    5              0             1        0      0     0593492919
  primary_isbn13     publisher
1  9781649374042     Red Tower
2  9781649374172     Red Tower
3  9780593422946     Riverhead
4  9780063204157          Ecco
5  9780593492918 Pamela Dorman
                                                                                                                        description
1  Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
2 The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
3        Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
4 A widow working the night shift at the Sowell Bay Aquarium is aided in solving a mystery by a giant Pacific octopus living there.
5                                 A woman who works for a mysterious boss takes on a new identity to dig up information on someone.
  price                            title         author        contributor
1  0.00                      FOURTH WING Rebecca Yarros  by Rebecca Yarros
2  0.00                       IRON FLAME Rebecca Yarros  by Rebecca Yarros
3  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride   by James McBride
4  0.00      REMARKABLY BRIGHT CREATURES  Shel Van Pelt by Shelby Van Pelt
5  0.00                   FIRST LIE WINS  Ashley Elston   by Ashley Elston
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
3 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
4 https://storage.googleapis.com/du-prd/books/images/9780063204157.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780593492918.jpg
  book_image_width book_image_height
1              309               500
2              309               500
3              331               500
4              329               500
5              331               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/0063204150?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/0593492919?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
2                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
3                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
4                            0063204150, 0063204185, 0063204169, 0063204177, 9780063204157, 9780063204188, 9780063204164, 9780063204171
5                                                       0593492919, 0593492927, 0593789687, 9780593492918, 9780593492925, 9780593789681
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
2                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
3 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
4              Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0063204150?tag=NYTBSREV-20, https://goto.applebooks.apple/9780063204157?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780063204157, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FREMARKABLY%2BBRIGHT%2BCREATURES%2FShel%2BVan%2BPelt%2F9780063204157, https://bookshop.org/a/3546/9780063204157, https://www.indiebound.org/book/9780063204157?aff=NYT
5                             Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593492919?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593492918?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593492918, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFIRST%2BLIE%2BWINS%2FAshley%2BElston%2F9780593492918, https://bookshop.org/a/3546/9780593492918, https://www.indiebound.org/book/9780593492918?aff=NYT
                                         book_uri
1 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
2 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
3 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9
4 nyt://book/206a5e83-12f4-5ea9-8e63-1da5470a6ef5
5 nyt://book/d5aa005c-08a5-5bd9-ba0e-6dcd5e7e31f8

$`2024-01-09`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1            34        0      0     1649374046
2    2              3             8        0      0     1649374178
3    3              2            19        0      0     0593422945
4    4              5            86        0      0     038554734X
5    5              4            11        0      0     0385548958
  primary_isbn13 publisher
1  9781649374042 Red Tower
2  9781649374172 Red Tower
3  9780593422946 Riverhead
4  9780385547345 Doubleday
5  9780385548953 Doubleday
                                                                                                                         description
1   Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
2  The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
3         Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
4                               A scientist and single mother living in California in the 1960s becomes a star on a TV cooking show.
5 In a sequel to “The Firm,” Mitch McDeere, who is now a partner at the world’s largest law firm, gets caught up in a sinister plot.
  price                            title         author       contributor
1  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
2  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
3  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
4  0.00             LESSONS IN CHEMISTRY  Bonnie Garmus  by Bonnie Garmus
5  0.00                     THE EXCHANGE   John Grisham   by John Grisham
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
3 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
4 https://storage.googleapis.com/du-prd/books/images/9780385547345.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780385548953.jpg
  book_image_width book_image_height
1              309               500
2              309               500
3              331               500
4              328               500
5              329               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/038554734X?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/0385548958?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
2                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
3                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
4                            038554734X, 0593507533, 0385547374, 0593862406, 9780385547345, 9780593507537, 9780385547376, 9780593862407
5                            0385548958, 0385548966, 0593607481, 0385548974, 9780385548953, 9780385548960, 9780593607480, 9780385548977
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
2                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
3 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
4                       Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/038554734X?tag=NYTBSREV-20, https://goto.applebooks.apple/9780385547345?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385547345, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FLESSONS%2BIN%2BCHEMISTRY%2FBonnie%2BGarmus%2F9780385547345, https://bookshop.org/a/3546/9780385547345, https://www.indiebound.org/book/9780385547345?aff=NYT
5                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0385548958?tag=NYTBSREV-20, https://goto.applebooks.apple/9780385548953?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385548953, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BEXCHANGE%2FJohn%2BGrisham%2F9780385548953, https://bookshop.org/a/3546/9780385548953, https://www.indiebound.org/book/9780385548953?aff=NYT
                                         book_uri
1 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
2 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
3 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9
4 nyt://book/717e0ead-9782-567d-af27-d9a6cfb1856f
5 nyt://book/52c31163-754f-58c8-90d8-ea1f297f7030

$`2024-01-02`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1            33        0      0     1649374046
2    2              2            18        0      0     0593422945
3    3              3             7        0      0     1649374178
4    4              4            10        0      0     0385548958
5    5              5            85        0      0     038554734X
  primary_isbn13 publisher
1  9781649374042 Red Tower
2  9780593422946 Riverhead
3  9781649374172 Red Tower
4  9780385548953 Doubleday
5  9780385547345 Doubleday
                                                                                                                         description
1   Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
2         Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
3  The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
4 In a sequel to “The Firm,” Mitch McDeere, who is now a partner at the world’s largest law firm, gets caught up in a sinister plot.
5                               A scientist and single mother living in California in the 1960s becomes a star on a TV cooking show.
  price                            title         author       contributor
1  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
2  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
3  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
4  0.00                     THE EXCHANGE   John Grisham   by John Grisham
5  0.00             LESSONS IN CHEMISTRY  Bonnie Garmus  by Bonnie Garmus
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
2 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
3 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
4 https://storage.googleapis.com/du-prd/books/images/9780385548953.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780385547345.jpg
  book_image_width book_image_height
1              309               500
2              331               500
3              309               500
4              329               500
5              328               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/0385548958?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/038554734X?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
2                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
3                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
4                            0385548958, 0385548966, 0593607481, 0385548974, 9780385548953, 9780385548960, 9780593607480, 9780385548977
5                            038554734X, 0593507533, 0385547374, 0593862406, 9780385547345, 9780593507537, 9780385547376, 9780593862407
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
2 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
3                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
4                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0385548958?tag=NYTBSREV-20, https://goto.applebooks.apple/9780385548953?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385548953, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BEXCHANGE%2FJohn%2BGrisham%2F9780385548953, https://bookshop.org/a/3546/9780385548953, https://www.indiebound.org/book/9780385548953?aff=NYT
5                       Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/038554734X?tag=NYTBSREV-20, https://goto.applebooks.apple/9780385547345?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385547345, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FLESSONS%2BIN%2BCHEMISTRY%2FBonnie%2BGarmus%2F9780385547345, https://bookshop.org/a/3546/9780385547345, https://www.indiebound.org/book/9780385547345?aff=NYT
                                         book_uri
1 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
2 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9
3 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
4 nyt://book/52c31163-754f-58c8-90d8-ea1f297f7030
5 nyt://book/717e0ead-9782-567d-af27-d9a6cfb1856f

$`2023-12-26`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1            32        0      0     1649374046
2    2              3            17        0      0     0593422945
3    3              2             6        0      0     1649374178
4    4              4             9        0      0     0385548958
5    5              5            84        0      0     038554734X
  primary_isbn13 publisher
1  9781649374042 Red Tower
2  9780593422946 Riverhead
3  9781649374172 Red Tower
4  9780385548953 Doubleday
5  9780385547345 Doubleday
                                                                                                                         description
1   Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
2         Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
3  The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
4 In a sequel to “The Firm,” Mitch McDeere, who is now a partner at the world’s largest law firm, gets caught up in a sinister plot.
5                               A scientist and single mother living in California in the 1960s becomes a star on a TV cooking show.
  price                            title         author       contributor
1  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
2  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
3  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
4  0.00                     THE EXCHANGE   John Grisham   by John Grisham
5  0.00             LESSONS IN CHEMISTRY  Bonnie Garmus  by Bonnie Garmus
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
2 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
3 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
4 https://storage.googleapis.com/du-prd/books/images/9780385548953.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780385547345.jpg
  book_image_width book_image_height
1              309               500
2              331               500
3              309               500
4              329               500
5              328               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/0385548958?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/038554734X?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
2                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
3                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
4                            0385548958, 0385548966, 0593607481, 0385548974, 9780385548953, 9780385548960, 9780593607480, 9780385548977
5                            038554734X, 0593507533, 0385547374, 0593862406, 9780385547345, 9780593507537, 9780385547376, 9780593862407
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
2 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
3                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
4                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0385548958?tag=NYTBSREV-20, https://goto.applebooks.apple/9780385548953?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385548953, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BEXCHANGE%2FJohn%2BGrisham%2F9780385548953, https://bookshop.org/a/3546/9780385548953, https://www.indiebound.org/book/9780385548953?aff=NYT
5                       Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/038554734X?tag=NYTBSREV-20, https://goto.applebooks.apple/9780385547345?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385547345, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FLESSONS%2BIN%2BCHEMISTRY%2FBonnie%2BGarmus%2F9780385547345, https://bookshop.org/a/3546/9780385547345, https://www.indiebound.org/book/9780385547345?aff=NYT
                                         book_uri
1 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
2 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9
3 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
4 nyt://book/52c31163-754f-58c8-90d8-ea1f297f7030
5 nyt://book/717e0ead-9782-567d-af27-d9a6cfb1856f

$`2023-12-19`
  rank rank_last_week weeks_on_list asterisk dagger primary_isbn10
1    1              1            31        0      0     1649374046
2    2              2             5        0      0     1649374178
3    3              4            16        0      0     0593422945
4    4              3             8        0      0     0385548958
5    5              5            83        0      0     038554734X
  primary_isbn13 publisher
1  9781649374042 Red Tower
2  9781649374172 Red Tower
3  9780593422946 Riverhead
4  9780385548953 Doubleday
5  9780385547345 Doubleday
                                                                                                                         description
1   Violet Sorrengail is urged by the commanding general, who also is her mother, to become a candidate for the elite dragon riders.
2  The second book in the Empyrean series. Violet Sorrengail’s next round of training might require her to betray the man she loves.
3         Secrets held by the residents of a dilapidated neighborhood come to life when a skeleton is found at the bottom of a well.
4 In a sequel to “The Firm,” Mitch McDeere, who is now a partner at the world’s largest law firm, gets caught up in a sinister plot.
5                               A scientist and single mother living in California in the 1960s becomes a star on a TV cooking show.
  price                            title         author       contributor
1  0.00                      FOURTH WING Rebecca Yarros by Rebecca Yarros
2  0.00                       IRON FLAME Rebecca Yarros by Rebecca Yarros
3  0.00 THE HEAVEN & EARTH GROCERY STORE  James McBride  by James McBride
4  0.00                     THE EXCHANGE   John Grisham   by John Grisham
5  0.00             LESSONS IN CHEMISTRY  Bonnie Garmus  by Bonnie Garmus
  contributor_note
1                 
2                 
3                 
4                 
5                 
                                                            book_image
1 https://storage.googleapis.com/du-prd/books/images/9781649374042.jpg
2 https://storage.googleapis.com/du-prd/books/images/9781649374172.jpg
3 https://storage.googleapis.com/du-prd/books/images/9780593422946.jpg
4 https://storage.googleapis.com/du-prd/books/images/9780385548953.jpg
5 https://storage.googleapis.com/du-prd/books/images/9780385547345.jpg
  book_image_width book_image_height
1              309               500
2              309               500
3              331               500
4              329               500
5              328               500
                                    amazon_product_url age_group
1 https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20          
2 https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20          
3 https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20          
4 https://www.amazon.com/dp/0385548958?tag=NYTBSREV-20          
5 https://www.amazon.com/dp/038554734X?tag=NYTBSREV-20          
  book_review_link first_chapter_link sunday_review_link article_chapter_link
1                                                                            
2                                                                            
3                                                                            
4                                                                            
5                                                                            
                                                                                                                                  isbns
1 1649374046, 1649374089, 1705085059, 1705085032, 1649376162, 9781649374042, 9781649374080, 9781705085059, 9781705085035, 9781649376169
2                                                                                  1649374178, 1705085083, 9781649374172, 9781705085080
3                            0593422945, 0593422961, 0593684125, 0593684141, 9780593422946, 9780593422960, 9780593684122, 9780593684146
4                            0385548958, 0385548966, 0593607481, 0385548974, 9780385548953, 9780385548960, 9780593607480, 9780385548977
5                            038554734X, 0593507533, 0385547374, 0593862406, 9780385547345, 9780593507537, 9780385547376, 9780593862407
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          buy_links
1                                 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374046?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374042?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374042, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FFOURTH%2BWING%2FRebecca%2BYarros%2F9781649374042, https://bookshop.org/a/3546/9781649374042, https://www.indiebound.org/book/9781649374042?aff=NYT
2                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/1649374178?tag=NYTBSREV-20, https://goto.applebooks.apple/9781649374172?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9781649374172, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FIRON%2BFLAME%2FRebecca%2BYarros%2F9781649374172, https://bookshop.org/a/3546/9781649374172, https://www.indiebound.org/book/9781649374172?aff=NYT
3 Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0593422945?tag=NYTBSREV-20, https://goto.applebooks.apple/9780593422946?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780593422946, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BHEAVEN%2B%2526%2BEARTH%2BGROCERY%2BSTORE%2FJames%2BMcBride%2F9780593422946, https://bookshop.org/a/3546/9780593422946, https://www.indiebound.org/book/9780593422946?aff=NYT
4                                  Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/0385548958?tag=NYTBSREV-20, https://goto.applebooks.apple/9780385548953?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385548953, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FTHE%2BEXCHANGE%2FJohn%2BGrisham%2F9780385548953, https://bookshop.org/a/3546/9780385548953, https://www.indiebound.org/book/9780385548953?aff=NYT
5                       Amazon, Apple Books, Barnes and Noble, Books-A-Million, Bookshop, IndieBound, https://www.amazon.com/dp/038554734X?tag=NYTBSREV-20, https://goto.applebooks.apple/9780385547345?at=10lIEQ, https://www.anrdoezrs.net/click-7990613-11819508?url=https%3A%2F%2Fwww.barnesandnoble.com%2Fw%2F%3Fean%3D9780385547345, https://www.anrdoezrs.net/click-7990613-35140?url=https%3A%2F%2Fwww.booksamillion.com%2Fp%2FLESSONS%2BIN%2BCHEMISTRY%2FBonnie%2BGarmus%2F9780385547345, https://bookshop.org/a/3546/9780385547345, https://www.indiebound.org/book/9780385547345?aff=NYT
                                         book_uri
1 nyt://book/106c2cf0-7d20-51b1-bad4-91c3ebcd131a
2 nyt://book/d3c570c9-3c3a-5c8b-a740-85ea5e92bfc9
3 nyt://book/7d47b076-7ad7-539c-a051-6664384636b9
4 nyt://book/52c31163-754f-58c8-90d8-ea1f297f7030
5 nyt://book/717e0ead-9782-567d-af27-d9a6cfb1856f

Updating results for new data

Finally, we can combine some of these functions into a larger function that we can run every week to update our results.

download_data <- function() {
  # automatically pull today's date
  dates <- seq(Sys.Date(), by = -7, length.out = 12)
  bestseller_lists <- lapply(
    dates,
    function(x) {
      # slow down execution by waiting 12 seconds
      Sys.sleep(12)
      jsonlite::fromJSON(
        paste0(
          "https://api.nytimes.com/svc/books/v3/lists/",
          x,
          "/hardcover-fiction.json?api-key=",
          api_key
        )
      )$results$books
    }
  )
  names(bestseller_lists) <- dates
  return(bestseller_lists)
}
generate_plot <- function() {
  # Add code here . . .
}