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.
Choose a sample project, move the sliders, and watch the estimated savings update instantly.
Even small improvements in a recurring accounting process can free up meaningful time every month for review, analysis, and better decision making.
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.
Interactive dashboards for financial, operational, and public data.
Clean visual stories for trends, performance, and insights.
Automated reports, tracking systems, databases, and forms.
Accounting reports, grant tracking, spending analysis, and more.
Race trends, maps, participation data, and runner insights.
Simple, professional visuals that make data easier to understand.
Practical AI workflows using ChatGPT, Claude, structured prompts, API integrations, and automated reporting tools to save time and improve decisions.
Interactive web apps built with React and JavaScript — public-facing tools, calculators, and custom utilities.
Scripted pipelines and automated workflows that eliminate repetitive tasks and keep your data current.
I help people and organizations turn public data, financial data, race data, and internal records into clear tools, dashboards, and reports.
Dashboards, reports, and tracking tools that make sales, expenses, operations, and performance easier to review.
Public data dashboards, grant reporting support, impact reporting, and visuals that help tell a clear story.
Race result analysis, participation trends, runner maps, historical comparisons, and public facing race data tools.
Financial reporting, operational tracking, spending analysis, and dashboards designed for transparency and decision making.
Excel, Access, Power BI, and automation support for people who need better systems but do not have time to build them.
Data storytelling for public interest projects where clear visuals can help people understand the issue faster.
Dashboard and data analysis projects combining public data, financial reporting, running data analytics, and community storytelling.
Power BI dashboard used by nearly 6,000 members to track progress across all 169 Connecticut towns. Automated, interactive, real-time.
30 years of race data analysis with participant trends, finish times, demographics, and interactive visual storytelling.
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.
Projects can be hourly, fixed price, or volunteer based for selected nonprofit and public interest projects.
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.
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.
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!
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.
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.
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.
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!!
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.
Learn More About MeI can help organize your data, explain the numbers, and build dashboards, reports, automation tools, and AI powered workflows that people can actually use.
Get In TouchI'd love to help with your next project.
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.
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.
Read more20,088 finishers analyzed — finish time distributions, gender splits, age group trends, and pace breakdowns.
Read moreA 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.
Read moreEvery 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.
Read moreFull 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.
Read moreI 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.
Read more25 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.
Read moreA 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.
Read moreFrom 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.
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.
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.
"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."
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.
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.
"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."
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 |
|---|
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.
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 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 full ranking from fastest to slowest, using the average winning time at each major from 2010 to 2026:
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.
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 |
|---|
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.
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:
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.
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 |
|---|
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.
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 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 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 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.
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.
| 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 |
| 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 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.
| 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 |
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.
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.
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.
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.
5,919 members, 99,927 towns submitted, hometown distribution map, member directory search, real-time royalty ticker.
Personalized member view with interactive CT map showing completed towns by year, completion progress donut, county breakdown, and race history chart.
Members select their name and instantly see all upcoming races in towns they still need — eliminating hours of manual searching across multiple websites.
Real-time leaderboard showing current-year town submissions and total miles by member, with county completion percentages and number-of-races-per-town map.
Tracks all members who have completed all 169 towns, sorted by finish order, with title designations (Queen, King, Majesty), dates, and multi-round tracking.
Connecticut-wide race calendar integrated into the dashboard, filterable by town, date, and distance — the most comprehensive CT race calendar available.
Five pages from the live dashboard used daily by the Run 169 Towns Society membership.
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.
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.
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.
Bar charts show completion percentage by county in real time, creating friendly competition between regions and helping identify areas that still need coverage.
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.
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.
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.
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.
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.
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.
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.
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.
Four pages from the live public dashboard: complaint trends by region, searchable case decisions, decision year filter, and the decision summary with referee breakdown.
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.
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.
Find the Run 169 Towns Society at run169towns.org.
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.
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.
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.
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.
| 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 |
| 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 |
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.
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.
This post is a placeholder for your full Run 169 Day write-up.
Add your description of the logistics here.
How did it unfold? Where did things go smoothly, where were there surprises?
Stats, participation figures, dashboard highlights, and anything data-driven worth sharing.
| 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 |
| 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 |
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.
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).
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.
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.
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.
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.
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.
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.
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.
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.
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.
| 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 |
| 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 |
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.
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.
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 →
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.
| 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 |
| 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 |
| Year | Male Winner | Time | Female Winner | Time |
|---|---|---|---|---|
| 2001 | Brian Fullem | 1:17:28 | Gale Case | 1:43:00 |
| 2002 | Tom Casey | 1:17:14 | Kate Paddon | 1:21:55 |
| 2003 | Anthony Longabard | 1:18:54 | Cindy Pomeroy | 1:25:07 |
| 2004 | Joshua Adams | 1:20:38 | Cindy Pomeroy | 1:28:41 |
| 2005 | Joshua Adams | 1:20:24 | Amanda Hill | 1:28:53 |
| 2006 | Chris Toepfer | 1:12:40 | Shannon Hovey 🏆 CR | 1:19:44 |
| 2007 | Stephen Herrera | 1:12:06 | Maureen Terwilliger | 1:24:32 |
| 2008 | Jeffrey McDermott | 1:19:56 | Tracy Dickey | 1:35:23 |
| 2009 | Ray Houle | 1:19:04 | Amanda Hill | 1:29:18 |
| 2010 | Joshua Adams | 1:22:40 | Jen Ward | 1:41:57 |
| 2011 | Marc Robaczynski | 1:12:39 | Margaret Alexson | 1:39:36 |
| 2012 | Brian Nelson | 1:14:00 | Janelle Ralph | 1:33:57 |
| 2013 | James McKirdy | 1:14:04 | Amanda Kourtz | 1:23:47 |
| 2014 | Jon Lindenauer | 1:14:45 | Addie DiFrancesco | 1:30:27 |
| 2015 | Patrick Byrne | 1:26:01 | Michelle Gosselin | 1:30:36 |
| 2016 | Peter Hornak | 1:34:45 | Sherri Odell | 1:32:34 |
| 2017 | Mario Vazquez 🏆 | 1:15:26 | Brianna Demers | 1:24:03 |
| 2018 | Morgan Kennedy | 1:12:11 | Nicole Semanchik | 1:33:40 |
| 2019 | Jonathon Toro | 1:18:05 | Amanda Morgan | 1:27:05 |
| 2020 | No Race — COVID-19 Pandemic | |||
| 2021 | Mario Vazquez 🏆 | 1:11:13 | Brittany Telke | 1:27:38 |
| 2022 | Mario Vazquez 🏆 | 1:09:50 | Larissa Giordano 🏆 | 1:32:21 |
| 2023 | Mario Vazquez 🏆 | 1:08:53 | Larissa Giordano 🏆 | 1:30:10 |
| 2024 | Mario Vazquez 🏆 | 1:08:55 | Larissa Giordano 🏆 | 1:33:25 |
| 2025 | Mario Vazquez 🏆 CR | 1:07:48 | Olivia Provance | 1:29:39 |
Date: September 26, 2026 • Start: 8:30 a.m. • Location: Goodwin Dam, Durst Road, Colebrook, CT 06021
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.
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.
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.
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.
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 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.
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.
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.