bet365.ended_events

Raw landing table for Bet365 ended-event payloads, written as-is by the Scrapy crawler. Each row holds one event keyed by key, with the full Bet365 response stored in the data ClickHouse JSON column.

Lineage

flowchart LR
scrapy([Scrapy: bet365 ended events]) --> me[(bet365__ended_events)]
me --> src[/sources.ended_events/]
click src "/sources/ended_events/" "Open sources.ended_events"

Columns

Column	Description	Formula / Source
key	Unique key for every event.	Set by the Scrapy loader; tested unique + not_null.
event_id	Bet365 event identifier.	Loader copy of data.id.
event_date	Event date (YYYY-MM-DD).	Derived by the loader from data.time.
event_partition_key	ClickHouse partition key.	Loader-controlled bucket (used for PARTITION BY).
event_count	Total events for this event_date/sport_id, used as a validation aid.	Loader-side counter.
data	Full Bet365 payload as ClickHouse JSON.	Verbatim API response.
extracted_at	Crawl timestamp.	now() at write time, used as loaded_at_field.
loaded_at	Optional downstream-load timestamp.	Usually empty; reserved for ETL tooling.