Updates

A post-pipeline audit identified 589 YMCA-affiliated EINs that had been written to Harbor Commons tables during the April 25 ingest. All 589 originated from a Schedule R fan-out of YMCA-related entities and were corpus-tagged ymca — they should never have reached sailing-designated tables. 726,043 rows were removed across 20 tables.

Separately, Operation 1 — a systematic IRS TEOS refresh covering the full sailing corpus — completed with 7,390 filings processed and 0 errors. Post-purge, post-refresh count: 1,560 nonprofit profiles connected to sailing and blue-space organizations (1,015 Form 990 · 645 Form 990-EZ · 1,349 Form 990-PF, deduplicated).

A fan-out guard and lane-routing test have been hardened to prevent recurrence. All purged rows were backed up locally before deletion.

1,149 Schedule R related-org rows are now fully named and typed by relationship tier. All 828 unique EINs disclosed across IRS Schedule R filings have been loaded into the sailing ecosystem with stability tiers: schedule_r_stable (3+ years), schedule_r_recurring (2 years), and schedule_r_disclosed (1 year). 748 net-new organizations were added, bringing the ecosystem to over 3,100 entries.

Cleveland Foundry (EIN 30-0609496, Cleveland OH) has been ingested with 6 years of 990 filings (TY2016–TY2024). Community sailing and rowing nonprofit on the Cuyahoga River, formerly Cleveland Scholastic Rowing.

Fixed a long-standing display bug where 469 990-EZ filers showed as “Unknown Organization” across the site, in compare, and in Google search results. The root cause was a missing org_name fallback in the EZ data fetch path; all affected pages now resolve to the correct organization name.

IRS filing ingest for 726 of the 748 newly-added ecosystem organizations completed — 6,110 filings spanning TY2017–TY2025 in 8h 24m. Post-ingest audit found that all 726 EINs originated from a Schedule R fan-out of YMCA-related entities, which had been incorrectly included in the sailing relationship graph. No net-new sailing profile pages were added; all 726 EINs are corpus-tagged as ymca and excluded from the public site. A fan-out guard has been hardened to prevent recurrence. Sailing-only corpus: 1,484 organizations (1,003 Form 990 · 620 Form 990-EZ · 1,258 Form 990-PF, deduplicated).

View newly added organizations →

21 Rhode Island yacht clubs and sailing organizations have been added to Harbor Commons following a full XML ingest and flat-walk extraction of IRS e-file records (TY2018–2025). The cluster spans Newport Harbor, Narragansett Bay, and coastal RI — from Watch Hill to Tiverton.

Three additional RI sailing-ecosystem organizations have been confirmed and added: Limerock Foundation (Newport — historic preservation arm of Ida Lewis YC, est. 2022), IYRS School of Technology & Trades (Newport — yacht restoration and marine trades education, $5.4M revenue), and Herreshoff Marine Museum (Bristol — sailing heritage museum, $1.7M revenue). All three are now in the ecosystem and discoverable in Harbor Commons.

Analysis of RI Community Foundation (RICF, $1.35B assets) grant schedules confirmed active 2022–2023 grantmaking to sailing-adjacent orgs: Conanicut Island Sailing Foundation ($10K general operating), IYRS ($15.1K → $25.5K), and Herreshoff Marine Museum ($12.6K → $18.3K). Newport YC Endowment Fund (~$205K) transferred to RICF in two tranches (TY2022 + TY2023) and continues as a restricted fund within RICF’s portfolio.

View newly added organizations →

Organization pages now display complete multi-year filing history rather than a single year. Revenue trends, net asset trajectories, and filing timelines are now computed from the full depth of available filings per organization — typically TY2015 through TY2024 where machine-readable returns exist.

Similar Organizations cards now resolve names correctly in all cases. Previously, some peer suggestions appeared without a name when the most recent filing row lacked the field; the summary builder now back-fills from any available filing year.

The “Send a Signal” link on organization pages now pre-fills the EIN and organization name into the correction form, so you don't need to re-enter what you were just looking at.

Officer compensation tables now include a contextual note when an individual shows $0 direct compensation but non-zero “Other Comp.” This pattern typically means the person is compensated through a related entity, with Other Comp reflecting benefits, retirement contributions, or deferred compensation from that relationship. A tooltip on the column header provides the same context on hover.

The deduplication step that selects the most recent version of each filing (original vs. amended) was keyed on filing year alone instead of the intended composite of EIN and filing year. This caused the summary builder to retain only one filing per year across the entire corpus rather than one per organization per year. The key has been corrected. Revenue, expense, and asset figures on organization pages and in the compare tool now reflect the full filing history for each organization.

199 sailing, yacht club, and boating nonprofit organizations have been added to the Harbor Commons corpus following a keyword scan of IRS annual e-file index files (2019–2025) covering 4.2 million filings. Each organization was verified against ProPublica Nonprofit Explorer.

New additions include yacht clubs, community sailing programs, racing associations, collegiate sailing bodies, and boating-adjacent nonprofits across 40+ states. Organizations filed under 501(c)(3), 501(c)(4), 501(c)(6), or 501(c)(7) status.

View the full list of newly added organizations →

Structured data extraction now covers additional sections across all three supported form types (Form 990, 990-EZ, and 990-PF). New fields include expanded balance sheet line items, officer compensation detail, revenue and expense breakdowns, and qualifying distribution schedules.

Revenue and net assets figures have been backfilled for eligible organizations where machine-readable filings are available. Organizations that previously appeared in the corpus without financial figures may now display totals.

Coverage now spans TY2015–TY2023 for most e-filers, with depth varying by form type and filing history.

Period labels in revenue tables changed from Pre-COVID / COVID-era / Post-COVID to Before 2020 / 2020–2021 / 2022+. The "Read trends in context" note on club pages now treats 2020–2021 as an example of a major discontinuity rather than naming it as the organizing frame.

Club pages now surface similar organizations automatically, scored on organization type, revenue scale, state/region, and filing type. Each suggestion explains why it scored as a match and links directly into the compare tool with the anchor club pre-loaded.

The Compare tool now anchors to the first selected club. Search results and suggestions rank toward stronger peers. Peer sets generate a shareable URL so a comparison can be sent to a board member or fellow officer without rebuilding it. A Geography toggle scores peers on structural fit alone, across any state.

The organizations browse gained an org type filter and Type column. State pages gained revenue-band and org-type breakdowns with a direct link into compare. The chart palette is now colorblind-accessible. Country clubs carry a dedicated type label and a guardrail note when mixed into a peer set.

The homepage now leads with three role vignettes (Commodore/Board, GM/Treasurer, Sailing Coach/Volunteer parent) before the stat block. The Corpus Revenue stat was removed and replaced with a Data current as of card.

A Coverage by filing year expandable section shows the percentage of indexed organizations with at least one filing for each of the last six tax years, with a plain-English note on IRS processing lag.

Updated site guidance to better frame the intended use: start with your own organization, then benchmark against genuinely comparable peers by geography, scale, filing type, and history. Coverage and methodology language tightened across the trust layer.

Added 990 and 990-EZ filings across sailing foundations, regional clubs, and national sailing bodies. Coverage now extends back to 2015 where available.

Some organizations appear in search but display no financial fields because they file 990-N or on paper — an IRS input-format constraint on what is machine-readable in TEOS.

Harbor Commons launched with 2,100+ sailing-related tax-exempt organizations in the corpus; 1,200+ with machine-readable e-file returns (Form 990 or 990-EZ) and displayable financial data. Coverage spans TY2016–TY2023 for most organizations, with depth varying by filing history and TEOS availability.