bet365.odds
Raw landing table for Bet365 odds payloads (per-event, per-snapshot). The ClickHouse JSON data column carries the nested odds arrays (data.1_1 → array of full-time 1×2 odd snapshots), which the typed sources.odds model then unfolds via array join.
Lineage
Section titled “Lineage”flowchart LR scrapy([Scrapy: bet365 odds]) --> me[(bet365__odds)] me --> src[/sources.odds/] click src "/sources/odds/" "Open sources.odds"
Columns
Section titled “Columns”| Column | Description | Formula / Source |
|---|---|---|
key | Unique key for every event. | Loader-set; tested unique + not_null. |
event_id | Bet365 event identifier. | Loader copy. |
event_date | Event date (YYYY-MM-DD). | Loader-derived. |
event_partition_key | ClickHouse partition key. | Loader-controlled bucket. |
event_count | Total events for this event_date/sport_id. | Loader-side counter. |
data | Full Bet365 odds payload (JSON). | Verbatim API response; arrays under data.1_1. |
extracted_at | Crawl timestamp. | now() at write time, used as loaded_at_field. |
loaded_at | Optional downstream-load timestamp. | Usually empty. |