Ultrapedia

What Ultrapedia holds: the queryable views, every column and what it means, the allowed values of category columns, and how many races there are. Read this before writing SQL for `query`.

Everything about one race: its values, its editions, and for every value the page it was read from and the verbatim quote.

Send a value for one field of one race, read from a web page — a correction or a value the index is missing. `field` is a column name from `describe`; `value` is in that column's form and units (gain_m in metres, dates yyyy-mm-dd, start_time HH:MM 24h, price_usd a number). `quote` must be copied verbatim from `source_url` and must show the value. For date, start time, price, aid stations, drop bags and runners, `year` is the edition year. The server checks the quote on the page; the result says whether the value was applied, held for a maintainer, or rejected and why.

Send a US ultramarathon the index does not have yet. Check with search_races first. `quote` is copied verbatim from `source_url` and names the race. One call for each distance (a 50K and a 100M at the same event are two races).

Run one read-only SQL SELECT (SQLite) over the views `races`, `editions` and `sources`. Returns columns and rows; `truncated` is true when more rows exist than `limit` (max 500). Example: SELECT slug, name, date, city FROM races WHERE state='CO' AND distance_category='100M' AND date >= date('now') ORDER BY date

Read a public web page the way this server reads it when it checks a quote: its visible text and its links. Use it before `propose_correction` to copy an exact quote, or to read a race page your own tools cannot open. `find` returns only the passages around that text. A value that is a URL (website_url, registration_url) can be shown by a link: quote the sentence that holds it.

Report something a single value cannot fix: a cancelled or discontinued race, two rows for the same race, a race filed under the wrong distance. Include a source and quote when you have one.

Find races. `text` matches the name, city or start location; `state` is a two-letter code; `distance_category` is one of the values in `describe`; dates are yyyy-mm-dd and filter the current edition's date. Returns the main columns; use `get_race` for everything about one race.