KeenableKeenable SELECT showcaseAsk your own question →GitHub

Best New Casual Southeast Asian Restaurants in the Bay Area

Trajectory · 18 messages, 9 tool calls · report · all reports

user

What are the best new southeast asian restaurants in the bay area? They should be open since 2025, casual, and take walk-ins.

assistant

tool call · select

SELECT
  url,
  title,
  published_at,
  UNNEST(
    SEM_EXTRACT_ALL(
      content,
      'a San Francisco Bay Area restaurant that opened on or after 2025-01-01 and serves Southeast Asian cuisine',
      restaurant := 'restaurant name',
      cuisine := 'specific cuisine or Southeast Asian culinary tradition',
      location := 'Bay Area city or neighborhood',
      opened := 'opening date, YYYY-MM-DD; use YYYY-MM if day is unavailable',
      acclaim := 'specific praise, recommendation, award, or critic assessment',
      format := 'service style and atmosphere, including whether casual',
      walkins := 'walk-in policy or evidence that reservations are not required',
      evidence := 'per_field'
    ),
    recursive := true
  )
FROM WEB_SEARCH(
  'best new Bay Area restaurants 2025 Vietnamese Thai Filipino Indonesian Malaysian Burmese Cambodian Lao',
  'site:sfchronicle.com best new restaurant 2025 Thai Vietnamese Filipino Bay Area',
  'site:sf.eater.com openings 2025 Thai Vietnamese Filipino restaurant Bay Area',
  'site:theinfatuation.com/san-francisco new restaurant Thai Vietnamese Filipino 2025',
  'San Francisco Bay Area new Southeast Asian restaurants 2026 openings',
  'Oakland new restaurant 2025 Filipino Vietnamese Thai Indonesian Cambodian Lao',
  'San Jose new restaurant 2025 Vietnamese Filipino Thai Malaysian Singaporean',
  'Berkeley new restaurant 2025 Burmese Thai Filipino Southeast Asian',
  'Marin Peninsula new Vietnamese Thai Filipino restaurant 2025',
  'Bay Area restaurant walk ins casual new 2025 Southeast Asian'
)
WHERE SEM_MATCH(
  content,
  'discusses or recommends at least one San Francisco Bay Area Southeast Asian restaurant that opened on or after January 1, 2025'
)
{
 "show_preview": false
}
tool result (3318 chars)
result_set_id: rfb1095c04a1
total_rows: 245
columns[17]: acclaim,acclaim_evidence,cuisine,cuisine_evidence,format,format_evidence,location,location_evidence,opened,opened_evidence,published_at,restaurant,restaurant_evidence,title,url,walkins,walkins_evidence
preview:
  sample_rows[3]:
    - url: "https://sfchronicle.com/projects/2025/restaurants-to-visit-now"
      title: The Bay Area's 25 best restaurants right now
      published_at: "2025-07-08T11:00:00"
      restaurant: Carabao
      cuisine: null
      location: null
      opened: null
      acclaim: null
      format: null
      walkins: null
      restaurant_evidence[2]: "The summer produced a bounty of new restaurant openings in the Bay Area, and we’re glad to welcome many to the fall edition of the... [truncated in preview]","From Jade and Mathew Cunningham — spouses and French Laundry alumni — comes Carabao, Napa’s first Filipino restaurant."
      cuisine_evidence: null
      location_evidence: null
      opened_evidence: null
      acclaim_evidence: null
      format_evidence: null
      walkins_evidence: null
    - url: "https://www.sfchronicle.com/food/restaurants/article/le-soleil-restaurant-stonestown-sf-20416010.php"
      title: Le Soleil opens new SF location in Stonestown Galleria
      published_at: "2025-07-05T11:00:00"
      restaurant: Le Soleil
      cuisine: null
      location: null
      opened: null
      acclaim: null
      format: null
      walkins: null
      restaurant_evidence[3]: "After 32 years, this S.F. restaurant family is back with a new contemporary Vietnamese spot","Now, the restaurant has expanded with a second San Francisco location in Stonestown Galleria.","If you visit the Stonestown location, whose opening in mid-June attracted guests such as San Francisco Mayor Daniel Lurie, you’ll probably see Annie, the matriarch... [truncated in preview]"
      cuisine_evidence: null
      location_evidence: null
      opened_evidence: null
      acclaim_evidence: null
      format_evidence: null
      walkins_evidence: null
    - url: "https://allthe.news/ko/articles/new-east-bay-restaurants-introduce-diverse-cuisines"
      title: New east bay restaurants introduce diverse cuisines
      published_at: "2026-03-04T09:41:09"
      restaurant: Jolly Cafe
      cuisine: null
      location: null
      opened: null
      acclaim: null
      format: null
      walkins: null
      restaurant_evidence[2]: # New east bay restaurants introduce diverse cuisines,"Jolly Cafe replaced Boba Binge in Oakland Chinatown, serving Vietnamese coffee, matcha, spring rolls, banh mi sandwiches, and drinks with sweet mung bean."
      cuisine_evidence: null
      location_evidence: null
      opened_evidence: null
      acclaim_evidence: null
      format_evidence: null
      walkins_evidence: null
notes[3,]{text}:
  "The full table is too large to return in one response. This is a preview, not the data — do not draw conclusions from it alone. Query the result set by id: SEM_EXTRACT fields, filter with exact WHERE, aggregate, or page with LIMIT/OFFSET. Even if the preview looks irrelevant, probe the full result set before searching again."
  Merged 10 queries (1982 total) → 1571 unique results
  "Search result set: r8edc25760a3 (1571 rows), reference it as FROM r8edc25760a3 in follow-up queries"

result set rfb1095c04a1 · 245 rows

urltitlepublished_atrestaurantcuisinelocationopenedacclaimformatwalkinsrestaurant_evidencecuisine_evidencelocation_evidenceopened_evidenceacclaim_evidenceformat_evidencewalkins_evidence
https://sfchronicle.com/projects/2025/restaurants-to-visit-nowThe Bay Area's 25 best restaurants right now2025-07-08T11:00:00Carabaonullnullnullnullnullnull["The summer produced a bounty of new restaurant openings in the Bay Area, and we’re glad to welcome many to the fall edition of the Now List, our guide to the…nullnullnullnullnullnull
https://oaklandside.org/2026/08/25/aks-anh-hong-berkeley-bagels-happy-express-philzNew Asian fusion moves into 10th & Wood spot, plus fresh bagel and Chinese takeout options2026-08-25T19:00:00Ak’s Anh Hongnullnullnullnullnullnull["New Asian fusion moves into 10th & Wood spot, plus fresh bagel and Chinese takeout options", "## **Ak’s Anh Hong**", "*Ak’s Anh Hong, 945 Wood St., Oakland*"]nullnullnullnullnullnull
https://berkeleyside.org/2026/08/25/aks-anh-hong-berkeley-bagels-happy-express-philzBerkeley Bagels debuts downtown location, plus new Asian fusion, coffee and takeout Chinese options2026-08-25T19:00:00Ak’s Anh Hongnullnullnullnullnullnull["Berkeley Bagels debuts downtown location, plus new Asian fusion, coffee and takeout Chinese options", "## **Ak’s Anh Hong**", "*Ak’s Anh Hong, 945 Wood St., …nullnullnullnullnullnull
https://richmondside.org/2026/08/25/aks-anh-hong-berkeley-bagels-happy-express-philzPhilz comes to Concord, plus new Asian fusion, bagel, and takeout Chinese options.2026-08-25T19:00:00Ak’s Anh Hongnullnullnullnullnullnull["Philz comes to Concord, plus new Asian fusion, bagel, and takeout Chinese options.", "A running list of restaurants that have recently opened in Berkeley, Oa…nullnullnullnullnullnull
https://sf.eater.com/dining-report/213437/payakk-reviewPork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant2026-08-24T22:00:59Payakknullnullnullnullnullnull["Pork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant", "Pinpech’s new restaurant [Payakk](https://www.eater.com/venue/98…nullnullnullnullnullnull
Download all 245 rows · 227 KB
assistant

tool call · select

SELECT
  SEM_NORM(restaurant) AS restaurant,
  ANY_VALUE(cuisine) AS cuisine,
  ANY_VALUE(location) AS location,
  ANY_VALUE(opened) AS opened,
  ANY_VALUE(acclaim) AS acclaim,
  ANY_VALUE(format) AS format,
  ANY_VALUE(walkins) AS walkins,
  COUNT(DISTINCT url) AS source_mentions,
  LIST(DISTINCT url)[:4] AS urls
FROM rfb1095c04a1
WHERE restaurant IS NOT NULL
  AND (
    opened LIKE '2025%'
    OR opened LIKE '2026%'
    OR published_at >= '2025-01-01'
  )
  AND cuisine IS NOT NULL
GROUP BY SEM_NORM(restaurant)
ORDER BY
  source_mentions DESC,
  restaurant
LIMIT 80
{
 "show_preview": false
}
tool result (708 chars)
result_set_id: r1878c670efc
total_rows: 2
columns[9]: acclaim,cuisine,format,location,opened,restaurant,source_mentions,urls,walkins
rows[2]:
  - restaurant: Pho 510
    cuisine: Vietnamese
    location: Castro Valley
    opened: 2025-09-18
    acclaim: null
    format: cozy
    walkins: null
    source_mentions: 1
    urls[1]: "https://berkeleyside.org/2025/10/06/marins-leos-cafe-brusco-payakk-east-bay-openings"
  - restaurant: Restaurant Naides
    cuisine: Filipino
    location: San Francisco
    opened: 2025-12
    acclaim: null
    format: fine dining
    walkins: null
    source_mentions: 1
    urls[1]: "https://sf.eater.com/restaurant-news/209430/restaurant-naides-san-francisco-new"
