Source

Query Quora expert answers with SQL

Full-text Quora answers from topic-ranked, view-ranked writers, with question, credential, upvotes, and views — queryable with read-only SQL by writer and text.

Surface

  • Records23.2M+ answers
  • Canonicalquora.answers
  • FreshnessLive
  • Extentcreation_time 2009-10-08 to 2026-08-26
  • Cadencelive: new answers land within minutes
  • MethodPublic Quora answer pages; source-native answer records with writer credentials.
  • StatsLast stats snapshot: 2026-08-27T12:07:10Z

Query surfaces

  • quora.answers
  • quora.writers

Public Quora answer pages; source-native answer records with writer credentials.

Best for

a writer’s answers ranked by upvotes, with the stated credential
token search across question title plus answer body
expertise signal per writer from quora.writers, joined on author_slug

Fields

  • aid
  • url
  • author_slug
  • author_uid
  • question_title
  • question_url
  • question_answer_count
  • creation_time
  • updated_time
  • num_upvotes
  • num_views
  • num_shares
  • credential
  • content
  • content_raw
  • harvested_slug
  • harvested_at
  • source_file
  • loaded_at
  • search_text_lc

Read live from the schema registry for quora.answers — 20 columns. Every relation's full contract is served by /v1/scry/schema.

Indexed predicates

  • PruneshasToken(search_text_lc, '<lowercase-token>')
  • PruneshasAllTokens(search_text_lc, ['<t1>','<t2>'])
  • PruneshasAnyTokens(search_text_lc, ['<t1>','<t2>'])
  • Prunesauthor_slug = '<slug>'

Queries

Most-upvoted answers on a topic

Match lowercase tokens across question and answer, collapse repeats, rank by upvotes.

SELECT aid, author_slug, question_title, num_upvotes, num_views, creation_time
FROM (
  SELECT * FROM quora.answers
  WHERE hasToken(search_text_lc, 'clickhouse')
  ORDER BY updated_time DESC
  LIMIT 1 BY aid
)
ORDER BY num_upvotes DESC
LIMIT 20;

Gaps

  • HolesNone declared on the live schema entry for quora.answers (declared holes are curation, not a measurement of completeness).
  • Notean answer can land more than once across harvests — collapse on aid (LIMIT 1 BY aid inside a subquery) before counting
  • Notedetected LLM answer-farm writers are excluded at ingest; that is a heuristic, not a certification that every remaining row is human-authored
  • Notesearch_text_lc concatenates the question title and the answer body