DATA 607 NYT API
Susanna Wong
2023-03-23
Assignment Prompt
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.
Retreive Data from API
I sign up for an API key on the New York Times website. I will be retrieving JSON data related to movie reviews
Connect to New York Times API
We will use GET() function from the HTTR package to make a request to retrieve data from New York Times API. The status is 200, which indicates a successful request. A status of 401 indicates a unsuccessful request due to unauthorization. For more information regarding other status number, look here .
library(jsonlite)
library(httr)
library(DT)
movies_url <- "https://api.nytimes.com/svc/movies/v2/reviews/picks.json?&api-key=lUEiZ4B7FNb2Nh9v3Xpy8w14vTaPAapg"
mov_response = GET(movies_url) #response from the request GET()
mov_response## Response [https://api.nytimes.com/svc/movies/v2/reviews/picks.json?&api-key=lUEiZ4B7FNb2Nh9v3Xpy8w14vTaPAapg]
## Date: 2023-03-27 02:19
## Status: 200
## Content-Type: application/json; charset=utf-8
## Size: 15.7 kBarticle_url <- "https://api.nytimes.com/svc/mostpopular/v2/viewed/1.json?api-key=W3DrQnpNWXQ253JBiRWf6Vo0AX1w1BSI"
article_response = GET(article_url)
article_response## Response [https://api.nytimes.com/svc/mostpopular/v2/viewed/1.json?api-key=W3DrQnpNWXQ253JBiRWf6Vo0AX1w1BSI]
## Date: 2023-03-27 02:19
## Status: 200
## Content-Type: application/json; charset=utf-8
## Size: 34.2 kBJSON Data
Movie Reviews
NYT_content <- rawToChar(mov_response$content)
data = fromJSON(rawToChar(mov_response$content), flatten = TRUE)
names(data)## [1] "status" "copyright" "has_more" "num_results" "results"data <- as.data.frame(data)
data## status copyright
## 1 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 2 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 3 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 4 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 5 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 6 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 7 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 8 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 9 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 10 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 11 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 12 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 13 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 14 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 15 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 16 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 17 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 18 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 19 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 20 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## has_more num_results results.display_title
## 1 TRUE 20 Tori and Lokita
## 2 TRUE 20 The Worst Ones
## 3 TRUE 20 Petite Solange
## 4 TRUE 20 Reggie
## 5 TRUE 20 Nam June Paik: Moon Is the Oldest TV
## 6 TRUE 20 Walk Up
## 7 TRUE 20 The Lost King
## 8 TRUE 20 The Five Devils
## 9 TRUE 20 Rimini
## 10 TRUE 20 Drylongso
## 11 TRUE 20 The Innocent
## 12 TRUE 20 Chang Can Dunk
## 13 TRUE 20 Stonewalling
## 14 TRUE 20 Punch
## 15 TRUE 20 Therapy Dogs
## 16 TRUE 20 Split at the Root
## 17 TRUE 20 Linoleum
## 18 TRUE 20 A House Made of Splinters
## 19 TRUE 20 Emily
## 20 TRUE 20 Huesera: The Bone Woman
## results.mpaa_rating results.critics_pick results.byline
## 1 1 Manohla Dargis
## 2 1 Lisa Kennedy
## 3 1 Natalia Winkelman
## 4 PG-13 1 Glenn Kenny
## 5 1 Nicolas Rapold
## 6 1 Austin Considine
## 7 PG-13 1 Jeannette Catsoulis
## 8 1 Beatrice Loayza
## 9 1 Beatrice Loayza
## 10 R 1 Lisa Kennedy
## 11 1 Claire Shaffer
## 12 PG 1 Calum Marsh
## 13 1 Manohla Dargis
## 14 1 Kyle Turner
## 15 1 Brandon Yu
## 16 1 Concepción de León
## 17 1 Jeannette Catsoulis
## 18 1 Nicolas Rapold
## 19 R 1 Manohla Dargis
## 20 1 Natalia Winkelman
## results.headline
## 1 ‘Tori and Lokita’ Review: Precarious Lives in Exile
## 2 ‘The Worst Ones’ Review: The Gazes of Children
## 3 ‘Petite Solange’ Review: Coming of Age as Your Parents Divorce
## 4 ‘Reggie’ Review: Reggie Jackson on Himself, Racism and, Yes, Baseball
## 5 ‘Nam June Paik: Moon Is the Oldest TV’ Review: Art Onscreen
## 6 ‘Walk Up’ Review: Good Friends Make Bad Neighbors
## 7 ‘The Lost King’ Review: A Royal Obsession
## 8 ‘The Five Devils’ Review: The Scent of the Past
## 9 ‘Rimini’ Review: Just an Austrian Gigolo
## 10 ‘Drylongso’ Review: Extraordinary
## 11 ‘The Innocent’ Review: A Heist With a French Accent
## 12 ‘Chang Can Dunk’ Review: That’s a Man’s Jam
## 13 ‘Stonewalling’ Review: A Young Woman’s Exchange Value
## 14 ‘Punch’ Review: Hitting at the Heart
## 15 ‘Therapy Dogs’ Review: It’s Time to Be Real
## 16 ‘Split at the Root’ Review: A Powerful Lens on Immigrant Families Split Apart
## 17 ‘Linoleum’ Review: Rocket Plan
## 18 ‘A House Made of Splinters’ Review: Home Is Where the Hope Is
## 19 ‘Emily’ Review: A Brontë Sister’s Savage, Hardy and Free Life
## 20 ‘Huesera: The Bone Woman’ Review: What to Dread When You’re Expecting
## results.summary_short
## 1 In the new movie from the Dardenne brothers, two underage African migrants struggle to make a home in an unkind land.
## 2 In their feature, the directors Lisa Akoka and Romane Gueret build a provocative critique of filmmaking practices.
## 3 Axelle Ropert’s carefully calibrated film from France follows a girl experiencing the pain of having to accept her parents as people with faults.
## 4 Jackson, a.k.a. Mr. October, was called a lot of things during his storied career with the Yankees. A new documentary goes beyond the nicknames.
## 5 A new documentary follows the ceaseless innovations of a man who made art out of television sets and found inspiration in disruption.
## 6 Hong Sang-soo’s latest film traces the relationships in a small Seoul apartment building as they evolve and grow heavier with complications.
## 7 Sally Hawkins lights a fire under this droll dramedy about the search for the final resting place of Richard III.
## 8 Part queer love story, part supernatural psychodrama, the uncanny second feature by Léa Mysius follows a young girl with a magical sense of smell.
## 9 The director Ulrich Seidl’s unsettling drama tracks the exploitative behaviors of an aging lounge singer, his fans and family members.
## 10 Cauleen Smith’s 1998 movie, set in Oakland in the mid-90s, remains a vivid and prescient feature debut.
## 11 A light, enjoyable confection of a film that is built upon an amusingly absurd premise.
## 12 A short teen channels his inner Kobe Bryant in this exhilarating, warmhearted Disney+ basketball comedy.
## 13 In this haunting drama, a 20-year-old Chinese woman struggles to find her place in a country where she faces a series of seemingly impossible hurdles.
## 14 Welby Ings’s keenly observant debut feature follows a young, promising boxer whose priorities shift.
## 15 This low-budget film by a pair of high schoolers offers a bracing, impressionistic portrait of senior year as it’s happening.
## 16 This documentary shows the plight of one woman as she tries to reunite with her sons and make a permanent home in the United States.
## 17 Jim Gaffigan plays a dual role as rival scientists in this mysterious yet surprisingly effective movie.
## 18 This film, an Oscar nominee this year for best documentary feature, has an aching sensitivity for the children in a Ukraine shelter.
## 19 Blending fact with generous, liberating fiction, the director Frances O’Connor brings the author of “Wuthering Heights” to pleasurable life.
## 20 In Michelle Garza Cervera’s terrifying and transfixing debut feature, a pregnant woman battles visions of a demoness who threatens her body and mind.
## results.publication_date results.opening_date results.date_updated
## 1 2023-03-23 <NA> 2023-03-23 17:46:51
## 2 2023-03-23 2023-03-24 2023-03-23 16:44:03
## 3 2023-03-23 <NA> 2023-03-23 15:29:03
## 4 2023-03-23 2023-03-24 2023-03-23 11:05:02
## 5 2023-03-23 2023-03-24 2023-03-23 11:07:02
## 6 2023-03-23 <NA> 2023-03-23 11:06:03
## 7 2023-03-23 <NA> 2023-03-23 11:02:10
## 8 2023-03-23 <NA> 2023-03-23 11:01:03
## 9 2023-03-16 <NA> 2023-03-16 18:56:03
## 10 2023-03-16 <NA> 2023-03-16 14:24:50
## 11 2023-03-16 <NA> 2023-03-16 11:04:02
## 12 2023-03-10 2023-03-10 2023-03-10 08:02:03
## 13 2023-03-09 <NA> 2023-03-09 19:08:05
## 14 2023-03-09 <NA> 2023-03-09 16:17:03
## 15 2023-03-08 <NA> 2023-03-08 12:01:03
## 16 2023-03-02 <NA> 2023-03-02 12:03:10
## 17 2023-02-23 <NA> 2023-02-23 12:02:04
## 18 2023-02-22 2023-02-21 2023-02-22 19:47:03
## 19 2023-02-16 <NA> 2023-02-16 18:18:03
## 20 2023-02-09 2023-02-10 2023-02-09 15:33:15
## results.link.type
## 1 article
## 2 article
## 3 article
## 4 article
## 5 article
## 6 article
## 7 article
## 8 article
## 9 article
## 10 article
## 11 article
## 12 article
## 13 article
## 14 article
## 15 article
## 16 article
## 17 article
## 18 article
## 19 article
## 20 article
## results.link.url
## 1 https://www.nytimes.com/2023/03/23/movies/tori-and-lokita-review-dardenne.html
## 2 https://www.nytimes.com/2023/03/23/movies/the-worst-ones-review.html
## 3 https://www.nytimes.com/2023/03/23/movies/petite-solange-review.html
## 4 https://www.nytimes.com/2023/03/23/movies/reggie-review.html
## 5 https://www.nytimes.com/2023/03/23/movies/nam-june-paik-moon-is-the-oldest-tv-review.html
## 6 https://www.nytimes.com/2023/03/23/movies/walk-up-review.html
## 7 https://www.nytimes.com/2023/03/23/movies/the-lost-king-review.html
## 8 https://www.nytimes.com/2023/03/23/movies/the-five-devils-review.html
## 9 https://www.nytimes.com/2023/03/16/movies/rimini-review.html
## 10 https://www.nytimes.com/2023/03/16/movies/drylongso-review.html
## 11 https://www.nytimes.com/2023/03/16/movies/the-innocent-review-a-heist-with-a-french-accent.html
## 12 https://www.nytimes.com/2023/03/10/movies/chang-can-dunk-review.html
## 13 https://www.nytimes.com/2023/03/09/movies/stonewalling-review.html
## 14 https://www.nytimes.com/2023/03/09/movies/punch-review.html
## 15 https://www.nytimes.com/2023/03/08/movies/therapy-dogs-review.html
## 16 https://www.nytimes.com/2023/03/02/movies/split-at-the-root-review.html
## 17 https://www.nytimes.com/2023/02/23/movies/linoleum-review-rocket-plan.html
## 18 https://www.nytimes.com/2023/02/22/movies/a-house-made-of-splinters-review.html
## 19 https://www.nytimes.com/2023/02/16/movies/emily-review-bronte-wuthering-heights.html
## 20 https://www.nytimes.com/2023/02/09/movies/huesera-the-bone-woman-review.html
## results.link.suggested_link_text
## 1 Read the New York Times Review of Tori and Lokita
## 2 Read the New York Times Review of The Worst Ones
## 3 Read the New York Times Review of Petite Solange
## 4 Read the New York Times Review of Reggie
## 5 Read the New York Times Review of Nam June Paik: Moon Is the Oldest TV
## 6 Read the New York Times Review of Walk Up
## 7 Read the New York Times Review of The Lost King
## 8 Read the New York Times Review of The Five Devils
## 9 Read the New York Times Review of Rimini
## 10 Read the New York Times Review of Drylongso
## 11 Read the New York Times Review of The Innocent
## 12 Read the New York Times Review of Chang Can Dunk
## 13 Read the New York Times Review of Stonewalling
## 14 Read the New York Times Review of Punch
## 15 Read the New York Times Review of Therapy Dogs
## 16 Read the New York Times Review of Split at the Root
## 17 Read the New York Times Review of Linoleum
## 18 Read the New York Times Review of A House Made of Splinters
## 19 Read the New York Times Review of Emily
## 20 Read the New York Times Review of Huesera: The Bone Woman
## results.multimedia.type
## 1 mediumThreeByTwo210
## 2 mediumThreeByTwo210
## 3 mediumThreeByTwo210
## 4 mediumThreeByTwo210
## 5 mediumThreeByTwo210
## 6 mediumThreeByTwo210
## 7 mediumThreeByTwo210
## 8 mediumThreeByTwo210
## 9 mediumThreeByTwo210
## 10 mediumThreeByTwo210
## 11 mediumThreeByTwo210
## 12 mediumThreeByTwo210
## 13 mediumThreeByTwo210
## 14 mediumThreeByTwo210
## 15 mediumThreeByTwo210
## 16 mediumThreeByTwo210
## 17 mediumThreeByTwo210
## 18 mediumThreeByTwo210
## 19 mediumThreeByTwo210
## 20 mediumThreeByTwo210
## results.multimedia.src
## 1 https://static01.nyt.com/images/2023/03/23/multimedia/tori-lokita-mplb/tori-lokita-mplb-mediumThreeByTwo440.jpg
## 2 https://static01.nyt.com/images/2023/03/23/multimedia/23worst-ones-review-jhpw/23worst-ones-review-jhpw-mediumThreeByTwo440-v4.jpg
## 3 https://static01.nyt.com/images/2023/03/22/multimedia/petite1-cftq/petite1-cftq-mediumThreeByTwo440.jpg
## 4 https://static01.nyt.com/images/2023/03/23/multimedia/23reggie-review-jcqg/23reggie-review-jcqg-mediumThreeByTwo440.jpg
## 5 https://static01.nyt.com/images/2023/03/24/multimedia/23nam-june-paik-review1-kthm/23nam-june-paik-review1-kthm-mediumThreeByTwo440.jpg
## 6 https://static01.nyt.com/images/2023/03/24/multimedia/walkup1-kzml/walkup1-kzml-mediumThreeByTwo440.jpg
## 7 https://static01.nyt.com/images/2023/03/22/multimedia/lostking1-zklj/lostking1-zklj-mediumThreeByTwo440.jpg
## 8 https://static01.nyt.com/images/2023/03/22/multimedia/fivedevils1-wjpl/fivedevils1-wjpl-mediumThreeByTwo440.jpg
## 9 https://static01.nyt.com/images/2023/03/16/multimedia/16rimini-review-chpq/16rimini-review-chpq-mediumThreeByTwo440.jpg
## 10 https://static01.nyt.com/images/2023/03/17/multimedia/16drylongso-review-fvcl/16drylongso-review-fvcl-mediumThreeByTwo440.jpg
## 11 https://static01.nyt.com/images/2023/03/16/multimedia/16innocent-review-pix1-kbfj/16innocent-review-pix1-kbfj-mediumThreeByTwo440.jpg
## 12 https://static01.nyt.com/images/2023/03/10/multimedia/chang1-vqgp/chang1-vqgp-mediumThreeByTwo440.jpg
## 13 https://static01.nyt.com/images/2023/03/09/multimedia/09stonewalling2-lmgz/09stonewalling2-lmgz-mediumThreeByTwo440.jpg
## 14 https://static01.nyt.com/images/2023/03/09/multimedia/09punch-review-vkzq/09punch-review-vkzq-mediumThreeByTwo440.jpg
## 15 https://static01.nyt.com/images/2023/03/08/multimedia/08therapy-dogs-review1-pvct/08therapy-dogs-review1-pvct-mediumThreeByTwo440-v2.jpg
## 16 https://static01.nyt.com/images/2023/03/03/multimedia/02split-at-the-root-review-wcgq/02split-at-the-root-review-wcgq-mediumThreeByTwo440.jpg
## 17 https://static01.nyt.com/images/2023/02/24/multimedia/linoleum-kvgh/linoleum-kvgh-mediumThreeByTwo440.jpg
## 18 https://static01.nyt.com/images/2023/02/24/multimedia/22house-made-of-splinters-art-bptg/22house-made-of-splinters-art-bptg-mediumThreeByTwo440-v2.jpg
## 19 https://static01.nyt.com/images/2023/02/16/multimedia/16emily-review-bmqz/16emily-review-bmqz-mediumThreeByTwo440.jpg
## 20 https://static01.nyt.com/images/2023/02/08/multimedia/huesera1-zmtl/huesera1-zmtl-mediumThreeByTwo440.jpg
## results.multimedia.height results.multimedia.width
## 1 140 210
## 2 140 210
## 3 140 210
## 4 140 210
## 5 140 210
## 6 140 210
## 7 140 210
## 8 140 210
## 9 140 210
## 10 140 210
## 11 140 210
## 12 140 210
## 13 140 210
## 14 140 210
## 15 140 210
## 16 140 210
## 17 140 210
## 18 140 210
## 19 140 210
## 20 140 210Popular Articles
NYT_article <- rawToChar(article_response$content)
article_data = fromJSON(NYT_article , flatten = TRUE)
names(article_data)## [1] "status" "copyright" "num_results" "results"article_data <- as.data.frame(article_data)
article_data## status copyright
## 1 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 2 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 3 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 4 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 5 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 6 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 7 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 8 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 9 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 10 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 11 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 12 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 13 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 14 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 15 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 16 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 17 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 18 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 19 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## 20 OK Copyright (c) 2023 The New York Times Company. All Rights Reserved.
## num_results results.uri
## 1 20 nyt://article/5c326d97-c547-50e9-8ad0-83ee9305f543
## 2 20 nyt://article/939d1fbf-ac7c-5419-8d14-6b61f30f8df0
## 3 20 nyt://article/8223b6ba-1f47-5c37-928e-2f1928fe2768
## 4 20 nyt://article/6b4ca178-c19c-5d3f-a0bc-44d3fdc5d585
## 5 20 nyt://article/2d7003a4-3ba1-55ed-a447-54720d37ddf9
## 6 20 nyt://article/379b5e55-da01-5ca5-a4fb-72dfcaaa8173
## 7 20 nyt://article/c59d59b2-6d09-5edd-8925-d989dbb92062
## 8 20 nyt://article/81b8b00f-d015-5379-8a93-59a8d18e84b4
## 9 20 nyt://article/0aa8c28a-7191-5939-a6d0-65e166b9eee1
## 10 20 nyt://article/ad5e5fc4-8245-5d73-867f-aa89e7844d01
## 11 20 nyt://article/7320c766-b60e-5bb4-b5db-d6ad32d3c604
## 12 20 nyt://article/f7d8e632-ef00-56fb-9925-f21fed6ccf88
## 13 20 nyt://article/2fdf7eee-ec4b-5412-86ad-b40bbe6eeec3
## 14 20 nyt://article/52609e72-79b7-5f4b-b3f9-3402b1bd1301
## 15 20 nyt://article/ff858963-eb12-5e49-887e-d63813e251bf
## 16 20 nyt://article/da05852d-6829-5594-a547-1334dc1efff6
## 17 20 nyt://article/441d699b-26e7-5cec-b956-4afa77f65153
## 18 20 nyt://article/619ef7df-6e9b-58c2-aedf-3e8b5534f117
## 19 20 nyt://article/f36db063-2b1f-50c3-b899-7be88857e18d
## 20 20 nyt://article/66f260bd-65e6-5aa2-9de8-d7867b02faab
## results.url
## 1 https://www.nytimes.com/2023/03/25/world/europe/volunteers-us-ukraine-lies.html
## 2 https://www.nytimes.com/2023/03/24/us/fire-chocolate-factory-west-reading.html
## 3 https://www.nytimes.com/2023/03/22/health/beethoven-death-dna-hair.html
## 4 https://www.nytimes.com/2023/03/25/style/exclusive-gym-memberships.html
## 5 https://www.nytimes.com/2023/03/25/us/tornado-mississippi-storms-dead.html
## 6 https://www.nytimes.com/2023/03/25/opinion/great-salt-lake-drought-utah-climate-change.html
## 7 https://www.nytimes.com/2023/03/25/us/politics/trump-2024-rally-waco-texas.html
## 8 https://www.nytimes.com/2023/03/25/opinion/walking-hiking-spring.html
## 9 https://www.nytimes.com/2023/03/24/technology/gordon-moore-dead.html
## 10 https://www.nytimes.com/2023/03/24/travel/hotels-end-daily-cleaning.html
## 11 https://www.nytimes.com/2023/03/24/opinion/international-world/ellsberg-nuclear-war-ukraine.html
## 12 https://www.nytimes.com/2023/03/24/health/fda-duodenoscopes.html
## 13 https://www.nytimes.com/2023/03/23/realestate/mansion-tax-los-angeles.html
## 14 https://www.nytimes.com/article/best-movies-amazon-prime.html
## 15 https://www.nytimes.com/2023/03/24/us/politics/syria-us-contractor-killed-iran-drone.html
## 16 https://www.nytimes.com/2023/03/24/opinion/yuval-harari-ai-chatgpt.html
## 17 https://www.nytimes.com/2023/03/24/us/northern-lights-aurora-virginia-us.html
## 18 https://www.nytimes.com/2023/03/24/sports/ncaabasketball/march-madness-friday.html
## 19 https://www.nytimes.com/2023/03/24/health/covid-booster-older-immunocompromised.html
## 20 https://www.nytimes.com/article/best-movies-netflix.html
## results.id results.asset_id results.source results.published_date
## 1 1e+14 1e+14 New York Times 2023-03-25
## 2 1e+14 1e+14 New York Times 2023-03-24
## 3 1e+14 1e+14 New York Times 2023-03-22
## 4 1e+14 1e+14 New York Times 2023-03-25
## 5 1e+14 1e+14 New York Times 2023-03-25
## 6 1e+14 1e+14 New York Times 2023-03-25
## 7 1e+14 1e+14 New York Times 2023-03-25
## 8 1e+14 1e+14 New York Times 2023-03-25
## 9 1e+14 1e+14 New York Times 2023-03-24
## 10 1e+14 1e+14 New York Times 2023-03-24
## 11 1e+14 1e+14 New York Times 2023-03-24
## 12 1e+14 1e+14 New York Times 2023-03-24
## 13 1e+14 1e+14 New York Times 2023-03-23
## 14 1e+14 1e+14 New York Times 2020-09-10
## 15 1e+14 1e+14 New York Times 2023-03-24
## 16 1e+14 1e+14 New York Times 2023-03-24
## 17 1e+14 1e+14 New York Times 2023-03-24
## 18 1e+14 1e+14 New York Times 2023-03-24
## 19 1e+14 1e+14 New York Times 2023-03-24
## 20 1e+14 1e+14 New York Times 2020-09-10
## results.updated results.section results.subsection results.nytdsection
## 1 2023-03-26 08:25:41 World Europe world
## 2 2023-03-26 22:05:10 U.S. u.s.
## 3 2023-03-23 11:58:36 Health health
## 4 2023-03-26 17:11:09 Style style
## 5 2023-03-26 08:43:04 U.S. u.s.
## 6 2023-03-26 10:12:34 Opinion opinion
## 7 2023-03-25 21:58:23 U.S. Politics u.s.
## 8 2023-03-26 19:04:35 Opinion opinion
## 9 2023-03-26 20:33:21 Technology technology
## 10 2023-03-26 16:34:26 Travel travel
## 11 2023-03-25 09:41:58 Opinion Opinion | The World opinion
## 12 2023-03-25 15:43:57 Health health
## 13 2023-03-25 15:25:24 Real Estate real estate
## 14 2023-03-20 11:35:08 Arts arts
## 15 2023-03-26 22:04:08 U.S. Politics u.s.
## 16 2023-03-25 16:46:26 Opinion opinion
## 17 2023-03-24 18:57:09 U.S. u.s.
## 18 2023-03-25 13:31:49 Sports College Basketball sports
## 19 2023-03-26 09:41:44 Health health
## 20 2023-03-01 14:21:53 Movies movies
## results.adx_keywords
## 1 Russian Invasion of Ukraine (2022);Defense and Military Forces;Frauds and Swindling;Volunteers and Community Service;Ukraine;Russia;United States
## 2 Explosions (Accidental);Fires and Firefighters;Factories and Manufacturing;internal-storyline-no;Deaths (Fatalities);RM Palmer Co;West Reading (Pa)
## 3 Classical Music;DNA (Deoxyribonucleic Acid);Hair;Hepatitis;Genetics and Heredity;Liver;Poisoning and Poisons;Lead;Research;internal-sub-only;Genealogy;Beethoven, Ludwig van;Current Biology (Journal)
## 4 Health Clubs;Luxury Goods and Services;Exercise;United States
## 5 Tornadoes;Deaths (Fatalities);Mississippi;Alabama;Rolling Fork (Miss);Silver City (Miss)
## 6 Lakes;Global Warming;Water Pollution;Air Pollution;Hazardous and Toxic Substances;Conservation of Resources;Drought;Pelicans;Birds;Salt;Water;Agriculture and Farming;Metals and Minerals;Mormons (Church of Jesus Christ of Latter-Day Saints);Politics and Government;vis-photo;Great Salt Lake (Utah);Utah;Salt Lake City (Utah)
## 7 Presidential Election of 2024;Right-Wing Extremism and Alt-Right;Conspiracy Theories;Storming of the US Capitol (Jan, 2021);Trump, Donald J;Clifford, Stephanie (1979- );Bragg, Alvin;Republican Party;Waco (Tex)
## 8 Walking;Santiago de Compostela (Spain)
## 9 Deaths (Obituaries);Computers and the Internet;Computer Chips;Silicon;Philanthropy;Entrepreneurship;Moore, Gordon E;Noyce, Robert N;Intel Corporation;Fairchild Semiconductor International Inc.
## 10 Hotels and Travel Lodgings;Hygiene and Cleanliness;Organized Labor;Travel and Vacations;Quarantine (Life and Culture);American Hotel and Lodging Assn;United States
## 11 Pentagon Papers;Whistle-Blowers;Content Type: Personal Profile;Classified Information and State Secrets;Nuclear Weapons;United States Politics and Government;United States International Relations;Ellsberg, Daniel
## 12 your-feed-science;Medical Devices;Cameras;Digestive Tract;Bacteria;Consumer Protection;Defective Products;Food and Drug Administration;Olympus Corp;United States
## 13 Real Estate and Housing (Residential);Affordable Housing;Homeless Persons;Taxation;High Net Worth Individuals;California;Los Angeles (Calif)
## 14 Movies;Amazon.com Inc
## 15 Terrorism;Defense and Military Forces;United States International Relations;United States Defense and Military Forces;Drones (Pilotless Planes);Biden, Joseph R Jr;Defense Department;Islamic State in Iraq and Syria (ISIS);Iran;Syria
## 16 Artificial Intelligence;ChatGPT;Computers and the Internet;Social Media;Politics and Government;United States Politics and Government;internal-sub-only
## 17 Aurora Borealis;Earth;Solar Energy;Space and Astronomy;Weather;National Oceanic and Atmospheric Administration;United States;North Carolina
## 18 NCAA Basketball Championships (Women);Basketball (College);San Diego State University;University of Alabama;University of Miami;University of Houston
## 19 your-feed-science;Coronavirus (2019-nCoV);Vaccination and Immunization;Elderly;Immune System;Food and Drug Administration
## 20 Movies;Netflix Inc
## results.column
## 1 NA
## 2 NA
## 3 NA
## 4 NA
## 5 NA
## 6 NA
## 7 NA
## 8 NA
## 9 NA
## 10 NA
## 11 NA
## 12 NA
## 13 NA
## 14 NA
## 15 NA
## 16 NA
## 17 NA
## 18 NA
## 19 NA
## 20 NA
## results.byline
## 1 By Justin Scheck and Thomas Gibbons-Neff
## 2 By David DeKok, Amanda Holpuch and Michael Levenson
## 3 By Gina Kolata
## 4 By Danielle Braff
## 5 By Rick Rojas, Sarah Kramer Ozbun, Emily Cochrane and Richard Fausset
## 6 By Terry Tempest Williams and Fazal Sheikh
## 7 By Michael C. Bender and J. David Goodman
## 8 By Andrew McCarthy
## 9 By Holcomb B. Noble and Katie Hafner
## 10 By Danielle Braff
## 11 By Alex Kingsbury
## 12 By Roni Caryn Rabin
## 13 By Debra Kamin
## 14 By Jason Bailey
## 15 By Eric Schmitt
## 16 By Yuval Harari, Tristan Harris and Aza Raskin
## 17 By McKenna Oxenden
## 18 By The New York Times
## 19 By Apoorva Mandavilli
## 20 By Jason Bailey
## results.type
## 1 Article
## 2 Article
## 3 Article
## 4 Article
## 5 Article
## 6 Article
## 7 Article
## 8 Article
## 9 Article
## 10 Article
## 11 Article
## 12 Article
## 13 Article
## 14 Article
## 15 Article
## 16 Article
## 17 Article
## 18 Article
## 19 Article
## 20 Article
## results.title
## 1 Stolen Valor: The U.S. Volunteers in Ukraine Who Lie, Waste and Bicker
## 2 Death Toll in Chocolate Factory Explosion Rises to Seven
## 3 DNA From Beethoven’s Hair Unlocks Medical and Family Secrets
## 4 Think Getting Into College Is Hard? Try Applying for These Gyms.
## 5 At Least 26 Killed as Powerful Tornado Tears Through Mississippi
## 6 I Am Haunted by What I Have Seen at Great Salt Lake
## 7 As Trump Rallies in Waco, His Followers Shore Up His 2024 Bid
## 8 Whatever the Problem, It’s Probably Solved by Walking
## 9 Gordon E. Moore, Intel Co-Founder Behind Moore’s Law, Dies at 94
## 10 Say Goodbye to Daily Hotel Room Cleaning
## 11 The Man Who Leaked the Pentagon Papers Is Scared
## 12 These Devices Sickened Hundreds. The New Models Have Risks, Too.
## 13 For Sale: Mansions in Los Angeles at Bargain Prices
## 14 The Best Movies on Amazon Prime Video Right Now
## 15 Conflict in Syria Escalates Following Attack That Killed a U.S. Contractor
## 16 You Can Have the Blue Pill or the Red Pill, and We’re Out of Blue Pills
## 17 The Northern Lights Were Seen Farther South in the United States
## 18 What We Learned in March Madness on Friday
## 19 Should You Get Another Covid Booster?
## 20 The 50 Best Movies on Netflix Right Now
## results.abstract
## 1 People who would not be allowed anywhere near the battlefield in a U.S.-led war are active on the Ukrainian front, with ready access to American weapons.
## 2 One person was found alive in the rubble overnight on Friday after an explosion at the R.M. Palmer Company chocolate factory in West Reading, Pa., officials said.
## 3 By analyzing seven samples of hair said to have come from Ludwig van Beethoven, researchers debunked myths about the revered composer while raising new questions about his life and death.
## 4 A new crop of luxury gyms requires referrals, interviews and even, in some cases, medical evaluations. And that’s before paying a monthly fee of up to $2,750.
## 5 Dozens more were injured after a deadly tornado ripped through a rural area. The death toll is expected to rise.
## 6 The Latter-day Saints church has the moral authority and political sway to save Great Salt Lake.
## 7 Despite a pattern of dangerous, erratic behavior, the former president remains a strong front-runner for his party’s nomination. His durability stems from his most loyal supporters.
## 8 A walk begins to carve out space between my thoughts that allows clarity to rise up through my shoes.
## 9 His prediction in the 1960s about rapid advances in computer chip technology charted a course for the age of high tech.
## 10 The pandemic put a pause on many hotels’ guaranteed once-a-day cleanings. Now many of them are making the change permanent, even saying guests prefer it.
## 11 The whistle-blower Daniel Ellsberg has never run out of secrets.
## 12 Duodenoscopes — tubular cameras threaded into the intestine — with disposable parts were supposed to be safer. But the parts can fall off in the body, the F.D.A. warned.
## 13 Millionaire homeowners are trying to sell their houses before the city’s “mansion tax” goes into effect on April 1.
## 14 New films, and classics, just keep coming, but you don’t have to drill down to find the finest selections to stream. We’ll do the heavy lifting. You press play.
## 15 U.S. officials said the main air defense system at the coalition base was “not fully operational” at the time of Thursday’s attack, which killed a U.S. contractor and wounded six other Americans.
## 16 In games like chess, no human can hope to beat a computer. What happens when the same thing occurs in art, politics or religion?
## 17 A powerful geomagnetic storm helped to make the colorful aurora visible in places like North Carolina and Arizona on Thursday night.
## 18 San Diego State bothered the Crimson Tide with a physical style and slow pace. Miami pounced on Houston early and cruised in the second half.
## 19 Britain and Canada have authorized another round of booster shots for older and immunocompromised citizens. So far, U.S. officials haven’t followed suit.
## 20 Movies upon movies await, and you don't even have to drill down to find them.
## results.des_facet
## 1 Russian Invasion of Ukraine (2022), Defense and Military Forces, Frauds and Swindling, Volunteers and Community Service
## 2 Explosions (Accidental), Fires and Firefighters, Factories and Manufacturing, internal-storyline-no, Deaths (Fatalities)
## 3 Classical Music, DNA (Deoxyribonucleic Acid), Hair, Hepatitis, Genetics and Heredity, Liver, Poisoning and Poisons, Lead, Research, internal-sub-only, Genealogy
## 4 Health Clubs, Luxury Goods and Services, Exercise
## 5 Tornadoes, Deaths (Fatalities)
## 6 Lakes, Global Warming, Water Pollution, Air Pollution, Hazardous and Toxic Substances, Conservation of Resources, Drought, Pelicans, Birds, Salt, Water, Agriculture and Farming, Metals and Minerals, Mormons (Church of Jesus Christ of Latter-Day Saints), Politics and Government, vis-photo
## 7 Presidential Election of 2024, Right-Wing Extremism and Alt-Right, Conspiracy Theories, Storming of the US Capitol (Jan, 2021)
## 8 Walking
## 9 Deaths (Obituaries), Computers and the Internet, Computer Chips, Silicon, Philanthropy, Entrepreneurship
## 10 Hotels and Travel Lodgings, Hygiene and Cleanliness, Organized Labor, Travel and Vacations, Quarantine (Life and Culture)
## 11 Pentagon Papers, Whistle-Blowers, Content Type: Personal Profile, Classified Information and State Secrets, Nuclear Weapons, United States Politics and Government, United States International Relations
## 12 your-feed-science, Medical Devices, Cameras, Digestive Tract, Bacteria, Consumer Protection, Defective Products
## 13 Real Estate and Housing (Residential), Affordable Housing, Homeless Persons, Taxation, High Net Worth Individuals
## 14 Movies
## 15 Terrorism, Defense and Military Forces, United States International Relations, United States Defense and Military Forces, Drones (Pilotless Planes)
## 16 Artificial Intelligence, ChatGPT, Computers and the Internet, Social Media, Politics and Government, United States Politics and Government, internal-sub-only
## 17 Aurora Borealis, Earth, Solar Energy, Space and Astronomy, Weather
## 18 NCAA Basketball Championships (Women), Basketball (College)
## 19 your-feed-science, Coronavirus (2019-nCoV), Vaccination and Immunization, Elderly, Immune System
## 20 Movies
## results.org_facet
## 1
## 2 RM Palmer Co
## 3 Current Biology (Journal)
## 4
## 5
## 6
## 7 Republican Party
## 8
## 9 Intel Corporation, Fairchild Semiconductor International Inc.
## 10 American Hotel and Lodging Assn
## 11
## 12 Food and Drug Administration, Olympus Corp
## 13
## 14 Amazon.com Inc
## 15 Defense Department, Islamic State in Iraq and Syria (ISIS)
## 16
## 17 National Oceanic and Atmospheric Administration
## 18 San Diego State University, University of Alabama, University of Miami, University of Houston
## 19 Food and Drug Administration
## 20 Netflix Inc
## results.per_facet
## 1
## 2
## 3 Beethoven, Ludwig van
## 4
## 5
## 6
## 7 Trump, Donald J, Clifford, Stephanie (1979- ), Bragg, Alvin
## 8
## 9 Moore, Gordon E, Noyce, Robert N
## 10
## 11 Ellsberg, Daniel
## 12
## 13
## 14
## 15 Biden, Joseph R Jr
## 16
## 17
## 18
## 19
## 20
## results.geo_facet
## 1 Ukraine, Russia, United States
## 2 West Reading (Pa)
## 3
## 4 United States
## 5 Mississippi, Alabama, Rolling Fork (Miss), Silver City (Miss)
## 6 Great Salt Lake (Utah), Utah, Salt Lake City (Utah)
## 7 Waco (Tex)
## 8 Santiago de Compostela (Spain)
## 9
## 10 United States
## 11
## 12 United States
## 13 California, Los Angeles (Calif)
## 14
## 15 Iran, Syria
## 16
## 17 United States, North Carolina
## 18
## 19
## 20
## results.media
## 1 image, photo, Axel Vilhelmsen trained Ukrainian soldiers last year as part of the Mozart Group, which two former Marines established to help Ukraine. It disbanded after one founder sued the other, alleging theft and harassment., Laura Boushnak for The New York Times, 1, https://static01.nyt.com/images/2023/03/23/multimedia/00Ukraine-volunteers-01-fmbk/00Ukraine-volunteers-01-fmbk-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/23/multimedia/00Ukraine-volunteers-01-fmbk/00Ukraine-volunteers-01-fmbk-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/23/multimedia/00Ukraine-volunteers-01-fmbk/00Ukraine-volunteers-01-fmbk-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 2 NULL
## 3 image, photo, , Joseph Karl Stieler, via Beethoven-Haus Bonn, 0, https://static01.nyt.com/images/2023/03/22/multimedia/22beethoven-promo/22beethoven-promo-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/22/multimedia/22beethoven-promo/22beethoven-promo-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/22/multimedia/22beethoven-promo/22beethoven-promo-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 4 image, photo, Ghost, a gym in Williamsburg, is part of a new crop of luxury fitness centers requiring an extensive application process. “If you’re making widgets in Akron, Ohio, they may not want you,” said the founder of another gym., Hiroko Masuike/The New York Times, 1, https://static01.nyt.com/images/2023/03/26/fashion/INVITE-ONLY-GYMS-new-01-vlcw/INVITE-ONLY-GYMS-new-01-vlcw-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/26/fashion/INVITE-ONLY-GYMS-new-01-vlcw/INVITE-ONLY-GYMS-new-01-vlcw-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/26/fashion/INVITE-ONLY-GYMS-new-01-vlcw/INVITE-ONLY-GYMS-new-01-vlcw-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 5 image, photo, Silver City, Miss., in the aftermath of a tornado that sliced through the area on Friday night., Mississippi Highway Patrol Greenwood, 1, https://static01.nyt.com/images/2023/03/25/world/25xp-tornado/25xp-tornado-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/25/world/25xp-tornado/25xp-tornado-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/25/world/25xp-tornado/25xp-tornado-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 6 image, photo, , , 0, https://static01.nyt.com/images/2023/03/26/multimedia/23williams-19-wgpt/23williams-19-wgpt-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/26/multimedia/23williams-19-wgpt/23williams-19-wgpt-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/26/multimedia/23williams-19-wgpt/23williams-19-wgpt-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 7 image, photo, Early polls show that former President Donald J. Trump has a commanding advantage in the 2024 Republican primary field, though surveys also suggest that many G.O.P. voters would prefer another nominee., Rebecca Noble for The New York Times, 1, https://static01.nyt.com/images/2023/03/25/multimedia/25pol-trump-rally-vkpf/25pol-trump-rally-vkpf-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/25/multimedia/25pol-trump-rally-vkpf/25pol-trump-rally-vkpf-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/25/multimedia/25pol-trump-rally-vkpf/25pol-trump-rally-vkpf-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 8 image, photo, , Pierre Buttin, 1, https://static01.nyt.com/images/2023/03/26/opinion/25McCarthy/25McCarthy-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/26/opinion/25McCarthy/25McCarthy-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/26/opinion/25McCarthy/25McCarthy-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 9 image, photo, Gordon E. Moore in 1990 at the Silicon Valley headquarters of Intel, which he founded in 1968 with Robert Noyce. , Alamy, 1, https://static01.nyt.com/images/2021/01/19/obituaries/00moore-sub_gordon1/00moore-sub_gordon1-thumbStandard.jpg, https://static01.nyt.com/images/2021/01/19/obituaries/00moore-sub_gordon1/00moore-sub_gordon1-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2021/01/19/obituaries/00moore-sub_gordon1/00moore-sub_gordon1-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 10 image, photo, , Bianca Bagnarelli, 1, https://static01.nyt.com/images/2023/03/24/travel/24Hotel-room-cleaning-illo/24Hotel-room-cleaning-illo-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/24/travel/24Hotel-room-cleaning-illo/24Hotel-room-cleaning-illo-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/24/travel/24Hotel-room-cleaning-illo/24Hotel-room-cleaning-illo-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 11 image, photo, , Andres Gonzalez for The New York Times, 1, https://static01.nyt.com/images/2023/03/24/multimedia/24ellsberg_1-gfkh/24ellsberg_1-gfkh-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/24/multimedia/24ellsberg_1-gfkh/24ellsberg_1-gfkh-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/24/multimedia/24ellsberg_1-gfkh/24ellsberg_1-gfkh-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 12 image, photo, Duodenoscopes, which enter the upper part of the small intestine through the mouth to diagnose and treat diseases of the pancreas and the bile duct, are used in about 500,000 procedures a year in the U.S., Anze Furlan, via Shutterstock, 1, https://static01.nyt.com/images/2023/03/23/science/24scopes/Stasis-Photo-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/23/science/24scopes/Stasis-Photo-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/23/science/24scopes/Stasis-Photo-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 13 image, photo, Measure ULA, a transfer tax on big-ticket property sales in Los Angeles, goes into effect on April 1. The looming tax has sparked a frenzy in listings., Getty, 0, https://static01.nyt.com/images/2023/03/23/realestate/oakImage-1679588294671/oakImage-1679588294671-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/23/realestate/oakImage-1679588294671/oakImage-1679588294671-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/23/realestate/oakImage-1679588294671/oakImage-1679588294671-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 14 image, photo, Michael B. Jordan, center, and Sylvester Stallone, right, in “Creed.”, Warner Bros. Pictures, 1, https://static01.nyt.com/images/2015/11/25/arts/10new-best-amazon-CREED/25CREED-thumbStandard.jpg, https://static01.nyt.com/images/2015/11/25/arts/10new-best-amazon-CREED/25CREED-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2015/11/25/arts/10new-best-amazon-CREED/25CREED-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 15 NULL
## 16 NULL
## 17 image, photo, A powerful geomagnetic storm caused the northern lights to stretch southward in the United States on Thursday night., National Weather Service Gaylord, MI, 1, https://static01.nyt.com/images/2023/03/24/multimedia/24xp-Aurora-gbhk/24xp-Aurora-gbhk-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/24/multimedia/24xp-Aurora-gbhk/24xp-Aurora-gbhk-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/24/multimedia/24xp-Aurora-gbhk/24xp-Aurora-gbhk-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 18 image, photo, Lamont Butler of San Diego State guarding Alabama’s Jahvon Quinerly on Friday., Andy Lyons/Getty Images, 1, https://static01.nyt.com/images/2023/03/24/multimedia/24cbb-friday-quinerly-pglq/24cbb-friday-quinerly-pglq-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/24/multimedia/24cbb-friday-quinerly-pglq/24cbb-friday-quinerly-pglq-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/24/multimedia/24cbb-friday-quinerly-pglq/24cbb-friday-quinerly-pglq-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 19 image, photo, A woman receiving a fourth shot in September in Phoenix. While a Covid infection can be a matter of inconvenience for some, it can spell severe disease, hospitalization and death for older adults and immunocompromised people., Ash Ponders for The New York Times, 1, https://static01.nyt.com/images/2023/03/24/multimedia/24virus-booster-tvzf/24virus-booster-tvzf-thumbStandard.jpg, https://static01.nyt.com/images/2023/03/24/multimedia/24virus-booster-tvzf/24virus-booster-tvzf-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/03/24/multimedia/24virus-booster-tvzf/24virus-booster-tvzf-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## 20 image, photo, Daniel Craig and Janelle Monáe in “Glass Onion: A Knives Out Mystery.”, John Wilson/Netflix, via Associated Press, 1, https://static01.nyt.com/images/2023/01/03/multimedia/10new-best-netflix-glass-onion-1-ccb6/10new-best-netflix-glass-onion-1-ccb6-thumbStandard.jpg, https://static01.nyt.com/images/2023/01/03/multimedia/10new-best-netflix-glass-onion-1-ccb6/10new-best-netflix-glass-onion-1-ccb6-mediumThreeByTwo210.jpg, https://static01.nyt.com/images/2023/01/03/multimedia/10new-best-netflix-glass-onion-1-ccb6/10new-best-netflix-glass-onion-1-ccb6-mediumThreeByTwo440.jpg, Standard Thumbnail, mediumThreeByTwo210, mediumThreeByTwo440, 75, 140, 293, 75, 210, 440
## results.eta_id
## 1 0
## 2 0
## 3 0
## 4 0
## 5 0
## 6 0
## 7 0
## 8 0
## 9 0
## 10 0
## 11 0
## 12 0
## 13 0
## 14 0
## 15 0
## 16 0
## 17 0
## 18 0
## 19 0
## 20 0JSON data to Dataframe
Movies Review: Critic’s Pick
The data contains recent 20 critic’s movie picks on New York Times.
Remove columns
We do not need the following columns: status”, “has_more”, “num_results”, “results.opening_date”, “results.date_updated”, “results.link.type”, “results.link.suggested_link_text”, “results.multimedia.height”, “results.multimedia.width”.
Since most of the values in the ‘mpaa_rating’ column are missing, this column will be dropped.
names(data)## [1] "status" "copyright"
## [3] "has_more" "num_results"
## [5] "results.display_title" "results.mpaa_rating"
## [7] "results.critics_pick" "results.byline"
## [9] "results.headline" "results.summary_short"
## [11] "results.publication_date" "results.opening_date"
## [13] "results.date_updated" "results.link.type"
## [15] "results.link.url" "results.link.suggested_link_text"
## [17] "results.multimedia.type" "results.multimedia.src"
## [19] "results.multimedia.height" "results.multimedia.width"tidied_data <- data[c("copyright", "results.display_title", "results.critics_pick", "results.byline","results.headline", "results.summary_short","results.publication_date","results.link.url","results.multimedia.src" )]
colnames(tidied_data) <- c("copyright", "film_title", "critics_pick", "critic_name","NYT_headline", "short_summary","publication_date","link.url","multimedia.src" )
tidied_data <- tidied_data[c( "film_title","multimedia.src", "critics_pick", "critic_name","NYT_headline", "short_summary","publication_date","link.url", "copyright" )]
datatable(tidied_data,options = list(scrollX = TRUE), colnames=c("Movie Title","Movie Image", "Critic's Pick", "Critic Name","NYT Headline", "Short Summary","Publication Date","Article URL", "Copyright"))Display images
There is column that provides the images associated with the movie. In order to display, we need to append “<img src=” in front of every url and “‘height=’200’>” at the end of each URL.
# The code below helps us show the images from the provided URL in the 'multimedia.src' column. This code requires manual work of inserting each unique link
#tidied_data$multimedia.src[grep("https://static01.nyt.com/images/2023/03/23/multimedia/tori-lokita-mplb/tori-lokita-mplb-mediumThreeByTwo440.jpg", tidied_data$multimedia.src)] <- "<img src='https://static01.nyt.com/images/2023/03/23/multimedia/tori-lokita-mplb/tori-lokita-mplb-mediumThreeByTwo440.jpg'height='200'></img>'
# The code below helps us show the images from the provided URL in the 'multimedia.src' column. It is easier than above.
tidied_data$multimedia.src <- paste("<img src='", tidied_data$multimedia.src)
tidied_data$multimedia.src <- paste(tidied_data$multimedia.src, "'height='150'width='300'></img>")
datatable(tidied_data,options = list(scrollX = TRUE), escape = FALSE, colnames=c("Movie Title","multimedia.src", "Critic's Pick", "Critic Name","NYT Headline", "Short Summary","Publication Date","Article URL", "Copyright"))Popular Articles
The data contains 20 popular articles from New York Times.
Remove columns
We do not need the following columns: status”, “num_results”, “results.uri”, “results.id”, “results.asset_id”, results.source”, “results.updated”, “results.subsection”, “results.nytdsection”, “results.column”, “results.type”, “results.des_facet”, “results.org_facet”, “results.per_facet”, “results.geo_facet”, “results.media”, “results.eta_id”
names(article_data)## [1] "status" "copyright" "num_results"
## [4] "results.uri" "results.url" "results.id"
## [7] "results.asset_id" "results.source" "results.published_date"
## [10] "results.updated" "results.section" "results.subsection"
## [13] "results.nytdsection" "results.adx_keywords" "results.column"
## [16] "results.byline" "results.type" "results.title"
## [19] "results.abstract" "results.des_facet" "results.org_facet"
## [22] "results.per_facet" "results.geo_facet" "results.media"
## [25] "results.eta_id"article_data1 <- article_data[c("results.url", "results.published_date",
"results.section", "results.adx_keywords", "results.byline","results.title" ,"results.abstract")]
colnames(article_data1) <- c("article_url", "published_date",
"section", "adx_keywords", "author","article_title" ,"abstract")
article_data1 <- article_data1[c("published_date","article_title","author","section", "adx_keywords" ,"abstract","article_url"
)]
datatable(article_data1,options = list(scrollX = TRUE), colnames=c("Published Date","Article Title","Author","Section", "Adx keywords" ,"Abstract","Article URL"))Percentage of Article for Each Section
There are 11 sections:“World”, “U.S.”, “Health”, “Style”, “Opinion”, “Technology” “Travel”, “Real Estate”, “Arts”, “Sports”,“Movies”
library(tidyverse)
unique(article_data1$section)## [1] "World" "U.S." "Health" "Style" "Opinion"
## [6] "Technology" "Travel" "Real Estate" "Arts" "Sports"
## [11] "Movies"article_section <- article_data1 %>%
count(section) %>%
mutate(percentage = (n / 20)*100)
article_section %>%
arrange(desc(percentage)) %>%
ggplot(., aes(x = reorder(section, percentage), y = percentage)) +
geom_bar(stat = 'identity', fill = 'lightblue') +
coord_flip() + ggtitle("Percentage of Article for Each Section") +
theme(plot.title = element_text(hjust = 0.5)) +
ylab("Percentage of Article") +
xlab("Section")
Source
The link below provide information on how to request data from API in R. https://www.dataquest.io/blog/r-api-tutorial/
The link below provides the formatting of inserting images. https://stackoverflow.com/questions/62970417/rendering-images-in-dt-table-in-r-shiny