notes[0]:

result set r1878c670efc · 2 rows

restaurantcuisinelocationopenedacclaimformatwalkinssource_mentionsurls
Pho 510VietnameseCastro Valley2025-09-18nullcozynull1["https://berkeleyside.org/2025/10/06/marins-leos-cafe-brusco-payakk-east-bay-openings"]
Restaurant NaidesFilipinoSan Francisco2025-12nullfine diningnull1["https://sf.eater.com/restaurant-news/209430/restaurant-naides-san-francisco-new"]
Download all 2 rows · 1 KB
assistant

tool call · select

SELECT
  url,
  title,
  published_at,
  SEM_EXTRACT(
    content,
    restaurant := 'name of the new Southeast Asian restaurant that is the main subject',
    cuisine := 'specific national or regional cuisine',
    location := 'Bay Area city and neighborhood',
    opening := 'actual opening month or date',
    casual_signals := 'counter service, food hall, cafe, noodle shop, affordable, or other casual-service evidence',
    walkin_signals := 'walk-in availability, no-reservation policy, counter ordering, food-hall seating, or first-come-first-served evidence',
    praise := 'critic recommendation, best-new-list inclusion, notable chef pedigree, or standout dishes',
    evidence := 'per_field'
  ) AS facts
FROM WEB_SEARCH(
  'Bay Area Filipino restaurant opened 2025 casual walk ins review Carabao Napa',
  'Bay Area Vietnamese restaurant opened 2025 casual walk ins Le Soleil Stonestown',
  'Bay Area Thai restaurant opened 2025 casual new review',
  'Bay Area Indonesian Malaysian Singaporean restaurant opened 2025 new review',
  'Bay Area Burmese Cambodian Lao restaurant opened 2025 new review',
  'San Francisco new Vietnamese restaurant 2026 casual opening',
  'Oakland Berkeley new Southeast Asian restaurant 2026 opening',
  'San Jose new Southeast Asian restaurant 2026 opening',
  'site:sfchronicle.com/food/restaurants 2025 "Filipino" "opened" restaurant',
  'site:sfchronicle.com/food/restaurants 2025 "Vietnamese" "opened" restaurant',
  'site:sf.eater.com 2025 "Thai" "opening" restaurant San Francisco Oakland',
  'site:sf.eater.com 2026 "Filipino" OR "Vietnamese" OR "Burmese" restaurant opening'
)
WHERE SEM_MATCH(
  content,
  'the main subject is a San Francisco Bay Area Southeast Asian restaurant location that newly opened in 2025 or 2026'
)
{
 "show_preview": false
}
tool result (3332 chars)
result_set_id: reaac9c66750
total_rows: 89
columns[4]: facts,published_at,title,url
preview:
  sample_rows[3]:
    - url: "https://sf.eater.com/dining-report/213437/payakk-review"
      title: Pork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant
      published_at: "2026-08-24T22:00:59"
      facts:
        restaurant: Payakk
        cuisine: null
        location: null
        opening: null
        casual_signals: null
        walkin_signals: null
        praise: null
        restaurant_evidence[2]: # Pork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant,"But while Secrets of Tiger feels casual, Pinpech’s new restaurant [Payakk](https://www.eater.com/venue/981835/payakk) is more considered, a spot that feels more date night-coded through moody lighting and gorgeously plated dishes."
        cuisine_evidence: null
        location_evidence: null
        opening_evidence: null
        casual_signals_evidence: null
        walkin_signals_evidence: null
        praise_evidence: null
    - url: "https://sf.eater.com/restaurant-news/210554/izzy-and-wooks-opening-saluhall-downtown-san-francisco"
      title: A Filipino Sandwich Favorite Wants to Turn Saluhall Around
      published_at: "2026-01-07T17:26:47"
      facts:
        restaurant: Izzy and Wooks
        cuisine: null
        location: null
        opening: null
        casual_signals: null
        walkin_signals: null
        praise: null
        restaurant_evidence[1]: "The Filipino and American burger heroes at [Izzy and Wooks](https://izzyandwooks.com/) open inside the space on Wednesday, January 14."
        cuisine_evidence: null
        location_evidence: null
        opening_evidence: null
        casual_signals_evidence: null
        walkin_signals_evidence: null
        praise_evidence: null
    - url: "https://postcard.inc/places/burma-berkeley-berkeley-jHx1WXA5I8T"
      title: "Burma Berkeley - Burmese restaurant in Southside, Berkeley | Reviews, Photos & Information on Postcard"
      published_at: null
      facts:
        restaurant: Burma Berkeley
        cuisine: null
        location: null
        opening: null
        casual_signals: null
        walkin_signals: No wait
        praise: null
        restaurant_evidence[2]: Burmese restaurant · Southside ·,"Burma Berkeley - Burmese restaurant in Southside, Berkeley | Reviews, Photos & Information on Postcard"
        cuisine_evidence: null
        location_evidence: null
        opening_evidence: null
        casual_signals_evidence: null
        walkin_signals_evidence[2]: "Burma Berkeley - Burmese restaurant in Southside, Berkeley | Reviews, Photos & Information on Postcard",Plus no wait like at Burma Superstar whose established reputation precedes it.
        praise_evidence: null
notes[3,]{text}:
  "The full table is too large to return in one response. This is a preview, not the data — do not draw conclusions from it alone. Query the result set by id: SEM_EXTRACT fields, filter with exact WHERE, aggregate, or page with LIMIT/OFFSET. Even if the preview looks irrelevant, probe the full result set before searching again."
  Merged 12 queries (2205 total) → 2010 unique results
  "Search result set: r5b43e17ab49 (2010 rows), reference it as FROM r5b43e17ab49 in follow-up queries"

result set reaac9c66750 · 89 rows

urltitlepublished_atfacts
https://sf.eater.com/dining-report/213437/payakk-reviewPork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant2026-08-24T22:00:59{"restaurant": "Payakk", "cuisine": null, "location": null, "opening": null, "casual_signals": null, "walkin_signals": null, "praise": null, "restaurant_eviden…
https://yahoo.com/lifestyle/articles/pork-jowl-fried-rice-produce-220059135.htmlPork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant2026-08-24T22:00:59{"restaurant": "Payakk", "cuisine": null, "location": null, "opening": null, "casual_signals": null, "walkin_signals": null, "praise": null, "restaurant_eviden…
https://sfchronicle.com/food/restaurants/article/broken-dreams-vietnamese-oakland-22337543.phpBroken Dreams is a new Vietnamese restaurant coming to Oakland2026-07-15T11:00:00{"restaurant": "Broken Dreams", "cuisine": null, "location": null, "opening": null, "casual_signals": null, "walkin_signals": null, "praise": null, "restaurant…
https://sf.eater.com/restaurant-news/212134/ca-phe-viet-vietnamese-coffee-cafe-opening-san-franciscoVietnamese Egg Coffee Comes to Downtown San Francisco2026-04-15T20:20:24{"restaurant": "Cà Phê Việt", "cuisine": null, "location": null, "opening": null, "casual_signals": null, "walkin_signals": null, "praise": null, "restaurant_e…
https://sf.eater.com/pop-ups/203964/esmeria-bakehouse-bakery-pop-up-east-bayPork Jowl Croissants and Kumquat Thai Basil Danishes Hit the East Bay2025-07-14T18:23:21{"restaurant": "Esmeria Bakehouse", "cuisine": null, "location": null, "opening": null, "casual_signals": null, "walkin_signals": null, "praise": null, "restau…
Download all 89 rows · 86 KB
assistant

tool call · select

SELECT
  facts.restaurant AS restaurant,
  facts.cuisine AS cuisine,
  facts.location AS location,
  facts.opening AS opening,
  facts.casual_signals AS casual_signals,
  facts.walkin_signals AS walkin_signals,
  facts.praise AS praise,
  facts.restaurant_evidence AS restaurant_evidence,
  facts.cuisine_evidence AS cuisine_evidence,
  facts.location_evidence AS location_evidence,
  facts.opening_evidence AS opening_evidence,
  facts.casual_signals_evidence AS casual_evidence,
  facts.walkin_signals_evidence AS walkin_evidence,
  facts.praise_evidence AS praise_evidence,
  title,
  url,
  published_at
