The New York Times web site provides a rich set of APIs, as described here: (https://developer.nytimes.com/apis)
You’ll need to start by signing up for an API key.
Your task is to choose one of the New York Times APIs, construct an interface in R to read in the JSON data, and transform it into an R DataFrame.
library(httr)
library(jsonlite)books_url <- ("https://api.nytimes.com/svc/books/v3/lists/names.json?api-key=lB6izVNFT7zMy5s1eRiPKwEAfBlAyctS")
books <- GET(books_url)
books2 <- fromJSON(content(books, type = "text"))## No encoding supplied: defaulting to UTF-8.books_dataframe <- as.data.frame(books2)
books_dataframe## status copyright
## 1 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 2 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 3 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 4 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 5 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 6 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 7 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 8 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 9 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 10 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 11 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 12 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 13 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 14 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 15 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 16 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 17 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 18 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 19 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 20 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 21 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 22 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 23 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 24 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 25 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 26 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 27 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 28 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 29 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 30 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 31 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 32 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 33 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 34 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 35 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 36 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 37 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 38 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 39 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 40 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 41 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 42 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 43 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 44 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 45 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 46 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 47 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 48 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 49 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 50 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 51 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 52 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 53 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 54 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 55 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 56 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 57 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 58 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## 59 OK Copyright (c) 2024 The New York Times Company. All Rights Reserved.
## num_results results.list_name
## 1 59 Combined Print and E-Book Fiction
## 2 59 Combined Print and E-Book Nonfiction
## 3 59 Hardcover Fiction
## 4 59 Hardcover Nonfiction
## 5 59 Trade Fiction Paperback
## 6 59 Mass Market Paperback
## 7 59 Paperback Nonfiction
## 8 59 E-Book Fiction
## 9 59 E-Book Nonfiction
## 10 59 Hardcover Advice
## 11 59 Paperback Advice
## 12 59 Advice How-To and Miscellaneous
## 13 59 Hardcover Graphic Books
## 14 59 Paperback Graphic Books
## 15 59 Manga
## 16 59 Combined Print Fiction
## 17 59 Combined Print Nonfiction
## 18 59 Chapter Books
## 19 59 Childrens Middle Grade
## 20 59 Childrens Middle Grade E-Book
## 21 59 Childrens Middle Grade Hardcover
## 22 59 Childrens Middle Grade Paperback
## 23 59 Paperback Books
## 24 59 Picture Books
## 25 59 Series Books
## 26 59 Young Adult
## 27 59 Young Adult E-Book
## 28 59 Young Adult Hardcover
## 29 59 Young Adult Paperback
## 30 59 Animals
## 31 59 Audio Fiction
## 32 59 Audio Nonfiction
## 33 59 Business Books
## 34 59 Celebrities
## 35 59 Crime and Punishment
## 36 59 Culture
## 37 59 Education
## 38 59 Espionage
## 39 59 Expeditions Disasters and Adventures
## 40 59 Fashion Manners and Customs
## 41 59 Food and Fitness
## 42 59 Games and Activities
## 43 59 Graphic Books and Manga
## 44 59 Hardcover Business Books
## 45 59 Health
## 46 59 Humor
## 47 59 Indigenous Americans
## 48 59 Relationships
## 49 59 Mass Market Monthly
## 50 59 Middle Grade Paperback Monthly
## 51 59 Paperback Business Books
## 52 59 Family
## 53 59 Hardcover Political Books
## 54 59 Race and Civil Rights
## 55 59 Religion Spirituality and Faith
## 56 59 Science
## 57 59 Sports
## 58 59 Travel
## 59 59 Young Adult Paperback Monthly
## results.display_name
## 1 Combined Print & E-Book Fiction
## 2 Combined Print & E-Book Nonfiction
## 3 Hardcover Fiction
## 4 Hardcover Nonfiction
## 5 Paperback Trade Fiction
## 6 Paperback Mass-Market Fiction
## 7 Paperback Nonfiction
## 8 E-Book Fiction
## 9 E-Book Nonfiction
## 10 Hardcover Advice & Misc.
## 11 Paperback Advice & Misc.
## 12 Advice, How-To & Miscellaneous
## 13 Hardcover Graphic Books
## 14 Paperback Graphic Books
## 15 Manga
## 16 Combined Hardcover & Paperback Fiction
## 17 Combined Hardcover & Paperback Nonfiction
## 18 Children’s Chapter Books
## 19 Children’s Middle Grade
## 20 Children’s Middle Grade E-Book
## 21 Children’s Middle Grade Hardcover
## 22 Children’s Middle Grade Paperback
## 23 Children’s Paperback Books
## 24 Children’s Picture Books
## 25 Children’s Series
## 26 Young Adult
## 27 Young Adult E-Book
## 28 Young Adult Hardcover
## 29 Young Adult Paperback
## 30 Animals
## 31 Audio Fiction
## 32 Audio Nonfiction
## 33 Business
## 34 Celebrities
## 35 Crime and Punishment
## 36 Culture
## 37 Education
## 38 Espionage
## 39 Expeditions
## 40 Fashion, Manners and Customs
## 41 Food and Diet
## 42 Games and Activities
## 43 Graphic Books and Manga
## 44 Hardcover Business Books
## 45 Health
## 46 Humor
## 47 Indigenous Americans
## 48 Love and Relationships
## 49 Mass Market
## 50 Middle Grade Paperback
## 51 Paperback Business Books
## 52 Parenthood and Family
## 53 Politics and American History
## 54 Race and Civil Rights
## 55 Religion, Spirituality and Faith
## 56 Science
## 57 Sports and Fitness
## 58 Travel
## 59 Young Adult Paperback
## results.list_name_encoded results.oldest_published_date
## 1 combined-print-and-e-book-fiction 2011-02-13
## 2 combined-print-and-e-book-nonfiction 2011-02-13
## 3 hardcover-fiction 2008-06-08
## 4 hardcover-nonfiction 2008-06-08
## 5 trade-fiction-paperback 2008-06-08
## 6 mass-market-paperback 2008-06-08
## 7 paperback-nonfiction 2008-06-08
## 8 e-book-fiction 2011-02-13
## 9 e-book-nonfiction 2011-02-13
## 10 hardcover-advice 2008-06-08
## 11 paperback-advice 2008-06-08
## 12 advice-how-to-and-miscellaneous 2013-04-28
## 13 hardcover-graphic-books 2009-03-15
## 14 paperback-graphic-books 2009-03-15
## 15 manga 2009-03-15
## 16 combined-print-fiction 2011-02-13
## 17 combined-print-nonfiction 2011-02-13
## 18 chapter-books 2008-06-08
## 19 childrens-middle-grade 2012-12-16
## 20 childrens-middle-grade-e-book 2015-08-30
## 21 childrens-middle-grade-hardcover 2015-08-30
## 22 childrens-middle-grade-paperback 2015-08-30
## 23 paperback-books 2008-06-08
## 24 picture-books 2008-06-08
## 25 series-books 2008-06-08
## 26 young-adult 2012-12-16
## 27 young-adult-e-book 2015-08-30
## 28 young-adult-hardcover 2015-08-30
## 29 young-adult-paperback 2015-08-30
## 30 animals 2014-09-07
## 31 audio-fiction 2018-03-11
## 32 audio-nonfiction 2018-03-11
## 33 business-books 2013-11-03
## 34 celebrities 2014-09-07
## 35 crime-and-punishment 2014-10-12
## 36 culture 2014-10-12
## 37 education 2014-10-12
## 38 espionage 2014-12-14
## 39 expeditions-disasters-and-adventures 2014-12-14
## 40 fashion-manners-and-customs 2014-10-12
## 41 food-and-fitness 2013-09-01
## 42 games-and-activities 2014-10-12
## 43 graphic-books-and-manga 2019-10-13
## 44 hardcover-business-books 2011-07-03
## 45 health 2014-10-12
## 46 humor 2014-09-07
## 47 indigenous-americans 2014-12-14
## 48 relationships 2014-09-07
## 49 mass-market-monthly 2019-10-13
## 50 middle-grade-paperback-monthly 2019-10-13
## 51 paperback-business-books 2011-07-03
## 52 family 2014-09-07
## 53 hardcover-political-books 2011-07-03
## 54 race-and-civil-rights 2014-12-14
## 55 religion-spirituality-and-faith 2014-09-07
## 56 science 2013-04-14
## 57 sports 2014-03-02
## 58 travel 2014-09-07
## 59 young-adult-paperback-monthly 2019-10-13
## results.newest_published_date results.updated
## 1 2024-03-24 WEEKLY
## 2 2024-03-24 WEEKLY
## 3 2024-03-24 WEEKLY
## 4 2024-03-24 WEEKLY
## 5 2024-03-24 WEEKLY
## 6 2017-01-29 WEEKLY
## 7 2024-03-24 WEEKLY
## 8 2017-01-29 WEEKLY
## 9 2017-01-29 WEEKLY
## 10 2013-04-21 WEEKLY
## 11 2013-04-21 WEEKLY
## 12 2024-03-24 WEEKLY
## 13 2017-01-29 WEEKLY
## 14 2017-01-29 WEEKLY
## 15 2017-01-29 WEEKLY
## 16 2013-05-12 WEEKLY
## 17 2013-05-12 WEEKLY
## 18 2012-12-09 WEEKLY
## 19 2015-08-23 WEEKLY
## 20 2017-01-29 WEEKLY
## 21 2024-03-24 WEEKLY
## 22 2017-01-29 WEEKLY
## 23 2012-12-09 WEEKLY
## 24 2024-03-24 WEEKLY
## 25 2024-03-24 WEEKLY
## 26 2015-08-23 WEEKLY
## 27 2017-01-29 WEEKLY
## 28 2024-03-24 WEEKLY
## 29 2017-01-29 WEEKLY
## 30 2017-01-15 MONTHLY
## 31 2024-03-17 MONTHLY
## 32 2024-03-17 MONTHLY
## 33 2024-03-17 MONTHLY
## 34 2017-01-15 MONTHLY
## 35 2017-01-15 MONTHLY
## 36 2017-01-15 MONTHLY
## 37 2017-01-15 MONTHLY
## 38 2017-01-15 MONTHLY
## 39 2017-01-15 MONTHLY
## 40 2017-01-15 MONTHLY
## 41 2017-01-15 MONTHLY
## 42 2017-01-15 MONTHLY
## 43 2024-03-17 MONTHLY
## 44 2013-10-13 MONTHLY
## 45 2017-01-15 MONTHLY
## 46 2017-01-15 MONTHLY
## 47 2016-01-10 MONTHLY
## 48 2017-01-15 MONTHLY
## 49 2024-03-17 MONTHLY
## 50 2024-03-17 MONTHLY
## 51 2013-10-13 MONTHLY
## 52 2017-01-15 MONTHLY
## 53 2017-01-15 MONTHLY
## 54 2017-01-15 MONTHLY
## 55 2017-01-15 MONTHLY
## 56 2019-09-15 MONTHLY
## 57 2019-09-15 MONTHLY
## 58 2017-01-15 MONTHLY
## 59 2024-03-17 MONTHLY