Kinderkopje - /r/Peloton's Data Collection Project

Data

Database

All pages share one SQLite database, kept in this browser. Save it as a .sqlite file to keep a copy or pass it on; it opens in any SQLite tool.

Tables and fields

What is in the database. The two views (v_team_points, v_results) are the easy way in. Open a table to see its fields and what they mean; the buttons ask a first question of it below.
Download it: HTML page Markdown JSON

Public beta database

A SQLite file anyone can download and open in any SQLite tool: the rankings and the point-scoring results collected so far, with races (internal and external names), links, countries and continents. It holds names, nations, rider ages, places, points, team names, race names, race links and race facts: no layout, no photos. This is a beta: not every race is in it yet.
Looking for the published file ...
Download the beta database (.sqlite)
For whoever publishes the beta: it builds the file from the data in this browser, with its joins, names and links.

Ask the data (SQL, read only)

Write a SELECT, or use a button above or one of these. Nothing here can change the data.
Asking: my database

v0.1.0 (db55b20)