{"schema_version":"mostlyright-public-catalog.v1","dataset":{"id":"4c728874-5dc9-48bd-b325-8b51c54924af","slug":"czech-horse-racing-results-19972026","title":"Czech horse racing results, 1997–2026","summary":"**Study Czech domestic horse-racing starts from 1997 through the latest published result.** This table combines Jockey Club Czech Republic meeting results and retrieval-time horse profiles with ČHMÚ weather observations and source provenance. It is intended as a raw, feature-engineering-ready base table rather than a finished model matrix.\n\n## Coverage\n\n- **Window:** 1997-01-01 through the latest published result, using Europe/Prague race dates.\n- **Grain:** one row per horse start in `horse_race_starts`, keyed by race, horse, and saddle number.\n- **Cadence:** whole-table rebuild; the upstream collection and weather sources do not expose one common bounded incremental cursor.\n\n## Contents\n\n- Race, entry and connection facts available around race time, including IDs, venue/course, schedule, conditions, advertised prize, horse, stable, weight, equipment, jockey and trainer.\n- Observed result facts, including finish/status, time, margin, earnings, equivalent rating, sectionals and race verdict text.\n- Retrieval-time horse-profile facts, pedigree and raw profile fields. These describe the current fetched profile and must not be assumed historically point-in-time.\n- Weather station mapping and daily observations. Race-day daily aggregates are observed outcomes, not safe pre-race features.\n- Raw extraction strings, source URLs, retrieval timestamps, content hashes and a profile-layout validation flag for audit and reparsing.\n\nColumn descriptions label fields as **PRE-RACE**, **POST-RACE**, **RETRIEVAL-TIME**, **PROVENANCE** or **QUALITY** where leakage risk matters. Targets and rolling ML features are deliberately left for downstream feature engineering.\n\n## Missing values\n\nAbsent source values remain null and are never inferred. Original racing statuses, currencies, raw strings, failed pages and unmatched profiles remain distinguishable.\n\n## Source and rights\n\nRacing results and profiles come from public Jockey Club Czech Republic pages. Weather observations come from Czech Hydrometeorological Institute open-data files; redistribution rights are not asserted, so the dataset remains private.","topics":["horse racing","jockey club czech republic","czech hydrometeorological institute","sports statistics","race results","meteorological data"],"publisher":{"handle":"mostlyrightmd","display_name":"Mostly Right","avatar_url":"https://mostlyright.md/api/public/avatars/e70f8c973d16894fcee5cb5aba887feafc75cc0d67419bd0ed321cfde9d0d967.webp","mark":{"background":"#FFC613","facets":["#2B5FE3","#F15B22","#17160F"],"pattern":2,"rotation":90}},"star_count":0,"table_count":1,"row_count":138756,"published_at":"2026-09-20T18:46:20.514Z","updated_at":"2026-10-01T13:49:11.529Z","cover_image_url":"https://storage.googleapis.com/mostlyright-dataset-covers/v1/5a4d712d-02fb-49d1-bc84-16de7446cf75/febbb69240b85c09dc85ba0636f9001f025576eb95d5d6b1fc7bf53ee7b5f2ff.webp","cover_tile_url":"https://storage.googleapis.com/mostlyright-dataset-covers/v1/5a4d712d-02fb-49d1-bc84-16de7446cf75/febbb69240b85c09dc85ba0636f9001f025576eb95d5d6b1fc7bf53ee7b5f2ff.tile.webp","activity":{"views":517,"likes":0},"canonical_url":"https://mostlyright.md/datasets/czech-horse-racing-results-19972026","tables":[{"id":"5ebcc94b-d479-414e-88db-519f7ec6811a","slug":"horse-race-starts","title":"horse_race_starts","license":null,"schema":{"columns":83,"column_details":[{"name":"meeting_id","unit":null,"meaning":"The source meeting identifier.","nullable":null,"logical_type":"string"},{"name":"race_id","unit":null,"meaning":"The source race identifier.","nullable":null,"logical_type":"string"},{"name":"race_date","unit":null,"meaning":"The local date on which the race was run.","nullable":null,"logical_type":"date"},{"name":"venue","unit":null,"meaning":"The published Czech racecourse name.","nullable":null,"logical_type":"string"},{"name":"race_number","unit":null,"meaning":"The published race number within the meeting.","nullable":null,"logical_type":"integer"},{"name":"race_name","unit":null,"meaning":"The published race name.","nullable":null,"logical_type":"string"},{"name":"scheduled_start_time","unit":null,"meaning":"The published scheduled local start represented with the Europe/Prague UTC offset.","nullable":null,"logical_type":"timestamp_utc"},{"name":"actual_start_time","unit":null,"meaning":"The actual start timestamp when explicitly published.","nullable":null,"logical_type":"timestamp_utc"},{"name":"race_discipline","unit":null,"meaning":"The published flat or jump-racing discipline text.","nullable":null,"logical_type":"string"},{"name":"race_class","unit":null,"meaning":"The published race class or category.","nullable":null,"logical_type":"string"},{"name":"race_type","unit":null,"meaning":"The published race type.","nullable":null,"logical_type":"string"},{"name":"distance_m","unit":null,"meaning":"The published race distance in metres.","nullable":null,"logical_type":"decimal"},{"name":"age_restriction","unit":null,"meaning":"The published age eligibility restriction.","nullable":null,"logical_type":"string"},{"name":"prize_amount","unit":null,"meaning":"The advertised total prize in the original currency.","nullable":null,"logical_type":"decimal"},{"name":"prize_currency","unit":null,"meaning":"The original published prize currency.","nullable":null,"logical_type":"string"},{"name":"declared_starters","unit":null,"meaning":"The published starter count.","nullable":null,"logical_type":"integer"},{"name":"track_condition","unit":null,"meaning":"The published going description.","nullable":null,"logical_type":"string"},{"name":"track_condition_score","unit":null,"meaning":"The published numeric going measurement.","nullable":null,"logical_type":"decimal"},{"name":"winning_time_raw","unit":null,"meaning":"The published winning time text.","nullable":null,"logical_type":"string"},{"name":"race_conditions_raw","unit":null,"meaning":"The original published race conditions text.","nullable":null,"logical_type":"string"},{"name":"horse_id","unit":null,"meaning":"The source horse identifier.","nullable":null,"logical_type":"string"},{"name":"horse_name","unit":null,"meaning":"The published horse name.","nullable":null,"logical_type":"string"},{"name":"horse_country","unit":null,"meaning":"The published horse country suffix.","nullable":null,"logical_type":"string"},{"name":"saddle_number","unit":null,"meaning":"The published saddlecloth number.","nullable":null,"logical_type":"string"},{"name":"horse_age_on_race_day","unit":null,"meaning":"The horse age published for this entry.","nullable":null,"logical_type":"integer"},{"name":"horse_sex_on_race_day","unit":null,"meaning":"The horse sex published for this entry.","nullable":null,"logical_type":"string"},{"name":"carried_weight_kg","unit":null,"meaning":"The published carried weight in kilograms.","nullable":null,"logical_type":"decimal"},{"name":"equipment_raw","unit":null,"meaning":"The original published equipment codes.","nullable":null,"logical_type":"string"},{"name":"stable_on_race_day","unit":null,"meaning":"The stable published for the entry.","nullable":null,"logical_type":"string"},{"name":"jockey_id","unit":null,"meaning":"The source jockey identifier.","nullable":null,"logical_type":"string"},{"name":"jockey_name","unit":null,"meaning":"The published jockey name.","nullable":null,"logical_type":"string"},{"name":"trainer_id","unit":null,"meaning":"The source trainer identifier.","nullable":null,"logical_type":"string"},{"name":"trainer_name","unit":null,"meaning":"The published trainer name.","nullable":null,"logical_type":"string"},{"name":"finish_position","unit":null,"meaning":"The numeric finishing position; non-finishers remain null.","nullable":null,"logical_type":"integer"},{"name":"result_status_raw","unit":null,"meaning":"The original result text, including non-finisher statuses.","nullable":null,"logical_type":"string"},{"name":"finish_time_raw","unit":null,"meaning":"The published individual finish time text.","nullable":null,"logical_type":"string"},{"name":"margin_raw","unit":null,"meaning":"The published distance or margin text.","nullable":null,"logical_type":"string"},{"name":"earnings_amount","unit":null,"meaning":"The published entry earnings in the original currency.","nullable":null,"logical_type":"decimal"},{"name":"earnings_currency","unit":null,"meaning":"The original published earnings currency when stated.","nullable":null,"logical_type":"string"},{"name":"horse_date_of_birth","unit":null,"meaning":"The birth date published on the current horse profile.","nullable":null,"logical_type":"date"},{"name":"horse_color","unit":null,"meaning":"The coat colour published on the current horse profile.","nullable":null,"logical_type":"string"},{"name":"horse_sex_current","unit":null,"meaning":"The sex recorded when the profile was retrieved.","nullable":null,"logical_type":"string"},{"name":"sire_id","unit":null,"meaning":"The source identifier of the published sire.","nullable":null,"logical_type":"string"},{"name":"sire_name","unit":null,"meaning":"The published sire name.","nullable":null,"logical_type":"string"},{"name":"dam_id","unit":null,"meaning":"The source identifier of the published dam.","nullable":null,"logical_type":"string"},{"name":"dam_name","unit":null,"meaning":"The published dam name.","nullable":null,"logical_type":"string"},{"name":"damsire_id","unit":null,"meaning":"The source identifier of the published maternal grandsire.","nullable":null,"logical_type":"string"},{"name":"damsire_name","unit":null,"meaning":"The published maternal grandsire name.","nullable":null,"logical_type":"string"},{"name":"breeder","unit":null,"meaning":"The breeder published on the current profile.","nullable":null,"logical_type":"string"},{"name":"breed_classification","unit":null,"meaning":"The breed or classification published on the current profile.","nullable":null,"logical_type":"string"},{"name":"stable_current","unit":null,"meaning":"The stable recorded when the profile was retrieved.","nullable":null,"logical_type":"string"},{"name":"profile_retrieved_at","unit":null,"meaning":"The timezone-aware timestamp when the profile page was retrieved.","nullable":null,"logical_type":"timestamp_utc"},{"name":"weather_station_id","unit":null,"meaning":"The selected Czech Hydrometeorological Institute station identifier.","nullable":null,"logical_type":"string"},{"name":"weather_station_name","unit":null,"meaning":"The selected weather station name.","nullable":null,"logical_type":"string"},{"name":"weather_station_distance_km","unit":null,"meaning":"The great-circle distance from racecourse to selected station.","nullable":null,"logical_type":"decimal"},{"name":"weather_date","unit":null,"meaning":"The publisher-labelled observation date joined to the race date.","nullable":null,"logical_type":"date"},{"name":"precipitation_mm","unit":null,"meaning":"The published daily precipitation measurement.","nullable":null,"logical_type":"decimal"},{"name":"temperature_min_c","unit":null,"meaning":"The published daily minimum air temperature.","nullable":null,"logical_type":"decimal"},{"name":"temperature_max_c","unit":null,"meaning":"The published daily maximum air temperature.","nullable":null,"logical_type":"decimal"},{"name":"meeting_source_url","unit":null,"meaning":"The source meeting page URL.","nullable":null,"logical_type":"string"},{"name":"horse_profile_source_url","unit":null,"meaning":"The source horse profile URL.","nullable":null,"logical_type":"string"},{"name":"meeting_retrieved_at","unit":null,"meaning":"The timezone-aware timestamp when the meeting page was retrieved.","nullable":null,"logical_type":"timestamp_utc"},{"name":"meeting_content_hash","unit":null,"meaning":"The SHA-256 digest of the retrieved meeting page content.","nullable":null,"logical_type":"string"},{"name":"profile_content_hash","unit":null,"meaning":"The SHA-256 digest of the retrieved horse profile page content.","nullable":null,"logical_type":"string"},{"name":"card_number","unit":null,"meaning":"[PRE-RACE] Published race card number extracted from the race name.","nullable":null,"logical_type":"integer"},{"name":"equivalent_rating","unit":null,"meaning":"[POST-RACE] Published equivalent performance rating; exclude from pre-race features.","nullable":null,"logical_type":"integer"},{"name":"sectionals_csv","unit":null,"meaning":"[POST-RACE] Published intermediate times preserved as comma-separated raw text.","nullable":null,"logical_type":"string"},{"name":"race_margins_raw","unit":null,"meaning":"[POST-RACE] Published race-level margins/verdict text.","nullable":null,"logical_type":"string"},{"name":"course_code","unit":null,"meaning":"[PRE-RACE] Stable short code mapped from the published venue.","nullable":null,"logical_type":"string"},{"name":"horse_profile_name_raw","unit":null,"meaning":"[RETRIEVAL-TIME] Raw horse name text from the fetched profile.","nullable":null,"logical_type":"string"},{"name":"horse_text_raw","unit":null,"meaning":"[PRE-RACE] Raw horse cell text on the meeting result page.","nullable":null,"logical_type":"string"},{"name":"weight_raw","unit":null,"meaning":"[PRE-RACE] Raw carried-weight text before numeric parsing.","nullable":null,"logical_type":"string"},{"name":"earnings_raw","unit":null,"meaning":"[POST-RACE] Raw earnings tooltip text.","nullable":null,"logical_type":"string"},{"name":"race_header_raw","unit":null,"meaning":"[POST-RACE PAGE] Raw published race header text.","nullable":null,"logical_type":"string"},{"name":"race_spec_raw","unit":null,"meaning":"[PRE-RACE] Raw published race specification text.","nullable":null,"logical_type":"string"},{"name":"prize_raw","unit":null,"meaning":"[PRE-RACE] Raw advertised-prize text.","nullable":null,"logical_type":"string"},{"name":"track_condition_raw","unit":null,"meaning":"[POST-RACE] Raw published going text.","nullable":null,"logical_type":"string"},{"name":"result_raw","unit":null,"meaning":"[POST-RACE] Raw published result summary text.","nullable":null,"logical_type":"string"},{"name":"meeting_raw","unit":null,"meaning":"[PRE-RACE] Raw meeting date and venue text.","nullable":null,"logical_type":"string"},{"name":"horse_href","unit":null,"meaning":"[PROVENANCE] Raw horse profile link found on the meeting page.","nullable":null,"logical_type":"string"},{"name":"profile_dob_age_raw","unit":null,"meaning":"[RETRIEVAL-TIME] Raw profile date-of-birth and age text.","nullable":null,"logical_type":"string"},{"name":"profile_color_sex_raw","unit":null,"meaning":"[RETRIEVAL-TIME] Raw profile color and sex text.","nullable":null,"logical_type":"string"},{"name":"profile_layout_valid","unit":null,"meaning":"[QUALITY] 1 when all expected profile labels match the certified layout, otherwise 0.","nullable":null,"logical_type":"integer"}],"schema_version":"mostlyright.cloud.released-schema-summary.v1"},"preview_enabled":true,"download_enabled":true,"version_id":"079a5674-4e54-50d8-8578-5b5d011bcbab"}]}}