Queries
Browse community-built SQL queries on quality data.
Browse community-built SQL queries on quality data.
Author
Last Run
Last Update
Stars
Forks
Last night, Ronaldo scored the winning goal in Portugal's 2–1 victory over Germany in the UEFA Nations League semifinal — 25 years after the last Portuguese win against Germany. It wasn’t just poetic. It was statistically remarkable. Over the past decade, Ronaldo has scored in 54% of the matches he’s played. At age 40, that number rises to 65% — as this plot shows, he’s defying not just time, but every expectation.
The top 5 single-season goal-scoring performances across major soccer leagues (2016/17 to 2024/25)
The top 5 single-season goal-scoring performances across Premier League and Primeira Liga (2016/17 to 2024/25)
The top 5 single-season goal-scoring performances across Premier League and Primeira Liga (2016/17 to 2024/25)
Let's see how the costs of fighting wildfires in the US has changed over time and normalize it for inflation to see if there has been a substantive change.
In 2019, ambient air pollution claimed the lives of young children at alarming rates in several countries. Here's the top 10 list of countries with the highest number of deaths per 100,000 children under 5 due to ambient air pollution.
This bubble chart highlights the five most actively traded open prediction markets on Polymarket (based on total volume). Each bubble represents a market, with: - Y-axis showing the market question - X-axis representing the last traded price (probability) - Bubble size proportional to trading volume.
Looking at RLUSD and other stablecoins issued on the XRPL.
Last night, Ronaldo scored the winning goal in Portugal's 2–1 victory over Germany in the UEFA Nations League semifinal — 25 years after the last Portuguese win against Germany. It wasn’t just poetic. It was statistically remarkable. Over the past decade, Ronaldo has scored in 54% of the matches he’s played. At age 40, that number rises to 65% — as this plot shows, he’s defying not just time, but every expectation.
We asked Baselight (literally) what exciting insights it could produce on the FIFA Club World Cup — and here’s what it found.
In 2004, Portugal filed just 5 patents per million people to the European Patent Office. By 2024, that number had risen to 33 — a 6.6× increase in 20 years.
Messi still delivers magic - even at 37. Yesterday, Lionel Messi sealed Inter Miami’s win over FC Porto with a breathtaking free kick in the FIFA Club World Cup. A moment of brilliance that reminds us just how dangerous he remains in his late 30s. It’s also a perfect moment to revisit a comparison I had started a few weeks ago - Cristiano Ronaldo’s scoring consistency after turning 30. This time, I’ve added Messi to the mix.
The Most One-Sided Match in the FIFA Club World Cup 2025? According to pre-match odds from dozens of bookmakers indexed by Baselight, FC Bayern München vs. Auckland City FC (June 15) is shaping up to be the most lopsided matchup of the tournament: - FC Bayern München win: 97.1% implied probability - Draw: 2.0% - Auckland City FC win: 0.8% — a true miracle scenario
Number of goals scored by Cristiano Ronaldo per 90 minutes of gameplay since turning 30 years-old. This includes all official club level matches, and the final stages of international competitions with Portugal. Importantly, these results do not include Euro and World Cup qualifying stages.
Tip as a percentage of total bill amount, by meal time.
Anyone who has the link will be able to view this.