Power BI Developer · Tableau Developer · Excel & Access Expert · AI Solutions · Data Analyst · Running Data Storyteller · Accountant
I build interactive dashboards, running race analysis tools, and financial reporting solutions that turn complex data into clear insights and better decisions. Over 20 years of government and private sector accounting experience. Master of Science in Accounting and Data Analytics (STEM), University of New Haven, GPA 3.95.
Adjust the numbers below to see how cleaner reporting, automation, and dashboards can turn everyday accounting work into measurable time savings and better decision making.
Live mini dashboard
Accounting Impact Calculator
Choose a sample project, move the sliders, and watch the estimated savings update instantly.
Reconciliation cleanup
63
Hours saved monthly
$3.4K
Monthly value
$41K
Annual impact
Cost vs. SavingsUpdates live
What this means
Even small improvements in a recurring accounting process can free up meaningful time every month for review, analysis, and better decision making.
This is a simple estimate for demonstration purposes. Actual savings depend on data quality, workflow design, review steps, and reporting requirements.
What I Do
I combine accounting experience, data analytics, and dashboard design to create reports, tools, and AI-powered applications that are useful, clear, and easy to understand.
Power BI Dashboards
Interactive dashboards for financial, operational, and public data.
Tableau Visualizations
Clean visual stories for trends, performance, and insights.
Excel & Access Solutions
Automated reports, tracking systems, databases, and forms.
Financial Reporting
Accounting reports, grant tracking, spending analysis, and more.
Data Analysis
Race trends, maps, participation data, and runner insights.
Public Data Storytelling
Simple, professional visuals that make data easier to understand.
AI-Powered Solutions
Practical AI workflows using ChatGPT, Claude, structured prompts, API integrations, and automated reporting tools to save time and improve decisions.
App Development
Interactive web apps built with React and JavaScript — public-facing tools, calculators, and custom utilities.
Process Automation
Scripted pipelines and automated workflows that eliminate repetitive tasks and keep your data current.
Best For
I help people and organizations turn public data, financial data, race data, and internal records into clear tools, dashboards, and reports.
Small Businesses
Dashboards, reports, and tracking tools that make sales, expenses, operations, and performance easier to review.
Nonprofit Organizations
Public data dashboards, grant reporting support, impact reporting, and visuals that help tell a clear story.
Race Directors
Race result analysis, participation trends, runner maps, historical comparisons, and public facing race data tools.
Public Agencies
Financial reporting, operational tracking, spending analysis, and dashboards designed for transparency and decision making.
Professionals
Excel, Access, Power BI, and automation support for people who need better systems but do not have time to build them.
Community Projects
Data storytelling for public interest projects where clear visuals can help people understand the issue faster.
Featured Work
Dashboard and data analysis projects combining public data, financial reporting, running data analytics, and community storytelling.
Run 169 Towns Member Dashboard
Power BI dashboard used by nearly 6,000 members to track progress across all 169 Connecticut towns. Automated, interactive, real-time.
View Project →
Hartford Half Marathon: 30 Years of Data
30 years of race data analysis with participant trends, finish times, demographics, and interactive visual storytelling.
View Project →
Why Work With Me
I combine accounting experience, data analysis, dashboard design, and real world reporting experience. I do not just build charts. I help organize the data, explain the numbers, and create tools people can actually use.
Project Options
Projects can be hourly, fixed price, or volunteer based for selected nonprofit and public interest projects.
Accounting background that helps connect the numbers to real business questions.
Dashboard design focused on clarity, usability, and practical decision making.
Experience with public data, financial reporting, running race analysis, and automation.
AI powered workflows that reduce repetitive work and keep reporting easier to maintain.
Client Feedback
What Run 169 Towns Society members say about the website, database, and Power BI dashboards I built for the group.
“
Adam has done an outstanding job with the Run 169 Towns Society website, calendar tools, and tracking dashboard. The website is clean, user friendly, and well organized, making it easy for runners to navigate and find information. The dashboard functionality has greatly improved how we manage and track data throughout our Run 169 journey. He also consistently identifies opportunities for new features and enhancements.
What truly sets Adam apart is his in depth analytical approach to projects. He quickly understands complex requirements, identifies opportunities for improvement, and translates data and user feedback into practical, effective solutions. His analytical skills have played a key role in building systems that are both highly functional and scalable.
I highly recommend Adam for dashboards, data analysis, and automation projects.
CL
Carolina L.
Run 169 Towns Society
“
I’ve used the dashboard and database that Adam Osmond built for the Run 169 Society. The membership database, race listings & calendar, and dashboard were helpful in tracking my races, towns run, and for registering for races. All the modules were integrated in an extremely intuitive interface, which I (along with others in the group) found extremely useful.
CC
Christopher C.
Norwalk, CT · Run 169 Towns Member
“
Embarking on the journey to complete a race in all 169 towns in Connecticut was a daunting task, but the website and database Adam built for the Run 169 Towns Society made it possible. Finding races, planning the towns, and tracking progress were all easy, so I only had to worry about completing the races!
KF
Kathy F.
Run 169 Towns Member
“
I have been using the Run 169 database and dashboard that Adam Osmond created, for the past few years. I have found it to be invaluable in planning and tracking my progress toward the goal of running a race in every town in CT. The database is comprehensive and easy to use. I have no need to use any other resource, as it is truly a one stop shop. Every time you think the site can’t get any better, Adam introduces an additional feature or improvement.
KF
Christopher R.
Run 169 Towns Member
“
The Run 169 Towns website and Power BI dashboard that Adam built for the group are my go-to resources for my running journey. I use them not only for the basics, such as finding upcoming races and submitting my runs, but also as a way to connect with other members by viewing their hometowns, achievements, and progress. Adam is continuously improving the website with engaging features, useful analytics, and tools that help members stay connected and motivated. I use the Member Dashboard to prioritize my races, track progress, and see who has submitted the most new towns and which members are approaching key milestones. The website and dashboard have made the Run 169 experience easier, more organized, and more enjoyable.
MM
Maureen M.
Run 169 Towns Member
“
The Run 169 Towns Society dashboard is an exceptionally innovative and comprehensive platform that provides runners with a highly detailed and interactive way to monitor their progress across all 169 towns in Connecticut. Its features, including personalized progress tracking, town completion data, rankings, milestone statistics, and community-wide participation metrics, create an engaging and user-friendly experience for participants at every stage of the challenge. The dashboard organizes a significant amount of running data into an accessible and visually effective format that allows users to easily analyze accomplishments, identify remaining goals, and follow statewide participation trends. By combining functionality, precision, and community connection, the platform serves as both an advanced tracking tool and a motivating resource that strengthens engagement within Connecticut’s running community.
KB
Katey B.
Run 169 Towns Member
“
As a decidedly non-techie 64 year old, this runner finds the Run 169 website and dashboard intuitive and user friendly. I can find what I need easily, log what I have to quickly, and peruse organized races in any manner I choose. Adam responds to questions promptly; he also takes suggestions and implements them. Adam’s attention to detail means I get more time to RUN!!
DJ
Doree J.
Run 169 Towns Member
About Adam
Accountant, data analyst, dashboard developer, and running data storyteller with over 20 years of government and private sector experience.
Master of Science in Accounting and Data Analytics (STEM) from the University of New Haven, GPA 3.95.
AccountingFinancial ReportingData VisualizationPublic Data Analysis
Need a dashboard, report, or data tool? Let's talk.
I can help organize your data, explain the numbers, and build dashboards, reports, automation tools, and AI powered workflows that people can actually use.
A collection of race reports and data analysis. Some of these are races I ran, some I paced or filmed, and others are races I found interesting enough to dig into the data. Every post includes analysis.
World Marathon Majors 1897–2026 · Global Marathon Circuit
A historical and statistical look at Boston, New York City, Chicago, Berlin, London, Tokyo, and Sydney, including winners, course records, winning times, country dominance, and the rise of the East African era.
Years 1996–2025Total Finishers 91,545Peak Year 2013
A full historical breakdown of 30 years of Hartford Half Marathon data — participation growth and decline, gender trends, median finish times by year, age group distributions, and all-time records.
Every year someone complains that charity runners are taking spots from qualifiers. So I pulled the BAA's tax filings and actually looked at the numbers. What I found changes the conversation entirely.
Full breakdown of both races — finish time distributions, gender and age group analysis including non-binary finishers, top finishers by net time, and year-over-year growth from 2025 to 2026.
I paced the 11:00/mile group with Beast Pacing and filmed the entire race with my GoPro. A full breakdown of 2,432 finishers and 15 years of race history showing Baltimore's running community on the rise.
Editions 24Total Finishers 5,193Peak Year 2015 (439)Women Majority Since 2013
25 years of data from one of Connecticut's favorite half marathons along the Farmington River. Participation trends, gender shifts, median finish times, age group analysis, a full winners table, and a Power BI dashboard where runners can look up all of their results in one place. I have raced, paced, coordinated pacers, or volunteered every year since 2015.
Years 2001 to 20252025 Total 2,494West Central All Time HighState Agency Complaints All Time Low
A 25 year analysis of complaint filings, regional trends, case types, closure outcomes, and what changed most dramatically in FY 2025, including a 55% decrease in complaints against state agencies and an all time high in the West Central region.
From the windswept New England roads of 1897 to the harborside debut of Sydney in 2025: a 129-year statistical portrait of the marathon's most prestigious circuit. Who wins, how fast, and from where.
Adam OsmondAdamOsmond.comSource · World Athletics Records
7
World Majors
622
Champions Crowned
45
Winning Nations
354
Unique Athletes
129
Years of Data
The Circuit
Seven races, one global benchmark of the long road.
The Abbott World Marathon Majors is the closest thing distance running has to a Grand Slam. Six races defined the circuit for two decades. In 2025, Sydney became the seventh, the first new major in twelve years (since Tokyo joined in 2013) and the first ever held in the Southern Hemisphere.
This analysis covers every champion across all seven majors: 622 winners, men and women, from the very first Boston race in 1897 through the most recent results of the 2026 season. Where the numbers go is its own story. The marathon has gone from American local-club hero to a Kenyan and Ethiopian duopoly, with winning times that have compressed by nearly an hour for men and by close to forty minutes for women.
Boston
Inaugural · 1897 · 129 editions
190Champions
133Unique Winners
24Nations
2026Most Recent
New York City
Inaugural · 1970 · 54 editions
106Champions
73Unique Winners
21Nations
2025Most Recent
Berlin
Inaugural · 1974 · 50 editions
100Champions
75Unique Winners
20Nations
2025Most Recent
Chicago
Inaugural · 1977 · 47 editions
94Champions
74Unique Winners
17Nations
2025Most Recent
London
Inaugural · 1981 · 46 editions
92Champions
64Unique Winners
18Nations
2026Most Recent
Tokyo
Inaugural · 2007 · 19 editions
38Champions
32Unique Winners
7Nations
2026Most Recent
Sydney
Inaugural · 2025 · 1 editions
2Champions
2Unique Winners
2Nations
2025Most Recent
Winning Times
A century-and-a-third of getting faster.
Marathon winning times have collapsed. In 1897, John McDermott crossed the Boston finish line in 2:55:10. In 2026, John Korir won the same race in 2:01:52, fifty-three minutes faster on essentially the same hills. The women's progression is steeper still. Women were not formally allowed in Boston until 1972, and have since shaved more than forty minutes off their winning times, from above 3:00 in the early 1970s to under 2:10 in the 2020s.
Men's winning times
All seven majors · 1897 to 2026
Women's winning times
All seven majors · 1970 to 2026
"The men's average winning time has dropped from over 2:30 in the 1970s to under 2:05 in the 2020s, and the women's average has fallen by nearly an hour over the same span."
Decade Averages
The shape of the slowdown, and the surge.
Plotting the average winning time of every major champion by decade reveals a sport in two distinct eras: a long, steady improvement from the 1970s through the 1990s, then a step-change after 2000 driven by East African dominance, super-shoe technology, and unprecedented depth.
Average winning time per decade
All seven majors · Men vs Women
East African Era
When the African runners arrived, and never left.
For the first eighty-three years of major marathon history, no African runner ever stood on the top step. From 1897 through 1982, every single major win went to a runner from North America, Europe, Japan, or Australia. The wall did not crumble all at once. It came down in stages, and once it fell, it stayed down.
The breakthrough came on October 16, 1983, when Kenya's Joseph Nzau won the Chicago Marathon in 2:09:44, becoming the first African to win any of the seven majors. Four years later, Ibrahim Hussein took New York City for Kenya in 1987 and then Boston in 1988, and the door was open for good.
For women, the African era arrived almost a decade later. Tegla Loroupe won New York City in 1994 for Kenya, and Fatuma Roba took Boston in 1997 for Ethiopia. By the year 2000, both genders were squarely in the East African era.
1983
First African Major Win
9%
African Wins · 1980s
34%
African Wins · 1990s
62%
African Wins · 2000s
92%
African Wins · 2010s
Share of major winners from African nations, by decade
Kenya · Ethiopia · all other African nations · rest of the world
"From 1897 to 1982, the African share of major marathon wins was exactly zero. By the 2010s it was 92 percent. There has never been a faster takeover in distance running history."
First African winner at each major
The order in which the African wave reached each of the seven majors is itself a small map of the sport's evolution: Chicago was first to be broken, in 1983; the British and American originals followed in the late 1980s; Tokyo and Sydney came last, simply because they came later.
Race
Sex
First African Winner
Country
Time
Year
Fastest and Slowest Courses
Some courses are built for speed. Others fight you back.
Each major marathon has a personality written into its asphalt: the flat boulevards of Berlin, the rolling hills of Boston, the five bridges of New York. When you average every winning time at each course across decades, those personalities emerge clearly. Some courses have produced fast champions year after year. Others, by design or by terrain, have always sent the winners home slower.
The two charts below plot the average winning time at each major, decade by decade. A line that sits low on the chart means the course has consistently produced fast winners. A line that sits higher means the course has been slower over the same era. Same scale, same colors as the rest of this analysis.
Average men's winning time per decade, by race
One line per major · 1970s to 2020s
Average women's winning time per decade, by race
One line per major · 1970s to 2020s
The fastest course: Berlin (men) and London (women)
Berlin is the runaway fastest course in the men's circuit. Run on flat asphalt through a city laid out in straight, wide boulevards, and held in late September weather that is reliably cool, it has been the chosen venue for nearly every men's world record since the 2000s. Across the 2010s and 2020s combined, the average Berlin men's winner has finished in 2:03:13, faster than any other major. London sits less than a minute behind at 2:03:58, owing to its own flat course, deep prize money, and pacemaking culture.
On the women's side, London takes the title of fastest course at 2:18:55 on average across 2010 to 2026, with Chicago essentially tied at 2:19:00. London's mix of flat terrain, aggressive female elite recruitment, and Paula Radcliffe's long-standing course record set a tradition of fast women's racing that the modern Kenyan and Ethiopian generations have continued.
The slowest course: Boston (both) and New York City (close behind)
The slowest of the modern majors are Boston and New York City, and the reasons are baked into the courses themselves. Boston's point-to-point route includes the four Newton Hills, ending with Heartbreak Hill at mile twenty-one, exactly where elite legs are starting to fail. New York City crosses five bridges, including the steep climb up the Verrazzano at the start and the punishing ascent of the Queensboro at mile sixteen, before finishing on the rolling paths of Central Park.
In the 2010s and 2020s the average men's Boston winner ran 2:08:13, more than five minutes slower than the average Berlin winner. New York City came in at 2:08:18. The women's picture is similar: Boston 2:24:14, New York City 2:24:20, both about five minutes slower than London or Chicago in the same era.
The modern era ranking
The full ranking from fastest to slowest, using the average winning time at each major from 2010 to 2026:
Men
Women
Tokyo and Sydney are partial-data outliers worth noting. Tokyo joined the majors in 2013, so its modern-era sample is smaller. Sydney has run only once at the major level (August 2025), so it cannot be ranked yet. Tokyo's recent average winning times put it in the upper half of the speed table, suggesting a fast course; whether Sydney joins that group will become clear over the next several years.
Course Records
The fourteen fastest times in major history.
Every course holds its own record. Five of the seven men's marks have been set in the 2020s. The women's records cluster even tighter into the present: six of the seven were set in 2023 or later, including Ruth Chepngetich's 2024 Chicago time of 2:09:56, the women's world record.
Race
Sex
Time
Athlete
Country
Year
Nations on the Podium
Where the winners come from.
Of the 45 countries that have produced a major champion, just two, Kenya and Ethiopia, now win more than two-thirds of all major marathon titles. A century ago, the United States and Canada owned Boston outright. The geographic axis has shifted decisively east.
Country × Race
Each major has its own national fingerprint.
Boston's American heritage still shows in the all-time totals. Berlin has been the world-record course favored by East Africans. Tokyo has the highest share of Japanese winners of any major. The breakdown:
Top winning nations by race
Stacked count of champions · all-time
Greatest Champions
The marathoners who collected the most majors.
Two athletes are tied at the top, separated by forty years and a continent. Norway's Grete Waitz dominated New York City in the 1970s and 1980s and added London titles. Kenya's Eliud Kipchoge has won across four different majors and remains the only athlete to break two hours over the distance, in an unofficial exhibition.
Most major wins · all-time
Top 15 athletes
Won at three or more different majors
A separate measure of greatness is range: winning on multiple courses, with their different climates, hills, and competitive fields. These 20 athletes have done it on at least three different majors.
Athlete
Sex
Country
Different Majors
Total Wins
In Closing
From McDermott to Korir, in 129 years.
Boston's first winner, John McDermott, was a piano-mover from New York who finished the 1897 race in shoes that would today be classified as work boots. He ran a 2:55. In 2026, on a similar course, John Korir of Kenya ran 2:01:52, fast enough to win every Olympic marathon ever held.
That gap of fifty-three minutes is more than just better training and better shoes. It is a complete reorganization of who runs the marathon, where, and why. The seven World Marathon Majors are the public ledger of that change. Each finish line is a tiny correction to the record of human endurance.
Sydney's first major in 2025 added a new chapter. The next decade will write the rest.
Data analysis and visualization by Adam Osmond. Source noted in the analysis: World Athletics records and compiled major marathon winner data.
True Cost per Runner vs. What Runners Actually Pay
The $877 gap between what runners pay ($260) and the true cost ($1,137) is bridged by sponsors, charity programs, and volunteer labor.
Where the Money Comes From
Estimated breakdown of Boston Marathon revenue sources
Charity Raised vs. Race Operating Cost
2024 charity fundraising more than doubles the BAA's entire operating budget
Every year like clockwork, someone complains that charity runners are taking spots away from qualified runners. So I decided to actually look at the numbers instead of just having an opinion about it.
I pulled the Boston Athletic Association's most recently available public tax filing for 2023. Here is what I found.
The Math Nobody Is Talking About
The BAA spent $34,116,665 to put on the race in 2023. With 30,000 runners, if you removed every sponsor and every organization that receives funds from charity runners and then turns around and supplies volunteers to make the race happen, each runner would need to pay roughly $1,137 just to cover operating costs. Most runners currently pay around $260. That gap does not close by magic.
But here is where it gets even more interesting. That $1,137 figure assumes all 9,000 to 10,000 volunteers continue working for free. If you paid each volunteer just 10 hours at minimum wage, that adds another $1,425,000 to the bill, pushing the true cost per runner to over $1,185. And that is using the most conservative numbers possible. Many volunteer roles would cost far more than minimum wage in the real world.
The Part That Gets Overlooked
The money charity runners raise goes directly to charitable organizations, not to offset your registration fee. But many of those same organizations are the ones supplying the volunteers who make race day function. On top of that, many people volunteer specifically because they know the race supports causes they care deeply about. Remove charity from the equation and you do not just lose fundraising. You risk losing a big chunk of the volunteer workforce that keeps the whole operation running.
The Airline Analogy
The charity runner does not take a spot from a qualifier in any meaningful economic sense. Think of it this way. Complaining about charity runners taking your spot is like demanding airlines remove first class. Removing first class does not create more seats for economy passengers. It just makes every remaining seat more expensive. The same applies here. Remove charity runners and you do not gain more spots. You just get a much higher registration bill.
On the contrary, the charity program provides the financial and operational floor that allows the qualified runner's spot to exist at an affordable price. The $71.9 million raised by charity runners in 2024 alone is the ultimate proof of the marathon's value to the region, ensuring that the world's most prestigious race remains viable, sustainable, and inclusive for decades to come. The interdependence of the qualifier, the charity runner, the sponsor, and the volunteer is not just a feature of the Boston Marathon. It is the very foundation of its existence.
The Bottom Line
For the small but loud group of people who complain about charity runners, let's be honest about what they are actually saying. They want their race registration subsidized by sponsors and volunteers, but they also want to eliminate the $71.9 million that charity runners raise for good causes across the region. You simply cannot have it both ways.
So before criticizing a charity runner who spent months training and raising thousands of dollars for a worthy cause, remember this. They are not taking your spot. They are part of the reason the spot is affordable in the first place, and the organizations they support are out there on the course making sure you cross that finish line safely.
The entire ecosystem depends on all of it working together.
Data source: BAA 2023 Form 990 (public tax filing). Charity fundraising figure from BAA 2024 race report. Analysis by Adam Osmond.
The Hartford Half Marathon has been a Connecticut running institution since 1996. With nearly 30 years of results data covering 91,545 finishers across 29 races, there's a rich story to tell — from the race's explosive growth through the early 2010s, to the gender shift that transformed the field, to what median finish times reveal about who is running and how the sport has evolved.
91,545
Total Finishers
29
Races (1996–2025)
6,585
Peak Field (2013)
54%
Female Finishers (all-time)
2:11:14
All-Time Median (F)
1:56:44
All-Time Median (M)
Total Finishers Per Year (1996–2025)
The race grew steadily from 460 finishers in 1996 to a peak of 6,585 in 2013, then declined. No race was held in 2020 (COVID). The field has been recovering since 2021.
Male vs. Female Finishers by Year
In 1996, only 16.5% of finishers were women. By 2013 that had risen to nearly 60%. The field has leveled out to roughly 52% female in recent years.
Median Finish Time by Year — Men vs. Women
Finish times in minutes. Both genders show a gradual slowdown over time, likely reflecting the field becoming broader and more recreational as the race grew. Men median ~116 min, women ~131 min in recent years.
All-Time Finishers by Age Group
The 30–39 age group accounts for the most finishers overall, followed closely by 40–49. The race draws a broad adult demographic with strong representation from 20–59.
All-Time Top 3 Men
Fastest male finishers in race history
Rank
Name
Year
Age
Time
1
Timothy Ritchie
2017
30
1:02:41
2
Ako Benedict
1999
23
1:03:37
3
Thomas Omwenga
2002
22
1:04:02
All-Time Top 3 Women
Fastest female finishers in race history
Rank
Name
Year
Age
Time
1
Kimberly Smith
2011
29
1:11:17
2
Kim Smith
2010
28
1:11:32
3
Anna Oeser
2025
26
1:12:09
The Story Behind the Numbers
The Hartford Half Marathon has been running since 1996, and nearly 30 years of race data tells a fascinating story about how the event grew, shifted, and evolved.
When the race launched in 1996, just 460 runners crossed the finish line, and the field was 83.5% male. That changed almost overnight. By 1997, the field more than doubled to 968 finishers, and the gap had already narrowed to 62% male, 38% female. The growth never really stopped from there.
Then came 2004, a turning point. For the first time in race history, women became the majority, making up 50.9% of the 1,839 finishers. It was a milestone that stuck. Women never gave that majority back, and over the next decade they kept building on it, peaking at 59.5% of the field in 2013.
That 2013 race holds a special place in Hartford Half history. It was the all-time record year with 6,585 finishers, and that number carries special meaning. The Boston Marathon bombing happened in April 2013, and the running community responded the way runners always do, by showing up. Hartford that fall saw a record-breaking turnout as runners across Connecticut and beyond used the race as a way to stand in solidarity with Boston and affirm that they would not be scared away from the roads. Women outnumbered men by over 1,200 finishers that year (3,915 to 2,670), the widest gap in race history.
The years after 2013 saw a gradual decline in overall participation, a pattern common to many road races nationally as the post-2010s running boom cooled. But something compelling has been happening in the last three years. The gap between male and female finishers has been closing steadily and noticeably. In 2023, it was 51.3% female to 48.6% male. In 2024, it tightened further to 50.7% female and 49.1% male, the closest the race had been to even since the early 2000s. And in 2025, it was 51.7% female to 48.1% male, with overall participation climbing to 3,774 finishers. After two decades of a wide and consistent female majority, the race is trending back toward parity, and the momentum is real.
And for the first time, starting in 2023, non-binary runners began appearing in the official results. There were 3 non-binary finishers in 2023, 5 in 2024, and 8 in 2025. Small numbers, but a meaningful step forward in how the race recognizes and welcomes all participants.
Key Year Snapshots
Year
Finishers
Female %
Note
1996
460
16.5%
First year
2004
1,839
50.9%
Women become majority for first time
2013
6,585
59.5%
All-time record, #BostonStrong
2023
3,405
51.3%
First year with non-binary category
2024
3,599
50.7%
Gap continuing to close
2025
3,774
51.7%
8 non-binary finishers
A Personal Connection
This race has special meaning to me. The Hartford Half was my first half marathon in 2011, and the following year I ran the full marathon, which was also my first marathon. I have been watching this race's data for a long time, and the story it tells keeps getting more interesting.
Back in 2019, I did a deep dive into half marathon participation data across Connecticut and found something striking. Every single half marathon in the state had peaked between 2012 and 2014, and all of them were on a steady decline heading into 2019, with some even folding entirely. At the same time, big city races like the Brooklyn Half were seeing massive growth, suggesting runners were not disappearing but migrating toward marquee events.
Fast forward to 2026, and the Hartford Half has grown every single year since returning from COVID in 2021, reaching 3,774 finishers in 2025, a 55% rebound from the post-COVID low. The data suggests the days of chasing 2013 numbers may be behind us, but the Hartford Half is clearly healthy, stable, and growing again.
Finish Time Trends
Median finish times tell another story. Both genders show a gradual slowdown over the decades, consistent with the field becoming more recreational and diverse. The fastest men ran sub-1:03 in the late 1990s and 2000s, and those course records still stand. On the women's side, Kimberly Smith's back-to-back 1:11 performances in 2010 and 2011 remain the standard.
A selection of data analytics, Power BI, and dashboard projects. Available for freelance work in Power BI, data analysis, and dashboard development. Connect on LinkedIn.
Run 169 Towns Society — Member Dashboard
Power BI · Data Automation · Interactive Maps · 6,000 Members · Live Production System
Power BIDAXPower QuerySQLInteractive MapsAutomated RefreshMember Portal
The Run 169 Towns Society is a Connecticut running community of nearly 6,000 members working to complete an official race in every one of Connecticut's 169 towns. As co-founder and Technology Lead, I designed and built the entire data infrastructure from scratch — replacing a fully manual process with a live, interactive Power BI dashboard that serves the entire membership.
Before this system existed, volunteers manually tracked which towns each member had completed, members had to search multiple websites to find upcoming races for the towns they still needed, and there was no central leaderboard or achievement tracking. I identified all of these friction points and built a single integrated system to solve them.
The Problem
Member race tracking was done manually by volunteers — slow, error-prone, and unscalable at 6,000 members
Members had no central place to see their own progress across all 169 towns
No leaderboard, no achievement tracking, no visibility into community-wide progress
Royalty tracking (members who finished all 169 towns) had no automated system
The Solution
I built a fully automated, multi-page Power BI dashboard that refreshes automatically when members submit races. Each member gets a personalized view of their own progress including an interactive map showing completed and remaining towns by year, a county-level completion breakdown, and a race history table. The system connects race submissions directly to member profiles with no manual intervention required.
Main Page
5,919 members, 99,927 towns submitted, hometown distribution map, member directory search, real-time royalty ticker.
My Towns
Personalized member view with interactive CT map showing completed towns by year, completion progress donut, county breakdown, and race history chart.
My Upcoming Races
Members select their name and instantly see all upcoming races in towns they still need — eliminating hours of manual searching across multiple websites.
2026 Leaderboard
Real-time leaderboard showing current-year town submissions and total miles by member, with county completion percentages and number-of-races-per-town map.
Royalty Page
Tracks all members who have completed all 169 towns, sorted by finish order, with title designations (Queen, King, Majesty), dates, and multi-round tracking.
Upcoming Races Listing
Connecticut-wide race calendar integrated into the dashboard, filterable by town, date, and distance — the most comprehensive CT race calendar available.
Dashboard Screenshots
Five pages from the live dashboard used daily by the Run 169 Towns Society membership.
Impact
Eliminated manual volunteer tracking for nearly 6,000 active members
Members can now see their personalized progress map in seconds instead of waiting for manual updates
Upcoming race matching saves members hours of searching across multiple external websites
Real-time leaderboard and royalty tracking created new engagement and accountability in the community
Dashboard refreshes automatically on race submission — zero manual intervention required
Nearly 100,000 town submissions tracked and visualized across all members and years
Power BI · Google Sheets · Real-Time Automation · Live Event Tracking · 169 Towns · 5 Years Running
Power BIGoogle SheetsDAXPower QueryReal-Time AutomationInteractive MapsLive Event Tracking
Run 169 Day is the annual anniversary event of the Run 169 Towns Society, held every March 5th. The goal is for every one of Connecticut's 169 towns to have at least one runner cover a minimum of 1.69 miles on that single day. I created this event in 2022 to celebrate the Society's 10th anniversary and March 5, 2026 marked the 5th consecutive successful Run 169 Day.
In the first year, eight volunteers each monitored one of Connecticut's eight counties all day long, manually tracking whether every town had been covered. Starting in year two, I replaced that entire process with a fully automated two-report Power BI system connected to Google Sheets — and we have never needed volunteers tracking towns again.
The Two-Dashboard System
Registration Dashboard
Opens two months before March 5th. Members register for the town they plan to cover. Updates automatically so members can see which towns still need a runner and recruit friends to sign up.
Race Day Dashboard
Published on March 5th. As members complete their runs, the Connecticut map fills in automatically. Members watch the map turn blue town by town until all 169 are covered.
County Progress Charts
Bar charts show completion percentage by county in real time, creating friendly competition between regions and helping identify areas that still need coverage.
Full Automation
Both dashboards connect to Google Sheets and refresh automatically. No manual updates, no volunteer monitoring. The system runs itself from registration through race day completion.
Dashboard Screenshots
Top: Registration dashboard showing 252 runners registered across all 169 towns. Bottom: Race day dashboard with all 169 towns completed, 310 total runs, and 100% county completion across all eight counties.
Replaced a full day of manual volunteer monitoring across 8 counties with a fully automated system
Registration dashboard allows the community to self-organize and recruit runners for uncovered towns
Real-time race day map creates a shared live experience for nearly 6,000 members watching from across the state
Members have traveled back to Connecticut from out of state specifically to participate on race day
Some members have covered an entire county in a single day, running more than ten towns
Zero volunteer overhead required after the first year — fully self-sustaining automated system
Power BI · Public Interest · Civil Rights Data · 25 Years · Searchable Case Decisions
Power BIDAXPower QueryPublic DataCivil RightsCase SearchGovernment DataPDF Consolidation
The Connecticut Commission on Human Rights and Opportunities (CHRO) publishes its complaint and public hearing data annually, but only as separate PDF files, one per year, with no way to search across years, filter by case name, or compare trends over time. Anyone who wanted to research a case, track a respondent, or study complaint patterns had to manually open dozens of documents.
I identified this gap and built a free, publicly accessible Power BI dashboard that consolidates 25 years of CHRO data into one place, covering complaint filings by region and type from FY 2001 through FY 2025, plus a fully searchable table of public hearing decisions going back to 1999.
The Problem
CHRO complaint and decision data existed only in individual PDFs published year by year, with no searchable archive
Researchers, attorneys, journalists, and the public had no way to find cases by name, respondent, referee, or decision type without opening dozens of separate files
No historical trend visualization existed for complaint volumes, regional breakdowns, or case outcomes over time
Public hearing decisions dating back to 1999 were effectively inaccessible without knowing the exact year to search
The Solution
I consolidated and structured 25 years of publicly available CHRO data into a multi page interactive dashboard. Every number came from official CHRO publications. The work was in extracting, cleaning, and connecting it into a unified, usable format. The result is the only public tool that lets anyone search, filter, and explore the full history of CHRO complaints and hearing decisions in one place.
Complaints Overview (FY 2001 to 2025)
Stacked bar chart showing annual filings broken out by all five CHRO regions, plus a separate chart tracking complaints filed against state agencies, where 2025 produced an all time low of 87.
Type of Complaints
Year by year breakdown of filings by case type: Employment, Housing, Public Accommodations, Credit, and Other, with filters to isolate trends by category across the full 25 year span.
Decision Summary
Complete matrix of public hearing decisions by type (final decisions, motions to dismiss, damages hearings, and more) split by Discrimination and Whistleblower cases, with referee level volume breakdown and year filter.
Searchable Case Table
A fully filterable table of hundreds of public hearing decisions, searchable by case name, respondent, referee, decision year, decision type, and case summary. Every row includes a full case summary. No attorney or researcher needs to dig through PDFs again.
Dashboard Screenshots
Four pages from the live public dashboard: complaint trends by region, searchable case decisions, decision year filter, and the decision summary with referee breakdown.
Why This Matters
All source data is publicly available. The value is in making it accessible, searchable, and connected across 25 years
Attorneys, researchers, journalists, and advocates can now find cases by name or respondent in seconds instead of searching year by year through PDFs
The 2025 data shows a 54.9% decrease in complaints against state agencies, the lowest count in the full dataset, a trend not visible without a longitudinal view
Referee level decision data is now comparable across the full dataset for the first time
Dashboard is fully public and free, designed as a civic resource, not a commercial product
Data Analysis Dashboards · Financial Reporting · Government Data Systems
Additional portfolio projects are being added including running race analysis dashboards, financial reporting systems built during my state government career, and data visualization work. For a full discussion of my capabilities and past work, connect on LinkedIn or reach out directly.
Power BITableauSQLR ProgrammingMS AccessExcel / VBAFinancial DashboardsFederal Reporting
Runner · Data Analyst · Co-founder, Run 169 Towns Society
I’m a Connecticut runner and data professional with more than 500 races to my name, all 169 Connecticut towns completed, and a 300 plus day running streak.
My background includes accounting, financial reporting, grants management, data analysis, dashboard development, and public sector fiscal operations. I hold a Master of Science in Accounting and Data Analytics from the University of New Haven with a 3.95 GPA.
This site is where my running, data, dashboard, and storytelling work come together.
I co-founded the Run 169 Towns Society in 2012, a community of nearly 6,000 runners working to cover all 169 Connecticut towns on foot. I've completed all 169 myself and I'm working through a second round. I film races with a GoPro, analyze results data, and write about what the numbers reveal about the sport.
Each year on March 5th, our community coordinates an effort to cover all 169 CT towns in a single day. The 14th annual event in 2025 was tracked in real time via a Power BI dashboard, with members running, walking, and driving between towns across the state.
Supervise the DOH accounting unit covering Accounts Receivable, Accounts Payable, Loans, and Facilities. Manage federal grants and HUD/FEMA reimbursements, prepare GAAP and federal financial reports, develop Access databases and Power BI financial dashboards, and administer fiscal aspects of grants for compliance.
Supervising Accountant
State of Connecticut, Department of Housing
September 2022 – February 2026
Supervised the DOH accounting unit covering Accounts Receivable, Accounts Payable, Loans, and Facilities. Managed federal grants and HUD/FEMA reimbursements, prepared GAAP and federal financial reports, developed Access databases and Power BI financial dashboards, and administered fiscal aspects of grants for compliance.
Associate Accountant / Accountant
State of Connecticut, Department of Housing
December 2017 – September 2022
Performed HUD drawdowns, managed federal grants and FEMA reimbursements, created financial dashboards, prepared GAAP reporting, and reviewed nonprofit audits for compliance. Managed budgets over $200 million for SANDY and NDR programs, designed accounting systems, prepared GAAP and federal financial reports, and monitored grant compliance.
Fiscal Administrative Assistant
State of Connecticut, Department of Economic and Community Development
April 2013 – December 2017
Managed loan services for a portfolio of nearly $900 million, processed accounts payable in CORE-CT, prepared GAAP and federal reports, and provided data analysis to support management decision-making.
Eligibility Service Worker
State of Connecticut, Department of Social Services
May 2012 – April 2013
Planned and conducted interviews to evaluate applicants for grant services and public assistance. Served as a liaison between local, state, and federal agencies to coordinate client eligibility determinations. Provided clear communication about state public assistance programs to clients, social service agencies, attorneys, and the public. Prepared detailed summaries and represented the agency in fair hearings. Processed client and provider payments efficiently.
Database Architect / Developer
All in One Reports LLC (Founded)
February 2010 – May 2012
Founded and owned All in One Reports LLC, managing overall business administration, sales, marketing, and customer relationships. Developed cost accounting systems for the convenience store and gas station marketplace. Oversaw software and database development including accounting software, Microsoft Access databases, and website design. Created Excel reports with advanced data visualization, VB code, and macros to meet client needs.
State of Connecticut, Department of Children and Families
February 2004 – February 2010
Supervised the Fiscal Analyst Unit overseeing a $700 million annual budget. Managed the DCF Board and Care Account with budgets exceeding $200 million, administered grants, developed financial management systems and Access databases, and prepared state and federal compliance reports.
Co-founder & Technology Lead (Volunteer)
Run 169 Towns Society
March 2012 – Present
Built and manage the public website, member database, and Power BI reporting for a community of nearly 6,000 runners. Design interactive dashboards and maps, maintain Connecticut's most comprehensive race calendar, and administer the Facebook community.
Education
Master of Science in Accounting and Data Analytics (STEM)
University of New Haven
GPA 3.95
BS, Business Administration
Charter Oak State College
AS, Business Administration
Middlesex Community College
Google Data Analytics Certificate
Google / Coursera
R Programming Certificate
Google / Coursera
Key Skills
Power BITableauExcel ExpertAccess ExpertSQLDAXR ProgrammingVBA / MacrosData AnalyticsGrants ManagementFederal ReportingFinancial DashboardsBudget AnalysisGAAP ReportingHUD DrawdownsLoan ServicingWeb Development
Awards
Aiello Inspiration Team, 2015Eversource Hartford Marathon — for work with Run 169 Towns Society and as a guide for disabled athletes through Achilles International.
Power of Running Award, 2016Fleet Feet Stores & Mizuno — for inspiring others through running.
West Hartford Police Citizen AwardWest Hartford Police Department.
Manager of the YearCumberland Farms.
Personal Records
1 Mile 5:32
5K 19:40
4 Mile 27:31
5 Mile 34:22
8K 37:07
10K 44:31
Half Marathon 1:40:39
Marathon 3:54:21
Disclaimer
This is my personal website and is not affiliated with, sponsored by, or endorsed by any current or former employer. Any consulting, dashboard, data analysis, or website work is performed on my own personal time and does not involve employer resources, confidential information, or matters connected to my official duties.
Distance 10 miRole VideographerCamera GoProField Size 20,088Location Washington, DC
I want to be clear upfront — I was not racing the 2026 Cherry Blossom 10 Mile. I was there as a videographer, filming the entire course with my GoPro as an unofficial resource for the race director and the running community. My finish time of 1:48:14 reflects a camera-in-hand effort, not a race effort. That said, I still crossed the line, and the data analyst in me couldn't resist pulling the full results and breaking down the field.
The Course Video
Here's the full course footage I captured at the 2026 Cherry Blossom 10 Mile. This video was filmed while running the course with a GoPro — it gives runners a real feel for the layout, landmarks, and conditions on race day.
My Result in Context
Finishing in 1:48:14, I placed 14,440th overall out of 20,088 finishers, putting me in the top 71.8% of the field. Among men aged 40–49, I placed 1,297th out of 1,559. The median male finish time was 1:29:31 and the overall median was around 1:36 — so I was running about 12 minutes off the male median, which tracks with where I am in my training cycle.
20,088
Total Finishers
56%
Female Finishers
1:48:14
My Finish Time
1:29:31
Median Male Time
1:42:08
Median Female Time
32
Median Finisher Age
Finish Time Distribution — All 20,088 Finishers
Number of finishers by 5-minute finish time buckets. My finish of 1:48:14 is marked in red.
Gender Split
11,256 women (56%), 8,767 men (44%)
Finishers by Age Group
20-29 was the largest group with 7,367 runners
Average Finish Time by Age Group
Finish times in minutes. Younger runners under 20 were fastest on average; performance slows gradually with age.
Top 5 Men
Overall top male finishers
Place
Name
Age
Time
1
Mohammed El Youssfi
28
0:46:17
2
Graydon Morris
24
0:46:18
3
Kieran Tuntivate
29
0:46:32
4
Cole Sprout
24
0:46:35
5
Aidan Reed
28
0:46:38
Top 5 Women
Overall top female finishers
Place
Name
Age
Time
1
Asayech Ayichew
21
0:50:37
2
Joy Cheptoyek
23
0:50:41
3
Emma Grace Hurley
28
0:50:42
4
Weini Kelati
29
0:50:46
5
Karissa Schweizer
29
0:50:55
Men vs. Women by Detailed Age Group
The crossover from female majority to male majority happens precisely at the 50–54 bracket — separated by a single finisher.
Gender & Age Trends: The Data Keeps Telling the Same Story
I've been doing demographic analysis across large and small road races for years, and the 2026 Cherry Blossom is completely consistent with everything I've seen before. Women have become the majority participant demographic in distance running, and this data makes that undeniable.
Their dominance is strongest in the 20s and 30s age brackets, which also happen to be the highest volume groups. The 25 to 29 cohort alone shows women outnumbering men by nearly 1,000 runners (2,974 F vs. 1,991 M). But here is where it gets interesting. The flip happens at exactly 50 to 54, where 476 women and 475 men finished, separated by a single runner. That is not a coincidence. That is a demographic boundary.
Older male runners who came of age during the running boom of the 1970s and 80s entered the sport when it was largely male-dominated, and many of them never stopped. That generation built a lifelong identity around running during that era, and that dedication absolutely shows in the data. Meanwhile, the surge in women's participation over the last 20 to 30 years has fundamentally reshaped who shows up at the start line, and that shift is most visible in the millennial and Gen Z age groups.
The growth of this sport is being driven by women, and the data across every race I have analyzed backs that up.
Key Takeaways
The 2026 Cherry Blossom had one of its largest fields ever at over 20,000 finishers, with women making up 56% of all finishers. The 20–29 age group dominated participation with 7,367 runners. Average finish times held steady between the 20–29 and 30–39 groups before climbing in the 50+ categories. The fastest age group on average was the Under 20 cohort at 1:32:28.
For my own result — 1:48:14, overall place 14,440 — this was a filming run, not a race effort. But the data gives a useful baseline to measure against in future editions when I line up to actually race.
Data source: 2026 Cherry Blossom 10 Mile official results (20,088 finishers). Analysis by Adam Osmond.
Race Report + Analysis April 2026 · Alexandria, VA
PNC Alexandria 5K & Half Marathon 2026: Full Race Analysis
5K: 1,697 finishersHalf Marathon: 3,630 finishersStart: 7:00 AM · Alexandria, VAAnalysis by Adam Osmond
Start Fairfax & Wythe StFinish N Union & Oronoco StFestival Oronoco Bay ParkKids Dash 10:30 AM
1,697
2026 5K Finishers
1,455
2025 5K Finishers
+16.6%
5K Growth
3,630
2026 Half Finishers
3,037
2025 Half Finishers
+19.5%
Half Growth
Total Finishers: 2025 vs. 2026
Both races grew significantly year over year — the half marathon added nearly 600 finishers.
2026 5K Gender Split
1,697 finishers · 10 non-binary
2026 Half Gender Split
3,630 finishers · 9 non-binary
2026 5K Finish Time Distribution (Net Time)
Bucketed in 2-minute intervals. Peak concentration between 28–34 minutes.
2026 Half Marathon Finish Time Distribution (Net Time)
Bucketed in 5-minute intervals. Peak concentration between 1:45–2:00.
2026 5K: Finishers by Age Group & Gender
Women dominate the 20-49 age brackets. Men lead only in the 70+ group.
2026 Half Marathon: Finishers by Age Group & Gender
Men lead in the 30-39 bracket and 60+. Women lead in 20-29 and Under 20.
2026 5K Top 3 by Gender (Net Time)
Gender
Name
Age
Net Time
M 1st
Johnny Rogers
27
15:44
M 2nd
Cody Hodgins
36
16:05
M 3rd
Nico Diffenbach
14
16:35
F 1st
Carmen Garson-Shumway
29
18:06
F 2nd
Tatum Peskin
24
18:11
F 3rd
Eliana Ornelas
25
18:30
2026 Half Top 3 by Gender (Net Time)
Gender
Name
Age
Net Time
M 1st
Alex Hillyard
24
1:07:45
M 2nd
Michael Conway
33
1:08:10
M 3rd
Scott Doescher
32
1:11:35
F 1st
Halle Gill
26
1:21:03
F 2nd
Rachel Cassidy
38
1:21:48
F 3rd
Katherine Taylor
23
1:24:40
Race Video
Course Details
Both the 5K and half marathon start at 7:00 AM at the intersection of Fairfax Street and Wythe Street, across from Oronoco Bay Park in Alexandria, VA. The finish line is on N Union Street at the intersection with Oronoco Street, with the post-race festival held at Oronoco Bay Park, 100 Madison Street.
The Kids Dash starts at 10:30 AM at the intersection of King and Union Streets, with the finish also at Oronoco Bay Park.
Aid Stations
The half marathon has six aid stations along the course. The 5K has one dedicated aid station at mile 1.8 on Green Street. All aid stations include portable toilets and medical support. Aid station locations for the half marathon are at mile 2 (S Washington Bridge Overpass), mile 4 (GW Memorial Parkway and Tulane Drive, water and Gatorade), mile 6 (GW Parkway and Wellington Road), mile 8 (water and Gatorade), mile 9.5 (water and Gatorade), and mile 12 (S Washington Bridge Overpass).
Pace Teams
The half marathon offers 13 pace teams with two leaders each, targeting the following overall times: 1:30, 1:35, 1:40, 1:45, 1:50, 1:55, 2:00, 2:10, 2:20, 2:30, 2:45, 3:00, and 3:15. Pace leaders wear special singlets and carry signs showing their target pace and overall finish time.
Course Cutoff
The half marathon cutoff is based on a 15-minute-per-mile pace, roughly equivalent to a 3:30 finish. Runners who fall behind that pace may be asked to move to the public sidewalks to complete the distance.
Key Takeaways
Both the 5K and half marathon saw strong year-over-year growth in 2026 — the 5K grew 16.6% from 1,455 to 1,697 finishers, and the half marathon grew 19.5% from 3,037 to 3,630. That's meaningful growth for both events and reflects a healthy, expanding race.
In the 5K, women made up 60.5% of finishers, consistent with the broader national trend of women dominating shorter road races. Non-binary runners represented 10 finishers in the 5K and 9 in the half marathon — a small but notable presence as race organizations continue to expand their gender categories.
The half marathon was nearly even between men (51%) and women (48.8%), with the 30–39 age group being the largest for men and the 20–29 group being the largest for women. Median finish times were 1:55:22 for men and 2:12:39 for women in the half, and 31:15 for men and 36:11 for women in the 5K.
About the Race
The PNC Alexandria Half Marathon and 5K is produced by Run Pacers and held annually in Alexandria, Virginia. For registration, course maps, and race-day information visit alexandriahalf.com.
About the Timing Company
Race timing for the PNC Alexandria events is provided by ARE Event Productions, based in Albany, NY. ARE is an endurance event timing, technology, and full-scale production company that has provided services to over 2,000 races across the U.S. and Canada, including national championships, the Nike Women's Series, and the NYC Marathon.
As a vertically integrated company with its own software developers and event producers, ARE delivers timing with live tracking, logistics, entertainment, and equipment. They author their own timing, registration, and event management software, giving them the in-house technical capability to deliver a first-class race experience from start to finish.
Data source: PNC Alexandria 5K and Half Marathon official results, 2025 and 2026. Course information from Run Pacers. Timing by ARE Event Productions. Analysis by Adam Osmond.
Let's Connect
Available for freelance work in Power BI, data analysis, and financial reporting. Most project work and consultations are scheduled after regular business hours and on weekends.
Get in Touch
Whether you have a Power BI project, need data analysis, or want to talk about running race data, I'd love to hear from you. Fill out the form and I'll get back to you as soon as possible.
Power BI Dashboards · Tableau Dashboard. MS Access. MS Excel. Data Analysis · Financial Reporting · Race Data Analytics · SQL & DAX Development · Financial Systems
2,432 finishersRole: 11:00/mile Pacer · Beast Pacing15 years of race historyAnalysis by Adam Osmond
Distance 10KFinishers 2,432States 28Teams 99Running Clubs 33Location Harbor Point, Baltimore
This year I stepped out of my racing shoes and into a pacer vest. I volunteered with Beast Pacing to lead the 11:00/mile pace group at the 2026 Sole of the City 10K, Baltimore's marquee springtime 10K held at Harbor Point. While I wasn't racing, the data analyst in me couldn't put down the results file, and 15 years of participation history tells a remarkable story about this race and the Baltimore running community.
If you are interested in running with a pace group at a race near you, or becoming a pacer yourself, visit beastpacing.com. More information about the race is at soleofthecity10k.com.
2,432
Total Finishers
56.6%
Female Finishers
43.1%
Male Finishers
28
States Represented
38.7
Avg Age (Years)
82 / 10
Oldest / Youngest
Full Race Coverage: GoPro
Filmed the entire 2026 Sole of the City 10K from start to finish while pacing the 11:00/mile group with Beast Pacing.
Race Participation: 2012–2026
Total finishers across all 15 editions. The 2020 bar reflects the virtual-only COVID edition (689 runners). Every year since 2021 has shown growth.
The COVID Effect and the Road Back
The Sole of the City 10K climbed from 2,235 runners in 2012 to a peak of 3,984 in 2018, a 78% increase in just six years. COVID-19 brought it to 689 virtual participants in 2020, an 83% decline from the prior in-person peak. Since returning in 2021 with 1,668 runners, the race has grown every single year, reaching 2,432 in 2026 — the strongest showing since 2019 and six consecutive years of post-COVID growth.
Gender Split
1,377 women (56.6%) · 1,049 men (43.1%) · 6 non-binary (0.2%)
Maryland vs. Out of State
Maryland accounts for 92.1% of all finishers (2,239 of 2,432)
Finish Time Distribution (Chip Time)
Bucketed in 2-minute intervals. Peak concentration between 54 minutes and 1:10.
Finishers by Age Group & Gender
The 30–39 age group dominates for both men and women with a combined total of 914 finishers.
Top 10 States by Finisher Count
Maryland dominates with 2,239 runners. Pennsylvania, Virginia, and DC round out the top four.
Top 3 Men (Chip Time)
Place
Name
Age
City
Time
1
Clark Otte
27
Columbia, MD
30:51
2
Nicolas Crouzier
41
Gaithersburg, MD
31:14
3
Perry Bennett
24
Baltimore, MD
31:14
Top 3 Women (Chip Time)
Place
Name
Age
City
Time
1
Ainsley Pressl
26
Baltimore, MD
36:13
2
Marissa Dailey
22
Phoenix, MD
36:37
3
Laura Doody
36
Baltimore, MD
36:58
Top 10 Teams by Finisher Count
Wedding Day 10K led all teams with 62 finishers across 99 total teams.
Running Clubs Represented (33)
Identified running clubs, run crews, and track clubs in the 2026 field.
Baltimore Road Runners ClubBe More Run CollectiveBirdland Track ClubBlack Men RunBlack Running Organization (BRO)Cove RunnersD17 Running TeamDYE for RunningFalls Road RacingGo VTS RunGreatest Running Team in AmericaHarbor East Run ClubHarford County Running ClubHealth is Wealth Run ClubLabRatsRunClubLululemon Run CrewMoguls RunNeighborhood Runners Race TeamPre-Race PoopsPulse Run ClubRealtors on the RunRowdie Running ClubRun Now, Beer LaterRunnas301Runners4JusticeRunnersRunSRTT Anne Arundel CountyThe Bad Girls ClubTrack Hawks Run ClubUA Velociti EliteUnleashed Run ClubWe Got the RunsWorst Pace Scenario
A Note From Your Race Filmmaker and Pacer
This year I stepped out of my racing shoes and into a pacer vest. I volunteered with Beast Pacing to lead the 11:00/mile pace group, keeping runners on track, on pace, and having fun along the way. Pacing is one of the most rewarding things you can do in the running community. There is something special about helping dozens of runners achieve their goal time.
I also filmed the entire race from start to finish with my GoPro. If you are interested in joining a pace group at a race near you, or even becoming a pacer yourself, Beast Pacing operates at races all across the country and is always looking for passionate runners to join their team.
Data source: 2026 Sole of the City 10K official results (2,432 finishers). Historical data: 2012–2026 race records. Analysis by Adam Osmond. Pacing by Beast Pacing. Race info at soleofthecity10k.com.
Hogsback Half Marathon: 25 Years of Data (2001–2025)
24 race editions5,193 total finishers2001–2025Analysis by Adam Osmond
Distance Half MarathonLocation Goodwin Dam, Colebrook CTCourse Record (M) 1:07:48Course Record (F) 1:19:44Women Majority Since 2013Benefits Running for Rescues
The Hogsback Half Marathon is one of my favorite half marathons in Connecticut. Held along the Farmington River on rural country roads through Riverton, Pleasant Valley, Hartland, and Colebrook, it is a fast USATF-certified course with a 100-foot net elevation decrease that draws runners from across New England every September. Since 2015, I have been part of this race every single year, whether racing it myself, pacing a group, coordinating pacers, or volunteering.
Over the years the race has changed timing companies, which meant results were scattered across multiple platforms with no single place to view them. I gathered all 25 years of results into one dataset and built the Power BI dashboard linked below so runners can search their own history in one place. The 2026 results will be added after the September race.
2021 Race Video
GoPro footage from the 2021 Hogsback Half Marathon — the race's return after COVID.
Power BI Dashboard — All Results 2001–2025
I compiled results from multiple timing companies spanning 25 years into a single dataset and built an interactive Power BI dashboard. Runners can search their own results across all editions in one place. Updated with 2026 results after the September race. Open the Dashboard →
5,193
Total Finishers (2001–2025)
24
Race Editions
439
Peak Field (2015)
2013
Women Became Majority
1:07:48
Male Course Record (2025)
1:19:44
Female Course Record (2006)
Total Finishers by Year (2001–2025)
From 34 finishers in 2001 to a peak of 439 in 2015 (highlighted). A major jump occurred in 2006 when the field grew from 66 to 161. Post-COVID the race has stabilized in the 224–309 range. No race was held in 2020.
🔒 2020: No Race — The Hogsback Half Marathon was cancelled due to the COVID-19 pandemic. The race returned in 2021 with 270 finishers.
Finishers by Gender Over Time
Men dominated the field through the first decade. In 2009 the race was exactly 50/50. Women became the majority in 2013 at 60% and have held it every year since. Non-binary runners first appeared in results in 2022.
Female Percentage of Field by Year
The dashed line marks 50%. Women first crossed and stayed above 50% in 2013 (60.1%) and peaked at 67.4% in 2018. The share has settled around 58–62% in recent years.
When Women Became the Majority
For the first decade of Hogsback, men dominated the field. In 2009 the race landed at an exact 50/50 split (40 men, 40 women). But 2013 was the turning point: women reached 60% of finishers and have never dropped below 57% since. By 2018 women made up 67% of the field, the highest proportion in race history. In 2025 women were approximately 59% of finishers, a trend that has held consistently for over a decade.
Median Finish Time by Year — Overall, Male & Female
Median finish times in h:mm:ss. The overall median has climbed from roughly 1:49 in the early years to around 2:16–2:18 in recent editions, reflecting a broader and more recreational field over time. Male and female medians track together, with women consistently about 18–22 minutes slower.
Winning Times Each Year — Male & Female
Course records: Mario Vazquez 1:07:48 (2025 — male); Shannon Hovey 1:19:44 (2006 — female, still standing after nearly two decades). Vazquez has won six consecutive times from 2021–2025, improving his time every single year.
Finishers by Age Group Over Time
The 35–54 core has always dominated, but notice how the 45–54 cohort has grown relative to 35–44 in recent years. The 50+ segment has expanded substantially, consistent with national trends in half marathon participation.
Median Finisher Age by Year
The median age has climbed from 42 in 2001 to 44–49 in recent years, reflecting an aging running population nationally.
2025 Age Group Breakdown
Distribution of all 250 finishers across age groups in the most recent edition.
Top 10 States by Finisher Count (All-Time)
Connecticut runners make up approximately 83% of all finishers across 25 years. Massachusetts is the largest out-of-state contingent, followed by New York.
All-Time Male Course Records
Year
Name
Time
2025
Mario Vazquez 🏆 CR
1:07:48
2024
Mario Vazquez
1:08:55
2023
Mario Vazquez
1:08:53
2022
Mario Vazquez
1:09:50
2021
Mario Vazquez
1:11:13
All-Time Female Course Records
Year
Name
Time
2006
Shannon Hovey 🏆 CR
1:19:44
2017
Brianna Demers
1:24:03
2013
Amanda Kourtz
1:23:47
2023
Larissa Giordano
1:30:10
2024
Larissa Giordano
1:33:25
Full Winners History (2001–2025)
Fastest male and female in each edition. Mario Vazquez has won six times (2017, 2021–2025). Larissa Giordano won three consecutive years (2022–2024).
Fast USATF certified course with a 100-foot net elevation decrease through the towns of Riverton, Pleasant Valley, Hartland, and Colebrook along the Farmington River. 6 aid stations, custom finisher medals, electronic bib tag timing, and awards 3 deep in 5-year age groups for male, female, and non-binary. All proceeds benefit Running for Rescues, a 501(c)(3) dedicated to saving shelter animals. Packet pickup at 7:00 a.m. No race day registration.
Data source: Hogsback Half Marathon official results 2001–2025 (5,193 finishers across 24 editions). Results gathered from multiple timing companies and consolidated by Adam Osmond. No race held in 2020 (COVID-19). Analysis and Power BI dashboard by Adam Osmond. Race information at RunSignUp.
Government Data Analysis 2001 to 2025 · Connecticut
25 Years of CT CHRO Complaints: What the 2025 Data Reveals
The Connecticut Commission on Human Rights and Opportunities (CHRO) has published complaint data going back to FY 2001. This analysis covers 25 years of filings across five regions and four complaint types, with a close look at what shifted most sharply in FY 2025.
2,494
FY 2025 Total Complaints
+2.3% vs 2024
855
West Central, All Time High
+12.4% vs 2024
87
State Agency Complaints, All Time Low
‑54.9% vs 2024
295
Public Accommodations Complaints
+21.9% vs 2024
Total CHRO Complaints Filed, FY 2001 to 2025
Annual filings peaked in 2016 at 2,616, fell to their lowest level of 2,018 in 2022, and have risen in each of the last three years.
Overview
Over 25 fiscal years, the CHRO has processed an average of roughly 2,280 complaints per year. The volume peaked in FY 2016 at 2,616 and hit its lowest level of 2,018 in FY 2022. Since then, filings have risen in each of the three subsequent years, reaching 2,494 in FY 2025, the highest since 2019. The headline number is relatively stable, but beneath it the composition of complaints has shifted meaningfully.
Complaints by Region, FY 2024 vs FY 2025
West Central surged to an all time high. Capitol and Eastern declined sharply. Southwest and the Housing Discrimination Unit rose moderately.
Regional Trends: A Sharply Divided Map
The most striking regional story in 2025 is West Central, which at 855 complaints set an all time record for any single region in any year in the dataset. That is up from 761 in 2024 and represents 34.3% of all statewide filings, the highest regional share in 25 years. West Central has now risen for three consecutive years.
Southwest also posted a meaningful increase, climbing from 485 to 530 (+9.3%), reversing two years of decline. The Housing Discrimination Unit rose from 163 to 181 (+11.0%).
In contrast, Capitol and Eastern both dropped roughly 10%. Capitol fell from 581 to 524 and Eastern from 449 to 404, Eastern's lowest count since FY 2022. The regional divergence in 2025 is the sharpest in recent memory, with three offices rising while two fall.
Complaints by Type, FY 2001 to 2025
Employment dominates at roughly 80% of all filings. Public accommodations complaints have surged since 2019 and hit a near record high in 2025.
Complaint Types: Employment Holds Steady, Public Accommodations Surge
Employment complaints remained essentially flat at 2,004 in 2025 (down just 12 from 2,016 in 2024), continuing to make up roughly 80% of all filings. Housing complaints rose 13.5% to 185.
The most notable type level trend is the continued rise of public accommodations complaints. At 295 in 2025, this category is up 21.9% from 2024 and is the second highest annual total on record, trailing only the spike year of 2019 (367). Three consecutive years of growth (241, then 242, then 295) suggest this is a sustained shift rather than a one year anomaly. Public accommodations complaints now represent 11.8% of all filings, more than double their historical share from 2001 to 2014.
Complaints Filed Against State Agencies, FY 2001 to 2025
FY 2025 produced 87 complaints against state agencies, the fewest in the entire 25 year dataset and less than half of the FY 2024 total.
State Agency Complaints: An All Time Low
Complaints filed against state agencies fell from 193 in FY 2024 to 87 in FY 2025, a decrease of 54.9%. This is the lowest count in the 25 year dataset. The prior record low was 115 in FY 2001, the first year of available data.
The figure is notable because it moves in the opposite direction from overall complaint volumes. Total filings rose 2.3% in 2025 and employment complaints held essentially flat, yet complaints specifically targeting state agencies fell by more than half in a single year.
The data alone does not identify a cause. Possible contributing factors include changes in how complaints are categorized at intake, variations in filing behavior among state employees, shifts in outreach or awareness, or other procedural factors. What the numbers show is that the 2025 figure is the lowest in the full 25 year record and represents a statistically notable departure from the prior year.
Selected Case Closure Types, FY 2024 vs FY 2025
Release of jurisdiction, no reasonable cause findings, and withdrawals all rose sharply. Public hearing closures dropped by more than half.
How Cases Are Being Resolved
Total case closures rose from 2,218 in FY 2024 to 2,330 in FY 2025. The composition of those closures shifted in notable ways.
Release of jurisdiction, where the CHRO transfers a case to another forum, typically federal court, jumped 25.4% to 533, the highest level since 2019. Withdrawals with settlement rose 6.6% to 794, remaining near their peak levels. No reasonable cause findings increased 20.9% to 388, suggesting the agency is resolving a larger share of cases against complainants than in recent years.
On the other end, public hearing closures fell 50.7% from 71 to just 35, the fewest since before 2016. Pre-determination conciliations also declined, dropping from 41 to 31. Fewer cases are reaching the hearing stage, and fewer are being resolved through early settlement negotiations. Reasonable cause draft issuances increased from 74 to 91 (+22.9%), indicating that more cases are being advanced to a probable cause determination even as fewer ultimately proceed to public hearings.
Key Takeaways
West Central set an all time regional record at 855 complaints, the highest single region total in 25 years.
State agency complaints reached an all time low of 87, a decrease of 54.9% from the prior year, while total filings rose 2.3%.
Public accommodations complaints continue a multi year rise, reaching 295, the second highest ever, with three consecutive years of growth.
Release of jurisdiction surged to 533, suggesting more complainants are opting for or being directed to federal forums.
Public hearing closures fell by more than half, continuing a longer term decline in cases reaching full adjudication.
Overall filings have risen for three consecutive years after the 2022 low and remain below the 2015 to 2019 peak period.
Data source: Connecticut Commission on Human Rights and Opportunities (CHRO), Number of Complaints Per Fiscal Year, FY 2001 to 2025. Analysis by Adam Osmond. Fiscal years run July 1 through June 30.