`cited_urls`

View

All-time; not windowable (no day field). URL citation funnel separating engine-observed source events and synthetic search candidates. Retrieved is citations plus observed sources, never synthetic search. Observed SERP candidates are not proof the engine read a page; citation_rate is cited / observed events. Filtering last_seen_at selects URLs, it does not window the counts. For windowed reach use citation_facts (filter run_at); for dashboard-identical headline numbers, anchored windows and deltas, use read report_top_cited or report_sources.

Max rows per query: 100
Default order: cited desc
Required filter: one of project_id
Max offset: 2000
Cursor paging: by id

Filter project_id and day where available. For dashboard-identical headline numbers, anchored windows and deltas, use read report_*.

Fields

Field	Type	Description	Filter	Sort
`id`	`string`	Stable identifier for this aggregate row.	–	✓
`project_id` indexed	`string`	Project ID from projects.	✓	–
`url`	`string`	Source URL.	✓	✓
`domain`	`string`	Stored source domain.	✓	✓
`cited`	`integer`	Visible citation events.	✓	✓
`considered`	`integer`	Deprecated alias of engine_observed_considered; synthetic candidates excluded.	✓	✓
`retrieved`	`integer`	Visible citations plus engine-observed uncited sources; synthetic candidates excluded.	✓	✓
`citation_rate` nullable	`number`	Visible citations / observed events as a rounded percent, null with no observed events.	✓	✓
`engine_observed_considered`	`integer`	Uncited source events observed in engine or provider response, excluding synthetic search.	✓	✓
`synthetic_search`	`integer`	Synthetic search candidates; not evidence of engine retrieval and excluded from citation_rate.	✓	✓
`prompts`	`integer`	Distinct prompts with observed events for this URL.	✓	✓
`engines`	`string[]`	Engines with observed events for this URL.	✓	–
`answers`	`integer`	Distinct answer runs with observed events for this URL.	✓	✓
`last_seen_at` nullable	`datetime`	Most recent answer time with a visible citation or engine-observed source for this URL; synthetic candidates excluded, null when only synthetic candidates exist.	✓	✓
`last_candidate_at` nullable	`datetime`	Most recent answer time with a synthetic search candidate for this URL, null when none.	✓	✓

Examples

Example

SELECT id, project_id, url, domain, cited
FROM cited_urls
WHERE project_id = $1
ORDER BY cited DESC
LIMIT 25

Calling it

MCP

Tool call

query({"sql":"SELECT id, project_id, url, domain, cited FROM cited_urls WHERE project_id = $1 ORDER BY cited DESC LIMIT 25","params":["<value 1>"]})

REST

curl

curl -X POST "https://app.sensorhub.ai/api/v1/query" \
  -H "Authorization: Bearer $API_KEY" \
  -H "Content-Type: application/json" \
  --data-binary @- <<'JSON'
{
  "sql": "SELECT id, project_id, url, domain, cited FROM cited_urls WHERE project_id = $1 ORDER BY cited DESC LIMIT 25",
  "params": [
    "<value 1>"
  ]
}
JSON

Row JSON Schema

json

{
  "type": "object",
  "description": "All-time; not windowable (no day field). URL citation funnel separating engine-observed source events and synthetic search candidates. Retrieved is citations plus observed sources, never synthetic search. Observed SERP candidates are not proof the engine read a page; citation_rate is cited / observed events. Filtering last_seen_at selects URLs, it does not window the counts. For windowed reach use citation_facts (filter run_at); for dashboard-identical headline numbers, anchored windows and deltas, use read report_top_cited or report_sources.",
  "properties": {
    "id": {
      "type": "string",
      "description": "Stable identifier for this aggregate row.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": false,
      "x-sensorhub-sortable": true
    },
    "project_id": {
      "type": "string",
      "description": "Project ID from projects.",
      "x-sensorhub-indexed": true,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": false
    },
    "url": {
      "type": "string",
      "description": "Source URL.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "domain": {
      "type": "string",
      "description": "Stored source domain.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "cited": {
      "type": "integer",
      "description": "Visible citation events.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "considered": {
      "type": "integer",
      "description": "Deprecated alias of engine_observed_considered; synthetic candidates excluded.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "retrieved": {
      "type": "integer",
      "description": "Visible citations plus engine-observed uncited sources; synthetic candidates excluded.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "citation_rate": {
      "type": [
        "number",
        "null"
      ],
      "description": "Visible citations / observed events as a rounded percent, null with no observed events.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "engine_observed_considered": {
      "type": "integer",
      "description": "Uncited source events observed in engine or provider response, excluding synthetic search.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "synthetic_search": {
      "type": "integer",
      "description": "Synthetic search candidates; not evidence of engine retrieval and excluded from citation_rate.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "prompts": {
      "type": "integer",
      "description": "Distinct prompts with observed events for this URL.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "engines": {
      "type": "array",
      "description": "Engines with observed events for this URL.",
      "items": {
        "type": "string"
      },
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": false,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": false
    },
    "answers": {
      "type": "integer",
      "description": "Distinct answer runs with observed events for this URL.",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "last_seen_at": {
      "type": [
        "string",
        "null"
      ],
      "description": "Most recent answer time with a visible citation or engine-observed source for this URL; synthetic candidates excluded, null when only synthetic candidates exist.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    },
    "last_candidate_at": {
      "type": [
        "string",
        "null"
      ],
      "description": "Most recent answer time with a synthetic search candidate for this URL, null when none.",
      "format": "date-time",
      "x-sensorhub-indexed": false,
      "x-sensorhub-searchable": false,
      "x-sensorhub-aggregatable": true,
      "x-sensorhub-filterable": true,
      "x-sensorhub-sortable": true
    }
  },
  "additionalProperties": false
}