FROM reaac9c66750
WHERE facts.restaurant IS NOT NULL
ORDER BY published_at DESC NULLS LAST
{
 "show_preview": false
}
tool result (3120 chars)
result_set_id: r5d97401aa20
total_rows: 89
columns[17]: casual_evidence,casual_signals,cuisine,cuisine_evidence,location,location_evidence,opening,opening_evidence,praise,praise_evidence,published_at,restaurant,restaurant_evidence,title,url,walkin_evidence,walkin_signals
preview:
  sample_rows[3]:
    - restaurant: HolyShred
      cuisine: null
      location: null
      opening: null
      casual_signals: null
      walkin_signals: null
      praise: null
      restaurant_evidence[2]: Stanford alum opens protein-forward Palo Alto Thai restaurant,HolyShred is a fast-casual Thai restaurant located in the former Siam Fine Thai space on El Camino
      cuisine_evidence: null
      location_evidence: null
      opening_evidence: null
      casual_evidence: null
      walkin_evidence: null
      praise_evidence: null
      title: Stanford alum opens protein-forward Palo Alto Thai restaurant
      url: "https://paloaltoonline.com/palo-alto/2026/08/26/holy-shred-thai-restaurant-opens-in-palo-alto"
      published_at: "2026-08-26T18:56:04"
    - restaurant: Restaurant Naides
      cuisine: null
      location: null
      opening: null
      casual_signals: null
      walkin_signals: null
      praise: null
      restaurant_evidence[2]: Alums From Some of the World’s Best Restaurant Kitchens Bring Fine Dining Filipino Cuisine to San Francisco,Chef Patrick Gabon and partner Celine Wuu open Restaurant Naides in December
      cuisine_evidence: null
      location_evidence: null
      opening_evidence: null
      casual_evidence: null
      walkin_evidence: null
      praise_evidence: null
      title: Alums From Some of the World’s Best Restaurant Kitchens Bring Fine Dining Filipino Cuisine to San Francisco
      url: "https://sf.eater.com/restaurant-news/209430/restaurant-naides-san-francisco-new"
      published_at: "2025-11-10T20:57:35"
    - restaurant: Burma Berkeley
      cuisine: null
      location: null
      opening: null
      casual_signals: null
      walkin_signals: No wait
      praise: null
      restaurant_evidence[2]: Burmese restaurant · Southside ·,"Burma Berkeley - Burmese restaurant in Southside, Berkeley | Reviews, Photos & Information on Postcard"
      cuisine_evidence: null
      location_evidence: null
      opening_evidence: null
      casual_evidence: null
      walkin_evidence[2]: "Burma Berkeley - Burmese restaurant in Southside, Berkeley | Reviews, Photos & Information on Postcard",Plus no wait like at Burma Superstar whose established reputation precedes it.
      praise_evidence: null
      title: "Burma Berkeley - Burmese restaurant in Southside, Berkeley | Reviews, Photos & Information on Postcard"
      url: "https://postcard.inc/places/burma-berkeley-berkeley-jHx1WXA5I8T"
      published_at: null
notes[1,]{text}:
  "The full table is too large to return in one response. This is a preview, not the data — do not draw conclusions from it alone. Query the result set by id: SEM_EXTRACT fields, filter with exact WHERE, aggregate, or page with LIMIT/OFFSET. Even if the preview looks irrelevant, probe the full result set before searching again."

result set r5d97401aa20 · 89 rows

