response <- GET("https://api.nytimes.com/svc/books/v3/lists.json?list=hardcover-fiction&api-key=Mf6q45GOp16AVREtOZMcsnFIO0jcUHcm")
data = fromJSON(rawToChar(response$content))
content <- response$content
char <- rawToChar(content)
books_text <- fromJSON(char)
lists <- books_text$results
list_df <- as.data.frame(lists)
list_df## list_name display_name bestsellers_date published_date rank
## 1 Hardcover Fiction Hardcover Fiction 2022-10-22 2022-11-06 1
## rank_last_week weeks_on_list asterisk dagger
## 1 0 1 0 0
## amazon_product_url isbns.isbn10
## 1 https://www.amazon.com/dp/0385548923?tag=NYTBSREV-20 0385548923
## isbns.isbn13 isbns.isbn10.1 isbns.isbn13.1 book_details.title
## 1 9780385548922 0385548931 9780385548939 THE BOYS FROM BILOXI
## book_details.description
## 1 Two childhood friends follow in their fathers’ footsteps, which puts them on opposite sides of the law.
## book_details.contributor book_details.author book_details.contributor_note
## 1 by John Grisham John Grisham
## book_details.price book_details.age_group book_details.publisher
## 1 0.00 Doubleday
## book_details.primary_isbn13 book_details.primary_isbn10
## 1 9780385548922 0385548923
## reviews.book_review_link reviews.first_chapter_link
## 1
## reviews.sunday_review_link reviews.article_chapter_link list_name.1
## 1 Hardcover Fiction
## display_name.1 bestsellers_date.1 published_date.1 rank.1 rank_last_week.1
## 1 Hardcover Fiction 2022-10-22 2022-11-06 2 0
## weeks_on_list.1 asterisk.1 dagger.1
## 1 1 0 0
## amazon_product_url.1 isbns.isbn10.2
## 1 https://www.amazon.com/dp/0063251922?tag=NYTBSREV-20 0063251922
## isbns.isbn13.2 isbns.isbn10.3 isbns.isbn13.3 book_details.title.1
## 1 9780063251922 006325199X 9780063251991 DEMON COPPERHEAD
## book_details.description.1
## 1 A reimagining of Charles Dickens’s “David Copperfield” set in the mountains of southern Appalachia.
## book_details.contributor.1 book_details.author.1
## 1 by Barbara Kingsolver Barbara Kingsolver
## book_details.contributor_note.1 book_details.price.1 book_details.age_group.1
## 1 0.00
## book_details.publisher.1 book_details.primary_isbn13.1
## 1 Harper 9780063251922
## book_details.primary_isbn10.1 reviews.book_review_link.1
## 1 0063251922
## reviews.first_chapter_link.1 reviews.sunday_review_link.1
## 1
## reviews.article_chapter_link.1 list_name.2 display_name.2
## 1 Hardcover Fiction Hardcover Fiction
## bestsellers_date.2 published_date.2 rank.2 rank_last_week.2 weeks_on_list.2
## 1 2022-10-22 2022-11-06 3 2 7
## asterisk.2 dagger.2 amazon_product_url.2
## 1 0 0 https://www.amazon.com/dp/1668002175?tag=NYTBSREV-20
## isbns.isbn10.4 isbns.isbn13.4 isbns.isbn10.5 isbns.isbn13.5 isbns.isbn10.6
## 1 1668002175 9781668002179 1668002183
## isbns.isbn13.6 isbns.isbn10.7 isbns.isbn13.7 book_details.title.2
## 1 9781668002186 1797145282 9781797145280 FAIRY TALE
## book_details.description.2
## 1 A high school kid inherits a shed that is a portal to another world where good and evil are at war.
## book_details.contributor.2 book_details.author.2
## 1 by Stephen King Stephen King
## book_details.contributor_note.2 book_details.price.2 book_details.age_group.2
## 1 0.00
## book_details.publisher.2 book_details.primary_isbn13.2
## 1 Scribner 9781668002179
## book_details.primary_isbn10.2 reviews.book_review_link.2
## 1 1668002175
## reviews.first_chapter_link.2 reviews.sunday_review_link.2
## 1
## reviews.article_chapter_link.2 list_name.3 display_name.3
## 1 Hardcover Fiction Hardcover Fiction
## bestsellers_date.3 published_date.3 rank.3 rank_last_week.3 weeks_on_list.3
## 1 2022-10-22 2022-11-06 4 1 2
## asterisk.3 dagger.3 amazon_product_url.3
## 1 0 0 https://www.amazon.com/dp/1538719827?tag=NYTBSREV-20
## isbns.isbn10.8 isbns.isbn13.8 isbns.isbn10.9 isbns.isbn13.9 isbns.isbn10.10
## 1 1538719827 9781538719824 1538739763 9781538739761 1538719819
## isbns.isbn13.10 isbns.isbn10.11 isbns.isbn13.11 book_details.title.3
## 1 9781538719817 1538719797 9781538719794 LONG SHADOWS
## book_details.description.3
## 1 The seventh book in the Memory Man series. Decker works with a new partner to investigate a double homicide.
## book_details.contributor.3 book_details.author.3
## 1 by David Baldacci David Baldacci
## book_details.contributor_note.3 book_details.price.3 book_details.age_group.3
## 1 0.00
## book_details.publisher.3 book_details.primary_isbn13.3
## 1 Grand Central 9781538719824
## book_details.primary_isbn10.3 reviews.book_review_link.3
## 1 1538719827
## reviews.first_chapter_link.3 reviews.sunday_review_link.3
## 1
## reviews.article_chapter_link.3 list_name.4 display_name.4
## 1 Hardcover Fiction Hardcover Fiction
## bestsellers_date.4 published_date.4 rank.4 rank_last_week.4 weeks_on_list.4
## 1 2022-10-22 2022-11-06 5 4 5
## asterisk.4 dagger.4 amazon_product_url.4
## 1 0 0 https://www.amazon.com/dp/059344955X?tag=NYTBSREV-20
## isbns.isbn10.12 isbns.isbn13.12 isbns.isbn10.13 isbns.isbn13.13
## 1 059344955X 9780593449554 0593449568 9780593449561
## isbns.isbn10.14 isbns.isbn13.14 isbns.isbn10.15 isbns.isbn13.15
## 1 0593633237 9780593633236 0593633229 9780593633229
## book_details.title.4
## 1 DREAMLAND
## book_details.description.4
## 1 Musicians from different backgrounds are attracted to each other and a mother flees with her son from an abusive husband.
## book_details.contributor.4 book_details.author.4
## 1 by Nicholas Sparks Nicholas Sparks
## book_details.contributor_note.4 book_details.price.4 book_details.age_group.4
## 1 0.00
## book_details.publisher.4 book_details.primary_isbn13.4
## 1 Random House 9780593449554
## book_details.primary_isbn10.4 reviews.book_review_link.4
## 1 059344955X
## reviews.first_chapter_link.4 reviews.sunday_review_link.4
## 1
## reviews.article_chapter_link.4 list_name.5 display_name.5
## 1 Hardcover Fiction Hardcover Fiction
## bestsellers_date.5 published_date.5 rank.5 rank_last_week.5 weeks_on_list.5
## 1 2022-10-22 2022-11-06 6 5 3
## asterisk.5 dagger.5 amazon_product_url.5
## 1 0 0 https://www.amazon.com/dp/1984818384?tag=NYTBSREV-20
## isbns.isbn10.16 isbns.isbn13.16 isbns.isbn10.17 isbns.isbn13.17
## 1 1984818384 9781984818386 1984818392 9781984818393
## book_details.title.5
## 1 MAD HONEY
## book_details.description.5
## 1 After returning to her hometown, Olivia McAfee’s son gets accused of killing his crush.
## book_details.contributor.5
## 1 by Jodi Picoult and Jennifer Finney Boylan
## book_details.author.5 book_details.contributor_note.5
## 1 Jodi Picoult and Jennifer Finney Boylan
## book_details.price.5 book_details.age_group.5 book_details.publisher.5
## 1 0.00 Ballantine
## book_details.primary_isbn13.5 book_details.primary_isbn10.5
## 1 9781984818386 1984818384
## reviews.book_review_link.5 reviews.first_chapter_link.5
## 1
## reviews.sunday_review_link.5 reviews.article_chapter_link.5 list_name.6
## 1 Hardcover Fiction
## display_name.6 bestsellers_date.6 published_date.6 rank.6 rank_last_week.6
## 1 Hardcover Fiction 2022-10-22 2022-11-06 7 3
## weeks_on_list.6 asterisk.6 dagger.6
## 1 2 0 0
## amazon_product_url.6 isbns.isbn10.18
## 1 https://www.amazon.com/dp/1501101781?tag=NYTBSREV-20 1501101781
## isbns.isbn13.18 isbns.isbn10.19 isbns.isbn13.19 book_details.title.6
## 1 9781501101786 1501101803 9781501101809 THE MAZE
## book_details.description.6
## 1 The eighth book in the John Corey series. When a former lover offers him a job, Corey comes out of forced retirement to track a serial killer.
## book_details.contributor.6 book_details.author.6
## 1 by Nelson DeMille Nelson DeMille
## book_details.contributor_note.6 book_details.price.6 book_details.age_group.6
## 1 0.00
## book_details.publisher.6 book_details.primary_isbn13.6
## 1 Scribner 9781501101786
## book_details.primary_isbn10.6 reviews.book_review_link.6
## 1 1501101781
## reviews.first_chapter_link.6 reviews.sunday_review_link.6
## 1
## reviews.article_chapter_link.6 list_name.7 display_name.7
## 1 Hardcover Fiction Hardcover Fiction
## bestsellers_date.7 published_date.7 rank.7 rank_last_week.7 weeks_on_list.7
## 1 2022-10-22 2022-11-06 8 10 4
## asterisk.7 dagger.7 amazon_product_url.7
## 1 0 0 https://www.amazon.com/dp/1791392792?tag=NYTBSREV-20
## isbns.isbn10.20 isbns.isbn13.20 isbns.isbn10.21 isbns.isbn13.21
## 1 1791392792 9781791392796 153872474X 9781538724743
## isbns.isbn10.22 isbns.isbn13.22 isbns.isbn10.23 isbns.isbn13.23
## 1 1538724731 9781538724736 1538739720 9781538739723
## book_details.title.7
## 1 VERITY
## book_details.description.7
## 1 Lowen Ashleigh is hired by the husband of an injured writer to complete her popular series and uncovers a horrifying truth.
## book_details.contributor.7 book_details.author.7
## 1 by Colleen Hoover Colleen Hoover
## book_details.contributor_note.7 book_details.price.7 book_details.age_group.7
## 1 0.00
## book_details.publisher.7 book_details.primary_isbn13.7
## 1 Grand Central 9781538739723
## book_details.primary_isbn10.7 reviews.book_review_link.7
## 1 1538739720
## reviews.first_chapter_link.7 reviews.sunday_review_link.7
## 1
## reviews.article_chapter_link.7 list_name.8 display_name.8
## 1 Hardcover Fiction Hardcover Fiction
## bestsellers_date.8 published_date.8 rank.8 rank_last_week.8 weeks_on_list.8
## 1 2022-10-22 2022-11-06 9 6 3
## asterisk.8 dagger.8 amazon_product_url.8
## 1 0 0 https://www.amazon.com/dp/0593492544?tag=NYTBSREV-20
## isbns.isbn10.24 isbns.isbn13.24 book_details.title.8
## 1 0593492544 9780593492543 OUR MISSING HEARTS
## book_details.description.8
## 1 Twelve-year-old Bird Gardner goes on a quest to find his mother, a Chinese American poet whose work he was taught to disavow.
## book_details.contributor.8 book_details.author.8
## 1 by Celeste Ng Celeste Ng
## book_details.contributor_note.8 book_details.price.8 book_details.age_group.8
## 1 0.00
## book_details.publisher.8 book_details.primary_isbn13.8
## 1 Penguin Press 9780593492543
## book_details.primary_isbn10.8 reviews.book_review_link.8
## 1 0593492544
## reviews.first_chapter_link.8 reviews.sunday_review_link.8
## 1
## reviews.article_chapter_link.8 list_name.9 display_name.9
## 1 Hardcover Fiction Hardcover Fiction
## bestsellers_date.9 published_date.9 rank.9 rank_last_week.9 weeks_on_list.9
## 1 2022-10-22 2022-11-06 10 0 1
## asterisk.9 dagger.9 amazon_product_url.9
## 1 0 0 https://www.amazon.com/dp/0525509593?tag=NYTBSREV-20
## isbns.isbn10.25 isbns.isbn13.25 book_details.title.9
## 1 0525509593 9780525509592 LIBERATION DAY
## book_details.description.9
## 1 A collection of nine short stories by the author of “Lincoln in the Bardo,” which won the Man Booker Prize.
## book_details.contributor.9 book_details.author.9
## 1 by George Saunders George Saunders
## book_details.contributor_note.9 book_details.price.9 book_details.age_group.9
## 1 0.00
## book_details.publisher.9 book_details.primary_isbn13.9
## 1 Random House 9780525509592
## book_details.primary_isbn10.9 reviews.book_review_link.9
## 1 0525509593
## reviews.first_chapter_link.9 reviews.sunday_review_link.9
## 1
## reviews.article_chapter_link.9 list_name.10 display_name.10
## 1 Hardcover Fiction Hardcover Fiction
## bestsellers_date.10 published_date.10 rank.10 rank_last_week.10
## 1 2022-10-22 2022-11-06 11 0
## weeks_on_list.10 asterisk.10 dagger.10
## 1 1 0 0
## amazon_product_url.10 isbns.isbn10.26
## 1 https://www.amazon.com/dp/1501189271?tag=NYTBSREV-20 1501189271
## isbns.isbn13.26 book_details.title.10
## 1 9781501189272 THE LAST CHAIRLIFT
## book_details.description.10
## 1 The son of a competitive slalom skier returns to the hotel in Aspen where he was conceived and encounters some ghosts.
## book_details.contributor.10 book_details.author.10
## 1 by John Irving John Irving
## book_details.contributor_note.10 book_details.price.10
## 1 0.00
## book_details.age_group.10 book_details.publisher.10
## 1 Simon & Schuster
## book_details.primary_isbn13.10 book_details.primary_isbn10.10
## 1 9781501189272 1501189271
## reviews.book_review_link.10 reviews.first_chapter_link.10
## 1
## reviews.sunday_review_link.10 reviews.article_chapter_link.10
## 1
## list_name.11 display_name.11 bestsellers_date.11 published_date.11
## 1 Hardcover Fiction Hardcover Fiction 2022-10-22 2022-11-06
## rank.11 rank_last_week.11 weeks_on_list.11 asterisk.11 dagger.11
## 1 12 0 1 0 0
## amazon_product_url.11 isbns.isbn10.27
## 1 https://www.amazon.com/dp/0593500105?tag=NYTBSREV-20 0593500105
## isbns.isbn13.27 book_details.title.11
## 1 9780593500101 THE CHRISTMAS SPIRIT
## book_details.description.11
## 1 A pastor and a bartender discover love when they switch jobs during the holidays.
## book_details.contributor.11 book_details.author.11
## 1 by Debbie Macomber Debbie Macomber
## book_details.contributor_note.11 book_details.price.11
## 1 0.00
## book_details.age_group.11 book_details.publisher.11
## 1 Ballantine
## book_details.primary_isbn13.11 book_details.primary_isbn10.11
## 1 9780593500101 0593500105
## reviews.book_review_link.11 reviews.first_chapter_link.11
## 1
## reviews.sunday_review_link.11 reviews.article_chapter_link.11
## 1
## list_name.12 display_name.12 bestsellers_date.12 published_date.12
## 1 Hardcover Fiction Hardcover Fiction 2022-10-22 2022-11-06
## rank.12 rank_last_week.12 weeks_on_list.12 asterisk.12 dagger.12
## 1 13 9 3 0 0
## amazon_product_url.12 isbns.isbn10.28
## 1 https://www.amazon.com/dp/0593422473?tag=NYTBSREV-20 0593422473
## isbns.isbn13.28 isbns.isbn10.29 isbns.isbn13.29 isbns.isbn10.30
## 1 9780593422472 0593422481 9780593422489 059363263X
## isbns.isbn13.30 book_details.title.12
## 1 9780593632635 RIGHTEOUS PREY
## book_details.description.12
## 1 The 32nd book in the Prey series. Virgil Flowers and Lucas Davenport go after a group of vigilante killers.
## book_details.contributor.12 book_details.author.12
## 1 by John Sandford John Sandford
## book_details.contributor_note.12 book_details.price.12
## 1 0.00
## book_details.age_group.12 book_details.publisher.12
## 1 Putnam
## book_details.primary_isbn13.12 book_details.primary_isbn10.12
## 1 9780593422472 0593422473
## reviews.book_review_link.12 reviews.first_chapter_link.12
## 1
## reviews.sunday_review_link.12 reviews.article_chapter_link.12
## 1
## list_name.13 display_name.13 bestsellers_date.13 published_date.13
## 1 Hardcover Fiction Hardcover Fiction 2022-10-22 2022-11-06
## rank.13 rank_last_week.13 weeks_on_list.13 asterisk.13 dagger.13
## 1 14 12 25 0 0
## amazon_product_url.13 isbns.isbn10.31
## 1 https://www.amazon.com/dp/038554734X?tag=NYTBSREV-20 038554734X
## isbns.isbn13.31 isbns.isbn10.32 isbns.isbn13.32 book_details.title.13
## 1 9780385547345 0593507533 9780593507537 LESSONS IN CHEMISTRY
## book_details.description.13
## 1 A scientist and single mother living in California in the 1960s becomes a star on a TV cooking show.
## book_details.contributor.13 book_details.author.13
## 1 by Bonnie Garmus Bonnie Garmus
## book_details.contributor_note.13 book_details.price.13
## 1 0.00
## book_details.age_group.13 book_details.publisher.13
## 1 Doubleday
## book_details.primary_isbn13.13 book_details.primary_isbn10.13
## 1 9780385547345 038554734X
## reviews.book_review_link.13 reviews.first_chapter_link.13
## 1
## reviews.sunday_review_link.13 reviews.article_chapter_link.13
## 1
## list_name.14 display_name.14 bestsellers_date.14 published_date.14
## 1 Hardcover Fiction Hardcover Fiction 2022-10-22 2022-11-06
## rank.14 rank_last_week.14 weeks_on_list.14 asterisk.14 dagger.14
## 1 15 11 4 0 0
## amazon_product_url.14 isbns.isbn10.33
## 1 https://www.amazon.com/dp/1982112794?tag=NYTBSREV-20 1982112794
## isbns.isbn13.33 isbns.isbn10.34 isbns.isbn13.34 book_details.title.14
## 1 9781982112790 1982112816 9781982112813 THE WINNERS
## book_details.description.14
## 1 The third book in the Beartown series. Rivalries between two hockey-obsessed towns escalate into violence off the ice.
## book_details.contributor.14 book_details.author.14
## 1 by Fredrik Backman Fredrik Backman
## book_details.contributor_note.14 book_details.price.14
## 1 0.00
## book_details.age_group.14 book_details.publisher.14
## 1 Atria
## book_details.primary_isbn13.14 book_details.primary_isbn10.14
## 1 9781982112790 1982112794
## reviews.book_review_link.14 reviews.first_chapter_link.14
## 1
## reviews.sunday_review_link.14 reviews.article_chapter_link.14
## 1