SQLite Web: event

seq

Primary key. INTEGER

id

TEXT NOT NULL

kind

TEXT NOT NULL

ts

TEXT NOT NULL

actor

TEXT

subject_entity_ids

TEXT

payload

{"fetched_at":"2026-04-03T11:18:29.330266+00:00","meta":{"serper":{"has_answer_box":false,"has_knowledge_graph":false,"organic_count":5,"top_stories_count":0}},"provider":"serper","query":"fun things to do in San Francisco","raw":{"organic":[{"date":"7 days ago","link":"https://www.reddit.com/r/AskSF/comments/1s5cb59/what_to_do_in_sf_this_weekend_or_in_general_that/","position":1,"sitelinks":[{"link":"https://www.reddit.com/r/AskSF/comments/1s8g592/what_are_your_favorite_ways_to_find_fun_hidden/","title":"What are your favorite ways to find fun hidden gem events in the city ..."},{"link":"https://www.reddit.com/r/usatravel/comments/1rx17a1/first_time_in_california_san_francisco/","title":"First time in California, San Francisco- Recommendations : r/usatravel"}],"snippet":"Take a water taxi to Sausalito from Ferry Building, or go to Alameda, there is a USS Hornet warship museum in Alameda, very cool experience. Stalk and persuade ...","title":"What to do in SF this weekend (or in general) that doesn't involve ..."},{"attributes":{"Missing":"fun | Show results with:fun"},"date":"Mar 25, 2026","link":"https://www.tripadvisor.com.au/ShowTopic-g28926-i29-k14208551-5_Days_in_San_Francisco_with_teens_Itinerary_advice-California.html","position":2,"snippet":"5 Days in San Francisco with teens Itinerary advice ; An abbreviated guide to national-parks stargazing \u00b7 5 min read \u00b7 By Sarah Kuta ; 6 stunning superblooms worth ...","title":"5 Days in San Francisco with teens Itinerary advice - California Forum"},{"date":"Mar 9, 2026","link":"https://www.quora.com/If-you-were-in-San-Francisco-where-are-you-now","position":3,"snippet":"Ride a cable car from Hallidie Plaza to Ghirardelli Square. Wander around in the North Beach area at night. I'm leaving far too much out, and I'm ignoring the ...","title":"If you were in San Francisco, where are you now? - Quora"},{"date":"Mar 24, 2026","link":"https://www.tripadvisor.com/ShowTopic-g60713-i30-k14419460-Thanks_for_the_recommendation_on_Radhaus-San_Francisco_California.html","position":4,"snippet":"On our recent trip to SF in May we ate at Radhaus in Fort Mason. We had gone to the De Young Museum for the Ansel Adams exhibit (wonderful!)","title":"Thanks for the recommendation on Radhaus - San Francisco Forum"},{"date":"Mar 24, 2026","link":"https://www.tripadvisor.com/ShowTopic-g60713-i30-k13680171-San_Francisco_Trip_with_Kids_and_a_Dog-San_Francisco_California.html","position":5,"snippet":"I'm looking for activities to do with both kids and a dog in San Francisco. The kids are 8 (girl) and 12 (boy). My dog is a 1-year-old Maltipoo (he is well ...","title":"San Francisco Trip with Kids and a Dog - Tripadvisor"}],"searchParameters":{"engine":"google","num":5,"q":"fun things to do in San Francisco","tbs":"qdr:d30","type":"search"}},"recency_days":30,"request":{"api_key_env":"SERPER_API_KEY","endpoint":"https://google.serper.dev/search","max_results":5,"provider":"serper","query_sha256":"76248193584e1cc9bb7392db41f7f8dc94ba2cb2ead12f9458532d86b67d46df","recency_days":30,"timeout_seconds":12},"results":[{"display":"","extra":{"date":"7 days ago","position":1,"sitelinks":[{"link":"https://www.reddit.com/r/AskSF/comments/1s8g592/what_are_your_favorite_ways_to_find_fun_hidden/","title":"What are your favorite ways to find fun hidden gem events in the city ..."},{"link":"https://www.reddit.com/r/usatravel/comments/1rx17a1/first_time_in_california_san_francisco/","title":"First time in California, San Francisco- Recommendations : r/usatravel"}]},"kind":"organic","rank":1,"snippet":"Take a water taxi to Sausalito from Ferry Building, or go to Alameda, there is a USS Hornet warship museum in Alameda, very cool experience. Stalk and persuade ...","title":"What to do in SF this weekend (or in general) that doesn't involve ...","url":"https://www.reddit.com/r/AskSF/comments/1s5cb59/what_to_do_in_sf_this_weekend_or_in_general_that/"},{"display":"","extra":{"date":"Mar 25, 2026","position":2},"kind":"organic","rank":2,"snippet":"5 Days in San Francisco with teens Itinerary advice ; An abbreviated guide to national-parks stargazing \u00b7 5 min read \u00b7 By Sarah Kuta ; 6 stunning superblooms worth ...","title":"5 Days in San Francisco with teens Itinerary advice - California Forum","url":"https://www.tripadvisor.com.au/ShowTopic-g28926-i29-k14208551-5_Days_in_San_Francisco_with_teens_Itinerary_advice-California.html"},{"display":"","extra":{"date":"Mar 9, 2026","position":3},"kind":"organic","rank":3,"snippet":"Ride a cable car from Hallidie Plaza to Ghirardelli Square. Wander around in the North Beach area at night. I'm leaving far too much out, and I'm ignoring the ...","title":"If you were in San Francisco, where are you now? - Quora","url":"https://www.quora.com/If-you-were-in-San-Francisco-where-are-you-now"},{"display":"","extra":{"date":"Mar 24, 2026","position":4},"kind":"organic","rank":4,"snippet":"On our recent trip to SF in May we ate at Radhaus in Fort Mason. We had gone to the De Young Museum for the Ansel Adams exhibit (wonderful!)","title":"Thanks for the recommendation on Radhaus - San Francisco Forum","url":"https://www.tripadvisor.com/ShowTopic-g60713-i30-k14419460-Thanks_for_the_recommendation_on_Radhaus-San_Francisco_California.html"},{"display":"","extra":{"date":"Mar 24, 2026","position":5},"kind":"organic","rank":5,"snippet":"I'm looking for activities to do with both kids and a dog in San Francisco. The kids are 8 (girl) and 12 (boy). My dog is a 1-year-old Maltipoo (he is well ...","title":"San Francisco Trip with Kids and a Dog - Tripadvisor","url":"https://www.tripadvisor.com/ShowTopic-g60713-i30-k13680171-San_Francisco_Trip_with_Kids_and_a_Dog-San_Francisco_California.html"}],"status":"ok"}

TEXT NOT NULL

source_ref

TEXT

confidence

REAL (default 0.0

dedupe_key

TEXT

episode_id

TEXT

created_at

TEXT NOT NULL (default strftime('%Y-%m-%dT%H:%M:%fZ','now')

event_store.db — events

Update row 1232 in events