restaurantcuisinelocationopeningcasual_signalswalkin_signalspraiserestaurant_evidencecuisine_evidencelocation_evidenceopening_evidencecasual_evidencewalkin_evidencepraise_evidencetitleurlpublished_at
HolyShrednullnullnullnullnullnull["Stanford alum opens protein-forward Palo Alto Thai restaurant", "HolyShred is a fast-casual Thai restaurant located in the former Siam Fine Thai space on El …nullnullnullnullnullnullStanford alum opens protein-forward Palo Alto Thai restauranthttps://paloaltoonline.com/palo-alto/2026/08/26/holy-shred-thai-restaurant-opens-in-palo-alto2026-08-26T18:56:04
Payakknullnullnullnullnullnull["Pork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant", "But while Secrets of Tiger feels casual, Pinpech's new restauran…nullnullnullnullnullnullPork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restauranthttps://yahoo.com/lifestyle/articles/pork-jowl-fried-rice-produce-220059135.html2026-08-24T22:00:59
Payakknullnullnullnullnullnull["# Pork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant", "But while Secrets of Tiger feels casual, Pinpech’s new restaur…nullnullnullnullnullnullPork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restauranthttps://sf.eater.com/dining-report/213437/payakk-review2026-08-24T22:00:59
Ka Kainullnullnullnullnullnull["# The Castro’s best new restaurant pushes the SF Thai food scene even further", "But chef Tar Watcharin Pintisuep, who opened Ka Kai in March in the Castro, …nullnullnullnullnullnullThe Castro’s best new restaurant pushes the SF Thai food scene even furtherhttps://sfstandard.com/2026/08/23/ka-kai-northern-thai-restaurant-san-francisco2026-08-23T13:00:00
Saamnullnullnullnullnullnull["Is This SF Hotspot the Most Important New Thai Restaurant in America?", "“I’ve never been more excited for a Thai restaurant,” Eater correspondent Matthew Ka…nullnullnullnullnullnullIs This SF Hotspot the Most Important New Thai Restaurant in America?https://sf.eater.com/best-food-travel-destinations/213401/saam-new-restaurant-san-francisco-thitid-ton-tassanakajohn2026-08-19T17:16:41
Download all 89 rows · 81 KB
assistant

tool call · select

SELECT
  url,
  title,
  published_at,
  UNNEST(
    SEM_EXTRACT_ALL(
      content,
      'a currently open, casual San Francisco Bay Area Southeast Asian restaurant location that first opened during 2025 or 2026',
      restaurant := 'restaurant name',
      cuisine := 'Southeast Asian cuisine',
      location := 'city and neighborhood',
      opened := 'first public opening date of this location, YYYY-MM-DD or YYYY-MM',
      casual_reason := 'evidence it is casual, such as counter service, fast-casual, cafe, food hall, sandwich shop, noodle shop, or low-key atmosphere',
      walkin_reason := 'evidence it accommodates walk-ins, such as counter service, no reservations, food hall, first-come-first-served, or explicit walk-in policy',
      recommendation := 'specific positive critical assessment, best-new recognition, chef pedigree, popularity, or praised dishes',
      evidence := 'per_field'
    ),
    recursive := true
  )
FROM r5b43e17ab49
WHERE SEM_MATCH(
  content,
  'describes a currently open Bay Area Southeast Asian restaurant that opened in 2025 or 2026, is casual rather than fine dining, and is suitable for customers without reservations'
)
{
 "show_preview": false
}
tool result (3365 chars)
result_set_id: r7699db09f63
total_rows: 56
columns[17]: casual_reason,casual_reason_evidence,cuisine,cuisine_evidence,location,location_evidence,opened,opened_evidence,published_at,recommendation,recommendation_evidence,restaurant,restaurant_evidence,title,url,walkin_reason,walkin_reason_evidence
preview:
  sample_rows[3]:
    - url: "https://oaklandside.org/2026/04/21/homemade-cafe-dinner-causa-jiams-qargo-open"
      title: "Homemade Cafe now serving dinner, plus new Peruvian, Southeast Asian, and shokupan options"
      published_at: "2026-04-21T19:00:00"
      restaurant: Jiams
      cuisine: null
      location: null
      opened: null
      casual_reason: null
      walkin_reason: null
      recommendation: null
      restaurant_evidence[3]: "A running list of restaurants that have recently opened in Berkeley, Oakland, Richmond, and beyond.",## **Jiams**,"A [new Southeast Asian restaurant](https://www.instagram.com/p/DXFLhhdARNm/) has opened in Oakland’s San Antonio neighborhood."
      cuisine_evidence: null
      location_evidence: null
      opened_evidence: null
      casual_reason_evidence: null
      walkin_reason_evidence: null
      recommendation_evidence: null
    - url: "http://sf.eater.com/2025/1/14/24343678/senor-sisigs-filipino-american-new-thrive-city-restaurant-warriors-chase-center-opening"
      title: Señor Sisig’s Opens New Restaurant on January 21 at Thrive City Near Chase Center
      published_at: "2025-01-14T18:56:41"
      restaurant: Señor Sisig
      cuisine: null
      location: null
      opened: null
      casual_reason: null
      walkin_reason: null
      recommendation: null
      restaurant_evidence[2]: # Señor Sisig’s Filipino American Street Food Gets a Signal Boost From the Warriors,"**It’s been 15 years since** [**Señor Sisig**](https://www.senorsisig.com/) launched its brand of Filipino Mexican dishes as a food truck, but its biggest milestone yet is just... [truncated in preview]"
      cuisine_evidence: null
      location_evidence: null
      opened_evidence: null
      casual_reason_evidence: null
      walkin_reason_evidence: null
      recommendation_evidence: null
    - url: "https://richmondside.org/2026/05/06/starline-sable-lounge-lodge-sanaa-shake-shack-open"
      title: "Hercules gets a new coffee shop, Milk Cloud launches pre-orders, and more April openings"
      published_at: "2026-05-06T19:12:14"
      restaurant: Jiams
      cuisine: null
      location: null
      opened: null
      casual_reason: null
      walkin_reason: null
      recommendation: null
      restaurant_evidence[3]: "Hercules gets a new coffee shop, Milk Cloud launches pre-orders, and more April openings",## **Jiams**,"A [new Southeast Asian restaurant](https://www.instagram.com/p/DXFLhhdARNm/) has opened in Oakland’s San Antonio neighborhood."
      cuisine_evidence: null
      location_evidence: null
      opened_evidence: null
      casual_reason_evidence: null
      walkin_reason_evidence: null
      recommendation_evidence: null
notes[1,]{text}:
  "The full table is too large to return in one response. This is a preview, not the data — do not draw conclusions from it alone. Query the result set by id: SEM_EXTRACT fields, filter with exact WHERE, aggregate, or page with LIMIT/OFFSET. Even if the preview looks irrelevant, probe the full result set before searching again."

result set r7699db09f63 · 56 rows

urltitlepublished_atrestaurantcuisinelocationopenedcasual_reasonwalkin_reasonrecommendationrestaurant_evidencecuisine_evidencelocation_evidenceopened_evidencecasual_reason_evidencewalkin_reason_evidencerecommendation_evidence
https://oaklandside.org/2026/04/21/homemade-cafe-dinner-causa-jiams-qargo-openHomemade Cafe now serving dinner, plus new Peruvian, Southeast Asian, and shokupan options2026-04-21T19:00:00Jiamsnullnullnullnullnullnull["A running list of restaurants that have recently opened in Berkeley, Oakland, Richmond, and beyond.", "## **Jiams**", "A [new Southeast Asian restaurant](htt…nullnullnullnullnullnull
https://berkeleyside.org/2026/04/21/homemade-cafe-dinner-causa-jiams-qargo-openHomemade Cafe now serving dinner, plus new Peruvian, Southeast Asian, and coffee options2026-04-21T17:15:00Jiamsnullnullnullnullnullnull["Homemade Cafe now serving dinner, plus new Peruvian, Southeast Asian, and coffee options", "A running list of restaurants that have recently opened in Berkel…nullnullnullnullnullnull
https://sfchronicle.com/food/restaurants/article/broken-dreams-vietnamese-oakland-22337543.phpBroken Dreams is a new Vietnamese restaurant coming to Oakland2026-07-15T11:00:00Broken Dreamsnullnullnullnullcounter servicenull["Broken Dreams, at 1312 Broadway, will debut on Aug. 10.", "Now Nguyen and her husband, Geoffrey Deetz, who was formerly chef-owner of Oakland Vietnamese spot…nullnullnullnull["The restaurant will serve cơm tấm from a station where customers can choose toppings, similar to ordering a burrito, Deetz said.", "Now Nguyen and her husban…null
https://sf.eater.com/restaurant-news/212134/ca-phe-viet-vietnamese-coffee-cafe-opening-san-franciscoVietnamese Egg Coffee Comes to Downtown San Francisco2026-04-15T20:20:24Cà Phê Việtnullnullnullnullnullnull["**A new Vietnamese cafe** touting egg cream coffees and banh mi has landed in downtown San Francisco.", "Say hello to [Cà Phê Việt](https://www.caphe-viet.co…nullnullnullnullnullnull
https://berkeleyside.org/2026/05/05/bake-sum-teni-east-dave-busters-kathiew-house-starline-openBake Sum hits Alameda, Dave & Buster’s debuts in JLS, Teni East relocates, and more openings2026-05-05T19:00:00Kathiew Housenullnullnullnullset up outside at A&R Marketnull["# Bake Sum hits Alameda, Dave & Buster’s debuts in JLS, Teni East relocates, and more openings", "A running list of restaurants that have recently opened in …nullnullnullnull["# Bake Sum hits Alameda, Dave & Buster’s debuts in JLS, Teni East relocates, and more openings", "A running list of restaurants that have recently opened in …null
Download all 56 rows · 64 KB
assistant

tool call · select

SELECT
  SEM_NORM(restaurant) AS restaurant,
  ANY_VALUE(cuisine) AS cuisine,
  ANY_VALUE(location) AS location,
  ANY_VALUE(opened) AS opened,
  ANY_VALUE(casual_reason) AS casual_reason,
  ANY_VALUE(walkin_reason) AS walkin_reason,
  ANY_VALUE(recommendation) AS recommendation,
  COUNT(DISTINCT url) AS mentions,
  LIST(DISTINCT url) AS source_urls
FROM r7699db09f63
WHERE restaurant IS NOT NULL
GROUP BY SEM_NORM(restaurant)
ORDER BY mentions DESC, restaurant
{
 "show_preview": false
}
tool result (12666 chars)
result_set_id: r258031e0e90
total_rows: 35
columns[9]: casual_reason,cuisine,location,mentions,opened,recommendation,restaurant,source_urls,walkin_reason
rows[35]:
  - restaurant: FOB West
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: food hall
    recommendation: null
    mentions: 5
    source_urls[5]: "https://richmondside.org/2026/04/09/fob-west-tita-beccas-butters-lena-gara-cocinita-nica-open","https://allthe.news/sw/articles/new-east-bay-restaurants-introduce-diverse-cuisines","https://allthe.news/da/articles/new-east-bay-restaurants-introduce-diverse-cuisines","https://allthe.news/hi/articles/new-east-bay-restaurants-introduce-diverse-cuisines","https://sfchronicle.com/food/restaurants/article/fob-west-prescott-market-oakland-22071463.php"
  - restaurant: Jiams
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 5
    source_urls[5]: "https://richmondside.org/2026/04/21/homemade-cafe-dinner-causa-jiams-qargo-open","https://richmondside.org/2026/05/06/starline-sable-lounge-lodge-sanaa-shake-shack-open","https://oaklandside.org/2026/04/21/homemade-cafe-dinner-causa-jiams-qargo-open","https://berkeleyside.org/2026/04/21/homemade-cafe-dinner-causa-jiams-qargo-open","https://newsbeep.com/us-ca/278871"
  - restaurant: Cà Phê Việt
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: quick stop and counter service layout
    recommendation: null
    mentions: 3
    source_urls[3]: "https://nationaltoday.com/us/ca/san-francisco/news/2026/04/15/new-vietnamese-cafe-brings-egg-coffee-and-banh-mi-to-downtown-san-francisco","https://sf.eater.com/restaurant-news/212134/ca-phe-viet-vietnamese-coffee-cafe-opening-san-francisco","https://hoodline.com/2026/04/fidi-gets-frothy-as-vietnamese-egg-coffee-cracks-open-on-new-montgomery"
  - restaurant: Kathiew House
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: set up outside at A&R Market
    recommendation: null
    mentions: 3
    source_urls[3]: "https://berkeleyside.org/2026/05/05/bake-sum-teni-east-dave-busters-kathiew-house-starline-open","https://richmondside.org/2026/05/05/bake-sum-teni-east-dave-busters-kathiew-house-starline-open","https://newsbeep.com/us-ca/301376"
  - restaurant: Le Soleil
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: food court setting
    recommendation: null
    mentions: 3
    source_urls[3]: "https://postcard.inc/places/le-soleil-stonestown-san-francisco-cto0Ksq-LOk","https://48hills.org/2025/09/best-of-the-bay-editors-pick-2025-stonestown","https://postcard.inc/places/le-soleil-san-francisco-G3RJPN16M2q"
  - restaurant: Aung Myanmar
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 2
    source_urls[2]: "https://richmondside.org/2026/06/23/divan-serotonin-scoops-miles-slice-aung-myanmar-millenium","https://oaklandside.org/2026/06/23/divan-serotonin-scoops-miles-slice-aung-myanmar-millenium"
  - restaurant: InNenasKitchen
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: counter service
    recommendation: null
    mentions: 2
    source_urls[2]: "https://sfchronicle.com/food/restaurants/article/innenaskitchen-cambodian-oakland-22197685.php","https://yahoo.com/lifestyle/articles/landlord-dispute-helped-create-one-120000855.html"
  - restaurant: Izzy & Wooks
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: kiosk
    recommendation: null
    mentions: 2
    source_urls[2]: "https://sfchronicle.com/food/restaurants/article/izzy-wooks-saluhall-sf-22222367.php","https://sf.eater.com/restaurant-news/210554/izzy-and-wooks-opening-saluhall-downtown-san-francisco"
  - restaurant: Jolly Cafe
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: cafe
    recommendation: null
    mentions: 2
    source_urls[2]: "https://allthe.news/hi/articles/new-east-bay-restaurants-introduce-diverse-cuisines","https://allthe.news/fi/articles/new-east-bay-restaurants-introduce-diverse-cuisines"
  - restaurant: Ka Kai
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: soft opening last week
    recommendation: null
    mentions: 2
    source_urls[2]: "https://nationaltoday.com/us/ca/san-francisco/news/2026/04/13/new-izakaya-northern-thai-cuisine-and-michelin-additions-shake-up-san-franciscos-food-scene","https://axios.com/local/san-francisco/2026/07/15/san-francisco-summer-2026-restaurant-openings"
  - restaurant: Kien Svay Cafe
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: takeout food
    recommendation: null
    mentions: 2
    source_urls[2]: "https://oaklandside.org/2025/08/11/east-bay-new-restaurants-july-cambodian-greek","https://richmondside.org/2025/08/11/east-bay-new-restaurants-july-cambodian-greek"
  - restaurant: Señor Sisig
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: counter service
    recommendation: null
    mentions: 2
    source_urls[2]: "https://sf.eater.com/2025/1/14/24343678/senor-sisigs-filipino-american-new-thrive-city-restaurant-warriors-chase-center-opening","http://sf.eater.com/2025/1/14/24343678/senor-sisigs-filipino-american-new-thrive-city-restaurant-warriors-chase-center-opening"
  - restaurant: Ak’s Anh Hong
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 1
    source_urls[1]: "https://richmondside.org/2026/08/25/aks-anh-hong-berkeley-bagels-happy-express-philz"
  - restaurant: Broken Dreams
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: counter service
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sfchronicle.com/food/restaurants/article/broken-dreams-vietnamese-oakland-22337543.php"
  - restaurant: Burma Berkeley
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: Came here on a Friday late afternoon and it was practically empty. Friendly staff greeted and got seated immediately.
    recommendation: null
    mentions: 1
    source_urls[1]: "https://postcard.inc/places/burma-berkeley-berkeley-jHx1WXA5I8T"
  - restaurant: Cafe 86
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: fast-growing cafe
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sfchronicle.com/food/restaurants/article/peninsula-south-bay-new-open-19588946.php"
  - restaurant: Fat Cat x The Mantis
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: "Service leans bar-first, so grabbing a stool is still the quickest way to see what the kitchen is firing that night."
    recommendation: null
    mentions: 1
    source_urls[1]: "https://hoodline.com/2026/06/bernal-s-bubblegum-wine-bar-hides-a-shockingly-affordable-nine-course-feast"
  - restaurant: GA.RA
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 1
    source_urls[1]: "https://berkeleyside.org/2026/03/10/ga-ra-vietnamese-sheng-kee-marufuku-opening"
  - restaurant: Ghien Banh Mi & Cafe
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: sandwich shop / quick lunch spot
    recommendation: null
    mentions: 1
    source_urls[1]: "https://richmondsunsetnews.com/2026/07/08/tuan-luu-and-uyen-vu-of-luxury-spa-on-balboa-open-ghien-banh-mi-cafe"
  - restaurant: Glom Thai
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: soft opened
    recommendation: null
    mentions: 1
    source_urls[1]: "https://davidrvalva.com/blog/berkeleys-summer-opening-wave-doesnt-have-a-center"
  - restaurant: HolyShred
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 1
    source_urls[1]: "https://paloaltoonline.com/palo-alto/2026/08/26/holy-shred-thai-restaurant-opens-in-palo-alto"
  - restaurant: Jollibee
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: "dine-in and to-go options, fast-food chain"
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sfchronicle.com/food/restaurants/article/jollibee-sf-opening-date-22353875.php"
  - restaurant: Khao Tiew
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: wait times climbing up to 40 minutes on busy nights
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sfchronicle.com/food/restaurants/article/khao-tiew-thai-sf-19787392.php"
  - restaurant: Lacàphê
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: "On a Wednesday morning, staff were busy with a steady flow of single customers."
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sfchronicle.com/food/restaurants/article/lacaphe-vietnamese-coffee-18378960.php"
  - restaurant: Lao Garden
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: dine-in orders
    recommendation: null
    mentions: 1
    source_urls[1]: "https://richmondside.org/2025/02/06/restaurant-openings-east-bay-nossa-jaji-sirene"
  - restaurant: Ling Nam
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: fast-casual
    recommendation: null
    mentions: 1
    source_urls[1]: "https://richmondside.org/2026/07/21/gateway-highwire-milk-cloud-pop-bar-gregorys"
  - restaurant: Lunette
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: counter-service
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sfchronicle.com/food/restaurants/article/lunette-cambodian-ferry-building-19604782.php"
  - restaurant: Nem Nuong Nha Trang
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: small dining room with 16 seats and a patio under a gazebo
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sfchronicle.com/food/restaurants/article/nem-nuong-nha-trang-san-jose-21112213.php"
  - restaurant: Pamilya
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: fast-casual
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sfchronicle.com/food/restaurants/article/new-peninsula-south-bay-restaurants-20279662.php"
  - restaurant: Phin and Bowl
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 1
    source_urls[1]: "https://thesanjoseblog.com/2026/05/phin-and-bowl-debuts-on-third-street.html"
  - restaurant: Pho Ha Noi
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sfchronicle.com/food/restaurants/article/peninsula-south-bay-openings-18130821.php"
  - restaurant: Saam
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 1
    source_urls[1]: "https://hoodline.com/2026/07/michelin-starred-bangkok-chef-bets-on-brannan-street-with-a-menu-built-by-text"
  - restaurant: Saigon Yum
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 1
    source_urls[1]: "https://sanleandronext.com/2025-new-restaurant-roundup-a-year-in-review"
  - restaurant: Sawaan Thai Kitchen
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: null
    recommendation: null
    mentions: 1
    source_urls[1]: "https://axios.com/local/san-francisco/2026/07/15/san-francisco-summer-2026-restaurant-openings"
  - restaurant: Wanjai Cafe
    cuisine: null
    location: null
    opened: null
    casual_reason: null
    walkin_reason: cafe
    recommendation: null
    mentions: 1
    source_urls[1]: "https://newsbreak.com/mission-local-317599203/4480687986904-tenderloin-buzz-thai-tinis-a-vietnamese-t-t-festival-and-more"
notes[0]:

result set r258031e0e90 · 35 rows

restaurantcuisinelocationopenedcasual_reasonwalkin_reasonrecommendationmentionssource_urls
FOB Westnullnullnullnullfood hallnull5["https://richmondside.org/2026/04/09/fob-west-tita-beccas-butters-lena-gara-cocinita-nica-open", "https://allthe.news/sw/articles/new-east-bay-restaurants-int…
Jiamsnullnullnullnullnullnull5["https://richmondside.org/2026/04/21/homemade-cafe-dinner-causa-jiams-qargo-open", "https://richmondside.org/2026/05/06/starline-sable-lounge-lodge-sanaa-shak…
Cà Phê Việtnullnullnullnullquick stop and counter service layoutnull3["https://nationaltoday.com/us/ca/san-francisco/news/2026/04/15/new-vietnamese-cafe-brings-egg-coffee-and-banh-mi-to-downtown-san-francisco", "https://sf.eater…
Kathiew Housenullnullnullnullset up outside at A&R Marketnull3["https://berkeleyside.org/2026/05/05/bake-sum-teni-east-dave-busters-kathiew-house-starline-open", "https://richmondside.org/2026/05/05/bake-sum-teni-east-dav…
Le Soleilnullnullnullnullfood court settingnull3["https://postcard.inc/places/le-soleil-stonestown-san-francisco-cto0Ksq-LOk", "https://48hills.org/2025/09/best-of-the-bay-editors-pick-2025-stonestown", "htt…
Download all 35 rows · 14 KB
assistant

tool call · select

SELECT
  url,
  title,
  published_at,
  SEM_EXTRACT(
    content,
    'the restaurant location primarily discussed by the article',
    restaurant := 'restaurant name',
    cuisine := 'specific Southeast Asian cuisine or cuisines',
    address_area := 'street address if stated, plus city and neighborhood',
    opened := 'date this location first opened to the public, YYYY-MM-DD; use YYYY-MM if day is unavailable',
    service := 'ordering and service format',
    atmosphere := 'description showing whether the restaurant is casual or formal',
    reservations := 'explicit reservations or walk-in policy; if not explicit, state only operational facts such as counter service, kiosk, cafe, food hall, or takeout that support walk-in access',
    price := 'stated price range or representative menu-item prices',
    best_dishes := 'specific recommended or standout dishes',
    acclaim := 'critic verdict, best-new-list recognition, award, chef pedigree, or evidence of popularity',
    hours := 'current days and hours if stated',
    evidence := 'per_field'
  ) AS facts
FROM WEB_FETCH(
  'https://sfchronicle.com/food/restaurants/article/innenaskitchen-cambodian-oakland-22197685.php',
  'https://sfchronicle.com/food/restaurants/article/broken-dreams-vietnamese-oakland-22337543.php',
  'https://sfchronicle.com/food/restaurants/article/fob-west-prescott-market-oakland-22071463.php',
  'https://sf.eater.com/restaurant-news/210554/izzy-and-wooks-opening-saluhall-downtown-san-francisco',
  'https://sf.eater.com/restaurant-news/212134/ca-phe-viet-vietnamese-coffee-cafe-opening-san-francisco',
  'https://paloaltoonline.com/palo-alto/2026/08/26/holy-shred-thai-restaurant-opens-in-palo-alto',
  'https://sfchronicle.com/food/restaurants/article/nem-nuong-nha-trang-san-jose-21112213.php',
  'https://oaklandside.org/2025/08/11/east-bay-new-restaurants-july-cambodian-greek',
  'https://sfchronicle.com/food/restaurants/article/new-peninsula-south-bay-restaurants-20279662.php',
  'https://sfchronicle.com/food/restaurants/article/le-soleil-restaurant-stonestown-sf-20416010.php',
  'https://sf.eater.com/2025/1/14/24343678/senor-sisigs-filipino-american-new-thrive-city-restaurant-warriors-chase-center-opening',
  'https://sf.eater.com/dining-report/213437/payakk-review',
  'https://sfchronicle.com/food/restaurants/article/khao-tiew-thai-sf-19787392.php',
  'https://sfchronicle.com/food/restaurants/article/lunette-cambodian-ferry-building-19604782.php',
  'https://richmondside.org/2025/02/06/restaurant-openings-east-bay-nossa-jaji-sirene'
)
{
 "show_preview": false
}
tool result (16370 chars)
result_set_id: r1da23d41933
total_rows: 15
columns[4]: facts,published_at,title,url
rows[15]:
  - url: "https://www.sfchronicle.com/food/restaurants/article/innenaskitchen-cambodian-oakland-22197685.php"
    title: InNenasKitchen is Oakland’s most exciting new Cambodian restaurant
    published_at: 1776337200
    facts:
      restaurant: InNenasKitchen
      cuisine: null
      address_area: null
      opened: null
      service: counter service
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: # A landlord dispute helped create one of Oakland’s most exciting new restaurants,"Nena Neak started InNenasKitchen in March 2024 as a home restaurant in Fruitvale, selling bowls of kathiew, the Cambodian beef noodle soup."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence[2]: # A landlord dispute helped create one of Oakland’s most exciting new restaurants,"In March, she landed a residency at Oakland’s Aloha Club, where she now runs InNenasKitchen as a counter service spot."
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://www.sfchronicle.com/food/restaurants/article/broken-dreams-vietnamese-oakland-22337543.php"
    title: Broken Dreams is a new Vietnamese restaurant coming to Oakland
    published_at: 1784113200
    facts:
      restaurant: Broken Dreams
      cuisine: null
      address_area: null
      opened: null
      service: counter service
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: "Now Nguyen and her husband, Geoffrey Deetz, who was formerly chef-owner of Oakland Vietnamese spot Temple Club, [a 2018 Chronicle Top 100 restaurant](https://projects.sfchronicle.com/2018/top-100-restaurants/templeclub/), and executive chef of the French-Vietnamese Le Colonial, a longtime [San Francisco establishment](https://www.sfchronicle.com/restaurants/article/Le-Colonial-is-an-Orientalist-specter-14446833.php) with a controversial legacy, are opening a new Oakland fast-casual restaurant that will specialize in cơm tấm.","Broken Dreams, at 1312 Broadway, will debut on Aug. 10."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence[1]: "The restaurant will serve cơm tấm from a station where customers can choose toppings, similar to ordering a burrito, Deetz said."
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://www.sfchronicle.com/food/restaurants/article/fob-west-prescott-market-oakland-22071463.php"
    title: Filipino restaurant FOB West opens in Oakland's Prescott Market
    published_at: 1773313200
    facts:
      restaurant: FOB West
      cuisine: null
      address_area: null
      opened: null
      service: food hall
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: ## Key Points,"FOB West, an offshoot of chef-owner Janice Dulce’s [FOB Kitchen](https://www.sfchronicle.com/projects/2025/top-100-best-restaurants-san-francisco-bay-area/#fob-kitchen) in Oakland’s Temescal neighborhood, is now open inside Prescott Market at 1620 18th St. in [West Oakland](https://www.sfchronicle.com/food/restaurants/article/west-oakland-new-open-20232774.php), according to an Instagram [announcement](https://www.instagram.com/reels/DVwBWiVKQp-/)."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence[2]: ## Key Points,"It’s the latest addition to the [ambitious, 12,000-square-foot food hall that ](https://www.sfchronicle.com/food/restaurants/article/prescott-market-oakland-opening-20185691.php)opened last year with backing from a [major developer](https://www.bizjournals.com/sanfrancisco/news/2023/05/12/joe-ernsts-corner-of-oakland.html)."
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://sf.eater.com/restaurant-news/210554/izzy-and-wooks-opening-saluhall-downtown-san-francisco"
    title: A Filipino Sandwich Favorite Wants to Turn Saluhall Around
    published_at: 1767806807
    facts:
      restaurant: Izzy and Wooks
      cuisine: null
      address_area: null
      opened: null
      service: food hall
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[1]: "The Filipino and American burger heroes at [Izzy and Wooks](https://izzyandwooks.com/) open inside the space on Wednesday, January 14."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence[1]: "To the Smish Smash end, Manuel says he and Cheryl will focus on Izzy and Wooks’s fried chicken in the food hall."
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://sf.eater.com/restaurant-news/212134/ca-phe-viet-vietnamese-coffee-cafe-opening-san-francisco"
    title: Vietnamese Egg Coffee Comes to Downtown San Francisco
    published_at: 1776284424
    facts:
      restaurant: Cà Phê Việt
      cuisine: null
      address_area: null
      opened: null
      service: null
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: "Say hello to [Cà Phê Việt](https://www.caphe-viet.com/), located on New Montgomery and Minna streets.","[Dianne de Guzman](https://www.eater.com/authors/dianne-de-guzman)is the regional editor for Eater’s Northern California/Pacific Northwest sites, writing about restaurant and bar trends, upcoming openings, and pop-ups for the San Francisco Bay Area, Portland, and Seattle."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence: null
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://paloaltoonline.com/palo-alto/2026/08/26/holy-shred-thai-restaurant-opens-in-palo-alto"
    title: Stanford alum opens protein-forward Palo Alto Thai restaurant
    published_at: 1787770564
    facts:
      restaurant: HolyShred
      cuisine: null
      address_area: null
      opened: null
      service: null
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: Stanford alum opens protein-forward Palo Alto Thai restaurant,HolyShred is a fast-casual Thai restaurant located in the former Siam Fine Thai space on El Camino
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence: null
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://www.sfchronicle.com/food/restaurants/article/nem-nuong-nha-trang-san-jose-21112213.php"
    title: New restaurant Nem Nuong Nha Trang focuses on Vietnamese spring rolls
    published_at: 1762171200
    facts:
      restaurant: Nem Nuong Nha Trang
      cuisine: null
      address_area: null
      opened: null
      service: null
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: # This new Bay Area restaurant is selling thousands of spring rolls every weekend,"Nem Nuong Nha Trang, which quietly opened in April in San Jose’s Little Saigon, appears to be the only restaurant in the Bay Area to specialize in nem nuong cuon, fresh rolls loaded with juicy pork sausage grilled over charcoal."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence: null
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://oaklandside.org/2025/08/11/east-bay-new-restaurants-july-cambodian-greek/"
    title: "New Cambodian, Greek, Puerto Rican and Nigerian spots mark July openings"
    published_at: 1754944940
    facts:
      restaurant: Kien Svay Cafe
      cuisine: null
      address_area: null
      opened: null
      service: takeout
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[5]: "# New Cambodian, Greek, Puerto Rican and Nigerian spots mark July openings","Kien Svay Cafe, Greek Wonders, Puerto Rican Street Cuisine and 9jagrills are just a few of the East Bay restaurants to recently debut.",Oakland restaurant openings,"## [Kien Svay Cafe](https://www.instagram.com/kiensvaycafe/)","*07.24.25:* A casual outpost for Cambodian takeout food has arrived on the edge of East Oakland’s Clinton Park."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence[5]: "# New Cambodian, Greek, Puerto Rican and Nigerian spots mark July openings","Kien Svay Cafe, Greek Wonders, Puerto Rican Street Cuisine and 9jagrills are just a few of the East Bay restaurants to recently debut.",Oakland restaurant openings,"## [Kien Svay Cafe](https://www.instagram.com/kiensvaycafe/)","*07.24.25:* A casual outpost for Cambodian takeout food has arrived on the edge of East Oakland’s Clinton Park."
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://www.sfchronicle.com/food/restaurants/article/new-peninsula-south-bay-restaurants-20279662.php"
    title: New Peninsula and South Bay restaurants
    published_at: 1746529200
    facts: null
  - url: "https://www.sfchronicle.com/food/restaurants/article/le-soleil-restaurant-stonestown-sf-20416010.php"
    title: Le Soleil opens new SF location in Stonestown Galleria
    published_at: 1751713200
    facts:
      restaurant: Le Soleil
      cuisine: null
      address_area: null
      opened: null
      service: null
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: "# After 32 years, this S.F. restaurant family is back with a new contemporary Vietnamese spot","Together, they opened a restaurant together on Clement Street: Le Soleil, which would go on to be a treasured Vietnamese staple for over 30 years."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence: null
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://sf.eater.com/2025/1/14/24343678/senor-sisigs-filipino-american-new-thrive-city-restaurant-warriors-chase-center-opening"
    title: Señor Sisig’s Filipino American Street Food Gets a Signal Boost From the Warriors
    published_at: 1736881001
    facts:
      restaurant: Señor Sisig
      cuisine: null
      address_area: null
      opened: null
      service: null
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: # Señor Sisig’s Filipino American Street Food Gets a Signal Boost From the Warriors,"**It’s been 15 years since** [**Señor Sisig**](https://www.senorsisig.com/) launched its brand of Filipino Mexican dishes as a food truck, but its biggest milestone yet is just around the corner."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence: null
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://sf.eater.com/dining-report/213437/payakk-review"
    title: Pork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant
    published_at: 1787608859
    facts:
      restaurant: Payakk
      cuisine: null
      address_area: null
      opened: null
      service: null
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: # Pork Jowl Fried Rice and Produce-Studded Eggplant Star at This Impressive Thai Restaurant,"But while Secrets of Tiger feels casual, Pinpech’s new restaurant [Payakk](https://www.eater.com/venue/981835/payakk) is more considered, a spot that feels more date night-coded through moody lighting and gorgeously plated dishes."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence: null
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://www.sfchronicle.com/food/restaurants/article/khao-tiew-thai-sf-19787392.php"
    title: "Review: S.F.’s best new Thai restaurant draws crowds to a quiet area"
    published_at: 1727866800
    facts:
      restaurant: Khao Tiew
      cuisine: null
      address_area: null
      opened: null
      service: null
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: "To understand what Khao Tiew does best, look no further than the engrossing beef fried rice ($25).",## Khao Tiew
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence: null
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://www.sfchronicle.com/food/restaurants/article/lunette-cambodian-ferry-building-19604782.php"
    title: "Restaurant review: Lunette in SF helps usher in a new era of dining"
    published_at: 1723028400
    facts:
      restaurant: Lunette
      cuisine: null
      address_area: null
      opened: null
      service: counter-service
      atmosphere: null
      reservations: null
      price: null
      best_dishes: null
      acclaim: null
      hours: null
      restaurant_evidence[2]: # This hard-to-find cuisine rocks San Francisco’s biggest culinary stage,"You’ll come to know the subtleties of black pepper at Lunette, a casual new Cambodian restaurant that’s the latest addition to San Francisco’s Ferry Building."
      cuisine_evidence: null
      address_area_evidence: null
      opened_evidence: null
      service_evidence[2]: # This hard-to-find cuisine rocks San Francisco’s biggest culinary stage,"Where Nyum Bai was a full-service restaurant, Lunette is counter-service and intimate, with a focus on quick, one-plate lunches."
      atmosphere_evidence: null
      reservations_evidence: null
      price_evidence: null
      best_dishes_evidence: null
      acclaim_evidence: null
      hours_evidence: null
  - url: "https://richmondside.org/2025/02/06/restaurant-openings-east-bay-nossa-jaji-sirene/"
    title: New options for craft cocktails come to East Bay with January openings
    published_at: 1738872000
    facts: null
notes[1,]{text}:
  "Fetch result set: r867412b71a3 (15 rows), reference it as FROM r867412b71a3 in follow-up queries"

result set r1da23d41933 · 15 rows

urltitlepublished_atfacts
https://www.sfchronicle.com/food/restaurants/article/innenaskitchen-cambodian-oakland-22197685.phpInNenasKitchen is Oakland’s most exciting new Cambodian restaurant1776337200{"restaurant": "InNenasKitchen", "cuisine": null, "address_area": null, "opened": null, "service": "counter service", "atmosphere": null, "reservations": null,…
https://www.sfchronicle.com/food/restaurants/article/broken-dreams-vietnamese-oakland-22337543.phpBroken Dreams is a new Vietnamese restaurant coming to Oakland1784113200{"restaurant": "Broken Dreams", "cuisine": null, "address_area": null, "opened": null, "service": "counter service", "atmosphere": null, "reservations": null, …
https://www.sfchronicle.com/food/restaurants/article/fob-west-prescott-market-oakland-22071463.phpFilipino restaurant FOB West opens in Oakland's Prescott Market1773313200{"restaurant": "FOB West", "cuisine": null, "address_area": null, "opened": null, "service": "food hall", "atmosphere": null, "reservations": null, "price": nu…
https://sf.eater.com/restaurant-news/210554/izzy-and-wooks-opening-saluhall-downtown-san-franciscoA Filipino Sandwich Favorite Wants to Turn Saluhall Around1767806807{"restaurant": "Izzy and Wooks", "cuisine": null, "address_area": null, "opened": null, "service": "food hall", "atmosphere": null, "reservations": null, "pric…
https://sf.eater.com/restaurant-news/212134/ca-phe-viet-vietnamese-coffee-cafe-opening-san-franciscoVietnamese Egg Coffee Comes to Downtown San Francisco1776284424{"restaurant": "Cà Phê Việt", "cuisine": null, "address_area": null, "opened": null, "service": null, "atmosphere": null, "reservations": null, "price": null, …
Download all 15 rows · 17 KB
assistant

tool call · select

SELECT
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN 1
    WHEN 'Nem Nuong Nha Trang' THEN 2
    WHEN 'FOB West' THEN 3
    WHEN 'Le Soleil' THEN 4
    WHEN 'Izzy and Wooks' THEN 5
    WHEN 'Señor Sisig' THEN 6
    WHEN 'Kien Svay Cafe' THEN 7
    WHEN 'Cà Phê Việt' THEN 8
    WHEN 'HolyShred' THEN 9
  END AS pick_order,
  facts.restaurant AS restaurant,
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN 'Cambodian'
    WHEN 'Nem Nuong Nha Trang' THEN 'Vietnamese'
    WHEN 'FOB West' THEN 'Filipino'
    WHEN 'Le Soleil' THEN 'Contemporary Vietnamese'
    WHEN 'Izzy and Wooks' THEN 'Filipino-American'
    WHEN 'Señor Sisig' THEN 'Filipino-Mexican'
    WHEN 'Kien Svay Cafe' THEN 'Cambodian'
    WHEN 'Cà Phê Việt' THEN 'Vietnamese café'
    WHEN 'HolyShred' THEN 'Thai'
  END AS cuisine,
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN 'Aloha Club, Oakland'
    WHEN 'Nem Nuong Nha Trang' THEN 'Little Saigon, San Jose'
    WHEN 'FOB West' THEN 'Prescott Market, West Oakland'
    WHEN 'Le Soleil' THEN 'Stonestown Galleria, San Francisco'
    WHEN 'Izzy and Wooks' THEN 'Saluhall, downtown San Francisco'
    WHEN 'Señor Sisig' THEN 'Thrive City, Mission Bay, San Francisco'
    WHEN 'Kien Svay Cafe' THEN 'Clinton Park, Oakland'
    WHEN 'Cà Phê Việt' THEN 'New Montgomery & Minna, San Francisco'
    WHEN 'HolyShred' THEN 'El Camino Real, Palo Alto'
  END AS area,
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN 37.779
    WHEN 'Nem Nuong Nha Trang' THEN 37.331
    WHEN 'FOB West' THEN 37.812
    WHEN 'Le Soleil' THEN 37.728
    WHEN 'Izzy and Wooks' THEN 37.783
    WHEN 'Señor Sisig' THEN 37.768
    WHEN 'Kien Svay Cafe' THEN 37.780
    WHEN 'Cà Phê Việt' THEN 37.786
    WHEN 'HolyShred' THEN 37.426
  END AS latitude_approx,
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN -122.225
    WHEN 'Nem Nuong Nha Trang' THEN -121.857
    WHEN 'FOB West' THEN -122.292
    WHEN 'Le Soleil' THEN -122.476
    WHEN 'Izzy and Wooks' THEN -122.408
    WHEN 'Señor Sisig' THEN -122.387
    WHEN 'Kien Svay Cafe' THEN -122.235
    WHEN 'Cà Phê Việt' THEN -122.400
    WHEN 'HolyShred' THEN -122.145
  END AS longitude_approx,
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN 'March 2026 at Aloha Club (the project began as a home restaurant in 2024)'
    WHEN 'Nem Nuong Nha Trang' THEN 'April 2025'
    WHEN 'FOB West' THEN 'March 2026'
    WHEN 'Le Soleil' THEN 'mid-June 2025'
    WHEN 'Izzy and Wooks' THEN 'January 14, 2026'
    WHEN 'Señor Sisig' THEN 'January 21, 2025'
    WHEN 'Kien Svay Cafe' THEN 'July 2025 (reported July 24)'
    WHEN 'Cà Phê Việt' THEN 'April 2026'
    WHEN 'HolyShred' THEN 'August 2026'
  END AS opened,
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN 'Counter service inside a neighborhood bar'
    WHEN 'Nem Nuong Nha Trang' THEN 'Tiny 16-seat specialist with patio; focused menu'
    WHEN 'FOB West' THEN 'Food-hall stall'
    WHEN 'Le Soleil' THEN 'Mall food-court location'
    WHEN 'Izzy and Wooks' THEN 'Food-hall fried-chicken and sandwich counter'
    WHEN 'Señor Sisig' THEN 'Filipino-Mexican street-food restaurant'
    WHEN 'Kien Svay Cafe' THEN 'Casual takeout outpost'
    WHEN 'Cà Phê Việt' THEN 'Vietnamese coffee and bánh mì café'
    WHEN 'HolyShred' THEN 'Fast-casual, protein-forward Thai'
  END AS casual_format,
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN 'Yes — counter service'
    WHEN 'Nem Nuong Nha Trang' THEN 'Yes — small dining room/patio; expect a wait at peaks'
    WHEN 'FOB West' THEN 'Yes — food-hall seating'
    WHEN 'Le Soleil' THEN 'Yes — food-court service'
    WHEN 'Izzy and Wooks' THEN 'Yes — food-hall counter'
    WHEN 'Señor Sisig' THEN 'Yes — casual street-food format'
    WHEN 'Kien Svay Cafe' THEN 'Yes — takeout-focused'
    WHEN 'Cà Phê Việt' THEN 'Yes — café/counter format'
    WHEN 'HolyShred' THEN 'Yes — fast-casual format'
  END AS walkin_fit,
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN 'The Chronicle called it one of Oakland’s most exciting new restaurants; go for Cambodian kathiew.'
    WHEN 'Nem Nuong Nha Trang' THEN 'The Chronicle reported thousands of charcoal-grilled pork spring rolls sold each weekend and called it the Bay Area’s only specialist.'
    WHEN 'FOB West' THEN 'An accessible offshoot of chef Janice Dulce’s FOB Kitchen, a Chronicle Top 100 restaurant.'
    WHEN 'Le Soleil' THEN 'A contemporary offshoot of a treasured Vietnamese restaurant family with more than 30 years in San Francisco.'
    WHEN 'Izzy and Wooks' THEN 'Eater’s Filipino-American “burger heroes,” now emphasizing fried chicken at Saluhall.'
    WHEN 'Señor Sisig' THEN 'A major new home for a pioneering Bay Area Filipino-Mexican food-truck brand.'
    WHEN 'Kien Svay Cafe' THEN 'One of the few new casual Cambodian takeout specialists in the East Bay.'
    WHEN 'Cà Phê Việt' THEN 'A downtown specialist for Vietnamese egg coffee plus bánh mì.'
    WHEN 'HolyShred' THEN 'One of the Peninsula’s newest fast-casual Thai openings, with a protein-forward angle.'
  END AS why_it_made_the_list,
  CASE facts.restaurant
    WHEN 'InNenasKitchen' THEN 'Kathiew (Cambodian beef noodle soup)'
    WHEN 'Nem Nuong Nha Trang' THEN 'Nem nướng cuốn (charcoal-grilled pork spring rolls)'
    WHEN 'FOB West' THEN 'Filipino food-hall menu from the FOB Kitchen team'
    WHEN 'Le Soleil' THEN 'Contemporary Vietnamese dishes'
    WHEN 'Izzy and Wooks' THEN 'Filipino-American fried chicken and sandwiches'
    WHEN 'Señor Sisig' THEN 'Sisig in Filipino-Mexican street-food formats'
    WHEN 'Kien Svay Cafe' THEN 'Cambodian takeout specialties'
    WHEN 'Cà Phê Việt' THEN 'Vietnamese egg coffee and bánh mì'
    WHEN 'HolyShred' THEN 'Protein-forward Thai dishes'
  END AS what_to_order,
  'Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.' AS methodology_note,
  url AS source_url
FROM r1da23d41933
WHERE facts.restaurant IN (
  'InNenasKitchen',
  'Nem Nuong Nha Trang',
  'FOB West',
  'Le Soleil',
  'Izzy and Wooks',
  'Señor Sisig',
  'Kien Svay Cafe',
  'Cà Phê Việt',
  'HolyShred'
)
ORDER BY pick_order
{
 "show_preview": false
}
tool result (6160 chars)
result_set_id: rdd5fac7defd
total_rows: 9
columns[13]: area,casual_format,cuisine,latitude_approx,longitude_approx,methodology_note,opened,pick_order,restaurant,source_url,walkin_fit,what_to_order,why_it_made_the_list
rows[9,]{pick_order,restaurant,cuisine,area,latitude_approx,longitude_approx,opened,casual_format,walkin_fit,why_it_made_the_list,what_to_order,methodology_note,source_url}:
  1,InNenasKitchen,Cambodian,"Aloha Club, Oakland",37.779,-122.225,March 2026 at Aloha Club (the project began as a home restaurant in 2024),Counter service inside a neighborhood bar,Yes — counter service,The Chronicle called it one of Oakland’s most exciting new restaurants; go for Cambodian kathiew.,Kathiew (Cambodian beef noodle soup),"Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.","https://www.sfchronicle.com/food/restaurants/article/innenaskitchen-cambodian-oakland-22197685.php"
  2,Nem Nuong Nha Trang,Vietnamese,"Little Saigon, San Jose",37.331,-121.857,April 2025,Tiny 16-seat specialist with patio; focused menu,Yes — small dining room/patio; expect a wait at peaks,The Chronicle reported thousands of charcoal-grilled pork spring rolls sold each weekend and called it the Bay Area’s only specialist.,Nem nướng cuốn (charcoal-grilled pork spring rolls),"Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.","https://www.sfchronicle.com/food/restaurants/article/nem-nuong-nha-trang-san-jose-21112213.php"
  3,FOB West,Filipino,"Prescott Market, West Oakland",37.812,-122.292,March 2026,Food-hall stall,Yes — food-hall seating,"An accessible offshoot of chef Janice Dulce’s FOB Kitchen, a Chronicle Top 100 restaurant.",Filipino food-hall menu from the FOB Kitchen team,"Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.","https://www.sfchronicle.com/food/restaurants/article/fob-west-prescott-market-oakland-22071463.php"
  4,Le Soleil,Contemporary Vietnamese,"Stonestown Galleria, San Francisco",37.728,-122.476,mid-June 2025,Mall food-court location,Yes — food-court service,A contemporary offshoot of a treasured Vietnamese restaurant family with more than 30 years in San Francisco.,Contemporary Vietnamese dishes,"Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.","https://www.sfchronicle.com/food/restaurants/article/le-soleil-restaurant-stonestown-sf-20416010.php"
  5,Izzy and Wooks,Filipino-American,"Saluhall, downtown San Francisco",37.783,-122.408,"January 14, 2026",Food-hall fried-chicken and sandwich counter,Yes — food-hall counter,"Eater’s Filipino-American “burger heroes,” now emphasizing fried chicken at Saluhall.",Filipino-American fried chicken and sandwiches,"Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.","https://sf.eater.com/restaurant-news/210554/izzy-and-wooks-opening-saluhall-downtown-san-francisco"
  6,Señor Sisig,Filipino-Mexican,"Thrive City, Mission Bay, San Francisco",37.768,-122.387,"January 21, 2025",Filipino-Mexican street-food restaurant,Yes — casual street-food format,A major new home for a pioneering Bay Area Filipino-Mexican food-truck brand.,Sisig in Filipino-Mexican street-food formats,"Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.","https://sf.eater.com/2025/1/14/24343678/senor-sisigs-filipino-american-new-thrive-city-restaurant-warriors-chase-center-opening"
  7,Kien Svay Cafe,Cambodian,"Clinton Park, Oakland",37.78,-122.235,July 2025 (reported July 24),Casual takeout outpost,Yes — takeout-focused,One of the few new casual Cambodian takeout specialists in the East Bay.,Cambodian takeout specialties,"Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.","https://oaklandside.org/2025/08/11/east-bay-new-restaurants-july-cambodian-greek/"
  8,Cà Phê Việt,Vietnamese café,"New Montgomery & Minna, San Francisco",37.786,-122.4,April 2026,Vietnamese coffee and bánh mì café,Yes — café/counter format,A downtown specialist for Vietnamese egg coffee plus bánh mì.,Vietnamese egg coffee and bánh mì,"Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.","https://sf.eater.com/restaurant-news/212134/ca-phe-viet-vietnamese-coffee-cafe-opening-san-francisco"
  9,HolyShred,Thai,"El Camino Real, Palo Alto",37.426,-122.145,August 2026,"Fast-casual, protein-forward Thai",Yes — fast-casual format,"One of the Peninsula’s newest fast-casual Thai openings, with a protein-forward angle.",Protein-forward Thai dishes,"Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based assessment, not a quoted reservation policy. Check same-day hours before traveling.","https://paloaltoonline.com/palo-alto/2026/08/26/holy-shred-thai-restaurant-opens-in-palo-alto"
notes[0]:

result set rdd5fac7defd · 9 rows

pick_orderrestaurantcuisinearealatitude_approxlongitude_approxopenedcasual_formatwalkin_fitwhy_it_made_the_listwhat_to_ordermethodology_notesource_url
1InNenasKitchenCambodianAloha Club, Oakland37.779-122.225March 2026 at Aloha Club (the project began as a home restaurant in 2024)Counter service inside a neighborhood barYes — counter serviceThe Chronicle called it one of Oakland’s most exciting new restaurants; go for Cambodian kathiew.Kathiew (Cambodian beef noodle soup)Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based a…https://www.sfchronicle.com/food/restaurants/article/innenaskitchen-cambodian-oakland-22197685.php
2Nem Nuong Nha TrangVietnameseLittle Saigon, San Jose37.331-121.857April 2025Tiny 16-seat specialist with patio; focused menuYes — small dining room/patio; expect a wait at peaksThe Chronicle reported thousands of charcoal-grilled pork spring rolls sold each weekend and called it the Bay Area’s only specialist.Nem nướng cuốn (charcoal-grilled pork spring rolls)Walk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based a…https://www.sfchronicle.com/food/restaurants/article/nem-nuong-nha-trang-san-jose-21112213.php
3FOB WestFilipinoPrescott Market, West Oakland37.812-122.292March 2026Food-hall stallYes — food-hall seatingAn accessible offshoot of chef Janice Dulce’s FOB Kitchen, a Chronicle Top 100 restaurant.Filipino food-hall menu from the FOB Kitchen teamWalk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based a…https://www.sfchronicle.com/food/restaurants/article/fob-west-prescott-market-oakland-22071463.php
4Le SoleilContemporary VietnameseStonestown Galleria, San Francisco37.728-122.476mid-June 2025Mall food-court locationYes — food-court serviceA contemporary offshoot of a treasured Vietnamese restaurant family with more than 30 years in San Francisco.Contemporary Vietnamese dishesWalk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based a…https://www.sfchronicle.com/food/restaurants/article/le-soleil-restaurant-stonestown-sf-20416010.php
5Izzy and WooksFilipino-AmericanSaluhall, downtown San Francisco37.783-122.408January 14, 2026Food-hall fried-chicken and sandwich counterYes — food-hall counterEater’s Filipino-American “burger heroes,” now emphasizing fried chicken at Saluhall.Filipino-American fried chicken and sandwichesWalk-in suitability is explicit where the source states counter, takeout, food-hall, food-court, café, or fast-casual service; otherwise it is a format-based a…https://sf.eater.com/restaurant-news/210554/izzy-and-wooks-opening-saluhall-downtown-san-francisco
Download all 9 rows · 8 KB
assistant

tool call · generate_html_report

{"brief":"Question asked verbatim: “What are the best new southeast asian restaurants in the bay area? They should be open since 2025, casual, and take walk-ins.”\n\nFinding: As of 2026-08-31, the strongest verified shortlist is nine casual Bay Area Southeast Asian openings from 2025–2026 that work for walk-ins: InNenasKitchen (Oakland), Nem Nuong Nha Trang (San Jose), FOB West (West Oakland), Le Soleil at Stonestown (San Francisco), Izzy and Wooks at Saluhall (San Francisco), Señor Sisig at Thrive City (San Francisco), Kien Svay Cafe (Oakland), Cà Phê Việt (San Francisco), and HolyShred (Palo Alto). Lead with InNenasKitchen and Nem Nuong Nha Trang as the most compelling destination picks: the former was called one of Oakland’s most exciting new restaurants, and the latter reportedly sells thousands of its specialty charcoal-grilled pork spring rolls each weekend. FOB West is the best easy food-hall choice tied to an acclaimed parent restaurant.\n\nrdd5fac7defd holds the final ranked shortlist, one row per restaurant, including approximate latitude/longitude for a Bay Area map, cuisine, neighborhood, opening date, casual-service format, walk-in rationale, why it made the list, what to order, caveat, and source URL. Use it for all cards/table/map. The coordinates are approximate neighborhood/venue coordinates, not survey-grade geocodes.\n\nBuild a beautiful, useful dining guide led by ONE large Bay Area map, with numbered points corresponding to the ranked picks. Follow with concise restaurant cards and a scan-friendly comparison table. Visually distinguish “destination picks” (top three) from “easy casual options.” Emphasize geographic spread and cuisine diversity. Walk-in suitability is directly supported by operational format where sources state counter service, takeout, café, food-hall, food-court, or fast-casual service; for the tiny San Jose specialist, walk-in suitability is an assessment from its small dining-room/patio format rather than a quoted no-reservations policy. Do not imply guaranteed immediate seating. Advise readers to check same-day hours and expect waits at popular small spots. The opening threshold applies to each listed location; InNenasKitchen’s physical counter residency opened in March 2026, though the business began as a home restaurant in 2024. Keep source links prominent and make the design polished, warm, and food-forward.","result_set_ids":["rdd5fac7defd"],"title":"Best New Casual Southeast Asian Restaurants in the Bay Area","prev_report_token":null}