Extract Yelp business profiles — name, address, phone, website, ratings, attributes, photos, review insights, popular dishes, and health inspections — by business URL or by location + keyword search. One clean row per business.
Sample
Here's a sample run for two San Francisco businesses — Molinari Delicatessen and Gary Danko — showing the exact schema and results you can expect, including ratings, attributes, review insights, popular dishes, photos, and health inspections.
| # | Business Name | Business URL | Address | Neighborhoods | Latitude | Longitude | Phone | Website | Menu URL | Rating | Total Reviews | Star Breakdown | Review Insights | Review Highlights | Popular Dishes | Attributes | Specialties | Summary | Year Established | History | Photos | Health Inspections | Hours (Today) | Q&A Count |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Molinari Delicatessen | 37.798 | -122.408 | +1 415-421-2337 | 4.4 | 1,593 | — | Historic Italian deli with meats sliced fresh to order, featuring an old-world atmosphere with hanging salamis and shelves lined with imported goods; known for its sandwiches on freshly baked focaccia. | — | — | 14 | |||||||||||||
2 | Gary Danko | 37.806 | -122.421 | +1 415-749-2060 | 4.5 | 6,129 | Twenty-six years after opening its doors in San Francisco’s iconic Fisherman’s Wharf neighborhood, Restaurant Gary Danko continues to refine its award-winning combination of classic French cooking, thoughtful and inventive use of local ingredients and personable yet impeccable service. “You don’t just open a great restaurant,” says Chef Gary Danko, “it’s a constant work in progress.” | Elegant fine dining with customizable multi-course menus and a romantic, dimly lit ambiance; standout dishes include lobster risotto and glazed oysters. | — | — | 38 | |||||||||||||
3 | Tartine Bakery | 37.762 | -122.424 | +1 415-487-2600 | 4.2 | 9,166 | A humble beginnings bakery making its way in the big city circa 2002. Chad and Liz had a dream to sell traditional style baked good and bread all while upholding high standards seen in both France and Germany. Today, we continue to follow in our founders foot steps by adhering to traditional style baking and sticking with quality ingredients. Although there are many other bakeries to visit in San Francisco, Tartine continues to be a staple in the baked good realm. You can catch us on Season 4 Episode 11 of "Somebody Feed Phil". Here at Tartine there is something for everyone. We hope to see you around! | Neighborhood bakery with communal tables and a lively atmosphere, known for its flaky chocolate croissants and rich banana cream pie, offering a grab-and-go option for those in a hurry. | — | — | 40 | |||||||||||||
4 | The Slanted Door | 37.796 | -122.394 | — | 3.6 | 5,804 | — | — | Modern Vietnamese food. | — | 1995 | — | — | — | 5 | |||||||||
5 | State Bird Provisions | 37.784 | -122.433 | +1 415-795-1272 | 4.2 | 3,560 | — | Dim sum-style dining with a rotating menu of New American dishes in a lively, bustling space featuring a unique tapas cart concept and standout items like the smoked trout dip and ricotta cheesecake. | 2011 | State Bird Provisions started as a recipe for serving quail and has slowly evolved into a restaurant without any programmed elements: think creative small plates passed around the dining room on carts and trays, dim sum-style, and a craftily-curated beer & wine list. | 26 | |||||||||||||
6 | Foreign Cinema | 37.756 | -122.419 | +1 415-648-7600 | 4 | 5,853 | Foreign Cinema opened in 1999 in San Francisco's Mission District. Offering eclectic California-Mediterranean cuisine, Foreign Cinema's Chefs/Owners Gayle Pirie and John Clark change the menu daily to reflect the finest organic, seasonal produce, meat and fish available.
Foreign Cinema provides an industrial chic setting with a warm yet lively vibe. The indoor dining room features a fireplace and open kitchen, and foreign and independent films are screened against the white wall in the covered outdoor patio. Adjacent to the restaurant, Laszlo Bar serves as the perfect stop to sip a cocktail after dinner with a bar program paying a playful homage to noteworthy classic and modern films with cocktails such as La Dolce Vita and Vertigo. | Chic dining spot with an outdoor courtyard for movie screenings and a cozy indoor space; features California-style cuisine with global influences and standout pork chop and madras fried chicken. | — | — | 43 | |||||||||||||
7 | Zuni Café | 37.774 | -122.422 | +1 415-552-2522 | 3.7 | 3,272 | — | Charming San Francisco staple with high ceilings and natural light, known for its legendary roast chicken with bread salad and addictive shoestring fries. | — | — | — | 9 | ||||||||||||
8 | BIX | 37.797 | -122.403 | +1 415-433-6300 | 4 | 2,180 | On a romantic alley in San Francisco's charming Jackson Square, a lone neon sign leads into a soaring room of fluted columns, mahogany paneling, plush banquettes and distinguished artwork.
Jacketed bartenders hold forth behind a gently curved bar, mixing what many have called the city's best classic cocktails. Variously described as a civilized speakeasy, a supper club and an elegant saloon, BIX offers modern American cuisine served in a soaring two-story dining room to the strains of live jazz nightly.
Stay updated on our specials and what we're up to at facebook.com/bixrestaurant. | A hidden alleyway gem with a vintage supper club vibe, featuring live jazz and dim lighting, where potato pillows with caviar and Dungeness crab croquettes stand out among the classic decor and high ceilings. | 1988 | Through the years, BIX has been featured in movies, magazines, books and commercials as the quintessential San Francisco restaurant.The ambiance is pure 1930s and '40s -- tasteful art moderne reminiscent of the glory days of Cunard and French Line ships. Fashionable and glamorous are the hallmarks. Trendy is simply not a part of the BIX culture. | 25 | |||||||||||||
9 | Flour + Water | 37.759 | -122.412 | +1 415-826-7000 | — | 3.8 | 2,852 | flour + water serves a daily changing menu of house-made pasta exposing the regional variety found throughout Italy, Neapolitan-style pizzas prepared in a wood-fired oven and carefully crafted dishes utilizing seasonal ingredients. | Mission District eatery known for its handmade pasta and seasonal menu, featuring a cozy ambiance with close-knit tables and a serene, upscale interior; standout dishes include the duck breast and agnolotti. | 2009 | Opening the doors in 2009 in the heart of the mission district in San Francisco, flour + water continues to showcase a menu influenced by regional traditions throughout Italy with Northern Californian inspirations led by Executive Chef Thomas McNaughton. | 11 | ||||||||||||
10 | Nopalito | 37.773 | -122.439 | +1 415-437-0303 | 3.8 | 2,123 | — | Casual upscale Mexican eatery with a vibrant indoor-outdoor patio, featuring beautifully presented dishes like tacos de pescado and a creative mezcal selection. | — | — | 11 |
Playground
Advanced parameters are collapsed below.
curl -X POST https://api.mindcase.co/v1/data/yelp/business/run \
-H "Authorization: Bearer mk_live_YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"params": {
"urls": []
}
}'Related