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 | Ratings | 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 | — | Historic Italian deli with an old-world market feel and a wide selection of fresh meats and cheeses; features limited outdoor seating and shelves stocked with imported Italian goods. | — | — | 14 | |||||||||||||
2 | Gary Danko | 37.806 | -122.421 | +1 415-749-2060 | 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 a dimly lit, intimate atmosphere featuring a customizable multi-course menu and standout dishes like lobster risotto and chocolate soufflé. | — | — | 38 | |||||||||||||
3 | Sightglass Coffee | 37.772 | -122.438 | +1 415-463-1673 | Known for its craft small-batch, single-origin selections, Sightglass has garnered a loyal following for its pristine coffee that is thoughtfully sourced, harvested, roasted and brewed to preserve the integrity of the beans. | — | — | — | 3 | |||||||||||||
4 | Perch | 34.049 | -118.251 | +1 213-802-1770 | Perch is an elevated resting place, a whimsical French-inspired rooftop bistro with unobstructed views of the Downtown Los Angeles skyline and mountains in the distance, two outdoor fireplaces and various fire pits.
Enjoy classic French-inspired dishes with a twist. Join us for dinner 7 nights a week, our Friday Rooftop Lunch at 11:30 a.m., and our brunch Saturdays and Sundays starting at 10:00 AM. Outdoor seating is on our 15th-floor rooftop.
*Our dress code is Upscale Casual- No gym or beach attire including tank tops, baseball caps and flip flops permitted after 4:00PM.
*PERCH does not allow minors on the premises after 10:30PM. Dinner Reservations after 10:30 PM require all guests to be 21+, and a valid ID is required upon arrival.
*An independent third-party Valet service is available Monday through Friday (5:00PM- Closing) for $14.00. Valet Service is also offered Saturday and Sunday for $14.00 (10 AM- Closing).
*As a courtesy, we hold reservations 15 minutes past the scheduled time, after which you may be placed at the top our cancellation list for the next available seating.
*Our 16th-floor rooftop bar is located above our restaurant level.
*Please visit our website for more information. | Rooftop dining with panoramic city views and a lively atmosphere featuring live music and a rooftop bar; known for its steak frites and eclectic decor. | 2011 | Perch is an elevated rested place, a whimsical French inspired all inclusive rooftop bistro. Due to its surroundings Perch offers an unobstructed view, one truly feels as though they are floating at the skyline. At Perch there really is something for everyone; with two outdoor fireplaces, various fire pits, both lounge and table seating. On any given night you may come to see a live Caberet act, a funky jazz trio, indie bands or a late night DJ, Perch is a magical scene! | — | 316 | ||||||||||||
5 | Da Vinci Dental | — | 47.618 | -122.191 | +1 425-409-9999 | — | — | (5 Star Review) C M. says about Da Vinci Dental,
"Wow! I am so happy with my porcelain veneers. I was treated with the most respect and professionalism. My teeth are so bright and better shaped now. Completely life changing. Thank you to both Dr's and team. The front desk staff has been extremely helpful. From my first appointment, the experience has been 10 star! Absolutely art. I feel like I can smile, laugh without covering my mouth. I feel and felt so taken care of, educated, and grateful. I highly recommend you to take the leap and do it! Book a consultation, you won't regret this decision. I wish I did this ten plus years ago!"
Dental veneers can last indefinitely, depending on how well they are taken care of by the patient. Because porcelain veneers are stronger than simple bonding, they are also more resistant to stains and chipping. Even so, you must maintain regular oral hygiene at home, and visit us for routine cleanings and exams. This is to ensure that your new cosmetic veneers will look as good as new. Another important point is that oral habits that damage natural teeth such as nail biting, opening bobby pins, and chewing on hard objects can also damage your new dental veneers. Once porcelain veneers are applied, just treat them like natural teeth. They look great and are extremely durable.
Dr. Beau and Dr. Andrew have extensive experience with placing cosmetic dental veneers. We invite you to come to Da Vinci Dental to learn more about dental veneers. | Licensed cosmetic dental practice specializes in porcelain veneers and gum contouring procedures. The clinic offers advanced digital smile design consultations and uses E-max porcelain for no-prep or minimal-prep veneers, ensuring a natural and durable finish. | 2010 | Porcelain veneers are a thin, semi-translucent laminate permanently bonded to your teeth. While they’re not suitable for every patient, porcelain veneers are the most aesthetic alternative for a variety of dental conditions involving the front teeth, including:
Diastemas (spaces between teeth)
Broken or chipped teeth
Unsightly, stained or washed out fillings
Permanently stained or discolored teeth that can’t be bleached
Crooked teeth
Patients travel near and far to see Bellevue dentists Dr. Beau Keller and Dr. Andrew Keller who offer beautifully crafted World Class Porcelain Veneers.
Advantages and Benefits of Dental Veneers
- The procedure of placing cosmetic veneers takes only two to three appointments
- A conservative amount of tooth structure is removed during the porcelain veneer procedure
- Porcelain veneers are the most biocompatible material
- A healthy “natural” look is achieved; in fact, porcelain veneers are the most aesthetic restoration in dentistry | — | 14 | |||||||||
6 | Blue Dragon Plumbing | 30.42 | -97.722 | +1 512-947-2491 | — | — | Blue Dragon Plumbing offers residential service, including water heater repair and installation, drain cleaning, kitchen and bathroom fixture repair and replacement, Insta-Hot and garbage disposal installation, light replacement of kitchen and bathroom fixtures, repair of water leaks, PRV installation and replacement, repair/replacement of appliance gas flex lines, and annual plumbing system maintenance.
All of our work complies with the rules and regulations of the Texas Plumbing Code, without exception.
Our regular hours are from 8:00 am to 5:00 pm, Monday-Saturday. If you have an emergency plumbing issue, please call rather than contacting us by email or through Yelp.
Our labor rates consist of a one-hour minimum of $165,which includes a half hour of travel time, and additional time is charged at $27.50/15 minutes ($110/hr). Pricing provides discounts for senior citizens, military personnel and others.
We are appropriately licensed, bonded and insured. Checks, cash, and all major credit cards are accepted.
Se habla Español!
.
| Licensed, bonded, and insured plumbing service offers a comprehensive range of commercial and residential services, including water heater repair, drain cleaning, and fixture installation. Established in 2011, the family-owned business adheres to the Texas Plumbing Code and provides services in Austin and surrounding areas. | 2011 | Blue Dragon Plumbing is a family-owned, commercial/residential plumbing business, serving Austin and many surrounding areas. Owner Gilbert Jimenez has over 25 years of experience providing friendly, quality service in the Austin area, and is ready to add you to his list of satisfied customers. | — | 3 | ||||||||||
7 | Strand Bookstore | 40.733 | -73.991 | +1 212-473-1452 | — | — | Welcome to Strand Bookstore, New York City's legendary home of 18 miles of new, used and rare books. Since 1927. | Iconic independent bookstore established in 1927, offering an extensive selection of new, used, and rare books across three floors. Known for its vast collection, including graphic novels, comics, and rare finds, the store also hosts events such as book signings and readings. | — | — | — | 13 | ||||||||||
8 | Kavárna Slavia | 50.082 | 14.414 | +420 224 218 493 | — | — | Kavárna s tradicí a historií. Domácí dorty, výborná káva a nejlepší výhled na Pražský Hrad a Petřín. | — | 1881 | Historie Kavárny Slavia
Známý podnikatel Václav Zoufalý obdržel 10.srpna 1881 povolení ke stavebním úpravám za účelem provozovat kavárenskou činnost v pronajatém přízemí paláce Lažanských. Kavárna Slavia. Záměrem Václava Zoufalého bylo vybudovat kavárnu, která by splňovala tehdejší nároky kavárenské klientely a současně by odpovídala svému postavení proti Národnímu divadlu, jehož otevření se kvapem blížilo. Souhlas k provedení rozsáhlejších stavebních úprav získal ovšem dva měsíce po slavnostním představení Smetanovy Libuše za účasti korunního prince Rudolfa (11. června 1881). V divadle se pracovalo dále a než práce dospěly ke svému konci, zhoubný požár v noci z 12. na 13. srpna oddálil jeho uvedení do trvalého divadelního provozu.
Souběžně z rekonstrukcí ND probíhaly i stavební práce v kavárně Slavia dle projektu městkého stavitele Ferdinanda Víška.
Kavárna byla otevřena během roku 1882. Poté další zvelebení kavárny a vytvoření nového vchodového portálu ku příležitosti Slavnostního | — | — | ||||||||||
9 | Boréal Coffee Shop | 47.372 | 8.535 | +41 44 221 95 16 | — | — | — | — | Founded in Switzerland in 2009, we believe in bringing specialty coffee to everyone through our welcoming coffee shops . Organic specialty coffee from bean to cup ! | — | 2008 | Boréal Coffee was the first specialty coffee shop in Geneva ! We have now 5 locations in Geneva and are present in Zurich since 2016 with 2 shops. | — | — |
Playground
Advanced parameters are collapsed below.
curl -X POST https://api.mindcase.co/api/v1/agents/yelp/business/run \
-H "Authorization: Bearer mk_live_YOUR_API_KEY" \
-H "Content-Type: application/json" \
-d '{
"params": {
"urls": []
}
}'Related