DATA 607
Load Packages
library(jsonlite)
library(knitr)
library(curl)I searched for hardcover fiction books on the NYT books list.
url <- curl(url = "https://api.nytimes.com/svc/books/v3/lists.json?list-name=hardcover-fiction&api-key=iVhtPRPmz4DRzhywxFicIrAeuGMRYQo9")
nyt_df <- fromJSON(url)
nyt_df## $status
## [1] "OK"
##
## $copyright
## [1] "Copyright (c) 2019 The New York Times Company. All Rights Reserved."
##
## $num_results
## [1] 15
##
## $last_modified
## [1] "2019-03-27T22:38:01-04:00"
##
## $results
## list_name display_name bestsellers_date published_date
## 1 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 2 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 3 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 4 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 5 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 6 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 7 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 8 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 9 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 10 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 11 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 12 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 13 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 14 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## 15 Hardcover Fiction Hardcover Fiction 2019-03-23 2019-04-07
## rank rank_last_week weeks_on_list asterisk dagger
## 1 1 1 29 0 0
## 2 2 0 1 0 0
## 3 3 0 1 0 0
## 4 4 2 2 0 0
## 5 5 3 3 0 0
## 6 6 4 3 0 0
## 7 7 5 7 0 0
## 8 8 9 3 0 0
## 9 9 6 3 0 0
## 10 10 7 5 0 0
## 11 11 8 6 0 0
## 12 12 14 11 1 0
## 13 13 11 3 0 0
## 14 14 12 22 0 0
## 15 15 0 14 0 0
## amazon_product_url
## 1 https://www.amazon.com/Where-Crawdads-Sing-Delia-Owens/dp/0735219095?tag=NYTBS-20
## 2 https://www.amazon.com/Run-Away-Harlan-Coben/dp/1538748460?tag=NYTBS-20
## 3 https://www.amazon.com/Celtic-Empire-Dirk-Pitt-Adventure-ebook/dp/B079R3KT4X?tag=NYTBS-20
## 4 https://www.amazon.com/Wolf-Pack-Pickett-Novel-Book-ebook/dp/B07FLZYJD8?tag=NYTBS-20
## 5 https://www.amazon.com/Cemetery-Road-Novel-Greg-Iles-ebook/dp/B07B7L4QMF?tag=NYTBS-20
## 6 https://www.amazon.com/Daisy-Jones-Taylor-Jenkins-Reid/dp/1524798622?tag=NYTBS-20
## 7 https://www.amazon.com/Silent-Patient-Alex-Michaelides/dp/1250301696?tag=NYTBS-20
## 8 https://www.amazon.com/Island-Sea-Women-Novel/dp/1501154850?tag=NYTBS-20
## 9 https://www.amazon.com/Silent-Night-Novel-Danielle-Steel-ebook/dp/B07DN22MKB?tag=NYTBS-20
## 10 https://www.amazon.com/Chef-James-Patterson-ebook/dp/B07HWPRDHM?tag=NYTBS-20
## 11 https://www.amazon.com/Last-Romantics-Novel-Tara-Conklin/dp/0062358200?tag=NYTBS-20
## 12 https://www.amazon.com/Girl-Greer-Hendricks/dp/1250133734?tag=NYTBS-20
## 13 https://www.amazon.com/Malta-Exchange-Novel-Cotton-Malone-ebook/dp/B07D2BV7LW?tag=NYTBS-20
## 14 https://www.amazon.com/Reckoning-Novel-John-Grisham-ebook/dp/B079DBS447?tag=NYTBS-20
## 15 https://www.amazon.com/Circe-Madeline-Miller/dp/0316556343?tag=NYTBS-20
## isbns
## 1 0735219095, 0735219117, 0525640371, 9780735219090, 9780735219113, 9780525640370
## 2 1538748460, 9781538748466
## 3 0735218994, 0735219001, 9780735218994, 9780735219007
## 4 0525538194, 0525538208, 9780525538196, 9780525538202
## 5 0062824619, 0062824635, 006282466X, 9780062824615, 9780062824639, 9780062824660
## 6 1524798622, 1524798630, 1984892258, 9781524798628, 9781524798635, 9781984892256
## 7 1250301696, 1250301718, 1250317541, 9781250301697, 9781250301710, 9781250317544
## 8 1501154850, 1501154877, 9781501154850, 9781501154874
## 9 0399179380, 0399179399, 1984884573, 9780399179389, 9780399179396, 9781984884572
## 10 0316453307, 031653000X, 0316532320, 9780316453301, 9780316530002, 9780316532327
## 11 0062358200, 0062358227, 0062887548, 9780062358202, 9780062358226, 9780062887542
## 12 1250133734, 1250133742, 9781250133731, 9781250133748
## 13 1250140269, 1250140277, 9781250140265, 9781250140272
## 14 0385544154, 0385544162, 052563925X, 0525639292, 0385544170, 9780385544153, 9780385544160, 9780525639251, 9780525639299, 9780385544177
## 15 0316556343, 0316556335, 1478975318, 1549171763, 1549142380, 0316556327, 9780316556347, 9780316556330, 9781478975311, 9781549171765, 9781549142383, 9780316556323
## book_details
## 1 WHERE THE CRAWDADS SING, A woman who survived alone in the marsh becomes a murder suspect., by Delia Owens, Delia Owens, , 0, , Putnam, 9780735219090, 0735219095
## 2 RUN AWAY, A family is torn apart when the daughter becomes addicted to drugs and goes missing., by Harlan Coben, Harlan Coben, , 0, , Grand Central, 9781538748466, 1538748460
## 3 CELTIC EMPIRE, The 25th book in the Dirk Pitt series., by Clive Cussler and Dirk Cussler, Clive Cussler and Dirk Cussler, , 0, , Putnam, 9780735218994, 0735218994
## 4 WOLF PACK, The Wyoming game wardens Joe Pickett and Katelyn Hamm take on killers working for the Sinaloa cartel., by C.J. Box, CJ Box, , 0, , Putnam, 9780525538196, 0525538194
## 5 CEMETERY ROAD, The journalist Marshall McEwan returns to his hometown, which is shaken by two deaths and an economy on the brink., by Greg Iles, Greg Iles, , 0, , Morrow, 9780062824615, 0062824619
## 6 DAISY JONES & THE SIX, A fictional oral history charting the rise and fall of a ’70s rock ’n’ roll band., by Taylor Jenkins Reid, Taylor Jenkins Reid, , 0, , Ballantine, 9781524798628, 1524798622
## 7 THE SILENT PATIENT, Theo Faber looks into the mystery of a famous painter who stops speaking after shooting her husband., by Alex Michaelides, Alex Michaelides, , 0, , Celadon, 9781250301697, 1250301696
## 8 THE ISLAND OF SEA WOMEN, The friendship over many decades of two female divers from the Korean Island of Jeju is pushed to a breaking point., by Lisa See, Lisa See, , 0, , Scribner, 9781501154850, 1501154850
## 9 SILENT NIGHT, After tragedy strikes, a child TV star loses her memory and ability to speak., by Danielle Steel, Danielle Steel, , 0, , Delacorte, 9780399179389, 0399179380
## 10 THE CHEF, Caleb Rooney, a police detective and celebrity food truck chef, must clear his name of murder allegations., by James Patterson with Max DiLallo, James Patterson with Max DiLallo, , 0, , Little, Brown, 9780316453301, 0316453307
## 11 THE LAST ROMANTICS, A family crisis tests the bonds and ideals of a renowned poet and her siblings., by Tara Conklin, Tara Conklin, , 0, , Morrow, 9780062358202, 0062358200
## 12 AN ANONYMOUS GIRL, Jessica Farris’s life unravels when she signs up for Dr. Shields’s psychology study., by Greer Hendricks and Sarah Pekkanen, Greer Hendricks and Sarah Pekkanen, , 0, , St. Martin's, 9781250314208, None
## 13 THE MALTA EXCHANGE, The 14th book in the Cotton Malone series. The former Justice Department operative tangles with a rogue cardinal and an ancient sect of knights., by Steve Berry, Steve Berry, , 0, , Minotaur, 9781250239723, None
## 14 THE RECKONING, A decorated World War II veteran shoots and kills a pastor., by John Grisham, John Grisham, , 0, , Doubleday, 9780385544153, 0385544154
## 15 CIRCE, Zeus banishes Helios' daughter to an island, where she must choose between living with gods or mortals., by Madeline Miller, Madeline Miller, , 0, , Little, Brown, 9780316556347, 0316556343
## reviews
## 1 , , ,
## 2 , , ,
## 3 , , ,
## 4 , , ,
## 5 , , ,
## 6 https://www.nytimes.com/2019/03/04/books/review/daisy-jones-six-taylor-jenkins-reid.html, , ,
## 7 , , ,
## 8 , , ,
## 9 , , ,
## 10 , , ,
## 11 , , ,
## 12 , , ,
## 13 , , ,
## 14 , , ,
## 15 https://www.nytimes.com/2018/05/28/books/review/circe-madeline-miller.html, , ,